C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




stored procedure


Posted Date: 05 Jul 2008      Total Responses: 4
Posted By: krishna chaitanya       Member Level: Silver     Points: 1



hi,

sUserAcls=40
sUserAcls1=60

sUserAcls2 = sUserAcls + "," + sUserAcls1
sites = sUserAcls2.Split(",")
Dim str As String = "m.Acls like '%'+'" + sites(0) + "'+'%'"
For i = 1 To sites.Length - 1
str = str + " " + "or" + " " + "m.Acls like '%'+'" + sites(i) + "'+'%'"
Next i
numFolders1 = foDb.GetNumFolders1(str)

GetNumFolders1--->this is my s.p name

in str am getting values as
str=m.Acls like '%'+'40'+'%' or m.Acls like '%'+'60'+'%'
so now i want to execute this str value in my s.p query as a where condition

my s.p is
@Acls =str -->hear that str value will come
declare @site as varchar(100)
set @site="Select * from Documents m where" (@Acls)
exec string
this is not working plz tell me any changes in my s.p





Responses
Author: Sujit Kumar    05 Jul 2008Member Level: DiamondRating:     Points: 3

please change in your s.p like :
give column name instead of * in your query.

@Acls =str -->hear that str value will come
declare @site as varchar(100)
set @site="Select site from Documents m where" (@Acls)



Author: Bunty    05 Jul 2008Member Level: DiamondRating:     Points: 1

Hi,

Modify the above code with the below one and execute

give column name instead of * in your query.

@Acls =str -->hear that str value will come
declare @site as varchar(100)
set @site="Select site from Documents m where" (@Acls)

Thaks and Regards
S.S.Bajoria



Thanks & Regards
S.S.Bajoria



Author: http://dotnetvj.blogspot.com    05 Jul 2008Member Level: DiamondRating:     Points: 2

Hi

set @site='Select * from Documents m where' + '(' + @Acls + ')'

Modify ur query.

Thanks -- Vj
http://dotnetvj.blogspot.com

Thanks -- Vj

http://dotnetvj.blogspot.com



Author: Gaurav Agrawal    06 Jul 2008Member Level: DiamondRating:     Points: 3

Register urself on this site for earning money by using this link

http://www.rupeemail.in/rupeemail/invite.do?in=MTAxNTM0JSMlS0hqblZtUFI0c3BmTmw2azNNVDhyb1dCaA==

GA



Post Reply
You must Sign In to post a response.
Next : how to get foreignkeys of a table
Previous : generate id in sql server 2005
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers   BizTalk Adaptors    Web Design

Contact Us    Privacy Policy    Terms Of Use