Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Search Not Working

Search Not Working

Thread began 5/08/2012 8:12 am by J7HNW | Last modified 5/10/2012 7:53 am by Jason Byrnes | 1769 views | 6 replies |

5/08/2012 8:12 am | #1 J7HNW

Search Not Working

Please can you help

I have run the database wizard and all pages work fine apart from Search ( Insert, Update etc all doing as they should )

If I search with no criteria - then the results all appear fine

One of the fields is TOWN

If I do a search by putting TOWN in the search and then enter HIGH for HIGH WYCOMBE which is a town in the database - the search returns nothing

Same if I search on any of the fields. However if I leave all the search fields blank - then all results are shown

Help please

Attached Files

repvisits_Search.zip

5/08/2012 10:29 am | #2 Jason ByrnesWebAssist

please send a link where i can see the problem and a copy of the repvisits_Results.php page to troubleshoot.

5/09/2012 2:34 am | #3 J7HNW

Link

Hi Jason

Search file and Results file are attached

Link to search can be found here

repvisits_Search.php

Thanks

John

Attached Files

Customers.zip

5/09/2012 11:19 am | #4 Jason ByrnesWebAssist

to help troubleshoot add the following code to the results page, just after the <body> tag:

php:

<?php echo("SQL: ".$query_limit_WADArepvisits); ?><br />

5/10/2012 1:50 am | #5 J7HNW

Code Added

Hi Jason

Code added just after Body tag

PHP:

---------

<?php echo("SQL: ".$query_limit_WADArepvisits); ?>

---------

5/10/2012 4:13 am | #6 J7HNW

Fixed

Hi Jason

In the end I ran the Wizard again and remade the pages and this time it has worked

Thanks for your help.

John

5/10/2012 7:53 am | #7 Jason ByrnesWebAssist

Ok, glad to hear it is working.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.