Hello Rich, what is
SELECT * FROM FOO. last... i created a recordset on my machine, and that is how i drag the 'field' onto the index.cfm file. but at godaddy, i haven't created a recordset, and how does the serever or the coldfusion at godaddy know what 'rs-christmas' is. or it just takes the name of the field (large_photo_source in my case), and puts it on the page. this is more confusing that i thought it would be. please understand that i am a hardcore biologist, venturing into the world of the computer geeks, and i am kinda lost! dan >Daniel, >You need to place the DSN string (Datasource name as defined in the CF >administrator by godaddy) in the CFQUERY tag (that you did not show in your >code sample). > >Ex: > ><cfquery name=" rs_christmas " datasource="DSN_STRING_HERE"> > SELECT * FROM FOO ></cfquery> > > >HTH, >Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
