Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MichelleB
Starting Member
8 Posts |
 Posted - 2014-01-21 : 23:29:32
|
| hi i have inherited a sql database to work on and cannot seen to fix this error. its an availability calendar and at the end of each month a new month is generated, it by default makes all dates unavailable but i need them available. is this done in the database as a default??if a member has logged in recently then the avails populate fine but if they have not logged in for a while then they all show unavailable? it doesnt make sense to me?? please point me in the right direction to look for this |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-01-21 : 23:35:32
|
quote:
its an availability calendar and at the end of each month a new month is generated, it by default makes all dates unavailable but i need them available. is this done in the database as a default?? is this done in the database as a default??
Not sure. It maybe a default value defined in the table's column or it maybe done by the application. Post the query that perform the new month generation and we can have a look at it.quote:
if a member has logged in recently then the avails populate fine but if they have not logged in for a while then they all show unavailable? it doesnt make sense to me??
You can run the Profiler to see what is the query that does this.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
MichelleB
Starting Member
8 Posts |
Posted - 2014-01-22 : 00:29:16
|
| how do i run profiler, i am logged into mysql and have found the table that holds the dates for the calendar buti do not know what creates the dates that are added into this table? is it done by a script a page or by the database?? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-01-22 : 01:06:08
|
you are not using MS SQL Server ? This site is on Microsoft SQL Server. If you are using mysql, try posting at dbforums.com
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
generating new month in calendar issue