addition

vz · Aug 13, 2001

I am using the max function where it will return the greatest value to me in a perticular column and I would like to add 1 to it before I place the value in a form field I keep getting a syntax error does anyone know how to do this?

tleish · Aug 13, 2001

What does your current code look like? - tleish

sknyppy · Aug 13, 2001

<cfquery name="Name" datasource="Datasource">
select max(Column) as YourColumnMax
from table
</cfquery>

<cfset YourColumnMax = YourColumnMax + 1>

<cfform action="" method="">
<cfinput type="text" name="whatever" value="#Variables.YourColumnMax#">
</cfform>

~Dave

Silvano · Aug 13, 2001

try this:

<cfquery name="queryName" datasource="Datasource">
select max(Column) as YourColumnMax
from table
</cfquery>

<cfset YourColumnMax = queryName.YourColumnMax + 1>

<cfform action="" method="">
<cfinput type="text" name="whatever" value="#YourColumnMax#">
</cfform>

sknyppy · Aug 14, 2001

Ya. I guess it might help to scope the variable with the proper queryname....Duh....typing too fastttt.

~Dave

ded · Aug 14, 2001

Much easier depending if your DB likes it is

Code:

<cfquery name=&quot;queryName&quot; datasource=&quot;Datasource&quot;>
   select (max(Column)+1) as YourColumnMaxplusone
   from table
</cfquery>

vz · Aug 14, 2001

Thanks for your help so far, but I am now getting an errror that says:One or more problems exist with the data you have entered.
Data entered in the Order_id field must be a number (you entered '#max_id#').

Use the Back button on your web browser to return to the previous page and correct the listed problems

Here is my code, order_id's datatype in postgres (db) is int4.

