Re: [sqlite] insert of string with line breaks

2008-04-01 Thread Samuel Neff
How are you verifying that the db only received one line from the description? using sqlite3.exe or some other tool, or AIR? SQLite itself does not have issues with storing line breaks, but it's possible the AIR wrapper is losing them somewhere or more likely it's a display/formatting issue.

[sqlite] insert of string with line breaks

2008-03-26 Thread Raymond Camden
I've got an AIR app that does simple inserts into a SQLite db. The insert looks like so: var insStmt:SQLStatement = new SQLStatement(); insStmt.sqlConnection = dbconnection; sql = "insert into hours(description,projectidfk,clientidfk,hours,date)