Re: Keyword Search
It would probably be better to post this to the Lasso discussion list at Blueworld.com as for Lasso, this will require you to use tags but it's been ages since I coded with Lasso (3.6 and FileMaker. :) and I can't recall/never knew, the tag modifications. Good luck --- maggie chloe [EMAIL PROTECTED] wrote: I am new to Lasso and My SQL, but I have a pretty basic question on searching a text field using Keywords. I think I am missing something easy. I have a MySql database and am using Lasso 7. The user enters search information on a form on a search.lasso page and an inline search is then run on a results.lasso page. I want to parse out what the user enters and search the text field and retrieve only those records that contain each word of the search. For example: Where field is 'NAME' Record 1 contains 'John Michael Smith' Record 2 contain 'John Adams' Record 3 conains 'John Smith' Record 4 contains 'Michael Smith' If the user searches the field by typing 'John Smith' his found set should contain Record 1 and Record 3 only. How do I accomplish this? This is the inline that I'm using. [Inline:(Action_Params),-Search,-database='DATABASE',- Layout='CONTACTS',-Operator='ft','NAME'=(Action_Param:'NAME')] Thanks for your help, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Finding duplicate values in a column
This seems like it should be easy, and I'd be happy for a simple reference to where in the manual or in Paul's book I can find the answer. I am wanting to find basically the inverse of a SELECT DISTINCT operation. I have a table with a column labled date_created. I know that some records (about 30) were created at the exact same time (to the second) as another record. I would like to find the records that have a date_created value equal to another record. Is this possible in 3.23.54? Thanks in advance = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Finding duplicate values in a column
No worries mate, that is exactly what I need, and the number I've got are 32 and when I subtract the ones more than a year old I've less than 10. I can do the legwork. :) Thanks. --- Mike Johnson [EMAIL PROTECTED] wrote: From: Mike Johnson From: Robert Reed [mailto:[EMAIL PROTECTED] This seems like it should be easy, and I'd be happy for a simple reference to where in the manual or in Paul's book I can find the answer. I am wanting to find basically the inverse of a SELECT DISTINCT operation. I have a table with a column labled date_created. I know that some records (about 30) were created at the exact same time (to the second) as another record. I would like to find the records that have a date_created value equal to another record. Is this possible in 3.23.54? Thanks in advance Try this: SELECT date_created, COUNT(*) AS num FROM tablename GROUP BY date_created HAVING num 1; HTH! Oof. On re-reading this, I realized I wasn't entirely specific enough. What this'll return is all date_created values that have more than one record and a count of how many. The legwork after that is to select all the rows that have each of those date_created values, but that's not exactly a scalable solution. Come to think of it, I'm not entirely sure, off the top of my head, how to get the records themselves. Sorry for the confusion! -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help with Joins
Greetings. I have a table that contains procedures and a table that contains forms. Each procedure may have 1 or more forms or it may have no associated forms. Each form may be relevant to more than 1 procedure. The procedure table has 1 entry per procedure. The forms table may have more than 1 entry per form depending on how many procedures use that form. Each form entry has a foriegn key tying it to the record number of the procedure. I want to compose a query that will pull out each distinct instance of a form (in other words, no duplicates) and then list which procedures use that form So: Form Name Procedure(s) Name Is this a clear enough explanation for folks? I'm willing to RTFM if somebody will point me to the chapter(s) that discuss different join syntax and how it's used in MySQL. I'm using 3.23.54 in my production environment at the moment and my tables are MyISAM. Thanks in Advance = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Yahoo! Domains Claim yours for only $14.70/year http://smallbusiness.promotions.yahoo.com/offer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: This thing called MOD
Thomas MOD is a way to get the remainder from a division problem. It does not take into account fractions like we do in real math. It's more basic and elementary. Mod of 5 by 2 would be 1. The answer is 2 remainder 1, thus the MOD is 1. I myself have never used this fuction but I'm sure lots of others on the list have found a use for it. cheers --- Thomas Nyman [EMAIL PROTECTED] wrote: Hi All I'm a bit perplexed..perhaps its a language thing,,but the MYSQL reference manual says that MOD ..Returns the remainder of N divided by M... and gives an example SELECT MOD(234,10) -- 4 This I do not understand. remainder of N divided by M - isn't that simply division? I mean 234 divided by 10 does not equal 4 On my own machine..if I do SELECT MOD(23,6) I would expect 3,8333 as the result and not 5. SInce MOD is returning something other than I expect there must be something I am missingin other words...what is MOD returning?? Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Directory Permissions on files
Greetings, I've recently inherited a FreeBSD server running MySQL 3.23.54. It's good and stable. I have a second server that runs as a slave to the first. Everything goes smoothly until I make changes to a certain table on my master. This will kill the slave with the error that this table is read-only. These are all MyISAM tables. I noticed recently that the various directories have different permissions and access levels on them and wondered what the correct levels should be. And...does this even have an effect on whether the table can be written to? Thanks in Advance = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Alter Table question
This seems very basic to me but I can't find (though only really looked for a little bit) the syntax for issuing an alter table statement that will force a field to no longer allow NULL values. I have some fields in a MyISAM table of MySQL 3.23 and wish to require them to contain a value. What is the syntax of this and how will it affect data in the table? Thanks in advance for the help. = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Conference Presentations
Yes, I'm anxious to get my hands on some of the presentations myself. I think I saw a couple of brief mentions of a url but it wasn't written down anywhere. I'd also like to see some of the pictures I saw David snapping everywhere. :) --- David Perron [EMAIL PROTECTED] wrote: Does anyone know if the presentations from the User Conference are available online? Thanks dp = Robert Reed 512-869-0063 home 512-818-2460 cell __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]