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:
killing white space (1998)
[TaxableTotal] - not working with AOL and IE (1997)
bug ? causes NT event log to fill (1997)
Re[2]: WebCat is different user (1999)
problem with NT beta (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
WebCommerce: Folder organization ? (1997)
shipcost (1997)
WebCat2b13 Command Reference Doc error (1997)
Text data with spaces in them... (1997)
Suffix Mapping (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
WebCatalog for guestbook ? (1997)
URGENT! ACGI Stopped!!!! (1997)
Possible Bug in 2.0b15.acgi (1997)
simple forum/bboard (2004)
WebCat editing, SiteGuard & SiteEdit (1997)
Summing fields (1997)
SiteCheck & WebCat ? (1997)
Problem: 3.0 doesn't update carts (1997)