RE: Db query question

Hi Peter Something like this should do the trick cfquery name=select datasource=testdb dbtype=ODBC select f.LONG_NAME, n.VALUE, n.NUTRIENT from NIP_FOOD f, NIP_Nutrient n where f.id = '01A10014' /cfquery Then just output the query as normal (without the aliases) HTH Mark Mark Smyth

RE: Db query question

I got it. My problem is, well here goes: a) - ColdFusion 5 (buy the Enterprise version for the smarts that Macromedia fooled us about, eg: app archiving) b) = NT Workstation 4 c) - 64Mb RAM d) - 130Mb Access db P.S. - God I love caching! P.S.S. - Beer is right at the top of the database as