you definitely don't want to use CLOB... That's a Character Large OBject.. meaning don't use that unless you need to store LARGE amounts of data, larger than 4000 characters (on Oracle, may be a different size for Access). If they're both numeric values use cf_sql_type = "cf_sql_number" or decmial or even integer What error are you getting? I didnt see it posted but may have missed it
On Tue, Mar 18, 2008 at 11:43 AM, pauld581 <[EMAIL PROTECTED]> wrote: > Hello everyone. > > I am relatively new to CF but not new to development. I am working on a > small project that requires processing form inputs for insertion into an > Access 2007 db. The version of CF I am on is CF MX-7.0.2. On one form > there are two list boxes that allow multiple selections and that's where > I am getting my problem. The multiselect list boxes need to be inserted > into a linking table and the values that need to be inserted are the > selections themselves plus the other foreign key required to maintain > integrity. To get this number (Student_ID) I have a small function that > grabs the last value put into the Student_ID PK field. > > That number is paired with the multiple selection in an insertion loop > and put into the db.All of this works perfectly except it doesn't... and > it's driving me crazy. > > Here's one of the literally hundreds of variations I have tried. The > error is always on the same line: > > <cfset var lastID="#getLastID()#"> > <cfloop index="i" list="#form.mnuInsStatus#" delimiters=","> > <cfdump var="#i#"> > <cfdump var="#lastID#"> > <cfquery name="newstatus" datasource="#request.eltcdata#"> > insert into Student_Status (Student_ID,Status_ID) > values (<cfqueryparam value="#lastID#" cfsqltype="cf_sql_clob">, > <cfqueryparam value="#i#" cfsqltype="cf_sql_char">) > </cfquery> > </cfloop> > > The thing is, those dumps there have EXACTLY the right values. The CF > debug shows that all of the multiple selections are making it into > the function and the PK is correct. > > 1 //the "i" value > query - Top 1 of 1 Rows > EXPR1 > 1 104 > > //the PK > > MNUINSSTATUS=1,2,3,4,5 > > > As you can see the value is a simple int - nothing tricky. A meta dump > from that Access table indicates that > the value CF want s there is type INT but I have tried all or nearly all > of the cf-sql types. > I have also tried not using the CFqueryparam thing at all but that > doesn't work. As I have said I have tried > hundreds of variations and I am at my wit's end. I really hope someone > can help me out here as I am sort of stalled > until I get this figured out and there are multiple selections involved > in this project. > > Thanks, > Paul > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
