I loop through a recordset to return values that populate a form which
the user can then edit and save. However these fields need to be validated first
to make sure the data entered is correct. I have a Firstname field that returns 3 records
from my recordset which means when I try to validate, I get an error as the page doesn't know which of
the 3 to use. I believe I have to do it through an array, but have no clue how as my efforts have failed
how do i insert multiple values into one database fields using ASP.
View Replies View RelatedI have form1.asp which contains a form which is posted to and processed by a page called process.asp.I want to create a second form on form2.asp and also post it to process.asp. On process.asp I would execute different stored procedures conditionally based on where the form is submitted from.How can I tell which page the form is submitted from?
I think I should be able to have a hidden form field on my forms and post that to process.asp.Is there a better or preferred method.?Can I combine these three pages on one asp page?
I'm having problems retrieving all the values from a multiple selection field using the freeaspupload component.
I'm creating an online email app that uses the freeaspupload to add attachement functionality, which means the form encoding type is multipart/form-data. I've done something similar with the persits aspupload component, and had no problems with that, but the freeaspupload version seems to handle <select> fields slightly differently. Code:
How do I post an HTML form to multiple ASP pages? I need to do two things with my data at the same time and it would be very helpful if I could spawn the processes when the HTML form is posted, not through downstream ASP handling.
View Replies View RelatedAssuming the following code actually worked, I'd like to take data entered from one form and post it to two different locations. Hypothetically, I have a server in NY and one in LA that I want to get the same information.
<form action="http://ny.server.com/test.asp"
action="http://la.server.com/test.asp" method="post">
Name:
<input type="text" name="request" /><br />
<input type="submit" value="Submit">
'''Contents of ny.server.com/test.asp
<%
response.write "Data saved on NY server"
%>
'''Contents of server2.com/test.asp
<%
response.write "Data saved on LA server"
%>
I have a form F1, once submitted it goes into another form F2, I want the fields in F2 to be filled with the values the user filled out in F1. in php I would use the $_POST[] to get it, but I dont know nothing of asp
and from what I could find on the web, would this work?
Code:
<asp:textbox id="txtLastName" runat="server" MaxLength="30" Width="140px" Height="21px" value="Request.Form('lname')">
and what if they accessed the page directly, rather than through a previous form, would it field appear blank? or do I have to have an if statement. also what if based on the F1 value I want to select (check) a checkbox/radiobutton or drop down menu in F2?
I have a request form that is used for requesting copies og an edition of a magazine. What I need to do is get back the information, from a MS Access table, for the issuedate and deadline.
Because the deadline is not always the same number of days (ie dependant on issue it could be 14 days before, or 21 days before etc), so as well as picking the issue date from the table, I need to be able to get the deadline date back, and write to a seperate Request "field" on the Form. Code:
How do I convert this ASP mailer script to accept and mail multiple fields of a form. This will do one field only )iMesg.TextBody = Request.Form("body") and it works great. Code:
View Replies View RelatedI am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
i have an asp code which is somewhat like this:
<select name=test>
<option value="<%=parRs.Fields ("ProductId").Value%>">
<%=parRs.Fields ("description").Value%>
</option>
</select>
when i submit this page i can retrieve the value of the option box test, which is the productid.
I want to send the both the id and descritption in the select test, and how do i retrieve them on the next page?
I know we can use the id and open a db conection on the next page and retrieve the description, but this is a bit bulky when we have many selection boxes.
Is there some thing in asp like print_r() in php? something that I can use and print out everything that has been selected in a form?
View Replies View RelatedI 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:
I want to use field values outside a recordset. When is use "set speler8 = rs.fields("naam").value" I get an "Microsoft VBScript runtime error '800a01a8' Object required: '[string: "John Doe"]'. I can't find the info to resolve it anywhere. Can someone help, it's probably verry easy, but I don't know it.
View Replies View RelatedHow do I pass in more that one variable in the form tag below
code:
<%
Dim CmdPopulatelist
Set Conn= Server.CreateObject ("ADODB.Connection")
Set CmdPopulatelist = Server.CreateObject("ADODB.Recordset")
%>
.
.
<% sql_select= "select * from Patch_Feedback where Patch_name= '"& view_name &" ' and Name_of_user = '" &Name_of_user &"' " %>
<%
Conn.Open "DSN=Patch;uid=cmadmin;pwd=dci01;database=cm_db"
Conn.execute(sql_select)
CmdPopulatelist.Open sql_select, Conn
%>
.
.
.
<form method ="post" action="updateresponseA1.asp?update_ID=<%Response.Write(""& CmdPopulatelist ("Patch_ID") )%> ">
I have code that is looking at the userlogin name and then assigns them to a certain value, thereby allowing them to see certain groups of reports on a website. If I want them to have multiple values, how would I code this? This is what I have so far:
if strUser="jdoe" or strUser="jsmith" then
I am looking for some help in writing an ASP script to check for duplicate values in a database. Using a web form to add and edit the records, the user will type/edit the data including phone number.
If the user types in a phone number or email address that is already in the database, I would like an alert box to indicate the name of the person with that phone number when the form is submitted. This is a more user friendly error instead of "Microsoft JET Database Engine error '80004005' ".
how can I compare a values to multiple string values. i.e.
If Request.ServerVariables("REMOTE_ADDR") = "213.123.214.33" Then
WriteLine "A problem has occured, please email for help<BR>"
end if
Would it be to do multiple if the elses, case or can you put all the possible values on the one line? i.e. "123.123.123.23" or "345.234.234.234" etc.
I've a multiple checkboxes and would like to insert those values into the db. How can we insert all those checkboxes’ values into 1 field (DB), we use a stored procedure. This is urgent
View Replies View Relatedhow i could put multiple values on to a Query String and get them on the next ASP page. Currently on wy website, i know how to get one, but i am not sure how i am able to get more than one assigned to a specific variable.
View Replies View RelatedI have a link as follows:
<A HREF=""Tracker.asp?MovementID=" & RS("MovementID") & " PONumber=" &
RS("PONumber") & """>" & RS("MovementID") & "</A>
I am trying to pass: MovementID & PONumber.
On linking to Tracker.asp,
MovementID = 2257 PONumber=21071045
PONumber = Empty
I am just testing this with Request.querystring. What have I done wrong, how can I separate these values ?
I am running two queries on a single page and they essentially work, the only problem is that i am unsure exactly how to get one aspect to function properly.
To explain it correctly it will probably be easier to just show you the code, the first query looks like this: Code:
is there a more efficient way to replace multiple values than this (so that the numbers 0-9 are placed with particular texts in one go): Code:
View Replies View Relatedhow do get ASP to display multiple calls from a database? For example, I can name a variable for a password, then query the database, then call the password variable later in the code and it should display the password from the database.
Code:
strBody = "Here is your login password: " & strPassword
If in the body of this message I want to have a username on the next line, how do you do this in code? I thought you used a &vblt command, but that throws an error.
i've got 7 radiobuttons with the same name, but them values are different. I need to request the checked values and insert in my field on the database, but how can i get do this separated ones?
<input name="idioma" type="checkbox" class="campo" value="1">Portuguese
<input name="idioma" type="checkbox" class="campo" value="2">Germany
<input name="idioma" type="checkbox" class="campo" value="3">Russian
<input name="idioma" type="checkbox" class="campo" value="4">Spain
<input name="idioma" type="checkbox" class="campo" value="5">French
<input name="idioma" type="checkbox" class="campo" value="6">English
<input name="idioma" type="checkbox" class="campo" value="7">Italian
Can anyone Helps me?
I have some problems in trying to retrive multiple parameters from a stored procedure. When i want to just get one i use
select @param AS 'para'
But how should i do when i want multiple parameters out to the ASP files?
i want to submit 30 field(textbox,combo etc.) data into database.if i take all 30 fields on same asp page or form,the page will not look good, so i want to break that into 3 pages,each page will having only 10 fields.when all required fields on first page will be filled by the user then he will click on next button,so he will see next page , i.e. page no. 2,same for page 3.
if he want to come on previous page for editing some info,it should be possible.on 3rd page there is submit button,when he clicks on submit all the info will stored into table. can anyone tell me is it possible using ASP 3.0? if it is possible then tell me how to do this?
At the moment, the function looks like this:
code:
public function fncGetPageContent(intSectionId_In)
set rsPageContent = connection.execute("SELECT TOP 1 * FROM sections WHERE section_id = " & intSectionId_In & ";")
if not rsPageContent.eof then
strSectionCopy = rsPageContent("section_copy")
strSectionTitle = rsPageContent("section_title")
end if
rsPageContent.close
set rsPageContent = nothing
end function
My question is, how do I call this function and return the two distinct values?
I have a stored procedure that requires one variable to be filled: WHERE ItemNo = @ItemNo
Instead of sending 1 value,I'd like to send a bunch of values. I don't mind changing the SP if I new how to approach this. The user would select any number of ItemNo's from a form and submit.
Assume ItemNo's like: B1, B2, B3, etc...
The end result would be something like ...
WHERE ItemNo = B1 or ItemNo = B5 or ItemNo = B10 ...etc....
I want to build a recordset based on the user's selections. How?
I have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
how 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?
I have a check box and I need to automatically select certain values from the avaialable selection in drop down lists when the tick box is selected. So check box is selected and then drop1 = blah1 and drop2= blah2.
Would somebody have an example i can work on a bit, I am not sure if JavaScript is the best way of handling this, not very good with making anything work automatically.
I've looked around the net and searched this message board and haven't been able to find a solution to this problem. An application that I am currently making pushes and pulls data from SQL. One stored procedure is very important and returns many values.
I call this sp many times in my script and wanted to put it in easy to manage function, sub, or whatever works. The problem is that it returns about 10 values that I would need to return from the function back to the standard asp. Code: