This is so frustrating -
If I comment out the table column names, everything works fine! I
just want to be able to name the columns in the query...
<cfquery name="perm_write_content" datasource="#Application.dsn#"
dbtype="ODBC">
INSERT INTO content(guid,
type_id,
client_id,
user_id,
logdate,
birthdate,
expirationdate)
VALUES('#temp.guid#',
#temp.content_type_id#,
#temp.client_id#,
#getuserid.user_id#,
#Now()#,
#ParseDateTime(temp.birth_date)#,
#ParseDateTime(temp.expiration_date)#);
</cfquery>
FAILS WITH ODBC ERROR 37000
BUT
<cfquery name="perm_write_content" datasource="#Application.dsn#"
dbtype="ODBC">
INSERT INTO content
VALUES('#temp.guid#',
#temp.content_type_id#,
#temp.client_id#,
#getuserid.user_id#,
#Now()#,
#ParseDateTime(temp.birth_date)#,
#ParseDateTime(temp.expiration_date)#);
</cfquery>
WORKS NO PROBLEM.
And I am here to tell ya that I've looked at my spellings of the
column names enough now that I promise there are no typos in the
1st example.
Ahh, the strange and wonderful world of Microsoft products.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
