Hello
I have a postgresql table and i do a select via ASP
strSQL = "SELECT * FROM " & MioTabella & " WHERE TRIM(date_inserted) >= '" & datainizio & "' AND TRIM(date_inserted) <= '" & datafine & "'"
oRs.open strSQL,oConn,3
schede = oRs.RecordCount
Do until oRs.EOF
sch_sin = cint(sch_sin) + cint(oRs("SCHE_SINGOLA").Value)
oRs.movenext
Loop
Then inside my asp page in the body i write the result. and this works
<%
Response.write schede
%>
Then i want to get the SUM of the values inserted in the SCHE_SINGOLA column (defined as text)
<%
Response.Write sch_sin
%>
But here i get a type mismacth error..
What should i do?
Thanks