Fw: [Zope] Python Script

[Jonathan Miles]

----- Original Message -----
From: "Jonathan Miles" <jonathan.miles@btconnect.com>
To: "Dieter Maurer" <dieter@handshake.de>
Sent: Thursday, January 16, 2003 11:05 PM
Subject: Re: [Zope] Python Script


> Thanks for your prompt help the web application is fixed.
>
> simple example
>
> RecordSet = Context.SqlMethod(Param1 = request.ID)
>
> if RecordSet:
>     return context.REQUEST.RESPONSE.redirect("%s?message=%s %
> (context.REQUEST.URL1,"Sorry Record Locked By ' " + RecordSet[0].FieldName
+
> " ' ! "))
>
> ...
>
> You are quite correct the key point is the [0] when that is missing you
get
> an attribute not found error.
>
> Also the other points on the if statement is quite true.
>
> The main issue was to learn who to get at the fields in the record set.
> The previous code was one of several were this messaging is used.
>
> Thank again all.
>
> ----- Original Message -----
> From: "Dieter Maurer" <dieter@handshake.de>
> To: "Jonathan Miles" <info@jonathan-miles.com>
> Cc: <zope@zope.org>
> Sent: Thursday, January 16, 2003 8:46 PM
> Subject: Re: [Zope] Python Script
>
>
> > Jonathan Miles wrote at 2003-1-16 00:21 -0000:
> >  > Can someone help me with this.
> >  >
> >  > I just want to run the salescheck sql method and use a field
> 'OFFICENAME' in
> >  > the result set in the message.
> >  >
> >  > It is a simple task and it's been bugging me far to long.
> >  >
> >  > Thank for your help.
> >  >
> >  >
> >  > orderrecordok = context.salescheck(locationid = request.LOCID, RECID
=
> >  > request.ID)
> >  >
> >  > if not orderrecordok:
> >  >
> >  >    return context.REQUEST.RESPONSE.redirect("%s?message=%s" %
> >  > (context.REQUEST.URL1,' Sorry the Order ' + salescheck.OFFICENAME + '
> is not
> >  > yours'))
> > Apparently, when you run "salescheck", it returns an empty result
> > set.
> > Of course, you cannot access a field in an empty result set.
> >
> > If you have a non-empty result set "R", then "R[i]" is the i-th
> > result row (0-based) and "R[i].OFFICENAME" would give you
> > the "OFFICENAME" field of this row.
> >
> >
> > Dieter
>