| Groups | Blog | Home |
inetserver asp db : generating html
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") %>
SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:
[.......] [quoted text, click to view] > > 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 "" 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 %>. [quoted text, click to view] > 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. The Netherlands.
Sean O'Connor wrote on 06 aug 2007 in
microsoft.public.inetserver.asp.db: [quoted text, click to view] > "Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message > news:Xns99848AFC8903Ceejj99@194.109.133.242... >> SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db: >> >> [.......] >> >>> >>> 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 "" >> >> 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") >>> Set filetemp = fstemp.CreateTextFile("somepage.htm", true,true) >>> filetemp.Write(strHTML) >>> filetemp.Close >>> set filetemp = nothing >>> set xmlHttp = nothing >>> response.Redirect("somepage.html") >>> %> [Please do not toppost on usenet] [quoted text, click to view] > 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] [quoted text, click to view] > Set xmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP3.0") Try: "MSXML2.ServerXMLHTTP" [quoted text, click to view] > 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 [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 %> -- Evertjan. The Netherlands.
Evertjan. wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:
[quoted text, click to view] > 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? -- Evertjan. The Netherlands.
SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db:
[quoted text, click to view] > 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 %> -- Evertjan. The Netherlands.
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. [quoted text, click to view] "Evertjan." <exjxw.hannivoort@interxnl.net> wrote in message news:Xns99848AFC8903Ceejj99@194.109.133.242... > SOC wrote on 06 aug 2007 in microsoft.public.inetserver.asp.db: > > [.......] > >> >> 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 "" > > 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") >> Set filetemp = fstemp.CreateTextFile("somepage.htm", true,true) >> filetemp.Write(strHTML) >> filetemp.Close >> set filetemp = nothing >> set xmlHttp = nothing >> response.Redirect("somepage.html") >> %> > > > > -- > Evertjan. > The Netherlands. > (Please change the x'es to dots in my emailaddress)
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. [quoted text, click to view] "SOC" <zxc0@yahoo.com> wrote in message news:OuKgnrB2HHA.2064@TK2MSFTNGP03.phx.gbl... > (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") > %> > > >
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. [quoted text, click to view] "SOC" <zxc0@yahoo.com> wrote in message news:OuKgnrB2HHA.2064@TK2MSFTNGP03.phx.gbl... > (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") > %> > > >
Thanks Evertjan,
It works on a different machine. Soc. [quoted text, click to view] "SOC" <zxc0@yahoo.com> wrote in message news:uUCOx6D2HHA.5160@TK2MSFTNGP05.phx.gbl... > 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. > > "SOC" <zxc0@yahoo.com> wrote in message > news:OuKgnrB2HHA.2064@TK2MSFTNGP03.phx.gbl... >> (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") >> %> >> >> >> > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |