I was going through AdobeTV and can across a cool video I thought was worth sharing. It is on Flex 3 and ColdFusion Using VO's and CFC's. I recommend checking it out if you have an extra hour (53 min).
I was posed with the task of making little dashboards for various managers lately. One of the things that every dashboard needed was a date range that was dynamically driven through date pickers.
I first setup my coldfusion component .cfc to return a query. I then set up 2 date arguments to be used in my between statement to narrow my query results. An example function can be found below:
<cffunction name="dateRange" access="remote" returntype="query">
<cfargument name="DateField1" required="true" type="date">
<cfargument name="DateField2" required="true" type="date">
<cfquery name="revReport" datasource="dsnScoreCard">
SELECT column1, column2
FROM test
WHERE date1 BETWEEN CONVERT(VARCHAR(10), <cfqueryparam cfsqltype="cf_sql_date" value="#DateField1#">, 101) AND CONVERT(VARCHAR(10), <cfqueryparam cfsqltype="cf_sql_date" value="#DateField2#">, 101)
</cfquery>
<cfreturn revReport>
</cffunction>
I made a view on SQL SERVER 2005 that queries 2 databases. I then set up a datasource to the database that contains the view. The set up a coldfusion login specific to that database containing the view. When I try to RemoteObject the view in flex 3 I get an error stating that the cfc could not be invoked. Is this because the coldfusion login only has permission to one of the databases? Does anyone have any experience with this problem? Thanks in advance
PS I set up a view that queries only one database with the same datasource and it works no problem..
Here is my problem, we have a server that we opened for our customers to access via SSL. When we are internally connected via our network, the flex app works. However when I'm outside our network and try visiting the site we get a send fail error and it will not connect to our .cfc. Do you think there is something wrong with the server that needs to be fixed? Any troubleshooting methods you can pass to me?
I was posed with the problem of converting flex 3 datagrids from a dashboard to an excel sheet. I came across some really good blog posts that explain how to accomplish this task. The best one can be found here.
He has it set up in actionscript calling a .php page but I wanted to supply the simple ColdFusion code for us ColdFusion people. All you need to do is direct the actionscript to a coldfusion page containing the code below and it should work.
<cfcontent type=”application/msexcel”>
<cfheader name=”Content-Disposition” value=”filename=export.xls”>
<cfoutput>
#form.htmltable#
</cfoutput>
This little flex 3 script makes lots of managers very happy! My next adventure will be printing flex 3 datagrids and graphs into a nice looking report which seems to be posing a little challenge for me, the nice looking part that is ;)
This post will show you how to place dynamic data from a CFC and put it into a Flex Line Chart.
Flex application integrated with a database using a CFC. I’ll walk you through the steps to first get the data from the CFC and then to dump that data into a DataGrid.
Create a very simple cfc, which takes a last name from a database and returns the first name.
This may be old news to some but I just found out a really cool ColdFusion Component window in CFEclipse.
Recent Comments