[Android Apps and Games] daryelv:
Tried using this, but keep getting "NA" for everything.

Took a logcat... here's a few of the errors that I think may be related...

E/SQLiteLog(18066): (1) near "--121950659) LIMIT 1": syntax error
E/DB Error(18066): android.database.sqlite.SQLiteException: near "--121950659) LIMIT 1": syntax error (code 1): , while compiling: SELECT C._id, C.name, C.country_code, C.country_code, C.lat_e6, C.lon_e6, C.population, C.priority, C.latest_update FROM city C WHERE C.lat_e6 BETWEEN 38328557 AND 38358557 AND C.lon_e6 BETWEEN -121965659 AND -121935659 ORDER BY ABS(C.lat_e6-38343557) + ABS(C.lon_e6--121950659) LIMIT 1
W/System.err(18066): android.database.sqlite.SQLiteException: near "--121950659) LIMIT 1": syntax error (code 1): , while compiling: SELECT C._id, C.name, C.country_code, C.country_code, C.lat_e6, C.lon_e6, C.population, C.priority, C.latest_update FROM city C WHERE C.lat_e6 BETWEEN 38328557 AND 38358557 AND C.lon_e6 BETWEEN -121965659 AND -121935659 ORDER BY ABS(C.lat_e6-38343557) + ABS(C.lon_e6--121950659) LIMIT 1
W/System.err(18066):	at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
W/System.err(18066):	at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
W/System.err(18066):	at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
W/System.err(18066):	at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
W/System.err(18066):	at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
W/System.err(18066):	at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
W/System.err(18066):	at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
W/System.err(18066):	at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
W/System.err(18066):	at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
W/System.err(18066):	at com.fingrtips.beta.weathermaps.database.DatabaseManager.getNearestCity(DatabaseManager.java:318)
W/System.err(18066):	at com.fingrtips.beta.weathermaps.WeatherMapsBetaActivity$6.run(WeatherMapsBetaActivity.java:698)
W/System.err(18066):	at com.google.android.maps.MyLocationOverlay.runOnFirstFix(MyLocationOverlay.java:728)
W/System.err(18066):	at com.fingrtips.beta.weathermaps.WeatherMapsBetaActivity.clickMenuMyPosition(WeatherMapsBetaActivity.java:694)
W/System.err(18066):	at com.fingrtips.beta.weathermaps.WeatherMapsBetaActivity.onOptionsItemSelected(WeatherMapsBetaActivity.java:438)
W/System.err(18066):	at android.app.Activity.onMenuItemSelected(Activity.java:2534)
W/System.err(18066):	at com.android.internal.policy.impl.PhoneWindow.onMenuItemSelected(PhoneWindow.java:971)
W/System.err(18066):	at com.android.internal.view.menu.MenuBuilder.dispatchMenuItemSelected(MenuBuilder.java:735)
W/System.err(18066):	at com.android.internal.view.menu.MenuItemImpl.invoke(MenuItemImpl.java:149)
W/System.err(18066):	at com.android.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:874)
W/System.err(18066):	at com.android.internal.view.menu.MenuPopupHelper.onItemClick(MenuPopupHelper.java:156)
W/System.err(18066):	at android.widget.AdapterView.performItemClick(AdapterView.java:298)
W/System.err(18066):	at android.widget.AbsListView.performItemClick(AbsListView.java:1086)
W/System.err(18066):	at android.widget.AbsListView$PerformClick.run(AbsListView.java:2855)
W/System.err(18066):	at android.widget.AbsListView$1.run(AbsListView.java:3529)
W/System.err(18066):	at android.os.Handler.handleCallback(Handler.java:615)
W/System.err(18066):	at android.os.Handler.dispatchMessage(Handler.java:92)
W/System.err(18066):	at android.os.Looper.loop(Looper.java:137)
W/System.err(18066):	at android.app.ActivityThread.main(ActivityThread.java:4900)

And...

W/GoogleAnalyticsTracker(18066): Problem with socket or streams.
W/GoogleAnalyticsTracker(18066): java.net.ConnectException: failed to connect to www.google-analytics.com/127.0.0.1 (port 80): connect failed: ECONNREFUSED (Connection refused)
W/GoogleAnalyticsTracker(18066):	at libcore.io.IoBridge.connect(IoBridge.java:114)
W/GoogleAnalyticsTracker(18066):	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:192)
W/GoogleAnalyticsTracker(18066):	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:459)
W/GoogleAnalyticsTracker(18066):	at java.net.Socket.connect(Socket.java:842)
W/GoogleAnalyticsTracker(18066):	at org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:119)
W/GoogleAnalyticsTracker(18066):	at com.google.android.apps.analytics.PipelinedRequester.maybeOpenConnection(Unknown Source)
W/GoogleAnalyticsTracker(18066):	at com.google.android.apps.analytics.PipelinedRequester.addRequest(Unknown Source)
W/GoogleAnalyticsTracker(18066):	at com.google.android.apps.analytics.NetworkDispatcher$DispatcherThread$AsyncDispatchTask.dispatchSomePendingHits(Unknown Source)
W/GoogleAnalyticsTracker(18066):	at com.google.android.apps.analytics.NetworkDispatcher$DispatcherThread$AsyncDispatchTask.run(Unknown Source)
W/GoogleAnalyticsTracker(18066):	at android.os.Handler.handleCallback(Handler.java:615)
W/GoogleAnalyticsTracker(18066):	at android.os.Handler.dispatchMessage(Handler.java:92)
W/GoogleAnalyticsTracker(18066):	at android.os.Looper.loop(Looper.java:137)
W/GoogleAnalyticsTracker(18066):	at android.os.HandlerThread.run(HandlerThread.java:60)
W/GoogleAnalyticsTracker(18066): Caused by: libcore.io.ErrnoException: connect failed: ECONNREFUSED (Connection refused)
W/GoogleAnalyticsTracker(18066):	at libcore.io.Posix.connect(Native Method)
W/GoogleAnalyticsTracker(18066):	at libcore.io.BlockGuardOs.connect(BlockGuardOs.java:85)
W/GoogleAnalyticsTracker(18066):	at libcore.io.IoBridge.connectErrno(IoBridge.java:127)
W/GoogleAnalyticsTracker(18066):	at libcore.io.IoBridge.connect(IoBridge.java:112)
W/GoogleAnalyticsTracker(18066):	... 12 more

Update - Just saw your last post... wish I had seen it 20 minutes ago. :) The app looks really nice, just wish it had data. There are other sources to get weather data as well... wunderground, accuweather, etc. I did some Windows Mobile work with wunderground years ago, it had the best API then, but that was years ago and things change in seconds now.

-Daryel