RE: UML

2000-12-04 Thread Anthony Geoghegan

UML is designed with object orientated software in mind, is it not?
CF is most definitely not OO
You could try it in combination with the CFOBJECTS coding standard, which
purports to make CF OO compliant.

I am going to try and model out the next project with UML - any suggestions
on resources, books, sites... etc?  I have the monstrous 10MB UML docs
1.3 -- anything else?

Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SPAM Alert

2000-11-28 Thread Anthony Geoghegan

www.netcraft.com
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


-Original Message-
From: Adam Reynolds [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2000 09:08
To: CF-Talk
Subject: SPAM Alert


Hi guys,
I appear to be getting email from [EMAIL PROTECTED] about
some crap job board.

As I've only just started consulting at Unilever and I've only posted to
the CF lists I think we may have a problem. Anybody know of site where it
is possible for me to track down their ISP so I can get them banned?

Best Regards,

Adam Reynolds
ColdFusion Web Developer
ISMG Development, Unilever
London
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Application.cfm inheritence

2000-11-27 Thread Anthony Geoghegan

In a word, no.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: 25 November 2000 01:31
To: CF-Talk
Subject: Application.cfm inheritence


Hello,


Will a "child" application.cfm inherit variables, settings, etc from the 
parent application.cfm?

For example:


+Root Dir
|application.cfm
+---Some Subdir
|   applicaiton.cfm(2)


will application.cfm(2) be able to get the settings from application.cfm?
-- 
Michael She
I m a g i n e   C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Radio Buttons

2000-11-27 Thread Anthony Geoghegan



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2000 12:41
To: CF-Talk
Subject: Radio Buttons


Hi Luke it should be:

 Cfswitch expression=form.options 
Cfcase value="free"
   Free code here
   /cfcase
cfdefaultcase
blah
/cfdefaultcase
/cfswitch

What am I doing wrong?

Thanks

Will

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Radio Buttons

2000-11-27 Thread Anthony Geoghegan

I knew this worked but people keep telling me not to use the # symbols when
possible as it takes the interpreter longer to execute.

   Cfswitch expression="#form.options#"

Sorry for leading you astray.  I'm sure the correct solution presented
itself to you quickly when I drew your attention to the line of code with
the problem.  I am very familiar with this error as I still do it regularly
;-).
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: SQL Question

2000-11-22 Thread Anthony Geoghegan

SQL server chokes on this. 
Replace() is a valid TSQL function, I guess I need something like DE() in
CF...

Any ideas?

Just use single quotes.

SELECT * 
FROM   tblNames
WHERE  replace(firstname+lastname,' ','')='#who#'
It should work now.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: MORE VERITY PROBLEMS

2000-11-22 Thread Anthony Geoghegan

I've had this problem.
I found I had to restart the CF server after removing a verity collection if
it got corrupt or anything.
Then I could replace the old colection with a new one.
We are using 4.0.1 I hope it may be fixed in 4.5.1
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 06:14
To: CF-Talk
Subject: Re: MORE VERITY PROBLEMS


Why don't you remove the collection before trying to make a new one?

At 09:47 PM 11/21/00 -0800, you wrote:

Now I delete a collection but the files are still on the server so when I
try and make a collection with the same name...yep you guessed it...NADA.

Anyone out there using Verity a lot?

In some ways it's very cool. In other ways...it's stinky.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

-=-=-
SBG-Priority: 4 (Low) http://www.internz.com/SpamBeGone/

-- 
Michael She
I m a g i n e   C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Determining optimum timeout

2000-11-22 Thread Anthony Geoghegan

Some kind of random element in the timeouts could be effective in avoiding
contention.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2000 21:59
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Determining optimum timeout


 How do you determine the optimum timeout for a cflock? I
 currently have most of mine set to timeout="10" but am
 wondering if there is a method to determining timeouts?

Unfortunately, there isn't a very good answer for this. I personally tend to
keep timeouts for using memory variables around 2-5, but use larger values
when locking access to other shared resources, like CFX tags.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: MORE VERITY PROBLEMS

2000-11-22 Thread Anthony Geoghegan

Dylan,
I Have had exactly this problem.
It looks like a bug.

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 15:54
To: CF-Talk
Subject: RE: MORE VERITY PROBLEMS


I'm deleting through the Admin. Files are on the server, collection does not
exist in the admin.

They're not mapped collections.

What version of CF are you running? I'm on 4.01 Ent.

-Original Message-
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 22, 2000 7:51 AM
To: CF-Talk
Subject: RE: MORE VERITY PROBLEMS


We're using Verity.  I'm able to delete collections using CFCOLLECTION, and
it does remove the files.

Are you deleting using CFCOLLECTION or through the Administrator?  If the
former, check the Administrator and see if the collection still exists.

Is it, by chance, a mapped collection?  From the docs:

Deleting a mapped collection unregisters the alias; the base collection is
not deleted.



-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 11:48 PM
To: CF-Talk
Subject: MORE VERITY PROBLEMS


Now I delete a collection but the files are still on the server so when I
try and make a collection with the same name...yep you guessed it...NADA.

Anyone out there using Verity a lot?

In some ways it's very cool. In other ways...it's stinky.

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: MORE VERITY PROBLEMS

2000-11-22 Thread Anthony Geoghegan

Snap
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 16:12
To: CF-Talk
Subject: RE: MORE VERITY PROBLEMS


I've encountered the same thing.  Here's what I do when I need to delete and
recreate a collection:

