Stored Procedures in a CFC

2005-03-03 Thread Andy Jarrett
Hi there, I have a SP wrapped in a CFC. The SP returns two record sets, which i use cfprocresult to reference. How do i then return the 2 queries via the CFC? Cheers Andy J www.andyjarrett.co.uk ~| Find out how CFTicket can

RE: Stored Procedures in a CFC

2005-03-03 Thread Robertson-Ravo, Neil (RX)
Good question, I believe you will have to enter the two resultset objects into a single CF complex object (such as a Structure) and return that as a single value. -Original Message- From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 09:01 To: CF-Talk Subject: Stored

Skins in XML forms

2005-03-03 Thread Mike Kear
There is a lot of information in the new help files in CFMX7, but i havent been able to find out how to tinker with the skins of XML forms. Specifically, what files I need to tinker with. i've found a file called blue.xml for example, but that seeems to refer to the specs of the 'blue' skin for

Re: Skins in XML forms

2005-03-03 Thread Andy Allan
I think it's /cfide/scripts Andy On Thu, 3 Mar 2005 21:58:24 +1100, Mike Kear [EMAIL PROTECTED] wrote: There is a lot of information in the new help files in CFMX7, but i havent been able to find out how to tinker with the skins of XML forms. Specifically, what files I need to tinker with.

I got it! Output grouped query horizontal loop thingamajig.

2005-03-03 Thread Will The Game
Here's my final code that worked in case it may help someone else in the future. Is nothing fancy, but here it is anyway! Thanks Charlie and Ade, Will cfset ctr=0 table width=90% align=left cellpadding=6 tr cfoutput query=getprodsbycategory

Re: I got it! Output grouped query horizontal loop thingamajig.

2005-03-03 Thread Pete Ruckelshaus
You could use [queryname].currentrow MOD 3 EQ 0 instead of the ctr variable. Slightly more elegant (IMO) and slightly easier. Pete On Thu, 03 Mar 2005 06:28:35 -0400, Will The Game [EMAIL PROTECTED] wrote: Here's my final code that worked in case it may help someone else in the future. Is

Re: I got it! Output grouped query horizontal loop thingamajig.

2005-03-03 Thread Charlie Griefer
except that he's grouping his output. that was the original issue. currentrow is no longer sequential :) On Thu, 3 Mar 2005 07:22:59 -0500, Pete Ruckelshaus [EMAIL PROTECTED] wrote: You could use [queryname].currentrow MOD 3 EQ 0 instead of the ctr variable. Slightly more elegant (IMO) and

RE: MSSQL TEXT datatype problem with CF

2005-03-03 Thread Dawson, Michael
Did you ever try storing the files in an Image data-type? I'm not sure, but I would guess that would not require the files to be converted to text before storing them. M!ke -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005

RE: Stored Procedures in a CFC

2005-03-03 Thread S . Isaac Dealey
Good question, I believe you will have to enter the two resultset objects into a single CF complex object (such as a Structure) and return that as a single value. That would be my choice. I think a structure makes more sense for that as this code: cfset data = myCFC.getQueries() cfloop

RE: Stored Procedures in a CFC

2005-03-03 Thread Adrian Lynch
I use structures to pass back multiple things from functions, but I'm not so sure you're right about not using an array. An array maps to the cfprocresult's resultset attribute(as it could equally to it's name attrib) but with the array you don't need to know the name used only the number of the

Re: ot: interesting thingy on allaire

2005-03-03 Thread Thomas Chiverton
On Thursday 03 Mar 2005 00:04 am, dave wrote: crurious how if jeremy will add any cfm perks to this? Yes, but: An error occurred while loading http://www.brightcove.com/: Unknown host www.brightcove.com -- Tom Chiverton Advanced ColdFusion Programmer

Re: cfscript functions in CFCs

2005-03-03 Thread Ben Doom
cfcomponent cfscript function myFunc... return resultVar /cfscript That method nets function myFunc not found. It's been a while since I've played with CFC's, but from what I remember, that should work. Are you calling object.myfunc()? That method gets me a variable myArg

Re: OT: Dynamic form fields calendars

2005-03-03 Thread Thomas Chiverton
On Friday 25 Feb 2005 16:02 pm, Damien McKenna wrote: Any ideas what I should look for, or failing that, anyone have a suggestion on something else for me to try? There was speed-up code added to reuse Calender.js instances - one of the setup variables turns this off, try that... -- Tom

RE: cfscript functions in CFCs

2005-03-03 Thread Paul
Thanks for playing around with this, Jared. In your experiments did you try calling test.getCGI() from within a second cfc as well? (temp.cfm creates test1.cfc; test1.cfc calls test.getCGI() as part of its processing.) If that works for you my difficulty may be a difference between BD and

RE: cfscript functions in CFCs

2005-03-03 Thread Paul
Well this syntax is invalid -- if your psuedocode is accurate... You can't declare a function within a function. Or that was what I thought You're right - my function-within-a-function code block caused an error on CFMX server. It does seem like a pretty silly idea after having it pointed

Re: MSSQL TEXT datatype problem with CF

2005-03-03 Thread Jared Rypka-Hauer - CMG, LLC
No, I didn't... but that's a great idea. I was using the long-value columns in SQL Server because the site I was doing needed secured storage for the PDFs (they're fairly private contract documents - high but not mission-critical security needs) but thru the host at the time I didn't have access

Re: Stored Procedures in a CFC

2005-03-03 Thread Marc Campeau
I would do it differently (then returning a struct/array with both recordset). Please give comments/suggestions/whatevers as I'm just thinking out loud. In essence, your SP returns two recordsets which don't hold the same data, they could be related but they are not the same. Why not create two

RE: MSSQL TEXT datatype problem with CF

2005-03-03 Thread Robertson-Ravo, Neil (RX)
You are going to use more physical disk space storing the PDF's in the DB than if you store them as physically files on the drive. -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:24 To: CF-Talk Subject: Re: MSSQL TEXT datatype

Re: Securing MS-SQL port 1433

2005-03-03 Thread John Paul Ashenfelter
On Wed, 2 Mar 2005 09:32:10 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: My point is that if you are running 818 you are NOT fully patched. Not disputing that at all. And even having MS-SQL fully patched on a Windows box that is missing OS patches doesn't necessarily make you safe

RE: Securing MS-SQL port 1433

2005-03-03 Thread Robertson-Ravo, Neil (RX)
-- My original point wasn't that you have to be fully patched to be safe I agree with that for sure. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:28 To: CF-Talk Subject: Re: Securing MS-SQL port 1433 On Wed, 2 Mar 2005 09:32:10 -,

RE: Stored Procedures in a CFC

2005-03-03 Thread Robertson-Ravo, Neil (RX)
Well, If the method called can call one proc and is returning two record sets which are required - sure they are not calling the same data sets but they may be required - and one hit to the DB is better than separate calls - if there is certainly good reason and better performance over your idea

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Thomas Chiverton
On Friday 25 Feb 2005 15:21 pm, Bryan F. Hogan wrote: send it to me. Against all of my recommendations to have us write an import function they don't want to spend the money. So, fine. Let them do it that way. When it breaks, explain why. -- Tom Chiverton Advanced ColdFusion Programmer

Re: OT: Migration from Sybase ASE 12.5.1 to SQl Server

2005-03-03 Thread Jared Rypka-Hauer - CMG, LLC
Isn't it annoying how you can search for an answer for days, then post a request to the list, then find the answer no more than an hour after requesting assitance? Invariably, I find this to be true. Maybe we should call it the Natural Law of Abundant Answers. It means that there are always

Re: RDS and file browsing

2005-03-03 Thread Thomas Chiverton
On Friday 25 Feb 2005 17:47 pm, Douglas Knudsen wrote: dir only, user Henry Rollins has access to everything, etc... Use WebDAV :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading

Re: Securing MS-SQL port 1433

2005-03-03 Thread John Paul Ashenfelter
On Tue, 1 Mar 2005 22:06:48 -0500, Dave Watts [EMAIL PROTECTED] wrote: If someone's installing Visio Enterprise to work on flowcharts at home, they probably got it from work. Licensing issues aside (since we'll assume they're good there) then their home box gets hosed. PITA, but not much

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Bryan F. Hogan
No not fine. I don't care if they want it or not, I want it to make my job easier. These are people that if they see something that will understand how it will make their jobs easier. That's why I posted looking for something that someone may have already done. I can't believe that this has not

OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread John Paul Ashenfelter
The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email)

RE: Stored Procedures in a CFC

