This might work (or it might not).
select count(dateofpayment) as rownum from table where dateofpayment = #createodbcdate(form.dateofpayment)# But, it is worth a try ******************************************* 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> - 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)
