MySQL 4 driver and characterEncoding=ISO-8859

2007-12-09 Thread Terry Ford
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  AND, using the MySQL 3 
driver, useUnicode=truecharacterEncoding=ISO-8859-1 in the connection string.  
It works.

Now that we've upgraded to CF 8 / the MySQL 4 driver, a lot of our non-ASCII 
characters are getting displayed as boxes or other weird characters.

I suspect there is a very simply fix that I'm overlooking here.  It appears the 
useUnicode=truecharacterEncoding=ISO-8859-1 string used for the MySQL 3 
driver is being ignored by the MySQL 4 driver.

Does anyone have any suggestion on how to get this international data to 
display properly in CF 8 using the MySQL 4 driver? 

Thanks for your thoughts.


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294411
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: query help

2007-12-09 Thread Adrian Lynch
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, state,
ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) +

it changes the error to:
 'ROUND' is not recognized as a function or procedure.


so i might be sol on this tut


~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294412
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: query help

2007-12-09 Thread Greg Morphis
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 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, state,
ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) +

 it changes the error to:
  'ROUND' is not recognized as a function or procedure.


 so i might be sol on this tut


 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294413
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: query help

2007-12-09 Thread Jon Clausen
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,
   ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) +

 it changes the error to:
 'ROUND' is not recognized as a function or procedure.


 so i might be sol on this tut


 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294414
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


No Longer Need to Lock Session Variables?

2007-12-09 Thread Rick Faircloth
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



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294415
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Drag Image

2007-12-09 Thread Greg Edmonds
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 will need to be
able to click and drag the uploaded image and place it in a position over a
pre-defined image.  I will need to send the exact location (where the user
dragged it) of the uploaded picture to the database.  This is a complete
Cold Fusion environment, so any solutions would need to integrate with Cold
Fusion.  I hope I have explained myself well enough, if not let me know and
I'll go into more detail.  Any suggestions would be greatly appreciated.

 

Thanks!

Greg

 



Greg Edmonds

Sitecon

http://www.sitecon.com/

 

 






~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294416
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: No Longer Need to Lock Session Variables?

2007-12-09 Thread Casey Dougall
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 best example and what I think about when setting a cflock is a  web hit
counter. If two people visit a page at exactly the same millisecond, a
cflock would be needed to me sure the data is correct. There are a couple of
additional times when I think back to the web hit counter logic and see if
it's a problem with an update or insert script but normally, I try not to
rely on the ID of the last inserted record for anything so 9.9 times out of
10 cflock is not needed.

Casey


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: No Longer Need to Lock Session Variables?

2007-12-09 Thread Matt Robertson
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

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294418
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


form problem

2007-12-09 Thread Richard White
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 interfaces and works and this was working on this 
page but has now decided to stop working.

if i do a js alert on the hidden form fields it shows the correct data in them. 
then the next line of code says: document.formname.submit(); but then when i 
dump the form on the actionpage it shows that all the hidden form fields are 
empty strings

i have never seen anything like this before and use this method alot. has 
anyone come across anything like this?

thanks 

~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294419
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: No Longer Need to Lock Session Variables?

2007-12-09 Thread Jim Davis
 -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 understanding correct that I no longer need to place
 cflocks around any setting or reading of session variables?

In short you no longer need to do this to ensure server reliability (the
structures which hold this information are now thread-safe) - no more
crashes because of locking.  (5 year-old Yay!)

