WebSmart Code Samples
 

SQL Multiple Field Search

Description: This program demonstrates how to create multiple field search functionality using SQL. By placing values in the fields, you reduce the number of records displayed until reaching a unique record by providing values for all input fields. Note: This example is for WebSmart versions 4 and lower. If you are using version 5 templates please use the built in option for filter fields in the template wizard.


Click here to view step by step instructions on how this program was created

  Search Criteria  
Inventory Category Category Group Inventory Item Code
 
Example: Category=AMPS - Group=EFFECTS - Code=123
 
       
   


Action Inventory Category Category Group Inventory Item Code Item Short Description
view
AMPS EFFECTS 119 An excellent sounding fuzz-tone, which produces incredible sustain.
view
AMPS EFFECTS 120 Effects adaptor
view
AMPS EFFECTS 121 Ring modulator
view
AMPS EFFECTS 122 Signal compressor
view
AMPS EFFECTS 123 Three postion equalizer for guitar or keyboard
view
AMPS EFFECTS 124 Combination signal booster and tone modifier
view
AMPS EFFECTS 125 Equalizer for bass guitars, guitars, and keyboards
view
AMPS JACKS 128 Replacement cable for either AGH or AGS-1 acoustic pickups
view
AMPS JACKS 128 Replacement cable for either AGH or AGS-1 acoustic pickups
view
AMPS JACKS 131 This is the companion jack for the DEQ-3
view
AMPS JACKS 139 Standard 1/4 inch jack
view
AMPS JACKS 140 Gold standard 1/4 inch jack
view
AMPS JACKS 141 Long bushing 1/4 inch input jack
view
AMPS JACKS 142 Standard stereo/switching 1/4 inch input jack
view
AMPS JACKS 143 Long mono panel jack
view
AMPS JACKS 144 Gold long, mono panel jack
view
AMPS JACKS 145 Long, stereo/switching panel jack
view
AMPS JACKS 146 Gold long, stereo/switching panel jack
view
AMPS JACKS 147 Acoustic endpin jack- mono
view
AMPS JACKS 148 Acoustic endpin jack- stereo

  next  Next Page
  This example was created using WebSmart.

www.excelsystems.com