Not a developer? Go to MovableType.com

Plugin and Theme Directory

SQL v2.0

By Brad Choate
Posted November 30, 2002, in MT Tags, Templates, Widgets.

Details

The MTSQL tag can use SELECT statements like MySQL and PHP statements can.

<MTSQLEntries query="select entry_id from mt_entry
where entry_title like '%Movable Type%'">
<a href="<MTEntryLink>"><MTEntryTitle></a><br />
</MTSQLEntries>

Compatibility

Movable Type versions: 4.3


Back

40 Comments

linh.myopenid.com on June 24, 2008, 4:11 p.m. Reply

SQL is installed on MT 4.1. When ran with a simple query, nothing is returned, and there are
no errors or messages in the apache log files. Is this plugin compatible with 4.1? Thanks, - l -

Unicorn Ninja on December 24, 2008, 6:44 a.m. Reply

This might be the most useful plugin for MT yet. For someone attempting to highly customize a blog, this is extremely helpful. Thank you!

Drazend on January 3, 2009, 3:20 a.m. Reply

I installed this plugin on MT 4.2 and I get this:

“Cannot call method ‘cfg’ on object ‘MT::ObjectDriver::Driver::Cache::RAM=HASH(0x886dcfc)’ at /xxxxxxx/extlib/bradchoate/sql.pm line 602 “

Any idea what might be wrong?

Drazend on January 3, 2009, 3:45 a.m. Reply

Problem resolved by updating to SQL plugin 2.0 (had V 1.5).

Diana Schnuth on January 4, 2009, 4:26 p.m. Reply

I attempted to use a less-than in a where clause in a query (entry _ authored _ on < ‘[MTEntryDate format_name=’iso8601’]’), and discovered that the plugin gave me SQL syntax errors until I changed the < symbol to the & l t ; HTML escape character.

Just wanted to document that here, in case anyone else came across the same problem.

Bobb Menk on May 16, 2009, 7:37 a.m. Reply

Can anyone confirm if this plugin actually works with MT 4.2.3 with an Oracle backend?

Initial tests indicated that the plain MTSQL tag would work and that we could then use regular MT tags like MTEntry inside the MTSQL enclosure to display results. However right now we’re having trouble even with that, so I’m hoping to get a definitive answer.

We know the queries work using other tools to run them against the MT db, and we’re not getting any syntax errors from the templates, so I’m trying to determine if it’s the plugin itself or something outside of it.

Thanks for any light anyone can shed on this.

Bobb Menk on May 18, 2009, 12:36 p.m. Reply

Having worked on this a bit more, it now appears that with an Oracle backend, this plugin is limited to just the use of the MTSQL tag itself and the MTSQLColumn tag within that container. Regular MT tags do not appear to work, nor do the variants supplied by the plugin such as MTSQLEntries, etc. work.

It would be nice to be proven wrong on this, as it reduces the flexibility of the plugin significantly, but so far, that’s all we’ve been able to make it do.

Sunil Shrestha

Sunil Shrestha on August 26, 2016, 11:53 a.m. Reply

It works.

192.168.1.1

Naomi Stalenberg

Naomi Stalenberg on May 4, 2017, 11:06 a.m. Reply

Assignment writing help writers SQL is, as toby says, “preferred question language” wherein it’s miles a set of common sense based instructions used in querying datasources. It’s truly “structured query language” through the way, shhh! It isn’t always a programming language, as wamsie says. Sql. Is regularly utilized in programming, but to mention it’s far a programming language is inaccurate, it is not. Wamsie you actually need to test your reaction out on this… It is able to carry out responsibilities but that doesnt make it an software.

Besides, “Sql” is usually matters… It’s far a sort of server and it is a language for handling statistics, often also held in those servers, however this is not absolutely neces

sunny

sunny on November 2, 2017, 3:41 p.m. Reply

It is so play the jumble solver game https://jumblesolver.online online play.

milan

milan on June 19, 2018, 1:22 p.m. Reply

It’s nice to see the details regarding the SQL V2.0 plugin you have shared here. Thank you so much for sharing some of the important details over here. That helps me to understand more about this plugin. I am expecting more such plugins from here and keep up the good work.3D Eye Mask for Sleeping

johnjw

johnjw on November 21, 2018, 3:44 p.m. Reply

I appreciate this post. visit games.lol for arcade games

catherinwills

catherinwills on December 31, 2018, 9:55 a.m. Reply

wow.. nice article.powder coating company

draga

draga on January 16, 2019, 12:52 p.m. Reply

Magnificent goods from you, man. I have understand your stuff previous to and you are just extremely wonderful. I really like what you have acquired here, really like what you’re saying and the way in which you say it. You make it enjoyable and you still care for to keep it wise. I can not wait to read much more from you. This is really a great website.

brawl stars cheats for android

gandupilli

gandupilli on March 14, 2019, 2:56 p.m. Reply

