I'm using the following code to pull productnames and extensions of the products into a form, and I want to submit the data back to the database later.
The problem is with this bit of code
<option value="location.href='exis
in the source of the working page the Value of the string ends up apearing as a large string including "location.href='existingRe
Can anything be done to fix this?
And is there a way of getting around the page submitting to itself? can this be done in the background?
<td>Product Type <%
Dim ConnString
ConnString = "DSN=DBSERVER;uid=dba;pwd=
Dim objConn
Set objConn = Server.CreateObject("ADODB
objConn.ConnectionString = ConnString
objConn.Open
%>
<%
dim objSQL, objRS
objSQL = "select ProductName from SerialRanges where Status = 'A' and PType ='x' "
set objRS = objConn.execute(objSQL)
%>
<script language="Javascript">
function doSel(obj)
{
for (i = 0; i < obj.length; i++)
if (obj[i].selected == true)
eval(obj[i].value);
}
</script>
<select name="ProductName" Class="form" onchange="doSel(this)">
<%
do while not objRS.EOF
%>
<option value="location.href='exis
<%
objRS.movenext
loop
%>
</select>
<%
objRS.close
set objRS = nothing
%>
</td>
<td>Units <input type="text" name="Units" size="5" class="form"></td>
<td>From: XX-XX-XXXX To: XX-XX-XXXX </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"><table class="cellborder_content3
<tr><td class="cellborder_content3
<table class="cellborder_content3
<tr>
<%
if request.querystring("str")
Dim objConn1
Set objConn1 = Server.CreateObject("ADODB
objConn1.ConnectionString = ConnString
objConn1.Open
%>
<tr><td width="33%">Name</td><td width="33%">Units</td><td width="33%">Expiery Date</td></tr>
<%
dim objSQL1, objRS1
objSQL1 = "select ProductName from SerialRanges where PType = '" & request.querystring("str")
set objRS1 = objConn1.execute(objSQL1)
do while not objRS1.EOF
%>
<tr> <td><input type="checkbox" name="chkbox" value="<%=objRS1("ProductN
<td><input type="text" name="<%=objRS1("ProductNa
<td><input class="form" name="<%=objRS1("ProductNa
<%
objRS1.movenext
loop
objRS1.close
set objRS1 = nothing
end if
%>
<%
objConn.close
set objConn = nothing
%>
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Why don't you use location.href from javascript itself. If URL its constant, just use it from javascript and keep only data value in value os of option
<option value="<%=objRS("ProductNa
and in javascript
function doSel(obj)
{
for (i = 0; i < obj.length; i++)
if (obj[i].selected == true)
eval(obj[i].value);
}
location.href='existingRec
</script>
P.S. <%=%> asp tag will work in javascript
ASP is getting confused between your delimiters.
Try the following:
Dim strOption
strOption = "<option value=""location.href='exi
If Request.QueryString("str")
strOption = strOption & " selected"
End If
strOption = strOption & ">" & objRS("ProductName") & "</option>"
Response.Write strOption
This should work!
Regards
bukko
hehe: javascript is the answer alright:
<option value="JavaScript:location
simply add the "JavaScript:" perogative before your statement... ;)
Max!
You can't use javascript in an option value.
ANd if all you want is the product name, get it from the database.
<option value="<%=objRS("ProductNa
<%if request.querystring("str")
selected
<%end if%>><%=objRS("ProductName
Which should give you this output
<option value="product Name" selected>Product Name</option>
No javascript
Note: this is basically hongjun's answer, just formatted differently.
>>jitganguly
The page kept reloading .... trhe url would flash in the address bar, page was blank and reload was almost instant. without having you see it thats the best I can describe it.
What I need to do is very simple. Same page (URL) is ok, loading back onitself is ok. I just want to get rid of the extra tex in the value tag of the option. And the code still has to work so theat the database populated pull down populates the checkboxes below.
You're mixing up client side and server side. You CANNOT put javascript in an option tag. Never will work.
The javascript should key off the selection of an option -- and that's TOTALLY client side. You use an ONCHANGE for that. CLIENT SIDE -- it has NOTHING to do with actually generating the option values.
What EXACTLY are you trying to do? If you want to go to another page when somebody picks an option, you're going about it COMPLETELY wrong.
WebWoman
I'm not doing anything wrong the page works as it is. It functions fine, when I select a product from the dropdown the page reloads and I am presented with the subselections for that product. Everything is pulled from my database, take a look at the code in my first posting.
The problem is if you load up the page make the selection, then do a view source, the VALUE of the product displays as "location.href='existingRe
gpyper,
As I understand it you want to get the value of the dropdown back into the database...
To get around this... I assume that the page is inside the form...
Since the option value is the location.href='existingRec
Now put a hiddenfield and then paste here the vale of the request.querystring
<input type="hidden" name="hiddenField" value="request.querystring
When you pass the page later(saving into the db) you will just refer to the hiddenfield value and not the dropdown...
HTH...
Happy programming...
Reading thru the thread
>>>>>>
The problem is if you load up the page make the selection, then do a view source, the VALUE of the product displays as "location.href='existingRe
>>>>>>
gpyper,
You dont need to do anything with the code
just add this one line of code and it will fixed the probelm...
<input type="hidden" name="hiddenField" value="request.querystring
HTH...
Happy programming...
gpyper, if your trying to load a page based on the selected product name then why not just submit the values?
<%
dim paramstr
dim prodname
paramstr = request.querystring("str")
%>
[....]
<form action="existingRecord.asp
<select name="str" Class="form" onchange="javascript:docum
<%
do while not objRS.EOF
prodname = objRS("ProductName")
%>
<option value="<%=prodname%>'" <%if paramstr=prodname then%>SELECTED<%end if%>><%=prodname%></option
<%
objRS.movenext
loop
%>
</select>
</form>
gpyper,
The code looks familiar....
The method will be most helpful when you want a database dynamic dropdown... At the same time checking/validating using javascript when you hit submit...
That is why I dont use this method document.prodselect.submit
But the workaround that I've used for this is to put the real value of the dropdown into the hidden field...
Just like I have mention on my prevoius post...
Regards,
Glad
Business Accounts
Answer for Membership
by: hongjunPosted on 2003-01-30 at 08:29:16ID: 7846842
Do this then
<option value='<%=objRS("ProductNa
hongjun