Problem when using Z SQL Method and URL named field
Hello, I don't know what/ and if this is correct, but perhaps somebody can check for me. I have a MySQL database connection with ZMySQLDA, and have the following table. CREATE TABLE BusinessName ( BusID int(11) DEFAULT '0' NOT NULL auto_increment, BusinessName varchar(40), CompanyInfo text, NoEmployees int(11), Turnover int(11), URL varchar(35), Status int(2) DEFAULT '0' NOT NULL, PRIMARY KEY (BusID) ) Here is my Z SQL Method insert into BusinessName (BusinessName, CompanyInfo, NoEmployees, Turnover, URL, Status) values ('<dtml-var BusinessName>', '<dtml-var CompanyInfo>', '<dtml-var NoEmployees>', '<dtml-var Turnover>', '<dtml-var URL>', '<dtml-var Status>') The problem is that URL appends the path of where the object is based, to the url address I type, so that I get this:- SQL used: insert into BusinessName (BusinessName, CompanyInfo, NoEmployees, Turnover, URL, Status) values ('dfsfdfs', 'dsfsdfasf', '12', '1', 'http://this-address.net//Tutorials/Zope_MySQL/methods/insert2/manage_test', '1') So how do I resolve this? Without having to rename the field name. Thanks Norman zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz zz/********/z/****\zzz|****\*\zz|*******|z z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman@khine.net zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz zz/******/zz\******/zz|*|zzzzzzz|*|*****|z z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
Norman Khine wrote:
Hello, I don't know what/ and if this is correct, but perhaps somebody can check for me. I have a MySQL database connection with ZMySQLDA, and have the following table.
CREATE TABLE BusinessName ( BusID int(11) DEFAULT '0' NOT NULL auto_increment, BusinessName varchar(40), CompanyInfo text, NoEmployees int(11), Turnover int(11), URL varchar(35), Status int(2) DEFAULT '0' NOT NULL, PRIMARY KEY (BusID) )
Here is my Z SQL Method
insert into BusinessName (BusinessName, CompanyInfo, NoEmployees, Turnover, URL, Status) values ('<dtml-var BusinessName>', '<dtml-var CompanyInfo>', '<dtml-var NoEmployees>', '<dtml-var Turnover>', '<dtml-var URL>', '<dtml-var Status>')
The problem is that URL appends the path of where the object is based, to the url address I type, so that I get this:-
This happens because "URL" is a reserved word in Zope and resolves to exactly what you're getting. Try using an alternate name like companyURL for the form field name. Also look at dtml-sqlvar in Appendix in the Zope Book online. In general using dtml-sqlvar for inputs to ZSQL methods is recommended and also more powerful. Nitin Borwankar nitin@borwankar.com
SQL used:
insert into BusinessName (BusinessName, CompanyInfo, NoEmployees, Turnover, URL, Status) values ('dfsfdfs', 'dsfsdfasf', '12', '1',
'http://this-address.net//Tutorials/Zope_MySQL/methods/insert2/manage_test', '1')
So how do I resolve this? Without having to rename the field name.
Thanks
Norman
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz zz/********/z/****\zzz|****\*\zz|*******|z z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman@khine.net zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz zz/******/zz\******/zz|*|zzzzzzz|*|*****|z z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- -- Nitin Borwankar nitin@borwankar.com
participants (2)
-
Nitin Borwankar -
Norman Khine