One suggestion though, try using the CFQUERYPARAM tag with your queries. It helps avoid some syntax errors and offers better speed and security.
HTH! Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider J.B. Mentzer wrote: > Hi list, > > This query, called as a custom tag, caused an internal server error > (yellow band). I tried relocating the tag's file to the named custom tag > directory. No change. > > <cfquery datasource="#SESSION.dsn#" name="CALLER.gm_parts"> > SELECT * FROM parts > > WHERE > product_line = '#SESSION.product_line#' > > ORDER BY #ATTRIBUTES.order_by# > </cfquery> > > > > Thank you, > > * JB * > > > > > > > --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
