|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
|
|||
|
|||
|
Character Conversion
Hello,
I need to input into an Access database a string. My problem occurs when the string that I grab from an HTML form has a ' in it. I understand why it is doing it. However I do not understand how to fix it. My question is, how do you grab a string from an ASP page such as: "Hello what's up" and place it into an database through ADO. The problem is the single quote. I know how to insert values into a database. Thank-you |
|
#2
|
|||
|
|||
|
What kind of database you are using ?
In MySQL for example there is an escape character backslash ( \ ) which allows you to work with some special characters in a string: I think there must be an equivalent in MSSQL or others. For MySQL: \\' A single quote character. \" A double quote character. \b A backspace character. \n A newline character. \r A carriage return character. \t A tab character. \\ A backslash character. First you have to replace all single quotes in your strings to ( \\' ) and than insert them to database: Code:
YourNewString = Replace(YourString,"'","\\'")
SQLtext="insert into YourTbl(Colname) values('" & YourNewString & "')"
__________________
Sweet smell of a great sorrow lies over the land. Plumes of smoke rise, merge into the leaden sky. A man lies and dreams of green fields and rivers, but awakes to a morning with no reason for waking. He's haunted by the memory of lost paradise. In his youth or dream, he can't be precise. He's chained forever to a world that's departed. It's not enough, it's not enough. Gilmour |
|
#3
|
|||
|
|||
|
I'm using an Access Database
|
|
#4
|
|||
|
|||
|
It is same with MySQL...
You can use the info in my first post |
|
#5
|
|||
|
|||
|
I already tried using replace(str, "'", "\'")
However, when I use this, and I try to Update the information in the database, I get the following error: Microsoft JET Database Engine (0x80040E14) In operator without () in query expression ''1. \' In '. I tried replacing the \' with other characters, and those work fine, however the value in the database is then incorrect. I also tried putting "\" & chr(39) for the last parameter of the replace function, however, this didn't work properly either. |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Character Conversion |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|