Databases
StackOverflow2013
Postsdbo
POtrying to attach the where clause to sql statement
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POtrying to attach the where clause to sql statement
    text
    copied!<p>HiI am trying to attach the where clause to sql statement like this </p> <pre><code> public static DataTable paymentType(string paymenttype, string ddproviders, string overdue) { string paymenttypestr = ""; string ddproviderstr = ""; if (paymenttype != "") { paymenttypestr = string.Format("AND membertomships.memberToMship_PayMethod = '{0}'", paymenttype); } if (ddproviders != "") { ddproviderstr = string.Format("AND ddproviders.ddProvider_Name = '{0}'", ddproviders); } if (overdue == "OverDue-Now") { string sql += @"WHERE memberpaysched.memberPaySched_dateDue &lt; NOW() AND memberpaysched.memberPaySched_amountDue &gt; memberpaysched.memberPaySched_amountPaid "; } string sql = string.Format( @"SELECT members.member_Id, members.member_Lastname As Last_name, members.member_Firstname AS First_name, members.member_PostCode As Post_Code, ddaccounts.ddAccount_DdReference As dd_reference, ddproviders.ddProvider_Name As dd_providername, memberToMship_ChargePerPeriod As monthly_amount, mshiptypes.mshipType_Name As Membership_type, mshipstatustypes.mshipStatusType_Name As Status, membertomships.memberToMship_EndDate As Expiry_Date, membertomships.memberToMship_PayMethod As payment_method FROM members LEFT JOIN membertomships ON membertomships.member_Id = members.member_Id LEFT JOIN memberpaysched ON memberpaysched.memberPaySched_memberId = members.member_Id LEFT OUTER JOIN ddaccounts ON ddaccounts.member_Id = members.member_Id LEFT OUTER JOIN ddproviders ON ddaccounts.ddProvider_Id=ddproviders.ddProvider_Id LEFT JOIN mshipstatustypes ON mshipstatustypes.mshipStatusType_Id = membertomships.mshipStatusType_Id LEFT JOIN mshipoptions ON mshipoptions.mshipOption_Id = membertomships.mshipOption_Id LEFT JOIN mshiptypes ON mshiptypes.mshipType_Id = mshipoptions.mshipType_Id WHERE members.member_Active LIKE 'y%' AND mshipoptions.mshipOption_Period = 'month' AND (mshipstatustypes.mshipStatusType_Id &lt;&gt; 5) {0} {1} ORDER BY members.member_Lastname", paymenttypestr, ddproviderstr); return getdata(sql,mf); } </code></pre> <p>but it was giving error at this line like ";" this symbol is needed;</p> <pre><code> string sql += @"WHERE memberpaysched.memberPaySched_dateDue &lt; NOW() AND memberpaysched.memberPaySched_amountDue &gt; memberpaysched.memberPaySched_amountPaid "; </code></pre> <p>I want to add this where clause if overdue == "overdue-now"</p> <p>how can i add this where clause according to condition </p> <p>would any one help on this ....</p> <pre><code>Modified Query : string sql += @"memberpaysched.memberPaySched_dateDue &lt; NOW() AND memberpaysched.memberPaySched_amountDue &gt; memberpaysched.memberPaySched_amountPaid"; </code></pre> <p>still it was showing this error "Invalid EXPRESSION TERM +="</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload