I have a sql statement which will select an integer column from oracle database. Below are the codes :
*****************************************
sqlSelect =
"select id from temptable where " & _
"trans_id = '123'"
Set rs = conn.Execute (sqlSelect)
id = rs(0)
Response.Write "id = " & id & "<br>"
*****************************************
I'm not able to print out the value using Response.Write, even if i do this : id = CStr(rs(0))
The only solution i found was to change the select statement
to "select to_char(id) from temptable where trans_id = '123'".
My question is, doesn't asp treat all the resultset values as string? Thanks in advance.
*****************************************
sqlSelect =
"select id from temptable where " & _
"trans_id = '123'"
Set rs = conn.Execute (sqlSelect)
id = rs(0)
Response.Write "id = " & id & "<br>"
*****************************************
I'm not able to print out the value using Response.Write, even if i do this : id = CStr(rs(0))
The only solution i found was to change the select statement
to "select to_char(id) from temptable where trans_id = '123'".
My question is, doesn't asp treat all the resultset values as string? Thanks in advance.