Is there a way ?

2009-08-16 Thread m i l e s 

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.

2008-02-29 Thread m i l e s 
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.

2008-02-27 Thread m i l e s 

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

2006-10-03 Thread m i l e s 

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.

2006-07-09 Thread m i l e s 

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.

2006-03-03 Thread m i l e s 

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

2006-01-06 Thread m i l e s 

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

2006-01-06 Thread m i l e s 

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]

SQL HAVING statement ?

2005-11-26 Thread m i l e s 

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: SQL HAVING statement ?

2005-11-26 Thread m i l e s 

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]

Inner Join Search on Two (2) fields ?

2005-11-19 Thread m i l e s 
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]

Re: Inner Join Search on Two (2) fields ?

2005-11-19 Thread m i l e s 

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]

LASSO TIPS for MYSQL: 3.4 ROLL YOUR OWN

2005-10-31 Thread m i l e s 

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

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=ascendinganotherfield=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

LASSO TIPS for MYSQL: 3.3 NEAR MAGICAL INLINES

2005-10-24 Thread m i l e s 

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

2005-10-18 Thread m i l e s 

   - 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

2005-10-10 Thread m i l e s 

   - 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  [EMAIL PROTECTED]
ToolboxEngine  - Custom CMS for everyone(415) 686 - 6164
http://www.lassoconsultant.com/   AIM/Yahoo/MSN:  magikmiles

LASSO TIPS for MYSQL: 3.0 THE LASSO APP

2005-10-03 Thread m i l e s 

   - 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

2005-09-26 Thread m i l e s 

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

2005-09-22 Thread m i l e s 

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

2005-09-06 Thread m i l e s 

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 ?

2005-08-30 Thread m i l e s 

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 ?

2005-08-09 Thread m i l e s 

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]

Query HELP!

2005-08-08 Thread m i l e s 


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]

Re: Query HELP!

2005-08-08 Thread m i l e s 

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]

4.0 - 4.1 update killed my db!

2005-04-21 Thread m i l e s 
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

2004-07-28 Thread m i l e s 
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: Spamcease ?

2004-07-27 Thread m i l e s 
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]

Re: Newbie: Transitioning from MS Access to MYSQL

2004-07-27 Thread m i l e s 
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]

Another: LOAD DATA INFILE error.

2004-07-22 Thread m i l e s 
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 ?

2004-01-03 Thread m i l e s 
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.

2003-11-28 Thread m i l e s 
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]