Home
SQLGridSelectedView
       Simple Grid - NorthWind Products Simple Grid - NorthWind Products
       Simple Grid with DropDown Filter Selection Simple Grid with DropDown Filter Selection
       Simple Grid with Text Search Simple Grid with Text Search
       Milti-Grid Page using Intermodule Communication Milti-Grid Page using Intermodule Communication
       Product - Editable Product - Editable
       Orders Editable with Template Orders Editable with Template
       User Selection by Field User Selection by Field
       In-Line Function MakeLink  In-Line Function MakeLink 
       Browser Breakdown Browser Breakdown
       Selection Links Selection Links
       Golf Scores from Excel Spreadsheet Golf Scores from Excel Spreadsheet
       Wait on Previous Filter Wait on Previous Filter
       Customers using UDF Split Customers using UDF Split
       Rollup Columns  Rollup Columns 
SQLChart
       Line - Orders Per Month Line - Orders Per Month
       Spline - Visitors and Views Spline - Visitors and Views
       Column - Vistors And Views Column - Vistors And Views
       Column 3D - Visitors and Views Column 3D - Visitors and Views
       Bar - Visitors and Views Bar - Visitors and Views
       Area - Vistors and Views Area - Vistors and Views
       Stacked Column - Visitors and Views Stacked Column - Visitors and Views
       Browser Breakdown Browser Breakdown
       Sales per month Sales per month
       Bot Views Bot Views
T-Minus
       Examples Examples
XMLdb
       User List User List
       Revised User List Revised User List
       NorthWind Employees NorthWind Employees
       NorthWind Customers Paging Example NorthWind Customers Paging Example
IFrame64
       Display URL Display URL
       With Parameters With Parameters
       With Parameters - Base64 Encoded With Parameters - Base64 Encoded
       With Parameters - Parameter Encrypted With Parameters - Parameter Encrypted
       With Parameters as Single Parameter With Parameters as Single Parameter
MenuLinks
       Horizontal Siblings Horizontal Siblings
       Vertical Siblings Vertical Siblings
       Parent Horizontal Parent Horizontal
       Parent Vertical Parent Vertical
       Vertical Children  Vertical Children 
       Templated Templated
ThermoChart
       Simple Thermometer
       Simple Thermometer - Square
       Simple Thermometer - No Scale
       Colorful Thermometer
       ColorFul Thermometer #2
       Guage Style
       Guage Style #2
       Fund Raising
       Fat Albert
       SQL Matrix - Percentage
SimpleQuery
       SimpleQuery - DesktopModules SimpleQuery - DesktopModules
       SimpleQuery - Products SimpleQuery - Products
       SimpleQuery - Products with Column Sort SimpleQuery - Products with Column Sort
       SimpleQuery - IMC SimpleQuery - IMC
 		SimpleQuery » SimpleQuery - Products with Column Sort
 
Enter Title  
 
 
 

In this example, SimpleQuery is using the JQuery Plug-in called TableSorter to perform the column sorting. See TableSorter for details on useage.
 
 
 
SimpleQuery - Products with Column Sort via JQuery Plug-in  
 
 
 
