MySQL data type: Text,,, Erroring: Data Too Long
The type TEXT is limited to 2^16 bytes, or 65536 bytes. Try using the type LONGTEXT instead. It can hold values up to 2^32 bytes in length.
coldfusion
How do I concatenate two strings and store them into the same struct key
& is the string concat operator, AND and && are boolean operators. <cfset myStruct.concatendatedSring = myStruct.string1 & myStruct.string2>
ColdFusion SOAP response with attachments
It has been a while since I worked with ColdFusion. The last I remember, it did not provide a harness to send a SOAP attachment. I solved this issue by writing a custom CFX tag with Java that did it for me. The entire SOAP call will need to go through the tag. The Java … Read more
Lose EF Code First Migration when working on different TFS branches?
An EF migration step contains a metadata file, that has a signature of the model that is the result of the migration step. The problem when merging is that the signature of the migration done in branch B doesn’t include the stuff done in the migration in branch A. As long as the migrations are … Read more
How can I write a newline in a string in ColdFusion?
Your way is correct. There is no support for \n or \r in CF. From the Live Docs Chr(10) returns a linefeed character Chr(13) returns a carriage return character The two-character string Chr(13) & Chr(10) returns a Windows newline
Join Two Arrays in ColdFusion
Not really, but guess what, just use Java! 🙂 <cfset foo = [1,2,3]> <cfset bar = [4,5,6]> <cfset foo.addAll( bar )> reference: Java’s Collection Interface API. source: http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/merging-two-arrays-267
Can I get a query row by index in ColdFusion?
You can’t get a row in CF <= 10. You have to get a specific column. <cfset x = QueryName.columnName[5]> It’s been 8 years since I posted this answer, however. Apparently CF11 finally implemented that feature. See this answer.
JavaScript Error when using Flash Forms in ColdFusion 9
I occurred with the same error while i was developing one application . You might be declaring some other script before this which will bring conflict . Comment all others and try again . Mine was resolved by doing this hit an trial method . I commented all scripts run my application , it worked … Read more
Once grammar is complete, what’s the best way to walk an ANTLR v4 tree?
I wouldn’t walk this manually if I were you. After generating a lexer and parser, ANTLR would also have generated a file called CfscriptBaseListener that has empty methods for all of your parser rules. You can let ANTLR walk your tree and attach a custom tree-listener in which you override only those methods/rules you’re interested … Read more
Is there a way to ‘listen’ for a database event and update a page in real time?
This isn’t too difficult. The simple way would be to add via .append: $( ‘#table > tbody:last’).append(‘<tr id=”id”><td>stuff</td></tr>’); Adding elements real-time isn’t entirely possible. You’d have to run an Ajax query that updates in a loop to “catch” the change. So, not totally real-time, but very, very close to it. Your user really wouldn’t notice … Read more