tag:blogger.com,1999:blog-5666457738678091444.post9173579032660248129..comments2023-10-01T14:34:35.157+01:00Comments on 1000 for 1KSQ: SP5595ish, 05/01/2013Andy Musgrovehttp://www.blogger.com/profile/05105588316743620086noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5666457738678091444.post-2029629775569813032013-01-08T11:30:12.862+00:002013-01-08T11:30:12.862+00:00I'd already tried changing the code to reflect...I'd already tried changing the code to reflect a 1k square but it didn't work. I've forced a solution by changing the admin area for each pertinent site which I can then use in filtering.Skevhttps://www.blogger.com/profile/05601888498478097564noreply@blogger.comtag:blogger.com,1999:blog-5666457738678091444.post-13999783600971773732013-01-07T15:45:25.731+00:002013-01-07T15:45:25.731+00:00Sorry, clumsy of me. I meant
[Sites\Default].[1kS...Sorry, clumsy of me. I meant<br /><br />[Sites\Default].[1kSquare]='SP5595'Andy Musgrovehttps://www.blogger.com/profile/05105588316743620086noreply@blogger.comtag:blogger.com,1999:blog-5666457738678091444.post-88332537027353091382013-01-07T15:44:30.872+00:002013-01-07T15:44:30.872+00:00I don't use Mapmate myself, but I do use SQL. ...I don't use Mapmate myself, but I do use SQL. Difficult to be sure without a good knowledge of the database, but I bet if you try something like Mark's suggestion, but just try [Sites\Default].[1kSquare])='WV4281' then you'd have a fighting chance of it working. Just have a play and see what comes outAndy Musgrovehttps://www.blogger.com/profile/05105588316743620086noreply@blogger.comtag:blogger.com,1999:blog-5666457738678091444.post-68870281225941176962013-01-06T21:27:16.294+00:002013-01-06T21:27:16.294+00:00Jeez, Harvestmen give me the creeps! I mean, just ...Jeez, Harvestmen give me the creeps! I mean, just look at it! What a freak.<br /><br />Good SQL'ing I'd say. I use Mapmate for all my Lep records. I know I have used down to 2km squares before for atlases by adding a letter at the end of the grid reference (eg (([Sites\Default].[2kSquare])='WV48B') but I use it so infrequently that I always forget how it all works.M Lawlorhttps://www.blogger.com/profile/00955756227234970302noreply@blogger.com