The Robertson Team


 

 
 
 
 
 
  Programmers' Tools >  The Free Stuff >  GridMonger >  FAQ >  Tell me about joined table support
 

Tell me about joined table support

GridMonger supports table joins to only a limited degree at present.

The 'main' table is the displayed data. A 'joined' table can be added that will affect the records displayed.  The join is a part of the WHERE clause and not a part of the data displayed.

For example, a table of motor vehicles located in various U.S. states can be queried, with the results limited to those located only in California by querying a second, related table and pulling the state of residency. 

See the Live Demos page for an example of this in action using a table of U.S. states and a separate one containing U.S. ZIP codes (you'll need to download the application to see how it is set up).


The Robertson Team, TheKing@mysecretbase.com
1.559.360.1717 


HostMySite.com is a leader in ColdFusion web hosting and managed dedicated servers.