is illusory query tree structure list mysql unparalleled query, any depth?


i'm pondering answer no, nonetheless i'd adore it anybody any understanding yield tree structure any abyss sql (mysql), nonetheless unparalleled query



more specifically, given tree structured list (id, data, data, parent_id), quarrel table, illusory all descendants (child/grandchild/etc), matter ancestors (parent/grandparent/etc) but meaningful distant down adult go, controlling unparalleled query?



or controlling kind recursion require, where i keep querying deeper until there new results?



specifically, i'm controlling flush rails, nonetheless i'm guessing that's unequivocally relevant.



Comments

Post a Comment

Popular posts from this blog

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?

Image
hopefully settlement value thousand lines formula since i don't wish have frame down asp.net code, html, javascript, css yield an instance (but i'll supply i on ask someone doesn't contend "oh, i've seen before! try this...") [actually, i post formula css - bottom question]. here apportionment form page being displayed firefox: the blue boxes surrogate stylings <label> add-on orange lines surrogate border styles <div> tags (so i where extend break). <label> 's styled float: left <div 's right. addition, heir controls <div> also float:left definitely line adult tip <div> (since there taller controls multiline textboxes down below). the radio buttons generated an asp control, wrapped <span> - also floated left given heir <div> . here same apportionment shade rendered ie7: there few teenager digest differences, nonetheless large that's pulling me crazy additional white space beside <input> con...
Read more

grails record upload problems

i'm perplexing heed record upload formula grails website, i'm controlling problems. i'm controlling same formula found . here code: <g:form action="upload" method="post" enctype="multipart/form-data"> <input type="file" name="myfile" /> <input type="submit" value="upload" /> </g:form> and def upload = { def f = request.getfile('myfile') if(!f.empty) { flash.message = 'success' } else { flash.message = 'file can't empty' } } i'm receiving following blunder during runtime: message: signature method: org.mortbay.jetty.request.getfile() convenient justification types: (java.lang.string) values: {"myfile"} caused by: groovy.lang.missingmethodexception: signature method: org.mortbay.jetty.request.getfile() convenient justification types: (java.lang.string) values: {"myfile"} ...
Read more

how i emanate permitted url asp.net mvc?

how i beget permitted urls within asp.net mvc framework? example, we've got url looks this: http://site/catalogue/browsebystylelevel/1 the 1 id inspect turn (higher case) browse, nonetheless i'l reformat url same proceed does it. for example, twin urls take same place: edit: permitted biased url referred slug .
Read more