How to have a validation check

Guest_imported · Jun 6, 2002

Hi,

I want to have a check function on an item, whether this items is belong to an Existing item or a New item in the database. My idea is:

1.enter an item number from the form page.
2.then have a check on the item number.
3.if the item is existing, it'll link to the Update action form
4.or if the item is new, then it'll link to Add action form.

Thanks in advance....

pcorreia · Jun 6, 2002

You would need a page that had a form for the user to enter the item number. That form would submit to a page containing the code below:

Code:

<cfquery name=&quot;qryCheckItem&quot; datasource=&quot;myDSN&quot;>
  SELECT *
  FROM tblItems
  WHERE itemNumber = <cfqueryparam value=&quot;#FORM.itemNumber#&quot; cfsqltype=&quot;CF_SQL_INTEGER&quot;> 
</cfquery>
<cfif qryCheckItem.recordcount EQ 0>
  <!---
    Insert &quot;Add&quot; form here
  --->
<cfelse>
  <!---
    Insert &quot;Update&quot; form here
    (Note: you already have the data stored in qryCheckItem)
  --->
</cfif>

You would then need additional form handler pages to handle the add and update forms.

Hope this helps!

Guest_imported · Jun 6, 2002

Hi, Pcorreia

It's works....Thanks. But I've one problem it can link to the update form but it can't open the update form. Add form is functioned. Here's my program:

AddUpdateChk.cfm:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFinclude template="../template/header1.cfm">
<cfquery name="chkpartno" datasource="JESEng">
SELECT partno
FROM Film
WHERE partno = <cfqueryparam value="#form.partno#"
cfsqltype="CF_SQL_VARCHAR"
MAXLENGTH="15">
</cfquery>
<cfif chkpartno.recordcount EQ 0>
<form action="filmAdd.cfm" method="post">
<font color="#993399"><strong>PLEASE WAIT....WHILE PROCESSING</strong></font>
<meta http-equiv=refresh content="2;url=..\Film\filmAdd.cfm">
</form>
<cfelse>
<form action="filmUpdate.cfm" method="post">
<font color="#993399"><strong>PLEASE WAIT....WHILE PROCESSING</strong></font>
<meta http-equiv=refresh content="2;url=..\Film\filmUpdate.cfm">
</form>
</cfif>

And filmUpdate.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<CFinclude template="../template/header1.cfm">
<style>
.bu{ background-color: #33ff99 ; color=#330000}
</style>

<CFQUERY DATASOURCE="JESEng" NAME="ReFilm">
SELECT partno, partname, Rdate, subno, refno, rmk, Rneng, Org
FROM Film
WHERE partno = '#form.partno#'
</CFQUERY>

<CFOUTPUT QUERY="ReFilm">
<html>
<head>
<title>FILM/SAMPLE/MECHA SPEC MASTER</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<center>
<body TEXT="BLUE">
<h1>FILM/SAMPLE/MECHA SPEC MASTER - #partno#</h1>
</center>

<FORM ACTION="filmUpdateAction.cfm" METHOD="POST">



<P>
Part No.:
<INPUT TYPE="text" NAME="partno" SIZE="20" MAXLENGTH="20" VALUE="#TRIM(ReFilm.partno)#">
<BR>
Part Name:
<INPUT TYPE="text" NAME="partname" SIZE="20" MAXLENGTH="20" VALUE="#TRIM(ReFilm.partname)#">
<BR>
Received Date:
<INPUT TYPE="text" NAME="Rdate" SIZE="10" MAXLENGTH="10" VALUE="#TRIM(ReFilm.Rdate)#">
<BR>
Sub No.:
<INPUT TYPE="text" NAME="subno" SIZE="20" MAXLENGTH="15" VALUE="#TRIM(ReFilm.subno)#">
<BR>
Reference No.:
<INPUT TYPE="text" NAME="refno" SIZE="20" MAXLENGTH="15" VALUE="#TRIM(ReFilm.refno)#">
<BR>
Remarks:
<INPUT TYPE="text" NAME="rmk" SIZE="20" MAXLENGTH="15" VALUE="#TRIM(ReFilm.rmk)#">
<BR>
RND/ENG:
<INPUT TYPE="text" NAME="Rneng" SIZE="2" MAXLENGTH="2" VALUE="#TRIM(ReFilm.Rneng)#">
Origin:
<INPUT TYPE="text" NAME="Org" SIZE="2" MAXLENGTH="2" VALUE="#TRIM(ReFilm.Org)#">
<p>

<INPUT TYPE="submit" NAME="Update" VALUE="Update Part No" class="bu">
<INPUT TYPE="submit" NAME="Delete" VALUE="Delete Part No" class="bu">
<INPUT TYPE="reset" VALUE="Clear" class="bu">
</form>
</CFOUTPUT>

</body>
</html>
<cfinclude template="../template/footer.cfm">

pcorreia · Jun 7, 2002

I think <META> tags are only allowed in the head of an HTML document -- that may be why the redirect isn't working. You have a couple of options here:[ol][li]Instead of using redirects, put the code for each of the forms right in your AddUpdateChk.cfm page, between the <CFIF> tags. This reduces the number of pages you have to maintain. Basically, the user sees AddUpdateChk.cfm as a form page which shows different content based on whether the item number they entered exists or not.[/li]
[li]If that gets too complicated, keep your separate pages for the different input forms but <cfinclude> the appropriate one into the AddUpdateChk.cfm page depending on the result of the chkpartno query. The result to the user is the same as in the first option, but you get to separate the code out into distinct pages that may make more sense to you.[/li]
[li] If you're really determined to redirect the user to another page, you can use <cflocation> instead of a meta tag to redirect the user to the appropriate page. This tag can be used anywhere in the page, but you won't see any output from the page in the browser because <cflocation> writes an HTTP header that tells the browser to go directly to another page, and doesn't send any additional content.[/li][/ol]
Hope this helps.

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!

How to have a validation check

Guest_imported

New member

pcorreia

Programmer

Guest_imported

New member

pcorreia

Programmer

Similar threads

Part and Inventory Search

Sponsor