Error message on query

[rmorgan]

Hi, can some one tell me what this error is trying to tell me:
Error Executing Database Query.
No value specified for parameter 12

Its happening when the data is passed to the action page to be inserted into the db. I know I may not have provided enough info, but possibly the error will. If I need to post more its not a problem. TIA

[Dan_Bracuk]

turn on debugging, and post the sql that your code produces. Also specify the db type (oracle, mysql, whatever)

[rmorgan]

Its a MySQL DB

Error Executing Database Query.
No value specified for parameter 12

The error occurred in /var/www/html/alumforms/broadcast/query/qrybcastinsert.cfc: line 3
Called from /var/www/html/alumforms/broadcast/finished.cfm: line 10
Called from /var/www/html/alumforms/broadcast/query/qrybcastinsert.cfc: line 3
Called from /var/www/html/alumforms/broadcast/finished.cfm: line 10

1 : <!--- <cfoutput>#form.colleges_id#</cfoutput> --->
2 : <cftransaction>
3 : <cfinsert datasource="#dsn#" tablename="bcasts" formfields="sendbcast,bcastgroupid, senddate,contact,email,colleges,Phone,Subject,audience,eventstartdate,starttime,eventenddate,endtime,myEditorHTML" >


SQL insert into bcasts (sendbcast senddate,contact,email,colleges,Phone,Subject,audience,eventstartdate,starttime,eventenddate,endtime,myEditorHTML) values ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) )

[Dan_Bracuk · Accepted solution]

you are trying to put 12 values into 10 fields.

[rmorgan]

Sheesh, thanks for the nudge.

[paross1]

You are learning how much "fun" using cfinsert can be. Do yourself a BIG favor..... use cfquery and write your own SQL insert statements instead. Forget about using cfinsert and cfupdate tags, as they look like they save you time, but end up causing you nothing but headaches.

My 2 cents....

Phil

[rmorgan]

I usually do write my own, that was the first and probably the last.