Glad you found the problem.
On Aug 9, 2006, at 11:42 PM, PostgreSQL Admin wrote:
$connection->execute("SELECT insert_staff_b('$staff
[insert_firstname]'::varchar)");
$connection->execute("SELECT insert_staff_b('".$staff
['insert_firstname']."'::varchar)");
If you are creating SQL functions y
Thanks for the catch. I've tried:
$connection->execute("SELECT
insert_staff_b('$staff[insert_firstname]'::varchar)");
$connection->execute("SELECT
insert_staff_b('".$staff['insert_firstname']."'::varchar)");
None work... I'm scratching my head on this one.
Thanks,
J
On Aug 9, 2006, at 10:36 PM, PostgreSQL Admin wrote:
select insert_staff_b('$_POST['firstname']::varchar)
Still I get this error:
Warning: pg_query(): Query failed: ERROR: function insert_staff_b
(character varying) does not exist HINT: No function matches the
given name and argument types
