Yes, I have been using old messages and erasing the content. Didn't know it
caused sorting problems. Won't do that again.
Did have debugging on. First time was today. It does tell you quite alot.
A quick bit of history. When I first encountered this issue, I had a table
with a primary key field with the same name as the table
SubcontractorInitialApplication.SubcontractorInitialApplication.
I decided that was what was "Not a valid alias name" and changed the field
to SubcontractorInitialApplicationId. Of course, this caused multiple other
problems. After changing all the references to the primary field to reflect
the new name, I was still getting the same message. And when I looked down
at the debugging info. it said Url variable SubcontractorInitialApplication
did not exist. Duh. I decided since PLUM works with the info it gathers
about the database, I decided to run "synchronize with database" function in
IDE. And generate code. before I did, i locked the add page since that was
working and was formatted like I wanted.
Still get the error except now it says "URL Parameters: MESSAGE= Not a
valid alias name".
Here is the code from the list page.
<cfmodule template="#Request.adminLayout#/Header.cfm" pageType="Database">
<cf_DisplayList table="SubcontractorInitialApplication" rowsPerPage="50"
label="Subcontractor Initial Applications"
displayALinkToThisSearchForm="SubcontractorInitialApplicationSearchForm.cfm"
>
<cf_PrimaryKey primaryKeyColumn="SubcontractorInitialApplicationId"
primaryKeyType="integer">
<cf_DisplayDeleteCheckboxInList>
<cf_DisplayColumnInList column="Address" label="Address"
type="varchar(150)">
<cf_DisplayColumnInList column="AddressTwo" label="Address Two"
type="varchar(100)">
<cf_DisplayColumnInList column="CellPhoneNumber" label="Cell Phone
Number"
type="varchar(50)">
<cf_DisplayColumnInList column="City" label="City" type="varchar(50)">
<cf_DisplayColumnInList column="CompanyName" label="Company Name"
type="varchar(50)">
<cf_DisplayListLinks add="SubcontractorInitialApplicationAddForm.cfm"
view="SubcontractorInitialApplicationViewForm.cfm"
edit="SubcontractorInitialApplicationEditForm.cfm"
delete="SubcontractorInitialApplicationDeleteForm.cfm">
</cf_DisplayList>
<cfmodule template="#Request.adminLayout#/Footer.cfm">
Here is the code for the view page.
<cfmodule template="#Request.adminLayout#/Header.cfm" pageType="Database">
<cf_DisplayViewForm table="SubcontractorInitialApplication" label="View a
Subcontractor Initial Application"
displayALinkToThisList="SubcontractorInitialApplicationList.cfm">
<cf_PrimaryKey primaryKeyColumn="SubcontractorInitialApplication"
primaryKeyType="" value="#URL.SubcontractorInitialApplication#">
<cf_PrimaryKey primaryKeyColumn="SubcontractorInitialApplicationId"
primaryKeyType="integer" value="#URL.SubcontractorInitialApplicationId#">
<cf_DisplayColumnOnForm column="ForWhichPositionAreYouApplyingFor"
label="For Which Position Are You Applying For" type="varchar(50)">
<cf_DisplayColumnOnForm column="FirstName" label="First Name"
type="varchar(50)">
<cf_DisplayColumnOnForm column="LastName" label="Last Name"
type="varchar(50)">
<cf_DisplayColumnOnForm column="CompanyName" label="Company Name"
type="varchar(50)">
<cf_DisplayColumnOnForm column="Address" label="Address"
type="varchar(150)">
<cf_DisplayColumnOnForm column="AddressTwo" label="Address Two"
type="varchar(100)">
<cf_DisplayColumnOnForm column="City" label="City" type="varchar(50)">
<cf_DisplayColumnOnForm column="State" label="State" type="varchar(50)">
<cf_DisplayColumnOnForm column="Zipcode" label="Zipcode"
type="varchar(50)">
<cf_DisplayColumnOnForm column="Email" label="Email" type="varchar(50)">
<cf_DisplayColumnOnForm column="CellPhoneNumber" label="Cell Phone
Number"
type="varchar(50)">
<cf_DisplayColumnOnForm column="MainPhone" label="Main Phone"
type="varchar(50)">
<cf_DisplayColumnOnForm column="HowManyYearsHaveYouBeenInBusiness"
label="How Many Years Have You Been In Business" type="varchar(50)">
<cf_DisplayColumnOnForm column="RateYourBrushAndRollSkills" label="Rate
Your Brush And Roll Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourLineCuttingSkills" label="Rate
Your
Line Cutting Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourCaulkingSkills" label="Rate Your
Caulking Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourMaskingSkills" label="Rate Your
Masking Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourAirlessSpraySkills" label="Rate
Your Airless Spray Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourHVLPSpraySkills" label="Rate
Your
HVLPSpray Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourLiftSkills" label="Rate Your
Lift
Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourDrywallFinishingSkills"
label="Rate
Your Drywall Finishing Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourDrywallHangingSkills"
label="Rate
Your Drywall Hanging Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourDrywallRepairSkills" label="Rate
Your Drywall Repair Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourFinishCarpentryTrimSkills"
label="Rate Your Finish Carpentry Trim Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourSkillsInstallingCabinets"
label="Rate Your Skills Installing Cabinets" type="integer">
<cf_DisplayColumnOnForm column="RateYourSkillsWithCustomBuiltIns"
label="Rate Your Skills With Custom Built Ins" type="integer">
<cf_DisplayColumnOnForm column="RateYourSaleSkills" label="Rate Your
Sale
Skills" type="integer">
<cf_DisplayColumnOnForm column="RateYourManagementSkills" label="Rate
Your
Management Skills" type="integer">
<cf_DisplayColumnOnForm column="DoYouHaveAnyOtherQuestionsOrComments"
label="Do You Have Any Other Questions Or Comments" type="text">
</cf_DisplayViewForm>
<cfmodule template="#Request.adminLayout#/Footer.cfm">
Thanks,
Mark Fuqua
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
