RE: Value deletion

2005-03-11 Thread Hardy Merrill
, March 10, 2005 1:52 PM To: Moreno, Javier Cc: dbi-users@perl.org Subject: RE: Value deletion Quoting Moreno, Javier [EMAIL PROTECTED]: Actually it is now getting worse. It has AutoCommit set to 0 so I am doing this: $::sql = UPDATE GLOBALSettings SET Lang = ?; $::crt = $::lang_code; Debug

RE: Value deletion

2005-03-11 Thread Moreno, Javier
, March 11, 2005 8:34 AM To: Moreno, Javier Cc: dbi-users@perl.org Subject: RE: Value deletion I'm not familiar enough with trace output to know exactly what's happening there, but I'm guessing that the UPDATE is the problem. When you do an UPDATE, don't you *have* to have a WHERE clause? I see

RE: Value deletion

2005-03-11 Thread Hardy Merrill
Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED] Sent: Friday, March 11, 2005 8:34 AM To: Moreno, Javier Cc: dbi-users@perl.org Subject: RE: Value deletion I'm not familiar enough with trace output to know exactly what's happening there, but I'm guessing that the UPDATE is the problem. When

Re: Value deletion

2005-03-10 Thread Hardy Merrill
By saying ...of course the app bombs isn't very descriptive. You need to be a little more clear about just what the problem is and what is happening. Are you saying that the value $::lang_code is not being written to the database? Copy and paste in the exact error that comes up - this will help

RE: Value deletion

2005-03-10 Thread Ronald J Kimball
Hardy Merrill [mailto:[EMAIL PROTECTED] wrote: By saying ...of course the app bombs isn't very descriptive. You need to be a little more clear about just what the problem is and what is happening. Indeed. Javier, I might be way off here, but looks to me like this statement: my($sql)

RE: Value deletion

2005-03-10 Thread Ronald J Kimball
Hardy Merrill [mailto:[EMAIL PROTECTED] wrote: The string is a double-quoted string. The single-quotes are just literal characters inside a double-quoted string. They have no special meaning here. HM I understand the single quotes have no meaning here in this double quoted string,

RE: Value deletion

2005-03-10 Thread Moreno, Javier
- From: Michael A Chase [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 11:21 AM To: Moreno, Javier Cc: dbi-users@perl.org Subject: Re: Value deletion Quoting Moreno, Javier [EMAIL PROTECTED]: I have a script that writes a single record to a single row on a GLOBALSettings table. I

RE: Value deletion

2005-03-10 Thread Hardy Merrill
:21 AM To: Moreno, Javier Cc: dbi-users@perl.org Subject: Re: Value deletion Quoting Moreno, Javier [EMAIL PROTECTED]: I have a script that writes a single record to a single row on a GLOBALSettings table. I have a web page that does that and it does so successfully. I go into the database

RE: Value deletion

2005-03-10 Thread Michael A Chase
Quoting Moreno, Javier [EMAIL PROTECTED]: Actually it is now getting worse. It has AutoCommit set to 0 so I am doing this: $::sql = UPDATE GLOBALSettings SET Lang = ?; $::crt = $::lang_code; Debug(About to prepare: $::sql with criteria: $::crt); $::sth = $::dbh-prepare($::sql) or

RE: Value deletion

2005-03-10 Thread Moreno, Javier
: Thursday, March 10, 2005 1:52 PM To: Moreno, Javier Cc: dbi-users@perl.org Subject: RE: Value deletion Quoting Moreno, Javier [EMAIL PROTECTED]: Actually it is now getting worse. It has AutoCommit set to 0 so I am doing this: $::sql = UPDATE GLOBALSettings SET Lang = ?; $::crt = $::lang_code