Re: CFMX bug ??

2002-07-03 Thread James Sleeman
> Complex object types cannot be converted to simple values. > > The Error Occurred in J:\InnovativeMedia\StaffAdmin\qry_husk.cfm: line > 71 > Called from J:\InnovativeMedia\StaffAdmin\dsp_husk.cfm: line 6 > Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 126 > > 69 :

RE: CFMX bug ??

2002-07-03 Thread Whiterod, David (PLNSA)
> I heard that on CFMX the loop over a list is deprecated.. Please say it ain't so! Seriously ... if this is so my only question is why -Original Message- From: Gianluca Pinelli [mailto:[EMAIL PROTECTED]] Sent: Thursday, 4 July 2002 4:36 PM To: CF-Talk Subject: Re: CFMX bug ?? I h

Re: CFMX bug ??

2002-07-03 Thread James Sleeman
- Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 7:04 PM Subject: RE: CFMX bug ?? > In the second case, #URL# might be the prime suspect for the same > reason. Yes, duh, realised that as soon as I posted :-)

RE: CFMX bug ??

2002-07-03 Thread Joe Bastian
Hmm... Does that say that "File" is a keyword and you cant use it as a variable in CFMX Java Architecture... Most likely so. Joe -Original Message- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 2:59 AM To: CF-Talk Subject: Re: CFMX bug ?? - Original M

Re: CFMX bug ??

2002-07-03 Thread Gianluca Pinelli
I heard that on CFMX the loop over a list is deprecated.. Luca - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 8:43 AM Subject: RE: CFMX bug ?? > CFMX automatically converts variables with dots into structu

RE: CFMX bug ??

2002-07-03 Thread Matthew Walker
Maybe it relates to the File scope which is deprecated in favour of the cffile scope... In the second case, #URL# might be the prime suspect for the same reason. > -Original Message- > From: James Sleeman [mailto:[EMAIL PROTECTED]] > Sent: jeudi 4 juillet 2002 18:59 > To: CF-Talk > Sub

Re: CFMX bug ??

2002-07-03 Thread James Sleeman
- Original Message - From: "James Sleeman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 04, 2002 6:34 PM Subject: CFMX bug ?? > > DESTINATION="#REQUEST.MirrorDir#\#file#" > > > > fails with... > > Complex object types cannot be converted to simple val

RE: CFMX bug ??

2002-07-03 Thread Matthew Walker
CFMX automatically converts variables with dots into structures. I wonder if cfdumping request.rootpath or request.Mirrordir might be interesting. > -Original Message- > From: James Sleeman [mailto:[EMAIL PROTECTED]] > Sent: jeudi 4 juillet 2002 18:35 > To: CF-Talk > Subject: CFMX bug ??

CFMX bug ??

2002-07-03 Thread James Sleeman
Hi all, I'm just working on porting our intranet (which is currently running under CF5) to CFMX, and right off the bat I have a little strangeness I have a query, Q_Changers which contains the names of files that need to be copied, generating the query works fine, but the copy code...

RE: Update with cflocation

2002-07-03 Thread Joe Bastian
Paul, CFLocation redirects header info to wherever you are pointing it to.. After all the query updates are done on the template.. at the end of code execution.. you can code some Inline JavaScript self.location='yourTemplate.cfm'; The ot

RE: DTS Import

2002-07-03 Thread Joe Bastian
Doug, The below code should work for you. Whatever your file is Create Table newTable (#nQuery#) Hope the above is what you wanted. Joe -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 6:42 PM To: CF-Talk Subject: DTS I

Update with cflocation

2002-07-03 Thread Paul Giesenhagen
I am doing some query updates and then following the processing with a When I use the updates do not take place (On MS SQL Server). When I remove the they process the update. I have heard the use of for redirection, does anyone have any example code to redirect to a different url? Or any

Re: [Q of Q] comparing queries

2002-07-03 Thread Michael Dinowitz
I'm getting it directly from the tag. The main problem is that joins are not allowed in QoQ. Union is and I tried this: select name, [Size] as size1, '' as size2 from cfdirectory1 union select name, [Size] as size2, '' as size1 from cfdirectory2 But to no effect. If I could get all of the

Re: activedit vs. em dash vs. unicode vs.CFMX vs. me

2002-07-03 Thread Paul Hastings
> Activedit allows me to use an em dash, I can see the em dash in the database, but when CFMX queries it out, it will only display the Unicode "box" and not the em dash character. ARGH! a [] means your browser can't render the character properly, a ? means the character is trashed so you're not d

Re: DTS Import

2002-07-03 Thread S . Isaac Dealey
> Getting an error, any ideas > Here is the top 2 items > client_first_name > co_client_first_name > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access > violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line > 4: Incorrect s

Re: DTS Import

2002-07-03 Thread Douglas Brown
Getting an error, any ideas Here is the top 2 items client_first_name co_client_first_name Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near 'co_client_first_na

Re: DTS Import

2002-07-03 Thread Douglas Brown
Well at this point, I dont char what the data type is. I can go back and change that, I just dont want to have to type all that crap into the table. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]>

Re: DTS Import

2002-07-03 Thread S . Isaac Dealey
> I have a text file with about 200 lines in it, and I want > the value of > each line to be a column in the database. How do I go > about this? I > tried first row has colum name, but it just gives me the > first row as a > column name and the other 299 rows as values. > > Example: > > I want all

DTS Import

2002-07-03 Thread Douglas Brown
I have a text file with about 200 lines in it, and I want the value of each line to be a column in the database. How do I go about this? I tried first row has colum name, but it just gives me the first row as a column name and the other 299 rows as values. Example: I want all these to be column

RE: MDAC version

2002-07-03 Thread Neil Clark - =TMM=
Not that a good check as some versions of software demand lower (and higher) versions of the MDAC components. You can download COMCheck from Microsoft : just search from the Homepage and you can find out what version you are running. It does pay to have the latest software installed, but in case

Re: MDAC version

2002-07-03 Thread Bryan Stevenson
quickest way to find out is to check Microsoft Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com -

OT: MDAC version

2002-07-03 Thread Thanh Nguyen
Just wondering what version of MDAC should I be using? What's the latest version. Thanks, Thanh Nguyen __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community

RE: Distributed Mode?

2002-07-03 Thread Stacy Young
We've used it since version 4.0 up until now (MX)...Generally there aren't any issue with it although sometimes the documentation can be a little skimpyAlso the setup for CFMX is much better than previous versions of CF...You don't have to run any additional listeners and what not... Bottom-l

RE: [Q of Q] comparing queries

2002-07-03 Thread Ben Johnson
> Just did this with an LDAP query and a SQL Server result set the other day. > > UNION is what you want to use, as for flagging dups...UNION eliminates the > duplicates so I don't know if you would need/want/be able/ to flag them. I think he's looking to find differences instead of combining eve

RE: [Q of Q] comparing queries

2002-07-03 Thread Ryan Kime
Just did this with an LDAP query and a SQL Server result set the other day. UNION is what you want to use, as for flagging dups...UNION eliminates the duplicates so I don't know if you would need/want/be able/ to flag them. At 04:13 PM 7/3/2002 -0400, you wrote: >Let say I have 2 queries resu

Re: Form Builder>?

2002-07-03 Thread Bryan Stevenson
How does it handle the underlying data? So say I create a form and then a user fills it in and posts it. Does it create a new table(s) in the database for that form's data to be stored in (on first use of form or creation of form), or does it store the data in some sort of generic format (user

RE: Form Builder>?

2002-07-03 Thread David DiPietro
Very nice! David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 4:22 PM To: CF-Talk Subject: Re: Form Builder>? On 7/3/02, Kris

activedit vs. em dash vs. unicode vs.CFMX vs. me

2002-07-03 Thread Justin Hansen
EM dashs (among other special chars) are very important to my company. Activedit allows me to use an em dash, I can see the em dash in the database, but when CFMX queries it out, it will only display the Unicode "box" and not the em dash character. ARGH! Has anyone else battled this yet? I th

Re: [Q of Q] comparing queries

2002-07-03 Thread Jeffry Houser
Since you are manipulating cfdirectory data, I imagine you want to use QOQ? Or is the data going into a database first? You could union the two and then do a self-join. Do something (conceptually) along these lines: select * from cfdirectory1 UNION select * from cfdirectory2 sele

RE: [Q of Q] comparing queries

2002-07-03 Thread Ben Johnson
I haven't used Q of Q very much, but SQL for something like that would be: SELECT a.name As MissingFilesFromDir1, b.name As MissingFilesFromDir2 FROM cfDir1 a FULL OUTER JOIN cfDir2 b ON a.name = b.name WHERE a.name IS NULL or b.name IS NULL You may want

Re: Form Builder>?

2002-07-03 Thread Bud
On 7/3/02, Kris Pilles penned: >Anyone know if any coldfusion based HTML form generators exist??? > >I need one but would like to avoud building it if at all possible.. Here's one you can play with. http://www.twcreations.com/makeform/ It will generate your insert and update queries also. --

RE: CFStudio 4.5.2 doesn't show RDS mappings in Open/Save/Save As dia log boxes

2002-07-03 Thread Debbie Dickerson
You need to make sure the option for using standard file dialogs is turned off. Go to Options > Settings > General. You should see an option there for "Use standard file dialogs". Once you uncheck that, apply the changes and then FTP/RDS should be available with Save As. Debbie -Original

Re: COM Object Help

2002-07-03 Thread Bud
On 7/3/02, Hatton Humphrey penned: >Okay, switching subjects slightly... I've got an app that is using the >HTML2EXCEL custom tag that is working great on my dev server (WinNT, >Netscape Webserver, CF 4.0.1). > >When I go to run it on my production server (Win2k, IIS 5, CF 4.5.1) I >keep getting "

[Q of Q] comparing queries

2002-07-03 Thread Michael Dinowitz
Let say I have 2 queries result sets from 2 different sources and I want to compare them. i.e. if there's a record different between them than that record will be flagged in some way. Records that are the same are not flagged. Is there an easy way to do this in a SQL statement? The goal is to r

Distributed Mode?

2002-07-03 Thread Joseph Christina
Hi, I'm working on a relocation project for our web servers. Part of the proposed changes in the architecture is to move CF to it's own app server and run it in distributed mode. I thought this was a logical and scalable solution, but when discussed it with a Macromedia tech, I heard that di

RE: JS WDDX Problem - Is it fixed?

2002-07-03 Thread Ben Johnson
> This should have been fixed in 5.0 as well. Anyway, yes, it's also fixed > in MX. Thanks, Raymond. We have a mix of different CF boxes here (5.0, 4.5 & maybe even a 4.0). I may have been on a 4.5 box whenever I was using it. I just write it myself now. Ben Johnson ___

RE: Form Builder>?

2002-07-03 Thread David DiPietro
Here's the code if you want it. Beware of wrapping START CODE SELECT name, id FROM dbo.sysobjects WHERE name = '#TTableName#' SELECT * FROM dbo.syscolumns WHERE id = #GetID.id# Source Code for the Select quer

Re: DB ?

2002-07-03 Thread Bill Wheatley
yea that worked duh thanks guys ;) Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: "Shawn Kernes" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 03,

RE: DB ?

