Query binding and the question mark

Query binding and the question mark - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Query binding and the question mark (/showthread.php?tid=55243)

Query binding and the question mark - El Forum - 10-16-2012

[eluser]Unknown[/eluser]
I am trying to use query binding but I am running into a problem because one of my field names has a question mark in it. I know the correct approach would be to go back and rename the field, however, this is not an option for me.

Is there any way that I can modify this SQL INSERT statement to properly escape the question mark in this field:

Code:
`Paid?`

Here is the SQL:

Code:
$sql = "INSERT INTO `tblAppeals` 

 ( 

 `#`,

 `Year`,

 `Property#`,

 `Paid?`,

 `Outcome`,

 `ResolvedBy`,

 `AppealCategory`

 ) 

 VALUES (?,?,?,?,?,?,?)";

What seems to be happening is that whatever process is handling the bind parameters is also eagerly trying to change all of the

Code:
?

in the SQL and not just what is in the values part of the clause.

EDIT:

I think I have figured out a workaround. I can structure the insert as follows and it works:

Code:
$data = array('#'  => $aID, 

  'Year'   => $aYear, 

  'Property#'   => $aRoll, 

  'Paid?'          => $aPaid, 

  'Outcome'   => $aOutcome, 

  'ResolvedBy'   => $aResolvedBy, 

  'AppealCategory'  => $aCat);

$result = $this->db->insert_string('tblAppeals', $data);

If anyone has any better ideas, please let me know. Thanks.