php-windows Digest 4 Jun 2004 06:57:45 -0000 Issue 2274

Topics (messages 23915 through 23920):

Re: calculations
        23915 by: Gryffyn, Trevor

Re: [ANNOUNCEMENT] ODBTP 1.1.1 Released
        23916 by: Gerardo Rojas
        23917 by: Frank M. Kromann
        23918 by: Robert Twitty

Re: select top 1 *  WAS: [PHP-WIN] [ANNOUNCEMENT] ODBTP 1.1.1 Rel eased
        23919 by: Svensson, B.A.T. (HKG)

IIS5, ISAPI PHP Slow load after timeout
        23920 by: Alan McDonald

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        [EMAIL PROTECTED]


----------------------------------------------------------------------
--- Begin Message ---
As people pointed out, your current calculations don't add up to 452.

What I'm reading here is that you want an image gallery with 3 rows (do you mean 
columns since you're talking width?) with borders on the images.  Maybe you're 
calculating the width to use for your table or something.

If this is the case, I'd change:

------------------------
$galleryRow
... to ...
$galleryCol
------------------------

..just to keep it straight, and I'd change:

------------------------
$contentwidth = ($imagediv * 3);
... to ...
$contentwidth = $imagediv * $galleryCol;
------------------------

But looks like your script does what you want it to do.  

If you work your answer backwards and divide 452 by 3 you get 150.67, so I don't know 
what you did to get that, but I'm thinking you just mis-typed something somewhere.  
The script looks fine by itself for what it seems to be intended for.

-TG

> -----Original Message-----
> From: Lenny Davila [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, June 02, 2004 9:24 PM
> To: 'php windows'
> Subject: [PHP-WIN] calculations
> 
> 
> I have in my php code:
> 
> $galleryRow = 3;
> $maxwidth = 144;
> $borderwidth = 2;
> $imagediv = ($maxwidth + (2 * $borderwidth));
> $contentwidth = ($imagediv * 3);
> 
> The output of contentwidth should be : 452
> But it comes out as 444.  Does anyone know what I am doing wrong?
> TIA
> ------------------------------------
> Eleno Davila
> [EMAIL PROTECTED]
> (877)933-6750 Ext�163 (direct line)
> http://plasticsurgery.com�
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 

--- End Message ---
--- Begin Message ---
Robert,

Do you have an example of pulling the Column types from an MS Sql query?  For example: 
select top 1 * from mytablename.

loop thru the fields in the recordset and print out their data types?


--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]


-----Original Message-----
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 02, 2004 7:52 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] [ANNOUNCEMENT] ODBTP 1.1.1 Released


FYI for the members of this list that are using ODBTP:

Version 1.1.1 has been released, and is available for download at
http://odbtp.sourceforge.net

Key Changes:

* All version 1.1 known bugs have been fixed.
* Data truncation detection.
* Auto char to wide char mapping for MS Access in UNICODE SQL mode.
* PHP 5 support, including Win32 odbtp extension dlls.
* PEAR DB driver works with latest DB version.

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message ---
mssql_field_type() is the function for that.

- Frank

> Robert,
> 
> Do you have an example of pulling the Column types from an MS Sql query?
 For example: select top 1 * from mytablename.
> 
> loop thru the fields in the recordset and print out their data types?
> 
> 
> --
> Gerardo S. Rojas
> mailto: [EMAIL PROTECTED]
> 
> 
> -----Original Message-----
> From: Robert Twitty [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 02, 2004 7:52 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-WIN] [ANNOUNCEMENT] ODBTP 1.1.1 Released
> 
> 
> FYI for the members of this list that are using ODBTP:
> 
> Version 1.1.1 has been released, and is available for download at
> http://odbtp.sourceforge.net
> 
> Key Changes:
> 
> * All version 1.1 known bugs have been fixed.
> * Data truncation detection.
> * Auto char to wide char mapping for MS Access in UNICODE SQL mode.
> * PHP 5 support, including Win32 odbtp extension dlls.
> * PEAR DB driver works with latest DB version.
> 
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

--- End Message ---
--- Begin Message ---
If you are using odbtp as a driver for the mssql ext, and want
mssql_field_type() to return the actual type name, then call

odbtp_set_attr( ODB_ATTR_FULLCOLINFO, 1 );

before you run any queries.

-- bob


On Thu, 3 Jun 2004, Frank M. Kromann wrote:

> mssql_field_type() is the function for that.
>
> - Frank
>
> > Robert,
> >
> > Do you have an example of pulling the Column types from an MS Sql query?
>  For example: select top 1 * from mytablename.
> >
> > loop thru the fields in the recordset and print out their data types?

--- End Message ---
--- Begin Message ---
Does anybody know if that is faster than doing
SELECT * FROM <some table> WHERE 1 = 2 ?

-----Original Message-----
From: Gerardo Rojas
To: Robert Twitty; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 3-6-2004 17:14
Subject: RE: [PHP-WIN] [ANNOUNCEMENT] ODBTP 1.1.1 Released

Robert,

Do you have an example of pulling the Column types from an MS Sql query?
For example: select top 1 * from mytablename.

--- End Message ---
--- Begin Message ---
I have Win2000 Server, PHP4 installed with ISAPI module.
Output_buffer is ON
php4isapi is in the c:\php directory
php4ts.dll is in the system32 directory.
All works OK especially when traffic is high to the site.
But when traffic is low and I assume a timeout expires, it appears to me
that php4ts.dll is unloaded and only reloads when another page is hit. Then
it remains until I leave the site inactive for a period. Then after hitting
the site a few times, pages are delivered quite fast again.
Is there a way of forcing php4ts.dll to remain loaded? if this is in fact
the problem. I know php4isapi.dll remains loaded because I can't rename it
while the application is loaded but I can rename php4ts.dll after a period
of idle activity, so it doesn't remain loaded.
Anyone try adding it to the application list?
Alan

--- End Message ---

Reply via email to