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 08: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_numRows = 0

Can someone help me???

davidj 02-08-2008 08:13 PM

we have an ASP guy (mangofreak)

he will be along shortly to sort you out

mangofreak 02-09-2008 07: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:


Buena suerte y avisa como te resulta,

Mapachillo 02-19-2008 11:04 PM

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

All times are GMT. The time now is 04:48 PM.

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