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:

Date Sorting (1997) pull downs (1997) Unique SKUs (2000) [countWords]? (1997) Email template names (1997) HELP!? (2002) [Search] on Remote Database (2000) [BULK] [WebDNA] WebDNA Code and HTML WYSIWYG Editors (2011) Emailer setup (1997) Multiple prices (1997) OK, here goes... (1997) textA (1998) Question about replacing words (1998) Forms Search Questions (1997) Summing fields (1997) webmerchant - Crediting Back (2000) unable to launch acgi in WebCat (1997) Auto-email upon restart? (2001) re:Clickable maps and WebCatalog? (1996) Browser security type (2000)