Send database results to email

I have a FP2003 asp results page that displays results from an Access
database. So far ok. It looks ok on the web , so I now want to click IE7 to
"send this page" (not just a link but the page exactly how it looks in IE7)
to an email addressee. When I try this, all the data areas on the page
display Database Results Error". Is there a way to copy this page into the
body of an email without literally copy/paste from the asp results page
please. Thank you.

"Mick" <Mick@discussions.microsoft.com> wrote in message
news:EBFE4311-87CA-464A-99A2-EA9F9A159436@microsoft.com...
>I have a FP2003 asp results page that displays results from an Access
> database. So far ok. It looks ok on the web , so I now want to click IE7
> to
> "send this page" (not just a link but the page exactly how it looks in
> IE7)
> to an email addressee. When I try this, all the data areas on the page
> display Database Results Error". Is there a way to copy this page into the
> body of an email without literally copy/paste from the asp results page

Mick,
The reason your seeing the "database results error" is because the page is
being created dynamically so there is no fixed data in there. That is why
you would have to "copy" the entire thing not just the code of the page.
It should be possible to arrange for the page to be e-mailed directly but
that would actually require an additional "submit" button. And you might
need some custom written code to do it. I am uncertain if FP extensions can
be setup to do that directly.

FP VIP?

Thanks,
Tom Miller



--
Posted via a free Usenet account from http://www.teranews.com

From IE7, use File->Save As and save the page to your desktop as a
complete web page with .mht extension.
Then attach the .mht file to your email.

You may get better answers in an Internet Explorer newsgroup or forum.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/
http://www.rxs-enterprises.org/fp



"Mick" <Mick@discussions.microsoft.com> wrote in message
news:EBFE4311-87CA-464A-99A2-EA9F9A159436@microsoft.com:

> I have a FP2003 asp results page that displays results from an Access
> database. So far ok. It looks ok on the web , so I now want to click IE7 to
> "send this page" (not just a link but the page exactly how it looks in IE7)
> to an email addressee. When I try this, all the data areas on the page
> display Database Results Error". Is there a way to copy this page into the
> body of an email without literally copy/paste from the asp results page
> please. Thank you.

Hi Tom, many thanks, I understand your reply and rationale. I suppose the
next question is, can I transfer the dynamic parts of the page directly to
email as well? I have experimented with other sites and exactly the same
happens, i.e. the dynamic parts either show an error or blank. So perhaps the
problem is not just a FrontPage one, but its a wider one. I dont really know
where to go from here. Thanks anyway for your time. Mick

"Tom Miller" wrote:

> "Mick" <Mick@discussions.microsoft.com> wrote in message
> news:EBFE4311-87CA-464A-99A2-EA9F9A159436@microsoft.com...
> >I have a FP2003 asp results page that displays results from an Access
> > database. So far ok. It looks ok on the web , so I now want to click IE7
> > to
> > "send this page" (not just a link but the page exactly how it looks in
> > IE7)
> > to an email addressee. When I try this, all the data areas on the page
> > display Database Results Error". Is there a way to copy this page into the
> > body of an email without literally copy/paste from the asp results page
>
> Mick,
> The reason your seeing the "database results error" is because the page is
> being created dynamically so there is no fixed data in there. That is why
> you would have to "copy" the entire thing not just the code of the page.
> It should be possible to arrange for the page to be e-mailed directly but
> that would actually require an additional "submit" button. And you might
> need some custom written code to do it. I am uncertain if FP extensions can
> be setup to do that directly.
>
> FP VIP?
>
> Thanks,
> Tom Miller
>
>
>
> --
> Posted via a free Usenet account from http://www.teranews.com
>
>

I just tried emailing a page that gets data from a database using
File->Send from IE7. There were no problems except IE7 paced a <base
href="...> tag immediately before the <!doctype... , which caused IE7 to
go into quirks mode - thus altering the font size and layout slightly.

However, when a form is involved in the page the page sent by email will
be the form submitted with nothing entered in the fields - this will
probably result in your database errors.

Unfortunately, saving as a web archive file does exactly the same thing,
but saving as HTML page will preserve the data (it did in my test), but
not any external CSS or JavaScript files or images; saving as web page
complete will also save additional files such as CSS and images, but as
separate files.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/
http://www.rxs-enterprises.org/fp



"Mick" <Mick@discussions.microsoft.com> wrote in message
news:EBFE4311-87CA-464A-99A2-EA9F9A159436@microsoft.com:

> I have a FP2003 asp results page that displays results from an Access
> database. So far ok. It looks ok on the web , so I now want to click IE7 to
> "send this page" (not just a link but the page exactly how it looks in IE7)
> to an email addressee. When I try this, all the data areas on the page
> display Database Results Error". Is there a way to copy this page into the
> body of an email without literally copy/paste from the asp results page
> please. Thank you.

Hi Ron, many thanks for your input. I think this one goes on the "pending"
list, I keep trying various options but with similar results, the dynamic
parts of the results only appears correctly on a cut and paste into the
email. So unless there is a way to take a "picture" of the results page and
email that off, I think its a no go from here. Many thanks to Tom & Ron for
trying. Kind regards
Mick

"Ronx" wrote:

> I just tried emailing a page that gets data from a database using
> File->Send from IE7. There were no problems except IE7 paced a <base
> href="...> tag immediately before the <!doctype... , which caused IE7 to
> go into quirks mode - thus altering the font size and layout slightly.
>
> However, when a form is involved in the page the page sent by email will
> be the form submitted with nothing entered in the fields - this will
> probably result in your database errors.
>
> Unfortunately, saving as a web archive file does exactly the same thing,
> but saving as HTML page will preserve the data (it did in my test), but
> not any external CSS or JavaScript files or images; saving as web page
> complete will also save additional files such as CSS and images, but as
> separate files.
> --
> Ron Symonds - Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
> FrontPage Support: http://www.frontpagemvps.com/
> http://www.rxs-enterprises.org/fp
>
>
>
> "Mick" <Mick@discussions.microsoft.com> wrote in message
> news:EBFE4311-87CA-464A-99A2-EA9F9A159436@microsoft.com:
>
> > I have a FP2003 asp results page that displays results from an Access
> > database. So far ok. It looks ok on the web , so I now want to click IE7 to
> > "send this page" (not just a link but the page exactly how it looks in IE7)
> > to an email addressee. When I try this, all the data areas on the page
> > display Database Results Error". Is there a way to copy this page into the
> > body of an email without literally copy/paste from the asp results page
> > please. Thank you.
>
>

To get a screen dump:
Open the page in a browser and click in the page to ensure the browser
is the "active" window.
Type Alt+PrtScn to copy the browser window to the clipboard.
Open a graphics editor (example Paint) and paste (ctrl+V) the image in.
Save and email the image.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/
http://www.rxs-enterprises.org/fp



"Mick" <Mick@discussions.microsoft.com> wrote in message
news:5082106D-C432-487F-93D2-0397FC778E40@microsoft.com:

> Hi Ron, many thanks for your input. I think this one goes on the "pending"
> list, I keep trying various options but with similar results, the dynamic
> parts of the results only appears correctly on a cut and paste into the
> email. So unless there is a way to take a "picture" of the results page and
> email that off, I think its a no go from here. Many thanks to Tom & Ron for
> trying. Kind regards
> Mick
>
> "Ronx" wrote:
>
> > I just tried emailing a page that gets data from a database using
> > File->Send from IE7. There were no problems except IE7 paced a <base
> > href="...> tag immediately before the <!doctype... , which caused IE7 to
> > go into quirks mode - thus altering the font size and layout slightly.
> >
> > However, when a form is involved in the page the page sent by email will
> > be the form submitted with nothing entered in the fields - this will
> > probably result in your database errors.
> >
> > Unfortunately, saving as a web archive file does exactly the same thing,
> > but saving as HTML page will preserve the data (it did in my test), but
> > not any external CSS or JavaScript files or images; saving as web page
> > complete will also save additional files such as CSS and images, but as
> > separate files.
> > --
> > Ron Symonds - Microsoft MVP (FrontPage)
> > Reply only to group - emails will be deleted unread.
> > FrontPage Support: http://www.frontpagemvps.com/
> > http://www.rxs-enterprises.org/fp
> >
> >
> >
> > "Mick" <Mick@discussions.microsoft.com> wrote in message
> > news:EBFE4311-87CA-464A-99A2-EA9F9A159436@microsoft.com:
> >
> > > I have a FP2003 asp results page that displays results from an Access
> > > database. So far ok. It looks ok on the web , so I now want to click IE7 to
> > > "send this page" (not just a link but the page exactly how it looks in IE7)
> > > to an email addressee. When I try this, all the data areas on the page
> > > display Database Results Error". Is there a way to copy this page into the
> > > body of an email without literally copy/paste from the asp results page
> > > please. Thank you.
> >
> >