Hi, Im using the Python MySQL Connector to fire a stored procedure with a variable.
Thanks to the awesome help in this forum my working version of an insert is
Ive tried to format based on the select query and also tried callproc but can't quite seem to get either format right.
Thanks in advance
Todd
Thanks to the awesome help in this forum my working version of an insert is
query = ("SELECT distinctrow UPC, ItemFriendlyNames, ItemName, Brand, Model, Retailer, ItemID FROM my.view where ItemFriendlyNames like "%(pSearch)%" order by UPC, Model, Retailer") data = (event['pSearch'],) cursor.execute(query,data) rows = cursor.fetchall()What I need to do is fire stored procedure sp_showitemswithSearch that recieves an input called pSearchTerm
Ive tried to format based on the select query and also tried callproc but can't quite seem to get either format right.
Thanks in advance
Todd