|
declare @exp varchar(100)
set @exp = '12,13,14'
declare @start int
declare @substring varchar(20)
set @start = 1
while(@start <> 0)
begin
set @start = charindex(',' , @exp , @start)
if(@start = 0)
return
print @start
--print substring(@exp , @start ,
set @start = @start + 1
end
i want the following output
12
13
14
how should i get it
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
|
|
One good way is to pass XML and use OpenXML instead of string mashing.
But, it's true you're in the wrong forum.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Check-out this SQL split function
http://www.devx.com/tips/Tip/20009
Here is my modified (0.1%) code.
DECLARE @String nvarchar (4000)<br />
DECLARE @Delimiter nvarchar (10)<br />
<br />
SET @String = '12,13,14'<br />
SET @Delimiter = ','<br />
<br />
declare @NextString nvarchar(4000)<br />
declare @Pos int<br />
declare @NextPos int<br />
declare @CommaCheck nvarchar(1)<br />
<br />
--Initialize<br />
set @NextString = ''<br />
set @CommaCheck = right(@String,1) <br />
<br />
--Check for trailing Comma, if not exists, INSERT<br />
--if (@CommaCheck <> @Delimiter )<br />
set @String = @String + @Delimiter<br />
<br />
--Get position of first Comma<br />
set @Pos = charindex(@Delimiter,@String)<br />
set @NextPos = 1<br />
<br />
--Loop while there is still a comma in the String of levels<br />
while (@pos <> 0) <br />
begin<br />
set @NextString = substring(@String,1,@Pos - 1)<br />
<br />
PRINT @NextString<br />
<br />
set @String = substring(@String,@pos +1,len(@String))<br />
<br />
set @NextPos = @Pos<br />
set @pos = charindex(@Delimiter,@String)<br />
end<br />
<br />
BTW, this is ASP.NET forum. (You have been here for long time so you know that, right? )
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
|
declare @exp varchar(100)
set @exp = '12,13,14'
declare @start int
declare @substring varchar(20)
set @start = 1
while(@start <> 0)
begin
set @start = charindex(',' , @exp , @start)
if(@start = 0)
Begin
select substring(@exp,@start+1,2)
return
end
select substring(@exp,@start+1,2)
set @start = @start + 1
end
Devjit Das.
|
|
|
|
|
InsDev wrote: if(@start = 0)
Begin
select substring(@exp,@start+1,2)
return
end
it is not certain wherther the length will be = 2 or more then 2
if i replace 2 with len(@exp)
again bug starts to occur
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
What's the problem in the following
declare @exp varchar(100)
set @exp = '12,13,14'
declare @start int
declare @pos int
declare @substring varchar(20)
set @pos = 1
set @start = 1
while(@pos <> 0)
begin
set @pos = charindex(',' , @exp , @start)
if(@pos = 0)
begin
print substring(@exp , @start , len(@exp))
return
end
print substring(@exp , @start , @pos -1)
set @start = @pos + 1
end
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Hi,
I have a static non-dynamic 2 select list box. Example:
1) <asp:DropDownList id="cboYear" runat="server">
<asp:ListItem Value="2007">2007</asp:ListItem>
<asp:ListItem Value="2006">2006</asp:ListItem>
<asp:ListItem Value="2005">2005</asp:ListItem>
<asp:ListItem Value="2004">2004</asp:ListItem>
</asp:DropDownList>
2) <asp:DropDownList id="cboDate" runat="server">
<asp:ListItem Value="200706">Jun 2007</asp:ListItem>
<asp:ListItem Value="200705">May 2007</asp:ListItem>
<asp:ListItem Value="200704">Apr 2007</asp:ListItem>
<asp:ListItem Value="200606">Jun 2006</asp:ListItem>
<asp:ListItem Value="200605">May 2006</asp:ListItem>
<asp:ListItem Value="200604">Apr 2006</asp:ListItem>
<asp:ListItem Value="200508">Aug 2005</asp:ListItem>
<asp:ListItem Value="200506">Jun 2005</asp:ListItem>
<asp:ListItem Value="200505">May 2005</asp:ListItem>
<asp:ListItem Value="200409">Sep 2004</asp:ListItem>
<asp:ListItem Value="200405">May 2004</asp:ListItem>
</asp:DropDownList>
So i wonder how to create a dependent select list? I want the cboDate to be appear for year that was selected on cboYear. Example: if i select cboYear 2007, i want cboDate to show only 2007 list. Can it be done?
Please help. Thx.
|
|
|
|
|
Handle the event when list one's selected index changes, and either through AJAX or a postback, repopulate list two accordingly
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
thx for reply.
BUT if i use a postback, will that refresh the page? If i don't want the page to be refresh is it possible?
i using ASP.NET C# code.
Thx.
|
|
|
|
|
Put the dropdownlist in updatepanel so that part of the page will be refreshed.
God is always with you.
|
|
|
|
|
|
|
The simple answer: NO
Reason: Security Reasons implemented by the web browser.
You need not know the file path where it gets stored in the client web browser.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
hi deepak is there is any way if u know u plz send the code for me it will be useful for me
|
|
|
|
|
Your response to 'you can't' is, 'please send me to code' ? Is someone paying you for your time right now ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
You seem to have a passion of asking the same question so many times in this forum. Appreciate your persistence and endurance but I don't think at least for the security of millions of people, web browser companies are going to relax the security model. Please read through http://www.codeproject.com/scrapbook/forumguidelines.asp[^] on effective querying in discussion forums.
Now coming to your specific query:
If you want to really go into 'Path Trapping', I would suggest an ActiveX Control to be written which can read the file from the server and save it to the client browser.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
|
|
|
|
|
Can I have your bosses email address please ? I think he needs to know that your approach to solving a problem is to ignore the advice you've been given and just ask again, in the hope that someone will come along who can change reality for you.
You can't. You just can't. And even if you could, you could not interact with that path in any way. You could perhaps render it, but that's all. And, you can't.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi professionals,
First, I am sorry to repost my question but this time it has more accurate information to help getting the good answer.
I am planning to launch a website like youtube, but it is meant for different purpose, it will have very similar functionality to youtube, more precisely it will have:
1. Simple interface design, but professional design (I mean no graphical complications, yet great reachbility of video content).
2. Makes intensive use of AJAX to update the user-interface.
3. Needs to be able to handle thousands of users surfing the site at the same time.
4. Needs to manipulate large amounts of data in different databases efficiently.
5. Needs to embed media controls like flash video, real player, windows media player in web-pages.
6. Functionality includes user profiles, e-mailing, video rating, video commenting and everything youtube has.
I don't know what technology I should use in building this project, is it ASP .NET or PHP? I know little about ASP .NET and I know nothing about PHP.
For now let us make the following assumptions:
1. Regarding video content management, let us assume that the problem of load-balancing and all problems regarding video managemnt (upload, download, etc) are already solved by a professional company.
2. Let us assume that my goal is to implement user profiles, rating, commenting, signing up, etc. also I want to make my site able to handle thousands of users simaltanously sending msgs to each other, logging in and out, rating, commenting, etc.
I need to use a tool that is very productive, relatively easier and reliable to build a world-class project, I need it to be able to handle millions of database records and thousands of users surfing the website simaltanously.
I know that this is a ASP.NET forum so it is likely to see more people recommending ASP .NET, but I need you to be fair, so I need justifications ,please.
Any help professionals?
Thanks in advance.
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
Mohammad A Gdeisat wrote: I know little about ASP .NET and I know nothing about PHP.
What about Java? now, you are trying to create the website like YouTube. good. If you wanna create the Search engine like Google one day, Java might be useful..
Mohammad A Gdeisat wrote: I need to use a tool that is very productive, relatively easier and reliable to build a world-class project
It's depend on your expertise. (There are a lot of "world-class" projects which are written in PHP, ASP.NET and Java.)
but one thing for sure is that little knowledge about ASP.NET and nothing about PHP can't help you to build the "world-class" projects .. no matter which tool you are using.. So, The best advice would be "learn more about ASP.NET or PHP or Java".
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Thats exactly what I want to do -
1st let experts help me find the better langauge for this application - find the right thing to learn
second learn the better technology or give the project to an expert.
what I need to know is what is more useful in this specific application, PHP or ASP.NET or any other?
I don't want to learn one language and then find that another language can assist me better building this website, sure, I don't want to build a "world-class" project with little knowledge, thats impossible 
Thanks
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
Final Answer : ASP.NET 2.0
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
I can only reiterate that if you know little about ASP.NET and nothing about PHP, the answer is that you may as well use Logo, no way are you going to be able to do this.
If this is a business idea, consider hiring someone to impliment it. If it's a rentacoder job gone bad, cut and run. That's really where it's at. As I said before, PHP and ASP.NET are both equally capable of doing this. Your player will end up being some sort of embedded app, so probably Java, and the rest is just a bit of HTML which is not going to be hard. But, it still sounds like you're biting off far more than you can chew, to be repeatedly asking this question.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
