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

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 (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group