Re: Recursive SQL query?

2008-04-16 Thread Peter J. Holzer
On 2008-04-15 18:55:25 -0400, Colin Wetherbee wrote: Scott Webster Wood wrote: You shouldn't really need to go recursing through a data tree to come up with all the parts of a single fact. Well that is unless you are wanting to inherit data from linked elements further up a link list without

Re: Recursive SQL query?

2008-04-16 Thread Nathan Haigh
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I haven't given this too much thought with your situation, but could be something to look into. Have you looked into using the nested set's model for hierarchies? It allows you to easily pull out a parent with all it's children in 1 or 2 queries -

Re: Recursive SQL query?

2008-04-16 Thread Scott Webster Wood
- Original Message From: Colin Wetherbee [EMAIL PROTECTED] My goal was as a time/work saving measure (from the administration perspective) to allow 'children' elements to have blank entries where the values would get inherited down from parents. That makes sense. I haven't delved

Re: Recursive SQL query? - Ah hah!

2008-04-16 Thread Scott Webster Wood
Someone in the local LUG group put me onto a possible way to accomplish it - not sure if what I took from their message was what they were getting at but it would seem to at least begin to address a possible way to do the inheritance! included response: --- Now there's

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
If the singular is The syntax of the command is The command has two syntaxes The command has two syntacies (like incidies) On Wed, Apr 16, 2008 at 9:24 AM, Scott Webster Wood [EMAIL PROTECTED] wrote: - Original Message From: Colin Wetherbee [EMAIL PROTECTED] My goal was as a

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
Bloody keyboard Anyway, If the singular is The syntax of the command is Then the plural possibilites are The command has two syntaxes The command has two syntacies (like incidies) The command has two forms of syntax The command has two syntactic forms The command has two

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
http://encarta.msn.com/encnet/features/dictionary/DictionaryResults.aspx?refid=1861717794 On Wed, Apr 16, 2008 at 1:54 PM, Matthew Persico [EMAIL PROTECTED] wrote: Bloody keyboard Anyway, If the singular is The syntax of the command is Then the plural possibilites are The

Re: Recursive SQL query?

2008-04-16 Thread Matthew Persico
http://en.wiktionary.org/wiki/syntax http://encarta.msn.com/encnet/features/dictionary/DictionaryResults.aspx?refid=1861717794 On Wed, Apr 16, 2008 at 2:03 PM, Matthew Persico [EMAIL PROTECTED] wrote: http://encarta.msn.com/encnet/features/dictionary/DictionaryResults.aspx?refid=1861717794

Re: Log DBI query and values with placeholders

2008-04-16 Thread aspiritus
On Apr 15, 3:10 pm, [EMAIL PROTECTED] (Robert Roggenbuck) wrote: $sth-{Statement} returns the prepared statement. Using this as a base You can get the used values in a HashRef by $boundParams = $sth-{ParamValues} after an execute. I did not used it before ... but it should work. Regards

Re: Multiple selectrow_array calls with statement handle error

2008-04-16 Thread Douglas Wilson
On Tue, Apr 15, 2008 at 2:30 PM, Tim Bunce [EMAIL PROTECTED] wrote: Try this (completely untested) patch to the DBI: --- Driver.xst (revision 10993) +++ Driver.xst (working copy) @@ -157,7 +157,11 @@ AV *row_av; PPCODE: if (SvROK(ST(1))) { - sth = ST(1); +

Re: Multiple selectrow_array calls with statement handle error

2008-04-16 Thread Douglas Wilson
On Tue, Apr 15, 2008 at 2:30 PM, Tim Bunce [EMAIL PROTECTED] wrote: Try this (completely untested) patch to the DBI: like I said...it works for me, but if that's the fix, then you'll want to do selectall_arrayref also (same problem). -Doug