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:
docs for WebCatalog2 (1997)
extended ASCII with middle command (1999)
RE: Missing contexts on NT (1997)
Where is the bug fix info for 4.0.1? (2000)
WC Database Format (1997)
[Announce]: Web server security and password protection (1997)
Dark Horse Comics success story (1997)
Execute Applescript (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
shownext & searchstring (2000)
ADDEMDUM: Which beta for w* 4.1 and a problem w/b12 (1999)
select multiple (1997)
Dieresis in [sendmail] (1999)
Truncated numbers (2000)
orderfile location (1999)
multi-paragraph fields (1997)
maybe even an easier plan to satisfy need for solid tech support? (2000)
WebCatalog NT (1996)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
WC2b15 File Corruption (1997)