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 ACOUSTIC 10 Laminated mahogany back and sides, solid spruce top, satin finish.
view
GUITAR ACOUSTIC 11 Mahogany solid back and laminated sides, solid Sitka spruce top, satin finish.
view
GUITAR ACOUSTIC 12 Solid mahogany back, sides, and top, minimal ornamentation, and satin finish.
view
GUITAR ACOUSTIC 13 Solid mahogany back & sides with satin finish, solid spruce top
view
GUITAR ACOUSTIC 130 On board acoustic EQ with 3 bands.
view
GUITAR ACOUSTIC 14 The original 14-fret Merlin dreadnought
view
GUITAR ACOUSTIC 15 Entry point to the Vintage Series
view
GUITAR ACOUSTIC 16 Similar to the D-18V, but with 12 frets to the body and a slotted peghead
view
GUITAR ACOUSTIC 17 The Dreadnought, the standard by which all others are measured.
view
GUITAR ACOUSTIC 18 Strong bass component in its tone, making it an excellent rhythm instrument
view
GUITAR ACOUSTIC 19 Solid spruce and highly flamed Hawaiian koa
view
GUITAR ACOUSTIC 20 Top-of-the-line dreadnought
view
GUITAR ACOUSTIC 21 Satin, 15 series, acoustic electric with Fisher Pickup
view
GUITAR ACOUSTIC 22 14 frets clear of the body, 25.4 scale length, tortoise pickguard
view
GUITAR ACOUSTIC 23 Road Series rosewood dreadnough
view
GUITAR ACOUSTIC 24 Solid Indian rosewood back and sides, solid spruce top.
view
GUITAR ACOUSTIC 25 Legendary large soundhole dreadnought
view
GUITAR ACOUSTIC 26 A reissue of the pre-WWII HD-28
view
GUITAR ACOUSTIC 27 12-fret dreadnought, a recreation of the pre-1938 D-28 herringbone model
view
GUITAR ACOUSTIC 28 Solid spruce top, mahogany neck, rosewood headplate and bound fingerboard.

  next  Next Page
  This example was created using WebSmart.

www.excelsystems.com