|
|
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!) |
|
Subject:
Re: Getting a list of row names in a table (SQL)
Answered By: brad-ga on 04 Aug 2002 10:01 PDT Rated: |
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:
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 |
|
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" |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |