Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Re: unpacking - html re-encoding?

by iakobski (Pilgrim)
on Jul 18, 2001 at 11:26 UTC ( #97569=note: print w/replies, xml ) Need Help??


in reply to Re: unpacking - html re-encoding?
in thread unpacking - html re-encoding?

quotemeta is close but not a perfect fit. It will escape (with a backslash) any non-alphanumeric which includes ALL punctuation and even spaces.

In most dialects of SQL, quotes are escaped by doubling them:

he said, "I'LL be back"
Would need to become:
'he said, "I''LL be back"'
Using the example given by the questioner. There's no need to escape other punctuation or spaces. And I said most, because the quoting given by DBI::quote() will match that required by the database transparently.

Update OK, alfie so you updated your reply while I was writing that. And ++ for the bit about asking for an e-mail.

-- iakobski

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2022-05-27 17:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (97 votes). Check out past polls.

    Notices?