DF-M23259-Sporadic error “Incorrect syntax near ‘-‘” adding non-constituent guest to an event registrant
Symptom
Users experience the error message below when clicking Insert to add a Guest row onto an event registrant record after clicking on Create a Non-Constituent Guest link.
*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attlnkkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select guestkey from event_guest_full where guestlnkky = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Media'.--37000 Statement: DSN=Web SQL;UID=tvt;==select gitemitmky from guest_items_full where gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0 or gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0
*SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attlnkkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select attkey from attendance_full where attregkey = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '-'.--37000 Statement: DSN=Web SQL;UID=tvt;==select guestkey from event_guest_full where guestlnkky = - *SQLExecDirect Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Media'.--37000 Statement: DSN=Web SQL;UID=tvt;==select gitemitmky from guest_items_full where gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0 or gitemlnkky = 5900 or gitemlnkky = cial Media Workshop 1/25/18 or gitemlnkky = 0
Product Line
DF-FR-21332-Guest Card Prints Only Headers
Symptom
Print Preview of Guest tab only returns the header rows. The Guest Names and Guest of columns are blank. Printing to printer also returns only column headers
Product Line
DF-M19590-Constituent First Name is truncated when adding a non-constituent guest to a registrant
Symptom
Constituent First Name is truncated when adding a non-constituent guest to a registrant
Product Line
DF-FR-19429-List of Registrants by Activity report returns “SQLSTATE = S0022, Invalid column name ‘activity_id’”
Symptom
Report returns error when including activity in the query.
Product Line
DF-M17011-Blank Event Guest display after updating Guest record
Symptom
After updating guest record, the event guest blanks out.
Product Line