Product ID Product Name Supplier ID Category ID Quantity Per Unit Unit Price Units In Stock Units On Order Reorder Level Discontinued
1 Tazo Chai 6 1 10 boxes x 20 bags 18.0000 100 1 100 False
2 Chang 1 1 24 - 12 oz bottles 19.0000 17 40 25 False
3 Aniseed Syrup 1 2 12 - 550 ml bottles 10.0000 13 70 25 False
4 Chef Anton's Cajun Seasoning 2 2 48 - 6 oz jars 22.0000 53 0 0 False
5 Chef Anton's Gumbo Mix 2 2 36 boxes 21.3500 0 0 0 True
6 Grandma's Boysenberry Spread 3 2 12 - 8 oz jars 25.0000 120 0 25 False
7 Uncle Bob's Organic Dried Pears 3 7 12 - 1 lb pkgs. 30.0000 15 0 10 False
8 Northwoods Cranberry Sauce 3 2 12 - 12 oz jars 33.0000 6 0 0 False
9 Mishi Kobe Niku 4 6 18 - 500 g pkgs. 97.0000 29 0 2 True
10 Ikura 4 8 12 - 200 ml jars 31.0000 31 0 0 False
11 Queso Cabrales 5 4 1 kg pkg. 21.0000 22 30 30 False
12 Queso Manchego La Pastora 5 4 10 - 500 g pkgs. 38.0000 86 0 0 False
13 Konbu 6 8 2 kg box 6.0000 24 0 5 False
14 Tofu 6 7 40 - 100 g pkgs. 23.2500 35 0 0 False
15 Genen Shouyu 6 2 24 - 250 ml bottles 15.5000 39 0 5 False
16 Pavlova 7 3 32 - 500 g boxes 17.4500 29 0 10 False
17 Alice Mutton 7 6 20 - 1 kg tins 39.0000 0 0 0 True
18 Carnarvon Tigers 7 8 16 kg pkg. 62.5000 42 0 0 False
19 Teatime Chocolate Biscuits 8 3 10 boxes x 12 pieces 9.2000 25 0 5 False
20 Sir Rodney's Marmalade 8 3 30 gift boxes 81.0000 40 0 0 False
21 Sir Rodney's Scones 8 3 24 pkgs. x 4 pieces 10.0000 3 40 5 False
22 Gustaf's Knäckebröd 9 5 24 - 500 g pkgs. 21.0000 104 0 25 False
23 Tunnbröd 9 5 12 - 250 g pkgs. 9.0000 61 0 25 False
24 Guaraná Fantástica 10 1 12 - 355 ml cans 4.5000 20 0 0 True
25 NuNuCa Nuß-Nougat-Creme 11 3 20 - 450 g glasses 14.0000 76 0 30 False
26 Gumbär Gummibärchen 11 3 100 - 250 g bags 31.2300 15 0 0 False
27 Schoggi Schokolade 11 3 100 - 100 g pieces 43.9000 49 0 30 False
28 Rössle Sauerkraut 12 7 25 - 825 g cans 45.6000 26 0 0 True
29 Thüringer Rostbratwurst 12 6 50 bags x 30 sausgs. 123.7900 0 0 0 True
30 Nord-Ost Matjeshering 13 8 10 - 200 g glasses 25.8900 10 0 15 False
31 Gorgonzola Telino 14 4 12 - 100 g pkgs 12.5000 0 70 20 False
32 Mascarpone Fabioli 14 4 24 - 200 g pkgs. 32.0000 9 40 25 False
33 Geitost 15 4 500 g 2.5000 112 0 20 False
34 Sasquatch Ale 16 1 24 - 12 oz bottles 14.0000 111 0 15 False
35 Steeleye Stout 16 1 24 - 12 oz bottles 18.0000 20 0 15 False
36 Inlagd Sill 17 8 24 - 250 g jars 19.0000 112 0 20 False
37 Gravad lax 17 8 12 - 500 g pkgs. 26.0000 11 50 25 False
38 Côte de Blaye 18 1 12 - 75 cl bottles 263.5000 17 0 15 False
39 Chartreuse verte 18 1 750 cc per bottle 18.0000 69 0 5 False
40 Boston Crab Meat 19 8 24 - 4 oz tins 18.4000 123 0 30 False
41 Jack's New England Clam Chowder 19 8 12 - 12 oz cans 9.6500 85 0 10 False
42 Singaporean Hokkien Fried Mee 20 5 32 - 1 kg pkgs. 14.0000 26 0 0 True
43 Ipoh Coffee 20 1 16 - 500 g tins 46.0000 17 10 25 False
44 Gula Malacca 20 2 20 - 2 kg bags 19.4500 27 0 15 False
45 Rogede sild 21 8 1k pkg. 9.5000 5 70 15 False
46 Spegesild 21 8 4 - 450 g glasses 12.0000 95 0 0 False
47 Zaanse koeken 22 3 10 - 4 oz boxes 9.5000 36 0 0 False
48 Chocolade 22 3 10 pkgs. 12.7500 15 70 25 False
49 Maxilaku 23 3 24 - 50 g pkgs. 20.0000 10 60 15 False
50 Valkoinen suklaa 23 3 12 - 100 g bars 16.2500 65 0 30 False
51 Manjimup Dried Apples 24 7 50 - 300 g pkgs. 53.0000 20 0 10 False
52 Filo Mix 24 5 16 - 2 kg boxes 7.0000 38 0 25 False
53 Perth Pasties 24 6 48 pieces 32.8000 0 0 0 True
54 Tourtière 25 6 16 pies 7.4500 21 0 10 False
55 Pâté chinois 25 6 24 boxes x 2 pies 24.0000 115 0 20 False
56 Gnocchi di nonna Alice 26 5 24 - 250 g pkgs. 38.0000 21 10 30 False
57 Ravioli Angelo 26 5 24 - 250 g pkgs. 19.5000 36 0 20 False
58 Escargots de Bourgogne 27 8 24 pieces 13.2500 62 0 20 False
59 Raclette Courdavault 28 4 5 kg pkg. 55.0000 79 0 0 False
60 Camembert Pierrot 28 4 15 - 300 g rounds 34.0000 19 0 0 False
61 Sirop d'érable 29 2 24 - 500 ml bottles 28.5000 113 0 25 False
62 Tarte au sucre 29 3 48 pies 49.3000 17 0 0 False
63 Vegie-spread 7 2 15 - 625 g jars 43.9000 24 0 5 False
64 Wimmers gute Semmelknödel 12 5 20 bags x 4 pieces 33.2500 22 80 30 False
65 Louisiana Fiery Hot Pepper Sauce 2 2 32 - 8 oz bottles 21.0500 76 0 0 False
66 Louisiana Hot Spiced Okra 2 2 24 - 8 oz jars 17.0000 4 100 20 False
67 Laughing Lumberjack Lager 16 1 24 - 12 oz bottles 14.0000 52 0 10 False
68 Scottish Longbreads 8 3 10 boxes x 8 pieces 12.5000 6 10 15 False
69 Gudbrandsdalsost 15 4 10 kg pkg. 36.0000 26 0 15 False
70 Outback Lager 7 1 24 - 355 ml bottles 15.0000 15 10 30 False
71 Flotemysost 15 4 10 - 500 g pkgs. 21.5000 26 0 0 False
72 Mozzarella di Giovanni 14 4 24 - 200 g pkgs. 34.8000 14 0 0 False
73 Röd Kaviar 17 8 24 - 150 g jars 15.0000 101 0 5 False
74 Longlife Tofu 4 7 5 kg pkg. 10.0000 4 20 5 False
75 Rhönbräu Klosterbier 12 1 24 - 0.5 l bottles 7.7500 125 0 25 False
76 Lakkalikööri 23 1 500 ml 18.0000 57 0 20 False
77 Original Frankfurter grüne Soße 12 2 12 boxes 13.0000 32 0 15 False
78 Easier Mac 6 7 10 packages 12.5000 100 0 20 False
81 arg 5 4 adg 0.0000 6 6 5 False
88 jj 1 1 k 12.2500 50 50 25 False
 
 
 
 
 
 
 
 
  Copyright 2009 by TressleWorks