List Info

Thread: Re: Check if files is empty
Re: Check if files is empty
country flaguser name
United States		 2007-04-23 10:13:44 

  


  

    TRY THIS..



IF (DB_FETCH_OBJECT(DB
_QUERY(DB_REWRITE_SQL("SELECT COUNT(*) FROM  F WHERE F.FILEPATH LIKE 'FILES/%'", 'F'))) >= 1) {




 



ON MON APR 23 10:45 , 'JOHAN FORNGREN' FORNGREN.COM> SENT:




FORNGREN.COM>
HI ALL,



I NEED HELP WITH TURNING THIS QUERY INTO SOMETHING USEFUL



SELECT FID FROM  WHERE FILEPATH LIKE 'FILES/%' LIMIT 1



IF (COUNT(DB_FETCH_OBJECT(DB
_QUERY("SELECT FID FROM  WHERE FILEPATH LIKE 'FILES/%' LIMIT 1"))) == 1) {




THE PURPOSE IS TO DETERMINE IF THERE IS SOME FILES WITHIN THE DIR 'FILES' REGISTERED IN THE DB. I'M STUCK AT THE DB_* STUFF, ANY HELP WOULD BE GREATLY APPRECIATED. SEE ALSO 

HTTP://DRUPAL.ORG/NODE/98824 .



THANK YOU


-- 

REGARDS,

  JOHAN FORNGREN 



  FORNGREN.COM','','','')" TARGET="_BLANK" DEFANGED_ONCLICK="RETURN TOP.JS.OPENEXTLINK(WINDOW,EVENT,THIS)">
JOHANFORNGREN.COM :: HTTP://JOHAN.FORNGREN.COM/





  

  
  
   
     
    






 [1]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )