Sorry for the stupid question. I was fixated on the SQL.
Thanks
Len Sumnler
Peter Otten wrote:
> len wrote:
>
>
> > Have the following code:
>
> Short variable names increase the likelihood of name clashes:
>
> > c = db.cursor()
>
> > c = ''
>
> > c = csz[0]
>
> >
len wrote:
> Have the following code:
Short variable names increase the likelihood of name clashes:
> c = db.cursor()
> c = ''
> c = csz[0]
> c = csz[0] + ' ' + csz[1]
> c.execute("insert into Producer \
> (Producer_Sid,
Have the following code:
import os
import csv
import re
import mx.ODBC
import mx.ODBC.Windows
currdir = os.getcwd()
db = mx.ODBC.Windows.DriverConnect('dsn=UICPS Test')
c = db.cursor()
sid = 315
matchstr = re.compile(r'\(*\)*-*,*')
reader = csv.reader(open(currdir + r'\\IBI Brokers List 8-21-06.
