RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
Thanks but where are the tutorials on how to do this in CF7, they all seem to be geared toward CF8 onwards. I am willing to learn, however time is not on my side as there is a lot of pressure to migrate to .NET -Original Message- From: jqdur...@gmail.com [mailto:jqdur...@gmail.com]

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
Thanks but where are the tutorials on how to do this in CF7, they all seem to be geared toward CF8 onwards. I am willing to learn, however time is not on my side as there is a lot of pressure to migrate to .NET -Original Message- From: jqdur...@gmail.com [mailto:jqdur...@gmail.com]

Re: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Russ Michaels
i'm sure I sent some links to tutorials at the start of this thread ? If you use JQuery as suggested then you do not need any cf8/cf9 specific code. just Google using jquery with coldfusion and you will get plenty of hits. On Mon, Mar 14, 2011 at 10:12 AM, Ian Vaughan

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
Thanks found this link http://www.monochrome.co.uk/blog/2008/02/01/using-jquery-and-coldfusion- 7-with-a-little-json-glue which seems ok - the problem I am having in understanding is how would I use CFJSON to use the .asmx webservice data that I would consume/call with the Coldfusion 7 cfinvoke

Re: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Michael Grant
The secret to why Ian doesn't want to do any of his own work on this is in his email address: .gov.uk He works for the goverment, of course he doesn't want to do any work. hahaha. just kidding Ian In all seriousness, why don't you just hire someone to do it? It's been 12 days since your

RE: Text to voice

2011-03-14 Thread Stephens, Larry V
Excellent point. It is. I've been talking with the chief and we'll do a mock-up with them first thing. -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Friday, March 11, 2011 5:16 PM To: cf-talk Subject: Re: Text to voice On 3/11/2011 2:06 PM, Judah McAuley wrote:

Re: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Dean Lawrence
Ian, again you are mixing things up.CFJSON is not what calls the webservice. CFJSON is used to encode or decode native ColdFusion objects to and from JSON format. So if you if have a query result, you would pass that query object to CFJSON and it will encode it into JSON format. Vice-versa, you

RE: RE: Database Lookup - Possible with CF?

2011-03-14 Thread Ian Vaughan
Thanks dean, that's great -Original Message- From: Dean Lawrence [mailto:dean...@gmail.com] Sent: 14 March 2011 13:21 To: cf-talk Subject: Re: RE: Database Lookup - Possible with CF? Ian, again you are mixing things up.CFJSON is not what calls the webservice. CFJSON is used to encode

Re: Database Lookup - Possible with CF?

2011-03-14 Thread Dan G. Switzer, II
I also posted already posted an example for Ian showing the jQuery/CF7 portion of the code: http://blog.pengoworks.com/index.cfm/2011/3/3/Easy-AJAX-using-ColdFusion-jQuery-and-CFCs The example does deal w/a struct, but converting data to a struct is very straightforward. I know he's seen

cf jquery mobile

2011-03-14 Thread Tim Do
I'm playing around w/ jquery mobile and am struggling with how to get certain features of cf to work within jquery mobile. For instance, within my cfform the form validation and my related dropdown which I use cfselect and bind no long work. Why is this and is there a way to get this to work

Data Truncation on TEXT field

2011-03-14 Thread Robert Harrison
Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base is: MS SQL 2008 R2 Field type is: text When an update is done the data is truncated at around 63,000 characters.

Re: Data Truncation on TEXT field

2011-03-14 Thread Brian Cain
Check the advanced settings on the datasource in the CF Adminstrator. Make sure CLOB (Enable long text retrival) is checked , and increase the long text buffer to handle the larger data field size. ~| Order the Adobe

RE: Data Truncation on TEXT field

2011-03-14 Thread Robert Harrison
Going straight to just the SQL update I have: cfquery datasource=#dsn# UPDATE tbl_capabilities_categories SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS' WHERE id=#id#; /cfquery capability_cat_txt2 field type is TEXT Only about 63,000 of the update characters are

RE: Data Truncation on TEXT field

2011-03-14 Thread Robert Harrison
That's it. Thank You. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog:

Re: Data Truncation on TEXT field

