Skip to main content
R
Rusyt9073
Known Participant
August 16, 2007
Question

Help with Godaddy and Coldfusion

  • August 16, 2007
  • 7 replies
  • 907 views
Hi
With the help of people at this forum, I was able to successfully set up a searchable database with Coldfusion. I have now uploaded the file to my godaddy server and am having trouble getting it to work. The server is set up to do Coldfusion and I was able to create a DSN name for the access database (joeandmoe79_accesscf_wildlife).

However, when I serch for an item the results page shows up as a grey blank page (my background color for the page is gray). When I change anything code on the results page I get coldfusion error pages. Does someone have an idea of what I am doing wrong? Please help
Thank you
Rusty9073
This topic has been closed for replies.

7 replies

N
Newsgroup_User
Inspiring
August 18, 2007
the column name in your query on the results page should now have no " "
around it !!! just TITLE, not "TITLE"
--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
R
Rusyt9073Author
Known Participant
August 18, 2007
Hi

Azadi.... YOU WERE RIGHT!!! Removing the quotes around "TITLE" solved the problem. The quotes didn't affect the query when I tested the code locally, but it was the problem on the Godaddy Server. Now it is working perfectly!!!! Thank you SO MUCH for your help :)

Rusty9073
R
Rusyt9073Author
Known Participant
August 18, 2007
Hi

I changed the column in my database from DESC to TITLE. Unfortunately I still do not get any queries. I talked to a web developer at Godaddy and he says there appear to be no server issues. For some reason, the query is still not showing any results. Could it be something wrong with the search code? Please help
Rusty9073
tclaremont
tclaremont
Inspiring
August 17, 2007
Definately change the name of the DESC column in your Access database. While there are ways to implement an alias in your query writing, this is going to become a hassle for the remainder of the project unless you change it now.
tclaremont
tclaremont
Inspiring
August 16, 2007
Put #joeandmoe79_accesscf_wildlife.RecordCount# after your query (or just do a CFDUMP) to see if anything is being returned at all.

What do you see when you do a view source on the blank grey page?
R
Rusyt9073Author
Known Participant
August 17, 2007
Hi

Thank you for the responses. I added:
<cfdump var="#joeandmoe79_accesscf_wildlife#">

to my code. I then typed "cat" into my search box and hit enter. Now I get a blank gray screen with the following purple table:

---------------------------------------
| query - Top 0 of 0 rows |
----------------------------------------
| | EXPR1000 | IMAGE | LINK |
----------------------------------------

"IMAGE" and "LINK" are on columns in my access database... I don't know where "EXPR1000" is coming from

When I test the search locally and type the word "cat" ... the search works perfectly and displays several results. Can you tell what might be wrong?

Thank you,

Nate


N
Newsgroup_User
Inspiring
August 16, 2007
oops, somehow managed to post an uncomplete reply...

the cfdump should actually be:
<cfdump var="#joeandmoe79_accesscf_wildlife#">

another suggestion: do yourself a favour and rename your db field "DESC"
to at least DESCRIPTION. DESC is a reserved word in MS Access and
should not be used as field/column name... but if you do have a field
named DESC (or using any other reserved word), surround it with [ ] in
your queries, like [DESC]

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
N
Newsgroup_User
Inspiring
August 16, 2007
> one mistake you've made is sign up for a GoDaddy CF hosting...
>
I'm serious and I was going to say the same thing. GD is
known for people having CF problems.

Shouldn't make much of a difference but this
should not be on two lines:

<form name="form1" method="get"
action=" http://www.tshirttitan.com/results3.cfm">

Should be: <form name="form1" method="get"
action=" http://www.tshirttitan.com/results3.cfm">


N
Newsgroup_User
Inspiring
August 16, 2007
one mistake you've made is sign up for a GoDaddy CF hosting...

but seriously:
my guess is your query does not return any results. why it does not
return anything is another question...

to test, in your action page add
<cfdum var="##">
right after </cfquery> to see what what the query returns

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices