logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > ASP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 02-08-2008, 09:01 PM   #1
Mapachillo
 
Join Date: Feb 2008
Posts: 3
Default 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???
__________________
IM A NOOB!
Mapachillo is offline   Reply With Quote
Old 02-08-2008, 09:13 PM   #2
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

we have an ASP guy (mangofreak)

he will be along shortly to sort you out
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Old 02-09-2008, 08:20 PM   #3
mangofreak
mangofreak's Avatar
 
Join Date: Jan 2006
Location: Toronto-Canada
Posts: 444
Default

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,
__________________
J.
DW | FW | HTML | CSS | ASP | some PHP | Windows | Ubuntu
mangofreak is offline   Reply With Quote
Old 02-20-2008, 12:04 AM   #4
Mapachillo
 
Join Date: Feb 2008
Posts: 3
Default Still trying

Thanks!
I'm going to check out this tutorial.
__________________
IM A NOOB!
Mapachillo is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:38 PM.


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