Ask a Question related to ASP Database, Design and Development.
-
Baiju K U #1
Set a datetime field to Null
Hi
I created a record set at client side and added a coulmn as date time
DBRS = CreateObject("ADODB.RecordSet")
DBRS.Fields.Append "Updation_Date",adDateTime
How can I set a this field as nullable ?
Thanks
Baiju
Baiju K U Guest
-
NULL To DateTime field through sp
How can I insert null value into a datetime field through stored procedure? i use cybase,cf 4 -
Separated date and time or one datetime field
Hi all, I am learning php+mysql and am trying to set up a log database. I wonder if it is better to have 2 different columns for date and time... -
update row with null numeric or datetime dataset cell values in a datagrid
I keep getting the, now, dreaded "System.FormatException: String was not recognized as a valid DateTime" error when updating a datagrid row that has... -
get week from date/datetime field
Hi, I have a very basic quesetion but I can't find any answer by myself. Is it possible to extract number of week from date/datetime column?... -
dateTime = Null problem
Hi All, I have an object that ahs a property of time dateTime, this property is set to the contents of a DateTime field in the database(SQL... -
Baiju K U #2 Set a datetime field to Null
Hi
I created a record set at client side and added a coulmn as date time
DBRS = CreateObject("ADODB.RecordSet")
DBRS.Fields.Append "Updation_Date",adDateTime
How can I set a this field as nullable ?
Thanks
Baiju
Baiju K U Guest
-
Ray at #3 Re: Set a datetime field to Null
[url]www.aspfaq.com/5003[/url]
Ray at home
"Baiju K U" <baiju@indus-systems.com> wrote in message
news:u9Az%23cukDHA.3732@tk2msftngp13.phx.gbl...> Hi
>
> I created a record set at client side and added a coulmn as date time
>
> DBRS = CreateObject("ADODB.RecordSet")
> DBRS.Fields.Append "Updation_Date",adDateTime
>
> How can I set a this field as nullable ?
>
>
> Thanks
> Baiju
>
>
Ray at Guest
-
Bob Barrows #4 Re: Set a datetime field to Null
Baiju K U wrote:
Use the attrib argument of the Append method:> Hi
>
> I created a record set at client side and added a coulmn as date time
>
> DBRS = CreateObject("ADODB.RecordSet")
> DBRS.Fields.Append "Updation_Date",adDateTime
>
> How can I set a this field as nullable ?
>
[url]http://msdn.microsoft.com/library/en-us/ado270/htm/mdamth01_2.asp[/url]
--
HTH,
Bob Barrows - ASP MVP
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Bob Barrows Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
