----- Original Message -----
Sent: Thursday, June 13, 2002 7:04
AM
Subject: RE: [CFTALKTor] Check Existing
Date in Database
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]
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
