Web page editing system with database drill-down

• US 7,647,310 B2
• Filed: 04/03/2007
• Issued: 01/12/2010
• Est. Priority Date: 04/07/2006
• Status: Expired due to Fees

• Current Assignee: Infopower Corporation
• Original Assignee: Infopower Corporation
• Inventors: Hsu, Wen-Hao, Lai, Chang-Chun, Peng, Fu-Bin, Han, Shuang-Fu, Hsu, Yi-Chen
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US11/695,615
• Publication Number:
  US 20070245224A1
• Time in Patent Office: 1,015 Days
• Field of Search: 715/205
• US Class Current: 707/726
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/986 Document structures and storage, e.g. HTML extensions

Abstract

A method of establishing a link in a first web page includes establishing a first component in the first web page capable of querying a first data source, establishing a variable named according to a predetermined naming convention, generating an argument to the variable having a field queried in the first data source, establishing a second component in a second web page capable of receiving the variable from the first component, appending the argument to a query statement, and querying a second data source linked to the first data source, and embedding a link to the second web page in the code of the first web page having the variable and the argument.

Claims

1. A method of establishing a link in a first web page comprising:

a first server establishing a first component in the first web page capable of querying a first data source;

the first server establishing a variable named according to user input and a predetermined naming convention, wherein the name of the variable comprises a query function keyword;

the first server generating an argument to the variable comprising a field queried in the first data source selected in an editing system by a user;

a second server establishing a second component in a second web page capable of receiving the variable from the first component, appending the query function keyword and the argument to a predetermined query statement, and utilizing a result of appending the query function keyword and the argument to the predetermined query statement to query a second data source linked to the first data source; and

the editing system embedding a link to the second web page in the code of the first web page comprising the variable and the argument.

2. The method of claim 1, wherein embedding the link to the second web page in the code of the first web page comprises embedding a hyperlink to the second web page in the code of the first web page.

3. The method of claim 1, wherein establishing the variable named according to the predetermined naming convention comprises establishing a variable comprising a reference to the second component and a query function keyword.

4. The method of claim 3, wherein establishing the variable comprising the reference to the second component and the query function keyword comprises establishing a variable comprising a keyword based on a structured query language (SQL) function keyword.

5. The method of claim 4, wherein establishing the variable comprising the keyword based on the SQL function keyword comprises establishing a variable comprising a keyword based on WHERE, GROUP, HAVING, or ORDER BY SQL function keywords.

6. The method of claim 1, wherein the variable comprising the field queried in the first data source further comprises a condition for filtering a result of querying the second data source.

7. The method of claim 6, wherein the condition for filtering the result of querying the second data source comprises equal to, greater than, less than, or a combination thereof.

8. The method of claim 1, wherein the variable comprising the field queried in the first data source further comprises a condition for sorting a result of querying the second data source.

9. The method of claim 1, wherein the variable comprising the field queried in the first data source further comprises a condition for summing a result of querying the second data source.

10. The method of claim 1, wherein the first web page and the second web page are the same, and the first component and the second component are different components on the same web page.