Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

[Paul Hastings]

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

Issue Solved -> Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

[Sathyanarayanan Ramanathan]

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 
> 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

[Sathyanarayanan Ramanathan]

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 
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

Re: Auto File Uploading...

[Byron Mann]

Sounds like curl or wget would do the trick.

Byron Mann
Lead Engineer & Architect
HostMySite.com
On Aug 6, 2014 8:36 PM, "Phillip Vector"  wrote:

>
> So I have a server that reads a file that is submitted to it and processes
> the contents. I can not touch this server and change any settings on it..
>
> I want to take a file I have (Let's call it data.txt) and upload it to the
> server once an hour. I can just reload the page once an hour or I can set
> up a schedule, no problem.. I just can't seem to automate the browse button
> to pick the file (which I can understand not allowing).
>
> So is there any way for me to not use the browse button and post it
> directly to an address like a form?
>
>
> 

~|
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:359083
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: T&C's and Privacy Policy

[Christopher Bowyer]

Looks good! However, the last two lines of the Web Site Terms and Conditions of 
Use:

General Terms and Conditions applicable to Use of a Web Site.
- 2 -

and the last line of the Privacy Policy:

[Note1]Internet Web Site Privacy Policy.

look like they don't belong.

Could you advise on this please? In addition, if the two are to be taken in 
context as one document or as two separate documents?

Thank you. I look forward to your reply.

> Here are some templates I have used in the past.  Fill in the [blanks].
> 
> 
> 
> Web Site Terms and Conditions of Use
> 
> 1. Terms
> By accessing this web site, you are agreeing to be bound by these web 
> site Terms and Conditions of Use, all applicable laws and regulations, 
> and agree that you are responsible for compliance with any applicable 
> local laws. If you do not agree with any of these terms, you are 
> prohibited from using or accessing this site. The materials contained 
> in this web site are protected by applicable copyright and trade mark 
> law.
> 2. Use License
> (a) Permission is granted to temporarily download one copy of the 
> materials (information or software) on [Web Site Name]'s web site for 
> personal, non-commercial transitory viewing only. This is the grant of 
> a license, not a transfer of title, and under this license you may 
> not:
> (i) modify or copy the materials;
> (ii) use the materials for any commercial purpose, or for any public 
> display (commercial or non-commercial);
> (iii) attempt to decompile or reverse engineer any software contained 
> on [Web Site Name]'s web site;
> (iv) remove any copyright or other proprietary notations from the 
> materials; or
> (v) transfer the materials to another person or "mirror" the materials 
> on any other server.
> (b) This license shall automatically terminate if you violate any of 
> these restrictions and may be terminated by [Web Site Name] at any 
> time. Upon terminating your viewing of these materials or upon the 
> termination of this license, you must destroy any downloaded materials 
> in your possession whether in electronic or printed format.
> 3. Disclaimer
> (a) The materials on [Web Site Name]'s web site are provided "as is". 
> [Web Site Name] makes no warranties, expressed or implied, and hereby 
> disclaims and negates all other warranties, including without 
> limitation, implied warranties or conditions of merchantability, 
> fitness for a particular purpose, or non-infringement of intellectual 
> property or other violation of rights. Further, [Web Site Name] does 
> not warrant or make any representations concerning the accuracy, 
> likely results, or reliability of the use of the materials on its 
> Internet web site or otherwise relating to such materials or on any 
> sites linked to this site.
> 4. Limitations
> In no event shall [Web Site Name] or its suppliers be liable for any 
> damages (including, without limitation, damages for loss of data or 
> profit, or due to business interruption,) arising out of the use or 
> inability to use the materials on [Web Site Name]'s Internet site, 
> even if [Web Site Name] or a [Web Site Name] authorized representative 
> has been notified orally or in writing of the possibility of such 
> damage. Because some jurisdictions do not allow limitations on implied 
> warranties, or limitations of liability for consequential or 
> incidental damages, these limitations may not apply to you.
> 5. Revisions and Errata
> The materials appearing on [Web Site Name]'s web site could include 
> technical, typographical, or photographic errors. [Web Site Name] does 
> not warrant that any of the materials on its web site are accurate, 
> complete, or current. [Web Site Name] may make changes to the 
> materials contained on its web site at any time without notice. [Web 
> Site Name] does not, however, make any commitment to update the 
> materials.
> 6. Links
> [Web Site Name] has not reviewed all of the sites linked to its 
> Internet web site and is not responsible for the contents of any such 
> linked site. The inclusion of any link does not imply endorsement by 
> [Web Site Name] of the site. Use of any such linked web site is at the 
> user's own risk.
> 7. Site Terms of Use Modifications
> [Web Site Name] may revise these terms of use for its web site at any 
> time without notice. By using this web site you are agreeing to be 
> bound by the then current version of these Terms and Conditions of Use.
> 
> 8. Governing Law
> Any claim relating to [Web Site Name]'s web site shall be governed by 
> the laws of the State of [State (ie. California)] without regard to 
> its conflict of law provisions.
> General Terms and Conditions applicable to Use of a Web Site.
> - 2 -
> 
> 
> 
> 
> 
> 
> 
> 
> Privacy Policy
> 
> 
> Your privacy is very important to us. Accordingly, we have developed 
> this Policy in order for you to understand how we collect, use, 
> communicate and disclose and make use of personal information. The 
> f

Re: Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

[Paul Hastings]

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:359081
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

[Gerald Guido]

http://www.httrack.com/   is, IMHO, outstanding.

HTH
G!

*Gerald Anthony Guido*
Nullius in verba 
-- Horace

Twitter 
Facebook 


On Wed, Aug 6, 2014 at 8:36 PM, Ricardo Russon 
wrote:

>
> I've always just used wget.
>
>
>
>
>
> On Thu, Aug 7, 2014 at 10:35 AM, John M Bliss 
> wrote:
>
> >
> > This is what I've used in the past:
> > https://softbytelabs.com/en/BlackWidow/
> > On Aug 6, 2014 8:32 PM, "Michael Dinowitz" 
> > wrote:
> >
> > >
> > > Does anyone have a suggestion for a good application that can be
> pointed
> > to
> > > an url and then download every page under that url. For example, if I
> > want
> > > to view all of the Google maps documents offline I can point the app at
> > > https://developers.google.com/maps and it'll get me all of the faq,
> the
> > > api
> > > docs, etc.
> > >
> > > Yes, I can write such an app in CF and have a dozen times over. I also
> > know
> > > that if I start rewriting my old apps in any way, shape, or form, I run
> > the
> > > risk of getting pulled into a black hole of optimization and
> organization
> > > and lose track of the real project. Save me from myself and point me to
> > > what you would use. ;)
> > >
> > > Thanks
> > > Michael
> > >
> > > "It is a wise man who knows his own foibles, especially if he can spell
> > > foibles without using a spellchecker."
> > >
> > >
> > >
> >
> >
>
> 

