Re: Wierd regex problem (isn't it always)
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
a 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
!--- String to be manipulated ---
cfset str = First username is @andrew and second is @jarrett /
cfoutputp#str#/p/cfoutput
!--- The Regex
(@){1} - First back reference is the @ sign. Look for one of these
([a-zA-Z0-9]){1,} - Second back reference is the username
---
cfset reg = (@){1}([a-zA-Z0-9]){1,} /
!--- Using reReplace we take the second back reference and wrap
an a tag around it ---
cfset usernamePos = reReplace(str, reg, @a href='test'\2/a, all)
cfoutput#usernamePos#/cfoutput
~|
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)
Hi
I'm trying to do a look through as string to find usernames and add
a 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
!--- String to be manipulated ---
cfset str = First username is @andrew and second is @jarrett /
cfoutputp#str#/p/cfoutput
!--- The Regex
(@){1} - First back reference is the @ sign. Look for one of these
([a-zA-Z0-9]){1,} - Second back reference is the username
---
cfset reg = (@){1}([a-zA-Z0-9]){1,} /
!--- Using reReplace we take the second back reference and wrap
an a tag around it ---
cfset usernamePos = reReplace(str, reg, @a href='test'\2/a, all)
cfoutput#usernamePos#/cfoutput
~|
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
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
cfquery datasource=#dsn# name=qry1 result=qry.result2
{CALL libraryName.programName(' ')}
/cfquery
The Error
Error Executing Database Query.
[RPG9001] Error RPG0233 caused program programName to stop.
Second:
The Call
cfstoredproc datasource=#dsn# procedure=libraryName.programName
cfprocparam type=in cfsqltype=CF_SQL_CHAR value= /
/cfstoredproc
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
Hi, Has anyone had to edit the a XML XSD's value before parsing it? I want to go from file xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=file.xsd to file xmlns:xsi=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
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 cfform.
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
cfform format=flash name=myform
cfselect name=myfield id=myfield
option value=XYes/option
option value=YNo/option
/cfselect
cfinput type=radio name=payment_type id=payment_type
value=1
label=Payment option 1
visible={(myfield.text == 'Yes')?true:false}/
cfinput type=radio name=payment_type id=payment_type
value=2
label=Payment option 2
visible={(myfield.text == 'Yes')?true:false}/
cfinput type=radio name=payment_type id=payment_type
value=3
label=Payment option 3
visible={(myfield.text == 'No')?true:false}/
cfinput type=radio name=payment_type id=payment_type
value=4
label=Payment option 4
visible={(myfield.text == 'No')?true:false}/
/cfform
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
Does anyone know how to remove the white gap created when you set
visible=false in cfform.
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
cfform format=flash name=myform
cfselect name=myfield id=myfield
option value=XYes/option
option value=YNo/option
/cfselect
cfinput type=radio name=payment_type id=payment_type value=1
label=Payment option 1
visible={(myfield.text == 'Yes')?true:false}/
cfinput type=radio name=payment_type id=payment_type value=2
label=Payment option 2
visible={(myfield.text == 'Yes')?true:false}/
cfinput type=radio name=payment_type id=payment_type value=3
label=Payment option 3
visible={(myfield.text == 'No')?true:false}/
cfinput type=radio name=payment_type id=payment_type value=4
label=Payment option 4
visible={(myfield.text == 'No')?true:false}/
/cfform
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
cfheader breaks my xml
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 ?xml version=1.0 encoding=UTF-8? root node child1/child /node root I open this up and its valid. I know change the content type so the file is passed as XML: cfheader name=Content-Type value=text/xml ?xml version=1.0 encoding=UTF-8? root node child1/child /node root This breaks the page. It seems that cfheader 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
Re: cfheader breaks my xml
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 cfcontent instead of cfheader and it works great: cfcontent type=text/xml reset=Yes / cfoutput ...myXML... /cfoutput 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 ?xml version=1.0 encoding=UTF-8? root node child1/child /node root I open this up and its valid. I know change the content type so the file is passed as XML: cfheader name=Content-Type value=text/xml ?xml version=1.0 encoding=UTF-8? root node child1/child /node root This breaks the page. It seems that cfheader 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
CFreport problems
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
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
Re: IE 7 beta is available
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
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 cfgreetings name=Gert Franz from=[EMAIL PROTECTED] 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: Bluedragon 6.1
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
Bluedragon 6.1
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
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 (£)
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
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
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 cftry cfstoredproc datasource=#application.dsn# procedure=spQry cfprocparam type=in cfsqltype=cf_sql_varchar value=#var# / cfprocresult name = qryName resultset=1 / /cfstoredproc cfcatch type=any ERROR cfabort /cfcatch /cftry But by replacing error with cfoutputcfcatch.message/cfoutput 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
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
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
When to use Application var?
I have a bit of code on a smallish, low hit site cfset thisSiteName = ListGetAt(cgi.script_name, 1, /)/ cfif NOT application.init OR structKeyExists(url, reinit) cfquery datasource=#variables.dsn# name=thisCompany SELECT * FROM companydetails c WHERE c.company_folder = '#thisSiteName#' /cfquery cfset application.companyName = thisCompany.company_name / cfset application.companyWebsite = thisCompany.company_website / cfset application.companyEmail = thisCompany.company_email / cfset application.companyId = thisCompany.company_uid / cfset application.companyfolder = thisCompany.company_folder / cfset application.company_prerefix = thisCompany.company_prefix / cfset application.init = 1 /cfif 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 cfquery datasource=#variables.dsn# name=thisCompany cachedWithin=#createTimeSpan(2,0,0,0)# SELECT * FROM companydetails c WHERE c.company_folder = '#thisSiteName#' /cfquery cfset request.companyName = thisCompany.company_name / cfset request.companyWebsite = thisCompany.company_website / cfset request.companyEmail = thisCompany.company_email / cfset request.companyId = thisCompany.company_uid / cfset request.companyfolder = thisCompany.company_folder / cfset request.company_prerefix = thisCompany.company_prefix / 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: When to use Application var?
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 cfset thisSiteName = ListGetAt(cgi.script_name, 1, /)/ cfif NOT application.init OR structKeyExists(url, reinit) cfquery datasource=#variables.dsn# name=thisCompany SELECT * FROM companydetails c WHERE c.company_folder = '#thisSiteName#' /cfquery cfset application.companyName = thisCompany.company_name / cfset application.companyWebsite = thisCompany.company_website / cfset application.companyEmail = thisCompany.company_email / cfset application.companyId = thisCompany.company_uid / cfset application.companyfolder = thisCompany.company_folder / cfset application.company_prerefix = thisCompany.company_prefix / cfset application.init = 1 /cfif 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 cfquery datasource=#variables.dsn# name=thisCompany cachedWithin=#createTimeSpan(2,0,0,0)# SELECT * FROM companydetails c WHERE c.company_folder = '#thisSiteName#' /cfquery cfset request.companyName = thisCompany.company_name / cfset request.companyWebsite = thisCompany.company_website / cfset request.companyEmail = thisCompany.company_email / cfset request.companyId = thisCompany.company_uid / cfset request.companyfolder = thisCompany.company_folder / cfset request.company_prerefix = thisCompany.company_prefix / 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
cfgridupdate and fusebox
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
Cfrig problems
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
Re: Cfrig problems
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
Re: OT: 15 minute rule
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: OT: 15 minute rule
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
ColdFusion Exam
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: ColdFusion Exam
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
Re: Jrun connection closing for no reason
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
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
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
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
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
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
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 ?
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
Hi, Do i need to install the complete Crystal Reports 10 on the server to user cfreport 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
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 table'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 table border=0 width=100% height=100% tr th colspan=3nbsp;/th /tr tr td width=100nbsp;/td tdnbsp;/td td width=100nbsp;/td /tr tr td colspan=3nbsp;/td /tr /table 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
Hi, I am having a nightmare trying to replicate a 3 column site with CSS - it nearly make me want to use table'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 table border=0 width=100% height=100% tr th colspan=3nbsp;/th /tr tr td width=100nbsp;/td tdnbsp;/td td width=100nbsp;/td /tr tr td colspan=3nbsp;/td /tr /table 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
Stored Procedures in a CFC
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: Stored Procedures in a CFC
I think for readability returning the values in a structure is going to do a.k.a S.Isaac cfset data = myCFC.getQueries() cfloop query=data.getUsers.../cfloop cfloop query=data.getRoles.../cfloop 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
Re: FB4 book? (was RE: Discovering FB4.1 book comparison to FB4.0 edition?)
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: FB4 book? (was RE: Discovering FB4.1 book comparison to FB4.0 edition?)
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
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: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: CF Hosting
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 cf-talk@houseoffusion.com 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
Cfgrid on CFMX 6.1
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 cfgrid or does it have to go through cfgridupdate? 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: Cfgrid on CFMX 6.1
Thanks for that, I've found some relating to the certificate on cfform 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 cfgrid or does it have to go through cfgridupdate? 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
Re: OT: Homesite enhancement project?
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 stdjoke.h ~| 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: lcd monitors
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
OT: SQL
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: SQL
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
Re: OT: SQL
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: cffunction name=userFailed returntype=boolean cfargument name=qGrades type=query cfargument name=userId type=numeric cfset var qGetGrades = / cfquery dbType=query name=qGetGrades SELECT userId WHERE grade = 'fail' AND userId = cfqueryparam cfsqltype=cf_sql_int value=#arguments.userId# /cfquery !--- Return 0 if there are no failures, int other than 0 (true) if there is a failure --- cfreturn qGetGrades.recordCount / /cffunction -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: Fusebox 3 - circuit not loading fbx_settings.cfm?
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 cfdump var=#fusebox# or cfdump var=#fapplication# 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 stdjoke.h ~| 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
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 cfsavecontent tag isn't used here? Basically your page would be: cfsavecontent variable=content Content Goes Here /cfsavecontent This would allow several options at the bottom of the page 1) cfinclude template=layout.cfm This would take the variable content and display its contents 2) cfmodule template=layout.cfm body=#content# 3) cf_foo#content#/cf_foo 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
Came across a weird one (or so i think) cfset i = 5 cfoutput#i GT 0 AND i LT 4#/cfoutput Returns NO - expected cfset i = 5 cfoutput#i GT 0 LT 4#/cfoutput 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
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
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
OT: Find out my IP
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
Re: OT: Find out my IP
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
cached Queries
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: UTF-8 and MySQL
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. cfprocessingdirective pageencoding=utf-8 cfcontent type=text/html; charset=utf-8 good. html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en not good if the page is in greek. head title/title meta http-equiv=Content-Type content=text/html; charset=utf-8 / 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=truecharacterEncoding=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: Odd Dreamweaver behaviour
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: CF developer numbers
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 to CF growth, is in reality not much of an obstacle. We rarely finds ourselves talking to those for
UTF-8 and MySQL
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 cftry 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: UTF-8 and MySQL
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 cftry 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
Re: UTF-8 and MySQL
Ok, im stuck again with this whole UTF-8 problem. This time outputting the results. Below is my complete page that i am testing cfprocessingdirective pageencoding=utf-8 cfcontent type=text/html; charset=utf-8 !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.1//EN http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd; html xmlns=http://www.w3.org/1999/xhtml; xml:lang=en head title/title meta http-equiv=Content-Type content=text/html; charset=utf-8 / /head body cfquery datasource=#dsn# name=q SELECT * FROM cc_languages WHERE langId = '2' /cfquery cfoutput #q.lang_country# /cfoutput /cftry /body /html 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 cftry 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: RegEx problem
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
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=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: RegEx problem
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
Re: Session Variables dropping?
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 ALAmersfoort 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?
.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]
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
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
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
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
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: img serving images from different domin, good or bad for preformance, any suggestions?
I'd be interested in where you heard that. As far as i am aware this should not affect CF at all as the img 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: img 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 img src=""> I'm gonna create a new domain www.myprojectimages.com and serve images from there img src=""> 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: free web design?
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: OT-MySql Newbiee
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 Fronthttp://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]
encrypt whole site
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: encrypt whole site
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]
Re: Change .cfm to .xxx - Legal or not?
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=eentry=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: Regex Question
WIthout sounding silly. Isn't this more of a simple replace rather than using RegEx? replace(string, '[GT:moons]', 'a 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 a 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: .cfmail to .eml
Thanks for that. Though i've installed the CFX and registered it with CF the following code isnt producing a file cfx_imsmail 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: cfx_imsmail createmailfileonly=yes spooldir=some_directory 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 cfmail. 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: .cfmail to .eml
Thanks for that. Though with the following code it doesnt seem to be generating any file cfx_imsmail 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
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) cfx_imsmail 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 cfx_imsmail 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: Is this possible in SQL
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. cfquery name=qryName SELECT c.categoryid AS catId FROM categories c WHERE c.category = '#form.searchVal#' /cfquery cif NOT qry.recordCount cfquery name=qryName SELECT sc.sub_CategoryId AS catId FROM sub_category sc WHERE sc.sub_Category = '#form.searchVal#' /cfquery /cfif cfset variables.catId =qryName.catId 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: advice on structure and cfcs (petmarket related)
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: MySQL 4.1 reliability?
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: createTimeSpan can't take parameter as variable?
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]
