[Zope] Zope with Microsoft Access

[Mike Kelland]

Hrm... I've tried what you said, but  it still fails to work...

Is there a Zope guru out there who is willing to look over this code in it
entirety (ie the DTML and the ZSQL Method) and work with me directly to try
to get this working?

Thanks,
Mike
mike@studiomatic.com

----- Original Message -----
From: "Chris Gray" <cpgray@library.uwaterloo.ca>
To: "Mike Kelland" <mike@studiomatic.com>
Cc: <zope@zope.org>
Sent: Thursday, November 23, 2000 3:56 PM
Subject: Re: [Zope] Zope with Microsoft Access


> Here's a fix.  Change the line:
>
> <dtml-call UpdateHours(REQUEST)>
>
> to:
>
> <dtml-call "UpdateHours(myval=_['myval'], mykey=_['mykey'],
> sequence_item=_['sequence-item'])">
>
> and change the name of the parameter in your ZSQL method from
> sequence-item to sequence_item and change the dtml-var tag in the method
> to <dtml-var sequence_item>.
>
> Cheers,
> Chris
>
> On Wed, 22 Nov 2000, Mike Kelland wrote:
>
> > What does <dtml-var "0/0"> actually do?  Looks like all it would do is
> > divide by zero which *has* to be some kind of error.  The problem, I
think,
> > lies mainly in the arguments being passed to UpdateHours.  I have done a
> > whole slew of tests to show that my if statement works perfectly (the
> > _.string.find thing seems to return false if it finds the specified sub
> > string which is odd, but works) and I've actually outputted the correct
SQL
> > in the DTML (ie displayed it within the page) and I've copied and pasted
> > that SQL directly into a ZSQL Method and ran it on my database and that
> > works fine.  However it seems to do absolutly nothing when I actually
> > attempt to run everything together and call UpdateHours from the DTML
> > document.  I've played a little with namespace as well, but as I said,
I'm
> > new to all this so there may be an error there.
> >
> > Thanks for everyone's insight so far, it's really helpful, and please
keep
> > those suggestions coming! : )
> >
> > Mike Kelland
> > mike@studiomatic.com
> >
> > ----- Original Message -----
> > From: "Dgallion@rochester.rr.com" <darrell@dorb.com>
> > To: "Mike Kelland" <mike@studiomatic.com>; <zope@zope.org>
> > Sent: Wednesday, November 22, 2000 8:48 PM
> > Subject: Re: [Zope] Zope with Microsoft Access
> >
> >
> > > You may not be entering UpdateHours.
> > >
> > > Try <dtml-var "0/0"> just before the call to UpdateHours.
> > > Or some other obvious way to know if your entering it.
> > >
> > > Here's how I coded the same kind of thing.
> > > Although I'm reading the Zope book right now to see how I should have
done
> > > it.
> > > The book is good and I might just learn a better solution than 0/0 :)
> > >
> > > --- Part of addContact
> > > <form action="insertNewContactForm" method="get">
> > > <table>
> > > <tr><td>Name:</td><td><input type="text" name="name" ></td></tr>
> > > <tr><td>Title:</td><td><input type="text" name="title"></td></tr>
> > > <tr><td>Phone:</td><td><input type="text" name="phone"></td></tr>
> > > </table>
> > > <table><tr>
> > > <td><input type="submit" name="cmd" value="Insert"></td>
> > > <td><input type="submit" name="cmd" value="Update"></td>
> > > <td><input type="submit" name="cmd" value="Delete"></td>
> > > <td><input type="submit" name="cmd" value="Clear"></td>
> > > </tr></table>
> > > </form>
> > >
> > > ---insertNewContactForm
> > > <dtml-if expr="_.len(name) > 0">
> > >  <dtml-if expr="cmd=='Insert'">
> > >    <dtml-var insertNewContact>
> > >  <dtml-elif expr="cmd=='Delete'">
> > >   <dtml-call deleteWhere>
> > >  <dtml-elif expr="cmd=='Update'">
> > >   <dtml-call updateWhere>
> > >  <dtml-elif expr="cmd=='Clear'">
> > >  </dtml-if>
> > > </dtml-if>
> > > <dtml-var "RESPONSE.redirect('addContact')">
> > >
> > > --Darrell
> > >
> > >
> > > _______________________________________________
> > > 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 )
> > >
> > >
> >
> >
> > _______________________________________________
> > 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 )
> >
>
>
>
> _______________________________________________
> 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 )
>
>