[nero]

Thanks.

So you found the problem.

Happy I could help and looking forward to 3.5

Greetings nero :ph34r:

[nero]

The Perl way HERE is also in Php

Taken from the manual:

Code:

echo << This uses the “here document” syntax to output
multiple lines with $variable interpolation. Note
that the here document terminator must appear on a
line with just a semicolon no extra whitespace!
END;

will be translated for the query as

Code:

$qry=<< SELECT *
FROM testtable;
END;

While I don't use Perl and have no acknowledge of it I see here that Php uses 3 < instead of 2 that Perl does but the way it works should be the same. For the other Perl methods I don't know there equivalents if they exist in Php. Well this about the advanced non M$ languages. How to do it in VBasic (VBA)?

Code:

Dim qry as string 'otherwise I get error for shure;)
qry=”SELECT *
FROM table
WHERE id=1″

Oh no this doesn't work.

Code:

Dim qry as string 'otherwise I get error for shure;)
qry=”SELECT * _
 FROM table _
 WHERE id=1″

And this should does it. End every line where a follow up exists with a space+underscore.

The only thing I found in the variants of VBA is that sometimes it works and sometimes not.

The reason is't clear for me.

Code:

Dim qry as string 'otherwise I get error for shure;)
qry=””
qry=qry & “SELECT *”
qry=qry & ” FROM table”
qry=qry & ” WHERE id=1″

This way or there equivalent's have one nice feature, you can easy add or comment a part of the query.

And with copy/paste the leading part is not so worse to add. Even with the trailer you can do it.

BTW For Php (and Perl?) you can also do it as

Code:

$qry =””
$qry.=”SELECT *”;
$qry.=” FROM table”;
$qry.=” WHERE id=1″;

Note to the dots at secondline and up

This method I prefer to do for the easy adjusment by commenting a line(s).

Just remember an other method I have seen

Code:

$qry =””
. “SELECT *”
. ” FROM table”
. ” WHERE id=1″;

nero :ph34r:

Summary:

SQLyog is to create the queries and test them.

How they wil be used in the many programming languages and the way they can handle this stuff is, I think, out the scope of SQLyog.

If they can add a way to add a prefix and suffix for each line then the only thing you have to do is adjusting the first and last line to match the language and variant in it.

And, I think/wish, is the only help they can provide to make many people happy with this issue.

I agree with the option of a button to do this fixxing would be nice.

The use of cut/paste by the use of a key shortcut as ctrl-A to select all, already in use by many applications, and ctrl-V in the external application does the job very well, without this fixing.

nero :ph34r:

[nero]

Forgot to add the data file 🙁

So here it is

I have tested with this as source and the behaviour is still there so

it must work at your side also bad.

nero :ph34r:

[nero]

Hi Ritesh.

As you wil see this was in a sensitive table so i had to obscure some columns

The monitor resolution was 1024/768 but on my second 1280/1024 it's the same.

The window for 'insert/update data F11' sizes just inside the main window but the problem stays

It's the 'CustomGridControl' that has some problems on the right side.

If you need other or more data I have to prepare some but I think you can use this.

I hope you can find the problem for next release.

Greatings from nero :ph34r:

[nero]

Well that wil make a recordset result of

count(v_all) * count(v_teacher_main) * count(v_def_instruments) * count(v_county)

when I am right and that can be the problem.

Try to modify your query as follows. That can be the proper resultset you want.

SELECT v_all.*, v_teacher_main.*, v_def_instruments.*, v_county.*

FROM v_all

JOIN v_teacher_main

ON v_all.pid = v_teacher_main.pid AND (v_teacher_main.InstrumentKey= 6 OR v_teacher_main.InstrumentKey= 1)

JOIN v_def_instruments

ON v_teacher_main.instrumentkey = v_def_instruments.instrumentkey

JOIN v_county

ON v_all.pCounty = v_county.countyid

Maybe that will do the job.

nero :ph34r:

[nero]

Ritesh:

I just found this problem also.

It looks to me it is sensitive to the size of the content in the fields.

When i press F11 to edit a field (the las one) I miss the two last collumns in my view.

Did a copy of the structure to a test db and all the fields are there

Then insert the data and in my case the 2 last fields are gone.

Using the horizontal scrollbar and go to the right does not work.

Using the column resize handles and narrow the columns on the left slide of the

missing fields let them slide in on the right side.

So the range of the horizontal scrollbar is not big enough.

Also on the right side the last handle is hidden behind the vertical scrollbar.

B.T.W. The handles to size the columns are very narrow, a few pixels.

Can they be made bigger in width ?

nero

[nero]

Some assistance for this is nice but if you are working with php there is a simple solution.

$query=”

SELECT *

FROM table

WHERE x=1

“;

Only the bold blue on top and bottom and you are ready!! 😛

nero :ph34r:

[nero]

hi,

May be a good tip.

I have a ADSL connection but MSDN is still f… slow while they refresh constantly the whole page.

So I started to simple save the page as .mht (IE version only)

You wil get a single file, internal it's a email, with all the stuff text and pictures in it if they are on the page.

You can copy this file to any place and it still works. Becarefull not to use Save as .html because that is not working so nice. It creates a directory with the page title as name and there are people that makes it very long. Secondly the html file is rewriten to the path you used to store it and is not to move to other place without editing the whole page.

Another option is to use something as SiteSnagger or HTtrack (wich I use) to get a copy of such pages. 😉

nero :ph34r:

[nero]

Thanks 🙂

[nero]

Hi Olivier,

Wel that sounds not good. 🙁

If they say there is a GUI that works on there MySQL version why don't they tell you wich one.

Problem may be solved, and not a upset customer. 😡

Still I believe they must have changed more things to not standard behaviour. If the customers all using phpAdmin then they must have changed that one to. :huh:

If they have a commercial license for MySQL then they are also allowed to change it as they like, I think everybody has that right, so you can't do anything against it.

Same is for phpAdmin. For both are the sourcecode free to use I believe. 😮

With there response is it also not custom friendly.

I don't understand that in the beginning of this topic you was so happy with them, but anyway thay are not the only one in France.

Quote:

How do you say “go to hell?”.

That is in Dutch “Loop naar de hel.” 🙄

I hope you will find a solution but this will be fighting against air.

Nero :ph34r:

[nero]

Still another question.

I have readed your explanation again.

They say customized MySQL? –we modified mysql to suit our own needs

Well that gives me the hint for the posibility that they did not use a dot at all.

Like I do some protection to not follow the simple standard rules but use a comma in the name. For many viewers it is not always clear to see in a filename in a quick look. Just like using not a space chr(20) but a space chr(255) or chr(176).

Posible is the dot a ¸ ascii character 184 ¸ look almost the same for example on my lcd monitor size 1024/768. 😉

Why did they customize? Securety perhaps :P. Strange that there phpAdmin works and yours not. I have tried the same as your action create a dot db and copy the files in it. No difference with phpAdmin 2.3.3 or 2.5 and the same result as you have. Not working :(. SQLyog show the database in the objectbrowser but can't create/see any table. Did they modify phpAdmin also to show you a dot and are they using in real another character.? It can be done.

It looks to me that you are able to access your database with there phpAdmin localy only for security reasons.

Secure Nero

[nero]

Hi again,

Sorry for the long quote above. had not intention to do that.

I'm i right 'olivierf77' if i understand the provider can use dots in the database name?

If so and the backticks does not work then maybe they are running the server in ANSI mode.

As I have just read in the manual (for 4.0.5) the dot is not allowed to use.

You can find about that in the manual at 6.1.2.

The difference for ANSI mode describes that the double qoute is used instead of the backtick when I am reading it the right way. See section 1.7.2 (or on the website 1.8.2).

English is not my native language so I can interprete it false but Ritesh wil understand it, I think.

About your idee to use a alias for the database name, in the same section 6.1.2 is

also information about the characters allowed for the objects, all say NO to the dot but for the alias it's ok.

from the man:

Identifier, Max length, Allowed characters

---

Database 64 Any character that is allowed in a directory name except `/', `' or `.'

Table 64 Any character that is allowed in a file name, except `/' or `.'

Column 64 All characters.

Alias 255 All characters.

Also a question is the real name of the database.

Is it shure it does not contain a reserved word. The list is very big but some should be nice to have as domain name. In manual 6.1.7 is the list

Ritesh:

Can it be a bug(small) if SQLyog crashes when I try to use

'USE databasename as aliasname' ?

Have a little luck Nero.

[nero]

olivierf77 wrote on May 28 2003, 07:34 PM:

Dear Ritesh

History tab content, with my comments prefixed by —

— user comments: initialization

[15:20:16][ 60 ms] show databases

[15:20:19][ 60 ms] use `myname.cc`

[15:20:19][ 70 ms] use “

[15:20:19][ 60 ms] use “

— => displaying msg err 1045

— issuing order manually

[15:21:05][ 70 ms] use `myname.cc`

[15:21:05][ 60 ms] select database()

— => success

— issuing order manually

[15:23:12][ 60 ms] show tables

— => success

[15:24:03][ 491 ms] select * from tb_first

— => success

[15:26:21][ 60 ms] select * from `myname.cc`.tb_first

— => failure. errmsg:

— Error code 1103

— Incorrect table name 'tb_first'

— (60 ms taken)

And, once again, the problem is not in your program, but in their very poor choice of a databasename.

BTW, PhpAdmin installed on their site (rel 2.2.42) accepts data and/or structure dump orders, on their database, but a more recent release (2.5.0) installed on my computer, fails to get any value or list dump.

Best Regards

Olivier

Hi,

I follow this discussion.

I have a tip for you.

The problem can be this part:

[15:26:21][ 60 ms] select * from `myname.cc`.tb_first

— => failure. errmsg:

— Error code 1103

— Incorrect table name 'tb_first'

— (60 ms taken)

try select * from `myname.cc`.`tb_first`

I think if you start using backticks you have to do it for all the parts of a database.table.field construction. MySql did accept the databasename now but have problems with the tablename.

I did see your way of using backticks in more examples and as far I know it should work with backticks but it is imho stupid to use names like this by a provider that should have competence.

Succes Nero.

[nero]

Hi

I tried 'USE databasename as aliasname'

Very nice crash with SQLyog (SQLyog3.11, mysql4.0.12).

So the alias isn't posible from SQLyog.

I haven't tried it on the commandline level.

[nero]

Wel try some other way's give me this as result

I found it related to missing UNION in MySQL v3 as a solution.

The idee is simple, make a table with only 1 field in it

Enter in the field a ascending number as much of tables you want to use in a UNION.

Make the pseudo UNION like this:

select d.num

, ifnull(db.host,ifnull(tables_priv.host,columns_priv.host)) as hhost

, ifnull(db.user,ifnull(tables_priv.user,columns_priv.user)) as huser

, ifnull(db.db, ifnull(tables_priv.db, columns_priv.db)) as hdb

, ifnull( ifnull( tables_priv.Table_name, columns_priv.Table_name ) , 'x') as htbl

, ifnull( ifnull( ifnull( columns_priv.Column_name,'y' ) ,'z' ) ,'w' ) as hcol

FROM dummy as d

left join db on (d.num=0 and

`db`.`user` like '%' AND

( `db`.`Select_priv` ='y'

OR `db`.`Insert_priv` ='y'

OR `db`.`Update_priv` ='y'

OR `db`.`Delete_priv` ='y'

OR `db`.`Create_priv` ='y'

OR `db`.`Drop_priv` ='y'

OR `db`.`Grant_priv` ='y'

OR `db`.`References_priv`='y'

OR `db`.`Index_priv` ='y'

OR `db`.`Alter_priv` ='y')

)

left join tables_priv on (d.num=1 and

`tables_priv`.`user` like '%' AND

( `tables_priv`.`Table_priv` <>''

OR `tables_priv`.`Column_priv` <>''

)

)

left join columns_priv on (d.num=2 and

`columns_priv`.`user` like '%' AND

(

`columns_priv`.`Column_priv` <>''

)

)

where d.num<3;

For each loop on the dummy table you get a new where clause and that will do the UNION of the tables.

It is not my creation how this is working but it works very well.

And I believe it has some nice possibilties in advance of the UNION.

Nero is happy :ph34r: 😀

[Author]

Posts