<CFQuery name="getval" datasource="supply">
Select max(order_id) as max_id from ordersplaced;
</cfQuery>
<HTML>
<HEAD>
<TITLE>Supplies Database Place Order Form</TITLE>
<SCRIPT LANGUAGE=JAVASCRIPT>
//begin is numeric function
function isNum(passedVal)
{
if(passedVal =="&quot

{
return false
}
for (i=0; i<passedVal.length; i++)
{
if (passedVal.charAt(i) < "0&quot

{
return false
}
if (passedVal.charAt(i) > "9&quot

{
return false
}
}
return true
}//end is numeric function

//begin is date function - This function checks to see if the
//date is in the correct format.
function isDate(date)
{
if (date.length != 10)
{
alert("Please enter an Order Date in the format (mm/dd/yyyy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if (date.charAt(2) != "/&quot

{
alert("Please enter a foward slash '/' between month and day in the format (mm/dd/yyyy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if (date.charAt(5) != "/&quot

{
alert("Please enter a forward slash'/' between day and year in the format (mm/dd/yyyy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if ((date.substring(0,2) < "01&quot

|| (date.substring(0,2) > "12&quot

)
{
alert("Please enter a valid month EX.(01 to 12).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if ((date.substring(3,5) < "01&quot

|| (date.substring(3,5) > "31&quot

)
{
alert("Please enter a valid day EX.(01 to 31).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if ((date.substring(6,10) < "0000&quot

|| (date.substring(6,10) > "9999&quot

)
{
alert("Please enter a valid year EX.(2000).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
}
//end is date function

//begin main validation function
function validateInfo()
{
//declare variables to hold input values
var _accountnumber = document.addordersplacedform.accountnumber.value;
var _accountname = document.addordersplacedform.accountname.value;
var _orderdate = document.addordersplacedform.orderdate.value;
var _tubes = document.addordersplacedform.tubes.value;
var _needles = document.addordersplacedform.needles.value;
var _butterfly = document.addordersplacedform.butterfly.value;
var _sterilecontainer = document.addordersplacedform.sterilecontainer.value;
var _tissuecontainer = document.addordersplacedform.tissuecontainer.value;
var _sharps = document.addordersplacedform.sharps.value;
var _gloves = document.addordersplacedform.gloves.value;
var _misc = document.addordersplacedform.misc.value;

//verify that certain input fields are filled in
if(isNum(_accountnumber) == false)
{
alert("Please enter a numeric Account Number.&quot

;
addordersplacedform.accountnumber.focus();
return false;
}
if(_accountname.toString() =="&quot

{
alert("Please enter an Account Name.&quot

;
addordersplacedform.accountname.focus();
return false;
}
if(_orderdate.toString() =="&quot

{
alert("Please enter an Order Date in the format (mm/dd/yy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
//calls function isDate to check date validity
if(isDate(_orderdate)== false)
{
addordersplacedform.orderdate.focus();
return false;
}
if(_tubes.toString() =="&quot

{
alert("Please enter a numeric value for Tubes.&quot

;
addordersplacedform.tubes.focus();
return false;
}
if(_needles.toString() =="&quot

{
alert("Please enter a numeric value for Needles.&quot

;
addordersplacedform.needles.focus();
return false;
}
if(_butterfly.toString() =="&quot

{
alert("Please enter a numeric value for Butterfly.&quot

;
addordersplacedform.butterfly.focus();
return false;
}
if (_sterilecontainer.toString() =="&quot

{
alert("Please enter a numeric value for Sterile Container.&quot

addordersplacedform.sterilecontainer.focus();
return false;
}
if (_tissuecontainer.toString() =="&quot

{
alert("Please enter a numeric value for Tissue Container.&quot

addordersplacedform.tissuecontainer.focus();
return false;
}
if (_sharps.toString() =="&quot

{
alert("Please enter a numeric value for Sharps.&quot

addordersplacedform.sharps.focus();
return false;
}
if (_gloves.toString() =="&quot

{
alert("Please enter a numeric value for Gloves.&quot

addordersplacedform.gloves.focus();
return false;
}
if(_misc.toString() =="&quot

{
alert("Please enter a numeric value for Misc.&quot

addordersplacedform.misc.focus();
return false;
}
}
//end validation function
</SCRIPT>
</HEAD>


<CFSET dateentered = NOW()>
<CFSET max_id = getval.max_id + 1>
<BODY bgcolor="cccccc">
<TABLE height="100%" width="100%" cellspacing="3" cellpadding="5">
<TR>
<TD>Orders Placed
</TD>
<TD>

<A href="mainsuppliesdbpage.cfm"><IMG src="mainpage.gif" border="0"></A>
</TD>
</TR>
<TR>
<TD>
<cfFORM name="addordersplacedform" action="postordersplaceddata.cfm" method="Post">

<INPUT type="text" name="order_id" size="8" maxlength="8" value="#max_id#"> Account Number:

<cfINPUT type="text" name="accountnumber" size="8" maxlength="8"> Account Name:
<cfINPUT type="text" name="accountname" size="50" maxlength="50"> Order Date:
<cfINPUT type="Text" name="orderdate" size="10" maxlength="50"> Tubes:
<cfINPUT type="Text" name="tubes" size="10" maxlength="50"> Needles:
<cfINPUT type="Text" name="needles" size="10" maxlength="50"> Butterfly:
<cfINPUT type="Text" name="butterfly" size="10" maxlength="50"> Sterile Containers:
<cfiNPUT type="Text" name="sterilecontainer" size="10" maxlength="50"> Tissue Container:
<cfINPUT type="Text" name="tissuecontainer" size="10" maxlength="50"> Sharps:
<cfINPUT type="Text" name="sharps" size="10" maxlength="50"> Gloves:
<cfINPUT type="Text" name="gloves" size="10" maxlength="50"> Misc:
<cfINPUT type="Text" name="misc" size="10" maxlength="50"> 
<CFOUTPUT>
<INPUT type="hidden" name="dateentered" value="#dateentered#"> 
</CFOUTPUT>
</TD>
</TR>
<TR>
<TD>

<A href="javascript: document.addordersplacedform.submit()"><IMG src="submit.gif" onClick="return validateInfo();" border="0"></A>
<A href="javascript: document.addordersplacedform.reset()"><IMG src="clearform.gif" border="0"></A>
</TD>
</TR>
</TABLE>
</cfFORM>
</BODY>
</HTML>

ded · Aug 14, 2001

You have commented out your CFOUTPUT

Code:

<cfFORM name=&quot;addordersplacedform&quot; action=&quot;postordersplaceddata.cfm&quot; method=&quot;Post&quot;>
                <!---<cfoutput query=&quot;getval&quot;>--->
                <INPUT type=&quot;text&quot; name=&quot;order_id&quot; size=&quot;8&quot; maxlength=&quot;8&quot; value=&quot;#max_id#&quot;>

should be

Code:

<cfFORM name=&quot;addordersplacedform&quot; action=&quot;postordersplaceddata.cfm&quot; method=&quot;Post&quot;>
                <cfoutput>
                <INPUT type=&quot;text&quot; name=&quot;order_id&quot; size=&quot;8&quot; maxlength=&quot;8&quot; value=&quot;#max_id#&quot;></cfoutput>

vz · Aug 14, 2001

Thank you for your help. I put the cfoutput statement back, and I can now see the number; however, now when I click submit my page just hangs and ends up shutting down my server. I can't see anything wrong, but I've been looking at it forever. I am using postgresql as my db if that should matter. Does anyone see something wrong?
Thanks heres my new code:

<CFQuery name="getval" datasource="supply">
Select max(order_id) as max_id from ordersplaced;
</cfQuery>
<HTML>
<HEAD>
<TITLE>Supplies Database Place Order Form</TITLE>
<SCRIPT LANGUAGE=JAVASCRIPT>
//begin is numeric function
function isNum(passedVal)
{
if(passedVal =="&quot

{
return false
}
for (i=0; i<passedVal.length; i++)
{
if (passedVal.charAt(i) < "0&quot

{
return false
}
if (passedVal.charAt(i) > "9&quot

{
return false
}
}
return true
}//end is numeric function

//begin is date function - This function checks to see if the
//date is in the correct format.
function isDate(date)
{
if (date.length != 10)
{
alert("Please enter an Order Date in the format (mm/dd/yyyy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if (date.charAt(2) != "/&quot

{
alert("Please enter a foward slash '/' between month and day in the format (mm/dd/yyyy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if (date.charAt(5) != "/&quot

{
alert("Please enter a forward slash'/' between day and year in the format (mm/dd/yyyy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if ((date.substring(0,2) < "01&quot

|| (date.substring(0,2) > "12&quot

)
{
alert("Please enter a valid month EX.(01 to 12).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if ((date.substring(3,5) < "01&quot

|| (date.substring(3,5) > "31&quot

)
{
alert("Please enter a valid day EX.(01 to 31).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
if ((date.substring(6,10) < "0000&quot

|| (date.substring(6,10) > "9999&quot

)
{
alert("Please enter a valid year EX.(2000).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
}
//end is date function

//begin main validation function
function validateInfo()
{
//declare variables to hold input values
var _accountnumber = document.addordersplacedform.accountnumber.value;
var _accountname = document.addordersplacedform.accountname.value;
var _orderdate = document.addordersplacedform.orderdate.value;
var _tubes = document.addordersplacedform.tubes.value;
var _needles = document.addordersplacedform.needles.value;
var _butterfly = document.addordersplacedform.butterfly.value;
var _sterilecontainer = document.addordersplacedform.sterilecontainer.value;
var _tissuecontainer = document.addordersplacedform.tissuecontainer.value;
var _sharps = document.addordersplacedform.sharps.value;
var _gloves = document.addordersplacedform.gloves.value;
var _misc = document.addordersplacedform.misc.value;

//verify that certain input fields are filled in
if(isNum(_accountnumber) == false)
{
alert("Please enter a numeric Account Number.&quot

;
addordersplacedform.accountnumber.focus();
return false;
}
if(_accountname.toString() =="&quot

{
alert("Please enter an Account Name.&quot

;
addordersplacedform.accountname.focus();
return false;
}
if(_orderdate.toString() =="&quot

{
alert("Please enter an Order Date in the format (mm/dd/yy).&quot

;
addordersplacedform.orderdate.focus();
return false;
}
calls function isDate to check date validity
if(isDate(_orderdate)== false)
{
addordersplacedform.orderdate.focus();
return false;
}
if(_tubes.toString() =="&quot

{
alert("Please enter a numeric value for Tubes.&quot

;
addordersplacedform.tubes.focus();
return false;
}
if(_needles.toString() =="&quot

{
alert("Please enter a numeric value for Needles.&quot

;
addordersplacedform.needles.focus();
return false;
}
if(_butterfly.toString() =="&quot

{
alert("Please enter a numeric value for Butterfly.&quot

;
addordersplacedform.butterfly.focus();
return false;
}
if (_sterilecontainer.toString() =="&quot

{
alert("Please enter a numeric value for Sterile Container.&quot

addordersplacedform.sterilecontainer.focus();
return false;
}
if (_tissuecontainer.toString() =="&quot

{
alert("Please enter a numeric value for Tissue Container.&quot

addordersplacedform.tissuecontainer.focus();
return false;
}
if (_sharps.toString() =="&quot

{
alert("Please enter a numeric value for Sharps.&quot

addordersplacedform.sharps.focus();
return false;
}
if (_gloves.toString() =="&quot

{
alert("Please enter a numeric value for Gloves.&quot

addordersplacedform.gloves.focus();
return false;
}
if(_misc.toString() =="&quot

{
alert("Please enter a numeric value for Misc.&quot

addordersplacedform.misc.focus();
return false;
}
}
//end validation function
</SCRIPT>
</HEAD>


<CFSET dateentered = NOW()>
<CFSET max_id = getval.max_id + 1>
<BODY bgcolor="cccccc">
<TABLE height="100%" width="100%" cellspacing="3" cellpadding="5">
<TR>
<TD>Orders Placed
</TD>
<TD>

<A href="mainsuppliesdbpage.cfm"><IMG src="mainpage.gif" border="0"></A>
</TD>
</TR>
<TR>
<TD>
<cfFORM name="addordersplacedform" action="postordersplaceddata.cfm" method="Post">
<cfoutput>
<cfINPUT type="text" name="order_id" size="8" maxlength="8" value="#max_id#"> Account Number:
</cfoutput>
<cfINPUT type="text" name="accountnumber" size="8" maxlength="8"> Account Name:
<cfINPUT type="text" name="accountname" size="50" maxlength="50"> Order Date:
<cfINPUT type="Text" name="orderdate" size="10" maxlength="50"> Tubes:
<cfINPUT type="Text" name="tubes" size="10" maxlength="50"> Needles:
<cfINPUT type="Text" name="needles" size="10" maxlength="50"> Butterfly:
<cfINPUT type="Text" name="butterfly" size="10" maxlength="50"> Sterile Containers:
<cfiNPUT type="Text" name="sterilecontainer" size="10" maxlength="50"> Tissue Container:
<cfINPUT type="Text" name="tissuecontainer" size="10" maxlength="50"> Sharps:
<cfINPUT type="Text" name="sharps" size="10" maxlength="50"> Gloves:
<cfINPUT type="Text" name="gloves" size="10" maxlength="50"> Misc:
<cfINPUT type="Text" name="misc" size="10" maxlength="50"> 
<CFOUTPUT>
<INPUT type="hidden" name="dateentered" value="#dateentered#"> 
</CFOUTPUT>
</TD>
</TR>
<TR>
<TD>

<A href="javascript: document.addordersplacedform.submit()"><IMG src="submit.gif" onClick="return validateInfo();" border="0"></A>
<A href="javascript: document.addordersplacedform.reset()"><IMG src="clearform.gif" border="0"></A>
</TD>
</TR>
</TABLE>
</cfFORM>
</BODY>
</HTML>

vz · Aug 14, 2001

sorry, actually I accidentally forgot to comment something and I fixed, but now it says illegal operation program will shut down.
thanks

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

addition

vz

MIS

tleish

Programmer

sknyppy

Programmer

Silvano

Programmer

sknyppy

Programmer

ded

Programmer

vz

MIS

ded

Programmer

vz

MIS

vz

MIS

Similar threads

Part and Inventory Search

Sponsor