Error Occurred While Processing Request

yohooo8 · yohooo8

Hi, i am new to coldfusion and i was building my first Access database into my
website as instructed on the macromedia web.

When i preview the page, the follow error is poped up instead of the tables,
can you help?

================================================== ==============================
=
Error Occurred While Processing Request
Invalid CFML construct found on line 21 at column 29.
ColdFusion was looking at the following text:
ID

The CFML compiler was processing:

An expression that began on line 21, column 11.
Your expression might be missing an ending "#" (it might look like #expr ).
The body of a cfoutput tag beginning on line 19, column 4.

Please try the following:
Enable Robust Exception Information to provide greater detail about the source
of errors. In the Administrator, click Debugging & Logging > Debugging
Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)
Remote Address 127.0.0.1
Referrer
Date/Time 15-Apr-05 03:51 PM

================================================== ============================

Kronin555 · Kronin555

In order for anyone to help you, you need to post your code.

jjcuzz · jjcuzz

hello, you need to put a "#" at the end of your var

you probably have #ID when you need to have #ID#

yohooo8 · yohooo8

Here is the code.

<cfquery name="contacts" datasource="Access">
SELECT * FROM Contact
</cfquery>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table border="1">
<tr>
<td>Contact ID</td>
<td>Contact Name</td>
<td>Contact Email address</td>
<td>Contact Cell #</td>
<td>Contact Birthday</td>
</tr>
<cfoutput query="contacts">
<tr>
<td>#contacts.Contact ID#</td>
<td>#contacts.Contact Name#</td>
<td>#contacts.Contact Email address#</td>
<td>#contacts.Contact Cell ##</td>
<td>#contacts.Contact Birthday#</td>
</tr>
</cfoutput>
</table>

</body>
</html>

Stressed_Simon · Stressed_Simon

OK this is really simple to diagnose, however it might not be so simple for you
to fix.

The reason why this is causing problems is that you cannot have spaces in your
variable names. However these are coming out of your databse, so you need to
rename your database field names so that they do not have spaces in. I hope for
yor sake that this wont be a problem as there is no way it'll work otherwise!

Stressed_Simon · Stressed_Simon

Also, you cannot have reserved characters in your field names either so you will have to take the # out of the 'Contact Cell #' field!

Kronin555 · Kronin555

Coldfusion doesn't allow spaces in variable names.

#contacts.Contact ID#

What does your Contact table look like in Access? What are the columns named? That's what you should use.

yohooo8 · yohooo8

I have renamed all the table names and it's working now. Thank you.

big-dog-K · big-dog-K

Database works great - but when i am uploading a new NEWS database file for the
web server - anyone who trys to access the database is given an "Error
Executing Database Query. " error page. I tried placing a file called
errorhandler.html in the JRUN file inside the website folder under the
"cf_root\runtime\lib\wsconfig\ directory" but this is not spawned when the
error occurs because the web server CAN communicate with CF.... Cold fusion
just sees that the file is not available - QUESTION: Is there a way to have CF
display a custom webpage just for this particular website in this case? I am
using IIS 6.0 (WIN2003) with CFMX 6.1

I don't want to change the GLOBAL results for this - only for the single
website.

Thanks - Kevin

OldCFer · OldCFer

Can't you just use the cferror tag in the Application.cfm for that site to direct them
to the HTML error page you want displayed?

The ScareCrow · The ScareCrow

I would have an application variable to indicate if the db is being uploaded
(Yes/No)
In any page that interacts with this db include some code at the top of the
page to check this application variable.
If it's Yes, then redirect to a page that indicates the db is being updated
and should be ready soon.
If no the proceed with the page.
Then have an admin page that does the actual upload of the db file. At the
top of this page set the application variable to indicate the db file is being
uploaded, then have your code to upload, then after the upload rest the
variable to indicate that the db file is ready again.

Ken

big-dog-K · big-dog-K

Thanks a lot Larry,

I had not realized this was possible - i am a real newby at this point...
could you please show me the simple snippet of code this requires?? I am
trying to direct to a file called errorhandler.html in the same directory as
the application.cfm file... I was looking around on the LiveDocs but could not
find an example of the syntax on the command - I am presently on business in
Australia and do not have the references with me... thanks a lot for the help
amigo !

Kevin
Dallas, TX

big-dog-K · big-dog-K

Thanks Ken, could you give me an example of this code snippet ? I am a newby
and cannot seem to find an example of this for my application.cfm file... the
file i would like to direct to if the database is not available is
ErrorHandler.html

Thanks for hte help,

Kevin
Dallas, TX

The ScareCrow · The ScareCrow

Kevin,
Where in Australia are you, I'm in Sydney

Basically you would have at the top of each page

<cfif Application.dbAvailable Is "No">
<cflocation url="ErrorHandler.html">
</cfif>

In the action page that would upload the db file
<cfset Application.dbAvailable = "No">

Then the code to do the actual file upload

Then,
<cfset Application.dbAvailable = "Yes">

Ken

big-dog-K · big-dog-K

WOW, that is pretty cool... I can't wait to try it out.... Is the location
statement a relative path?? All of the HTML and CFM files are not in the same
directory.... I can place the statements in the sitewide template that I am
using and place the last bit in the Application.cfm file for the database....
the database is accessed at:
[url]http://www.dallascrimewatch.org/News_Database/news.cfm[/url]

This is my first database and it is working out pretty good i think - has been
a lot of fun to put together and a great learning expereience...

I am 600 km West of Brisbane right now about 2 hours drive West of Roma... I
am a drilling engineer and drilling a horizontal coal bed methane well in the
outback for a company in Brisbane... I spent 3 weeks in Brisbane last month -
brilliant city... I also spent a weekend in Adelaide and spent a day in the
Barossa Wine valley - had a blast..... I spent a long weekend in Sydney about
10 years ago when i lived in Perth for about 5 months so i have seen Sydney
briefly - i loved the Taronga Zoo...

Ken, i really appreciate the help... this little experiment has given me a bug
for this - the Crime Watch people in Dallas were amazed at the advancement of
the website after i bought Cold Fusion and put it up on the server... i went
from 2000 visitors a month to 6,000 since i upgraded the website - it has been
very successful so far - if you have any ideas when you look at it - they would
be most appreciated...

Kevin
Dallas, TX
(presently in OZ)
:-)

The ScareCrow · The ScareCrow

Kevin,
The cflocation tag. The url attribute can be a url or a relative url.

I have had a look at the site, very nice.

A coupe of suggestions
I would give all the links a visual effect, that is when the user mouses over
they change color. Just makes it a bit easir for th user to know the piece of
text does something.
On the news page.
While the search works well and I don't know the user group. I would allow
the user to also search by all 3 (or part of) categories. This would require
taking out the onchange event for the select lists and include a search button.
I would also limit the number of news items displayed on the page. This page
could become very long which would require a lot of scrolling.
Again with the news items I would give a visual effect on the mouse over.
I'm a bit confused about the select list of "choose topic". Is there a reason
these a not part of the menu ?

I'm glad you have enjoyed Australia. Don't work to hard in the Queensland
outback. At least this time of year it won't get to hot out there.

Ken

big-dog-K · big-dog-K

That's a great idea on the mousover effects - i will work on that - I am sure
that CF will allow me to do that - honestly, all that is a little overwhelming
at this point - i am still not exactly sure about the last statements - i have
printed them out and reading but nt sure about "the action page that loads the
db file".... my files that go to the selected topics are:
news.cfm
news_Latest.cfm
news_request.cfm
news_search_crime.cfm
news_search_crimewatch.cfm
news_search_neighborhood.cfm

