• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
affect vs effect

#8
Quote:"affected rows" makes it an adjective, right?

Essentially, yes. Verbs can become adjectives by turning into participles. (Sorry you asked yet?)
Participles are verb forms ending in ‑ing (present participles) or -ed or -en (past participles) that modify nouns.

While effect is usually a noun, it can be a verb when used in the sense of to bring about e.g. "The update method is used to effect change on the rows." However, once the method has run we would want to know which (or how many) rows were affected not effected.

So, for me, the correct DB function name is affected_rows.

In the interests of full disclosure, there are cases where a noun can act as an adjective e.g. "ticket office".  Rolleyes
Reply


Messages In This Thread
affect vs effect - by skunkbad - 03-23-2017, 01:53 PM
RE: affect vs effect - by InsiteFX - 03-23-2017, 03:14 PM
RE: affect vs effect - by skunkbad - 03-23-2017, 03:26 PM
RE: affect vs effect - by markusnippet - 04-04-2017, 03:32 AM
RE: affect vs effect - by JayAdra - 03-23-2017, 04:09 PM
RE: affect vs effect - by skunkbad - 03-23-2017, 06:50 PM
RE: affect vs effect - by JayPatel - 03-27-2017, 10:17 PM
RE: affect vs effect - by llebkered - 03-24-2017, 12:47 AM
RE: affect vs effect - by PaulD - 03-25-2017, 07:55 AM
RE: affect vs effect - by dave friend - 03-27-2017, 08:42 AM
RE: affect vs effect - by skunkbad - 03-27-2017, 02:06 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.