RE: .NET Data question

["Craig Jacobsen" <CraigJacobsen@xxxxxxxxxxx>]

Right out of the manual:

DTW_ADDQUOTE


Purpose 

Replaces single quotes in an input string with two single quotes. The
replacement is needed so that SQL statements can be processed correctly when
a string contains a single quote. 

Consider using this function for all SQL INPUT statements. For example, if
you enter O'Brien as a last name, as in the following example, the single
quote might give you an error: 

INSERT INTO USER1.CUSTABLE (LNAME, FNAME)
VALUES ('O'Brien', 'Patrick')

Using the DTW_ADDQUOTE function changes the SQL statement and prevents the
error: 

INSERT INTO USER1.CUSTABLE (LNAME, FNAME)
VALUES ('O''Brien', 'Patrick')

Format 

@DTW_ADDQUOTE(stringIn, stringOut) 

@DTW_rADDQUOTE(stringIn) 

HTH,

Craig

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Monday, February 12, 2007 1:38 PM
To: Midrange Systems Technical Discussion
Subject: RE: .NET Data question

Hi Doug:

I have a comment field, and when the users key in something like:   I'll
get back to you.   - The apostrophe (I believe) is bombing out the SQL
statement.  There must be an easy solution for that??

Thanks,
Don C. 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hart, Doug
Sent: Tuesday, January 30, 2007 3:26 PM
To: Midrange Systems Technical Discussion
Subject: RE: .NET Data question


 The very best Net.Data support can be found here.  

http://dtwdude.com/ 


--
Doug Hart - Sr. iSeries Consultant
ITT Corporation  -  Enterprise Infrastructure (EI) Seneca Falls, New
York  -  DataCenter
Voice: 315-568-7568    Doug.Hart@xxxxxxx
 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Allen
Sent: Monday, January 29, 2007 8:24 AM
To: Midrange Systems Technical Discussion
Subject: .NET Data question

have a kinda vendor developed/kinda in house klidged (not by me) site
using NET data and intermittently getting the following, before I call
the vendor and/or get on our in house people does the error msg below
give me any idea as to what (it very well could be a data issue).

NET.DATA Error: Function call to DTW_FORMAT failed. Error Number is
4001.

--
http://unsystematic-diversity.blogspot.com/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.


************************************
This e-mail and any files transmitted with it are proprietary and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this e-mail in error please notify the
sender. Please note that any views or opinions presented in this e-mail
are solely those of the author and do not necessarily represent those of
ITT, Inc. The recipient should check this e-mail and any attachments for
the presence of viruses. ITT accepts no liability for any damage caused
by any virus transmitted by this e-mail.
************************************


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.