Re: Wierd regex problem (isn't it always)

2007-11-09 Thread Andy Jarrett
Thanks guys for all your help its been a good regex learning
experience as usual for me :)

@Ben yours is the one i've gone with thank for the comments and explanation

Andy J


On Nov 7, 2007 8:24 PM, Ben Doom <[EMAIL PROTECTED]> wrote:
> A handful of comments:
>
> Backreferencing a single, static character is silly.  It just wastes
> memory and processor time.  You're throwing it away, anyway.
>
> {1} is useless.  It means "one of".  Which would just be the thing by
> itself.
>
> Second, {1,} is more commonly written +.  Also, you are saying "one or
> more backreferenced things" instead of "one or more backreferenced things.
>
> I'd write it like this:
> @([a-zA-Z0-9]+)
> Then use the first backreference instead of the second.
>
> --Ben Doom
>
>
> Andy Jarrett wrote:
> > Hi
> >
> > I'm trying to do a look through as string to find usernames and add
> >  tags around them ala Twitter.
> >
> > The regex I think is fine but when I use reReplace 's back reference
> > I'm not getting the result I thought I would of. Heres the code. Can
> > anyone see anything obvious?
> >
> > Cheers, Andy
> >
> >
> > 
> > 
> > #str#
> >
> >
> > 
> > 
> >
> > 
> > \2", "all") >
> >
> > #usernamePos#
> >
> >
>
> 

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293019
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Wierd regex problem (isn't it always)

2007-11-07 Thread Andy Jarrett
Hi

I'm trying to do a look through as string to find usernames and add
 tags around them ala Twitter.

The regex I think is fine but when I use reReplace 's back reference
I'm not getting the result I thought I would of. Heres the code. Can
anyone see anything obvious?

Cheers, Andy




#str#   






\2", "all") >

#usernamePos#

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292863
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


AS400 program calls errors

2007-02-08 Thread Andy Jarrett
Hi there

I have two calls to a AS400, they both call the same program but using
different methods and returning different errors.

Both programs expect a string of 7 blank character i.e. '   '

First:
The Call

{CALL libraryName.programName('   ')}


The Error
Error Executing Database Query.
[RPG9001] Error RPG0233 caused program programName to stop.


Second:
The Call




The Error
Error Executing Database Query.
[SQL0204] programName in libraryName type *N not found.



As you can see I'm not a AS400 guy, at all! But I figured these two
calls did the same.

Can anyone see what I am missing. Or what the error messages mean?

Cheers

Andy J

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269128
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


dynamicly editing XML schema value

2006-09-07 Thread Andy Jarrett
Hi,

Has anyone had to edit the a XML XSD's value before parsing it?

I want to go from

http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="file.xsd">

to

http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="http://www.myXSDURL.com/file.xsd";>


The XML files are rather large so I don't want to just read them in
completly and run replace() on them if I don't have to but I can't see
another way.

I wouldn't want to do this at all but it seems that CF (rather xerces)
doesn't like the relative file locations for schemas.


Cheers

Andy J
www.andyjarrett.co.uk

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252370
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: The visible attribute with Flash forms

2006-07-23 Thread Andy Jarrett
Cheers !




On 20/07/06, Kelly Keith <[EMAIL PROTECTED]> wrote:
>
> When visible is set to false set the height to a negative number.
>
> -Original Message-
> From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 20, 2006 6:37 AM
> To: CF-Talk
> Subject: The visible attribute with Flash forms
>
> Does anyone know how to remove the white gap created when you set
> visible="false" in .
>
> The idea is that based on a selected the form will show 2 different
> radio buttons. With HTML and CSS this would be easy, but I can't see how
> to do this with the Flash Forms.
>
>
>
> I have the following bit of code as an example of what I am trying to do
>
> 
>
>
>Yes
>No
>
>
> value="1"
> label="Payment option 1"
>visible="{(myfield.text == 'Yes')?true:false}"/>
> value="2"
> label="Payment option 2"
>visible="{(myfield.text == 'Yes')?true:false}"/>
>
> value="3"
> label="Payment option 3"
>visible="{(myfield.text == 'No')?true:false}"/>
> value="4"
> label="Payment option 4"
>visible="{(myfield.text == 'No')?true:false}"/>
> 
>
> Cheers
>
> Andy J
> www.andyjarrett.co.uk
>
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247436
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


The visible attribute with Flash forms

2006-07-20 Thread Andy Jarrett
Does anyone know how to remove the white gap created when you set
visible="false" in .

The idea is that based on a selected the form will show 2 different
radio buttons. With HTML and CSS this would be easy, but I can't see
how to do this with the Flash Forms.



I have the following bit of code as an example of what I am trying to do




Yes
No









Cheers

Andy J
www.andyjarrett.co.uk

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247166
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfheader breaks my xml

2006-03-30 Thread Andy Jarrett
cheers rob



On 30/03/06, Rob Wilkerson <[EMAIL PROTECTED]> wrote:
> I'm not sure if this is relevant because I'm not sure how you're using
> your XML, but I use  instead of  and it works
> great:
>
> 
> 
>  ...myXML...
> 
>
> On 3/30/06, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I'm having some trouble create a valid XML document using cfheader to
> > change the page content.
> >
> > My simple file looks like this:
> >
> > xml.cfm
> >
> > 
> > 
> > 
> > 1
> > 
> > 
> >
> > I open this up and its valid. I know change the content type so the
> > file is passed as XML:
> >
> > 
> > 
> > 
> > 
> > 1
> > 
> > 
> >
> > This breaks the page. It seems that  adds three blank lines
> > to the top of the page.
> >
> > Has anyone else come across this problem?
> >
> > Cheers,
> >
> > Andy
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236538
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


cfheader breaks my xml

2006-03-30 Thread Andy Jarrett
Hi,

I'm having some trouble create a valid XML document using cfheader to
change the page content.

My simple file looks like this:

xml.cfm




1



I open this up and its valid. I know change the content type so the
file is passed as XML:





1



This breaks the page. It seems that  adds three blank lines
to the top of the page.

Has anyone else come across this problem?

Cheers,

Andy

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236529
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CFexecute calling directory

2006-03-10 Thread Andy Jarrett
Hi

I have a bat file which I am using CFexecute to run at
C:\batfolder\batfolder2\batFile.bat.

This calls another bat file and C:\batfolder\anotherBatFile.bat

The problem is CFexecute is calling these from
C:\CFusionMX7\runtime\bin and I want it to be calling if from the root
of C:\. Is there anyway I can change this behaviour?

Cheers, Andy

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234986
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CFreport problems

2006-02-09 Thread Andy Jarrett
Hi,

I was wondering if anyone could tell me what this means

"Report data binding error Error evaluating expression : textField_2
Source text : query.invon"

Te query im running is

SELECT DATE_FORMAT(c.invited_on, '%Y %M %D') AS 'invitedOn',
count(id) AS 'cnt'
FROM delegates c
WHERE c.company_id = 1
GROUP BY invitedOn


In the report (created by the wizard) it references the field as
'query.invitedOn', but when I run it I get the above error.

Cheers,

Andy J

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231716
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Bluedragon 6.1

2006-02-01 Thread Andy Jarrett
Cheers Gert, I've been playing around and it looks good.

To echo's Rick's comments, when you say one web, is that one website
or one web server?

Also will the community edition be allowed to be used for commercial
purposes (keeping within the one datasource rule?)

Cheers

Andy J
On 01/02/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> Gert,
>
> When you write "one Web" for the Professional version, are you
> referring to web servers or websites?
>
> Rick
>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230996
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Bluedragon 6.1

2006-02-01 Thread Andy Jarrett
Cheers Gert. Im downloading now. My only hold up is that it seems to
be in beta still and im looking for a fully fledged engine. With that
said im still gonna give it a go :o)

What are you future plans with railo in the way of pricing are you
planning on keeping this free?





