1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
var adOpenStatic=3;
var adLockOptimistic=3;
var cnxstr = proxy.XmlDataSource().selectSingleNode("CONNECTSTRING").text;
var stream = Server.CreateObject("ADODB.stream");
var pathFile = "c:\\image.jpg";
stream.Open();
stream.Type = 1
stream.LoadFromFile(pathFile);
var conn = Server.CreateObject("ADODB.CONNECTION");
conn.Open(cnxstr);
var rs = Server.CreateObject("ADODB.RECORDSET");
conn.BeginTrans();
conn.Execute("INSERT INTO SMGSZCONFINFO (UIDSZCONFINFO, UIDNETWORKCONF, VALIDATIONDATE, PROFIL, CONFCOMMENT, CONFFILE ) VALUES ( ( SELECT CASE WHEN MAX(UIDSZCONFINFO)IS NULL THEN 1 ELSE MAX(UIDSZCONFINFO)+1 END FROM SMGSZCONFINFO ) , (SELECT UIDNETWORKCONF FROM SMGNETWORKCONF), '03/07/2008', 'TOTO', 'MON COMMENT', empty_blob())");
rs.Open ("SELECT CONFFILE FROM SMGSZCONFINFO WHERE UIDSZCONFINFO = ( SELECT MAX( UIDSZCONFINFO) FROM SMGSZCONFINFO )", conn, adOpenStatic, adLockOptimistic);
rs.Fields("CONFFILE").AppendChunk(stream.Read());
rs.Update();
rs.Close();
conn.CommitTrans(); |
Partager