How can connect 3 combo box with MYSQL by java script or ASP Classic

Hi every body

I would like connect three combo box (CascadingDropDown with a Database) MYSQL by asp classic or Java Script .
But I have a problem with this example , when I will change City , returen the curser to the old select -City .

Can you Solve this problem for me.
Thanks

Expand|Select|Wrap|Line Numbers

  
Const cServer="localhost"

Const cUsername="root"

Const cpassword="123"

const cDatabaseName ="3combo"

Const cPort = "3306"
 
'===========================================

Dim objCon

Dim strDB
 
Sub openDB()

    strDB = "Driver=MySQL ODBC 3.51 Driver;server="&cServer&";uid="&cUsername&";Pwd="&cPassword&";database="&cDatabasename&";Port="&cPort&";Option=147456"

    Set objCon = Server.CreateObject("ADODB.Connection")

    objCon.open strDBEnd Sub
 
Sub closeDB()

    objCon.Close

    Set objCon = Nothing

End sub
 
'========================================

<%@ Language=VBScript %>

<!--#include file="conect.asp"-->
 
%>
 
<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Example combo box</title>
 
<script language="javascript">

<!--

function dept_onchange(frmSelect) {

    frmSelect.submit(); 

}

//-->

</script>

</head>

<body>

<div align="center">The following was selected : 
 
  <%'=Request.Form ("courses")

Dim X

Dim C

Dim D
 
X=Request.Form ("Country2")

C=Request.Form ("City2")

D=Request.Form ("Destric")
 
Response.Write(X)

Response.Write(C)

Response.Write(D)

%>
 
</div>

<form name="frmSelect" method="Post" action="combo test only.asp">

</p>

  </div>

  <table width="270" border="0" align="center" cellpadding="4" cellspacing="4">

    <tr>

      <td><SELECT name=Country2 id="Country2" style="width:144px;" onChange="return dept_onchange(frmSelect)" LANGUAGE=javascript>

        <%

Dim strSQL

Dim RS

strSQL= "SELECT DISTINCT Country FROM asocity ORDER BY ID"

'strSQL= "SELECT Country FROM asocity group by Country ORDER BY ID"
 
Call openDB

Set RS=objCon.Execute(strSQL)
 
Do while not RS.EOF

'==========================================================================

if Request.Form("Country2") = RS("Country") then
 
Response.Write "<OPTION VALUE = '" & RS ("Country") & "' SELECTED>"

Response.Write RS("Country") & "</Option>"

RS.MoveNext 

else

Response.Write "<OPTION VALUE = '" & RS ("Country") & "'>"

Response.Write RS("Country") & "</Option>"

RS.MoveNext 

end if

loop        

%></SELECT>

        Country</td>

    </tr>

    <tr>

      <td>
 
 <SELECT name=City2 id="City2" style="width:144px;" onChange="return dept_onchange(frmSelect)" LANGUAGE=javascript>

<%

Dim strSQL2

Dim RS2
 'strSQL2 = "SELECT city FROM asocity Where City= '"&C&"' group by City"
 
strSQL2 = "SELECT DISTINCT City FROM asocity Where Country= '"&X&"'"

Call openDB

Set RS2=objCon.Execute(strSQL2)

'============================================
 Do while not RS2.EOF

'==================================

Response.write ("<option>" &RS2("City")&"</option>" ) 

RS2.MoveNext

loop
 
'if Request.Form("City2") = RS2("City") then

'Response.Write "<OPTION VALUE = '" & RS2 ("City") & "' SELECTED>"

'Response.Write RS2("City") & "</Option>"

'RS2.MoveNext 

'else

'Response.Write "<OPTION VALUE = '" & RS2 ("City") & "'>"

'Response.Write RS2("City") & "</Option>"

'RS2.MoveNext 

'end if

'loop        

%>

      </SELECT>

 City</td>

    </tr>

    <tr>

      <td><select name="Destric" style="width:144px;" id="Destric">

        <%

Dim strSQL3

Dim RS3
 
strSQL3 = "SELECT username FROM asocity Where city= '"&C&"'"
 
'strSQL3 = "SELECT DISTINCT username FROM asocity Where Country= '"&X&"' ORDER BY ID"
 
Call openDB

Set RS3=objCon.Execute(strSQL3)
 
Do while not RS3.EOF

Response.write ("<option>" &RS3("username")&"</option>") 

RS3.MoveNext 

loop

%>

      </SELECT>

        Destric</td>

    </tr>

    <tr>

      <td width="254"><input type="submit" name="Submit" value="Add"></td>

    </tr>

  </table>

  <p>&nbsp;</p>

  <p>&nbsp;</p>
 
  <div align="center">

    <%

 Dim akm

 akm=Request.Form("txtArea7")
 
 if akm="" then

 akm="0000000000000"

 end if
 
 IF Request.Form("Submit")="Add" then

 Response.write (X)+"<BR>"

 Response.write (C)+"<BR>"

 Response.write (akm) 

 End if

 %>

  </div>