(Just kidding - we went straight from 4.5 to 7 so I know exactly where
you're coming from.)

However you still may need to lock to protect your data for
application/design reasons (race-conditions for example).  It's rare that
you'll need to lock whole scopes however and for the most part named locks
should provide all the utility you need without dragging performance.

Jim Davis


~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294420
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: form problem

2007-12-09 Thread Claude Schneegans
 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 send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294421
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: form problem

2007-12-09 Thread Richard White
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
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294422
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: form problem

2007-12-09 Thread Richard White
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



~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: form problem

2007-12-09 Thread Richard White
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:

document.manageLookupForm.columnID.value = columnIDArray;

then it works all the time

does anyone have any idea why this would happen.

i have the first way set up on all my interfaces and works fine but on this 
interface like i said it works fine with the second way but not the first?

thanks




~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294424
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: form problem

2007-12-09 Thread Dave Watts
-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 form 
 fields as follows:

 $('columnID').value = columnIDsArray;
 
 then it was working sometimes and not others,
 yet if i set it as follows:

 document.manageLookupForm.columnID.value 
 = columnIDArray;

 then it works all the time

 does anyone have any idea why this would 
 happen.

columnIDsArray != columnIDArray

If that's not the problem, you'll have to show your code.

Dave Watts, CTO, Fig Leaf Software 


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294425
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: form problem

2007-12-09 Thread Jon Clausen
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:

$('#columnID').value=columnIDsArray;

If it's an existing javascript object variable, than there's no need  
to quote it:

var columnID = document.getElmentById(columnId);
$(columnId).value=columnIDsArray;

I'm not exactly sure what the execution plan and fallback for JQuery  
is when the pound sign is missing.  Rey Bango would probably know, but  
it's a good bet that this may be the problem.  By using  
document.manageLookupForm.columnID.value you are bypassing the  
JQuery lookup of the object and accessing the DOM tree directly.

In any case, I'm not sure that populating your forms with javascript  
on each step is the most effective or efficient way.   Javascript and  
a JQuery are wonderful for manipulating stuff after the document has  
loaded, but server side code can make quick and accurate work of it  
like in this (very basic) example of using the passed form structure  
to quickly populate required fields:

cfset reqFields = name,author,title,text
cfloop list=#reqFields# index=i
input type=hidden name=#i# id=#i#cfif structKeyExists(form,i)  
value=#form[i]#cfelse value=/cfif/
/cfloop

You can make short work of handling the passed variables and don't  
have to rely on the browser to make sure the values are set correctly.

Just my 2 cents.


-Jon


On Dec 9, 2007, at 3:23 PM, Richard White wrote:

 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:

 document.manageLookupForm.columnID.value = columnIDArray;

 then it works all the time

 does anyone have any idea why this would happen.

 i have the first way set up on all my interfaces and works fine but  
 on this interface like i said it works fine with the second way but  
 not the first?

 thanks


~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294426
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: form problem

2007-12-09 Thread Jon Clausen
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);
columnID.value=columnIDsArray;

:)
Jon


On Dec 9, 2007, at 4:04 PM, Jon Clausen wrote:

 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:

 $('#columnID').value=columnIDsArray;

 If it's an existing javascript object variable, than there's no need
 to quote it:

 var columnID = document.getElmentById(columnId);
 $(columnId).value=columnIDsArray;

 I'm not exactly sure what the execution plan and fallback for JQuery
 is when the pound sign is missing.  Rey Bango would probably know, but
 it's a good bet that this may be the problem.  By using
 document.manageLookupForm.columnID.value you are bypassing the
 JQuery lookup of the object and accessing the DOM tree directly.

 In any case, I'm not sure that populating your forms with javascript
 on each step is the most effective or efficient way.   Javascript and
 a JQuery are wonderful for manipulating stuff after the document has
 loaded, but server side code can make quick and accurate work of it
 like in this (very basic) example of using the passed form structure
 to quickly populate required fields:

 cfset reqFields = name,author,title,text
 cfloop list=#reqFields# index=i
 input type=hidden name=#i# id=#i#cfif structKeyExists(form,i)
 value=#form[i]#cfelse value=/cfif/
 /cfloop

 You can make short work of handling the passed variables and don't
 have to rely on the browser to make sure the values are set correctly.

 Just my 2 cents.


 -Jon


 On Dec 9, 2007, at 3:23 PM, Richard White wrote:

 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:

 document.manageLookupForm.columnID.value = columnIDArray;

 then it works all the time

 does anyone have any idea why this would happen.

 i have the first way set up on all my interfaces and works fine but
 on this interface like i said it works fine with the second way but
 not the first?

 thanks


 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294427
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: form problem

2007-12-09 Thread Claude Schneegans
 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.


~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294428
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: form problem

2007-12-09 Thread Richard White
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 hidden form fields 
with the data they entered then post it to the actionpage which is the reason 
why we have done it like this

thanks again for your comments very much appreciated 

~|
Create robust enterprise, web RIAs.
Upgrade to ColdFusion 8 and integrate with Adobe Flex
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294429
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: form problem

2007-12-09 Thread Richard White
... 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
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: query help

