Interactive Queries?

[mangafan75]

Hi, I have a question regarding interactive or dynamic sql queries.

Many years ago I worked a bit with MS Access creating a mp3 database.

I also created queries that could select for instance a particular artist or song from the database by asking the user to write the name/title of the artist/song that the user would like to see.

This was done by using the [ ] function when creating the queries in MS Access.

Now, can I create the same sort of interactive queries using SLQyog connecting to MySQL?

I tried the same type of code – using the [ ] but that didn´t work.

I am a newbie at this so please if someone could enlighten me…:-)

[peterlaursen]

No you cannot.

This is a special Access feature and not a standard SQL feature.

In Access you can actually just use a non-existent column name and it is treated like a parameter that can be substituted.

SQLyog is a SQL-based database client. We can only support what is supported by the server!

Of course such parsing functionalities could be implemented in the tokenizer/editor (just as 'DELIMITER' is). I shall not exlude that we will some day, but it is not priority! With MySQL most people would use a FORMS feature of (D)HTML or a scirpting language for this.

[mangafan75]

peterlaursen wrote on Sep 29 2006, 02:41 PM:

No you cannot.

This is a special Access feature and not a standard SQL feature.

In Access you can actually just use a non-existent column name and it is treated like a parameter that can be substituted.

SQLyog is a SQL-based database client. We can only support what is supported by the server!

Of course such parsing functionalities could be implemented in the tokenizer/editor (just as 'DELIMITER' is). I shall not exlude that we will some day, but it is not priority! With MySQL most people would use a FORMS feature of (D)HTML or a scirpting language for this.

Ok! I understand. Thank you for the quick reply.

cheers

[Author]

Posts