2005-03-03 Thread Adrian Lynch
I'm not sure about others, but I was talking about the call to the function that contains the two resultset SP. No matter how many layers you put between the SP call at some point you need to call a function that will run that SP. The cfstoredproc tag will return both queries regardless, you

Re: cfscript functions in CFCs

2005-03-03 Thread Jared Rypka-Hauer - CMG, LLC
Hey Paul... Here's the latest test. :) Note that in test.cfc, I've got both CFINVOKE and createObject() styles of accessing the second CFC... they both work just fine. I used one, then remarked it out and used the other too and figured I'd leave them both in as examples. temp.cfm

Re: OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Jerry Johnson
At work, crappy 30 dollar office depot special. The up/down air cylinder is broken and the screw to hold the back upright doesn't hold. At home I've got an Aeron chair (used, part of a complete Herman Miller cube system I resold), but I don't use it for coding anymore. My computer desk is a

Re: OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Mark Drew
Currently I have a low ikea coffee (side) table and a big ole beanbag (looks like leather but it aint) NOT the most comfortable coding position known to man. Oh.. thats at home, at work they treat me a bit better... MD On Thu, 03 Mar 2005 10:53:11 -0500, Jerry Johnson [EMAIL PROTECTED]

Re: MSSQL TEXT datatype problem with CF

2005-03-03 Thread Jared Rypka-Hauer - CMG, LLC
Indeed... I could tell. I ran an export of the DB into a local replica sans the PDF column... the data file went from 198MB to 4MB. Twas a telling test. But still... there are situations where eating up disk space with a DB data file isn't a waste so much as a cost. The point was mostly just

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
Against all of my recommendations to have us write an import function they don't want to spend the money. Well, if they don't want to spend the money, why care for them anyway? ;-) Do I understand well that if spreadsheets come from their client, they can have about anything in it, in any

Re: access w username and password..

2005-03-03 Thread Jared Rypka-Hauer - CMG, LLC
That doesn't really matter. So long as you're using the right username/password combination, it'll work fine even if you have access credentials in both places. Sometimes it's a matter of going into CFADMIN, getting it all set up so it works, then stripping the creds out of CFADMIN and using them

RE: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Michael T. Tangorre
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? Fun, yes. On-topic, No.

Re: Securing MS-SQL port 1433

2005-03-03 Thread Lee
Lee: Hi my name is Lee and I'm and idiot. Half the list: Hi Lee! Lee: I installed my first Windows box in 1998. Half the list: (Sympathetic Hush) Lee: Yeah and ever since then my life has been out of control. I really need Windows but the problems it's caused... Half the list: Nodding

Re: OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Nathan Strutz
Dual montiors, one, a 19 dell flatscreen, one a 19 viewsonic crt. I've found I can't tell color differences in most text colors on the lcd (except at extreme angles or with bright colors), which is why i put all my CFEclipse utility panels on there and the coding window on the crt. My chair is

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Bryan F. Hogan
Ok, let me reiterate. I care for them because I know if they can see an example, they will foot the integration bill. These are clients that I have that we have been working with for the last 5 years. I care for them because they sustain our business and even if they were one of our smaller

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Dawson, Michael
Can you force a spreadsheet format on them? If so, you can generate a spreadsheet with locked cells where they can only enter information in cells you have specified. That would make it much easier for you handle the data. Of course, if the sheets contain varying amounts of data, it might not

cfform not working correctly

2005-03-03 Thread toru okada
everything has been working on the developers workstation (windows xp/standalone/cfmx7) but when deployed to server (solaris/j2ee(jrun)/cmx7) the forms will not display correctly on the clients. The bizarre thing is that it displays differently depending on the client you are using. There is

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. I was just joking ;-) The reason I asked is because I have a site in which spreadsheets are imported, but the columns always match, so it won't help. I don't know about any matching tool however.

Re: OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Raymond Camden
Speaking of tables - I used to have a nice desk. When I moved, the desk broke, so I borrowed a simple table that you would typically use at Thanksgiving for the kids. I love it. I feel like I have acres of real estate. I never used the drawers of my old desk anyway so it's perfect. On Thu, 03

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Aaron Rouse
A matching tool as described would be an easy sell to a lot of people. Though probably would be a nightmare to try and make which might be why I have never stumbled upon a canned solution for it. :) On Thu, 03 Mar 2005 11:38:18 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: If you haven't

