Re: Sorting 2d arrays

Sorry, forgot to mention that the query above just returns the ASCII chars. Then I use a different query to classify the first char: DECLARE @ErrorNum INT SET @ErrorNum = 1 DECLARE @ TABLE ( [Id]INT, [Name] VARCHAR(255), [Number]VARCHAR(255), [_] VARCHAR(255),

Re: Sorting 2d arrays

Okay I figured it was going to be a query based solution. Turns out there is a table in SQL Server that lists all chars in ASCII so I can sort based on that table's numeric values and then return two columns to output. Pretty RAD. here's the t-sql to generate it. ---

RE: Coldfusion Encrypt and Insert quotation mark issue

There is an undocumented cfusion_encrypt() that will only return alpha-numeric values. -Original Message- From: Joel Black [mailto:j...@blackbeardesign.com] Sent: Thursday, October 15, 2009 3:54 PM To: cf-talk Subject: Coldfusion Encrypt and Insert quotation mark issue I am using the e

RE: Coldfusion Encrypt and Insert quotation mark issue

Sanitize your data? I don't know if I completely understand WHERE in your code the error occured (cfquery or form field etc). For every parameter to a SQL statement, make sure they are passed through the CFQueryParam tag For every user-controlled piece of data being displayed in HTML, make sure

Coldfusion Encrypt and Insert quotation mark issue

I am using the encrypt function to encrypt passwords going into and out of my database. I ran into an issue on a password that was one of the characters was encrypted to a ", which messed up my insert. "#encrypt(form.password,0)#" ended up as "19$h#1".y " The extra " ended my string to

Re: Form validation question

The JQuery Validate plugin has a method whereby, aside from any standard checks you put in place (not empty, alphanumeric only, etc), it will make an Ajax request and assign a field it's validation status based upon the Ajax status return. http://bassistance.de/jquery-plugins/jquery-plugin-val

Form validation question

I'm working on a site where people register and choose their own username. In the registration form I'd like to, onBlur from the username field, immediately check to see if that username is already in use and if so, trigger an alert that returns them to the field. What's the best way to do this?

RE: CF8, 64 bit, and Microsoft Access

There IS an Access driver that is 64 bit. It is httx. You can also jury rig a proxy ws to a 32bit server (which is how I handled it for a data export). That approach assumes you have access to both types of server and on a shared host is probably out of the question. The 64bit driver may be out of

Re: CF8, 64 bit, and Microsoft Access

On Thu, Oct 15, 2009 at 1:01 PM, John Pullam wrote: > > Is it true? And if yes, is there anything I can do? Are there technical > alternatives to allow me to use Access from a 64 bit CF8 system? Move your site to a server that doesn't run 64 bit CF Or maybe hire a .NET programmer to write on o

RE: CF8, 64 bit, and Microsoft Access

If it's shared hosting, then you're probably out of luck because you are at their mercy. If you have a virtual server, however, then maybe you can try installing the access 32 bit odbc driver on your 64 bit system, and then use it through the ODBC Socket driver in ColdFusion.it's worth a try.

RE: Separate CFC's

Perhaps on the first call to the page that compiles your god CFC. Realistically thoguh, I think your answer is no, but I would think it might make your development a little easier. :) ~Brad Original Message Subject: Separate CFC's From: Joshua Rowe Date: Thu, October 15, 20

CF8, 64 bit, and Microsoft Access

I've just been told by my ISP that CF8 doesn't support Microsoft Access on a 64 bit server, and seeing as they are implementing it on a 64 bit server, I'm in trouble. Don't get me wrong--I understand that Access isn't strategic and I will be moving away from it, but I have an app that gets an

RE: Sorting 2d arrays

