330 Topics
 | |
 | 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 … |
| | Sqlite is a single user database application. It has many capabilities. It would be appreciated if either a link to an example, or some sample code could be shown for creating, inserting and querying a database. |
| | I am new to android programming. I tried to execute a app from one of the tutorials and it is showing runtime error. If it runs highscores menu. Application closed. Below are the error messages from logcat and the activity file. Appreciate your help. Thanks in advance. ERROR 12-15 03:49:51.124: … |
 | Importing a hierarchy of firefox bookmarks in konqueror can be tricky, as konqueror's bookmarks editor doesn't read firefox's sqlite databases where the bookmarks are stored. Konqueror bookmarks are normally stored in a file `~/.kde/share/apps/konqueror/bookmarks.xml` , which is actually a dialect of `xml` named `xbel`. I found very little documentation about … |
| | Is there are an easier way of serializing a vector attribute of an object in c++ using sqlite3?  |
| | I can serialize an object if it's class definition has attributes. So if I have an object whose class does not have attributes, do I serialize the attributes importedi in it's class definition? For example; suppose I have the following class, #ifndef BREAD_H #define BREAD_H #include "EGGS.h"; #include "FLOUR.h"; class …  |
| | Hello all, I was writing code that was supposed to spawn multiple jobs from a sqlite DB and my first idea was to implement the multiprocessing Pool function. I'm not sure if this question would be better suited somewhere related to shell scripting, but I'm not sure how to call …  |
| | Hello, The reason why im asking for this is becouse im currently making a project that needs data storage. And sqlite seems to be perfect for that matter. I've already read the documentation of Sqlite3 but i found that insufficient. It didn't really explain much besides the obvious. I can …  |
| | Hi All, I am developing an App for Windows Phone 8.1 called Transport Management System. First up am trying to use Sqlite DB with the App. I was successful in creating New DB, updating and retrieving values from DB. Now, i have tried to use existing Sqlite DB with the …  |
| | Hi guys, I'm working on my python script to create the button for tv programs. I know how to create the variable to get the program title for the programs which I have to pull the data from the sqlite database. I can also create the variable for the height …  |
| | 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 …  |
| | |
 | Hi all, it's been awhile... my prob. I have a form to order drinks in a bar, as below. <div class="col_left"> <h2> Order Your Drinks And Food</h2><br /> <form action="process.php" method="post" name="orders"> <table border="1" class="trapezi"> <tr> <th>Drink</th><th>Qty</th> </tr> <tr> <td><input type="checkbox" name="drink[]" value="p/c">Carlsberg 50cl</td> <td><input type="text" name="drinkno[]" size="2"></td> </tr> <tr> … |
 | I'm trying to catch an SQLite problem but I'm unsure how. The problem is opening a database which is password protected. No error appears to be thrown when opening a database with an incorrect or no password. I tried the following. SQLiteConnection m_dbConnection = null; try { m_dbConnection = new … |
| | I am creating an AlertDialog that I can enter a new value into a SQLite database. The Insert method works if I call it by itself in the onCreate() method, but when I try to call the method in the setPositiveButton onclick listener it doesn't work, it gives me a … |
| | We are wanting to develop a Mobile App either a hybrid App or web app. Since Usability and performance are the main architectural drivers we are thinking Hybrid App is the best approach. But it is supposed to have these features. Because of development cost for each specific platform, Developing … |
| | 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 working on my final year project. It is a web based system that is based on ASP.NET/MVC. I want to start from database but I have a little confusion which database to use from Sql, sqlite and sqlite3 that is not complicated and good for me to finish …  |
| | 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?? |
| | We'll be launching a mobile app (iOS, Android) soon. App is native with a local SQLite database. App is supposed to do scheduled database sync with a live online MySQL database connected to a PHP based backend system hosted on a Hostgator dedicated machine. App audience is expected to be …  |
| | I have created a class with few public and private functions to create an sqlite database and related operations.consists of 2 private member variables **A & B**. **Public functions:** to check whether database exists ,if exists open and read data A & B else call the 3 functions from private. … |
| | Hi am kinda new in python programing. I have this game that involves a user inputs a value , say color it iterates over imported modules( in this case color) and prints data about it. The problem is that i cant get to code the best way to iterate over … |
 | **Task:** I'm currently working on my final year project and i have to present my evaluation in 10 days. The only task which is left is to connect my android application to a database through WIFI. **Database:** I have to work on sqlite3, and currently I've Installed Navicat IDE for … |
| | i need to develope the pdf annotator and sticky note. i need to store the position of annotator and sticky note in sqlite beacuse when i reload the pdf need to show the annotation and notes. please send the sample code. |
| | This python script prints all the columns of an sqlite database which path is given as argument. |
| | Is there a pythonistic way available to search all the tables and columns of an Sqlite3 database? The only inputs would be the name of the sqlite DB file or a raw input. I am trying to write a forensics tool and want to search sqlite files for a specific … |
| | hi guys, iam workin on an application that calculate the income for certain diving centers, i using the SQLite database, i developed a database with 3 table the first one for user input, the second is to hold daily income, and the third for weekly income. i've a problem when … |
 | I am in the final stages of testing a text-based game I have been working on for several years but I am running into some major problems with my database access code and some very strange problems at that. What I am attempting to do is loop through a SQLite3 … |
 | Hello Daniwebbers, Recently I have begun a new project that will go out to the internet and fetch information off IMDb about a source of media. Now currently when I do this I use an XML file to store what I have downloaded and parsed. For each piece of media … |
 | I am retrieving data from sqlite and showing it in a listview using simpleadapter.I don't have any issues regarding Layouts.Still just for your reference : list_item.xml <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="vertical" android:padding="10dp" android:paddingLeft="10dp" android:paddingRight="10dp" > <!-- Name Label --> <TextView android:id="@+id/subject" android:layout_width="fill_parent" android:layout_height="wrap_content" android:paddingBottom="2dip" android:paddingTop="6dip" android:textColor="#421fc4" android:textSize="16sp" android:textStyle="bold" /> <TextView … |
| | 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 … |
 | The following error occurs in nexus7 android 4.4 device 12-11 12:53:15.708: E/AndroidProtocolHandler(5245): Unable to open asset URL: file:///android_asset/www/cordova_plugins.json 12-11 12:53:15.798: D/CordovaNetworkManager(5245): Connection Type: wifi 12-11 12:53:15.798: D/DroidGap(5245): onMessage(networkconnection,wifi) 12-11 12:53:15.798: D/CordovaNetworkManager(5245): Connection Type: wifi 12-11 12:53:15.808: D/DroidGap(5245): onMessage(spinner,stop) 12-11 12:53:15.848: D/dalvikvm(5245): GC_FOR_ALLOC freed 119K, 5% free 7745K/8148K, paused 16ms, total … |
 | How can I write bash script to force pre-written sql quaries and inserts into my sqlite3 DB? I am currently having to run my page in a browser and then the sqlite4 DB gets edited by php commands then I have to go back into sqlite3 and manually set everything … |
 | I'm trying to represent my data using a bar graph, the data being displayed is goodVotes, neutralVotes and badVotes on the x-axis for each of my pieces of data (records in an sqlite3 database). I wish the "bookName" of each record to be displayed on the x axis of the … |
| | HI, I created an app to add a clinc details to the sqlite3 db from xcode. the code is below. The (sqlite3_step(statement1) == SQLITE_DONE) does not execute it. I dont get an error or anything. I can't figure out what exactly is wrong.Apprecite if someone can tell me what i …  |
| | Sorry, I posted this in software development not python. How do i make an auto-incrementing column? Heres my pseudocode/sql attempt c.execute('''CREATE TABLE <tableName> ( <columnName> <auto incrementing??!!>, <columnName2> text, <columnName3> text, <columnName4> text ) ''') |
| | How do i make an auto-incrementing column? Heres my pseudocode/sql attempt How do you make an auto-incrementing ID for a record c.execute('''CREATE TABLE <tableName> ( <columnName> <aut incrementing??!!>, <columnName2> text, <columnName3> text, <columnName4> text ) ''')  |
| | 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 |
| | 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 … |
 | Hello. I am currently studying database design at my local university. They use Microsoft products there (Microsoft SQL Server 2008/2012), but we can't use them at home because of the licensing. I have two questions: 1 - Is there anything in the world of Open Source that I can use …  |
| | delete hash from users where email='emailaddress@hotmail.com'; Why is the above line not working? I want to delete the value in the hash column in the row the contains the specified email. |
| | Hey everyone, So awhile back I built a program that contained a function to merge two databases (well SQLite ones that are read in as Lists). When the first database is read in, well the file, it's read into a Binary Search Tree, while the second is read into a … |
| | Hi i'm a beginner in android mobile development. I have a question regarding sqlite(Android)... Is there a way for me to be able to import text file onto database other than making it hardcoded..? or if there's not, how can i populate my database if i have a string formatted … |
| | I am building an application that needs to access a database. I installed SQLite.net, made references to SQLite for Windows Runtime and Microsoft Visual C++ Runtime Packages. Now, how do I connect to the database? In other words, what are the Visual Basic codes? Note that I do not see … |
| | 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 …  |
| | 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 … |
| | I created a small table with one entrey with three columns but I can't get it to show up in my php code. I'm not really doing anything with the form variables right now I'm mainly focused on getting the code below that to query my SQLite DB. <?php // … |
| | I can not get a page to load from the following php program. When I load the page in the browser all I get is a blank white page. I also looked in the /var/log/apache2/error.log file and found this line -> [Sun Aug 25 21:36:37 2013] [error] [client 127.0.0.1] PHP … |
| | Hi!!! Somebody knows whats the problem???? If i remove OpenFileDialog and pass the string direct pathDiskCover = @"C:\Documents and Settings\Administrator\My Documents\someImage.jpg"; it works fine private void toolStripButton2_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.FileName = String.Empty; dlg.Title = "Open Images"; dlg.Filter = "Image Files(*.png; *.jpg; *.bmp)|*.png; *.jpg; … |
The End.