Re: [ cf-dev ] IP and Country codes
you sure you got the full list of IP ranges, and not just a US-only list? What IP addresses are you using to test against? Jenny [EMAIL PROTECTED] 25/09/2004 13:26 Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject [ cf-dev ] IP and Country codes Hi Duncan, When it looks up the ip address, unless it is registered in the US, no = country code is given. Jenny Admin and Development, chicksNchaps http://www.chicksNchaps.co.uk - Original Message -=20 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] not sure I understand; you mean it only works for US IP addresses, or = for the IP addresses in the US it only gives the country code not the = country name? Give me the IP's you're using, and what your output is.=20 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.768 / Virus Database: 515 - Release Date: 23/09/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] IP and whois
not sure I understand; you mean it only works for US IP addresses, or for the IP addresses in the US it only gives the country code not the country name? Give me the IP's you're using, and what your output is. Jenny [EMAIL PROTECTED] 24/09/2004 15:47 Please respond to dev To: [EMAIL PROTECTED] cc: Subject: Re: [ cf-dev ] IP and whois Hi Duncan, well, kinda got it running .. but it's only returning a country code for US registered IPs! rgrds, Jenny - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 23, 2004 11:47 AM Subject: Re: [ cf-dev ] IP and whois you have two options. Either save it in your website folder, or save it in the C:\Cfusion\Custom Tags\ folder. Depending probably on if you think you'll use this in more than one website? see also: http://tutorial18.easycfm.com/ Jenny [EMAIL PROTECTED] To: [EMAIL PROTECTED] place.org cc: Subject: Re: [ cf-dev ] IP and whois 22/09/2004 22:11 Please respond to dev Hi Duncan, This looks great, I'm just not sure how to install the custom tag. Can you help please? Thanks, Jenny Jenny Admin and Development, chicksNchaps http://www.chicksNchaps.co.uk - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 12:49 PM Subject: Re: [ cf-dev ] IP and whois missed out a bit, here's an example of how you could use it (included a few bogus addresses): cfset IPList = 2.6.190.57, 12.3.248.184, 24.230.192.0, 61.247.224.0, 212.124.240.0, 217.77.241.204, 217.168.0.0, 192.191.138.0, , 1.1.1.1.1, a.1.2, 1.2.3, a.b.c.1 cfloop list=#IPList# index=IPAddress cfset IP_Country = cfset IP_CountryCode = cfset IP_Error = cf_CountryIPWhois IPAddress=#IPAddress# cfoutput cfif Len(IPAddress)IPAddress: #IPAddress#br/cfif cfif Len(IP_Country)IP_Country: #IP_Country#br/cfif cfif Len(IP_CountryCode)IP_CountryCode: #IP_CountryCode#br/cfif cfif Len(IP_Error)IP_Error: #IP_Error#/cfif /cfoutput br /cfloop [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 22/09/2004 12:47 Subject: Re: [ cf-dev ] IP and whois Please respond to dev get the .csv list here, either free or not-so-free: http://www.maxmind.com/app/geoip_country store it in a table. use this code as your custom tag, call it CountryIPWhois.cfm: cfparam name=Attributes.IPAddress default= cfif NOT Len(Attributes.IPAddress) !--- Find out the user's IP address, and from this work out the country --- cfset Attributes.IPAddress = CGI.REMOTE_ADDR /cfif cfset Attributes.IPAddress = Trim(Attributes.IPAddress) cfif Len(Attributes.IPAddress) !--- we have an IP address --- !--- check it has 4 parts --- cfif ListLen(Attributes.IPAddress, .) EQ 4 !--- split it up into the 4 parts --- cfset w = ListGetAt(Attributes.IPAddress, 1, .) cfset x = ListGetAt(Attributes.IPAddress, 2, .) cfset y = ListGetAt(Attributes.IPAddress, 3, .) cfset z = ListGetAt(Attributes.IPAddress, 4, .) cfif IsNumeric(w) AND IsNumeric(x) AND IsNumeric(y) AND IsNumeric(z) !--- all parts are numeric --- cfset IPNumber = (16777216*w) + (65536*x) + (256*y) + z !--- query the database to find out what country this IP address belongs to --- cfquery name=getCountry datasource=CountryIPWhois SELECT CountryCode, Country FROM IPCountry WHERE #IPNumber# = IPNumberStart AND #IPNumber# = IPNumberEnd /cfquery cfif getCountry.RecordCount GT 0 cfset CALLER.IP_CountryCode = getCountry.CountryCode cfset CALLER.IP_Country = getCountry.Country cfelse cfset CALLER.IP_Error = Error: IP address not found in database /cfif cfelse cfset CALLER.IP_Error = Error: Part of the IP address isn't numeric /cfif cfelse cfset CALLER.IP_Error = Error: IP address must have 4 parts seperated by dots /cfif cfelse cfset CALLER.IP_Error = Error: No IP address found /cfif call it like this: cf_CountryIPWhois IPAddress=#IPAddress# Jenny [EMAIL PROTECTED]To: [EMAIL PROTECTED] place.org cc: Subject: Re: [ cf-dev ] IP and whois 22/09/2004 12:37 Please respond to dev could well be if i don't figured out the cfx ... thanks Tom. Going to try the freebie way first. Jenny Admin and Development, chicksNchaps http://www.chicksNchaps.co.uk - Original Message - From: Tom Smith To: [EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:52 AM Subject: Re: [ cf-dev ] IP and whois we use ip2location any use to you?
Re: [ cf-dev ] Finding out if a string contains particular charac ters
http://faq.cfmxdeveloper.co.uk/ Stephen Moretti To: [EMAIL PROTECTED] (cfmaster) cc: [EMAIL PROTECTED]Subject: Re: [ cf-dev ] Finding out if a string contains particular ter.co.ukcharac ters 23/09/2004 11:16 Please respond to dev Aidan Whitehall wrote: We did start sorting it out into a wiki and updating it, but like so many things we all got way too busy and it fell by the way side. Was wondering about that the other day... is it still online anywhere or did you ditch it? Ummm dunno actually - need to dig through my emails Could have sworn it was something like faq.cfmxhosting.com, but that doesn't work Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] IP and whois
you have two options. Either save it in your website folder, or save it in the C:\Cfusion\Custom Tags\ folder. Depending probably on if you think you'll use this in more than one website? see also: http://tutorial18.easycfm.com/ Jenny [EMAIL PROTECTED]To: [EMAIL PROTECTED] place.org cc: Subject: Re: [ cf-dev ] IP and whois 22/09/2004 22:11 Please respond to dev Hi Duncan, This looks great, I'm just not sure how to install the custom tag. Can you help please? Thanks, Jenny Jenny Admin and Development, chicksNchaps http://www.chicksNchaps.co.uk - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 12:49 PM Subject: Re: [ cf-dev ] IP and whois missed out a bit, here's an example of how you could use it (included a few bogus addresses): cfset IPList = 2.6.190.57, 12.3.248.184, 24.230.192.0, 61.247.224.0, 212.124.240.0, 217.77.241.204, 217.168.0.0, 192.191.138.0, , 1.1.1.1.1, a.1.2, 1.2.3, a.b.c.1 cfloop list=#IPList# index=IPAddress cfset IP_Country = cfset IP_CountryCode = cfset IP_Error = cf_CountryIPWhois IPAddress=#IPAddress# cfoutput cfif Len(IPAddress)IPAddress: #IPAddress#br/cfif cfif Len(IP_Country)IP_Country: #IP_Country#br/cfif cfif Len(IP_CountryCode)IP_CountryCode: #IP_CountryCode#br/cfif cfif Len(IP_Error)IP_Error: #IP_Error#/cfif /cfoutput br /cfloop [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 22/09/2004 12:47 Subject: Re: [ cf-dev ] IP and whois Please respond to dev get the .csv list here, either free or not-so-free: http://www.maxmind.com/app/geoip_country store it in a table. use this code as your custom tag, call it CountryIPWhois.cfm: cfparam name=Attributes.IPAddress default= cfif NOT Len(Attributes.IPAddress) !--- Find out the user's IP address, and from this work out the country --- cfset Attributes.IPAddress = CGI.REMOTE_ADDR /cfif cfset Attributes.IPAddress = Trim(Attributes.IPAddress) cfif Len(Attributes.IPAddress) !--- we have an IP address --- !--- check it has 4 parts --- cfif ListLen(Attributes.IPAddress, .) EQ 4 !--- split it up into the 4 parts --- cfset w = ListGetAt(Attributes.IPAddress, 1, .) cfset x = ListGetAt(Attributes.IPAddress, 2, .) cfset y = ListGetAt(Attributes.IPAddress, 3, .) cfset z = ListGetAt(Attributes.IPAddress, 4, .) cfif IsNumeric(w) AND IsNumeric(x) AND IsNumeric(y) AND IsNumeric(z) !--- all parts are numeric --- cfset IPNumber = (16777216*w) + (65536*x) + (256*y) + z !--- query the database to find out what country this IP address belongs to --- cfquery name=getCountry datasource=CountryIPWhois SELECT CountryCode, Country FROM IPCountry WHERE #IPNumber# = IPNumberStart AND #IPNumber# = IPNumberEnd /cfquery cfif getCountry.RecordCount GT 0 cfset CALLER.IP_CountryCode = getCountry.CountryCode cfset CALLER.IP_Country = getCountry.Country cfelse cfset CALLER.IP_Error = Error: IP address not found in database /cfif cfelse cfset CALLER.IP_Error = Error: Part of the IP address isn't numeric /cfif cfelse cfset CALLER.IP_Error = Error: IP address must have 4 parts seperated by dots /cfif cfelse cfset CALLER.IP_Error = Error: No IP address found /cfif call it like this:
[ cf-dev ] number of items in a list
cfset list=a,b,c,i cfoutput #ListLen(list)# /cfoutput = 4. i.e. it's not counting the empty elements in the list. how'd you get round that, parse through the list looking for commas? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] number of items in a list
who said anything about arrays? Paul Johnston [EMAIL PROTECTED]To: [EMAIL PROTECTED] tions.com cc: Subject: Re: [ cf-dev ] number of items in a list 23/09/2004 12:44 Please respond to dev If you want an array... use an array. Lists are useless when you should be using an array. To get round it, count the number of commas and + 1. Either that, or loop over the string and create a real array (listtoarray won't help here either)... Paul On Thu, 2004-09-23 at 12:48, [EMAIL PROTECTED] wrote: cfset list=a,b,c,i cfoutput #ListLen(list)# /cfoutput = 4. i.e. it's not counting the empty elements in the list. how'd you get round that, parse through the list looking for commas? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] IP and whois
missed out a bit, here's an example of how you could use it (included a few bogus addresses): cfset IPList = 2.6.190.57, 12.3.248.184, 24.230.192.0, 61.247.224.0, 212.124.240.0, 217.77.241.204, 217.168.0.0, 192.191.138.0, , 1.1.1.1.1, a.1.2, 1.2.3, a.b.c.1 cfloop list=#IPList# index=IPAddress cfset IP_Country = cfset IP_CountryCode = cfset IP_Error = cf_CountryIPWhois IPAddress=#IPAddress# cfoutput cfif Len(IPAddress)IPAddress: #IPAddress#br/cfif cfif Len(IP_Country)IP_Country: #IP_Country#br/cfif cfif Len(IP_CountryCode)IP_CountryCode: #IP_CountryCode#br/cfif cfif Len(IP_Error)IP_Error: #IP_Error#/cfif /cfoutput br /cfloop [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 22/09/2004 12:47 Subject: Re: [ cf-dev ] IP and whois Please respond to dev get the .csv list here, either free or not-so-free: http://www.maxmind.com/app/geoip_country store it in a table. use this code as your custom tag, call it CountryIPWhois.cfm: cfparam name=Attributes.IPAddress default= cfif NOT Len(Attributes.IPAddress) !--- Find out the user's IP address, and from this work out the country --- cfset Attributes.IPAddress = CGI.REMOTE_ADDR /cfif cfset Attributes.IPAddress = Trim(Attributes.IPAddress) cfif Len(Attributes.IPAddress) !--- we have an IP address --- !--- check it has 4 parts --- cfif ListLen(Attributes.IPAddress, .) EQ 4 !--- split it up into the 4 parts --- cfset w = ListGetAt(Attributes.IPAddress, 1, .) cfset x = ListGetAt(Attributes.IPAddress, 2, .) cfset y = ListGetAt(Attributes.IPAddress, 3, .) cfset z = ListGetAt(Attributes.IPAddress, 4, .) cfif IsNumeric(w) AND IsNumeric(x) AND IsNumeric(y) AND IsNumeric(z) !--- all parts are numeric --- cfset IPNumber = (16777216*w) + (65536*x) + (256*y) + z !--- query the database to find out what country this IP address belongs to --- cfquery name=getCountry datasource=CountryIPWhois SELECT CountryCode, Country FROM IPCountry WHERE #IPNumber# = IPNumberStart AND #IPNumber# = IPNumberEnd /cfquery cfif getCountry.RecordCount GT 0 cfset CALLER.IP_CountryCode = getCountry.CountryCode cfset CALLER.IP_Country = getCountry.Country cfelse cfset CALLER.IP_Error = Error: IP address not found in database /cfif cfelse cfset CALLER.IP_Error = Error: Part of the IP address isn't numeric /cfif cfelse cfset CALLER.IP_Error = Error: IP address must have 4 parts seperated by dots /cfif cfelse cfset CALLER.IP_Error = Error: No IP address found /cfif call it like this: cf_CountryIPWhois IPAddress=#IPAddress# Jenny [EMAIL PROTECTED]To: [EMAIL PROTECTED] place.org cc: Subject: Re: [ cf-dev ] IP and whois 22/09/2004 12:37 Please respond to dev could well be if i don't figured out the cfx ... thanks Tom. Going to try the freebie way first. Jenny Admin and Development, chicksNchaps http://www.chicksNchaps.co.uk - Original Message - From: Tom Smith To: [EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:52 AM Subject: Re: [ cf-dev ] IP and whois we use ip2location any use to you? http://www.ip2location.com/ - Original Message - From: Jenny To: [EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:40 AM Subject: [ cf-dev ] IP and whois Hi all, Anyone know of a util that will look up an ip address and update a database with country location? ie, I log the remote_addr .. the util scans the ip's in the database and updates a country field based on the lookup. Loads of whois stuff out
Re: [ cf-dev ] Finding out if a string contains particular characters
cfif FindNoCase(a, queryname.yourString) do set 1 cfelse do set 2 /cfif James Buckingham To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] [EMAIL PROTECTED]cc: a.com Subject: [ cf-dev ] Finding out if a string contains particular characters 22/09/2004 17:24 Please respond to dev Hi guys, Bit of a basic question I'm sure but I need to find a way of seeing if a string in a database record contains the characters a (i.e. the start of a link). Depending on the answer I want to run one of two sets of code. How can I do this in Cold Fusion? I'm running version 5.0 Cheers again, JamesB -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Multiple page questionnaires
1. pass the information between pages with hidden form fields. this method is probably fine, although if your form has quite a few pages and fields, you'll end up with lots of hidden fields. if you also go back to the previous page if there's an error in the form (e.g. they've left a field blank), you'll have to pass all this information back too. 2. store the form information in a table. either this could be a temporary store, which then gets deleted after form completion or periodically, or it could be the actual table the form results are meant to end up in. if your form is created dynamically, you'll need to have a table flexible enough to allow for various types of answers (text/numeric/longtext/boolean etc). probably the most potentially difficult way of doing it IMHO. 3. store the information in a structure in the session. probably the simplest way to do it. then at the end of the form, just transfer this structure to an email/database/whatever. Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] Multiple page questionnaires 10/09/2004 12:45 Please respond to dev Hi, Anyone got good pointers/ tips/ resources for creating multiple page forms i.e. a registration process with several stages... ?? What to look out for, pitfalls etc etc d -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Multiple page questionnaires
yep, that's a definite issue if an individual form is long enough. i.e. it takes longer to fill out that form and submit it than your session timeout is set at. although if you're splitting it across many pages, hopefully it wouldn't take that long to fill out any one page. unless they get fed up with it and go for their lunch break or something Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: Re: [ cf-dev ] Multiple page questionnaires 10/09/2004 18:19 Please respond to dev Thanks Duncan, that's given me some ideas ;) Going to have to be the 2nd of the three I think- it's a very long questionnaire so I guess using session structs may lose some users after timeout [EMAIL PROTECTED] wrote: 1. pass the information between pages with hidden form fields. this method is probably fine, although if your form has quite a few pages and fields, you'll end up with lots of hidden fields. if you also go back to the previous page if there's an error in the form (e.g. they've left a field blank), you'll have to pass all this information back too. 2. store the form information in a table. either this could be a temporary store, which then gets deleted after form completion or periodically, or it could be the actual table the form results are meant to end up in. if your form is created dynamically, you'll need to have a table flexible enough to allow for various types of answers (text/numeric/longtext/boolean etc). probably the most potentially difficult way of doing it IMHO. 3. store the information in a structure in the session. probably the simplest way to do it. then at the end of the form, just transfer this structure to an email/database/whatever. Damian Watson [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] Multiple page questionnaires 10/09/2004 12:45 Please respond to dev Hi, Anyone got good pointers/ tips/ resources for creating multiple page forms i.e. a registration process with several stages... ?? What to look out for, pitfalls etc etc d -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Verity Oddity
you might have to replace the special characters with a safe version when creating your collection. had this problem when trying to search for email addresses, it didn't like the @ symbol IIRC. Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] dexpo.com cc: Subject: RE: [ cf-dev ] Verity Oddity 07/09/2004 08:44 Please respond to dev Hah... it just doesn't return a) anything on a single search criteria and totally bombs out CF with error if you add more than one criteria. Basically is there anything which will stop CF searching on any special chars from a Verity collection created from a DB query (using K2) -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 07 September 2004 08:18 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Verity Oddity Robertson-Ravo, Neil (RX) wrote: Got an issue where I am searching an English collection for the word république but it seems to be hosing out big timeany ideas why? And the technical description of hosing out is -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] session time out and security
Show us the code that's in login_process.cfm. It sounds like there's something that's passing the CGI.HTTP_REFERER from index.cfm to login_process.cfm, then redirecting there before you're setting the session variables (unless I'm misunderstanding your login process). Jenny [EMAIL PROTECTED]To: [EMAIL PROTECTED] place.org cc: Subject: Re: [ cf-dev ] session time out and security 30/08/2004 18:21 Please respond to dev Hi Duncan, Files: 1. index.cfm containing login 2. login_process.cfm processed after login and sets session variables 3. *.cfm any other file on the system with security check normal process, 1, 2, 3 what's happening, 1, 3 - splatt reason for splatt: session times out or user bookmarks any other file on the system apart from index.cfm comes back and tries to login CF tries to be over helpful and after sending user to login page then returns them to 3 and bypasses 2. sooo .. i need to stop CF passing the user straight back to 3 from 1 and make sure they go through 2 first. Hope that explains it! Jenny - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 30, 2004 2:49 PM Subject: Re: [ cf-dev ] session time out and security so there's two pages: login_process.cfm and process.cfm? Can you include the session variable stuff from process.cfm into login_process.cfm? Jenny [EMAIL PROTECTED]To: [EMAIL PROTECTED] place.org cc: Subject: Re: [ cf-dev ] session time out and security 30/08/2004 14:15 Please respond to dev Hi Duncan, The login_process.cam is acted on from the login page. Trouble happens when a user book marks other pages in the site that have security set and require variables to run. They try to return directly to the page, the security sends them to login page, then when they log in the process.cfm page is skipped and none of the variables are set. Jenny - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 30, 2004 12:13 PM Subject: Re: [ cf-dev ] session time out and security so the login form has action=process.cfm, right? is there some code in process.cfm that is redirecting before the session variables are set? Jenny [EMAIL PROTECTED]To: [EMAIL PROTECTED] place.org cc: Subject: [ cf-dev ] session time out and security 30/08/2004 11:18 Please respond to dev Hi all, Got a problem with the above. Scenario is: standard login: login on front page of site refers using to a process cfm which checks for further access rights and sets up a load of needed session variables. messed up login: user bookmarks secure page, security bungs them out to the home page to login, they log in and then get directed by the default security to their bookmarked page, skipping the process cfm and it errors cos needed session variables haven't been set. I've been through the docs a few hundred times, but can't see a solution. Anyone have any ideas please? Jenny --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.744 / Virus Database: 496 - Release Date: 24/08/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* ::
Re: [ cf-dev ] SOT dynamic pages with search engines
firstly, don't build pages for the spiders that are different from what anyone else will see, as you'll inevitably be marked down for it. Could you add a Description field to your Categories table, for this descriptive text? Google won't have a problem with dynamic url's and pages (page.cfm?ID=1foo=bar). Make sure though that these pages can be reached by ways other than javascript links or submitting forms, otherwise it'll never find them. put this descriptive text near the top of the page. If there's a title, stick that in H1 or H2 to give it extra importance. Stick the description in H3 for the same reason. You can adjust the styles so it doesn't look too different. http://www.google.com/webmasters/ is a good starting point too Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] SOT dynamic pages with search engines 31/08/2004 11:27 Please respond to dev Can anyone give me a little advice please. My client has requested a few pages from me to be 'optimised?' for a search engine. The person doing this has requested that a descriptive text appear on certain pages of the site. For example shoes, boots, lingerie, costumes, makeup etc. The site uses one page for each of these categories and populates it dynamically with this information so I can't present a page as such for the search engine optimiser to see if you see what I mean. I am not up at all on how goggly type spiders work with dynamic pages. Whats the bes way of doing this ...? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] MySQL Select Numeric
Any way in MySQL to select rows where a value is or can be converted to a number? sort of like: SELECT Age FROM Ages WHERE IsNumeric(Age) My best workaround so far seems to be just do the select as normal, then loop through the list, removing rows where NOT IsNumeric(query.Age). -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] MySQL Select Numeric
cool, although i decided to go with my loop instead of the regex (might even be faster?). this way i can append the non-numeric ones to a seperate list for display on their own. ta Fiaz Khan [EMAIL PROTECTED]To: [EMAIL PROTECTED] world.comcc: Subject: RE: [ cf-dev ] MySQL Select Numeric 25/08/2004 15:20 Please respond to dev Try this SELECT Age FROM Ages WHERE (Age REGEXP ('^[0-9]+')); I havent tried it but it looks like it might work. :) Any way in MySQL to select rows where a value is or can be converted to a number? sort of like: SELECT Age FROM Ages WHERE IsNumeric(Age) My best workaround so far seems to be just do the select as normal, then loop through the list, removing rows where NOT IsNumeric(query.Age). -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] MySQL Select Numeric
I'd tried selecting WHERE Age 0 AND Age 99 But this still gave me things like '50+' Stephen Pope [EMAIL PROTECTED]To: [EMAIL PROTECTED] rv.org.uk cc: Subject: RE: [ cf-dev ] MySQL Select Numeric 25/08/2004 15:32 Please respond to dev You could try selecting where Age is greater than 0 .. That should give you a number (in theory not tried it) The RegExp one will work too (but can be a little 'expensive' if you are doing a lot of queries. e.g. SELECT * FROM Ages WHERE Age 0 0; Regards Stephen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 August 2004 14:56 To: [EMAIL PROTECTED] Subject: [ cf-dev ] MySQL Select Numeric Any way in MySQL to select rows where a value is or can be converted to a number? sort of like: SELECT Age FROM Ages WHERE IsNumeric(Age) My best workaround so far seems to be just do the select as normal, then loop through the list, removing rows where NOT IsNumeric(query.Age). -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] UKCFUG website and meeting
Links don't seem to work, take me directly back to the Links page (Firefox 0.9) ColdFusion MailingLists To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ismix.comSubject: [ cf-dev ] UKCFUG website and meeting 19/08/2004 11:11 Please respond to dev Hi everyone, Two things... (1) We have a newly designed website - would love to hear your feedback http://www.ukcfug.org/ (2) We have a really exciting meeting next week all about Blackstone, CFMX with Contribute and Breeze http://www.ukcfug.org/go/objectid/DE671A2E-E081-0302-F9071C980907E3FD Cheers Niklas -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] UKCFUG website and meeting
yep, that's it working for me now I've allowed popups. The issue isn't popups, it's 'unexpected' popups, i.e. you get redirected to some .cfm page that presumably tallies up a hit counter for the outgoing link or something, then tries launching a new window. So it looks like a page trying to launch a popup as soon as it's viewed, without any user input, which is a bad thing (think: circlejerk). If it just said a href=http://whatever.com; target=_blank it wouldn't be a problem. Andy Allan [EMAIL PROTECTED]To: [EMAIL PROTECTED] int.co.uk cc: Subject: Re: [ cf-dev ] UKCFUG website and meeting 19/08/2004 11:45 Please respond to dev Was the same for me .. I had to enable Popups for the site to get the links to work. Quoting [EMAIL PROTECTED]: Links don't seem to work, take me directly back to the Links page (Firefox 0.9) ColdFusion MailingLists To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ismix.comSubject: [ cf-dev ] UKCFUG website and meeting 19/08/2004 11:11 Please respond to dev Hi everyone, Two things... (1) We have a newly designed website - would love to hear your feedback http://www.ukcfug.org/ (2) We have a really exciting meeting next week all about Blackstone, CFMX with Contribute and Breeze http://www.ukcfug.org/go/objectid/DE671A2E-E081-0302-F9071C980907E3FD Cheers Niklas -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- [EMAIL PROTECTED] www.creative-restraint.co.uk -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: JS Bold first letter
this will capitalise the first letter of each word: input type=text style=text-transform:capitalize I expect you could also use Mark's suggestion: input type=text style=first-letter {font-weight: bold;} Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] dexpo.com cc: Subject: RE: [ cf-dev ] OT: JS Bold first letter 17/08/2004 11:58 Please respond to dev Erm, don't think so, it's in a form field (more than one on the page) -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 11:52 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: JS Bold first letter Can you use css? E.g. style p:first-letter {font-weight: bold;} /style /head body p This is a test /p -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 11:47 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] OT: JS Bold first letter Got a bit of a brain fuzz, anyone got any JS which will embolden the first letter of a string being typed into a text field? N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
RE: [ cf-dev ] OT: JS Bold first letter
the first one definitely works fine for me. never used the other one before, so don't know why it doesn't work. Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] dexpo.com cc: Subject: RE: [ cf-dev ] OT: JS Bold first letter 17/08/2004 12:06 Please respond to dev Neither seem to work? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 12:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: JS Bold first letter this will capitalise the first letter of each word: input type=text style=text-transform:capitalize I expect you could also use Mark's suggestion: input type=text style=first-letter {font-weight: bold;} Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] dexpo.com cc: Subject: RE: [ cf-dev ] OT: JS Bold first letter 17/08/2004 11:58 Please respond to dev Erm, don't think so, it's in a form field (more than one on the page) -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 11:52 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: JS Bold first letter Can you use css? E.g. style p:first-letter {font-weight: bold;} /style /head body p This is a test /p -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 11:47 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] OT: JS Bold first letter Got a bit of a brain fuzz, anyone got any JS which will embolden the first letter of a string being typed into a text field? N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is
Re: [ cf-dev ] Driving me nuts
remember and put it in speech marks: cfif isdefined(form.modifiedbannerpic) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] Driving me nuts 17/08/2004 13:56 Please respond to dev I can't understand this ive done it a million time but now forgotten something obvious. I want to see if a variable is defined. cfif isdefined(form.modifiedbannerpic) cffile action =UPLOAD filefield =Modifiedbannerpic nameconflict = overwrite accept = image/gif destination = e:/inetpub/wwwroot/store/banners cfif #file.filewassaved# eq yes cfset modifiedbanpic = '#trim(file.serverfile)#' CFQUERY NAME= update_query DATASOURCE= #application.dsn# UPDATE tblbanners SET Banner_pic = ' #trim(form.modifiedBannerPic)#' WHERE ID = #Form.BannerID# /CFQUERY cfelse PIC NOT SAVED /cfif /cfif Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] cfmx hosting
there's your endorsement Russ to use in your Sales Marketing: I think CFMX hosting is the best solution to mine the clients needs. - Paul Swingewood, CF guru. ;-) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: RE: [ cf-dev ] cfmx hosting 17/08/2004 16:27 Please respond to dev oops didn't mean to start a hosting war. I suggested CFMX hosting to my client for all the reasons that Russ has just said. #1 that I can pick up the phone and speak to someone right now who understands what I am trying to do and who will help me achieve it. Wicked! I should point out that I am not paying for the hosting the client is. For me I think CFMX hosting is the best solution to mine the clients needs. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: JS Bold first letter
seems like a lot of work for what can be covered by one line of CSS. and it doesn't do what Neil wanted. and yes, I have the Javascript Bible :-) Christopher Dawes To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: dawes.biz Subject: RE: [ cf-dev ] OT: JS Bold first letter 17/08/2004 18:07 Please respond to dev Please learn JavaScript!! All of you! Get Danny Goodman's JavaScript Bible and put it on the shelf on your desk after reading it cover to cover. Do yourselves a favour. Nearly all scripting languages (including CFSCRIPT and Action script) are based closely on JavaScript... JSB is a dictionary for JavaScript - ie you can look up what you want quickly and easily. I got so frustrated watching you try to use styles in Internet Explorer that I felt sorry for you and wrote these two scripts. If you haven't worked out by now that IE is NOT standards compliant, then you need to wake up and smell the coffee!! IE5+ is the new NS4, that is the bain of everyone's existence; an over-patched piece of poo! gets off soapbox Here's the old fashioned way... ( ie: without using Regex ) I've made it easy to read so that you can learn a little more about Javascript. The first function sets the first letter ONLY and the second function sets the first letter of each word. SCRIPT LANGUAGE=JavaScript function firstLetterCaps(string) { partOne = string.substring(0,1); partTwo = string.substring(1,string.length); return partOne.toUpperCase() + partTwo.toLowerCase(); } function firstCaps (string) { lastSpace = -2; outputString = ; for ( a=0; astring.length; a++) { thisLetter = string.substring(a,a+1); if ( thisLetter == ) { lastSpace = a; } alert(a + : + thisLetter ); if ( a==0 || a == lastSpace+1 ) { outputString += thisLetter.toUpperCase(); } else { outputString += thisLetter.toLowerCase(); } } return outputString; } /SCRIPT INPUT TYPE=text NAME=thisField VALUE=sweet onBlur=this.value = firstCaps(this.value); -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, 17 August 2004 11:26 PM To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: JS Bold first letter Yeah the caps works but it looks like its impossible to embolden the first letter in an input field... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 12:09 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: JS Bold first letter the first one definitely works fine for me. never used the other one before, so don't know why it doesn't work. Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] dexpo.com cc: Subject: RE: [ cf-dev ] OT: JS Bold first letter 17/08/2004 12:06 Please respond to dev Neither seem to work? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 12:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: JS Bold first letter this will capitalise the first letter of each word:
Re: [ cf-dev ] unique order no
cfset newID = Year(Now()) Month(Now()) Day(Now()) RandRange(1,9) should give you ID's like 20040813123456. You could also factor in the time for even more uniqueness. You might also want to query the db to ensure this ID is in fact unique. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] unique order no 16/08/2004 17:47 Please respond to dev Can anyone help with this please. I want to generate a unique order no. I was using CFSET NewID = CreateUUID() but the number it generates is way too long. I was thinking of creating something based on teh date and an incrementing number. Any ideas on how to do this? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] RegEx strip attribute
using regex, how could I turn this: font face=Times New Roman, Serif size=2 style=whatever color= #FF into this: font size=2 style=whatever color=#FF i.e. remove just the face= attribute, but leave everything else the same? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Form Submission Problem
you're looping through your query: cfoutput query=getItems so if you have 1 record returned in that query, you will have multiple forms, all with the same name and form field names. Which isn't a good idea. Make sure each form is uniquely name, perhaps: CFFORM name=hiddenValues#getItems.CurrentRow# ACTION=moditemform.cfm METHOD=POST Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] Form Submission Problem 12/08/2004 13:25 Please respond to dev I have the following code cfif getitems.recordcount gt 0 cfoutput query=getItems tr !--- bgcolor=##ffcdef --- td width=75 rowspan=4 cfswitch Expression=#form.ItemAction# cfcase value=modify CFFORM name=hiddenValues ACTION=moditemform.cfm METHOD=POST input type=hidden name=ItemAction value=modify input type=hidden name=itemID value=#getitems.itemID# a href=javascript:document.hiddenValues.submit() img name=#itemName# src=../images/products/#itemImage# width=75 height=75 style=background-color: ##CC66FF /a /cfform /cfcase cfcase value=delete CFFORM name=hiddenValues ACTION=delitemform.cfm METHOD=POST input type=hidden name=ItemAction value=delete input type=hidden name=itemID value=#getitems.itemID# a href=javascript:document.hiddenValues.submit() img name=#itemName# src=../images/products/#itemImage# width=75 height=75 style=background-color: ##CC66FF /a /cfform /cfcase /cfswitch /td td width=1 rowspan=4 img src =../images/spacer.gif width=1 align=top /td /tr tr td valign=topItem Name :/td td Valign=top #getitems.ItemName#/td /tr tr td valign=topPart Number :/td td valign=top #getitems.partnum#/td /tr tr td valign=topItem ID :/td td valign=top #getitems.itemID#/td /tr /cfoutput cfelse Sorry no items were found with that ItemID or Part Number /cfif The form is submitted ok if only one item is returned in getItems. It doesn't work when multiple items are returned. I just get the error on page (standard non helpful JS error). Can anyone see why this should be please? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow
Re: [ cf-dev ] js drives me mad
what's the javascript error? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] js drives me mad 12/08/2004 17:20 Please respond to dev Still doesn't work :( From: Andy Allan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] js drives me mad Date: Thu, 12 Aug 2004 17:17:53 +0100 should be function submitForm() ... remember Javascript is case sensitive. Andy Quoting Paul Swingewood [EMAIL PROTECTED]: Now this is as simple as it gets... Yeah right ... script language=JavaScript !-- function submitform() { if (document.addsubctgry.subcatpic.value == ) { alert(You must enter a picture for this subcategory.); } // -- /script . . . . . cfform name=addsubctgry action=adsbctac.cfm onsubmit=submitForm(); enctype=multipart/form-data . . . input type=file size=35 name=subcatpic Why doesn't this validate! - Aghhh! Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- [EMAIL PROTECTED] www.creative-restraint.co.uk -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] SOT: javascript popup
am i right in thinking there's a dropdown, you select a 'pack', which you then want the details to be displayed on the page? you probably want to have a named div in your page that you can write all this content to. function showPack(packName, packSubDir) { var packtext; packtext = '!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN' + 'HTML lang=en xml:lang=en xmlns=http://www.w3.org/1999/xhtml;' + 'HEAD' + 'TITLESlide pack: ' + packName + '/TITLE' + 'LINK href=../includes/css/ns4styles.css type=text/css rel=stylesheet' + 'LINK media=print href=styles/print.css type=text/css rel=stylesheet' + 'STYLE type=text/css media=all@import url(styles/styles.css );/STYLE' + 'SCRIPT language=JavaScript1.3 src=scripts/notices.js/SCRIPT' + 'SCRIPT language=JavaScript1.3 src=' + packSubDir + '/slides.js/SCRIPT' + 'SCRIPT language=JavaScript1.3 src=scripts/slide_show.js/SCRIPT' + '/HEAD' + 'BODY onload=initialise() onUnload=closeQuestionPopup() ' + ' vlink=#99 alink=#99 ' + ' link=#99 onkeydown=keyCapture(window.event);' + 'TABLE cellSpacing=0 cellPadding=2 width=600 border=0 align=center' + 'TBODY' + ' TRTD colspan=3 align=center' + 'IMG name=slide alt=Slide src= border=0/' + ' /TD/TR' + ' TRTD colspan=3 align=centerFONT size=-3 color=#99' + ' DIV id=Notice/DIV' + ' /FONT/TD/TR' + ' TR align=center' + 'TD align=left width=25%DIV id=goBackward/DIV/TD' + 'TD align=center width=50%FONT color=#99' + 'DIV id=slideNo/DIV/FONT/TD' + 'TD align=right width=25%DIV id=goForward/DIV/TD' + ' /TR' + ' TRTD colspan=3 align=center' + ' IMG name=logo alt=Logo border=0//TDTR' + ' TR' + ' TD align=centerDIV id=question/DIV/TD' + ' TD align=centerA href=javascript: closeThisPopup()' + ' FONT size=-2Close window/FONT/A/TD' + ' TD align=centerA href=javascript: self.print()' + ' FONT size=-2Print/FONT/A/TD' + ' TR' + '/TBODY' + '/TABLE' + '/BODY' + '/HTML'; if(document.getElementById) document.getElementById('packcontent').innerHTML = packtext; else if(document.all) document.all['packcontent'].innerHTML = packtext; } the rest of the javascript functions seem fine. add this somewhere in the body: div id=packcontent/div you probably also want to remove the bits of html you won't need, such as the doctype, head etc (these should already all be in your page). [EMAIL PROTECTED] gsi.gov.ukTo: [EMAIL PROTECTED] cc: 11/08/2004 12:01 Subject: RE: [ cf-dev ] SOT: javascript popup Please respond to dev Sorry for bringing js into the mix Just trying to debug something for someone. Can anyone tell me if there's a quick and dirty way to stop this function producing and popup window? Just want the page to be created in the current browser: Thanks! Damien - var havePopup = false; var popup; function showPack(packName, packSubDir) { if (!havePopup || popup.closed) { // Open new popup popup = window.open('', '', 'toolbar=0,status=0,width=620,height=540'); havePopup = true; } // Open popup for writing popup.document.open(text/html, replace); // Write HTML popup.document.write( '!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN' + 'HTML lang=en xml:lang=en xmlns=http://www.w3.org/1999/xhtml;' + 'HEAD' + 'TITLESlide pack: ' + packName + '/TITLE' + 'LINK href=../includes/css/ns4styles.css type=text/css rel=stylesheet' + 'LINK media=print href=styles/print.css type=text/css rel=stylesheet' + 'STYLE type=text/css media=all@import url(styles/styles.css );/STYLE' + 'SCRIPT language=JavaScript1.3 src=scripts/notices.js/SCRIPT' + 'SCRIPT language=JavaScript1.3 src=' + packSubDir + '/slides.js/SCRIPT' + 'SCRIPT language=JavaScript1.3 src=scripts/slide_show.js/SCRIPT' + '/HEAD' + 'BODY onload=initialise() onUnload=closeQuestionPopup() ' + '
Re: [ cf-dev ] SOT: javascript popup
innerHTML doesn't just work in IE, as it will work in all the gecko-engined browsers dated later than May 2000: http://www.mozilla.org/docs/dom/domref/dom_el_ref8.html judging from that little block of html, most of it isn't exactly very accessible anyway, so something like upsetting NN 4.x users probably isn't foremost in their minds! Nick de VoilTo: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: com Subject: Re: [ cf-dev ] SOT: javascript popup 11/08/2004 13:45 Please respond to dev Sadly innerHTML only works in IE, whereas this page seems designed to work in other browsers including Netscape 4 judging from the stylesheet includes. Alternatively you could implement what's currently going in the popup as a separate CFM and do the processing server-side in CF rather than client-side in JS. Nick - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 1:29 PM Subject: RE: [ cf-dev ] SOT: javascript popup am i right in thinking there's a dropdown, you select a 'pack', which you then want the details to be displayed on the page? you probably want to have a named div in your page that you can write all this content to. function showPack(packName, packSubDir) { var packtext; packtext = '!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN' + 'HTML lang=en xml:lang=en xmlns=http://www.w3.org/1999/xhtml;' + 'HEAD' + 'TITLESlide pack: ' + packName + '/TITLE' + 'LINK href=../includes/css/ns4styles.css type=text/css rel=stylesheet' + 'LINK media=print href=styles/print.css type=text/css rel=stylesheet' + 'STYLE type=text/css media=all@import url(styles/styles.css );/STYLE' + 'SCRIPT language=JavaScript1.3 src=scripts/notices.js/SCRIPT' + 'SCRIPT language=JavaScript1.3 src=' + packSubDir + '/slides.js/SCRIPT' + 'SCRIPT language=JavaScript1.3 src=scripts/slide_show.js/SCRIPT' + '/HEAD' + 'BODY onload=initialise() onUnload=closeQuestionPopup() ' + ' vlink=#99 alink=#99 ' + ' link=#99 onkeydown=keyCapture(window.event);' + 'TABLE cellSpacing=0 cellPadding=2 width=600 border=0 align=center' + 'TBODY' + ' TRTD colspan=3 align=center' + 'IMG name=slide alt=Slide src= border=0/' + ' /TD/TR' + ' TRTD colspan=3 align=centerFONT size=-3 color=#99' + ' DIV id=Notice/DIV' + ' /FONT/TD/TR' + ' TR align=center' + 'TD align=left width=25%DIV id=goBackward/DIV/TD' + 'TD align=center width=50%FONT color=#99' + 'DIV id=slideNo/DIV/FONT/TD' + 'TD align=right width=25%DIV id=goForward/DIV/TD' + ' /TR' + ' TRTD colspan=3 align=center' + ' IMG name=logo alt=Logo border=0//TDTR' + ' TR' + ' TD align=centerDIV id=question/DIV/TD' + ' TD align=centerA href=javascript: closeThisPopup()' + ' FONT size=-2Close window/FONT/A/TD' + ' TD align=centerA href=javascript: self.print()' + ' FONT size=-2Print/FONT/A/TD' + ' TR' + '/TBODY' + '/TABLE' + '/BODY' + '/HTML'; if(document.getElementById) document.getElementById('packcontent').innerHTML = packtext; else if(document.all) document.all['packcontent'].innerHTML = packtext; } the rest of the javascript functions seem fine. add this somewhere in the body: div id=packcontent/div you probably also want to remove the bits of html you won't need, such as the doctype, head etc (these should already all be in your page). [EMAIL PROTECTED]
[ cf-dev ] Find-and-Replace in SQL
How could I do this in MySQL, just using a query: Find all instances of h1 (for instance). Change them to h2. The only way I can think of is to query the database for LIKE '%h1%'; then loop through the results with Coldfusion, doing a RegEx to replace the bits you want to change, then perform another query within the loop to update each record. But is it possible to do this just using sql? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Dreamweaver FTP :(
sounds like a problem with the FTP server itself. Is your FTP session not getting kicked after a lengthy period of inactivity (i.e., overnight)? They should be able to set that up. Either that or make sure and disconnect yourself at the end of each day, so you don't have to get this guy to kick your session off. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] Dreamweaver FTP :( 05/08/2004 10:43 Please respond to dev Does anyone out there use Dreamweaver 2004? I am using v7.01 (Latest Version?) The FTP is driving me nuts. I keep getting an error Your login information is incorrect in fact its nothing to do with this at all. Its actually the number of open instances of FTP that is causing the problem. The server administrator locked down how many instances are open for each user (or so I am told). Everytime I start my machine on a new day I get this error. The administrator has to kick me off ftp and then all is ok. Does anyone know whats going on here? Is there a fix? It drives me nuts (where dd I put that old CFstudio CD?) Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Dreamweaver FTP :(
no idea. but presumably when you shutdown your PC at night, your connection should then close. but (depending on what FTP server they're using) it should be straightforward to configure the FTP server to disconnect you after say 2 hours idle. or i dunno, pull your network cable out or something. [EMAIL PROTECTED] ham.gov.uk To: [EMAIL PROTECTED] cc: 05/08/2004 10:58 Subject: Re: [ cf-dev ] Dreamweaver FTP :( Please respond to dev Apart from closing Dreamweaver there isn't anything else to close the FTP connection though is there? 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. * -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] cftransaction
Paul, my understanding is CFTransaction is used to group one block of code together. e.g. the typical use is: 1. insert row to table 2. find out maximum ID in that table (i.e. ID of the row just inserted) 3. update table with ID = the maximum you just found out. Obviously this would all be grouped as one transaction, lest someone add a new row to the table in between steps 1 and 2 above. If you're just displaying some select boxes, I'm not sure why you'd need to use it? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] cftransaction 03/08/2004 10:21 Please respond to dev I have 5 queries which populate drop down lists. I have just been reading up on cftransaction. Should I put all of these queries inside a cftransaction tag? - Does this increase speed? - How why? I don't think I need all this rollback stuff as I am only reading to populate dropdown lists. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] OT: Amazon affiliates
Anyone here have an Amazon.co.uk affiliates account? I've got one on a personal site, and used to use it to put through my own transactions, bumping up my commissions. But they seem to have cottoned on to this and are now deducting the amount from my own sales. So does anyone else want to make a few pennies on their account? Gimme a URL or your affiliate ID and I'll go buy a couple CD's... -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: Amazon affiliates[Scanned]
nice one, expect the monies in your affiliate account any time now. duncancumming-21 if you want to return the favour. Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: RE: [ cf-dev ] OT: Amazon affiliates[Scanned] 03/08/2004 13:58 Please respond to dev Yay - funjunkie-21 please. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 August 2004 13:56 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: Amazon affiliates[Scanned] Anyone here have an Amazon.co.uk affiliates account? I've got one on a personal site, and used to use it to put through my own transactions, bumping up my commissions. But they seem to have cottoned on to this and are now deducting the amount from my own sales. So does anyone else want to make a few pennies on their account? Gimme a URL or your affiliate ID and I'll go buy a couple CD's... -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] SES
you should really use example.com, an example domain that actually exists for just such a purpose. Spike [EMAIL PROTECTED]To: [EMAIL PROTECTED] org.uk cc: Subject: RE: [ cf-dev ] SES 28/07/2004 17:25 Please respond to dev Oh boy! Remedial mailing list class for Neil it is then ;) When providing example URLs in mailing lists it is common to use somesite.com or somedomain.com to indicate 'any domain of your choice' rather than a real one. Here's an example of one that works: http://farcry.daemon.com.au/go/objectid/63D0ECC9-D0B7-4CD6-F91523F690CBB8F0 Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] o.uk] On Behalf Of Robertson-Ravo, Neil (RX) Sent: Wednesday, July 28, 2004 8:09 AM To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SES Hmm this http://www.somesite.com/ took me nowhere -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 17:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SES If yo're on CFMX you can use a servlet to do the rewriting for you, so you have http://www.somesite.com/go/products/23 which is slightly friendlier and more search engine safe because it doesn't contain a file name. I wrote a servlet to do this a while back: http://www.spike.org.uk/go/fuservlet/ Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] o.uk] On Behalf Of Robertson-Ravo, Neil (RX) Sent: Wednesday, July 28, 2004 6:43 AM To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SES Cheers my man,...let's see how this works then -Original Message- From: Alex Puritche [mailto:[EMAIL PROTECTED] Sent: 28 July 2004 15:39 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SES Neil, i do. here is all you need http://www.fusium.com/index.cfm?fuseaction=view.aProductconten tObjectID=5DA 3DC7A-1C03-4367-A7B90A1EEE3EF675#sesConverter Wednesday, July 28, 2004, 4:08:34 PM, you wrote: Neil For anyone who has implemented SES fortheir apps, how Neil have they gone about it...? What scripts have they used?What Neil implementation steps did they follow? Neil Neil Ta Neil Neil Neil This e-mail is from Reed Exhibitions (Oriel House, 26 The Neil Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division Neil of Reed Business, Registered in England, Number 678540. It Neil contains information which is confidential and may also be Neil privileged. It is for the exclusive use of the intended Neil recipient(s). If you are not the intended recipient(s) please Neil note that any form of distribution, copying or use of this Neil communication or the information in it is strictly prohibited Neil and may be unlawful. If you have received this communication in Neil error please return it to the sender or call our switchboard on Neil +44 (0) 20 89107910. The opinions expressed within this Neil communication are not necessarily those expressed by Reed Neil Exhibitions. Visit our website at http://www.reedexpo.com -- Regards, Alexmailto:[EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
Re: [ cf-dev ] WYSIWYG editors - XHTML validation
nice one. I've been extending your CleanMSText custom tag a little bit, e.g. replacing the deprecated u with the equivalent in CSS, and a few extra MS Word nonsense html tags you'd missed out. Still want to do more on this, e.g. replacing all use of font tags, but that'll be more work to parse it. Chris TazewellTo: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ll.co.ukSubject: [ cf-dev ] WYSIWYG editors - XHTML validation 27/07/2004 10:14 Please respond to dev I know some people on this list have mentioned the need for XHTML valid code from WYSIWYG editors like SoEditor and Activedit... usually for government contracts etc. Obviously it's damn near impossible to find anything on the MM exchange, which in some respects is a blessing, since there's quite a lot of crap on there anyway. If you still need this, I've written a fairly basic UDF which runs through the tags and sets all the non-quoted code to lower case. This is the first version of the function, so there may be bugs etc. Feel free to use it, or hack it to pieces. But if you do make any modifications or find bugs, let me know what they are and I'll add them to the pot. Cheers Taz cfscript // *** // ValidXHTML - Written By Taz on the back of a beer mat // Parses html input from a WYSIWYG editor and validates as xhtml (lowercase tags) // Note: tag attribute values must be in double quotes // Use it as much as you like, but let me know if you find any bugs or add // functionality via the contact form on www.tazmedia.co.uk // *** function ValidXHTML(myString) { // initialise the start tag index startIndex = 1; while (startIndex LTE Len(myString)) { // get the index of the next tag opening and closing angle bracket openTag = Find(, myString, startIndex); closeTag = Find(, myString, openTag) + 1; // grab that tag myTag = Mid(myString, openTag, closeTag-openTag); // if there are upper case letters, process case converter if (REFind([A-Z], MyTag, 1)) { // initialise start sub tag index startSubIndex = 1; myLCaseTag = myTag; while (startSubIndex LT Len(myLCaseTag)) { if (Find('', myLCaseTag, startSubIndex)) { endSubindex = Find('', myLCaseTag, startSubIndex); // grab start, current part and end as individual sub strings if (startSubIndex GT 1) { tagHead = Left(myLCaseTag, startSubIndex-1); } else { tagHead = ; } mySubStr = Mid(myLCaseTag, startSubIndex, endSubIndex-startSubIndex); tagTail = Right(myLCaseTag, Len(myLCaseTag)-endSubindex + 1); // rebuild the tag with lowercase letters myLCaseTag = tagHeadLCase(mySubStr)tagTail; startSubIndex = Find('', myTag, endSubIndex+1) + 1; } else { myLCaseTag = LCase(myTag); startSubIndex = Len(myLCaseTag) + 1; } } // Now replace all instances of this tag in the string myString = Replace(myString, myTag, myLCaseTag, 'all'); } // Set start index past current tag startIndex = closeTag; } return myString; } /cfscript -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] IE and per-session cookies
I'm sure it's something to do with the app running in a virtual directory On a related note, can you explain this, or is this applicable to your problem? Got a site with roughly this structure: Root - sub-directory -- virtual directory The root and sub-directory each have application.cfm, with the same application name. The virtual directory doesn't have an application.cfm file. The sub-directory uses session logins to prevent unauthorised access. The virtual directory doesn't seem to use the application.cfm of the sub-directory (I'm guessing instead of traversing upwards through the site for the application.cfm, it's doing it through it's own folder structure which bears no relation to the website structure). So anyone can go to site/sub-directory/virtual-directory/ effectively bypassing the security placed on the sub-directory. I'm sure there's a straightforward way round this (give each virtual directory an application.cfm similar to that in the sub-directory). Mark Woods [EMAIL PROTECTED]To: [EMAIL PROTECTED] e.iecc: Subject: RE: [ cf-dev ] IE and per-session cookies 27/07/2004 15:09 Please respond to dev I don't see any problems with the response you are getting. But just in case this is of any use, below is the code I normally use to clear sessions on browser close and it seems to work fine regardless of browser. cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN ) cfset localCFID = Cookie.CFID cfset localCFTOKEN = Cookie.CFTOKEN cfcookie name=CFID value=#localCFID# cfcookie name=CFTOKEN value=#localCFTOKEN# /cfif I have tried that too, but same end result in IE. I'm sure it's something to do with the app running in a virtual directory. BTW, if you leave setClientCookies set to yes for the application and then use the code snippet above, the client will receive two cfid cookies and two cftoken cookies. This doesn't cause any problems as the latest cookie value is the one accepted by the client - I'm just explaining why I setClientCookies to no and use session.cfid and session.cftoken Mark -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] cookie problems
giles, in CFApplication, set SetDomainCookies=yes. Then when you write the cookie, it should be accessible to all sub-domains. i think. Giles Roadnight To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ght.nameSubject: RE: [ cf-dev ] cookie problems 22/07/2004 10:46 Please respond to dev So there is absolutely no way of accessing cookies from testcookie in cookie.testcookie? I take it this isn't a CF thing (actually implementation will be Flash sending requests to a PHP back end - I am just test cookie behaviour in CF. Thanks for the reply. Giles Roadnight http://giles.roadnight.name -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 10:37 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] cookie problems You can't directly access a cookie set from another domain : it's a security risk. -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 10:36 To: [EMAIL PROTECTED] Subject: [ cf-dev ] cookie problems I have set up two test domains on my local installation of apache: cookietest cookie.cookietest I want a page in cookie.cookietest to be able to read a cookie set by page in cookietest. I have tried .cookie.cookietest in the domain attribute of cfcookie but this doesn't seem to work. Any ideas? Thanks Giles Roadnight http://giles.roadnight.name -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
RE: [ cf-dev ] cookie problems
if you're using CFCookie to set your cookie, use: domain=cookietest rather than domain=test.cookietest Giles Roadnight To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ght.nameSubject: RE: [ cf-dev ] cookie problems 22/07/2004 11:09 Please respond to dev setDomainCookies Optional. Yes or No. Sets the CFID and CFTOKEN cookies for a domain, not just a single host. Applications that are running on clusters must set this value to Yes. The default is No Think that just sets where the cftoken cookies gets set - doesn't affect how other cookies are set. Must be do-able if they do it for those cookies. Will dig a little deeper. Thanks Giles Roadnight http://giles.roadnight.name -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 10:58 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] cookie problems giles, in CFApplication, set SetDomainCookies=yes. Then when you write the cookie, it should be accessible to all sub-domains. i think. Giles Roadnight To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ght.nameSubject: RE: [ cf-dev ] cookie problems 22/07/2004 10:46 Please respond to dev So there is absolutely no way of accessing cookies from testcookie in cookie.testcookie? I take it this isn't a CF thing (actually implementation will be Flash sending requests to a PHP back end - I am just test cookie behaviour in CF. Thanks for the reply. Giles Roadnight http://giles.roadnight.name -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 10:37 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] cookie problems You can't directly access a cookie set from another domain : it's a security risk. -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 10:36 To: [EMAIL PROTECTED] Subject: [ cf-dev ] cookie problems I have set up two test domains on my local installation of apache: cookietest cookie.cookietest I want a page in cookie.cookietest to be able to read a cookie set by page in cookietest. I have tried .cookie.cookietest in the domain attribute of cfcookie but this doesn't seem to work. Any ideas? Thanks Giles Roadnight http://giles.roadnight.name -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within
Re: [ cf-dev ] meaningful uuid
uh... why would you want to just get the end part of the string? The whole idea is that each UUID is totally unique, for which you'll need the whole thing. ok, if you set a few of these in succession, you'll notice the first parts all look the same, but you do really need the whole thing. if you just want to generate some other kind of random string, there are other ways of doing it. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] meaningful uuid 22/07/2004 11:27 Please respond to dev I want to create a Unique Identifier and so I am using this code CFPARAM NAME=Cookie.CartID DEFAULT=#CreateUUID()# The problem is this creates a string which is huge like .. A5C2A55B-5004-4AF5-83CB90FECA60673E Is there a way of setting what CreateUUID creates or do I need to use ListGetAt to get say just the end part of the string. WIll this have any consequences on the UUID? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] URGENT: cfmail issue - undeliverables
what does the contents of Mail62142.cfmail look like? Have you tried putting everything back into the spool apart from this one? Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 13:57 Please respond to dev Hi Duncan, Thanks for your response, I have checked the mail.log file on the coldfusion server and it says nothing apart from starting with the following line: Error,scheduler-5,07/22/04,05:38:14,,The ColdFusion mail spool encountered an invalid spool file in the spool directory. The invalid file was Mail62142.cfmail. This file was moved to the undelivered directory. There was no files with 0kb in either the undelvr/spool folder, I have also tried what you said but it still chucks them back into the undelvr folder. Even on cut and paste back into the spool it doesn't work. Starting to pull my hair out on this one!! Cheers Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 13:32 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] URGENT: cfmail issue - undeliverables check the mail.log file to see why they weren't delivered. there will be a reason for it. tell us what it is - this will shed light on it. if that doesn't clear it up, find a mail in the spool or undelvr with size=0 bytes. if there are any, stop the CF service. move all the mail out of the spool/undelvr, to some temporary folder. delete the ones with zero bytes. start the CF service. put the rest of the mail files back into the spool. Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 12:26 Please respond to dev Morning, I have a serious problem, I have just done a mailing for one of my clients and they have all come back and are now permanently stuck in the undelivr Folder and when I copy and paste they get chucked back into it. I have checked the from address, reply address, and the to address and all are fine. A portion of the emails went out but most of the didn't. This has happened before but my hosting company said it was because I did it at peak time and coldfusion server leaves cfmail till the end and processes all requests before processing mail. Its really important I get these mails out if possible so if any of you have any ideas I would be grateful. Mike -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 11:41 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] meaningful uuid Hmmm. Yes. I am using this to generate an OrderID which I then ouput as the orderNO. Being lazy I guess. I'll make a new order no based on the date time. Just would have been easier to use the last part of the UUID provided it was always different. As you say though its really unique in its wholeness Ok i'll use that for the ID and generate a seperate orderNo. Regards - Paul From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] meaningful uuid Date: Thu, 22 Jul 2004 11:36:13 +0100 uh... why would you want to just get the end part of the string? The whole idea is that each UUID is totally unique, for which you'll need the whole thing. ok, if you set a few of these in succession, you'll notice the first parts all look the same, but you do really need the whole thing. if you just want to generate some other kind of random string, there are other ways of doing it. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] meaningful uuid 22/07/2004 11:27 Please respond to
RE: [ cf-dev ] URGENT: cfmail issue - undeliverables
[EMAIL PROTECTED] - that's a catchy address! should replyto be reply-to? other than that, I can't shed much light on this, seems sort-of ok... Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 14:16 Please respond to dev MAIL62142.cfmail reads - server: mail.mailsuite.co.uk:25 from: Mailsuite [EMAIL PROTECTED] to: [EMAIL PROTECTED] replyto: IFA Events [EMAIL PROTECTED] subject: Your industry in bite sized chunks - Money Marketing Live type: multipart/alternative; boundary==_NextPart_000_188_EDRR1YSB5H6D X-Mailer: ColdFusion MX Application Server bodypart-start: text/plain; charset=UTF-8 body: ::: This is a test ::: bodypart-end: text/plain; charset=UTF-8 bodypart-start: text/html; charset=UTF-8 body: ::: This is a test :: bodypart-end: text/html; charset=UTF-8 I have tried a number of different ways of putting the files back into the spool but still no luck. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 14:05 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables what does the contents of Mail62142.cfmail look like? Have you tried putting everything back into the spool apart from this one? Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 13:57 Please respond to dev Hi Duncan, Thanks for your response, I have checked the mail.log file on the coldfusion server and it says nothing apart from starting with the following line: Error,scheduler-5,07/22/04,05:38:14,,The ColdFusion mail spool encountered an invalid spool file in the spool directory. The invalid file was Mail62142.cfmail. This file was moved to the undelivered directory. There was no files with 0kb in either the undelvr/spool folder, I have also tried what you said but it still chucks them back into the undelvr folder. Even on cut and paste back into the spool it doesn't work. Starting to pull my hair out on this one!! Cheers Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 13:32 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] URGENT: cfmail issue - undeliverables check the mail.log file to see why they weren't delivered. there will be a reason for it. tell us what it is - this will shed light on it. if that doesn't clear it up, find a mail in the spool or undelvr with size=0 bytes. if there are any, stop the CF service. move all the mail out of the spool/undelvr, to some temporary folder. delete the ones with zero bytes. start the CF service. put the rest of the mail files back into the spool. Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 12:26 Please respond to dev Morning, I have a serious problem, I have just done a mailing for one of my clients and they have all come back and are now permanently stuck in the undelivr Folder and when I copy and paste they get chucked back into it. I have checked the from address, reply address, and the to address and all are fine. A portion of the emails went out but most of the didn't. This has happened before but my hosting company said it was because I did it at peak time and coldfusion server leaves cfmail till the end and processes all requests before processing mail. Its really important I get these mails out if possible so if any of you have any ideas I would be grateful. Mike -Original Message- From: Paul Swingewood [mailto:[EMAIL
RE: [ cf-dev ] URGENT: cfmail issue - undeliverables
Start from first principles - write a new page that just does a basic cfmail without any fanciness. Add in extra bits (multipart/alternative, long from address, etc) one at a time until it is the same as these emails you can't send, or it fails to deliver, whichever happens first. Hopefully a process of elimination should help identify the problem. Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 14:41 Please respond to dev Its logging client vars and other stuff. Replyto should be ok as it worked before. Losing hair rapidly now!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 14:24 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables [EMAIL PROTECTED] - that's a catchy address! should replyto be reply-to? other than that, I can't shed much light on this, seems sort-of ok... Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 14:16 Please respond to dev MAIL62142.cfmail reads - server: mail.mailsuite.co.uk:25 from: Mailsuite [EMAIL PROTECTED] to: [EMAIL PROTECTED] replyto: IFA Events [EMAIL PROTECTED] subject: Your industry in bite sized chunks - Money Marketing Live type: multipart/alternative; boundary==_NextPart_000_188_EDRR1YSB5H6D X-Mailer: ColdFusion MX Application Server bodypart-start: text/plain; charset=UTF-8 body: ::: This is a test ::: bodypart-end: text/plain; charset=UTF-8 bodypart-start: text/html; charset=UTF-8 body: ::: This is a test :: bodypart-end: text/html; charset=UTF-8 I have tried a number of different ways of putting the files back into the spool but still no luck. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 14:05 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables what does the contents of Mail62142.cfmail look like? Have you tried putting everything back into the spool apart from this one? Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] URGENT: cfmail issue - undeliverables 22/07/2004 13:57 Please respond to dev Hi Duncan, Thanks for your response, I have checked the mail.log file on the coldfusion server and it says nothing apart from starting with the following line: Error,scheduler-5,07/22/04,05:38:14,,The ColdFusion mail spool encountered an invalid spool file in the spool directory. The invalid file was Mail62142.cfmail. This file was moved to the undelivered directory. There was no files with 0kb in either the undelvr/spool folder, I have also tried what you said but it still chucks them back into the undelvr folder. Even on cut and paste back into the spool it doesn't work. Starting to pull my hair out on this one!! Cheers Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 13:32 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] URGENT: cfmail issue - undeliverables check the mail.log file to see why they weren't delivered. there will be a reason for it. tell us what it is - this will shed light on it. if that doesn't clear it up, find a mail in the spool or undelvr with size=0 bytes. if there are any, stop the CF service. move all the mail out of the spool/undelvr, to some temporary folder. delete the ones with zero bytes. start the CF service. put the rest of the mail files back into the spool. Mike [EMAIL PROTECTED]To:
[ cf-dev ] OT: Macromedia.com survey
Chris Cantrell is asking for comments regarding the Macromedia site, at: http://www.markme.com/cantrell/archives/005577.cfm so now you can tell them how much you enjoy using the Exchange to search for custom tags... ;-) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] custom tag weirdness
got a folder with some files in it, that calls a custom tag which is meant to reside in the same directory. there is also a copy of this custom tag in the CFusion custom tags directory. Initially, I had forgot to copy the custom tag into the directory. So when I called the .cfm pages, they referenced the custom tag in the CFusion custom tags directory (following me so far?). I then uploaded the custom tag into the same directory as the .cfm pages, yet they continue to reference the one in the main custom tags directory. My understanding is that when calling a custom tag, a page looks in it's own directory, then looks upwards before eventually trying the CFusion custom tags directory. It seems to have somehow cached the decision to not look in it's own folder for the file that is now there. How do I tell CF to get the tag in it's folder, not the other one? I tried renaming the one in the CF custom tags folder, but the page just gave an error like couldn't find custom tag CF_whatever in C:\Cfusion\Custom Tags\, rather than try using the one in it's own folder. on CF 5... -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] custom tag weirdness
I'm pretty sure it's not some kind of typo, all filenames present and correct. will maybe try cfmodule, or maybe just cut-and-paste the code from the custom tag to the calling template. Stephen Moretti To: [EMAIL PROTECTED] (cfmaster) cc: [EMAIL PROTECTED]Subject: Re: [ cf-dev ] custom tag weirdness ter.co.uk 21/07/2004 16:40 Please respond to dev [EMAIL PROTECTED] wrote: How do I tell CF to get the tag in it's folder, not the other one? I tried renaming the one in the CF custom tags folder, but the page just gave an error like couldn't find custom tag CF_whatever in C:\Cfusion\Custom Tags\, rather than try using the one in it's own folder. on CF 5... It sounds like CF can't find the file in the same folder as the page currently being processed. It can't be case sensitivity, because you are on windows judging by the c:\Cfusion\... reference above, so I can only assume a typo in the file name, permissions (unlikely) or perhaps the calling page is not actually in the same folder as the tag. You can always get the template path and check that it matches what you're expecting. Have you tried using CFMODULE to load the tag? Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Free Beer!
Paul, this *may* be connected to the bug where this code wouldn't work: cfoutput query=whatever cfloop query=something else #reference to whatever.variable# /cfloop /cfoutput in the above instance, #whatever.variable# would always equal the first value from that query, not the one currently being looped. you have to set a temp variable before you enter the cfloop, and reference that instead: cfoutput query=whatever cfset somevariable = whatever.variable cfloop query=something else #somevariable# /cfloop /cfoutput This bug might have been fixed in CFMX, not sure...? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Free Beer! 19/07/2004 10:40 Please respond to dev Heres the problem. Best viewed visually at http://217.43.93.212/store/ Select Footwear, Stilettos, Choose a shoe, put this in my basket. Change the size and the new size change is reflected in the drop down list. Perfect! Now add another stiletto to the basket change size (Dispear! - Angst and stress) You will see ive added a few debugging lines to the table to show the values. I can't understand why this works first time but then not for any other item added Now for the code cfoutput query = GetCartItems cfset tblitemsItemID = GetCartItems.ItemIdPK !--- Get sizess relevant for this item --- CFQUERY NAME=Getsizes datasource= #application.dsn# SELECT tblItemSizes.FKItemID, tblSizes.Size, tblItemSizes.FKSizeID, tblSizes.SizeID FROM tblSizes INNER JOIN tblItemSizes ON tblSizes.SizeID = tblItemSizes.FKSizeID WHERE (tblItemSizes.FKItemID = #tblitemsItemId#) /cfquery trtd BGCOLOR=##cc colspan=7 Possible Sizes for this item are : cfloop query=GetSizes #GetSizes.Size#,/cfloop /td/tr !--- Get colours relevant for this item --- CFQUERY NAME=GetColours datasource= #application.dsn# SELECT tblItemColours.FKItemID, tblColours.Colour, tblItemColours.FKColourID, tblColours.ColourID FROM tblColours INNER JOIN tblItemColours ON tblColours.ColourID = tblItemColours.FKColourID WHERE (tblItemColours.FKItemID = #tblitemsItemId#) Order By ColourID ASC /cfquery trtd BGCOLOR=##cc colspan=7Get Cart Items Size(Outer loop) = #GetCartItems.ItemSize#/td/tr TR TD BGCOLOR=##cc #PartNum#/TD TD BGCOLOR=##cc #ItemName#/TD td BGCOLOR=##cc cfif GetSizes.size eq N/A cfelse select name =selectSize#Replace(ItemIDPK,-,_,ALL)#
Re: [ cf-dev ] Free Beer!
you've done it on the itemID's, but you also need to replace references to GetCartItems.ItemSize (in the cfloop) with a local variable instead. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Free Beer! 19/07/2004 10:50 Please respond to dev Yeah I did that further up the code to ensure the itemID's were being returned ok. I remembered that from something I did a while ago. Its weird though that the values must be returned properly to populate the dropdowns. I'll give it a go and see what happens Regards - Paul From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:46:04 +0100 Paul, this *may* be connected to the bug where this code wouldn't work: cfoutput query=whatever cfloop query=something else #reference to whatever.variable# /cfloop /cfoutput in the above instance, #whatever.variable# would always equal the first value from that query, not the one currently being looped. you have to set a temp variable before you enter the cfloop, and reference that instead: cfoutput query=whatever cfset somevariable = whatever.variable cfloop query=something else #somevariable# /cfloop /cfoutput This bug might have been fixed in CFMX, not sure...? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Free Beer! 19/07/2004 10:40 Please respond to dev Heres the problem. Best viewed visually at http://217.43.93.212/store/ Select Footwear, Stilettos, Choose a shoe, put this in my basket. Change the size and the new size change is reflected in the drop down list. Perfect! Now add another stiletto to the basket change size (Dispear! - Angst and stress) You will see ive added a few debugging lines to the table to show the values. I can't understand why this works first time but then not for any other item added Now for the code cfoutput query = GetCartItems cfset tblitemsItemID = GetCartItems.ItemIdPK !--- Get sizess relevant for this item --- CFQUERY NAME=Getsizes datasource= #application.dsn# SELECT tblItemSizes.FKItemID, tblSizes.Size, tblItemSizes.FKSizeID, tblSizes.SizeID FROM tblSizes INNER JOIN tblItemSizes ON tblSizes.SizeID = tblItemSizes.FKSizeID WHERE (tblItemSizes.FKItemID = #tblitemsItemId#) /cfquery trtd BGCOLOR=##cc colspan=7 Possible Sizes for this item are : cfloop query=GetSizes #GetSizes.Size#,/cfloop /td/tr !--- Get colours relevant for this item --- CFQUERY NAME=GetColours datasource= #application.dsn# SELECT tblItemColours.FKItemID, tblColours.Colour, tblItemColours.FKColourID, tblColours.ColourID FROM tblColours INNER JOIN tblItemColours ON tblColours.ColourID =
Re: [ cf-dev ] Free Beer!
thanks Paul! (will code for beer tokens) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Free Beer! 19/07/2004 11:17 Please respond to dev Duncan, Free beer for you! Send me your paypal address off list. (I don't get down your way and im serious about the free beer) That bug could drive you nuts. I played with this all Sunday as I was convinced that all was OK as everything was being outputted ok. Even in the debugger the values show up correctly. In fact it was only when I changed the actual values of the select option that it made any diference. The IF had no effect and could still use GetCartItems.ItemSize. How weird is that! cfif Getsizes.Size eq #ItemSize# !--- Makes no difference which variable is used --- option value=#ItemSize# selected#ItemSize#/option!--- Must be a local variable --- Many thanks Regards - Paul From: Paul Swingewood [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:56:43 +0100 and just as he saves the changes to his development server . It crashes and dies with a reboot Im having a bad day . :( Regards - Paul From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:53:01 +0100 you've done it on the itemID's, but you also need to replace references to GetCartItems.ItemSize (in the cfloop) with a local variable instead. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Free Beer! 19/07/2004 10:50 Please respond to dev Yeah I did that further up the code to ensure the itemID's were being returned ok. I remembered that from something I did a while ago. Its weird though that the values must be returned properly to populate the dropdowns. I'll give it a go and see what happens Regards - Paul From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Free Beer! Date: Mon, 19 Jul 2004 10:46:04 +0100 Paul, this *may* be connected to the bug where this code wouldn't work: cfoutput query=whatever cfloop query=something else #reference to whatever.variable# /cfloop /cfoutput in the above instance, #whatever.variable# would always equal the first value from that query, not the one currently being looped. you have to set a temp variable before you enter the cfloop, and reference that instead: cfoutput query=whatever cfset somevariable = whatever.variable cfloop query=something else #somevariable# /cfloop /cfoutput This bug might have been fixed in CFMX, not sure...? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Free Beer! 19/07/2004 10:40 Please respond to dev Heres the problem. Best viewed visually at http://217.43.93.212/store/ Select Footwear, Stilettos, Choose a shoe, put this in my basket. Change the size and the new size change is reflected in the drop down list. Perfect! Now add another stiletto to the basket change size (Dispear! - Angst and stress) You will see ive added a few debugging lines to the table to show the values. I can't understand why this works first time but then not for any other item added Now for the code cfoutput query = GetCartItems cfset
Re: [ cf-dev ] loop the loop loopiness
the problem is with your getcartitems.itemsitemsize. i'd guess you're basically selecting the items and the various sizes/colours they are available in, in the same query. however, this is returning multiple rows for each item, i.e. the colour red is available for each shoe, so if there are 3 shoes, the colour red will show up three times. you either need to use a bit of SELECT DISTINCT, or to use seperate queries for getting the colours and sizes (what I'd do). Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] loop the loop loopiness 16/07/2004 11:21 Please respond to dev Can anyone help me with this one please. I have the following code CFOUTPUT QUERY=GetCartItems TR TD BGCOLOR=##cc #PartNum#/TD TD BGCOLOR=##cc #ItemName#/TD td BGCOLOR=##cc cfif GetCartItems.ItemsItemSize eq N/A cfelse select name =selectSize#Replace(ItemIDPK,-,_,ALL)# cfloop index = ListElementSize list = #ValueList(GetCartItems.ItemsItemSize)# cfif #ListElementsIZE# eq GetCartItems.CartItemsItemSize !--- preselect it --- option value=#ListElementSize# selected#ListElementSize#/option cfelse option value=#ListElementSize##ListElementSize#/option /cfif /cfloop /select /cfif /td td BGCOLOR=##cc cfif GetCartItems.ItemsItemColour eq N/A cfelse select name =selectColour#Replace(ItemIDPK,-,_,ALL)# cfloop index = ListElementColour list = #ValueList(GetCartItems.ItemsItemColour)# cfif #ListElementColour# eq GetCartItems.CartItemsItemColour !--- preselect it --- option value=#ListElementColour# selected#ListElementColour#/option cfelse option value=#ListElementColour##ListElementColour#/option /cfif /cfloop /select /cfif /td td ALIGN=RIGHT bgcolor= ##cc#lscurrencyFormat(ItemCost)#/TD td bgcolor=##cc input type=Text name =Quantity#Replace(ItemIDPK,-,_,ALL)# value=#Quantity# align=RIGHT size=3 /TD TD BGCOLOR=##cc ALIGN =RIGHT #lscurrencyFormat(ItemCost * Quantity)# /TD /TR !--- Add cost of current item(s) to total cost --- CFSET TotalCost = TotalCost + (GetCartItems.ItemCost * GetCartItems.Quantity) /CFOUTPUT All seems to work ok except that when I add more and more items to the cart the select drop down lists apend whats in the list to the previous list each time. YOu can see this happening by going here http://217.43.93.212/store select footwear (stilettos platforms have pics)
Re: [ cf-dev ] loop the loop loopiness
Paul, does tblItems have a seperate row for each colour, and each size? e.g. Shoe 1, Red, size 3 Shoe 1, Red, size 4 Shoe 1, Red, size 5 Shoe 1, Black, size 3 Shoe 2, Black, size 3 Shoe 2, Black, size 3 etc etc? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] loop the loop loopiness 16/07/2004 11:47 Please respond to dev The query is simple enough really (I would have thought this was all ok ) I still don't see how the select list gets appended to? CFQUERY NAME=GetCartItems datasource=#application.dsn# SELECT DISTINCT ItemIDPK, PartNum, ItemName, ItemCost, Quantity, tblitems.itemsize AS ItemsItemSize, tblitems.itemcolour AS ItemsItemColour, tblCartItems.ItemSize AS CartItemsItemSize, tblCartItems.ItemColour AS CartItemsItemColour FROM tblItems, tblCartItems WHERE itemID = ItemIDPK AND CartIDPK = '#Cookie.CartID#' /cfquery From: Steve Powell [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Steve Powell [EMAIL PROTECTED] Subject: Re: [ cf-dev ] loop the loop loopiness Date: Fri, 16 Jul 2004 10:45:16 GMT Looks to me like you are getting a cross product effect in one of your JOINS in a query and getting duplicate rows. Look at the query as the cause of the problem. Try a DISTINCT or altering the JOIN criteria regards Steve -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] loop the loop loopiness
that explains a lot. one way you could get round this withouth changing your tables would be to use a de-duplicate function on the list. I think cflib.org should have something to do that. but ideally you want to do this properly, with linker tables for a many-to-many relationship between colours and items, and again between sizes and items: tblItems ID Name Description etc tblColours ID Colour tblSizes ID Size tblItem_Colours ID itemID ColourID tblItem_Sizes ID itemID SizeID Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] loop the loop loopiness 16/07/2004 11:54 Please respond to dev Tblitems No I cheated and did this. NAME COLOUR SIZE Shoe1 - red,white,blue - 1,2,3,4,5,6,7,8 Shoe2 - Orange,purple - 5,7,9,10,11 etc etc From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] loop the loop loopiness Date: Fri, 16 Jul 2004 11:50:48 +0100 Paul, does tblItems have a seperate row for each colour, and each size? e.g. Shoe 1, Red, size 3 Shoe 1, Red, size 4 Shoe 1, Red, size 5 Shoe 1, Black, size 3 Shoe 2, Black, size 3 Shoe 2, Black, size 3 etc etc? Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] loop the loop loopiness 16/07/2004 11:47 Please respond to dev The query is simple enough really (I would have thought this was all ok ) I still don't see how the select list gets appended to? CFQUERY NAME=GetCartItems datasource=#application.dsn# SELECT DISTINCT ItemIDPK, PartNum, ItemName, ItemCost, Quantity, tblitems.itemsize AS ItemsItemSize, tblitems.itemcolour AS ItemsItemColour, tblCartItems.ItemSize AS CartItemsItemSize, tblCartItems.ItemColour AS CartItemsItemColour FROM tblItems, tblCartItems WHERE itemID = ItemIDPK AND CartIDPK = '#Cookie.CartID#' /cfquery From: Steve Powell [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Steve Powell [EMAIL PROTECTED] Subject: Re: [ cf-dev ] loop the loop loopiness Date: Fri, 16 Jul 2004 10:45:16 GMT Looks to me like you are getting a cross product effect in one of your JOINS in a query and getting duplicate rows. Look at the query as the cause of the problem. Try a DISTINCT or altering the JOIN criteria regards Steve -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
Re: [ cf-dev ] More nuttiness
that's an easy one! WHERE (tblItemColours.FKItemID = GetCartItems.ItemId) should be WHERE (tblItemColours.FKItemID = #GetCartItems.ItemId#) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] More nuttiness 16/07/2004 16:02 Please respond to dev Since changing the tables I have now developed a few more errors to do with the queires. I get this error Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The column prefix 'GetCartItems' does not match with a table name or alias name used in the query. Heres the query cfoutput query = GetCartItems CFQUERY NAME=GetColours datasource= #application.dsn# SELECT tblItemColours.FKItemID, tblColours.Colour, tblcolours.colourID FROM tblColours INNER JOIN tblItemColours ON tblColours.ColourID = tblItemColours.Id WHERE (tblItemColours.FKItemID = GetCartItems.ItemId) /cfquery TR TD BGCOLOR=##cc #PartNum#/TD TD BGCOLOR=##cc #ItemName#/TD td BGCOLOR=##cc !--- cfif GetCartItems.ItemsItemSize eq N/A cfelse select name =selectSize#Replace(ItemIDPK,-,_,ALL)# cfloop index = ListElementSize list = #ValueList(GetCartItems.ItemsItemSize)# cfif #ListElementsIZE# eq GetCartItems.CartItemsItemSize !--- preselect it --- option value=#ListElementSize# selected#ListElementSize#/option cfelse option value=#ListElementSize##ListElementSize#/option /cfif /cfloop /select /cfif --- /td td BGCOLOR=##cc select name =selectColour#Replace(ItemIDPK,-,_,ALL)# cfloop query =GetColours cfif GetColours.ColourID eq GetCartItems.ItemColour !--- preselect it --- option value=#ListElementColour# selected#GetColour#/option cfelse option value=#GetColour.ColourID##GetColour#/option /cfif /cfloop /select /td td ALIGN=RIGHT bgcolor= ##cc#lscurrencyFormat(ItemCost)#/TD td bgcolor=##cc input type=Text name =Quantity#Replace(ItemIDPK,-,_,ALL)# value=#Quantity# align=RIGHT size=3 /TD TD BGCOLOR=##cc ALIGN =RIGHT #lscurrencyFormat(ItemCost * Quantity)# /TD /TR !--- Add cost of current item(s) to total cost --- CFSET TotalCost = TotalCost + (GetCartItems.ItemCost * GetCartItems.Quantity) cfset ListElementColour = /cfoutput I am trying to get the colours to populate the select drop down relative to the the
RE: [ cf-dev ] (not) activedit and polish chars[Scanned]
what does the N stand for? Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] 14/07/2004 11:13 Please respond to dev You'll all be overjoyed no doubt to learn that I've discovered the problem. So for those of you interested: On my insert, in the SQL syntax, rather than INSERT INTO dbTable(content) VALUES('#content#') It should be: INSERT INTO dbTable(content) VALUES(N'#content#') (Note the N) I can't find any SQL BOL info on that - can anyone find it? I presume it tells SQL Server to expect Unicode data and so not to perform any translation on the characters? This means that the collation on the column and database can remain on my default Latin (western European) and I can store whatever character set I like in there, confusingly. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 09:36 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Cheers Gene, yea that works for me too. Problem is, I'm worried about having Polish as the database default when I'm not just storing Polish content, I'm storing X number of other languages as well. Its strange we have a database containing Chinese characters using a Latin collation, both as database default AND column collation. I can't figure it out. -Original Message- From: Gene Brown [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 17:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Rich, What collation did you select when creating the database? I have just been through your process, selecting polish_CS_AS_KS_WS as the collation for the database. The queries then work with the correct characters being added and retrieved from the db. Cheers Gene -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 17:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Ok - I did the following: New database New table ('test' - columns: line_id NUMERIC IDENTITY, content NTEXT) INSERT INTO test(content) VALUES('Znajd Pastwo Zachcamy') SELECT content FROM test Results: ' Znajda Panstwo Zachecamy ' (ie, lost all the special chars.) This was all in Query Analyser. -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:44 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Have u tried, make a new database, create a new table, set the coalition and ntext, try the insert.. At least u will know if it's just that database being silly then. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Via query analyzer I can insert Chinese text into the first table, but not the second (well, it goes in, but it doesn't come out chinese) Both columns are ntext, default collation Both collations are the same for both databases. -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:27 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Can u insert the same text into both database via query analyser? Or does it only fail on the polish one. Check the coalition setting of the DATABASE properties for both databases (not just the tables) and see what the default is set to. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 July 2004 16:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] (not) activedit and polish chars[Scanned] Hmmm - more information. I have 2 databases on the *same* sql server. One has a table with an ntext column, default collation, that contains Chinese characters The other has a table with an ntext column, default collation. Ie identical. How come one can contain Chinese
Re: [ cf-dev ] OT - cheap hosting
Thanks to everyone who's replied to me offering me some good deals. I've managed to get something sorted out, case closed. cheers duncan [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 07/07/2004 16:33 Subject: [ cf-dev ] OT - cheap hosting Please respond to dev Anyone care to offer me some cheap hosting for a very small website (probably 5 pages)? Nothing much to it at all, maybe a couple of contact forms and an Access database. Any version of CF server is fine. Email me off-list with prices if you 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! -- -- -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OnChange?
form name=whatever action=somepage.cfm method=POST select name=quantity onChange=submitForm() option value=Select a quantity/option option value=11/option option value=22/option /select input type=hidden name=ID value=#Product.ID# /form function submitForm() { if (document.whatever.quantity.options[document.whatever.quantity.selectedIndex].value != ) { // they've chosen an option that's not blank document.whatever.submit(); } } somepage.cfm: cfparam name=Form.quantity default=0 cfparam name=Form.ID default=0 cfquery name=updateQuantities datasource=dsn UPDATE Product SET Quantity= #Form.quantity# WHERE ID = #Form.ID# /cfquery cflocation url=someotherpage.cfm Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] OnChange? 08/07/2004 16:28 Please respond to dev Can anyone help me with this one please. I want to have a drop down list (quantity) When the user changes the quantity I want to update the qnty field in the table orders. How do I do this? Any ideas? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OnChange?
not like this. e.g. if trying to enter 1234, that registers as 4 onChange events. You'd be better using onBlur, which is the event triggered after this field loses focus. Although to be honest, that could be annoying, especially if you're not finished editing the page. you might just have clicked into the field, then clicked elsewhere to change something else - the form would submit when you click outside of the box. better to use a button to submit it - the drop-down select is better for doing the automatic submission as it assumes you've made a change to the field. it would also work with radio buttons, but not really any other form fields. you're better off keeping the javascript to a minimum and just letting the user click a button when they're done. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] OnChange? 08/07/2004 17:04 Please respond to dev Excellent! Can the same be done for a texbox? input type=Text name=Quantity#Replace(ItemIDPK,-,_,ALL)# value=#Quantity# align=RIGHT size=3 onChange=submitForm() This would give an infinate number of possible quantities ... Regards - Paul From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OnChange? Date: Thu, 8 Jul 2004 16:44:17 +0100 form name=whatever action=somepage.cfm method=POST select name=quantity onChange=submitForm() option value=Select a quantity/option option value=11/option option value=22/option /select input type=hidden name=ID value=#Product.ID# /form function submitForm() { if (document.whatever.quantity.options[document.whatever.quantity.selectedIndex].value != ) { // they've chosen an option that's not blank document.whatever.submit(); } } somepage.cfm: cfparam name=Form.quantity default=0 cfparam name=Form.ID default=0 cfquery name=updateQuantities datasource=dsn UPDATE Product SET Quantity= #Form.quantity# WHERE ID = #Form.ID# /cfquery cflocation url=someotherpage.cfm Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] OnChange? 08/07/2004 16:28 Please respond to dev Can anyone help me with this one please. I want to have a drop down list (quantity) When the user changes the quantity I want to update the qnty field in the table orders. How do I do this? Any ideas? Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by
Re: [ cf-dev ] OnChange?
don't use cfselect. cfform select name=select_size size=4 cfloop query=getItem option value=#getItem.ItemSize# #getItem.ItemSize#/option /cfloop /select /cfform I'm assuming the top-level loop around the form is incorrect? in fact, hang on, the query has maxrows 1, so there's no point looping. let me rethink what you're trying to do: have a select from 1 to 9, with the size of this shoe pre-selected? cfset shoesizes = 1,2,3,4,5,6,7,8,9 cfform select name=select_size size=4 cfloop index=size list=#shoesizes# cfif getItem.ItemSize = size !--- preselect it --- option value=#size# selected#size#/option cfelse option value=#size##size#/option /cfif /cfloop /select /cfform Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] OnChange? 08/07/2004 17:29 Please respond to dev Oh yeah one other quick question ... I have a cell with shoes sizes like this 1,2,3,4,5,6,7,8,9 (a list) I want to populate a cfselect from the list ... So, CFQUERY NAME=GetItem MAXROWS=1 DATASOURCE=#application.dsn# SELECT DISTINCT tblitems.itemID, tblitems.partNum, tblitems.itemName, tblitems.itemDescription, tblitems.itemCost, tblitems.itemImage, tblitems.itemColour, tblitems.itemSize, tblitems.itembigimage FROM tblitems WHERE (((tblitems.itemID)=#url.itemID#)) /CFQUERY Get the item Now I guess I need some kind of loop to loop the list cfloop index = listelements list = #getItem.itemSize# delimiters = , cfform cfselect query = getItem name = select_size size = 4 value = #getItem.itemSize# display = #getItem.itemSize# /cfselect /cfform /cfloop As expected this is not right but I think you get the idea of what I am trying to do ... Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OnChange?
that should be cfif getItem.ItemSize EQ size [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 08/07/2004 17:49 Subject: Re: [ cf-dev ] OnChange? Please respond to dev don't use cfselect. cfform select name=select_size size=4 cfloop query=getItem option value=#getItem.ItemSize# #getItem.ItemSize#/option /cfloop /select /cfform I'm assuming the top-level loop around the form is incorrect? in fact, hang on, the query has maxrows 1, so there's no point looping. let me rethink what you're trying to do: have a select from 1 to 9, with the size of this shoe pre-selected? cfset shoesizes = 1,2,3,4,5,6,7,8,9 cfform select name=select_size size=4 cfloop index=size list=#shoesizes# cfif getItem.ItemSize = size !--- preselect it --- option value=#size# selected#size#/option cfelse option value=#size##size#/option /cfif /cfloop /select /cfform Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] OnChange? 08/07/2004 17:29 Please respond to dev Oh yeah one other quick question ... I have a cell with shoes sizes like this 1,2,3,4,5,6,7,8,9 (a list) I want to populate a cfselect from the list ... So, CFQUERY NAME=GetItem MAXROWS=1 DATASOURCE=#application.dsn# SELECT DISTINCT tblitems.itemID, tblitems.partNum, tblitems.itemName, tblitems.itemDescription, tblitems.itemCost, tblitems.itemImage, tblitems.itemColour, tblitems.itemSize, tblitems.itembigimage FROM tblitems WHERE (((tblitems.itemID)=#url.itemID#)) /CFQUERY Get the item Now I guess I need some kind of loop to loop the list cfloop index = listelements list = #getItem.itemSize# delimiters = , cfform cfselect query = getItem name = select_size size = 4 value = #getItem.itemSize# display = #getItem.itemSize# /cfselect /cfform /cfloop As expected this is not right but I think you get the idea of what I am trying to do ... Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Whats wrong please?
how about this: select name=selectSize cfloop index = ListElement list = #ValueList(GetCartItems.ItemsItemSize)# cfif #ListElement# eq GetCartItems.CartItemsItemSize !--- preselect it --- option value=#ListElement# selected#ListElement#/option cfelse option value=#ListElement##ListElement#/option /cfif /cfloop /select Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Whats wrong please? 08/07/2004 19:38 Please respond to dev Duncan I have changed the query to this CFQUERY NAME=GetCartItems datasource=#application.dsn# SELECT ItemIDPK, PartNum, ItemName, ItemCost, Quantity, tblitems.itemsize AS ItemsItemSize, tblCartItems.ItemSize AS CartItemsItemSize FROM tblItems, tblCartItems WHERE itemID = ItemIDPK AND CartIDPK = '#Cookie.CartID#' /cfquery To prevent confusion as to what is being selected And the loop now looks like this select name=selectSize cfloop index = ListElement list = #GetCartItems.ItemsItemSize# delimiters=, cfif #ListElement# eq GetCartItems.ItemsItemSize !--- preselect it --- option value=#GetCartItems.CartItemsItemSize# selected#GetCartItems.CartItemsItemSize#/option cfelse option value=#ListElement##ListElement#/option /cfif /cfloop /select As I understand it the select is populated withthe list data from itemsItemSize. (which seems to work ok) Inside the loop I check to see if the value of the list from itemsItemSize is equal to that which is held in the cart (cartitemsitemsize) if it is then make this value selected. It doesn't work still :( Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Whats wrong please?
cfquery name=getCountries select country from countries /cfquery #getCountries.country# = Australia (first record from the query) #ValueList(getCountries.country)# = Australia, Brazil, Canada, Denmark... (all the records from the query) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Whats wrong please? 08/07/2004 20:01 Please respond to dev HO HO HO! Its Christmas! MAGIC - ! It works a treat now - I'm still not sure why it didn't work before but I see you used valuelist() which I presume makes the data in the list more sensible. I can only assume that the EQ wasn't being triggered as the items didn't match as I expected... Many thanks for this Duncan once again you've saved the day and whats left of my sanity. All I have to do know is replicate this for the colour and Roberts your mothers brother ... Regards - Paul From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Whats wrong please? Date: Thu, 8 Jul 2004 19:53:09 +0100 how about this: select name=selectSize cfloop index = ListElement list = #ValueList(GetCartItems.ItemsItemSize)# cfif #ListElement# eq GetCartItems.CartItemsItemSize !--- preselect it --- option value=#ListElement# selected#ListElement#/option cfelse option value=#ListElement##ListElement#/option /cfif /cfloop /select Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: Re: [ cf-dev ] Whats wrong please? 08/07/2004 19:38 Please respond to dev Duncan I have changed the query to this CFQUERY NAME=GetCartItems datasource=#application.dsn# SELECT ItemIDPK, PartNum, ItemName, ItemCost, Quantity, tblitems.itemsize AS ItemsItemSize, tblCartItems.ItemSize AS CartItemsItemSize FROM tblItems, tblCartItems WHERE itemID = ItemIDPK AND CartIDPK = '#Cookie.CartID#' /cfquery To prevent confusion as to what is being selected And the loop now looks like this select name=selectSize cfloop index = ListElement list = #GetCartItems.ItemsItemSize# delimiters=, cfif #ListElement# eq GetCartItems.ItemsItemSize !--- preselect it --- option value=#GetCartItems.CartItemsItemSize# selected#GetCartItems.CartItemsItemSize#/option cfelse option value=#ListElement##ListElement#/option /cfif /cfloop /select As I understand it the select is populated withthe list data from itemsItemSize. (which seems to work ok) Inside the loop I check to see if the value of the list from itemsItemSize is equal to that which is held in the cart (cartitemsitemsize) if it is then make this value selected. It doesn't work still :( Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and
Re: [ cf-dev ] SQL
use: like 'c%' Matt Horn [EMAIL PROTECTED]To: [EMAIL PROTECTED] rn.org cc: Subject: [ cf-dev ] SQL 07/07/2004 14:28 Please respond to dev Hello again any reason why Access returns one record for this query Select ProductionHouseName, ProductionHouseID from tblproductionHouse where productionhousename like 'c*' but query.recordcount in CF returns 0 ? Matt |\/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\/| -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] OT - cheap hosting
Anyone care to offer me some cheap hosting for a very small website (probably 5 pages)? Nothing much to it at all, maybe a couple of contact forms and an Access database. Any version of CF server is fine. Email me off-list with prices if you 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! -- -- -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Verity madness
Here's a strange one. Got a website on CF 5. Uses Verity for a search, all works fine. Apart from it doesn't seem to have some recent data in the index. Re-indexing doesn't make any difference. In the CF Administrator, if I Purge the collection, the search still works (i.e. returns results) - isn't the Purge meant to remove all the data from the collection? I then deleted the collection, re-created and re-indexed - still not returning certain results that it should be. My indexing looks roughly like: cfquery name=getPages datasource=dsn SELECT* FROM Content /cfquery cfdump var=#getPages# cflock name=CollectionName timeout=100 type=Exclusive cfindex collection=CollectionName action=Refresh type=Custom Key=theID Title=page_title Body=page_title, menu_title, Content Query =getPages Custom1=Pages /cflock So from the CFDump, I can see what data should be getting indexed. I see there are 26 items. When I then do a CFSearch on * I get only 23 results, and looking in the actual contents of the collection, I can see it's not indexed certain words in at least one of the three missing items. I'm probably being stupid here - any ideas? It's as if there are two versions, or perhaps it's failing on the 24th item for some reason. Normally don't have much problems with Verity stuff, it's just a pain in the arse when it goes wrong. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Verity madness
So far, it looks like the 23rd item could be the culprit - the text in the Body is relatively long and full of HTML (although it seems to be indexed ok itself); could this have an affect on the collection not wanting to index anything else? [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 07/07/2004 16:46 Subject: [ cf-dev ] Verity madness Please respond to dev Here's a strange one. Got a website on CF 5. Uses Verity for a search, all works fine. Apart from it doesn't seem to have some recent data in the index. Re-indexing doesn't make any difference. In the CF Administrator, if I Purge the collection, the search still works (i.e. returns results) - isn't the Purge meant to remove all the data from the collection? I then deleted the collection, re-created and re-indexed - still not returning certain results that it should be. My indexing looks roughly like: cfquery name=getPages datasource=dsn SELECT* FROM Content /cfquery cfdump var=#getPages# cflock name=CollectionName timeout=100 type=Exclusive cfindex collection=CollectionName action=Refresh type=Custom Key=theID Title=page_title Body=page_title, menu_title, Content Query =getPages Custom1=Pages /cflock So from the CFDump, I can see what data should be getting indexed. I see there are 26 items. When I then do a CFSearch on * I get only 23 results, and looking in the actual contents of the collection, I can see it's not indexed certain words in at least one of the three missing items. I'm probably being stupid here - any ideas? It's as if there are two versions, or perhaps it's failing on the 24th item for some reason. Normally don't have much problems with Verity stuff, it's just a pain in the arse when it goes wrong. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Verity madness
I think I figured out the problem - seemed there was a flaw in my logic, I was using duplicate values for the Key field which arses up Verity. Was joining 2 tables - Pages and Content (many-to-many), and using the PageID as the basis for the Key, which of course wasn't unique. Snake Hollywood To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: kepit.net Subject: RE: [ cf-dev ] Verity madness 07/07/2004 18:29 Please respond to dev You do know that certain words do not get indexed? I do not have a list for you, you will need to go find that, but it's all the common stuff like THE, THIS, THAT and some other more obscure things. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 July 2004 17:21 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Verity madness So far, it looks like the 23rd item could be the culprit - the text in the Body is relatively long and full of HTML (although it seems to be indexed ok itself); could this have an affect on the collection not wanting to index anything else? [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 07/07/2004 16:46 Subject: [ cf-dev ] Verity madness Please respond to dev Here's a strange one. Got a website on CF 5. Uses Verity for a search, all works fine. Apart from it doesn't seem to have some recent data in the index. Re-indexing doesn't make any difference. In the CF Administrator, if I Purge the collection, the search still works (i.e. returns results) - isn't the Purge meant to remove all the data from the collection? I then deleted the collection, re-created and re-indexed - still not returning certain results that it should be. My indexing looks roughly like: cfquery name=getPages datasource=dsn SELECT* FROM Content /cfquery cfdump var=#getPages# cflock name=CollectionName timeout=100 type=Exclusive cfindex collection=CollectionName action=Refresh type=Custom Key=theID Title=page_title Body=page_title, menu_title, Content Query =getPages Custom1=Pages /cflock So from the CFDump, I can see what data should be getting indexed. I see there are 26 items. When I then do a CFSearch on * I get only 23 results, and looking in the actual contents of the collection, I can see it's not indexed certain words in at least one of the three missing items. I'm probably being stupid here - any ideas? It's as if there are two versions, or perhaps it's failing on the 24th item for some reason. Normally don't have much problems with Verity stuff, it's just a pain in the arse when it goes wrong. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are
Re: [ cf-dev ] Belated Monday stupidness
what does cfdump var=#Form# give you? Matt Horn [EMAIL PROTECTED]To: [EMAIL PROTECTED] rn.org cc: Subject: [ cf-dev ] Belated Monday stupidness 06/07/2004 10:25 Please respond to dev Hi I am tearing my hair out with this: I have a form that posts back to itself but it seems like there are no form variables being posted . the code below is on top of the page and this is the form can anyone see where I am bolloxing it up? thanks Matt form name=LoginForm method=post action=Login.cfm table border=0 align=center tr td class=showUsernamenbsp;:/td td input type=text name=username class=inputbox/td /tr tr td class=showPasswordnbsp;:/td td input type=password name=pass class=inputbox/td /tr tr td input type=submit class=inputbutton value=login/td td input type=reset value =Clear class=inputbutton/td /tr /table /form cfif isdefined(form.pass) cfquery name=getdetails datasource=#db# dbtype=odbc SELECT userId,productionhouseId from tbluser where username='#form.username#' and password ='#form.pass#' /cfquery CFIF getdetails.recordcount GTE 1 cflock scope=session timeout=10 cfset session.userId=getdetails.userID cfset session.productionhouseID=getdetails.productionhouseID /cflock cflocation url=Add.cfm CFELSE script language=JavaScript alert('The username password combination you supplied is incorrect'); /script /CFIF /cfif |\/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\/| -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Belated Monday stupidness
you got session cookies enabled in your browser? Matt Horn [EMAIL PROTECTED]To: [EMAIL PROTECTED] rn.org cc: Subject: Re: [ cf-dev ] Belated Monday stupidness 06/07/2004 10:58 Please respond to dev Ok so it is passing but if I output session vars on the login page I get correct values but on the page I CFlocated to the session vars are empty *scratches head* - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 11:46 AM Subject: RE: [ cf-dev ] Belated Monday stupidness That's shouldn't make any difference for CF, but its worth a change! Matt, have you removed all of your other code and just done a CF abort with and isDefined(form) on the page? Weird its not passing. I don't have a CF5 server to test anymore! -Original Message- From: Steve Powell [mailto:[EMAIL PROTECTED] Sent: 06 July 2004 10:47 To: [EMAIL PROTECTED] Cc: Steve Powell Subject: Re: [ cf-dev ] Belated Monday stupidness I notice there's a name but not an ID for the INPUT tags Matt Horn [EMAIL PROTECTED] wrote : No nbsp;Cf 5 nbsp; hmmm nbsp; ok I'll try some other stuff nbsp; thanks nbsp; nbsp; - Original Message - From: Robertson-Ravo, Neil (RX) To: '[EMAIL PROTECTED]' Sent: Tuesday, July 06, 2004 11:29 AM Subject: RE: [ cf-dev ] Belated Monday stupidness It seems to be working for me (renamed page to formtest.cfm)?. nbsp; lt;form name=LoginForm method=post action=formtest.cfm gt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;table border=0 align=centergt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;trgt; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;td class=showgt;Usernameamp;nbsp;:lt;/tdgt; nbsp;nbsp;nbsp;nbsp; lt;td gt;lt;input type=text name=username class=inputboxgt;lt;/tdgt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;/trgt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;trgt; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;td class=showgt;Passwordamp;nbsp;:lt;/tdgt; nbsp;nbsp;nbsp;nbsp; lt;td gt;lt;input type=password name=pass class=inputboxgt;lt;/tdgt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;/trgt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;trgt; nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;td gt;lt;input type=submitnbsp; class=inputbutton value=logingt;lt;/tdgt; nbsp;nbsp;nbsp;nbsp; lt;td gt;lt;input type=reset value =Clear class=inputbuttongt;lt;/tdgt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;/trgt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;/tablegt; nbsp;nbsp;nbsp;nbsp;nbsp; lt;/formgt; nbsp; nbsp; lt;cfif isdefined(form.pass) and IsStruct(form)gt; nbsp;nbsp; lt;cfdump var=#form#gt; lt;/cfifgt; nbsp; Is this on CFMX? nbsp; nbsp; nbsp; From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 06 July 2004 10:26To: [EMAIL PROTECTED]: [ cf-dev ] Belated Monday stupidness nbsp; Hi nbsp; nbsp;I am tearing my hair out with this: nbsp; I have a form that posts back to itselfnbsp; but it seems like there are no form variables being posted . nbsp; the code below is on top of the page and this is the form nbsp; can anyone see where I am bolloxing it up? nbsp; thanks nbsp;Matt nbsp; lt;form name=LoginForm method=post action=Login.cfm gt;nbsp;nbsp;nbsp;nbsp;nbsp; lt;table border=0 align=centergt;nbsp;nbsp;nbsp;nbsp;nbsp; lt;trgt;nbsp;nbsp;nbsp;nbsp;nbsp; nbsp;lt;td class=showgt;Usernameamp;nbsp;:lt;/tdgt;nbsp;nbsp;nbsp;nbsp; nbsp; lt;td gt;lt;input type=text name=username class=inputboxgt;lt;/tdgt;nbsp;nbsp;nbsp;nbsp;nbsp;
Re: [ cf-dev ] Batch Processing - Admin systems
if you're passing data to pages for validation, i assume you're talking server-side, i.e. not local. unless you do all your validation in Javascript, in which case just do it all on the same page. you could also upload a .csv file and import from that automatically. i like the idea of doing it all in Javascript (use hidden form fields to store the info) before submitting it. Or just have a form with a tabular layout, allowing the user to enter up to 50 items at once. Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: [ cf-dev ] Batch Processing - Admin systems 06/07/2004 15:09 Please respond to dev I need to make an admin system that allows batch processing. The user wants to be able to add say 50 records locally and then upload them to the server. I was thinking of using a form that adds a new line each time add another record is pressed finally a submit to database button. The user would enter data and then add another record until the user decided to upload to database. I think I will need an array to keep track of the data locally pass it to some sort of verifying page to verify all of the data (what if something is wrong?) and then an upload page to send it to the database. To put this in context the user is entering stock. Its a pain to enter an item on a form sumit/ enter another item etc ... Is this the right way to do it? Does anyone have any ideas - thoughts on this? Is there anything out there that I can have a look at for ideas? All comments welcome Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] QoQ and Verity
not entirely sure what you're trying to do here, but what I've done in the past with things like this is firstly perform your Verity search on the keywords: cfsearch name=getStuff ... then do a query on whatever criteria, plus your list of values returned from the cfsearch. cfquery name=dosearch datasource=dsn SELECT columns FROM tableName WHERE [some criteria] cfif getStuff.RecordCount AND ID IN (#ValueList(getStuff.Key) #)/cfif /cfquery don't think you can treat the results from the CFSearch as a table in a second query though. It might be that you'd be better off adding the relevant information (eventTitle, eventAims) to the actual collection (probably using the Custom1 and Custom2 fields). damian [EMAIL PROTECTED]To: [EMAIL PROTECTED] ign.co.ukcc: Subject: [ cf-dev ] QoQ and Verity 05/07/2004 11:43 Please respond to dev Hi all, I've got a verity search resultset and an additional resultset that I'm trying to join with a QoQ -- however it seems that CF don't like doing that- I'm getting errors like Incorrect Select list for the verity key column -- anyone know what I need to do or what I'm doing wrong? Here's the code: cfsearch collection=eventsMatrix type=SIMPLE criteria=' (#request.s_searchString#) OR #replace(form.searchKeywords,' ', ', ', ALL)#' name=keywordSearch cfquery name=selectEventsAdvanced datasource=#request.dsn# SELECT eventID,eventTitle,eventAims FROM contentEvents WHERE cfif isDate(form.dateFrom)dateFrom =#form.dateFrom#/cfif /cfquery cfquery name=selectJoinResults dbtype=query SELECT keywordSearch.score, selectEventsAdvanced.eventID,selectEventsAdvanced.eventTitle,selectEventsAdvanced.eventAims FROM keywordSearch, selectEventsAdvanced WHERE selectEventsAdvanced.eventID= keywordSearch.key ORDER BY keywordSearch.score /cfquery Cheers d -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Urgent: Moving Data from one table to another
cfquery INSERT INTO childTable (field1, field2, field3) SELECT a, b, c FROM masterTable WHERE ID IN (#Form.selectedRecords#) /cfquery Mike [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: [ cf-dev ] Urgent: Moving Data from one table to another 05/07/2004 15:45 Please respond to dev I am trying to put in a bit of functionality into a very old app and it's a nightmare. Here's the scenario: - One Master Table with all records - Customer chooses groups of records they want to use which is then transported to another table for action What I am trying to do is find the quickest and most efficient way of transporting those records between the master and child table. Also the records that could be chosen could be anything from 100 - 5 records. I have thought of a couple of ways of doing it involving arrays and sql inserts but didn't know if there was a way that sql could do it from a stored procedure (Still learning SQL at the moment) Any help would be gratefully received. Cheers Mike -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Online form builder
don't forget to move your custom tag: Cannot find CFML template for custom tag fb_ewebeditpro. http://www.choosemcs.co.uk/formbuilder/form-input-details.cfm Fiona Conner [EMAIL PROTECTED]To: [EMAIL PROTECTED] and.co.uk cc: Subject: RE: [ cf-dev ] Online form builder 05/07/2004 16:21 Please respond to dev Hi Adrian Sorry, the demo application has moved and can now be found at http://www.choosemcs.co.uk/formbuilder/ Regards Fiona. At 09:53 03/07/2004 +0100, you wrote: Fiona, in case you need a heads-up, I'm seeing Bad Request (Invalid Hostname) when I hit the URL http://www.mcscommunications.co.uk/ ...I just happened to hit a saved link to your online Form Builder. Regards -- 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 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] Broadband Communications . 3rd Floor, 133 Long Acre, London, WC2E 9DT +44 (0)20 7420 7991 Mobile +44 (0) 7775 710013 http://www.broadband.co.uk Development Centre High Pavement Business Centre 3-5 High Pavement, The Lace Market, Nottingham. NG1 1HF Tel: +44 (0) 115 959 6455 Fax: +44 (0) 115 959 6456 Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error. Security Warning: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] SQL compared to Access backend
things to watch for: text strings that are greater than the limit on a column (i.e. trying to insert a 100 char string into a varchar(50)) will need to be trimmed to length first if you don't want to throw an error. with Access I think it just truncated the string automatically. also things like concatenating strings is totally different Jolly Green Giant To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: dstoy.com Subject: [ cf-dev ] SQL compared to Access backend 01/07/2004 01:39 Please respond to dev So how different is your code when your backend is SQL Server rather than Access? I've worked in Access for 4 years. What can I expect to be different if I want to work in SQL? Most simple queries will stay the same, won't they? I know some functions may change, but what else? Thanks! David /jgg -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Access .ldb files
1. In CF Administrator, disable 'Maintain db connections' for this datasource. You'll probably have to restart CF server to see this work, I've found. 2. If it's still there, create a page with a query on this datasource that will break, e.g 'SELECT * FROM MadeUpTableName', and run this page 3. Try deleting the .ldb file if it's still there. Phil Ewington - 43 Plc To: UK CFUG [EMAIL PROTECTED] phil.ewington@cc: 43plc.com Subject: [ cf-dev ] Access .ldb files 30/06/2004 14:51 Please respond to dev Hi All, I have a project that uses Access databases and have come across a problem. There is .ldb file on the server and I now cannot update the database, how are these lock files created, I know when you open a .mdb file one is created, is one created when the db is accessed? How do I delete one, I only have FTP access. TIA Phil. --- Phil Ewington - Technical Director 43 Plc - Ashdale House 35 Broad Street, Wokingham Berkshire RG40 1AU T: +44 (0)1189 789 500 F: +44 (0)1189 784 994 E: mailto:[EMAIL PROTECTED] W: www.43plc.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 27/06/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Access .ldb files
that's a good technique. Presumably you could put something in the application.cfm to redirect them to a static page with a 'site temporarily down for maintenance' message. Jolly Green Giant To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: dstoy.com Subject: Re: [ cf-dev ] Access .ldb files 30/06/2004 15:10 Please respond to dev I was in that same senario for years. my ldb's took 30 min to clear. And with only FTP, there's nothing you can do really. There is some code that you can run to clear out all the connections and free it up, but if you are in a shared environment, it may -- will probably -- disrupt everyone else. One solution I used was to find all my references to that datasource and put some code around them that checks for a site-wide variable. if that var is false, it doens't allow the connection to the db and gives the user a 'temp out of service error page. 30 min of that would free up my db and then I 'd do what I had to do, and then set that var back to true so that normal functions could resume. Now if you just need to do things like add fields or tables, you can do that dynamically through SQL in your query statements. You wouldn't need to bring down the db for that. __/ Phil Ewington - 43 Plc \__ I have a project that uses Access databases and have come across a problem. There is .ldb file on the server and I now cannot update the database, how are these lock files created, I know when you open a .mdb file one is created, is one created when the db is accessed? How do I delete one, I only have FTP access. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] cfform
Are you sure you've got the fields 'revision' and 'EditComments' in your form, with the same-case spelling? Your bit of script chkRevision should ideally be in the head of your document, not just above the form. Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: [ cf-dev ] cfform 29/06/2004 14:47 Please respond to dev Yuck. I've inherited code which I'm debugging and it all uses cfform, a personal peeve of mine. Now, perhaps its because I came back from Glastonbury yesterday and so am a little bit mental, but I'm trying to get this cfform to fire off a validation script on submit. So I've added the onsubmit parameter to the cfform call like thus: cfform action=index.cfm?fuseaction=act_itemstepsstep=1 method=POST name=itemFrm enctype=multipart/form-data onsubmit=return chkRevision (); And I have the following function declared just above it like thus: script function chkRevision() { if (document.itemFrm.revision.value !document.itemFrm.EditComments.value.length) { alert('Warning!\n\nPlease ensure that you have completed the \'Edit Comments\' field.'); return false } else { return true } } /script That should work yea? So why does the JS give me a Object Not Found error when run at the browser on this line (which is obviously created by cfform) function _CF_checkitemFrm(_CF_this) { if (!_CF_hasValue(_CF_this.title, TEXT )) { if (!_CF_onError(_CF_this, _CF_this.title, _CF_this.title.value, Please enter Title)) { return false; } } return chkRevision(); return true; } p.s. I *would* dearly love to turn the whole form into a normal form, but there's a lot of work required (large form) to do that and this is a quick fix, very unfortunately. I think I've left my mind in a field. Ta everyone. Rich -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] cfform[Scanned]
you're usually better to have Javascript functions in the head of your document, so that they load in before the page starts to render. If it's stuff where you actually want to use Javascript to render the content (e.g. with some document.writeln commands), then obviously that should be in the document body. Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: RE: [ cf-dev ] cfform[Scanned] 29/06/2004 14:59 Please respond to dev Your bit of script chkRevision should ideally be in the head of your document, not just above the form. Why? I've never experienced this before. You can have a script wherever you like. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 29 June 2004 14:57 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] cfform[Scanned] Yup. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 June 2004 14:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfform[Scanned] Are you sure you've got the fields 'revision' and 'EditComments' in your form, with the same-case spelling? Your bit of script chkRevision should ideally be in the head of your document, not just above the form. Rich Wild [EMAIL PROTECTED]To: [EMAIL PROTECTED] group.com cc: Subject: [ cf-dev ] cfform 29/06/2004 14:47 Please respond to dev Yuck. I've inherited code which I'm debugging and it all uses cfform, a personal peeve of mine. Now, perhaps its because I came back from Glastonbury yesterday and so am a little bit mental, but I'm trying to get this cfform to fire off a validation script on submit. So I've added the onsubmit parameter to the cfform call like thus: cfform action=index.cfm?fuseaction=act_itemstepsstep=1 method=POST name=itemFrm enctype=multipart/form-data onsubmit=return chkRevision (); And I have the following function declared just above it like thus: script function chkRevision() { if (document.itemFrm.revision.value !document.itemFrm.EditComments.value.length) { alert('Warning!\n\nPlease ensure that you have completed the \'Edit Comments\' field.'); return false } else { return true } } /script That should work yea? So why does the JS give me a Object Not Found error when run at the browser on this line (which is obviously created by cfform) function _CF_checkitemFrm(_CF_this) { if (!_CF_hasValue(_CF_this.title, TEXT )) { if (!_CF_onError(_CF_this, _CF_this.title, _CF_this.title.value, Please enter Title)) { return false; } } return chkRevision(); return true; } p.s. I *would* dearly love to turn the whole form into a normal form, but there's a lot of work required (large form) to do that and this is a quick fix, very unfortunately. I think I've left my mind in a field. Ta everyone. Rich -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting
Re: [ cf-dev ] CFSearch: a laugh a minute
you're probably better using the startrow and maxrows on the cfoutput instead. Chris TazewellTo: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ll.co.ukSubject: [ cf-dev ] CFSearch: a laugh a minute 26/06/2004 14:54 Please respond to dev I've always thought that CFSearch was rather quirky, to say the least. Firstly there's the maxrows facility in CF 5, that when specified, will actually spit out one more row than the number input. So a cfsearch with maxrows set to 10, say, will actually return 11 records. Genius! I can live with this. However, what I was surprised about with CFMX (6.1), is that MM have managed to fix this rather blindingly obvious error. It now spits out up to the exact number specified in Maxrows. Woohoo! Exactly, that is, unless you specify a different start row. In my usual fashion, I create a search engine that outputs 10 or 20 rows at a time. The first time the search is run, there's a test search to find out how many results the search produces. Then the real search for output goes something like this: cfsearch criteria=#Trim(attributes.Criteria)# type=SIMPLE maxrows=20 collection=#request.CollectionName# startrow=#attributes.Startrow# name=FullSearch so attributes.Startrow will be 1, 11, 21... All well and good in CF5, but in MX, as soon as the second result set is called for, nothing comes out the other end. It took me quite a while to figure out what's going on. I checked the macromedia knowledge base (which only takes about 4 hours to find anything), nothing. I checked the MM forums (which takes about 3 hours per search), nada. So I tried the following: cfsearch criteria=* type=SIMPLE collection=#Request.CollectionName# name=Search1 cfsearch criteria=* type=SIMPLE maxrows=10 collection=#Request.CollectionName# startrow=1 name=Search2 cfsearch criteria=* type=SIMPLE maxrows=10 collection=#Request.CollectionName# startrow=11 name=Search3 cfsearch criteria=* type=SIMPLE maxrows=20 collection=#Request.CollectionName# startrow=11 name=Search4 cfdump var=#Search1# cfdump var=#Search2# cfdump var=#Search3# cfdump var=#Search4# And here are the results: Search 1: 109 records Search 2: 10 records Search 3: 0 records Search 4: 10 records So it turns out that Maxrows in MX isn't maxrows at all... The functionality is really Endrow. Pure bloody genius on a stick! Taz -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Web+
Anyone used or even looked at Web+? http://www.talentsoft.com/products/webplus/ it looks rather similar to CF, to say the least, but never heard of it before. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT : Mac OS 9 - IE 5.0 - Javascript issues.
nope, show us the code ;-) Stephen Moretti To: [EMAIL PROTECTED] (cfmaster) cc: [EMAIL PROTECTED]Subject: [ cf-dev ] OT : Mac OS 9 - IE 5.0 - Javascript issues. ter.co.uk 28/06/2004 14:15 Please respond to dev Is anyone aware of any issues with IE 5 on Mac OS 9 not having enough finger to be able to count from 1 to 5 correctly? Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT : Mac OS 9 - IE 5.0 - Javascript issues.
when I test that code, ItemTotal always returns zero (Firefox on PC). Stephen Moretti To: [EMAIL PROTECTED] (cfmaster) cc: [EMAIL PROTECTED]Subject: Re: [ cf-dev ] OT : Mac OS 9 - IE 5.0 - Javascript issues. ter.co.uk 28/06/2004 14:27 Please respond to dev Stephen Moretti (cfmaster) wrote: Is anyone aware of any issues with IE 5 on Mac OS 9 not having enough finger to be able to count from 1 to 5 correctly? Sorry I should be a bit more explicit. Just a p'd off with macs and the amount of f'ing around I'm having to do for something that is relatively simple. I have a number of checkboxes on a page and I have a bit of code that counts the number of boxes that have been checked onChange(). If the number of checked boxes is greater than the maximum number of items, then the user gets told so and the box gets unchecked. Works great on the PC, but I've just had the project manager on the phone saying it doesn't work on his computer (Mac OS 9: IE5.0) until he hits the maxitem+2 item. Then it unchecks the box for maxitem+1 Any seen anything like this?? The code is at the bottom of the page, just in case I've stuffed something up in there. Must think calming thoughts calm tranquil waters, sunny beaches, margarita's in the sunshine, funjunkie summer burn cds... Regards Stephen input type=checkbox name=selecta5samples value=F5164-45 class =descriptionText onChange =LimitReached(document.requestinfo,this,'selecta5samples') var maxItems = 5; function ItemTotal(thisForm, thisFieldName) { var total = 0; var thisField = eval(thisForm.+thisFieldName); for (var i=0;ithisField.length;i++) if (thisField[i].checked) total++; return total; } function LimitReached(thisForm,thisField,thisFieldName) { var total = ItemTotal(thisForm,thisFieldName); if ((total maxItems) thisField.checked) { alert(You can select up to + maxItems + items. Uncheck another item and try again.); thisField.checked = false; total--; } } -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] CFPOP
uh, at the bottom of that page it says: PLEASE NOTE: All our CFX tags are for the Windows platform only. Allan Cliff - CFUG SpainTo: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ain.org Subject: Re: [ cf-dev ] CFPOP 23/06/2004 10:10 Please respond to dev I just bought this tag and opened the zip and found it was a .dll. Something that was omitted from the description on their website. I use LINUX and therefore this won't help me. By the way, the company refunded me the money in less than 5 minutes which I thought was very good of them. Just thought I would warn any other potential buyers who use CF on LINUX. Allan - Original Message - From: Stephen Moretti To: [EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:37 AM Subject: [cf-dev] Re: [ cf-dev ] CFPOP Allan, This looks enlightening and the CFX tag that is there is a grand sum of £7.50! (11.35) :D http://www.web-architect.co.uk/cfxtags/cfx_tag.cfm?ProductID=3 Regards Stephen Allan Cliff - CFUG Spain wrote: CFPOP gave me loads of problems in CF5, so i have decided to use it in CFMX and guess what ! Yes, you are right. It doesn't work in CFMX either. http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags74.htm http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7threadid=767099#2800265 http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7threadid=767099#2800265 Lets see if Russ can shed any light on this. Maybe he got around this problem while configuring cfmxhosting.co.uk? I have tried updating to J2SDK 1.4.2_04-b05 but no joy. What i do is read mails that get bounced, pull out the email address and mark that in the db as a bad email address. The problems are only with mail received from Microsoft Exchange v5 and hotmail. They have unicode-1-1-utf-7 which CFPOP / Java doesn't like. *An exception occurred while retrieving mail. The cause of this exception was: java.io.UnsupportedEncodingException: iso-5520-1* We love you Macromedia ! -- Allan Cliff Malaga RedPro S.L. -- -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
[ cf-dev ] ASP / CF sessions
Lets say you've got a typical CF session, where you perhaps store the UserID in the Session scope. And you've also got some ASP pages, where you need to know that UserID. What would be the best way of passing the UserID to the ASP pages? some thoughts so far: - is it possible for ASP to access a CF session variable? - could access it via a cookie - use some kind of encryption to safely pass the value in a form/url, and decrypt on the other side (what kind of encryption?) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Creating an Access Database
cfcomet.com seems to have been down for some time. you can still access some of it's articles at http://web.archive.org/web/*/www.cfcomet.com Snake Hollywood To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: kepit.net Subject: RE: [ cf-dev ] Creating an Access Database 18/06/2004 11:08 Please respond to dev Ah Jet SQL what a wonderful thing. a lot of the access functionality and clever stuff is done via COM, you may find some useful code on www.cfcomet.com Russ From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 08:29 To: CF - List Subject: [ cf-dev ] Creating an Access Database I run the Spanish CFUG mailing list and someone has asked me the following question. I hope one if you can help (even though its Friday and most of you got pissed after the footy frenzy yesterday) This person has an SQL database with many companies. Each company has to have the option of downloading their data into a .mdb Access database. How could they create the .mdb file? The rest is not doubt CREATE TABLE etc script. -- Allan Cliff Malaga RedPro S.L. -- -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] DecimalFormat bug
the only one I could find was CommaFormat, which adds commas to the left of the decimal, and doesn't change what's on the right of the decimal. Guess I could write my own function... Snake Hollywood To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: kepit.net Subject: RE: [ cf-dev ] DecimalFormat bug 18/06/2004 11:07 Please respond to dev OK I think there was a replacement UDF on cflib.org for this function to get round that problem. If memory serves. Russ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 18:50 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] DecimalFormat bug Round just rounds to the nearest integer, which isn't going to help (well maybe in this theoretical one). The actual numbers I'm using are slightly different, e.g. 123.405 - could be either 123.41 or 123.42 depending on the vagaries of CF. Don't really want to go to the hassle of splitting the number up, rounding the part after the decimal, then re-joining. I guess I'll have to use NumberFormat... or perhaps ignore it! Snake Hollywood To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: kepit.net Subject: RE: [ cf-dev ] DecimalFormat bug 17/06/2004 18:39 Please respond to dev Use Round() to round it down. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 18:03 To: [EMAIL PROTECTED] Subject: [ cf-dev ] DecimalFormat bug This has probably been covered before. In CF5: #DecimalFormat(1.005)# #DecimalFormat(2.005)# gives: 1.00 2.01 What's the fix/workaround for this? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by
RE: [ cf-dev ] PDF 2 Text only
FWIW, too many TLA's IMHO FFS ;-) Colm Brazel [EMAIL PROTECTED]To: [EMAIL PROTECTED] world.iecc: Subject: RE: [ cf-dev ] PDF 2 Text only 18/06/2004 16:41 Please respond to dev Alex, How is your XSLT, I seem to be seeing this all over the place today? There are pressos at the coming CFUN04 by Michael Dinowitz and April Fleming on working with it, one of the outputs of FOP is to txt or RTF in the process it must convert the doc at some stage to XSL-FO using XSLT, I`m assuming the doc can be converted by FOP then to pdf or rtf or text, I may be incorrect in assuming this and it might not be possible as you suggest, that is that you can step back with the pdf to XSL-FO then use the engine to output to txt or RTF,...working with this before you probably know more about it than I:) For sure though if you can find a way to change the doc into xml then afaik it is fairly straight forward to use an XSLT transformation to do what you want. Apparently its the in thing to grab anything in xml whether its emails from google using xml or search applications, grab the xml apply XSLT and you can do anything with it, put it into a database, make a rtf of it FOP uses the standard XSL-FO file format as input, lays the content out into pages, then renders it to the requested output. One great advantage to using XSL-FO as input is that XSL-FO is itself an XML file, which means that it can be conveniently created from a variety of sources. The most common method is to convert semantic XML to XSL-FO, using an XSLT transformation. ot Microblast html2text is excellent but you need pdf to text:) I`m looking forward to CFUN04:) Colm -Original Message- From: Alex Skinner [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 15:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] PDF 2 Text only Colm, Thanks for the reply but, i dont see how FOP is going to help, i have used that before and it helps for production of pdfs but what im trying to do is take an existing pdf document and convert it either into xml document, html or straight text output ? Have you seen anything that does that ? Alex From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 15:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] PDF 2 Text only FOP is what you need latest CFDJ there's an interesting article on using a free Apache FOP(Formatting Objects Processor) that can be used with CFMX to create free pdf's and other formats http://xml.apache.org/fop/output.html, its a java application and the article by Nate Nelson describes how to configure it for CFMX WBR Colm -Original Message- From: Alex Skinner [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 14:57 To: [EMAIL PROTECTED] Subject: [ cf-dev ] PDF 2 Text only Hi, Has anyone got any experience of converting pdf docs into text or html on the fly with cfmx, are there any free java based modules that can do this ? Cheers Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.657 / Virus Database: 422 - Release Date: 13/04/2004 avast! Antivirus: Outbound message clean. Virus Database (VPS): 0425-1, 17/06/2004 Tested on: 18/06/2004 15:11:10
[ cf-dev ] DecimalFormat bug
This has probably been covered before. In CF5: #DecimalFormat(1.005)# #DecimalFormat(2.005)# gives: 1.00 2.01 What's the fix/workaround for this? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] IFRAME problems
using the onLoad will wait for the index page to fully load in, content, images etc, before it calls the function. If you want it to happen more automatically, remove the call to the function from the body onLoad bit, and just put it in the head of the index page. The function will then execute when the index page starts to load, not when it's completed loading. LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] IFRAME problems 16/06/2004 12:38 Please respond to dev Hi everyone, Thanks for everyones input yesterday, I ended up going down the route duncan suggested and it works fine although there is a bit of a nasty delay between when the you first enter the page and the body onload tag. If anyone has any other ideas I'd like to hear them but thanks to everyone Who helped. Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 14:34 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] IFRAME problems here's what I'd do: a href=index.cfm?id=#sid#submit/a in index.cfm, pass the relevant URL parameter to your Iframe: cfparam name=URL.ID default=0 iframe src=frame.cfm?id=#URL.id# /iframe LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: [ cf-dev ] IFRAME problems 15/06/2004 09:42 Please respond to dev Its early and I had no sleep last night trying to get an app finished. I have one problem though which I'm not sure is applicable to this list or some other list but help would be much appreciated. I am trying to load a page and update a iframe within that page at the same time. No matter what I try I can't get it to work. Any ideas? Link Code: a href=index.cfm onclick=document.mframe.location='frame.cfm?id =#sid#'submit/a The iframe is called mframe and the filename is frame.cfm The page with the iframe on is index.cfm Would I have to load the page and then do a frame refresh once the page is loaded? Any help would be appreciated Cheers Chris -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] IFRAME problems
your page should be something like this: head cfparam name=URL.ID default=0 /head body iframe name=mframe src=whatever id=mframe/iframe script language=Javascript type=text/javascript !-- var id = cfoutput#url.ID#/cfoutput; if (id 0) { document.getElementById('mframe').src = 'frame.cfm?id1=' + cfoutput#url.id1#/cfoutput + 'id2=' + cfoutput#url.id2#/cfoutput; } //-- /script /body NB: you were using to concatenate your javascript strings, but it should be + Also I've changed the typeof stuff you had to something simpler that works. LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] IFRAME problems 16/06/2004 16:46 Please respond to dev Hi Duncan, Am a bit rusty on the javascript side at the moment, what is required to do this? I have looked into it but having some trouble getting the thing to load from the top. Here is my script: if (typeof('url.ifs') != undefined) { document.getElementById('mframe').src = 'frame.cfm?id1=' cfoutput#url.id1#/cfoutput 'id2=' cfoutput#url.id2#/cfoutput; } Any help would be appreciated Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 16 June 2004 13:12 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] IFRAME problems using the onLoad will wait for the index page to fully load in, content, images etc, before it calls the function. If you want it to happen more automatically, remove the call to the function from the body onLoad bit, and just put it in the head of the index page. The function will then execute when the index page starts to load, not when it's completed loading. LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] IFRAME problems 16/06/2004 12:38 Please respond to dev Hi everyone, Thanks for everyones input yesterday, I ended up going down the route duncan suggested and it works fine although there is a bit of a nasty delay between when the you first enter the page and the body onload tag. If anyone has any other ideas I'd like to hear them but thanks to everyone Who helped. Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 14:34 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] IFRAME problems here's what I'd do: a href=index.cfm?id=#sid#submit/a in index.cfm, pass the relevant URL parameter to your Iframe: cfparam name=URL.ID default=0 iframe src=frame.cfm?id=#URL.id# /iframe LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: [ cf-dev ] IFRAME problems 15/06/2004 09:42 Please respond to dev Its early and I had no sleep last night trying to get an app finished. I have one problem though which I'm not sure is applicable to this list or some other list but help would be much appreciated. I am trying to load a page and update a iframe within that page at the same time. No matter what I try I can't get it to work. Any ideas? Link Code: a href=index.cfm onclick=document.mframe.location='frame.cfm?id =#sid#'submit/a The iframe is called mframe and the filename is frame.cfm The page with the iframe on is index.cfm Would I have to load the page and then do a frame refresh once the page is loaded? Any help would be appreciated Cheers Chris -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* ::
Re: [ cf-dev ] heeeeeelp!... I'm dumb !
this is the classic '404' error. the image on the top-left of the page has the following URL: http://www.gardenpassion.cfdeveloper.co.uk/placeholder.gif Does this image exist? Have you uploaded it to your website? Have you spelled the filename the same as in your HTML? Also, your slideshow thing has url's like: fotos/Aberia%20cAffra.jpg,fotos/Aberia%20cAffra.jpg, fotos/abutilon%20hybridum4.jpg,fotos/abutilon%20hybridum4.jpg, fotos/Acacia%20Caven.jpg,fotos/Acacia%20Caven.jpg, again, do these photos exists. have you spelled them correctly, is the directory 'fotos' in the correct location, etc? It looks to me like the 'fotos' directory doesn't even exist, or is in a different location (e.g. within another sub-folder) [EMAIL PROTECTED] ting.co.ukTo: [EMAIL PROTECTED] cc: 16/06/2004Subject: [ cf-dev ] heelp!... I'm dumb ! 17:36 Please respond to dev Hi thereBRBRI must be blind or something cause I loaded a page called pic.cfm in A href=http://www.gardenpassion.cfdeveloper.co.uk www.gardenpassion.cfdeveloper.co.uk/Anbsp;and I dotn seem to get it working, the pictures just wont coem out, can someone take a look at the source code which can be seen with no problem and let me know what I'm doing wrong BRBRthanks.thanksthanksthanksBRBRkoko This message has been sent from CFdeveloper with username gardenpassion ([EMAIL PROTECTED]) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT: JavaScript createUuid() ?
yes: script language=Javascript var UUID = cfoutput#CreateUUID()#/cfoutput; /script ;-) Aidan Whitehall [EMAIL PROTECTED]To: [EMAIL PROTECTED] nks.co.ukcc: Subject: [ cf-dev ] OT: JavaScript createUuid() ? 15/06/2004 14:45 Please respond to dev Sorry for the OT: have Googled and gone through O'Reilly JavaScript TDG, but can't find an answer -- is there a built-in JavaScript function that creates a UUID or GUID? Thanks. -- 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 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] IFRAME problems
if you actually want for index.cfm to fully load in before you change the content of it's iframe, you could try this in index.cfm cfparam name=URL.ID default=0 function changeIframe() { cfoutput document.iframename.src = 'frame.cfm?ID=' #URL.ID#; /cfoutput } body onLoad=changeIframe() LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] IFRAME problems 15/06/2004 14:51 Please respond to dev Hi News, Thanks for your reply, it works fine on the page you are on but it doesn't change the page that follows with the IFRAME on. I think I am gonna have to load the variables into the frame once the subsequent page has loaded. I think that's the only way, if anyone knows different let me know. Cheers Chris -Original Message- From: News Sameli [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 14:22 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] IFRAME problems If tried this onClick-Statement and it works fine: document.getElementById('iframe').src='yoursite.htm' LIVE Support wrote: Still trying to work out what this IFRAME saga, have tried everything and now far to tired and stressed. If anyone else knows anything I will be eternally grateful. -Original Message- From: News Sameli [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 10:23 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] IFRAME problems yep, that's what I mean LIVE Support wrote: -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: JavaScript createUuid() ?
could you just add a sequential number to the fieldnames? failing that, I guess you could randomly generate a 35-character string, and assume they'll be unique? Aidan Whitehall [EMAIL PROTECTED]To: [EMAIL PROTECTED] nks.co.ukcc: Subject: RE: [ cf-dev ] OT: JavaScript createUuid() ? 15/06/2004 15:04 Please respond to dev Why don't you dump a CreateUUID from coldfusion into a script? I'm generating form elements on the fly on a page in JS, and I figured the easiest way to find a unique name for each form field that's added is to use a native JavaScript createUuid() or createGuid() function. Thing is, I've searched high and low and can't find one and am finding it hard to believe that it's neither something in core JS or that no-ones every needed to do the same thing. And please excuse me if I refrain from justifying future requests. -- 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 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] IFRAME problems
here's what I'd do: a href=index.cfm?id=#sid#submit/a in index.cfm, pass the relevant URL parameter to your Iframe: cfparam name=URL.ID default=0 iframe src=frame.cfm?id=#URL.id# /iframe LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: [ cf-dev ] IFRAME problems 15/06/2004 09:42 Please respond to dev Its early and I had no sleep last night trying to get an app finished. I have one problem though which I'm not sure is applicable to this list or some other list but help would be much appreciated. I am trying to load a page and update a iframe within that page at the same time. No matter what I try I can't get it to work. Any ideas? Link Code: a href=index.cfm onclick=document.mframe.location='frame.cfm?id =#sid#'submit/a The iframe is called mframe and the filename is frame.cfm The page with the iframe on is index.cfm Would I have to load the page and then do a frame refresh once the page is loaded? Any help would be appreciated Cheers Chris -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OT - The going rate
sounds good to me, although I personally wouldn't split it into three types of development, as it's all part and parcel (especially on a small site). [EMAIL PROTECTED] ham.gov.uk To: [EMAIL PROTECTED] cc: 10/06/2004 13:29 Subject: [ cf-dev ] OT - The going rate Please respond to dev Hi all, I am trying to work out how much to charge a client for a small e-commerce site .. I am breaking up the development like this Front end development (£n) per hour x (n) hours / day = Daily rate (As I can't dedicate 100% of my time to it) x (n)days Back end developmet (Admin site) - This will have customer analysis tools, new products, delete products, pricing etc etc - same formula Database development - same formula Thing now is filling in the n's Front End £10.00/hour 2 hours per day (£20 / Day) and I would say 7 days (14 hours) to complete = £140.00 realistic Back End (more fiddly) £15/hour 2 hous per day (£30 / Day) and I would say 15 days (30 hours) to complete = £450.00 Database (probably ms access as hosting is cheaper) £10/hour 2 hours per day (£20 / Day) and I would say 3 days (6 hours) to complete = £60.00 Total = £650.00 Is this realistic for a small e-commerce site? 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. * -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Big prob
To unsubscribe, e-mail: [EMAIL PROTECTED] Roberta Englund To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: t Subject: RE: [ cf-dev ] Big prob 10/06/2004 17:15 Please respond to dev Delete [EMAIL PROTECTED] from your send contacts, Now! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 10:57 AM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Big prob I'm passing form parameters, but I can't use cfhttp as it's CF5 and everything's under SSL 128 bit encryption, hence CFX_rawsocket I could pass the form fields directly to the asp, but I'd got other error trapping and things were 'wrapped' up quite nicely. Rafe -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] cfschedule
I'm guessing he sent it the the CF Dev mailing list, which presumably you're signed up to Roberta? The [cf-dev] bit gives the clue... Roberta Englund To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: t Subject: RE: [ cf-dev ] cfschedule 09/06/2004 13:47 Please respond to dev And who did you really send this to? -Original Message- From: LIVE Support [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 7:25 AM To: [EMAIL PROTECTED] Subject: [ cf-dev ] cfschedule Afternoon everyone, I am experiencing some strange goings on when I check the schedule list on the server, I have a schedule that is set to process on a daily intervaland just after the 1st process has been done the schedule disappears from the list. Could anyone tell me if this is normal and the schedule is still there but not displayed or whether the schedule should stay in the list until the last one has been processed. Any help would be much appreciated. Cheers Chris -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] cfschedule
you did. Possibly Roberta has been signed up to the list by mistake, or didn't realise this email was sent to the list? To unsubscribe, e-mail: [EMAIL PROTECTED] LIVE Support [EMAIL PROTECTED]To: [EMAIL PROTECTED] nts.co.ukcc: Subject: RE: [ cf-dev ] cfschedule 09/06/2004 14:13 Please respond to dev Apologies I assumed I sent it to the CF Dev list. -Original Message- From: Roberta Englund [mailto:[EMAIL PROTECTED] Sent: 09 June 2004 13:47 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] cfschedule And who did you really send this to? -Original Message- From: LIVE Support [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 7:25 AM To: [EMAIL PROTECTED] Subject: [ cf-dev ] cfschedule Afternoon everyone, I am experiencing some strange goings on when I check the schedule list on the server, I have a schedule that is set to process on a daily intervaland just after the 1st process has been done the schedule disappears from the list. Could anyone tell me if this is normal and the schedule is still there but not displayed or whether the schedule should stay in the list until the last one has been processed. Any help would be much appreciated. Cheers Chris -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [cf-dev] [ cf-dev ] Decode Hash
or replace the Hash with an Encrypt / Decrypt, if you really need to find out passwords Peter Harrison [EMAIL PROTECTED]To: [EMAIL PROTECTED] sguru.com cc: Subject: RE: [cf-dev] [ cf-dev ] Decode Hash 08/06/2004 11:47 Please respond to dev Hashing is one-way encryption. Can be beaten (usually slowly) by brute force password guessers. How desperate are you to find the password? What the others guys are saying makes sense. Take the password management away from yourself (as the sys admin). Let users request new passwords be e-mailed to their account's e-mail address. - Peter -Original Message- From: Allan Cliff - CFUG Spain [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 11:36 To: [EMAIL PROTECTED] Subject: Re: [cf-dev] [ cf-dev ] Decode Hash You can't. All you can do is generate a random password and send it to the user. You will then have to save that new password (Hashed) in your database. Allan - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 12:32 PM Subject: [cf-dev] [ cf-dev ] Decode Hash I want to decode Hash , actually my password is stored using Hash. Now when i am developing Forget password option i want to send that password to user.BRBRany idea about it. Waqas Ahmed (JDeveloper) This message has been sent from CFdeveloper with username jdeveloper ([EMAIL PROTECTED]) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]