RE: ColdFusion sightings in D/FW Area...

2006-08-09 Thread Cornillon, Matthieu (Consultant)
Word game geek here is guessing Dallas/Fort Worth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 3:05 PM To: CF-Jobs-Talk Subject: RE: ColdFusion sightings in D/FW Area... Where is D/FW? I assume it isn't around where I am because

CFX tag error

2006-03-27 Thread Cornillon, Matthieu \(Consultant\)
Hi, there. I am creating my first Java CFX tag, and I am getting the following error: PullNTID (Unsupported major.minor version 49.0) null The error occurred on line 1. (PullNTID is the name of the class.) Any thoughts? TIA, Matthieu

RE: usability skills

2006-03-17 Thread Cornillon, Matthieu \(Consultant\)
I think that there are three things here: 1) Talent for seeing problems and their solutions in user interfaces. 2) Experience with designing/fixing user interfaces. 3) Knowledge of theories/abstract concepts related to user interfaces. Number 1 may be overrated; I think that Number 2 tends to be

Pulling NT ID using ColdFusion

2006-03-09 Thread Cornillon, Matthieu \(Consultant\)
All, I run a site using ColdFusion MX7 on a Unix box. It is an intranet site, accessible only to people within the company who have logged on to the network using their NT ID. Some coworkers of mine (who run ColdFusion sites on NT boxes) are able to have their CF apps pull that NT ID for use

RE: SQL Problem

2006-03-09 Thread Cornillon, Matthieu \(Consultant\)
Mark, I'd try this: SELECT TOP 1 (controlID, memberID, memberSubmitDate) FROM tblList ORDER BY memberSubmitDate DESC HTH, Matthieu ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234884 Archives:

RE: SQL Update

2006-01-20 Thread Cornillon, Matthieu \(Consultant\)
Aaron, I Googled MySQL concatenation operator and eventually came to the CONCAT function, pasted below. I think searching for DB_SOFTWARE concatenation operator should help others find their db-specific answers as well. HTH, Matthieu CONCAT(str1,str2,...) Returns the string that results

RE: Decimal

