Re: [libreoffice-users] Parameterised query

2012-03-01 Thread Mark Stanton
Thanks Drew, now clear. For you too Fernand? Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.d

Re: [libreoffice-users] Parameterised query

2012-03-01 Thread Fernand Vanrie
On 01/03/2012 15:11, Mark Stanton wrote: Hi Fernand, so "?" works for native SQL ":" works for OO-SQL I'm not sure if you are asking me a question or making a statement. sorry, i just wanted to know if ?parameter works for native SQL mode and

Re: [libreoffice-users] Parameterised query

2012-03-01 Thread drew jensen
On Thu, 2012-03-01 at 14:11 +, Mark Stanton wrote: > Hi Fernand, > > > so "?" works for native SQL > > ":" works for OO-SQL > > I'm not sure if you are asking me a question or making a statement. > What you are saying is not what I was saying, I'm not certain it is right, > I don't thi

Re: [libreoffice-users] Parameterised query

2012-03-01 Thread Mark Stanton
Hi Fernand, > so "?" works for native SQL > ":" works for OO-SQL I'm not sure if you are asking me a question or making a statement. What you are saying is not what I was saying, I'm not certain it is right, I don't think it is. I may be wrong :-) Regards Mark Stanton One small step for

Re: [libreoffice-users] Parameterised query

2012-03-01 Thread Fernand Vanrie
Mark , so "?" works for native SQL ":" works for OO-SQL Greetz Fernand Hi Fernand, ?Isssue_Num (3s) ? greetz Fernand Thanks, but nope. The name Issue_Num, just identifies a parameter, it doesn't have to match the name of any field. The problem was the wrong SQL mode. Mark Stanton

[Solved] Re: [libreoffice-users] Parameterised query

2012-02-29 Thread Tom Davies
Hi :) Congrats on fixing the problem :)  Nicely done :) Regards from Tom :) --- On Wed, 29/2/12, Mark Stanton wrote: From: Mark Stanton Subject: Re: [libreoffice-users] Parameterised query To: users@global.libreoffice.org Date: Wednesday, 29 February, 2012, 22:13 Hi Fernand, > ?Isssue_

Re: [libreoffice-users] Parameterised query

2012-02-29 Thread Mark Stanton
Hi Fernand, > ?Isssue_Num (3s) ? > greetz > Fernand Thanks, but nope. The name Issue_Num, just identifies a parameter, it doesn't have to match the name of any field. The problem was the wrong SQL mode. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to

Re: [libreoffice-users] Parameterised query

2012-02-29 Thread Tom Davies
: [libreoffice-users] Parameterised query To: users@global.libreoffice.org Date: Wednesday, 29 February, 2012, 15:06 Hi, Taking advice here and the French FAQ on the Wiki (now translated :-) ), I see how to use parameters in a query. I have a query in my database that's linked to a MySQL database an

Re: [libreoffice-users] Parameterised query

2012-02-29 Thread Fernand Vanrie
On 29/02/2012 16:06, Mark Stanton wrote: Hi, Taking advice here and the French FAQ on the Wiki (now translated :-) ), I see how to use parameters in a query. I have a query in my database that's linked to a MySQL database and it just complains "The data content could not be loaded. No value sp

Re: [libreoffice-users] Parameterised query

2012-02-29 Thread drew jensen
On Wed, 2012-02-29 at 15:06 +, Mark Stanton wrote: > Hi, > > Taking advice here and the French FAQ on the Wiki (now translated :-) > ), I see how to use parameters in a query. > > I have a query in my database that's linked to a MySQL database and > it just complains "The data content could

[libreoffice-users] Parameterised query

2012-02-29 Thread Mark Stanton
Hi, Taking advice here and the French FAQ on the Wiki (now translated :-) ), I see how to use parameters in a query. I have a query in my database that's linked to a MySQL database and it just complains "The data content could not be loaded. No value specified for parameter 1" with the query