Skip to main content
Inspiring
February 3, 2010
Question

retrieve 3 rows of data and put each row in different position on screen

  • February 3, 2010
  • 1 reply
  • 822 views

I need to retrieve 3 consecutive rows of data (easy) and need to put each row's data in an entirely different location on the home page

for example,

row 1 needs to go up in the top left content box

row 2 needs to go in the large content area in the middle of the page

row 3 needs to be put down in the footer of the page

what's the most efficient way to do this ?

This topic has been closed for replies.

1 reply

Inspiring
February 3, 2010

queryname.fieldname[rownumber]

Inspiring
February 3, 2010

care to elaborate ?

do you mean

<cfquery name="getData" datasource="foo">

  SELECT firstname,surname,age

  FROM pricelist

</cfquery>

<cfoutput>

     getData.surname(1)

<cfoutput>

Inspiring
February 15, 2010

What's happening that you don't like?


well for a start, it's outputting 27 items of data instead of 3