Member Avatar
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 …
by Hephaestus in Web Development ()
Member Avatar
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 …
by Hendo 8 in Mobile Development ()
Member Avatar
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 …
by Odyssey2001 in Software Development ()
Member Avatar
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 …
by Niloofar24 15 in Software Development ()
Member Avatar
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 …
by Niloofar24 15 in Software Development ()
Member Avatar
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 …
by otengkwaku 30 in Databases ()
Member Avatar
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 …
by otengkwaku 30 in Databases ()
Member Avatar
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." …
by Sinan_2 in Software Development ()
Member Avatar
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??
by ziadkassam in Mobile Development ()
Member Avatar
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 …
by titos97 in Web Development ()
Member Avatar
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
by mathewmoozh in Web Development ()
Member Avatar
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 …
by renzlo 4 in Software Development ()
Member Avatar
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 …
by titos97 in Web Development ()
Member Avatar
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 …
by Morley93 in Software Development ()
Member Avatar
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 …
by wolf29 in Software Development ()
Member Avatar
How to install Sqlite in windows OS and how to customize the database table in sqlite and, Tools for sqlite working like mysql workbench.
by ganesh641 in Databases ()
Member Avatar
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 …
by thing2 in Mobile Development ()
Member Avatar
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 …
by siaswar in Software Development ()
Member Avatar
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 …
by LinaClark in Software Development ()
Member Avatar
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 …
by pritaeas 1,895 in Web Development ()
Member Avatar
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 …
by rarment in Mobile Development ()
Member Avatar
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 ) …
by elenizi in Software Development ()
Member Avatar
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 …
by lenash in Software Development ()
Member Avatar
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']; …
by TonyG_cyprus 36 in Databases ()
Member Avatar
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 …
by lancelot626 in Software Development ()
Member Avatar
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!
by TonyG_cyprus 36 in Databases ()
Member Avatar
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 …
by pynehalem in Software Development ()
Member Avatar
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 …
by romanromeo89 in Software Development ()
Member Avatar
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 …
by supreet.kaur26 in Mobile Development ()
Member Avatar
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 …
by Lius in Software Development ()