Click here to Skip to main content
16,010,114 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: IE Back button Pin
Paul Watson17-Feb-02 22:34
sitebuilderPaul Watson17-Feb-02 22:34 
Generalxml Pin
Mazdak14-Feb-02 9:23
Mazdak14-Feb-02 9:23 
GeneralRe: xml Pin
markkuk14-Feb-02 19:50
markkuk14-Feb-02 19:50 
GeneralRe: xml Pin
Mazdak14-Feb-02 19:53
Mazdak14-Feb-02 19:53 
GeneralSession does not work Pin
Mazdak13-Feb-02 22:13
Mazdak13-Feb-02 22:13 
GeneralRe: Session does not work Pin
omkamal14-Feb-02 4:04
omkamal14-Feb-02 4:04 
GeneralRe: Session does not work Pin
Mazdak14-Feb-02 4:31
Mazdak14-Feb-02 4:31 
GeneralAdding dates to a database Pin
Xavier Shay13-Feb-02 14:33
Xavier Shay13-Feb-02 14:33 
I'm trying to create a forums site, and I would like to add a date to all posts. At the moment I have the following code:

SQLStmt = "INSERT INTO Messages (ForumID, ParentID, PosterID, Title, Body, Date) "
SQLStmt = SQLStmt & " VALUES (" & forumID & ", " & parentID & ", " & userID & ", '" & subject & "', '" & message & "', #" & Date() & "#)"
set RS = conn.Execute(SQLStmt)

Which when expanded prints something like:
INSERT INTO Messages (ForumID, ParentID, PosterID, Title, Body, Date) VALUES (22, 0, 1, 'Test', 'Test Text', #2/14/2002#)

This all works fine if I exclude the Date Field. The most descriptive error I get is:

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.

Any help would be greatly appreciated
- X
GeneralRe: Adding dates to a database Pin
Konstantin Vasserman13-Feb-02 17:01
Konstantin Vasserman13-Feb-02 17:01 
GeneralRe: Adding dates to a database Pin
Xavier Shay14-Feb-02 23:43
Xavier Shay14-Feb-02 23:43 
GeneralRe: Adding dates to a database Pin
15-Feb-02 20:08
suss15-Feb-02 20:08 
GeneralUsing ocx in intranet Pin
12-Feb-02 22:26
suss12-Feb-02 22:26 
GeneralRe: Using ocx in intranet Pin
12-Feb-02 23:02
suss12-Feb-02 23:02 
GeneralNetscape file upload problem Pin
AG12-Feb-02 19:30
AG12-Feb-02 19:30 
GeneralMinimizing the Browser Window Pin
Paul Watson11-Feb-02 23:27
sitebuilderPaul Watson11-Feb-02 23:27 
GeneralRe: Minimizing the Browser Window Pin
Konstantin Vasserman12-Feb-02 18:14
Konstantin Vasserman12-Feb-02 18:14 
GeneralRe: Minimizing the Browser Window Pin
Paul Watson12-Feb-02 20:02
sitebuilderPaul Watson12-Feb-02 20:02 
GeneralRe: Minimizing the Browser Window Pin
Nish Nishant12-Feb-02 18:29
sitebuilderNish Nishant12-Feb-02 18:29 
GeneralASP blocks in XML Pin
Paul Watson11-Feb-02 22:12
sitebuilderPaul Watson11-Feb-02 22:12 
GeneralRe: ASP blocks in XML Pin
Paul Watson11-Feb-02 22:33
sitebuilderPaul Watson11-Feb-02 22:33 
GeneralSystem.Web.HttpBrowserCapabilities Pin
Wictor Wilén11-Feb-02 21:20
Wictor Wilén11-Feb-02 21:20 
Questionis cold fusion the only way to do a login system? Pin
tbbooher11-Feb-02 9:53
tbbooher11-Feb-02 9:53 
AnswerRe: is cold fusion the only way to do a login system? Pin
Jon Sagara11-Feb-02 10:01
Jon Sagara11-Feb-02 10:01 
GeneralRe: is cold fusion the only way to do a login system? Pin
tbbooher11-Feb-02 12:15
tbbooher11-Feb-02 12:15 
GeneralRe: is cold fusion the only way to do a login system? Pin
Jon Sagara11-Feb-02 13:09
Jon Sagara11-Feb-02 13:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.