330 Topics
 | |
 | In the following code I'm trying to figure out what InitDB is? I need to reconfigure these files for a particular website and to use SQLite. http://www.html-form-guide.com/php-form/php-registration-form.html <?PHP require_once("./include/fg_membersite.php"); $fgmembersite = new FGMembersite(); //Provide your site name here $fgmembersite->SetWebsiteName('user11.com'); //Provide the email address where you want to get notifications $fgmembersite->SetAdminEmail('user11@user11.com'); …  |
| | Hi all, I have recently been give a project to create an invoicing system for a small business. The system needs to be able to easily add new customers and store them for usage within invoices. There also needs to be a form to enter invoice data and invoices need … |
 | Hi Guys, I need some help about join queries in SQLite manager. I wanna have some sample queries on joining one or more tables with relationship of course. PLEASE I NEED THIS FOR OUR PROJECT. Thanks. It would be an honor hearing from professionals out there. :) |
 | I have a program that takes csv values, parses the content and inserts it in an sqlite3 database. I am using sqlite3 to save on space and to make the py scripts a little more portable. The next refactoring may well need to have postgresql or mysql to deal with … |
| | Using an SQLite database your program should be able to create, read, update, and delete room reservations. Present the user with a menu at the beginning using the console or JOptionPane for example: Choose a task 1. Add a reservation 2. View a reservation 3. List all reservations 4. Update …  |
| | I want to create sqlite3 databases from within a python script. I am currently running this code which does not pass the right variable content to the sqlite3 command prompt, so I have one issue there. I also do not want to have the user have an sqlite3 command shell …  |
| | My question is : how do I put the results that I have obtained into an SQLite Db after a click event. I do not have handy my code but will post it ASAP. Thanks  |
| | I have 2 functions, one of which works and one of which doesn't. I do not understand this, because the only difference is that the second function puts in just the name of the variable, where the 1st function puts in the value. There is only one line to build … |
| | I have a csv that needs to be put into a database format so I can sort and count the data. My approach has been to use python csv and sqlite modules. I am communicating with the database and creating one of the 2 tables. Second table has many more … |
| | Hi everyone. I'm building an applicaiton but want to use HTML to create a gui.. Obviously I'll need to create the gui with CSS and maybe some javascript,, not sure yet but as far as I know I'm limited to building and viewing it in a web browser such as … |
| | I need to convert mysql class of one script to make a support for sqlite,but problem is sqlite dont have username/password thing nor database select as well,which means how some parts need to be removed.If i would convert to mssql one search and replace probaly would do the job.There is …  |
| | |
| | I have a phone I want to root but before I do that I need to backup my Shazam tags. Is there a way to do that without rooting, it seems if you've done that you can pull the sqlite file from the phone. But I made these tags when … |
| | I would like to ask on how to do calculations and saving the result and retrieve again just like making a deposit and withdrowal in banking system. i really dont know how to do so.. i am trying to formulate some codes but it just don't work. Pls help. I …  |
 | I have to resurrect the article that I marked solved this am, 'cause it ain't! My code is: <?php if(isset($_POST['chest'])){ $pin=$_COOKIE['registered']; $game=$_POST['item']; foreach($game as $rep){ $link=sqlite_open('data/'.$pin.'.sqlite ',0666,$sqliteerror); sqlite_query($link,"INSERT INTO holding (item) VALUES('$rep')"); sqlite_query($link,"UPDATE players SET points = points+10"); header('location:entrance.php'); } } include('php/head.php'); ?> <div class="game"> <p><u>Chest</u></p> <p> The chest has … |
| | Hi guys, I've hit a wall again with this code and I'm sureit's something simple I'm doing wrong, I just can't see it. <?php include('php/head.php'); // form action $asset=$_POST['asset']; $item=$_POST['item']; $link=sqlite_open('data/3002.sqlite ',0666,$sqliteerror); sqlite_query($link,"INSERT INTO holding(item) VALUES('$item')"); sqlite_query($link,"DELETE FROM '$asset' WHERE item= '$item'"); // open page display div echo"<div class='image_pane'>"; // … |
| | Hi guys' I'm having trouble with this code <?php $link=sqlite_open('data/3001.sqlite ',0666,$sqliteerror); $comp=sqlite_query($link,"SELECT * FROM assets WHERE asset='chest'"); while($ent=sqlite_fetch_array($comp)){ $item=$ent['content']; $asset= "array(".$item.")"; echo $asset; } $saved=array('food','knife'); $left=array_diff($asset,$saved); echo $left; ?> the echo $asset line displays "array(array(food,knife,scarf,torch,key)" but I get an error Warning: array_diff() [function.array-diff]: Argument #1 is not an array in …  |
| | Hello I modified tutorial code found at http://www.codeproject.com/Articles/119293/Using-SQLite-Database-with-Android?fid=1592519&df=90&mpp=25&noise=3&prof=False&sort=Position&view=Quick&spc=Relaxed&fr=1#xx0xx to create an assignment list app, and when I click modify, delete, or cancel it force closes. Here is my DatabaseHelper.java code: public class DatabaseHelper extends SQLiteOpenHelper { static final String dbName="assignDB"; static final String employeeTable="Assignments"; static final String colID="assignID"; static final … |
| | I want to develop a simple application which runs on single computer (just runs in one mechine) and did not need network. Program has to store some data in database and show them for printing. I have no experience with real-word program so I confused here: If the program is …  |
 | Explore Python's sqlite3 database module, create, write and read a database file. |
| | I used the folowing website towards the end of the website http://zetcode.com/databases/sqlitephptutorial/ to make a connection to the sqlite database using PHP. Working on netbeans and have imported the appropriate driver and jar files however clicking submit on html is not doing the job and simply prints the whole php … |
 | 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 … |
 | Hello, I have been struggling a little bit with an issue in a relational database that supports queries. Originally I was going to use an OleDB data adapter and connect to an Microsoft Access database (created with Access 2000). The problem is that when I use a connection string like: …  |
 | Hello guys, I am a dude who used to work with vb.net until i joined college where Java rules the day. I have a project in which i have a database in sqllite and i want the db to be in the same folder as the executable file(jar in this … |
 | Below is a documented code example showing how to use the SQLite3 class to connect and query your database (and check for errors). IMHO using PDO is a better alternative, as this extension uses mixed technology in a non-standard way (objects, arrays and exceptions). If there are any questions let … |
| | Below is a documented code example showing how to use the SQLite functions to connect and query your database (and check for errors). Please note that using the SQLite extension is NOT RECOMMENDED. This extension is no longer available in PHP 5.4.0. If you want your scripts to be future … |
| | All, I am working on a project in C# with Visual studio 10 (on WinXP 32bit with .NET 4.0) and I need to use SQLite. I am totally confused by the SQLite installation process. [This FAQ](http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q8) says that there is no need to install SQLite, but the [instructions given here](http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) …  |
| | I'm working on an app and I am having some trouble getting the login and registration to work. Here is the code I have for my registration. public class RegisterActivity extends Activity { Button btnRegister; Button btnLinkToLogin; EditText inputFullName; EditText inputEmail; EditText inputPassword; TextView registerErrorMsg; //JSON Response node names private …  |
 | Wondering if anyone has used SQLite. I'm having trouble with the basics. sqlite3_get_table function. The Apress book 'The Definitive Guide to SQLite' provides the following example. The first problem is that when declaring char *result[]; Things start to go wrong. I get an error message saying that *'the size of … |
| | Can anyone suggest a good sqlite3/php tutorial for beginners? I've been using sqlite, and now wanting to learn sqlite3, am looking for a good tutorial but the only ones I seem to find are either assuming you know version 3 already, or are for command line. |
| | Hi i am having problems designing a solution for this problem : I have a form where you can choose the items you wish and type the quantity and then add them to a listview item. The itema are already saved in a database ( i am using sqlite ) … |
| | Hello, I have a doubt with the concept of server and client in the database.I am developing an application which needs a centralized server for holding the updated information from which all the clients would be getting it.And also the other way updation also should work where information is sent …  |
| | how to access a web service from a mobile POS Device application in c and to store the accessed data in the device to use it (like printing bills for a collection) when it is required.can anyone please give any guidance for the above requirement iam totally new with POS … |
| | 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']; … |
| | I saved some images in an sqlite database but when i tried to display them using static bitmap i get an error OnOpenEdit self.frmEdit.imageCtrl.SetBitmap((i[7])) File "C:\Python27\lib\site-packages\wx-2.8-msw-unicode\wx\_controls.py", line 1229, in SetBitmap return _controls_.StaticBitmap_SetBitmap(*args, **kwargs) TypeError: in method 'StaticBitmap_SetBitmap', expected argument 2 of type 'wxBitmap const &' here is a print of … |
| | 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! |
| | I'm not sure how to ask this but here it goes. I am building a C++ application, in this case I'm building it in Code::Blocks with a MingW compiler. I want to incorporate/utilize/whatever, SQLite into my applicaiton by **including** (#include) the sqlite C code header file sqlite3.h in my project … |
| | I'm finding it difficult to understand how to get a start on SQLite... I know there are allot of tutorials out there but they all seem to go off on some tangent. Even the books is vuage on how to go about incorporating it into a C++ project. This is … |
| | I've been trying to display sqlite data in wxcomboboxes but I get a type error not all arguments converted during string formatting, I'm Using a caller for the frame and it displays for about five comboBoxes but when I add more (exactly the same way as the first ones) It … |
| | To All Pythonist.. I have small SQLITE db.. for User Table 'SELECT loginUser from User'; sql = cursor.fetchall() listSQL = sql[:] for x in listSQL: print x listSQL SELECT Data Produce: (u'user1',) (u'user2',) (u'user3',) I want to match the list of user with a string input: example if the value … |
| | I can't edit the code I posted in [this thread](http://www.daniweb.com/software-development/cpp/threads/432459/c-variable-in-sqlite-query#post1854736) because it won't let me place the cursor where I need to add something. I put the somewhere then use the arrow keys to move it to the right spot but it just goes to random locations. I want to … |
 | I'm trying to write a simple sqlite query in c++ using visual studio 2010. My problem is that i can't use a c++ variable inside that query. I was not able to find the right syntax. `sqlite3_prepare_v2(handler, "SELECT * FROM grammateas WHERE username==X;", -1, &statement, 0);` where X i would … |
| | I am going to work on building a database application. One part of this is parsing pdf files which will feed the data into the database. Will be using SQLite build it C which has wrappers for Perl so there's not problem there. From what I understand, Perl is a … |
| | This code was inspired after several discussions on the forum, and I'm especially indebted to PyTony for all of his help with these aspects. The motivation behind this code is quite simple. I wanted a robust, light and general way of storing CSV data that could be used over and …  |
 | Hi guys. So, I'm trying to read data from a database and displaying in a GtkTreeview. I used glade to design the GUI when i click on the button (view movies) the list of movies should display as a list. def on_btnmovies_clicked(self,widget,data=None): store=self.builder.get_object('listmovies') connect=sqlite.connect('movies.db') db=connect.cursor() db.execute("SELECT * FROM movie") for … |
| | hi i am developing an android application on platform 2.1 im presently working on two classes: Dbhelper.java RssActivity.java I have made a students table, its schema is created but my problem is values are not being inserted into it. There are two textbox: one for Name and other for entering … |
| | hii..i am new to android..i am developing an android application on platform 2.1.. There are two textbox: one for Name and other for entering job.I want the values should be taken from the 2 textboxes editText1 and editText2 and inserted in my database whenever a user clicks the button.Please help … |
| | 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 … |
| | Hi i'm new to android development.So i have comeup with a simple dictionary application.It should connects with sqlite database and show the meaning of an english word, when button clicks.The user enter the relevant word into a Edittext field and click the translate button.Then it should show the meaning on …  |
| | Hi I'm trying to decide which **SQLite** book to get and was wondering if anyone has used either of the ones or others listed below? I could rely on Amazon testimonials but not sure I trust them. I have never used any database software outside of Microsoft access before so … |
The End.