On 01/02/06, Gert Franz <[EMAIL PROTECTED]> wrote:
> Hi Andy,
>
> Why don't you give Railo a try...
> The free community version can be redistributed.
>
> www.railo.ch
>
>  location="switzerland" function="railo core developer">
>
>
>
> -Ursprüngliche Nachricht-
> Von: Andy Jarrett [mailto:[EMAIL PROTECTED]
> Gesendet: Mittwoch, 1. Februar 2006 11:41
> An: CF-Talk
> Betreff: Re: Bluedragon 6.1
>
>
> I want to set up a cheap CF server, in a commercial enviorment, though
> the [internal] site won't acutally be generating any money. under the
> new 6.2 licence this will break the licence agreement
>
>
>
>
>
> On 31/01/06, Rick Root <[EMAIL PROTECTED]> wrote:
> > Andy Jarrett wrote:
> > > Hi,
> > >
> > > Does anybody have a copy of BD 6.1 (the free edition) which they
> > > could let me download please?
> >
> > Technically speaking, that would be illegal because you cannot
> > redistribute the free edition.
> >
> > That being said, why would you want 6.1?  Many bugs.
> >
> > Rick
> >
> >
> >
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230955
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: IE 7 beta is available

2006-02-01 Thread Andy Jarrett
Brad, fpr reference you might want to look at

http://extended64.com/blogs/rafael/archive/2005/07/28/1051.aspx

Like i said, reference only.



On 31/01/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
> It requires XP SP2.
>
> > -Original Message-
> > From: Brad Wood [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, January 31, 2006 4:27 PM
> > To: CF-Talk
> > Subject: RE: IE 7 beta is available
> >
> > Dang it-- I wanted to try it out on my work computer... but it is not
> > compatible with 2000.  One of my co-workers tried it on his
> > XP machine,
> > and apparently our site license for XP doesn't authenticate as a valid
> > install.
> >
> > Microsoft must not want me to see IE 7!
> >
> > Tricksy Hobbits'!
> >
> > ~Brad
>
> This transmission may contain information that is privileged, confidential 
> and/or exempt from disclosure under applicable law. If you are not the 
> intended recipient, you are hereby notified that any disclosure, copying, 
> distribution, or use of the information contained herein (including any 
> reliance thereon) is STRICTLY PROHIBITED. If you received this transmission 
> in error, please immediately contact the sender and destroy the material in 
> its entirety, whether in electronic or hard copy format. Thank you. A1.
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230927
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Bluedragon 6.1

2006-02-01 Thread Andy Jarrett
I want to set up a cheap CF server, in a commercial enviorment, though
the [internal] site won't acutally be generating any money. under the
new 6.2 licence this will break the licence agreement





On 31/01/06, Rick Root <[EMAIL PROTECTED]> wrote:
> Andy Jarrett wrote:
> > Hi,
> >
> > Does anybody have a copy of BD 6.1 (the free edition) which they could
> > let me download please?
>
> Technically speaking, that would be illegal because you cannot
> redistribute the free edition.
>
> That being said, why would you want 6.1?  Many bugs.
>
> Rick
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230926
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Bluedragon 6.1

2006-01-31 Thread Andy Jarrett
Hi,

Does anybody have a copy of BD 6.1 (the free edition) which they could
let me download please?

Cheers

Andy J
--
www.andyjarrett.co.uk

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230850
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Coldfuion Life Spam

2006-01-26 Thread Andy Jarrett
I was talking to someone today who has said that now adobe has taken over 
macromedia that they will consentrate on flash and the life of coldfusion will 
becoming to an end. I am about to build a major system using coldfusion but the 
company now has doubts over the future of coldfusion.
I know its not going anywhere but is there anything I can provide to this 
company to stop there fears.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230467
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


incorrect pound sign (£)

2005-11-29 Thread Andy Jarrett
HELP !!!

everything was running fine until we moved to coldfusion mx (6.1) and upgraded 
our MySQL from 3.x to 4.1.

Every time we post data to a text field the pound sign shows correctly but when 
we output it using coldfsuion is appears as a 'a' symbol with a tick above it. 
when i send it to a pdf it appears as a question mark. it will not output as a 
pound sign.

Does anyone know how to correct this problem?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225525
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CF talking to a DMZ server

2005-11-18 Thread Andy Jarrett
Hi there,

The company i work for are having a host of problems with a dedicated
CFMX 7.01 box and one of our own servers in a DMZ.

Currently we use the DMZ for AS400 and other DB lookups. We have some
java classes and web services sitting on the DMZ which invoked goes of
and makes its calls. The issue is that sometime the webservice isn't
getting a response (another matter all together). And with that the CF
services just hang and become unresponsive, regardless of the timeout
settings in the Admin or on the page etc.

At this point we take offline and restart the web services on the DMZ
box and instantly the CF box start being responsive.

We've had the same problem with a MSSQL box sitting in the DMZ. If
that ever went off line CF again became unresponsive and hung instead
of showing any messages.

Has anyone come across this, or got a solution?


Many thanks, Andy J

www.andyjarrett.co.uk

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224609
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


cfcatching timeouts

2005-10-26 Thread Andy Jarrett
Hi,

I have a stored procedure running which can take ages. I've set the
page time out 20seconds, but now was to be able to catch the error.

The following code works and displays "error"







ERROR




But by replacing "error" with cfcatch.message
just throws back a CF error
"The request has exceeded the allowable time limit Tag: cfoutput"

Is there any way to gracefully catch the stroed procedure timing out?
or page timeout?

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:77
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: MSSQL and CF connections

2005-10-06 Thread Andy Jarrett
Hi Kola,

First of we are running CFMX 7 on a fairly busy (dedicated) server.

I did think about checking running some scheduled code to check if the
server is there, but im more concerned if the MSSQL services are
actually running. I don't want to connect to the Datasource as that
"seems" to be were we are getting the hang ups.

I suppose if could ping the server and port see if its there first
actually without using the datasource.

Cheers, Andy



On 10/5/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Andy
>
> What would you like to do if you can't connect to the database? What version
> of cf and how many apps on the server?
>
> Just a suggestion if you're using cfmx7 - You could use the admin api to
> disable datasources to prevent any other applications trying to connect to
> the server, it would result in all your applications throwing more errors -
> (if you're happy for this to happen as long as cf stays up then it may not
> be much of a problem assumming you have some error handling in place)  you
> could then run some code which continually attempts to connect to the
> database (as well as notifying you *once* by email that it cant connect)
> once it connects it could then re-enable the datasources.
>
> Just a suggestion, haven't tried it myself
>
> Kola
>
>
> > -Original Message-
> > From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> > Sent: 05 October 2005 12:05
> > To: CF-Talk
> > Subject: MSSQL and CF connections
> >
> > Hi
> >
> > I am currently running a MSSQL sever in a DMZ setup with an externally
> > hosted website. The problem is due to a driver error the DMZ has been
> > rebooting recently and when it does the CF box comes down with it
> > (just the CF services).
> >
> > The problem i think is down to ColdFusion coldfusion not being about
> > to connect to the SQL server. When this happends it is getting
> > overloaded with conenctions waiting for a response bring CF down.
> >
> > Has anyone else been in this situation, how have you resolved it?
> >
> > I've looked at the "Limit Connections" and "Timeout (min)" under
> > datasources and was wondering what would be a good optimal for these
> > in this situation?
> >
> > Many thanks, Andy
> >
> > www.andyjarrett.co.uk
> >
> > ~
> >
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220185
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


MSSQL and CF connections

2005-10-05 Thread Andy Jarrett
Hi

I am currently running a MSSQL sever in a DMZ setup with an externally
hosted website. The problem is due to a driver error the DMZ has been
rebooting recently and when it does the CF box comes down with it
(just the CF services).

The problem i think is down to ColdFusion coldfusion not being about
to connect to the SQL server. When this happends it is getting
overloaded with conenctions waiting for a response bring CF down.

Has anyone else been in this situation, how have you resolved it?

I've looked at the "Limit Connections" and "Timeout (min)" under
datasources and was wondering what would be a good optimal for these
in this situation?

Many thanks, Andy

www.andyjarrett.co.uk

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220111
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: When to use Application var?

2005-09-14 Thread Andy Jarrett
We've got a dedicated machine with quite a bit of Ram - so its not an
issue, and at the moment we have about 20-30 sites running of about 10
code bases.

So for each of those sites they have their own app name and app
variables, hence the first line in my code checking the URL.

I suppose my question more is - is it better to keep using the
app.scope when i can just get the information from the cached query.
I'm also thinking in shared hosting enviroments as well?

Andy J







The information doesnt change much at all 
On 9/14/05, Andy McShane <[EMAIL PROTECTED]> wrote:
> Personally, if your information is unlikely to change on any regular basis
> then I would use the application scope. As for having too much in the
> app.scope I suppose it really depends on the machine and how much memory you
> have to play with. If what you have below is all that have in the app scope
> then there should be no problem at all.
> 
> -----Original Message-
> From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> Sent: 14 September 2005 10:08
> To: CF-Talk
> Subject: When to use Application var?
> 
> I have a bit of code on a smallish, low hit site
> 
> 
> 
> 
> 
> 
> SELECT *
> FROM companydetails c
> WHERE c.company_folder = '#thisSiteName#'
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> It just sets up some basic site wide vars - nothing special. What im
> thinking though is that this is just a bad use of the application
> scope? Surely i could just use
> 
>   cachedWithin="#createTimeSpan(2,0,0,0)#">
> SELECT *
> FROM companydetails c
> WHERE c.company_folder = '#thisSiteName#'
> 
> 
> 
> 
> 
> 
> 
> 
> Which would save the having too much in the app.scope?
> 
> Am i missing something obvious? What would/does everyone else do?
> 
> Andy J
> www.andyjarrett.co.uk
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218170
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


When to use Application var?

2005-09-14 Thread Andy Jarrett
I have a bit of code on a smallish, low hit site






SELECT * 
FROM companydetails c
WHERE c.company_folder = '#thisSiteName#'






 



It just sets up some basic site wide vars - nothing special. What im
thinking though is that this is just a bad use of the application
scope? Surely i could just use


SELECT * 
FROM companydetails c
WHERE c.company_folder = '#thisSiteName#'








Which would save the having too much in the app.scope?

Am i missing something obvious? What would/does everyone else do?

Andy J
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218163
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Cfrig problems

2005-08-08 Thread Andy Jarrett
Obviously i have no coldfuion rigging problem and the subject line is
meant to say CFGRID

D'oh

On 8/8/05, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> Hi again,
> 
> Ok newish here to the new flash CFGRID and so far liking it, but I am
> having a few issues though
> 
> 1. I have 1 editable column. When a user edits the field then loses
> focus you cannot see the information just typed - is this a bug or
> meant to happen?
> 
> 2. When they to blur off the field i would like to do some basic (is
> numeric) validation - how do i do this? I know i can with
> actionscript, but i don't know how to pass the value out and run the
> validation.
> 
> Im sure there is one more but i cannot think of it at the moment. D'oh
> 
> Cheers,
> 
> Andy J
> 


-- 
Andy J
www.andyjarrett.co.uk

I had 50 Gmail Invites, i got rid of them, i now have 50 more.
If you want any amount drop me a line

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213998
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Cfrig problems

2005-08-08 Thread Andy Jarrett
Hi again,

Ok newish here to the new flash CFGRID and so far liking it, but I am
having a few issues though

1. I have 1 editable column. When a user edits the field then loses
focus you cannot see the information just typed - is this a bug or
meant to happen?

2. When they to blur off the field i would like to do some basic (is
numeric) validation - how do i do this? I know i can with
actionscript, but i don't know how to pass the value out and run the
validation.

Im sure there is one more but i cannot think of it at the moment. D'oh

Cheers, 

Andy J

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213997
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


cfgridupdate and fusebox

2005-08-08 Thread Andy Jarrett
Hi there,

Has anyone successfully used cfgridupdate and fusebox together? 

The reason i ask is that at the moment when i post the cfgrid to a
fuseaction the gridupdate (within a CFC or as a single fuse(file))
cannot find the grid name. Yet if i post directly an act_file it has
no problem.

Im guessing it is probably to do with the way FB handle form vars -
but i was just wondering if anyone else has had any experience with
this?

Andy J
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213996
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: 15 minute rule

2005-08-04 Thread Andy Jarrett
A little harsh on the couple of last statements there James :o) but true.

I know what you mean though, the office enviorment is full of too many
distractions to do solid work. Home is definately better, but sometime
the hustle and bustle is missed





On 8/4/05, James Holmes <[EMAIL PROTECTED]> wrote:
> I admit that I've wasted an hour or two on problems that weren't
> really problems, that may have been caught by someone who was around
> to hear me scream obscenities at the machine, but there are so many
> benefits of working from home that far outweigh that one drawback for
> me (e.g. not wasting hours being interrupted by those who have
> mistaken me for someone who actually wants to discuss their favourite
> group of people who skillfully hit a ball with a stick on the weekend
> etc etc).
> 
> On 8/4/05, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> > Pete, same here in regards to the one man band. Its probably one of
> > the biggest draw backs working from home, and one of the reasons i
> > sometimes enjoy having to work up in the offices (though im still the
> > only CF guy there).
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213713
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: 15 minute rule

2005-08-04 Thread Andy Jarrett
Pete, same here in regards to the one man band. Its probably one of
the biggest draw backs working from home, and one of the reasons i
sometimes enjoy having to work up in the offices (though im still the
only CF guy there).

My 15 min rule is probably moving away from the error, making a black
coffee, then coming back and hitting the lists to solve it. Failure to
resolve my issue will probably mean regretting throwing my laptop out
of the window at a later date :o) or less drastically banging my mouse
up and down on the desk until realising its that i don't want to break
it as my shortcut keys knowledge is crap.

Andy J
www.andyjarrett.co.uk






On 8/4/05, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
> I'd kill to have another developer in the office to bounce that sort
> of stuff off of.
> 
> Alas, I am a one man band.  Developer.  Designer.  DBA.  Sysadmin.
> Exchange server admin.  IT guy.  Facilities manager.
> 
> Pete
> 
> On 8/3/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> > I really dunno what you guys are talkin' about. My code is always perfect. 
> > Everything works first run. I've never seen a CF error (What do they look 
> > like?) Could someone please send me a screen cap? I've even TRIED to create 
> > an error, and I just cannot do it! Maybe you could even include some faulty 
> > code and I'll run it?
> >
> > :)
> >
> > Will
> >
> >
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213701
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ColdFusion Exam

2005-07-21 Thread Andy Jarrett
Thats the book i've just brought and waiting to be delivered :o)



On 7/21/05, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I'd also suggest Ben's study guide. An excellent resource in general too.
> 
> http://forta.com/books/0321330110/
> 
> Will
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212465
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


ColdFusion Exam

2005-07-21 Thread Andy Jarrett
Hi,

Well i've just found out i've got a MM test centre on my doorstop so i
have no excuse to not go for the CFMX exam. So with the book ordered i
was thinking of an exam date.

How long did everyone else give themselves to study?? weeks, months, days???

I know its a bit of a open question as it depends on work load - im
just being curious more than anything.

Also has anyone used CF exam buster to study (it was there spam this
morning which prompted a look around)

Cheers, Andy J

www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212435
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Jrun connection closing for no reason

2005-07-05 Thread Andy Jarrett
Cheers for the Reply. 

At the moment (and im knocking on wood here) all is going well. We did
think that it might be a SQL connection problem.

In a nutshell we applied the 6.1 updater and left it at that which for
now is holding :o)

Cheers for the posts

Andy J

On 6/30/05, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> Yes, it is a common error - can be caused by a number of things.
> 
> 1. Simultaneous connections has been reached
> 2. Server is too busy to handle requests
> 3. Long running query has not times out leading to JRun not serving requests
> 4. Not patched with latest Web Connectors.
> 
> 
> 
> -----Original Message-
> From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> Sent: 30 June 2005 12:07
> To: CF-Talk
> Subject: Jrun connection closing for no reason
> 
> Hi there,
> 
> at the moment we are getting a few of the following errors
> 
> Server Error
> The server encountered an internal error and was unable to complete
> your request.
> JRun closed connection.
> 
> The problem is that they are not *that* regular and nothing from the
> logs is jumping out at us.
> 
> Has anyone had this problem, or something similar?
> 
> We have CFMX 6.1 on Window 2003
> 
> Cheers
> 
> Andy Jarrett
> 
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:24
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Jrun connection closing for no reason

2005-06-30 Thread Andy Jarrett
Hi there,

at the moment we are getting a few of the following errors

Server Error
The server encountered an internal error and was unable to complete
your request.
JRun closed connection.

The problem is that they are not *that* regular and nothing from the
logs is jumping out at us.

Has anyone had this problem, or something similar? 

We have CFMX 6.1 on Window 2003

Cheers

Andy Jarrett

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210945
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Crystal Reports is hurting my head

2005-06-24 Thread Andy Jarrett
So my last three posts have all been about Crystal Reports. I can
honestly say its been the worst experience of getting something to
work with CF ever.

