I'm getting an error saying the IfNull function is undefined in my sql statement (need to put in an empty string for nulls). The function runs from the adodb.inc.php file. My best guess right now is that for some reason the ADODB drivers are not loading. I've confirmed they are referenced in the php.ini files and that the .php extension is referenced in the httpd.conf file. I loaded all the adodb files into the PHP folder. I'm hoping this is just a simple mapping issue. I'm loading it at the top of the file as -

 

include_once('C:\CPSv3\UniServer3_2a\diskw\usr\local\Php\adodb.inc.php');

(I also tried it with the path as - 'W:\usr\local\Php\adodb.inc.php'. Both versions worked until I added the function.)

 

The sql statement pulled the data fine until I added the function. It is -

 

$sql = "SELECT PartNumber, PartDesc, IfNull(Serial, ""), PartModel FROM Parts"

$rs = $conn->Execute($sql) or die("Error in query: $query. " . $db->ErrorMsg());

 

Is there something special needed for using ADODb with UniformServer?

 

 

Thanks in advance for the help.

I have never tried it with Uniform Server but i do know that the file: W:\usr\local\Php\adodb.inc.php is not in that folder, unless you added it.

 

I will try and see, make sure it is loaded in the php.ini file and also the my.cnf file in W:\usr\local\mysql\bin

 

Hmm.. is this function a MySQL function or PHP function? Trying to figure something out.

 

Thanks.