You should be able to do all these things using sub-queries. To do a "distinct" on the email addresses, I would UNION all three queries, with just the...
cf-talk@...
Jun 1, 2004 7:38 am
9355
I am just now taking a stab at using MySQL, and hit a fundamental snag, i.e., creating the database. MySQL indicates the following statement will do the job ...
cf-talk@...
Jun 1, 2004 9:04 am
9356
Just like with any other DBMS, you'll have to create a database through the database's native interface, not via CF. With MySQL, that's the `mysql` command...
cf-talk@...
Jun 1, 2004 9:18 am
9357
... Though you can play tricks with mod_proxy if you are on Apache. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email:...
cf-talk@...
Jun 1, 2004 10:26 am
9358
The difference between a tinyint (1 byte?) and a char(35) (35 bytes) on a table that will never contain more than 255 records is pretty minimal. 8k, maybe. Is...
cf-talk@...
Jun 1, 2004 11:48 am
9359
Not exactly true that you have to use the "native interface" for all rdbms's. In MsSQL (and other rdbms's) if you have the proper permissions you can create...
cf-talk@...
Jun 1, 2004 12:41 pm
9360
I'm a liar, I admit it. You can create new databases through CF DSNs with MySQL as well. You can issue a CREATE DATABASE <name> from any connection that was...
cf-talk@...
Jun 1, 2004 12:54 pm
9361
Any ideas on this? Thanks! ... Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia...
cf-talk@...
Jun 1, 2004 1:30 pm
9362
What DB? Normally, datediff returns an integer that you can happily SUM(). ... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase...
cf-talk@...
Jun 1, 2004 1:48 pm
9363
... Access. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support...
cf-talk@...
Jun 1, 2004 2:16 pm
9364
Java Primitive Arrays are NOT Fully Compatible with CFMX 6.1. CFMX 6.1 Arrays = Vectors != Java Primitive Arrays. Method like arrayLen(Java Primitive Arrays)...
cf-talk@...
Jun 1, 2004 2:20 pm
9365
And SUM is not working? AFAIK the result of datediff should be an int (Not that I use access a lot). You can always calculate the sum in CF. <cfset sum = 0> ...
cf-talk@...
Jun 1, 2004 2:25 pm
9366
Joe, You would still not be able to return a Vector from within a CFX with setVariable. That would not be the approach to use with a CFX. rish ... From: Joe...
cf-talk@...
Jun 1, 2004 2:35 pm
9367
... This is kind of an aside, but it's a pet peeve of mine. If you can, use an ArrayList not a Vector. CF's data type may require you to use a vector...
cf-talk@...
Jun 1, 2004 2:36 pm
9368
... I get the following error w hen I insert your example: The value of the attribute query, which is currently "q", is invalid. ============================= ...
cf-talk@...
Jun 1, 2004 2:41 pm
9369
Q was just an example (as I didn't know the name of your query). Use the name of your query (esitest)!!! Are you sure adding SUM(DATEDIFF('n', confhrsfrom,...
cf-talk@...
Jun 1, 2004 2:52 pm
9370
Hello, I am looking for a book about documentation writing (computer application documentation). I looked in my local bookstore but didn't find anything. I ...
cf-talk@...
Jun 1, 2004 3:06 pm
9371
Hello, First of all, I haven't done much CF work since CF 5.0. I DLed the new MX demo version. I have a simple form page. <cfparam name="url.holiday"...
cf-talk@...
Jun 1, 2004 3:13 pm
9372
Hi all, The cffile append function append a document at the end..how could I insert a line at the beginning instead? Thanks Pat ...
cf-talk@...
Jun 1, 2004 3:14 pm
9373
Prepending to a file involves reading and rewriting the file. CFFILE read, and CFFILE write with #newstring# newline #existing file# But if it's a one time...
cf-talk@...
Jun 1, 2004 3:17 pm
9374
"_date" is a reserved name in ColdFusion It allows for automatic form validation. See the section on server-side validation in the documentation there is a...
cf-talk@...
Jun 1, 2004 3:22 pm
9375
... Good stuff. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben...
cf-talk@...
Jun 1, 2004 3:25 pm
9376
... When you name a form field with "_date", CF uses that field as a validation rule. There are seven built-in validation rules in CF. So, if you have a form...
cf-talk@...
Jun 1, 2004 3:25 pm
9377
<cfset crlf = chr(13) & chr(10)> <cffile action="READ" file="#variables.file#" variable="out"> <cfset out = "my line here" & crlf & variables.out> <cffile...
cf-talk@...
Jun 1, 2004 3:27 pm
9378
Because you have a form field with a name ending on "_date". This will give an error in cf4 or cf5 too. Because of CF's built-in server side validation, form...
cf-talk@...
Jun 1, 2004 3:36 pm
9379
Thanks a lot, I tought of that but I was sonwdering if there was something I missed in the append attributes to facilitate the manipulation... Thank you Pat ...
cf-talk@...
Jun 1, 2004 3:36 pm
9380
try #createodbcdate(dateformat(yourstringvalue,'mm/dd/yyyy'))# ... From: JT To: CF-Talk Sent: Monday, May 31, 2004 4:32 PM Subject: variable as a string Hi...
cf-talk@...
Jun 1, 2004 3:56 pm
9381
On Friday I started getting this error: Network problem, session aborted due to internal error in remote procedure call, connection closed. Our database is a...
cf-talk@...
Jun 1, 2004 3:57 pm
9382
... What kind of docs: manuals, requirement docs, inline documentation? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the...
cf-talk@...
Jun 1, 2004 3:59 pm
9383
A few weird things regarding this error: 1. The error happens on a template that is included on every page view and has been in use for over a year without...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
