Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re^10: Relational table with perl DBI

by Neighbour (Friar)
on Mar 14, 2013 at 10:13 UTC ( #1023444=note: print w/replies, xml ) Need Help??

in reply to Re^9: Relational table with perl DBI
in thread Relational table with perl DBI

What does your event-table look like? It seems there is no column named event (even though your original post showed there should be).
Once again, the insert query fails, $inserted_records becomes undef which doesn't quite compare to a number.

Replies are listed 'Best First'.
Re^11: Relational table with perl DBI
by M15U (Acolyte) on Mar 14, 2013 at 10:38 UTC

    Well it looks like this :

    $create_query = qq{ create table event( id_event int(10) auto_increment NOT NULL, event MEDIUMTEXT COLLATE utf8_general_ci, primary key (id_event) ) }; $dbh->do($create_query);

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1023444]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (10)
As of 2016-10-25 07:45 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (315 votes). Check out past polls.