Thanks Greg. I have tried both decimal and integer and bigint and number and double and so on. The version I posted is just one of very,very many. As you say in your followup, it may be something else. How else can I do what I am trying to do?
Greg Morphis wrote: > 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:301515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
