Re: Correlating the record found with the fieldname
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29914
interpreted = N
texte = on 4/3/2000 12:40 PM, Dennis J. Bonsall, Jr. at dbonsall@webbuilders.com wrote:> Is there any way that, when a record is found, I can figure out what > field in the database that record was found in? I have a database that > contains about 300 date fields in it, and I am doing a group search on > all the date fields at once. My customer wants to know what field the > matching date was found in, so she can determine what jobs need done, or > stages need complete. The search is suprisingly fast, but there are not > very many records yet. But, I don't know of any way to determine what > field the match was found in. Anyone got any pointers? > > Also, can I expect any performance troubles once this database gets > populated, especially on this particular search? The entire database > currently has 338 fields, and most of them are date fields, and I need > to search them all at once. Will this cause any problems? > > Thanks, > > Dennis > You might try using the [listfields] context to determine which field is getting the match.====== Untested ======= [search ...] [founditems] [text]record[index]=[listfields ...] [showif [interpret][[fieldname]][/interpret]=[url][searchstring][/url]] [fieldname], [/showif] [/listfields][/text] [/founditems] [/search] ========================(without the line breaks, of course)I think this would give you a list of text variables that were a comma delimited list of all the fieldnames that matched the search string.I would be curious to know how much of a performance hit this method would create, especially on a large database. When you get your db populated, let us know how it performs.Mike ------------------------------------------------------------- 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:
on 4/3/2000 12:40 PM, Dennis J. Bonsall, Jr. at dbonsall@webbuilders.com wrote:> Is there any way that, when a record is found, I can figure out what > field in the database that record was found in? I have a database that > contains about 300 date fields in it, and I am doing a group search on > all the date fields at once. My customer wants to know what field the > matching date was found in, so she can determine what jobs need done, or > stages need complete. The search is suprisingly fast, but there are not > very many records yet. But, I don't know of any way to determine what > field the match was found in. Anyone got any pointers? > > Also, can I expect any performance troubles once this database gets > populated, especially on this particular search? The entire database > currently has 338 fields, and most of them are date fields, and I need > to search them all at once. Will this cause any problems? > > Thanks, > > Dennis > You might try using the [listfields] context to determine which field is getting the match.====== Untested ======= [search ...] [founditems] [text]record[index]=[listfields ...] [showif [interpret][[fieldname]][/interpret]=[url][searchstring][/url]] [fieldname], [/showif] [/listfields][/text] [/founditems] [/search] ========================(without the line breaks, of course)I think this would give you a list of text variables that were a comma delimited list of all the fieldnames that matched the search string.I would be curious to know how much of a performance hit this method would create, especially on a large database. When you get your db populated, let us know how it performs.Mike ------------------------------------------------------------- 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:
Emailer error 550? (1999)
Emailer setup (1997)
TCPSend/Replace DB Records (2002)
Loop context to replace items (1998)
Looking for a Manual (1997)
[WebDNA] Should I be able to use [setmimeheader name=Content-Type ? (2018)
HELP!!! (1998)
protect tag on NT IIS (1997)
WebCat & WebTen (1997)
WebMerchant 1.6 and SHTML (1997)
Searching Multiple DBs (1997)
RE: WebCat and image maps (1997)
[purchase] (1999)
session handling (2004)
Search Debugging (2004)
Problems getting parameters passed into email. (1997)
Review comparison by PC Magazine: Open for On-line Business (1997)
log out (2001)
Webstar 1.3.1 PPC (1997)
Why no EMailFolder? (2001)