I'm looking for an asp page to detect if there are any characters in my
contact form that shouldn't be there. For example, if there is a "<"
character, then this may mean there is html in my contact form, which
is not good. I want to build a string that has all the values of my
textboxes in my contact form. Its not working? Code:
I've seen alot of boring forms where a vbscript window will popup if the user submits a bad word in the form. Does anyone know of a tutorial or how to make a bad word filter written in asp that basically goes through an array of bad words and if detected the output would be something like:
<%response.write("Profanity is not allowed.")%>
I have set up a database, myDB, in MS Access. one of my Table, myTable, has columns Col1, Col2, ..., Col10. Depending on some scenarios, I insert some values in some (but not all) of the columns. Now I want to delete those records that their col3 is null or nothing is set.
I used col3= '' and col3=NULL in the below statement
objRS.Open "SELECT * FROM myTable WHERE col3 = '' ", myDB, , , adCmdText
but none of them works.How to delete a record based on Null value filtering?
First, thanks to all who have helped me over the last few weeks !!
I have a form that allows the user to select multiple options.
These are user names:
Fred S
Bob D
Paul G
Dave O
When the form is submitted, I'm getting the details using
user = request.form("user")
this is returning the mutliple options.
What I would like to do is pass all the options to 'user' but at one
point on the results page only show the first user selected, not the
multiple selection
I need to build an ASP query to search a property size that is between minimum and maximum values (in two text boxes in a form). Here is the SQL statement I use:
mysql="select Center_name, Store_name, Address, Phone, Size, Type, APN
from delamo where size >= '"&min& "'"
But when running the code I got an error message "Data type mismatch in criteria expression."Do I need to dim both min and mas as numbers?
I have very look strings which are o be stored into Textarea. The field in a memo.upto 3kin lemgth. What I woul like o do is format the text before it jits the testarea; eliminating thing like a single !,.:# which cause errors and then return it on the way back out to be placed back into htr textarea.
View Replies View RelatedI transfer two search filters as defined from dropdown list on first page. The details are passed to my search page where i try to query the database to display the records which meet the conditions of passed variables. Code:
View Replies View Relatedi have a database with person's data: lastname, language (these two columns used for filtering).
i've created a search page with a list menu with "language"s and text box for last name. how can i filter based on last name OR language OR both. how do perfomr a filter if one is missing (let's say "lastname")?
anyone have any tips on creating a search results filter to provide the best
matches first? we're using an access database as part of a very small custom
CMS, and we need to site search function that doesnt just output any base
matches for a given term.
I have a Crystal Report 9 that gets its info from a SQL database. I
installed the RAS in a Win2K server. The report lists from the
database all the invoices. What I'm trying to do and I'm unable it's
to filter the results and only show the one that I want.
I have de following code:
currently i building a forum, that why i need to filter some bad word that input by the user. i don want that bad word to come out in my forum.
View Replies View RelatedI am making a small ASP application that retrieves data from a MS access file and what I'd like the application to do is to retrive only data about items that expire in the current month. I have been trying to figure it out for a while now and have not been able to find the right tools yet.
If I try to explane a little better then the problem is that I need this to work automaticly. I have already made the application retrieve the right data but I have to change the filter conditions every time a new month starts. What I need is to have these changes made automatic.
I am trying (with Classic ASP) to pass from a form multiple selected check boxes. These are the days of the week. On the receiving page I need to check for the selected days between a date range (eg. 1/12/07 - 24/12/07) and write those dats to a database.
eg. all mondays and thursdays in the date range. I can wite the thing in vba no problem but into a web page and no satisfaction.
I have a set of db results that I cannot filter completely in my query and I'm trying to figure out how to eliminate the "duplicate entries" after the fact.
My problem is I'm pulling columns for lot number and transaction time, but some (not all) lot numbers have two transaction times so I can't filter out these double entries with a "DISTINCT" statement in my query since the transaction times are distinct, but I only care about the first one. I'm looping through pulling my results as such: Code:
I was trying to set up 3 menue drop downs for filtered relational selections of 1st-(Buildings), 2nd (Departments) followed by (Projects). I foillowed all the links and can not see how to get a onchange to work as relational menue. This would have been best. But 3 days later I am tight for time so I was attempting to just setup of the time being 3 seperate drop downs with submit. I can only get the departments to work. The building and projects will not filter as the departments. Code:
View Replies View RelatedI am trying to filter a table of users to select only those records
whose roleID matches a value in an array. There could be any number of
IDs held in the array from one to a few hundred. The array is
generated by splitting a comma delimited memo field from a second
table in an Access DB. I can split the memo field OK, I can
response.write its values, but what I now want to do is add a value
from another table to my reponse write loop. Code:
I´m having a problem using ASP Upload with an insert form..
If I use ENCTYPE="multipart/form-data" the all the parametres i might get with request.form don´t appear.. but i can upload the files.. Besides if I take away the ENCTYPE tag, i can´t upload but the INSERT INTO form works propertly
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). 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 as follows:
<form action="dropboxsubmit.asp" method="post" enctype="multipart/form-data">
<input type="file" name="FILE1" size="30">
<input type="text" name="def" value="0" size="10">
etc.....
and can't get my asp to recognize data in other form input boxes using Request.Form
Any thoughts?
In my prototype asp page (with no javascript and no password validation, I have a registration form with the following action:
<form name="form" method="post" action="RegDetails.asp">
This works fine, the form details are collected by RegDetails.asp
I am attempting to include javascript server side validation for the pasword, which obviously requires password and password2 fields (to be verified). I have used the script available at:
http://javascript.internet.com/forms/val-pass.html
It works fine in a new blank page with the form action:
<form name=myForm onSubmit="return validatePwd()">
The final stage in this javascript demo form displays an alert box:
else {
alert('Nice job.');
return true;
When I change the first line of my original form to:
<form name=myForm onSubmit="return validatePwd()">
how do I get my original action of - action="RegDetails.asp" instead of this alert box?
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:
I have some ASP server-side code that works perfectly when the client is running on Windows (IE, Netscape, Firefox, etc.) but doesn't work at all when the client is running on Macintosh (IE, Omniweb, Safari, etc.) This is the client-side Javascript code:
View Replies View RelatedIm having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Heres the script Code:
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.
<%@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....
I have a series a forms that submit data to different tables in a database. As it stands, when a user completes FORM 1 and clicks the SUBMIT button, the FORM 1 data is submitted (action = form2.asp, method = post) to ASP code at the top of FORM 2 (request.form("form1 field name") etc...), and submitted to the database with SQL code, also at the top of FORM 2(INSERT into...). Hence the submit button on FORM 1 directs the user to FORM 2, and submits the data which is exaclty what I wanted. However, I now need the users to submit multiple sets of data with FORM 1, and direct them to FORM 2 once they have finished using FORM 1. Most importantly, I need to pass a few parameters from FORM 1 to FORM 2, and have these parameters submitted to the database.
My main problem is getting a fresh form1 after submiting the same form1, in preparation for anoter set of data using the same form. Basically, the database has 'one to many' relationship tables. Form1 and form2 are both populating the 'many' tables, so that each form needs to be filled-in several times while retaining the key field of the 'one' table. At the moment submiting form1 takes me to form2. Is is possible to submit the data to the database, get form1 back again to submit more data, as many times as required, then click another button to load form2 when the user is finished with form1?
Can anyone please give me some pointers? or at least explain the concept of what I need to do. I am a novice and it's taking me a while to get to this stage. Any help will be greatly appreciated.
Is it possible to post FORM1 to itself and insert the data (i.e. place the request.form at the top of FORM 1) If so, how do I direct users to FORM 2 while retaining my parameters?
While I can extract the option value from the following:
<Select name='Keystring' MULTIPLE>
<option value='1' name='status'>Pending</option>
.....
</select>
I cannot seem to extract the corresponding 'display' value when I do a
For...Next Loop:
for each keystring in Request.Form("Keystring")
keystring=request("keystring")
Next
How do I aslo get hold of that 'display' value eg 'Pending'...is it
possible?
I have a simple form to accept two form fields and display the values
entered on pressing the submit button. The following is the form I have
created to accept the two entries and display the form fields on
pressing the submit form. It does not work can somebody please correct
the code or provide a simple equivalent code where I can have the form
and the validation and usage of the form values in the same ASP page.
Code:
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
View Replies View RelatedI 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.
I have an html form where a serial # is entered and goes to an asp page to determine wether it is a res or comm number, then directs to another form where they can finish entering info to register the serial number. I want the second form to display the serial # entered in the first form. How do I do that??
View Replies View RelatedI am trying to create a form where the user can check a box within a form and the address will fill in automatically from a previous address in the form, without submitting the form.
View Replies View Related