hi guys
I want to move over my .asp site to .net gradually over time. To start I've renamed the first .asp file extension to .aspx
I've also added below code to the top of the page
<%@ Page Language="VB" Debug="true" %>
page code
however im getting a run time error
could someone shed some light please? for the time being i want to make minimal changes to have the asp coded page working as a .aspx page. and then I shall look into rebuilding every individual page in asp .net...
thanks in advance
Omar.
I want to move over my .asp site to .net gradually over time. To start I've renamed the first .asp file extension to .aspx
I've also added below code to the top of the page
<%@ Page Language="VB" Debug="true" %>
page code
Code:
<%@ Page Language="VB" Debug="true" %>
<html>
<head></head>
<body>
£
<%
'DISPLAY CHEAPEST LGWYYZ PRICE
DIM objConn1
Set objConn1 = Server.CreateObject("ADODB.Connection")
objConn1.ConnectionString = "Provider=SQLOLEDB;Data Source=DBIPGOESHERE;" & _
"Initial Catalog=Prices;User ID=USERNAME;Password=PASSWORDHERE"
objConn1.Open
DIM LGWYYZ
LGWYYZ = "Select LGWYYZPrice = MIN(LGWYYZPrice) from (Select MIN(Price_Band_1) As LGWYYZPrice from UK_Specials where Id in (1) UNION ALL " & _
"Select MIN(Price_Band_2) from UK_Specials where Id in (1) UNION ALL " & _
"Select MIN(Price_Band_3) from UK_Specials where Id in (1) UNION ALL " & _
"Select MIN(Price_Band_4) from UK_Specials where Id in (1) UNION ALL " & _
"Select MIN(Price_Band_5) from UK_Specials where Id in (1) )x"
DIM objRS1
Set objRS1 = Server.CreateObject("ADODB.Recordset")
objRS1.Open LGWYYZ, objConn1
Response.Write objRS1 (Trim("LGWYYZPrice"))
'close connection
objRS1.Close
Set objRS1 = Nothing
objConn1.Close
Set objConn1 = Nothing
%>
</body>
</html>
Code:
Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
thanks in advance
Omar.
Comment