A common need in SQL is the ability to iterate over a list as if it were an array. In SQL it is not possible to declare arrays, unlike other programming languages such as ColdFusion, ActionScript and Java. Fortunately, there is a way around this problem: use a User-Defined Functions (UDFs) to create a tabular version of the data. Arrays are, after all, essentially tabular data (at their simplest, one dimension level).
Tags: ActionScript, array, data, database, database server, extend, function, Java, SQL, sub-routine, subroutine, t-sql, tabular, UDF, user defined function
The SQL Replace function enables us to look for a certain character phrase in a string and replace it with another character phrase. The updated string is then returned by the function.
Tags: database, database server, extend, fairly straight forward, function, Microsoft, Oracle, SQL, sub-routine, subroutine, t-sql, UDF, user defined function
SQLite is a mostly ACID-compliant relational database management system contained in a relatively small (~500kB) C programming library. The Adobe AIR runtime includes the SQLite embedded database for use by Adobe AIR applications. This allows applications to run and store data locally and or synchronise the datastore with online repositories.
Tags: ActionScript, Adobe, Adobe Integrated Runtime, AIR, attack, database, Databases, exploit, JavaScript, online repositories, relational database, SQL, SQL Injection, SQLite, United States, vulnerability
In my previous post, What is a SQL Injection Attack, I gave a brief overview of SQL injection and Cross-Site Scripting (XSS), primarily with regard to websites. In the example given, we saw that an attack could take the form of a ‘hacked’ URL which contained either a literal SQL statement, or a hexadecimal string that could be interpreted by an insecure SQL database server.
Tags: attack, backup, ColdFusion, cross-site scripting, database, database server, hack, hacking, how to, howto, programatically, restore, rollback, script, Scripting, SQL, XSS
Download the SQL Server 2005 JDBC Driver 1.2, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition).
This release of the JDBC Driver is JDBC 3.0 compliant and runs on the Java Development Kit (JDK) version 1.4 and higher. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, JBoss, and Sun.
Tags: Adobe ColdFusion, api, ColdFusion, database, download, driver, IBM, jar, Java, JDBC, Microsoft, Microsoft SQL Server, MSSQL, SQL Server 2005
Object-Relational Mapping (or ORM), is a programming technique that links databases to object-oriented language concepts, creating (in effect) a “virtual object database”. There are both free and commercial packages available that perform object-relational mapping, although some programmers opt to code their own object-relational mapping for their systems.
Tags: Active Record Factory, api, Code, code generation, ColdFusion, database, Doug Hughes, Frameworks, generation, Hibernate, mapping, Microsoft, Nicholas Tunney, object, object relational mapping, object-oriented programming, ObjectBreeze, Oracle, ORM, Programmer, Reactor, Reactor Reactor, relational database, SQL, Transfer, XML