Database change

I want to add a field to my front page database. Adding
the new column to database is no problem. When I go to
results form to add new field via "Insert Database Column
Value", the new field I added in database does not appear
in drop down list? As we all know, we can't use wizaed to
do these updates. How do I modify my database after
wizard generates results and editor?

Kathleen
Sat May 01 17:34:12 CDT 2004

Did you update the database on your hard drive and reimport it into your web
or did you update the database in your web?


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


Robert <anonymous@discussions.microsoft.com> wrote:
> I want to add a field to my front page database. Adding
> the new column to database is no problem. When I go to
> results form to add new field via "Insert Database Column
> Value", the new field I added in database does not appear
> in drop down list? As we all know, we can't use wizaed to
> do these updates. How do I modify my database after
> wizard generates results and editor?

anonymous
Sat May 01 18:28:02 CDT 2004

I updated database on hard drive in FrontPage (in folder
fpdb)so no need to reimport.

>-----Original Message-----
>Did you update the database on your hard drive and
reimport it into your web
>or did you update the database in your web?
>
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/
>
>
>Robert <anonymous@discussions.microsoft.com> wrote:
>> I want to add a field to my front page database. Adding
>> the new column to database is no problem. When I go to
>> results form to add new field via "Insert Database
Column
>> Value", the new field I added in database does not
appear
>> in drop down list? As we all know, we can't use wizaed
to
>> do these updates. How do I modify my database after
>> wizard generates results and editor?
>
>.
>

Kathleen
Sat May 01 18:43:02 CDT 2004

I would recommend exporting the database from your web down to your hard
drive, delete the database and the global.asa from your web and then
reimport the database (give it the same DSN as you did the first time) and
let FP recreate the global.asa. That should fix it.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


anonymous@discussions.microsoft.com wrote:
> I updated database on hard drive in FrontPage (in folder
> fpdb)so no need to reimport.
>
>> -----Original Message-----
>> Did you update the database on your hard drive and reimport it into
>> your web or did you update the database in your web?
>>
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> Robert <anonymous@discussions.microsoft.com> wrote:
>>> I want to add a field to my front page database. Adding
>>> the new column to database is no problem. When I go to
>>> results form to add new field via "Insert Database Column
>>> Value", the new field I added in database does not appear
>>> in drop down list? As we all know, we can't use wizaed to
>>> do these updates. How do I modify my database after
>>> wizard generates results and editor?
>>
>> .

anonymous
Sat May 01 23:41:05 CDT 2004

I did all that, but same results. New field not available.
>-----Original Message-----
>I would recommend exporting the database from your web
down to your hard
>drive, delete the database and the global.asa from your
web and then
>reimport the database (give it the same DSN as you did
the first time) and
>let FP recreate the global.asa. That should fix it.
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/
>
>
>anonymous@discussions.microsoft.com wrote:
>> I updated database on hard drive in FrontPage (in folder
>> fpdb)so no need to reimport.
>>
>>> -----Original Message-----
>>> Did you update the database on your hard drive and
reimport it into
>>> your web or did you update the database in your web?
>>>
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> Robert <anonymous@discussions.microsoft.com> wrote:
>>>> I want to add a field to my front page database.
Adding
>>>> the new column to database is no problem. When I go
to
>>>> results form to add new field via "Insert Database
Column
>>>> Value", the new field I added in database does not
appear
>>>> in drop down list? As we all know, we can't use
wizaed to
>>>> do these updates. How do I modify my database after
>>>> wizard generates results and editor?
>>>
>>> .
>
>.
>

Kathleen
Sun May 02 07:55:29 CDT 2004

OK - here's two other things to try: verify your database connection: go to
Tools | Web Settings | Database click once on the connection and click the
Verify button, and click OK.

Try creating a new query page - is the new field available?


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


anonymous@discussions.microsoft.com wrote:
> I did all that, but same results. New field not available.
>> -----Original Message-----
>> I would recommend exporting the database from your web down to your
>> hard drive, delete the database and the global.asa from your web and
>> then reimport the database (give it the same DSN as you did the
>> first time) and let FP recreate the global.asa. That should fix it.
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> anonymous@discussions.microsoft.com wrote:
>>> I updated database on hard drive in FrontPage (in folder
>>> fpdb)so no need to reimport.
>>>
>>>> -----Original Message-----
>>>> Did you update the database on your hard drive and reimport it into
>>>> your web or did you update the database in your web?
>>>>
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> Robert <anonymous@discussions.microsoft.com> wrote:
>>>>> I want to add a field to my front page database. Adding
>>>>> the new column to database is no problem. When I go to
>>>>> results form to add new field via "Insert Database Column
>>>>> Value", the new field I added in database does not appear
>>>>> in drop down list? As we all know, we can't use wizaed to
>>>>> do these updates. How do I modify my database after
>>>>> wizard generates results and editor?
>>>>
>>>> .
>>
>> .

