Re: CFMAIL wrongly moved to Undelivr folder

2007-08-08 Thread Jochem van Dieten
Joy Anderson wrote: Jochem van Dieten wrote: CF is delivering the email message to the SMTP server and the SMTP server waits a long time before confirming the receipt. So after a while CF stops waiting for the receipt and decides the message is undeliverable, and some time later the SMTP

Report Problems

2007-08-08 Thread David Mineer
I am creating a report with report builder. I have a report header. This report is 3 pages long. After I get the content for the first page, I add a page break. 2 problems. Once the detail band is longer than a page, the report header is forced to page 1 by itself, like a page break magically

RE: Site masking from GoDaddy.com

2007-08-08 Thread Eric Roberts
The site is inside a frame if that helps...it's called URL framing Eric -Original Message- From: Dave Hatz [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 7:26 PM To: CF-Talk Subject: Site masking from GoDaddy.com I am not even sure site masking is the correct term, but let me

Re: running jrockit with CFusionMX7 to find memory leak

2007-08-08 Thread Tom Chiverton
On Tuesday 07 Aug 2007, [EMAIL PROTECTED] wrote: I have been having a terrible time trying to get jrockit running with coldfusion. I have coldfusion MX 7 running and installed jrockit Can you stick your app on CF8 in the dev. environment and use the built in stuff to try and locate it by

Re: coldfusion 8 and memory

2007-08-08 Thread Casey Dougall
On 8/8/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Tuesday 07 Aug 2007, [EMAIL PROTECTED] wrote: what the heck works in native 64bit systems yet, :looks around his 64-bit machine :sees ColdFusion, Eclipse, KDE, FireFox w/Flash and Java Umm, everything ? -- Tom Chiverton I'm sure

RE: Content Placeholders

2007-08-08 Thread Mark Leder
in the i18n world, java MessageFormat's are often used for dynamic content like this. it's flexible, quick as an added bonus handles locale formatting where needed. Where would I find something like that? Mark ~| Get the

Re: Content Placeholders

2007-08-08 Thread Paul Hastings
Mark Leder wrote: Where would I find something like that? it's already in cfmx (core java anyway). see those links for examples. ~| ColdFusion is delivering applications solutions at at top companies around the world in

Cfdocument named anchors and image scaling

2007-08-08 Thread Gareth Hughes
This is CF 7 with all updates on IIS 6. Has anyone got named anchors to work in PDFs generated by cfdocument? If so, any tips on how? If not, any other ways of including links to other portions of the document? Also, anyone got any ideas why my images would display at 100% when the document

Re: CFMAIL wrongly moved to Undelivr folder

2007-08-08 Thread Joy Anderson
I agree it would be nice to make the SMTP server faster, but some things are out of my control. I checked the documentation -http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1710.htm - and found it mentions

Re: coldfusion 8 and memory

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: I'm sure everything is working but not in what I should have stated, native 64bit mode. In two years, it will be time to upgrade my system again and maybe it would be worth checking out a 64bit system then. I must admit - it was more hassle

Re: Cfdocument named anchors and image scaling

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: If I view the PDF at 100% the images are scaled down and look ropey but if I view the PDF at 113% they are as per the originals and nice and sharp. Umm, yes ? Maybe the native image resolution matches your display resolution only at 113% zoom

Re: CFMAIL wrongly moved to Undelivr folder

2007-08-08 Thread Joy Anderson
I found a file named neo-mail.xml in the \lib folder of cfroot. It contains the mail connection timeout value (default is 60.0). - var name=timeout number60.0/number /var I changed this to 120.0 and restarted CF. The Settings Summary in CFAdmin now shows the Mail Connection Timeout to

RE: CFMX 7 / Vista

2007-08-08 Thread Aaron Wolfe
Randy, This is what finally got my install of CFMX 7 and Vista to work together. http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1c atid=3threadid=1257380highlight_key=ykeyword1=vista -Aaron Wolfe -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent:

Re: Cfdocument named anchors and image scaling

2007-08-08 Thread Gareth Hughes
Umm, cool. Not sure I understand you exactly but you must be right as the optimum zoom seems to differ across machines. Thanks :) Tom Chiverton wrote: Umm, yes ? Maybe the native image resolution matches your display resolution only at 113% zoom of the document.

