60 Discussion / Question Topics
Remove Filter
|
|
I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as … |
|
I'm looking to build a command-line tool that will enable me to read an arbitrary XML file combined with a mapping to fill an existing (arbitrary) SQLite database with data. What I'm looking for are conceptual ideas on how to solve this. I've got a possible theoretical solution in mind, … |
|
Hi All, in sqlite SMALLINT datatype is used to store 2 bytes integer but i didn't see any Unsigned SMALLINT type to support the range(0-65535). Can anybody let me know how to achieve the same. |
|
Hey guise, I have a uni assignment; setting up backend code for a tour company website. Everything's gone swimmingly but I've run into issues implementing a system for rating the tour packages. Implementation for the rating system: user clicks rate button, the rating score is added to a running total … |
|
I'm creating a small and simple app to use with my poker league. I've created a small DB that I simply enter the player name, who took them out, and what place they went out in. All of that works just fine. What I need to do is implement the … |
|
Hello!!I have a database and I want to display its data into a QTreeView in PyQt.The database's column has file paths.I have a problem in filling this treeview with data because it's a database and I'm not sure if it is like working with txt files and because it is … |
|
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 … |
|
Hello everybody. How can i get "ls" from shell scripting? I tried this but it doesn't work, i saved it in a file: #!/bin/bash $ls I know the second line is not correct, so what should i type? Getting "ls" is just an example, i infact want to import this … |
|
Hi guys i have an sql query string that in my view there is something wrong with it but i an handicaped since i am very new to sql so my question is, is there any way of optimizing this query string select t1.cat,t1.site from (select cat,site from news where … |
|
I am new to Qt and I'm trying to connect a remote database. QSqlDatabase db = QSqlDatabase::addDatabase( "QMYSQL" ); db.setHostName("IP ADRESS"); // local or IP db.setPort(3306); // Default port is 3306 db.setUserName("DB USER"); // example root db.setPassword("PASSWORD"); db.setDatabaseName("DB NAME"); if( !db.open() ) { qDebug() << db.lastError(); qFatal( "Failed to connect." … |
|
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 … |
|
can anyone help me in configuring the sqlite with php. I have tried changing the php.ini and enabling the extension from the extensions list. I am using the wamp for development. Please fix my error. Thanks in advance |
|
Hello, Everyone, I need your help with my code, I am trying to display the image from database to picturebox but I can't figure it out. Below is my code: Private Sub LoadImage(ByVal ind As Integer) Dim cn As New SQLiteConnection("Data Source=C:\db\QC_ASD_2013_08_09.qdb") Dim cmd As New SQLiteCommand(String.Concat("SELECT beeld_data FROM image … |
|
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 … |
|
|
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 … |
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 … |
|
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 … |
|
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 … |
|
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 … |
|
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 ) … |
|
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! |
|
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'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 … |
The End.