kiad_198's Profile User Rating: -----

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
130 (0.06 per day)
Joined:
19-November 08
Profile Views:
5,712
Last Active:
User is offline Yesterday, 06:45 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0

Latest Visitors

Icon   kiad_198 has not set their status

Posts I've Made

  1. In Topic: Query won't insert data problem

    Posted 11 Dec 2014

    thanks for the reply,

    I figured it out, seems working now. I just remove this code:
     Dim Trans = con.BeginTransaction
      'and Trans to sql statement.
     Trans.Dispose()
    
    


    Here's the code:

    Dim con As New MySqlConnection("server=" & server & ";database=" & database & ";user id=" & username & ";password=" & userpass & ";port=3306")
    
    
                con.Open()
    
                IdDate = MD5("01-0056" & crdate)
    
                Dim Cmd = New MySqlCommand("INSERT INTO local_attendance.employee_time_log (employee_id, log_date, keylog) SELECT * FROM (SELECT '01-0056' as empid, '" & crdate & "' as curdate, '" & IdDate & "' as keylogid) as tmp WHERE NOT EXISTS (SELECT keylog,employee_id,log_date FROM local_attendance.employee_time_log WHERE keylog = keylogid AND employee_id = empid AND log_date = curdate) LIMIT 1", con)
    
                Cmd.ExecuteNonQuery()
                Cmd.Dispose()
    
                con.Close()
    
    
    


    Thanks,

    kiad
  2. In Topic: Unable to Cast object of type 'TimeSpan'

    Posted 8 Jun 2014

    Thanks for the reply guys..
    Its working now...




    kiad
  3. In Topic: Concatenation problem

    Posted 28 Apr 2014

    yes,

    error: Run-time error '3021' Either BOF or EOF is True, or the current record has beed deleted.
    Request operation requires a current record.

    Point to a = Empty
  4. In Topic: Concatenation problem

    Posted 28 Apr 2014

    sorry for not discuss my problem more.

    I have a comboBox with the fullname(firstname & lastname) value and I want to search using the data in my comboBox into my database. However, I don't have fullname datafield instead firstname and lastname datafield.
    Now, my problem is how can search that?

    I'm using MySQL database. I just trying to CONCAT it but not working.




    Thanks,
    kiad
  5. In Topic: Subscript out of range

    Posted 22 Apr 2014

    Thank you for the reply, very much appreciated.

    Here's the value.
    Posted Image


    Here's the new value:
    Posted Image

    I haven't dimensioned RegTemplate.
    what should I do?
    can you give an idea how please?


    thanks
    kiad

My Information

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

Contact Information

E-mail:
Private

Friends

kiad_198 hasn't added any friends yet.

Comments

kiad_198 has no profile comments yet. Why not say hello?