>- see footer for list info -< I am adding a column to an SQL table, when I press save the column saves and then my queries related to that table go tits up.
<CFQUERY NAME="CheckEmail" DATASOURCE="#request.maindsn#"> SELECT * FROM Requests WHERE email = <CFQUERYPARAM VALUE="#Trim(attributes.email)#" CFSQLTYPE="CF_SQL_VARCHAR"> </CFQUERY> The only fix is to remove the <CFQUERYPARAM> (not ideal) <CFQUERY NAME="CheckEmail" DATASOURCE="#request.maindsn#"> SELECT * FROM Requests WHERE email = '#Trim(attributes.email)#' </CFQUERY> Why would the adding of a "new" column cause existing fully working queries to stop working and why "Unsupported data conversion" ?? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Unsupported data conversion. Anyone got any ideas or run into anything similar? Using CFMX 7, SQL 2000 on a Windows box. Allan _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
