From thelist at jarmin.com  Mon Oct 15 03:54:45 2007
From: thelist at jarmin.com (iris)
Date: Mon, 15 Oct 2007 10:54:45 +0200
Subject: [thelist] how to protect downloadable docs in members only area
Message-ID: <47132AD5.10200@jarmin.com>

good morning everyone

i've got a website that has a password protected members' area (php 
login system).  physically the content is all located within a /members/ 
folder.  within this is a documents folder with word, powerpoint etc 
docs which can be downloaded from within the members' area (i.e. only if 
logged in).

however, if someone knew the exact location of a document 
(http://example.com/members/docs/example.doc) they could get to them 
without being logged in.

how do i protect these documents from unauthorised access?

i tried the htaccess file approach, passing the login instructions in 
the links, so that those logged in don't have to log in again. e.g.
<a href="http://username:password at example.com/members/docs/example.doc">
but i discovered that IE doesn't play nice if the security setting are 
set too high (middle being too high).  since the users of this site are 
mostly on university computers and might not have rights to change these 
settings, i've decided that this is a bad method.

has anybody got another solution for me?

also, are the documents save from search engines? (i don't really trust 
them to follow the instructions in robot.txt)

thank you so very much

iris



From beertastic at gmail.com  Mon Oct 15 04:00:48 2007
From: beertastic at gmail.com (Tris)
Date: Mon, 15 Oct 2007 10:00:48 +0100
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <47132AD5.10200@jarmin.com>
References: <47132AD5.10200@jarmin.com>
Message-ID: <8b20a7490710150200w3e5975ddv1680ebfee92c00b8@mail.gmail.com>

I used to keep the files outside of the www DIR... and then created a
downlaod page, (with a login checker) and then used the header()
function to asign the correct mime type and pass the file to the
user...

Does that makes sence?
it worked great for me, and no one could guess the URL direct to the
files, cuase there were none!

let me know if you need more info..

Tris...


On 15/10/2007, iris <thelist at jarmin.com> wrote:
> good morning everyone
>
> i've got a website that has a password protected members' area (php
> login system).  physically the content is all located within a /members/
> folder.  within this is a documents folder with word, powerpoint etc
> docs which can be downloaded from within the members' area (i.e. only if
> logged in).
>
> however, if someone knew the exact location of a document
> (http://example.com/members/docs/example.doc) they could get to them
> without being logged in.
>
> how do i protect these documents from unauthorised access?
>
> i tried the htaccess file approach, passing the login instructions in
> the links, so that those logged in don't have to log in again. e.g.
> <a href="http://username:password at example.com/members/docs/example.doc">
> but i discovered that IE doesn't play nice if the security setting are
> set too high (middle being too high).  since the users of this site are
> mostly on university computers and might not have rights to change these
> settings, i've decided that this is a bad method.
>
> has anybody got another solution for me?
>
> also, are the documents save from search engines? (i don't really trust
> them to follow the instructions in robot.txt)
>
> thank you so very much
>
> iris
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz


From sharrison at mzl.com  Mon Oct 15 04:04:07 2007
From: sharrison at mzl.com (Simon Harrison)
Date: Mon, 15 Oct 2007 10:04:07 +0100
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <8b20a7490710150200w3e5975ddv1680ebfee92c00b8@mail.gmail.com>
Message-ID: <030932EF7CC19F4A9E8FFC78149F3DBC01B7D504@mzlsrv1.mzl.local>


Try creating a session varaible as you log in, and look for that session
variable at the head of every secure page. No session variable, no
entry.



-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Tris
Sent: 15 October 2007 10:01
To: thelist at jarmin.com; thelist at lists.evolt.org
Subject: Re: [thelist] how to protect downloadable docs in members only
area


I used to keep the files outside of the www DIR... and then created a
downlaod page, (with a login checker) and then used the header()
function to asign the correct mime type and pass the file to the
user...

Does that makes sence?
it worked great for me, and no one could guess the URL direct to the
files, cuase there were none!

let me know if you need more info..

Tris...


On 15/10/2007, iris <thelist at jarmin.com> wrote:
> good morning everyone
>
> i've got a website that has a password protected members' area (php
> login system).  physically the content is all located within a
/members/
> folder.  within this is a documents folder with word, powerpoint etc
> docs which can be downloaded from within the members' area (i.e. only
if
> logged in).
>
> however, if someone knew the exact location of a document
> (http://example.com/members/docs/example.doc) they could get to them
> without being logged in.
>
> how do i protect these documents from unauthorised access?
>
> i tried the htaccess file approach, passing the login instructions in
> the links, so that those logged in don't have to log in again. e.g.
> <a
href="http://username:password at example.com/members/docs/example.doc">
> but i discovered that IE doesn't play nice if the security setting are
> set too high (middle being too high).  since the users of this site
are
> mostly on university computers and might not have rights to change
these
> settings, i've decided that this is a bad method.
>
> has anybody got another solution for me?
>
> also, are the documents save from search engines? (i don't really
trust
> them to follow the instructions in robot.txt)
>
> thank you so very much
>
> iris
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to
be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 


From beertastic at gmail.com  Mon Oct 15 04:07:51 2007
From: beertastic at gmail.com (Tris)
Date: Mon, 15 Oct 2007 10:07:51 +0100
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <030932EF7CC19F4A9E8FFC78149F3DBC01B7D504@mzlsrv1.mzl.local>
References: <8b20a7490710150200w3e5975ddv1680ebfee92c00b8@mail.gmail.com>
	<030932EF7CC19F4A9E8FFC78149F3DBC01B7D504@mzlsrv1.mzl.local>
Message-ID: <8b20a7490710150207h669deaeci6518de740a124c0d@mail.gmail.com>

But users can still 'guess' fuile locations... and bypass the login
area that way...
Unless you emply a random number system to file names... ?
that'll slow them down..!

On 15/10/2007, Simon Harrison <sharrison at mzl.com> wrote:
>
> Try creating a session varaible as you log in, and look for that session
> variable at the head of every secure page. No session variable, no
> entry.
>
>
>
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Tris
> Sent: 15 October 2007 10:01
> To: thelist at jarmin.com; thelist at lists.evolt.org
> Subject: Re: [thelist] how to protect downloadable docs in members only
> area
>
>
> I used to keep the files outside of the www DIR... and then created a
> downlaod page, (with a login checker) and then used the header()
> function to asign the correct mime type and pass the file to the
> user...
>
> Does that makes sence?
> it worked great for me, and no one could guess the URL direct to the
> files, cuase there were none!
>
> let me know if you need more info..
>
> Tris...
>
>
> On 15/10/2007, iris <thelist at jarmin.com> wrote:
> > good morning everyone
> >
> > i've got a website that has a password protected members' area (php
> > login system).  physically the content is all located within a
> /members/
> > folder.  within this is a documents folder with word, powerpoint etc
> > docs which can be downloaded from within the members' area (i.e. only
> if
> > logged in).
> >
> > however, if someone knew the exact location of a document
> > (http://example.com/members/docs/example.doc) they could get to them
> > without being logged in.
> >
> > how do i protect these documents from unauthorised access?
> >
> > i tried the htaccess file approach, passing the login instructions in
> > the links, so that those logged in don't have to log in again. e.g.
> > <a
> href="http://username:password at example.com/members/docs/example.doc">
> > but i discovered that IE doesn't play nice if the security setting are
> > set too high (middle being too high).  since the users of this site
> are
> > mostly on university computers and might not have rights to change
> these
> > settings, i've decided that this is a bad method.
> >
> > has anybody got another solution for me?
> >
> > also, are the documents save from search engines? (i don't really
> trust
> > them to follow the instructions in robot.txt)
> >
> > thank you so very much
> >
> > iris
> >
> > --
> >
> > * * Please support the community that supports you.  * *
> > http://evolt.org/help_support_evolt/
> >
> > For unsubscribe and other options, including the Tip Harvester
> > and archives of thelist go to: http://lists.evolt.org
> > Workers of the Web, evolt !
> >
>
>
> --
> Give a man a fish and he'll feed himself for a day.
> Give a man a religion and he'll starve to death praying for a fish.
> Anon
>
> `We are what we pretend to be, so we must be careful what we pretend to
> be.`
> Kurt Vonnegut
>
> `When a person can no longer laugh at himself, it is time for others
> to laugh at him.`
> Thomas Szasz
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz


From moseley at hank.org  Mon Oct 15 09:27:54 2007
From: moseley at hank.org (Bill Moseley)
Date: Mon, 15 Oct 2007 07:27:54 -0700
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <47132AD5.10200@jarmin.com>
References: <47132AD5.10200@jarmin.com>
Message-ID: <20071015142754.GB6307@hank.org>

On Mon, Oct 15, 2007 at 10:54:45AM +0200, iris wrote:
> good morning everyone
> 
> i've got a website that has a password protected members' area (php 
> login system).  physically the content is all located within a /members/ 
> folder.  within this is a documents folder with word, powerpoint etc 
> docs which can be downloaded from within the members' area (i.e. only if 
> logged in).

On Apache?  How about mod_auth_token?

-- 
Bill Moseley
moseley at hank.org



From pixelmech at gmail.com  Mon Oct 15 10:05:34 2007
From: pixelmech at gmail.com (Tom Dell'Aringa)
Date: Mon, 15 Oct 2007 10:05:34 -0500
Subject: [thelist] Rusty PHP questions...
Message-ID: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>

Hey there,

Got a quick little helper job using some PHP/mySQL and it's just been ages
since I've done anything. I've got the thing working as she wanted, but I
had a couple quick questions.

1. One best practice is to never use SELECT * - could someone explain why,
and tell me when this is okay if ever? Right now I am doing this:

$query = sprintf("SELECT name, date, city, distance, start, state, score,
course_type, price, size, chip, food, beer, url, frequency, sponsors,
description FROM event_list WHERE id = $raceId");

Which seems a bit excessive... but if it makes it work better I'm for it.
These are indeed all the columns in this table.

2. They are connecting to the db directly in the page code, which I know is
a no-no - is the best way to do this simply to have an include like '
connect.php'? Also, they are selecting the database at the top of the page
as well - shouldn't I do this before each query, or does it matter? (top of
page is like so)

mysql_connect("domain.com", "user", "pw") or die(mysql_error());
mysql_select_db("db_name") or die(mysql_error());

3. Lastly, just checking that I am setting my variable correctly. They are
appending an id onto the get string for each link, so I set it at the top of
the page like so, so I can test for it at the section when I need it:

$raceId = $_GET['id'];

Thanks in advance for any tips, please CC me at pixelmech at gee mail dot
com.

Tom


From john at userfrenzy.com  Mon Oct 15 10:15:24 2007
From: john at userfrenzy.com (John Handelaar)
Date: Mon, 15 Oct 2007 16:15:24 +0100
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
Message-ID: <86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>

On 15/10/2007, Tom Dell'Aringa <pixelmech at gmail.com> wrote:
> $query = sprintf("SELECT name, date, city, distance, start, state, score,
> course_type, price, size, chip, food, beer, url, frequency, sponsors,
> description FROM event_list WHERE id = $raceId");


> 3. Lastly, just checking that I am setting my variable correctly. They are
> appending an id onto the get string for each link, so I set it at the top of
> the page like so, so I can test for it at the section when I need it:
>
> $raceId = $_GET['id'];
>
> Thanks in advance for any tips,

One tip:

a)  Take a backup (seriously, *TAKE A BACKUP* before moving to b)
b)  Try appending this to the page URI:

    ?id=0;DELETE FROM event_list;


c)  Plug the huge hole you just described.


jh


From pixelmech at gmail.com  Mon Oct 15 10:19:21 2007
From: pixelmech at gmail.com (Tom Dell'Aringa)
Date: Mon, 15 Oct 2007 10:19:21 -0500
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>
Message-ID: <c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>

On 10/15/07, John Handelaar <john at userfrenzy.com> wrote:
>
> > 3. Lastly, just checking that I am setting my variable correctly. They
> are
> > appending an id onto the get string for each link, so I set it at the
> top of
> > the page like so, so I can test for it at the section when I need it:
> >
> > $raceId = $_GET['id'];
>
> One tip:
>
> a)  Take a backup (seriously, *TAKE A BACKUP* before moving to b)
> b)  Try appending this to the page URI:
>
>     ?id=0;DELETE FROM event_list;
>
> c)  Plug the huge hole you just described.


Holy carp! Ok, HOW do I plug that huge hole, I have no idea. Man do I stink
at php these days.

Tom


From kenrbnsn at rbnsn.com  Mon Oct 15 10:45:46 2007
From: kenrbnsn at rbnsn.com (Ken Robinson)
Date: Mon, 15 Oct 2007 11:45:46 -0400
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>
	<c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
Message-ID: <20071015114546.fl8ox1wjeocow80c@www.rbnsn.com>

Quoting Tom Dell'Aringa <pixelmech at gmail.com>:

> On 10/15/07, John Handelaar <john at userfrenzy.com> wrote:
>>
>> > 3. Lastly, just checking that I am setting my variable correctly. They
>> are
>> > appending an id onto the get string for each link, so I set it at the
>> top of
>> > the page like so, so I can test for it at the section when I need it:
>> >
>> > $raceId = $_GET['id'];
>>
>> One tip:
>>
>> a)  Take a backup (seriously, *TAKE A BACKUP* before moving to b)
>> b)  Try appending this to the page URI:
>>
>>     ?id=0;DELETE FROM event_list;
>>
>> c)  Plug the huge hole you just described.
>
>
> Holy carp! Ok, HOW do I plug that huge hole, I have no idea. Man do I stink
> at php these days.

Use the function mysql_real_escape_string(). This function will help  
prevent SQL injections from working:

     $raceID = mysql_real_escape_string($_GET['id']);

Ken



From beertastic at gmail.com  Mon Oct 15 10:22:32 2007
From: beertastic at gmail.com (Tris)
Date: Mon, 15 Oct 2007 16:22:32 +0100
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>
	<c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
Message-ID: <8b20a7490710150822j3174fa73xe31c1aaa8571749d@mail.gmail.com>

does the mysql_query() function allow 2 x query...?

On 15/10/2007, Tom Dell'Aringa <pixelmech at gmail.com> wrote:
> On 10/15/07, John Handelaar <john at userfrenzy.com> wrote:
> >
> > > 3. Lastly, just checking that I am setting my variable correctly. They
> > are
> > > appending an id onto the get string for each link, so I set it at the
> > top of
> > > the page like so, so I can test for it at the section when I need it:
> > >
> > > $raceId = $_GET['id'];
> >
> > One tip:
> >
> > a)  Take a backup (seriously, *TAKE A BACKUP* before moving to b)
> > b)  Try appending this to the page URI:
> >
> >     ?id=0;DELETE FROM event_list;
> >
> > c)  Plug the huge hole you just described.
>
>
> Holy carp! Ok, HOW do I plug that huge hole, I have no idea. Man do I stink
> at php these days.
>
> Tom
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz


From rjmolesa at consoltec.net  Mon Oct 15 10:05:45 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Mon, 15 Oct 2007 11:05:45 -0400
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <47132AD5.10200@jarmin.com>
References: <47132AD5.10200@jarmin.com>
Message-ID: <20071015150545.GA2718@jenna.rjmolesa.homelinux.net>

I agree with Tris.  Store your files somewhere on the system outside of 
the public location.  Authenticate the user as normal.  Point your
script to where your files are.  Generate a list, and when the user
clicks on one of the files have PHP hand it to them.  Tris give the
technical description, I'm just trying to help explain the process.

-- 
Jon Molesa
http://rjmolesa.com


From rjmolesa at consoltec.net  Mon Oct 15 10:25:23 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Mon, 15 Oct 2007 11:25:23 -0400
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
Message-ID: <20071015152523.GB2718@jenna.rjmolesa.homelinux.net>

*On Mon, Oct 15, 2007 at 10:05:34AM -0500 Tom Dell'Aringa <pixelmech at gmail.com> wrote:

> 1. One best practice is to never use SELECT * - could someone explain why,
> and tell me when this is okay if ever? Right now I am doing this:

It's ok to use SELECT *, but on large tables with a lot of fields you
can get back more information than you need for a given purpose.
Sometimes, when sorting, filtering, and grouping data, returning all
fields can give you a misrepresentation of what you're trying to get at.
It's always better to specify which fields you need.  OTOH, if your just
generating a table of informaton, and the table is pretty small, no
complex groupings or calculations then SELECT * is ok.

> 2. They are connecting to the db directly in the page code, which I know is
> a no-no - is the best way to do this simply to have an include like '
> connect.php'? Also, they are selecting the database at the top of the page
> as well - shouldn't I do this before each query, or does it matter? (top of
> page is like so)
> 
> mysql_connect("domain.com", "user", "pw") or die(mysql_error());
> mysql_select_db("db_name") or die(mysql_error());

Include is bennificial if you need to connect multiple pages to the db
and don't want to retype the connection strings everytime.

> 
> 3. Lastly, just checking that I am setting my variable correctly. They are
> appending an id onto the get string for each link, so I set it at the top of
> the page like so, so I can test for it at the section when I need it:
> 
> $raceId = $_GET['id'];
> 
$raceId = $_REQUEST['id'] will work for post or get and I believe is the
preferred way on PHP5??

-- 
Jon Molesa
http://rjmolesa.com


From beertastic at gmail.com  Mon Oct 15 10:41:43 2007
From: beertastic at gmail.com (Tris)
Date: Mon, 15 Oct 2007 16:41:43 +0100
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <20071015150545.GA2718@jenna.rjmolesa.homelinux.net>
References: <47132AD5.10200@jarmin.com>
	<20071015150545.GA2718@jenna.rjmolesa.homelinux.net>
Message-ID: <8b20a7490710150841l51541c35v2825ee0cc7cef21d@mail.gmail.com>

I gave a vauge description ;-p
I tried to find the page I had that did it all... but I've lost it :-(

Must control my file archive better!


On 15/10/2007, Jon Molesa <rjmolesa at consoltec.net> wrote:
> I agree with Tris.  Store your files somewhere on the system outside of
> the public location.  Authenticate the user as normal.  Point your
> script to where your files are.  Generate a list, and when the user
> clicks on one of the files have PHP hand it to them.  Tris give the
> technical description, I'm just trying to help explain the process.
>
> --
> Jon Molesa
> http://rjmolesa.com
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz


From matt.slocum at gmail.com  Mon Oct 15 10:43:20 2007
From: matt.slocum at gmail.com (Matt Slocum)
Date: Mon, 15 Oct 2007 11:43:20 -0400
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <20071015114546.fl8ox1wjeocow80c@www.rbnsn.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>
	<c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
	<20071015114546.fl8ox1wjeocow80c@www.rbnsn.com>
Message-ID: <eefc34900710150843o6e0731c9k4592d873d38a9ff6@mail.gmail.com>

Tip: On something I know is supposed to be a numeric value I use:
$id = $_REQUEST['id'];
if (!is_numeric($id))
    error("bad ID");

