- see footer for list info -<
I just got the exact same error, but for something different:
<cfif isnumeric(call.categoryID)>
AND
CategoryID = <cfqueryparam
cfsqltype="CF_SQL_NUMERIC" value="#call.categoryID#">
</cfif>
Restarted CF, problem went away.
Allan Cliff wrote:
- 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 -<
_______________________________________________
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 -<
