> Thank you all for your ideas. After speaking with [Justice] over on the IRC
> channel I
> removed the <cfqueryparam /> and found it ran smooth as silk. Seems that
> there was
> some form of datatype mismatch going on, after changing the cf_sql_type on the
> queryparam we've got it running at proper speed again!!
While you're doing that, you might want to make your lists with
CFQUERYPARAM too.
Where LogClass.Name In (
'org.thinkblue.TransferComplete',
'org.openobex.Error.ConnectionRefused',
'org.openobex.Error.Forbidden',
'org.openobex.Error.NotAuthorized',
'org.openobex.Error.ConnectionTimeout'
)
would be
Where LogClass.Name In (
<cfqueryparam ... list="yes"
value="org.thinkblue.TransferComplete,org.openobex.Error.ConnectionRefused,...">
)
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318171
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