ColdFusion 8 CachedWithin Issue

2007-08-08 Thread Jason Fill
I am getting very strange behaviors while using CachedWithin on CF8. All the sudden, something that has been working without fail for months in CF7 is giving odd errors. On CF8 I will get intermittent errors that say corrupt table null. If I remove the cachedwithin attribute the query runs

SOT: CF 8 SW Maintenance Plan

2007-08-08 Thread Howell, Craig H Civ WRALC/ITMS
Just a quick survey..has anyone with an Adobe SW Maintenance Plan received an upgrade coupon/code or key for CF 8? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver

Quick Question about upgrading to CF 8

2007-08-08 Thread LHWH Interactive
I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it

Re: ColdFusion 8 CachedWithin Issue

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: the sudden, something that has been working without fail for months in CF7 is giving odd errors. On CF8 I will get intermittent errors that say corrupt table null. If I remove the cachedwithin attribute the query runs fine. For example, I

Re: Quick Question about upgrading to CF 8

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Or should I just get the upgrade and install it over top of 7? I believe by default CF8 installs into a different directory, and

RE: CFMX 7 / Vista

2007-08-08 Thread Robert Harrison
That's timely and great information... thanks. I just bought a Vista machine and have been updating it. So, two related questions: 1. Does CF8 install cleanly on Vista or will these same instructions work for CF8? 2. Also, Vista does not support SQL Server2000 so I had to

RE: CF 8 SW Maintenance Plan

2007-08-08 Thread Dawson, Michael
We received ours on Monday. My father's school corporation received theirs a few days earlier. M!ke -Original Message- From: Howell, Craig H Civ WRALC/ITMS [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:35 AM To: CF-Talk Subject: SOT: CF 8 SW Maintenance Plan Just a

Re: CFMX 7 / Vista

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: I just bought a Vista machine and have been updating it. So, two related questions: There's the obvious question of 'why' that we'll save for another time. 1. Does CF8 install cleanly on Vista or will these same instructions work for

Re: CFMX 7 / Vista

2007-08-08 Thread Peter Tilbrook
Officially CF7 isn't supported on Vista (CF7 arrived nearly two years before Vista) and initially CF8 support was flaky (but so was Vista) - but now works a treat. Consider upgrading. CF7 is now old and superceded tech as far as ColdFusion goes.

Re: CFMX 7 / Vista

2007-08-08 Thread Peter Tilbrook
2. Also, Vista does not support SQL Server2000 so I had to upgrade to 2005 (big pain). There is always SQL Server 2005 Express if you get desperate. Vista and CF8 support both (expect a few patches for SQL Server however - sigh!).

Re: ColdFusion 8 amp; CachedWithin Issue

2007-08-08 Thread Jason Fill
Well it would blow up on various states. All the time on CF8. But this has never happened on 7. I restarted the CF service and it seems to be ok now. But that is beside the point really, I am more concerned on what might have caused this issue since it is a very simple query that just pulls

Eclipse/CFEclispe

2007-08-08 Thread Robert Harrison
So as advised by many on this list I'm going to try CFEclipse, but I found the whole thing a bit confusing. It looks like there are two steps. First install an Eclipse IDE / SDK, then install CFEclipse as a plug-in. I thinks that it. So, first which version of Eclipse should I install? There are

RE: ColdFusion 8 CachedWithin Issue

2007-08-08 Thread Adrian Lynch
Have you managed to get the SQL statement that runs when it falls over? What does it look like? Adrian -Original Message- From: Jason Fill Sent: 08 August 2007 15:26 To: CF-Talk Subject: ColdFusion 8 CachedWithin Issue I am getting very strange behaviors while using CachedWithin on

RE: CF 8 SW Maintenance Plan

