Hey Chris, are you the developer of fodor's or do you guys have a massive team? cool site! I own Pubcrawler.com which does similar community and rating stuff, but for beer bars, breweries, etc. Been around since 1995. I have traffic and ideally folks that want more than just beer.... I am interested in talking to someone about doing some potential cooperative exchange of traffic... I also have massive photos and resources for the establishments here in Pittsburgh metro area... Appreciate any recommendations you have. -paris Paris Lundis 412-288-9901 x1038(Office) 412-292-3135 (Cellular) [finding the future in the past, passing the future in the present] [connecting people, places and things] -----Original Message----- From: "Gilbert, Chris" <[EMAIL PROTECTED]> Date: Fri, 15 Jun 2001 12:03:41 -0400 Subject: RE: What's wrong? (urgent) > 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
