RE: I'm sure this worked earlier

Message- From: Joshua Meekhof [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:54 To: CF-Talk Subject: Re: I'm sure this worked earlier Darren, I have a few questions / comments. 1) Why do you convert the query, which is conceptually a structure of arrays into an array

RE: I'm sure this worked earlier

; 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

RE: I'm sure this worked earlier

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

RE: I'm sure this worked earlier

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

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 =

RE: I'm sure this worked earlier

Your insert is probably breaking a constraint in the table, or the Access datasource is open in design view (close Access, use 'fix' option in ODBC admin.). Probably :-) ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: I'm sure this worked earlier

Check your last query. You have an extra ) where you list your values This '#oldnews[i].expdate#'), should be this '#oldnews[i].expdate#', cfquery name=newnews datasource=cosmos1 dbtype=ODBC insert into pressoffice (headline)!---,subtitle,body,date,expdate),country,live,author--- Values

RE: I'm sure this worked earlier

they are all text/memo apart from the date fields. The live fields are boolean field types. -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:18 To: CF-Talk Subject: RE: I'm sure this worked earlier can you provide the datatypes of the fields

Re: I'm sure this worked earlier

Darren, I have a few questions / comments. 1) Why do you convert the query, which is conceptually a structure of arrays into an array of structures? 2) Why don't you insert the records into the data base in one step? e.g. cfquery insert into pressoffice

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

RE: I'm sure this worked earlier

Access hasnt been open for about 10 mins. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:25 To: CF-Talk Subject: RE: I'm sure this worked earlier Your insert is probably breaking a constraint in the table, or the Access datasource is open

RE: I'm sure this worked earlier

Yes you are correct but it is commented out so surely this would not make a difference ? the code is commented out so that it just deals with the headline. -Original Message- From: Art Broussard [mailto:[EMAIL PROTECTED]] Sent: 01 May 2001 16:32 To: CF-Talk Subject: Re: I'm sure

Re: I'm sure this worked earlier

On 5/1/01, Darren Adams penned: 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