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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
How do I check the field for example zip code to make sure that it has 5 digits?
View Replies
View Related
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
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