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: | 20020417214624.GA6452@fifoost.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
e-hoeffner(at)fifoost(dot)org
Tal 44
D-80331 München
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Wilson | 2002-04-17 21:52:34 | Re: |
Previous Message | Hillensbeck, Preston | 2002-04-17 21:43:39 | Re: |