Don't know any ASP but maybe Response.Write only accepts strings. In
that case you would need to do something like
<%
Response.Write cStr(sch_sin)
%>
Maybe you can let the database do the summing:
<% option explicit %>
<%
Dim strSQL
Dim oRs
Dim oConn
oConn = ... 'Fill t
On Tue, 20 Mar 2007, Shavonne Marietta Wijesinghe wrote:
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.
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) + cin