Prostate Cancer Treatment Overview
   

Prostate Cancer
Treatment Guide


 

Treatment
Description
Prostate Cancer
Patient Profile
Prostate Cancer
Treatments
Prostate Cancer
Survival Rates
Prostate Cancer
Side Effects

Brachytherapy

Prostate Brachytherapy

Minimally invasive radiation therapy implants low or high dose radiation (LDR or HDR) seeds in the prostate. Prostate Brachytherapy

Minimally invasive radiation therapy implants low or high dose radiation (LDR or HDR) seeds in the prostate.

click to learn more

Prostate Seed Implant

Brachytherapy seeds are more effective for younger patients in good health with localized prostate cancer. Prostate Seed Implant

Brachytherapy seeds are more effective for younger patients in good health with localized prostate cancer.

click to learn more

Prostate Seed Implant

Minimally invasive surgery lasts 1-2 hours with a possible overnight stay; most return to normal activities in a few days. Prostate Seed Implant

Minimally invasive surgery lasts 1-2 hours with a possible overnight stay; most return to normal activities in a few days.

click to learn more

Brachytherapy
Survival Rates

Multiple long-term brachytherapy studies have found recurrence-free survival rates of 77 to 93%. Brachytherapy
Survival Rates

Multiple long-term brachytherapy studies have found recurrence-free survival rates of 77 to 93%.

click to learn more

Brachytherapy
Side Effects

Possible bleeding at the minimally invasive site, blood in the urine, scrotal burning, incontinence, or impotence. Brachytherapy
Side Effects

Possible bleeding at the minimally invasive site, blood in the urine, scrotal burning, incontinence, or impotence.

click to learn more

Chemotherapy

Prostate Chemotherapy

Chemotherapy may be used in advanced prostate cancer, if the disease has extended to other parts of the body. Prostate Chemotherapy

Chemotherapy may be used in advanced prostate cancer, if the disease has extended to other parts of the body.

click to learn more

Recurrent Prostate Cancer

Recurrent prostate cancer that has stopped responding to treatment may benefit from chemotherapy. Recurrent
Prostate Cancer

Recurrent prostate cancer that has stopped responding to treatment may benefit from chemotherapy.

click to learn more

Salvage Chemotherapy

Chemotherapy is administered orally, or by a computerized pump, or by frequent injections at a doctor’s office. Salvage Chemotherapy

Chemotherapy is administered orally, or by a computerized pump, or by frequent injections at a doctor’s office.

click to learn more

Effects
of Chemotherapy

Chemotherapy may relieve pain and slow tumor growth in advanced stages of prostate cancer. Effects
of Chemotherapy

Chemotherapy may relieve pain and slow tumor growth in advanced stages of prostate cancer.

click to learn more

Chemotherapy
Side Effects

Chemotherapy may cause nausea, hair loss, vomiting, and mouth sores. Chemotherapy
Side Effects

Chemotherapy may cause nausea, hair loss, vomiting, and mouth sores.

click to learn more

Cryosurgery &
Cryotherapy

Prostate Cryotherapy

Also called cryotherapy, this minimally invasive procedure uses needles to apply freezing gases to the prostate. Prostate Cryotherapy

Also called cryotherapy, this minimally invasive procedure uses needles to apply freezing gases to the prostate.

click to learn more

Cryosurgery Patients

Cryosurgery is used for patients with localized cancer, external radiation recurrent cancer, Gleason scores under 6, or PSA levels under 10. Cryosurgery Patients

Cryosurgery is used for patients with localized cancer, external radiation recurrent cancer, Gleason scores under 6, or PSA levels under 10.

click to learn more

Minimally Invasive Surgery

Cryosurgery takes about 2 hours with a possible overnight admission. Minimally Invasive
Surgery

Cryosurgery takes about 2 hours with a possible overnight admission.

click to learn more

Cryosurgery
Survival Rates

Long-term clinical results are limited but promising. Cryosurgery
Survival Rates

Long-term clinical results are limited but promising.

click to learn more

Cryosurgery
Side Effects

Side effects may include moderate pelvic pain, blood in urine, scrotal swelling, mild urinary urgency, and impotence. Cryosurgery
Side Effects

Side effects may include moderate pelvic pain, blood in urine, scrotal swelling, mild urinary urgency, and impotence.

click to learn more

Hormone
Therapy

Prostate Hormone Therapy

Prostate hormone therapy suppresses, blocks, or eliminates testosterone to slow the tumor’s growth. Prostate Hormone
Therapy

Prostate hormone therapy suppresses, blocks, or eliminates testosterone to slow the tumor’s growth.

click to learn more

Hormone Therapy Uses

Therapy can slow the tumor’s growth or lower a PSA level; it may be used before, during, or after other treatment. Hormone Therapy Uses

Therapy can slow the tumor’s growth or lower a PSA level; it may be used before, during, or after other treatment.

click to learn more

Shrinking the Prostate

Surgical castration patients return home the day of the surgery. Treatment is given orally or by injection. Shrinking the Prostate

Surgical castration patients return home the day of the surgery. Treatment is given orally or by injection.

click to learn more

Hormone
Therapy Effects

Hormone therapy does not destroy cancer but research has shown effectiveness in enhancing other treatments. Hormone
Therapy Effects

Hormone therapy does not destroy cancer but research has shown effectiveness in enhancing other treatments.

click to learn more

Hormone Therapy
Side Effects

May cause impotence, weight gain, hot flashes, fatigue, loss of muscle mass; and hormone “flare” in LHRH use. Hormone Therapy
Side Effects

May cause impotence, weight gain, hot flashes, fatigue, loss of muscle mass; and hormone “flare” in LHRH use.

click to learn more

Radiation
Therapy

Prostate Radiation Therapy

EBRT or electron beam radiation therapy aims external radiation at prostate cancer cells. Prostate Radiation
Therapy

EBRT or electron beam radiation therapy aims external radiation at prostate cancer cells.

click to learn more

Using Radiation Therapy

IMRT and 3D-CRT are newer versions of EBRT and are non-invasive. Using Radiation Therapy

IMRT and 3D-CRT are newer versions of EBRT and are non-invasive.

click to learn more

Radiation Treatment

Radiation therapy generally requires 5 treatments per week over 6-8 weeks. Radiation Treatment

Radiation therapy generally requires 5 treatments per week over 6-8 weeks.

click to learn more

External Radiation Outcomes

Multiple long- and short-term studies indicate success rates over 85% especially when used with other therapies. External Radiation
Outcomes

Multiple long- and short-term studies indicate success rates over 85% especially when used with other therapies.

click to learn more

Radiation
Side Effects

May include tiredness, diarrhea, skin irritation, upset stomach, frequent or burning urination, and proctitis. Radiation
Side Effects

May include tiredness, diarrhea, skin irritation, upset stomach, frequent or burning urination, and proctitis.

click to learn more

Prostatectomy

Prostate Surgery

Prostatectomy is the removal of the prostate by surgical incisions in abdomen or perineum, or small incisions and laparoscope use. Prostate Surgery

Prostatectomy is the removal of the prostate by surgical incisions in abdomen or perineum, or small incisions and laparoscope use.

click to learn more

Prostatectomy Patients

Prostatectomy carries surgical risks and possible side effects so is usually recommended only for younger patients who are in otherwise good health. Prostatectomy Patients

Prostatectomy carries surgical risks and possible side effects so is usually recommended only for younger patients who are in otherwise good health.

click to learn more

Prostate Removal

Length of prostatectomy surgeries, recovery times, and hospital stays vary according to specific prostatectomy procedure. Prostate Removal

Length of prostatectomy surgeries, recovery times, and hospital stays vary according to specific prostatectomy procedure.

click to learn more

Prostatectomy
Survival Rates

Multiple long-term studies indicate recurrence-free success rates over 90%. Prostatectomy
Survival Rates

Multiple long-term studies indicate recurrence-free success rates over 90%.

click to learn more

Risks of
Prostatectomy

Surgical complications, impotence, or incontinence may occur. Risks of
Prostatectomy

Surgical complications, impotence, or incontinence may occur.

click to learn more

Robotic
Prostatectomy

Robotic Prostatectomy

Robotic prostate surgery is a minimally invasive procedure involving the removal of the prostate and surrounding cancerous tissue.Robotic Prostate Surgery

Robotic prostatectomy surgery is a minimally invasive procedure involving the removal of the prostate and surrounding cancerous tissue.

click to learn more

Learn More

Robotic Prostatectomy Patients

Minimally invasive robotic surgery is reserved only for patients whose cancer is confined to the prostate gland. Robotic Prostatectomy Patients

Minimally invasive robotic surgery is reserved only for patients whose cancer is confined to the prostate gland.

click to learn more

Learn More

Prostate Removal

During a robotic prostatectomy, surgeon-controlled robotic arms are used to remove the prostate gland. Robotic Prostate Removal

During a robotic prostatectomy, surgeon-controlled robotic arms are used to remove the prostate gland.

click to learn more

Learn More

Robotic Prostatectomy Outcomes

Clinical research indicates comparable surgical outcomes when compared to traditional retropubic procedures.Robotic Prostatectomy
Survival Rates

Clinical research indicates comparable surgical outcomes when compared to traditional retropubic procedures.

click to learn more

Learn More

Risks of Robotic Prostate Removal

Impotence, incontinence, blood loss, and other surgical complications are known risk factors of robotic prostate removal. Risks of Robotic-Assisted
Prostatectomy

Impotence, incontinence, blood loss, and other surgical complications are known risk factors of robotic prostate removal.

click to learn more

Learn More

Watchful
Waiting

Watchful Waiting

Also called expectant therapy, patient undergoes careful monitoring instead of more aggressive therapy. Watchful Waiting

Also called expectant therapy, patient undergoes careful monitoring instead of more aggressive therapy.

click to learn more

Expectant Therapy Patients

Recommended to those with low Gleason and PSA levels, and nonpalpable tumors. Expectant Therapy
Patients

Recommended to those with low Gleason and PSA levels, and nonpalpable tumors.

click to learn more

Monitoring and Care

Expectant therapy includes regular visits to a doctor for prostate specific antigen (PSA) tests and digital rectal exams. Monitoring and Care

Expectant therapy includes regular visits to a doctor for prostate specific antigen (PSA) tests and digital rectal exams.

click to learn more

Watchful Waiting Outcomes

Because prostate cancer is usually slow-growing, many men opt for and benefit from watchful waiting. Watchful Waiting
Outcomes

Because prostate cancer is usually slow-growing, many men opt for and benefit from watchful waiting.

click to learn more

Risks of
Watchful Waiting

Cancer may grow between monitoring visits and quickly spread to other parts of the body. Risks of
Watchful Waiting

Cancer may grow between monitoring visits and quickly spread to other parts of the body.

click to learn more

Complementary
and
Alternative Medicine

Complementary & Alternative Medicine

Complementary and alternative treatment for prostate cancer explores non-orthodox modalities of patient care. Complementary & Alternative
Medicine Patients

Complementary and alternative treatment for prostate cancer explores non-orthodox modalities of patient care.

click to learn more

more

CAM Patient Criteria

The decision to explore complementary and alternative prostate cancer treatment is often a personal one. CAM Patient Criteria
The decision to explore complementary and alternative prostate cancer treatment is often a personal one.

click to learn more

more

CAM Treatment

CAM treatments include, but are not limited to, prostate cancer diets, mind-body practices, and alternative medical systems. CAM Treatment

CAM treatments include, but are not limited to, prostate cancer diets, mind-body practices, and alternative medical systems.

click to learn more

more

Clinical CAM Evidence

Clinical evidence concerning  complementary and alternative medicine's role as a valid prostate cancer treatment option.
Clinical CAM Evidence

Clinical evidence concerning complementary and alternative medicine's role as a valid prostate cancer treatment option.

click to learn more

Risks of CAM

Known risk factors include lack of clinical evidence and the potential of  harmful treatment interactions.
Risks of CAM

Known risk factors include lack of clinical evidence and the potential of harmful treatment interactions.

click to learn more

more

High Intensity
Focused
Ultrasound (HIFU)

HIFU Description

Minimally invasive procedure that uses ultrasound waves to heat and destroy affected tissues within the prostate.HIFU Description

