Re: SQL in SEARCH breaks FOUNDITEMS

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24616
interpreted = N
texte = would something like this work?[search db=some.db&eqFieldNamedata=[inField]] [text]TVVars=[founditems],[FieldName][/founditems][/text] [/search] [SQL dsn=aDSN&username=u&password=faf&statement=SELECT tablename from table where fieldname in '[TVVars]'] found [numfound] in SQL. [founditems] [name] - [value]
[/founditems] [/SQL] Mike_Davis wrote:> This is happening on NT 3.0.4. I haven't tried on other platforms. > This is the code: > > [search db=some.db&eqFieldNamedata=[inField]] > [founditems] > [SQL dsn=aDSN&username=u&password=faf&statement=SELECT blah blah] > found [numfound] in SQL. > [founditems] > [name] - [value]
> [/founditems] > [/SQL] > [/founditems] > [/search] > > Problem: The inner SQL numfound shows the correct number but the founditems > loop inside the SQL does not execute. There is no error reported. Same > results if I bring the SQL out of the surrounding founditems loop, but still > within the outer search context. If I bring the SQL completely outside of > the search context, it works fine. > > Any ideas? My solution is a pain because I have to now set a bunch of text > variables in the search and bury the SQL in a bunch of showifs that do what > the search was doing. > > Mike > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL in SEARCH breaks FOUNDITEMS (djones@augustmartin.net (August Martin - Dave Jones) 1999)
  2. Re: SQL in SEARCH breaks FOUNDITEMS (PCS Technical Support 1999)
  3. SQL in SEARCH breaks FOUNDITEMS (Mike_Davis 1999)
would something like this work?[search db=some.db&eqFieldNamedata=[inField]] [text]TVVars=[founditems],[FieldName][/founditems][/text] [/search] [SQL dsn=aDSN&username=u&password=faf&statement=SELECT tablename from table where fieldname in '[TVVars]'] found [numfound] in SQL. [founditems] [name] - [value]
[/founditems] [/SQL] Mike_Davis wrote:> This is happening on NT 3.0.4. I haven't tried on other platforms. > This is the code: > > [search db=some.db&eqFieldNamedata=[inField]] > [founditems] > [SQL dsn=aDSN&username=u&password=faf&statement=SELECT blah blah] > found [numfound] in SQL. > [founditems] > [name] - [value]
> [/founditems] > [/SQL] > [/founditems] > [/search] > > Problem: The inner SQL numfound shows the correct number but the founditems > loop inside the SQL does not execute. There is no error reported. Same > results if I bring the SQL out of the surrounding founditems loop, but still > within the outer search context. If I bring the SQL completely outside of > the search context, it works fine. > > Any ideas? My solution is a pain because I have to now set a bunch of text > variables in the search and bury the SQL in a bunch of showifs that do what > the search was doing. > > Mike > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 djones@augustmartin.net (August Martin - Dave Jones)

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:

Security Question (1997) Webcat2, WebCommerce, Mod 10 etc. (1997) [input]?? (1998) Huge databases and RAM (1998) credit card authorization question (1997) [WebDNA] HTTP Streaming -- impossible? (2010) founditem align (1998) [Sum] function? (1997) [WebDNA] Mailing list failure !!! (2019) WCS Newbie question (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) WebCatalog2 Feature Feedback (1996) Sorting by date (1997) shipcost (1997) Join us at MacWorld -- in the booth and after the show!!! (1999) RE: Ongoing group search problems ... (1997) .html with IIS4 (1999) WebCommerce: Folder organization ? (1997) Document Contains no data, or showcart error. (1997) Hiding HTML and page breaks (1997)