Posts by StephNicolaou

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.

No problem. Could you please mark this thread as solved if done so?

Thanks :)

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 PHP sqcript to get your database size is as follows:

<?php
$db = mysql_connect("hostname", "username","password"); // MySql database connection
mysql_select_db("dbname",$db); //Select the database
?>

<?php
{
$sql = "SHOW TABLE STATUS"; //Command to get the database status
$result = mysql_query($sql); 
while($row = mysql_fetch_array($result))
{
$dbsize = $row['Data_length']+$row['Index_length']; // Columns 'Index_length' and 'Data_length' of each row calculated
}
echo($dbsize); // Print the database size
}
?>

Once you have the size (with $dbsize) you can check that thedbsize < 1GB and if true, run the following PHP script to create a table and it's tables:

<?php
$con = mysql_connect("hostname", "username","password"); 
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

// Create table
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Employees
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";

// Execute query
mysql_query($sql,$con);

mysql_close($con);
?>

Hope that helps :)

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 (Employee_ID, Cart_ID, Sum(Amount)).

You can then pull all the information you want to show, like the names and cart information in a SELECT statement via. the relationsional links indicated above.

Hope that helps.

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.

http://www.w3schools.com/sql/sql_select_into.asp

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

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

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.

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

To display only one particular type of news articles in a drop down menu, you need to ensure you have a category table and the news_category compound table in your database where all of the news articles are linked to a category.

Then you can add the WHERE command to your SQL statement:

SELECT nTitle, date_format(nDate, '%d %M, %Y'), nContent FROM news, news_category WHERE category = 1 order by nDate DESC

When doing the match you can use the index of the selected category after getting it from a drop down menu of categories in your PHP code.

Hope that helps.

Have you tried the SELECT DISTINCT and possibly WHERE NOT EXISTS clauses?

You can set the location of the Jframe under the mouse listeners so it will not move from that position

No problem! you can mark this thread as solved if that did the trick :)

Which part doesnt work, the frame removing or the game re-starting? If the frame does not close, then you could try the below methods, have a look at the JFrame class, (below).

f.dispose();
f.setDefaultCloseOperation(f.EXIT_ON_CLOSE);

Or the update() method to call paint instead.

http://docs.oracle.com/javase/1.4.2/docs/api/javax/swing/JFrame.html

Then once that works, you can focus on the game restarting. I'm not sure but you need to reload the game class or reconstruct it??

Try:

foreign key (ssn) references Student(ssn),
foreign key (courseId) references Course(courseId)

If you are currently echoing every age option under 100, do you want the selected age?

Have you tried the get method?

$_Get Variable on w3s:

http://www.w3schools.com/php/php_get.asp

Session Variables:

http://www.w3schools.com/php/php_sessions.asp

echo $_GET['age']; or
$var = intval($_get['age']);

You have to change the encoding and use a stream reader. Look up internalisation and how to convert non-UTF back to UTF:

Oracle tutorials:

http://docs.oracle.com/javase/tutorial/i18n/index.html
http://docs.oracle.com/javase/tutorial/i18n/text/convertintro.html

1) yes, make sure you've constructed the frame then you can use setVisible(true)

2) Java Web Server - try port 7001

3) Yes.

Google is your friend. Use it.

Servlets:

http://docs.oracle.com/javaee/1.4/api/javax/servlet/http/package-summary.html
http://www.apl.jhu.edu/~hall/java/Servlet-Tutorial/Servlet-Tutorial-First-Servlets.html

Oracle JWS Annotation Reference:

http://docs.oracle.com/cd/E13222_01/wls/docs90/webserv/annotations.html

Oracle Internal Frames Tutorial:

http://docs.oracle.com/javase/tutorial/uiswing/components/internalframe.html

Thanks, I suppose you would have to use the index to only remove one of the duplicated values which would depend on the case anyway.

I'm not a programmer, I'm the analyst so don't have an ide at work :o

So, how would you remove a duplicated number in an array list without using "Collection.removeAll(Collection<?> c) " out of interest?

Fotsung,

I'm assuming that you mean main class by "form" class.

When you are anywhere in the main class, like the event method, you construct another class in your package like so:

OtherClass anyName = new OtherClass(); 
//OtherClass being the name of your other class

Then, when you want to use a method from that other class you simply write:

anyName.OtherMethod(); 
//OtherMethod being the name of the other method in the other class!
//include any arguments required for method between the paramaters

When you are returning a result from the other method, the call would be:

int result = anyName.otherClass();

I hope this helps.

Regards,
Cleo