From owner-cvs-ports@FreeBSD.ORG Wed Jan 16 12:42:57 2008 Return-Path: Delivered-To: cvs-ports@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 47A6616A420; Wed, 16 Jan 2008 12:42:57 +0000 (UTC) (envelope-from clsung@FreeBSD.org) Received: from repoman.freebsd.org (repoman.freebsd.org [IPv6:2001:4f8:fff6::29]) by mx1.freebsd.org (Postfix) with ESMTP id 263D913C46A; Wed, 16 Jan 2008 12:42:57 +0000 (UTC) (envelope-from clsung@FreeBSD.org) Received: from repoman.freebsd.org (localhost [127.0.0.1]) by repoman.freebsd.org (8.14.1/8.14.1) with ESMTP id m0GCgvdL010714; Wed, 16 Jan 2008 12:42:57 GMT (envelope-from clsung@repoman.freebsd.org) Received: (from clsung@localhost) by repoman.freebsd.org (8.14.1/8.14.1/Submit) id m0GCgvw7010713; Wed, 16 Jan 2008 12:42:57 GMT (envelope-from clsung) Message-Id: <200801161242.m0GCgvw7010713@repoman.freebsd.org> From: Cheng-Lung Sung Date: Wed, 16 Jan 2008 12:42:56 +0000 (UTC) To: ports-committers@FreeBSD.org, cvs-ports@FreeBSD.org, cvs-all@FreeBSD.org X-FreeBSD-CVS-Branch: HEAD Cc: Subject: cvs commit: ports/databases Makefile ports/databases/p5-SQL-Interp Makefile distinfo pkg-descr pkg-plist X-BeenThere: cvs-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: CVS commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 16 Jan 2008 12:42:57 -0000 clsung 2008-01-16 12:42:56 UTC FreeBSD ports repository Modified files: databases Makefile Added files: databases/p5-SQL-Interp Makefile distinfo pkg-descr pkg-plist Log: SQL::Interp converts a list of intermixed SQL fragments and variable references into a conventional SQL string and list of bind values suitable for passing onto DBI. This simple technique creates database calls that are simpler to create and easier to read, while still giving you full access to custom SQL. SQL::Interp properly binds or escapes variables. This recommended practice safeguards against "SQL injection" attacks. The DBI documentation has several links on the topic. Besides the simple techniques shown above, The SQL-Interpolate distribution includes the optional DBIx::Interp module. WWW: http://search.cpan.org/dist/SQL-Interp/ Revision Changes Path 1.660 +1 -0 ports/databases/Makefile 1.1 +23 -0 ports/databases/p5-SQL-Interp/Makefile (new) 1.1 +3 -0 ports/databases/p5-SQL-Interp/distinfo (new) 1.1 +15 -0 ports/databases/p5-SQL-Interp/pkg-descr (new) 1.1 +7 -0 ports/databases/p5-SQL-Interp/pkg-plist (new)