View Full Version : bindings + Request variable + Request.Querystring

03-30-2006, 03:39 PM
Hi all,

I have a page with 2 menus each on a separate page but included to my main page. Both menus are related and depend on each other to work.

The menus are: Main menu(prodCat) and Submenu(SubCat)

The main menu, call the submenu which in turn should display the records of my products table.
Both menus are working and retrieve data properly but one thing is killing me, When I clik on my submenu, it dissapears. It goes to another submenu.

I tried using the Bindings tab and set a request variable but it is not working any ideas?

Is there some kind of javascript code that could fix this.
BTW I'm using DWMX 2004, ASP Classic and Windows.

heeeelp pleassssssssse.

ps. here is my submenu code. in case a brilliant mind comes along....

Dim rsSubCats__MMColParam
rsSubCats__MMColParam = "True"
If (Request("MM_EmptyValue") <> "") Then
rsSubCats__MMColParam = Request("MM_EmptyValue")
End If
Dim rsSubCats__MMColParam1
rsSubCats__MMColParam1 = "0"
If (Request.QueryString("cat") <> "") Then
rsSubCats__MMColParam1 = Request.QueryString("cat")
End If
Dim rsSubCats
Dim rsSubCats_numRows

Set rsSubCats = Server.CreateObject("ADODB.Recordset")
rsSubCats.ActiveConnection = MM_connProducts_STRING
rsSubCats.Source = "SELECT tblProdSubcat.bitShow, intPCatID, intPSubCatID, txtSubCatName, intProdCatID FROM tblProdSubcat, tblProdCat WHERE tblProdSubcat.bitShow = " + Replace(rsSubCats__MMColParam, "'", "''") + " AND intPCatID = intProdCatID AND intPCatID LIKE '" + Replace(rsSubCats__MMColParam1, "'", "''") + "' ORDER BY intPSubCatID ASC"
rsSubCats.CursorType = 0
rsSubCats.CursorLocation = 2
rsSubCats.LockType = 1

rsSubCats_numRows = 0
<div id="navsubcat">
<div align="right">
While ((Repeat2__numRows <> 0) AND (NOT rsSubCats.EOF))
"><%=(rsSubCats.Fields.Item("txtSubCatName").Value)%> (http://myurl/home.asp?subcat=<%=(rsSubCats.Fields.Item() <%


Set rsSubCats = Nothing

03-30-2006, 06:19 PM
:P Thank goodness perseverance pays off. I had tried to figure out my problem for 3 days and now, as almost always, it was somthing simple, but it eluded me until now.

Solution. I had to pass a variable called "cat" that comes from the main menu and apply it to my submenu.

Anyhow. Thanks for your attention.