On Aug 26, 5:14 am, menuge <[EMAIL PROTECTED]> wrote:
> I have 2 tables:
> - info (id: integer, cfg: integer)
> - info_with_error (id:integer, cfg: varchar(32))
>
> I'd like to check the query before inserting into table. For instance:
> INSERT INTO info VALUES("STRING")
> If my query has an err
On Aug 23, 2:11 am, OKB <[EMAIL PROTECTED]> wrote:
> ... let's say I have a table with columns Firstname, Lastname,
> and Income. What I'd like is to get query results where the columns
> are Firstname, Lastname, Income, "sum of incomes of everyone with this
> Firstname", "sum of incomes of every
On Aug 19, 10:40 am, "Heston James - Cold Beans"
<[EMAIL PROTECTED]> wrote:
> ... ZSI requires that datetime's in the objects be in
> Python Time Tuples as documented in the 'time' module.
>
> Is there any way in which I can configure SQLAlchemy to return me time
> tuples instead? Or perhaps a che
TkNeo wrote:
> I am trying to connect to an MS SQL server 2000 ...
> using Integrated Security and not use a specific username and
> password. Can anyone tell me the format of the connection string ?
...
> I tried installing pymssql which requires a minimum of python 2.4
> and all I have is pytho
(sqlalchemy 0.4.4/pymssql/windows/pylons)
Our MS SQL legacy database has column names with spaces and sometimes
other special characters. I'm able to get sqlalchemy to work with it
by having every column object include quote=True, and by having the
mapper() call include:
,properties= {'NameJamme