Validation of records

[whatsaname]

How can i validate if a record number in the Database NOT exist, and that an
error message will be returned to the user,
that a wrong number has been entered.

The code i'm having sofar is :
<cfparam name="FORM.issue_number" default="1">
<cfquery name="rs_issue" datasource="issue">
SELECT *
FROM tbl_issue
WHERE issue_number = #FORM.issue_number#
</cfquery>

[Dan Bracuk]

Run a select query and use the recordcount variable.

Or run a select count(fieldname) as thecount query with the appropriate where
clause and use the queryname.thecount value.

Originally posted by: whatsaname
How can i validate if a record number in the Database NOT exist, and that an
error message will be returned to the user,
that a wrong number has been entered.

The code i'm having sofar is :
<cfparam name="FORM.issue_number" default="1">
<cfquery name="rs_issue" datasource="issue">
SELECT *
FROM tbl_issue
WHERE issue_number = #FORM.issue_number#
</cfquery>

[_silence]

<cfparam name="FORM.issue_number" default="">
<cfquery name="rs_issue" datasource="issue">
SELECT *
FROM tbl_issue
WHERE issue_number = #FORM.issue_number#
</cfquery>

<cfif not rs_issue.recordcount>
No records found.
</cfif>

[whatsaname]

I'm not that familar with database quiries rahter than the simple recordsets.
I've tried to find how to make the quiry that runs the RECORDCOUNT, but i can
not find that.
Could you please assist me a bit?

Thanks

[_silence]

All queries ran with cfquery return the following variables in the query scope:
query_name.currentRow
Current row of query that cfoutput is processing
query_name.columnList
Comma-delimited list of the query columns
query_name.RecordCount
Number of records (rows) returned from the query
cfquery.ExecutionTime
Cumulative time required to process the query

They can all be referenced in CF after the query is executed by using
query_Name.recordcount (where query_Name is the actual name of your query),
etc...

For more information see:

[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b19.htm[/url]

[whatsaname]

Thank you so much, now i've got the clue, and it is working.
I've place the CFIF where thhe output is expected
("<cfoutput>#Form.issue_number# <cfif not rs_issue.recordcount>
DOES NOT EXIST</cfif></cfoutput>"

Again Great Help.

[whatsaname]

That is a good one. Thanks for your help.