sorting question

[sde]

what is the end user level use of the name "cnfg1" ? is it referencing an actual file somehwere? is this a fixed table? or are rows always added. will there ever be gaps in the numbers? i guess i don't understand the practical use of this table.

to me it still seems you should not be using a number in the name if that is sort of a key identifyer you are using to sort configs.

if there can be a cnfg1 and a nwcnfg1, then it seems to make sense to have a 'id' and 'cfgtype' field.

id ( numeric, but not unique since there can be cnfg1 and nwfng1, this is the '1' value )
type - ( cnfg or nwcnfg, or ...?)
definition-stores
file-stores

with this setup the query would simply be

"select * from table where id=1 and type='cnfg'"

or for ordering configs

"select * from table where type='cnfg' order by id"

again though, there is so much speculation in this advice since i don't know the entire scope of what you're trying to accomplish.

[Odoggy5]

its really basic...

all it is definitions for fields in a table or for configs in a mem file which my company uses for its software. i am just creating a way people can look by particular file all of the configs in that file, or be able to search a specific field or config(they show up in error messages). the information changes between revisions so we need to be able change them, hence the reason i am not just making static pages.

the lpad thingy is working for me right now so i guess i am going to stick with it for now.

in future tables it would probably be a good idea for me to seperate the fields when i do something like this. but im too far into it now and have most of the data uploaded in to my tables.