Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^3: DBI variable argument count

by ig (Vicar)
on Sep 14, 2012 at 02:50 UTC ( #993625=note: print w/ replies, xml ) Need Help??


in reply to Re^2: DBI variable argument count
in thread DBI variable argument count

Take a break - it's amazing what a fresh mind can see.

I'm not familiar with REGEXP, so can't comment on that.

I would strip down the query then build it back up one argument at a time, to see where the problem is. Do you get some records from the query select * from nsmw? If so, then add your where clauses one at a time. This will, at least, narrow your focus a bit.

update: a quick look at REGEXP turns up this for MySQL 5.1:

The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multi-byte safe and may produce unexpected results with multi-byte character sets. In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal.

Are your strings plain ASCII or are they multi-byte?


Comment on Re^3: DBI variable argument count
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://993625]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (16)
As of 2015-07-06 13:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (74 votes), past polls