Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Re: Where the advice to use DBI bind parameters can go wrong (long)

by rdfield (Priest)
on Jun 27, 2002 at 08:23 UTC ( #177655=note: print w/ replies, xml ) Need Help??


in reply to Re: Where the advice to use DBI bind parameters can go wrong (long)
in thread Where the advice to use DBI bind parameters can go wrong (long)

hacker, the second example doesn't work because of the %$name being interpolated inside the double quotes. Single quotes is a saves a bit of typing over qq{}.

As a solution to the initial problem pointed out by dws the work-around in Oracle is to use InterMedia indexes for full text searches of VARCHAR2 and LOB data. They can be a bit tricky to set up initially but do work well when you get them going (make sure you monitor the CTX server process).

rdfield


Comment on Re: Re: Where the advice to use DBI bind parameters can go wrong (long)
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (13)
As of 2014-09-22 18:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (198 votes), past polls