On an access db:
<cfquery
name="qry_answersGetMaxMultipleKey"
connectstring="#request.dbConnectionString#"
dbtype="dynamic">
SELECT MAX(multipleKey) AS maxMultipleKey
FROM #request.sqlObjectPrefix#tbAnswers
</cfquery>
<cfdump var="#qry_answersGetMaxMultipleKey#"><cfabort>
It shows qry_answersGetMaxMultipleKey (Records=1, Time=0ms), but the
recordset is empty or has a null value.
I'm used to ms sql, so perhaps access is a bit different?
Also, multipleKey is not the PK, there are duplicate records with the same
value. Could that be the problem?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community
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
