[ic] Using Mozilla 5.0 - strange things happening with my from

Alma Nuker interchange-users@interchange.redhat.com
Fri May 17 01:45:01 2002


Hi list;

I have form that I use for issuing evaluation license. Everything works
fine when I open my page using Netscape 4.77, IE or Opera 6.0. I do not
have any problems saving form info in db.

Problem is when I am using Mozilla. I do not know what, but something is
going strange. What is happening is that when I enter values in DB
trough form they do not get save to db.

I checked both interchange error.log and apache error.log. They said
nothing.

This is how my table is defined:

Database  evaluationdb  evaluationdb.txt   __SQLDSN__
ifdef SQLUSER
Database  evaluationdb  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  evaluationdb  PASS         __SQLPASS__
endif
Database  evaluationdb  KEY           serial_number
Database  evaluationdb  COLUMN_DEF   "serial_number=INT(9) UNSIGNED
AUTO_INCREMENT PRIMARY KEY"
Database  evaluationdb  COLUMN_DEF   "username=CHAR(30) default '' NOT
NULL"
Database  evaluationdb  COLUMN_DEF   "company=CHAR(30)"
Database  evaluationdb  COLUMN_DEF   "email=VARCHAR(42)"
Database  evaluationdb  COLUMN_DEF   "address1=CHAR(64)"
Database  evaluationdb  COLUMN_DEF   "city=CHAR(30)"
Database  evaluationdb  COLUMN_DEF   "state=CHAR(10)"
Database  evaluationdb  COLUMN_DEF   "zip=CHAR(10)"
Database  evaluationdb  COLUMN_DEF   "country=CHAR(64)"
Database  evaluationdb  COLUMN_DEF   "url_limit=text"
Database  evaluationdb  COLUMN_DEF   "url_limit_other=text"
Database  evaluationdb  COLUMN_DEF   "host_ip_address=CHAR(100)"
Database  evaluationdb  COLUMN_DEF   "issue_date=CHAR(64)"
Database  evaluationdb  COLUMN_DEF   "issue_date=CHAR(64)"
Database  evaluationdb  COLUMN_DEF   "expiry_date=CHAR(100)"
Database  evaluationdb  COLUMN_DEF   "licencekey=text"
Database  evaluationdb  COLUMN_DEF   "invoice_number=text"
Database  evaluationdb  COLUMN_DEF   "order_billing_date=date"
Database  evaluationdb  COLUMN_DEF   "order_billing_amount=text"
Database  evaluationdb  COLUMN_DEF   "order_date_paid=date"
Database  evaluationdb  COLUMN_DEF   "maintenance_required=text"
Database  evaluationdb  COLUMN_DEF   "license_type=text"
Database  evaluationdb  COLUMN_DEF   "product_version_number=text"
Database  evaluationdb  COLUMN_DEF   "static_mapping_limit=CHAR(64)"
Database  evaluationdb  COLUMN_DEF   "dynamic_mapping_limit=CHAR(64)"
Database  evaluationdb  COLUMN_DEF   "evaluation=CHAR(20)"


In my form I have following:


[update values]
[set mv_data_enable]1[/set]
[tag flag write]evaluationdb[/tag]
[perl]
        $Config->{NoSearch} = '';
        return '';
[/perl]

<FORM ACTION="[process]" METHOD="POST">
<INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="evaluationdb">
<INPUT TYPE=HIDDEN NAME="mv_data_key"      VALUE="serial_number">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="insert">
<INPUT TYPE=HIDDEN NAME="mv_nextpage" VALUE=@@MV_PAGE@@>
<INPUT TYPE=hidden NAME="mv_form_profile" VALUE="evaluation_profile">
<INPUT TYPE="HIDDEN" NAME="mv_data_fields"
VALUE="serial_number,username,company,email,address1,city,state,zip,country,url_limit,url_limit_other,host_ip_address,issue_date,expiry_date,licencekey,order_number,maintenance_required,maintenance_fee,maintenance_due_date,license_type,
product_version_number,static_mapping_limit,dynamic_mapping_limit,evalution">

[if session username eq ""]
[set name=User_ID interpolate=1]
[sql type=list query="select username from userdb where company='[value
company]' AND email='[value email]' AND address1='[value address1]'  AND
city='[value city]' AND zip='[value zip]' AND country='[value
country]'"][sql-code][/sql]
[/set]
[else]
[seti User_ID]
[calc]
$Scratch->{mv_autocreate} =~ /mv_username=(\w+)/;
$1;
[/calc][/seti]
[/else]
[/if]

<INPUT TYPE="HIDDEN" NAME="mv_data_return_key" VALUE="serial_number">
<INPUT TYPE="hidden" NAME="serial_number" VALUE="">
<INPUT TYPE="hidden" NAME="license_type" VALUE="Evaluation License">

etccccccccccc etccccccccc alll other things.

<INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
<INPUT TYPE="SUBMIT" NAME=mv_click VALUE="Register Now">
<INPUT TYPE="Reset">
[set Register Now]
mv_nextpage=ord/send_evaluation
[/set]
</FORM>

Do I have to set something special if I am using Interchange with
Mozilla?? Or what ??? Do you have any ideas what is going on ???

I tried everything that I could think off, but I can not see any strange
things happening.


Any help is moew than welocme.

Thank you all so much.

Alma