2,570 Topics
 | |
| | Hi Friend, dtpdate datetime that's my field and datatype in vb.net use dtpdate.text Error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. please solve my problem. Thanks & Regards |
| | I am passing string, but in mysql query not executed. because IN not taking integers please check and solve this one. My query not working SELECT * FROM `employee` WHERE `employee_id` IN (1001,a/bb/001,a/bb/002,a/bb/003,a/bb/004,a/bb/005,a/bb/006,a/bb/007,a/bb/008,a/bb/009,a/bb/010,a/bb/011,a/bb/012) ORDER BY employee_name ASC correct one is SELECT * FROM `employee` WHERE `employee_id` IN ('1001','a/bb/001','a/bb/002','a/bb/003','a/bb/004','a/bb/005','a/bb/006','a/bb/007','a/bb/008','a/bb/009','a/bb/010','a/bb/011,'a/bb/012') ORDER BY …  |
| | Hey I have 4 computers. 1st computer is my server machine. I want to install mysql on these computers. Can anyone help me to do that ? * I want to know how to install mysql on server pc ? * Also want to know clint machine ? |
| | I checked my spellings and everything for so many times already Here's the code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If Not cnn.State = ConnectionState.Open Then 'open connection if it is not yet open cnn.Open() End If cmd.Connection = cnn 'check whether add new …  |
 | 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 … |
The End.