RE: SQL regex select

2003-09-24 Thread Jason Lees (National Express)
Yes, in MSSQL

Select 
*
from 
myTable
where
myColumn like '[a-z]iger'

so you can build up regular expresions like that,

Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: 24 September 2003 14:27
To: CF-Talk
Subject: SQL regex select


I have an application where I want to select rows from a table where the
rows match according to a simple regex.  For example, say I have the word
"tiger" - I would want to select rows with values like:

t*
*
?
tiger
t??er

Is this possible?

Thanks,

Howie

~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138272
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: re"

2003-09-18 Thread Jason Lees (National Express)
You dont say what DB to use, but with MSSQL I suppose you could have a look
up of invalid entries in another SQL table so that your  query reads


INSERT INTO strfields
(
var,
destination
)
VALUES
(
,

)
where   
 not in
(select Prohibited from
ProhibitedTable)


Table ProhibitedTable is defined as 

create table [ProhibitedTable {
WordID int not null]
Prohibited varchar (25)
}

Then if you make WordId a Prinary key, and auto increment this should solve
the problem.

It may need some fine tuning but should work. this also save you having to
hard code each prohibited word, and also will allow in definate expansion,



Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: 18 September 2003 15:36
To: CF-Talk
Subject: re" 


INSERT INTO strfields
(
var,
destination
)
VALUES
(
,

)









~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137494
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: [OT] ShittyCode.Com (Launched new site last night, feedback p lease!)

2003-09-11 Thread Jason Lees (National Express)
Just remember - one mans cr*p is anothers gold

I have to agree with the comments made by Micheal and Calvin. 

As for some of the examples, they are not so much sh*t code, more like lack
of knowledge, besides we've all dont things like  espcially
when switching between several development languages & environments.

PS - as for sh*t the auto page reload is totally superflous, good job your
not on a slow dialup connection when viewing this site as you'd nver get to
see the page

Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: 11 September 2003 09:26
To: CF-Talk
Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback
please!)


I agree with Michael completely.

And in fact, this isn't something I need to let be appearing in my browser
or email client at work, we do have clients walk through our building fairly
often.

It's flat out unprofessional sounding and doesn't belong in this forum.

- Calvni

- Original Message - 
From: "Michael Dinowitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 4:00 PM
Subject: Re: [OT] ShittyCode.Com (Launched new site last night, feedback
please!)


> Well, let me see:
> 1. I think the name just sucks. If your trying to make a positive
statement of
> proper code use, a name of that sort will turn off many of those who need
such a
> statement.
> 2. Site reviews and such are something for CF-OT or CF-Community. Talking
about
> good code concepts would fit here, but that's not what your doing.
> 3. You can't run such a site without constant editorial review.
> 4. Your examples are rather off. Take the one about pound signs. The usage
of
> them are subjective in the case you gave and the use of queryname. in the
CFIF
> is not representative of the initial example (which would have to be
inside a
> CFOUTPUT or CFLOOP to access the query object. I could go on, but the
point is
> made.
> Bad code is subjective in many cases. Indentation, use of pounds, use of
> CFSCRIPT vs. CFTags, etc. are all based on personal use. If I use
> function test()
> {
> return 1
> }
> and someone else says that
> function test(){
> return 1
> }
> is the right way, we're not talking bad code, we're talking code religion.
> 5. Religion is NOT ON TOPIC for this list.
>
> > Last night, I launched a new site, it can be seen at:
> >
> > http://www.shittycode.com
> >
> > I wanted to see if I could get some feedback on the site, the concept,
and
> maybe even the name! :)
> >
> > Thanks,
> > Pablo Varando
> > http://www.easycfm.com
> >
> >
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Anyone going to MAX in November?

2003-09-09 Thread Jason Lees (National Express)
anyone have any details on this please, As I'd be interested to go.

Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Cathy Taylor [mailto:[EMAIL PROTECTED]
Sent: 09 September 2003 15:09
To: CF-Talk
Subject: Anyone going to MAX in November?


I'm probably going too, though it sure is far away (when will they have it
in DC again??). I'm waiting for my time to be approved by my client (I'll
pony up the rest). I'm also hoping there's snow so I can fit in some skiing
without the fam along (one advantage to traveling to the conference - a week
ALONE in a hotel!! Woohoo!). 

Cathy

>I'll probably be going. I'm really not excited about the location, but the
>new MX2004 was pretty much the deciding factor for me.
>
>-Kevin
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: sql question

2003-08-19 Thread Jason Lees (National Express)
I think this should work, 

select
Id,count(Id)
from
mytable
group by
Id
having 
count(id)>1

It will also show you how many of each Id's you have, you can naturally add
a where clause if you want.

Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
Sent: 19 August 2003 15:10
To: CF-Talk
Subject: sql question


i would like to write a sql query that can find where a certain 'id' has a
duplicate. i don't want to see the ids where there is only one instance of
it. (for example, show me 20010001 if there are 2 of them in the db, and
don't show me 20010002 if there is only one of them in the db). anyone have
any suggestions? thanks.


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Auto generate form fields problem...

2003-07-31 Thread Jason Lees (National Express)
I believe this may work, as I do somethink simular with parsing through
dynamic Form variables.




Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Bruce H. Beinert [mailto:[EMAIL PROTECTED]
Sent: 31 July 2003 08:52
To: CF-Talk
Subject: Auto generate form fields problem...


Hi,

I am trying to auto generate form fields and can't seem to get the last part
right. I want to set the value of the input box as the variable but can't
figure out how to do it... Obviously what happens is the value is set to
"call_letters_1" instead what I want which is #call_letters_1#

I have tried a bunch of different things none of which work and just throw
errors.

Any ideas??? Thanks!













#i#.








--
Bruce H. Beinert
p.808-637-0727<>m.917-627-4035

Web Development and Consulting:
http://www.siliconmaui.com

Weblog:
http://www.bruceandwende.com





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX & .Net Remoting

2003-07-29 Thread Jason Lees (National Express)
All,

Has anyone used .Net remoting with CFMX, and is it possible?

If you have any experience can you pass on any helpfull tips for accessing
and creating the objects

TIA

Jason Lees
Development Team Leader
National Express.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: numbers too big

2003-06-13 Thread Jason Lees (National Express)
No specific proof, but thinking about it logially

International dialing allow 4 for Expansion (there aer some 3 digit codes),
For Regional Exchanges allow 4 digits ( Regions), Local Exchanges allow
4 digits, that leaves you five digits spare for individual phones.

That would give you 
 countries,
 Regions/Country,
 Local Exchanges
9 Phones/Exchange.

Therefore you could use a bigint (64 bit number) to hold the data.

Personally I think these numbers allow for quite a large range.

Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 15:57
To: CF-Talk
Subject: Re: numbers too big


Can you confirm this? I would need hard proof.

I appreciate the insight however.

Mike

- Original Message - 
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 13, 2003 10:48 AM
Subject: RE: numbers too big


> Why 30 digits?, I'm not aware of any numbers of greater than 20 digits,
even
> with the International diaing code.
>
> Jason Lees
> Development Team Leader
> National Express.
>
>
> -Original Message-
> From: Michael Tangorre [mailto:[EMAIL PROTECTED]
> Sent: 13 June 2003 15:25
> To: CF-Talk
> Subject: numbers too big
>
>
> I have some really large number ranges that I need to store in a SQL
Server
> 2K DB.
>
> The numbers are of the following size:
>
> range start
> 00
>
> range end
> 99
>
> That was one generic example. Basically the number represents a phone
number
> range and I have a range for each country in the world that has telephone
> service. What would be the best way to store it these ranges so that I
can
> run a query that says, select country name where #phoneNumber#  is within
> the range.
>
> I tried inporting the values in as bigints.. no dice, by the way this info
> is coming in from an excel sheet.
>
>
> Thanks,
>
> Michael Tangorre
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: numbers too big

2003-06-13 Thread Jason Lees (National Express)
Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, even
with the International diaing code.

Jason Lees
Development Team Leader
National Express.


-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 15:25
To: CF-Talk
Subject: numbers too big


I have some really large number ranges that I need to store in a SQL Server
2K DB.

The numbers are of the following size:

range start
00

range end
99

That was one generic example. Basically the number represents a phone number
range and I have a range for each country in the world that has telephone
service. What would be the best way to store it these ranges so that I  can
run a query that says, select country name where #phoneNumber#  is within
the range.

I tried inporting the values in as bigints.. no dice, by the way this info
is coming in from an excel sheet.


Thanks,

Michael Tangorre

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: TSQL Script to replicate a db?

2003-03-18 Thread Jason Lees (National Express)
You could use the Scripting wizard in the Enterprise manager.

To do this Select the DB right click, and select Script DB, this gives you
the necessary wizard to get everything, SP's, tables, Indexes etc.

Jason Lees
Development Team Leader
National Express Systems.


-Original Message-
From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]
Sent: 18 March 2003 14:47
To: CF-Talk
Subject: TSQL Script to replicate a db?


Hi All,

I have a SQL2K db in a shared hosting environment at CFDynamics.com.
Each time I need to duplicate the db (intranet db) for my clients I just use
the export tool and export it to another client's db.  The problem is that
each
time I do this I have to go back and set up the autonumber fields on every
single
table which takes a long time.

Does anyone know of a way to take my existing db and use a wizard to create
either a stored procedure or a bunch of sql statements that will recreate
all of the
tables and relationships of my db?

Thanks,
Jason


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



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

2003-03-18 Thread Jason Lees (National Express)
I didnt get it from anywhere, It was part of the installation.  What type of
install did you do? 

>From what I can remember theres three option, Client Tools only, DB & Client
Tools, or DB Only.

If you didnt install the tools option that might be the reason.

Jason Lees
Development Team Leader
National Express Systems.


-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: 18 March 2003 09:07
To: CF-Talk
Subject: Re: MSDE on Office XP CD - where is Enterprise Manager?


Thanks Jason.

So - stupid question - that means you have a file called

"C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise
Manager.MSC" ?

 I don't. Where did you get it from?

Nick




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



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

2003-03-18 Thread Jason Lees (National Express)
This is the Short cut I use to start EM 

C:\WINNT\SYSTEM32\MMC.EXE /s "C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"



Jason Lees
Development Team Leader
National Express Systems.


-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: 18 March 2003 08:44
To: CF-Talk
Subject: Re: MSDE on Office XP CD - where is Enterprise Manager?


> It had one on Windows 98.

Well, let me rephrase that. I have MSDE on my W98 machine and also EM, and
if EM isn't part of MSDE where did I get it I wonder... don't remember.

Using isql for development is fine for a manly man like me ;-) but also I
wanted to use EM to administer a remote SQL Server DB, which would be rather
painful with isql, if indeed it's possible. What should I use instead? Any
suggestions?

Nick








~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Using createUUID()

2003-03-17 Thread Jason Lees (National Express)
Heres a URL on how the UUID is defined

http://www.dsps.net/uuid.html (the Colour coding leaves something to be
desired but...)

Just glancing at the document suggests that this will be a unique number, as
it uses the Mac address of the PC to generate it.

there are 3.4028236692093846346337460743177e+38 combinations (2^128). 


Jason Lees
Development Team Leader
National Express Systems.


-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:51
To: CF-Talk
Subject: RE: Using createUUID()


Ignore my last post...ASCII has more than 36 characters...the point
still holds though.

-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:48
To: CF-Talk
Subject: RE: Using createUUID()

If you only use 4 characters then there are only roughly (10+26) to the
power of 4 = 1679616 different combinations... this is a relatively low
number which may or may not be considered unique enough for your
purposes. 

With only 100,000 records you already have nearly a 6% chance of a
collision.

André

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 17 March 2003 13:34
To: CF-Talk
Subject: RE: Using createUUID()

not sure what the odds could be : its not 1 in a thousand, I see your
point,
but in this instance, just include more chars or add your own rand
function...

though, Rand again but definition is not 'unique', there is a chance you
could get the same ID.

N

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()


but not the first four...the whole uuid in and of itself, would be,
however, you could conceivably
get the same striking everything but the first four

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:28 AM
To: CF-Talk
Subject: RE: Using createUUID()


erm... I would say that they are unique.  No UUID is the same by its
very
definition; thats the point...  


The mechanism used to guarantee that UUIDs are Unique is through
combinations of hardware addresses, time stamps and random seeds. 

No two comps can generate the same UUID.

"AFAIK"


-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:27
To: CF-Talk
Subject: RE: Using createUUID()


I wouldn't do that , first 4 chars of createuuid() are not unique. If
you cat that with something else than _maybe_ you are doing a bit
better. 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:18 AM
To: CF-Talk
Subject: RE: Using createUUID()


if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E-
etc...) then you may be able to use newid() within mySQL, though I am
not sure that it supports it.

In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
4 chars of a CF generated ID.

HTH

Neil

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:04
To: CF-Talk
Subject: RE: Using createUUID()


Use the current date and add random numbers to the end:

03172003nn where 'nnn' are the random numbers.

To be honest with you... UUID is the way to go though, but this should
work.

