Getting SQL Count value into variable

[sd_javascript]

Hi all,

I'm trying to implement a pagination feature in my search page and I'm wondering how I can get and use the value that's returned from this SQL statement:

SELECT COUNT(*) FROM TableName WHERE Assigned = 'name'

I've run this query in the database query analyzer and it returned 19 however when I attempt the code on my page I get a 500 error.

Here's the page code:

Set row = conn.Execute("SELECT COUNT(*) FROM TableName WHERE Assigned = 'Name'")

<div id="resultTest"> <%=row%> </div>

[siteguru]

Set row = conn.Execute("SELECT COUNT(*) AS RowCount FROM TableName WHERE Assigned = 'Name'")

<div id="resultTest"> <%=row("RowCount")%> </div>)

[sd_javascript]

Set row = conn.Execute("SELECT COUNT(*) AS RowCount FROM TableName WHERE Assigned = 'Name'")

<div id="resultTest"> <%=row("RowCount")%> </div>)

Ah yes!

I tried doing exactly that except I forgot the quotation marks on "RowCount". Blast... It's always the smallest thing.

Thanks so much for your help!!