Re: Product ID - enterprise level application

2009-06-12 Thread Dave Watts
Nothing to do with security measures for me.  Many times I simply don't want anyone accessing another record in the database.  I am sure that you can imagine that type of scenario, in case not An example would be for an emailed order confirmation with a link back to their order

Re: Product ID - enterprise level application

2009-06-12 Thread Peter Boughton
(in this case the client does not want someone to fill out user details and create an account for their own reasons) By using an integer it would be extremely easy for someone to view other order details Doesn't require a UUID as the PK, just something unique and unpredictable for that piece

Re: Product ID - enterprise level application

2009-06-12 Thread Jochem van Dieten
On Fri, Jun 12, 2009 at 9:59 AM, Dave Watts wrote: An example would be for an emailed order confirmation with a link back to their order details.(in this case the client does not want someone to fill out user details and create an account for their own reasons)  By using an integer it would

CFHTTP / CSV / Hot Fix for YouTube

2009-06-12 Thread Adam Bridgeman
I've updated my server with the http://kb2.adobe.com/cps/406/kb406660.html hot-fix as I want to use the YouTube API. The problem is that a simple use of CFHTTP to read a .csv file that used to work no longer does. I get an 'Attribute validation error for tag cfloop' when I try to loop over

Re: Product ID - enterprise level application

2009-06-12 Thread Tom Chiverton
On Friday 12 Jun 2009, Ryan Letulle wrote: An example would be for an emailed order confirmation with a link back to their order details. ... By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. But surely your getOrderFromOrderId()

Re: Product ID - enterprise level application

2009-06-12 Thread Ryan Letulle
Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. BTW I am not talking about guarding Fort Knox here. -- Ryan LeTulle On Fri, Jun 12, 2009 at 4:21 AM,

Re: Product ID - enterprise level application

2009-06-12 Thread Ryan Letulle
Doesn't require a UUID as the PK, just something unique and unpredictable for that piece of functionality, which could be derived/hashed from any static column(s). Peter, Are you saying that a uuid is inherently insecure? I thought part of the uuid was created randomly and for the purposes

Re: Product ID - enterprise level application

2009-06-12 Thread Jochem van Dieten
On Fri, Jun 12, 2009 at 1:38 PM, Ryan Letulle wrote: Are you saying that a uuid is inherently insecure? Depends on how you use them.  I thought part of the uuid was created randomly and for the purposes where I was using it felt comfortable. Some UUIDs are random, some are completely

Re: Product ID - enterprise level application

2009-06-12 Thread Ryan Letulle
OK, I guess. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:01 AM, Jochem van Dieten joch...@gmail.comwrote: On Fri, Jun 12, 2009 at 1:38 PM, Ryan Letulle wrote: Are you saying that a uuid is inherently insecure? Depends on how you use them. I thought part of the uuid was created

Re: Product ID - enterprise level application

2009-06-12 Thread Peter Boughton
Are you saying that a uuid is inherently insecure? UUIDs are guaranteed to be unique, but not (afaik) to be unpredictable. I don't know *how* predictable they might be, but for any secure string I wouldn't want to rely entirely on something with potentially knowable/guessable sources - I

Re: Product ID - enterprise level application

2009-06-12 Thread Ryan Letulle
Thank you all. A long habit of not thinking a thing wrong gives it a superficial appearance of being right. Thomas Painehttp://www.brainyquote.com/quotes/quotes/t/thomaspain161749.html * *-- Ryan LeTulle On Fri, Jun 12, 2009 at 7:12 AM, Peter Boughton bought...@gmail.com wrote: Are you

RE: Product ID - enterprise level application

2009-06-12 Thread Bobby Hartsfield
If it is SQL server, you can set the column type to uniqueidentifier. If you are like me and don't like the pointless dashes in the uuids, you can set the column to nvarchar(32) then set the default constraint to replace(newID(), '-', '') Then... SQL Server will take care of populating the field

Phillp Vector

2009-06-12 Thread Scott Stewart
Please contact me off list Re: someone's hiring practices.. Thanks sas -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Want to reach the

Re: Product ID - enterprise level application

2009-06-12 Thread Mary Jo Sminkey
Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. If they want to view order history, yes, that's the easiest way to ensure security for viewing the

Re: Product ID - enterprise level application

2009-06-12 Thread Ryan Letulle
One note I don't use the uuid as the primary key in these instances. I know that's how this post started. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 9:07 AM, Mary Jo Sminkey mary...@cfwebstore.comwrote: Are you guys saying that I should force my client to require their client to create a

User Authentication without Session Expiration

2009-06-12 Thread Dawson, Michael
For the last seven years, I have used IIS and basic authentication to log in to our intranet web site. We tied in to Active Directory for the user database. Now, we are building a new online admission application where the applicants will not yet have an Active Directory account. Therefore,

Re: cf8 help with japanese characters

2009-06-12 Thread Paul Hastings
Paul Kukiel wrote: Well dealing with non English char set's you should always be using cfqueryparam / Actually there is really no excuse for not ever using it. except of course when you can't or shouldn't. As fro MS SQL 2008 I have had no issues inserting all types of languages.

Re: client holding open a connection

2009-06-12 Thread Michael Dinowitz
It looks like cfflush might be the culprit here. The connection seems to be to a bot which may be slow or inefficient. I'm speculating that the connection that is opened by cfflush to the webserver and caller may not obey the default timeout for an application. Again, not sure, but the removal

CF8 and Facebook Connect - Any guidance?

2009-06-12 Thread Shane E. Larrabee
Can anyone point me in the right direction and/or have any examples of how this can be done. I have a project that will be utilizing CF8 and I need use the single sign-in and find friend features of Facebook Connect (http://developers.facebook.com/connect.php). I have found a few resources on

Re: CF8 and Facebook Connect - Any guidance?

2009-06-12 Thread John M Bliss
You've searched http://www.riaforge.org ? Other possibilities...? http://wiki.developers.facebook.com/index.php/ColdFusion http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:58950 On Fri, Jun 12, 2009 at 4:48 PM, Shane E. Larrabee slarra...@projectbigfish.com wrote: Can

Re: CF8 and Facebook Connect - Any guidance?

2009-06-12 Thread Casey Dougall
On Fri, Jun 12, 2009 at 5:55 PM, John M Bliss bliss.j...@gmail.com wrote: You've searched http://www.riaforge.org ? Other possibilities...? http://wiki.developers.facebook.com/index.php/ColdFusion http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:58950 Not facebook...

Syntax error in SQL statement

2009-06-12 Thread Steve Lichtenberg
I am not a SQL expert but I play one on TV :) I have the following query select DataLoadStatus,DataLoadData,DataLoadFileLineNumber,exception.description from PUB.DataCenterDataload left outer join PUB.DataCenterHoldingArea on(DataCenterDataload.DataLoadNumber =

Re: cf8 help with japanese characters

2009-06-12 Thread Paul Kukiel
On 12/06/2009, at 11:34 AM, Paul Hastings wrote: As fro MS SQL 2008 I have had no issues inserting all types of languages. what does that mean? It means I can insert all languages be it Japanese, Chinese, French or any Indian dialect. If your having issues feel free to ping me off list.

Re: Syntax error in SQL statement

2009-06-12 Thread Roger Austin
Steve Lichtenberg wrote: I am not a SQL expert but I play one on TV :) I have the following query select DataLoadStatus,DataLoadData,DataLoadFileLineNumber,exception.description from PUB.DataCenterDataload left outer join PUB.DataCenterHoldingArea

Re: client holding open a connection

2009-06-12 Thread Ben Nadel
Michael, I'm not sure I understand? You mean like after the bot gets the first chunk of content, it somehow refuses to get the rest? -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need

Re: Syntax error in SQL statement

2009-06-12 Thread Jason Fisher
Doesn't look like any of the parens are actually necessary on this query, are they? Shot in the dark here, but is exception a reserved word in SQL Server? ~| Want to reach the ColdFusion community with something they want? Let

Re: client holding open a connection

2009-06-12 Thread Michael Dinowitz
Not refusing but either not closing the connection or keeping it open longer than it should. Normally, the CF server generates some content and sends it as a whole to the webserver to be delivered. Once the data is handed off, the CF thread is dead. In this case, a timeout will kill the thread

Re: Syntax error in SQL statement

2009-06-12 Thread Peter Boughton
Does this work? SELECT DataLoadStatus , DataLoadData , DataLoadFileLineNumber , EX.description FROM pub.DataCenterDataload DL LEFT JOIN pub.DataCenterHoldingArea HA ON DL.DataLoadNumber =

Proper returntype of a cfc

2009-06-12 Thread Ryan Letulle
Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make

Re: cf8 help with japanese characters

2009-06-12 Thread James Holmes
2009/6/13 Paul Kukiel pkuk...@gmail.com: On 12/06/2009, at 11:34 AM, Paul Hastings wrote: As fro MS SQL 2008 I have had no issues inserting all types of languages. what does that mean? It means I can insert all languages be it Japanese, Chinese, French or any Indian dialect. If your

Re: Proper returntype of a cfc

2009-06-12 Thread Rob Parkhill
You would need to return it as a struct. then just reference any parts of the struct that contain the data you want. I have one cfc that returns a struct of arrays... Rob On Fri, Jun 12, 2009 at 8:25 PM, Ryan Letulle bayous...@gmail.com wrote: Is it a common/best practice to return multiple

Re: Proper returntype of a cfc

2009-06-12 Thread Ryan Letulle
That's what I thought but I've been wrong before. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:30 PM, Rob Parkhill robert.parkh...@gmail.comwrote: You would need to return it as a struct. then just reference any parts of the struct that contain the data you want. I have one cfc that

Re: Proper returntype of a cfc

2009-06-12 Thread Dave Watts
Is it a common/best practice to return multiple variables from a cfc?  Like if I wanted perform some processing in a cfc and return several variables.  For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make

Re: Proper returntype of a cfc

2009-06-12 Thread Ryan Letulle
Understand, I guess the proper terminology should be multiple values ? -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:35 PM, Dave Watts dwa...@figleaf.com wrote: Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return

Re: Proper returntype of a cfc

2009-06-12 Thread Dave Watts
Understand, I guess the proper terminology should be multiple values ? Well then, it seems an odd question to ask. Return whatever data type reflects the best possible output for your function. If that's a query, return a query. If it's an array, return an array. If it's a structure, return a

Re: Proper returntype of a cfc

2009-06-12 Thread Ryan Letulle
Only odd to you because you are all knowing. For the most part I have always returned either a query or 1 variable. I have never done this before in a cfc. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:43 PM, Dave Watts dwa...@figleaf.com wrote: Understand, I guess the proper terminology

Re: Proper returntype of a cfc

2009-06-12 Thread Ryan Letulle
BTW I always appreciate the guidance. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:45 PM, Ryan Letulle bayous...@gmail.com wrote: Only odd to you because you are all knowing. For the most part I have always returned either a query or 1 variable. I have never done this before in a cfc. --

Re: Proper returntype of a cfc

2009-06-12 Thread Dave Watts
Only odd to you because you are all knowing. I wish! But calling functions in CF is basically the same as calling functions in other languages. You provide a list of inputs, and get a single return value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides

Re: Proper returntype of a cfc

2009-06-12 Thread Ryan Letulle
@dave I started using cfcs after reading a Ben Forta article a couple of years ago where he said at least use cfcs for querys and you should never output to the screen from cfcs. For the most part that is what I have used them for. Unfortunately, I never really advanced further than that with

Re: Proper returntype of a cfc

2009-06-12 Thread Pete Freitag
Consider returning an object (another CFC), rather than a struct. In some cases a struct works well, but if you return an object you have better documentation as to what it returns, rather than with a struct with unknown keys. You can also setup default values in the CFC. -- Pete Freitag

Re: Proper returntype of a cfc

2009-06-12 Thread Gerald Guido
Only odd to you because you are all knowing. For some reason this tickles me pink. Dave, you *are* a walking, talking cf_encyclopedia. G! On Fri, Jun 12, 2009 at 8:45 PM, Ryan Letulle bayous...@gmail.com wrote: Only odd to you because you are all knowing. -- Gerald Guido

Re: cf8 help with japanese characters

2009-06-12 Thread Paul Hastings
Paul Kukiel wrote: It means I can insert all languages be it Japanese, Chinese, French or any Indian dialect. uh, you *really* need to read jochem's blog post. the fact that his blog is called it be bunnies should be reason enough ;-) but seriously, read it.

Harrisburg, PA COLDFUSION DEVELOPER OPENING

2009-06-12 Thread Balaskas, Leyla
Please send a resume if interested this is a full time onsite position located in Harrisburg, PA, Government client Short Description: Programmer is responsible for analysis, design, coding, component assembly testing of Internet applications using a variety of Web server technologies

RE: Harrisburg, PA COLDFUSION DEVELOPER OPENING

2009-06-12 Thread John Lyons
I have attached my resume in response to this posting. John Lyons Software Engineer (Jacksonville, FL) (p) 706.948.4105 (c) 706.599.5970 john.ly...@pridedata.com http://www.linkedin.com/in/johnlyons -Original Message- From: Balaskas, Leyla [mailto:leyla.balas...@ajilon.com]