[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database

2006-09-11 Thread willie2
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69432





--- Additional comments from [EMAIL PROTECTED] Mon Sep 11 00:28:26 -0700 
2006 ---
I can check that, i hope this only refers to the a bit exaggerated 
Priority. 
In case you can't reconstruct the problem feel free to ask me for more details
that might be missing.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database

2006-09-11 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69432


User msc changed the following:

What|Old value |New value

 Assigned to|dbaneedsconfirm   |msc

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW





--- Additional comments from [EMAIL PROTECTED] Mon Sep 11 00:34:45 -0700 
2006 ---
Hi,

I can reproduce this if and only if you enter the sql string manual _and_ if the
name of the parameter is the same as the field name from the master table. 
If you name the parameter not position but x_position this works for me.

Can you confirm this.

Bye Marc

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database

2006-09-11 Thread willie2
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69432





--- Additional comments from [EMAIL PROTECTED] Mon Sep 11 04:30:20 -0700 
2006 ---
Hi,

great idea!! If i name the parameter different from the field name of the main
form it works.

But i still found some strange behavior:
- There is no difference between using the SQL query designer and entering the
SQL string manual.
- Linking the subform with a named parameter only works if i use a different
name for the named parameter as mentioned above and if i use OOo 1.1.X to change
the SQL query and if i then open the form in OOo 2.0.3. In case i change the SQL
query in OOo 2.0.3 there will be a warning no value specified for parameter 2
and the subform will stay empty.
I think there is a problem how OOo sends the Query to MySQL because i have to
use apostrophs in the query like 'position' = :'xposition' in OOo 1.1.X. If i do
exactly the same in OOo 2.0.3 there will be the warning???

regards Willie


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database

2006-09-11 Thread msc
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69432


User msc changed the following:

What|Old value |New value

 Assigned to|msc   |fs

Priority|P2|P3

Target milestone|not determined|OOo 2.x





--- Additional comments from [EMAIL PROTECTED] Mon Sep 11 05:10:46 -0700 
2006 ---
Hi Willie,

Ok, I send this issue to the right developer to fix the problem when the
parameter has the same name as the field.

 There is no difference between using the SQL query designer and entering the
 SQL string manual.

this is intended in this way to support users without sql knowlegde

Bye Marc

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



[dba-issues] [Issue 69432] named parameters do not wo rk for MySQL-Database

2006-09-10 Thread rainerbielefeld
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=69432


User rainerbielefeld changed the following:

What|Old value |New value

  CC|''|'rainerbielefeld'

Keywords|  |oooqa

Priority|P1|P2

 Summary|named parameters do not wo|named parameters do not wo
|rk|rk for MySQL-Database





--- Additional comments from [EMAIL PROTECTED] Sun Sep 10 10:52:05 -0700 
2006 ---
No P1, but may be serious.
I can't check that.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]