Re: Searching Relational Databases
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55313
interpreted = N
texte = .... guess a workaround would be is to create a WebDNA [table] from the multi .db search and then search and sort on that table to create the HTML table? Just a guess ... hahaha ... : c) MK On Thursday, January 8, 2004, at 10:23 AM, Justin Carroll wrote: > Say I have a business.db and an employee.db. The business.db is a > list of businesses and the employee.db is a list of people who work at > the businesses in the businesses.db. > > The employee.db has three headers: sku, employee_name, and > business_sku. > The business.db has three headers: sku, business_name, and > business_address. > > When viewing the business.db contents on an html page, I put in an > extra header in my table called Employees but keep in mind that there > is no actual Employees header in the business.db. What goes in this > Employess column is the number of employees that the particular > business has working there. I pull this information by doing a > [search] on the employee.db and pulling the [numfound] of > employee_name I get in return by sending it the business.db current > sku. Here's an example: > > [search db=business.db&geskudatarq=0] > [founditems] > [search > db=employee.db&eqbusiness_skudatarq=[sku]][numfound][/search] > [/founditems] > [/search] > > Here's my problem: > All the headers for the business.db html data table are clickable so > that the user can sort by them. I haven't done this for the Employees > header yet because I can't figure out how to search the employee.db > and then sort the business.db contents based on the returned data. > > Hopefully I communicated my problem well enough. This is a fictional > situation but the core problem is what I'm after -- how to search > another db inside of a search and affect the parent search results. > Any help would be greatly appreciated. Thank you. > > Justin Carroll > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ > > Signed: Marc Kaiwi ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
.... guess a workaround would be is to create a WebDNA [table] from the multi .db search and then search and sort on that table to create the HTML table? Just a guess ... hahaha ... : c) MK On Thursday, January 8, 2004, at 10:23 AM, Justin Carroll wrote: > Say I have a business.db and an employee.db. The business.db is a > list of businesses and the employee.db is a list of people who work at > the businesses in the businesses.db. > > The employee.db has three headers: sku, employee_name, and > business_sku. > The business.db has three headers: sku, business_name, and > business_address. > > When viewing the business.db contents on an html page, I put in an > extra header in my table called Employees but keep in mind that there > is no actual Employees header in the business.db. What goes in this > Employess column is the number of employees that the particular > business has working there. I pull this information by doing a > [search] on the employee.db and pulling the [numfound] of > employee_name I get in return by sending it the business.db current > sku. Here's an example: > > [search db=business.db&geskudatarq=0] > [founditems] > [search > db=employee.db&eqbusiness_skudatarq=[sku]][numfound][/search] > [/founditems] > [/search] > > Here's my problem: > All the headers for the business.db html data table are clickable so > that the user can sort by them. I haven't done this for the Employees > header yet because I can't figure out how to search the employee.db > and then sort the business.db contents based on the returned data. > > Hopefully I communicated my problem well enough. This is a fictional > situation but the core problem is what I'm after -- how to search > another db inside of a search and affect the parent search results. > Any help would be greatly appreciated. Thank you. > > Justin Carroll > > > > ------------------------------------------------------------- > 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://webdna.smithmicro.com/ > > Signed: Marc Kaiwi ------------------------------------------------------------- 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://webdna.smithmicro.com/
Marc Kaiwi
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:
delete credit card number (2002)
Add htmlarea 3 to SiteBuilder (2004)
[accountNum] and [math] (1997)
Problems with [Applescript] (1997)
problems with 2 tags (1997)
SiteEdit Pro Update Announcement (1997)
Checkboxes (1998)
encryption madness (2004)
more on quicktime test stuff (1997)
The Depths of Credit Card Payment (2003)
Getting real time CC's out of Australia (1998)
NT - Thanks and Taxes (1997)
Error & Problem (1997)
MATH PROBLEM (1997)
Configuring E-mail (1997)
Searching multiple fields from one form field (1997)
Re2: frames & carts (1997)
[WebDNA] Enhancements to "list" contexts ... (2015)
Spaces in sendmail (1998)
Webstar 1.3.1 PPC (1997)