Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Page 2 of 2 1 2
 
Old August 11th, 2004, 12:26 PM
Authorized User
  
Join Date: Aug 2004
Posts: 86
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Hi Mahulda,
I tried this and got an error:-

"Format is not a recognized function name"

This time I need to format it in the sql command as I am not using a datagrid.
 
Old August 12th, 2004, 04:58 AM
Authorized User
  
Join Date: Feb 2004
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to mahulda
Default
Renu,
Even I was not using a datagrid.
Make Sure of the Single quotes and Double quotes

"SELECT JName, JCity, JState, Format(WorkDate,'dd-mm-yy') FROM tbl_Jurisdiction"


-.. -..
 
Old August 12th, 2004, 02:00 PM
Authorized User
  
Join Date: Aug 2004
Posts: 86
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Mahulda-
This is exactly what I am using and still getting the same error. I am wondering if I need to include/import something in my code?
 
Old August 13th, 2004, 03:13 PM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default
Mahulda,

I suppose your suggested solution pertains to Access DB. Format() works with access and not with SQL server.

I believe seeing this error ("Format is not a recognized function name"), Renu is using SQL server.

Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old August 16th, 2004, 04:36 AM
Authorized User
  
Join Date: Feb 2004
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to mahulda
Default
Vijay, Renu

MS Access it is .
I am not so sure what changes have to be made for SQL

-.. -..
 
Old August 16th, 2004, 02:05 PM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default
Mahulda,
Convert() is to be used with SQL server.

Renu,
It looks like you have initiated a post on another forum regarding this. If so, one can assume that this thread is closed.

Cheers!

_________________________
- Vijay G
Strive for Perfection
Page 2 of 2 1 2





Similar Threads
Thread Thread Starter Forum Replies Last Post
Time displayed with date! Please help Renu ASP.NET 1.0 and 1.1 Basics 18 August 20th, 2004 09:04 AM
Date and Time Displayed Together in DataGrid mahulda Classic ASP Databases 4 July 17th, 2004 11:03 PM
Date and Time Displayed Together in DataGrid mahulda ADO.NET 2 July 16th, 2004 04:43 AM
Not getting "time" displayed in the first example dotnetabhi VS.NET 2002/2003 6 March 27th, 2004 11:53 AM
time displayed damnnono_86 Access 2 November 28th, 2003 01:02 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.