2002-07-03 Thread Shawn Kernes
to get the length of the longest entry you could do something like this select max(length(#fieldname#) from #tableName# with oracle.. is that what your trying to find? -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:10 PM To: CF-Talk

RE: Form Builder>?

2002-07-03 Thread Kris Pilles
Thanks -Original Message- From: David DiPietro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 3:16 PM To: CF-Talk Subject: RE: Form Builder>? Here is a very elementry one I made Simply set the table name and Datasource name And you are on your way. View source and copy wher

RE: Form Builder>?

2002-07-03 Thread David DiPietro
Sorry no attachments David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: David DiPietro [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 3:16 PM To: CF-Talk Subject: RE: Form Builde

RE: DB ?

2002-07-03 Thread Chris Lofback
Yes, the max allowable length of a field. So for a field that is varchar2(200) it would return 200. And no, this is of absolutely no use for examining any of the entries in the field! :( Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com

RE: Form Builder>?

2002-07-03 Thread David DiPietro
Here is a very elementry one I made Simply set the table name and Datasource name And you are on your way. View source and copy where it says to. Search and insert the "<"s for the display page. Copy the action page directly and again search and insert the "<"s Tweak the display for different t

Re: DB ?

2002-07-03 Thread Matt Kornguth
Not positive, but think MAX(DATALENGTH(textfield)) should do it On 7/3/2002 2:20 PM, [EMAIL PROTECTED] wrote: >Whats the best way to get the max length of a column in a TEXT Field? > > >ANy ideas? > >Danks > >Bill Wheatley >Macromedia Certified Advanced Coldfusion Developer >EDIETS.C

CFHTTP Error.

2002-07-03 Thread Greg Luce
Has anyone had something happen to them like this using cfhttp-post? Here's my error on: "Error","TID=207","06/24/102","10:29:22","10.24.1.122, Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705), 'Error resolving parameter CFHTTP.RESPONSEHEADERCold Fusion was unable to

Re: DB ?

2002-07-03 Thread Bill Wheatley
good shot :) but you cant set local vars to be text type. Oh well I guess cfs the way to go with it Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: "S. Isaac Dealey" <[EMAIL PROT

RE: DB ?

2002-07-03 Thread S . Isaac Dealey
> Do you mean the max field length of a text field in a DB table? In Oracle > it would be something like this: > > select data_length > from user_tab_columns > where table_name = '#UCase("TableName")#' > and column_name = '#UCase("ColumnName")#' > >SQL Server probably has a similar construct. Th

Re: Form Builder>?

2002-07-03 Thread S . Isaac Dealey
> Anyone know if any coldfusion based HTML form generators exist??? > > I need one but would like to avoud building it if at all possible.. I've built a couple of them, but haven't published them -- they're not stand-alone apps... A friend of mine built this one: http://www.cfxtras.com/SalesCom

RE: DB ?

2002-07-03 Thread Chris Lofback
Do you mean the max field length of a text field in a DB table? In Oracle it would be something like this: select data_length from user_tab_columns where table_name = '#UCase("TableName")#' and column_name = '#UCase("ColumnName")#' SQL Server probably has a similar construct. Chris Lofback Sr.

Re: DB ?

2002-07-03 Thread S . Isaac Dealey
> you cant use len on a text type :) thats why i'm trying to see if theres > another way to do it short of doing it in CF Ahh... I'd never tried using len... I knew you couldn't group on them... You can probably do it with a cursor: DECLARE @ctext TEXT; DECLARE @clen INT; SET @clen = 0; DECLAR

RE: Client variable purge on Solaris?

2002-07-03 Thread Stacy Young
Found it...nevermind! :) http://www.macromedia.com/v1/Handlers/index.cfm?ID=22419&Method=Full -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 2:39 PM To: CF-Talk Subject: Client variable purge on Solaris? Anyone ever have any trouble with

Re: DB ?

2002-07-03 Thread Bill Wheatley
you cant use len on a text type :) thats why i'm trying to see if theres another way to do it short of doing it in CF Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: "S. Isaac Dea

Form Builder>?

2002-07-03 Thread Kris Pilles
Anyone know if any coldfusion based HTML form generators exist??? I need one but would like to avoud building it if at all possible.. KP __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusi

Client variable purge on Solaris?

2002-07-03 Thread Stacy Young
Anyone ever have any trouble with CF on Solaris not purging client variables? We're still storing in the "registry"It's being moved out of there but in the meantime I need it to purge...and it's not! Stacy Young System Integration Specialist, Architecture Surefire Commerce http://www

Re: DW MX Color Coding pages.

2002-07-03 Thread Neil H.
Perfect. Thanks! Neil - Original Message - From: "Massimo, Tiziana e Federica" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 03, 2002 2:25 PM Subject: Re: DW MX Color Coding pages. > > Is there a way to make another extension like .txt format like a .cfm

Re: DB ?

2002-07-03 Thread S . Isaac Dealey
> Whats the best way to get the max length of a column in a TEXT Field? > > ANy ideas? I'm guessing you want to know the maximum length of the existing values? ... shouldn't this work? SELECT MAX(LEN(mytextcolumn)) AS maxlength FROM mytable .. The only other way I can think of would be to draw

COM Object Help

2002-07-03 Thread Hatton Humphrey
Okay, switching subjects slightly... I've got an app that is using the HTML2EXCEL custom tag that is working great on my dev server (WinNT, Netscape Webserver, CF 4.0.1). When I go to run it on my production server (Win2k, IIS 5, CF 4.5.1) I keep getting "Error trying to create object specifie

Re: DB ?

2002-07-03 Thread Jochem van Dieten
Bill Wheatley wrote: > Whats the best way to get the max length of a column in a TEXT Field? Text is unlimited length. At least, in the RDBMS I am currently using :) Jochem __ Your ad could be here. Monies from ads go to suppo

