Long Text / Unicode Message using SMPP

2008-06-10 Thread Jignesh Kakkad
Dear All, Just wanted to know if any one knows how to Send Long Unicode/ Text Message using SMPP? I have got UDH for the same but not sure in format i need to submit to SMPP server? Thanking you all in advance looking forward for your reply regards Jignesh Kakkad 919886897224 ~

cffile upload temporary folder changes

2008-06-10 Thread James Holmes
I predict this is another stumper. Occasionally, on one of our servers, the temporary folder into which cffile uploads go before they are moved to the final location changes from the correct cf_root/runtime/servers/coldfusion/SERVER-INF/temp/wwwroot-tmp/ to /var/tmp. Has anyone else experienced t

Re: Importing Lists with empty values

2008-06-10 Thread Les Mizzell
Raymond Camden wrote: > Don't forget CF8 modified ListToArray so you can detect empty items in a list. Yea - as soon as I get my freaking client to upgrade!!! Still stuck with CF7! ~| Adobe® ColdFusion® 8 software 8 is the most

Re: Importing Lists with empty values

2008-06-10 Thread Raymond Camden
Don't forget CF8 modified ListToArray so you can detect empty items in a list. On Tue, Jun 10, 2008 at 5:19 PM, Brad Wood <[EMAIL PROTECTED]> wrote: > http://www.cflib.org/index.cfm?event=page.udfbyid&udfid=507 > for starters > > Alternatively you could do a manual replace to replace every instanc

RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Rick Faircloth
Thanks for the info, Jim...sounds great! I'll check it out! Rick > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2008 5:53 PM > To: CF-Talk > Subject: RE: One thing I've always wanted to build... breadcrumb trail... > > > -Original Message-

Re: CF thinks 0F is boolean.

2008-06-10 Thread denstar
On Tue, Jun 10, 2008 at 6:16 PM, Brad Wood <[EMAIL PROTECTED]> wrote: > Definitely no regex-- mostly attempts to parse as a double etc, and some > string manipulation. I can watch the variables as they go by, but I > obviously can't see the actual Java code with the exception of when it > dip

Re: Need some advice on approach...

2008-06-10 Thread s. isaac dealey
> Thanks for the wildcard idea, Isaac... that definitely sounds better! Welcome. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8

RE: Can't create Verity collections

2008-06-10 Thread Frank
At 06:05 PM 2008-06-09, you wrote: >Is the verity engine enabled? By default it is not enabled in CF8 and >you have to run a command line utility. It should be, when I run a cfcollection tag or ask verity to create the collection via the CF admin, it tries, but it presents me with an error. So

RE: CF thinks 0F is boolean.

2008-06-10 Thread Brad Wood
Hmm, this isn't much, but when you step through an isboolean("0f ") function in a debugger, this is a _rough_ list of Java methods that get called (several of these get called many times in a row). Definitely no regex-- mostly attempts to parse as a double etc, and some string manipulation. I can

Re: Application.cfc variables

2008-06-10 Thread Barney Boisvert
the 'this' scope corresponds to the CFAPPLICATION tag, not the application scope. If you want to set stuff into the application scope you have to use it literally. A concrete example: setting this.name is equivalent to passing the NAME attribute to CFAPPLICATION, which in turn is available as the

Application.cfc variables

2008-06-10 Thread Alex Pogodin
Hi everyone! Can somebody explain me why assigning a value to This.Blah inside Application.cfc doesn't affect Application struct itself. Doesn't Application.cfc represent an application scope? if so, why assigning this.name inside cfc affects Application. and one more related question: do I ne

Re: CF thinks 0F is boolean.

