|
-
September 23rd, 2002, 02:10 AM
#1
How i can use one ADO Command object for 2 recordsets.
i have done 2 stored procedures in SQL server 7.0..
On one ASP page,
i am calling one stored procedure 2 time susequently..
That prcedure is to fill combo-box..
First time i am seding parameters..
table name. display column,value comumn and order by column.
if my first call is for table 'App_Mast' and second call is for table 'Role_Mast' then i am getting error for right truncation.
i think length of 'role_mast' word is greater than 'app_mast' word so that inner parameters of stored procedure does not allowed next call of bigger length..
is stored procedure.. can not be called subsequently using same ADO command object..
Last edited by sachin_gokhale; September 24th, 2002 at 05:22 AM.
sachin
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
