how do i write a query in coldfusion?

**gogbpackrs2** · 03-19-2007, 12:10 PM

**cyrus** · 04-24-2007, 08:29 AM

The following steps would help you to search and display the query results:
Create a Cold Fusion page with the following content:
<html>
<head>
<title>Searching a collection</title>
</head>
<body>

<h2>Searching a collection</h2>

<form method="post" action="collection_db_results.cfm">
<p>Collection name: <input type="text" name="collname" size="30"
maxLength="30"></p>

<p>Enter search term(s) in the box below. You can use AND, OR, NOT,
and parentheses. Surround an exact phrase with quotation marks.</p>
<p><input type="text" name="criteria" size="50" maxLength="50">
</p>
<p><input type="submit" value="Search"></p>
</form>

</body>
</html>

Save the file as collection_db_search_form.cfm in the myapps directory under the web_root.
This file is similar to collection_search_form.cfm, except the form uses collection_db_results.cfm, which you create in the next step, as its action page.

Create another Cold Fusion page with the following content:
<html>
<head>
<title>Search Results</title>
</head>

<body>

<cfsearch
collection="#Form.collname#"
name="getEmps"
criteria="#Form.Criteria#"
maxrows = "100">


<cfoutput>
Your search returned #getEmps.RecordCount# file(s).
</cfoutput>

<cfoutput query="getEmps">
<p><table>
<tr><td>Title: </td><td>#Title#</td></tr>
<tr><td>Score: </td><td>#Score#</td></tr>
<tr><td>Key: </td><td>#Key#</td></tr>
<tr><td>Summary: </td><td>#Summary#</td></tr>
<tr><td>Custom 1:</td><td>#Custom1#</td></tr>
<tr><td>Column list: </td><td>#ColumnList#</td></tr>
</table></p>

</cfoutput>
</body>
</html>

Save the file as collection_db_results.cfm in the myapps directory under the web_root.
View collection_db_search_form.cfm in the web browser and enter the name of the collection and search terms.

**rameshuddaraju** · 05-21-2007, 10:47 AM

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>

how do i write a query in coldfusion?

Thread Tools

Search Thread

how do i write a query in coldfusion?

Writing a query in ColdFusion

Share

Connect

Exforsys e-Newsletter

Subscribe and Get Free Bonus PDF Book

Network Security Risk Assessment and Measurement