Menu
▾
▴
phpesp-devel — Discussion of the development of phpESP
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
(103) |
Apr
(37) |
May
(45) |
Jun
(49) |
Jul
(55) |
Aug
(11) |
Sep
(47) |
Oct
(55) |
Nov
(47) |
Dec
(8) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(43) |
Feb
(85) |
Mar
(121) |
Apr
(37) |
May
(33) |
Jun
(33) |
Jul
(14) |
Aug
(34) |
Sep
(58) |
Oct
(68) |
Nov
(31) |
Dec
(9) |
| 2004 |
Jan
(13) |
Feb
(57) |
Mar
(37) |
Apr
(26) |
May
(57) |
Jun
(14) |
Jul
(8) |
Aug
(12) |
Sep
(32) |
Oct
(10) |
Nov
(7) |
Dec
(12) |
| 2005 |
Jan
(8) |
Feb
(25) |
Mar
(50) |
Apr
(20) |
May
(32) |
Jun
(20) |
Jul
(83) |
Aug
(25) |
Sep
(17) |
Oct
(14) |
Nov
(32) |
Dec
(27) |
| 2006 |
Jan
(24) |
Feb
(15) |
Mar
(46) |
Apr
(5) |
May
(6) |
Jun
(9) |
Jul
(12) |
Aug
(5) |
Sep
(7) |
Oct
(7) |
Nov
(4) |
Dec
(5) |
| 2007 |
Jan
(4) |
Feb
(1) |
Mar
(7) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(2) |
Sep
(2) |
Oct
|
Nov
(22) |
Dec
(19) |
| 2008 |
Jan
(94) |
Feb
(19) |
Mar
(32) |
Apr
(46) |
May
(20) |
Jun
(10) |
Jul
(11) |
Aug
(20) |
Sep
(16) |
Oct
(12) |
Nov
(13) |
Dec
|
| 2009 |
Jan
|
Feb
(9) |
Mar
(37) |
Apr
(65) |
May
(15) |
Jun
|
Jul
(24) |
Aug
(1) |
Sep
(8) |
Oct
(4) |
Nov
(21) |
Dec
(5) |
| 2010 |
Jan
(35) |
Feb
(6) |
Mar
(8) |
Apr
|
May
(4) |
Jun
(3) |
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(4) |
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
|
From: SourceForge.net <no...@so...> - 2004-04-06 22:02:49
|
Bugs item #930450, was opened at 2004-04-06 08:48 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=930450&group_id=8956 Category: Admin Group: v1.6.1 Status: Open Resolution: None Priority: 5 Submitted By: Christopher Kolar (ckolar) Assigned to: Nobody/Anonymous (nobody) Summary: resp acct exp date problem Initial Comment: Hi. I'm not sure if this is just a display problem or not. I have a respondent account set up and I wanted it to expire on April 15 so I set it up and everything worked fine. Today I decided to extend the survey so I went into the manage respondent accounts screen to change the date. The values in the box looked funny. I put in 2004, 5, 1 in the three boxes for May 1, saved the info, and then went back to look at it. The respondent editor screen now has the values 2004 -0 5- in the three boxes. I'm not sure if my settings took and this just a display problem, or if there is something going on in the code (maybe getting the day/months slots out of order). Anyway, thought you should know. In this case it will not be a problem to manually shut down the survey when the time comes. Cheers, --chris ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=930450&group_id=8956 |
|
From: - 2004-04-02 17:01:24
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>µL¼ÐÃD¤å¥ó</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>
<body>
<div id="Layer1" style="position:absolute; left:2px; top:2px; width:620px; height:569px; z-index:1"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_1.gif" width="101" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_2.gif" width="99" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_3.gif" width="100" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_4.gif" width="100" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_5.gif" width="101" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_6.gif" width="118" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_7.gif" width="101" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_8.gif" width="99" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_09.gif" width="100" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_10.gif" width="100" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_11.gif" width="101" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_12.gif" width="118" height="150"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_13.gif" width="101" height="200"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_14.gif" width="99" height="200"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_15.gif" width="100" height="200"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_16.gif" width="100" height="200"><a href="http://t988.com.tw/art/"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_17.gif" width="101" height="200" border="0"></a><a href="http://t988.com.tw/art/"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_18.gif" width="118" height="200" border="0"></a><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_19.gif" width="101" height="70"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_20.gif" width="99" height="70"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_21.gif" width="100" height="70"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_22.gif" width="100" height="70"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_23.gif" width="101" height="70"><img src="http://t988.com.tw/art/advimg/adv9/edm1-2_24.gif" width="118" height="70"></div>
</body>
</html>
|
|
From: Aaron A. <lt...@fr...> - 2004-03-23 20:49:44
|
It appears the problem only occurs when exportying to CSV file. I have indentified that the problem occurs if a survey skips the question after the Radio button question, then it produces the funky results when exporting to CSV. --- Aaron Axelsen Learning Technology Center UW - Whitewater |
|
From: Aaron A. <lt...@fr...> - 2004-03-23 20:30:16
|
Greetings, We are analyzing the results from a survey we have just ended. There was a question, of type radio button, with two possible answers of "Completed= " and "Did not enroll or complete". When looking at the CSV file, it prints either """Yes""" or """No""". There are also some entries that have "Com", "Comp","Did " Any suggestions as to what may have occured? .. i am out of ideas. --- Aaron Axelsen Learning Technology Center UW - Whitewater |
|
From: SourceForge.net <no...@so...> - 2004-03-23 18:31:51
|
Bugs item #903467, was opened at 2004-02-24 09:29 Message generated for change (Comment added) made by greggmc You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=903467&group_id=8956 Category: Admin Group: v1.6.1 >Status: Closed Resolution: None Priority: 5 Submitted By: David Klein (cadey) Assigned to: Nobody/Anonymous (nobody) Summary: About Authentication... Initial Comment: Hello, When I put $ESPCONFIG['auth_design'] = true in my phpESP.ini.php file, I always get 500 errors... Why ? I solved that by putting $ESPCONFIG['auth_design'] = false. But that's not an issue, I'm not able to identify different designers/groups now... I don't know anything about LDAP. Maybe I did something wrong in the configuration? Could you help me ? Thanks ! Cadey ---------------------------------------------------------------------- >Comment By: Matthew Gregg (greggmc) Date: 2004-03-23 13:31 Message: Logged In: YES user_id=14116 PHP is probably running as a CGI on the server running phpESP. Authentication will only function if PHP is running as an Apache module. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=903467&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2004-03-23 18:29:27
|
Bugs item #921806, was opened at 2004-03-23 10:23 Message generated for change (Comment added) made by greggmc You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=921806&group_id=8956 Category: User Group: v1.6.1 Status: Open Resolution: None Priority: 5 Submitted By: Erich Parzefall (erichelch) Assigned to: Nobody/Anonymous (nobody) Summary: Respondent accounts can't Login Initial Comment: I want to make an survey with an closed usergroup and put some Users in the Respondent Account Manager. If I try to connect as a respondent user I can't log in. I put this in an test.php (without # :-): #<?php $sid=4; include('handler-prefix.php'); ?> # <html> # <head><title></title></head> # <body> # <table border="0" width="800"> # <tr><td><?php include('example-sidebar.php'); ?></td> # <td><?php include('handler.php'); ?> # </td> # </tr> # <tr><td colspan="2"><p align="right"><font size="-2"> # Copyright © 2003. #Example.com</font></p></td></tr> # </table> # </body> # </html> The login-screen comes, but I can't login. What is wrong? ---------------------------------------------------------------------- >Comment By: Matthew Gregg (greggmc) Date: 2004-03-23 13:29 Message: Logged In: YES user_id=14116 Make sure the respondent user is in the same group as the survey. Also on the survey access page, click on the survey name and assign the same group to the survey. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=921806&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2004-03-23 17:02:22
|
Bugs item #921806, was opened at 2004-03-23 16:23 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=921806&group_id=8956 Category: User Group: v1.6.1 Status: Open Resolution: None Priority: 5 Submitted By: Erich Parzefall (erichelch) Assigned to: Nobody/Anonymous (nobody) Summary: Respondent accounts can't Login Initial Comment: I want to make an survey with an closed usergroup and put some Users in the Respondent Account Manager. If I try to connect as a respondent user I can't log in. I put this in an test.php (without # :-): #<?php $sid=4; include('handler-prefix.php'); ?> # <html> # <head><title></title></head> # <body> # <table border="0" width="800"> # <tr><td><?php include('example-sidebar.php'); ?></td> # <td><?php include('handler.php'); ?> # </td> # </tr> # <tr><td colspan="2"><p align="right"><font size="-2"> # Copyright © 2003. #Example.com</font></p></td></tr> # </table> # </body> # </html> The login-screen comes, but I can't login. What is wrong? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=921806&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2004-03-23 15:02:49
|
Bugs item #921737, was opened at 2004-03-23 09:45 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=921737&group_id=8956 Category: None Group: v1.6.1 Status: Open Resolution: None Priority: 5 Submitted By: Daniel de Carvalho Gomes (dcgomes) Assigned to: Nobody/Anonymous (nobody) Summary: As stated in /docs/TRANSLATION Initial Comment: I think there's a pt_BR bug with gettext due to te "GNU Gettext test: %%%% Gettext Test Failed", just as stated in /docs/TRANSLATION, here's the track : PHP Information Version: 4.3.4 OS: Linux SAPI: apache register_globals: No magic_quotes_gpc: Yes magic_quotes_runtime: No safe_mode: No open_basedir: PHP Extensions dBase: No GD: No GNU Gettext: Yes LDAP: No MySQL: Yes PHP Extension Dir (compiled): /usr/local/lib/php/extensions/no-debug-non-zts-20020429 PHP Extension Dir (run time): ./ phpESP Settings Expected ESP_BASE: /usr/local/apache/htdocs/phpESP/ Expected base_url: http://10.31.1.123/phpESP/ Loading phpESP.ini.php ... ESP_BASE: /usr/local/apache/htdocs/phpESP/ base_url: http://10.31.1.123/phpESP/ Version: 1.6.1 Debug: No phpESP Language Settings GNU Gettext: Real default_lang: en_US current lang: pt_PT available langs: da_DK, de_DE, el_GR, en_US, es_ES, fr_FR, ja_JP, it_IT, nl_NL, pt_BR, pt_PT, sv_SE (da, de, el, en, es, fr, it, ja, nl, pt, sv) GNU Gettext test: %%%% Gettext Test Failed Catalog Open Test: Yes PHP Session Test session.save_path: /tmp Counter: 1 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=921737&group_id=8956 |
|
From: Matthew G. <gr...@mu...> - 2004-03-18 17:57:07
|
The ADOdb port is now at a point where folks that are interested in
seeing/testing it, can have at it. It is available here[1]. You'll
need to install ADOdb[2] as well.
I didn't go the route of my previous posts(breaking out all the SQL
calls into includes), but instead was able to use the exist SQL with
ADOdb abstraction.
Several new options have been added to phpesp.ini.php that need to be
configured.
// ADODB
$ESPCONFIG['adodb_path'] = '/usr/share/adodb/';
^-should point to where your ADOdb is installed
$ESPCONFIG['adodb_database_type'] = 'mysql';
^-mysql, postgres, sqlite
$ESPCONFIG['adodb_dbpersist'] = 'true';
^-use persistent DB connections
$ESPCONFIG['adodb_pathto_db'] = "/var/www/phpESP/scripts/db/esp.dbm";
^- if you are using sqlite, where is the database located.
I've added populate scripts for postgresql and sqlite:
mysql:
- mysql -u root -p < scripts/db/mysql_create.sql
- mysql -u root -p phpesp < scripts/db/mysql_populate.sql
postgresql:
- psql -U youruser -h yourhost phpesp
< scripts/db/postgres_populate.sql
sqlite:
- sqlite esp.dbm < scripts/db/sqlite_populate.sql
- esp.dbm needs to be read/write and the directory it's located in
also needs read/write by your Apache user.
Known bugs:
When using sqlite question ordering only works one way
Unknown bugs:
Probably many.
TODO:
More code cleanup and testing.
Decide if we should include ADOdb with phpESP.
Please download, install, test and comment.
Thanks.
[1] http://bfs.itlab.musc.edu/~greggmc/devel/phpESP/phpesp_adodb.tar.gz
[2] http://php.weblogs.com/ADODB
--
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|
|
From: SourceForge.net <no...@so...> - 2004-03-14 23:22:36
|
Feature Requests item #903203, was opened at 2004-02-23 19:56 Message generated for change (Comment added) made by liontooth You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=903203&group_id=8956 Category: None Group: None >Status: Closed Priority: 5 Submitted By: David Liontooth (liontooth) Assigned to: Nobody/Anonymous (nobody) Summary: Comma-delimited export problem Initial Comment: Surveys can include text boxes, and the text entered may include commas. This is currently not handled in any special way -- in contrast, quotation marks within entered text is escaped. Could we get tab-delimited export instead, or some consistent way of handling internal commas? Cheers, David ---------------------------------------------------------------------- >Comment By: David Liontooth (liontooth) Date: 2004-03-14 15:20 Message: Logged In: YES user_id=897748 Internal commas are handled fine -- let's close this. Tab-delimited would be a nice feature, but my needs at the moment are met. ---------------------------------------------------------------------- Comment By: Matthew Gregg (greggmc) Date: 2004-02-24 07:12 Message: Logged In: YES user_id=14116 Changing this to a feature request. Current CSV export of data isn't broken with respect to it's handling of commas. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=903203&group_id=8956 |
|
From: Matthew G. <gr...@mu...> - 2004-03-12 23:16:07
|
Yup, I compared ADODB and PEAR. ADODB seemed to have the advantage in
speed and DB support.
On Fri, 2004-03-12 at 17:14, Charlie Smith wrote:
> I'd be glad to do what I am able. aDid you attempt a PEAR port or
> look into how that might work? I imagine you found the same types of
> issues with queries utilizing empty string/nulls, functions
> (password() now(), etc), bit manipulation?
>=20
> >>> "Matthew Gregg" <gr...@mu...> 03/12/04 02:35PM >>>
> Oh, and once we have mysql,sqlite,postrgres working, it should be
> relatively easy to do the Oracle port. And since I don't have access
> to
> an Oracle DB, I'll need your help a good bit with that port.
>=20
> btw: The files you've given me have helped a good deal with what I've
> done so far.
>=20
> On Fri, 2004-03-12 at 15:56, Charlie Smith wrote:
> > Matthew:
> > Where I gave you a ported phpESP to Oracle with abstracted oracle
> > function calls, wouldn't you be able to include Oracle as one of the
> > supported DB's?
> > =20
> > To answer your query about abstracting DB queries. THe idea of a
> hash
> > sounds ok. I'm not sure you'd need to have the hash for all
> queries.=20
> > Most of the queries between MySql and Oracle work against either DB.
> I
> > noticed that ones using bit manipulation and a few that use the
> empty
> > string had to be converted, but most went straight accross. If
> there
> > is only a small subset of queries that have to be modified to work
> > under different DB's perhaps these could be isolated rather than
> > rewriting all the queries.
> > =20
> > Are you finding that most queries require modification to run agains
> > all proposed DB's?
> >=20
> > >>> "Matthew Gregg" <gr...@mu...> 03/12/04 12:48PM >>>
> > I was thinking more along the lines of a separate include file per
> DB.
> > Each file contains all the SQL logic for the selected DB. Each SQL
> > statement would be contained in a hash and access by a single
> function
> > that is passed the key.
> >=20
> > include/lib/espsql_mysql.inc would contain something like this:
> > $ESPSQL['admdesigner_delete_designer'] =3D "DELETE FROM
> > ".$GLOBALS['ESPCONFIG']['designer_table']." WHERE username=3D$u AND
> > realm=3D$r";
> >=20
> > then accessed as:
> > $sql =3D eval(getSQL("admdesigner_delete_designer"));
> >=20
> > On Thu, 2004-03-11 at 22:03, Ajay Patil wrote:
> > > Dear Matthew,
> > >=20
> > > I have subscribed to this list but it is my first time to post a=20
> > > message. I am sorry for not making any useful contribution=20
> > > towards PhpESP.
> > >=20
> > > I have a suggestion about the switch for SQL calls for different
> > DBS.
> > >=20
> > > Perhaps, we can define all SQL calls in an properties file (or
> XML).
> > > Example:
> > > SQL_Queries.properties.
> > > ADD_QUESTION_SQL =3D "INSERT ...."
> > > DELETE_QUESTION_SQL =3D "DELETE ..."
> > >=20
> > > The application can read the SQL queries needed from the property
> > file.
> > > $sql =3D getSQL("ADD_QUESTION_SQL");=20
> > >=20
> > > This approach is similar to internationalization.=20
> > > We can keep a separate file for each target database.
> > >=20
> > > I wonder if others have a better idea.
> > >=20
> > > Ajay
> > >=20
> > > -----------------------------------------------------------------
> > > =C3=83=C2=A5=C3=82=C2=B7=C3=82=C2=AE=C3=83=C2=A5=C3=A2=E2=82=AC=C2=A1=
=C3=82=C2=BA=C3=83=C2=A4=C3=82=C2=BA=C3=82=C2=BA Matthew Gregg <greggmc@=
musc.edu>=20
> > > =C3=83=C2=A9=C3=A2=E2=80=9A=C2=AC=C3=82=C2=81=C3=83=C2=A4=C3=82=C2=BF=
=C3=82=C2=A1=C3=83=C2=A6=C3=A2=E2=82=AC=E2=80=9D=C3=82=C2=A5=C3=83=C2=A6=C3=
=A2=E2=80=9E=C2=A2=C3=A2=E2=82=AC=C5=A1 2004=C3=83=C2=A5=C3=82=C2=B9=C3=82=
=C2=B43=C3=83=C2=A6=C3=85=E2=80=9C=C3=8B=E2=80=A012=C3=83=C2=A6=C3=A2=E2=82=
=AC=E2=80=9D=C3=82=C2=A5
> (=C3=83=C2=A9=C3=A2=E2=82=AC=C2=A1=C3=A2=E2=82=AC=CB=9C) =C3=83=C2=A5=C3=
=82=C2=8D=C3=8B=E2=80=A0=C3=83=C2=A5=C3=A2=E2=82=AC=C2=B0=C3=82=C2=8D 11:=
14=20
> > > =C3=83=C2=A5=C3=82=C2=AE=C3=A2=E2=82=AC=C2=BA=C3=83=C2=A5=C3=A2=E2=82=
=AC=C2=A6=C3=8B=E2=80=A0 phpESP-devel <php...@li...=
t>=20
> > > =C3=83=C2=A4=C3=82=C2=BB=C3=82=C2=B6=C3=83=C2=A5=C3=82=C2=90=C3=82=C2=
=8D [phpesp-dev] adodb port question.=20
> > >=20
> > > I've been slowly converting ESP over to us the ADODB[1] library
> > > targeting mysql, postgres and sqlite as supported DB's.
> > >=20
> > > I had hoped that adodb would provide enough DB abstraction that it
> > would
> > > be possible to do the port just by replacing the native php mysql
> > > functions and SQL bits, with adodb equivalents. I have
> approximately
> > > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> > to
> > > get all the DB's working I will need to replace all/most SQL calls
> > with
> > > a function that implements a switch based on the current DB and
> > returns
> > > SQL appropriate for it. So my question is.. does this sound like
> the
> > > path I should take? Other suggestions?
> > >=20
> > >
> >
> ______________________________________________________________________
> > > From: Matthew Gregg <gr...@mu...>
> > > To: phpESP-devel <php...@li...>
> > > Subject: [phpesp-dev] adodb port question.
> > > Date: Wed, 31 Dec 1969 23:59:59 +0000
> > >=20
> > > I've been slowly converting ESP over to us the ADODB[1] library
> > > targeting mysql, postgres and sqlite as supported DB's.
> > >=20
> > > I had hoped that adodb would provide enough DB abstraction that it
> > would
> > > be possible to do the port just by replacing the native php mysql
> > > functions and SQL bits, with adodb equivalents. I have
> > approximately
> > > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> > to
> > > get all the DB's working I will need to replace all/most SQL calls
> > with
> > > a function that implements a switch based on the current DB and
> > returns
> > > SQL appropriate for it. So my question is.. does this sound like
> > the
> > > path I should take? Other suggestions?
> > >=20
> > > [1] http://php.weblogs.com/ADODB
> > --=20
> > mcg
> > -------------------------------------
> > The IT Lab (http://www.itlab.musc.edu)
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: IBM Linux Tutorials
> > Free Linux tutorial presented by Daniel Robbins, President and CEO
> of
> > GenToo technologies. Learn everything from fundamentals to system
> > administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dclick
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> --=20
> mcg
> -------------------------------------
> The IT Lab (http://www.itlab.musc.edu)
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dclick
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|
|
From: Charlie S. <sm...@ld...> - 2004-03-12 22:27:05
|
I'd be glad to do what I am able. aDid you attempt a PEAR port or look =
into how that might work? I imagine you found the same types of issues =
with queries utilizing empty string/nulls, functions (password() now(), =
etc), bit manipulation?
>>> "Matthew Gregg" <gr...@mu...> 03/12/04 02:35PM >>>
Oh, and once we have mysql,sqlite,postrgres working, it should be
relatively easy to do the Oracle port. And since I don't have access to
an Oracle DB, I'll need your help a good bit with that port.
btw: The files you've given me have helped a good deal with what I've
done so far.
On Fri, 2004-03-12 at 15:56, Charlie Smith wrote:
> Matthew:
> Where I gave you a ported phpESP to Oracle with abstracted oracle
> function calls, wouldn't you be able to include Oracle as one of the
> supported DB's?
> =20
> To answer your query about abstracting DB queries. THe idea of a hash
> sounds ok. I'm not sure you'd need to have the hash for all queries.=20
> Most of the queries between MySql and Oracle work against either DB. I
> noticed that ones using bit manipulation and a few that use the empty
> string had to be converted, but most went straight accross. If there
> is only a small subset of queries that have to be modified to work
> under different DB's perhaps these could be isolated rather than
> rewriting all the queries.
> =20
> Are you finding that most queries require modification to run agains
> all proposed DB's?
>=20
> >>> "Matthew Gregg" <gr...@mu...> 03/12/04 12:48PM >>>
> I was thinking more along the lines of a separate include file per DB.
> Each file contains all the SQL logic for the selected DB. Each SQL
> statement would be contained in a hash and access by a single function
> that is passed the key.
>=20
> include/lib/espsql_mysql.inc would contain something like this:
> $ESPSQL['admdesigner_delete_designer'] =3D "DELETE FROM
> ".$GLOBALS['ESPCONFIG']['designer_table']." WHERE username=3D$u AND
> realm=3D$r";
>=20
> then accessed as:
> $sql =3D eval(getSQL("admdesigner_delete_designer"));
>=20
> On Thu, 2004-03-11 at 22:03, Ajay Patil wrote:
> > Dear Matthew,
> >=20
> > I have subscribed to this list but it is my first time to post a=20
> > message. I am sorry for not making any useful contribution=20
> > towards PhpESP.
> >=20
> > I have a suggestion about the switch for SQL calls for different
> DBS.
> >=20
> > Perhaps, we can define all SQL calls in an properties file (or XML).
> > Example:
> > SQL_Queries.properties.
> > ADD_QUESTION_SQL =3D "INSERT ...."
> > DELETE_QUESTION_SQL =3D "DELETE ..."
> >=20
> > The application can read the SQL queries needed from the property
> file.
> > $sql =3D getSQL("ADD_QUESTION_SQL");=20
> >=20
> > This approach is similar to internationalization.=20
> > We can keep a separate file for each target database.
> >=20
> > I wonder if others have a better idea.
> >=20
> > Ajay
> >=20
> > -----------------------------------------------------------------
> > =C3=A5=C2=B7=C2=AE=C3=A5=E2=80=A1=C2=BA=C3=A4=C2=BA=C2=BA Matthew =
Gregg <gr...@mu...>=20
> > =C3=A9=E2**=C2 =C3=A4=C2=BF=C2=A1=C3 =E2=80"=C2=A5=C3 =E2*=A2=E2=80* =
2004=C3=A5=C2=B9=C2 3=C3 =C5"=CB*12=C3 =E2=80"=C2=A5 (=C3=A9=E2=80=A1=E2=80=
*) =C3=A5=C2 =CB*=C3=A5=E2=80=B0=C2 11:14=20
> > =C3=A5=C2=AE=E2=80=BA=C3=A5=E2=80 =CB* phpESP-devel <phpesp-devel@list=
s.sourceforge.net>=20
> > =C3=A4=C2=BB=C2=B6=C3=A5=C2 =C2 [phpesp-dev] adodb port question.=20
> >=20
> > I've been slowly converting ESP over to us the ADODB[1] library
> > targeting mysql, postgres and sqlite as supported DB's.
> >=20
> > I had hoped that adodb would provide enough DB abstraction that it
> would
> > be possible to do the port just by replacing the native php mysql
> > functions and SQL bits, with adodb equivalents. I have approximately
> > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> to
> > get all the DB's working I will need to replace all/most SQL calls
> with
> > a function that implements a switch based on the current DB and
> returns
> > SQL appropriate for it. So my question is.. does this sound like the
> > path I should take? Other suggestions?
> >=20
> >
> ______________________________________________________________________
> > From: Matthew Gregg <gr...@mu...>
> > To: phpESP-devel <php...@li...>
> > Subject: [phpesp-dev] adodb port question.
> > Date: Wed, 31 Dec 1969 23:59:59 +0000
> >=20
> > I've been slowly converting ESP over to us the ADODB[1] library
> > targeting mysql, postgres and sqlite as supported DB's.
> >=20
> > I had hoped that adodb would provide enough DB abstraction that it
> would
> > be possible to do the port just by replacing the native php mysql
> > functions and SQL bits, with adodb equivalents. I have
> approximately
> > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> to
> > get all the DB's working I will need to replace all/most SQL calls
> with
> > a function that implements a switch based on the current DB and
> returns
> > SQL appropriate for it. So my question is.. does this sound like
> the
> > path I should take? Other suggestions?
> >=20
> > [1] http://php.weblogs.com/ADODB=20
> --=20
> mcg
> -------------------------------------
> The IT Lab (http://www.itlab.musc.edu)
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id 70&alloc_id638&op=3Dclick
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id 70&alloc_id638&op=3Dclick
_______________________________________________
phpESP-devel mailing list
php...@li...=20
https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
|
|
From: Matthew G. <gr...@mu...> - 2004-03-12 21:46:48
|
Oh, and once we have mysql,sqlite,postrgres working, it should be
relatively easy to do the Oracle port. And since I don't have access to
an Oracle DB, I'll need your help a good bit with that port.
btw: The files you've given me have helped a good deal with what I've
done so far.
On Fri, 2004-03-12 at 15:56, Charlie Smith wrote:
> Matthew:
> Where I gave you a ported phpESP to Oracle with abstracted oracle
> function calls, wouldn't you be able to include Oracle as one of the
> supported DB's?
> =20
> To answer your query about abstracting DB queries. THe idea of a hash
> sounds ok. I'm not sure you'd need to have the hash for all queries.=20
> Most of the queries between MySql and Oracle work against either DB. I
> noticed that ones using bit manipulation and a few that use the empty
> string had to be converted, but most went straight accross. If there
> is only a small subset of queries that have to be modified to work
> under different DB's perhaps these could be isolated rather than
> rewriting all the queries.
> =20
> Are you finding that most queries require modification to run agains
> all proposed DB's?
>=20
> >>> "Matthew Gregg" <gr...@mu...> 03/12/04 12:48PM >>>
> I was thinking more along the lines of a separate include file per DB.
> Each file contains all the SQL logic for the selected DB. Each SQL
> statement would be contained in a hash and access by a single function
> that is passed the key.
>=20
> include/lib/espsql_mysql.inc would contain something like this:
> $ESPSQL['admdesigner_delete_designer'] =3D "DELETE FROM
> ".$GLOBALS['ESPCONFIG']['designer_table']." WHERE username=3D$u AND
> realm=3D$r";
>=20
> then accessed as:
> $sql =3D eval(getSQL("admdesigner_delete_designer"));
>=20
> On Thu, 2004-03-11 at 22:03, Ajay Patil wrote:
> > Dear Matthew,
> >=20
> > I have subscribed to this list but it is my first time to post a=20
> > message. I am sorry for not making any useful contribution=20
> > towards PhpESP.
> >=20
> > I have a suggestion about the switch for SQL calls for different
> DBS.
> >=20
> > Perhaps, we can define all SQL calls in an properties file (or XML).
> > Example:
> > SQL_Queries.properties.
> > ADD_QUESTION_SQL =3D "INSERT ...."
> > DELETE_QUESTION_SQL =3D "DELETE ..."
> >=20
> > The application can read the SQL queries needed from the property
> file.
> > $sql =3D getSQL("ADD_QUESTION_SQL");=20
> >=20
> > This approach is similar to internationalization.=20
> > We can keep a separate file for each target database.
> >=20
> > I wonder if others have a better idea.
> >=20
> > Ajay
> >=20
> > -----------------------------------------------------------------
> > =C3=A5=C2=B7=C2=AE=C3=A5=E2=80=A1=C2=BA=C3=A4=C2=BA=C2=BA Matthew Gr=
egg <gr...@mu...>=20
> > =C3=A9=E2=82=AC=C2=81=C3=A4=C2=BF=C2=A1=C3=A6=E2=80=94=C2=A5=C3=A6=E2=
=84=A2=E2=80=9A 2004=C3=A5=C2=B9=C2=B43=C3=A6=C5=93=CB=8612=C3=A6=E2=80=94=
=C2=A5 (=C3=A9=E2=80=A1=E2=80=98) =C3=A5=C2=8D=CB=86=C3=A5=E2=80=B0=C2=8D=
11:14=20
> > =C3=A5=C2=AE=E2=80=BA=C3=A5=E2=80=A6=CB=86 phpESP-devel <phpesp-deve=
l...@li...>=20
> > =C3=A4=C2=BB=C2=B6=C3=A5=C2=90=C2=8D [phpesp-dev] adodb port questio=
n.=20
> >=20
> > I've been slowly converting ESP over to us the ADODB[1] library
> > targeting mysql, postgres and sqlite as supported DB's.
> >=20
> > I had hoped that adodb would provide enough DB abstraction that it
> would
> > be possible to do the port just by replacing the native php mysql
> > functions and SQL bits, with adodb equivalents. I have approximately
> > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> to
> > get all the DB's working I will need to replace all/most SQL calls
> with
> > a function that implements a switch based on the current DB and
> returns
> > SQL appropriate for it. So my question is.. does this sound like the
> > path I should take? Other suggestions?
> >=20
> >
> ______________________________________________________________________
> > From: Matthew Gregg <gr...@mu...>
> > To: phpESP-devel <php...@li...>
> > Subject: [phpesp-dev] adodb port question.
> > Date: Wed, 31 Dec 1969 23:59:59 +0000
> >=20
> > I've been slowly converting ESP over to us the ADODB[1] library
> > targeting mysql, postgres and sqlite as supported DB's.
> >=20
> > I had hoped that adodb would provide enough DB abstraction that it
> would
> > be possible to do the port just by replacing the native php mysql
> > functions and SQL bits, with adodb equivalents. I have
> approximately
> > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> to
> > get all the DB's working I will need to replace all/most SQL calls
> with
> > a function that implements a switch based on the current DB and
> returns
> > SQL appropriate for it. So my question is.. does this sound like
> the
> > path I should take? Other suggestions?
> >=20
> > [1] http://php.weblogs.com/ADODB
> --=20
> mcg
> -------------------------------------
> The IT Lab (http://www.itlab.musc.edu)
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dclick
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|
|
From: Matthew G. <gr...@mu...> - 2004-03-12 21:41:31
|
Problem cases involve anywhere interactions with: auto-increment,
timestamp/date, password fields and bit manipulations. I've also tried
to take into consideration various ways DB's handle/represent NULL.
What I've done so far is to put a adodb function or my own "wrapper"
round any database specific calls to these types of functions. This
appeared to work ok with mysql and sqlite. Adding postgres created some
difficulties. Having done that, I think it looks cleaner to go the
separate file method I've mentioned. I also think it would provide more
flexibility if folks want to port to other DB's.
=20
On Fri, 2004-03-12 at 15:56, Charlie Smith wrote:
> Matthew:
> Where I gave you a ported phpESP to Oracle with abstracted oracle
> function calls, wouldn't you be able to include Oracle as one of the
> supported DB's?
> =20
> To answer your query about abstracting DB queries. THe idea of a hash
> sounds ok. I'm not sure you'd need to have the hash for all queries.=20
> Most of the queries between MySql and Oracle work against either DB. I
> noticed that ones using bit manipulation and a few that use the empty
> string had to be converted, but most went straight accross. If there
> is only a small subset of queries that have to be modified to work
> under different DB's perhaps these could be isolated rather than
> rewriting all the queries.
> =20
> Are you finding that most queries require modification to run agains
> all proposed DB's?
>=20
> >>> "Matthew Gregg" <gr...@mu...> 03/12/04 12:48PM >>>
> I was thinking more along the lines of a separate include file per DB.
> Each file contains all the SQL logic for the selected DB. Each SQL
> statement would be contained in a hash and access by a single function
> that is passed the key.
>=20
> include/lib/espsql_mysql.inc would contain something like this:
> $ESPSQL['admdesigner_delete_designer'] =3D "DELETE FROM
> ".$GLOBALS['ESPCONFIG']['designer_table']." WHERE username=3D$u AND
> realm=3D$r";
>=20
> then accessed as:
> $sql =3D eval(getSQL("admdesigner_delete_designer"));
>=20
> On Thu, 2004-03-11 at 22:03, Ajay Patil wrote:
> > Dear Matthew,
> >=20
> > I have subscribed to this list but it is my first time to post a=20
> > message. I am sorry for not making any useful contribution=20
> > towards PhpESP.
> >=20
> > I have a suggestion about the switch for SQL calls for different
> DBS.
> >=20
> > Perhaps, we can define all SQL calls in an properties file (or XML).
> > Example:
> > SQL_Queries.properties.
> > ADD_QUESTION_SQL =3D "INSERT ...."
> > DELETE_QUESTION_SQL =3D "DELETE ..."
> >=20
> > The application can read the SQL queries needed from the property
> file.
> > $sql =3D getSQL("ADD_QUESTION_SQL");=20
> >=20
> > This approach is similar to internationalization.=20
> > We can keep a separate file for each target database.
> >=20
> > I wonder if others have a better idea.
> >=20
> > Ajay
> >=20
> > -----------------------------------------------------------------
> > =C3=A5=C2=B7=C2=AE=C3=A5=E2=80=A1=C2=BA=C3=A4=C2=BA=C2=BA Matthew Gr=
egg <gr...@mu...>=20
> > =C3=A9=E2=82=AC=C2=81=C3=A4=C2=BF=C2=A1=C3=A6=E2=80=94=C2=A5=C3=A6=E2=
=84=A2=E2=80=9A 2004=C3=A5=C2=B9=C2=B43=C3=A6=C5=93=CB=8612=C3=A6=E2=80=94=
=C2=A5 (=C3=A9=E2=80=A1=E2=80=98) =C3=A5=C2=8D=CB=86=C3=A5=E2=80=B0=C2=8D=
11:14=20
> > =C3=A5=C2=AE=E2=80=BA=C3=A5=E2=80=A6=CB=86 phpESP-devel <phpesp-deve=
l...@li...>=20
> > =C3=A4=C2=BB=C2=B6=C3=A5=C2=90=C2=8D [phpesp-dev] adodb port questio=
n.=20
> >=20
> > I've been slowly converting ESP over to us the ADODB[1] library
> > targeting mysql, postgres and sqlite as supported DB's.
> >=20
> > I had hoped that adodb would provide enough DB abstraction that it
> would
> > be possible to do the port just by replacing the native php mysql
> > functions and SQL bits, with adodb equivalents. I have approximately
> > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> to
> > get all the DB's working I will need to replace all/most SQL calls
> with
> > a function that implements a switch based on the current DB and
> returns
> > SQL appropriate for it. So my question is.. does this sound like the
> > path I should take? Other suggestions?
> >=20
> >
> ______________________________________________________________________
> > From: Matthew Gregg <gr...@mu...>
> > To: phpESP-devel <php...@li...>
> > Subject: [phpesp-dev] adodb port question.
> > Date: Wed, 31 Dec 1969 23:59:59 +0000
> >=20
> > I've been slowly converting ESP over to us the ADODB[1] library
> > targeting mysql, postgres and sqlite as supported DB's.
> >=20
> > I had hoped that adodb would provide enough DB abstraction that it
> would
> > be possible to do the port just by replacing the native php mysql
> > functions and SQL bits, with adodb equivalents. I have
> approximately
> > 99% working in mysql, 70% sqlite, 10% postgres and it appears that
> to
> > get all the DB's working I will need to replace all/most SQL calls
> with
> > a function that implements a switch based on the current DB and
> returns
> > SQL appropriate for it. So my question is.. does this sound like
> the
> > path I should take? Other suggestions?
> >=20
> > [1] http://php.weblogs.com/ADODB
> --=20
> mcg
> -------------------------------------
> The IT Lab (http://www.itlab.musc.edu)
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dclick
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|
|
From: Charlie S. <sm...@ld...> - 2004-03-12 21:08:13
|
Matthew:
Where I gave you a ported phpESP to Oracle with abstracted oracle function =
calls, wouldn't you be able to include Oracle as one of the supported =
DB's?
=20
To answer your query about abstracting DB queries. THe idea of a hash =
sounds ok. I'm not sure you'd need to have the hash for all queries. =
Most of the queries between MySql and Oracle work against either DB. I =
noticed that ones using bit manipulation and a few that use the empty =
string had to be converted, but most went straight accross. If there is =
only a small subset of queries that have to be modified to work under =
different DB's perhaps these could be isolated rather than rewriting all =
the queries.
=20
Are you finding that most queries require modification to run agains all =
proposed DB's?
>>> "Matthew Gregg" <gr...@mu...> 03/12/04 12:48PM >>>
I was thinking more along the lines of a separate include file per DB.
Each file contains all the SQL logic for the selected DB. Each SQL
statement would be contained in a hash and access by a single function
that is passed the key.
include/lib/espsql_mysql.inc would contain something like this:
$ESPSQL['admdesigner_delete_designer'] =3D "DELETE FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE username=3D$u AND
realm=3D$r";
then accessed as:
$sql =3D eval(getSQL("admdesigner_delete_designer"));
On Thu, 2004-03-11 at 22:03, Ajay Patil wrote:
> Dear Matthew,
>=20
> I have subscribed to this list but it is my first time to post a=20
> message. I am sorry for not making any useful contribution=20
> towards PhpESP.
>=20
> I have a suggestion about the switch for SQL calls for different DBS.
>=20
> Perhaps, we can define all SQL calls in an properties file (or XML).
> Example:
> SQL_Queries.properties.
> ADD_QUESTION_SQL =3D "INSERT ...."
> DELETE_QUESTION_SQL =3D "DELETE ..."
>=20
> The application can read the SQL queries needed from the property file.
> $sql =3D getSQL("ADD_QUESTION_SQL");=20
>=20
> This approach is similar to internationalization.=20
> We can keep a separate file for each target database.
>=20
> I wonder if others have a better idea.
>=20
> Ajay
>=20
> -----------------------------------------------------------------
> =E5=B7=AE=E5*=BA=E4=BA=BA Matthew Gregg <gr...@mu...>=20
> =E9=80 =E4=BF=A1=E6*=A5=E6** 2004=E5=B9 3=E6**12=E6*=A5 (=E9*') =E5 =
*=E5* 11:14=20
> =E5=AE*=E5** phpESP-devel <php...@li...>=20
> =E4=BB=B6=E5 [phpesp-dev] adodb port question.=20
>=20
> I've been slowly converting ESP over to us the ADODB[1] library
> targeting mysql, postgres and sqlite as supported DB's.
>=20
> I had hoped that adodb would provide enough DB abstraction that it would
> be possible to do the port just by replacing the native php mysql
> functions and SQL bits, with adodb equivalents. I have approximately
> 99% working in mysql, 70% sqlite, 10% postgres and it appears that to
> get all the DB's working I will need to replace all/most SQL calls with
> a function that implements a switch based on the current DB and returns
> SQL appropriate for it. So my question is.. does this sound like the
> path I should take? Other suggestions?
>=20
> ______________________________________________________________________
> From: Matthew Gregg <gr...@mu...>
> To: phpESP-devel <php...@li...>
> Subject: [phpesp-dev] adodb port question.
> Date: Wed, 31 Dec 1969 23:59:59 +0000
>=20
> I've been slowly converting ESP over to us the ADODB[1] library
> targeting mysql, postgres and sqlite as supported DB's.
>=20
> I had hoped that adodb would provide enough DB abstraction that it would
> be possible to do the port just by replacing the native php mysql
> functions and SQL bits, with adodb equivalents. I have approximately
> 99% working in mysql, 70% sqlite, 10% postgres and it appears that to
> get all the DB's working I will need to replace all/most SQL calls with
> a function that implements a switch based on the current DB and returns
> SQL appropriate for it. So my question is.. does this sound like the
> path I should take? Other suggestions?
>=20
> [1] http://php.weblogs.com/ADODB=20
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id 70&alloc_id638&op=3Dclick
_______________________________________________
phpESP-devel mailing list
php...@li...=20
https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
|
|
From: Matthew G. <gr...@mu...> - 2004-03-12 19:59:18
|
I was thinking more along the lines of a separate include file per DB.
Each file contains all the SQL logic for the selected DB. Each SQL
statement would be contained in a hash and access by a single function
that is passed the key.
include/lib/espsql_mysql.inc would contain something like this:
$ESPSQL['admdesigner_delete_designer'] =3D "DELETE FROM
".$GLOBALS['ESPCONFIG']['designer_table']." WHERE username=3D$u AND
realm=3D$r";
then accessed as:
$sql =3D eval(getSQL("admdesigner_delete_designer"));
On Thu, 2004-03-11 at 22:03, Ajay Patil wrote:
> Dear Matthew,
>=20
> I have subscribed to this list but it is my first time to post a=20
> message. I am sorry for not making any useful contribution=20
> towards PhpESP.
>=20
> I have a suggestion about the switch for SQL calls for different DBS.
>=20
> Perhaps, we can define all SQL calls in an properties file (or XML).
> Example:
> SQL_Queries.properties.
> ADD_QUESTION_SQL =3D "INSERT ...."
> DELETE_QUESTION_SQL =3D "DELETE ..."
>=20
> The application can read the SQL queries needed from the property file.
> $sql =3D getSQL("ADD_QUESTION_SQL");=20
>=20
> This approach is similar to internationalization.=20
> We can keep a separate file for each target database.
>=20
> I wonder if others have a better idea.
>=20
> Ajay
>=20
> -----------------------------------------------------------------
> =E5=B7=AE=E5=87=BA=E4=BA=BA Matthew Gregg <gr...@mu...>=20
> =E9=80=81=E4=BF=A1=E6=97=A5=E6=99=82 2004=E5=B9=B43=E6=9C=8812=E6=97=A5=
(=E9=87=91) =E5=8D=88=E5=89=8D 11:14=20
> =E5=AE=9B=E5=85=88 phpESP-devel <php...@li...>=20
> =E4=BB=B6=E5=90=8D [phpesp-dev] adodb port question.=20
>=20
> I've been slowly converting ESP over to us the ADODB[1] library
> targeting mysql, postgres and sqlite as supported DB's.
>=20
> I had hoped that adodb would provide enough DB abstraction that it woul=
d
> be possible to do the port just by replacing the native php mysql
> functions and SQL bits, with adodb equivalents. I have approximately
> 99% working in mysql, 70% sqlite, 10% postgres and it appears that to
> get all the DB's working I will need to replace all/most SQL calls with
> a function that implements a switch based on the current DB and returns
> SQL appropriate for it. So my question is.. does this sound like the
> path I should take? Other suggestions?
>=20
> ______________________________________________________________________
> From: Matthew Gregg <gr...@mu...>
> To: phpESP-devel <php...@li...>
> Subject: [phpesp-dev] adodb port question.
> Date: Wed, 31 Dec 1969 23:59:59 +0000
>=20
> I've been slowly converting ESP over to us the ADODB[1] library
> targeting mysql, postgres and sqlite as supported DB's.
>=20
> I had hoped that adodb would provide enough DB abstraction that it woul=
d
> be possible to do the port just by replacing the native php mysql
> functions and SQL bits, with adodb equivalents. I have approximately
> 99% working in mysql, 70% sqlite, 10% postgres and it appears that to
> get all the DB's working I will need to replace all/most SQL calls with
> a function that implements a switch based on the current DB and returns
> SQL appropriate for it. So my question is.. does this sound like the
> path I should take? Other suggestions?
>=20
> [1] http://php.weblogs.com/ADODB
--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)
|
|
From: Ajay P. <ap...@ve...> - 2004-03-12 02:58:18
|
Dear Matthew,
I have subscribed to this list but it is my first time to post a
message. I am sorry for not making any useful contribution
towards PhpESP.
I have a suggestion about the switch for SQL calls for different DBS.
Perhaps, we can define all SQL calls in an properties file (or XML).
Example:
SQL_Queries.properties.
ADD_QUESTION_SQL = "INSERT ...."
DELETE_QUESTION_SQL = "DELETE ..."
The application can read the SQL queries needed from the property file.
$sql = getSQL("ADD_QUESTION_SQL");
This approach is similar to internationalization.
We can keep a separate file for each target database.
I wonder if others have a better idea.
Ajay
-----------------------------------------------------------------
差出人 Matthew Gregg <gr...@mu...>
送信日時 2004年3月12日 (金) 午前 11:14
宛先 phpESP-devel <php...@li...>
件名 [phpesp-dev] adodb port question.
I've been slowly converting ESP over to us the ADODB[1] library
targeting mysql, postgres and sqlite as supported DB's.
I had hoped that adodb would provide enough DB abstraction that it would
be possible to do the port just by replacing the native php mysql
functions and SQL bits, with adodb equivalents. I have approximately
99% working in mysql, 70% sqlite, 10% postgres and it appears that to
get all the DB's working I will need to replace all/most SQL calls with
a function that implements a switch based on the current DB and returns
SQL appropriate for it. So my question is.. does this sound like the
path I should take? Other suggestions?
|
|
From: Matthew G. <gr...@mu...> - 2004-03-12 02:25:11
|
I've been slowly converting ESP over to us the ADODB[1] library targeting mysql, postgres and sqlite as supported DB's. I had hoped that adodb would provide enough DB abstraction that it would be possible to do the port just by replacing the native php mysql functions and SQL bits, with adodb equivalents. I have approximately 99% working in mysql, 70% sqlite, 10% postgres and it appears that to get all the DB's working I will need to replace all/most SQL calls with a function that implements a switch based on the current DB and returns SQL appropriate for it. So my question is.. does this sound like the path I should take? Other suggestions? [1] http://php.weblogs.com/ADODB -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: James E. F. <jf...@uv...> - 2004-03-11 03:27:58
|
I was completely unaware that the lists received any spam. (Yay SpamAssassin!) I will see what I can do about the lists. Remind me again in a few days if you still get spam on the list. -James Matthew Gregg wrote: > Can we get the ESP lists, subscriber submission only? Getting SPAM from > them, bugs me. I would make the change myself, but I don't have > permissions. > > On Wed, 2004-03-10 at 11:53, Clifton Glenn wrote: > >>Market Mover Stock Report's Last Pick (CWTD) exploded from $1.19 to >>$9.20, a gain of over 670% in 5 days (Feb 12 - 17)!!! --spam deleted-- |
|
From: SourceForge.net <no...@so...> - 2004-03-10 22:58:06
|
Feature Requests item #913770, was opened at 2004-03-10 16:48 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=913770&group_id=8956 Category: None Group: None Status: Open Priority: 5 Submitted By: Aaron Axelsen (axelseaa) Assigned to: Nobody/Anonymous (nobody) Summary: Anonymous Survey Results Initial Comment: It would be nice to have a way to have survey data submitted anonymous if it is the type of survey that asks for it. Becuase now, regardless of if the survey creator says the results will be kept anonymous, they can still be traced back and one can figure out who answered to what. Maybe a field can be flagged as anonymous, and stored in a different table and just have the respones connected to the survey? That way when the results are viewed, all the infomation is shown, without the anonymous field attached to the results. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=913770&group_id=8956 |
|
From: Matthew G. <gr...@mu...> - 2004-03-10 20:56:19
|
Can we get the ESP lists, subscriber submission only? Getting SPAM from them, bugs me. I would make the change myself, but I don't have permissions. On Wed, 2004-03-10 at 11:53, Clifton Glenn wrote: > Market Mover Stock Report's Last Pick (CWTD) exploded from $1.19 to > $9.20, a gain of over 670% in 5 days (Feb 12 - 17)!!! > > Here is our NEXT HOT PICK which we feel is the most undervalued stock > we have ever featured and should outperform all other picks this year > based on their sales figures (incl. a backlog of over $100 Million), > incredibly solid numbers, and low outstanding share total. > > Life Energy and Technology Holdings, Inc. > (OTCBB: LETH) > Current Price: 2.25 > Near-Term Target: 7.00 > Projected High for '04: 15.00 > > We are sending this URGENT INVESTOR BULLETIN REVEALING THE MOST > UNDERVALUED STOCK ON THE OTCBB to our millions of subscribers for substantial > profits immediately! > Sales orders received by LETH exceed $150 Million over the past year > while major news was just released that adds multi-millions to the bottom > line. LETH has experienced a recent spike in price and volume > indicating heavy accumulation of shares which is a sign of even bigger things to > come for this emerging world leader in the conversion of waste > materials into electrical energy, an industry with such high global demand that > it is impossible to assign a value to the size of the market. > > Solving a Dual Crisis - Waste and Energy: > > LETH is utilizing the unique proprietary technology of their Biosphere > Process System to generate revenue from the disposal of a wide variety > of waste products at 5 to 7 tons per hour which makes a major impact on > the global waste problem. This profitable and environmentally safe > process converts into clean, "green" electricity such waste materials as > Municipal Solid Waste, agricultural wastes, forestry wastes, medical > wastes, industrial wastes, sewage sludge, shale oil, sour natural gas, and > the huge market of used tires. LETH profits from the sale of > electricity created from the waste conversion on a continuous basis by generating > 5 to 10 mega-watts per hour of electricity which is then sold to > replenish the local or national grid. > > (Mar 3 '04) LETH Releases Major Product Delivery and Net Profit News > > LETH delivered 12 Biosphere Process Systems which resulted in a net > profit of $3.5 Million, the equivalent of .12 cents per share. LETH is > scheduled to receive an additional $7 Million translating into an > additional .24 cents per share which is the balance of this completed contract > over the next 6 months. The net profit per share from just this single > contract would value the stock above $6 by calculating the .36 cents > per share total at an average industry PE of 18 - 22. > > Examining LETH - By The Numbers: > > Total Assets: 36.8 Million = 1.26 per share of assets > Cash: 23.4 Million = .80 cents per share of cash > Shares Outstanding: 29 million (down from 31.8 million) after 2.8 > million shares retired in Feb. '04 > Additional Shares to be Retired: 1.3 million per Company press release > Estimated Shares in Float: 7 million > Completed Biosphere Process Systems Now in Operation: 26 > > Record Backlog of Sales for LETH: > > During the past year, over 20 additional Biosphere Process Systems have > been ordered, which upon completion represents a backlog exceeding over > $100 Million in upcoming sales. Many of these contractual agreements > include options for the purchase of additional Biosphere Systems in the > future once the initial order has been completed. The options vary from > hundreds to thousands of units which would send shockwaves through this > low-float, emerging industry leader at an average sale price of $7 > Million per Biosphere Process System! > > LETH's Blue Chip Partner - Fortifying the System: > > LETH is an alliance partner with Tetra Tech, Inc. (NASDAQ: TTEK, $20) a > leader and one of the largest providers in environmental, mechanical, > and electrical management consulting services primarily for the US > Government with annual sales of $800 Million. Tetra Tech will coordinate the > securing of necessary permits, installation, and continuous worldwide > monitoring of the Biosphere Process System for LETH. Tetra Tech is now > in the process of obtaining Department of Environmental Quality > permitting for the Biosphere Process in the state of Louisiana. This is a > monumental event for LETH which opens the floodgates for major project > revenues in Louisiana while having a parallel effect on LETH stock in the > form of a huge near-term announcement. > > Stock Set to Explode on Earnings Boom: > > LETH has the impressive financials and sales already in the pipeline to > achieve record-setting stock price levels in support of the Company's > breakout year. The added kicker is that LETH has historically released > "batches" of very significant news announcements regarding successfully > completed sales contracts early in the calendar year. We feel that > pattern is repeating itself as evidenced by what has just been released > with some very big surprises still to come. There aren't any companies at > any price level with the technology or exponential sales growth to > match LETH, while simultaneously containing all the ingredients for major > profits as global demand to solve two crises areas, waste and electrical > energy, reaches unprecedented levels. > > Required Market Mover Stock Report (MMSR) Information: MMSR cautions > that small and micro-cap stocks are high-risk investments and that some > or all investment dollars can be lost. We suggest you consult a > professional investment advisor before purchasing any stock. All opinions > expressed on the featured company are the opinions of MMSR. MMSR recommends > you use the information found here as an initial starting point for > conducting your own research and your own due diligence on the featured > company in order to determine your own personal opinion of the company > before investing. MMSR is not an Investment Advisor, Financial Planning > Service or a Stock Brokerage Firm and in accordance with such is not > offering investment advice or promoting any investment strategies. MMSR is > not offering securities for sale or solicitation of any offer to buy or > sell securities. MMSR has received twelve thousand dollars from an > unaffiliated third party for the preparation of this company profile. Since > we have received compensation there is an inherent conflict of interest > in our statements and opinions. Readers of this publication are > cautioned not to place undue reliance on forward looking statements, which are > based on certain assumptions and expectations involving various risks > and uncertainties, that could cause results to differ materially from > those set forth in the forward looking statements. > > v ijs hir e eq rzxtuunqwslbkweemz hfrqu pblvn cm > nsh > bvhxl hs > mvyjeph > wqnq a -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: Charlie S. <Sm...@ld...> - 2004-03-09 21:21:03
|
Is there a way to list multiple text boxes per question as in:
1. Enter your name:
*First Name ____________
*Last Name ____________
2....
Is there a way to make answers go horizontally across page rather than vertical
for check boxes as in:
3. Check appropriate box:
Speak Read Write
English
4.
Spanish
5.
French
|
|
From: Matthew G. <gr...@mu...> - 2004-03-09 20:16:49
|
Don't think that problem happens with ESP normally. Probably something introduced when you ported. On Tue, 2004-03-09 at 14:51, Charlie Smith wrote: > I noticed with my copy of phpESP, it appears as though questions with checkboxes > are not getting results stored to the DB. Is there a fix for this or am I off > on this one. I've converted the code to Oracle, but looks to me like to > processing is not quite right in the mkcheckbox() function. Also, in looking > at the source of the output HTML page, it shows two input check boxes with the > same name - number appended with '[]'. > > I'll be working on this in my version of the code, but am hoping this has been > noticed and fixed already. > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IBM Linux Tutorials > Free Linux tutorial presented by Daniel Robbins, President and CEO of > GenToo technologies. Learn everything from fundamentals to system > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: Charlie S. <Sm...@ld...> - 2004-03-09 20:01:17
|
I noticed with my copy of phpESP, it appears as though questions with checkboxes are not getting results stored to the DB. Is there a fix for this or am I off on this one. I've converted the code to Oracle, but looks to me like to processing is not quite right in the mkcheckbox() function. Also, in looking at the source of the output HTML page, it shows two input check boxes with the same name - number appended with '[]'. I'll be working on this in my version of the code, but am hoping this has been noticed and fixed already. |
|
From: SourceForge.net <no...@so...> - 2004-03-09 00:25:42
|
Feature Requests item #912382, was opened at 2004-03-08 19:16 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=912382&group_id=8956 Category: None Group: None Status: Open Priority: 5 Submitted By: Matthew Gregg (greggmc) Assigned to: Nobody/Anonymous (nobody) Summary: New Help Page Initial Comment: From Aaron Axelse Attached file should replace admin/include/where/help.inc ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=912382&group_id=8956 |
24 messages has been excluded from this view by a project administrator.
![http://t988.com.tw/art/advimg/adv9/edm1-2_1.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_1.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_2.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_2.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_3.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_3.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_4.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_4.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_5.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_5.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_6.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_6.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_7.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_7.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_8.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_8.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_09.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_09.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_10.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_10.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_11.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_11.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_12.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_12.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_13.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_13.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_14.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_14.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_15.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_15.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_16.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_16.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_17.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_17.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_18.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_18.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_19.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_19.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_20.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_20.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_21.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_21.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_22.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_22.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_23.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_23.gif"){kind=link}
![http://t988.com.tw/art/advimg/adv9/edm1-2_24.gif"](http://t988.com.tw/art/advimg/adv9/edm1-2_24.gif"){kind=link}