RSS
Recortes: 2
php
asp
recordset
bbdd
connection
MSSQLServer
ConnectionString = "DRIVER=SQL Server;SERVER=localhost;DATABASE=MasterDB;Address=127.0.0.1,1433;Trusted_Connection=Yes;" set conn = Server.CreateObject("adodb.connection") conn.open ct_ConnectionString conn.execute "INSERT ..." set rs = Server.CreateObject("adodb.recordset") rs.Open "SELECT ...", conn do until rs.eof rs.MoveNext: loop rs.Close set rs = Nothing conn.close set conn = Nothing
// Lee todos los "Perez" de la tabla usuarios $db = NewADOConnection('mysql'); $db->PConnect($dbhost, $dbuser, $dbpass, $dbdatabase); $result = $db->Execute("select nombre, apellidos from usuarios where apellido=?", array("Perez")); if ($result === false) die("falló"); while (!$result->EOF) { echo $result->fields['nombre'].' '.$result->fields['apellidos']; $result->MoveNext(); }