Having trouble with the agnDB tab

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

MaryJane
Posts: 2
Joined: Tue Jan 30, 2007 3:56 pm

Having trouble with the agnDB tab

Post by MaryJane »

Good morning/afternoon:

We are test driving OpenEMM and I am having trouble getting the [agnDB ...] tag to work (others appear to be working fine for me). As I am very new at this, I am sure I must be doing something wrong.

The following are my two test lines of code. . . from looking at the pdf manual, this looks fine.

This should display the cust id.
[agnDB column="ext_entity_id"]

Can you help me please?

MaryJane
maschoff
Site Admin
Posts: 2608
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

agn-Tags

Post by maschoff »

Do you use 5.0.2? There was a agn-Tag related bug in former versions. If you use 5.0.2, please try [agnDB column=ext_entity_id]. Does this work for you?
OpenEMM Maintainer
MaryJane
Posts: 2
Joined: Tue Jan 30, 2007 3:56 pm

Post by MaryJane »

Hello ma!

Yes, we use 5.0.2 (I should have included that - many apologies).

Thank you for your suggestion - I had already tried that to no avail. However, I did work with our DBA late yesterday and he changed the database to make it an integer. For some reason the column was defined as double precision number. Is this the standard default for a new numeric column?

Thank you!

MaryJane
maschoff
Site Admin
Posts: 2608
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

db field

Post by maschoff »

Update:

I checked the source: Actually a "numerical" data field is defined as type double to allow for really big numbers. However, your code should have worked. We will have to look into this!
OpenEMM Maintainer
Post Reply