Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear, Thanks for your replies. But still am facing issue. @Paul, Yes. I was using ODBC socket datasource to connect CF with SQL server database. In that the connection was successful but Arabic didn't display properly in CFM page.(In db the datatype is correctly used nvarchar and I can see Arabic data as well.) @Bobby, As per your suggestion, I tried to create datasource with Microsoft SQL server driver. But am getting the below error. - Connection verification failed for data source: MCONSULT java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect I found few suggestions from net tried below things but still issue exists. 1. In SQL server configuration manager I enabled TCP/IP protocol. 2. In Windows Firewall I added inbound rule for TCP 1433. Both my CF9 SQL server 2008 are installed in same machine. Please suggest. Sathya.R On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings p...@sustainablegis.com wrote: On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Issue Solved - Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
Dear Friends, Finally the is solved. Thanks Bobby Paul. While adding datasource in CF administrator , in server field I was wrongly trying as localhost, now I changed to MICRO\SQLEXPRESS as server and db name in database field along with check box checked for Enable High ASCII characters and Unicode for data sources configured for non-Latin characters. This solved the issue. Now am able to successfully connect CF9 with SQL server 2008 and Arabic text is displaying as well. Your valuable time help is really appreciated. Thanks, Sathya.R On Thu, Aug 7, 2014 at 10:34 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear, Thanks for your replies. But still am facing issue. @Paul, Yes. I was using ODBC socket datasource to connect CF with SQL server database. In that the connection was successful but Arabic didn't display properly in CFM page.(In db the datatype is correctly used nvarchar and I can see Arabic data as well.) @Bobby, As per your suggestion, I tried to create datasource with Microsoft SQL server driver. But am getting the below error. - Connection verification failed for data source: MCONSULT java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect I found few suggestions from net tried below things but still issue exists. 1. In SQL server configuration manager I enabled TCP/IP protocol. 2. In Windows Firewall I added inbound rule for TCP 1433. Both my CF9 SQL server 2008 are installed in same machine. Please suggest. Sathya.R On Thu, Aug 7, 2014 at 5:19 AM, Paul Hastings p...@sustainablegis.com wrote: On 8/7/2014 6:16 AM, Bobby wrote: He said the arabic text was actually in the database but only ??? when retrieving/displaying with CF. Wouldnt it be garbage IN the db if it wasnt an nchar/nvarchar data type? could be already garbaged as far as cf unicode go. in the bad old days (pre cf/java unicode) that was actually the only way to work w/some encodings. doesn't matter to cf either way. the encodings match back-to-front but the text data is already garbaged or the encodings are mismatched getting garbaged on the way to cf. just to be thorough, i suppose its probably prudent to ask if cf is using the JDBC driver to talk to the db and not some ODBC thing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page
On 8/7/2014 1:34 PM, Sathyanarayanan Ramanathan wrote: Yes. I was using ODBC socket datasource to connect CF with SQL server well you can stop now. Driver]Error establishing socket to host and port: 127.0.0.1:1433. use real IP or server name instead of 127.0.0.1. if you're using an instance, make sure you add that for the server name, bangkok\sqlexpress for example. also double check username/password (won't see that authentication error until server name issue is resolved). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (Semi-OT) - site sucker app
On Wed, Aug 6, 2014 at 9:06 PM, Gerald Guido gerald.gu...@gmail.com wrote: http://www.httrack.com/ is, IMHO, outstanding. +1 for this tool Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com Every cloud does have a silver lining. Sometimes you just have to do some smelting to find it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
This isn't the right tool for the job. But this code seems to work.
!DOCTYPE html
html
head
title/title
/head
body
cfif StructKeyExists(FORM , 'fieldnames')
cfdump var=#FORM# /
scriptsetTimeout(function(){window.history.back();} , 2000);/script
cfelse
scriptsetTimeout(function(){document.getElementById('somefrm').submit();}
, 2);/script
form method=post id=somefrm enctype='multipart/form-data'
input type=file name=somefile
/form
/cfif
/body
/html
I'd be surprised if this worked, actually, since it's not going to
reload the document from the filesystem. So, it'll continue uploading
the file already loaded within the browser, but changes wouldn't be
sent.
Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359088
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
expire application variable
I have a case where I need to have an application variable expire after a known amount of time. Do you have a favorite method for doing this? I was thinking of something like: application.thevar = structnew(); application.thevar.createtick = gettickcount(); application.thevar.thevalue = foo; ...and then, on use, checking gettickcount() - application.thevar.createtick. Good? Better way? -- John Bliss - http://www.linkedin.com/in/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: expire application variable
Are you on ColdFusion 9+? Why not use the built-in cache functionality (cachePut(), cacheGet(), etc.)? If you are on ColdFusion 10+, you can even put related objects into a cache region and manually flush that region using CacheRemoveAll( region ) . -Carl V. On 8/7/2014 1:06 PM, John M Bliss wrote: I have a case where I need to have an application variable expire after a known amount of time. Do you have a favorite method for doing this? I was thinking of something like: application.thevar = structnew(); application.thevar.createtick = gettickcount(); application.thevar.thevalue = foo; ...and then, on use, checking gettickcount() - application.thevar.createtick. Good? Better way? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: expire application variable
Sweet. Thanks! On Aug 7, 2014 5:51 PM, Carl Von Stetten vonner.li...@vonner.net wrote: Are you on ColdFusion 9+? Why not use the built-in cache functionality (cachePut(), cacheGet(), etc.)? If you are on ColdFusion 10+, you can even put related objects into a cache region and manually flush that region using CacheRemoveAll( region ) . -Carl V. On 8/7/2014 1:06 PM, John M Bliss wrote: I have a case where I need to have an application variable expire after a known amount of time. Do you have a favorite method for doing this? I was thinking of something like: application.thevar = structnew(); application.thevar.createtick = gettickcount(); application.thevar.thevalue = foo; ...and then, on use, checking gettickcount() - application.thevar.createtick. Good? Better way? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
Interesting point Dave.
But I just tested on Chrome (Mac) and it does pick up the changed file.
On Fri, Aug 8, 2014 at 12:17 AM, Dave Watts dwa...@figleaf.com wrote:
This isn't the right tool for the job. But this code seems to work.
!DOCTYPE html
html
head
title/title
/head
body
cfif StructKeyExists(FORM , 'fieldnames')
cfdump var=#FORM# /
scriptsetTimeout(function(){window.history.back();} , 2000);/script
cfelse
scriptsetTimeout(function(){document.getElementById('somefrm').submit();}
, 2);/script
form method=post id=somefrm enctype='multipart/form-data'
input type=file name=somefile
/form
/cfif
/body
/html
I'd be surprised if this worked, actually, since it's not going to
reload the document from the filesystem. So, it'll continue uploading
the file already loaded within the browser, but changes wouldn't be
sent.
Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359092
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
And again, I don't think this would be the right tool for the job.
I just also thought that it wouldn't (shouldn't) work and had to try it out.
I would probably go for rsync or something similar.
On Fri, Aug 8, 2014 at 10:06 AM, Ricardo Russon ricardo.rus...@gmail.com
wrote:
Interesting point Dave.
But I just tested on Chrome (Mac) and it does pick up the changed file.
On Fri, Aug 8, 2014 at 12:17 AM, Dave Watts dwa...@figleaf.com wrote:
This isn't the right tool for the job. But this code seems to work.
!DOCTYPE html
html
head
title/title
/head
body
cfif StructKeyExists(FORM , 'fieldnames')
cfdump var=#FORM# /
scriptsetTimeout(function(){window.history.back();} , 2000);/script
cfelse
scriptsetTimeout(function(){document.getElementById('somefrm').submit();}
, 2);/script
form method=post id=somefrm enctype='multipart/form-data'
input type=file name=somefile
/form
/cfif
/body
/html
I'd be surprised if this worked, actually, since it's not going to
reload the document from the filesystem. So, it'll continue uploading
the file already loaded within the browser, but changes wouldn't be
sent.
Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359093
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Auto File Uploading...
Interesting point Dave. But I just tested on Chrome (Mac) and it does pick up the changed file. I'm surprised! But that's interesting to know, so thanks! Dave Watts, CTO, Fig Leaf Software 1-202-527-9569 http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
