Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to edit a query without regenerating the table

Databases

How to edit a query without regenerating the table

by  caitlin  Posted    (Edited  )
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!

:)
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top