Two queries within a procedure...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Two queries within a procedure...

Author

Topic

kam
Starting Member

17 Posts

Posted - 2006-03-09 : 21:14:43

Hi,
I have two queries within a procedure, when running the query within sql sever it retuns the values from both:

subID       userID      subName                                            category                                           bbox                                               
----------- ----------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- 
4           3           my house                                           All                                                392362.036001,424603.15882,427412.466218,452731.25

(1 row(s) affected)


(1 row(s) affected)

xList                                                                                                                                                                                                                                                            yList                                                                                                                                                                                                                                                            
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
4.141934468218742e+005,4.130918618721971e+005,4.146941672535457e+005,4.166970489802314e+005,4.165969048938971e+005,4.157957522032228e+005,4.143937349945428e+005                                                                                                 4.366580556430000e+005,4.350507360666000e+005,4.339256123631200e+005,4.346489061725000e+005,4.356132979183400e+005,4.363365917277200e+005,4.365776896641800e+005

(1 row(s) affected)

but I'm trying to return read these values in coldfusion, which throws and error saying that XLIST is undefined, but the values from the first query are processed fine. Any ideas?

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2006-03-09 : 21:40:06

I don't think Cold Fusion supports multiple resultsets. You might have to break your proc up into two.

Damian
"A foolish consistency is the hobgoblin of little minds." - Emerson

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources