Mailing List Archive: URL Loading Error

URL Loading Error - Zope+MySQL

Nov 15, 2006, 9:23 PM

Post #1 of 5 (4079 views)

Hi All,

I'm trying to add data in mysql database using DTML in Zope.

But, all other fields are okay. But, url fiels does not call URL I entered.
Instead it
generates the url for add dtml method like
http://www.thegateway.org/about/gemingeneral/gemConsortium/memberDirectory/contactadd.

Could you give me some piece of advice how to handle?
Any advice would be really appreciated. Best regards, Nam

Here is my add dtml method:
<dtml-var standard_html_header>
<dtml-if submit>
<dtml-call contactadd3>
<h2>New Member Information Added!!</h2>
<p>
<a href="memberlist2">View all Member Information</a>|
<a href="selectcall?SiteID:string=<dtml-var SiteID>">View Added
Information</a>
<br>
<a href="edit1">Edit Member Information</a> |
<a href="delete">Delete Member Information</a> |
<a href="contactadd">Add Member Information</a>
<br>

<dtml-else>
<h1>Member Information Add</h1>
<form action="contactadd" method="POST">
<table width="95%" cellspacing="0" >
<tr>
<td width="20%"><div align="center"><strong>SiteID:</strong></div></td>
<td width="80%"><input name="SiteID" width=30 value=""></td>
</tr>

<tr>
<td width="20%"><div align="center"><strong>Agency:</strong></div></td>
<td width="80%"><input name="Agency" width=30 value=""></td>
</tr>

<tr>
<td width="20%"><div align="center"><strong>URL:</strong></div></td>
<td width="80%"><input name="URL" width=30 value=""></td>
</tr>

<tr>
<td width="20%"><div align="center"><strong>Last
Name:</strong></div></td>
<td width="80%"><input name="LastName" width=30 value=""></td>
</tr>

<tr>
<td colspan=2 align=left>
<input
type="submit" name="submit" value="Add">
<input type="reset" name="cancel" value="Cancel">
</td>
</tr>
</table>
</form></dtml-if><dtml-var standard_html_footer>

Here is memberlist2 page:
<dtml-var standard_html_header>
<h2>Member Information Update</h2>
<ul>
<dtml-in selectAllMethod>
<li> <dtml-var SiteID>
<br>

<font size="-1"><a href="editcall?SiteID=<dtml-var SiteID>">Edit</a>|<a
href="delete?SiteID=<dtml-var SiteID>">delete</a></font>

<p>
</dtml-in>
</ul>

<br>
<a href="contactadd">Add a New Member Information</a>
<dtml-var standard_html_footer>

_________________________________________________________________
Get the latest Windows Live Messenger 8.1 Beta version. Join now.
http://ideas.live.com

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: URL Loading Error - Zope+MySQL [ In reply to ]

lists at zopyx

Nov 15, 2006, 9:44 PM

Post #2 of 5 (3920 views)

Permalink

Your posting really does not contain anything related to your question.
You provide the code of a form and ask about putting the stuff into
a database. What do you want to tell us? You need to write a ZSQL method.
Everything is documented here

<http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx>

-aj

--On 16. November 2006 05:23:08 +0000 oknam park <ponda7777@hotmail.com>
wrote:

> Hi All,
>
> I'm trying to add data in mysql database using DTML in Zope.
>
> But, all other fields are okay. But, url fiels does not call URL I
> entered. Instead it
> generates the url for add dtml method like
> http://www.thegateway.org/about/gemingeneral/gemConsortium/memberDirector
> y/contactadd.
>
> Could you give me some piece of advice how to handle?
> Any advice would be really appreciated. Best regards, Nam
>
> Here is my add dtml method:
> <dtml-var standard_html_header>
> <dtml-if submit>
> <dtml-call contactadd3>
> <h2>New Member Information Added!!</h2>
> <p>
> <a href="memberlist2">View all Member Information</a>|
> <a href="selectcall?SiteID:string=<dtml-var SiteID>">View Added
> Information</a>
> <br>
> <a href="edit1">Edit Member Information</a> |
> <a href="delete">Delete Member Information</a> |
> <a href="contactadd">Add Member Information</a>
> <br>
>
> <dtml-else>
> <h1>Member Information Add</h1>
> <form action="contactadd" method="POST">
> <table width="95%" cellspacing="0" >
> <tr>
> <td width="20%"><div
> align="center"><strong>SiteID:</strong></div></td>
> <td width="80%"><input name="SiteID" width=30 value=""></td>
> </tr>
>
> <tr>
> <td width="20%"><div
> align="center"><strong>Agency:</strong></div></td>
> <td width="80%"><input name="Agency" width=30 value=""></td>
> </tr>
>
> <tr>
> <td width="20%"><div align="center"><strong>URL:</strong></div></td>
> <td width="80%"><input name="URL" width=30 value=""></td>
> </tr>
>
> <tr>
> <td width="20%"><div align="center"><strong>Last
> Name:</strong></div></td>
> <td width="80%"><input name="LastName" width=30 value=""></td>
> </tr>
>
> <tr>
> <td colspan=2 align=left>
> <input
> type="submit" name="submit" value="Add">
> <input type="reset" name="cancel" value="Cancel">
> </td>
> </tr>
> </table>
> </form></dtml-if><dtml-var standard_html_footer>
>
> Here is memberlist2 page:
> <dtml-var standard_html_header>
> <h2>Member Information Update</h2>
> <ul>
> <dtml-in selectAllMethod>
> <li> <dtml-var SiteID>
> <br>
>
> <font size="-1"><a href="editcall?SiteID=<dtml-var SiteID>">Edit</a>|<a
> href="delete?SiteID=<dtml-var SiteID>">delete</a></font>
>
> <p>
> </dtml-in>
> </ul>
>
> <br>
> <a href="contactadd">Add a New Member Information</a>
> <dtml-var standard_html_footer>
>
> _________________________________________________________________
> Get the latest Windows Live Messenger 8.1 Beta version.?Join now.
> http://ideas.live.com
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 TÃ¼bingen - Germany
Web: www.zopyx.com - Email: info@zopyx.com - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting

Re: URL Loading Error - Zope+MySQL [ In reply to ]

ponda7777 at hotmail

Nov 15, 2006, 10:10 PM

Post #3 of 5 (3937 views)

Permalink

Hi,

Terribly Sorry for cross posting. and not clear explanation.

Sincerely,
Nam

