home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1998-10-05 | 2.3 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
| SIMH tape data
| default (weak)
| |
| 99%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 0c 00 00 00 53 68 6f 77 | 53 51 4c 54 61 62 6c 65 |....Show|SQLTable|
|00000010| 0c 00 00 00 53 68 6f 77 | 53 51 4c 54 61 62 6c 65 |....Show|SQLTable|
|00000020| 03 00 00 00 41 53 50 2b | 00 00 00 44 69 73 70 6c |....ASP+|...Displ|
|00000030| 61 79 73 20 61 20 72 65 | 73 75 6c 74 20 73 65 74 |ays a re|sult set|
|00000040| 20 69 6e 20 61 20 53 45 | 4c 45 43 54 20 53 51 4c | in a SE|LECT SQL|
|00000050| 20 71 75 65 72 79 ca 08 | 00 00 27 3d 3d 3d 3d 3d | query..|..'=====|
|00000060| 3d 3d 3d 3d 3d 3d 3d 3d | 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 0d 0a | 27 20 50 52 4f 43 45 44 |======..|' PROCED|
|000000b0| 55 52 45 3a 09 53 68 6f | 77 53 51 4c 54 61 62 6c |URE:.Sho|wSQLTabl|
|000000c0| 65 0d 0a 0d 0a 27 20 49 | 4e 50 55 54 3a 09 09 09 |e....' I|NPUT:...|
|000000d0| 64 62 20 28 6f 62 6a 65 | 63 74 29 09 09 09 09 2d |db (obje|ct)....-|
|000000e0| 20 61 6e 20 6f 70 65 6e | 65 64 20 64 61 74 61 62 | an open|ed datab|
|000000f0| 61 73 65 20 63 6f 6e 6e | 65 63 74 69 6f 6e 20 6f |ase conn|ection o|
|00000100| 62 6a 65 63 74 0d 0a 27 | 09 09 09 09 09 73 71 6c |bject..'|.....sql|
|00000110| 20 28 73 74 72 69 6e 67 | 29 09 09 09 2d 20 74 68 | (string|)...- th|
|00000120| 65 20 53 51 4c 20 71 75 | 65 72 79 20 73 74 72 69 |e SQL qu|ery stri|
|00000130| 6e 67 20 75 73 65 64 20 | 74 6f 20 6f 70 65 6e 20 |ng used |to open |
|00000140| 74 68 65 0d 0a 27 09 09 | 09 09 09 09 09 09 09 09 |the..'..|........|
|00000150| 09 09 20 20 72 65 63 6f | 72 64 20 73 65 74 0d 0a |.. reco|rd set..|
|00000160| 27 09 09 09 09 09 74 62 | 6c 62 6f 72 64 65 72 20 |'.....tb|lborder |
|00000170| 28 6e 75 6d 62 65 72 29 | 09 2d 20 74 68 65 20 48 |(number)|.- the H|
|00000180| 54 4d 4c 20 74 61 62 6c | 65 20 62 6f 72 64 65 72 |TML tabl|e border|
|00000190| 20 76 61 6c 75 65 0d 0a | 27 09 09 09 09 09 74 62 | value..|'.....tb|
|000001a0| 6c 77 69 64 74 68 20 28 | 73 74 72 69 6e 67 29 09 |lwidth (|string).|
|000001b0| 09 2d 20 74 68 65 20 48 | 54 4d 4c 20 74 61 62 6c |.- the H|TML tabl|
|000001c0| 65 20 77 69 64 74 68 20 | 76 61 6c 75 65 0d 0a 27 |e width |value..'|
|000001d0| 09 09 09 09 09 63 65 6c | 6c 70 61 64 64 69 6e 67 |.....cel|lpadding|
|000001e0| 20 28 6e 75 6d 62 65 72 | 29 09 2d 20 74 68 65 20 | (number|).- the |
|000001f0| 48 54 4d 4c 20 74 61 62 | 6c 65 20 63 65 6c 6c 70 |HTML tab|le cellp|
|00000200| 61 64 64 69 6e 67 20 76 | 61 6c 75 65 0d 0a 27 09 |adding v|alue..'.|
|00000210| 09 09 09 09 63 65 6c 6c | 73 70 61 63 69 6e 67 20 |....cell|spacing |
|00000220| 28 6e 75 6d 62 65 72 29 | 09 2d 20 74 68 65 20 48 |(number)|.- the H|
|00000230| 54 4d 4c 20 74 61 62 6c | 65 20 63 65 6c 6c 73 70 |TML tabl|e cellsp|
|00000240| 61 63 69 6e 67 20 76 61 | 6c 75 65 0d 0a 0d 0a 27 |acing va|lue....'|
|00000250| 20 44 45 53 43 3a 09 09 | 09 54 68 69 73 20 70 72 | DESC:..|.This pr|
|00000260| 6f 63 65 64 75 72 65 20 | 70 65 72 66 6f 72 6d 73 |ocedure |performs|
|00000270| 20 61 20 53 45 4c 45 43 | 54 20 53 51 4c 20 71 75 | a SELEC|T SQL qu|
|00000280| 65 72 79 20 61 6e 64 20 | 64 69 73 70 6c 61 79 73 |ery and |displays|
|00000290| 20 74 68 65 0d 0a 27 09 | 09 09 09 09 72 65 73 75 | the..'.|....resu|
|000002a0| 6c 74 20 73 65 74 20 69 | 6e 20 61 6e 20 48 54 4d |lt set i|n an HTM|
|000002b0| 4c 20 74 61 62 6c 65 0d | 0a 27 3d 3d 3d 3d 3d 3d |L table.|.'======|
|000002c0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000002d0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000002e0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|000002f0| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========|
|00000300| 3d 3d 3d 3d 3d 3d 0d 0a | 53 75 62 20 53 68 6f 77 |======..|Sub Show|
|00000310| 53 51 4c 54 61 62 6c 65 | 28 64 62 2c 20 73 71 6c |SQLTable|(db, sql|
|00000320| 2c 20 74 62 6c 62 6f 72 | 64 65 72 2c 20 74 62 6c |, tblbor|der, tbl|
|00000330| 77 69 64 74 68 2c 20 63 | 65 6c 6c 70 61 64 64 69 |width, c|ellpaddi|
|00000340| 6e 67 2c 20 63 65 6c 6c | 73 70 61 63 69 6e 67 29 |ng, cell|spacing)|
|00000350| 0d 0a 09 44 69 6d 20 72 | 73 2c 20 61 6c 69 67 6e |...Dim r|s, align|
|00000360| 2c 20 6e 75 6d 66 69 65 | 6c 64 73 2c 20 69 2c 20 |, numfie|lds, i, |
|00000370| 73 74 72 0d 0a 09 09 53 | 65 74 20 72 73 20 3d 20 |str....S|et rs = |
|00000380| 64 62 2e 45 78 65 63 75 | 74 65 28 73 71 6c 29 0d |db.Execu|te(sql).|
|00000390| 0a 0d 0a 09 49 66 20 4e | 6f 74 20 72 73 2e 45 4f |....If N|ot rs.EO|
|000003a0| 46 20 54 68 65 6e 0d 0a | 09 09 6e 75 6d 66 69 65 |F Then..|..numfie|
|000003b0| 6c 64 73 20 3d 20 72 73 | 2e 46 69 65 6c 64 73 2e |lds = rs|.Fields.|
|000003c0| 43 6f 75 6e 74 0d 0a 09 | 09 0d 0a 09 09 27 20 42 |Count...|.....' B|
|000003d0| 65 67 69 6e 20 74 61 62 | 6c 65 0d 0a 09 09 73 74 |egin tab|le....st|
|000003e0| 72 20 3d 20 22 3c 74 61 | 62 6c 65 20 62 6f 72 64 |r = "<ta|ble bord|
|000003f0| 65 72 3d 22 20 26 20 43 | 68 72 28 33 34 29 20 26 |er=" & C|hr(34) &|
|00000400| 20 74 62 6c 62 6f 72 64 | 65 72 20 20 26 20 43 68 | tblbord|er & Ch|
|00000410| 72 28 33 34 29 20 26 20 | 22 20 63 65 6c 6c 70 61 |r(34) & |" cellpa|
|00000420| 64 64 69 6e 67 3d 22 20 | 26 20 43 68 72 28 33 34 |dding=" |& Chr(34|
|00000430| 29 0d 0a 09 09 73 74 72 | 20 3d 20 73 74 72 20 26 |)....str| = str &|
|00000440| 20 63 65 6c 6c 70 61 64 | 64 69 6e 67 20 26 20 43 | cellpad|ding & C|
|00000450| 68 72 28 33 34 29 20 26 | 20 22 20 63 65 6c 6c 73 |hr(34) &| " cells|
|00000460| 70 61 63 69 6e 67 3d 22 | 20 26 20 43 68 72 28 33 |pacing="| & Chr(3|
|00000470| 34 29 20 26 20 63 65 6c | 6c 73 70 61 63 69 6e 67 |4) & cel|lspacing|
|00000480| 20 26 20 43 68 72 28 33 | 34 29 0d 0a 09 09 73 74 | & Chr(3|4)....st|
|00000490| 72 20 3d 20 73 74 72 20 | 26 20 22 20 77 69 64 74 |r = str |& " widt|
|000004a0| 68 3d 22 20 26 20 43 68 | 72 28 33 34 29 20 26 20 |h=" & Ch|r(34) & |
|000004b0| 74 62 6c 77 69 64 74 68 | 20 26 20 43 68 72 28 33 |tblwidth| & Chr(3|
|000004c0| 34 29 20 26 20 22 3e 3c | 74 72 3e 22 0d 0a 09 09 |4) & "><|tr>"....|
|000004d0| 52 65 73 70 6f 6e 73 65 | 2e 57 72 69 74 65 20 73 |Response|.Write s|
|000004e0| 74 72 0d 0a 09 09 0d 0a | 09 09 27 20 44 69 73 70 |tr......|..' Disp|
|000004f0| 6c 61 79 20 74 68 65 20 | 66 69 65 6c 64 20 6e 61 |lay the |field na|
|00000500| 6d 65 73 20 61 73 20 63 | 6f 6c 75 6d 6e 20 68 65 |mes as c|olumn he|
|00000510| 61 64 65 72 73 2e 20 41 | 6c 69 67 6e 20 63 6f 6c |aders. A|lign col|
|00000520| 75 6d 6e 20 68 65 61 64 | 65 72 73 20 77 69 74 68 |umn head|ers with|
|00000530| 20 6e 75 6d 65 72 69 63 | 20 0d 0a 09 09 27 20 66 | numeric| ....' f|
|00000540| 69 65 6c 64 20 76 61 6c | 75 65 73 20 74 6f 20 74 |ield val|ues to t|
|00000550| 68 65 20 72 69 67 68 74 | 20 61 6e 64 20 61 6c 6c |he right| and all|
|00000560| 20 6f 74 68 65 72 73 20 | 74 6f 20 74 68 65 20 6c | others |to the l|
|00000570| 65 66 74 2e 0d 0a 09 09 | 46 6f 72 20 69 20 3d 20 |eft.....|For i = |
|00000580| 30 20 74 6f 20 6e 75 6d | 66 69 65 6c 64 73 20 2d |0 to num|fields -|
|00000590| 20 31 0d 0a 09 09 09 49 | 66 20 49 73 4e 75 6d 65 | 1.....I|f IsNume|
|000005a0| 72 69 63 28 72 73 2e 46 | 69 65 6c 64 73 28 69 29 |ric(rs.F|ields(i)|
|000005b0| 2e 56 61 6c 75 65 29 20 | 54 68 65 6e 0d 0a 09 09 |.Value) |Then....|
|000005c0| 09 09 61 6c 69 67 6e 20 | 3d 20 22 72 69 67 68 74 |..align |= "right|
|000005d0| 22 0d 0a 09 09 09 45 6c | 73 65 0d 0a 09 09 09 09 |".....El|se......|
|000005e0| 61 6c 69 67 6e 20 3d 20 | 22 6c 65 66 74 22 0d 0a |align = |"left"..|
|000005f0| 09 09 09 45 6e 64 20 49 | 66 0d 0a 09 09 09 0d 0a |...End I|f.......|
|00000600| 09 09 09 73 74 72 20 3d | 20 22 3c 74 64 20 61 6c |...str =| "<td al|
|00000610| 69 67 6e 3d 22 20 26 20 | 43 68 72 28 33 34 29 20 |ign=" & |Chr(34) |
|00000620| 26 20 61 6c 69 67 6e 20 | 26 20 43 68 72 28 33 34 |& align |& Chr(34|
|00000630| 29 20 26 20 22 3e 3c 73 | 74 72 6f 6e 67 3e 22 0d |) & "><s|trong>".|
|00000640| 0a 09 09 09 73 74 72 20 | 3d 20 73 74 72 20 26 20 |....str |= str & |
|00000650| 72 73 2e 46 69 65 6c 64 | 73 28 69 29 2e 4e 61 6d |rs.Field|s(i).Nam|
|00000660| 65 20 26 20 22 3c 2f 73 | 74 72 6f 6e 67 3e 3c 2f |e & "</s|trong></|
|00000670| 74 64 3e 22 0d 0a 09 09 | 09 52 65 73 70 6f 6e 73 |td>"....|.Respons|
|00000680| 65 2e 57 72 69 74 65 20 | 73 74 72 0d 0a 09 09 09 |e.Write |str.....|
|00000690| 0d 0a 09 09 4e 65 78 74 | 0d 0a 09 09 09 0d 0a 09 |....Next|........|
|000006a0| 09 52 65 73 70 6f 6e 73 | 65 2e 57 72 69 74 65 20 |.Respons|e.Write |
|000006b0| 22 3c 2f 74 72 3e 22 0d | 0a 09 09 09 0d 0a 09 09 |"</tr>".|........|
|000006c0| 27 20 44 69 73 70 6c 61 | 79 20 61 6c 6c 20 66 69 |' Displa|y all fi|
|000006d0| 65 6c 64 20 76 61 6c 75 | 65 73 20 61 6c 69 67 6e |eld valu|es align|
|000006e0| 69 6e 67 20 6e 75 6d 65 | 72 69 63 20 76 61 6c 75 |ing nume|ric valu|
|000006f0| 65 73 20 74 6f 20 74 68 | 65 20 72 69 67 68 74 20 |es to th|e right |
|00000700| 61 6e 64 20 61 6c 6c 20 | 0d 0a 09 09 27 20 6f 74 |and all |....' ot|
|00000710| 68 65 72 73 20 74 6f 20 | 74 68 65 20 6c 65 66 74 |hers to |the left|
|00000720| 2e 0d 0a 09 09 44 6f 20 | 55 6e 74 69 6c 20 72 73 |.....Do |Until rs|
|00000730| 2e 45 4f 46 09 09 09 0d | 0a 09 09 09 52 65 73 70 |.EOF....|....Resp|
|00000740| 6f 6e 73 65 2e 57 72 69 | 74 65 20 22 3c 74 72 3e |onse.Wri|te "<tr>|
|00000750| 22 0d 0a 09 09 09 09 09 | 09 09 09 0d 0a 09 09 09 |".......|........|
|00000760| 46 6f 72 20 69 20 3d 20 | 30 20 74 6f 20 6e 75 6d |For i = |0 to num|
|00000770| 66 69 65 6c 64 73 20 2d | 20 31 0d 0a 09 09 09 09 |fields -| 1......|
|00000780| 49 66 20 49 73 4e 75 6d | 65 72 69 63 28 72 73 2e |If IsNum|eric(rs.|
|00000790| 46 69 65 6c 64 73 28 69 | 29 2e 56 61 6c 75 65 29 |Fields(i|).Value)|
|000007a0| 20 54 68 65 6e 0d 0a 09 | 09 09 09 09 61 6c 69 67 | Then...|....alig|
|000007b0| 6e 20 3d 20 22 72 69 67 | 68 74 22 0d 0a 09 09 09 |n = "rig|ht".....|
|000007c0| 09 45 6c 73 65 0d 0a 09 | 09 09 09 09 61 6c 69 67 |.Else...|....alig|
|000007d0| 6e 20 3d 20 22 6c 65 66 | 74 22 0d 0a 09 09 09 09 |n = "lef|t"......|
|000007e0| 45 6e 64 20 49 66 0d 0a | 09 09 09 09 0d 0a 09 09 |End If..|........|
|000007f0| 09 09 73 74 72 20 3d 20 | 22 3c 74 64 20 61 6c 69 |..str = |"<td ali|
|00000800| 67 6e 3d 22 20 26 20 43 | 68 72 28 33 34 29 20 26 |gn=" & C|hr(34) &|
|00000810| 20 61 6c 69 67 6e 20 26 | 20 43 68 72 28 33 34 29 | align &| Chr(34)|
|00000820| 20 26 20 22 3e 22 0d 0a | 09 09 09 09 73 74 72 20 | & ">"..|....str |
|00000830| 3d 20 73 74 72 20 26 20 | 72 73 2e 46 69 65 6c 64 |= str & |rs.Field|
|00000840| 73 28 69 29 2e 56 61 6c | 75 65 20 26 20 22 3c 2f |s(i).Val|ue & "</|
|00000850| 74 64 3e 22 0d 0a 09 09 | 09 09 52 65 73 70 6f 6e |td>"....|..Respon|
|00000860| 73 65 2e 57 72 69 74 65 | 20 73 74 72 0d 0a 09 09 |se.Write| str....|
|00000870| 09 4e 65 78 74 0d 0a 09 | 09 09 09 52 65 73 70 6f |.Next...|...Respo|
|00000880| 6e 73 65 2e 57 72 69 74 | 65 20 22 3c 2f 74 72 3e |nse.Writ|e "</tr>|
|00000890| 22 0d 0a 09 09 09 09 0d | 0a 09 09 09 72 73 2e 4d |".......|....rs.M|
|000008a0| 6f 76 65 4e 65 78 74 0d | 0a 09 09 4c 6f 6f 70 0d |oveNext.|...Loop.|
|000008b0| 0a 09 45 6e 64 20 49 66 | 0d 0a 09 09 72 73 2e 43 |..End If|....rs.C|
|000008c0| 6c 6f 73 65 0d 0a 09 53 | 65 74 20 72 73 20 3d 20 |lose...S|et rs = |
|000008d0| 4e 6f 74 68 69 6e 67 0d | 0a 09 0d 0a 09 27 20 45 |Nothing.|.....' E|
|000008e0| 6e 64 20 74 61 62 6c 65 | 0d 0a 09 52 65 73 70 6f |nd table|...Respo|
|000008f0| 6e 73 65 2e 57 72 69 74 | 65 20 22 3c 2f 74 61 62 |nse.Writ|e "</tab|
|00000900| 6c 65 3e 22 0d 0a 45 6e | 64 20 53 75 62 20 27 20 |le>"..En|d Sub ' |
|00000910| 45 6e 64 20 6f 66 20 53 | 68 6f 77 53 51 4c 54 61 |End of S|howSQLTa|
|00000920| 62 6c 65 20 0e 00 00 00 | 32 2e 30 20 61 6e 64 20 |ble ....|2.0 and |
|00000930| 68 69 67 68 65 72 0e 00 | 00 00 33 2e 30 20 61 6e |higher..|..3.0 an|
|00000940| 64 20 68 69 67 68 65 72 | |d higher| |
+--------+-------------------------+-------------------------+--------+--------+
