I have a link which opens new popup window.
I need to make it so, every time i click on the link it will open new window(without closing previous one).
Thank you
If i have a string separated by commas, let it be the following
==========Text=============
New York, Paris, London, Boston
========== End=============
When a user clicks on word "Paris", I need to get the word "Paris" out of the string, so it will be look like this...
Please if anybody can show me how to make a text looks like a hyperlink.
For example if i have a string: "John, Andy, Steve" i need each comma dilimited names to be underline and when i hover over it shows a "hand" as mouse pointer. Since the text is inside of the TEXTAREA, i think it needs to...
I have a text area with comma delimited string.
Let's say it's: "New York, Paris , London," i would like to click on one of the word and get it removed from the text area.
So if i click on Paris, then it's going to be only " New York , London".
Is it possible to accomplish it in any way...
I need a help with the following scenario.
I have two dynamic SQL like this:
DECLARE @sSQL_ID varchar(1000)
SELECT @sSQL_ID= 'SELECT ID FROM Store WHERE StoreLocation='New York'
DECLARE sSQL varchar(1000)
SELECT @sSQL = 'SELECT * FROM City WHERE StoreID = @sSQL
Of course the second statement...
****if you are using sql server, google fn_split*****
I'm not looking for the split function, i have it ready. The problem i'm facing is in my last reply before this one.
This is actually not a physical table it's a TABLE variable which i populate dynamically inside a SP and it wont have more then 100 records at a time, so performance is not an issue here i think.
You said: "in the stored proc, take your @Lastname parameter and extract each item separately"...
I have a LastName field which holds this data
LastName
Johnson|Vasques
Adams|Fox|Johnson
Vasques|Smith
Now let’s say I have a SELECT Stored Procedure which takes 1 parameter @LastName.
The @LastName can be something like this: “Fox|Smith”.
I would like to have my SP to return me all of the...
I have 3 tables: Authors, Employee and Stores.
I need to create a stored procedure which will take 3 comma delimited parameters, to be able to query above 3 tables.
Basically my front end user can say give me Authors with last name starting from ‘A,B’ and Employee with first name starting from...
I’m passing a comma separated parameter (home, world, child) into stored procedure.
I have a Slitter function which is basically creates a table out of delimited list.
My stored procedure needs to find matched records in one of the table based on delimited list.
I have something like this...
Hi all,
I have two User Control(UC2 inside UC2).
I need dynamically create LinkButton in UC2(.ascx) and capture Click event in UC1(.ascx).
Please help.
Thanks
**********************************
So the number they request is the MINIMUM? You want what matches and any additional following consecutive rows?
**********************************
Yes, you are correct.
*********************************************************
Illyxer,
One question just came up. What if your user enters 2 and the data is:
1
2
3
4
6
7
9
Do you want 1 & 2 returned? It is the first occurance of two consecutive rows, it's also the first of 4. Or do you want 6 & 7 returned as it...
****************************
If I entered 2, the result should return only 1 & 2 (first 2 consecutive rows. Even though 4&5 meet the criteria, they aren't the FIRST occurance.). If I enter 4, I should get 9, 10, 11, 12 as that's the first 4 consecutive rows.
Illyxer, let us know if my...
User do not ADD , he will enter 3 as a parameter to pass to the query. If user enters 3 I basically want to query the table and find first 3 consecutive matches. I he enters 72, the query should look for 72 consecutive rows.
Hello all,
I have a table Orders which has 3 columns : Invoice_Number, invoice_date and invoice_status.
It looks like this:
Invoice_Number | invoice_date | invoice_status
________________________________________________
0001 | 01/12/2001 12:00...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.