Re:

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

In response to

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

Browse pgsql-php by date

  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: