ASP command

Discussion in 'ASP .Net Web Services' started by Mickael JOUVIN, Dec 3, 2004.

  1. Hello,
    I would like to know what is the ASP command which returns the number of
    record after a SQL request ?
    Regards,

    Mickaël.
    Mickael JOUVIN, Dec 3, 2004
    #1
    1. Advertising

  2. Mickael JOUVIN

    Dan Rogers Guest

    I believe the response object has a recordcount property on it.


    --------------------
    >From: "Mickael JOUVIN" <>
    >Newsgroups: microsoft.public.dotnet.framework.aspnet.webservices
    >Subject: ASP command
    >Date: Fri, 3 Dec 2004 15:46:16 +0100
    >Organization: CRAA
    >Lines: 8
    >Message-ID: <copu4m$3a2$>
    >Reply-To: "Mickael JOUVIN" <>
    >NNTP-Posting-Host: agri-bord.rain.fr
    >X-Trace: s5.feed.news.oleane.net 1102085078 3394 81.80.110.184 (3 Dec 2004

    14:44:38 GMT)
    >X-Complaints-To:
    >NNTP-Posting-Date: Fri, 3 Dec 2004 14:44:38 +0000 (UTC)
    >X-Priority: 3
    >X-MSMail-Priority: Normal
    >X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
    >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
    >Path:

    cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!new
    sfeed1.ip.tiscali.net!proxad.net!proxad.net!oleane.net!oleane!not-for-mail
    >Xref: cpmsftngxa10.phx.gbl

    microsoft.public.dotnet.framework.aspnet.webservices:27019
    >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservices
    >
    >Hello,
    >I would like to know what is the ASP command which returns the number of
    >record after a SQL request ?
    >Regards,
    >
    >Mickaël.
    >
    >
    >
    Dan Rogers, Dec 3, 2004
    #2
    1. Advertising

  3. Mickael JOUVIN

    Scott M. Guest

    An ADO RecordSet has a RecordCount property. The Response object does not
    since the Response object has nothing to do with data returned from a
    database.

    RecordCount however, is classic ADO, not ADO.NET and RecordCount returns
    however many records there are in a RecordSet and not necessarially how many
    records were affected by executing a command.


    "Dan Rogers" <> wrote in message
    news:...
    >I believe the response object has a recordcount property on it.
    >
    >
    > --------------------
    >>From: "Mickael JOUVIN" <>
    >>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservices
    >>Subject: ASP command
    >>Date: Fri, 3 Dec 2004 15:46:16 +0100
    >>Organization: CRAA
    >>Lines: 8
    >>Message-ID: <copu4m$3a2$>
    >>Reply-To: "Mickael JOUVIN" <>
    >>NNTP-Posting-Host: agri-bord.rain.fr
    >>X-Trace: s5.feed.news.oleane.net 1102085078 3394 81.80.110.184 (3 Dec 2004

    > 14:44:38 GMT)
    >>X-Complaints-To:
    >>NNTP-Posting-Date: Fri, 3 Dec 2004 14:44:38 +0000 (UTC)
    >>X-Priority: 3
    >>X-MSMail-Priority: Normal
    >>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
    >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
    >>Path:

    > cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!new
    > sfeed1.ip.tiscali.net!proxad.net!proxad.net!oleane.net!oleane!not-for-mail
    >>Xref: cpmsftngxa10.phx.gbl

    > microsoft.public.dotnet.framework.aspnet.webservices:27019
    >>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservices
    >>
    >>Hello,
    >>I would like to know what is the ASP command which returns the number of
    >>record after a SQL request ?
    >>Regards,
    >>
    >>Mickaël.
    >>
    >>
    >>

    >
    Scott M., Dec 3, 2004
    #3
  4. Mickael JOUVIN

    Dan Rogers Guest

    Ahh, yes. My bad. It's been a while since I had to do that... this being
    the WS forum and all.

    --------------------
    >From: "Scott M." <>
    >References: <copu4m$3a2$>

    <>
    >Subject: Re: ASP command
    >Date: Fri, 3 Dec 2004 18:38:34 -0500
    >Lines: 51
    >X-Priority: 3
    >X-MSMail-Priority: Normal
    >X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
    >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
    >X-RFC2646: Format=Flowed; Original
    >Message-ID: <>
    >Newsgroups: microsoft.public.dotnet.framework.aspnet.webservices
    >NNTP-Posting-Host: 69.37.4.150.adsl.snet.net 69.37.4.150
    >Path:

    cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
    ..phx.gbl
    >Xref: cpmsftngxa10.phx.gbl

    microsoft.public.dotnet.framework.aspnet.webservices:27030
    >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservices
    >
    >An ADO RecordSet has a RecordCount property. The Response object does not
    >since the Response object has nothing to do with data returned from a
    >database.
    >
    >RecordCount however, is classic ADO, not ADO.NET and RecordCount returns
    >however many records there are in a RecordSet and not necessarially how

    many
    >records were affected by executing a command.
    >
    >
    >"Dan Rogers" <> wrote in message
    >news:...
    >>I believe the response object has a recordcount property on it.
    >>
    >>
    >> --------------------
    >>>From: "Mickael JOUVIN" <>
    >>>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservices
    >>>Subject: ASP command
    >>>Date: Fri, 3 Dec 2004 15:46:16 +0100
    >>>Organization: CRAA
    >>>Lines: 8
    >>>Message-ID: <copu4m$3a2$>
    >>>Reply-To: "Mickael JOUVIN" <>
    >>>NNTP-Posting-Host: agri-bord.rain.fr
    >>>X-Trace: s5.feed.news.oleane.net 1102085078 3394 81.80.110.184 (3 Dec

    2004
    >> 14:44:38 GMT)
    >>>X-Complaints-To:
    >>>NNTP-Posting-Date: Fri, 3 Dec 2004 14:44:38 +0000 (UTC)
    >>>X-Priority: 3
    >>>X-MSMail-Priority: Normal
    >>>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
    >>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
    >>>Path:

    >>

    cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!new
    >>

    sfeed1.ip.tiscali.net!proxad.net!proxad.net!oleane.net!oleane!not-for-mail
    >>>Xref: cpmsftngxa10.phx.gbl

    >> microsoft.public.dotnet.framework.aspnet.webservices:27019
    >>>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservices
    >>>
    >>>Hello,
    >>>I would like to know what is the ASP command which returns the number of
    >>>record after a SQL request ?
    >>>Regards,
    >>>
    >>>Mickaël.
    >>>
    >>>
    >>>

    >>

    >
    >
    >
    Dan Rogers, Dec 4, 2004
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Lucas Cowald
    Replies:
    4
    Views:
    1,049
    Tohid
    Oct 23, 2003
  2. Lucas Cowald

    RUN/execute a Command-Line command from an ASP page

    Lucas Cowald, Oct 22, 2003, in forum: ASP .Net Building Controls
    Replies:
    1
    Views:
    233
    Genich
    Oct 22, 2003
  3. Lucas Cowald

    RUN/execute a Command-Line command from an ASP page.

    Lucas Cowald, Oct 22, 2003, in forum: ASP .Net Datagrid Control
    Replies:
    1
    Views:
    199
    Oliver
    Oct 22, 2003
  4. Lucas Cowald

    RUN/execute a Command-Line command from an ASP page.

    Lucas Cowald, Oct 22, 2003, in forum: ASP .Net Mobile
    Replies:
    0
    Views:
    174
    Lucas Cowald
    Oct 22, 2003
  5. Lucas Cowald

    RUN/execute a Command-Line command from an ASP page.

    Lucas Cowald, Oct 22, 2003, in forum: ASP .Net Security
    Replies:
    0
    Views:
    232
    Lucas Cowald
    Oct 22, 2003
Loading...

Share This Page