MySql Database

Writeable forms would be incredibly useful. I tried to use the MySQL extension to list glossary pages (glossary/word) from the wikidb catalog but of course the html tags were also displayed in the table. I had hoped the function would either remove html tags in the data or use them intelligently but this was naive perhaps.

Since my company uses a custom made issue tracker, I was hoping I could use this extension to retrieve the issue list directly from mysql. Of course this works just fine, except I want something more. =)

I wanted to transform the ID-field to a link that would point to our issue tracker, I did a really fancy MySQL query for it and when I tested it in mysql client, it worked perfectly. However when I tried it in this extension, the link part only returned the text "System.Byte[]". It did fetch all the rows correctly and render the table, but the ID part was not working for some reason. Any idea what might cause that?

The query I was using was similar to this: (yes, I did escape the double quotes when I put it inside mysql.Table())
SELECT CONCAT_WS('', '<a href="http://url.to.issue.tracker/issue/', issue_id, '">', issue_id, '</a>') AS `ID`, issue_title AS `Title` FROM issues WHERE project = 1337

Can anyone expand on the setup instructions for this extension? Such as, how does one properly create a read only user for MySQL? And does this user have to be created in the OS as well? I'm pretty sure thats the source of my problem, of which I receive this error: "Unable to connect to any of the specified MySQL hosts."

Is there a way to display BLOBs?

Not yet. Support for BLOBs is coming to DekiScript in the future though. No date yet.

Sorry if these are stupid questions:
"db-catalog Config Key" = What is this supposed to be? MySql has its server name, which contains one or more databases within it, each of which contains one or more tables. So what's a catalog?
"Preference = namespace" = are you trying to associate a particular database within a MySql server here?
An example or two of connection parameters would also be helpful.

The catalog is also the database name. I clarified the description for it.

The definition of the return data type is different between specification above and actual-manifest for the MySql extension. Which is correct? I use Deki v8.08.1a on VM.

function | spec | manifest
-------------------------------------
Value | xml | str
List | xml | list

Can I preset a format for the table result of the mysql select???

The table is generated automatically based on the columns that are returned. If you need more control over the rendering of the result set, you can use mysql.recordlist to return an array of results and then render it dynamically using DekiScript.

Does make nasty sql queries, but BLOB data can be converted to string format instead of being displayed as "System.Byte[]" using:
CAST(columnName AS CHAR(10) CHARACTER SET utf8)

Does any database come with MindTouch install by default? If not, how do I connect MindTouch to a MySql database?

Hi, I'm pretty new of dekiwiki scripting and what I'm trying to do is getting a formatted table of data coming out from mysql.
My query return more than one row, actually hundreds, but finally the List or Map are eather populated by one record.
Here below a snip of my code. Any help is appreciated.
var sqlQuery = "select
date(radpostauth.authdate) as Anno,
count(username) as Autenticazioni
FROM radpostauth
where reply='Access-Accept'
group by Anno
order by Anno desc";

var recordList = [ radsql.RecordList(sqlQuery) ];
var recordListLenght = #recordList;
<div>"RecordListLenght :"..recordListLenght</div>

var recordMap = { query: radsql.Record(sqlQuery) };
var recordMapLenght = #recordMap;
<div>"RecordMapLenght :"..recordMapLenght</div>

both RecordMapLenght and RecordListLenght are equal to 1!
I'm going crazy about that.
Please heeelp!! :-)

@racepa radsql.RecordList() already returns a list. don't embed it into another list. radsql.Record() will always just return a single record or nil if none is found

Dear Mind Touch developer i want to know that how can i write the insert query in mind touch what i do is that i go to the Edit page option and then i write the following code that will insert the record into the mysql database table named "user_info" it has 10 columns and i have entered all the 9 columns empty and i want the value of the first column to be the value that i have entered in the textbox this is only for testing how the insert query will work (??) sign in the DB query here indicates that what should i do to get the value of the textbox here in the Dekiscript insert query statement. Kindly help me in this issue.

<p><script type="text/javascript">/*<![CDATA[*/
var city;
function insert()
{
city = document.getElementById('txtCity').value;
alert(city);
document.getElementById('record').style.visibility = 'visible';
}
/*]]>*/</script></p>
<p><input id="txtCity" name="txtCity" type="text" /></p>
<div id="record" style="visibility:hidden">
{{mysql.table(&quot;INSERT into user_info values (??,'','','','','','','','','')&quot;)}}


</div>
<p><input ctor="when($this.click) insert()" type="submit" value="Submit" /></p>