escaping apostrphee in a select statement

[cfdeveloper]

Hi Guys,

I'm passing a url variable a string/text that has a apostrphee in it.

Ex:
mytext = It's a test

I'm escaping it like this:

window.location.href = "somepage.cfm?txt="+escape(mytext);

I'm passing this url varialbe, url.txt to the select statement,

I get an error:

Incorrect syntax near 's'.

Can someone show me how to get round this please.

Best regards
cfcoder

 

[vbkris]

window.location.href = "somepage.cfm?txt="+mytext;

why use escape command???



Known is handfull, Unknown is worldfull

 

[webmigit]

window.location.href = 'somepage.cfm?txt=#urlencodedformat(mytext)#';

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.