pyado-users — PyADO users mailing list

[Pyado-users] Array problem

[Michel M. <mme...@gm...>]

Hi everyone,
I am writing a python program using PyADO to add some data to an 'mdb'
database. For example,

filename = UserObjs.mdb
table I am working with = Lines
fields I am working with = ID and Metrics

The 'ID' field is just a number field. The 'Metrics' filed is an OLE object.
In this OLE object assigned in Microsoft Access, I need to include a series
of latitude/longitude numbers as in an array.

The problem I have is that, let's suppose I want to add this array:
[(23.00000,56.5897),(23.4569,58),(244569,60)]

When I read the database (SELECT etc..), what I get is something like
this: [ *(*2*3*.*0*,...) ]

(Note: Here, I used the * to symbolize a 'box' string shown in the python
command line.)

I'd appreciate any help I could get on this!

Thank you so much!!!

Regards,

Michel
PS: Below is the code I am using to insert / read the data:

****To insert:
import PyADO
import win32com.client
import sys

id_number = raw_input("ID? ")

id_metrics = [(23.00000,56.5897),(23.4569,58),(244569,60)]

conn = win32com.client.Dispatch(r'ADODB.Connection')
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=C:\msm_test\OLE_project\UserObjs.mdb;'
sql_statement = "INSERT INTO Lines (ID,Metrics) VALUES ('%s','%s');"
%(id_number,id_metrics)

conn.Open(DSN)
conn.Execute(sql_statement)
conn.Close()

*** To read the data
import PyADO

conn =
PyADO.connect(None,user='admin',password='',host=None,database='C:\\msm_test\OLE_project\UserObjs.mdb',provider='Microsoft.Jet.OLEDB.4.0')

curs = conn.cursor()

curs.execute("select * from Lines")

result = curs.fetchall()
descr = curs.description
for row in result:
   for col in row:
      print col

curs.close()
conn.close()

[Pyado-users] about MS-Access and relationships

[nadeem m. <nad...@ya...>]

Hello Guys...
  I`m trying to get the relationships between two related tables in MS-Access like:
  table1.cName=table2.dName.
  I can`t make a query using conn.Execute(sql) because MSysRealshionships  is a syaytem table not an ordinary table please tell me what I have to  do.
  It`s a part of a project in my study.
  and Thanx.
  Nadeem.
  
		
---------------------------------
Love cheap thrills? Enjoy PC-to-Phone  calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.

[Pyado-users] FASD project: Online survey launched

[<ben...@id...>]

Dear Open Source developer

I am doing a research project on "Fun and Software Development" in which I kindly invite you to participate.
You will find the online survey under http://fasd.ethz.ch/qsf/. The questionnaire consists of 53 questions and you will need about 15 minutes to complete it.

With the FASD project (Fun and Software Development) we want to define the motivational significance of fun when software developers decide to engage in Open Source projects. What is special about our research project is that a similar survey is planned with software developers in commercial firms. This procedure allows the immediate comparison between the involved individuals and the conditions of production of these two development models. Thus we hope to obtain substantial new insights to the phenomenon of Open Source Development.


With many thanks for your participation,
Benno Luthiger


PS:
The results of the survey will be published under http://www.isu.unizh.ch/fuehrung/blprojects/FASD/.
We have set up the mailing list fa...@we... for this study. Please see http://fasd.ethz.ch/qsf/mailinglist_en.html for registration to this mailing list.

_______________________________________________________________________

Benno Luthiger
Swiss Federal Institute of Technology Zurich
8092 Zurich

Mail: benno.luthiger(at)id.ethz.ch
_______________________________________________________________________

[Pyado-users] Help!

[Mark R. <Mar...@di...>]

Am extremely new to Python and have encountered the following problem.
If I have more than
3 field names to INSERT into I get the following error message:
'Syntax error in INSERT INTO statement.', None, 5003134, -2147217900),
None).

With 3 or less fields, no problems.

Any help would be much appreciated (code listed below). Am running
Python 2.2.3

Thanks.

Mark


import PyADO
conn =
PyADO.connect(None,user='admin',password='',host=None,database='C:/ssts/validation/bulk_email/All_Schools_Tracking.mdb',provider='Microsoft.Jet.OLEDB.4.0')
curs = conn.cursor()

f = open("c:\ssts\ssw_reports\SSW_Mod20040301.txt")
for l in f.readlines():
        k = l.replace("\t", "nob")
        k = k.split("nob",12)
              
        d1 = k[0]
        d2 = k[1]
        d3 = k[2]
        d4 = k[3]

        zlst = [
               (d1,d2,d3,d4)
        ]

        for r in zlst:
            sql = """INSERT INTO nobber (Anumber, ChangeCode, Name,
Level)
                VALUES ('%s','%s','%s','%s')""" % r
            curs.execute(sql)
f.close
conn.close()