[plt-scheme] how to find column names through sqli?

From: Hans Oesterholt-Dijkema (hdnews at gawab.com)
Date: Wed Apr 11 16:39:00 EDT 2007

Yes, It is possible, I know. I'd be happy to provide the feature,
but at the moment (till somewhere june), I'm too busy. If you
want to contribute yourself, please do so. Code is available via
CVS or SVN at schematics.sf.net.

--Hans


Yin-So Chen schreef:
> Hi Hans,
>
> thanks for the info.  If you are wondering about feasibility, I have 
> seen API in other languages (e.g. perl DBI, or ADO.NET 
> <http://ADO.NET>) providing column names for major databases, so I 
> would imagine that it is feasible (when there are man power to put 
> behind it of course ;P).
>
> http://search.cpan.org/~timb/DBI/DBI.pm#fetchrow_hashref 
> <http://search.cpan.org/%7Etimb/DBI/DBI.pm#fetchrow_hashref> - Perl 
> DBI fetching a row as a hash containing name/value pairs
>
> http://msdn2.microsoft.com/en-us/library/system.data.idatarecord.getname.aspx 
> - ADO.NET <http://ADO.NET> retrieving the name of the field for the 
> recordset from ordinal positions.
>
> Thanks,
> yinso
>
> On 4/10/07, *Hans Oesterholt-Dijkema* <hdnews at gawab.com 
> <mailto:hdnews at gawab.com>> wrote:
>
>     No(t Yet),
>
>     I've kept the interface as simple as possible. I don't know if I can
>     require from all drivers that they return the column names.
>
>     --Hans
>
>     Yin-So Chen schreef:
>>     Hi all -
>>
>>     can one retrieve the column names through sqlid interface?  It
>>     seems that the returned results only have the data... at first
>>     glance through doc or sqli.scm I cannot find a function that
>>     returns column names.  This is useful when one specify a column
>>     alias or using * to dynamically receive a list of names back from
>>     sql.
>>
>>     Thanks,
>>     yinso
>>
>>     -- 
>>     http://www.yinsochen.com
>>     ...continuous learning...
>>     ------------------------------------------------------------------------
>>
>>     _________________________________________________
>>       For list-related administrative tasks:
>>       
>>     http://list.cs.brown.edu/mailman/listinfo/plt-scheme
>>       
>
>
>
>
> -- 
> http://www.yinsochen.com
> ...continuous learning... 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.racket-lang.org/users/archive/attachments/20070411/7e4442b9/attachment.html>

Posted on the users mailing list.