sql context issues

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38055
interpreted = N
texte = 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: sql context issues (Peter Werno 2001)
  2. sql context issues (Bob McPeak 2001)
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/ Bob McPeak

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:

WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) feature request.... [stop] (2000) Need NT Assist. w/ Emailer (2000) WebCatalog for guestbook ? (1997) Bug or syntax error on my part? (1997) RE: Formulas.db + Users.db (1997) Possible Bug in 2.0b15.acgi (1997) PIXO with cometsite ... and/or other plugins (1998) Emailer Set Up (1997) dbf2txt (2003) more [sendmail] woes.. (2000) Format all of a sudden doesn't work (1997) Authenticate (1997) [isfile] ? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Protect and Serve (1999) Sitebuilder (2004) WebCat2b15MacPlugin - [protect] (1997) Online reference (1997) WebCat2b13MacPlugIn - [include] (1997)