I am using the following code adapted from http://www.roth.net/perl/odbc/docs/object/
to try and capture the field names of a database. The odd thing is
that the fields names are not returned in the order they appear in the
table. I know from the aforementioned site there is a sort option but
the order of the field names in the table are not in alphabetical
order. any way to get the returned field names in the order in which
they appear in the Access database?
TIA
Dan
**
$db->Sql("SELECT * FROM Groups");
$db->FetchRow();
%hash = $db->DataHash;
foreach $key (keys %hash) {
@fields[$i]=$key;
print "my field $fields[$i]\n";
$i++;
Re: SQL Server Performance (slowdown) ... I don't think that database design causes to the slowness in this case, ... But in this case I did not capture any slowness in SQL ... Some strange issues that I captured on the production server.... I asked them to send the database backup.... (microsoft.public.sqlserver.server)
Re: New Records printing on odd pages - Word 2000 ... So if you convert one section break to an Odd Page one, ... >> What I have is a mail merged document which reads off an access ... >> According to the database, if one field is "1" for instance, then the ... >> into the document from the access database,... (microsoft.public.word.docmanagement)
Re: Active Directory password external use ... I was involved in a single-signon password strengthening project where ... whose task it is to update the back end database...capture the new password and send it to another ... This could be done with an agent or daemon running on the ... (Focus-Microsoft)
Re: how do i read odd numbered lines from a file ... can anyone tell me how to lines from a file which are odd numbered i.e. ... The right answer is to use a database. ...Skipping every other line as you read the file is trivial. ... you've seen an even or odd number of '\n' characters,... (comp.lang.c)