Re: [ cf-dev ] non ascii MSword malarchy
No -- various clients have CMS where they are copying contents of a Word doc into a form field (activeedit for instance) and then save it to their db. I'm looking for a way to strip illegal characters from this when it is submitted and convert them to ascii characters... hope that's clearer! - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 12:30 PM Subject: RE: [ cf-dev ] non ascii MSword malarchy I don't understand what you mean. What are you trying to do? Are you reading the contacts of a word document into a form field or something else? You can transform a word doc into plan text using cfobject.. Justin -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 12:12 To: [EMAIL PROTECTED] Subject: [ cf-dev ] non ascii MSword malarchy Hi all, You've probably had this b4 -- does anyone have or know of a javascript (or tag) that can strip a text string of silly Microplop characters and replace them with sensible ascii characters like the good old ' straight and narrow apostrophe when submitted through a form? cheers d ;0) - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 11:41 AM Subject: RE: [ cf-dev ] Cookies in Windows XP it could be that you're using ie6 in xp but not in the others and that its picking up on p3p problems. -Original Message- From: Sridhar Pedamallu [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 11:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Cookies in Windows XP Hi We are using cookies and client variables in our site. It works fine in win 98 or win 2000 etc except windows xp. Has anyone any suggestions to solve this. Any assistance much appreciated. reference site http://www.alphagalileo.org/ http://www.alphagalileo.org/ regards Sridhar Clear Thinking Group 100 New Kings Road, London SW6 4LX. Tel 0870 201 1601 Fax 0207 348 6089 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] non ascii MSword malarchy
cheers Russ ;0) - Original Message - From: Snake [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 1:05 PM Subject: RE: [ cf-dev ] non ascii MSword malarchy CFREPLACE or CFREREPLACE -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 12:12 To: [EMAIL PROTECTED] Subject: [ cf-dev ] non ascii MSword malarchy Hi all, You've probably had this b4 -- does anyone have or know of a javascript (or tag) that can strip a text string of silly Microplop characters and replace them with sensible ascii characters like the good old ' straight and narrow apostrophe when submitted through a form? cheers d ;0) - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 11:41 AM Subject: RE: [ cf-dev ] Cookies in Windows XP it could be that you're using ie6 in xp but not in the others and that its picking up on p3p problems. -Original Message- From: Sridhar Pedamallu [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 11:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Cookies in Windows XP Hi We are using cookies and client variables in our site. It works fine in win 98 or win 2000 etc except windows xp. Has anyone any suggestions to solve this. Any assistance much appreciated. reference site http://www.alphagalileo.org/ http://www.alphagalileo.org/ regards Sridhar Clear Thinking Group 100 New Kings Road, London SW6 4LX. Tel 0870 201 1601 Fax 0207 348 6089 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] non ascii MSword malarchy
How was it we ended up with activeedit again?? ;0) - Original Message - From: Snake [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 1:13 PM Subject: RE: [ cf-dev ] non ascii MSword malarchy soEditor will remove MS crap automatically. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 13:02 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] non ascii MSword malarchy No -- various clients have CMS where they are copying contents of a Word doc into a form field (activeedit for instance) and then save it to their db. I'm looking for a way to strip illegal characters from this when it is submitted and convert them to ascii characters... hope that's clearer! - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 12:30 PM Subject: RE: [ cf-dev ] non ascii MSword malarchy I don't understand what you mean. What are you trying to do? Are you reading the contacts of a word document into a form field or something else? You can transform a word doc into plan text using cfobject.. Justin -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 12:12 To: [EMAIL PROTECTED] Subject: [ cf-dev ] non ascii MSword malarchy Hi all, You've probably had this b4 -- does anyone have or know of a javascript (or tag) that can strip a text string of silly Microplop characters and replace them with sensible ascii characters like the good old ' straight and narrow apostrophe when submitted through a form? cheers d ;0) - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 11:41 AM Subject: RE: [ cf-dev ] Cookies in Windows XP it could be that you're using ie6 in xp but not in the others and that its picking up on p3p problems. -Original Message- From: Sridhar Pedamallu [mailto:[EMAIL PROTECTED]] Sent: 06 September 2002 11:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Cookies in Windows XP Hi We are using cookies and client variables in our site. It works fine in win 98 or win 2000 etc except windows xp. Has anyone any suggestions to solve this. Any assistance much appreciated. reference site http://www.alphagalileo.org/ http://www.alphagalileo.org/ regards Sridhar Clear Thinking Group 100 New Kings Road, London SW6 4LX. Tel 0870 201 1601 Fax 0207 348 6089 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] non ascii MSword malarchy
hmmm yeah -- problem is the majority of (civil service) clients are too, how shall I say it, inexperienced and bloody stubborn to learn how to copy into Notepad... they just want you to scan or hotlink their documents magically onto the web :-) anyway I've found a tag that looks promising... will report back if any good, it looks like this annoys the hell out of everyone d - Original Message - From: Taz -=TT=- [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 1:18 PM Subject: Re: [ cf-dev ] non ascii MSword malarchy Its a complete arse.. I don't think there is a good way to stop the crap getting through, so I always tell clients to paste it into notepad, then copy it from there and paste it into activedit I think a bunch of Regexs to get rid of all the M$ crap would be a hell of a lot of code. Taz No -- various clients have CMS where they are copying contents of a Word doc into a form field (activeedit for instance) and then save it to their db. I'm looking for a way to strip illegal characters from this when it is submitted and convert them to ascii characters... hope that's clearer! -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] server_name
ok -- so cgi.server_name don't need no scoping... - Original Message - From: Matt Horn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:54 PM Subject: RE: [ cf-dev ] server_name SCOPING!! At 12:47 12/09/02 +0100, you wrote: douglas, that is exactly what he is already using. cgi.server_name and server_name is the same thing. -Original Message- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 12:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] server_name CGI.SERVER_NAME ?? maybe... -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 12:41 To: [EMAIL PROTECTED] Subject: [ cf-dev ] server_name Hi, I've been setting a session variable with #server_name# to give me a site URL -- however on our servers there are numerous proxied domains and server_name won't give me the correct URL for these. Does anyone have a way of grabbing the domain name of a site? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] server_name
Sorry shoulda been more specific -- proxy redirects are being used so the server name is the DNS name... - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 1:33 PM Subject: RE: [ cf-dev ] server_name I'm confused by this... DNS name www.whatever.com - Proxy webserver 1 Proxy webserver 2 Proxy webserver 3 So SERVER_NAME should aways be whatever.com ??? Unless, when you go to www.whatever.com you get *redirected* to http://xxx.xxx.xxx.xxx/whatever or http://proxy1.whatever.com In this case you chould use the HTTP_REFERER possibly. HTTP_HOST should give the server IP address if thats any help. Justin -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 12:41 To: [EMAIL PROTECTED] Subject: [ cf-dev ] server_name Hi, I've been setting a session variable with #server_name# to give me a site URL -- however on our servers there are numerous proxied domains and server_name won't give me the correct URL for these. Does anyone have a way of grabbing the domain name of a site? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] boredvision logs
I personally prefer Webtrends to Livestats -- seems to make more sense of the data and go deeper with it-- though it maybe cos it looked nicer or I had a dumbed down version of LiveStats... - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 1:45 PM Subject: RE: [ cf-dev ] boredvision logs yup, saw those cheers - any more? also - I would like opinions on what is the best web reporting software as well... is it webtrends - or livestats (from mediahouse) or funnelweb (yuck) etc -Original Message- From: Taz -=TT=- [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 13:57 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] boredvision logs Webtrends has components for broadvision. Taz Anyone know of any logging software that will analyse broadvision (bv) logs - not the web server hit logs, but the boredvision ones -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] server_name
Yeah -- that's what I was trying to avoid doing because this same prob runs across a number of the same applications so I was trying to save some work... kind of thing you always forget to reset when you're just copying across code to set up a new site. oh well = ;^) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:41 PM Subject: Re: [ cf-dev ] server_name cfset application.URL = www.whatever.com in application.cfm? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson damian.watson@euTo: [EMAIL PROTECTED] phony.net cc: Subject: Re: [ cf-dev ] server_name 09/12/02 02:32 PM Please respond to dev Using 4.5 on these servers gr ... it does seem to me that this will be a question of hardcoding the URL or setting it in the CMS or summit... tanx for trying ;0) - Original Message - From: Robert Scurr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:28 PM Subject: RE: [ cf-dev ] server_name Erm, is you proxy including anything in the header? If your using 5 or above... cfset test = GetHttpRequestData() cfdump var=#test# [EMAIL PROTECTED] 12/09/02 13:48:01 ok lets try another explanation. user type www.domain.com/whatever coldfusion generates the URL's as #server_name#/whatever which results in www2.domain.com/whatever as this is the actual server cf sits on this cannot happen, only the proxy server can request from this server, you cannot go to it directly. So u need to get the www.domain.com that was originally requested by user. Yes referer will get it for subsequent pages, but not the first and not for people who have softare that blocks this. -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 13:49 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] server_name So whats the problem ??? :-) Is the issue, you need to redirect them to the same box they start a session on? Might need to use HTTP_HOST Justin - missing something basic. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 13:31 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] server_name Sorry shoulda been more specific -- proxy redirects are being used so the server name is the DNS name... - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 1:33 PM Subject: RE: [ cf-dev ] server_name I'm confused by this... DNS name www.whatever.com - Proxy webserver 1 Proxy webserver 2 Proxy webserver 3 So SERVER_NAME should aways be whatever.com ??? Unless, when you go to www.whatever.com you get *redirected* to http://xxx.xxx.xxx.xxx/whatever or http://proxy1.whatever.com In this case you chould use the HTTP_REFERER possibly. HTTP_HOST should give the server IP address if thats any help. Justin -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 12 September 2002 12:41 To: [EMAIL PROTECTED] Subject: [ cf-dev ] server_name Hi, I've been setting a session variable with #server_name# to give me a site URL -- however on our servers there are numerous proxied domains and server_name won't give me the correct URL for these. Does anyone have a way of grabbing the domain name of a site? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED
Re: [ cf-dev ] More SQL Q's...
Can't you just shove an if in there along the lines of, if data exists for client and employer, select only client? - Original Message - From: Tim Blair [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:56 PM Subject: [ cf-dev ] More SQL Q's... Well, just the one for now anyway... I have a list of services, clients and employees. Each client is linked to a number of services (via a link table, in which the client and service IDs are specified, along with a cost to that client). The same is true for an employee. I want to SELECT a list of services available to a particular employee. An employee is linked to a client, so any service which is available to the client is available to the employee. That's no problem, nor is selecting the services directly linked to an employee. Now comes the tricky bit. If a service is lited under the client AND employee, I want to use the cost stored in the employee table. So if we have these under the client: Service number one : 123.45 Service number two : 1000.00 Service number three : 9.99 And these under the employee: Service number two : .11 Service number four : 19.95 I want the get the following info back: Service number one : 123.45 Service number two : .11 Service number three : 9.99 Service number four : 19.95 I've been playing around with UNION (not best I know) to grab all of the client and employee services and stick them together, but I'm stumped on the next bit. Not using UNION is a start I guess... ;o) Anyone? Cheers, Tim. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- rawnet ltd Atrium Court Bracknell[EMAIL PROTECTED] BerkshireTel : +44 (0) 1344 393 040 RG12 1BW, UK http://www.rawnet.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] why use cookie - was Logging Screen Resolution
Our recent research shows that 800 x 600 still accounts for the majority of user resolutions by quite some way (this is for the Department for Education and Skills)... next up I believe was 640 x 480 eeuuurrggghh - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 4:54 PM Subject: RE: [ cf-dev ] why use cookie - was Logging Screen Resolution Are most folks still developing for 800x600? we are. -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 17:08 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] why use cookie - was Logging Screen Resolution Yes, we already checked for cookies 99.99% using cookies , those with them turned off, are computer-smart-enough to set a decent resolution (maybe). Are most folks still developing for 800x600? Thanks Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 17:03 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] why use cookie - was Logging Screen Resolution requires cookies to be enabled in their browser. the other method will give you more results. But if cookies have to be enabled to access the site, then shouldn't make any difference. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Justin MacCarthy To: [EMAIL PROTECTED] macarthy@iolcc: .ie Subject: [ cf-dev ] why use cookie - was Logging Screen Resolution 09/17/02 05:02 PM Please respond to dev Well, it's lightweight and easy as there is only one way into the site [login page] - [home page] and as we already are logging the time / user + other info, adding #cookie.whatever# into the log is easy. We are just getting stats so we can target our next build. Is there a reason I shouldn't use this method? Thanks Justin -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 16:36 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Logging Screen Resolution - howto? just interested academically, but is there a specific reason why you're choosing the cookie route? -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 16:41 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Logging Screen Resolution - howto? Thanks all, Think I'll write a cookie with JS and read it and log with CF. Cheers, Justin -Original Message- From: Garry Mills [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 16:25 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Logging Screen Resolution - howto? Browserhawk also does it, but it's a sledgehammer solution unless you want all the other bells and whistles Also means it'll work if the client has Javascript disabled G -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 16:10 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Logging Screen Resolution - howto? I think JS is the only way. You could get the res and everything you need in JS first, then change the src attribute of an transparent gif to something like: document.myImage.src=resolution_logger.cfm?resolution= + resolution; -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 17 September 2002 16:19 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Logging Screen Resolution - howto? Hi, Is it possible to log Screen Resolution without using JavaScript? Is using javascript to write a cookie, and cf (or whatever) to read it to a log the best way?? Cheers Justin -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail:
Re: [ cf-dev ] OT: line breaks in dreamweaver
...are you not using the indent button in properties?? this if memory serves correct puts in a blockquote. Similarly to Word, you have to press return twice to end the blockquote tag... What version of Creambeaver are you using... may be an issue... - Original Message - From: Christopher Chaduka [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:57 PM Subject: Re: [ cf-dev ] OT: line breaks in dreamweaver I am waiting to hear this one. I also need to use the auto indent feature for my PHP code. I should be able to set this somewhere in some language specific conf file? Can DMW do that? At 15:52 09/25/2002 +0100, you wrote: Is there any way I can set dreamweaver so that new lines start with the same indent as the line I am coming from. At the moment when I press return the cursor goes right back to the margin so I have to hammer the tab button!! Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Emails
Justin (or anybody), Do you have any more handy tips for text emails?? Giles, I agree with Justin, html emails are a complete PITA for a lot of people... unless you have a very specific audience in mind, tis best to leave em alone. Cheers d ;0) - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 6:22 PM Subject: RE: [ cf-dev ] Emails Even if it is very simple html, users that use plain text mail settings, will see the html source. If you send both HTML plain text the messages become bigger. If you wrap your text at 80 chars you should be ok for most readers. use Chr(13) Chr(10) instead of BR / in text mails. Justin -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails It will be very simple html, really the only tag I will use is br I also have trouble sometimes with normal e-mails in that line breaks work sometimes and don't work other times which can be a real pain. Giles Roadnight http://giles.roadnight.name -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:13 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails safe=yes (assuming you are the only one sending it and not sending script stuff etc.) desirable=no I dislike html mails. If you are sending a plain text email, why don't use just send £ ? Justin -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Emails Hi Is it safe to send HTML e-mails to everyone who comes to my site? I tried sending a normal e-mail and pound; appears as pound; instead of £. Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Emails
True Rich, tho in this case you are sending to people with technical backgrounds who wouldn't be confused if they received source code in an email... agreed though, HTML definately much nicer ;-p - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:32 AM Subject: RE: [ cf-dev ] Emails having said that html e-mails are a pain, many people also really like them. the uk cfug newsletter IMHO is an example of an HTML newsletter done really well. we send Intel newsletters out in html (well, multipart actually) also which gets a lot of really positive feedback and hardly any negative because they look really great, are quick to load etc. also, using HTML means you can build in reporting functionality. snee-kay. -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 22:38 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails Cheers, I have gone for the text e-mails, just had to add some extra stuff in for the currency symbols. I was just trying to be lazy! Giles Roadnight http://giles.roadnight.name -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 22:19 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Emails Justin (or anybody), Do you have any more handy tips for text emails?? Giles, I agree with Justin, html emails are a complete PITA for a lot of people... unless you have a very specific audience in mind, tis best to leave em alone. Cheers d ;0) - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 6:22 PM Subject: RE: [ cf-dev ] Emails Even if it is very simple html, users that use plain text mail settings, will see the html source. If you send both HTML plain text the messages become bigger. If you wrap your text at 80 chars you should be ok for most readers. use Chr(13) Chr(10) instead of BR / in text mails. Justin -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails It will be very simple html, really the only tag I will use is br I also have trouble sometimes with normal e-mails in that line breaks work sometimes and don't work other times which can be a real pain. Giles Roadnight http://giles.roadnight.name -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:13 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails safe=yes (assuming you are the only one sending it and not sending script stuff etc.) desirable=no I dislike html mails. If you are sending a plain text email, why don't use just send £ ? Justin -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Emails Hi Is it safe to send HTML e-mails to everyone who comes to my site? I tried sending a normal e-mail and pound; appears as pound; instead of £. Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk
Re: [ cf-dev ] Emails
mm horse pudding - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 9:05 AM Subject: RE: [ cf-dev ] Emails well, its horses for courses really. Usually if a mail client doesn't support html then it'll drop down to the text only format if its a multipart format (and I do stress *usually*, some clients just break it full stop) If you know that most of the audience are going to be using Lotus Notes then use text only (although I think the latest version may be able to handle it) also, if you know most of your audience are going to be annoyed by html then use text only. the intel one doesn't actually have a techie audience, techies usually prefer text only formats. I know I do. Its nice to give the reader the option if possible. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 09:06 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Emails True Rich, tho in this case you are sending to people with technical backgrounds who wouldn't be confused if they received source code in an email... agreed though, HTML definately much nicer ;-p - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:32 AM Subject: RE: [ cf-dev ] Emails having said that html e-mails are a pain, many people also really like them. the uk cfug newsletter IMHO is an example of an HTML newsletter done really well. we send Intel newsletters out in html (well, multipart actually) also which gets a lot of really positive feedback and hardly any negative because they look really great, are quick to load etc. also, using HTML means you can build in reporting functionality. snee-kay. -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 22:38 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails Cheers, I have gone for the text e-mails, just had to add some extra stuff in for the currency symbols. I was just trying to be lazy! Giles Roadnight http://giles.roadnight.name -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 22:19 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Emails Justin (or anybody), Do you have any more handy tips for text emails?? Giles, I agree with Justin, html emails are a complete PITA for a lot of people... unless you have a very specific audience in mind, tis best to leave em alone. Cheers d ;0) - Original Message - From: Justin MacCarthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 6:22 PM Subject: RE: [ cf-dev ] Emails Even if it is very simple html, users that use plain text mail settings, will see the html source. If you send both HTML plain text the messages become bigger. If you wrap your text at 80 chars you should be ok for most readers. use Chr(13) Chr(10) instead of BR / in text mails. Justin -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails It will be very simple html, really the only tag I will use is br I also have trouble sometimes with normal e-mails in that line breaks work sometimes and don't work other times which can be a real pain. Giles Roadnight http://giles.roadnight.name -Original Message- From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:13 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Emails safe=yes (assuming you are the only one sending it and not sending script stuff etc.) desirable=no I dislike html mails. If you are sending a plain text email, why don't use just send £ ? Justin -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Emails Hi Is it safe to send HTML e-mails to everyone who comes to my site? I tried sending a normal e-mail and pound; appears as pound; instead of £. Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk
Re: [ cf-dev ] cfug
cfif session.username EQSnake cfthrow_as_far_as_possible /cfif ;0) I've used it too. - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 3:35 PM Subject: RE: [ cf-dev ] cfug Well, it works okay now! :) Must have known it was you and decided to throw an error rather than let you register!! Hoho!! ;) -Original Message- From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] cfug the register link on the newsletter don't work. oh and the site is currently broken. Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'CFUG'. The Error Occurred in E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_bannerad.cfm: line 54 Called from E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_header.cfm: line 74 Called from E:\Sites\www.ukcfug.org\live\wwwroot\app_layout.cfm: line 18 Called from E:\Sites\www.ukcfug.org\live\wwwroot\index.cfm: line 48 Called from E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_bannerad.cfm: line 54 Called from E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_header.cfm: line 74 Called from E:\Sites\www.ukcfug.org\live\wwwroot\app_layout.cfm: line 18 Called from E:\Sites\www.ukcfug.org\live\wwwroot\index.cfm: line 48 52 : set banner_page_impression_count = banner_page_impression_count + 1 53 : where banner_id = #qry_banner_get.banner_id# 54 : /cfquery 55 : 56 : cftransaction action=COMMIT / -- -- SQLupdate banner set banner_page_impression_count = banner_page_impression_count + 1 where banner_id = 2568 DATASOURCE ukcfug VENDORERRORCODE -1102 SQLSTATE HY000 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] cfug
At a school for the especially disadvantaged, I seem to remember that you were my course tutor. - Original Message - From: Russ 'Snake' Michaels [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 3:38 PM Subject: RE: [ cf-dev ] cfug did u learn that at web design school -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:41 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfug cfif session.username EQSnake cfthrow_as_far_as_possible /cfif ;0) I've used it too. - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 3:35 PM Subject: RE: [ cf-dev ] cfug Well, it works okay now! :) Must have known it was you and decided to throw an error rather than let you register!! Hoho!! ;) -Original Message- From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] cfug the register link on the newsletter don't work. oh and the site is currently broken. Error Occurred While Processing Request Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'CFUG'. The Error Occurred in E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_bannerad.cfm: line 54 Called from E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_header.cfm: line 74 Called from E:\Sites\www.ukcfug.org\live\wwwroot\app_layout.cfm: line 18 Called from E:\Sites\www.ukcfug.org\live\wwwroot\index.cfm: line 48 Called from E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_bannerad.cfm: line 54 Called from E:\Sites\www.ukcfug.org\live\wwwroot\display\dsp_header.cfm: line 74 Called from E:\Sites\www.ukcfug.org\live\wwwroot\app_layout.cfm: line 18 Called from E:\Sites\www.ukcfug.org\live\wwwroot\index.cfm: line 48 52 : set banner_page_impression_count = banner_page_impression_count + 1 53 : where banner_id = #qry_banner_get.banner_id# 54 : /cfquery 55 : 56 : cftransaction action=COMMIT / -- -- SQLupdate banner set banner_page_impression_count = banner_page_impression_count + 1 where banner_id = 2568 DATASOURCE ukcfug VENDORERRORCODE -1102 SQLSTATE HY000 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Alphabetical dumbass question
Hi, I'm making an index of users on a site which one can navigate through A-Z. I am trying to get each letter from the A_Z list of links to only appear if there are entries under that letter. I've done this but it's pretty query intensive and I'm wondering if anyone's got any other ideas. Currently I've created a list 'a,b,c,d' etc which I loop into a query which selects records where like #list#%. I then output the letters if there are any records from the query. Problem is, this gives me 26 queries which (if there were a large userbase) would be a nightmare. Any ideas? cheers d - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:49 PM Subject: Re: [ cf-dev ] CFMX, looping through error varaibles Thanks everyone for the help. Adrian, this looks like the one I am looking for. I already use similar loops to the error one I am tying to use to send me session, client and other variables but it will be a lot easier to use CFdump. is htis new in MX? Also I didn't think you could use cfmail in the error page. has this now changed? when I first did an error template I put all variables in a form and submitted to another page that e-mailed me as I didn't think you could use any CF in the error page. The grey box is a syntax error, it was just a deliberate error I did to test my error template. I didn't know that these were handled differently. Thanks for all of the help. Giles - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:36 PM Subject: RE: [ cf-dev ] CFMX, looping through error varaibles This might help you out, but I've just ripped it out of an application so you might need to wade through it a little. Put this in your Application.cfm file: cferror type=EXCEPTION exception=ANY template=/errors/exception.cfm mailto=[EMAIL PROTECTED] then put this in /errors/exception.cfm cfmail to=[EMAIL PROTECTED] from=My web site subject=An e-mail from My web site type=HTMLhtml head titleAn error has occurred/title /head body pAn error has occurred on My web site/p hr pError:/p cfdump var=#Error# pVariables:/p cfdump var=#Variables# pCGI:/p cfdump var=#CGI# pFile:/p cfdump var=#File# pURL:/p cfdump var=#URL# pForm:/p cfdump var=#Form# pCookie:/p cfdump var=#Cookie# pClient:/p cfdump var=#Client# pServer:/p cfdump var=#Server# pApplication:/p cfdump var=#Application# pSession:/p cfdump var=#Session# pRequest:/p cfdump var=#Request# /body /html/cfmail !--- Put your header cfinclude or cfmodule here --- cfoutput pUnfortunately an error has occurred on this web site./p pThe error has now been logged and the web site developers notified./p pWe are sorry for the inconvenience this has caused. If you would like to contact the web site technical support team, please send an e-mail to a href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/a./p pPlease a href=/return to the web site/a./p /cfoutput !--- Put your footer cfinclude or cfmodule here --- -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Alphabetical dumbass question
Thanks Neil, Time to RTFM 4 me ;0) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:18 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question Use an SP. If you perform all the logic within the DB, you should be able to return only the data required for display by CF/HTML. N -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:17 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Alphabetical dumbass question Hi, I'm making an index of users on a site which one can navigate through A-Z. I am trying to get each letter from the A_Z list of links to only appear if there are entries under that letter. I've done this but it's pretty query intensive and I'm wondering if anyone's got any other ideas. Currently I've created a list 'a,b,c,d' etc which I loop into a query which selects records where like #list#%. I then output the letters if there are any records from the query. Problem is, this gives me 26 queries which (if there were a large userbase) would be a nightmare. Any ideas? cheers d - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:49 PM Subject: Re: [ cf-dev ] CFMX, looping through error varaibles Thanks everyone for the help. Adrian, this looks like the one I am looking for. I already use similar loops to the error one I am tying to use to send me session, client and other variables but it will be a lot easier to use CFdump. is htis new in MX? Also I didn't think you could use cfmail in the error page. has this now changed? when I first did an error template I put all variables in a form and submitted to another page that e-mailed me as I didn't think you could use any CF in the error page. The grey box is a syntax error, it was just a deliberate error I did to test my error template. I didn't know that these were handled differently. Thanks for all of the help. Giles - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:36 PM Subject: RE: [ cf-dev ] CFMX, looping through error varaibles This might help you out, but I've just ripped it out of an application so you might need to wade through it a little. Put this in your Application.cfm file: cferror type=EXCEPTION exception=ANY template=/errors/exception.cfm mailto=[EMAIL PROTECTED] then put this in /errors/exception.cfm cfmail to=[EMAIL PROTECTED] from=My web site subject=An e-mail from My web site type=HTMLhtml head titleAn error has occurred/title /head body pAn error has occurred on My web site/p hr pError:/p cfdump var=#Error# pVariables:/p cfdump var=#Variables# pCGI:/p cfdump var=#CGI# pFile:/p cfdump var=#File# pURL:/p cfdump var=#URL# pForm:/p cfdump var=#Form# pCookie:/p cfdump var=#Cookie# pClient:/p cfdump var=#Client# pServer:/p cfdump var=#Server# pApplication:/p cfdump var=#Application# pSession:/p cfdump var=#Session# pRequest:/p cfdump var=#Request# /body /html/cfmail !--- Put your header cfinclude or cfmodule here --- cfoutput pUnfortunately an error has occurred on this web site./p pThe error has now been logged and the web site developers notified./p pWe are sorry for the inconvenience this has caused. If you would like to contact the web site technical support team, please send an e-mail to a href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/a./p pPlease a href=/return to the web site/a./p /cfoutput !--- Put your footer cfinclude or cfmodule here --- -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
Re: [ cf-dev ] Alphabetical dumbass question
Ah that looks good, thought there must be a SQL solution, I'll be trying that as soon as I can log into my server (Russ!) cheers everyone --- - Original Message - From: Peter Harrison [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:32 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question or perhaps some SQL like: SELECT DISTINCT SUBSTR([TBL_USER].[USERNAME], 1, 1) AS FIRSTLETTER ORDER BY FIRSTLETTER ASC (returns letters only where a username starts with that letter - or number or any character for that matter) -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:19 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question Use an SP. If you perform all the logic within the DB, you should be able to return only the data required for display by CF/HTML. N -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:17 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Alphabetical dumbass question Hi, I'm making an index of users on a site which one can navigate through A-Z. I am trying to get each letter from the A_Z list of links to only appear if there are entries under that letter. I've done this but it's pretty query intensive and I'm wondering if anyone's got any other ideas. Currently I've created a list 'a,b,c,d' etc which I loop into a query which selects records where like #list#%. I then output the letters if there are any records from the query. Problem is, this gives me 26 queries which (if there were a large userbase) would be a nightmare. Any ideas? cheers d - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:49 PM Subject: Re: [ cf-dev ] CFMX, looping through error varaibles Thanks everyone for the help. Adrian, this looks like the one I am looking for. I already use similar loops to the error one I am tying to use to send me session, client and other variables but it will be a lot easier to use CFdump. is htis new in MX? Also I didn't think you could use cfmail in the error page. has this now changed? when I first did an error template I put all variables in a form and submitted to another page that e-mailed me as I didn't think you could use any CF in the error page. The grey box is a syntax error, it was just a deliberate error I did to test my error template. I didn't know that these were handled differently. Thanks for all of the help. Giles - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:36 PM Subject: RE: [ cf-dev ] CFMX, looping through error varaibles This might help you out, but I've just ripped it out of an application so you might need to wade through it a little. Put this in your Application.cfm file: cferror type=EXCEPTION exception=ANY template=/errors/exception.cfm mailto=[EMAIL PROTECTED] then put this in /errors/exception.cfm cfmail to=[EMAIL PROTECTED] from=My web site subject=An e-mail from My web site type=HTMLhtml head titleAn error has occurred/title /head body pAn error has occurred on My web site/p hr pError:/p cfdump var=#Error# pVariables:/p cfdump var=#Variables# pCGI:/p cfdump var=#CGI# pFile:/p cfdump var=#File# pURL:/p cfdump var=#URL# pForm:/p cfdump var=#Form# pCookie:/p cfdump var=#Cookie# pClient:/p cfdump var=#Client# pServer:/p cfdump var=#Server# pApplication:/p cfdump var=#Application# pSession:/p cfdump var=#Session# pRequest:/p cfdump var=#Request# /body /html/cfmail !--- Put your header cfinclude or cfmodule here --- cfoutput pUnfortunately an error has occurred on this web site./p pThe error has now been logged and the web site developers notified./p pWe are sorry for the inconvenience this has caused. If you would like to contact the web site technical support team, please send an e-mail to a href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/a./p pPlease a href=/return to the web site/a./p /cfoutput !--- Put your footer cfinclude or cfmodule here --- -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk
Re: [ cf-dev ] Alphabetical dumbass question
How can you tell between the two? - Original Message - From: Stephen Fernandez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:48 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question yeah theyre no good for making coffee or pouring beer or washing the dishes. thats what women are for! ;-) -Original Message- From: Gordon Thomas [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 16:47 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question depends what u wanna do with them ;o) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 14:30 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question stored procedures = good. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:42 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question yes, SPuse them for everything, even the shittiest SQL query. -Original Message- From: Taz -=TT=- [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:39 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Alphabetical dumbass question Use an SP. Stored procedure my arse! SELECT DISTINCT LEFT(Surname,1) AS MyAlpha FROM User ORDER BY LEFT(Surname,1) Taz -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] This email has been scanned for viruses by NetBenefit using Sophos anti-virus technology This email has been scanned for viruses by NetBenefit using Sophos anti-virus technology -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Alphabetical dumbass question
so you're saying... WTFAYS? ;0) -- I guess I could set up a table with 26 columns a-z and when a user is registered just add 1 to the appropriate letter -- that would be normanised a bit more twould be another method - Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:44 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question Any ideas? Only guessing, but you could normalise the table a bit and say make 4 tables out of it and use 4 lists one for each table and use cf ISdefined which should limit the number of queries you do on each table as well, Sam`s Teach Yourself SQL in 24 Hours, is good for options around this as well and could give you some more ideas. Or you could give each user a queryid in the user table, then use the foreign key of their id to point at their list of links and use one quuery to output their info based on their queryid or somtin like that... regards Colm Colm Brazel MA CB Publications www.cbweb.net http://www.cbweb.net [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:17 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Alphabetical dumbass question Hi, I'm making an index of users on a site which one can navigate through A-Z. I am trying to get each letter from the A_Z list of links to only appear if there are entries under that letter. I've done this but it's pretty query intensive and I'm wondering if anyone's got any other ideas. Currently I've created a list 'a,b,c,d' etc which I loop into a query which selects records where like #list#%. I then output the letters if there are any records from the query. Problem is, this gives me 26 queries which (if there were a large userbase) would be a nightmare. Any ideas? cheers d - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:49 PM Subject: Re: [ cf-dev ] CFMX, looping through error varaibles Thanks everyone for the help. Adrian, this looks like the one I am looking for. I already use similar loops to the error one I am tying to use to send me session, client and other variables but it will be a lot easier to use CFdump. is htis new in MX? Also I didn't think you could use cfmail in the error page. has this now changed? when I first did an error template I put all variables in a form and submitted to another page that e-mailed me as I didn't think you could use any CF in the error page. The grey box is a syntax error, it was just a deliberate error I did to test my error template. I didn't know that these were handled differently. Thanks for all of the help. Giles - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:36 PM Subject: RE: [ cf-dev ] CFMX, looping through error varaibles This might help you out, but I've just ripped it out of an application so you might need to wade through it a little. Put this in your Application.cfm file: cferror type=EXCEPTION exception=ANY template=/errors/exception.cfm mailto=[EMAIL PROTECTED] then put this in /errors/exception.cfm cfmail to=[EMAIL PROTECTED] from=My web site subject=An e-mail from My web site type=HTMLhtml head titleAn error has occurred/title /head body pAn error has occurred on My web site/p hr pError:/p cfdump var=#Error# pVariables:/p cfdump var=#Variables# pCGI:/p cfdump var=#CGI# pFile:/p cfdump var=#File# pURL:/p cfdump var=#URL# pForm:/p cfdump var=#Form# pCookie:/p cfdump var=#Cookie# pClient:/p cfdump var=#Client# pServer:/p cfdump var=#Server# pApplication:/p cfdump var=#Application# pSession:/p cfdump var=#Session# pRequest:/p cfdump var=#Request# /body /html/cfmail !--- Put your header cfinclude or cfmodule here --- cfoutput pUnfortunately an error has occurred on this web site./p pThe error has now been logged and the web site developers notified./p pWe are sorry for the inconvenience this has caused. If you would like to contact the web site technical support team, please send an e-mail to a href=mailto:[EMAIL PROTECTED];[EMAIL PROTECTED]/a./p pPlease a href=/return to the web site/a./p /cfoutput !--- Put your footer cfinclude or cfmodule here --- -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around
Re: [ cf-dev ] Alphabetical dumbass question
hmmm yeah -- Taz's query works best thus far... nice an simple related question- can one convert from uppercase to lowercase, 'n vice versa when outputting? - Original Message - From: Russ 'Snake' Michaels [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:50 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question that would be awful. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Alphabetical dumbass question so you're saying... WTFAYS? ;0) -- I guess I could set up a table with 26 columns a-z and when a user is registered just add 1 to the appropriate letter -- that would be normanised a bit more twould be another method - Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:44 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question Any ideas? Only guessing, but you could normalise the table a bit and say make 4 tables out of it and use 4 lists one for each table and use cf ISdefined which should limit the number of queries you do on each table as well, Sam`s Teach Yourself SQL in 24 Hours, is good for options around this as well and could give you some more ideas. Or you could give each user a queryid in the user table, then use the foreign key of their id to point at their list of links and use one quuery to output their info based on their queryid or somtin like that... regards Colm Colm Brazel MA CB Publications www.cbweb.net http://www.cbweb.net [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:17 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Alphabetical dumbass question Hi, I'm making an index of users on a site which one can navigate through A-Z. I am trying to get each letter from the A_Z list of links to only appear if there are entries under that letter. I've done this but it's pretty query intensive and I'm wondering if anyone's got any other ideas. Currently I've created a list 'a,b,c,d' etc which I loop into a query which selects records where like #list#%. I then output the letters if there are any records from the query. Problem is, this gives me 26 queries which (if there were a large userbase) would be a nightmare. Any ideas? cheers d - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:49 PM Subject: Re: [ cf-dev ] CFMX, looping through error varaibles Thanks everyone for the help. Adrian, this looks like the one I am looking for. I already use similar loops to the error one I am tying to use to send me session, client and other variables but it will be a lot easier to use CFdump. is htis new in MX? Also I didn't think you could use cfmail in the error page. has this now changed? when I first did an error template I put all variables in a form and submitted to another page that e-mailed me as I didn't think you could use any CF in the error page. The grey box is a syntax error, it was just a deliberate error I did to test my error template. I didn't know that these were handled differently. Thanks for all of the help. Giles - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:36 PM Subject: RE: [ cf-dev ] CFMX, looping through error varaibles This might help you out, but I've just ripped it out of an application so you might need to wade through it a little. Put this in your Application.cfm file: cferror type=EXCEPTION exception=ANY template=/errors/exception.cfm mailto=[EMAIL PROTECTED] then put this in /errors/exception.cfm cfmail to=[EMAIL PROTECTED] from=My web site subject=An e-mail from My web site type=HTMLhtml head titleAn error has occurred/title /head body pAn error has occurred on My web site/p hr pError:/p cfdump var=#Error# pVariables:/p cfdump var=#Variables# pCGI:/p cfdump var=#CGI# pFile:/p cfdump var=#File# pURL:/p cfdump var=#URL# pForm:/p cfdump var=#Form# pCookie:/p cfdump var=#Cookie# pClient:/p cfdump var=#Client# pServer:/p cfdump var=#Server# pApplication:/p cfdump var=#Application# pSession:/p cfdump var=#Session# pRequest:/p cfdump var=#Request# /body /html/cfmail !--- Put your header cfinclude or cfmodule here --- cfoutput pUnfortunately an error has occurred on this web site./p pThe error has now been
Re: [ cf-dev ] Alphabetical dumbass question
Yeah, they get stuck in my mouse... oh no... I didn't say that - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:52 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question jeez, you must have hairy palms if you dont know that by now. :-) -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:52 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Alphabetical dumbass question How can you tell between the two? - Original Message - From: Stephen Fernandez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:48 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question yeah theyre no good for making coffee or pouring beer or washing the dishes. thats what women are for! ;-) -Original Message- From: Gordon Thomas [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 16:47 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question depends what u wanna do with them ;o) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 14:30 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question stored procedures = good. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:42 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Alphabetical dumbass question yes, SPuse them for everything, even the shittiest SQL query. -Original Message- From: Taz -=TT=- [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:39 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Alphabetical dumbass question Use an SP. Stored procedure my arse! SELECT DISTINCT LEFT(Surname,1) AS MyAlpha FROM User ORDER BY LEFT(Surname,1) Taz -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] This email has been scanned for viruses by NetBenefit using Sophos anti-virus technology This email has been scanned for viruses by NetBenefit using Sophos anti-virus technology -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Alphabetical dumbass question
Thanks for all, time for me to book myself into Highlander SQL course ;0) if they cater for hairy palmed hobbits d - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 4:02 PM Subject: Re: [ cf-dev ] Alphabetical dumbass question #UCase(variable)# #LCase(variable)# Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson damian@greenhouse-desTo: [EMAIL PROTECTED] ign.co.ukcc: Subject: Re: [ cf-dev ] Alphabetical dumbass question 10/10/02 03:59 PM Please respond to dev hmmm yeah -- Taz's query works best thus far... nice an simple related question- can one convert from uppercase to lowercase, 'n vice versa when outputting? - Original Message - From: Russ 'Snake' Michaels [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:50 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question that would be awful. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Alphabetical dumbass question so you're saying... WTFAYS? ;0) -- I guess I could set up a table with 26 columns a-z and when a user is registered just add 1 to the appropriate letter -- that would be normanised a bit more twould be another method - Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 3:44 PM Subject: RE: [ cf-dev ] Alphabetical dumbass question Any ideas? Only guessing, but you could normalise the table a bit and say make 4 tables out of it and use 4 lists one for each table and use cf ISdefined which should limit the number of queries you do on each table as well, Sam`s Teach Yourself SQL in 24 Hours, is good for options around this as well and could give you some more ideas. Or you could give each user a queryid in the user table, then use the foreign key of their id to point at their list of links and use one quuery to output their info based on their queryid or somtin like that... regards Colm Colm Brazel MA CB Publications www.cbweb.net http://www.cbweb.net [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 15:17 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Alphabetical dumbass question Hi, I'm making an index of users on a site which one can navigate through A-Z. I am trying to get each letter from the A_Z list of links to only appear if there are entries under that letter. I've done this but it's pretty query intensive and I'm wondering if anyone's got any other ideas. Currently I've created a list 'a,b,c,d' etc which I loop into a query which selects records where like #list#%. I then output the letters if there are any records from the query. Problem is, this gives me 26 queries which (if there were a large userbase) would be a nightmare. Any ideas? cheers d - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:49 PM Subject: Re: [ cf-dev ] CFMX, looping through error varaibles Thanks everyone for the help. Adrian, this looks like the one I am looking for. I already use similar loops to the error one I am tying to use to send me session, client and other variables but it will be a lot easier to use CFdump. is htis new in MX? Also I didn't think you could use cfmail in the error page. has this now changed? when I first did an error template I put all variables in a form and submitted to another page that e-mailed me as I didn't think you could use any CF in the error page. The grey box is a syntax error, it was just a deliberate error I did to test my error template. I didn't know that these were handled differently. Thanks for all of the help. Giles - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 10, 2002 2:36 PM Subject: RE: [ cf-dev ] CFMX
[ cf-dev ] SO Odditor / This is not secure in any way
Hi all, I've got a problem an a page where I'm getting an alert on load saying this is not secure in any way! . All there is in the page though is a simple select query and a So Editor Lite tag which is the only thing i could think would cause this. Just wondering if anyone has come across this before or has any idea what it might be. When clicking OK on the alert, a new browser window opens up going to macromedia's coldfusion site... d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] SO Odditor / This is not secure in any way
Here ya go: cfoutput query=get_text cf_soEditor_lite form=update_text field=update_text html=#update_text# scriptpath=#request.soeditor# width=450 height=300 singlespaced=false wordcount=true validateonsave=true fontdialog=false bold=true italic=true link=true find=true hr=false image=true unlink=false align=false list=false unindent=false indent=false format=false font=false size=false underline=false superscript=false subscript=false fgcolor=false bgcolor=false tables=false htmledit=true borders=false details=false /cfoutput - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 11:35 AM Subject: Re: [ cf-dev ] SO Odditor / This is not secure in any way Can we see some code? I use soeditor all the time and have had no problems. Cheers Dave At 11:31 10/16/2002 +0100, you wrote: Hi all, I've got a problem an a page where I'm getting an alert on load saying this is not secure in any way! . All there is in the page though is a simple select query and a So Editor Lite tag which is the only thing i could think would cause this. Just wondering if anyone has come across this before or has any idea what it might be. When clicking OK on the alert, a new browser window opens up going to macromedia's coldfusion site... d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Phipps CF Development Oxford, Oxfordshire. Telephone: +44(0)7718 896696 http://www.phipps-cf.co.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] SO Odditor / This is not secure in any way
I bet there is a script tag in there. Neil is right, replacing the offending data fixed the problem. I'd suggest that anyone using inline editors should clean fields of naughty script tags when submitting to a query. CleanFields.cfm (available from dev exchange) can be customised to do this and cleans out lots of MS nonsense anyway. - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 11:36 AM Subject: RE: [ cf-dev ] SO Odditor / This is not secure in any way check the code it is pulling from the DB.I bet there is a script tag in there. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED]] Sent: 16 October 2002 11:37 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SO Odditor / This is not secure in any way Here ya go: cfoutput query=get_text cf_soEditor_lite form=update_text field=update_text html=#update_text# scriptpath=#request.soeditor# width=450 height=300 singlespaced=false wordcount=true validateonsave=true fontdialog=false bold=true italic=true link=true find=true hr=false image=true unlink=false align=false list=false unindent=false indent=false format=false font=false size=false underline=false superscript=false subscript=false fgcolor=false bgcolor=false tables=false htmledit=true borders=false details=false /cfoutput - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 11:35 AM Subject: Re: [ cf-dev ] SO Odditor / This is not secure in any way Can we see some code? I use soeditor all the time and have had no problems. Cheers Dave At 11:31 10/16/2002 +0100, you wrote: Hi all, I've got a problem an a page where I'm getting an alert on load saying this is not secure in any way! . All there is in the page though is a simple select query and a So Editor Lite tag which is the only thing i could think would cause this. Just wondering if anyone has come across this before or has any idea what it might be. When clicking OK on the alert, a new browser window opens up going to macromedia's coldfusion site... d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Phipps CF Development Oxford, Oxfordshire. Telephone: +44(0)7718 896696 http://www.phipps-cf.co.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Dozy with functions
Thanks Duncan ;0) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 2:11 PM Subject: Re: [ cf-dev ] Dozy with functions #ReplaceList(yourVariable, p,/p,P,/P, , ALL)# #Left(yourVariable, 50)# all together: #Left(ReplaceList(yourVariable, p,/p,P,/P, , ALL), 50)# Personally I like the CFML Language Reference for the functions and tags. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson damian@greenhouse-desTo: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] Dozy with functions 11/26/02 02:07 PM Please respond to dev Hi, I need to to strip a variable of p/p tags and limit it to a number of characters in output... and my understanding of functions ain't all that! How do I do it? --and coincidentally, does anyone know of a good guide on using functions... the books are a little dry on this. d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT: ByPassing Style Sheets
This might seem pedantic Giles but do you actually need to put a table in -- couldn't you just use SoEditor for the content of the table... if could also save your client going off and doing frightful things with the tables! - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 2:05 PM Subject: Re: [ cf-dev ] OT: ByPassing Style Sheets The styles are all in a separate CSS file. Don't really know what you mean by the second Question. You can see the home page here: http://dev.scottishproperty.co.uk The problem is that the Cambuslang Investment Park bit on the left with the picture of the property should have a blue background as is defined in the table but the style overrides it. The site has not been launched yet so don't moan about any errors you may find = :-) - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 1:56 PM Subject: RE: [ cf-dev ] OT: ByPassing Style Sheets how are you defining the style sheet for the normal HTML? is it a custom style or is it a redefined HTML tag? -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED]] Sent: 16 January 2003 13:58 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: ByPassing Style Sheets Hi Sorry for the off topic post. We use SoEditor Lite (with the CSS support) to edit cfm files that are included in our home page. The problem is that if we give a table in SoEditor a blue background it looks blue in soEditor but when the file is included in the home page it turns to the background colour of the table defined in our style sheet. Is there a way to make a part of an HTML page ignore the style sheet? The only other way I can see of doing this is to dynamically create styles in our style sheet from the properties of tables and so in the include file. Then apply these new tempoary styles to the elements in the include file. I think this would work but it would be a bit of a nightmare catering for every different style that could be applied to a table or cell or row or font and so on. Thanks Giles -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] CSS for form tag
Paul did the margin 0px not work? -- it may be IE only... - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 12:39 PM Subject: RE: [ cf-dev ] CSS for form tag Wrong. The space does appear, it's just not next to the button. It shouldn't do... could you show us an example? Taz It should! The Form element is a blockstyle element and so it will output a newline to the browser. Blockstyle elements, p, blockquote, form etc don't add on top of each other, so if you put in two next to each other, they won't add two newlines, just one. Tables are blockstyle elements as well! It's correct! Trust me! The way to get round it btw: form.myStyle { display:inline; } And then reference: form class=myStyle input type=submit /form Etc... This doesn't work perfectly, but... It's the only solution I can come up with! Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regular Expression for Email and Domain checking - it works!
Impressive, but how about an email address such as [EMAIL PROTECTED] -- obviously this can be incorporated into the regex, but does anyone know of a comprehensive database or list of all valid domain names which one could throw into the regex (presumably one could bundle in a | delimited list of them) - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 1:43 PM Subject: RE: [ cf-dev ] Regular Expression for Email and Domain checking - it works! Holy shitnice one... very nice indeed. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 13:47 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regular Expression for Email and Domain checking - it works! Everyone, For those that can't be bothered to read to the bottom here is the regular expression for validating an email address: ^[a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^_ `\{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a -z0-9])|com|co[.]uk|net|org|com[.]uk)$ Having read the various RFC's around the place about domains and emails, I just thought I'd let you know what I'd found out! Here is the regular expression for validating the part before an @ in an email address: [a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+([.][a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+)* Basically, according to RFC 2822 (and I haven't checked what's updated it yet, so this may still be incomplete), this is the form that an address must take before the @ sign. It starts with either a digit or a number, or one of the other characters in there, and then can include a period, but must end in one of those characters (ie not in a period). There are 2 other forms of email address, but they are mainly for use internally within a mailserver (and are unimportant in terms of functionality of the regex) and it should be no problem to ignore them. My previous email outlined the regular expression for validating a domain name (simple form): ([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a-z0-9])|com| co[.]uk|net|org|com[.]uk) And you can create a regular expression for validating emails. Please note, that none of this is tested, although it does look okay to me ;). The regular expression then for testing if an email is valid is: [a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+([.][a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+)*@([a-z0- 9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a-z0-9])|com|co[.]uk |net|org|com[.]uk) (NOTE: watch the word wrap) Bearing in mind that CF needs to escape several of the characters in the regular expression, it becomes this: [a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^_` \{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a- z0-9])|com|co[.]uk|net|org|com[.]uk) And also taking into account that you need to check the whole string, ie this must be from the start to the end, you get: ^[a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^_ `\{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a -z0-9])|com|co[.]uk|net|org|com[.]uk)$ You can easily make this into a function or into a custom tag. In fact, I'll be nice and write the function for you: cfscript // returns true or false depending on whether or not it's valid function isValidEmail(emailstr) { regex = ^[a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^ _`\{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[ a-z0-9])|com|co[.]uk|net|org|com[.]uk)$; if(REFind(regex, emailstr)) { return true; } else return false; } /cfscript (NOTE: watch the word wrap again) I hope this helps you all sort your email addresses out okay now! Paul --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regular Expression for Email and Domain checking - it works!
aw dang... I didn't read the email properly... sorry! - Original Message - From: Damian Watson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 2:10 PM Subject: Re: [ cf-dev ] Regular Expression for Email and Domain checking - it works! Impressive, but how about an email address such as [EMAIL PROTECTED] -- obviously this can be incorporated into the regex, but does anyone know of a comprehensive database or list of all valid domain names which one could throw into the regex (presumably one could bundle in a | delimited list of them) - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 1:43 PM Subject: RE: [ cf-dev ] Regular Expression for Email and Domain checking - it works! Holy shitnice one... very nice indeed. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 13:47 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regular Expression for Email and Domain checking - it works! Everyone, For those that can't be bothered to read to the bottom here is the regular expression for validating an email address: ^[a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^_ `\{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a -z0-9])|com|co[.]uk|net|org|com[.]uk)$ Having read the various RFC's around the place about domains and emails, I just thought I'd let you know what I'd found out! Here is the regular expression for validating the part before an @ in an email address: [a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+([.][a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+)* Basically, according to RFC 2822 (and I haven't checked what's updated it yet, so this may still be incomplete), this is the form that an address must take before the @ sign. It starts with either a digit or a number, or one of the other characters in there, and then can include a period, but must end in one of those characters (ie not in a period). There are 2 other forms of email address, but they are mainly for use internally within a mailserver (and are unimportant in terms of functionality of the regex) and it should be no problem to ignore them. My previous email outlined the regular expression for validating a domain name (simple form): ([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a-z0-9])|com| co[.]uk|net|org|com[.]uk) And you can create a regular expression for validating emails. Please note, that none of this is tested, although it does look okay to me ;). The regular expression then for testing if an email is valid is: [a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+([.][a-zA-Z0-9!#$%'*+-/=?^_`{|}~]+)*@([a-z0- 9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a-z0-9])|com|co[.]uk |net|org|com[.]uk) (NOTE: watch the word wrap) Bearing in mind that CF needs to escape several of the characters in the regular expression, it becomes this: [a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^_` \{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a- z0-9])|com|co[.]uk|net|org|com[.]uk) And also taking into account that you need to check the whole string, ie this must be from the start to the end, you get: ^[a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^_ `\{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[a -z0-9])|com|co[.]uk|net|org|com[.]uk)$ You can easily make this into a function or into a custom tag. In fact, I'll be nice and write the function for you: cfscript // returns true or false depending on whether or not it's valid function isValidEmail(emailstr) { regex = ^[a-zA-Z0-9!##\$%''\*\+-/=\?\^_`\{\|}~]+([.][a-zA-Z0-9!##\$%''\*\+-/=\?\^ _`\{\|}~]+)*@([a-z0-9]([-]|[a-z0-9])*[a-z0-9][.])+(([a-z0-9]([-]|[a-z0-9])*[ a-z0-9])|com|co[.]uk|net|org|com[.]uk)$; if(REFind(regex, emailstr)) { return true; } else return false; } /cfscript (NOTE: watch the word wrap again) I hope this helps you all sort your email addresses out okay now! Paul --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional
Re: [ cf-dev ] OT: Mini computer WAS: RE: [ cf-dev ] Query_String length
That's more operations per second than the NHS. I'm impressed. - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 3:05 PM Subject: [ cf-dev ] OT: Mini computer WAS: RE: [ cf-dev ] Query_String length Not really that amazing when the last line says: The authors report that a microliter of solution could hold three trillion computers, which together would perform 66 operations a second. Not a very good number of operations is it! --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Writing Coldfusion
It's been of those days too... but don't you feel a sense of nurdy achievment when you've built a site without even viewing it using CF Studio or Notepad? Great if you're self-esteem is ebbing ;0) Ahem. Seriously though, the code that comes out of dreamweaver and its poorer imitators especially is abominable. If you're going to get sites to properly display across multiple browser versions you've got no option but to get hands an with it. Unless I've missed a few tricks since I stopped using it! - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 5:37 PM Subject: Re: [ cf-dev ] Writing Coldfusion So you really ARE an *SA* There's no arguing that. For the serious answer I'm actually kinda taken with DWMX - I just started getting the hang of UltraDev for design-type-stuff-merged-with CF - DWMX seems to be pretty good at handling that kind of stuff. There are a couple of little options changes you might need to make to stop it from crashing itself, but generally I find it pretty good. Of course, then there are times when I have gouts of code and DWMX and UD are driving me up the wall, so I retreat back to CF Studio 5 and use DWMX for site synchronisation and file locking. Regards Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] multipart email -- email coming out blank
Hi got a problem here. For some reason I'm getting a blank email sent. No errors are generated. Anyone come across this b4? Here's the cfmail code: cfset boundary = CreateUUID() cfmail to=#Form.Email# from=[EMAIL PROTECTED] subject=subject cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/newmember_plain.cfm --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/newmember_html.cfm --#boundary#-- /cfmail -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] multipart email -- email coming out blank
doh... you would be right there ta ;0) - Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:25 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Could be something in the cfinclude files like cfoutput which could cause a problem? Colm -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 14:13 To: [EMAIL PROTECTED] Subject: [ cf-dev ] multipart email -- email coming out blank Hi got a problem here. For some reason I'm getting a blank email sent. No errors are generated. Anyone come across this b4? Here's the cfmail code: cfset boundary = CreateUUID() cfmail to=#Form.Email# from=[EMAIL PROTECTED] subject=subject cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/newmember_plain.cfm --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/newmember_html.cfm --#boundary#-- /cfmail -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] multipart email -- email coming out blank
That may also be the trouble! I've got a stupid setup here at the moment with MX server on dev machine but using CF5 on web server so I may be missing a trick *don't ask*. I'll tell you when I've got it working. Nik, does your code work on 5? - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:31 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Damian, Does this work in CFMX? I wrote a custom tag to output multipart emails for the UKCFUG website. But if you can do it like this - well, that's a LOT easier! Cheers Niklas -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] multipart email -- email coming out blank Hi got a problem here. For some reason I'm getting a blank email sent. No errors are generated. Anyone come across this b4? Here's the cfmail code: cfset boundary = CreateUUID() cfmail to=#Form.Email# from=[EMAIL PROTECTED] subject=subject cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/newmember_plain.cfm --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/newmember_html.cfm --#boundary#-- /cfmail -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] multipart email -- email coming out blank
hehe soz @;^P - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 5:21 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Cheeky git! :P -Original Message- From: Taz [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 5:16 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] multipart email -- email coming out blank Nik, does your code work on 5? Nik's code? Work? You're funny... -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] multipart email -- email coming out blank
Ok all -- this code works nice (though I haven't had the chance to test it on a proper plain text client -- what's the best way to do that, Outlook / Express etc seem too cunning?). However it requires comments in it to send properly. Can anyone tell me why? See below: cfset boundary = CreateUUID() cfmail query=GetEmail to=#Email# from=#request.SiteEmail# subject=#GetMailShot.Subject# cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/PLAIN_adhoc.cfm --#boundary# !--- This comment is needed or the email comes out as plain text --- Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/HTML_adhoc.cfm !--- This comment also needed, a blank gap between cfinclude and boundary produces the blank email I was originally having trouble with --- --#boundary#-- /cfmail FYI- I got the code from http://www.thenetprofits.co.uk/coldfusion/faq/topic.cfm?TopicID=18 ;^D - Original Message - From: Alex Skinner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 6:35 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Niks gone to the CFUG meeting mate but check the dev exchange its on there. Alex -Original Message- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 18:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] multipart email -- email coming out blank There is a multipart custom tag for CF5, Nik, Any chance of letting me have that for CF5, thanks Colm [EMAIL PROTECTED] www.cbweb.net http://www.cbweb.net [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Niklas Richardson [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 17:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] multipart email -- email coming out blank Hi Damian, There is a multipart custom tag for CF5, I had to write a CFMX version as I didn't realise you could do it so easily with the code you did! Cheers Niklas -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 5:02 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] multipart email -- email coming out blank That may also be the trouble! I've got a stupid setup here at the moment with MX server on dev machine but using CF5 on web server so I may be missing a trick *don't ask*. I'll tell you when I've got it working. Nik, does your code work on 5? - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:31 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Damian, Does this work in CFMX? I wrote a custom tag to output multipart emails for the UKCFUG website. But if you can do it like this - well, that's a LOT easier! Cheers Niklas -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] multipart email -- email coming out blank Hi got a problem here. For some reason I'm getting a blank email sent. No errors are generated. Anyone come across this b4? Here's the cfmail code: cfset boundary = CreateUUID() cfmail to=#Form.Email# from=[EMAIL PROTECTED] subject=subject cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/newmember_plain.cfm --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/newmember_html.cfm --#boundary#-- /cfmail -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL
Re: [ cf-dev ] multipart email -- email coming out blank
hmmm, I'll give it a try later if I got a mo -- so you're basically saying to set text/plain as a default param for the email... - Original Message - From: Colm Brazel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 10:19 AM Subject: RE: [ cf-dev ] multipart email -- email coming out blank cfmailparam name=Mime-Version value=1.0 cfmailparam name=content-type value=text/plain charset=us-ascii Damian, Maybe your Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit below should be inside the first cfmailparam tag? Colm -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 21:37 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] multipart email -- email coming out blank Ok all -- this code works nice (though I haven't had the chance to test it on a proper plain text client -- what's the best way to do that, Outlook / Express etc seem too cunning?). However it requires comments in it to send properly. Can anyone tell me why? See below: cfset boundary = CreateUUID() cfmail query=GetEmail to=#Email# from=#request.SiteEmail# subject=#GetMailShot.Subject# cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/PLAIN_adhoc.cfm --#boundary# !--- This comment is needed or the email comes out as plain text --- Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/HTML_adhoc.cfm !--- This comment also needed, a blank gap between cfinclude and boundary produces the blank email I was originally having trouble with --- --#boundary#-- /cfmail FYI- I got the code from http://www.thenetprofits.co.uk/coldfusion/faq/topic.cfm?TopicID=18 ;^D - Original Message - From: Alex Skinner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 6:35 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Niks gone to the CFUG meeting mate but check the dev exchange its on there. Alex -Original Message- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 18:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] multipart email -- email coming out blank There is a multipart custom tag for CF5, Nik, Any chance of letting me have that for CF5, thanks Colm [EMAIL PROTECTED] www.cbweb.net http://www.cbweb.net [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Niklas Richardson [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 17:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] multipart email -- email coming out blank Hi Damian, There is a multipart custom tag for CF5, I had to write a CFMX version as I didn't realise you could do it so easily with the code you did! Cheers Niklas -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 5:02 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] multipart email -- email coming out blank That may also be the trouble! I've got a stupid setup here at the moment with MX server on dev machine but using CF5 on web server so I may be missing a trick *don't ask*. I'll tell you when I've got it working. Nik, does your code work on 5? - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 3:31 PM Subject: RE: [ cf-dev ] multipart email -- email coming out blank Damian, Does this work in CFMX? I wrote a custom tag to output multipart emails for the UKCFUG website. But if you can do it like this - well, that's a LOT easier! Cheers Niklas -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] multipart email -- email coming out blank Hi got a problem here. For some reason I'm getting a blank email sent. No errors are generated. Anyone come across this b4? Here's the cfmail code: cfset boundary = CreateUUID() cfmail to=#Form.Email# from=[EMAIL PROTECTED] subject=subject cfmailparam name=Content-Type value=multipart/alternative; boundary=#boundary# --#boundary# Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit cfinclude template=mailtemplates/newmember_plain.cfm --#boundary# Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable cfinclude template=mailtemplates/newmember_html.cfm --#boundary#-- /cfmail
[ cf-dev ] OT select list validator
Hi, anyone see anything wrong with this? //validate selectlists that need a value selected selectlist = new Array('selectitem','selectitem2'); for(element=0;elementselectlist.length;element++) { doc = eval('document.forms[0].'+selectlist[element]); if(doc.selectedIndex == -1) {alert('You must select at least one item for '+selectlist[element]); return false} } --or does anyone have an alternative? Soz for being lazy but I'm in a blinding rush! -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Kinda Hacking but ...
Jesus -- I actually am the webmaster of this site -- you lot going round scaring me i dunno... and as Russ says there only be select permissions on the public role so please no trying to monkey around, cos I'll cry. If anyone wants syndicated content i.e. up-to-date LEA info please use feedback on the site to request it and I'm sure we'll look at it in time. d ;0) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 11:08 AM Subject: RE: [ cf-dev ] Kinda Hacking but ... in the url is fine, otherwise url parameters would never work, but in the filename is not fine. e.g. fishchips.cfm is not going to work. this can be a problem where you're letting users upload files that might have invalid characters, but otherwise works pretty well. it's fully customisable though as to what you want to allow and deny, but the default settings seem pretty good. it also logs everything that gets rejected, so you can see any attempted hacks, or things that have ben rejected that should have been ok. http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/ tools/tools/urlscan.asp Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Kola Oyedeji [EMAIL PROTECTED]To: [EMAIL PROTECTED] yalty.com cc: Subject: RE: [ cf-dev ] Kinda Hacking but ... 03/04/2003 11:03 Please respond to dev I'm assuming that you can tell it what to filter out. Isn't ; used as part of a J2EE session identifier on the url? And surely it doesn't reject ampersands in the url? Kola -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 April 2003 10:09 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Kinda Hacking but ... works with IIS as part of the IISLockDown tool, although I think it can also be installed on it's own. checks no invalid stuff is going into the url, e.g. ; drop table admin would get rejected. can't remember it all, but it's things like ;.* etc. It keeps logfiles, you'd be surprised the amount of attempted url hacks for C:\cmd.exe etc. should be installed as a basic security measure on any NT/2000 server imho. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Kola Oyedeji [EMAIL PROTECTED]To: [EMAIL PROTECTED] yalty.com cc: Subject: RE: [ cf-dev ] Kinda Hacking but ... 03/04/2003 10:05 Please respond to dev While we're on the subject, what exactly does urlscan do? We don't use it here, we generally rely on using cfqueryparam and restricting DSNs I'm wondering if we should be using it. Thanks Kola -Original Message- From: Snake.Lists [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 18:24 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Kinda Hacking but ... I put a stop to things like a while ago. It did used to be possible tho. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 17:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Kinda Hacking but ... or how about updating some details, maybe insert a nice new LEA, delete those we don't like. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! --
Re: [ cf-dev ] form.fieldnames
Ian, could the problem be here: cfoutput query=artforms tr td#artform#/td tdinput type=checkbox name=artform value=#id#/td /tr /cfoutput Do you need instead input type=checkbox name=#id# -- at the moment your #Form.FormFields# variable is only going to contain one 'artform'. You need instead to create fields with the artforumid names. Then if they are checked, you will have a list to loop. Hope I haven't completely misunderstood! d - Original Message - From: Ian Westbrook [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 06, 2003 4:09 PM Subject: Re: [ cf-dev ] form.fieldnames can't get any of those suggestions to work. which raises the question - how do other people do it? surely writing checkbox choices to a db is a pretty common occurrence? Ian W - Original Message - From: Simon Horwith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 06, 2003 2:01 PM Subject: RE: [ cf-dev ] form.fieldnames BTW - I've just worked out the firewall issues I was having at my new company so I am now online. Greeting UK developers. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 14:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] form.fieldnames Ian, No * required in the DELETE. cfquery datasource=#dsn# DELETE FROM artformjoin WHERE userid = #variables.userid# /cfquery Use form[field] to reference the content of your form field. cfquery datasource=#dsn# INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #form[field]#) /cfquery Be aware that form.artform will be a comma delimited list of artform ids if the user selects more than one artform in form. You probably need some this like this. cfif field eq 'artform' cfloop list=#form[field]# index=artformid cfquery datasource=#dsn# INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #artformid#) /cfquery /cfloop /cfif Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] form.fieldnames
Ah! Didn't know that ;0) It does seem a little overcomplicated doing it this way though. Surely it would be easier to loop the names of the fields to set up form params defaulted to 0 and then if a value of 1 is passed, insert into the join table? - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 06, 2003 4:42 PM Subject: RE: [ cf-dev ] form.fieldnames Do you need instead input type=checkbox name=#id# -- at the moment your #Form.FormFields# variable is only going to contain one 'artform'. You need instead to create fields with the artforumid names. Then if they are checked, you will have a list to loop. No, if more than one checkbox with the same name is checked, you receive all the contents as a list of the same name as the checkbox name. ie this: input type=checkbox name=myBox value=1 checked input type=checkbox name=myBox value=2 checked will yield one variable called form.myBox with a value of 1,2. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 16:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] form.fieldnames Ian, could the problem be here: cfoutput query=artforms tr td#artform#/td tdinput type=checkbox name=artform value=#id#/td /tr /cfoutput Do you need instead input type=checkbox name=#id# -- at the moment your #Form.FormFields# variable is only going to contain one 'artform'. You need instead to create fields with the artforumid names. Then if they are checked, you will have a list to loop. Hope I haven't completely misunderstood! d - Original Message - From: Ian Westbrook [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 06, 2003 4:09 PM Subject: Re: [ cf-dev ] form.fieldnames can't get any of those suggestions to work. which raises the question - how do other people do it? surely writing checkbox choices to a db is a pretty common occurrence? Ian W - Original Message - From: Simon Horwith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 06, 2003 2:01 PM Subject: RE: [ cf-dev ] form.fieldnames BTW - I've just worked out the firewall issues I was having at my new company so I am now online. Greeting UK developers. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 14:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] form.fieldnames Ian, No * required in the DELETE. cfquery datasource=#dsn# DELETE FROM artformjoin WHERE userid = #variables.userid# /cfquery Use form[field] to reference the content of your form field. cfquery datasource=#dsn# INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #form[field]#) /cfquery Be aware that form.artform will be a comma delimited list of artform ids if the user selects more than one artform in form. You probably need some this like this. cfif field eq 'artform' cfloop list=#form[field]# index=artformid cfquery datasource=#dsn# INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #artformid#) /cfquery /cfloop /cfif Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL
Re: [ cf-dev ] form.fieldnames
take your point, I get it now :) - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 06, 2003 5:11 PM Subject: RE: [ cf-dev ] form.fieldnames It does seem a little overcomplicated doing it this way though. Surely it would be easier to loop the names of the fields to set up form params defaulted to 0 and then if a value of 1 is passed, insert into the join table? not really, as that way you need to find all your ids again (prob by a database query), then loop over these using cfparam to default them all, and then check whether each one is zero or not before inserting. If you do it the way Ian was doing it, then you only need one cfparam to ensure that there the form variable exists, even if its empty, and then you just need to loop over the that list. If its empty, no inserts happen, if its not, then those ids get entered into the database. You don't need to check if they're zero or something else. so compare this: form.cfm === cfoutput query=myIds input type=checkbox name=myBox value=#id#br /cfoutput action.cfm == cfparam name=form.myBox default= cfif listlen(form.myBox) cfquery. Do insert. /cfif = to this: form.cfm === cfoutput query=myIds input type=checkbox name=myBox_#id# value=1br /cfoutput = action.cfm == cfquery name=myBoxes datasource=#dsn# SELECT id FROM myBoxes /cfquery cfloop query=myBoxes cfparam name=form.myBox_#id# default=0 /cfloop cfloop query=myBoxes cfif form[myBox_ id] cfquery... Do Insert. /cfif /cfloop = Method 1 is faster cf_emphasisin this instance/cf_emphasis. There are of course, other times when you method would be more correct, which I can't even begin to think of this close to the booze hour. Rich -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] percentages of values in recordset
Thanks Rich, don't think I explained myself very well though. What I'm trying to do is: SELECT myValue, COUNT(myValue) AS Whatever FROM myTable Where myValue=1 (and then on up to 5) Then output the count as a percentage of the whole recordcount. I realise I could loop it from 1 to 5 but myValue is already being looped and I'm going to end up with a silly amount of queries generated Cheers d - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:12 PM Subject: RE: [ cf-dev ] percentages of values in recordset SELECT myValue, COUNT(myValue) FROM myTable GROUP BY myValue -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 15:21 To: [EMAIL PROTECTED] Subject: [ cf-dev ] percentages of values in recordset Hi, Pretty dumbass question but I'm working on a poll where for instance I have a column with 5 possible values (1 to 5). Say there are 50 records. How do I get the number of records for each value without doing 5 queries? Cheers d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] percentages of values in recordset
That bit's easy enough. The column I'm selecting records from has 5 possible values (1-5). I'm trying to count the number of times the value appears in the column's recordset without writing 5 queries with the where clause. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:40 PM Subject: Re: [ cf-dev ] percentages of values in recordset (query.Whatever / query.RecordCount) * 100 ??? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: Re: [ cf-dev ] percentages of values in recordset 11/06/2003 15:36 Please respond to dev Thanks Rich, don't think I explained myself very well though. What I'm trying to do is: SELECT myValue, COUNT(myValue) AS Whatever FROM myTable Where myValue=1 (and then on up to 5) Then output the count as a percentage of the whole recordcount. I realise I could loop it from 1 to 5 but myValue is already being looped and I'm going to end up with a silly amount of queries generated Cheers d - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:12 PM Subject: RE: [ cf-dev ] percentages of values in recordset SELECT myValue, COUNT(myValue) FROM myTable GROUP BY myValue -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 15:21 To: [EMAIL PROTECTED] Subject: [ cf-dev ] percentages of values in recordset Hi, Pretty dumbass question but I'm working on a poll where for instance I have a column with 5 possible values (1 to 5). Say there are 50 records. How do I get the number of records for each value without doing 5 queries? Cheers d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] percentages of values in recordset
ok -- I really have confused things! Maybe it's the way I've asked the question. I have a solution though that at least saves me querying lots, it'll help you see what I'm doing. cfparam name=Value1 default=0 ...same for 2,3,4,5 cfquery name=QueryName SELECT ColumnName, COUNT(ColumnName) AS Count FROM TableName /cfquery cfloop query=QueryName cfif ColumnName EQ 1 cfset Value1=Value1 + 1 cfelseif ColumnName EQ 2 cfset Value2=Value2 + 1 etc etc... /cfif /cfloop Then to get the percentage: cfoutput query=QueryName#DecimalFormat(Evaluate((Value1 / Count) * 100))# %/cfoutput Apologies if I'm being stoopid ;0) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:55 PM Subject: Re: [ cf-dev ] percentages of values in recordset how about this. i'm making an assumption about how you're getting your 1-5 list: cfquery name=getPoll select myValue from myTable order by myValue /cfquery cfoutput query=getPoll group=myValue cfquery name=getVotes SELECT COUNT(myValue) AS Whatever FROM myTable WHERE myValue = #getPoll.myValue# /cfquery #getPoll.myValue#: #getVotes.Whatever# times cfset percent = (getVotes.Whatever/ getPoll.RecordCount) * 100 #percent# % /cfoutput Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: Re: [ cf-dev ] percentages of values in recordset 11/06/2003 15:45 Please respond to dev That bit's easy enough. The column I'm selecting records from has 5 possible values (1-5). I'm trying to count the number of times the value appears in the column's recordset without writing 5 queries with the where clause. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:40 PM Subject: Re: [ cf-dev ] percentages of values in recordset (query.Whatever / query.RecordCount) * 100 ??? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: Re: [ cf-dev ] percentages of values in recordset 11/06/2003 15:36 Please respond to dev Thanks Rich, don't think I explained myself very well though. What I'm trying to do is: SELECT myValue, COUNT(myValue) AS Whatever FROM myTable Where myValue=1 (and then on up to 5) Then output the count as a percentage of the whole recordcount. I realise I could loop it from 1 to 5 but myValue is already being looped and I'm going to end up with a silly amount of queries generated Cheers d - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:12 PM Subject: RE: [ cf-dev ] percentages of values in recordset SELECT myValue, COUNT(myValue) FROM myTable GROUP BY myValue -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 15:21 To: [EMAIL PROTECTED] Subject: [ cf-dev ] percentages of values in recordset Hi, Pretty dumbass question but I'm working on a poll where for instance I have a column with 5 possible values (1 to 5). Say there are 50 records. How do I get the number of records for each value without doing 5 queries? Cheers d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED
Re: [ cf-dev ] percentages of values in recordset
Ah ok... beginner's SQL course for me. Thanks everyone. d - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:03 PM Subject: Re: [ cf-dev ] percentages of values in recordset ok -- I really have confused things! Maybe it's the way I've asked the question. I have a solution though that at least saves me querying lots, it'll help you see what I'm doing. cfparam name=Value1 default=0 ...same for 2,3,4,5 cfquery name=QueryName SELECT ColumnName, COUNT(ColumnName) AS Count FROM TableName /cfquery One quick note, don't use count as the alias for the count(columnname) - even ColCount is better. Count is a reserved word (or potentially is) so you need to avoid using them as column names, variables etc. cfloop query=QueryName cfif ColumnName EQ 1 cfset Value1=Value1 + 1 cfelseif ColumnName EQ 2 cfset Value2=Value2 + 1 etc etc... /cfif /cfloop If you put GROUP BY ColumnName on the end of your query above, then you don't need to do this. The COUNT(ColumnName) will return the Value1 through Value5 along side in the query. Then to get the percentage: cfoutput query=QueryName#DecimalFormat(Evaluate((Value1 / Count) * 100))# %/cfoutput If you put the GROUP BY on the end of the query, then use Rich's bit of script to add up the total number of Poll responses cfset totalresponses = arraysum(listtoarray(valuelist(QueryName.ColCount))) You can output the percentages like this : Total Responses : cfoutput#totalresponses#/cfoutput cfoutput query=QueryName cfset ColPercent = (ColCount/TotalResponses) *100 #ColumnName# - #ColCount# - #DecimalFormat(ColPercent)#% /cfoutput The query with the GROUP BY is already totaling up the number of responses per option for you, so all you need to do is work out the total number of responses from the query (Rich's code) and then you have 5 (the number of options in your poll) rows in a query to work out the percentages for. Hope this helps. Regards Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Anyone in Sussex area...
that needs development work from time to time. Email me off list with list of sites and rates! - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:34 AM Subject: RE: [ cf-dev ] XML feeds Thanks Rich. I actually found something on www.devx.com which helped a lot but there code was a little shabby so looking at your code was a great help. Cheers Dave At 09:41 6/17/2003 +0100, you wrote: Hi Dave, Luckily, to produce XML feeds doesn't take much knowledge of XML (its very boring and I can't help fall asleep when people start talking about it) So I'll tell you the layman's guide to producing feeds. You have a couple of options. You can either produce the feed with the fields you want to use (Custom XML), but for things like news releases, they usually follow a standard format (title, author, date, content etc) and so you can use the widely accepted RSS format (Rich Site Summary) that Netscape created and then handed over to the people. Lots and lots of aggregators (eg http://www.syndic8.com ) and feedreaders (eg http://www.feedreader.com ) accept RSS, its all documented and premade, so you don't have to worry about schemas, DTD's etc, you just create the file. I have an example at Funjunkie that works really well: http://www.funjunkie.co.uk/news.xml This feed is a static file generated by a simple Coldfusion page and saved out as a .xml file. Here's the code: cfcontent type=application/xmlcfsetting enablecfoutputonly=yes cfquery name=articles datasource=#dsn# dbtype=ODBC cachedwithin=#createtimespan(7,0,0,0)# EXEC front_page_articles /cfquery cfsetting enablecfoutputonly=no?xml version=1.0 encoding=UTF-8 ? !DOCTYPE rss PUBLIC -//Netscape Communications//DTD RSS 0.91//EN http://my.netscape.com/publish/formats/rss-0.91.dtd; rss version=0.91 channel titleFunjunkie/title linkhttp://www.funjunkie.co.uk/link descriptionIrreverent, Offbeat Weblog/description languageen-gb/language copyrightCopyright 2003, funjunkie.co.uk. All Rights Reserved/copyright managingEditor[EMAIL PROTECTED]/managingEditor webMaster[EMAIL PROTECTED]/webMaster cfoutput query=articles maxrows=15cfset description = rereplacenocase(article_desc, [^]*, , ALL) item title#xmlformat(title)#/title linkhttp://www.funjunkie.co.uk/news_archive.cfm?date=#dateformat(date_pub l ish, 'mmyy')article_id#/link description#xmlformat(description)#/description /item /cfoutput /channel /rss and thats it! (watch out for wrap) You can find an excellent list of RSS resources at http://www.larkfarm.com/rss_resources.htm as well as a quickstart guide to help you understand it more. There are 3 versions of RSS which are produced by different people RSS 0.91 is probably still the most widely used, but you can publish in all the formats to be safe (Funjunkie publishes in 0.91, 1.0, 2.0 and in WDDX). Be careful in thinking that the different versions relate to the chronological updates to RSS. Unfortunately, theres a lot of bad blood in the XML world with Dave Winer et al getting at each others throats and stabbing each other in the back and so one camp is deleoping RSS 1.0 and the other is developing RSS 2.0. In reality they're completely different. It makes it all very confusing for developers and I wish they'd sort it the f out quite personally. Rich -Original Message- From: Dave Phipps [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 07:30 To: ColdFusion User group Subject: [ cf-dev ] XML feeds Hi, I am still getting to grips with XML and I have a client site that provides news releases via email to subscribers. They are now requesting the option of XML feeds that would be available to remote sites to connect to. I presume this is an ideal candidate for a web service. I am not quite sure where to start. Can anyone point to some good online resources about putting together some basic XML feeds? Has anyone done something similar they would care to share? (the site is for a reg'd charity and therefore funds are a little tight!) Thanks Dave -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive:
Re: [ cf-dev ] Anyone in Sussex area...
It's an offer for work :) Ash--- I seen you there with your orange moccachinos - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:53 AM Subject: RE: [ cf-dev ] Anyone in Sussex area... Its scary down south, they are all trendified and drink in al fresco bars on the seafront and stuff. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:47 AM To: [EMAIL PROTECTED] Subject: [ cf-dev ] Anyone in Sussex area... that needs development work from time to time. Email me off list with list of sites and rates! - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:34 AM Subject: RE: [ cf-dev ] XML feeds Thanks Rich. I actually found something on www.devx.com which helped a lot but there code was a little shabby so looking at your code was a great help. Cheers Dave At 09:41 6/17/2003 +0100, you wrote: Hi Dave, Luckily, to produce XML feeds doesn't take much knowledge of XML (its very boring and I can't help fall asleep when people start talking about it) So I'll tell you the layman's guide to producing feeds. You have a couple of options. You can either produce the feed with the fields you want to use (Custom XML), but for things like news releases, they usually follow a standard format (title, author, date, content etc) and so you can use the widely accepted RSS format (Rich Site Summary) that Netscape created and then handed over to the people. Lots and lots of aggregators (eg http://www.syndic8.com ) and feedreaders (eg http://www.feedreader.com ) accept RSS, its all documented and premade, so you don't have to worry about schemas, DTD's etc, you just create the file. I have an example at Funjunkie that works really well: http://www.funjunkie.co.uk/news.xml This feed is a static file generated by a simple Coldfusion page and saved out as a .xml file. Here's the code: cfcontent type=application/xmlcfsetting enablecfoutputonly=yes cfquery name=articles datasource=#dsn# dbtype=ODBC cachedwithin=#createtimespan(7,0,0,0)# EXEC front_page_articles /cfquery cfsetting enablecfoutputonly=no?xml version=1.0 encoding=UTF-8 ? !DOCTYPE rss PUBLIC -//Netscape Communications//DTD RSS 0.91//EN http://my.netscape.com/publish/formats/rss-0.91.dtd; rss version=0.91 channel titleFunjunkie/title linkhttp://www.funjunkie.co.uk/link descriptionIrreverent, Offbeat Weblog/description languageen-gb/language copyrightCopyright 2003, funjunkie.co.uk. All Rights Reserved/copyright managingEditor[EMAIL PROTECTED]/managingEditor webMaster[EMAIL PROTECTED]/webMaster cfoutput query=articles maxrows=15cfset description = rereplacenocase(article_desc, [^]*, , ALL) item title#xmlformat(title)#/title linkhttp://www.funjunkie.co.uk/news_archive.cfm?date=#dateformat(date_pub l ish, 'mmyy')article_id#/link description#xmlformat(description)#/description /item /cfoutput /channel /rss and thats it! (watch out for wrap) You can find an excellent list of RSS resources at http://www.larkfarm.com/rss_resources.htm as well as a quickstart guide to help you understand it more. There are 3 versions of RSS which are produced by different people RSS 0.91 is probably still the most widely used, but you can publish in all the formats to be safe (Funjunkie publishes in 0.91, 1.0, 2.0 and in WDDX). Be careful in thinking that the different versions relate to the chronological updates to RSS. Unfortunately, theres a lot of bad blood in the XML world with Dave Winer et al getting at each others throats and stabbing each other in the back and so one camp is deleoping RSS 1.0 and the other is developing RSS 2.0. In reality they're completely different. It makes it all very confusing for developers and I wish they'd sort it the f out quite personally. Rich -Original Message- From: Dave Phipps [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 07:30 To: ColdFusion User group Subject: [ cf-dev ] XML feeds Hi, I am still getting to grips with XML and I have a client site that provides news releases via email to subscribers. They are now requesting the option of XML feeds that would be available to remote sites to connect to. I presume this is an ideal candidate for a web service. I am not quite sure where to start. Can anyone point to some good online resources about putting together some basic XML feeds? Has anyone
[ cf-dev ] CFUN
Anyone going from UK? -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] CFStudio v5 - Saving files in wrong folder
Or you could just use 'Save As' -- but as Paul says, using the FTP connector is much more stable - Original Message - From: Paul Fennell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 11:36 AM Subject: RE: [ cf-dev ] CFStudio v5 - Saving files in wrong folder Lo its a known Bug with cf studio and yes it saves the file into the last folder created To ensure you save correctly - just reconnect to the RDS after creating a folder or Use the more reliable and less flaky FTP connecter - (ps the above bug got me an allaire hat and shirt - and they never fixed it ;O ) - Paul Fennell ([EMAIL PROTECTED]) - Satachi Support ([EMAIL PROTECTED]) -Original Message- From: Richard Burkitt [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 10:11 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CFStudio v5 - Saving files in wrong folder Hi, I am using CFStudio version 5 and quite often, when saving files on an RDS server, the file gets saved into a completely different folder. I have not managed to pin down exactly under what circumstances this happens but it could be after I create a sub folder somewhere. Does anyone know if there are there any patches that fix this? Many thanks, Rich -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.483 / Virus Database: 279 - Release Date: 19/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.483 / Virus Database: 279 - Release Date: 19/05/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] CFC's was RE: [ cf-dev ] so....
I totally agree Paul. As someone said a while back, not all CF developers have a programming background, without real world examples easliy available and well documented one ends up programming to what one knows. I assume most of us don't have time to be bogged down in learning from scratch from books, but we have a lot of catching up to do with the old skool programmers and the thinking behind applications. I saw Raymond Camden talk about CFCs at CFUN and it was useful, for instance he went through the use of web services, but other than that I didn't get a nice easy, this is how it works in simple language and these are the things it does for you. It's much easier to learn when you are given a good overview of the purpose of what you're learning, and I haven't found anything yet that is particularly helpful. I agree with Simon that CF web applications should grow up a little (when needed) but we need much better literature (online and offline). Why don't you write a book Simon- you're good at explaining stuff ;0) d - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 3:16 PM Subject: RE: [ cf-dev ] CFC's was RE: [ cf-dev ] so :D I love CFMX and think that it's a definite improvement on the prior versions of CF. However the issues are: A) training B) marketing The training and marketing of CFMX is still aiming at the wrong people - ie new developers, HTML developers - and not aimed at people who've been doing CF since version -2.93. Not only that, but I don't think there is enough output from MM on real-world scenarios and (as has already been said) best-practices or anything like that. It's there, but not wonderfully accessible. I think CFC's are a fantastic idea, and a really useful tool. I have made a few test CFC's on my machine and like them. However, I have had no reason to use them in a real world application, because there is not enough CFMX out there that is being used with the clients I am working with. Maybe it's just my clients, but if MM really wanted lots of people to be using CFC's, they'd be giving people free/cheap upgrades to MX, promoting madly to try and get people on board etc. They aren't! They are marketing it as It's CF, just better and it needs to be sorted out if MM want us to make more of it! I place the responsibility for the lack of training and understanding of these tools firmly at MM's feet. However, I doubt if they will change much because of what I've said! Whatever happened to Here's a real world CFC that you can use or Here's all the features of CFMX in a complete real-world application or something rather than trying to explain the best ways to use Flash as a front end (which imho is actually far less useful to most of the CF Developers I know!). Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 15:02 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFC's was RE: [ cf-dev ] so this is a good debate. i think there's still a big market for ye olde CF 5. the beauty of CF used to be that a complete newbie could probably install the server and get their first CF page up and running in a very short space of time. If you could understand an HTML tag and the basics of Iteration, Selection, Sequence, then you knew enough to understand the majority of CFML. I don't know the same could be said of CFMX, and I think it'll deter any newbies from picking it up. Existing CF heads can maybe manage, but anyone who's got to learn their first server-side application language are probably more likely than ever before to go with PHP. just my 2pence. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Paul Johnston [EMAIL PROTECTED]To: [EMAIL PROTECTED] tions.com cc: Subject: RE: [ cf-dev ] CFC's was RE: [ cf-dev ] so 03/07/2003 14:39 Please respond to dev I am not sure if it's whether we use their full power or whether they are actually not that useful for the majority of sites. Its interesting. Many developers aren't sure whether their old apps should now be using CFCs, or any new ones should be, or whether they should be using them at all. Very true I don't see the point in using some of the features of coldfusion for the majority of sites
Re: [ cf-dev ] Client Management Tools
Ditto that... anyone know of anything CF based? Paul -- if you end up having to build something I'll give you a hand scoping it if you want. - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 11:49 AM Subject: RE: [ cf-dev ] Client Management Tools Ok... Something like that, although I don't want to pay for it... Just not have the hassle of a few hours sitting here and coding something that will work, but I'll miss somethings I'm sure! Paul -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 11:46 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Client Management Tools what like a ticket tool? You can probably get a cheap copy of SiteSpring somewhere! -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 11:47 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Client Management Tools I want to be able to organise my clients to let me know when there are bugs for software, and what needs doing, who to contact etc... I've looked on the MM exchange and can't find that kind of tool with their (pretty useless imho) search tools! Anyone? Tool must be free (or I'll write it myself) Paul --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Client Management Tools
Well I'm probably gonna have a bash at one if I have time anyway, happy to keep it open to the list. :0P - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 1:33 PM Subject: RE: [ cf-dev ] Client Management Tools Oooh... Sounds like another open source CF project on sourceforge coming along! Erm... Not at the moment! Having a look at RT (although seems a bit OTT for my liking!) Found this: http://www.triangle-solutions.com/triangle.html?page=support Which is simple and effective! Does the job which is to store customer bugs and things like that for the admin to respond to... Doesn't do much more. Paul -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 13:28 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Client Management Tools Ditto that... anyone know of anything CF based? Paul -- if you end up having to build something I'll give you a hand scoping it if you want. - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 11:49 AM Subject: RE: [ cf-dev ] Client Management Tools Ok... Something like that, although I don't want to pay for it... Just not have the hassle of a few hours sitting here and coding something that will work, but I'll miss somethings I'm sure! Paul -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 11:46 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Client Management Tools what like a ticket tool? You can probably get a cheap copy of SiteSpring somewhere! -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 11:47 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Client Management Tools I want to be able to organise my clients to let me know when there are bugs for software, and what needs doing, who to contact etc... I've looked on the MM exchange and can't find that kind of tool with their (pretty useless imho) search tools! Anyone? Tool must be free (or I'll write it myself) Paul --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] damn MM website
Some say that designers have large monitors to compensate for a lack in other areas ;0) - Original Message - From: Mark Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 9:56 AM Subject: [ cf-dev ] damn MM website Why is it every time I try and use that damn website I end up diving into the medicine cabinet to look for the paracetamol! Ever tried using it with a browser on a server with 256 colours (well, why the hell would you have more on your sever?) while connected to that server via terminal services or VNC over a 56K dialup net connection, with high encryption of course? This is the REAL world, system administrators have to use your site too, not just web designers with 21 inch monitors, 32 gazillion colours and multi-megabit leased line. arrrggg ok, I'll stop ranting, I just needed to open the air vent. Mark -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] damn MM website
Comparisons with mice may come into it :-P - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 10:57 AM Subject: RE: [ cf-dev ] damn MM website Slow mice? -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 10:51 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] damn MM website Some say that designers have large monitors to compensate for a lack in other areas ;0) - Original Message - From: Mark Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 06, 2003 9:56 AM Subject: [ cf-dev ] damn MM website Why is it every time I try and use that damn website I end up diving into the medicine cabinet to look for the paracetamol! Ever tried using it with a browser on a server with 256 colours (well, why the hell would you have more on your sever?) while connected to that server via terminal services or VNC over a 56K dialup net connection, with high encryption of course? This is the REAL world, system administrators have to use your site too, not just web designers with 21 inch monitors, 32 gazillion colours and multi-megabit leased line. arrrggg ok, I'll stop ranting, I just needed to open the air vent. Mark -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] encoding and funny characters
Hi, I know this has come up b4, but I'm getting funny characters coming out of strings in MX (i.e. ' comes out as weird things with accents etc) -- what's the solution for it, summit to do with the encoding...?? - Original Message - From: Douglas Humphris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 15, 2003 3:18 PM Subject: RE: [ cf-dev ] Passing ENUMs when calling a webservice Hi, OK I saved the WSDL file locally (postcodeanywhere.xml) and changed the parameters to accept a string: s:element minOccurs=1 maxOccurs=1 name=Language type=s:string / s:element minOccurs=1 maxOccurs=1 name=ContentType type=s:string / and added a URI into the definition to point it to the webservice: definitions uri=http://services.postcodeanywhere.co.uk/uk/lookup.asmx then I called the local WSDL file and it WORKS! cfinvoke webservice=http://localhost/postcodeanywhere.xml; It's not a very pretty solution and I'm not yet decided whether to use it or use the cfhttp post, but it's good to know that the reason it failed was because of the enumeration parameter types and just by manually changing them to string solves the problem. As a general point, ColdFusion still isn't up to speed on webservices which is a bit disappointing, and if you're thinking of using a webservice in a CF solution I would double check that it all works before committing to it. Douglas -Original Message- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 15 August 2003 14:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Passing ENUMs when calling a webservice Thanks Tim, I was just about to revert to using cfhttp post, but I've had a thought that I could save the WSDL locally and manually change the ENUMs to strings, then call that. I'll let you know if it works. Cheers, Douglas -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 15 August 2003 14:37 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Passing ENUMs when calling a webservice I'm having problems trying to call the PostCodeAnywhere webservice I had the exact same problem a few months ago and unfortunately never solved it. :( I spent a good couple of days searching all over the shop for info and trying all the different ways I could think of to pass the values of the correct type. I even had the PCA developers on the case and they couldn't help either. Getting the list of addresses under a postcode is fine but it's when you go to use the ByPostcode() function that it goes wrong. I ended up using a cfhttp post to get the actual XML address data. No help I know... Sorry. :o\ Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] RegEx I assume
Hi, Say I have a long string of text inside of which I have character combinations of A12 (one letter, two numerals). I want to turn any alpha-numeric combos of this nature into a link so for instance into: a href=whatever.htm?combo=A12A12/a. How'd I do that? Thanks d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] RegEx I assume
No worries Duncan ;) Tim, Simon, Duncan-- I get an error: Missing argument name. Here's the code: cfsavecontent variable=textpPrivate sources of funding for SEN pupils (See I13). 6th form funding for SEN pupils (See I02). Funds delegated by the LEA to a special school (See I01)./p/cfsavecontent cfoutput #REReplaceNoCase(text,([a-z]{1,1}[0-9]{2,2}), a href='whatever.htm?combo=\1'\1/a, ALL)# /cfoutput cheers d - Original Message - From: Duncan Fenton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:26 PM Subject: RE: [ cf-dev ] RegEx I assume OK, guys, I did clearly miss the point. Back to the drawing board I guess. Duncan -Original Message- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 15:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] RegEx I assume Damien, is this any good? Or have I missed the point? (This is my first post to this list) cfset fred = A12 !-- just an example -- cfoutputA href=http://127.0.0.1.htm?combo=#fred#;hit me/a/cfoutput Duncan Fenton Director, Alan Morris Ltd 07986 047588 -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 14:53 To: [EMAIL PROTECTED] Subject: [ cf-dev ] RegEx I assume Hi, Say I have a long string of text inside of which I have character combinations of A12 (one letter, two numerals). I want to turn any alpha-numeric combos of this nature into a link so for instance into: a href=whatever.htm?combo=A12A12/a. How'd I do that? Thanks d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] RegEx I assume
Disco... very nice, thank you all ;0) - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:46 PM Subject: RE: [ cf-dev ] RegEx I assume Put the regex in quotes ([a-z]) Coldfusion thinks it's a variable and throws an invalid variable name error I assume. Paul -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 15:42 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] RegEx I assume No worries Duncan ;) Tim, Simon, Duncan-- I get an error: Missing argument name. Here's the code: cfsavecontent variable=textpPrivate sources of funding for SEN pupils (See I13). 6th form funding for SEN pupils (See I02). Funds delegated by the LEA to a special school (See I01)./p/cfsavecontent cfoutput #REReplaceNoCase(text,([a-z]{1,1}[0-9]{2,2}), a href='whatever.htm?combo=\1'\1/a, ALL)# /cfoutput cheers d - Original Message - From: Duncan Fenton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:26 PM Subject: RE: [ cf-dev ] RegEx I assume OK, guys, I did clearly miss the point. Back to the drawing board I guess. Duncan -Original Message- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 15:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] RegEx I assume Damien, is this any good? Or have I missed the point? (This is my first post to this list) cfset fred = A12 !-- just an example -- cfoutputA href=http://127.0.0.1.htm?combo=#fred#;hit me/a/cfoutput Duncan Fenton Director, Alan Morris Ltd 07986 047588 -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 14:53 To: [EMAIL PROTECTED] Subject: [ cf-dev ] RegEx I assume Hi, Say I have a long string of text inside of which I have character combinations of A12 (one letter, two numerals). I want to turn any alpha-numeric combos of this nature into a link so for instance into: a href=whatever.htm?combo=A12A12/a. How'd I do that? Thanks d -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] RegEx I assume
well... it's just an href with URL variable so could go to any type of page you want... but in this case tis just a made up thang for the time being... - Original Message - From: Ian Westbrook [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:51 PM Subject: Re: [ cf-dev ] RegEx I assume cfoutput #REReplaceNoCase(text,([a-z]{1,1}[0-9]{2,2}), a href='whatever.htm?combo=\1'\1/a, ALL)# /cfoutput er, shouldn't that be .cfm? Ian W - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:46 PM Subject: RE: [ cf-dev ] RegEx I assume Put the regex in quotes ([a-z]) Coldfusion thinks it's a variable and throws an invalid variable name error I assume. Paul -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 15:42 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] RegEx I assume No worries Duncan ;) Tim, Simon, Duncan-- I get an error: Missing argument name. Here's the code: cfsavecontent variable=textpPrivate sources of funding for SEN pupils (See I13). 6th form funding for SEN pupils (See I02). Funds delegated by the LEA to a special school (See I01)./p/cfsavecontent cfoutput #REReplaceNoCase(text,([a-z]{1,1}[0-9]{2,2}), a href='whatever.htm?combo=\1'\1/a, ALL)# /cfoutput cheers d - Original Message - From: Duncan Fenton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:26 PM Subject: RE: [ cf-dev ] RegEx I assume OK, guys, I did clearly miss the point. Back to the drawing board I guess. Duncan -Original Message- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 15:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] RegEx I assume Damien, is this any good? Or have I missed the point? (This is my first post to this list) cfset fred = A12 !-- just an example -- cfoutputA href=http://127.0.0.1.htm?combo=#fred#;hit me/a/cfoutput Duncan Fenton Director, Alan Morris Ltd 07986 047588 -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 14:53 To: [EMAIL PROTECTED] Subject: [ cf-dev ] RegEx I assume Hi, Say I have a long string of text inside of which I have character combinations of A12 (one letter, two numerals). I want to turn any alpha-numeric combos of this nature into a link so for instance into: a href=whatever.htm?combo=A12A12/a. How'd I do that? Thanks d -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] RegEx I assume
ah just the ticket, ta Rich. I'm starting to understand these things ;0) - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 1:41 PM Subject: RE: [ cf-dev ] RegEx I assume change the {1,1) bit to read {1,2} so that it matches one instance or 2 of the [a-z] search. so it would be: ([a-z]{1,2}[0-9]{2,2}) and you'd only need to run that once - ie not have text2. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 August 2003 13:40 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] RegEx I assume One final question on this-- I need to extend the functionality to include text with AA11 (two alphas and two numerals). What I've done is: cfsavecontent variable=Text#REReplaceNoCase(Includes,([a-z]{1,1}[0-9]{2, 2}), a href='whatever.htm?combo=\1'\1/a, ALL#/cfsavecontent cfsavecontent variable=Text2#REReplaceNoCase(Text,([a-z]{2,2}[0-9]{2,2}), a href='whatever.htm?combo=\1'\1/a, ALL#/cfsavecontent This of course does not work in the second regex because the first one has taken out everything with A12 in it. So the question is, can this be done in one statement? - or what is the regex to do ([a-z]{1,1}[0-9]{2,2}) but with a space in front... Cheers d - Original Message - From: Simon Horwith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 18, 2003 3:13 PM Subject: RE: [ cf-dev ] RegEx I assume You could go a step further and REReplaceNoCase(longstring, ([a-z]{1,1}[0-9]{2,2}), a href='whatever.htm?combo=\1'\1/a, ALL) ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 18 August 2003 15:06 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] RegEx I assume I'd replace this: [A-Za-z]{1,1}[0-9]{2,2} With this: [A-Za-z][0-9]{2} But that's just me... ;) Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT: CSS and Mac ie5
I've had trouble with MAC IE5 and divs before --- this may be a dumb question but is your div inside table data? If so that may well be causing a problem but I don't imagine you've done that... d Chairman of Vice Mac IE5 fan club - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 4:36 PM Subject: [ cf-dev ] OT: CSS and Mac ie5 Hi all, sorry to be OT, but this is doing me nut in: I have a page that uses divs for positioning and validates as strict xhtml However, whenever I resize a Mac IE5 window up from a smaller size, the divs don't resize and loads of whitespace occurs. This problem doesn't occur on IE6 or Mozilla etc. Here's my div: #searchbox { left: 0px; top: 80px; width: 100%; height:30px; z-index: 1; background-color: #069; padding-left: 0px; padding-right: 0px; padding-top: 2px; padding-bottom: 2px; border-left: 0px; border-right: 0px; border-top: 2px solid; border-bottom: 2px solid; border-color: #FFF; } can anyone see what might be causing this or how to get round it (without using the Javascript onresize refresh trick)? ta. --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] SoEditor and white space
That's what I originally thought... then he told me that he was just typing stuff in and he's using a PC. Crazy world! I'll try their forum unless anyone else got any ideas? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 01, 2003 1:44 PM Subject: Re: [ cf-dev ] SoEditor and white space yeah I've seen that recently. Is he using a Mac? You could try asking on the soEditor forum, they're usually pretty good at getting back to you. I don't know what causes it or how to fix it, but with the instance I noticed, it had only done it on some words (the first sentence only if I remember correctly). I wondered if it was due to cutting and pasting from Word or similar? Or where some kind of formatting had been applied to that sentence. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] SoEditor and white space 01/09/2003 13:37 Please respond to dev Hey all, I kinda asked this question before but at the time I thought the problem was to do with Word. I've got a client who's typing stuff into soeditor pro and when he saves his work it often gets rid of the space between words. Anyone come across this before? Cheers d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT: CSS and Mac ie5
Jolly good ;0) Did you figure out how you did sort it? Always useful info that... - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:24 AM Subject: RE: [ cf-dev ] OT: CSS and Mac ie5 Divs and IE 5 for the Mac = no not so, I have it working nicely, although needed to do some specific tweaks and a separate stylesheet to get it working for mac ie5. Damian, the whole thing is DIVS - not a table in sight. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 September 2003 11:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: CSS and Mac ie5 Divs and IE 5 for the Mac = no IE5 for the mac = no Ashley Whiting -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 7:32 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT: CSS and Mac ie5 I've had trouble with MAC IE5 and divs before --- this may be a dumb question but is your div inside table data? If so that may well be causing a problem but I don't imagine you've done that... d Chairman of Vice Mac IE5 fan club - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 4:36 PM Subject: [ cf-dev ] OT: CSS and Mac ie5 Hi all, sorry to be OT, but this is doing me nut in: I have a page that uses divs for positioning and validates as strict xhtml However, whenever I resize a Mac IE5 window up from a smaller size, the divs don't resize and loads of whitespace occurs. This problem doesn't occur on IE6 or Mozilla etc. Here's my div: #searchbox { left: 0px; top: 80px; width: 100%; height:30px; z-index: 1; background-color: #069; padding-left: 0px; padding-right: 0px; padding-top: 2px; padding-bottom: 2px; border-left: 0px; border-right: 0px; border-top: 2px solid; border-bottom: 2px solid; border-color: #FFF; } can anyone see what might be causing this or how to get round it (without using the Javascript onresize refresh trick)? ta. --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET. On entering the GSI, this email was scanned for viruses by the Government Secure Intranet (GSI) virus scanning service supplied exclusively by Cable Wireless in partnership with MessageLabs. GSI users see http://www.gsi.gov.uk/main/notices/information/gsi-003-2002.pd f for further details. In case of problems, please call your organisational IT helpdesk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT: CSS and Mac ie5
No worries ;0) Just add it to the Mac IE5 X-file of weird things that happen one day and not the next. - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:47 AM Subject: RE: [ cf-dev ] OT: CSS and Mac ie5 Did you figure out how you did sort it? Always useful info that... I know, which is why I've been trying to find out how so that I could copy it to the list. Haven't found out yet and I'm up against deadlines, so a full investigation is going to have to wait I'm afraid. Soz. Rich -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 10:39 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT: CSS and Mac ie5 Jolly good ;0) Did you figure out how you did sort it? Always useful info that... - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:24 AM Subject: RE: [ cf-dev ] OT: CSS and Mac ie5 Divs and IE 5 for the Mac = no not so, I have it working nicely, although needed to do some specific tweaks and a separate stylesheet to get it working for mac ie5. Damian, the whole thing is DIVS - not a table in sight. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 September 2003 11:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: CSS and Mac ie5 Divs and IE 5 for the Mac = no IE5 for the mac = no Ashley Whiting -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 7:32 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT: CSS and Mac ie5 I've had trouble with MAC IE5 and divs before --- this may be a dumb question but is your div inside table data? If so that may well be causing a problem but I don't imagine you've done that... d Chairman of Vice Mac IE5 fan club - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 4:36 PM Subject: [ cf-dev ] OT: CSS and Mac ie5 Hi all, sorry to be OT, but this is doing me nut in: I have a page that uses divs for positioning and validates as strict xhtml However, whenever I resize a Mac IE5 window up from a smaller size, the divs don't resize and loads of whitespace occurs. This problem doesn't occur on IE6 or Mozilla etc. Here's my div: #searchbox { left: 0px; top: 80px; width: 100%; height:30px; z-index: 1; background-color: #069; padding-left: 0px; padding-right: 0px; padding-top: 2px; padding-bottom: 2px; border-left: 0px; border-right: 0px; border-top: 2px solid; border-bottom: 2px solid; border-color: #FFF; } can anyone see what might be causing this or how to get round it (without using the Javascript onresize refresh trick)? ta. --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET. On entering the GSI, this email was scanned for viruses by the Government
Re: [ cf-dev ] MVC issues
Ok everyone, for junior developers like meself, can you explain what a listener is etc? Sounds interesting but flying over my head at the moment... ;0) - Original Message - From: Simon Horwith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 05, 2003 10:17 AM Subject: RE: [ cf-dev ] MVC issues BTW - there's an article coming out in the upcominging CFDJ all about architecting Flash Apps... the author is an old-school java developer who now codes exclusively in Flash and uses MVC and listeners a lot! ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 05 September 2003 10:12 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] MVC issues So my question is, is it important to implement listeners? For web only, then I'm thinking no, but if you are creating views for Java, Web Services, Flash, then does a listener need to be implemented, and if so how? CFDJ has quite a number of articles by Hal Helms I thinkon MVC in its archives. I`m far from expert but from Flash perspective can say listeners are very important where eg a mainpanel.swf is loaded first followed by (LoadMovieNum) next menu.swf each with a menu button listening for an onPress event. Means instead of a large single .file the movie is broken down into smaller Flash movies using listeners. Good point! So if you have a web app in CF, it's important to be able to implement some form of listener, so that Flash (the main controller) can use the models and views of the MVC application. Although that listener doesn't have to be implemented in the CF application itself, only the Flash movie...? Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] MVC issues
Yup, makes sense, thanks! - Original Message - From: Paul Johnston [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 05, 2003 10:29 AM Subject: RE: [ cf-dev ] MVC issues Ok everyone, for junior developers like meself, can you explain what a listener is etc? Sounds interesting but flying over my head at the moment... :D Fair enough! It's complicated talking in terms of Java/Flash and other things when most people on this list haven't had much experience of the terminology. Ok... Listener is basically something that listens. Simple I know, but an example will make it simpler... Let's take a flash app for example. It creates a dynamic text field in the middle of the space. This text field displays the text in variable mytext. Now if mytext variable changes, the text field needs to change to, so there is a (built in) listener, that says When the data in the mytext variable changes, update the dynamic tetx field with the new data. Does that help? You can create your own listeners to do various different things, but it's basically a piece of code that is triggered when a piece of data changes. Listeners are programmed for specific parts of your program that are dynamic. Does that help? Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Editing word docs online...
Hi, I've been asked to build a site for someone that will basically operate as a shared drive for users across the internet. The client wants there to be editable word docs on the site but only editable to users with certain access priveleges, basic users will have read only rights. Any pointers as to how I might do this, anyone done anything similar? For instance I'm slightly concerned that these disparate users may have different versions of word etc... Cheers d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] ValueList
and great-two-for-the-price-of-oneValueList() - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:18 PM Subject: RE: [ cf-dev ] ValueList Even better! -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] ValueList Don't forget quotedvaluelist() -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 16:27 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] ValueList Isn't ValueList() a bloody great function? I've always known about it but never really used it. Isn't CF great :OD -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Scottish CFUG
They have a branding strap-line... never a good sign :-P - Original Message - From: Niklas Richardson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 15, 2003 3:54 PM Subject: RE: [ cf-dev ] Scottish CFUG Looks more like a marketing / sales tool! ;) Haha! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:57 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] Scottish CFUG Anyone heard anything about a Scottish CFUG? http://www.scottishcfug.com A CF developer at another company had been invited to attend, by Tidalfire, who're a scottish training company. As I hadn't heard anything about it, sounded a bit dubious, and could just be an opportunity for the company to market their training courses. Thoughts? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Simple a to z
I use this- it gives you the A-Z but only letters that need to appear: cfquery name=select_az datasource=#dsn# SELECT DISTINCT LEFT(*COLUMN*,1) AS MyAlpha FROM *TABLE* ORDER BY LEFT(*COLUMN*,1) /cfquery HTH d - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:16 AM Subject: Re: [ cf-dev ] Simple a to z here's a very simple version: cfquery name=getContent select name from table order by name /cfquery cfset currentLetter = cfset newLetter = cfoutput query=getContent cfset newLetter = Left(getContent.Name, 1) cfif CompareNoCase(newLetter, currentLetter) !--- first letter of this item is different from the one before --- pstrong#UCase(newLetter)#/strongbr cfset currentLetter = newLetter /cfif #getContent.Name#br /cfoutput would be easy to amend this to whatever you want. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- [EMAIL PROTECTED] ham.gov.uk To: [EMAIL PROTECTED] cc: 29/09/2003 10:08 Subject: [ cf-dev ] Simple a to z Please respond to dev Does anyone know of a simple a to z list system to save me writing another one? A to Z accross the top with paged results etc. Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] a-z
Paul, did that work? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 29, 2003 1:34 PM Subject: Re: [ cf-dev ] a-z should perhaps be cfquery name=select_az datasource=WebUserDSN SELECT EstablishmentName FROM School_Details WHERE LEFT(EstablishmentName,1) = '#attributes.search_string#' ORDER BY EstablishmentName /cfquery (quotes around the string) Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- [EMAIL PROTECTED] ham.gov.uk To: [EMAIL PROTECTED] cc: 29/09/2003 13:28 Subject: Re: [ cf-dev ] a-z Please respond to dev Hmmm. did that and still doesn't work. Should have looked at error message though Invalid column name 'a' - er I think thats a little wrong then . I just wanted to look in school_details and find all records starting with a Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] MOT checking if URL exists
Hey all, In a CMS for a site index I'm building there's a submit URL form... is there anyway of checking on submission if that URL exists? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] MOT checking if URL exists
doh. ta ;0) - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:15 AM Subject: Re: [ cf-dev ] MOT checking if URL exists cfhttp Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] MOT checking if URL exists 02/10/2003 11:12 Please respond to dev Hey all, In a CMS for a site index I'm building there's a submit URL form... is there anyway of checking on submission if that URL exists? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Multi-language site
I've just been doing similar... I have different tables for each language. The site administrators can edit these in the CMS -- they are set up on a permissions basis to access content in certain languages. When a user visits the site a session variable is set up called session.lang defaulted to which retrieves content from a table tableName -- then if they choose Swedish for example it is set to sv_ -- this will then retrieve content from sv_tableName through dynamic query. This is handy in this instance as there is a pile of textual content on this site. Have other people done this or are there more suitable methods as I have several languages to go yet! d - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:05 AM Subject: RE: [ cf-dev ] Multi-language site We personally use tables for this, and load them into Mem.if you need any infoplease get in touch. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 10:55 To: CF - List Subject: [ cf-dev ] Multi-language site We are thinking of making a site multilanguage. Has anyone any experience on this? I did something a long time ago and i was planning to have a text table and a language table. Then to either send all the texts into the application scope and read them from cf memory or call the db on every page? I suppose it would depend on the size of the texts etc. Anyone got any hands on experience. We are talking about a site with more than 2 million hits per month. Thanks Allan -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site
Would this be a cached query you're looping then?? Seems that this would take up a lot of memory in the initial query if you had a lot of content... How would this compare to including static htm files that had been written in the CMS (i.e. having a static file per language per page) -- anyone? - Original Message - From: Allan Cliff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:48 AM Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site CFLOOP QUERY=q_GetTexts CFSET application.T#textid#L#Languageid# = Text /CFLOOP Single loop only. - Original Message - From: Damian Watson To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 12:40 PM Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site Then Burn into application memory T1234L1 as variables in a double loop That's kinda gone over my head... what does this mean? How would do you do it? Cheers :) - Original Message - From: Allan Cliff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:36 AM Subject: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site I personally was going to have all the texts in 1 table related by textid, languageid, text, Then Burn into application memory T1234L1 as variables in a double loop and then read them from the page depending on a cookie. (if set) T1234L#Languageid# on each page. - Original Message - From: Damian Watson To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 12:26 PM Subject: [cfmail] Re: [ cf-dev ] Multi-language site I've just been doing similar... I have different tables for each language. The site administrators can edit these in the CMS -- they are set up on a permissions basis to access content in certain languages. When a user visits the site a session variable is set up called session.lang defaulted to which retrieves content from a table tableName -- then if they choose Swedish for example it is set to sv_ -- this will then retrieve content from sv_tableName through dynamic query. This is handy in this instance as there is a pile of textual content on this site. Have other people done this or are there more suitable methods as I have several languages to go yet! d - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 06, 2003 11:05 AM Subject: RE: [ cf-dev ] Multi-language site We personally use tables for this, and load them into Mem.if you need any infoplease get in touch. -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 06 October 2003 10:55 To: CF - List Subject: [ cf-dev ] Multi-language site We are thinking of making a site multilanguage. Has anyone any experience on this? I did something a long time ago and i was planning to have a text table and a language table. Then to either send all the texts into the application scope and read them from cf memory or call the db on every page? I suppose it would depend on the size of the texts etc. Anyone got any hands on experience. We are talking about a site with more than 2 million hits per month. Thanks Allan -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] General CMS question
Hey y'all I've made quite a few CMS now and got a fairly standardised template thang going. However one thing that always niggles me is the publishing of content onto the live website. I've tried two approaches to avoid immediate publishing once data is changed: 1) when a user chooses content to edit it goes over to a staged db table (i.e. myContentStaged) and then is published once they proof read; and 2) user makes changes in db and then publishes flat files of content (i.e.myContent.htm), writing them onto the live server after proof reading. I'm sure this is all very familiar but does anyone have any preferences or alternative methods?? Cheers d ...and don't let this stop you from Friday beer \~/ - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:21 PM Subject: RE: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool Me a beginner. Heheh Once upon a time Allan I used to answer the questions on list before the questions even appeared... Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource and community for ColdFusion developer. http://www.cfdeveloper.co.uk Join the CFDeveloper discussion lists. To subscribe send an e-mail to [EMAIL PROTECTED] -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 13:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool I have been on this mail for maybe a year now and I think we all have a fair idea of each others cf level and areas of expertise. As I understand it Russ is setting up CFMXHosting.co.uk and we can gather from that, that he is not a beginner to CF or SQL. So I really think this reply is an insult to his level of intellingence. In fact I have seen that Neil Robertson has had some attention drawn to his answers of late. I think that if you are not prepared to give the answer asked for then just let someone else answer. Who is this guy anyway? He must spend all damn day writing emails as he is always on cfdev, cftalk and farcry and god knows how many more lists. My two pennies worth. As it is Friday. Allan - Original Message - From: Robertson-Ravo, Neil (RX) To: '[EMAIL PROTECTED]' Sent: Friday, October 10, 2003 12:49 PM Subject: [cfmail] RE: [ cf-dev ] Database schema tool well... select name from sysobjects where type = 'U' will give you all user tables -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 11:48 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Database schema tool I know someone here, possibly Spike, wrote a tag to query the system tables and give back all user tables and column info for a specified database. Anyone got a copy to save me writing it. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer Satachi Internet Development Phone: 0870 787 3610 Tech Support: 0906 9607800 FAX: 0709 2212 636 http://www.satachi.com email general: [EMAIL PROTECTED] email support: [EMAIL PROTECTED] Join our ColdFusion Developer discussion lists. Send an e-mail to [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] General CMS question
I do use that as well...however, you want the editor to be working on data whilst on the live site everything is as normal until the editor decides they've finished editing / updating and choose to click the big don't click this button button that publishes the content. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:48 PM Subject: Re: [ cf-dev ] General CMS question you could also add a boolean or numeric field to the relevant tables, called Publish or something similar. If it's 0 don't publish it, but put it in the 'proof-read this' list. Once it's been proofed, they choose to Publish it and you set this value to 1. If you have more than 2 states, just have different values for each state and use an integer field. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] General CMS question 10/10/2003 14:35 Please respond to dev Hey y'all I've made quite a few CMS now and got a fairly standardised template thang going. However one thing that always niggles me is the publishing of content onto the live website. I've tried two approaches to avoid immediate publishing once data is changed: 1) when a user chooses content to edit it goes over to a staged db table (i.e. myContentStaged) and then is published once they proof read; and 2) user makes changes in db and then publishes flat files of content (i.e.myContent.htm), writing them onto the live server after proof reading. I'm sure this is all very familiar but does anyone have any preferences or alternative methods?? Cheers d ...and don't let this stop you from Friday beer \~/ - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:21 PM Subject: RE: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool Me a beginner. Heheh Once upon a time Allan I used to answer the questions on list before the questions even appeared... Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource and community for ColdFusion developer. http://www.cfdeveloper.co.uk Join the CFDeveloper discussion lists. To subscribe send an e-mail to [EMAIL PROTECTED] -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 13:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool I have been on this mail for maybe a year now and I think we all have a fair idea of each others cf level and areas of expertise. As I understand it Russ is setting up CFMXHosting.co.uk and we can gather from that, that he is not a beginner to CF or SQL. So I really think this reply is an insult to his level of intellingence. In fact I have seen that Neil Robertson has had some attention drawn to his answers of late. I think that if you are not prepared to give the answer asked for then just let someone else answer. Who is this guy anyway? He must spend all damn day writing emails as he is always on cfdev, cftalk and farcry and god knows how many more lists. My two pennies worth. As it is Friday. Allan - Original Message - From: Robertson-Ravo, Neil (RX) To: '[EMAIL PROTECTED]' Sent: Friday, October 10, 2003 12:49 PM Subject: [cfmail] RE: [ cf-dev ] Database schema tool well... select name from sysobjects where type = 'U' will give you all user tables -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 11:48 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Database schema tool I know someone here, possibly Spike, wrote a tag to query the system tables and give back all user tables and column info for a specified database. Anyone got a copy to save me writing it. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer Satachi Internet Development Phone: 0870 787 3610 Tech Support: 0906 9607800 FAX: 0709 2212 636 http://www.satachi.com email general: [EMAIL PROTECTED] email support: [EMAIL
Re: [ cf-dev ] General CMS question
Kinda what I'm doing (not a staged database but staged table which stores all previous states which is useful)... the boolean thang isn't necessary if you're creating static pages cos you can just edit away until you choose to publish. I was just wondering if there was anyone doing anything radically different really... - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:56 PM Subject: RE: [ cf-dev ] General CMS question The simplest way is just to store content in the same database, do not use a staged database. You simply set flags for the content as ACTIVE/Archived/APPROVAL/ Obviously content that needs approval is not live. When a moderator has checked a piece of content they simply mark it ACTIVE. If you are replacing an existing piece of content, you mark the old one as ARCHIVED so that it can be rolle dback if neccesary. The same way if u are generating static files, u just create the file when it is marked as ACTIVE, and the ARCHIVED one will still exist in the database. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer Satachi Internet Development Phone: 0870 787 3610 Tech Support: 0906 9607800 FAX: 0709 2212 636 http://www.satachi.com email general: [EMAIL PROTECTED] email support: [EMAIL PROTECTED] Join our ColdFusion Developer discussion lists. Send an e-mail to [EMAIL PROTECTED] -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 14:35 To: [EMAIL PROTECTED] Subject: [ cf-dev ] General CMS question Hey y'all I've made quite a few CMS now and got a fairly standardised template thang going. However one thing that always niggles me is the publishing of content onto the live website. I've tried two approaches to avoid immediate publishing once data is changed: 1) when a user chooses content to edit it goes over to a staged db table (i.e. myContentStaged) and then is published once they proof read; and 2) user makes changes in db and then publishes flat files of content (i.e.myContent.htm), writing them onto the live server after proof reading. I'm sure this is all very familiar but does anyone have any preferences or alternative methods?? Cheers d ...and don't let this stop you from Friday beer \~/ - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 10, 2003 2:21 PM Subject: RE: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool Me a beginner. Heheh Once upon a time Allan I used to answer the questions on list before the questions even appeared... Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource and community for ColdFusion developer. http://www.cfdeveloper.co.uk Join the CFDeveloper discussion lists. To subscribe send an e-mail to [EMAIL PROTECTED] -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 13:16 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool I have been on this mail for maybe a year now and I think we all have a fair idea of each others cf level and areas of expertise. As I understand it Russ is setting up CFMXHosting.co.uk and we can gather from that, that he is not a beginner to CF or SQL. So I really think this reply is an insult to his level of intellingence. In fact I have seen that Neil Robertson has had some attention drawn to his answers of late. I think that if you are not prepared to give the answer asked for then just let someone else answer. Who is this guy anyway? He must spend all damn day writing emails as he is always on cfdev, cftalk and farcry and god knows how many more lists. My two pennies worth. As it is Friday. Allan - Original Message - From: Robertson-Ravo, Neil (RX) To: '[EMAIL PROTECTED]' Sent: Friday, October 10, 2003 12:49 PM Subject: [cfmail] RE: [ cf-dev ] Database schema tool well... select name from sysobjects where type = 'U' will give you all user tables -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 10 October 2003 11:48 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Database schema tool I know someone here, possibly Spike, wrote a tag to query the system tables and give back all user tables and column info for a specified database. Anyone got a copy to save me writing it. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer Satachi Internet Development Phone: 0870 787 3610 Tech Support: 0906 9607800 FAX: 0709
Re: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool
I've heard you can get quite a nasty rash - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 10, 2003 3:04 PM Subject: RE: [ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Database schema tool Snake If you rub peoples rhubarb up the wrong way you have to take the flak. You shouldn't be rubbing anyones rhubard either way! -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] SQL 2K can't see CF5 Database...???????
Wild guess... do you have all permissions set for users?? Are you getting errors?? What makes you say the data is hidden? - Original Message - From: Cruz, Lisa L Ms GPRMC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 8:12 PM Subject: [ cf-dev ] SQL 2K can't see CF5 Database...??? ALCON: Urgently need some advice - I have a secure web server for telemedicine. The web server comes up, and I can see my list of users - BUT NOTHING ELSE!!! No consults, no facilities, nada! I have checked the actual database and it is all there - can anyone think why the [EMAIL PROTECTED]@$#@ the data is being hidden from viewing on the web server?? Lisa Cruz Teledermatology System Administrator Office of Clinical Operations Great Plains Regional Medical Command 2410 Stanley Rd., Suite B-17 Ft Sam Houston, Texas 78234-6230 210-295-2705 DSN: 421-2705 Fax: 210-295-2345 DSN: 421-2345 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Check insert
Richard, for info, if you want a record of the error in your cfcatch you could do all sorts of useful stuff i.e. if an error is thrown you could email details of that error to yourself, or you could insert the error into a db table for errors creating your own error log. Apologies if you know this already :) -- probably way overboard if you're just doing a simple insert HTH d - Original Message - From: Lovelock, Richard J [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 17, 2003 11:39 AM Subject: RE: [ cf-dev ] Check insert thanks for the info on CFTRY/CATCH guys - will look in to that one that's the way i am doing Duncan but wasn't sure if it was the most efficient way!?? ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 11:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Check insert query the database immediately afterwards to verify that your record is in there. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Lovelock, Richard J To: 'cflist' [EMAIL PROTECTED] richard.lovelockcc: @cgey.com Subject: [ cf-dev ] Check insert 17/10/2003 10:55 Please respond to dev guys..what's the best way to check that a DB insert from a cfm page has been successful? ___?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] SQL 2K can't see CF5 Database...???????
RE: [ cf-dev ] SQL 2K can't see CF5 Database...???Hi, It's a bit difficult to tell from the info you've given... I can only think that either it's searching a defunct datasource that has no records in or that there is an error occurring in there somewhere that has a cftry / catch around it-- in the catch it's then not throwing the user off and pretending nothing has happened. Then, hypothetically, your results page has default parameters set so doesn't worry it's not being passed the correct data... errr that was a bit of a mouthful, hope it made sense! d - Original Message - From: Cruz, Lisa L Ms GPRMC To: '[EMAIL PROTECTED]' ; '[EMAIL PROTECTED]' Sent: Friday, October 17, 2003 2:32 PM Subject: RE: [ cf-dev ] SQL 2K can't see CF5 Database...??? Yes, permissions are set. I am getting NO errors - check this out - (see word file attached). Lisa Cruz Teledermatology System Administrator Office of Clinical Operations Great Plains Regional Medical Command 2410 Stanley Rd., Suite B-17 Ft Sam Houston, Texas 78234-6230 210-295-2705 DSN: 421-2705 Fax: 210-295-2345 DSN: 421-2345 -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 5:34 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SQL 2K can't see CF5 Database...??? Wild guess... do you have all permissions set for users?? Are you getting errors?? What makes you say the data is hidden? - Original Message - From: Cruz, Lisa L Ms GPRMC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 16, 2003 8:12 PM Subject: [ cf-dev ] SQL 2K can't see CF5 Database...??? ALCON: Urgently need some advice - I have a secure web server for telemedicine. The web server comes up, and I can see my list of users - BUT NOTHING ELSE!!! No consults, no facilities, nada! I have checked the actual database and it is all there - can anyone think why the [EMAIL PROTECTED]@$#@ the data is being hidden from viewing on the web server?? Lisa Cruz Teledermatology System Administrator Office of Clinical Operations Great Plains Regional Medical Command 2410 Stanley Rd., Suite B-17 Ft Sam Houston, Texas 78234-6230 210-295-2705 DSN: 421-2705 Fax: 210-295-2345 DSN: 421-2345 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] DWMX nightmare
That kinda thing used to happen on older versions of dreamweaver, 2 and 3 I think and I never knew why. As much as DWMX has improved it still got a lot of the annoying problems it used to have. Having cakes and eating them springs to mind. - Original Message - From: Snake Hollywood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 1:41 AM Subject: [ cf-dev ] DWMX nightmare OK I had a very weird problem today. DWMX saved my file with double spacing or more everywhwere. It just inserted blank lines all over the show, extra spaces between every character etc, and the file would no longer run. I have to clean up the file in studio and get it back into a working state, and now whenever I try to open this file in DWMX it shows a load of ASCII rubbish, like an encrypted file except worse. The file loads fine into notepad and studio but not DWMX. I have even tried creating a new file and pasting the code into it, but still the same. Tried it on 2 computers running DWMX, both the same. DWMX does seem to have problems with large files as well, this is a 285k file, and DWMX is slow as a tortoise, a copy and paste takes 30 seconds, and so does swapping between design/code pane or saving a file. Again the same behaviour on multiple machines. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] DWMX nightmare
This may be really dumb but would you be happening to be working on the file through FTP which might then somehow cause what Duncan's saying? - Original Message - From: Duncan Fenton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 1:03 PM Subject: RE: [ cf-dev ] DWMX nightmare This is a real long shot, but did it inadvertently save as Unicode? If then read back as normal ASCII, that could give 'spaces' (really they would be nulls 0x00) between each character. Similarly some stupid interpretation of 0x0D0A as two newlines could give double spacing. Probably way off base, but it's worth a thought. Duncan Fenton -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 18 October 2003 01:42 To: [EMAIL PROTECTED] Subject: [ cf-dev ] DWMX nightmare OK I had a very weird problem today. DWMX saved my file with double spacing or more everywhwere. It just inserted blank lines all over the show, extra spaces between every character etc, and the file would no longer run. I have to clean up the file in studio and get it back into a working state, and now whenever I try to open this file in DWMX it shows a load of ASCII rubbish, like an encrypted file except worse. The file loads fine into notepad and studio but not DWMX. I have even tried creating a new file and pasting the code into it, but still the same. Tried it on 2 computers running DWMX, both the same. DWMX does seem to have problems with large files as well, this is a 285k file, and DWMX is slow as a tortoise, a copy and paste takes 30 seconds, and so does swapping between design/code pane or saving a file. Again the same behaviour on multiple machines. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Date/Time
or sticky back plastic... Why would you want a real time one? By the sounds of who your client is, do they really need something like that? It's almost like having a page counter! d - Original Message - From: Lucas Sherwood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 6:35 PM Subject: RE: [ cf-dev ] Date/Time Or flash :) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 16 October 2003 13:50 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Date/Time or Java -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 16 October 2003 13:57 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Date/Time javascript. -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 16 October 2003 13:49 To: 'cflist' Subject: [ cf-dev ] Date/Time what's the best way to get a real-time date/clock on a page? ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Regex
Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Yeah... but I want to know how to replace two different strings with two other different strings in one expression... You should be in church on a Sunday :) - Original Message - From: Tom Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 19, 2003 12:23 PM Subject: RE: [ cf-dev ] Regex As you don't want to do anything fancy you might just as well use use replace()... Or even replaceNoCase() Check the documentation of CF for more info... I'm at home and shouldn't ever post on a Sunday:( -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something | \2 class=somethingelse]' in the second attribute? #rereplacenocase(body, '([a|p])', '\1 class=mainBody', ALL)# - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 8:52 AM Subject: RE: [ cf-dev ] Regex rereplacenocase(mystring, ([a|p]), \1 class=whatever , ALL) should do it, haven't tested it though. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Got it now, not only is it Monday morning, I'm also at the lower end of the regex learning curve- a painful combination if there ever was one ;0) It's beginning to make sense though, I've passed the brain scramble stage... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:39 AM Subject: RE: [ cf-dev ] Regex \1 refers to a back-reference ( the stuff between the brackets in the regex) .. if you wanted 2 you'd need 2 reg-ex's ! I think .. it is Monday morning ! Regards Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something | \2 class=somethingelse]' in the second attribute? #rereplacenocase(body, '([a|p])', '\1 class=mainBody', ALL)# - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 8:52 AM Subject: RE: [ cf-dev ] Regex rereplacenocase(mystring, ([a|p]), \1 class=whatever , ALL) should do it, haven't tested it though. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Ok then, one final thang... I've now bunged the list tag in there: #rereplacenocase(body, '([a|p|li])', '\1 class=mainBody', ALL)# but the end result in the code is: L class=mainBodyI eep! Why it do dat? - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:55 AM Subject: RE: [ cf-dev ] Regex yea - it is difficult to get your head around, but once you start using them and feeling the awesome power of the Death Star, erm... regex then you'll find them immensely rewarding - especially when you can lose 9 or 10 lines of replace code. -Original Message- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Regex Ive avoided regex for so long but so much stuff here is in Perl that I couldn't avoid it any longer ! Its quite a learning curve hehe but with a bizarre sense of satisfaction at the end ! :¬) Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Got it now, not only is it Monday morning, I'm also at the lower end of the regex learning curve- a painful combination if there ever was one ;0) It's beginning to make sense though, I've passed the brain scramble stage... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:39 AM Subject: RE: [ cf-dev ] Regex \1 refers to a back-reference ( the stuff between the brackets in the regex) .. if you wanted 2 you'd need 2 reg-ex's ! I think .. it is Monday morning ! Regards Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something | \2 class=somethingelse]' in the second attribute? #rereplacenocase(body, '([a|p])', '\1 class=mainBody', ALL)# - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 8:52 AM Subject: RE: [ cf-dev ] Regex rereplacenocase(mystring, ([a|p]), \1 class=whatever , ALL) should do it, haven't tested it though. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Is that enough self-satisfaction to power a small windmill Stephen? Could be an alternative form of energy in the future all thanks to regex :) Kevin, I think Paul J on this list has a website with explications and stuff... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:51 AM Subject: RE: [ cf-dev ] Regex Ive avoided regex for so long but so much stuff here is in Perl that I couldn't avoid it any longer ! Its quite a learning curve hehe but with a bizarre sense of satisfaction at the end ! :¬) Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Got it now, not only is it Monday morning, I'm also at the lower end of the regex learning curve- a painful combination if there ever was one ;0) It's beginning to make sense though, I've passed the brain scramble stage... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:39 AM Subject: RE: [ cf-dev ] Regex \1 refers to a back-reference ( the stuff between the brackets in the regex) .. if you wanted 2 you'd need 2 reg-ex's ! I think .. it is Monday morning ! Regards Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something | \2 class=somethingelse]' in the second attribute? #rereplacenocase(body, '([a|p])', '\1 class=mainBody', ALL)# - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 8:52 AM Subject: RE: [ cf-dev ] Regex rereplacenocase(mystring, ([a|p]), \1 class=whatever , ALL) should do it, haven't tested it though. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Is there a way around that -- just tried a couple of things to no avail! - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 10:07 AM Subject: RE: [ cf-dev ] Regex this bit: [a|p|li] only matches single characters, you its finding the L and using that in the replace. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 10:02 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Ok then, one final thang... I've now bunged the list tag in there: #rereplacenocase(body, '([a|p|li])', '\1 class=mainBody', ALL)# but the end result in the code is: L class=mainBodyI eep! Why it do dat? - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:55 AM Subject: RE: [ cf-dev ] Regex yea - it is difficult to get your head around, but once you start using them and feeling the awesome power of the Death Star, erm... regex then you'll find them immensely rewarding - especially when you can lose 9 or 10 lines of replace code. -Original Message- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Regex Ive avoided regex for so long but so much stuff here is in Perl that I couldn't avoid it any longer ! Its quite a learning curve hehe but with a bizarre sense of satisfaction at the end ! :¬) Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Got it now, not only is it Monday morning, I'm also at the lower end of the regex learning curve- a painful combination if there ever was one ;0) It's beginning to make sense though, I've passed the brain scramble stage... - Original Message - From: Stephen Pope [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 9:39 AM Subject: RE: [ cf-dev ] Regex \1 refers to a back-reference ( the stuff between the brackets in the regex) .. if you wanted 2 you'd need 2 reg-ex's ! I think .. it is Monday morning ! Regards Stephen -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 09:36 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regex Works a treat Rich, thanks. Just out of interest can you do stuff like '[\1 class=something | \2 class=somethingelse]' in the second attribute? #rereplacenocase(body, '([a|p])', '\1 class=mainBody', ALL)# - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 8:52 AM Subject: RE: [ cf-dev ] Regex rereplacenocase(mystring, ([a|p]), \1 class=whatever , ALL) should do it, haven't tested it though. -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 19 October 2003 11:43 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex Hi, I want a regex that replaces p with p class=whatever and a with a class=whatever -- is it possible to do this in one or do I have to run two expressions? d -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev% 40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev
Re: [ cf-dev ] OT: Search Engine listing Companies
These guys seem pretty cool: http://www.sitescreamer.com/ -- they've got some handy tools on their site (down near bottom on blue nav bar) - Original Message - From: Giles Roadnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 20, 2003 2:28 PM Subject: [ cf-dev ] OT: Search Engine listing Companies I'm sure that you all get hundreds of spam e-mail a day from companies guaranteeing top ranking on Google. Of course it is impossible to guarantee this but I was wondering if any of these companies are any good. Anyone got any good experiences with any of them? Thanks Giles Roadnight http://giles.roadnight.name -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Performance
I would say that is potentially the optimum way of doing it -- no queries at all... If you have built the frontend of your site using well organised CSS this makes life lovely... basically when content is updated in the CMS you write an .htm (or whatever) file to the frontend which is named with the contentID... basically you get your frontend cfm pages to include the relevent file when required. Another beauty of this method is that your website administrators can make loads and loads of change on the database without it appearing on the live website until they choose to publish it (which then writes the files). Even better is that you could write XML files from your CMS and serve up content depending on the browsing application... I did post on this b4 musing about what options there are for speedy sites and decent content management... I personally think this is the best for a small / medium size site. d - Original Message - From: Matt Horn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 10:33 AM Subject: Re: [ cf-dev ] Performance storedprocs are great as the are semi precompiled but if the datapath changes on each query you wont see much performance enhancement one way to increase performance is to cffile the most visited pages down to HTML pages and serve those up instead of the CFML if no updates have occured since the last page request *not too sure how its done but I know it can be Matt - Original Message - From: Allan Cliff [EMAIL PROTECTED] To: CF - List [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 11:32 AM Subject: [ cf-dev ] Performance Anyone like to share their opinion on improving coldfusion speed either by using stored procedures or caching queries? Which one is better? Or does it depend on the query. At the moment I have a mixture of them both with dynamic queries as SP and basic queries q_GetCountries and q_GetStates as CachedWithin. Any comments? Thanks Allan -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Performance
Yup about the caching... only 100 default. I seem to rememebr a useful thing in caching is to cache a query for a long period of time and when content is updated in your cfm to run that query on the frontend so that the query basically only ever operates when you make changes... is useful in some instances anyway. - Original Message - From: Tomo Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 10:46 AM Subject: Re: [ cf-dev ] Performance I found using a mixture of SP and cached queries was the daddy, although Matt's idea certainly has promise, and is something I've had a look at myself:) I also found that there's absolutely no point in caching things that run very rarely as you wont get any gains from that. It's also not a good plan to cache admin areas. Also remember that CF admin by default will only cache a certain number of queries (100 by default) - this can be changed through cfadmin though. If you're on a shared server, you'll be sharing the cache with other sites. HTH Tom - Original Message - From: Allan Cliff [EMAIL PROTECTED] To: CF - List [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 10:32 AM Subject: [ cf-dev ] Performance Anyone like to share their opinion on improving coldfusion speed either by using stored procedures or caching queries? Which one is better? Or does it depend on the query. At the moment I have a mixture of them both with dynamic queries as SP and basic queries q_GetCountries and q_GetStates as CachedWithin. Any comments? Thanks Allan -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Any fusecoders on the list?
Hey Ellwood... I don't know too much about what fusebox does but I'd store any common includes in one includes folder, there's no point in duplicating them- defeats the object. Is that what you're asking? - Original Message - From: Ellwood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 9:13 PM Subject: [ cf-dev ] Any fusecoders on the list? Fusebox is a fantastic methodology. It makes developing sites quick and almost painless. BUT!!! Should I be careful of falling into the INCLUDE trap. Its great to have includes that you can code once and use anywhere. In fusebox this can be a problem if you have several circuits that share one of those includes. Try to avoid this is my advice. Okay, meet me half way here. If you close off a circuit that holds the included file how do the other circuits use it if you decide to remove that circuit altogether? Surely though, this means that the reason for using includes, namely to make changes in one place that ripple throughout the site, is then negated. Each circuit has a copy of the fuse which you will need to update. I suppose you could get around this by having global includes and then circuit level includes. Makes sense, but what is the correct way? What should a PURE fusecoder do? -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]