Re: DBI giving user input by place holders

in reply to DBI giving user input by place holders

You should create the table outside of your script, once the table is created, your done with it. Why try and create the table everytime you run the script?

Without executing the code, I am also going to assume the script dies when attempt to create the table that already exists which causes problems.

Create your table manually, and delete the do statement which creates the table from your code. Run that and see what happens.

Comment on Re: DBI giving user input by place holders

Replies are listed 'Best First'.
Re^2: DBI giving user input by place holders by ptum (Priest) on Jul 11, 2006 at 15:05 UTC
As Herkum has said, create your table outside your script (or drop it every time and recreate it). In order to add multiple rows to your table, you'll want the execute statement inside your while loop, passing it new arguments for each iteration of the execute. You'll probably want to check the success of the execute as well. No good deed goes unpunished. -- (attributed to) Oscar Wilde	[reply]

In Section Seekers of Perl Wisdom