RE: [PHP] Excel Spreadsheet Writer

2006-10-03 Thread Jef Sullivan
OUTSTANDING!!! Thanks for taking the time. However, I am bit confused. Are you telling me that the blank lines are what is causing my problems? Jef From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 12:41 PM To

[PHP] Excel Spreadsheet Writer

2006-10-02 Thread Jef Sullivan
ons on getting this resolved? If this is the wrong list, please let me know where I can send this question. Perhaps it is the way I installed the Writer? All I did was copy it over from another machine. Jef Sullivan Programmer Progrexion work: 801-828-1745 moble: 801-682-9727

[PHP] addFormat with Spreadsheet Excel Writer

2006-09-08 Thread Jef Sullivan
lor' => 'black', 'bgcolor' => '#C0C0C0', 'bold' => 1) ); Neither have worked. The error I get is pointing to the Writer/Worksheet.php file, line 1242 indicating that it cannot be converted. Yet, this same code was used in anot

[PHP] Spreadsheet Writer

2006-09-07 Thread Jef Sullivan
. Does any one know if that is possible? If so, can you give me a reference for that information? Thanks, Jef -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] calendar Q

2006-08-11 Thread Jef Sullivan
I like using mktime() whenever I pull dates from a database. Get your date from the query, store it to a value: $val = mktime($qval); Then you can compare any part of the date you want by using date(). if( date( "m", date(now)) == date( "m", $val )) m = month Jef -

RE: [PHP] Cron running 'Hello world' script dies with "Could not startup."

2006-08-08 Thread Jef Sullivan
Here is the cron command that we use. I've modified the path to the file for security purposes. */5 * * 1-6 lynx -dump http://fully.qualified.path/cron_test.php -auth=usr:pwd Jef -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 7:

[PHP] php and printing

2006-08-07 Thread Jef Sullivan
similar to the first page. My question is this, has anyone here ever set up printing through php (or javascript) and dealt with multiple pages before? If so, where can you direct me for assistance? Jef

[PHP] [RESOLUTION] -- Spreadsheet Excel Writer

2006-07-13 Thread Jef Sullivan
nly wont one column to be affected by the setColumn() then you set the first and last column values to the same column number. If you want to affect more than one column you can set the last column to the desired column number, just remember the column numbering begins with a 0.

RE: [PHP] setting column width

2006-07-12 Thread Jef Sullivan
I did some more googling and found some information on setColumn(). Thanks for your responses. Jef -Original Message- From: Jef Sullivan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 12, 2006 12:57 PM To: php-general@lists.php.net Subject: [PHP] setting column width I am using the

[PHP] setting column width

2006-07-12 Thread Jef Sullivan
ing a break in the column headers? For example I want... Total Amount to look like... Total Amount Thanks for any help Jef

[PHP] PHP Automation

2006-06-19 Thread Jef Sullivan
Perl. However, I have discovered that a Perl script will not work. I know I can build the URL to the monthly statement. What I don't know how to do is automate this process and get it to print to a specific printer. Any help would be greatly appreciated. Jef

RE: [PHP] Please help me with a query

