>- see footer for list info -<
Yeah that worked for me too previously but now on shared
hosting so its not possible.
Really weird.
I suppose I'll wait a few days, see if the host reboots sometime and change
back the code to see if it runs ok. Not a very technical fix.
----------------------------------------
From: Jim <[EMAIL PROTECTED]>
Sent: 09 August 2006 09:53
To: Coldfusion Development <[email protected]>
Subject: Re: [CF-Dev] Unsupported data conversion
>- see footer for list info -<
I just got the exact same error, but for something different:
AND
CategoryID =
cfsqltype="CF_SQL_NUMERIC" value="#call.categoryID#">
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.
>
>
> SELECT *
> FROM Requests
> WHERE email =
>
>
> The only fix is to remove the (not ideal)
>
>
> SELECT *
> FROM Requests
> WHERE email = '#Trim(attributes.email)#'
>
>
> 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 -<
_______________________________________________
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 -<
