How to supply more than one Parameter's in PostgreSQL

[ManjunathReddy (P Manjunatha)]

Select * from Table Where Date = ‘’
Select * from Table Where Age = ‘’

I know how to apply for single parameter, but how about more then one?

For single parameter I used

in excel have query as Select * from Table Where Date = '<DATE>'

In code you can use Row("ColumnName").ToString.Replace("<DATE>",actualDate)

@Anil_G

Thanks in advance

[Anil_G (Anil Gorthi)]

@ManjunathReddy

Add more tags for each you want to use and add replace as needed similar to date

Eg: ... Where Date = '<DATE>' and ID = '<ID>'

now use one replace for date and another for id

cheers

[ManjunathReddy (P Manjunatha)]

In the above image I have replace ‘year-mm-dd’

Thanks

[Anil_G (Anil Gorthi)]

@ManjunathReddy

give it as <DATE1> and <DATE2> and use one replace with required date format …

or if you need separate only then use <YEAR1>-<MONTH1>-<DATE1> and use separate replace functions for each

cheers

[ManjunathReddy (P Manjunatha)]

showing error like below

[Anil_G (Anil Gorthi)]

@ManjunathReddy

You should use two replace functions…and will not work in replace

.Replace("<DATE1>",ExecutionDate1).Replace("<DATE2>",ExecutionDate2)

cheers