<CFQUERY datasource="#ds#" username="#un#" password="#pw#"
NAME="daily_housekeeping_report">
select *
from hsk_rpt.csv
</CFQUERY>
<cfset unit_number=#ToString(daily_housekeeping_report.unit)#>
<CFQUERY datasource="#ds#" username="#un#" password="#pw#"
NAME="insert_daily_hsk_report">
insert into Housekeeping_Activities (date,
day,
month,
year,
unit_number,
room_status)
values (#createodbcdatetime(ausdate_time)#,
#dateformat(ausdate_time, 'dd')#,
#dateformat(ausdate_time, 'mm')#,
#dateformat(ausdate_time, 'yy')#,
'#unit_number#',
'#room_status#')
</cfquery>
the values are being taken from a csv file which has just been uploaded to
the server
as mentioned earlier its only a problem when the unit number ends in a
letter that's when it stores as blank
if the unit number starts with a letter or else is numeric then it stores
correctly
and yes when I look at the csv file itself the values are all there
thanks for your assistance with this
Regards
Claude Raiola
B.Econ (Acc), B.Hot.Mngt.
Websites:
www.AustralianAccommodation.com
www.SAMARIS.NET
www.WebSiteSolutions.com.au
Mobile: 0414 228 948
-----Original Message-----
From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf
Of Chris Velevitch
Sent: Wednesday, 18 February 2009 11:21 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Problems Uploading CSV data into SQL table
On Wed, Feb 18, 2009 at 11:47, SAMARIS Software <rai...@ozemail.com.au>
wrote:
> the file to the server space and then I read the file and import data into
> the sql server table via traditional cfquery insert.
Can you show us some code?
Chris
--
Chris Velevitch
Manager - Adobe Platform Users Group, Sydney
m: 0415 469 095
www.apugs.org.au
Adobe Platform Users Group, Sydney
Feb '09 meeting: Hands On Cairngorm Basics
Date: Mon 23rd Feb 6pm for 6:30 start
Details and RSVP on http://groups.adobe.com/posts/d094878396
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
