Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-04 : 18:05:41
|
Ari writes "Heres the scenario.
Lets say I have an application which takes my excel document or access database and uploads it and magically reads the taxonomy to output to a tree in another application. I can import the taxonomy or all the products.
I want to be specific because before I import the database I have to upload it to the server and hand-write a sql query
something like SELECT * FROM [$DVD PLAYERS] which would do the select the correct products or taxonomy for my application which could then do the grab.
My customers have to type the query in themselves and may not be too savvy on that, and if they want to get more than just "*" then they may need a little help.
What if they clicked a little button next to the sql query text box and up popped a little window which showed:
Here are all the table names (rows) of the database you uploaded:
for examples
Your column NAMES are "NAME" "TYPE" "CHARACTERISTIC"
and then it allowed me to click on them or move them into a box which built the query. it also allowed me to click on an iconic representation of the products oritems within those columns (rows) and then add them as well. I could do exceptions or just about anything SQL can. Then I click OK and it outputs the query into the text box. The user then clicks submit query and the application does the rest.
What do you think?
The technology is using ASp but mainly XML translated by XSLT stylesheets." |
|
|
|
|
|
Incorporating an integrated sql query builder in asp or appropriate language