> dontchya have to set up the connection string somewheres? yeah, in the cfquery tag, i omitted that, my bad <cfquery name="query_name" datasource="ds_name"> sql goes here </cfquery> i do tend to oversimplify at times, sorry ;o) rudy