Re: Re: Truncation Issues with SQL Server Insert Statement

From: Amonotod (amonotod_at_charter.net)
Date: 07/13/04 

To: <dbi-users@perl.org>
Date: Tue, 13 Jul 2004 20:11:24 +0000

> From: "Hardy Merrill" <HMerrill@dhcr.state.ny.us>
> Date: 2004/07/13 Tue PM 07:42:25 GMT
 
> Original poster: did you use either the "quote" method, or better yet
> did you use placeholders??

You know, to be more accurate, I am indeed using placeholders,
after constucting my sql statement from my field names. Placeholders
are a really cool way to do it, I've been getting 300K+ inserts done
in less than a minute.

I noticed, in the message this morning from M. Peppler, that he mentioned
 a BLK API, but I've never heard of this before. Does DBI in general
support this, or only certain DBDs?

> Hardy Merrill

Thanks,
amonotod (all lower case, btw... :-) 

-- 
    `\|||/         amonotod@    | subject line: 
      (@@)         charter.net  | no perl, no read...
  ooO_(_)_Ooo________________________________
  _____|_____|_____|_____|_____|_____|_____|_____|

Relevant Pages

  • RE: Fetch without Execute...
    ... If you fix the execute, ... Is key a reserved word in MySQL? ... Also, you should be using placeholders, or at least DBI->quote, instead ... of interpolating external data directly into an SQL statement. ...
    (perl.dbi.users)
  • Re: cgi.pm; DBI, filtering input?
    ... > I've decided to use HTML::Entities to do the tag encoding. ... > How would I use DBI placeholders in the case of a multiple insert? ... into one SQL statement. ...
    (comp.lang.perl.misc)
  • Re: How can i escape special characters( % [ _ ) in an Access SQL statement?
    ... It is a recommended practice to use @parameters to provide placeholders in ... Construct the Sql statement with parameters and assign ... the values by mapping each value to the corresponding parameter. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Dynamic DTS Task Challenge
    ... hardcoded name and SQL statement that includes the database name. ... Then use an activeX task to replace placeholders in the sql statements with this database name. ... Helge ...
    (microsoft.public.sqlserver.dts)
  • Re: How to escape single quotes inside fields but not the ones around fields?
    ... I replace it with a string and then replace it back. ... i cannot use the placeholders to handle strings because this is a ... generic function in a perl lib that works like bcp in sybase (i.e., ... Btw, I used to do alot of ADO back in the day. ...
    (comp.lang.perl.misc)