/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / ScriptBuilder / NOSB30_TRIAL.exe / data1.cab / Program_Files / scriptlib3.sbl / ROOT35 / DATA

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 09 00 00 00 44 62 54 6f | 41 72 72 61 79 09 00 00 |....DbTo|Array...|
|00000010| 00 44 62 54 6f 41 72 72 | 61 79 08 00 00 00 4c 69 |.DbToArr|ay....Li|
|00000020| 76 65 57 69 72 65 37 00 | 00 00 53 74 6f 72 65 73 |veWire7.|..Stores|
|00000030| 20 74 68 65 20 72 65 73 | 75 6c 74 73 20 6f 66 20 | the res|ults of |
|00000040| 61 20 53 51 4c 20 71 75 | 65 72 79 20 69 6e 74 6f |a SQL qu|ery into|
|00000050| 20 61 6e 20 61 72 72 61 | 79 20 6f 62 6a 65 63 74 | an arra|y object|
|00000060| 2e f8 04 00 00 2f 2a 20 | 3d 3d 3d 3d 3d 3d 3d 3d |...../* |========|
|00000070| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|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 0d 0a |========|======..|
|000000b0| 46 55 4e 43 54 49 4f 4e | 3a 20 44 62 54 6f 41 72 |FUNCTION|: DbToAr|
|000000c0| 72 61 79 0d 0a 20 0d 0a | 49 4e 50 55 54 3a 20 09 |ray.. ..|INPUT: .|
|000000d0| 64 62 20 2d 20 61 6e 20 | 6f 70 65 6e 20 64 61 74 |db - an |open dat|
|000000e0| 61 62 61 73 65 20 63 6f | 6e 6e 65 63 74 69 6f 6e |abase co|nnection|
|000000f0| 20 6f 62 6a 65 63 74 0d | 0a 09 09 09 73 71 6c 20 | object.|....sql |
|00000100| 2d 20 74 68 65 20 53 51 | 4c 20 73 74 61 74 65 6d |- the SQ|L statem|
|00000110| 65 6e 74 20 77 68 69 63 | 68 20 77 69 6c 6c 20 67 |ent whic|h will g|
|00000120| 65 6e 65 72 61 74 65 20 | 74 65 68 20 64 65 73 69 |enerate |teh desi|
|00000130| 72 65 64 20 72 65 63 6f | 72 64 0d 0a 09 09 09 41 |red reco|rd.....A|
|00000140| 72 72 20 2d 20 61 6e 20 | 61 72 72 61 79 20 6f 62 |rr - an |array ob|
|00000150| 6a 65 63 74 20 74 68 61 | 74 20 77 69 6c 6c 20 68 |ject tha|t will h|
|00000160| 6f 6c 64 20 74 68 65 20 | 64 61 74 61 0d 0a 0d 0a |old the |data....|
|00000170| 52 45 54 55 52 4e 3a 09 | 4e 6f 74 68 69 6e 67 0d |RETURN:.|Nothing.|
|00000180| 0a 0d 0a 44 45 53 43 3a | 09 09 53 74 6f 72 65 73 |...DESC:|..Stores|
|00000190| 20 74 68 65 20 72 65 73 | 75 6c 74 73 20 6f 66 20 | the res|ults of |
|000001a0| 61 6e 20 53 51 4c 20 71 | 75 65 72 79 20 69 6e 74 |an SQL q|uery int|
|000001b0| 6f 20 61 6e 20 61 72 72 | 61 79 20 6f 62 6a 65 63 |o an arr|ay objec|
|000001c0| 74 2e 20 42 65 63 61 75 | 73 65 20 0d 0a 09 09 09 |t. Becau|se .....|
|000001d0| 4a 61 76 61 73 63 72 69 | 70 74 20 64 6f 65 73 20 |Javascri|pt does |
|000001e0| 6e 74 6f 20 68 61 76 65 | 20 6d 75 6c 74 69 2d 64 |nto have| multi-d|
|000001f0| 69 6d 65 6e 73 69 6f 6e | 61 6c 20 61 72 72 61 79 |imension|al array|
|00000200| 73 2c 20 61 20 6f 6e 65 | 20 0d 0a 09 09 09 64 69 |s, a one| .....di|
|00000210| 6d 65 6e 73 69 6f 6e 61 | 6c 20 41 72 72 61 79 20 |mensiona|l Array |
|00000220| 6f 62 6a 65 63 74 20 68 | 6f 6c 64 73 20 74 68 65 |object h|olds the|
|00000230| 20 65 6e 74 69 72 65 20 | 72 65 63 6f 72 64 73 65 | entire |recordse|
|00000240| 74 2e 0d 0a 0d 0a 50 4c | 41 54 46 4f 52 4d 53 3a |t.....PL|ATFORMS:|
|00000250| 09 4e 65 74 73 63 61 70 | 65 20 4e 61 76 69 67 61 |.Netscap|e Naviga|
|00000260| 74 6f 72 20 33 2e 30 31 | 20 61 6e 64 20 68 69 67 |tor 3.01| and hig|
|00000270| 68 65 72 2c 0d 0a 09 09 | 09 20 20 09 4d 69 63 72 |her,....|.  .Micr|
|00000280| 6f 73 6f 66 74 20 49 6e | 74 65 72 6e 65 74 20 45 |osoft In|ternet E|
|00000290| 78 70 6c 6f 72 65 72 20 | 33 2e 30 32 20 61 6e 64 |xplorer |3.02 and|
|000002a0| 20 68 69 67 68 65 72 2c | 0d 0a 09 09 09 20 20 09 | higher,|.....  .|
|000002b0| 4e 65 74 73 63 61 70 65 | 20 45 6e 74 65 72 70 72 |Netscape| Enterpr|
|000002c0| 69 73 65 20 53 65 72 76 | 65 72 20 33 2e 30 2c 0d |ise Serv|er 3.0,.|
|000002d0| 0a 09 09 09 20 20 09 4d | 69 63 72 6f 73 6f 66 74 |....  .M|icrosoft|
|000002e0| 20 49 49 53 2f 41 53 50 | 20 33 2e 30 2e 0d 0a 0d | IIS/ASP| 3.0....|
|000002f0| 0a 53 41 4d 50 4c 45 3a | 0d 0a 0d 0a 0d 0a 09 76 |.SAMPLE:|.......v|
|00000300| 61 72 20 70 6f 6f 6c 20 | 3d 20 6e 65 77 20 44 62 |ar pool |= new Db|
|00000310| 50 6f 6f 6c 20 28 22 4f | 44 42 43 22 2c 22 55 53 |Pool ("O|DBC","US|
|00000320| 45 52 22 2c 22 22 2c 22 | 22 2c 22 22 2c 22 22 2c |ER","","|","","",|
|00000330| 31 29 0d 0a 09 76 61 72 | 20 73 71 6c 20 3d 20 22 |1)...var| sql = "|
|00000340| 53 45 4c 45 43 54 20 2a | 20 46 52 4f 4d 20 4e 41 |SELECT *| FROM NA|
|00000350| 4d 45 22 09 0d 0a 09 76 | 61 72 20 61 20 3d 20 6e |ME"....v|ar a = n|
|00000360| 65 77 20 41 72 72 61 79 | 28 29 0d 0a 0d 0a 09 44 |ew Array|().....D|
|00000370| 62 54 6f 41 72 72 61 79 | 20 28 70 6f 6f 6c 2e 63 |bToArray| (pool.c|
|00000380| 6f 6e 6e 65 63 74 69 6f | 6e 28 29 2c 20 73 71 6c |onnectio|n(), sql|
|00000390| 2c 20 61 29 0d 0a 0d 0a | 09 2f 2f 50 72 69 6e 74 |, a)....|.//Print|
|000003a0| 20 6f 75 74 20 74 68 65 | 20 69 6e 66 6f 72 6d 61 | out the| informa|
|000003b0| 74 69 6f 6e 20 69 6e 20 | 74 68 65 20 61 72 72 61 |tion in |the arra|
|000003c0| 79 3a 0d 0a 09 0d 0a 09 | 66 6f 72 20 28 76 61 72 |y:......|for (var|
|000003d0| 20 6a 3d 30 3b 20 6a 3c | 3d 61 2e 6c 65 6e 67 74 | j=0; j<|=a.lengt|
|000003e0| 68 2d 31 3b 20 6a 2b 2b | 29 20 7b 0d 0a 09 09 77 |h-1; j++|) {....w|
|000003f0| 72 69 74 65 28 61 5b 6a | 5d 29 0d 0a 09 09 77 72 |rite(a[j|])....wr|
|00000400| 69 74 65 20 28 22 3c 62 | 72 3e 22 29 0d 0a 09 7d |ite ("<b|r>")...}|
|00000410| 0d 0a 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |..======|========|
|00000420| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000430| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000440| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000450| 3d 3d 3d 3d 3d 3d 20 2a | 2f 0d 0a 09 0d 0a 66 75 |====== *|/.....fu|
|00000460| 6e 63 74 69 6f 6e 20 44 | 62 54 6f 41 72 72 61 79 |nction D|bToArray|
|00000470| 20 28 64 62 2c 20 73 71 | 6c 2c 20 41 72 72 29 20 | (db, sq|l, Arr) |
|00000480| 7b 09 09 09 09 09 0d 0a | 0d 0a 09 76 61 72 20 72 |{.......|...var r|
|00000490| 65 73 75 6c 74 20 3d 20 | 64 62 2e 63 75 72 73 6f |esult = |db.curso|
|000004a0| 72 28 73 71 6c 29 0d 0a | 09 76 61 72 20 6a 3d 30 |r(sql)..|.var j=0|
|000004b0| 3b 0d 0a 09 0d 0a 09 77 | 68 69 6c 65 20 28 72 65 |;......w|hile (re|
|000004c0| 73 75 6c 74 2e 6e 65 78 | 74 28 29 29 20 7b 0d 0a |sult.nex|t()) {..|
|000004d0| 09 09 66 6f 72 20 28 76 | 61 72 20 69 3d 30 3b 20 |..for (v|ar i=0; |
|000004e0| 69 3c 3d 72 65 73 75 6c | 74 2e 63 6f 6c 75 6d 6e |i<=resul|t.column|
|000004f0| 73 28 29 2d 31 3b 69 2b | 2b 29 20 7b 0d 0a 09 09 |s()-1;i+|+) {....|
|00000500| 09 76 61 72 20 74 20 3d | 20 22 72 65 73 75 6c 74 |.var t =| "result|
|00000510| 2e 22 2b 72 65 73 75 6c | 74 2e 63 6f 6c 75 6d 6e |."+resul|t.column|
|00000520| 4e 61 6d 65 28 69 29 0d | 0a 09 09 09 41 72 72 5b |Name(i).|....Arr[|
|00000530| 6a 5d 20 3d 20 28 65 76 | 61 6c 28 74 29 29 0d 0a |j] = (ev|al(t))..|
|00000540| 09 09 09 6a 2b 2b 3b 09 | 0d 0a 09 09 7d 09 09 09 |...j++;.|....}...|
|00000550| 09 09 0d 0a 09 7d 09 09 | 09 09 0d 0a 7d 0e 00 00 |.....}..|....}...|
|00000560| 00 33 2e 30 20 61 6e 64 | 20 68 69 67 68 65 72 0e |.3.0 and| higher.|
|00000570| 00 00 00 33 2e 30 20 61 | 6e 64 20 68 69 67 68 65 |...3.0 a|nd highe|
|00000580| 72                      |                         |r       |        |
+--------+-------------------------+-------------------------+--------+--------+