4 messages in com.mysql.lists.mysqlRe: Problem with update using DBI & perl
FromSent OnAttachments
Oliver Hinds17 Jan 2001 13:10 
Gerald L. Clark18 Jan 2001 06:08 
Oliver Hinds18 Jan 2001 09:39 
Gerald L. Clark18 Jan 2001 13:13 
Subject:Re: Problem with update using DBI & perl
From:Oliver Hinds (oli@ed.phys.ncat.edu)
Date:01/18/2001 09:39:41 AM
List:com.mysql.lists.mysql

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 <mysq@lists.mysql.com> To unsubscribe, e-mail
<mysql-unsubscribe-oliver=ed.p@lists.mysql.com> 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