Search results for query: *

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

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

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

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

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

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

Hi i have a table that i want to store text in What is the maximum Lenght of the column can be. I can not find anywhere on the interent where it says there is a max.

Hi i am doing this statement SELECT * FROM FORM_VALUES WHERE FORM_NAME = 'CUSTOMER_COMPLAINT.12.14.2004' AND (FIELD_TYPE = 'A' OR FIELD_TYPE = 'D' OR FIELD_TYPE = 'N') I am getting other values from the table that do not have FORM_NAME = 'CUSTOMER_COMPLAINT.12.14.2004' I need to select where...

Hi has any one ever seen an asp that has a link that pops up a little notepage editor and then returns back to the asp ...... Cheers

I have a table that im trying to space with spacer image and it is leaving space so it looks like two lines <table width="760" border="" bordercolor="#333366" bgcolor="#CCCCCC" > <tr> <td border="" bordercolor="" bgcolor="" > <input name="449" type="text"...

hi i have a form qty on hand <%if request("QtyOnHand") = "" then QtyOnHand = 0 else%> <% QtyOnHand = CDBL(QtyOnHand)%> <%response.write "on hand" & QtyOnHand end if When i put in value of 5...the value im getting is 0 i thought CDBL would give me 5 so if they put in 17.28 it...

hi there i have a form <form name="form1" method="post" action="form_entry_update.asp"> But i want to add two buttons... One button will be called SEARCH...and the other will be UPDATE Now if i select UPDATE i want it to actually go and do the form_entry_update.asp If i select SELECT i want...

im trying to access a table but i want to determine what table to read DECLARE @TABLE_NAME NVARCHAR(50), @COLUMN_NAME NVARCHAR(50) select DISTINCT @COLUMN_NAME FROM @TABLE_NAME But im getting error...saying define @TABLE_NAME is it actually possible to do this

First page What im trying to do is update the input name of FIELD_ID_<%=rs("FIELD_ID")%> with what i select from the window. <td width="<%=rs("FIELDNAMESPACE")%>" border="<%=TRIM(rs("BORDERSIZE"))%>" bordercolor="<%=TRIM(rs("BORDERCOLOR"))%>" bgcolor="<%=TRIM(rs("BGCOLOR"))%>" > <input...

Hi there i have the following FSSERIES.12.3.2004 FSSERIES.12.14.2004 INS.12.5.2004 INS.12.7.2004 where it is form name plus a date So i need to get the max record for each of the Forms so i would only see FSSERIES.12.14.2004 and INS.12.7.2004 Any suggestions

i have field type of DATETIME and need to return this in select as '1/1/2004' I tried this select CONVERT(NVARCHAR(15),FIELD_DATE,112) as 'FIELD_DATE' , * from form_values but when i do thist in ASP nothing is being printed out if rs("FIELD_DATE") = trim(request("txtSearch")) then...

Hi i have data in a table that is being displayed as 37571-1-A009 37571-1-A008 37571-1-A0038 37571-1-A0037 37571-1-A0036 37571-1-A0035 37571-1-A0034 37571-1-A0033 37571-1-A0032 37571-1-A0031 37571-1-A0030 37571-1-A0029 37571-1-A0028 37571-1-A0027 37571-1-A0026 37571-1-A0025 37571-1-A0024...

I have this BLOWER_SERIAL_NUMBER = rtrim(request.form("BLOWER_SERIAL_NUMBER")) BLOWER_SERIAL_NUMBER = replace(BLOWER_SERIAL_NUMBER,"'", "''") My replace is giving me a syntax error I cannot figure it out

hi i have select * from INSPHEADER WHERE SERIAL_NUMBER LIKE 'INT00138' + '%' but im trying to code in ASP txtSerialNumber = request("SerialNumber") & " % " sqlHeader = "select INSPHEADER.SERIAL_NUMBER, INSPHEADER.BASE_ID, INSPHEADER.PART_ID, INSPHEADER.LOT_ID, INSPHEADER.PART_ID...

Hi i have our intranet site on server_03 and need to access some diagrams from server_02 What would be the best way to access the diagrams