Links to execute operations with SQLEdit

Which are links to use to let an SQLEdit elemento execute operations as creating new record, modifying or deleting of an existing one?

What it says to SQLEdit of choosing an operation or another one, is the part of page url which has an SQLEdit element on the right of the question mark symbol. This part is also known as "query string".

We suppose therefore that our page with the SQLEdit element is available to the url

http://www.domain.ext/index.pl/our_page

to execute database operations with our SQLEdit element, this page must be linked with these "query string":

per fare eseguire operazioni sul database al nostro elemento SQLEdit questa pagina va chiamata con le seguenti "query string":

to add a new record is sufficient to open this url without query string or, use this query string:

...?exec=new

to modify an existing record you must creare a link with query string formed by the parameter "exec = edit" and by all primary keys of the table with their correct value. If table, as an example, has three primary keys "pk1", "pk2" and "pk3" and you wish to edit the record with "pk1 = v1", "pk2 = v2" e pk3 = v3" you must use this query string:

...?exec=edit&pk1=v1&pk2=v2&pk3=v3

in analogous way, to delete an item, the link must be formed by the url above and by a query string that has the values of the primary keys of the element to delete and the parameter "exec = delete". By using the example above, the link would be as:

...?exec=delete&pk1=v1&pk2=v2&pk3=v3

This last link doesn't delete the record directly but asks a confirmation before executing deletion. To delete directly the record without show the confirmation page, you must use this link:

...?exec=deleteConfirm&pk1=v1&pk2=v2&pk3=v3

JavaScript Menu Courtesy of Milonic.com




	Site Utility



	Printer version Leggilo in italiano Site stats Read forums Site map




	Resources



	Download SQLEdit Download SQLEdit beta How to install ChangeLog




	Documentation



	Add/Edit Template Template for fields Field properties Field check Database operation Upload type Template usage Master-detail tables Events usage




	Ads by Google




	Chat with me



	My nickname is emi but now I am offline. However you can usually find me on these channels of the Azzurra networks: areanetworking, telug, controguerra, webgui, geeks, pescaralug




	Internal related links



	WebGUI BlobViewer Wobject Allow to insert in your web pages and, however, to download, binary or textual data stored in database columns of BLOB type. These data can be of whatever type such as images, pdf documents, autocad files, etcetera. WebGUI SQLExt Macro A WebGUI Macro to execute SQL statements. As regard to WebGUI standard macro, it allows to execute query to external database and to execute DELETE, UPDATE and INSERT statements. WebGUI GDWGraph Wobject A WebGUI Wobject to create graphs from external sources. Support for lines chart, point chart, area chart, bar chart, 3D bar chart and 3D lines chart WebGUI DateTime patch Rewriting of the standard module WebGUI::DateTime that solves the fact that, in all WebGUI versions,is not possible to enter date before 01/01/1970 WebGUI, a C.M.S. for everybody. The ideal solution to realize and update web contents in a collaborative environment or anyhow from whom is 'not assigned to the jobs' requires the use of a content management system. Of these environments we'll analyze the salient characteristics for dealing therefore the main installation and property of one of theirs: WebGUI.




	External related links



	WebGUI Home page A versatile content managment system (C.M.S.) to simply build dynamical web site. Written in Perl, it generates dynamical content from templates using the HTML::Template module. It represents a simple framework to give also to who knows nothing about HTML.




	Credits



	Mason All this website has built using Mason. Without this language derived from Perl, most of the tools used for the manage of this site would never been developed. JavaScript Menu The great menu at the top of this page.

Comments


Copyright© 1997-2006 Emiliano Bruni	Online from 16/08/1998 with visitors	Write me to:


Name	E-mail	URI