Need help!! on searching in two databases.
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19593
interpreted = N
texte = I am trying to do a search which involves 2 databses (tables).I am first doing a search in one database for a specific id number. Thedatabase have two fields: _group_id and _instace_id.My search for a certain _group_id returns a list if _instance_idīs.I then use this list as search argument for a second search, where I wantfind all the _instance_idīs from the first search in a second table. I knowI could do this with a lookup in a second table, but I want to sort theresult alfabetically.The argument goes something like this:[search db=table_two.db&wo_instance_iddatarq=[searchdb=table_one.db&eq_group_iddatarq=100009][founditems][_instance_id][/founditems][/search]&_namesort=1][founditems]Tags[/founditems][/search]Now to the problem:The search:[search db=table_one.db&eq_group_iddatarq=100009]returns less rows than the whole search. And it is not consistently doingso, only on certain groups. Sometimes it works as expected.I did a check on it, by looking up the _group_id of every person, and thesearch returned people not member of the group originally searched for.I might add that for the moment a person is member of one and only one group. Help !?Per Christian Lied
Associated Messages, from the most recent to the oldest:
I am trying to do a search which involves 2 databses (tables).I am first doing a search in one database for a specific id number. Thedatabase have two fields: _group_id and _instace_id.My search for a certain _group_id returns a list if _instance_idīs.I then use this list as search argument for a second search, where I wantfind all the _instance_idīs from the first search in a second table. I knowI could do this with a lookup in a second table, but I want to sort theresult alfabetically.The argument goes something like this:[search db=table_two.db&wo_instance_iddatarq=[searchdb=table_one.db&eq_group_iddatarq=100009]
[founditems][_instance_id][/founditems][/search]&_namesort=1]
[founditems]Tags[/founditems][/search]Now to the problem:The search:[search db=table_one.db&eq_group_iddatarq=100009]returns less rows than the whole search. And it is not consistently doingso, only on certain groups. Sometimes it works as expected.I did a check on it, by looking up the _group_id of every person, and thesearch returned people not member of the group originally searched for.I might add that for the moment a person is member of one and only one group. Help !?Per Christian Lied
Per Christian Lied
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:
Re:E-Mailer (WebCatb15acgiMac) (1997)
Rollovers (1999)
Applescript error (1998)
Cannot calculate prices (1997)
New commands in Final candidate (1997)
[FileInfo] (1998)
Emailer Error 550 (Was Strange Crash) (1998)
New public beta available (1997)
Help name our technology! I found it (1997)
Email Mac (2002)
Does [Sendmail] create html? (2002)
showif... (2000)
page redirect in webDNA (1997)
restart needed???? (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
F3 crashing server (1997)
Firesite and [referrer] atg broke (1997)
Warning: Mac OS X 10.2.4 Update Overwrites Apache's (2003)
List of WebDNA users - Show of Hands (2002)
TeaRoom Search page (2000)