RE: [Zope] Double quote in ZSQL Method

2006-02-21 Thread Jaroslav Lukesh
> Jason C. Leach > In a ZSQL Method, I have tablename. > and I get tablename.'species_value', what I need is > tablename."species_value". Any idea how I can get Zope/ZSQL to not > put in the single quotes (or use double quotes)? JL. ___ Zope maillist

Re: [Zope] Double quote in ZSQL Method

2006-02-21 Thread Andrew Milton
+---[ Chris Withers ]-- | Andrew Milton wrote: | >| In a ZSQL Method, I have tablename. | >| and I get tablename.'species_value', what I need is | >| tablename."species_value". Any idea how I can get Zope/ZSQL to not | >| put in the single quotes (or use double quotes)? | >

Re: [Zope] Double quote in ZSQL Method

2006-02-21 Thread Chris Withers
Andrew Milton wrote: | In a ZSQL Method, I have tablename. | and I get tablename.'species_value', what I need is | tablename."species_value". Any idea how I can get Zope/ZSQL to not | put in the single quotes (or use double quotes)? | tablename. Don't use sqlvar except for things you want qu

Re: [Zope] Double quote in ZSQL Method

2006-02-20 Thread Andrew Milton
+---[ Jason C. Leach ]-- | Hi, | | In a ZSQL Method, I have tablename. | and I get tablename.'species_value', what I need is | tablename."species_value". Any idea how I can get Zope/ZSQL to not | put in the single quotes (or use double quotes)? | tablename. Don't use sq

Re: [Zope] Double quote in ZSQL Method

2006-02-20 Thread jpenny
tablename. should work. Be sure that you check that species is valid before this call. sql_quote should protect you from SQL injection, but it is better to be safe. jim [EMAIL PROTECTED] wrote on 02/20/2006 05:46:49 PM: > Hi, > > In a ZSQL Method, I have tablename. > and I get tablename.'sp

[Zope] Double quote in ZSQL Method

2006-02-20 Thread Jason C. Leach
Hi, In a ZSQL Method, I have tablename. and I get tablename.'species_value', what I need is tablename."species_value". Any idea how I can get Zope/ZSQL to not put in the single quotes (or use double quotes)? Thanks, Jason. -- Jason C. Leach PGP