Is there a way ?
Hi, I'm a little rusty in my SQL statements, and I'm not all that certain that this can be done. IF I have a field with the contents like: "http://beta.somedomain.com/url/url/url=2"; where 2 is the record ID value. And I need to change the contents of that field to read: "http://www.somedomain.com/url/url/url=2"; How would I accomplish this with a native SQL statement ? I was thinking that I'd just export the contents of the table, and do a text manipulation against the field, only to realize that the record id value is embedded in the link of the field. Which means that I can't change the record id value at all. Or turn off the auto increment of the keyfield because it will invalidate the records when its turned back on Any suggestions as to how I might clean this up Thanks. Miles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Odd Update Question.
Folks, Thanks for the 'help'. Oy. I figured it out from some help on the Lasso discussion list. All I had to do was properly address ALL the tables I wanted to touch. So this: UPDATE tbe_gallery SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND tbe_images.img_orig_filename = tbe_gsa.gsa_id Should have been This: UPDATE tbe_gallery, tbe_gsa, tbe_images SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND tbe_images.img_orig_filename = tbe_gsa.gsa_id And viola, it works! Miles.
Odd Update Question.
Hi, I'm wondering if the following can be done UPDATE tbe_gallery SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND tbe_images.img_orig_filename = tbe_gsa.gsa_id Let me explain: I have 3 tables and only 1 of them has the correct data which I need to update the other two. The SQL statement above is based upon the following select statement below: SELECT tbe_gsa.gsa_id, tbe_gallery.gallery_id, tbe_gallery.gallery_title, tbe_gallery.gallery_price, tbe_gsa.gsa_sin, tbe_gsa.gsa_paperprice, tbe_gsa.gsa_canvasprice FROM tbe_gsa INNER JOIN tbe_images ON tbe_gsa.gsa_id = tbe_images.img_orig_filename INNER JOIN tbe_gallery ON tbe_images.img_rel_id = tbe_gallery.gallery_id ORDER BY gsa_id ASC This statement works just fine. However the table tbe_gsa contains the necessary column tbe_gsa.gsa_paperprice which has a match field of gsa_id, which matches a field in the images table called tbe_images.img_orig_filename, and the images table contains a match field called tbe_images.img_rel_id, which matches a field in the gallery table called tbe_galery.gallery_id. So my question is how do use the corresponding match fields to update the necessary fields so that... be_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper Is my statement above anywhere close to what it should be Miles. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Self References & Indexes
Hi, Can anyone tell me if this is the correct syntax for a self reference & Index ? --> ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`) REFERENCES `RPI_CTYPE`(`RPI_CT_ID`); --> CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID); M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a lil sql help please.
Hi, I have the following Query and Im a lil lost on this one SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date, tbe_orders.order_piececount FROM tbe_orders The query produces the following results: +++ + order_id + order_date + order_piececount + +++ + oid1 + 2006-07-08 +1 + + oid1 + 2006-07-08 +2 + + oid1 + 2006-07-08 +3 + + oid5 + 2006-07-08 +7 + + oid5 + 2006-07-08 +1 + + oid4 + 2006-07-08 +1 + + oid4 + 2006-07-08 +2 + + oid4 + 2006-07-08 +1 + +++ This is actually right. However, ideally what I'm wanting is this: +++ + order_id + order_date + order_piececount + +++ + oid1 + 2006-07-08 +6 + + oid5 + 2006-07-08 +8 + + oid4 + 2006-07-08 +4 + +++ Note the order_piececount column. What do I need to do to my SQL statement to perform this action ? My guess that I need to perform a secondary query inside the statement to get the computed value of order_piececount. Anyone ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Movable Type + OSXServer + MySQL issues.
Hi, Im having a rather nasty time installing MT on my G5XServe. IM trying to use MySQL but Im getting a rather NASTY error Stock Install of MySQL that came with the G5. ++ Got an error: Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC (@INC contains: /Volumes/webserver/ ~shoreweddings.com/blog/extlib lib /System/Library/Perl/5.8.6/darwin- thread-multi-2level /System/Library/Perl/5.8.6 /Library/Perl/5.8.6/ darwin-thread-multi-2level /Library/Perl/5.8.6 /Library/Perl /Network/ Library/Perl/5.8.6/darwin-thread-multi-2level /Network/Library/Perl/ 5.8.6 /Network/Library/Perl /System/Library/Perl/Extras/5.8.6/darwin- thread-multi-2level /System/Library/Perl/Extras/5.8.6 /Library/Perl/ 5.8.1 .) at lib/MT/ObjectDriver/DBI.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI.pm line 10. Compilation failed in require at lib/MT/ObjectDriver/DBI/mysql.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI/mysql.pm line 10. Compilation failed in require at (eval 6) line 1. BEGIN failed--compilation aborted at (eval 6) line 1. ++ Anyone seen this before ? And how best to resolve it ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Combine Into One Query ????
Hi, Im wondering if there is a way to combine the following queries into ONE query, or at the very least fewer queries... (DATE) is today's date. SELECT DISTINCT ip_address FROM logfile WHERE site_id = x AND date_time LIKE (DATE) GROUP BY ip_address SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%WIN%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%WIN%" AND a_browser NOT LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%NETSCAPE%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%WINDOWS%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%NETSCAPE%" AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%FIREFOX%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%WINDOWS%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%FIREFOX%" AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%MSIE%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%WINDOWS%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%MSIE%" AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%SAFARI%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%SAFARI%" AND a_browser NOT LIKE "%FIREFOX%" AND a_browser NOT LIKE "%NETSCAPE%" AND a_browser NOT LIKE "%MSIE%" AND a_browser NOT LIKE "%MAC%" AND a_browser NOT LIKE "%WIN%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%SAFARI%" AND a_browser NOT LIKE "%FIREFOX%" AND a_browser NOT LIKE "%NETSCAPE%" AND a_browser NOT LIKE "%MSIE%" AND a_browser LIKE "%MAC%" AND a_browser LIKE "%MOZ%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%SAFARI%" AND a_browser NOT LIKE "%FIREFOX%" AND a_browser NOT LIKE "%NETSCAPE%" AND a_browser NOT LIKE "%MSIE%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%MOZ%" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Combine Into One Query ????
Hi, Im wondering if there is a way to combine the following queries into ONE query, or at the very least fewer queries... (DATE) is today's date. SELECT DISTINCT ip_address FROM logfile WHERE site_id = x AND date_time LIKE (DATE) GROUP BY ip_address SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%WIN%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%WIN%" AND a_browser NOT LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%NETSCAPE%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%WINDOWS%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%NETSCAPE%" AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%FIREFOX%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%WINDOWS%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%FIREFOX%" AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%MSIE%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%WINDOWS%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%MSIE%" AND a_browser LIKE "%MAC%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser LIKE "%SAFARI%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%SAFARI%" AND a_browser NOT LIKE "%FIREFOX%" AND a_browser NOT LIKE "%NETSCAPE%" AND a_browser NOT LIKE "%MSIE%" AND a_browser NOT LIKE "%MAC%" AND a_browser NOT LIKE "%WIN%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%SAFARI%" AND a_browser NOT LIKE "%FIREFOX%" AND a_browser NOT LIKE "%NETSCAPE%" AND a_browser NOT LIKE "%MSIE%" AND a_browser LIKE "%MAC%" AND a_browser LIKE "%MOZ%" SELECT a_browser FROM logfile WHERE site_id = x AND date_time LIKE (DATE) AND a_browser NOT LIKE "%SAFARI%" AND a_browser NOT LIKE "%FIREFOX%" AND a_browser NOT LIKE "%NETSCAPE%" AND a_browser NOT LIKE "%MSIE%" AND a_browser LIKE "%WIN%" AND a_browser LIKE "%MOZ%" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL HAVING statement ?
Rhino, Thanks for all the info. It was as simple as %% in the statement... DUH! I can't believe I missed that. Sorry to have bothered. Thanks anyway. M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL HAVING statement ?
Hi, Im having a bit of a problem with the following query: SELECT CONCAT(people2.First_Name, " ", people2.Last_Name) AS zNAME, events.name_short, events.date_start FROM people2 INNER JOIN event_people ON people2.ID = event_people.peopleID INNER JOIN events ON event_people.eventID = events.ID WHERE event_people.people_role = "FACULTY" HAVING zNAME LIKE "" ORDER BY events.date_start DESC Specifically, the HAVING statement Im trying to perform a search against the concatenated result of first_name/last_name and not getting very far. Can anyone point me in the right direction ??? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Inner Join & Search on Two (2) fields ?
Michael, My apologies for not formatting the request properly for readability. I was typing fast... THanks for the tip...I'll try it out Most Sincerely, M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Inner Join & Search on Two (2) fields ?
SELECT events.name_short, events.type, events.location, events.description, events.faculty, concat(people2.First_Name, people2.Last_Name) as zName, people2.roles FROM events INNER JOIN people2 ON events.faculty = people2.id WHERE people2.roles = "faculty" AND zName = "some name" Is this SELECT statement correct ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 'T 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... [link_firstgroup]FIRST[/link_firstgroup] [link_prevgroup]PREV[/link_prevgroup] [link_nextgroup]NEXT[/link_nextgroup] [link_lastgroup]LAST[/link_lastgroup] [/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 TIPS for MYSQL: 3.3 NEAR MAGICAL INLINES
- Hi and Welcome to - LASSO TIPS FOR NEWBIES: 3.3 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=154555 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: THE INLINE THAT CHANGED MY LIFE I'll never forget the afternoon that I web enabled my very first FileMakerPro db. The Lasso install took less than 2 minutes. Once installed it was just open the database, restart WebStar, then write my page and run it. I was skeptical at first because these other languages and scripts (tango, webfm, coldfusion) had to do x, y and z and what not...s complicated. But I pressed on and wrote 5 lines of code. An Inline, A records statement. A field tag. And then a closing records and inline tag. Then saved the document, and pulled the url & hit enter. I wasn't expecting anything after having tried and failing with Tango & WebFM I was to say the least, appathetic. The browser immediately returned my page to me. It was like the clouds parted. Magic! Just FIVE lines of code. 5 lines!!! There was my data! I was in awe. I sat there stunned for several minutes giddy at the thought of what I had just done. I then ran it over again...and kept looking at the code and was just stunned at what I had just done. It was just 5 lines, but its 5 lines that would change my life. The dreams of data avarice quickly began seeping into my lil Mileslike brain and I saw bigger and better things to do with my new found toy...errr 'skill'. I wanted to see what else it and I could doAnd my Life has never been the same since. PART ONE: THE BASIC INLINE. For those of you that have been living under a rock for the last 8 years, the real power of Lasso aside from its simplicity and ease of use, and its ace in the whole that sets it apart from other scripting languages is the INLINE: Your 'basic' inline consists of three parts. The tag (1), name value pairs (2), and commands (3): EX: [inline (1): -database='dbname', -table='tbname', -op='eq', 'fieldname'='somevalue' (2), -search (3)] We all use this basic structure on a daily basis in some form or another. In the 8 years that Ive been using Lasso this basic structure hasn't changed all that much. A quick review of an inline reveals that with it, you can invoke a query against a named datasource and its table/layout, add records to said datasource/ tables, display said values from said query, or update values already in said datasource/tables, and/or delete them. We all know this to be true. And this is Lasso's true power I believe, what you can do in a single inline, will take you 10 to 50 lines in any other languagebeat that with a stick PHP/.NET/COLDFUSION! ++ TO SEE THE REST OF THIS LASSO TIP ++ THE CURRENT LASSO TIP for MYSQL: http://www.listsearch.com/lassotalk.lasso?id=154859 THE LAST 5 LASSO TIPS for MYSQL: 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 LTƒM 2.8: SQL and Lasso (pt2) ->> http://www.listsearch.com/ lassotalk.lasso?id=149158 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]
LASSO TIPS for MYSQL: 3.2 IF I ONLY HAD A...
- Hi and Welcome to - LASSO TIPS FOR MYSQL: 3.2 The FIRST LASSO TIPS FOR MYSQL -> http://www.listsearch.com/lassotalk.lasso?id=143312 The LAST LASSO TIPS FOR MYSQL -> http://www.listsearch.com/lassotalk.lasso?id=154176 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 Secondly, My apologies for not getting this out on time yesterday...my servers suffered an outage...so consequently my collective hair has been in piles on the floor folks! And when your servers goo PF on a saturday night when you're deep in the middle of an email 'discourse' of questionable nature, that's probably a good sign to stop! I digress. However all is well and my servers are back online. And soon to get a major upgrade. I'll be in MASSACHUSETTS the week of NOV 1st - 7th (2005). Ive got a number of clients and appointments but if anyone wants to get together for a lil chat/wrap/coding session ping me. Thirdly, Many people have asked me to write a book, I'll tell you straight up, Im not in the market to write a book, that's Duncan Cameron's area, not mine. However, if you're in the market for a tiny lil PDF with a few tips that haven't been published here and there and something with a few more examples, methodologies and practices, please by all means let me see a show of hands (digitally speaking). Perhaps I'll have something ready by summit time. Just in time for my class on Lasso for Newbies. http:// 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, Consultin' with the rain. And my head, I'd be scratchin', While my thoughts were busy hatchin', If I only had a brain." - From "IF I only had a brain" - Wizard of OZ, circa 1933. While I'd love to sit here and yap about the scarecrow, the tin man or the cowardly lion, and that fine hottie Dorothy, somehow or another I think your head you'd be scratchin' while your thoughts were busy hatchin', "Has the boy gone crazzah!!" Well no I haven't gone crazy but I am on to somethin' here. The IF proposition. The conditional. You don't think about it until you actually need it, and then you begin to wonder well how the hell do I use it ? More over WHY and WHERE do you use it ? Hence this week's lil foray into the seemingly mundane...the ALMIGHTY, ALL PURPOSE, '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 simple language, the IF is a method to branch your logic into a situation to cover a particular scenario or likelihood that a user may experience while using your application. To use the word, to define the word is a bad habit and doens't really help but in this case, I think it does: "what if..." That's the premise of the conditional IF statement, what if this or that happens. With Lasso there are several different kinds of conditional statements, the IF is only one of them, however it is the most ubiquitous. For the purposes of this article we're focusing solely on the IF statement. Why ? Because as you'll see, in its simplicity it is not only exceptionally powerful, and useful but its come a long way in what can be done with itso without further adieu, may I introduce to 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=154555 THE LAST 5 LASSO TIPS for MYSQL: LTƒM 3.1: Three Lil Toys ->> http://www.listsearch.com/ lassotalk.lasso?id=154176 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 LTƒM 2.8: SQL and Lasso (pt2) ->> http://www.listsearch.com/ lassotalk.lasso?id=149158 LTƒM 2.7: SQL and Lasso (pt1) ->> http://www.listsearch.com/ lassotalk.lasso?id=148892 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LASSO TIPS for MYSQL: 3.1 THREE LIL TOYS
- Hi and Welcome to - LASSO TIPS FOR MYSQL: 3.0 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=153613 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 Secondly, Chickens DO come home to roost. Eventually. There will be a LASSO SUMMIT!!! Yes that's right kiddies, its time to break out the champagne and get your groove on with others of our kind, your Lasso Brethren. Praise be to all things Lasso. The dates Feb 17 - 19th 2006, in Ft. Lauderdale, FL. By now you've seen the 'official' announcement, so this is nothing new, but those of who haven't, go here: http://www.lassosummit.com/ Grok to your hearts content. Word is that I, your magicmilesness, will be hosting a roundtable or two. Thirdly, I will conducting newbie training for Lasso, on the 2 days before Lasso Summit. If you've enjoyed Lasso Tips for Newbies, then the time is at hand to get it from the original Lasso Evangelist himself...ME. Dates: Feb 16 - 17, two FULL days of Lasso Training for the Neophyte (the unwashed masses). More details and the official announcement later on this week, but let's keep this just between you and I for the moment (and 10,000 of our closest friends). Seating will be limited. TODAYS TIP: T h r e e L i l T o y s Today's tip is actually 3 tiny tips that have been buggin me for months that I frequently see others not taking advantage of, that you can USE today. No if's, and's, or but's about it. So without further adieuon with the tips. PART ONE: ITERATION is the KEY! From time to time you will run across the need to pull values out of a variable and reorder them as you see fit. OR just get the values out and use them as you see fit. There are several ways to do this with Lasso, however none more powerful than the ITERATE tag. Some of you have seen this tag before and probably thought to yourselves that it looks just a tad scary, and you know what, you'd be right. It is. Its just downright intimidating! Coming from a newbie standpoint, it is. However as with all things, it just needs lil light shed on it to give it a lil clarity, so that perhaps you won't shy away from the thing the next time you run across the need to use it. In its basic form an [iterate] tag is very similar to a [loop] or [while] statement. They all do the same things, sort of. Except that a LOOP or WHILE statement doesn't actually allow you to use itself as the comparitor statement, or in simpler parlance, to compare itself against itself! A loop will continue running a series of operations to a certain number; a WHILE will continue doing the same thing while a certain condition is true; but an ITERATE statement, an iterate statement will go several steps further than either and allow you to stop and examine the values that you feed it and change it in process! And that my Lasso Brethren is where the rubber hits the road and why this lil toy is S amazingly powerful. ++ TO SEE THE REST OF THIS LASSO TIP ++ THE CURRENT LASSO TIP for MYSQL: http://www.listsearch.com/lassotalk.lasso?id=154176 THE LAST 5 LASSO TIPS for MYSQL: 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 LTƒM 2.8: SQL and Lasso (pt2) ->> http://www.listsearch.com/ lassotalk.lasso?id=149158 LTƒM 2.7: SQL and Lasso (pt1) ->> http://www.listsearch.com/ lassotalk.lasso?id=148892 LTƒM 2.6: LASSO STUDIO for ECLIPSE PT 2. ->> http:// www.listsearch.com/lassotalk.lasso?id=148569 LTƒM 2.5: LASSO STUDIO for ECLIPSE PT 1. ->> http:// www.listsearch.com/lassotalk.lasso?id=148197 Spreadin' The Lasso Gospel! 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
LASSO TIPS for MYSQL: 3.0 THE LASSO APP
- Hi and Welcome to - LASSO TIPS FOR MYSQL: 3.0 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=153613 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: T h e L a s s o A p p So there you are, code all done, functions working perfectly, and all done several days ahead of schedule. When the phone rings and its another developer friend who tells you that he just got ripped off. His client just up and disappeared with the code he'd spent weeks working on, weeks. Some of his best work, and he's got nothing to show for it, absolutely NOTHING! He's worried about paying the rent, and you being the kind soul that you are, offer to help him out a bit till things get better. You hang up the phone and begin to wonder...while the app that you just finished is not your best work, it is very clean, very stable and will make your client very happy. You wonder will your client pay you or skip town with the goods never to be heard from again ? This is a new client and you've only done one small project with this client before...a few pages, after another developer just 'mysteriously' disappeared on the client - so the client says. He was a lil late in paying you the last time and this time around while he dropped a good amount upfront, he's been rather silent of late. You start to worry, "Is this guy for real ?". You have a solid development contract, but as a favorite character of yours points out in response to a similar question, "INK on the PAGE!". Which is to say that your friend pointed this out to you as well and look where THAT got him. You being the resourceful lil Lasso Developer, you ask the all important question, "Does Lasso have anything that could protect my code ?". In the all too real scenario above of the digital age where clients come and go like the wind, which Ive had happen a few times over my career, there was up until Lasso 5 no way to protect your code from at the very least being modified. Enter the LassoApp. ++ TO SEE THE REST OF THIS LASSO TIP ++ THE CURRENT LASSO TIP for MYSQL: http://www.listsearch.com/lassotalk.lasso?id=153881 THE LAST 5 LASSO TIPS for MYSQL: LTƒM 2.9: The Login Routine ->> http://www.listsearch.com/ lassotalk.lasso?id=153613 LTƒM 2.8: SQL and Lasso (pt2) ->> http://www.listsearch.com/ lassotalk.lasso?id=149158 LTƒM 2.7: SQL and Lasso (pt1) ->> http://www.listsearch.com/ lassotalk.lasso?id=148892 LTƒM 2.6: LASSO STUDIO for ECLIPSE PT 2. ->> http:// www.listsearch.com/lassotalk.lasso?id=148569 LTƒM 2.5: LASSO STUDIO for ECLIPSE PT 1. ->> http:// www.listsearch.com/lassotalk.lasso?id=148197 M i l e s. BRINGING THE LASSO LIGHT TO THE UNWASHED MASSES -don't know what lasso is ? - http://www.omnipilot.com/ M i l e s [EMAIL PROTECTED] MagicMiles Software (415) 686 - 6164 http://www.lassoevangelist.com/ AIM/Yahoo/MSN: magikmiles "The strangeness of this life can not be measured, in trying to produce my own death, I was elevated to the status of a living hero." - Lt. John J. Dunbar. - 'Dances With Wolves' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LASSO TIPS for MySQL: 2.9 THE LOGIN ROUTINE
- Hi and Welcome to - LASSO TIPS FOR MYSQL: 2.9 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 MYSQL -> http://www.listsearch.com/lassotalk.lasso?id=143312 The LAST LASSO TIPS FOR MYSQL -> http://www.listsearch.com/lassotalk.lasso?id=149158 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/index.html?section=Products%2fLasso% 2fResources%20for%20Beginners TODAYS TIP: The Login Routine Today's tip has a lot of information in it, and if you've been reading my posts over the last few weeks/months while Ive been on hiatus on the Lasso list you've seen me make the same post over and over againthe Login Routine! Because there's a lot of information to convey in today's tip, I'll try to keep the chit-chat short. However let me point out from the start that my solution to a LOGIN routine is NOT everyone's solution, it just happens to be my methodology to it. I have spent the better portion of 5 years working out this routine, and over the last year heavily writing it and rewriting it getting it to a point of stable functionality, which is the goal of any good developer - get it to work, get it to work correctly - you get paid. Now if only Doctors and Lawyers worked that way. Its still not perfect but it does work and it works well. My solution entails the use of SESSIONS, so if you haven't used sessions, you will now and you'll thank me for it later. Also this solution does not take into account being MULTIUSER aware, meaning types of users. For that, you'd have to rewrite this logic, completely. I know...Ive done it. With multiple login types you will need to rewrite the better portion of the validation and session logic. And this solution doesn't take that into consideration, but the roots of it are there...my current solution (which you're about to see) was actually stripped of this functionality so that you could see the basics. PART ONE: Login! Vee Don't Need NO Stinkin' Login! Like hell you don't. Nearly ever data driven website on the internet today has some kind of login routine that it requires in order to garner from the user who they are, what their user preferences are (or could be), and then redirect that user to their specific record or series of records that pertain to them and them alone. Because you don't want an end user to see anyone else's data, you want them to see ONLY their information...you have to provide some level of security, or at least make it appear as such. Let me say from the outset that this solution is database independent. Meaning you can use FileMaker for this, if you want, however you'd be better off with a SQL solution across the board for a variety of reasons, not the least of which is (separately) speed and security. ++ TO SEE THE REST OF THIS LASSO TIP ++ THE CURRENT LASSO TIP for MYSQL: http://www.listsearch.com/lassotalk.lasso?id=153613 THE LAST 5 LASSO TIPS for MYSQL: LTƒF 2.8: SQL and Lasso (pt2) ->> http://www.listsearch.com/ lassotalk.lasso?id=149158 LTƒF 2.7: SQL and Lasso (pt1) ->> http://www.listsearch.com/ lassotalk.lasso?id=148892 LTƒF 2.6: LASSO STUDIO for ECLIPSE PT 2. ->> http:// www.listsearch.com/lassotalk.lasso?id=148569 LTƒF 2.5: LASSO STUDIO for ECLIPSE PT 1. ->> http:// www.listsearch.com/lassotalk.lasso?id=148197 LTƒF 2.4: TEN WASCAWY TIDBITS ->> http://www.listsearch.com/ lassotalk.lasso?id=147152 M i l e s. ––– LASSO EVANGELIST FOR HIRE: GREAT RATES –– NEEDS WORK ––– -don't know what lasso is ? - http://www.omnipilot.com/ M i l e s [EMAIL PROTECTED] MagicMiles Software (415) 686 - 6164 http://www.lassoevangelist.com/ AIM/Yahoo/MSN: magikmiles Creating custom content management systems for yoga, dance, healing arts, & now real estate starting at just $65.00 a month, incld: domain registration, web hosting, email and webmail, and access to TOOLBOXENGINE! A very robust tool. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL help: Updating Strange Chrs.
Hi, I have an odd situation where I was handed just bad data, and while I have cleaned it up to the best of my ability one hurdle remains. I have a situation where I have the following example in a field: Canna ÒBengalÒ. Note the odd chrs "Ò" in the field ? I need to get rid of those, my question is HOW. And I have thousands of rows like this and its just ONE field that's the stumbling block. Any suggestions ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: renaming indexes
Jason, The only way that I can think to do this is the change its status as a primary key field... Once you do that, you can rename the field, and then reinitiate it as a primary keyfield. M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table Collation ?
Hi, Ive noticed that my ALL my databases and tables have "latin1_swedish_ci" as the collation...h that wouldn't be so bad except that I didn't set it that way by default, and I don't speak swedish. Not that swedish isn't a fine language, or sweden isn't a fine country (although Ive never been there) so I hear. However, that's NOT what I want. 1.) What should the db collation be set to if I am in the USA -> latin_1_bin ? 2.) and would doing so cause a problem that anyone can think of ? Thanks. I'm running 4.1.12 on OS X.4.2. Thanks. M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade from 4.018 to 4.1.13 ?
Hi, I have a silly questionDUH Im running OS X Server, I installed 4.018 and I want to run 4.1.13, how do I upgrade the server, without losing anything ? Do I just install over it ? Of course backing up all the tables and what not first ? Any pointers would be helpful. Thanks. M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query HELP!
Shawn, Took me a bit to digest what you were sayin but if I get it the way you splain'd it then the following should work: ++ SELECT cmc_search_members.PropertyName AS pNAME, cmc_search_members.PropertyEmail AS pEMAIL, cmc_user_count.user_id, MAX(cmc_user_count.date_time) AS pDATE, COUNT(cmc_user_count.user_id) AS pHITS FROM cmc_search_members INNER JOIN cmc_user_count ON cmc_search_members.Property_ID = cmc_user_count.user_id GROUP BY pNAME, pEMAIL ORDER BY pDATE DESC ++ If I want a NON-CUMULATIVE result, ie: pNAME + pHITS + pDATE --- fillmore+ 198 + 08/08/2005 mannor inn + 56+ 08/08/2005 seacrest+ 23+ 08/08/2005 --- fillmore+ 102 + 08/07/2005 mannor inn + 89+ 08/07/2005 seacrest+ 19+ 08/07/2005 etc. Then Im assuming the statement above will NOT produce this result ? What'd be great is if I could get that in Alphabetical order as well...I tried adding a ORDER BY pDATE DESC, pNAME ASC but DESC doesn't help. Which is what I was lookin for. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query HELP!
Hi, IS the following query counting cumulative (see below **) pHITS or is it counting individual counts for each user for a particular day. Im not skilled enough to answer this question myself. My instinct says that its counting cumulative values and NOT individual counts for each property name. SELECT search_members.Property_Name AS pNAME, search_members.Property_Email AS pEMAIL, MAX(user_count.u_datetime) AS pDATE, **COUNT(user_count.u_userid) AS pHITS FROM search_members INNER JOIN user_count ON search_members.Property_ID = user_count.u_userid GROUP BY pNAME, pEMAIL, search_members.Property_ID ORDER BY pDATE DESC I have a feeling that the COUNT line should be something similar to select distinct statement Any ideas ? Sincerely, M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.0 -> 4.1 update killed my db!
Hi, I updated my 4.0 install to 4.1 and now NONE of my databases and tables show up at all. Im on OS X.3.9. All the files are there in the data folder, permissions are set, what did I do wrong ? Any suggestions as to how to get it back ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT, but real: Hoax or legit
Hi, >I received the same. I concluded from the typos that the message is a hoax. I got two more today. And yeah I believe its a hoax. Of course the only way that we'd be sure is if said list manager were to pipe up here and state that with certainty. My guess is that its a harvester address thats on the list and thereby sending these msgs to anyone that's posted to the list, quite ingenious really. M i l e s +++ President & Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.magicmiles.com/ [EMAIL PROTECTED] aim/yahoo/msn: magikmiles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie: Transitioning from MS Access to MYSQL
Rodney, Did you EVER get a response to your question ? Im keenly interested to know the answer. M i l e s +++ President & Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.magicmiles.com/ [EMAIL PROTECTED] aim/yahoo/msn: magikmiles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Spamcease ?
Hi, I got them too. A few days ago. I bounced the msg to spamcop directly. No matter... If I were a bettin man, and Ive been known to partake from time to time...I'd guess that there is a harvester address in the list. That would be one guess. M i l e s +++ President & Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.magicmiles.com/ [EMAIL PROTECTED] aim/yahoo/msn: magikmiles -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Another: LOAD DATA INFILE error.
Hi, I have the following sql statement: LOAD DATA INFILE '/Babylon5/Library/WebServer/Documents/~milesfiles.com/ eims_errorlog.txt' INTO TABLE eims_log FIELDS TERMINATED BY ' ' ENCLOSED BY ' ' LINES TERMINATED by '\r' I can't seem to get it to run. The path is correct but I keep getting the error: "can't get stat of '/Babylon5/Library/WebServer/Documents/~milesfiles.com/ eims_errorlog.txt' " What am I doing wrong ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL + QuickBooks + OS X ?
Does anyone know of a way for all three fo these to talk to one another ? -- M i l e s President & Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.servicetoolbox.com/ http://www.workshoptoolbox.com/ http://www.healingartstoolbox.com/ http://www.artshoptoolbox.com/ We create content management systems for the rest of us, starting at $25.00 a month, includes domain registration, web hosting, email and webmail. Great for Yoga Teachers, Massage Therapists, Lawyers, Doctors, and any professional! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL users.
Hi Im a more than a lil confused about how to set up multiple users for EXTERNAL access to MySQL. Ive granted permissions to the Local user, but how to I grant permissions to external users ? Sincerely, -- M i l e s President & Toolbox Architect MagicMiles Software (413) 374 - 5161 PO Box 414, Northampton, MA 01060 http://www.servicetoolbox.com/ http://www.workshoptoolbox.com/ http://www.healingartstoolbox.com/ http://www.artshoptoolbox.com/ We create content management systems for the rest of us, starting at $25.00 a month, includes domain registration, web hosting, email and webmail. Great for Yoga Teachers, Massage Therapists, Lawyers, Doctors, and any professional! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]