Home page

Alternatura - Software Development Articles and Tips

1
WEB BASED DEVELOPMENT (INTRANET/EXTRANET/INTERNET) TECHNOLOGIES
HTML "PRE-PROCESSORS" TECHNOLOGIES (ASP, PHP, etc): GENERALITIES
HTML/DHTML
JavaScript
HTTP Protocol
TCP/IP Protocol
XML
  • A concise but overall XML Tutorial to the main concepts with real examples (by W3 Schools)
ASP.NET
ASP & VBScript
ADO
ColdFusion
  • Database transactions basics (CFTRANSACTION) (by CFHub.com).
    Used with DB error traps (CFTRY, CFCATCH)
  • Dealing with Dates and Times in ColdFusion (by Ron Kurtus for SFC).
    Date-Time display (DATEFORMAT()) and database manipulation (CREATEODBCDATETIME())
  • Building a ColdFusion Login System, Oracle oriented but with standard programing procedures (by Kailash Awati & Arati Apte for OraDsuion.com).
  • Hash function, refrence (from Macromedia).
  • CGI Environment variables. Retrieve your current URL: Not need to store your page name or query strings in variables, use the cgi object.
    Example: <CFSET current_page = "#cgi.path_info#?#cgi.query_string#">.
    In this way you can pass your complete current URL to a processing page that can return you back to the this page with the complete query string.
    Or just to Go Back to the referer page use CGI.http_referer
  • Get the "date modified" for your cfm page and create dynamic foot notes with "Last updated" statements
  • File Handling and Upload
    • Creating a ColdFusion upload page in Dreamweaver MX by Macromedia
    • CFFILE for file manipulation
    • CFDIRECTORY for file manipulation
PHP
MACROMEDIA FLASH & ActionScript
Scalable Vector Graphics (SVG)
(Drawing vector graphics on the fly with XML)
SQL
  • Creating a Developing Environment for MS SQL Server (by Roberto Miglietti for Alternatura)
  • MS SQL Server: Transact-SQL Reference by MS
  • MS SQL Server: SQL multiple condition (CASE...WHEN...ELSE) by MS
  • MS SQL Server: Type convertion functions (CAST and CONVERT) by MS
  • T-SQL looping: WHILE
  • Fundamentals of store procedures
  • T-SQL table copy and copy-structure
    • Copy data and structure
    • Copy structure (bulk-copy)
  • Cross-Tabs/Pivot views or table transpositions in MS SQL Server
    • Static cross-Tabs/Pivot tables using GROUP and CASE, the traditional way but not generic
    • Dynamic cross-Tabs/Pivot tables using store procedures
      The store procedure has parameters as follows
      EXECUTE crosstab SELECT statement, summary calculation, pivot column, table name
    • More dynamic pivot/cross-tab tables solutions

      Using the sp
    • Cross-tabs in MS SQL Server 2005: PIVOT and UNPIVOT
  • Tips
    • Concatenation and NULLs (more...)
      When concatenating in T-SQL (SELECT FirstName + LastName AS [User Name] FROM Users), if any of the concatenated fields is NULL the whole concatenation will be NULL.
      To avoid this, first get rid of the potential NULL value for all fields using the COALESCE() function:
      SELECT COALESCE(FirstName,'') + COALESCE(LastName,'') AS [User Name] FROM Users
    • Query pagination methods with ADO, arrays and stored procedures
  • Statistics in SQL, good chapter 8 from the Transact-SQL Cookbook
SSI (Server Side Includes) - SSI (Inclusión del Lado del Servidor)
Regular Expressions
Accesibility
RSS

Back to parent link