home *** CD-ROM | disk | FTP | other *** search
Unknown | 1998-10-05 | 2.0 KB |
open in:
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence | Program | Detection | Match Type | Support
|
---|
100%
| file
| Excel 2 BIFF 2
| default (weak)
| |
99%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 09 00 00 00 41 72 72 61 | 79 54 6f 44 62 09 00 00 |....Arra|yToDb...|
|00000010| 00 41 72 72 61 79 54 6f | 44 62 08 00 00 00 4c 69 |.ArrayTo|Db....Li|
|00000020| 76 65 57 69 72 65 4e 00 | 00 00 49 6e 73 65 72 74 |veWireN.|..Insert|
|00000030| 73 20 74 68 65 20 65 6c | 65 6d 65 6e 74 73 20 6f |s the el|ements o|
|00000040| 66 20 74 68 65 20 67 69 | 76 65 6e 20 61 72 72 61 |f the gi|ven arra|
|00000050| 79 2c 20 69 6e 74 6f 20 | 61 20 73 70 65 63 69 66 |y, into |a specif|
|00000060| 69 65 64 20 74 61 62 6c | 65 20 6f 66 20 61 20 64 |ied tabl|e of a d|
|00000070| 61 74 61 62 61 73 65 2e | 6c 07 00 00 2f 2a 20 3d |atabase.|l.../* =|
|00000080| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000090| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000000a0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000000b0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000000c0| 3d 3d 3d 3d 3d 0d 0a 46 | 55 4e 43 54 49 4f 4e 3a |=====..F|UNCTION:|
|000000d0| 20 41 72 72 61 79 54 6f | 44 42 0d 0a 20 0d 0a 49 | ArrayTo|DB.. ..I|
|000000e0| 4e 50 55 54 3a 20 09 64 | 62 20 2d 20 61 6e 20 6f |NPUT: .d|b - an o|
|000000f0| 70 65 6e 20 64 61 74 61 | 62 61 73 65 20 63 6f 6e |pen data|base con|
|00000100| 6e 65 63 74 69 6f 6e 20 | 6f 62 6a 65 63 74 0d 0a |nection |object..|
|00000110| 09 09 09 74 61 62 6c 65 | 6e 61 6d 65 20 2d 20 74 |...table|name - t|
|00000120| 68 65 20 6e 61 6d 65 20 | 6f 66 20 74 68 65 20 74 |he name |of the t|
|00000130| 61 62 6c 65 20 77 68 65 | 72 65 20 74 68 65 20 61 |able whe|re the a|
|00000140| 72 72 61 79 20 76 61 6c | 75 65 73 20 61 72 65 20 |rray val|ues are |
|00000150| 74 6f 20 62 65 20 69 6e | 73 65 72 74 65 64 2e 0d |to be in|serted..|
|00000160| 0a 09 09 09 41 72 72 20 | 2d 20 61 6e 20 61 72 72 |....Arr |- an arr|
|00000170| 61 79 20 28 73 69 6e 63 | 65 20 4a 61 76 61 53 63 |ay (sinc|e JavaSc|
|00000180| 72 69 70 74 20 63 61 6e | 6e 6f 74 20 73 75 70 70 |ript can|not supp|
|00000190| 6f 72 74 20 6d 75 6c 74 | 69 2d 64 69 6d 65 6e 73 |ort mult|i-dimens|
|000001a0| 69 6f 6e 61 6c 20 61 72 | 72 61 79 73 2c 20 74 6f |ional ar|rays, to|
|000001b0| 20 0d 0a 09 09 09 09 09 | 69 6e 73 65 72 74 20 6d | .......|insert m|
|000001c0| 75 6c 74 69 70 6c 65 20 | 72 65 63 6f 72 64 73 20 |ultiple |records |
|000001d0| 73 69 6d 70 6c 79 20 69 | 6e 63 72 65 61 73 65 20 |simply i|ncrease |
|000001e0| 74 68 65 20 6c 65 6e 67 | 74 68 20 6f 66 20 74 68 |the leng|th of th|
|000001f0| 65 20 6f 6e 65 20 64 69 | 6d 65 6e 73 69 6f 6e 61 |e one di|mensiona|
|00000200| 6c 20 61 72 72 61 79 2e | 29 0d 0a 0d 0a 52 45 54 |l array.|)....RET|
|00000210| 55 52 4e 3a 09 4e 6f 74 | 68 69 6e 67 0d 0a 0d 0a |URN:.Not|hing....|
|00000220| 44 45 53 43 3a 20 09 49 | 6e 73 65 72 74 73 20 74 |DESC: .I|nserts t|
|00000230| 68 65 20 65 6c 65 6d 65 | 6e 74 73 20 6f 66 20 74 |he eleme|nts of t|
|00000240| 68 65 20 67 69 76 65 6e | 20 69 6e 20 61 72 72 61 |he given| in arra|
|00000250| 79 2c 20 69 6e 74 6f 20 | 61 20 73 70 65 63 69 66 |y, into |a specif|
|00000260| 69 65 64 20 74 61 62 6c | 65 20 6f 66 20 61 20 0d |ied tabl|e of a .|
|00000270| 0a 09 09 09 64 61 74 61 | 62 61 73 65 2e 20 20 44 |....data|base. D|
|00000280| 41 54 41 20 46 4f 52 20 | 41 4c 4c 20 46 49 45 4c |ATA FOR |ALL FIEL|
|00000290| 44 53 20 4d 55 53 54 20 | 42 45 20 50 52 4f 56 49 |DS MUST |BE PROVI|
|000002a0| 44 45 44 2e 20 20 0d 0a | 0d 0a 50 4c 41 54 46 4f |DED. ..|..PLATFO|
|000002b0| 52 4d 53 3a 09 4e 65 74 | 73 63 61 70 65 20 4e 61 |RMS:.Net|scape Na|
|000002c0| 76 69 67 61 74 6f 72 20 | 33 2e 30 31 20 61 6e 64 |vigator |3.01 and|
|000002d0| 20 68 69 67 68 65 72 2c | 0d 0a 09 09 09 20 20 09 | higher,|..... .|
|000002e0| 4d 69 63 72 6f 73 6f 66 | 74 20 49 6e 74 65 72 6e |Microsof|t Intern|
|000002f0| 65 74 20 45 78 70 6c 6f | 72 65 72 20 33 2e 30 32 |et Explo|rer 3.02|
|00000300| 20 61 6e 64 20 68 69 67 | 68 65 72 2c 0d 0a 09 09 | and hig|her,....|
|00000310| 09 20 20 09 4e 65 74 73 | 63 61 70 65 20 45 6e 74 |. .Nets|cape Ent|
|00000320| 65 72 70 72 69 73 65 20 | 53 65 72 76 65 72 20 33 |erprise |Server 3|
|00000330| 2e 30 2c 0d 0a 09 09 09 | 20 20 09 4d 69 63 72 6f |.0,.....| .Micro|
|00000340| 73 6f 66 74 20 49 49 53 | 2f 41 53 50 20 33 2e 30 |soft IIS|/ASP 3.0|
|00000350| 2e 0d 0a 09 09 09 20 20 | 09 0d 0a 53 41 4d 50 4c |...... |...SAMPL|
|00000360| 45 3a 0d 0a 0d 0a 09 76 | 61 72 20 70 6f 6f 6c 20 |E:.....v|ar pool |
|00000370| 3d 20 6e 65 77 20 44 62 | 50 6f 6f 6c 20 28 22 4f |= new Db|Pool ("O|
|00000380| 44 42 43 22 2c 22 55 53 | 45 52 53 22 2c 22 22 2c |DBC","US|ERS","",|
|00000390| 22 22 2c 22 22 2c 22 22 | 2c 31 29 0d 0a 09 76 61 |"","",""|,1)...va|
|000003a0| 72 20 64 62 20 3d 20 70 | 6f 6f 6c 2e 63 6f 6e 6e |r db = p|ool.conn|
|000003b0| 65 63 74 69 6f 6e 28 29 | 3b 0d 0a 09 76 61 72 20 |ection()|;...var |
|000003c0| 74 61 62 6c 65 6e 61 6d | 65 20 3d 20 22 66 6c 61 |tablenam|e = "fla|
|000003d0| 74 66 69 6c 65 22 3b 0d | 0a 0d 0a 09 2f 2f 53 55 |tfile";.|....//SU|
|000003e0| 50 50 4f 53 45 20 57 45 | 20 41 52 45 20 32 20 52 |PPOSE WE| ARE 2 R|
|000003f0| 45 43 4f 52 44 53 20 54 | 4f 20 41 20 44 41 54 41 |ECORDS T|O A DATA|
|00000400| 42 41 53 45 20 57 49 54 | 48 20 32 20 46 49 45 4c |BASE WIT|H 2 FIEL|
|00000410| 44 53 3a 20 4e 41 4d 45 | 20 41 4e 44 20 41 47 45 |DS: NAME| AND AGE|
|00000420| 0d 0a 09 2f 2f 0d 0a 09 | 76 61 72 20 41 72 72 20 |...//...|var Arr |
|00000430| 3d 20 6e 65 77 20 41 72 | 72 61 79 28 29 3b 0d 0a |= new Ar|ray();..|
|00000440| 09 41 72 72 5b 30 5d 20 | 3d 20 22 53 48 41 4e 4e |.Arr[0] |= "SHANN|
|00000450| 4f 4e 22 0d 0a 09 41 72 | 72 5b 31 5d 20 3d 20 31 |ON"...Ar|r[1] = 1|
|00000460| 33 0d 0a 09 41 72 72 5b | 32 5d 20 3d 20 22 53 48 |3...Arr[|2] = "SH|
|00000470| 41 4e 45 22 0d 0a 09 41 | 72 72 5b 33 5d 20 3d 20 |ANE"...A|rr[3] = |
|00000480| 31 38 0d 0a 0d 0a 09 2f | 2f 41 64 64 20 41 72 72 |18...../|/Add Arr|
|00000490| 61 79 20 74 6f 20 44 42 | 3a 0d 0a 09 41 72 72 61 |ay to DB|:...Arra|
|000004a0| 79 54 6f 44 42 28 64 62 | 2c 74 61 62 6c 65 6e 61 |yToDB(db|,tablena|
|000004b0| 6d 65 2c 41 72 72 29 0d | 0a 0d 0a 3d 3d 3d 3d 3d |me,Arr).|...=====|
|000004c0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000004d0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000004e0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000004f0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000500| 3d 20 2a 2f 0d 0a 0d 0a | 66 75 6e 63 74 69 6f 6e |= */....|function|
|00000510| 20 41 72 72 61 79 54 6f | 44 42 20 28 64 62 2c 20 | ArrayTo|DB (db, |
|00000520| 74 61 62 6c 65 6e 61 6d | 65 2c 20 41 72 72 29 20 |tablenam|e, Arr) |
|00000530| 7b 0d 0a 09 0d 0a 09 09 | 76 61 72 20 72 73 20 3d |{.......|var rs =|
|00000540| 20 64 62 2e 63 75 72 73 | 6f 72 28 22 53 45 4c 45 | db.curs|or("SELE|
|00000550| 43 54 20 2a 20 46 52 4f | 4d 20 22 2b 74 61 62 6c |CT * FRO|M "+tabl|
|00000560| 65 6e 61 6d 65 29 0d 0a | 09 09 76 61 72 20 63 6f |ename)..|..var co|
|00000570| 6c 20 3d 20 72 73 2e 63 | 6f 6c 75 6d 6e 73 28 29 |l = rs.c|olumns()|
|00000580| 0d 0a 09 09 76 61 72 20 | 73 71 6c 0d 0a 09 0d 0a |....var |sql.....|
|00000590| 09 09 76 61 72 20 41 72 | 72 61 79 5f 4c 65 6e 67 |..var Ar|ray_Leng|
|000005a0| 74 68 20 3d 20 41 72 72 | 2e 6c 65 6e 67 74 68 2d |th = Arr|.length-|
|000005b0| 31 0d 0a 09 09 76 61 72 | 20 6a 3d 30 0d 0a 09 09 |1....var| j=0....|
|000005c0| 72 73 2e 63 6c 6f 73 65 | 28 29 0d 0a 0d 0a 09 0d |rs.close|()......|
|000005d0| 0a 09 09 2f 2f 41 72 72 | 61 79 20 4c 65 6e 67 74 |...//Arr|ay Lengt|
|000005e0| 68 20 6d 75 73 74 20 62 | 65 20 61 20 6d 75 6c 74 |h must b|e a mult|
|000005f0| 69 70 6c 65 20 6f 66 20 | 74 68 65 20 6e 75 6d 62 |iple of |the numb|
|00000600| 65 72 20 6f 66 20 63 6f | 6c 75 6d 6e 73 2c 20 0d |er of co|lumns, .|
|00000610| 0a 09 09 2f 2f 73 6f 20 | 61 62 6f 72 74 20 69 66 |...//so |abort if|
|00000620| 20 69 74 20 69 73 20 6e | 6f 74 3a 09 0d 0a 20 0d | it is n|ot:... .|
|00000630| 0a 09 09 69 66 20 28 41 | 72 72 2e 6c 65 6e 67 74 |...if (A|rr.lengt|
|00000640| 68 25 63 6f 6c 29 0d 0a | 09 09 09 72 65 74 75 72 |h%col)..|...retur|
|00000650| 6e 20 31 3b 0d 0a 0d 0a | 09 09 2f 2f 45 61 63 68 |n 1;....|..//Each|
|00000660| 20 72 65 63 6f 72 64 20 | 6d 75 73 74 20 62 65 20 | record |must be |
|00000670| 69 6e 73 65 72 74 65 64 | 20 62 79 20 61 20 64 79 |inserted| by a dy|
|00000680| 6e 61 6d 69 63 61 6c 6c | 79 20 62 75 69 6c 74 0d |namicall|y built.|
|00000690| 0a 09 09 2f 2f 53 51 4c | 20 49 4e 53 45 52 54 20 |...//SQL| INSERT |
|000006a0| 73 74 61 74 65 6d 65 6e | 74 3a 0d 0a 09 0d 0a 09 |statemen|t:......|
|000006b0| 09 77 68 69 6c 65 20 28 | 6a 3c 3d 41 72 72 61 79 |.while (|j<=Array|
|000006c0| 5f 4c 65 6e 67 74 68 29 | 0d 0a 09 09 7b 0d 0a 09 |_Length)|....{...|
|000006d0| 09 09 73 71 6c 20 3d 20 | 22 49 4e 53 45 52 54 20 |..sql = |"INSERT |
|000006e0| 49 4e 54 4f 20 22 2b 74 | 61 62 6c 65 6e 61 6d 65 |INTO "+t|ablename|
|000006f0| 2b 22 20 56 41 4c 55 45 | 53 20 28 22 0d 0a 09 09 |+" VALUE|S ("....|
|00000700| 09 66 6f 72 20 28 76 61 | 72 20 69 3d 30 3b 20 69 |.for (va|r i=0; i|
|00000710| 3c 3d 63 6f 6c 2d 31 3b | 20 69 2b 2b 29 20 7b 0d |<=col-1;| i++) {.|
|00000720| 0a 09 09 09 09 73 71 6c | 20 3d 20 73 71 6c 20 2b |.....sql| = sql +|
|00000730| 22 27 22 2b 20 41 72 72 | 5b 6a 2b 2b 5d 2b 22 27 |"'"+ Arr|[j++]+"'|
|00000740| 22 0d 0a 09 09 09 09 69 | 66 20 28 21 28 69 3d 3d |"......i|f (!(i==|
|00000750| 63 6f 6c 2d 31 29 29 0d | 0a 09 09 09 09 09 73 71 |col-1)).|......sq|
|00000760| 6c 20 3d 20 73 71 6c 20 | 2b 20 22 2c 20 22 3b 20 |l = sql |+ ", "; |
|00000770| 0d 0a 09 09 09 7d 0d 0a | 09 09 09 73 71 6c 20 3d |.....}..|...sql =|
|00000780| 20 73 71 6c 20 2b 20 22 | 29 22 0d 0a 09 09 09 64 | sql + "|)".....d|
|00000790| 62 2e 65 78 65 63 75 74 | 65 28 73 71 6c 29 0d 0a |b.execut|e(sql)..|
|000007a0| 09 09 09 69 66 20 28 64 | 62 2e 6d 61 6a 6f 72 45 |...if (d|b.majorE|
|000007b0| 72 72 6f 72 4d 65 73 73 | 61 67 65 28 29 29 20 0d |rrorMess|age()) .|
|000007c0| 0a 09 09 09 09 72 65 74 | 75 72 6e 20 31 3b 20 09 |.....ret|urn 1; .|
|000007d0| 09 0d 0a 09 09 7d 0d 0a | 09 09 72 65 74 75 72 6e |.....}..|..return|
|000007e0| 20 30 3b 0d 0a 7d 0d 0a | 0e 00 00 00 33 2e 30 20 | 0;..}..|....3.0 |
|000007f0| 61 6e 64 20 68 69 67 68 | 65 72 0e 00 00 00 33 2e |and high|er....3.|
|00000800| 30 20 61 6e 64 20 68 69 | 67 68 65 72 |0 and hi|gher |
+--------+-------------------------+-------------------------+--------+--------+