I have an order form that dynamically populates item names and item ids from my MS SQL database. These values get put into three arrays that are looped based on the qty selected for insert into a cart table. Everything works except that the values are inserted into the database twice. Here's the insert code:
I've got a form which lets users input HTML code into a database (the user enters their code into a form field, then submits, and the HTML is written to a db). This code is then pulled out of the database onto a web page. It must validate - so needs to have all characters intact.
How do I perform an update statement which lets me insert double quotes into the database? I know it's possible to achieve a similar thing by replacing the double quotes with some other characters on insert, then replacing these other characters with double quotes when the data is pulled out of the db, but this seems a bit messy.
I have a form online, and I don't know if people are double clicking the submit button or what is happening really, but sometimes I will have two or more matching entries in a row. Is there any code I can use to filter out double clicks or tripple clicks even? These forms are done in asp and sent to sendcontactform.asp to process.
I am using an HTML form to post data to my database, but when a users enter contact info into my database I am getting the same info twice, although the user only submits once. Here is my code:
I'm trying to pass data from a <textarea> box to a confirmation page and then pass the same information from the confirmation page to a final page.
When the information gets passed to the final page it is truncating it where there are double quotes. I've tried to do a replace() function to try and escape the quotes out but it's not working.
What I would like to do is the following: Menu box 1 populates all 50 states from an SQL table. Use selects State. Menu box 2 gets populated from SQL table with Al counties in that State. User selects prefered county then hits submit The part I am having trouble with is populating the county menu box.
I have a active server page where records are displayed from a query. The display right now is read only. However, with text box this display can also be edited. The first column shows category while the second category shows category total sales.
I would like to double click on category field to get to another asp page that would show the details of sales for that category value double clicked.
My question is: If there is any double click event that would allow me to pass values to open another asp page.
I am trying to convert the date in DD/MM/YYYY format so it is always displayed as 01/01/2004 instead of 1/1/2004.The script I am trying to embed this into has similar attributes to the Calendar on this site located at http://www.asp101.com/samples/calendar.asp.and the objects that require to be double digits are iCurrent and Month(dDate).
I have some data string like ~!@#$%'^&(*("}[;asd"> which contains double quote and greater then sign, first I need to insert this value into database, second this inserted value I have display in a textbox by retriving from database, as it has "> at end of the string values are getting discarded.
prints as <input type=text value=" Hello "Jim" Lad">
How can I get double quotes to display in a text box or textarea? Using a backslash or &Quot; (with Replace() e.g.) just prints out the backslash or &Quot;
Here's an example of using ASP, CDO and a Microsoft Access database to create a double opt in mailing list for subscribers. It lets the user subscribe and then sends them a confirmation email with a random url that has to be clicked to confirm the subscription. I had a hard time finding a free example so I threw this together for other's searching for something to start their own with.
If user refreshes the browser window, or if user clicks twice onto the submit button, SQL query is executed twice, the table gets two new rows.I found many possible solutions, but not the complete one - every solution has it's problems.
When you want to put double quotes inside a string, how do you verify that the double quotes are not the end to a string? For example, what if you want to write this. Code:
"Response.Write("The words "DEV SHED FORUMS" are in double quotes")
I have created an Intranet in my office using ASP (of course). Within it is a booking system, allowing booking of conference rooms, digital camera and other equipment. It works perfectly...almost, as there is no way to prevent double bookings.
I really don't know where to begin with this one. All bookings go to an Access DB, into a single table. The bookings have a start time and an end time (24hr).
I would like it so that when the user submits the form, if there is a clash in times instead of saying, thanks for your booking, to redirect them back to the booking page saying there is already a booking for this time and that I am very sorry!
I guess I have to check some value in access and return the info back to the webpage before it chooses where to redirect the user.
Some basics to check, does this happen on all machines that submit, or only one. If it is only one, then chances are it has to do with mouse settings on that machine (i.e. double click speed type of thing).
Try checking and submitting on another machine. If it only happens on one machine, try changing the mouse settings on the original machine. Try submitting on the original machine. If this doesn't work, then worry about programming around the event.
Could someone explain when to use double and single quotes? I'm having a problem with an insert statement and I think it may be the quotes. The error I get is a sql syntax error.
The values are variables. I checked the input statements first then assigned to variables. I hoped it would make the sql statement easier for me too read. Also does Access accept null?
IE6 users submit a request to an ASP page which (among other things) sends an e-mail, however, the page appears to be submitted twice since two e-mails are sent.
I have verified that the page is being submitted twice (by IE6 somehow and not through user action) by attaching a time to the content of the sent e-mail. With a single submit at the client end, the server process the page twice and two messages (with slightly different times) are sent.
It would seem that the initial submit initiates the ASP page on the server, then there is a reset at the server end and the submit is reprocessed before the HTML is returned to the client. Code:
I just alanyzed the response of my ASP and discovered that the header "Content-Length" was added twice. I've double checked my application , but it only adds it once, so I think IIS has also added this header. Is there a way to "overwrite" the header added by IIS or to tell IIS not to add this header information?
I have a huge amount of very small responses, so the header may be a reasonable part of the whole response and I want it to be as small as possible. I need to add this manually, because for some responses I use Response.Flush - so IIS simply cannot be sure what amount of data will be there.
I am trying to use ServerXMLHTTP to post data containing Japanese characters, but the data posts as question marks, boxes or just random ascii characters. Here is the code I am using:
2) when highlighting words (in a search results page for example), I want to match the word ignoring case. however, when wrapping the word in highlighting code and replacing the substring, I want to keep the original capitalization.
for example, if the word to match is marvelous, but the word is stored uppercase in the db, the above code will replace the word with a lowercase version. how do I get around this?
3) I want to remove any and|or that are not inside double quotes in a string. for example,
test = """The dog and the cat""" & " and fox or mouse " & """the cat and the dog"""
resulting in "The dog and the cat" and fox or mouse "the cat and the dog"
I would like to remove only the AND OR linking fox and mouse in the middle of the string. how would I do that?
I am using ASP Upload to upload an image to a website. I have other form fields in the form that are used to obtain data and are inserted into an access database. This occurs on the same page as the page that upload the image. Everything works fine except it inserts each record twice into the database. Anyone have an idea what causes this or what I can do to make it only insert once. I am useing the progress bar and don't know if that has anything to do with it. Here is my code.
Set rsPhoto = Server.CreateObject("ADODB.RecordSet") Set Upload = Server.CreateObject("Persits.Upload.1") Upload.ProgressID = Request.QueryString("PID") Upload.SetMaxSize 500000, True Upload.Save ....