Blank Numbers and Dates in a view

This topic is locked

Blank Numbers and Dates in a view	12/13/2007 1:36:22 PM
PHPRunner General questions
S skingspan author I have created a view based on a custom query such as: SELECT ss.corehub, ss.DS3NEDiscComplete, count(ss.DS3NEDiscComplete) FROM (SELECT gcgipon, max(corehub) 'corehub' , max(hop), max(DS3NEDiscComplete) DS3NEDiscComplete from ExcelCircuitOrders E where DS3NEDiscComplete is not null group by gcgipon) ss group by corehub, DS3NEDiscComplete The issue is that when I build and view the code I see blank values for the date and numeric fields. When I export the results to excel all fields are output as they should be. Thanks


J	Jane 12/14/2007
	Hi, it's difficult to tell you what's happening without seeing actual files. Please publish your project on Demo Account and post a URL to your pages here or send it to [email=support@xlinesoft.com]support@xlinesoft.com[/email] along with instructions on reproducing this error. I'll find what's wrong with your project inspecting it at Demo account site.