var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Invalid operator for data type
I am getting the following error message when I try to put the datetime between strings
Invalid operator for data type. Operator equals boolean AND, type equals datetime.
The code is:
INSERT INTO AdminAlerts values (CURRENT_USER, 'INSERT', getDate(), @biui, 'Booked room number ' & @rn & ' on ' & @gd & ', Customer ID: ' & @ci & ' and Booking ID: ' & @biui)
@gd is where the error is, it is a datetime.
Anyone knows whats wrong?
The word INSERT is a reserved word, yet you are using it within your insert statement itself, likely this is causing the error.
Assuming that your INSERT is intended to run in MySQL instead of another tool such as MS-Access, I think you want to use the Concat() function instead of the & operator.