fielmann Posted December 20, 2008 Share Posted December 20, 2008 (edited) SQLite: How to select only one field? I could only realize it with: _SQLite_QuerySingleRow #include <SQLite.au3> #include <SQLite.dll.au3> Local $aRow _SQLite_Startup() _SQLite_Open("..\sqlite\database.db") $SQL = "select field from table where id=100" _SQLite_QuerySingleRow(-1,$SQL,$aRow) MsgBox(0,"SQL-Result:",$aRow[0]) _SQLite_Close() _SQLite_Shutdown() Is there a simple way to read out only one field? Edited December 20, 2008 by fielmann Link to comment Share on other sites More sharing options...
ChrisL Posted December 21, 2008 Share Posted December 21, 2008 Try that $SQL = "select field from table where id=100 LIMIT 1" [u]Scripts[/u]Minimize gui to systray _ Fail safe source recoveryMsgbox UDF _ _procwatch() Stop your app from being closedLicensed/Trial software system _ Buffering Hotkeys_SQL.au3 ADODB.Connection _ Search 2d Arrays_SplashTextWithGraphicOn() _ Adjust Screen GammaTransparent Controls _ Eventlogs without the crap_GuiCtrlCreateFlash() _ Simple Interscript communication[u]Websites[/u]Curious Campers VW Hightops Lambert Plant Hire Link to comment Share on other sites More sharing options...
fielmann Posted December 21, 2008 Author Share Posted December 21, 2008 Try that$SQL = "select field from table where id=100 LIMIT 1"id=100 is already unique! so I get always back one result. Can anybody send me an example how to realize? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now