Erika,
Hmmm. I assume that your development and production databases are not one
and the same? If so, I think that you might have a problem with your data
types being differently defined. I would look at the data structure for the
two different versions to see if all the types are the same. I would also
follow Jann's suggestion (below): <CFOUTPUT> your SQL text to see if it's
OK. I'd then go a step further and try manually entering that SQL text
through SQL Plus or some other SQL command line utility. If you have a
problem there, you KNOW that it has something to do with your database
structure, and not your CF.
If this doesn't work, we'll need that "incredibly annoying SQL syntax error"
posted.
Hope this helps,
Matthieu
> -----Original Message-----
> From: Jann VanOver [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 11, 2001 4:55 PM
> To: CF-Talk
> Subject: RE: SQL Syntax Error
>
>
> So, what was the "incredibly annoying SQL syntax error" ??
> Did it give you
> any clues? Did you try <CFOUTPUT>ing the text of the query
> before executing
> to make sure it looks right?
>
> -----Original Message-----
> From: Erika Foster [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 03, 2000 7:42 PM
> To: CF-Talk
> Subject: SQL Syntax Error
>
>
> Hi there,
>
> I've got this whole application running perfecto on my
> development machine
> running CF 4.5.1. I upload it to the web server running 4.01 and I'm
> getting this incredibly annoying SQL syntax error on the
> action page. Can
> someone spot what the problem might be??? Much appreciated,
>
> <cfquery name="addrow" datasource="Personnel">
> INSERT INTO Tshirt (orderid, style, color, quantity, size)
> VALUES (#thisorderid#, #thisstyle#, '#thiscolor#', #thisquantity#,
> '#thissize#')
> </cfquery>
>
> Erika Foster
> engineering-environmental Management
> Applications Developer
> (505) 866-1654
> [EMAIL PROTECTED]
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
