Re: MI SQL question
Yes IE supports Java. Let me check on the failure to load. Matt - Original Message - From: "PERRY Chris" <[EMAIL PROTECTED]> To: "'Fran Peck'" <[EMAIL PROTECTED]> Cc: "MapInfo-L (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, January 13, 2000 4:56 PM Subject: RE: MI SQL question > Fran, > > The MapBasic help file gives you this sort of information. I have attached > the following excerpt which relates to SQL selections (using MB, but same > principles apply). Also from the MB help, on the like statement: > > The pattern_string parameter can contain the following wild-card characters: > > _ (underscore) matches a single character > % (percent) matches zero or more characters > > I agree that this is not well documented in the MapInfo help. If you search > for wildcards, this info is under the heading "Comparison Operators". This > is in the index under "Operators" - so the indexing is pretty poor. > > Hope this helps, > > Chris Perry > Systems Development CoOrdinator > Parks Victoria > Melbourne, Australia > Ph: 61 3 9816 6800 > Fax: 61 3 9816 9876 > [EMAIL PROTECTED] > > > -Original Message- > From: Fran Peck [mailto:[EMAIL PROTECTED]] > Sent: Friday, 14 January 2000 4:58 > To: Mapinfo List (E-mail) > Subject: MI SQL question > > > Is there reference material that gives a better explanation of SQL select in > MI than the reference and user's guides that come with it? The reference > guide lacks what should be simple things such as the use of like statements, > wildcards, etc. Since every sql handles these statements slightly > differently, it would be good to have a reference to the use. Thanks in > advance. > > Fran Peck > Peoria Unified School District > 6330 W Thunderbird Rd > Glendale, AZ 85306 > Voice: 623-486-6099 > Fax: 623-486-6111 > Email: [EMAIL PROTECTED] > > -- > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] > > -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI SQL question
Hi Fran, Not sure what you are after - if it is the SQL syntax used by Mapinfo/MapBasic try this: 1. Create an ODBC SQL link to a database using MapInfo (menu = File>Open ODBC table) 2. Save the table 3. Open the newly created .tab file in notepad or other text editor The table definition includes a Query statement - this is in effect the SQL eg. "\DATALINK\Query" = "select `DataSet_ID`, `Dataset_name`, `Dataset_creation_date`, `Dataset_author`, `Dataset_owner` from `C:\Userdata\mat\Database\MAT`.`TblDataSets` where (`DataSet_ID` = 15) and (`Dataset_name` like 'test')" Similarly, if you create an SQL query of a table using Mapinfo (menu = Query>SQL select) and save the workspace, you can view the workspace file in a text editor to see the select statement. However, I suspect that you are trying to find out the syntax to be used in the MapInfo Query>SQL select dialogue (to avoid the dreaded errors that you get when you try to verify your syntax!), and the only method I have found is trial and error or looking at one that worked previously! Regards, Pete, Ordnance Survey, UK -Original Message- From: Fran Peck [mailto:[EMAIL PROTECTED]] Sent: 13 January 2000 17:58 To: Mapinfo List (E-mail) Subject: MI SQL question Is there reference material that gives a better explanation of SQL select in MI than the reference and user's guides that come with it? The reference guide lacks what should be simple things such as the use of like statements, wildcards, etc. Since every sql handles these statements slightly differently, it would be good to have a reference to the use. Thanks in advance. Fran Peck Peoria Unified School District 6330 W Thunderbird Rd Glendale, AZ 85306 Voice: 623-486-6099 Fax: 623-486-6111 Email: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI SQL question
Fran, The MapBasic help file gives you this sort of information. I have attached the following excerpt which relates to SQL selections (using MB, but same principles apply). Also from the MB help, on the like statement: The pattern_string parameter can contain the following wild-card characters: _ (underscore) matches a single character % (percent)matches zero or more characters I agree that this is not well documented in the MapInfo help. If you search for wildcards, this info is under the heading "Comparison Operators". This is in the index under "Operators" - so the indexing is pretty poor. Hope this helps, Chris Perry Systems Development CoOrdinator Parks Victoria Melbourne, Australia Ph: 61 3 9816 6800 Fax: 61 3 9816 9876 [EMAIL PROTECTED] -Original Message- From: Fran Peck [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 January 2000 4:58 To: Mapinfo List (E-mail) Subject: MI SQL question Is there reference material that gives a better explanation of SQL select in MI than the reference and user's guides that come with it? The reference guide lacks what should be simple things such as the use of like statements, wildcards, etc. Since every sql handles these statements slightly differently, it would be good to have a reference to the use. Thanks in advance. Fran Peck Peoria Unified School District 6330 W Thunderbird Rd Glendale, AZ 85306 Voice: 623-486-6099 Fax: 623-486-6111 Email: [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] sqlselect.rtf
Re: MI SQL question Obtaining counts
Fran: I believe what you are looking for is the "group by" column. If you "group by" school, then the count of 0s and 1s will be grouped by school. HTH Stephen Sloan - Original Message - From: Fran Peck <[EMAIL PROTECTED]> To: Mapinfo List (E-mail) <[EMAIL PROTECTED]> Sent: Friday, August 20, 1999 5:59 PM Subject: MI SQL question Obtaining counts > I have a question for the list. I have gone into the archives and users > guide and have found one part of this question, but not the full solution. I > have a table of students with a column of INOUTDIST, and in the column there > is an "I" if they are varianced but from in district, and an "O" if they are > varianced but they are from out of the district. I have joined this table > to my school polygon service area table by school number to ultimately > thematically map the information. My dilemma is this: I can get a count > (frequency) of "I" and "O" and when I add schoolnum in there can get the > number by school. BUT I am still missing something - the query returns with > a TOTAL of "I"s and "O"s for each school. I can add in a where clause with > either "I" or "O", but cannot figure out how to get my query to breakdown > the number of each for each school. I know I could take this into Access and > manipulate it, but would like to keep it in MI with all of my MI pertinent > info if at all possible. Any and all suggestions greatly appreciated! > Thanks in advance. > > Fran Peck > Office of Research and Planning > Peoria Unified School District > 6330 W Thunderbird Rd > Glendale, AZ 85306 > 623-486-6099 > Fax: 623-486-6111 > Email: [EMAIL PROTECTED] > > -- > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] > -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]