Thanks Joshua, that worked like a charm.
-----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:45 PM To: CF-Talk Subject: RE: Access to SQL discrepancy in transfer of data <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#') -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 1:37 PM To: CF-Talk Subject: Access to SQL discrepancy in transfer of data 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? ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
