On 2/21/06, Michael Lackhoff <[EMAIL PROTECTED]> wrote:
> I found out about my problem from yesterday. It was all (well almost)
> my fault. In the database definition I had forgotten the 'INTEGER'
> qualifier but in the class definition everything was all right. Now
> these two didn't fit together and I got these mysterious effects.
> I say 'almost all my fault' because something should croak/die if the
> type is wrong, probably sqlite.
SQLite really has no concept of SQL data types. Well, it has a very
simplified concept, anyway. All that detail you put in your CREATE
TABLE statements is pretty much ignored by SQLite. Instead, it stores
everything as strings and integers (and maybe floats?). SQLite will
let you type almost any crazy thing in your CREATE TABLE statements
and then blithely insert whatever you want. Example:
% sqlite3
SQLite version 3.1.3
Enter ".help" for instructions
sqlite> create table f (i int);
sqlite> insert into f values ('abc');
sqlite> select * from f;
abc
sqlite>
Not much to be done. That's just the nature of the beast.
> One other question:
> Is there an accessor method to get all the fields of a set in a
> hash(ref)? I know I could just use the object but that is considered
> bad practice.
I'm not sure what you're asking here. Can you give me an example?
-John
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
