[Catgen-developer] IOB notes
Status: Beta
Brought to you by:
mbeneteau
|
From: Marc B. <mbe...@ho...> - 2000-08-31 09:04:17
|
(Alexey, Eugene - make sure you are both subscribed to =
catgen-developer.)
I want to explain difference between $TPCode$ and $TPCode||text$. The =
last will surround item in quotes and also escape embedded quotes. So =
for instance:
condition=3D"TPCode =3D '$TPCode' "=20
and=20
condition=3D"TPCode =3D $TPCode||text"=20
are equivalent (since TPCode cannot contain embedded quotes), and =
therefore use the last one preferentially because it is more clear.
Consequently, when inserting numeric item into database, do not use say =
$isLive||text$ but only $isLive|0$. (the last is default value, =
important in case of numeric columns).
Also, as I mentioned, explore inserting current date into any dbStore =
operation as=20
<iob:dbStore
columns=3D"abc,...,isSynchronized,DateUpdated"
values=3D"...,0 ,$sysdate$". (or, $sysdate||text$)
And also always remember to update isSynchronized as above. This is =
very important.
Marc.
|