Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GnegDevelop
- Order by date
-
LAST_INSERT_ID() Method Question
I am using a Cold Fusion front end and I can't figure out how to use the LAST_INSERT_ID() method in my CF application. When I place the method within a <cfquery> I always get an invalid syntax error. <cfquery datasource="#request.main_dsn#" name="insertMem"> <!--- Insert...- GnegDevelop
- Thread
- Replies: 1
- Forum: MySQL
-
LAST_INSERT_ID() and Cold Fusion
I'm trying to use the LAST_INSERT_ID() function to return the last generated ID for a tuple but it won't work within a <cfquery> tag. Can the Last_Insert_id method be used in conjunction with Cold Fusion? I've put my code bellow. Thanks. <!---Query the DB and insert member information--->...- GnegDevelop
- Thread
- Replies: 0
- Forum: MySQL
-
LOCK TABLE with ColdFusion Front
I've gotten rid of the LOCK TABLES but when I try to run the LAST_INSERT_ID through a <cfquery> I get a SYNTAX error. Can I use the LAST_INSERT_ID function with cold fusion?- GnegDevelop
- Post #4
- Forum: MySQL
-
LOCK TABLE with ColdFusion Front
I am running MySQL in junction with Cold Fusion on a Windows 2000 platform. In order to create an enviroment that assures that an INSERT followed by a SELECT will return the last created ID, I used a LOCK TABLE statement but now the server always returns that table as locked. I tried to run an...- GnegDevelop
- Thread
- Replies: 3
- Forum: MySQL
