advcomputer
|
| Posted: 09/20/2002, 7:23 AM |
|
Hello,
I'm new to developement with CSS, however I have some skill with many of the other popular development environments. I think the following templates or functionality could be very helpful.
They have to do with database actions; Insert, Update and Delete.
It would be nice that for each database action we can have several properties for the following:
a. If the query or insert works goto page a
b. If the query returns no rows goto page b
c. If there is some type of database error goto page c
Several uses for the above mentioned would be as follows:
I'm attempting to do an insert on a database however one of the required fields was not supplied - goto the error page
I have done a query and it is retuning no rows. A page to display No data has been found would be appropriate
and other... I'm sure you get the idea.
PS: I have only worked with ASP and CF templates.
--Jeff
|
|
|
 |
eDuck
|
| Posted: 09/21/2002, 12:06 AM |
|
Using SQL server, you can already achieve this result by inserting and event after each of the above steps.
You can return the #of rows, any errors and success operations with a SQL Stored procedure, which also executes faster then having CCS calling the SQL statement every time as it has to be compiled every time by SQL server.
|
|
|
 |
|