2,569 Topics
 | |
| | 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 |
| | 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 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 … |
| | 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']; …  |
| | 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 …  |
| | Hello. I have created a filter result using php but it is not properly working for me when i filter result it is not showing me up with any products <form method="POST" action="product.php?cat=<?php echo $cat; ?>"> <div class="price-box"> <h5>Price</h5> <input type="hidden" name='price_range' class="range-slider" min="0" max="600" value="23" /> </div> <div id="filters"> … |
| | this code doesnt save data in db as 1 when i click on yes button.. <table id="main" class="display" cellspacing="0" width="100%"> <thead> <tr> <th>Date</th> <th>Amount</th> <th>Approve</th> </tr> </thead> <tbody> <?php $i= 0; foreach($purchaseorder as $tdata): $i++; ?> <tr> <td><?php echo $tdata['pay_date']; ?></td> <td><?php echo $tdata['amount']; ?></td> <td><td><?php if ($tdata['approve']=='1') { ?> … |
 | Hi all, I am trying to select single record from each year of last ten year. Given below is the code what I am using now. But its taking too much time to get the result. Is there any way to make it fast? $sql_cond ="SELECT Close_Price FROM (SELECT Close_price … |
| | Greetings, I read about database normalization and I knew that there are 8 normal forms to follow. I understand the 3 first normal forms, however, I did not understand the other 5 normal forms and they are: 1- BCNF - Boyce-Codd Normal Form 2- 4NF 3- 5NF 4- ONF - … |
| | developed an admin panel in which users can add products from there and I put fields over there as size and color for the dresses dresses sizes and color would be more then 1 so I made 2 more tables in the database named prod_size and prod_color here is the … |
| | Hello All, I have been working on a registration form for opencart for a while now. I think I am nearly there in how I have coded it. However I just do not know where I am going wrong with it. It is a standard form with text input fields … |
| | Hi all, Just wanted to start a discussion on a database issue that I am presented with; the issue is that I am trying to insert seed data into around 90 tables without having to worry about manipulating/disabling the foreign key constraints. The most logical solution would be to do … |
 | I'm trying to load dxf files CAD into a database for searching. Some of these files are huge with hundreds of thousand of separate entites. I've separated the file into the following tables: * drawings * layers * style * entities * points * flags * floats * text The … |
| | Following is my code effort.... I want to read first line of file(comma separated) & then create table in JavaDB but stuck here... Please someone help me how to do next???? public class DatabaseDAO { public void FileRead(String st) throws ClassNotFoundException, SQLException, IOException{ String []tokens=null; try{ try (FileReader fr = … |
| | Please i need help in writing a code showing online friends on a chatting site |
| | Hy there! I have prestashop 1.4.4.1 and i want to export database clients in CSV through Mysql. I want all the fields possible. Is possible to export their passwords also?I mean MD5. Can you please help me? Best regards, Florea Uwe  |
| | Hi, Can you guys reccomend me some good oracle sql journals? Thanks |
| | Hello, What are the different areas of databases I can focus on for my project? Thanks, |
The End.