Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Code Block
<Request method="GET">
		<Sql id="user" type="query" when="$authType eq 'normal'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="googleUser" type="query" when="$authType eq 'google'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="linkedInUser" type="query" when="$authType eq 'linkedin'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="twitterUser" type="query" when="$authType eq 'twitter'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
      	<Sql id="facebookUser" type="query" when="$authType eq 'facebook'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
	</Request>


The above request can be written as


Code Block
<Request method="GET">
		<Sql id="user" type="query" when="$authType eq 'normal'"> 
          	SELECT * FROM account WHERE emailUsers=$email
      	</Sql>
	</Request>