MySQL5... someone mentioned to append: ?MultipleQuery=True (or something
like that) to my connection string in the DB... but it didn't work.


-----Original Message-----
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 09, 2006 9:26 AM
To: CF-Talk
Subject: RE: Get last inserted ID

What version of MySQL was this?
 
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
 

-----Original Message-----
From: Baz [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 09, 2006 1:00 AM
To: CF-Talk
Subject: RE: Get last inserted ID

Thanks for the info guys - all this makes me really sad... I remember
researching this a long, long time ago and was recommended using
cftransaction - so I did - for EVERY insert for all my apps. Now it seems I
have major changes ahead of me... 

If I don't post for a while you'll know why...

Baz

P.S. 

Bobby, the query returned this error: 

"You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '; Select
LAST_INSERT_ID() as newid' at line 2"

This is the exact test query I used:

<cfquery NAME='myqry' datasource="mydsn">
Insert into customer (customerdate,customeruserid) 
Values (<cfqueryparam value="#now()#"
cfsqltype="CF_SQL_TIMESTAMP">,<cfqueryparam value="1"
cfsqltype="CF_SQL_INTEGER">); Select LAST_INSERT_ID() as newid; 
</cfquery>

My DB is MySQL 5


-----Original Message-----
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 09, 2006 12:45 AM
To: CF-Talk
Subject: Re: Get last inserted ID

It happens because Oracle and most other DBs do not default to
serializable transactions; Oracle, for example, defaults to read
committed, which means that your transaction can read other committed
data even if it happened during your transaction (although in Oracle
this level does provide statement-level consistency). MySql defaults
to repeatable read as far as I could tell from a quick google.

Info on Oracle:
http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html

and MySQL
http://dev.mysql.com/doc/refman/4.1/en/innodb-transaction-isolation.html


On 1/9/06, Baz <[EMAIL PROTECTED]> wrote:
> What does cftransaction do then?
>
> The livedocs say that it "can be used to group multiple queries that use
> CFQUERY into one business event". How do other events occur in between
"one"
> event?
>
--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/







~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228825
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to