[Zope] - Re: Bug or Error? in ZMySQL--Sorry, Ignore this.

[LEE, Kwan Soo]

I am terribly sorry now. I just see I made an sql syntax mistake.
Please yell at me, "You STUPID!". I deserve that.
                        LEE Kwan Soo
"LEE, Kwan Soo" wrote:

> Well, I wish this is my error, but as far as I see, it seems otherwise.
> I've searched the zope list but failed to solve this problem.
>
> The ZMySQLDA-1.1.2-nonbin.tar.gz and python 1.5.1 are installed.
> Using Zope 1.9.0 with PCGI through apache redirection.
> MySQL server version is 3.21.30 installed from mysql-3.21.30-rh50.1.rpm
> and mysql-client from mysql-client-3.21.30-rh50.1.rpm.
> OS is RedHat 5.2.
> (with no attribution at myhost/Zope/ yet. this site  is not 'released'
> yet).
>
> I have a SQLMethod
>
> ID:  update_anot
> ConnectionID: MySQL
> Arguments:  words type id timestring url expla
>
> Query template:
> update anots
> set words = <!--#sqlvar words type=nb-->
> and type = <!--#sqlvar type type=string-->
> and url = <!--#sqlvar url type=string-->
> and expla = <!--#sqlvar expla type=nb-->
> where
> id = <!--#sqlvar id type=string--> and
> timestring = <!--#sqlvar timestring type=string-->
>
> and auto-made serch input form 'y' :
> <form action="x" method="get">
> ...
> <table>
> <tr> <th>Words</th>
> <td><input name="words" width=30 value=""></td></tr>
> <tr> <th>Type</th>
> <td><input name="type" width=30 value=""></td></tr>
> <tr> <th>Id</th>
>  <td><input name="id" width=30 value=""></td></tr>
> <tr> <th>Timestring</th>
>  <td><input name="timestring" width=30 value=""></td></tr>
> <tr> <th>Url</th>
>  <td><input name="url" width=30 value=""></td></tr>
> <tr> <th>Expla</th>
>  <td><input name="expla" width=30 value=""></td></tr>
> <tr><td colspan=2 align=center>
> <input type="SUBMIT" name="SUBMIT" value="Submit Query">
> <!--#if HTTP_REFERER-->
>   <input type="SUBMIT" name="SUBMIT" value="Cancel">
>   <INPUT NAME="CANCEL_ACTION" TYPE="HIDDEN"
>          VALUE="<!--#var HTTP_REFERER-->">
> <!--#/if HTTP_REFERER-->
> </td></tr>
> </table>
> </form>
>
> and auto-made report form x:
>
> <!--#in update_anot size=50 start=query_start-->
>    <!--#if sequence-start-->
>
>       <!--#if previous-sequence-->
>         <a href="<!--#var URL--><!--#var sequence-query
>                  -->query_start=<!--#var
>                  previous-sequence-start-number-->">
>         (Previous <!--#var previous-sequence-size--> results)
>         </a>
>       <!--#/if previous-sequence-->
>       <table border>
>  <tr>
>  </tr>
>
>    <!--#/if sequence-start-->
>
>    <tr>
>  </tr>
>
>    <!--#if sequence-end-->
>       </table>      <!--#if next-sequence-->
>          <a href="<!--#var URL--><!--#var sequence-query
>             -->query_start=<!--#var
>             next-sequence-start-number-->">
>          (Next <!--#var next-sequence-size--> results)
>          </a>
>       <!--#/if next-sequence-->
>    <!--#/if sequence-end-->
>
> <!--#else-->
>
>   There was no data matching this <!--#var title_or_id--> query.
>
> <!--#/in-->
>
> (actually I used custum edited ones. however auto-made ones do the same
> curious thing)
>
> I have test several pairs of data input through the search form y and
> whenever & whatever I did, y-update_anot-x tripple makes words field '0'
> and do not update any other field.
> Same pairs succeeded to update through mysql at telnet terminal.
>
> Now what is my fault?
> Please tell me, then you are a God-send angel!!!
>
>         LEE Kwan Soo
>
> p.s. What I'm afraid of is reinstalling mysql from source codes. Should
> I do it?