Glad you figured it out :-)
#set ($tmpVend_number = ${token.getcnnSG().queryValue("SELECT Vend_number FROM PRODUCTS WHERE Product_ID=${orderItem.getProductID()}")}) <rant> Now, CF code is not always pretty, but that line is ghastly IMHO. (Well, maybe you could mix in some dynamic javascript) </rant> ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------