PC Review


Reply
Thread Tools Rate Thread

Database Editor Returns No Results

 
 
Dave
Guest
Posts: n/a
 
      21st Apr 2004
The Database Interface Wizard creates the Database Editor Page which is
split in an upper and lower half.

The lower half which is edit.asp shows No records found. The upper half
displays delete.asp and it works fine.

I have deleted the folder that was crated and ran the wizard again with the
same results.

The wizard seemed straight forward. Is there anything I am missing? The
database was created via FP2003

I am using FrontPage 2003.

Thanks

Dave


 
Reply With Quote
 
 
 
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      21st Apr 2004
Did you tell the wizard to use an existing database connection or to create
a new database?

--

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


Dave <(E-Mail Removed)> wrote:
> The Database Interface Wizard creates the Database Editor Page which
> is split in an upper and lower half.
>
> The lower half which is edit.asp shows No records found. The upper
> half displays delete.asp and it works fine.
>
> I have deleted the folder that was crated and ran the wizard again
> with the same results.
>
> The wizard seemed straight forward. Is there anything I am missing?
> The database was created via FP2003
>
> I am using FrontPage 2003.
>
> Thanks
>
> Dave


 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      21st Apr 2004
Use existing DB!

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Did you tell the wizard to use an existing database connection or to

create
> a new database?
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Dave <(E-Mail Removed)> wrote:
> > The Database Interface Wizard creates the Database Editor Page which
> > is split in an upper and lower half.
> >
> > The lower half which is edit.asp shows No records found. The upper
> > half displays delete.asp and it works fine.
> >
> > I have deleted the folder that was crated and ran the wizard again
> > with the same results.
> >
> > The wizard seemed straight forward. Is there anything I am missing?
> > The database was created via FP2003
> >
> > I am using FrontPage 2003.
> >
> > Thanks
> >
> > Dave

>



 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      21st Apr 2004
OK, because I just tried this from scratch telling the Wizard to create a
new database, and it worked pretty well. I will try it using an existing
database and let you know what I find out.

--

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


Dave <(E-Mail Removed)> wrote:
> Use existing DB!
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> in message news:(E-Mail Removed)...
>> Did you tell the wizard to use an existing database connection or to
>> create a new database?
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft FrontPage MVP
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> Dave <(E-Mail Removed)> wrote:
>>> The Database Interface Wizard creates the Database Editor Page which
>>> is split in an upper and lower half.
>>>
>>> The lower half which is edit.asp shows No records found. The upper
>>> half displays delete.asp and it works fine.
>>>
>>> I have deleted the folder that was crated and ran the wizard again
>>> with the same results.
>>>
>>> The wizard seemed straight forward. Is there anything I am missing?
>>> The database was created via FP2003
>>>
>>> I am using FrontPage 2003.
>>>
>>> Thanks
>>>
>>> Dave


 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      21st Apr 2004
Dave:
In the top half of the Database Editor window, you should see a list of the
records in your database table. One of the fields in the record should be a
hyperlink. Click on it and the detail of that record will appear in the
lower half of the window. If you want to edit the record, click the Edit
button at the bottom of the page and it will give you all the fields in text
boxes for editing. Make your edits and click OK. The top half of the window
will refresh and you should see your changes.


--

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


Dave <(E-Mail Removed)> wrote:
> Use existing DB!
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> in message news:(E-Mail Removed)...
>> Did you tell the wizard to use an existing database connection or to
>> create a new database?
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft FrontPage MVP
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> Dave <(E-Mail Removed)> wrote:
>>> The Database Interface Wizard creates the Database Editor Page which
>>> is split in an upper and lower half.
>>>
>>> The lower half which is edit.asp shows No records found. The upper
>>> half displays delete.asp and it works fine.
>>>
>>> I have deleted the folder that was crated and ran the wizard again
>>> with the same results.
>>>
>>> The wizard seemed straight forward. Is there anything I am missing?
>>> The database was created via FP2003
>>>
>>> I am using FrontPage 2003.
>>>
>>> Thanks
>>>
>>> Dave


 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      21st Apr 2004
BLESS YOUR HEART!!!

Thanks

Dave

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:%(E-Mail Removed)...
> Dave:
> In the top half of the Database Editor window, you should see a list of

the
> records in your database table. One of the fields in the record should be

a
> hyperlink. Click on it and the detail of that record will appear in the
> lower half of the window. If you want to edit the record, click the Edit
> button at the bottom of the page and it will give you all the fields in

text
> boxes for editing. Make your edits and click OK. The top half of the

