[cfaussie] Re: LEFT JOIN in update cfquery
Try UPDATE TagtT_EFFDATEFINYRS SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] FROM TagtVS_EFFDATEupd LEFT JOIN TagtT_EFFDATEFINYRS ON TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno You might have to change the LEFT JOIN to a RIGHT JOIN now Pauline On Oct 23, 12:55 pm, Greavesy [EMAIL PROTECTED] wrote: Could someone please shed some light on a cfquery that I am working on. I am receiving a syntax error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'LEFT'. cfquery datasource=#application.Dsn_dev0eucActuary# UPDATE TagtT_EFFDATEFINYRS LEFT JOIN TagtVS_EFFDATEupd ON TagtT_EFFDATEFINYRS.AgentID = TagtVS_EFFDATEupd.agentno SET TagtT_EFFDATEFINYRS.NoOfPol0708 = [noofpol], TagtT_EFFDATEFINYRS.BPrem0708 = [baseprem] /cfquery Any guidance/help would be appreciated. --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Session Variables Stopped Working
I had a similar thing happen yesterday. I think my instance restarted itself and suddenly session variables weren't working. Our resident guru said to click Use J2EE session variables in CF Admin which apprently is not enabled by default when the server/instance starts On Oct 11, 1:29 pm, Dale Fraser [EMAIL PROTECTED] wrote: I have an app that was working yesterday and isn't today. I've pinned it down to session variables not working. I've checked the admin settings and restarted cf but still nothing. Take this example. cfif isDefined(session.me) cfoutput#session.me#/cfoutput cfelse Not Defined! cfdump var=#COOKIE# / /cfif cfset session.me = now() / I get the Not Defined, when refreshing the page. CFID and CFTOKEN does exist in the COOKIE dump and remain consistant across page refreshes. Anyone have a clue? Regards Dale Fraser http://learncf.com --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Session Variables Stopped Working
Andrew, Do you mean when the browser is closed rather than after each page request? I have J2EE session vars switched on and they only expire after the browser is closed. On Oct 11, 1:42 pm, Andrew Scott [EMAIL PROTECTED] wrote: When you use J2EE session variables, this forces CF to expire the session after each page request. As opposed to using the standard CFID CFToken. --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFAussie Community Head Count
ping --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Date format
Tom,
If you use the following, which is an extract from a component I wrote
to convert Active Directory account expiry filetime to utc time, you
get quite different results.
AD stores dates as nanoseconds since 1/1/1601, but I'd say that these
dates are probably seconds since 1/1/1970 or seconds from 30/12/1899,
so I've cut out the part that deals with nanoseconds! .
cfscript code snippet:
interimDate1 = DateAdd(s, 716640, 30/12/1899 00:00:00);
interimDate2 = DateAdd(s, 712672, 30/12/1899 00:00:00);
interimDate3 = DateAdd(s, 716640, 01/01/1970 00:00:00);
interimDate4 = DateAdd(s, 712672, 01/01/1970 00:00:00);
// Convert UTC to local.
convertedDate1 = createodbcdatetime(DateConvert(utc2local,
interimDate1));
convertedDate2 = createodbcdatetime(DateConvert(utc2local,
interimDate2));
convertedDate3 = createodbcdatetime(DateConvert(utc2local,
interimDate3));
convertedDate4 = createodbcdatetime(DateConvert(utc2local,
interimDate4));
If you output these dates you get you get the same actual days, but
different times.
{ts '1900-01-07 17:04:00'}
{ts '1900-01-07 15:57:52'}
{ts '1970-01-09 17:04:00'}
{ts '1970-01-09 15:57:52'}
Which date range do you think tour dobs are from? You should be able
to work out which one of these to use.
Doesn't quite make sense to me that both Excel and CF are showing the
date years 3862 and 3851. They have to be working in seconds maybe,
not days since a certain date.
Hope this helps.
Pauline
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---
