SQL in SEARCH breaks FOUNDITEMS

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24612
interpreted = N
texte = 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 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)
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 Mike_Davis

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:

Show shoppingcart after remove last item (1997) Stinkin' [Referrer] (1998) WCS Newbie question (1997) WebCatalog + Linux + ODBC + Oracle ! ? (2000) different ship dates and shopping carts -- how to? (1997) Calculating multiple shipping... (1997) maximu values for sendmail! (1997) Nesting format tags (1997) [OT] will work for... (2003) Extra equals signs with IE? (More debugging questions...) (1997) Multi-processor Mac info ... (1997) Country & Ship-to address & other fields ? (1997) [WebDNA] Still having problems (2008) Multiple Ad databases? (1997) FW: WebDNA-Talk searchable? (1997) WebCatalog [FoundItems] Problem - LONG - (1997) Banner DNA (1997) WCS Newbie question (1997) [SearchString] problem with [search] context (1997) [WebDNA] StandardConversions.db (2016)