never mind, i knew it.
select cont(*) as blah
Thanks for all answers, i love you all. :D
>From: "Redd Liao" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Server <[EMAIL PROTECTED]>
>Subject: RE: What's wrong? (urgent)
>Date: Fri, 15 Jun 2001 12:36:28 -0400
>
>if i use count(*), how can i output the number?
>thanks
>
>
> >From: "Gilbert, Chris" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Server <[EMAIL PROTECTED]>
> >Subject: RE: What's wrong? (urgent)
> >Date: Fri, 15 Jun 2001 12:03:41 -0400
> >
> >Actually, now that I think about it for more than 5 seconds (*grin*) if
>all
> >you really want is the recordcount, you should just let the Database do
>the
> >counting rather than making it fetch all the rows, send them to CF, and
> >then
> >making CF count the rows. If you *really* don't need the data, then try
> >this:
> >
> >SELECT count(*) FROM job
> >where cyv_id = '#FORM.cyv_id#' and job_close is null
> >
> >-Chris Gilbert, Fodors.com
> >
> >-----Original Message-----
> >From: Redd Liao [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, June 15, 2001 12:05 PM
> >To: CF-Server
> >Subject: What's wrong? (urgent)
> >
> >
> >I use MS SQL and CF 4.5.
> >
> ><cfquery name="works" datasource="project" dbtype="ODBC">
> >SELECT * FROM job
> >where cyv_id = '#FORM.cyv_id#' and job_close = ''
> ></cfquery>
> >
> >I wanna get works.recordcount in which job_close is null,
> >but i always get 0. Is there anything wrong in cfquery?
> >Thanks.
> >
> >R
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
