Re: sql statement parsing

2002-08-11 Thread Hytham Shehab
> 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

Re: sql statement parsing

2002-08-10 Thread Wiggins d'Anconia
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

Re: sql statement parsing

2002-08-10 Thread Hytham Shehab
> 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

Re: sql statement parsing

2002-08-10 Thread Hytham Shehab
> 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

Re: sql statement parsing

2002-08-10 Thread Marty Landman
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 = $