Handling Text Input To Database
how do i allow the user to add in a value that has a ' in it (e.g int'l) in the form. apperantly if i do that there will be an error... how do i go about this?
View Replieshow do i allow the user to add in a value that has a ' in it (e.g int'l) in the form. apperantly if i do that there will be an error... how do i go about this?
View Replieshow do i allow the user to add in a value that has a ' in it (e.g int'l) apperantly if i do that there will be an error... how do i go about this?
View Replies View RelatedI'm using Access Database with ASP. There is one particular thing that I
have issue with.
My purpose is for user to update their own profile. Their existing profile
information will be display in Edit Form format. The problem is if the field
has space, the second word will not display, when I display in input text
format.
E.g if My first name "User_FirstName" in my table has entry, let say "David
Johnson" as FirstName, when I execute following code and do a input text, it
will display "David" only. Code:
<INPUT TYPE="FILE" SIZE="50" NAME="FILE2">
I have this form field that I'm processing on another ASP page on submission. How do i determine if this field has had any data input? I tried
<% Request.Form("FILE2") %>
but it does not have any value. What am i doing wrong?
How to do the error handling if the users key in character into integer text field? If possible, please give example and show me the coding.
View Replies View RelatedWhat I need to do is parse a string, then create variables for each word. Example:
- someone enters "cats and dogs" in the text field
- I need to end up with:
firstWord = "cats"
secondWord ="and"
thirdWord ="dogs"
Then I will use the variables firstWord, secondWord, thirdWord later in my app.
Have an ASP page on internet, where I let the user write his email address. Today I see that this text input field has got a yellow background instead of the normal white as the other input fields. The code is quite normal. Using IE 6.0.2900. It has not appeared before. Then I rebooted the computer,but got the same result.When I try another computer, also with XP pro and the same IE, the text input is white as it should.
View Replies View RelatedI have a form with an text box called keywords. I want to get the text typed in by the user from this box (which will pobably be built up of several words).
I have declared arrsplitkeywords to assign these words to. But first i have split the input from the text box where there is a space. See the line of code below:
arrsplitkeywords = Split(Request.Form("Keywords"),",")
I now need to replace this so that the words are split up to be split like "','" I have the following line of code to do this:
Replace(arrsplitkeywords,",", "','")
This doesn't appear to work, and on the replace line i get the following error:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
Any help please as to why this isn't working?
I want to capture the value of variable into a hidden input test field, using the following code.Code:
<input type="hidden" name="selectedby" size="20" value="<%'strNTUser'%>">
When i run the code the variable value is not captured in the field "selectedby". strNTUser is the variable.
i made database with these fields :
id ,name , address ,favo ,email , phone
now i did every thing ok i can add data readdata search by on of any field.
but i do not know how can i search with 3 fields .
i mean i need page include 3 input text one for name
2nd for email , and 3rd for phone . also botton for search
but i want when the user do not input any name or email and click on search botton popup messege come tell you must input all fileds then back to search page . if he input all and click search i want new page read data from database.
I am trying to build an asp page the displays 100 characters from text inputed into a text area. The page keeps breaking because it counts any HTML code the text might have. I would like to have it count the words instead and when I write out the words it includes any underlying html.
For example, here is a sentence: "The fox jumps over the lazy dog" and I could cut this sentence in half by counting out the first 18 character and only outputing those respectively. Everything would work just fine. But if the sentence is like this "The fox jumps <a href='http://www.microsoft.com' target='_blank'>over</a> the lazy dog." a simple letter count no longer works for me. If I printed out the first 18 characters then it will break my "href" tag and therefore would mess up the formatting of my page. Can someone point me to an article or component that will assist me in correcting this?
I want to create some text input fields which they should all have the same size regardless the browser version or type. Because my text input field looks different in size if I view them from a different computer. Is the following coding should solve the problem?
<input type="text" name="field" value="" size="30" style="width:300px;">
Is the best way to use CSS to control the size of a text input field?
If I try and add a record with a duplicate primary key I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. Code:
I want to change the text color of the input box depending on the value entered by user.
View Replies View RelatedThis problem only occur when ppl using NetScape 7.2 I've tested it myself and it works in IE and it DOESN"T work in NetScape 7.2 Here is the code:
View Replies View RelatedI have a website with a Guessbook section. Lately I noticed someone copy and pasted a long http address to promote viagra.. I believe he simply copy and paste the whole link into the text input field and submit several times. It created multiple entries in my guessbook.
How can I prevent this? I was thinking if it is possible for me to write some code to disable people using the control-p to paste text in my text input field.. Can I really do that? What other options do I have?
I want to have a user input a value (1 through 10) in a form. Then click submit. and right under that have text appear depending on what they input. This is what I have, but it doesn't work. I'm not understanding the flow of the script getting called. Code:
View Replies View RelatedIsn't there some line of code that I can write to tell ASP to treat everything between BLAH and /BLAH as text (including the apostrophe). So that users can type a name of "O'Malley" in a form and I can retrieve it and store it in my database.
View Replies View RelatedI need to know how to handle errors if a write to the database fails. Here's the pseudo-code:
View Replies View RelatedI am currently making a form in asp and when i make the text boxes they are all formatted to the same size, even if I use the width=*** to change the size? Is there another way to make the input text boxes smaller or bigger?
View Replies View RelatedWhen simultaneous requests to open an Access Database occur, the Jet Database engine returns an error stating: Cannot Open file, already in use.
I know this occurs because I'm using a file-based Access database, and it's locked while data access is taking place. However, at this time, its the only platform available on the site.
My question is, can I somehow use an On Error GoTo Blah statement to catch the error, clear it, and then attempt the ADODB.Connection.Open statement again?
So far I've been using Sets to read information from the database (Set RS = Server.CreateObject("ADODB.RecordSet") and RS.Open queryString, Conn)
I've got a situation now where I have a function which returns just a single value. I call this function using "SELECT myFunction(parameters)". I can't use a result set to retrieve the function return value, can I? How should I do it?
i'm trying to show a message where a user can print after checkout. i have 2 pages, the checkout page and the validate order page, where the checkout page displays a form and the user will fill this page and submit the order, then the order will be stored in the database in a table called Orders where the Order ID is generated automatically, and the date is also stored using the date function.
now what i need is after the order is being stored in the database the validate order will be called to display the message that the order has being received, well i need to add the two fields (Order ID, date) from the Orders table based on this specific order.
How can i do that ?
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.
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
zip table
id, zip, contactid, city
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
zip table
id, zip, contactid, city
I have a little code to add multiple items to a shopping cart based
page. This code works perfect, but it adds all of the info to the
same input fields every time it loops. I need it to change the input
names each time it loops. Here is the code:
I want o create a small site and I dont see the need for a database. So I want to use a text file for this site but I don't know how!
I know I can use Mysql or Access, but I don't want to. I simply want to use a flat file as it is called.
My site is an ASP site, so can anyone guide me on how to use "flat files" for databases
how can i format text so it can be read by a database? for example, for numbers i do cint(whatever). whats the equivalent for text?
View Replies View RelatedI have 2 textboxes. In first text box i need to enter name, the second text box shud be automatically filled with the person'd id.
Both the name and id is coming from database. I tried using this code, but i'm getting error saying System.NullReferenceException: Object reference not set to an instance of an object. at line 1 Code:
i am building a search form by word from text field in a table. for example the table has
1. ID
2. Price
3. Note
the Note field of a record could have sentence that contains words or jargon. What sort of method or approach can i use to solve the problem? can we use sql statement? if yes what sort of?
Is it possible to store html tags in a database field so that when data is retrieved from this field the formating is retained? For example I have an address field in my database, which I return using:
<p><%=(rsType.Fields.Item("DAT_Address").Value)%>
However they are times where I may want to have my city, state etc on seperate lines by using <br>, but right now if I store a <br> in my database it does not affect the formating of my displayed address.
I have a text field i am pulling from a database that uses vbcrlf to create line breaks.
I used the following code to replace them:
response.write Replace(rs_classes.Fields.Item("DESCRIPTION").Value, VbCrLf, "<br />")
But ran into the problem that when the field is blank, I get an error that shows a problem w/ the "replace" function.
So I tried the follwoing: Code: