Chad, You seem to have 4 bind variables but only need 3. Did you check the status of the execute call (or have RaiseError set to 1)?
Michael Fox -----Original Message----- From: chad kellerman [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 9:04 AM To: perl dbi Subject: problems with place holders Hello everyone, Trying to run a select statement but getting errors. I know it's something stupid but just can't put my finger on it: $addr_slct= qq( SELECT SUBSTRING_INDEX(IP, '.',2) AS addr, COUNT(*) AS addrsum FROM tbl_masterIP WHERE ipFree=? AND IP NOT LIKE ? AND IP NOT LIKE ? GROUP BY addr; ); $addr_count = $dbh->prepare($addr_slct); $addr_count->execute("Yes", "$ip1.%", "$ip2.%", "$admin"); $addr_count->bind_columns(\$addr, \$count); I can run the select statemenet from the command line and everything is fine, but thru script it fails? Any suggestions? Thanks for the help.. Chad Australia Post is committed to providing our customers with excellent service. If we can assist you in any way please either telephone 13 13 18 or visit our website www.auspost.com.au. CAUTION This e-mail and any files transmitted with it are privileged and confidential information intended for the use of the addressee. The confidentiality and/or privilege in this e-mail is not waived, lost or destroyed if it has been transmitted to you in error. If you have received this e-mail in error you must (a) not disseminate, copy or take any action in reliance on it; (b) please notify Australia Post immediately by return e-mail to the sender; and (c) please delete the original e-mail.
