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
should not be set?
HTH
Cheers
David
On Saturday, August 3, 2002, at 01:18 PM, Gordon McGowan wrote:
> 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 <mysql-unsubscribe-
> [EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
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
