Handling Apostrophes And Other Characters
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)?
View Replies
ADVERTISEMENT
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 ÿ.
View Replies
View Related
When I insert info into a DB from a form, it cuts the string off at the first apostrophe (").
How would I make it insert the data as-is, with the apostrophes? Here is the code used to insert the Data:
View Replies
View Related
I put in some code to keep apostrophes from being a problem. However, on the
display page, they have double quotes. What am I doing wrong?
Here is the code on the page which captures the data from the form, right
before it gets entered into the database:
------------------------------------------
strInternalDesc =
Replace(Replace(Trim(Request.Form("InternalDesc")),"'","''"),vbCrLf,"<br>")
------------------------------------------
then, on the page where it gets displayed, I get:
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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>
View Replies
View Related
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???
View Replies
View Related
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?
View Replies
View Related
I’m trying to write a script that will select some records from an Access database within a certain date range one of the fields is a date. Code:
View Replies
View Related
sql = "SELECT * FROM Calls WHERE Date BETWEEN " &startdate& " AND " &enddate
Where did I go wrong?????????????
Ugly response:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
View Replies
View Related
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.
View Replies
View Related
if I have two strings as follows :
"1,3,45,65,777,89,00
and
"8,9,67,54,89,23
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.
View Replies
View Related
how use the array handling in asp
View Replies
View Related
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.
View Replies
View Related
im following all single quotes as follows:
email = request.form.item("email")
email = Replace(email, " ' ", " ' ' ")
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)
View Replies
View Related
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?
View Replies
View Related
Can you please help me with event handling (for eg: capture key press, mouse overs, mouse_over drop-down menu, on_click drop down box) in asp.
View Replies
View Related
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.
View Replies
View Related
I want to handle events of the AO Connection object in my ASP page. How can I do it?
View Replies
View Related
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".
Here is my code: ....
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
How i can handle the errors in ASP. Please suggest something.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
Like File Uploading, Can I browse a file from local and when i click ok, The file should be read and update the DB. Code:
View Replies
View Related
can anyone tell how to handle exceptions in ASP. please give me any link or explain me if possible.
View Replies
View Related
