Re: SQL Madness
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62674
interpreted = N
texte = Appreciated. I did try the url tag around the variables, but never expected for a second that I should url the sql syntax items! I will go forward under the context that I should probably wrap all my variables (actually everything inside the '') in url to combat the unurl'ing and see if I can find inconsistent results. Of course getting there is always the trick because searching and results is black magic when it comes to QA. You know what works, and you know what doesn't based on your searches, but you never know what's left you didn't expose with your search tests ;-) Thanks and I will holler if I find anything. :-) Alex On 7/27/05 3:44 PM, "Scott Anderson"
wrote: > 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] parameter > values when parsing a context, I would have to say that this is the correct > behavior. > > I also think that [url]ing the search value in this case should not cause > any other complications, and may yield more consistent results. > > But I also have to acknowledge that the topic of when to URL or UNURL, can > be a bit confusing at times. If you feel that any of my statements above > are not consistent with behavior you are seeing, I will be happy to > investigate this further. -- 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:
Appreciated. I did try the url tag around the variables, but never expected for a second that I should url the sql syntax items! I will go forward under the context that I should probably wrap all my variables (actually everything inside the '') in url to combat the unurl'ing and see if I can find inconsistent results. Of course getting there is always the trick because searching and results is black magic when it comes to QA. You know what works, and you know what doesn't based on your searches, but you never know what's left you didn't expose with your search tests ;-) Thanks and I will holler if I find anything. :-) Alex On 7/27/05 3:44 PM, "Scott Anderson" wrote: > 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] parameter > values when parsing a context, I would have to say that this is the correct > behavior. > > I also think that [url]ing the search value in this case should not cause > any other complications, and may yield more consistent results. > > But I also have to acknowledge that the topic of when to URL or UNURL, can > be a bit confusing at times. If you feel that any of my statements above > are not consistent with behavior you are seeing, I will be happy to > investigate this further. -- 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:
speed of TCPConnect? (1998)
can WC render sites out? (1997)
Emailer help....! (1997)
Press Release hit the NewsWire!!! (1997)
Https not showing products (2004)
WebCatalog Upgrade Pricing? (1997)
Help! WebCat2 bug (1997)
Multiple catalog databases and showcart (1997)
using showpage and showcart commands (1996)
SetMIMEHeader ATTN:John P. (2001)
select multiple 2 more cents (1997)
WebCat2 - [format thousands] (1997)
Shared conversion under WebTen (1998)
ColdFusion v. WebDNA (2004)
Associative lookup style? (1997)
[TaxableTotal] - not working with AOL and IE (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Tab Charactor (1997)
Part 2 - [showif] if variable exists (1998)
can WC render sites out? (1997)