My original query code below, which has been running for months with no
error, suddenly start throwing an unspecified database error today, plus
actually timed out once, and the server reset in the middle of the query
another time:
Select ... from ...
WHERE ml_id IN
(<cfqueryparam
value="#ValueList(getGROUP.ml_id)#"
cfsqltype="CF_SQL_INTEGER"
list="yes" />)
Since I was at lunch and the client got p*ssed (I have no life of my own
with this client), they got somebody else to look at the page. They
changed the code to:
WHERE ml_id IN
(<cfoutput query="getGROUP">
<cfif getGroup.CurrentRow NEQ 1>,</cfif>
#ml_id#
</cfoutput>)
....no error. No timeout. No server reset.
Specific query in question was returning approximately 5000 records -
basically a first name, last name, and an email address.
I don't get it. Shouldn't the cfqueryparam version perform
*better*?????? Ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312550
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
