Re: Determining Database Type

2004-01-13 Thread Nick de Voil
> What I'm wondering, though, is if there is a way for me to run a query in my > application.cfm to determine the version of the database I'm running.  At > the moment I'm exploring using a CFCatch around a specific MySQL query > (select version()), but does anyone have any better ideas of how to g

Re: Flash question - newbie

2004-01-05 Thread Nick de Voil
Clint > > The only 2 tools you need Flash MX 2004 Professional and Sapien's > > PrimalScript www.sapien.com. > > > > What's the minimum software requirement for developing Flash > > > apps? What would be the benefits of alternatives to the minimum? Why is PrimalScript part of the minimum require

Re: Session variable time out?

2003-12-18 Thread Nick de Voil
> And if the user does not have cookies turned on?  No session scope avail > then :-( Not exactly http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applica tions_with_CFML/sharedVars3.htm Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Set

Re: MS-SQL 2000 NULL Problem

2003-12-17 Thread Nick de Voil
Mark > Update MyTable > SET email = Len(FORM.email)>'#FORM.email#'NULL > Where memberID = #FORM.memberID# Looks good to me. Unless you want to use - http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html Nick [Todays Threads] [This Message] [Subscriptio

Re: MS-SQL 2000 NULL Problem

2003-12-17 Thread Nick de Voil
Mark > All the empty fields in the email db contain How exactly do you know the email field is null? It seems to me that if "WHERE L.email IS NOT NULL" returns the rows, then that's the surest proof that the field is not null. Nick [Todays Threads] [This Message] [Subscription] [Fast Uns

Re: Best Practices

2003-12-17 Thread Nick de Voil
Jochem > unfortunately CFML doesn't allow the clean syntax PHP and C allow cfscript? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: How to alter just column name in MS SQL? Oracle?

2003-12-12 Thread Nick de Voil
Matt > I have a field name in a db that I'd like to rename from fieldname1 to > fieldname2 (leaving the data intact and fieldspecs the same) via a SQL > statement. MySQL is unusually obliging in this respect. IIRC in SQL Server you need to use sp_rename()  to rename a column. I'm not at all sure

Re: SQL UNION Trouble

2003-12-09 Thread Nick de Voil
Mark > In the following query I want the email addresses from two different tables > to be grouped together (for sending in CFMail), can't get it to work, what > am I missing? (BTW: the individual queries work just not as a UNION) Try putting the column names in the same order in both parts of th

Re: XML and the Degree Sign

2003-12-09 Thread Nick de Voil
Scott > Other than stripping out the degree symbols in the data first (which is > a bit of a kluge and leads to a time when I see us having to strip out > other characters), is there something else we can try? Also a kludge I guess but you could substitute them all with the entity ° Nick [Today

Re: SQL col type

2003-12-09 Thread Nick de Voil
Mickael > Hi I don't really have that skill set, is that the only way to do this? In Access, I think so. Most other DBMS have tables that you can query for this info but Access only has a table of tables, not a table of columns. The ADO way is not too hard using CFOBJECT iirc. Nick [Todays Thr

Re: Flash Instant Messenger Software?

2003-12-09 Thread Nick de Voil
Novak > It's really nothing more than a Flash movie using ColdFusion as > "middleware" to do SQL selects and inserts from a database table.  Some > might argue that using session/client variables would be better... but > for corporate reasons we wish to keep a 14 day (configurable of course) > log

Re: SQL col type

2003-12-08 Thread Nick de Voil
> I don't know if this is possible or not but I thought I would ask.  I am using Access and I would like to know if it is possible to return along with my query the type of field that I am querying. If this is MX, and you want to write some Java code, you can do it via the JDBC metadata interface.

Re: I could use a JS expert right now.

2003-12-08 Thread Nick de Voil
Che > the page still bombs. this sucks. Can you post the generated source code? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: I could use a JS expert right now.

2003-12-08 Thread Nick de Voil
> - Error: document.PageSwitch2.Action has no properties action is lower case. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: hostdepartment.com?

2003-11-28 Thread Nick de Voil
Oliver > If not can anyone recommend current hosts which are preferably MX > enabled, a reasonable price & have msSQL. If you want a UK-based one you might take a look at http://www.cfmxhosting.co.uk Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings

Re: Problems using JRUN4 and CFMX together.

2003-11-26 Thread Nick de Voil
> If you're running CFMX 6.1, I'd recommend taking a look at just running CFMX > on top of your existing JRun install Is "CFMX for J2EE" now simply an install option for Enterprise then? Or is it a different product version? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsub

Re: Problems using JRUN4 and CFMX together.

2003-11-26 Thread Nick de Voil
> We seem to be having trouble getting JRUN4 and CFMX to work together. There may be a way of getting a standalone JRun to play nice with the one in CFMX, but we couldn't figure it out. We gave up in the end and we're running our pure Java apps through CFMX Enterprise's built-in JRun as well as ou

Re: Source Control: everyone uses it, right?

2003-11-25 Thread Nick de Voil
> Would you > hire a web development shop to work on a project > if they routinely did not use source control but relied > on the developers to maintain informal source control? That would depend on the complexity of the requirements (especially interfaces to other systems/components), the depende

Re: Heartbeat with Flash?

2003-11-25 Thread Nick de Voil
> I currently have an application that has a built in "heartbeat"... A 1x1 > pixel iframe that refreshes itself every 30 seconds. Or just use an img tag? Works for me. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: ImageMagick

2003-11-22 Thread Nick de Voil
> Can someone steer me in the right direction to lear to use ImageMagick? I guess you know about [EMAIL PROTECTED] ? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Flash link to pop-up

2003-11-21 Thread Nick de Voil
> I know, everyone hates pop-ups. I only use pop-ups to display larger > images from thumbnails. Is it possible (via actionscript) to create a > pop-up? How is it done if so? getURL(url, "_blank") or getURL(url, existingWindowName) should do it. But I always wonder, why is it that everyone suppos

Re: java/cf

2003-11-20 Thread Nick de Voil
> All I need to do is send in 1,1,1 to this method: > public void setWidths(float[] widths) throws BadElementException { float[] widths = {1.0,1.0,1.0}; setWidths(widths); Any good? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Remotely cycling CF server

2003-11-20 Thread Nick de Voil
Tom > Check out servers alive at http://www.woodstone.nu/salive/ Thanks Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Remotely cycling CF server

2003-11-20 Thread Nick de Voil
Dave > It seems to me that you'd be better off reducing the number of "moving > parts" in this process. Why not write something that just runs on the > server? You're right (as usual), it's a bit of a mess. I was just being lazy & trying to avoid writing any code. Nick [Todays Threads] [Thi

Remotely cycling CF server

2003-11-20 Thread Nick de Voil
We have been suffering from this problem with CFMX 6.1 that a lot of people seem to have been having, where CF seizes up periodically. Every time this happens we have to log in remotely and restart the CFMX services. I'm trying to set up a system on my desktop that will detect that there's a probl

Re: SOT: OO Design

2003-11-18 Thread Nick de Voil
Deanna > Okay, so I was following along, but then you throw this out there. Huh? I > thought that we're all supposed to start "thinking OO" to fully leverage > CFC's. Am I wrong here? No, of course you're not wrong - but there's more to CF than CFC's :-) Nick [Todays Threads] [This Message]

Re: SOT: OO Design

2003-11-18 Thread Nick de Voil
> I'm not sure how 3 objects makes this any more likely than 2 objects. I think Dwayne is referring to the fact that, once you've gone beyond having one table or object class to model each real-world "thing", the criteria you apply in each method for discovering your other artefacts are quite diff

Re: Not Subscribed: OT: SQL Server to Oracle migration

2003-11-04 Thread Nick de Voil
> 1) Will the SQL in my CF Templates still work after the migration? Most likely not. Depends how standards-compliant your SQL is. Date functions, string functions, data type conversions may give you a problem. SEQUENCEs will need to be changed to IDENTITY columns. Nick [Todays Threads] [T

Re: page encoding french characters stupid hosting

2003-10-31 Thread Nick de Voil
> You mean the lang environment variable on the server settings right? I mean the Linux environment variable on the server, yes. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: page encoding french characters stupid hosting

2003-10-31 Thread Nick de Voil
> ALL ACCENTED CHARACTERS that are passed to the server via web > forms are converted to `y. We had a similar problem in a JRun/Linux environment which was fixed by setting the LANG environment variable appropriately. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: Scope Locking (RE: Blue Dragon and Fusebox)

2003-10-28 Thread Nick de Voil
I could well be wrong here, but I think maybe people are being misled by the statement in the MM doc: "Simply put, a race condition occurs anytime two threads (in this case, page requests) try to write to the same data at the same time. " That doesn't fully describe what's happening in their exam

Re: How can it be done ?

2003-10-28 Thread Nick de Voil
> I think that writing to the registry will be the best solution for this. cfregistry writes to the server's registry, not the client's. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Eolas patent suit

2003-10-25 Thread Nick de Voil
> You don't have anything to worry about, Jeff.  Users who have enabled > ActiveX controls in Outlook will not be prompted before the Flash > player and other ActiveX controls are loaded. Does anyone in their right mind enable ActiveX controls in Outlook? Nick [Todays Threads] [This Messa

Re: Programatically Adding Custom Tag Paths

2003-10-21 Thread Nick de Voil
Oliver > Ideally I'd like to update the custom tag paths for the duration of a > request and no longer. > > Anyone got any ideas? Nasty hack, but but you could do something with ? Or use CFCs or UDFs? Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Set

Re: ...this HTML cf-talk system

2003-10-04 Thread Nick de Voil
> How about trying to turn it back on and then off again to see if it still > works for you? > > I've been trying for several days and my choice is always ignored. Ah... just looked at it again... maybe I did something different ffrom you. I chose "Text only email" from the dropdown. I don't think

Re: ...this HTML cf-talk system

2003-10-04 Thread Nick de Voil
> I don't want to deny anyone the choice of using html email but the option of > turning it off needs to be fixed. Everytime I uncheck the html preference at > houseoffusion.com it comes right back, never accepts that as my preference. Strange, I turned off the HTML option within the first two or

Re: CFMX Instances on JRUN

2003-09-27 Thread Nick de Voil
Joe> I wasnt able to find any clear documentation of the correct setup> for Multiple Instances of CFMX on JRun.Did you see this?http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/clusteri.htm#wp102311Not a very full explanation I know.Nick [Todays Threads] [This Message] [Subscription] [Fast U

Re: SQL List Comparison

2003-09-26 Thread Nick de Voil
Neil> Anyone know if and how you can compare two lists in SQL?imo the answer to all questions about lists in SQL is... don't store yourdata as lists!Not  a very helpful statement I know. But you could read the lists intoanother table with a normalised structure and all of a sudden the querywould be

Re: SQL Table pains

2003-09-26 Thread Nick de Voil
Robert> This is off topic somewhat, but I needed to move a SQL table to anotherSQL server. At first it seems the table did not import. So I deleted the oneon the new server and then imported the table I wanted (same name). Now theCF cart I created reads the records twice even though the table has o

Re: SQL question

2003-09-25 Thread Nick de Voil
MichaelHow about something likeSELECT sum(UNIQUE_VISITs) AS sys_sum, to_char(unique_date,'MM') AS monthno, to_char(unique_date,'MON') AS monthnameFROM unique_sessionsWHERE SITE = '#client#'GROUP BY monthno, monthNick [Todays Threads] [This Message] [Subscription] [Fast Unsu

Re: Repost: Passing a RecordSet via Webservice to a Delphi App..

2003-09-23 Thread Nick de Voil
Brook > Does any one know what the best way to pass a CF recordset via a webservice > to a desktop application developed in Delphi would be? Would I need to > convert the recordset to an alternate format before sending it to a desktop > app via a webservice? > > Would I need to convert the query t

Re: Jrun4 and CFMX

2003-09-22 Thread Nick de Voil
> Well, if you ever used CF3.0, which had NO proper way ... What was the point of that post? POS, indeed. My 2 cents worth: we've been using both CF and JRun for some time now. JSP, on its own, has nothing to recommend it over CF, except that you can deploy JSP apps on free standards-based softwa

CFMX 6.1 and JRun 4

2003-09-17 Thread Nick de Voil
We have had CFMX and JRun 4 coexisting peacefully on a W2K server for months, blissfully ignorant of each other. Last week we upgraded CF to 6.1 and now it appears that JRun is interfering with CF somehow. CF was grinding to a halt on a regular basis until we disabled the services for the JRun serv

CFCHART error

2003-06-24 Thread Nick de Voil
Hi everyone, We rebuilt our server (CFMX/W2K), and CFCHART now falls over with the following error. Looks as if part of the JRE is missing. Has anyone seen this/know how to fix it? Thanks Nick The chart could not be generated due to an error in the graphing engine.

Re: DB Driven Collapsable Tree

2003-03-27 Thread Nick de Voil
> I'm looking for a tree structure that can be expanded and collapsed much > like Windows Explorer. I'm surprised no-one has mentioned Joust. Not supported any more but still pretty good, don't you think? http://www.ivanpeters.com/index.htm?page=/joust/ Nick PS I *love* Jochem's solution to the

Re: JSP and outputing cgi variables

2003-03-27 Thread Nick de Voil
> Sorry for the OT post, I'm a JSP newbie and need to know how I would do > > > #cgi.server_name# > > > on a JSP page? <%=request.getServerName()%> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 S

Re: J2EE session replication -- application replication?

2003-03-25 Thread Nick de Voil
Isaac > I'm not familiar... What's JMS? Java Message Service - it's the J2EE spec for publisher-subscriber and point-to-point messaging. Supported by JRun & other J2EE products. As Sean says, it's quite hard work though. Nick ~~~

Re: J2EE session replication -- application replication?

2003-03-24 Thread Nick de Voil
> What I'm really wondering if there's a way to get something like J2EE > session replication for the application scope. I've wondered this too, but it seems that, because application data is part of the servlet context, and the servlet context is unique to each JVM, there is no built-in way to do

Re: (CFMX) Array Max size?

2003-03-24 Thread Nick de Voil
> Should be...max java class size issue? It's reminiscent of a problem I've had using JSP custom tags in JRun, where the compilation would fail if you had too many custom tag invocations in a page. The only solution seemed to be to split the source up using JSP includes - quite annoying at the tim

Re: SQL Help

2003-03-19 Thread Nick de Voil
Sorry abot the fingers. What I was about to say was - is 600 and 400 the result you *want* or that you don't want? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.co

Re: SQL Help

2003-03-19 Thread Nick de Voil
- Original Message - From: "JS" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 19, 2003 1:42 PM Subject: OT: SQL Help > I know there are some smart SQL people on this list, > so I hope someone would be willing to help me with my > problem. > > I have 2 tables

Re: Free SQL Server

2003-03-18 Thread Nick de Voil
Bryan This is exactly what we're talking about in the thread about MSDE. MSDE (Microsoft Data Engine) is a baby SQL Server. It's on the Office XP CD amongst other places. Nick - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesda

Re: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-18 Thread Nick de Voil
> That's the answer. The 120 day trial of SQLServer is handed out like > lolly water by Microsoft at any of their promotions. The server expires > after 120 days but I don't think the EM does. Thanks, yes, I think that must be where I had it from before - I had a SQL Server 7 book with an evaluat

Re: Documentation examples

2003-03-18 Thread Nick de Voil
Maybe you should take javadoc into consideration also. > I wouldn't know of any such standard, but it is an issue I have encountered as > well. What I was wondering is if there would be any interest in defining an XML > schema for documentation and write some tools to create several derivative > f

Re: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-18 Thread Nick de Voil
Jason > >From what I can remember theres three option, Client Tools only, DB & Client > Tools, or DB Only. It didn't give me any options. Is this MSDE or a proper SQL Server you've got? Nick ~| Archives: http://www.houseoffus

Re: CF Talk is not a javascript forum but I need help!

2003-03-18 Thread Nick de Voil
> I wrote a "highlight keyword" function in JavaScript where I use the > innerHtml property to get the body content into a variable. The script works > fine with IE 4.x and NS 7, but NS 4.x doesn't support this property. > > Does anybody know an equivalent property that works in NS 4.x. ? There is

Re: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-18 Thread Nick de Voil
Thanks Jason. So - stupid question - that means you have a file called "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC" ? I don't. Where did you get it from? Nick ~| Archives: http://w

Re: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-18 Thread Nick de Voil
> It had one on Windows 98. Well, let me rephrase that. I have MSDE on my W98 machine and also EM, and if EM isn't part of MSDE where did I get it I wonder... don't remember. Using isql for development is fine for a manly man like me ;-) but also I wanted to use EM to administer a remote SQL Serv

Re: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-17 Thread Nick de Voil
Hi Paul > msde has no GUI, its for manly men who use t-sql ;-) It had one on Windows 98. Has that changed? Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com

OT: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-17 Thread Nick de Voil
I've been trying to install MSDE on XP Pro from the Office XP Pro CD. The actual server part appears to have worked. I have some files under Program Files\Microsoft SQL Server, in 2 folders called MSSQL and 80 respectively. The readme file in MSSQL is interesting but says nothing about how to inst

Re: JS problem

2003-03-06 Thread Nick de Voil
Emmet > if ((isNan(document.CartForm.myField.value)) || Try if ((isNan(document.CartForm.elements[myField].value)) || Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.house

Re: New Macromedia.com launched!

2003-03-06 Thread Nick de Voil
Sorry, way OT by now. > I took a seminar a while back on Section 508 and they explained that the > word Handicap was given to disabled people because most disabled people at > the time were Vietnam vets. The word handy capped means to had out a > baseball call in and ask for a hand out. What a b

Re: FBX3 AND CFMX

2003-02-26 Thread Nick de Voil
> Or if you're a larger shop that has a vested interest in a "secret" > methodology -- much like the people of Florence at one time gave > Michaelangelo's David a FigLeaf, which only serves to create interest in > what is covered up-- then any open publically known framework, Fusebox or > otherwis

Re: CFMX for J2EE on JRun 4

2003-02-26 Thread Nick de Voil
> Did you install JRun 4 SP1a ? (it breaks CF) This only affects CFMX for J2EE, right? I hope there isn't a problem for those of us running JRun separately alongside CFMX Pro? Thanks Nick ~| Archives: http://www.houseoffusio

Re: FBX3 AND CFMX

2003-02-25 Thread Nick de Voil
John > To answer your question, our thinking is as follows: CFCs are not ready for > the big time. > > The reasons why have been discussed and debated for literally months by tons > of people on the various lists. All the same, would you mind just giving a summary - for those of us who've missed

Re: CFHTTP timeout

2003-02-24 Thread Nick de Voil
Thanks Bud. Any advance on that, anyone? > CFHTTP has a problem with pages that are delivered in steps, such as > a page that come back with "Please wait while your request is > processed". It will get that first message and think the page is > done. Not sure what you can do about it if anythi

CFHTTP timeout

2003-02-24 Thread Nick de Voil
We're using CFHTTP (CFMX) to get PDF documents translated to HTML by Adobe's online service at http://access.adobe.com/perl/convertPDF.pl . CFHTTP appears to be finishing reading the output before it's finished coming back. I don't think it's timing out because we have the timeout set to 600, both

Re: Searching CFM files in Windows XP

2003-02-16 Thread Nick de Voil
> have u installed the service packs? It's a new computer. It has SP1 installed. Is there another one? Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_l

Re: Searching CFM files in Windows XP

2003-02-16 Thread Nick de Voil
> what exactly are ya tryin to do? search within those files? Yes. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4

Re: Searching CFM files in Windows XP

2003-02-16 Thread Nick de Voil
it will default to searching all of the local hard drives > you have. > > have you tried this? > > tony > > -Original Message- > From: Nick de Voil [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 16, 2003 6:17 AM > To: CF-Talk > Subject: OT: Search

Re: Basic HTML Question

2003-02-16 Thread Nick de Voil
> URL fragments, used to reference named anchors, and query strings are not > mutually exclusive in any respect. You can use either or both within a > request. If you use both, the query string is processed by the application > server, and the URL fragment is used by the browser to navigate to the

OT: Searching CFM files in Windows XP

2003-02-16 Thread Nick de Voil
Hello everyone, I'm sure this must be in the archives but I can't find it. I've only had XP on my desktop machine for a couple of months. My Documents > Search > A word or phrase in the file doesn't work for me. It doesn't find the occurrences of the word. If I search the same set of folders fo

Re: I need to recommend a J2EE server

2003-01-27 Thread Nick de Voil
Eric > I need to recommend a J2EE server, or rather, I need this list too! JRun works great for us (Linux, MySQL) Nick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffus

Re: Verity operators - THESAURUS, TYPO, SOUNDEX

2002-09-30 Thread Nick de Voil
OK, I RTFM'ed and in Developing ColdFusion MX Applications with CFML I find this: THESAURUS Expands the search to include the word that you enter and its synonyms. Collections do not have a thesaurus by default; to use this feature you must build one. SOUNDEX Expands the search to include the wo

Verity operators - THESAURUS, TYPO, SOUNDEX

2002-09-30 Thread Nick de Voil
I'm looking at this Verity doc http://www.verity.com/pdf/white_papers/MK0348a_Discovery_WP.pdf and I like the look of the THESAURUS, TYPO and SOUNDEX evidence operators. Are these available via CF? If not, what do I have to do to get them and what does it cost? Thanks Nick __

Re: Pagination (should be basic)

2002-09-30 Thread Nick de Voil
Russ > I'm trying to understand how to do simple pagination This is called a next-n interface. There are quite a few web resources on this if you do a search. Basically you need to do a CFQUERY... CACHEDWITHIN... to get the data efficiently, then display it on the page using variables to keep t

Re: CFMX - Java ADO replacement?

2002-08-03 Thread Nick de Voil
Dick > On non-Windows platforms, you couldn't use ADO anyway. I imagine that you > could use the appropriate JDBC driver to do some of this stuff, directly > from Java, but don't know enough about either Java or JDBC to say for sure. Dave's right, you can this with JDBC. Check out in particular

Re: MX and Javabean tutorials?

2002-07-17 Thread Nick de Voil
Jon I haven't actually tried these out but I'd guess that > My question is, is a good way to unload the > object? I don't think you need to unload it like that. It wouldn't cause the memory to be released immediately anyway. The JVM's garbage collection will take care of that for you. > Also,

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

OT: Windows ME, IE6 cookies problem

2002-07-01 Thread Nick de Voil
I've tried more relevant lists on this one but no luck. This is a JRun 3.1 app. The login page submits a form and the action page sets some session variables. As you probably know, JRun handles sessions by setting a cookie called "jsessionid". All the testing so far has been done on W2K, W98 an

Re: Impending session timeout warning methods?

2002-06-05 Thread Nick de Voil
If you'd rather silently refresh the session of a user who's still in your site, without prompting them, this can be done surprisingly easily with JavaScript: var dummy = new Image(); function keepAlive() { dummy.src="servlet.KeepAlive?t=" + new Date.valueOf(); // timestamp parameter to avoid

Re: Online CSS editors ?

2002-05-22 Thread Nick de Voil
> Certainly still looking, you should put up a demo somewhere, looks like I'm > not the only one interested in something like that :-) For now, I've put a link to a screenshot at http://www.ecstra.com (link at bottom right of page). It's part of a larger system so I would need to split out that

Re: Online CSS editors ?

2002-05-21 Thread Nick de Voil
James > I am looking for a way that I can allow site admins to edit CSS styles to effect the look of a site, or page etc. It needs to be edited online. Basically I want soEditor but for editing CSS styles instead of html :-) > > Anybody seen anything like this around ? Yes, I have one I built,

Re: CFCs ( Was: Re: Inheritance : was "I like CFMX)

2002-04-30 Thread Nick de Voil
> ( On a completely unrelated note, how can I view / set / change a > classpath in Windows 2000? ) Control Panel - System - Advanced - Environment Variables Nick __ Your ad could be here. Monies from ads go to support these

Re: Inheritance : was "I like CFMX

2002-04-30 Thread Nick de Voil
Hi Neil, > IMO, CFC's are a great OOP addition to ColdFusion; sure they may not fit > into your Dictionary definition of OOP and they don't support > polymorphism, but they are still an OOP concept - yes? Yes. CFCs are the best thing since.. well, UDFs. Yes, they support inheritance. OOP is no

Re: Fusebox (was: I like CFMX)

2002-04-30 Thread Nick de Voil
> If there's anyone you can imagine sliding down the Batpole, wouldn't it be > Steve Nelson? Dave Watts maybe? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. htt

Re: OT: OO vs procedural (was: What's the difference...)

2002-03-12 Thread Nick de Voil
> XML is an implementation of SGML, which has been around for decades. Yes indeed. But I was giving an example of something changing the landscape. We now have a universally accepted, simple, mostly logical, standard for structuring data in a self-describing format that's both portable and huma

Re: OT: OO vs procedural (was: What's the difference...)

2002-03-12 Thread Nick de Voil
> Can I ask for examples? XML. It doesn't change programming, but it sure changes the landscape. btw my guess at first OO language would be Simula (1967) Nick __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RA

IsCreditCard() UDF from cflib.org

2002-03-12 Thread Nick de Voil
If anyone's got this UDF and is using the optional parameter, please download the new version which fixes a bug in the Mastercard number validation. Thanks to Troy Pullis for spotting it. Nick __ Why Share? Dedicated Win 2000

Re: slooow query using JOIN

2002-03-07 Thread Nick de Voil
Adrian > It is terrible (60 seconds) when run like this: > SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON a.id > = b.id AND b.ff3 = 'T' > WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' How about the id fields in both tables, are they indexed? Ni

Re: Coldfusion & Intelligent Queries ???

2002-01-14 Thread Nick de Voil
Oracle, right? AND eventdate >= SysDate should do it Nick - Original Message - From: Ian Vaughan <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 11:48 AM Subject: Coldfusion & Intelligent Queries ??? > Hi > > How do I modify my query below, so that

Re: SQL question

2002-01-05 Thread Nick de Voil
Chad, I think you want select distinct type from table where category = 'large' Nick - Original Message - From: Chad Gray <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 3:19 PM Subject: SQL question > I have a table that i would like to pull some

Re: fusebox and coldfusion?

2002-01-05 Thread Nick de Voil
House of Fusion has 2 lists dedicated to fusebox. Also you could have a look in the archive (see URL at the bottom of message) Nick __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER I

Re: Database AutoNum column

2002-01-03 Thread Nick de Voil
> Doesn't oracle support @@identity? No. > (What I DON'T know how to do is use that same value in subsequent > queries > without selecting it from the table I just inserted...) Use sequencename.currval. Nick __ Dedicated Windo

Re: death of coldfusion

2001-12-31 Thread Nick de Voil
Ben, > Not to mention access to JSP tag and libraries (and other Java bits) What the the future of CFML versus JSTL? (For those who don't know, JSTL is the JSP Standard Tag Library, to be included in a forthcoming J2EE spec. It lets you write JSP code that looks uncannily like CF code) Nick __

Re: Altering the name of a table

2001-12-22 Thread Nick de Voil
Brad > Can I use the alter table SQL statement to change the name of a table? No, but you can do CREATE TABLE b AS SELECT * FROM a (in some DBMS) DROP TABLE a which has the same effect. Nick __ Get Your Own Dedicated Windows

Re: XML Schema Validation

2001-12-15 Thread Nick de Voil
Dick Does this help? http://www.vbws.com/tutors/xsd/xsdvb.aspx The nitty-gritty part seems to be Dim schemaCache As MSXML2.XMLSchemaCache40 Set schemaCache = New MSXML2.XMLSchemaCache40 schemaCache.Add “”,”D:\schemas\mySchema.xsd” Dim doc As MSXML2.DOMDocument40 Set doc = New MSXML2.DOMDocumen

Re: Query Field with Null Value

2001-12-15 Thread Nick de Voil
Anthony Yes, but use "IS NULL" instead of "= NULL" (TC.Status <> 'Closed') OR (TC.Status IS NULL) Nick ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www

Re: "lower" SQL function

2000-09-07 Thread Nick de Voil
That's it in Access and it's LOWER inn the other 2. Nick - Original Message - From: Howie Hamlin <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 07, 2000 4:30 PM Subject: Re: "lower" SQL function > Try LCase > > Regards, > > Howie > > - Original Message - >

Re: Distinct Help

2000-04-28 Thread Nick de Voil
know the syntax I need?? > > > > No it doesn't make sense really. If you have more than one UserName for > each > > UserID, which I assume you do - otherwise the filtering would still be > > working - then if you want a full list of UserNames you're bound to get

<    1   2   3   >