Hello everyone.
I need your help for create trigger insert.
Now I use this code ASP for insert new record in the table.
This operation it’s possible with trigger in the Mysql 5.0.45 version?
//QUERY TABLE _TEMP
SQL = " SELECT * FROM "
SQL = SQL & " _temp "
Set Rs = CreateObject("ADODB.Recordset")
Rs.Open SQL, cn
if not Rs.eof then
Rs.MoveFirst()
Do While Not Rs.EOF
//QUERY FOR _TBL
qs = "SELECT * FROM "
qs = qs & " _tbl "
qs = qs & " WHERE 1 "
qs = qs & " AND DATES = '" & formatGMTDate(RS("DATES"),0,"yyyy-mm-dd") & "' "
set RSqs = CreateObject("ADODB.Recordset")
RSqs.Open qs, cn
if not RSqs.eof And not RSqs.bof then
response.write "Nothing"
else
SQL = "INSERT INTO "
SQL = SQL & " _tbl "
SQL = SQL & "( "
SQL = SQL & " DATES "
SQL = SQL & " ) "
SQL = SQL & " VALUES "
SQL = SQL & " ( "
SQL = SQL & " '" & formatGMTDate(Rs("DATES"),0,"yyyy-mm-dd") & "' "
SQL = SQL & " ) "
cn.execute(sql)
end if
RSqs.Close()
set RSqs = Nothing
Rs.MoveNext()
Loop
Rs.Close()
Set Rs = Nothing
cn.Close()
Set cn = Nothing