We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
COURSE of the MONTH
15 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Select Statement help please...
Posted on 2006-10-22
HI.
OK - I am not an HTML programmer - I am a VB Programmer and I understand HTML and this is our first venture into ASP with HTML - and I'm stuck.
The Problem.
We have designed a web site for a heavy plant machinery customer where by they can advertise for sale pieces of plant.
The web site, which we have adopted from another web site allows the user to upload a photo and add description price etc etc.
The problem is when they come to edit an entry. We have added a select statement that allows them to choose from a specific list of equipment type and for a new entry this works fine, but when they edit the item the same select list is used but it defaults to the first item in the select list.
What we require is the field to display the current selection that has been saved in the access database - with also the ability to use the drop down list and select a different model type if required.
Our standard field code looks like this:
<input name="Price" size="40" value="<%=rs("Price")%>"><
Our Select Statement looks like this:
<select name="Type" size="1" value="<%=rs("Type")%>">
<option VALUE="BackHoe/Loaders">Ba
<option VALUE="Breakers">Breakers
<option VALUE="Compressors">Compre
<option VALUE="Dumpers">Dumpers
<option VALUE="Excavators">Excavat
<option VALUE="Misc">Miscellaneous
<option VALUE="Mixers">Mixers
<option VALUE="Rollers-Tandem/Pede
<option VALUE="Skid Steel Loaders">SkidSteelLoaders
<option VALUE="Telescopic Handlers/Forklifts">Telesc
</select>
</tr>
<tr>
However the above code section - value="<%=rs("Type")%>"> does not display the stored database value - instead is SHOWS (But has not been stored yet) the first int he select list - "BackHoe/Loaders"
Could anyone provide me with the actual code I need.
Many thanks
Andy.
OK - I am not an HTML programmer - I am a VB Programmer and I understand HTML and this is our first venture into ASP with HTML - and I'm stuck.
The Problem.
We have designed a web site for a heavy plant machinery customer where by they can advertise for sale pieces of plant.
The web site, which we have adopted from another web site allows the user to upload a photo and add description price etc etc.
The problem is when they come to edit an entry. We have added a select statement that allows them to choose from a specific list of equipment type and for a new entry this works fine, but when they edit the item the same select list is used but it defaults to the first item in the select list.
What we require is the field to display the current selection that has been saved in the access database - with also the ability to use the drop down list and select a different model type if required.
Our standard field code looks like this:
<input name="Price" size="40" value="<%=rs("Price")%>"><
Our Select Statement looks like this:
<select name="Type" size="1" value="<%=rs("Type")%>">
<option VALUE="BackHoe/Loaders">Ba
<option VALUE="Breakers">Breakers
<option VALUE="Compressors">Compre
<option VALUE="Dumpers">Dumpers
<option VALUE="Excavators">Excavat
<option VALUE="Misc">Miscellaneous
<option VALUE="Mixers">Mixers
<option VALUE="Rollers-Tandem/Pede
<option VALUE="Skid Steel Loaders">SkidSteelLoaders
<option VALUE="Telescopic Handlers/Forklifts">Telesc
</select>
</tr>
<tr>
However the above code section - value="<%=rs("Type")%>"> does not display the stored database value - instead is SHOWS (But has not been stored yet) the first int he select list - "BackHoe/Loaders"
Could anyone provide me with the actual code I need.
Many thanks
Andy.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
-
2
- +1
7 Comments
Active today
try this...
<%
function chkOpt(v1, v2, selectedValue)
if v1 = v2 then
chkOpt = selectedValue
else
chkOpt = ""
end if
end function
%>
<select name="Type" size="1">
<option VALUE="BackHoe/Loaders" <%=chkOpt("BackHoe/Loaders
<option VALUE="Breakers" <%=chkOpt("Breakers","" & rs("Type"), " selected")%>>Breakers
<option VALUE="Compressors" <%=chkOpt("Compressors",""
<option VALUE="Dumpers" <%=chkOpt("Dumpers","" & rs("Type"), " selected")%>>Dumpers
.....
<option VALUE="Telescopic Handlers/Forklifts" <%=chkOpt("Telescopic Handlers/Forklifts","" & rs("Type"), " selected")%>>Telescopic Handlers/Forklifts
</select>
?
<%
function chkOpt(v1, v2, selectedValue)
if v1 = v2 then
chkOpt = selectedValue
else
chkOpt = ""
end if
end function
%>
<select name="Type" size="1">
<option VALUE="BackHoe/Loaders" <%=chkOpt("BackHoe/Loaders
<option VALUE="Breakers" <%=chkOpt("Breakers","" & rs("Type"), " selected")%>>Breakers
<option VALUE="Compressors" <%=chkOpt("Compressors",""
<option VALUE="Dumpers" <%=chkOpt("Dumpers","" & rs("Type"), " selected")%>>Dumpers
.....
<option VALUE="Telescopic Handlers/Forklifts" <%=chkOpt("Telescopic Handlers/Forklifts","" & rs("Type"), " selected")%>>Telescopic Handlers/Forklifts
</select>
?
for the <select> tag we do not have to have the "value" attribute, instead it should be for the <option> tag:
Here is one sample HTML which you can try it out:
<html>
<head>
<title>Select</title>
<script language="javascript">
function dispVal(obj){
alert("You have Chosen: "+obj[obj.selectedIndex].v
}
</script>
</head>
<body>
<form name="testSelect">
<select name="test" onchange="javascript:dispV
<option value="No Value" selected>-- Select --
<option value="First Value">Value 1
<option value="Second Value">Value 2
<option value="Third Value">Value 3
<option value="Fourth Value">Value 4
</select>
</form>
</body>
</html>
Here is one sample HTML which you can try it out:
<html>
<head>
<title>Select</title>
<script language="javascript">
function dispVal(obj){
alert("You have Chosen: "+obj[obj.selectedIndex].v
}
</script>
</head>
<body>
<form name="testSelect">
<select name="test" onchange="javascript:dispV
<option value="No Value" selected>-- Select --
<option value="First Value">Value 1
<option value="Second Value">Value 2
<option value="Third Value">Value 3
<option value="Fourth Value">Value 4
</select>
</form>
</body>
</html>
...please close option tags :)
<option VALUE="BackHoe/Loaders">Ba
<option VALUE="Breakers">Breakers<
<option VALUE="Compressors">Compre
<option VALUE="Dumpers">Dumpers</o
<option VALUE="Excavators">Excavat
<option VALUE="Misc">Miscellaneous
<option VALUE="Mixers">Mixers</opt
<option VALUE="Rollers-Tandem/Pede
<option VALUE="Skid Steel Loaders">SkidSteelLoaders<
<option VALUE="Telescopic Handlers/Forklifts">Telesc
...humor me about the ASP (it's been a while). I assume that rs represents a single record from the database? If not won't you need to iterate through many records to retrieve the data?
...any way. Typically I believe what you're looking fro is to have a code render block within the select tag that fills the value and text for each option tag. This would be accomplished with a loop, typically you'll use the primary key of the lookup table as the value. Makes for quicker processing once you submit.
Cheers,
Jesse
<option VALUE="BackHoe/Loaders">Ba
<option VALUE="Breakers">Breakers<
<option VALUE="Compressors">Compre
<option VALUE="Dumpers">Dumpers</o
<option VALUE="Excavators">Excavat
<option VALUE="Misc">Miscellaneous
<option VALUE="Mixers">Mixers</opt
<option VALUE="Rollers-Tandem/Pede
<option VALUE="Skid Steel Loaders">SkidSteelLoaders<
<option VALUE="Telescopic Handlers/Forklifts">Telesc
...humor me about the ASP (it's been a while). I assume that rs represents a single record from the database? If not won't you need to iterate through many records to retrieve the data?
...any way. Typically I believe what you're looking fro is to have a code render block within the select tag that fills the value and text for each option tag. This would be accomplished with a loop, typically you'll use the primary key of the lookup table as the value. Makes for quicker processing once you submit.
Cheers,
Jesse
Andy there is a small change. Ignore the previous and try out this code:
<html>
<head>
<title>Test Div over Select</title>
<style>
.ac_menu
{
border:1px solid black
}
.ac_normal
{
background-color:#ffffff;
cursor:pointer;
}
</style>
<script language="">
function loadFrame(){
var DivRef=document.getElement
var IfrRef=document.getElement
IfrRef.style.position="abs
IfrRef.style.width=DivRef.
IfrRef.style.height=DivRef
IfrRef.style.top=DivRef.st
IfrRef.style.left=DivRef.s
IfrRef.style.zIndex=DivRef
IfrRef.style.display="";
}
</script>
</head>
<body onload="loadFrame();">
<iframe id="DivShim" style="display:none;positi
<div id="ac_menu1" class="ac_menu" style="visibility: visible; position: absolute; z-index: 100; ">
<div class="ac_normal">
simple
</div>
<div class="ac_normal">
simple text
</div>
<div class="ac_normal">
simple text to
</div>
<div class="ac_normal">
simple text to cover a
</div>
<div class="ac_normal">
simple text to cover a select
</div>
<div class="ac_normal">
simple text to cover a select box
</div>
</div>
<select id="testSelect" size="5" multiple="yes">
<option value="1">test 1</option>
<option value="2">test 2</option>
<option value="3">test 3</option>
<option value="4">test 4</option>
<option value="5">test 5</option>
</select>
</body>
</html>
<html>
<head>
<title>Test Div over Select</title>
<style>
.ac_menu
{
border:1px solid black
}
.ac_normal
{
background-color:#ffffff;
cursor:pointer;
}
</style>
<script language="">
function loadFrame(){
var DivRef=document.getElement
var IfrRef=document.getElement
IfrRef.style.position="abs
IfrRef.style.width=DivRef.
IfrRef.style.height=DivRef
IfrRef.style.top=DivRef.st
IfrRef.style.left=DivRef.s
IfrRef.style.zIndex=DivRef
IfrRef.style.display="";
}
</script>
</head>
<body onload="loadFrame();">
<iframe id="DivShim" style="display:none;positi
<div id="ac_menu1" class="ac_menu" style="visibility: visible; position: absolute; z-index: 100; ">
<div class="ac_normal">
simple
</div>
<div class="ac_normal">
simple text
</div>
<div class="ac_normal">
simple text to
</div>
<div class="ac_normal">
simple text to cover a
</div>
<div class="ac_normal">
simple text to cover a select
</div>
<div class="ac_normal">
simple text to cover a select box
</div>
</div>
<select id="testSelect" size="5" multiple="yes">
<option value="1">test 1</option>
<option value="2">test 2</option>
<option value="3">test 3</option>
<option value="4">test 4</option>
<option value="5">test 5</option>
</select>
</body>
</html>
Hi Folks.
Thanks for all your help.
The problem has been sorted and I will accept RYANCYS answer. My personal opinion is that Ryan's answer was the simplest and I understood it more because it looked more like a VB function - implementation worked the first time and seem's the cleanest - that said I would like to split the points between you all with most going to Ryan. I am concious that people take the time to help each other and I think that in itself deserves a reward.
Thank you all.
Andy
Thanks for all your help.
The problem has been sorted and I will accept RYANCYS answer. My personal opinion is that Ryan's answer was the simplest and I understood it more because it looked more like a VB function - implementation worked the first time and seem's the cleanest - that said I would like to split the points between you all with most going to Ryan. I am concious that people take the time to help each other and I think that in itself deserves a reward.
Thank you all.
Andy
Andy actually my second was a wrong post, it was entirely for a different query. Sorry for this but my first post was entirely for you and it is a valid one.
Featured Post
The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.
See if your editor made the list.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
In this tutorial viewers will learn how to position items using CSS's three positioning types
Create a new HTML document with an internal stylesheet.: Create another div in CSS and name it Absolute : Type "position:absolute;" and "top:10px; left:50p…
The viewer will receive an overview of the basics of CSS showing inline styles.
In the head tags set up your style tags:
(CODE)
Reference the nav tag and set your properties.: (CODE)
Set the reference for the UL element and styles for it to ensu…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll
771 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.