Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Search option

Search option

Thread began 3/22/2013 7:52 am by wbrooks199805 | Last modified 3/22/2013 9:02 am by wbrooks199805 | 1254 views | 4 replies |

3/22/2013 7:52 am | #1 wbrooks199805

Search option

I am trying to update up DA search and it keeps generating code <?php require_once("../webassist/database_management/wada_search.php"); ?> which gives an error:
Fatal error: Cannot redeclare waqb_getenddate() (previously declared in /home/content/n/a/m/namcnational/html/webassist/database_management/wada_search.php:332) in /home/content/n/a/m/namcnational/html/WADbSearch/HelperPHP.php on line 345

So I delete that ..but it won't return any search options.
I have attached the file.

I did up date recently from Data Assist to Data Bridge. Also, All the records show when I open the page. As soon as I do a search all the records disappear. I want to be able to search by each field, not all. I think I have the correct as "AND"

3/22/2013 8:42 am | #2 Jason ByrnesWebAssist

You need to remove line 9 which is the include for the old Data Assist search include file:
<?php require_once("../WADbSearch/HelperPHP.php");?>

to troubleshot why the search is not returning any results I will need a link to the search page to test the search.

also if you could add the following code on the results page just after the <body> tag to display the search SQL, that would be helpfull:

php:

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

3/22/2013 8:49 am | #3 wbrooks199805

here you go..

members_Results.php

3/22/2013 8:55 am | #4 Jason ByrnesWebAssist

one issue I see is in the last 2 select lists, they do not have blank values for the default options. in the sourch code i see:

<select name="S_servicesone" class="WADADataTableCell" id="S_servicesone">
<option selected>NACIS Code</option>

and:
<select name="S_divisionone" id="S_divisionone">
<option value="selected" selected="selected" > Divisions</option>

those should be:
<select name="S_servicesone" class="WADADataTableCell" id="S_servicesone">
<option value="" selected>NACIS Code</option>

and:
<select name="S_divisionone" id="S_divisionone">
<option value="" selected="selected" > Divisions</option>

3/22/2013 9:02 am | #5 wbrooks199805

You are right

When I put that code on, I thought it might be that.

Thanks so much Jason, as always. ;)

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.