if (form.Notes eq "") session.Notes = "NULL"; else session.Notes = "'" & Replace(form.Notes,"'", "''", "All") & "'"; UPDATE RelName SET Notes = #PreserveSingleQuotes(session.Notes)# WHERE RelNameId = #url.RelNameId# SELECT Name_1.FullNameCache AS Name1, Name_2.FullNameCache AS Name2, RelNameQualifier.RelNameQualifier, RelName.Notes FROM RelName INNER JOIN Name Name_2 ON RelName.NameFk2 = Name_2.NameId INNER JOIN Name Name_1 ON RelName.NameFk1 = Name_1.NameId INNER JOIN RelNameQualifier ON RelName.RelNameQualifierFk = RelNameQualifier.RelNameQualifierId LEFT OUTER JOIN RefDetail ON RelName.RefDetailFk = RefDetail.RefDetailId LEFT OUTER JOIN Reference ON RelName.RefFk = Reference.RefId WHERE RelName.RelNameId = #URL.RelNameId# session.BackFromEditTypeNotes = cgi.http_referer; session.Name1 = TypeNotes.Name1; session.Name2 = TypeNotes.Name2; session.RelNameQualifier = TypeNotes.RelNameQualifier; session.Notes = TypeNotes.Notes;

Add Edit notes for "#session.Name1# #session.RelNameQualifier# #session.Name2#"

Notes