I'm running a query through XML from the local database which uses PHPMyAdmin to a remote one which uses MSSQL.
Unfortunately I have no way of checking syntax against MSSQL so all I know is that this works in PHPMyAdmin. So the query gets as far as running, but is never successful.
UPDATE tbl_wisenet_checklist_shared SET Completed = '1', DateCompleted = '2006-03-06', StaffName = 'Ladybib Nat', Comment = 'Level 2 competencies assessed, Phase 2B (WRRI1B, WRRF1B, WRRLP2B, WRRCS3B, WRRCS2B). Clarifying questions asked to check underpinnning knowledge. Trainee is competent - assessment evidence attached. Assessment techniques used include observation, verbal questions and written assignments.T, Rang to check, Discussed results with Manager/Owner, Rest of comment' WHERE ChecklistID = 78780;
Any Ideas? :rolleyes: