Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > ASP command

Reply
Thread Tools

ASP command

 
 
Mickael JOUVIN
Guest
Posts: n/a
 
      12-03-2004
Hello,
I would like to know what is the ASP command which returns the number of
record after a SQL request ?
Regards,

MickaŽl.


 
Reply With Quote
 
 
 
 
Dan Rogers
Guest
Posts: n/a
 
      12-03-2004
I believe the response object has a recordcount property on it.


--------------------
>From: "Mickael JOUVIN" <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
>Subject: ASP command
>Date: Fri, 3 Dec 2004 15:46:16 +0100
>Organization: CRAA
>Lines: 8
>Message-ID: <copu4m$3a2$(E-Mail Removed)>
>Reply-To: "Mickael JOUVIN" <(E-Mail Removed)>
>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: http://www.velocityreviews.com/forums/(E-Mail Removed)
>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.webservic es:27019
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>
>Hello,
>I would like to know what is the ASP command which returns the number of
>record after a SQL request ?
>Regards,
>
>MickaŽl.
>
>
>


 
Reply With Quote
 
 
 
 
Scott M.
Guest
Posts: n/a
 
      12-03-2004
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I believe the response object has a recordcount property on it.
>
>
> --------------------
>>From: "Mickael JOUVIN" <(E-Mail Removed)>
>>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
>>Subject: ASP command
>>Date: Fri, 3 Dec 2004 15:46:16 +0100
>>Organization: CRAA
>>Lines: 8
>>Message-ID: <copu4m$3a2$(E-Mail Removed)>
>>Reply-To: "Mickael JOUVIN" <(E-Mail Removed)>
>>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: (E-Mail Removed)
>>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.webservic es:27019
>>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>>
>>Hello,
>>I would like to know what is the ASP command which returns the number of
>>record after a SQL request ?
>>Regards,
>>
>>MickaŽl.
>>
>>
>>

>



 
Reply With Quote
 
Dan Rogers
Guest
Posts: n/a
 
      12-04-2004
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." <(E-Mail Removed)>
>References: <copu4m$3a2$(E-Mail Removed)>

<(E-Mail Removed)>
>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: <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
>NNTP-Posting-Host: 69.37.4.150.adsl.snet.net 69.37.4.150
>Path:

cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFT NGP08.phx.gbl!TK2MSFTNGP11
..phx.gbl
>Xref: cpmsftngxa10.phx.gbl

microsoft.public.dotnet.framework.aspnet.webservic es:27030
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>
>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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>>I believe the response object has a recordcount property on it.
>>
>>
>> --------------------
>>>From: "Mickael JOUVIN" <(E-Mail Removed)>
>>>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
>>>Subject: ASP command
>>>Date: Fri, 3 Dec 2004 15:46:16 +0100
>>>Organization: CRAA
>>>Lines: 8
>>>Message-ID: <copu4m$3a2$(E-Mail Removed)>
>>>Reply-To: "Mickael JOUVIN" <(E-Mail Removed)>
>>>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: (E-Mail Removed)
>>>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.webservic es:27019
>>>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>>>
>>>Hello,
>>>I would like to know what is the ASP command which returns the number of
>>>record after a SQL request ?
>>>Regards,
>>>
>>>MickaŽl.
>>>
>>>
>>>

>>

>
>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RUN/execute a Command-Line command from an ASP page. Lucas Cowald ASP .Net 4 10-23-2003 11:09 AM
RUN/execute a Command-Line command from an ASP page Lucas Cowald ASP .Net Building Controls 1 10-22-2003 04:26 PM
RUN/execute a Command-Line command from an ASP page. Lucas Cowald ASP .Net Datagrid Control 1 10-22-2003 12:22 PM
RUN/execute a Command-Line command from an ASP page. Lucas Cowald ASP .Net Security 0 10-22-2003 11:15 AM
RUN/execute a Command-Line command from an ASP page. Lucas Cowald ASP .Net Mobile 0 10-22-2003 11:15 AM



Advertisments