I am using the count function to get a count of a field in the database and I then want to pass the counted value to a text box. I am way over my head in the respect that I've never done this before and I need help!!! please!!!


My SQL Statement:

SQL = "Select count(FrequencyID) num1 FROM Pain_Chart_data"

Text Box:

<p>&nbsp&nbsp&nbsp&nbsp Numerator: <input type="text" size="8" value="<%=num1%>" name="Num1" /readonly></p>

Am I on the right path? Is it possible to pass the count value to a text box?

Any help would be appreciated. Thanks!

not sure readonly can fit you purpose, you may use disabled instead. Other than that, a simple test can prove if it is working.

Your general approach looks right. Are you having a specific problem with it or what??