here is my coding. Actually i want to write a coding including the [<cfset
Howmanyhour = Abs(DateDiff("H",now(),getlogin_ready))>
<cfif Howmanyhour LT "24">] in my sql so that i can output the records in
the cfmail without the cfset and cfif statement. Can anyone please help
me. I really needed it..
regards
my coding
-------------
<cfquery name="GetRecordCollected" datasource="clientmaster"
dbtype="ODBC">
Select *
from user_info
where getlogin_ready <> '1' OR getlogin_ready <> '0'
</cfquery>
<cfmail to="[EMAIL PROTECTED]" from="[EMAIL PROTECTED]"
subject="Collection New web userid and Password">
Collected
----------------------------------------------------------------------------------------
<cfloop query="GetRecordCollected">
<cfset Howmanyhour = Abs(DateDiff("H",now(),getlogin_ready))>
<cfif Howmanyhour LT "24">
MY OUTPUT
</cfif>
</cfloop>
</cfmail>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