window
> will refresh and you should see your changes.
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Dave <(E-Mail Removed)> wrote:
> > Use existing DB!
> >
> > "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> > in message news:(E-Mail Removed)...
> >> Did you tell the wizard to use an existing database connection or to
> >> create a new database?
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft FrontPage MVP
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Dave <(E-Mail Removed)> wrote:
> >>> The Database Interface Wizard creates the Database Editor Page which
> >>> is split in an upper and lower half.
> >>>
> >>> The lower half which is edit.asp shows No records found. The upper
> >>> half displays delete.asp and it works fine.
> >>>
> >>> I have deleted the folder that was crated and ran the wizard again
> >>> with the same results.
> >>>
> >>> The wizard seemed straight forward. Is there anything I am missing?
> >>> The database was created via FP2003
> >>>
> >>> I am using FrontPage 2003.
> >>>
> >>> Thanks
> >>>
> >>> Dave

>



 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      21st Apr 2004
I spoke too soon.

I get results below, but I get Wizards error I make changes and click OK.

Dave

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:%(E-Mail Removed)...
> Dave:
> In the top half of the Database Editor window, you should see a list of

the
> records in your database table. One of the fields in the record should be

a
> hyperlink. Click on it and the detail of that record will appear in the
> lower half of the window. If you want to edit the record, click the Edit
> button at the bottom of the page and it will give you all the fields in

text
> boxes for editing. Make your edits and click OK. The top half of the

window
> will refresh and you should see your changes.
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Dave <(E-Mail Removed)> wrote:
> > Use existing DB!
> >
> > "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> > in message news:(E-Mail Removed)...
> >> Did you tell the wizard to use an existing database connection or to
> >> create a new database?
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft FrontPage MVP
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Dave <(E-Mail Removed)> wrote:
> >>> The Database Interface Wizard creates the Database Editor Page which
> >>> is split in an upper and lower half.
> >>>
> >>> The lower half which is edit.asp shows No records found. The upper
> >>> half displays delete.asp and it works fine.
> >>>
> >>> I have deleted the folder that was crated and ran the wizard again
> >>> with the same results.
> >>>
> >>> The wizard seemed straight forward. Is there anything I am missing?
> >>> The database was created via FP2003
> >>>
> >>> I am using FrontPage 2003.
> >>>
> >>> Thanks
> >>>
> >>> Dave

>



 
Reply With Quote
 
Kathleen Anderson [MVP - FrontPage]
Guest
Posts: n/a
 
      21st Apr 2004
Dave:
What does this mean? "I get Wizards error I make changes and click OK."

--

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


Dave <(E-Mail Removed)> wrote:
> I spoke too soon.
>
> I get results below, but I get Wizards error I make changes and click
> OK.
>
> Dave
>
> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> in message news:%(E-Mail Removed)...
>> Dave:
>> In the top half of the Database Editor window, you should see a list
>> of the records in your database table. One of the fields in the
>> record should be a hyperlink. Click on it and the detail of that
>> record will appear in the lower half of the window. If you want to
>> edit the record, click the Edit button at the bottom of the page and
>> it will give you all the fields in text boxes for editing. Make your
>> edits and click OK. The top half of the window will refresh and you
>> should see your changes.
>>
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft FrontPage MVP
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> Dave <(E-Mail Removed)> wrote:
>>> Use existing DB!
>>>
>>> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)>
>>> wrote in message news:(E-Mail Removed)...
>>>> Did you tell the wizard to use an existing database connection or
>>>> to create a new database?
>>>>
>>>> --
>>>>
>>>> ~ Kathleen Anderson
>>>> Microsoft FrontPage MVP
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> Dave <(E-Mail Removed)> wrote:
>>>>> The Database Interface Wizard creates the Database Editor Page
>>>>> which is split in an upper and lower half.
>>>>>
>>>>> The lower half which is edit.asp shows No records found. The upper
>>>>> half displays delete.asp and it works fine.
>>>>>
>>>>> I have deleted the folder that was crated and ran the wizard again
>>>>> with the same results.
>>>>>
>>>>> The wizard seemed straight forward. Is there anything I am
>>>>> missing? The database was created via FP2003
>>>>>
>>>>> I am using FrontPage 2003.
>>>>>
>>>>> Thanks
>>>>>
>>>>> Dave

 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      21st Apr 2004
I got it fixed MKBA 828898

Thanks for your help!!!

Dave

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:%(E-Mail Removed)...
> Dave:
> In the top half of the Database Editor window, you should see a list of

