dbTalk Databases Forums  

Get Column Name

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Get Column Name in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eddie
 
Posts: n/a

Default Get Column Name - 10-11-2007 , 11:41 AM






I'm running a PHP call to MS SQL to automatically look in sysbojects
and syscolumns to get each table name in realtime so I can make a list
and execute it. That part's fine. I'm having problems though getting
the name of the first column, so we can use that as the default sort.
Can anybody help? Thanks.


Reply With Quote
  #2  
Old   
MC
 
Posts: n/a

Default Re: Get Column Name - 10-11-2007 , 01:59 PM






What do you mean by first column? You can use columnID = 1 if you want the
first column in a table, but shouldnt you use something like first column in
grid or something like that?

MC


"Eddie" <eddieandrews (AT) gmail (DOT) com> wrote

Quote:
I'm running a PHP call to MS SQL to automatically look in sysbojects
and syscolumns to get each table name in realtime so I can make a list
and execute it. That part's fine. I'm having problems though getting
the name of the first column, so we can use that as the default sort.
Can anybody help? Thanks.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.