RE: .NET Data question

["Don Cavaiani" <dcavaiani@xxxxxxxxxxxxx>]

generating a string for the SQL statement 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hayes, Joe
Sent: Thursday, February 15, 2007 12:48 AM
To: Midrange Systems Technical Discussion
Subject: RE: .NET Data question

Are you using prepared statements, or generating a string for the SQL
statement?
A prepared statement should avoid that.

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/h
tml/dbpgen9/00000021.htm


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Monday, February 12, 2007 12: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.


--
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 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.