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

hi i have a table on server a, which holds customer details. each customer gets a unique number (numeric field) and a datetime field (sdate) when the customer was created. there is also a datetime field called edate, which if the customer moves, stamps a date and time in the edate field, and...

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

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

Hi I've used a form wherby the user gets a long list of records, they can select any one to be true - click approve and it runs a sql update to update those records where true was chosen - this works ok Dim iCount iCount = request("Count") Dim strDisplay, strID Dim strSQL Dim iLoop For...

Hi i've rewritten someones ASP page into a new Application - problem is the page displays absolutely nothing, blank here is the code thanks gareth <% ID = Request.QueryString("ID") Function PressEditDisplay(Params, DBConn, PageID, ParentID, TopID) Dim b, h if Request.Form("cmdaction") = ""...

Hi I've got my RegExp set up as below - Password and email seem ok but Postcode doesn't seem to work it will allow CH1 2HSSSSSSSSSSSSSSSSSSSS won't allow CH1 2HS (which is valid) any ideas ? thanks kim Dim valid_str Dim oRegExp Set oRegExp = New RegExp oRegExp.IgnoreCase = False...

Hi I have a form based on a table Membership There are 2 fields in the table bitApproved and bitDeclined. I want 2 radio buttons, Approve and Reject, the user being able to choose one or the other for each record displayed. The user can then run an update button, which looks for any values of 1...

Hi I'm writing some basic server-side validation - must be vbscript I'd like to incorporate within the code below a password checker for fields Pass1 and Pass2 i.e. they must be at least 6 characters, no spaces, at least one number and of course must match + anything else I've forgot ! I also...

Hi I want to set-up a page which if the user logs in successfully wil redirect them to another page or send them to a noaccess.asp page Using our CMS system there are already two files logon.asp and noaccess.asp as shown below I want to create my own page say LegLogin.asp and use/call logon.asp...

Hi I've used the code below to naviagte through a Database using previous and next buttons. works fine except only one record per page is displayed. I'd like it to show the number I set in the interval per page i.e. 10 in this example any help much appreciated Ian Set objCon =...

Hi I've a form with an option group. I'm using VBscript to write server-side validation - has to be like this When I submit the form it retains any text values but I can't get it to retain the option group value - I am plugging this code into an off the shelf package so i can't use method such...

Hi I'm opening a main form and a pop-up form at the same time (which is just a read-only) form from the main form i can click next and open another form and so on - each time the pop-up form then is hidden behind main form - I'd like it to stay always as the top form - any ideas ? I don't want...

Hi I have a generic Public Function called Validator as below. It doesn't like the Forms!Screen.ActiveForm.Name!Frame1001 - how can I get round this please ? also can you call other functions from within a function as I've tried below ? regards gareth Public Function PAIS_Page1() As Boolean...

I have a form with unbound fields. When the users commits the record to live they can edit the record at any time which sets teh control source in code so the fields are populated. works fine except for option groups. for example in the table fieldname TrainType may have a value of 2. When the...

Hi I have a form where several fields are mandatory (this also includes recordset checks for subforms to check at least one record in subform is completed)- when the user clicks commit to Database - if any of the checks aren't met it runs a CheckFields Function which returns false and tells the...

Hi I have a form with unbound fields which, assuming validation is met, are inserted into the live table. my first problem was one of the fields, saref, is a concatenation of the directorate field and the autonumber field. I got round this by using a GetUserLogon script, which captures the...