Drastic Grid - Add row doesn't work

I downloaded the example table and customized it. Everything seems to work, except the "Add Row" thing. When I click in the gray "star" that suppose to add a row, the loading red animation flashs for a second than vanish. The grid stays the same, my DB stays the same. I thought tha could be my customization and used the example grid amost to the letter. The olnly diference (Except that I used my table and note the example one). Same problem. Than I thougth: "Ok, the problem is probably something that I did on my data base.". And now I really follow the example to the letter. Still can add a row. Can anyone, please help me on this? I loved the tool, but this is killing me!

Thanks in advance and sorry my poor english.

Difficult to say something about it from a distance.
You can send your code and example to [email protected] and then we can analyse the problem if we have time.

best regards,

DrasticData

I'm having the same problem, the AddRow wouldn't work, the loading panel just shows and disappears.

Compared to the thread owner though, I'm using Tomcat 6 as my web server with Quercus installed. I literally just run the examples and created its corresponding database in MySql but to no avail. Note: code is as is. I only changed the connection settings.

Hi Roberto,

If adding a row does not work, even in the simple examples, then usually there is a difference in the database created. The INSERT will not work bevcuase the defaults do not conform to the database.
Of course there other possibilities, but this is where it is best to start looking.

If you do not succeed in getting it to work, please contact us at [email protected] and we will have a look.

best regards,

DrasticData

$arr=mysql_fetch_array(mysql_query("SELECT * FROM corsi WHERE id_corso=".$_SESSION['corso']['corso']));
define("PATHDRASTICTOOLS", "");
include (PATHDRASTICTOOLS . "Examplemysqlconfig.php");
include (PATHDRASTICTOOLS . "drasticSrcMySQL.class.php");
class mysrc extends drasticSrcMySQL {
protected function select(){
$res = mysql_query("SELECT * FROM $this->table WHERE titolo_corso= '$arr['titolo_corso']'" . $this->orderbystr, $this->conn) or die(mysql_error());
return ($res);
}

i have a problem write where titolo_corso= '$arr['titolo_corso']'

can you help me?

Dear luca,

If you want the add to work accordingly you could have a look at examplegrid3.As you may see,not only the select is specified,but also the add is defined as in:

class mysrc extends drasticSrcMySQL {
protected function select(){
$res = mysql_query("SELECT * FROM $this->table WHERE Continent='Europe'" . $this->orderbystr, $this->conn) or die(mysql_error());
return ($res);
}
protected function add(){
mysql_query("INSERT INTO $this->table (Continent) VALUES('Europe')", $this->conn) or die(mysql_error());
if (mysql_affected_rows($this->conn) == 1) return(true); else return(false);
}
}

Hope this helps,

regards,
DrasticData

I had the same problem.

Fixed (eventually) by ensuring a PRIMARY field in the SQL - doesnt need to be displayed

Set to 'Auto-Increment'

I had the same program will example11 as-is. Just change the columns to all have a default value (i.e. '') except for the id column