Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Article Manager 2:
Database Editor Feature

 
 


jcocking
User

Dec 4, 2006, 8:09 PM

Post #1 of 4 (846 views)
Shortcut
Database Editor Feature Can't Post
I think I found an undocumented feature. I tried to set up a validation for a new data field within the database editor. I selected the 0-9 and the other category. (creating a dollar amount field and wanted to be able to enter $xx.xx) The editor allowed me select two check boxes, but trying to enter the amount on an article gives me an error. It is only checking for the first box checked.

See attached images:
1. validation - article data field validation setup
2. value - what was entered in the article setup field
3. error message

Is the problem on the data validation setup, should only be able to select one checkbox or is the error on the validation routines?
Jeff Cocking
[url "http://www.lotuselan.net"]Lotus Elan (AM 1.38)[/url]
[url "http://www.netphoneinfo.com"]VoIP Phone Comparisons (AM 2.02)[/url] 

(This post was edited by jcocking on Dec 4, 2006, 8:14 PM)
Attachments: validation.png (4.13 KB)
  value entered.jpg (1.50 KB)
  error message.jpg (19.9 KB)


ross
Staff / Moderator


Dec 6, 2006, 3:54 PM

Post #2 of 4 (825 views)
Shortcut
Re: [jcocking] Database Editor Feature [In reply to] Can't Post
Hi Jeff.

Thanks for posting!

That's definitely a strange one you have there. I have been trying to re-create this locally but haven't got the same error message.

From what I can tell, I am using all the same settings as you but my article saves when I use 15.66 as the value.

Do you think you could send in a support request on this one for me? That way I can have a much closer look at what's going on:

https://www.interactivetools.com/support/email_support.cgi

How does that sound? I look forward to hearing from you Smile.
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Product Specialist
support@interactivetools.com

Hire me!  Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/



jcocking
User

Dec 6, 2006, 6:24 PM

Post #3 of 4 (819 views)
Shortcut
Re: [ross] Database Editor Feature [In reply to] Can't Post
I figured it out after reviewing the variable setup. I had declared the variable an Integer in the Database Field Setup. To keep others from doing the same dumb thing I did, I would suggest if you select an integer, then the validation fields are grayed out or an error routine and notice is presented if you try mis matching validation with database field setup.

thanks
Jeff Cocking
[url "http://www.lotuselan.net"]Lotus Elan (AM 1.38)[/url]
[url "http://www.netphoneinfo.com"]VoIP Phone Comparisons (AM 2.02)[/url] 

(This post was edited by jcocking on Dec 6, 2006, 6:25 PM)


MikeB
Staff


Dec 8, 2006, 8:56 AM

Post #4 of 4 (798 views)
Shortcut
Re: [jcocking] Database Editor Feature [In reply to] Can't Post
Hi Jeff,

Thanks for the follow-up! Smile

I'm glad to hear you've managed to sort out this issue and your suggestion is definitely something I'll make note of here.

If you do have any other questions or comments, don't hesitate to ask! Smile



Cheers,
Mike Briggs - Product Specialist
support@interactivetools.com

[hr][i][url "http://www.interactivetools.com/consulting/"][b]Hire me![/b][/url]
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with [url "http://www.interactivetools.com/consulting/"][b]Priority Consulting[/b][/url].[/i]