2006-06-13 Thread Jef Sullivan
Your query is wrong. You are selecting only one result yet you are referencing three. I suggest... SELECT * FROM centers ORDER BY idc asc Jef -Original Message- From: Jesús Alain Rodríguez Santos [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 8:49 AM To: php-general

RE: [PHP] Skip first 4 array values

2006-06-09 Thread Jef Sullivan
Why? Jef -Original Message- From: Jonas Rosling [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 7:48 AM To: PHP List Subject: [PHP] Skip first 4 array values Is there any way you can skip for example the first 4 array values/posisions in an array no matter how many values it

RE: [PHP] parsing out quoted text

2006-06-09 Thread Jef Sullivan
Set your string to an array and use the elements in your query. Jef -Original Message- From: sam [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 6:53 AM To: PHP Subject: [PHP] parsing out quoted text $str='bass "electric organ" bagpipes'; $parser($str); $

RE: [PHP] file from database work local, but not on server

2006-06-08 Thread Jef Sullivan
What happens when you print out the query to the page? Is the query correct? Jef -Original Message- From: Peter Lauri [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 1:10 PM To: php-general@lists.php.net Subject: [PHP] file from database work local, but not on server Best

RE: [PHP] pop-up window in php???

2006-05-30 Thread Jef Sullivan
The code would be quicker and fewer lines if you did this with Javascript, but you could do it with PHP. Use an iframe for the yes / no options, create a form, then capture the response and display the results as you wish. Jef -Original Message- From: Adam Zey [mailto:[EMAIL

RE: [PHP] parsing/replacing for special MS Word characters

2006-05-24 Thread Jef Sullivan
Start here... http://www.php.net/manual/en/function.preg-replace.php Jef -Original Message- From: Dan McCullough [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 8:35 AM To: PHP LIST Subject: [PHP] parsing/replacing for special MS Word characters I have a friend who I wrote

RE: [PHP] date iteration

2006-05-24 Thread Jef Sullivan
+$i,$syear); $dates[$i] = date( "m/d/Y", $added ); } return $dates; } [SNIP] Good luck, Jef -Original Message- From: Richard Lynch [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:27 PM To: Dave Goodchild Cc: php-general@lists.php.net Subj

RE: [PHP] selecting current month from a database

2006-05-22 Thread Jef Sullivan
$cur_month = date("m"); while ($r = mysql_fetch_array($month_query)) { $v = $r["m_id"]; $out = $r["months"]; if( $cur_month = $v ) { echo("".$out."") } } Jef -Origin

FW: [PHP] Date() finding yesterday

2006-05-22 Thread Jef Sullivan
ime, only 24 hours before, use this... $yesterday = mktime(date("H"),date("i"),date("s"),date("m"),date("d")-1,date("Y")); To display the date use... date( "m/d/Y", $yesterday ); Or you can put the mktime code in play of $yester

RE: [PHP] PHP & JavaScript

2006-05-19 Thread Jef Sullivan
I use document.getElementById().value. The only change that would need to be made with the input example is add an id="list['.$x.']" Jef -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Friday, May 19, 2006 8:47 AM To: php-general@lists.php.n

RE: [PHP] Mktime formatting problems

2006-05-11 Thread Jef Sullivan
Here is what I have used for mktime.. $unix_date_33 = mktime(0,0,0,date("m"),date("d")-33,date("Y")); I am getting the current month, day, and year from the system. I am subtracting 33 days from the current day. The result is compared to a date value from the

[PHP] include problem

2006-05-04 Thread Jef Sullivan
ment_type_rs ) mysql_free_result( $payment_type_rs ); ?> The result is an empty pulldown menu. Suggestions? Jef

[PHP] Why Cox went down day before yesterday?

2003-08-14 Thread jef
Jason: I think this is probably why I lost my cable/Cox for several hours almost 12 hours day before yesterday... SEE:http://www.theregister.co.uk/content/5/32340.html _justin -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-07

[PHP] print_r recursion/depth problem

2003-06-17 Thread jef
We are developing a site with the binarycloud platform, which is completely object oriented with (sometimes) large (deep) trees of objects. Sometimes in the place where we need it, deep down, we try to use print_r on the object tree, or subtree, and the machine load average goes to the moon, and b

Re: [PHP] implode()

2002-11-26 Thread Jef
don't know which will be the last element in the string. I am allowing 9 images to be changed, 9 text labels to be changed, and 9 links to be changed. I don't know which will be the last. I'm using an update sql command to change the database when these changes are being made. When

Re: [PHP] implode()

2002-11-26 Thread Jef
x27;$image11_name', "; The reason being the comma at the end of the SQL command will prevent the command from working because SQL will expect another entry. However, your comment about implode expecting an array helps out. Thanks. Jef -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] implode()

2002-11-25 Thread Jef
#x27;) $sqlUpdate .= "textlink12='$textlink12'"; $update = implode(",", $sqlUpdate); $sql = "UPDATE mp " .$sqlUpdate; I get a bad parameter message on the line with the call to the Implode function. Questions? Comments? Suggestions? Jef -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] longitude/latitude function

2002-11-15 Thread jef
Edward: We use a dealer locator. I would suggest one thing if you have a lot of data, hits, namely to pre-calculate the lat/long in radians and store radians in the database. This would speed up the script. _justin Edward Peloke wrote: > > Thanks Aaron, > > If you don't mind me asking, where

[PHP] convert int to string

2002-10-30 Thread Jef
How can I convert an integer variable to a string variable? I have checked PHP's website and I must not be looking for the right function. Any help please. Jef -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Database help

2002-10-08 Thread Jef
The code works fine for displaying the information in the database. However, the first line of information is still skipped. Jef ++ "Davy Obdam" <[EMAIL PROTECTED]> wrote in message 000801c26e63$8622cb00$960a@davy&qu

Re: [PHP] detecting POST variables

2002-10-08 Thread Jef
So is it better to use a text field in this case? Jef + "Vidyut Luther" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... you cannot pre-populate a field type of FILE in a form, it's in

Re: [PHP] NEXT() and/or PREV()

2002-10-08 Thread Jef
What archives? Jef ++ "Jason Wong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Tuesday 08 October 2002 06:03, Jef wrote: > > I need some help with the NEXT() and PRE

Re: [PHP] detecting POST variables

2002-10-08 Thread Jef
I've noticed that this issue is associated with text fields, password fields, and textarea fields. What about file fields? I have a form that is not showing the information pulled from a database in a file field. Any ideas why? Does the file type not allow this to be done?

[PHP] Re: NEXT() and/or PREV()

2002-10-07 Thread Jef
current() function correctly I would use it this way... $fCurrent = current($pnFields); I'm not sure where to go from there. Thanks for your help. Jef <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > sure, get an array with all your

[PHP] Database help

2002-10-07 Thread Jef
next line prints the lot field to the screen. The number printed to the screen is the second lot number that matches this database query. Any suggestions on how to get the first information displayed to the screen? Jef -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] NEXT() and/or PREV()

2002-10-07 Thread Jef
database viewed. Any suggestions? I have gone through the manual on these two functions but nothing has worked. Thank you, Jef -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php