Tony, Probably a ton of ways to do this. Would this get you what you want?: (note: the below would be for oracle, you need + instead of || for Sql server - not sure about what db you're using) select sql_id, alphanumeric_id || description as auto_suggest_descr

Separate CFC's

Hello, I have somewhere around fifty to sixty functions in one CFC which adds up to about 2500 lines of code. If I categorize these functions and separate them into different CFC's, will this speed up page loading time at all? ~

Re: Files stay locked after processing them

Phillip B wrote: >> Now I just have to figure out how to apply it in a multi-server >> install. There isn't a metadata-extractor-2.3.1.jar file to be found. >> > > Dur... > I found it. Love days like this. :-\ If you truely have multiple instances then there is probably multiple versions

Sorting 2d arrays

I have an app currently that needs a list sorted alphabetically with alpha-numeric chars. I am using a query and then narrowing the results into an array and then creating two lists for an autosuggest. Imagine searching by an alphanumeric ID (not SQL ID) and also by the description: 1234ii --

Re: Files stay locked after processing them

> Now I just have to figure out how to apply it in a multi-server > install. There isn't a metadata-extractor-2.3.1.jar file to be found. Dur... I found it. Love days like this. :-\ ~| Want to reach the ColdFusion community w

Re: Files stay locked after processing them

>I ran into a similar issue on CF8 and it ended up being a bug. There's a >hotfix out there for it: >http://kb2.adobe.com/cps/403/kb403411.html > >-Jake Looks like my problem. Thanks. Now I just have to figure out how to apply it in a multi-server in

Re: Files stay locked after processing them

I ran into a similar issue on CF8 and it ended up being a bug. There's a hotfix out there for it: http://kb2.adobe.com/cps/403/kb403411.html -Jake On Thu, Oct 15, 2009 at 10:10 AM, Phillip B wrote: > > I have an issue where image files will stay loc

Files stay locked after processing them

I have an issue where image files will stay locked after I'm done with them. I get an image, make multiple sizes and then need to move the file to a new place. Problem is the files are being moved rather than copied because they are still locked. I'm using a directory-watcher event gateway to

Re: cfprocparam - null setting

Yep, for anyone reading along: "Returns Yes, for a nonzero value; No for zero, false, and no Boolean values, and an empty string ("")." http://www.cfquickdocs.com/cf8/?getDoc=YesNoFormat mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/15 DURETTE, STEVE

RE: cfprocparam - null setting

Cool, I didn't know that YesNoFormat("") resolved to no. -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Thursday, October 15, 2009 9:38 AM To: cf-talk Subject: Re: cfprocparam - null setting I'd use YesNoFormat() as I think it's more readable than NOT len()

Re: cfprocparam - null setting

I'd use YesNoFormat() as I think it's more readable than NOT len(), but the result is the same. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/10/15 DURETTE, STEVEN J (ATTASIAIT) : > > You can only pass in things that resolve to true/false, zero/one, > yes/n

RE: cfprocparam - null setting

You can only pass in things that resolve to true/false, zero/one, yes/no, etc. Using not len resolves to 0 (false) if there is a length and 1 (true) if there is no length. -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Thursday, October 15, 2009 9:05 A

RE: cfprocparam - null setting

Can you pass anything other than true/false to the null parameter in cfprocparam? I know you can in cfqueryparam, but I was under the impression than in cfprocparam it's strictly true/false -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Thursday, Oc

RE: cfprocparam - null setting

Forgot to add that you can do the cfif outside of the cfstoredproc and then just use the cfprocparam inside. Using this method, if Variables.myPassIn is not zero or "" then it will put FALSE in the NULL and pass in the value. If it is zero then it converts to "" and it will put TRUE in the NULL

RE: cfprocparam - null setting

Actually, I think you can solve this problem easily. If the only two bad options are zero and "" then try this... Of course replace Variables.myPassIn with whatever your variable is. Steve -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Thurs

RE: cfprocparam - null setting

Right, the null parameter in cfprocparam is a true/false. What I don't want inside a cfstoredproc is -Original Message- From: Kris Jones [mailto:kris.jon...@verizon.net] Sent: Thursday, October 15, 2009 8:52 AM To: cf-talk Subject: Re: cfprocparam - null setting T

Re: cfprocparam - null setting

The former: It ignores anything passed to it, and sets the value to null. Note, however, that whatever you are passing to the procparam must still validate; e.g., a variable in the value attribute must exist: Will throw a CF error. Cheers, Kris > I have a question about cfprocparam. If I use

cfprocparam - null setting

Hey all, I have a question about cfprocparam. If I use the "nulll" option, does it ignore anything passed to it and set the value to null or Does it set a null value when nothing is passed to it. I have a stored procedure that chokes on an integer value when either zero or an empty string

Re: GetHTTPRequestdata().content is changing my data any ideas?

> if you read in a jpg using cffile "read" and then save it > using cffile, you will get the same munged image If a "read" returns the same results, that does sound like the binary data is being treated as text. In a quick test with cfhttp, I had no problems saving the getHTTPRequestData().con

Re: compare arrays for same

> http://cflib.org/udf/listVenn Hah! I knew cflib.org must "have a function for that ..." ;-) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Arch

Re: compare arrays for same

neat function! thanks to all posts >http://cflib.org/udf/listVenn > >On Thu, Oct 15, 2009 at 6:05 AM, Richard White wrote: > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House

Re: get SWF movie length

good find! i do not think i ever encountered macromedia.swf.TagDecoder before... will try it out as soon as i get a chance. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 15/10/2009 20:03, Leigh wrote: > I have not used it, but you might also try the code in this entry (see bottom > c

Re: get SWF movie length

> convert it to FLV and use ffmpeg and I have not used it, but you might also try the code in this entry (see bottom comments) http://coldfused.blogspot.com/2008/02/reading-flash-swf-metadata-from.html -Leigh ~| Wa

Re: compare arrays for same

> is there a function to compare 2 arrays or lists and return > the values that exist in both? Not that I know of, but you could create your own. Though I have not looked, but I would be very surprised if cflib.org did not already have a function for this This could certainly be improved ...

Re: get SWF movie length

convert it to FLV and use ffmpeg and to get running time of the clip. (you can use ffmpeg to convert swf to flv) you can't get run-time of SWF file with CF or js. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 15/10/2009 04:33, Joshua Rowe wrote: > Hello, > > Is there a way to detect

Re: compare arrays for same

http://cflib.org/udf/listVenn On Thu, Oct 15, 2009 at 6:05 AM, Richard White wrote: > > hi > > is there a function to compare 2 arrays or lists and return the values that > exist in both? > > i have found plenty they return then difference but not for this case > > thanks > > > ~~

Re: CFPDF Thumbnail quality

>I'm converting PDFs to image >format, and would expect some kind of control over the output quality >- I'm writing a JPG after all. Yep, and you *should* have the option to set a compression percentage for that, so I would raise that bit as a bug. I'm guessing the resolution setting is pro

compare arrays for same

hi is there a function to compare 2 arrays or lists and return the values that exist in both? i have found plenty they return then difference but not for this case thanks ~| Want to reach the ColdFusion community with someth