The results of your search are shown below. To refine your search, revise your keywords, and/or select the appropriate check boxes to the right.
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
All guests are assigned to table and seating when you highlight some guests and click “Add all”
Symptom
Event guest seating assignment permits you to highlight guests and click “Add all” to an existing table. This gives the impression that just the highlighted guests would be assigned to the table, but all guests without a table and seat assignment are placed at the table.
Product Line