Beefy Boxes and Bandwidth Generously Provided by pair Networks Russ
Perl Monk, Perl Meditation
 
PerlMonks  

Re: variable substitution using Like in DBI

by BlueBlazerRegular (Friar)
on Sep 11, 2003 at 17:02 UTC ( [id://290822]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to variable substitution using Like in DBI

Instead of using '*' (like Access says you should), try the '%'. My tests don't work when using '*', but do when using the '%'. My guess is that DBI is converting it during the prepare step.

Other than that, my code looks just like jasonk and menolly's.

If it makes any difference, I'm using Access 97 via DBD::ODBC.

Good luck.

  • Comment on Re: variable substitution using Like in DBI

Replies are listed 'Best First'.
Re: Re: variable substitution using Like in DBI
by runrig (Abbot) on Sep 11, 2003 at 23:11 UTC
    My guess is that DBI is converting it during the prepare step.

    It's probably the ODBC driver doing the conversion. DBI shouldn't be converting anything, as it and DBD::ODBC wouldn't know anything about what needs to be converted specifically for Access.

[reply]
      Awesome .. thanks that fixed it. Shoulda thought of that though.. thanks guys for all your help.
[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://290822]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    • hippo‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.