>> , Access can retrieves a not empty recordset but my python code
>> retrieves a empty recordset.
>
> Which is exactly what it _should_ return on that query, unless you have
> records with "e*" in column field1.
>
> The proper SQL clause is:
>
> ... WHERE field1 LIKE 'e*' ...
which would
luis wrote:
> My problem was opening a query (not a table) on mdb file
>
> 1) If the query includes a where clause type
> field1="edf" and field2=3
> , for example, no problem, Access can retrieve a not empty recordset
> and my python code too.
>
> 2) But if the Access's query includes a LIKE cl
Iain King ha escrito:
> luis wrote:
> > Iain King ha escrito:
> >
> > > luis wrote:
> > > > Iain King ha escrito:
> > > >
> > > > > luis wrote:
> > > > > > while not rs.EOF:
> > > > > > id=rs.Fields(colName.Value) #colName, valid column name
> > > > > > ...
> > > > > >
luis wrote:
> Iain King ha escrito:
>
> > luis wrote:
> > > Iain King ha escrito:
> > >
> > > > luis wrote:
> > > > > while not rs.EOF:
> > > > > id=rs.Fields(colName.Value) #colName, valid column name
> > > > > ...
> > > > > rs.MoveNext()
> > > > > rs.Close()
>
Iain King ha escrito:
> luis wrote:
> > Iain King ha escrito:
> >
> > > luis wrote:
> > > > while not rs.EOF:
> > > > id=rs.Fields(colName.Value) #colName, valid column name
> > > > ...
> > > > rs.MoveNext()
> > > > rs.Close()
> > > > conn.Close()
> > >
>
luis wrote:
> Iain King ha escrito:
>
> > luis wrote:
> > > while not rs.EOF:
> > > id=rs.Fields(colName.Value) #colName, valid column name
> > > ...
> > > rs.MoveNext()
> > > rs.Close()
> > > conn.Close()
> >
> > I don't know if it's the problem your aski
Iain King ha escrito:
> luis wrote:
> > Hi
> > I'm using activestate python 2.4 on win xp 2 ed. and Ms Access 2002
> > (reading first http://starship.python.net/crew/bwilk/access.html)
> > I have writed the following code
> >
> > def append_from_Access(self):
> >try:
> > import ...
> >
luis wrote:
> Hi
> I'm using activestate python 2.4 on win xp 2 ed. and Ms Access 2002
> (reading first http://starship.python.net/crew/bwilk/access.html)
> I have writed the following code
>
> def append_from_Access(self):
>try:
> import ...
> conn = win32com.client.Dispatch(r'ADO
Hi
I'm using activestate python 2.4 on win xp 2 ed. and Ms Access 2002
(reading first http://starship.python.net/crew/bwilk/access.html)
I have writed the following code
def append_from_Access(self):
try:
import ...
conn = win32com.client.Dispatch(r'ADODB.Connection')
DSN = "P