Gossamer Forum
Home : Products : DBMan : Installation :

Field Types in Database Definition

Quote Reply
Field Types in Database Definition
Can I enter the option of alpha and nuber in a field type? For a Street Address.
Thanks
Quote Reply
Re: Field Types in Database Definition In reply to
No...Fields must be defined as EITHER of the following:

Code:
alpha
number
date

They cannot be defined as both. Break up your fields into different types.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Quote Reply
Re: Field Types in Database Definition In reply to
When using the date format for a field, it seems no matter what I enter, I get invalid date format, even when I emulate the exact setup of the Entry Date field that uses &get_date. What am I doing wrong? (I wound up making it a numeric field and using validation to make sure it is in the right format.)
Quote Reply
Re: Field Types in Database Definition In reply to
Try using the date mod found at the following URL:

www.jpdeni.com/dbman/mods.html

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------