Re: Sean Corfield left Adobe (was: Project Time Tracking Software?

2007-05-24 Thread Sean Corfield
On 5/23/07, Adam Churvis [EMAIL PROTECTED] wrote: Best of luck with everything, Sean. Give me a link to your resume and I'll try to send people your way. http://corfield.org/resume (surprisingly :) What is the nature of your health promotion service? Sounds intriguing. You'll have to wait

RE: An OO Too Far?

2007-05-24 Thread Robert Rawlins - Think Blue
Thanks for all the advice on this Guys, I DID end up encapsulating this in its own object. It's true that some of the functions are just wrappers for other cffunctions but I also found myself coding more complex items like conditional loops to count elements of the array with particular

RE: Load Testing

2007-05-24 Thread Robert Rawlins - Think Blue
This Load Testing is very intriguing stuff, something I've not considered doing until this topic came up. How does this stuff work with user authentication? The large majority of my application (all except one lonely cfm) are behind my authentication system, is this passler software (or any of

Re: An OO Too Far?

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Robert Rawlins - Think Blue wrote: should this be an array of structs? Or can you perhaps do an array of product.cfc objects? Hehe, it's like the old proverb which I believe goes The latter. In an ideal world, Cart needs to know nothing about how Product works. -- Tom

RE: An OO Too Far?

2007-05-24 Thread Robert Rawlins - Think Blue
I always suspected that was the case, I'm lucky enough not to have to work with e-commerce but it's always nice to know how it works in 'theory'. Thanks Tom, Rob -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 24 May 2007 09:23 To: CF-Talk Subject: Re: An OO Too

Re: Load Testing

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Robert Rawlins - Think Blue wrote: How does this stuff work with user authentication? The large majority of my application (all except one lonely cfm) are behind my authentication system, is this passler software (or any of the others) able to work around that if I

Granular Security Model

2007-05-24 Thread Robert Rawlins - Think Blue
Hello Chaps, I'm currently working on an overhaul for my security/authentication model and finally reached the core element, which is the granular permissions. I've seen several different solutions for achieving this kind of thing and thought I'd try and see what everyone here does for their

RE: Load Testing

2007-05-24 Thread Robert Rawlins - Think Blue
That's great Tom, Just out of interest which tool are you using Tom? I've downloaded the trial edition of the Pasler one this morning and it seems to run very nicely and give me a decent level of feedback. Thanks. Rob -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED]

Re: Granular Security Model

2007-05-24 Thread James Holmes
This could be normalised so that there is a user table, an enlitlement table and an m:n joining table between them (user_entitlement or similar). This way only a true (1) is indicated in the DB and you can assume false for everything else (inlcuding when initialising the struct in CF). On

Re: An OO Too Far?

