Yea that might be it .. i'll switch it up .. but wouldnt the error state THAT and not 'datatype mismatch' ??
----- Original Message ----- From: "dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, May 24, 2006 8:48 PM Subject: re: insert query error - ANY FIX IDEAS? > I think some of your table names are reserved words in access.. like (name). > I don't run access but I seem to recall Will having this problem. > > ~Dave the disruptor~ > > ---------------------------------------- > From: "Joe Velez" <[EMAIL PROTECTED]> > Sent: Wednesday, May 24, 2006 11:44 PM > To: CF-Talk <[email protected]> > Subject: insert query error - ANY FIX IDEAS? > > Here is a strange one. > > I'm running Access as the database. > > Before I get too much deeper the Format for the column is Yes/No (but the values are 1/0) -- So maybe I need to insert Yes or No instead of 1 or 0 ??? I'll try that .... > > I inserted "test" as a hard coded value in the last 2 columns sequentially testing because the error was thrown (bold) there, and as I went through each field adding hard coded values rather than dynamic data. So first ORDERED_BY was throwing an error, then SN_NUM and now OEM_SERIAL_NUM > > My query is processed in a loop querying data from a seperate database w/ the same columns -- inserting the data into the database I want to use. [hope that made sense] > > The set values for the failed query are as follows: [ looping, f = evaluate(f) > ] > > ADV_EXCH = 0 > BUS_DAYS_15 = > CAL_DAYS_15_20 = 2005-04-04 00:00:00.0 > CLASS_ID = HDD > COMMENTS = P=170=E=120=C=50 > CUSTOMER_NUM = 10029 > DOA = 1 > ID = 9397 > INVOICE_NUM = 12713 > ITEM_NUM = IBM08K9758E > LATE_BILLABLE = 0 > LOCATION = > NAME = SIEMENS > NTF = 0 > OEM_SERIAL_NUM = 0 > OPEN_BOX = 0 > OPEN_STATIC_BAG = 0 > ORDERED_BY = DENNIS > ORDER_DATE = 2005-03-16 00:00:00.0 > ORDER_NUM = 126018 > OUTSTANDING = 1 > PAYMENT_TYPE = 30 > PO_NUM = 6883712 > RA_NUM = 10029 > REASON = ADV-EX > RETURNED = 0 > RETURN_DATE = > SN_NUM = > SPECIAL = 0 > SURPLUS = 0 > > The query is: > > insert into return_authorization( > ra_num, > doa, > adv_exch, > surplus, > special, > order_date, > bus_days_15, > cal_days_15_20, > customer_num, > name, > location, > item_num, > class_id, > po_num, > reason, > return_date, > comments, > invoice_num, > order_num, > open_box, > open_static_bag, > oem_serial_num, > sn_num, > > ordered_by) > > values( > > '#ra_num#', > #doa#, > #adv_exch#, > #surplus#, > #special#, > '#dateformat(order_date, "mm/dd/yyyy")#', > '#bus_days_15#', > '#cal_days_15_20#', > '#customer_num#', > '#name#', > '#location#', > '#item_num#', > '#class_id#', > '#po_num#', > '#reason#', > '#dateformat(return_date, "mm/dd/yyyy")#', > '#comments#', > '#invoice_num#', > '#order_num#', > #open_box#, > #open_static_bag#, > '#oem_serial_num#', > 'test', > 'test') > > The error is: > > Error Executing Database Query. > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. > > The error occurred in F:\oemcfm\merge.cfm: line 68 > Called from F:\oemcfm\index.cfm: line 40 > Called from F:\oemcfm\merge.cfm: line 68 > Called from F:\oemcfm\index.cfm: line 40 > > 66 : #open_box#, > 67 : #open_static_bag#, > 68 : '#oem_serial_num#', > 69 : 'test', > 70 : 'test') > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241411 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
