I'm making some modifications to a CF app which uses either an Oracle 8 or
Access 2000 database. Unfortunately, I can't test on Oracle today without
installing a copy (want to avoid if possible), and was wondering if anyone
could confirm that I can use SQL bind variables with the IN predicate, like
so...
UPDATE #PREDICTEDFIXTURES#
SET points = points + #intCorrectScorePoints#
WHERE entry_id IN (
<cfif database EQ "oracle">
<cfqueryparam value="#ListQualify(lstCorrectScore, "'")#"
cfsqltype="CF_SQL_VARCHAR"
list="Yes">
<cfelse>
#ListQualify(lstCorrectScore, "'")#
</cfif>
)
AND fixture_id = '#fixture_id#'
AND competition_id = '#competition_id#'
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
