A couple of questions.
Does your datasource in cf have insert rights?
Can you get details for the database error?
What datatypes are these three fields?
Have you tried to hardcode the insert (rather than run it from the form
vars)?
On 1/3/07, Bruce Sorge <[EMAIL PROTECTED]> wrote:
>
> I am pulling my hair out with this stupid INSERT query. Here is the query:
>
> <cfquery datasource="#Application.dsn#">
> INSERT INTO Clients
> (Client_Name, Login, Password)
> VALUES ('#Form.Client_Name#', '#Form.Login#', '#Form.Password#')
> </cfquery>
>
> Very basic. I am getting the message Syntax Error in INSERT query. Here is
> what the query looks like after the post:
>
> INSERT INTO Clients (Client_Name, Login, Password) VALUES ('Ford', 'Ford',
> 'password')
>
> I opened the database and copied and pasted the query and it worked like a
> champ. I know the query is formed correctly, I mean it is a basic INSERT!!
> I
> have tons of these all over the app that are working fine.
> It is an MS Access DB (Clients wish, not mine).
>
> Thanks,
>
> Bruce
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265597
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
