SalesCart Standard / PRO / SQL - Another search question

Print Page | Close Window

Another search question

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=620
Printed Date: November/23/24 at 6:30pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com

Topic: Another search question

Posted By: jmoffett
Subject: Another search question
Date Posted: September/10/06 at 6:26pm

Using the search feature found on the default.asp page, the form field properties indicates it is referencing "fmname" to search the name field. What is the syntax to make it also search the SKU field? Would it be "fmname&fmSKU"?

Replies:

Posted By: mikeb
Date Posted: September/29/06 at 2:54pm

This is the same question as you indicated in your other post...you have to rerun the Database Region Wizard and add a second criteria to the wizard (to modify the sql statement)

Posted By: qrsystems
Date Posted: September/29/06 at 4:38pm

Hi Mike,
I have similar problem. How do you modify the sql and with what sytax?

-------------
Dave

Posted By: mikeb
Date Posted: September/29/06 at 4:42pm

You can rerun the database region wizard if you are using FrontPage.... Its a point and click wizard and there is a point where you can select "criteria". You can specify that criteria. You need a good book on FrontPage with a good chapter on the Database Region Wizard... so it needs to be a more advanced book.

This can also be done in Dreamweaver.