I tried emailing you but I get:
<[email protected]>:
No MX or A records for cs.depaul.edu
I tested using IDLE:
>>> import sys
>>> sys.path.append('c:\\web2py\\trunk')
>>> sys.path.append('c:\\web2py\\trunk\\gluon')
>>> import sql
WARNING:root:no file locking
>>> sql.SQLDB('db2:DSN=dot8;UID=test;PWD=db2py')
<SQLStorage {'_connection': <pyodbc.Connection object at 0x01167F80>,
'_lastsql': '', '_dbname': 'db2', '_execute': <function <lambda> at
0x00C35070>, '_pools': 0, '_folder': '', '_uri':
'db2:DSN=dot8;UID=test;PWD=db2py', 'tables': [], '_translator':
{'upper': 'UPPER(%(field)s)', 'reference': 'INT, FOREIGN KEY (%
(field_name)s) REFERENCES %(foreign_key)s (id) ON DELETE %
(on_delete_action)s', 'text': 'CLOB', 'random': 'RAND()', 'datetime':
'TIMESTAMP', 'substring': 'SUBSTR(%(field)s,%(pos)s,%(length)s)',
'boolean': 'CHAR(1)', 'extract': 'EXTRACT(%(name)s FROM %(field)s)',
'id': 'ROWID NOT NULL', 'is null': 'IS NULL', 'is not null': 'IS NOT
NULL', 'blob': 'IMAGE', 'notnull': 'NOT NULL DEFAULT %(default)s',
'string': 'VARCHAR(%(length)s)', 'date': 'DATE', 'integer': 'INT',
'password': 'VARCHAR(%(length)s)', 'lower': 'LOWER(%(field)s)', 'left
join': 'LEFT OUTER JOIN', 'double': 'DOUBLE', 'upload': 'VARCHAR
(128)', 'time': 'TIME'}, '_cursor': <pyodbc.Cursor object at
0x00C4D448>}>
>>>
And I ran a SELECT successfully.
I will run some more tests.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
