<div>
I don't believe Coldfusion is much more than an interface to a database. &nbsp;It only remembers/tracks what you tell it to.<br />
<br />
Unless you return the value from the database, I don;t think it has any 'smarts' built in.<br />
<br />
An example:<br />
Oracle has a 'returning' clause hat allows you to return specific values from DML. &nbsp;If the app coded the DML to take advantage of the returning clause and handled the return values properly, then yes.<br />
<br />
If not, I'm afraid you might be out of luck.<br />
<br />
Then again, I'm not a Coldfusion expert...
</div>


I don't believe Coldfusion is much more than an interface to a database.  It only remembers/tracks what you tell it to.

Unless you return the value from the database, I don;t think it has any 'smarts' built in.

An example:
Oracle has a 'returning' clause hat allows you to return specific values from DML.  If the app coded the DML to take advantage of the returning clause and handled the return values properly, then yes.

If not, I'm afraid you might be out of luck.

Then again, I'm not a Coldfusion expert...

<div>
<div class="content wysiwyg-content">
Is there any function in coldfusion, i want last inserted value from database.<br />
if there is no function so what is the right way to do it.<br />
<br />
database could be oracle or MSSQL<br />
<br />
Thank you.....
</div>
</div>


Is there any function in coldfusion, i want last inserted value from database.
if there is no function so what is the right way to do it.

database could be oracle or MSSQL

Thank you.....

Coldfusion Last Inserted value in database

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.