passing data between a page to retrieve more

[AWZ]

I have a drop down with 5 zip codes pulled from an Access database... they are
assigned as the primary key. I want to select a zip code from the drop down and
it to go to another dynamic page..eg. action- (area_stats.cfm) which it does do
BUT it always picks the first zip code listed in the database NOT the zip code
the user picked from the drop down. eg. 22142, 22636, 33653, 477474, 47423
are in the database I pick 33653 in the dop down and click 'submit'... on the
recieving area_stats.cfm page it acts as is I always pick 22142 Please help

[The ScareCrow]

The query in the "area_stats.cfm" page has to include the passed form field

Select *
From table
Where id = #form.nameofselectlist#

Ken

[AWZ]

ok, I'm kinda following this. It seems like it should be so simple... I
basically want 26505 from a drop down sent to the next page as dynamic text...
I have my recordset like so SELECT * FROM area_stats WHERE Zip_Code =
#FORM.Zip_Code# on the receiving page but I always get this error Error
Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
1. The error occurred in
E:\CFusionMX\wwwroot\RealEstateSite\With_fl\Html\a rea_stats_processor.cfm: line
5 3 : 4 : <cfquery name='zipcode' datasource='realestate'> 5 : SELECT
Zip_Code FROM area_stats WHERE Form = #URL.Zip_Code# 6 : </cfquery> 7 :
<cfquery name='zipcodesearch' datasource='realestate'> I know it has to be
as simple as a form name or ??? I guess I really don't know. Any other tips
that would make this easy for a newbie?

[AWZ]

ok, I'm kinda following this. It seems like it should be so simple... I
basically want 26505 from a drop down sent to the next page as dynamic text...
I have my recordset like so SELECT * FROM area_stats WHERE Zip_Code =
#FORM.Zip_Code# on the receiving page but I always get this error Error
Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
1. The error occurred in
E:\CFusionMX\wwwroot\RealEstateSite\With_fl\Html\a rea_stats_processor.cfm: line
5 3 : 4 : <cfquery name='zipcode' datasource='realestate'> 5 : SELECT
Zip_Code FROM area_stats WHERE Form = #URL.Zip_Code# 6 : </cfquery> 7 :
<cfquery name='zipcodesearch' datasource='realestate'> I know it has to be
as simple as a form name or ??? I guess I really don't know. Any other tips
that would make this easy for a newbie?

[The ScareCrow]

From the error message, I would say that the field Zip_Code is text and not a
number, thus you need to enclose the value in single quotes
SELECT *
FROM area_stats
WHERE Zip_Code = '#FORM.Zip_Code#'

Ken