You know, I had the same thing on the page that PLUM generated for the List page as well. I caught that one. Both of these pages were generated by the Plum IDE. So somewhere in the Guts, there are two references to the primary table.
After the correction, the error message still says "Not a valid alias name" You know, the only problems I have had with PLUM ( and odds are good the problems were mine not PLUM's) was after making changes to the database, especially in regards to the primary key. I think the easiest thing will be to make a new table and delete the existing one. When I synchronize with the database, it will pick up on the new table. Adam mentioned in one of his post today, that he was not fond of table aliases and was planning on eliminating them on the next release. I wonder if PLUM stores info on database schema's somewhere and if it is possible to go in examine what is there and then make changes manually. Thanks, Mark Fuqua -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Fleitz Sent: Wednesday, July 27, 2005 8:30 AM To: [email protected] Subject: Re: [plum] New "Not a valid alias name" It looks like at first glance that the view form has 2 cf_PrimaryKey declarations: <cf_PrimaryKey primaryKeyColumn="SubcontractorInitialApplication" > primaryKeyType="" value="#URL.SubcontractorInitialApplication#"> > <cf_PrimaryKey primaryKeyColumn="SubcontractorInitialApplicationId" > primaryKeyType="integer" value="#URL.SubcontractorInitialApplicationId#"> Try removing the first one. Jeff Mark Fuqua wrote: > 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 > ********************************************************************** > > ********************************************************************** 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 ********************************************************************** ********************************************************************** 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 **********************************************************************
