I ahve a strange anomaly and I'm starting to think that Cf does not like me.
I have a simple table that contains company information (name, address,
notes, etc.)
When i try to search for a company name that I have in the db, nothing ever
comes up. not one record:
<cfquery... name="Companies">
SELECT companyID, companyBranch,
companyName, companyAddress,
companyCity,
companyState,
companyCountry,
companyZipcode,
companyPhone1,
companyPhone2,
companyTollFree,
companyFax,
companyEmail,
companyWebsite,
companysummary,
companynotes,
isActive,
isDelete
FROM
tbl_Company WHERE isDelete = '0'
ORDER BY companyName ASC, companyBranch ASC
</cfquery>
<cflock name="RefreshCompany" type="EXCLUSIVE" timeout="#CreateTime(0, 0,
30)#">
<cfindex collection="#CompanyCollection#"
action="Refresh"
type="CUSTOM"
body="companyName,companySummmary,companyNotes"
key="companyID"
query="Companies">
</cflock>
<cfsearch collection="#CompanyCollection#"
Name="CompanyFound"
type="EXPLICIT"
Criteria="#Form.keywords#">
then when i view the valuelist, nothing is there..
I've deleted and recreated the collection numerous times and am frustrated.
It should be easy. Its only one table X-)
any thoughts?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
