TADOQuery problem with send XML <?xml ...> paramcheck=false doesn't work

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Grzegorz Wed, 15 Jun 2005 17:17

#842

Author: Grzegorz
Date: Wed, 15 Jun 2005 17:17

9 lines
1280 bytes

Hello,
I want to save in MySQL Database a XML string, I am using TADOQuery, and 
when I execute ExecSQL function i get an error (too few parameters) This 
error is generate by a "?" (question mark) in XML string, sometimes ago i 
had similar problem but then i used dbExpress (TSQLQuery) i set checkparams= 
false and it worked. I was searching in Google but without resultats.

sorry for my poor english,
best regards Gregory Jakubowski

Re: TADOQuery problem with send XML <?xml ...> paramcheck=false doesn't work

#844

Author: Viatcheslav V. Vassiliev
Date: Wed, 15 Jun 2005 20:45

23 lines
1923 bytes

Use parameters and pass your XML as parameter.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Grzegorz" <mystuff@o2.pl> �������/�������� � �������� ���������: 
news:42b0629b@newsgroups.borland.com...
> Hello,
> I want to save in MySQL Database a XML string, I am using TADOQuery, and 
> when I execute ExecSQL function i get an error (too few parameters) This 
> error is generate by a "?" (question mark) in XML string, sometimes ago i 
> had similar problem but then i used dbExpress (TSQLQuery) i set 
> checkparams= false and it worked. I was searching in Google but without 
> resultats.
>
> sorry for my poor english,
> best regards Gregory Jakubowski
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads