MySQL Forums
Forum List  »  Newbie

Pass Complex Parameters | Your Suggestion Please
Posted by: Jassim Rahma
Date: April 06, 2023 10:37AM

Hi,

I need your suggestion please.

I have populate_members stored procedure and I want to pass values from my .NET MAUI app:

param_nationality -> will pass blank or 2 digits country code

param_gender -> will pass M, F or blank

param_country -> will pass blank or 2 digits country code


Then in my SELECT query, I want to say:

if nationality is blank then do not add it to the query but if it's not blank the nationality = param_nationality

if gender is blank then do not add it to the query but if it's not blank the gender = param_gender

if country is blank then do not add it to the query but if it's not blank the country = param_country


Kindly advise.


Thanks,
Jassim

Options: ReplyQuote


Subject
Written By
Posted
Pass Complex Parameters | Your Suggestion Please
April 06, 2023 10:37AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.