1,079 Recommended Topics
Remove Filter  | |
 | Hi Everyone Dont know if this is the right place to ask this but i Just wanted to consult anybody of you that might have an idea on what this core dump message means. Yesterday my website is down for almost 30 min and when i called the hosting provider … Databases client-server mysql php |
| | Hello, I rebooted my server and it won't startup due to the below error, now server is not getting up, its throwing the below error and keep trying to connect to Oracle, so I am unable to access the server to free some space if its the issue as per … Databases oracle  |
| | Im working with Forms Builder. Ive built my form, when Im testing, it shows: FRM-41045::cannot find item:invalid ID. See Help>Online help for details But, online help sucks - there are only unanswered questions (forum-like site) Any help? Databases client-server oracle  |
 | Why was `INSERT DELAYED` deprecated? https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html I used to use it and it was incredibly useful. Databases mysql  |
| | I have an InnoDB table called `articles_read` with fewer than 20,000 rows in it. It consists of 3 columns: member_id article_id timestamp There are two indexes: A unique index on (member_id, article_id) and a regular index on (timestamp). It is read from fairly more than it is written to, and … Databases mysql  |
| | SAMPLE TABLE 1 =================================== product Division sales % =================================== product1 divsion1 99 product2 divsion1 51 product3 divsion1 50 product4 divsion2 98 product5 divsion2 41 product6 divsion2 40 product7 divsion3 97 product8 divsion3 31 product9 divsion3 30 =================================== Expected output 1 =================================== product2 divsion1 51 product3 divsion1 50 product5 divsion2 41 … Databases mysql |
 | HI, I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name … |
 | Hi hope you can help me. I have studied a lot to make my website using php and mysql and I know how to insert data in a table from a form, how to select and display data on page etc. Lately I got involved with wordpress which is a … Databases mssql |
 | Hi hope someone can help me Read sqlite datatable is verry slow I have a listview in detail mode with 45 columns. and a datatable to add, read, delete and update datarows with 45 colums. Only i have a problem to read the datatable and show it all in the … Databases vb.net  |
| | Hi all, I'm working on a SQL procedure to insert a row for new clients based on a template account that already exists in the database. I thought about Declaring a variable and selecting the value from the table one at a time, but with many columns needed, this seems … Databases sql |
| | Hello, I built a website on my personal server and everything work fine. But when I uploaded it on the production server there is a problem with the database - the character encoding is wrong so the text is unreadable (users submit greek words). The collation of the tables is … |
| | The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all … |
| | What is FIND_IN_SET() performance like? It it something that should be avoided at all costs? I want to search a column that consists of comma-delimited numbers for rows that contain a specific number. Databases mysql |
 | `Select * from contacts WHERE behavior = 'nice'` [SQL Clause is coming to town.](http://imgur.com/gallery/KvsXO) Not mine, [Little Bobby Tables](https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables) almost ruined Christmas. Databases sql |
 | Hello friends. Please help me to solve my problem. I am using sql server 2008. When I try to access it recieve the following error: "Cannot connect to localhost ". So my question is, how to repair sql server? Hopefully someone will be able to help me with this. Databases mssql  |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
 | Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot … Databases client-server sql |
| | I am working on a report that is requesting to count the total number of errors per element in the total row of the report for a given County. When I use the COUNT function it is taking the max value from the number of reads complete column for that … Databases sql |
 | I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, … Databases database-design mssql |
| | Hello to all! I am going to make a stock management and Point of sale for a person on Ms Excel file. Actually my client has a store of bedding accessories (e.g pillows, blankets, quilts, cushions. bedsheets and many other items).I have to maintain such an excel file that should … Databases  |
 | Help me....! Actually I have records about 1000 credit customers, My collection boys go to their door on due date(eg. 15-11-2016) for collection of money. but they have no money to pay,that's why they call my collection boy after 10 day(eg. 26-11-2016). Now, I want the query in Sql. if … Databases sql |
 | Hi, can some one please help? I want to double-click on a "customer name" in form1 datagridview and then see "customer details" of selected customer on form2.. (in ms access it called "linked forms") I use VS2012 (vb.net) and SQL database.. Thanks, Michelle Databases sql vb.net web-design |
 | I want to retrive data from two tables. I used below code : (SELECT sum(total_amount) as tr from loan where loan_status = 'not finish') union (SELECT sum(amount) as tt from settlement where sett_status = 'Active') But It load data by one column and these two values load under the another …  |
| | I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling … Databases microsoft-access  |
 | I am using the Ionic framwork for the mobile app and Bootstrap for the web app, this has been set by my University as what we have to use, so we can't change them, but is there a way to link the data base to both services? Thanks in advance … Databases client-server microsoft-access mysql php sql |
| | I had mysql database and had many tables in database. For this problem we need details only about two tables. These tables are customer and guarantor. For each customer had two guarantors. In Customer tables it's primary key is Customer_id In Guarantor table it's primary key is Guarantor_id Then I … Databases mysql |
 | Hello Group! I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office … Databases microsoft-office vb.net |
 | Hello everyone, I need to open mdf file but I can't install SQL server. Please advise how to view data in sql mdf file? Thanks in advance, Richard Databases sql |
 | this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)") Press any key to continue . . . from pony.orm import * db = Database() db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data') Databases mysql  |
 | Sir I have this query and result [IMG]http://i66.tinypic.com/4r7oee.jpg[/IMG] Now I want to modify query to get result like this [IMG]http://i65.tinypic.com/11aihzs.png[/IMG] Please help Databases mysql |
 | Hi Guys! i need some help, with recurring invoices or payments. I have Application which i developed recently to my customer. And inside of App i got a module to invoice clients, for a product, which this product is valid only for one year starting may for each year and … |
 | I have a database that I use in VB. As records update there is a lot of useless info in there because access doesn't reuse the same spots. So that information has to be removed. Before I would use compact & repair and access 2000 and it would correct this. … Databases microsoft-access  |
| | Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried … Databases microsoft-access sql |
 | I have been trying to insert,update,delete,select with separate queries.But when i try to write a query after a pre-written query i get an error that the string is predefined.I am working on a PBL project so i have to show all that in one program itself. Here is the current … Databases |
| | Hi, I was asked by my lead engineer to configure and migrate current database to elasticsearch that he believe will overcome the slow query issues . We are using laravel 5.2 , and using Amazon Web Services : Amazon Elasticsearch Service . I already done a proof of concept on … Databases client-server mysql |
 | For Each itm As ListViewItem In ListView1.Items If itm.Text <= CStr(56) Then itm.BackColor = Color.Orange Else itm.BackColor = ListView1.BackColor End If Next this codes change background color of all items in listview....but i just want to change the forecolor mu value of stocks in listview in a column stocks..not all … Databases vb.net  |
| | I have a query that get the balance for last month and current month balance. I'm using a function inside the view that took more than 30 minutes. May I ask your help guys any idea or approach to speed up the processing or optimize the script it can be … Databases mssql  |
 | I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration …  |
| | Sir I want to generate a query which will convert data from rows to columns I have this table  I want to get this result  [IMG]http://i66.tinypic.com/2hfjep4.png[/IMG] Workers amount will go to column in relevant data Group by code. I wrote this query session_start(); require_once("includes/connectw.php"); $query = … Databases mysql |
 | After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as the exact nature of the issue) I have the ibdata1 ib_logfile0, and ib_logfile1files, and all the .frm and .ibd files … Databases mysql |
 | File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), …  |
 | Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), )) |
| | Hiii I want to use select in select clause this is my statement which got an error: [code=sql]Select count(*) as cnt, (select count (answer_q1) from answers where (answer_q1 = 'ضعيف'))as a_q1 FROM Answers[/code] and this is the error: Error in SELECT clause: expression near 'SELECT'. Error in SELECT clause: expression … Databases mssql  |
| | I have Post code column and I want to get 60, 30 and 10% for each area code that I have, but the thing is there is a between statement which makes things a bit complicated. I need 60% from the first postcode then 30% from the second and 10% … Databases sql |
| | I'm not sure whether this is a good question for this forum but, I'm struggling to set up a database to use in my school academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest part … Databases mysql |
| | Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an … Databases oracle vb.net visual-studio |
 | : CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not … Databases client-server mysql sql |
| | Hi, I am developing a mobile app for a health care institution. I'd like to get a suggestion on how to approach my database design. There are many user types of this app; residents, nurse, and general-staff. The "resident" has many information that other types don't have; unit_number, food_allergy, emergency_contact, … Databases database-design postgresql web-design |
| | I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | … |
| | Hi all, I'm using the Laravel framework to create an application, and have a database question. I have a table called `posts`. I have been pulling the 10 most recent rows from here and making use of an offset variable for pagaination. Now however I also have a table `media` … Databases mysql |
The End.