Hei!

Why does this not display the total number of records in the recordset?

set objRsTelle=server.createobject("ADODB.Recordset")

    objRsTelle.open "select COUNT(*) from Innsjekk", kobling, adOpenForwardOnly, adLockReadonly, adcmdtext

        if objRsTelle.eof then

            totaltRegistrert = objRsTelle

            else

        End if

            objRsTelle.Close

            set objRsTelle = Nothing

Response.write totaltRegistrert

With regards
grstad

__________________
Internet has become favorable with that tool...thank you Tim Berners-Lee!

Hi grstad,

objRsTelle is a recordset, you need to get the value from a field within it.

Try this...
HTH,

Chris

...thank you for your reply Chris Scott! (I will sooon try it out) But I wonder; it seems to be so many varied versions of all of the sql-query methods. Is it one standard Vb-script SQL which fit the ASP-tech?

Vennlig hilsen
grstad

I have changed the code somewhat, and it gives a 0x800A0E7D


dim objRsMenner,AlleMann,m

set objRsMenner=server.createobject("ADODB.Recordset")

(line 71) objRsMenner.open "SELECT COUNT(1) as m FROM Produkt WHERE ProduktKjonn = '" & mann & "' GROUP BY ProduktKjonn"'", kobling, adOpenStatic, adLockReadonly, adcmdtext

            AlleMann = objRsMenner("m").Value

            objRsMenner.Close

            set objRsMenner = Nothing




Feiltype:
ADODB.Recordset (0x800A0E7D)
Tilkoblingen kan ikke brukes til å utføre denne operasjonen. Den er enten lukket eller ugyldig i denne sammenhengen.
/innsjekk/treff_yngre.asp, linje 71

Med vennlig hilsen
grstad

... it does work, the variable no holds "0"!. But it is records in the db with the value like "mann"!?

Med vennlig hilsen
grstad

... it seems that an answer can be;

objRsMenner.open "SELECT COUNT(*) AS m, ProduktKjonn
FROM Produkt GROUP BY ProduktKjonn
ORDER BY COUNT(*) DESC;",
kobling, adOpenForwardOnly, adLockReadonly, adcmdtext

            AlleMann = objRsMenner("m").value

It is only two different values in the field ProduktKjonn. Either it is "mann" or it is "kvinne". The "DESC" in the query then sort out "menn", and count it to "some value". But what if there was more than two diff values in the field ProduktKjonn, and I want some value between "m" and "k"?. The WHERE...conditions, how does I get it to work?

Does anyone have the answer?

Med hilsen
grstad :)

...som har det med å svare seg selv!