Re: DW MX Color Coding pages.

2002-07-03 Thread Massimo, Tiziana e Federica
> Is there a way to make another extension like .txt format like a .cfm page > in DreamWeaver MX? You may try: http://www.macromedia.com/support/dreamweaver/ts/documents/add_ext_mx.htm Massimo __ Signup for the Fusion Authorit

Re: cfx_spell on ColdFusionMX

2002-07-03 Thread Critter
oi Chris!! there is a problem with cfx_zip running under mx.not sure if _spell falls under the same category or not... -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - Wednesday, July 3, 2002, 2:20:15 PM, you wrote: CW> Has anyone got the

cfx_spell on ColdFusionMX

2002-07-03 Thread Chris White
Has anyone got the custom tag cfx_spell to run on ColdFusionMX? The install program does not detect ColdFusionMX so it won't install. I have tried to copy things manually and register the cfx_spell.dll and it seems to register ok but when I run a page and call the custom tag I get the followin

DB ?

2002-07-03 Thread Bill Wheatley
Whats the best way to get the max length of a column in a TEXT Field? ANy ideas? Danks Bill Wheatley Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 __ Your ad could be h

RE: Listing Current Activity (Stored Procedure??)

2002-07-03 Thread James Taavon
um, i have not attempted a query yet, i thought i would pose the question before i started. -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:55 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) Sorry, my bad. I

CFStudio 4.5.2 doesn't show RDS mappings in Open/Save/Save As dia log boxes

2002-07-03 Thread Earl, George
I have RDS working in both the "Files" and "Database" Resource tabs in CF Studio. I can see Allaire FTP & RDS in Windows Explorer. The problem I am having is that if I click "File>Open" or "File>Save" or "File>Save As" or if I use the corresponding icons on the toolbar, I do not see Allaire FTP &

RE: JS WDDX Problem - Is it fixed?

2002-07-03 Thread Raymond Camden
This should have been fixed in 5.0 as well. Anyway, yes, it's also fixed in MX. === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful al

JS WDDX Problem - Is it fixed?

2002-07-03 Thread Ben Johnson
I have used the WDDX tag extensively in the past to pass variables to javascript but I always had a problem when passing structures that use integers as their keys. For example: This ends up erroring because

RE: File Size limit with CFFile?

2002-07-03 Thread Matt Liotta
You'd do best to steer clear of COM with CF. I would suggest using a servlet or JSP page instead. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] > -Original Message- > From: Thanh Nguyen [mailto:[EMA

Re: MSSQL/ODBC connection best practices?

2002-07-03 Thread Jamie Jackson
Thanks again, Dave. Jamie On Wed, 3 Jul 2002 13:21:07 -0400, in cf-talk you wrote: >> Generally, should you maintain connections with MSSQL/ODBC >> datasources? (Or, how do you decide?) >> >> Also, specifically, should you maintain them when using >> MSSQL DBs for client variable storage? > >

RE: File Size limit with CFFile?

