Shad Keene wrote:
> Sean,
>
> Thanks...I got it to work. It turned out that I didn't have default
> values for the other columns so it wouldn't enter one column into the
> database w/o default values for the others. Until I put the "die-error"
> message after the "execute", I didn't know why it wasn't working,
Glad to hear it is working for you.
In general, you probably want to spend some time learning about the
details of debugging DBI code. Once you are comfortable with it, it
often makes some sense to make some subroutines that perform inserts,
deletes, updates, and selects and wrap everything in the appropriate
error handling. Alternatively, there are a number of higher-level
interfaces (like DBIx::Simple) that have it built-in.
Sean
>
------------------------------------------------------------------------
> From: /Sean Davis <sdavis2@[EMAIL PROTECTED]
>/
> To: /Shad Keene <shadkeene@[EMAIL PROTECTED]
>/
> Subject: /Re: pu****ng web form params into mysql table/
> Date: /Tue, 26 Jun 2007 21:06:47 -0400/
> >Shad Keene wrote:
> >>
> >>Sean,
> >>
> >>Thanks very much for the advice...I read through the do***entation
> >>and feel like I have most if not all of the code correct. The
> >>script is returning the correct passed param, but the row in which
> >>I'd like to input the param isn't being populated...no rows are
> >>being affected when I use the "select * from regimetest"...it says
> >>empty set. Any thoughts?
> >>
> >See here as a place to go next:
> >
>
>http://search.cpan.org/~timb/DBI-1.58/DBI.pm#RaiseError_(boolean,_inherited)
> >
> >Sean
>
>
> ------------------------------------------------------------------------
> Picture this – share your photos and you could win big!
> <http://g.msn.com/8HMAENUS/2740??PS=47575>
|
