JavaScript is loosely typed. Database files are not. If you put text into a Boolean database column or a Boolean value into a date/time column, then you will get an error.
For the most part this is not a problem, except for
Take a look at the snippet below. (It's not part of our lesson, but I want you to look at it anyway.) Please notice
objConn.Open(strConnect) sql = "INSERT INTO FoloVisit (SessionID,VisitTime) " sql+= "Values ('" + Session.SessionID + "',#" + DateTime + "#);" objConn.Execute(sql)
DateTime has to be in a very particular format:
Get Started:
Below is the script for Lesson 20.
<%@LANGUAGE="JavaScript"%> <SCRIPT LANGUAGE="VBScript" RUNAT="Server"> Dim VBTime,VBDate,VBDateTime VBTime = Time & " " VBDate = Date & " " VBDateTime = Date & " " & Time </SCRIPT> <% function whatTimeIsIt() { var m=new Date() var minute=m.getMinutes() var second=m.getSeconds() var ampm=false if (minute >=0 && minute < 10) { minute=("0" + minute) } if (second >= 0 && second < 10 ) { second=("0" + second) } var hours=m.getHours() if (hours > 12) { ampm=true hours=hours-12 } if (hours==12) { ampm=true } if (hours == 0) { hours=hours+12 ampm=false } if (ampm) { ampm=" PM" } else { ampm=" AM" } var myTime=hours + ":" + minute + ":" + second + ampm return myTime; } var DateTime = new Date(); var Month = (DateTime.getMonth() + 1) + "/"; var Day = DateTime.getDate() + "/"; var Year = DateTime.getFullYear(); var JustTheDate = Month + Day + Year; var JustTheTime = whatTimeIsIt(); var DateTime = Month + Day + Year + " " + whatTimeIsIt(); Response.Write("<HTML>\r") Response.Write("<STRONG>JavaScript Time</STRONG><BR>\r") Response.Write("The date in proper database format is: " + JustTheDate + "<BR>\r") Response.Write("The time in proper database format is: " + JustTheTime + "<BR>\r") Response.Write("The date & time together are: " + DateTime + "<BR>\r") Response.Write("<HR>\r") Response.Write("<STRONG>VBScript Time</STRONG><BR>\r") Response.Write("The date in proper database format is: " + VBDate + "<BR>\r") Response.Write("The time in proper database format is: " + VBTime + "<BR>\r") Response.Write("The date & time together are: " + VBDateTime + "<BR>\r") Response.Write("</HTML>") %>
Click Here to run the script in a new window.
Living on VBScript Time:
The other way to solve the problem is to use the VBScript date and time Objects. What can I say? If you can't beat 'em, steal from 'em!
Time For a Tangent:
If all you want to do is store
That's the end of the lesson plan. I have received messages from all over the world. Thank you for your kind words. If you have questions or comments you can click onto the link for the home page and then there's a link to contact me.
数据库设计范式 一、范式概念 设计关系数据库时遵从不同的规范要求设计出合理的...
啰嗦的话,不多说,我们直接开始部署,我相信有点linux基础的人都能看得懂。 Mys...
1.我该努力了,不为别的,就为了以后我想要的东西,我会自己给自己。 2.有些人...
【莫烦Python】Threading 学会多线程 Python 【2021最新版】Python 并发编程实战...
压缩工具中的神器: 压缩比高,速度快,性能好 1. 工具介绍 主要介绍 zstd 工具的...
HTML meta viewport属性说明 什么是Viewport 手机浏览器是把页面放在一个虚拟的...
IEEE Spectrum 根据以下数据来源,对各大编程语言的使用普及率进行了统计。 1)...
Angular 中常用的指令有用来遍历的 *ngFor 、控制元素显示隐藏的 *ngIf ,今天学...
代码演示如下: 方法一 php function encryptDecrypt($key, $string, $decrypt){...
工程结构 工程分为两部分,bilibili-api是api接口服务,其他是前端的部分,工程...