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
>Hi, Rebolers! > I was unable to google the subj.
<<quoted lines omitted: 4>>>brgds >Janeks
[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
> 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:
- Quoted lines have been omitted from some messages.
View the message alone to see the lines that have been omitted