> Problem solved
>
> <cfset year2 = year(qry_getSampleState.dateFrom)>
> <cfset month2 = month(qry_getSampleState.dateFrom)>
> <cfset day2 = day(qry_getSampleState.dateFrom)>
> <cfset cov = qry_getSampleState.datefrom>
> <cfset cov=#createDate(year2,month2,day2)#>
>
> <cfset year1 = year(qry_getSampleState.dateTo)>
> <cfset month1 = month(qry_getSampleState.dateTo)>
> <cfset day1 = day(qry_getSampleState.dateTo)>
> <cfset dov = qry_getSampleState.dateTo>
> <cfset dov=#createDate(year1,month1,day1)#>
> did the trick
>
> -----Original Message-----
> From: John McCosker
> Sent: 28 March 2001 14:27
> To: '[EMAIL PROTECTED]'
> Subject: query update with dates
>
> Hi all,
>
> Can anyone help me with this,
>
> I am inserting dates into a database using the custom tag
> dateSelect,
>
> <cfset
> form.datefrom=#createDate(displayYear,displayMonth,displayDay)#>
> <cfset
> form.dateTo=#createDate(displayYearTo,displayMonthTo,displayDayTo)#>
>
> <cfquery name="qry_insertNewLog" datasource="#application.dsn#"
> username="#application.gateway#" password="#application.key#">
> INSERT INTO dbo.milfordLog (dt,
>
> Username,
>
> Status,
>
> Duration,
>
> sampleInterval,
>
> dateFrom,
>
> dateTo,
>
> timeFrom,
>
> timeTo)
> VALUES
> (#createODBCDateTime(now())#,
>
> '#session.checkMilfordLogin#',
>
> #databaseStatus#,
>
> #Duration#,
>
> #level#,
>
> #dateFrom#,
>
> #dateTo#,
>
> '#timeFrom#',
>
> '#timeTo#')
>
>
> </cfquery>
>
> thats fine,
>
> but if I update (I'm not changing the dates just one int field
> type)
>
> <cfquery name="qry_updateSampleState" datasource="#application.dsn#"
> username="#application.gateway#" password="#application.key#">
> UPDATE
> dbo.sampler_status
> SET
> Username='#qry_getSampleState.Username#',
>
> Status=#qry_getSampleState.Status#,
>
> Duration=#qry_getSampleState.Duration#,
>
> sampleInterval=#qry_getSampleState.sampleInterval#,
>
> dateFrom=#qry_getSampleState.dateFrom#,
>
> dateTo=#qry_getSampleState.dateTo#,
>
> timeFrom='#qry_getSampleState.timeFrom#',
>
> timeTo='#qry_getSampleState.timeTo#',
>
> location='#qry_getSampleState.location#'
> WHERE id = 1
> </cfquery>
>
> I get this error
>
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 6: Incorrect
> syntax near '00'.
> SQL = "UPDATE dbo.sampler_status SET Username='margaret ',
> Status=5.00, Duration=60.00, sampleInterval=1.00, dateFrom=28/03/01
> 00:00:00, dateTo=28/03/01 00:00:00, timeFrom='13:00 pm ', timeTo='14:00 pm
> ', location='inlet' WHERE id = 1"
>
> mmmmm puzzled I'd appreciate any help with this at all.
>
> John
> Derry (N.Ireland)
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
