MS-SQL DateTime field --> MySQL int(10)unsigned HOW!?!?
I'm trying to import data from an MS-SQL database into MySQL and have run up to a problem resulting in :
[TCX][MyODBC]You have an error in your SQL syntax near 'User(usergroupid, username, password, email, styleid, adminemail, showemail, inv' at line 1
I'm inserting data from an MS-SQL2000 DateTime (length 8) field into a MySQL int(10)unsigned field (apparently according to the GUI I'm using for the MySQL database).
My question is - how do I insert this? I'm currently using :
<cfquery name="qPutMySQLUser" datasource="vBulletin">
INSERT INTO User(usergroupid, username, password, email, styleid, adminemail, showemail, invisible, joindate, cookieuser, lastvisit, receivepm, emailonpm, pmpopup)
VALUES (2, <cfif qGetMSSQL.screenname EQ "">'#qGetMSSQL.firstname# #qGetMSSQL.surname#'<cfelse>'#qGetMSSQL.screenname#'</cfif>, '#qGetMSSQL.Password#', '#qGetMSSQL.Email_Address#', 1, 0, 0, #qGetMSSQL.DateJoined#, 1, #qGetMSSQL.DateJoined#, 1, 1, 1)
I was wondering if I need to format qGetMSSQL.DateJoined in any way?