Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, help me because I’m desperate. I was running XAMPP 7.1.22 where I had said database and I decided to install XAMPP 7.2.10 without backing up the database. After that, the site wasn’t working so I figured the problem was the database. And indeed PHPMyAdmin wouldn’t recognize it. I reinstalled the …

Member Avatar
+0 forum 0

I am trying to get access toke from FB through Developer App. But I am not able to json_decode the call back response. If I use the token_url call from browser, it returns the access token. But from within the script it does work. I searched online and foun that it could be that the Json encoded response must be containg some UTF -8 BOM. So I tried some functions that would strip the response from that. However, I still am not able to get that elusive access token as a variable by json decoding and getting an array. My …

Member Avatar
+0 forum 0

Hi, I have a SQL Server (RSQL) and a SSAS Server(RSSAS). RSQL has a linked server to RSSAS, naming [LinkedCube] Here is a screenshot of my Linked Server Properties I use SSMS to connect to RSQL and then run a query that returns data from SSAS using linked server. The result set contains 100,000 rows and it took 17 seconds to return data completely. The Profiler said that MDX query duration is about 3 seconds, so it took 14 seconds to return data. The network connection has a maximum transfer rate at 100MB/sec, so 14 seconds is not acceptable. Do …

Member Avatar
+0 forum 0

