I believe tt is vomitting on the single quote inside the text you're trying
to send into the database...
|-----Original Message-----
|From: Darren Adams [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, May 02, 2001 7: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