Minimally invasive procedure that uses ultrasound waves to heat and destroy affected tissues within the prostate.

click to learn more

more

HIFU Patients

Most effective for patients with Stage I or II prostate cancer or whose cancer recurs locally after radiation therapy.HIFU Patients
Most effective for patients with Stage I or II prostate cancer or whose cancer recurs locally after radiation therapy.

click to learn more

more

HIFU Procedure

Ultrasound waves are directed at the prostate, and the temperature is rapidly elevated to ablate the affected tissue.HIFU Procedure

Ultrasound waves are directed at the prostate, and the temperature is rapidly elevated to ablate the affected tissue.

click to learn more

more

HIFU Survival Rates

A high percentage of men with localized prostate cancer, who use HIFU, are successfully treated while maintaining continence.
HIFU Survival Rates

A high percentage of men with localized prostate cancer, who use HIFU, are successfully treated while maintaining continence.

click to learn more

Side effects of HIFU

After a HIFU procedure, patients may experience frequent and/or urgent urination, mild discomfort, or discharge.
Side effects of HIFU

After a HIFU procedure, patients may experience frequent and/or urgent urination, mild discomfort, or discharge.

click to learn more

more

Emerging Technologies

Emerging Technology Description

Alternative treatments for prostate cancer are emerging from advances in technology.Emerging Technology Description

Alternative treatments for prostate cancer are emerging from advances in technology.

click to learn more

more

Emerging Technology Patients

Emerging technologies could be one of the best options for patients who haven't responded to other forms of treatment.Emerging Technology Patients
Emerging technologies could be one of the best options for patients who haven't responded to other forms of treatment.

click to learn more

more

Emerging Technology Procedure

Emerging technologies for prostate cancer treatment: What are they?Emerging Technology Procedure

Emerging technologies for prostate cancer treatment: What are they?

click to learn more

more

Emerging Technology Survival Rates

As technology advances, so do the chances of prostate cancer survival and prevention.
Emerging Technology Survival Rates

As technology advances, so do the chances of prostate cancer survival and prevention.

click to learn more

more

Side effects of Emerging Technology

Alternative healing therapies are being researched in clinical trials to find a way to treat prostate cancer.
Side effects of Emerging Technology

Alternative healing therapies are being researched in clinical trials to find a way to treat prostate cancer.

click to learn more

more
 
 

Coping with Prostate Cancer      Are You at Risk for Prostate Cancer?      Prostate Cancer News     Glossary

 Home     Contact Us     Disclaimer    Privacy Policy     Resources     Add URL      Site Map

 
 
 

The Prostate Cancer Treatment Guide is a comprehensive source of prostate cancer information that is written plainly and organized conveniently into a chart. The simple layout of this guide will ease the daunting task of learning about treatments after receiving a prostate cancer diagnosis. The guide is not a substitution for a doctor, but its complete and easy-to-understand information will prepare readers for the journey ahead.

If you, or someone you love, have received a diagnosis, or you are wondering if you are at risk, the Prostate Cancer Treatment Guide is a valuable resource.

 
 
 

Prostate Cancer Treatment Overview
This year in the United States, there will be over 230,000 new prostate cancer diagnoses, making prostate cancer the most common type of cancer affecting men. Chances are either you or someone you know will develop the disease.

Prostate Cancer Definition: The Glossary
The Prostate Cancer Treatment Guide provides the most comprehensive glossary of prostate cancer information available on the Internet. PCTG definitions describe the meaning of the term you want and then explain how the term relates to prostate cancer.

 
 

