Re: [GENERAL] problem creating users via pythons script

2006-07-19 Thread Timothy Smith
Volkan YAZICI wrote: On Jul 19 10:40, Timothy Smith wrote: Volkan YAZICI wrote: On Jul 19 10:02, Timothy Smith wrote: cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s """,(StaffUserName,NewPassword,StaffGroup)) produces this error ERROR: syntax error at or near "

Re: [GENERAL] problem creating users via pythons script

2006-07-19 Thread Volkan YAZICI
On Jul 19 10:40, Timothy Smith wrote: > Volkan YAZICI wrote: > >On Jul 19 10:02, Timothy Smith wrote: > > > >>cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s > >>""",(StaffUserName,NewPassword,StaffGroup)) > >> > >>produces this error > >> > >>ERROR: syntax error at or near "'bob.smi

Re: [GENERAL] problem creating users via pythons script

2006-07-19 Thread Volkan YAZICI
On Jul 19 10:02, Timothy Smith wrote: > cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s > """,(StaffUserName,NewPassword,StaffGroup)) > > produces this error > > ERROR: syntax error at or near "'bob.smith'" at character 13 IIRC, per Python DB-API PEP, the DB adapter you use try to e

[GENERAL] problem creating users via pythons script

2006-07-19 Thread Timothy Smith
this is really newb of me but i can't manage to make a script to create users. cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s """,(StaffUserName,NewPassword,StaffGroup)) produces this error ERROR: syntax error at or near "'bob.smith'" at character 13 is it because i need to dou