2011-03-14 Thread Russ Michaels
Rob, The Text, NText, and Image data types come from the previous versions of SQL Server. It is recommended that you use the newer varchar(MAX), nvarchar(MAX), and varbinary(MAX) data types instead. Results to text only allows a maximum of 8192 characters. Perhaps this is also your issue in

same content different result CFFile vs CFContent

2011-03-14 Thread Dawn Sekel
I am converting some code that originally used CFFILE to write the contents of a variable to a file on the server and then attached it to an email and emailed. For security reasons, we have switched to https:// and are providing a link for an authenticated user that takes the contents of the

Old School CFX (TextCrypt) and RSA Encryption

2011-03-14 Thread Brook Davies
Hey all, We're moving away from a really old CFC (textCrypt) from PerthWeb that we have been using for years to generate RSA public/private key pairs and do encryption/decryption. The CFX doesn't play well with CF9 64 Bit and I wanted to use the native Java encryption abilities. I've

Solr Summary Text

2011-03-14 Thread Dean Lawrence
Does anyone know if you can control how much text is included in the summary text that Solr returns with it's results? I am trying to migrate from Verity to Solr, but the summary text that I am getting back is very short when using Solr. With Verity, I get back about a paragraph or so of text,

CF9 Undelivr not working as expected

2011-03-14 Thread Yuliang Ruan
We upgraded to CF9 on the production server and the spooler isn't working like before. Expected behavior is .cfmail file is created in Spool/ folder, then if rejected by SMTP, moved to Undelivr folder. Current behavior. .cfmail created in Spool/, never appears in Undelivr/I sent

Re: CF9 Undelivr not working as expected

2011-03-14 Thread Russ Michaels
this means your SMTP server is accepting the email and attempting to deliver it, failing and then sending you an email to tell you it failed. when it ends up in undelivered folder this means the SMTP refused the email or coldfusion could not connect to smtp server. These are setting on the mail

Re: CF9 Undelivr not working as expected

2011-03-14 Thread Yuliang Ruan
this means your SMTP server is accepting the email and attempting to deliver it, failing and then sending you an email to tell you it failed. when it ends up in undelivered folder this means the SMTP refused the email or coldfusion could not connect to smtp server. These are setting on the mail

Re: CF9 Undelivr not working as expected

2011-03-14 Thread Brian Cain
If it is a valid formatted email address CF will send to the mail server regardless. I believe CF will only move something to undeliverable if it cannot connect to the mail server or if the email address in not in a valid format. Brian

Re: CF9 Undelivr not working as expected

2011-03-14 Thread Yuliang Ruan
If it is a valid formatted email address CF will send to the mail server regardless. I believe CF will only move something to undeliverable if it cannot connect to the mail server or if the email address in not in a valid format. Brian actually not getting that behavior either. I sent an

Re: Javascript question

2011-03-14 Thread Carl Von Stetten
Is it possible that the click event is actually happening on the TD elements and not the TR? You might try attaching the click event to the parent table (so it only binds to one element) and take advantage of event bubbling. Use the event.target attribute to get to the row:

RE: Data Truncation on TEXT field

2011-03-14 Thread Bobby Hartsfield
Enable Blob/Clob on the datasoruce. FYI, this is a public list indexed by Google... Client's can search for your name... if the ones with no sense haha ;-) .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Robert Harrison

Re: CF9 Undelivr not working as expected

2011-03-14 Thread Russ Michaels
what SMTP server are you using ? try using something else as a test, such as your gmail account. If this refuses the invalid emails then this will prooce whether it is your mail server or not. On Mon, Mar 14, 2011 at 8:50 PM, Yuliang Ruan yuliangr...@hotmail.comwrote: If it is a valid

nested hierarchical query question

2011-03-14 Thread LRS Scout
I have a table departments with the fields departmentID, parentDepartmentID, departmentName. I'm trying to build a nested ul li structure out of this. Currently this can be nested n deep. I'm not sure how best to even approach this. SQL Server 2008. god this sounds dumb even to me.

RE: Data Truncation on TEXT field

2011-03-14 Thread Bobby Hartsfield
Even the ones** .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Monday, March 14, 2011 5:41 PM To: cf-talk Subject: RE: Data Truncation on TEXT field Enable Blob/Clob

