I' m getting a (0x80040E2F) error, if I submit my form, with blank textboxes
to my update stored procedure. The stored procedure expect values, so how
can I detect if a form field was empty. I've tried testing to see if the
form field is null, blank and to count the characters, but I can't get it
working. My SQL table allows nulls, so it's not that.
I have a page that processes a form and one of the fields might be empty as it's optional if it gets selected or not.
In my process page I would like to check if the form field news_image is empty or not.
How would I do this?
<% If Request.Form("news_image") = "" Then %>
Is that how you do it?
I am writing an application which when the code first loads there is a form which all the fields are blank. I then need to test some date fields to check if the end date is before the start date etc. The form fails to work. So I then wrote a test asp page which has a single box I then use an If...
Else statement if it is Blank then do nothing if it has data in the text box then display a message. The form works ok until I input text and then it does not detect any input text in it and therefore does not display the message. This is totally the oppoisite of the original application which does not detect the form is empty. Code:
i'd like to know if there is some way to detect whether a field is of type MEMO (i'm using MS Access) so to behave accordingly placing a textarea instead of a textbox in the UI.
View Replies View Relatedwhat i am trying to do is when the database field is empty to not display the box (table) that is in my css file, whereas when there's something in the field i would like the box to display!!! So i'm basically trying to get a 'when field empy, do nothing!!! my code at present generates the box no matter whether the field is full or not!!! Code:
View Replies View RelatedI have a dynamicaly drop down the problem is that it places a blank in the first position I need for it to only display the values returned Code:
View Replies View RelatedI set up a form, asp code for the form, and an access db to store the data. It all works fine. The only problem is that I want to set up an error message that reads something like "Please fill in the blank field and then resubmit". Code:
View Replies View RelatedI need a function for blocking or converting letters inserted into a Form to digits, since the Data will be used in mathematical functions.
Is there a specific seach-function for letters, or:
If Input1(not a digit) then...
Else... Input1 * 5...
?
I 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:
What I need to know is how to click on a button that is labeled NEW, as in new record, and have the current form open to data input. That is a blank record. After the user then inputs the data to all the fields on the screen and hits the SAVE button the record will then be placed into the database table.
View Replies View RelatedJust wondering if there is a way to give a default value to a form text box if it is left blank. I can set a default value for the textbox but then it shows up in the textbox and that is not what I want. I would like it just determine if the form is blank and change it to the needed value accordingly.
I'll ask a second part to this question as well in case I am going about this all wrong.
What I have is a search page where a user can search for names from a database. However if I have 5 textboxes of different criteria to search from then if all of them are filled then it would have to match a record in the database exactly....
but if only one or two textboxes are used then the other textboxes basically are now set to a wild card. In this case they would be "%". Also to make things more complicated I am using the frontpage DRW for the SQL query.
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.
I'm working on a form where the user is not required to fill out every text input. How mught I check for that in an ASP script. Here's what I have:
If Request.Form("mp3title1") == ""
amnt = 0;
Else If Request.Form("mp3title2") == ""
amnt = 1;
Else If Request.Form("mp3title3") == ""
amnt = 2;
Else If Request.Form("mp3title4") == ""
amnt = 3;
Else If Request.Form("mp3title5") == ""
amnt = 4;
End If
Pretty straight forward, its checking in order if the first element is left blank, is the correct technique:
== "", or is there more to it?
I have a form that is being sent over to an asp page. About 5% of the time, the form fields are blank when the ASP page is reading them. But when the user hit the submit button, they were not blank, because I have client-side validation that will not allow the submit to occur if any of the fields are blank. When this occurs, all the fields in the request.form object are blank?
View Replies View Relatedi have a form for users to enter their name password and e-mail,i am currently using javascript to check that all details have been filled,
if(myForm.fname.value=='')
{
alert("Plz enter a first name")
return false
}
This works if the field is left blank however if the user enters numbers(1,2) or spaces i.e.(" ") how do i deal with these,i also need to check that the e-mail contains "@" and "."
I created a feedback form for my website that has only 2 required fields. When you submit the form it calls my asp page which puts the information in a database and then sends me n email with the information that was entered into the form. The problem is that the form only has two required fileds, and if the remaining non required fields are left empty when the asp page is called it does write to the data base, but does not send me any email. However if I go back in and put somethng in every field in the form then when I submit the form and my asp page is called it writes to the data base and sends me an email with the all the information I entered in the feedback form. Is there a way to tell my asp page that it is ok to send the email even if the non required fields are left empty? I really do not want to have to go back through the form and put default values in for each area of the form? Also is there a way to have an error displayed if the email is not sent? My asp code is below....
View Replies View RelatedFor some reason my server won't send an email from a form if the email address contains a period (.) before the "@", i.e. firstname.lastname@myisp.com.
Can someone help me modify my form validation to popup an alert if the email address submitted contains a period? I know the code to alert for empty fields, but not for a particular character before an "@".
Here is my form validation code:
<%
Dim Flag
If Upload.Form("Flag") = "True" Then Flag = True
If Upload.Form("FirstName")="" Or Upload.Form("LastName")="" Or Upload.Form("Address")="" Or Upload.Form("City")="" Or Upload.Form("State")="" Or Upload.Form("Zip")="" Or Upload.Form("HomePhone")="" Or Upload.Form("MarketingQuestion")="" Then
If Flag Then
Response.Write "<span class='boldtext'>You must fill out the form as completely as possible (including contact information, address, and how you heard about Pine Rest).</span></p>"
Else
Response.Write "Please fill out the following form as completely as possible.</p>"
End If
%>
I have a form that has approximately 7 text fields and 1 checkbox.
Generally when this form is submitted(to itself BTW) it works fine,
however, when the checkbox is only field that has been
modified/clicked the form doesn't always submit. When it does work, a
Stored procedure is passed form variables and updates to the db are
made. When it doesn't, its as if the form wasn't submitted, it
reloads and resets the page, but the stored procedure isn't triggered.
How do you make a form field's value be determined based on the page URL?I've seen sites that you can change the URL like this (given "UserName" is the name of the field):
Code:
http://www.yoursite.com/page.asp?UserName=baseballdude_
Then when I clicked to visit this page, when it loaded, the value of the UserName field would be preset to baseballdude_.I've tried doing this for one of my sites, but it doesn't work. Is there some way of enabling this?
Ive got a session("name") and the following form in my website:
<form action="updateName.asp" method="post" name="myform">
<label>Name</label><br />
<input type="text" name="Name" size="25" maxlength="60" style="width: 50%"><br />
<br />
<input type="submit" name="submit" value="Update Password">
</form>
How can I equal the value of the form field name with the value of the session so the name will be displayed on the text field?
I have a form that users fill in, thefirst field is a username, which
must be unique.Currently only when I attempt the Insert into the DB does the restaint
inform the user that it already exists.Is there any way i can check , let say onblur, if that username exists, so that they dont have to complete the whole form before being
informed?
I have an asp page that has a form and only 1 field which is know as the ID field.
I only want users to enter an Integer value in the field. If they enter anything else it should come up with a pop up box error and not allow them to process the page.
I'm trying to make a simple Feedback Form using that CDONTS thing I read about (in that "How to use CDONTS" thread). Every works like it should until I try to step it up a little and get the information from a Form... Code:
I am trying to create an upload form field in asp. Below is my code. When I try and access the form I get the following error. Does any one know whats wrong with my code
the error I get is
Microsoft VBScript runtime error '800a0009'
Subscript out of range: '[number: 0]'
/cwm/admin/reportrequest.asp, line 105
Code:
We have a shared hosting plan (Windows-based) with GoDaddy.com. GD.com has a
"generic" form mailer script (gdform.asp) that allows us to set up a
"Contact Us" page, which, when the user clicks "Submit" sends an email to
us.
I am a complete newbie re asp, but looking at the code, it looks to me as if
a error is generated if any of the fields are left blank--which is good. I
don't want to be getting emails that don't contain messages, or that don't
contain a return email address.
However, submitting a completely blank form results in me getting an email
with blank response fields.
Can you take a look at this code and tell me if it should be allowing blank
fields to be submitted? Are there any changes that can be made? Code:
I would like to make two field in a for required fields. Do you all know a simple way to accomplish this? I can post form and any asp if needed( page is getting really huge).
View Replies View RelatedI have a form field on an ASP page and was wondering if I can require the number that is entered to begin with a 0 or a 2.If the number starts with anything else,the user is notified to update the number correctly(Your [FormField] must begin with a 0 or a 2, Please update your entry).
View Replies View RelatedIs there an ASP equivalent to Javascript's '...focus.();' that returns focus to a form field? I want to accept input from a user on a form.This input is to be databased and also unique. I want to check the user's input against what already exists in the database. If the input already exists.
I want to generate a pop up dialog box ala javascript and then when it's acknowledged, return focus to the form field.
I'm using MS database editor.When the db is updated ("submit") I want to send an email to an addrss in one of the fields.The db update function works well.
View Replies View RelatedI'm trying to figure out if it's possible to use an email-processing page for different forms.For example, having a feedback as well as a contact form page.When the user fills out the form I would like it to be processed on the next page,which will display all the completed fields as well as email them to the recipient.
I can do this with just one form,but what if I'd like to use the same form-processing script with a different page and then another without having to specify particular form fields.
This is done in CGI.I looked at Matt Wright's formmail script but I don't know if the same carries over to ASP.
I know that the order of from fields from a form post are somewhat random. But, what about fields that have the same name -
<input type="text" name="something" value=""> First Choice
<input type="text" name="something" value=""> Second Choice
<input type="text" name="something" value=""> Third Choice
<input type="text" name="something" value=""> Fourth Choice
First = "bananna"
Second = "orange"
Third = ""
Fourth = "apple"
Will the values, in the delimited list contained in Request.Form("something"), always be in the order they are in the form? That is - bananna, orange, , apple
I have a form where the user enters a customer name, then clicks the submit
button which then adds it to a database. This works absolutely fine untill
the name has an apostrophe in it.
eg when the name entered is O'Hanlon and its submitted, I get this
error.....
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression ''O'Hanlon'
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?