- Strength to Increase Rep
- +6
- Strength to Decrease Rep
- -1
- Upvotes Received
- 15
- Posts with Upvotes
- 12
- Upvoting Members
- 10
- Downvotes Received
- 2
- Posts with Downvotes
- 1
- Downvoting Members
- 2
- Interests
- -Mountain Biking -Travelling / World Heritage Sites -PS3 Gaming -Photography
- PC Specs
- -Java -VB -SQL -PHP/HTML/XML -Drupal
Re: Hi Ezzaral, Can you please explain how you get the Integer of the selected item? Yes I can return the selected string by [code] combo.getSelectedItem(); [/code] but how do I get it's int returned by the getValue() method? Thanks in advance, Cleo123 | |
Re: It's printerJob, I would advise you to take a look at oracle documents which explain everything to do with setting the jobs, rendering with the Printable interface and opening the printer dialog. Go through the document list and look at the examples and you should be able to then put … | |
Re: Exactly what the title says... Look closely at line 3. [code] Rs.Open "Select * from tblpayroll where EmployeeID= '"+ Trim(txtEmpID.Text) +"' ", Cn [/code] | |
Re: No, if the recipient doesn't have SQL Server Management Studio, he/she will need a program to open the file. Either ssms.exe or sqlwb.exe. | |
Re: Create a button and the command button wizard will pop up. Go to the category, Form Operations and choose 'Open Form'. A list of your forms will appear/ and select the form you want it to go to when the button is clicked. Then you can write the text you … | |
Re: Would you like the total of the 5 total sales? You will need to add these up before you convert to string including a result variable. [code] total = total + intStore [/code] Post your error, what to you want to fix/improve here? | |
Re: Line 27 isn't needed. Has this been solved already now that this is 2 days old? | |
Re: Unfortunately, GoDaddy doesn't allow you to increase your database size limit. However you can have more than one database, if you upgrade you account plan. If you have the Economy plan, you can have 10 databases, Deluxe gives you 25 database and you can also have an Unlimited plan. The … | |
All, Is it at all possible to have a 'multiple items' form based on a query, plus have a combo box added to it, with the control source of a field already on the form. Issues: 1. When the combo box is given the control source of a field already … | |
Re: I am assuming you have an EMPLOYEE & CART entity with each of their primary key and attributes, in addition to a link table, e.g. EMPLOYEE_CART with the foreign keys, Employee_ID, Cart_ID and the Sum. So to store each instance, use the INSERT INTO statement. E.g. INSERT INTO EMPLOYEE_CART VALUES … | |
Re: Yes, you do not *have* to include the username or password. I'm not sure if you are familiar with the database connection syntax, but you can just exclude the username and password variables from the connection string. E.g. [URL="http://www.java-samples.com/showtutorial.php?tutorialid=9"]http://www.java-samples.com/showtutorial.php?tutorialid=9[/URL] There are alternative methods such as the grant element to allow … | |
Re: Yes, this is possible. To select a range of rows, you use the LIMIT element. E.G. SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15 "With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the MAXIMUM number of rows … | |
Re: Try this with variables defined and without the getbytes method for now: [code] try { InetAddress adr = InetAddress.getByName("173.194.35.133"); System.out.println("Reachable Host: "+adr.isReachable(3000)); boolean status = inet.isReachable(3000); System.out.println("Reachable Host:" + status); } catch (IOException e) { e.printStackTrace(); } [/code] Either using the boolean or not. Hope that helps :) | |
Re: Student_ID is not a string, could you change line 9 to: [code]pst.setInt(1, txtid.getInt());[/code] Yes, you can usually execute to different prepared statements. Hope that helps :) | |
Re: Your insert SQL statement is always expecting there to be 8 images and so the undefined variables are the empty files being found. Your SQL needs to be more dynamic, counting the number of files you have prior to the SQL statement. Here is a working example of a dynamic … | |
Re: Are you able to move line 47 where you are doing this to line 16 and just make the frame visible when the button is hit instead? Could you also inform us of the error message you're receiving? Thanks :) | |
Re: Modify the double percentage symbols to a single percentage symbol, e.g. '%M %e, %Y' Double percentages are a literal % symbol. Here is a MySQL guide to every format available: [URL="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format"]http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format[/URL] Hope that helps :) | |
Re: Try changing the equals to VALUES() E.G. [code] UPDATE TABLE2 SET VIDEOID,VIDEONAME,DIRECTOR,RATING,PLAYCOUNT VALUES ( 'VIDEOID','VIDEONAME','DIRECTOR','RATING','PLAYCOUNT') FROM TABLE1 [/code] Another UPDATE that is possible: E.G.2 [CODE] INSERT INTO TBL1 ( A, B, C ) SELECT tbl.[A], tbl.[B], tbl.[C] FROM aTBL AS tbl [/CODE] | |
Re: Use the INTO statement after your SQL SELECT statement (..as UniqueClick..) before the FROM elememt. So .. INTO tableName tableName will then be created on the fly if not already created, else updated. [url]http://www.w3schools.com/sql/sql_select_into.asp[/url] | |
| Re: Initially it looks like you're giving us your assignment to do, "Here is my assignment: Here is your assignment: " and your code isn't in code tags which will put a lot of people off! You don't really need to setSize a JTextField if you have already constructed it with … |
Re: Why don't you assign name into a global variable $a before you close the connection on line 13 (part one) i.e. place this line [code]$a=$row['name'];[/code] after line 12. Alternatively use the same statement on the other page. | |
Re: Research the company website, wikiJobs, the financial times news, company news & events in general. Get on linkedIn, follow their company, view their updates and get connected to the contacts that visit your school/uni. Make sure you take your CV (with all relevant experience) and/or business cards - which you … | |
Re: Are the fields blank or do they have the value zero in them? | |
Re: [code] public static int getLineNumber() { return Thread.currentThread().getStackTrace()[3].getLineNumber(); } [/code] "The index will change based on the JVM version. I believe it changed from 1.4 to 1.5". Resource: [URL="http://bit.ly/xLDhVJ"]http://bit.ly/xLDhVJ[/URL] I have changed the index to [3] instead of [2] but try either based on the version you are using until … | |
Re: Hi there. You are receiving incompatible types because x is and int and z is a double. Also, are you allowed to change from public parent to Shape myShape = new Shape[10] ? | |
Re: Under your main method (public static void main(String[] args)) call a createAndShowGUI() method that constucts and sets visible the main frame you want to use. Then under your public method you can use the JMenubar package to create menu items that open your other frames. Using this you can create … | |
Re: Without reading through your whole code, a simple way would to just use the scanner class, "Please enter your name and surname". [code] Scanner sc = new Scanner(System.in); string name = sc.next(); string surname = sc.next(); sc.close(); [/code] [URL="http://docs.oracle.com/javase/1.5.0/docs/api/java/util/Scanner.html"]http://docs.oracle.com/javase/1.5.0/docs/api/java/util/Scanner.html[/URL] | |
Re: Yes, connect to your database as you would normally, connection paths, etc. And use the SQL statement, DELETE * FROM TBLNAME1, TABLENAME2 ... How would that database look? The tables would just be empty and you would have to make sure you also delete foreign relational data to ensure you … | |
Re: Well, it depends how complicated/realistic you want this program to be. If you've wrote the database, you should have students, the courses they are assigned to, their lecturers and their timetables, etc! Then you can add a database table linked to the courses tables for all the course's assignments/examinations and … | |
Re: The best way is the IsNumeric(inputValue) method saying: [CODE] If Not IsNumeric(inputValue) Then MsgBox "Please enter a number!" Else do whatever End If [/CODE] Another way is using an if statement checking for 1, 2 and 3 - not a wide range of numbers to say: [code] If not (inputValue … |