- see footer for list info -<
that's fine, since GETDATE() is not passed in as a variable, so you
don't need to parameterize it
Shawn Fawcett wrote:
- see footer for list info -<
I managed to get this to work but is it safe without CFQUERYPARAM ?
UPDATE members
SET last_login = GETDATE()
WHERE memberID = <CFQUERYPARAM Value="#session.memberID#">
Shawn Fawcett wrote:
- see footer for list info -<
On the login action form once a member successfully logs in the field
last_login is updated.
Right now I use
set last_login = <CFQUERYPARAM Value="#now()#"
cfsqltype="CF_SQL_TIMESTAMP">
this goes into sql server 2005.
the coldfusion server is hosted in the UK. we don't want this time
Our sql server is on the west coast in Canada. we want this time.
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go
to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go
to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
