Nacirema
12-18-2006, 02:40 PM
Hi,
I have this SQL Query:
$sqlInit = "SELECT (substring(firstname,1,1) + substring(lastname,1,1)) as initials from bl_ress INNER JOIN BL_quot ON bl_ress.IDresscreatedby = BL_quot.idRessCreatedBy where BL_quot.idClient =" .$quotId;
$initials = $conn->execQuery($query);
return $initials;
How do I execute this query and put the the recordset in a variable?
I mean am I doing something wrong?
Because I got:
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:
This is how I call it and display the results:
"<td align='center'><nobr>".$quotDAO->getInitials($quot['IDQuotation'])."</nobr></td>" .
I have this SQL Query:
$sqlInit = "SELECT (substring(firstname,1,1) + substring(lastname,1,1)) as initials from bl_ress INNER JOIN BL_quot ON bl_ress.IDresscreatedby = BL_quot.idRessCreatedBy where BL_quot.idClient =" .$quotId;
$initials = $conn->execQuery($query);
return $initials;
How do I execute this query and put the the recordset in a variable?
I mean am I doing something wrong?
Because I got:
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:
This is how I call it and display the results:
"<td align='center'><nobr>".$quotDAO->getInitials($quot['IDQuotation'])."</nobr></td>" .