2,566 Topics
 | |
 | I want to build a mysql query to search comma-separate string with in another comma-separate string. For example : search string '1,3,5' from '1,2,3,4,5,6' What will be the mysql query? |
| | Hi, I need a help from you. I tried but I can not. Can anyone tell me how to increase the font size in mPDF, Here is the code, where I tried, require('mpdf/mpdf.php'); $mpdf=new mPDF('C','legal','10');  |
 | Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. … |
| | Hey I have a problem with execute query into sql I got an error I want to add query like sql into sql can I put query by click on new query then i execute it I need to make the same idea but without open sql I need to …  |
| | Currently I have something like this (a bit modified): function function1($param) { $ans = @file_get_contents($param); if (!$ans) return ("Failure"); return json_decode($ans, true); } Extremely straight forward. However, the `file_get_contents()` gets answer from an API, that has proven to be a little stinky boa. It sometimes answers incorrectly, or "Access Denied" … |
| | Hello, I am working on a project for online store but i am getting the error Fatal error: Call to a member function querry() on a non-object i have tried everything i can think of, please help me, i am in a bit hurry. Here's my code init.php : <?php … |
| | Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ?  |
| | Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. … |
 | Group, I'm trying to import an EXCEL table into an SQL Server Table. Although new to SQL, I've done it several times. However for the first time I'm having to import a column that is a date. I'm not sure how the EXCEL column should be formatted so that it … |
| | i have an access database with table relationships, queries and i want to convert into mysql is there any free software that can help me to do it, i searched for MySQL workbench but its not opening in windows 7 64-bit |
| | Hi all, I currently have two tables that look like this: COMMENTS +----+-------------------------+--------------+---------+---------------------+----------+ | ID | comment | profile_post | creator | created | approved | +----+-------------------------+--------------+---------+---------------------+----------+ | 1 | This is a test comment | 3 | 1 | 2016-02-26 12:26:36 | 1 | | 2 | 0 | …  |
| | hi thrr is no one who can help me this is the prog which when i run faces problem of session. [B][U]session_start(): Cannot send session cookie - headers already sent [/U][/B] pls plssssssssss help me to solve the problem below is the code any one this is simple prog but … |
| | Anybody help me ? I need a php script that will run automatically every day on Morning 09:00 O'clock. But my script not working. My script. <?php date_default_timezone_set('Asia/Calcutta'); $now = date("h:i"); $base = '09:00'; $to = 'test@mydomain.com'; $subject = 'My Subject'; $message = 'Hello'; $headers = 'From: test@mydomain.com' . "\r\n" … |
| | i am trying to generate daily,monthly,and annual report of contractor from stored data which include id,in time,out time,late in time,early out time, my project is in advance java i have used CRUD in each module,and phpmyadmin i ll be glad if i get answer of my question. |
| | I need to transform between two different database schema the same data. For example i have one table in old schema looking like this: OLD EMPLOYEE TABLE USER_ID - NUMBER (PRIMARY KEY) FIRST_NAME - VARCHAR(50), (NOT NULL) LAST_NAME - VARCHAR(50), (NOT NULL) CITY - VARCHAR(50), (NOT NULL) and i need …  |
 | Hi, I have a scenario like XYZ company is creating a User management System , which allows to purchase for different company , so based on the package the system provides options to save last three or five user password to check and the max is ten . XYZ---| Total …  |
| | Hi, CREATE PROCEDURE `FindDuplicateExpenses`(IN `strExpenseDate` DATE, IN `strProfile` VARCHAR(50)) NO SQL SQL SECURITY INVOKER SELECT PD.Code, PD.ExpenseAuthorizedRefAmount, PD.FullName, PD.ExpenseDate, PD.ExpenseNatureID, PD.Ignore_Expense, PD.Profile FROM tblExpenses AS PD, (SELECT Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID FROM tblExpenses GROUP BY Profile, ExpenseAuthorizedRefAmount, FullName, ExpenseDate, ExpenseNatureID HAVING COUNT(*) > 1) AS SUB1 WHERE PD.ExpenseAuthorizedRefAmount = …  |
| | hey , I'm at unhandled error. if you can give me help I apreciate it :) when I run software it say "connection already open". I find all, but I can't find. If Len(Trim(txtloanids.Text)) < 4 Then MessageBox.Show("Please Check Custormer ID", "", MessageBoxButtons.OK, MessageBoxIcon.Warning) txtloanids.Focus() Exit Sub End If query … |
| | I have a list of objects that having becode as string(setter,getter),i want to set the ststus as "active" for all the becodes.below is my query.but its giving exceptions as "java.lang.ClassCastException: com.rogers.tpia.model.updatetpia cannot be cast to java.lang.String".pls help me u will get appriciated. public void activateUser(List<updatetpia> act){ Session session = sessionFactory.getCurrentSession(); … |
| | HeY First I'm new to software developing side. I made some system abount money lending and some my teachers said that system good but there is wrong thing at finding profit/loss page. Therefore I want your advices guys ! :) In this system user can register new clients and also … |
| | hello guys My SQL Server doesn't restore a backup because of active connections. How can I force it?  |
| | Im making a website that works around a very basic MVC structure. I have three folders, the Model, View and Controller. I want to display the content of the database in the dropdown once the page has loaded. My view has: <div id="appCalc"> <form id="applianceCalc" method="POST" > <?php if(isset($error)) { … |
| | Hi all can you help me I really don´t know why my web app is being deformed when a message is shown I Been trying the update panel but it just does nothing when try to retrieve information from a database in access |
| | I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | … |
| | 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 … |
 | My project uses local sql database. I tried the app on a non development machine for first time. Got a message saying it was downloading required files, sql 2008 express, at a whopping 600MB+ file. Please tell me I've done something wrong, and any user of my app will not … |
| | I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id … |
 | Hi all I have a system that im working on the the code works fine it, but theres a part thats giving me issues below is the code that loops through the number of records in the table and generates the same number of update queries with the random numbers … |
 | Hello to all! I am using Sql server express 2008. Now I want to use Integtation services such as creating and executing packages. But I could not find any interface to create and execute packages in version of server which i am using. When I go to start menu > … |
| | hi..... i am searching for the query for retrieving the deleted data from the table.From the web i got "flashback" method to get the dropped table.Any one has any idea pls,help me thanks in advance |
The End.