You can subscribe to this list here.
2004 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2006 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Michel M. <mme...@gm...> - 2009-03-17 19:27:58
|
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() |
From: nadeem m. <nad...@ya...> - 2006-04-09 07:00:19
|
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. |
From: <ben...@id...> - 2004-05-25 07:57:24
|
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 _______________________________________________________________________ |
From: Mark R. <Mar...@di...> - 2004-03-30 04:54:26
|
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() |