I created a WEB site in Front Page 2000
All of the secure pages are .ASP and link to a SQL server database.
One user has Netscape and the page does not show completely.
Only the top 3 lines, which are:
"Terms: xxxxxx"
"Records found xxxx"
"Use your Browsers BACK button to add another part"
------------------------ here is the code ----------
<html>
<%@ Language=VBScript %>
<head>
<title>Parts Search Results</title>
</head>
<body>
<%pnum=request.querystring("PartNumber"
%>
<%desc=request.querystring("Description"%>
<%Customer=request.querystring("Customer"%>
<%PONum=request.querystring("PONum"%>
<%If PONum = "" then
NoPO = true
End If%>
<%
Set Conn = server.CreateObject("ADODB.Connection"
Conn.Open "driver=SQL Server;server=myserver.com;uid=user;pwd=pass;database=mydb;"
Set RS = Conn.Execute("SELECT Count(*) AS Recs FROM [Copy-PartMaster Lite] Where [STOCK_CODE] Like N'%" & pnum & "%' And [Description] Like N'%" & desc & "%'"
Set RS1 = Conn.Execute("SELECT [STOCK_CODE], [Description], [LONG_DESC], [SELLING_PRICE] FROM [Copy-PartMaster Lite] Where [STOCK_CODE] Like N'%" & pnum & "%' And [Description] Like N'%" & desc & "%'"
Set RS2 = Conn.Execute("SELECT * From Customers Where [CUSTOMER] ='" & Customer & "'"
Response.Write "Terms: " & RS2("PYMTRMID"
%>
<br>
Records Found <%=RS("Recs"%>
<p>Use your Browsers BACK button to add another part</p>
---------------
Any assistance would be appreciated
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
All of the secure pages are .ASP and link to a SQL server database.
One user has Netscape and the page does not show completely.
Only the top 3 lines, which are:
"Terms: xxxxxx"
"Records found xxxx"
"Use your Browsers BACK button to add another part"
------------------------ here is the code ----------
<html>
<%@ Language=VBScript %>
<head>
<title>Parts Search Results</title>
</head>
<body>
<%pnum=request.querystring("PartNumber"
%><%desc=request.querystring("Description"
%><%Customer=request.querystring("Customer"
%><%PONum=request.querystring("PONum"
%><%If PONum = "" then
NoPO = true
End If%>
<%
Set Conn = server.CreateObject("ADODB.Connection"
Conn.Open "driver=SQL Server;server=myserver.com;uid=user;pwd=pass;database=mydb;"
Set RS = Conn.Execute("SELECT Count(*) AS Recs FROM [Copy-PartMaster Lite] Where [STOCK_CODE] Like N'%" & pnum & "%' And [Description] Like N'%" & desc & "%'"
Set RS1 = Conn.Execute("SELECT [STOCK_CODE], [Description], [LONG_DESC], [SELLING_PRICE] FROM [Copy-PartMaster Lite] Where [STOCK_CODE] Like N'%" & pnum & "%' And [Description] Like N'%" & desc & "%'"
Set RS2 = Conn.Execute("SELECT * From Customers Where [CUSTOMER] ='" & Customer & "'"
Response.Write "Terms: " & RS2("PYMTRMID"
%>
<br>
Records Found <%=RS("Recs"
%> <p>Use your Browsers BACK button to add another part</p>
---------------
Any assistance would be appreciated
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
