"Results returned for UPDATE ONLY"

From: Al (none_at_no.com)
Date: 12/15/04

  • Next message: Mark Matthews: "Re: "Results returned for UPDATE ONLY"" 
    Date: Wed, 15 Dec 2004 20:09:49 GMT

    I just put together some servlets to communicate with MYSQL. One merely
    accepts a string as input in a form and sends it to MYSQL. I have a table
    named 'articles', with columns 'name' and 'summary'. I can INSERT values
    in to the table, by sending:
    insert into articles (name,summary) values ('a', 'b')

    That works fine. But when I try:
    select * from articles
    I get the error:
    java.sql.SQLException: Results returned for UPDATE ONLY.

    What am i doing wrong? Thanks.

  • Next message: Mark Matthews: "Re: "Results returned for UPDATE ONLY""

    Relevant Pages

    • Re: "Results returned for UPDATE ONLY"
      ... > I just put together some servlets to communicate with MYSQL. ... > accepts a string as input in a form and sends it to MYSQL. ...
      (comp.lang.java.databases)
    • Re: return multiple rows from sql statement
      ... strings from input values is almost certainly a safe path to SQL ... Also, being a MySQL function, it knows what MySQL needs or uses. ... All characters that are entered in the fields make their way into the database unaltered. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
      (comp.lang.php)
    • Re: DoCmd.RunSQL who could check my sql?
      ... The SQL string looks correct. ... DoCmd.RunSQL MySQL 'No Parentheses ... Dim mySQL As String ... Is the SQL after the DoCmd.sql the same code as the sql access uses when you look in query designer view / sql? ...
      (microsoft.public.access.modulesdaovba)
    • Re: Errors installing Template CPAN module
      ... Clue #1 is taring you right in the face ... ... > Now enter the data source for the test database. ... do you have MySQL on your system? ... > Use of uninitialized value in join or string at ...
      (comp.lang.perl.misc)
    • Re: php form info...
      ... when trying to search in the mysql statement. ... : echo $testvar; ... combine a variable containing an arbitrary string with a constant number. ... The results within php depend a great deal on the contents ...
      (comp.lang.php)