2008-06-10 Thread Adam Haskell
Good point. on both accounts :-P Adam Haskell On Tue, Jun 10, 2008 at 6:39 PM, Jim Davis <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Adam Haskell [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, June 10, 2008 5:34 PM > > To: CF-Talk > > Subject: Re: CF thinks 0F is boolean.

RE: CF thinks 0F is boolean.

2008-06-10 Thread Jim Davis
> -Original Message- > From: Adam Haskell [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2008 5:34 PM > To: CF-Talk > Subject: Re: CF thinks 0F is boolean. > > 0A is a line feed (pretty sure on this) which is certainly not boolean. > I > have no idea what 0F is though I thought it had

RE: CF thinks 0F is boolean.

2008-06-10 Thread Jim Davis
> -Original Message- > From: Fred Anderson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2008 5:31 PM > To: CF-Talk > Subject: Re: CF thinks 0F is boolean. > > A more simplified example would be: > > #isBoolean("0F ")# > > Additionally '0D' has the same effect. I think you may fin

RE: Importing Lists with empty values

2008-06-10 Thread Brad Wood
http://www.cflib.org/index.cfm?event=page.udfbyid&udfid=507 for starters Alternatively you could do a manual replace to replace every instance of || with |some reserved word that you will interpret as blank| Just make sure you do the replace twice so "firstname|||address|other" will work as well.

Re: Importing Lists with empty values

2008-06-10 Thread Barney Boisvert
replace "|" with " | " (that's space-pipe-space), do your parse, and then trim everything coming out of it. cheers, barneyb On Tue, Jun 10, 2008 at 3:18 PM, Les Mizzell <[EMAIL PROTECTED]> wrote: > I've set up a function for a client to import lists of email addresses > from "|" delimeted files g

Importing Lists with empty values

2008-06-10 Thread Les Mizzell
I've set up a function for a client to import lists of email addresses from "|" delimeted files generated from Excel spreadsheets. There's a specific format that they always use: firstname|lastname|emailaddress|other No problems. The code below works fine: -

RE: CF thinks 0F is boolean.

2008-06-10 Thread Brad Wood
Man, I wish we could examine the source code on this kind of stuff. When I do a bunch of isboolean's SeeFusion's stack trace sees a lot of coldfusion.runtime.CFDouble.parseDouble and java.lang.FloatingDecimal.readJavaFormatString going on, but there must obviously be some more there that doesn't t

Extending ColdFusion 8 servemonitoring.cfc

2008-06-10 Thread Andy Matthews
Is it possible to extend the servermonitoring cfc? I'm writing a POC app and I thought it would be a simple thing to extend the SM.cfc so that I wouldn't have to write the methods myself. Also, that I wouldn't have to bother creating the object. Just wanted to check if it's possible because I'm

RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Jim Davis
> -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Monday, June 09, 2008 11:54 PM > To: CF-Talk > Subject: One thing I've always wanted to build... breadcrumb trail... > > Not the one that represents a folder structure or > hierarchy, but shows the exact places v

Re: CF thinks 0F is boolean.

2008-06-10 Thread Adam Haskell
0A is a line feed (pretty sure on this) which is certainly not boolean. I have no idea what 0F is though I thought it had some significance like terminator or something. Adam Haskell On Tue, Jun 10, 2008 at 5:20 PM, Brian Kotek <[EMAIL PROTECTED]> wrote: > True, but 0A is also hex and it still

Re: CF thinks 0F is boolean.

2008-06-10 Thread Wil Genovese
I just tried this with Blue Dragon JX and I get the desired results. http://labs.trunkful.com/isitBoolean.cfm Also, I check other hex values and found that "0D " also comes back as a boolean. ALso if you just have the string "0F " ( that is Zero Ef Space") you get true for boolean. Odd.

Re: CF thinks 0F is boolean.

2008-06-10 Thread Fred Anderson
A more simplified example would be: #isBoolean("0F ")# Additionally '0D' has the same effect. Fred > I have run into an issue with cold fusion, > When I try to concatenate the string '0F' & ' ' I get a value that > passes isBoolean(). > While this works with any number of leading zeros it does n

Re: CF thinks 0F is boolean.

2008-06-10 Thread Brian Kotek
True, but 0A is also hex and it still returns false for isBoolean. On Tue, Jun 10, 2008 at 5:13 PM, Adam Haskell <[EMAIL PROTECTED]> wrote: > Hexadecimal :) > > > Adam Haskell > > > On Tue, Jun 10, 2008 at 5:00 PM, Fred Anderson <[EMAIL PROTECTED]> > wrote: > > > I have run into an issue with col

Re: CF thinks 0F is boolean.

2008-06-10 Thread Adam Haskell
Hexadecimal :) Adam Haskell On Tue, Jun 10, 2008 at 5:00 PM, Fred Anderson <[EMAIL PROTECTED]> wrote: > I have run into an issue with cold fusion, > When I try to concatenate the string '0F' & ' ' I get a value that passes > isBoolean(). > While this works with any number of leading zeros it d

CF thinks 0F is boolean.

2008-06-10 Thread Fred Anderson
I have run into an issue with cold fusion, When I try to concatenate the string '0F' & ' ' I get a value that passes isBoolean(). While this works with any number of leading zeros it does not work with any other value besides 'F'. Additionally it only works when you try to append a ' ' space to i

RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
> Ok I changed Root URL: to http://127.0.0.1/ and to > http://localhost:8500/ and changed context root: to / and > added the project directory to IIS. Still won’t display, > any other thoughts? What is the URL to your swf? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.co

Re: Money datatype in SQL Server

2008-06-10 Thread Jochem van Dieten
Retry, and hopefully the charset stuff now works. Make sure you read this message as UTF-8 (the list still strips the charset from the content-type header). Charlie Griefer wrote: > There are some people here who suggest that it makes the database more > self documenting, and I don't disagree wi

Re: Money datatype in SQL Server

2008-06-10 Thread Jochem van Dieten
Make sure you read this message as UTF-8 (the list still strips the charset from the content-type header). Charlie Griefer wrote: > There are some people here who suggest that it makes the database more > self documenting, and I don't disagree with that... but if there are > indeed accuracy iss

Re: cfoutput

2008-06-10 Thread Charlie Griefer
I believe this is (and has been) true. put the conditional outside. #variables.i#, not found #variables.i#, #getShots.Filename#, #getShots.JID#, #getShots.status# On Tue, Jun 10, 2008 at 10:33 AM, Chad Gray <[EMAIL PROTECTED]> wrote: > If I use cfoutput with query="

Re: Money datatype in SQL Server

2008-06-10 Thread Charlie Griefer
On Tue, Jun 10, 2008 at 10:34 AM, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Charlie Griefer wrote: >> Is there any "bottom line" recommendation on using the Money datatype >> in SQL Server? I've googled and found a lot of folks say not to use >> it because of accuracy issues (and of course, t

Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
Ok I changed Root URL: to http://127.0.0.1/ and to http://localhost:8500/ and changed context root: to / and added the project directory to IIS. Still won’t display, any other thoughts? ~| Adobe® ColdFusion® 8 softwar

Re: Money datatype in SQL Server

2008-06-10 Thread Jochem van Dieten
Charlie Griefer wrote: > Is there any "bottom line" recommendation on using the Money datatype > in SQL Server? I've googled and found a lot of folks say not to use > it because of accuracy issues (and of course, the fact that it's > proprietary), but I haven't seen any that suggest a better > alt

cfoutput

2008-06-10 Thread Chad Gray
If I use cfoutput with query="foo" and the queries record count is 0. The CFoutput is not stepped into. Has this always been true? I have some code like this and noticed that I never returned the "NOT FOUND" statement because if the recordcount is zero the cfoutput is skipped over.

Re: [CF-Dev] WDDX<->JSON plugin for jQuery ?

2008-06-10 Thread Carl Von Stetten
Peter, Have you considered skipping WDDX and going straight to JSON? If not, check out both AJAXCFC and JSON.CFC. Carl [EMAIL PROTECTED] wrote: > A bit more background info. might be good but have you looking at AJAXCFC? > > The Robert Gordon University, a Scottish charity registered under cha

Re: Word document generation (header, footer, page numbering)

2008-06-10 Thread denstar
On Tue, Jun 10, 2008 at 6:26 AM, Loathe <[EMAIL PROTECTED]> wrote: > There are several well known ways of generating word documents, xml, > html with cfcontent/header, and I hear POI although I haven't used it. > > I have a need to be able to create a word document and do page > numbering, and have

RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
> Is there something I new to set up in iis like an virtual > directory, and proporties os set as follows > > Root Folder - C:\ColdFusion8\wwwroot > Root URL: - http://l127.0.0.1/ > Context root - wwwroot The root URL is wrong, and the context root would be "/" by default. Dave Watts, CTO, Fig

Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
Ok, I got past that error, Now I get. Internet Explorer cannot display the webpage Most likely causes: You are not connected to the Internet. The website is encountering problems. There might be a typing error in the address. What you can try: Diagnose Connection Problems

Re: Money datatype in SQL Server

2008-06-10 Thread Charlie Griefer
hmm... this was the page i saw that seemed to strongly suggest that the money datatype could be problematic in terms of accuracy (even provided sample SQL to run in query analyzer to see the results): http://tinyurl.com/6fh8hl On Tue, Jun 10, 2008 at 9:55 AM, Jacob <[EMAIL PROTECTED]> wrote: > We

RE: Money datatype in SQL Server

2008-06-10 Thread Jacob
Well... I use the money datatype in SQL server for our prices. I have had not issues. When we output, we use #dollarformat(queryname.price)#. Works for what we do. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2008 9:23 AM To: CF-Talk Subjec

RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
> Though you can probably just use the --services compiler > argument to point at a services-config.xml file instead, right ? > That's what we do for Flash Remoting. Yeah, that's really what happens when you define your Flex Builder project to use LCDS or Remoting. Dave Watts, CTO, Fig Leaf Soft

Re: Multi-dimentions Arrays

2008-06-10 Thread Charlie Griefer
i did a 3 part tutorial on arrays and structures that might be of some help. http://tutorial171.easycfm.com/ http://tutorial172.easycfm.com/ http://tutorial173.easycfm.com/ check 'em out and see if they help wrap your brain around the concepts. On Tue, Jun 10, 2008 at 7:04 AM, Kamru Miah <[EMAIL

Money datatype in SQL Server

2008-06-10 Thread Charlie Griefer
Is there any "bottom line" recommendation on using the Money datatype in SQL Server? I've googled and found a lot of folks say not to use it because of accuracy issues (and of course, the fact that it's proprietary), but I haven't seen any that suggest a better alternative. My understanding is th

Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Matt Williams
On Tue, Jun 10, 2008 at 10:51 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Thanks, Matt... sounds similar to what I was thinking about doing. > > Question: What do you mean by "window numbers"? Some of our links open a new browser window or tab. If this happens and they started using links in

RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Rick Faircloth
Thanks, Matt... sounds similar to what I was thinking about doing. Question: What do you mean by "window numbers"? Rick > -Original Message- > From: Matt Williams [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2008 9:53 AM > To: CF-Talk > Subject: Re: One thing I've always wanted t

Re: RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Once again disregard, I figured it out. A hello world with RtfWriter2: paths = arrayNew(1); /* This points to the jar we want to load. Could also load a directory of .class files */ paths[1] = expandPath("iText-2.1.2u.jar"); paths[2] = e

Re: RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Moving on: I have: paths = arrayNew(1); /* This points to the jar we want to load. Could also load a directory of .class files */ paths[1] = expandPath("iText-2.1.2u.jar"); paths[2] = expandPath("iText-rtf-2.1.2u.jar"); //creat

Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Jerry Johnson
No, a worse idea, but it is already done for you (laziest approach) On Tue, Jun 10, 2008 at 12:05 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Ooohhh... I knew someone was going to say the word 'javascript'. > > Is it really so much better to use js (with which I'm not so good) > than a CF s

Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Tom Chiverton
On Tuesday 10 Jun 2008, Dave Watts wrote: > > In the file properties under Flex Server it says "Sience this > > project dose not use a server, these settings do not apply. > To use LCDS functionality, your project has to define a server. Though you can probably just use the --services compiler arg

RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
> In the file properties under Flex Server it says "Sience this > project dose not use a server, these settings do not apply. To use LCDS functionality, your project has to define a server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber

Re: RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Disregard. It's com.lowagie.text.rtf.RtfWriter2 Loathe wrote: > Whats the correct path to the RtfWriter2 class? > > I thought it would be com.lowagie.text.RtfWriter2 but it can't find > that, I have googled all over the place for it. I've created the > document object now I need to pass that

RtfWriter2 was (Re: Word document generation (header, footer, page numbering))

2008-06-10 Thread Loathe
Whats the correct path to the RtfWriter2 class? I thought it would be com.lowagie.text.RtfWriter2 but it can't find that, I have googled all over the place for it. I've created the document object now I need to pass that to RtfWriter2.getInstance() but can't seem to instantiate a RtfWriter2 ob

Re: Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
ColdFusion started fine. In the file properties under Flex Server it says "Sience this project dose not use a server, these settings do not apply. Any Ideas ~| Adobe® ColdFusion® 8 software 8 is the most important and dramat

RE: Coldfusion 8 and Flex 2

2008-06-10 Thread Dave Watts
> I am trying to configure messaging-config.xml file to talk to > a flex application. The flex application keeps telling me > “'Unknown destination”. Doe’s anyone have any Ideas? First, make sure that your server configuration is correct. You can easily d

Re: cfthread with a cffile upload

2008-06-10 Thread George Abraham
Chad, As an aside, we went down many routes for large file uploads. HTTP is simply not built for that. We finally went with an embedded FTP Java client that simplified our lives a great deal. For reference, we went with this one: http://www.utechsoft.com/products/uupload/webdemo/cart/ HTH, George

Multi-dimentions Arrays

2008-06-10 Thread Kamru Miah
Hi, I am new to developing code with multi-dimensional arrays (or structures). Could someone please advise me how to implement the following 4-level loops to store the financial values (for outputting at a later stage)? --- Loop by projNo Loop by finYear Loop by account type (4 types)

Re: alternatives to cfcontent to allow large downloads

2008-06-10 Thread Gerald Guido
Actually the presentation is on this page: http://coldfusion.meetup.com/17/calendar/6620698/?from=list&offset=30 Good stuff G On Tue, Jun 10, 2008 at 9:37 AM, Gerald Guido <[EMAIL PROTECTED]> wrote: > I have been looking at there stuff for a while for a my next dot bomb. > > >> Barney seems to

Re: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Matt Williams
I have a breadcrumb solution that I created for a Mach-II app. You could probably pull out relevant parts of the code and use it in Application.cfm. At one point I attempted to make it "window aware" so that if a link spawned a new window or tab, it would keep track of that. I don't think this par

Re: alternatives to cfcontent to allow large downloads

2008-06-10 Thread Gerald Guido
I have been looking at there stuff for a while for a my next dot bomb. >> Barney seems to like it a lot, but are there any major gotchas? Their set up is very cool. There are no major gotchas that I have seen to date. There are a couple of wrappers on RIAforge for using there service. Here is ano

Re: alternatives to cfcontent to allow large downloads

2008-06-10 Thread George Abraham
> > Instead of using CFCONTENT, you can use CF to create a temporary URL, then > let your web server serve the file directly. For example, you could use > CFEXECUTE to create a symlink to a directory containing the file, then > after > an hour (or whatever time you deem appropriate) you could delet

RE: One thing I've always wanted to build... breadcrumb trail...

2008-06-10 Thread Rick Faircloth
Thanks for the ideas and feedback, everyone...I'll check it all out! Rick > -Original Message- > From: William Seiter [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2008 2:48 AM > To: CF-Talk > Subject: RE: One thing I've always wanted to build... breadcrumb trail... > > I would use

Re: Word document generation (header, footer, page numbering)

2008-06-10 Thread Loathe
Thanks a lot, I'll jump into it now. Paul Hastings wrote: > Loathe wrote: >> I have a need to be able to create a word document and do page >> numbering, and have access to the header and footer to add letterhead >> and document classification information. I'm wondering if anyone can >> point

Coldfusion 8 and Flex 2

2008-06-10 Thread Keith McGee
I am trying to configure messaging-config.xml file to talk to a flex application. The flex application keeps telling me “'Unknown destination”. Doe’s anyone have any Ideas? Error Message [MessagingError message='Unknown destination 'ColdFusionGateway'.'] at mx.messaging.config::Se

Re: Word document generation (header, footer, page numbering)

2008-06-10 Thread Paul Hastings
Loathe wrote: > I have a need to be able to create a word document and do page > numbering, and have access to the header and footer to add letterhead > and document classification information. I'm wondering if anyone can > point me towards a solution that does this other than CF Report Builder

Re: How to change the properties of a column on an Oracle Server?

2008-06-10 Thread Tom Chiverton
On Tuesday 10 Jun 2008, nic olai wrote: > But whats the corry syntax for usage on Oracle Server? Fairly similar. What does the Oracle documentation (hell, a swift google) say ? -- Tom Chiverton This email is sent for and on behalf of Halliw

How to change the properties of a column on an Oracle Server?

2008-06-10 Thread nic olai
Hi all, how can i change the properties of a column on an Oracle Server? With MySQL i can change it with: ALTER TABLE `mytable.mycolumn` CHANGE `mytable.mycolumn` `mytable.mycolumn` TEXT CHARACTER SET utf-8 COLLATE utf-8 NOT NULL But whats the corry syntax for usage on Oracle Server? Thank yo

Word document generation (header, footer, page numbering)

2008-06-10 Thread Loathe
There are several well known ways of generating word documents, xml, html with cfcontent/header, and I hear POI although I haven't used it. I have a need to be able to create a word document and do page numbering, and have access to the header and footer to add letterhead and document classific

Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
I seem to remeber someone doing dynamic datasources using jdbc connections and a little bit of Java. http://www.petefreitag.com/item/152.cfm has some ideas. I havent tried it but setting up 900 datasources has to be too much of a kind regards, Joel ~

Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
I seem to remeber someone doing dynamic datasources using jdbc connections and a little bit of Java. http://www.petefreitag.com/item/152.cfm has some ideas. I havent tried it but setting up 900 datasources has to be too much of a kind regards, Joel ~

Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
> Hey Everyone, > > This is more of a performance question. We have a client in the > securities industry for which we have built a client management system > in CFML, that enables our securities client to create fully managed > database solutions for each of their downstream clients. Due to

Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Joel Stobart
> Hey Everyone, > > This is more of a performance question. We have a client in the > securities industry for which we have built a client management system > in CFML, that enables our securities client to create fully managed > database solutions for each of their downstream clients. Due to

Re: Large Number of CF DSNs and SQL Performance Question

2008-06-10 Thread Tom Chiverton
On Tuesday 10 Jun 2008, JB Cameron wrote: > Technically we run 3 web servers load balanced for this client, so we are > really talking about 3 x 150 clients, or 450 connections to the SQL server, > growing to probably 900 in a year. Thoughts? Try it in your staging environment and see what happens

RE: [CF-Dev] WDDX<->JSON plugin for jQuery ?

2008-06-10 Thread j.c.buckingham
A bit more background info. might be good but have you looking at AJAXCFC? The Robert Gordon University, a Scottish charity registered under charity number SCO 13781. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, con

Re: Alarming

2008-06-10 Thread Tom Chiverton
On Monday 09 Jun 2008, Brian Kotek wrote: > cfqueryparam won't actually stop someone from entering XSS code into a text > field. It needs to be stripped out prior to insertion into the DB. Ahh, yes, client side problems would still be possible, you're right :-) -- '' Chiverton *

Re: ODBC vs JDBC MS-SQL Driver Question

2008-06-10 Thread Paul Hastings
JB Cameron wrote: > We are looking to optimize performance for a few client sites and many > optimization whitepapers have recommended using a Type IV JDBC driver for > MS-SQL server. What driver type of driver comes pre-built with with CFMX 7.0? cf already has a type 4 from data direct for sql se