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

[Josh Mellicker]

get revDataFromQuery("","",dbID,"SELECT LAST_INSERT_ID()")

is now working, I rewrote my connection function and all is well!  
Thanks!

I think my connection thing somehow generated multiple database  
connections  :o

Thanks!

On May 26, 2006, at 11:46 AM, Trevor DeVore wrote:

> 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
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution