Results for "Author: hwa ying lee"
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool
1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool