One link works, identical link doesn't
4 posts by 3 authors in: Forums > CMS Builder
Last Post: November 16, 2010 (RSS)
I have two CMSBuilder sites for the same client. We need to call pages that use one result for a field.
The link on one site works prefectly:
http://www.starhomeusa.com/listings.php?lfield3=danville
The identical link on the other site returns "no record found" even though it is using another version of he same database:
http://www.kylandsales.com/listings.php?lfield3=danville
The client has made some changes to records on the 2nd page - the one that no longer works, but I can't see where anything he did messed it up. It worked when I installed it, but it isn't working now. The settings are identical. Any idea what could have gone wrong on the 2nd page?
Thanks for any help,
Bob
The link on one site works prefectly:
http://www.starhomeusa.com/listings.php?lfield3=danville
The identical link on the other site returns "no record found" even though it is using another version of he same database:
http://www.kylandsales.com/listings.php?lfield3=danville
The client has made some changes to records on the 2nd page - the one that no longer works, but I can't see where anything he did messed it up. It worked when I installed it, but it isn't working now. The settings are identical. Any idea what could have gone wrong on the 2nd page?
Thanks for any help,
Bob
Re: [orangecat] One link works, identical link doesn't
By Jason - November 16, 2010
Hi Bob,
"No Record Found" doesn't necessarily indicate an error, just that the query didn't return any results.
Here are some possible causes:
1) There are no records in your table where lfield3 = danville
2) lfield3 has been either removed or renamed.
This is where I would start looking. If it's still not working, please fill out a 2nd level support request here:
https://www.interactivetools.com/support/email_support_form.php
and we can take a closer look for you.
Hope this helps.
"No Record Found" doesn't necessarily indicate an error, just that the query didn't return any results.
Here are some possible causes:
1) There are no records in your table where lfield3 = danville
2) lfield3 has been either removed or renamed.
This is where I would start looking. If it's still not working, please fill out a 2nd level support request here:
https://www.interactivetools.com/support/email_support_form.php
and we can take a closer look for you.
Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] One link works, identical link doesn't
Thanks, Jason, but there are records where lfield3=danville. It works for one city name but not the others. I'll fill out a Level 2 request so someone can take ma look at it.
Re: [orangecat] One link works, identical link doesn't
By Damon - November 16, 2010
Hi,
Just fixed that. The issue was the Where statement. Removed this code:
and the search works as expected.
Just fixed that. The issue was the Where statement. Removed this code:
'where' => whereRecordNumberInUrl(1),
and the search works as expected.
Cheers,
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/