Hi i have doubt regarding how i can exact match my database timestamp with my date i'm getting date from my URL query string which looks like this 2017-07-19 and my stored date in my database is 2017-07-19 13:40:23 Below query returns 0 results despi
How can I get data back as an array or generic list from a Firebase database in Unity3D without knowing ahead of time what the name (key) of the children are? I have been trying out the new Unity Firebase plugin, and I am having an issue figuring out
This may be a repeat question but I'm very new with pl sql so I'm going to ask it anyways. I wrote a function that is supposed to determine if a varchar2 contains all alpha characters. It is defined as... CREATE OR REPLACE FUNCTION isAlpha (al IN VAR
I'm new to here. Recently I was ordered by my boss to make a SQL Server database from a Winforms app. I'm trying to create database programmatically. But every time I'm getting an error message. Is it possible to create a SQL Server database file (.m
I have three tables: Customer(CustomerID,Name) CustInvoice(InvoiceID, CustomerID (FK to Customer), CustName) ProductOrder(OrderID,OrderDate,CustomerID (FK to Customer)) I want to write the following trigger: "Whenever there's a new order in ProductOr
Got stuck on this one, know it should be simple. But I have a list of unique IDs that looks like AB123456, XY584234, CDE987654. The last six characters mean something, so I need to find all rows that have the same last six characters as another (subs
I want to insert multiple records in one go using a single insert into statement, but this format shows errors. Is this way correct? Any other way to do it. Using oracle 11g Screens"INSERT ALL"statement you can use but still you have to construc
I have a requirement in my app where one user can send the friend request to another user. We use SQL Server database as the backend. The structure of the table is like this. CREATE TABLE FriendStatus (FriendStatusId BIGINT PRIMARY KEY IDENTITY(1,1),
Each of the salesmen should make a forecast of his sales. I know how he may input data directly from Excel sheet to SQL table. Do I need to create different tables - one table per salesman? At the end I need to aggregate all the forecasts. Is it poss
This question already has an answer here: When is SQLiteOpenHelper onCreate() / onUpgrade() run? 12 answers I'm making the app that stores a list of the user's purchases in a SQLite database in android. A problem I'm having is I can't delete any of t
I have three tables in my database. Table one effectively contains two fields: |Datetime| |Set| Table two is a lookup table which matches a number of parts of a set to a set number: |Set| |Part1| |Part2| |Part3| |Part4| I want table 3 to have a recor
I am creating a program in VB.NET which uses an online MySQL database to retrieve certain data. I have now succeeded in connecting and getting some basic stuff out of it. Now, what I want to do is that when an user presses a button it has to update t
A Team Captain must be created by an Admin. once created, a Team Captain can then create the rest of his/her Team by adding members. Does it make more sense to have a separate Team Captain table or just to assign a Team Member Role (captain or member
I have been trying to install DNN 7 but it got stucked at the first step of installation. Giving the error "No valid default database connection detected. Standard Database setup option is unavailable Database Connection Error" ERROR:Index #: 0
I'm currently taking the online standford class on databases, If you could help me solve this sql problem I would greatly appreciate it. Sorry I'm a complete noob. Table Movie: mID | title | year | director Table Rating rID | mID | stars | ratingDate
I have a database of schools, I would like to make it so that when you search the database for existing data, it outputs right next the the input box. So without going to a new page. Here's what a have: <form action=" " method="post"
Today i ask this question, but i missed something so ill describe more in this question. I have three tables: [Table1] - ID // Unique - Name - Location - Country [Table2] - ID - Unique - Table1.ID - Value [Table3] - Table2.Value - LN - Name Relations
Could somebody tell me why this isn't adding the values to the database. The form runs fine and doesn't return any errors. private void button1_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(); SqlCommand command = n
I load data from internet to build the listview, and put a star icon for each row. If user checked the star, I would save the entire row data into sqllite databse. My question is that how can I know if one item has been added to favorites before to m
I am a absolute beginner in Windows Phone Development with a basic idea in C# & Silverlight . I am building an application which will require some basic database functionality . Then , I discovered that SQL Server is not compatible with Windows Phone
For development , sometimes we need for a faster programming , the SQLite database state of our programs . But i can only extract database if it's on emulator , not mobile . Then my exactly question is ¿Is there a way to see the android sqlite db or
I know how to create random chars both at PHP and MySQL but the question is that I have to create a 4 char random string for a table of 10 thousand or so rows. What way is the best to make sure it will remain unique? I can use a longer string if I ne
am used lot of time , i know the diff between sql query and sp , SQL query will be compiled everytime it is executed. Stored procedures are compiled only once when they are executed for the first time. This is general database question But one big do
My MySQL database has carefully defined fields. Some fields, if there is a chance that they can be unknown, allow a NULL value. I'm writing a web-based CMS to handle the data in said database. Obviously, the post arrays from the HTML forms never cont
I have like 50 txt files each with around 8 columns and 80,000 records. I have written a script in Matlab that reads all the files one by one and then puts it into MySQL using a single INSERT statement for each file. However doing so is taking a huge
I really hope someone can help me with this. I'm struggling with it for nearly two days now... I have a DB-table "Device" and a table "Connection". I'm using it to visualize my company's network. To pass the data to the JS-framework I
I am using php and building an MVC for my web application. I am to the step where I need to connect to my DB, look at the current URL, compare that to data in my DB, and then return the correct content from my DB to the user. My question is, where sh
I'm working with Datamapper which allows you to specify either a path to a database file on your system or simply the string "memory" and then an "in-memory" database is used. However, I have no idea what this means. Is an "in-mem
I have a three tier system, SQL Server backend, hand written data access layer, and using stored procedures. I have a table called EventTable. Each row is an 'Event'. An Event has a primary key, and a start date. CREATE TABLE EventTable ( ID INT IDEN
Almost all of free web hosting server, you can not use PDO + MySQL. They lack PDO drivers. So I am considering to select pear MDB2, or DB_DataObject. Which do you reccomend to me? Give me your opinions!I would actually recommend using the Mysqli func
