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.