+FarmerPickles
Sun May 02 10:59:01 CDT 2004

It may be on the hard drive.. but has it been uploaded to the server??


"Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org> wrote in message
news:%23aTEITEMEHA.556@TK2MSFTNGP10.phx.gbl...
> OK - here's two other things to try: verify your database connection: go
to
> Tools | Web Settings | Database click once on the connection and click the
> Verify button, and click OK.
>
> Try creating a new query page - is the new field available?
>
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> anonymous@discussions.microsoft.com wrote:
> > I did all that, but same results. New field not available.
> >> -----Original Message-----
> >> I would recommend exporting the database from your web down to your
> >> hard drive, delete the database and the global.asa from your web and
> >> then reimport the database (give it the same DSN as you did the
> >> first time) and let FP recreate the global.asa. That should fix it.
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> anonymous@discussions.microsoft.com wrote:
> >>> I updated database on hard drive in FrontPage (in folder
> >>> fpdb)so no need to reimport.
> >>>
> >>>> -----Original Message-----
> >>>> Did you update the database on your hard drive and reimport it into
> >>>> your web or did you update the database in your web?
> >>>>
> >>>>
> >>>> --
> >>>> ~ Kathleen Anderson
> >>>> Microsoft MVP - FrontPage
> >>>> Spider Web Woman Designs
> >>>> http://www.spiderwebwoman.com/resources/
> >>>>
> >>>>
> >>>> Robert <anonymous@discussions.microsoft.com> wrote:
> >>>>> I want to add a field to my front page database. Adding
> >>>>> the new column to database is no problem. When I go to
> >>>>> results form to add new field via "Insert Database Column
> >>>>> Value", the new field I added in database does not appear
> >>>>> in drop down list? As we all know, we can't use wizaed to
> >>>>> do these updates. How do I modify my database after
> >>>>> wizard generates results and editor?
> >>>>
> >>>> .
> >>
> >> .
>

anonymous
Sun May 02 16:03:40 CDT 2004

OK, we're there! Prior to verifying database, it was
necessary to click "Modify", then "Apply". After a few
seconds, Connection appears with ? -then a verify finishes
the task. Rather than generate new Query page, modified
SQL in custom query through wizard dialog.
Thanks for all the guidance.
Rob
>-----Original Message-----
>OK - here's two other things to try: verify your database
connection: go to
>Tools | Web Settings | Database click once on the
connection and click the
>Verify button, and click OK.
>
>Try creating a new query page - is the new field
available?
>
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/
>
>
>anonymous@discussions.microsoft.com wrote:
>> I did all that, but same results. New field not
available.
>>> -----Original Message-----
>>> I would recommend exporting the database from your web
down to your
>>> hard drive, delete the database and the global.asa
from your web and
>>> then reimport the database (give it the same DSN as
you did the
>>> first time) and let FP recreate the global.asa. That
should fix it.
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> anonymous@discussions.microsoft.com wrote:
>>>> I updated database on hard drive in FrontPage (in
folder
>>>> fpdb)so no need to reimport.
>>>>
>>>>> -----Original Message-----
>>>>> Did you update the database on your hard drive and
reimport it into
>>>>> your web or did you update the database in your web?
>>>>>
>>>>>
>>>>> --
>>>>> ~ Kathleen Anderson
>>>>> Microsoft MVP - FrontPage
>>>>> Spider Web Woman Designs
>>>>> http://www.spiderwebwoman.com/resources/
>>>>>
>>>>>
>>>>> Robert <anonymous@discussions.microsoft.com> wrote:
>>>>>> I want to add a field to my front page database.
Adding
>>>>>> the new column to database is no problem. When I
go to
>>>>>> results form to add new field via "Insert Database
Column
>>>>>> Value", the new field I added in database does not
appear
>>>>>> in drop down list? As we all know, we can't use
wizaed to
>>>>>> do these updates. How do I modify my database after
>>>>>> wizard generates results and editor?
>>>>>
>>>>> .
>>>
>>> .
>
>.
>

anonymous
Sun May 02 16:05:20 CDT 2004

Yes, all the recent work is being done directly on server.

Problem fixed. See my latest response to Kathleen.

Thanks for helping out.

