- 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]
