Yes! Please stop spamming us; we would signup for a Lasso list if we cared to get these tips not a MySQL list.
John A. McCaskey Software Development Engineer Klir Technologies, Inc. [EMAIL PROTECTED] 206.902.2027 -----Original Message----- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, October 31, 2005 3:31 PM To: m i l e s; MySQL Subject: RE: LASSO TIPS for MYSQL: 3.4 ROLL YOUR OWN Hi, I'm not really interested in Lasso and can't see why I am receiving your emails. Could you please take the entire list off your mailing list? Thanks and Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: m i l e s [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 November 2005 9:58 AM To: MySQL Subject: LASSO TIPS for MYSQL: 3.4 ROLL YOUR OWN - Hi and Welcome to - ++++++++++++++++++++++++++++++++ LASSO TIPS FOR MYSQL: 3.4 ++++++++++++++++++++++++++++++++ I'm your host, M i l e s. First and foremost, a good place for you to start with Lasso is the following 5 things: The FIRST LASSO TIPS FOR NEWBIES -> http://www.listsearch.com/lassotalk.lasso?id=143312 The LAST LASSO TIPS FOR NEWBIES -> http://www.listsearch.com/lassotalk.lasso?id=154859 10 LASSO RESOURCES -> http://www.listsearch.com/lassotalk.lasso?id=143018 THE LASSO RESOURCES ADDENDUM -> http://www.listsearch.com/lassotalk.lasso?id=143417 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 ++++++++++++++++++++++++++++++++ TODAYS TIP: ROLL YOUR OWN LINKS! ++++++++++++++++++++++++++++++++ Last week I got a call from (what I thought was) a new client asking me to take a look at a Lasso 3 site that they've had online since before time was time, wanting an estimate of just what it would take to upgrade this site to LP8, and to MySQL (as they were dumping FMP as a backend, 'TOOOO SLOW!', their words not mine). They sent me the site, and as I went through the pages, flashes of rememberence came through first in bits and pieces, then as I got to one page, BAM! It was here that I unearthed my own comments I'd written 5 years ago! I had developed this site for a 3rd party but was never told who the end client was, now I knew. Going through the site I came across a page that I had spent a LONG time on. It was a way to display a series of links dynamically outside an inline. I remember that I couldn't do what I really wanted to do, which was google style links, but I did find a 'work around' to doing what could not be done at the time with some really fancy inlines, lists (the forerunner of today's arrays), and few well placed token values. Looking at the code and now having LP8 in my back pocket I could now do what I really wanted to do (and the client actually requested in their spec document). And that's where today's article comes from, that and the following quote (courtesy of OmniPilot's own Fletcher Sandbeck): The [Link_...] tags only work with the -Search or -FindAll actions. The links don't show up for -SQL actions. The workaround is to create your own link tags by checking the found count and calculating your desired -SkipRecords value manually. So today Im going to show you a method to rolling your own links! PART ONE: ROLLING ON A RIVER The act of creating a series of dynamically generated links is not an easy task, or has the viewpoint of not being that easy to create. However it can be done. But before we get there let's take a gander at the LINK_ tag series. This series of tags (and all the link_ series for that matter), all require being inside an inline container in order to produce results. Like so: [inline: -database='mydb', -table='mytb', 'somefield'='searchvalue', -skiprecords=(skiprecords_value), -search] etc...some HTML... <td>[link_firstgroup]FIRST[/link_firstgroup]</td> <td>[link_prevgroup]PREV[/link_prevgroup]</td> <td>[link_nextgroup]NEXT[/link_nextgroup]</td> <td>[link_lastgroup]LAST[/link_lastgroup]</td> [/inline] This series of tags makes it the act of creating links to the rest of your search results really simple and not only that these tags have a series of subtags that makes them secure to use, so that you don't display your parameters via the URL. If you run the LINK_XXX tags above without the subtags, you'll end up with something like this: http://yourdomain.com/page.lasso?-Search=Action&-Table=mytb&- MaxRecords=10&-SkipRecords=10&-Database=mydb&-KeyField=id_key&- SortField=somefield&-SortOrder=ascending&anotherfield=somevalue ++++++++++++++++++++++++++++++++++++++ TO SEE THE REST OF THIS LASSO TIP ++++++++++++++++++++++++++++++++++++++ THE CURRENT LASSO TIP for MYSQL: http://www.listsearch.com/lassotalk.lasso?id=155180 THE LAST 5 LASSO TIPS for MYSQL: LTƒM 3.3: Near Magical Inlines ->> http://www.listsearch.com/ lassotalk.lasso?id=154859 LTƒM 3.2: If I Only Had A ->> http://www.listsearch.com/ lassotalk.lasso?id=154176 LTƒM 3.1: Three Lil Toys ->> http://www.listsearch.com/ lassotalk.lasso?id=154555 LTƒM 3.0: The Lasso App ->> http://www.listsearch.com/ lassotalk.lasso?id=153881 LTƒM 2.9: The Login Routine ->> http://www.listsearch.com/ lassotalk.lasso?id=153613 M i l e s $LASSO->MYSQL CONSULTANT & EVANGELIST FOR HIRE -don't know what 'LASSO' is ? - http://www.omnipilot.com/ ------------------------------------------------------------ M i l e s [EMAIL PROTECTED] Featuring: ToolboxEngine - A Custom CMS (415) 686 - 6164 http://www.lassoconsultant.com/ AIM/Yahoo/MSN: magikmiles ------------------------------------------------------------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]