= Details =

 Applies to:: MySQL.py.parser
 Purpose::  Extend table creation abilities
 Description:: This patch adds the ability to create tables by massaging SQL queries.  For example this query finds customer addresses from a CRM, formats them into a table and makes one column a link to google maps highlighting the physical location of the customer. 

{{{
#!MySQL
DBDATA localhost,davecrm,crmread,DatabasePassword
QUERY select concat(concat("http://maps.google.com/maps?f=q&hl=en&q=", replace(shipping_address_street, "\n", ", "), ", ", shipping_address_city, ", New Zealand"), "|", concat("Map to ", name,  ", ", Shipping_address_street)) from accounts where NOT shipping_address_street = "" and NOT shipping_address_city = "" and NOT deleted = "1" order by name;
WMLCOLUMN 1
}}}

returns a table of links that looks like this

{{{ http://maps.google.com/maps?f=q&hl=en&q=320%20Manchester%20St,%20Christchurch,%20New%20Zealand   "Map to Total Team, 320 Manchester Street" }}}

= Patch =

{{attachment:MySQL.py.parser.diff}}

= Discussion =

Created by cfalconer@totalteam.co.nz   The purpose was to allow more flexible generation of tables from SQL queries, so that a URL could be created from a name field and an address field.  See the example above for one way to use WML.

And WML stands for Wiki Mark-up Language... for no reason at all.

 /!\ Please move this to the ParserMarket.

= Plan =
## This part is for Moin``Moin developers:

 * Priority: 
 * Assigned to:
 * Status: