Hey all. Very happy to have found this e'list. I have worked with a few other DB (and DB-ish) systems in the past but am only now taking a deep-dive into SQLite.
I am attempting to load a delimited text file into a Celko-style nested-set model table. In a previous life, I was able to get the stuff into a MS SQL Server adjancency model table using TSQL constructs like WHILE and FOR to iterate over parts of strings, use temp-holder variables, and then perform inserts. >From what I understand about SQLite, only CASE is available and only set-based (non-procedural) operations are possible. I have visited a few links (like http://dev.mysql.com/tech-resources/articles/hierarchical-data.html) but none really show enough information about how I can "get procedural" to load the file into SQLite. Can anyone throw me some clues? Part of my input data: Animals Animals|Pets Animals|Pets|Exotic Pets Industries|Construction|Buildings Industries|Construction|Materials|Nails|Metal Industries|Construction|Materials|Screws table ddl: CREATE TABLE nested_category ( category_id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20) NOT NULL, lft INT NOT NULL, rgt INT NOT NULL ); Thanks. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
