• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

Display value of query result in ASP

Hi Experts,

This seems simple enough but I can't figure it out or find a solution,  all I want to do is execute a sql query
sqlNewClients = "SELECT COUNT(AdvisorID) AS NewAdvisorID FROM TFN_Advisors"
And write the result in my ASP page

I need to replace There Are sqlNewClients  with the correct syntax.  Thanks

Dim objCmd
Set objCmd = Server.Createobject("ADODB.Connection")
strConnectionString = "Driver={SQL SERVER};Server=XXX.XX.XXX.XXX;Database=NAME;Uid=user;Pwd=password"
objCmd.Open strConnectionString
objCmd.Execute sqlNewClients
Set objCmd = Nothing
Response.Write("NewAdvisorID")
%>
<BR>
<font color ="navy" size=5><b><%="There Are sqlNewClients %>
<BR>

Open in new window

0
millerfw
Asked:
millerfw
1 Solution
 
millerfwAuthor Commented:
I forgot to add that if the values is zero I want to return the the home site if the values is >0 i want to return to the previous page.  I am assuming I can just right a function to do this just like in HTML.
0
 
_Stilgar_Commented:
See code below
Dim objConn, strSQL, rs, val
Set objConn = Server.Createobject("ADODB.Connection")
strConnectionString = "Driver={SQL SERVER};Server=XXX.XX.XXX.XXX;Database=NAME;Uid=user;Pwd=password"
objConn.Open strConnectionString
 
strSQL = "SELECT COUNT(AdvisorID) AS NewAdvisorID FROM TFN_Advisors"
set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open strSQL, Site_Conn
val = rs(0).value
rs.close
set rs = nothing
objConn.close
set objConn = nothing
 
if CInt(val)>0 then response.redirect "/" else response.redirect "/previouspage.asp"
%>
<BR>
<font color ="navy" size=5><b><%="There Are sqlNewClients %>
<BR>

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now