[Zope] Problem w/ form writing to database

Terry McKenna terry_a_mckenna@yahoo.com
Tue, 10 Jul 2001 09:49:48 -0700 (PDT)


Steve,

Thanks a lot. This did the trick. 

--- Steve Spicklemire <steve@spvi.com> wrote:
> 
> Yeah.. the 'name="..."' in your form needs to match
> the arguments in
> your ZSQLMethod, or you need to explicitly use them
> as arguments
> to you method, 
> 
> e.g., <dtml-call "newTicket(email=x, priority=y,
> problem=z)">
> 
> -steve
> 
> >>>>> "Terry" == Terry McKenna
> <terry_a_mckenna@yahoo.com> writes:
> 
>     Terry> Steve,
> 
>     Terry> Thanks for the quick response. I tried
> this approach.  I
>     Terry> get the following error:
> 
>     Terry> Error Type: Bad Request Error Value:
> ['email', 'priority',
>     Terry> 'problem']
> 
>     Terry> I have these variables defined as
> "arguments" in my Z SQL
>     Terry> Method. Not sure why this is happening.
> Any ideas?
> 
>     Terry> --- Steve Spicklemire <steve@spvi.com>
> wrote:
>     >>  Hi Terry,
>     >> 
>     >> You want the "action" of your form to be
> another DTML Method
>     >> that calls the ZSQLMethod and then either
> displays some
>     >> confirmation UI, or redirects to something
> intelligent.
>     >> 
>     >> e.g.,
>     >> 
>     >> <dtml-call newTicket>
>     >> 
>     >> Thanks Your Ticket has been entered!
>     >> 
>     >> <form action="&dtml-URL1;"> <input
> type="SUBMIT" value="OK!">
>     >> </form>
>     >> 
>     >> -steve
>     >> 
>     >> Terry McKenna wrote:
>     >> > 
>     >> > I am trying to build a Help Desk Trouble
> Ticket > tracking
>     >> system. I want to use a web based form to >
> allow customers to
>     >> enter trouble tickets. The problem > I am
> having is that when I
>     >> submit the form, the zope > development
> environment pulls up
>     >> its native database > "test" form instead of
> making an entry in
>     >> the > database. It seems I can only enter
> data to my > external
>     >> database through the Zope "test" form.  Any >
> ideas?
>     >> >
>     >>
> ---------------------------------------------------
>     >> > 
>     >> > "submitTicket" method:
>     >> > 
>     >> > <form action="troubleTicket/newTicket"
> method="get"> >
>     >> <table> > <tr> > <th align=right>Name: >
> <td><input type="text"
>     >> name="name" size=32> > <tr> > <th
> align=right>Phone: >
>     >> <td><input type="text" name="phone" size=10>
> > <tr> > <th
>     >> align=right>E-Mail: > <td><input type="text"
> name"email"
>     >> size=32> > <tr> > <th aligh=right>App: >
> <td><select
>     >> name="app"> > <option>N/A > <option>Servie
> Inquiry >
>     >> <option>Idea DataMart > <option>Siebel Smart
> Serve > <option>S4
>     >> Operations > </select> > <tr> > <th
> aligh=right>Server: >
>     >> <td><select name="server"> > <option>N/A >
> <option>caycom3 >
>     >> <option>caycom4 > <option>caydec1 >
> <option>caydec2 >
>     >> <option>cosclim1 > <option>cossi01 >
> <option>cspcom1 >
>     >> <option>cspcom2 > <option>cspsie05 >
> <option>norsi01 >
>     >> <option>omzdie06 > <option>omzsie07 >
> <option>omzsie09 >
>     >> <option>s4reports > <option>system2 >
> </select> > <tr> > <th
>     >> align=right>Priority: > <td><select
> name="pri"> > <option>4 >
>     >> <option>3 > <option>2 > <option>1 > </select>
> > </table> >
>     >> <table> > <tr> > <td> 1 = 1 hr response >
> <tr> > <td> 2 = 4 hr
>     >> response > <tr> > <td> 3 = 24 hr response >
> <tr> > <td> 4 = 72
>     >> hr response > </table> > <p><h4>Description
> of Problem:</h4> >
>     >> <textarea name="description" cols="37"
> rows="5"> > </textarea>
>     >> > <p><input type="submit" name="submit"
> value=" > Submit " >
>     >> </form>
>     >> >
>     >> 
>     Terry>
>
---------------------------------------------------------------
>     >> > > Z SQL method "newTicket":
>     >> > 
>     >> > insert into ticket3 values > (<dtml-sqlvar
> ticketNum
>     >> type="int" optional>, > <dtml-sqlvar name
> type="string">, >
>     >> <dtml-sqlvar phone type="string">, >
> <dtml-sqlvar email
>     >> type="string">, > <dtml-sqlvar app
> type="string">, >
>     >> <dtml-sqlvar server type="string">, >
> <dtml-sqlvar priority
>     >> type="int">, > <dtml-sqlvar problem
> type="string">)
>     >> >
>     >> 
>     Terry>
>
--------------------------------------------------------------
>     >> > > submitTicket calls newTicket. I think
> submitTicket > passes
>     >> the values entered by the user on the form to
> > newTicket. I
>     >> thought that should be enough for > NewTicket
> to make an entry
>     >> in the database but the > Zope "test"
> interface populates the
>     >> screen when I hit > submit.
>     >> > 
>     >> > -Thanks in advance.
>     >> > 
>     >> >
> __________________________________________________ >
> Do You
>     >> Yahoo!?  > Get personalized email addresses
> from Yahoo! Mail >
>     >> http://personal.mail.yahoo.com/
>     >> > 
>     >> >
> _______________________________________________ >
> 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 )
> 
> 
>     Terry>
> __________________________________________________
> Do You
>     Terry> Yahoo!?  Get personalized email addresses
> from Yahoo! Mail
>     Terry> http://personal.mail.yahoo.com/
> 
> 


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/