2007-12-09 Thread Dave l
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, address1, city, state, postalcode, state,
  ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) +
 
  it changes the error to:
  'ROUND' is not recognized as a function or procedure.
 
 
  so i might be sol on this tut
 
 
  


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294431
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


SequeLink driver.

2007-12-09 Thread jeremy m
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 
fighting with it and finally gave up, opting to use ODBC.

Holy crap the SequeLink ODBC driver sucks!  I can initially connect and load a 
page o.k., but if I let my browser sit for even 30 seconds without any 
activity, I'll get any number of SequeLink JDBC Driver errors.  Connection 
closed due to session kill and MySQL server has gone away are two I can 
remember off the top.

I've found that if I uncheck Maintain Connections in cfadministrator, 
Everything seems to work fine, however, any and all requests, from simple ajax 
requests to larger cf pages, all take about 20 seconds.

Any suggestions or ideas out there?  I'm open to anything. 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294432
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: SequeLink driver.

2007-12-09 Thread Dave Watts
 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 ODBC.

Can't your client simply create a new login with a shorter password? I'm not
sure what database you're using, but you can usually do this without
changing existing logins.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294433
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: No Longer Need to Lock Session Variables?

2007-12-09 Thread Rick Faircloth
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 reliability (the
 structures which hold this information are now thread-safe) - no more
 crashes because of locking.  (5 year-old Yay!)
 
 (Just kidding - we went straight from 4.5 to 7 so I know exactly where
 you're coming from.)
 
 However you still may need to lock to protect your data for
 application/design reasons (race-conditions for example).  It's rare that
 you'll need to lock whole scopes however and for the most part named locks
 should provide all the utility you need without dragging performance.
 
 Jim Davis




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294434
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: No Longer Need to Lock Session Variables?

2007-12-09 Thread Nicholas M Tunney
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 Certified Advanced ColdFusion MX7 Developer
Adobe Certified Instructor
Adobe Community Expert



Rick Faircloth wrote:
 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 reliability (the
 structures which hold this information are now thread-safe) - no more
 crashes because of locking.  (5 year-old Yay!)

 (Just kidding - we went straight from 4.5 to 7 so I know exactly where
 you're coming from.)

 However you still may need to lock to protect your data for
 application/design reasons (race-conditions for example).  It's rare that
 you'll need to lock whole scopes however and for the most part named locks
 should provide all the utility you need without dragging performance.

 Jim Davis
 




 

~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294435
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Drag Image

2007-12-09 Thread Azadi Saryev
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 (look for jQuery 
puzzle).
i am sure if you google it, you will find more examples  solutions

---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com



Greg Edmonds wrote:
 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 will need to be
 able to click and drag the uploaded image and place it in a position over a
 pre-defined image.  I will need to send the exact location (where the user
 dragged it) of the uploaded picture to the database.  This is a complete
 Cold Fusion environment, so any solutions would need to integrate with Cold
 Fusion.  I hope I have explained myself well enough, if not let me know and
 I'll go into more detail.  Any suggestions would be greatly appreciated.

  

 Thanks!

 Greg

  

 

 Greg Edmonds

 Sitecon

 http://www.sitecon.com/

  

  






 

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294436
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: query help

2007-12-09 Thread Dave l
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
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294437
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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

2007-12-09 Thread Andy Matthews
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:
http://gaylordoprylandsales.com/prop/proposal.cfm?view=73534E3B54060A4C061052691D13

Here's the page when a PDF is trying to be generated:
http://gaylordoprylandsales.com/prop/proposal_pdf.cfm?view=73534E3B54060A4C061052691D13

You can see that the top portion of the proposal outputs just fine, but 
EVERYTHING ELSE is missing. It appears that the correct number of pages are 
there, so I can assume it's simply something with my HTML that's the problem, 
but I have no idea what it might be. It's not like you can debug this sort of 
thing.

Does anyone have any idea why it might be doing this, and if so, what I can do 
to fix it?



andy matthews 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294438
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


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

2007-12-09 Thread Andy Matthews
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, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294440
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


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

2007-12-09 Thread Andy Matthews
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 - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294439
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: No Longer Need to Lock Session Variables?

2007-12-09 Thread Rick Faircloth
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 09, 2007 8:54 PM
 To: CF-Talk
 Subject: 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
 
 




~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294441
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4