[Plone-users] Re: [Zope-DB] MS SQL stored procedures and MXODBCDA - supposedly NO RESULTS

[Peter Millar]

There are no errors that is part of the problem ... I simply get a
message 'no results returned'

Yet there are results.

____________________________________________ 
Peter Millar 


-----Original Message-----
From: plone-users-admin at lists.sourceforge.net
[mailto:plone-users-admin at lists.sourceforge.net] On Behalf Of M.-A.
Lemburg
Sent: Tuesday, 29 June 2004 5:40 PM
To: Peter Millar
Cc: egenix-users at lists.egenix.com; Zope-DB at zope.org;
plone-users at lists.sourceforge.net
Subject: [Plone-users] Re: [Zope-DB] MS SQL stored procedures and
MXODBCDA - supposedly NO RESULTS


Peter Millar wrote:
> How come when I run my stored procedure from the query analyzer I get 
> a swag of results but if I run it from zope I get no results returned.
> 
> Is it because the odbc driver or zsql cannot handle such a simple 
> stored procedure as this one where a temporary table is created, 
> populated, queried, and finally dropped.

What kind of errors do you get ? (Please always copy them into your
reports; otherwise there's nothing much list readers can do to help)

> CREATE PROC myState
> @StartDate DateTime, 
> @EndDate DateTime, 
> @Name varchar(256)
> 
> AS
> --Create a temporary table containing the history data
> CREATE TABLE #DisAgg (name varchar(256), dt datetime, value int) 
> INSERT #DisAgg  SELECT name, DateTime, Value
>   FROM y
> 
> SELECT
> b.name,
> b.dt as enddate, 
> FROM #DisAgg b 
> WHERE b.value = 0
> 
> --Drop temporary tables
> Drop table #DisAgg
> 
> ____________________________________________
> Peter Millar 
> Technical Project Manager 
> Parasyn Controls Pty Ltd 
> 
> Peter.Millar at Parasyn.com.au
> T: 61 7 3396 6388 
> F: 61 7 3396 6299 
> 45 Millenium Place, Tingalpa QLD 4173 
> PO Box 400 Cannon Hill QLD 4170 
> Australia 
> www.parasyn.com.au <http://www.parasyn.com.au/>  
> 
> 
> 
> 
> ----------------------------------------------------------------------
> --
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org http://mail.zope.org/mailman/listinfo/zope-db

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jun 29 2004)
 >>> Python/Zope Consulting and Support ...
http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...
http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...
http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::


-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training. Attend
Black Hat Briefings & Training, Las Vegas July 24-29 - 
digital self defense, top technical experts, no vendor pitches, 
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
Plone-users mailing list
Plone-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/plone-users