<div>
Though ID numbers can be recycled, so I usually prefer to order by a datetime stamp column.
</div>


Though ID numbers can be recycled, so I usually prefer to order by a datetime stamp column.

<div>
Thanks, I knew I was close but got too frustrated.
</div>


Thanks, I knew I was close but got too frustrated.

<div>
<div class="content wysiwyg-content">
This isn't too difficult but the syntax errors are bothersome. &nbsp;I am retrieving the latest record by ID but all the records are displaying.<br />
<br />
select * from #vTableName# ORDER BY ID desc<br />
<br />
I have tried TOP 1 and MAX but it won't make it through the syntax error. &nbsp;What would be the correct statement?<br />
<br />
Thanks,<br />
John<br />

</div>
</div>


This isn't too difficult but the syntax errors are bothersome.  I am retrieving the latest record by ID but all the records are displaying.

select * from #vTableName# ORDER BY ID desc

I have tried TOP 1 and MAX but it won't make it through the syntax error.  What would be the correct statement?

Thanks,
John


Coldfusion CS3 - Display most recent record

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.