the
> records in your database table. One of the fields in the record should be

a
> hyperlink. Click on it and the detail of that record will appear in the
> lower half of the window. If you want to edit the record, click the Edit
> button at the bottom of the page and it will give you all the fields in

text
> boxes for editing. Make your edits and click OK. The top half of the

window
> will refresh and you should see your changes.
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Dave <(E-Mail Removed)> wrote:
> > Use existing DB!
> >
> > "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> > in message news:(E-Mail Removed)...
> >> Did you tell the wizard to use an existing database connection or to
> >> create a new database?
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft FrontPage MVP
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Dave <(E-Mail Removed)> wrote:
> >>> The Database Interface Wizard creates the Database Editor Page which
> >>> is split in an upper and lower half.
> >>>
> >>> The lower half which is edit.asp shows No records found. The upper
> >>> half displays delete.asp and it works fine.
> >>>
> >>> I have deleted the folder that was crated and ran the wizard again
> >>> with the same results.
> >>>
> >>> The wizard seemed straight forward. Is there anything I am missing?
> >>> The database was created via FP2003
> >>>
> >>> I am using FrontPage 2003.
> >>>
> >>> Thanks
> >>>
> >>> Dave

>



 
Reply With Quote
 
Dave
Guest
Posts: n/a
 
      21st Apr 2004
If I tried to edit a record by selecting a file above. The record would
open below. I would make a change and click OK, then I got a Results Wizard
error below.

I remember reading the Knowledge Base Article 828898 discussing this, I made
the change to the Timestamp and life is good!

Dave

"Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Dave:
> What does this mean? "I get Wizards error I make changes and click OK."
>
> --
>
> ~ Kathleen Anderson
> Microsoft FrontPage MVP
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> Dave <(E-Mail Removed)> wrote:
> > I spoke too soon.
> >
> > I get results below, but I get Wizards error I make changes and click
> > OK.
> >
> > Dave
> >
> > "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)> wrote
> > in message news:%(E-Mail Removed)...
> >> Dave:
> >> In the top half of the Database Editor window, you should see a list
> >> of the records in your database table. One of the fields in the
> >> record should be a hyperlink. Click on it and the detail of that
> >> record will appear in the lower half of the window. If you want to
> >> edit the record, click the Edit button at the bottom of the page and
> >> it will give you all the fields in text boxes for editing. Make your
> >> edits and click OK. The top half of the window will refresh and you
> >> should see your changes.
> >>
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft FrontPage MVP
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> Dave <(E-Mail Removed)> wrote:
> >>> Use existing DB!
> >>>
> >>> "Kathleen Anderson [MVP - FrontPage]" <(E-Mail Removed)>
> >>> wrote in message news:(E-Mail Removed)...
> >>>> Did you tell the wizard to use an existing database connection or
> >>>> to create a new database?
> >>>>
> >>>> --
> >>>>
> >>>> ~ Kathleen Anderson
> >>>> Microsoft FrontPage MVP
> >>>> Spider Web Woman Designs
> >>>> http://www.spiderwebwoman.com/resources/
> >>>>
> >>>>
> >>>> Dave <(E-Mail Removed)> wrote:
> >>>>> The Database Interface Wizard creates the Database Editor Page
> >>>>> which is split in an upper and lower half.
> >>>>>
> >>>>> The lower half which is edit.asp shows No records found. The upper
> >>>>> half displays delete.asp and it works fine.
> >>>>>
> >>>>> I have deleted the folder that was crated and ran the wizard again
> >>>>> with the same results.
> >>>>>
> >>>>> The wizard seemed straight forward. Is there anything I am
> >>>>> missing? The database was created via FP2003
> >>>>>
> >>>>> I am using FrontPage 2003.
> >>>>>
> >>>>> Thanks
> >>>>>
> >>>>> Dave



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Successful search results returns a blank "Full Name" in results Sharam Microsoft Outlook Contacts 11 6th Jan 2008 03:41 AM
Database Editor & Database Results Wizard =?Utf-8?B?R3VpZG8=?= Microsoft Frontpage 2 26th Jan 2006 09:38 PM
Database Results Dropdown Imbedded in Other Database Results form Nicholas Microsoft Frontpage 0 29th Jul 2004 07:17 PM
Database Editor results error for me WebDeb Microsoft Frontpage 9 31st Mar 2004 10:12 PM
ASP Database Results and Search Form page displays results upon initial entry =?Utf-8?B?RGF0YWd1cnU=?= Microsoft Frontpage 3 27th Mar 2004 06:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:38 AM.