Hello everyone,
If you had a variable set like the one I have below...how do you then
reference the variable to display the results? (sorry in advance for the
long posting)
<-----Here's the variable------->
<cfset myquery = "Select *, CALLS.ID AS TICKET, DATENAME(MM, CALLDATE) + ' '
+ DATENAME(DD, CALLDATE) + ', ' + DATENAME(YYYY, CALLDATE)AS 'DATEOFCALL',
DATENAME(MM, LASTUPDATE) + ' ' + DATENAME(DD, LASTUPDATE) + ', ' +
DATENAME(YYYY, LASTUPDATE)AS 'LU', Ext, ExternalEmail, LastName + ', ' +
FirstName AS FullName from CALLS, Employees WHERE ">
<cfif closed IS NOT "">
<cfset myquery = myquery & "CLOSED = '" & #CLOSED# & "'">
</cfif>
<cfif useridconj IS NOT "">
<cfif closed IS NOT "">
<cfset myquery = myquery & " " & #useridconj#>
</cfif>
<cfset myquery = myquery & " CALLS.NAME = " & #NameID#>
</cfif>
<cfif techconj IS NOT "">
<cfif nameid IS NOT "">
<cfset myquery = myquery & " " & #useridconj#>
</cfif>
<cfset myquery = myquery & " " & #techconj# & " CALLS.TECH = '" & #TECH# &
"'">
</cfif>
<cfif calldatestart IS NOT "">
<cfset myquery = myquery & " " & #calldatefromconj# & " CALLS.CALLDATE >= "
& #CallDateStart#>
</cfif>
<cfif calldatethru IS NOT "">
<cfset myquery = myquery & " AND CALLS.CALLDATE <= " & #CallDatethru#>
</cfif>
<cfif category IS NOT "">
<cfset myquery = myquery & " " & #categoryconj# & " CALLS.CATEGORY = '" &
#CATEGORY# & "'"></cfif>
<cfif enteredby IS NOT "">
<cfset myquery = myquery & " " & #enteredbyconj# & " CALLS.ENTEREDBY = '" &
#ENTEREDBY# & "'"></cfif>
<cfif callmethod IS NOT "">
<cfset myquery = myquery & " " & #callmethodconj# & " CALLS.CALLMETHOD = '"
& #CALLMETHOD# & "'"></cfif>
<cfif Office IS NOT "">
<cfset myquery = myquery & " " & #Officeconj# & " Employees.Office = '" &
#Office# & "'"></cfif>
<cfif CallDescWords IS NOT "">
<cfset myquery = myquery & " " & #descwordsconj# & " Calls.Issue like '"
& #CallDescWords# & "'"></cfif>
<cfif CallNotesWords IS NOT "">
<cfset myquery = myquery & " " & #noteswordsconj# & " Calls.Notes like '"
& #CallNotesWords# & "'"></cfif>
<cfif CallResolutionWords IS NOT "">
<cfset myquery = myquery & " " & #resolutionwordsconj# & "
Calls.Resolution like '" & #CallResolutionWords# & "'"></cfif>
<-----Here's the query I try to use------->
<cfquery datasource="firmdaily" name="GetMyQueryResults">
<cfoutput>#myquery#</cfoutput>
</cfquery>
<-----Here's the output I try to display------>
<cfoutput query="GetMyQueryResults">
<tr>
<td>#Ticket#</td>
<td><a href=" #FullName# <mailto:#ExternalEmail#>
mailto:#ExternalEmail#";>#FullName#</a></td>
<td>#Ext#</td>
<td><a href=" #Tech# <mailto:#Tech#> mailto:#Tech#";>#Tech#</a></td>
<td>#DateOfCall#</td>
<td>#LU#</td>
<td><a
href="MonitorEdit.cfm?ID=#CallsQry.Ticket#&OLDTECH=#TECH#">Edit</a><BR>
<a href="MonitorClose.cfm?ID=#Ticket#&OLDTECH=#TECH#">Close</a><BR>
<a href="MonitorViewNotes.cfm?ID=#Ticket#">Notes</a></td>
<td>#Issue#</td>
<td>#Category#</td>
<td>#Office#</td>
</tr>
</cfoutput>
<---------Here's the lovely error message I receive--------->
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or
column names. Use a single space if necessary.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (64:1) to (64:57).
Date/Time: 09/17/02 15:04:06
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Hotbar 4.1.5.0)
Remote Address: 10.30.25.134
HTTP Referrer: http://dailynews/helpdesk/monitorqbe.cfm
<http://dailynews/helpdesk/monitorqbe.cfm>
Does anyone have any ideas on a better way for me to generate my output?
This is a Query By Example application.
Thanks,
Aimee Clark
Web Developer
Stinson Morrison Hecker LLP
816-691-3461
[EMAIL PROTECTED]
_____
<http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3
bst%3b&SG=&RAND=9320> <http://skins.hotbar.com/Skins/promo/1px/1px.gif>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
