Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.javascript > #21977

Re: Date to MS Access

Show all headers | View raw

Andrew Poulos wrote:

> I have an MS Access field of type Date/Time with no specific format set.
> Here Access dates appear in this type of format
>    12/11/2013 7:57:46 AM
> 
> I need to take a date from the client side and pass it via a posted form
> to an ASP page running JScript.
> 
> On the client I have
>    var nowDate = new Date();
> 
> On the server I have
> 
> var d = ... // nowDate retrieved from the form

The part that is missing from your question is how you get “nowDate” into 
the form.
 
> var SQLstr = "UPDATE myTable " +
>               "Set tbl_Date=#" + d +"# " +
>               "WHERE myID=1;";

Hopefully you clean your input so that SQL injection like

  d = "12/11/2013 7:57:46 AM#; DELETE myTable;"
    + " UPDATE myTable SET tbl_Date=12/11/2013 7:57:46 AM";

is prevented.  The proper approach is Prepared Statements, but apparently MS 
JetSQL does not support that; you could emulate it.
 
> Running it though results in a "500: Internal Server Error".
> 
> How do I "format" the date on the client so that its valid SQL for Access?

You could use Date.prototype.strftime("%d/%m/%Y %I:%M:%S %p") as provided by 
JSX:string/date.js [1] on the client side, but I would strongly recommend to 
pass a timestamp (Date.prototype.getTime()) and let the server-side code do 
the SQL formatting (in which case I would be interested to know if date.js 
worked there if there is no ASP-native way).

(Pseudo-)integers are safer, and you do not want to update the client-side 
code when you change the database on the server.

[1] <http://PointedEars.de/scripts/test/date>

-- 
PointedEars

Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.

Back to comp.lang.javascript | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Date to MS Access Andrew Poulos <ap_prog@hotmail.com> - 2013-11-12 11:05 +1100
  Re: Date to MS Access Andrew Poulos <ap_prog@hotmail.com> - 2013-11-12 11:34 +1100
  Re: Date to MS Access Christoph Michael Becker <cmbecker69@arcor.de> - 2013-11-12 01:35 +0100
  Re: Date to MS Access Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-11-12 01:57 +0100
    Re: Date to MS Access Andrew Poulos <ap_prog@hotmail.com> - 2013-11-12 14:38 +1100
      Re: Date to MS Access Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-11-12 13:21 +0100
        Re: Date to MS Access Andrew Poulos <ap_prog@hotmail.com> - 2013-11-12 23:42 +1100
  Re: Date to MS Access "Michael Haufe (TNO)" <tno@thenewobjective.com> - 2013-11-11 17:41 -0800

csiph-web