[Zope-DB] MS SQL stored procedures and MXODBCDA - supposedly NO RESULTS

M.-A. Lemburg mal at egenix.com
Tue Jun 29 03:39:55 EDT 2004


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 ! ::::


More information about the Zope-DB mailing list