2006-01-13 Thread Cornillon, Matthieu \(Consultant\)
Depends on what you mean by this. If you are looking for a test of whether it is an integer versus a real number with non-zero digits after the decimal point, then you can use this: CFIF Variables.MyVar = Int (Variables.MyVar !--- Variables.MyVar is an integer. --- CFELSE !---

RE: Calculate schedule timeslots

2006-01-13 Thread Cornillon, Matthieu \(Consultant\)
Well, you have a bigger problem than that. Let's take your example, where--after someone selects a start time of 11:45 AM and a finish time of 12:45 PM--you change your start time list to: 11:30AM 01:00PM What if the person selects 11:30 AM (completely valid), and then selects an end

RE: OT: Eclipse is the One Ring?

2006-01-13 Thread Cornillon, Matthieu \(Consultant\)
I just learned about eclipse recently, and I love it. I am curious, though, as to whether there is a plug-in that allows the sort of visual HTML layout editing that Dreamweaver does. You see, I am too cheap to buy Dreamweaver at home. Is there an eclipse plug-in (I've looked through and not

RE: Verity and Coldfusion MX

2006-01-13 Thread Cornillon, Matthieu \(Consultant\)
Mark, In the ColdFusion documentation, take a look at the key parameter for the CFINDEX tag. Here is some of the info: The value specified for key depends on the type attribute: If type = file, the directory path and filename for the file, If type = path, the directory path for the location

RE: FW: Outputiing dynamic columns

2006-01-13 Thread Cornillon, Matthieu \(Consultant\)
Russ, All right. Let me take a shot. First off, I don't think I really understand the ins and outs of your data, but the formatting issues remind me of a problem that I had outputting data, so I'll punt: Generally stated, you have data that is grouped by some geographic area. Within each

RE: Preventing auto-fill

2006-01-13 Thread Cornillon, Matthieu \(Consultant\)
Cameron, I use the autocomplete=off approach with much success. I am curious though: is it true that you can override this setting from within the client? Matthieu -Original Message- From: Cameron Childress [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 7:57 PM To: CF-Talk

RE: phone numbers in database

2006-01-03 Thread Cornillon, Matthieu \(Consultant\)
Brian, If you do text, you of course will want to do lots of validation on the way in to get rid of any parentheses, periods, spaces, dashes, etc. that the user puts in, so that you can then standardize it. Without advocating the original plan for number fields, I can at least tell you how to do

RE: ColdFusion Cookbook

2006-01-03 Thread Cornillon, Matthieu \(Consultant\)
Ray, This does sound like a great idea. I can't claim to be expert enough to be writing any chef entries, but I am a PITA proofreader (folks never like me because I actually find all the errors--grin), and as a medium-level CFer, I know enough to be a sample user of the thing. So, I'd love to

RE: HTML In Application.cfm

2006-01-03 Thread Cornillon, Matthieu \(Consultant\)
Hi, all. I've been just an observer on this very interesting thread, with little to contribute in favor of either idea. However, in reading through the 73 (!) posts I had not yet seen when I came in today, something striking occurred to me. I saw the two camps as Keep display code separate

RE: Adding Multiple Objects

2006-01-03 Thread Cornillon, Matthieu \(Consultant\)
Well, I would say that you can add contact info without adding a user (multiple contacts, right?) but you can't add a user without adding contact info. So, it seems to me that you first instantiate the user and then instantiate the contact info entry, not the other way around (i.e., AddUser()

RE: A Contractor or Two

2005-12-29 Thread Cornillon, Matthieu \(Consultant\)
All, I don't have much more to add, except for some reinforcement of already stated ideas. My mother and step-father have been running very successful engineering consulting firms out of their house for years, and their advice to me has echoed what the folks on this list have said: 1) Never

RE: Query String Dud - issue

2005-12-29 Thread Cornillon, Matthieu \(Consultant\)
Neal, How about this: CFIF Right(cgi.HTTP_REFERER,1) IS ? !--- URL ends with ? --- /CFIF If this is true, then the URL ends with a ?. I don't know whether having multiple ? in the URL will be necessary. If so, and if this will even work (I can't remember whether it causes browser

RE: Query String Dud - issue

2005-12-29 Thread Cornillon, Matthieu \(Consultant\)
. It looks like its adding ? to the url when I want to remove it if there is not a query string available. Hope all this makes sense. I have been starring at it so long I'm not sure if I can explain it well enough. Neal Bailey -Original Message- From: Cornillon, Matthieu (Consultant

Performance Problem - Client Variables

2005-12-15 Thread Cornillon, Matthieu \(Consultant\)
All, I am in the process of moving a CF site from one server to another. The new site is in CFMX7. I do not have access to the administrator settings, as I have to work through someone in another department on this. The problem is that I have ~8.5 seconds (+/- 0.2 seconds) delay on each page

RE: Performance Problem - Client Variables

2005-12-15 Thread Cornillon, Matthieu \(Consultant\)
All, Thanks for your input on the client variable problem I mentioned. Turns out that the problem was that the client variable store table (in an ODBC datasource) was not indexed properly. Never would have tracked that down if you all hadn't given me the hints that you did. Major problem

RE: Google search appliance and Cold Fusion

2005-11-29 Thread Cornillon, Matthieu \(Consultant\)
I, too, have had experience with this sort of thing. The approach I used has a bunch of dummy index pages that spill out db content in a way that will be interesting from a content perspective to people searching Google, but with nothing else on them. These index pages are then set with

RE: HELP!! Query - Loop - List - Form Madness

2005-11-29 Thread Cornillon, Matthieu \(Consultant\)
Molly, Hi, there. I think that using a database alias will do the trick. If you use this syntax: CFQUERY name=getindiv datasource=sotl SELECT #i# AS ProposalName FROMgrades06 WHERE readerid = #session.readerid# /CFQUERY then you can refer to that column as

RE: Jump to an anchor link inside an iframe

2005-11-29 Thread Cornillon, Matthieu \(Consultant\)
Andy, Sorry. That's what I meant to say. The idea is that page 2 dynamically builds the URL with the named anchor using information passed it by page 1. So, for example, page 1 might link to: page2.cfm?pageToLoad=nameOfPageToLoadanchorToLoad=nameOfAnchorToLoad Then, page 2 loads

RE: SQL

2005-11-29 Thread Cornillon, Matthieu \(Consultant\)
CFSHEEPISHOops. Should have known better than to make suggestions on something I had never really done myself./CFSHEEPISH :) Now that I see it, Tanguy's suggestion is obviously the way to go. The temporary table thing that my friend here suggested was for something a little more complicated.

RE: HELP!! Query - Loop - List - Form Madness

2005-11-29 Thread Cornillon, Matthieu \(Consultant\)
Ken, I ran this query on a table called USERS through Toad to an Oracle database: SELECT 404 FROM USERS and I got exactly what you described as a result: one column (named 404) with one row per row in USERS, each row equal to 404. I have contacted Molly off-list and am helping her with

RE: SQL

2005-11-28 Thread Cornillon, Matthieu \(Consultant\)
Thanks for that, but is there a way to copy a whole row... This is a snippet of code that a friend here at work sent me for creating a whole new row from a whole old row all within SQL. It is Oracle-based, and I have never used it myself, but I am pretty sure that it does what you want. Say

RE: Jump to an anchor link inside an iframe

2005-11-28 Thread Cornillon, Matthieu \(Consultant\)
This seems too easy an answer, so I probably missed something, but I'll give it a try anyway. You have page 1 currently sending variables to page 2, which dynamically loads page 3 in an interior iframe. Can you not send the name of a named anchor along with it and have page 2 load

RE: listgetat problems....

2005-11-16 Thread Cornillon, Matthieu \(Consultant\)
I think that the delimiter attribute of ListGetAt looks at each character specified on its own. In other words, it's looking for three possible delimiters: %, 2, and 0. Maybe if you used the URLDecode function first, then used a space as delimiter? Otherwise, I'd replace %20 with some uncommon

Can client.cfid and client.cftoken not exist?

2005-11-14 Thread Cornillon, Matthieu \(Consultant\)
Hi, everyone. Is it possible for Client.CFID and Client.CFTOKEN to not exist? With the exception of a read immediately following a StructClear or StructDelete statement, it seems to me that this gets set during the transfer of information between the server and the client before any ColdFusion

RE: Problem with relational tables

2005-11-14 Thread Cornillon, Matthieu \(Consultant\)
Mark, If I understand you correctly, all you need to do is a join in your query. Rather than having two queries, just have one: cfquery name=getInfo datasource=#request.dsn# SELECTdistrict_plan_documents.COLUMNNAME, district_plan_section_headings.DP_Heading FROM

making a static snapshot of a site

2005-11-11 Thread Cornillon, Matthieu \(Consultant\)
Hello, all. I am preparing for some hypothetical scenarios. Under one, my web host stops supporting ColdFusion, and I have to keep hosting my site there. Obviously, there is no way around the fact that some of the functionality cannot be preserved without serious work. However, I am looking at

RE: making a static snapshot of a site

2005-11-11 Thread Cornillon, Matthieu \(Consultant\)
Barney, Thanks! This looks perfect. Matthieu Barney Boisvert wrote: wget. Or any other web scraper/spider. We do exactly that for our sales guys when they're going somewhere and know they won't have an internet connection, so they can still have our website available.

eKnowlogie: anyone know about this product?

2005-11-07 Thread Cornillon, Matthieu \(Consultant\)
Hi, everyone. I am looking at converting a ColdFusion site to Java J2EE (sniff, sniff). I have found a product called eKnowlogie. Their site (eknowlogie.com) claims to do it all and do it all nicely. I am still researching this, but I was wondering if anyone knew anything at all about this

RE: Strange DB behaviour

2005-11-04 Thread Cornillon, Matthieu \(Consultant\)
Russ, I get somewhat similar behavior depending on how I add the data in question. I access the database in two ways: through ColdFusion code and through TOAD (a SQL client on my desktop). If I go through TOAD and I issue a regular INSERT statement and ask it to execute, I will immediately see

OT: new next primary key value in Oracle

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
Hi, everyone. I have been doing something for years that works, but feels darned silly. I have a table called WIDGETS. I have a sequence set to increment by 1 up to some ridiculous number called WIDGETS_PKSEQ. When I add a new row to WIDGETS, I put WIDGETS_PKSEQ.NEXTVAL into WIDGETS.pkWIDG, the

RE: SQL join a table to a set of values not in a table.

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
You could do a query of queries. You dynamically create a query result set that has your aDate values (cfloop over the range, and add a new row and value on each iteration). Run a query of your actual db table limited to the dates in question. Then run a query of queries where you do a join (I

RE: new next primary key value in Oracle

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
DUAL?!?!!? That works, and is magic, but, again: ?!?!? I'll have to research this. I am sure there is a good reason for it being called DUAL. If not, and if this is truly arbitrary, then I am disappointed that the folks at Oracle didn't come up with some more colorful name, like

RE: new next primary key value in Oracle

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
Aaron, This is another good solution. Thanks, Matthieu -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, November 03, 2005 2:08 PM To: CF-Talk Subject: Re: new next primary key value in Oracle You could just run the insert on one table, then select out

RE: SQL join a table to a set of values not in a table.

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
Ian, Shouldn't the same technique work, where you do separate outer joins against each of those other tables? I only know Oracle SQL, so I never know how it would work in a query of queries (if outer joins are even an option), but I would do this in pseudocode: qTable1 SELECT Letters FROM

RE: new next primary key value in Oracle

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
Yet another good answer. Thanks, gang, for sending these in. At least one will do the trick. Matthieu Matt Small wrote: One idea, if it's possible - pass all of this information at once into a stored procedure, which would know the newly created row id know what number to use.

RE: new next primary key value in Oracle

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
I LOVE DUAL! Thanks! I'll be doing more research on this. Matthieu Deanna Schneider wrote: You're new to dual? Dual is just a wonderful little widget that acts like a one row table, but the column is arbitrary. You can do all sorts of stuff with it: select sysdate from dual; select 1 + 1

RE: SQL join a table to a set of values not in a table.

2005-11-03 Thread Cornillon, Matthieu \(Consultant\)
Ian Skinner wrote: We are also using Oracle here as well. Your idea would probably work, except Queries of Queries only supports inner joins. A limitation I have butted heads with on several occasions. Bummer. I can't think of a query-returning option, then. I would pull all the Oracle data

RE: Caching, caching what is doing all this caching?!

2005-11-02 Thread Cornillon, Matthieu \(Consultant\)
Yesterday, my workstation started experiencing some maddening kind of intermittent caching. Ian, I had a similarly maddening experience just as I switched (simultaneously) from ColdFusion Server 5 to MX7 and from Dreamweaver Ultradev 4 to Dreamweaver 8. Don't know what caused it, but

RE: JavaScript in Mouseover

2005-11-02 Thread Cornillon, Matthieu \(Consultant\)
I get this JavaScript error on the mouseover below: Expected ')' tr onMouseover=HighLightTR('##f0f0e1'); ondblclick=self.location=('getinventory4.cfm?id=#id#lname=#lname#fnam e=#fname#serialnumber=#serialnumber#'); When I just use the ?id=#id# after getinventory4.cfm I do not get an

client variables and migration of site

2005-11-01 Thread Cornillon, Matthieu \(Consultant\)
The site that I maintain uses a client variable store that sits in Oracle. At some point in the near future, the entire site (web and database servers) is being migrated to new equipment. The people handling the migration will shut off all web connections to the old site, take a snapshot of all

ColdFusion and WebLogic

2005-11-01 Thread Cornillon, Matthieu \(Consultant\)
Hi, everyone. A client of mine is telling me that their hardware providers may have force them to switch their site (written in ColdFusion) to WebLogic. To be honest, I hardly know what that means. I have seen that ColdFusion can be made to run in WebLogic, but the client may not have that

RE: How do I rewrite this as a join query?

2004-11-17 Thread Cornillon, Matthieu (Consultant)
I'm using MySQL (4.0) version, which doesn't support subqueries, so I need to rewrite this as a join query...how would I do that? Well, here's a clumsy idea that gets the job done. Do an outer join (don't know the exact syntax for MySQL) that gets you two columns in each row: email address

Oracle CFQUERYPARAM error

2004-11-16 Thread Cornillon, Matthieu (Consultant)
All, Hi, there. Have a bit of a tricky one. Before starting, let me say that I know the real solution is to use CLOBs, but I need to make this work in the meantime. I have to put huge amounts of text into tables whose columns are already defined and whose setup may not be changed. Luckily, I

strange behavior: session vars, cfid, cftoken, cookies

2004-10-26 Thread Cornillon, Matthieu (Consultant)
Hi. I have a really weird problem here that is hard to summarize, so I am just going to ask anyone if they've had anything even vaguely like this, since that might help me know where to look. I have a sign-in and registration system on my intranet site. Here is the system: a user registers,

RE: strange behavior: session vars, cfid, cftoken, cookies

2004-10-26 Thread Cornillon, Matthieu (Consultant)
From Michael: What version of CF are you running. I am running CF5.0. From Bryan: If you're running clustered servers, there could be some session confusion between servers. Assuming this is the case, is there anything I can do about it? Thanks! Matthieu

RE: strange behavior: session vars, cfid, cftoken, cookies

2004-10-26 Thread Cornillon, Matthieu (Consultant)
Bryan, Thanks for this information. I have more or less stopped using session variables in general (can't stand all that pesky locking business), but that has only happened since I released the sign-in/registration system. I agree about the security hole inherent in the cookie system. I am

RE: Field Naming

2004-10-19 Thread Cornillon, Matthieu (Consultant)
My two cents: I (sinfully) use the plurals in the table names. Can be confusing, yes, but if you are consistent one way or the other, you should be able to remember what you are doing. My rules: 1) Each table name has a related table abbreviation (e.g., CLIENTS has CLI, PHONENUMBERS has PHONE).

RE: Field Naming

2004-10-19 Thread Cornillon, Matthieu (Consultant)
The are so many options on which styles to follow, the approach I recommend is to pick a something, document it and follow your document. This is indeed the most important thing. The system I just laid out (that I use) in another e-mail is only useful to me insofar as I am consistent in

RE: page creation times

2004-10-18 Thread Cornillon, Matthieu (Consultant)
Anders, DISCLAIMER: All of the rambling you are about to read is based on my own experience designing user interfaces, and none of it is based on industry standards.In other words, get your grains of salt ready. I think that it depends what page is loading, and how it all fits into the user

RE: page creation times

2004-10-18 Thread Cornillon, Matthieu (Consultant)
The theory in that is a very very good answer... finally a pretty balanced point... altho you may want to cache that 43 second query somehow so that it isn't that long the next time round :) Indeed.I was mainly using such a big number for contrast.In general, a 43-second process had darn well

RE: SQL Question...

2004-10-12 Thread Cornillon, Matthieu (Consultant)
Can anybody lend a hand and help me out on this one?All it does is return 1 row no matter how many rows are in the sizeLine table.. Blaine, I'm not exactly sure why this is happening, but here are some ideas of what to check: 1) Forgive me for suggesting the obvious, but since it's

RE: SQL Query Help Please.

2004-10-12 Thread Cornillon, Matthieu (Consultant)
2.) Can someone please suggest a good book on SQL syntax that will clear thing up for me. Other beginner resources: 1) http://www.sqlcourse.com/ http://www.sqlcourse.com/ 2) http://sqlcourse2.com/ http://sqlcourse2.com/ 3) http://www.freeprogrammingresources.com/sql.html

