This is a multi-part message in MIME format. ------=_NextPart_000_0019_01BE95D8.30ABE9C0 Content-Type: text/plain; charset="windows-1257" Content-Transfer-Encoding: quoted-printable using cfselect I am wanting to be able to extract the values for the id = number of the record as well as the value of the main field name for = that record. let me explain I have a tables that contains all the geographical = regions of a state in the table using the cf select function in a form I want the user to be able to = select the region of their choice but by doing so it will pass the = region name as well as the regionid number for that particular record I believe I can do this using cf list get function however I am not = sure how to use the code exactly nor the correct syntax the current code I ma using without the cf list get function is: <cfquery name=3D"RegionDropDown" datasource=3D"australianaccomm"> Select Distinct Region FROM Regions Order By Region </cfquery> <cfselect name=3D"Region" value=3D"RegionDropDown.Region" size=3D"1"> <option></option> <cfoutput query=3D"RegionDropDown"> <option>#Region#</option> </cfoutput> </cfselect></td> =20 i look forward to your assistance Kind Regards Claude Raiola E-Mail: [EMAIL PROTECTED] Website: www.internetgoldcoastproperties.com.au ------=_NextPart_000_0019_01BE95D8.30ABE9C0 Content-Type: text/html; charset="windows-1257" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Dwindows-1257" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT color=3D#0000ff size=3D2>using cfselect I am wanting to be = able to=20 extract the values for the id number of the record as well as the value = of the=20 main field name for that record.</FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2>let me explain I have a tables that = contains all=20 the geographical regions of a state in the table</FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2>using the cf select function in a = form I want=20 the user to be able to select the region of their choice but by doing so = it will=20 pass the region name as well as the regionid number for that particular=20 record</FONT></DIV> <DIV><FONT color=3D#0000ff size=3D2></FONT> </DIV> <DIV><FONT color=3D#0000ff size=3D2>I believe I can do this using = cf list get=20 function however I am not sure how to use the code exactly nor the = correct=20 syntax</FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2>the current code I ma using without = the cf list=20 get function is:</FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2><cfquery name=3D"RegionDropDown"=20 datasource=3D"australianaccomm"><BR>Select Distinct Region<BR>FROM=20 Regions<BR>Order By Region<BR></cfquery></FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2><cfselect name=3D"Region"=20 value=3D"RegionDropDown.Region"=20 size=3D"1"><BR> <option></option><BR>&nbs= p; <cfoutput=20 query=3D"RegionDropDown"><BR> <option>#Region#&= lt;/option><BR> </cfoutput><BR></FONT><FONT=20 color=3D#0000ff = size=3D2> </cfselect></td></FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2>i look forward to your = assistance</FONT></DIV> <DIV><FONT color=3D#0000ff size=3D2><BR>Kind Regards</FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2>Claude Raiola<BR>E-Mail: <A=20 href=3D"mailto:[EMAIL PROTECTED]">info@internetgold= coastproperties.com.au</A><BR>Website:=20 <A=20 href=3D"http://www.internetgoldcoastproperties.com.au">www.internetgoldco= astproperties.com.au</A></FONT></DIV> <DIV> </DIV> <DIV><FONT color=3D#0000ff size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0019_01BE95D8.30ABE9C0-- ------------------------------------------------------------------------------ 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.