At the moment i have Crystall 11 and CFMX 6.1 on my dev machine.
Everytime i run the report i get the following message

An unexpected error occurred while using the Crystal Engine. Unable to
find error details file D:\My Documents\sites\cfr\ERROR.TXT, error
was: Error attempting to open file to be mapped.

I can only find one blog reference to this on the web/MM forums.
Business Objects says that they wont help as its a CF
issueaarrgg!

So i just wanted to know if anyone actually has this setup working? Or
what that error actually means?

Many thanks, Andy J

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210476
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Should you lock a cfreport

2005-06-21 Thread Andy Jarrett
Hi

Should you ever need to lock CFreport when calling a crystal report? 

At the moment i have a report which i pass it a parameter. Sometime
this can take a little while - though nothing majorly long. Should
this process be locked??

Just a thought,

Andy J
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210074
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Crystal reports

2005-06-09 Thread Andy Jarrett
Is anyone actually using CR XI on CFMX 6.1 or CFMX 7? 

Andy

> Hi there,
> 
> I cant seem to find this anywere but is it possible to pass parameters 
> to Crystal (11) via CFMX 6.1?
> 
> The report is expecting an ID to be passed to it i.e. 200 which in 
> turn passes to a Stored Procedure (on MSSQL) to create the query.
> 
> Cheers for any help
> 
> Andy J
> www.andyjarrrett.co.
uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209092
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Crystal reports

2005-06-08 Thread Andy Jarrett
Hi there,

I cant seem to find this anywere but is it possible to pass parameters to 
Crystal (11) via CFMX 6.1?

The report is expecting an ID to be passed to it i.e. 200 which in turn passes 
to a Stored Procedure (on MSSQL) to create the query.

Cheers for any help

Andy J
www.andyjarrrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209000
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


hierarchal invites

2005-05-12 Thread Andy Jarrett
Hi,

I've got a problem with one of my new sites. Im trying to create in
invite only site with a hierarchal level system in it.

So for example.

a invites b and c
b invites d,e,f and
c invites g,h,i

How to structure the DB is where im getting stuck? I can see a couple
of ways of doing it but to get all the users under 'a' would require a
stupid amount of cfqueries and cfloops.

Has anyone set up this kind of scenario or could give a few pointers ?

Cheers

-- 
Andy J
www.andyjarrett.co.uk

I had 50 Gmail Invites, i got rid of them, i now have 50 more.
If you want any amount drop me a line

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206509
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: link validation ?

2005-05-11 Thread Andy Jarrett
On 5/11/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Also, target="_blank" won't validate as strict.
> 
> Ade
> 

You beat me to it. But you can make it strict compliant with a bit of
Js, check out sitepoint.com

http://www.sitepoint.com/article/standards-compliant-world


-- 
Andy J
www.andyjarrett.co.uk

I had 50 Gmail Invites, i got rid of them, i now have 50 more.
If you want any amount drop me a line

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206322
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Crystal Reports on CFMX 6.1/7

2005-05-04 Thread Andy Jarrett
Hi,

Do i need to install the complete Crystal Reports 10 on the server to
user  as i currently have only got it working after doing so
(locally). Or is there just a couple of key componets (files) that
need installing??

Cheers

Andy J
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205552
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Is this possible with CSS

2005-04-28 Thread Andy Jarrett
Thanks everyone for those links - glad to know that it wasnt as easy
as i thought :o)

Sandy, your Skidoo links seem great - im trying the lean version now
but it seems to be doing the job well, thanks

Cheers

Andy J
www.andyjarrett.co.uk


