cfqueryparam unicode characters

[doramon]

I am storing Unicode characters in sqlserver.

If I use :

SELECT * table values WHERE a=N"#val1#" it works fine.

However if I use:

SELECT * table values WHERE a=<cfqueryparam value=N"#val1#"
cfsqltype="cf_sql_varchar">

I get the following error:

Invalid token '"' found on line 16 at column 51.
The CFML compiler was processing:

a cfqueryparam tag beginning on line 16, column 31.
a cfqueryparam tag beginning on line 16, column 31.

Can someone please help?

[PaulH]

lose the unicode hinting (N') and read [url]http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=F9553D86-20ED-7DEE-2A913AFD8651643F[/url].

[doramon]

Great! Now I don't need 1 set of code for MS Access and another for SQL Server. Thanks Paul for pointing this out.

[PaulH]

well if you do that you're probably missing out on some of the goodies that sql
server has to offer that access doesn't (or does in a limited way). stored
procedures, triggers, identities, full-text indexing, etc. all can really power
up db interactions.