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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
