ASP :: 1 Value 2 Fields Inserted On Form Update

Sql Update Multiple Fields
Is it possible to do an update on a recordset like this?display all the fields in a form and let the user pick which ones to update? What happens if they pick, say, two of the total to update, and leave the rest of the form fields blank? Would that update the chosen records and leave the rest of them blank or null?

How To Update And Retrieve Ntext Fields
how to update and retrieve ntext fields in my asp code:

.update Creates New Record But All Fields Null
I have made several Access-based CMSs but now I am using SQL Server. I can read the records but my first attempts at writing are resulting in new records (with new ID) but all the fields are null.

I am posting the data from a form to the same page and an if /then statement catches the flag in the URL and runs the update script below. All the field names are correct. Code:

How To Tie RegID To Form To Update (batch Update)
Okay there is an unique EventRegID for every registration. When people first register they get pre-registered. Then an admin comes in and confirms or wait list them (based on whatever requirements). My question is how can I tie the EventRegID to a form with multipule ID's so they can batch confirm or wait list the PreReg list? Code:

ASP Repeating Form Fields In An Email Form
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?

Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.

Then all of the information from the whole form is submitted which returns an email to the administrator of the event.

Form Fields
I have an asp page which has a number of form fields on it (about 50). 2/3rds of these fields are used to store username (windows username) and date (todays date). I want these fields to be locked so the user cannot enter any info into them. The infor will be grabbed from the current user and the current date.

However, I only want these fields to be populated only when the left most field is changed. Once the fields have been populated the username and date fields will change with however is logged in and the new date.

Form Fields To 1 Variable
I need to loop through all submitted form fields and place them all into 1 variable but i have no idea how. Here's what I have so far:

for each item in request.form

myVariable = "formfieldname:" & item & "formfieldvalue:" & request(item)

next
response.write(myVariable)
The problem with that is that response.write(myVariable) only prints the last field in the form.

I know that if I move the response.write(myVariable) INSIDE of the loop it will print correctly but I am not trying to print the form fields BUT I AM TRYING to store them in ONE variable.

For example:

myVariable = formfield1name:formfield1value:formfield2name:formfield2value:formfield3name:f ormfield3value:ETC ETC

Not Getting Form Fields Thru ASP (CDOSYS)
Code to email form data via ASP. Forced to use CDOSYS by 2003 server at host. It sends an email fine, but the form data is missing. Where my going wrong? Could it be the html file's form actuating the .asp file? Could it be an enctype issue? Or bad ASP syntax... Code:

Bunch Of Form Fields
Can someone tell me how I can take a bunch of form fields using Request.Form, and put them in a array. And then, how do I send that in and INSERT sql.

Insert Form Fields
I have about 30 names of workers (and their IDs in hidden fields, that depend on their departments) in one form, beside them there is one dropdown list for each worker, with same items. I want to select item from dropdown list for each worker, that will write item ID in another hidden field... and then I want to submit worker's ID, ID from dropdown list etc....into another .asp page and sql db.
If I use next way :
<%
FOR EACH name IN Request.Form
Response.Write("<BR>")
Response.Write(Request.Form(name))
NEXT
%>
I get only values of IDs from dropdown lists. But I need workers' IDs, too.

How To Send All Fields Of A Form Without Specifying Each One
how can I send the whole form using the script below, without listing every NAME of the form. Basically I wondered if you can just put a certain code in that will send all the fields of the form without putting each NAME of the fields down indiv individualy??

