<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var accessbarrier__MMColParam1 = "access"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam1 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam2 = "barriers"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam2 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam3 = "cultural barriers"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam3 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam4 = "cultural competency"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam4 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam5 = "cross-cultural care"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam5 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam6 = "outreach"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam6 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam7 = "language"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam7 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier__MMColParam8 = "communication"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { accessbarrier__MMColParam8 = String(Request("MM_EmptyValue")); } %> <% var accessbarrier = Server.CreateObject("ADODB.Recordset"); accessbarrier.ActiveConnection = MM_lit_STRING; accessbarrier.Source = "SELECT * FROM AAPI_HEALTH_LIT WHERE Keywords LIKE '%"+ accessbarrier__MMColParam1.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam2.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam3.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam4.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam5.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam6.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam7.replace(/'/g, "''") + "%' OR Keywords LIKE '%"+ accessbarrier__MMColParam8.replace(/'/g, "''") + "%'"; accessbarrier.CursorType = 0; accessbarrier.CursorLocation = 2; accessbarrier.LockType = 1; accessbarrier.Open(); var accessbarrier_numRows = 0; %> <% var Repeat1__numRows = 15; var Repeat1__index = 0; accessbarrier_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables // set the record count var accessbarrier_total = accessbarrier.RecordCount; // set the number of rows displayed on this page if (accessbarrier_numRows < 0) { // if repeat region set to all records accessbarrier_numRows = accessbarrier_total; } else if (accessbarrier_numRows == 0) { // if no repeat regions accessbarrier_numRows = 1; } // set the first and last displayed record var accessbarrier_first = 1; var accessbarrier_last = accessbarrier_first + accessbarrier_numRows - 1; // if we have the correct record count, check the other stats if (accessbarrier_total != -1) { accessbarrier_numRows = Math.min(accessbarrier_numRows, accessbarrier_total); accessbarrier_first = Math.min(accessbarrier_first, accessbarrier_total); accessbarrier_last = Math.min(accessbarrier_last, accessbarrier_total); } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (accessbarrier_total == -1) { // count the total records by iterating through the recordset for (accessbarrier_total=0; !accessbarrier.EOF; accessbarrier.MoveNext()) { accessbarrier_total++; } // reset the cursor to the beginning if (accessbarrier.CursorType > 0) { if (!accessbarrier.BOF) accessbarrier.MoveFirst(); } else { accessbarrier.Requery(); } // set the number of rows displayed on this page if (accessbarrier_numRows < 0 || accessbarrier_numRows > accessbarrier_total) { accessbarrier_numRows = accessbarrier_total; } // set the first and last displayed record accessbarrier_last = Math.min(accessbarrier_first + accessbarrier_numRows - 1, accessbarrier_total); accessbarrier_first = Math.min(accessbarrier_first, accessbarrier_total); } %> <% var MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables var MM_rs = accessbarrier; var MM_rsCount = accessbarrier_total; var MM_size = accessbarrier_numRows; var MM_uniqueCol = ""; MM_paramName = ""; var MM_offset = 0; var MM_atTotal = false; var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined"); %> <% // *** Move To Record: handle 'index' or 'offset' parameter if (!MM_paramIsDefined && MM_rsCount != 0) { // use index parameter if defined, otherwise use offset parameter r = String(Request("index")); if (r == "undefined") r = String(Request("offset")); if (r && r != "undefined") MM_offset = parseInt(r); // if we have a record count, check if we are past the end of the recordset if (MM_rsCount != -1) { if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount % MM_size); } else { MM_offset = MM_rsCount - MM_size; } } } // move the cursor to the selected record for (var i=0; !MM_rs.EOF && (i < MM_offset || MM_offset == -1); i++) { MM_rs.MoveNext(); } if (MM_rs.EOF) MM_offset = i; // set MM_offset to the last possible record } %> <% // *** Move To Record: if we dont know the record count, check the display range if (MM_rsCount == -1) { // walk to the end of the display range for this page for (var i=MM_offset; !MM_rs.EOF && (MM_size < 0 || i < MM_offset + MM_size); i++) { MM_rs.MoveNext(); } // if we walked off the end of the recordset, set MM_rsCount and MM_size if (MM_rs.EOF) { MM_rsCount = i; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; } // if we walked off the end, set the offset based on page size if (MM_rs.EOF && !MM_paramIsDefined) { if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount % MM_size); } else { MM_offset = MM_rsCount - MM_size; } } // reset the cursor to the beginning if (MM_rs.CursorType > 0) { if (!MM_rs.BOF) MM_rs.MoveFirst(); } else { MM_rs.Requery(); } // move the cursor to the selected record for (var i=0; !MM_rs.EOF && i < MM_offset; i++) { MM_rs.MoveNext(); } } %> <% // *** Move To Record: update recordset stats // set the first and last displayed record accessbarrier_first = MM_offset + 1; accessbarrier_last = MM_offset + MM_size; if (MM_rsCount != -1) { accessbarrier_first = Math.min(accessbarrier_first, MM_rsCount); accessbarrier_last = Math.min(accessbarrier_last, MM_rsCount); } // set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount); %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters // create the list of parameters which should not be maintained var MM_removeList = "&index="; if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "="; var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone=""; // add the URL parameters to the MM_keepURL string for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) { var nextItem = "&" + items.item().toLowerCase() + "="; if (MM_removeList.indexOf(nextItem) == -1) { MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item())); } } // add the Form variables to the MM_keepForm string for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) { var nextItem = "&" + items.item().toLowerCase() + "="; if (MM_removeList.indexOf(nextItem) == -1) { MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item())); } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1); %> <% // *** Move To Record: set the strings for the first, last, next, and previous links var MM_moveFirst="",MM_moveLast="",MM_moveNext="",MM_movePrev=""; var MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves var MM_moveParam = "index"; // if the page has a repeated region, remove 'offset' from the maintained parameters if (MM_size > 1) { MM_moveParam = "offset"; if (MM_keepMove.length > 0) { params = MM_keepMove.split("&"); MM_keepMove = ""; for (var i=0; i < params.length; i++) { var nextItem = params[i].substring(0,params[i].indexOf("=")); if (nextItem.toLowerCase() != MM_moveParam) { MM_keepMove += "&" + params[i]; } } if (MM_keepMove.length > 0) MM_keepMove = MM_keepMove.substring(1); } } // set the strings for the move to links if (MM_keepMove.length > 0) MM_keepMove += "&"; var urlStr = Request.ServerVariables("URL") + "?" + MM_keepMove + MM_moveParam + "="; MM_moveFirst = urlStr + "0"; MM_moveLast = urlStr + "-1"; MM_moveNext = urlStr + (MM_offset + MM_size); MM_movePrev = urlStr + Math.max(MM_offset - MM_size,0); %> AAPI Health Literature Database





Home
What's New and Happening
About this site
About AAPCHO
Members
Products and Publications
Programs
API Links
Email Lists


AAPCHO Logo



AAPI Health Literature Database - Colorectal Cancer

Bernstein L, Wu AH. Colon and Rectal Cancer among Asian Americans and Pacific Islanders. Asian Am Pac Isl J Health 1998;6(2):184-200.

Borugian MJ, Sheps SB, Whittemore AS, Wu AH, Potter JD, Gallagher RP. Carbohydrates and colorectal cancer risk among Chinese in North America. Cancer Epidemiol Biomarkers Prev 2002;11(2):187-93.

Flood DM, Weiss NS, Cook LS, Emerson JC, Schwartz SM, Potter JD. Colorectal cancer incidence in Asian migrants to the United States and their descendants. Cancer Causes Control 2000;11(5):403-11.

Honda K. Factors associated with colorectal cancer screening among the US urban Japanese population. Am J Public Health 2004;94(5):815-22.

Kim K, Yu ES, Chen EH, Kim J, Brintnall RA. Colorectal cancer screening. Knowledge and practices among Korean Americans. Cancer Pract 1998;6(3):167-75.

Krieger N, Quesenberry C, Jr., Peng T, Horn-Ross P, Stewart S, Brown S, et al. Social class, race/ethnicity, and incidence of breast, cervix, colon, lung, and prostate cancer among Asian, Black, Hispanic, and White residents of the San Francisco Bay Area, 1988-92 (United States). Cancer Causes Control 1999;10(6):525-37.

Lin SS, Clarke CA, Prehn AW, Glaser SL, West DW, O'Malley CD. Survival differences among Asian subpopulations in the United States after prostate, colorectal, breast, and cervical carcinomas. Cancer 2002;94(4):1175-82.

Marchand LL. Combined influence of genetic and dietary factors on colorectal cancer incidence in Japanese Americans. J Natl Cancer Inst Monogr 1999(26):101-5.

Rajendra S, Ho JJ, Arokiasamy J. Risk of colorectal adenomas in a multiethnic Asian patient population: Race does not matter. J Gastroenterol Hepatol 2005;20(1):51-5.

Sun WY, Basch CE, Wolf RL, Li XJ. Factors associated with colorectal cancer screening among Chinese-Americans. Prev Med 2004;39(2):323-9.


Return to AAPI Health Literature Database Home

Chop Image
Comments? Please e-mail mailto:webmaster@aapcho.org
site version 2.0 | 17 FEB 104
© AAPCHO 1999