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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
