I am trying to scrape rows off of over 1200 .htm files that are on my hard drive. On my computer they are here 'file:///home/phi/Data/NHL/pl07-08/PL020001.HTM'. These .htm files are sequential from *20001.htm until *21230.htm. My plan is to eventually toss my data in MySQL or SQLite via a spreadsheet app or just straight in if I can get ...
I am writing a prototype application. Right now some things fail such as inserting a non unique column. In this case i would like to rollback everything i have did. How do i do that? I also notice in sqlite i need to commit the data, in C# it seems to do it automatically which makes me suspect there is an automatic rollback option? ...
i have 2 tables "CREATE TABLE if not exists tag_name( " + "tagid INTEGER PRIMARY KEY, " + "title TEXT UNIQUE);"; "CREATE TABLE if not exists media_tags( " + "media_id INTEGER, " + "tagid INTEGER);"; Then i insert them with this code. The problem is, last_insert_rowid is not what i expec...
For kicks I'm writing a "schema documentation" tool that generates a description of the tables and relationships in a database. I'm currently shimming it to work with SQLite. I've managed to extract the names of all the tables in a SQLite database via a query on the sqlite_master table. For each table name, I then fire off a simple s...
How do I bulk insert with SQLite? I looked it up and it seems like I do an insert with a select statement. I googled, looked at the examples and they all look like they are copying data from one table to another or is not compatible with SQLite. I want to do something like "INSERT INTO user_msg_media (recipientId, mediaId, catagory, cu...
Is it possible to insert multiple sets of values to a SQLite table in one statement? I was trying: INSERT INTO the_table VALUES (1,2,'hi'),(2,0,'foo'); with the different ()s representing different insert sets, but I get an error. ...
Goodeve, My SQLite is version 3.4.0 However my phpinfo's PDO support for SQLitev3 is not enabled/listed How can I enable it? I installed my web server via XAMPP. ...
Any SQLite database on the iPhone is simply a file bundled with the application. It is relatively simple for anyone to extract this file and query it. What are your suggestions for encrypting either the file or the data stored within the database. Edit: The App is a game that will be played against other users. Information about a user...
Hello, Unless I have missed something in the documentation, I can't see if it is possible to execute an NSFetchRequest so that it returns an array of properties of objects, instead of the objects themselves. For example, I have: @interface SaleDate { NSDate *open; NSDate *close; Sale *sale; } I want to query something like "clos...
in SQLite with C# I want to do SELECT * FROM media WHERE mediaId= for each SELECT mediaId FROM fav WHERE userId=1 ORDER BY indx DESC LIMIT 0, 100 The syntax is obviously incorrect. I have no idea how to use the param from one select statement in another. ...
I have a varchar column in an sqlite datbase. A particular row of text has a backslash, which is used with "\n" for a carriage return in a UITextView. When the value is read from the database via a SELECT: myobject.text = [NSString stringWithUTF8String: (char *)sqlite3_column_text(selectstmt, 2)]; The backslash is escaped and looks ...
Hi, we are trying to develop an application on android we are using SQLite Database and on phone we are getting SQLiteException:no such table. but, it is working fine on simulator. Can anyone provide any input on this? ...
Is there any "Best Practice" approach to storing persistent STATIC data for iphone apps? I have an app that reads a dictionary of approximately 1000 items many of which are arrays. I started out using a single plist for this and it has become somewhat unwieldly especially since much of the values are html strings. Is there a better wa...
Hi, I am developing an application in Django using sqlite on windows.Will this db work on a linux machine? If not, how do i replicate the data on the new db on linux (creating scripts is one way)? ...
I am getting strange formatting errors while trying to update a row in SQLite through a C# wrapper. The issue is not in the wrapper, but in how I am passing the parameters to the parametric query. Is there a way to see the SQL generated to send to the DB? I've looked up a lot but it seems it is not very common wanting this or at least, ...
Is there a way in sqlite to automatically save a timestamp in the table whenever a record has been created that I can then grab and save as an NSDate in my application? Or should I instead create the NSdate object with the current time in my iphone app, and then insert it into the database. If so? What column should the datatype be for...
The Situation I have a very compressed time schedule to write a simple (basically write-only web app). The app is to be a mostly jQuery-driven question tree. The questions and tree will probably need to change both before and after the site launches. The answers will get emailed... I probably don't even need to store them, but I'm g...
I get an error message of un-finalized statement when attempting to close the database connection in ApplicationWillTerminate method. In order to find the source of the error I want to use the SQLLite next statement. But it seems this statement is not supported as per the header files in iPhone OS 2.2. Am I missing something ? Is...
I'm using a SQLite database to store cover images of books I have in a database. I've got the inserting of BLOBs ok, but when I don't have a cover image for my book I can't seem to get it to insert a null BLOB. I'm using parameters for my insert SQL statement, using ODBC, as shown below: OdbcParameter^ paramCoverImage = gcnew OdbcParam...
I created a table in Sqlite by using the CREATE TABLE AS syntax to create a table based on a SELECT statement. Now this table has no primary key but I would like to add one. Executing ALTER TABLE table_name ADD PRIMARY KEY(col1, col2,...) gives a syntax error "near PRIMARY" Is there a way to add a primary key either during table creat...