[sqlite] Forum Topics

Hello. When we want to insert a vlue into a table in sqlite, we use this line, right? cursor.execute('INSERT INTO colors Values ("red", "blue")') As we can see above, we want to insert 2 words and we type them as when we are typing whole the codes. But i want …

Hi guys i have a table with this data ______________ | site | cat | ______________ | my | sp | | my | sp | | my | cc | | my | cc | | yo | sp | | yo | sp | | yo | cc …

I am developing an android application using java with SQLite. The following code make the error: String selectQuery = "SELECT * FROM User"; Cursor cursor = db.rawQuery(selectQuery, null); I checked my program and I found that the cursor make unfortunatly error. Please help from where is the error come??

Hi Guys , I couldnt dispay sum of a column of sqlite database in php . I tried the sql statement in database its working fine but not sure how to dispay the result in PHP . I belive i need to fetch it and then dispay any help will …

On the form user enter rego no where it search database and display the output what i am looking is, if the entered data not match its should display " Record not found." <?php $search_Rego = ($_POST['RegoNo']); try { //open the database $db = new PDO('sqlite:iSearch.sqlite'); $result = $db->query("SELECT Fname …

I need help figuring out how to fix my code. Every time I run the code its traceback is to this part of it. My code is Unbound Local Error for 'result'. Please see code below: def Level1(self): sql = "SELECT easyhint, gps, qrcode FROM gamedb WHERE quad = 1 …

For my project, these two queries don't work. The sqlite manual says to use 'qualified-table-name' but if I do (flist.fdata) an error is returned 'no such table'. As they are below no errors are returned, but the database table is not affected. if (isset ($_POST['del'])) { $id = $_POST['id']; $titl=$_POST['titl']; …

Hi all,Anyone know of a decent free sqlite manager. One that will work with sqlite not sqlite3. Ive tried some and not been able to find one that works!

This same code run good on windows 7 32 bit Problem happen when i run it on windows 7 64 bit error : database is locked... public void genTablehadir() { tblKehadiran.setAutoCreateColumnsFromModel(false); m_data = new Kehadirantable(this); tblKehadiran.setModel(m_data); tblKehadiran.setRowHeight(23); //inisialisasi int m_Jalokasi=0,m_kode=0; Boolean m_alokasi=false; String[] parsePeriode; String m_npk="null",m_nama="null",m_ket="null",m_id="null",m_flagE="null",m_flagP="null",m_cekhk="null",m_ceksts="null"; try { db.createMasterConn(); rs1 …

I am having trouble structuring an sqlite update statement that has multiple parameters. The following code does not raise an exception, but nor does it update my table. After extensive googling and searching Daniweb, I think I'm looking right at the blindingly obvious and missing it. I have a list …

Hi :) I am writing an admin application for a website I've written. It's a basic database update/insert/delete app. I started by using the website's server, but the time it took to connect to the server (since the main JTable is populated from the db, you have to wait for …

Problem with storing extracted values in SQLite - How to adress or index list of values for proper insertion into table. The Regex works fine: input logging data looks like: 0.0.0(06026104) 1.6.1(0.1501)(1011111000) 1.6.1*32(0.1446)(1010190800) 1.8.1(02484.825) 1.8.1*32(02449.574) correct regex output: 06026104 0.1501 02484.796 [CODE] with open("usage.log") as fp: for line in fp: …

Someone mentioned in another thread they had found and downloaded [URL="http://search.cpan.org/~adamk/ORLite-1.45/lib/ORLite.pm"]OrLite[/URL], presumably to consider using it to access data in an SQLite database. Since, to use OrLite you need to have the DBI and DBD::SQLite modules installed on your computer as well, I think you could just use DBI to …

Hi, First off, I'm a real greenhorn so please forgive me asking questions which may be bleeding obvious, but I have searched and searched and cannot find an answer to my problem. I'm trying to import a CSV file into sqlite3 database in python. The CSV file has 56 columns …