Webmaster Forum / ColdFusion / Advanced Techniques / July 2006

Hello i have a Insert query which loops through my form from the previous page,
what i need to do is if the PlayerPhone starts with "0" to remove it, i have
tried the code below but i am having probllems can someone help

<cfloop index="currRow" from="#form.startRow#" to="#form.dispRows#">
    <cfif IsDefined("form.ID_#currRow#")>
        <cfset ID = Evaluate("form.ID_" & currRow)>
           
<cfif left("form.PlayerPhone_#currRow#",1) EQ "0">
<cfset PhoneNo=removeChars(replace("form.PlayerPhone_#currRow#", " ", "",
"all"),1,1)>
</cfif>
       
<cfquery name="INSERT" datasource="iluvcricket">
INSERT INTO sms_players_table
(PlayerFirstName, PlayerSurname, PlayerPhone, ClubID)
VALUES
('#form["PlayerFirstName_#currRow#"]#', '#form["PlayerSurname_#currRow#"]#',
#PhoneNo#, #form.ClubID#)
</cfquery>
<cfelse>
        <cfbreak>
    </cfif>
</cfloop>