This prevents worthless queries and it allows you to give smarter error
messages. (Not that you want to give a nice error message to someone that is
trying to do a sql injection).

Also, $_REQUEST will retrieve get POST or GET submissions. This can be good
or bad. Good: It allows you to get either and be lazy. Bad: it makes it
easier for someone to try things using a URL even if you are using POST.

Matt

On 10/15/07, Ken Robinson <kenrbnsn at rbnsn.com> wrote:
>
> Quoting Tom Dell'Aringa <pixelmech at gmail.com>:
>
> > On 10/15/07, John Handelaar <john at userfrenzy.com> wrote:
> >>
> >> > 3. Lastly, just checking that I am setting my variable correctly.
> They
> >> are
> >> > appending an id onto the get string for each link, so I set it at the
> >> top of
> >> > the page like so, so I can test for it at the section when I need it:
> >> >
> >> > $raceId = $_GET['id'];
> >>
> >> One tip:
> >>
> >> a)  Take a backup (seriously, *TAKE A BACKUP* before moving to b)
> >> b)  Try appending this to the page URI:
> >>
> >>     ?id=0;DELETE FROM event_list;
> >>
> >> c)  Plug the huge hole you just described.
> >
> >
> > Holy carp! Ok, HOW do I plug that huge hole, I have no idea. Man do I
> stink
> > at php these days.
>
> Use the function mysql_real_escape_string(). This function will help
> prevent SQL injections from working:
>
>      $raceID = mysql_real_escape_string($_GET['id']);
>
> Ken
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From joel at streamliine.com  Mon Oct 15 10:44:17 2007
From: joel at streamliine.com (Joel D Canfield)
Date: Mon, 15 Oct 2007 08:44:17 -0700
Subject: [thelist] Rusty PHP questions...
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
Message-ID: <72E9FAA171D63B48AAC707C72900E6B4D89D95@ireland.spinhead.com>

> 1. One best practice is to never use SELECT * - could someone 
> explain why,
> and tell me when this is okay if ever? Right now I am doing this:

my primary argument is future needs: listing all the columns makes it
really easy to change from 'select * ' to 'select * except for column
13' which you can't do. it's also self-documenting. right there in your
code you've got all the column names, when you come back in six weeks to
adjust something.

> 2. They are connecting to the db directly in the page code, 
> which I know is
> a no-no - is the best way to do this simply to have an include like '
> connect.php'? 

I know less PHP than you, Tom, but from an ASP perspective, it's
cleaner, safer, and more efficient to put the db connection in an
include, as you suggest here

joel


From rjmolesa at consoltec.net  Mon Oct 15 10:47:34 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Mon, 15 Oct 2007 11:47:34 -0400
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <8b20a7490710150841l51541c35v2825ee0cc7cef21d@mail.gmail.com>
References: <47132AD5.10200@jarmin.com>
	<20071015150545.GA2718@jenna.rjmolesa.homelinux.net>
	<8b20a7490710150841l51541c35v2825ee0cc7cef21d@mail.gmail.com>
Message-ID: <20071015154734.GA12526@jenna.rjmolesa.homelinux.net>

*On Mon, Oct 15, 2007 at 04:41:43PM +0100 Tris <beertastic at gmail.com> wrote:

> Must control my file archive better!

When you find something that works let me know.  I've been trying svn.
But it still requires me to remember to do things.  LOL ;-)

-- 
Jon Molesa
http://rjmolesa.com


From pixelmech at gmail.com  Mon Oct 15 11:14:30 2007
From: pixelmech at gmail.com (Tom Dell'Aringa)
Date: Mon, 15 Oct 2007 11:14:30 -0500
Subject: [thelist] one more PHP question - using a function
Message-ID: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>

Thanks for all the answers folks, really helpful. One more question. I want
to use a function to call the data when the user clicks a link. If I don't I
end up with errors because code is just running willy nilly in the page.

So I have this example function

function GetRaceinfo($raceId)
{
    // make sure there is a race id selected before attempting to pull data
    if(isset($raceId))
    {
    ...do some stuff, etc....
    }
}

Then I have the link that is being written out like so:

<a href=\'events.php?id=\'' . $info['id'] . '>' . $info['name'] . '</a>

How can I switch this so when the link is clicked, it still calls
events.php?id=
but it does it via the function instead? Would I just do this:

<a href='<?php GetRaceinfo(' . $raceId .  ')?>'>linkname</a>

then at the end of my function use header to hit the page?

header('Location: http://blah.com/events.php?id=4');

I'm thinking I've got something backwards here though...

CC me at pixelmech at gee mail dot com if you can...thanks!

Tom


From darrellgking at gmail.com  Mon Oct 15 11:49:30 2007
From: darrellgking at gmail.com (Darrell King)
Date: Mon, 15 Oct 2007 12:49:30 -0400
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
Message-ID: <1f2cbbe70710150949j73e00dbh228a6118259a74af@mail.gmail.com>

1) If you are going to use all the fields from a given table, then
SELECT * makes sense. Don't use it if you only need some of the
columns just because it looks cleaner in the PHP.

2) Why reassign $_GET['id'] to $raceid? It's an unnecessary step
unless you are going to do something with the latter that you don't
want affecting the former. This might be the case if you are going to
escape the input bur re-display the original variable in the output
HTML,. for instance.  Think twice about the reassignment if it's just
to be pretty, though, especially if efficiency concerns you.

3) I recommend putting the MySQL connection into an external file and
including it in the HTML document where needed via a PHP include.

4) If you need only the one database, why not select it only once?

On 10/15/07, Tom Dell'Aringa <pixelmech at gmail.com> wrote:
> Hey there,
>
> Got a quick little helper job using some PHP/mySQL and it's just been ages
> since I've done anything. I've got the thing working as she wanted, but I
> had a couple quick questions.
>
> 1. One best practice is to never use SELECT * - could someone explain why,
> and tell me when this is okay if ever? Right now I am doing this:
>
> $query = sprintf("SELECT name, date, city, distance, start, state, score,
> course_type, price, size, chip, food, beer, url, frequency, sponsors,
> description FROM event_list WHERE id = $raceId");
>
> Which seems a bit excessive... but if it makes it work better I'm for it.
> These are indeed all the columns in this table.
>
> 2. They are connecting to the db directly in the page code, which I know is
> a no-no - is the best way to do this simply to have an include like '
> connect.php'? Also, they are selecting the database at the top of the page
> as well - shouldn't I do this before each query, or does it matter? (top of
> page is like so)
>
> mysql_connect("domain.com", "user", "pw") or die(mysql_error());
> mysql_select_db("db_name") or die(mysql_error());
>
> 3. Lastly, just checking that I am setting my variable correctly. They are
> appending an id onto the get string for each link, so I set it at the top of
> the page like so, so I can test for it at the section when I need it:
>
> $raceId = $_GET['id'];
>
> Thanks in advance for any tips, please CC me at pixelmech at gee mail dot
> com.
>
> Tom
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Darrell G. King
DarrellGKing at gmail.com
(C) 1/585.820.8231


From pixelmech at gmail.com  Mon Oct 15 11:51:44 2007
From: pixelmech at gmail.com (Tom Dell'Aringa)
Date: Mon, 15 Oct 2007 11:51:44 -0500
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <1f2cbbe70710150949j73e00dbh228a6118259a74af@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<1f2cbbe70710150949j73e00dbh228a6118259a74af@mail.gmail.com>
Message-ID: <c61099b40710150951x2fcf2f82nf9c540aeda7dd5c1@mail.gmail.com>

On 10/15/07, Darrell King <darrellgking at gmail.com> wrote:
>
> 2) Why reassign $_GET['id'] to $raceid? It's an unnecessary step
> unless you are going to do something with the latter that you don't
> want affecting the former. This might be the case if you are going to
> escape the input bur re-display the original variable in the output
> HTML,. for instance.  Think twice about the reassignment if it's just
> to be pretty, though, especially if efficiency concerns you.


My thought here - and I said I was rusty, I may be mixing terms - was to
make sure I initialized my variable first. Possibly it is already
initialized by default in this case?


From darrellgking at gmail.com  Mon Oct 15 11:52:14 2007
From: darrellgking at gmail.com (Darrell King)
Date: Mon, 15 Oct 2007 12:52:14 -0400
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
Message-ID: <1f2cbbe70710150952q67751ecs759dfa9c65a2f1aa@mail.gmail.com>

You can us output buffering around the function call
(http://us.php.net/manual/en/function.ob-start.php) or you can just
assign the output to a variable and then echo that variable when
appropriate.

D

On 10/15/07, Tom Dell'Aringa <pixelmech at gmail.com> wrote:
> Thanks for all the answers folks, really helpful. One more question. I want
> to use a function to call the data when the user clicks a link. If I don't I
> end up with errors because code is just running willy nilly in the page.
>
> So I have this example function
>
> function GetRaceinfo($raceId)
> {
>     // make sure there is a race id selected before attempting to pull data
>     if(isset($raceId))
>     {
>     ...do some stuff, etc....
>     }
> }
>
> Then I have the link that is being written out like so:
>
> <a href=\'events.php?id=\'' . $info['id'] . '>' . $info['name'] . '</a>
>
> How can I switch this so when the link is clicked, it still calls
> events.php?id=
> but it does it via the function instead? Would I just do this:
>
> <a href='<?php GetRaceinfo(' . $raceId .  ')?>'>linkname</a>
>
> then at the end of my function use header to hit the page?
>
> header('Location: http://blah.com/events.php?id=4');
>
> I'm thinking I've got something backwards here though...
>
> CC me at pixelmech at gee mail dot com if you can...thanks!
>
> Tom
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
Darrell G. King
DarrellGKing at gmail.com
(C) 1/585.820.8231


From matt.slocum at gmail.com  Mon Oct 15 12:08:01 2007
From: matt.slocum at gmail.com (Matt Slocum)
Date: Mon, 15 Oct 2007 13:08:01 -0400
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
Message-ID: <eefc34900710151008w15b5e0b8hd8198961b01f8f82@mail.gmail.com>

Tom, I'm not sure I understand your question.

This is what I do. When it comes to php flow. I would avoid having long
chunks of code running outside a function. I recommend separating each
segment of a page into its own function.
checkUser()
printMenu()
printOptions()
printChart()
printFooter()
etc...

At the begging of the php use conditional statements to control which
workflow gets done.

Is that even close to your question???

Matt

On 10/15/07, Tom Dell'Aringa <pixelmech at gmail.com> wrote:
>
> Thanks for all the answers folks, really helpful. One more question. I
> want
> to use a function to call the data when the user clicks a link. If I don't
> I
> end up with errors because code is just running willy nilly in the page.
>
> So I have this example function
>
> function GetRaceinfo($raceId)
> {
>     // make sure there is a race id selected before attempting to pull
> data
>     if(isset($raceId))
>     {
>     ...do some stuff, etc....
>     }
> }
>
> Then I have the link that is being written out like so:
>
> <a href=\'events.php?id=\'' . $info['id'] . '>' . $info['name'] . '</a>
>
> How can I switch this so when the link is clicked, it still calls
> events.php?id=
> but it does it via the function instead? Would I just do this:
>
> <a href='<?php GetRaceinfo(' . $raceId .  ')?>'>linkname</a>
>
> then at the end of my function use header to hit the page?
>
> header('Location: http://blah.com/events.php?id=4');
>
> I'm thinking I've got something backwards here though...
>
> CC me at pixelmech at gee mail dot com if you can...thanks!
>
> Tom
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From rjmolesa at consoltec.net  Mon Oct 15 12:12:54 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Mon, 15 Oct 2007 13:12:54 -0400
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
Message-ID: <20071015171254.GC12526@jenna.rjmolesa.homelinux.net>

*On Mon, Oct 15, 2007 at 11:14:30AM -0500 Tom Dell'Aringa <pixelmech at gmail.com> wrote:

Build your link as you describe.  Use $_REQUEST['id'] or which ever
variable is part of your link.  Get it's value and query the db.  Return
the results.

-- 
Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious
http://rjmolesa.com


From pixelmech at gmail.com  Mon Oct 15 12:20:37 2007
From: pixelmech at gmail.com (Tom Dell'Aringa)
Date: Mon, 15 Oct 2007 12:20:37 -0500
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <eefc34900710151008w15b5e0b8hd8198961b01f8f82@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
	<eefc34900710151008w15b5e0b8hd8198961b01f8f82@mail.gmail.com>
Message-ID: <c61099b40710151020n48f9a1ffgd17d1a1ce1846d0f@mail.gmail.com>

On 10/15/07, Matt Slocum <matt.slocum at gmail.com> wrote:
>
> Tom, I'm not sure I understand your question.
>
> This is what I do. When it comes to php flow. I would avoid having long
> chunks of code running outside a function. I recommend separating each
> segment of a page into its own function.
> checkUser()
> printMenu()
> printOptions()
> printChart()
> printFooter()
> etc...
>
> At the begging of the php use conditional statements to control which
> workflow gets done.
>
> Is that even close to your question???


Close yes. Let me give a bit more context, maybe I am making this too hard.

Page lists out lists of races held in various places via a database query.
This just happens loosely at the beginning of the page.

For each item in the list, a link is written out which you click on to get
the full information about the race. This link is formatted events.php?id=4
for example.

Clicking the link gives you the info on the right side of the page on page
reload.

Ok, so when the page loads I am checking to see if the id is empty or not.
If it is, then we are at the first entrance of the page (or you got a bad
link in the race list with no id). If it is empty, I essentially skip the
whole process of pulling the race detail with an if statement like so:

if(!empty($raceId))
    {
       get the race detail
   }

This works, but leaves an awkward blank space below 'race details' on
initial page load. At first I put an else clause and just wrote out
something like "please choose a race" but that doesn't work if they choose a
race that has no id for some reason - the message "choose a race" wouldn't
make sense, because they just had.

Basically I'm just trying to figure out the best way to handle that scenario
- tell them to choose a race on initial page load, and also have an
intelligent error message if they choose a race but for some reason it has
no ID.

Tom


From hassan.schroeder at gmail.com  Mon Oct 15 12:30:00 2007
From: hassan.schroeder at gmail.com (Hassan Schroeder)
Date: Mon, 15 Oct 2007 10:30:00 -0700
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <c61099b40710151020n48f9a1ffgd17d1a1ce1846d0f@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
	<eefc34900710151008w15b5e0b8hd8198961b01f8f82@mail.gmail.com>
	<c61099b40710151020n48f9a1ffgd17d1a1ce1846d0f@mail.gmail.com>
Message-ID: <4eedb92a0710151030o4ccf1cbcld633ee1b29ebd7b5@mail.gmail.com>

On 10/15/07, Tom Dell'Aringa <pixelmech at gmail.com> wrote:

> Basically I'm just trying to figure out the best way to handle that scenario
> - tell them to choose a race on initial page load, and also have an
> intelligent error message if they choose a race but for some reason it has
> no ID.

? Wouldn't it be much easier (and better UX)  to just *not* display any
links without IDs? I mean, you're generating these, right?

-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com


From pixelmech at gmail.com  Mon Oct 15 12:45:40 2007
From: pixelmech at gmail.com (Tom Dell'Aringa)
Date: Mon, 15 Oct 2007 12:45:40 -0500
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <4eedb92a0710151030o4ccf1cbcld633ee1b29ebd7b5@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
	<eefc34900710151008w15b5e0b8hd8198961b01f8f82@mail.gmail.com>
	<c61099b40710151020n48f9a1ffgd17d1a1ce1846d0f@mail.gmail.com>
	<4eedb92a0710151030o4ccf1cbcld633ee1b29ebd7b5@mail.gmail.com>
Message-ID: <c61099b40710151045ub24c1c3pf8be80172f1d174d@mail.gmail.com>

On 10/15/07, Hassan Schroeder <hassan.schroeder at gmail.com> wrote:
>
> ? Wouldn't it be much easier (and better UX)  to just *not* display any
> links without IDs? I mean, you're generating these, right?


Yeah, you're right. Not sure what I was thinking.

Tom


From fredthejonester at gmail.com  Mon Oct 15 12:45:48 2007
From: fredthejonester at gmail.com (Fred Jones)
Date: Mon, 15 Oct 2007 20:45:48 +0300
Subject: [thelist] RTF Import to CMS
Message-ID: <4713A74C.7090603@gmail.com>

I have now a set of around 10K RTF files which I want to import into my 
CMS of choice, that being Drupal. Roughly 600 of them have external 
images, linked using a structured file naming system. The RTF data is 
structured in volumes, each one to a directory, and then each page (more 
or less) is an RTF file.

I have poked around Google and drupal.com and I haven't really found any 
good solution for this type of import. The RTF files are not technically 
simple--some have tables and sideways text and other non-trivial RTF 
constructs.

Any ideas as how to begin with this job? Perhaps convert RTF to HTML or 
XML first?

I would also consider another CMS if one was more suited to this 
task--Drupal is the one I know.

Thanks,
Fred



From hpls at ilimburg.nl  Mon Oct 15 13:47:34 2007
From: hpls at ilimburg.nl (Huup Offermans)
Date: Mon, 15 Oct 2007 20:47:34 +0200
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com>
	<c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
Message-ID: <DCE05184-55AC-4D9F-86CE-810541FC8324@ilimburg.nl>

Could you please send your replies directly to  
<thelist at lists.evolt.org>, just like everybody else does, instead of  
using this address for a CC? My e-mailfilters look at the From- 
address to decide where messages go to, and I don't think you want to  
end up in the trash.....
Or am I the only one to have this problem?


Huup Offermans


On 15 Oct 2007, at 17:19, Tom Dell'Aringa wrote:

> On 10/15/07, John Handelaar <john at userfrenzy.com> wrote:
>>
>>> 3. Lastly, just checking that I am setting my variable correctly.  
>>> They
>> are
>>> appending an id onto the get string for each link, so I set it at  
>>> the
>> top of
>>> the page like so, so I can test for it at the section when I need  
>>> it:
>>>
>>> $raceId = $_GET['id'];
>>
>> One tip:
>>
>> a)  Take a backup (seriously, *TAKE A BACKUP* before moving to b)
>> b)  Try appending this to the page URI:
>>
>>     ?id=0;DELETE FROM event_list;
>>
>> c)  Plug the huge hole you just described.
>
>
> Holy carp! Ok, HOW do I plug that huge hole, I have no idea. Man do  
> I stink
> at php these days.
>
> Tom
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !



From joel at streamliine.com  Mon Oct 15 14:31:37 2007
From: joel at streamliine.com (Joel D Canfield)
Date: Mon, 15 Oct 2007 12:31:37 -0700
Subject: [thelist] email filters and CCs (was RE:  Rusty PHP questions...)
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com><86f32b920710150815t271c3e69udf3dc5bd5ea5d816@mail.gmail.com><c61099b40710150819x7de4cd2cp8a9fa2ca7f97663@mail.gmail.com>
	<DCE05184-55AC-4D9F-86CE-810541FC8324@ilimburg.nl>
Message-ID: <72E9FAA171D63B48AAC707C72900E6B4D89DA3@ireland.spinhead.com>

> Or am I the only one to have this problem?

hasn't happened here, that I'm aware of

(note the changed subject line . . . ;)

joel


From mydarb at gmail.com  Mon Oct 15 15:57:50 2007
From: mydarb at gmail.com (Brady Mitchell)
Date: Mon, 15 Oct 2007 13:57:50 -0700
Subject: [thelist] RTF Import to CMS
In-Reply-To: <4713A74C.7090603@gmail.com>
References: <4713A74C.7090603@gmail.com>
Message-ID: <43f7a9ca0710151357j699ff80cg3765676cf5c8d3bd@mail.gmail.com>

I would probably convert the files to XML or HTML first, then parse
that data into my database. I've never used it before, but this class
would be my starting point:
http://www.phpclasses.org/browse/package/1930.html.

Good luck!

Brady

On 10/15/07, Fred Jones <fredthejonester at gmail.com> wrote:
> I have now a set of around 10K RTF files which I want to import into my
> CMS of choice, that being Drupal. Roughly 600 of them have external
> images, linked using a structured file naming system. The RTF data is
> structured in volumes, each one to a directory, and then each page (more
> or less) is an RTF file.
>
> I have poked around Google and drupal.com and I haven't really found any
> good solution for this type of import. The RTF files are not technically
> simple--some have tables and sideways text and other non-trivial RTF
> constructs.
>
> Any ideas as how to begin with this job? Perhaps convert RTF to HTML or
> XML first?
>
> I would also consider another CMS if one was more suited to this
> task--Drupal is the one I know.
>
> Thanks,
> Fred
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From bobm at dottedi.biz  Tue Oct 16 08:51:16 2007
From: bobm at dottedi.biz (Bob Meetin)
Date: Tue, 16 Oct 2007 07:51:16 -0600
Subject: [thelist] Converting php forms/session to Joomla
Message-ID: <4714C1D4.2090804@dottedi.biz>

I'm converting a site for which I designed an administration section 
with login/password and PHP sessions to Joomla. 

I can possibly do this in either direction, but what I would prefer 
doing is to convert my forms/session so that it will use the standard 
Jooma session - so that I don't need to manage two different types of 
sessions, login, etc.  My forms start with something like:

session_name ("SomeVisitID");
session_start();

Can I get some suggestions as to what I would need to do, add to my 
forms, session-wise, so that they will run with Jooma or what code I 
need to be grabbing from Joomla to make this happen?  

Thx, Bob



From fredthejonester at gmail.com  Tue Oct 16 08:20:34 2007
From: fredthejonester at gmail.com (Fred Jones)
Date: Tue, 16 Oct 2007 16:20:34 +0300
Subject: [thelist] RTF Import to CMS
In-Reply-To: <43f7a9ca0710151357j699ff80cg3765676cf5c8d3bd@mail.gmail.com>
References: <4713A74C.7090603@gmail.com>
	<43f7a9ca0710151357j699ff80cg3765676cf5c8d3bd@mail.gmail.com>
Message-ID: <4714BAA2.10604@gmail.com>

Brady Mitchell wrote:
> I would probably convert the files to XML or HTML first, then parse
> that data into my database. I've never used it before, but this class
> would be my starting point:
> http://www.phpclasses.org/browse/package/1930.html.

Thanks.


From scott at hireawebgeek.com  Tue Oct 16 09:19:31 2007
From: scott at hireawebgeek.com (Scott Wilhelm (HireAWebGeek.com))
Date: Tue, 16 Oct 2007 10:19:31 -0400
Subject: [thelist] phpBB Sessions & Authentication
Message-ID: <71f3f2fc0710160719t7b5035fas82f8e8fae0719ba@mail.gmail.com>

Hello:

Has anyone had any experiences with phpBB 3 & using their sessions in other
non-phpBB parts of your site?

I have to build a simple database, but I need to use their session &
username to validate & associate any records that they would enter in.

Any suggestions, ideas, hints, references, or "clue by 4's"? :)

Thanks,

Scott


From btesanovic at gmail.com  Tue Oct 16 09:22:52 2007
From: btesanovic at gmail.com (Bojan Tesanovic)
Date: Tue, 16 Oct 2007 16:22:52 +0200
Subject: [thelist] one more PHP question - using a function
In-Reply-To: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
References: <c61099b40710150914o14ba10e5i67809093a64dea6a@mail.gmail.com>
Message-ID: <4714C93C.2010306@gmail.com>

Wow, well you should first separate HTML  and PHP in your head ;)
Those are completely different things.

lets say that user clicked on 'events.php?id=4'

so user is requesting events.php file with id=4;

let events.php file look like this
<?php

$ID = isset($_GET['id']) ? $_GET['id'] : '';
if( ! is_numeric($ID) ) $ID='';

$info = '';
if($ID){
  $info = GetRaceInfo($ID);
}

$links = '';
$arrayIds = array(1=>'name1' ,3 =>'name3' ,4 ........);
foreach($arrayIds as $id=>$name){
$links .= "<a href='events.php?id=$id'>$name</a><br>";
}

//template
$HTML=<<<TPL
<h2>Hello There<h2>
<div> $info <div>

Available events
$links

<h3>bye</h3>
TPL;

echo $HTML;


function GetRaceInfo($id){
  ...
  return $info;
}
?>


So eny request to events.php with or without ID will print possible links for events
and if ID is present in URL it will call GetRaceInfo function and print $info 
above links



Tom Dell'Aringa wrote:
> Thanks for all the answers folks, really helpful. One more question. I want
> to use a function to call the data when the user clicks a link. If I don't I
> end up with errors because code is just running willy nilly in the page.
> 
> So I have this example function
> 
> function GetRaceinfo($raceId)
> {
>     // make sure there is a race id selected before attempting to pull data
>     if(isset($raceId))
>     {
>     ...do some stuff, etc....
>     }
> }
> 
> Then I have the link that is being written out like so:
> 
> <a href=\'events.php?id=\'' . $info['id'] . '>' . $info['name'] . '</a>
> 
> How can I switch this so when the link is clicked, it still calls
> events.php?id=
> but it does it via the function instead? Would I just do this:
> 
> <a href='<?php GetRaceinfo(' . $raceId .  ')?>'>linkname</a>
> 
> then at the end of my function use header to hit the page?
> 
> header('Location: http://blah.com/events.php?id=4');
> 
> I'm thinking I've got something backwards here though...
> 
> CC me at pixelmech at gee mail dot com if you can...thanks!
> 
> Tom


-- 
Bojan Tesanovic
http://www.classicio.com/
http://www.real-estates-sale.com/


From cnuccio at ltpro.com  Tue Oct 16 12:19:11 2007
From: cnuccio at ltpro.com (chris nuccio)
Date: Tue, 16 Oct 2007 12:19:11 -0500
Subject: [thelist] interactive advertising advice
Message-ID: <D307C13E-84FA-4B9A-90DD-7DC427F6144D@ltpro.com>

hello all,
been away for quite a while, and a client, who does automotive  
advertising, is doing a few flash banners, etc. which are  
subsequently distributed via interactive agencies based on some  
unknown strategy.  my question is, if one want to essentially become  
an expert quickly on formats, pixel dimensions, types of interactive  
gimmicks, etc, placement strategies, infometrics etc, where would one  
start?(beyond all the very unfocused google searching i have been  
doing).

  what i am getting at is being the geek in between the "old school"  
ad agency and whoever actually places the banners etc. to essentially  
translate. i have a web programming background, although i am a  
compressionist/ video guy these days.
a metaphor would be, if i needed to learn php, i would start at evolt.
is there a similar "home base" for interactive/ flash et al advertising?

sorry its so general but i never fail to at least get leads from the  
great people here.
thanks very much.


chris nuccio
cnuccio at ltpro.com





From Ron.Luther at hp.com  Tue Oct 16 13:08:39 2007
From: Ron.Luther at hp.com (Luther, Ron)
Date: Tue, 16 Oct 2007 18:08:39 -0000
Subject: [thelist] Rusty PHP questions...
In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4D89D95@ireland.spinhead.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<72E9FAA171D63B48AAC707C72900E6B4D89D95@ireland.spinhead.com>
Message-ID: <97D1949F5E36434E8DC375C1608538BF02491FAE@G3W0634.americas.hpqcorp.net>

Joel D Canfield noted:

> 1. One best practice is to never use SELECT * - could someone explain 
> why, and tell me when this is okay if ever? Right now I am doing this:

>>my primary argument is future needs: listing all the columns makes it 
>>really easy to change from 'select * ' to 'select * except for column 
>>13' which you can't do. it's also self-documenting. right there in
your 
>>code you've got all the column names, when you come back in six weeks 
>>to adjust something.


Hi Tom,

Let me build on Joel's good example.  I think many people view 'select
*' as lazy 
or as fast but somehow less than best practice -- but they don't see any
real 
harm to it, right?  What could it hurt?   ;-)

My guess is that this is probably because they may have 'ownership' of
the entire 
data chain from creation to manipulation to loading and reporting.  They
know 
everything about the data flow and approve or personally make any
changes that 
happen.  They have full control.  That's nice.  But that's not always
the case.

Sometimes you are not the only developer working off that data store.
Sometimes 
you are not the only person or the only group who can affect a change to
the 
table structure.  That is the case where 'select *' gets scary, and why
it's a 
good idea to give up the practice now.  It doesn't "scale" to working on
bigger 
projects with bigger teams ... for potentially bigger money ;-).

* Now, right off the bat, if your design depended on a fixed number of
columns 
or on a specific field structure (e.g. "name" is field # 3 or the total
number 
of fields is divisible by four) then any structural table change has the
potential 
to completely flummox your design and break your app ... And pretty much
generally 
trash years of cumulative work.  Fun Stuff!

* Granted, fields are often added at the end of the table, which can
still wreck 
your design, but usually not as badly.  But rework is always fun, right?

So let's look at a different issue.

* Those newly added db fields may contain confidential information that
should 
not be made available to the audience you are 'select *'-ing to.
Consider an 
extra-net application made available to your suppliers and large
customers.  If 
some dba in another part of the company thinks adding supplier credit
ratings to 
this table is a good idea, then _your_ [select * --> display *]
application 
(perhaps written years before the table change) may suddenly expose the
company 
to legal liabilities ... which is not a conversation you want to be on
the receiving 
end of!

There are a lot of areas; HR applications, Payroll applications, Finance
applications 
where it may turn out to be MUCH more than merely a bad idea to 'select
*'.

It's safest to explicitly call out the fields you intend to use.  [More
readable and 
better documentation too!]  Select * is more than just lazy - it can get
you and the 
company into hot water.


HTH,
RonL.


From jslist at sbcglobal.net  Tue Oct 16 13:40:34 2007
From: jslist at sbcglobal.net (j s)
Date: Tue, 16 Oct 2007 11:40:34 -0700 (PDT)
Subject: [thelist] Web Page Headers with a Variable
Message-ID: <203403.70092.qm@web81005.mail.mud.yahoo.com>

Hi,

I'm sure this has been covered before but...  I'm producing reports thru the web with asp.  I'm printing headers with CSS to avoid line counting and sometimes character counting (line wrap).  The reports are broken down by different areas.  When a new page shows up to print is there anyway to grab the current area and have it print up in the header?  CSS generates the header at print time not when the page is generated on the server so I'm not sure it can be done.  

Jess


From kendsnyder at gmail.com  Tue Oct 16 14:19:10 2007
From: kendsnyder at gmail.com (Ken Snyder)
Date: Tue, 16 Oct 2007 13:19:10 -0600
Subject: [thelist] Web Page Headers with a Variable
In-Reply-To: <203403.70092.qm@web81005.mail.mud.yahoo.com>
References: <203403.70092.qm@web81005.mail.mud.yahoo.com>
Message-ID: <dbdcbc940710161219u1898b1e6m92c7ba1560fad08c@mail.gmail.com>

On 10/16/07, j s <jslist at sbcglobal.net> wrote:
> ... When a new page shows up to print is there anyway to grab the current area and have it print up in the header?  ...

I thought that specifying page header/footer with CSS was only
available in CSS3 which isn't supported by browsers yet.  I've always
had to do a print to PDF when header/footer was important.

I'd be really interested if CSS can currently control page
header/footer!  Does anyone know for sure?

- Ken Snyder


From soniethomas at gmail.com  Tue Oct 16 23:10:51 2007
From: soniethomas at gmail.com (soniethomas at gmail.com)
Date: Tue, 16 Oct 2007 21:10:51 -0700 (PDT)
Subject: [thelist] Form submit to iframe
Message-ID: <47158b4b.1cef600a.6fa6.fffff6c2@mx.google.com>

Hi all,
 I have a web application in which i open many screens in the same browser. I do this by dynamically creating iframes and hiding and displaying them selectively. What I want to achieve now is this:
 When I submit a form on one page, it should target a new iframe, i am dynamically creating. I tried setting the target through javascript to the name of the new form, the form object etc.. Whatever I do, the submit opens up a new browser window. I am submitting the page through javascript using, theForm.submit(). Any idea why its not working properly?

Thanks.







	
_____________________________ 
I sent this email  using Morange. 
Get push email, news, IM on your mobile phone for free at: http://www.morange.com

----- Original Message -----
From: "thelist-request at lists.evolt.org" <thelist-request at lists.evolt.org>
To: thelist at lists.evolt.org
Sent: Sun, 14 Oct 2007 12:00:04 -0500
ReplyTo: thelist at lists.evolt.org
Subject: thelist Digest, Vol 56, Issue 14



Send thelist mailing list submissions to
	thelist at lists.evolt.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.evolt.org/mailman/listinfo/thelist
or, via email, send a message with subject or body 'help' to
	thelist-request at lists.evolt.org

You can reach the person managing the list at
	thelist-owner at lists.evolt.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of thelist digest..."


Today's Topics:

   1. Re:  from text to quicktime player (Shawn K. Quinn)
   2. Re:  from text to quicktime player (marianna)
   3. Re:  from text to quicktime player (Shawn K. Quinn)
   4. Re:  from text to quicktime player (marianna)
   5. Re:  Form data to office database (Jon Molesa)
   6. Re:  from text to quicktime player (Stephen Rider)


----------------------------------------------------------------------

Message: 1
Date: Sat, 13 Oct 2007 12:32:31 -0500
From: "Shawn K. Quinn" <skquinn at speakeasy.net>
Subject: Re: [thelist] from text to quicktime player
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Message-ID: <1192296751.4973.2.camel at xevious.platypuslabs.org>
Content-Type: text/plain

On Fri, 2007-10-12 at 15:23 -0700, marianna wrote:
> is there a way to launch a quicktime movie from text? and how would
> that
> look like?

The same as any other link, if I understand what you're asking
correctly:

<a href="mymovie.mov"> my movie </a>

-- 
Shawn K. Quinn <skquinn at speakeasy.net>



------------------------------

Message: 2
Date: Sat, 13 Oct 2007 11:09:52 -0700
From: marianna <wemac2 at pacbell.net>
Subject: Re: [thelist] from text to quicktime player
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Message-ID: <C3365800.EAC3%wemac2 at pacbell.net>
Content-Type: text/plain;	charset="US-ASCII"

with your code another window opens and plays the movie in the browser. i
would like a link that opens quicktime player on the viewer's computer.
that's what i am having trouble with.

here is how i make it happen with a poster movie and javascript:

<script language="javascript">
QT_WriteOBJECT_XHTML('postermovie.mov' , 'xx' , 'yy' , '' , 'controller' ,
'false' , 'autoplay' , 'false' , 'kioskmode' , 'true' , 'href' , 'movie.mov'
, 'target' , 'quicktimeplayer' ); </script>

i know nothing about javascript and so don't know how to incorporate text
into that script in place of postermovie.mov

i hope i was able to explain this.

thanks,
marianna




Shawn K. Quinn wrote:

> On Fri, 2007-10-12 at 15:23 -0700, marianna wrote:
>> is there a way to launch a quicktime movie from text? and how would
>> that
>> look like?
> 
> The same as any other link, if I understand what you're asking
> correctly:
> 
> <a href="mymovie.mov"> my movie </a>




------------------------------

Message: 3
Date: Sat, 13 Oct 2007 13:32:01 -0500
From: "Shawn K. Quinn" <skquinn at speakeasy.net>
Subject: Re: [thelist] from text to quicktime player
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Message-ID: <1192300322.4973.7.camel at xevious.platypuslabs.org>
Content-Type: text/plain

On Sat, 2007-10-13 at 11:09 -0700, marianna wrote:
> with your code another window opens and plays the movie in the
> browser. i
> would like a link that opens quicktime player on the viewer's
> computer.
> that's what i am having trouble with.

The links themselves don't do that, that depends entirely on the user's
browser configuration.

Note that if you have something which uses Javascript without a
non-Javascript alternative, users without Javascript (note that
Javascript is not always enabled even if the capability is there) will
not be able to access the Quicktime movie *at all*; there's a reason I
use the phrase "(site held together with) duck tape, Javascipt, and
Flash".

-- 
Shawn K. Quinn <skquinn at speakeasy.net>



------------------------------

Message: 4
Date: Sat, 13 Oct 2007 16:00:32 -0700
From: marianna <wemac2 at pacbell.net>
Subject: Re: [thelist] from text to quicktime player
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Message-ID: <C3369C20.EADD%wemac2 at pacbell.net>
Content-Type: text/plain;	charset="US-ASCII"

actually this is an internal website for view by other computers that are
macs and have quicktime, so no worries about computers and what is
installed.

but if i call the quicktimeplayer through a postermovie in javascript, it
opens the quicktimeplayer. but i just don't know how to do this through
text. perhaps i have to create a text file and call the quicktime player
though this file?

thanks,
marianna 


Shawn K. Quinn wrote:

> On Sat, 2007-10-13 at 11:09 -0700, marianna wrote:
>> with your code another window opens and plays the movie in the
>> browser. i
>> would like a link that opens quicktime player on the viewer's
>> computer.
>> that's what i am having trouble with.
> 
> The links themselves don't do that, that depends entirely on the user's
> browser configuration.
> 
> Note that if you have something which uses Javascript without a
> non-Javascript alternative, users without Javascript (note that
> Javascript is not always enabled even if the capability is there) will
> not be able to access the Quicktime movie *at all*; there's a reason I
> use the phrase "(site held together with) duck tape, Javascipt, and
> Flash".




------------------------------

Message: 5
Date: Sat, 13 Oct 2007 21:45:04 -0400
From: Jon Molesa <rjmolesa at consoltec.net>
Subject: Re: [thelist] Form data to office database
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Message-ID: <20071014014504.GA2495 at jenna.rjmolesa.homelinux.net>
Content-Type: text/plain; charset=us-ascii

This not elegant code by any means, but it did the trick in a pinch for
me a few months back on a job.  HIH.

