Page 1 of 1

Having trouble with the agnDB tab

Posted: Tue Jan 30, 2007 4:05 pm
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

agn-Tags

Posted: Wed Jan 31, 2007 9:21 am
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?

Posted: Wed Jan 31, 2007 1:49 pm
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

db field

Posted: Wed Jan 31, 2007 3:51 pm
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!