> Posting your whole script, or a larger part might be helpful and get
> more response. are you using strict and warnings?
>
> My original hunch was that the "where" method was not being exported and
> therefore was not "loaded" by your script, upon a slight more research I
> was *unable* to find
Posting your whole script, or a larger part might be helpful and get
more response. are you using strict and warnings?
My original hunch was that the "where" method was not being exported and
therefore was not "loaded" by your script, upon a slight more research I
was *unable* to find the "wh
> Is the below 'exactly' what you have? The reason I ask is:
> $statement = SQL::Statement->new("select 1,
> and
> $where = $stmt->where();
>
> Should it be:
> $where = $statement->where();
>
> HTH, David
thanks david for telling my about my *EMAIL* typo, coz it is wriiten
*CORRECTLY* in the s
> Hytham,
>
> Although I haven't used SQL::Statement you can certainly do something
like:
>
> $condition = $1 if $statement =~ /where (.+)( order by .+){0,1}$/;
>
> I haven't tested this but I expect it to pick up the conditional part of
an
> SQL statement which would then be up to you to parse fu
At 07:34 PM 8/10/02 +0300, Hytham Shehab wrote:
> how can i parse the where clause in an SQL::Statement object instance?
>$statement = SQL::Statement->new("select 1,2,3 from table where x=y");
Hytham,
Although I haven't used SQL::Statement you can certainly do something like:
$condition = $