What a surprise, NOT!!
I have a QUERY in a QUERY that works fine in MS-Access 97, but bombs in SQL
SERVER 2000.
Here is the query:
<cfquery name="GetKeyUser" datasource="lsar_dev">
select fullname, role
from dbo.tbl_users
where role = (select 'key_' & role as keyrole
from dbo.tbl_users
where username = '#session.username#')
</cfquery>
The error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data
type. Operator equals boolean AND, type equals nvarchar.
SQL CHANGED MY DATA TYPES FROM TEXT IN ACCESS TO NVARCHAR IN SQL. WHAT
DATATYPE SHOULD THE FIELD "ROLE" BE?
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
