Google Answers Logo
View Question
 
Q: Getting a list of row names in a table (SQL) ( Answered 1 out of 5 stars,   1 Comment )
Question  
Subject: Getting a list of row names in a table (SQL)
Category: Computers > Programming
Asked by: wassini-ga
List Price: $10.00
Posted: 04 Aug 2002 09:30 PDT
Expires: 03 Sep 2002 09:30 PDT
Question ID: 50468
I'm trying to write a webinterface (ASP) to administer all my
databases (Access) on differents sites. So far I can select the
differents databases and get a list of tables in each database (SELECT
Name from MsysObjects...), but how do I get a list of row names in a
table? (Not the data!)
Answer  
Subject: Re: Getting a list of row names in a table (SQL)
Answered By: brad-ga on 04 Aug 2002 10:01 PDT
Rated:1 out of 5 stars
 
Given: you have a table: Table1 in a database: Database1.

To get the row names in that table, your select statement would be:
"Select rowid from Table1"

This would return all the row id's.
***********************
If you do not want every column in that table, you would select only
those that you wish:
"Select rowid, Name,Address,City from Table1"
************************
"Is there a way to access a row id? I have a customer who stores in
one file the row id# that they use in a relative file. They would like
to query their relative file by accessing this known row id...do you
know of a way in the current driver. Is there a call they could be
doing like %rowid????

Just use the ROWID pseudo-column name in your SQL statements"
http://www.trifox.com/faq/genesis.html
*********************************************
wassini-ga rated this answer:1 out of 5 stars
Using "Select rowid from Table1" just returns "No value given for one
or more required parameters." - Seems like the interpreter thinks that
rowid is a rowname.

j_philipp-ga actually gave me the "sollution" when I just found the
right words to search for on google:
http://www.pscode.com/xq/ASP/txtCodeId.7521/lngWid.4/qx/vb/scripts/ShowCode.htm

Comments  
Subject: Re: Getting a list of row names in a table (SQL)
From: j_philipp-ga on 04 Aug 2002 09:42 PDT
 
There is some information at Google using search terms like:
"getting column name" asp sql
"get column name" asp access
"retrieve column name"

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy