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!

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

Recent content by TRACEYMARYLAND

  1. TRACEYMARYLAND

    SQL In range

    I just did this CHARINDEX(',' + CAST(VMFG.DBO.PART.PRODUCT_CODE as varchar(100)) + ',',',' + case @str1 when '' then CAST(VMFG.DBO.PART.PRODUCT_CODE as varchar(100)) else @str1 end + ',')>0 That seems to work
  2. TRACEYMARYLAND

    SQL In range

    Where would that code go before the select ? Thanks
  3. TRACEYMARYLAND

    SQL In range

    hi i have declare @str nvarchar(50), @str1 nvarchar(50), @str2 nvarchar(50), @str3 nvarchar(50) set @str1 = 'CHEMBIO' set @str2 = 'DECON' SELECT ORDERNUM, DESCR, VMFG.DBO.CUST_ORDER_LINE.PART_ID,LINE_NO,VMFG.DBO.PART.PRODUCT_CODE,* FROM PRODSCHED INNER JOIN VMFG.DBO.CUSTOMER_ORDER ON...
  4. TRACEYMARYLAND

    Return rows where string matches

    Ok let me research ....the keywords cheers
  5. TRACEYMARYLAND

    Return rows where string matches

    I have a description field that consists of (1)SD3-UZA08-GZ(2)LF-40-1(8)FR-24-48(4)HS-X-P(1)WP-18-S(2) (1)SFR-UZA08-ZK (1)SCM-WaA09-ZG(2)DG-5.5(4)LF-40-1(1)AH-125-15(1)WP-18-S(1)WH-340-1-1 (2)SD1-TTB02-GZ (1)SD3-UZA08-GZ(2)LC-1810-X(1)LCA-B(4)HS-X-P(8)FR-24-48 (1)SCM-WaA10-ZG...
  6. TRACEYMARYLAND

    simple folder question

    i could never get the UNC link to work either, how did u do the map part....
  7. TRACEYMARYLAND

    Web Page Wont Display IIS5!!!

    oh i forget the name its...dllhost.exe
  8. TRACEYMARYLAND

    Web Page Wont Display IIS5!!!

    run iis5recyle its a tool that will clear out yr server deadlocks. try this first... go to applications tasks alt tab and delete dll.host
  9. TRACEYMARYLAND

    ASP text area problem

    Thanks i got it
  10. TRACEYMARYLAND

    Can;t delete if inner join

    Thanks i get a bit worried with deletes ..... Cheers
  11. TRACEYMARYLAND

    Can;t delete if inner join

    Like so DELETE DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS FROM DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS INNER JOIN VMFG.DBO.WORK_ORDER ON DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS.WORKORDER_BASE_ID=VMFG.DBO.WORK_ORDER.BASE_ID WHERE VMFG.DBO.WORK_ORDER.STATUS NOT IN ('F','R') So before i run it...
  12. TRACEYMARYLAND

    Can;t delete if inner join

    hi my select works but when change select to delete from it errors on inner join SELECT * FROM DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS INNER JOIN VMFG.DBO.WORK_ORDER ON DATAWAREHOUSETEST.DBO.SHELTERPRODUCTS.WORKORDER_BASE_ID = VMFG.DBO.WORK_ORDER.BASE_ID WHERE VMFG.DBO.WORK_ORDER.STATUS IN...
  13. TRACEYMARYLAND

    How do I access a .Net dll in asp?

    It has to be registered on the Server. What you can try is to register just the email dll cdonts and see if that at least works..... I not so sure about C# but i know VB it has to be active X dll.... Thats all i can offer
  14. TRACEYMARYLAND

    ASP text area problem

    hi i have textarea and i allow user to type in so for example i have line1 line2 line3 line4 In database i see just line1 when i do delete after the line 1 i see line2 comes in....so it must have a carriage return in the data. So now i did to display it What i want to do is just display in...
  15. TRACEYMARYLAND

    hyphen in text file problem

    Can you remove the ' first before importing the data.. and then to put in the data use the replace function Replace(strName, "'", "''")
See more

Part and Inventory Search

Back
Top