1. Delete the collection using either CF Administrator or CFCOLLECTION.
2. Restart the CFAS.
3. Delete the files found under CFUSION/Verity/Collections/{collection
name}.  Note: it seems that the CFAS will not let you delete these files
without the restart in step 2.
4. You may have to restart the CFAS again (I can't remember if I had to).
5. Recreate the collection (via Administrator or CFCOLLECTION).

This seems to work, as long as you can afford to restart the CFAS.  We
usually do it late at night when it isn't likely that anyone is hitting the
server.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: MS Index Server vs. Verity

2000-11-22 Thread Anthony Geoghegan

Index server is a security nightmare, never, ever install this dung.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 17:06
To: CF-Talk
Subject: RE: MS Index Server vs. Verity


I don't know a lot about index server, but I hazard to guess it's probably
going to run faster than verity.  I'm sure Mr. Dave Watts will have more to
say on the matter.

~Simon

 Simon Horwith
 Certified ColdFusion Developer
 Fig Leaf Software
 1400 16th St NW, # 220
 Washington DC 20036
 202.797.6570 (direct line)
 www.figleaf.com
 


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 22, 2000 11:46 AM
To: CF-Talk
Subject: MS Index Server vs. Verity


Hi,

I had to demo how cold fusion works to my I.S. department last week and 
after showing them how 'verity' works they suggested I look into 'Index 
Server' as a 'better' alternative. Can I get some of your opinions as to the

differences between the two and where I can get more info on 'Index Server'

Thanks

Sal

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: n-Tier Applications and CF

2000-11-21 Thread Anthony Geoghegan

I would have thought that JSP's would be the easiest solution.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Rob Cawte [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2000 06:30
To: CF-Talk
Subject: n-Tier Applications and CF


Hi All,

We have a large CF site running on Solaris/Oracle, and intend to move much
of the business logic to Java classes/EJBs, possibly using Weblogic.

Is there anyone with experience using CF for the presentation/controller
layer of such a system, who can advise of the approach they used, such as
whether they used CFOBJECT, Java CFXes or servlets, the benefits of using CF
in the mix, and the possible pitfalls of this kind of setup.

Many TIA,
-Rob
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: ASP and ColdFusion

2000-11-09 Thread Anthony Geoghegan

Hi Stu,

What I would like to do, is to use ColdFusion to pull the data from the
website and put it into a database.

How are you going to pull the data from the website?
Are you going to execute ASP pages to give a result and then use the CF to
act on the results of the ASP pages to put the data into a DB?
If you are then try using WDDX xml packets.
I believe an activex for creating WDDX packets exists and easily available.
You can easily integrate this with your ASP to produce the resultant xml
datapacket.  Then use CFHTTP to pull the xml file to the CF pages (you don't
need CFHTTP if the CF web server is also executing your ASP) and just import
the WDDX data and Bob's your father's brother.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: date comparisons

2000-11-09 Thread Anthony Geoghegan

Hi Willy,

SELECT * FROM table
WHERE datefield = '#dateformat(date1,"mm/dd/yy")#'
AND datefield = '#dateformat(date2,"mm/dd/yy")#'

Pulls all data from table between date1 and date2 (inclusive).
I found the Books Online SQL refernece an excellent Reference.
I can't say I've ever used a tuorial for it though.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Help - Please

2000-11-09 Thread Anthony Geoghegan

I've found SQL very case-sensitive is SKYFOCUS really skyfocus or SkyFocus.
Because you hav asked to access an unknown database it may give a general
login failure.
I'm not sure as I haven't used MySQL before.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Is Cold Fusion a Typed Language?

2000-11-08 Thread Anthony Geoghegan

Try modula 2 for a strongly typed language.
It must be the most strongly type system I've ever run into.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: 07 November 2000 22:17
To: CF-Talk
Subject: RE: Is Cold Fusion a Typed Language?


A strongly typed language requires you to declare the data type of all
variables ahead of time. All functions return values that are of a specific
type. All operators act on values of specific data types.

For example, assume you have a function nth( list, n) that returns the nth
value of a list where a list is a string with comma separated values. nth
might be declared as follows:
  string nth( string list, integer n)

It would be an error to pass anything but a string as the first argument. It
would be an error to pass anything but an integer as the second argument. It
would be an error to assign the results to anything but a string variable.

string list = "10,20,30,40";
string val;
integer n=2;
integer m;

val = nth( list, n);( val = the string "20")
m = nth( list, n);(ERROR because nth returns a STRING not an integer)
val = nth( list, "3")  (ERROR because "3" is a string)
val = nth( list, 3)(val = the string "30")

If you need to get around these restrictions you need to explicitly convert
the datatypes:

m = convert( nth( list, 3), "integer")
or
m - (int) convert( nth( list, 3))   (this is how 'C' does it)


The advantages of a strongly typed language are the compiler/run-time system
can catch subtle errors because you are so explicit about what data types
are being passed around.
The disadvantage is it's a pain to have to declare everything ahead of time
and to convert values all over the place.

Most "typed languages" are not quite this strict and will do many automatic
conversions for you.


At 08:21 AM 11/7/00 -0800, Warrick, Mark wrote:
For the sake of us non-programmers could you explain what "typed language"
means?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


 -Original Message-
 From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 07, 2000 5:40 AM
 To: CF-Talk
 Subject: Is Cold Fusion a Typed Language?
 
 
 
   I've heard in quite a few places that ColdFusion is a typed language?
 However, it acts as an untyped language.  Can anyone verify for me which 
 one is actually true?
   
   You don't declare variables a type when you create them, and you 
 can typically change a variable from a string to an integer without 
 a second thought.  I was told that ColdFusion handles all data 
 conversion internally to take the burden off the user, but for 
 efficiency's sake, it's best not to switch the type of a variable if 
 you can avoid it.
 
   And if Cold Fusion is a typed language, what are the simple types? 
 The standard string, integer, float, and boolean?  
 
 -- 
 Jeff Houser
 AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
 --
 DotComIt, LLC
 Computer Consultant specializing in database driven web data
 Lotus Notes/Domino, Cold Fusion
 --
 Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
 http://www.farcryfly.com
 http://www.mp3.com/FarCryFly
 --
 Does Everyone Think I'm a Cynical?
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
 or send a message with 'unsubscribe' in the body to 
 [EMAIL PROTECTED]

---
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarsts or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]



---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938

To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803rid=972879910type=A




Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
---

RE: strange SQL error code

2000-11-08 Thread Anthony Geoghegan


On that note, does anyone have a list of Microsoft SQL Error Codes?

They are listed in the online books online-reference.
If you like I'll post you a text file offlist.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Is Cold Fusion a Typed Language?

2000-11-07 Thread Anthony Geoghegan

In my experience CF is a typed language, but with virtually no
type-checking.  Almost all datatypes (except date/time types) are easily
cross compatible.  Without variable declaration it's very hard to type-check
data.
It's a bit lax and probably results in quite a few bugs.
Java is much cooler.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: 07 November 2000 13:40
To: CF-Talk
Subject: Is Cold Fusion a Typed Language?



  I've heard in quite a few places that ColdFusion is a typed language?
However, it acts as an untyped language.  Can anyone verify for me which 
one is actually true?
  
  You don't declare variables a type when you create them, and you 
can typically change a variable from a string to an integer without 
a second thought.  I was told that ColdFusion handles all data 
conversion internally to take the burden off the user, but for 
efficiency's sake, it's best not to switch the type of a variable if 
you can avoid it.

  And if Cold Fusion is a typed language, what are the simple types? 
The standard string, integer, float, and boolean?  

-- 
Jeff Houser
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
DotComIt, LLC
Computer Consultant specializing in database driven web data
Lotus Notes/Domino, Cold Fusion
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
http://www.farcryfly.com
http://www.mp3.com/FarCryFly
--
Does Everyone Think I'm a Cynical?


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: Poll two tables...

2000-11-07 Thread Anthony Geoghegan

Use a custom field to indicate which table the data is from.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 07 November 2000 14:46
To: CF-Talk
Subject: Poll two tables...


Not sure how'd I would go about doing this, so here's my question.

I do a verity search, then query the verity results - match those results
from a table in my DB, and present the final results. 

Problem is every once in a while some of the matched verity results may lay
in another table.

Any suggestions for me?

Thanks,
Pete



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: CFHEADER

2000-11-02 Thread Anthony Geoghegan

I've used this to good effect:

CFHEADER NAME="cache-control" VALUE="no-cache, no-store, must-revalidate"

Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: 01 November 2000 19:39
To: CF-Talk
Subject: CFHEADER


This is a multi-part message in MIME format.

--=_NextPart_000__01C043F8.607059A0
Content-Type: multipart/alternative;
boundary="=_NextPart_001_0001_01C043F8.60798160"


--=_NextPart_001_0001_01C043F8.60798160
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Has anyone used CFHEADER to make a page expire? I've tried several settings
with no luck.

What I'm trying to do is make so when someone logs out of a page and then
uses the BACK feature in their browser, that page is no longer available.

Thanks!

--Dylan

  bromby.com

  web  wireless consulting  dylan bromby

e [EMAIL PROTECTED]
m 949 400 6333
f 707 220 2964
  co-author wap development with wml  wmlscript



--=_NextPart_001_0001_01C043F8.60798160
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252"
META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR/HEAD
BODY
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana size=3D2Has =
anyone used=20
CFHEADER to make a page expire? I've tried several settings with no =
luck.=20
/FONT/SPAN/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana size=3D2What =
I'm trying to=20
do is make so when someone logs out of a page and then uses the BACK =
feature in=20
their browser, that page is no longer available./FONT/SPAN/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana=20
size=3D2Thanks!/FONT/SPAN/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana=20
size=3D2--Dylan/FONT/SPAN/DIV
DIVSPAN class=3D010063819-01112000FONT face=3DVerdana=20
size=3D2/FONT/SPANnbsp;/DIV
TABLE cellSpacing=3D2 cellPadding=3D9 width=3D375 bgColor=3D#00 =
border=3D0
  TBODY
  TR
TD bgColor=3D#003399
  CENTERFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#ff=20
  size=3D1Bbromby.com/B BRBRweb amp; wireless consulting=20
  /FONT/CENTER/TD
TD bgColor=3D#e6e6e6FONT face=3DVERDANA,ARIAL,HELVETIVA =
color=3D#00=20
  size=3D1Bdylan bromby/B BRBR
  TABLE cellSpacing=3D0 cellPadding=3D2 border=3D0
TBODY
TR
  TDFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#00=20
size=3D1Be/B/FONT/TD
  TDFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#00=20
size=3D1[EMAIL PROTECTED]/FONT/TD/TR
TR
  TDFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#00=20
size=3D1Bm/B/FONT/TD
  TDFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#00 =
size=3D1949 400=20
6333/FONT/TD/TR
TR
  TDFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#00=20
size=3D1Bf/B/FONT/TD
  TDFONT face=3DVERDANA,ARIAL,HELVETIVA color=3D#00 =
size=3D1707 220=20
2964/FONT/TD/TR/TBODY/TABLEco-author Iwap =
development with wml=20
  amp; wmlscript/I /FONT/TD/TR/TBODY/TABLE
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_001_0001_01C043F8.60798160--

--=_NextPart_000__01C043F8.607059A0
Content-Type: text/x-vcard;
name="Dylan Bromby.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Dylan Bromby.vcf"

BEGIN:VCARD
VERSION:2.1
N:Bromby;Dylan
FN:Dylan Bromby
ORG:bromby.com
TEL;WORK;VOICE:(949) 400-6333
TEL;WORK;FAX:(707) 220-2964
URL:
URL:http://www.bromby.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20001026T145402Z
END:VCARD

--=_NextPart_000__01C043F8.607059A0--



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: JOIN ON not supported in Access?

2000-10-26 Thread Anthony Geoghegan

Hi John,
The Access documentation states that Access does support left join (left
outer join).
You use this line here:
  FROM
   uprr_related_drawings  rel,
   uprr_drawings  dwg
  LEFT JOIN
   uprr_dateloc  loc
  ON
   dwg.drawing_ID = loc.drawing_ID

Try:
  FROM
   uprr_related_drawings AS rel
  INNER JOIN
   uprr_drawings AS dwg   
  ON
   uprr_drawings.drawing_ID = uprr_related_drawings.related_drawing_ID
  LEFT JOIN
   uprr_dateloc AS loc
   ON
   uprr_drawings.drawing_ID = uprr_dateloc.drawing_ID

This might help, I've had problems with aliases working inside the query
before.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: SQL INSERTs across multiple related tables

2000-10-24 Thread Anthony Geoghegan

Hi Simon,
would it not be

INSERT INTO Users
INNER JOIN Wages
ON Users.User_ID = Wages.User_ID
(Users.Surname, Wages.NINumber)
VALUES ('Bloggs', 'NY012398B')

eh?

Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: SQL INSERTs across multiple related tables

2000-10-24 Thread Anthony Geoghegan

What about using a view?
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: CFINPUT fill-in-the-value question

2000-10-20 Thread Anthony Geoghegan

Hi Scott,
We use something like this

cfset CheckboxArray = ArrayNew(1)
cfloop index="i" from="1" to="#number_of_checkboxes#"
cfset CheckboxArray[i] = ""
/cfloop
cfloop query="get_values"
cfset CheckboxArray[get_values.checkresults] = "checked"
/cfloop
cfoutput
input type="checkbox" name="box" #CheckboxArray[1]# value="1" 
input type="checkbox" name="box" #CheckboxArray[2]# value="2"
input type="checkbox" name="box" #CheckboxArray[3]# value="3"
input type="checkbox" name="box" #CheckboxArray[4]# value="4"
::::   :   :   :   :   ::   ::   :   :   :
::::   :   :   :   :   ::   ::   :   :   :
::::   :   :   :   :   ::   ::   :   :   :
::::   :   :   :   :   ::   ::   :   :   :
::::   :   :   :   :   ::   ::   :   :   :
input type="checkbox" name="box" #CheckboxArray[n]# value="n"
/cfoutput

Hope this helps.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent: 19 October 2000 22:13
To: CF-Talk
Subject: CFINPUT fill-in-the-value question


How, pray tell... when one has several CFINPUTS that are checkboxes, named
the same but with different numeric values... if one should have a list of a
portion of those values... does one tell a CFINPUT tag to check that list
against the value of the current checkbox field, and check it should it find
a match?

Obviously one can't put a CFIF inside a CFINPUT to check and spit out
"checked" if it finds it... any thoughts?

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]



RE: cfif

2000-10-12 Thread Anthony Geoghegan

Sorry Guys,
I didn't mean keep it simple as in make it easy to follow.  I've been coding
too long I think.  I meant keep it simple as in smaller code = smarter code.
The less processing the page has to do the better.
I guess I've left those days of being a teacher long behind.
Sorry for being so cryptic Pete ;-).

Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfif

2000-10-11 Thread Anthony Geoghegan

Hi Peter,

Try something like this:
cfif testdate2 LTE dateadd("d","30",testdate1) and complete is "true"



-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2000 14:32
To: CF-Talk
Subject: cfif


I want to check if a date is not greater than 30 days old.

I've got the datediff working, but I want to present the table only if the
date isn't over 30 days old.  So I'm doing this: cfif difference IS NOT GT
-30 AND complete IS "true"

Which obviosly doesn't work.  What am I doing wrong?

-Peter
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfif

2000-10-11 Thread Anthony Geoghegan

Hi Pete,
Like this.
cfif now() LTE dateadd("d","30",due) and complete is "true"
Keep it simple.

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2000 15:43
To: CF-Talk
Subject: RE: cfif


Well here is all the offending code

cfset datedue=#DateFormat(#due#, "m/d/yy")#
cfset nNow=#DateFormat(Now(), "m/d/yy")#
cfset difference=#DateDiff("D", nNow, datedue)#

cfif difference IS NOT LT -30 AND complete IS "true"


I'm not sure how I'd use your example with this.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Error creating Verity collection

2000-10-04 Thread Anthony Geoghegan

Hi Steve,
Restart the server.
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 October 2000 12:26
To: CF-Talk
Subject: Error creating Verity collection


I have been happily creating and deleting Verity collections for a 
few days now either via the Administrator or code (CF 4.5, NT 
Server).  However, when I try to create a collection now I am given 
the error message "Error creating Verity collection".  

I have deleted all the collections, but CF still refuses to play ball.

Any suggestions?

Thanks

Steve


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: quick question

2000-09-28 Thread Anthony Geoghegan

Hi Simon,
I am currently working on a similar project...
ick question


What is the information in CGI.HTTP_USER_AGENT?

For Netscape I get:

Mozilla/4.08 [en] (Win98; U ;Nav)

and for IE I get:

Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)

These values are provided by the browser and as such are provided in any
format that Netscape or IE chooses.  I don't see much option but to capture
the results from a variety of browsers and then write code to compensate for
each type.
Mozilla is an organization that produced one of the first open-source
browsers and such has been cloned to a greater or lesser degree by these
browsers.
You can access www.mozilla.org for more info.
Mozilla sounds like a cross between a Japanese monster and a stooge.
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Public Rates Discussion

2000-09-26 Thread Anthony Geoghegan

|And anyone else on this list with half a brain (U.S. Citizens, of course)
will keep their mouths |shut as well.

Mark,
Are you saying that US citizens only have half a brain :-)
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Vignette?

2000-09-26 Thread Anthony Geoghegan

Craig,
The http://www.medweb.com.au site is not exactly what I would call a
comprehensive site.  In fact it's just a single page , with one link to a
totally differently designed site.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Public Rates Discussion

2000-09-26 Thread Anthony Geoghegan

It's Just a joke Mark.
Take it easy.
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Verity Collection Names [CF-Talk]

2000-09-20 Thread Anthony Geoghegan

You could use a custom field with collection name in it...
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2000 10:38
To: [EMAIL PROTECTED]
Subject: Verity Collection Names [CF-Talk]


Hi,

Is there a way of retriecing the collection name from which a record came   
when searching through multiple collections using a single CFSearch?

Thanks

Richard  
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: MS SQL 7 Varchar

2000-09-18 Thread Anthony Geoghegan

USE oledb as dbtype

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 6:19 PM
To: [EMAIL PROTECTED]
Subject: MS SQL 7 Varchar


I've got a MS SQL 7 table with some fields defined as Varchar(510).
When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255
characters.  Is there a reason for this?  How about a workaround?

Jim

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Comparing values in 2 queries

2000-09-14 Thread Anthony Geoghegan


Hi Roger,

I suggest you turn field_b into a comma delimited list using valuelist. Then
cfloop through each record of field_a using a listfind to check for it's
presence in the list you created from field_b.
Just use a flag to indicate a failed check.

|Wanna ask for help here. Let's say that I have 2 queries which have a
|similar field column name. I wish to do a comparision and it's a AND
|critieria.

|For example,

|Field_a Field_b
|1   1
|2   2
|3   4
 5

|I wish to compare field_a with field_b and everything that's in field_a has
|to be found in field_b, else it'll fail. How do I go about doing that ?

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: sql query

2000-09-14 Thread Anthony Geoghegan

Hi Chad,

CFQUERY Name="aoyama" Datasource="super"
SELECT Storename, ID, City
FROM review
Where ID IN ('#ID1#, #ID2#')
/CFQUERY


Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Hotel Booking Engine up

2000-09-13 Thread Anthony Geoghegan

Hi Bob,

|   Anyone who was or is interested in a hotel booking can now view a
demo at
|http://www.reactivevision.com/products . There is an example of a portal
|site and a singular hotel site. The price is $5000 but is negotiable
|depending on what kind of configuration you are looking for. This is a new
|products so feedback is appreciated and fixes and enhancements can be done
|in a minimal amount of time.

Your link in the above paragraph is faulty.
It is my guess that your web-server has not been configured to take
index.cfm as the default page for this folder
http://www.reactivevision.com/products/index.cfm works though.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: SQL - Relational issue

2000-09-11 Thread Anthony Geoghegan

Hi Rudy

[You wrote:]

System : NT4, MSSQL 7 and CF 4.5

Scenario:
I have 2 tables, USERS and CARS with One-to-Many relationship.
If I delete a user, then all cars that he has should be deleted too.

I use 2 queries to delete a user in the USERS and all his cars in the =
CARS table.

