write a simple function to check the user input from a form. I need to check that the string contains only numbers, has a maximum leght of say 15 and that the first number is zero.
i have created a database system for work but when you input job details you have to fill in every box i want it to be able to process and add the data to the database without having to have every box filled in. Here is the code:
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)
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.
I have an ASP page that goes from part to part based off of a session variable. Is there any way to check for when the user clicks back so that I can change the variable. If not I will have to separate all of the pages out and that is just not fun.
So, when the user clicks back, the session variable gets changed. That is what I am looking for.
P.S. Is there a faster way to check if a variable is blank other than an If Bleh="" Then <some code> End If
P.P.S. When a submit button is clicked, I want to open a new window with a message like "Be sure to fill out this on page X"
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.
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.
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 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 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?
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 "."
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....
How can I create a query based on the form input. I want to have a pulldown menu (list of states). The user can select the state, lets say VA and click on "go" button. I want the page to return results that has state=VA. So how do I create that statement and send to aspx ?
I want to have a form like a table of record. If I let user input number of record to be insert in advance, how can I make a form that having number of rows of input? For example:
Number of records : 5
Then I need a input form like a table with the column and 5 row like Excel format.
I have been ask to try a create a form on my works website to allow teachers to fill it out the click button that emails to the boss
I thought asp is what need so i am very new to asp and with a lot of reading from the net and books i got it to work :) but i tried to get too clever and sent the user info to a page so the user can check for errors before emailing but i cant figure it out and by fiddling too much i have stuff it completely
can it even be done input info into form post that info to a new page and then if the info ok email
i've recently done a basic website offline and haven't uploaded or found a host server yet. however i was wondering if there is a way to process the form input offline. I was told i need ASP functionality. but i'm not too familiar with it.
I have a form which inputs info into a database. However what I would like is to populate a select box directly from the dbase. When the form is entered the field is updated along with all the other info.
I have enclosed two of my pages - I think I'm nearly there.
I am designing a website for a friend that has a backend database that holds information on all the stock they have and this gets displayed onto the page no problems.
The only problem I have is when they add new items to the database, a part of the form is a textarea and in this teaxtarea they copy generated code from paypal (a form that is generated by Paypal as a add to basket button).
The problem I have got is that if you try to add this textarea to the database field what you get is a image of the paypal button and no code.
I have tried the replace function, concatenated it in comments etc but all i get is a blank field or a image of the button.
I have a HTML page with a form on it. I have an ASP page that processes what a user has entered into the form (updates a database etc).
I now need a page that fits between these two pages to pre-process�the users input. I need to do it this way because I am not allowed to change either of the two existing pages.
I know how to read what the user has input into the form and I know how to pass control onto the next page.
What I have not been able to work out is how to change the user input and have those changes passed onto the next page as if nothing has happened (that is, the original ASP page just performs its request.form(�item�) calls as it always has but instead of seeing what the user actually typed in, it should see the changed text as created by the new pre process� page)
I have tried using a regular expression replace but can only successfully make this change a variable and not the original form input. Equally I cannot find a way of swapping the original form input string with the output variable from the replace.
i have fixed my code and there was no error at all, it executed well and the msg "The quote has been sent" appeared. But although it was working, but it seemed that it didn't really sent the Firstname and Address to the email. Why? here's my code :
I want to send the data from a user's form input in an ASP email. For instance, shen the user submits their name and email address on a form, I would receive an email with those fields mixed in with a plain text message. How can I do this?
I have programmed extensively in other languages, but not ASP (our company is switching from ColdFusion), so I will need my answer in fairly introductory ASP terms.
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.
I have a form, where the user types their initals and it then returns some results. However, the Oracle database requires the initials to be in capitals, how can I convert the user input to upppercase?
I'm developing an account lookup, mostly in ASP, that displays a list of radio buttons to select one account from those found in a recordset. Here is a snip of the account display, after the recordset is populated: Code:
But one of my fields is based on input from a radio input (three inputs with a value of 1,2,3). Since they all have the same name using the code above will not set they value for any of them. Anybody else run into this, or have a suggested way I should do this.
I'm trying to create an input screen that allows users to create a hierarchical structure as the one below, but have no clue where to start or how to construct it. Code:
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
i have 2 tables related to each other contact table id, fname, lastname, contactid, email
How to search a database field from form input? is it easy to do i like to have a html form from an html page that will call an asp page to do db search, if user enter a zipcode that match in the database it will pull all the infomation from both talbes and display on the screen
