Re: [Zope] SQL method: Trying to be too clever?

2000-06-30 Thread Andy Gates

Message-ID: <[EMAIL PROTECTED]>
Priority: NORMAL
X-Mailer: Execmail for Win32 5.1 Build (9) 
MIME-Version: 1.0
Content-Type: Text/Plain; charset="us-ascii"

> > in that case you just want a  (you not passing it as sql
> > query values)

Perfecto.  That's two today.  My turn to get the beers.

AndyG

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] SQL method: Trying to be too clever?

2000-06-30 Thread Chris Withers

Andy,

An error message / traceback would be useful ;-)

Rik Hoekstra wrote:
> >insert into related (rootstory, )
> 
> in that case you just want a  (you not passing it as sql
> query values)

Nope, the  is for quoting use in SQL statements,
kindof like  which I think may be even be
correct syntax...

cheers,

Chris

___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] SQL method: Trying to be too clever?

2000-06-30 Thread Rik Hoekstra





>Is it possible to pass a variable into anything other than the values
>of a SQL method?  I'm trying to pass a parameter to a method, such that
>the param is used to define which field is affected by the action:


The only thing is you'll have to define the param in your sql method
definition. In this case this would be field, besides storytitle and value.

>
>insert into related (rootstory, )

in that case you just want a  (you not passing it as sql
query values)

>values (,
>)
>
>Possible?  This doesn't work, of course...
>

hth

Rik


___
Zope maillist  -  [EMAIL PROTECTED]
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] SQL method: Trying to be too clever?

2000-06-30 Thread Andy Gates

Is it possible to pass a variable into anything other than the values 
of a SQL method?  I'm trying to pass a parameter to a method, such that
the param is used to define which field is affected by the action:

insert into related (rootstory, )
values (,
)

Possible?  This doesn't work, of course...
--
Andy Gates, Learning and Research Technology
[EMAIL PROTECTED] - ICQ#74362415


___
Zope maillist  -  [EMAIL PROTECTED]
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 )