Re: sql context issues
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38062
interpreted = N
texte = Usually, you would only nest SEARCHes (that includes SQL-calls) when they are somewhat related. Example:[search ...something...] [foundItems] [firstname] [lastname]
[sql ... SELECT ... where fname=[firstName]...] [foundItems] [/foundItems] [/sql] [/foundItems] [/search]if in your case the two Database-queries are NOT related, you should separate them :[search ...] [foundItems] [firstname] [lastname]
[/foundItems] [/search] [sql ... something] [foundItems] Print something
[/foundItems] [/sql]Ciao,PeterOn Tue, 21 Aug 2001 11:08:30 Bob McPeak
wrote: > This is from my sys admin. Anybody seen this? > > ----- Original Message ----- > From: Nick > To: Bob McPeak > Cc: Marla Ferrency ; Celeste Paul > > Sent: Tuesday, August 21, 2001 11:00 AM > Subject: SQL context issues > > > > Bob, maybe you should forward this to the talklist... > > > > ------------------------- Example > 1 ----------------------------------------- > > This is something I figured out that didn't make sense at first. > This > first > > example works like you would expect. both searches happen > correctly, and > the > > [firstname] and [lastname] expand out like they should for the > inner > search. > > > > [search ...something...] > > [search ...somethingelse...] > > There were [numfound] results. Listing them:
> > [founditems] > > [firstname] [lastname]
> > [/founditems] > > [/search] > > [/search] > > > > > > ------------------------- Example > 2 ---------------------------------------- > > But in this almost identical example, the [founditems] that appears > inside > > of the [SQL][/SQL] tags acts as if were outside of the tags. > Example 2 and > > Example 3 function exactly the same. Note the differences. > > > > [search ...something...] > > [SQL ... SELECT firstname,lastname ...] > > There were [numfound] results. Listing them:
> > [founditems] > > [firstname] [lastname]
> > [/founditems] > > [/SQL] > > [/search] > > > > ------------------------- Example > 3 ---------------------------------------- > > This works just like Example 2. > > > > [search ...something...] > > [SQL ... SELECT firstname,lastname ...] > > There were [numfound] results. Listing them:
> > [/SQL] > > > > [founditems] > > [firstname] [lastname]
> > [/founditems] > > [/search] > > > > -------------------------------------------------------------------------- > -- > > > > This looks like it happens because the outer search didn't have a > [founditems] > > at all, and webcatalog didn't let the [SQL] context's [founditems] > take > > precedence over the [search]'s [founditems] > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Usually, you would only nest SEARCHes (that includes SQL-calls) when they are somewhat related. Example:[search ...something...] [founditems] [firstname] [lastname]
[sql ... SELECT ... where fname=[firstName]...] [founditems] [/foundItems] [/sql] [/foundItems] [/search]if in your case the two Database-queries are NOT related, you should separate them :[search ...] [founditems] [firstname] [lastname]
[/foundItems] [/search] [sql ... something] [founditems] Print something
[/foundItems] [/sql]Ciao,PeterOn Tue, 21 Aug 2001 11:08:30 Bob McPeak wrote: > This is from my sys admin. Anybody seen this? > > ----- Original Message ----- > From: Nick > To: Bob McPeak > Cc: Marla Ferrency ; Celeste Paul > > Sent: Tuesday, August 21, 2001 11:00 AM > Subject: SQL context issues > > > > Bob, maybe you should forward this to the talklist... > > > > ------------------------- Example > 1 ----------------------------------------- > > This is something I figured out that didn't make sense at first. > This > first > > example works like you would expect. both searches happen > correctly, and > the > > [firstname] and [lastname] expand out like they should for the > inner > search. > > > > [search ...something...] > > [search ...somethingelse...] > > There were [numfound] results. Listing them:
> > [founditems] > > [firstname] [lastname]
> > [/founditems] > > [/search] > > [/search] > > > > > > ------------------------- Example > 2 ---------------------------------------- > > But in this almost identical example, the [founditems] that appears > inside > > of the [SQL][/SQL] tags acts as if were outside of the tags. > Example 2 and > > Example 3 function exactly the same. Note the differences. > > > > [search ...something...] > > [SQL ... SELECT firstname,lastname ...] > > There were [numfound] results. Listing them:
> > [founditems] > > [firstname] [lastname]
> > [/founditems] > > [/SQL] > > [/search] > > > > ------------------------- Example > 3 ---------------------------------------- > > This works just like Example 2. > > > > [search ...something...] > > [SQL ... SELECT firstname,lastname ...] > > There were [numfound] results. Listing them:
> > [/SQL] > > > > [founditems] > > [firstname] [lastname]
> > [/founditems] > > [/search] > > > > -------------------------------------------------------------------------- > -- > > > > This looks like it happens because the outer search didn't have a > [founditems] > > at all, and webcatalog didn't let the [SQL] context's [founditems] > take > > precedence over the [search]'s [founditems] > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/
Peter Werno
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:
Jail Break...Please! (2000)
[random] only for 1-100??? (1997)
Talk List Suggestions (1997)
Old $ commands and migration (2004)
[Webcat 2]Next (1997)
Sorting by highest number of matches unique to a field (2003)
RE: format problem on NT? (1997)
FM PRO Compatibility Issue - Single Database w/o Conversions (1997)
WebMerchant -- Sweeping WebDelivery < 24 hrs (2000)
Not really WebCat- (1997)
Convert Chars Q (2000)
Database Security Rev., (2002)
Tech question about web dna actions (1998)
Two stores, one server (1998)
syntax question, not in online refernce (1997)
WebCatalog2 Feature Feedback (1996)
Sandbox Administation (2003)
Re:One more time (1997)
Protect vs Authenicate (1997)
WebCatalog2 Feature Feedback (1996)