i'm getting an instance of a form field value being cut off when input into a MS SQL db. i can't figure out where it's doing it. the field datatype is set to VARCHAR with a size of 100. the data is being cut at 30 characters. here is the form field: Code:
View RepliesA bit of a strange request this, but I do have a reason When using request.form to access a forms elements data, is it possible to btain the elements type.
For instance whether the field (element) its being passed from was a hidden field, a text box etc etc! I've hunted everywhere, and tried lots of variates but I couldnt find anything..
I have the simple form as below. When I click it is not getting the form
action from the line inside the loop but from somewhere else in the page.
The page has multiple forms but depending on what the status is various
elements are dsiplayed or hidden. For examples even If I change the
viewpo.asp to nopage.asp it still is displaying the page and going to
viewpo.asp page with the PONumber query string set. Code:
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:
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:
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
<%@Language=VBScript %>
<%option explicit%>
<%
MESSAGE = (Request.Form("type"))
MESSAGE=MESSAGE & vbcrlf & "Name" & (Request.Form("name"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("address"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("handphone"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("phonenumber"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf & (Request.Form("comments"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf
MESSAGE=MESSAGE & "____________________________________________"
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From =Request.Form(email)
objMail.To = "icepricessa@hotmail.com"
objMail.Subject = "Business/Career Enquiries"
objMail.Body = ""&MESSAGE&""
objMail.Send
Set objMail = Nothing
%>
but somehow i'm not able to send the mail....
How do I show a double with 2 decimal places in vbscript? Also is there a way to show a string that is holding a number with two decimal places or does it need to be converted to doulbe first and then converted back to string after manipulating the double?
View Replies View RelatedI am a C#-Coder and now I have the duty to rewrite a ASP-Website and add some functionality. The problem is that I have never seen ASP before and I don't have the time to learn everything necessary to complete my work.
It's a very simple problem and would be really great if someone could tell me what to do or show me a small code-example. I think "learning by reading code" is the best way to get new information
I have an ASP-Website with a very long list (out of a SQL-Query). If I scroll down the page I can't see the list-header any more <- THATs my problem. What I need is an ASP-Website with a fixed section that can't be moved and below a common, scrollable website.
The header of my SQL-Query should be in this fixed section and the datasets should be in the scrollable section.
I have variable, say "total". It can be an integer or floating number.
No matter what value it stores (5 or 5.1 or 5.24), when I display it, is
there a way I can make it display it with fixed 2 decimal digits, like 5.00?
I posted a similar problem a while ago but never found a solution. I am passing an integer value (called NoElements)from a html form (which gets created using javascript) to an asp page. The value of NoElements is used to create an asp array of that size. At first I was confronted with the following error:
Expected integer constant
I then was advised to initialise the array (to say 100) and then do a ReDim Preserve. I now get this error message:
This array is fixed or temporarily locked? What should (or at least I thought) be a simple porcedure is making my life a nightmare.
I have an articles_tbl . How do i create a select statement which only brings back the latest 3 records added to this table (the database has a field called 'date_added') so the information of when they were added is present.
I was just wondering how to bring back only THREE records and showing them, instead of bringing back the entire table content and then showing three out of them..
i got this error when trying to looping through an array
Quote: Microsoft VBScript runtime error '800a000a'
This array is fixed or temporarily locked
Here are my code:
i know how to create text files using ASP, but is there any way to create fixed width text file using ASP? i need to have the data lined up in the same location at each row.
View Replies View Relatedi am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.
i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!
How would one extract the number of (days) from (today) and a (future fixed
date)- eg: February 12, 2003. ....where today will always be Date().
Thus:
02/12/04 - Date(now) = 27 days.
Can anyone help me here?
I have the following line of code in my asp page:
Dim ix
For ix = 1 to Request.Form.Count
fieldName = Request.Form.Key(ix)
fieldValue = Request.Form.Item(ix)
Response.Write fieldName
Response.Write fieldValue &
Next
Response.End
It is not returning the results of any field on the previous form page.
Does anyone know what I might look for?
How can I getting parameter values from more than 1 HTML form onto the same ASP page?
View Replies View Relatedput the ASP part where Page 3-Displaying form values from one page on another
View Replies View Relatedwe have a web system whena user submits a form, it's take to a page... if the user didn't fill in a particular form properly then resulting page tells them so. they then go back and fill in the remaining fields.this works for all but 1 user whose values disppear totally, having to do it all again.has he got his computer set up differently?
View Replies View RelatedI have created a asp page "AddUsers.asp" which allows the admin to create new user ids.The admin fills in all relevant details and clicks on submit.The form gets posted to a page "Insertusers.asp" which checks if the new entered userid already exists in a database.
If the userid already exists, page display a message saying "Userid already exists" and a back button(link to Addusers.asp).When the admin clicks on back button, it takes him to Addusers.asp and all the relevant details entered in a form are lost.Again he has to fill in all the details which i want to avoid.How can i retain the values entered in the form so that the admin can change only the userid and submit the form again?
I have a problem where form values go missing. The are several forms on one page with indivdual names (i.e. form1, form2) but with the same fields. Whenever the form is submitted via post the values disappear. It only happens on this one particular page.
The odd thing is that if I do a response.write with the variable and then a response.end write after it it shows up perfectly. The page is just a basic record update page. If I do a response.flush() it works as well (up until the redirect). I am leaning towards a response buffer problem but still don't understand why it is happening.
I came up with the new problem. I want to fetch all form values by using request.form("FormName") which is generated by javascript on runtime.
The attached zip code contains the working code of javascript creating dynamic form elements. So after generating a couple of textboxes when I click on the "Submit" button it should display all the values entered in the textboxes on the next page.
I am trying to create a page that displays the values the user has just selected from my form. The form consists of three drop down lists. Upon clicking the submit button, I would like to go to a new page that says something along these lines:
"Thank you for filling out the form. You have successfully transfered account _____ (value from one drop down) from ______ (another value) to ________ (the last value)." How would i go about doing something like this?
Does anyone have the code to write all the form values to variables of the same name. So for example request.form("myname") would be stored in a variable called myname after running this. It should just save time from doing the request for all the fields.
View Replies View RelatedIs it possible to save all the names/values of a form to another memo textfield before a Insert to the database then when required on another page split that memo textfield into the name and their corresponding values retrieved from the recordset ?
View Replies View RelatedIf I have say 10 fixed variables, how can I set their values = to that of a form that is built dynamically?
column1column2
email=formvalue(0)
fname=formvalue(1)
lname=formvalue(2)
etc..
lastvar=formvalue(9)
Is there a way to store a form value that can be passed across multiple
pages, other than creating a session variable for the form value?
Can an array be created to hold form values and maintained and used across
many pages? Or, other alternatives?
I've used session variables, but have understood that using many session
variables isn't good and there would be a better method to handle this?
Is there an easy way in ASP to check the value of a form element, like a hidden field, of the current page, not the previous page?
View Replies View RelatedI have created a form. I have a log in page and a view registration page. When a user logs in I have to display only their information on the registration page. But when an admin logs in...
they can view all the records in the database. I am not sure how to do this. Can anyone help me? I have included that code that I have now. Right now...when the users log in they see everythings. Code:
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 am trying to total the value of some form fields I am referecing the form
field with an inner loop, I am having a little trouble because the amount of
fields returned is always different, how can I roll-up the total of the form
fields (request.form("subtotal_"& i)) to get one final figure? Code:
Lets say I have a page with 6 different options a user can select, each linking to a registration form. Regardless of what the user picks, they will fill out the same form. The only difference is the title of the Email sent. To avoid having a seperate form page for each option, is there a way to pass a value and put it into the Subject title of the email depending on which link they click?
View Replies View Related