This is Interesting: Free Magazines for Graphics designers and webmasters  


Home > Archive > Dreamweaver > March 2004 > SQL help (SQL code in the hyperlink)





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author SQL help (SQL code in the hyperlink)
Wally Kolcz

2004-03-31, 11:38 am

I am trying to work on a dynamic web site that has the SQL inside the
hyperlink. I want it to pull information out of a database for the city and
the businesses in that city.

I have 2 tables: CatCity and CatType. CatCity is a number 1 - 32 (which is
the city) and CatType is a number 1 - 20 (which is a type of business in a
city).

When I try
http://www.carryoutmenus.com/listin...y=16&CatType=2, I
only get the city to pull up and it displays all the types of businesses in
that city with no response from the CatType. Am I writing the correct string
code?

It seems to work fine in the Macromedia forum when they have 2 identifiers
(catid and threadid):
http://www.macromedia.com/cfusion/w....cfm?catid=189&
threadid=803084


RobGT

2004-03-31, 1:36 pm

Post your recordset SQL statement so we can see what's going on.
Cheers,
Rob http://robgt.com/
Extensions: http://robgt.com/products/index.asp
Tutorials: http://robgt.com/tutorials/index.asp
Blog: http://blog.robgt.com/


Sponsored Links


Copyright 2003 - 2008 forum4designers.com  Software forum  Computer Hardware reviews