This is a CF / SQL question. Please let me know if CF is taboo here.

I have 11 sequences (one per category) represented in a form drop-down menu.

I'm having a difficult time getting the selected sequence to work in the insert statement. The values that I've stored in the form are in this format:

gpn_dft_seq.nextval
gpn_ds_seq.nextval

etc, etc till all 11 categories (and thus all 11 sequences) are represented.

Please see below:








insert into graphicpartnumbers
(
category_seq_no,
category,
currdate,
fullname,
description
)
values
(
to_number(#category#),
'#striped_category#',
'to_date(#currdate#)',
'#fullname#',
'#description#'
)




I keep getting a variety of errors depending on what modifications I try {with this line: to_number(#category#)}, including the one listed in the subject line.

Any suggestions will be much appreciated.

Thanks.
Cam