2002-07-03 Thread Thanh Nguyen
Matt, That's an interesting way to do it. I'll look into that. Thanks. Thanh -Original Message- From: MW [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 4:08 PM To: CF-Talk Subject: RE: File Size limit with CFFile? We had a terrible time with CFFile and uploads. We got not on

RE: Listing Current Activity (Stored Procedure??)

2002-07-03 Thread Ryan Pieszak
Sorry, my bad. I misinterpreted his question. :( -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:57 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) Ryan, Yes, I agree with you. You can wrap your query

RE: Listing Current Activity (Stored Procedure??)

2002-07-03 Thread Mark A. Kruger - CFG
Ryan, Yes, I agree with you. You can wrap your query in a stored proc and it may indeed be faster and provide a level of abstraction. But, I sensed that he was saying there was no way to do this in a query - that he would have to write a lengthy case statement or temp table or whatever to accompl

RE: Listing Current Activity (Stored Procedure??)

2002-07-03 Thread Ryan Pieszak
Just my two cents... We've found that SP's are much much quicker than queries. So even if you could do it in a query, you may want to consider a stored proc. At least do some performance testing on both. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wedn

RE: Listing Current Activity (Stored Procedure??)

2002-07-03 Thread Mark A. Kruger - CFG
James, Stored procs are great - and a great idea, but why for this specific thing? Couldn't you do it in a query? select blah blah. WHERE month(columname) = month(gedate()) -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:27 PM

OT: and Mouse events...

2002-07-03 Thread Ryan Pieszak
Sorry for the off-topic post, but I can't find an answer any where else... We're using some graphing applets, and a client has requested that the cursor change to the crosshairs rather than the default arrow. Seem easy, right? I'm trying to do an onMouseOver and onMouseOut to set the this.style.

DW MX Color Coding pages.

2002-07-03 Thread Neil H.
Is there a way to make another extension like .txt format like a .cfm page in DreamWeaver MX? Thanks, Neil __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http:/

RE: ODBC Error Code = 08001

2002-07-03 Thread Thanh Nguyen
Josh, that's what I thought to, I'm running a trace right now. Thanks Thanh -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 7:17 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 Could be a network problem. The web server is able

Listing Current Activity (Stored Procedure??)

2002-07-03 Thread James Taavon
I believe I need a stored procedure for this, but I thought I would ask anyway. I want to be able to list the current month's activity from the first of the month to the current date. In other words, a live data dump from 1st to current date. Am I correct in guessing stored procedure? ___

RE: Certification

2002-07-03 Thread Adrian Lynch
The truth is, I'm very new to CF. I just see the cert as being some sort of indication that I can so at least some CF. I don't think it could ever be a bad thing obtaining a cert. As to it's value, I only know I want one. Be it 5 or MX :O) And Brian, where's the CF5 demo upgrade? :OP Ade -O

RE: ODBC Error Code = 08001

2002-07-03 Thread Thanh Nguyen
Yeah. We have a firewall. the webserver is set up as an IP forwarding. -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 5:53 PM To: CF-Talk Subject: RE: ODBC Error Code = 08001 Do you have a firewall? > -Original Message- > From

RE: MSSQL/ODBC connection best practices?

2002-07-03 Thread Dave Watts
> Generally, should you maintain connections with MSSQL/ODBC > datasources? (Or, how do you decide?) > > Also, specifically, should you maintain them when using > MSSQL DBs for client variable storage? The general answer here is yes, you should typically maintain database connections whenever u

MSSQL/ODBC connection best practices?

2002-07-03 Thread Jamie Jackson
Generally, should you maintain connections with MSSQL/ODBC datasources? (Or, how do you decide?) Also, specifically, should you maintain them when using MSSQL DBs for client variable storage? I know it's not advisable to maintain connections to Access DBs, but I haven't seen anything regarding M

RE: Cold Fusion Marking Information

2002-07-03 Thread Vernon Viehe
I didn't see any of the old ones, so I don't know if this is just the same, but we do have a technology comparison chart which compares CF to competing technologies: http://www.macromedia.com/software/coldfusion/productinfo/competitive/ -Vern > I agree that something like this would be very nic

RE: Certification

2002-07-03 Thread Brian Simmons
Hi, If you're going to get your CF Certification, be sure to check out: CF_Buster at: http://www.centrasoft.com CF_Buster has over 550 questions to help you prepare for the ColdFusion 5.0 certification exam. There are 9 predefined tests, topic tests, and the ability to create random tests. You

Re: What's this in my logs??

2002-07-03 Thread Jamie Jackson
Well, I created a CFIDE virtual directory in Site1, which points to the *real* CFIDE directory, so that CF can at least find those files, and stop all the log entries. Now, how do I get CF to look in the *real* CFIDE directory (where my CF Admin is installed, etc.) for serverinfo.cfm and getmetri

RE: CF - Web Based Org Charts

2002-07-03 Thread chris.alvarado
Here is something I just through together, This is not Dynamically driven yet. But soon will be. All this really is, is an XSL style sheet applied to an XML Document, and some VML elements thrown into the XSL document. http://www.squidinc.com/intranet/sales/results.htm -Original Message--

Re: server ip and CGI vars

2002-07-03 Thread Jason Miller
just a a few cool - complete tag and funcion lists - has the cgi vars listed as well - http://www.teratech.com/freestuff.cfm thought it helpful for those of us who don't know all the tags available. jay John McCosker wrote: >Will I can't see anything listed that will give this info, > >all lis

RE: CF - Web Based Org Charts

2002-07-03 Thread Dan O'Keefe
Where id you find the examples? Dan -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:10 PM To: CF-Talk Subject: RE: CF - Web Based Org Charts Actually, an update; I found some nice examples of doing just this is XML / VML so I have d

RE: SMTP MAIL SOLUTION ON SQL SERVER

2002-07-03 Thread Alan Quinlan
We just got the newest version of IMAIL here to replace our old crap we're using now. Haven't implemented it yet though but seems like a good program. But we only got the up to 250 users license since were a small business. -AQ -Original Message- From: Mike Byers [mailto:[EMAIL PROTECTE

RE: CF - Web Based Org Charts

2002-07-03 Thread chris.alvarado
Actually, an update; I found some nice examples of doing just this is XML / VML so I have decided persue this route. Yes this solution will only work in IE 5 and up, but luckily this is for a an intranet so that is one of the requirements we alreasy have in place. Thanks for everyone's feedback

Re: CF - Web Based Org Charts

2002-07-03 Thread Nick de Voil
Chris > A new client project of mine is going to requires some sort of dynamic > web based Org Chart creation. > > Preferably a package that will integrate with CF. > > It would be nice if the interface were somewhat drag and drop. Fig Leaf had a rather cool demo of exactly this based on Flash b

RE: Cold Fusion Marking Information (CF-Talk FAQ)

2002-07-03 Thread Chris Lofback
D'oh! I've used that FAQ many times in the past but never knew it was the "official" CF-Talk FAQ. Well, if that's the CF-Talk FAQ, why not just refer people to it when they post such questions? (Although, according to the date, it *is* a year out of date...) Chris Lofback Sr. Web Developer TR

RE: CF - Web Based Org Charts

2002-07-03 Thread Dave Watts
> A new client project of mine is going to requires some > sort of dynamic web based Org Chart creation. > > Preferably a package that will integrate with CF. > > It would be nice if the interface were somewhat drag and > drop. > > Also, the ability to contain links to sections that explain

RE: Returning Error codes with a UDF.

2002-07-03 Thread Thane Sherrington
At 11:17 AM 03/07/02 -0400, Raymond Camden wrote: >Then, check the result. > >Make sense? Yup. Thanks. T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http:

RE: Cold Fusion Marking Information

2002-07-03 Thread Ken Wilson
>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq How about the one listed at the bottom of each email? Not CF-Talk specific but is helpful. Ken __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: h

Re: CF - Web Based Org Charts

2002-07-03 Thread S . Isaac Dealey
> A new client project of mine is going to requires some sort of dynamic > web based Org Chart creation. > > Preferably a package that will integrate with CF. > > It would be nice if the interface were somewhat drag and drop. > > Also, the ability to contain links to sections that explain a certai

Re: Cold Fusion Marking Information

2002-07-03 Thread Michael Dinowitz
Look down. Way down. Down at the bottom of every post. Tell me what you see. :) > We *really* need a CF-Talk FAQ for questions like this (and many others like > it). Is there one? Or has there ever been one? > > Chris Lofback > Sr. Web Developer > > TRX Integration > 28051 US 19 N., Ste. C >

RE: Returning Error codes with a UDF.

2002-07-03 Thread Raymond Camden
Error handling in UDFs can be accomplished many ways. 1) Let the server handle it. Imagine a UDF that returns the length of an array. (Yes, we have a built in function for that...) It could look like so: function myArrayLen(a) { return arrayLen(a); } If you pass a structure instead of

RE: Cold Fusion Marking Information

2002-07-03 Thread Chris Lofback
We *really* need a CF-Talk FAQ for questions like this (and many others like it). Is there one? Or has there ever been one? Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EM

RE: Cold Fusion Marking Information

2002-07-03 Thread Mark A. Kruger - CFG
Matt, You have a child named cold fusion? Bound to grow up to be scientist - or a serial killer (with my apologies to general mills). -mk -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 10:11 AM To: CF-Talk Subject: RE: Cold Fusion Ma

RE: Cold Fusion Marking Information

2002-07-03 Thread Thane Sherrington
At 11:11 AM 03/07/02 -0400, Matthew Friedman wrote: >All I am looking for is any type of documentation that has the comparisons >like what was available for cf 4.0 vs asp 3.0 > >The new comparison has to be cf MX or CF 5 to .net I agree that something like this would be very nice to have, but it

  1   2   >