(OO) UI in CFCs

2005-03-03 Thread Michael Dinowitz
I'm starting this topic to get peoples feelings on the subject. Do you use CFCs for UI? Do you have a good reason to do so? Do you see a reason to use it (or not) vs. CFINCLUDEs or CFMODULEs? According to commonly discussed practices in the community (and in part of the Macromedia docs), UI

RE: MSSQL TEXT datatype problem with CF

2005-03-03 Thread Robertson-Ravo, Neil (RX)
The problem is simply the size and cost of the indexes etc they all add up to unnecessary usage. -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:06 To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF Indeed... I could

RE: Securing MS-SQL port 1433

2005-03-03 Thread Robertson-Ravo, Neil (RX)
Eh? -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:15 To: CF-Talk Subject: Re: Securing MS-SQL port 1433 Lee: Hi my name is Lee and I'm and idiot. Half the list: Hi Lee! Lee: I installed my first Windows box in 1998. Half the list: (Sympathetic Hush)

RE: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Bryan F. Hogan
Ah, and that's why I don't want to write it myself. I was thinking something along the lines of a mail merge. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:42 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping A matching

Re: (OO) UI in CFCs

2005-03-03 Thread Bryan Stevenson
It's a big no noone of the points of using CFCs is to seperate business logic from the presentation layer I know it's possiblebut it's also possible to put page header display code in Application.cfmbut we don't do it ;-) Ultimately it's up to the developer ;-) Cheers Bryan

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Claude Schneegans
A matching tool as described would be an easy sell to a lot of people. Ah ah! A great idea for a new tag? ;-) Though probably would be a nightmare to try Not really, using CFX_ODBCInfo would make it pretty easy. I'm about to release a super new application: The ODBCMyAdmin, version 1.0 and

RE: (OO) UI in CFCs

2005-03-03 Thread Adrian Lynch
I don't think he means use UI and business together, but rather CFCs for the presentation. Mike? Ade -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:52 To: CF-Talk Subject: Re: (OO) UI in CFCs It's a big no noone of the points of using

RE: cfscript functions in CFCs

2005-03-03 Thread Paul
This was a fun, if simple, excercise... thanks Paul! For as often as I'm confused, it's nice that at least my questions at least occasionally lead to something positive for someone out there! Thanks for looking into it, as well.

Re: Stored Procedures in a CFC

2005-03-03 Thread Marc Campeau
The cfstoredproc tag will return both queries regardless, you could construct the function to return one of the callers choosing, but from a simplistic approach returning both in either an array or a structure seems more useful. The point I was making was that you either reference them as:

Re: (OO) UI in CFCs

2005-03-03 Thread Marlon Moyer
This is one of those topics where I see people making CFC's into something they aren't. Yeah, CFC's can be used to separate BL from UI blah blah blah. But that doesn't preclude the use for other things. I see so many emails floating around about OO design and how this rule keeps you from doing

RE: (OO) UI in CFCs

2005-03-03 Thread Michael Dinowitz
Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. Basically, you have a page which calls a BL (business logic) CFC for logic and a UI (user interface) CFC for specific UI elements that go on the page with the business logic. Take an average blog

Re: Web Based Spreadsheet To MSSQL Mapping

2005-03-03 Thread Aaron Rouse
To me the mapping itself would not be the nightmare. It would be the reading in the Excel file and grabbing the data correctly. Dealing with any pretty formating it might have, dealing with multiple worksheets and so on. I actually have the need for something kind of like this and will be

RE: Stored Procedures in a CFC

2005-03-03 Thread Adrian Lynch
Right, but in your getResult1() and getResult2() you access the key named in loadData(). That's what I'm saying(asking whether it's) bad. Would array syntax not hide better what loadData() does? -Original Message- From: Marc Campeau [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 17:04 To:

OT: short term contractor required

2005-03-03 Thread Dave Wilson
Hi all, Sorry if this is an inappropriate post, however I'm looking for someone to write up a Coldfusion XML-RPC implementation for me as its just beyond my skill levels. Basics of the project is to use XML-RPC to check our db for new events, then push them to the client. The environment is

Re: (OO) UI in CFCs

2005-03-03 Thread Aaron Rouse
Thus far I have only seen one example where someone was using a CFC for the UI. I never got to see the actual code but his explanation made it sound like a good chunk of the business logic was in other CFCs and then he had a set of CFCs for the UI portion. Without really seeing the code, I

Re: (OO) UI in CFCs

2005-03-03 Thread toru okada
[EMAIL PROTECTED] wrote: Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. we have talked about his many times in our shop. the main advantage that we have come up with is giving UI an interface of sorts. It would allow you to define what is

RE: (OO) UI in CFCs

2005-03-03 Thread Burns, John D
Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. I believe the default action is to take the column names and make them table

coldfusion photo gallery suggestions?

2005-03-03 Thread Phill B
I need a coldfusion photo gallery that can have multiple users and allow the verification of the photos put on the site. Here is an example of one. http://www.stingrayboats.com/MyStingray/ppost/showmembers.php/cat/500/password/ its driven by http://www.photopost.com/ but its not really what we

Re: (OO) UI in CFCs

2005-03-03 Thread Aaron Rouse
A datagrid as you refered to it is exactly the example I am thinking of. We just use custom tags here to do what you are describing. Now our system was developed long before CFCs were even available. I could see how maybe it would be easier using some Set/Get functions over potentially a lot of

Re: coldfusion photo gallery suggestions?

2005-03-03 Thread Jerry Johnson
Are you looking for a solution that only allows moderated/approved images and captions to appear? Who can moderate/approve? Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 12:35PM I need a coldfusion photo gallery that can have multiple users and allow the

Re: (OO) UI in CFCs

2005-03-03 Thread Nick de Voil
Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. We do something similar. We have a set of report-building CFCs where you can

Which is better?

2005-03-03 Thread Greg Morphis
Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable

RE: (OO) UI in CFCs

2005-03-03 Thread Burns, John D
Yeah, my main intrigue with it is that you could have different mini-functions within the CFC that could do formatting and arranging and stuff and could be used for a lot of data display. That way, even more than with a custom tag, you could reuse the CFC for all kinds of displays and such.

Re: coldfusion photo gallery suggestions?

2005-03-03 Thread mac jordan
On Thu, 3 Mar 2005 12:35:55 -0500, Phill B [EMAIL PROTECTED] wrote: I need a coldfusion photo gallery that can have multiple users and allow the verification of the photos put on the site. We need user sections that allow them to post a few images that we can make sure are kid friendly. Plus

RE: (OO) UI in CFCs

2005-03-03 Thread Calvin Ward
For ColdFusion, I prefer presentation elements (we are talking about HTML/XHTML/XML for the most part, right?) to be in tags. The main reasons are simple. I'd rather see: ui:navdiv a href=homehome/a /ui:navdiv Than cfsavecontent variable=myvar a href=homehome/a /cfsavecontent

Re: (OO) UI in CFCs

2005-03-03 Thread Aaron Rouse
Our tags handle a lot of this. They are however fed a single file that is nothing more than a big switch case. You set the cases values to various things based upon what and how you want the datagrid to be displayed. The more I think about it from a coding(code within custom tag or CFC, not code

Re: Which is better?

2005-03-03 Thread Barney Boisvert
The latter will almost certainly be faster, probably by a large margin. However, the former will be far simpler to set up and maintain. How about option C, create a full text index on your CLOB from option A, and use that? I know SQL Server and MySQL both support such indexes, I'd imagine

Re: Which is better?

2005-03-03 Thread Douglas Knudsen
one word...Verity :) DK On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where

delivering a file...

2005-03-03 Thread Protoculture
I want my template to deliver ( start a download ) form the current template, without opening a new window or calling a seperate template. Basically... I need to run some processing in cf and then call the downloadhow can this be done?

RE: (OO) UI in CFCs

2005-03-03 Thread Steve Brownlee
Yes, I use CFCs for presentation of content, but only in situations where it makes sense. For simple web pages, absolutely not, there's no point. My main use of CFC is, for example, in a custom content management system where almost every view is the same and only a query resultset changes what

Insert Unicode Smart Quotes into MS SQL Server 2000

2005-03-03 Thread Mike Chabot
I thought char and varchar columns would only allow the 255 ASCII values and would not allow Unicode. SQL Server 2000 seems to let me insert Unicode into these columns without any problems. For example, when I insert the two sets of MS Word smart quotes, separated by a space, into a varchar(5)

Re: cfscript functions in CFCs

2005-03-03 Thread Adam Haskell
If I have option values I do this function bob(required) { var optional = ''; if (arraylen(arguments) EQ 2) optional = arguments[2]; ... } I think you will find this common practice if you look trhough a good chunk of the UDFs on cflib.org. Adam H On Wed, 2 Mar 2005

Re: Which is better?

2005-03-03 Thread Greg Morphis
Cool, this was more or less just a preformance (which would you do in this situation) question. Thanks for the responses :) On Thu, 3 Mar 2005 13:09:26 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: one word...Verity :) DK On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis [EMAIL

Re: (OO) UI in CFCs

2005-03-03 Thread Deanna Schneider
We use CFC's to _return_ UI elements. In other words, we don't use output=true but we do use CFC's to return data that generates output. For example, we have a contentserver CFC. This CFC returns images and files that are outside of the webroot. We also have a template CFC for one specific

RE: (OO) UI in CFCs

2005-03-03 Thread Andy Ousterhout
Nick, I am not sure that previous discussions where about CFC's designed specifically for UI, but for CFC's that are instances of objects. -Original Message- From: Nick de Voil I can't see any sense in the assertion that you shouldn't use CFCs for UI. Why on earth not?

Announcing SeeFusion 2.0 - Enterprise amp; Standard

2005-03-03 Thread Patrick Quinn
Greetings, all. We're extremely excited to announce the release of SeeFusion 2.0. This latest version of SeeFusion includes the long-awaited Enterprise Edition, along with a host of new features. Here's a summary of 2.0: strongStandard:/strong ul liEven faster than before/li

Re: OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Pete Ruckelshaus
Dual Dell 1800FP's in front of me, and an Aeron beneath me. On Thu, 3 Mar 2005 10:39:39 -0600, Raymond Camden [EMAIL PROTECTED] wrote: Speaking of tables - I used to have a nice desk. When I moved, the desk broke, so I borrowed a simple table that you would typically use at Thanksgiving for

Re: OT: So what chair are you sitting in with your dual monitors?

2005-03-03 Thread Mike Chabot
I have a Steelcase Leap chair. I have not found the perfect chair, but this one is pretty good. -Mike Chabot On Thu, 3 Mar 2005 10:48:30 -0500, John Paul Ashenfelter [EMAIL PROTECTED] wrote: The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of

RE: Questions on a dynamic tab delimited export and regular expressions

2005-03-03 Thread Dan Plesse
Is or was it the quotes cffile action=append file=#tempfile# output=cfloop list= -- ??? -Dan -Original Message- From: Doug Hyde [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 8:28 PM To: CF-Talk Subject: Questions on a dynamic tab delimited export and regular

RE: Questions on a dynamic tab delimited export and regular expressions

2005-03-03 Thread Bryan F. Hogan
Please by all means use cfsavecontent for your output variable. cfsavecontent variable=myVar Do stuff /cfsavecontent cffile output=#variables.myVar# ~| Find out how CFTicket can increase your company's customer support

Re: Announcing SeeFusion 2.0 - Enterprise amp; Standard

2005-03-03 Thread Douglas Knudsen
very exciting! We have been looking at this tool, trying to convinve the boss now liOptional kill command available to stop long running/hung requests/li Does this kill the actual thread? Doug On Thu, 03 Mar 2005 13:49:28 -0400, Patrick Quinn [EMAIL PROTECTED] wrote: Greetings, all. We're

RE: short term contractor required

2005-03-03 Thread Dan Plesse
What is XML-RPC? Is it like XMLHttpRequest? -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:25 PM To: CF-Talk Subject: OT: short term contractor required Hi all, Sorry if this is an inappropriate post, however I'm looking for someone

RE: short term contractor required

2005-03-03 Thread Bryan F. Hogan
Dan see http://www.xmlrpc.com/spec Dave see http://www.markme.com/cantrell/archives/002339.cfm -Original Message- From: Dan Plesse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 2:26 PM To: CF-Talk Subject: RE: short term contractor required What is XML-RPC? Is it like

Re: coldfusion photo gallery suggestions?

2005-03-03 Thread Phill B
Yup. Every thing would have to go thru a person here in the office. If the photo or story is ok, it would get approved and listed to the public. At this point I would be ok with a php app if one in CF doesn't exist. On Thu, 03 Mar 2005 12:32:52 -0500, Jerry Johnson [EMAIL PROTECTED] wrote: Are

RE: (OO) UI in CFCs

2005-03-03 Thread COLLIE David
And if you don't agree with me, I'll take my Property p = new Property(Ball.Color(Red)) and Structure.Home.Go() That's one of the funniest things I've read all week!!! (It's been a hard one :) -- dc ~| Logware

Re: coldfusion photo gallery suggestions?

2005-03-03 Thread Jerry Johnson
Just seeing what the needs are to dig around for a solution. You have 3 user types. General public. Free unfettered access to view gallery. view galleries. Submitter . unrestricted ability to submit images and text. How many images per piece of text? Can the submitter create a new gallery, or

OT: Live Chat

2005-03-03 Thread Russ
Can anyone recommend some live chat software (preferably something that integrates with CF). We need something that works sort of like the ESPN chat, which allows visitors to ask questions and after the moderator approves it, the question would show up, and then the host can answer the question.

Re: short term contractor required

2005-03-03 Thread Dave Carabetta
Hi all, Sorry if this is an inappropriate post, however I'm looking for someone to write up a Coldfusion XML-RPC implementation for me as its just beyond my skill levels. Basics of the project is to use XML-RPC to check our db for new events, then push them to the client. The

Troublesome or Dangerous Form Submission Characters for SQL

2005-03-03 Thread Mike Chabot
Are there any characters that a user could enter into a textarea form field that I should strip out before inserting the value into an MS SQL Server varchar field? Could these characters cause problems? semi-colon,,*,+,-,--,?,%,_. To prevent SQL injection, I could strip out truncate, drop,

RE: Troublesome or Dangerous Form Submission Characters for SQL

2005-03-03 Thread Adrian Lynch
Nothing if you're using queryparam/SPs, however on pulling the data back out double quotes may cause you trouble in text inputs(or single quotes if that's how you delimit your attributes in HTML). Use HTMLEditFormat() to solve the problem with double quotes. Ade -Original Message- From:

Re: Troublesome or Dangerous Form Submission Characters for SQL

2005-03-03 Thread Mike Chabot
Thanks for the tip about the double quotes. I am concerned that some people who enter in the text field will see the five character HTML-safe equivalent when they go to edit the value because of the HtmlEditFormat function. IE 6 does not seem to have this problem. Are there any browsers that

Re: Stored Procedures in a CFC

2005-03-03 Thread Sean Corfield
On Thu, 3 Mar 2005 13:54:45 -, Adrian Lynch [EMAIL PROTECTED] wrote: I use structures to pass back multiple things from functions, but I'm not so sure you're right about not using an array. An array maps to the cfprocresult's resultset attribute(as it could equally to it's name attrib) but

