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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-10 : 09:09:05
|
Bill writes "[IS This an ADO Guru question or an SQL Guru question? I don't know. Sorry]
I have a web page that pulls together 15 record sets related to a single item
for sale. I choose to use ADO's Hierarchical Recordsets to pull this
information together and for the sake of simplicity, I wrote a stored procedure
that accepts two pieces of information: offer_no, and the type of information of
obtain. Here's a shortened version of the query:
SHAPE {SELECT 6700123 AS offer_no, fl7905.offer_status
FROM fl7905 WITH (NOLOCK)
WHERE fl7905.offer_no = 6700123}
APPEND ({EXEC spGetRecap 6700123, 'color'} AS color RELATE offer_no TO offer_no),
({EXEC spGetRecap 6700123, 'leaf'} AS leaf RELATE offer_no TO offer_no)
This code works wonderfully in an IIS5/ADO2.6/SQL7 environment, but it appears
to cache the results from the first appended record set, returning them for the
results of the record appended recordset. It's as if the stored procedure's
parameters are being cached. Executing the individual SQL pieces in Query
Analyzer returns the correct results. We replaced the single stored proc with
customized procs for each situation (one for color, one for leaf, etc), rebuilt
the SHAPE call, and it works fine.
I find it difficult to believe that we've found something you can do with
IIS5/ADO2.6/SQL7 that CAN'T be done with IIS5/ADO2.6/SQL2000, but I'm hard-
pressed to offer any other explanation. Help!" |
|
|
|
|
|
|
|
(No topic)