- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 6
- Posts with Upvotes
- 5
- Upvoting Members
- 4
- Downvotes Received
- 6
- Posts with Downvotes
- 6
- Downvoting Members
- 5
- Interests
- - Football (Soccer)-- Favorite Team: Chelsea FC- Australian Football League (AFL)-- Favorite Team: West…
- PC Specs
- - Dell Inspiron 9400- Windows 7 Ultimate
85 Posted Topics
 | in your link tags, just do exactly what [B]musthafa.aj[/B] has said. [CODE=HTML]<li><a href="#">Electronics</a> <ul> <li><a href="electronics.jsp?value=Mobile">Mobile Phones</a></li> <li><a href="electronics.jsp?value=TV">Television</a></li> <li><a href="electronics.jsp?value=AirCon">Air Conditioners</a></li> <li><a href="electronics.jsp?value=Photo">Photo & Optics</a></li> <li><a href="electronics.jsp?value=AudioSys">Audio Systems</a></li> </ul> </li>[/CODE] In your electronics.jsp file, make sure that you have the following; [CODE=JAVA]if( request.getParameter("value") != null){ String electronicType = ""; … |
| | Hey Guys, I've got a question that's gotten me stumped. Granted, i've been away from MySQL and daniweb for well over 18months, i've picked up pretty much where i left off back then, and am just filling in the blanks as i go along. **My question is:** i have a … |
 | [CODE]String temp = RS.getString("FirstName"); if(temp.isEmpty()){ out.println("...."); }else{ out.println("...."); }[/CODE] I'm a bit rusty, but give it a whack |
| | Hey Guys, I'm just trying to set up my Virtual Host file to set up an alias URL. I've configured my Windows\System32\drivers\etc host file to include the following: [CODE]127.0.0.1 internal.test[/CODE] this works well, however I want to be able to do the following: Have this: [B][U]internal.test:8080/Test/[/U][/B] Look like this: [B][U]internal.test/[/U][/B] … |
| | G'day guys, Given that I am (sort of) new to javascript I have the following code; [CODE]<html> <head></head> <script type="text/javascript"> [INDENT]function insertBold(tArea){ [INDENT]var unselectedText = tArea.value; var selectedText = tArea.value.substr(tArea.selectionStart, tArea.selectionEnd); var v = "[B]" + selectedText + "[/B]"; var temp_array = tArea.value.split(selectedText); tArea.value = v;[/INDENT] }[/INDENT] </script> <body> [INDENT]<textarea … |
| | |
| | Hi Guys, Back again. I'm having an issue with my java with mysql. I have the following query generated through my java, which reads in about 3k records from an excel file and churns out an sql query for me. For the purpose of this forum, ill show the first … |
| | Hi Guys, Please find below a copy of my code for the issue that I'm having. So, before you have a look at the code and inevitably laugh at something silly that I've done (because I have a feeling that it would be), I should explain what my problem is. …  |
| | Hi Guys, Okay, my question goes like this.. I have two sections which start off as hidden (display: none) and depending on the values submitted the two areas may need to be shown. For example, if a checkbox is clicked, it displays one area. And if a specific <select> option … |
| | Hi Guys, I'm having an issue with my sum() function on my queries. My DB has 3 tables 1. plans 2. handset 3. matrix [B][U]plans;[/U][/B] - planNum - planCode - planName - planLength - simRebate - commission [B][U]handset;[/U][/B] - handset - RRP [B][U]matrix;[/U][/B] - planNum - handset - subsidy The … |
| | Hey guys, In my DB, i've got appointments set, and i need to select all appointments which are an hour or less away. For example i want to do something to the following (Dont worry, i know this wont work as is) [CODE]SELECT * FROM timetable WHERE time has one … |
| | Hi guys, I've got a small problem, though I have a feeling that it will be simple to fix. I just cant figure out how to do it! I'm currently running XAMPP/Tomcat as my web server, and having developed the site in JSP/JAVA, the only way i can access the … |
| | G'day Guys, I've been scouring the internet to try and find some ideas on how to set up a web-server on my work machine's HDD. I'm currently developing a web-app as a ERP/CRM system. It's almost complete, and I want to set up a web-server for our employee's to access …  |
| | Hi Guys, I've got a problem where as I attempt to output, i get thrown a Null Pointer Exception. I can read the values for [B][I][U]orders[0][/U][/I][/B] but nothing after. The DB is intact, and i get thrown the results as per the query generated in my code, so thats not … |
| | G'day guys, My boss has just asked me to develop a small CRM system. Now, writing a simple SQL Insert is not something im a stranger to, however for some reason i cannot seem to get this working. I've included all necessary libraries, and tested the actual sql statement in … |
| | G'day, I just want to ask how could i run a set up for a MySQL DB through Java. For example, when installing the application, I need to check if MySQL is installed, and if not, install it. OR, how would I go about checking for a registry for mysql …  |
 | Re: Getting started If you want to learn SQL, i personally would recommend using WAMPServer or XAMPP for running on a windows OS. This includes your apache server and MySQL |
| | Re: SQL Query wanted [CODE]SELECT * FROM tablename WHERE iss_date <= 2010-06-15 ORDER BY item_code, aa, bb, cc[/CODE] This query will return all records from the table where the date is LESS THAN a given date, though is inclusive of the date given. |
| | Have you tried to redownload XAMPP? The file may have been corrupted during download, and hence was not properly extracted. You could also try using WAMPServer which is more or less the same as XAMPP, however you will need to download an aditional jar for TOMCAT support |
 | Re: Help in JOIN G'day vibhadevit, First off, there is a flaw within your database design. [CODE]CREATE TABLE `subject` ( `subjectID` int(11) NOT NULL auto_increment, `subjectName` varchar(255) NOT NULL, PRIMARY KEY (`subjectID`) ) ENGINE=InnoDB; CREATE TABLE `student` ( `studentID` int(11) UNSIGNED NOT NULL auto_increment, `studentName` VARCHAR(255) NOT NULL, PRIMARY KEY (`studentID`) )ENGINE=INNODB; CREATE TABLE … |
| | i think you will need to provide a full mysql dump for us to properly look over your tables and query. If you could post the full sql dump, it would be much much more helpful  |
| | Instead of using MyODBC 3.51 use [B]MySQL JDBC Driver - mysql-connector-java-5.1.6-bin[/B] Then use the following servlet code: [CODE=JAVA] import javax.swing.*; import java.sql.*; public class Database { private Connection connection; private static String databaseName = ""; private static String databaseUsername = ""; private static String databasePassword = ""; private static String … |
| | you may be getting the out put of 0 because $sig is not what is expected. [CODE=PHP]<?php include_once "secure/dbconfig.php"; //check md5 $SECRET = 'xxxxxxxxxxxxxxxxxxxxxxxxx'; // I think that the php syntax for concatenation is to use the . not the + $sig = md5('userId' . ":" . 'appId' . ":" … |
| | take a look at this thread [URL="http://www.daniweb.com/forums/thread283954.html"]Sun Certified MySQL Associate - Material[/URL] download the file attached. It should help you. There are plenty of php tutorials which cover registration and login pages. here's one that i just found. not sure how good it is though [URL="http://www.x-code.com/vdaemon/samples/registration.php"]http://www.x-code.com/vdaemon/samples/registration.php[/URL] |
| | [CODE]SELECT prodmanage.user.id, prodmanage.widescreen_user.user_id, prodmanage.widescreen.name, prodmanage.user.username, prodmanage.user.password, prodmanage.widescreen.location, prodmanage.widescreen.serial_no, prodmanage.widescreen.last_access_date, prodmanage.widescreen.status, prodmanage.widescreen.proprietor, prodmanage.widescreen.phone, installation.install.id, installation.install.installer, installation.install.widescreen_id, prodmanage.widescreen.id, installation.install.install_notes, installation.install.status FROM prodmanage.user, prodmanage.widescreen_user, prodmanage.widescreen, installation.install WHERE (prodmanage.user.id = prodmanage.widescreen_user.user_id) AND (prodmanage.widescreen.id = prodmanage.widescreen_user.widescreen_id) AND (installation.install.widescreen_id = prodmanage.widescreen.id) ORDER BY prodmanage.widescreen.name ASC[/CODE] I find that a lot of people seem to make the …  |
| | [B]@tesu[/B] - You said that is important to group by all attributes which are not part of an aggregate function. Why exactly is this?? Its just that I haven't heard of this rule of thumb before. Thx |
| | G'day, Hopefully someone here may be able to help me solve my little dilemma. I have a check box set up, and along side it i have a text input. When a user enters a value into either text field i'd like to automatically check the given checkbox. If someone … |
| | G'day, I was wondering if anyone here knew how i could convert java output to a formatted PDF file? If anyone knows of a reliable open-source project it would be much appreciated. Thx, TC  |
| | Could you please post your create table statement so we may get a better understanding of your table structure Also, are trying to store the image itself, or the url to the image? |
| | Could you please provide the table structures in the CREATE TABLE format in the future. This will help is to understand your tables much easier. Also, please use the [ CODE ] tags in future. As for your problem; Could you please provide more information as to what is happening … |
| | G'day, I'm just looking to clean up some of my code as i know that at the moment it doesnt follow the best practices. I have the following function which calls my database() class. I know that i need to close my connections and statements im just not too sure …  |
| | G'day, I've got a small problem. As all who post here usually do. I've got my table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` int(11) NOT NULL, PRIMARY KEY (`attID`), UNIQUE KEY … |
| | If you use the appropriate [B]ORDER BY ... DESC/ASC[/B] you can get the top 5 and bottom 5 from the column you wish. ALSO, mysql does not limit your query usage to having a minimum number of rows in a table [B]GETS TOP 5:[/B] [CODE]SELECT * FROM tableA ORDER BY … |
| | 1. [B]SELECT * FROM `pipeline_commision' WHERE `DatePaid` IS NOT NULL;[/B] 2. [B]SELECT * FROM `pipeline_commision' WHERE `DatePaid` IS NULL;[/B] As for number 3, in your PHP do you want to simply iterate through each of the pipeline/commission for each of those? |
 | WOW. Before i even TRY to salvage this.. can you please tell me why it is that you have 15 of each items?? With most of which being empty in your table??? [I]I will help you[/I]. but please [B]explain [/B]why it is that you have made such an [I]utterly horrible[/I] … |
| | G'day, Before i start, i have to admit that I'm out of my element when dealing with javascript! I've been developing a site for a travel agency, and opted to use some of the UI elements which can be found in jQuery. The problem is however, that when I move … |
| | Could you please provide full create queries and table dumps. Sorry, its just that im too lazy at the moment to go through all of your tables to try n figure this out. Cheerz |
| | G'day, I've got my SCMA tomorrow morning, and I thought i would post up my notes. These notes are intended as a general tutorial/guide for MySQL. [B]It covers the following topics:[/B] [B]Section 1: Theory, Terminology and Concepts (10%)[/B] [LIST] [*]Client/Server Concepts [/LIST] [B]Section 2: Data Definition using SQL (25%)[/B] [LIST] … |
| | G'day, I've got rather a simple problem to deal with though i'm personally having some trouble. I've recently fixed up some of my database queries so that i use a view to get the data that i need. My view gets the following info: [LIST] [*]Attraction Name [*]Package ID [*]Package … |
| | G'day, Just a simple question. Does MySQL Support Inheritance? I understand that both Oracle and PostgreSQL support Inheritance, but haven't seen anything in MySQL regarding this. Regards, TC |
| | Sorry, please forgive me. My PHP is VERY rusty, however what you SHOULD do to speed up the processing time is call your DB connection outside of the for loop first off. This will dramatically reduce your query processing time. Secondly, i would recommend that you use a VIEW to … |
| | Re: Date range [QUOTE=maks91;1154063]How can i select a date range if its a php timestamp?[/QUOTE] G'day [B]maks91[/B], I've had to do a little research to check exactly how this is done, and as far as i can tell, it works the same is it does with other dates. [B]Given a table:[/B] [CODE]CREATE TABLE … |
| | with your second join, what is [I]p.clients_ClientID[/I] referring to? [CODE=SQL]SELECT m.MortgageID, m.AccountNumber, m.Lender, m.LoanAmount, m.Term, m.PurchasePrice, m.ReviewDate, m.DatePaid, m.DateSubmitted, m.StartDate, m.Amount, m.RepaymentType, m.clients_ClientID, m.IssueDateMortgage, m.MortgageTypeName, m.MortgageSold, m.MortgageStatus, c.ClientID, c.App1FirstName, c.App1LastName, c.App2FirstName, c.App2LastName, c.ClientUserID, p.Pip_CommID, p.clients_ClientID FROM (mortgage m INNER JOIN clients c ON m.clients_ClientID = c.ClientID ) INNER JOIN pipeline_commission … |
| | Sorry [B]urtrivedi[/B] you are right the query itself is correct, but i think the syntax isnt quite right. What i believe is happening is that the Between is lookin at the 2nd AND statement and misreading it. Maybe try this: [CODE]$data = mysql_query("SELECT * FROM table WHERE (date BETWEEN '$beginDate' … |
| | what you can do is this; [CODE]INSERT INTO a VALUES ('C:\\qqq\\www\\eee.ttt');[/CODE] The first slash tells the MySQL engine that the next character is to be taken as a literal character as opposed to a character which MySQL has reserved. The second problem can be solved with the same solution. [CODE]INSERT … |
| | G'day, I've got a table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` varchar(255), PRIMARY KEY (`attID`), KEY (`attName`) ) ENGINE=InnoDB;[/CODE] Now my initial set up was that [B]referenceID[/B] was linked to [B]attID[/B] … |
| | Okay, first off, the problem you have [B]ISN'T[/B] with dreamweaver, it is with which-ever language you are using. The password section, if was not set should be set as [B]""[/B]. Which language are you using to connect to the MySQL database? JSP/PHP/Python...? This will help in identifying which is the … |
| | G'day, I've recently gotten a new 2TB WD external HDD. I've replaces my 1.5TB WD HDD which worked fine without any problems. However, now the 2TB cant be seen. When i check the devices and printers, I get a USB to ATA/ATAPI Bridge but still no drive is being shown. … |
| | When exporting data out of a MySQL table/database, you should use the following SQL code: [CODE=mysql]SELECT * INTO OUTFILE 'filename/location' FROM table_name;[/CODE] My assumption would be to run a statement query execute. In terms of the whole DB at once, im sorry, but im not entirely sure. |
| | the method posted by [B]qualitybrains[/B] is the most efficient. This is because rather than: [B]1. pulling data into java 2. modifying data 3. updating in mysql[/B] All your doing is basically step 3. this is because the MySQL engine handles steps 1 and 2 more or less for you. |
The End.