Can someone give me an example of how to insert an event into the calendar using SQL? I'm using PHP and the MSSQL connecter. I'm very familiar with how to do this using MySQL but MSSQL is proving more difficult.
I am not sure what you really wanted to insert. however the below query insert the data.
Thanks,
That is exactly what I was looking for. I have one follow-up question. It mostly looks like I just need to learn to use MS SQL better, but can you tell me how I would insert an arbitrary date into either of those fields. Like say I wanted the reminder to show up on
3/19/2007 at 4:00pm. Thanks for your help. It is much appreciated.HI Tiff, You can write the following query to accomplished this. INSERT INTO CalendarEvent (StoreID, CashierID, DateTime, Text, ReminderEnabled, ReminderDate, IsPersonal) VALUES (0, 1, '03/09/2007 4:00pm', 'Testing', 0, '03/09/2007 4:00pm', 0)
" snipped-for-privacy@gmail.com" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.