Hi,
I'm trying to get mySQL 4/myODBC working properly with CF5 on a Win2k
machine, but am having problems with auto_increment.
I've set up some tables using auto_increment for the ID field, and when I
insert a record using mySQLgui or the MSDOS mysql command line tool, it
increments correctly.
However, if I insert a record using an HTML or Flash form, posting to a CF
insert statement, the values get inserted in the correct fields, but the ID
doesnt increment, instead taking its default value of 0.
A simple statement would be as follows:
INSERT INTO myTable(fname,lname)
VALUES('fred','smith')
- I'm probably missing something obvious, so I'd be grateful if anyone can
shed any light on this and offer a solution (urgently, if possible)
- Cheers,
FlashG
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
