what does your query look like? I usually get that error when I try to do an insert of text characters into a INT type field in the db.
tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 8:52 AM To: CF-Talk Subject: RE: <cfquery syntax I'm getting a little further but now I get this error. What does this mean? Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type text to data type nvarchar, table 'prefs.dbo.tblprofiles', column 'strSelect'. Use the CONVERT function to run this query. On Thu, 4 Sep 2003 08:46:33 -0400, Dave Watts wrote: > > I checked the database and there seems to be something > > wrong with the <cfqueryparam> because when I check the > > fields using SQL Query Analyzer there are question marks > > "?" in the fields which I think is an error trying to > > update the fields? > > If you look at debug output for an SQL statement that's using > CFQUERYPARAM, you'll see question marks in the SQL, which are used as > placeholders. You may want to remove the quotes around the > CFQUERYPARAM tag in your case. > > > Do I need the <cfqueryparam>? > > It's not absolutely necessary, but it is a really good idea to use it > whenever possible. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
