I posted a message earlier about the Verity Collection problems i was having. I have tried another way and I now have a different problem!
At the top of my search I have the following value:
5 advertisement(s) matched your query.
This obviously means that the search has found records matching the criteria i entered. However the search refuses to display the results and i get this error:
Variable EXPIRYDATE is undefined.
you can replace the variable EXPIRYDATE with any of the table variables in my database - it's all the same.
here is my code:
<cfsearch collection="adVerityCollection" name="findAds" criteria="#keywords#">
<CFIF findads.RecordCount GT 0>
<CFoutput query = "findAds">
<B>#findads.RecordCount#</B> advertisement(s) matched your query.
Sorry, No records were returned from your request.
here is the code which i used to update the verity collection:
<cfquery name="get_db_info" datasource="advertisements">
body="sellername, adverttitle, emailaddress, dateentered, expirydate, advertisementcontents, category, region">
Your Collection has been updated.
The collection updates without any problems and as i said earlier the search is obviously finding records matching the entered criteria - it's just that it doesnt display any of the fields which are in the database table which i thought i had set up correctly with the update verity code.