You need to add the following assignments to the taf

<@ASSIGN noSQLEncoding true> 
to the section prior to submitting the DirectDBMS

and

<@ASSIGN noSQLEncoding false> 
to the top  of results section or the 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 Dan Stein
Sent: Friday, January 17, 2003 4:15 PM
To: Multiple recipients of list witango-talk
Subject: Witango-Talk: Execute SQL taf

I have used this for awhile as a way to do a query, update, insert etc
to my
DB but I always have a problem with
Select * from courses where course name='My Course'

The debug code shows

Select * from courses where course name=''My Course''

Or if I put in Select * from courses where course name=My Course

It gives me Select * from courses where course name=My Course

Which is also an error

What am I doing wrong and is there another solution


-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com



________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

Reply via email to