Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / ASP / Database Access / August 2007



Tip: Looking for answers? Try searching our database.

generating html

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SOC - 06 Aug 2007 12:13 GMT
(Further to "24hrs static content".....many thanks)
Currently our web site is pulling all pages from a database, dependent on
querystrings.

I wish to set up different system:

index.asp lists a selection of links to pages, but instead of
href="/page.asp?a=10&b=20"
the link will be
href="/10/20.html"

This html page will not be present when the link is used for the first time,
so goes to custom 404.

404.asp extract the querystring from the page name and directory, generates
the html and creates the 20.html page.
Then it redirects to 20.html.
Future users will go to a html page with no need for database access.

I'm having difficulty generating the html, I'm testing the code below. Am i
on the correct track?
Thanks.

MSXML3.dll error '80072ee7'

The server name or address could not be resolved

/404.asp, line 27    (...xmlHttp.Send "")

<%
Response.Expires = -1
URLToRSS = http://www.abcde12345xyz.com:99/anindex.html
Set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP3.0")
xmlHttp.Open "Get", URLToRSS, false
xmlHttp.Send ""
strHTML = xmlHttp.ResponseText
Set fstemp = server.CreateObject("Scripting.FileSystemObject")
Set filetemp = fstemp.CreateTextFile("somepage.htm", true,true)
filetemp.Write(strHTML)
filetemp.Close
set filetemp = nothing
set xmlHttp = nothing
response.Redirect("somepage.html")
%>
Evertjan. - 06 Aug 2007 12:39 GMT
SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:

[.......]

> MSXML3.dll error '80072ee7'
>
[quoted text clipped - 8 lines]
> xmlHttp.Open "Get", URLToRSS, false
> xmlHttp.Send ""

So the url does not exist or is inaccessable from the server.

The below is not part of the problem, and is not even executed, meseems.

Retest the url,
and then make a testpage, a simple test.asp, not containing the below,
but the %>.

> strHTML = xmlHttp.ResponseText
> Set fstemp = server.CreateObject("Scripting.FileSystemObject")
[quoted text clipped - 5 lines]
> response.Redirect("somepage.html")
> %>

Signature

Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Sean O'Connor - 06 Aug 2007 16:01 GMT
I have been able to create a web page using filesystemobject, but I can't
generate content using msxml:

       Response.Expires = -1
       URLToRSS=http://www.abc123.xyz.com
       Set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP3.0")
       xmlHttp.Open "Get", URLToRSS, false
       xmlHttp.Send ()             (....line27)

The following error is returned.

MSXML3.dll error '80072ee7'

The server name or address could not be resolved

/404.asp, line 27

Thanks.

> SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:
>
[quoted text clipped - 30 lines]
>> response.Redirect("somepage.html")
>> %>
Evertjan. - 06 Aug 2007 16:34 GMT
Sean O'Connor wrote on 06 aug 2007 in
microsoft.public.inetserver.asp.db:

>> SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:
>>
[quoted text clipped - 31 lines]
>>> response.Redirect("somepage.html")
>>> %>

[Please do not toppost on usenet]

> I have been able to create a web page using filesystemobject, but I
> can't generate content using msxml:
>
>         Response.Expires = -1
>         URLToRSS=http://www.abc123.xyz.com

Forgetting the quotes is unforgivable in vbs!!!
[while allowed in jscript]

>         Set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP3.0")

Try:

"MSXML2.ServerXMLHTTP"

>         xmlHttp.Open "Get", URLToRSS, false
>         xmlHttp.Send ()             (....line27)
[quoted text clipped - 6 lines]
>
> /404.asp, line 27

[advice: do not use 404.asp for testing!]

This works fine overhere:

<%
   Response.Expires = -1
   URLToRSS="http://www.google.com/"
   Set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP")
   xmlHttp.Open "Get", URLToRSS, false
   xmlHttp.Send ()
   response.write  xmlHttp.ResponseText
%>

Signature

Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Evertjan. - 06 Aug 2007 16:36 GMT
Evertjan. wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:
> Sean O'Connor wrote on 06 aug 2007 in
>> "Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message
>>> SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:


Why do you change your name in one and the same thread, Sean?

Signature

Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

SOC - 06 Aug 2007 16:28 GMT
Apologies, reading an earlier post on this subject, I have noticed that the
web cannot be browsed from this server, and therefore content cannot be
generated from the web.
Thanks Soc.

> (Further to "24hrs static content".....many thanks)
> Currently our web site is pulling all pages from a database, dependent on
[quoted text clipped - 40 lines]
> response.Redirect("somepage.html")
> %>
Evertjan. - 06 Aug 2007 16:38 GMT
SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:

> Apologies, reading an earlier post on this subject, I have noticed
> that the web cannot be browsed from this server, and therefore content
> cannot be generated from the web.

Sean,
please first try correct code,
before you decide your server is the culprit.

<%
   Response.Expires = -1
   URLToRSS="http://www.google.com/"
   Set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP")
   xmlHttp.Open "Get", URLToRSS, false
   xmlHttp.Send ()
   response.write  xmlHttp.ResponseText
%>

Signature

Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

SOC - 06 Aug 2007 16:29 GMT
Apologies, having read an earlier post on this subject, I have noticed that
the
web cannot be browsed from this server, and therefore content cannot be
generated from the web.
Thanks Soc.

> (Further to "24hrs static content".....many thanks)
> Currently our web site is pulling all pages from a database, dependent on
[quoted text clipped - 40 lines]
> response.Redirect("somepage.html")
> %>
SOC - 07 Aug 2007 09:59 GMT
Thanks Evertjan,
It works on a different machine.
Soc.
> Apologies, having read an earlier post on this subject, I have noticed
> that the
[quoted text clipped - 46 lines]
>> response.Redirect("somepage.html")
>> %>
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.