I can't get the SQL Query option to work when generating reports. I enter my query and click on execute and the system reports "Valid SQL Query". I then go through the steps but the resulting report are just a blank white screen. Not even the style I choose is there.
When using the "table" option it works 100% with no problems.
Is there anything specific I must do to get the SQL Query option to work cos I really need it ?
PS. I even used a simple query like : select * from tblname where columnname = 'criteria'; and still it doesnt work
What's the full query you wish to run? select * from tblname where columnname = 'criteria';
It may be something to do with the 'criteria' that is done visually in one of the steps.
select * from musiekdvds where Disk_Name = 'Faith Hill DVD';
It works 100% when I run it on the MySql server itself and retrieves the data. But on the form generator , nothing.
I even tested on another table with :
select * from users where naam = 'Wikus';
Same thing , works 100% when I run it on the MySql server itself , but on the form generator just blank white screen.
Maybe if you need another way try a little php script.
displayit.php
PHP Code:
<html>
<head><title>FEEDS</title></head>
<body>
<?php
$database="database_name";
mysql_connect ("localhost", "username", "password");
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query( "select * from musiekdvds where Disk_Name = Faith Hill DVD" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
print "There are $num_rows records.<P>";
print "<table width=200 border=1>\n";
while ($get_info = mysql_fetch_row($result)){
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td><font face=arial size=1/>$field</font></td>\n";
print "</tr>\n";
}
print "</table>\n";
?>
</body>
</html>
Of course edit your own db connection stuff. Never really used this app's sql window but i think your issue is because your report can be generated visually using the tables option. Just a guess...
Can't get SQL Query option to work
Linear Mode
