MySQL Forums :: Cursors :: Problem with CHAR() variable throwing INT error in CURSOR in Stored Procedure

I can accomplish the task by writing a driver in php, but I'd rather keep the entire routine server-side (in mysql as a stored procedure). PHP would be::


<?php

include("mysql.include.php") ;
open_mysql_connection() ;


$sql01_source = "SELECT collection_id,criteria FROM collection_criteria WHERE disabled = 0" ;
$sql01 = mysql_query("$sql01_source") or die(mysql_error()) ;

while( $row = mysql_fetch_object($sql01)) {
$sql02_source = "INSERT INTO collections_to_docs (sku,collection_id) SELECT T1.sku, '{$row->collection_id}' collection_id FROM documents AS T1 WHERE {$row->criteria} AND T1.sku NOT IN (SELECT T2.sku FROM collections_to_docs AS T2 WHERE T2.collection_id = {$row->collection_id})" ;
$sql02 = mysql_query("$sql02_source") or die(mysql_error()) ;
}

?>



Edited 1 time(s). Last edit at 05/07/2010 10:09PM by Jarad Peckenpaugh.