Postgres, ColdFusion and Transactions
Hello! I've got the following problem: Commits seem to be executed in a deferred mode. An example: 1) DELETE some rows ... commit the transaction 2) SELECT rows ... the rows deleted in 1) are still displayed 3) After a reload of the page the rows of 1) have dissapeared I've already tried to add a cftransaction statement with isolation="read_uncommitted" to the SELECT statement but it does not help. Software: ColdFusion MX, Postgres 7.3 (debian stable release), JDBC driver for 7.3 Is this a known problem? Peter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Concatenate 2 binary variables
> This should do it: > > bos = createObject("java", "java.io.ByteArrayOutputStream").init(); > bos.write(binary_stuff,0,len(binary_stuff)); > bos.write(ender,0,len(ender)); > New_binary = bos.tobytearray(); > bos.close(); > > Probably a better way with the fileinputstream but I already had this > code so I figured I'd post if for ya. > > Adam H Thanks Adam, that worked really well. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Warning Page Expired problem
Hi, My client is facing 'Warning: Page Expired' problem when they click back button, i have put tag at the top of the page to cache it and it is working fine at my end, is there any other issues that need to be addressed?? thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Notebook recommendations
Yes, I have a Dell Inspiron 7500 and while I think it's a good laptop I need something more up to date. I was looking on some of the Dell forums and a lot of horror stories lately, both about th equality of the products and customer service. I had only one problem with my battery pack 2 months after I bought it and they sent me a new one, but this was 4 years ago :) I will look at IBM too. I had once a desktop IBM. It was good but too much proprietary stuff, at least than. I was king of looking to buy the Toshiba S1-QW6 Centrino 1.7GHz Notebook, because comes with Windows XP professional, 512 MB (one stick) RAM and 60GB (5400rpm, almost all others have the 4200 type) HD. It's not easy /regards Victor - Original Message - From: Simeon Bateman <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 17:15:22 -0700 Subject: Re: OT Notebook recommendations To: CF-Talk <[EMAIL PROTECTED]> I used to be a huge supported of Dell laptops, they have received about 35 purchases based on my recomendations to clients and friends. However in the last year I have switched my support to ibm and the think pad. Much better laptops. better built in features and more rugged than the dells. The seem to hold up better even those they are lighter and sleeker than their dell counterparts. Good Luck with the new laptop! sim - Original Message - From: Chris Johnston <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 17:45:48 -0400 Subject: Re: OT Notebook recommendations To: CF-Talk <[EMAIL PROTECTED]> On Tue, 31 Aug 2004 17:02:36 -0400, Victor Moore <[EMAIL PROTECTED]> wrote: > Sorry for the OT, but I am looking for a new laptop and I was > wondering if you guys have any preference or can make a > recommendation. > > I was able to narrow it down to the following: > Dell Inspiron 8600 > Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook > HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook > > It will be used mainly for some development and demos. > Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc I have the Dell Inspiron 1100 and have been very happy with it. The only suggestion that I would make is to get as much RAM in the notebook as possible. I would go with either 768 or 1024Megs of RAM. Anything less is not sufficient for running the above apps. -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Unicode Problem
I'm moving an application from CF 5 to CFMX... and I'm having a problem with some of my data. The database is PostgreSQL. How do I start tracking down the problem / fix it? Any tips? The error: Error Executing Database Query. Invalid character data was found. This is most likely caused by stored data containing characters that are invalid for the character set the database was created in. The most common example of this is storing 8bit data in a SQL_ASCII database. Thanks! -- Jillian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Removing extensions from filelists
Ewok scribbled Well, you live in a perfect world if your encouragement works! I need to know your secret! So noted and now covered ty - that was a very quick cold reminder that my perfect world is in fact as far from reality as yours (or thereabouts)! Regards MarkH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Removing extensions from filelists
* Your message is a reply to anothers post and is more than 100 lines of text. Unless you are a major writer, your probably adding a lot of the previous * replies. Please trim your posts when replying. Thank you. Well, you live in a perfect world if your encouragement works! I need to know your secret! In the event that it doesnt work cover it anyway ""), ".", "_", "ALL") & "." & ListLast(FileName, ".")> #FileName# This will turn some.dumb.file.exe into some_dumb_file.exe _ From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 7:13 PM To: CF-Talk Subject: RE: Removing extensions from filelists Thanks to both Pascal and Ewok (and pardon the delay in responding. I've been out of the office). I also I must've missed your response detailing regexp as a solution Pascal, but I'm looking it up now. Til then I'm using Ewoks solution since it seems to be working fine (no dots in filenames). I encourage most of our users to go with underscores as opposed to dots or spaces when naming their files. Regards Mark Henderson Web Designer mailto:[EMAIL PROTECTED] 205 Main Street PO Box 143, Gore Southland 9700 Phone: (03) 203 Fax: (03) 203 9900 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ODBC vs JDBC sql syntax differences
On Tue, 31 Aug 2004 20:49:55 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > And Isaac, I won't damn you. ;) > > Mighty kind of you Dave. :) > > Although ... I'm not sure about Oracle, but I know that with SQL > Server you can (maybe not with all JDBC drivers, but I'm pretty sure I > have with at least one) use more than one sql statement in a single > cfquery without the semicolons. I hadn't noticed that semicolons had > changed -- though that may also depend on the individual JDBC > driver... I remember having some show-stopper problems when I tried to > use cfqueryparam with the Merant drivers for Oracle that shipped with > CFMX, although I was developing and testing locally with the JDBC > drivers from Oracle and having no problems. Unfortunately in my case > the client didn't go for using the Oracle drivers even though I > believe they're superior in just about every respect. I think there > was a later hotfix for the cfqueryparam issue. > I can't speak for SQL Server as we don't use it and I don't have access to an installation of it to check. But my experience was using the packaged drivers that come with ColdFusion against an Oracle 8.1.7 database. And, again, I was going from ODBC drivers on CF 4.5 to JDBC drivers on CFMX, so the ODBC implementation with CFMX might be different and my experience irrelevant. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ODBC vs JDBC sql syntax differences
> And Isaac, I won't damn you. ;) Mighty kind of you Dave. :) Although ... I'm not sure about Oracle, but I know that with SQL Server you can (maybe not with all JDBC drivers, but I'm pretty sure I have with at least one) use more than one sql statement in a single cfquery without the semicolons. I hadn't noticed that semicolons had changed -- though that may also depend on the individual JDBC driver... I remember having some show-stopper problems when I tried to use cfqueryparam with the Merant drivers for Oracle that shipped with CFMX, although I was developing and testing locally with the JDBC drivers from Oracle and having no problems. Unfortunately in my case the client didn't go for using the Oracle drivers even though I believe they're superior in just about every respect. I think there was a later hotfix for the cfqueryparam issue. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ODBC vs JDBC sql syntax differences
On Tue, 31 Aug 2004 17:00:34 -0400, Samuel R. Neff <[EMAIL PROTECTED]> wrote: > Are there differences in SQL/functions when moving from an ODBC datasource > to a JDBC datasource? > > We're hosting an application for another contractor and their app is the > only one using ODBC (all apps use Oracle). We'd like to remove the ODBC > services (well, we're setting up a brand new box and would like to do so > without ODBC) but they claim that it's a big hassle for them to change their > app to use JDBC instead of ODBC. When we've migrated apps in the past (many > of which are considerably larger) we never had to change any SQL as long as > the back-end database was the same. > There are a couple of differences that come to mind based on some code I inherited back when we were migrating an app from CF 4.5 to CFMX. The drivers on CF 4.5 were using the ODBC drivers, and it may or may not apply to CFMX's ODBC implementation. Nonetheless, I figured I'd throw it out there: 1) You cannot end your queries with a semi-colon, i.e. SELECT sysdate FROM dual; There were a bunch of querie like that in the code, and I'm assuming that it was because the previous developer copied and pasted from SQL Plus directly into the cfquery tag. 2) You can't have multiple SQL statements (that I'm aware of) in the same cfquery tag (mainly because of #1 above), i.e., UPDATE myTable SET myColumn = myValue WHERE myKey = myKeyID; SELECT COUNT(*) FROM myTable WHERE myKey = myKeyID Again, I'm not suggesting that the above is good coding practices, but you can't help what you inherit and I noticed you said it was a contractor's app. And Isaac, I won't damn you. ;) Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: fyi
> Sorry everyone. No wonder my manager wondered why I left > today. LOL > Had a few email windows open and got typing in the wrong > one. > Please disregard. > Mike Good thing that was a work-related email and not something intended for say... a fetish forum. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: For S.Isaak - onTap SES
> Hi S. Isaak > it's possible to use OnTap framework works with SES > procedures? > Cheers Likely... you're lucky, I almost missed this message 'cause I normally filter anything with "isaac" in it into my inbox (instead of my list-mail folder)... Anyway, yes, you'd want to apply your SES adaptation in the /_components/_appsettings.cfm template or possibly the application stage (although setting them in the application stage wouldn't be compatible with a netaction variable in the url because it has to be applied before the application stage to determine which application templates to execute) but once you have it in your _appsettings.cfm template I don't see why it wouldn't work just the same... fyi -- in case you hadn't seen it yet, there's a forum for the framework on the site now at http://www.fusiontap.com/forum - which should eliminate the risk of me missing the message in my list-mail. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Notebook recommendations
I've been happy with my Gateway notebook as well as my Apple Powerbook. I can also recommend the IBM Thinkpad line; they are built really well but tend to be a bit more pricey. Matt On Tue, 31 Aug 2004 17:02:36 -0400, Victor Moore <[EMAIL PROTECTED]> wrote: > Sorry for the OT, but I am looking for a new laptop and I was > wondering if you guys have any preference or can make a > recommendation. > > I was able to narrow it down to the following: > Dell Inspiron 8600 > Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook > HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook > > It will be used mainly for some development and demos. > Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc > > Thanks > Victor > PS if you have any suggestions please let me know > If other people are not interested in it you can send them privately > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Removing extensions from filelists
Well, you live in a perfect world if your encouragement works! I need to know your secret! In the event that it doesnt work cover it anyway ""), ".", "_", "ALL") & "." & ListLast(FileName, ".")> #FileName# This will turn some.dumb.file.exe into some_dumb_file.exe _ From: Mark Henderson [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 7:13 PM To: CF-Talk Subject: RE: Removing extensions from filelists Thanks to both Pascal and Ewok (and pardon the delay in responding. I've been out of the office). I also I must've missed your response detailing regexp as a solution Pascal, but I'm looking it up now. Til then I'm using Ewoks solution since it seems to be working fine (no dots in filenames). I encourage most of our users to go with underscores as opposed to dots or spaces when naming their files. Regards Mark Henderson Web Designer mailto:[EMAIL PROTECTED] 205 Main Street PO Box 143, Gore Southland 9700 Phone: (03) 203 Fax: (03) 203 9900 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 1:19 AM To: CF-Talk Subject: RE: Removing extensions from filelists This will work in most cases, but not if there is a dot in the filename. The easiest way to remove the extension is using the regexp I posted. List functions will give problems in some cases. Pascal > -Original Message- > From: Ewok [mailto:[EMAIL PROTECTED] > Sent: 30 August 2004 13:15 > To: CF-Talk > Subject: RE: Removing extensions from filelists > > > > > > > > #replace(listFirst(name, "."), "_", " ", "ALL")# > > > > _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:176663"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=35" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Notebook recommendations
I have had 3 Inspirons over the past few years (2 from work,a nd one personal) and I can't say enough about them. I love mine, which is an 8500. Just my $0.02. - Original Message - From: Victor Moore <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 17:02:36 -0400 Subject: OT Notebook recommendations To: CF-Talk <[EMAIL PROTECTED]> Sorry for the OT, but I am looking for a new laptop and I was wondering if you guys have any preference or can make a recommendation. I was able to narrow it down to the following: Dell Inspiron 8600 Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook It will be used mainly for some development and demos. Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc Thanks Victor PS if you have any suggestions please let me know If other people are not interested in it you can send them privately [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: fyi
Sorry everyone. No wonder my manager wondered why I left today. LOL Had a few email windows open and got typing in the wrong one. Please disregard. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Notebook recommendations
I used to be a huge supported of Dell laptops, they have received about 35 purchases based on my recomendations to clients and friends. However in the last year I have switched my support to ibm and the think pad. Much better laptops. better built in features and more rugged than the dells. The seem to hold up better even those they are lighter and sleeker than their dell counterparts. Good Luck with the new laptop! sim - Original Message - From: Chris Johnston <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 17:45:48 -0400 Subject: Re: OT Notebook recommendations To: CF-Talk <[EMAIL PROTECTED]> On Tue, 31 Aug 2004 17:02:36 -0400, Victor Moore <[EMAIL PROTECTED]> wrote: > Sorry for the OT, but I am looking for a new laptop and I was > wondering if you guys have any preference or can make a > recommendation. > > I was able to narrow it down to the following: > Dell Inspiron 8600 > Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook > HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook > > It will be used mainly for some development and demos. > Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc I have the Dell Inspiron 1100 and have been very happy with it. The only suggestion that I would make is to get as much RAM in the notebook as possible. I would go with either 768 or 1024Megs of RAM. Anything less is not sufficient for running the above apps. -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT Notebook recommendations
Ive pretty happy with my Area51m from Alienware. My only complaint about it is that the internal wireless card blows (even for an internal wireless card), but a Linksys wusb54gp fixed that problem. Alienware support has also been better than great in my opinion. _ From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 5:03 PM To: CF-Talk Subject: OT Notebook recommendations Sorry for the OT, but I am looking for a new laptop and I was wondering if you guys have any preference or can make a recommendation. I was able to narrow it down to the following: Dell Inspiron 8600 Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook It will be used mainly for some development and demos. Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc Thanks Victor PS if you have any suggestions please let me know If other people are not interested in it you can send them privately _ [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:176646"This Message] [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings] [HYPERLINK "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation s and Support] _ HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=34" \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Opening Common Intranet files
I'm not sure if this is possible (but I'm really hoping). Currently on our intranet (which is on an IP) there is one person who frequently accesses common word and excel files to update (for pricing and such) . Since they are MS products and we browse using IE, these files open inside IE, which is fine. But once the changes are made, clicking the back button prompts the user to save changes (this is also fine). However, when the user selects 'yes' they are automatically shown a popup browse window so they can select where to store the file (by default it starts on the c drive). I don't want this to happen. If the user is in a doc file editing on http://192.168.2.1/intranet/files/hardwareorder.doc I want this overwritten automatically when they click the yes button to save it in that location. Permissions are not a problem bcos I can simply browse to the same place and then save as good as gold. This may be the wrong approach, so my next question would be - is it possible to open the file in the correct associated program by launching it (i.e. doc files launch word for editing) and would this solve the problem? Also, if a particular file is open what's the best approach to flag this for other users so they're aware? Regards MarkH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Proc output params with CFMX 6.1
That is probably what I will end up doing, but I have had other issues with that driver. I am just trying to decide which one has the fewest number of issues! >> I am runnig CFMX6.1 on Solaris and I have a stored procedure > >I'm not especially familiar with the DataDirect driver for Sybase, but if >the vendor's own driver does what you want, why not just use that instead? > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
For S.Isaak - onTap SES
Hi S. Isaak it's possible to use OnTap framework works with SES procedures? Cheers [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF -> Javascript variables
Thanx Patrick, I finaly got it to work: I put the CF variables in an Then I used JS to get these values Regards - Frank From: Patrick Whittingham [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 6:45 PM To: CF-Talk Subject: Re: CF -> _javascript_ variables Can't you use the innerHTML instead? Pat
x.innerHTML="3432432432";
- Original Message - From: Frank Dewey <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 13:13:53 -0500 Subject: CF -> _javascript_ variables To: CF-Talk <[EMAIL PROTECTED]> Wrong subject From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 1:10 PM To: CF-Talk Subject: RE: CFQuery Hello all, In my page, clicking on a name brings up another window where you can edit their information (their address is shown below their name). The addressID for each address is also stored in a variable (addressIDList). Clicking on a button gets the the current information from the database - the processing is done in an iframe and addressIDList is passed in the URL. I would like to have _javascript_ write this new information to the screen. I do not want the entire screen to be reloaded though, just certain information. The proper text is surounded by (for the city and state text): ... ... ... Everything works like it should except that I cannot get _javascript_ to update the page because of some syntax errors. I am trying to use JS.innertext to write the new information (i.e. for the city):
parent['city'+#addressid#].innerText =
#evaluate(city&addressid)#;
...
What is wrong with this syntax? What should it be instead? I appreciate any help... Thank you - Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF -> Javascript variables
Can't you use the innerHTML instead? Pat
x.innerHTML="3432432432";
- Original Message - From: Frank Dewey <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 13:13:53 -0500 Subject: CF -> _javascript_ variables To: CF-Talk <[EMAIL PROTECTED]> Wrong subject From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 1:10 PM To: CF-Talk Subject: RE: CFQuery Hello all, In my page, clicking on a name brings up another window where you can edit their information (their address is shown below their name). The addressID for each address is also stored in a variable (addressIDList). Clicking on a button gets the the current information from the database - the processing is done in an iframe and addressIDList is passed in the URL. I would like to have _javascript_ write this new information to the screen. I do not want the entire screen to be reloaded though, just certain information. The proper text is surounded by (for the city and state text): ... ... ... Everything works like it should except that I cannot get _javascript_ to update the page because of some syntax errors. I am trying to use JS.innertext to write the new information (i.e. for the city):
parent['city'+#addressid#].innerText =
#evaluate(city&addressid)#;
...
What is wrong with this syntax? What should it be instead? I appreciate any help... Thank you - Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Removing extensions from filelists
Thanks to both Pascal and Ewok (and pardon the delay in responding. I've been out of the office). I also I must've missed your response detailing regexp as a solution Pascal, but I'm looking it up now. Til then I'm using Ewoks solution since it seems to be working fine (no dots in filenames). I encourage most of our users to go with underscores as opposed to dots or spaces when naming their files. Regards Mark Henderson Web Designer mailto:[EMAIL PROTECTED] 205 Main Street PO Box 143, Gore Southland 9700 Phone: (03) 203 Fax: (03) 203 9900 -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 1:19 AM To: CF-Talk Subject: RE: Removing extensions from filelists This will work in most cases, but not if there is a dot in the filename. The easiest way to remove the extension is using the regexp I posted. List functions will give problems in some cases. Pascal > -Original Message- > From: Ewok [mailto:[EMAIL PROTECTED] > Sent: 30 August 2004 13:15 > To: CF-Talk > Subject: RE: Removing extensions from filelists > > > > > > > > #replace(listFirst(name, "."), "_", " ", "ALL")# > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
> Let me add to this one and see if anyone knows how to > output the > parameters passed to a stored proc as well. Without > having debuggin > enabled also. Use a function or custom tag to call all your stored procedures and store the arguments or attributes for later use. It would be pretty easy to modify the onTap framework to do this. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ODBC vs JDBC sql syntax differences
> Are there differences in SQL/functions when moving from an > ODBC datasource > to a JDBC datasource? > We're hosting an application for another contractor and > their app is the > only one using ODBC (all apps use Oracle). We'd like to > remove the ODBC > services (well, we're setting up a brand new box and would > like to do so > without ODBC) but they claim that it's a big hassle for > them to change their > app to use JDBC instead of ODBC. When we've migrated apps > in the past (many > of which are considerably larger) we never had to change > any SQL as long as > the back-end database was the same. I'd be damned surprised if it required any changes at all... I'm not saying it won't, I'd just be very surprised. I'd insist on testing a copy of the app on JDBC as is to see what happens. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Entire keyboard-based CF application
There's an XForms option -- there's also a Flash option and a default option which creates the same html/_javascript_ forms cfform creates now. Or so I've heard. > XForms is the replacement for current HTML forms - > basically it's a separate > W3C standard just for forms to go with XHTML 2.0. > Hit www.W3C.org or google "xforms" > for more information. > I believe that that enhanced forms processing in > Blackstone (CF 7) is partially XForms-based. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: fyi
At 05:13 PM 8/31/2004, you wrote: >Just wanted to let you know I'm leaving on time today, but will probably >stay a little later tomorrow (til 7ish). >The final thing left to do for the NDA stuff is to upload the executed >doc, which will be done in the AM tomorrow. > >You asked that the output be sorted by DATE ISSUED. That is no problem, >however, if more than one NDA is issued to the same business then the >output is grouped by business name and sorted by DATE ISSUED within that >group. Check out OP 141 (internal ID) and click "View NDAs" on the >left... you will see what I am talking about. > >I also added a count in the navigational area as to the number of NDAs >available to view by clicking on the link (#). Also, you can navigate >between the areas (op and exchange) without losing your current >opportunity. A lot of the additional queries/stored procs written today >will be used in the splash/user's homepage so it was not a waste of time >to knock those of the list. > >Tomorrow afternoon I will continue working with the TA section. > >Let me know how the NDA section is looking if you have a moment. It >should be inline with what we've talked about but let me know if >something is askew. > >Thanks! > >-Mike > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Notebook recommendations
On Tue, 31 Aug 2004 17:02:36 -0400, Victor Moore <[EMAIL PROTECTED]> wrote: > Sorry for the OT, but I am looking for a new laptop and I was > wondering if you guys have any preference or can make a > recommendation. > > I was able to narrow it down to the following: > Dell Inspiron 8600 > Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook > HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook > > It will be used mainly for some development and demos. > Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc I have the Dell Inspiron 1100 and have been very happy with it. The only suggestion that I would make is to get as much RAM in the notebook as possible. I would go with either 768 or 1024Megs of RAM. Anything less is not sufficient for running the above apps. -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Let me add to this one and see if anyone knows how to output the parameters passed to a stored proc as well. Without having debuggin enabled also. Christian -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:50 PM To: CF-Talk Subject: Re: CFQuery >> so why is debugging being enabled on a production machine >> bad? > it takes up valuable time slices :) > Doug Personally I find time difficult to slice ... I can never seem to find a knife sharp enough to penetrate its fabric. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT Notebook recommendations
Personally I would go for a Sony with an X-Black LCD screen. The displays are amazing compared to any other laptop I have seen and the Sony's look really nice as well, and they are no more expensive than other makes. In fact I purchased one recently and it worked out cheaper than the same Dell once you had added Dell's massive delivery charge. Best Regards >>> Andrew SpamNet - Stop spam immediately and help me too! www.cloudmark.com/spamnet Referral Code: 2tc4hl (use the code a get spamnet for $1.99 per month instead of $4.99!!!) _ From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: 31 August 2004 22:03 To: CF-Talk Subject: OT Notebook recommendations Sorry for the OT, but I am looking for a new laptop and I was wondering if you guys have any preference or can make a recommendation. I was able to narrow it down to the following: Dell Inspiron 8600 Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook It will be used mainly for some development and demos. Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc Thanks Victor PS if you have any suggestions please let me know If other people are not interested in it you can send them privately _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFXM 6.1 Updater 1 comments?
> I saw Damon (from MM) respond on one list that the fix is just to copy > navserver.cfm from a 6.1 install back into the updated 6.1 install > since that's the only file affected. The thing is... it shouldn't have been re-introduced in the first place... If QA missed an already known bug, you have to wonder what else could be going on under the hood... Regression testing should have found that problem and it certainly shouldn't have made it as far as the RTM. Also with the sizes of the navserver.cfm file being so very different and I have to wonder what else changed in the file for the latest release and am I missing other fixes by going back to the patch version??? Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
fyi
Just wanted to let you know I'm leaving on time today, but will probably stay a little later tomorrow (til 7ish). The final thing left to do for the NDA stuff is to upload the executed doc, which will be done in the AM tomorrow. You asked that the output be sorted by DATE ISSUED. That is no problem, however, if more than one NDA is issued to the same business then the output is grouped by business name and sorted by DATE ISSUED within that group. Check out OP 141 (internal ID) and click "View NDAs" on the left... you will see what I am talking about. I also added a count in the navigational area as to the number of NDAs available to view by clicking on the link (#). Also, you can navigate between the areas (op and exchange) without losing your current opportunity. A lot of the additional queries/stored procs written today will be used in the splash/user's homepage so it was not a waste of time to knock those of the list. Tomorrow afternoon I will continue working with the TA section. Let me know how the NDA section is looking if you have a moment. It should be inline with what we've talked about but let me know if something is askew. Thanks! -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Clustercats Vs Win2k Advanced Server
Currently we have 3 production web servers all running CF5 (CFMX upgrade is not an option for us), different sites on each m/c. Each box services betwen 5 and 8 web sites. We don't run our own dns. What we would like to do is have all the m/c's look the same, and use either clustercats or win2k advanced server cluster services to be the front end. Any recommendations ? btw, I have no idea what I'm doing at the moment, just poking around in the dark! I will be given two m/c's to test on Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Thanks Ben, that is what I was afraid of. Christian -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:09 PM To: CF-Talk Subject: RE: CFQuery If you are trying to pull it the way I did in that UDF, then yes, debugging must be on. I have not yet found a way to get this without debugging enabled. --- Ben _ From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server-side forwarding in CFMS
getpagecontext.forward() doesn't seem to pass on form variables. Can anyone confirm this is in the bug base and has/has not been fixed with the most recent service pack. -Phil >I successfully implemented the getpagecontext.forward() method in one >of my applications and it worked great. > >The problem came during testing when I found out the this call opens a >new connection on the server and the connection is never closed within >a reasonable time (if at all). One thing that I did not try was >placing a after this call. > >I do know that the method works though despite its lack of >documentation. The question is simply controlling it. > >Hope this helps some...It is definitely worth some experimentation. > >-- >Mike Kelp > >--Education's purpose is to replace an empty mind with an open one. >~Malcolm S. Forbes >--If knowledge is power, know this is tyranny. >~Thrice [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ODBC vs JDBC sql syntax differences
Samuel R. Neff wrote: > Are there differences in SQL/functions when moving from an ODBC datasource > to a JDBC datasource? I know from theory there can be differences, but I have never encountered them. But ODBC and JDBC are not bug-compatible of course :) Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT Notebook recommendations
On Aug 31, 2004, at 5:02 PM, Victor Moore wrote: > Sorry for the OT, but I am looking for a new laptop and I was > wondering if you guys have any preference or can make a > recommendation. Get the best thinkpad you can, they're built to last, unlike most others. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
If you are trying to pull it the way I did in that UDF, then yes, debugging must be on. I have not yet found a way to get this without debugging enabled. --- Ben _ From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 4:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFXM 6.1 Updater 1 comments?
Hi. Have had it installed for 3 weeks (was a beta tester) on a development server with no issues. Have it installed on a W2k3 production server as well and it seems to have made a small improvement to the stability but it still have the JRun/W2k3 random crash restart issue. Will be installing in on our productions Linux servers soon. Best Regards >>> Andrew SpamNet - Stop spam immediately and help me too! www.cloudmark.com/spamnet Referral Code: 2tc4hl (use the code a get spamnet for $1.99 per month instead of $4.99!!!) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT Notebook recommendations
Sorry for the OT, but I am looking for a new laptop and I was wondering if you guys have any preference or can make a recommendation. I was able to narrow it down to the following: Dell Inspiron 8600 Toshiba Tecra S1-QW6 Centrino 1.7GHz Notebook HP Pavilion ZT3380US Intel Centrino M 1.7GHz Notebook It will be used mainly for some development and demos. Needs to run CFMX, MS-SQL2000, CFStudio, VisualStudio .Net etc Thanks Victor PS if you have any suggestions please let me know If other people are not interested in it you can send them privately [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ODBC vs JDBC sql syntax differences
Are there differences in SQL/functions when moving from an ODBC datasource to a JDBC datasource? We're hosting an application for another contractor and their app is the only one using ODBC (all apps use Oracle). We'd like to remove the ODBC services (well, we're setting up a brand new box and would like to do so without ODBC) but they claim that it's a big hassle for them to change their app to use JDBC instead of ODBC. When we've migrated apps in the past (many of which are considerably larger) we never had to change any SQL as long as the back-end database was the same. Thanks, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Ah.. is that dilemna - sorry, I misread. -Original Message- From: Christian Watt [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:55 PM To: CF-Talk Subject: RE: CFQuery The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
The way that Forta wrote a UDF though implies that you have to have debugging enable to use the service.factory. If this is not true, let me know please. Christian -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 3:37 PM To: CF-Talk Subject: RE: CFQuery If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFXM 6.1 Updater 1 comments?
On Tue, 31 Aug 2004 21:44:13 +0100, Paul Vernon <[EMAIL PROTECTED]> wrote: > Just one issue for me in that the bug using CF admin over SSL seems to have > been re-introduced I mentioned it on list and I've reported it to MM but > no response from either! I saw Damon (from MM) respond on one list that the fix is just to copy navserver.cfm from a 6.1 install back into the updated 6.1 install since that's the only file affected. Some people hit the "admin:l10n" tag error - that happens when you have your CFIDE directory in two places and only update one instance of it. The same problem bit a few people with Updater 3 (CFMX 6.0) and it is addressed explicitly in the release notes. -- Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFX Tag development in Visual C++.NET 2003?
Hi there, after a lengthy absence from the CF Community it looks like I'm back to developing CF Pages, and hence have my first question to CF-Talk in a few years probably. I need to develop a CFX tag that will work with ColdFusion 5.0. My C++ development is done in Visual Studio .NET 2003. Is there any way to get the ColdFusion 5 custom tag wizard working in Visual Studio.NET 2003? Anyone out there attempted it? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFXM 6.1 Updater 1 comments?
On Aug 31, 2004, at 4:10 PM, DeMarco, Alex wrote: > Anyone try this latest update? Any big issues? Works great here. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
>> so why is debugging being enabled on a production machine >> bad? > it takes up valuable time slices :) > Doug Personally I find time difficult to slice ... I can never seem to find a knife sharp enough to penetrate its fabric. :) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFXM 6.1 Updater 1 comments?
Just one issue for me in that the bug using CF admin over SSL seems to have been re-introduced I mentioned it on list and I've reported it to MM but no response from either! Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Book Recomendations
> I'm looking for a good book on integrating CF and Flash, > specifically with heavy references to webservices. Anybody > have any suggestions? The Flash Remoting book from O'Reilly that Chris Johnston mentions is very good. You might also take a look at Nate Weiss' "Macromedia Flash MX Professional 2004 for Server Geeks". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFXM 6.1 Updater 1 comments?
I have had no issues, though I have read a few poeple claiming to have issues, what about exactly I don't remeber sorry. I'll be putting on the production servers Tomarrow probably. Adam H On Tue, 31 Aug 2004 16:10:16 -0400, DeMarco, Alex <[EMAIL PROTECTED]> wrote: > Anyone try this latest update? Any big issues? > > - Alex > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
If you are using CFMX you can get at the query information using the service factory. I posted a function on my blog (http://blog.mxconsulting.com). I'm sorry if someone has already mentioned this - it's been around for a while and resurfaces every few months. I think I originally got it from one of you guys ... or it might have been ben forta - can't remember. -Mark -Original Message- However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging . [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Concatenate 2 binary variables
This should do it: bos = createObject("java", "java.io.ByteArrayOutputStream").init(); bos.write(binary_stuff,0,len(binary_stuff)); bos.write(ender,0,len(ender)); New_binary = bos.tobytearray(); bos.close(); Probably a better way with the fileinputstream but I already had this code so I figured I'd post if for ya. Adam H On Tue, 31 Aug 2004 16:13:44 -0400, Marc Campeau <[EMAIL PROTECTED]> wrote: > > That will only work if the first file has a size that is a > > multiple of 3 bytes. > > Thanks for the info Jochem! I guess that it's only doable using some > CF add-ons like CFOBJECT then? > -- > Marc > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Book Recomendations
On Tue, 31 Aug 2004 15:58:45 -0400, Cutter (CF related) <[EMAIL PROTECTED]> wrote: > I'm looking for a good book on integrating CF and Flash, specifically > with heavy references to webservices. Anybody have any suggestions? > Flash Remoting the definitive guide from O'Reilly is about the best book that I have come across for integrating CF and Flash. It is written specifically for Flash Remoting, but contains a chapter on using remoting with CF and also contains a chapter on Web Services. -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
If debugging is turned on in the admin debuging routines are ALWAYS run. IsDebugMode() returns for the specific instance weather YOU will see degubbing or not. Debuging from my expeince does use a good bit of processing time. However that asside somehow the debugging information is pulling the SQL syntax form something, so it might be possible find it. I've been trying to figure this out for fun in my spare time but I haven't gotten anywhere with it. The only thing I have come up with,which is discourgaging, is in the java.sql.statement a method execute exists. I am figuring ColdFusion uses that and might be checking if debuging is on prior to making a call to it and storing the SQL string in an array in the ServiceFactory. I have had no luck retrieving the java.SQL.statement object for a query even though there is a getstatement method in the coldfusion.sql.QueryTable (atleast I think thats the object that has the method) Adam H On Tue, 31 Aug 2004 16:22:43 -0400, Dave Watts <[EMAIL PROTECTED]> wrote: > > This brings up an interesting question though, if my ip is not > > in the list then I don't get debug information and debug mode > > is turned off, so why is debugging being enabled on a production > > machine bad? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Proc output params with CFMX 6.1
> I am runnig CFMX6.1 on Solaris and I have a stored procedure > that has one input parameter and one output parameter. When > I use the Sybase driver that ships with CFMX, I get the > following error when I try to execute the proc: > > Error Executing Database Query. > [Macromedia][Sybase JDBC Driver]The stored procedure call > could not be made as a language event, due to the presence of > one or more output-only parameters. It is recommended that > parameter markers be used for all stored procedure arguments. > > When I switch to a Sybase jConnect JDBC driver, then it works > fine. > > Any ideas? I'm not especially familiar with the DataDirect driver for Sybase, but if the vendor's own driver does what you want, why not just use that instead? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
> This brings up an interesting question though, if my ip is not > in the list then I don't get debug information and debug mode > is turned off, so why is debugging being enabled on a production > machine bad? My understanding is that simply gathering debug statistics incurs a performance penalty, whether you actually show those statistics to anyone or not. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Cfquery Blockfactor and Oracle9i
> I have been reading in many places to increase performance, > increate the BLOCKFACTOR of queries to 100. If I have a > query that generally returns 5 rows should a blockfactor of > 100 benefit, hurt, or not affect performance. > > I have tried using the blockfactor in the past by going > through the app and if a query on average returned 30 rows I > set the blockfactor to 30. I didnt notice a performance > increase at all and in fact in some places I notice some > actual decrease. So I removed the setting from all cfquery > tags. But I didn't try just making all query blockfactor's 100. I don't really know whether BLOCKFACTOR makes much of a performance difference in CFMX; I'm basically assuming that it works the same way as in previous versions, but I haven't tested that. That said, you should set the BLOCKFACTOR based on the size of an individual row. The BLOCKFACTOR attribute lets you put more than one row within a buffer, but the buffer in CF 5 at least is a fixed size of 32Kb if I recall correctly. So, you should set your BLOCKFACTOR value equal to the number of rows that will fit in 32Kb. If you set it to a higher number, the BLOCKFACTOR attribute is ignored, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Concatenate 2 binary variables
> That will only work if the first file has a size that is a > multiple of 3 bytes. Thanks for the info Jochem! I guess that it's only doable using some CF add-ons like CFOBJECT then? -- Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFXM 6.1 Updater 1 comments?
Anyone try this latest update? Any big issues? - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Concatenate 2 binary variables
It occurs to me that you could use the system to concatenate two files, then read them as binary. ie you could "copy file1+file2 file3 /b" and then read file3. --Ben Neculai Macarie wrote: > Hi! > > Is there a way to concatenate 2 binary variables (that contain 2 files): > > > > I want to have a single variable, something like this: > > > > Thanks, > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Concatenate 2 binary variables
Marc Campeau wrote: >>Is there a way to concatenate 2 binary variables (that contain 2 files): >> >> > Otherwise, maybe you can convert both files to Base64, do the > concatenation and then reconvert back to binary... That will only work if the first file has a size that is a multiple of 3 bytes. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Concatenate 2 binary variables
> Is there a way to concatenate 2 binary variables (that contain 2 files): > > You'll probably want to use some Java (look at java.io.fileInputStream) to do that since CFFILE deals mostly with text files, especially if you want to write the results to a file. Otherwise, maybe you can convert both files to Base64, do the concatenation and then reconvert back to binary... I've never done this, so I'm basing this on my understanding of the docs. -- Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Book Recomendations
I'm looking for a good book on integrating CF and Flash, specifically with heavy references to webservices. Anybody have any suggestions? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
component browser on windows 2003 and CFMX 6.1
We are having issues with our component browser in coldfusion administrator. Current configuration : Windows server 2003 and CFMX 6.1 with apache. The component browser works fine on the stand alone windows 2000 professional with or with out apace/IIS. Either it keeps trying to open repeatedly the component browser window or it opens up after a long period and hangs up. Any help would be greatly appreciated. Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: galleon
Peter, Yeah, that is my plan. That is the technique my blog uses (although I switched to UUIDs to handle that). It's not really a huge change, just something I have to find time for. If there are a lot of you guys out there dieing for this, and want it "officially" from me, ping me offlist and I'll try to hurry it up. On Tue, 31 Aug 2004 11:10:06 -0400, Peter Farrell <[EMAIL PROTECTED]> wrote: > Ray, > > It wouldn't be that hard to add a switch in the application settings that would indicate the Db being used. In the places where last id is need, just put in a switch/case block for the DB specific query to get last id. I use MySQL a whole ton and I'm willing to go through and supply code to get the last id. > > .Peter > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
> Yes, you are correct, but the requesting IPAddress has to > be in the > debugging IP Addresses. otherwise IsDebugMode returns > false. This > brings up an interesting question though, if my ip is not > in the list > then I don't get debug information and debug mode is > turned off, so why > is debugging being enabled on a production machine bad? > This is near > the top of my page also. I would also like to know of > some way to > return the query as well. And yes, I understand I can > rewrite all of > queries as strings, but was really hoping to not do that > since most of > them are going to become stored procs pretty soon anyway. At which point you won't get to see any of the sql by collecting it from CF... I wouldn't be surprised if debugging inflates execution times whether it's used on a given request or not -- although I haven't tested it, so I couldn't tell you for certain if that's the case. I do know that having debugging enabled and doing nothing but displaying execution times inflates the execution times being displayed by almost an order of magnitude when I tested it. (Though the specific code being executed likely varries those results quite a bit.) s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Cfquery Blockfactor and Oracle9i
I have been reading in many places to increase performance, increate the BLOCKFACTOR of queries to 100. If I have a query that generally returns 5 rows should a blockfactor of 100 benefit, hurt, or not affect performance. I have tried using the blockfactor in the past by going through the app and if a query on average returned 30 rows I set the blockfactor to 30. I didnt notice a performance increase at all and in fact in some places I notice some actual decrease. So I removed the setting from all cfquery tags. But I didnt try just making all query blockfactor's 100. Thanks, David [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
> so why is debugging being enabled on a production machine bad? it takes up valuable time slices :) Doug - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 13:34:52 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Yes, you are correct, but the requesting IPAddress has to be in the debugging IP Addresses. otherwise IsDebugMode returns false. This brings up an interesting question though, if my ip is not in the list then I don't get debug information and debug mode is turned off, so why is debugging being enabled on a production machine bad? This is near the top of my page also. I would also like to know of some way to return the query as well. And yes, I understand I can rewrite all of queries as strings, but was really hoping to not do that since most of them are going to become stored procs pretty soon anyway. Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 12:11 PM To: CF-Talk Subject: Re: CFQuery As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Yes, you are correct, but the requesting IPAddress has to be in the debugging IP Addresses. otherwise IsDebugMode returns false. This brings up an interesting question though, if my ip is not in the list then I don't get debug information and debug mode is turned off, so why is debugging being enabled on a production machine bad? This is near the top of my page also. I would also like to know of some way to return the query as well. And yes, I understand I can rewrite all of queries as strings, but was really hoping to not do that since most of them are going to become stored procs pretty soon anyway. Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 12:11 PM To: CF-Talk Subject: Re: CFQuery As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Proc output params with CFMX 6.1
I am runnig CFMX6.1 on Solaris and I have a stored procedure that has one input parameter and one output parameter. When I use the Sybase driver that ships with CFMX, I get the following error when I try to execute the proc: Error Executing Database Query. [Macromedia][Sybase JDBC Driver]The stored procedure call could not be made as a language event, due to the presence of one or more output-only parameters. It is recommended that parameter markers be used for all stored procedure arguments. When I switch to a Sybase jConnect JDBC driver, then it works fine. Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
I found in order to code ColdFusion correctly I had to do this: And in ASP I did this <%response.Charset="ISO-8859-1"%> I was then able to encrypt a string, urlencode it, then pass it to ASP and ASP could then use RC4 to decrypt that string. Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Credit card page processing before error check
This bit is always gonna return true, maybe thats the problem if (!this.isExpiryDate()) return false; return true; also try checkit();return false; --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.745 / Virus Database: 497 - Release Date: 8/27/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web service method with an argument of type Base64
> You sure its not a problem on the other side? I use the getbytes > function regularly as well as other function that return btye arrays > like Gzip. This infommation is used with external applications and > Amazon. If it was buggy I wouldn't imagine it would be working. > > > Adam H The problem was on my side. I was reading the files from disk with Read instead of ReadBinary and the ToBase64 function was treating them as strings, not as binary data. Thanks for the help, much appreciated. -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Credit card page processing before error check
> I'm so sorry, but I'm pulling my hair out on this _javascript_ > issue and I can't get any help. > > I have this credit card code that checks values. The code > throws an alert error, but when I click ok on the alert > popup, the page process instead of allowing me to fix the > error and process it again. > > I'm using document.ThisForm.submit(); to process the page, > look for this text below. I just briefly read through the code, so I may not understand exactly which forms and functions are doing what. However, usually when using _javascript_ form validation, you want to write a validation function which simply returns true or false. Then, within your form's onsubmit event handler, you return the value returned by that function:
function checkme() {
if (ok) {
return true;
} else {
return false;
}
}
... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: redirect after cfheader/cfcontent
> I've been meaning to ask for awhile, but how much overhead > does CFCONTENT create if you are serving a 1MB file? Howabout > a 10MB file? Does the CF server actually handle the file, or > does it just provide a pointer to the local file? I believe that the request is handled entirely by the web server connector, rather than by the CF server itself. I'm not sure about overhead in a general sense, as there are plenty of ways to measure that, but it's been my observation that it will monopolize a thread until the file has been returned, which can cause significant performance issues with multiple users. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Concatenate 2 binary variables
Hi! Is there a way to concatenate 2 binary variables (that contain 2 files): I want to have a single variable, something like this: Thanks, [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF -> Javascript variables
Wrong subject From: Frank Dewey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 1:10 PM To: CF-Talk Subject: RE: CFQuery Hello all, In my page, clicking on a name brings up another window where you can edit their information (their address is shown below their name). The addressID for each address is also stored in a variable (addressIDList). Clicking on a button gets the the current information from the database - the processing is done in an iframe and addressIDList is passed in the URL. I would like to have _javascript_ write this new information to the screen. I do not want the entire screen to be reloaded though, just certain information. The proper text is surounded by (for the city and state text): ... ... ... Everything works like it should except that I cannot get _javascript_ to update the page because of some syntax errors. I am trying to use JS.innertext to write the new information (i.e. for the city):
parent['city'+#addressid#].innerText =
#evaluate(city&addressid)#;
...
What is wrong with this syntax? What should it be instead? I appreciate any help... Thank you - Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Hello all, In my page, clicking on a name brings up another window where you can edit their information (their address is shown below their name). The addressID for each address is also stored in a variable (addressIDList). Clicking on a button gets the the current information from the database - the processing is done in an iframe and addressIDList is passed in the URL. I would like to have _javascript_ write this new information to the screen. I do not want the entire screen to be reloaded though, just certain information. The proper text is surounded by (for the city and state text): ... ... ... Everything works like it should except that I cannot get _javascript_ to update the page because of some syntax errors. I am trying to use JS.innertext to write the new information (i.e. for the city):
parent['city'+#addressid#].innerText =
#evaluate(city&addressid)#;
...
What is wrong with this syntax? What should it be instead? I appreciate any help... Thank you - Frank [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
>> Arguments is an array rather than a structure > If I recall correctly, the Arguments "object" is exposed > as both an array > and a structure. > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 On MX you're right, although the original question was on CF5. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
Not in CF5. That is where the problem was. Pascal > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: 31 August 2004 18:40 > To: CF-Talk > Subject: [Spam?] RE: Second Pair Of Eyes > > > Arguments is an array rather than a structure > > If I recall correctly, the Arguments "object" is exposed as both an array > and a structure. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
Robert Everland III wrote: > So how do we change the charset in ColdFusion, I found out how to change it in ASP. You can give each template a Byte Order Mark, or you can use cfprocessingdirective on each page. > I have tried a meta tag in HTML, but that didn't change the output. That only changes the way the browser tries to render the HTML, it does not change the way CF MX processes the data. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP and replace() on Multiple Lines
>Where a single search doesn't work, I usually revert to finding the >start index 'start = find(" >index 'end = find("", myStr, start) + 4' and then do a mid(myStr, >start, end) call to pull it out. You may have to tweak that a little, >but that's the idea. > >cheers, >barneyb > >On Tue, 31 Aug 2004 12:27:46 -0400, Josen Ruiseco ><[EMAIL PROTECTED]> wrote: >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com It turns out that I used the find function then used the removeChars function. Other techniques, such as ReFindNoCase and replace using chr()s did not work. Thanks to all for the help... Josen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CHR in ASP and CFMX
So how do we change the charset in ColdFusion, I found out how to change it in ASP. I have tried a meta tag in HTML, but that didn't change the output. Bob > Robert Everland III wrote: > > > When I do a CHR() in ASP and a CHR() in CFMX they come up with 2 > different values. Is there any way to match the values up? > > Use the same charset in ASP and CF MX. > > Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: database connections
there is a timeout setting in the CFADMIN tool for this. I'd guess turning off teh 'maintain connections' should kill each connection after the timeout, maybe before I can't recall. ah...the docs have Timeout (min) The maximum number of minutes after the data source connection is made that you want ColdFusion MX to cache a connection after it is used. Interval (min) The time (in minutes) that the server waits between cycles to check for expired data source connections to close. Doug - Original Message - From: Phill B <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:44:28 -0500 Subject: database connections To: CF-Talk <[EMAIL PROTECTED]> Here is the deal. I have CFMX on my laptop with dev apps that connect to the mssql server. I use an app that hits 3 different data sources which would create 3 processes on the sql server. Lets say I shut down and restart my laptop and run the app again. I now have 6 processes running on the sql server. In CF Admin I have maintain connections checked. If I uncheck it, will that help or fix the problem? Also, is there a way to time out connections on the sql server? -- Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
it does require debug to be on though for sure, not a good thing for production systems, eh? try the long hand way #PreserveSingleQuotes(varaibles.sql)# of course you may need to name your sql var different for multiple queries. Doug - Original Message - From: Qasim Rasheed <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 13:10:30 -0400 Subject: Re: CFQuery To: CF-Talk <[EMAIL PROTECTED]> As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
application testing
Hello, It's been awhile since I've posted but this seems like a good time to = get some expert opinions.=20 I have been tasked with evaluating application testing software and = would like to get an idea what other CF developer's use. I'm primarily = interested in static, functional and regression testing, and some load = analysis would be helpful but not necessary. I'm looking at: Seapine's QA Wizard Parasoft's WebKing Empirix's E-Test Suite OpenDemand's OpenLoad We do a lot of extranet sites with multiple users and entitlements. Not = much in the way of public or high demand enterprise e-commerce sites. Any experiences, insights, or thread references are greatly appreciated. Thanks in advance, John Chase [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Alternative to cgi.http_referer - single signon
Brian, I'm not sure you will get consistency from anything in cgi. I'd say you are going to have to pass something else - a shared key of somekind between you and the host. This could be done with _javascript_ point to a page on your server (src="" that appends a url string to the link or hidden variable. -Mark -Original Message- From: Brian Meloche [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 11:54 AM To: CF-Talk Subject: Alternative to cgi.http_referer - single signon At the office, we've run into a bit of a snag with a script that a consultant did for us that authenticates from the URL of a referring page hosted on a third party site to auto-generate single signon authentication, so that an account from their site is automatically generates an account on our system and doesn't require the user to sign into our system. This feature is a requirement to our application by the third party (our client). In this case, the consultant's code tries to authenticate from cgi.http_referer. The problem we're getting is that we're not getting back a value. I have looked around the web, on this list and elsewhere, and know that this is a potential problem both with firewalls and certain browsers, but I haven't been able to find an alternative. We NEED an alternative, and we need it ASAP. Any suggestions? -- Sincerely, Brian Meloche http://www.brianmeloche.com http://www.clevelandmmug.org (currently partially down) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT : Keeping JS Count
> Say you have 2 radio inputs one with a value of 0, the other > with a value of 1. And you have five of these.. > a_1 = 0 > a_2 = 1 > a_3 = 0 > a_4 = 0 > a_5 = 1 > how would you keep track of the totals? > Initially you could just do a sum of the values but what if > the user changed an option? it wouldnt subtract the 1? > Any ideas would be appreciated. You can assign an event handler to any form field, so that when an event occurs a _javascript_ function is called. For example, if you had an array of checkboxes, you could loop over them to see which ones were checked. You could do this whenever any of them were checked or unchecked.
function calcTotal() {
var total = 0;
for (var i = 0; i < document.forms[0].items.length; i++) {
if (document.forms[0].items[i].checked) {
total += document.forms[0].items[i].value;
}
}
document.forms[0].total.value = total;
}
Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
> Arguments is an array rather than a structure If I recall correctly, the Arguments "object" is exposed as both an array and a structure. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQUERYPARAM in CFSET
> This may not be possible but... > > Doesn anyone know of a way to get this or something similar > to work? > > > value=""#Variable#"">"> > > > #preserveSingleQuotes(strSQL)# > I'm pretty sure that idea, or any variations on it, won't work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Alternative to cgi.http_referer - single signon
Brian Meloche wrote: > At the office, we've run into a bit of a snag with a script that a > consultant did for us that authenticates from the URL of a referring > page hosted on a third party site to auto-generate single signon > authentication, so that an account from their site is automatically > generates an account on our system and doesn't require the user to > sign into our system. This feature is a requirement to our > application by the third party (our client). > > In this case, the consultant's code tries to authenticate from > cgi.http_referer. The problem we're getting is that we're not getting > back a value. > > I have looked around the web, on this list and elsewhere, and know > that this is a potential problem both with firewalls and certain > browsers, but I haven't been able to find an alternative. We NEED an > alternative, and we need it ASAP. HTTP Digest Authentication can be set up to authenticate for multiple domains / servers, see RFC 2617. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFQuery
As far as I can tell after looking at the UDF, it doesn't require an error to occur before it returns the sql statement. the only requirement I see is that debugging must be turned on on the server for this to work. since I am not the author of this udf, I might completely be wrong - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 12:00:39 -0500 Subject: RE: CFQuery To: CF-Talk <[EMAIL PROTECTED]> Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Alternative to cgi.http_referer - single signon
At the office, we've run into a bit of a snag with a script that a consultant did for us that authenticates from the URL of a referring page hosted on a third party site to auto-generate single signon authentication, so that an account from their site is automatically generates an account on our system and doesn't require the user to sign into our system. This feature is a requirement to our application by the third party (our client). In this case, the consultant's code tries to authenticate from cgi.http_referer. The problem we're getting is that we're not getting back a value. I have looked around the web, on this list and elsewhere, and know that this is a potential problem both with firewalls and certain browsers, but I haven't been able to find an alternative. We NEED an alternative, and we need it ASAP. Any suggestions? -- Sincerely, Brian Meloche http://www.brianmeloche.com http://www.clevelandmmug.org (currently partially down) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP and replace() on Multiple Lines
Use regexp? REReplaceNoCase(str,"\s+","","all") Pascal > -Original Message- > From: Josen Ruiseco [mailto:[EMAIL PROTECTED] > Sent: 31 August 2004 18:28 > To: CF-Talk > Subject: CFHTTP and replace() on Multiple Lines > > I am calling a document via cfhttp. I am replacing numerous lines of text > within the called document. > > There is a snippet in the document that I cannot seem to grab: > > > > > > > > Spacing is as it is in the doc... > > I can grab the with no problem. But I cannot grab the > because I will screw up the entire document. I tried control characters to > get the whole thing - chr(), etc. (replace(document," > width=1>#chr(13)#...", "")>) but it seems that I could not grab them > that way. > > Any ideas? > > Regards, > > Josen > GoMotorBids.com > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFQuery
Reply, not quite, this only works when an error has occurred. I would like to do this even if an error has not occurred. Select * from table #Output Query Ran# Christian -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:37 AM To: CF-Talk Subject: Re: CFQuery I guess this is what you need http://cflib.org/udf.cfm?ID=686 - Original Message - From: Christian Watt <[EMAIL PROTECTED]> Date: Tue, 31 Aug 2004 10:21:43 -0500 Subject: CFQuery To: CF-Talk <[EMAIL PROTECTED]> I know you can return the execution time of a query, but how do you return what the query ran is? Just like they do when you turn on debugging. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SOT : Keeping JS Count
IS this what you want?? function showValues(theForm) { var currVal = document.getElementById("ptotal"); var sum = 0; for(var i=0;i if(theForm.elements[i].checked) sum += parseInt(theForm.elements[i].value); } alert(sum); } Pascal > -Original Message- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: 31 August 2004 18:34 > To: CF-Talk > Subject: Re: SOT : Keeping JS Count > > this is what I have > function showValues(theForm) { > currVal = document.getElementById("ptotal"); > sum = 0; > for(i=0;i > sum += parseInt(theForm.elements[i].value); > } > alert(sum); > } > > Unfortunately the radios have a value of 0 and a value of 1. > So this adds up 0 + 1 per radio and returns 1. > How do I make it add up only whats selected, not both values? > Maybe a radio isnt the right way of doing this? I'm open to any > suggestions. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Mail in Undeliverable Folder
iff all you need to do is change the IP just do a search and replace on the folder for the IP and move them back to the spool folder. ADam H On Tue, 31 Aug 2004 11:42:05 -0500, B G <[EMAIL PROTECTED]> wrote: > Due to an IP change on our server and an application that didn't get updated > I have quite a number of emails in the undeliverable folder that I would > like to send out. Has anyone converted these and drop them in the spool so > they get sent? > > Thanks. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Second Pair Of Eyes
In cf5, arguments is an array. Just use formName and defaultValue without a prefix (or arguments[1] and arguments[2]). Pascal > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 31 August 2004 17:22 > To: CF-Talk > Subject: [Spam?] Second Pair Of Eyes > > Can anyone see something wrong with this, working on CFMX but failing on > CF5 > > > function formValue(formName, defaultValue) { > > if ( IsDefined("FORM.#ARGUMENTS.formName#") ) { > return HTMLEditFormat(FORM["#ARGUMENTS.formName#"]); > } else { > return HTMLEditFormat(ARGUMENTS.defaultValue); > } > > } > > > Error resolving parameter ARGUMENTS.FORMNAME > > > Is this ok on CF5..? > > IsDefined("FORM.#ARGUMENTS.formName#") > > What about... > > FORM["#ARGUMENTS.formName#"] > > Thanks, just need someone else to look at it as it seems ok to me. > > Ade > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Mail in Undeliverable Folder
Due to an IP change on our server and an application that didn't get updated I have quite a number of emails in the undeliverable folder that I would like to send out. Has anyone converted these and drop them in the spool so they get sent? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]