•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 402,578 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,252 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 811 | Replies: 1 | Solved
 |
•
•
Join Date: Mar 2007
Posts: 34
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
hi..
i've created a table named
urvey
my problem is regarding my DateCreated.. when system created through my page in aspx, the survey input are correctly stored in the database except for DateCreated where the whole table Column DateCreated changes its date to date at time the last survey was created....
my code for inserting in survey.aspx
where did i go wrong? please guide me..
i've created a table named
urveyCREATE TABLE [dbo].[Survey] (
[CustomerID] [int] NOT NULL ,
[SurveyID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[DateCreated] AS (getdate()) ,
[coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GOmy problem is regarding my DateCreated.. when system created through my page in aspx, the survey input are correctly stored in the database except for DateCreated where the whole table Column DateCreated changes its date to date at time the last survey was created....
my code for inserting in survey.aspx
Dim strTitle As String = title.Text
Dim strDescription As String = description.Text
sql2 = "INSERT INTO Survey(CustomerID,SurveyTitle,SurveyDescription) VALUES('" & Session("sCustomerID") & "','" & strTitle & "','" & strDescription & "')"
cmd2 = New SqlCommand(sql2, MyConnection)
cmd2.ExecuteNonQuery()
where did i go wrong? please guide me..
•
•
Join Date: Mar 2007
Posts: 34
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
ok..ok
finally i understand..
now i've changed my column DateCreated in MSSQL to accept null values..
and inside my form at ASP.NET..i've changed my sql statement to..
and now it's finally work..
finally i understand..
now i've changed my column DateCreated in MSSQL to accept null values..
and inside my form at ASP.NET..i've changed my sql statement to..
sql2 = "INSERT INTO Survey(CustomerID,SurveyTitle,SurveyDescription,DateCreated) VALUES('" & Session("sCustomerID") & "','" & strTitle & "','" & strDescription & "',CURRENT_TIMESTAMP)"and now it's finally work..
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Changing the system date (Motherboards, CPUs and RAM)
- SQL date problem (MS SQL)
- sorting flexgrid by date column (Visual Basic 4 / 5 / 6)
- editing the appearance of entries in a guestbook (HTML and CSS)
- How to erase Date Last Accessed Info (Windows NT / 2000 / XP / 2003)
Other Threads in the MS SQL Forum
- Previous Thread: Creating a SQL SERVER LOGIN
- Next Thread: text message via sql server 2005 to mobile phone
