• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • 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
<font color ="navy" size=5><b><%="There Are sqlNewClients %>

Open in new window

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.
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
set rs = nothing
set objConn = nothing
if CInt(val)>0 then response.redirect "/" else response.redirect "/previouspage.asp"
<font color ="navy" size=5><b><%="There Are sqlNewClients %>

Open in new window

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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