Search results for query: *

I've set up a batch job to run the iisreset.exe using C:\WINDOWS\system32\iisreset.exe in the run field of the task job. ad-hoc i usually run iisreset /restart can i do that using the sceduled task direct or do i need to put it in an actual .bat file created within C:\WINDOWS\system32\ and...

Hi we have a new asp application, which I'm about to set up within IIS 6.0. Now live should be ok because its on a different server completely to test and train so I just create one website and I'm away. on the server holding dev, test and train ! I could do with some advice on how to set it...

Hi i installed this edition fine on our istanbul server, used an account account2 - worked fine ! tried it on another server - doesn't work the only difference i can see is through IIS - there are 2 websites, the default website and another one which hosts another application. the sql...

thanks will try that.....

...time in the edate field, and creates a new record for that customer (keeping their same unique number) so the customers current details are select * from servera.tblCustomer where edate is null. server b also has a table called tblCustomer which just holds one row for each customer (their...

yeah I've been checking for typo's for half an hour........and just found it sorry ! i thought there was a little on javascript if statements or something ! keith

sorry i forgot to mention that if i add the other 2 checkboxes in it fails completely !

Hi i've got this code which works ! but its only validating 7 out of the 9 checkbox fields i have. Is there a limit on the length ? the missing 2 fields are chkFailurePink and chkCalendar thanks keith Response.Write "if (document.frmEnquiry.chkBNE.checked == false &&...

Hi I've inherited some code which does this i.e. returns a URL, if found in the lookup table. if Request ("selSimple1") <> "" then strSQL = "SELECT URL, URL_NAME FROM CTS_SIMPLE_SERVICES WHERE SERVICEID = " & Request ("selSimple1") set oRSURL = ExecQueryRS(strSQL,null) if not oRSURL.EOF and...

oh ok...........two for the price of one ! one quick question re. george's function i call it like such in my asp (works great) strTempID = "Select BusinessDir.dbo.ConcatDesc1(ID) as MyID from tblTempID" set objRS8 = objCon.execute(strTempID) my table tblTempID has lots of records, I'd...

will do...........thanks again

brilliant ! thank you

sorry george, bit of a novice at this...... it is saying UDF must include name and text

hi i do want to use them in a recordset within my asp. i've tried implementing george's code but get an error ?

oh ok is there some way i could do what i want to do ? thanks

I've got a SQL table with column ID of type int. it will have anything from 1 - 10 rows with values such as ID -- 10 12 20 I'd like to return the values as a comma delimited string i.e. 10, 12, 20 I've created the UDF below CREATE Function dbo.ConcatDesc (@ID int) returns varchar(1000)...

so my output at the moment is (if they select 3 records for example) 46 50 60 I suppose I could insert these ID values into a temporary table ? then on the next form select from the temporary table and hey presto ! but could there be a conflict if 2 users are adding at the same time ? thanks

thanks DNG I only need those values that are passed as 1 though, hence the bit of code below. strDisplay passes through the values of 1 or 0 and strID passes through the ID numbers if arDisplay(i) = 1 then b = b & "<input type=""text"" name=""myArray"" value= """ & arID(i) & """>" else end if

I have now got the values where the user selects 1 in a text box as below...............so if the user selects 2 items 2 text boxes appear with the correct ID values. I now need to pass these values to the next page in an array ? how can i go about doing that ? thanks Dim iCount iCount =...

I've managed to get my values in a array now. problem is all the values are been brought across, not just the ones where the user has set select to value 1 this is my latest code Dim iCount iCount = request("Count") Dim strDisplay, strID Dim strSQL Dim iLoop For iLoop = 0 to iCount...