Search results for query: *

Hi i have this bit of code Dim item For Each item in Request.Form Response.write "<input type=text name=FieldName value=" & item & ">" & vblf Response.write "<input type=text name=FieldValue value=" & Request.Form(item) & ">" & vblf Next which outputs all field names and their values onto a...

Hello I've been asked to install a dll, from our software supplier as per below (see below). Never done anything with COM+ before, how can i go about this please ? i presume there are no security risks ? the dll is from a trusted supplier. My Services has COM+ event system started but COM+...

thanks to everyone - it is now working ok, i relaised the char field was causing problems because it was padding out with spaces, so i changed it in the SP and parameters append to varchar. thank you tony

...have my sp, using optional parameters as below, still no joy, does this look about right ? I will search google.......... thanks again /* ALL parameters are optional */ @RegNo char(10) = null, @Make varchar(50) = null, @Colour varchar(50) = null, @Location varchar(250) = null as IF @RegNo...

...end if rec1.close set rec1 = nothing end sub sp usp_GetAbanVehicles_lucky CREATE PROCEDURE [dbo].[usp_GetAbanVehicles_lucky] /* ALL parameters are optional */ @RegNo char(10), @Make varchar(50), @Colour varchar(50), @Location varchar(250) as select tblAbandonVeh_ISB.CallID...

Hi Borislav thanks yeah that seems to only return one customer. thanks anyway

thank you very much ! works a treat re. 3rd party software - not this one ! i guess you get what you pay for...............

don't know...............3rd party software, hence all the response.writes i have to do !

great thanks I am getting a similar problem now with Response.Write "<script>location.href = ctsURL("Summary.asp") & "&EnquiryID=" & Enquiry & "&target=Summary.asp?id2=" & request("id2")</script>" i put ""Summary.asp"" which seemed to sort that part but then i get invalid character for...

thank you everyone

still same error Microsoft VBScript compilation error '800a0409' Unterminated string constant /CCCu_PROCESSENQUIRY_AbanVehicles.ASP, line 724 Response.Write " <input type=""submit"" name=""SAVE"" onclick=""alert('<% =Enquiry ----------------------------^

thanks getting unterminated string constant error now Response.Write " <input type=submit name=SAVE onclick=""alert('<%=Enquiry%>')"" value=SAVE>

hello in my asp i have a variable called Enquiry, which holds a value. I'd like, on the onlick of the save button to return the Enquiry variable in an alert ? how can i ? thanks rob

example as is Surname, UPRN, CustomerID, datelastmodified Ainslie, 900012568, 2001567, 6/27/2006 2:51:27 PM Hughes, 900011774, 2001568, 6/27/2006 2:00:15 PM Roberts, 900001001, 2001500, 6/26/2006 1:00:00 PM Ainslie, 900012568, 2001567, 6/01/2006 06:00:00 AM so sorted by a.datelastmodified, b...

...ON a.CUSTOMERID = b.CUSTOMER WHERE ((a.SURNAME + ISNULL(b.UPRN, '')) IN (SELECT a.surname + isnull(b.uprn, '') FROM CUSTOMERS a, CUSTOMERADDRESS b WHERE a.customerid = b.customer GROUP BY a.surname, b.uprn HAVING COUNT(*) > 1)) ORDER BY a.datelastmodified, b.UPRN, LEFT(a.SURNAME, 24)...

I have a SQL statement (i have a report in visual studio that creates a dataset) and calls this sqlstmt1 SELECT WARD_NAME, COUNT(*) AS CustomerCount, WARD_ID FROM dbo.vwLPGWards GROUP BY WARD_NAME, WARD_ID ORDER BY COUNT(*), WARD_NAME, WARD_ID this is based on a view (shown below) but the...

i've set the command object as a recordset, which now works ok - is this the recommended method ? set objRS = buscmd.Execute response.write objRS("TheNewID")

thanks - this is now working ok one last thing how can i read the scope-identity value from my SP ? i need to use it to update another table something like this..... thanks SQLstmtTemp = "UPDATE tblID set " & _ "DetailsID = " & cmd.Parameters("@NewId") & " " & _ "WHERE UniqueID = '" &...

found the problem - it was the text columns - i needed to append the parameters and specify the text columns as adlongvarchar buscmd.Parameters.append buscmd.createparameter("@Cat_2", adlongvarchar, adParamInput, len(objRS8("MyID"))) buscmd.Parameters.Item("@Cat_2").AppendChunk objRS8("MyID")...

thanks I have tried that but no joy. what i've done now is create a temp table with 2 columns ID (identity, 1,1 ) as primary key also and another column temp12 as varchar(50) my sp is CREATE PROCEDURE [insert_temp12_1] ( @temp12_2 [varchar](50)) AS SET NOCOUNT ON INSERT INTO...