#DateFormat(now(),"mmdd")##Rand()##Rand()#




-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:56 AM
To: CF-Talk
Subject: Using createUUID()


Hi,

I need to generate a unique ID for every form I submit. The createUUID #
generated is just too long for my needs. My ID only needs to be 10
characters in length. Something like:

CT-0001001

I'm using MySQL. Can I have mysql generate the unique ID? How could I do
this with CF?




---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---












~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Using createUUID()

2003-03-17 Thread Jason Lees (National Express)
The point of a UUID is not to use the first four characters, but to use the
whole ID


Jason Lees
Development Team Leader
National Express Systems.


-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()


Ok , run Mid(CreateUUID(),1,4) a few times and see what you get.

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:28 AM
To: CF-Talk
Subject: RE: Using createUUID()


erm... I would say that they are unique.  No UUID is the same by its
very definition; thats the point...  


The mechanism used to guarantee that UUIDs are Unique is through
combinations of hardware addresses, time stamps and random seeds. 

No two comps can generate the same UUID.

"AFAIK"


-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:27
To: CF-Talk
Subject: RE: Using createUUID()


I wouldn't do that , first 4 chars of createuuid() are not unique. If
you cat that with something else than _maybe_ you are doing a bit
better. 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Monday, March 17, 2003 8:18 AM
To: CF-Talk
Subject: RE: Using createUUID()


if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E-
etc...) then you may be able to use newid() within mySQL, though I am
not sure that it supports it.

In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
4 chars of a CF generated ID.

HTH

Neil

-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:04
To: CF-Talk
Subject: RE: Using createUUID()


Use the current date and add random numbers to the end:

03172003nn where 'nnn' are the random numbers.

To be honest with you... UUID is the way to go though, but this should
work.

#DateFormat(now(),"mmdd")##Rand()##Rand()#




-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:56 AM
To: CF-Talk
Subject: Using createUUID()


Hi,

I need to generate a unique ID for every form I submit. The createUUID #
generated is just too long for my needs. My ID only needs to be 10
characters in length. Something like:

CT-0001001

I'm using MySQL. Can I have mysql generate the unique ID? How could I do
this with CF?




---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---









~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: JS problem

2003-03-06 Thread Jason Lees (National Express)
Can't you just use 

if ((isNan(myField.value)) || myField.Value==0){
window.alert("- The Quantity you entered is invalid");
myField.Focus();
return false;
}
else
return true;


Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: 06 March 2003 14:58
To: CF-Talk
Subject: JS problem


To clarify my earlier post.  This is what I've been trying to no avail

function CheckCartQty(myField) {
var ErrMsg = "";

// Validate that the Quantities in the Cart are
numbers
if ((isNan(document.CartForm.myField.value)) ||
(document.CartForm.myField.value == 0)) {
ErrMsg = ErrMsg + "- The Quantity you
entered is invalid\n";
}

if (ErrMsg.length > 0) {
window.alert(ErrMsg);
document.CartForm.myField.focus();

return false;
} else {
return true;
}
}   


RE:

I am calling a function onBlur of a text field... to validate that the
text entered is a number...  of course... this list of text fields is
being generated dynamically... (shopping cart quantities). If I pass a
parameter, like so, CheckQty(someFieldName) how do I check that in the
function... Like so, document.CartForm.PARAMETER.value ,it wont let me
use the name of the parameter... do I have to build a string or
something?

Emmet


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX 100% utilization

2003-03-05 Thread Jason Lees (National Express)
Sorry, we're a bit rushed switching back to the old production server.

webserver - IIS 
DB - MSSQL 2K, SP3 with the Generic Windows ODBC drivers.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]
Sent: 05 March 2003 10:24
To: CF-Talk
Subject: Re: CFMX 100% utilization


On Wednesday, Mar 5, 2003, at 02:02 US/Pacific, Jason Lees (National 
Express) wrote:
> We've just moved a development website over to the production server.
>
> The problem is that after about 2 hours, the production server just 
> went
> keeled over with 100% CPU. This didnt happen on the development server

What web server / version? What database / version / drivers?

Sean A Corfield -- http://www.corfield.org/blog/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX 100% utilization

2003-03-05 Thread Jason Lees (National Express)
All,

We've just moved a development website over to the production server.  

The problem is that after about 2 hours, the production server just went
keeled over with 100% CPU. This didnt happen on the development server 

The production server win 2K, twin Xeon processor, with hyper threading.

Any one any Ideas?

TIA.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Strange characters after MX upgrade

2003-02-28 Thread Jason Lees (National Express)
Thats what I would assume.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Phillip Cave [mailto:[EMAIL PROTECTED]
Sent: 28 February 2003 14:52
To: CF-Talk
Subject: RE: Strange characters after MX upgrade


Thanks. It's the first one under SQL Server-Specific Issues. But, doesn't
this mean it's supposed to be fixed in updater 2?

Phillip

-Original Message-----
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED] 
Sent: Friday, February 28, 2003 9:35 AM
To: CF-Talk
Subject: RE: Strange characters after MX upgrade


There are several prbolems with CFMX and DB's, the simplest way is for you
to check the following URL for a list of Known Issues,

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx
_updater.html#newissues



Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Phillip Cave [mailto:[EMAIL PROTECTED]
Sent: 28 February 2003 14:30
To: CF-Talk
Subject: Strange characters after MX upgrade


Has anyone experienced problems with inserting and updating nText fields
after upgrading to CFMX. We have a system that worked fine until the
upgrade. Now the system will sometimes (and I mean randomly) insert chr(25)
'end of medium' characters where apostrophes are supposed to be. The queries
are quite simple.

Insert or update .

Eweb v2.6.0.6 is used for the form control by the way.

Before and after examples are below (notice It's and I'm):

Before:


Thank you, Mr. President, and Mr. Vice President, for inviting me here
today. It's good to know that you both are working hard and using your
leadership to strengthen Social Security. 

I'm from Oklahoma City, and am currently a Junior at Howard, an historically
black university here in Washington, DC.


After:

Thank you, Mr. President, and Mr. Vice President, for inviting me here
today. Its good to know that you both are working hard and using your
leadership to strengthen Social Security. 

Im from Oklahoma City, and am currently a Junior at Howard, an historically
black university here in Washington, DC.

Thanks,

Phillip


Phillip Cave
ColdFusion Developer
Carol/Trevelyan Strategy Group 
202.448.5212




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Strange characters after MX upgrade

2003-02-28 Thread Jason Lees (National Express)
There are several prbolems with CFMX and DB's, the simplest way is for you
to check the following URL for a list of Known Issues,

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx
_updater.html#newissues



Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Phillip Cave [mailto:[EMAIL PROTECTED]
Sent: 28 February 2003 14:30
To: CF-Talk
Subject: Strange characters after MX upgrade


Has anyone experienced problems with inserting and updating nText fields
after upgrading to CFMX. We have a system that worked fine until the
upgrade. Now the system will sometimes (and I mean randomly) insert chr(25)
'end of medium' characters where apostrophes are supposed to be. The queries
are quite simple.

Insert or update .

Eweb v2.6.0.6 is used for the form control by the way.

Before and after examples are below (notice It's and I'm):

Before:


Thank you, Mr. President, and Mr. Vice President, for inviting me here
today. It's good to know that you both are working hard and using your
leadership to strengthen Social Security. 

I'm from Oklahoma City, and am currently a Junior at Howard, an historically
black university here in Washington, DC.


After:

Thank you, Mr. President, and Mr. Vice President, for inviting me here
today. Its good to know that you both are working hard and using your
leadership to strengthen Social Security. 

Im from Oklahoma City, and am currently a Junior at Howard, an historically
black university here in Washington, DC.

Thanks,

Phillip


Phillip Cave
ColdFusion Developer
Carol/Trevelyan Strategy Group 
202.448.5212


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX behaving Strangely

2003-02-28 Thread Jason Lees (National Express)
A couple of days ago I got this error (unable to load library null). It's
when we try to do the 1 second waits when we are waiting for a Smartnet
reply - we call a C++ cfx library functon. I had to resurrect cfadmin
support on webserver4 (which had been lost for no known reason). I reset
everything, reimported the library, stopped and restarted CF and all was
then fine. 
One thing to note, though, is that I've yet to stop CF MX cleanly using
'services' - it has always come up with an error 1053 - the service did not
respond in a timely fashion. However, it seems to restart ok after a 1053. 
I just got the null library error again when trying to run enq3. This time
cfadmin was fine; I checked the cfx settings, everything was fine. I stopped
CF (got error 1053) restarted it and now enq3 works. Conclusion, CF MX was
stuffed and had corrupted the link to this permanently loaded library. I'm
not aware of any peculiar errors happening recently. We're getting plenty of
syntax errors and such, but nothing low level (I've checked the logs) that I
can see. 
One other worrying feature is something I've not noticed when I use IE 5.0,
and I'm going backwards and forwards through enquiries and bookings like a
demon. Quite often - 2 or 3 times a day - I will get an IE lock and it
almost always seems to be when I click on 'back' (browser button, not our
back button). I deliberately left one like this overnight, and it did not
recover. Task manager reports it as 'not responding' and I have to end task.

If anyone has any time to spare I'd be grateful if they could check out the
macromedia website and see if there are any known CF MX issues and any
issued patches. 
Many Thanks in Advance

PS - we're using OS - Win2k Server, 


Jason Lees
Development Team Leader
National Express Coaches Ltd.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: BlueDragon for .NET (was: CF - PHP comparisons?)

2003-02-14 Thread Jason Lees (National Express)
I was thinking the same thing. It'll save having .Net Webservices etc, I
also hope it might Open up full COM+ transactions etc.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2003 15:32
To: CF-Talk
Subject: RE: BlueDragon for .NET (was: CF - PHP comparisons?)


Wow - I'm looking forward to seeing it.  I would love to have some of
the classes I use in .NET available to CFML.  Think about the ease of
report generation using Crystal Reports.NET with BD.NET. Easy report
generation was a major factor in switching to .NET.  I love to use CFML
as well, so this is the best of both worlds.

Will I be able to write BD.NET in Visual Studio (with intellisense, help
files, etc.)?


Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Vince Bonfanti [mailto:[EMAIL PROTECTED]] 
Sent: Friday, February 14, 2003 9:55 AM
To: CF-Talk
Subject: RE: BlueDragon for .NET (was: CF - PHP comparisons?)

BlueDragon for .NET is coded to the standard .NET Framework APIs (just
as
BlueDragon for J2EE is coded to standard Java APIs). It's not a
re-implementation of the .NET Framework (which Microsoft's patents are
intended to prevent), but requires that the .NET Framework be installed
in
order to use it (which Microsoft will like, because it means you have to
buy
Windows to run BlueDragon for .NET). So no impact on BlueDragon at all.

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com


> -Original Message-
> From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, February 14, 2003 9:40 AM
> To: CF-Talk
> Subject: RE: CF - PHP comparisons?
> 
> 
> Vince,
> 
> Have you had opportunity yet to review/consider the 
> implications of Microsoft's patent efforts on .NET and how 
> they will impact BlueDragon for .NET? Just curious what your 
> take on all that is.
> 
> Ken
>



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: CF - PHP comparisons?

2003-02-14 Thread Jason Lees (National Express)
Where can I find out more about Bluedragon?

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Vince Bonfanti [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2003 14:20
To: CF-Talk
Subject: RE: CF - PHP comparisons?


Hi Mike,

I tend to agree with your comments regarding the "richness" of PHP. If you
do a straight comparison of PHP and CFML's built-in functions then they seem
pretty equal. However, one thing that's changed in the CFML world with the
introduction of CFMX and BlueDragon is that you now have seamless access to
the full set of Java APIs from CFML. With the release of BlueDragon for .NET
you'll similarly have seamless access to the full .NET Framework (APIs) from
within CFML.

In effect, the set of CFML functions is being expanded to include all of the
Java APIs or all of the .NET APIs, depending on which platform you prefer.

It seems to me that since PHP is not built on either of the two major
"platform" technologies (Java or .NET), it's "richness" is going to suffer
in comparison as CFML developers learn to take advantage of the integration
with Java and .NET.

Also, look at the way CFMX leveraged the Java platform to implement web
services support (via Apache Axis). PHP is not going to be able to take
advantage of the underlying platform technology the way CFMX did; instead
they're going to have to implement their own solution "from scratch". It
seems to me that this will be a major disadvantage of PHP.

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com


> -Original Message-
> From: Mike Alberts [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, February 14, 2003 3:33 AM
> To: CF-Talk
> Subject: CF - PHP comparisons?
> 
> 
> Since I develop with both CF and php, I guess I'll add my .02...
> 
> Also respectfully to you Dave, this is NOT a terrible 
> comparison. With the exception of the part about user defined 
> functions, the comparison seems pretty valid to me, even 
> though it is quite old.
> 
> In addition, php has made great strides in the last couple of 
> years: There are at least 3 very good IDE's for php (Zend 
> Studio, Nusphere PhpEd and Activestate Komodo), as well as 
> some decent simple code editors (php coder/Maguma Studio, etc.
> 
> Zend has done some other great things for php, like code 
> encryption, acceleration, caching, etc. Granted these 
> products are not free, but their new 'Small Business Program' 
> lets you get all of that stuff with the IDE for a $295 
> lifetime payment. This is an absolute bargain.
> 
> Now I still love the CF language, and it's what I prefer to 
> code in, for its ability to let me get projects done quickly. 
> But over the years of using CF I've developed my own 
> 'methodology', that implements the Application Framework, as 
> well as some other ways of doing things that are sort of like 
> Fusebox (only simpler). I've personally found that I can use 
> this same framework in php as well, and the only thing that 
> changes is the syntax of the language. Many things in php 
> (switch/case for example) are almost identical in both 
> languages (using the CF version with cfscript tags of course).
> 
> And don't think that php isn't 'rich'. More than once I've 
> sat down to write a function in php and realized part way 
> through that there was already a built in function to 
> accomplish the task.
> 
> To me, it all boils down to what Sean said  both 
> languages have their strengths and weaknesses. Use the right 
> tool for the task at hand. I'm not even going to comment on 
> ASP (ugh), but php is a fine tool in its own right and even 
> though it does take longer to develop with than CF (for me), 
> it still allows me to do some cool stuff for clients, which 
> makes them (and me) happy. 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Proper SQL statements

2003-02-06 Thread Jason Lees (National Express)
Use a strored procedure to do both jobs, 

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: 06 February 2003 15:23
To: CF-Talk
Subject: Proper SQL statements


Is there a better more efficient way of writing these 2 queries such as
combining them into a single query?
I will eventually convert it into a stored procedure.


SELECT COUNT(*) AS RecsAvailable 
FROM tbl_reports_FlapList


DELETE 
FROM tbl_reports_FlapList
WHERE FlapListID IN
(SELECT FlapListID FROM tbl_reports_FlapList)


Regards,
Dave Bosky
Sr. Multimedia Web Designer
Horry Telephone Cooperative, Inc. 
office: (843)369-8613
[EMAIL PROTECTED]



HTC Disclaimer:  The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited.  If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.  Thank you.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: CFMX & .NET

2003-02-05 Thread Jason Lees (National Express)
I have them both runing on the same PC, although its my main development PC.
so I dont know how it would react on a Win2k Server etc.

And I've not seen any so far. 

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Adrocknaphobia Jones [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2003 15:00
To: CF-Talk
Subject: CFMX & .NET


I know there is an enormous anti-MS sentiment here, but I'm curious is
anyone as installed the .NET framework on the same box running CFMX. If
so, how was performance affected? I've always done one or the other, but
I'm thinking of combining them both, although I can foresee conflict out
the arse. Any thoughts? War stories? Recommendations?
 
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: CF Logins and Users Logged In

2003-02-04 Thread Jason Lees (National Express)
To update the on login DB I think the SQL is 

update 
usersetup
set 
logged_in=1
where 
Username = '#Session.Username#'

and on logout 

update 
usersetup
set 
logged_in=0
where 
Username = '#Session.Username#'

This assumes that you dont have users with the same username.

You may also want to investigate putting it into a stored procedure to
reduce the CF load, but have a chat with your DBA about it.


Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2003 09:30
To: CF-Talk
Subject: Re: CF Logins and Users Logged In


Hi

Thanks for the excellent replies

I have a log off feature which is a little piece of javascript 


function confirmDelete(aURL) {
 if (confirm("W A R N I N G !  Are you sure you wish to log off")){
  document.location=aURL;
 }
} 



Log Out


which sends the user to logoff.cfm. Contained in logoff.cfm is the following
CF Code




Which ends their session.

Both ideas seem very usefull, just would like to implement the most
consistent and efficient method, so I would appreciate your views on the
best example to use?

Using Jasons example I would add another field to my Oracle usertable called
logged_in.

However how would I set that field when the user logs in

Any code examples of how to achieve the above ??




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: CF Logins and Users Logged In

2003-02-04 Thread Jason Lees (National Express)
Its fairly straight forward, the problem is when they dont log out cleanly,
The simplist way is to have another column in your user table called
Logged_In and set it to 1 when logged on, and 0 on a clean logout

To find the count simply run the following script.

Select 
count(Logged_in) 
from 
usersetup
where 
logged_in=1

I think you might be able to use Jscript to get round the problem of a messy
application closure (ie closing the browser), but I'm not sure.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2003 08:49
To: CF-Talk
Subject: CF Logins and Users Logged In


Hi

Does anybody on the list know how I can implement a feature on my Intranet
site thats shows how many users are currently logged.

I.E. There are currently 5 users on the site.

Any ideas on how to implement this ? This is what I have at the moment
..

The user enters their username/password to log into the Intranet - this
checks against the database below

 


SELECT *

FROM usersetup

WHERE Username = '#form.Username#' AND Password = '#form.Password#'



 

If correct session variables are created and you enter the homepage.

 












~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Webservices in CFMX

2003-01-30 Thread Jason Lees (National Express)
The way we do the invoke is inside a cfloop, as we first query a Database to
get locations to search through, then loop through the record set for Each
Pair of locations/for a set of given days.

At no point is the page refreshed, could this be the problem with CF?

The reason we do this is so that we can build up a data base of operational
days between certain locations so that we can display the results to the
customer to find the day/s when a particular route is in operation.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2003 17:07
To: CF-Talk
Subject: Re: Webservices in CFMX


On Wednesday, Jan 29, 2003, at 01:36 US/Pacific, Jason Lees (National 
Express) wrote:
> I've just been doing some load testing connecting from CFMX to an 
> Inhouse
> webservice application.  Everything is running ok until about 300
> transactions have been processed, CFMX then throws the following error

How are you actually doing the load testing? Are you creating a .cfm 
that loops over a cfinvoke webservice=... or are you doing something 
more complex?

Sean A Corfield -- http://www.corfield.org/blog/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




Webservices in CFMX

2003-01-29 Thread Jason Lees (National Express)
All,

I've just been doing some load testing connecting from CFMX to an Inhouse
webservice application.  Everything is running ok until about 300
transactions have been processed, CFMX then throws the following error

Object reference not set to an instance of an object. at
JourneySearch.JourneySearch.SingleJourneySearch(String FromLocation, String
ToLocation, String JourneyDate, String JourneyTime)

However if we connect through to the webservice using the browser through
http it works ok.

Has anyone seen this before? or got any ideas on how to solve the problem?

Jason Lees
Development Team Leader
National Express Coaches Ltd.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Book reviews

2003-01-20 Thread Jason Lees (National Express)
check out the Ben forta books published by Macromedia press (ISDN nos -
0-321-12516-9, and 0-321-12710-2], they're both quite good,

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2003 14:40
To: CF-Talk
Subject: Book reviews


Hello,

We are getting ready to migrate to CFMX and I went to a local B&N to take a
look at what's out. I was quite dissapointed, it's all the same stuff just
updated to say MX on the cover. Are there any advanced books out there?
Thanks!







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Stealing content?

2003-01-20 Thread Jason Lees (National Express)
Its called scrapping or syndication, depending on the books you read. 

to accomplish syndication, you use the  tag, However this is
technically illegal without the Website owners permission as they own legal
copyright on the material.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2003 12:38
To: CF-Talk
Subject: Stealing content?


I was talking to someone the other day about ColdFusion, and they said "Oh 
yeah, and it has that feature that allows you to steal content."  I've 
never heard of that - what feature would that be?

T


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




RE: Loop Errors

2003-01-06 Thread Jason Lees (National Express)
the simple answer about the nested  tags is whats the point? and
so the parser catches the nested  tags as a coding error.

Its like doing 


#myVar1#

#MyVar2#





Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 16:25
To: CF-Talk
Subject: Re: Loop Errors


Thanks

For the replies

Taking them in no particular order

Jason Lees said
"Well for a start you dont neet to nest the 's"

Why don't I need to nest the cfoutputs?

Jeff Garza and Mosh Teitelbaum picked up on the same point, jeff
said..

"I beleive that you have referenced the query wrong.

Try:

"

I know what you are saying however, the query is linked to the output of the
actual select shown below

Select ATA Code 
#category# 

If you look at my code you should see this..


Jerry Johnson said

"

ChapterArray#category#[#i#] = #category#;
ChapterArrayVal#category#[#i#] = "#catno# #category#";

"

why do you think I dont need this??

The code I am using is based on the code below , which works but I think
they were using two tables I am only using one table??  From this you may be
able to solve some of these problems???


---ORIGINAL--




 Untitled





SELECT a.ata_chapter, a.ata_title, b.ata_section, b.ATA_TITLE SubTitle
FROM ata_codes a, ata_sub_codes b
WHERE a.ata_chapter = b.ata_chapter
ORDER BY a.ata_chapter, b.ata_section



<!--
// For each chapter, create an array to hold the sections.
// Each chapter array will be identified by the ATA_Chapter
<cfoutput query="rsATA1" group="ATA_Chapter">
// Create the array
ChapterArray#ATA_Chapter# = new Array();
ChapterArrayVal#ATA_Chapter# = new Array();
<cfset i = 0>
// Populate the array
<cfoutput>
<cfset i = i + 1>
ChapterArray#ATA_Chapter#[#i#] = #ATA_Chapter#;
ChapterArrayVal#ATA_Chapter#[#i#] = "#ata_section# #SubTitle#";
</cfoutput>
</cfoutput>


// Function to populate the ATA_Sub_Codes for the ATA_Code selected
function PopulateATASubCode() {
// Only process the function if the first item is not selected.
var indx = document.InsertForm.ATACode.selectedIndex;
if (indx != 0) {
// Find the Chapter
var ThisChapter = document.InsertForm.ATACode[indx].value;
// Set the length of the ATA_Sub_Codes drop down equal to the length of the
Chapter's array
var len;
len = eval("ChapterArray" + ThisChapter + ".length");
document.InsertForm.ATA_SubCode.length = len;
// Put 'Select' as the first option in the SubCode drop-down
document.InsertForm.ATA_SubCode[0].value = "";
document.InsertForm.ATA_SubCode[0].text = "Select ATA Sub Code";
document.InsertForm.ATA_SubCode[0].selected = true;
// Loop through the chapter's array and populate the SubCode drop down.
for (i=1; i<len; i++) {
document.InsertForm.ATA_SubCode.value = eval("ChapterArray" + ThisChapter +
"");
document.InsertForm.ATA_SubCode.text = eval("ChapterArrayVal" + ThisChapter
+ "");
}
}
}
//-->




Requirements Database Add Requirement






 
Select ATA Code 
#ATA_Chapter# #ATA_Title# 


Select ATA Sub Code












- Original Message -
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 3:55 PM
Subject: RE: Loop Errors


> Well for a start you dont neet to nest the 's
>
>
> Jason Lees
> Development Team Leader
> National Express Coaches Ltd.
>
>
>
> -Original Message-
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
> Sent: 06 January 2003 15:50
> To: CF-Talk
> Subject: Loop Errors
>
>
> Does anybody have any ideas on why I am getting a loop error from my code
> below I cant see why this is happening, any suggestions would be most
> helpful thanks...
>
> Error Occurred While Processing Request
> Error Diagnostic Information
> Loop error
>
>
> The error occurred while processing an element with a general identifier
of
> (CFOUTPUT), occupying document position (23:1) to (23:42).
>
>
> Date/Time: Mon Jan 06 15:49:37 2003
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
> Remote Address: 121.100.25.2
>
>
>
> 
>
> 
> 
>  Untitled
> 
>
> 
> 
> 
> SELECT a.category, a.catno, a.parent_level, b.category, b.catno,
> b.parent_level
> FROM category_menu a, category_menu b
>
> WHERE a.parent_level = b.catno
>
> ORDER BY a.category, b.category
> 
> 
> 
> <!--
> // For each chapter, create an array to hold the sections.
> // Each chapter array will be identified by the ATA_Chapter
> <cfoutput query="rsATA1" group="category">
&g

RE: Loop Errors

2003-01-06 Thread Jason Lees (National Express)
Well for a start you dont neet to nest the 's


Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 15:50
To: CF-Talk
Subject: Loop Errors


Does anybody have any ideas on why I am getting a loop error from my code
below I cant see why this is happening, any suggestions would be most
helpful thanks...

Error Occurred While Processing Request
Error Diagnostic Information
Loop error


The error occurred while processing an element with a general identifier of
(CFOUTPUT), occupying document position (23:1) to (23:42).


Date/Time: Mon Jan 06 15:49:37 2003
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address: 121.100.25.2







 Untitled





SELECT a.category, a.catno, a.parent_level, b.category, b.catno,
b.parent_level
FROM category_menu a, category_menu b

WHERE a.parent_level = b.catno

ORDER BY a.category, b.category








Requirements Database Add Requirement






 
Select ATA Code 
#category# 


Select ATA Sub Code












~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: MS CF?

2002-12-23 Thread Jason Lees (National Express)
If it happens it happens, being a developer I'll use whatever tool's I'm
told to use either by Clients or the company I work for at the time.

As for if MS buys MM personally I can see it happening, based on the
aqusitions its made over the years, and also the fact that the only tools MS
have for web design are Front Page and ASP.Net, and they arnt the easiest to
use.

Well thats my two penneth. 

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Len Conrad [mailto:[EMAIL PROTECTED]]
Sent: 23 December 2002 10:07
To: CF-Talk
Subject: MS CF?


http://theregister.co.uk/content/4/28667.html





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Page Breaks for Printing

2002-12-19 Thread Jason Lees (National Express)
We use page breaks, and its a simple tag extention of the classic paragraph
Tag



The Complication is deciding on the location to place the Tag.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Page Breaks for Printing


Has anyone figured out how to make page breaks for printing?

I.E. have the user click one button to print all of the new orders.
Each order on a separate piece of 8.5x11 paper.

Javascript?  Generate a PDF?

Thanks!


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Is Coldfusion REALLY multi threaded?

2002-12-05 Thread Jason Lees (National Express)
It might not Be CF thats causing the problem, its most likley the DB thats
escalating the Lock to a full table lock and thus preventing other users
from running the queries until the table is free.

Also try moving the DB onto another server, as we had a simular problem,
with ingres and moving the CF app to a new server solved the problem.

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Stephen Richards [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2002 16:23
To: CF-Talk
Subject: Fw: Is Coldfusion REALLY multi threaded?


- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, December 05, 2002 4:14 PM
Subject: Re: Is Coldfusion REALLY multi threaded?


> Stephen Richards wrote:
> >
> > We have 24 connections at the moment, as reported by the database.
(can't
> > use netstat because the CF server is running on the same machine as the
> > database, so it's a unix socket rather than port 5423.
>
> And how many of them are idle? In the mean time you might want to get
> somebody to look at that query, since 2 minutes is rather long.
>
how do I tell which ones are active?

Yep, I agree with you about the query, and we're taking action on that, but
it still raises the point that CF is unresponsive while a query is
executing, and I am sure it is not supposed to be.  And the more  users log
on, the worse it is going to become.
-
Stephen Richards
020 7903 3226
--



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Passing objects from CFMX to Webservices

2002-12-04 Thread Jason Lees (National Express)
All,

I have two webservices both written in VB.Net, one generates a Journey
Object, which I can parse quite easily in CFMX, however I need to be able to
pass part of  the object back into another webservice after a selection is
made, the receiving webservice is expecting the same object type I'm passing
back.

The following code give me a Jave Lang Exception error - 'Could not perform
web service invocation "fareSearch" because
java.lang.IllegalArgumentException: argument type mismatch)'

http://jlees1/FareSearch/FareSearch.asmx?wsdl";
  method="fareSearch" 
  returnvariable="Fares">
  
 

I've tried all using the argumentcollection in the cfinvoke, which gives me
the error - 'Cannot remove properties from a java object'

I've conisdered redeveloping the webservice to use flat strings, but I'd
Ideally like a neater solution, hence the reasons for using a webservice and
objects)

Can anybody offer me any pointers on what to try next 

Many thanks in advance for all your help.

Jason Lees
Systems Developer
National Express Coaches Ltd.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Checking SESSION variable

2002-12-02 Thread Jason Lees (National Express)
Use the find function




.

 
but from the example that could be ambigious, as there could be more than
one mywork2 in different sub folders.

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 16:08
To: CF-Talk
Subject: Checking SESSION variable


Hi,

I have session variable that contains the directory name
"session.strFileName". I also have another session variable "session.ShowMe"
that contains multiple directory names 
(comma-delimited) which i'm setting from my database. Basically, i need to
check if the directory "session.strFileName" exists in the variable
"session.showme".

Example:

session.strfilename = 'mywork'

session.showme = 'c:\temp\dir1,c:\temp\dir2,c:\temp\mywork,c:\temp\mywork2'



---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Webservices that return Collections

2002-11-29 Thread Jason Lees (National Express)
All,

Im not a full time CF Coder, This is just to enable me a proof of concept
for some external contractor who are sceptical about the use of webservices.

The CFDump tag works a treat, I can use this to get all the details I need.

Many thanks, 

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 29 November 2002 10:51
To: CF-Talk
Subject: RE: Webservices that return Collections


Is it a valid ColdFusion recognised structure?   The others are correct, if
you use CFDUMP you should be able to find out if if the structure is valid
for CF to intepret etc...

I would assume though that this should get the values out (though it
probably wont, as its Friday and I am putting in little effort ;): 




 
#webservice[Journeys][1][JourneyDetail][LegCount][Duration][Legs][1].LegDate
#


also, try and run an #isStruct(YOURSERVICE)# to determine if its a valid
structure...

It really shouldnt be difficult to get at the values if it is!

Neil

-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: 29 November 2002 10:39
To: CF-Talk
Subject: Webservices that return Collections


All,

I have written a Webservice in .Net that produces an Object Collection, the
basic structure is

Journeys(Index).JourneyDetail.LegCount
   .Duration
   .Legs(Index).LegData

I would like to know how I can loop through this structure so it can be
output in to a table, I've tried using CFloop to loop round the collection,
but it throw errors,

My Code is 

http://localhost/JourneySearch/JourneySearch.asmx?wsdl";
  method="JourneySearch" 
  returnvariable="Journeys">
 
 
 
 



#JourneyDetail.LegCount#


I get the following error returned by CF -

You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members. The Error Occurred in
C:\Inetpub\wwwroot\test1\Test.cfm: line 21
19 : 
20 : 
21 :#JourneyDetail.LegCount#
22 : 
23 :  

Can anybody give me some pointers, please

Jason Lees
Systems Developer
National Express Coaches Ltd.





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Webservices that return Collections

2002-11-29 Thread Jason Lees (National Express)
All,

I have written a Webservice in .Net that produces an Object Collection, the
basic structure is

Journeys(Index).JourneyDetail.LegCount
   .Duration
   .Legs(Index).LegData

I would like to know how I can loop through this structure so it can be
output in to a table, I've tried using CFloop to loop round the collection,
but it throw errors,

My Code is 

http://localhost/JourneySearch/JourneySearch.asmx?wsdl";
  method="JourneySearch" 
  returnvariable="Journeys">
 
 
 
 



#JourneyDetail.LegCount#


I get the following error returned by CF -

You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members. The Error Occurred in
C:\Inetpub\wwwroot\test1\Test.cfm: line 21
19 : 
20 : 
21 :#JourneyDetail.LegCount#
22 : 
23 :  

Can anybody give me some pointers, please

Jason Lees
Systems Developer
National Express Coaches Ltd.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Alternating Row Colours & Number Listing in CFOutput

2002-11-27 Thread Jason Lees (National Express)
Cant you just use the CurrentRow variable, for the record number display?

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2002 16:39
To: CF-Talk
Subject: Alternating Row Colours & Number Listing in CFOutput


Hi

I am using the following script to display the latest 5 records from the
database table, and alternate the colour of each row, from white to grey.

This works, but how to I add a number listing with each record so the latest
record would have a number 1. next to it the seconf record would have number
2 then number 3 etc.

If you look at the code attached and the second CFIF statement you will see
that at present I have hard coded a number 1 and number 2, so in the results
at present it is bringing back

1.) Record Name
2.) Record Name
1.) Record Name
2.) Record Name
1.) Record Name

How to I make this dynamic in Coldfusion so it is a number listing of 1 to
5???

TIA
Ian



  

   


  

   
 


  


1.
  
  2
  

  

 #linktitle#
  
  #linktitle#
  
  

  





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Checking a float

2002-11-18 Thread Jason Lees (National Express)
As CF is a loosly typed language you could simply do


--whole bathrooms

--partial bathrooms


Question is though how do you have .5 of a bathroom, isnt this like half a
hole?

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 15:28
To: CF-Talk
Subject: Checking a float


A have a float field in a db to store the number of bathrooms for a 
property ( 1.5 bathrooms, 3 bathrooms). My question is, how do I check 
to see if there is a non zero value after the decimal? I want it to show:

1.5 bathrooms
3 bathrooms

and not:

1.5 bathrooms
3.0 bathrooms

Any help is greatly appreciated.

Cutter
Falcon Knives


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: calling a dll from an sql stored proc

2002-11-15 Thread Jason Lees (National Express)
Hi John,

I've just spoken with our MS SQL Guru and hes not aware of any way of
accesing a VB created Dll through MS SQL.

The only way he intimated it could be done was by writing an xp_ wrapper in
c++ for the VB library.


Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: John McCosker [mailto:J.McCosker@;andronics.co.uk]
Sent: 15 November 2002 13:17
To: CF-Talk
Subject: calling a dll from an sql stored proc


Greetings,

Has anyone called a dll from a stored procedure,
I am aware you can create custom stored procs that are dll's
but the sql API only understands dll's in c or c++,

I want to write it in VB.

The problem is with a trigger, that when an update occurrs I need it to
create a recordset
and loop throug it performing calculations from the recordset then inserting
the results
into a new table, this can be done with a Cursor,
but is very slow and I have been told is very resource intensive on sql
server.

We don't want to do this as the trigger will be called often.

An alternative would be if a stored proc could call a flat file, i.e. a cfm
or asp page
and then do the maipulation here.

We have thought of a third alternative which will work, send an email to an
INBOX via sgl server
and have the inbox agent call the dll, but the result has a latency due to
the email request.

Would appreciate any thoughts,

Respectfully,

J

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: CFX tags

2002-11-14 Thread Jason Lees (National Express)
Mark,

To the best of my knowledge you need to define the CFX tag on the local
server, and have a local copy or a mapped drive to the location of the CFX
tags on the other server.

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Mark Leder [mailto:mel@;markleder.com]
Sent: 14 November 2002 13:42
To: CF-Talk
Subject: CFX tags


Hi All,
Can CFX tags installed on one CFServer be called from a second server /
site which doesn't have the tags installed on its CFServer?

Thanks,
Mark


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: CFOBJECT and conversion from ASP

2002-11-12 Thread Jason Lees (National Express)
Coms not dead yet as you say theres too many older applications using it,
but the way forward is webservices, which is basically a newer version of
Com without the all the hassles.

With reagrd the problem try

myMethod = myObject.item("title");
myMethod = "title";



Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Joshua O'Connor-Rose [mailto:whifflebat@;hotmail.com]
Sent: 12 November 2002 15:57
To: CF-Talk
Subject: CFOBJECT and conversion from ASP


OK so COM is dead, I would like to see the thread. Do you have a link.
That would also imply that no one uses it anymore.

Anyway the office I'm developing for is using all that dead stuff.

I have been advocating replacing what they have with Verity and hopefully
that is what the system will convert to. But right now . . . I'm a slave to
a contract.

In response to your suggestion (thanks for the post)

myObject = myObject.item("title");
myObject = "title";

This throws an error "the parameter is incorrect" on this line:
myObject = myObject.item("title"); 
which I assume is coming from the object itself.

So that doesn't work either. (It as if the object won't accept the name of
the option without an assignment operator).

Any other ideas? or am I going to have to use asp?

-Joshua O'Connor-Rose
-All is Good

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: CFOBJECT and conversion from ASP

2002-11-12 Thread Jason Lees (National Express)
Joshua,

I think this will work,





Or With 


anObject=CreateObject("Com","NextPage.NPOptions")'
myMethod=anObject.Item("title");
myMethod="Title";



Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Joshua O'Connor-Rose [mailto:whifflebat@;hotmail.com]
Sent: 12 November 2002 16:08
To: CF-Talk
Subject: CFOBJECT and conversion from ASP


New to the list. Not to ColdFusion

The contract I'm working on is using NextPage NXT3 to manage documents. They

want to do some management of the NextPage environment through the 
ColdFusion system. (Never mind that Verity is better it has been discussed)

NextPage has provided developers with com objects so that collections can be

built by using the objects.

One of these objects is merely used to define options and is created like 
this

In asp
Set objNPOptions = Server.CreateObject("NextPage.NPOptions")

to create the name value pairs the command is this:

objNPOptions("title") = "Title"

or
objNPOptions.item("title") = "Title"

I've been trying to convert this into cold fusion but my conversion bombs 
when I attempt the same



Can't use a function on the left side of an assignment. (sigh)

The unfortunate thing is the NPOptions object is required to set the options

for other objects like
objSiteAdmin.CreateInfobase objNPOptions, "name", "c:\filename.nfo"

aka in ColdFusion


I tried structures and arrays but it seems that NPOptions is an object that 
the other com objects are expecting

-from the desk of Joshua O'Connor-Rose
-All is good





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Studio MX

2002-11-08 Thread Jason Lees (National Express)
My understanding is that there is no longer a CF Studio, its now fully
integrated with Dreamweaver MX.

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Owens, Howard [mailto:HOwens@;insidevc.com]
Sent: 07 November 2002 20:49
To: CF-Talk
Subject: Studio MX


I'm trying to decide the best upgrade path ...

Some time in the next year, we'll upgrade our servers to MX, so I will want
to upgrade my development environment, too.

Currently, I have Studio5 and the dev version of the server for 5.0.  I also
have UltraDev, but rarely use it. I do all of my coding (and very little
design) in Studio. That's the way I like it.

Should I upgrade to Studio MX?  Will I like it if I love the current version
of Studio, or does the "homesite" aspect of Studio disappear?  If it does,
but I get MX anyway, can I retain the install of Studio5 (without any
hassle, such as fussing with the registry), or does MX overwrite/take over
5?

Should I upgrade to the latest version of HomeSite instead?

I assume there is a demo/single-license version of MX server I can download.
Would my best option be to just stick with Studio5 and download the MX
server?  If I do this, is there some place I can get VTMs and help files and
documentation for new tags?

Thanks.

H.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Using .Net Object with CF Server MX

2002-11-07 Thread Jason Lees (National Express)
All,

Has anybody succesfully managed to interface Microsoft .NET DLL's with CF
MX?

If so can you provide me with some pointers please.

Many thanks in Advance.

Jason Lees
Systems Developer
National Express Coaches Ltd.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: is this list dead?

2001-07-02 Thread Jason Lees (National Express)

This is the first one i've had in over a week!!!

I thought the list was Dead!!

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Erika L. Walker [mailto:[EMAIL PROTECTED]]
Sent: 02 July 2001 16:53
To: CF-Talk
Subject: RE: is this list dead?


I'm getting posts, but not as many as we used to get.

:(

Erika
(with a *K*)

"Those who love deeply never grow old; they may die of old age, but they die
young." - Sir Arthur Wing Pinero
-
Macromedia ColdFusion 5.0 Certified Developer - < Just passed!!
WooHoo
-

-Original Message-
From: Mike Sullivan [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 10:57 AM
To: CF-Talk
Subject: is this list dead?


I haven't seen a post in quite some time now.
Mike
~~
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: ignore an error??

2001-06-07 Thread Jason Lees (National Express)


you could use the CFParam to set it to an empty string.



Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: 07 June 2001 16:10
To: CF-Talk
Subject: ignore an error??


I recieve the following error:

An error occurred while evaluating the expression: 
#url.techID#

Page User Came From: http://www.site.com/Code.cfm?exitID=8&techID=94

I was wondering how to ignore or bypass this error because the techID does
get
passed and the code executes. But I always get an error email report and on
some machines the error message DOES display causing the code to bomb.
~~
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: Preserve ampersand tagged data (SGML)

2001-06-06 Thread Jason Lees (National Express)


Use the reverse of UrlDecode(encodedUrlString) 


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 15:05
To: CF-Talk
Subject: RE: Preserve ampersand tagged data (SGML)



Thanks

Another question.

I need to extract the complete path using the CGI.HTTP_REFERER in my 
template but when I output
the line the string is encoded for use in URL's.

What I need is the exact path without the encoding to be passed into my



Output:
dir=d%3A%5Cdirectory%5Csub-directory\

Require:
d:\directory\subdirectory\

Is there another way of getting this output without using the "Replace" 
function?



At 02:37 PM 6/6/01 +0100, you wrote:
>HTMLEditFormat()
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 06 June 2001 12:58
> > To: CF-Talk
> > Subject: RE: Preserve ampersand tagged data (SGML)
> >
> >
> >
> > I'm using  > french accented characters.
> >
> > Is there a CF function to preserve ampersand stuff ?
> >
> > Here is a little snippet from the datafile that has the SGML entity for
a
> > accented character "çais"
> >
> > 
> >
> > Disponible en français
> >
> > 
> >
> >
> > When outputted in a  I want the text to appear AS IS. I don't
> > want the "cedil" translated into the ASCII character.
> >
> > 
> >
> > Disponible en français
> >
> > 
> >
> >
> >
>
~~
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: Challenging dillemma (double values?)

2001-06-06 Thread Jason Lees (National Express)


you can youse a hidden field in the page and pass that into the Javascript
function and just add the part item into it, with a comma so its a commer
delmited list, just remember to remove the last Commer from the List.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 14:16
To: CF-Talk
Subject: Challenging dillemma (double values?)


Hi!

I have a little challenging question for you.
I have a "build your own computer system" 
page where customers can choose what parts 
they want in their system.  There is a javascript
that calculates everything on the fly.
This javascript needs to have the price
as the value:

#PartName#

But, I also need to pass the partID to the server, not the price.
Is there a way that we could have the best of both world?
The calculating javascript and the PartID's to send to 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: profanity checker(again)

2001-06-06 Thread Jason Lees (National Express)


you could check to see if there is a valid caracter before and/or after the
profanity, it Saturday would find turd then check back and find that there
is no space or full stop, and then check forward for the same.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 13:56
To: CF-Talk
Subject: profanity checker(again)


Hi all,

I emailed the list regarding this a few weeks ago, but an interesting
problem has now come up.

I have some code that pulls a list of profanities from a db table, then
checks them against a form feild submitted by a user. Any words that match
are asterisked out. All well and good. But, when someone entered Saturday,
the code returned Saay!! Yers, turd is in the database! What I want to
know is this. How would I look at changing this so that whilst turd would be
picked up and returned as , saturday is not??

Any ideas? Code is below.

TIA

Will





 


SELECT ID, badword, rate1
FROM tbl_profanity











~~
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: CF 5 Eval

2001-06-06 Thread Jason Lees (National Express)


Go to http://www.macromedia.com/go/cfpromo/

As far as I can understand its available now.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 11:06
To: CF-Talk
Subject: RE: CF 5 Eval


When exactly is cf5 (enterprise) released, does anyone know?

-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 7:46 AM
To: CF-Talk
Subject: RE: CF 5 Eval



I'm currently evaluating it, and this sounds like it could be extremly
usefull, please forward any information.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 07:44
To: CF-Talk
Subject: CF 5 Eval


Is anyone else evaluating or currently using CF 5? I have got
some examples I would like to share with you about getting tons of user
defined functions to run in memory instead of having to load them at the top
of ever page. It is kind of the same effect you would get from caching a
query except with a function instead.

Anyway before I go into it. Anybody?

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development
~~
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: CF 5 Eval

2001-06-06 Thread Jason Lees (National Express)


I'm currently evaluating it, and this sounds like it could be extremly
usefull, please forward any information.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: 06 June 2001 07:44
To: CF-Talk
Subject: CF 5 Eval


Is anyone else evaluating or currently using CF 5? I have got
some examples I would like to share with you about getting tons of user
defined functions to run in memory instead of having to load them at the top
of ever page. It is kind of the same effect you would get from caching a
query except with a function instead.

Anyway before I go into it. Anybody?

Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development
~~
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: CF5.0 Tag CFFlush

2001-06-05 Thread Jason Lees (National Express)


Thanks,

Just tried that, changed from a cookie to the Registry and it appears to be
working a bit better.

Whats the best way to store client vars, Registry or DB Table?

Thanks.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: 05 June 2001 14:42
To: CF-Talk
Subject: Re: CF5.0 Tag CFFlush


If you are using client variables, and have specified cookies as storage,
then you have an implied call to CFCOOKIE or a similar construct being
included for you by CF.  If you change your client variable storage to
something other than cookie, it will probably work.

DC
- Original Message -
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 05, 2001 09:13
Subject: RE: CF5.0 Tag CFFlush


>
> Thanks,
>
> I've checked the code for that and there is nothing except standard CFML &
> HTML tags, ie no CFCookie, cflocation, or any other such tags.
>
> Just to check I used this on a page that is a 90%  block. and
> still the same.
>
>
> Jason Lees
> National Express
> Email : [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Ulf Unger [mailto:[EMAIL PROTECTED]]
> Sent: 05 June 2001 14:15
> To: CF-Talk
> Subject: AW: CF5.0 Tag CFFlush
>
>
> Hi Jason,
>
> I've read in the documentation that you can't use any ColdFusion-Tag that
> modifies the HTTP-Header (e.g. Cookies..) after you have used the
.
>
> Hope that helps.
>
> Ulf
> -Ursprüngliche Nachricht-
> Von: Jason Lees (National Express)
> [mailto:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 5. Juni 2001 14:54
> An: CF-Talk
> Betreff: CF5.0 Tag CFFlush
>
>
>
> Hi All,
>
> I'm just evaluating Coldfusion 5.0, at the moment I'm experimenting with
the
> new  tag, But every time I get an error at the end of the page,
>
> Error attempting to store global client values.
> The amount of data you have stored in global client variables is too long.
> The Cookie header has already been sent to the client, most likely because
a
> CFFLUSH tag has been executed.
> the tag reads 
>
> Does anybody have any Ideas A)Why this happens, and B) how do I stop it
> happening.
>
> The application uses a Cookie as the Client storage method,
>
> any help appreciated.
>
> Thanks
>
>
> Jason Lees
> National Express
> Email : [EMAIL PROTECTED]
>
> ###
> This document is intended for, and should only be read by, those persons
to
> whom it is addressed. Its contents are confidential and if you have
received
> this message in error, please notify us immediately by telephone on 0121
609
> 6301
> and delete all records of the message from your computer. Any form of
> reproduction,
> dissemination, copying, disclosure, modification, distribution and / or
> publication of this message without our prior written consent is strictly
> prohibited. Neither the author of this message nor their employers accept
> legal responsibility for the contents of the message. Any views or
opinions
> presented are solely those of the author.
> If you have any queries please contact [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: CF5.0 Tag CFFlush

2001-06-05 Thread Jason Lees (National Express)


Thanks,

I've checked the code for that and there is nothing except standard CFML &
HTML tags, ie no CFCookie, cflocation, or any other such tags.

Just to check I used this on a page that is a 90%  block. and
still the same.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Ulf Unger [mailto:[EMAIL PROTECTED]]
Sent: 05 June 2001 14:15
To: CF-Talk
Subject: AW: CF5.0 Tag CFFlush


Hi Jason,

I've read in the documentation that you can't use any ColdFusion-Tag that
modifies the HTTP-Header (e.g. Cookies..) after you have used the .

Hope that helps.

Ulf
-Ursprüngliche Nachricht-----
Von: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 5. Juni 2001 14:54
An: CF-Talk
Betreff: CF5.0 Tag CFFlush



Hi All,

I'm just evaluating Coldfusion 5.0, at the moment I'm experimenting with the
new  tag, But every time I get an error at the end of the page,

Error attempting to store global client values.
The amount of data you have stored in global client variables is too long.
The Cookie header has already been sent to the client, most likely because a
CFFLUSH tag has been executed.
the tag reads 

Does anybody have any Ideas A)Why this happens, and B) how do I stop it
happening.

The application uses a Cookie as the Client storage method,

any help appreciated.

Thanks


Jason Lees
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609
6301
and delete all records of the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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



CF5.0 Tag CFFlush

2001-06-05 Thread Jason Lees (National Express)


Hi All,

I'm just evaluating Coldfusion 5.0, at the moment I'm experimenting with the
new  tag, But every time I get an error at the end of the page, 

Error attempting to store global client values. 
The amount of data you have stored in global client variables is too long.
The Cookie header has already been sent to the client, most likely because a
CFFLUSH tag has been executed. 
the tag reads 

Does anybody have any Ideas A)Why this happens, and B) how do I stop it
happening.

The application uses a Cookie as the Client storage method, 

any help appreciated.

Thanks


Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: Use interactive CF debugger!!! : was VeRy tricky evaluate()

2001-06-04 Thread Jason Lees (National Express)


Surely the Array a has not been defined, therefore a will always either be a
null or length=0.

Have you Evaluating the Session Variable as the Array?

I think this should work, or somthing very simular


#evaluate("session.my" & url.grid & "[" & i & "]")#


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:42
To: CF-Talk
Subject: RE: Use interactive CF debugger!!! : was VeRy tricky evaluate()


After many many attempts i still have not got it working this may be due to
the fact that i'm not sure exactly how it is supposed to work. Do you have
an tips/pointers?

Thanks

Kola

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 04 June 2001 14:24
To: CF-Talk
Subject: Use interactive CF debugger!!! : was VeRy tricky evaluate()


Seems to me the only way you could find your way out of this one is to use
the cfstudio step through debugging. You may be doing so already but I get
the impression not many cf developers use this, perhaps because it can be
temperamental. But I've found it invaluable now I've got it working. It can
save you mountains of time and brain ache. I'd recommend spending the time
to get it running.
I had it working on a stand-alone but I'd been led to believe it wouldn't
work well on a network, but it does, sometimes it takes a few attempts to
connect.

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 29 May 2001 16:45
To: CF-Talk
Subject: VeRy tricky evaluate()


I'm in a complex situation here which gives NO ERRORS but doesn't seem to
work right.
please help.

My project has several unique sections (where the key=grid)
Every user can upload several images to each group.
everytime he uploads at least 1 file to a new group, I'm assigning him a
session array variable
that is called: "session.my#url.grid#":







then I give him the upload form.

after each upload, I'm appending the array with the new file:





and now I want to display back the upload form, but with a list of the files
he already uploaded:

