Which is just one of the many reasons you should always use <cfset
request.tapi.sql.update("db_table")> instead of <cfinsert> :P> Yeah, just with cfinsert it does not display the "key" > like we get with > cfqueryparam. The "key" being the portion of the debug > information that > lists the datatype and the value. > On 6/23/05, Ian Skinner <[EMAIL PROTECTED]> > wrote: >> >> Don't know if this applies to cfinsert, but the question >> marks like that >> are the bind parameters I get when I write my queries >> with <cfqueryparam> >> tags on the where clause. >> >> Just below the query you should see something like this. >> Query Parameter Value(s) - >> Parameter #1(cf_sql_varchar) = abcdef >> >> #1 would be the first ?, #2 the second and so on. >> >> -------------- >> Ian Skinner >> Web Programmer >> BloodSource >> www.BloodSource.org <http://www.BloodSource.org> >> Sacramento, CA >> >> "C code. C code run. Run code run. Please!" >> - Cynthia Dunning >> >> ....-----Original Message----- >> ....From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED] >> ....Sent: Thursday, June 23, 2005 1:52 PM >> ....To: CF-Talk >> ....Subject: CFINSERT Question >> .... >> ....I have a form and I want to use CFINSERT, but it's >> not putting the >> ....values in the "values" statement of the SQL. >> .... >> ....Below is what I get: >> .... >> ....insert into CONFREG >> >> ....(CNTX,MEALS2,FEES2,CTTX,C2NB,BOST,COTX,AXXT,MEALS3,CZ >> NB,CYNB,CWTX,C3NB,M >> ....EALS4,MEALS6,MEALS5) values >> (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) >> .... >> ....Any Ideas where the '?' are coming from? The form >> fields have values. >> .... >> ....Thank you, >> ....Daron Smith s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210444 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
