[rameshuddaraju]

Originally Posted by gogbpackrs2

how do i write a query in coldfusion?

By using coldfusion cfquery

Example

Your_DataSourceName : DSn name we created in Coldfusion server. which refers to your database.


<cfquery name="AnyName" datasource="Your_DataSourceName">

select empno,ename,sal from employee

</cfquery>

To display data from the above query

<table>
<cfoutput query="AnyName">

<tr><td> #empno# </td><td>#ename#</td><td>#sal#</td></tr>

</cfoutput>

</table>