Monday, January 22, 2001 - Brett wrote:
> to see what the columns look like. I've heard that myodbc does a pretty
> good job of transferring the data, but you never know what could have happened.
I've found that when transferring from Access to MySQL you tend to
lose "Autonumber" fields. You need to manually set these to the MySQL
autoincrement type (can't remember the exact descriptor, sorry.. can
find it if required). Some of the problems could be due to having
records with blank autonumber fields... or maybe I'm just way off
target :)
I'd recommend getting hold of something like Calistra (a windows MySQL
admin tool) if you havn't already.
------------------------------------
Broadband Communications Ltd.
+44 (0)115 924 7150
http://www.broadband.co.uk/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
