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,VBDateTimeVBTime = 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
新聞熱點(diǎn)
疑難解答
圖片精選
