[ic] updating an arbitrary SQL table with an IC/HTML form + [process]

Mike Heins interchange-users@lists.akopia.com
Fri Jun 22 13:56:00 2001


Quoting Gabe Burt (gabe_burt@yahoo.com):
> I'm trying to update a table (not userdb or products or any of the
> default tables), and have gotten quite close, but can't quite get it to
> work. I've been referring to this documentation during my efforts:
> 
> http://interchange.redhat.com/cgi-bin/ic/dev/ictemplates_35.html
> 
> I am running Red Hat 6.2 and Postgresql 7.1.
> 
> Here is a snippit from my HTML code:
> 
> <form action="[process secure=1]" method="post">
> <input type="hidden" name="mv_doit"             value="set">
> <input type="hidden" name="mv_session_id"       value="[data session
> id]">

[snip]
> 24.124.4.105 qTwWfqpC:admin admin [22/June/2001:12:26:04 -0500] test
> /cgi-bin/test/process.html No key 'username' found for
> function='update' table='members'
> 

You have no key "username", as it says.

Try adding:

	<INPUT TYPE=hidden NAME=username VALUE="[data session username]">

If anyone can come up with a better error message, please send it to me.
Perhaps:

    Key variable 'username' appears to be empty, won't set blank key.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

I am a great believer in luck, and I find that the harder I work
the more luck I have. -- Thomas Jefferson