Your wish is my command <@QUERY SourceInfo="" SQLStmt="" ArrayName=""> SourceInfo = three comma seperated facts DSN,USERID,PASSWORD SQLStmt = sql statment, one that returns a result ArrayName = the name of the local returned local variable that contains the results of SQLStmt
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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Smith Sent: Wednesday, September 25, 2002 6:15 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Meta tag for searching a table within a taf or tcf Another one to add to the list for the With developers to consider....this issue would be solved if Witango implmeted a <@query> tag that let you write SQL in results. I know this is abilty exists in php and cf. csmith ----- Original Message ----- From: "Ben Johansen" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 4:08 PM Subject: RE: Witango-Talk: Meta tag for searching a table within a taf or tcf > Well you could create a custom tag that call a directDBMS ;-) > > No, there is only the 2 action Search and directDBMS > > Ben Johansen - http://www.pcforge.com > Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm > Latest downloads & List Archives @ http://www.witango.ws > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Fogelson, Steve > Sent: Wednesday, September 25, 2002 1:00 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Meta tag for searching a table within a taf or > tcf > > I looked through the documentation and didn't find anything, but as my > wife > tells me, sometimes the obvious is right in front of my face. > > Is their a meta tag for searching a table within a taf or tcf? Or is the > only option a search action? > > Thanks > > Steve Fogelson > Internet Commerce Solutions > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
TestDoQuery.taf
Description: Binary data
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</name>
<varname>runsqlinstance</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>
