Never mind, I figured it out... Just needed to use <dtml-var first> and <dtml-var second> instead of the <dtml-sqlvar first/second type=string> parts. Thanks, Jeff On Thu, 23 Mar 2000 jeffr@odeon.net wrote:
Heya folks,
I've got an SQL query that looks like the following:
select artists.hidden_URL,gigs.* from artists,gigs where artists.name=gigs.name and gigs.date >= "<dtml-call "REQUEST.set / ('CurrentDate',ZopeTime().Date())"> / <dtml-var "REQUEST.CurrentDate">" order by gigs.date, gigs.start_time
This works fine. The '/'s indicate that a single line continues, in the ZSQL method the 'and gigs.date >= etc." part is on one line.
I'd link to be able to change the values the query is ordered by based on the link used to access it. Something like the following:
http://foo.bar.com/Zope/query?first=date&second=start_time
Towards that end I made the above look like:
select artists.hidden_URL,gigs.* from artists,gigs where artists.name=gigs.name and gigs.date >= "<dtml-call "REQUEST.set / ('CurrentDate',ZopeTime().Date())"> / <dtml-var "REQUEST.CurrentDate">" order by gigs.<dtml-sqlvar first type=string>, / gigs.<dtml-sqlvar second type=string>
When I test the ZSQL method it shows the SQL used as:
select artists.hidden_URL,gigs.* from artists,gigs where artists.name=gigs.name and gigs.date >= "2000/03/23" order by gigs.'date', gigs.'start_time'
Note the 'date' and 'start_time'... Because of the 's the query does not work.
Is there a way to not have the <dtml-sqlvar> tag return the 's to MySQL, or is there another way I should be trying to do this?
Thanks for the help,
Jeff Robertson
_______________________________________________ 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 )