$i=0;
$header = '';
$data = '';

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
	$f=1;  // this was needed because for some reason it was skipping the
		   // first row of data

	foreach($row as $key => $val)
	{
		$cnt = count($row);
		
		if($i==0){
			if($f==$cnt){  // i had to add this test as well.
				$header .= "\"".$key."\"\n";
				$data .= "\"".$val."\"\n";
			}else{
				$header .= "\"".$key."\",";
				$data .= "\"".$val."\",";
			}
		}else{
			if($f==$cnt){  // i never quite figured out why.
				$data .= "\"".$val."\"\n";
			}else{
				$data .= "\"".$val."\",";
			}
		}
		$f++;
	}
	$i++;
}

// this would output our csv data.  To do it in a browser, you'll need
// to send the appropriate headers as well.  Then it'll open
// automatically in Excel.
// you may want to change the output method though
echo $header;
echo $data;


I just remembered why that was needed.  I needed a way to not insert the
commas on the last column of data.

-- 
Jon Molesa
rjmolesa at consoltec.net
http://rjmolesa.com


------------------------------

Message: 6
Date: Sun, 14 Oct 2007 01:22:53 -0500
From: Stephen Rider <evolt_org at striderweb.com>
Subject: Re: [thelist] from text to quicktime player
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Message-ID: <8895F0D0-AA4F-42B8-887D-B40F401ADDEA at striderweb.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed

I would think a little DOM scripting would be in order.  Use  
JavaScript to replace the link (or some other element) with the  
Quicktime movie itself, set to autoplay.

Just a thought.

Stephen


On Oct 13, 2007, at 6:00 PM, marianna wrote:

> actually this is an internal website for view by other computers  
> that are
> macs and have quicktime, so no worries about computers and what is
> installed.
>
> but if i call the quicktimeplayer through a postermovie in  
> javascript, it
> opens the quicktimeplayer. but i just don't know how to do this  
> through
> text. perhaps i have to create a text file and call the quicktime  
> player
> though this file?
>
> thanks,
> marianna
>
>
> Shawn K. Quinn wrote:
>
>> On Sat, 2007-10-13 at 11:09 -0700, marianna wrote:
>>> with your code another window opens and plays the movie in the
>>> browser. i
>>> would like a link that opens quicktime player on the viewer's
>>> computer.
>>> that's what i am having trouble with.
>>
>> The links themselves don't do that, that depends entirely on the  
>> user's
>> browser configuration.
>>
>> Note that if you have something which uses Javascript without a
>> non-Javascript alternative, users without Javascript (note that
>> Javascript is not always enabled even if the capability is there)  
>> will
>> not be able to access the Quicktime movie *at all*; there's a  
>> reason I
>> use the phrase "(site held together with) duck tape, Javascipt, and
>> Flash".
>
>
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !



------------------------------

_______________________________________________
Help: http://lists.evolt.org/mailman/listinfo/thelist

Archives: http://lists.evolt.org

End of thelist Digest, Vol 56, Issue 14
***************************************

From kasimir.k.lists at gmail.com  Wed Oct 17 03:41:35 2007
From: kasimir.k.lists at gmail.com (kasimir-k)
Date: Wed, 17 Oct 2007 08:41:35 +0000
Subject: [thelist] Form submit to iframe
In-Reply-To: <47158b4b.1cef600a.6fa6.fffff6c2@mx.google.com>
References: <47158b4b.1cef600a.6fa6.fffff6c2@mx.google.com>
Message-ID: <4715CABF.9070200@gmail.com>

soniethomas at gmail.com scribeva in 17/10/2007 4:10:
> I tried setting the target through javascript to the name of the new form,
> the form object etc.. Whatever I do, the submit opens up a new browser window.

Set the form's target attribute to the name of the iframe you want to 
submit it to.

And please, when starting a new thread on a list like this, please 
create a new mail instead of just replying to a random mail (to enable 
thread view), or at leas delete first the content of old mail! Every 
single byte needs energy to move around, and you sent ten thousand 
unnecessary ones... In this time and age every bit counts ;-)

.k


From jthjothi at yahoo.com  Wed Oct 17 08:52:49 2007
From: jthjothi at yahoo.com (jothi jothi)
Date: Wed, 17 Oct 2007 06:52:49 -0700 (PDT)
Subject: [thelist] Your PHP installation does not support PostgreSQL. You
	need to recompile PHP using the --with-pgsql configure option.
Message-ID: <630411.39705.qm@web53707.mail.re2.yahoo.com>

i am a student doing a project in using php and xampp server..now i have t use posgresql..i had installed the posgresql ready...but when i got below errors as i comile one of the coding...
   
   
  Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
   
      Fatal error: Call to undefined function: pg_connect() in C:\Program Files\xampp\htdocs\posgre.php on line 54
   
   
  1.can some one explain to me ,how n recompile the php?
  2.Why the pg_connect function is undefined?
  3.How i know that i have installed the posgresql correctly?
  4.How i can run the server?
   
   
  below is my coding....
  <html> 
    <body> 
        <table border="0" cellspacing="0" cellpadding="0"> 
            <tr> 
                <td> 
                    ID
                </td> 
                <td> 
                   voltage
                </td> 
                <td> 
                    temp
                </td> 
                <td> 
                    light 
                </td> 
                  <td> 
                    accel_x
                </td> 
  
                <td> 
                    accel_y
                </td> 
   
                  <td> 
                    mag_x
                </td> 
   
                  <td> 
                    mag_y
                </td> 
  
                <td> 
                    mic
                </td> 
   
  
                <td> 
                    Time
                </td> 
  
            </tr> 
        <?php 
$conn = pg_connect("host=localhost  
   port=5432  
   dbname=task  
   user=tele
   password=tiny");
       
     $query = "SELECT * FROM sample_mts310"; 
          $result = pg_query($query); 
        if (!$result) { 
            echo "Problem with query " . $query . "<br/>"; 
            echo pg_last_error(); 
            exit(); 
        } 
          while($myrow = pg_fetch_assoc($result)) { 
            printf ("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $myrow['Id'], $myrow['voltage'], $myrow['temp'], $myrow['light'],$myrow['accel_x'],$myrow['accel_y'],$myrow['mag_x'],$myrow['mag_y'],$myrow['mic'],$myrow['time']); 
        } 
        ?> 
        </table> 
    </body> 
</html> 
   
   
  
your help is very much appreciated...

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

From hassan.schroeder at gmail.com  Wed Oct 17 09:27:49 2007
From: hassan.schroeder at gmail.com (Hassan Schroeder)
Date: Wed, 17 Oct 2007 07:27:49 -0700
Subject: [thelist] Your PHP installation does not support PostgreSQL.
	You need to recompile PHP using the --with-pgsql configure option.
In-Reply-To: <630411.39705.qm@web53707.mail.re2.yahoo.com>
References: <630411.39705.qm@web53707.mail.re2.yahoo.com>
Message-ID: <4eedb92a0710170727w31acbd1m30cdbd0e3ea56288@mail.gmail.com>

On 10/17/07, jothi jothi <jthjothi at yahoo.com> wrote:
> i am a student doing a project in using php and xampp server..now i have t use posgresql..i had installed the posgresql ready...but when i got below errors as i comile one of the coding...
>
>   Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
>
>       Fatal error: Call to undefined function: pg_connect() in C:\Program Files\xampp\htdocs\posgre.php on line 54
>
>   1.can some one explain to me ,how n recompile the php?

Download the source and follow the directions :-)

>   2.Why the pg_connect function is undefined?

? You already have the answer -- your version of PHP doesn't
include the PostgreSQL functions.

>   3.How i know that i have installed the posgresql correctly?

When (1) it starts and (2) you can connect to it from a client.

>   4.How i can run the server?

Um, as you would any other command? Or are you asking about
creating a start-on-boot script? That would depend on your OS.

Good luck,
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com


From jslist at sbcglobal.net  Wed Oct 17 09:51:33 2007
From: jslist at sbcglobal.net (j s)
Date: Wed, 17 Oct 2007 07:51:33 -0700 (PDT)
Subject: [thelist] Crystal Reports
Message-ID: <228907.25393.qm@web81001.mail.mud.yahoo.com>

Anyone have some good references for crystal reports with Visual Studio 2005 - and placing them on the web?

Thanks
Jess


From tymartist at gmail.com  Wed Oct 17 09:52:35 2007
From: tymartist at gmail.com (Tim Palac)
Date: Wed, 17 Oct 2007 09:52:35 -0500
Subject: [thelist] Good Mid-Range CMS Options?
Message-ID: <c05813000710170752h3c8d09d3if4ef7bae0d635f93@mail.gmail.com>

Hey list,

I don't post very often, but I definitely appreciate being a part of such a
list and having the opportunity to hear all the great input you have to
offer.

Hopefully you can help me out - The organization I work for, a small
non-profit (75 people or so) is looking for a new CMS.  We're currently
running PaperThin's CommonSpot (yuck!) and looking to move to a similar
mid-range application.  It would preferrably be something that supports
XML/XSLT and works well when integrating with a back end AMS (database).

Right now, our front runner is Ingeniux, but I've been told to keep an eye
out for potential other number 2 options, since we don't have any others
we're that impressed with from a list of Ektron, SiteCore, Hannon Hill's
Cascade, Serena Collage, and Conductor.

If you have any positive feedback on any of our second options for a new CMS
in terms of what we're looking for, that would be awesome.  If you happen to
know of an alternative option for a new CMS in the same price range, that
would be appreciated as well :)

Thanks all!  You're of wonderful help :)

Tim
IM: TymArtist
www.timpalac.com


From fredthejonester at gmail.com  Wed Oct 17 09:12:06 2007
From: fredthejonester at gmail.com (Fred Jones)
Date: Wed, 17 Oct 2007 17:12:06 +0300
Subject: [thelist] Good Mid-Range CMS Options?
In-Reply-To: <c05813000710170752h3c8d09d3if4ef7bae0d635f93@mail.gmail.com>
References: <c05813000710170752h3c8d09d3if4ef7bae0d635f93@mail.gmail.com>
Message-ID: <47161836.7000308@gmail.com>

> Hopefully you can help me out - The organization I work for, a small
> non-profit (75 people or so) is looking for a new CMS.  We're currently
> running PaperThin's CommonSpot (yuck!) and looking to move to a similar
> mid-range application.  It would preferrably be something that supports
> XML/XSLT and works well when integrating with a back end AMS (database).

For NPO check out: http://civicrm.org/

I recommend running it on http://drupal.org/ , an excellent all-purpose 
CMS, which has XML/XLST and is infinitely expandable with modules.

Fred


From tymartist at gmail.com  Wed Oct 17 10:16:35 2007
From: tymartist at gmail.com (Tim Palac)
Date: Wed, 17 Oct 2007 10:16:35 -0500
Subject: [thelist] Good Mid-Range CMS Options?
In-Reply-To: <47161836.7000308@gmail.com>
References: <c05813000710170752h3c8d09d3if4ef7bae0d635f93@mail.gmail.com>
	<47161836.7000308@gmail.com>
Message-ID: <c05813000710170816m5f44446bs2119eda083271b59@mail.gmail.com>

Sorry I forgot to mention that we're looking for vendor software, since
we're going to need a bunch of help, consulting, and support.

And also, we're going to be running on a .NET platform, so PHP is sort of
out of the question (needs to be .NET or Platform-Independent)

Tim

On 10/17/07, Fred Jones <fredthejonester at gmail.com> wrote:
>
> > Hopefully you can help me out - The organization I work for, a small
> > non-profit (75 people or so) is looking for a new CMS.  We're currently
> > running PaperThin's CommonSpot (yuck!) and looking to move to a similar
> > mid-range application.  It would preferrably be something that supports
> > XML/XSLT and works well when integrating with a back end AMS (database).
>
> For NPO check out: http://civicrm.org/
>
> I recommend running it on http://drupal.org/ , an excellent all-purpose
> CMS, which has XML/XLST and is infinitely expandable with modules.
>
> Fred
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From fredthejonester at gmail.com  Wed Oct 17 09:23:44 2007
From: fredthejonester at gmail.com (Fred Jones)
Date: Wed, 17 Oct 2007 17:23:44 +0300
Subject: [thelist] Good Mid-Range CMS Options?
In-Reply-To: <c05813000710170816m5f44446bs2119eda083271b59@mail.gmail.com>
References: <c05813000710170752h3c8d09d3if4ef7bae0d635f93@mail.gmail.com>	<47161836.7000308@gmail.com>
	<c05813000710170816m5f44446bs2119eda083271b59@mail.gmail.com>
Message-ID: <47161AF0.30208@gmail.com>

Tim Palac wrote:
> Sorry I forgot to mention that we're looking for vendor software, since
> we're going to need a bunch of help, consulting, and support.
> 
> And also, we're going to be running on a .NET platform, so PHP is sort of
> out of the question (needs to be .NET or Platform-Independent)

Just to add one more 2 cents worth, you can hire a CiviCRM consultant 
and PHP and MySQL are 100% platform independent, or at least they run on 
all major platforms. :)

Fred


From jslist at sbcglobal.net  Wed Oct 17 09:49:24 2007
From: jslist at sbcglobal.net (j s)
Date: Wed, 17 Oct 2007 07:49:24 -0700 (PDT)
Subject: [thelist] Web Page Headers with a Variable
Message-ID: <178789.80770.qm@web81006.mail.mud.yahoo.com>

To get a header and footer in place I used this code.  The trick was to put it all in 1 big table and place the header then footer on top.  

<style type="text/css">
<!--
thead { display: table-header-group;}
tfoot { display: table-footer-group;} 
-->
</style>


<table width="747" border="0" cellpadding="0">
<thead>         <%'~~~~~~~~~~~~~~~~~THEAD~~~~~~~~~~~~%>
  <tr>
    <td width="856"><table width="100%" border="0" cellpadding="0" class="textBold">
      <tr>
        <td colspan="6"><img src="../images/logo.jpg" width="200" height="47" align="left"> <table width="458" border="0" cellpadding="0">
          <tr>
            <td width="642"><div align="center">
              <p class="textBold">Summary by Area</p>
              <p class="textBold">As of <%=(FormatDateTime(Now(),2))%><br>
&nbsp;&nbsp;&nbsp; </p>
            </div></td>
          </tr>
        </table>          <div align="center"></div>
        </td>
        </tr>
      <tr>
        <td width="27%" >&nbsp;</td>
        <td width="11%" valign="top">State&nbsp;</td>
        <td width="18%" valign="top"><div align="left">Type</div>
      &nbsp;</td>
        <td width="15%" valign="top"><div align="right">Total Area</div>
      &nbsp;</td>
        <td width="15%" valign="top"><div align="right">Total Counts</div>
      &nbsp;</td>
        <td width="14%" valign="top">&nbsp;</td>
      </tr>
      
    </table>
 </td>
  </tr>
  </thead>
  <tfoot>         <%'~~~~~~~~~~~~~~~~~TFOOT~~~~~~~~~~~~%>
  <tr>
    <td>&nbsp;</td>
  </tr>
  </tfoot>
  <tbody>  
    body of page
 </tbody>
</table>
</body>

----- Original Message ----
From: Ken Snyder <kendsnyder at gmail.com>
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Sent: Tuesday, October 16, 2007 2:19:10 PM
Subject: Re: [thelist] Web Page Headers with a Variable

On 10/16/07, j s <jslist at sbcglobal.net> wrote:
> ... When a new page shows up to print is there anyway to grab the current area and have it print up in the header?  ...

I thought that specifying page header/footer with CSS was only
available in CSS3 which isn't supported by browsers yet.  I've always
had to do a print to PDF when header/footer was important.

I'd be really interested if CSS can currently control page
header/footer!  Does anyone know for sure?

- Ken Snyder
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !


From kendsnyder at gmail.com  Wed Oct 17 10:40:26 2007
From: kendsnyder at gmail.com (Ken Snyder)
Date: Wed, 17 Oct 2007 09:40:26 -0600
Subject: [thelist] Web Page Headers with a Variable
In-Reply-To: <178789.80770.qm@web81006.mail.mud.yahoo.com>
References: <178789.80770.qm@web81006.mail.mud.yahoo.com>
Message-ID: <dbdcbc940710170840g5d1ffa88j826154b16038e2d4@mail.gmail.com>

On 10/17/07, j s <jslist at sbcglobal.net> wrote:
> To get a header and footer in place I used this code.  The trick was to put it all in 1 big table and place the header then footer on top.t
>
> <style type="text/css">
> <!--
> thead { display: table-header-group;}
> tfoot { display: table-footer-group;}
> -->
> </style>
> ...

That is pretty cool!  Does it work on IE6? Safari 3?

- Ken Snyder


From jslist at sbcglobal.net  Wed Oct 17 11:03:48 2007
From: jslist at sbcglobal.net (j s)
Date: Wed, 17 Oct 2007 09:03:48 -0700 (PDT)
Subject: [thelist] Web Page Headers with a Variable
Message-ID: <138559.14944.qm@web81008.mail.mud.yahoo.com>

Thanks

Works in IE 6 & 7.  I'm not sure on Safari.  But works in Firefox.  To get the page numbers in IE you do 
File -> Page Setup -> In the footer line put 
&bPage &p of &P            <-    this is usually the default.
So I'm not worring about the page numbers either.

----- Original Message ----
From: Ken Snyder <kendsnyder at gmail.com>
To: "thelist at lists.evolt.org" <thelist at lists.evolt.org>
Sent: Wednesday, October 17, 2007 10:40:26 AM
Subject: Re: [thelist] Web Page Headers with a Variable

On 10/17/07, j s <jslist at sbcglobal.net> wrote:
> To get a header and footer in place I used this code.  The trick was to put it all in 1 big table and place the header then footer on top.t
>
> <style type="text/css">
> <!--
> thead { display: table-header-group;}
> tfoot { display: table-footer-group;}
> -->
> </style>
> ...

That is pretty cool!  Does it work on IE6? Safari 3?

- Ken Snyder
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !


From hassan.schroeder at gmail.com  Wed Oct 17 11:31:34 2007
From: hassan.schroeder at gmail.com (Hassan Schroeder)
Date: Wed, 17 Oct 2007 09:31:34 -0700
Subject: [thelist] interactive advertising advice
In-Reply-To: <D307C13E-84FA-4B9A-90DD-7DC427F6144D@ltpro.com>
References: <D307C13E-84FA-4B9A-90DD-7DC427F6144D@ltpro.com>
Message-ID: <4eedb92a0710170931n554168bn158a645316d4b8d8@mail.gmail.com>

On 10/16/07, chris nuccio <cnuccio at ltpro.com> wrote:

>                                my question is, if one want to essentially become
> an expert quickly on formats, pixel dimensions, types of interactive
> gimmicks, etc, placement strategies, infometrics etc, where would one
> start?

If it were me:  <http://iab.com/>  :-)

HTH,
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com


From mydarb at gmail.com  Wed Oct 17 11:29:45 2007
From: mydarb at gmail.com (Brady Mitchell)
Date: Wed, 17 Oct 2007 09:29:45 -0700
Subject: [thelist] Your PHP installation does not support PostgreSQL.
 You	need to recompile PHP using the --with-pgsql configure option.
