From: Bill F. <bil...@cr...> - 2004-04-29 17:24:38
|
I did that initially and found that a status of 1 corresponded to an active survey, but when someone else created a survey and activated it, it had a status of 9. I'm wondering if the type of designer (superuser, etc.) has something to do with it. -----Original Message----- From: php...@li... [mailto:php...@li...] On Behalf Of Matthew Gregg Sent: Thursday, April 29, 2004 12:14 PM To: php...@li... Subject: RE: [phpesp-general] Retrieving list of surveys dynamically Off the top of my head, I don't know how the status states relate. All you should have to do is create a survey, then query it's state as you change it from, editing->testing->active->archive. On Thu, 2004-04-29 at 13:07, Bill Farber wrote: > Brian, thanks for your input, but that add-on is a little overkill for > what I need. I have already written a short script to pull the surveys > based on the value of the status column in the survey table. I just > need to know what the possible status values are and what they mean. > > Thanks, > > Bill > > -----Original Message----- > From: php...@li... > [mailto:php...@li...] On Behalf Of Brian > Wood > Sent: Wednesday, April 28, 2004 6:02 PM > To: Bill Farber; php...@li... > Subject: Re: [phpesp-general] Retrieving list of surveys dynamically > > > Bill, > > Check out this addon by Chad Bearden: > > http://www.beardendesigns.com/phpESP/index.php > > Brian Wood > Programmer/Analyst > UC Berkeley Human Resources > > At 03:04 PM 4/28/2004, Bill Farber wrote: > >I would like to retrieve a list of active surveys from the database > >to displayed on my web site, so when a new survey is activated it is > >automatically added to my site. I'm assuming I would need to perform > >a > > >query on the survey table to find all the surveys with a specific > >value > > >in the status column, but I don't know what the status values > >correspond to. Can anyone help me out? > > > >Thanks in advance for your help. > > > >-Bill > > > > > > > > > >------------------------------------------------------- > >This SF.Net email is sponsored by: Oracle 10g > >Get certified on the hottest thing ever to hit the market... Oracle > >10g. Take an Oracle 10g class now, and we'll give you the exam FREE. > >http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click > >_______________________________________________ > >phpESP-general mailing list php...@li... > >https://lists.sourceforge.net/lists/listinfo/phpesp-general > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: Oracle 10g > Get certified on the hottest thing ever to hit the market... Oracle > 10g. > > Take an Oracle 10g class now, and we'll give you the exam FREE. > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click > _______________________________________________ > phpESP-general mailing list php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general > > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: Oracle 10g > Get certified on the hottest thing ever to hit the market... Oracle > 10g. > Take an Oracle 10g class now, and we'll give you the exam FREE. > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click > _______________________________________________ > phpESP-general mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-general -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) ------------------------------------------------------- This SF.Net email is sponsored by: Oracle 10g Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click _______________________________________________ phpESP-general mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-general |