2. ASPRunnerPro General questions
  3. Display 'RunDate' from DB at top of List Page
This topic is locked

Display 'RunDate' from DB at top of List Page

 		11/15/2007 6:36:14 PM
ASPRunnerPro General questions
pbunyon99 author

I want to display a single 'As Of' date at the top of an ASP Runner List Page.

The 'RunDate' column is is my database, and all records have the same date.
In previous projects, I was able to insert a row, above my columns and drag that field

to that row, and it would display. However, in this project, its not working.

The only thing that is displayed is "1RunDate_value".
I am using the London layout.
I can't understand why one project will let me do this, but not another.

Can you suggest another way to do this ?
(maybe a 'Select RunDate from DataTable Group by RunDate' stuffed into a variable ?? But how do I display it? )
Thanks.
Sergey Kornilov admin 11/16/2007

1RunDate_value won't work if placed outside <!--{foreach from=$rowinfo item=row}--> ... <!--{/foreach}--> section.
I suggest to use Insert ASP code snippet button in Visual Editor.

set rstmp=Server.CreateObject("ADODB.Recordset")

rstmp.Open "Select RunDate from DataTable Group by RunDate", dbConnection

Response.Write rstmp(0)

rstmp.close : set rstmp=nothing