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

[Gabe Burt]

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]">
<input type="hidden" name="mv_nextpage"         value="members">
<input type="hidden" name="mv_data_enable"      value="1">
<input type="hidden" name="mv_data_table"       value="members">
<input type="hidden" name="mv_data_key"         value="username">
<input type="hidden" name="mv_data_function"    value="UPDATE">
<input type="hidden" name="mv_data_fields"     
value="fullname,biz_name">
<input type="hidden" name="mv_data_filter_fullname"        
value="sql">
<input type="hidden" name="mv_data_filter_biz_name"        
value="sql">
Full name:
<INPUT TYPE=text NAME=fullname VALUE="[value fullname]" size="30">
<br><br>
Business name:
<INPUT TYPE=text NAME=biz_name VALUE="[value biz_name]" size="30">
<br><br>
<input type="hidden" name="mv_todo" value="set">
<input type="submit" value=" Save ">
</form>

Here's my dbconf/pgsql/members.pgsql file:

Database  members  members.txt __SQLDSN__
#ifdef SQLUSER
Database  members  USER         __SQLUSER__
#endif
#ifdef SQLPASS
Database  members  PASS         __SQLPASS__
#endif
Database  members  KEY          username
Database  members  COLUMN_DEF   "username=VARCHAR(20) NOT NULL PRIMARY
KEY"
Database  members  COLUMN_DEF   "fullname=VARCHAR(128)"
Database  members  COLUMN_DEF   "biz_name=varchar(128)"
Database  members  ChopBlanks   1

Here's the error message I get in my error.log file:

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'

The table 'members' has definitely been created and the row for the
user I'm trying to update with has already been inserted.

Regards,

Gabe

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/