DD date type issue

Hi,

Thanks in advance. I am updating 5 columns in a table with my dd script. One of them is the date field and it is getting updated everytime I run the ddscript. I would like to know a way where I could be able to update the date filed only if any of the other data of other colums is updated.

Also, can we get the date without passing the value to the script? I mean to say that I would like to avoid the use of $mydate in the below code?

Thanks!
Jenni

[html]
value="$mydate"
data-format="yyyy-MM-dd" allows-null="no"
is-url="no"/>
[/html]

Find more posts tagged with

Comments

moonkhanna

Jenni - please paste your complete code snippet to the post..

Bhargav Coca

First of all you haven't specified you SQL? if it is MSSQL you would be better off using DATETIME than just "DATE" . Secondly if you do not want to use it as a perl variable assign it to a hidden field in your DCR using Form API and fetch it in your dd with that field name.

Hope this helps

Thanks

Adam Stoller

First of all you haven't specified you SQL? if it is MSSQL you would be better off using DATETIME than just "DATE" . Secondly if you do not want to use it as a perl variable assign it to a hidden field in your DCR using Form API and fetch it in your dd with that field name.

Hope this helps

Thanks

Alternatively, if you are looking to use the date / time when the data was inserted / updated in the DB - you should be able to have the DB take care of that for you any time you create / modify a record (the mechanism likely varies from DB vendor to DB vendor) - check with your local DBA

Jenni

Hi Guys,
Thanks for the replies.

Moonkhanna,

I am still working on the code.

Lilleywhite,

I don't have any SQL. I am currently using Oracle DB.

Even if I use a hidden variable of DCR or the perl variable and the user didn't modify any DCR info. the date field (ie the entire record) would be updated once you run the DD script. But I am looking for updating the record only if there is a change in the user input data.

Ghoti,

We already have an option from the db side. But we are looking for any possibility from the dd script / DCT.

1. Can we populate the current date value in DD script without passing from perl or DCT?

2. Even if we pass the date value and the user does not update any other form fields, the date value should not be updated. Can we achieve it?

Thanks!
Jenni

Adam Stoller

[...]
2. Even if we pass the date value and the user does not update any other form fields, the date value should not be updated. Can we achieve it?

If no data in the DCR was changed - why would it even be in the list of files to deploy?

Jenni

If no data in the DCR was changed - why would it even be in the list of files to deploy?

Hi Ghoti,

The user would have the ability to deploy the same data multiple times. Is there a way we could restrict them based on the fact that whether the same data is getting deployed or not (is there any flag to know the whether user updated the data)?

Thanks!
Jenni