this sems like it should work but i just cant find the error, i keep getting is this
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]
Too few parameters. Expected 1.
I checked the reserved db names but I just cant find it. I even did a standard db
insert just to see and still got the same error.
<!--- start insert, make sure has been submitted --->
<cfif isDefined("form.submit")>
<cftransaction isolation="serializable">
<!--- get last posted subjectID --->
<cfquery name="qfr" datasource="#dsn#">
SELECT FRID
FROM fr
ORDER BY subjectID DESC
</cfquery>
<!--- finalize insert --->
<cfquery name="qifr" datasource="#dsn#">
INSERT INTO fr (FRarea,
author,
FRreport,
PM,
rating,
weather,
waterFlow,
waterTemp,
hotFly,
hatch,
IP)
VALUES ('#trim(form.FRarea)#',
'#trim(form.author)#',
'#trim(form.FRreport)#',
#val(form.PM)#,
#val(form.rating)#,
'#trim(form.weather)#',
'#trim(form.waterFlow)#',
#val(form.waterTemp)#,
'#trim(form.hotFly)#',
'#trim(form.hatch)#',
#val(form.IP)#
)
</cfquery>
</cftransaction>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
