"If not exists"

[programmher]

What is the code I can include in my CF form to check a SQL table to see whether data exists for a selected customer? I am attempting to duplicate and web-enable an old pre-existing system that does this.

The only syntax I can think of is to query the table and see if the rows are not null.

Does anyone have a better method?

 

[tlhawkins]

Hey Programmher,

I think the simplest method is what you mentioned.
Query for the data and check if there is something there like this:

<CFQUERY name=&quot;Check&quot; datasource=&quot;BigOldDatabase&quot;>
Select *
From tblcustomer
Where Customername = &quot;FirstCustomer&quot;
</CFQUERY>

<CFIF #Check.recordcount# is 0> Customer Not in Database
<CFELSE> Customer is in database #Check.recordcount# times
</CFIF>

I took some liberties with the table and field names but you get the idea.

Have FUN!