Comments (5)
Hi golgote, you can retrieve column names from a select by passing true as a
parameter to the 'fetch' or 'rows' method of a statement handle. By default
'fetch'
or 'rows' returns a numerically index table (AKA an array), but by passing true
to
these methods the result is return as a table indexed by column names.
See the examples on http://code.google.com/p/luadbi/wiki/DBDDriverStatement for
more
details.
Original comment by [email protected]
on 5 Apr 2009 at 5:14
from luadbi.
Yes, I noticed that, but columns in the table can be in any order (since that's
the way tables work in Lua). To
build specific functions like "getAssoc" (and some others for my ORM), I need
to know in which order the
columns were fetched, that's why a function to get the column names is useful.
Thanks for your reply :)
Original comment by [email protected]
on 6 Apr 2009 at 10:26
from luadbi.
I've had a look at the source code, and the functionality should be relatively
easy
to add. The implementation will look something like:
local sth = dbh:prepare('SELECT id,num,timestamp FROM sometable')
sth:execute()
-- fields will be equal to {'id','num','timestamp'}
local fields = sth:columns()
I'll look at adding this in the next week.
Original comment by [email protected]
on 9 Apr 2009 at 12:48
from luadbi.
I've committed changes to implement the 'columns' method for statement handles
into
SVN. I'll be uploading a new release source package shortly.
Original comment by [email protected]
on 17 Apr 2009 at 11:49
- Changed state: Fixed
from luadbi.
Thank you Neil :)
Original comment by [email protected]
on 19 Apr 2009 at 8:45
from luadbi.
Related Issues (20)
- Trying to use on a Windows 7 Luarocks installation HOT 1
- Include for postgres_fe.h looks in non-standard location HOT 6
- Need to move to autoconf HOT 1
- Infinite loop when retrieving empty blobs (MySQL) HOT 3
- When a PostgreSQL connection is opened, a transaction is started before the previous transaction commits. HOT 5
- Problem compile HOT 3
- Problem compile HOT 1
- OSX binaries HOT 1
- fetch() on mysql returns expected output with trailing random characters HOT 5
- Empty values from joined tables HOT 3
- Makefile improvements (fixes for #11 and #12) HOT 2
- enum fields seems not correct in lua-dbi HOT 1
- Issue with compile.
- Garbled UTF-8 characters with MySQL and utf8 charset/utf8_general_ci collation. HOT 7
- sqlite3 does not allow strings with NULL characters HOT 4
- luadbi with lua 5.2 HOT 7
- "SELECT 1" returns invalid type HOT 3
- Unchecked malloc in common.c HOT 2
- support unix socket in mysql driver HOT 2
- MySQL BIGINT handled wrong HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from luadbi.