RE: SQL Question...

2004-10-12 Thread Cornillon, Matthieu (Consultant)
Wow, do I ever feel stupid.It was the output stage that I had my problem with.It's fixed, that join query runs fine. I'm glad it worked out.No need to feel stupid: getting a second (third, fourth,...,nth) pair of eyes to look at the issue freshly is one of the great things about this list.

RE: grouping by...

2004-10-11 Thread Cornillon, Matthieu (Consultant)
If you want to do this in SQL, you can use the DECODE function.Let's say you have a table called TASKS, and you want to prioritize TASK_Name by TASK_Priority, High to Low: SELECT TASK_Name, DECODE(TASK_Priority,'High',1,'Normal',2,'Low',3) AS PriorityOrder FROM TASKS ORDER BY PriorityOrder

RE: currentrow is undefined?

2004-10-11 Thread Cornillon, Matthieu (Consultant)
Phillip, In the CFQUERY tag, you define the name of the query as display.So the later CFIF statement should read CFIF Display.CurrentRow... instead.When you took out the error_table part, CF looked through the available variable scopes and found the data somewhere, but it may have been looking

RE: looping query

2004-10-05 Thread Cornillon, Matthieu (Consultant)
Adam, I think that it is just bad coding.I have seen a fair amount of confusion on the point of getting values out of a query (e.g., people often seem refer to MyQuery.ColName without looping, unintentionally getting nothing but the first value).Also, I think people often don't know array