On 4/27/05, Robert Redpath <[EMAIL PROTECTED]> wrote:
> Here a good resource.
> http://css-discuss.incutio.com/?page=ThreeColumnLayouts 
> <http://www.ftponline.com/reports/wdwsf/2005/bowman1/>
> 
> -Original Message-
> From: Connie DeCinko [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 27, 2005 1:35 PM
> To: CF-Talk
> Subject: RE: Is this possible with CSS
> 
> Making the page 100% height is tough and each browser interprets that
> differently.  You need to tell the page 100% of what?  In my case I had
> to
> add height 100% to the body tag as well.
> 
> -Original Message-
> From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 27, 2005 9:21 AM
> To: CF-Talk
> Subject: OT: Is this possible with CSS
> 
> Hi,
> 
> I am having a nightmare trying to replicate a 3 column site with CSS -
> it nearly make me want to use 's (did i say that out loud)
> 
> To see what i am trying to create go to
> http://andyjarrett.co.uk/css.gif
> 
> For those of you who you can i am trying to create a 3 column site
> with a header and footer.
> 
> h e a d e r
> -
> left col  | content  |  right col
> -
>  f o o t e r
> 
> The 3 middle columns should always be 100% of the gap between the
> header and footer. With the left and right columns being fixed. In
> tables it would be
> 
> 
>   
>  
>   
>   
>  
>  
>  
>   
>   
>  
>   
> 
> 
> I have seen some templates but they rely on the content column to be
> the longest. I have never found a solution as solid as the tables
> version.
> 
> Its gotta be do-able - actually its probably well easy but I'm just
> not seeing it.
> 
> Cheers for any help
> 
> Andy J
> www.andyjarrett.co.uk
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204886
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


OT: Is this possible with CSS

2005-04-27 Thread Andy Jarrett
Hi,

I am having a nightmare trying to replicate a 3 column site with CSS -
it nearly make me want to use 's (did i say that out loud)

To see what i am trying to create go to 
http://andyjarrett.co.uk/css.gif

For those of you who you can i am trying to create a 3 column site
with a header and footer.

h e a d e r 
-
left col  | content  |  right col
-
 f o o t e r

The 3 middle columns should always be 100% of the gap between the
header and footer. With the left and right columns being fixed. In
tables it would be


  
 
  
  
 
 
 
  
  
 
  



I have seen some templates but they rely on the content column to be
the longest. I have never found a solution as solid as the tables
version.

Its gotta be do-able - actually its probably well easy but I'm just
not seeing it.

Cheers for any help

Andy J
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204731
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Stored Procedures in a CFC

2005-03-03 Thread Andy Jarrett
I think for readability returning the values in a structure is going
to do a.k.a S.Isaac


...
...

But the idea of going through a function to get the different
recordsets, and referencing via the array would mean that there is no
need to know the name of the queries? defently beneficial.

Cheers everyone for you help

Andy





On Thu, 3 Mar 2005 17:17:48 -, Adrian Lynch
<[EMAIL PROTECTED]> wrote:
> Right, but in your getResult1() and getResult2() you access the key named in
> loadData(). That's what I'm saying(asking whether it's) bad. Would array
> syntax not hide better what loadData() does?
> 
> -Original Message-
> From: Marc Campeau [mailto:[EMAIL PROTECTED]
> Sent: 03 March 2005 17:04
> To: CF-Talk
> Subject: Re: Stored Procedures in a CFC
> 
> > The cfstoredproc tag will return both queries regardless, you could
> > construct the function to return one of the callers choosing, but from a
> > simplistic approach returning both in either an array or a structure seems
> > more useful. The point I was making was that you either reference them as:
> >
> > function()[1] and function()[2]
> >
> > or:
> >
> > function().resultsetOne and function().resultsetTwo
> >
> > one, the structure, exposes more about the function than the other, the
> > array.
> 
> I understand but I feel like they both expose too much to the application.
> ;)
> 
> I usually prefer structs becauses they're more literate but by
> "hiding" the resultsets in the CFC it doesn't matter whether you use
> an array, struct or whatever.
> 
> I would do this:
> component
>   private datasets = structNew();
>   private isLoaded  = false;
> 
>   private function loadData()
> if not isLoaded
>   sp
>  result1
>  result2
>   /sp
>   datasets.result1 = result1;
>   datasets.result2 = result2;
>   isLoaded = true;
> /if
> return;
>   /function
> 
>   private function getResult1()
> loadData();
> return datasets.result1;
>   /function
> 
>   private function getResult2()
> loadData();
> return datasets.result2;
>   /function
> /component
> 
> --
> Marc
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.300 / Virus Database: 266.6.0 - Release Date: 02/03/2005
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197324
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Stored Procedures in a CFC

2005-03-03 Thread Andy Jarrett
Hi there,

I have a SP wrapped in a CFC. The SP returns two record sets, which i use 
cfprocresult to reference. How do i then return the 2 queries via the CFC?

Cheers

Andy J
www.andyjarrett.co.uk


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197229
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: FB4 book? (was "RE: "Discovering FB4.1" book comparison to FB4.0 edition?")

2005-02-18 Thread Andy Jarrett
Just to add that i've just purchased "What's New in Fusebox 4.1" and
have got 2/3 coupons for "$5 off a purchase of $20 or more, courtesy
of CafePress.com"

So if anyone is thinking of doing a purchase let me know!

Andy J
www.andyjarrett.co.uk

On Fri, 18 Feb 2005 10:25:16 +, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> I just wanna second getting "Fusebox 4 and FLiP" by jeff peters.
> Online material for FB4 is slim - unless you want to scrounge through
> mailing lists, forums and hack through a couple of demo apps.
> 
> Andy J
> www.andyjarrett.co.uk
> 
> 
> On Fri, 18 Feb 2005 00:59:36 -0500, Brian Kotek <[EMAIL PROTECTED]> wrote:
> > Yes, Jeff's books are available at 
> > http://www.cafepress.com/protonarts/250818
> >
> > On Thu, 17 Feb 2005 22:51:55 -0500, Michael T. Tangorre
> > <[EMAIL PROTECTED]> wrote:
> > > > From: Damien McKenna [mailto:[EMAIL PROTECTED]
> > > > If the FB4.1 book hasn't shipped yet, what would be the recommended
> > > > choice for an FB4 book if I wanted something to read for the weekend?
> > >
> > > I would grab Jeff Peter's "Fusebox 4 and FLiP" along with the "What's New 
> > > in
> > > Fusebox 4.1"... although you have to order them both from proton arts.. I
> > > think.
> > >
> > >
> > >
> >
> > 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195354
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: FB4 book? (was "RE: "Discovering FB4.1" book comparison to FB4.0 edition?")

2005-02-18 Thread Andy Jarrett
I just wanna second getting "Fusebox 4 and FLiP" by jeff peters.
Online material for FB4 is slim - unless you want to scrounge through
mailing lists, forums and hack through a couple of demo apps.

Andy J
www.andyjarrett.co.uk






On Fri, 18 Feb 2005 00:59:36 -0500, Brian Kotek <[EMAIL PROTECTED]> wrote:
> Yes, Jeff's books are available at http://www.cafepress.com/protonarts/250818
> 
> On Thu, 17 Feb 2005 22:51:55 -0500, Michael T. Tangorre
> <[EMAIL PROTECTED]> wrote:
> > > From: Damien McKenna [mailto:[EMAIL PROTECTED]
> > > If the FB4.1 book hasn't shipped yet, what would be the recommended
> > > choice for an FB4 book if I wanted something to read for the weekend?
> >
> > I would grab Jeff Peter's "Fusebox 4 and FLiP" along with the "What's New in
> > Fusebox 4.1"... although you have to order them both from proton arts.. I
> > think.
> >
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195353
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF Hosting

2005-02-16 Thread Andy Jarrett
I did look at CFMX Hosting - but for what you pay you get nothing -
50mb webspace and MS Access DB.

The reason i personally went for CT was that with the "Intermediate"
plan you get 400mb and MySQL db etc - and with the conversion of $ to
£'s it works out cheaper (about £90 annually)

The reason for looking at Vuix was for a friend who wanted cheap
hosting with xchange rate it works out at only £30 - the equilivant to
some cheap ASP hosting providers overhere. Personally as long as it
has MySQL & CFMX 6.1 all is good. I know you get more if you pay more
- but some people don't need/care for it all - and it doesnt matter
how we say it.







On Wed, 16 Feb 2005 10:27:24 -, Mark Smyth
<[EMAIL PROTECTED]> wrote:
> I'd recommend
> 
> http://www.cfmxhosting.co.uk/
> 
> Reasonably priced with excellent support etc and a top notch control panel!
> 
> -Original Message-
> From: dave [mailto:[EMAIL PROTECTED]
> Sent: 16 February 2005 10:12
> To: CF-Talk
> Subject: re: CF Hosting
> 
> not too mention the user control panels are top notch plus now smartermail &
> smarterstats, its a good package :)
> 
> 
> From: Andy Jarrett <[EMAIL PROTECTED]>
> Sent: Wednesday, February 16, 2005 5:00 AM
> To: CF-Talk 
> Subject: CF Hosting
> 
> Hi there,
> 
> I've just came across Viux (www.vuix.com) for CF hosting and was wondering
> if anyone is using them or has used them?
> 
> Im already with CrystalTech, but was thinking of getting another domain w/
> hosting for a friend and for CF they seemed too cheap. Their Starter Plan
> (http://hosting.viux.com/webhosting/plan-starter.asp)
> starts at $55.84 yearly with
> 
> Microsoft Windows Server 2003
> Web Hosting Control Panel
> Internet Information Services (IIS 6 | .htm) ColdFusion MX v6.1 (CFML |
> ..cfm) ...NET Framework v1.1 (ASP.Net | .aspx) Active Server Pages (ASP |
> ..asp) VBScript / JScript PHP v4.3.10 (.php) ActivePerl v5.8.3 Build 809
> (Perl / CGI | .pl & .cgi) Private CGI-Bin Directory Server Side Includes
> 24 / 7 / 365 Unlimited FTP Updates
> Password Protected Directories (IISPassword / .htaccess) Custom 404 / Error
> Pages Domain Pointers: (4) Sub (Conical) Domains: (4)
> 
> Plus loads of other stuff?
> 
> Cheers
> 
> Andy
> www.andyjarrett.co.uk
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194916
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CF Hosting

2005-02-16 Thread Andy Jarrett
Hi there,

I've just came across Viux (www.vuix.com) for CF hosting and was
wondering if anyone is using them or has used them?

Im already with CrystalTech, but was thinking of getting another
domain w/ hosting for a friend and for CF they seemed too cheap. Their
Starter Plan (http://hosting.viux.com/webhosting/plan-starter.asp)
starts at $55.84 yearly with

Microsoft Windows Server 2003
Web Hosting Control Panel
Internet Information Services (IIS 6 | .htm)
ColdFusion MX v6.1 (CFML | .cfm)
..NET Framework v1.1 (ASP.Net | .aspx)
Active Server Pages (ASP | .asp)
VBScript / JScript
PHP v4.3.10 (.php)
ActivePerl v5.8.3 Build 809 (Perl / CGI | .pl & .cgi)
Private CGI-Bin Directory
Server Side Includes
24 / 7 / 365 Unlimited FTP Updates
Password Protected Directories (IISPassword / .htaccess)
Custom 404 / Error Pages
Domain Pointers: (4)
Sub (Conical) Domains: (4)

Plus loads of other stuff? 

Cheers

Andy 
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194911
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Cfgrid on CFMX 6.1

2005-02-04 Thread Andy Jarrett
Thanks for that,

I've found some relating to the certificate on  but nothing
directly to do with CFMX 6.1 and my error.

I was looking at 

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17883

Andy




On Fri, 4 Feb 2005 17:27:03 +0530, sathya v <[EMAIL PROTECTED]> wrote:
> Hi
> 
> there is some Hot fix for CFgrid iuuse in CFmx try install hotfix
> 
> 
> On Fri, 4 Feb 2005 08:58:25 +, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> > I've just moved an app from CF4.5 to CFMX 6.1. All seems fine except
> > for CFGRID. It is displaying fine but when i update the grid im
> > getting the following error message:
> >
> > Error casting an object of type to an incompatible type. This usually
> > indicates a programming error in Java, although it could also mean you
> > have tried to use a foreign object in a different way than it was
> > designed
> >
> > This only happens when i change a value. If i don't change anything
> > and hit submit all seems fine.
> >
> > Is it possible to write a SQL update for  or does it have to
> > go through ?
> >
> > Cheers
> >
> > Andy J
> > www.andyjarrett.co.uk
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193054
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Cfgrid on CFMX 6.1

2005-02-04 Thread Andy Jarrett
I've just moved an app from CF4.5 to CFMX 6.1. All seems fine except
for CFGRID. It is displaying fine but when i update the grid im
getting the following error message:

Error casting an object of type to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you
have tried to use a foreign object in a different way than it was
designed

This only happens when i change a value. If i don't change anything
and hit submit all seems fine.

Is it possible to write a SQL update for  or does it have to
go through ?

Cheers

Andy J
www.andyjarrett.co.uk

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193050
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Homesite enhancement project?

2005-01-13 Thread Andy Jarrett
I think if Homesite was available again it would take off big -
especially as a sourceforge (dare i say free) project. No doubt there
whatsoever, the tone of the board has shown this time and time again.
Surely the big problem would be to let MM release it? I can't see them
ever doing that for obvious reason of competetion?

I don't think the question should be "is it worth it", the CF
community is always more than happy to help. But will MM release it
from there grasp?

Andy
www.andyjarrett.co.uk

 



On Thu, 13 Jan 2005 10:17:14 -0500, Damien McKenna
<[EMAIL PROTECTED]> wrote:
> Would it be worthwhile starting a Sourceforge project to promote
> Homesite and to centralize development of Homesite enhancements?
> 
> I'm personally sick of Dreamweaver, I don't really like Eclipse (it
> isn't helped by some plugin developers not hosting their files
> correctly) and don't like any of the tonnes of other HTML editors out
> there.  So I'm back to Homesite but need some improvements in its
> handling of XHTML, PHP, CFML, etc.  A Sourceforge project where everyone
> could contribute in a centralized location would reduce duplicate
> efforts (only need one PHP syntax highlighter, etc) and give people a
> one-stop-shop for what they needed.
> 
> So, what do y'all thing?  Would it be worth my time trying this?
> 
> --
> Damien McKenna - Web Developer - [EMAIL PROTECTED]
> The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
> #include 
> 
> 

~|
Purchase Captivate from House of Fusion, a Macromedia Authorized Affiliate and 
support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=52

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190224
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: SQL

2004-12-20 Thread Andy Jarrett
Joe, Sorry, but to add to your solution another problem ( i don't do
this on purpose, promise). It will also return 0 where the is no user
there, in which case you get a false positive.

Mark, you'd have to do the counts as 2 different SQL's statements
which was something i was trying to avoid.

I've now created a UDF which checks the occurance of a word in a
string/list. So with the SQL

SELECT userId
WHERE userId = 'xx'

I am using ValueList() and my UDF for checking that the occurance of
pass equals the recordcount.

 






On Mon, 20 Dec 2004 13:45:59 +0100, Mark Drew <[EMAIL PROTECTED]> wrote:
> Or you could Count(mark) where it equals fail  and count where it
> equals pass total them and there you go :D
> 
> 
> On Mon, 20 Dec 2004 07:41:15 -0500, Joe Rinehart <[EMAIL PROTECTED]> wrote:
> > Hey Andy,
> >
> > Instead of seeing if they're all "Pass," why not just see if there are
> > any failed?  For user 1:
> >
> > 
> >   
> >   
> >   
> >
> >   
> > SELECT userId
> > WHERE grade = 'fail'
> >   AND userId =  > value="#arguments.userId#">
> >   
> >
> >   
> >   
> > 
> >
> > -joe
> >
> > On Mon, 20 Dec 2004 12:32:12 +, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> > > Opps badly worded post sorry.
> > >
> > > Im trying to create a QoQ SQL statement that would return whether user
> > > 1 has passed or failed by checking that all his grades are passes?
> > >
> > > I've just been playing with another method were i am using the QoQ to
> > > return the users marks then just by checking that the amount of pass
> > > marks equals the amount of entries for the user.
> > >
> > > Hope this makes sense
> > >
> > > Andy J
> > >
> > >
> > > On Mon, 20 Dec 2004 13:23:04 +0100, Mark Drew <[EMAIL PROTECTED]> wrote:
> > > > Whats the question?
> > > >
> > > >
> > > > On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett <[EMAIL PROTECTED]> 
> > > > wrote:
> > > > > Hi there,
> > > > >
> > > > > I am have a table with user id and grade SQL statement. THe Table is -
> > > > >
> > > > > userid | grade
> > > > > 1 | pass
> > > > > 1 | pass
> > > > > 1 | pass
> > > > > 2 | fail
> > > > > 2 | pass
> > > > > 3 | pass
> > > > > 4 | pass
> > > > > 4 | fail
> > > > > 5 | pass
> > > > >
> > > > > The output shows bascially whether the user has passed all courses. So
> > > > > user 1 would be an overall 'Pass' mark as all courses are completed.
> > > > > Yet user 2 would be an overall 'Fail' as he/she has one more course to
> > > > > pass.
> > > > >
> > > > > Oh and this is a QoQ that i have to do this in.
> > > > >
> > > > > Any help appreciated
> > > > >
> > > > > Regards
> > > > >
> > > > > Andy J
> > > > > www.andyjarrett.co.uk
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188231
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: SQL

2004-12-20 Thread Andy Jarrett
Opps badly worded post sorry.

Im trying to create a QoQ SQL statement that would return whether user
1 has passed or failed by checking that all his grades are passes?

I've just been playing with another method were i am using the QoQ to
return the users marks then just by checking that the amount of pass
marks equals the amount of entries for the user.

Hope this makes sense

Andy J




On Mon, 20 Dec 2004 13:23:04 +0100, Mark Drew <[EMAIL PROTECTED]> wrote:
> Whats the question?
> 
> 
> On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> > Hi there,
> >
> > I am have a table with user id and grade SQL statement. THe Table is -
> >
> > userid | grade
> > 1 | pass
> > 1 | pass
> > 1 | pass
> > 2 | fail
> > 2 | pass
> > 3 | pass
> > 4 | pass
> > 4 | fail
> > 5 | pass
> >
> > The output shows bascially whether the user has passed all courses. So
> > user 1 would be an overall 'Pass' mark as all courses are completed.
> > Yet user 2 would be an overall 'Fail' as he/she has one more course to
> > pass.
> >
> > Oh and this is a QoQ that i have to do this in.
> >
> > Any help appreciated
> >
> > Regards
> >
> > Andy J
> > www.andyjarrett.co.uk
> >
> >
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188225
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


OT: SQL

2004-12-20 Thread Andy Jarrett
Hi there,

I am have a table with user id and grade SQL statement. THe Table is - 

userid | grade
1 | pass 
1 | pass
1 | pass
2 | fail
2 | pass
3 | pass
4 | pass
4 | fail
5 | pass

The output shows bascially whether the user has passed all courses. So
user 1 would be an overall 'Pass' mark as all courses are completed.
Yet user 2 would be an overall 'Fail' as he/she has one more course to
pass.

Oh and this is a QoQ that i have to do this in.

Any help appreciated

Regards

Andy J
www.andyjarrett.co.uk

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188222
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: ot: lcd monitors

2004-12-20 Thread Andy Jarrett
Hi Dave,

I managed to get hold of a Compaq 7020 which has been really good to
me. With DV input and built in speakers which was a must for me.

Andy J
www.andyjarrett.co.uk


On Sat, 18 Dec 2004 18:07:17 -0500, dave <[EMAIL PROTECTED]> wrote:
> any recommends on a 17" lcd?
> and not a $1000 one either
> 
> mostly standard stuff not much gaming but occasionally
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188220
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Fusebox 3 - circuit not loading fbx_settings.cfm?

2004-12-15 Thread Andy Jarrett
Are you currently getting an errors back? Or is it just not loading?

How do you know its not loading. Usually if i think a page isnt being
included them i put something like  or 
 at the top of the suspect page just to
double check.

Andy J
www.andyjarrett.co.uk


On Tue, 14 Dec 2004 13:12:35 -0500, Damien McKenna
<[EMAIL PROTECTED]> wrote:
> I've got several sites done in FB3 that work well. One particular site
> has this strange problem with two specific circuits. The circuits are
> three levels down (sub-circuits of About/Conferences) and neither load
> the fbx_settings.cfm file. The odd thing is that this doesn't affect
> other sites I have, only this site, only these circuits. Is there
> anything I could be doing wrong? Any pointers would be appreciated.
> 
> --
> Damien McKenna - Web Developer - [EMAIL PROTECTED]
> The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
> #include 
> 
> 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187705
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFMODULE vs. CFINCLUDE

2004-12-01 Thread Andy Jarrett
I've was thinking about this post last night - don't ask.

To give you a little background im mainly a solid Fuseboxer so issues
of layout have always been in the back of my head as it is something
FB accomodates for. But the one thing i love about the move from FB2
to FB3 was having the layout file in one file.

Well after reading this post it got me thinking about the Layout
process again (mainly because i am also looking at doing a small app
without FB for a change). And i was wondering why the 
tag isn't used here?

Basically your page would be:


Content Goes Here


This would allow several options at the bottom of the page

1)  
This would take the variable content and display its contents

2) 

3) #content#

4) Plus you could even put the layout template reference in the
onRequestEnd.cfm and put some logic for each page?

Just my 2 cents

Andy
www.andyjarrett.co.uk

On Wed, 1 Dec 2004 09:12:08 +0100, Micha Schopman
<[EMAIL PROTECTED]> wrote:
> Personally, the advantages of cfmodule outweigh those of cfinclude. The
> performance hit of cfmodule is really low, and cfmodule provides you
> with encapsulation. Variables defined within a template called by
> cfmodule have no effect on the executed code outside that template
> (unless you are using variables in request, session, application,
> client, server, or use the caller).
> 
> What you need to keep in mind, when you call a cfmodule template within
> a CFC, and use caller in that template, the variable is returned to the
> CFC. So if you want to use returned data from the template, you need to
> put business logic in your CFC which handles that.
> 
> Micha Schopman
> Software Engineer
> 
> Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
> Tel 033-4535377, Fax 033-4535388
> KvK Amersfoort 39081679, Rabo 39.48.05.380
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185777
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Should this code break

2004-11-10 Thread Andy Jarrett
Came across a weird one (or so i think)


#i GT 0 AND i LT 4#
Returns NO - expected


#i GT 0 LT 4#
Return Yes - not expected

With the second snippet surely this should error??

Andy
www.andyjarrett.co.uk

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183929
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Find out my IP

2004-10-28 Thread Andy Jarrett
N nothing that complicated. 

Just the usual direct wire from the NIC to the NTL box.






On Thu, 28 Oct 2004 15:21:48 +0100, Thomas Chiverton
<[EMAIL PROTECTED]> wrote:
> On Thursday 28 Oct 2004 13:08 pm, Andy Jarrett wrote:
> > WOW, cheers for the response, i never knew all that about NTL's proxies.
> 
> When I was on NTL, my box just got a public IP.
> How are you connected to them ? Set top box ? Stand alone box ? xDSL ?
> Intergrated wireless gatway nonsense ? Linux gateway ... ?
> 
> --
> Tom Chiverton
> Advanced ColdFusion Programmer
> 
> Tel: +44(0)1749 834997
> email: [EMAIL PROTECTED]
> BlueFinger Limited
> Underwood Business Park
> Wookey Hole Road, WELLS. BA5 1AF
> Tel: +44 (0)1749 834900
> Fax: +44 (0)1749 834901
> web: www.bluefinger.com
> Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
> Quay, BRISTOL. BS1 6EG.
> *** This E-mail contains confidential information for the addressee
> only. If you are not the intended recipient, please notify us
> immediately. You should not use, disclose, distribute or copy this
> communication if received in error. No binding contract will result from
> this e-mail until such time as a written document is signed on behalf of
> the company. BlueFinger Limited cannot accept responsibility for the
> completeness or accuracy of this message as it has been transmitted over
> public networks.***
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182808
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Find out my IP

2004-10-28 Thread Andy Jarrett
WOW, cheers for the response, i never knew all that about NTL's proxies.

As for the upgrades, i've got mine here (on the south coast) had it
for a while now and i gotta say i like it. Though the upload speed is
what really needs looking into.

Andy


On Wed, 27 Oct 2004 20:18:02 +0100, Paul Vernon
<[EMAIL PROTECTED]> wrote:
> Hi Andy,
> 
> NTL use a plethora of networking tricks to enable them to host more people
> than they have IP addresses. Can you say multi layered NAT based on region?
> Secondly, they use a whole host of transparent proxies to speed up Internet
> access for their users (this only works on port 80)
> 
> If you want to bypass the transparent caching proxies then you will have to
> find a public proxy that you can tell IE to use instead of attempting to
> access the sites you are looking at directly.
> 
> Thing is, figuring out your actual IP address on NTL is a bit of a
> non-started what with the transparent proxies and multi layered NAT masking
> it almost beyond hope.. Bypassing these with a proxy and running the tests
> will report the proxies IP address...
> 
> BTW... NTLs broadband speed upgrades should be almost finished by now.. They
> tell me I'm on 1.5Mbps at home... Funny... Looks to me like 1Mbps still...
> Ho hum... More waiting on their customer support lines I guess...
> 
> Some useful info about NTL networks is here
> 
> http://homepage.ntlworld.com/robin.d.h.walker/cmtips/index.html
> 
> HTH
> 
> Paul
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182801
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Find out my IP

2004-10-27 Thread Andy Jarrett
Im in the UK and using NTL

Andy




On Wed, 27 Oct 2004 12:45:45 -0400, Ray Champagne <[EMAIL PROTECTED]> wrote:
> Who is you ISP?
> 
> I got the same result in all of those links.
> 
> Ray
> 
> 
> 
> At 12:43 PM 10/27/2004, you wrote:
> >I wanted to know what IP address my PC was giving off online. I
> >thought easy, just pop along to whatismyip.com and have a look.
> >
> >The result was not what i was expecting so i tried another, and
> >another and i got a different result from every page (though always
> >the same result from the same page). I even set up a page on my site
> >here, and this showed a different result. As far as i know this
> >shouldnt change or be different from site to site. Anyone have any
> >ideas why this would happen? Below are the sites i viewed.
> >
> >http://checkip.dyndns.org/
> >http://www.lawrencegoetz.com/programs/ipinfo/
> >http://www.ipaddressworld.com/
> >http://megawx.aws.com/support/faq/software/ip.asp
> >
> >Cheers
> >
> >Andy
> >www.andyjarrett.co.uk
> >
> >
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182737
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


OT: Find out my IP

2004-10-27 Thread Andy Jarrett
I wanted to know what IP address my PC was giving off online. I
thought easy, just pop along to whatismyip.com and have a look.

The result was not what i was expecting so i tried another, and
another and i got a different result from every page (though always
the same result from the same page). I even set up a page on my site
here, and this showed a different result. As far as i know this
shouldnt change or be different from site to site. Anyone have any
ideas why this would happen? Below are the sites i viewed.

http://checkip.dyndns.org/ 
http://www.lawrencegoetz.com/programs/ipinfo/ 
http://www.ipaddressworld.com/ 
http://megawx.aws.com/support/faq/software/ip.asp 

Cheers

Andy
www.andyjarrett.co.uk

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182718
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


cached Queries

2004-10-24 Thread Andy Jarrett
Hi there,

Is there away of telling if a query was generated from a cached query
without setting a variable or anything??

Cheers

Andy
www.andyjarrett.co.uk

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182463
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Odd Dreamweaver behaviour

2004-10-22 Thread Andy Jarrett
What do you name the file, i'll give it a go here if you want

Andy
www.andyjarrett.co.uk


On Fri, 22 Oct 2004 10:00:24 +0100, James Smith <[EMAIL PROTECTED]> wrote:
> I have a CFM file that, every time I open it, crashes Dreamweaver with the
> following message...
> 
> ***
> The instruction at "0x00aaabd7" referenced memory at "0x0054".  The
> memory could not be "read".
> ***
> 
> If I rename the file to something else in explorer then Dreamweaver opens it
> fine, if I rename it back to the original name inside Dreamweaver then try
> to open it again, Dreamweaver crashes.
> 
> If I rename the file to something else in explorer then open it in
> Dreamweaver, then do a "save as" in Dreamweaver it remains open fine,
> however if I then close and re-open the file, Dreamweaver crashes.
> 
> Anyone any idea how to fix this?
> 
> --
> James Smith
> [EMAIL PROTECTED]
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182304
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: UTF-8 and MySQL

2004-10-22 Thread Andy Jarrett
The connection string worked a treat, cheer Paul




On Thu, 21 Oct 2004 22:24:24 +0700, Paul Hastings
<[EMAIL PROTECTED]> wrote:
> Andy Jarrett wrote:
> 
> first off not really sure mysql supports unicode/utf-8 at all.
> 
> > 
> > 
> 
> good.
> 
> > http://www.w3.org/1999/xhtml"; xml:lang="en">
> 
> not good if the page is in greek.
> 
> > 
> >   
> >   
> 
> waste of time for mx but useful for brain dead spiders, etc.
> 
> > This should simply out Ελλάδα, but its not i am getting junk.
> 
> did you remember to add something like
> "UseUnicode=true&characterEncoding=UTF-8" to that dsn?
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182300
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: UTF-8 and MySQL

2004-10-21 Thread Andy Jarrett
Ok, im stuck again with this whole UTF-8 problem. This time outputting
the results.

Below is my complete page that i am testing



http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd";>
http://www.w3.org/1999/xhtml"; xml:lang="en">






SELECT * FROM cc_languages
WHERE langId = '2'



#q.lang_country#





This should simply out Ελλάδα, but its not i am getting junk.

I am running MySQL 4.1.6, on CFMX 6.1, windowsXP pro

Cheers

Andy


On Thu, 21 Oct 2004 08:57:20 +0100, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> Fixed already
> 
> bad, SQL statement, i was too concerned thinking it was a UTF-8 problem.
> 
> Andy
> 
> 
> 
> 
> On Thu, 21 Oct 2004 08:49:30 +0100, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> > Hi there, I'm pretty sure this is me being naive. But i am running
> > MySQL 4.1.6 and have create a MyIsam table with a UTF-8 character set.
> >
> > UPDATE cc_languages2
> > lang_coutry = 'Ελλάδα'
> > WHERE langId = 2
> >
> > When i run the above code in a  block i get the following error returned
> >
> > You have an error in your SQL syntax; check the manual that
> > corresponds to your MySQL server version for the right syntax to use
> > near '= 'Î"λλάδα' WHERE langId = 2
> >
> > Do i need to convert the text i am updating before i run the SQL (by
> > the way it says Greece in Greek)??
> >
> > Cheers
> >
> > Andy
> > www.andyjarrett.co.uk
> >
>

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182152
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: UTF-8 and MySQL

2004-10-21 Thread Andy Jarrett
Fixed already

bad, SQL statement, i was too concerned thinking it was a UTF-8 problem.

Andy


On Thu, 21 Oct 2004 08:49:30 +0100, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> Hi there, I'm pretty sure this is me being naive. But i am running
> MySQL 4.1.6 and have create a MyIsam table with a UTF-8 character set.
> 
> UPDATE cc_languages2
> lang_coutry = 'Ελλάδα'
> WHERE langId = 2
> 
> When i run the above code in a  block i get the following error returned
> 
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '= 'Î"λλάδα' WHERE langId = 2
> 
> Do i need to convert the text i am updating before i run the SQL (by
> the way it says Greece in Greek)??
> 
> Cheers
> 
> Andy
> www.andyjarrett.co.uk
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182147
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


UTF-8 and MySQL

2004-10-21 Thread Andy Jarrett
Hi there, I'm pretty sure this is me being naive. But i am running
MySQL 4.1.6 and have create a MyIsam table with a UTF-8 character set.


UPDATE cc_languages2
lang_coutry = 'Ελλάδα'
WHERE langId = 2

When i run the above code in a  block i get the following error returned 

You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '= 'Î"λλάδα' WHERE langId = 2

Do i need to convert the text i am updating before i run the SQL (by
the way it says Greece in Greek)??

Cheers

Andy
www.andyjarrett.co.uk

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182146
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF developer numbers

2004-10-20 Thread Andy Jarrett
Or maybe even consider not going down the Blue Alanta pricing, but
their own Flex pricing? Surely this would open up the gates a little?

As long as you can gaurantee (somehow) that the site is going to be
used for personal use (or charity etc) by giving the server away free
in these cases means that ISP can offer CF at a rate thats in
competition with ASP and PHP hosting.

I know that CF costs more to host, and i've seen the threads that
outway costs against development time. We all have. But i still know
smaller developers who would rather pay £29 a year
(http://www.web-hosting.uk.com/packages/) for hosting  ASP or PHP than
£119 (http://cfmxhosting.co.uk/index.cfm?action=services.hosting) and
get half the features. I know that development time levy's of the cost
etc, but to the small developer he see's his hosting cost in this
example as 400% bigger than if he was hosting with another language.

Andy
www.andyjarrett.co.uk

On Wed, 20 Oct 2004 20:51:19 -0700, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> > What do you think would make a difference? Or put even more bluntly, if you
> > were my boss and could dictate how I spent my time, what would you want me
> > doing to spread the gospel according to Saint CF?
> 
> What ever's going to keep MM going strong and CF becoming a better
> product is what you ought to be doing.  I'm convinced that's the large
> company market based on events of the past year or so, and your
> comments back that up 100%.  However, there's still a lot of little
> guys around in the world, most of which aren't going to be affecting
> CF's overall revenue in any significant way (what's $1300 every few
> years next to $50,000 for 10 clustered CF enterprises), but it still
> represents a significant portion of the developer base.
> 
> That developer base is a very valuable asset to MM's overall marketing
> of CF, more voices translates to more converts translates to more
> sales.  If the little guys start petering out for PHP, ASP, or
> whatever, suddenly there's a lot less noise being made about CF,
> except withing the tight circles of corporate IT departments.
> 
> This hasn't hurt Java or .NET in any way, of course, but it's going to
> piss off a LOT of CF developers who've invested heavily but have been
> swept by the wayside by MM, because they don't contribute to the
> bottom line enough to matter.  Java and .NET have a certain barrier to
> entry.  You just can't go that route without some real resources.  PHP
> takes nothing but hardware.  CF floats somewhere in the middle.
> 
> So along with provding for the future development of CF and MM as a
> whole, a nod to the existing user base would be nice.   How much do CF
> Standard sales account for?  Would dropping that price down by 50%
> have a huge effect on the overall bottom line?  I bet you'd get more
> sales if you did.  (Chalk me up for at least one, but for now, it's
> JSPs for me).  Hell, maybe even consider New Atlanta's route.  Take CF
> Standard, trim it down some more (no CFX, only Access and MySQL, maybe
> even single-threaded) and give it away.  With the unified codebase,
> you just change a serial to upgrade, and that's it.
> 
> I have no idea if any of that is feasible, or even reasonable, you'll
> have to tell us that.  But it some thoughts from a "little guy" that's
> seen MM ignore us more and more in favor of the "big guy".
> 
> cheers,
> barneyb
> 
> On Wed, 20 Oct 2004 22:51:30 -0400, Ben Forta <[EMAIL PROTECTED]> wrote:
> > Interesting thread, on a whole bunch of levels.
> >
> > A few comments, and then an open question ...
> >
> > 1) Lots of messages imply that MM is not working on getting the word out
> > there. And I know for a fact that that is not true, it is what I do almost
> > full-time, and others work at it too. Maybe many are not seeing it, I'll get
> > back to that in a moment.
> >
> > 2) We are selling lots of CF. I can't disclose numbers and financials and
> > stuff without getting into all sorts of trouble, but I don't think I'll get
> > fired for saying that CF is indeed selling, and selling well.
> >
> > 3) What I have noticed is a dramatic change in who I am speaking to, and the
> > types of conversations. A few years ago I was talking to lots of .com
> > start-ups and developments shops and consultants and departmental decision
> > makers. I honestly don't bump into many of these anymore. But I do spend
> > lots of time talking to corporate decision makers, in the past few weeks I
> > have met with no less than a dozen well known very high profile
> > corporations, all using CF and lots of it. And this is reflected in the
> > types of sales we are making, and who we are selling to. With the changes in
> > CFMX, the maturation of the market in general, the tightening of the purse
> > strings and the subsequent trend towards consolidation and bringing projects
> > back in house, we are finding ourselves selling CF differently. Even
> > pricing, which some of you pointed out as an obstacle

Re: RegEx problem

2004-10-20 Thread Andy Jarrett
There's also CF RegEx at http://www.cfregex.com/ which is "donationware"

Andy
www.andyjarrett.co.uk



On Tue, 19 Oct 2004 19:23:16 -0400, dave <[EMAIL PROTECTED]> wrote:
> http://www.regexbuddy.com/
> so thats your secret charlie ;)
> 
> 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: RegEx problem

2004-10-19 Thread Andy Jarrett
Trying to go the long way around this.

You got love the fact everything is a list in CF. I used the
listLast() with delimiters: "()".

Cheers





On Wed, 20 Oct 2004 12:18:11 +1300, Matthew Walker
<[EMAIL PROTECTED]> wrote:
> Untested:
> reReplace(str, "[^(]*\(([^)]*)\)", "\1")
> Assuming there's only one set of brackets and nothing after the brackets.
> You could also use listLast() with delimiters: "()"
> 
> 
> 
> > -Original Message-
> > From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, 20 October 2004 12:04 p.m.
> > To: CF-Talk
> > Subject: RegEx problem
> >
> > Hi there,
> >
> > Out of the following string i am trying to return only the
> > value in the brackets user RegEx.
> >
> > String = German (Luxembourg)
> >
> > Is this possible in one Regex or does it have to be two?
> >
> > Cheers
> >
> > Andy J
> > www.andyjarrett.co.uk
> >
> >
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181953
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RegEx problem

2004-10-19 Thread Andy Jarrett
Hi there,

Out of the following string i am trying to return only the value in
the brackets user RegEx.

String = German (Luxembourg)

Is this possible in one Regex or does it have to be two?

Cheers

Andy J
www.andyjarrett.co.uk

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181949
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Session Variables dropping?

2004-10-14 Thread Andy Jarrett
100k in the Application scope. WOW. When it comes to this sort of
thing im always way to reserved. Usually shying awaying from hold any
huge amount of data in a persistance scope.

What type of system you running this on: intranet, internet etc?? You
got many other application on the same server?

Andy
www.andyjarrett.co.uk



On Thu, 14 Oct 2004 16:08:17 +0200, Micha Schopman
<[EMAIL PROTECTED]> wrote:
> I have systems running storing more than 100k records in the application
> scope with no problem at all. I guess there still has to be a tiny itchy
> annoying bug waiting for you to be resolved :-) I have never seen
> problems like yours before.
> 
> 
> Micha Schopman 
> Software Engineer 
> Modern Media, Databankweg 12 M, 3821 AL  Amersfoort 
> Tel 033-4535377, Fax 033-4535388 
> KvK Amersfoort 39081679, Rabo 39.48.05.380
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CF Certified Print Logos?

2004-10-13 Thread Andy Jarrett
.bin is a binary files that can be either:

application/octet-stream 
application/bin 
application/binary 
application/x-msdownload

(check out www.filext.com for anything extension related)

You might want to try out an image viewer like
http://www.irfanview.com/ (its freeware).


On Tue, 12 Oct 2004 18:28:39 -0400, dave <[EMAIL PROTECTED]> wrote:
> .bin is also a windows file
> 
> the magic of google gives us this
> http://forums.devhardware.com/archive/t-17622
> 
> 
> 
> -- Original Message --
> From: Dave P <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date:  Tue, 12 Oct 2004 18:25:06 -0400
> 
> >.bin and .hqx are mac compressions like zip...
> >
> >...if you deal with crossover files on a regular basis, try StuffIt by
> Alladin software...it will handle all sorts of formats for PC, Mac, and even
> Linux (i think it does tar...?)...there is a free version called UnStuffIt
> that just lets you extract (that's what i use)...
> >
> >...but you probably already figured a way in judging from your last post...
> >
> >...if you can extract it, the chances should be fairly good that you can
> pull the eps into Freehand (which comes with MX Studio) or Adobe Illustrator
> or Photoshop...
> >
> >good luck...
> >...dave
> >
> >
> >>pardon that notion.
> >>
> >>loooks like the print versions are only for mac.
> >>
> >>and the digital versions are standard .jpg and .gif format/extensions.
> >>
> >>sorry.
> >>tw
> >>
> >>
> >>On Tue, 12 Oct 2004 16:32:22 -0400, Tony Weeg <[EMAIL PROTECTED]> wrote:
> >>> >
> >
> >
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Com Object

2004-10-06 Thread Andy Jarrett
Its definately a CF/jRun issue.

Craig, in regards to registering it - i shouldnt need to as its a COM
object and not a CFX. Thats what i thought. I havent need to in the
past for other COM's


On Wed, 6 Oct 2004 13:25:21 +0100, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> From what I can tell from the email it seems that its all working with VB
> just not with CF...its obviously a CF/jRun issue...
> 
> 
> 
>    _  
> 
> From: Craig Dudley [mailto:[EMAIL PROTECTED] 
> Sent: 06 October 2004 13:09
> To: CF-Talk
> Subject: RE: Com Object
> 
> 
> 
> Just playing devils advocate here but...
> 
> Have registered the dll on the server? If so, have you changed it since
> you did? If you have, re-registering it might help.
> 
> -Original Message-
> From: Andy Jarrett [mailto:[EMAIL PROTECTED] 
> Sent: 06 October 2004 11:17
> To: CF-Talk
> Subject: Re: Com Object
> 
> Sorry, my head is totally shot away today with Flu.
> 
> CFMX 6.1 - fully updated - but without most Hotfixes
> WinXP pro w/IIS 5.1 w/SP2
> 
> On Wed, 6 Oct 2004 10:49:01 +0100, Robertson-Ravo, Neil (RX)
> <[EMAIL PROTECTED]> wrote:
> > So you have a Firewall such as ZoneAlarm installed? Try
> > uninstalling/disabling and see what happens.
> > 
> > 
> > 
> >    _  
> > 
> > From: Andy Jarrett [mailto:[EMAIL PROTECTED] 
> > Sent: 06 October 2004 10:43
> > To: CF-Talk
> > Subject: Re: Com Object
> > 
> > Opps.
> > 
> > Sorry running cfmx 6.1
> > 
> > On Wed, 6 Oct 2004 10:26:24 +0100, Robertson-Ravo, Neil (RX)
> > <[EMAIL PROTECTED]> wrote:
> > > What version of CF?
> > > 
> > > 
> > > 
> > >    _  
> > > 
> > > From: Andy Jarrett [mailto:[EMAIL PROTECTED] 
> > > Sent: 06 October 2004 10:24
> > > To: CF-Talk
> > > Subject: Com Object
> > > 
> > > 
> > > 
> > > Hi there,
> > > 
> > > I have a com object installed on my development machine which was
> > > developed by another developer. When it is tested via a small VB app
> > > it all works fine.
> > > 
> > > When i make a call and execute with CF i get the following error in
> my
> > logs,
> > > # Created by JRun on 06/10 09:47:32    
> > > 06/10 09:47:32 error socket closed    
> > > java.net.SocketException: socket closed    
> > > at java.net.PlainSocketImpl.socketAccept(Native Method)    
> > > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)    
> > > at java.net.ServerSocket.implAccept(ServerSocket.java:448)    
> > > at java.net.ServerSocket.accept(ServerSocket.java:419)    
> > > at
> jrun.servlet.network.NetworkService.accept(NetworkService.java:368)    
> > > at
> jrun.servlet.jrpp.JRunProxyService.accept(JRunProxyService.java:104)
> > 
> > > at
> > >
> >
> jrun.servlet.jrpp.JRunProxyService.createRunnable(JRunProxyService.java:
> 120)
> > > at
> > >
> >
> jrunx.scheduler.ThreadPool$ThreadThrottle.createRunnable(ThreadPool.java
> :377
> > > )
> > > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:62)    
> > > 
> > > The component checks a load of fields then send a small text file on
> > > port 22 to another server. What i cannot understand is i cannot get
> > > this working via ColdFusion?
> > > 
> > > Anyone had a similar problem??
> > > 
> > > Andy
> > > 
> > >    _
> > >
> > 
> >    _
> > 
>   _
> 
>    _
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Com Object

2004-10-06 Thread Andy Jarrett
Just turned off all firewalls to no prevail. D'oh

On Wed, 6 Oct 2004 11:16:35 +0100, Andy Jarrett <[EMAIL PROTECTED]> wrote:
> Sorry, my head is totally shot away today with Flu.
> 
> CFMX 6.1 - fully updated - but without most Hotfixes
> WinXP pro w/IIS 5.1 w/SP2
> 
> On Wed, 6 Oct 2004 10:49:01 +0100, Robertson-Ravo, Neil (RX)
> <[EMAIL PROTECTED]> wrote:
> > So you have a Firewall such as ZoneAlarm installed? Try
> 
> 
> > uninstalling/disabling and see what happens.
> >
> >
> >
> >    _
> >
> > From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> > Sent: 06 October 2004 10:43
> > To: CF-Talk
> > Subject: Re: Com Object
> >
> > Opps.
> >
> > Sorry running cfmx 6.1
> >
> > On Wed, 6 Oct 2004 10:26:24 +0100, Robertson-Ravo, Neil (RX)
> > <[EMAIL PROTECTED]> wrote:
> > > What version of CF?
> > >
> > >
> > >
> > >    _
> > >
> > > From: Andy Jarrett [mailto:[EMAIL PROTECTED]
> > > Sent: 06 October 2004 10:24
> > > To: CF-Talk
> > > Subject: Com Object
> > >
> > >
> > >
> > > Hi there,
> > >
> > > I have a com object installed on my development machine which was
> > > developed by another developer. When it is tested via a small VB app
> > > it all works fine.
> > >
> > > When i make a call and execute with CF i get the following error in my
> > logs,
> > > # Created by JRun on 06/10 09:47:32
> > > 06/10 09:47:32 error socket closed
> > > java.net.SocketException: socket closed
> > > at java.net.PlainSocketImpl.socketAccept(Native Method)
> > > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)
> > > at java.net.ServerSocket.implAccept(ServerSocket.java:448)
> > > at java.net.ServerSocket.accept(ServerSocket.java:419)
> > > at jrun.servlet.network.NetworkService.accept(NetworkService.java:368)
> > > at jrun.servlet.jrpp.JRunProxyService.accept(JRunProxyService.java:104)
> >
> > > at
> > >
> > jrun.servlet.jrpp.JRunProxyService.createRunnable(JRunProxyService.java:120)
> > > at
> > >
> > jrunx.scheduler.ThreadPool$ThreadThrottle.createRunnable(ThreadPool.java:377
> > > )
> > > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:62)
> > >
> > > The component checks a load of fields then send a small text file on
> > > port 22 to another server. What i cannot understand is i cannot get
> > > this working via ColdFusion?
> > >
> > > Anyone had a similar problem??
> > >
> > > Andy
> > >
> > >    _
> > >
> >
> >    _
> >
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Com Object

2004-10-06 Thread Andy Jarrett
Sorry, my head is totally shot away today with Flu.

CFMX 6.1 - fully updated - but without most Hotfixes
WinXP pro w/IIS 5.1 w/SP2

On Wed, 6 Oct 2004 10:49:01 +0100, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> So you have a Firewall such as ZoneAlarm installed? Try
> uninstalling/disabling and see what happens.
> 
> 
> 
>    _  
> 
> From: Andy Jarrett [mailto:[EMAIL PROTECTED] 
> Sent: 06 October 2004 10:43
> To: CF-Talk
> Subject: Re: Com Object
> 
> Opps.
> 
> Sorry running cfmx 6.1
> 
> On Wed, 6 Oct 2004 10:26:24 +0100, Robertson-Ravo, Neil (RX)
> <[EMAIL PROTECTED]> wrote:
> > What version of CF?
> > 
> > 
> > 
> >    _  
> > 
> > From: Andy Jarrett [mailto:[EMAIL PROTECTED] 
> > Sent: 06 October 2004 10:24
> > To: CF-Talk
> > Subject: Com Object
> > 
> > 
> > 
> > Hi there,
> > 
> > I have a com object installed on my development machine which was
> > developed by another developer. When it is tested via a small VB app
> > it all works fine.
> > 
> > When i make a call and execute with CF i get the following error in my
> logs,
> > # Created by JRun on 06/10 09:47:32    
> > 06/10 09:47:32 error socket closed    
> > java.net.SocketException: socket closed    
> > at java.net.PlainSocketImpl.socketAccept(Native Method)    
> > at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)    
> > at java.net.ServerSocket.implAccept(ServerSocket.java:448)    
> > at java.net.ServerSocket.accept(ServerSocket.java:419)    
> > at jrun.servlet.network.NetworkService.accept(NetworkService.java:368)    
> > at jrun.servlet.jrpp.JRunProxyService.accept(JRunProxyService.java:104)
> 
> > at
> >
> jrun.servlet.jrpp.JRunProxyService.createRunnable(JRunProxyService.java:120)
> > at
> >
> jrunx.scheduler.ThreadPool$ThreadThrottle.createRunnable(ThreadPool.java:377
> > )
> > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:62)    
> > 
> > The component checks a load of fields then send a small text file on
> > port 22 to another server. What i cannot understand is i cannot get
> > this working via ColdFusion?
> > 
> > Anyone had a similar problem??
> > 
> > Andy
> > 
> >    _
> >
> 
>    _
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Com Object

2004-10-06 Thread Andy Jarrett
Opps.

Sorry running cfmx 6.1

On Wed, 6 Oct 2004 10:26:24 +0100, Robertson-Ravo, Neil (RX)
<[EMAIL PROTECTED]> wrote:
> What version of CF?
> 
> 
> 
>    _____  
> 
> From: Andy Jarrett [mailto:[EMAIL PROTECTED] 
> Sent: 06 October 2004 10:24
> To: CF-Talk
> Subject: Com Object
> 
> 
> 
> Hi there,
> 
> I have a com object installed on my development machine which was
> developed by another developer. When it is tested via a small VB app
> it all works fine.
> 
> When i make a call and execute with CF i get the following error in my logs,
> # Created by JRun on 06/10 09:47:32    
> 06/10 09:47:32 error socket closed    
> java.net.SocketException: socket closed    
> at java.net.PlainSocketImpl.socketAccept(Native Method)    
> at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)    
> at java.net.ServerSocket.implAccept(ServerSocket.java:448)    
> at java.net.ServerSocket.accept(ServerSocket.java:419)    
> at jrun.servlet.network.NetworkService.accept(NetworkService.java:368)    
> at jrun.servlet.jrpp.JRunProxyService.accept(JRunProxyService.java:104)    
> at
> jrun.servlet.jrpp.JRunProxyService.createRunnable(JRunProxyService.java:120)
> at
> jrunx.scheduler.ThreadPool$ThreadThrottle.createRunnable(ThreadPool.java:377
> )
> at jrunx.scheduler.WorkerThread.run(WorkerThread.java:62)    
> 
> The component checks a load of fields then send a small text file on
> port 22 to another server. What i cannot understand is i cannot get
> this working via ColdFusion?
> 
> Anyone had a similar problem??
> 
> Andy
> 
>    _
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Com Object

2004-10-06 Thread Andy Jarrett
Hi there,

I have a com object installed on my development machine which was
developed by another developer. When it is tested via a small VB app
it all works fine.

When i make a call and execute with CF i get the following error in my logs,
# Created by JRun on 06/10 09:47:32    
06/10 09:47:32 error socket closed    
java.net.SocketException: socket closed    
at java.net.PlainSocketImpl.socketAccept(Native Method)    
at java.net.PlainSocketImpl.accept(PlainSocketImpl.java:353)    
at java.net.ServerSocket.implAccept(ServerSocket.java:448)    
at java.net.ServerSocket.accept(ServerSocket.java:419)    
at jrun.servlet.network.NetworkService.accept(NetworkService.java:368)    
at jrun.servlet.jrpp.JRunProxyService.accept(JRunProxyService.java:104)    
at jrun.servlet.jrpp.JRunProxyService.createRunnable(JRunProxyService.java:120)
at jrunx.scheduler.ThreadPool$ThreadThrottle.createRunnable(ThreadPool.java:377)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:62)    

The component checks a load of fields then send a small text file on
port 22 to another server. What i cannot understand is i cannot get
this working via ColdFusion?

Anyone had a similar problem??

Andy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: serving images from different domin, good or bad for preformance, any suggestions?

2004-10-05 Thread Andy Jarrett
I'd be interested in where you heard that.

As far as i am aware this should not affect CF at all as the  tag
will never get processed by CF server.

If anything it could stiffle the loading of the original HTML page
because it has to do a call across domains and if the other domain is
down, or responding slowly then it will affect the calling page.

Andy
www.andyjarrett.co.uk 

- Original Message -
From: dave <[EMAIL PROTECTED]>
Date: Tue,  5 Oct 2004 03:38:31 -0400
Subject: Re:  serving images from different domin, good or bad
for preformance, any suggestions?
To: CF-Talk <[EMAIL PROTECTED]>

ummm
i could be wrong but i sure cant see how making the app do more work
is gunna speed it up
just has to go farther to find it, logically it would slow it down. 

-- Original Message --
From: "Nurettin Omer Hamzaoglu" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 5 Oct 2004 10:26:36 +0300

>Hi,
>
>I've heard that serving images from a different domain like www.images.com
>is better for CF Apllication Server performance. For example I've domain called
>www.myproject.com and I'm calling images 
>I'm gonna create a new domain www.myprojectimages.com and serve
>images from there 
>
>Any of you know if this improves the performance of the CF
Application Server, any suggestions?
>
>Thanks in advance.
>
>Nurettin Omer Hamzaoglu
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: OT-MySql Newbiee

2004-10-04 Thread Andy Jarrett
In the way of graphical GUI's you can also try for free

MySQL Control Centre http://www.mysql.com/products/mysqlcc/
MySQL Query Browser http://dev.mysql.com/downloads/query-browser/

There are als some "paid for" version like which give free 30day eval
MySQL Front  http://www.mysqlfront.de/
SQLyog http://www.webyog.com/sqlyog/index.php

Andy
www.andyjarrett.co.uk

- Original Message -
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Mon, 4 Oct 2004 16:21:21 +0100
Subject: RE: OT-MySql Newbiee
To: CF-Talk <[EMAIL PROTECTED]>

sure there's a cfmyadmin tool out there as well... 

http://www.cfmyadmin.com/

You'll still find it easier running the winmysqladmin.exe to configure
the mysql server tho

if not, good luck with the command line there's plenty of docs about
it on the mysql website.

me, I'm a windows baby unfortunately

-- 
dc
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: free web design?

2004-10-04 Thread Andy Jarrett
Even by comparison addr.com can be seen as expensive. My friend who
was a freelancer had a couple of 3/4 page static jobs taken of him
last year because they (the client)  found a "cheaper alternative"
which tended to be a Frontpage Template. Plus he even heard one client
saying that it was going to cost £50/£60 for site!

How do you compete with that. You don't. You just say here's my card
incase you need me in the future.

Andy 


- Original Message -
From: Jim McAtee <[EMAIL PROTECTED]>
Date: Sun, 3 Oct 2004 11:46:41 -0600
Subject: Re: free web design?
To: CF-Talk <[EMAIL PROTECTED]>

You still see plenty of Mom and Pop static sites out there done by some 
junior high school kid or by someone with Front Page.  $500 from a 
starving graphic arts student can buy you a hell of a lot over those other 
options.

- Original Message - 
From: "Dwayne Cole" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, October 03, 2004 4:21 AM
Subject: Re: free web design?

> This is Unbeleivable!  No one worth their weight in salt would do a 
> thing like this.  Plus I ask my business customer do they really want to 
> bet the business on a 499.00 website?
>
>
> -- Original Message --
> From: Douglas Knudsen <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date:  Fri, 1 Oct 2004 12:06:18 -0400
>
>>reminds me...
>>http://www.cubicleman.com/?id=19
>>someone here in Atlanta was advertising this.  Have websites become
>>such a commodity?  LOL!
>>
>>Doug
>>
>>
>>- Original Message -
>>From: Ray Champagne <[EMAIL PROTECTED]>
>>Date: Fri, 01 Oct 2004 11:03:19 -0400
>>Subject: RE: free web design?
>>To: CF-Talk <[EMAIL PROTECTED]>
>>
>>Oh it definitely was SPAM.  But SPAM that caught my attention :)
>>
>>
>>
>> At 11:00 AM 10/1/2004, you wrote:
>> >Sounds like .SPAM SPAM SPAM SPAM
>> >
>> >
>> >
>> >    _
>> >
>> >From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
>> >Sent: 01 October 2004 16:00
>> >To: CF-Talk
>> >Subject: Re: free web design?
>> >
>> >
>> >
>> >Been around for everjust template based cheesy sites I'm 
>> >sureall
>> >kinds of ISPs offer it as a loss leader to their hosting packages
>> >
>> >Bryan Stevenson B.Comm.
>> >VP & Director of E-Commerce Development
>> >Electric Edge Systems Group Inc.
>> >phone: 250.480.0642
>> >fax: 250.480.1264
>> >cell: 250.920.8830
>> >e-mail: [EMAIL PROTECTED]
>> >web: www.electricedgesystems.com
>> >
>> >   - Original Message -
>> >   From: Ray Champagne
>> >   To: CF-Talk
>> >   Sent: Friday, October 01, 2004 7:51 AM
>> >   Subject: free web design?
>> >
>> >   I got an email from these folks today, saying that they will create 
>> > a <10
>> >   page site for free, all you pay for is the hosting (9.95/mo). 
>> > There must
>> >   be a catch in this offer somewhere, but I don't see where.  Anybody 
>> > ever
>> >   heard of these guys?
>> >
>> >   http://www.addr.com/free-design/
>> >
>> >   How does one compete with *free*???  Not that these types of sites 
>> > are our
>> >
>> >   main focus, but they did provide some nice side work!
>> >
>> >   Ray
>> >
>> >   =
>> >   Ray Champagne - Senior Application Developer
>> >   CrystalVision Web Site Design and Internet Services
>> >   603.433.9559
>> >   www.crystalvision.org
>> >   =
>> >
>> >   The information contained in this transmission (including any 
>> > attached
>> >   files) is CONFIDENTIAL and is intended only for the person(s) named
>> >   above. If you received this transmission in error, please delete it
>> >   from your system and notify us immediately. If you are not an 
>> > intended
>> >   recipient, please note that any use or dissemination of the 
>> > information
>> >   contained in this transmission (including any attached files) and 
>> > the
>> >   copying, printing, or retransmission of that information is 
>> > strictly
>> >   prohibited. You can notify us by return email or by phone at 
>> > 603.433.9559.
>> >   Thank you.
>> >
>> >    _
>> >
>> >
>> >
>> >
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: encrypt whole site

2004-09-29 Thread Andy Jarrett
opps, thought this just did one page at a time.

*holding head low will promise to properly read docs before posting*

:o)

Andy
www.andyjarrett.co.uk

- Original Message -
From: Dave Watts <[EMAIL PROTECTED]>
Date: Wed, 29 Sep 2004 08:36:05 -0400
Subject: RE: encrypt whole site
To: CF-Talk <[EMAIL PROTECTED]>

> Has anyone come across a tool to encrypt all .cfm pages in a 
> site (preferably free)?
> 
> I just don't want to re-invent the wheel by creating a script 
> to loop through all folders and encrypt them if someone has 
> already done it.

The cfencode.exe utility in your CF installation does this.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




encrypt whole site

2004-09-29 Thread Andy Jarrett
Has anyone come across a tool to encrypt all .cfm pages in a site
(preferably free)?

I just don't want to re-invent the wheel by creating a script to loop
through all folders and encrypt them if someone has already done it.

Cheers

Andy
www.andyjarrett.co.uk
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Regex Question

2004-09-24 Thread Andy Jarrett
WIthout sounding silly. Isn't this more of a simple replace rather
than using RegEx?

replace(string, '[GT:moons]', '
href="">
', 'all')

Just a thought

Andy

On Fri, 24 Sep 2004 10:18:53 -0400, Duane Boudreau <[EMAIL PROTECTED]> wrote:
> Hi All,
> 
> 
> Got a regex question.
> 
> 
> Sample content block: There are 31 [GT:moons] that surround Saturn
> 
> 
> I need to replace [GT:moons] with 
> href="">
> 
> 
> I've got the following regex ,"\[GT:([a-zA-Z0-9 \'\\/]*)\]", but the problem
> is that I really need to check for any character between [GT: and ].
> 
> 
> I know it should be something like "\[GT:(.*)\]" but I cant figure out how
> to enter in the exception for ]
> 
> 
> TIA,
> Duane
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Change .cfm to .xxx - Legal or not?

2004-09-24 Thread Andy Jarrett
Just to add, one company which i think make good use of this by
incoporating their name is Hotchilli.com (and i think as well that it
is CF that they use)

e.g. http://hotchilli.com/hosting/domains.hot

Andy
www.andyjarrett.co.uk

- Original Message -
From: Marco Antonio C. Santos <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 21:03:35 -0300
Subject: Re: Change .cfm to .xxx - Legal or not?
To: CF-Talk <[EMAIL PROTECTED]>

Thanx Jim

We're using W2K3 Server/IIS 6/CFMX 6.1

This link by Ben Forta is very cool

http://forta.com/blog/index.cfm?mode=e&entry=681

Thanx all

Marco

On Thu, 23 Sep 2004 19:54:28 -0400, Jim Davis
<[EMAIL PROTECTED]> wrote:
> There is no legalities concerning this at all - you can change the extension
> to whatever you like.
> 
> You would do this in the web server (not CF) - let us know what server
> you're using and somebody should be able to tell you how to change it.  I've
> got an old article detailing how to do this in IIS 5 (and some reasons why
> you might want to) that I think is applicable to later versions of IIS (no
> promises):
> 
> http://www.depressedpress.com/depressedpress/Content/Development/ColdFusion/
> Articles/MultipleExtensions/Index.cfm
> 
> Jim Davis
> 
>  _
> 
> From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 23, 2004 7:41 PM
> To: CF-Talk
> Subject: Change .cfm to .xxx - Legal or not?
> 
> 
> 
> 
> Hi
> 
> it's possible to change the CF extensions(.cfm) to .anything??? It's
> legal or not? What's the "law" point of view? And MM?
> 
> Thanx
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: .cfmail to .eml

2004-08-24 Thread Andy Jarrett
Howie, thanks for all your help so far, your new DLL did the trick. One more issue though (sorry about this), it doesnt seem to be attaching documents. When i run the following code it creates the file but its minial size (about 4.00kb)


	createmailfileonly="yes" 
	spooldir="D:\WWW\wwwroot\scribble\newmail\"
	attachment="D:\WWW\wwwroot\scribble\test.zip"
	header_to="[EMAIL PROTECTED]"
	header_from="[EMAIL PROTECTED]"
	header_subject="Test email"
	body="test">

I've read the pdf guide and cant see anything im missing? Any help would be much appreciated.

Cheers again,

Andy

> I apologize - that functionality is not often used in the tag (though 
> it's been there for quite some time) and it seems to have been broken.  
> I corrected the tag so that the createmailfileonly functionality works 
> properly again.  You can download the updated tag here:
> 
> ftp://ftp.coolfusion.com/pub/ods/cfx_imsmail/cfx_imsmail353_dll.zip
> 
> Just replace the one you have with the enclosed DLL and you should be 
> good to go.
> 
> Regards,
> 
> Howie
  
> - Original Message - 
  
> From: Andy Jarrett 
  
> To: CF-Talk 
  
> Sent: Tuesday, August 24, 2004 10:50 AM
  
> Subject: Re: .cfmail to .eml
> 
> 
  
> Thanks for that. Though with the following code it doesnt seem to be 
> generating any file
> 
  
> 
  
> createmailfileonly="yes" 
  
> spooldir="c:\Documents and Settings\aj\Desktop\" 
  
> header_to="[EMAIL PROTECTED]" 
  
> header_from="[EMAIL PROTECTED]"
  
> body="test">
> 
  
> Am i missing something?
> 
  
> Andy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: .cfmail to .eml

2004-08-24 Thread Andy Jarrett
Thanks for that. Though with the following code it doesnt seem to be generating any file


	createmailfileonly="yes" 
	spooldir="c:\Documents and Settings\aj\Desktop\" 
	header_to="[EMAIL PROTECTED]" 
	header_from="[EMAIL PROTECTED]"
	body="test">

Am i missing something?

Andy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: .cfmail to .eml

2004-08-24 Thread Andy Jarrett
Thanks for that. Though i've installed the CFX and registered it with CF the following code isnt producing a file


	createmailfileonly="yes" 
	spooldir="c:\" 
	header_to="[EMAIL PROTECTED]" 
	header_from="[EMAIL PROTECTED]"
	body="test">
Is there something im missing?

Cheers

Andy

> CFX_iMSMail (our tag for sending mail with iMS) can do this.  The code 
> would be something like:
> 
> 
> attachments="c:\file1.zip,c:\file2.zip" header_to="someone" 
> header_from="someone"
> body="test">
> 
> This code would create a mail file in the specified folder with the 
> specified attachments.  The tag is freeware and you can download it 
> from our web site.
> 
> HTH,
> 
> -- 
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc. - www.CoolFusion.com
> inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail 
> Server
> PrismAV - Virus scanning for ColdFusion applications
> >>> Find out how iMS Stacks up to the competition: http://www.
> coolfusion.com/imssecomparison.cfm
> 
  
> - Original Message - 
  
> From: Andy J 
  
> To: CF-Talk 
  
> Sent: Tuesday, August 24, 2004 8:05 AM
  
> Subject: .cfmail to .eml
> 
> 
  
> HI, ok, this might sound odd but is there a away of creating an email 
> (with
  
> attachements) but without using . 
> 
  
> All I want is the final file so when I open it in Tunderbird I can 
> read the
  
> message and see the file. 
> 
  
> Hope this is clear
> 
  
> Andy
> 
  
> ---
> 
  
> Checked by AVG anti-virus system (http://www.grisoft.com).
  
> Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: MySQL 4.1 reliability?

2004-08-10 Thread Andy Jarrett
I've been playing around with it on my home machine and word Dev machine with no problems so far. 

Andy J

>I am running it fine on our intranet, no problems so far.
>
>--
>Jay 
>
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: advice on structure and cfcs (petmarket related)

2004-08-10 Thread Andy Jarrett
My CFC knowledge is limited at the moment, but if you want some good starting points to building an app with CFC's then downloand and check out Ray Camdens BlogCFC (http://www.camdenfamily.com/morpheus/blog/).

If you're looking for a good way to structure your code then have you looked at frameworks like Mach-ii (www.mach-ii.com) or Fusebox 4 (www.fusebox.org)

Hope this helps

Andy

> I'm looking how to best structure an application and build it with 
> cfcs. I'm looking at the petmarket example right now (cfml only, not 
> the flash front end version).
> 
> What do people feel in general about the way that application is 
> structured?
> 
> In particular, I'm wondering about the detailview.cfm which is called 
> by the product.cfc detailview function and used to output the page. 
> Isn't that a "bad thing"? I would have thought you would call from a 
> page template a cfc to return query info on a product and output that.
> 
> 
> Anything else about this application in particular I should be aware 
> of or wary of duplicating, as maybe there is a better method or better 
> performance to be had another 
way?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Is this possible in SQL

2004-08-10 Thread Andy Jarrett
Cheers Matt, 

Worked a charm

>I have two tables which I want to query at the same time. I'm thinking
>something along the lines of 
>
>SELECT c.categoryid, sc.sub_CategoryId
>FROM categories c, sub_category sc
>WHERE c.category = '#form.searchVal#' OR sc.sub_Category =
>'#form.searchVal#'
>LIMIT 1
>
>But where this is a left join it will always return a result for either
>column whether it makes a match or not. 
>
>I could do something like the code below, but it seems to cumbersum for the
>job.
>
>SELECT c.categoryid AS catId
>FROM categories c
>WHERE c.category = '#form.searchVal#'
>
>
>
>	
>	SELECT sc.sub_CategoryId AS catId
>	FROM sub_category sc
>	WHERE sc.sub_Category = '#form.searchVal#'
>	
>
>
>
>
>
>Cheers 
>
>Andy
>
>---
>
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.735 / Virus Database: 489 - Release Date: 06/08/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: createTimeSpan can't take parameter as variable?

2004-08-03 Thread Andy Jarrett
Cheers Pascal, i see what you mean by error in my code, its quite obvious now - don't you love hindsight. 

To explain what i was playing around with in my head - I was thinking of having an .ini file with a string profile like:

tSpan=0,2,0,0

The idea was to have some key variables which could be edited without going into the code e.g. a settings page. I might stick with my idea of the .ini file but try something like

myTimeSpan = getProfileString(iniPath, "tSpan");
aryTimeSpan = listToArray(myTimeSpan);

Then in the query have:
createTimeSpan(aryTimeSpan[1],aryTimeSpan[2],aryTimeSpan[3],aryTimeSpan[4]); 

 
Andy J

>This is not a bug, but an error in your code. You need 4 parameters for
>createTmeSpan and you are only passing one (myTimeSpan):
>1. Put the CreateTimeSpan function in your assignment:
>myTimeSpan = CreateTimeSpan(0,0,2,0);
>2. Create each parameter individually:
>myTimeSpan = StructNew();
>myTimeSpan.days = 0;
>myTimeSpan.hours = 0;
>myTimeSpan.minutes = 2;
>myTimeSpan.seconds = 0;
>writeOutput(createTimeSpan(myTimeSpan.days, myTimeSpan.hours,
>myTimeSpan.minutes, myTimeSpan.seconds));
>
>I would go with option 1
>
>Pascal
>
>> -Original Message-
>> From: Andy J [mailto:[EMAIL PROTECTED]
>> Sent: 03 August 2004 10:02
>> To: CF-Talk
>> Subject: createTimeSpan can't take parameter as variable?
>> 
>> Is this a bug, or is there a perfectly good explanation why the
>following
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]