how do you get the MySQL mysql_insert_id(); from within Rev?

Trevor DeVore lists at mangomultimedia.com
Fri May 26 14:46:17 EDT 2006


On May 26, 2006, at 11:33 AM, Josh Mellicker wrote:

> Hmmm... I tried both of these, and got a nice round zero as a  
> returned value in both cases, same as my earlier tests with  
> mysql_insert_id()...
>
> My first instinct is that I need to do the INSERT using some other  
> command than revExecuteSQL? Because revExecuteSQL does not provide  
> for a "Record set"

Are you inserting into a table with an autoincrement primary key?   
revExecuteSQL is the correct handler to call for the insert.  You  
won't get a record set when inserting data.

-- 
Trevor DeVore
Blue Mango Learning Systems - www.bluemangolearning.com
trevor at bluemangolearning.com





More information about the use-livecode mailing list