From: m i l e s Date: October 18 2005 5:00pm Subject: LASSO TIPS for MYSQL: 3.2 IF I ONLY HAD A... List-Archive: http://lists.mysql.com/mysql/190532 Message-Id: <98F5EB66-71E5-4FD7-8F8C-07858FC1B50D@gmail.com> MIME-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Content-Transfer-Encoding: quoted-printable - Hi and Welcome to - ++++++++++++++++++++++++++++++++ LASSO TIPS FOR MYSQL: 3.2 ++++++++++++++++++++++++++++++++ The FIRST LASSO TIPS FOR MYSQL -> http://www.listsearch.com/lassotalk.lasso?id=3D143312 The LAST LASSO TIPS FOR MYSQL -> http://www.listsearch.com/lassotalk.lasso?id=3D154176 10 LASSO RESOURCES -> http://www.listsearch.com/lassotalk.lasso?id=3D143018 THE LASSO RESOURCES ADDENDUM -> http://www.listsearch.com/lassotalk.lasso?id=3D143417 OMNIPILOT RESOURCE LIST -> http://www.omnipilot.com/Resources+for+Beginners.2225.lasso http://www.omnipilot.com/Tip+of+the+Week.1768.lasso http://www.omnipilot.com/Hosting+Providers.1744.lasso http://www.omnipilot.com/Frequently+Asked+Questions.1791.lasso Secondly, My apologies for not getting this out on time =20 yesterday...my servers suffered an outage...so consequently my =20 collective hair has been in piles on the floor folks! And when your =20 servers goo POOOOF on a saturday night when you're deep in the middle =20= of an email 'discourse' of questionable nature, that's probably a =20 good sign to stop! I digress. However all is well and my servers =20 are back online. And soon to get a major upgrade. I'll be in =20 MASSACHUSETTS the week of NOV 1st - 7th (2005). Ive got a number of =20 clients and appointments but if anyone wants to get together for a =20 lil chat/wrap/coding session ping me. Thirdly, Many people have asked me to write a book, I'll tell you =20 straight up, Im not in the market to write a book, that's Duncan =20 Cameron's area, not mine. However, if you're in the market for a =20 tiny lil PDF with a few tips that haven't been published here and =20 there and something with a few more examples, methodologies and =20 practices, please by all means let me see a show of hands (digitally =20 speaking). Perhaps I'll have something ready by summit time. Just =20 in time for my class on Lasso for Newbies. http://=20 www.lassosummit.com/ Feb 17 - 19th, 2006! ++++++++++++++++++++++++++++++++ TODAYS TIP: IF IF IF IF IF IF IF ONLY... ++++++++++++++++++++++++++++++++ "I could while away the hours. Conferrin' with the flowers, =20 Consultin' with the rain. And my head, I'd be scratchin', While my =20 thoughts were busy hatchin', If I only had a brain." - =46rom "IF I =20 only had a brain" - Wizard of OZ, circa 1933. While I'd love to sit here and yap about the scarecrow, the tin man =20 or the cowardly lion, and that fine hottie Dorothy, somehow or =20 another I think your head you'd be scratchin' while your thoughts =20 were busy hatchin', "Has the boy gone crazzah!????!" Well no I =20 haven't gone crazy but I am on to somethin' here. The IF =20 proposition. The conditional. You don't think about it until you =20 actually need it, and then you begin to wonder well how the hell do I =20= use it ? More over WHY and WHERE do you use it ? Hence this week's =20 lil foray into the seemingly mundane...the ALMIGHTY, ALL PURPOSE, =20 'IF' CONDITIONAL! PART ONE: THE IF ANDS & BUTS of IT ALL. The vaunted IF. What is it and why do you use it ? In short =20 simple language, the IF is a method to branch your logic into a =20 situation to cover a particular scenario or likelihood that a user =20 may experience while using your application. To use the word, to =20 define the word is a bad habit and doens't really help but in this =20 case, I think it does: "what if..." That's the premise of the =20 conditional IF statement, what if this or that happens. With Lasso =20 there are several different kinds of conditional statements, the IF =20 is only one of them, however it is the most ubiquitous. For the =20 purposes of this article we're focusing solely on the IF statement. =20 Why ? Because as you'll see, in its simplicity it is not only =20 exceptionally powerful, and useful but its come a long way in what =20 can be done with it....so without further adieu, may I introduce to =20 you the star of today's game, (a drum roll please....) the IF statement! ++++++++++++++++++++++++++++++++++++++ TO SEE THE REST OF THIS LASSO TIP ++++++++++++++++++++++++++++++++++++++ THE CURRENT LASSO TIP for MYSQL: http://www.listsearch.com/lassotalk.lasso?id=3D154555 THE LAST 5 LASSO TIPS for MYSQL: LT=83M 3.1: Three Lil Toys ->> http://www.listsearch.com/=20 lassotalk.lasso?id=3D154176 LT=83M 3.0: The Lasso App ->> http://www.listsearch.com/=20 lassotalk.lasso?id=3D153881 LT=83M 2.9: The Login Routine ->> http://www.listsearch.com/=20 lassotalk.lasso?id=3D153613 LT=83M 2.8: SQL and Lasso (pt2) ->> http://www.listsearch.com/=20 lassotalk.lasso?id=3D149158 LT=83M 2.7: SQL and Lasso (pt1) ->> http://www.listsearch.com/=20 lassotalk.lasso?id=3D148892