first I'm moving the session array into a local variable:






then I'm looping without worrying for locking:

Files that were uploaded to #url.grid#:

#a[i]#

the a array keeps being EMPTY all the time.
I'm checking that with this:


You haven't uploaded any pictures to #url.grid# yet.


note that I don't want to :

a. query the db everytime to get the list of files that was uploaded.
b. limit the session timout to 1 minute


Thanks,

Michael Lugassy
IT/WEB Specialist
Interactive Music Ltd.
~~
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: What's with this?

2001-06-01 Thread Jason Lees (National Express)


Doesn't June only have 30 days!!!!!


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 14:11
To: CF-Talk
Subject: What's with this?


I have this bit of code...




and I'm getting this error on date1


In the function CreateDate(year, month, day) the combination of the 
arguments, which are 2001- 6-31, have resulted in an invalid date value. 
The valid range of dates approximately covers the period between 100 AD and 
 AD


WHY?


Steven D Dworman
---
Cold Fusion Programmer
Web Applications Developer

ComSpec International

phone: 248.647.8841
cell:  734.972.9676
---
http://www.comspec-intnl.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



RE: How do I parse strings?

2001-05-30 Thread Jason Lees (National Express)


hi Bill,

This should do what you want more or less, it uses CF Script, Except this
will also check for the Existing CR&LF characters and bearck naturally.  It
will search backwards for the last space before a word rather than search
forward.

Amend Linelength to match requirements.  The Output is in TmpActual which is
an Array.

iLine is the Line count Amend it from 2 to 1,

Theres also probably a better way to do this, but it works,



iLine=2;
LineLength=64
TmpActual=Arraynew(1);

MsgOperator=Replace(Form.Message,Chr(10),"}","ALL");
MsgOperator=Replace(MsgOperator,Chr(13),"}","ALL");
while (len(MsgOperator) gt 0){
TmpNote="";
if (len(MsgOperator) gt LineLength) 
TmpNote=Mid(MsgOperator,1,LineLength);
else
TmpNote=Mid(MsgOperator,1,len(MsgOperator));

pos=Find("}}",TmpNote,1)-1;
if (pos lte 0){
pos=Len(TmpNote);
if (pos eq LineLength){
for (pos;pos gt 0 and Mid(TmpNote,pos,1) neq
" ";pos=pos-1);
if (pos eq 0)
pos=Len(TmpNote);
}
}

Miss_Line=FALSE;
if (Find("}}",TmpNote,1) eq 1){
pos=2;
Miss_Line=TRUE;
}

if (not Miss_Line){
TmpActual[iline]=
Ljustify(Mid(TmpNote,1,pos),LineLength);
iLine=iLine+1;
}

if (Find("}}",TmpNote,1) gte 0)
pos=pos+2;
else
pos=pos+1;
MsgOperator=Mid(MsgOperator,pos-1,len(MsgOperator));
}
iLine=iLine-1;



HTH

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Bill Poff [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2001 15:45
To: CF-Talk
Subject: How do I parse strings?


Hello fellow CFers,

I'm trying to process a "textarea" variable and break it up into lines of
aprox 70-80 characters in length for transmission as a text formatted email
message.

Can someone help me with the code to parse the variable into lines so that I
can insert a #CHR(13)##CHR(10)# at the end of every line. The challenge is
to break between words.

Thanks.

--Bill
~~
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: whitespace

2001-05-26 Thread Jason Lees (National Express)


I had a similar problem, so I used the  tag and this reduced page
size by as much as 25%, unfortunatly you can't use querys or custom tags in
a  block so there are limitations and Debuging can be a hand full.

I would suggest writting the page normally in CF then converting as much as
possible into a CFScript tag.

HTH.

Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]



-Original Message-
From: nagesh [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 8:09 PM
To: CF-Talk
Subject: whitespace


hi all,


i really fed up with the white space which is generated in the text file by
coldfusion(4.5). This happens when client(outlook) is reading the data which
is in output tags and trying to write into the text(log) file.

Do we have anything by which we can remove/trim the white space before it
goes to text file. Because the problem here is with the white space the size
of the file is getting increased like anything.


I know about  tag. but i want something
powerful than that. Any ideas would be greatly appreciated.

Thanks
nagesh
~~
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: Can I retrieve the peripherals attached to a 'puter?

2001-05-25 Thread Jason Lees (National Express)


If you goto the M$ page http://windowsupdate.microsoft.com/ and click on the
products Update, and it appears that this goes and searches the registry.

So It is Possible,

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2001 15:33
To: CF-Talk
Subject: Can I retrieve the peripherals attached to a 'puter?


Does anyone know if it is possible to query the system registry of a
visitor's system in an effort to retrieve the names of peripherals attached
to it?

i.e. HP2000 printer, Iomega zip drive, Panasonic CD Writer...

How about with VB?

anyone...anyone...
~~
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: CFGRID with list box?

2001-05-25 Thread Jason Lees (National Express)


Probably not, M$ seems to have gone off java since sun won its law suite
against them, besides Sun is developing Java faster than M$ or Netscapecan
keep up, they're currently working 1.4 at the moment which by all accounts
is a major overhaul.  

Beside M$ is too busy trying to push its .net development suite, so chances
are that it wont.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2001 14:13
To: CF-Talk
Subject: RE: CFGRID with list box?


Arrggh..what are the chances that the new JRE will be bundled with future MS
OS updates or something like that?

Will IE6.0 have it standard?

-Gel


-Original Message-
From: Jason Lees (National Express)

Latest JRE Environment (1.3.1) is about 5.5MB, It is ideal for Intranets,
but a problemif your Network Admin has a god complex where hes locked all
machines to Normal Users Installing software, even off the intranet!!!
~~
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: CFGRID with list box?

2001-05-25 Thread Jason Lees (National Express)

Latest JRE Environment (1.3.1) is about 5.5MB, It is ideal for Intranets,
but a problemif your Network Admin has a god complex where hes locked all
machines to Normal Users Installing software, even off the intranet!!!


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 May 2001 13:43
To: CF-Talk
Subject: Re: CFGRID with list box?


* Team Allaire *
> Ya but -- Correct me if I'm wrong -- I've been told that the new CFGRID
> involves a five mb download the first time it is used -- which makes it's
> usefullnees nil for most applications -- those that still want to be
> functional on a 56k line.

if you mean the latest JRE, i think its even bigger than that ;-) BUT
if you want to use any java stuff from cf5, that's one bullet you gotta
bite. we gagged at first but on our intranet it cleared up several pesky
java problems (nothing to do w/cf).  now we're pushing it all our
intranet sites.

if thats not for you, then i guess dhtml is one recourse. think there's
a cheap tag in the gallery cf_jsgrid or something like that...
~~
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: SLightly OT - a time formula

2001-05-22 Thread Jason Lees (National Express)


Try this 




Therefore with 400 Mins you get

Hours=int(400/60)=6
Mins=400 Mod 6= 40

Back Calc = (6*60)+40=360+40=400



Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2001 14:46
To: CF-Talk
Subject: SLightly OT - a time formula


Hi all,

This is slightly OT, but refers to a cf project so I guess it is relevant in
a way. Does anyone know a formula for calculating time. I have numbers of
minutes, and need to calculate the time in hours and minutes from these.

For example, I have the figure of 400 minutes. I need to calculate how many
hours and minutes this is. Dividing by 60 won't do the job, it gives an
answer of 6.. What I need is a formula that will give me the correct
answer: 6hrs 40minutes.

Anyone know a nice formula for calculating this?

TIA

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



Configuring CF45 for Java

2001-05-18 Thread Jason Lees (National Express)


Hi All,

The problem I am experiencing is that I have developed a Java Applet that
creates a Menu system, It works fine on the development macine with Java
installed but when I check on another Machine there I get a Class not found
Exception.

I have assumed that this is becuase CF isn't set up to run JVM and doesnt
have the necessary classes on the system. Is this true? 

and

How do you configure the Java settings in CF4.5 so that you can utilise
classes?

Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: OpenIngres Database

2001-05-16 Thread Jason Lees (National Express)


I've Just spoken to our resident Ingres expert, and his opinion is that you
need to use a DB procedure to do it.

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 18:37
To: CF-Talk
Subject: OpenIngres Database


Help!

Does anyone know if there's a way to make an auto-
incrementing number field in a CA OpenIngres database?

Thanks!

Norman Elton
~~
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



Way OT:Java Mailing Lists

2001-05-14 Thread Jason Lees (National Express)


Hi All,

Can anybody recommend a good JAVA Mailing list like CF-Talk.

TIA

Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: query error

2001-05-14 Thread Jason Lees (National Express)


Do You realy need the ; at the end of the Query?


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 11:36
To: CF-Talk
Subject: query error


Hello,

Must be having a brain spasm todayI am getting this error message:

Message: ODBC Error Code = S1000 (General error)
Error Code: -3035 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access
Driver] Operation must use an updateable query.


SQL = "INSERT INTO tbl_threads (operaID, thread_title, thread_body,
thread_author, thread_time) VALUES (32, 'hhdf', 'hsdfhdfh', 1, 14/05/01);"

This is the query that seems to be causing the problem:


INSERT INTO tbl_threads (operaID,
thread_title,
thread_body,
thread_author,
thread_time)
VALUES  (#url.operaID#,
'#Form.thread_title#',
'#Form.thread_body#',
#checkauthor.authorID#,
#dadate#);


Any ideas anyone?

TIA

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



RE: Changing Default Site error page

2001-05-03 Thread Jason Lees (National Express)


sorry, this is what I meant, I must start being more precise..

Any Ideas?


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2001 19:59
To: CF-Talk
Subject: RE: Changing Default Site error page


He said "when CF Server has been shut down".  If the CF server isn't
running, how could it process the site wide error handler?  I think he's
asking about this error:

Error Diagnostic Information
An error occurred while attempting to establish a connection to the service.

The most likely cause of this problem is that the service is not currently
running. You can use the 'Services' Control Panel to verify that the service
is running and to restart it if necessary.

Windows NT error number 2 occurred.

Any way to replace that with a friendlier message?

Bob

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: May 2, 2001 12:29 PM
To: CF-Talk
Subject: Re: Changing Default Site error page


* Team Allaire *
How did you set up the site wide error handler? It has to be the 'true path'
to the template. i.e. c:\htdocs\error.cfm


>
> Hi All,
>
> is there any way to change the default displayed page when CF Server has
> been shut down? at the moment we get an Error Diagnostic page and want to
> change this to a more freindly solution.
>
> We have tried Using the CF Site wide error option in the administrator
> settings but this doesn't work.
>
> Does anyone have any ideas??
>
> Jason Lees
> National Express
> Systems Department.
> E-Mail : [EMAIL PROTECTED]
>
>
> ###
> This document is intended for, and should only be read by, those persons
to
> whom it is addressed. Its contents are confidential and if you have
received
> this message in error, please notify us immediately by telephone on 0121
609 6301
> and delete all records of the message from your computer. Any form of
reproduction,
> dissemination, copying, disclosure, modification, distribution and / or
> publication of this message without our prior written consent is strictly
> prohibited. Neither the author of this message nor their employers accept
> legal responsibility for the contents of the message. Any views or
opinions
> presented are solely those of the author.
> If you have any queries please contact [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



Changing Default Site error page

2001-05-02 Thread Jason Lees (National Express)


Hi All,

is there any way to change the default displayed page when CF Server has
been shut down? at the moment we get an Error Diagnostic page and want to
change this to a more freindly solution.

We have tried Using the CF Site wide error option in the administrator
settings but this doesn't work.

Does anyone have any ideas??

Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]


###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Jason Lees (National Express)

Cant see anything wrong with the syntax, have you tried removing the spaces
before and after all the ='s in the query string,shouldn't make a difference
but worth trying.

is the DSN correct?

Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 4:22 PM
To: CF-Talk
Subject: RE: Update in CFquery is failing, somone code check this ?


> I think you might find that the Skill field is now 2 and not 
> 1 Re-read your
> e-mail, 
>
> Technically the critera you want to update doesn't exist any 
> more there for
> no record therefore an Error.

Shame that the error is 'syntax error', and not 'no records updated', which
iirc wont be reported 'cuase its OK for an update to not update anything.

Anyway, its still a bug, now fixed, so thanks for spotting it :-) 
Dont suppose you've secretly found out where the syntax error is ?
~~
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: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Jason Lees (National Express)

I think you might find that the Skill field is now 2 and not 1 Re-read your
e-mail, 

'The previous query (update con_list set
skill_level=2 where userid = 32715281 and skill=1) on the same datasource
finishes fine.'

Technically the critera you want to update doesn't exist any more there for
no record therefore an Error.

QED

Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 11:43 AM
To: CF-Talk
Subject: Update in CFquery is failing, somone code check this ?


I have:

update con_list set note = 'dr' where userid = #session.userid# and skill =
#form.skill#

And it is dieing with:
ODBC Error Code = 37000 (Syntax error or access violation) 
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. 
SQL = "update con_list set note = 'dr' where userid = 32715281 and skill =
1" 
Data Source = "PS_SKILLS"
and I cant sport the error. The previous query (update con_list set
skill_level=2 where userid = 32715281 and skill=1) on the same datasource
finishes fine.

Regards,
Thomas Chiverton
Intranet Architect and Desktop Analyst
01565 757 909
It's not a job, it's an adventure
~~
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: CF Time off by an hour?

2001-04-06 Thread Jason Lees (National Express)

Same thing happens on our system running CF server 4.5.1 and windows NT4 SP
4

Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 2:26 PM
To: CF-Talk
Subject: RE: CF Time off by an hour?


This is a problem with old apps compiled with a broken C++ library.

I suggest you upgrade CF / NT to more recent versions / patches.

-Original Message-
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 2:08 PM
To: CF-Talk
Subject: CF Time off by an hour?


Our Windows NT 4 Server, running Cold Fusion 4.01 switched over with
daylight savings time,
yet Cold Fusion seems to still be an hour off.. The system time itself is
correct, but running
a script which outputs #now()# reports an hour behind. Has anybody else
encountered this
problem and have a fix for it? We've rebooted the machine, as well as
stopped and started the
Cold Fusion services, but it doesn't seem to have any effect...

Thanks,
Scott Becker
Web Developer : ConnectWise, Inc.
www.ConnectWise.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



RE: ASCII for Tab

2001-04-06 Thread Jason Lees (National Express)


I think it would be better to chr(9) in he replace statement,


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 13:11
To: CF-Talk
Subject: Re: ASCII for Tab


So it would be 	  in a replace statement.   Is this correct?

Thanks,
Dave


- Original Message -
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 8:06 AM
Subject: RE: ASCII for Tab


>
> I belive its ASCII '9'
>
>
> Jason Lees
> National Express
> Email : [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Dave Hannum [mailto:[EMAIL PROTECTED]]
> Sent: 06 April 2001 13:01
> To: CF-Talk
> Subject: ASCII for Tab
>
>
> 'Mornin,
>
> Can anybody tell me what the ASCII for 'Tab' is so I can remove them?
>
> Thanks
> Dave
>
~~
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: ASCII for Tab

2001-04-06 Thread Jason Lees (National Express)


I belive its ASCII '9'


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 13:01
To: CF-Talk
Subject: ASCII for Tab


'Mornin,

Can anybody tell me what the ASCII for 'Tab' is so I can remove them?

Thanks
Dave
~~
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: Oddness with cfqueryparam

2001-04-05 Thread Jason Lees (National Express)

Fair comment,


Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 2:23 PM
To: CF-Talk
Subject: RE: Oddness with cfqueryparam


> Personally I've never used the CFQueryparam tag, but Surely the query
should
> read,

:goes to a web site you've written and types into a form box:
wibble';drop table *;select * where lastname='wibble

Oops...

> LastName like '%#form.what#%' ORDER BY LastName ASC

Yes, unsurprisingly that works, but I need to clean the user input up, and I
dont fancy writting my own sanatiser...

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:55 PM
To: CF-Talk
Subject: Oddness with cfqueryparam


cfqueryparam doesnt seem to be doing as expected:


SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE 
LastName like '%%' ORDER BY LastName ASC


Debugging shows 
Form Fields:
FIELDNAMES=WHAT
WHAT=ch 
and the query as 
SQL = 
SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE 
LastName like '%?%' ORDER BY LastName ASC

What gives ? Shouldnt cfqueryparam sanatise the string (for " and ; etc.) ?

Regards,

Thomas Chiverton,
Intranet Architect and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...
~~
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: Oddness with cfqueryparam

2001-04-05 Thread Jason Lees (National Express)


Personally I've never used the CFQueryparam tag, but Surely the query should
read,


SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE 
LastName like '%#form.what#%' ORDER BY LastName ASC


Jason Lees
E-Mail:[EMAIL PROTECTED]


-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:55 PM
To: CF-Talk
Subject: Oddness with cfqueryparam


cfqueryparam doesnt seem to be doing as expected:


SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE 
LastName like '%%' ORDER BY LastName ASC


Debugging shows 
Form Fields:
FIELDNAMES=WHAT
WHAT=ch 
and the query as 
SQL = 
SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE 
LastName like '%?%' ORDER BY LastName ASC

What gives ? Shouldnt cfqueryparam sanatise the string (for " and ; etc.) ?

Regards,

Thomas Chiverton,
Intranet Architect and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...
~~
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: date range search

2001-04-04 Thread Jason Lees (National Express)


Give this one a try,






Select * 
>From My Table 
where OrderDate >= '#CreateODBCDateTime(startdate+TimeFormat("00:00:00"))#' 
  and OrderDate <= '#CreateODBCDateTime(enddate+TimeFormat("23:59:00"))#'




-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 4:55 PM
To: CF-Talk
Subject: RE: date range search


Thanks for the suggestion. It didn't work though. I have a form with a
dropdown menu. Can dates in an Access table between: 01/01/00 and 01/01/01
be searched ?
-
Using my code:






SELECT * FROM wwebsales
where orderdate between #startdate# and #enddate#

---
I can the following error:

ODBC Error Code = 22012 (Division by zero)
[Microsoft][ODBC Microsoft Access Driver]Division by zero (null)
SQL = "SELECT * FROM wwebsales where orderdate between 01/01/00 and
01/01/01"
Data Source = "wwebsales"
--

Thanks.

Robert O.

>-Original Message-
>From: Lamon, Alec [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 03, 2001 3:04 PM
>To: CF-Talk
>Subject: RE: date range search
>
>
>I think you want to use the CreateODBCDate() function to create
>your start and end dates.
>
>
>
>Then refer to those in your query *without* 's. (the
>CreateODBCDate() function puts them in for you):
>
>
>
>SELECT * FROM wwebsales
>where orderdate between #startdate# and #enddate#
>
>
>> -Original Message-
~~
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: Please Help

2001-04-04 Thread Jason Lees (National Express)


Its also Ideal way to learn Java Script. At least thats how I taught myself
Java script.

Another benefit is that I also managed to cut the output page sizes down by
as much as 50%!!!

Remember why reinvent the wheel.

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 3:51 PM
To: CF-Talk
Subject: RE: Please Help


I like that suggestion. It's naughty, but makes sense!! ;)

Will

-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]]
Sent: 04 April 2001 13:27
To: CF-Talk
Subject: Re: Please Help




...use .  Call the page in your browser then view source.
You will see all the JavaScript you will need for validating forms.
Copy and paste away

Not the most ethical solution, but a solution none the less.


-
Douglas Knudsen
Leveraged Technologies Group  
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 04/03/2001 06:11 PM

To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)

Subject:  Please Help


I am in desperate need of a simple validation of two types of form
fields.

1.   Date field (not a cfform just a plain form) - must validate that
data
entered is a date

2.  Number field (not a cfform just a plain form) - must validate that
data
entered is a number


Thanks

Stephanie
~~
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: Looping through a Query in CFSCRIPT

2001-04-03 Thread Jason Lees (National Express)


Thanks for all the help, I've tried the solution and it works, I forgot that
effectivly the query is a structured array.

I need a break/holiday or caffine injection.

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2001 16:19
To: CF-Talk
Subject: RE: Looping through a Query in CFSCRIPT



for(myCounter=1;
myCounter LTE myQuery.recordcount;
myCounter = myCounter + 1){
writeOutput(myQuery.myFieldName[myCounter] & '');
};



-Original Message-----
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 9:55 AM
To: CF-Talk
Subject: Looping through a Query in CFSCRIPT



Hi all,

Is it possible to loop through the results of a CFQuery structure? 

and Has anybody got an example of how its done

TIA.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609
6301
and delete all records of the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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



Looping through a Query in CFSCRIPT

2001-04-03 Thread Jason Lees (National Express)


Hi all,

Is it possible to loop through the results of a CFQuery structure? 

and Has anybody got an example of how its done

TIA.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Jason Lees (National Express)


try something like this. 

Checked >




Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2001 14:22
To: CF-Talk
Subject: Displaying yes/no field dynamically in checkboxes?


Friends,

I would much appreciate any help with a problem I'm stuck on.

I'm writing a page that will allow my client to edit a record. I've got it
so that the page queries the table and inserts the values from the record
specified by the numeric variable passed to it. The numeric fields, text
fields and memo fields appear, but I can't figure out how to make the
checkboxes display a check when the yes/no field is "yes".

Here's my code (below), such as it currently is. UltraDev wrote some of it
and I wrote the rest. The first few yes/no fields are "cabinHottub",
"cabinJettedtub", "cabinFireplace" and "cabinPets".

I would be grateful for any help; thanks very much in advance.

P@tty Ayers






SELECT * FROM cabinQuery WHERE cabinID = #rsEdit__varcabintoedit#






 Edit a Record Page











  

  Cabin Name:
  

  
  Location (City):
  

  


  Distance from Asheville:
  

  
  Number of Bedrooms:
  

  


  Number of Bathrooms:
  

  
  Sleeps:
  

  


  Hot tub:
  

  
  Jetted tub:
  

  


  Fireplace:
  

  
  Pet-friendly:
  

  


  Nightly Rate:
   $

  
  Weekly Rate:
   $

  


  Bedroom 1:
  

  
  Bedroom 2:
  

  


  Bedroom 3:
  

  
  Bedroom 4:
  

  


  Bedroom 5:
  

  
  Sleep Sofa:
  

  


  Loft:
  

  
  Dishwasher:
  


  Microwave:
  
  Air Conditioning:
  


  Stereo/CD Player:
  
  TV:
  

  


  VCR:
  
  Washer/Dryer:
  

  


  Deck/Porch:
  
  Grill:
  

  


  View:
  

  
  Fireplace Style:
  

  


  
Description:
  #cabinsDescription#

  


  

  

  

  







~~
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: Form Variables not being passed on selected machines

2001-03-28 Thread Jason Lees (National Express)


Have you Checked that the form method is set to post?


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2001 11:57
To: CF-Talk
Subject: Form Variables not being passed on selected machines


All of a sudden, I have a situation where form variables are not being
passed to the action template of a fairly basic form.

Out of 300 users, I guess a handful of them get an error when the action
template tries to evaluate the variables.

I've checked the security settings in Explorer and they seem ok.  Some have
IE4 some have IE5 running on NT4.  There is no pattern with the browser
version.

Any ideas?



Craig Wilson
Business Analyst
Business Applications
VOLKSWAGEN FINANCIAL SERVICES (UK) LIMITED

Work:   +44 (0)1908 485229
Fax:+44 (0)1908 549296
Mail:   mailto:[EMAIL PROTECTED]




**

The opinions expressed in this E-mail are those  of  the individual  and
not  necessarily  the  company.  This E-mail and  any files transmitted 
with it are confidential and solely for the use of the intended recipients


**
~~
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



OT:Converting CFML to WML

2001-03-27 Thread Jason Lees (National Express)


Hi All,

Is it an easy job to convert CFML pages to WML?

Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: Is this possible?

2001-03-26 Thread Jason Lees (National Express)


Just done some refining of the code. This will work, as long as you are
holding the validation results in a Query.

THe previosu version doesn't work because I was assuming that Item2 was an
object, but its not its a literal. 


function Check_Items(Item1,Item2){
if (Item1.value!='')
return;

if (Item1.value!=Item2){
alert ("These contradict the DB")
Item1.focus();
}
    return;
}







Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 15:34
To: CF-Talk
Subject: Is this possible?


Hey all,

Is it possible to determine what a user has inputted in a form BEFORE the 
form is submitted? What I would like to do is IF a user makes a selection in

the form that conflicts with information already in the db, I want to have a

javascript popup alert them to the discrepancy and have them verify if they 
want to continue. Otherwise, just a regular submit button would be 
displayed.

I have the javascript alert/confirm working alright, but I can't figure out 
how to get it to check the formfields and only display conditionally. I 
don't even think this is possible, considering that CF is server-side and 
essentially what I want to do is have CF determine what was selected BEFORE 
it is submitted. Is there a way I can determine this with JavaScript (I'm 
not very good at JS, so "baby steps", please ;).

I know I could do this within CF and just have the form submit to an interim

confirmation page, but I would rather do this on the client.

Thanks!
Terri
~~
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: Is this possible?

2001-03-26 Thread Jason Lees (National Express)


what Terri could so is query the DB on loading the page, then validate the
answers with a simple JS function.


function Check_Items(Item1,Item2){
if (Item1.value!=Item2.value){
alert ("These contradict the DB")
Item1.setfocus();
}
return;
}


then in the page



this should work, you might have to wrap round a CFOutput, round the Input
tag.

In theory it should work, give it a try and let me know.

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 16:00
To: CF-Talk
Subject: RE: Is this possible?


But Terri wants to compare the client-side form element values to what's in
the 
db.  In order to do this, she'll have to get the db info into JS.  She could

query for the data and then convert it to JS via CFWDDX ACTION=CFML2JS.
-David

On Monday, March 26, 2001 6:40 AM, Dylan Bromby [SMTP:[EMAIL PROTECTED]]
wrote:
> yes you can do this. you can reference the form elements by object name.
you
> don't have to submit the form to validate or check values. you can do it
> using onFocus and/or onBlur.
>
> -Original Message-
> From: Terri Stocke [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 6:34 AM
> To: CF-Talk
> Subject: Is this possible?
>
>
> Hey all,
>
> Is it possible to determine what a user has inputted in a form BEFORE the
> form is submitted? What I would like to do is IF a user makes a selection
in
> the form that conflicts with information already in the db, I want to have
a
> javascript popup alert them to the discrepancy and have them verify if
they
> want to continue. Otherwise, just a regular submit button would be
> displayed.
>
> I have the javascript alert/confirm working alright, but I can't figure
out
> how to get it to check the formfields and only display conditionally. I
> don't even think this is possible, considering that CF is server-side and
> essentially what I want to do is have CF determine what was selected
BEFORE
> it is submitted. Is there a way I can determine this with JavaScript (I'm
> not very good at JS, so "baby steps", please ;).
>
> I know I could do this within CF and just have the form submit to an
interim
> confirmation page, but I would rather do this on the client.
>
> Thanks!
> Terri
>
~~
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: CF Status in UK

2001-03-26 Thread Jason Lees (National Express)


CF is not as big in the UK as it is in the states, also most companies tend
to train there own IT staff in CF as its quite easy to use.

If yopu are looking for contract work It might be worth registering with a
couple of recruitment agencies, they may well be able to place you much
easier and quicker, I would suggest Computer Futures
(www.computerfutures.co.uk), mainly becuase they have offices nationwide.

I had an interview with Novasoft myself, about a year ago, I wasn't
impressed with what they where offering.

Good Luck,

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 09:44
To: CF-Talk
Subject: CF Status in UK


Hi,

Could anybody tell me how is ColdFusion doing in UK? Is it not in demand
here now?

Actually, I came here in UK from India on 29th Jan., 2001 as a Software
Consultant through NovaSoft Info. Tech. (Europe) Ltd.
(http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire
Software Professionals from India and place them here on Contract basis. My
main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL,
Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites
using ColdFusion. 

Now almost two months have been completed and I am still on Bench. Not only
myself, there are other 4 ColdFusion professionals they are also on bench.
NovaSoft is not able to place anybody. What they are saying is that there is
no market for ColdFusion in UK now and the situation will remain same for
next 5-6 months atleast. I have already wasted almost 2 months for the
process for coming to UK and 2 months on bench and if the situation is going
to remain for next 5-6 months, it is going to spoil my career very badly.
Moreover, company might take some harsh decisions also. I am in great
dilemma now-a-days. 

Could you please tell me the status of ColdFusion in UK or could anybody
guide me overcoming this problem? Any kind of help/suggestion is welcome. 

Thanks and Regards,
Rajesh Kumar





For Valentine's Day shop by Brand, Product, Price, Store and Location!
http://shop.storerunner.com/shop.asp?pdef=home&trsid=3080
~~
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: Help please

2001-03-23 Thread Jason Lees (National Express)


Dont just stick to Web based tools, get to grips with conventional
programming languages as well, such as VB, C++, JAVA. and others.

Even if its just a matter of installing a standard edition of the software
and getting to grips with the syntax and format and quirks of the language.

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 15:33
To: CF-Talk
Subject: Re: Help please


Personally, my advice is to learn everything.  That way you can go one way
or the other.  Makes you available for
multiple jobs, as well as some places that need multiple skills.

At this point and time, most of the work appears to be in ASP, and there's a
healthy chunk of Perl out there.
Though you don't wait until you need to a job to learn these skills; it's
hard to learn enough fast enough.  Always
think forwards.

"Suggest a way out"?  McDonald's is always hiring.   :)

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Venkata Ramakrishna wrote:

> Hi gang,
> Iam a Cf guy since 1.5 years.I changed my company
> expecting a assignment in US.As the market slowed down
> there,my new employer is making me sit at his place.
> The problem is that he don't have any CF work and the
> other teams wont allow me inside their domain.
>
> Should i stick with CF or change to some other
> domain?Whats the trend at US?
> Can someone suggest a way out until the US markets
> gear up again?
>
> Expecting some serious suggestions.
>
> Thank you.
>
> Ramakrishna
>
~~
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: Calling Custom Tags in

2001-03-23 Thread Jason Lees (National Express)


I thought as much but just wanted to make sure I'd not missed an
undocumented feature.

Roll on CF5.0!!!!!


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:51
To: CF-Talk
Subject: RE: Calling Custom Tags in 


> How would you convert the CF_Foo into the cfscript block?

You can't. :|

You can't use any cf tags within cfscript

One of the many limitations of cfscript - which is a shame.




---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-----
> From: Jason Lees (National Express)
> [mailto:[EMAIL PROTECTED]]
> Sent: 23 March 2001 12:59
> To: CF-Talk
> Subject: Calling Custom Tags in 
> 
> 
> 
> Hi All,
> 
> In CF Version 4.5 is it possible to call a custom Tag from with in a
> CFScript block
> 
> EG
> 
> 
> 
> 
> 
> the x^2 = #y#
> 
> How would you convert the CF_Foo into the cfscript block?
> 
> 
> Jason Lees 
> National Express
> Email : [EMAIL PROTECTED]
> 
> ###
> This document is intended for, and should only be read by, 
> those persons to
> whom it is addressed. Its contents are confidential and if 
> you have received
> this message in error, please notify us immediately by 
> telephone on 0121 609 6301
> and delete all records of the message from your computer. Any 
> form of reproduction,
> dissemination, copying, disclosure, modification, 
> distribution and / or
> publication of this message without our prior written consent 
> is strictly
> prohibited. Neither the author of this message nor their 
> employers accept
> legal responsibility for the contents of the message. Any 
> views or opinions
> presented are solely those of the author.
> If you have any queries please contact 
> [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



Calling Custom Tags in

2001-03-23 Thread Jason Lees (National Express)


Hi All,

In CF Version 4.5 is it possible to call a custom Tag from with in a
CFScript block

EG





the x^2 = #y#

How would you convert the CF_Foo into the cfscript block?


Jason Lees 
National Express
Email : [EMAIL PROTECTED]

###
This document is intended for, and should only be read by, those persons to
whom it is addressed. Its contents are confidential and if you have received
this message in error, please notify us immediately by telephone on 0121 609 6301
and delete all records of the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and / or
publication of this message without our prior written consent is strictly
prohibited. Neither the author of this message nor their employers accept
legal responsibility for the contents of the message. Any views or opinions
presented are solely those of the author.
If you have any queries please contact [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: loop in

2001-03-22 Thread Jason Lees (National Express)


Sorry I've had my 'C++' and Java hat on recently and forgot that CF doesnt
like the k++.  My fault.

use k=k+1 
and replace 0 with 1, should work then.

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 16:02
To: CF-Talk
Subject: RE: loop in 


It won't work, besides, for CF, array start with 1 not 0.

Thanks though.

Mei

-Original Message-----
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 10:45 AM
To: CF-Talk
Subject: RE: loop in 



cant you use a 

arrayYes=Arraynew(1);
for (k=0;k lte varlength;k++)
arrayYes[k]=(#SomeNum[k]#/#othernum[k]#)*100;





Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 15:33
To: CF-Talk
Subject: loop in 


Can someone please tell me where I can find the resource about how
to loop inside  instead of ?

My problem is:

I have use the combination of 

arrayYes = ArrayNew(1);


  


// someNum and otherNum has been defined and assigned values in the same
pages
   before with template, but when I run it, it says: can not convert
number...

// when I look up CF book, it says, 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: loop in

2001-03-22 Thread Jason Lees (National Express)


cant you use a 

arrayYes=Arraynew(1);
for (k=0;k lte varlength;k++)
arrayYes[k]=(#SomeNum[k]#/#othernum[k]#)*100;





Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 15:33
To: CF-Talk
Subject: loop in 


Can someone please tell me where I can find the resource about how
to loop inside  instead of ?

My problem is:

I have use the combination of 

arrayYes = ArrayNew(1);


  


// someNum and otherNum has been defined and assigned values in the same
pages
   before with template, but when I run it, it says: can not convert
number...

// when I look up CF book, it says, 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: HTML problem

2001-03-22 Thread Jason Lees (National Express)


Try the reverse, Ie make the image 1024x768 then use HTML to shrink to
800x600.  

This should solve the problem, it may be a little blured I'm not sure.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2001 08:22
To: CF-Talk
Subject: HTML problem


Hi All,
This is not a javascript or coldfusion question, but i
thought someone might be able to help and/or suggest
something.
I'm creating this web page, that our graphics designer
has already designed using photoshop for 800X600
resolution.  He cut up the images using Fireworks and
has given them to me.  Now our problem is this:
We want the images to enlarge to fit to screen when we
use a higher resolution.  What i did was i put them in
a table and made the table width 100% so that it fits
to screen.  When i did that the table stretched to fit
to screen but the images stayed the same size and i
had these big white gaps inbetween each image.  I then
tried specifying the images width=100% so that it can
stretch as well.  What happened was it did stretch but
the resolution went way down and the images were
really fuzzy.
So, my question is, is there a way to get the images
to stretch but still stay clear? or does our graphics
designer have to redo the images with a higher
resolution in mind?
Thanks!
Heidi 

=
Heidi Belal
ICQ# 32127109
http://m3.easyspace.com/hmbelal

A bus stops at a bus station.
A train stops at a train station.  On my desk
I have a work station...
~~
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: Previous date

2001-03-21 Thread Jason Lees (National Express)


use the function CreateTimeSpan

Yesterday=DateFormat(Now()-CreatetimeSpan(1,0,0,0),"MM/DD/YY")


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: monika kon [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 16:03
To: CF-Talk
Subject: Previous date


Hi !
Can any one please tell me how can I display the
previous date. For example if today is '03/21/01' then
I have to display '03/20/01'. Is there any function
which I can use. 

Shally
~~
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: Win2k

2001-03-21 Thread Jason Lees (National Express)


So Far we've not had any problems with the CF on a Win2k server (+1Month),
but the hits are quiet low. 

However I've seen posts from others on the lists that have noted problems
though.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 15:31
To: CF-Talk
Subject: Win2k


Anyone had any experience of Coldfusion (proffesional) running on a 2K
server ?
We're thinking of moving to that from NT4, and was wundering if there were
any issues (speed, lag etc.) that would make this a Good Thing, or weather
it all just gets rosy and faster ?

Regards,

Thomas Chiverton,
Intranet Architect and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...
~~
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: [RE: To ASP or not to ASP]

2001-03-21 Thread Jason Lees (National Express)


Why not take the best of both worlds and cerate templates that use CF and
ASP!!


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 15:24
To: CF-Talk
Subject: RE: [RE: To ASP or not to ASP]


Especially if they live in Trinidad where most IT firms don't even know what
COld Fusion is :)

-Gel
www.carigamer.com


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]

Anyone who relies solely on CF for marketability is in trouble already.
~~
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: Can we do another select on a cfquery resultset?

2001-03-21 Thread Jason Lees (National Express)


as far as I'm aware this facility is Only available in CF5.0, unless you
loop through the entire collection.


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 12:54
To: CF-Talk
Subject: Can we do another select on a cfquery resultset?



hi 
   i was juz wondering if it is possible to do a select on the resultset
returned from ?
~~
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: cfloop

2001-03-13 Thread Jason Lees (National Express)


Have you tried


  Or use a CFLoop

http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data
#&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#">




Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 16:19
To: CF-Talk
Subject: cfloop


>From a select box I am selecting a single vehicle or all vehicles and pass
the parameter to a second template which determines my vairables type of
existence,








SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   vowner = 222






SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   callsign = '#form.callsign#'



Then I am passing to a second server to get the vehicle positioning,
I wanted to do this the proper way with cfhttp, but due to buggy problems
with 4.5.1 and cfhttp

I have done it this way,








http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data
#&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#">


This is fine for one vehicle, but for multable I still only get the first
vehicle in the recordset, even though I loop through my query for the
existence of all.

If I test my looped query like so,







http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#&data=#data
#&zoom=#zoom#&x=#qry_getVeichle.lon#&y=#qry_getVeichle.lat#&symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#">



the obvious happens I get multable vehieles displayed but on multible maps,
(I know, duuu!!)

so I think that my problem lies somewhere around

startrow="#start#" endrow="#max#" which works fine when outputting to html

or else the problems with the 'mapview.exe' which would be a completely
different issue.

If some one could send me in the right direction with my cfloop though, it
would be mighty appreciated.

Thanx world..
~~
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: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Jason Lees (National Express)


You can always run them through dreamweaver before commiting them to disk
(esp the word files).

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: 07 March 2001 14:37
To: CF-Talk
Subject: Re: Converting Docs and Powerpoint files to html or pdf using
CF?


> If they are using Word or Powerpoint 2000 all they have to do si save the
> file as an HTML file.


Have you ever looked at the quality of the code that method generates?
~~
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



  1   2   >