330 Topics
 | |
| | hi, I have these two tables: [CODE]personal_details (staff_ID integer PRIMARY KEY, title varchar(10), fn varchar(250), ln varchar(250), mn varchar(250), dob varchar(50), hometown varchar(250), securityno varchar(50), phone varchar(15), phone2 varchar(15), phone3 varchar(15), email varchar(50), address varchar(300), confirmation varchar(50), retirement varchar(50));[/CODE] and [CODE]training( training_ID integer primary key NOT NULL, staff_ID varchar(100), training_level … |
| | Dear all, Currently I am able to print out the saved values from sqlite3 database. However, I figuring out to put individual values into different text boxes.. Just like this... [img]http://i39.tinypic.com/9jnfbn.jpg[/img] Using my little experience on Java, I am thinking to use arraylist(if there is for python) and retrieve the … |
| | I am writing a flat-file database app using SQLite. That part works just fine, but the GUI not so much. The issues are arising in the bindings. I have a list of accounts displayed in a datagrid. The datagrid has its ItemsSource set to a List<Accounts> collection. That works fine. … |
| | I'm trying to perform multiple inserts into a table present in SQLite database using JavaScript. For this purpose I'm using Transactions. Here is my code (HTML + JavaScript): <html> <head> <script language="javascript"> var shortName = 'Test'; var version = '1.0'; var displayName = 'Test'; var maxSize = 65536; db = … |
| | Does any one know how to use SQLite? Can anyone tell me how to convert populated MySQL tables to SQLite tables without using a DBConvert software? |
| | Does sqlite contain a function that would look at every row in a column and find the ones contain a string I supply it with. I'm trying to make a dynamic database search that would query retrieve rows from the database every time I type a new letter into my … |
| | this is helper class . i m unable create a second table in my sqlite please observe the following code [code]helper class.java public class DBAdapter { private static final String DATABASE_NAME="satya_db"; private static final int DATABASE_VERSION=1; private static Context context; private SQLiteDatabase db=null; private static String CREATE_TABLE="create table states(_id integer …  |
| | Hey guys, I'm working on an SQLite3 wrapper using C programming. I was wondering if you know how can I set database properties such as mode, headers and echo through the C application. For example when running the SQLite shell and you are connected to the database you can do … |
| | Hi, I'm developing a Visual Studio C# application, which is related to a database. It currently uses a database file (SQLite). But I want to connect it to an online database. The idea is: the same copy of database should be on users' computers (in SQLite files) and on a … |
| | Hi, My program uses a database (SQLite) and I would like to protect the database with a password, as there is very important and secret data in there. How can I "hide" the password in the code, to prevent it from being captured during decompilation, or something like that? I … |
| | Today went to use GD within PHP and a simple check of phpinfo() showed it wasn't installed, but running php -m show that both (pdo_mysql and gd) where installed. Does anyone know how to sort this? [INDENT] [CODE] - PHP Modules ctype curl date dom exif filter ftp gd <-- … |
| | Hi, I'm currently trying to learn how to use php gtk2 to work with sqlite in stand alone application. If i try to open it in browser all working. But, its not working when i try to use php gtk and open it in stand alone application. i've already enabled …  |
| | Hi there guys... Been working all week for the database connection of VC# with SQLite. I got an error everytime i try to open the database... No matter how i tried the [B]SQLiteConnection.Open()[/B] command still returns an error... I installed the required ADO.NET and the required SQLite Database... [I] here's … |
 | I love to learn the hard way i.e with real world examples. I thought to make MP3 Player, but I changed mind and now I want to make small SQLIte driven app. How do you manipulate SQLite with Java? I'm googling to see if I will catch noobish things :-/  |
| | Hey I have a problem! when I try using SQL lite in viusal studio. [code] using System; using System.Collections.Generic; using System.Data.SQLite; using System.Data; using System.ComponentModel; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; [/code] Whey Will visual Studio not accept using System.Data.SqlLite? The compiler says: "Error - The type or …  |
 | hi... i want to know how do i use database to make a simple c++ program for console.. Somebody told me before that i could use the SQLite database for the receipt program that i'm making.. I just want to know about this further and if i could,i also want … |
| | Hey guys, Does any of you have a clue how can I install the sqlite3 library on my computer? I'm using netbeans for building my application which now needs to handle a database. I already tried to compile the sqlite3 source code but the make command ends into a huge … |
 | Hello guys, can someone tell me how can I get the values from the columns ? My sql table is: Table name: settbl Table columns: id, first (int), second (int) ...and now, I want to get the values from "first" and "second", but I got the error message "Object reference … |
| | hello ! I`m trying to use sqlite database with c++, but something isnt working right... The problem I`m dealing here is that i cant insert other datas into the table i`ve created except NULL, because i get following error message: Error in select statement : INSERT INTO a (a,b,c,d) VALUES … |
| | OK I have a search script that suppose to search for information in my database. The problem I having is that I want the user to be able to enter a last name to search. The only part that is giving me problems is this part, I'm stuck on this … |
| | Could anyone lend some help? Trying to figure out how to do this in SQLite3 (this is mySQL) [code] CREATE TABLE car_contacts ( id INTEGER NOT NULL AUTO_INCREMENT, carriers_id CHAR NOT NULL, name CHAR NULL, phone CHAR NULL, phone_ext INTEGER NULL, fax CHAR NULL, email CHAR NULL, PRIMARY KEY(id, carriers_id), … |
| | This program hangs when trying to generate fixtures when the table is empty: [CODE] using System; using Gtk; using Mono.Data.Sqlite; using System.IO; public partial class MainWindow: Gtk.Window { //SQLite variables static SqliteConnection DataConn; static SqliteCommand DataComm = new SqliteCommand(); static SqliteDataReader DataReader; string dsn; //tree_1 variables Gtk.TreeViewColumn name_1 = new … |
| | Hi i have this section of code that looks for user info on another table... this code works fine querying the database locally... but i need it to work remotely can anyone see what im doing wrong... [CODE]from sqlite3 import dbapi2 as sqlite import MySQLdb as mysql from mud.common.persistent import … |
| | Hi im trying to write a game. Its very early stage but i hit to an error so need your help. Here the code: [CODE]def gexp(): connection = sqlite.connect('test.db') memoryConnection = sqlite.connect(':memory:') cursor = connection.cursor() cursor.execute('SELECT * FROM gain') expget = cursor.fetchone() exp = expget[1] texp = expget[1] + mexp … |
| | I need a back-end that can: -be used in python -handle multiple-users reading and writing to a database at the same time -can be accessed on a mapped share drive I have used sqlite but I have read that it is not recommended for multi-user use. I have looked into … |
| | Hello! I wonder how and where can I see a sqlite database that i have created in c++, if it is possible at all? I would like to see if the db exist, and what are the inputs, to check if i have inserted valuations properly.. Thank you. T :) |
| | Could someone please explain me how should I copy datas from c++ into sqlite database. I have installed sqlite and then i have found somewhere information that i also need a sqlite++ wrapper to be able to use sqlite trought c++. so, i have installed both, but i dont dont … |
| | I don't understand what this code does. I really just want an explanation for the part between the /**********************************/ /**********************************/ It was predominantly found at the following site: [url]http://www.ch-werner.de/javasqlite/[/url] (the actually code is in the 'test program' link at this site). You'll notice parts are different because I edited/added parts. … |
| | Implementing Save algorithm Postby Apostle on Fri Sep 04, 2009 4:48 pm Hello All, I have a project of allowing user to save guests in Guest Book. I use Python/wxPython/SQLite for that. I Have implement basic database operation as well as GUI. I can save to DB as well as … |
| | Hi! I am using Zedgraph in my ASP.NET application. I get a duplicate legend in my graph. How to remove? Please help! Here's my code: //Default.aspx.cs [code=c#]using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Drawing; using ZedGraph; using System.Configuration; using System.Data; // using System.Data.SQLite; public … |
| | I have tables already. How do I search for a given keyword? Thanks |
| | I cannot get the code work. I want to use placeholder than a fixed value. When use fixed value it works but not placeholder. Please correct me! [CODE=python] import sqlite3 as sql class Tables(object): def __init__(self): print "Class created!" def CreateDb(self, dbname): self.conn = sql.connect("?", (dbname, )) self.cur = self.conn.cursor() … |
| | [CODE=python] import sqlite3 as sql class Tables(object): def __init__(self): print "Class created!" def CreateDb(self, dbname): self.conn = sql.connect("?", (dbname, )) self.cur = self.conn.cursor() def CreateNewTable(self, tablename):#, tablename self.cur.execute("CREATE TABLE IF NOT EXISTS ?(id INTEGER, name TEXT)", (tablename, )) listed = [(1, "Mary"), (2, "Martha"), (3, "Jesca"), (4, "Don")] for i … |
 | Have just spent the last hour guiding someone through creating a new profile in Firefox, while still salvaging as much as possible from the [B]old[/B] profile. Thought may well be valuable to set up this tutorial to guide others :) [B]Before you start, best to copy out the instructions into … |
 | I'm playing around with SQLite, which is very similar to what i've seen in MySQL, and I want to write some code that returns the column names along with the data for output purposes. Is there an SQL query I could use to do that, or is it done differently … |
| | [code=c#]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data.SQLite; namespace PlayingWithSQLite1 { abstract class Database { #region Member Variables string PATH = String.Format("{0}\\Database\\", Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData)); string FILENAME = "test.s3db"; #endregion public string File { get { return string.Format("{0}\\{1}", PATH, FILENAME); } } public static void CreateDatabaseFile() { SQLiteConnection.CreateFile(File); } } … |
| | I have a SQLite database added to my project in the solution explorer, named testdb.s3db. What I want to do is reference it in my code without having to fully qualify the path. Currently my code is [icode]SQLiteConnection connection = new SQLiteConnection("Data Source=C:\\Users\\Chris\\Documents\\Visual Studio 2008\\Projects\\ConsoleApplication3\\ConsoleApplication3\\testdb.s3db");[/icode] Can I do this somehow … |
 | After teaching comp sci and math for almost 30 years in Montreal, Canada, I retired 5 years ago, took a lot of linguistics courses, became interested in Japanese, then Chinese, and finally got my ESL certification. So here I am in Neijiang (Sichuan) teaching oral and written English to a … |
| | When I run this code: [CODE]sql = "SELECT Name FROM nameDatabase" self.cursor.execute(sql) list=self.cursor.fetchall() print list[/CODE] I get: >>> [(u'Joe',), (u'Katie',), (u'Bob',), (u'Ian',)] However, if I try to make a SingleChoiceDialog with wxpython it does not like that list. Is there any way to get those values in a so it … |
| | I know how to store data into a database if I know the value of what I am storing. For example: [CODE]sql="INSERT INTO nameDatabase (name) Values('Joe')"[/CODE] However, I want to be able to store data that I do not know the value of into my database. So I can prompt … |
| | Hi, I'm working on little phone book program with wxPython and SQLite. I can get database populated and can retrieve back the phones and names, but when I do fill them in ListCtrl it throws cruel errors :) Here is the retrieved data from database: [(1, u'Steve', u'Giddy', u'0654743553'), (2, … |
| | hi frnds i want to ask that what is the format of cookies last modified..Coookies of Mozilla are saved in C:\Documents and Settings\Administrator\Application Data\Mozilla\Firefox\Profiles\x5ncmceb.default\cookies.sqlite If we read it last accessed date of cookie is in format 1244272348453125. How to convert it to date..Can somebody tell me? |
| | I know this is for MySQL, but there really isn't a forum for 'other databases.' I was wondering if anyone could point me in the right direction for learning SQLite. I tried googling it, and I did find some helpful things, but nothing that shows me how to use it. … |
| | Hi I am writing a function which gets values. These ones will be used in my sqlite query [code] def updateDB(tel, month, price): mytel = (tel,) myprice = (price,) connection = sqlite.connect("mydb.db") cursor = connection.cursor() sql = 'UPDATE mydatabase SET %s = ? WHERE number = ?' cursor.execute( sql % … |
| | I have a combo box that is populated from entries in a SQLite table. The entries are city names. Here is the code for the data binding: [code] cbb_City.DataSource = data; cbb_City.DisplayMember = "Accounts.City"; cbb_City.ValueMember = "Accounts.City"; [/code] It gets the values just fine but it has an entry for … |
| | Having a problem with ASP.NET on Vista Business 32 bit. This is s a development machine. I have tested websites using the "View In Browser" and Debug options from Visual Studio 2008 and they load without a problem. But when I try to run a site from localhost i get … |
| | I apologize beforehand if this topic is in the wrong place. Quite honestly I am desperate for help. I have a project for school involving Firefox and making an extension that is a visual database. My professor suggested I use SQL Lite to make the database. I am so beyond … |
| | Hello, I call the imagettfbbox function like so `imagettfbbox($font_size, 0, 'monofont.ttf', $code)` but its generating the following error: 'imagettfbbox() [function.imagettfbbox]: Could not find/open font' monofont.ttf is in the same folder. And the code executes fine on the server. It just won't work on my computer. This leads me to believe … |
| | I'm trying to grasp SQLite to do some stuffs I want it to do, but it is sometimes too hash to me :) So what i'm I wrong with this code?? [CODE=python] #!/usr/bin/ # SQLite command to be used with the applications import sqlite3 as sqlite import os class SqliteCommands: … |
| | Hi all, I have been trying to write and retrieve data from SQLite Database. So far I can make connection, cursor; but cannot get table populated(fails to execute SQL statement). Since I read somewhere that it is recommended to use ? instead of % then I tries it but I … |
The End.