Help with Godaddy and Coldfusion

[Rusyt9073]

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

[Newsgroup_User]

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

[Newsgroup_User]

> 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">

[Newsgroup_User]

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

[tclaremont]

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?

[Rusyt9073]

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

[Newsgroup_User]

as you can see from the dump, your query did not return any records at
all...

what's wrong? my guess is the name of your "DESC" column...

rename your column called "DESC" to something else which is not a
reserved word in ms access.

or at least surround it with [ ] in the queries instead of with " ",
which, i believe, is not a truly valid sql, just an ms access
implementation of it...

--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com

[tclaremont]

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.

[Rusyt9073]

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

[Newsgroup_User]

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

[Rusyt9073]

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