Do you mean select the highest number before the first dot and increment
the number after the last dot?
If so treat the number as a list and have
firstnumber=listfirst(project_Num_number,".")
lastnumber=listlast(projet_num_number,".")
you can then find the max firstnumber and increment the last number
If you have to check more than the first number I would suggest using
listtoarray with a delimitter of "." and manipulating that
----- Original Message -----
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 29, 2001 6:51 AM
Subject: Val :: manipulating strings as numbers
> ok i am having some problems trying to figure out how to do this
>
> i have all these project numbers, but they are not real numbers, but text.
> like
>
> Project_Num_Number
> 50001.01
> 500020.07.01
> 500051.02.03
> 900008.01
> 900009.00
>
> in each case i need to select the highest number
> then add one 1 to insert as a new number for that field.
>
> the way it is right now, my where stament are not selecting the right
range.
> it did work prevously when i had the Project_Num_Number fieeld converted
to
> number field in access.
>
> WHERE Val(Project_Num_Number) < 1351103
> WHERE Val(Project_Num_Number) < 600000
> WHERE Val(Project_Num_Number) < 900008.00
>
> right now they are only selecting 90000 reange for all categories & it is
> incrementing by 1
> but if the highest number for that section is
> 900008.02 i need it to do 900008.03 NOT 900009
>
>
> if you have any idea what i need to do i would appreciate the help.
>
> thank you
>
> -paul
>
> <!---
> Select the highest project number
> then will add +1 to it
> to be inserted back into new project
> we will also need to insert the updated number back into this table latter
> with the project name, After the project is complete!
> --->
> <!---
> Numbers in the 900000 range to be inserted
> Type_of_Project
> Billable (New Project No.)=1,
> Billable (Sub No. to Existing Project)=2
> --->
> <CFIF (#FORM.Type_of_Project# EQ 1) OR (#FORM.Type_of_Project# EQ 2)>
> <cfquery name="rs_Proj_Num" datasource="Project_Set_Up" dbtype="ODBC">
> SELECT Project_Num_Number
> FROM tbl_project_num_Link
> WHERE Val(Project_Num_Number) < 1351103
> ORDER BY Project_Num_Number DESC
> </cfquery>
> <CFSET Proj_Num = IncrementValue('#rs_Proj_Num.Project_Num_Number#')>
>
> <!---
> Numbers in the 500000 range to be inserted
> Type_of_Project Marketing=3
> --->
> <CFelseIF (#FORM.Type_of_Project# EQ 3)>
> <cfquery name="rs_Proj_Num" datasource="Project_Set_Up" dbtype="ODBC">
> SELECT Project_Num_Number
> FROM tbl_project_num_Link
> WHERE Val(Project_Num_Number) < 600000
> ORDER BY Project_Num_Number DESC
> </cfquery>
> <CFSET Proj_Num = IncrementValue('#rs_Proj_Num.Project_Num_Number#')>
>
>
> <!---
> Numbers in the 600000 range to be inserted
> Type_of_Project Admin=4
> --->
> <CFelseIF (#FORM.Type_of_Project# EQ 4)>
> <cfquery name="rs_Proj_Num" datasource="Project_Set_Up" dbtype="ODBC">
> SELECT Project_Num_Number
> FROM tbl_project_num_Link
> WHERE Val(Project_Num_Number) < 900008.00
> ORDER BY Project_Num_Number DESC
> </cfquery>
> <CFSET Proj_Num = IncrementValue('#rs_Proj_Num.Project_Num_Number#')>
> <cfelse>
> <CFSET Proj_Num = 0>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