RE: Headache with # in table colors

2004-10-05 Thread Cornillon, Matthieu (Consultant)
Is there an easy way to go about handling table rows/columns colors as I am doing my page design/layout? Donna, I'm not sure if this is what you're going for, but here's a stab: between CFOUTPUT tags, use ## instead of #. HTH, Matthieu [Todays Threads] [This Message] [Subscription]

form variables without forms?

2004-10-05 Thread Cornillon, Matthieu (Consultant)
Hello, all. I have to submit some values to a form action page.I have no choice on the far end: it is expecting POSTed form variables.On my end, though, this is kind of a pain, because I need to do an intermediate, non-user step before the submission.So my situation is: UserForm - page on which

RE: form variables without forms?

2004-10-05 Thread Cornillon, Matthieu (Consultant)
have you tried cfhttp? Lawrence, I have never used CFHTTP before, but I don't think it will do it.I have just tried setting it up, and it doesn't go anywhere.In other words, it seems that the data is posting to the other server, but the client never goes there.I want this to be exactly the

RE: form variables without forms?

2004-10-05 Thread Cornillon, Matthieu (Consultant)
Chris, Thanks for this message.Unfortunately, I am getting a connection error.I am guessing that something about the set-up I am using doesn't allow this approach?I am going from one company to another, across at least one firewall.I probably have another solution, but in the interest of

