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 dencom 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
  • Content: Threads
  • Order by date
  1. 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
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. 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...
  11. 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...
  12. lllyxer

    Stored procedure help

    I have a table FEES. It has columns like fee_id, return_code,fee_source , application_fee, approval_fee and denial_fee I need to create a stored procedure that will get SUM of application_fee and SUM of approval or denial fee(see logic below) . The trick here is to get the right field based...

Part and Inventory Search

Back
Top