Re: SQL Madness

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 62673
interpreted = N
texte = Given that the entire SQL query is itself a 'value' of the [SQL] 'statement'parameter, and that it is 'normal' behavior for WebDNA to [unurl] parametervalues when parsing a context, I would have to say that this is the correctbehavior.I also think that [url]ing the search value in this case should not causeany other complications, and may yield more consistent results.But I also have to acknowledge that the topic of when to URL or UNURL, canbe a bit confusing at times. If you feel that any of my statements aboveare not consistent with behavior you are seeing, I will be happy toinvestigate this further.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfAlex McCombieSent: Wednesday, July 27, 2005 12:13 PMTo: WebDNA TalkSubject: Re: SQL MadnessUgh, that seemed to help. ThanksThis 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'ingthe string will cause some issues searching a SQL table where stuff isnturl'd going it.Second, is it safe to say that this is NOT supposed to be happening. IE: thestring should not be unurl'd without me telling it to do so explicitly? Isit likely that this 'behavior' will change?And on a side not, in the face of having no solution, I rewrote all the codeto create webCat tables and all my searching is done that way though thedata 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 ohwell... 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 Ican convince everyone that its a foolproof fix but it looks like a start.AlexOn 7/27/05 2:59 PM, "Scott Anderson" wrote:> Just a thought. I wonder if the '%' in combination with a integer valuefor> [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 124888/892.6379 MartVille, NY 13111Alex@Adventureskies.comInterface 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 toWeb Archive of this list is at: http://webdna.smithmicro.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:

Re: SQL Madness ( Alex McCombie 2005) Re: SQL Madness ( "Scott Anderson" 2005) Re: SQL Madness ( Alex McCombie 2005) Re: SQL Madness ( Jesse Proudman 2005) Re: SQL Madness ( "Scott Anderson" 2005) SQL Madness ( Alex McCombie 2005) SQL Madness ( Alex McCombie 2005)

Given that the entire SQL query is itself a 'value' of the [SQL] 'statement'parameter, and that it is 'normal' behavior for WebDNA to [unurl] parametervalues when parsing a context, I would have to say that this is the correctbehavior.I also think that [url]ing the search value in this case should not causeany other complications, and may yield more consistent results.But I also have to acknowledge that the topic of when to URL or UNURL, canbe a bit confusing at times. If you feel that any of my statements aboveare not consistent with behavior you are seeing, I will be happy toinvestigate this further.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfAlex McCombieSent: Wednesday, July 27, 2005 12:13 PMTo: WebDNA TalkSubject: Re: SQL MadnessUgh, that seemed to help. ThanksThis 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'ingthe string will cause some issues searching a SQL table where stuff isnturl'd going it.Second, is it safe to say that this is NOT supposed to be happening. IE: thestring should not be unurl'd without me telling it to do so explicitly? Isit likely that this 'behavior' will change?And on a side not, in the face of having no solution, I rewrote all the codeto create webCat tables and all my searching is done that way though thedata 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 ohwell... 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 Ican convince everyone that its a foolproof fix but it looks like a start.AlexOn 7/27/05 2:59 PM, "Scott Anderson" wrote:> Just a thought. I wonder if the '%' in combination with a integer valuefor> [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 124888/892.6379 MartVille, NY 13111Alex@Adventureskies.comInterface 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 toWeb Archive of this list is at: http://webdna.smithmicro.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/ "Scott Anderson"

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:

[WriteFile] problems (1997) OT: javascript help (2003) OT - good CC processor(s)? (1999) RE: WebCatalog2 for NT Beta Request (1997) Spamming this list! (2000) select multiple 2 more cents (1997) converting tabs (1997) (2000) looking for developers with solutions (2000) [ShowIf] if the varieable exists (1998) Why did this copyfile stop working? (2004) [protect admin] (1997) Help name our technology! (1997) WebCatalog in the subject line for this list? (2000) Paths (1998) A little syntax help (1997) No comment (1997) Introduction/Tutorial/QuickStart (1997) Pre-flight public flag (1997) AppleScript question (1997)