Re: Stored Procedures in a CFC

2005-03-03 Thread Andy Jarrett
I think for readability returning the values in a structure is going to do a.k.a S.Isaac cfset data = myCFC.getQueries() cfloop query=data.getUsers.../cfloop cfloop query=data.getRoles.../cfloop But the idea of going through a function to get the different recordsets, and referencing via the

was: coldfusion photo gallery suggestions? - Is this List Working?

2005-03-03 Thread Stan Winchester
I made two posts to coldfusion photo gallery suggestions? several hours ago and neither of them got listed, so here is my post again. Phill, We are about to start a public beta of a ColdFusion/JavaScript photo gallery with the features you are requesting. Please contact me off-list if you

Safe HTML display of user-entered text

2005-03-03 Thread Mike Chabot
Below is a function for displaying text, entered by users in form fields, in HTML format to someone else. Can this code be improved? This code assumes the user is not allowed to enter HTML markup in the text fields. function friendlyHtml(argStr) { argStr=htmlEditFormat(argStr);

Re: Binding Flash Form

2005-03-03 Thread David Brown
Thanks for the info. I see that you use the name of the input or textarea to reference it. How would you reference a cfformgroup object? - Original Message - From: Sean Corfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 02, 2005 5:14 PM Subject:

Re: Safe HTML display of user-entered text

2005-03-03 Thread Barney Boisvert
This code assumes the user is not allowed to enter HTML markup in the text fields. By this you mean that the submitted data is checked for HTML content via another means? Because the way you said it (the form field itself prevents HTML from being entered) isn't secure. cheers, barneyb On

  1   2   >