[PHP-DB] numeric in plpgsql function

2003-10-01 Thread Bacuño
Saw this in the Postgresql manual : Chapter 8. Data Types Some of the operators and functions (e.g., addition and multiplication) do not perform run-time error-checking in the interests of improving execution speed. On some systems, for example, the numeric operators for some data types may s

[PHP-DB] numeric in plpgsql function

2003-10-01 Thread Bacuño
numeric problem in postgres function... here's my function : -- Function : fn_adjust_accum_dep(int4,int4,numeric) -- Used in computing accumulated depreciation expense during Adjustment Transaction CREATE OR REPLACE FUNCTION fn_adjust_accum_dep(int4,int4,numeric) RETURNS numeric AS ' DECLARE

RE: [PHP-DB] PHP 5 and MySQL

2003-10-01 Thread Jack van Zanen
Hi, I installed Apache/2.0.47 (Unix) PHP/5.0.0b1 pretty much the same way I installed version 4.3.3 on this apache and both work fine with Mysql straight from the start. This is on Linux and I did compile features into Apache *** MySQL Support enabled A

RE: [PHP-DB] show list of values and new values

2003-10-01 Thread Gary . Every
Create a table (items) with selectable items with these columns select_id | selection | description +---+ 1 | #00 | White 1 | #FF | Black 2 | other | Another type 2 | second| S

[PHP-DB] show list of values and new values

2003-10-01 Thread Hull, Douglas D
Just for example, in php how can I show a list of colors so the user can select one? Also if needed the user could add a new color. This could be a drop down or whatever. How can I make this dynamic so when the user adds the new color that anywhere I show the list of colors in my web pages the n

[PHP-DB] PHP 5 and MySQL

2003-10-01 Thread John Smith
Hello all: This may be a stupid question, but I am having trouble running MySQL on PHP 5. It seems as though the MySQL functionality is not loaded by default. When running 4.3.3 and then showing phpinfo() I receive information containing the fact that the MySQL module has been loaded, but 5.0 doe

Re: [PHP-DB] mySQL field structure question

2003-10-01 Thread CPT John W. Holmes
From: "Susan Ator" <[EMAIL PROTECTED]> > If I have a field in mySQL consisting of a number with 8 digits a decimal > point and 4 more digits what is the field type it needs to be to sort it > numerically? > > I've tried decimal(8,4) but it converts everything to .. I've > also tried fl

[PHP-DB] mySQL field structure question

2003-10-01 Thread Susan Ator
If I have a field in mySQL consisting of a number with 8 digits a decimal point and 4 more digits what is the field type it needs to be to sort it numerically? I've tried decimal(8,4) but it converts everything to .. I've also tried float but it doesn't sort numerically. All of the oth

[PHP-DB] resorting a Table in Mysql?

2003-10-01 Thread Jenson
Hello all, i'm sitting here on my php project and wondering how to solve this problem. I have a MySql - Table with the following fields: q_ID | sur_ID | grp_ID | qText | qTyp | sort_ID if i delete one record in this table i have to resort the sort_ID in the

[PHP-DB] Re: MSSQL Problem

2003-10-01 Thread João Cândido de Souza Neto
Post your script, then we can help you... "Sascha Kaufmann" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hello everyone > > I have a strange problem with MSSQL Server 2000 and PHP 4.3.3 on a > Windows XP machine with IIS. > Sometimes, my script connects to the SQL Server, he s

[PHP-DB] HELP-PHP install

2003-10-01 Thread ed anderson
I submitted a question on Monday, September 01, 2003 2:45 PM, The title was " [PHP-DB] Novice needs help installing PHP on second computer" and it containd the following script with which i installed. The script is a result of two or more months of trying to install linux, mysql, php, and apach

[PHP-DB] MSSQL Problem

2003-10-01 Thread Sascha Kaufmann
Hello everyone I have a strange problem with MSSQL Server 2000 and PHP 4.3.3 on a Windows XP machine with IIS. Sometimes, my script connects to the SQL Server, he said he couldn't connect, but if I reload the page, eveything is fine I can't see any schema in this fault, sometimes it works a

Re: [PHP-DB] HELP-PHP install

2003-10-01 Thread Robert Hennig
Jason Wong wrote: >On Wednesday 01 October 2003 01:39, Balazs Nemeth wrote: > > > >>cd /apache/apache-xxx >>./configure --prefix=/www >>cd /php/php-xxx >>./configure --with-mysql --with-apache=/apache/apache-xxx >>--enable-track-vars >>make >>make install >>cd /apache/apache-xxx >>./configure