Summary:	ASTERISK-17411: [patch] func_odbc insertsql option may not work on SQL_NODATA
Reporter:	Gregory Hinton Nietsky (irroot)	Labels:
Date Opened:	2011-02-15 09:04:25.000-0600	Date Closed:	2011-02-28 03:34:17.000-0600
Priority:	Minor	Regression?	No
Status:	Closed/Complete	Components:	Functions/func_odbc
Versions:	1.6.2.15	Frequency of Occurrence
Related Issues:
Environment:		Attachments:	( 0) func_odbc.insert_nodata.patch
Description:	Figgured out why when UPDATE returned 0 Rows func_odbc saw this as a failure and returned no stmt find a small patch attached to rectify this ... SQL_NODATA was not taken into account as a valid return for SQLExecDirect ...
Comments:	By: Gregory Hinton Nietsky (irroot) 2011-02-15 09:08:54.000-0600 @tilghman This is related to ASTERISK-17392 the complete patch [including merged code] is here for completeness against the stated version above this resolves all my issues regarding the insert function. Regards Greg By: Leif Madsen (lmadsen) 2011-02-16 15:44:42.000-0600 Reminder for another func_odbc issue. Related to the issue you recently resolved. By: Tilghman Lesher (tilghman) 2011-02-16 16:10:10.000-0600 Looks fine to me. By: Gregory Hinton Nietsky (irroot) 2011-02-24 07:31:51.000-0600 nudge nudge wink wink ... By: Tilghman Lesher (tilghman) 2011-02-24 14:04:08.000-0600 Your issue is in queue, please be patient, and we will get to it as time permits and developer resources become available. By: Gregory Hinton Nietsky (irroot) 2011-02-25 01:06:21.000-0600 @tlghman not a problem ive got it working here was bumping issues that are closeable ... By: Tilghman Lesher (tilghman) 2011-02-25 03:18:24.000-0600 Please don't do that.  It generates needless extra email, and it does not change the position of the issue in the queue. By: Digium Subversion (svnbot) 2011-02-28 03:32:24.000-0600 Repository: asterisk Revision: 308990 U   branches/1.6.2/funcs/func_odbc.c ------------------------------------------------------------------------ r308990 | tilghman | 2011-02-28 03:32:24 -0600 (Mon, 28 Feb 2011) | 7 lines Statements updating zero rows may return SQL_NO_DATA.  This is fine; it's handled. (closes issue ASTERISK-17411) Reported by: irroot Patches:       func_odbc.insert_nodata.patch uploaded by irroot (license 52) ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=308990 By: Digium Subversion (svnbot) 2011-02-28 03:33:23.000-0600 Repository: asterisk Revision: 308991 _U  branches/1.8/ U   branches/1.8/funcs/func_odbc.c ------------------------------------------------------------------------ r308991 | tilghman | 2011-02-28 03:33:23 -0600 (Mon, 28 Feb 2011) | 14 lines Merged revisions 308990 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.6.2 ........  r308990 | tilghman | 2011-02-28 03:32:22 -0600 (Mon, 28 Feb 2011) | 7 lines    Statements updating zero rows may return SQL_NO_DATA.  This is fine; it's handled.    (closes issue ASTERISK-17411)   Reported by: irroot   Patches:         func_odbc.insert_nodata.patch uploaded by irroot (license 52) ........ ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=308991 By: Digium Subversion (svnbot) 2011-02-28 03:34:17.000-0600 Repository: asterisk Revision: 308992 _U  trunk/ U   trunk/funcs/func_odbc.c ------------------------------------------------------------------------ r308992 | tilghman | 2011-02-28 03:34:16 -0600 (Mon, 28 Feb 2011) | 21 lines Merged revisions 308991 via svnmerge from https://origsvn.digium.com/svn/asterisk/branches/1.8 ................  r308991 | tilghman | 2011-02-28 03:33:22 -0600 (Mon, 28 Feb 2011) | 14 lines    Merged revisions 308990 via svnmerge from  https://origsvn.digium.com/svn/asterisk/branches/1.6.2    ........    r308990 | tilghman | 2011-02-28 03:32:22 -0600 (Mon, 28 Feb 2011) | 7 lines        Statements updating zero rows may return SQL_NO_DATA.  This is fine; it's handled.        (closes issue ASTERISK-17411)     Reported by: irroot     Patches:           func_odbc.insert_nodata.patch uploaded by irroot (license 52)  ........ ................ ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=308992