RE: Thanks everyone but one last question

2001-03-19 Thread Tony Gruen
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 M

RE: Thanks everyone but one last question

2001-03-19 Thread BORKMAN Lee
Do you really want to see what's in row 2, column 2, or do you want to see what ID(3)'s First Name is? That seems much more useful. To do that you just use SELECT FirstName from TableName WHERE ID = 3 #test.firstname# If you really want to access fields by row and column nu

RE: Thanks everyone but one last question

2001-03-19 Thread Bryan Love
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]