Looks like you have some "single quote" issues.
-----Original Message-----
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 6:11 AM
To: CF-Talk
Subject: RE: I'm sure this worked earlier
Here you go:
I have now removed the excluded text so that it is just getting the headline
and sticking it in the headline in pressoffice on cosmos1.
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression ''Quatre nouvelles langues d'Europe pour SunSystems')'.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (29:2) to (29:60).
Date/Time: 05/02/01 12:09:35
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt)
Remote Address: 129.153.207.20
Template: E:\Inetpub\publicsite\menutest\pressoffice\convertnews.cfm
-----Original Message-----
From: Bruce Heerssen [mailto:[EMAIL PROTECTED]]
Sent: 01 May 2001 17:05
To: CF-Talk
Subject: RE: I'm sure this worked earlier
It would also help if you can post the error message.
-Bruce
> -----Original Message-----
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 10:18 AM
> To: CF-Talk
> Subject: RE: I'm sure this worked earlier
>
>
> can you provide the datatypes of the fields?
>
> -----Original Message-----
> From: Darren Adams [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 8:04 AM
> To: CF-Talk
> Subject: I'm sure this worked earlier
>
>
> Hello Folks,
>
> Can any of you eagle eyed people spot why I am getting a "ODBC Error Code
=
> 37000 (Syntax error or access violation)" error when I run this.
> I had it working earlier and managed ot output all the oldnews.headline
into
> my database but, I added a few more fields to the sql and now it had
> buggered it all up.
> This is bugging me, any help will be very appreciated.
> Cheers
> Daz
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
