Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sanctified
  • Content: Threads
  • Order by date
  1. sanctified

    Checking last 6 passwords

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

    Lock user account after 3 login attempts

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

    Check for at least one numeric char in string

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

    Datagrids' dataset using OO Model

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

    DatGrid record count

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

    Datagrid databound rows not showing

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

    ANSI-PADDING DTS job

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

    Compare two date fields in same table

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

    Passing file path/filename back to application

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

    Update record in same table

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

    opener issue

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

    SubQuery Returned more than 1 value error

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

    Holiday Dates

    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 + ' ' +...
  14. sanctified

    Insert File as hyperlink

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

    Report Viewer properties with .NET

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

Part and Inventory Search

Back
Top