Multiple database search q -- Web Catalog 2.1
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35879
interpreted = N
texte = Hello,I am using WebCatalog to create a classified ad database. The main databasecontains the following information* name/address/city/state/zip of entity putting up ad, seller sku, sellerstatus(whether the seller is allowed to post ads)the secondary database contains* contents of ad, ad header, ad category, ad sku, seller skuThe database needs to be searchable by:*City*Ad Category*BothSearching by City is fine; I can reference City and seller status and thenpull the appropriate ads by seller ski.Searching Ad Category is fine; I can just use the second database to grabjust the ads in the appropriate category.Searching by both is proving to be extremely tricky, however, because itseems impossible to set both variables in a second search because of thelack of the [text] context in WebCat 2.1.One workaround was to do a search for category in the ad database, and thendo a showif which displays only if the city matches the input city; butthis threw off my founditems.Any ideas are welcome!Christopher Feyrer-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hello,I am using WebCatalog to create a classified ad database. The main databasecontains the following information* name/address/city/state/zip of entity putting up ad, seller sku, sellerstatus(whether the seller is allowed to post ads)the secondary database contains* contents of ad, ad header, ad category, ad sku, seller skuThe database needs to be searchable by:*City*Ad Category*BothSearching by City is fine; I can reference City and seller status and thenpull the appropriate ads by seller ski.Searching Ad Category is fine; I can just use the second database to grabjust the ads in the appropriate category.Searching by both is proving to be extremely tricky, however, because itseems impossible to set both variables in a second search because of thelack of the [text] context in WebCat 2.1.One workaround was to do a search for category in the ad database, and thendo a showif which displays only if the city matches the input city; butthis threw off my founditems.Any ideas are welcome!Christopher Feyrer-------------------------------------------------------------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 Web Archive of this list is at: http://search.smithmicro.com/
Christopher Feyrer
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:
NT IIS number of files limit (2003)
shipcost (1997)
F2 to F3 rocky transition (1997)
Bug or syntax error on my part? (1997)
Appending space (1998)
Templates for Customer Database? (1997)
FWD: Autoproxy Bug with WebCatalog and FireSite (1997)
Closing Databases (1998)
WebDelivery downloads alias, not original ? (1997)
[WebDNA] Amazon EC2 (2009)
Latest WebCat release version (1998)
Cyberstudio and WebDNA (1997)
RE: creating writefile data from a nested search (1997)
Merging databases (1997)
Image as submit button (2000)
BUG in [showif] using ^ (contains) (1997)
[random] only for 1-100??? (1997)
[append] vs. [appendfile] delta + question? (1997)
Webcatalog 4.0 - When will we be able to beta test it? (2000)
All of a Sudden Type 2 errors (1999)