Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lllyxer
  • Order by date
  1. lllyxer

    window.open help please.

    Crazy, that simple. Thank you mate.
  2. lllyxer

    window.open help please.

    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
  3. lllyxer

    Get text on mouse click

    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...
  4. lllyxer

    Fake hyperlink

    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...
  5. lllyxer

    Remove text from Text Area

    Not IE?
  6. lllyxer

    Remove text from Text Area

    Thanks, but it doesn't look like it works. The var pos=what.selectionStart returns "underfined". Please take a look and thanks again.
  7. lllyxer

    Remove text from Text Area

    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...
  8. lllyxer

    Dynamic SQL

    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...
  9. lllyxer

    Not so simple SELECT

    ****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.
  10. lllyxer

    Not so simple SELECT

    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"...
  11. lllyxer

    Not so simple SELECT

    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...
  12. lllyxer

    Dynamic WHERE clause alternative.

    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...
  13. lllyxer

    Comma separated value

    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...
  14. lllyxer

    Event handler between two user controls.

    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
  15. lllyxer

    Need help with Select query

    Hello , I have a table WORDS. Word_id | word_name | word synonym 1 | oval | egg-shaped 2 | oval | rounded 3 | voyage | travel 4 | voyage | journey 5 | voyage | trip In the output I’m looking...
  16. lllyxer

    Get consecutive rows

    ********************************** So the number they request is the MINIMUM? You want what matches and any additional following consecutive rows? ********************************** Yes, you are correct.
  17. lllyxer

    Get consecutive rows

    ********************************************************* 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...
  18. lllyxer

    Get consecutive rows

    **************************** 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...
  19. lllyxer

    Get consecutive rows

    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.
  20. lllyxer

    Get 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...

Part and Inventory Search

Back
Top