Re: SQL Madness

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62669
interpreted = N
texte = Not sure if this is related, but I found I had to escape the % sign with another % sign in my inserts using the [sqlexecute] commands. \% wouldn't work. It had to be %% Pretty strange... On Jul 27, 2005, at 11:59 AM, Scott Anderson wrote: > Just a thought. I wonder if the '%' in combination with a integer > value for > [descriptionvar] is getting [unurl]'d somewhere in the parsing > process. For > example: > > LIKE '%541%' -- Jesse Proudman Blue Box Group, LLC p. +1.800.613.4305 x801 e. jesse@blueboxgrp.com ------------------------------------------------------------- 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: SQL Madness ( Alex McCombie 2005)
  2. Re: SQL Madness ( "Scott Anderson" 2005)
  3. Re: SQL Madness ( Alex McCombie 2005)
  4. Re: SQL Madness ( Jesse Proudman 2005)
  5. Re: SQL Madness ( "Scott Anderson" 2005)
  6. SQL Madness ( Alex McCombie 2005)
  7. SQL Madness ( Alex McCombie 2005)
Not sure if this is related, but I found I had to escape the % sign with another % sign in my inserts using the [SQLexecute] commands. \% wouldn't work. It had to be %% Pretty strange... On Jul 27, 2005, at 11:59 AM, Scott Anderson wrote: > Just a thought. I wonder if the '%' in combination with a integer > value for > [descriptionvar] is getting [unurl]'d somewhere in the parsing > process. For > example: > > LIKE '%541%' -- Jesse Proudman Blue Box Group, LLC p. +1.800.613.4305 x801 e. jesse@blueboxgrp.com ------------------------------------------------------------- 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/ Jesse Proudman

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:

Custom formulas.db (1998) Changing the value assigned to a formvariable (2000) New WebDNA Solutions ... (1997) Re:2nd WebCatalog2 Feature Request (1996) [WebDNA] Double sendmails (2014) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Running _every_ page through WebCat ? (1997) Bug? (1997) [WebDNA] v7 thisurl has different behavour (2012) emailer (1997) Separate SSL Server (1997) Bad Cookie / Internet Option / Internet Explorer (2004) Re:no [search] with NT (1997) Server Freeze (1998) find with exceptions (1997) Rhapsody? (1997) Why is my easy [AddLineItems] NOT working?? MORE (2000) downloadable txt file (2001) WC2b15 File Corruption (1997) [bump -SMSI] Sitebuilder (2004)