Not sure why you are getting that error, but there are a few things I will
ask why? Mainly for others who might be newer to ColdFusion and reading
this.
This
<cfif fix_this.recordcount gt 0>
Can be written
<cfif fix_this.recordcount>
Any number above zero will always return true.
Also this
<cfoutput query="fix_this">
You are not actually outputting anything, so why are you not using a cfloop?
And lastly, I think you might need to upgrade to CF9.01 with all the latest
hotfixes just in case your issue was fixed in the 9.01 or the patch just
after the 9.01 was released.
Regards,
Andrew Scott
http://www.andyscott.id.au/
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Scott Thornton
Sent: Friday, 1 October 2010 9:36 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in
query
Hi,
Running across a odd problem in CF 9,0,0,251028. development server.
I was just running a process that usually works and has not been modified
for quite a long time. part of that process runs a query and then loops over
the result set. Simple enough. however the query does not seem to exist
after it has run.
eg: The following code returns Element RECORDCOUNT is undefined in FIX_THIS.
<cfquery datasource="#DSN#" name="fix_this">
select sb_invoice.sb_invoice_id,
sb_invoice.sb_reminder_date, max(sb_claim_date) as sb_claim_date
from sb_invoice
inner join sb_invoice_item
on sb_invoice.sb_invoice_id = sb_invoice_item.sb_invoice_id
inner join sb_item_claim
on sb_invoice_item.sb_invoice_item_id =
sb_item_claim.sb_invoice_item_id
where sb_invoice.sb_bill_mech_code in
('M','F','AG','SC','MB','MO')
and sb_invoice_item.sb_item_status_code in ('21','24','31')
group by sb_invoice.sb_invoice_id,
sb_invoice.sb_reminder_date
having sb_invoice.sb_reminder_date <
DateAdd(d,30,max(sb_claim_date))
</cfquery>
<cfif fix_this.recordcount gt 0>
<cfoutput query="fix_this">
<cfquery name="upd_fund_reminder"
datasource="#DSN#">
update sb_invoice
set sb_reminder_date =
<cfqueryparam cfsqltype="cf_sql_varchar"
value="#DateFormat(DateAdd("d",31,fix_this.sb_claim_date),"dd-mmm-yyyy")#">
where sb_invoice_id =
<cfqueryparam cfsqltype="cf_sql_numeric" value="#fix_this.sb_invoice_id#">
</cfquery>
</cfoutput>
</cfif>
I have changed the name of the query to a few different values, I have used
cfloop instead of cfoutput, I added the cfif.recordcount to see if that
helped, to no avail. Without the CFIF the error was :
Attribute validation error for tag cfoutput.
The value of the attribute query, which is currently fix_this, is invalid.
Debug output shows that the query executed in 922ms and returned no rows.
What am I missing?
--
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.
--
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.
