timestamp

[efrank]

Hello everybody,

I'm constructing a new campaign for which I wish to record in the
database the time and date when a referral is completed. For that I
have a field in the db with type smalldatetime and an ADOR named
register_date for which I defined already several write expressions
trying to find one that does what I want.
So far I tried with no success the following:
|->[register_date] := Now() (with register_date in the schema as date)
|->[register_date] := AsDate(Now()) (with register_date in the schema
as date)
|->[register_date] := AsString(Now()) (with register_date in the
schema as string)
They all produced a NULL entry in the db.

Even though this method is suggested in the PersonalEffect v4.5 Cross
media training guide, but it doesn't work for me. Can anyone point out
what I might be doing wrong? Thanks in advance.

[Timothy Perrett]

Stupid question, but you are actually calling the update method for the ADOR value right? If its still null, i would imagine that its not being called.

The code you wrote looks just fine.

Cheers, Tim

> --
>
> You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
> To post to this group, send email to xmpie...@googlegroups.com.
> To unsubscribe from this group, send email to xmpie-users...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/xmpie-users?hl=en.
>
>
>

[Igor Vorobeychik]

If we assume that you have correct expression in write ADOR and you
are using our update methods , I'd check format of the data field that
you are updating .
If this is a date field than it may be that we returning date in non
default format of your DB and it fails . easy check will be staticly
insert value like 01/01/2009 that should alwais work and aslo check
what you are getting from AsString(Now()) )

> > For more options, visit this group athttp://groups.google.com/group/xmpie-users?hl=en.- Hide quoted text -
>
> - Show quoted text -

[Bill]

Reading your post, I understand that you use uCreate XM from
Dreamweaver, and do not design a uProduce API-based application.
When reading Tim's and Igor posts, I understand they are more refering
to the way to update ADOR values through an API call.
Please don't read the following, if I am already wrong... ;-)
___
When you design a Web page from Dreamweaver and uCreate XM, only
**those** Write ADORs which are refered to in the Insert > Referal
page will be updated. This was certainly designed to help you update
only the ADORs you want from the pages you want.
In your case, it could be strange to refer to an ADOR, whose you know
the Write expression is not bound to any "value" provided by the ASP
page, but I am afraid you will need to do it anyway.
To do so, you could create a sort of fake hidden Form element, without
even assigning a value to it in the HTML code, but just assigning your
Write ADOR to this element in the uCreate XM > Insert > Referal page.

[efrank]

Thank you Bill.
You were 100% right. I'm using uCreate XM with Dreamweaver.
I'm also fairly new to xmpie and I lose sometimes sight of the
obvious.

Happy Holidays
Eduardo