RE: Calling a PostgreSQL function via DBI

Louis,

Perhaps you could attempt to explain, politely this time, what you meant
by the following.

As for your select statement with the $arg1, ..., $argN, the
bind_param() function will work
on those arguments too, I'd just suggest to use the process of double
quoting your string
concatenation assignments upfront:

$arg1 = "$someVariable" . "::someText";

What exactly do you believe adding the double quotes does to alter the
string value stored in $arg1? How is it any different from the
following:
$arg1 = $someVariable . "::someText";

Please spare us the rudeness while you're at it and just stick to the
technical issues.

-Will

-----Original Message-----
From: Louis Gonzales [mailto:louis.gonzales@xxxxxxxxxxxxxx]
Sent: Thursday 23 February 2006 15:47
To: Christian Stalp
Cc: dbi-users@xxxxxxxx; alexander@xxxxxxxx
Subject: Re: Calling a PostgreSQL function via DBI


And again, in now a third attempt to clarify to Will, nowhere did I
state that double quoting around a variable in PERL, is going to produce

a string with quote marks????????? Please Will, pay attention to what
I've written/write and don't paraphrase/quote me, because you are taking

everything I write, out of context and adding your own invalid ideas to
them.


- - - - - - - Appended by Scientific-Atlanta, Inc. - - - - - - -
This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.

.

Relevant Pages

  • Re: QuoteSQL
    ... quoting of non-wildcard specials ... I'm suggesting functions based on the role of the string they need to ... Quoting of wildcard strings for a query using LIKE etc. ... non-wildcard specials, ...
    (comp.lang.python)
  • Re: how to adapt a path name to the OS
    ... The quotes are only needed to protect certain characters from the ... shell. ... If you want to pass the string to Ada.Text_IO.Open to open a file, ... then you don't need quoting at all. ...
    (comp.lang.ada)
  • Re: puts variable without quoting
    ... but was wondering about performance of quoting it anyway. ... quotes with a puts string. ... Tclers omit the "$quotes" as a matter of style. ...
    (comp.lang.tcl)
  • Re: tablelist headers passed as variables containing blanks
    ... and they contain blanks ("Nom d'objet"). ... You have got the quoting wrong and you use a string where a list would ...
    (comp.lang.tcl)
  • How best to have incompatible but convertible types?
    ... I'd like to pass a temperature to a function and have somebody automagically convert the temperature to the type that the function's logic expects. ... In a web application, you need to deal with strings in many different quoting styles: HTML encoding, POST data encoding, database quoting, and shell quoting. ... Many SQL and shell injection attacks are based on quoting-style errors; it's easy to pass a string with the wrong quoting style and not notice it because your normal test data doesn't contain quotes, control characters, or null characters. ... If would be nice if there were a way to concatenate an SQL statement like ...
    (comp.lang.functional)