hey guys, i have a table named Stuff.this table has the fields stuff_id, stuff_title, first_person_id, second_person_id, and third_person_id.
The those last 3 fields refer to a table called persons, and contains the person_id.The table PERSONS contain the fields person_id, first_name, and
SELECT stuff.*, person1.*, person2.*, person3.*
FROM(
(
stuff LEFT JOIN persons AS person1 ON stuff.first_person_id =
persons.person_id
) LEFT JOIN persons AS person2 ON stuff.second_person_id = persons.person_id
) LEFT JOIN persons AS person3 ON stuff.third_person_id = persons.person_id)
What if I wanted to add a WHERE clause?
- Original Message -
From: Matthew Walker
To: CF-Talk
Sent: Thursday, May 20, 2004 1:28 AM
Subject: RE: SQL HELP!
SELECT stuff.*, person1.*, person2.*, person3.*
FROM(
(
stuff LEFT JOIN persons AS person1 ON stuff.first_person_id =
Thanks for your assistance but I'm still having the problem.I tried cfif IsDefined(FAQList[i].Company) as you stated below... both with quotes and without.
I also tried cfif StructKeyExistsbut still no luck.
the only items I'm trying to retrieve are the Analyst' which there are only 4 at the
Just add it after the FROM clause. Also keep in mind that if you use
all * in the SELECT clause, you won't be able to access all names in CF.
You have to use aliasses for the names
SELECT stuff.*,
person1.first_name AS first_name1, person1.last_name AS last_name1,
person2.first_name AS
hey peter may i contact you off the list quick?
- Original Message -
From: Pascal Peters
To: CF-Talk
Sent: Thursday, May 20, 2004 4:22 AM
Subject: RE: SQL HELP!
Just add it after the FROM clause. Also keep in mind that if you use
all * in the SELECT clause, you won't be able to access
From: brobborb
Now I want to return all the rows in the STUFF table, but to
replace the last 3 fields with names in the PERSONS table.
THe fields first_person_id, second_person_id, and
third_person_id links to the person_id field in the table
PERSONS.
A good book to have on your desk
Hi All,
One of our cfmx app servers, we turned off cffile and cfdirectory because of security reasons. But, I need to be able to read filesand del/update files
on the box. Anyone have a different solution. BTW, wscript is turned off also:(
This is a W2K server, can WMI work or something
Why not write a Java object, and call CFOBJECT on it?
public class MyCFFile {
public MyCFFile(){}
public String readTXT(String path){
StringBuffer buff=new StringBuffer();
java.io.BufferedReader r=new java.io.BufferedReader(new
java.io.InputStreamReader(new java.io.FileInputStream(new
Check out the new TechNote at:
http://www.macromedia.com/support/coldfusion/ts/documents/hotfix_verity_linu
x.htm
http://www.macromedia.com/support/coldfusion/ts/documents/hotfix_verity_lin
ux.htm
Macromedia has created a hot fix for Verity to support additional versions
of Linux.
[Todays
no...:(Do you have any other ideas.? This web server is admin by other sub-contractor...:( We don't have control over it, we just deal with its
limitations
TIA,
Patrick Whittingham
United Space Alliance
AES - Data Warehouse
-Original Message-
From: Katz, Dov B (IT)
I need to use CFLDAP to match a form submitted username and password to Active Directory not knowing what OU's the user may be in. I have to use a special account to bind to AD with so the username and password attributes are already utilized. I can successfully pull back a users information using
Hmm...
If my var1 is equal to...
cfset var1 = 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64,
On Thursday 20 May 2004 14:06 pm, Whittingham, P wrote:
no...:(Do you have any other ideas.?
Buy a Big Stick :-)
I assume cfexecute is turned off too ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business
On Wednesday 19 May 2004 20:32 pm, Burns, John D wrote:
Not a bad suggestion.Is there any way (that you know of) to add a
filter to only grab files larger than X?
GNU find.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Any ideas would be appreciated,
We're sharing product tables info with partners via a Web service.Our partners will be using
this product information to populate their database and display data on their Web site.
Because we warehouse and drop ship the partner's customer order, we want to capture
I'm getting into using web services more (from Flash and CF) and I'm
curious if there is an amount of data that is considered reliable and
if there is a set amount that is considered too much for web services
to handle.Just as an off the wall example, let's say I have a server
with information in
Hi,
Can anyone provide a rehash of last nights meeting?I got stuck at work and I
would love to know what was talked about, of course if this is allowed and not
against any non-discloser agreement.
Thanks
Mario
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
here is your answer:
cfscript
var2 = ;
n = listlen(var1);
for (i=1;i LTE n;i=i+1) {
curr = listgetat(var1,i);
if (i LT n) {
next = listgetat(var1,i + 1);
} else {
next = ;
}
if (i GT 1) {
last = listgetat(var1,i - 1);
} else {
last = ;
}
if (curr + 1 NEQ next) {
I would use a case construct.Or even use the MOD function with an array to
load the values or count of values into an array:
// NOTE:THIS IS OFF OF THE TOP OF A VERY EMPTY HEAD SO FORGIVE SYNTAX ERRORS
RangeCount = 6;//Create ranges of 1-6, 7-12,
etc
NumRanges = 6;// Last range will be 36 and
Mario,
On 5/20/2004 at 09:59, you wrote:
CM Can anyone provide a rehash of last nights meeting?I got stuck
CM at work and I would love to know what was talked about, of course
CM if this is allowed and not against any non-discloser agreement.
I didn't sign an NDA ;)
If NYCFUG was in on the MM
OOPS
here is is fixed
cfscript
var2 = ;
n = listlen(var1);
for (i=1;i LTE n;i=i+1) {
curr = listgetat(var1,i);
if (i LT n) {
next = listgetat(var1,i + 1);
} else {
next = ;
}
if (i GT 1) {
last = listgetat(var1,i - 1);
} else {
last = ;
}
if (curr - 1 NEQ last) {
Hi,
I'm writing an application that allows our client support reps to import
customer files of a predefined format into our database.The CSR
uploads (form via CFFILE) the tab-delimited text file to the server, and
then I loop through the file contents and insert the data into the
database.So
Where do I place this?
On Thu, 20 May 2004 10:19:11 -0400, Ian Sheridan wrote:
OOPS
here is is fixed
cfscript
var2 = ;
n = listlen(var1);
for (i=1;i LTE n;i=i+1) {
curr = listgetat(var1,i);
if (i LT n) {
next = listgetat(var1,i + 1);
} else {
next = ;
}
if (i GT 1) {
last
I would use a case construct.Or even use the MOD function with an array to
load the values or count of values into an array:
// NOTE:THIS IS OFF OF THE TOP OF A VERY EMPTY HEAD SO FORGIVE SYNTAX ERRORS
RangeCount = 6;//Create ranges of 1-6, 7-12,
etc
NumRanges = 6;// Last range will be 36 and
heh ok sorry here is the full script:
cfscript
var1 = 1,2,3,4,5,6,10,11,12,13,14,20,25,30,31,32,33,50;
var2 = ;
n = listlen(var1);
for (i=1;i LTE n;i=i+1) {
curr = listgetat(var1,i);
if (i LT n) {
next = listgetat(var1,i + 1);
} else {
next = ;
}
if (i GT 1) {
last =
On Thursday 20 May 2004 15:36 pm, Pete Ruckelshaus - CFList wrote:
I'm trying to figure out what the most elegant way is to split these
big files into smaller ones, and do it without killing performance.Has
anyone done this?
You could cfexecute something like split, or use Java file classes to
[Non-cf suggestions]
Not sure what database you are using but 77k record parsing/insert sounds like a prime candidate for Stored Procedure processing - take it to the database and let the database server do its magic. CF is obviously not built for / handling that kind of processing.
Hmmm if
On Thursday 20 May 2004 15:19 pm, Ubqtous wrote:
I didn't sign an NDA ;)
...
Some teaser demos of BlackStone, including very nifty CFFORM FLASH
integration. Also CFDOCUMENT TYPE=PDF (or something to that effect).
Does this mean we can stop dropping vague hints the next time anyone asks
about
Hi folks..
lately having an issue where CFMX 6.1 is doubling
up on scheduled tasks AND emails !!
If I look in the email logs,I see entries like scheduler-4 scheduler-5
for an email that is getting sent twice. ( should only be once )
This is becoming an annoyance over the last two days.
Any
Is there some special requirement to executing a PL/SQL block of code in CFMX?I had a block that ran in CF 5 fine.It looked like this:
cfquery name=finalizecycle datasource=#request.datasource#
declare
jobno BINARY_INTEGER;
BEGIN
Original Message:
From: Thomas Chiverton
Does this mean we can stop dropping vague hints the next time anyone asks
about generating PDF from CFML ? :-)
Sure, if you don't mind telling them that it will be sometime in 2005 before they can actually use it. :)
Scott
Are you using MSSQL? If so, check out BULK INSERT.
http://doc.ddart.net/mssql/sql2000/html/tsqlref/ts_ba-bz_4fec.htm
-Original Message-
From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 10:37 AM
To: CF-Talk
Subject: Text file problem
Hi,
I'm writing
The cfdocument tag and its ability to produce PDF from HTML in the body
of the tag is public knowledge and has been for sometime. Although,
Macromedia hasn't committed in anyway to this tag, so it might not be
there at all. Of course, I highly doubt they would bother showing it if
they didn't
The oracle jdbc driver that coldfusion mx uses does not allow multiple
statments in a single query.Bassically if you need a semi-colon then it
won't work.The only real alternative (aside from acquiring a suitable
third party driver) is to encapsulate the functionality in functions and
stored
BEEEautiful. Thanks Tyler.
-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 10:15 AM
To: CF-Talk
Subject: RE: executing a PL/SQL Block
The oracle jdbc driver that coldfusion mx uses does not allow multiple
statments in a single
Does Crystal Reports play nice with Cold Fusion these days??
If so, exactly what components/versions of Crystal are required to be able to generate reports in PDF file format?
Also, what report generation products do you use and like -- instead of Crystal Reports -- to generate paginated reports
We're on SQL Server 2000, app servers are MX 6.1 on Win2K3.
I saw the BULK INSERT command, the problem is that there isn't a 1:1
relationship between the columns in the database and the data in that
tab-delimited text file (i.e. there are some system-specific columns in
our database that don't
I haven't had the best luck with Crystal and CFMX.I had a COM object
wrapper that worked decent with CF5, but I could never get it to work
reliably with CFMX.I've since then resorted to using a simple ASP.net
script that I cfhttp from CFMX passing all the pertinent parameters.
The ASP.net script
ok, thank you.The description is useful - bet it's nice to have docs.
I appreciate all the help.
Without actually being able to test it, that appears to me that it
should work just fine. Dual is...hard to describe...so I'll leave it
to the Oracle documentation to explain what it is, heh (see
I'm assuming that 1) this is a Win server and 2) you have access to it.
Instead of opening the file directly, try setting up a file DSN.Then,
you can let the system handle access of it and pull in records in groups.
HTH.
--Ben Doom
Pete Ruckelshaus - CFList wrote:
Hi,
I'm writing an
I don't know what version of Oracle you're using, but all of the documentation is available online at OTN. Here's the link for all of the Oracle9i documentation: http://otn.oracle.com/documentation/oracle9i.html http://otn.oracle.com/documentation/oracle9i.html . If you have need for other
At 11:13 AM 5/20/2004, you wrote:
The cfdocument tag and its ability to produce PDF from HTML in the body
of the tag is public knowledge and has been for sometime. Although,
Macromedia hasn't committed in anyway to this tag, so it might not be
there at all. Of course, I highly doubt they would
Hello
I've been looking at
http://www.w3.org/TR/CSS21/selector.html#pseudo-elements and the
pseudo-class 'focus'
When I've got
style type=text/css
.input { background: #CC; color: #00; }
.input:focus { background: #FF; color: #FF; }
/style
input type=text size=20
What is this all about now?PDF's from CFML?Easily? Me likee, want to
hear more
Ray
At 10:55 AM 5/20/2004, you wrote:
On Thursday 20 May 2004 15:19 pm, Ubqtous wrote:
I didn't sign an NDA ;)
...
Some teaser demos of BlackStone, including very nifty CFFORM FLASH
integration. Also
Be sure to drop by one of the stop on my upcoming user group tour (stops
listed at http:// http://www.forta.com/ www.forta.com/, right column) to
see examples of this in action ...
Ooops, did I say that publicly!?!?!? Bad bad!
evil grin
--- Ben
_
From: Ray Champagne [mailto:[EMAIL
Ben,
On 5/20/2004 at 12:06, you wrote:
BF Be sure to drop by one of the stop on my upcoming user group tour
BF (stops listed at http:// http://www.forta.com/ www.forta.com/,
BF right column) to see examples of this in action ...
You'll be happy to know that your tour was heavily advertised
Since Flash doesn't understand query objects, I often find myself
returning an array of structures (using the QueryToArrayOfStructures()
function that I found on cflib)... it works well with Flash but not with
other platforms... like VB doesn't know what a structure is.
What are my
Why would I get this SQL error : Error converting data type varchar to numeric on one filed and not another when I do a submit from a form even though they are setup the same. Both are numeric in the SQL table.
I'm entering them this way:
CFIF getponumber.recordcount EQ 0 OR
I didn't sign an NDA ;)
If NYCFUG was in on the MM Breeze presentation, it was basically a
high level overview of MM's plans for the rest of the year and into
next.
Some teaser demos of BlackStone, including very nifty CFFORM FLASH
integration. Also CFDOCUMENT TYPE=PDF (or something to that
Very happy about that.
I was even happier when I heard that the DW chat started with an opener,
asking who you'd want to be stuck ondesert island with, and I came in 1st
(ahead of the DW team, ouch!). :-)
--- Ben
_
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004
Is that ASP script available for sharing?We use a lot of Crystal around here and our solution is sub-par to say the least and I just don't have the time to teach myself enough ASP and/or JSP to create a better interface just now.
Thank You
--
Ian Skinner
Web Programmer
BloodSource
No, that was not specifically mentioned. I can't comment on this feature
specifically, but I do plan on discussing this on tour stops.
--- Ben
_
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 12:37 PM
To: CF-Talk
Subject: Re: SOT - Last nights NYCFUG
I heard someone mention passing using a CFC data type but I
don't really know what that means.. I must've missed that
session at MAX last year :)
You can define a custom data type using a CFC with nothing but CFPROPERTY
tags. You can then specify that CFC as your RETURNTYPE attribute value.
Hi, all...
How can I order these values numerically?
1:1-5
1:14-18
1:6-8
How can I, without making the db field a numeric field rather than a varchar
field,
cause these values to be ordered this way:
1:1-5
1:6-8
1:14-18
Thanks for your help...
Rick
--
Outgoing mail is certified Virus Free.
Is there a way to programmatically create/delete a file DSN from within
CF MX 6.1/Windows?I didn't think there was...
Pete
Ben Doom wrote:
I'm assuming that 1) this is a Win server and 2) you have access to it.
Instead of opening the file directly, try setting up a file DSN.Then,
you can
Not to put a damper on anything in the new version of CF, but Blue Dragon does
offer very good code protection.It seems as though the CFML templates can be
precompiled and encrypted.
The templates are no longer human readable.There is no way to return the
COML. templates to there original COML.
Did you try the IE7 hack?
http://dean.edwards.name/IE7/
forces IE6 to behave with web standards.
-nathan strutz
[EMAIL PROTECTED] wrote:
Hello
I've been looking at
http://www.w3.org/TR/CSS21/selector.html#pseudo-elements and the
pseudo-class 'focus'
When I've got
style
On May 20, 2004, at 11:59 AM, Ray Champagne wrote:
What is this all about now? PDF's from CFML? Easily? Me likee, want
to
hear more
Here's your chance.Ben, Tim and Dave Gruber will be presenting at
12:00 PM Pacific (3:00 PM Eastern).Just go to the URL below:
Hi,
I am relatively new to using Cold Fusion but I will describe my problem the best that I can. I am looking to access the cert_subject cgi variable and am having problems with it being returned, returns an empty string. I am now running a cold fusion mx on a netscape enterprise server 6.1 where
I saw a quote from you that said that while you were talking about all sorts
of neat stuff at the regular user group meeting, that you were actually
saving the big guns for the CFUN-04 conference in June! Can't wait Ben, see
ya there!
Sandy
http://www.cfconf.org/cfun-04/
and I promise, no
If the fields are not numeric fields then you are left with 1) parsing the
string fields prior to sorting or 2) sorting by the string values as they
are.To avoid parsing, you could change the values in the db (once) to
something that would sort more easily, like 0001:0001-0005 instead of
1:1-5.You
I know there is a fix for this, but I am not having any luck in my searches
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice:This message including any
attachments is
hi there.
I think this was mentioned in a thread last week or the week before, but im
building out a hot spare cfmx server, and I want to get *EVERYTHING*, all
settings, datasources, mappings, checkboxes for cache, etc...
where does one go to get EVERYTHING?
thanks!
...tony
tony weeg
senior
CF 5 or MX?
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 1:26 PM
To: CF-Talk
Subject: Lost Administrator Password
I know there is a fix for this, but I am not having any luck in my
searches
--
Ian Skinner
Web Programmer
Ok, so that search I tried resulted in a relevant link
http://www.houseoffusion.com/cf_lists/index.cfm/method=messages http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=22866forumid=4 threadid=22866forumid=4
Confidentiality Notice:This message including any
attachments is
Here's a goofy idea.
As long as you don't have any decimals in your list - that your list is all
ranges of integers -
I'm assuming you're extracting 1-5, 6-8 etc. from your DB, and they're all
in the same field.
So do a ValueList() on that field, so you end up with a list:
1-5,14-18,6-8
Be sure to drop by one of the stop on my upcoming user group tour (stops
listed at http:// http://www.forta.com/ www.forta.com/, right column) to
see examples of this in action ...
Heh, you're going to be at CFUN as well, aren't you?
Hatton
---
Outgoing mail is certified Virus Free.
Checked
At 12:00 PM Pacific (3:00 PM Eastern), Ben Forta, Tim Buntel and Dave Gruber talk ColdFusion and answer community questions.
To participate, go to:
http://macromedia.breezecentral.com/r36158305/
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
OK.If it won't make you break NDA etc, any time frame for next cf release?
No, that was not specifically mentioned. I can't comment on this feature
specifically, but I do plan on discussing this on tour stops.
--- Ben
_
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent:
I've heard that this macrochat will be focused on the currently released version of CFMX... so I wouldn't hold you breath on hearing anything about Blackstone...I might be, and I hope that I am, completely wrong on this...I'd love to see more Blackstone information... the Worldwide Usergroup
Order by the length of the field, then the field itself.This won't
always work if there are overlaps.
--Ben Doom
Rick Faircloth wrote:
Hi, all...
How can I order these values numerically?
1:1-5
1:14-18
1:6-8
How can I, without making the db field a numeric field rather than a
Ben,
On 5/20/2004 at 12:36, you wrote:
BF asking who you'd want to be stuck ondesert island with, and I
BF came in 1st (ahead of the DW team, ouch!). :-)
Certain CFUGers (not me, mind you) wanted to base their choice on what
you'd be wearing :)
Many said that the DW designer would be better as
Chunshen,
On 5/20/2004 at 13:41, you wrote:
CL any time frame for next cf release
2005 was as specific as they'd get...and fairly noncommittal at that.
But I don't think it will be concurrent with Longhorn's release ;)
~ Ubqtous ~
[Todays Threads]
[This Message]
[Subscription]
[Fast
Yep, indeed. CFUN opens the 5th week of the tour.
--- Ben
_
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 1:39 PM
To: CF-Talk
Subject: RE: SOT - Last nights NYCFUG meeting.
Be sure to drop by one of the stop on my upcoming user group tour (stops
Sorry...forgot a subject line.
==BEGIN FORWARDED MESSAGE==
From: Nathan R. Jessop [EMAIL PROTECTED]
To: Bushy [EMAIL PROTECTED]
Date: Thu, 20 May 2004 14:09:56 -0400
Reply-To: Nathan R. Jessop [EMAIL PROTECTED]
Priority: Normal
X-Mailer: PMMail 2000 Standard
In these CFUN-04 interviews, Michael Smith talks to Christian Cantrell
about Flash for CFers, Charlie Arehart about Database, Sandra Clark
on CSS for Better Sites and Stephen Shapiro about his keynote
talk at CFUN-04, SpeedInnovating: Breakthrough Solutions at
Breakneck Speed. But first some news.
Thanks.
Chunshen,
On 5/20/2004 at 13:41, you wrote:
CL any time frame for next cf release
2005 was as specific as they'd get...and fairly noncommittal at that.
But I don't think it will be concurrent with Longhorn's release ;)
~ Ubqtous ~
[Todays Threads]
[This Message]
[Subscription]
I believe they said early 2005, not just 2005. That's a bit better,
isn't it? ;-)
--- Ben
_
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 2:13 PM
To: CF-Talk
Subject: Re: SOT - Last nights NYCFUG meeting.
Thanks.
Chunshen,
On 5/20/2004 at 13:41, you
:focus is only supported in NS6, Mozella, Firebird IE5(MAC).You will
need to use _javascript_.
Walt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 11:51 AM
To: CF-Talk
Subject: OT: CSS 'focus' in IE
Hello
I've been looking at
Ben,
On 5/20/2004 at 14:17, you wrote:
BF I believe they said early 2005, not just 2005. That's a bit better,
BF isn't it? ;-)
After seeing CFFORM and CFDOCUMENT in action, even early 2005 is too
long to wait!
~ Ubqtous ~
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
This is probably more appropriate on CF-IDE, but that doesn't seem to be a very active list.
Has anybody on this list augmented Dreamweaver with their own features/ functions/ behaviors?
I'm trying to get a sense of what and how I can extend Dreamweaver.The root of my desire is that I like the
What would be the code if I inserted the values as
1:001-005
1:014-018
1:006-008
so that they would sort correctly as entered,
then strip out all 0's for display?
Rick
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 1:47 PM
To: CF-Talk
Subject:
Order the list in SQL, then use a CFOUTPUT GROUP to ensure that they're
unique
-Original Message-
From: Nathan R. Jessop [mailto:[EMAIL PROTECTED]
Sent: 20 May 2004 14:12
To: CF-Talk
Subject: re: Ignoring duplicates in select
Sorry...forgot a subject line.
At 02:17 PM 5/20/2004, you wrote:
RedSky beta lasted 6-8 months, I think. If the beta starts soon (if not already), then EOY 2004, Early 2005 looks correct.
Any tidbits on the new event-based programming features?
I also heard that MM is adding a CFFUSEBOX tag to do fusebox stuff because its
Hello,
I have a signup form for a client that gets 9700 records from the database it then outputs them into a select box for them to people out for it for roommates.It does this 3 or 6 times depending of how many hotels they are staying at.The script is using more than 200MB of memory causing CF
If the values were inserted like that, they should sort correctly.You
could strip leading 0s with something like
rereplace(string, :0*, :)
rereplace(string, -0*, -)
Is that what you were asking?
Ben Doom
Rick Faircloth wrote:
What would be the code if I inserted the values as
1:001-005
I don't want to use a database because of oeverhead.
On Thu, 20 May 2004 14:48:18 -0400, Philip Arnold wrote:
Order the list in SQL, then use a CFOUTPUT GROUP to ensure that they're
unique
-Original Message-
From: Nathan R. Jessop [mailto:[EMAIL PROTECTED]
Sent: 20 May 2004 14:12
Of course, I wouldn't want appropriate 0's stripped...
10:001-005
10:014-018
10:006-008
If those were the values, the first 0's for 10: would need to stay...
Rick
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 2:50 PM
To: CF-Talk
Subject:
Hi,
My client will be uploading MS Excel files periodically to the server. The
names of the files change periodically, but the column names in the sole
worksheet will stay the same. How do I read these Excel files with CFMX (in
Windows) without committing to a File-based DSN?
Thanks,
George
Alexander Sherwood wrote:
I also heard that MM is adding a CFFUSEBOX tag to do fusebox stuff
because its the best framework.
I heard it'll shoot lasers at .net servers but you can't feed it after
midnight.
hmm. i think we're getting off topic now.
-nathan strutz
[Todays Threads]
[This
From: Nathan R. Jessop
I don't want to use a database because of oeverhead.
In which case, keep a list of items as you write them out, and before
you do the next one, check that it's not in the list
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
anyone have a URL for some good docs on this?up to date ones?google is not so friendly today:(
Cheers!
--
Douglas Knudsen
Alltel ACI Rapid Response Team
To fear love is to fear life, and those who fear life are already three parts dead. Bertrand Russell
If you have access to another CF machine that you know the password to, you
can export the registry key adminpassword and import it into the one you
do not know the password for. (or you can probably zero out the registry
key for the server and login with no password.)
Start and Stop CF server
I am using CFQUERY on a text ODBC datasource. One of the fields is zip code.
When a zip contains a dash, as in 12345-1234, the field is returned as an
empty string. What could be going on?
Thanks!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hey All (and Dave),
I know Dave and others have mentioned some software that they use for
cross-browser and I think even cross-OS testing.I've Googled it and can't
find it in the CF-Talk archives.
Anybody? or any other options?
TIA
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce
Hi,
I just created a custom tag called CF_RelateList.It works just like
CF_TwoSelects and CF_ThreeSelects.When you select an item in one select
list, a new list of items will be generated in the second select list. This
CF_RelateList allows you to create individual select lists.This would make
First, thx to the guys who helped me out earlier.And because of their
help, I've gotten to the point where I've got another question.
A bit of background - I've got a view in Oracle that's got 21 columns and
1066 rows; I was told the number of rows is going to grow larger.It
seemed to me CF was a
At 15:46 5/20/2004 -0400, you wrote:
I am using CFQUERY on a text ODBC datasource. One of the fields is zip code.
When a zip contains a dash, as in 12345-1234, the field is returned as an
empty string. What could be going on?
What type of DB?
What data type is it in the DB?
[Todays Threads]
Check your CF Admin pages.Specifically the detailed information for you DSN.There is an option there to restrict the size of a field to 64k characters, and is on by default.
I believe this is a performance tuning setting, but can be turned off in situations like yours.
Of course, this is only
1 - 100 of 137 matches
Mail list logo
