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

Error with query

From: Helgi Örn Helgason <sacredeagle(at)gmail(dot)com>
To: PostgreSQL - newbie <pgsql-novice(at)postgresql(dot)org>
Subject: Error with query
Date: 2010-10-07 07:54:07
Message-ID: AANLkTi=Xcejx32F5Vu7Q-0UnDmBAknTskGsm=RKWn+EP@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
I'm still a postgres newbie so don't get upset if I'm sending this
question to the wrong forum, just tell me if I am and I'll move it.

I get this error message in Firefox:
Error with query: ERROR: invalid input syntax for type date: "" LINE
1: ..._name, pack_tidin, pack_tidut, pack_lunch) VALUES('', '', ''...
^

When running this query with PHP:

<?php
$db = pg_connect('host=localhost dbname=name user=me password=pass');

$pack_date = pg_escape_string($_POST['pack_date']);
$pack_week = pg_escape_string($_POST['pack_week']);
$pack_day = pg_escape_string($_POST['pack_day']);
$pack_pts = pg_escape_string($_POST['pack_pts']);
$pack_name = pg_escape_string($_POST['pack_name']);
$pack_tidin = pg_escape_string($_POST['pack_tidin']);
$pack_tidut = pg_escape_string($_POST['pack_tidut']);
$pack_lunch = pg_escape_string($_POST['pack_lunch']);

$query = "INSERT INTO timmar(pack_date, pack_week, pack_day, pack_pts,
pack_name, pack_tidin, pack_tidut, pack_lunch) VALUES('" . $pack_date
. "', '" . $pack_week . "', '" . $pack_day . "', '" . $pack_pts . "',
'" . $pack_name . "', '" . $pack_tidin . "', '" . $pack_tidut . "', '"
. $pack_lunch . "')";
$result = pg_query($query);
if (!$result) {
    $errormessage = pg_last_error();
    echo "Error with query: " . $errormessage;
    exit();
}
printf ("Detta har lagts till i databasen - %s %s %s", $pack_date,
$pack_week, $pack_day, $pack_pts, $pack_name, $pack_tidin,
$pack_tidut, $pack_lunch);
pg_close();
?>

I've search every little " and ' and , and . and all I can think of
but it still doesn't work. I started with only 3 columns (in another
test-database) and everything was just fine.
Anyone who can spot something I missed?

If you think you need the FORM part just let me know and I'll send it.

Regards,
Helgi Örn

--
PostgreSQL 8.4.4, Ubuntu Linux 10.04, Firefox 3.6.10

Responses

pgsql-novice by date

Next:From: Cristian RomanescuDate: 2010-10-07 07:56:38
Subject: Re: Error with query
Previous:From: Michael WoodDate: 2010-10-07 07:10:40
Subject: Re: Alternative to AS?

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