Re: [GENERAL] child/parent creation

2010-05-29 Thread Richard Broersma
On Sat, May 29, 2010 at 11:05 AM, Dennis Gearon wrote: > Can the whole three level, 4 member hierarchy be created in one, prepared > statement(to avoid SQL injection), transaction without shuttling any > information back and forth between the database and the calling script? Not yet, but possi

Re: [GENERAL] child/parent creation

2010-05-29 Thread Justin Graf
On 5/29/2010 1:05 PM, Dennis Gearon wrote: > Is it possible to create a complex schema object in one transaction, I'm not sure i understand what you mean by schema object > using prepared statements to protect(somewaht) against SQL injection? > In short no Prepared statements do not pro

[GENERAL] child/parent creation

2010-05-29 Thread Dennis Gearon
Is it possible to create a complex schema object in one transaction, using prepared statements to protect(somewaht) against SQL injection? Example: A 'family tree object' (having obvious relationships) consisting of: Table grandparent Table parent table childA table childB If I have all the inf