Inserting form info into access problem

[jen_ren]

I am developing three different surveys which are the same topic - different
view points. I have 2 forms working and going into the tables perfectly. On
this last one is the problem. You can fill out the form and submit with no
problem. It carries the correct values for each answer and enters a record into
the table. Here is when I encounter the problem, when I go into access and open
the table, the records that are entered all have the values of null or 0. Can
someone help me to understand why the correct values are being passed, but not
entered to the table correctly?

[VillageX]

Can you post the code for the insert?

[jen_ren]

Here is my insert statement. The other 2 are the same way and they work just
fine.

<cfquery name="Intostudent" datasource="year2Calendar">
INSERT INTO student
VALUES
('#Form.level#', #Form.twoA#, #Form.twoB#, #Form.twoC#, #Form.twoD#,
#Form.twoE#,
#Form.twoF#, #Form.twoG#, #Form.threeA#, #Form.threeB#, #Form.threeC#,
#Form.threeD#,
#Form.threeE#, #Form.threeF#, #Form.threeG#, '#Form.inconvenience#',
'#Form.benefit#', #Form.participate#,
'#Form.instruction#', '#Form.food#', '#Form.transport#', '#Form.afterCare#',
'#Form.communInfo#',
'#Form.dayLength#', #Form.inFavor#, '#Form.comment#', '#xypz#')
</cfquery>

[philh]

Are all of the column entries in agreement as to datatype? Can you print the
form variable values out on the page that does the inserting? Can you
construct a SQL statement from the passed variables (as opposed to plugging
them into the CFQUERY tag) and run it in Access?

[jen_ren]

All of the columns data types match.

i]Can you print the form variable values out on the page that does the
inserting?

[url]http://localhost:8500/fcboefusion/Surveys/Calendar/student/process_student.cfm?l[/url]
evel=5&twoC=1&twoD=1&threeA=1&threeB=1&threeF=1&in convenience=1&benefit=1&partic
ipate=1&instruction=0&food=1&transport=2&afterCare =3&communInfo=3&dayLength=4&in
Favor=1&comment=lk3Basdjf3Blkjadlkjakdjflkjasdf

Don't quite understand the third statement. Do you mean pass the variables and
use <cfoutput>s to display???

I also have an application.cfm that uses <cfparam>s to set the values to null
or 0. I just don't understand why this 1 does not work and the other 2 do,
because they are set up the same way. Each are in different folders with
different application.cfm's

[paross1]

You state that when I go into access and open the table, the records that are
entered all have the values of null or 0 and also I also have an
application.cfm that uses <cfparam>s to set the values to null or 0 In case you
weren't aware, the APPLICATION.CFM template is executed for every page that is
called, so if you are repeatedly setting these form variables to NULL or 0
before every page that is called, that probably accounts for the database
columns are being set to those values.

Phil

[SaltwaterOtter]

Looks like you are sending a URL varable--try using #URL.var# vs. #Form.var#

[jen_ren]

Thanks. Duh, I got it working. I did not have method='post' and the action page was not correct. I have had that cruddy flu bug. Thanks for yalls help

[philh]

Hope you feel better, Jen!