Hi John,
I've no idea why its not working but this illustrates why I prefer to create
the sql string outside the execute - its a lot easier to debug when you can
print the string exactly as passed to execute. I know many others like to
leave execute to do the escaping stuff but I prefer to see what I'm doing
and put in a little extra effort.
So I would write it as:
query = '''UPDATE cost_grid
SET cost_1 = %s
WHERE cost_grid_id = %s
AND finish_dro = %s'''' % ( a,c,b)
c.execute(query)
Dunno if that helps but its my experience FWIW,
Alan G.
----- Original Message -----
From: "John CORRY" <[EMAIL PROTECTED]>
To: <tutor@python.org>
Sent: Saturday, April 15, 2006 10:26 PM
Subject: [Tutor] Didn't take long to hit my next wall!
> Hi,
>
> I am having problems amending records in my database.
>
> If I use the following code my database is updated fine.
>
> c = '"PF1"'
> b = 91.4
> a = 85.00
> import mx.ODBC
> import mx.ODBC.Windows
> db = mx.ODBC.Windows.DriverConnect('DSN=vfp')
> c = db.cursor()
> c.execute('UPDATE cost_grid SET cost_1 = ? where cost_grid_id = "PF1"
> and finish_dro = ?', ( a, b,))
>
> db.commit()
> c.close()
>
> However if I use the following code:-
> Where the only difference is I use the c variable instead of the actual
> "PF1". The database does not get updated. I have also tried
> C = "PF1" but this does not work either.
>
> c = '"PF1"'
> b = 91.4
> a = 85.00
> import mx.ODBC
> import mx.ODBC.Windows
> db = mx.ODBC.Windows.DriverConnect('DSN=vfp')
> c = db.cursor()
> c.execute('UPDATE cost_grid SET cost_1 = ? where cost_grid_id = ? and
> finish_dro = ?', ( a, c,b,))
>
> db.commit()
> c.close()
>
> Any suggestions would be greatly appreciated.
>
> Thanks,
>
> John.
>
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
