|
 |
asp_databases thread: Searching for specific records using wildcards.
Message #1 by "DrClean" <Wayne@d...> on Thu, 14 Dec 2000 20:03:42 -0000
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C06608.F54846A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi All,
I have a specific problem that i can't seem to solve.
In a web page I have a text field that represents Post Codes filled in with
at least 2 characters by the client. When submitted I want to search using
the string they supply plus a wildcard and return all the relevant records
in the recordset with postcodes starting with what was supplied.
I've tried querying stored procedures and tables but whatever i do to the
SQL WHERE statement it doesn't recognise the wildcard element. All I get
returned is "NO Records Found for HA*" or whatever wildcard I try to use.
I've attempted WHERE Postcode LIKE, WHERE Postcode MATCHES and WHERE
Postcode CONTAINS
and the Request object is passed to a variable strPCode and appended with a
*, or a .* or a % (yes I've tried them all), None work.
Can someone please tell me what I'm doing wrong - I don't seem to populate
the recordset when using wildcards. Out of interest the recordset is
populated when I don't use wildcards.
Thanks in advance
Wayne
www.DrClean.co.uk
------=_NextPart_000_0000_01C06608.F54846A0
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IioUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHDAAOABMANwAAAAQAPwEB
A5AGAAgIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAMAAAAFNlYXJjaGluZyBmb3Igc3BlY2lmaWMgcmVjb3JkcyB1c2luZyB3aWxkY2FyZHMuAAIB
cQABAAAAFgAAAAHAZgfXBmCM92LR+RHUo5i3bqNWVz8AAAIBHQwBAAAAGQAAAFNNVFA6V0FZTkVA
RFJDTEVBTi5DTy5VSwAAAAALAAEOAAAAAEAABg4AAra9B2bAAQIBCg4BAAAAGAAAAAAAAABMXYe4
Oaq/EZsdNr7k4OdbwoAAAAsAHw4BAAAAAgEJEAEAAACaAwAAlgMAAEQFAABMWkZ15FIF2AMACgBy
Y3BnMTI1JjIA+AtgbmcB0DU3TwH3AqQD4wIAY2gKwHPwZXQwIAcTAoMAUALySRDJU2gJESBIAHBk
zQKAfQqACMggOwlvDjCWNQKACoF2CJB3awuA9GQ0DGBjAFALAwu1E3DEaSARYGxsLAqiCoQJCoBJ
IBDwdmUgYTggc3AFkAaQDeAgcMMDYAJgZW0gdBDwBUB1GCBjAHAnBUARIBrCb3cZ0AbwGZAuGJsD
oBnAd2RlYhpgYWcZoBlXdIxleAVAGjBlbGQa5C8JcBpwB5AJ8HQEIFBv/nMFQAhQAQAEIBowGGAJ
gH8bMAOgA/Aa8BmwBUAasGF9IKEyG1AQ8QDQHtARECDMYnka4RmgY2wIkAIwGC4gVyPAA6BzdWLe
bSHgHtAfYBlQdwBwBUDLHBIiYHIQ4CB1AJAPIL8joyCgBRAmpCOQJMBwC1DfI5ALUCZwHYIDEGQb
YAsg9xmwE6AfwXQIcB1xGGAjo7sJcBqwdiWSCXAFoWQEIN8hoSo0KyMRMCHEcCCRBaC3IPIgoArA
dCaSIdN3GwKvJYAtYSfiCJBkHJwnGZHLJyEhcXEKUHJ5JpIgoPcFsCFxGnFjCYAIcAeRKUL3AZEa
sCNhdSxxGwEqoASQHRsxZBwgHBEjslNRTOEkYEhFUkUtch7QB4C/JaEh4DQxB5AbgisCZwMA/xEg
I6MotyqBNdIkUBhRHjEfHhAfsimiIXIEICJOT3sH8CsVRghgKVECEAXASPBBKiIgBbEzlyi3GVD/
JyAjkRwgJnAcjTBSGxA1sT8FMCFxNSQgcy0iGDBMSThLRSwYMDUkQChNQTxUQzUwBfApQkE9Q0/A
TlRBSU5TGJQyo98jwTpwMPEgoRqQagWQGyH/BCAKsAQQIXEcERnAKrAHIdsaoScCUCDSKTNhJ/AJ
8OcBAB9gIdQgKkEABbEZwIQuKkmkJSAoeQeRrzBJI7Ea0CnxKUEATgIg6zeRBbBrHJtDA5EcQAeA
/0xiC1AiYTBxH0ADIAeALlS/MEAa0DRALdMDYCahLR4x5zRAG4os4HB1C2Ae0CuuVySCJnQotnMk
UE8zYW/+ZiGRIzFFgiu8RjJR5UjxXySCUNY9wVPpGJpUEPBu8msrY2FkKrEyIBiaCvReYwBBDDAS
AgvwOCRgYRZ5OcAYmndd4C5EchJDIlFuLgWgLnVrv1s8ChEC0QvFGKMT4QBhMAAACwABgAggBgAA
AAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMA
B4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUA
AAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAuA
CCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEYA
AAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAgg
BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAA
AAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBdgAggBgAAAAAAwAAAAAAAAEYAAAAA
BoUAAAAAAAADAF6ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAExdh7g5
qr8Rmx02vuTg51sCAfoPAQAAABAAAABMXYe4Oaq/EZsdNr7k4OdbAgH7DwEAAACCAAAAAAAAADih
uxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lO
RE9XU1xMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91
dGxvb2sucHN0AAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAMwAAADxMUEJCSkxCTkhLT0RHREZJ
Tk9QQkFFSERDQkFBLldheW5lQGRyY2xlYW4uY28udWs+AAADAAYQz79T1AMABxAvAwAAAwAQEAAA
AAADABEQAAAAAB4ACBABAAAAZQAAAEhJQUxMLElIQVZFQVNQRUNJRklDUFJPQkxFTVRIQVRJQ0FO
VFNFRU1UT1NPTFZFSU5BV0VCUEFHRUlIQVZFQVRFWFRGSUVMRFRIQVRSRVBSRVNFTlRTUE9TVENP
REVTRklMTEUAAAAAd/A
------=_NextPart_000_0000_01C06608.F54846A0--
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by Imar Spaanjaars <Imar@S...> on Thu, 14 Dec 2000 23:51:15 +0100
|
|
For SQL server, the % sign should do the trick.
SELECT clmSomething FROM tblSomeTable WHERE anOtherCOLUMN LIKE 'AB%'
will return all records where anOtherCOLUMN starts with AB.
But since you mentioned you already tried the % sign, something else is
probably going wrong, so maybe you could post some of your code.
HtH
Imar
At 10:46 PM 12/14/2000 -0800, you wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0000_01C06608.F54846A0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>
>Hi All,
>
>I have a specific problem that i can't seem to solve.
>
>In a web page I have a text field that represents Post Codes filled in with
>at least 2 characters by the client. When submitted I want to search using
>the string they supply plus a wildcard and return all the relevant records
>in the recordset with postcodes starting with what was supplied.
>
>I've tried querying stored procedures and tables but whatever i do to the
>SQL WHERE statement it doesn't recognise the wildcard element. All I get
>returned is "NO Records Found for HA*" or whatever wildcard I try to use.
>
>I've attempted WHERE Postcode LIKE, WHERE Postcode MATCHES and WHERE
>Postcode CONTAINS
>and the Request object is passed to a variable strPCode and appended with a
>*, or a .* or a % (yes I've tried them all), None work.
>
>Can someone please tell me what I'm doing wrong - I don't seem to populate
>the recordset when using wildcards. Out of interest the recordset is
>populated when I don't use wildcards.
>
>Thanks in advance
>
>Wayne
>
>www.DrClean.co.uk
>
>
>------=_NextPart_000_0000_01C06608.F54846A0
>Content-Type: application/ms-tnef;
> name="winmail.dat"
>Content-Transfer-Encoding: base64
>Content-Disposition: attachment;
> filename="winmail.dat"
>
>eJ8+IioUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
>b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHDAAOABMANwAAAAQAPwEB
>A5AGAAgIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
>AAAAMAAAAFNlYXJjaGluZyBmb3Igc3BlY2lmaWMgcmVjb3JkcyB1c2luZyB3aWxkY2FyZHMuAAIB
>cQABAAAAFgAAAAHAZgfXBmCM92LR+RHUo5i3bqNWVz8AAAIBHQwBAAAAGQAAAFNNVFA6V0FZTkVA
>RFJDTEVBTi5DTy5VSwAAAAALAAEOAAAAAEAABg4AAra9B2bAAQIBCg4BAAAAGAAAAAAAAABMXYe4
>Oaq/EZsdNr7k4OdbwoAAAAsAHw4BAAAAAgEJEAEAAACaAwAAlgMAAEQFAABMWkZ15FIF2AMACgBy
>Y3BnMTI1JjIA+AtgbmcB0DU3TwH3AqQD4wIAY2gKwHPwZXQwIAcTAoMAUALySRDJU2gJESBIAHBk
>zQKAfQqACMggOwlvDjCWNQKACoF2CJB3awuA9GQ0DGBjAFALAwu1E3DEaSARYGxsLAqiCoQJCoBJ
>IBDwdmUgYTggc3AFkAaQDeAgcMMDYAJgZW0gdBDwBUB1GCBjAHAnBUARIBrCb3cZ0AbwGZAuGJsD
>oBnAd2RlYhpgYWcZoBlXdIxleAVAGjBlbGQa5C8JcBpwB5AJ8HQEIFBv/nMFQAhQAQAEIBowGGAJ
>gH8bMAOgA/Aa8BmwBUAasGF9IKEyG1AQ8QDQHtARECDMYnka4RmgY2wIkAIwGC4gVyPAA6BzdWLe
>bSHgHtAfYBlQdwBwBUDLHBIiYHIQ4CB1AJAPIL8joyCgBRAmpCOQJMBwC1DfI5ALUCZwHYIDEGQb
>YAsg9xmwE6AfwXQIcB1xGGAjo7sJcBqwdiWSCXAFoWQEIN8hoSo0KyMRMCHEcCCRBaC3IPIgoArA
>dCaSIdN3GwKvJYAtYSfiCJBkHJwnGZHLJyEhcXEKUHJ5JpIgoPcFsCFxGnFjCYAIcAeRKUL3AZEa
>sCNhdSxxGwEqoASQHRsxZBwgHBEjslNRTOEkYEhFUkUtch7QB4C/JaEh4DQxB5AbgisCZwMA/xEg
>I6MotyqBNdIkUBhRHjEfHhAfsimiIXIEICJOT3sH8CsVRghgKVECEAXASPBBKiIgBbEzlyi3GVD/
>JyAjkRwgJnAcjTBSGxA1sT8FMCFxNSQgcy0iGDBMSThLRSwYMDUkQChNQTxUQzUwBfApQkE9Q0/A
>TlRBSU5TGJQyo98jwTpwMPEgoRqQagWQGyH/BCAKsAQQIXEcERnAKrAHIdsaoScCUCDSKTNhJ/AJ
>8OcBAB9gIdQgKkEABbEZwIQuKkmkJSAoeQeRrzBJI7Ea0CnxKUEATgIg6zeRBbBrHJtDA5EcQAeA
>/0xiC1AiYTBxH0ADIAeALlS/MEAa0DRALdMDYCahLR4x5zRAG4os4HB1C2Ae0CuuVySCJnQotnMk
>UE8zYW/+ZiGRIzFFgiu8RjJR5UjxXySCUNY9wVPpGJpUEPBu8msrY2FkKrEyIBiaCvReYwBBDDAS
>AgvwOCRgYRZ5OcAYmndd4C5EchJDIlFuLgWgLnVrv1s8ChEC0QvFGKMT4QBhMAAACwABgAggBgAA
>AAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMA
>B4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUA
>AAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAuA
>CCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEYA
>AAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAgg
>BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAA
>AAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBdgAggBgAAAAAAwAAAAAAAAEYAAAAA
>BoUAAAAAAAADAF6ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAExdh7g5
>qr8Rmx02vuTg51sCAfoPAQAAABAAAABMXYe4Oaq/EZsdNr7k4OdbAgH7DwEAAACCAAAAAAAAADih
>uxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lO
>RE9XU1xMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91
>dGxvb2sucHN0AAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAMwAAADxMUEJCSkxCTkhLT0RHREZJ
>Tk9QQkFFSERDQkFBLldheW5lQGRyY2xlYW4uY28udWs+AAADAAYQz79T1AMABxAvAwAAAwAQEAAA
>AAADABEQAAAAAB4ACBABAAAAZQAAAEhJQUxMLElIQVZFQVNQRUNJRklDUFJPQkxFTVRIQVRJQ0FO
>VFNFRU1UT1NPTFZFSU5BV0VCUEFHRUlIQVZFQVRFWFRGSUVMRFRIQVRSRVBSRVNFTlRTUE9TVENP
>REVTRklMTEUAAAAAd/A
>
>------=_NextPart_000_0000_01C06608.F54846A0--
>
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #3 by "Dallas Martin" <dmartin@z...> on Thu, 14 Dec 2000 20:51:33 -0500
|
|
With Access databases, use zipcode LIKE "234*"
With SQL or SQL92 Compliant, use zipcode LIKE "234%"
Let your code supply the wildcard, not the users.
----- Original Message -----
From: "DrClean" <Wayne@d...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, December 15, 2000 1:46 AM
Subject: [asp_databases] Searching for specific records using wildcards.
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0000_01C06608.F54846A0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Hi All,
>
> I have a specific problem that i can't seem to solve.
>
> In a web page I have a text field that represents Post Codes filled in
with
> at least 2 characters by the client. When submitted I want to search using
> the string they supply plus a wildcard and return all the relevant records
> in the recordset with postcodes starting with what was supplied.
>
> I've tried querying stored procedures and tables but whatever i do to the
> SQL WHERE statement it doesn't recognise the wildcard element. All I get
> returned is "NO Records Found for HA*" or whatever wildcard I try to use.
>
> I've attempted WHERE Postcode LIKE, WHERE Postcode MATCHES and WHERE
> Postcode CONTAINS
> and the Request object is passed to a variable strPCode and appended with
a
> *, or a .* or a % (yes I've tried them all), None work.
>
> Can someone please tell me what I'm doing wrong - I don't seem to populate
> the recordset when using wildcards. Out of interest the recordset is
> populated when I don't use wildcards.
>
> Thanks in advance
>
> Wayne
>
> www.DrClean.co.uk
>
>
> ------=_NextPart_000_0000_01C06608.F54846A0
> Content-Type: application/ms-tnef;
> name="winmail.dat"
> Content-Transfer-Encoding: base64
> Content-Disposition: attachment;
> filename="winmail.dat"
>
>
eJ8+IioUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
>
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHDAAOABMANwAAAAQAPwEB
>
A5AGAAgIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
>
AAAAMAAAAFNlYXJjaGluZyBmb3Igc3BlY2lmaWMgcmVjb3JkcyB1c2luZyB3aWxkY2FyZHMuAAIB
>
cQABAAAAFgAAAAHAZgfXBmCM92LR+RHUo5i3bqNWVz8AAAIBHQwBAAAAGQAAAFNNVFA6V0FZTkVA
>
RFJDTEVBTi5DTy5VSwAAAAALAAEOAAAAAEAABg4AAra9B2bAAQIBCg4BAAAAGAAAAAAAAABMXYe4
>
Oaq/EZsdNr7k4OdbwoAAAAsAHw4BAAAAAgEJEAEAAACaAwAAlgMAAEQFAABMWkZ15FIF2AMACgBy
>
Y3BnMTI1JjIA+AtgbmcB0DU3TwH3AqQD4wIAY2gKwHPwZXQwIAcTAoMAUALySRDJU2gJESBIAHBk
>
zQKAfQqACMggOwlvDjCWNQKACoF2CJB3awuA9GQ0DGBjAFALAwu1E3DEaSARYGxsLAqiCoQJCoBJ
>
IBDwdmUgYTggc3AFkAaQDeAgcMMDYAJgZW0gdBDwBUB1GCBjAHAnBUARIBrCb3cZ0AbwGZAuGJsD
>
oBnAd2RlYhpgYWcZoBlXdIxleAVAGjBlbGQa5C8JcBpwB5AJ8HQEIFBv/nMFQAhQAQAEIBowGGAJ
>
gH8bMAOgA/Aa8BmwBUAasGF9IKEyG1AQ8QDQHtARECDMYnka4RmgY2wIkAIwGC4gVyPAA6BzdWLe
>
bSHgHtAfYBlQdwBwBUDLHBIiYHIQ4CB1AJAPIL8joyCgBRAmpCOQJMBwC1DfI5ALUCZwHYIDEGQb
>
YAsg9xmwE6AfwXQIcB1xGGAjo7sJcBqwdiWSCXAFoWQEIN8hoSo0KyMRMCHEcCCRBaC3IPIgoArA
>
dCaSIdN3GwKvJYAtYSfiCJBkHJwnGZHLJyEhcXEKUHJ5JpIgoPcFsCFxGnFjCYAIcAeRKUL3AZEa
>
sCNhdSxxGwEqoASQHRsxZBwgHBEjslNRTOEkYEhFUkUtch7QB4C/JaEh4DQxB5AbgisCZwMA/xEg
>
I6MotyqBNdIkUBhRHjEfHhAfsimiIXIEICJOT3sH8CsVRghgKVECEAXASPBBKiIgBbEzlyi3GVD/
>
JyAjkRwgJnAcjTBSGxA1sT8FMCFxNSQgcy0iGDBMSThLRSwYMDUkQChNQTxUQzUwBfApQkE9Q0/A
>
TlRBSU5TGJQyo98jwTpwMPEgoRqQagWQGyH/BCAKsAQQIXEcERnAKrAHIdsaoScCUCDSKTNhJ/AJ
>
8OcBAB9gIdQgKkEABbEZwIQuKkmkJSAoeQeRrzBJI7Ea0CnxKUEATgIg6zeRBbBrHJtDA5EcQAeA
>
/0xiC1AiYTBxH0ADIAeALlS/MEAa0DRALdMDYCahLR4x5zRAG4os4HB1C2Ae0CuuVySCJnQotnMk
>
UE8zYW/+ZiGRIzFFgiu8RjJR5UjxXySCUNY9wVPpGJpUEPBu8msrY2FkKrEyIBiaCvReYwBBDDAS
>
AgvwOCRgYRZ5OcAYmndd4C5EchJDIlFuLgWgLnVrv1s8ChEC0QvFGKMT4QBhMAAACwABgAggBgAA
>
AAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMA
>
B4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUA
>
AAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAuA
>
CCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEYA
>
AAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAgg
>
BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAA
>
AAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBdgAggBgAAAAAAwAAAAAAAAEYAAAAA
>
BoUAAAAAAAADAF6ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAExdh7g5
>
qr8Rmx02vuTg51sCAfoPAQAAABAAAABMXYe4Oaq/EZsdNr7k4OdbAgH7DwEAAACCAAAAAAAAADih
>
uxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lO
>
RE9XU1xMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91
>
dGxvb2sucHN0AAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAMwAAADxMUEJCSkxCTkhLT0RHREZJ
>
Tk9QQkFFSERDQkFBLldheW5lQGRyY2xlYW4uY28udWs+AAADAAYQz79T1AMABxAvAwAAAwAQEAAA
>
AAADABEQAAAAAB4ACBABAAAAZQAAAEhJQUxMLElIQVZFQVNQRUNJRklDUFJPQkxFTVRIQVRJQ0FO
>
VFNFRU1UT1NPTFZFSU5BV0VCUEFHRUlIQVZFQVRFWFRGSUVMRFRIQVRSRVBSRVNFTlRTUE9TVENP
> REVTRklMTEUAAAAAd/A
>
> ------=_NextPart_000_0000_01C06608.F54846A0--
>
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #4 by rrrabe@y... on Fri, 15 Dec 2000 09:04:47 -0000
|
|
Hello Wayne,
Try this one.
For example "strPostCode" is the string that receives value from the text
field. Then,
"SQL where Postcode like '" & strPostCode & "%'"
ciao,
Bay
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #5 by "DrClean" <Wayne@d...> on Fri, 15 Dec 2000 09:32:49 -0000
|
|
Thanks Imar & Dallas,
It is an access database that I'm thinking of upsizing because it's rather
large. But- Yes I have got it working - by using the % and changing the LIKE
to = on the second condition (number field).
I've included to check that it's right as I am not totally sure that I'll
have no problems with the = sign on different browsers? I've also got two
recordset variables which I feel is wasting resources but I know of no other
way to count the results before printing them. I tried using the same
variable for both but it wouldn't perform 2 while opperations.
Your advice is much appreciated.
Wayne
www.DrClean.co.uk
<%
Dim strPCode, rsRepList, rsRecCount, strSQL, intRecsFound, objCommand
strPCode = Request.Form("Postcode") 'variable gets the postcode
strPCode = UCase(strPCode) 'make sure it's upper case
strPCode = strPCode & "%" 'append the wildcard
'set the SQL statement on the access database
strSQL = "SELECT * FROM tblBusinesses " &_
"WHERE Postcode LIKE '" & strPCode & "' " &_
"AND SIC_Number = '52720';"
'get a command object up and running
Set objCommand = Server.CreateObject("ADODB.Command")
objCommand.ActiveConnection = objConn
objCommand.CommandText = strSQL
objCommand.CommandType = adCmdText
'open a recordset
Set rsRepList = objCommand.Execute
Set rsRecCount = objCommand.Execute
'Count the records
intRecsFound = 0
While not rsRecCount.EOF
intRecsFound = intRecsFound+1
rsRecCount.MoveNext
Wend
Response.Write "<P align='Center'><Font face='Comic MS Sans' size='3'
color='#0000FF'>The search found " & intRecsFound & " Records.<Br> To narrow
the search be more" &_
" specific with the Post Code and if too few records have been
found extend the search by " &_
"looking at a different Post Code or being less
specific.<Br><Br></P></Font>"
Set objCommand = Nothing
'Display the records
While Not rsRepList.EOF
Response.Write _
"<Table border=0 width='80%' CellSpacing='2' CellPadding='2'
bgcolor='#3399FF' align='center'>" &_
"<Tr>" &_
"<Td align='Center' colspan=2> " & rsRepList("BusName") &_
"</TD>" &_
"</Tr>" &_
"<Tr>" &_
"<Td colspan=2> Contact; " & rsRepList("Contact") &_
"</TD>" &_
"</Tr>" &_
"<Tr>" &_
"<Td> Tel: " & rsRepList("Telephone") & "<Br> Fax; " & rsRepList("Fax")
&_
"</Td>" &_
"<Td>" & rsRepList("Number") & "<Br>" & rsRepList("Building") & "<Br>"
&_
rsRepList("Street") & "<BR>" & rsRepList("Town") & " " &
rsRepList("Postcode") &_
"</TD>" &_
"</Tr>" &_
"<Tr>" &_
"<Td> Classification; <Br> " & rsRepList("SIC_Description") &_
"</Td>" &_
"<Td> Email; <Br>" & rsRepList("Email") &_
"</Td>" &_
"</Tr>" &_
"<tr>" &_
"<td colspan=2><hr>" &_
"</Td>" &_
"</Tr>"
rsReplist.MoveNext
Response.Write "</Table>"
wend
'clean up
rsRepList.close
set rsRepList = nothing
rsRecCount.close
set rsRecCount = nothing
%>
-----Original Message-----
From: Imar Spaanjaars [mailto:Imar@S...]
Sent: 14 December 2000 22:51
To: ASP Databases
Subject: [asp_databases] Re: Searching for specific records using
wildcards.
For SQL server, the % sign should do the trick.
SELECT clmSomething FROM tblSomeTable WHERE anOtherCOLUMN LIKE 'AB%'
will return all records where anOtherCOLUMN starts with AB.
But since you mentioned you already tried the % sign, something else is
probably going wrong, so maybe you could post some of your code.
HtH
Imar
At 10:46 PM 12/14/2000 -0800, you wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0000_01C06608.F54846A0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>
>Hi All,
>
>I have a specific problem that i can't seem to solve.
>
>In a web page I have a text field that represents Post Codes filled in with
>at least 2 characters by the client. When submitted I want to search using
>the string they supply plus a wildcard and return all the relevant records
>in the recordset with postcodes starting with what was supplied.
>
>I've tried querying stored procedures and tables but whatever i do to the
>SQL WHERE statement it doesn't recognise the wildcard element. All I get
>returned is "NO Records Found for HA*" or whatever wildcard I try to use.
>
>I've attempted WHERE Postcode LIKE, WHERE Postcode MATCHES and WHERE
>Postcode CONTAINS
>and the Request object is passed to a variable strPCode and appended with a
>*, or a .* or a % (yes I've tried them all), None work.
>
>Can someone please tell me what I'm doing wrong - I don't seem to populate
>the recordset when using wildcards. Out of interest the recordset is
>populated when I don't use wildcards.
>
>Thanks in advance
>
>Wayne
>
>www.DrClean.co.uk
>
>
>------=_NextPart_000_0000_01C06608.F54846A0
>Content-Type: application/ms-tnef;
> name="winmail.dat"
>Content-Transfer-Encoding: base64
>Content-Disposition: attachment;
> filename="winmail.dat"
>
>eJ8+IioUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWN
y
>b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHDAAOABMANwAAAAQAPwE
B
>A5AGAAgIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAA
B
>AAAAMAAAAFNlYXJjaGluZyBmb3Igc3BlY2lmaWMgcmVjb3JkcyB1c2luZyB3aWxkY2FyZHMuAAI
B
>cQABAAAAFgAAAAHAZgfXBmCM92LR+RHUo5i3bqNWVz8AAAIBHQwBAAAAGQAAAFNNVFA6V0FZTkV
A
>RFJDTEVBTi5DTy5VSwAAAAALAAEOAAAAAEAABg4AAra9B2bAAQIBCg4BAAAAGAAAAAAAAABMXYe
4
>Oaq/EZsdNr7k4OdbwoAAAAsAHw4BAAAAAgEJEAEAAACaAwAAlgMAAEQFAABMWkZ15FIF2AMACgB
y
>Y3BnMTI1JjIA+AtgbmcB0DU3TwH3AqQD4wIAY2gKwHPwZXQwIAcTAoMAUALySRDJU2gJESBIAHB
k
>zQKAfQqACMggOwlvDjCWNQKACoF2CJB3awuA9GQ0DGBjAFALAwu1E3DEaSARYGxsLAqiCoQJCoB
J
>IBDwdmUgYTggc3AFkAaQDeAgcMMDYAJgZW0gdBDwBUB1GCBjAHAnBUARIBrCb3cZ0AbwGZAuGJs
D
>oBnAd2RlYhpgYWcZoBlXdIxleAVAGjBlbGQa5C8JcBpwB5AJ8HQEIFBv/nMFQAhQAQAEIBowGGA
J
>gH8bMAOgA/Aa8BmwBUAasGF9IKEyG1AQ8QDQHtARECDMYnka4RmgY2wIkAIwGC4gVyPAA6BzdWL
e
>bSHgHtAfYBlQdwBwBUDLHBIiYHIQ4CB1AJAPIL8joyCgBRAmpCOQJMBwC1DfI5ALUCZwHYIDEGQ
b
>YAsg9xmwE6AfwXQIcB1xGGAjo7sJcBqwdiWSCXAFoWQEIN8hoSo0KyMRMCHEcCCRBaC3IPIgoAr
A
>dCaSIdN3GwKvJYAtYSfiCJBkHJwnGZHLJyEhcXEKUHJ5JpIgoPcFsCFxGnFjCYAIcAeRKUL3AZE
a
>sCNhdSxxGwEqoASQHRsxZBwgHBEjslNRTOEkYEhFUkUtch7QB4C/JaEh4DQxB5AbgisCZwMA/xE
g
>I6MotyqBNdIkUBhRHjEfHhAfsimiIXIEICJOT3sH8CsVRghgKVECEAXASPBBKiIgBbEzlyi3GVD
/
>JyAjkRwgJnAcjTBSGxA1sT8FMCFxNSQgcy0iGDBMSThLRSwYMDUkQChNQTxUQzUwBfApQkE9Q0/
A
>TlRBSU5TGJQyo98jwTpwMPEgoRqQagWQGyH/BCAKsAQQIXEcERnAKrAHIdsaoScCUCDSKTNhJ/A
J
>8OcBAB9gIdQgKkEABbEZwIQuKkmkJSAoeQeRrzBJI7Ea0CnxKUEATgIg6zeRBbBrHJtDA5EcQAe
A
>/0xiC1AiYTBxH0ADIAeALlS/MEAa0DRALdMDYCahLR4x5zRAG4os4HB1C2Ae0CuuVySCJnQotnM
k
>UE8zYW/+ZiGRIzFFgiu8RjJR5UjxXySCUNY9wVPpGJpUEPBu8msrY2FkKrEyIBiaCvReYwBBDDA
S
>AgvwOCRgYRZ5OcAYmndd4C5EchJDIlFuLgWgLnVrv1s8ChEC0QvFGKMT4QBhMAAACwABgAggBgA
A
>AAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAM
A
>B4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIU
A
>AAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAu
A
>CCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEY
A
>AAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAg
g
>BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAA
A
>AAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBdgAggBgAAAAAAwAAAAAAAAEYAAAA
A
>BoUAAAAAAAADAF6ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAExdh7g
5
>qr8Rmx02vuTg51sCAfoPAQAAABAAAABMXYe4Oaq/EZsdNr7k4OdbAgH7DwEAAACCAAAAAAAAADi
h
>uxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0l
O
>RE9XU1xMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG9
1
>dGxvb2sucHN0AAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAMwAAADxMUEJCSkxCTkhLT0RHREZ
J
>Tk9QQkFFSERDQkFBLldheW5lQGRyY2xlYW4uY28udWs+AAADAAYQz79T1AMABxAvAwAAAwAQEAA
A
>AAADABEQAAAAAB4ACBABAAAAZQAAAEhJQUxMLElIQVZFQVNQRUNJRklDUFJPQkxFTVRIQVRJQ0F
O
>VFNFRU1UT1NPTFZFSU5BV0VCUEFHRUlIQVZFQVRFWFRGSUVMRFRIQVRSRVBSRVNFTlRTUE9TVEN
P
>REVTRklMTEUAAAAAd/A
>
>------=_NextPart_000_0000_01C06608.F54846A0--
>
---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS? Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #6 by Imar Spaanjaars <Imar@S...> on Fri, 15 Dec 2000 11:46:40 +0100
|
|
How about the following pseudo code?
Open connection
sSQL = "SELECT COUNT(ID) FROM myTable WHERE something is something
Recordset.Open sSQL, MyConnection
iCount = Recordset(0)
sSQL = "SELECT only, the, fields, you, need FROM myTable WHERE something is
something
Recordset.Open sSQL, MyConnection
Do something with the recordset
Close Recordset
Close Connection
Bit strange code, but it should give you an idea on how to do it.
Looping through a recordset just to count is an awful waste of resources.
The COUNT(ColumnName) function will give you the answer way faster.
Check out Ken's site to read on about ways to retrieve the number of records.
http://www.adopenstatic.com/faq/recordcountalternatives.asp
BTW, I am surprised that like '%' works on an Access database. I thought it
was a *
Imar
At 09:32 AM 12/15/2000 +0000, you wrote:
>Thanks Imar & Dallas,
>
>It is an access database that I'm thinking of upsizing because it's rather
>large. But- Yes I have got it working - by using the % and changing the LIKE
>to = on the second condition (number field).
>
>I've included to check that it's right as I am not totally sure that I'll
>have no problems with the = sign on different browsers? I've also got two
>recordset variables which I feel is wasting resources but I know of no other
>way to count the results before printing them. I tried using the same
>variable for both but it wouldn't perform 2 while opperations.
>
>Your advice is much appreciated.
>
>Wayne
>
>www.DrClean.co.uk
>
><%
> Dim strPCode, rsRepList, rsRecCount, strSQL, intRecsFound, objCommand
>
> strPCode = Request.Form("Postcode") 'variable
> gets the postcode
> strPCode = UCase(strPCode) 'make
> sure it's upper case
> strPCode = strPCode & "%" 'append
> the wildcard
>
> 'set the SQL statement on the access database
> strSQL = "SELECT * FROM tblBusinesses " &_
> "WHERE Postcode LIKE '" & strPCode & "' " &_
> "AND SIC_Number = '52720';"
>
> 'get a command object up and running
> Set objCommand = Server.CreateObject("ADODB.Command")
> objCommand.ActiveConnection = objConn
> objCommand.CommandText = strSQL
> objCommand.CommandType = adCmdText
>
> 'open a recordset
> Set rsRepList = objCommand.Execute
> Set rsRecCount = objCommand.Execute
>
> 'Count the records
> intRecsFound = 0
> While not rsRecCount.EOF
> intRecsFound = intRecsFound+1
> rsRecCount.MoveNext
> Wend
>
> Response.Write "<P align='Center'><Font face='Comic MS Sans' size='3'
>color='#0000FF'>The search found " & intRecsFound & " Records.<Br> To narrow
>the search be more" &_
> " specific with the Post Code and if
> too few records have been
>found extend the search by " &_
> "looking at a different Post Code or
> being less
>specific.<Br><Br></P></Font>"
>
> Set objCommand = Nothing
>
> 'Display the records
> While Not rsRepList.EOF
> Response.Write _
> "<Table border=0 width='80%' CellSpacing='2' CellPadding='2'
>bgcolor='#3399FF' align='center'>" &_
> "<Tr>" &_
> "<Td align='Center' colspan=2> " &
> rsRepList("BusName") &_
> "</TD>" &_
> "</Tr>" &_
> "<Tr>" &_
> "<Td colspan=2> Contact; " &
> rsRepList("Contact") &_
> "</TD>" &_
> "</Tr>" &_
> "<Tr>" &_
> "<Td> Tel: " & rsRepList("Telephone") & "<Br>
> Fax; " & rsRepList("Fax")
>&_
> "</Td>" &_
> "<Td>" & rsRepList("Number") & "<Br>" &
> rsRepList("Building") & "<Br>"
>&_
> rsRepList("Street") & "<BR>" &
> rsRepList("Town") & " " &
>rsRepList("Postcode") &_
> "</TD>" &_
> "</Tr>" &_
> "<Tr>" &_
> "<Td> Classification; <Br> " &
> rsRepList("SIC_Description") &_
> "</Td>" &_
> "<Td> Email; <Br>" & rsRepList("Email") &_
> "</Td>" &_
> "</Tr>" &_
> "<tr>" &_
> "<td colspan=2><hr>" &_
> "</Td>" &_
> "</Tr>"
> rsReplist.MoveNext
> Response.Write "</Table>"
>
> wend
> 'clean up
> rsRepList.close
> set rsRepList = nothing
> rsRecCount.close
> set rsRecCount = nothing
>%>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>-----Original Message-----
>From: Imar Spaanjaars [mailto:Imar@S...]
>Sent: 14 December 2000 22:51
>To: ASP Databases
>Subject: [asp_databases] Re: Searching for specific records using
>wildcards.
>
>
>For SQL server, the % sign should do the trick.
>
>SELECT clmSomething FROM tblSomeTable WHERE anOtherCOLUMN LIKE 'AB%'
>
>will return all records where anOtherCOLUMN starts with AB.
>
>But since you mentioned you already tried the % sign, something else is
>probably going wrong, so maybe you could post some of your code.
>
>HtH
>
>Imar
>
>
>At 10:46 PM 12/14/2000 -0800, you wrote:
> >This is a multi-part message in MIME format.
> >
> >------=_NextPart_000_0000_01C06608.F54846A0
> >Content-Type: text/plain;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: 7bit
> >
> >Hi All,
> >
> >I have a specific problem that i can't seem to solve.
> >
> >In a web page I have a text field that represents Post Codes filled in with
> >at least 2 characters by the client. When submitted I want to search using
> >the string they supply plus a wildcard and return all the relevant records
> >in the recordset with postcodes starting with what was supplied.
> >
> >I've tried querying stored procedures and tables but whatever i do to the
> >SQL WHERE statement it doesn't recognise the wildcard element. All I get
> >returned is "NO Records Found for HA*" or whatever wildcard I try to use.
> >
> >I've attempted WHERE Postcode LIKE, WHERE Postcode MATCHES and WHERE
> >Postcode CONTAINS
> >and the Request object is passed to a variable strPCode and appended with a
> >*, or a .* or a % (yes I've tried them all), None work.
> >
> >Can someone please tell me what I'm doing wrong - I don't seem to populate
> >the recordset when using wildcards. Out of interest the recordset is
> >populated when I don't use wildcards.
> >
> >Thanks in advance
> >
> >Wayne
> >
> >www.DrClean.co.uk
> >
> >
> >------=_NextPart_000_0000_01C06608.F54846A0
> >Content-Type: application/ms-tnef;
> > name="winmail.dat"
> >Content-Transfer-Encoding: base64
> >Content-Disposition: attachment;
> > filename="winmail.dat"
> >
> >eJ8+IioUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWN
>y
> >b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHDAAOABMANwAAAAQAPwE
>B
> >A5AGAAgIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAA
>B
> >AAAAMAAAAFNlYXJjaGluZyBmb3Igc3BlY2lmaWMgcmVjb3JkcyB1c2luZyB3aWxkY2FyZHMuAAI
>B
> >cQABAAAAFgAAAAHAZgfXBmCM92LR+RHUo5i3bqNWVz8AAAIBHQwBAAAAGQAAAFNNVFA6V0FZTkV
>A
> >RFJDTEVBTi5DTy5VSwAAAAALAAEOAAAAAEAABg4AAra9B2bAAQIBCg4BAAAAGAAAAAAAAABMXYe
>4
> >Oaq/EZsdNr7k4OdbwoAAAAsAHw4BAAAAAgEJEAEAAACaAwAAlgMAAEQFAABMWkZ15FIF2AMACgB
>y
> >Y3BnMTI1JjIA+AtgbmcB0DU3TwH3AqQD4wIAY2gKwHPwZXQwIAcTAoMAUALySRDJU2gJESBIAHB
>k
> >zQKAfQqACMggOwlvDjCWNQKACoF2CJB3awuA9GQ0DGBjAFALAwu1E3DEaSARYGxsLAqiCoQJCoB
>J
> >IBDwdmUgYTggc3AFkAaQDeAgcMMDYAJgZW0gdBDwBUB1GCBjAHAnBUARIBrCb3cZ0AbwGZAuGJs
>D
> >oBnAd2RlYhpgYWcZoBlXdIxleAVAGjBlbGQa5C8JcBpwB5AJ8HQEIFBv/nMFQAhQAQAEIBowGGA
>J
> >gH8bMAOgA/Aa8BmwBUAasGF9IKEyG1AQ8QDQHtARECDMYnka4RmgY2wIkAIwGC4gVyPAA6BzdWL
>e
> >bSHgHtAfYBlQdwBwBUDLHBIiYHIQ4CB1AJAPIL8joyCgBRAmpCOQJMBwC1DfI5ALUCZwHYIDEGQ
>b
> >YAsg9xmwE6AfwXQIcB1xGGAjo7sJcBqwdiWSCXAFoWQEIN8hoSo0KyMRMCHEcCCRBaC3IPIgoAr
>A
> >dCaSIdN3GwKvJYAtYSfiCJBkHJwnGZHLJyEhcXEKUHJ5JpIgoPcFsCFxGnFjCYAIcAeRKUL3AZE
>a
> >sCNhdSxxGwEqoASQHRsxZBwgHBEjslNRTOEkYEhFUkUtch7QB4C/JaEh4DQxB5AbgisCZwMA/xE
>g
> >I6MotyqBNdIkUBhRHjEfHhAfsimiIXIEICJOT3sH8CsVRghgKVECEAXASPBBKiIgBbEzlyi3GVD
>/
> >JyAjkRwgJnAcjTBSGxA1sT8FMCFxNSQgcy0iGDBMSThLRSwYMDUkQChNQTxUQzUwBfApQkE9Q0/
>A
> >TlRBSU5TGJQyo98jwTpwMPEgoRqQagWQGyH/BCAKsAQQIXEcERnAKrAHIdsaoScCUCDSKTNhJ/A
>J
> >8OcBAB9gIdQgKkEABbEZwIQuKkmkJSAoeQeRrzBJI7Ea0CnxKUEATgIg6zeRBbBrHJtDA5EcQAe
>A
> >/0xiC1AiYTBxH0ADIAeALlS/MEAa0DRALdMDYCahLR4x5zRAG4os4HB1C2Ae0CuuVySCJnQotnM
>k
> >UE8zYW/+ZiGRIzFFgiu8RjJR5UjxXySCUNY9wVPpGJpUEPBu8msrY2FkKrEyIBiaCvReYwBBDDA
>S
> >AgvwOCRgYRZ5OcAYmndd4C5EchJDIlFuLgWgLnVrv1s8ChEC0QvFGKMT4QBhMAAACwABgAggBgA
>A
> >AAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAM
>A
> >B4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIU
>A
> >AAEAAAAEAAAAOS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAu
>A
> >CCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEY
>A
> >AAAAOIUAAAEAAAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAg
>g
> >BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAA
>A
> >AAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAACwBdgAggBgAAAAAAwAAAAAAAAEYAAAA
>A
> >BoUAAAAAAAADAF6ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAIB+A8BAAAAEAAAAExdh7g
>5
> >qr8Rmx02vuTg51sCAfoPAQAAABAAAABMXYe4Oaq/EZsdNr7k4OdbAgH7DwEAAACCAAAAAAAAADi
>h
> >uxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0l
>O
> >RE9XU1xMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG9
>1
> >dGxvb2sucHN0AAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAMwAAADxMUEJCSkxCTkhLT0RHREZ
>J
> >Tk9QQkFFSERDQkFBLldheW5lQGRyY2xlYW4uY28udWs+AAADAAYQz79T1AMABxAvAwAAAwAQEAA
>A
> >AAADABEQAAAAAB4ACBABAAAAZQAAAEhJQUxMLElIQVZFQVNQRUNJRklDUFJPQkxFTVRIQVRJQ0F
>O
> >VFNFRU1UT1NPTFZFSU5BV0VCUEFHRUlIQVZFQVRFWFRGSUVMRFRIQVRSRVBSRVNFTlRTUE9TVEN
>P
> >REVTRklMTEUAAAAAd/A
> >
> >------=_NextPart_000_0000_01C06608.F54846A0--
> >
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
