|-----Original Message----- |From: Darren Adams [mailto:Darren_Adams@SystemsUnion.com] |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:bheerssen@visualbridge.tv] |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:dylan@bromby.com] |> 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:Darren_Adams@SystemsUnion.com] |> 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 |> |