No Repeat Region

why not just do it in the <cfoutput>

<cfoutput query="whatever" startrow="#recordcount# maxrows="1">
</cfoutput>

That will give you last record of query.

Thanks. The LIMIT 1 works fine if you put it on the very end. I put is
before the ORDER BY and it blew up.

A quick goggle looks like for MySql it is limit

SELECT *
FROM aTable
LIMIT 1

Here are other dbms versions that may also work.

--SQL:
TOP 3 * from mytable

--ACCESS:
select top 3 * from (select * from mytable)

--ORACLE:
ROWID <=3

Wally Kolcz wrote:
> Yeah, I am using MySQL 5
>
>

Yeah, I am using MySQL 5

So then you just want one record returned.

SELECT TOP 1 works for MS databases, I'm not sure for Oracle and mySQL
or others.

Wally Kolcz wrote:
> What do you put in a WHERE clause to get it to only show the newest result?
>
> The news is not time sensitive so I cannot compare it to anything. The
> client may only put one news update every 60 day or 6 years.
>
>

What do you put in a WHERE clause to get it to only show the newest result?

The news is not time sensitive so I cannot compare it to anything. The
client may only put one news update every 60 day or 6 years.

Nothing to do with being a component. Just put a where clause in your
query so that it only returns the one record you want to display.

If you want to to do both, then use <cfarguments...> to pass is a
parameter to dynamically determine when to return one record and when to
return many.

Wally Kolcz wrote:
> I am new to components. Here is what I have.
>
> <cfcomponent>
> <cffunction name="LatestNews" access="public" returntype="query">
> <cfquery name="news" datasource="#Request.MainDSN#">
> SELECT News_ID, Story,Date FROM ms411.news ORDER BY Date DESC
> </cfquery>
> <cfreturn news>
> </cffunction>
> </cfcomponent>
>
> How can I get that to show 1 result (the newest)?
>
>

I am new to components. Here is what I have.

<cfcomponent>
<cffunction name="LatestNews" access="public" returntype="query">
<cfquery name="news" datasource="#Request.MainDSN#">
SELECT News_ID, Story,Date FROM ms411.news ORDER BY Date DESC
</cfquery>
<cfreturn news>
</cffunction>
</cfcomponent>

How can I get that to show 1 result (the newest)?

If you have control over the cfc, enhance it so that it gives you what you need. Otherwise, do a query of queries on your return variable.

?? You lost me on that one ??

It pulls the correct record, but the code wants to create a repeat region
for all the records. i only want it to show the latest record since it is
pulling decendingly.

Did I miss something?