Location: PHPKode > projects > Customer Inquiry Management System > ute/index.html


  <TITLE>UTE v3.01 - Universal Table Editor</TITLE>
  <LINK REL="stylesheet" TYPE="text/css" HREF="ute_style.css">

<BODY BGCOLOR="#FFFFFF" LINK="#0000A0" VLINK="#0000A0" ALINK="#0000A0">


<H1>UTE v3.01 - Universal Table Editor</H1>

<H3>Very welcome to this small demo site of UTE.</H3>

<P>To setup UTE, please copy the contents of the ZIP file (including all subdirectories)
to a folder of your choice, create a <B>Virtual Directoty</B> in your <B>IIS</B> that
points to it, and launch the <B>index.html</B> (this) page from within this virtual directory.</P>

<P>There are two ways to connect UTE to a database: 
  <LI>Via ODBC, using a so alled <b>DSN connection</b>.
  <LI>Via OLEDB Provider, this means directly to the file, a so called <b>DSN-less connection</b>.

<P>This demo uses the second way, the <b>DSN-less connection</b>. So, you don't need to setup
an ODBC datasource first. Due to differences within the ODBC driver and OLEDB Provider 
implementations UTE is not always able to detect the <B>Primary Keys</B> of your table. If you
encounter problems with this just try the other connection method (see 
<A HREF="http://www.codeproject.com/asp/ute.asp" TARGET="_BLANK">UTE Article on CodeProject</A> for more details).</P>

<P>If you want UTE to list all tables of the current database <B>TEST.MDB</B>, 
just call it without any parameter:
  <LI><A HREF="ute.asp"><b>ute.asp</b></A>

<P>Alternatively you can set the table to be viewed as URL parameter:

  <LI><A HREF="ute.asp?name=Employees"><b>ute.asp?name=Employees</b></A>
  <LI><A HREF="ute.asp?name=OrderDetails"><b>ute.asp?name=OrderDetails</b></A>
  <LI><A HREF="ute.asp?name=Orders"><b>ute.asp?name=Orders</b></A>
  <LI><A HREF="ute.asp?name=Products"><b>ute.asp?name=Products</b></A>

<P>As already mentioned UTE is not able to detect <B>PRIMARY KEYS</B> when being connected to the database via ODBC. In this
case you are able to set the <B>PRIMARY KEYS</B> as additional parameters:
  <LI><A HREF="ute.asp?name=OrderDetails&pkey1=OrderID&pkey2=ProductID"><b>ute.asp?name=OrderDetails&pkey1=OrderID&pkey2=ProductID</b></A>

<P>Per default UTE displays the fields of the table in the order as they have been defined. You can ask UTE 
to sort them alphabetically using an additional parameter:
  <LI><A HREF="ute.asp?name=Employees&sorted=1"><b>ute.asp?name=Employees&sorted=1</b></A>


<P>That's all for the moment and for this small UTE demonstration. There are two locations to get the latest
version of UTE the most recent documentation from and to join discussions about it:
  <LI><B><A HREF="http://sourceforge.net" TARGET="_BLANK">SourceForge</A></B>
  <P>UTE is maintained on SourceForge as an OpenSource project unter the 
  <A HREF="http://www.gnu.org/licenses/gpl.html" TARGET="_BLANK">GNU General Public License</A> 
  <A HREF="GPL.html">(GPL)</A>. 
  The latest changes and releases can always be found here<BR><BR>
    <LI><A HREF="http://sourceforge.net/projects/ute-asp/" TARGET="_BLANK">http://sourceforge.net/projects/ute-asp/</A>

  <LI><B><A HREF="http://www.codeproject.com" TARGET="_BLANK">The Code Project</A></B>
  <P>The project homepage of UTE is located here. Even though UTE is developed on SourceForge this is the
  location of the <B>latest documentation</B> !<BR><BR>
    <LI><A HREF="http://www.codeproject.com/asp/ute.asp" TARGET="_BLANK">http://www.codeproject.com/asp/ute.asp</A>


<P>The history of UTE can be found <A HREF="whatsnew.txt">here</A>.</P>

<P>And now: Enjoy UTE !</P>

<P>Tom Wellige, <A HREF="mailto:hide@address.com"><b>mailto:hide@address.com</b></A>, 
<A HREF="http://www.wellige.com" TARGET="_BLANK"><b>http://www.wellige.com</b></A><P>



Return current item: Customer Inquiry Management System