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
GUITAR 12-STRING 4
view
GUITAR 12-STRING 5
view
GUITAR CASES 06 deal for instrument cases, electronic apparatus, mic cases, etc
view
MANDOLIN MISC 117 A fully compensated saddle.
view
GUITAR ACOUSTIC 26 A reissue of the pre-WWII HD-28
view
BANJO UKELELE 404 A soprano size uke made from solid Updated version of the traditional Martin Sty
view
MANDOLIN MISC 406 A unique, high-quality alto recorder.
view
AMPS JACKS 147 Acoustic endpin jack- mono
view
AMPS JACKS 148 Acoustic endpin jack- stereo
view
AMPS JACKS 149 All metal 1/4 inch male end plug
view
AMPS TUBEAMP 415 All modules include two 12AX9 preamp tubes, 3 band EQ w/bright switch, and level
view
GUITAR ACOUSTIC 55 An affordable orchestra model featuring mahogany solid back and laminated sides
view
GUITAR MISC 101 An all-in-one guitar care solution
view
AMPS EFFECTS 119 An excellent sounding fuzz-tone, which produces incredible sustain.
view
GUITAR ACOUSTIC 46 An orchestra-sized gloss top, 12-fret with slotted peghead.
view
GUITAR ACOUSTIC 49 Auditorium model features include 14 frets clear of the body
view
GUITAR CASES 81 Backpack straps and waist belt lifts the guitar to a comfortable position
view
BANJO MISC 311 Banjo Hanger
view
BANJO MISC 310 Banjo Mute
view
MANDOLIN MISC 115 Capo for Mandolin and Banjo

  next  Next Page
  This example was created using WebSmart.

www.excelsystems.com