How to set mysql variables in ColdFusion?

[Dawg06]

Hey there,

I am trying to figure out how to set a global variable in CF. What I need to do is change the max length of a variable in mysql. How do I do this in CF and what file do I put it in?

Here is what I need to set as by default it is too low for what I need it for.

SET [SESSION | GLOBAL] group_concat_max_len = 1000000;

Thanks for any help I can get with this

 

[r937]

haven't needed it myself but i think you can just run the SET statement in a CFQUERY tag like any other statement

r937.com | rudy.ca

 

[Dawg06]

I have tried setting it in the cfquery and had no sucess. Any other ideas?

Thanks

 

[imstillatwork]

<cfset maxLen = 1000000>

<cfquery>
SET [SESSION | GLOBAL] group_concat_max_len = #maxLen#;
</cfquery>

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[Dawg06]

Perfect thanks very much for your help, that worked great!
Cheers