PDA

View Full Version : cannot get values on menu


Mapachillo
02-08-2008, 09:01 PM
Im trying to call values from a data base on a menu. So that when a customer select a car make, the models of that car appear on a different menu. But when im trying to do so it appears as it cannot find the menu.

What i have so far is this:

<%
Dim Marca2
Dim Marca2_numRows
Set Marca2 = Server.CreateObject("ADODB.Recordset")
Marca2.ActiveConnection = MM_Nap_STRING
Marca2.Source = "SELECT Modelo FROM dbo.tblModelos WHERE Yearslisting LIKE '%00%' AND Marca = " & CBOmodelo.value

//if i place this code: Marca2.Source = "SELECT Modelo FROM dbo.tblModelos WHERE Yearslisting LIKE '%00%' AND Marca = " & "'hd'" -- it does who me the values from that variable//
Marca2.CursorType = 0
Marca2.CursorLocation = 2
Marca2.LockType = 1
Marca2.Open()
Marca2_numRows = 0
%>

Can someone help me???

davidj
02-08-2008, 09:13 PM
we have an ASP guy (mangofreak)

he will be along shortly to sort you out

mangofreak
02-09-2008, 08:20 PM
Hola Mapachillo,

check this out. Here is a tutorial for similar type of application. Although it is done with MS access it should app;ly nicely to your problem:

http://www.webthang.co.uk/Tuts/tuts_dmx/gk_search1/multisearch1.asp

Buena suerte y avisa como te resulta,

Mapachillo
02-20-2008, 12:04 AM
Thanks!
I'm going to check out this tutorial.