330 Topics
 | |
| | Hi, I can connect to an energy-meter (Baudrate 300!) and the logfile with 228 lines comes slowly in.[code=Python]line = ser.readline(eol='!') print line [/code] If I use the above code, the complete logfiles is shown. And if I parse separatly saved logfiles with match, it sorts out the right values into … |
 | When i insert value into table row (data type float), smt rounds decimal values into zeros. Here is the dramatically simplified code in order to see the situation.Interestingly, assigning a single array value into a variable (as usual) doesn't work here ! Is this a SQLite bug ?? |
| | I have been trying to no avail to load a ui file and insert it into a tabWidget as a new tab. I commented out a try that I thought would work, I was wrong. I have tried several different ways but I always seem to get the same error. … |
| | Hey guys! Its me again. I'm working with a SQLite database, and I want to list every entry inside a listbox (only the "Name" row). I know that I can list everything inside a DataGrid, but I don't want to list everything (: Also... sometimes, when you open a window … |
 | I have a database, test.db, with a table called Events. I tried this: [code] <?php try { // open the database $database = new PDO('sqlite:test.db'); $result = $db->query('SELECT * FROM Events'); foreach($result as $row) { // both of these lines produce a blank page //echo $row['EventName'] . ' | ' … |
| | We have been working to solve the issue early in the morning. This is a sample code to clearly show the situation. There are also more than 100 tables are waiting to get their records to calculate the results . Any idea ? conn.h #include "stdafx.h" static double global ; … |
| | ive been told to put all my sql statement together but i jus keep getting lots of errors with local variables in my vc++ project. sql.h[CODE]#ifndef __SQL_H__ #define __SQL_H__ #include "stdafx.h" #include <iostream> #include <string> using namespace std; using namespace System::Data::SQLite; using namespace System::Data; using namespace System::Windows::Forms; using namespace System; …  |
| | 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: … |
 | Hi there, I have started working on a new C# app which will be installed directly onto our customers' computers to access our services remotely. I'm still in the phase of planning how everything will fit together. I normally use PostgreSQL for our back-end database needs, but I can't think … |
| | Hello, I have about 500,000+ txt file for about 7+ gigs of data total. I am using python to put them into a sqlite database. I am creating 2 tables, 1. is the pK and the hyperlink to the file. For the other table I am using an entity extractor … |
 | 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 everyone. I'm using sqlite3 in Linux and I currently have a problem. I have a database and 2 tables in it: db1 and db2. db1 has 3 columns: empID, empName, empAddr. db2 has just 1 column: empID and its value is set to 0 by default. I created a … |
| | I can't think of a way to get rows out of a table. It was easy doing it with VB.Net and I'm just finding vc++ really difficult. This is what I have so far. I've connected to the database file and I am able to get the data shown onto …  |
| | Hello. After scanning this computer in safe mode with Nod32, Makwarebytes, SuperAntiSpyware, and TFC I got rid of around ~700 infections. But still I believe that there is something left because malwarebytes sometimes finds some folders infected. I scanned again with all those programs and non of them found anything. …  |
 | Hi, I wrote a program in Objective C for iphone app to display a letter and image from a database.. I dont want it in a table view .. i want only one view with text field and image view .. when i write a letter i get the corresponding … |
 | I have a big problem using the default SQLite database via JDBC driver.I would like to use ORMLite with this.Let me expose my code: [CODE=java]String databaseUrl = "jdbc:sqlite:/data/data/my.package.name/db.sqlite"; Class.forName("SQLite.JDBCDriver"); DriverManager.getConnection(databaseUrl); dataSource = DatabaseTypeUtils.createSimpleDataSource(databaseUrl); databaseType = DatabaseTypeUtils.createDatabaseType(dataSource); databaseType.loadDriver(); UpDao = new UserProfileJdbcDao(databaseType); UpDao.setDataSource(dataSource); UpDao.initialize();[/CODE] I downloaded the ormlite2.8.jar (src) and modified … |
 | Would be possible to create "generic" sub-forum in Databases where we can place any db related stuff which doesn't fit into any of our present options?(MySQL, MS SQL, Oracle, MS Access and FileMaker Pro, Database Desing) Having something similar to Software Development sub-forum Legacy and Other Languages. Reason: Often there … |
| | Hi all can anyone tell me how to store unicode values in sqlite2.1.0.0..I am not sure whether sqlite 2.1.0.0 supports unicode format |
| | Hi guys i can't seem to figure out whats wrong with my sql statement. its an insert statements using session variables to insert into a SQLite table. part of problem code as follows: [CODE]<?php $db = new PDO('sqlite:name.sqlite'); $submitNewSummary = $db ->query("INSERT INTO clinicalSummary(placementID,attMon1,attTue1,attWed1,attThu1,attFri1,attMon2,attTue2,attWed2,attThu2,attFri2,item1,item2,item3,item4,item5,item6,item7,item8,item9,item10,item11,item12,item13,item14,item15,item16,item17,item18,item19,item20,dateCompleted) VALUES (".$_SESSION['studentRetrievedPID'].",".$_SESSION['Monday1'].",".$_SESSION['Tuesday1'].",".$_SESSION['Wednesday1'].",".$_SESSION['Thursday1'].",".$_SESSION['Friday1'].",".$_SESSION['Monday2'].",".$_SESSION['Tuesday2'].",".$_SESSION['Wednesday2'].",".$_SESSION['Thursday2'].",".$_SESSION['Friday2'].",".$_SESSION['itemSummary1'].",".$_SESSION['itemSummary2'].",".$_SESSION['itemSummary3'].",".$_SESSION['itemSummary4'].",".$_SESSION['itemSummary5'].",".$_SESSION['itemSummary6'].",".$_SESSION['itemSummary7'].",".$_SESSION['itemSummary8'].",".$_SESSION['itemSummary9'].",".$_SESSION['itemSummary10'].",".$_SESSION['itemSummary11'].",".$_SESSION['itemSummary12'].",".$_SESSION['itemSummary13'].",".$_SESSION['itemSummary14'].",".$_SESSION['itemSummary15'].",".$_SESSION['itemSummary16'].",".$_SESSION['itemSummary17'].",".$_SESSION['itemSummary18'].",".$_SESSION['itemSummary19'].",".$_SESSION['itemSummary20'].",".$_SESSION['studentRetrievedDF'].")"); if ($submitNewSummary) { echo … |
| | Hi, I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the one of the row of … |
| | I'm trying to make a siple list to display sqlite rows in a grid using wxList. I can't come up with something decent. I can't place correctly the items in the list. [code] #!/usr/bin/env python # -*- coding: utf-8 -*- # generated by wxGlade HG on Wed Sep 22 12:34:17 … |
| | Hi, I have populated a dropdown menu using php pdo from sqlite database. How would i go about reading what the user has selected in the dropdown menu. so i can do something like: $userSelected = [whatever user selected in the dropdown menu]; my code is as follows (part of … |
| | Ever since the "disatrous" Adobe Encore (CS4 and 5 does not matter)'s way of storing the installation directory details in Sqlite database file and some uninstall string in the registry, I would like to create dll to get the install directory from Sqlite database as per recommended by the Inno … |
 | Hey everyone, I'm trying to get started with SQLite. My app keeps force closing on this activity: [code=java]public class ViewActivity extends Activity { private TextView company; private BillMeDB dh; public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.all); company = (TextView) findViewById(R.id.Company1); BillMeDB db = new BillMeDB(this); db.open(); long id; id = … |
| | Hi guys! I'm writing my first small application*. For this I'm using Sqlite as database, Glade as GUI builder and Python as coding. The application is pretty simple: it's a notebook to store names, surnames, adresses, etc.. I've been able to create a first window to store data in Sqlite … |
| | Hello i got a text based game running atm and i want to develop an app for it on android. I have created the interface and the login pages and all the pages i need . i have even created a database for it. but i want to link my … |
| | Hi, I'm trying to develop application with separation of UI/BL/DAL. I have read a lot of theories and I'm trying to develop a blue print for my application. I have no problem in UI thing. But I have problem with designing Data Access Layer. It will basically be a SQLite … |
 | Hi, I have just started out with sqlite in c but I can't seem to return the results of the select statements. There are so many functions that I don't know what to use as none of them make any sense. So can anybody give me an example of how … |
| | Hi, I have a code design problem: I have several classes *MainWindow - holds 2 widgets, a QTableView Widget and a QTabWidget *TabLayout - layout of the tab, comboboxes etc. Creates an instance of TabCode and connects its signals to it. *VideoTab - contains the slots. Slots are called whenever … |
| | I am trying to convert my CMS to SQLite for easy and quicker deploy-ability. Performance wise, I heard that SQLite might be the way to go. At any rate, I am having the hardest time with trying to convert my mysql database to a SQLite database. Having reviewed and downloaded …  |
| | I'm using the SQLite java Wrapper from [url]http://www.ch-werner.de/javasqlite/overview-summary.html#jdbc_driver[/url]. The only changes I made to the Windows MS Visual C++ make file (javasqlite3.mak) were to the locations of JAVA_HOME (mine is not in the C:\ directory. But when I run it I get the following error: "Unexpected token 'javasqlite.mak' in expression …  |
| | Hi, I'm currently writing an application using VS C++, Qt, and SQLite. I have a user interface where the user uses a series of combo boxes to select certain criteria that they want to fetch from the database. When this dialog closes, all of the combo boxes selected text (string … |
| | Hi, I've just created my first 2d game (c# XNA) - a car racing game. My problem is how to perform a multiplayer mode. I wanted to use MySQL server. I decided to try with a local database (SQLite) first. As i suspected it didn't work. The thing is that … |
| | 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 …  |
| | I have a sqlite database and want to update the sort column in my table. e.g. Col1 - Col2 C - 4 A - 3 B - 5 I want to sort on col1 then update Col2 with new values i.e. 1-3 Don't know if it's possible but doing it … |
| | Hi, Sorry if this is in the wrong forum but it appears daniweb doesn't have a category for sqlite or miscellaneous database systems. I have just started on a personal project which is an admin interface for sqlite (Like sqliteMyAdmin), similar to Phpmyadmin but for sqlite. Anyways the question is …  |
| | Hi all, I have ubuntu and just installed sqlite then edit the php.ini file accordingly but for some reason the class named ¨SQLiteDatabase()¨ reports as undefined. The error is as follows: [CODE]Fatal error: Uncaught exception 'SQLiteException' with message 'SQLiteDatabase::__construct() [<a href='sqlitedatabase.--construct'>sqlitedatabase.--construct</a>]: unable to open database: /var/www/vhosts/cwarn23/base' in /var/www/vhosts/cwarn23/php.php:3 Stack trace: … |
| | Hi I have a problem as detailed below. I hope the answer is something really simple: [CODE]$connect = new PDO("sqlite:main.db"); $sql = "SELECT * FROM employee ORDER BY Surname"; echo "<table align='center' border='1'>"; foreach ($connect->query($sql) as $info) { $FirstNames=$info['FirstNames']; $Surname=$info['Surname']; $EmployeeID=$info['EmployeeID']; $TagID=$info['TagID']; echo "<tr align='center'>"; echo "<td width='16%'> $FirstNames </td>"; … |
 | Hi folks, I've got a little problem with my queries in sqlite3. I need to select 'brands' (a, b, c, ...) for a 'date' YYYY-MM-DD from my table. As you can see in my script, I'm able to build a query by passing 'selectedDate' or 'selection', but not both values. … |
| | Hi Guys I wrote a little web app to integrate with an SQLite database. When the database is on a local PC, there is no problem connecting to it as in: [CODE]$connect = new PDO("sqlite:\path\to\database.db");[/CODE] Now I've been asked if I can adapt it to connect to a linux device …  |
| | Hi I'm a bit of a newbie with this stuff, so I'm not 100% sure where to post this. Anyway I have a mini arm based PC for which I am trying to compile a php binary in cgi-mode, which supports sqlite. I am trying to cross compile from a … |
| | I'm in the beginning stages of writing (and learning as I go) a Python database app using SQLite. I have the db structure planned on paper, and I have the queries I'll need in mind, but before I start coding I want to fully test the db design to make … |
| | Hi, I just received my Ubuntu machine with 3.2GHz 7 core but now I need to install SQLite. Does anybody know where SQLite gets installed in Ubuntu or where itś portable database files are stored as the php cms phpSQLiteAdmin requires me to copy a database file into the database … |
| | Well I am interested in fetching 3 records because i need to show them on one screen as the program starts, and reason for showing 3 recording is to maintain next , now and previous button. Whenever i click next button so it should increment by +1 everytime and show … |
| | i was just trying the new DBMS , herd it was kinda faster than MySql in some case. the below is the code i have taken (Standard example) and still i am getting error. [code] <?php // create new database (OO interface) $db = new SQLiteDatabase("db.sqlite"); // create table foo … |
| | Hi Guys, I have access to mini linux PCs that can serve up webpages using the Boa webserver. They also house an sqlite db file. What I want to do is install the bare-bones of php with only sqlite and PDO functionality, so I can write to and display data … |
 | Well I have reflected on why my first proposal for a open source project failed. We had no base to build on, and there was to much administrivia that made us loose interest in the project. Since then I have come up with a new project idea. I started simple … |
 | Florian Mueller, Open Source Patent Activist, just released the following information. He believes that patents already used by IBM against [URL="http://www.turbohercules.com"]TurboHercules[/URL] are also a threat to other major FOSS projects. He now calls on the community for action. [URL="http://openbsd.org"]OpenBSD[/URL], [URL="http://xen.org"]Xen[/URL], [URL="http://virtualbox.org"]VirtualBox[/URL], [URL="http://redhat.com"]Red Hat Enterprise Virtualization[/URL], [URL="http://mysql.com"]MySQL[/URL], [URL="http://postgresql.com"]PostgreSQL[/URL], [URL="http://sqlite.org"]SQLite[/URL] and [URL="http://kaffe.org"]Kaffe[/URL] … |
| | Hello I have a rails application where I have to subtract 2 time stamps and display the result on the webpage I have used the following sql statement and I am getting the results. [CODE]select (julianday(resolutions.created_at)-julianday(tickets.created_at))*24 from tickets,resolutions[/CODE] the value of tickets.created_at is 2010-04-05 18:59:02 which is a time stamp … |
| | I'm trying to get a SQLite3 DB to populate a wx.ListCrtl. I can get it to print to stdout/stderr without any problem. I just can't seem to figure out how to display the data in the DataWindow/DataList? I'm still learning programing/python so any advice would be appreciated. After two days … |
The End.