Frank Rocco
|
| Posted: 06/14/2001, 10:14 AM |
|
Hello,
I have been going through the code and cannot see where the developer is
assigned to a case.
Is this not implemented?
Thanks
Frank
|
|
|
 |
Dr. Scott R. Senay
|
| Posted: 06/14/2001, 11:12 AM |
|
That happens in the admCaseResponse page when the administrator clicks on
the list box to assign a developer. The listbox is populated from the
"users" table and simply updates the assigned_to field in hte system. If
you open the responces form and check the properties of the field you'll see
how hte listbox is populated, this then when clicked on stores the value in
the "support_responses" table. CodeCharge is remarkably easy to use and in
some way so simple to make work that it can throw people off because it
really DOES make things that simple and easy. Under the covers they have
done an amazing job of dotting the "i"'s and crossing the "t"'s and I know
it threw me off at first...
Scott...
Frank Rocco <farocco@hotmail.com> wrote in message
news:9garct$ff8$1@mail.tankhill.com...
> Hello,
>
> I have been going through the code and cannot see where the developer is
> assigned to a case.
>
> Is this not implemented?
>
> Thanks
> Frank
>
>
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/14/2001, 11:38 AM |
|
Thanks Scott,
I cannot see how this screen is invoked. I tried locking or unlocking and
cannot get a screen that will allow me to assign a developer or reply to the
customer response.
What am I missing?
Thanks fro the help.
Frank
"Dr. Scott R. Senay" <drsenay@conceptech.com> wrote in message
news:9gauqa$is0$1@mail.tankhill.com...
> That happens in the admCaseResponse page when the administrator clicks on
> the list box to assign a developer. The listbox is populated from the
> "users" table and simply updates the assigned_to field in hte system. If
> you open the responces form and check the properties of the field you'll
see
> how hte listbox is populated, this then when clicked on stores the value
in
> the "support_responses" table. CodeCharge is remarkably easy to use and
in
> some way so simple to make work that it can throw people off because it
> really DOES make things that simple and easy. Under the covers they have
> done an amazing job of dotting the "i"'s and crossing the "t"'s and I know
> it threw me off at first...
>
> Scott...
>
>
>
>
>
> Frank Rocco <farocco@hotmail.com> wrote in message
>news:9garct$ff8$1@mail.tankhill.com...
> > Hello,
> >
> > I have been going through the code and cannot see where the developer is
> > assigned to a case.
> >
> > Is this not implemented?
> >
> > Thanks
> > Frank
> >
> >
> >
> >
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/14/2001, 1:32 PM |
|
I changed the following code below and it works. What is wrong with it?
Session ID matches.
' My Open event here
who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
ToSQL(GetParam("case_id"), "Number"))
if who_locked = 0 or who_locked <> Session("UserID") then
SetVar "FormResponse", ""
exit sub
end if
Changed to
' My Open event here
who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
ToSQL(GetParam("case_id"), "Number"))
if who_locked = 0 then
SetVar "FormResponse", ""
exit sub
end if
|
|
|
|
Dr. Scott R. Senay
|
| Posted: 06/14/2001, 4:45 PM |
|
Well to answer your first question, everything happens on the Response form,
when you change the value in the listbox for assigned to it saves that new
value to the database and sends an email to the developer you assigned the
case to. Ironically the reason you don't see anything happen is because
when you change the value in the listbox nothing does happen, it litteraly
writes the value and nothing else happens. When you then click on the Reply
button everything happens in the same After Insert event I've been
mentioning:
----------------------------------------------------------------------------
--------------------------------------------------------
if ($fldassigned_to != "") {
# Send email assigned developer
$subject = "You have assigned Case # $fldcase_id";
mail(dlookup("users", "user_email", "user_id=$fldassigned_to" ), $subject,
$supp_notif_body, "From:support@conceptech.com");
}
----------------------------------------------------------------------------
--------------------------------------------------------
Line one: if it IS assigned to someone execute the following
Line two: comment;
Line three: Populate the subject variable;
Line four: send mail to the assigned developer by doing a lookup on the
user_id to get his/her e-mail address with the subject, body and the from
address...
Line five: That's all folks...
Your second question is a bit more complex but at the highest level I think
you've confused it because it no longer knows who you are... By taking out
the session("UserID") it no longer knows who is working on the form so it
won't let you work on it... I have to look at it a bit more when I have a
moment to play with it... Sorry I don't have a more direct answer right off
the bat... One question though: Why did you modify it that way what were
you trying to do? This will make it easier for me to figure out what's
going on...
Hope this helps! Like I said to someone else earlier, CodeCharge is
actually SO EASY to work with you think there has to be a catch and that it
can't POSSIBLY be that simple... You are always looking for more work
because with ANYTHING else it ISN'T this easy...
Enjoy!
Scott...
Frank Rocco <farocco@hotmail.com> wrote in message
news:9gb71l$rds$1@mail.tankhill.com...
> I changed the following code below and it works. What is wrong with it?
> Session ID matches.
>
> ' My Open event here
> who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> ToSQL(GetParam("case_id"), "Number"))
> if who_locked = 0 or who_locked <> Session("UserID") then
> SetVar "FormResponse", ""
> exit sub
> end if
>
> Changed to
>
> ' My Open event here
> who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> ToSQL(GetParam("case_id"), "Number"))
> if who_locked = 0 then
> SetVar "FormResponse", ""
> exit sub
> end if
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/14/2001, 4:51 PM |
|
I took out the check for Session("UserID") because when I pressed the Lock
button, I did not get a response form to reply.
I am testing by creating my own case# and assigning to myself and then
trying to reply.
HTH
Thanks
Frank
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9gb71l$rds$1@mail.tankhill.com...
> I changed the following code below and it works. What is wrong with it?
> Session ID matches.
>
> ' My Open event here
> who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> ToSQL(GetParam("case_id"), "Number"))
> if who_locked = 0 or who_locked <> Session("UserID") then
> SetVar "FormResponse", ""
> exit sub
> end if
>
> Changed to
>
> ' My Open event here
> who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> ToSQL(GetParam("case_id"), "Number"))
> if who_locked = 0 then
> SetVar "FormResponse", ""
> exit sub
> end if
>
>
|
|
|
|
Dr. Scott R. Senay
|
| Posted: 06/14/2001, 6:08 PM |
|
Hello again Frank,
Ah yes, you might want to put that back in... You probably did get a form,
it just happens to be a the VERY bottom of the page/form... I was thrown
off by that too at first, but after looking at it I figured out was going
wrong... It dawns on me to ask, which version are you trying to work with?
The ASP version I got from the folks at CodeCharge seemed to install and
work but since my production server is PHP4 I got from them the almost ready
PHP version which had LOADS of troubles... I had to re-write portions of
it, and debug a bunch of other areas before mine would work. I never found
out of they had done further work on it but I do seem to recall that there
were chuncks that didn't work... Being the kind of person I was I just
ripped it open and did what needed to get it working, it is possible that
your code is similarly in need of repair... Let me know what you are using
and we can go from there...
Scott...
Frank Rocco <farocco@hotmail.com> wrote in message
news:9gbilj$5ru$1@mail.tankhill.com...
> I took out the check for Session("UserID") because when I pressed the Lock
> button, I did not get a response form to reply.
> I am testing by creating my own case# and assigning to myself and then
> trying to reply.
>
> HTH
>
> Thanks
>
> Frank
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9gb71l$rds$1@mail.tankhill.com...
> > I changed the following code below and it works. What is wrong with it?
> > Session ID matches.
> >
> > ' My Open event here
> > who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> > ToSQL(GetParam("case_id"), "Number"))
> > if who_locked = 0 or who_locked <> Session("UserID") then
> > SetVar "FormResponse", ""
> > exit sub
> > end if
> >
> > Changed to
> >
> > ' My Open event here
> > who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> > ToSQL(GetParam("case_id"), "Number"))
> > if who_locked = 0 then
> > SetVar "FormResponse", ""
> > exit sub
> > end if
> >
> >
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/15/2001, 5:44 AM |
|
Hi Scott,
I do all my coding in ASP.
I checked at the bottom, but there is no reply form.
locked does equal my id, so I'm not sure what is happening.
Thanks again
Frank
"Dr. Scott R. Senay" <drsenay@conceptech.com> wrote in message
news:9gbn6e$9g2$1@mail.tankhill.com...
> Hello again Frank,
>
> Ah yes, you might want to put that back in... You probably did get a
form,
> it just happens to be a the VERY bottom of the page/form... I was thrown
> off by that too at first, but after looking at it I figured out was going
> wrong... It dawns on me to ask, which version are you trying to work
with?
> The ASP version I got from the folks at CodeCharge seemed to install and
> work but since my production server is PHP4 I got from them the almost
ready
> PHP version which had LOADS of troubles... I had to re-write portions of
> it, and debug a bunch of other areas before mine would work. I never
found
> out of they had done further work on it but I do seem to recall that there
> were chuncks that didn't work... Being the kind of person I was I just
> ripped it open and did what needed to get it working, it is possible that
> your code is similarly in need of repair... Let me know what you are
using
> and we can go from there...
>
> Scott...
>
>
>
> Frank Rocco <farocco@hotmail.com> wrote in message
>news:9gbilj$5ru$1@mail.tankhill.com...
> > I took out the check for Session("UserID") because when I pressed the
Lock
> > button, I did not get a response form to reply.
> > I am testing by creating my own case# and assigning to myself and then
> > trying to reply.
> >
> > HTH
> >
> > Thanks
> >
> > Frank
> >
> > "Frank Rocco" <farocco@hotmail.com> wrote in message
> >news:9gb71l$rds$1@mail.tankhill.com...
> > > I changed the following code below and it works. What is wrong with
it?
> > > Session ID matches.
> > >
> > > ' My Open event here
> > > who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> > > ToSQL(GetParam("case_id"), "Number"))
> > > if who_locked = 0 or who_locked <> Session("UserID") then
> > > SetVar "FormResponse", ""
> > > exit sub
> > > end if
> > >
> > > Changed to
> > >
> > > ' My Open event here
> > > who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> > > ToSQL(GetParam("case_id"), "Number"))
> > > if who_locked = 0 then
> > > SetVar "FormResponse", ""
> > > exit sub
> > > end if
> > >
> > >
> >
> >
>
>
|
|
|
|
Dr. Scott R. Senay
|
| Posted: 06/15/2001, 5:56 AM |
|
Hum, very interesting... I'll try and get a look at the ASP version
sometime in the next day or so and get back to you... I know the version
running on the CodeCharge site is ASP, but that's about it... I load it up
on my NT server and see what I get...
Scott...
Frank Rocco <farocco@hotmail.com> wrote in message
news:9gcvvn$e84$1@mail.tankhill.com...
> Hi Scott,
>
> I do all my coding in ASP.
> I checked at the bottom, but there is no reply form.
> locked does equal my id, so I'm not sure what is happening.
>
> Thanks again
>
> Frank
>
> "Dr. Scott R. Senay" <drsenay@conceptech.com> wrote in message
>news:9gbn6e$9g2$1@mail.tankhill.com...
> > Hello again Frank,
> >
> > Ah yes, you might want to put that back in... You probably did get a
> form,
> > it just happens to be a the VERY bottom of the page/form... I was
thrown
> > off by that too at first, but after looking at it I figured out was
going
> > wrong... It dawns on me to ask, which version are you trying to work
> with?
> > The ASP version I got from the folks at CodeCharge seemed to install and
> > work but since my production server is PHP4 I got from them the almost
> ready
> > PHP version which had LOADS of troubles... I had to re-write portions
of
> > it, and debug a bunch of other areas before mine would work. I never
> found
> > out of they had done further work on it but I do seem to recall that
there
> > were chuncks that didn't work... Being the kind of person I was I just
> > ripped it open and did what needed to get it working, it is possible
that
> > your code is similarly in need of repair... Let me know what you are
> using
> > and we can go from there...
> >
> > Scott...
> >
> >
> >
> > Frank Rocco <farocco@hotmail.com> wrote in message
> >news:9gbilj$5ru$1@mail.tankhill.com...
> > > I took out the check for Session("UserID") because when I pressed the
> Lock
> > > button, I did not get a response form to reply.
> > > I am testing by creating my own case# and assigning to myself and then
> > > trying to reply.
> > >
> > > HTH
> > >
> > > Thanks
> > >
> > > Frank
> > >
> > > "Frank Rocco" <farocco@hotmail.com> wrote in message
> > >news:9gb71l$rds$1@mail.tankhill.com...
> > > > I changed the following code below and it works. What is wrong with
> it?
> > > > Session ID matches.
> > > >
> > > > ' My Open event here
> > > > who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> > > > ToSQL(GetParam("case_id"), "Number"))
> > > > if who_locked = 0 or who_locked <> Session("UserID") then
> > > > SetVar "FormResponse", ""
> > > > exit sub
> > > > end if
> > > >
> > > > Changed to
> > > >
> > > > ' My Open event here
> > > > who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
> > > > ToSQL(GetParam("case_id"), "Number"))
> > > > if who_locked = 0 then
> > > > SetVar "FormResponse", ""
> > > > exit sub
> > > > end if
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Frank Rocco
|
| Posted: 06/15/2001, 6:44 AM |
|
Hi Scott,
I solved the problem by using the CInt function:
' My Open event here
who_locked = DLookUp("support_cases", "locked_by", "case_id=" &
ToSQL(GetParam("case_id"), "Number"))
if CInt(who_locked = 0) or CInt(who_locked) <> CInt(Session("UserID"))
then
SetVar "FormResponse", ""
exit sub
end if
Thanks for your help.
Best Regards,
Frank
|
|
|
|
Don Orrell
|
| Posted: 06/15/2001, 6:54 AM |
|
Where did you get the demo_support application. I don't see it anywhere on
the Web site. I recently purchased the professional version. Although the
support page indicates that the support application is part of the
professional package, all I got was a serial number. I had to download the
Trial version and apply the serial number. I don't see the demo_support
anywhere.
Not complaining because I think it is a great program, I just want to know
what I am missing.
Don Orrell
dorrell@favoritenurses.com
"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9garct$ff8$1@mail.tankhill.com...
> Hello,
>
> I have been going through the code and cannot see where the developer is
> assigned to a case.
>
> Is this not implemented?
>
> Thanks
> Frank
>
>
>
>
|
|
|
|
Anthony Trotter
|
| Posted: 06/15/2001, 8:22 AM |
|
Don,
I think it is the "Bug Tracking" app. It would be in the same
directory as CodeCharge on your PC in the "Examples" folder.
"Don Orrell" <dorrell@favoritenurses.com> wrote in message
news:9gd42d$i80$1@mail.tankhill.com...
> Where did you get the demo_support application. I don't see it
anywhere on
> the Web site. I recently purchased the professional version.
Although the
> support page indicates that the support application is part of the
> professional package, all I got was a serial number. I had to
download the
> Trial version and apply the serial number. I don't see the
demo_support
> anywhere.
>
> Not complaining because I think it is a great program, I just want
to know
> what I am missing.
>
> Don Orrell
>dorrell@favoritenurses.com
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9garct$ff8$1@mail.tankhill.com...
> > Hello,
> >
> > I have been going through the code and cannot see where the
developer is
> > assigned to a case.
> >
> > Is this not implemented?
> >
> > Thanks
> > Frank
> >
> >
> >
> >
>
>
|
|
|
|
Eddy
|
| Posted: 06/15/2001, 8:40 AM |
|
Hi,
Try here,
http://www.codecharge.com/download/files/examples/demo_support.zip
Ed,
"Don Orrell" <dorrell@favoritenurses.com> wrote in message
news:9gd42d$i80$1@mail.tankhill.com...
> Where did you get the demo_support application. I don't see it anywhere
on
> the Web site. I recently purchased the professional version. Although
the
> support page indicates that the support application is part of the
> professional package, all I got was a serial number. I had to download
the
> Trial version and apply the serial number. I don't see the demo_support
> anywhere.
>
> Not complaining because I think it is a great program, I just want to know
> what I am missing.
>
> Don Orrell
>dorrell@favoritenurses.com
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9garct$ff8$1@mail.tankhill.com...
> > Hello,
> >
> > I have been going through the code and cannot see where the developer is
> > assigned to a case.
> >
> > Is this not implemented?
> >
> > Thanks
> > Frank
> >
> >
> >
> >
>
>
|
|
|
|
CodeCharge
|
| Posted: 06/16/2001, 12:45 PM |
|
Please look at the footer of http://support.codecharge.com
You may request our support application at http://support.codecharge.com
"Don Orrell" <dorrell@favoritenurses.com> wrote in message
news:9gd42d$i80$1@mail.tankhill.com...
> Where did you get the demo_support application. I don't see it anywhere
on
> the Web site. I recently purchased the professional version. Although
the
> support page indicates that the support application is part of the
> professional package, all I got was a serial number. I had to download
the
> Trial version and apply the serial number. I don't see the demo_support
> anywhere.
>
> Not complaining because I think it is a great program, I just want to know
> what I am missing.
>
> Don Orrell
>dorrell@favoritenurses.com
>
>
> "Frank Rocco" <farocco@hotmail.com> wrote in message
>news:9garct$ff8$1@mail.tankhill.com...
> > Hello,
> >
> > I have been going through the code and cannot see where the developer is
> > assigned to a case.
> >
> > Is this not implemented?
> >
> > Thanks
> > Frank
> >
> >
> >
> >
>
>
|
|
|
|
|
