Re: [Zope] Unquoting a string.
Hi, Yes, I had tried that, but, I had some little a syntax problem that was causing zope to throw an error, and I thought it was because it didn't like the use of dtml-var in an sql call. From the advice here, and in a second response, I looked more closely at the error message and discovered the syntax error. : ( Thanks for helping out here. ciao! greg. Gregory Haley venaca.com > > Greg, > > Have you tried using just instead of ? The > sqlvar version I think automatically adds the quotation marks. > > --Aaron Williamson ___ 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] Unquoting a string.
just use To: Zope <[EMAIL PROTECTED]> Sent: Friday, July 07, 2000 10:36 AM Subject: [Zope] Unquoting a string. Hi, I am trying to pass a column id through a ZMySQL method call. The thing looks like this: UPDATE venapoll SET = last_insert_id(+1) WHERE poll_num = 3; where resp is a value passed in by a dtml method and can have the value of resp0, resp1, resp3, etc. These are the names of columns. Zope is blowing chuncks, because the parsed call is actually: SET 'resp1' = last_insert_id(+1) and ZMySQL needs to have the value passed in as SET resp1 = . . . (i.e., without the quotes). Has anyone had a problem with this? TIA. ciao! greg. Gregory Haley venaca.com ___ 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 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] Unquoting a string.
dtml-sqlvar does quoting of strings to aid in placing them in SQL queries. Use just instead of ___ Ron Bickers Logic Etc, Inc. [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gregory Haley > Sent: Friday, July 07, 2000 11:36 AM > To: Zope > Subject: [Zope] Unquoting a string. > > > Hi, > > I am trying to pass a column id through a ZMySQL method > call. The thing looks like this: > > UPDATE venapoll > SET = last_insert_id(+1) > WHERE poll_num = 3; > > where resp is a value passed in by a dtml method and can > have the value of resp0, resp1, resp3, etc. These are the > names of columns. Zope is blowing chuncks, because the > parsed call is actually: > > SET 'resp1' = last_insert_id(+1) > > and ZMySQL needs to have the value passed in as > > SET resp1 = . . . > > (i.e., without the quotes). > > Has anyone had a problem with this? ___ 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 )