That fixes it The <@Assign noSQLEncoding True> at the top does not work at
least in MSQL but adding the ENCODING=none to the <ARG SQL> in the DBMS
works.
Thanks
Dan
--
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
> From: "Bill Downall" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Sat, 18 Jan 2003 23:03:38 -0500
> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
> Subject: Re: Witango-Talk: Execute SQL taf still a problem
>
> Dan,
>
> Be sure you don't have ENCODING="SQL"
>
> NONE is probably what you want at that place.
>
> SQL encoding makes the quotation character get doubled, as it would
> need to be to escape a literal quotation mark within a value.
>
> Bill
>
> On Sat, 18 Jan 2003 21:33:02 -0500, Dan Stein wrote:
>
>> 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 registration where Lname='Cat'
>>
>> The debug code shows
>>
>> Select * from registration where Lname=' 'Cat' '
>>
>> Or if I put in Select * from registration where Lname=Cat
>>
>> It gives me Select * from registration where Lname= Cat
>>
>> Which is also an error
>>
>> Even if I try and double quote things it does not work
>>
>> What am I doing wrong and is there another solution
>>
>> I am on Witango 5 and MSSQL 2000
>>
>> If someone could connect this taf to any table on their system and
> get it to
>> run or suggest a better way for me to set up a single taf to do simple
>> queries I would be most happy. I am usually doing selects,
> sometimes updates
>> a rarely deletes.
>>
>> I do think there is a need for a taf that would allow remote DB
> access.
>> Someone had one for RBASE but we need on that is more DB
> agnostic.
>>
>>
>>
>>
>> --
>> 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
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
