corresponding db value in the text input box for the value in selection menu

638 512MB

hi there i have a tbl in db which has following fields
table name:stock
id_no(primary key...autono)
part_name(text)
price(currency)

now i have an asp and htmlbased form in which i have made a selection menu and an input field right under it
what i want is that my drop dow selection menu should have the total no of parts that are placed in the database and as soon as the user selects any of the parts,in the very next input field the same price saved in the db for that part should appear what i have done till now is as following i have made the selecion menu containing the db values of the field part_name and its working perfectly fine now what i want is that if i select name of any part no its corresponding price should appear in the text input box named "price" what should i be doing can any body help

Expand|Select|Wrap|Line Numbers

 
<%

set r=Server.CreateObject("ADODB.Recordset")

connstr="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb")

strSQL="Select * from sotck;"

r.open strSQL, connstr, 3

%>

    <td class="add"><div align="left">Customer Name:</div></td>

    <td width="150" align="Center" valign="Center"><div align="left">

    <SELECT name="cust_name" style="width:194px; height:17px; font-size:11px; font-family:tahoma; border-style:solid; border-width:1px; border-color:#4C4A48; color:#8C8B89; background-color:#0A0501 ">

        <option value="none" selected="selected">Please select a Customer</option>

        <%while not r.EOF%>

        <option value="<%=r.Fields("part_name")%>"><%Response.Write(r.Fields("part_name"))%></option>

    <%r.Movenext            

    wend%>

    </SELECT>

    </div></td>

    <td class="add" ><div align="left">Price:</div></td>

    <td width="150" align="Center" valign="Center"><div align="left"><input name="price" type="text" size="25" style="width:194px; height:17px; font-size:11px; font-family:tahoma; border-style:solid; border-width:1px; border-color:#4C4A48; color:#8C8B89; background-color:#0A0501 "></div></td>

Nov 29 '07 #1

Subscribe Post Reply

1721

stepterr

157

100+

Try using the onchange event in your drop down list so that when they make the selection for the part you can call another function that will query your database for the price where the part is equal to the selection that they made. Then you can just display that result in your textbox

Nov 30 '07 #2

omerbutt

638

512MB

nice try to get started
its not all that simple i know i have to call an onchange method to cal js funtion which would get the current value of the part ..but..there are aloots of things that i had to manage i had already done alot work on it but its kind of mess ya know
i got the code lets see if you can help more than i know

Expand|Select|Wrap|Line Numbers

 
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

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

<title>Untitled Document</title>

<script type="text/javascript">

function price(pval)

{

Stamp = new Date();

var xmlHttp

var t

try

{

// Firefox, Opera 8.0+, Safari

xmlHttp=new XMLHttpRequest();

}

catch (e)

{

// Internet Explorer

try

{

xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

}

catch (e)

{

try

{

xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

}

catch (e)

{

alert("Your browser does not support AJAX!");

return false;

}

}

}

xmlHttp.onreadystatechange=function() {

if(xmlHttp.readyState==4) {

document.getElementById("cust").value=xmlHttp.responseText

}

}

xmlHttp.open("GET","test2.asp?cred_lim="+pval+"time=" + Stamp,true);

xmlHttp.send(null);

}

</script>

</head>
 
<body>

<%

set r=Server.CreateObject("ADODB.Recordset")

connstr="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb")

strSQL="Select * from Cust;"

r.open strSQL, connstr, 3

%>

<td class="add"><div align="left">Customer Name:</div></td>

<td width="150" align="Center" valign="Center"><div align="left">

<SELECT name="cust_name">

<option value="none" selected="selected">Please select a Customer</option>

<%while not r.EOF

Dim nik=r.Fields("Cust_name")%>

<option value="<%=r.Fields("Cust_name")%>" onclick="price('nik');"><%Response.Write(r.Fields("Cust_name"))%></option>

<%r.Movenext

wend%>

</SELECT>

</div></td>

<td class="add" ><div align="left">Cred limit:</div></td>

<td width="150" align="Center" valign="Center"><div align="left"><input name="cred_lim" type="text" size="25" id="prc"></div></td> 

</body>

</html>

Try using the onchange event in your drop down list so that when they make the selection for the part you can call another function that will query your database for the price where the part is equal to the selection that they made. Then you can just display that result in your textbox

Dec 1 '07 #3

omerbutt

638

512MB

gud try to get started :D
well i got the solution for it i got to use AJAX ;) buddy cause other wise i will not be able to do that javascript does not support writing SQL queries that much and thats y uses forms and button to submit the data and communicate with the server and a new page will load showing the results for the selected serch or records added where as AJAX uses http response objects which don let u redirect or load another page and show the queried values or result on the same page without re-loading [;)]

Try using the onchange event in your drop down list so that when they make the selection for the part you can call another function that will query your database for the price where the part is equal to the selection that they made. Then you can just display that result in your textbox

Dec 1 '07 #4

by: Mark R | last post by:

I have one .asp page with a SELECT pulldown list on it and some INPUT fields. When SUBMIT is clicked the form data is submitted to that same page and validated. If INPUT fields are empty the asp...

ASP / Active Server Pages

passing checked value of radio button to js function from form submit

by: jason | last post by:

The following (likely far from imperfect code), reports a value of NaN in the j4 display. I suppose the problem is I am not really passing the "checked" value of the radio button via .value ......

Javascript

Cannot Read Value from Drop Down Script

by: Dan | last post by:

This is one that has me stumped and I need an expert's input. Any ideas why the values from the second script-generated drop down list isn't recognized by the script to add time values to the...

Javascript

Validating TextField dependent on List/Menu value

by: platostoteles | last post by:

Hallo NG, I am new to JavaScript and would really appreciate any help to solve my problem. I am using the blow code in my form to validate form fields. What I would like to accomplish is that...

Javascript

dropdown menu over text 2 / to see the behavior ...

by: jweinberg1975 | last post by:

I would like for users to be able to select from a small number of options that come from a little drop down menu which then closes. .....

Javascript

smarty using index to get the value in array

by: sksksk | last post by:

I want to achieve the following process in the smarty for $item one i should be able to get the value using loop.index, but without any luck. any help is appreciated. <?php for ($i = 1; $i...

PHP

change the textbox value depending on selection made in dropdown

by: manishamca | last post by:

In dropdown i am retriving value from the backend. For eg: in the dropdown list the value selected are employee id..then i want to disply the emp name,job etc in the textbox. If i select a...

Java

Element offsetLeft producing a wrong value in IE6

by: montybytes | last post by:

Hi there, Although, I have already placed this question in the HTML/CSS section, perhaps it might be worthwhile asking the question here as well. I have a JavaScript function which retrieves...

Javascript

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

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++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

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

corresponding db value in the text input box for the value in selection menu

Similar topics