Re: Cleaning strings for SQL with WebCat

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 63675
interpreted = N
texte = Thanks Donovan. Doesn't [URL] mostly handle line breaks and spaces? I guess my point is, what I am most concerned with is quotes, single quotes, semi-colons, etc. Those type of characters are *legal* within a -url if I am not mistaken. That is why I thought perhaps [grep] could detect quotes and replace them with \" -which is compatible with sql. For some reason this didn't work, perhaps I am doing it wrong.I am trying to do something like this:ex:cBody = "Hello World" , 'Hello World'[text]cBody=[grep search="&replace=\"][cBody][/grep] --- look for quotes and escape them[text]cBody=[grep search="&replace=\'][cBody][/grep] --- look for single quotes and escape them.Needed result: cBody = \"Hello World\" , \'Hello World\'Basically, look into the message body for quotes and single quotes and escape them for the sql db. Seems like the above should work, but it doesn't.Donovan Brooke wrote:> Adam O'Connor wrote:>>> Can anyone tell me the general method on cleaning strings with webcat >> for preparation to sql. For instance, is there a webcat method of >> cleaning/escaping strings like php's clean() or .net's string >> cleaning? I have been working with [convertchars] and [grep], but >> still haven't been too sucessful. Figure if I would ask before >> considering other methods, ie php, c#. Any help appriciated.>>>> -thanks for answering my last question Nitai>>>> [url][/url]>> will create asc11 characters of the non-url compatible characters..>> Donovan>>>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
Re: Cleaning strings for SQL with WebCat ( "Nitai @ ComputerOil" 2005)
Re: Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
Re: Cleaning strings for SQL with WebCat ( Donovan Brooke 2005)
Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)

Thanks Donovan. Doesn't [url] mostly handle line breaks and spaces? I guess my point is, what I am most concerned with is quotes, single quotes, semi-colons, etc. Those type of characters are *legal* within a -url if I am not mistaken. That is why I thought perhaps [grep] could detect quotes and replace them with \" -which is compatible with sql. For some reason this didn't work, perhaps I am doing it wrong.I am trying to do something like this:ex:cBody = "Hello World" , 'Hello World'[text]cBody=[grep search="&replace=\"][cBody][/grep] --- look for quotes and escape them[text]cBody=[grep search="&replace=\'][cBody][/grep] --- look for single quotes and escape them.Needed result: cBody = \"Hello World\" , \'Hello World\'Basically, look into the message body for quotes and single quotes and escape them for the sql db. Seems like the above should work, but it doesn't.Donovan Brooke wrote:> Adam O'Connor wrote:>>> Can anyone tell me the general method on cleaning strings with webcat >> for preparation to sql. For instance, is there a webcat method of >> cleaning/escaping strings like php's clean() or .net's string >> cleaning? I have been working with [convertchars] and [grep], but >> still haven't been too sucessful. Figure if I would ask before >> considering other methods, ie php, c#. Any help appriciated.>>>> -thanks for answering my last question Nitai>>>> [url][/url]>> will create asc11 characters of the non-url compatible characters..>> Donovan>>>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Adam O'Connor"

DOWNLOAD WEBDNA NOW!

Re: Cleaning strings for SQL with WebCat

2005

Top Articles:

Related Readings: