11 Topics
 | |
| | 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'm starting my Computing project and am using Python linked via sqlite3 to a database. As part of my project I shall be searching for maths books in the database via name or module etc. I wish to display the results on a GUI in python so need to set …  |
 | I have a very small sqlite3 database with one row consisting of three columns but I can get the page to display the row to save my life. So far all I've been able to get the page to display is the first column of the one row that's in … |
 | Explore Python's sqlite3 database module, create, write and read a database file. |
| | 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 ) …  |
 | 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 … |
 | Hi there, my name is Stéphane, i'm french and a beginner with Python... I've registered on a french forum about Python to ask a question regarding an issue i have with a code, but it seems the members of this forum are not active. I paste the message i posted … |
| | 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 … |
| | 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 … |