Time: 5/17/12 8:16 AM
Error - struct
Cause
Error - struct
ErrorCode 0
Message java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time
SQLState S1009
StackTrace java.sql.SQLException: java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.getTimeFromBytes(ResultSet.java:6195) at com.mysql.jdbc.ResultSet.getTimeInternal(ResultSet.java:6227) at com.mysql.jdbc.ResultSet.getTime(ResultSet.java:5814) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:5032) at com.intergral.fusionreactor.jdbc.g.getObject(ResultSetSurrogate.java:553) at coldfusion.sql.QueryTable.populate(QueryTable.java:352) at coldfusion.sql.QueryTable.populate(QueryTable.java:217) at coldfusion.sql.Executive.getRowSet(Executive.java:466) at coldfusion.sql.Executive.executeQuery(Executive.java:1252) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfshowRSS2ecfm2098856818.runPage(C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:280) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm754682338.runPage(C:\sites\prostate-cancer\prostate-cancer\index.cfm:1374) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376) at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 30
RAW_TRACE at cfshowRSS2ecfm2098856818.runPage(C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm:30)
TEMPLATE C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFMODULE
LINE 1374
RAW_TRACE at cfindex2ecfm754682338.runPage(C:\sites\prostate-cancer\prostate-cancer\index.cfm:1374)
TEMPLATE C:\sites\prostate-cancer\prostate-cancer\index.cfm
TYPE CFML
Type java.sql.SQLException
DataSource dsProstateCancer
Detail java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time
ErrorCode S1009
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
Error - struct
ErrorCode 0
Message java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time
SQLState S1009
StackTrace java.sql.SQLException: java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.getTimeFromBytes(ResultSet.java:6195) at com.mysql.jdbc.ResultSet.getTimeInternal(ResultSet.java:6227) at com.mysql.jdbc.ResultSet.getTime(ResultSet.java:5814) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:5032) at com.intergral.fusionreactor.jdbc.g.getObject(ResultSetSurrogate.java:553) at coldfusion.sql.QueryTable.populate(QueryTable.java:352) at coldfusion.sql.QueryTable.populate(QueryTable.java:217) at coldfusion.sql.Executive.getRowSet(Executive.java:466) at coldfusion.sql.Executive.executeQuery(Executive.java:1252) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfshowRSS2ecfm2098856818.runPage(C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:280) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm754682338.runPage(C:\sites\prostate-cancer\prostate-cancer\index.cfm:1374) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376) at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 30
RAW_TRACE at cfshowRSS2ecfm2098856818.runPage(C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm:30)
TEMPLATE C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFMODULE
LINE 1374
RAW_TRACE at cfindex2ecfm754682338.runPage(C:\sites\prostate-cancer\prostate-cancer\index.cfm:1374)
TEMPLATE C:\sites\prostate-cancer\prostate-cancer\index.cfm
TYPE CFML
Type java.sql.SQLException
SQLState S1009
Sql select * from pcifeed ORDER BY DATE(feeddate) DESC, TIME(feedtime) DESC ;
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583) at cfshowRSS2ecfm2098856818.runPage(C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63) at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:280) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661) at cfindex2ecfm754682338.runPage(C:\sites\prostate-cancer\prostate-cancer\index.cfm:1374) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376) at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.getTimeFromBytes(ResultSet.java:6195) at com.mysql.jdbc.ResultSet.getTimeInternal(ResultSet.java:6227) at com.mysql.jdbc.ResultSet.getTime(ResultSet.java:5814) at com.mysql.jdbc.ResultSet.getObject(ResultSet.java:5032) at com.intergral.fusionreactor.jdbc.g.getObject(ResultSetSurrogate.java:553) at coldfusion.sql.QueryTable.populate(QueryTable.java:352) at coldfusion.sql.QueryTable.populate(QueryTable.java:217) at coldfusion.sql.Executive.getRowSet(Executive.java:466) at coldfusion.sql.Executive.executeQuery(Executive.java:1252) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) ... 39 more
TagContext
Error - array
1
Error - struct
COLUMN 0
ID CFQUERY
LINE 30
RAW_TRACE at cfshowRSS2ecfm2098856818.runPage(C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm:30)
TEMPLATE C:\sites\prostate-cancer\prostate-cancer\news\showRSS.cfm
TYPE CFML
2
Error - struct
COLUMN 0
ID CFMODULE
LINE 1374
RAW_TRACE at cfindex2ecfm754682338.runPage(C:\sites\prostate-cancer\prostate-cancer\index.cfm:1374)
TEMPLATE C:\sites\prostate-cancer\prostate-cancer\index.cfm
TYPE CFML
Type Database
queryError java.sql.SQLException: Value '00:00:00 can not be represented as java.sql.Time
where [empty string]
cgi - struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE [empty string]
CERT_SECRETKEYSIZE [empty string]
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER [empty string]
CERT_SERVER_SUBJECT [empty string]
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH C:\sites\prostate-cancer\prostate-cancer\index.cfm
CONTENT_LENGTH 0
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE [empty string]
HTTPS_SECRETKEYSIZE [empty string]
HTTPS_SERVER_ISSUER [empty string]
HTTPS_SERVER_SUBJECT [empty string]
HTTP_ACCEPT text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING gzip
HTTP_ACCEPT_LANGUAGE en-us,en;q=0.5
HTTP_CONNECTION close
HTTP_COOKIE [empty string]
HTTP_HOST www.prostate-cancer.com
HTTP_REFERER [empty string]
HTTP_USER_AGENT CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO /index.cfm
PATH_TRANSLATED C:\sites\prostate-cancer\prostate-cancer\index.cfm
QUERY_STRING [empty string]
REMOTE_ADDR 38.107.179.221
REMOTE_HOST 38.107.179.221
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /index.cfm
SERVER_NAME www.prostate-cancer.com
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/7.0
WEB_SERVER_API [empty string]
Form - struct [empty]
URL - struct [empty]
request - struct
cfdumpinited false
error
request - struct
MESSAGE [empty string]
VALID true
loginerrormessage [empty string]
session - struct
cfid 9399978
cftoken 80a56ab0258178f9-5ABA4FDC-B4E7-AA03-9B8B2318F66C00B9
sessionid PROSTATECANCEROPTIMIZATIONSITE_9399978_80a56ab0258178f9-5ABA4FDC-B4E7-AA03-9B8B2318F66C00B9
urltoken CFID=9399978&CFTOKEN=80a56ab0258178f9-5ABA4FDC-B4E7-AA03-9B8B2318F66C00B9
user
session - component CFC.Users
        extends CFC.dbsettings
