The following is an extract from a txt / csv file I import into my sql database
095,2 Bdrm S,Clean House,,WRIGHT x2 095A,Hotel,Svc Daily,18/02/2009,ANGELL x1 096,2 Bdrm S,Dirty Departs,,EVANS x4 096A,Hotel,Svc Daily,18/02/2009,SOUCE x2 097,2 Bdrm S,Dirty Departs,,WENCESLAUS x2 097,2 Bdrm S,Dirty Arrives,,. x2 097A,Hotel,Svc Daily,18/02/2009,BLACKLEY x2 098,2 Bdrm S,Clean Vacant,, 098A,Hotel,Svc Daily,18/02/2009,MOIR x2 099,2 Bdrm S,Clean House,,MAGUIRE x4 100,2 Bdrm S,Clean Vacant,, 101,2 Bdrm S,Clean Arrives,,COOKE x2 the first column is unit number all the data inserts into the table row by row however when there is a letter at the end of the unit number that field remains blank in the database even though its present in the data file if there is a letter at the front of the unit number eg w1255 then the value is recorded any idea what causes the value to record blank when there is a charcter at the end of the unit number but if there is no character in the number or the character is at the beginning it records correctly the field type for unit number in the sql table is nvchar I reassign each unit value using <cfset unit_number=#ToString(daily_housekeeping_report.unit)#> to force before the insert query for each record being uploaded Regards Claude Raiola B.Econ (Acc), B.Hot.Mngt. Websites: www.AustralianAccommodation.com www.SAMARIS.NET www.WebSiteSolutions.com.au Mobile: 0414 228 948 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---