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 fieldnamein '[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:
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 fieldnamein '[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:
Use WebCat to search files in a folder like a search engine? (2001)
Protect Tag and Groups (1998)
Help Encrypt/Decrypt eMail (2003)
What am I doing wrong? (2000)
Cool new site (1996)
How to archive....? (1998)
Re:mac hack (1997)
[ot] Dreamweaver & Mac OSX (2002)
WebCat Beta NT 18 (1997)
mysql errors (2005)
WebCatalog 2.0.1 NT beta 1 released (1997)
[OT] XML Primer (2004)
Verifying both name and password (was: New Problem) (1997)
delayed email response (2005)
Reversed words (1997)
Webmerchant confirmation hooks? (1997)
Parameter Problem ATTN: Ken Grome (1998)
Running 2 two WebCatalog.acgi's (1996)
Plugin or CGI or both (1997)
Accented chars and emailer (1998)