×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Frontpage and SQL

Frontpage and SQL

Frontpage and SQL

(OP)
I have a database that I am displaying through Frontpage. The database contains several tables that have the exact same format but contain different information. I want to be able to have a dropdown list that I can select a table from and then have that table displayed(on that page or on a new page) when I click on the Select button. I know I can do it by having a seperate .asp page for each table but I would like to be able to modify the SQL query for each table. Any help would be appreciated.

RE: Frontpage and SQL

Alastor,
Have you tried using frames?
You could have a top or left frame w/ the drop-down box and then load the other asp page in the other frame. It would then give you the allusion of loading on the same page
Just a thought??

RE: Frontpage and SQL

(OP)
That's not exactly my problem. I want to pass a variable containing the table name from the combo box to the SQL query. That way I can have one .asp page that will query whatever table is selected instead of having eight different queries and eight different .asp pages. Any ideas?

RE: Frontpage and SQL

None here, sorry.

RE: Frontpage and SQL

hey shortcutkid... your suggestion for alastor sounds like a visual shortcut, but what about download time? alastor, i am researching your problem right now

RE: Frontpage and SQL

(OP)
Thanks Rebecca. Any ideas you can come up with will be greatly appreciated.

RE: Frontpage and SQL

Go into the HTML itself, find the SQL setup area. Simply change the FROM area to a variable (which is the value of the dropdown box). ie
Was 'Select * from Table-name'
Now 'select * from ' & dropdown.value

This was each time the form is submitted, the sql will be reset and since the grid is displayed based on the underlying recordset, nothing else needs to be changed..

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close