bjv211
asked on
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
Looks like you're using the variable incorrectly in the code, can you post the code where the error happens
ASKER
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")) >
<!--- Set curruser in session --->
<cfset session.curruser = URL.user>
<!---Create CalDate to check --->
<cfset checkforcalendartodaysDate
<cfquery datasource="#application.dsn#" name="checkforcalendar">
SELECT * FROM #session.curruser#dates WHERE #session.curruser#date >= #checkforcalendartodaysDate#
</cfquery>
Do you have a database table with this name?
jag336dates
jag336dates
ASKER
yes, with 1 col : jag336date
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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'}