Search results for query: *

Hi Group, I'm using the built-in sp_password SP and was wondering if I could get at the last 6 passwords the user has used and prevent them from using them again. I'm using ASP.NET as my front-end. Here is a snippet of code: Private Sub btnSaveChanges_Click(ByVal sender As System.Object, ByVal...

Hi Group, The following code was written by someone else and I would like to amend so that the users account is locked after 3 unsuccessful attempts to log in. How can I amend this code? I have created a field called locked on the users table and will set it to 1 to lock the account out. I'm...

Hi Group, I have a text box on my login page. As part of the validation, I want to ensure that at least ONE character of the password is numeric. I've had a look at the IsNumeric and Instr Function but can't seem to get the syntax right to check that for AT LEAST ONE character being numeric...

Hi Group, An existing application exists which has been developed around the OO model. Lots of classes with standard routines etc. I need to add an extra page which gets its data from the database and places this in a datagrid. I've created an aspx page which holds the datagrid. My code is...

Hi Group, How can I detect whether a datgrid control has any records? I need to check for no records being present. TIA

Hi Group, I've created a datagrid and I'm able to edit, update and cancel changes. Data is being posted back to the database correctly. However, when I clicking edit, the record is displayed for me to edit. Clikcing update, it updates but the record is NOT displayed on the screen. It is only...

I've created a DTS job which will export data from a table into a text file using the delimited format. The field is a char datatype of size 10 chars. I need to be able to strip trailing spaces from a field how can I achieve this? I've tried using SET ANSI_PADDING ON/OFF within the script but...

Hi Group, I will have 2 sets of 'matched' records in a table with a start date field of type datetime. I want to update a field called flag in the table with 1 for the earlier date and 2 for the later date. example Start Date Flag 12/07/2006 1 17/07/2006 2 regards

I'm having problems with trying to achieve the following: I want the user to be able to navigate to a directory to select a file. The path of the file selected should then be passed back into a field so that I can save this in the database. Questions: Is there a control I can use for this...

I have a table which self-joins to itself by the following fields: SiteID and MergeID So I will have: SiteID MergeID StartDate Notice MergeStatus 127 128 01/12/2006 7 128 127 02/12/2006 7 My asp application will pass in the siteid for...

What does this mean? opener.SiteMaintenance.txtmergeConsentno is null or not an object I'm using it in my .net page. It used to work until I changed the dataAdapter. I think the dataAdapter might have added some extra bits of code...!!! regards

Hi Group, I'm getting the following error in my SP when the tblHolidayDates has more than one record. Here is my SP: begin if datediff(day,getdate()-10 ,(Select HolidayDate from tblHolidayDates))= 3 AND DATEPART(dw,(select holidaydate from tblHolidayDates)) = 1 -- Monday Date SELECT...

Hi Group, Currently, I have a Stored Procedure which is called from my ASP Page. It takes into account Fridays and weekends passing the value in as a parameter: snippet.... if @pListType = 'F' -- being a Friday begin SELECT su.SuspensionID, su.ConsentNo, si.SiteID, si.NameNo + ' ' +...

Hello, Does anyone know how I can implement the feature of including a file as an hyperlink into a textbox control. I've played around with the htmlfileinput control but cannot get it to include the file as an hyperlink. This feature is available in Outlook - when you click on the insert...

Hi Group, My 1st posting to Tek-Tips... I'm new to reporting services and have managed to create and view reports using the ReportViewer Control. However one of my report uses an expression in its label to navigate to another sub-report. (Passes in a field value and a parameter). How can I...