If you are inserting into a text field make sure your value has single
quotes around it. 'retreat' instead of retreat
SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName,
LastUpdate) VALUES(HPRO-12-28-2000, 'retreat', {ts '2000-12-28 18:42:56'})"
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 6:50 PM
To: CF-Talk
Subject: This is weird
I am getting an ODBC error message. Below the message is saying that
'retreat' is a column name but it is not. It is the VALUE for the column
name CommunityEventName.
Any suggestions. I can't figure this out.
Sebastian
------------------------------
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'retreat' is not
permitted in this context. Only constants, expressions, or variables allowed
here. Column names are not permitted.
SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName,
LastUpdate) VALUES(HPRO-12-28-2000, retreat, {ts '2000-12-28 18:42:56'})"
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
