if you place the output of a Search or Insert Action into a DirectDBMS that contains
quotes wrap the DiretDBMS in
<@ASSIGN noSQLEncoding true>
DBMS
<@ASSIGN noSQLEncoding false>
this will stop Witango from trying to determine quotes needed and just submit it as is
--- message from "John Shaw" <[EMAIL PROTECTED]> attached:
_____________________________________________________________
The best email provider on today's market, sign-up now for as low as $20.00 AUD per
year! http://www.aussiemail.com.au
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--- Begin Message ---
Title: Re: Witango-Talk: Query Problem
|
That's the query generated by Witango in the
insert action.
----- Original Message -----
Sent: Monday, August 25, 2003 12:37
PM
Subject: Re: Witango-Talk: Query
Problem
John Why the “
“ around Tracking number.
Witango SQL Query:
INSERT INTO Orders_Tracking
(Order_Number,Tracking Number) VALUES ('@@local$Order_Number','@@local$Item_Description')
Try
on 8/25/03 10:52, John Shaw at [EMAIL PROTECTED] wrote:
Hello
again,
I've been
using this Insert for years and it stopped working last week. It might
have something to do with upgrading to Witango. [Order_Number] and
[Tracking Number] are both varchar fields. Does this have something to
do with the space in my field name? Thanks
Witango SQL Query:
INSERT
INTO Orders_Tracking (Order_Number,"Tracking Number") VALUES
('@@local$Order_Number','@@local$Item_Description')
MS-SQL2000 Error Message:
[SQL Server]Unclosed quotation mark before the
character string ') VALUES
('2003081172288','1ZA761R70141736284')'.
________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
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: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
|
--- End Message ---
