2,570 Topics
 | |
 | Hello, I almost forget. Last time someone recommend me a software that I could use repeatedly for sql database management that real web developer must have in exchange of the free one like xampp that often shows error. Can anyone help me fix this error? Thanks in advance, Davy  |
| | Hello everyone! I have been working on my school project and I have encountered problem linking jTable with a table in the sql server.Can anyone please help me regarding it.Please help me with the code on how to link the the table.  |
 | I have a SQL Server bank account table which contains ... ID (Identity) Trdate (Date), Description (Varchar), Debit (Money), Credit (Money), Balance (Money) Details (Varchar) I want to list a subset of the transactions between two dates (the period of an Australian Financial year) and the query below works correctly … |
| | I used below select query to select information from two tables. But it show one record. How to change this code to view all records ? select loan.loan_id, loan.customer_name, loan.total_amount, ifnull(sum(settlement.amount), 0) as 'Total Received', ((loan.total_amount) - ifnull(sum(settlement.amount), 0)) as 'Total Due' from loan left join settlement on settlement.loan_id = …  |
 | Hey new to JDBC SQL DERBY and Java so I don't know why but my Jtable only shows the columns. Here are my codes for my LeaderboardDAO class. public class LeaderboardDAO extends Dao { private static final Logger LOG = LogManager.getLogger(PlayerDAO.class); public static final String TABLE_NAME = "leaderboard"; private static … |
| | What's the current status of the API following the update to tags? For searching, can ony see: `http://www.daniweb.com/api/articles/search?query=blah` which gives the same results regardless of the query text (and the 'members' equivalent, which seems to work). Was there not a tags endpoint before? Can't remember. Anyhow, was thinking of a … |
| | Hi Guys, I need your help to create query dynamically, how to populate data value from formula in other table. Sample Below Table A ID Amount 1 50 2 40 3 50 Table B ID FormulaID VALUE X 1+2+3 Y 1-2+3 Result Expectation ID FormulaID VALUE X 1+2+3 140 Y …  |
| | Hi .. I have been asked to create a new thread rather than recurrent on old post ([url]http://www.daniweb.com/forums/thread116468-2.html[/url]), hope to get some help here... :) I would like to have a "Extract" button which then open a Save As dialog to save the file from the Database into local pc, … |
| | hey, Previously I post my question. But it wasn't helped. So I tried own and make sum query. It's not generate 0 value records. can anyone hep me ? select loan.loan_id as 'Loan ID' ,loan.customer_name as 'Customer Name' ,loan.total_amount as 'Total Amount' ,ifnull(sum(settlement.amount),0) as 'Total Received' ,((loan.total_amount)-ifnull(sum(settlement.amount), 0))as 'Total Due' … |
 | SELECT [SNAP!] FROM topics INNER JOIN members ON topics.author = members.id WHERE topics.parent = [variable from PHP] ORDER BY topics.id DESC LIMIT [variable from PHP], 10 Is what I have in pocket. I'd like to slam `SELECT * FROM forums WHERE id = topics.parent`. While keeping the functionality it already … |
| | `Unknown column 'topics.id' in 'field list'` `SELECT topics.id topicId,` [...] `topics.id` DOES exist. |
| | Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …  |
| | I have a member table from which I'm trying to create a query using these fields mem_id / username / create_date / mem_status / ref_id / qualify_id A new member is mem_status 'F' with ref_id equal to the mem_id of their referrer and qualify_id of zero When the member upgrades, … |
 | Hi Dw. What is the correct way to write an sql query like this? `"select * from MyTable where username ='username' And password ='Password'"` in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. … |
| | I have been working on this to replace every code that is shared on post in my website but is not working for me. I need everything that appear inside `<pre><code></code></pre>`to replay all the tags and give it a color using css. please if there is any simple way to … |
| | Hey everyone, I have created a PHP web application that allows people of different permissions to do certain things such as read-only, add, update, or delete. That works pefectly. However, it came across my mind that I have not done anything to prevent against SQL injection or XSS attacks. I … |
| | `INSERT INTO 'members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')` - `#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''members' ('username', 'password', 'email') VALUES ('axe', 'axe', 'weql')' at line 1` |
| | I think this is called "foreign key" and "local key" ? I have a table `users`, these users have `rank`. It's an `int`. There is a table named `rank`, this table has field where hexadecimal string is placed `FF0000`. Is there a way to `SELECT * FROM users` and `SELECT … |
| | Hey everyone, I have a question about a database design that I have right now. The template I was given from someone is the first attached that you will see. I looked at it and figured that the database design of that is not the best, so I decided to … |
| | Hi, I have a page for sending SMS by selecting anyone organization, By selecting organization, it will calculate how many customers are there to send SMS, It will display the SMS Count along with all managers names using JQUERY AJAX. For counting this value,it takes so much time in online, … |
| | Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, … |
| | I'm trying to do something, but it doesn't work out, the primary suspect is incorrect query, but I don't know whether it's correct or not. I could try running it in phpMyAdmin, but then I don't know how these are escaped. The result is: `array(5) { ["current_field"]=> NULL ["field_count"]=> NULL … |
| | i scan my invoice and i had 5 column item_no ,descrption ,qty,unit price, total Amount and ihave 20 rows i need to trans rows to excel file or .txt i need to help to make programm by vb.net or asp.net : scan the invoice then send data rows to table … |
 | Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use … |
| | Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p |
 | How do i get the most repeated value that is inserted just today from 23:59 till 00:00 i have this sql but i dont know how to filter it by date any help will be apreciated. $sql = "SELECT `MatchTitle`, COUNT(`MatchTitle`) AS `mostPlayed` FROM `matches` GROUP BY `MatchTitle` ORDER BY … |
 | hello to all! I am developing a data warhouse as my final year project. I have made my star schema succesfully. Now i want to make a query interface for end users so that they run their desired queries. But i am unable to understand that what type of interface … |
 | Probably just overlooking something small but its 5:30 am here so please forgive me. $sql = "SELECT * FROM accounts WHERE username = $testuser"; $result = mysqli_query($conn, $sql); if (!$result || mysqli_num_rows($result) > 0) { // output data of each row while($row = mysqli_fetch_assoc($result)) { echo "id: " . $row["id"]. … |
| | > i have bind 10 random post form json file in to marquee but the problem is arising , its show like list and showing as marquee works kindly check the code and the output , do some suggestion what to do . Thanks in advance <html> <head> <meta charset="UTF-8"> … |
| | Hi Guys, I am trying to make a webpage using asp.net and SQL server 2008. Just a simple page through which data will be inserted to the database. But I noticed it is taking duplicate records as wel. So I used "Unique" constraint while the respective table and it is … |
The End.