ChrisL 13 Posted July 26, 2011 I've got a query which doesn't work. UPDATE PrintsCD SET p6x4 = p6x4 +1 Where (Select ID from IMAGETABLE WHERE isPrintable='True'); The items which "isPrintable" equals False in IMAGETABLE still get updated in PrintsCD, any ideas please? [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 Share this post Link to post Share on other sites
jvanegmond 306 Posted July 26, 2011 You're saying: Where {1,2,3,4,5,6}. A list of IDs is forced to evaluate to true/false. It should be more like:UPDATE PrintsCD SET p6x4 = p6x4 +1 Where ID IN (Select ID from IMAGETABLE WHERE isPrintable='True'); github.com/jvanegmond Share this post Link to post Share on other sites
ChrisL 13 Posted July 26, 2011 Thanks Manadar perfect [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 Share this post Link to post Share on other sites