CF 8 Logging Error 1811

I'm using CF 8 and MS Access for an applicaton.  Occasionally I receive the attached error in one of my applications.  The error only occurs when a one particular user's ID is passed in the URL params.  The url param passed is user=jag336. Any ideas?
ErrorCode-1811 
Message[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\ColdFusion8\db\slserver54\logging\jag336.mdb'. 
SQLStateHY000

Open in new window

LVL 1
bjv211Asked:
Who is Participating?
 
gdemariaCommented:
hmmm, can you pull the query from the debug output (so you have it exactly as executed) and run it directly in your database?  

This will help test to see if it's associated with the database or how coldfusion is processing it..
0
 
gdemariaCommented:
Looks like you're using the variable incorrectly in the code, can you post the code where the error happens
0
 
bjv211Author Commented:
Attached is the line indicated in the error log.  Also, this is the setup for the variables used in that line.

<!--- Set curruser in session --->
<cfset session.curruser = URL.user>

<!---Create CalDate to check --->
<cfset checkforcalendartodaysDate = CreateODBCDate(DateFormat(NOW(),"MM/DD/YYYY"))>

<cfquery datasource="#application.dsn#" name="checkforcalendar">
SELECT * FROM #session.curruser#dates WHERE #session.curruser#date >= #checkforcalendartodaysDate#
</cfquery>

Open in new window

0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
gdemariaCommented:
Do you have a database table with this name?

  jag336dates
0
 
bjv211Author Commented:
yes, with 1 col : jag336date
0
 
bjv211Author Commented:
Good idea, as soon as I found the query I was able to realize and replicate the error.  The error occurs when users input a period after the url variable.  Now I need to first trim out that period and then track down if any links are mistyped causing the error. Thank you!

SELECT * FROM jag336.dates WHERE jag336.date >= {d '2008-10-11'}

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.