RE: form variables without forms?

2004-10-05 Thread Cornillon, Matthieu (Consultant)
is your network behind a firewall? do u find it takes forever for it to process? you may need to add your proxy's address, port, username and password... may not be allowing you to post. Yes, it is.I have been playing with this with no luck.This should be my proxy address, port, username,

RE: Order in multi-column select box

2004-09-29 Thread Cornillon, Matthieu (Consultant)
This is a long shot, but if you are pulling your from Oracle or another DB that allows the LPAD/RPAD functions, you could pad it on the query instead of having to loop through it.In fact, I often, when putting values like this together in select statements, do all of the concatenation in the

RE: type ahead select lists

2004-09-28 Thread Cornillon, Matthieu (Consultant)
Anybody know of a script that replicates type-ahead select lists (like in Gmail or offline VB applications)? George, I built this using _javascript_.It's not too pretty, but it works just fine. The idea is that a global variable is the buffer in the list, to which keystrokes are added.The

RE: Select Box / LIKE operator

2004-09-28 Thread Cornillon, Matthieu (Consultant)
If the end user just enters e in the search box, I am not so sure that I want every name that contains an 'e' to be returned Or do I??? What is the consensus on how to make something like this work best? I personally like the anywhere in the string approach, but I have found that

RE: ;amp in my URL's?

