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

How to search two SQL database fields with one search box?

Thread began 8/14/2013 1:43 pm by blakebenjamin327842 | Last modified 8/14/2013 7:08 pm by blakebenjamin327842 | 934 views | 10 replies |

blakebenjamin327842

How to search two SQL database fields with one search box?

I want to have one search form field named "search" on the top corner of the page and I want a visitor to be able to try to match either a product name or product sku # with the aptly named fields in the SQL dbase. How would I go about this using the DataAssist Search Wizard?

Thnaks

Sign in to reply to this post

Jason ByrnesWebAssist

Use a key word search criteria type. Where you select the columns to search will be a multi select box, use ctrl+mouse click to select each column you wish to search.

Sign in to reply to this post

blakebenjamin327842

No Keyword Search Available

I don't see an option for a "key word search criteria". The search type options available to me are as follows:

1. Advanced Text Search
2. Date Range
3. Price Range
4. Numeric Range
5. Exact Match
6. Multiple Select List or Checkboxes
7. Single Checkboxes
8. Single Check Box

Am I missing something?

Sign in to reply to this post

Jason ByrnesWebAssist

use Advanced Text Search, that should be the same as a Keyword search.

Sign in to reply to this post

blakebenjamin327842

Still not working. See the link below.

I am selecting:

Search Type: "Advanced Text Search"

Separator: "Or"

Columns: : "ProductSKU" & "ProductName"

New for field: "try"

Sign in to reply to this post

Jason ByrnesWebAssist

"not working" can mean any number of things. Can you please provide more details.

also the link you provided in the private section does not work.

keep in mind:
Before starting the Data Assist Search wizard, you should create the results page.

ON the results page, add a basic recordset, and create the record display using a repeat region and add the paging navigation if need be. Then start the Data Assist Search wizard, this will allow you to configure how the results page recordset will be filtered.

Sign in to reply to this post

blakebenjamin327842

I used DataAssist to create the original search page, results page and detail page. Then created a secondary search page using the search wizard. Would there be an issue is the we a mixing text with numerics in the search?

I sent more accurate links for you to view.

Sign in to reply to this post

Jason ByrnesWebAssist

  Then created a secondary search page  


using a secondary search page wont work. You should configure the initial search page for what you are trying to accomplish rather than trying to use 2 separate search pages that connect to one results page, they will conflict with each other.

Sign in to reply to this post

blakebenjamin327842

I tried to use DataAssist to create the results page and detail page. Then created the search page using the search wizard.

I used the same settings (shown below again)

I am selecting: ??Search Type: "Advanced Text Search"??Separator: "Or"??Columns: : "ProductSKU" & "ProductName" ??New for field: "try"

Still doesn't work at all.

Sign in to reply to this post

Jason ByrnesWebAssist

Use the Data Assist wizard to create the Search, Results and Details pages.

for the search page setting, set it to Search the ProductSKU SKU column


after the pages are created, open the results page, and go to the Server Behaviors panel. Double Click the Data Assist Search server behavior. Edit the Criteria that was created by the wizard, and change it to a Key Word criteria type, and add the ProductName column to the selection of columns to search.

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...