close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DataAssist Database Search Not Returning Results

Thread began 7/26/2010 6:30 pm by stephanierjones133663 | Last modified 7/27/2010 11:09 am by Jason Byrnes | 1089 views | 9 replies |

stephanierjones133663

DataAssist Database Search Not Returning Results

Hello,
I am using CS5 and DataAssist 2. I am trying to perform a search that can have up to 5 parameters. When I set it up using my own search form and results, the "search" returned ALL THE RECORDS in the database. When I tried to have the extension create the page, form, and form field (testing using one text field with an EXACT MATCH attribute), everything in the database was still returned.

The WADbSearch folder is in the root of my site. If you need the connection file to my dummy database, I can give that to you.

Attached Files
NewSearch1.txt
empSrchrs1.txt
Sign in to reply to this post

Jason ByrnesWebAssist

the trigger for the search is looking for a form element named "WADbSearch1" to have a value.

add a new hidden form element to your search form, set the name to "WADbSearch1" and the value to "WADbSearch1"

Sign in to reply to this post

stephanierjones133663

Added Hidden Field and Still Did not Work

Hello, I added and it still did not work. Please see attached file. I started to get excited but am deflated... LOL! Thanks for helping me.

Attached Files
NewSearch1HiddenFieldAdded.txt
Sign in to reply to this post

stephanierjones133663

Better Image

Here is a better image of the page. I am using "jones" as a datapoint.

Sign in to reply to this post

Jason ByrnesWebAssist

please compress the original search and results PHP pages into a zip archive and attach the zip file to your reply. Also include a link where I could see the problem.

Sign in to reply to this post

stephanierjones133663

Here is the link and a zip file.

Here is the link...

NewSearch1.asp

I am not using PHP. I have attached everything I have for that folder.

Attached Files
Harmonization.zip
Sign in to reply to this post

Jason ByrnesWebAssist

the forms method is set to get.

on the results page, change the following line:

if (cStr(Request.Form("WADbSearch1")) <> "") then



to:

if (cStr(Request.Querystring("WADbSearch1")) <> "") then
Sign in to reply to this post

stephanierjones133663

Omg...

Oh my goodness!!!!!!!!!!!!!!!! Jason... Thank you soooooooo much!!!!!!!!!!!!!!!! You are da bomb!

Sign in to reply to this post

stephanierjones133663

One more thing...

I guess I forgot to tell you that IT WORKED LIKE A CHARM.

Sign in to reply to this post

Jason ByrnesWebAssist

great, glad to hear it is working.

Sign in to reply to this post
loading

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...