Okay, so I tried using val() both when values get added to the query and in
the query of query -- I currently have this code:
<cfquery name="rsnew" dbtype="query">
SELECT nick, message FROM history
WHERE msgid > #val(attributes.cleared)# AND
( nick = '' OR nick = '#trim(ucase(attributes.nick))#'
OR sender = '#trim(ucase(attributes.nick))#' )
</cfquery>
I also tried WHERE val(msgid) > blah... and the server didn't like that...
After getting to the point above, it worked on CF 5 and on MX it loaded and
then I got a message from the flash movie this page returns data to saying
that a script had caused it to run slow and asking me if I wanted to abort
it. So I fiddled with it a bit with the same results every time. Then I
restarted the MX server and now it no longer does this, but again produces
the invalid datatype comparison error with the val() in the query.
Error Executing Database Query.<br><b>Query Of Queries runtime
error.</b><br> Unsupported type comparison. The specific sequence of files
included or processed is: C:\CFusionMX\wwwroot\dev\talkontap\index.cfm
damn this is frustrating.
>> So I'm guessing that MX is creating the msgid column as a
>> varchar column
> and
>> it's complaining about "msgid > #attributes.cleared#" ...
>> So does anybody
>> know how to set the data type on a query column created
>> using querynew()
> in
>> MX?
> I've had success with this problem by putting putting
> Val() around the
> values to be "cast" as a number. The only thing to be
> careful about is that
> if you have a blank string (i.e., ""), Val() will convert
> the empty string
> to zero. That might not matter in your case, but a warning
> just in case.
> Regards,
> Dave.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~~~~~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> This list and all House of Fusion resources hosted by
> CFHosting.com. The place for dependable ColdFusion
> Hosting.
> Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
> ubscribe.cfm?user=633.558.4
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
tapestry api is opensource http://www.turnkey.to/tapi
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
