StephNicolaou

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

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 …

Exactly what the title says... Look closely at line 3. [code] Rs.Open "Select * from tblpayroll where EmployeeID= '"+ Trim(txtEmpID.Text) +"' ", Cn [/code]

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.

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 …

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?

Line 27 isn't needed. Has this been solved already now that this is 2 days old?

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 …

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 …

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 …

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 …

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 :)

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 :)

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 …

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 :)

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 :)

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]

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]

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 …

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.

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 …

Are the fields blank or do they have the value zero in them?

[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 …

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] ?

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 …

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]

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 …

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 …

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 …

Have you checked you php.ini file to see whether you SMTP address and port details are correct? I can't see line 38 in sendmail.php but that's the first place I would look according to your error message.

Select all the fields you want to use and place MAX() around the field you want. Then you have to group by everything youve selected and order by a field ID. [code] SELECT TBL.field1, MAX(TBL.field2) FROM TBL WHERE TBL.childid on TBL.childid and (parent.name LIKE '%$search%') GROUP BY field1, field2ID ORDER …

First you have to drag and drop the combo box into the form. Then, under the Form Load event in the Code Builder, you call the two options, I'm assuming from a database, using the RowSource method and SQL: [code] Me.ComboBox.RowSource = "SELECT * FROM [Duties] IN '" & DatabasePath …

Not really, if the foreign key value changes, it loses the relational link to the primary key. So you then lose the integrity of the information as the row values will link to another primary key value of different data, or nothing if it doesn't exist causing an error. You …

Since this is your first post, try to make sure you use the code brackets next time you post. First things that come to mind is checking your refresh-rate, setting the image as background, reducing the size of your window/ enlarging your picture and checking all of your window properties. …

Yes, on logging in each user will have a session, also opening the data relevant to them from an SQL query... Look at where the sumbit blog button code is and add the 2point's global variable to the user's total points variable which can then be stored in the user's …

To go to then next question, you just need to increment the question_id value by one each time the next button is pressed. Then just increment a count value every time an option box is selected.

Not if it works like a Microsoft disc license or Sky TV link codes where you can use them on a limited number of computers.

I got the query to work using this statement: [code] SELECT * FROM eshop_flat_sales_order WHERE (((status)="complete") AND ((customer_email)="a(at)a.com")); [/code] You would have to replace "a(at)a.com" as a variable name input from your front end, along with "complete" if you would like the user to select the status as well. In …

I would advise you to try and place the DISTINCT element at the beginning of the statement and work from there, e.g. [code] SELECT DISTINCT brands.brand_id FROM brands INNER JOIN products ON brands.brand_id = products.brand_id WHERE products.stock > 0" [/code] Alternatively, remove the inner join and use the match in …

I can't see anywhere that you have constructed any frame or panel in which to add to the frame to then set it frame visible, you can also use a Container... e.g. [code] JPanel p = new JPanel(); p.setLayout(new BoxLayout(p, BoxLayout.PAGE_AXIS)); p.add(label1); p.add(label2); [/code] I would suggest you look at …

Can you please post your XML? I would initially check your node names and structure.

One option is to use a while in JavaScript with a boolean to indicate an upload is being carried out: [code] while (uploading = true) { document.getElementById("123").disabled = true; or document.theForm.theButton.disabled; } [/code]

Firstly, you're missing the master data for the people attending the lecture table. You can either have 2 tables; Student Master and Staff Master or a Persons table with a Student/Staff drop-down menu from a PersonsType table. 2. You don't really need two TimeTable's, you can add a Join table …

You could try following these instructions before using the return value for the presentation (line 6). These use the Input method: [URL="http://stackoverflow.com/questions/938796/vba-read-lines-from-text-file-exclude-top-two-lines"]http://stackoverflow.com/questions/938796/vba-read-lines-from-text-file-exclude-top-two-lines[/URL] [URL="http://vbadud.blogspot.com/2007/06/vba-read-text-files-with-leading.html"]http://vbadud.blogspot.com/2007/06/vba-read-text-files-with-leading.html[/URL]

Under the form load, you can enter: [code]Me.ComboName.RowSource = "SELECT [TBL].[IDField1], [TBL].[NameField2] FROM [TBL] IN '" & DBpath & "' ORDER BY [IDField1];"[/code] Or have you solved this thread completely? Mark as solved if so...

You could try doing something practical like: - A banking system - A grid navigation system - An employee HR system - A game like pacman, battleships, connect 4 These are good ways where you are going to get a lot of interaction with the user, however for most things …

The username and password on the connection has to be the username and password of the database. Post the code you have... And if all else fails the DAO method is a lot easier. [code] Dim rs As DAO.Recordset Dim db As DAO.Database Set db = CurrentDb Dim path As …

The problem may be with s.name, try using a variable without the dot.

I would say that once 5 is decremented to 0, it stays as 0 as all you have is 'return 0' doing nothing else, and you have no system exit at that point.