Re: Searching for a search solution
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31492
interpreted = N
texte = You need to use nested queries to get what you want. Try this:[search db=Guestbook.db&neUniqueIDdatarq=[BLANK]][founditems] [search db=Guestbook.db&eqParentdatarq=[UniqueID]] [founditems] Got One: [UniqueID] = [parent] [/founditems] [/search][/founditems][/search]HTHJohn PeacockAndy Mowrey wrote:> > TgIF,> > I'm trying to to do a search that's looking for identical strings in different fields of the same database, [UniqueID] and [parent]. This is what I have, and it's not turning up anything:> > [search db=Guestbook.db&eqUniqueIDdatarq=[parent]]> > I've tried this:> [search db=Guestbook.db&eqUniqueIDdatarq=[LOOKUP db=Guestbook.db&value=[parent]&lookInField=parent&returnField=fieldName¬Found=xx]]> > This doesn't work either. I know for a fact their is one record (with more on the way) that has UniqueID and parent equaling the same thing but need a way to pull it up. Any ideas?> > WebCat 2.1.3 on Web*> > Tia,> > Andy Mowrey> Web & Systems Manager> In Pittsburgh Weekly> http://www.inpgh.com> (412) 488-1212 x285> mowrey@inpgh.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 -------------------------------------------------------------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:
You need to use nested queries to get what you want. Try this:[search db=Guestbook.db&neUniqueIDdatarq=[BLANK]][founditems] [search db=Guestbook.db&eqParentdatarq=[UniqueID]] [founditems] Got One: [UniqueID] = [parent] [/founditems] [/search][/founditems][/search]HTHJohn PeacockAndy Mowrey wrote:> > TgIF,> > I'm trying to to do a search that's looking for identical strings in different fields of the same database, [UniqueID] and [parent]. This is what I have, and it's not turning up anything:> > [search db=Guestbook.db&eqUniqueIDdatarq=[parent]]> > I've tried this:> [search db=Guestbook.db&eqUniqueIDdatarq=[LOOKUP db=Guestbook.db&value=[parent]&lookInField=parent&returnField=fieldName¬Found=xx]]> > This doesn't work either. I know for a fact their is one record (with more on the way) that has UniqueID and parent equaling the same thing but need a way to pull it up. Any ideas?> > WebCat 2.1.3 on Web*> > Tia,> > Andy Mowrey> Web & Systems Manager> In Pittsburgh Weekly> http://www.inpgh.com> (412) 488-1212 x285> mowrey@inpgh.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 -------------------------------------------------------------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
John Peacock
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:
The Form authentication trick (2000)
redirect with frames (1997)
WebCat2b12 - nesting [tags] (1997)
[WebDNA] search command problem (2009)
apache on OSX (2000)
Problem with pull down menu (1998)
Banners (1997)
Problems with shopping cart (1997)
UnitShipCost Slight Return (2003)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Ports? (2002)
Pull Down Search (2000)
Not really WebCat (1997)
OT: Urgent help with Windows and Javascript (2003)
Line Endings (2007)
return missing item (was:WebCat Sales) (1997)
Encryption of E-mail (1998)
How far do [showif]s go? (1997)
How Many SKU's is enough? (1997)
Bug or syntax error on my part? (1997)