[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.frontpage.programming

Re: Database queries

Greg Chagnon

4/15/2004 5:23:00 PM

Hi,

See the in-lines below

"SHIPP" <anonymous@discussions.microsoft.com> wrote in message news:DFC6DD78-4EEE-495C-8CC9-09F36D14C1B6@microsoft.com...
> Using Frontpage 2002.
>
> Last night I created an access database that I uploaded to the web. I then ran the wizard and it was great. It created the form
and everything. However, the table was a bit ugly. I started playing around with it and got it to look the way I wanted. The next
step is where I ran into problems. I thought it would be nice to offer some selections. So I created them via the wizard. When they
were complete the wizard reverted my table back to its' ugly self causing me to have to recreate my look and feel all over again.
Does this always happen when one changes the SQL?

It has nothing to do with changing the SQL and everything to do with using the wizard again -- it rewrites the code each time.

> Item 2. After creating the table again along with some drop down menus I was forced to choose an item to query the database. What
if a person wanted to see all the records. Is there a button or something I could put on the form that would bypass the SQL and show
all records? Any help is greatly appreciated.

The SQL would not use a "Where" clause to limit the records return, e.g. Select * from mytable

--
Mike -- FrontPage MVP '97 - '02
http://www.websunl...