If ID_accesscf_chrisom is the DSN you(or GoDaddy) set up then yup. Ade
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 January 2006 17:01 To: CF-Newbie Subject: RE: Connection problem Do I use the whole thing? Eg.. <!---this is the main query to get info for all pages---> <cfquery name="page_info" datasource="ID_accesscf_chrisom"> select * from main where category = '#section#' AND page = '#page#' </cfquery> Dennis Sirois http://www.denauriewebs.com/ http://www.newenglandforyou.com/ http://www.themonetizejournal.com/ -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sunday, January 29, 2006 11:54 AM To: CF-Newbie Subject: RE: Connection problem Add your DSN to the query tag: <cfquery name="page_info" datasource="DSN GOES HERE"> select * from main where category = '#section#' AND page = '#page#' </cfquery> Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 January 2006 16:41 To: CF-Newbie Subject: Connection problem All pages connect to this file called query.cfm. I am hosting it at Godaddy with CF installed on domain www.chrisombrickandstone.com. I have been at it since friday and cant seem to figure it out. I think all I need is a connection string (but I could be wrong). Please help if you can. I am truly a CF newbie. I am using DSN with the host. <!---this is the main query to get info for all pages---> <cfquery name="page_info"> select * from main where category = '#section#' AND page = '#page#' </cfquery> Thanks, Dennis Sirois ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
