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,CZNB,CYNB,CWTX,C3NB,M > ....EALS4,MEALS6,MEALS5) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) > .... > ....Any Ideas where the '?' are coming from? The form fields have values. > .... > ....Thank you, > ....Daron Smith > .... > .... > .... > .... > .... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210433 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
