Thinus du Pisanie's Profile User Rating: -----

Reputation: 2 Apprentice
Group:
Active Members
Active Posts:
101 (0.1 per day)
Joined:
07-October 11
Profile Views:
2,982
Last Active:
User is offline Yesterday, 11:14 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   Thinus du Pisanie has not set their status

Posts I've Made

  1. In Topic: Automatic birthday email send out of MS SQL

    Posted 9 Jul 2014

    Good day

    I am using Microsoft SQL Server Management studio I think I stated that wrong.

    This is what I am using with my asp.net application. So the application will not be opened everyday.

    So I have no idea how to approach this.

    Even if the application is not used everyday the employee still have to get an email saying happy b-day.
  2. In Topic: Error Message on invalid characters

    Posted 9 Jun 2014

    Good day

    Ok I figured it out you where right about escaping it.

    It was just a matter of where.

       If txtTrack.Text.Contains("'") Then
                Field_Err_Track = True
                strErr = strErr & " Check for invalid characters like (\')"
            End If
    


    The escape must be here

    strErr = strErr & " Check for invalid characters like (\')"
    


    And not in the

    If txtTrack.Text.Contains("'")
    


    But thanks very much appreciate.
  3. In Topic: Error Message on invalid characters

    Posted 3 Jun 2014

    No the function pops my error message and kicks me out of the if statement if there is a . present but if I run the same function altering the values to pop the error message using a ' the function runs but for some reason does not pick up that there is a ' in the textbox.

    I just want a way any way to ensure if there is a ' in the textbox that a error message will pop and say invalid character '.
  4. In Topic: Error Message on invalid characters

    Posted 3 Jun 2014

    Ok if I do this

     If txtWeight.Text.Contains(".") Then
                Field_Err = True
                strErr = strErr & " Check for invalit characters like (.)"
            End If
    


    Here is my button click event again.

     Protected Sub cmdUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles cmdUpdate.Click
    
            If Field_Err() Then
                Set_Alert(strErr)
            Else
                Update_KPA()
                lblPerf_KPA_ID.Text = "0"
                Set_KPA()
                Check_KPA_Weight()
            End If
    
        End Sub
    


    So if there is a . present in the textbox in any sentence I get a popup error stating Check for invalit characters like (.)

    But if I use this

       If txtWeight.Text.Contains("'") Then
                Field_Err = True
                strErr = strErr & " Check for invalit characters like (')"
            End If
    


    For some reason if there is a ' present in the textbox the error does not pop and I don't know why. What I want to know is why does the error not pop reading that there is a ' present in the textbox
  5. In Topic: Error Message on invalid characters

    Posted 3 Jun 2014

    No here is the function

    Private Function Field_Err_Track() As Boolean
    
    If txtTrack.Text.Contains("'") Then
    	          Field_Err_Track = True
    	          strErr = strErr & " Check for invalit characters like (')"
    	      End If
    	 
    	  End Function
    


    Here is the button click event

      Protected Sub cmdUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles cmdUpdate.Click
    
            If Field_Err() Then
                Set_Alert(strErr)
            Else
                Update_KPA()
                lblPerf_KPA_ID.Text = "0"
                Set_KPA()
                Check_KPA_Weight()
            End If
    
        End Sub
    


    So basically if the button is clicked and the text box = a character like ' then the message box with the error message (Check for invalid characters like (')) must pop and the rest of the statement must be terminated

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Click here to e-mail me

Friends

Thinus du Pisanie hasn't added any friends yet.

Comments

Thinus du Pisanie has no profile comments yet. Why not say hello?