Awsome,
Thanks, Bruce Phillip Ciske wrote: > Since you have two statements after the IF, only the first is being > associated with the IF condition. The ELSE is seen as without a > matching IF. > > A BEGIN...END block will group the two IF condition statements so that > they will be executed together. If the IF condition fails, the ELSE > condition will execute: > > IF @Users_id = 0 > BEGIN > INSERT statement... > > SELECT statement... > END > ELSE > UPDATE statement... > > Hope this helps, > Phillip ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3005 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
