try replacing that
<pre><font size=1 face=Courier>s.replace...... </font></pre>
with
<pre><font size=1 face=Courier>replace(secretQ," ' ", " ' ' " ) </font></pre>
although i cant be sure, i'll try recreating the databse you've made

Edited by - Arcon on 6/18/2004 4:33:32 AM

thx for the reply but...
those changes are for database only

the problem lies before the database insertion
try putting a'jime as an input
it is likely to have 'a' inside the data base and not "a'jime"

argh i'm never gonna get paid, Goodbye a million credits

Arcon... related to Derek Smart?

NEVER!

-~-~-~-~
There is no Silicon Heaven! But where do all the calculators go ?

You could no more evade my wrath... than you could your own shadow!

Ajim, i'm not sure what you're on about. I've done it just showing it to screen and it runs fine with single quotes.

i have a question though:
- your getting a list of secret questions from the database, yet you keep overriding the variable you;re saving it to each itteration of the loop.. you're insane!!!

my code for page 2:
<pre><font size=1 face=Courier>
SecretQ = Request.Form("txt2"
'SecretQ = replace(SecretQ, "'","''" ' un comment this to replace the single quotes
response.Write(SecretQ & "<br />"
sql = "UPDATE login SET SecretQ = '" & SecretQ & "' WHERE user = '" & user & "'"
</font></pre>


"If i told you a secret you wont tell a soul,
will you hold it and keep it alive"

Edited by - Arcon on 6/20/2004 12:12:18 PM

nah it is overriding the value but i only take the last value it takes, and yes it is the only way i found on getting the value i desired for the variable. (save memory anyways) :p
But still the prob lies in that d@## apostrophe i'd (<<<see how this has no problem) really like to know how this site solve's (<<here also) it. Oh Mighty bargib I summon u with these bananas in trade for some knowledge

argh i'm never gonna get paid, Goodbye a million credits