
08/03/2005, 16:20
|
| | Fecha de Ingreso: octubre-2004
Mensajes: 104
Antigüedad: 20 años, 8 meses Puntos: 0 | |
Código:
sSQL = "INSERT INTO News_usr (usr_codi, usr_nemp, usr_email, "_
& "usr_cont, usr_email1, usr_cont2, usr_email2) "_
& "SELECT usr_codi, usr_nemp, usr_email, usr_cont, "_
& "usr_email1, usr_cont2, usr_email2 "_
& "FROM Sisc_clp2 "_
& "WHERE (usr_email1 <> 'PENDIENTE' "_
& "AND usr_email2 <> 'PENDIENTE') "_
& "OR (usr_email1 <> '' and usr_email2 <> '')"
Set RS = Conn.Execute(sSQL)
|