2004-09-21 Thread Cornillon, Matthieu (Consultant)
Im trapping a few errors per day which means probably 1-1000 users (or more) is experiencing this problem, and not sure what could be causing it. AAARGH!That foul beast dares rear its head again!?!!(read with pirate voice and one eye squinted shut) I had/have this exact same problem.The site

RE: OT:Javascript Problem

2004-09-20 Thread Cornillon, Matthieu (Consultant)
Vishnu, I think that having the field names all the same will be a mistake, as it will complicate the issue on your form page, if not outright causing errors. In any case, you do not need to have the field names be exactly the same as your database field names.I have done this sort of form

RE: Using a value from one insert for another insert

2004-09-16 Thread Cornillon, Matthieu (Consultant)
I don't know the proper way to do this, but I can tell you the hideously unattractive and effective three-query way that I do it.I use various items to create something that I know will be unique.For example, I concatenate user ID and current time.I put that in a local variable.I run the insert

RE: SQL, count

2004-09-16 Thread Cornillon, Matthieu (Consultant)
What i basically need to do is get a list of ID2 and a count of the people ID1 invited. Andy, How about a self join?(The following assumes that the name of your table is NAMES). query=qNames SELECT INVITERS.ID2 AS InviterID, INVITERS.NAME AS InviterName, INVITEES.ID2 AS InviteeID,

RE: OT- SQL PADDING QUESTION

2004-09-15 Thread Cornillon, Matthieu (Consultant)
SELECT MyNumber, TO_CHAR(MyNumber,'000') FROM NUMBERS returns: 1, 001 552,552 1234567,1234567 HTH, Matthieu -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 11:33 AM To: CF-Talk Subject: OT- SQL PADDING QUESTION I

OT: pulling header response variables

2004-09-13 Thread Cornillon, Matthieu (Consultant)
All, I am being forced to develop a small module application on my site outside of my normal environment, meaning that I cannot use ColdFusion.(shudder) I am interacting with a plug-in on this other server that includes certain information that I need in the header variables.If I use

RE: date difference (DateDiff) question?

2004-09-09 Thread Cornillon, Matthieu (Consultant)
cfset timeCallPlacedOnHold = queryTmp.HoldDateTime cfset timeOnHoldReleased = queryTmp.ReleasedDateTime For some reason the dates retuned are in this format: Ex: 2004-09-08 12:28:56.0 I can't understand why it adds the .0 after the time when the value stored in the database is 2004-09-08

RE: Comparing two records within the query

2004-09-09 Thread Cornillon, Matthieu (Consultant)
Another option is to do a self-join. This works, though I am not getting all rows returned and I haven't quite figured why yet.I hate to rely on the titles being exactly the same.I have data where one title contains the words DVD while the VHS version doesn't. Unfortunately, you are

RE: DHTML Drag and Drop pt.2

2004-09-08 Thread Cornillon, Matthieu (Consultant)
Still struggling with this drag and drop issue. Guy, I would like to help, but as Micha said, we'll need to see a little more of what you are talking about.Can you post it? Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations

RE: Comparing two records within the query

2004-09-08 Thread Cornillon, Matthieu (Consultant)
Another option is to do a self-join.I'll make some assumptions here that may not be true, but which you can modify to fit the truth.Key among those is that you have column called VID_MediaFormat holding either DVD or VHS. (I know you don't have this, but you seem to have some way of determining

RE: DHTML Drag and Drop pt.2

2004-09-08 Thread Cornillon, Matthieu (Consultant)
Guy, One tip on debugging _javascript_: I am sure there is some smart way to do it. I don't know this smart way.I find the errors when they come up in IE. Since the line numbers in the _javascript_ error that comes up (you can get it by double-clicking the little yellow icon in the lower,

RE: cfloop / cfquery and displaying results

2004-09-07 Thread Cornillon, Matthieu (Consultant)
Keith, Perhaps I am not understanding correctly, but it sounds like a query within which you group the results is the way to go. You can handle the grouping in a couple of different ways.I would start by reading the help on the CFOUTPUT tag, looking at the group parameter. HTH, Matthieu

RE: More drag and drop

2004-09-07 Thread Cornillon, Matthieu (Consultant)
However, I can't seem to get it to work with text unless I select the text not 100% surebut the text could be in a div and the div could have somehting along the lines of John, I'm not sure about the DIV tag that Bryan suggested.It may indeed work. The other way to do it is

RE: cfoutput -- group and maxrows problem

2004-09-07 Thread Cornillon, Matthieu (Consultant)
cfoutput query=research group=publication_title maxrows=10 #publication_title# cfoutput #author_name# /cfoutput /cfoutput But the maxrows attribute goes by the query record count, rather than the count of unique publication_titles. So instead of seeing 10 records per page, I may get 6 or 9 or

RE: DHTML Drag and Drop to reorder record set

2004-09-03 Thread Cornillon, Matthieu (Consultant)
I'm not a DHTML guy by any means. Could someone point me in the right direction to figuring out how to use DHTML to take a record from within a record set, drag it to a higher or lower position, and have it change its position within the record set? Guy, I recently set up a drag-and-drop

RE: DHTML Drag and Drop to reorder record set

2004-09-03 Thread Cornillon, Matthieu (Consultant)
Guy, Thanks for the kind words.The truth is that I learned by reading some tutorial somewhere myself.If I could have remembered where it was, I would have just sent you the link, because it was quite good. That said, my application of what I learned was more specifically geared toward

RE: Capture cflocations/redirects

2004-09-03 Thread Cornillon, Matthieu (Consultant)
I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where? Ian, I don't know if this applies, but when I have confusing and unplanned page-to-page routing, I add a dummy URL

CFMAIL and mass mailings: problem?

2004-09-02 Thread Cornillon, Matthieu (Consultant)
Hi.I want to set up a page to cycle through a list of about 25,000 users and send a personalized e-mail to each of them.I have no need for fancy subscription, opt-out, or other such management features.Also, I am only doing this two or three of times.As such, my plan was to loop over a query,

RE: currency symbol converter

2004-09-02 Thread Cornillon, Matthieu (Consultant)
Joe, Have you looked at LSCurrencyFormat and LSEuroCurrencyFormat?I haven't used them, but I think they might handle your needs. HTH, Matthieu -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 1:35 PM To: CF-Talk Subject: currency

RE: Looping Question

2004-09-02 Thread Cornillon, Matthieu (Consultant)
Mark, The problem is that your loop index (memberID) is changing, but nothing about the query is.You are repeatedly referring to getRecords.memberID, which, without a CFOUTPUT or CFLOOP tag, will always just give you the first record.In fact, I am surprised that you are doing anything other

RE: Looping Question

2004-09-02 Thread Cornillon, Matthieu (Consultant)
. In the getRecords query, I can filter by using WHERE directoryPhone IS NOT NULL. But is there a way to filter out records that have an empty value ()? Mark _ From: Cornillon, Matthieu (Consultant) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 1:58 PM To: CF-Talk Subject: RE: Looping

RE: CFMAIL and mass mailings: problem?

2004-09-02 Thread Cornillon, Matthieu (Consultant)
The big thing you need to look out for is invalid email addresses and such because that will kill the cfmail loop and thus kill all of the emails going out. John, Does invalid e-mail addresses mean e-mail addresses that simply are not e-mail addresses, or e-mail addresses that are valid

SOLVED: CFMAIL and mass mailings: problem?

2004-09-02 Thread Cornillon, Matthieu (Consultant)
All, I appreciate your answers on this thread.After doing some testing, it looks like I will be able to use CFMAIL with the query attribute set to cycle through messages.To avoid driving the mail server admins to kill me, I will set a scheduler to leak these out in small batches. The regular

RE: CFQueryParam and Error Handling

2003-01-08 Thread Cornillon, Matthieu
Well, it depends on what you want the flow to be, but here's the start. CFTRY [Query or other potentially problematic code] CFCATCH type=Database [Exception processing code] /CFCATCH /CFTRY [After running CFCATCH block, code resumes processing here.] If you just want a friendly

RE: CFServer Problem

2003-01-08 Thread Cornillon, Matthieu
This is going to sound really stupid, but it's a solution to a similar problem in my installation. Worth a try: When you attempt to access the datasources, try to log in. It will give you the error message. Then try again immediately. In my installation, for whatever reason, this works. It's

RE: Using Excel to Calculate a Result...

2003-01-08 Thread Cornillon, Matthieu
I have to say that my gut agrees with Samuel's gut. Or at least with Samuel's e-mail. I wince at the idea of going through Excel, despite the complexity of the formula conversion. I also agree with Samuel's suggestion of pushing back on the client. Like you said, this wasn't in the original

custom tag: pair of list boxes with transferring

2003-01-08 Thread Cornillon, Matthieu
Hi. I think there is a custom tag out there that allows me to do what I want, but I don't know what words to use to search for it. Here is what it should do: create a pair of listboxes, with a pair of buttons in between. The idea is to transfer items from one listbox to the other. This

RE: Query Output

2003-01-06 Thread Cornillon, Matthieu
I may have made some little mistakes, but this should do it. If you want to do fancier formatting (e.g., tables or bulleted lists), you should be able to use the same code with a little modification. Hope this helps, Matthieu CFSET Variables.LastMonth=0 CFOUTPUT query=qYear CFSET

RE: IsDefined do this...

2002-11-19 Thread Cornillon, Matthieu
Hi, Flashguy. Would you post the exact cfif statement (non-nested version) you are using that is causing a problem and let us know what error it's showing? You could also use this: cfif isdefined(qgetdir.strOmit) AND FindNoCase(documents,qgetdir.strOmit) The documents string should be wrapped

RE: IsDefined do this...

2002-11-19 Thread Cornillon, Matthieu
Stephen, I looked up the Booleans (Was: Studio MX) thread that you mentioned. This is a good point. I should use explicit comparisons unless the variable is definitely boolean. Sorry about my single-quote/double-quote note. Your single quotes work fine here. Also, the ListFindNoCase is a

  1   2   3   >