Dreamweaver Club Forums

Dreamweaver Club Forums (http://www.dreamweaverclub.com/forum//index.php)
-   ASP (http://www.dreamweaverclub.com/forum//forumdisplay.php?f=187)
-   -   cannot get values on menu (http://www.dreamweaverclub.com/forum//showthread.php?t=27355)

Mapachillo 02-08-2008 09:01 PM

cannot get values on menu
 
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_...ltisearch1.asp

Buena suerte y avisa como te resulta,

Mapachillo 02-20-2008 12:04 AM

Still trying
 
Thanks!
I'm going to check out this tutorial.


All times are GMT. The time now is 08:53 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com