oops, I left debug on in the TAF and the TCF :-b Your wish is my command II
<@QUERY SourceInfo="" SQLStmt="" ArrayName=""> SourceInfo = three comma separated facts DSN,USERID,PASSWORD SQLStmt = sql statement, one that returns a result ArrayName = the name of the local returned local variable that contains the results of SQLStmt example: <@QUERY SourceInfo="Metatags,," SQLStmt="Select * from WitangoMetatags" ArrayName="retArray"> place the TestDoQuery.taf and doquery.tcf in the folder website ie c:\inetpub\wwwroot\mydomain place the doquery.txt in the customtag folder designated in your witango.ini or t4server.ini run the TestDoQuery.taf ie http://www.yourdomain/TestDoQuery.taf Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm latest beta downloads @ http://www.witango.ws
doquery.tcf
Description: Binary data
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE TAGPACKAGES SYSTEM "ctags.dtd" >
<tagpackages Version="0x02000001">
<packagedef id="DoQuery">
<author>Ben Johansen</author>
<version>1</version>
<packagedesc>
returns an array base on a sql statement sent in
</packagedesc>
<objects>
<objectdef id="doquery" type="TCF" systemobject="false">
<name>doquery.tcf?Class=doquery</name>
<varname>doqueryinstance</varname>
<scope>local</scope>
</objectdef>
</objects>
<tags>
<tagdef name="query" objectid="doquery">
<method>QueryArray</method>
<encoding>NONE</encoding>
<attrdef name="SourceInfo" required="true">
</attrdef>
<attrdef name="SQLStmt" required="true">
</attrdef>
<attrdef name="ArrayName" required="true">
</attrdef>
</tagdef>
</tags>
</packagedef>
</tagpackages>
TestDoQuery.taf
Description: Binary data
