Search results for query: *

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

Where would that code go before the select ? Thanks

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

Ok let me research ....the keywords cheers

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

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

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

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

Thanks i got it

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

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

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

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

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

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

It was not an editor i was looking for . It was a utility that when an actual web page displays... The user pops up a little area that they can type in their text.......paragraphs.....also like an note pad then when the user saves the info it writes it to your database...

In file directory make sure you have IWAM, ISUR accounts set up.....then on then go to the default web site on the IIS and then click on your folder ....where your files are virtual directory and then properiteis directory security and make sure anonyomous is set... that should be it

Hi there was a utility called IIS5RECYCLE that can be run on windows 2000 but on XP it cannot be run...... Any one know how to clear out the processes in IIS without this tool...

I didn't even think you cold type in chinese characters on to a page?

Hi i have managed to get a form created and then user fills it in...its looks great on the screen they can scroll up and down Now i need to print this out for them........(But how do i get the text box to print out)... So they can see it. My mind has got confused how i can do this. The data is...