Very odd, page output going into sql statement

ztom27 · ztom27

Hi,

I have completely failed to come up with an explanation for this one. I have
a sql statement near the top of my page. The SQL is well-formed. About one
out of every 1000-2000 page views, I get this error in my logs:

Syntax error or access violation: You have an error in your SQL syntax near
'<html><head>'

But the <html><head> part of my page is 100 lines below the sql statement, so
I have no idea what it's doing in my sql statement. Somehow the page output is
getting mixed up and finding its way into my sql statement.

I repeat it's not a problem with the cfquery (at least not an obvious one),
because it works almost every time. Some further details:

Latest version of MX
Mysql 3
Linux
Using cfqueryparam

This happens in various queries on various pages, it seems random, however as
far as I can tell it ONLY happens when I implement onRequest in my
Application.cfc.

Any ideas for a workaround or fix would be much appreciated. (Removing
onRequest will be my last resort but it's legacy code so I'd rather not).

Dan Bracuk · Dan Bracuk

Does this query use any url, form, sesssion, etc variables? Unexpected values
with those are often the source of intermittent problems.

You could always wrap the query with cftry, and mail yourself some cfcatch
details to help you figure it out.

ztom27 · ztom27

Thanks for your response. It does use a url variable, but it's the same every
time and it's validated to be an integer. I think this problem has something
specifically to do with using onRequest because it never happened before. My
error page saves all the cfcatch info -- here's an example of what I find in my
exception.rootCause.sql in the error log:

select items.name from items where itemID = (param 1) and deletedflag = 0
<base href=" and paiduntil >= {ts '2006-04-08 12:22:17'}

The code causing this looks like:
<cfquery name="myquery" datasource="#request.dsn#">
select items.name from items
where
itemID = <cfqueryparam cfSQLtype="CF_SQL_INTEGER" value="#itemid#">
and deletedflag = 0
and paiduntil >= #CreateODBCDateTime(now())#
</cfquery>

(#itemID# is the url parameter)

Obviously the error is caused by the html code "base href" getting into my sql
statement, the problem is I didn't put it there. The "base href" code is a
hundred lines below the cfquery and is somehow sticking itself in the middle of
my query.

ztom27 · ztom27

The plot thickens....

It's not just sql statements. I just saw the "<html><head><base href=..."
code show up at the top of a page that didn't have any sql or even any html
tags. The only code in the file is:

<cfset tracker = createObject("java","coldfusion.runtime.SessionTra cker")>
<cfoutput><p>There are #tracker.getSessionCount()# active
sessions</p></cfoutput>

It happened a couple times, now I can't get it to repeat itself.

Very odd, page output going into sql statement

Thread Tools

Display

Very odd, page output going into sql statement

Similar Questions and Discussions

Output from different datasource in cfquery statement

Repeating output with cfif statement

Getting page output

SQL statement working in SQL Server but not in .aspx.cs page

Calling a html page from an asp page then returning to the next statement on the original asp page

Re: Very odd, page output going into sql statement

Re: Very odd, page output going into sql statement

Re: Very odd, page output going into sql statement

Posting Permissions