[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 double

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 escape and

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.smith' at character 13

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