Support Requests item #440262, was opened at 2001-07-10 19:19
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=203152&aid=440262&group_id=3152
Category: Scripting: Tcl/ADP
Group: aolserver3_4
>Status: Closed
Priority: 5
Submitted By: Tyge Cawthon (tyge)
Assigned to: Nobody/Anonymous (nobody)
Summary: Using the ns_table and ns_column
Initial Comment:
O/S FreeBSD 4.3-stable
DataBase postgreSQL 7.0.2
AOLServer 3.4
Need information about how to use the ns_table and
ns_column command. Documentation AOL 3.0 states it is
not supported. However, I found documentation (date
2000) that it is but I can not find information on how
it is used.
I would like to print out the column names of a table
with the data.
In the example I am using the statement is
set tinfo [ns_table info $db $table]
The error is:
unknown command "info": should be bestrowid, exists,
list, listall, or value
while executing
"ns_table info $db $table"
Using a different ADP file, I can see the data so I
know the communications between AOL and the DataBase is
good.
Thanks.
----------------------------------------------------------------------
Comment By: Tyge Cawthon (tyge)
Date: 2001-07-27 06:05
Message:
Logged In: YES
user_id=217624
Dossy and Petej,
Thanks for your suggestions. I will not be able to test
this for about two weeks. Lets close the ticket for now.
If I have problems, I will reopen it. Once again thanks.
----------------------------------------------------------------------
Comment By: Dossy Shiobara (dossy)
Date: 2001-07-27 03:13
Message:
Logged In: YES
user_id=21885
Tyge,
Did petej's solution work for you? Can this ticket be
closed?
-- Dossy
----------------------------------------------------------------------
Comment By: Peter M. Jansson (petej)
Date: 2001-07-11 07:30
Message:
Logged In: YES
user_id=20577
ns_table and ns_column are deprecated. If you need the
names of the columns in a table, a good portable way to do
this is to do a "select * from sometable where 0=1", which
will return an empty set, but you can obtain the column
names returned in the ns_set (from "ns_db bindrow...").
This should work in any database.
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=203152&aid=440262&group_id=3152