[Phoenix-pm] PERL DBI

[Loo, Peter # PHX]

Scott,

At any rate, I truly appreciate your comments and advises.
 
Peter Loo
Wolters Kluwer Health
(602) 381-9553

-----Original Message-----
From: phoenix-pm-bounces+peter.loo=source.wolterskluwer.com at pm.org
[mailto:phoenix-pm-bounces+peter.loo=source.wolterskluwer.com at pm.org] On
Behalf Of Scott Walters
Sent: Monday, March 13, 2006 2:46 PM
To: David A. Sinck
Cc: phoenix-pm at pm.org
Subject: Re: [Phoenix-pm] PERL DBI

On  0, "David A. Sinck" <phx-pm-list at grueslayer.com> wrote:
> 
> HAHAHAHAHA.  Guess again.  There's an instance, at least with MySQL

Okay, I don't use MySQL heavy (for reasons of it better garbage), so I
over generalized.  I conceede your point that rare bugs will make this
generalization not always true.

> \_ and you don't suffer
> \_ from SQL command length limitations,
> 
> I bet I could could craft something that hits a buffer still using 
> placeholders if I wanted.  :-)

I didn't say he didn't suffer from *buffer* length considerations --
that would be foolish indeed.  I only said that he doesn't suffer from
this particular one.  I've seen databases cap the command buffer at 64k.
Generally speaking (true in most cases, perhaps false in some) the
length-counted buffers for placeholder data will be significantly larger
than the command buffer.

> 
> \_ and the database doesn't have to parse potentially \_ megs of data 
> just to parse the SQL command,
> 
> Depends on the driver.  MySQL dbd, last I checked, actually sub'd the 
> values in before it got passed to the engine.  YMMV.

That must have been a long time ago indeed.  But you caught me -- I made
another false generalization.  I should have said "Generally, "
in front of it. 

By the way, people who argue small points while ignoring the point of
what was said annoy me.  Did you really think someone on the list would
be damaged thinking that placeholders always send data out of band, even
when using Informix?

I wrote a hasty reply out of desire to be helpful to someone who was
having trouble with something, not to debate minutia, and have been
punished for it.

-scott

> 
> David
> _______________________________________________
> Phoenix-pm mailing list
> Phoenix-pm at pm.org
> http://mail.pm.org/mailman/listinfo/phoenix-pm
_______________________________________________
Phoenix-pm mailing list
Phoenix-pm at pm.org
http://mail.pm.org/mailman/listinfo/phoenix-pm


This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.  Any unauthorized
review, use, disclosure or distribution is prohibited.  If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information.  Any unauthorized review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.