Cant populate and disable text boxes according to DD value selected!!

countdrak · Aug 5, 2003

Here is what I am trying to do.

I have a Car Information table. I have four fields- Car_id,Car_Description, Car_Make, Car_Model.

Now I have a coldfusion form with a drop down list that I poulate witht he descriptions. And then I have text-fields for the other three fields.
Now lets say we have Car_Descrption=Blue Car , Car_Make=Ford
Car_Model=Mustang and Car_Id=1.

I everytime the user select the Car_Decription from the Drop Down List..I want the corresponding Make,Model to be displayed on the page in text boxes and diable them, so users cant change or write to it. I dont know how to do it.

Can someone please help. This the code i have till now.

<cfquery name="CarTypeDD" datasource="CarMileage">
SELECT Car_Description
FROM Car_Info
ORDER BY Car_year DESC
</cfquery>

<html>
<head>
<title>Car Mileage System</title>
Choose a car:
<select name="CarType">
<cfoutput query="CarTypeDD">
<option value="#CarTypeDD.Car_Description#">
#CarTypeDD.Car_Description#
</option>
</cfoutput>
</select>
</p>
Make:
<input type="text" name="textfield9">

Model:
<input type="text" name="textfield10">

<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

Wiszh · Aug 5, 2003

You need to submit the form every time a car is selected and then load the fields with the appropriate values. (If you don't want your users to edit the fields, then just print them on the screen as text rather then put them in a textbox.

Good Luck

countdrak · Aug 5, 2003

Can you show me an example? or make changes to my code.
Thanks for the help.

RayGibbins · Aug 6, 2003

The best way is to create some dynamic VBScript.

You will have to edit the field names but should at least get you started....

<CFQUERY datasource="XXXXXXXXX" NAME="CarTypeDD">
SELECT Car_id, Car_Description, Car_Make, Car_Model, Car_Year
FROM Pubs.dbo.Car_Info
ORDER BY Car_Year
</cfquery>

Choose a car:
<select name="CarType" onchange="GetDetails()">
<cfoutput query="CarTypeDD">
<option value="#CarTypeDD.Car_Description#">
#CarTypeDD.Car_Description#
</option>
</cfoutput>
</select>
</p>

<INPUT type="Text" name="CarMake" disabled>
<INPUT type="Text" name="CarYear" disabled>
<INPUT type="Text" name="CarModel" disabled>

<SCRIPT language="VBScript">

SUB GetDetails()

<CFOUTPUT query="CarTypeDD">
IF CarType.Value = "#Car_Description#" THEN
CarMake.Value = "#Car_Make#"
CarModel.Value = "#Car_Model#"
CarYear.Value = "#Car_Year#"
END IF
</cfoutput>

END SUB

</script>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Cant populate and disable text boxes according to DD value selected!!

countdrak

Programmer

Wiszh

Programmer

countdrak

Programmer

RayGibbins

Programmer

Similar threads

Part and Inventory Search

Sponsor