Hello,
My table 'orderitems' looks like this
create table orderitem (
id serial not null primary key,
item integer not null,
quantity numeric(6,2) not null,
unit varchar(10),
conference integer not null,
seller integer not null,
incharge integer not null,
orderdate date not null,
duedate date
On 12/20/06, A. Kretschmer [EMAIL PROTECTED] wrote:
But i have questions/suggestions:
- you have never-used variables in your function. Perhaps you have an
older version from the function with an error and the wrong version
runs?
- perhaps, you have an other trigger on phonebook that calls
Hii,With regards to the previous mail and replaies, I tried with this code. Although it doesn't give any error when i run it as a script, but the
return value is NONE for 'q', which is assigned to return value of
cursor.execute(), and the data are not inserted into the database.
[code]
name =
On 7/31/06, Richard Huxton dev@archonet.com wrote:
Line68: query = cursor.execute(INSERT INTO ConfMain (ConfName, ConfHost, ConfStart, ConfEnd, ConfDays, ConfStartTime, ConfEndTime, ConfSize) VALUES (\'%s\', \'%s\', \'%%\', \'%%\', %i, \'%%\', \'%%\', %i); %
(conf_name, host_name, start_day,