In-Reply-To: <630411.39705.qm@web53707.mail.re2.yahoo.com>
References: <630411.39705.qm@web53707.mail.re2.yahoo.com>
Message-ID: <47163879.5020104@gmail.com>

You need to enable the postgres extension for PHP. Open php.ini and find 
the line ";extension=php_pgsql.dll" and remove the ; from the beginning. 
Once you do that and restart apache you should be able to use the 
postgres functions from php.

If you're not familiar with phpinfo(), take a look at it. Create a php 
file and call the phpinfo function and browse to it. This function gives 
you all kinds of information about PHP including which extensions are 
enabled, where php.ini is located, and more.

I don't know what you're asking in questions 3 and 4 - are you asking 
how to install postgres? Go to http://www.postgresql.org/download/ and 
follow the links there - that page also lists some graphical clients.

Brady

jothi jothi wrote:
> i am a student doing a project in using php and xampp server..now i have t use posgresql..i had installed the posgresql ready...but when i got below errors as i comile one of the coding...
>    
>    
>   Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
>    
>       Fatal error: Call to undefined function: pg_connect() in C:\Program Files\xampp\htdocs\posgre.php on line 54
>    
>    
>   1.can some one explain to me ,how n recompile the php?
>   2.Why the pg_connect function is undefined?
>   3.How i know that i have installed the posgresql correctly?
>   4.How i can run the server?
>    
>    
>   below is my coding....
>   <html> 
>     <body> 
>         <table border="0" cellspacing="0" cellpadding="0"> 
>             <tr> 
>                 <td> 
>                     ID
>                 </td> 
>                 <td> 
>                    voltage
>                 </td> 
>                 <td> 
>                     temp
>                 </td> 
>                 <td> 
>                     light 
>                 </td> 
>                   <td> 
>                     accel_x
>                 </td> 
>   
>                 <td> 
>                     accel_y
>                 </td> 
>    
>                   <td> 
>                     mag_x
>                 </td> 
>    
>                   <td> 
>                     mag_y
>                 </td> 
>   
>                 <td> 
>                     mic
>                 </td> 
>    
>   
>                 <td> 
>                     Time
>                 </td> 
>   
>             </tr> 
>         <?php 
> $conn = pg_connect("host=localhost  
>    port=5432  
>    dbname=task  
>    user=tele
>    password=tiny");
>        
>      $query = "SELECT * FROM sample_mts310"; 
>           $result = pg_query($query); 
>         if (!$result) { 
>             echo "Problem with query " . $query . "<br/>"; 
>             echo pg_last_error(); 
>             exit(); 
>         } 
>           while($myrow = pg_fetch_assoc($result)) { 
>             printf ("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $myrow['Id'], $myrow['voltage'], $myrow['temp'], $myrow['light'],$myrow['accel_x'],$myrow['accel_y'],$myrow['mag_x'],$myrow['mag_y'],$myrow['mic'],$myrow['time']); 
>         } 
>         ?> 
>         </table> 
>     </body> 
> </html> 
>    
>    
>   
> your help is very much appreciated...
> 
>  __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 



From kasimir.k.lists at gmail.com  Wed Oct 17 12:25:10 2007
From: kasimir.k.lists at gmail.com (kasimir-k)
Date: Wed, 17 Oct 2007 17:25:10 +0000
Subject: [thelist] Your PHP installation does not support PostgreSQL.
 You	need to recompile PHP using the --with-pgsql configure option.
In-Reply-To: <630411.39705.qm@web53707.mail.re2.yahoo.com>
References: <630411.39705.qm@web53707.mail.re2.yahoo.com>
Message-ID: <47164576.8060800@gmail.com>

jothi jothi scribeva in 17/10/2007 13:52:
>   3.How i know that i have installed the posgresql correctly?
>   4.How i can run the server?

HTH:
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html


.k


From pubs at audettemedia.com  Wed Oct 17 13:05:37 2007
From: pubs at audettemedia.com (Adam Audette)
Date: Wed, 17 Oct 2007 11:05:37 -0700
Subject: [thelist] Good Mid-Range CMS Options?
In-Reply-To: <mailman.7.1192640405.28921.thelist@lists.evolt.org>
Message-ID: <5.2.0.9.2.20071017110340.06bde658@mail.audettemedia.com>

Tim,

Hannon Hill's Cascade Server might be worth a look: 
http://www.hannonhill.com/index.html

-adam


-----
Adam Audette
LED Digest | Marketing Discussion List
http://www.led-digest.com


At 12:00 PM 10/17/2007 -0500, you wrote:
>Message: 10
>Date: Wed, 17 Oct 2007 09:52:35 -0500
>From: "Tim Palac" <tymartist at gmail.com>
>Subject: [thelist] Good Mid-Range CMS Options?
>To: thelist at lists.evolt.org
>Message-ID:
> 
><c05813000710170752h3c8d09d3if4ef7bae0d635f93 at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>Hey list,
>
>I don't post very often, but I definitely appreciate being a part 
>of such a
>list and having the opportunity to hear all the great input you 
>have to
>offer.
>
>Hopefully you can help me out - The organization I work for, a small
>non-profit (75 people or so) is looking for a new CMS.  We're 
>currently
>running PaperThin's CommonSpot (yuck!) and looking to move to a 
>similar
>mid-range application.  It would preferrably be something that 
>supports
>XML/XSLT and works well when integrating with a back end AMS 
>(database).
>
>Right now, our front runner is Ingeniux, but I've been told to 
>keep an eye
>out for potential other number 2 options, since we don't have any 
>others
>we're that impressed with from a list of Ektron, SiteCore, Hannon 
>Hill's
>Cascade, Serena Collage, and Conductor.
>
>If you have any positive feedback on any of our second options for 
>a new CMS
>in terms of what we're looking for, that would be awesome.  If you 
>happen to
>know of an alternative option for a new CMS in the same price 
>range, that
>would be appreciated as well :)
>
>Thanks all!  You're of wonderful help :)
>
>Tim
>IM: TymArtist
>www.timpalac.com



From roberto at castelosnoar.com  Wed Oct 17 13:17:20 2007
From: roberto at castelosnoar.com (=?ISO-8859-1?Q?Roberto_Gorj=E3o?=)
Date: Wed, 17 Oct 2007 19:17:20 +0100
Subject: [thelist] best practices on video in web pages
Message-ID: <471651B0.90002@castelosnoar.com>

Hi,

I'm trying to write a sort of technical manual, to this organization of 
which I'm a member, about best use and integration of video in web 
pages... I wonder if someone has good references/bookmarks to point me 
to about this subject.

I'm specially interested in references that:

   * describe the chronological evolution of the video use on the web;
   * discuss formats and its advantages/disadvantages;
   * discuss best practices, both from the coder's and the user's point
     of view (including usability and accessibility);

Thanks in advance to all!

Roberto

-- 
-------------------- Roberto Gorj?o
freelance designer and web designer
personal site: www.castelosnoar.com
PORTUGAL / BRAGA / P?VOA DE LANHOSO



From Paul.Bennett at wcc.govt.nz  Wed Oct 17 13:54:23 2007
From: Paul.Bennett at wcc.govt.nz (Paul Bennett)
Date: Thu, 18 Oct 2007 07:54:23 +1300
Subject: [thelist] best practices on video in web pages
In-Reply-To: <471651B0.90002@castelosnoar.com>
References: <471651B0.90002@castelosnoar.com>
Message-ID: <F6284A42697D094DBAA8E7BF1594775F0D800341@exchmb1.net.ad.wcc.govt.nz>

Hi Roberto,

I've found Tom Green's articles invaluable. They hit most of your points.

http://www.digital-web.com/articles/the_rise_of_flash_video_part_1/
http://www.digital-web.com/articles/the_rise_of_flash_video_part_2/
http://www.digital-web.com/articles/the_rise_of_flash_video_part_3/

http://www.digital-web.com/articles/captions_flash_video/
http://www.digital-web.com/articles/captions_flash_video_2/

HTH,
Paul 


From tymartist at gmail.com  Wed Oct 17 14:01:45 2007
From: tymartist at gmail.com (Tim Palac)
Date: Wed, 17 Oct 2007 14:01:45 -0500
Subject: [thelist] Good Mid-Range CMS Options?
In-Reply-To: <5.2.0.9.2.20071017110340.06bde658@mail.audettemedia.com>
References: <mailman.7.1192640405.28921.thelist@lists.evolt.org>
	<5.2.0.9.2.20071017110340.06bde658@mail.audettemedia.com>
Message-ID: <c05813000710171201n3be9a2bageab68b68c2769173@mail.gmail.com>

Adam,

Thanks for the suggestion!  That's actually my second favorite of the one's
we have in the running, but my superiors weren't impressed with the amount
of back-end integration it offered in terms of login, search, blogs, and
integrating with our AMS.  If you have a story to contradict this, I'd love
to hear it because Cascade is definitely a great tool.

Thanks
Tim

On 10/17/07, Adam Audette <pubs at audettemedia.com> wrote:
>
> Tim,
>
> Hannon Hill's Cascade Server might be worth a look:
> http://www.hannonhill.com/index.html
>
> -adam
>
>
> -----
> Adam Audette
> LED Digest | Marketing Discussion List
> http://www.led-digest.com
>
>
> At 12:00 PM 10/17/2007 -0500, you wrote:
> >Message: 10
> >Date: Wed, 17 Oct 2007 09:52:35 -0500
> >From: "Tim Palac" <tymartist at gmail.com>
> >Subject: [thelist] Good Mid-Range CMS Options?
> >To: thelist at lists.evolt.org
> >Message-ID:
> >
> ><c05813000710170752h3c8d09d3if4ef7bae0d635f93 at mail.gmail.com>
> >Content-Type: text/plain; charset=ISO-8859-1
> >
> >Hey list,
> >
> >I don't post very often, but I definitely appreciate being a part
> >of such a
> >list and having the opportunity to hear all the great input you
> >have to
> >offer.
> >
> >Hopefully you can help me out - The organization I work for, a small
> >non-profit (75 people or so) is looking for a new CMS.  We're
> >currently
> >running PaperThin's CommonSpot (yuck!) and looking to move to a
> >similar
> >mid-range application.  It would preferrably be something that
> >supports
> >XML/XSLT and works well when integrating with a back end AMS
> >(database).
> >
> >Right now, our front runner is Ingeniux, but I've been told to
> >keep an eye
> >out for potential other number 2 options, since we don't have any
> >others
> >we're that impressed with from a list of Ektron, SiteCore, Hannon
> >Hill's
> >Cascade, Serena Collage, and Conductor.
> >
> >If you have any positive feedback on any of our second options for
> >a new CMS
> >in terms of what we're looking for, that would be awesome.  If you
> >happen to
> >know of an alternative option for a new CMS in the same price
> >range, that
> >would be appreciated as well :)
> >
> >Thanks all!  You're of wonderful help :)
> >
> >Tim
> >IM: TymArtist
> >www.timpalac.com
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From info at thesitedoctor.co.uk  Wed Oct 17 14:34:32 2007
From: info at thesitedoctor.co.uk (Tim Gaunt)
Date: Wed, 17 Oct 2007 20:34:32 +0100
Subject: [thelist] Good Mid-Range CMS Options?
In-Reply-To: <c05813000710170816m5f44446bs2119eda083271b59@mail.gmail.com>
References: <c05813000710170752h3c8d09d3if4ef7bae0d635f93@mail.gmail.com>	<47161836.7000308@gmail.com>
	<c05813000710170816m5f44446bs2119eda083271b59@mail.gmail.com>
Message-ID: <010301c810f4$be00d790$3a0286b0$@co.uk>

Hi Tim,

Sorry to come to this one late but it's been a manic day. Seeing as you're
looking for a .Net solution I think you may be interested in Umbraco[1], I
met with the main developer last night and he's a lovely chap. The system
also looks very promising though I'm yet to have an installation on a
production site (coming soon)

> Sorry I forgot to mention that we're looking for vendor software 
AFAIK there is a pro license available with includes support getting you up
and running etc

HTH
 
Tim
[1]www.umbraco.org



From bobm at dottedi.biz  Wed Oct 17 16:10:41 2007
From: bobm at dottedi.biz (Bob Meetin)
Date: Wed, 17 Oct 2007 15:10:41 -0600
Subject: [thelist] ecommerce - certificate / authorize.net / payment module
	configuration
Message-ID: <47167A51.1060004@dottedi.biz>

Sounds like a newbie questions I guess - as I haven't fully configured 
an ecommerce package from scratch in the past, only inherited. And I 
have not set up authorize.net before.

When you order/install a certificate to avoid domain mismatch problems, 
how should it be named to not cause errors? Say the domain is 
www.myshop.com, is is supposed to be identified as www.myshop.com or 
myshop.com or http://www.myshop.com?

The shopping cart module we are using is virtuemart (formerly phpshop).  
When I look through the available Payment Methods there is nothing 
preinstalled for authorize.net, but there is a function to add a new 
method.  I did a google on 'authorize.net virtuemart' and found source 
code for a payment module at: 
http://virtuemart.net/index.php?option=com_openwiki&Itemid=109&id=references:payment:examples:authnet 


I presume that I copy that into the appropriate path, then add 
Authorize.net as a payment method.  Is there more to this? 

Then on the Add Payment Method page (via the shopping cart admin 
console)  there are a number of fields to complete:

* Payment Method Name:   Authorize.net (yes?)
* Code: _____ (what goes here?)
* Payment class name :  ps_authorize (without the .php extension?)
* Payment method type: Check credit card option?  (Other options include 
Use Payment Processor)
* Accepted Credit Card Types?  How do I know?

The business owner's rep went through authorize.net and got for me the 
merchant login/password used to  to issue the API Transaction Key you 
need for the cart activation.  How/where is this information used? 

I'm feeling pretty but I would rather get this right than wrong.  If 
there is a tutorial that answers these questions in novice language 
please point me there.

Thx, Bob




From oktellme at earthlink.net  Wed Oct 17 17:20:39 2007
From: oktellme at earthlink.net (Lightening)
Date: Wed, 17 Oct 2007 18:20:39 -0400 (EDT)
Subject: [thelist] html div
Message-ID: <11891806.1192659639626.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>

Here is a question so simple, it embarasses me to ask. 

No matter -  it would embarass me more to continue to not know!

I've been coding my html with tables for years, but tables are not the right tool for this application.

So I am using DIV instead. 

Trouble I am having is the browser puts the various blocks of DIV where it wants to, and not where I want it to be.

I am trying to have a header, a footer, each spanning the page, and a left, center and right column. I am using css, if that matters. 

Would anyone please give me some pointers on how to get these divs properly aligned?

thanks , Laura

ps, code available on request.




From anthony at baratta.com  Wed Oct 17 17:27:31 2007
From: anthony at baratta.com (Anthony Baratta)
Date: Wed, 17 Oct 2007 15:27:31 -0700
Subject: [thelist] html div
Message-ID: <4a152002268227a115c0b1d9e5664c76@baratta.com>

In a nutshell. Div's need a width defined to function well. And look up "float". Between those two attributes and proper use of the br tag, you can mangle the div's into a structure you want.

-----Original message-----
From: Lightening oktellme at earthlink.net
Date: Wed, 17 Oct 2007 15:20:39 -0700
To: thelist at lists.evolt.org
Subject: [thelist] html div

> Here is a question so simple, it embarasses me to ask. 
> 
> No matter -  it would embarass me more to continue to not know!
> 
> I've been coding my html with tables for years, but tables are not the right tool for this application.
> 
> So I am using DIV instead. 
> 
> Trouble I am having is the browser puts the various blocks of DIV where it wants to, and not where I want it to be.
> 
> I am trying to have a header, a footer, each spanning the page, and a left, center and right column. I am using css, if that matters. 
> 
> Would anyone please give me some pointers on how to get these divs properly aligned?
> 
> thanks , Laura
> 
> ps, code available on request.
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 


From mydarb at gmail.com  Wed Oct 17 17:33:18 2007
From: mydarb at gmail.com (Brady Mitchell)
Date: Wed, 17 Oct 2007 15:33:18 -0700
Subject: [thelist] html div
In-Reply-To: <11891806.1192659639626.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
References: <11891806.1192659639626.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
Message-ID: <43f7a9ca0710171533of2972dbia8861f2ae8704145@mail.gmail.com>

Do a search for "CSS based site layout" on your favorite search engine
and you'll get lots of help.

Here's an article to start with:

http://www.devarticles.com/c/a/Web-Style-Sheets/DIV-Based-Layout-with-CSS/

Take a look at some of the designs at http://csszengarden.com/ and
http://www.oswd.org for some sample templates coded with CSS.

If you have specific questions on rules that aren't working, not
working as expected, etc, post them to the list. Your question is so
broad it's hard to give a useful answer other than pointing you to
some articles.

Brady


From joel at streamliine.com  Wed Oct 17 17:30:17 2007
From: joel at streamliine.com (Joel D Canfield)
Date: Wed, 17 Oct 2007 15:30:17 -0700
Subject: [thelist] html div
References: <11891806.1192659639626.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
Message-ID: <72E9FAA171D63B48AAC707C72900E6B4D89DCE@ireland.spinhead.com>

> Here is a question so simple, it embarasses me to ask. 

well, maybe it's a simple question, but it's a *major* turning point in
your web coding

> Would anyone please give me some pointers on how to get these 
> divs properly aligned?

if you can send a link to an online example, we can offer more advice
than you really want.

in addition, save yourself loads of grief and spend some time learning
about floating in CSS:

    http://css.maxdesign.com.au/floatutorial/

and maybe even get a copy of the glashaus CSS book.

put aside 'table' thinking, spend some time on theory, and you'll come
up to speed *much* faster than by trial and error (and error, and error,
and error . . .)

oh, and ask lots of questions here.

joel


From thdomo at gmail.com  Wed Oct 17 17:35:45 2007
From: thdomo at gmail.com (Thomas Moore)
Date: Wed, 17 Oct 2007 15:35:45 -0700
Subject: [thelist] html div
In-Reply-To: <11891806.1192659639626.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
References: <11891806.1192659639626.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net>
Message-ID: <ebb1e0920710171535r53370195yd34e83c531dc14d5@mail.gmail.com>

Laura,  are you using Dreamweaver CS3?





On 10/17/07, Lightening <oktellme at earthlink.net> wrote:
> Here is a question so simple, it embarasses me to ask.
>
> No matter -  it would embarass me more to continue to not know!
>
> I've been coding my html with tables for years, but tables are not the right tool for this application.
>
> So I am using DIV instead.
>
> Trouble I am having is the browser puts the various blocks of DIV where it wants to, and not where I want it to be.
>
> I am trying to have a header, a footer, each spanning the page, and a left, center and right column. I am using css, if that matters.
>
> Would anyone please give me some pointers on how to get these divs properly aligned?
>
> thanks , Laura
>
> ps, code available on request.
>
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From jthjothi at yahoo.com  Thu Oct 18 07:46:14 2007
From: jthjothi at yahoo.com (jothi jothi)
Date: Thu, 18 Oct 2007 05:46:14 -0700 (PDT)
Subject: [thelist] how to embed Jpgraph in FPDF
Message-ID: <911902.62056.qm@web53701.mail.re2.yahoo.com>

hello there,
   
  Thanks for those help me in posgresql...
   
  Now i have another problem where i used jograph to generate graphs...i am using FPDF to generate pdf files...when i try to embed the graph with FPDF ,the output was not in pdf file..below is my coding...where is the error?
   
  Anyone have come through this situation before?help me...
   
  <?php
require('mem_image.php');
include('fpdf.php');
  $db_name = "wsn";
$table_name = "suhu";
  $connection = @mysql_connect("localhost", "12090", "kamala")
or die(mysql_error());
  $db = @mysql_select_db($db_name, $connection) or die(mysql_error());
  $query = "SELECT Node_ID , AVG(voltage),AVG(Temper), AVG(light),AVG(accel_x), AVG(accel_y), AVG(mag_x), AVG(mag_y), AVG(mic),Date from suhu 
group by Node_ID"; 
  $result = mysql_query($query) or die(mysql_error());
  include ("c:/jpgraph-1.21b/src/jpgraph.php");    
include ("c:/jpgraph-1.21b/src/jpgraph_Line.php"); 
 
  
while($row = mysql_fetch_array($result)) 
{ 
$data[] = $row["AVG(light)"]; 
$leg[] = $row[0]; 
}
$graph = new Graph(250, 150,"auto");
  
//$graph = new Graph(600,600); 
$graph->SetScale("textint"); 
$graph->img->SetMargin(50,30,50,50);
  //$graph->SetBackgroundImage("Blue hills.jpg",BGIMG_FILLFRAME);
  $graph->SetShadow(); 
$graph->xaxis->SetTickLabels($leg); 
$lplot = new LinePlot($data); 
$lplot->SetFillColor("lightgreen"); // Fill color 
$lplot->value->Show(); 
$lplot->value->SetFont(FF_ARIAL,FS_BOLD); 
$lplot->value->SetAngle(45); 
$lplot->value->SetColor("black","navy"); 
$lplot->SetLegend("Light");
  $graph->title->Set("Light");
$graph->xaxis->title->Set("Nodes_ID");
$graph->yaxis->title->Set("Light");
  $graph->title->SetFont(FF_FONT1,FS_BOLD);
$graph->yaxis->title->SetFont(FF_FONT1,FS_BOLD);
$graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);
$graph->Add($lplot); 
$graph->Stroke(); 
  // Put the image in a PDF page
$im = $graph->Stroke(_IMG_HANDLER);
  $pdf = pdf_new();
pdf_open_file($pdf, '');
  // Convert the GD image to somehing the
// PDFlibrary knows how to handle
$pimg = pdf_open_memory_image($pdf, $im);
  pdf_begin_page($pdf, 595, 842);
pdf_add_outline($pdf, 'Page 1');
pdf_place_image($pdf, $pimg, 0, 500, 1);
pdf_close_image($pdf, $pimg);
pdf_end_page($pdf);
pdf_close($pdf);
  $buf = pdf_get_buffer($pdf);
$len = strlen($buf);
  // Send PDF mime headers
header('Content-type: application/pdf');
header("Content-Length: $len");
header("Content-Disposition: inline; filename=foo.pdf");
  // Send the content of the PDF file
echo $buf;
  // .. and clean up
pdf_delete($pdf);
  ?>

   
   
   
   
   
   
   

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

From sales at lycosa.co.uk  Thu Oct 18 04:23:46 2007
From: sales at lycosa.co.uk (Sales @ Lycosa)
Date: Thu, 18 Oct 2007 10:23:46 +0100
Subject: [thelist] Snapshot of Flash movie using PHP
Message-ID: <003601c81168$990016d0$0201a8c0@DEV>

Hi,

I am writing an image / video gallery system, with the videos in Flash
initially. I am looking for a way to upload a .swf file to a PHP script, and
have it take a snapshot image of the first frame of the movie. In this way,
the video thumbnail images can more accurately represent the video.

I know PHP has .swf capabilities, but I couldn't find anything that would do
this. Any help would be appreciated.

Phil Parker

 



From bobm at dottedi.biz  Thu Oct 18 11:26:45 2007
From: bobm at dottedi.biz (Bob Meetin)
Date: Thu, 18 Oct 2007 10:26:45 -0600
Subject: [thelist] ecommerce - certificate / authorize.net / payment
 module configuration
In-Reply-To: <47167A51.1060004@dottedi.biz>
References: <47167A51.1060004@dottedi.biz>
Message-ID: <47178945.2050807@dottedi.biz>

I'm still working with this, if anyone can advise.  Also looking through 
other forums for advice.

I just installed a vanilla install of osCommerce on my site.  It has a 
default module already installed for Authorize.net and when you go to 
install that Gateway the questions are much different than what I see 
when I go to add a payment module for Virtuemart.  Not sure whether this 
is because I don't understand the processes or it is not installed 
correctly yet.

In osCommerce payment gateway I see:

*Enable Authorize.net Module* Do you want to accept Authorize.net 
payments? -->  True/False
*Login Username* used for the Authorize.net service --> ______________
*Transaction Key* used for encrypting TP data  --> _________________
*Transaction Mode* used for processing orders  --> Test/Production
*Transaction Method* used for processing orders --> Credit Card or eCheck

On Virtuemart there are a number of fields to complete:
> * Payment Method Name:   Authorize.net (yes?)
> * Code: _____________ (what goes here?)
> * Payment class name :  ps_authorize (without the .php extension?)
> * Payment method type: Check credit card option?  (Other options include 
> Use Payment Processor)
> * Accepted Credit Card Types?  How do I know?
>   



From rahaman29 at gmail.com  Thu Oct 18 09:02:10 2007
From: rahaman29 at gmail.com (rahaman)
Date: Thu, 18 Oct 2007 17:02:10 +0300
Subject: [thelist] how to embed Jpgraph in FPDF
In-Reply-To: <911902.62056.qm@web53701.mail.re2.yahoo.com>
References: <911902.62056.qm@web53701.mail.re2.yahoo.com>
Message-ID: <304ad6a0710180702p17e1b013g9918a3a0ada9386@mail.gmail.com>

send me the following file to check

mem_image.php
fpdf.php

jpgraph.php
jpgraph_Line.php


On 10/18/07, jothi jothi <jthjothi at yahoo.com> wrote:
>
> hello there,
>
> Thanks for those help me in posgresql...
>
> Now i have another problem where i used jograph to generate graphs...i am
> using FPDF to generate pdf files...when i try to embed the graph with FPDF
> ,the output was not in pdf file..below is my coding...where is the error?
>
> Anyone have come through this situation before?help me...
>
> <?php
> require('mem_image.php');
> include('fpdf.php');
> $db_name = "wsn";
> $table_name = "suhu";
> $connection = @mysql_connect("localhost", "12090", "kamala")
> or die(mysql_error());
> $db = @mysql_select_db($db_name, $connection) or die(mysql_error());
> $query = "SELECT Node_ID , AVG(voltage),AVG(Temper),
> AVG(light),AVG(accel_x), AVG(accel_y), AVG(mag_x), AVG(mag_y), AVG(mic),Date
> from suhu
> group by Node_ID";
> $result = mysql_query($query) or die(mysql_error());
> include ("c:/jpgraph-1.21b/src/jpgraph.php");
> include ("c:/jpgraph-1.21b/src/jpgraph_Line.php");
>
>
> while($row = mysql_fetch_array($result))
> {
> $data[] = $row["AVG(light)"];
> $leg[] = $row[0];
> }
> $graph = new Graph(250, 150,"auto");
>
> //$graph = new Graph(600,600);
> $graph->SetScale("textint");
> $graph->img->SetMargin(50,30,50,50);
> //$graph->SetBackgroundImage("Blue hills.jpg",BGIMG_FILLFRAME);
> $graph->SetShadow();
> $graph->xaxis->SetTickLabels($leg);
> $lplot = new LinePlot($data);
> $lplot->SetFillColor("lightgreen"); // Fill color
> $lplot->value->Show();
> $lplot->value->SetFont(FF_ARIAL,FS_BOLD);
> $lplot->value->SetAngle(45);
> $lplot->value->SetColor("black","navy");
> $lplot->SetLegend("Light");
> $graph->title->Set("Light");
> $graph->xaxis->title->Set("Nodes_ID");
> $graph->yaxis->title->Set("Light");
> $graph->title->SetFont(FF_FONT1,FS_BOLD);
> $graph->yaxis->title->SetFont(FF_FONT1,FS_BOLD);
> $graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);
> $graph->Add($lplot);
> $graph->Stroke();
> // Put the image in a PDF page
> $im = $graph->Stroke(_IMG_HANDLER);
> $pdf = pdf_new();
> pdf_open_file($pdf, '');
> // Convert the GD image to somehing the
> // PDFlibrary knows how to handle
> $pimg = pdf_open_memory_image($pdf, $im);
> pdf_begin_page($pdf, 595, 842);
> pdf_add_outline($pdf, 'Page 1');
> pdf_place_image($pdf, $pimg, 0, 500, 1);
> pdf_close_image($pdf, $pimg);
> pdf_end_page($pdf);
> pdf_close($pdf);
> $buf = pdf_get_buffer($pdf);
> $len = strlen($buf);
> // Send PDF mime headers
> header('Content-type: application/pdf');
> header("Content-Length: $len");
> header("Content-Disposition: inline; filename=foo.pdf");
> // Send the content of the PDF file
> echo $buf;
> // .. and clean up
> pdf_delete($pdf);
> ?>
>
>
>
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From hassan.schroeder at gmail.com  Thu Oct 18 11:56:34 2007
From: hassan.schroeder at gmail.com (Hassan Schroeder)
Date: Thu, 18 Oct 2007 09:56:34 -0700
Subject: [thelist] ecommerce - certificate / authorize.net / payment
	module configuration
In-Reply-To: <47178945.2050807@dottedi.biz>
References: <47167A51.1060004@dottedi.biz> <47178945.2050807@dottedi.biz>
Message-ID: <4eedb92a0710180956t580879adnb1a780e0eb62bbca@mail.gmail.com>

On 10/18/07, Bob Meetin <bobm at dottedi.biz> wrote:

> In osCommerce payment gateway I see:
>
> *Enable Authorize.net Module* Do you want to accept Authorize.net
> payments? -->  True/False
> *Login Username* used for the Authorize.net service --> ______________
> *Transaction Key* used for encrypting TP data  --> _________________
> *Transaction Mode* used for processing orders  --> Test/Production
> *Transaction Method* used for processing orders --> Credit Card or eCheck

I don't know anything about either of the two carts you're talking
about, but I do use Authorize.Net and those fields look appropriate.

I'm guessing you don't have the Authorize.net Implementation Guide;
download it before you do anything else. It's really well written, and
will make all this easier to understand, even if you're not writing your
own cart/cc interface.

FWIW,
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com


From indotekken at yahoo.com  Thu Oct 18 04:26:15 2007
From: indotekken at yahoo.com (XtiaN)
Date: Thu, 18 Oct 2007 02:26:15 -0700 (PDT)
Subject: [thelist] SQL Union and order by problem
In-Reply-To: <4eedb92a0710170727w31acbd1m30cdbd0e3ea56288@mail.gmail.com>
Message-ID: <546229.21203.qm@web56406.mail.re3.yahoo.com>

Hi,
can anyone help me ?

I've made some sql query like this (SQL Server 2000):

select * From (
SELECT top 100 PERCENT a,b,c    
FROM tb
WHERE DATEDIFF(day, b ,getdate())>=3 
order by b desc) asd 
union all
select * From (
SELECT top 100 PERCENT a,b,c    
FROM tb
WHERE DATEDIFF(day, b ,getdate())<3 
order by b asc) def


explanation:
i want to make query from union of 2 subqueries.
subquery 1 : simple query with order by b desc
subquery 2 : simple query with order by b asc
btw, a =  primary key (index)

But the result is not like i'd expected.. 
well, the result make all datetime data in column b order by asc... (not by desc first for subquery1, and followed by asc from subquery2)


ps: i added 'top 100 percent' because if i don't this message error will come ->
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.

thanks in advance

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

From darrellgking at gmail.com  Thu Oct 18 08:00:52 2007
From: darrellgking at gmail.com (Darrell King)
Date: Thu, 18 Oct 2007 09:00:52 -0400
Subject: [thelist] html div
In-Reply-To: <4a152002268227a115c0b1d9e5664c76@baratta.com>
References: <4a152002268227a115c0b1d9e5664c76@baratta.com>
Message-ID: <1f2cbbe70710180600j5d001d7cmbbdd5a0a2be9a10a@mail.gmail.com>

Don't hurt yourself trying to make layouts that exactly mimic table
layouts! There are issues involved with getting that footer to span
the page like the bottom row of a table. CSS didn't take that into
account when it was coded, so you could get a headache is you try to
conform to a variable-height layout of that type. Branch out from your
old habits and explore the new possibilities of CSS, such as
overlapping divs and the potential of positioning.

I wrote the above because I had my own headaches trying to make CSS
imitate table layouts. It was simply the wrong mindset to cling to.
Next is a more helpful response, a link to some layout examples:

http://www.glish.com/css/

Thanx,

D
> -----Original message-----
> From: Lightening oktellme at earthlink.net
>
> > Here is a question so simple, it embarasses me to ask.
> >
> > No matter -  it would embarass me more to continue to not know!
> >
> > I've been coding my html with tables for years, but tables are not the right tool for this application.
> >
> > So I am using DIV instead.
> >
> > Trouble I am having is the browser puts the various blocks of DIV where it wants to, and not where I want it to be.
> >
> > I am trying to have a header, a footer, each spanning the page, and a left, center and right column. I am using css, if that matters.
> >
> > Would anyone please give me some pointers on how to get these divs properly aligned?
> >
> > thanks , Laura
> >
> > ps, code available on request.
> >
> >


From jthjothi at yahoo.com  Thu Oct 18 06:30:14 2007
From: jthjothi at yahoo.com (jothi jothi)
Date: Thu, 18 Oct 2007 04:30:14 -0700 (PDT)
Subject: [thelist] Your PHP installation does not support PostgreSQL.
	You need to recompile PHP using the --with-pgsql configure option.
In-Reply-To: <47163879.5020104@gmail.com>
Message-ID: <468472.20720.qm@web53703.mail.re2.yahoo.com>

Thank you ...IT works:-)

Brady Mitchell <mydarb at gmail.com> wrote:  You need to enable the postgres extension for PHP. Open php.ini and find 
the line ";extension=php_pgsql.dll" and remove the ; from the beginning. 
Once you do that and restart apache you should be able to use the 
postgres functions from php.

If you're not familiar with phpinfo(), take a look at it. Create a php 
file and call the phpinfo function and browse to it. This function gives 
you all kinds of information about PHP including which extensions are 
enabled, where php.ini is located, and more.

I don't know what you're asking in questions 3 and 4 - are you asking 
how to install postgres? Go to http://www.postgresql.org/download/ and 
follow the links there - that page also lists some graphical clients.

Brady

jothi jothi wrote:
> i am a student doing a project in using php and xampp server..now i have t use posgresql..i had installed the posgresql ready...but when i got below errors as i comile one of the coding...
> 
> 
> Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
> 
> Fatal error: Call to undefined function: pg_connect() in C:\Program Files\xampp\htdocs\posgre.php on line 54
> 
> 
> 1.can some one explain to me ,how n recompile the php?
> 2.Why the pg_connect function is undefined?
> 3.How i know that i have installed the posgresql correctly?
> 4.How i can run the server?
> 
> 
> below is my coding....
> 
> 
>   
>     
>   
> ID
> 
>   
> voltage
> 
>   
> temp
> 
>   
> light 
> 
>   
> accel_x
> 
> 
>   
> accel_y
> 
> 
>   
> mag_x
> 
> 
>   
> mag_y
> 
> 
>   
> mic
> 
> 
> 
>   
> Time
> 
> 
> 
> > $conn = pg_connect("host=localhost 
> port=5432 
> dbname=task 
> user=tele
> password=tiny");
> 
> $query = "SELECT * FROM sample_mts310"; 
> $result = pg_query($query); 
> if (!$result) { 
> echo "Problem with query " . $query . "
"; 
> echo pg_last_error(); 
> exit(); 
> } 
> while($myrow = pg_fetch_assoc($result)) { 
> printf ("    %s  %s  %s  %s", $myrow['Id'], $myrow['voltage'], $myrow['temp'], $myrow['light'],$myrow['accel_x'],$myrow['accel_y'],$myrow['mag_x'],$myrow['mag_y'],$myrow['mic'],$myrow['time']); 
> } 
> ?> 
> 
> 
> 
> 
> 
> 
> your help is very much appreciated...
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 

-- 

* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

From nan at nanharbison.com  Thu Oct 18 12:54:51 2007
From: nan at nanharbison.com (Nan Harbison)
Date: Thu, 18 Oct 2007 13:54:51 -0400
Subject: [thelist] ecommerce - certificate / authorize.net / payment
	module configuration
In-Reply-To: <47178945.2050807@dottedi.biz>
Message-ID: <20071018175454.83A1CB6029C@smtp6.34sp.com>

Bob,

I was JUST investigating authorize.net yesterday for a client's website.
They have lots of information on their website for developers, including
downloadable sample code, and a test environment.

Start here:
http://developer.authorize.net/
 
They also offer the option of getting your own SSL certificate or using
theirs.

HTH
Nan


-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Bob Meetin
Sent: Thursday, October 18, 2007 12:27 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] ecommerce - certificate / authorize.net / payment
module configuration

I'm still working with this, if anyone can advise.  Also looking through
other forums for advice.

I just installed a vanilla install of osCommerce on my site.  It has a
default module already installed for Authorize.net and when you go to
install that Gateway the questions are much different than what I see when I
go to add a payment module for Virtuemart.  Not sure whether this is because
I don't understand the processes or it is not installed correctly yet.

In osCommerce payment gateway I see:

*Enable Authorize.net Module* Do you want to accept Authorize.net payments?
-->  True/False *Login Username* used for the Authorize.net service -->
______________ *Transaction Key* used for encrypting TP data  -->
_________________ *Transaction Mode* used for processing orders  -->
Test/Production *Transaction Method* used for processing orders --> Credit
Card or eCheck

On Virtuemart there are a number of fields to complete:
> * Payment Method Name:   Authorize.net (yes?)
> * Code: _____________ (what goes here?)
> * Payment class name :  ps_authorize (without the .php extension?)
> * Payment method type: Check credit card option?  (Other options 
> include Use Payment Processor)
> * Accepted Credit Card Types?  How do I know?
>   

-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester and archives
of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! 



From joel at streamliine.com  Thu Oct 18 13:21:39 2007
From: joel at streamliine.com (Joel D Canfield)
Date: Thu, 18 Oct 2007 11:21:39 -0700
Subject: [thelist] SQL Union and order by problem
References: <546229.21203.qm@web56406.mail.re3.yahoo.com>
Message-ID: <72E9FAA171D63B48AAC707C72900E6B4D89DDC@ireland.spinhead.com>

> i want to make query from union of 2 subqueries.
> subquery 1 : simple query with order by b desc
> subquery 2 : simple query with order by b asc

>From SQL BOL: "When UNION is used, the individual SELECT statements
cannot have their own ORDER BY or COMPUTE clauses. There can be only one
ORDER BY or COMPUTE clause after the last SELECT statement; it is
applied to the final, combined result set."

Perhaps if you explain why you want the same data sorted two different
ways in the same result set, we could offer alternatives.

joel


From rudy at r937.com  Thu Oct 18 13:24:06 2007
From: rudy at r937.com (r937)
Date: Thu, 18 Oct 2007 14:24:06 -0400
Subject: [thelist]  SQL Union and order by problem
Message-ID: <03ee01c811b4$2096ac30$9a7ba8c0@curly>

> i want to make query from union of 2 subqueries.
> subquery 1 : simple query with order by b desc
> subquery 2 : simple query with order by b asc

sorry, you cannot put ORDER BY into the subqueries to achieve this result

a UNION query should have only one ORDER BY, at the end, to sort the entire 
combined results from all SELECTs in the UNION

that said, you could have a column with the value -b in the first SELECT, 
which can then combine with the column b values from the second SELECT, so 
that the overall ORDER BY would be ASC

rudy
http://r937.com/ 




From rudy at r937.com  Thu Oct 18 13:30:20 2007
From: rudy at r937.com (r937)
Date: Thu, 18 Oct 2007 14:30:20 -0400
Subject: [thelist]   SQL Union and order by problem
Message-ID: <03f701c811b4$f25e7040$9a7ba8c0@curly>

>  you could have a column with the value -b in the first SELECT...

uh, wait a sec...   b appears to be a date

i would suggest you take another look, or explain what you're doing, because 
right now i don't think you need a UNION at all

;o)




From talleman at Lumpsum.com  Thu Oct 18 14:15:45 2007
From: talleman at Lumpsum.com (Tab Alleman)
Date: Thu, 18 Oct 2007 15:15:45 -0400
Subject: [thelist] SQL Union and order by problem
In-Reply-To: <03f701c811b4$f25e7040$9a7ba8c0@curly>
Message-ID: <E9912B60C8CE8A4BA7F2AFFBEFFCECFFF8E353@moose.settlementfunding.local>

But pursuing Rudy's idea, you could make an ordering column that uses the DATEDIFF and its inverse.  But he's probably right; whatever you're trying to do might better be done without a UNION at all.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of r937
> Sent: Thursday, October 18, 2007 2:30 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] SQL Union and order by problem
> 
> 
> >  you could have a column with the value -b in the first SELECT...
> 
> uh, wait a sec...   b appears to be a date
> 
> i would suggest you take another look, or explain what you're 
> doing, because 
> right now i don't think you need a UNION at all
> 
> ;o)
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 


From Ron.Luther at hp.com  Thu Oct 18 14:21:35 2007
From: Ron.Luther at hp.com (Luther, Ron)
Date: Thu, 18 Oct 2007 19:21:35 -0000
Subject: [thelist] SQL Union and order by problem
In-Reply-To: <546229.21203.qm@web56406.mail.re3.yahoo.com>
References: <4eedb92a0710170727w31acbd1m30cdbd0e3ea56288@mail.gmail.com>
	<546229.21203.qm@web56406.mail.re3.yahoo.com>
Message-ID: <97D1949F5E36434E8DC375C1608538BF02491FE9@G3W0634.americas.hpqcorp.net>

XtiaN asked:


>>can anyone help me ?

>>select * From (
>>SELECT top 100 PERCENT a,b,c    
>>FROM tb
>>WHERE DATEDIFF(day, b ,getdate())>=3
>>order by b desc) asd
>>union all
>>select * From (
>>SELECT top 100 PERCENT a,b,c    
>>FROM tb
>>WHERE DATEDIFF(day, b ,getdate())<3
>>order by b asc) def


Hi XtiaN,


I think we have some folks who can help.

However, we might want to crosscheck and make sure we understand what
you want.

Do you really want a list of "Records that are more than 3 days old
descending by datetime stamp" added to a list of "Records that are less
than 3 days old ascending by datetime stamp"?

So if we run this query at 2pm on 18-Oct-2007 we _want_ to see something
like this???:

(Record 1) 15-Oct-2007 2pm
(Record 2) 14-Oct-2006 1pm
(Record 3) 11-Oct-2005 6pm
(...)
(Record n) 15-Oct-2007 3pm
(Record n+1) 15-Oct-2007 7pm
(Record n+2) 16-Oct-2007 4am

It just seems like a really odd thing to ask for.

I think if we better understand what you want the result to look like,
we can help get there.


Thanks,
RonL.


From cdorer at gmail.com  Thu Oct 18 15:55:06 2007
From: cdorer at gmail.com (Chris Dorer)
Date: Thu, 18 Oct 2007 16:55:06 -0400
Subject: [thelist] Apache 1.3 Character Encoding
Message-ID: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>

List,

I'm curious, for apache 1.3, would any of you know what character encoding
apache uses to write into it's logs?

Chris

-- 
You always have the option of pitching baseballs at empty spray paint cans
in a cul-de-sac in a Cleveland suburb.


From cdorer at gmail.com  Thu Oct 18 16:05:20 2007
From: cdorer at gmail.com (Chris Dorer)
Date: Thu, 18 Oct 2007 17:05:20 -0400
Subject: [thelist] Apache 1.3 Character Encoding
In-Reply-To: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
References: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
Message-ID: <8ac626620710181405l2f65f334t70e99c07122639ff@mail.gmail.com>

I'm pretty sure it's latin_1, not really utf-8.  I'm just trying to figure
out how and what it is

On 10/18/07, Chris Dorer <cdorer at gmail.com> wrote:
>
> List,
>
> I'm curious, for apache 1.3, would any of you know what character encoding
> apache uses to write into it's logs?
>
> Chris
>
> --
> You always have the option of pitching baseballs at empty spray paint cans
> in a cul-de-sac in a Cleveland suburb.




-- 
You always have the option of pitching baseballs at empty spray paint cans
in a cul-de-sac in a Cleveland suburb.


From Paul.Bennett at wcc.govt.nz  Thu Oct 18 17:11:29 2007
From: Paul.Bennett at wcc.govt.nz (Paul Bennett)
Date: Fri, 19 Oct 2007 11:11:29 +1300
Subject: [thelist] Subversion locking
Message-ID: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>

Hi all,

We've got an SVN repository and work with a local copy of our site. All has been going fine until a couple, of days ago for my colleague.

>From what I can tell, she has an old lock file on her client setup which is preventing her checking in / updating form one particular directory.

I can check in and update the dir, so we know the repository is ok, but I'm guessing something failed (network outage or the like) during one of her commits, leaving the client thinking that the dir was still locked.

Is there a way we can remove the lock file? Cleaning up the entire repository copy fails when it hits the dir that is supposedly 'locked'.

Release locks also fails.

Has anyone struck this before? Any workarounds? I'm checking the documentation and faq's but with little luck yet.

Thanks in advance for any help / pointers,
Paul


From rjmolesa at consoltec.net  Thu Oct 18 17:27:30 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Thu, 18 Oct 2007 18:27:30 -0400
Subject: [thelist] Subversion locking
In-Reply-To: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>
References: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>
Message-ID: <20071018222730.GD2441@jenna.rjmolesa.homelinux.net>

Have her to try to do a checkout to a new directory.

*On Fri, Oct 19, 2007 at 11:11:29AM +1300 Paul Bennett <Paul.Bennett at wcc.govt.nz> wrote:

> Date: Fri, 19 Oct 2007 11:11:29 +1300
> From: "Paul Bennett" <Paul.Bennett at wcc.govt.nz>
> To: <thelist at lists.evolt.org>
> Subject: [thelist] Subversion locking
> 
> Hi all,
> 
> We've got an SVN repository and work with a local copy of our site. All has been going fine until a couple, of days ago for my colleague.
> 
> >From what I can tell, she has an old lock file on her client setup which is preventing her checking in / updating form one particular directory.
> 
> I can check in and update the dir, so we know the repository is ok, but I'm guessing something failed (network outage or the like) during one of her commits, leaving the client thinking that the dir was still locked.
> 
> Is there a way we can remove the lock file? Cleaning up the entire repository copy fails when it hits the dir that is supposedly 'locked'.
> 
> Release locks also fails.
> 
> Has anyone struck this before? Any workarounds? I'm checking the documentation and faq's but with little luck yet.
> 
> Thanks in advance for any help / pointers,
> Paul
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

-- 
Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious
http://rjmolesa.com


From Paul.Bennett at wcc.govt.nz  Thu Oct 18 17:29:51 2007
From: Paul.Bennett at wcc.govt.nz (Paul Bennett)
Date: Fri, 19 Oct 2007 11:29:51 +1300
Subject: [thelist] Subversion locking
In-Reply-To: <20071018222730.GD2441@jenna.rjmolesa.homelinux.net>
References: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>
	<20071018222730.GD2441@jenna.rjmolesa.homelinux.net>
Message-ID: <F6284A42697D094DBAA8E7BF1594775F0D80035A@exchmb1.net.ad.wcc.govt.nz>

Hi John,

You mean check out the problem folder to a new dir and then copy the results into the existing client copy, or check back in from the new dir (to see if that clears the error)? 

Paul

-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Jon Molesa
Sent: Friday, October 19, 2007 11:28 AM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Subversion locking

Have her to try to do a checkout to a new directory.

*On Fri, Oct 19, 2007 at 11:11:29AM +1300 Paul Bennett <Paul.Bennett at wcc.govt.nz> wrote:

> Date: Fri, 19 Oct 2007 11:11:29 +1300
> From: "Paul Bennett" <Paul.Bennett at wcc.govt.nz>
> To: <thelist at lists.evolt.org>
> Subject: [thelist] Subversion locking
> 
> Hi all,
> 
> We've got an SVN repository and work with a local copy of our site. All has been going fine until a couple, of days ago for my colleague.
> 
> >From what I can tell, she has an old lock file on her client setup which is preventing her checking in / updating form one particular directory.
> 
> I can check in and update the dir, so we know the repository is ok, but I'm guessing something failed (network outage or the like) during one of her commits, leaving the client thinking that the dir was still locked.
> 
> Is there a way we can remove the lock file? Cleaning up the entire repository copy fails when it hits the dir that is supposedly 'locked'.
> 
> Release locks also fails.
> 
> Has anyone struck this before? Any workarounds? I'm checking the documentation and faq's but with little luck yet.
> 
> Thanks in advance for any help / pointers,
> Paul
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

-- 
Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious
http://rjmolesa.com
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 


From bobm at dottedi.biz  Thu Oct 18 17:58:53 2007
From: bobm at dottedi.biz (Bob Meetin)
Date: Thu, 18 Oct 2007 16:58:53 -0600
Subject: [thelist] ecommerce - certificate / authorize.net / payment
 module configuration - solved
In-Reply-To: <47178945.2050807@dottedi.biz>
References: <47167A51.1060004@dottedi.biz> <47178945.2050807@dottedi.biz>
Message-ID: <4717E52D.2000407@dottedi.biz>

Read comments below...
>
> I just installed a vanilla install of osCommerce on my site.  It has a 
> default module already installed for Authorize.net and when you go to 
> install that Gateway the questions are much different than what I see 
> when I go to add a payment module for Virtuemart.  Not sure whether this 
> is because I don't understand the processes or it is not installed 
> correctly yet.
>
> In osCommerce payment gateway I see:
>
> *Enable Authorize.net Module* Do you want to accept Authorize.net 
> payments? -->  True/False
> *Login Username* used for the Authorize.net service --> ______________
> *Transaction Key* used for encrypting TP data  --> _________________
> *Transaction Mode* used for processing orders  --> Test/Production
> *Transaction Method* used for processing orders --> Credit Card or eCheck
>
>   
Mostly there, now just some testing.  This was way too simple...For the 
record, in osCommerce and perhaps  zen-cart, you have to select:

        Modules --> Payment --> Authorize.net --> then select to edit 
the gateway

With Virtuemart, it's a different route which is unexpected if you've 
had your expectations set...  Select:

       List Payment Methods --> then select to edit the credit card 
method  --> *General tab*
  
The vanilla installation has it already linked to the authorize.net 
class, ps_authorize.  You can check off the card types to process then 
select the *Configuration* tab.  Here is where you enter the 
authorize.net login, password, etc.

Harumph... not a technical problem - a virtuemart newbie issue!

-Bob




From rjmolesa at consoltec.net  Thu Oct 18 18:37:18 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Thu, 18 Oct 2007 19:37:18 -0400
Subject: [thelist] Subversion locking
In-Reply-To: <F6284A42697D094DBAA8E7BF1594775F0D80035A@exchmb1.net.ad.wcc.govt.nz>
References: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>
	<20071018222730.GD2441@jenna.rjmolesa.homelinux.net>
	<F6284A42697D094DBAA8E7BF1594775F0D80035A@exchmb1.net.ad.wcc.govt.nz>
Message-ID: <20071018233718.GE2441@jenna.rjmolesa.homelinux.net>

Well, I was starting more simply.  Just check out a copy to a new folder
first.  If the files there are editable then you 'should' be able to
copy the modified one from the hosed dir over that one.  Then update,
blow the old dir away, after making a local backup.

*On Fri, Oct 19, 2007 at 11:29:51AM +1300 Paul Bennett <Paul.Bennett at wcc.govt.nz> wrote:

> Date: Fri, 19 Oct 2007 11:29:51 +1300
> From: "Paul Bennett" <Paul.Bennett at wcc.govt.nz>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] Subversion locking
> 
> Hi John,
> 
> You mean check out the problem folder to a new dir and then copy the results into the existing client copy, or check back in from the new dir (to see if that clears the error)? 
> 
> Paul
> 
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Jon Molesa
> Sent: Friday, October 19, 2007 11:28 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] Subversion locking
> 
> Have her to try to do a checkout to a new directory.
> 
> *On Fri, Oct 19, 2007 at 11:11:29AM +1300 Paul Bennett <Paul.Bennett at wcc.govt.nz> wrote:
> 
> > Date: Fri, 19 Oct 2007 11:11:29 +1300
> > From: "Paul Bennett" <Paul.Bennett at wcc.govt.nz>
> > To: <thelist at lists.evolt.org>
> > Subject: [thelist] Subversion locking
> > 
> > Hi all,
> > 
> > We've got an SVN repository and work with a local copy of our site. All has been going fine until a couple, of days ago for my colleague.
> > 
> > >From what I can tell, she has an old lock file on her client setup which is preventing her checking in / updating form one particular directory.
> > 
> > I can check in and update the dir, so we know the repository is ok, but I'm guessing something failed (network outage or the like) during one of her commits, leaving the client thinking that the dir was still locked.
> > 
> > Is there a way we can remove the lock file? Cleaning up the entire repository copy fails when it hits the dir that is supposedly 'locked'.
> > 
> > Release locks also fails.
> > 
> > Has anyone struck this before? Any workarounds? I'm checking the documentation and faq's but with little luck yet.
> > 
> > Thanks in advance for any help / pointers,
> > Paul
> > -- 
> > 
> > * * Please support the community that supports you.  * *
> > http://evolt.org/help_support_evolt/
> > 
> > For unsubscribe and other options, including the Tip Harvester 
> > and archives of thelist go to: http://lists.evolt.org 
> > Workers of the Web, evolt ! 
> 
> -- 
> Jon Molesa
> rjmolesa at consoltec.net
> if you're bored or curious
> http://rjmolesa.com
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

-- 
Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious
http://rjmolesa.com


From oktellme at earthlink.net  Thu Oct 18 20:39:38 2007
From: oktellme at earthlink.net (Lightning)
Date: Thu, 18 Oct 2007 21:39:38 -0400
Subject: [thelist] html div ok now- next barrier is css
References: <4a152002268227a115c0b1d9e5664c76@baratta.com>
	<1f2cbbe70710180600j5d001d7cmbbdd5a0a2be9a10a@mail.gmail.com>
Message-ID: <005201c811f0$ee6ec840$0201a8c0@D9BV2G11>

Thanks to all you who relied about DIV, my html is now working properly.

Next question is about css:

Is there any way to get text into css? 

For instance, I've got a nice bar down the side of my page for navigation. 
These items should be the same on every page. 

Any way I can type those items on one age only?

thanks
Laura


From david at dorward.me.uk  Thu Oct 18 20:49:30 2007
From: david at dorward.me.uk (David Dorward)
Date: Fri, 19 Oct 2007 02:49:30 +0100
Subject: [thelist] html div ok now- next barrier is css
In-Reply-To: <005201c811f0$ee6ec840$0201a8c0@D9BV2G11>
References: <4a152002268227a115c0b1d9e5664c76@baratta.com>
	<1f2cbbe70710180600j5d001d7cmbbdd5a0a2be9a10a@mail.gmail.com>
	<005201c811f0$ee6ec840$0201a8c0@D9BV2G11>
Message-ID: <A68FB52A-8592-4EDB-A0B7-512648DEC012@dorward.me.uk>


On 19 Oct 2007, at 02:39, Lightning wrote:
> Next question is about css:
> Is there any way to get text into css?

CSS is for presentation, not content.

> For instance, I've got a nice bar down the side of my page for  
> navigation.
> These items should be the same on every page.

http://allmyfaqs.net/faq.pl?Include_one_file_in_another

-- 
David Dorward
http://dorward.me.uk/
http://blog.dorward.me.uk/




From indotekken at yahoo.com  Thu Oct 18 21:28:25 2007
From: indotekken at yahoo.com (XtiaN)
Date: Thu, 18 Oct 2007 19:28:25 -0700 (PDT)
Subject: [thelist] SQL Union and order by problem
In-Reply-To: <E9912B60C8CE8A4BA7F2AFFBEFFCECFFF8E353@moose.settlementfunding.local>
Message-ID: <165825.30611.qm@web56408.mail.re3.yahoo.com>

Actually, i'm using union because i've asked to make web page to view all of our member pictures. We want to display picture in our first page who already being 
registered 3 days ago (subquery asd). And the new member who registered in newest 3 days will be put in last pages.

ex: i have 1000 members registered. 1 page will contain 10 members, so i would have 100 pages. Our member who has registered 3 days before today (<= oct 17th) are 700 members.
Today is Oct 19th. in my first page until page-70, i will list my members pic who already registered 3 days ago (<= oct 17th) and our member who has registered from oct > Oct 17th will be displayed on latest pages


select * From (
SELECT top 100 PERCENT a,b,c    
FROM tb
WHERE DATEDIFF(day, b ,getdate())>=3 
order by b desc) asd 
union all
select * From (
SELECT top 100 PERCENT a,b,c    
FROM tb
WHERE DATEDIFF(day, b ,getdate())<3 
order by b asc) def

Thanks in advance

Tab Alleman <talleman at Lumpsum.com> wrote: But pursuing Rudy's idea, you could make an ordering column that uses the DATEDIFF and its inverse.  But he's probably right; whatever you're trying to do might better be done without a UNION at all.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of r937
> Sent: Thursday, October 18, 2007 2:30 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] SQL Union and order by problem
> 
> 
> >  you could have a column with the value -b in the first SELECT...
> 
> uh, wait a sec...   b appears to be a date
> 
> i would suggest you take another look, or explain what you're 
> doing, because 
> right now i don't think you need a UNION at all
> 
> ;o)
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

From rudy at r937.com  Thu Oct 18 21:46:01 2007
From: rudy at r937.com (r937)
Date: Thu, 18 Oct 2007 22:46:01 -0400
Subject: [thelist]  SQL Union and order by problem
Message-ID: <05ac01c811fa$326b7b20$9a7ba8c0@curly>

okay, i think i understand (maybe)

try this query --


     SELECT a,b,c    
          , case when DATEDIFF(day, b ,getdate()) >= 3
                 then 0
                 else 1 
             end          as which_group
     order 
         by which group asc
          , DATEDIFF(day, b ,getdate()) 

rudy
http://r937.com/



From indotekken at yahoo.com  Thu Oct 18 22:14:31 2007
From: indotekken at yahoo.com (XtiaN)
Date: Thu, 18 Oct 2007 20:14:31 -0700 (PDT)
Subject: [thelist] SQL Union and order by problem
In-Reply-To: <05ac01c811fa$326b7b20$9a7ba8c0@curly>
Message-ID: <455409.62963.qm@web56402.mail.re3.yahoo.com>

Nice... It works!!!


thanks rudy ^^

r937 <rudy at r937.com> wrote: okay, i think i understand (maybe)

try this query --


     SELECT a,b,c    
          , case when DATEDIFF(day, b ,getdate()) >= 3
                 then 0
                 else 1 
             end          as which_group
     order 
         by which group asc
          , DATEDIFF(day, b ,getdate()) 

rudy
http://r937.com/

-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 


 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

From steven.pierce at gmail.com  Fri Oct 19 00:22:08 2007
From: steven.pierce at gmail.com (Steven Pierce)
Date: Thu, 18 Oct 2007 22:22:08 -0700
Subject: [thelist] Apache 1.3 Character Encoding
In-Reply-To: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
References: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
Message-ID: <6e0cf1cc0710182222x72615d21r3ed1537e096a9c75@mail.gmail.com>

http://www.w3.org/International/O-HTTP-charset

Try this link, it might give you what you are looking for.
Also ApacheCon is in Ga Nov 12 - 16th.

On 10/18/07, Chris Dorer <cdorer at gmail.com> wrote:
>
> List,
>
> I'm curious, for apache 1.3, would any of you know what character encoding
> apache uses to write into it's logs?
>
> Chris
>
> --
> You always have the option of pitching baseballs at empty spray paint cans
> in a cul-de-sac in a Cleveland suburb.
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


From froyse at dimensionxcorp.com  Fri Oct 19 09:23:19 2007
From: froyse at dimensionxcorp.com (Forest Royse)
Date: Fri, 19 Oct 2007 10:23:19 -0400
Subject: [thelist] html div
Message-ID: <001201c8125b$9a839e20$6600a8c0@DimensionX.local>

"I am trying to have a header, a footer, each spanning the page, and a left,
center and right column. I am using css, if that matters."

 

You may find this page useful for what you're after:
http://css-discuss.incutio.com/?page=ThreeColumnLayouts  It links to many
other pages on 3-column CSS layouts.

 

Forest



From cdorer at gmail.com  Fri Oct 19 08:47:55 2007
From: cdorer at gmail.com (Chris Dorer)
Date: Fri, 19 Oct 2007 09:47:55 -0400
Subject: [thelist] Apache 1.3 Character Encoding
In-Reply-To: <6e0cf1cc0710182222x72615d21r3ed1537e096a9c75@mail.gmail.com>
References: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
	<6e0cf1cc0710182222x72615d21r3ed1537e096a9c75@mail.gmail.com>
Message-ID: <8ac626620710190647h1f781b3ewd70d469f4d01665a@mail.gmail.com>

It's a start.  I'll look down that avenue, it's more than I had found on
google for myself.

Thank you much Steven!

On 10/19/07, Steven Pierce <steven.pierce at gmail.com> wrote:
>
> http://www.w3.org/International/O-HTTP-charset
>
> Try this link, it might give you what you are looking for.
> Also ApacheCon is in Ga Nov 12 - 16th.
>
> On 10/18/07, Chris Dorer <cdorer at gmail.com> wrote:
> >
> > List,
> >
> > I'm curious, for apache 1.3, would any of you know what character
> encoding
> > apache uses to write into it's logs?
> >
> > Chris
> >
> > --
> > You always have the option of pitching baseballs at empty spray paint
> cans
> > in a cul-de-sac in a Cleveland suburb.
> > --
> >
> > * * Please support the community that supports you.  * *
> > http://evolt.org/help_support_evolt/
> >
> > For unsubscribe and other options, including the Tip Harvester
> > and archives of thelist go to: http://lists.evolt.org
> > Workers of the Web, evolt !
> >
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



-- 
You always have the option of pitching baseballs at empty spray paint cans
in a cul-de-sac in a Cleveland suburb.


From hassan.schroeder at gmail.com  Fri Oct 19 09:51:48 2007
From: hassan.schroeder at gmail.com (Hassan Schroeder)
Date: Fri, 19 Oct 2007 07:51:48 -0700
Subject: [thelist] Apache 1.3 Character Encoding
In-Reply-To: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
References: <8ac626620710181355v350648b1i94f61d18e007be9@mail.gmail.com>
Message-ID: <4eedb92a0710190751l4f3106f0k2eab79852cdfc98f@mail.gmail.com>

On 10/18/07, Chris Dorer <cdorer at gmail.com> wrote:

> I'm curious, for apache 1.3, would any of you know what character encoding
> apache uses to write into it's logs?

Why don't you just look? :-)  If nothing else, open a log file with FF and
see what PageInfo has to say about it (which, on my SuSE 10 desktop
with Apache httpd 2.2.6, was UTF-8).

FWIW,
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com


From nancychristine49 at yahoo.com  Fri Oct 19 10:16:13 2007
From: nancychristine49 at yahoo.com (Nancy Johnson)
Date: Fri, 19 Oct 2007 08:16:13 -0700 (PDT)
Subject: [thelist] html div
Message-ID: <936306.70752.qm@web45101.mail.sp1.yahoo.com>

if you have php or asp enabled use Server Side Includes (SS)) 

If not a simple javascript doc.write will do the trick. 

Nancy

_______________________________________________
Help: http://lists.evolt.org/mailman/listinfo/thelist

Archives: http://lists.evolt.org

End of thelist Digest, Vol 56, Issue 19
***************************************




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



From hassan.schroeder at gmail.com  Fri Oct 19 11:34:08 2007
From: hassan.schroeder at gmail.com (Hassan Schroeder)
Date: Fri, 19 Oct 2007 09:34:08 -0700
Subject: [thelist] html div
In-Reply-To: <936306.70752.qm@web45101.mail.sp1.yahoo.com>
References: <936306.70752.qm@web45101.mail.sp1.yahoo.com>
Message-ID: <4eedb92a0710190934s115278a7y36f420ff7b6bc0a5@mail.gmail.com>

On 10/19/07, Nancy Johnson <nancychristine49 at yahoo.com> wrote:
> if you have php or asp enabled use Server Side Includes (SS))

Every Web-oriented scripting language has some kind of include
function; that said, SSI is part of the Apache httpd and doesn't use
or require any external language.

> If not a simple javascript doc.write will do the trick.

? And will also prevent your pages from being accessible to search
engines or users without JavaScript -- not recommended!

FWIW,
-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com


From steveax at pobox.com  Fri Oct 19 14:13:46 2007
From: steveax at pobox.com (Steve Axthelm)
Date: Fri, 19 Oct 2007 12:13:46 -0700
Subject: [thelist] Subversion locking
In-Reply-To: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>
Message-ID: <r221-1049-i386-5D0EB2DAFB5E4CF5803CBF3E113529A1@MBP.local>

On 2007-10-18 Paul Bennett wrote:

> We've got an SVN repository and work with a local copy of our site.
> All has been going fine until a couple, of days ago for my colleague.
> 
> > From what I can tell, she has an old lock file on her client setup
> > which is preventing her checking in / updating form one particular
> > directory.
> 
> I can check in and update the dir, so we know the repository is ok,
> but I'm guessing something failed (network outage or the like) during
> one of her commits, leaving the client thinking that the dir was still
> locked.

You've tried 'cleanup' on the working copy?

svn cleanup --help
cleanup: Recursively clean up the working copy, removing locks, resuming
unfinished operations, etc.
usage: cleanup [PATH...]

Valid options:
  --diff3-cmd arg          : use ARG as merge command
  --config-dir arg         : read user configuration files from directory ARG

HTH,


-Steve

-- 
Steve Axthelm
steveax at pobox.com



From Groups at beachcomp.com  Fri Oct 19 17:45:22 2007
From: Groups at beachcomp.com (Groups at beachcomp.com)
Date: Fri, 19 Oct 2007 18:45:22 -0400
Subject: [thelist] Adcenter Ads
In-Reply-To: <72E9FAA171D63B48AAC707C72900E6B4D89D95@ireland.spinhead.com>
References: <c61099b40710150805t64cc1133t3f1e50d2c0c91524@mail.gmail.com>
	<72E9FAA171D63B48AAC707C72900E6B4D89D95@ireland.spinhead.com>
Message-ID: <04c701c812a1$bc1d98b0$3458ca10$@com>

Anyone know how one can start displaying adcenter ads?
Like Google Adsense?

 
Dave
 
 -----------------------------------
|Beach Computers                    |
|Affordable Hosting Solutions       |
|http://www.beachcomp.com           |
 ===================================
|Cheap Domain Warehouse             |
|Get Your Own Dot!                  |
|http://www.cheapdomainwarehouse.com|
 ---------------------------------- 

------------------------------------
Disclaimer and confidentiality note:

The contents of this communication are intended/meant only for addressee(s)
and may contain information that is privileged or otherwise confidential.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance on the
contents of this information is strictly prohibited and may be unlawful.
The contents of this e-mail shall not be forwarded to any third party. If
you have received this electronic mail transmission in error, please delete
it from your system without copying or forwarding it, and notify the sender
of the error by reply email, so that the sender's address records
can be corrected.
Views and opinions are solely those of the sender unless clearly indicated
as being that of Beach Computers or any of it's affiliated companies.
Beach Computers cannot assure that the integrity of this communication has
been maintained or that it is free of errors, virus, interception or
interference.






From rjmolesa at consoltec.net  Fri Oct 19 15:29:40 2007
From: rjmolesa at consoltec.net (Jon Molesa)
Date: Fri, 19 Oct 2007 16:29:40 -0400
Subject: [thelist] Subversion locking
In-Reply-To: <r221-1049-i386-5D0EB2DAFB5E4CF5803CBF3E113529A1@MBP.local>
References: <F6284A42697D094DBAA8E7BF1594775F0D800356@exchmb1.net.ad.wcc.govt.nz>
	<r221-1049-i386-5D0EB2DAFB5E4CF5803CBF3E113529A1@MBP.local>
Message-ID: <20071019202940.GK2441@jenna.rjmolesa.homelinux.net>

I knew someone else would have a better answer.

*On Fri, Oct 19, 2007 at 12:13:46PM -0700 Steve Axthelm <steveax at pobox.com> wrote:

> Date: Fri, 19 Oct 2007 12:13:46 -0700
> From: Steve Axthelm <steveax at pobox.com>
> To: thelist at lists.evolt.org
> X-Mailer: Mailsmith 2.2
> Subject: Re: [thelist] Subversion locking
> 
> On 2007-10-18 Paul Bennett wrote:
> 
> > We've got an SVN repository and work with a local copy of our site.
> > All has been going fine until a couple, of days ago for my colleague.
> > 
> > > From what I can tell, she has an old lock file on her client setup
> > > which is preventing her checking in / updating form one particular
> > > directory.
> > 
> > I can check in and update the dir, so we know the repository is ok,
> > but I'm guessing something failed (network outage or the like) during
> > one of her commits, leaving the client thinking that the dir was still
> > locked.
> 
> You've tried 'cleanup' on the working copy?
> 
> svn cleanup --help
> cleanup: Recursively clean up the working copy, removing locks, resuming
> unfinished operations, etc.
> usage: cleanup [PATH...]
> 
> Valid options:
>   --diff3-cmd arg          : use ARG as merge command
>   --config-dir arg         : read user configuration files from directory ARG
> 
> HTH,
> 
> 
> -Steve
> 
> -- 
> Steve Axthelm
> steveax at pobox.com
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 

-- 
Jon Molesa
rjmolesa at consoltec.net
if you're bored or curious
http://rjmolesa.com


From evolt_org at striderweb.com  Sat Oct 20 15:21:06 2007
From: evolt_org at striderweb.com (Stephen Rider)
Date: Sat, 20 Oct 2007 15:21:06 -0500
Subject: [thelist] how to protect downloadable docs in members only area
In-Reply-To: <47132AD5.10200@jarmin.com>
References: <47132AD5.10200@jarmin.com>
Message-ID: <9674D8D5-1391-4CCF-9A95-C0E4D2980FC2@striderweb.com>

There is an existing open-source program out there that does this --  
called (IIRC) "PHPFileNavigator".  Might be worth a look.  I've  
played with it a bit, and it seems to work nicely.

Whatever you do, I agree that the best way to protect these documents  
from direct download is that they should be located outside the  
public HTML directory.

Stephen


On Oct 15, 2007, at 3:54 AM, iris wrote:

> good morning everyone
>
> i've got a website that has a password protected members' area (php
> login system).  physically the content is all located within a / 
> members/
> folder.  within this is a documents folder with word, powerpoint etc
> docs which can be downloaded from within the members' area (i.e.  
> only if
> logged in).
>
> however, if someone knew the exact location of a document
> (http://example.com/members/docs/example.doc) they could get to them
> without being logged in.
>
> how do i protect these documents from unauthorised access?


From bobm at dottedi.biz  Sun Oct 21 10:50:58 2007
From: bobm at dottedi.biz (Bob Meetin)
Date: Sun, 21 Oct 2007 09:50:58 -0600
Subject: [thelist] client wishlist - modeling/graphics
Message-ID: <471B7562.1050804@dottedi.biz>

I have a client who has a product, exercise equipment,  He has PDF 
docs/diagrams and some various images.  On his wishlist he would like to 
be able to take some of the images and with whatever software that can 
do this create some 3 dimensional type moving/rotating views, as if 
someone using a video camera is walking around the equipment and moving 
up/down at the same time to change perspective. 

He mentioned autocad which I have heard of, never seen.  I'm wondering 
what application is used to create web-ready imagery like this.  Or what 
service/skillset I need to look for knowing that this is something I 
will likely have to farm out.  When trying to describe the requirments 
he talked about some of the screensavers he's seen with perspective and 
rotating images.

Door #2 which I suggested was to take the equipment to a studio where a 
camera/video person could put it on a rotating platform and do it that way.

-- 
Bob Meetin
dotted i - Internet Strategies & Solutions
www.dottedi.biz
303-926-0167




From jon at phazm.net  Sun Oct 21 11:37:20 2007
From: jon at phazm.net (Jon Hughes)
Date: Sun, 21 Oct 2007 09:37:20 -0700
Subject: [thelist] Conditional Statements -- any downside?
Message-ID: <067301c81400$a71c1490$f5543db0$@net>

I am in the process of writing a blog post promoting conditional statements.
>From my own personal experience, I have found no downside, other than
slightly increased file sizes, to using them.

 

Does anyone have anything against conditional comments?

 

Thanks,

 

-          Jon



From liorean at gmail.com  Sun Oct 21 12:30:38 2007
From: liorean at gmail.com (liorean)
Date: Sun, 21 Oct 2007 19:30:38 +0200
Subject: [thelist] Conditional Statements -- any downside?
In-Reply-To: <067301c81400$a71c1490$f5543db0$@net>
References: <067301c81400$a71c1490$f5543db0$@net>
Message-ID: <cee13aa30710211030g5de7627u2b3a9df8fdc988f2@mail.gmail.com>

On 21/10/2007, Jon Hughes <jon at phazm.net> wrote:
> Does anyone have anything against conditional comments?

Well, mostly this:
- NEVER target future browsers with it. If you tested for IE6 by
checking if the browser version was 6 or higher, then IE7 would also
get that code, and IE7 could break a lot of IE6 specific quirks.
Always make sure you cover the versions you have tested only, and not
any future ones.

But then again, that goes for all hacks/filters.
-- 
David "liorean" Andersson


From skquinn at speakeasy.net  Sun Oct 21 15:50:08 2007
From: skquinn at speakeasy.net (Shawn K. Quinn)
Date: Sun, 21 Oct 2007 15:50:08 -0500
Subject: [thelist] Conditional Statements -- any downside?
In-Reply-To: <067301c81400$a71c1490$f5543db0$@net>
References: <067301c81400$a71c1490$f5543db0$@net>
Message-ID: <1192999808.10447.6.camel@xevious.platypuslabs.org>

On Sun, 2007-10-21 at 09:37 -0700, Jon Hughes wrote:
> Does anyone have anything against conditional comments?

1) They are an IE feature, not a standard Web browser feature. Firefox,
Opera, Safari, Konqueror, Lynx, w3m, Dillo, Epiphany, and dozens of
other browsers may wind up choking on them or at least not giving the
expected results.

2) If carelessly written, you will have invalid HTML. Even if written
"correctly" you may fool the validator into rejecting a document that
would otherwise be valid.

3) By the design and function of a conditional comment, the validator
will see a different document from whatever version(s) of IE you target.
This can be bad, because IE is flaky enough when given valid HTML and
CSS, let alone something that deviates from the standards.

-- 
Shawn K. Quinn <skquinn at speakeasy.net>



From joel at streamliine.com  Sun Oct 21 16:04:18 2007
From: joel at streamliine.com (Joel D Canfield)
Date: Sun, 21 Oct 2007 14:04:18 -0700
Subject: [thelist] Conditional Statements -- any downside?
References: <067301c81400$a71c1490$f5543db0$@net>
	<1192999808.10447.6.camel@xevious.platypuslabs.org>
Message-ID: <72E9FAA171D63B48AAC707C72900E6B4D89E04@ireland.spinhead.com>

> 1) They are an IE feature, not a standard Web browser 
> feature.

While I don't think conditional comments are inherently evil, I do agree
that anyone who uses them should have point #1 clearly in mind. (Points
2 and 3 are real good, too)

> Firefox,
> Opera, Safari, Konqueror, Lynx, w3m, Dillo, Epiphany, and dozens of
> other browsers may wind up choking on them or at least not giving the
> expected results.

You don't happen to know of instances, do you? I know it's a valid
concern, but I'd love to have one for the archives.

joel