Is this now fixed in trunk?
On Jun 2, 9:51 am, Ross Peoples wrote:
> AHAH!
>
> I figured out what it was. I will post in a new thread since it actually has
> nothing to do with the DAL at all, but rather the new behavior of the
> Storage() object.
AHAH!
I figured out what it was. I will post in a new thread since it actually has
nothing to do with the DAL at all, but rather the new behavior of the
Storage() object.
Doing a little more research on this:
This happens when doing an INSERT. And the exact error I get:
DataError: ('22007', '[22007] [FreeTDS][SQL Server]Syntax error converting
datetime from character string. (241) (SQLExecDirectW)')
What's happening is my application is importing data from a leg
This patch that was added to the trunk breaks my application which runs on
MSSQL. Whenever I try to read a datetime from MSSQL now, I get a syntax
error about not being able to parse the date time from a string. Reverting
my web2py installation to to R-1.96.1 fixes the problem.
On 1 jun, 16:32, Massimo Di Pierro wrote:
> fixed in trunk... I am sure we will have 1.96.2 soon although this is
> a pre-existing problem.
Work fine. Thanks.
Jose
fixed in trunk... I am sure we will have 1.96.2 soon although this is
a pre-existing problem.
On Jun 1, 2:28 pm, Jose wrote:
> On 1 jun, 16:18, Massimo Di Pierro wrote:
>
> > Can you try replace:
>
> > return "DATEPART('%s' FROM %s)" % (what, self.expand(field))
>
> > with
>
> > return "DATEPART
On 1 jun, 16:18, Massimo Di Pierro wrote:
> Can you try replace:
>
> return "DATEPART('%s' FROM %s)" % (what, self.expand(field))
>
> with
>
> return "DATEPART(%s, %s)" % (what, self.expand(field))
>
I tried from the console, this work fine. SQL:
select * FROM my_table WHERE DATEPART(year,
my_
Can you try replace:
return "DATEPART('%s' FROM %s)" % (what, self.expand(field))
with
return "DATEPART(%s, %s)" % (what, self.expand(field))
-- Forwarded message --
From: Jose
Date: Jun 1, 2:05 pm
Subject: Bug in MSSQLAdapter.EXTRACT
To: web2py-users
Hi
This is using MS SQL
8 matches
Mail list logo
