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:

emailer (1997) Emailer Error 550 (Was Strange Crash) (1998) List Server (1999) Re[2]: Feature: TCPconnect via SSL (1999) Crashing Server (2000) URGENT! Locked DB's (2001) WebCatalog for Postcards ? (1997) [WebDNA] setcookie then redirect (2013) Clearing orders and database help! (1997) Major bug report on rootbeer (1997) Share Bulletin Board? (1998) Dates (2002) Viewing old carts (was FEW QUESTIONS) (1997) RE: major search problem (1998) WebCat2 several catalogs? (1997) HELP WITH DATES (1997) restarting service remotely on NT (1997) Frustration with formulas.db (1999) Problems with [Search] param - Mac Plugin b15 (1997) webdelivery not working (1998)