<div>
I forgot to add that if the values is zero I want to return the the home site if the values is &gt;0 i want to return to the previous page. &nbsp;I am assuming I can just right a function to do this just like in HTML.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
This seems simple enough but I can't figure it out or find a solution, &nbsp;all I want to do is execute a sql query<br />
sqlNewClients = &quot;SELECT COUNT(AdvisorID) AS NewAdvisorID FROM TFN_Advisors&quot;<br />
And write the result in my ASP page<br />
<br />
I need to replace There Are sqlNewClients &nbsp;with the correct syntax. &nbsp;Thanks<br />
<br />

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


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


Display value of query result in ASP

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.