Hi, I am trying to create an edit page for data being submmited by a user. The only was I know how to do this is by using the primary key ...
THIS IS WHAT I PUT AS THE LINK TO GO TO THE EDIT PAGE:
<a href="
AND THIS IS WHAT IDENTIFIES WHICH RECORD TO EDIT:
<CFQUERY NAME="EditDynorun" DATASOURCE="DynoRunEx">
SELECT * FROM RunData WHERE Make= #URL.PriKey#
</cfquery>
My question is , Is there a way to edit records if I dont have a PRIMARY KEY, I want to do it by Last name and First name instead since I didnt create a Primary key in my table. How do you do this ???
thanks
THIS IS WHAT I PUT AS THE LINK TO GO TO THE EDIT PAGE:
<a href="
AND THIS IS WHAT IDENTIFIES WHICH RECORD TO EDIT:
<CFQUERY NAME="EditDynorun" DATASOURCE="DynoRunEx">
SELECT * FROM RunData WHERE Make= #URL.PriKey#
</cfquery>
My question is , Is there a way to edit records if I dont have a PRIMARY KEY, I want to do it by Last name and First name instead since I didnt create a Primary key in my table. How do you do this ???
thanks