To insert Arabic text into my ColdFusion application with Oracle database.
Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| 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:358851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
Are you using the oracle to_nchar() function? http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions187.htm#i1006719 I don't recall what the resulting symptoms are, but I recall having to use that to insert multi-byte characters in Oracle. On Sun, Jul 13, 2014 at 12:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| 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:358852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
No wait, I think it's translate. It's been a while. http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions197.htm#i79617 On Sun, Jul 13, 2014 at 12:36 AM, Jen Larkin jlar...@gmail.com wrote: Are you using the oracle to_nchar() function? http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions187.htm#i1006719 I don't recall what the resulting symptoms are, but I recall having to use that to insert multi-byte characters in Oracle. On Sun, Jul 13, 2014 at 12:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| 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:358853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
On 7/13/2014 2:26 PM, Sathyanarayanan Ramanathan wrote: 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 0) using ancient codepages is no fun (you'll have to set cf's charset). if at all possible, use unicode instead (just use unicode). 1) what's the datatype holding the text? 2) is cf still set at default of utf-8? 3) how are you inserting the text data via cf? ~| 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:358854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked. Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| 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:358855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Billsafe integration
Hello, who knows an easy way to integrate Billsafe in a webshop? Anyone has experiences or has written a cfc for billsafe? Otherwise, what do you think is the best way? Using and modifying cfPayment or cfPaymill? (I need to accept invoice-payments, because of that I wanna use billsafe, or is there another good psp offering invoice-payments and a cfc for using the api?) Thanks Sebastian ~| 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:358856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
help
I have uploaded the images to: /site_ttheartoflovingcatsanddogs_com/toalcad_images /taolcad_images/ /site_ttheartoflovingcatsanddogs_com/main/taolcad_images I have tried: /taolcad_images/ ../../taolcad_images This code is broke: !---Read the image into an object --- cftry cfimage action=read name=myImage source=../taolcad_images/products/resize/#qry_latest24items.largepic1# cfcatch cfimage action=read name=myImage source=../taolcad_images/products/#qry_latest24items.largepic1# !--- Set the square size of the thumb --- cfset sq_size = 133 !--- Write the result to a file. --- cfset ImageSetAntialiasing(myImage,on) cfset ImageScaleToFit(myImage,sq_size,sq_size) !--- Calculate the x and y position to paste the image --- cfif myImage.width GTE myImage.height cfset x = 0 cfset y = ceiling((myImage.width - myImage.height)/2) cfelse cfset x = ceiling((myImage.height - myImage.width)/2) cfset y = 0 /cfif cfset newimg = ImageNew(,sq_size, sq_size, rgb, c4cba9) cfset ImagePaste(newimg, myImage, x, y) cfset ImageWrite(newimg,../taolcad_images/products/resize/#qry_latest24items.largepic1#) /cfcatch /cftry cfset qry_latest24items.name = replace( qry_latest24items.name, '', 'quot;', all) cfset qry_latest24items.productDescription = replace(qry_latest24items.productDescription, '', 'quot;', all) cfif len(qry_latest24items.productDescription) gt 310 cfset qry_latest24items.productDescription = mid(qry_latest24items.productDescription, 1, 310) /cfif cfset variables.item_url = /art-item/ lcase(rereplace(rereplacenocase(qry_latest24items.name, [^a-z|\ ], , all), [[:space:]]+, -, all)) - qry_latest24items.productid /index.cfm cfset qry_latest24items.productDescription = qry_latest24items.productDescription ... a href='#variables.item_url#'read more/a a href=#variables.item_url# title=#name#img src=/taolcad_images/products/resize/#qry_latest24items.largepic1# alt=#name# width=177 //a/td td/td tda href=#variables.item_url# title=#name#span class=frontpageitems#qry_latest24items.name# - #DollarFormat(qry_latest24items.unitPrice)#/span/abr / span class=frontpageitemstext#qry_latest24items.productDescription#/span/td /tr -- Regards, chedder is bedder ~| 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:358857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: help
Yes, this code is broken. You have a logic error. The code inside the CFCATCH will only execute of the code in the CFTRY fails. The syntax on the CFCATCH tag is wrong as you have no type declared, and the code on the first line inside the CFCATCH is the same as what you just tried. So if it fails on the TRY it will fail inside the CFCATCH. Also, to display images in a browser, you need that url path to the image, not the physical path. On Sun, Jul 13, 2014 at 8:18 AM, Matthew Smith chedders...@gmail.com wrote: I have uploaded the images to: /site_ttheartoflovingcatsanddogs_com/toalcad_images /taolcad_images/ /site_ttheartoflovingcatsanddogs_com/main/taolcad_images I have tried: /taolcad_images/ ../../taolcad_images This code is broke: ~| 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:358858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
Dear All, I have created a test oracle database with AR8MSWIN1256 as characterset. Also I created a test table with NVARCHAR2 (1000) as the datatype. Please see the screenshots below. [image: Inline image 1] *Test table:* [image: Inline image 2] *Simple insert statement using Toad for Oracle:* *[image: Inline image 3] * I am not able to find Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² as suggested by Bobby. I am using CF9. Regards, Sathya On Sun, Jul 13, 2014 at 3:52 PM, Bobby bo...@acoderslife.com wrote: In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked. Enable High ASCII characters and Unicode for data sources configured for non-Latin characters² On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| 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:358859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Billsafe integration
there are so many billing/invoicing options out there to choose form, many of then do not require any coding at all, or at very least you just use their api to add clients/invoices to their system. so it really depends what you want, whether you just want a simple invoicing system, or whether you want to process payments from existing site. cfpayment supports a number of gateways out of the box, so the easiest solution to integrating payment processing into your own site would be to use one of the already supported providers. CFPaymill is just for Paymill. On Sun, Jul 13, 2014 at 1:00 PM, sebastian mork federe...@gmx.de wrote: Hello, who knows an easy way to integrate Billsafe in a webshop? Anyone has experiences or has written a cfc for billsafe? Otherwise, what do you think is the best way? Using and modifying cfPayment or cfPaymill? (I need to accept invoice-payments, because of that I wanna use billsafe, or is there another good psp offering invoice-payments and a cfc for using the api?) Thanks Sebastian ~| 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:358860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: To insert Arabic text into my ColdFusion application with Oracle database.
Your screenshots will not come through on the the list, you will have to put them online somewhere and send the links instead. As for the ¡°Enable High ascii¡± settings, my apologies, it doesn¡¯t appear to be available for oracle datasources. On 7/13/14, 9:47 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I have created a test oracle database with AR8MSWIN1256 as characterset. Also I created a test table with NVARCHAR2 (1000) as the datatype. Please see the screenshots below. [image: Inline image 1] *Test table:* [image: Inline image 2] *Simple insert statement using Toad for Oracle:* *[image: Inline image 3] * I am not able to find Enable High ASCII characters and Unicode for data sources configured for non-Latin characters©÷ as suggested by Bobby. I am using CF9. Regards, Sathya On Sun, Jul 13, 2014 at 3:52 PM, Bobby bo...@acoderslife.com wrote: In the CF Administrator datasource settings, under the advanced section, there is a checkbox for enabling high ascii/unicode chars. It is off by default. Be sure that is checked. Enable High ASCII characters and Unicode for data sources configured for non-Latin characters©÷ On 7/13/14, 3:26 AM, Sathyanarayanan Ramanathan sathya0...@gmail.com wrote: Dear All, I am trying to insert Arabic text into my ColdFusion application with Oracle database. I tried below 3 scenarios but didn't work for me. 1. One of my ColdFusion application is already implemented to handle Arabic text using Oracle db. I checked the NLS_characterset is set to AR8MSWIN1256. There are few Arabic text found in few tables. But when I try to insert some sample rows with arabic text using toad it's coming as ?. 2. I created a new database and tried to set NLS_characterset to AR8MSWIN1256. I tried to create a table insert some sample rows with Arabic text using toad it's still coming as ?. 3. I searched few sites set NLS_characterset to AL32UTF8. But still the results are same. Your time help will be really appreciated. Sathya.R ~| 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:358861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: help
Yes, this code is broken. You have a logic error. The code inside the CFCATCH will only execute of the code in the CFTRY fails. The syntax on the CFCATCH tag is wrong as you have no type declared, and the code on the first line inside the CFCATCH is the same as what you just tried. So if it fails on the TRY it will fail inside the CFCATCH. This is all very accurate except for one portion. CFCATCH doesn't require a type. It's generally recommended that you specify a type, but in the absence of that attribute it'll simply catch any exception thrown by the CFTRY. 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:358862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: help
what path should i use? On Sun, Jul 13, 2014 at 10:11 AM, Dave Watts dwa...@figleaf.com wrote: Yes, this code is broken. You have a logic error. The code inside the CFCATCH will only execute of the code in the CFTRY fails. The syntax on the CFCATCH tag is wrong as you have no type declared, and the code on the first line inside the CFCATCH is the same as what you just tried. So if it fails on the TRY it will fail inside the CFCATCH. This is all very accurate except for one portion. CFCATCH doesn't require a type. It's generally recommended that you specify a type, but in the absence of that attribute it'll simply catch any exception thrown by the CFTRY. 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:358863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Lanyrd Site for NCDevCon
The NCDevCon team announced that they set up a Lanyrd site for the September 13-14, 2014 conference. Lanyrd Site: http://lanyrd.com/2014/ncdevcon/ There will be a ColdFusion track as well as JS, HTML/CSS, design, security, and others. The sessions include great speakers from the Adobe team, nationally known speakers, as well as regional and local speakers. Each year it is a little different, but always full of great content on web and mobile development. More Info: http://ncdevcon.com/ The event is conveniently located in Raleigh, NC at the College of Textiles facility on the Centennial Campus of North Carolina State University. http://www.tx.ncsu.edu/ There is a FAQ page on the web site if you have questions. Please contact the NCDevCon team through the web site if your questions aren't answered on the FAQs. I hope to see you at the event. Thanks, Roger -- LinkedIn: http://www.linkedin.com/pub/roger-austin/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Blog: http://RogerTheGeek.wordpress.com/ ~| 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:358864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
