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:

    
  1. Re: Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
  2. Re: Cleaning strings for SQL with WebCat ( "Nitai @ ComputerOil" 2005)
  3. Re: Cleaning strings for SQL with WebCat ( "Adam O'Connor" 2005)
  4. Re: Cleaning strings for SQL with WebCat ( Donovan Brooke 2005)
  5. 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!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Running 2 two WebCatalog.acgi's (1996) [WebDNA] Problem with SendMail - seems succesfull but nothing to (2016) CAPTCHA (2006) Using Cookie for client specific info? (1997) [WebDNA] Quick Grep question (2009) Multiple Pulldowns (1997) Online reference (1997) Problems with date math (1997) Trouble with Netscape (1998) emailer (1997) math on date? (1997) Quitting WebMerchant ? (1997) Checkbox question (1997) WebCat editing, SiteGuard & SiteEdit (1997) Emailer on NT CAN'T handle large email files (1997) Page Breaks (1999) Checkboxes (1997) [OT] Domain Name Scam (2000) Experience with creating real dynamic solutions?????? (1998) Emailer to include Human Name with email Address (2000)