Greg,
If you know a piece to key from you can get any piece you want. For example,
if you know the ID you're looking for is 3, and you want the first name in
record 3, use:
select firstname
from [tablename]
where ID = 3
this query would return 'tom'
Tony Gruen
[EMAIL PROTECTED]
-----Original Message-----
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 6:02 PM
To: CF-Talk
Subject: Thanks everyone but one last question
Thanks for the help on my newbie question. I learned a great deal believe it
or not. You were all kind.
Now one last question before I go back to the books.
See the database setup below.
ID PASSWORD FIRSTNAME LASTNAME
4 sdf greg landry
3 gth tom jones
Lets say I wanted to see what is in the second record and see what's under
the column FIRSTNAME. What I am learning is that I have to print out the
entire database to see what is in it. I would just like to be able to know
how to access a particular element in a database. Like what's in row 2,
column 2?
Thank you so much for your patience and time.
Greg "the ever curious newbie"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
