python-sybase-misc

[python-sybase] passing a date as a parameter in a select query

[Python <py...@ve...>]

I am running Linux with freetds and connecting to a MS SQL server.  I'd
like to select records newer than a specified datetime value, but have
been unsuccessful.

>>> td = DT.today()
(imported mx.DateTime as DT)

>>> nsql.execute("select * from IMAGES where updated > @latest", {'@latest': td})
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/home/lkvam/load.py", line 68, in execute
    curs.execute(cmd, parms)
  File "/usr/lib/python2.3/site-packages/Sybase.py", line 759, in
execute
    buf = DataBuf(value)
TypeError: unsupported parameter type
>>> td
<DateTime object for '2006-08-03 00:00:00.00' at b7ccc0c8>

The Sybase module is importing mx.DateTime
>>> ln.Sybase.use_datetime
1
>>> ln.Sybase.DateTime
<module 'mx.DateTime' from '/usr/lib/python2.3/site-packages/mx/DateTime/__init__.pyc'>

I looked at the C code to try to get a handle on DataBuf, but did not
figure it out.

I also tried to simply specify the date as a string in the SELECT query,
but could not figure out a pattern that worked (I mostly use MySQL).  

Any help would be greatly appreciated.

-- 
Lloyd Kvam
Venix Corp

Re: [python-sybase] passing a date as a parameter in a select query

[Marcos P. <ma...@bu...>]

Not a solution, but it might help.
MS SQL seems to understand {d'2006-08-03'} as a correct date value.

El jue, 03-08-2006 a las 20:14 -0400, Python escribió:
> 2006-08-03

Re: [python-sybase] passing a date as a parameter in a select query

[Python <py...@ve...>]

On Fri, 2006-08-04 at 09:41 +0200, Marcos Sánchez Provencio wrote:
> Not a solution, but it might help.
This is a good enough solution for me.  I can deal with some funny
string formatting.

> MS SQL seems to understand {d'2006-08-03'} as a correct date value.
> 
> El jue, 03-08-2006 a las 20:14 -0400, Python escribió:
> > 2006-08-03
> 
-- 
Lloyd Kvam
Venix Corp