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

please help me with cfoutput

2003-07-06 Thread Kim Inganamort
turns out to be an issue with access. thanks though! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.t

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

please help me with cfoutput

2003-07-05 Thread Kim Inganamort
also getting "Variable REPVOL is undefined" when i use my queries and throw ouput around tr tags ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm

please help me with cfoutput

2003-07-05 Thread Kim Inganamort
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)

RE: please help me with cfoutput

2003-07-05 Thread Mike Brunt
lto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 5:32 PM To: CF-Talk Subject: please help me with cfoutput Below is an exerpt of my code that is applicable. Whats weird is that the first cfoutput gives me an error, "repvol is undefined", and the second cfoutput works (of course I have to

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..

please help me with cfoutput

2003-07-05 Thread Kim M. Inganamort
Below is an exerpt of my code that is applicable. Whats weird is that the first cfoutput gives me an error, "repvol is undefined", and the second cfoutput works (of course I have to rid the first one to see so that it will process the second). Both are working valid fields in my db. I don't underst