I guess I was unclear. Let's suppose I have no interest in a specific value
like ID=3 but just want to know what is in a particular row and column. Am I
always stuck using a where statement having to look for a particular value?
I understand that a where statement can locate an instance of some
particular. I would just like to do a search on a row and a column in
general.
greg
-----Original Message-----
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 9:20 PM
To: CF-Talk
Subject: RE: Thanks everyone but one last question
You can create whatever WHERE statement you wish to select whatever rows you
need from the DB
to get row 2, column 2:
SELECT password
FROM table
WHERE ID = 3
Bryan Love ACP
Internet Application Developer
[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
