[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Question on a dynamic where statement

Clark,
Actually you will need to add the value of $entered_dept to the where
string, not the string '$entered_dept'.  Like ...

   let $whereclause = 'WHERE DEPTID = ' || $entered_dept

HTH,
Don Mellen


On Tue, 6 Oct 1998, C. Willis III wrote:

> let $whereclause = 'WHERE DEPTID = $entered_dept'
>
> SELECT (lots of fields)
> FROM PS_EMPLOYEES
> [$whereclause]

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"