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:1628
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
