asp and sql statement question thanks

[melnet]

hi

sql="SELECT Count(*) FROM employeeswhere productID='" & pid & "'""
set rs=kc.execute(sql)

next step, how to display the count(*) in asp!?

thanks

 

[onpnt]

sql="SELECT Count(*) FROM employeeswhere productID='" & pid & "'""
set rs=kc.execute(sql)

to

sql="SELECT Count(*) as cnt FROM employees where productID='" & pid & "'""
set rs=kc.execute(sql)

and display rs("cnt")

pid really a string?

___________________________________________________________________

_{onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811}

 

[melnet]

yes ...
coz it's foregin key(forgot how to spell)
it's fault?i should set it to be number type in access?