Could this be caused be a failure when joining tables? Maybe there is not
record in TABLE2 that goes with TABLE1. So more records would be searched than
returned. Perhaps try a LEFT JOIN?
>>> John Stottlemire <[EMAIL PROTECTED]> 07/12/07 11:55 AM >>>
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283574
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
