Menu
▾
▴
phpesp-general
|
From: Bill F. <bil...@cr...> - 2004-04-28 22:05:12
|
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 |
|
From: Brian W. <br...@uc...> - 2004-04-28 23:03:45
|
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 |
|
From: Bill F. <bil...@cr...> - 2004-04-29 17:07:22
|
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 |
|
From: Matthew G. <gr...@mu...> - 2004-04-29 17:15:13
|
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) |
|
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 |
|
From: David L. <lio...@co...> - 2004-05-25 09:10:24
|
Greetings -- I set up accounts for my students and ran into this problem. 1. I told the student the login was Rosch-197F 2. The login screen disregards case -- it accepts Rosch-197F, rosch-197f, ROSCH-197F, whatever 3. Other parts of the program are case sensitive -- for instance, activating a survey So if you log in as rosch-197F and design a survey, and then later log in as Rosch-197F, you won't be able to activate it. Shouldn't we be checking for case all the way? Cheers, David |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X