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 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:210431 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
