Have you tried this, I do this all the time on special needs Just before the insert issue this <@ASSIGN noSQLEncoding true>
And just after the statement issue this <@ASSIGN noSQLEncoding false> Ben -----Original Message----- From: Matt Muro [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:23 AM To: [email protected] Subject: Witango-Talk: noSQLEncoding ini setting I searched through the forum archives and saw some posts regarding Witango 5.5 and SQL encoding in DirectDBMS actions. It sounds like people WERE able to get the noSQLEncoding=false setting in the 5.5 witango.ini to automatically quote meta tag values. This doesn't seem to be working for me, requiring me to add "encoding=sql" to all meta tag variables in my SQL insert/update statements. Is this .ini setting fried in 5.5 (Win32) or am I doing something wrong? Thank you. We're using: Witango Application Server 5.5.009 Liquorice (Win32) [Professional Edition] This worked in 5.0: [in witango.ini] NOSQLENCODING=false INSERT INTO users ( user_id, user_name, date) VALUES (<@VAR name="user_id" scope="local">, '<@VAR name="user_name" scope="local">', sysdate) -- producing the extra single quote in the user's name, O'Malley (damn Irish :) INSERT INTO users ( user_id, user_name, date) VALUES ( 1, 'O''Malley', sysdate) In 5.5, I have to add encoding=sql to my meta tags even though I have NOSQLENCODING=false set in the witango.ini [in witango.ini] NOSQLENCODING=false INSERT INTO users ( user_id, user_name, date) VALUES (<@VAR name="user_id" scope="local">, '<@VAR name="user_name" scope="local" encoding="sql">', sysdate) INSERT INTO users ( user_id, user_name, date) VALUES ( 1, 'O''Malley', sysdate) >From the "Witango 5.5 Programmer's Guide" page 494 (510 in PDF). noSQLEncoding Valid in all scopes This configuration variable determines whether text in Direct DBMS actions is SQL-encoded by default (single quote characters doubled). The default value is false. Setting the value to true turns off automatic SQL-encoding in Direct DBMS actions. If noSQLEncoding is set to true, you can use the ENCODING=SQL attribute on most value-returning meta tags to SQL-encode the value returned by that meta tag. >From the "Witango 5.5 Programmer's Guide" page 73 (89 in PDF). ---------------------------------------------------------------------------- ------------------------ The SQL encoding type converts the specified value by doubling all occurrences of the single quote character. Witango Server automatically performs SQL encoding on meta tag values substituted in Direct DBMS SQL, except when the configuration variable noSQLEncoding is set to true. The SQL ENCODING attribute value is generally appropriate only when noSQLEncoding is set to true, and allows you to toggle SQL encoding on or off for particular meta tags. ________________________________________________________ Matt Muro [EMAIL PROTECTED] Harvard University phone: 617.998.8522 Division of Continuing Education fax: 617.495.9176 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
