mySQL CF5 - auto increment??

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

Re: mySQL CF5 - auto increment??

Hi Flash: This is a shot in the dark, but when I set up some tables using phpMyAdmin, I set a field to auto_increment and a default value of 0, phpMyAdmin created the table, but without the default value. When I add records from a form, it increments correctly. Perhaps the default value