6,934 Topics
 | |
| | 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)) { … |
| | So i have been searching all the net but haven't exactly found what I'm looking for and I'm starting to believe that it is impossible. The problem is that I have a local MS SQL Server stored on my notebook. What I would like to do is an android application … |
| | 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 | … |
| | hiii frnds i am work in vb.net windows application now in sql empid field is Unique (primary key) that how can i impliment and handle Empid manually  |
| | 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 |
| | Hi Guys! im making a small website based around a very simple and basic mvc pattern (in this case just seperating files into different folders) Im currently stuck on selecting data from the database and displaying it. My model looks like this: <?php require_once('../Controller/config.php'); class Readings { public $dbconn; public … |
 | I m in the process of creating a sql table which acts as a stafflist that has several columns like name , number , email and delete. One webpage on the website gives out the rows of this table and i would like to have a clickable link in the … |
| | please i need to query 2 tables at once and display the content in table. here is the code: <?php include 'database.php'; $pdo = Database::connect(); $sql = 'SELECT producs.*,validation_superviseur.* FROM products ORDER BY product_id DESC ,validation_superviseur ORDER BY id DESC'; foreach ($pdo->query($sql) as $row) { echo '<tr>'; echo '<td>'. $row['cat_id'] … |
 | Hi Everton one, I have the following search statement that works great, But what I would like to do is expand this to include multiple LIKE '%$search%' $STM = $dbh->prepare('SELECT * FROM tblname WHERE col=:lsecure'); $STM->bindParam(':lsecure', $search); $STM->execute(); $count = $STM->rowCount(); $results = $STM->fetchAll(PDO::FETCH_ASSOC); What I would like to do … |
| | I have a text area that I want a list to be entered. I am trying to seperate each list item and put it into a seperate sql entry. Could some one tell me what I am dong wrong? error_reporting(E_ALL); ini_set('display_errors',1); $textarray = explode("\n",$textarea);if(isset($_POST['textarea'])){ $textarea= $_POST['textarea']; $q = "INSERT INTO … |
| | i need help. my teacher told me to create a program on java gui that can send everything you input to notepad. then when you input another info in java gui. another notepad file should be made.. |
| | I'm making money lending system. In my database there are two mysql tables which are custormer AND income. All custormer info stored in custormer table. When I give loans these loan details stored in loan table. After I received loan amount from custormers(daily payments) these records stored in income table. … |
| | Hello, currently on one of my development servers I have SQL Server 2014 installed, the problem I HAD was that when I executed any of my PHP sites connected to various databases I was getting `SQLSTATE[HY2000][2002] Connection was activily refused...` I fixed that error by forwarding the port through the … |
 | Hello guys, im trying to learn how to use dynamic data table, which means i want to use data table as my searching result table. but i dint know how to make it because when the search result filled in the table, the sort and other "DataTable" function is not … |
| | Hello, please check the attachment for details. What i need is : The sum of all the full_trade_amount for that route The list of routes that share a customer with that route The number customers shared with that route The number of columns with data can vary so a route … |
| | i try to use phpoffice/phpexcel to do this but i haven't an idea of do it... i have this form in html <body> <div align="center">ELENCA TABELLE PRESENTI NEL DB</div> <form action="index.php" method="post" enctype="multipart/form-data"> <table> <tr> <td> Filename: </td> <td> <input type="file" name="file" id="file"> </td> </tr> <tr> <td colspan="2" align="right"> <input … |
 | |
 | Hello I have VB.NET System ; I wanna to make setup (.exe) for the program. The Program depend on SQL Server Database. How I can make it exe file with the database, and to install all the configuration on any PC. What I shall do according to the connection string … |
| | My php file connnects to my sql database , following code works <?php $servername = "globalxxx.com.mysql"; $username = "globalxxx_com"; $password = "YS4xxx"; $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully" $sql = "SELECT Id, FirstName, LastName FROM … |
| | Hi, I hope I've posted this in the right place, please just tell me if not. I've been having an issue with connecting to a database from a website and have recieved this as an error message: *Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] … |
 | hi im attempting to get all selected checkboxes to show in a database column. But ive tried adding a sql string for database to the code below to add the selected to database but nothing is coming up. where is it best to add the string <?php $aDoor = $_POST['formDoor']; …  |
 | Hello i want to make like button so i need to `INSERT`, `SELECT` and check does already exists the record i have this code: **likes.php** <?php require 'connect.php'; require 'core.php'; require_once 'functions.php'; $user = getUserData('users', 'UserUsername'); if(isset($_GET['type'], $_GET['id'])){ $type = $_GET['type']; $id = (int)$_GET['id']; switch($type) { case 'ticket': $sql = … |
| | hi, i just want to ask if you have any idea how to update / edit records inside mysql database using textboxes and listview. if i selected a record on my listview the details should also be in the textbox and can be updated, if the user clicks the save … |
| | [B][U]Following I am mentioning step-by-step procedure to create database connection to the asp.net website textboxes via C#.[/U][/B] 1: Open visual studio 2005 and from FILE select NEW-> WebSite, then from pop-menu select asp.net website (Note: Language must be C#) , then press OK. 2: Now create three textboxes from the … |
| | hi i have followed a online tutorial to replace photo system on my site and all went well till i attempt to upload photo i get no file selected even if i have just gone on the page but after pressing submit i get a success message and the photo … |
| | hi i got another syntax error in a script that i am fixing to add onto my main site can someone take a look to see whats going off this error is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version … |
| | hi i managed to change my site from mysql to mysqli with all your help although i have one line thats causing me problems in inbox.php can someone check this out and see whats wrong the error im getting is Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given … |
 | Hello Community, I was wondering if there is a way to get a posts comments within a Facebook group? I have tried using https://graph.facebook.com/{POST_ID}/comments?access_token={ACCESS_TOKEN} but all it returns is Array ( [data] => Array ( ) ) even though there are comments on my post. |
| | Hy there! I have a strange error to my prestashop. If I deactivate the module block contact without container the whole theme for mobile is ruined....Please see photo https://www.dropbox.com/s/1pst1w9ivuw4v3a/2016_01_03_12.25.10.png?dl=0 The error appears only to mobile and tablets. For desktop everything is okay. The same problem I get if I activate … |
 | I try to make a query and it works well, but when i put it in a stored procedure.I can't figure out whats wrong with my code. It says **Procedure or function has too many arguments specified** Stored procedure code ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- … |
| | I have a working search database and it's query code says $criteria = $_POST['criteria']; $query = "SELECT * FROM table WHERE field LIKE '%".$criteria."%' Order by Appeared asc"; but I want it to omit results that contain the word but are more then the word example the criteria might be … |
| | Hi, I was hoping I can get some help. I've been searching and searching for a lightbox that works with SrcSet so I can display different images based on viewport width. Most to which I have found; don't support SrcSet but presentation wise, are exactly what I want, somewhat a … |
| | this is my code $sql = "SELECT * FROM `sale_history` WHERE `date` BETWEEN :fromdate AND :todate"; $stmt = $PDO->prepare($sql); $stmt->bindParam(':fromdate', $_POST['fromdate'], PDO::PARAM_STR); $stmt->bindParam(':todate', $_POST['todate'], PDO::PARAM_STR); $stmt->execute(); $total = $stmt->rowCount(); while ($row = $stmt->fetchObject()) { echo "$row->date"; echo "$row->product"; echo "$row->username"; echo "$row->quantity"; } but its not working, where is the … |
 | Greetings, I have a database creation script. I've run the script after changed the path within the 'FILENAME' option to create the database on an external hard disk and I was able to see and select data from tables as the script run with no errors. However, when I tried … |
| | When I login same script works for first user but for other user, it gives error in connection. More over i want to fetch data from database Main File is <?php include_once("../init.php"); validation_check($_SESSION['SID'],MEM_HOME_ADMIN); $msg=''; $dir ='../'.USER_PIC; $sId = $_SESSION['SID']; $query = mysql_query("select * from user WHERE user = ".$sId) or …  |
| | <?php if (isset ($_POST['submit'])) { try { $picture = "../images/default-picsss.png"; $sql = " INSERT INTO user (username, password, fullname, address, mobile, email, picture) VALUES (:username, :password, :fullname, :address, :mobile, :email, :picture ); INSERT INTO user_balance (username) VALUE (:username); "; $stmt = $PDO->prepare($sql); $stmt->bindParam(':username', $_POST['username'], PDO::PARAM_STR); $stmt->bindParam(':password', $_POST['password'], PDO::PARAM_STR); $stmt->bindParam(':fullname', $_POST['fullname'], … |
The End.