erro shows " Too few parameters. Expected 9."<br>but there are 14 parameters totally. I think that's already too much.<br><br>-----------------------<br>file1:<br><form action="file2.cfm><br><input type="text" name="companyname">.......<br>.............</form><br>------------------------<br>file2:<br><cfquery datasource="db1"><br>INSERT INTO Company(CompanyName, CompanyLegalName, StateofIncorporation, MailingAddress, City, State, Zipcode, Country, PhoneNumber, Customer, Notes, Fax, LastUpdate, LastUpdateUserID)<br>VALUES(#CompanyName#, #CompanyLegalName#, #StateofIncorporation#, #MailingAddress#, #City#, #State#, #Zipcode#, #Country#, #PhoneNumber#, #Customer#, #Notes#, #Fax#, #LastUpdate#, #LastUpdateUserID#)<br></cfquery>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
query insert into problem
- Thread starter achai
- Start date
I'd be willing to bet there is a comma in one of your fields (maybe "MyCompany,Inc."???), making it look like you have 15 entries in your VALUES clause....<br><br>Try this:<br><FONT FACE=monospace><cfquery datasource="db1"><br>INSERT INTO Company(CompanyName, CompanyLegalName, StateofIncorporation, MailingAddress, City, State, Zipcode, Country, PhoneNumber, Customer, Notes, Fax, LastUpdate, LastUpdateUserID)<br>VALUES('#CompanyName#', '#CompanyLegalName#', '#StateofIncorporation#', '#MailingAddress#', '#City#', '#State#', '#Zipcode#', '#Country#', '#PhoneNumber#', '#Customer#', '#Notes#', '#Fax#', #LastUpdate#, #LastUpdateUserID#)<br></cfquery> </font><br>(take out the single quotes where ever you have a numeric database column, maybe zipcode)<br><br>DM
- Thread starter
- #3
I have already taken out of single quote from #zipcode#, #phoneNumber#, #fax#, #LastUpdate#, #LastUpdateUserID#.<br><br>but this time, erro shows "Data type mismatch in criteria expression."<br><br>actually there are 3 more fields in access, but they are radio type. so i didn't wrote them into these two files. cause according to input type="radio", erro also shows "Data type mismatch in criteria expression."<br><br>
- Thread starter
- #4
problem resolved <b>some</b>. <br>the form must be filled in number where single quote was taken off from parameter.<br><br>"Data type mismatch in criteria expression." because #customer# is yes/no type in access, and radio type in form.<br><br>how can i make this radio type match to coldfusion query expression?<br><br><br><br>
You can access the value by checking if the button is defined, if it has been checked it is defined if it hasn't it's not, so in your query you would do something like:<br><br>INSERT INTO Company (customer, BLA BLA BLA)<br>VALUES (#IIF(IsDefined("Customer"
, "true", "False"#, bla, bla, bla)<br><br>Hope this hels, <br><br>Bromrrrr
, "true", "False"#, bla, bla, bla)<br><br>Hope this hels, <br><br>Bromrrrr - Thread starter
- #6
not because of file2's query problem, because cfinput type="radio" is wrong. but i don't know why. <br><br>erro shows:<br>"Attribute set validation error in tag CFINPUT<br><br>The tag has an invalid attribute combination: the value of the tag switch attribute 'TYPE' which is now 'RADIO' requires a different combination of attributes. For the same switch attribute value the following required attributes have not been provided: (VALUE)."<br><br>
- Thread starter
- #7
- Thread starter
- #9
Also, a good idea is to have a default value for the radio button in the form handler:<br><br><cfparam name="(radiovariablename)" default=0><br><br>This will provide a default to the radio button and not give you a "parameter not defined" error....
- Status