Oliver Hinds wrote:
>
> On Thu, 18 Jan 2001, Gerald L. Clark wrote:
>
> > Oliver Hinds wrote:
> > >
> > > Has anyone experienced problems using DBI and perl with update statements
> > > not updating tables when the equivalent statement at the command line
> > > works, and all other operations work perfectly?
> > >
> > > Oliver Hinds
> > >
> > >
> > Only when I make the wrong assumption about what perl is actually
> > constructing
> > for an update statement.
> >
> > Have your application write the statement to a log file before it
> > executes it,
> > and look it over carefully.
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
> I have set the perl to die with the statement to examine it, and it looks
> good, here is an example:
>
> update Questions set type='f', question='In an experiment, the variable
> that you change in a systematic and purposeful way is called the <_>
> variable.', answer='independent', unit='Unit I. Introduction to
> LAAPhysics', model='Scientific Investigation Model (Underpinnings)',
> difficulty=NULL, description=NULL, standards=NULL, benchmarks=NULL where
> qid=3
>
> The strange thing is, the equivalent statement also works on a mSQL server
> running win2k. I am on linux(RH7) with mysql (latest beta).
>
> Thanks, Oliver Hinds
use dbh->quote() to quote your string variables before building your
statement,
or use placeholders.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