wonderful. I really like what you have acquired here, really like what you’re saying and the way in which you say it. You make it enjoyable and you still care for to keep wonderful. I really like what you have acquired here, really like what you’re saying and the way in which you say it. You make it enjoyable and you still care for to keep

wahid

wahid on March 17, 2019, 12:33 p.m. Reply

It’s late finding this act. At least, it’s a thing to be familiar with that there are such events exist. I agree with your Blog and I will be back to inspect it more in the future so please keep up your act. guaranteed payday loans

wahid

wahid on April 7, 2019, 4:21 p.m. Reply

Always trying to tell other people how important it is to do proper tree removal nassau county long island. As other methods can prove dangerous if the tree falls on its own.

wahid

wahid on May 3, 2019, 12:05 a.m. Reply

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing. die cut stickers

garrybee

garrybee on June 5, 2019, 4:10 p.m. Reply

Thanks for the post. I needed this https://issuu.com/acemail/docs/howtousetiktokfans_likesgen

wahid

wahid on August 9, 2019, 10:22 a.m. Reply

Very interesting information, worth recommending. However, I recommend this: Free Website Traffic

wahid

wahid on August 18, 2019, 10:44 a.m. Reply

I can give you the address Here you will learn how to do it correctly. Read and write something good. 바카라사이트

wahid

wahid on August 26, 2019, 10:57 a.m. Reply

You should mainly superior together with well-performing material, which means that see it: Ethereum Price

wahid

wahid on September 10, 2019, 10:15 a.m. Reply

You might comment on the order system of the blog. You should chat it’s splendid. Your blog audit would swell up your visitors. I was very pleased to find this site.I wanted to thank you for this great read!! sprawdź jak zdobyć lajki

wahid

wahid on September 12, 2019, 6:01 p.m. Reply

I should assert barely that its astounding! The blog is informational also always fabricate amazing entitys. äÞá ÚÝÔ

Diet Plan PDF

Diet Plan PDF on September 14, 2019, 11:03 p.m. Reply

I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work. Diet Plan PDF Keto Side Dishes

wahid

wahid on September 16, 2019, 11:02 a.m. Reply

I prefer merely excellent resources - you will see these people in: sprawdź opinie topinsta.pl

rockson

rockson on September 19, 2019, 4:50 a.m. Reply

Thanks for sharing the detailed explanation about sql. Would you like to know more about movie streaming sites? divxcrawler tv is one of the best site to watch movies.

wahid

wahid on September 19, 2019, 11:40 a.m. Reply

There is so much in this article that I would never have thought of on my own. Your content gives readers things to think about in an interesting way. Aussie brokers forex

wahid

wahid on September 23, 2019, 6:39 a.m. Reply

I am always searching online for articles that can help me. There is obviously a lot to know about this. I think you made some good points in Features also. Keep working, great job ! 생방송바카라게임

wahid

wahid on September 23, 2019, 11:51 a.m. Reply

I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post. House cleaning in Cambridge

pioneerseo

pioneerseo on September 25, 2019, 7:50 a.m. Reply

I read this article. I think You put a great deal of exertion to make this article. I like your work. [url=https://www.cimalight.net/category.php?cat=arabic-series]visit site[/url]

wahid

wahid on September 26, 2019, 10:41 a.m. Reply

Hi there, I discovered your blog per Google bit searching for such kinda educational advise moreover your inform beholds very remarkable for me. iceblingers.com

hardeep01

hardeep01 on September 26, 2019, 11:09 a.m. Reply

Office Remote transforms your telephone into a shrewd remote that cooperates with Office on your PC. The application gives you a chance to control Word, Excel, and PowerPoint from over the room, so you can stroll around openly during introductions. With an Office 365 membership office setup you get the most recent Office applications—both the work area and the online forms—and updates when they occur.

wahid

wahid on September 28, 2019, 10:23 a.m. Reply

You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I’m looking forward for your next post, I’ll try to get the hang of it! promowanie profili na instagramie

Edward fox

Edward fox on October 5, 2019, 8:16 a.m. Reply

I have to convey my respect for your kindness for all those that require guidance on this one field. Your special commitment to passing the solution up and down has been incredibly functional and has continually empowered most people just like me to achieve their dreams. Your amazing insightful information entails much to me and especially to my peers. Thanks a ton; from all of us. cod mobile hack

wahid

wahid on October 6, 2019, 12:27 p.m. Reply

Below you will understand what is important, the idea provides one of the links with an exciting site: 우리카지노사이트

wahid

wahid on October 12, 2019, 7:09 a.m. Reply

Make the most of mainly premium substances - you will find him or her for: visit website

Edward fox

Edward fox on October 13, 2019, 11:56 a.m. Reply

Glad to be one of the visitors on this awe inspiring web site : D. bubble shooter unblocked

wahid

wahid on October 14, 2019, 7:47 a.m. Reply

You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog. know more

Leave a Comment