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

interchange-users@interchange.redhat.com interchange-users@interchange.redhat.com
Fri May 17 08:20:01 2002


On Fri, May 17, 2002 at 03:14:52PM +0930, Alma Nuker wrote:
> 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.
> 

We use Mozilla all the time; it is **important** to use the latest
greatest version.  There is no such thing yet as "stable" mozilla.
If it works with the other browsers and passes weblint, etc... then
you are probably ok.



> 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
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users

-- 

Christopher F. Miller, Publisher                               cfm@maine.com
MaineStreet Communications, Inc           208 Portland Road, Gray, ME  04039
1.207.657.5078                                         http://www.maine.com/
Content/site management, online commerce, internet integration, Debian linux