Visual Paradigm Logo
     Build Quality Applications Faster, Better and Cheaper
 
Home | Products | Download | Documentation | Support | Resources | Partners | Quick Tour | Shop | Company |  
 
   Visual Paradigm Discussion Forum
  Login   [ Register ] Email: Password: Log me on automatically I lost my password  
Recent Topics
Advanced Search
Inserting into Database  
Forum Index -> DB Visual ARCHITECT (DB-VA)
Author Message
nomspes@gmail.com


Joined: 2007/03/23
Messages: 3

Offline

I get a nice little error here when trying to input into the database.

Just testing some stuff to make sure I did it right.

Either I didnt, or I have found a bug.

here is the error produced.

INSERT INTO temp_list (name, ) VALUES ('hahah', );

Fatal error: Uncaught exception 'epExceptionDbAdodb' with message 'Cannot execute query: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES ('hahah', )' at line 1] in EXECUTE("INSERT INTO temp_list (name, ) VALUES ('hahah', );") ' in /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbAdodb.php:194 Stack trace: #0 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDb.php(317): epDbAdodb->_execute('INSERT INTO tem...') #1 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbObject.php(2283): epDb->execute('INSERT INTO tem...') #2 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbObject.php(154: epDbObject->_execute('INSERT INTO tem...') #3 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/runtime/epManager.php(992): epDbObject->insert(Object(epClassMap), Object(epObjectWrapper)) #4 /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phpor in /var/www/vhosts/myarcworld.com/httpdocs/arcg2/lib/phporm/src/db/epDbAdodb.php on line 194

Any idea?
 
nomspes@gmail.com


Joined: 2007/03/23
Messages: 3

Offline

$lol = "hahah";
$list = temp_listDAO::createTemp_list();
$list->name = $lol;
temp_listDAO::save($list);

Thats my php code.
 
Jick


Joined: 2005/04/29
Messages: 2880

Offline

Hello nomspes,

Thank you for your post. We are now working on a new version, which is likely to fix this problem. Would you mind sending me your project file so that we can confirm if the fix work with your project?

Best regards,
Jick

Visual Paradigm International Ltd.
http://www.visual-paradigm.com

Build Quality Applications Faster, Better and Cheaper
 
 
   Forum Index -> DB Visual ARCHITECT (DB-VA)
Go to:   
Powered by JForum 2.1.4 © 2005 - Rafael Steil