My forms Name is 'conf', so I was wondering if there was a code like SENDWHOLEFORM="conf", (I know it obviously won't be that, but just to put the point across!)

<%
DIM strNAME, Mailer
strFirstName = Upload.Form("NAME")

Set JMail = Server.CreateObject("JMail.SMTPMail")

JMail.ServerAddress = "10.2.3.2"
JMail.AddRecipient "me@me.com"
JMail.Sender = "me@me.com"
JMail.Subject = "Submitted Item to sell"
JMail.Body = "Name: " & strNAME

JMail.Execute
Set JMail= Nothing
%>

How To Loop Through More Form Fields?
I have about 30 worker names (and their IDs in hidden fields) in one form, beside each worker I have a dropdown list with same items. When I select an item from dropdown list its ID is written in another hidden field. I want to submit values from hidden fields into another .asp page and sql db. If I use :

<%
FOR EACH name IN Request.Form
Response.Write("<BR>")
Response.Write(Request.Form(name))
NEXT
%>

I get only values from dropdown lists IDs. how to loop through all fields and get IDs of workers, too.

Dislpaying SQL Fields In A Form
I have the following asp code:

response.write "<td align=left colspan=2 class=text>" & _
"<input type=text name=ProjectDescription STYLE='width:465px' value=' " & ProjectDescription &" '>" & _
"</input></td>"

The problem I have is when ProjectDescription contains a ' the data gets truncated. How can I resolve this.

i.e. ProjectDescription=doesn't

Display Form Fields
I have created an email form in which all fields must be completed. If all the fields are not completed "submit" causes a refresh using response.redirect, Problem is allthe fields that were previously filled in are empty.How do I keep the values of the fields on refresh?

Scanning Form Fields
I have a form submitted with a form field called contents. This could have loads of text in. What i need to do is scan this field for words that match the text in a database record called PAC_WORD. This could match 3 or 4 of the words put. Basically for each word picked up I want to write " This item found is not allowed

Server Form Fields
I have a asp page that has a form that I have to submit to a third party website.if their is a way to create form values using asp to submit the secure data without having it in a hidden field where it can be seen when viewing page source?

Currently I have my asp code writing out hidden form fields using the response.write when the page loads then after everything is loaded JavaScript submits the form.

Checking Fields In A Form
How do I check the field for example zip code to make sure that it has 5 digits?

Form Fields Visibility
I have a web form which is quite long. My first field is required. If my user submits the form the page just sits there and the do not see my validation message at the top of my page. how I can reposition teh page so they see teh message i.e.scroll back up the page?

HTML Form Fields
how to access my HTML form fields from ASP. i don't know how to access HTML form fields from ASP code.

Hidden Form Fields
i wrote a script in asp/vb script that validates form fields. all works fine, apart from the fact that alerts are being shown against the empty form fields when the page loads the first time.

so, validation should not be carried out when the page loads the first time. my friend challenged me and said i can achieve this "using a hidden form field or even the submit button" and submitting the page to itself

i was more thinking of using session variables or a session cookie, but does anyone know how you could accomplish this using a hidden form field?

Updating The Fields From A Form
Here's what I want to do ... or here's my problem. I have a 'ICQ' on my user's profile, so it's a number, now when I update the database it DOES NOT use the single quotes, so it looks like:

& "ICQ = " & Trim(FormatStr(Request.Form("ICQ"))) & ", " _

Now, the prob with it is when a user DOES NOT type anything in it, since he doesn't have a ICQ number, then it gives a syntax error because your inserting nothing without any single quotes. How do i fix it? Or how can I NOT make it update if it doesn't have anything in the text box?

How To Send Blank Fields On Form
I have created a database were you submit a job by entering the fields which is fine if it is a site visit but if it is a phone call or remote help not all the fields need to be filled in but if there not filled in it wont submit the values to the database i get data mismatch error code is below.

I either need to be able to send them blank values to the database or ideally i wont to create a option box with Phone call, Site visit and remote help which when selected takes you to the correct page which have different values in the form to fill in.

Loop Through Form Fields To Set Cookies
I have a table in which I count the rows, and for each record it finds it uses that number to dynamically name the form field. i.e.

<input type=text name="FirstName<%=i%>">

I got that to work just fine. What I'm trying to do now, is post the form, and on the new page dynamically create cookies based on the number of form fields there are. For example, my desired end result would look something like this..

response.cookies("First0")=request.form("FirstName0")
response.cookies("First1")=request.form("FirstName1")

and so on. Is there a way to do this by looping, instead of hardcoding? I have my feeble attempt below....

Populating Form Fields From A Database
i have a form with fields that contain data from a db. the fields can then be edited, and on the click of the "submit" button, the updated information is returned to the database, replacing the old. a bonus would be arrow buttons allowing navigation from one record to the next, with the information populating the form each time. i'm having a hard time with this.

Requesting Many Looped Fields From A Form
I have an asp form page that has alot of textboxes on it and are displayed in a looped table, meaning that the number of fields submitted will vary each and every time the form is submitted.

I do not know how to pick up these fields on my submit page. Normally I would just use request.form("fieldname") but since i dont know how many fields will be submitted, its hard to bring in the field values that way.

there is only 1 field on my form but there could be alot of that 1 field because of the loop. I managed to name each field txtEmail1, txtEmail2, etc... Code:

Clearing Form Fields Value Button.
I have a form that comes up pre-filled with database results for the values. I'd like to add a button, though, that will clear all fields to start blank if desired.

A standard "reset" button, will only clear input that has been typed in, but won't clear the initial values. Does anyone have a script already that does this or could someone get me started on how I could do this?

Passing ASP Via Hidden Form Fields....
I want to pass ASP returned values via hidden form fields...

Here is a simpler demo of my what I am trying to do....

Page containg asp values in hidden fields of a form:

(input.asp)
<html>
<body>
<form method = "post" action="ad.asp">
<input type = "hidden" value = "adski" name = "ad1">
<input type = "hidden" value = ""<%= WeekDayName(Weekday(Date)) %>"" name="ad2">
<input type = "submit" value="submit" name = "submit">
</body>
</html>

Output page, showing passed ASP values:

Request.Form With Unknown Fields?
I need to create a script that will collect any variables sent by a form.

Reason: A company that I work for wants to have a script that they can pretty much send any HTML form to that will send them an email with the results. So if they make a new form with different form fields next week, they can point it to the same script.

Is there anything in ASP that can "Just collect Anything/Everything" that is sent from the form?

Repeat Region - Form Fields
I am displaying multiple records returned in a resultset using a Do While loop. I've set the form field names like the following:

<select name="fieldnameA<%=ID%>"...

where <%=ID%> is a hidden field on the page that holds the id value for each record.

I want to append that number to the end of each form field

So, "fieldnameA" would be fieldnameA1 or fieldnameA2, etc.

I thought this would work, but the field names remain the same for every record...i.e. fieldnameA just repeats and the hidden field value isn't appended to the end of the field name.

Is there a way to append the value of the hidden field to the end of the form fields? So, the form field names are different for each new record displayed?

Posting Form Fields With XMLHTTP
I am trying to post a large XML string to another url. I have been doing this previously in cold fusion but am trying to get all of my code up to date and it wont work in ASP. It should be very simple:

xml = Server.URLEncode(refi1_doc)

pingUrl = "https://xxx.xxxxxxx.com/b2b/incoming.asp"

set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP")
xmlHttp.Open "POST", pingUrl, False
xmlhttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
xmlHttp.Send xml

This should just be URLEncoding the xml document and posting it. I am getting a "Bad XML" response - line 0, position 0 -- but I KNOW the xml string is well formed -- have already tested that. The guy on that end who was trying to help me stated that the string MUST be in a form field named "xml" (all lowercase) and it has to be a post -- that's it! Isn't that what I am doing? I even tried adding to the end of the URL:

pingUrl = "https://xxx.xxxxxxx.com/b2b/incoming.asp?xml="

Nothing is working. How do I specify that the data being sent is in a form field called "xml"? Anyone know what is going on here?

Referencing (many) Form Fields In An Array
I am trying to do some client-side form validation using vbscript. The form consists of 15 rows, with five fields in each row. For example, I want to be able to look at the contents of the 3rd field in the 9th row. How do I reference that field using vbscript? Do I loop through a collection?

Showing Calculated Fields In The Form
I have a asp input form of a financial report. Here most of the fields are text boxes where the user need to input the values corresponding to an item.

However, there are few items which are calcuated field. Prior to submission of the information, I would like the user to know what the calculated field be (based on the information input in text boxes) before submission of the form. Is there any way to display the calculated value before submission in ASP?

Making Form Fields Required
How do I make form fields required if I'm using a formmail.asp script?
Also can I customize the page that visitors are sent to that tells them "you forgot to fill out this part..blah blah blah" ,and if so, how is it done?

Setting Required Fields On A Form
I have a form with several fields - I have a radio button Yes/No

I have Field1, Field2, Field3, Field4 and Field5

If the radio button is Yes then I want Field1, Field2 and Field3 to be required - the other fields do not have to be required.

I'm not sure how to set them to be required - I know that I would have an if statement that if the button was yes then do something, but I'm not sure what to do?

Database Fields In A Input Form
How can I specify formatting restrictions for special fields like Postal Code
(format X1X 2C2) or date input field MM/DD/YYYY? I have Acces DB with these specs, but when I used FP2002 Database Interface Wizard, it ignores these. Also I am unable to "edit" any of the records utilizing pages generated by this wizard.

There is an error that it will not accept empty fields. I have no problem adding data (even if some fields are empty) or deleting records.

Form Submission With Same Text Fields
I have 3 fields in my form and one of them called ID with multiple text fields e.g (there are 10 text fields for ID) and when you submit the form all the 10 ID's should be submitted to the DB for that particular record with a single space inbetween the 10 ID's. Can any one tell me how this is possible.

Cdonts Obligated Fields In A Form
I've implented a script that allows me to email a form using cdonts. How do I make a field an obligated field to enter data - for exemple a phone number if the phone number is the most important piece of data ?

Sum Form Fields Add Total To Database!
I have a an issue that I would love to solve. The below code adds 111111111111111111 to the field when I want it to sum the amount which in this case totals 18 and then add that total (18) to the field! Code:

Optional Fields In A Form, Converting To ASP And SQL
I am trying to incorporate a search feature, and I am having problems thinking up some code to accomplish a certain thing: I have a page that allows a user to search for Industry-specific locations.

It is a basic form with City, State, Zip, radius fields. I also want to incorporate optional fields, such as the different types of amenities/facilities that the building offers. These amenities/facilities will have checkboxes. Code:

Database Update On Fields With ""
im trying to build a custom webBlog interface with asp language and javascript embedded htmleditor. im using htmlTextArea to permit user to edit html code onthe fly (with IE 6+)

the address to the current site is URL you can check out the admin interface by clicking on login and validating with pass***

you can try editing an existing record in the first table (you click on the [...]to open the table) Code:

Request All Fields From A Form And Send By Email
i already create a code to request all fields from a previous page form using the next function y separate the fields with the value of each one. Code:

HTML Encode And Select Form Fields
I have downloaded and installed an ASP Calendar offered for free by Manohar Kamath from his website. I've modified it to accept two new fields (sStart_Time & sEnd_Time). I want to be able to have drop down selections for the time entry, but do not know how to accomplish this.

Please take a look and tell me if this can be done using the <% =Server.HTMLEncode(sStart_Time) %>"> value for this piece or if there is some other way to accomplish this, please let me know.

If I leave it as the following, it works OK, but I want to make it easier for people who are adding to the database: Code:

Exclude Some Input Fields From Form Submit
I would like to exclude 2 or three input textboxes (hidden ones) from being
included when I click the "submit" button on a form.

Form Including File And Text Fields
i want create a form that include many text boxes and an fiel field for upload a file to server but when i add "enctype="multipart/form-data" in the form tag i cant get the texts . how can i do a form working with file upload and text fields.

Binding 2 Text Fields On An Online Form
I am trying to bind/link 2 text fields on my online form.

So they both should show the exact same text entered in them.

When text is entered in one of them I want to see it in the other text box and vice versa and when text is deleted from one of the boxes it should also be deleted from the other one aswell.

Syntax To Have Body Of Email Include Form Fields
I finally figured out how to get my form to its database and have an
email come my way. However I am now trying to set up the body of the
email to include the form details. However the body of the email that
is sent only includes the last line of the "body" tag and has no
details next to it. Code:

How To Display Multiple Form Fields In Email Using This Script?
I am using this script to submit my form fields into the body of my email:

***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next

***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.

The closest I've come to getting something back from this thing is when I tested the script with these elements:

FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")

Which produced this result:

Email: Email
Email: Email
Email: Email

Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?

Stopping People Putting Scripts Into Form Fields
im making a simple site where people can add comments into a shoutbox. only ive had experience of people adding in html tags and javascript to redirect people away from my site and display images etc which im not interested in.

how do i stop this from happening? is there a way to intercept the form contents and kick out the code leaving plain text? or changing the code so it displays the real code using < and > ?