Re: [Phpwebsite-developers] Item/Manager troubles

[Steven L. <st...@tu...>]

Don,

  Yes the doc is wrong.  You do not need to add the WHERE the manager will
handle adding that for you.  I will update that in the documentation. 
Thanks for posting about it.

Steven

> In my conf/manager.php I have this line:
>
> $lists = array("messages"=>"WHERE pid=0");
>
> which is right, according to the ITEM_MANAGER_README.txt example:
>
> /* The name of your lists and their corresponding database constraints */
> $lists = array("mylist"=>"WHERE approved='1' AND saved='1'");
>
> However when I run my getLists function this is printed to the browser
> window:
>
> SQL: SELECT id FROM mod_phpwsbb_messages WHERE (WHERE pid=0)
> syntax error
>
> So I'm thinking the doc might be incorrect?  Of course when have just
> "pid=0" I don't get any items returned, despite them having pid of 0.
>
> Don.
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: ObjectStore.
> If flattening out C++ or Java code to make your application fit in a
> relational database is painful, don't do it! Check out ObjectStore.
> Now part of Progress Software. http://www.objectstore.net/sourceforge
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Steven Levin
Electronic Student Services
Appalachian State University
Phone: 828.262.2431
PhpWebsite Development Team
URL: http://phpwebsite.appstate.edu
Email: st...@NO...