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:

Temp DB (Was freeze) (2003) ALERT: Please unsubscribe? (2000) Exclamation point (1997) [ELSEIF] was hideif [x]=1,2,3..: (2003) SKU (1997) Configuring E-mail (1997) [interpret] inside the db field? (1997) Re:multiple digests, please stop (1997) [WebDNA] Emailer breaking format (2015) Server crash (1997) Javascript and Pull Down menus (1999) WebCommerce: Folder organization ? (1997) Lost Field (1998) question: writing files textb in webmerch (1997) HTML mapped to WebCat (2001) customizing the color of user's pages (1997) Problem displaying search result (1997) StandardConversions.db (1998) XMLNodes Error (2007) how do we turn off staticpages page creation? (2003)