RE: Merging form fields to single DB field...

[Olive, Christopher M Mr USACHPPM]

in your insert statement, do...

<CFQUERY...>
INSERT INTO
        fred
(fieldtogetmergedforms, ...)
VALUES
(#FORM.statefield##FORM.numberfield#, ...)
</CFQUERY>

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-----Original Message-----
From: C [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 23, 2000 9:28 PM
To: [EMAIL PROTECTED]
Subject: Merging form fields to single DB field...


I'd like to be able to have users select a dropdown (state) and combine 
that variable with a textinput (a set of digits) to make that a single 
identifier..

something like

<CFINPUT>
        <CFSELECT> <options for all states></CFSELECT>
        <CFINPUT>(textbox)</CFINPUT>
</CFINPUT>

I can't find anything for merging these two variables into a single form 
variable for integration into a database.. am I on the right track here?

CW

----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.