USERLASTNAME [empty string]
USERID [empty string]
USERFAX [empty string]
USERZIPCODE [empty string]
LASTLOGINDATETIME [empty string]
USERNAME [empty string]
USERPHONEALT [empty string]
USERPHONE [empty string]
OBJECTUSERTYPE
session - component cfc.Usertype
        extends CFC.dbsettings
OBJECTSNAME [empty string]
DSN dsProstateCancer
DELETED 0
USERTYPEID 5ABA4FDD-ED3C-D6B1-E7B424767247BECF
USERTYPEDEFAULT 0
DBPASS [empty string]
DBUSER [empty string]
SLASH \
ISNEWUSERTYPE TRUE
USERTYPENAME [empty string]
DBTYPE mysql
METHODS
SETUSERTYPENAME
session - function SetuserTypeName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERTYPENAME
session - function GetuserTypeName
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
FLUSHUSERTYPETODATABASE
session - function FlushUSERTYPEToDatabase
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
CREATEUSERTYPEDROPDOWN
session - function createUserTypeDropdown
Arguments:
Name Required Type Default
userTypeID Optional string [empty string]
fieldIDName Optional string usertypeName
className Optional string text
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISUSERTYPENEW
session - function IsUserTypeNew
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDSN
session - function getDSN
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETEUSERTYPE
session - function DeleteUSERTYPE
Arguments:
Name Required Type Default
userTypeID Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDBPASS
session - function getDBPass
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETDELETED
session - function SetDeleted
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETOBJECTSNAME
session - function SetObjectsName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERTYPEID
session - function SetuserTypeID
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
LISTUSERTYPE
session - function ListUSERTYPE
Arguments:
Name Required Type Default
userTypeID Optional string [empty string]
userTypeName Optional string [empty string]
userTypeDefault Optional string [empty string]
ReturnType: query
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERTYPEDEFAULTID
session - function getUserTypeDefaultID
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CHECKUSERTYPE
session - function CheckUSERTYPE
Arguments:
Name Required Type Default
userTypeID Optional string [empty string]
userTypeName Optional string [empty string]
limit Optional string [empty string]
ReturnType: boolean
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERTYPEID
session - function GetuserTypeID
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDBTYPE
session - function getDBType
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISMSSQL
session - function isMSSQL
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETDBUSER
session - function getDBUser
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
session - function init
Arguments:none
ReturnType: struct
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
GETSLASH
session - function getSlash
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETUSERTYPEADMINID
session - function getUserTypeAdminID
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETDELETED
session - function GetDeleted
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETOBJECTSNAME
session - function GetObjectsName
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
INITUSERTYPE
session - function InitUSERTYPE
Arguments:
Name Required Type Default
userTypeID Optional string [empty string]
ReturnType: struct
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERTYPENAMEFROMID
session - function getUserTypeNamefromID
Arguments:
Name Required Type Default
userTypeID Required string  
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
USERSTATE [empty string]
DBPASS [empty string]
PASSWORD [empty string]
USERISADMIN FALSE
USERCITY [empty string]
USEREMAIL [empty string]
USERADDRESS1 [empty string]
DELETED 0
USERFIRSTNAME [empty string]
LOGGEDIN FALSE
ADDEDDATETIME {ts '2012-05-17 08:16:28'}
USERTYPEID 23B7CB4B-B9A9-10ED-8D9FEDA5958681A6
SESSIONID [empty string]
DBTYPE mysql
USERCOUNTRY [empty string]
USERMIDDLENAME [empty string]
DSN dsProstateCancer
USERADDRESS2 [empty string]
SLASH \
LASTUPDATEDATETIME [empty string]
DBUSER [empty string]
METHODS
GETUSERCOUNTRY
session - function GetUserCountry
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSEREMAIL
session - function GetUserEmail
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERLASTNAME
session - function SetuserLastName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERLASTNAME
session - function GetuserLastName
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERCOUNTS
session - function GetuserCounts
Arguments:none
ReturnType: query
Roles:  
Access: remote
Output: No
DisplayName:  
Hint:  
Description:  
GETPASSWORD
session - function GetPassword
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETLASTLOGINDATETIME
session - function GetLastLoginDateTime
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERNAME
session - function GetUserName
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDBUSER
session - function getDBUser
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETDELETED
session - function SetDeleted
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDSN
session - function getDSN
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETUSERADDRESS2
session - function GetUserAddress2
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERCITY
session - function SetUserCity
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETCURRENTSEARCH
session - function getCurrentSearch
Arguments:none
ReturnType: query
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
GETUSERFIRSTNAME
session - function GetUserFirstName
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERADDRESS1
session - function GetUserAddress1
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERID
session - function SetUserID
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERNAME
session - function SetUserName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETCURRENTSEARCHQUERY
session - function getCurrentSearchQuery
Arguments:none
ReturnType: struct
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
GETCURRENTOBJECTSNAME
session - function getCurrentObjectsName
Arguments:none
ReturnType: string
Roles:  
Access: remote
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERSSEARCH
session - function getusersSearch
Arguments:
Name Required Type Default
stForm Required struct  
startRow Optional numeric 0
maxRows Optional string 25
orderBy Optional string UserID
orderByOrder Optional string ASC
ReturnType: query
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
SETUSERFIRSTNAME
session - function SetUserFirstName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERFAX
session - function SetUserFax
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERMIDDLENAME
session - function GetUserMiddleName
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
DELETEUSERS
session - function Deleteusers
Arguments:
Name Required Type Default
UserID Required string  
ReturnType: struct
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
INITUSERS
session - function Initusers
Arguments:
Name Required Type Default
UserID Optional string [empty string]
SessionID Optional string [empty string]
ReturnType: struct
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETSLASH
session - function getSlash
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETCURRENTOBJECTSNAME
session - function setCurrentObjectsName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: remote
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERSSTRUCT
session - function GetusersStruct
Arguments:
Name Required Type Default
UserID Required string  
ReturnType: struct
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERSTATE
session - function GetUserState
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
ISMSSQL
session - function isMSSQL
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
USEREXISTS
session - function userExists
Arguments:
Name Required Type Default
UserID Required string  
ReturnType: boolean
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERTYPEID
session - function GetUserTypeID
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETCURRENTSESSIONID
session - function getCurrentSessionID
Arguments:none
ReturnType: string
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
SETLOGGEDIN
session - function SetLoggedIn
Arguments:none
ReturnType: void
Roles:  
Access: remote
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERPHONE
session - function GetuserPhone
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETADDEDDATETIME
session - function SetAddedDateTime
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETOBJECTUSERTYPE
session - function getObjectUserType
Arguments:none
ReturnType: ANY
Roles:  
Access: remote
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERZIPCODE
session - function GetUserZipcode
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETCURRENTSEARCH
session - function setCurrentSearch
Arguments:
Name Required Type Default
searchresults Required query  
ReturnType: string
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
ISLOGGEDIN
session - function isLoggedIn
Arguments:none
ReturnType: boolean
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
SETALLUSERS
session - function setAllusers
Arguments:
Name Required Type Default
UserID Required string  
ReturnType: boolean
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETCURRENTSEARCHQUERY
session - function setCurrentSearchQuery
Arguments:
Name Required Type Default
searchquery Required struct  
ReturnType: string
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
GETUSERCITY
session - function GetUserCity
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
ISUSERNEW
session - function IsuserNew
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDBPASS
session - function getDBPass
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETUSERZIPCODE
session - function SetUserZipcode
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERCOUNTRY
session - function SetUserCountry
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
ISVALIDUSER
session - function isValidUser
Arguments:
Name Required Type Default
loginname Required string  
passCode Required string  
ReturnType: boolean
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
LISTUSER
session - function ListUSER
Arguments:
Name Required Type Default
UserID Optional string [empty string]
UserName Optional string [empty string]
Password Optional string [empty string]
UserFirstName Optional string [empty string]
userLastName Optional string [empty string]
UserMiddleName Optional string [empty string]
UserAddress1 Optional string [empty string]
UserAddress2 Optional string [empty string]
UserCity Optional string [empty string]
UserState Optional string [empty string]
UserZipcode Optional string [empty string]
UserCountry Optional string [empty string]
UserEmail Optional string [empty string]
userPhone Optional string [empty string]
UserPhoneAlt Optional string [empty string]
UserFax Optional string [empty string]
UserTypeID Optional string [empty string]
AddedDateTime Optional string [empty string]
LastLoginDateTime Optional string [empty string]
LastUpdateDateTime Optional string [empty string]
Deleted Optional string [empty string]
orderBy Optional string UserID
orderByOrder Optional string ASC
isLoggingIn Optional boolean false
ReturnType: query
Roles:  
Access: remote
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERFAX
session - function GetUserFax
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
INIT
session - function init
Arguments:none
ReturnType: struct
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
GETUSERPHONEALT
session - function GetUserPhoneAlt
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETLASTUPDATEDATETIME
session - function GetLastUpdateDateTime
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSEREMAIL
session - function SetUserEmail
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERADDRESS1
session - function SetUserAddress1
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERSTATE
session - function SetUserState
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDELETED
session - function GetDeleted
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERTYPEID
session - function SetUserTypeID
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETDBTYPE
session - function getDBType
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETPASSWORD
session - function SetPassword
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETUSERID
session - function GetUserID
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETCURRENTSEARCHRESULTS
session - function getCurrentSearchResults
Arguments:
Name Required Type Default
startRow Optional numeric 1
maxRows Optional string [empty string]
ReturnType: query
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
ISADMIN
session - function isAdmin
Arguments:none
ReturnType: boolean
Roles:  
Access: remote
Output: false
DisplayName:  
Hint:  
Description:  
SETUSERMIDDLENAME
session - function SetUserMiddleName
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERADDRESS2
session - function SetUserAddress2
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
FLUSHUSERTODATABASE
session - function FlushUSERToDatabase
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETLASTUPDATEDATETIME
session - function SetLastUpdateDateTime
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERPHONE
session - function SetuserPhone
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETLASTLOGINDATETIME
session - function SetLastLoginDateTime
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
SETUSERPHONEALT
session - function SetUserPhoneAlt
Arguments:
Name Required Type Default
name Required string  
ReturnType: void
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description:  
GETADDEDDATETIME
session - function GetAddedDateTime
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: No
DisplayName:  
Hint:  
Description: