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.

View Replies


ADVERTISEMENT

Asp Page Wont Send Email If Form Fields Are Blank

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 Related

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
%>

View Replies View Related

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:

View Replies View Related

Blank Fields

All my fields give that error when I try to leave it blank when inserting a new record. The field is not required in the database, so what do I have to do to insert it as blank?

SQL:

Code:
INSERT INTO Tablename (REQUIRED, NOTREQUIRED) VALUES ('tag', '')
Error:

Code:
[Microsoft][ODBC Microsoft Access Driver] Field 'Tablename.NOTREQUIRED' cannot be a zero-length string.

View Replies View Related

Detecting Blank Fields

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:

View Replies View Related

How Do I Skip Blank Fields?

I'm using ASP FormMail to collect user info, but now I'm trying to figure out how to modify the code so that any blank fields from the form will not be displayed on the confirmation page/email. I tried to modify the code below in bold, but it gave me a syntax error. Code:

View Replies View Related

Ordering Records With Blank Fields Last

I've written an ASP page that pulls all records from a table. My query
is 'SELECT * FROM teacher ORDER by Class'

It is working fine... sorta. The table has about 20 records, but only
5 have an entry in the 'Class' field. The 15 records with the blank
class field show up first, then the other 5 records. Is it possible to
have the blank one show after the ones with an entry. Here's how my
results look, IOW. Code:

View Replies View Related

Input Fields Blank Space

I have entries in the database that have spaces (Todd's Place) but when I try to get the info into an input box it only shows the first part of the string before the space (Todd's) Here is my code
strSQL = "SELECT ID, memname FROM tblMembers WHERE ID =" & numID
Set rsEdit = adoCon.Execute (strSQL)

<input type=text value=<%= rsEdit.Fields("memname").Value %>>

The funny thing is I can see the whole string when I view the source on the page (<input type=text value=Todd's Place>) but why can't I see it in the form.

View Replies View Related

Blank Form

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 Related

Get Data From Form, Send To A Html File And Send A Mail

i am trying harder to mix this 2 solutions... but without success... the below on seen to be grabing a template and replace the data with the values posted in a form Code:

View Replies View Related

Replace Blank Form Value With A Default Value

Just 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.

View Replies View Related

Check To See If A Form Field Is Blank.

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?

View Replies View Related

Detecting Blank Form Field

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.

View Replies View Related

Check For Blank Form Input

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?

View Replies View Related

Html Form Sending Over Blank Data

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 Related

Form Validation(checking For Digits And Blank Spaces)

i 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 "."

View Replies View Related

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.

View Replies View Related

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.

View Replies View Related

Form Fields

I have a form that will be filled out by users, what I would like to do is when the user selects a state from a dropdown list i want to have the City field show select options based on their state. I know this can be done but I dont remember how.

View Replies View Related

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

View Replies View Related

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:

View Replies View Related

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.

View Replies View Related

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.

View Replies View Related

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.

View Replies View Related

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

View Replies View Related

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?

View Replies View Related

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

View Replies View Related

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.

View Replies View Related

Update Fields In Form

I am creating a form that uses a postcode lookup that opens in another window to confirm an address how would I pass back the address and populate the form?

View Replies View Related

Checking Fields In A Form

How do I check the field for example zip code to make sure that it has 5 digits?

View Replies View Related

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?

View Replies View Related

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.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved