It may be from the consecutive delimiters (,,) CF treats consecutive delimiters as a single character.
On Tue, Feb 17, 2009 at 6:51 PM, SAMARIS Software <[email protected]>wrote: > > 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 <http://www.australianaccommodation.com/> > www.SAMARIS.NET <http://www.samaris.net/> > www.WebSiteSolutions.com.au <http://www.websitesolutions.com.au/> > Mobile: 0414 228 948 > > > > > > > -- "anything you say can/will be used against you-- --nothing you say can/will be used to help you." -Professor James Duane --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
