>-----Original Message-----
>From: Clinton [mailto:[EMAIL PROTECTED]]
>Sent: Friday, August 17, 2001 3:50 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Wildcards
>
>
>Thanks for the response Neil.
>It did in 97. I think this has changed in Access2000. I tried
>'A%' via Perl
>and directly both with no success.
Sorry. Didn't type the whole thing. Should be like 'A%'.
^^^^
That's the general syntax for what you are doing. Otherwise there might be
an error being generated, though this is probably the cause you should use {
RaiseError => 1} in the attributes of your database connection.
--Neil
>Regards
>CCJ
>----- Original Message -----
>From: "Neil Lunn" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, August 17, 2001 3:25 PM
>Subject: RE: Wildcards
>
>
>> >-----Original Message-----
>> >From: Clinton [mailto:[EMAIL PROTECTED]]
>> >Sent: Friday, August 17, 2001 3:11 PM
>> >To: [EMAIL PROTECTED]
>> >Subject: Wildcards
>> >
>> >
>> >My problem is if I run the query from perl I get no response -
>> >the program
>> >runs to completion with no errors (using strict and w).
>> >
>> >my $sql = "SELECT custID, ac_name, ac_address FROM tblAccount
>> >WHERE ac_state
>> >= 'VICTORIA' AND ac_name = 'A*' ORDER BY ac_name";
>> = 'VICTORIA' AND ac_name = 'A%' ORDER BY ac_name";
>>
>> The Access ODBC driver uses '%' instead just like SQL Server.
>>
>> --Neil
>>
>>
>_______________________________________________________________
>___________
>> Please Note :
>> Only the intended recipient is authorised to access or use
>this e-mail.
>> If you are not the intended recipient, please delete this e-mail and
>notify
>> the sender immediately. The contents of this e-mail are the writer's
>> opinion and are not necessarily endorsed by the Gunz Companies
>> unless expressly stated.
>>
>> We use virus scanning software but exclude all liability for
>viruses or
>> similar in any attachment.
>>
>>
>
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail.
If you are not the intended recipient, please delete this e-mail and notify
the sender immediately. The contents of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies
unless expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
