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:

[WebDNA] maybe silly suggestion? [founditems] (2015) Emailer program? (2000) Monitoring Script (2008) raw=T is broken in [include] (1997) Making WebCatalog run as www (2006) can WC render sites out? (1997) Webcat run amuk (2002) Running _every_ page through WebCat ? (1997) RE: Formulas.db + Users.db (1997) WebMerchant - fixed, now trigger question... (1999) CMS (2003) [ListFiles] Within [LineItems] (2001) Navigator Parsing (1997) Format of Required fields error message (1997) [WebDNA] "Safe Write for Database" setting.... (2016) WebCat2b13MacPlugIn - [include] (1997) Help with Shipping Costs (1997) Sendmail - Attachment / My First Post (2001) emailer w/F2 (1997) Word search (1997)