Using cfoutput within a cfif statement

[USPO]

I am trying to setup a form validation, what i need to do is look at the
Specimen Number entered and compare it against the database to see if it
already exists. What i am trying now is to place a query and a cfif statement
just before the insert query runs, and using the <cfabort> to stop it if a
match is found.

Here is what i have so far.

<cfquery name="rsSpecNoVerify" datasource="TNMP_DB_be_TRACS">
SELECT SPEC_NO FROM URINE WHERE SPEC_NO = <CFQUERYPARAM
CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#FORM.SpecimenNum#">
</cfquery>
<cfif "<cfoutput>#rsSpecNoVerify.SPEC_NO#</cfoutput>" EQ #FORM.SpecimenNum#>
<h1>ERROR! Duplicate Specimen Number</h1>
<cfabort>
</cfif>

I don't get any errors but it continues to insert the record even though i am
entering a specimen number that i know already exists. I am using the
cfqueryparam statement because while the field is numeric 90% of the time there
are some tests that have a number that starts with "hh" so the field type is
set to string, and without the cfqueryparam i get a data type mismatch.

Should i be going about this a different way ? I believe the problem is with
the cfoutput being inside the cfif statement, but i can't seem to find a way to
fix it, i tried it without the " but i get a syntax error when i do.

I am still new to CF and web development, so i am still working on the Syntax.

Thanks for any help.

[Paul Whitham TMM]

I wouldn't bother with a test like you are doing because essentially with
your Query you are are only interested if the recordset contains aby values,
so you could achieve it with the following simplier test

<cfif rsSpecNoVerify.Recordcount GT 0>
<h1>ERROR! Duplicate Specimen Number</h1>
<cfabort>
</cfif>


--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"USPO" <webforumsuser@macromedia.com> wrote in message
news:cvlbo4$j1f$1@forums.macromedia.com...

> I am trying to setup a form validation, what i need to do is look at the
> Specimen Number entered and compare it against the database to see if it
> already exists. What i am trying now is to place a query and a cfif

statement

> just before the insert query runs, and using the <cfabort> to stop it if a
> match is found.
>
> Here is what i have so far.
>
> <cfquery name="rsSpecNoVerify" datasource="TNMP_DB_be_TRACS">
> SELECT SPEC_NO FROM URINE WHERE SPEC_NO = <CFQUERYPARAM
> CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#FORM.SpecimenNum#">
> </cfquery>
> <cfif "<cfoutput>#rsSpecNoVerify.SPEC_NO#</cfoutput>" EQ

#FORM.SpecimenNum#>

> <h1>ERROR! Duplicate Specimen Number</h1>
> <cfabort>
> </cfif>
>
> I don't get any errors but it continues to insert the record even though

i am

> entering a specimen number that i know already exists. I am using the
> cfqueryparam statement because while the field is numeric 90% of the time

there

> are some tests that have a number that starts with "hh" so the field type

is

> set to string, and without the cfqueryparam i get a data type mismatch.
>
> Should i be going about this a different way ? I believe the problem is

with

> the cfoutput being inside the cfif statement, but i can't seem to find a

way to

> fix it, i tried it without the " but i get a syntax error when i do.
>
> I am still new to CF and web development, so i am still working on the

Syntax.

>
> Thanks for any help.
>

[USPO]

Paul,
Thanks, i didn't even think about that, makes perfect sense though, i only
care if the query returns any values at all. How does Homer say it "Doh".

Again, thanks much, it worked like a champ.
P.S. Pass along my thanks to the Dev team that created Dreamweaver, i truly
love working with it & the more i learn the more i like it.