Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 57D9C9FB2A7 for ; Tue, 20 Mar 2007 07:14:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 07394-07 for ; Tue, 20 Mar 2007 07:14:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtpout22.attiva.biz (smtpout22.attiva.biz [85.37.16.9]) by postgresql.org (Postfix) with ESMTP id 383189FB2A5 for ; Tue, 20 Mar 2007 07:14:25 -0300 (ADT) Received: from FBCMFE02B08.fbc.local ([192.168.30.96]) by smtpout22.attiva.biz with Microsoft SMTPSVC(6.0.3790.1830); Tue, 20 Mar 2007 11:14:23 +0100 Received: from dream ([88.34.161.130]) by FBCMFE02B08.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Tue, 20 Mar 2007 11:14:23 +0100 Message-ID: <005701c76ad8$8c4c7690$1102a8c0@dream> Reply-To: "Shavonne Marietta Wijesinghe" From: "Shavonne Marietta Wijesinghe" To: Subject: Select and Count Date: Tue, 20 Mar 2007 11:14:29 +0100 Organization: Studio FORM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0054_01C76AE0.EDBB1D70" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-OriginalArrivalTime: 20 Mar 2007 10:14:23.0454 (UTC) FILETIME=[883D2FE0:01C76AD8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.311 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200703/270 X-Sequence-Number: 27908 This is a multi-part message in MIME format. ------=_NextPart_000_0054_01C76AE0.EDBB1D70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello I have a postgresql table and i do a select via ASP strSQL =3D "SELECT * FROM " & MioTabella & " WHERE TRIM(date_inserted) = >=3D '" & datainizio & "' AND TRIM(date_inserted) <=3D '" & datafine & = "'" oRs.open strSQL,oConn,3 schede =3D oRs.RecordCount Do until oRs.EOF sch_sin =3D 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 <%=20 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 Shavonne Wijesinghe www.studioform.it =20 ------=_NextPart_000_0054_01C76AE0.EDBB1D70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello

I have a postgresql table = and i do a=20 select via ASP

strSQL =3D "SELECT = * FROM " &=20 MioTabella & " WHERE TRIM(date_inserted) >=3D '" & datainizio = & "'=20 AND TRIM(date_inserted) <=3D '" & datafine &=20 "'"

oRs.open=20 strSQL,oConn,3
schede =3D oRs.RecordCount

Do = until=20 oRs.EOF
sch_sin =3D cint(sch_sin) +=20 cint(oRs("SCHE_SINGOLA").Value)
oRs.movenext
Loop

Then inside my asp page in = the body i=20 write the result. and this works

<% =
Response.write=20 schede
%>

Then i want to get the SUM = of the=20 values inserted in the SCHE_SINGOLA column (defined as = text)

<%
Response.Write=20 sch_sin
%>

But here i get = a type=20 mismacth error..

What should i=20 do?

= ;

Thanks

Shavonne Wijesinghe
www.studioform.it

------=_NextPart_000_0054_01C76AE0.EDBB1D70--