At 06:14 PM 03/10/2001 +0000, you wrote:
> > Allow me to modify my previous post then...
> >
> > <CFPARAM lownum = 0>
> > <CFQUERY>
> > select top 20 * from mytable
> > where mytableID > #lownum#
> > </CFQUERY>
> > <CFSET highID = lownum>
> > <CFOUTPUT query=myquery>
> > <CFSET highID = myquery.mytableID>
> > </CFOUTPUT>
> >
> > <FORM blahblahblah>
> > <INPUT type="hidden" name="lownum" value=#highID#>
> > </FORM>
>
>OK, modifying what Jeffry's done;
><CFSET highID = myquery.mytableID[myquery.RecordCount]>
>
>And get rid of that CFOutput loop
Oh, good point... I was (of course) assuming that other processing was
going on in the CFOUTPUT loop. But, if there isn't that's a much better
way to do it.
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
The best advice I can give you is to ignore everything I say
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
