×
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

Microsoft: FrontPage FAQ

Databases

How to edit a query without regenerating the table by caitlin
Posted: 11 Jul 03

I manage several sites that rely heavily on tables containing database results regions drawn from Access. The tables are all formatted a specific way (colors/size/fonts/etc), and if I need to add a field, change a field name, or otherwise tweak the query, using the Database Results Wizard, FrontPage wants to regenerate the table and erase all my formatting.

If I try to edit the ASP code in HTML view, I get an error message and FP overwrites the changes when I save.

So how do you change the query without regenerating the table? It's surprisingly easy (and not documented).

In HTML view, find the commented out section that appears at the beginning of the database region, before the ASP scripting begins. It's filled with a bunch of FP gobbledy-gook about webbots and such.

In this commented section, you can change the query name, the connection name, any of the field names, even the criteria and SQL statement. Click Save and you'll see the ASP scripting section update automatically.

You've changed the underlying query and FP left your table alone!


Back to Microsoft: FrontPage FAQ Index
Back to Microsoft: FrontPage Forum

My Archive

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