--nqp=nb64=()p1KaLmIg2 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Here is something I wrote to help myself out. This custom tag will = take an ADO recordset and return a CF query. If you have any questions = please drop me a line. Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX: 301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] WWW: www.euservices.com > -----Original Message----- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 18, 2001 3:58 PM > To: CF-Talk > Subject: ADO > > > I'm in the middle of a project that'll help the community in CF 5. = I'd like > it if anyone who has some ADO scripts, please send them to me off = list. I've > already 'worked' with one to get the tables from a datasource. Other = 'admin > level' ADO scripts as well as straight DB calls will all be = appreciated. > The results will be up on customtags.org soon. That site will be = build and > have a front end up this week (I'm out of work). > Thanks > > Michael Dinowitz > Publisher: Fusion Authority weekly news alert > (www.fusionauthority.com/alert) > Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc. > (www.houseoffusion.com) > --nqp=nb64=()p1KaLmIg2 Content-Type: application/octet-stream; name="ADORS2Query.cfm" Content-Disposition: attachment; filename="ADORS2Query.cfm" Content-Transfer-Encoding: base64 PENGU0VUVElORyBFTkFCTEVDRk9VVFBVVE9OTFk9IlllcyI+IDwhLS0tIERvbid0IGFkZCB3 aGl0ZSBzcGFjZSAtLS0+DQo8IS0tLQ0KIFBhZ2U6IEFET1JTMlF1ZXJ5LmNmbQ0KIEZ1bmN0 aW9uOiBUaGlzIGlzIGEgQ29sZEZ1c2lvbiBDdXN0b20gVGFnIHRvIGNyZWF0ZSBhIHF1ZXJ5 IGZyb20NCiAJCQlhbmQgQURPIFJlY29yZHNldC4NCg0KIENyZWF0ZWQgYnk6IAlCaWxsIEdy b3Zlcg0KIAkJCQlGZWJ1cmFyeSAzLCAyMDAwDQoNCiBERVNDUklQVElPTjogDQoJVGhpcyBt b2R1bGUgdGFrZXMgYW4gQURPIFJlY29yZHNldCBhbmQgY3JlYXRlcyBhIENvbGRGdXNpb24N CglxdWVyeS4gIFRoaXMgaXMgdXNlZnVsIGlmIHlvdSBoYXZlIGEgcmVjb3Jkc2V0IGFuZCB5 b3UgbmVlZCB0byB1c2UNCgl0aGUgcmVzdWx0cyBpbiBhIENGTUwgdGFnLCBzdWNoIGFzIENG T1VUUFVULCBDRkxPT1AsIENGTUFJTCwgZXRjLg0KCQ0KIEFUVFJJQlVURVM6DQoJQURPUlMJ ICAtIChyZXF1aXJlZCkgdGhlIG5hbWUgcmVjb3Jkc2V0IHRvIGJlIGNvbnZlcnRlZC4NCglR dWVyeU5hbWUgLSAocmVxdWlyZWQpIHRoZSBuYW1lIG9mIHRoZSBxdWVyeSBvdCBwbGFjZSB0 aGUgcmVzdWx0cyBpbnRvLg0KDQogTElNSVRBVElPTlM6DQoJVGhpcyBtb2R1bGUgcmVxdWly ZXMgdGhhdCB0aGUgcmVjb3Jkc2V0IGJlIGNyZWF0ZWQgaW4gdGhlIGNhbGxpbmcgcGFnZS4N CiANCi0tLT4NCg0KPCEtLS0gQ2hlY2sgdGhhdCB0aGUgYXR0cmlidXRlIHdlcmUgcGFzc2Vk IC0tLT4NCjxDRklGICNJc0RlZmluZWQoIkFUVFJJQlVURVMuQURPUlMiKSMgQU5EICNJc0Rl ZmluZWQoIkFUVFJJQlVURVMuUXVlcnlOYW1lIikjPg0KDQoJPCEtLS0gQ3JlYXRlIHRoZSB2 YXJpYWJsZXMgbmVlZGVkIHRvIHJlZmVyZW5jZSBiYWNrIHRvIHRoZSBvcmlnaW5hdGluZyBw YWdlIC0tLT4NCgk8Q0ZTRVQgbGNSZWNTZXROYW1lID0gIkNBTExFUi4iICYgI0FUVFJJQlVU RVMuQURPUlMjPg0KCTxDRlNFVCBsY1F1ZXJ5TmFtZSAJPSAiQ0FMTEVSLiIgJiAjQVRUUklC VVRFUy5RdWVyeU5hbWUjPg0KDQoJPENGU0VUIGxvUmVjU2V0ID0gRVZBTFVBVEUoIiNsY1Jl Y1NldE5hbWUjIik+DQoJPENGU0VUIGxvRmllbGRMaXN0ID0gbG9SZWNTZXQuZmllbGRzPg0K CQ0KCTxDRlNFVCBsbkFET1JTVHJ1ZSA9IEVWQUxVQVRFKCItMSIpPg0KDQoJPCEtLS0gQmVm b3JlIHdlIGdldCB0byBmYXIgbGV0J3MgbWFrZSBzdXJlIHdlIGhhdmUgcmVjb3JkcyB0byBw cm9jZXNzISAtLS0+DQoJPENGSUYgbG9SZWNTZXQuQk9GIEVRIGxuQURPUlNUcnVlIEFORCBs b1JlY1NldC5FT0YgRVEgbG5BRE9SU1RydWU+DQoJCTwhLS0tIE5vIFJlY29yZHMgdG8gUHJv Y2VzcyBzbyBkb24ndCBkbyBhbnl0aGluZyEgLS0tPg0KDQoJPENGRUxTRT4NCgkJPCEtLS0g QmVnaW4gcHJvY2Vzc2luZyB0aGUgcmVjb3Jkc2V0IGFuZCBnZW5lcmF0aW5nIHRoZSBxdWVy eSAtLS0+DQoJCTxDRlNFVCBsY0ZpZWxkTGlzdCA9ICIiPg0KCQ0KCQk8IS0tLSBDcmVhdGUg YSBzdHJpbmcgdGhhdCB3aWxsIGNvbnRhaW4gdGhlIGNvbHVtbiBuYW1lcyBmb3IgdGhlIHF1 ZXJ5IC0tLT4NCgkJPENGTE9PUCBDT0xMRUNUSU9OPSIjbG9GaWVsZExpc3QjIiBpdGVtPSJs b0ZpZWxkIj4NCgkJCTxDRlNFVCBsY0ZpZWxkTGlzdCA9IGxjRmllbGRMaXN0ICYgI2xvRmll bGQubmFtZSMgJiAiLCAiPg0KCQk8L0NGTE9PUD4NCgkJPCEtLS0gU3RyaXAgb2ZmIHRoZSBj b21tYSBhdCB0aGUgZW5kIHNpbmNlIGl0J3Mgbm90IG5lZWRlZCAtLS0+DQoJCTxDRlNFVCBs Y0ZpZWxkTGlzdCA9IExFRlQobGNGaWVsZExpc3QsIExFTihsY0ZpZWxkTGlzdCkgLSAyKT4N CgkJDQoJCTwhLS0tIE5vdyBjcmVhdGUgdGhlIHF1ZXJ5IC0tLT4NCgkJPENGU0VUICIjbGNR dWVyeU5hbWUjIiA9IFF1ZXJ5TmV3KGxjRmllbGRMaXN0KT4NCgkJDQoJCTwhLS0tIENvcHkg ZWFjaCByZWNvcmQgaW4gdGhlIEFETyBSZWNvcmRzZXQgdG8gdGhlIHF1ZXJ5IC0tLT4NCgkJ PENGTE9PUCBDT05ESVRJT049Ik5PVCBsb1JlY1NldC5FT0YiPg0KCQkJPENGU0VUIFF1ZXJ5 QWRkUm93KEVWQUxVQVRFKCIjbGNRdWVyeU5hbWUjIikpPg0KICAgICAgICAJPCEtLS0gQ29w eSBlYWNoIGNvbHVtbiBmcm9tIHRoZSByZWNvcmRzZXQgdG8gdGhlIHF1ZXJ5IC0tLT4NCgkJ CTxDRkxPT1AgQ09MTEVDVElPTj0iI2xvRmllbGRMaXN0IyIgaXRlbT0ibG9GaWVsZCI+DQoJ CQkJPENGU0VUIFF1ZXJ5U2V0Q2VsbChFVkFMVUFURSgiI2xjUXVlcnlOYW1lIyIpLCAjbG9G aWVsZC5uYW1lIywgI2xvRmllbGQuVmFsdWUjKT4NCgkJCTwvQ0ZMT09QPg0KICAgICAgICAJ PENGU0VUIGxvUmVjU2V0Lm1vdmVuZXh0KCk+DQoJCTwvQ0ZMT09QPg0KCTwvQ0ZJRj4NCjxD RkVMU0U+DQoJPCEtLS0gSWYgYXR0cmlidXRlcyBub3QgcGFzc2VkLCBkaXNwbGF5IGFuIGVy cm9yIG1lc3NhZ2UsIGFuZCBhYm9ydCAtLS0+DQoJPENGU0VUIENBTExFUi5BRE9FcnJvciA9 ICI8SDE+RXJyb3IgaW4gY2Z4X0FET1JTMlF1ZXJ5LmNmbSE8L0gxPiBBRE9SUyBhbmQgUXVl cnlOYW1lIGF0dHJpYnV0ZXMgbXVzdCBiZSBzZXQuIj4NCjwhLS0tCTxDRkFCT1JUPiAtLS0+ DQo8L0NGSUY+DQo8Q0ZTRVRUSU5HIEVOQUJMRUNGT1VUUFVUT05MWT0iTm8iPg0K --nqp=nb64=()p1KaLmIg2-- Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
