How to update INFORMIX BYTE type columns with ADO in ASP JavaScript?
INFORMIX has BYTE type, how can I update ,insert,etc the BYTE type columns with ADO in ASP VBScript or JavaScript? Thanks. Sent via Deja.com http://www.deja.com/ Before you buy.
Use parameters. Leopold <robertwane@hotmail.com> wrote in message news:84p3ag$d7t$1@nnrp1.deja.com... >
ADO's GetChunk, AppendChunk method -- ---------------------------------------- Kim, Hyung Soo eIST Co. Senior Developer & DBA Tel : 6283-2108 Mailto:dankoon@ist.co.kr Mailto:dankoon@chollian.net ---------------------------------------- <robertwane@hotmail.com>''('') 'Ʒ' ''''''' news:84p3ag$d7t$1@nnrp1.deja.com'' 'Խ'''''''''. > INFORMIX has BYTE type, how can I update ,insert,etc the BYTE type > columns > with ADO in ASP VBScript or JavaScript? > Thanks. > > > Sent via Deja.com http://www.deja.com/ > Before you buy.
Hi You need to the use the following methods of an ADO Field object in VB: GetChunk() AppendChunk() INSERTS: You basically store the contents in a local temp file (e.g. C:\\blobtemp\\blob000.000). Then create an ADO Recordset with no rows (i.e. WHERE 1=2). Use AddNew to create a new row, assign field values to all the non blob fields (i.e. Rs!Surname="Smith"), then read from the temp disk file in a loop say reading 5k at a time into a string, then call Rs!Photo.AppendChuck $string_var until you have read the whole file. Then call the Rs.Update method to cause a suitable SQL-Insert statement to be executed. You must use a recordset, executing INSERT SQL statements will not work unless you are using IDS/UD 9.1x (i.e. FileToBlob, FileToClob methods). SELECTS: Read a row from a Recordset in the normal fashion. Then recursively call Rs!Photo.GetChunk to read say 5k at a time into a string which you will write to a temp local file. I can email you two useful functions with Automate this is you want? Regards Noel Griffin Ireland <robertwane@hotmail.com> wrote in message news:84p3ag$d7t$1@nnrp1.deja.com... > INFORMIX has BYTE type, how can I update ,insert,etc the BYTE type > columns > with ADO in ASP VBScript or JavaScript? > Thanks. > > > Sent via Deja.com http://www.deja.com/ > Before you buy.