MySQL Field Type Plugin

thanks for this great plugin.. I've been trying this plugin a while and would love to explore more from this.

I am using the latest version of this plugin. I understand it can retrieve one coloum data( e.g. id ) from mulitple rows like below.
select id from #__poll_data
return => 1|*|2|*|3|*|4|*|5|*|6|*|7|*|8|*|9|*|10|*|11|*|12

However, can I retrive muiltple column data from multiple row ?
e.g. select id, text from #_poll_data

Is there any limitation from maximum number of row to display ?

Thank you in advance !

Hi.

Im trying to get 1 result out of this:

SELECT * FROM rp_1.darkrp_wallets where steam = '[cb_steam}'

and the result i want as output is:

rp_1.darkrp_wallets.amount

How do i build this query?

Best regards
Claus

a very quick reply - try
SELECT rp_1.darkrp_wallets.amount FROM rp_1.darkrp_wallets where steam = '[cb_steam}'

Very odd. I have two copies of the same site. I have used this plug in for some months but now, having re-installed the plugin on my main site, I have duplicated the code from test site. While the test site works fine the main site will not. I still get the field warnings discussed earlier on both sites. Any ideas why this might be? How do I go about debugging this plug in?

Puzzled - because on the test site it works fine and is a veryuseful plugin.

Regards

Nick

PS on April 26th I have copied the code from the working test site to the non-working production site and Eureka - it is working again. No idea why - I haven't looked as yet but just a warning before upgrade. Keep a copy of the previous version.

NickOg wrote: a very quick reply - try
SELECT rp_1.darkrp_wallets.amount FROM rp_1.darkrp_wallets where steam = '[cb_steam}'

In this example there are a mixture of square and curly brackets in the placeholder, they should both be square.

I just wanted to say thankyou, softforge, for this plugin. It really is a lifesaver.

Cheers!