simple cfquery question - amateur level

Hello all,

making some simple changes to my website

there is already a database running with plenty of cfloop query

question is this:

this code below retrieves the cake name (#cake_name#) for row 1 in the database, but its using a loop

<cfloop query="cake_query" STARTROW="1" ENDROW="1">

#cake_name#

</cfloop>

how do i do this without using a loop?

i thought it ould be as simple as this:

<cfquery="cake_query" ROW="1">

</cfquery>

but apparently not...

also at the top of the code, there is already this code below, which i know works with the loop queries, im assuming i dont need to change for single row queries?

<cfquery name="cake_query" datasource="#request.datasource#"
username="#request.username#" password="#request.password#">
SELECT * FROM gce_cakes where cake_active = 1 ORDER BY cake_number
</cfquery>

Thank you in advance to anyone that can help