Re: SQL Madness

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62671
interpreted = N
texte = Ugh, that seemed to help. Thanks This brings up a couple of things. First a couple of questions. How will this effect searches with keywords which contain items like spaces. It appears to work with those as well, but I am a bit worried that url'ing the string will cause some issues searching a SQL table where stuff isnt url'd going it. Second, is it safe to say that this is NOT supposed to be happening. IE: the string should not be unurl'd without me telling it to do so explicitly? Is it likely that this 'behavior' will change? And on a side not, in the face of having no solution, I rewrote all the code to create webCat tables and all my searching is done that way though the data is also stored in SQL for lots and lots of reasons. Sux that I had to rewrite the code for adding/editing and search but oh well... Its about 3 times as fast so I guess that's a good thing. Any thoughts on the question above. It will take some more testing before I can convince everyone that its a foolproof fix but it looks like a start. Alex On 7/27/05 2:59 PM, "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%' > > is getting changed to > > LIKE 'T1%' > > before being sent to the SQL server. > > You may want to experiment with the [URL] context. Perhaps try: > > LIKE '[URL]%[descriptionvar]%[/URL]' -- Alex J McCombie Adventure Skies Interactive (ASI) Owner Box 124 888/892.6379 MartVille, NY 13111 Alex@Adventureskies.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- 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)
Ugh, that seemed to help. Thanks This brings up a couple of things. First a couple of questions. How will this effect searches with keywords which contain items like spaces. It appears to work with those as well, but I am a bit worried that url'ing the string will cause some issues searching a SQL table where stuff isnt url'd going it. Second, is it safe to say that this is NOT supposed to be happening. IE: the string should not be unurl'd without me telling it to do so explicitly? Is it likely that this 'behavior' will change? And on a side not, in the face of having no solution, I rewrote all the code to create webCat tables and all my searching is done that way though the data is also stored in SQL for lots and lots of reasons. Sux that I had to rewrite the code for adding/editing and search but oh well... Its about 3 times as fast so I guess that's a good thing. Any thoughts on the question above. It will take some more testing before I can convince everyone that its a foolproof fix but it looks like a start. Alex On 7/27/05 2:59 PM, "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%' > > is getting changed to > > LIKE 'T1%' > > before being sent to the SQL server. > > You may want to experiment with the [url] context. Perhaps try: > > LIKE '[url]%[descriptionvar]%[/URL]' -- Alex J McCombie Adventure Skies Interactive (ASI) Owner Box 124 888/892.6379 MartVille, NY 13111 Alex@Adventureskies.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- 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/ Alex McCombie

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:

Multiple adding (1997) [accountNum] and [math] (1997) Replace and Autonumber (2003) Web*3 virtual hosting Webcatalog problem (1998) WebCatalog Technical Reference (1997) WebTen? (1997) Only charge card when product shipped ? (1997) Follow-Up to: Removing [showif] makes a big difference in speed (1997) WebCatalog 2.1b3 - Plugin or cgi ? (1997) World Address Info (2003) Sort Order on a page search (1997) Separate SSL Server (1997) Random Order Sort? (2000) FileMaker and WebCat (1999) Showing Results Alphabetically in Columns (top to bottom) (2002) users change an email address (2002) inconsistencies (1999) Updating a database once per day - An example (1998) WebCat 4.0 & WebMerchant (2000) Running a store on BOTH http and https (1998)