Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^2: Pulling back paths from a database to populate form field

by osunderdog (Deacon)
on Apr 01, 2007 at 07:47 UTC ( #607680=note: print w/replies, xml ) Need Help??


in reply to Re: Pulling back paths from a database to populate form field
in thread Pulling back paths from a database to populate form field

I concure with the prescribed approach. Some databases, Oracle in particular, support this self referential table with an SQL syntax "CONNECT BY". You might check your favorite MySQL forum to see if there's corresponding idiom.

A similar problem is mentioned here: database table advice Update: I guess it's related because it's from the same author!

This problem shows up a lot in Bill-of-materials type applications.

Hazah! I'm Employed!

  • Comment on Re^2: Pulling back paths from a database to populate form field

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://607680]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2020-11-28 23:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?