Re: please help me with cfoutput

2003-07-06 Thread S . Isaac Dealey
> turns out to be an issue with access. thanks though! Glad I could help. :) s. isaac dealey972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi cer

Re: please help me with cfoutput

2003-07-05 Thread S . Isaac Dealey
I don't see anything in the code that would be causing it ... or rather should be... have you tried prior to the cfoutput just to be sure it's got everything you need and there aren't any typos? ... If the dump doesn't show the correct list of columns, then you may have driver issues or the lik

RE: please help me with cfoutput

2003-07-05 Thread Dave Watts
> ok... i tried both suggestions and am still getting the > same error: > > here is my new code: > > > SELECT * FROM price WHERE ID = (SELECT MAX(ID) FROM price) > > > ... > > and here is the error message: > Element REPVOL is undefined in CURRENT QUERY My guess is that you don't have a fie

RE: please help me with cfoutput

2003-07-05 Thread Mike Brunt
Kim, try this and see what happens: - #repVol #repIssue# #DateFormat(reportDate," d,")# Kind Regards - Mike Brunt Webapper Services LLC Web Site http://www.webapper.com Blog http://www.webapper.net Webapper -Original Message- From: Kim M. Inganamort [mailto:[EMAIL PROTE

Re: please help me with cfoutput

2003-07-05 Thread S . Isaac Dealey
I'm not sure about the message "repvol is undefined", however, simply having a cleaner query structure might help significantly in figuring out what's wrong if not solving your issue... give this a shot: SELECT * FROM price WHERE ID = (SELECT MAX(ID) FROM price) blah blah..