Re: [SQL] postgre variable

|Subject: [SQL] postgre variable | | |hello all, | |i want to make dynamic sql query like this | |select * from tb_cust where name='erick' and age='20' | |to | |select * from tb_cust $1 | |i have tried but error comeup | |any suggestion? | |thanks |Ricky |-- |Gutten Aben Sugeng So

Re: [SQL] postgre variable

Hi, On 5/19/05, bandeng <[EMAIL PROTECTED]> wrote: > i want to make dynamic sql query like this > > select * from tb_cust where name='erick' and age='20' > > to > > select * from tb_cust $1 > > i have tried but error comeup I think there's a confusion about the usage of parameters like $1, $2

Re: [SQL] postgre variable

bandeng wrote: hello all, i want to make dynamic sql query like this select * from tb_cust where name='erick' and age='20' to select * from tb_cust $1 i have tried but error comeup You have tried what? How? What error did you get? -- Richard Huxton Archonet Ltd ---(end o

[SQL] postgre variable

hello all, i want to make dynamic sql query like this select * from tb_cust where name='erick' and age='20' to select * from tb_cust $1 i have tried but error comeup any suggestion? thanks Ricky -- Gutten Aben Sugeng Sonten, Jangane Kurang Santen bandeng ---