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:

    
  1. Re: Searching Relational Databases ( Justin Carroll 2004)
  2. Re: Searching Relational Databases ( Justin Carroll 2004)
  3. Re: Searching Relational Databases ( Alex McCombie 2004)
  4. Re: Searching Relational Databases ( Alex McCombie 2004)
  5. Re: Searching Relational Databases ( Alex McCombie 2004)
  6. Re: Searching Relational Databases ( Alex McCombie 2004)
  7. Re: Searching Relational Databases ( Marc Kaiwi 2004)
  8. Re: Searching Relational Databases ( Justin Carroll 2004)
  9. Re: Searching Relational Databases ( Alex McCombie 2004)
  10. Re: Searching Relational Databases ( Marc Kaiwi 2004)
  11. Re: Searching Relational Databases ( Marc Kaiwi 2004)
  12. Searching Relational Databases ( Justin Carroll 2004)
.... 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:

Preventing Merchant Settling ? (1997) Calendar (1997) SmithMicro FTP problems (2002) [WebDNA] sem_open bugfix for os x version 6.2 (2012) Using EIMS instead of Emailer (1998) Sample Tearoom Search Error (1997) CSS positioning!!! (2001) Major Security Hole IIS NT (1998) [OT] two domains one site... (2005) my SOS last week... (1996) RE: IIS4b2 and WebCatalog b19 (1997) [WebDNA] BBEdit WebDNA codeless language module (2016) [Cart] ... (1997) [listfields] on Mac OS w/WC 3.x (2001) [WebDNA] feature request (2011) # of real domains on 1 web server (1997) [BoldWords] WebCat.acgib15Mac (1997) Time comparison question (1998) Date Formats (1997) [CART] inside a [LOOP] (1997)