MySQL 4 driver and characterEncoding=ISO-8859

Our site allows international / non-ASCII characters (accents, curly quotes, etc) in database data. We are using MySQL 4.1. In CF 6.1, it all works great with the following: cfset setEncoding(form,ISO-8859-1) cfset setEncoding(url,ISO-8859-1) cfcontent type = text/html; charset ISO-8859-1

RE: query help

If ROUND isn't there, look for another rounding function like CEILING, FLOOR etc. Adrian -Original Message- From: Dave l Sent: 09 December 2007 04:18 To: CF-Talk Subject: Re: query help if i change the select statement to: SELECT center_id, address1, city, state, postalcode,

Re: query help

http://www.ibm.com/developerworks/opensource/library/os-ad-trifecta6/ looks like you can use cast to round values On Dec 9, 2007 8:25 AM, Adrian Lynch [EMAIL PROTECTED] wrote: If ROUND isn't there, look for another rounding function like CEILING, FLOOR etc. Adrian -Original

Re: query help

Looks like CEIL() or CEILING() is the function you're looking for: http://db.apache.org/derby/docs/10.2/ref/refderby.pdf HTH, Jon On Dec 8, 2007, at 11:18 PM, Dave l wrote: if i change the select statement to: SELECTcenter_id, address1, city, state, postalcode, state,

No Longer Need to Lock Session Variables?

Hi, all. Now, remember, I'm still learning to write CF8 code straight from CF4.5 code, so. Is my understanding correct that I no longer need to place cflocks around any setting or reading of session variables? Thanks, Rick

Drag Image

Hi All, I have a project I am working on and was hoping someone could point me in the right direction. A user will upload a photo, re-size on the fly (I can handle this part). Here's the kicker, the user will then need to be able to drag the uploaded picture over another picture. So they

Re: No Longer Need to Lock Session Variables?

On 12/9/07, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all. Now, remember, I'm still learning to write CF8 code straight from CF4.5 code, so. Is my understanding correct that I no longer need to place cflocks around any setting or reading of session variables? Thanks, Rick The

Re: No Longer Need to Lock Session Variables?

Not really. You still need to lock around any potential race conditions. Perosnally I tend not to lock reads and always lock writes, unless there is a race condition possibility on the read, in which case I lock that too.. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com

form problem

Hi, i have something very strange happening with a form. i have set a form with an action page which has several hidden form fields. when a user clicks on save i am populating the hidden form fields with data and then submitting them to the action page. i have this set up on lots of

RE: No Longer Need to Lock Session Variables?

-Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, December 09, 2007 1:18 PM To: CF-Talk Subject: No Longer Need to Lock Session Variables? Hi, all. Now, remember, I'm still learning to write CF8 code straight from CF4.5 code, so. Is my

Re: form problem

i have never seen anything like this before Same with us, especially if you don't show any code ;-) Are you sure the form is submitted with METHOD=post -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please

Re: form problem

lol :) sorry, ok, ill try to compress the code down and show it back in a sec! thanks ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now

Re: form problem

when i try to break it down it works fine - so there must be a problem with my js somewhere, thanks anyway, im going to have to go through it really slowly. i bet its some tiny little error, its always the little things that take the longest! thanks

Re: form problem

ok after nearly tearing my hair out all day i still dont know what was wrong but managed to fix it. if i was to set the value of the hidden form fields as follows: $('columnID').value = columnIDsArray; then it was working sometimes and not others, yet if i set it as follows:

RE: form problem

-Original Message- From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: 09 Dec 07 15:23 Subject: Re: form problem ok after nearly tearing my hair out all day i still dont know what was wrong but managed to fix it. if i was to set the value of the hidden

Re: form problem

Richard, I appears that you're using JQuery so some of your questions might be more appropriate on the forums over there, but a couple of things: You need to pass the pound symbol in with your field so that JQuery knows to specifically to look for an HTML element with that id attribute:

Re: form problem

Oh and just to clarify (before someone else hits me on it), you don't need the JQuery lookup in my example of using an existing JS object. You can, however use the object directly to perform JQuery functions on the object: var columnID = document.getElmentById(columnId);

Re: form problem

its always the little things that take the longest! also known as Pareto's law ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks.

Re: form problem

hi thanks for your comments, at least i have some explanation to it now. your right also about populating the form from js. we are actually using a js grid with now way to get the data out and back to the server unless after the user has entered some information and click save we populate

Re: form problem

... also known as Pareto's law ;-) perfect way to put it!!! ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now

Re: query help

I'll take a look at those thanks guys Looks like CEIL() or CEILING() is the function you're looking for: http://db.apache.org/derby/docs/10.2/ref/refderby.pdf HTH, Jon On Dec 8, 2007, at 11:18 PM, Dave l wrote: if i change the select statement to: SELECT center_id,

SequeLink driver.

Hello all. I have a slight database connection problem. First, if someone has a work-around for MX7 and 16+ character passwords for db connections, that would be best. A client who uses this database for multiple applications, one of which requires 18-character passwords. I spent a day

RE: SequeLink driver.

First, if someone has a work-around for MX7 and 16+ character passwords for db connections, that would be best. A client who uses this database for multiple applications, one of which requires 18-character passwords. I spent a day fighting with it and finally gave up, opting to use

RE: No Longer Need to Lock Session Variables?

Casey, Matt, Jim... Thanks for the info! Rick -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, December 09, 2007 2:14 PM To: CF-Talk Subject: RE: No Longer Need to Lock Session Variables? In short you no longer need to do this to ensure server

Re: No Longer Need to Lock Session Variables?

I didn't see earlier posts to this thread, but it is worth noting that if you are using Application.cfc and calling onApplicationStart() or onSessionStart() explicitly, you will still need to lock the appropriate scope(s). Nic -- Nicholas M. Tunney Blog: http://www.nictunney.com Adobe

Re: Drag Image

i would start by looking at jQuery (www.jquery.com) or another js library/framework that supports dragging/dropping. i personally love jQuery for its simplicity and power. ben nadel @ kinkysolutions.com has several posts on his blog re jQuery and specifically about creating a dragdrop interface

Re: query help

change one thing it errors on another lol now it errors on the , I'll take a look at those thanks guys ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex

PDF creation in CF8 - not working...please help

I'm trying to create a PDF from a page and it's not working. The way I've read is that to do this, you simply wrap whatever content you have within cfdocument tags, with the type set to PDF. So that's what I've done, and it's not working correctly. Here's the actual page:

Re: PDF creation in CF8 - not working...please help

Oh...one more thing. The code on the PDF page is identical (except for the cfdocument tag), which is set up like so: cfdocument format=pdf all code inside here ... /cfdocument ~| Enterprise web applications, build robust,

Re: PDF creation in CF8 - not working...please help

Oh...one more thing. The code on the PDF page is identical (except for the cfdocument tag), which is set up like so: cfdocument format=pdf /cfdocument ~| Enterprise web applications, build robust, secure scalable apps today

RE: No Longer Need to Lock Session Variables?

Thanks, Nic... just coming from CF 4.5, I haven't even written an Application.cfc, yet! And haven't used onApplicationStart() or on SessionStart()! I'm trying to catch up, however! :o) Rick -Original Message- From: Nicholas M Tunney [mailto:[EMAIL PROTECTED] Sent: Sunday, December