Ma.gnolia: Bookmarks in CodeGrrl

Careful with Numeric Data Types in MySQL

pyroman — Thu, 24 Jul 2008 07:05:28 PDT

TINYINT can be set to length of 4, but that doesn’t mean the max value is 9999.

Saved By: CodeGrrl | View Details | Give Thanks

Conditions on Count or Sum in MySQL

pyroman — Tue, 22 Jul 2008 07:07:36 PDT

When selecting count, sum, or some other aggregate function, the value isn’t determined until after the WHERE clause so a condition can’t be placed there.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: sql, syntax, mysql, database, having, conditions

Implementing HaloScan Powered Comments

pyroman — Tue, 08 Jul 2008 12:48:45 PDT

Saved By: CodeGrrl | View Details | Give Thanks

Tags: comments, haloscan, javascript, blog

Tips for MySQL to PostgreSQL Switch

pyroman — Wed, 02 Jul 2008 07:25:01 PDT

If you’ve decided to move a few tables from MySQL to PostgreSQL, these few tips might help.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: mysql, postgresql, syntax, database, sql

Gapjumper Web Application Framework

Gapjumper — Fri, 27 Jun 2008 12:37:29 PDT

Create engaging, high-performance and maintainable web applications more easily using the Gapjumper Web Application Framework.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: Ajax, Javascript, Animation, Web Components

Quicktips: Finding all the controllers in your cakePHP application

studiocanaria — Fri, 27 Jun 2008 12:04:43 PDT

Quicktip for cakePHP showing how to get a list of all controllers in your application from within code

Saved By: CodeGrrl | View Details | Give Thanks

Tags: cakephp, list controllers

CakePHP Currency Conversion Component

studiocanaria — Fri, 27 Jun 2008 12:04:26 PDT

A currency conversion component for CakePHP, converts between 35 different currencies with rates updated daily by the European Central Bank

Saved By: CodeGrrl | View Details | Give Thanks

Tags: cakephp, currency conversion, currency, component

CakePHP Auth Component - Users, Groups

studiocanaria — Fri, 27 Jun 2008 12:04:08 PDT

An updated step by step by step guide to setting up a User, Groups & Permissions based Authorization and Authentication system using cakePHP, without using ACL

Saved By: CodeGrrl | View Details | Give Thanks

Tags: cakephp, auth component, authentication, authorization, php

Creating a dynamic sidebar — WP Project

Vixx — Mon, 02 Jun 2008 04:22:25 PDT

How to create a dynamic sidebar for your WordPress blog. Display different content in your sidebar for home page, posts, archive pages, search page, 404 page, etc.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: wordpress

CSS Decorative Gallery

Vixx — Thu, 29 May 2008 06:26:02 PDT

Saved By: CodeGrrl | View Details | Give Thanks

Tags: jquery, rpg tools, tutorials, images, how to, howto, css effects, design, css, designer wall

Clearskys.net Blog » Blog Archive » Introducing StayPress

Vixx — Thu, 15 May 2008 00:49:34 PDT

Saved By: CodeGrrl | View Details | Give Thanks

Tags: wordpress plugins, wordpress

Page2RSS - Create an RSS feed for any web page

Vixx — Wed, 14 May 2008 14:06:33 PDT

Saved By: CodeGrrl | View Details | Give Thanks

Tags: rss

How To Use Triggers to Track Changes in MySQL

pyroman — Tue, 06 May 2008 06:41:18 PDT

Setting constraints and rules in the database is better than writing special code to handle the same task since it will prevent another developer from writing a different query that bypasses all of the special code and could leave your database with poor data integrity.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: mysql, sql, syntax, trigger, delimiter

Swap Insert for Update When Key Exists

pyroman — Wed, 30 Apr 2008 07:44:46 PDT

When synchronizing tables or databases, sometimes it is useful to have a way to update a row if there is already an entry for a key. Using the MySQL syntax, ON DUPLICATE KEY UPDATE, it is possible to insert a row if it doesn’t exist or update it if there is already a row with that key.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: mysql, insert, sql, syntax, duplicate

Apple - Aperture - Tutorials

Vixx — Wed, 30 Apr 2008 07:36:18 PDT

Watch the 50 online tutorials to learn about many of the 100 + new features of Aperture 2.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: aperture, mac, tutorials, photography

25 Web 2.0 Generators | WebTecker the latest Web Tech, Resources and News.

Vixx — Sun, 20 Apr 2008 11:10:42 PDT

A couple of days ago when I wrote 14 CSS Tools to Save you Time I left some resources off that list because they weren't CSS Tools, but they do save some time.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: None assigned

WordPress › Wordpress Automatic upgrade « WordPress Plugins

Vixx — Thu, 03 Apr 2008 03:21:44 PDT

Saved By: CodeGrrl | View Details | Give Thanks

Tags: wordpress, wordpress plugins

Sort out your drawers - .net magazine

Vixx — Tue, 25 Mar 2008 11:31:33 PDT

Craig Grannell provides you with a quick, easy and modular solution for creating website drawers, using a lean little script that's just hundreds of bytes in size

Saved By: CodeGrrl | View Details | Give Thanks

Tags: tutorials, webdesign, .net mag

Featured Mac Download: Run Internet Explorer on Your Mac with ies4osx

Vixx — Mon, 24 Mar 2008 05:03:39 PDT

Mac OS X only Install and run Internet Explorer for Windows or on your Mac with free open source application

Saved By: CodeGrrl | View Details | Give Thanks

Tags: mac, ie, design

Multiple Inserts with a Subquery

pyroman — Thu, 20 Mar 2008 11:53:10 PDT

Important information on using a subquery when doing an insert.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: efficient, insert, multiple inserts, multiple records, MySQL, subqueries, syntax

A Guide to Web Typography | i love typography, the typography blog

Vixx — Sun, 09 Mar 2008 05:53:31 PDT

The BasicsTypography for the Web has come a long way since Tim Berners-Lee flipped the switch in 1991. Back in the days of IE 1.0, good web typography was

Saved By: CodeGrrl | View Details | Give Thanks

Tags: typography

How to Break a MySQL Left Join

pyroman — Wed, 05 Mar 2008 10:14:42 PST

Information on how to properly use conditional statements when using a Left Join.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: join, left join, mysql, one-to-many, select, sql, unexpected behavior, soft delete

jQuery Tutorials for Designers

Vixx — Fri, 29 Feb 2008 07:13:27 PST

jQuery Tutorials for Designers

Saved By: CodeGrrl | View Details | Give Thanks

Tags: jquery, webdesign, tutorials

|| Dummy Text Generator | Lorem ipsum for webdesigners ||

Vixx — Mon, 25 Feb 2008 02:38:50 PST

A handy Lorem Ipsum Generator that helps to create dummy text for all layout needs.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: typography, text generator

Free Online Computer Science and Programming Books, Textbooks, and Lecture Notes | FreeTechBooks.com

Vixx — Wed, 13 Feb 2008 11:03:05 PST

Free online computer science, engineering and programming books, ebooks, texts, textbooks, lecture notes, documentations and references.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: tutorials

WPCandy » The WordPress Help Sheet

Vixx — Thu, 03 Jan 2008 11:10:02 PST

Saved By: CodeGrrl | View Details | Give Thanks

Tags: wordpress

WPCandy » The Advanced WordPress Help Sheet

Vixx — Thu, 03 Jan 2008 11:09:45 PST

Saved By: CodeGrrl | View Details | Give Thanks

Tags: wordpress

Ellagic acid - Wikipedia, the free encyclopedia

nightsurfer — Mon, 17 Sep 2007 18:48:51 PDT

Ellagic acid is a polyphenol antioxidant found in numerous fruits and vegetables including raspberries, strawberries, cranberries, walnuts, pecans, pomegranates and other plant foods.

Saved By: CodeGrrl | View Details | Give Thanks

Tags: Ellagic acid, Wikipedia, raspberries, strawberries, cranberries, walnuts, pecans, pomegranate, anti-cancer, anticancer, cancer, antioxidant, apoptosis, apoptotic, info, information, nutrition, reference