I really do need to try and get this fixed...
here is the code in the page:
<CFQUERY NAME = "TEST" DATASOURCE = "TEST_DB">
SELECT TABLE1.RECORD_ID,DESCRIPTION,SOURCE_DESC FROM TABLE1, TABLE2
WHERE TABLE1.RECORD_ID = TABLE2.RECORD_ID
AND APPROVED = 'Y'
AND QUANTITY - CQTY > 0
AND SOURCE_DESC <> 'NOT AVAIL'
ORDER BY TABLE1.RECORD_ID DESC
</CFQUERY>
<CFOUTPUT>#TEST.RECORDCOUNT#</CFOUTPUT>
<CFLOCK NAME="VERITY" TIMEOUT="60">
<CFINDEX
QUERY = "TEST"
COLLECTION = "ALLPRODUCTS"
ACTION = "REFRESH"
TYPE = "CUSTOM"
KEY = "RECORD_ID"
BODY = "DESCRIPTION,SOURCE_DESC"
>
</CFLOCK>
<cfsearch name="OUTPUT_LIST" collection="ALLPRODUCTS" criteria="">
<CFOUTPUT>#OUTPUT_LIST.RECORDSSEARCHED#</CFOUTPUT>
I think, and please correct me if I am wrong, that both recordcount and
recordssearched should be equal.
PLEASE HELP!
-j
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283571
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
