This code works fine with a access database, since converting the entire cf
application to a live SQL database it has been the beginning of a
nightmare. I'm not real familiar with access but it seems they have some
really strange ways to check dates and whatnot.
<table class="rightMenu">
<tr>
<td class="rightMenu"
style="text-align: left;"><br><br>
<cfset theMonth =
datePart("m", now())>
<cfset theYear =
datePart("yyyy", now())>
<cfquery
name="getMonthlyPurchase" datasource="#DS#"
cachedwithin="#CreateTimeSpan(0,4,35,0)#">
SELECT
Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase
FROM tblItemPurchase
WHERE
tblItemPurchase.itemPurchaseDate >= ###theMonth#/1/#theYear###
</cfquery>
<cfset theGoal = 175000>
<cfif
getMonthlyPurchase.recordCount neq 0 and getMonthlyPurchase.recordCount neq
"" and getMonthlyPurchase.totalMonthlyPurchase neq "">
<cfset amountLeft
= theGoal - getMonthlyPurchase.totalMonthlyPurchase>
<cfelse>
<cfset amountLeft
= theGoal>
</cfif>
<p><table
width="100%"><tr><td bgcolor="#CCCCCC" style="font-size: 18px; font-weight:
bold; text-align: center; padding: 2 3 2 3; border-right: black 1px solid;
border-bottom:black 1px solid;">GOALS</td></tr></table>
<table
style="width:100%; "><tr><td style="border: dashed gray 1px; padding: 2 3 2
3; font-size: 12px; width:100%;">
<strong>THIS
MONTH:</strong>
<table
bgcolor="#B9E1F4" width="100%">
<tr>
<td
style="width:100%; ">
<span
class="voTitle">GOAL:<cfoutput>#DollarFormat(theGoal)#</cfoutput>.</span><span
style="font-size: 2px;"><br><br></span>
<span
style="font-size: 10px; font-weight: bold;"><strong>SO
FAR:<cfoutput>#DollarFormat(getMonthlyPurchase.totalMonthlyPurchase)#</cfoutput></strong></span><span
style="font-size: 2px;"><br><br></span>
<span
class="adminTitle">TO
GO:<cfoutput>#DollarFormat(amountLeft)#</cfoutput></span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td
style="font-size: 2px;"> </td>
</tr>
</table>
If anyone can point me in the right direction or where to look for the
needed information about converting a access based site to sql.
Thanx
Web Your Business Inc., - located in Loveland, Colorado; serving the World!
http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/
Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187067
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