I think if i read this right, I would place all the code in each of these
pages, well, not the news.cfm page (only the first part there, the second part
with the cfset command would go in each of the other pages as well as the first
part to make this work properly...??? Correct ? I haven't played with this
real-time yet because my connection is a telstra cell phone out here - i want
to have this better understoof before uploading the files in case i have
problems - i could easily make the db unavailable to everyone and not be able
to straighten it out very quickly....etc.... my CF experience is limited to the
most basic default setups - this database i created for our crime watch group
is probably not efficiently designed or thoughtout - i am sure of that but i am
just trying to get something more slick up for our group - the Dallas Police
Department has even become interested in the site and has asked questions-- the
db thing is powerful ! At any rate, i was wondering if you could be more
specific in your explination of where the code goes and why.... i really
appreciate the time your giving me.

It is nice out here in QLD... I have been here since Jan 12th and it was up to
45 C back in those days so i know what you mean about the heat - also the flies
were pretty feirce here... like dive bombers... if your interested, i would
send you some pics of this area when i get to a high speed connection - saw my
first big red kangaroo yesterday too.... LOL

thanks again.

Kevin

The ScareCrow · The ScareCrow

Okay, I know this can be overwhelming at first.

The following code should be place at the top of any page that interacts with
the db. In this case any page that has a cfquery in it. This code would then
be executed before any code that interacts with the db. Thus if the db is off
line then the error page will be shown and the db would not be queried.
<cfif Application.dbAvailable Is "No">
<cflocation url="ErrorHandler.html">
</cfif>

The second part would be in an "admin" page. I would assume that at present
you just use a ftp connection to upload the new db. What I suggest is that you
use a cfm page to upload the db. This then sets the variables to put the db
off line and on line.

For the mouse over effect of the links. I would assume that you would want
them all the same, so you should use CSS. This way you only need to include it
in the CSS and do not have to go through the pages and make changes.

Without knowing what data you want to store in the db. I assume it is just
the news data ? So I will give an example of this

Table 1 -- Crimes
Crime_Id
Crime_Desc

Table 2 -- Neighborhood
Neighborhood_Id
Neighborhood_Desc

Table 3 -- Crime_Watch
Crime_Watch_Id
Crime_Watch_Desc

Table 4 -- News_Events
News_Event_Id
Crime_Id
Neighborhood_Id
Crime_Watch_Id
News_Event_Desc

Yes, the flies in Australia can be very nemorous and they can bite. Vicious
little buggers.
Don't trust the Kangaroos, they will attack and can do major damage.

Ken

big-dog-K · big-dog-K

OK, that's a lot of info but i am copying all your comments into a word file
and taking them one at a time.... yes, i do use FTP to upload the MDB file but
i actually have had the admin page idea already - and it works ok but not great
- i have used it successfully but i find it easier to manipulate the mdb file
directly and it doesn't take too long to upload it with ftp but the problem was
that the page that CF displayes was giving entirely too much away on these
pages - i used the administrator to restrict the amount of information it
displayed to the point that it does not tell people what the db name is and
such things - the page i would like to display for the entire website for any
problem at all would be at:
[url]http://www.dallascrimewatch.org/News_Database/errorhandler.html[/url]

Man, what i wouldn't give to actually sit down at a keyboard for a few hours
with someone like you - the db for crime watch is the only custom code i have
ever written - to be perfectly honest, i would have a hard time replicating the
process again although it would come to me faster this time... it almost seemed
like i created the whole thing by mistake - LOL - i am simply amazed that it
all works so smoothly...
:-)

I will try the CSS file for a slightly different color on the mouse-over and
probably make them bold too ?? That is a good idea... but i guess that will
affect the news stories that are chosen which are generated by the CF cfquery
statements ?? I am assuming yes because of the way you presented it.

I would give you the files to see the data calls if you were interested.... So
i gave you my e-mail address below if you are willing to look at them..

[email]Kevin@Ward-Drilling.com[/email]
[url]www.Ward-Drilling.com[/url]

jjbonpar · jjbonpar

I?m working with the Tutorial and I can?t preview as I?m going on because I
always receive the following error:

Error Occurred While Processing Request
Element LOCALE is undefined in REQUEST.

The error occurred in
C:\CFusionMX7\wwwroot\CFIDE\gettingstarted\Applica tion.cfm: line 1

1 : <cfif request.locale neq "jp" and request.locale neq "ja">
2 : <cfset request.locale = "en">
3 : </cfif>

Could somebody help me please!

Error Occurred While Processing Request

Thread Tools

Display