Forum Home Forum Home > Legacy Products > SalesCart Standard / PRO / SQL
  New Posts New Posts RSS Feed - Another search question
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedAnother search question

 Post Reply Post Reply
Author
Message
jmoffett View Drop Down
Newbie
Newbie


Joined: July/18/06
Status: Offline
Points: 28
Post Options Post Options   Thanks (0) Thanks(0)   Quote jmoffett Quote  Post ReplyReply Direct Link To This Post Topic: Another search question
    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"?
Back to Top
mikeb View Drop Down
Admin Group
Admin Group
Avatar

Joined: March/17/04
Location: United States
Status: Offline
Points: 194
Post Options Post Options   Thanks (0) Thanks(0)   Quote mikeb Quote  Post ReplyReply Direct Link To This Post 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)
Back to Top
qrsystems View Drop Down
Newbie
Newbie
Avatar

Joined: November/16/04
Location: United States
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote qrsystems Quote  Post ReplyReply Direct Link To This Post Posted: September/29/06 at 4:38pm
Hi Mike,
I have similar problem. How do you modify the sql and with what sytax?
Back to Top
mikeb View Drop Down
Admin Group
Admin Group
Avatar

Joined: March/17/04
Location: United States
Status: Offline
Points: 194
Post Options Post Options   Thanks (0) Thanks(0)   Quote mikeb Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

Copyright 2015 by ComCity® LLC and SalesCart™.  All Rights Reserved