Hi Mike,
>Here's the template segment that produces this error:
>
><!--- Detect if the user has voted already today ---->
><CFQUERY NAME="testvoter" DATASOURCE="Calculators">
>SELECT
>max(whenvotes) as latestvote
>FROM poll_merger_1
>Where remote_addr='#remote_addr#'
></CFQUERY>
>
><!--- Test for did/didn't vote already --->
><!--- no records indicates hasn't voted yet. --->
> <cfif testvoter.recordcount eq '0'>
> <cfset dovote="yes">
> <Cfelseif #testvoter.recordcount# GT '0'>
One problem is that you can't do an recordcount type of test when using an
aggregate function like MAX() you will get a recordcount gt 0 almost
always. You might be better off testing for a null date entry or something
like that.
--
Yours,
Kym
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
