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:
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:
WC2b15 File Corruption (1997)
select multiple (1997)
HELP!!! (1998)
PCS Frames (1997)
PCS Emailer's role ? (1997)
a * question (2003)
PIXO Support (1997)
WebDelivery downloads alias, not original ? (1997)
ExpireDate Zero or Greater than Today (2006)
[lineitems] (2000)
Template not found error messages (1997)
Multiple catalog databases and showcart (1997)
WebCatalog and Macromedia Flash (1998)
Help! WebCat2 bug (1997)
HTML Mail & Line breaks... (2004)
Where is f2? (1997)
PCS Frames (1997)
2.0 Info (1997)
WebCat using all my CPU on OS X Server (2001)
NT considerations (1997)