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:

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

New WebDNA Solutions ... (1997) [isfile] ? (1997) Physical Security for WebCatalog Directories (1997) Information on Vieworders.tpl (1998) [WriteFile] problems (1997) RE: [sendmail]- bcc? (1998) Some ThankYou page problems (1997) [math] variable question (1997) If Empty ? (1997) Many $WebCat.exe processes (1998) CGI and SSI (2002) TIP of the DAY - to work or not work (2004) Claris HomePage messes up the code (1997) GroupField Returns (2002) Re:Navigator 4.01 (1997) Database (2000) Formulas.db + Users.db (1997) authenticate and password (1998) can webcat determine an image's pixel dimensions? (2000) b12 cannot limit records returned and more. (1997)