brain fartage....never had to make this work...
i only want to select the bottom most ten records
based on a primary key ID field.....
<cfquery name="getWriter" datasource="survivorsmiles">
select TOP 10 (ID), firstname, lastname, email
from reg
where id = #getStories.writer_Id#
order by ID
asc
</cfquery>
aint cuttin it? why...cause it doesnt make any sense....just trying to
give you an idea of the field i need and hoping that somehow i can do
this :)
please help.
thanks
...tony
tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
