[Zope] date in Z Gadfly Database

2000-11-22 Thread Angietel
When i create a table, one of the fields is consider as date type, but the Z Gadfly Database does not allow me to do that, it only accepts INTEGER instead of DATE type. The following is my SQL for creating a table:- CREATE TABLE customer(custid VARCHAR(10),custname VARCHAR(15),custactdate

[Zope] validation-onClick

2000-11-23 Thread Angietel
The form="a" and its input field="custid" is being validated,when the alert message box came outtheni clicked on the 'OK' button which is inside the alert message box, but it return to another page insteadreturn to form="a". ( Ipreferto use 'onClick' insteadof 'onSubmit' ) The following is

[Zope] Can't load confirm message box

2000-12-03 Thread Angietel
body class="body" script language="JavaScript" function confirm(){window.confirm("Are you sure you want to delete?");}/script

[Zope] Problem on connect to MySQL

2000-12-11 Thread Angietel
When i type in the Connection String , it will prompt out the error message - "illegal operation" and in my python it will exactly like this:- Files\WebSite\z2.py" -D--2000-12-12T03:15:10 PROBLEM(100) ZServer Computing default hostname--2000-12-12T03:15:11 INFO(0) ZServer Medusa

[Zope] *Problem on running the ZOPE by using ZmySQLDA

2000-12-13 Thread Angietel
Files\WebSite\z2.py" -D--2000-12-13T08:34:28 PROBLEM(100) ZServer Computing default hostname--2000-12-13T08:34:31 INFO(0) ZServer Medusa (V1.16.4.2) started at Wed Dec 1316:34:31 2000 Hostname: ANGIE Port:8080--2000-12-13T08:34:31 INFO(0) ZServer FTP server started at Wed Dec

[Zope] Problem on running the ZOPE with ZmySQLDA

2000-12-18 Thread Angietel
The following is the illegal operation msg details:- PYTHON executed an invalid instruction in module unknown at :01560f54. Registers: EAX=00b3ceb1 CS=016f EIP=01560f54 EFLGS=00010286 EBX=0001 SS=0177 ESP=01dbf5dc EBP=01560f50 ECX=1e10f91f DS=0177 ESI= FS=57df EDX=

[Zope] Problem on searching the record

2001-01-08 Thread Angietel
The following is my sql method, it can return result even i only enter one alphabet in custname but it can't work when i enter data into the custid. select *from customerwherecustid='dtml-var custid'ORcustname LIKE "%dtml-var custname%" P/s let me know where is my error.TQ

[Zope] How to retrieve the selection list

2001-01-08 Thread Angietel
The following is my selection list, where should i put the dtml-var custcountry in order to display the selected result. select name="custcountry" size="1" tabindex="9" style="HEIGHT: 22px; WIDTH: 293px" option value="."selectedPlease select a country/option option

[Zope] More than one condition indtml-if

2001-01-14 Thread Angietel
The following is my DTML code, purposely to valid the entry field and return the right sql method according to the situation:- dtml-if "_['dtml-var custname']!=""" AND "_['dtml-var custid']==""" dtml-in sqlSearchcust3#// if the custid is blank and custnameis not blank then will use

[Zope] Searching method due to situation

2001-01-14 Thread Angietel
The following is my DTML code, purposely to valid the entry field and return the right sql Searching method according to the situation:- dtml-if "_['dtml-var custname']!=""" AND "_['dtml-var custid']==""" dtml-in sqlSearchcust3#// if the custid is blank and custnameis not blank then

[Zope] Searching method using DTML

2001-01-15 Thread Angietel
dtml-if "_['custname']!=''AND _['custid']==''" dtml-call "sqlSearchcust3" dtml-elif "_['custid']!=''AND _['custname']==''" dtml-call "sqlSearchcust2" dtml-elif "_['custid']!=''AND _['custname']!=''" dtml-call "sqlSearchcust" dtml-else dtml-var

[Zope] DTML-dtml-in dtml-call

2001-01-15 Thread Angietel
Is dtml-call REQUEST['sqlSearchcust3'] equal to dtml-in sqlSearchcust3