Take the current date.
Subtract 12 months from it
Select all records that are greater than the result
Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517
-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30
Can CF use Java the way it can with Jrun with other application servers?
Brandon
Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:44 AM
To: CF-Talk
Does anyone know of any issues with Cold Fusion and connecting to a
relational database. Also, the situation is not a direct connection, they
go out over the internet.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
#Evaluate("myview.#myvariable#")#
-Original Message-
From: Laszlo Nadai [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 23, 2000 8:19 PM
To: CF-Talk
Subject: nested # problem
I have a query:
SELECT * FROM mytable
Now I would like to let's say myview.city, or my
myview.stat
you can't put cfm commands on the cferror page, but you can set the error
page to submit a form when it loads...
post the form to another page that has your cfmail and whatever error
message you wish to display.