tag:blogger.com,1999:blog-55428402641564776062009-04-20T19:54:55.625-04:00PHP GuyAdventures in ProgrammingDonald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-5542840264156477606.post-12031997020457764832009-04-20T19:54:00.001-04:002009-04-20T19:54:55.633-04:00Andromeda Presenation from BarCamp Orlando<div style="width: 425px; text-align: left;" id="__ss_1318258"><a style="margin: 12px 0pt 3px; font-family: Helvetica,Arial,Sans-serif; font-style: normal; font-variant: normal; font-weight: normal; font-size: 14px; line-height: normal; font-size-adjust: none; font-stretch: normal; display: block; text-decoration: underline;" href="http://www.slideshare.net/dorgan/andromeda-1318258?type=powerpoint" title="Andromeda">Andromeda</a><object style="margin: 0px;" width="425" height="355"><param name="movie" value="http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=andromeda-090420174856-phpapp01&stripped_title=andromeda-1318258"><param name="allowFullScreen" value="true"><param name="allowScriptAccess" value="always"><embed src="http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=andromeda-090420174856-phpapp01&stripped_title=andromeda-1318258" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="355"></embed></object><div style="font-size: 11px; font-family: tahoma,arial; height: 26px; padding-top: 2px;">View more <a style="text-decoration: underline;" href="http://www.slideshare.net/">presentations</a> from <a style="text-decoration: underline;" href="http://www.slideshare.net/dorgan">dorgan</a>.</div></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-1203199702045776483?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-22591305506521146312009-04-06T15:20:00.001-04:002009-04-06T15:22:28.536-04:00Cable Monopolies<span style="font-size:130%;"><span style="font-weight: bold;">Part1</span></span><br /><br />It really seems like Brighthouse is not will to work with the customer AT ALL.<br /><br />I recently moved down to Cocoa, FL from New York and prices are generally higher up there and I was paying around $140.00 a month for the following:<br /><br />1 HD Multi Room DVR<br />1 SD Cable Box<br />HBO Package<br /><br />10 MB Down / 2MB Up<br /><br />Unlimited Nation Wide...<br /><br />and paid a total of around $150 a month including taxes and the occasional on-demand rental.<br /><br />Now Brighthouse wants to charge me $119 a month for the following:<br /><br />1 HD DVR (Not Multiroom)<br />1 SD Box<br />10 MB Down / ??? Up<br />No HBO<br /><br />$161.73 a month!!!!<br /><br />Then I asked if there was anything they could do and possible provide the DVR box free of charge and try to work with the customer or if there was anything else they could do and they told me absolutely not.<br /><br />Something is wrong here.<br /><br />When I was switching from Cablevision to Fios up in New York Cable vision was willing to make each service 29.95 a month.<br /><br /><span style="font-size:130%;"><span style="font-weight: bold;">Part2</span></span><br />WOW BrightHouse Networks Customer Service is horrible.<br /><br />So I finally decided to go online last night after all the phone call fun, and signed up for the double pack...For Internet Service and TV Service, including the extras I wanted.<br /><br />I never got a confirmation email and no one called me this morning, so I called them and the lady told me there was nothing in the system so I went ahead and put the order in and got an install appointment for wednesday(good). Cable/Internet is the only thing holding me back from moving into my house right now.<br /><br />Not 10 minutes after I get off the phone does the BrightHouse Promotions department call me and start to go into a speech about brighthouse and then i guess he looks at his screen and says "oooo, I was calling to offer $50 off your first month, for setting up your order online. but I see that you went ahead and called prematurely." So I responded with well cant you give me the $50 off I just signed up today. He said "Well, you would have to cancel the order..." so I said OK cancel the order. His response was..."Well I cant cancel the order you would have to call back and cancel the order"...I said oh ok well this is strike 2 for customer service, and then he started to tell me how he disagrees...thats when i hung up...unfortunately this is the only cable broadband provider in the this area and I guess they could give a rats ass about making any of their customers happy.<br /><br />So 2 strikes for BrightHouse Cable before they even get into my house.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-2259130550652114631?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-20569119125705602612009-02-11T11:16:00.004-05:002009-04-06T11:08:35.116-04:00Thunderbird Extension DevelopmentI've spent the last two weeks developing a thunderbird(tb) extension and I must say trying to find information specific to tb development is very hard to come by. Firefox plugin development information is all over the place. But tb resources are hard to come by. I have put together a quick reference that will hopefull get crawled by google and maybe give some help to others that are trying to do the same thing. Please not that this is just a qucik reference, of things I foudn to get the job done...they might not be the best method of doing things but it gets the job done.<br /><br /><style type="text/css"> <!-- @page { margin: 0.79in } P { margin-bottom: 0.08in } A:link { so-language: zxx } --> </style> <p style="margin-bottom: 0in;" align="center"><span style="font-size:130%;"><b>Thunderbird Extension Development</b></span></p> <p style="margin-bottom: 0in;" align="center"><br /></p> <p style="margin-bottom: 0in;" align="left"><b>Overlay Reference:</b></p> <ul><li><p style="margin-bottom: 0in; font-weight: normal;" align="left"><b>chrome://messenger/content/messenger.xul- </b>statusbar<br /></p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left"><b>chrome://messenger/content/mailWindowOverlay.xul- </b>Toolbar Menu (taskPopup), Message Context Menu (threadPaneContext)<br /></p> </li><li><p style="margin-bottom: 0in;" align="left"><b>chrome://messenger/content/msgHdrViewOverlay.xul- </b>Attachment Context Menu (attachmentListContext)</p> </li></ul> <p style="margin-bottom: 0in;" align="left"></p><p style="margin-bottom: 0in;" align="left"><b>Accessing Attachments</b></p> <ol><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var attachmentList = document.getElementById( 'attachmentList' ) // returns attachment list</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var selectedAttachments = attachmentList.selectedItems; //Get selected attachments</p> </li></ol> <p style="margin-left: 0.25in; margin-bottom: 0in; font-weight: normal;" align="left"><br /></p> <p style="margin-bottom: 0in;" align="left"><b>Getting Message Information</b></p> <p style="margin-bottom: 0in; font-weight: normal;" align="left"> var MessageUri = GetFirstSelectedMessage(); // Get Message URI</p> <p style="margin-bottom: 0in; font-weight: normal;" align="left"><br /></p> <p style="margin-bottom: 0in; font-weight: normal;" align="left"> /* Get message body as it appears in preview window */</p> <p style="margin-left: 0.49in; text-indent: -0.25in; margin-bottom: 0in; font-weight: normal;" align="left"> body = document.getElementById("messagepane").contentDocument.body.innerHTML;</p> <p style="margin-left: 0.49in; text-indent: -0.25in; margin-bottom: 0in; font-weight: normal;" align="left"><br /></p> <p style="margin-bottom: 0in;" align="left"><b>Accessing Limited Message Header information</b></p> <ol><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var msg = messenger.messageServiceFromURI(uri); // get message object</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var hdr = msg.messageURIToMsgHdr(uri); // get header object</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var subject = hdr.mime2DecodedSubject; // get Subject</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var from = hdr.mime2DecodedAuthor; // get From</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var to = hdr.mime2DecodedRecipients; // get To</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var msgdate = new Date( hdr.date/1000); // turn epoch into date</p> </li><li><p style="margin-bottom: 0in; font-weight: normal;" align="left">var messageid = hdr.messageId; // get message ID</p> </li></ol> <p style="margin-bottom: 0in; font-weight: normal;" align="left"><br /></p> <p style="margin-bottom: 0in; font-weight: normal;" align="left"><br /></p> <p style="margin-bottom: 0in;" align="left"><b>Downloading Attachments</b></p> <p style="margin-bottom: 0in; font-weight: normal;" align="left"> This piece of code will take all selected attachments and download them to <a href="file:///C:/">C:\</a> with their original filenames.</p> <p style="margin-bottom: 0in; font-weight: normal;" align="left"><br /></p> <ol><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">attachments = this.getSelectedAttachments();</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">for( i=0;i<attachments.length;i++></attachments.length;i++></span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">var attachment = attachments[i];</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> </p> <br /></li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">/* Create a file interface object */</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">var file = Components.classes["@mozilla.org/file/local;1"].</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">createInstance(Components.interfaces.nsILocalFile);</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">var fullfilepath = '<a href="file:///C:/test/">C:/test/</a>' + attachment.displayName;</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">file.initWithPath(fullfilepath);</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">if(!file.exists()) {</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">file.create(0x00,0644);</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">}</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">messenger.saveAttachmentToFile( file, attachment.url, attachment.uri, attachment.contentType, null );</span></span></p> </li><li><p style="background: rgb(204, 204, 204) none repeat scroll 0% 0%; margin-bottom: 0in; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial; font-weight: normal;" align="left"> <span style="font-family:Lucida Console,monospace;"><span style="font-size:85%;">}</span></span></p> </li></ol><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-2056911912570560261?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com4tag:blogger.com,1999:blog-5542840264156477606.post-81375442341877608752009-02-01T22:48:00.000-05:002009-02-01T22:49:36.393-05:00Upgrading My DesktopSo I am going to upgrade my computer....here is what i am going with:<br /><br /><a href="http://www.newegg.com/Product/Product.aspx?Item=N82E16813121314">Intel BOXDP35DPM LGA 775 Intel P35 ATX Intel Motherboard</a><br /><br /><a href="http://www.newegg.com/Product/Product.aspx?Item=N82E16814121268" target="_blank">ASUS EN9800GT HB/HTDI/512M GeForce 9800 GT 512MB 256-bit GDDR3 PCI Express 2.0 x16 HDCP Ready SLI Supported</a><br /><br /><a href="http://www.newegg.com/Product/Product.aspx?Item=N82E16817339025" target="_blank">hec X-Power Pro 600 600W Continuous @ 40°C ATX12V V2.2 SLI Ready CrossFire Ready Power Supply</a><br /><br /><a target="_blank" href="http://www.newegg.com/Product/Product.aspx?Item=N82E16819115055">Intel Core 2 Quad Q8200 2.33GHz LGA 775 95W Quad-Core Processor Model BX80580Q8200</a><br /><br />I am also going with 8GB of ram.<br /><br />Only thing let to decide on it CPU cooling.<br /><br />Linux will rock and I will be dual booting XP(maybe Vista) so that I can play StarCraft 2 when it comes out.<br /><br /><br />Comments/ Suggestions??<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-8137544234187760875?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com2tag:blogger.com,1999:blog-5542840264156477606.post-15773211594594484962009-01-15T16:49:00.002-05:002009-01-15T16:52:41.075-05:00PETA Wow I want some of what your all takingSo PETA has decided that fish should now be called sea kittens. and they let you create a "sea kitten" on their site. Well you let me know when you see something in the ocean that looks like this.<br /><br /><embed src="http://www.peta.org/sea_kittens/_swf/sea_kitten.swf?c=fl&c0=2&c1=1&c2=1&c3=2&c4=2&c5=2&c8=1&c10=1&n=Scooby%20Wooby&d=peta.org&tc=skembed" allowscriptaccess="always" pluginspage="http://www.macromedia.com/go/getflashplayer" wmode="transparent" type="application/x-shockwave-flash" width="300" height="354"></embed><br /><a href="http://www.peta.org/sea_kittens/index.asp?c=skembed">Create Your Own Sea Kitten at peta.org</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-1577321159459448496?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com1tag:blogger.com,1999:blog-5542840264156477606.post-76052488433569452572008-10-12T15:07:00.007-04:002008-10-13T10:04:47.023-04:00Andromeda: Give it a chanceI have been working with <a href="http://www.andromeda-project.org/">Andromeda</a> for well over a year now and I can honestly say that I love this framework! I have tried many other frameworks including the following:<br /><ul><li><a href="http://www.mach-ii.com/">Mach II</a> (ColdFusion)</li><li><a href="http://www.fusebox.org/">FuseBox</a> (ColdFusion & PHP)</li><li><a href="http://www.joomla.org/">Joolma</a> (Not necessarily a framework)</li><li>MyCMS (PHP) <span style="font-style: italic;">developed by jeff@madtasty.com</span></li></ul>And I have <span style="font-weight: bold; text-decoration: underline;">always</span> found a reason that I could not use the framework in the fashion it was intended. I guess this is because alot of framework take the MVC approach and try to separate the business logic from the display logic. The MVC approach can cause a very large headache when you are picking up somebody elses' project and they are no longer around to answer questions. It also can cause a little bit of a headache because in my option it tries to be too organized. So I have never really used a framework for any given project because once I have started on these projects I have found the need to modify the framework in such a way that now what I have made exists outside the framework.<br /><br />Now going back to the MVC approach, its definetly a good idea on paper however in the site/application is still just file based. So in the end instead of looking in say one object file you are looking in about 2,3,4 or even more places just to add a field to the page.<br /><br />In my opinion <a href="http://www.andromeda-project.org/">Andromeda</a> takes an MVC type approach and separates the business logic from the code completely, and puts it in the database. All your business rules go into the database and now the database does the validation, so you can never have invalid data.<br /><br /><a href="http://www.andromeda-project.org/">Andromeda</a> uses YAML to define the database and the rules. An example of this would be:<br /><div stlye="margin-left:auto;margin-right:auto;width:300px;background-color: #EEEEEE;border:1px solid #CCCCCC;"><pre><br />table contacts:<br /> module: addressbook<br /> column name:<br /> primary_key:"Y"<br /> description: Name<br /> tooltip: Persons Name<br /> uisearch: "Y"<br /> column add1:<br /> primary_key: "Y"<br /> column add2:<br /> column city:<br /> column state:<br /> column zip9:<br /></pre></div><br />The above creates a table called contacts with 6 column: name, add1, add2, city, state, zip.<br />Andromeda has predefined columns. I have used only predefined columns in the table above, but sya you wanted to create another field to store the contacts favorite food, you could achieve this in the following way:<br /><div stlye="margin-left:auto;margin-right:auto;width:300px;background-color: #EEEEEE;border:1px solid #CCCCCC;"><pre><br />column favorite_food:<br /> type_id: vchar<br /> description: Favorite Food<br />table contacts:<br /> module: addressbook<br /> column name:<br /> primary_key:"Y"<br /> description: Name<br /> tooltip: Persons Name<br /> uisearch: "Y"<br /> column add1:<br /> primary_key: "Y"<br /> column add2:<br /> column city:<br /> column state:<br /> column zip9:<br /> column favorite_food:<br /></pre><br /></div><br /><br />You now have defined a column "favorite_food" that can be used in any other table in your application. Now once we build our application this table will exist in our application and can be edited <span style="font-weight: bold;">right away</span> with 0 code. One of the things I love the most about <a href="http://www.andromeda-project.org/">Andromeda</a> is that it created the CRUD (CReate, Update, Delete) screens for you, with 0 code so any time you might have spent creating these screens is no longer needed and if you go back and look at my table definition you'll see there is a property called "module". This allows us to assign permissions groups for each of these modules. This is done in the following way:<br /><br /><div stlye="margin-left:auto;margin-right:auto;width:300px;background-color: #EEEEEE;border:1px solid #CCCCCC;"><pre><br /><br />group editors:<br /> description: Address Book Editors<br /> module addressbook:<br /> permsel: "Y"<br /> permdel: "Y"<br /> permins: "Y"<br /> permupd: "Y"<br /></pre></div><br /><br />This defines a group called "editors" and gives it SELECT(permsel), DELETE(permdel),INSERT(permins), and UPDATE(permupd) permissions to any table in the module address booke. OK I am sure by now you are asking "but how does this put the business logic in the database?" OK lets say we now want to be able to assign phone number to these contacts we can now add a couple more tables to allow for this.<br /><br /><div stlye="margin-left:auto;margin-right:auto;width:300px;background-color: #EEEEEE;border:1px solid #CCCCCC;"><br /><pre><br />group editors:<br /> description: Address Book Editors<br /> module addressbook:<br /> permsel: "Y"<br /> permdel: "Y"<br /> permins: "Y"<br /> permupd: "Y"<br />column favorite_food:<br /> type_id: vchar<br /> description: Favorite Food<br />table contacts:<br /> module: addressbook<br /> column name:<br /> primary_key:"Y"<br /> description: Name<br /> tooltip: Persons Name<br /> uisearch: "Y"<br /> column add1:<br /> primary_key: "Y"<br /> column add2:<br /> column city:<br /> column state:<br /> column zip9:<br /> column favorite_food:<br /><br />table phonetypes:<br /> module: addressbook<br /> column name:<br /> primary_key: "Y"<br /> uisearch: "Y"<br /> description: Phone Type<br /> tooltip: Phone type eg. Cell, Home, Work<br /><br />table contactnumbers:<br /> description: Contacts Phone Numbers<br /> foreign_key contacts:<br /> uisearch: "Y"<br /> primary_key: "Y"<br /> foreign_key phonetypes:<br /> primary_key: "Y"<br /> uisearch: "Y"<br /> column phone:<br /></pre><br /></div><br /><br />We've now added two tables(phonetypes & contactnumbers). The phonetypes table is extremely simple and allows us to add phone types such as Cell, Work, Home, etc...<br /><br />The contactnumbers table has foreign_keys to the two previous tables contacts & phonetypes and that will tell the system that the primary_key fields from those tables need to be included in this table and to also make the primary_keys for this table. Our CRUD screens we will also have a drop down list for the foreign_key entries and this is done again with 0 code. What these primary_keys do is restrict each contact to having one phone type for each contact. If you try to insert more than one phone number for each phone type for a given contact, whether it be through the CRUD screens or even the SQL command line you will get an error telling you that the record already exists. So you don't have to make sure the record exists before you try inserting it, its done for you...yes of course you can still do this just so that your application wont have a DB error thrown back but the benefit of this is you can <span style="font-weight: bold;">never</span> get more than one phone type for a given contact into the system.<br /><br />Now say for instance you wanted to have the number of phone number for each contact included in the contact record, you can have this done in the database for free with what <a href="http://www.andromeda-project.org">Andromeda</a> calls AUTOMATIONS. Here is how this is achieved:<br /><br /><div stlye="margin-left:auto;margin-right:auto;width:300px;background-color: #EEEEEE;border:1px solid #CCCCCC;"><br /><pre><br />column num_phones:<br /> type_id: int<br /> description: Number of Phone Numbers<br />table contacts:<br /> module: addressbook<br /> column name:<br /> primary_key:"Y"<br /> description: Name<br /> tooltip: Persons Name<br /> uisearch: "Y"<br /> column add1:<br /> primary_key: "Y"<br /> column add2:<br /> column city:<br /> column state:<br /> column zip9:<br /> column favorite_food:<br /> column num_phones:<br /> automation_id: COUNT<br /> auto_formula: contactnumbers.phone<br /></pre><br /></div><br /><br />Once again we've added another column definition(num_phones) and now you'll notice the automation_id property of COUNT and the auto_formula of contactnumbers.phone this tells <a href="http://www.andromeda-project.org/">Andromeda</a> to do a count of records in the contactnumbers table that reference this table as a parent table(foreign_key). This is only a tip of the iceberg when it comes to Andromeda. There are many other useful automations and features such as ranged primary keys and dominant records.<br /><br /><br />This entire article is my opinion and probably not that well organized but I highly suggest taking a look at this "Database Development System/Framework". My basic examples above do not even compare to what is possible with <a href="http://www.andromeda-project.org/">Andromeda</a>. It does sometimes take changing the way you approach certain things but in the end you will have <span style="text-decoration: line-through;">drank the coolaid</span> realized why you will never use another framework again.<br /><br />I would highly suggest <a href="http://sourceforge.net/mail/?group_id=188856">joining the mailing list</a> and sending an email if you think something cannot be approached in the way you like. I have found more than once that the way that I like isn't the best way.<br /><br /><div style="text-align: center;">**Comments are welcomed and appreciated, even if you don't agree**<br /></div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-7605248843356945257?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-16252906743234328492008-06-30T10:09:00.004-04:002008-07-01T09:54:54.259-04:00ExtJSI've been working with <a href="http://www.extjs.com/">ExtJS</a> lately, and I must say I am highly impressed. For those of you not familiar with ExtJS (Ext), Ext is a crossbrowser javascript framework that allows for the creation of RIA (Rich Internet Applications).<br /><br />Ext uses the latest and greatest web 2.0 methods, such as ajax, which has built in parsers for JSON, XML, text and possibly some other formats. Ext allows for the creation of desktop looking interfaces with just som simple notation(Ext is probably not the first project to do this)...this in my opinion is one of the greatest things Ext has to offer. The simple notation way of creating these interfaces allows for rapid deployment of interfaces, and takes the GUI creation out of the hands of the developer, and allows the developer to focus on getting the data to the front end.<br /><br />Alot of chatter has been generated in the past couple of months on the decision to change the licensing model. The most current version of Ext uses the GPL 3.0 model in my opinion it may have not been the greatest of choices for a license however it still allows you to create open source applications. And if you want to build an application that you will be selling for $ you can purchase a license which will ultimately help support the project and only make it better.<br /><br />There is one negative aspect to Ext, the documentation....yes all the information you need is there and they even give some basic code in the documentation however in <span style="font-style: italic;">my opinion</span> the examples of interfaces/widgets are all given in the notation format of creating objects however the examples in the docs all give examples of referencing things or adding eventlisteners via old sytle javascript. This i think determs alot of people, they do have a community support forums but that can also at times be discouraging, as it may take a couple of bumps to get a question answered.<br /><br />In my opinion the <a href="http://extjs.com/deploy/dev/docs/">Ext documentation</a> could take a lesson from the <a href="http://docs.php.net/manual/en/">PHP documentation</a> and add common examples in this notation style format, for the various things you may want to do with an object/widget/datastore.<br /><br />In the end Ext is a great product with a bright future and just needs to polish its documentation as well as it has its interface objects.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-1625290674323432849?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com10tag:blogger.com,1999:blog-5542840264156477606.post-12884224247808649012008-04-30T21:56:00.003-04:002008-05-02T14:11:37.032-04:00jQueryWell I've been using<a href="http://www.jquery.com"> jQuery</a> from quite some time now, and I must say they have a <u>great</u> product. It is a extremely easy to use as well as makes things such as alternating row colors in a table so easy, with two lines of code you can have alternating row colors on a table. The plugin support is great and pretty much anything you can think of you can find a plugin for.<br /><br />Andromeda is rocking along and from what I here from Ken there may be some news coming in the next couple of weeks or so.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-1288422424780864901?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-49731895520948320772008-02-21T20:52:00.002-05:002008-02-21T20:58:12.255-05:00Andromeda SVNWell now that Andromeda has had SVN support built in for about two weeks I must say it makes pushing updates from dev to staging <span style="font-weight:bold;text-decoration:underline;">ALOT</span> easier also has allowed for cooperative development of Andromeda even more possible.<br /><br />I would say keep your eye on the <a href="http://www.andromeda-project.org">Andromeda site</a> in the coming weeks for more exciting news.<br /><br />And for those of you who have yet to try it...just do it already!! It will change your world.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-4973189552094832077?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com2tag:blogger.com,1999:blog-5542840264156477606.post-30082091155376901212008-02-10T22:49:00.001-05:002008-08-08T17:02:34.944-04:00Busy WeekWell this past week has been extremely busy both @ work and after work with Andromeda. Which is funny because both are connected. The e-commerce project I have been working on for the past ~5 months now uses Andromeda, so a lot of the bugs, most in my custom code not so much Andromeda lately, that I find keep Ken a little busy.<br /><br />But besides that Ken has been busy this week getting SVN(subversion) working for upgrades of Andromeda, and also deploying Andromeda applications. We will hopefully be announcing the AndroPage feature this week, it is currently available in the most recent releases of this week we just haven't announced it. I am working on getting the LIPHP site wrapped up so we can get that out there.<br /><br />I have a couple of extra that I am going to work on this coming week for Andromeda which include report back features this way we can start to see how people are using Andromeda as well as where in the world people are using it.<br /><br />I can actually say that I finally have used a framework that I would use for anything. And it does try to separate the code into all sort of sections and folders, my worst experience with something like that was fusebox(Coldfusion) or Mach-II also coldfusion. Drupal and Joomla both have way too much stuff to sort through to find anything, and then when you have found it, you havent it's something that just has the title that you were looking for.<br /><br />Andromeda makes creating an application with logic easy, and even just a website is easy to throw together with Andromeda and is even easier since the introduction of AndroPages. I am going to also start working out my idea of creating a google chart plugin for AndroPage which will bring reports to the next level.<br /><br />Well that also for now, happy programming everyone.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-3008209115537690121?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-87290816449486457262008-01-30T12:15:00.000-05:002008-02-01T17:20:05.156-05:00Upcoming Andromeda FeatureAbout three weeks ago I was working on a project for work, that is using <a href="http://www.andromeda-project.org/">Andromeda</a> and for some reason got to thinking about reports. And I thought to myself why couldn't we use <a href="http://www.yaml.org/">YAML</a> to define reports. So I sent an email to <a href="http://database-programmer.blogspot.com/">Ken Downs</a> and suggested that we should get together and hash this idea out. So we got together about two weekends ago, and I presented this idea to him, and then showed him <a href="http://www.smarty.net/">Smarty</a> and showed him a couple of things that could be done with it.<br /><br />Basically the whole "concept" comes down to the following<br /><ul><li>We already have our tables defined in the application YAML file</li><li>A report is just how to display the data</li><li>Smarty Gives us a way to have some logic (Looping, Alternating Row Color)</li><li>WE just need a filter for the data to display (WHERE CLAUSE)<br /></li></ul>So over the course of the rest of the weekend Ken coded up the concept of an AndroPage, which literally passes off the data to a another class that handles either turning the data into a Report(PDF) or a page(Smarty). After he was done with that I put into place the code that loops through the sections, and assigned the row(s) to the appropriate Smarty Variables named after the section they are in.<br /><br />The definition of page looks like this:<br /><blockquote><pre>options:<br /> title: Reviews<br /><br />section review:<br /> onerow: "Y"<br /> table reviews:<br /> column name_book:<br /> compare: = @book<br /> column review:<br /> column ts_ins:<br /> column ts_upd:<br /> column uid_ins:<br /> column uid_upd:<br /><br />uifilter book:<br /> description: Book Title<br /> type_id: vchar<br /> colprec: 50<br /><br />template: p_review.tpl<br /></pre></blockquote><br /><span style="font-weight: bold;">options:</span> Allows us to set things such as page title.<br /><br /><span style="font-weight: bold;">section:</span> Allows us to litterally pull as much data as we want and place it in different sections around the page, such as maybe client information in one area and then ads pertaining to this clients industry in another area.<br /><br /><span style="font-weight: bold;">onerow:</span> Specified that we only expect one row back for this page(This is done so that we do not need a foreach loop in the smarty template)<br /><br /><span style="font-weight: bold;">table:</span> Refer to tables that are specified in the application YAML file. Multiple tables can be specified and Andromeda will attempt to join the tables based on primary_keys<br /><br /><span style="font-weight: bold;">column:</span> The columns to be used for display from the tables.<br /><br /><span style="font-weight: bold;">uifilter: </span>Tells Andromeda that we need to filter on something, and if its not specified display a page so the user can enter it.<br /><br /><span style="font-weight: bold;">template: </span>Tells Andromeda that this is a Smarty Page and to use the specified template.<br /><br />Each section get assigned to a Smarty variable with the same name, then you just have to create the Smarty template.<br /><br />An example of a Smarty template is this:<br /><blockquote><br /><pre>{* Smarty *}<br /><table border="0" cellpadding="0" cellspacing="0"><br /><tbody><br /> <tr><br /> <td><h3>{$review.name_book}</h3></td><br /> </tr><br /> <tr><br /> <td>Review:</td><br /> </tr><br /> <tr><br /> <td>{$review.review}</td><br /> </tr><br /> <tr><br /> <td>Reviewed by: {$review.uid_ins} on {$review.ts_ins}</td><br /> </tr><br /></tbody><br /></table><br /></pre></blockquote>There as still a couple of minor bugs which should be fixed shortly and then there will be a release.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-8729081644948645726?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com2tag:blogger.com,1999:blog-5542840264156477606.post-43471352227567311792008-01-24T21:03:00.000-05:002008-01-24T21:22:34.841-05:00Blog ChangeI have decided to go with Blogger instead of Drupal as there were too many options in Druapl and changing something took some digging. So now I am using blogger.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-4347135222756731179?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-6374416522986465162007-10-23T13:16:00.000-04:002008-01-24T21:01:08.620-05:00EngagedWell after three years of dating, Melissa and I are engaged. We left for a cruise on October 11th so I figured before the cruise I would give her a Carribean Pirate Treasure hunt. I made a map with two X's on it, one was the location of the treasure chest with the ring in it and the other was the location of the scroll with the combination to the small luggage lock i used to lock the chest.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-637441652298646516?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0tag:blogger.com,1999:blog-5542840264156477606.post-59811941663632899582007-08-06T18:55:00.000-04:002008-01-24T20:59:46.978-05:00First PostWell this is the first post on my new developer blog. I am looking to get more involved in open source projects, and maybe even some C based projects, as I do not really know C (haven't used it since school, and its use then was extremely basic), but would love to learn more. So if you have a C based project that you are working on and are looking for some help, I would be more than willing.<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5542840264156477606-5981194166363289958?l=blog.donaldorgan.com'/></div>Donald J Organ IVhttp://www.blogger.com/profile/14412453157119493777noreply@blogger.com0