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

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.


Comment on Re^10: Relational table with perl DBI
Select or Download Code
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (8)
As of 2015-07-08 03:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls