drpcken
Posts: 60
|
| Posted: 02/15/2005, 11:47 AM |
|
I've been working on it, but now everytime I try to load it, i get a
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
error.
I raised the timeout time in IIS, but I'm wondering also if anyone has gotten this to successfully work?
Thanks!
|
 |
 |
Benjamin Krajmalnik
|
| Posted: 02/17/2005, 1:32 PM |
|
I am using it without any problems.
It worked "as-is", but in my design had some issues - it was writing
directly using response.write instead of buffering it into a variable to be
assigned to the label field on the form.
I made the necessary changes, extended its functionality quite a bit, and am
using it without any problems.
If you want to see it implemented, go to http://www.illumen.com/dealer
log in with login = 1, password = test
Go to the Calendar tab. Tou can see it in action.
All my apps allow the user to select a theme, so my version of the calndar
has been "themed".
|
|
|
|
drpcken
Posts: 60
|
| Posted: 02/17/2005, 1:47 PM |
|
awesome work man! everything works fine on it for me, except when i go to the DayView page, it gives an ASP 500 Error. I'm about to setup asp to show me the errors of it. But did you have any problems with the DayView side?
Thanks for the reply, if you don't mind i might contact you for more questions.
Thank you!!
kenny
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 02/22/2005, 12:39 PM |
|
I don't think that the day view functinoality was working. That is one of
the things which I extended on it.
"drpcken" <drpcken@forum.codecharge> wrote in message
news:6421511074eae2@news.codecharge.com...
> awesome work man! everything works fine on it for me, except when i go to
the
> DayView page, it gives an ASP 500 Error. I'm about to setup asp to show
me the
> errors of it. But did you have any problems with the DayView side?
>
> Thanks for the reply, if you don't mind i might contact you for more
> questions.
>
> Thank you!!
> kenny
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 02/22/2005, 12:40 PM |
|
By all means contact me if you need to.
|
|
|
|
drpcken
Posts: 60
|
| Posted: 02/23/2005, 1:33 PM |
|
Hey ben thank you!!
I'd like to contact you. Could you please email me I have a few questions if you dont' mind!
kenny(at)cbsmemphis(dot)com
thanks!
|
|
|
|
wayner
Posts: 37
|
| Posted: 02/24/2005, 8:08 AM |
|
Do you download the code when you order the ASP calendar from CCS Dev Mag? Or do you have to follow the magazine directions and create your own calendar?
Not knowing what you got for the money was one reason I never bought an issue.
Wayne
_________________
Have it your way, sort of!
1. You can have it fast.
2. You can have it cheap.
3. You can have it accurate.
Pick 2 out of the 3! |
|
|
|
dataobjx
Posts: 181
|
| Posted: 02/25/2005, 5:53 AM |
|
Source Code is supplied for all articles in CCS Developer Magazine.
When you download the free issue, you can see that this is the case.
Thank you for your interest in CCS Developer Magazine and remember that should you encounter any difficulties with the code from the magazine you can write to administrator@dataobjx.net for assistance.
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
|
wayner
Posts: 37
|
| Posted: 02/28/2005, 6:20 AM |
|
Just for reference; the free issue only gives you the PDF file and no code samples. But I did purchase the other issues and am working with the samples.
Thanks,
Wayne
_________________
Have it your way, sort of!
1. You can have it fast.
2. You can have it cheap.
3. You can have it accurate.
Pick 2 out of the 3! |
|
|
|
wayner
Posts: 37
|
| Posted: 02/28/2005, 6:28 AM |
|
I've been working on it as well and everytime I try to load it, i get an error:
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
error.
Will the DataObjx people bef fixing the issue? Or at least chime in on the problem?
Thanks,
Wayne
_________________
Have it your way, sort of!
1. You can have it fast.
2. You can have it cheap.
3. You can have it accurate.
Pick 2 out of the 3! |
|
|
|
Sean
Posts: 39
|
| Posted: 02/28/2005, 6:43 AM |
|
I had the same problems with the calendar back in December. After speaking with Martin at DataObjx, this is the solution:
------------------------------------------------------------------------------------------------
In the event_categories table add a field called css_class
In the events table add a field called dept_id
If you don't have a departments table, you may want to create one.
This will allow users to view corporate wide, department wide, etc.
In the Calendar_Events.asp page - modify "Function lblCalendar_BeforeShow()" as below - near line 130
'IF MS SQL SERVER
' sSQL = sSQL & "('" & dteToday & "' BETWEEN date_start AND date_end) OR "
' sSQL = sSQL & "('" & dteStart & "' BETWEEN date_start AND date_end) OR "
' sSQL = sSQL & "('" & dteEnd & "' BETWEEN date_start AND date_end) OR "
' sSQL = sSQL & "(date_start BETWEEN '" & dteStart & "' AND '" & dteEnd & "') OR "
' sSQL = sSQL & "(date_end BETWEEN '" & dteStart & "' AND '" & dteEnd & "') "
'IF MS ACCESS
sSQL = sSQL & "(#" & dteToday & "# BETWEEN date_start AND date_end) OR "
sSQL = sSQL & "(#" & dteStart & "# BETWEEN date_start AND date_end) OR "
sSQL = sSQL & "(#" & dteEnd & "# BETWEEN date_start AND date_end) OR "
sSQL = sSQL & "(date_start BETWEEN #" & dteStart & "# AND #" & dteEnd & "#) OR "
sSQL = sSQL & "(date_end BETWEEN #" & dteStart & "# AND #" & dteEnd & "#) "
|
|
|
|
dataobjx
Posts: 181
|
| Posted: 02/28/2005, 5:36 PM |
|
It's also important to note that one can receive a time-out if you're using a connection name other than DBIntranet.
If you have a situation where you're getting a sql time-out, have a look at your settings and determine the name you gave for your projects db connection.
Then, in the code, make sure you change any calls to DBIntranet or clsDBIntranet to your connections name. E.g., CCDLookup calls, etc.
It's easy to overlook.
If you have any issues I'm happy to reply here, but don't check-in as often as I perhaps should. Thus, it's alway best to send an email to administrator@dataobjx.net to ensure that your communication is promptly replied to.
Hope this helps... it's likely to be the problem in the event of a timeout.
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
|
dataobjx
Posts: 181
|
| Posted: 02/28/2005, 5:44 PM |
|
For instance notice in function below;
Function SelectData(vSQL, vReturnDataRS)
Dim cn
Dim rs
Dim pkID
Dim sFunctionName
'... used by error message
sFunctionName="SelectData()"
SelectData = False 'Assume Failure
'If vSQL was not passed in, exit the function
If Len(vSQL) = 0 Then Exit Function
'Create a new database connection object
'replace clsDBIntranet with the class name for your projects connection
Set cn=New clsDBIntranet
cn.Open
Set rs = cn.Execute(vSQL)
If cn.Errors.Count = 0 Then
If NOT rs.EOF Then
Set vReturnDataRS = rs
Else
Set vReturnDataRS = NOTHING
End If
Else
Response.Write "<font color=""red""><b>WARNING! </b></font><font color=""darkgreen""><b>" & sFunctionName & "</b></font> returned errors...<br>"
Response.Write "<font color=""red"">" & vSQL & "</b></font>"
cn.Errors.Clear
Response.End
End If
End Function
Also, it should be noted that a number of response.write's were utilzed for the magazine, but should never be utilized for production applications.
However, we left these in many places - perhaps too many to save you the trouble of typing them out yourself if you were having issues.
Therefore, if you are transporting this code to a production application, sure, leave the response.writes in while you test it before release... but then, delete them or remark them out.
Let me know if you have any other issues. Glad to help.
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
|
Benjamin Krajmalnik
|
| Posted: 03/01/2005, 9:05 AM |
|
The calendar code was not meant to be a plug and play but rather a good
example of how to implement a calendar.
There will always be code inherent to your own data structures.
I worked about 1 hour on it to get it to do what I wanted. The largest
change was modifying the code where it would return a value containing the
entire HTML instead of doing direct response.writes. I had to do this due
to the layout of my application, which uses CSS div's with relative
positioning.
|
|
|
|
wayner
Posts: 37
|
| Posted: 03/04/2005, 6:34 AM |
|
The calendar is now working.
Some how the connect ion name was DBIntranet in Calendar.asp and DBDBIntranet throughout the ViewEvent.asp.
Thanks to everyone for their input.
Wayne
_________________
Have it your way, sort of!
1. You can have it fast.
2. You can have it cheap.
3. You can have it accurate.
Pick 2 out of the 3! |
|
|
|
