var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can you assign the select result of a stored procedure as a value?
Hi all, hope you can help.
I was wondering if it is possible to assign the search result of a stored procedure as a value?
what i mean is, is it possible to do something like this?:
sSQL = "exec spGetUserName"
SET oRS = oDB.Execute(sSQL)
If Not oRS.EOF then
with a stored procedure of:
ALTER PROCEDURE [dbo].[spGetUserName]
SET NOCOUNT ON;
The above exmaple is probably wrong, but hope i have explained myself properly.
I think we've covered this before... http://www.dbforums.com/asp/1647320-...ml#post6420144
Ideally you want to use nothing but sprocs to access your data, so you are definately on the right tracks!
Hi gvee, thank you for the reply.
I couldn't remember if i had, I've been away on holiday and have had to pick it up again after a number of weeks, sorry for asking the same question twice.
I have to be honest, I still cant work out how to do it even when people say im on the right lines, I struggle to see them.
I'll read everything over again.
Give it a go and if you can't get it to work, post back your code highlighting any error lines/messages that you recieve and we can most likely help
Hi, you're too kind, I will have and go hopefully i can make some head way, or at least add my thoughts / code to help resolve the issue.