pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>
To: pgsql-sql@postgresql.org
Subject: Select and Count
Date: Tue, 20 Mar 2007 11:14:29 +0100
Message-ID: <005701c76ad8$8c4c7690$1102a8c0@dream> (raw)

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

Shavonne Wijesinghe
www.studioform.it
 

view thread (3+ messages)  latest in thread

Message-ID: <005701c76ad8$8c4c7690$1102a8c0@dream>
Permalink:  ../005701c76ad8$8c4c7690$1102a8c0@dream/
Also on:    postgresql.org/message-id/005701c76ad8$8c4c7690$1102a8c0@dream

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: shavonne.marietta@studioform.it
  Subject: Re: Select and Count
  In-Reply-To: <005701c76ad8$8c4c7690$1102a8c0@dream>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox