heh. this exact question was posted on the Adobe forums. apparently,
'password' is a reserved word in Access.
i couldn't find it on the reserved word list, but the original poster
said after enclosing the word Password in square brackets, the query
worked.
INSERT INTO clients (Client_Name, Login, [Password]) ...
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:265596
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
