Anyone move table information from MS Sql 2000 to MySQL 5 ? The table types
in MySQL are InnoDB, not MyISAM which is what we normally use. Someone tried
MS DTS services and gets errors on the blob data columns. They gave it to me
to use CF to write loops/queries to extract and insert the information but
I'm getting an error on insert which I don't understand because I'm not
familiar with the difference between myisam and innodb.
Here is the error if it helps:
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ' '', '', '')' at
line 16
The error occurred in C:\ColdFusion8\wwwroot\tblobject.cfm: line 30
28 : '#dtcheckout#',
29 : '#strcheckoutpermissions#',
30 : '#strcheckoutname#')
31 : </cfquery>
32 :
Line 16: #intobjectstatusid#,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:240079
Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
