Help. Handling Data.

[maasss18]

Assuming my table has a field called Name with two record called David and Alan. I can insert 1 record called Alex using .cfc approach.

.cfc Approach

<cffunction name="oCreate" access="public" output="false" returntype="void">
<cfargument name="aObjectTest" type="ModelDb" required="true" />

<!--- var scope everything! --->
<cfset var insertObject = "" />
<cfset var getObjectID = "" />

<cftry>
<cftransaction action="begin">
<cfquery name="insertObject" datasource="#variables.dsn#">
INSERT INTO Objects ( Name)
VALUES (
<cfqueryparam cfsqltype="cf_sql_varchar" value="#aObjectTest.getName()#" maxlength="40" null="no">
</cfquery>

<cfquery name="getObjectID" datasource="#variables.dsn#">
SELECT @@identity as newObjectID
</cfquery>

<cfscript>
aObjectTest.setObjectID(getObjectID.newObjectID) ;
</cfscript>

<cftransaction action="commit" />
</cftransaction>

<cfcatch type="database">
<cftransaction action="rollback" />
<cfthrow type="ModelDb.oCreate" message="#cfcatch.detail#" />
</cfcatch>
</cftry>
</cffunction>


I want to retrieve back all the records to display it in a comboBox using a .cfc aproach.

Currently i can only see the 2 records in the combobox, David and Alan using .cfm approach. I could not see Alex. Not sure if the table is refresh.

.cfm Approach to retrieve all the records

<cfprocessingdirective suppresswhitespace="yes" pageencoding="utf-8">

<cfquery name="getObjToVar" datasource="testdb3">
SELECT Name FROM Objects
</cfquery>

<cfxml variable="dataXML">
<posters>

<cfloop query="getObjToVar">
<pos>
<cfoutput>#Name#</cfoutput>
</pos>
</cfloop>

</posters>
</cfxml>

<cfoutput>#dataXML#</cfoutput>
</cfprocessingdirective>


HTTPService in .mxml application

<!-- Setup the connection to the Coldfusion CFM - Data.cfm -->
<mx:HTTPService id="dataRequest" resultFormat="e4x" method="POST"
url="http://localhost:8500/Wimeals/src/Database/Data.cfm">
</mx:HTTPService>


ComboBox code

<mx:ComboBox id="cBoxObject" dataProvider="{dataRequest.lastResult.pos}" change="{getImagePath()}" / >



Does .cfc allow us to retrieve a set of records inclusive of the latest inserted records?

[solisarg]

To use an HTTPService you should call somewhere. Once you update the table, you should call it again (probably adding some random in the URL to avoid cache)