www.webdeveloper.com
Results 1 to 4 of 4

Thread: A real challenge (asp.net)

  1. #1
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222

    A real challenge (asp.net)

    I have been trying to update a date in a data base when a user enters a site using today(). Well ribeyed and eye were working on getting this to work but it will not, my sql statement is fine without the date feild, but when I try to update a date it gives me a syntax error. Anyone have a theory or a good source code I can look at to figure this out?

  2. #2
    Join Date
    Nov 2002
    Location
    London UK
    Posts
    154
    What type of database are you using? Databases handle dates differently, for instance SQL Server wants dates enclosed in single quotes, but Access wants dates enclosed in hash (#) symbols. You should check the documentation of the DBMS you're using to see how your particular DBMS handles dates. That's the best I can offer you without seeing your code and knowing which DBMS you're using.

  3. #3
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222
    well right now I am using an access mdb but I will probably move to an sql data base in a little while when I get motivated to transfer all the data. So I should put it in the # #
    what should be put inbetween the ## I am using a today() to get the current system date. I am saying label1.text = today() then I am doing in my sql statement replace label1.text bla bla bla, and that feild in the data base I have tested it as a date feild and as a text feild, show me part of an sql statement so I can see what you mean.

  4. #4
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222
    I am using asp.net not asp by the way...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles