Author name: d5admin

Don’t use @@Identity

Don’t use @@Identity to select the ID of the newly inserted record, use scope_identity() instead. @@Identity returns the most recently created identity for your current connection. When you first use it, it might be fine, but if someone adds a trigger that causes another identity to be created, that one will be the one which

Don’t use @@Identity Read More »

INCOMPLETE – Parsing XML with SimpleXML and PHP

More reference: http://www.sitepoint.com/parsing-xml-with-simplexml/ Given the XML: <Calendar> <Account> <Name>Sample Account Name</Name> <Client>Test User</Client> </Account> <CalendarDates> <CalendarDate> <Date>2014-03-01</Date> <Events> <Event> <Name>Event Number One</Name> <StartingAt>2014-03-01T09:30:00</StartingAt> <Categories>General</Categories> </Event> <Event> <Name>Another Event</Name> <StartingAt>2014-03-01T09:30:00</StartingAt> <Categories>Meeting</Categories> </Event> <Event> <Name>Hockey Game</Name> <StartingAt>2014-03-01T10:00:00</StartingAt> <Categories>Sports</Categories> </Event> </Events> </CalendarDate> </CalendarDates> </Calendar> Perhaps this was entered into a textarea on a form and we have read

INCOMPLETE – Parsing XML with SimpleXML and PHP Read More »