新聞財經娛樂♬資訊 News Economy

Correct answer for the specific question was derived elsewhere, posted here for documentation purposes.

So the correct answer is to reformat the PHP data into a PostgreSQL array and pass that variable.  

$userKey = "{".implode(",",array_map("intval", $userKey))."}";

An then pass $userKey in the Array for $1.
   $return = pg_query($conn, "select web.sendKeys($userKey, $userMsgE, $userLoginE)");

The problem is passing a PHP arrary to a PostgreSQL Arrary --  

I see lot's of hits with Google searches but no answers yet --

================

I mean try simple example first and it will help to narrow down the bug,

Duncan

Just think about the input "->" is okay or not ,

Could you put the exact value into put pg_execute()  to test pg_execute is okay on sql database ?
PostpreSql sometimes have different declaration writing syntax tolerance from mysql or other sql


Duncan

Dave,  

   The pg_execute has 3 and the statement has 3 ..   The connection, and the Reference and the array() of values to be passed.  The problem is that the first element of the array is also an array.    I think thinking I need to unnest it and pass it that way..  

Duncan,    

   I am passing (or at least trying to) array(array, string,  string)   which is what the PostgreSQL function wants.  Changing the order kind of makes a mess of some documentation and standards in a function that has been used for years within the postgresql database.  Are you suggesting array(text, text, array) will make a difference ?

The 'pg_execute' page only shows 3 parameters and your statement above has 5.
http://us2.php.net/manual/en/function.pg-execute.php

COuld you put $current_user->user_login as variable  first ? something like that

$a=$current_user['user_login']  //example only
echo $a //to see that is what you want
and put it into  pg_execute if okay

Duncan

Okay,

Get this --

userKey is array
userMsg is string
user_Login is string

Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: array value must start with "{" or dimension information in /home/dxxxxxxxxx/public_html/xxxxxxxx/cgi-bin/xxxxcgi.php on line 87

$return_cde = pg_execute($conn, "SendKeys", array($userKey, $userMsg, $current_user->user_login));

pg_execute has error, right ?  if so, variable passing into web.sendKeys is matched or confilict.

and pg_prepare is no any error at all ?

Please put more echo statement to find out each code is error first

Duncan

Duncan,

   First off my php is runinng as a result of a form post not embedded in the html..

  So ---
<form action="/cgi-bin/xxxicgi.php" method="post" name="FrontPage_Form1" id="pagemsg" onsubmit="return autocomplete="off" FrontPage_Form1_Validator(this)">

<select id="targetGroups" class="targetSubselect" size="5" multiple name="Key[]" width="40" style="width: 400px">

==============================================================================================

The php cgi has no problem with the array Key

 $mySelected=$_POST['Key']
 echo "<br>You chose:<br>";
 foreach ($mySelected as $item)
 echo $item."<br>";

 But when I try to pass the array key to to the PostgreSQL function I get various errors depending on how and where I place the brackets or casts.  But nothing seems to work ..

----------------------------------

Could your provide more code from  your html form, php to parser  $_POST with key array  and all PostpreSQL code ?

I don't find any "?" character in your question post so I guess you need PostpreSQL and PHP tutorial at
this http://www.designmagick.com/article/9/Starting-Out/Adding-data-to-your-database, Right ?

Hope understand your question completely .If not, pls pt it out and  write it in detail

Duncan