CFMX 7 & MS Access

[doramon]

When executing the following query in In CFMX 7

<cfquery name="registerUser" datasource="test">
INSERT INTO test1 (Name, password) VALUES ('aaa','aaa')
</cfquery>

(i) if datasource is MS Access, there is no problem
(ii) if datasource is MSAccess with unicode, a "Syntax error in INSERT INTO
statement" occurs.

Did anybody face the same problem?

[Ken Ford - *TMM* & PVII]

Name is a reserved word:

[url]http://support.microsoft.com/default.aspx?scid=KB;en-us;286335[/url]

Try this:

<cfquery name="registerUser" datasource="test">
INSERT INTO test1 ([Name], password) VALUES ('aaa','aaa')
</cfquery>


--
Ken Ford
PVII Support Team
[url]http://www.projectseven.com[/url]
Team Macromedia Volunteer - Dreamweaver
Certified Dreamweaver MX 2004 Developer


"doramon" <webforumsuser@macromedia.com> wrote in message news:d0v0id$3db$1@forums.macromedia.com...

> When executing the following query in In CFMX 7
>
> <cfquery name="registerUser" datasource="test">
> INSERT INTO test1 (Name, password) VALUES ('aaa','aaa')
> </cfquery>
>
> (i) if datasource is MS Access, there is no problem
> (ii) if datasource is MSAccess with unicode, a "Syntax error in INSERT INTO
> statement" occurs.
>
> Did anybody face the same problem?
>

[doramon]

Thanks for your reply.

I made a typing mistake. Sorry. The code should read

<cfquery name="registerUser" datasource="test">
INSERT INTO test1 (name1, password) VALUES ('aaa','aaa')
</cfquery>

This code works if "test" is a MS Access datasource.
However, if "test" is a MS Access with unicode datasource, the syntax error
results.