Search results for query: *

Thanks adamroof worked like a charm!!

Hi IT4EVR I cut and pasted your code but had a space before the start of the string so this was throwing out the validation. It works a charm now. Thanks a lot!!

Hi IT4EVR, I've tried using what you've suggested however even when I put in a password with a digit the error message for the validator appears. The validation should pass. I've placed the validator against the 1st password text box. This is where the user enter their new password. The 2nd...

Hi Denny, Yes I thought this was the case. Just wanted to be certain. Thanks!!

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 Jim, Thanks for this. Yes I started to get myself in a muddle as the password could be any length and I was going to test for each character, became a bit lengthy and messy. I'll take a look at the Regular Expression. Regards

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 Jim, I'll give that a go. I'll let you know the outcome. Thanks

Hi Jim, It's declared at page level as a dataset. The dropdown lists uses a sub and it returns an array;declared as an array at page level too. That worked, why not a dataset? Do I need to loop through it in my class?

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

Thanks Guys, I'm not sure where what you've both suggested will fit into my current syntax. The datagrid is bound on the onload event of my form using a datatable. Currently my code where I pass the datarow of the datatable is this on the btn_submit click event: Dim objdt As New...

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

Hi ca8msm, Thanks for your response. I found out what it was, I hadn't set the itemTemplates' text property i.e. the container datatitem!! regards

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

Thanks mutley1. Works great!! cheers!!

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

OK Will give it a go soon.

Not at all. I don't look at it as you wasting my time. Your help was much appreciated. cheers mate!!

Just to recap, Compare the two dates If date1 < date2 update mergestatus to 1 for date1 record Update mergestatus to 2 for date2 record otherwise do the opposite.