From dev-return-12369-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Wed Jun 10 14:26:46 2009 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 21256 invoked from network); 10 Jun 2009 14:26:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Jun 2009 14:26:45 -0000 Received: (qmail 34257 invoked by uid 500); 10 Jun 2009 14:26:57 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 34213 invoked by uid 500); 10 Jun 2009 14:26:57 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 34203 invoked by uid 99); 10 Jun 2009 14:26:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jun 2009 14:26:56 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (athena.apache.org: transitioning domain of Alan.Raison@luminary.co.uk does not designate 69.18.216.40 as permitted sender) Received: from [69.18.216.40] (HELO mail.ingres.com) (69.18.216.40) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jun 2009 14:26:50 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: RE: SUBSTRING() arguments Date: Wed, 10 Jun 2009 10:26:22 -0400 Message-ID: In-Reply-To: <5037c36f.119bbed4.4a2fa47f.a602@o2.pl> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SUBSTRING() arguments Thread-Index: Acnpxn0grMaJbMcbT96enqi0Z7ONNQADmcbw References: <5037c36f.119bbed4.4a2fa47f.a602@o2.pl> From: "Alan Raison" To: X-Virus-Checked: Checked by ClamAV on apache.org SGkgTWlsb3N6DQoNClRoZSByZXF1aXJlc0Nhc3RGb3JNYXRoRnVuY3Rpb25zIHdhcyB0cnVlLiAg V2hlbiBzZXQgdG8gZmFsc2UsIEkgZ2V0IHRoZSBzYW1lIGVycm9yLCB3aXRob3V0IHRoZSBDQVNU czoNCg0KRnVuY3Rpb24gcmVxdWlyZXMgYXJndW1lbnQgdG8gYmUgbnVtZXJpYy4ge1NFTEVDVCB0 MC5pZCwgdDEuaWQsIHQxLmNpdHksIHQxLnBob25lTnVtYmVyLCB0MS5wb3N0YWxDb2RlLCB0MS5z dGF0ZSwgdDEuc3RyZWV0QWRkcmVzcywgdDAuTkFNRTAgRlJPTSBJRENfQ29tcGFueSB0MCBJTk5F UiBKT0lOIElEQ19BZGRyZXNzIHQxIE9OIHQwLkFERFJFU1NfSUQgPSB0MS5pZCBXSEVSRSAoKChQ T1NJVElPTigodDEuY2l0eSkgSU4gKFNVQlNUUklORyg/LCAoKD8gLSA/KSArIDEpKSkpIC0gMSAr ICg/IC0gPykpICsgPykgPiA/KX0gW2NvZGU9MzMwODk3LCBzdGF0ZT00MjAwMF0iDQoNCkkgZ3Vl c3MgdGhhdCdzIHdoeSBJIHNldCB0aGUgInJlcXVpcmVzQ2FzdC4uLiIgcHJvcGVydHksIGJ1dCBp dCBkb2Vzbid0IHNlZW0gdG8gYmUgd29ya2luZyENCg0KQWxhbsKgDQoNCi0tLS0tT3JpZ2luYWwg TWVzc2FnZS0tLS0tDQpGcm9tOiBNaWxvc3ogVHlsZW5kYSBbbWFpbHRvOm10eWxlbmRhQG8yLnBs XSANClNlbnQ6IDEwIEp1bmUgMjAwOSAxMzoxOA0KVG86IGRldkBvcGVuanBhLmFwYWNoZS5vcmcN ClN1YmplY3Q6IFJlOiBTVUJTVFJJTkcoKSBhcmd1bWVudHMNCg0KSGkgQWxhbiwNCg0KV2hhdCBp cyB0aGUgdmFsdWUgb2YgcmVxdWlyZXNDYXN0Rm9yTWF0aEZ1bmN0aW9ucyBpbiB5b3VyIGRpY3Rp b25hcnk/IEhhdmUgeW91IHRyaWVkIHJ1bm5pbmcgaXQgd2l0aCByZXF1aXJlc0Nhc3RGb3JNYXRo RnVuY3Rpb25zPWZhbHNlPw0KDQpHcmVldGluZ3MsDQpNaWxvc3oNCg0KDQo+IEhpIEFsbA0KPiAN Cj4gV2hpbGUgdGVzdGluZyB0aGUgSW5ncmVzIE9wZW5KUEEgZGljdGlvbmFyeSB0aGF0IEkgaGF2 ZSBiZWVuIGRldmVsb3BpbmcsIEkNCj4gZW5jb3VudGVyZWQgYSBmZXcgdGVzdCBmYWlsdXJlcyBy ZWxhdGluZyB0byBhcmd1bWVudHMgdG8gdGhlIHN1YnN0cmluZw0KPiBmdW5jdGlvbi4NCj4gDQo+ IEluZ3JlcyBjdXJyZW50bHkgZG9lc24ndCBoYXZlIGEgc3Vic3RyaW5nIGZ1bmN0aW9uIHRoYXQg YWNjZXB0cyBhIEJJR0lOVCBhcw0KPiB0aGUgaW5kZXggYXJndW1lbnQuICBUaGlzIHNlZW1zIHJl YXNvbmFibGUsIHNpbmNlIFZBUkNIQVJzIGFyZSBsaW1pdGVkIHRvDQo+IDIwMDAgY2hhcmFjdGVy cyBhbnl3YXkuDQo+IA0KPiBUaGUgZm9sbG93aW5nIHRlc3RzIGZhaWwgYXMgdGhleSBhcmUgdHJ5 aW5nIHRvIHVzZSBhIEJJR0lOVCBhcmd1bWVudCB0bw0KPiBTVUJTVFJJTkcuDQo+IA0KPiAqKSBv cmcuYXBhY2hlLm9wZW5qcGEucGVyc2lzdGVuY2UuanBxbC5mdW5jdGlvbnMuVGVzdEVKQlFMRnVu Y3Rpb24NCj4gCS50ZXN0Q29uY2F0U3ViU3RyaW5nRnVuYw0KPiAqKSBvcmcuYXBhY2hlLm9wZW5q cGEucGVyc2lzdGVuY2UubW9kZWxzLmNvbXBhbnkuQ29tcGFueU1vZGVsVGVzdA0KPiAJLnRlc3RC YXNpY1F1ZXJpZXMNCj4gICAgKFRoaXMgaXMgYW4gYWJzdHJhY3QgY2xhc3MgaW1wbGVtZW50ZWQg NCB0aW1lcyBieSB2YXJpb3VzIG1vZGVscykNCj4gDQo+IEkgbG9va2VkIGF0IHRoZSBjb2RlIGFu ZCBJIGNvdWxkbid0IGZpZ3VyZSBvdXQgd2h5IHRoZSBmcmFtZXdvcmsgd2FzIHNlbmRpbmcNCj4g dGhlIGluZGV4IGFzIGEgQklHSU5ULiAgQ2FuIGFueW9uZSBhZHZpc2U/DQo+IA0KPiBIZXJlIGlz IHRoZSBlcnJvciByZXR1cm5lZCwgYWx0aG91Z2ggSSB0aGluayBpdCBpcyByZWFsbHkgY29taW5n IGZyb20gdGhlDQo+IEluZ3JlcyBEYXRhYmFzZS4NCj4gDQo+IEZ1bmN0aW9uIHJlcXVpcmVzIGFy Z3VtZW50IHRvIGJlIG51bWVyaWMuIHtTRUxFQ1QgdDAuaWQsIHQwLkRUWVBFLA0KPiB0MC5maXJz dE5hbWUsIHQyLmlkLCB0Mi5jaXR5LCB0Mi5waG9uZU51bWJlciwgdDIucG9zdGFsQ29kZSwgdDIu c3RhdGUsDQo+IHQyLnN0cmVldEFkZHJlc3MsIHQwLmxhc3ROYW1lLCB0MS5pZCwgdDMuaWQsIHQz LmNpdHksIHQzLnBob25lTnVtYmVyLA0KPiB0My5wb3N0YWxDb2RlLCB0My5zdGF0ZSwgdDMuc3Ry ZWV0QWRkcmVzcywgdDEubmFtZSwgdDAuaGlyZURhdGUsIHQ0LmlkLA0KPiB0NC5EVFlQRSwgdDQu Zmlyc3ROYW1lLCB0NC5IT01FQUREUkVTU19JRCwgdDQubGFzdE5hbWUsIHQ0LkNPTVBBTllfSUQs DQo+IHQ0LmhpcmVEYXRlLCB0NC50aXRsZSwgdDQuc2FsYXJ5LCB0MC50aXRsZSwgdDAud2FnZSwg dDAud2Vla2x5SG91cnMgRlJPTQ0KPiBCQVNfUGVyc29uIHQwIElOTkVSIEpPSU4gQkFTX0NvbXBh bnkgdDEgT04gdDAuQ09NUEFOWV9JRCA9IHQxLmlkIExFRlQgT1VURVINCj4gSk9JTiBCQVNfQWRk cmVzcyB0MiBPTiB0MC5IT01FQUREUkVTU19JRCA9IHQyLmlkIExFRlQgT1VURVIgSk9JTiBCQVNf UGVyc29uDQo+IHQ0IE9OIHQwLk1BTkFHRVJfSUQgPSB0NC5pZCBMRUZUIE9VVEVSIEpPSU4gQkFT X0FkZHJlc3MgdDMgT04gdDEuQUREUkVTU19JRA0KPiA9IHQzLmlkIFdIRVJFICgoKFBPU0lUSU9O KCh0MS5uYW1lKSBJTiAoU1VCU1RSSU5HKD8sICgoQ0FTVCg/IEFTIEJJR0lOVCkgLQ0KPiBDQVNU KD8gQVMgQklHSU5UKSkgKyAxKSkpKSAtIDEgKyAoQ0FTVCg/IEFTIEJJR0lOVCkgLSBDQVNUKD8g QVMgQklHSU5UKSkpICsNCj4gPykgPiA/KSBBTkQgdDAuRFRZUEUgPSA/fSBbY29kZT0zMzA4OTcs IHN0YXRlPTQyMDAwXQ0KPiANCj4gQWxhbg0KPiANCj4gDQo=