Been a while since I've done any asp coding, but happy to be getting back
into it. My question is what is the best way (now) to handle apostrophes
coming in from forms and going into the database? I remember I used to use
a replace function replacing single quotes with two single quotes in one of
my old apps.
Is this still the best way, use this function on all fields I
think an apostrophe may come in, or on all fields? Or should I use a
javascript regular function (which may not even work due to a client
disabling this feature on their browser)?
when i type special char. on the textbox of my asp page. it shows the character but saving it and retieving it->gives different value. e.g when i press alt+152 it accepts ÿ but after retireving the same it gives the value as ÿ.
I have an apostrophe in an access database in a name. e.g. O'Brien. When I read this value back into some script the apostrophe seems to be terminating my script.Unless of course I have mis-understood what's going on Are there any rulesguidelines for this sort of data handling
I did a search about inserting names that have apostrophe, and found something about escape apostrophe? how to do that? When the user tries to insert a name with an apostrophe it blows up. Also the delete page I have doesn't like names with apostrophes in the where clause.
I need to insert field data with apostrophes into Access. However, I keep getting "object expected" errors when I post. I heard about using the replace function like this:
var incidentlocation = Replace(Request.Form("incidentlocation"), "'", "''");
but I get the "object expected" error. What I am doing wrong? My code is below in the text file.
I have a page where students can choose activities in a day... this then directs them to their timetable for that day.
However, if they go back to the choose.asp page and they have already registered, I redirect them to timetable.asp - because I don't want them to change their options.
I have their username stored as a session variable and it works fine for most students - however for the example student O'SMITH-JONESMark the page falls over.
I am using Dreamweaver's 'redirect if username exists' server behaviour. Code below... Can anyone tell me how to fix this so the code is not tripping up over the odd characters? Code:
I have been trying to find a script on the net that would allow me to handle directory listings through ASP. I'm basically looking to change the default generated pages when browsing directories. Eventually I would love to be able to change which directories/files show based on permissions and be able to allow uploads to current directory listings.
I am attempting to use url's on a database driven webpage - the url's are really ugly (created by mapquest) - I have tried to put " quotes " around the urls in the database as well as without - but all i get is a blank about page, can anyone help.
Here is my code: <td><a href="<%Response.Write(rs("Directions"))%>" target="_blank">Directions</a></td>
How do i do error handling using asp. Like taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [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.
how can i handle such cases and where do i place the code???
I have a piece of code which causes an exception. Now i don't know why that is. I would like to know the best way to debug the exception.
I know about try and catch statements. However with these you need to have a basic idea of the type of exceptions that could occur. Does someone have a better suggestion on how to debug an exception?
I want to error handling in ASP. But i think that ASP is not enough for error handling. I have got two chance. 1. I can prapare an error page and control throught IIS. 2. I can use on error resume next. For 1. This is a general handling. I want to handle local error. Maybe i do special thing when error occured. For 2. I have to write alot of lines code. I have to control every line.
The numbers represent a predefined access permission to a certain file.
I need a function to sift through the first string, and compare it to the second string. What numbers are located in the second string, which are are located in the first string need to be removed (from the second string) leaving only unmatched numbers beind.
Is there a possiblity that, when an error comes in asp page in server, especially with sql script, to hide that error from user and display just Error, report to admin,
i just want to make a general case where when an error comes i should take the page to report to admin.
so as not to crash my database. Only problem is, when i take a value out of the database it now has two quotes instead of one (example Linda D'Agostini --> Linda D''Agostini)
i want to create a long string and save it inside rs("history") what is the best way to save texts every action. with comma(,) in the end? and how when i want to view the list i will be able to add <br> after every comma in order to view this all list normaly?
I am using global.asax to handle my web application exceptions and have configured it to create event log entries for errors that occur and to display an error page advising the user to contact the helpdesk. I have an intermittent uninitialised object error that I am not able to reproduce in test and for which I really need the source line number. I believe this information is contained in the PDB but am not sure if one is created if I set the debug="true" flag in the compilation part of the system.web section of the web.config when the application is recompiled.
I have written some code to query a database and create a hyperlink based on a value, however, if the value comprises of more than one word, the hyperlink only references the first part of the value. e.g. For instance, if the value retrieved is "the strokes", the hyperlink will only contain the word "the".
i have a scenario where i have to serve users of my site questions on daily basis,but before they can answer a question they must answer a previous question correctly served previously before the current day .
This means to me that i have to keep a log of each questions served each day and users response whether they attempt the questions or not .i am scared to keep a scenario of a million users each day,their actions on a particular questions.what is the smartest way to achieve this.
We are interfacing an ASP page with a COM object. In the COM object, if there is a condition that makes it not possible to perform the requested action, an exception is raised that can be caught by the calling application.
When an exception is raised by the COM object during the processing in the ASP page, the processing seems to lock up on the ASP side on the line of the function call that raises the exception.Has anyone else ran into similar issues? If so, how can we work around them?
how i can handle errors on ASP page. Actually i want to maintain a ErrorLog in Database and want to redirect the user on an Error.asp page where i can show him the error details(i-e error #,Description etc).
I have found "With Endwith" method to handle errors but the problem is that i can only write it with a record set and it will handle only record set related errors and also i have to write With EndWith with each recordSet but i want to handle any error on page at a single place.
I have a dynamic asp page that takes input from a url. IE: parts.asp?sku=543 From there it looks up the sku in a database and outputs the part information. Currently if you put in an invalid sku that is not in my database, you just get a Internal server error.
Whats the correct way to give a 404? Do I just do a Response.Redirect to my 404.asp page if the recordset is empty?
I'm using a Firebird database to store user comments using my web app that I wrote in ASP. Some fields are mandatory. some are not. Whenever I leave the textareas blank, Firebird stores them as empty text. Anyhoo, the blob fields are subtyped to text 80 segments wide.
I'm using reponse.binarywrite() to output the text into text areas. If there is something in those blob fields, all goes well. But if there isn't anything in the blob fields or I leave a couple of the blob fields blank, the program crashes. So I decided that I want to check if there is something in the blob field, before binarywriting it. I tried comparing it to the string "" and checking to see if it's null but to no avail. Something about a type mismatch error. The exact error message is:
Response object, ASP 0106 (0x80020005) An unhandled data type was encountered. /tracking/updateproject.asp, line 314
line 314 is where I'm binarywriting the blank data.
I have an edit form for records that belong to numerous categories. Records are joined to categories with a join table in a many-to-many relationship.
When displaying a record for editing I loop through the category recordset, looping through the entire join-table recordset for each category, to tick (or not) each checkbox as it's displayed.
This seems like a costly way of populating checkboxes. Is there a more elegant solution?
