> record's row number? I've tried
>
> foo[1].Title
>
> to get the Title field in row 1 of my query named foo, but I
> get this error
>
> [Table (rows 1 columns TITLE): [TITLE:
> [EMAIL PROTECTED] ] is not indexable by 1
>
> I know I can loop through the query results with <cfloop> and
> set a start and an end record, and I can make that work for
> what I'm doing, but it would be a pain.
Assuming your query is named "foo" and the column you want is called
"Title", you could do it like this:
Foo.Title[1]
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
