GoDaddy Coldfusion FRUSTRATION

guzmanistan

Weaksauce
Joined
Jun 3, 2005
Messages
92
I've got a website up at godaddy.com HERE using coldfusion, but I'm having a hell of atime getting it to work. I finally figured out how to test it on my computer, now i can't figure out how to get it online. I'm using an mdb file and did the Access DNS thing, but I have no i idea with what to do with it.
a)what do i put in the top cfm code?
<cfquery name="q_schedule" datasource="juanandonly_accesscf_db">
SELECT *
FROM schedule
ORDER BY ID ASC
</cfquery>
That's what it looks like rightnow. The datasource stuff is what Godaddy told me.
b)I put my access files in the access_db folder, thats where its supposed to go right?

Help is GREATLY appreciated. thanks.
 
<cfquery name="q_schedule" datasource="juanandonly_accesscf_db">
SELECT *
FROM schedule
ORDER BY ID ASC
</cfquery>

<!--Now you need to output --->

<cfoutput query="q_schedule">
<p><strong>First Name:</strong>#q_schedule.first_name#</p>
</cfoutput>

==#(queryname).(column name) #
I should note since your using access you might be okay but with sql you need to use a <queryparam> or a stored procedure to prevent sql injection attacks on you Db.
Hope that helps
 
Back
Top