Re: nested hierarchical query question

2011-03-14 Thread Judah McAuley
Are you looking for help on the db part or constructing the UI display or both? When it comes to the DB part, I listen to Joe Celko. That dude knows way more about databases and SQL than any person ought to. Here's an article of his on messing with hierarchical data in SQL:

Re: nested hierarchical query question

2011-03-14 Thread LRS Scout
Yeah man a recursive function is probably going to be the answer I've seen it done with directory structures I'm just having a brain cramp on how to make it work here. On Mon, Mar 14, 2011 at 7:17 PM, Judah McAuley ju...@wiredotter.com wrote: Are you looking for help on the db part or

Re: nested hierarchical query question

2011-03-14 Thread LRS Scout
http://www.dougboude.com/blog/1/2006/06/Recursive-Functions-in-ColdFusion.cfm This has been useful. On Mon, Mar 14, 2011 at 7:20 PM, LRS Scout lrssc...@gmail.com wrote: Yeah man a recursive function is probably going to be the answer I've seen it done with directory structures I'm just

RE: cf jquery mobile

2011-03-14 Thread andy matthews
Without seeing code I couldn't be sure what was wrong, but jQuery Mobile is quite particular about pathing. My guess is that some of the script files aren't loading. Hit your site with Firefox (with Firebug turned on) and see if the javascript files needed for cfform are loading. andy

Re: cf jquery mobile

2011-03-14 Thread Raymond Camden
I would also _strongly_ urge you not to mix CF's built in JS stuff with any other JS framework. You can do it - but most of the time it leads to trouble. If you are experienced enough to be working with JQM, you probably do not need the built-in CF client side form validation. Use a good jQuery

Re: cf jquery mobile

2011-03-14 Thread Azadi Saryev
+1 to Ray Another thing to consider is: do you really want to add 500+Kb of scripts loaded when you use cfform tag (or any other cf's built-in ajax features) to your MOBILE site? Azadi On 15/03/2011 09:07 , Raymond Camden wrote: I would also _strongly_ urge you not to mix CF's built in JS

RE: cf jquery mobile

2011-03-14 Thread andy matthews
+1 -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Monday, March 14, 2011 8:07 PM To: cf-talk Subject: Re: cf jquery mobile I would also _strongly_ urge you not to mix CF's built in JS stuff with any other JS framework. You can do it - but most of the time

Website for Health Care Center

2011-03-14 Thread sandeep saini
I plan to create a website for a health care center(physical therapy). The client wants to store patients data, their day to day measurements(excercises,weights, strengths etc). I am afraid storing all this info on some outsite hosting company(server). So just thinking to put code

Re: Website for Health Care Center

2011-03-14 Thread Phillip Vector
Personally, I would stay FAR away from that requirement. Either that or have the client sign something that says that if the laptop gets taken, you aren't responsible for any data that was on it. On Mon, Mar 14, 2011 at 7:57 PM, sandeep saini sandeep00...@yahoo.com wrote: I plan to create a

Re: Website for Health Care Center

2011-03-14 Thread Phillip Duba
HIPAA is your friend here and will guide you down the path of telling them no, that is not allowable unless certain measures are taken (authentication onto the machines, encrypted hard drives, etc.), Phil On Mon, Mar 14, 2011 at 10:57 PM, sandeep saini sandeep00...@yahoo.comwrote: I plan to

Re: Website for Health Care Center

2011-03-14 Thread Maureen
Assuming this client is in the US, it would be smarter to find a host whose facility is already HiPAA compliant like Firehost.com or Connectria.com http://en.wikipedia.org/wiki/HIPAA On Mon, Mar 14, 2011 at 7:57 PM, sandeep saini sandeep00...@yahoo.com wrote: I plan to create a website for a

Re: CF9 CreateObject() Maps From Current Directory First?

2011-03-14 Thread Matt Quackenbush
And the answer is Apparently this is a bug in CF9. Under CF8, it works as expected. CF9? Nopers. Not even a mapping did the trick. Very strange. Will be filing a bug report. ~| Order the Adobe Coldfusion Anthology