Help | Site Map
Connecting Tech Pros Worldwide
 
 
LinkBack Thread Tools
  #1  
Old July 19th, 2005, 01:06 PM
Jim Rudnick
Guest
 
Posts: n/a
Default save an HTML report...

I am generating a report in HTML, that my users can look over AND if
they want to, store in their own Access dbase.

Thing is, I do not know how to "read" that whole html page into a var
and store same in a field in Access.

Can anyone point me here?

Jim



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
  #2  
Old July 19th, 2005, 01:06 PM
Alan Howard
Guest
 
Posts: n/a
Default Re: save an HTML report...

Buffer the HTML to a string first. You can then preview the page (in a new
window or wherever) using Response.Write strPageHtml and/or store the HTML
in the database in a normal char, varchar, text field.

Alan

"Jim Rudnick" <jrudnick@kkti.com> wrote in message
news:OMhsE3TMEHA.1272@tk2msftngp13.phx.gbl...[color=blue]
> I am generating a report in HTML, that my users can look over AND if
> they want to, store in their own Access dbase.
>
> Thing is, I do not know how to "read" that whole html page into a var
> and store same in a field in Access.
>
> Can anyone point me here?
>
> Jim
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]


  #3  
Old July 19th, 2005, 01:06 PM
Jim Rudnick
Guest
 
Posts: n/a
Default Re: save an HTML report...


Hmmm...exactly what does "buffer the string" in this context mean?

The html report is the result of a query on another text file and it
will be pretty plain, but will have a table in it for sure.

So, how do I "buffer" same? I know how to write a string to a dbase,
just not how to read an onscreen .html page into that string???

;-)

Jim


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
  #4  
Old July 19th, 2005, 01:06 PM
Alan Howard
Guest
 
Posts: n/a
Default Re: save an HTML report...

Instead of just Response.Write'ing your content out, set up a local variable
and write the various bits 'n' pieces to it:

Dim strPageHtml

' Buffer the HTML to a local variable, strPageHtml
strPageHtml = ""
strPageHtml = strPageHtml & "<html>"
strPageHtml = strPageHtml & "<head>"
....
strPageHtml = strPageHtml & "</body>"
strPageHtml = strPageHtml & "</html>"
....

' Output the HTML - this will display the content on-screen.
Response.Write strPageHtml

I'm not suggesting that you'll be able to do this without reorganising your
code though. You might display the HTML content onscreen along with, say, a
small form at the bottom of the page. The form contains a hidden control
whose value is the strPageHtml variable you created when buffering the page.
The form is submitted when the user elects to save the report to the
database, and when this happens you post the value of the variable (the page
HTML) to the processor where it can be written to the database.

Alan


"Jim Rudnick" <jrudnick@kkti.com> wrote in message
news:%23iXcZFVMEHA.628@TK2MSFTNGP11.phx.gbl...[color=blue]
>
> Hmmm...exactly what does "buffer the string" in this context mean?
>
> The html report is the result of a query on another text file and it
> will be pretty plain, but will have a table in it for sure.
>
> So, how do I "buffer" same? I know how to write a string to a dbase,
> just not how to read an onscreen .html page into that string???
>
> ;-)
>
> Jim
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]


  #5  
Old July 19th, 2005, 01:06 PM
Alan Howard
Guest
 
Posts: n/a
Default Re: save an HTML report...

By the way Jim, you should mangle your email address (assuming it's real) to
stop spambots picking it up in these newsgroups.

Alan

"Jim Rudnick" <deleted> wrote in message
news:%23iXcZFVMEHA.628@TK2MSFTNGP11.phx.gbl...[color=blue]
>
> Hmmm...exactly what does "buffer the string" in this context mean?
>
> The html report is the result of a query on another text file and it
> will be pretty plain, but will have a table in it for sure.
>
> So, how do I "buffer" same? I know how to write a string to a dbase,
> just not how to read an onscreen .html page into that string???
>
> ;-)
>
> Jim
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]


 

Bookmarks

Thread Tools

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 Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles