RE: Oracle SQL Question

2003-12-04 Thread d.a.collie
16:44 To: CF-Talk Subject: RE: Oracle SQL Question You have to loop and do multiple cfqueries. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:15 AM To: CF-Talk Subject: RE: Oracle SQL Question Stace wrote: >> If I've

RE: Oracle SQL Question

2003-12-04 Thread Hays, Duncan
You have to loop and do multiple cfqueries. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 11:15 AM To: CF-Talk Subject: RE: Oracle SQL Question Stace wrote: >> If I've got a pre-insert trigger that puts in the row pri

RE: Oracle SQL Question

2003-12-04 Thread d.a.collie
Stace wrote: >> If I've got a pre-insert trigger that puts in the row primary key on insert, can I return that >> ID in the same query? (not using a stored proc and is not an option) - like in MSSQL u >> can do multi-sql statements in one cfquery. Don't think so Oracle only handles one SQL ex

RE: Oracle SQL Question

2003-12-04 Thread Hays, Duncan
Hays -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:35 AM To: CF-Talk Subject: Oracle SQL Question If I've got a pre-insert trigger that puts in the row primary key on insert, can I return that ID in the same query? (not using a store

Oracle SQL Question

2003-12-04 Thread Stacy Young
If I've got a pre-insert trigger that puts in the row primary key on insert, can I return that ID in the same query? (not using a stored proc and is not an option) - like in MSSQL u can do multi-sql statements in one cfquery. Thanks! Stace AVIS IMPORTANT: --- Les inf