ChrisL Posted July 26, 2011 Share 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 Link to comment Share on other sites More sharing options...
jvanegmond Posted July 26, 2011 Share 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 Link to comment Share on other sites More sharing options...
ChrisL Posted July 26, 2011 Author Share 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 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