I am trying to pass a value into the text field on selecting the option in a drop down. The code works if the 'For' loop is not included. What should I do to make it work inside the loop? Code:
View Replieshow to i passing values to text field?
<input type="text" name="Usrname" size="20" value=<%= fullname %> >
i knew this is wrong.. but how do i solve this problem?
is it possible to do a for loop inside of a Do while not.
View Replies View RelatedIs it common practice to create a recordset object inside of a loop? Does it create multiple connections to the database?
View Replies View RelatedThere are two table in my Access database e.g. people and orders. There is a one-to-many relationship between these. At the moment I get a recordset of all the people. I put the results of this into an array (using GetRows) and close the array and set it to Nothing.
Then on the page I have a loop which goes through the array of people and for each one performs a different db search of all the order linked to that person. On the page I have got it displaying the people perfectly but for each search the RecordCount is coming out as -1. Yet, I know there are orders associated with each person.
I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
Could anyone tell me how to select the first three characters in a string, then put inside into another string.
View Replies View RelatedI am reading about 200 records from dbf file in ASP code and inserting into a table. I fetch the records in a recordset and in the recordset loop I have to insert it into the SQL table.
How should I insert the values?
1) Should I use query in ASP page
2) Or call stored procedure (passing each record parameter) for inserting, 200 times in the loop
I have an ASP page connected to an Access database table. Im wondering of an easy do while loop which will go through each of the records in a specific column and add them up.
Do While Not objRS.EOF
objRS.MoveNext
'Code to add the sum to TotalNumberValue using objRS("NumberValue") recordset
Loop
I have an ASP page that has 2 List Boxes. The first List Box contains available items and the 2nd list box contains selected items. Code:
<select name="lstAvailable">
<option value=”1”>User 1</option>
<option value=”2”>User 2</option>
<option value=”3”>User 3</option>
</select>
<select name=”lstSelected”>
</select>
I have JavaScript that populates the lstSelected when items are clicked on from the lstAvailable list box.
When the user presses the Submit button, a 2nd ASP page actually does the insert. My problem is that I do not know how to retrieve the value from the 2nd list box (lstSelected) from the 2nd ASP page. I need to do an insert for each item in the selected list box.
I have tried using Request.Form(“lstSelected”) but that did not work. I also tried a For next loop but I could not get that to work either.
Can someone help me figure out how to loop through all values in the lstSelected list box from the 2nd ASP page?
I don't know if this is possible, but I have a Do While Not rs.EOF loop that is pulling values from a SQL database and writes it to an html form. I'm trying to figure out how to tally the values as they are siphoned from the database -- I'm assuming I have to set a unique variable equal to that value as it goes through the loop, but I'm not certain how to pull it off. Code:
View Replies View RelatedI am using a ASP.NET function that returns a table with columns and rows and data (in the cells) taken from my DB (using ado.NET). That function actually returns a set of HTML tags with values, Labels and input boxes. All of that is working fine but now (after the function build that form whith that table) I want the user to fill some of the input boxes located in the last column.
The problem is that i do not know how many input text boxes had been changed by the user (different rows) and i need to manage all the input data of those input boxes.
in VB.NET I can use a loop which goes for each and rvery control and take its text (or value) property.
How can I do that here ?
How can i chack each of the input boxes values using a loop (becuse that input boxes had been filled accourding to a database and in additional the user changed/Add values to some of them ?
for information, to fill the that table i am using a loop that filled the table rows and values accourding to the rows in the DataBase and names of those inputboxes called: "Amount_" & i the "i" is an index which represent the row in the database.
How at the start of script can I dynamically loop through all Request.form variables and use them ? either name or the value, both is the ideal though.
example.
have a form:
2 textfields. named "text1" and "text2"
In asp I need to dynamically grab this data not knowing that this form had the textfields "text1" and "text2".
ideal print:
name "text1"
value of text 1
name "text2"
value of text2
I have just registered as I have found this very useful saveas asp script but I want to modify it to read in a list of image url's from a text file and save them automatically
Can anyone help me with the looping code to do this?
Is there a code, or something that scrambles the value being passed fromone asp page to another??
what I mean is this:
if i want to pass a value from a database (record id #721) from my page records.asp to recordview.asp
it might appear like this in the browser window, or when u highlight the link on records.asp:
recordsview.asp?K=751
I don't want users to see exactly what record number is being access... so I'd like it to show some garbage in the browser like
recordsview.asp?@$@#$=DSFSD+jklsjkld
you get my drift...
I have a submit form that collects my values, and if my form action is "mailto" the values are passed, but if I try to pass to another asp page the values aren't sent and the asp doesn't execute.
View Replies View Relatedi m using frontpage to create a login form using SQL SERver database. i want 2 redirect the value of username & password to another page.
View Replies View RelatedI have the following
pn = rs("PrinterName")
I put a response.write (PN) and it displays the correct print name
Later down the code I put in
<input type="hidden" name="PN" value=" & PN & ">
<input type="submit" value="Add Maintenance Record" name="cmdAddMaint"
onClick="window.open('addMaint.asp','addWindow','width=500, height=300')">
Then on the AddMaint.ASP page I have
PN = Request.Form("PN")
how can i pass value to next page when user click on link ? i can pass one values but can not pass another value please look at the code
Code:
<td align= "center"><a href="message.asp?ftopicid=<%response.write(result("fid"))%>"><input type="hidden" name="FForumID" value="<%request.querystring("FTopicID")%>"><%=result("fsubject")%></a></td>
i am trying to pass FForumID and FTopicID
I have a page which has a form in it. The form allows the user to pick a date and when he hits submit, he sees sales for that particular period of time. That works.
However, once he sees the sales for a particular time period, he has the option to click on a branch and see the breakdown of sales for that date.
I have that as a separate page and can't figure out how to pass the date to the new page. Right now when he clicks on the branch it says 0.00 because it doesn't think there is a date.
I'm passing date and time value to next page but at next page I am getting only date part. I'm not getting time part...why?
Suppose I'm passing this value 21-Oct-2005 16:11 but at next page I am getting only
21-Oct-2005
IssueDate =Server.HtmlEncode(Trim(objRs("issuedate")))
<input type=checkbox name=confirm_"& ObjID &" value="&IssueDate&"> ....
I have a text box.. and next to that I have a link , clicking on which will open a window , pasing value of that text box , to that new window.
View Replies View RelatedI have an ASP called seat_add.asp, when it is initially called I send it three values
sead_add.asp?sitenum=xx&site_name=xx&ttype=xx
within the ASP i have two forms because I am loading one dropdown from a access DB and when the user selects something from the list dropdown two is then loading using information from the selection in dropdown 1 in the SQL query.
This is done via an onchange(this.form.submit) on the first form. I am losing my values and I am not sure as to why?
I have a shopping cart displayed in a ASP.NET page using HTML Table Control. The shopping cart item details are displayed in each rows of the html table.For a purticular item say shoes i have a html select control inside the row which displays the colors available.which the user can select..also i have the size listed using another select control in the next row.
The table and rows,control and their data are build at run time and I want to access the values of these controls when i click a hyperlink "Add to Cart".The hyperlink takes me to the next ShoppingCart Display Page.
In the firts form a selection is done. After submit a second form is called. In that form there must be select from a list that is depending on the result of the first form. So far so good. The selection of the second form and the selection of the first form must
pas to a thirth page when the submit botton is hit.
I use in the second form:
<input type="hidden" name="hclass" value = <%Request.Form("klas") %>>
But that seems not to work. ( no error appears)
This test works correct
<input type="hidden" name="hklas" value = "test">
Iv had this problem for two days and iv been trying to work around it but its getting kinda messy. Im trying to pass values from my form,thats okay,passing them to the same page and putting them in asp variables,the problem is there a way of submitting the form everytime that you leave a frame,(i want to collect all the values from each frame) I hope i explained this okay.
View Replies View RelatedI have 3 option buttons, 3 select boxes correspondingly adjacent to them. Based on the selection of option button, the form should paas values of the corresponding select box. I tried using Javascript.
View Replies View Relatedonclick of an image button in my main page(parent.asp), im calling window.open("child.asp")as a popup!! child.asp has 36 checkboxes and a submit button.
I want my users to select any or all of the checkboxes and on clicking the submit button i need that popup(child.asp) to be closed and those checked values to be passed on to the parent page(parent.asp)!
onclick of an image button in my main page(parent.asp), im calling window.open("child.asp")as a popup!! child.asp has 36 checkboxes and a submit button.
I want my users to select any or all of the checkboxes and on clicking the submit button i need that popup(child.asp) to be closed and those checked values to be passed on to the parent page(parent.asp)!
I have a form which I can upload images to a web server. In the same form I have a drop down box which is populated by folder names in a specific directory (see code). I would like the user to select the images to upload and to the select the folder (from the drop down box) they would like the image(s) to be uploaded into.
I am having trouble passing (via a post method) the value of the dropdown box, namely the folder name to the upload code page. I passed value from drop down boxes to other pages successfully in the past but something is going wrong somewhere - it doesn't seem to pull any value through - would it be something to do with how the drop down box is populated?? Code:
I have an SQL query on my ASP page:
Select * from tblEmployee
On this page, I have a form with a Select box for DistrictName. I would like to pass the selected value to the above query and use it as part of the WHERE clause. I know that is not a problem. I can do the following:
Select * from tblEmployee where DistrictName = '" & Request.Form("DistrictName") & '"
Here is the problem. One of the values in the Select box is "All Districts". How or what do i send to the query to pull employees for all districts?
I have the following structure,
Form page My Server 2nd server
html ---------->My.asp------->2server.asp
User can submit the form in html to myasp. In my.asp I am using winhttp to
send the form values and some additional values to the other server's asp
page without showing the user where the actual process is happenning.
I have used the samples, but I am not getting the values in the 2nd server.
How to get the values?
Note: I dont want to expose the 2nd server in Myserver.
MyServer can be from anywhere (ie. the myserver may not known by 2nd server)
Any suggestions?
I,am passing form variable monthsenrolled as a query string It does not work as i get a error what is wrong here
function previous(){
window.open("http://localhost/college/basic.asp?status=2&test=<%Request.form("MonthsEnrolled")%>");
}