>From: Andreas Jung <lists@zopyx.com>
>Reply-To: Andreas Jung <lists@zopyx.com>
>To: oknam park <ponda7777@hotmail.com>, zope-db@zope.org
>Subject: Re: [Zope-DB] URL Loading Error - Zope+MySQL
>Date: Thu, 16 Nov 2006 06:44:12 +0100
>
>Your posting really does not contain anything related to your question.
>You provide the code of a form and ask about putting the stuff into
>a database. What do you want to tell us? You need to write a ZSQL method.
>Everything is documented here
>
><http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx>
>
>-aj
>
>--On 16. November 2006 05:23:08 +0000 oknam park <ponda7777@hotmail.com>
>wrote:
>
>>Hi All,
>>
>>I'm trying to add data in mysql database using DTML in Zope.
>>
>>But, all other fields are okay. But, url fiels does not call URL I
>>entered. Instead it
>>generates the url for add dtml method like
>>http://www.thegateway.org/about/gemingeneral/gemConsortium/memberDirector
>>y/contactadd.
>>
>>Could you give me some piece of advice how to handle?
>>Any advice would be really appreciated. Best regards, Nam
>>
>>Here is my add dtml method:
>><dtml-var standard_html_header>
>><dtml-if submit>
>><dtml-call contactadd3>
>><h2>New Member Information Added!!</h2>
>><p>
>><a href="memberlist2">View all Member Information</a>|
>><a href="selectcall?SiteID:string=<dtml-var SiteID>">View Added
>>Information</a>
>><br>
>><a href="edit1">Edit Member Information</a> |
>><a href="delete">Delete Member Information</a> |
>><a href="contactadd">Add Member Information</a>
>><br>
>>
>><dtml-else>
>><h1>Member Information Add</h1>
>><form action="contactadd" method="POST">
>><table width="95%" cellspacing="0" >
>> <tr>
>> <td width="20%"><div
>>align="center"><strong>SiteID:</strong></div></td>
>> <td width="80%"><input name="SiteID" width=30 value=""></td>
>> </tr>
>>
>><tr>
>> <td width="20%"><div
>>align="center"><strong>Agency:</strong></div></td>
>> <td width="80%"><input name="Agency" width=30 value=""></td>
>> </tr>
>>
>><tr>
>> <td width="20%"><div align="center"><strong>URL:</strong></div></td>
>> <td width="80%"><input name="URL" width=30 value=""></td>
>> </tr>
>>
>><tr>
>> <td width="20%"><div align="center"><strong>Last
>>Name:</strong></div></td>
>> <td width="80%"><input name="LastName" width=30 value=""></td>
>> </tr>
>>
>><tr>
>><td colspan=2 align=left>
>><input
>>type="submit" name="submit" value="Add">
>><input type="reset" name="cancel" value="Cancel">
>></td>
>></tr>
>></table>
>></form></dtml-if><dtml-var standard_html_footer>
>>
>>Here is memberlist2 page:
>><dtml-var standard_html_header>
>><h2>Member Information Update</h2>
>><ul>
>><dtml-in selectAllMethod>
>><li> <dtml-var SiteID>
>><br>
>>
>><font size="-1"><a href="editcall?SiteID=<dtml-var SiteID>">Edit</a>|<a
>>href="delete?SiteID=<dtml-var SiteID>">delete</a></font>
>>
>><p>
>></dtml-in>
>></ul>
>>
>><br>
>><a href="contactadd">Add a New Member Information</a>
>><dtml-var standard_html_footer>
>>
>>_________________________________________________________________
>>Get the latest Windows Live Messenger 8.1 Beta version.?Join now.
>>http://ideas.live.com
>>
>>_______________________________________________
>>Zope-DB mailing list
>>Zope-DB@zope.org
>>http://mail.zope.org/mailman/listinfo/zope-db
>
>
>
>--
>ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 TÃ¼bingen - Germany
>Web: www.zopyx.com - Email: info@zopyx.com - Phone +49 - 7071 - 793376
>E-Publishing, Python, Zope & Plone development, Consulting

><< attach3 >>

_________________________________________________________________
Talk now to your Hotmail contacts with Windows Live Messenger.
http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://get.live.com/messenger/overview

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: URL Loading Error - Zope+MySQL [ In reply to ]

lists at zopyx

Nov 15, 2006, 10:12 PM

Post #4 of 5 (3936 views)

Permalink

--On 16. November 2006 06:10:11 +0000 oknam park <ponda7777@hotmail.com>
wrote:

>
> Hi,
>
> Terribly Sorry for cross posting. and not clear explanation.
>

Unclear? You posted a simple HTML form and said something about
MySQL. All RDMBS issues *including examples* are documented
when you follow the link and read about the RDBMS basics.
Any problem with that?

-aj

Re: URL Loading Error - Zope+MySQL [ In reply to ]

jens at dataflake

Nov 16, 2006, 12:58 AM

Post #5 of 5 (3921 views)

Permalink

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 16 Nov 2006, at 06:23, oknam park wrote:

> Hi All,
>
> I'm trying to add data in mysql database using DTML in Zope.
>
> But, all other fields are okay. But, url fiels does not call URL I
> entered. Instead it
> generates the url for add dtml method like http://
> www.thegateway.org/about/gemingeneral/gemConsortium/memberDirectory/
> contactadd.
>
> Could you give me some piece of advice how to handle?
> Any advice would be really appreciated. Best regards, Nam

I see in your form that you call the input field URL - this is
probably colliding with the "reserved word" URL that is part of the
REQUEST object. Give the input field a different name.

jens

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFFXCghRAx5nvEhZLIRApKBAJ9HDC1VRSTrQ6bBllSdxyJq8PqjkQCfbgvI
E2CnVQ7CgUK5Uc+AV3JPLe8=
=Dhml
-----END PGP SIGNATURE-----
_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db