ASP page call problem

[Simeon Shapiro]

Any suggestions on the following problem:
I am making a call to an ASP page with the following call string:
admin_update_notice_processor.asp?NoticeID=<%=Requ est.QueryString("Notic
eID")%>

The page is as follows:

<%@LANGUAGE="VBSCRIPT"%>
<%
Dim dbConn
Dim nt_fixed
nt_fixed = Replace(Request.Form("Notice"),"'","&#39;")

Set dbConn = server.CreateObject("adodb.connection")
dbConn.open("CSh")
dbConn.Execute("UPDATE tbl_notices SET UserName = '" &
Request.Form("Author") & "', Header = '" & Request.Form("Header") & "',
Notice = '" & nt_fixed & "' WHERE NoticeID=" &
Request.QueryString("NoticeID"))
Response.Redirect("admin_manage_notice.asp")
%>

There is nothing else on the page. It works on my machine, but when
uploaded to the ISP, the page can't be found. All calls go to an Access
DB through a DNS called "CSh".
Thanks
Shimon



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

You're getting a 404 error? If so, this code isn't the issue. Are you sure
you're uploading the file to the right place? Are you running chilisoft on
a *nix server? If so, are you paying attention to case-sensitivity of the
filename? What error are you seeing in your browser? Did you upload
admin_manage_notice.asp? What happens if you comment out the redirect?
Which page is 404'ing?

Ray at work



"Simeon Shapiro" <shimon@iafrica.com> wrote in message
news:u6CFX8kuDHA.2492@TK2MSFTNGP12.phx.gbl...

> Any suggestions on the following problem:
> I am making a call to an ASP page with the following call string:
> admin_update_notice_processor.asp?NoticeID=<%=Requ est.QueryString("Notic
> eID")%>
>
> The page is as follows:
>
> <%@LANGUAGE="VBSCRIPT"%>
> <%
> Dim dbConn
> Dim nt_fixed
> nt_fixed = Replace(Request.Form("Notice"),"'","&#39;")
>
> Set dbConn = server.CreateObject("adodb.connection")
> dbConn.open("CSh")
> dbConn.Execute("UPDATE tbl_notices SET UserName = '" &
> Request.Form("Author") & "', Header = '" & Request.Form("Header") & "',
> Notice = '" & nt_fixed & "' WHERE NoticeID=" &
> Request.QueryString("NoticeID"))
> Response.Redirect("admin_manage_notice.asp")
> %>
>
> There is nothing else on the page. It works on my machine, but when
> uploaded to the ISP, the page can't be found. All calls go to an Access
> DB through a DNS called "CSh".
> Thanks
> Shimon
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Aaron Bertrand - MVP]

This is probably because you have "Show friendly HTTP errors" set in IE's
Tools/Internet Options/Advanced

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Simeon Shapiro" <shimon@iafrica.com> wrote in message
news:u6CFX8kuDHA.2492@TK2MSFTNGP12.phx.gbl...

> Any suggestions on the following problem:
> I am making a call to an ASP page with the following call string:
> admin_update_notice_processor.asp?NoticeID=<%=Requ est.QueryString("Notic
> eID")%>
>
> The page is as follows:
>
> <%@LANGUAGE="VBSCRIPT"%>
> <%
> Dim dbConn
> Dim nt_fixed
> nt_fixed = Replace(Request.Form("Notice"),"'","&#39;")
>
> Set dbConn = server.CreateObject("adodb.connection")
> dbConn.open("CSh")
> dbConn.Execute("UPDATE tbl_notices SET UserName = '" &
> Request.Form("Author") & "', Header = '" & Request.Form("Header") & "',
> Notice = '" & nt_fixed & "' WHERE NoticeID=" &
> Request.QueryString("NoticeID"))
> Response.Redirect("admin_manage_notice.asp")
> %>
>
> There is nothing else on the page. It works on my machine, but when
> uploaded to the ISP, the page can't be found. All calls go to an Access
> DB through a DNS called "CSh".
> Thanks
> Shimon
>
>
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!