Inspired by Ray Camden's Harlan ad server's interfaces (they're simple
but effective), I've decided to venture into the world of MX7's Flash
forms. First up is trying to display some tabular data using
CFGRID...problem is, I can't get my data to display in the grid...the
headers are displaying as they should, but no data. CFDUMP shows all
the data is there, and I know that CFGRID is working on some other
projects of mine since I have Harlan up and running locally.
Anyway, here's my code...am I doing something wrong?
<cfoutput>
<cfparam name="contactid" default="#SESSION.userid#">
<cfquery name="getRecent" datasource="#request.app.dsname#">
SELECT DISTINCT TOP 20 DC.ID AS datacardid, DC.Name, DC.updated
FROM tblDataCardNotes DCN, tblDataCards DC
WHERE DCN.datacardid =DC.id AND
DCN.contactid = <cfqueryparam
cfsqltype="CF_SQL_INTEGER"
value="#contactid#">
ORDER BY DC.updated DESC
</cfquery>
<cfdump var="#getrecent#">
<h2>Your Recent Datacards</h2>
<cfform action="#CGI.script_name#" method="POST" name="recent"
height="230" width="750" format="Flash" timeout="30" skin="haloBlue">
<cfgrid name="foo" format="FLASH" height="200" width="750"
query="getRecent" colheaders="Yes" enabled="Yes"
visible="Yes"></cfgrid>
</cfform>
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231339
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