~|
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:359080
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[Phillip Vector]

Thank you very much. Both of you.


On Wed, Aug 6, 2014 at 5:49 PM, Ricardo Russon 
wrote:

>
> This isn't the right tool for the job. But this code seems to work.
>
>
> 
> 
> 
> 
> 
>
> 
>
> 
>  
> setTimeout(function(){window.history.back();} , 2000);
>  
>
>  setTimeout(function(){document.getElementById('somefrm').submit();}
> , 2);
>  
> 
> 
>  
> 
> 
>
>
>
>
> On Thu, Aug 7, 2014 at 10:45 AM, John M Bliss 
> wrote:
>
> >
> > In other words, if you have CF running locally, you could write something
> > that performs a cfhttp post to server...mimicking browse, select file,
> > click submit.
> > On Aug 6, 2014 8:42 PM, "John M Bliss"  wrote:
> >
> > > ...or HTTP post.
> > > On Aug 6, 2014 8:39 PM, "John M Bliss"  wrote:
> > >
> > >> In short, no. You'd have to deliver file to server via email / FTP /
> > etc.
> > >> On Aug 6, 2014 8:36 PM, "Phillip Vector" 
> > >> wrote:
> > >>
> > >>>
> > >>> So I have a server that reads a file that is submitted to it and
> > >>> processes
> > >>> the contents. I can not touch this server and change any settings on
> > it..
> > >>>
> > >>> I want to take a file I have (Let's call it data.txt) and upload it
> to
> > >>> the
> > >>> server once an hour. I can just reload the page once an hour or I can
> > set
> > >>> up a schedule, no problem.. I just can't seem to automate the browse
> > >>> button
> > >>> to pick the file (which I can understand not allowing).
> > >>>
> > >>> So is there any way for me to not use the browse button and post it
> > >>> directly to an address like a form?
> > >>>
> > >>>
> > >>>
> >
> >
>
> 

~|
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:359079
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[Ricardo Russon]

This isn't the right tool for the job. But this code seems to work.











 
setTimeout(function(){window.history.back();} , 2000);
 
 setTimeout(function(){document.getElementById('somefrm').submit();}
, 2);
 


 






On Thu, Aug 7, 2014 at 10:45 AM, John M Bliss  wrote:

>
> In other words, if you have CF running locally, you could write something
> that performs a cfhttp post to server...mimicking browse, select file,
> click submit.
> On Aug 6, 2014 8:42 PM, "John M Bliss"  wrote:
>
> > ...or HTTP post.
> > On Aug 6, 2014 8:39 PM, "John M Bliss"  wrote:
> >
> >> In short, no. You'd have to deliver file to server via email / FTP /
> etc.
> >> On Aug 6, 2014 8:36 PM, "Phillip Vector" 
> >> wrote:
> >>
> >>>
> >>> So I have a server that reads a file that is submitted to it and
> >>> processes
> >>> the contents. I can not touch this server and change any settings on
> it..
> >>>
> >>> I want to take a file I have (Let's call it data.txt) and upload it to
> >>> the
> >>> server once an hour. I can just reload the page once an hour or I can
> set
> >>> up a schedule, no problem.. I just can't seem to automate the browse
> >>> button
> >>> to pick the file (which I can understand not allowing).
> >>>
> >>> So is there any way for me to not use the browse button and post it
> >>> directly to an address like a form?
> >>>
> >>>
> >>>
>
> 

~|
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:359078
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[John M Bliss]

In other words, if you have CF running locally, you could write something
that performs a cfhttp post to server...mimicking browse, select file,
click submit.
On Aug 6, 2014 8:42 PM, "John M Bliss"  wrote:

> ...or HTTP post.
> On Aug 6, 2014 8:39 PM, "John M Bliss"  wrote:
>
>> In short, no. You'd have to deliver file to server via email / FTP / etc.
>> On Aug 6, 2014 8:36 PM, "Phillip Vector" 
>> wrote:
>>
>>>
>>> So I have a server that reads a file that is submitted to it and
>>> processes
>>> the contents. I can not touch this server and change any settings on it..
>>>
>>> I want to take a file I have (Let's call it data.txt) and upload it to
>>> the
>>> server once an hour. I can just reload the page once an hour or I can set
>>> up a schedule, no problem.. I just can't seem to automate the browse
>>> button
>>> to pick the file (which I can understand not allowing).
>>>
>>> So is there any way for me to not use the browse button and post it
>>> directly to an address like a form?
>>>
>>>
>>> 

~|
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:359077
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[Phillip Vector]

Yes... HTTP post... That's what I'm trying to do.. Is there a way? (don't
tease)


On Wed, Aug 6, 2014 at 5:42 PM, John M Bliss  wrote:

>
> ...or HTTP post.
> On Aug 6, 2014 8:39 PM, "John M Bliss"  wrote:
>
> > In short, no. You'd have to deliver file to server via email / FTP / etc.
> > On Aug 6, 2014 8:36 PM, "Phillip Vector" 
> > wrote:
> >
> >>
> >> So I have a server that reads a file that is submitted to it and
> processes
> >> the contents. I can not touch this server and change any settings on
> it..
> >>
> >> I want to take a file I have (Let's call it data.txt) and upload it to
> the
> >> server once an hour. I can just reload the page once an hour or I can
> set
> >> up a schedule, no problem.. I just can't seem to automate the browse
> >> button
> >> to pick the file (which I can understand not allowing).
> >>
> >> So is there any way for me to not use the browse button and post it
> >> directly to an address like a form?
> >>
> >>
> >>
>
> 

~|
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:359076
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[John M Bliss]

...or HTTP post.
On Aug 6, 2014 8:39 PM, "John M Bliss"  wrote:

> In short, no. You'd have to deliver file to server via email / FTP / etc.
> On Aug 6, 2014 8:36 PM, "Phillip Vector" 
> wrote:
>
>>
>> So I have a server that reads a file that is submitted to it and processes
>> the contents. I can not touch this server and change any settings on it..
>>
>> I want to take a file I have (Let's call it data.txt) and upload it to the
>> server once an hour. I can just reload the page once an hour or I can set
>> up a schedule, no problem.. I just can't seem to automate the browse
>> button
>> to pick the file (which I can understand not allowing).
>>
>> So is there any way for me to not use the browse button and post it
>> directly to an address like a form?
>>
>>
>> 

~|
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:359075
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[Phillip Vector]

Damm security! :)

Thanks.


On Wed, Aug 6, 2014 at 5:39 PM, John M Bliss  wrote:

>
> In short, no. You'd have to deliver file to server via email / FTP / etc.
> On Aug 6, 2014 8:36 PM, "Phillip Vector" 
> wrote:
>
> >
> > So I have a server that reads a file that is submitted to it and
> processes
> > the contents. I can not touch this server and change any settings on it..
> >
> > I want to take a file I have (Let's call it data.txt) and upload it to
> the
> > server once an hour. I can just reload the page once an hour or I can set
> > up a schedule, no problem.. I just can't seem to automate the browse
> button
> > to pick the file (which I can understand not allowing).
> >
> > So is there any way for me to not use the browse button and post it
> > directly to an address like a form?
> >
> >
> >
>
> 

~|
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:359074
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Auto File Uploading...

[John M Bliss]

In short, no. You'd have to deliver file to server via email / FTP / etc.
On Aug 6, 2014 8:36 PM, "Phillip Vector"  wrote:

>
> So I have a server that reads a file that is submitted to it and processes
> the contents. I can not touch this server and change any settings on it..
>
> I want to take a file I have (Let's call it data.txt) and upload it to the
> server once an hour. I can just reload the page once an hour or I can set
> up a schedule, no problem.. I just can't seem to automate the browse button
> to pick the file (which I can understand not allowing).
>
> So is there any way for me to not use the browse button and post it
> directly to an address like a form?
>
>
> 

~|
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:359073
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

[Ricardo Russon]

I've always just used wget.





On Thu, Aug 7, 2014 at 10:35 AM, John M Bliss  wrote:

>
> This is what I've used in the past:
> https://softbytelabs.com/en/BlackWidow/
> On Aug 6, 2014 8:32 PM, "Michael Dinowitz" 
> wrote:
>
> >
> > Does anyone have a suggestion for a good application that can be pointed
> to
> > an url and then download every page under that url. For example, if I
> want
> > to view all of the Google maps documents offline I can point the app at
> > https://developers.google.com/maps and it'll get me all of the faq, the
> > api
> > docs, etc.
> >
> > Yes, I can write such an app in CF and have a dozen times over. I also
> know
> > that if I start rewriting my old apps in any way, shape, or form, I run
> the
> > risk of getting pulled into a black hole of optimization and organization
> > and lose track of the real project. Save me from myself and point me to
> > what you would use. ;)
> >
> > Thanks
> > Michael
> >
> > "It is a wise man who knows his own foibles, especially if he can spell
> > foibles without using a spellchecker."
> >
> >
> >
>
> 

~|
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:359072
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

[John M Bliss]

This is what I've used in the past: https://softbytelabs.com/en/BlackWidow/
On Aug 6, 2014 8:32 PM, "Michael Dinowitz" 
wrote:

>
> Does anyone have a suggestion for a good application that can be pointed to
> an url and then download every page under that url. For example, if I want
> to view all of the Google maps documents offline I can point the app at
> https://developers.google.com/maps and it'll get me all of the faq, the
> api
> docs, etc.
>
> Yes, I can write such an app in CF and have a dozen times over. I also know
> that if I start rewriting my old apps in any way, shape, or form, I run the
> risk of getting pulled into a black hole of optimization and organization
> and lose track of the real project. Save me from myself and point me to
> what you would use. ;)
>
> Thanks
> Michael
>
> "It is a wise man who knows his own foibles, especially if he can spell
> foibles without using a spellchecker."
>
>
> 

~|
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:359070
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Auto File Uploading...

[Phillip Vector]

So I have a server that reads a file that is submitted to it and processes
the contents. I can not touch this server and change any settings on it..

I want to take a file I have (Let's call it data.txt) and upload it to the
server once an hour. I can just reload the page once an hour or I can set
up a schedule, no problem.. I just can't seem to automate the browse button
to pick the file (which I can understand not allowing).

So is there any way for me to not use the browse button and post it
directly to an address like a form?


~|
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:359071
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

(Semi-OT) - site sucker app

[Michael Dinowitz]

Does anyone have a suggestion for a good application that can be pointed to
an url and then download every page under that url. For example, if I want
to view all of the Google maps documents offline I can point the app at
https://developers.google.com/maps and it'll get me all of the faq, the api
docs, etc.

Yes, I can write such an app in CF and have a dozen times over. I also know
that if I start rewriting my old apps in any way, shape, or form, I run the
risk of getting pulled into a black hole of optimization and organization
and lose track of the real project. Save me from myself and point me to
what you would use. ;)

Thanks
Michael

"It is a wise man who knows his own foibles, especially if he can spell
foibles without using a spellchecker."


~|
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:359069
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

[Bobby]

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?

On 8/6/14, 12:21 PM, "Paul Hastings"  wrote:

>
>On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote:
>> *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data
>>in
>> some table columns. But when I try to fetch & display using CF even
>>after
>> adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic
>>text
>> appeared as .
>
>"??" means your text data is garbaged from the db. double check that it's
>stored
>in an "N" datatype (nchar, nvarchar, etc.). then double check if the data
>is in
>fact encoded as unicode.
>
>
>

~|
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:359068
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

[Paul Hastings]

On 8/6/2014 8:28 PM, Bobby wrote:
>
> Last time, my suggestion was to make sure the "Enable High ASCII
> characters and Unicode for data sources configured for non-Latin
> characters� setting was enabled on your CF datasource but that was before
> I realized it was an oracle datasource. If you are using a SQL Server
> datasource this time, that setting should apply so make sure the setting
> is enabled and try it again.

will only have effect on cfqueryparam.



~|
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:359067
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

[Paul Hastings]

On 8/6/2014 8:17 PM, Sathyanarayanan Ramanathan wrote:
> *Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in
> some table columns. But when I try to fetch & display using CF even after
> adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic text
> appeared as .

"??" means your text data is garbaged from the db. double check that it's stored
in an "N" datatype (nchar, nvarchar, etc.). then double check if the data is in
fact encoded as unicode.


~|
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:359066
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

[Bobby]

Last time, my suggestion was to make sure the "Enable High ASCII
characters and Unicode for data sources configured for non-Latin
characters² setting was enabled on your CF datasource but that was before
I realized it was an oracle datasource. If you are using a SQL Server
datasource this time, that setting should apply so make sure the setting
is enabled and try it again.


On 8/6/14, 9:17 AM, "Sathyanarayanan Ramanathan" 
wrote:

>
>Dear Friends,
>
>Few days before I was trying to insert Arabic text into my ColdFusion
>application with oracle database. And finally it worked for me as I
>mentioned in previous mail chain below.
>
>*Steps taken:*
>
>*Oracle side:* I created the new database with NLS_CHARACTERSET as
>AL32UTF8
>and imported my old exported database having different characterset.
>
>*CF side:*
>I added the below two lines at the top of the cfm template.
>
>
>
>*Current Issue:*
>But now am facing similar issue with respect to insert Arabic text into my
>ColdFusion application with SQL Server 2008 database.
>
>*Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in
>some table columns. But when I try to fetch & display using CF even after
>adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic
>text
>appeared as .
>
>But if I use charset as Windows-1256 static text in the cfm page such as
>column headers are coming as Arabic. But the fetched data from sql db
>still
>appear as ???
>
>Please help.
>
>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:359065
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Unable To display Arabic text fetched SQL Server 2008 database into my CFM page

[Sathyanarayanan Ramanathan]

Dear Friends,

Few days before I was trying to insert Arabic text into my ColdFusion
application with oracle database. And finally it worked for me as I
mentioned in previous mail chain below.

*Steps taken:*

*Oracle side:* I created the new database with NLS_CHARACTERSET as AL32UTF8
and imported my old exported database having different characterset.

*CF side:*
I added the below two lines at the top of the cfm template.



*Current Issue:*
But now am facing similar issue with respect to insert Arabic text into my
ColdFusion application with SQL Server 2008 database.

*Issue 1: *Now I have existing SQL server 2008 db with Arabic text data in
some table columns. But when I try to fetch & display using CF even after
adding charset in meta tag & cfprocessingdirective as UTF-8 all Arabic text
appeared as .

But if I use charset as Windows-1256 static text in the cfm page such as
column headers are coming as Arabic. But the fetched data from sql db still
appear as ???

Please help.

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:359064
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9/Windows how to push data to HTML page

[John M Bliss]

Many ways to accomplish this:

Check out alternatives to cfdiv here:
https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfdiv/index.md

JQuery example (you'd use a Javascript timer instead of the button):
http://jsfiddle.net/ZPYUS/

etc


On Wed, Aug 6, 2014 at 8:23 AM, Mike K  wrote:

>
> Ideally I'd like it updating while he's looking at it .  rather the way
> Facebook does.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
>
> On Wed, Aug 6, 2014 at 10:17 PM, John M Bliss 
> wrote:
>
> >
> > Are you talking about updating the page while end-user is looking at it?
> Or
> > do you just need to have it updated on load / refresh?
> >
> >
> > On Wed, Aug 6, 2014 at 8:03 AM, Mike K  wrote:
> >
> > >
> > > I have a radio station site, and I want to be able to update the pages
> > > automatically as events happen.  For example on the section where it
> says
> > > "what's on air now"  i want it to automatically change as the hour
> ticks
> > > over and the new show startsOr as the live call of the sports ends
> > and
> > > we return to music.
> > >
> > > Does anyone have a way to do that?   I have been unsuccessful at using
> > > now() as a function in a CFC because the CFC stays in memory and doesnt
> > > necessarily update the data it works with.   In fact the "what's on
> > today"
> > > doesnt always have today's program listing - it often has yesterday's,
> > even
> > > though it's based on now() as a parameter in the cfquery on the
> database
> > > programming table.
> > >
> > > --
> > > Cheers
> > > Mike Kear
> > > Windsor, NSW, Australia
> > > Adobe Certified Advanced ColdFusion Developer
> > > AFP Webworks
> > > http://afpwebworks.com
> > > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
> > >
> > >
> > >
> >
> >
>
> 

~|
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:359063
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9/Windows how to push data to HTML page

[Mike K]

Ideally I'd like it updating while he's looking at it .  rather the way
Facebook does.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month




On Wed, Aug 6, 2014 at 10:17 PM, John M Bliss  wrote:

>
> Are you talking about updating the page while end-user is looking at it? Or
> do you just need to have it updated on load / refresh?
>
>
> On Wed, Aug 6, 2014 at 8:03 AM, Mike K  wrote:
>
> >
> > I have a radio station site, and I want to be able to update the pages
> > automatically as events happen.  For example on the section where it says
> > "what's on air now"  i want it to automatically change as the hour ticks
> > over and the new show startsOr as the live call of the sports ends
> and
> > we return to music.
> >
> > Does anyone have a way to do that?   I have been unsuccessful at using
> > now() as a function in a CFC because the CFC stays in memory and doesnt
> > necessarily update the data it works with.   In fact the "what's on
> today"
> > doesnt always have today's program listing - it often has yesterday's,
> even
> > though it's based on now() as a parameter in the cfquery on the database
> > programming table.
> >
> > --
> > Cheers
> > Mike Kear
> > Windsor, NSW, Australia
> > Adobe Certified Advanced ColdFusion Developer
> > AFP Webworks
> > http://afpwebworks.com
> > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
> >
> >
> >
>
> 

~|
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:359062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: CF9/Windows how to push data to HTML page

[John M Bliss]

Are you talking about updating the page while end-user is looking at it? Or
do you just need to have it updated on load / refresh?


On Wed, Aug 6, 2014 at 8:03 AM, Mike K  wrote:

>
> I have a radio station site, and I want to be able to update the pages
> automatically as events happen.  For example on the section where it says
> "what's on air now"  i want it to automatically change as the hour ticks
> over and the new show startsOr as the live call of the sports ends and
> we return to music.
>
> Does anyone have a way to do that?   I have been unsuccessful at using
> now() as a function in a CFC because the CFC stays in memory and doesnt
> necessarily update the data it works with.   In fact the "what's on today"
> doesnt always have today's program listing - it often has yesterday's, even
> though it's based on now() as a parameter in the cfquery on the database
> programming table.
>
> --
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
> 

~|
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:359061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF9/Windows how to push data to HTML page

[Mike K]

I have a radio station site, and I want to be able to update the pages
automatically as events happen.  For example on the section where it says
"what's on air now"  i want it to automatically change as the hour ticks
over and the new show startsOr as the live call of the sports ends and
we return to music.

Does anyone have a way to do that?   I have been unsuccessful at using
now() as a function in a CFC because the CFC stays in memory and doesnt
necessarily update the data it works with.   In fact the "what's on today"
doesnt always have today's program listing - it often has yesterday's, even
though it's based on now() as a parameter in the cfquery on the database
programming table.

-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


~|
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:359060
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm