RE: pushing web form params into mysql table
[email protected] (Aaron Reist)
| Newsgroups | perl.beginners.cgi |
|---|---|
| Message-ID | <[email protected]> |
How I get off this mailing list?I tried the link at the bottom of the message, (many times) but it doesnt seem to work.Please let me know> Date: Thu, 28 Jun 2007 10:58:19 -0400> From: [email protected]> To: [email protected]; [email protected]> Subject: Re: pushing web form params into mysql table> > 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 <[email protected]>/> > To: /Shad Keene <[email protected]>/> > Subject: /Re: pushing 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 documentation> > >>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>> > -- > To unsubscribe, e-mail: [email protected]> For additional commands, e-mail: [email protected]> http://learn.perl.org/> > _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE