[PHP] Stored Proc - Date not inserting into the Record

2010-02-25 Thread Don Wieland
I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate DATE,theDateRaw INT) BEGIN INSERT INTO Office_Hours_Cuttoff (ohc_Date,ohc_Date_Raw,Office_Status) VALUES (theDate,theDateRaw,Closed);

Re: [PHP] Stored Proc - Date not inserting into the Record

2010-02-25 Thread Peter
Change the input argument type as a varchar instead of date Ex: CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate VARCHAR(50),theDateRaw INT) surly it will work - Peter Don Wieland wrote: I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE

Re: [PHP] Stored Proc - Date not inserting into the Record

2010-02-25 Thread Peter
FYI Please Pass your input within quotes $db-query(CALL Insert_OHC_Sun(*'*{$nDate}*'*,{$cDate})); surly it will work - Peter Don Wieland wrote: I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate

[PHP] Accessing Windows File Comments

2010-02-25 Thread Floyd Resler
One of my users has asked if I can display comments with a file list on their site. So I thought I might be able to use the comments from the properties of the file. Is there any way I can access this from PHP? The files are actually stored on a Linux box. Thanks! Floyd -- PHP General

Re: [PHP] Accessing Windows File Comments

2010-02-25 Thread Bastien Koert
On Thu, Feb 25, 2010 at 9:59 AM, Floyd Resler fres...@adex-intl.com wrote: One of my users has asked if I can display comments with a file list on their site.  So I thought I might be able to use the comments from the properties of the file.  Is there any way I can access this from PHP?  The

Re: [PHP] Accessing Windows File Comments

2010-02-25 Thread Richard Quadling
On 25 February 2010 14:59, Floyd Resler fres...@adex-intl.com wrote: One of my users has asked if I can display comments with a file list on their site.  So I thought I might be able to use the comments from the properties of the file.  Is there any way I can access this from PHP?  The files

Re: [PHP] Accessing Windows File Comments

2010-02-25 Thread Richard Quadling
On 25 February 2010 15:16, Richard Quadling rquadl...@googlemail.com wrote: On 25 February 2010 14:59, Floyd Resler fres...@adex-intl.com wrote: One of my users has asked if I can display comments with a file list on their site.  So I thought I might be able to use the comments from the

[PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Hi, I forgot to mention that the url is formed from Actionscript, I am just using PHP to do the I/O because Actionscript does not have this option. So, I guess I cannot do the serialize here like you suggested. I have changed # to 0x for now, and that does not seem to help yet. BTW,

[PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Date: Thu, 25 Feb 2010 13:03:57 -0600 From: nos...@mckenzies.net CC: aj...@alumni.iu.edu; php-general@lists.php.net Subject: Re: PHP GET Error? Shawn McKenzie wrote: Alice Wei wrote: Hi, I have done something wrong here, because when I have my variables declared in my PHP:

[PHP] Re: PHP GET Error?

2010-02-25 Thread Shawn McKenzie
Alice Wei wrote: Hi, I have done something wrong here, because when I have my variables declared in my PHP: $people_from = $_GET['people_from']; $state_colors= $_GET['state_colors']; I get this url: http://localhost/generic.php?people_from=Adair, OK-Alfalfa, OK-Atoka,

[PHP] Magento SOAP2

2010-02-25 Thread Kim Madsen
Hi Does anyone on the list have experience with the above? The documentation is only on SOAP1.x, but not on SOAP2 and the calls are completely different: SOAP1.x:

[PHP] Re: PHP GET Error?

2010-02-25 Thread Shawn McKenzie
Alice Wei wrote: Hi, I forgot to mention that the url is formed from Actionscript, I am just using PHP to do the I/O because Actionscript does not have this option. So, I guess I cannot do the serialize here like you suggested. I have changed # to 0x for now, and that does not

[PHP] Re: PHP GET Error?

2010-02-25 Thread Shawn McKenzie
Shawn McKenzie wrote: Alice Wei wrote: Hi, I have done something wrong here, because when I have my variables declared in my PHP: $people_from = $_GET['people_from']; $state_colors= $_GET['state_colors']; I get this url: http://localhost/generic.php?people_from=Adair,

[PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Date: Thu, 25 Feb 2010 13:50:16 -0600 From: nos...@mckenzies.net To: aj...@alumni.iu.edu CC: php-general@lists.php.net Subject: Re: PHP GET Error? Alice Wei wrote: Hi, I forgot to mention that the url is formed from Actionscript, I am just using PHP to do the I/O because

[PHP] PHP GET Error?

2010-02-25 Thread Alice Wei
Hi, I have done something wrong here, because when I have my variables declared in my PHP: $people_from = $_GET['people_from']; $state_colors= $_GET['state_colors']; I get this url: http://localhost/generic.php?people_from=Adair, OK-Alfalfa, OK-Atoka, OK-Beaver, OK-Beckham,

Re: [PHP] RE: PHP GET Error?

2010-02-25 Thread Ashley Sheridan
On Thu, 2010-02-25 at 15:01 -0500, Alice Wei wrote: Date: Thu, 25 Feb 2010 13:50:16 -0600 From: nos...@mckenzies.net To: aj...@alumni.iu.edu CC: php-general@lists.php.net Subject: Re: PHP GET Error? Alice Wei wrote: Hi, I forgot to mention that the url is formed from

Re: [PHP] PHP GET Error?

2010-02-25 Thread Ashley Sheridan
On Thu, 2010-02-25 at 13:32 -0500, Alice Wei wrote: Hi, I have done something wrong here, because when I have my variables declared in my PHP: $people_from = $_GET['people_from']; $state_colors= $_GET['state_colors']; I get this url:

RE: [PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Subject: Re: [PHP] RE: PHP GET Error? From: a...@ashleysheridan.co.uk To: aj...@alumni.iu.edu CC: nos...@mckenzies.net; php-general@lists.php.net Date: Thu, 25 Feb 2010 20:03:28 + On Thu, 2010-02-25 at 15:01 -0500, Alice Wei wrote: Date: Thu, 25 Feb 2010 13:50:16 -0600 From:

[PHP] Re: PHP GET Error?

2010-02-25 Thread Shawn McKenzie
Alice Wei wrote: Date: Thu, 25 Feb 2010 13:50:16 -0600 From: nos...@mckenzies.net To: aj...@alumni.iu.edu CC: php-general@lists.php.net Subject: Re: PHP GET Error? Alice Wei wrote: Hi, I forgot to mention that the url is formed from Actionscript, I am just using PHP to do the I/O

RE: [PHP] RE: PHP GET Error?

2010-02-25 Thread Ashley Sheridan
On Thu, 2010-02-25 at 15:11 -0500, Alice Wei wrote: Subject: Re: [PHP] RE: PHP GET Error? From: a...@ashleysheridan.co.uk To: aj...@alumni.iu.edu CC: nos...@mckenzies.net; php-general@lists.php.net Date: Thu, 25 Feb 2010 20:03:28 + On Thu, 2010-02-25 at 15:01

[PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Alice Wei wrote: Date: Thu, 25 Feb 2010 13:50:16 -0600 From: nos...@mckenzies.net To: aj...@alumni.iu.edu CC: php-general@lists.php.net Subject: Re: PHP GET Error? Alice Wei wrote: Hi, I forgot to mention that the url is formed from Actionscript, I am just using

Re: [PHP] RE: PHP GET Error?

2010-02-25 Thread Shawn McKenzie
Alice Wei wrote: Subject: Re: [PHP] RE: PHP GET Error? From: a...@ashleysheridan.co.uk To: aj...@alumni.iu.edu CC: nos...@mckenzies.net; php-general@lists.php.net Date: Thu, 25 Feb 2010 20:03:28 + On Thu, 2010-02-25 at 15:01 -0500, Alice Wei wrote: Date: Thu,

RE: [PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Alice Wei wrote: Hi, I forgot to mention that the url is formed from Actionscript, I am just using PHP to do the I/O because Actionscript does not have this option. So, I guess I cannot do the serialize here like you suggested. I have changed # to 0x for now, and that

Re: [PHP] RE: PHP GET Error?

2010-02-25 Thread Shawn McKenzie
Alice Wei wrote: I can't see anything obviously wrong with the URL really. Is there no way instead to send the data as post data from Flash? I know Flash can make post requests, but I'm not sure how much more difficult it is. I had it using POST before, but from the PHP point of view, it

RE: [PHP] RE: PHP GET Error?

2010-02-25 Thread Alice Wei
Date: Thu, 25 Feb 2010 15:04:46 -0600 From: nos...@mckenzies.net To: aj...@alumni.iu.edu CC: a...@ashleysheridan.co.uk; php-general@lists.php.net Subject: Re: [PHP] RE: PHP GET Error? Alice Wei wrote: I can't see anything obviously wrong with the URL really. Is there no way instead

Re: [PHP] $_POST vs $_REQUEST

2010-02-25 Thread Jochem Maas
Op 2/24/10 11:18 AM, Ashley Sheridan schreef: On Wed, 2010-02-24 at 07:55 +, Jochem Maas wrote: Op 2/22/10 10:49 PM, John Black schreef: On 02/22/2010 11:42 PM, Michael Shadle wrote: The difference here is you can at least have some control over the data and expect it in a certain

[PHP] Re: Database design

2010-02-25 Thread Manuel Lemos
Hello, on 02/25/2010 02:37 AM Angus Mann said the following: Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate. I need

Re: [PHP] Re: Database design

2010-02-25 Thread sathyashrayan
On Thu, 2010-02-25 at 22:03 -0300, Manuel Lemos wrote: Hello, on 02/25/2010 02:37 AM Angus Mann said the following: Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please

[PHP] ctype_print, the British Pound and other non-ASCII characters

2010-02-25 Thread Bob
I'm seeing mischief from ctype_print. So far as I can tell, the British Pound symbol, '£' is considered a printable character according to the locale I use on my Ubuntu box. But even across two years, two boxes, several versions of Ubuntu (from 7.04 to 9.10, one x86, one AMD64), and two major

Re: [PHP] HipHop and other PHP compiler performance evaluation

2010-02-25 Thread Manuel Lemos
Hello Raymond, on 02/25/2010 11:34 PM Raymond Irving said the following: Very nice article. Thanks for sharing. I wish PHP had a feature/extension to compile (to native code) and cache the scripts at runtime. This way we could get speeds that are very close to PHC and Hiphop. It would be

[PHP] header function query

2010-02-25 Thread Nick allan
Hi all The situation is as follows I've read some data in from a couple of files into a string variable, made some changes to it and want to send the contents of the string out to the browser as a word document. My code currently looks like the following header('Content-Type: