I just found a nice little thing today (our DBA's didnt know about it either), you cant insert a pipe ( | ) directly with sql
insert into tblMyTable ( myField ) values ( "|" )
so, easy enough to change it to chr(124) and everything works well.
My Q is, How am i suposed to know that?? Is there some doc's / people know of what other things i cann't just go striaght out and add (of course " and ', but any other whacky ones )
Open for any input (on topic)! -
points for all!!!