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)MKOn 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)MKOn 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:
Problem 2: Prefs file... (1997)
[lookup] vs. [search] (1998)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
BBEdit and WebCatalog 2.0? (1997)
carriage returns in data (1997)
AppleScript: Tell application:app location? (1998)
2.0 Info (1997)
Date search - yes or no (1997)
HomePage Caution (1997)
WebCat2 Append problem (B14Macacgi) (1997)
LookUp Tag (1997)
AW: AW: Credit card processing - UK (1997)
Partner Edition question ... (2003)
View order not right (1997)
Nested tags count question (1997)
Further tests with the infamous shipCost (1997)
[countWords]? (1997)
Next X hits (1996)
cart info (1998)
first time using webcats sendmail option (2001)