help on rebol-cmd ODBC getting fieldnames
[1/6] from: sags::apollo::lv at: 8-Oct-2005 18:32
Hi, Rebolers!
I was unable to google the subj.
;-)
Could somebody please help me with an advice?
In php I like better to work with associative arrays
and I want to do something similar in Rebol.
brgds
Janeks
[2/6] from: lmecir:mbox:vol:cz at: 7-Oct-2005 17:57
[sags--apollo--lv] napsal(a):
>Hi, Rebolers!
> I was unable to google the subj.
<<quoted lines omitted: 4>>
>brgds
>Janeks
http://www.compkarori.com/vanilla/display/aa.r
-L
[3/6] from: sags::apollo::lv at: 12-Oct-2005 22:39
To be more exact I need to get field/column names from a query.
In http://www.rebol.com/docs/database.html#section-4 there are
described getting of field/column names from a table - but I need
from query.
At least for MS-SQL it did not work.
Any hints?
Janeks
On 8 Oct 2005 at 18:32, [sags--apollo--lv] wrote:
[4/6] from: SunandaDH::aol::com at: 13-Oct-2005 3:16
Janeks:
> At least for MS-SQL it did not work.
> Any hints?
As it says, it is a database specific method.
Take a look at the message here (and the next one that adds a correction):
http://forums.mysql.com/read.php?108,33446,34909#msg-34909
I don't use MySQL myself so I can't say if it works, but it looks plausible,
Sunanda
[5/6] from: mike::yaunish::shaw::ca at: 13-Oct-2005 9:44
In MySQL I use the query "SHOW COLUMNS FROM <tablename>"
Mike
[6/6] from: sags::apollo::lv at: 15-Oct-2005 23:42
It is not problem to get field names from a table.
And it if its not possible to do directly in Rebol than it is
possibel in SQL.
The problem in details:
Example a query:
select t1.fld1 "name", t1.fld3 "param1", t2.fld1 "param2"
from t1, t2
where t1.fld1 = t2.fld2
How to get in Rebol a block or object of the query above field
names f.ex. like this:
[ "name" "param1" "param2" ]
Thanks in advance,
Janeks
On 13 Oct 2005 at 9:44, Mike Yaunish wrote:
Notes
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted