Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gglgokop1704

  1. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi Jpadie, Thank you very very much. It works fine when I changed from int8[] and float8[] to numeric and text[]to varchar. All this while it has been a postgres proiblem and not the script you gave me. This is the message: Database Record inserted correctly thanks very much again Gokop
  2. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi, I changed the criteria_parameters to Criteria_Parameters and see the error: Warning: pg_query(): Query failed: ERROR: relation "criteria_parameters" does not exist in /var/www/html/newconnection.php on line 61 Problem inserting database record. Error was ERROR: relation...
  3. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi Jpadie, My first postgres table was Criteria_Parameters and columns were 'CriteriaID', 'DomainID', 'Criteria_Name', 'Upper_Lim', 'Lower_Lim', 'Range', 'Unit'. But after running the php script it complains. I went through the postgres documentation and I saw that the script converts all names...
  4. gglgokop1704

    how can i insert data into a table in postgresql database

    In postgres, I declared the table fields data types as: criteriaid as int8[] domainid as int8[] criteria_name as text[] upper_lim as float8[] lower_lim as float8[] range as float8[] unit as text[] Has this got anything to do with the error. Anyway they were declaed as int8, float8 and text...
  5. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi, It gave this error: Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 62 Problem inserting database record. Error was ERROR: array value must start with "{" or dimension information in line 62 i.e...
  6. gglgokop1704

    how can i insert data into a table in postgresql database

    By commenting the $fields = implode (" , ", $fields); below foreach and above $query, I got: Warning: pg_query(): Query failed: ERROR: syntax error at or near "Array" at character 34 in /var/www/html/newconnection.php on line 62 Problem inserting database record. Error was ERROR: syntax error...
  7. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi Thanks, Without changing anything, I got: Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 51...
  8. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi Jpadie, See the codes: <?php //set the debug parameters ini_set('display_errors','on'); error_reporting (E_ALL); //start the motor switchboard(); function switchboard(){ if (isset($_POST['submit'])){ processForm(); } displayForm(); } function displayForm(){ echo...
  9. gglgokop1704

    how can i insert data into a table in postgresql database

    You have done so well Jpadie. I did that and got this error: Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 50 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php on line 50 Warning: implode(): Bad arguments. in /var/www/html/newconnection.php...
  10. gglgokop1704

    how can i insert data into a table in postgresql database

    Yes that solves the problem also. I got some errors such as criteria_parameters relations, but I solved them. The error is : Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 60 Problem inserting...
  11. gglgokop1704

    how can i insert data into a table in postgresql database

    Itried to comment the is_binary and leave the is_string. I got this error: Warning: pg_query(): Query failed: ERROR: array value must start with "{" or dimension information in /var/www/html/newconnection.php on line 60 Problem inserting database record. Error was ERROR: array value must start...
  12. gglgokop1704

    how can i insert data into a table in postgresql database

    Thanks again, Error reduced to: Fatal error: Call to undefined function: is_binary() in /var/www/html/newconnection.php on line 71 Regards Gokop
  13. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi Jpadie, Thanks. At least I saw errors now with this change in the input button type. See errors displayed on the browser: Warning: Invalid argument supplied for foreach() in /var/www/html/newconnect.php on line 49 Notice: Undefined variable: dbValues in /var/www/html/newconnect.php on line...
  14. gglgokop1704

    how can i insert data into a table in postgresql database

    Hi Jpadie, It looks ok, however it does not insert data into the table. I have even granted insert, select, udate priviledges to the globus user. I will try working on configurations in httpd.conf and php.ini and see what happens. Thanks for your great help. Gokop
  15. gglgokop1704

    how can i insert data into a table in postgresql database

    The two files are kept in the /var/www/html/ path. I access them through http://host/criteria.htm

Part and Inventory Search

Back
Top