What is wrong with this?

Jerkycold · Jul 9, 2003

I cannot figure out what is wrong with this code:

<cfquery
datasource="#peregrine#"
name="getdomains">


SELECT DISTINCTROW applicationorders.Domain, applicationorders.userid
FROM applicationorders
where applicationorders.userid = #session.userid#
GROUP BY applicationorders.Domain, applicationorders.userid
</cfquery>

<cfelse>

<cfquery
datasource="peregrine"
name="getdomains">

select DISTINCT domain
FROM applicationorders
</cfquery>

<cfquery
datasource="peregrine"
name="getusers">
SELECT DISTINCT applicationorders.userid, users.UserLastName, users.UserFirstName
FROM applicationorders LEFT JOIN users ON applicationorders.userid = users.UserID
WHERE ((Not (applicationorders.userid)=0))
order by users.userlastname, users.userfirstname
</cfquery>

<cfquery
datasource="peregrine"
name="getstates">

select *
from states

</cfquery>

</cfif>

<cfquery
datasource="peregrine"
name="getstatus">

select *
FROM applicationstatus
order by statusid

</cfquery>

<cfquery
datasource="peregrine"
name="getat">

select *
FROM applicationtypes

</cfquery>




<b class="header">Generate Report</b><br>



<form action="appn-report.cfm" method="post">
<input type=Hidden name="flag" value="1">
<table border=0 cellpadding=4 cellspacing=0 width=100%>

<tr>
<td class=smallbold align="right">Domain</td>
<td class=small>
<select name="domain">
<option value="">--- All Domains ---
<cfoutput query="getdomains">
<option value="#domain#">#domain#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Agent</td>
<td class=small>
<select name="userid1">
<option value="">--- All Agents ---
<cfoutput query="getusers">
<option value="#userid#">#userlastname#, #userfirstname#
</cfoutput>
</select>
</td>
</tr>

<tr >
<td class="smallbold" align=right>State</td>
<td class="small">
<select name="state">
<option value="">--- All ---
<cfoutput query="getstates">
<option value="#state#">#state#
</cfoutput>
</select>
</td>
</tr>

</cfif>
<tr>
<td class=smallbold align="right">Time Frame</td>
<td class=small>
<select name="timeframe">
<option value="">--- All ---
<option value="TD">today
<option value="LW">last 7 days
<option value="CM">current month
<option value="LM">last month
<option value="CY">current year
<option value="LY">last year
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Type</td>
<td class=small>
<select name="applicationtypeid">
<option value="">--- All Types ---
<cfoutput query="getat">
<option value="#applicationtypeid#">#applicationtype#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">VVC Status</td>
<td class=small>
<select name="vvcstatusid">
<option value="">--- All Status ---
<cfoutput query="getvvcstatus">
<option value="#vvcstatusid#">#vvcstatus#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Status</td>
<td class=small>
<select name="statusid">
<option value="">--- All Status ---
<cfoutput query="getstatus">
<option value="#statusid#">#status#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Credit</td>
<td class=small>
<select name="ratecredit">
<option value="">--- All ---
<option value="Good">Good
<option value="Fair">Fair
<option value="Poor">Poor
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">From (m/d/yy)</td>
<td class=small>
<input type="text" name="from" size=10 value="">
</td>
</tr>

<tr>
<td class=smallbold align="right">To (m/d/yy)</td>
<td class=small>
<input type="text" name="to" size=10 value="">
</td>
</tr>

<tr>
<td class=smallbold align="center"> </td>
<td class=smallbold>
<input type="submit" value="Generate Report">
</td>
</tr>

</table>
</form>

<p>

Everytime I try to view it in my browser i get this error:

Error Diagnostic Information
Template file not found.

HTTP/1.0 404 Object Not Found
Note: If you wish to use an absolute template path (e.g. TEMPLATE="/mypath/index.cfm&quot

with CFINCLUDE then you must create a mapping for the path using the ColdFusion Administrator.

Using relative paths (e.g. TEMPLATE="index.cfm" or TEMPLATE="../index.cfm&quot

does not require the creation of any special mappings. It is therefore recommended that you use relative paths with CFINCLUDE whenever possible.

The error occurred while processing an element with a general identifier of (CFINCLUDE), occupying document position (4:1) to (4:56).

Date/Time: 07/09/03 14:31:33
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address: 192.168.254.48
Template: C:\Inetpub\

http://wwwroot\Intranet\application\app_form.cfm

The funny thing is I have no cfinclude in this code!!!

csteinhilber · Jul 9, 2003

The "occupying document position (4:1) to (4:56)" is the clue.

Position (4:1) to (4:56) means it's finding the problem between the first and fifty-sixth character of line 4.

I'm guessing you didn't include line 4 in the code above... because you started in the middle of a

Code:

<CFIF>

block.

Show us the very beginning of the file (lines 1 through 10, at most), and it will be more helpful.

-Carl

Jerkycold · Jul 9, 2003

here is everything starting from line one, sorry about that:

<cfif session.usertypeid is not "0"> This is line 1

<cfquery
datasource="#peregrine#" This is line 4
name="getdomains">


SELECT DISTINCTROW applicationorders.Domain, applicationorders.userid
FROM applicationorders
where applicationorders.userid = #session.userid#
GROUP BY applicationorders.Domain, applicationorders.userid
</cfquery>

<cfelse>

<cfquery
datasource="peregrine"
name="getdomains">

select DISTINCT domain
FROM applicationorders
</cfquery>

<cfquery
datasource="peregrine"
name="getusers">
SELECT DISTINCT applicationorders.userid, users.UserLastName, users.UserFirstName
FROM applicationorders LEFT JOIN users ON applicationorders.userid = users.UserID
WHERE ((Not (applicationorders.userid)=0))
order by users.userlastname, users.userfirstname
</cfquery>

<cfquery
datasource="peregrine"
name="getstates">

select *
from states

</cfquery>

</cfif>

<cfquery
datasource="peregrine"
name="getstatus">

select *
FROM applicationstatus
order by statusid

</cfquery>

<cfquery
datasource="peregrine"
name="getat">

select *
FROM applicationtypes

</cfquery>




<b class="header">Generate Report</b><br>



<form action="appn-report.cfm" method="post">
<input type=Hidden name="flag" value="1">
<table border=0 cellpadding=4 cellspacing=0 width=100%>

<tr>
<td class=smallbold align="right">Domain</td>
<td class=small>
<select name="domain">
<option value="">--- All Domains ---
<cfoutput query="getdomains">
<option value="#domain#">#domain#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Agent</td>
<td class=small>
<select name="userid1">
<option value="">--- All Agents ---
<cfoutput query="getusers">
<option value="#userid#">#userlastname#, #userfirstname#
</cfoutput>
</select>
</td>
</tr>

<tr >
<td class="smallbold" align=right>State</td>
<td class="small">
<select name="state">
<option value="">--- All ---
<cfoutput query="getstates">
<option value="#state#">#state#
</cfoutput>
</select>
</td>
</tr>

</cfif>
<tr>
<td class=smallbold align="right">Time Frame</td>
<td class=small>
<select name="timeframe">
<option value="">--- All ---
<option value="TD">today
<option value="LW">last 7 days
<option value="CM">current month
<option value="LM">last month
<option value="CY">current year
<option value="LY">last year
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Type</td>
<td class=small>
<select name="applicationtypeid">
<option value="">--- All Types ---
<cfoutput query="getat">
<option value="#applicationtypeid#">#applicationtype#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">VVC Status</td>
<td class=small>
<select name="vvcstatusid">
<option value="">--- All Status ---
<cfoutput query="getvvcstatus">
<option value="#vvcstatusid#">#vvcstatus#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Status</td>
<td class=small>
<select name="statusid">
<option value="">--- All Status ---
<cfoutput query="getstatus">
<option value="#statusid#">#status#
</cfoutput>
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">Credit</td>
<td class=small>
<select name="ratecredit">
<option value="">--- All ---
<option value="Good">Good
<option value="Fair">Fair
<option value="Poor">Poor
</select>
</td>
</tr>

<tr>
<td class=smallbold align="right">From (m/d/yy)</td>
<td class=small>
<input type="text" name="from" size=10 value="">
</td>
</tr>

<tr>
<td class=smallbold align="right">To (m/d/yy)</td>
<td class=small>
<input type="text" name="to" size=10 value="">
</td>
</tr>

<tr>
<td class=smallbold align="center"> </td>
<td class=smallbold>
<input type="submit" value="Generate Report">
</td>
</tr>

</table>
</form>

<p>

csteinhilber · Jul 9, 2003

And what's in your Application.cfm?

-Carl

Jerkycold · Jul 9, 2003

I dont have one

csteinhilber · Jul 9, 2003

Yes, you do. Otherwise you'd have no CFAPPLICATION tag, and

Code:

session.usertypeid

(from line 1) as well as you're entire session scope would not exist.

Of course... this could be the root of the error. Though usually you get something a lot more meaningful, like "no variable called 'USERTYPEID' is available in the scope: SESSION... use CFAPPLICATION to activate sessionmanagement..."

But... CF might just be thoroughly confused.

-Carl

rlarson · Jul 10, 2003

line 4: datasource="#peregrine#"
other queries: datasource="peregrine"

Is the first reference (line 4) to a variable "peregrine"?

csteinhilber · Jul 10, 2003

DOH! Completely missed that.
rlarson's right... and that's probably what's throwing the error right there.

-Carl

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

What is wrong with this?

Jerkycold

IS-IT--Management

csteinhilber

Programmer

Jerkycold

IS-IT--Management

csteinhilber

Programmer

Jerkycold

IS-IT--Management

csteinhilber

Programmer

rlarson

Programmer

csteinhilber

Programmer

Similar threads

Part and Inventory Search

Sponsor