Session Request Query String

jdm3 · Sep 17, 2003

can someone help me with the request query String session, How do I incorporate the URL String to work with the database if my string is as followed

http://mydomaine.com/city.asp?Flash...ovinceName=Ontario&CityID=11&CityName=Windsor

How can I make these variables communicate when I do a search in the database that it will look into that string, Country, Province, and City to pull out the requested search for that area

Veep · Sep 17, 2003

At the top of city.asp
<%
' get the values and assign them to variables
Country=request.querystring("country&quot

Province=request.querystring("province&quot

City=request.querystring("City&quot

'create your sql statement
strSql="SELECT * FROM myTable where Country='" & Country & _
"' AND Province='" & Province & "' AND City='" & City & "'"

'create your connection object and let it rip
set conn=server.creatobject("ADODB.CONNECTION&quot

conn.open yourConnectionString
set rs=conn.execute(strSql)
If not rs.eof then
'display your stuff here
End if
set rs=nothing
conn.close
set conn=nothing
%>

jdm3 · Sep 17, 2003

This ia what I have at the top right now but it's not doing the job.


<%
' Get Current Category
cat = TRIM( Request( "cat" ) )
IF cat = "" THEN cat = "Home"

' Get Search Phrase
searchFor = TRIM( Request( "searchFor" ) )

' Get Current Category
cat = TRIM( Request( "cat" ) )
IF cat = "" THEN cat = "Home"

' Open Database Connection
Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open "accessDSN"
' Open Recordset with Static Cursor
Set RS = Server.CreateObject( "ADODB.Recordset" )
RS.CursorType = adOpenStatic
RS.ActiveConnection = Con
RS.Open "Select * FROM Products"
' Display Count of Products
Response.Write "Number of products: "
Response.Write RS.RecordCount
%>

<% session("varFlashPath&quot

=Request.QueryString("FlashPath&quot

%>
<% session("varFlashName&quot

=Request.QueryString("FlashName&quot

%>
<% session("varCountryID&quot

=Request.QueryString("CountryID&quot

%>
<% session("varCountryName&quot

=Request.QueryString("CountryName&quot

%>
<% session("varProvinceID&quot

=Request.QueryString("ProvinceID&quot

%>
<% session("varProvinceName&quot

=Request.QueryString("ProvinceName&quot

%>
<% session("varCityID&quot

=Request.QueryString("CityID&quot

%>
<% session("varCityName&quot

=Request.QueryString("CityName&quot

%>

<html>
<head>

Veep · Sep 17, 2003

I'm not quite sure exactly what you're trying to do. Use those variables in a query? Add them to the database?

jdm3 · Sep 17, 2003

here is a breif discription of how this will work, the user as an exemple will not be entering any Cities or Province, as a text or any dropdowns, the User shall be clicking on a Flash Image Geographic Map, he will chose his country, then the Country map will appear, he can then choose the State or Province that he needs, If he is doing a state wide search he would search in the Search feild only Ex: "1965 Corvette"
and if a match is found in that state it will appear, If he wants also to do the search accross the entire country then he should be at the country Map wich will pull out all the 1965 Corvettes in the country, but if he wants to look closer he may click the province map then clicking on a city of choice his search would be specificly for that city. Then while at the city level, he can then do a search for any other category that he wishes to do either another car or a for an apartment. I also want it to work as if you chose on the category menu Automobile Dealerships and Chosing Toyota then all Toyota dealerships ads would appear for that City, at whatever map level that he choses, But in Order for the User to place an Ad he must chose the City that he wants the Ad to appear, if he tries to place an Ad when he only choses the Country or Province/State then he cannot place an Ad until he choses his City. Now everytime you click on the map it places the variables in the URL I want to make these variables work with the Variables that the categories, at this time I can click all the maps and the String appears in the URL as memtion Above on the first Posting, when I click on a gategory I lose my Map which disapears and the categories appear.

jdm3 · Oct 2, 2003

anyone

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Session Request Query String

jdm3

Programmer

Veep

Programmer

jdm3

Programmer

Veep

Programmer

jdm3

Programmer

jdm3

Programmer

Similar threads

Part and Inventory Search

Sponsor