I have a simple web page with a few queries and an output tag in the body. The
queries use the same datasource as another page that works fine, but uses
different tables within the source.
My page code is:
-----------------------------------------------------------
<CFQUERY datasource="itlog" name="tasks">
SELECT TransactionID,
CustomerID,
TransactionDate,
ComputerName,
ProblemDescription,
Status,
ResolutionNotes,
EnteredBy
FROM dbo.Transactions
ORDER BY TransactionID DESC
</CFQUERY>
<cfset EntryBy = #tasks.EnteredBy#>
<CFQUERY datasource="itlog" name="opentasks">
SELECT TransactionID,
CustomerID,
Status
FROM dbo.Transactions
WHERE Status = 'Open' or status = 'Ongoing'
</CFQUERY>
<CFQUERY datasource="itlog" name="followup">
SELECT TransactionID,
CustomerID,
Status
FROM dbo.Transactions
WHERE Status = 'Followup'
</CFQUERY>
<CFQUERY datasource="itlog" name="empl">
SELECT EmployeeID,
FirstName,
MiddleInitial,
LastName
FROM dbo.ITEmployees
WHERE EmployeeID = #EntryBy#
</CFQUERY>
<CFQUERY datasource="itlog" name="cust">
SELECT CustomerID,
LoginName
FROM dbo.Customers
WHERE CustomerID = #tasks.CustomerID#
</CFQUERY>
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<TITLE>Untitled Document</TITLE>
</HEAD>
<BODY>
<cfoutput>
#tasks.TransactionID#, #tasks.TransactionDate#, #tasks.ComputerName#,
#tasks.ProblemDescription#, #tasks.Status#, #tasks.ResolutionNotes#<BR>
#left(empl.FirstName,1)##empl.middleinitial##left(empl.lastname,1)#,
#cust.loginname#<BR>
</cfoutput>
</BODY>
</HTML>
-----------------------------------------------------------------
I am not getting any CF error messages, but the data that is displayed is
garbage:
example output 1:
------------------------------------------------------------
2, , [EMAIL PROTECTED]<&m, xmžm803AdminAdmin/REAlarmAlarmsAlcan
GenralAsbestosBENCHBudgetCarpentry, @â¦Cpâ¦CAP,
, itcrew
-----------------------------------------------------------
and every time I refresh the page, there is different garbage. Odd things
appear from other SQL databases on the server, or debug message info:
example output 2:
------------------------------------------------------------
2, H,mH,m ¾â ¾â, â¬ÃâPÃâ, xmžm [01000][ODBC
Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting
to us_english. ÂñE [01000][ODBC Socket][Microsoft][ODBC SQL
Server Driver][SQL Server]Changed database context to 'ITLogger'.,
ô»âø»âü»â¼â, xmžm
, itcrew
----------------------------------------------------------------------
I have recreated ny page from scratch a couple of times, and re-entered the
data into the database several times.
Any ideas?
Thanks,
Nicki
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
