How to update INFORMIX BYTE type columns with ADO in ASP JavaScript?
A poster asked how to update and insert Informix BYTE columns using ADO from ASP. Leopold The Cat said to use parameters. Kim, Hyung Soo named ADO's GetChunk and AppendChunk. Noel Griffin detailed it: write to a temp file, open an empty recordset, AddNew, loop AppendChunk, then Update; plain INSERT statements only work with IDS/UD 9.1x. Reads use repeated GetChunk. No reply from the poster.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.