How do i create table in sql for webappcabaret

[Gaurav Kalra]

Please guide me as i am unable to create tables for my site at www.webappcabaret.com
gaurav

[Desai Sandeep]

Gaurav,
Could you be more specific about your problem.Accessing your site gives Configuration error :500
Regards,

------------------
Sandeep Desai
[e-mail]

1. Sun Certified Java Programmer Scored 93 per cent
   
2. Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java Scored 56 out of 59
   
3. IBM Enterprise Connectivity with J2EE Scored 72 per cent
   
4. Enterprise Development on the Oracle Internet Platform Scored 44 out of 56
   

[maha anna]

Gaurav,
We have to go to a special URL where we have to give SQL statements and run them in order to create our initial tables.
A sample one which I use is

/* Working for Online System
CREATE TABLE System( ID int NOT NULL auto_increment,ParamName varchar(20), ParamValue varchar(20),PRIMARY KEY(ID))
INSERT INTO System (ParamName,ParamValue) values ('BaseBranch', 'Chennai')
*/

Note that at one time we can give only one SQL statement and execute. To check if the table was created properly, at last give "select * from System" SQL statement!

It was real pain though.
DataBase URL :
jdbc:mysql://mysql.webappcabaret.com/dbtest?user=dbtest&password=dbtest
Here dbtest is your database Name, user=username and password is password for your database. The link is here:
http://webappcabaret.com/apps/websql/websql_server_s.jsp

[This message has been edited by maha anna (edited April 07, 2001).]

[Mark Leong]

I have developed a little utility that helps me manage my databases at webappcabaret.com. You can goto the link below:-
http://www.webappcabaret.com/smallalley/servlet/smallcon.wacdbutilities.sqlutilities
Enter your context and password. I suggest you test your connection before executing any SQL statement (just type the statement into the text box).
Hope the utility is useful.