in reply to Re: how do i construct a sql select statement, where i want to get the where clauses out of an array
in thread how do i construct a sql select statement, where i want to get the where clauses out of an array

bout the problem of an empty array i already thought, but the array shouldnt be empty it is filled with values out of a form, which invokes the script... but u never know... would it be some solution to put a zero as first id in the array, cause the zero wont be an id in the db table
  • Comment on Re: how do i construct a sql select statement, where i want to get the where clauses out of an array

Replies are listed 'Best First'.
Re: Re: how do i construct a sql select statement, where i want to get the where clauses out of an array
by George_Sherston (Vicar) on Aug 25, 2001 at 21:40 UTC
    Yes, or just put the whole thing in an if (@ids) { ... }loop - which would make it work quicker when @ids was empty

    § George Sherston
[reply]
[d/l]

In Section Seekers of Perl Wisdom