I'm trying to create a form that allows me to modify the contents of list. When the user clicks on the modify button, it takes them to a page which displays the quantity of items they purchase, and allows them to update that quantity. So the quantity is shown in a textbox, and the content of the text box is drawn from a rs("content").
But the page is crashing when I run it. I'm having trouble getting the response.write textbox line to work. Here's the code:
I have encountered a problem when a user submits text which contains commas and quotation marks.
Code:
Function ChkString(string) If string = "" Then string = " " ChkString = Replace(string, "'", "''") End Function
I am currently using the above code, but what i have realised is that i am losing whole text that does not get entered into the database, when i wrap commas and quotes around it.
Im trying to text from a scrolling text box into my database but it only inserts the text before return is pressed. Im the field its being entered into is a memo in access. is there a way to get all the text in the box to be inserted?
I'm trying to put some text into the database using ADODB.Command object. Seems like a reasonable thing to do and I can do it. But in this instance my text is an HTML code which contains many quotes. But i have to save it as is into the database field.
I use:
INSERT INTO (f1, f2) VALUES (v1, v2) comand. But since my v2 contains some quotes in it, (many quotes), I get an error. (it works otherwise). Is there any way ?
I need to populate a field with html formated text. I'm using a simple form field to do so.
When I use a textarea to return the record, it comes out formatted, but when I use a Response.Write command, it comes out as plain text. Anyone can tell me how to make the response.write publish formated text?
I am working on a asp and sql website that I did not make. It runs an asp based content management system, where users can enter news articles. They enter the "body" into a text box/area and can add images separatly. The image will show up to the to left of the article.
This goes into a SQL database, and gets pulled out by asp for the webpage. I want to make it so a user can add in an image into the body of the article ( like in a word document ) and have it show up where they put it. What is the easiest way to do this. Both easy on me and the user.
Does anyone know how I can insert daynamic text box data into a SQL Server database? I have text boxes that are being generated dynamically and I want each of those values inserted into the database that hold the results. I'm not sure how to write my loop statement.
how to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:
I am currently trying to build a web app using ASP and MySQl DB. am reading books, surfing the web and reusing other peoples code to get what i want done done Code:
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
how can i insert data from a sub form to the fields in the parent form. I am currently to do a search from at the parent form by poping out a new form. When i got the search result, i will need to click on the selected search result and populate into the parent form fields without any refreshing process as it might reset my form.
I am trying to get a form to insert info into a access database. I am using dreamweaver 2004, i created the form with 4 text fields and a submit button. Ive added a ODBC connection and dreamweaver can qurery my table.
I added an insert record server behaviour, and i figured dreamweaver does all the work for you but when i saved and uploaded the page to my test server it would not submit and redirect to my chosen page, it only refresh the form.Has anyone out there done this before and can notice a step that im missing. Do i need to setup a recordset? because ive tried that as well and no success.
I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.
I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is
.Fields ("fieldname") = Request.value ("name of text box") .update
Any suggestions? If someones willing to help me out quick, I will post my code.
i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).
this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
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 a form on asp page that pulls info from a DB when the page loads. It them puts the info into text boxes on the page that are editable by the user.
The only problem I have is say in the description text box it should read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP" .. It does this on all the text boxes? I can't seem to figure out why it is doing it. Here is the sample code:
Pull text in from a simple notepad file on the server...simply looking for the code to place on page...I had it working in root but when I uploaded to server it din't function..checked permissions etc.
What I want to do is that I have created text box on one form so whenever user type something init and click search button then I want to display that text box value on other form so that i can retrieve a record according to that user's number... Code:
I currently am trying to get a form to send its data to a text file. I use the code I have found in tutorial/help sites around the web, but when I try the code out, nothing happens.
When I click the "Submit" button on my form, I am sent to the .asp file and the code in that file is displayed in the browser. There is nothing written to the text file either.
When the form is submitted I want the new page to determine (Request.Form), both the value, ie 431 etc, AND the text, ie £1.10. Request.Form gets the value, or if there's no value, the text, but how can it pick up both?
Annoyingly, this would be easy in Javascript but I can't find anything on ASP detecting the value.
I'm trying to write a web form that will allow users update info from a database table. Everything is working fine, except the display of the one text field from the database (nothing displays. Here's what I'm trying:Code:
I have a form that has both static and dynamic fields. I have no problem validating the static data, but whenever I try and apply form validation to a dynamic text box that has repeated rows, the validation does not seem to take. Do I have to run that validation through a loop? Code:
I have 3 fields in my form and one of them called ID with multiple text fields e.g (there are 10 text fields for ID) and when you submit the form all the 10 ID's should be submitted to the DB for that particular record with a single space inbetween the 10 ID's. Can any one tell me how this is possible.
i want create a form that include many text boxes and an fiel field for upload a file to server but when i add "enctype="multipart/form-data" in the form tag i cant get the texts . how can i do a form working with file upload and text fields.
I am trying to bind/link 2 text fields on my online form.
So they both should show the exact same text entered in them.
When text is entered in one of them I want to see it in the other text box and vice versa and when text is deleted from one of the boxes it should also be deleted from the other one aswell.
I need to load the file path of a file on a web server into a form text box. I tried using a normal form box using type=file but that just seems to return the file path from the local machine.
Ideally I'd like it if someone can get this to work with a file on a web server without using asp. If not then I suppose I'd have to use the FileSystemObject method. I can see how you can get a list of files from a remote server using FileSystemObject.
The problem I need help with is selecting a file path from the list of files into a text form box. The path of which I am then going to write to a database field.