Can we see the code?
--------------------------------------------------------------
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--------------------------------------------------------------
> -----Original Message-----
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 4: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
