[ic] SQL query

[Michael <suppressed>]

Hi folks.

Is it possable to have more than one sql statement in a [query] tag?
I have a table I am inserting data into where the key is defined as 
auto_increment.  After that insert, I wanted to use the MySql 
last_insert_id() function to grab the abovementioned key value for
use elsewhere.  The MySql last_insert_id() fcn is valid on a per connection
basis, and I am assuming (danger!) that the [query ...] ... [/query] 
container pair opens the connection, does its thing, then closes the 
connection.  (I can think of a few other places where multiple SQL statements
per connection can be useful to me as well.

I can also work around this too... 

Box is Linux 2.4.20, IC ver 4.9.5, DBD.pm is v 11.11, DBD::mysql is v1.6,
MySql v3.23.36, IC template is ground-up mine.

Thanks

Michael.
 
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users