I have the following code in an a5w page. This page works on my local machine when I run Execute Page. Once published to my server (which has the same directory structure as my development system as far as Alpha is conserned) I get the error shown below. That table is in fact there and in the directory the error says it is not in. Any Ideas??
500 Internal Server Error
Script Error
Error:Table not found: 'C:\db\STRRIDE II\tbl_demographics'.
Code:
<html> <head><title>Reading from a Table</title></head> <body bgColor=#ece9d8 background=""> <%a5 Dim males as C Dim females as C Dim CaucM as C Dim CaucF as C Dim AAM as C Dim AAF as C Dim OM as C Dim OF as C males = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'M'") females = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'F'") CaucM = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'M' .and. Race = 'C'") CaucF = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'F' .and. Race = 'C'") AAM = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'M' .and. Race = 'AA'") AAF = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'F' .and. Race = 'AA'") OM = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'M' .and. Race = 'H' .or. Race = 'I' .or. Race = 'A' .or. Race = 'O'") OF = a5_get_records_in_query("[PathAlias.ADB_Path]\tbl_demographics", "Gen = 'F' .and. Race = 'H' .or. Race = 'I' .or. Race = 'A' .or. Race = 'O'") %> <p><table width="90%" border="0" cellpadding="0" cellspacing="0" background="" > <tr> <td vAlign=top align=middle background="" > STRRIDE II Demographic Dashboard<table width="560" border="2" cellpadding="0" cellspacing="0" align=center background="" style="WIDTH: 560px; HEIGHT: 162px" bgColor=#00ffff> <tr> <td></td> <td vAlign=center align=middle width=100 background="" >Total</td> <td vAlign=center align=middle width=100 background="" >Caucasion</td> <td vAlign=center align=middle width=100>African American</td> <td vAlign=center align=middle width=100 background="" > Other</td></tr> <tr> <td> Number of Males:</td> <td vAlign=center align=middle background="" ><%a5 ? males %></td> <td vAlign=center align=middle background="" ><%a5 ? CaucM %></td> <td vAlign=center align=middle><%a5 ? AAM %></td> <td vAlign=center align=middle background="" ><%a5 ? OM %></td> </tr> <tr> <td> Number of Females:</td> <td vAlign=center align=middle background="" ><%a5 ? females %></td> <td vAlign=center align=middle background="" ><%a5 ? CaucF %></td> <td vAlign=center align=middle><%a5 ? AAF %></td> <td vAlign=center align=middle background="" ><%a5 ? OF %></td> </tr> </table></td> </tr> </table> </p> </body> </html>
Script Error
Error:Table not found: 'C:\db\STRRIDE II\tbl_demographics'.
Comment