Skip site navigation (1) Skip section navigation (2)


From: Eckhard Hoeffner <e-hoeffner(at)fifoost(dot)org>
To: pgsql-php(at)postgresql(dot)org
Subject: Re:
Date: 2002-04-17 21:46:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-php
* Hillensbeck, Preston <PHillensbeck(at)sfbcic(dot)com> [17 04 02 23:30]:

>Hmmm well it still tells me the same thing when I take the quotes off.  Is
>there some type of casting that I might have to do?  I have read about the
>cast command, but don't understand how to use it.

Looks like the definition of the attribut check_trans_type is not
text, but numeric. The quotes are not needed when entering numeric
data but they also do not disturb. 

>Hi Preston
>@$sql="INSERT INTO checking VALUES('$check_date', '$check_num',
>'$check_pay', '$check_amount', '$check_trans_type');";
>Try your INSERT without '' around '$check_amount'. The quotes are only
>used for character-types but not for numeric data.

Eckhard Hoeffner
Tal 44 
D-80331 München

In response to

  • Re: at 2002-04-17 21:30:53 from Hillensbeck, Preston

pgsql-php by date

Next:From: Dan WilsonDate: 2002-04-17 21:52:34
Subject: Re:
Previous:From: Hillensbeck, PrestonDate: 2002-04-17 21:43:39
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group