Is there a more efficient way to just delete a user in USERS table and =
all connection to this will also be deleted too?
Imagine if there are more than 10 relational tables.
And Can setting up a Relation Diagram in SQL help me? (I did some tests =
and it doesn't turn out to be what I expected)

Suggestions and Advices are very much welcome.

[Ant says:]
If you enforce referential integrity in MS SQL the manual says:

"When you enforce referential integrity, SQL Server prevents users from: 

Adding records to a related table if there is no associated record in the
primary table. 
Changing values in a primary table that result in orphaned records in a
related table. 
Deleting records from a primary table if there are matching related
records."

This means that SQL will manage the references for you!

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Help deploying first project?

2000-09-11 Thread Anthony Geoghegan

Hi Adrienne,

Most likely your server company has made a balls of it.
What dbtype are you using?
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
http://www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Verity: Allaire's Disowned Step Child?

2000-09-06 Thread Anthony Geoghegan

Hi Lon,

You wrote:

Is there anyone here with experience setting Verity up? Someone
willing to
answer a couple questions?

I wrote:
We have used Verity extensively here at WOW!
What help do you need?
Also I like the term "CyberEntomologist", interesting...

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: http://www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFmail - Body

2000-08-29 Thread Anthony Geoghegan

Hi Phim,

You Wrote:
| I changed from Chr(13) to Chr(10)
| and It work!

It should be both CHR(13)  CHR(10) (CR  LF)
Carriage return  Line Feed

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: http://www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Slightly OT - Detecting that a page has completed.

2000-08-22 Thread Anthony Geoghegan

Hi Michael,

You said:
|I need to post some info back to the server near 
|the end of the
|page without the user knowing. If I set up a form with an 
|action property
|targetting a hidden frame, some hidden form fields and put 
|some Javascript
|into the end of the page which submits the form data , the 
|data should go
|back to the server? I'm wondering if anyone has done this sort 
|of thing.


Check out the vote button on our home page( www.wow.ie ), it does just this.
email me off list for the details.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Caching pages

2000-08-22 Thread Anthony Geoghegan

Hi All,

You wrote:
| Is there a way to keep browsers from caching a page?
|
|Yes

I have found this to be very effective:

CFHEADER NAME="cache-control" VALUE="no-cache, no-store, must-revalidate"

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFTREE's CompletePath Parameter

2000-08-22 Thread Anthony Geoghegan

Hi Michael,

You wrote:
|What the f*** does this mean in plain english?
|
|The examples don't show what this does, and with debugging 
|info on, there
|doesn't seem to be any difference between specifying Yes or No.

I have recently had the misfortune to work with this applet and found a few
problems with it so I had to dump it and get a third party applet to do the
same thing.
I believe the completepath parameter just specifies the applet to include
the parent folders in the path variable.  I think this path variable is
included as a parameter in the URL when a link is included on the treeitem
and the link is clicked.
I'm not sure as I said I tossed it because of table related issues.

Hope this helps.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: verity partial word search

2000-08-16 Thread Anthony Geoghegan

Hi Chad

You said:
| I know I can just add a * to the end of the criteria, 
|however it could get
| tricky with multiple words..
| Is there a verity function that does this by default?

The answer is no.
You can write a piece of code to separate the words handily enough though.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: SQL Server Stored Procedure problem

2000-08-15 Thread Anthony Geoghegan

Hi Paul,

You said:

|Someone tell me why this isn't working.  It's annoying me now:
|
|
|SELECT 'name not given', *
|FROM Directory
|WHERE CountryID = @country
|IF ( @type IS NULL )
|BEGIN
|AND DirectType = @type
|END

SQL doesn't support IS NULL like this.
In my experience you have to use the ISNull() function.

usage:
ISNULL(check_expression, replacement_value)

The replacement_value argument is the value the field will have, replacing
the NULL value, when the field has a NULL value.

AN example:

 SELECT 'name not given', *
FROM Directory
WHERE CountryID = @country
IF ( ISNULL(@type,'ANULL IS HERE') = 'ANULL IS HERE' )
   BEGIN
   AND DirectType = @type
   END

Hope this helps.
Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Error Handling

2000-08-10 Thread Anthony Geoghegan

Hi Miriam and Greg,

Greg said:
|Hello Miriam.  While I'm not too familiar with the CFSearch 
|tag, I would imagine that the CFTRY/CFCATCH could pick up any 
|such error and then you have control over how you'd handle it. 
| Look up the CFTRY/CFCATCH statements, use those and tell me 
|how it works out.
|
|Gregory Harris
|Los Angeles ITA Dept.
|[EMAIL PROTECTED]

Miriam Said:
|I am using CFSearch.  If the user enters "and","or", "'" then 
|I get a CF
|error.  I would like to catch only this error and display a 
|message to the
|user telling them that they entered invalid search criteria.
|
|Thanks,
| 
| ---miriam

You could always use findfirst on your search criteria for each of the
illegal character sets and when you get a non-zero response give an error
message.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: problem with query.

2000-08-10 Thread Anthony Geoghegan

|Above are two queries that drive a response page...where on this page
|the queries (as you can see) are being driven by the passed parameter
|#tech# from the previous page.

Hi Miles,
Sometimes when CF gives me an obscure database error with a select statement
I copy the statement to a SQL client and execute the select statement their
to see what SQL says itself.  It might give you more insight to the problem.
Sorry couldn't help you more.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Printing with Javascript function

2000-08-10 Thread Anthony Geoghegan


|I can't remember who I talked with before, but I got assistance on
|launching a new window with my data and prompting the user whether they
|wanted to print the screen. What I am using works, but it 
|double prompts
|me for printing and I am not sure why. Here is my code.
|
|SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
|!--
|   var doit = confirm("Send summary data to a new screen 
|to print?")
|   if (doit) {
|   print()
|   } else {
|   self.close()
|}
|//--
|/SCRIPT

Hi James

You have called doit twice.
I bet the first doit makes no differnce as to whether it prints or not.
do something like this:

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
!--
function doit 
{
return confirm("Send summary data to a new screen to print?");
}
if (doit) 
print()
else 
self.close()

//--
/SCRIPT

This was quick and I didn't get to test it.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: dynamic pulldowns using a database?

2000-08-09 Thread Anthony Geoghegan

Hi Keith,
I have a CF tag for doing this.
I have found that using this you can develop page size problems as the
relevent javascript can become quite large as the number of possible options
to display increases.
You can see it in action in our cinema sectiona at
www.wow.ie/cinema/index.cfm
If you like I can provide you with same.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: new worried

2000-08-08 Thread Anthony Geoghegan

Hi Megan,

You said:
|CFQUERY DATASOURCE="data" NAME="mq_our"
|SELECT prod_num,bead
|FROM mq_our FOR all malaID in the “sessions” table where the sessionID
|matches this current sessionID
|/CFQUERY

You could try something like this.

# mq_our_list.cfm 
CFQUERY DATASOURCE="data" NAME="mq_our"
SELECT prod_num,bead
FROM mq_our
WHERE malaID IN (SELECT malaID FROM sessions WHERE SessionID =
'#SessionID#')
/CFQUERY

|Thanks in advance for any help!
|Megan

No bother.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFHTTP

2000-08-02 Thread Anthony Geoghegan

Hi Kevin,

|I was looking into CFHTTP and was wondering if I could use it 
|to load a page
|without displaying said page.

I had a similar problem with a submitted form.  I got arround it by
directing the submitted form to a hidden frame on the page.
Presto apparently no page.

Have a look at the vote in the sports section of our site, when a vote is
cast a form is submitted the page that we submit the form to apparently
doesn't get executed ;-).

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Paging query results

2000-08-02 Thread Anthony Geoghegan

|I am using STARTROW and MAXROWS to display one page at a time, 
|and calling the same page with different arguments to change 
|the page I am displaying... BUT this reexecutes the query each 
|time. This query searches through a large database and takes a 
|little time. This is a pretty inefficient way to do it (I think).

Make sure you use maxrows on the cfquery tag, to limit the query to your
maxrows cfoutput size.
Also A verity search will probably produce a quicker response then a
standard select statement.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Looping through lists

2000-08-01 Thread Anthony Geoghegan

Hi Jon,

Jon Wrote:
|Hey, I need to figure out how to loop though a list and 
|perform a query for
|each value returned in the list. Any ideas?

You can get a query to select all the records with an entry contained in a
comma delimited list so:

cfquery name="select_text"
SELECT stuff FROM stuff_list
WHERE stuff_id IN (#stuff_id_list#)
/cfquery

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: (OT) - IP # setup

2000-07-25 Thread Anthony Geoghegan

There shouldn't be any problem with 192.168.*.*
This address set is the so-called pseudo b-class address set.
It has been recomended for local use.
(Don't forget to set your ip mask for 255.255.0.0 and don't use 192.168.0.0
it's not a valid address. ;-))

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



List slow down(FUSEBOX)

2000-07-25 Thread Anthony Geoghegan

 Can anyone tell me where to find resources on the Fusebox methodology.
Any
 websites or print materials will be useful.  Thank you very much in
 advance...

Here's one for the faq anyway.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Dynamic Variable

2000-07-25 Thread Anthony Geoghegan

Hi Kevin,

|I have kind of a stupid question.

Wrong thing to put on a question to this list lately Kev.

|I need to create a dynamic 
|variable =
|in a loop with the counter number attached to the end of the 
|variable. =
|So I get button1 button2 buttton3 etc

It looks to me that an array would be a much more elegant solution to this
problem Kev.
Somesinc like ziz I am thinkink, no?

cfset array_name = ArrayNew(1)
cfloop index="i" from="1" to="20"
  cfset array_name[i] = "whatever you like"
/cfloop

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Help w/ query display...

2000-07-21 Thread Anthony Geoghegan

|However doing this:
|input type="checkbox" name="runway_id#runway_id#" 
|value="#runway_id#" CFIF
|runway_ID IS "qgetrunwaydetail.runway_ID"CHECKED/CFIF#runway#
|
|Does not work.  even though there are 2 runway Id's that are 
|pulled from the
|runwaydetail query it only brings back one
|in this output. Either way it doesnt check any boxes at all. 
|Yet throws no
|errors either. 

Hi Kelly,
Am I correct in thinking this line is executed within a cfoutput for the
query qgetrunways
If so then the problem is refering to qgetrunwaydetail.runway_ID .When you
refer to this runway_id it exists in a seperate query qgetrunwaydetail which
isn't operating in a cfoutput (thus not looping through all the records).
In fact this will only pull out the last value in the recordset each time it
is executed.

At least from your description of the code this is what appears to be
happening.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Help with Query

2000-07-21 Thread Anthony Geoghegan

Hi Ben,
Try

SELECT Email FROM
CustomerLeads
WHERE CustomerLeads.Email ='#Email#'
UNION
SELECT Email FROM
EuropeLeads
WHERE EuropeLeads.Email ='#Email#'

This or a variation on this should work.

Regards,
Anthony Geoghegan
Lead Developer
Ireland Film and Television Net
26 South Frederick Street
Dublin 2
Ireland
Tel: +353 1 671 3664
Fax: +353 1 671 0763
Web: www.iftn.ie www.wow.ie
mailto:[EMAIL PROTECTED]

NOTICE:
This communication is confidential.  The copyright in this communication
belongs to Ireland Film  Television Net (IFTN) or a third party.

If you are not the intended recipient of this communication please delete
and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
If you are the intended recipient of this communication you should not copy,
disclose or distribute this communication without the authority of IFTN.

Any views expressed in this communication are those of the individual sender
except where the sender specifically states those are of view of IFTN.

Except as required by law IFTN does not represent, warrant, and/guarantee
that the integrity of this communication has been maintained or that the
communication is free of virus, interception or interference.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



List slowdown problems and solutions

2000-07-20 Thread Anthony Geoghegan



-Original Message-
From: Anthony Geoghegan 
Sent: 20 July 2000 14:44
To: '[EMAIL PROTECTED]'
Subject: RE: List slowdown problems and solutions


|3. "Gee, I didn't even know they had electricity in Ireland, much less
|internet access!"

Personal attacks aside, This kind of racist remark is obviously indicative
of your level of professionalism.  I believe in free-speech even if you
don't.  It's funny that you have such low opinion of Ireland, obviously
you've never been here.  You should come over for a "vacation" and educate
yourself on this before you make another such ill-advised remark.

|2. "If you want more snappy answers, just keep asking stupid questions."

I have yet to ask any technical question of this list. I do wish you would
get your facts straight.
I have, on the other hand, provided plenty of answers.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



FW: Mail delivery failed: returning message to sender

2000-07-20 Thread Anthony Geoghegan



-Original Message-
From: Mail Delivery System [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2000 16:28
To: [EMAIL PROTECTED]
Subject: Mail delivery failed: returning message to sender


|Does Oracle provide a free or inexpensive "demo" version of 
|their database?
|I need to connect to it on NTServer in a single user environment.

Hi Duane,
As far as I know, here in Ireland anyway, The smallest installation of an
Oracle database is 5 users and you also need some sort of
maintenance/training contract with them before they will sell the package to
you.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



ORDER BY in a UNION Query

2000-07-20 Thread Anthony Geoghegan


 The MSSQL on-line manual says:
 
 "when the SELECT statement includes a UNION operator, the column names or
 column aliases [in the order by clause] must be those specified in the
 first select list."
 
 This should fix your problemo.
 
 Regards,
 Anthony Geoghegan
 Lead Developer
 Ireland Film and Television Net
 26 South Frederick Street
 Dublin 2
 Ireland
 Tel: +353 1 671 3664
 Fax: +353 1 671 0763
 Web: www.iftn.ie www.wow.ie
 mailto:[EMAIL PROTECTED]
 
 NOTICE:
 This communication is confidential.  The copyright in this communication
 belongs to Ireland Film  Television Net (IFTN) or a third party.
 
 If you are not the intended recipient of this communication please delete
 and destroy all copies and telephone IFTN on +353 1 671 3664 immediately.
 If you are the intended recipient of this communication you should not
 copy, disclose or distribute this communication without the authority of
 IFTN.
 
 Any views expressed in this communication are those of the individual
 sender except where the sender specifically states those are of view of
 IFTN.
 
 Except as required by law IFTN does not represent, warrant, and/guarantee
 that the integrity of this communication has been maintained or that the
 communication is free of virus, interception or interference.
 
 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cookies?? or what to use

2000-07-19 Thread Anthony Geoghegan

Hi Lewis,

I must concede this is an elegant solution.

|Why would you want to use session variables when the 
|CGI.HTTP_REFERER seems to a more logical solution.
|

I must admit I was thinking more in terms of user variable forgery.
I was thinking in terms of a proprietry certificate type system.
(oops! a bit complicated ;-) )

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: List slowdown problems and solutions

2000-07-19 Thread Anthony Geoghegan

Hi All,
This damn list is so slow! I feel like I like I am in another time zone
(which I am) and you guys are using snail-mail to contact me.  The messages
I get are so time scued that I gvet so confuseed it's like I'm on drugs or
something. Forget trying to follow a thread.  Can we get this list to
provide snappy answers or do I have to unsubscribe in disgust.

I don't want to unsubscribe as I think this list is a good resource, but
with 200+ mails a day, most of which are from lamers who should read a
manual or do a course, I feel I have to at least complain before I explode
with frustration.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



List slowdown problems and solutions

2000-07-19 Thread Anthony Geoghegan



-Original Message-
From: Anthony Geoghegan 
Sent: 19 July 2000 10:22
To: '[EMAIL PROTECTED]'
Subject: RE: List slowdown problems and solutions


Hi All,
This damn list is so slow! I feel like I like I am in another time zone
(which I am) and you guys are using snail-mail to contact me.  The messages
I get are so time scued that I gvet so confuseed it's like I'm on drugs or
something. Forget trying to follow a thread.  Can we get this list to
provide snappy answers or do I have to unsubscribe in disgust.

I don't want to unsubscribe as I think this list is a good resource, but
with 200+ mails a day, most of which are from lamers who should read a
manual or do a course, I feel I have to at least complain before I explode
with frustration.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cftransaction error ? HELP.

2000-07-18 Thread Anthony Geoghegan

|++
|ODBC Error Code = 23000 (Integrity constraint violation)
|
|[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
|constraint 'PK__nxstar_e__076C2375': Attempt to insert duplicate key 
|in object 'nxstar_e'.

Hi Miles
I think your solution is probably an index in your SQL table with a "unique"
setting.  This means you cant create a situation where the index entries
have a duplicate "key".
Try changing the index settings or check your code for why this event could
occur.

BTW just a tip if you are genuinely looking for assistance try and keep your
posts short and sweet, we're working stiffs here and it takes time to peruse
these lists.  It just means nobody will assist you if you write complete
dissertations.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cookies?? or what to use

2000-07-17 Thread Anthony Geoghegan

Hi Kim,
Session Variables can be used for this purpose.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]



|-Original Message-
|From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
|Sent: 15 July 2000 19:07
|To: [EMAIL PROTECTED]
|Subject: cookies?? or what to use
|
|
|Ok, I'm new to the list...and new to using coldfusion.  I need 
|to ensure 
|that users can only go through the system in a certain order 
|(they must fill 
|out forms in a particular order and should not be allowed to 
|come into any 
|page of the system without first going through the previous 
|pages).  Does 
|anyone know how this is best achieved.  Any advice will be helpful.
|
|Thanks, Kim
|[EMAIL PROTECTED]
|___
|_
|Get Your Private, Free E-mail from MSN Hotmail at 
http://www.hotmail.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: ADO

2000-07-14 Thread Anthony Geoghegan



|-Original Message-
|From: Nille af Ekenstam [mailto:[EMAIL PROTECTED]]
|Sent: 14 July 2000 15:17
|To: [EMAIL PROTECTED]
|Subject: ADO 
|
|
|Since I'm having troubles (or rather; cf is having trouble 
|with) ODBC 

Hi Nille,
Have you tried OLEDB with MSSQL7?
We find it much more stable.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: problem with primary key

2000-07-13 Thread Anthony Geoghegan

Hi Greg,
Do you have an index set besides your primary key?

|SQL operation updated no rows.
|The SQL operation affected no rows.Either the Key value has 
|changed or the
|row has been deleted.
|
|The primary key is id, and I can't figure out why it suddenly 
|would stop

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Please help! CFFTP and empty file.

2000-07-13 Thread Anthony Geoghegan

|Anthony,
|Thanks for the reply.  I am simply using CFFTP to put .jpg 
|files on another
|server.  If I manually send the files from the server, they 
|are fine.  But
|with CF and CFFTP, they are sent, but they contain no data.
|Jeff

Why not try CFFILE
I use it for exactly the same purpose.
cffile action="UPLOAD"
filefield="Filename"
destination="D:\INETPUB\WWWROOT\file.gif"
accept="image/gif"
nameconflict="MakeUnique"

This works to send a single file up.
With CFFTP check to see if the proxy server settings are okay, a proxy
server can stomp an upload.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Please help! CFFTP and empty file.

2000-07-12 Thread Anthony Geoghegan

|Hello,
|I am using CFFTP to send files from one CF server to another 
|CF server.  =
|The files get sent okay, but they contain no data.  They are all zero =
|bytes.

Hi Jeff,
What kind of name contention scheme are you using?

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem writing to file with CFFILE

2000-07-11 Thread Anthony Geoghegan



|CFSET Data = "lt;"  "?xml version="  "quot;"  "1.0"  
|"quot;"  "
|encoding="  "quot;"  "utf-8"  "quot;"  " ?"  "gt;"

Hi Mark try using CHR codes instead of html codes.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF 4.01 Keeps Crashing

2000-07-11 Thread Anthony Geoghegan

Hi TIA,

|ColdFusion 4.01 has started crashing on my development machine several 
|times a day, producing the following message:

This commonly happens after loading and unloading several different pieces
of software on a machine, after a while.

|
|CFSERVER caused an invalid page fault in module MSRD3X40.DLL
|

An invalid page fault is the system reporting a memory paging fault.  This
is usually down to two basic problems.

Software: Wipe the machine and start from scratch.

Hardware: A new/broken device is faulty check software first if software
doesn't fix it then you can assume it's hardware.
Check everything indiviually replacing each component until it goes
away.

Both of these solutions are quite extreme but from the thousands of
repairs/installations I've done it will save time in the long run.  Trying
to chase down a single bug in the OS can be a nightmare.

|I reinstalled CF but that didn't solve the problem.  Can 

It sounds as though the OS itself is corrupt.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: How to set a future date?

2000-07-06 Thread Anthony Geoghegan

|
|Is there a way to fill in a future date in a column of
|a table? 


Use the dateadd function with the now() fuction as an argument to specify a
future date
ex.:
2 weeks from today:
#DateAdd("d","14",Now())#
make sure the number of "days" is in quotes.

Regards,
Anthony Geoghegan.
Lead Developer,
IFTN 
www.wow.ie
mailto:[EMAIL PROTECTED]
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Verity Problems HELP needed

2000-07-03 Thread Anthony Geoghegan

|I have a table with thousands of names in it
|and searching for the letter "s" will come up with no results, 
|or the letter
|"d" will come up with say 2. I should be getting hundreds of 
|hits for these
|searches.


Dont forget to use the wildcard * in your criteria if you wish partial
keyword type searches.

Regards,
Anthony Geoghegan,
Lead developer,
IFTN
www.wow.ie
mailto:[EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Problem Displaying a 2D array.

2000-07-03 Thread Anthony Geoghegan


|CFLOOP INDEX="x" FROM="1" TO="#ArrayLen(addresses)#"
|CFOUTPUT#addresses[#x#][1]#/CFOUTPUT  
|/CFLOOP

Hi Jeff,
Use this instead:

CFLOOP INDEX="x" FROM="1" TO="ArrayLen(addresses)"
    CFOUTPUT#addresses[x][1]#/CFOUTPUT  
/CFLOOP

Regards,
Anthony Geoghegan,
Lead Developer,
IFTN
www.wow.ie
mailto:[EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF XML ?

2000-06-28 Thread Anthony Geoghegan

WDDX is the facility provided by CF in version 4.5 onwards
Regards,
Anthony Geoghegan
Lead Developer,
IFTN
www.wow.ie

Original Message-
From: Akbar [mailto:[EMAIL PROTECTED]]
Sent: 28 June 2000 11:37
To: CF Talk (E-mail)
Subject: CF  XML ?


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

hello all,

forgive me if i sound too naive. i have been programming in CF from
the past 1 yr and recently i am into XML. it feels good whenever i
read wat all XML can do and solve all those problems which we are not
aware of and all that stuff.

but when i get down to basics, i am unable to connect XML and CF. i
mean, i know that CF *somehow* supports XML. but i am not aware how
well and in wat way. i tried to find an answer at allaire site but
wat i got is a bunch of links to XML sites which were of not much
help. i tried to find some site which would describe the link between
XML and CF, but i couldnt get. may be i am not aware of it.

so can anyone explain or provide me links where all my Q's would be
answered?? to make it little bit more easy i would like to give an
example.

i have a XML file and which i am using as a part of EDI. and this
file i upload into the site. wat i want is that CF should be able to
parse this XML file and insert the data from the document to the SQL
DB. this is a simple example i was trying. does CF has its own
parser?? or do i have to depend on Java??

i have 1 more Q. in all this big picture. where does WDDX fit into??

i hope u ppl wont mind my long winded mail, bcoz i am just learning
now.

thanx in advance

akbar

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Running Cf under a user account

2000-06-28 Thread Anthony Geoghegan

How many user accounts do you think will be used a fixed amount or a
variable amount etc.?
Regards,
Anthony Geoghegan
Lead Developer,
IFTN
www.wow.ie

-Original Message-
From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: 28 June 2000 12:12
To: [EMAIL PROTECTED]
Subject: Re: Running Cf under a user account


What do you mean ???

 How many accounts have you got?



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Running Cf under a user account

2000-06-28 Thread Anthony Geoghegan

You said:"I'm having a problem running CF under a user account" by this I
assume you mean a DB server user account.  If so how many different DB
server accounts are you using?  Lets assume it's just the one.  You have to
check that the CF administrator has created a datasource entry for this DB
server using the username password etc.
The administrator verifies each datasource.  If it successfully verifies the
datasource you're laughing.  If not (it can be a bit buggy and repeated
attempts can be needed) you wont get diddly.
Regards,
Anthony Geoghegan
Lead Developer,
IFTN
www.wow.ie

|-Original Message-----
|From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]]
|Sent: 28 June 2000 11:56
|To: [EMAIL PROTECTED]
|Subject: RE: Running Cf under a user account
|
|
|Hi Justy,
|How many accounts have you got?
|Regards,
|Anthony Geoghegan
|Lead Developer,
|IFTN
|www.wow.ie
|
|-Original Message-
|From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
|Sent: 28 June 2000 11:42
|To: [cftalk]
|Subject: Running Cf under a user account
|
|
|Hi Everybody,
|
|I'm having a problem running CF under a user account,it works fine
|except for ODBC connections.
|I've followed Kb Article 11859 but with no luck ... any ideas ???
|
|~Justin
|
|
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Double Quotes in String Variable? Is it possible?

2000-06-28 Thread Anthony Geoghegan

USE #CHR(34)# instead of quotes
Regards,
Anthony Geoghegan,
Lead Developer,
IFTN
www.wow.ie

|-Original Message-
|From: Joshua Starr [mailto:[EMAIL PROTECTED]]
|Sent: 28 June 2000 16:40
|To: [EMAIL PROTECTED]
|Subject: Double Quotes in String Variable? Is it possible?
|
|
|All,
|  We may have visited this before, but is there a way to 
|include a double
|quote (") or a series of them in a string variable? I am 
|trying to output a
|string using CFHTMLHEAD and would prefer to use double quotes 
|instead of
|single quotes around my parameter values to be compatible with XHTML.
|
|  Thanks in advance!
|
|
|Joshua P Starr
|President  Creative Director, Ælana
|Evenings (719) 268-1588  Day (719) 310-3030
|Email: [EMAIL PROTECTED]
|
|Please visit us on the web at http://www.aelana.com
|or contact me on AOL Instant Messenger at AelanaWeb
|
|
|---
|---
|Archives: http://www.eGroups.com/list/cf-talk
|To Unsubscribe visit 
|http://www.houseoffusion.com/index.cfm?|sidebar=listsbody=lists
|/cf_talk or send a message to 
|[EMAIL PROTECTED] with 'unsubscribe' in the body.
|
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFML in a Object Orientated Style

2000-06-27 Thread Anthony Geoghegan

Colod fusion doesn't lend itself well to object orientation (as user
definable functions just about don't exist).  However I have found the
Fusebox system to be the best for a large application (or series of
fuseactions).  It is a little impractical at times, however, to implement it
word for word.

Regards, Ant.
Lead Developer.
IFTN
www.wow.ie


-Original Message-
From: Ben Lowndes @ CW [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2000 09:27
To: [EMAIL PROTECTED]
Subject: RE: CFML in a Object Orientated Style


You are probably talking about cfobbjects: http://www.cfobjects.com
Also worth looking at is Fusebox: http://www.fusebox.org

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: NULL using it in CF

2000-06-27 Thread Anthony Geoghegan

This works fine except when empty string values are also present as data in
the column (field).  The SQL ISNULL() function should help resolve this
issue if you are experiencing this problem (assuming you are using SQL ;-) )
Regards,
Anthony Geoghegan,
IFTN
Lead developer
www.wow.ie

-Original Message-
From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2000 12:24
To: [EMAIL PROTECTED]
Subject: Re: NULL using it in CF


Use


CFIF #myvariable# IS ""do something/CFIF
- Original Message -
From: Colin Robinson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 27, 2000 12:14 PM
Subject: NULL using it in CF
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: NULL using it in CF

2000-06-27 Thread Anthony Geoghegan

Sorry I was responding to what Justin had written.
(oops I thought it was included in the email I sent :-) )
Regards,
Anthony Geoghegan
Lead Developer,
IFTN
www.wow.ie

-Original Message-
From: Colin Robinson [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2000 13:15
To: [EMAIL PROTECTED]
Subject: RE: NULL using it in CF


Anthony,

What were you referring to when you say 'This works fine'

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.