Re: CFINSERT Question
I used which is simply a wrapper more or less for a CFC On 6/23/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > Which is just one of the many reasons you should always use request.tapi.sql.update("db_table")> instead of :P > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210460 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
Re: CFINSERT Question
Which is just one of the many reasons you should always use instead of :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 >> 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
Re: CFINSERT Question
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 > 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
Re: CFINSERT Question
Check your database, the values should be inserted still. To know what each ? equates to you just have to scroll down more to where the Form fields are listed in the rest of the debug information. On 6/23/05, Smith, Daron [PA] <[EMAIL PROTECTED]> wrote: > 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 > > > > > ~| 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:210432 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
RE: CFINSERT Question
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 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
Re: CFINSERT Question
The questions marks indicate bind variables, like you'd get when using CFQUERYPARAM. Bind variables have a number of uses, and are a Good Thing. In the debugging output, directly after the query, it should list the actual values that were passed. cheers, barneyb On 6/23/05, Smith, Daron [PA] <[EMAIL PROTECTED]> wrote: > 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 > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:210430 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
Re: CFINSERT Question
I think that they are there, but when using cfinsert, it doesn't display the actual values in the debug window, just like if you use cfqueryparam. How do you know that the insert isn't working? Smith, Daron [PA] wrote: > 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 > > > > > ~| 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:210429 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
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:210428 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