CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

  Employee Directory example shows no records

Print topic Send  topic

Author Message
cch4cc

Posts: 2
Posted: 12/31/2016, 9:24 PM Quote message

Hi All

Environment : W10+WAMP64+ MS SQL EXPRESS 2016

1. Created database INTRANET in SQLEXPRESS 2016 using the msql sql script in examples\intranet

2. INTRANET database successfully populated

3. Verified availability of records via a simple slect * from employees

4. Change connection to SQL SErver

5. Run empdir solution, can display but no records shown

What have I done wrong ?
View profile  Send private message
eratech


Posts: 510
Posted: 02/11/2017, 10:20 PM Quote message

If you haven't sorted this out yet, try changing the debug flag in db_mysqli.php from 0 to 1 and see what SQL is actually being executed.

It could be that a parameter is being mis-interpreted (dates *always* make me work hard) or perhaps there is a different permissions between the Dev (CCS) connection and the published site connection?

Let me know if you have sorted it and what the problem was (for future problem googlers)

Cheers

Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message

Add new topic Reply to topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.