I made an online registration form using ColdFusion MX and Access 2003. I want to be able to make it so when there are 20 entries into the database it will stop accepting signups. Does anyone know of any code that I could put on the page that checks for the number of entries and stops people from signing up if the limit has been met? Thanks!
Eiolon 0
Unverified User
Walyer 0
Light Poster
Ok,
This is the code,
<cfquery name="number_entries" datasource="Your DNS">
SELECT “Primary Key Column
FROM “Your table name
WHERE “Primary Key Column = 20
</cfquery>
<cfif number_entries.RecordCount NEQ 0>
<! ---this is the url the user will be sent to if you record count = 20--->
<! ---you have to create the “sorry.cfm to tell the user that no more recorders can be added--->
<cflocation url="sorry.cfm" />
<cfelse>
<!--- if the count is < 20 than you INSERT the VALUES-->
<cfquery datasource="Your DNS">
INSERT INTO ( )
VALUES ( )
</cfquery>
</cfif>
It worked for me so it should work for you.
Take care,
Walyer
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.