2007-05-24 Thread Andrew Scott
Well as one of our senior head java guys says, if you can instantiate it then it can be an object / class if not then leave it. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 On 5/24/07, Robert Rawlins - Think Blue [EMAIL

RE: Renaming Files with CFFILE

2007-05-24 Thread Bobby Hartsfield
There's all kinds of stuff available when you upload a file. cffile.serverFileExt will hold the extension Dump #cffile# for the rest #listlast(filename, .)# will get you the extension too ;-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message-

DataSource Help

2007-05-24 Thread D Suresh
Hi All, I am unable to create Datasource in CF Server. It hrows the following errors. Pls Help me ..! Thanks in advance. Ps: I had created a database in SQL Server 2000 as Test and I am using the same in CF server for creation. Regards Suresh

RE: Granular Security Model

2007-05-24 Thread Robert Rawlins - Think Blue
Ok I think I see what you're getting at their James, This would be a combination of the two solutions? Using the normalization in the database with a linking table that joins my users to the entitlements, which was the same I had with the array but instead of populating the array, simply build

RE: DataSource Help

2007-05-24 Thread D Suresh
sorry image not attached From: D Suresh [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com To: CF-Talk cf-talk@houseoffusion.com Subject: DataSource Help Date: Thu, 24 May 2007 12:10:20 + Hi All, I am unable to create Datasource in CF Server. It hrows the following errors. Pls

RE: DataSource Help

2007-05-24 Thread D Suresh
The Error msg is: Connection verification failed for data source: TestDB java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket.

Re: DataSource Help

2007-05-24 Thread srinivas ganta
Hi Suresh Hope this URL helps u to sort out the connection problem. http://livedocs.adobe.com/coldfusion/6.1/htmldocs/dataso12.htm Thanks Srinivas On 5/24/07, D Suresh [EMAIL PROTECTED] wrote: The Error msg is: Connection verification failed for data source: TestDB java.sql.SQLException:

Re: Load Testing

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Robert Rawlins - Think Blue wrote: Just out of interest which tool are you using Tom? I've downloaded the trial edition of the Pasler one this morning and it seems to run very nicely and give me a decent level of feedback. We don't, actually, load test (yeah, I know,

Re: DataSource Help

2007-05-24 Thread Jim Wright
On 5/24/07, D Suresh [EMAIL PROTECTED] wrote: The Error msg is: Connection verification failed for data source: TestDB java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException:

Re: CFDirectory Help

2007-05-24 Thread Joel Watson
Thanks for the tip--this UDF is pretty cool. Unfortunately, it doesn't solve my problem, for even if it returns false, the cfdirectory tag continues to be run, throwing an error when the directory exists. For whatever reason, I am having difficulty getting it to bypass this cfdirectory tag

Re: DataSource Help

2007-05-24 Thread Gert Franz
Hi Suresh, I had this issue with Railo and MX as well. The reason was that since I had service pack 2 of Windows XP installed I had to upgrade SQL Server to service pack 4 (although SP3 was sufficient). Something in the authorization checkings had changed... Mark Drew had a blog entry on this

Re: CFDirectory Help

2007-05-24 Thread Teddy R Payne
Joel, I usually create a variable to hold the value of the directory that I want to exist. ei. c:\pathtofile\directoryIwanttocreate After I create the string, I have a common method in a a file CFC like this: cffunction name=createDirectory access=private output=false returntype=void

Re: Renaming Files with CFFILE

2007-05-24 Thread Claude Schneegans
you put in place, somebody comes up with *something* that mucks up the works and refuses to do it right The last I saw in this category was somebody who absolutely wanted to enter several values in a text field using the Enter key in order to enter several lines... Of course, this submit the

Re: Image Re-Sizing

2007-05-24 Thread Rick Root
On 5/23/07, Greg Luce [EMAIL PROTECTED] wrote: I just used this one from Mossimo Foti the other day. Worked great. http://www.olimpo.ch/tmt/cfc/tmt_img/ Is Massimo's freely redistributable? That's the main reason I wrote my own (based on Jim Dew's original work), because I wanted something I

Re: Image Re-Sizing

2007-05-24 Thread Massimo Foti
Is Massimo's freely redistributable? That's the main reason I wrote my own (based on Jim Dew's original work), because I wanted something I could include in any software I wanted to redistribute/sell.. If it is that's great. and if it's not and you don't need to distribute it, that's great

Re: Renaming Files with CFFILE

2007-05-24 Thread Les Mizzell
The last I saw in this category was somebody who absolutely wanted to enter several values in a text field using the Enter key in order to enter several lines... Mine was a client with an admin for their image gallery. It was set up for a main image and a thumb. First round was my mistake.

Re: CFID-CFTOKEN Major Issues. HELP!!!!

2007-05-24 Thread Asad Khan
I am having a huge problem right now, I have an application where I am using CFID/Cftoken as part of URL parameter. They are currently being maintained in the registry. As an aside, you really don't want to store client data in the registry. Use a database instead. What is the underlying

RE: CFID-CFTOKEN Major Issues. HELP!!!!

2007-05-24 Thread Adkins, Randy
Is there a message (comments) in here I am missing?? -Original Message- From: Asad Khan [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 10:26 AM To: CF-Talk Subject: Re: CFID-CFTOKEN Major Issues. HELP I am having a huge problem right now, I have an application where I am

Re: CFID-CFTOKEN Major Issues. HELP!!!!

2007-05-24 Thread Asad Khan
Hi Dave: First of all thank you for your suggestions. I ahve couple of questions here. I have one app that is pointing to registry and one pointing to datasource. I know that data source is the correct way of handling. I notice the app where the admin is set to datasource, and when i look in

insert error

2007-05-24 Thread Daniel Kessler
I've been at this for awhile and I just don't see the error. The error is: ORA-00936: missing expression which leads me to believe I have the wrong number of values, but in checking and rechecking and rechecking, I don't see the problem. I even gave up on the loop and wrote it all

Re: insert error

2007-05-24 Thread Doug Bezona
It's probably your tmp_line list. If a list has empty items, CF drops it completely, so this list: 1||2|3|4||5 only has 5 items as far as CF is concerned - you may realize this, since you seem to be adding spaces with the replace() function, but I'm fairly sure a space isn't sufficient to keep CF

Re: Renaming Files with CFFILE

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Les Mizzell wrote: We just need to be able to export directly out of the camera. How did the ratio ever get broken then ? -- Tom Chiverton Helping to enormously deliver cross-media design-patterns on: http://thefalken.livejournal.com

Re: CFID-CFTOKEN Major Issues. HELP!!!!

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Asad Khan wrote: what will this do by setting url.cfid=client.cfid. If I do this and a url.cfid= *cookie*.cfid would be better. client still emails the entire link with these id/token in the URL, will I still have the same issue... No, the ones in the actual URL in

Re: insert error

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Daniel Kessler wrote: ORA-00936: missing expression which leads me to believe I have the wrong number of values, but in checking and rechecking and rechecking, I don't see the problem. I even gave up on the loop and wrote it all out. Turn debugging on and see what

Quick question about character sets

2007-05-24 Thread Christopher Jordan
Can someone please explain to me what is gained by doing something like this: cfset setEncoding(form,utf-8) cfset setEncoding(url,utf-8) I've never concerned myself with character sets, and everything seems to be okay for me. Are there any risks to *not* doing this? Thanks, Chris --

RE: Renaming Files with CFFILE

2007-05-24 Thread Andy Matthews
If you resize an image to 100x150 it'll skew the ratio unless you crop it. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 10:02 AM To: CF-Talk Subject: Re: Renaming Files with CFFILE On Thursday 24 May 2007, Les Mizzell wrote: We just

Re: insert error

2007-05-24 Thread Bryan Stevenson
On Thursday 24 May 2007, Daniel Kessler wrote: ORA-00936: missing expression which leads me to believe I have the wrong number of values, but in checking and rechecking and rechecking, I don't see the problem. I even gave up on the loop and wrote it all out. Not necessarily the wrong

Re: Renaming Files with CFFILE

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Andy Matthews wrote: If you resize an image to 100x150 it'll skew the ratio unless you crop it. Easy and obvious solutions include resizing to something slightly different (102x147) but with the same aspect, or using CSS to do the cropping if the CF solution can't.

Coldfusion MX 7 File System Gateway

2007-05-24 Thread Dan Munez
Hey guys I was reading up on this feature and was wonderin if any of you might know more about it. Would I be able to access event and error logs and application logs. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience

Re: Coldfusion MX 7 File System Gateway

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Dan Munez wrote: Hey guys I was reading up on this feature and was wonderin if any of you might know more about it. Would I be able to access event and error logs and application logs. Where from ? -- Tom Chiverton Helping to globally aggregate bricks-and-clicks

Re: Moving from CF5 on Windows to CFMX on Linux

2007-05-24 Thread Adrian Moreno
I started to write a reply and decided to just post it to my blog: http://www.iknowkungfoo.com/blog/index.cfm/2007/5/24/Moving-Coldfusion-applications-from-Windows-to-Linux I didn't address CFX tags though. IIRC, you may need versions of those tags that have been compiled on Linux. If the CFX

Re: Coldfusion MX 7 File System Gateway

2007-05-24 Thread Dan Munez
from the event viewer in windows? :) ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive:

Re: An OO Too Far?

2007-05-24 Thread Brian Kotek
I agree with Tom. Since (unless your store is very unusual) the cart will only have a few products in it, there is really no problem with holding Product instances in the Cart. On 5/24/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Thursday 24 May 2007, Robert Rawlins - Think Blue wrote:

Is this a CF bug?

2007-05-24 Thread Tony
Strange cfloop behaviour, that i'm not sure, isnt a coldfusion bug. cf7 and another unnamed version :) i see the same behaviour... 1. i have a query that returns a small recordset, 15 records 2. i have a cfloop that runs through that recordset, and for each record, it performs a cfquery gets

RE: Renaming Files with CFFILE

2007-05-24 Thread Andy Matthews
A good alternative would be to resize the original to something just larger than 100x150, say 105x150 or 100x154 (whichever site is longest), then crop the remaining pixels to fit the intended size. Once the photo is that small they're not going to notice much difference between 150 pixels and 154

Re: insert error

2007-05-24 Thread Teddy R Payne
Get the output of one iteration of the insert statement by outputting the end result of the SQL. Take the SQL statement and execute it directly against your DB. If the insert works fine, it may be how you handle different data types. If it continues to elude you and you are comfortable with

Re: CFID-CFTOKEN Major Issues. HELP!!!!

2007-05-24 Thread Asad Khan
Please expand on this. I am a newly admin on CF, background is DB, so any suggestions on what I need to do and where those would be applied in the code. If you can provide explicit code for me to totally eliminate the use of Tokens in the URL.. I want to get the cfid/cftoken out my urls and

Re: Is this a CF bug?

2007-05-24 Thread Tom Chiverton
On Thursday 24 May 2007, Tony wrote: Strange cfloop behaviour, that i'm not sure, isnt a coldfusion bug. It would help if you had a small test case piece of code. -- Tom Chiverton Helping to dynamically introduce open-source patterns on: http://thefalken.livejournal.com

Re: CFID-CFTOKEN Major Issues. HELP!!!!

2007-05-24 Thread Asad Khan
Please expand on this. I am a newly admin on CF, background is DB, so any suggestions on what I need to do and where those would be applied in the code. If you can provide explicit code for me to totally eliminate the use of Tokens in the URL.. I want to get the cfid/cftoken out my urls and

Re: Is this a CF bug?

2007-05-24 Thread Bryan Stevenson
Sounds normal to me (if I'm reading you right), but post your code and we'll know for sure ;-) Typically if you need a value from an outer loop in an inner loop, you MUST set a var in the outer loop to be used in the inner loopif not you'll get what you seem to have described. Cheers

Re: Is this a CF bug?

2007-05-24 Thread Barney Boisvert
The only scope of higher-precedence than field of the current row in a recordset being looped over are local variables within a UDF/CFC method. If you're within multiple recordset loops, the innermost has highest priority, and references to fields from loops outside the innermost must be fully

WebServices - XML Object sent as argument not working correctly

2007-05-24 Thread Ken Sykora
Hi Everyone - I posted this on the Adobe forums but have so far had no luck with any responses. I'm having trouble with coldfusion web services and am hoping that someone here can reproduce this error and provide some insight to this issue. I'm trying to create a web service, and in the web

Re: Moving from CF5 on Windows to CFMX on Linux

2007-05-24 Thread Jochem van Dieten
Adrian Moreno wrote: I started to write a reply and decided to just post it to my blog: http://www.iknowkungfoo.com/blog/index.cfm/2007/5/24/Moving-Coldfusion-applications-from-Windows-to-Linux ISTM you are generalizing your experiences with MySQL Linux to databases Linux. The majority of

CFIF and suppressing a register button if event_date is in the past

2007-05-24 Thread Elaine Mingus
I have an example: a href=http://www.robertstrausscenter.org/Newsite/events_details.cfm?ID=20http://www.robertstrausscenter.org/Newsite/events_details.cfm?ID=20/a This event was on April 22, 2007 so it no longer needs the registration button, but since the page is used for other events that

RE: CFIF and suppressing a register button if event_date is in the past

2007-05-24 Thread Adkins, Randy
Take a look at the DateDiff function. You can use that to accomplish your task. -Original Message- From: Elaine Mingus [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 12:03 PM To: CF-Talk Subject: CFIF and suppressing a register button if event_date is in the past I have an

Re: Moving from CF5 on Windows to CFMX on Linux

2007-05-24 Thread Jochem van Dieten
Jim McAtee wrote: We're going to be undertaking a long-overdue upgrade from CF5 to CFMX 7.1. At the same time we're considering moving from a Win2k server with IIS to Linux and Apache. Most of our data is in MySQL. But another issue we face is that a couple of legacy applications use

Re: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Robertson-Ravo, Neil (RX)
There is a bug/feature of ColdFusion web services when passing/returning XML objects. It is better practice to pass the data as a string however as it leads to better interop. Bottom line, if you want to pass XML, pass it as a string. This e-mail is from Reed Exhibitions (Gateway House, 28

RE: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Robert Rawlins - Think Blue
Yep I'll back Niel on this one, I pass XML as a string through web services all the time and it works like an absolute charm. I talk with all kinds of other apps from JAVA through to Python and C. Rob -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent:

Re: Coldfusion MX 7 File System Gateway

2007-05-24 Thread Robertson-Ravo, Neil (RX)
You mean Window evt logs? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the

Re: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Robertson-Ravo, Neil (RX)
Yep, the key is to understand that a ColdFusion XML object is just that... A ColdFusion one, so in all reality it's useless to anyone else other than ColdFusion and even then, only really on your own servers (as I have seen remote calls fail as well). XML is just a well formed string so best to

RE: Moving from CF5 on Windows to CFMX on Linux

2007-05-24 Thread Damien McKenna
-Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 12:33 PM Subject: Re: Moving from CF5 on Windows to CFMX on Linux No you shouldn't. Access + Linux == hell I went through that on my Mac once, was trying to do local development

Re: insert error

2007-05-24 Thread Jochem van Dieten
Daniel Kessler wrote: ORA-00936: missing expression !--- tmp_line is read in else where, then in the following lines made into an array --- cfset tmp_line = 12/2/2004|20:38:25|[EMAIL PROTECTED]|annteeka| gilmore|2|2|1|2|2|2|3|1|2|1|3|2||1|1|11|1 cfset tmp_line =

insert error

2007-05-24 Thread Daniel Kessler
Get the output of one iteration of the insert statement by outputting the end result of the SQL. Take the SQL statement and execute it directly against your DB. If the insert works fine, it may be how you handle different data types. I can't output the end-result. I put in debug=yes and

Re: CFIF and suppressing a register button if event_date is in the past

2007-05-24 Thread Josh Nathanson
cfif DateCompare(eventdate,Now(),d) is -1 suppress button /cfif -- Josh - Original Message - From: Elaine Mingus [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, May 24, 2007 9:03 AM Subject: CFIF and suppressing a register button if event_date is in the past I

Re: Possibly OT: Google stopped indexing site

2007-05-24 Thread Richard Cooper
Seen some mentions to id= causing unusual problems, this could be due to the fact that historically, Google treats that exact perameter as a session variable. They used to recommend not using it in their webmaster guidelines (couldn't see it though when I just looked). As for being dropped

Re: Coldfusion MX 7 File System Gateway

2007-05-24 Thread Sean Corfield
On 5/24/07, Dan Munez [EMAIL PROTECTED] wrote: Hey guys I was reading up on this feature and was wonderin if any of you might know more about it. Would I be able to access event and error logs and application logs. Do you mean the DirectoryWatcher event gateway? Michael D has done a lot of

Re: Is this a CF bug?

2007-05-24 Thread Sean Corfield
On 5/24/07, Bryan Stevenson [EMAIL PROTECTED] wrote: Sounds normal to me (if I'm reading you right), but post your code and we'll know for sure ;-) Typically if you need a value from an outer loop in an inner loop, you MUST set a var in the outer loop to be used in the inner loopif not

Re: [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed

2007-05-24 Thread Fernando Richter
Hi I am getting the following error everytime i try to run the query below from the coldfusion page. [Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. cfquery name=offerreport datasource=#placement#

Re: Is this a CF bug?

2007-05-24 Thread Aaron Rouse
An annoying quirk for scoping nazis at that. This exact thing bit one of us here this week. On 5/24/07, Sean Corfield [EMAIL PROTECTED] wrote: On 5/24/07, Bryan Stevenson [EMAIL PROTECTED] wrote: Sounds normal to me (if I'm reading you right), but post your code and we'll know for sure ;-)

Re: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Ken Sykora
Thank you both for the quick responses. I greatly appreciate your help. I understand what you're saying with this response, but when I pass over XML as a string to coldfusion, it converts the xml string in the SOAP message to an HTML encoded format (i.e. will become %lt; will become %gt;) which

Re: Project Time Tracking Software?

2007-05-24 Thread Jordan Michaels
Hi Bobby, Well... alright. I guess my point of the post was to say that sometimes you just need to roll your own. =P However, sure. I can set up a log-in for CF-Talk users. Not a problem. http://www.viviotech.net/timesheet2/index.cfm user - cftalk pass - cftalk org# - 1015 We haven't tested

Re: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Robertson-Ravo, Neil (RX)
You don't need to ToString the XmlObject it already is a string. If anything you should be using XMLParse() on the incoming argument. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in

RE: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Brad Wood
Is it just me, or does this whole conversation tie into the fact that CF XML Objects don't serialize for session replication? I'm assuming that the fact they don't serialize automatically (with out the programmer applying a tostring()) is the same reason they don't send properly as arguments to a

RE: Project Time Tracking Software?

2007-05-24 Thread Damien McKenna
-Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 1:31 PM Subject: Re: Project Time Tracking Software? http://www.viviotech.net/timesheet2/index.cfm user - cftalk pass - cftalk org# - 1015 Nice. I'm in yur site steelin yur codez.

Re: insert error

2007-05-24 Thread daniel kessler
Daniel Kessler wrote: ORA-00936: missing expression !--- tmp_line is read in else where, then in the following lines made into an array --- cfset tmp_line = 12/2/2004|20:38:25|[EMAIL PROTECTED]|annteeka| gilmore|2|2|1|2|2|2|3|1|2|1|3|2||1|1|11|1 cfset tmp_line =

RE: Is this a CF bug?

2007-05-24 Thread Ian Skinner
Sean A. Corfield: Agreed. It looks like odd behavior on the surface but CF has pretty much always behaved that way as far as I know. cfloop query=outer . cfset somevar = outer.somecol / cfloop query=inner . reference somevar ... /cfloop . /cfloop You can't reference outer.somecol

RE: Project Time Tracking Software?

2007-05-24 Thread Peterson, Chris
Jordan, Very slick looking =) thanks for taking the time to hook us up, sometimes I just like to see what other people have done to spark idea's in completely un-related projects. Chris -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007

Re: Sean Corfield left Adobe (was: Project Time Tracking Software?

2007-05-24 Thread John C. Bland II
Congrats on the new move Sean. I'm sure you'll do well. On 5/24/07, Sean Corfield [EMAIL PROTECTED] wrote: On 5/23/07, Adam Churvis [EMAIL PROTECTED] wrote: Best of luck with everything, Sean. Give me a link to your resume and I'll try to send people your way. http://corfield.org/resume

Re: WebServices - XML Object sent as argument not working correct ly

2007-05-24 Thread Robertson-Ravo, Neil (RX)
I wouldn't assume so no. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for

Re: insert error

2007-05-24 Thread Teddy R Payne
What I was referring to was to output the string and not execute the end result SQL. Create a temporary variable that holds a string that you create, so that you capture the SQL that you would normally execute. At that point, you put the variable to see how the SQL would have executed and

Re: insert error

2007-05-24 Thread daniel kessler
Well, that did work and it worked through a few entries, so I suspect that it's reasonably sound now. BUT, it's breaks down on third entry with a missing comma entry again. Back to debugging... oh the entry looks like (nothing special): 1/7/2005|21:25:05|[EMAIL

Re: insert error

2007-05-24 Thread daniel kessler
I suppose then that I don't know how to get the end result of the sql without running the sql. Any assistance would be useful. What I was referring to was to output the string and not execute the end result SQL. Create a temporary variable that holds a string that you create, so that you

password form not working -- strange

2007-05-24 Thread Bobby Tomato
Strange problem... I'm trying to create a simple password form. Once the user presses the submit button, the ColdFusion code has a conditional to see if the field contained the password or not, and then execute some code. Here's what's happening: if I type in the password, the conditional

RE: insert error

2007-05-24 Thread Ian Skinner
Something like this: cfsaveContent var=theSQL SELECT ... FROM ... WHERE ... GROUP BY ... ORDER BY ... /cfsaveContent cfquery ... #theSQL# /cfquery Add cfoutputs as required. Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and

Re: insert error

2007-05-24 Thread daniel kessler
ah, thank you very much Something like this: cfsaveContent var=theSQL SELECT ... FROM ... WHERE ... GROUP BY ... ORDER BY ... /cfsaveContent cfquery ... #theSQL# /cfquery Add cfoutputs as required. Confidentiality Notice: This message including any attachments is for the sole use of the

dreamweaver 8

2007-05-24 Thread Bader, Terrence C CTR MARMC, 231
ok, recently started working with DW 8 vs 7/mx that I have used for a long while now. In the old version I could hit my surround # key and type with the cursor on the inside of the #s, but now in 8 it puts the cursor outside of the #s. I find this quite annoying. Does anyone know if I missed a

Re: Is this a CF bug?

2007-05-24 Thread Tony
i think thats what sean said, kinda :) but, either way, it makes SENSE, its just weird. and something that kinda bit us in the behind a bit, however, its easy to code around, and now that i know it, it wont again. sounds like a good blog post. tw On 5/24/07, Ian Skinner [EMAIL PROTECTED] wrote:

Re: insert error

2007-05-24 Thread daniel kessler
Well, that did work and it worked through a few entries, so I suspect that it's reasonably sound now. BUT, it's breaks down on third entry with a missing comma entry again. Back to debugging... OK, I have Teddy's suggestion going and the one that's giving the missing comma problem is

Re: insert error

2007-05-24 Thread Jochem van Dieten
Daniel Kessler wrote: Get the output of one iteration of the insert statement by outputting the end result of the SQL. Take the SQL statement and execute it directly against your DB. If the insert works fine, it may be how you handle different data types. I can't output the end-result.

RE: Granular Security Model

2007-05-24 Thread Porter, Benjamin L.
I prefer something similar to what James mentioned but with the addition of groups or roles. The groups or roles would have a member table joining them 1 group/role to many permissions. A user could have either roles, and or permissions. If they had the role they by proxy had all the permissions

RE: insert error

2007-05-24 Thread Huff, Jerome P.
Your text values in the query need to have single quote around them. -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, May 24, 2007 2:20 PM To: CF-Talk Subject: Re: insert error Well, that did work and it worked through a few entries, so I suspect

RE: Is this a CF bug?

2007-05-24 Thread Ian Skinner
Tony: i think thats what sean said, kinda :) Well Sean said You can't reference outer.somecol directly inside the inner loop and I said One can reference the outer query so in that respect I think we rather said the opposite. But your general gist is correct. This is just one of those places

Re: insert error

2007-05-24 Thread daniel kessler
Oh man, how simple. Thank you very much Jerome. I guess this goes to show that Bryan's assessment was right. thank you everyone. hopefully, I won't bring this up again. Your text values in the query need to have single quote around them. -Original Message- From: daniel kessler

Re: Is this a CF bug?

2007-05-24 Thread Sean Corfield
On 5/24/07, Ian Skinner [EMAIL PROTECTED] wrote: One can reference the outer query but one can not do it relying on the generic current row. One has to fully qualify the outer query with its own current row value, or some other row value that makes sense to what one is trying to do. I didn't

Re: Sean Corfield left Adobe (was: Project Time Tracking Software?

2007-05-24 Thread Sean Corfield
On 5/24/07, John C. Bland II [EMAIL PROTECTED] wrote: Congrats on the new move Sean. I'm sure you'll do well. Thanx. It's interesting being on the other side of the fence as an Adobe customer and freelance CFer :) -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/

Re: dreamweaver 8

2007-05-24 Thread Cutter (CFRelated)
Not sure, but I know CFEclipse functions as you would expect it;) Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Bader, Terrence C CTR MARMC, 231 wrote: ok, recently started working

Session variables and cookies

2007-05-24 Thread Curt Schryver
Okay, I've searched the archives but want to get it straight. I've built a shopping cart using session variables. But, it looks like if a user has cookies turned off, the cart won't retain the contents. Is this correct? I've also read about using URLSessionFormat, but seen some posting that it

RE: Possibly OT: Google stopped indexing site

2007-05-24 Thread Will Swain
Hi Richard, That's the strange thing - they weren't in the index. There were 4 results, 3pdfs and 1 excel spreadsheet. Any .cfm or .htm pages had been dropped. Cheers w -Original Message- From: Richard Cooper [mailto:[EMAIL PROTECTED] Sent: 24 May 2007 17:54 To: CF-Talk Subject: Re:

Re: Possibly OT: Google stopped indexing site

2007-05-24 Thread Richard Cooper
What's the url? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive:

Re: Session variables and cookies

2007-05-24 Thread Josh Nathanson
Okay, I've searched the archives but want to get it straight. I've built a shopping cart using session variables. But, it looks like if a user has cookies turned off, the cart won't retain the contents. Is this correct? Yes, if you are not passing the CFID and CFTOKEN with a request, and

Re: Session variables and cookies

2007-05-24 Thread Robertson-Ravo, Neil (RX)
You will need to pass the cfid/token with every request if cookies are expected to be off. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains

  1   2   >