Hello Dave,
This error normally or historically would be a typo in on of the field
names. So if the other idea is WRONG, carefully check your field names.
Kind Regards,
Mike Randolph
At 11:51 PM 5/29/2003 -0400, you wrote:
>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
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
