Not knowing what types the fields or variables are, or what the setup is like,
its a little hard to comment...
However, one thing that springs to mind is does it require a username and
password in the CFQUERY?
David Cummins
Erika Foster wrote:
>
> 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