Rob
>-----Original Message-----
>It may be on the hard drive.. but has it been uploaded to
the server??
>
>
>"Kathleen Anderson [MVP - FP]" <spiderwebwoman@mvps.org>
wrote in message
>news:%23aTEITEMEHA.556@TK2MSFTNGP10.phx.gbl...
>> OK - here's two other things to try: verify your
database connection: go
>to
>> Tools | Web Settings | Database click once on the
connection and click the
>> Verify button, and click OK.
>>
>> Try creating a new query page - is the new field
available?
>>
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> anonymous@discussions.microsoft.com wrote:
>> > I did all that, but same results. New field not
available.
>> >> -----Original Message-----
>> >> I would recommend exporting the database from your
web down to your
>> >> hard drive, delete the database and the global.asa
from your web and
>> >> then reimport the database (give it the same DSN as
you did the
>> >> first time) and let FP recreate the global.asa. That
should fix it.
>> >>
>> >> --
>> >> ~ Kathleen Anderson
>> >> Microsoft MVP - FrontPage
>> >> Spider Web Woman Designs
>> >> http://www.spiderwebwoman.com/resources/
>> >>
>> >>
>> >> anonymous@discussions.microsoft.com wrote:
>> >>> I updated database on hard drive in FrontPage (in
folder
>> >>> fpdb)so no need to reimport.
>> >>>
>> >>>> -----Original Message-----
>> >>>> Did you update the database on your hard drive and
reimport it into
>> >>>> your web or did you update the database in your
web?
>> >>>>
>> >>>>
>> >>>> --
>> >>>> ~ Kathleen Anderson
>> >>>> Microsoft MVP - FrontPage
>> >>>> Spider Web Woman Designs
>> >>>> http://www.spiderwebwoman.com/resources/
>> >>>>
>> >>>>
>> >>>> Robert <anonymous@discussions.microsoft.com> wrote:
>> >>>>> I want to add a field to my front page database.
Adding
>> >>>>> the new column to database is no problem. When I
go to
>> >>>>> results form to add new field via "Insert
Database Column
>> >>>>> Value", the new field I added in database does
not appear
>> >>>>> in drop down list? As we all know, we can't use
wizaed to
>> >>>>> do these updates. How do I modify my database
after
>> >>>>> wizard generates results and editor?
>> >>>>
>> >>>> .
>> >>
>> >> .
>>
>
>
>.
>

Kathleen
Sun May 02 16:24:28 CDT 2004

Cool - thanks for letting us know.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


anonymous@discussions.microsoft.com wrote:
> OK, we're there! Prior to verifying database, it was
> necessary to click "Modify", then "Apply". After a few
> seconds, Connection appears with ? -then a verify finishes
> the task. Rather than generate new Query page, modified
> SQL in custom query through wizard dialog.
> Thanks for all the guidance.
> Rob
>> -----Original Message-----
>> OK - here's two other things to try: verify your database
>> connection: go to Tools | Web Settings | Database click once on the
>> connection and click the Verify button, and click OK.
>>
>> Try creating a new query page - is the new field available?
>>
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> anonymous@discussions.microsoft.com wrote:
>>> I did all that, but same results. New field not
> available.
>>>> -----Original Message-----
>>>> I would recommend exporting the database from your web down to your
>>>> hard drive, delete the database and the global.asa from your web
>>>> and then reimport the database (give it the same DSN as you did the
>>>> first time) and let FP recreate the global.asa. That should fix it.
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> anonymous@discussions.microsoft.com wrote:
>>>>> I updated database on hard drive in FrontPage (in folder
>>>>> fpdb)so no need to reimport.
>>>>>
>>>>>> -----Original Message-----
>>>>>> Did you update the database on your hard drive and reimport it
>>>>>> into your web or did you update the database in your web?
>>>>>>
>>>>>>
>>>>>> --
>>>>>> ~ Kathleen Anderson
>>>>>> Microsoft MVP - FrontPage
>>>>>> Spider Web Woman Designs
>>>>>> http://www.spiderwebwoman.com/resources/
>>>>>>
>>>>>>
>>>>>> Robert <anonymous@discussions.microsoft.com> wrote:
>>>>>>> I want to add a field to my front page database. Adding
>>>>>>> the new column to database is no problem. When I go to
>>>>>>> results form to add new field via "Insert Database Column
>>>>>>> Value", the new field I added in database does not appear
>>>>>>> in drop down list? As we all know, we can't use wizaed to
>>>>>>> do these updates. How do I modify my database after
>>>>>>> wizard generates results and editor?
>>>>>>
>>>>>> .
>>>>
>>>> .
>>
>> .