</form>
 
</body>

</html>

Attached Files

Exam.zip (10.3 KB, 315 views)

Aug 31 '09 #1

Subscribe Post Reply

5495

jhardman

3,406

Expert 2GB

just trying to make sure I understand you - you say that after the user makes one selection you want to move the cursor to another <select> box?

Jared

BTW, please put your code in [ code] [/ code] tags, it makes it much more readable

Sep 1 '09 #2

alandiit

Yes I want move a cursor to select a city , for example when I Select Berlin , in combobox2 , stop the cursor in the Berlin City.
For Example:
Combo box 1 : Country : Germany
Combo box 2 : City : Berlin
Combo box 3: State : G1

For More detail :
When I Select Germany in the Country Combo box 1, Show all City of Germany in the Next Combo box (Combo box2) , and when I Select Berlin in the ( Combo box2) , Return the cursor to Hamborg City ??? I have a problem in (combo box2) ?
Thanks for response us.

Sep 1 '09 #3

jhardman

3,406

Expert 2GB

OK, this is a fairly common problem, moving the cursor is going to have to be done with javascript, there's no way around that. ASP only works on the server, all ASP code is inactive by the time it gets to the user. The code to move a dursor is going to be something like this:

Expand|Select|Wrap|Line Numbers

 <select name="country" onSelect="this.form.city.focus()">

'...

</select>

<select name="city">

Does this make sense? It's been a while since I've done javascript, but it's something like that.

The other part of the question you seem to be asking is how to limit the results of the second select based on the first choice, so if the user chooses "germany" in the first box, he sees "Berlin, Hamburg, etc" in the second. As I mentioned earlier, the ASP code is inactive by the time it gets to the client's browser, so if you want to use ASP to limit the options in the second select box, you need to submit the form (onSelect="this.form.submit()") and then use asp to resend the form with the new data in place in the second box. Does this make sense? If you need help with any part of this task, please ask.

On the other hand, this might slow down the user's experience, and although I've seen plenty of professional sites that use this method, a lot of people use a pure javascript technique wherein all of the possibilities are sent to the user, and after the selection is made a javascript function alters the second select box accordingly. You will have to ask a javascript expert for that method.

There is also one other possibility, the technology "Ajax" was invented to handle exactly this type of issue, and it can communicate back to the server to refresh the list for the second select in real time. This is probably the preferred method nowadays.

Jared

Sep 6 '09 #4

Similar topics

Connect to MySQL

by: Mr Dygi | last post by:

Hi, PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a problem with this simple code: <?php $link = mysql_connect("127.0.0.1","","") or die("Could not connect: " ....

PHP

Can't connect to MySQL server on 'localhost' (10061)

by: pieter_hordijk | last post by:

Hi all, maybe this isn't a php question, but a MySQL question. If so I'm sorry for asking you guys to help me :) I know this question is asked often in NGs, but I couldn't find the answer...

PHP

cant connect to mysql server through socket

by: D. K. | last post by:

Hi; I have installed suse 8.2 a short while ago and at my first attempt to connect mysql (via shell and a perl dbi script) i get following error: can't connect to mysql server through socjet...

MySQL Database

Can't connect to mysql server with J Connector.

by: Denis Labon | last post by:

I can't connect to mysql server using the mysql-connector-java-3.0.11. I was able to run the same program when I was running Suse 9.0 but since I install Suse 9.1, I can't connect. The error...

MySQL Database

Cannot connect to MySQL DB remotely

by: Ike | last post by:

Through Java, I am attempting to connect to a MySQL 4.12 server on a remote computer. I can connect fine via php. I cann connect fine via Java, through a servlet, when the servlet is on the same...

MySQL Database

Unable to connect to MySQL database... what's 'hostname'?

by: iceboy | last post by:

Hello to all,I have a problem to connect PHP & MySQL together. I have created a form that gets the username & password from admin and connect him to database.the part of PHP script that connect to...

PHP

Client Side Vs Server Side Java Script

by: Ankur | last post by:

Hi Folks, I am new for this group. I want to clarify one thing what's a basic difference between Client Side Java Script and Server Side Java Script. how we can differentiate it. Why we called...

Javascript

cannot connect to mysql with jsp??

by: hkma08 | last post by:

I dont know I should post JSP error in here or not. If not please redirect me to another one. Thx. I just installed apache tomcat with mysql with java, but i got error when try to connect to mysql...

Java

Re: Java script on classic ASP page

by: Anthony Jones | last post by:

"paulmitchell507" <paulmitchell507@googlemail.comwrote in message news:effe22fb-7c85-4172-953d-d6546cd548f8@c58g2000hsc.googlegroups.com... On Aug 12, 1:06 pm, "Anthony Jones"...

ASP / Active Server Pages

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA