(cwroblew) What do you do when the Perl CPAN module DBD::MySQL won’t install with a password for root and the Windows MySQL client program I use couldn’t remove the password for root? In the table the password was blank, but when I logged in on the command line, it required the root password I used
Author: SSWUG Research
Database-Based Authentication for PHP Apps, Part 1
(Michael McLaughlin) Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, database-based authentication is the solution.
Encryption: Not the End-All Fix for Data Privacy
(Philip Alexander) Are you prepared for the unthinkable? I’m talking about a security breach involving customer information. Many federal and state data-privacy laws now demand embarrassing and potentially business-damaging public disclosures when a breach occurs, but all such laws make exceptions i
Sorting
(Jonathan Lewis) This queston came up on the Oracle newsgroup a few days ago: I have a table (call it policy) with three columns a, b and c. The table has two rows, with column c having value zero for both rows. I run the following query select * from policy order by c;
Handling Result Sets and More with PDO Objects in PHP 5
(Alejandro Gervasio) Building PHP applications that interact with different database systems can be a daunting task, especially from a developer’s point of view. To tackle this issue with minor hassles, PHP 5.1 comes bundled with a powerful extension called PDO (short for PHP Data Objects), a librar
sql*plus pagesize explained
(Laurent Schneider) SQL*Plus is a not only the command-line interface to the database server, it is also a featured reporting tool with paging capabilities. The pagesize is the number of rows of one page. The default is 14 and the maximum is 50000. One of the common property of the page is the heade
Programming Crystal Reports with ASP.NET 2.0
(Jagadish Chaterjee) This is the first article in a series focusing on programming with Crystal Reports with ASP.NET 2.0. In this article, we will focus on adding a Crystal Report to an ASP.NET 2.0 web site and displaying the same using the CrystalReportViewer control in a number of different ways.
Working with Custom Provider Controls
(Brian Mains) The ASP.NET framework is made of up custom HTML and Server controls that are the building blocks for developing ASP.NET web applications. Other technologies are highly utilized in the web development process, such as HTML, CSS, and JavaScript; however, for data-driven or server-based
Preserving XML queries during schema evolution
(Mirella Moura Moro, Susan Malaika and Lipyeow Lim) The always evolving context of the Web imposes the challenge of how to accommodate new functionalities and new data types in the database that underlies a Web application or service. For XML databases, new schema versions can be released as frequen
Table Space Reporting with dba_spaceused
(Andrew Novick) Managing space is a constant responsibility for the DBA. When space becomes a problem I often want to know the size of each table. It isn’t difficult to find the amount of space used by a table, SQL Server provides the sp_spaceused stored procedure, which can report on the space use