CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Enhancement Request for CCS: Database Actions

Print topic Send  topic

Author Message
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.

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.