Before Ant, building and deploying web applications required a series of scripts or manual processes, which often led to mistakes. Apache Ant is a software tool for automating software build processes. It is similar to Make but is implemented using the Java language, requires the Java platform, and is best suited to building Java projects. However, that doesn’t mean it is restricted to Java projects. I use Ant increasingly for all my web development projects as it is an integral part of Eclipse, my IDE of choice. It makes building applications and releasing them across different servers far more efficient and less problematic.
Tags: Apache Ant, automated build, best practices, build scripts, immediate processing, Java, JavaScript, local development server, similar build tool, SQL, The Definitive Guide, user acceptance testing server, web applications, web development, XML, Yahoo
PCI DSS stands for Payment Card Industry Data Security Standard, and is a worldwide security standard assembled by the Payment Card Industry Security Standards Council (PCI SSC). The PCI security standards are technical and operational requirements that were created to help organizations that process card payments prevent credit card fraud, hacking and various other security vulnerabilities and threats. The standards apply to all organizations that store, process or transmit cardholder data – with guidance for software developers and manufacturers of applications and devices used in those transactions. A company processing, storing, or transmitting cardholder data must be PCI DSS compliant.
Tags: Adobe ColdFusion, American Express, anti-virus software, Applications, architecture, Authentication, BlueDragon, Code, ColdFusion, ColdFusion Administrator, company processing, compliance, control measures, Data Security Standard, database server, Databases, Discover Financial Services, encryption, firewall, HTTP, Java, JCB International, Manitoba, Mastercard Worldwide, Payment Card Industry, Payment Card Industry Security Standards Council, payment card processing, Payment Processors, PCI DSS, public networks, Railo, raw processing, RDBMS, regulations, secure, secure systems, security, Security Standards Council, security systems, Server Side, software developers, software releases, SQL, SSC, the Council, Visa, Visa Inc ., web application, web application developers, web applications, web code, Web Servers
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
Every seasoned developer will know that protecting your website from a hacker is a top priority, whether for your own reputation or for maintaining your company’s reputation and log-term revenue prospects.
Tags: Adobe, Application.cfc, Application.cfm, attack, best practice, Business, cfquery, cfqueryparam, ColdFusion, ColdFusion Administrator, cross-site scripting, database server, Databases, encryption, firewall, how to, howto, Java, Manitoba, Mark Kruger, prevention, protection, raw processing, RDBMS, script protect, security, software releases, SQL, SQL Injection, url, variables, vulnerability, Web Application Hacker, web code, Web Security, Web Server, Web Servers, webserver, XSS
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
Over the past few weeks, subversive elements in the international arena have decided that attacking websites is a fun thing to do! The online world has become the new battle ground between nations vying to de-stabilise rivals. This may seem all very Jack Bauer, but we are increasingly seening ‘SQL injection attacks’ eminating from countries such as Russia, China and North Korea. Of course, that doesn’t mean our countries aren’t doing the same in return, but we only see the results from foreign-based attacks.
Tags: attack, C#, China, ColdFusion, cross-site scripting, hack, hacking, malicious web users, North Korea, online world, Russia, SQL, SQL Injection, T, url, web applications, XSS
Adobe has progressively been developing an online presence with Buzzword, Share, Brio and Photoshop Express. But the online presence falls short of important spreadsheet and presentation applications.
So who could the contenders be? Here are two extremely promising applications built on the Flash platform
Tags: Adobe, analytics tools, Applications, asset management, Blist, Brio, Buzzword, database software application, Databases, Flash, Flex, Google, Internet Application, Internet application technologies, Internet Evangelist writing, king, online database market, online database systems, online presence, online productivity application, online spreadsheet, Photoshop Express, presentation, presentation applications, presentation creation applications, presentation products, relational database, RIA, Rich Internet Applications, Ryan Stewart, Share, slide shows, SlideRocket, spreadsheets, SQL, web-based presentation application, web-based tools
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