Hello, my code at the minute fetches a record and splits it up into a tuple, this is so each individual element can be displayed in an entry. I am now trying to create a feature which reads what is in the entrybox and updates the record in the database. This is the current code: def Update(self): global Record global Name global TrainerID global Postcode global Age global Gender global Password (Name, TrainerID, Postcode, Age, Gender, Password) = tuple(Record) Name = self.ent_Name.get() TrainerID = self.ent_TrainerID.get() Postcode = self.ent_Postcode.get() Age = self.ent_Age.get() Gender = self.ent_Gender.get() Password = self.ent_Password.get() List = [Name, …

Member Avatar
+0 forum 0

I have 2 tables; first table Book, having book id and chapters. The second table points having studentid, bookid and hw-points for the students. I need to get results like below tabular format. Chapter 1 Chapter 2 Chapter 3 Book 1 sum of c1/B1 sum of c2/B1 sum of c2/B1 Book 2 sum of c1/B2 sum of c2/B2 sum of c2/B2 Points-table id userid BookId homeworkPoints 2 1308 673 250 3 2631 674 200 4 2631 627 175 5 2631 675 50 6 2631 647 50 7 2631 681 50 8 2631 638 50 Book-Table id Book-Id Chapter-Id 673 1 …

Member Avatar
+0 forum 0

Hi, I am following a walkthrough of [Entity Framework Code First to a New Database](https://msdn.microsoft.com/en-us/library/jj193542(v=vs.113).aspx) Everything appears to go as expected right through to the end of step 4, where it says "We can now inspect the schema that Code First created." The database shows up under data connections in server explorer, (host\sqlexpress.CodeFirstNewDatabaseSample.BloggingContext.dbo) but there are no tables in it. What might I have done wrong? Thanks for reading.

Member Avatar
+0 forum 0

Hi All, I am working on Oracle 11.2.0.3. and my requirement is, I have a table in Development(Dev) called " Dev_EMP". Have created Synosym for "Dev_EMP" as "SY_DEV_EMP" here is the structure [/code] create table Local_emp ( tran_id varchar2(10), acct_id varchar2(15) ); [/code] 2. Table which I am planning to access from Production is as below. create table c_emp ( tran_id varchar2(10), ex_ind varchar2(20), f_id varchar2(20) emp_stud clob ); [/code] Now the requirement is would like copy "ex_ind","f_id" columns from PROD to DEV table i.e"Dev_EMP" alias "SY_DEV_EMP" and load the data to these columns data from Production table "c_emp" to …

Member Avatar
+0 forum 0

i have a logical error in my code where by i will read data into my four textboxes from sql database and the textboxes will be filled but when i click on a textbox the data will appear in the metrogrid(from metro framework) but when clicking another textbox the data in the other textboxes except the one that i first clicked will disappear. i used dataset i have the same problem and also datareader, i had the same problem. please i need help. Here is the code: private void btnSearch_Click(object sender, EventArgs e) { using (SqlConnection connection = new SqlConnection(@"server …

Member Avatar
+0 forum 0

hello everyone , i have follwoing table structure check_id(pk) | user_id(fk) | check_in_time( timestamp ) | check_out_time( timestamp ) | is_checked_out(0 or 1) | checked_by | family_id now i want to calculate average of all checkIn and checkOut of user per day and then plot these data in graph this is what i have tried so far SELECT DAYNAME(check_in_checkout_time.check_in_time) as a ,DAYNAME(check_in_checkout_time.check_out_time) as b , ROUND(AVG(MINUTE(TIMEDIFF( DATE_FORMAT(check_out_time, "%h:%i:%s") , DATE_FORMAT(check_in_time, "%h:%i:%s") ))),0) as timediff FROM check_in_checkout_time WHERE check_in_checkout_time.checked_by =? this give result as a: wednesday b : wednesday timdiff: 14 and so on but does not give avgerage of all …

Member Avatar
+0 forum 0

Hi! I have here data: i don't have any idea on how to insert the details in TABLE2... as you can see, the parent_id is based on TABLE1, TABLE 1 TABLE 2 (INSERTED IN NEW TABLE) LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1) 1 NODEB EQUIPMENT 1 NODEB 2 NODEB_RADIO_MODULE NODEB 2 NODEB_RADIO_MODULE 2 1 2 NODEB_SYSTEM_MODULE NODEB 3 NODEB_SYSTEM_MODULE 3 1 2 NODEB_RADIO_MODULE NODEB 4 NODEB_RADIO_MODULE 4 1 3 NODEB_IF_CARD NODEB_SYSTEM_MODULE 5 NODEB_IF_CARD 5 3 3 CLOCK_PORT NODEB_SYSTEM_MODULE 6 CLOCK_PORT 6 3 3 ETHERNET_PORT NODEB_SYSTEM_MODULE 7 ETHERNET_PORT 7 3 3 ETHERNET_PORT NODEB_SYSTEM_MODULE 8 ETHERNET_PORT 8 …

Member Avatar
+0 forum 0

i'm trying to find in all tables with data in all columns.. example EMPLOYEE table with ID = 123 COLUMNS DATA ID 1 NAME TEST ADDRESS TESTADDRESS PHONE EMAIL POSITION DEV The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only.. by the way, i can't rely on NUM_DISTINCT in USER_TAB_COLUMNS..

Member Avatar
+0 forum 0

hi everyone i am new programer in oracle,i have save the url of the folders in the SQL server and i want to open or select a folder using the saved url by oracle plsql. I have select the url from the database, but the problem i don't know how to open the folder using this url. I search alot but I find only how to open file not folder. please help me thanks for your listening....

Member Avatar
+0 forum 0

hello, i have one table in sql server and i made a form to editing this table from. so when i click edit in the table .. it takes me to the editing form with the chosen id .. what i need is to show all other feildes in the form that related to the chosen id ???!! any help ?

Member Avatar
+0 forum 0

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 great CMS. The only problem is so different and is driving me nuts, also because I find no help in the various tutorials online. I have some simple questions. 1)Can you tell me how to insert data into a tablepress table from a form (my site is about hotel booking)-2) …

Member Avatar
+0 forum 0

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 three records. Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160101 20160103 20160104 Robot 20160101 20160104 20160105 select salesorder.unitid "Unit",max(salesorder.eventdate) "OrderDate",max(salesdelivery.eventdate) "ShipDate",max(salesreceipt.eventdate) "ReceiptDate" from (select eventdate,unitid from sales where event='ORDER' and eventdate>'2015-12-31' and eventdate<'2016-02-01') salesorder left outer join (select eventdate,unitid from sales where event='SHIP' and eventdate>'2015-12-31' and eventdate<'2016-02-01') salesdelivery …

Member Avatar
+0 forum 0

Not sure if this is the right place for this, if not, please remove. I'm an Admin for a very large SAP landscape which includes variety of DBs. I've been evaluating the Xandria product from syslink ([www.syslinkams.com](http://www.syslinkams.com)) and so far been very impressed. I was wondering if anyone had any good/bad expereince.

Member Avatar
+0 forum 0

`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.

Member Avatar
+1 forum 0

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 district instead of actually tallying the errors in the column. When I use the MAX function it is just placing a 1 there but not actually adding the errors either. Also when using the SUM function, it gives me the same values as the COUNT function. Here is what I …

Member Avatar
+0 forum 0

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 localhost using homestead for small data but somehow , i stuck when it deal with huge data . We have 16 Gigabytes of data and more than 23,000,000 of rows (few tables) . The question is , how to migrate such big data to elasticsearch . Any feedback were very …

Member Avatar
+0 forum 0

Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to avoid logs being generated while performing these deletes. Thanks, Aravind

Member Avatar
+0 forum 0

Hello. Allow me to apologize in advance regarding any abnormal phrasing. There is a certain table, hereby dubbed IPT, containing 4 keys and a variety of values. I wish to select several values spread throughout IPT, anchored via the first three keys and a varying fourth. Currently, this is achieved by individually inner / left joining each required instance of key_4. Problem is, a test case with 30 such instances takes a minimum of 10 seconds, despite a low explain cost (1 per nested loop). The real query has 40 tables, about the same cost as in the technique described …

Member Avatar
+0 forum 0

Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: <fruit> <fruit> <name>Orange</name> <variety>Valencia</variety> </fruit> <fruit> <name>Apple</name> <variety>Fuji</variety> </fruit> <fruit> <name>Lemon</name> <variety>Eureka</variety> </fruit> </fruit> And the SQL: CREATE TABLE IF NOT EXISTS `tmp_fruits`( `name` VARCHAR(50) NOT NULL, `variety` VARCHAR(50) NOT NULL ) ENGINE = MEMORY; LOAD XML LOCAL INFILE 'data.xml' INTO TABLE tmp_fruits ROWS IDENTIFIED BY '<fruit>'; SELECT * FROM …

Member Avatar
+0 forum 0

Hi I have a procuder which return a recordset using cursor in output what am trying to do is i use cursor to get the data and same have to return it to output cursor .I can do like below PROCEDURE test(value_one IN someTabel.somecolumn%TYPE, valu_two IN someTabel.somecolumn%TYPE, Outputcursor OUT SYS_REFCURSOR) IS mydeclaration goes here output_value_one sometable.somecolumn%Type; --- cursor test_select is select statement begin for val in test_select loop fetch test_select into output_value_one; -- I want my cursor outputcursor to be return instead of output_value_one end loop; end;

Member Avatar
+0 forum 0

I have been trying two save data into mysql database using hibernate but it have been giving me an error. Could someone give a solution to this. Following is the servlet code and hibernate configuration servlet package ac.ke.schoolsystem.controllers; import java.io.IOException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import ac.ke.schoolsystem.enumerators.ClassEnum; import ac.ke.schoolsystem.enumerators.Gender; import entity.ClassBean; /** * Servlet implementation class AddClass */ @WebServlet(name="AddClass", urlPatterns="/add_class") public class AddClass extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public AddClass() { …

Member Avatar
+0 forum 0

Hi, When I use the code below, the data is written to the detail section, but only shows in the design mode. How do I get the data to display on the report? Dim stDocName As String Dim db As Database Dim rs As Recordset Dim rs2 As Recordset Dim sSQL As String Dim fld As DAO.Field ' recordset field Dim txtNew As Access.TextBox ' textbox control Dim rpt As Report ' hold report object Dim lngTop As Long ' holds top value of control position Dim lngLeft As Long ' holds left value of controls position Dim location As …

Member Avatar
+0 forum 0

1. Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into interactive, actionable information that can be accessed offline or online, from applications, portals and mobile devices. Website: http://crystalreports.com/ 2. Jaspersoft Reporting Jaspersoft reporting and analytics is famous as timely, actionable data inside apps and business processes. Jaspersoft Business Intelligence reporting software takes information from one or more data sources and …

Member Avatar
+0 forum 0

I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 is child of 3 then 8 is child of 4 and so on ...... I Want to Create a Downline in above Structure. Please Help me. can any body help me

Member Avatar
+0 forum 0

Total VBA novice, trying to do some simple file modifications in excel via access. I need help navigating to the bottom row in excel to do some copy/pasting. Getting an "application defined or object defined error", marked by the "#" below. Please help! Sub MRFDATAIMPORT() Set xlApp = CreateObject("Excel.Application") With xlApp xlApp.workbooks.Open "C:\Users\xxxxx\Desktop\Account Book\ACCESS Version\Test Folder\Book1.xlsx" xlApp.Visible = True xlApp.Sheets("Sheet1").Select xlApp.Columns("A:A").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("C:C").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("F:G").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("G:M").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("H:I").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("I:M").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("K:M").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("L:AG").Select xlApp.Selection.Delete Shift:=xlToLeft xlApp.Columns("A:A").Select xlApp.Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove xlApp.Columns("H:H").Select xlApp.Selection.Cut xlApp.Columns("A:A").Select xlApp.Activesheet.Paste xlApp.Columns("C:C").Select xlApp.Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove xlApp.Columns("C:C").Select xlApp.Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove …

Member Avatar
+0 forum 0

I need some help in getting the table headers to sort the data populated to a table in MVC. I have implemented search functionality in which the user can filter whatever results by typing a name, but I need to also get the table headers to sort the information as well. I have found similar answers on other sites but when trying to apply them, nothing works. The table headers appear as links but don't sort anything when clicked. I'm not sure what I'm doing wrong. (Please ignnore the commented out stuff, I'm trying different approaches) The current code I …

Member Avatar
+0 forum 0

Hello, i am new to storm and stream data. I have implemented a sketch algorithm in java with maven. The algorithm has as an input a continuous stream of integers. The result is an array of integer frequencies and i want to run some queries on that array, but i don't have any idea how it will be done. Will it retrieve the result array from the topology and run on it from a java program?Will i use the maven sql plugin or something like Trident? Any kind of help would be extremely appreciated :)

Member Avatar
+0 forum 0

The End.