I have a huge Sales Application 99.99% completed and
after hours of attempts. I'm stumped on the last part!
Please send any help/advice. Thanks.
I'm trying to extract values from a query from within a
Custom Tag. I can get a record count value, but not a
needed date column/value. Argh! Here's what I have ...
***IN THE CUSTOM TAG**********
SET THE VARIABLE FOR THE QUERY
<cfset Variables.Query = "Caller." & Attributes.Query>
THIS EXPERSSION PARSES CORRECTLY AND RETURNS THE RECORD
COUNT OF THE QUERY THAT IS PASSED TO THE CUSTOM TAG
#Evaluate(Variables.Query & ".recordcount")#
NOW I NEED TO EVALUATE A COLUMN'S VALUE WITHIN THE QUERY
USING DATEDIFF. I'M UNABLE TO PROCESS WITH THE
srf_q1_date COLUMN NAME. WHEN I HARD CODE THE DATE,
WITH A DATE/TIME STAMP VALUE, IT WORKS.
DOESN'T WORK
<cfoutput query="#Variables.Query#">
<CFSET qdif = #datediff("q", srf_q1_date, now())#>
</cfoutput>
WORKS
<CFSET qdif = #datediff("q", "2/15/2002 12:00:00 PM", now
())#>
***********END***CUSTOM***TAG*****
****CUSTOM***TAG***REFERENCE**SYNTAX****
<cf_excel_2 Query="standard_market_ALL"
Columns="srf_companyname|srf_approv_eng|srf_sales|srf_cou
ntry|srf_contact|srf_email|srf_projname|srf_frn_pn|srf_to
tal_qnty|srf_sell_price|srf_prob|srf_q1_qnty|srf_q2_qnty|
srf_q3_qnty|srf_q4_qnty|srf_q5_qnty|srf_q6_qnty|srf_date_
created|srf_date_approv|srfor_date_entered|srfor_date_upd
ated" HeaderTitles="COMPANY NAME|MARKET SALES
ENG|FORECAST SALES ENG|COUNTRY|CUSTOMER CONTACT|CUSTOMER
EMAIL|PROJECT NAME|FORECASTED PN|TOTAL UNITS|SELL
PRICE|PROBABILTY|AMT Q1 2002|AMT Q2 2002|AMT Q3 2002|AMT
Q4 2002|AMT Q1 2003|AMT Q2 2003|DATE SAMPLE
REQUESTED|DATE SAMPLE APPROVED|DATE WIN FORECASTED|DATE
FORECAST UPDATED" FileName="Steve.xls"
AlternateRowColor="silver" Title="Company Forecast Wins
by Company" NoDataMessage="There was no data returned."
Border="yes">
****CUSTOM***TAG***REFERENCE******
THANKS
D-
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