2007-08-08 Thread Andy Matthews
We bought licenses for 7 a few months ago with subscription. We just got our 8 licenses a few days ago, last week maybe? -Original Message- From: Howell, Craig H Civ WRALC/ITMS [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:35 AM To: CF-Talk Subject: SOT: CF 8 SW

Re: Eclipse/CFEclispe

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: that it. So, first which version of Eclipse should I install? There are several on page http://www.eclipse.org/downloads/ 'WTP all in one' from http://download.eclipse.org/webtools/downloads/drops/R2.0/R-2.0-200706260303/ It has a few extra

RE: ColdFusion 8 cfgrid and formatting

2007-08-08 Thread Bhakti Pingale
Sorry for the late reply. Yes, the mask attribute applies only if format is flash. If you want to format the data in an html grid, you will have to write your query accordingly so that it returns the date in the required format. This was specifically for the date. However we can take this up as an

Re: ColdFusion 8 cfgrid and formatting

2007-08-08 Thread Dan Vega
Thanks for the reply Bhakti! Dan On 8/8/07, Bhakti Pingale [EMAIL PROTECTED] wrote: Sorry for the late reply. Yes, the mask attribute applies only if format is flash. If you want to format the data in an html grid, you will have to write your query accordingly so that it returns the date in

RE: Eclipse/CFEclispe

2007-08-08 Thread Robert Harrison
Thank You. I'll give it a try... downloading now! I'm figuring since I have a new kick-butt machine and I still have my old machine and environment, I'm going bleeding edge on the new one. IIS7, CF8, SQL Server 2005, CFECLISPE, etc. Why not for once be on the lead? Normally I wouldn't try that

RE: Eclipse/CFEclispe

2007-08-08 Thread Chad Gray
It does CSS? I wonder which one I installed, because I have never gotten CSS and that is the missing link to get me off of Dreamweaver. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:14 AM To: CF-Talk Subject: Re:

RE: Eclipse/CFEclispe

2007-08-08 Thread Dawson, Michael
Yeah, that's a good question. I have the WTP build, but I don't really see any other features, such as CSS, when I'm editing .css files or even styles within an HTML page. M!ke -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 9:40 AM To:

RE: Eclipse/CFEclispe

2007-08-08 Thread Loathe
Look at Aptana. Best CSS and JS plugin around far as I am concerned. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 10:40 AM To: CF-Talk Subject: RE: Eclipse/CFEclispe It does CSS? I wonder which one I installed, because I have never

RE: Eclipse/CFEclispe

2007-08-08 Thread Chad Gray
I tried aptana, but then I lost the ability to autocomplete CF tags... it was like I had to choose one or the other. CSS or CF.. I could not get autocomplete to work for each language at the same time. Is there anyway for me to upgrade my eclipse so I get this WTP all in one package

Re: Eclipse/CFEclispe

2007-08-08 Thread Dan Vega
You can also look at Aptana, I use that plugin and it has a lot of nice features. http://www.aptana.org On 8/8/07, Dawson, Michael [EMAIL PROTECTED] wrote: Yeah, that's a good question. I have the WTP build, but I don't really see any other features, such as CSS, when I'm editing .css files

Re: Eclipse/CFEclispe

2007-08-08 Thread Tom Chiverton
On Wednesday 08 Aug 2007, [EMAIL PROTECTED] wrote: Is there anyway for me to upgrade my eclipse so I get this WTP all in one package features??? Or do I have to reĀ­install and loose all my custom keys and plugins? Just add the WTP URL to your plugin finder. If you have Eclipse 3.3, it should

Re: Eclipse/CFEclispe

2007-08-08 Thread Dan Vega
Well i only use aptana when I am editing .css, .js, .html. When I am editing cfm or cfc I use CFEclipse of course! Dan On 8/8/07, Chad Gray [EMAIL PROTECTED] wrote: I tried aptana, but then I lost the ability to autocomplete CF tags... it was like I had to choose one or the other. CSS or

Help with CFNavigate

2007-08-08 Thread Andy Chen
I am going to try it here since no one from the Adobe support forum knew... Now maybe I am doing it wrong but with CFNavigate, it has the parameter for a container to refresh. What if I want the whole page to refresh with the form fields passed into it? Based on the CFML Reference Guide (pg

Re: CF 8 SW Maintenance Plan

2007-08-08 Thread Rick Root
Here at Duke, we got our CF8 subscription licenses last week. Rick ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki.

Re: One form with two submit buttons in lt;cflayoutareagt;

2007-08-08 Thread Andy Chen
So i did a test when I changed your cfform to post to test2.cfm, and dumped the form scope there, and I saw the same - it doesn't recognize the second button. I mean the button works, but the value is the same. Yeah, experienced the same problem too. I used a CFDUMP var=#form# and couldn't

DW8 download?

2007-08-08 Thread Adkins, Randy
Anyone have a link to the Dreamweaver 8 downloads? I need to get that version. We have our own key for it just need to re-install. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and

How would I go by doing this?

2007-08-08 Thread Andy Chen
Here's a situation: Basically there is a form (CFFORM) which there are various fields. One of the field would be a basic CFINPUT text field where an image ID can be entered. The user will be able to click on a button to preview available images (CFWINDOW). Whatever image they select in the

any idea how to

2007-08-08 Thread Scott Stewart
Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks

RE: any idea how to

2007-08-08 Thread Loathe
Date format? Left, mid, right? -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 12:05 PM To: CF-Talk Subject: any idea how to Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas -- Scott Stewart

Re: any idea how to

2007-08-08 Thread Alan Rother
LEFT MID AND RIGHT cfset variables.myDateString = 20060523 cfset variables.myDateObject = CreateDate(LEFT(variables.myDateString, 4), (variables.myDateString, 4, 2), RIGHT(variables.myDateString, 2)) =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006

Re: any idea how to

2007-08-08 Thread Crow T. Robot
crude, but it works consistently: cfset year = Left(20060523,4) cfset month = Mid(20060523,5,2) cfset day = Right(20060523,2) cfoutput#CreateDate(year,month,day)#/cfoutput On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in

Re: any idea how to

2007-08-08 Thread Jerry Johnson
There is probably a trick i don't know, but something like... dTemp=createODBCDate(mid(date,3,2)right(date,2)left(date,4)) sDate=dateFormat(dTemp,m/d/) On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Convert 20060523 Into 5/23/2006 I'm at a loss.

RE: any idea how to

2007-08-08 Thread Porter, Benjamin L.
Using SQL CONVERT(VARCHAR,CONVERT(DATETIME,'20060523'),101) Using CF Mid('20060523',5,2) '/' Right('20060523',2) '/' Left('20060523',4) -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 11:10 AM To: CF-Talk Subject: RE: any idea how to

Re: any idea how to

2007-08-08 Thread Ian Skinner
Scott Stewart wrote: Convert 20060523 Into 5/23/2006 I'm at a loss. Thanks in advance sas createDate(left('20060523'),mid('20060523',5,2),right('20060523')) is how I have done this in the past, you will probably want to use a variable here and there.

Re: How would I go by doing this?

2007-08-08 Thread kcundick_list
The only way I know of doing what you've indicated below is to use a JavaScript. You can reference the parent or opener window by using the opener keyword: opener.document.parentForm.pf1.value = document.childForm.cf1.value; A good example of how to do this from a JavaScript can be seen here:

Re: How would I go by doing this?

2007-08-08 Thread Andy Chen
Thanks you for the Javascript. That will work with a whole new Window - childWindow=open(file,window,'resizable=no,width=200,height=400') and not with the CFWindow tag. Using the script with CFWindow, I will get a Javascript (Object expected) error (tried it with parent and opener). I think

Re: How would I go by doing this?

2007-08-08 Thread Steve Sequenzia
If you are using cfwindow than the window is on the same page. You should be able to use JS to control the value on the original form. Like: document.formName.name.value; Check out this demo I did: http://demo.thinksys.com/cf8/cfwindow/addContacts.cfm I think the concept is kind of the same.

RE: any idea how to

2007-08-08 Thread Scott Stewart
Alan, This worked... Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -Original Message- From: Alan Rother [mailto:[EMAIL PROTECTED] Sent:

Re: any idea how to

2007-08-08 Thread Alan Rother
Coolio.. Make sure I got the MID function right, I tossed it together real quick and it might be 5, not 4. =] On 8/8/07, Scott Stewart [EMAIL PROTECTED] wrote: Alan, This worked... Thanks sas -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616

SQL Server problem getting records within date range

2007-08-08 Thread C. B.
Hello all... I could use a little help here. I am trying to get the latest transaction date from all users within a specified date range. But the query below is giving me records from the date range for this year and last year. What the heck am I doing wrong? SELECT

Data source 'source_name' verification failed.????

2007-08-08 Thread Charles Love
I have a ColdFusion page that is accessing two different ColdFusion data sources from the same page. I have many queries that are using the first source and they all work. I have TWO queries that access the second source and one of them works and the other doesn't. They are using the same

Re: How would I go by doing this?

2007-08-08 Thread Andy Chen
Steve, that is it. Similar to what I want to do but something is weird. I still get the Javascript: Object Expected error. This means I did something stupid like typed something wrong however I don't see it, and I simplified it a lot already. This test is just to copy what is typed in the

RE: Data source 'source_name' verification failed.????

2007-08-08 Thread Loathe
Try catch the query that is throwing the error Dump the cfcatch return you'll have additional information in there like oracle error code. cftry cfquery / cfcatch type=any cfdump var=#cfcatch# /cfcatch /cftry Something like that should work.

About the GotCFM.com Site List

2007-08-08 Thread Rey Bango
Hi Everyone, Of late, I've been seeing a number of questions as to why specific sites are not on the GotCFM list. The easy answer is that they haven't been submitted. I review and approve sites fairly quickly so its not a delay from that perspective. With that said, if you see a CF site that

Re: How would I go by doing this?

2007-08-08 Thread Steve Sequenzia
Andy, Move the JS to the form_test1.cfm page. It works when you do that. Here it is: http://demo.thinksys.com/cf8/cfwindow/form_test1.cfm Are you using Firebug? As Ray Camden has told me many times, use Firebug. It is really great for this stuff. You would see that the actual error was

Re: Quick Question about upgrading to CF 8

2007-08-08 Thread Jochem van Dieten
LHWH Interactive wrote: I've looked on Adobe and I just can't find the answer to a really easy question regarding upgrading to CF8. If I've got CF 7 installed on our internal development server, and I wanna upgrade it, is it better for me to uninstall 7 before installing 8? Install CF 8 next

Re: SQL Server problem getting records within date range

2007-08-08 Thread Janet MacKay
Use the WHERE not HAVING clause. Try something like SELECT ... FROM ... WHERE dbo.tblSubscribers.SID = dbo.tblUserTransactionLog.SID ANDdbo.tblUserTransactionLog.Processed = convert(datetime, '08/01/2007', 101) AND dbo.tblUserTransactionLog.Processed = convert(datetime, '08/07/2007',

Re: How would I go by doing this?

2007-08-08 Thread Andy Chen
Steve, You are da man! Never head of Firebug but I will give it a shot. I am pretty much developing for IE so I never thought about installing Firefox. Thanks, Andy Andy, Move the JS to the form_test1.cfm page. It works when you do that. Here it is:

Lynda.com released the first official CF8. Thank you Lynda!

2007-08-08 Thread Ali Majdzadeh
Hi: Just wanted to inform you about something. I was searching for a good CF8 video tutorial and found out Lynda.com released an essential traning. It seems it covers many basic subjects. I hope they release the intermediate and advanced DVDs soon. Thank you LYNDA.COM :) i hope you folks find it

cfquery: quotes vs queryparam

2007-08-08 Thread Rick Schmitty
Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery vs cfquery select * from table where name=cfqueryparam cfsqltype=cf_sql_varchar maxlength=255 value=#form.lastname#/ /cfquery Seems anything I throw at the quoted query gets

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Jochem van Dieten
Rick Schmitty wrote: Is there anyway for someone to hack a quoted query? cfquery select * from table where name='#form.lastname#' /cfquery Depends on the database and the configuration. Seems anything I throw at the quoted query gets escaped correctly... Have you played with characters

CF8 Commonspot

2007-08-08 Thread Eric Hoffan
Anyone have commonspot here htat upgraded to CF8and still have authoring capability?If so, could you shout back even offlist...quick problem I am seeing and want to make sure its just me. LOL Eric J. Hoffman Managing Partner 1940

Re: SQL Server problem getting records within date range

2007-08-08 Thread C. W. B.
Hello Janet - thanks for the reply. I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. Thanks, CWB Use the WHERE not HAVING

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Peterson, Chris
Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone Or, if you really wanna get tricky and someone has debugging turned on, or you can guess field / table names: Lets say you have a fName and lName column outputting a list, and I can

Setting session param in onRequestStart

2007-08-08 Thread Josh Nathanson
Hey all, Had an interesting conundrum today. I wanted to param a session variable in Application.cfc, so naturally I placed the cfparam name=session.myvar default=false in onSessionStart. I quickly realized that this does not catch people whose sessions are already in progress. Since we

Re: CF8 Commonspot (solved)

2007-08-08 Thread Eric Hoffan
RTFM. Hmm. Sorry about the list pollution. On 8/8/07 2:14 PM, Eric Hoffan [EMAIL PROTECTED] wrote: Anyone have commonspot here htat upgraded to CF8and still have authoring capability?If so, could you shout back even offlist...quick problem I am seeing and want to make sure its

Error when using Java class in Cold Fusion

2007-08-08 Thread Tripura Kondabala
Hello Every one I am getting the following error in my Coldfusion code . The error is as follow === Class coldfusion.runtime.java.JavaProxy can not access a member of class Search1 with modifiers My cold fusion code is as follow === cfobject type = Java action = Create class = Search1

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Bryan Stevenson
Have you played with characters your database considers escape characters? Do you know which characters that are? Do you know which characters that will be for every database your application will ever run on? Have you played with characters CF does not consider escape characters because CF

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Andy Matthews
Pete Freitag had an amazing session at CFUinted about things like this. It's amazing what can be done using the query string. -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 2:17 PM To: CF-Talk Subject: RE: cfquery: quotes vs

RE: Error when using Java class in Cold Fusion

2007-08-08 Thread Gaulin, Mark
CF won't create the actual java object until you call it, so the lack of an error on the cfobject line may not mean that part went 100% right. Things to check: * The class itself needs to be declared as public (so, public class ) * Your class needs to have a public no-argument constructor (or

Re: SQL Server problem getting records within date range

2007-08-08 Thread Janet MacKay
I should have mentioned that I need to get only the most recent transaction for each user within the given time-frame. That's why I am using max(). Using this aggregate function, I think, requires I use having, no?. No, if I'm understanding correctly its not required here. The WHERE

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Justin Scott
Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone ColdFusion would escape that single quote, rendering this attempt pretty much useless and data'z would still be there. I'm not suggesting that you shouldn't use CFQUERYPARAM wherever

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Gaulin, Mark
I'm not seeing how your example would do anything other than find zero records... Start with: cfqueryselect from table where lastname = '#form.lastname#'/cfquery Use your example: Form.lastname = test'; DROP TABLE table; So you get (with quote-doubling) select from table where lastname = '

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Rick Schmitty
Well thats the thing, I know I should use cfqueryparam but the quoted string wont let commands through I made a test table and tried to hack it (with something that wouldnt delete but would prove sql injection) http://localhost/test.cfm?name=rick%20or%201=1 etc, but query 2 will just return an

action pages

2007-08-08 Thread Katie Miller
I think this is mostly because I'm not thinking clearly today. I have a form where the fields are generated by a query a loop. I want the results of the form emailed to someone but I'm having a little trouble how to get the list into the email form. Katie

Re: action pages

2007-08-08 Thread Crow T. Robot
i think you're looking for FORM.fieldnames ? On 8/8/07, Katie Miller [EMAIL PROTECTED] wrote: I think this is mostly because I'm not thinking clearly today. I have a form where the fields are generated by a query a loop. I want the results of the form emailed to someone but I'm having a

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Bryan Stevenson
OKlet's all agree to disagree about added security from CFQUERYPARAM (even though it does add security...na na na boo boo) ;-) Just remember it also: -allows for additional maxlength validation (beyond your form inputs) -uses BIND vars with DBs that support them to speed up queries -adds

Re: Data source 'source_name' verification failed.????

2007-08-08 Thread Charles Love
Thanks, Loathe...That did it!! I got all the info I needed to solve the problem. Turns out I had different data sources within the same cftransaction and that is a CF error. I was catching the error but only showing the message. The cfcatch.Detail shows the REAL reason for the error

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Ian Skinner
http://localhost/test.cfm?name=rick%20or%201=1 Was this an invitation to demonstrate techniques? If so, localhost ain't going to work for anybody else. If not, never mind. But I too would like to know more details about how this actually happens. I trust that I should use cfqueryparam...

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Ian Skinner
but it isn't like cfquery without it is necessarily an open door (if you're consistent). Mark Well not that open, unless somebody has opened the door with preserveSingleQuotes() for some reason. But one would hope that this was done with a clear purpose and understanding of the risks and

Re: action pages

2007-08-08 Thread koen darling
Something like this should work: cfmail...type=html... cfloop collection=#form# item=field #field#: #form.[field]#br / /cfloop /cfmail Koen ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features -

Develop an ecommerce site in CFMX 7 using Paypal

2007-08-08 Thread Prema Sekar
Hi All, This is my first ecommerce application using Paypal in CFMX7. I am using Ben Forta's CFWACK book as my reference. I have downloaded the PayflowPro SDK by creating a test account in PayPal. But I couldnot download the .jar file. Could anybody please help me with the steps to be

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Ian Skinner
.just use the dang tag and it's all good ;-) Cheers I do, but that doesn't mean I don't want to know more how SQL injection actually works and how cfqueryparam... is mitigating this risk. Just to make myself a more knowledge person. No it has nothing to do with that site that fired me

Re: SQL Server problem getting records within date range

2007-08-08 Thread Janet MacKay
Yes, that looks correct. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive:

Re: SQL Server problem getting records within date range

2007-08-08 Thread C. W. B.
Hello again Janet, thank you for your help on this. It suare has had me stumped. So, like this? SELECT dbo.tblSubscribers.SID, dbo.tblSubscribers.Username, max(dbo.tblUserTransactionLog.Processed) AS LastTransaction FROM dbo.tblSubscribers, dbo.tblUserTransactionLog

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Gaulin, Mark
I hear you, but cfqueryparm was historically not all good... It disables query caching via cachedwithin. This was always a frustrating limitation and my understanding is that is has been fixed in CF8 but I haven't played with cf8 yet to know for sure. Query parameter binding also has

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Rick Schmitty
Oh no, I agree (the null is my fav of cfqueryparam). This was just a case of inheriting a large pile of code w/o cfqueryparams and the guy used '#quotedvars#' for his strings (and IDs for the matter) and me wanting to feel better about not trying to convert it all over... :) On 8/8/07, Bryan

Re: Develop an ecommerce site in CFMX 7 using Paypal

2007-08-08 Thread Rey Bango
The PayPal SDK can be daunting to work with. I would recommend contacting Jared Rypka-Hauer about his PayPalMX components. You can get more info here including Jared's email: http://www.web-relevant.com/blogs/cfobjective/index.cfm?mode=entryentry=83AEB42F-BDB9-5320-E0207DD531806BA8 Rey...

Re: cfquery: quotes vs queryparam

2007-08-08 Thread Jochem van Dieten
Gaulin, Mark wrote: I hear you, but cfqueryparm was historically not all good... It disables query caching via cachedwithin. This was always a frustrating limitation and my understanding is that is has been fixed in CF8 but I haven't played with cf8 yet to know for sure. It is. I wish CF

RE: Quick Question about upgrading to CF 8

2007-08-08 Thread Eric Roberts
It's always better to do a clean install...but CF 8 will also import setting from CF7 (and I believe 6). Eric -Original Message- From: LHWH Interactive [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 8:37 AM To: CF-Talk Subject: Quick Question about upgrading to CF 8 I've

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Dave Watts
I wish CF could allow the use of the cfqueryparam tag without all of the other side-effects (using binding, disabling caching) so that we really could say *always* use it... Binding is not a side-effect, it is exactly what CFQUERYPARAM does. CFQUERYPARAM creates bound parameters. Dave

RE: Eclipse/CFEclispe

2007-08-08 Thread Eric Roberts
Welcome to the dark side Robert :-D hehehe Pretty soon I will be running that with Windows Server 2008 Beta...they just shipped that out with the Microsoft Action pack Quarterly update. I love SQL Server 2005...very nice interface. It took a lil bit to get used to...first time I used it it was

RE: cfquery: quotes vs queryparam

2007-08-08 Thread Dave Watts
Are you kidding??? I just replace form.lastname with:test'; DROP TABLE table; Poof, your data'z are gone ColdFusion would escape that single quote, rendering this attempt pretty much useless and data'z would still be there. I'm not suggesting that you shouldn't use

  1   2   >