Re: [SQL] Select and Count

2007-03-20 Thread Bart Degryse
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

Re: [SQL] Select and Count

2007-03-20 Thread Martin Marques
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.

[SQL] Select and Count

2007-03-20 Thread Shavonne Marietta Wijesinghe
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