Just a curiosity at this point... Is there a way to do this using the quick quotes method?
Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -----Original Message----- From: Wieland Pusch [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 3:17 AM To: CAMPBELL, BRIAN D (BRIAN) Cc: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: Re: Large SQL statements... Hallo BRIAN, I like your solution with foreach and bind_param. Just add the prepare like this: $sth = $dbh->prepare("INSERT INTO AllMid_Data VALUES(?".(",?" x 21).")") or print "Error with INSERT _prepare_ $DBI::errstr\n"; Tuesday, September 7, 2004, 9:31:15 PM, you wrote: CBDB> This should work: $sth->>bind_param(1, undef); $sth->>bind_param($_+2, $data[$_]) foreach 0..20; $sth->>execute() or print "something"; cu Wieland mailto:[EMAIL PROTECTED]
