Given a specific DateTime value, how do I display relative time, like 2 hours ago 3 days ago a month ago etc...? ...
I'm coding a plugin. One particular file of this plugin is supposed to pull data from the plugin's custom DB table, and output it with minimal processing as raw XML. The problem is, to get the WPDB class to work when the file was opened directly, I had to add a ...
I want to read an file of 1.5 GB into an array. Now, as it takes long time, I want to switch it to some other option. Can anybody help me, If I preprocess the byte file into some database (or may be in other way) can I make it ...
I am new to Android programming and am trying to understand the best practices. I want to do multiple inserts into two different database tables, but as one transaction (as the tables shared a foreign key). I want my function to return a result so that I can display a Toast ...
This is for a library management system. I have two tables, one is Books with fields BookId, Title, AuthorId, PublisherId, ISBN, ISBN13, PublishedOn, NumberOfPages, etc etc. Other is BookTransactions that contains all the transaction of books that are issued to, or received from any student, with fields TransactionId, BookId, IssuedOn, IssuedTo, ReceviedOn, ...
I am trying to run a code to insert rows from one table using rows from a different table on a different database. I had this: INSERT [testDB].[dbo].[table1] SELECT * FROM [sourceDB].[dbo].[table1] LEFT OUTER JOIN [testDB].[dbo].[table1] ON [sourceDB].[dbo].[table1].[PKcolumn] = [testDB].[dbo].[table1].[PKcolumn] WHERE [testDB].[dbo].[table1].[PKcolumn] IS NULL However I was told to add correlation names so I made this: ...
I need to update a table from a temporary table. Therefore I need to compare and find out what lines are not in the main table to be imported from the temp table. My tables look like follows, line_id -> nvarchar(20) order_no -> nvarchar(20) line_no ->int Both tables have same fields but the temp table ...
So I am working on a sample database project. I have a LoginController.php, a Faculty database, and a login page (phtml). I get the error Fatal error: Class 'Faculty_DB' not found in /usr/local/zend/apache2/htdocs/InternProject1/application/controllers/LoginController.php on line 25 In the LoginController.php I have the following (plus some more): public function indexAction() { $login = ...
Again, I need someone's help. I am following the below tutorial for SQLite connection with FMDB wrapper: http://www.icodeblog.com/2011/11/04/simple-sqlite-database-interaction-using-fmdb/ In the above tutorial, everything (creating a database and table, inserting, deleting) is done programmatically but everything works fine in simulator but when I use SQLite Manager add-on to make any insertion ...
I am using PostgreSQL 9.1 with PostGIS 2.0.1. The type of column location is point. type of latitude and longitude double precision. Why is this update statement update list_of_location SET location = ST_SetSRID(ST_MakePoint(longitude,latitude), 4326); returning LINE 1: update list_of_location SET location = ST_SetSRID(ST_MakePoint(longit... ...
I'm making a game and so far i have a members table setup with working login/register. The game is going to be a 2 player game where the user picks a country. The database structure will need to keep track of country, states or provinces in that country, population. What I ...
I have a private wiki running in localhost. I use mediawiki 1.19 and I have to insert nearly 100 pages in mediawiki's database. I've tried pywikipediabot but it doesn't work, I've got trouble about login. I've spend few hours without find where is the problem. I've tried the mediawiki bulk creator, when ...
I'm trying to connect to a MySQL server via VB.NET, but my program keeps freezing on the con.Open() line. Imports System.Data.SqlClient Imports System.Data .... Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString = ...
When a user signs up on my website I create a user record in the database with email_sent = 'NO'. I then have a cron job that sends welcome emails every few minutes. It selects all user records where email_sent = 'NO' and sends the welcome email. If the ...
i want to use database in my application, but i dont want to add a prerequisite like sql server express with high size (i.e. 100 MB) in my final setup file, is there any way to use sql server without installing the express version or should i use another database ...
i have 2 databases one i load to a datagridview and one i use the OleDbDataReader to get the data from. i want to update the database that i load to the datagrid view based on changes i do to the other database using access like changing a cell value in ...
I tried to call this method from multiple threads trying to get the ID from the same string. I am always getting this exception at the line where I create the SqlDataReader: There is already an open DataReader associated with this Command which must be closed first. I ...
I want to do a PDO request that will get informations from 2 different tables, but things fastly get hard, i explain : I have a first database table (flowers) that is organized like this (but it's REALLY bigger than what I show to you) : ID; ...
I've found many tutorials on using SQLite databases in iOS, but haven't found anything that directly references .sql files. Can anybody tell me how I can link an existing SQL database to my app? ...