But most databases support LIMIT 1 Which is even more efficient, because then the database engine stops working once it finds one record (assuming you have no order by clause).
And hence only 1 record gets passed through the ODBC channel to CF, hence more efficient then CF throwing away the last n-1 rows. (If in fact that's what it does) Terry Fielder Network Engineer Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of [EMAIL PROTECTED] > Sent: Thursday, June 13, 2002 11:33 AM > To: [EMAIL PROTECTED] > Subject: RE: [CFTALKTor] Check Existing Date in Database > > > > this may also be useful to someone, > > re Terry's > <cfif myQuery.yourCountField_or_recordCount> to test for true/false > > > in the cfquery I add maxrows=1, thats all I need for a true condition, > doesn't matter if 1 or more rows are returned, its still > true. But I don't > know how efficient or inefficient maxrows is, I'm guessing its more > efficeint to get one record from the db than say 50 or 500 etc. > > -steve > > > > > > > > terry@greatgulfh > > omes.com To: > [EMAIL PROTECTED] > Sent by: cc: > > owner-cfug@cfugt Subject: RE: > [CFTALKTor] Check Existing Date in > oronto.org Database > > > > > > 06/13/02 07:04 > > AM > > Please respond > > to CFTALK > > > > > > > > > > When you try to compare something, you need to compare like > data types. > This may be why your database is never finding that date in > there already. > Try something like this: > > SELECT count(dateofpayment) AS rownum > FROM table > WHERE dateofpayment = #CreateODBCDate(form.dateofpayment)# > > > Furthermore, if you have a variables.rownum defined for > whatever reason, I > believe CF will use that first, so don't do this: > > > <cfif rownum gte 1> <!---(which could be equivalent to > variables.rownum) > ---> > > Do this: > > <cfif myquery.rownum GTE 1> > > And in fact because Count() guarantees to return an integer > >= 0, to be > more efficient do this: > <cfif myquery.rownum> > <!--- 1 or more records found, so date already exists ---> > > > > > > Terry Fielder > Network Engineer > Great Gulf Homes / Ashton Woods Homes > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Thursday, June 13, 2002 5:42 AM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Check Existing Date in Database Hello All, I am having a little trouble checking for an existing date. I have a form that passes a date from calendar that I am using. The calendar outputs the date as follows 6/13/2002. So I have a few fields that I insert into the database along with that date. There can only be one record per day. I try to do a row count in the database before my insert statement to check if there is a row with that date value but I keep getting 0 The field that is passed from the form is dateofpayment and the field in the Access database is also dateofpayment So I do select count(dateofpayment) as rownum form table where dateofpayment = #form.dateofpayment# I have manually entered the data in the table so there is already that date it should give me a record count of greater than one. So I attempt to do a <cfif rownum gte 1> Go back to change the date </cfif> But this is not working. Does anyone have a better way to see if the date already exists with Access or can tell where my logic is flawed? Thanks in Advance Mike - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
