getting an email address from a cfpop bounce back
im sending out newsletters to the companies database of subscribers, they say they get several thousand bounce backs each time. So I want to remove those bounce back emails from db. So i figured I'd set up a seperate email account just for the newsletters and grab all the bounce backs via cfpop and loop thru the results and run a delete against the mailing list db and get rid of them all. so the problem is that the email address comes back in the body section of the bounce back message and you have to go in and find it and grab it then run it into the delete query. You can use a regex but im not sure how to just get the email address out of all that. here is a sample of a bounce back I'm sorry to have to inform you that your message could not be be delivered to one or more recipients. It's attached below. For further assistance, please send mail to If you do so, please include this problem report. You can delete your own text from the attached returned message. The Postfix program <[EMAIL PROTECTED]>: host mail.asdd.com[216.77.62.196] said: 550 5.1.1 User unknown (in reply to RCPT TO command) how do i get that out and into its own variable? ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SMS Gateways
Burns, John D wrote: > I heard some stuff when Macromedia first came out with the gateways for > CFMX about the costs of SMS Gateways. Does anyone have round about > figures for that? Pricing for the gateway account and then prices per > message? I thought that it was pretty expensive but wanted to know if > it's changed or if anyone knows more details. I don't need exact > numbers, just an idea. Thanks! it depends a great deal on where you are, where you want to send (the "delivery" cost varies), whether your gateway connects to an aggregator or direct to a carrier, how much risk you want to undertake (seen some "too-good-to-be-true" offers), etc. but broadly speaking, maybe 5000 SMS outbound messages via SMPP shouldn't cost more than $300 US, with inbound ones usually costing 1/3 to 1/2 that. usually the more you send, the cheaper the cost per SMS will be. however there's more to it than simple pricing. you'll need to asses the service providers "support" for SMPP specs (which version, exactly what PDUs they do support, etc.) and perhaps their newbie tolerance ;-) and of course, you need the enterprise edition of cf7. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: sending mass emails
yes thats why I am trickling them out, their old site sent them all out at once. ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! From: Robert Munn <[EMAIL PROTECTED]> Sent: Saturday, February 04, 2006 12:26 AM To: CF-Talk Subject: Re: sending mass emails Are you worried about getting tagged as a spammer because of the volume? Just wondering , I didn't know that sort of stat showed up on the spam filters. >gotta send out 26,000 emails to a mailing list (dont worry it ain't sp*m) > >Made an email trickler to send them out in bursts. > >Does anyone have any current info on whats safe to send out at a time? > ># of messages per burst and time inbetween bursts. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231343 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sending mass emails
dag gone thats a lot! you dont have any troubles been listed a a spammer? ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! From: "Steve Kahn" <[EMAIL PROTECTED]> Sent: Saturday, February 04, 2006 12:16 AM To: CF-Talk Subject: RE: sending mass emails I use units of 500 with 2 seconds between bursts - haven't had any problems. Send apx 50,000 per week. Hope that helps. Steve -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:56 PM To: CF-Talk Subject: sending mass emails gotta send out 26,000 emails to a mailing list (dont worry it ain't sp*m) Made an email trickler to send them out in bursts. Does anyone have any current info on whats safe to send out at a time? # of messages per burst and time inbetween bursts. thanks ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: sending mass emails
Are you worried about getting tagged as a spammer because of the volume? Just wondering , I didn't know that sort of stat showed up on the spam filters. >gotta send out 26,000 emails to a mailing list (dont worry it ain't sp*m) > >Made an email trickler to send them out in bursts. > >Does anyone have any current info on whats safe to send out at a time? > ># of messages per burst and time inbetween bursts. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231341 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: sending mass emails
I use units of 500 with 2 seconds between bursts - haven't had any problems. Send apx 50,000 per week. Hope that helps. Steve -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:56 PM To: CF-Talk Subject: sending mass emails gotta send out 26,000 emails to a mailing list (dont worry it ain't sp*m) Made an email trickler to send them out in bursts. Does anyone have any current info on whats safe to send out at a time? # of messages per burst and time inbetween bursts. thanks ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Argh. Why isn't this Flash CFGRID displaying anything?
Inspired by Ray Camden's Harlan ad server's interfaces (they're simple but effective), I've decided to venture into the world of MX7's Flash forms. First up is trying to display some tabular data using CFGRID...problem is, I can't get my data to display in the grid...the headers are displaying as they should, but no data. CFDUMP shows all the data is there, and I know that CFGRID is working on some other projects of mine since I have Harlan up and running locally. Anyway, here's my code...am I doing something wrong? SELECT DISTINCT TOP 20 DC.ID AS datacardid, DC.Name, DC.updated FROMtblDataCardNotes DCN, tblDataCards DC WHERE DCN.datacardid =DC.id AND DCN.contactid = ORDER BYDC.updated DESC Your Recent Datacards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
sending mass emails
gotta send out 26,000 emails to a mailing list (dont worry it ain't sp*m) Made an email trickler to send them out in bursts. Does anyone have any current info on whats safe to send out at a time? # of messages per burst and time inbetween bursts. thanks ~Dave the disruptor~ I forgot what I was gunna put here, Will woulda stole it anyways! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231338 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ImageCFC component Available
Nice work, Rick. I downloaded it and it works a treat. Nicely done. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com On 2/4/06, Rick Root <[EMAIL PROTECTED]> wrote: > > Hi all, > > http://www.opensourcecf.com/imagecfc [/snip] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: passing multiple values from the same form field
It is for a form which will display a product. That product has options you can add to. Like Coffee, you can have the option of whole milk/skim/cream, sugar/equal/brown, caffine/decafe and so on. I want to pass these options along with the productID and qty. The possible values that are passed are: FORM.ProductID, FORM.Qty FORM.Option1 (option#count#) FORM.Option2 FORM.Option3 And so on... The Options are created dynamic so I don't know how many option groups (ie milk, sweeatner) I will have for each option (whole, skim, equal, splenda). This is why I have the input name= option#counter#. Since I'm working with radio input each group of options must have a unique name so I can select either whole milk, skim whole milk skim milk all have input nmes option1 white sugar, equal all have input names option2 The sku and qty are stored in a cartTable with a unique key for each line. Options will be insert in a seperate table which will only store the optionID and the cartID. Anyway, I don't know how to pass the many options along with the productID and qty. Can you point me to how to do this? > I have no idea what you are really trying to do. It sounds very > convoluted. > > But hopefully the answer to your question is the array notation for > form data. It usually is for these kinds of serially numbered fields. > > > #form["fieldname" & counter]# > > HTH > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > - > | 1 | | > - Binary Soduko > | | | > - > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231336 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
I have CFMX7, MySQL 5.0 and NaviCat all running locally -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:33 PM To: CF-Talk Subject: RE: MySQL 5 and CFMX7 (New Problem) Localhost is where the MySQL Database is at. It is all one machine -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in CF Admin > > -Original Message- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class > path? > You have to restart CF after you add it so that the jdbc driver gets > loaded in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/82.html > > Dave > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
Localhost is where the MySQL Database is at. It is all one machine -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in CF Admin > > -Original Message- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class > path? > You have to restart CF after you add it so that the jdbc driver gets > loaded in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/82.html > > Dave > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Equivalent to Java 'import .;'?
will do it. You don't need cfinvoke. On 2/4/06, Oleg Gunkin <[EMAIL PROTECTED]> wrote: > I want to be able to call all the functions of this component without > http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231333 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ImageCFC component Available
SWEET! Thanks dude! Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
It works fine, it just shows all the datatypes as having a field length of 65535 in rds. The reason this is a problem is my HomeSite/CF Studio cfc wizard (http://www.aftershockweb.net/forums/messages.cfm/ThreadId/50) gets all the qForm & cfc validation rules wrong because rds says all the field lengths are 65535. > the appropriatel ocation, and then used the "other" datasource type > instead of the "mysql" datasource type, and it still didn't work? > Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Equivalent to Java 'import .;'?
> Is there an equivalent to Java's 'import .;' > statement? I do not want to write ... all the time. No, there isn't. The CFIMPORT tag allows you to import JSP tag libraries and assign them prefixes, but that's not the same thing at all, really. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231330 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in > CF Admin > > -Original Message- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion > class path? > You have to restart CF after you add it so that the jdbc driver > gets loaded > in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/82.html > > Dave > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Equivalent to Java 'import .;'?
I want to be able to call all the functions of this component without mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 16:17 To: CF-Talk Subject: RE: Equivalent to Java 'import .;'? Is there an equivalent to Java's 'import .;' statement? I do not want to write http://www.houseoffusion.com/lists.cfm/link=i:4:231328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluate hell Pt2
-Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 22:58 To: CF-Talk Subject: evaluate hell Pt2 Need serious help rewriting this statement without using evaluate: (I'm confused???) Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
Yes, it is displayed under System Information in CF Admin -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:07 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Equivalent to Java 'import .;'?
Is there an equivalent to Java's 'import .;' statement? I do not want to write http://www.houseoffusion.com/lists.cfm/link=i:4:231326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
A useful trick if you're having this types of issue is to firstly ping the machine and then try telneting to the port. telnet ip.add.ress.here 1433 The ping tells you the routing is fine, the telnet tells you whether it's a firewall issue. (Telnet also works with mail servers (port 110 pop, 143 imap, 25 smtp.) Glad you got it sorted, Jenny >>-Original Message- >>From: Paul [mailto:[EMAIL PROTECTED] >>Sent: 03 February 2006 23:26 >>To: CF-Talk >>Subject: RE: setting up network data source >> >> >>I fixed it... It was the security policy on the db server; I had enabled >>port 1433 but not the SQL Server listener... or something. I'm not very >>familiar with Win2k3's security config stuff just yet. >> >>Thanks again for your advice. >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Equivalent to Java 'import .;'?
Is there an equivalent to Java's 'import .;' statement? I do not want to write http://www.houseoffusion.com/lists.cfm/link=i:4:231324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
Guess that would help java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 6:53 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) what error? On 2/3/06, ColdFusion <[EMAIL PROTECTED]> wrote: > Now I removed MySQL 5 and ran regClean to clean the registries. Then > re-installed MySQL 5. > > Downloaded the Connectors/J for 5.0 from MySQL > > copied the mysql-connector-java-5.0.0-beta-bin.jar > into CfusionMX7 \ wwwroot \ web-inf\ lib folder. > Restarted ColdFusion. > > Added the datasource using Other: > jdbc:mysql://localhost:3306/myTest > com.mysql.jdbc.Driver > > and now I have this error. > > Yes... MySQL is running on Port 3306 > Yes... I can connect to MySQL 5.0 using NaviCat using > Localhost:3306 > > Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
what error? On 2/3/06, ColdFusion <[EMAIL PROTECTED]> wrote: > Now I removed MySQL 5 and ran regClean to clean > the registries. Then re-installed MySQL 5. > > Downloaded the Connectors/J for 5.0 from MySQL > > copied the mysql-connector-java-5.0.0-beta-bin.jar > into CfusionMX7 \ wwwroot \ web-inf\ lib folder. > Restarted ColdFusion. > > Added the datasource using Other: > jdbc:mysql://localhost:3306/myTest > com.mysql.jdbc.Driver > > and now I have this error. > > Yes... MySQL is running on Port 3306 > Yes... I can connect to MySQL 5.0 using NaviCat using > Localhost:3306 > > Any ideas? > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
Now I removed MySQL 5 and ran regClean to clean the registries. Then re-installed MySQL 5. Downloaded the Connectors/J for 5.0 from MySQL copied the mysql-connector-java-5.0.0-beta-bin.jar into CfusionMX7 \ wwwroot \ web-inf\ lib folder. Restarted ColdFusion. Added the datasource using Other: jdbc:mysql://localhost:3306/myTest com.mysql.jdbc.Driver and now I have this error. Yes... MySQL is running on Port 3306 Yes... I can connect to MySQL 5.0 using NaviCat using Localhost:3306 Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluate hell Pt2
> From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] > evaluate("GetInventory.#GetListingFields.DBColName#[#GetInvent > ory.currentrow#]") > NEQ 0 AND > Trim(evaluate("GetInventory.#GetListingFields.DBColName#[#GetI > nventory.currentrow#]")) > NEQ ""> Is GetListingFields a query also? Just off the top of my head isdefined("GetInventory[GetListingFields[DBColName]]") and val(GetInventory[GetListingFields[DBColName]][GetInventory.currentrow]) neq 0 and len(trim(GetInventory[GetListingFields[DBColName]][GetInventory.currentrow]) ) neq 0 Tango ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Issue with CSS and doctype
Browsers have two rendering modes. quirks mode, is where a browser attempts to render a page in the way it used to (think "Best viewed with") Standards mode is where a browser attempts to render a page according to web standards mode (which basically is close to the same in each browser, tho each browser does have bugs) Browsers use DocTypes to "sniff" the rendering mode it will use. No DocType will always a revert a browser to quirks mode. Unfortunately, different browsers sniff different doctypes into different modes. The only doctypes that render standards mode across all browsers are: HTML 4.x Strict http://www.w3.org/TR/html4/strict.dtd";> HTML 4.01 Transitional http://www.w3.org/TR/html4/loose.dtd";> XHTML 1.0 Strict (no xml Declaration) http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> XHTML 1.0 Transitional (no xml Declaration) http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> the XHTML 1.1 doctypes will also force Standards mode, but IE has problems with it. Using an xml declaration with the DocType will Force IE6 and opera into Quirks Mode. Avoid using An example of what might be different is that IE 5.x and IE6 in quirks mode use a broken box model. In standards mode, IE6 will use the CSS standards box model. Its a major difference. The standard box model says that the width property is equal to the content width and all padding, borders and margins are in addition to the width. The broken box model that IE uses says the width property is equal to the content width, plus all padding and borders. so using that, if for example I had the following: div{ width: 10em; padding: 1em; border: .1em; } IE would actually subtract 2.2em from the 10em leaving just 7.8em for your content. Standards rendering would use 10em and the padding and border would be on their own. Hope that helps Sandy Clark -Original Message- From: Mike Soultanian [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 3:26 PM To: CF-Talk Subject: Re: OT: Issue with CSS and doctype You might want to try the css-discuss list: http://www.css-discuss.org They are *very* good at everything css... mike Robert Everland III wrote: > Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluate hell
Yeah, you can nest sqaure brackets. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 22:43 To: CF-Talk Subject: RE: evaluate hell GetInventory[GetListingFields.DBColName[GetListingFields.CurrentRow]][GetInv entory.CurrentRow] Adrian I wonder if that nested square brackets is allowed. It may have been the reason to do with that convoluted evaluate version. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
I fixed it... It was the security policy on the db server; I had enabled port 1433 but not the SQL Server listener... or something. I'm not very familiar with Win2k3's security config stuff just yet. Thanks again for your advice. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:23 PM To: CF-Talk Subject: Re: setting up network data source I would still look into firewall issues...Named Pipes uses the same ports as File and Print sharing, so some firewall may be letting that through, but not 1433 (TCP). -jim On 2/3/06, Paul <[EMAIL PROTECTED]> wrote: > Both use the same port here. It must be to do with TCP, assuming the other > two are using named pipes. I'll see what I can stir up, I guess. Thanks > for taking some time on this. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
evaluate hell Pt2
Need serious help rewriting this statement without using evaluate: (I'm confused???) Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluate hell
GetInventory[GetListingFields.DBColName[GetListingFields.CurrentRow]][GetInv entory.CurrentRow] Adrian I wonder if that nested square brackets is allowed. It may have been the reason to do with that convoluted evaluate version. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluate hell
Could someone translate this (and how to get out of it) #Evaluate("GetInventory.#GetListingFields.DBColName[GetListingFields.currentRow]#[#GetInventory.CurrentRow#]")# TIA, Cutter U maybe ... aField = GetListingFields.DBColName[GetListingFields.currentRow]; aRow = GetInventory.CurrentRow something = GetInventory[aField][aRow]; -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231312 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: evaluate hell
I guess GetInventory is a query so: GetInventory[GetListingFields.DBColName[GetListingFields.CurrentRow]][GetInv entory.CurrentRow] With GetListingFields.DBColName[GetListingFields.CurrentRow] equating to a column in GetInventory. Is that the sort of explaination you were after? Adrian -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: 03 February 2006 22:32 To: CF-Talk Subject: evaluate hell Could someone translate this (and how to get out of it) #Evaluate("GetInventory.#GetListingFields.DBColName[GetListingFields.current Row]#[#GetInventory.CurrentRow#]")# TIA, Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
evaluate hell
Could someone translate this (and how to get out of it) #Evaluate("GetInventory.#GetListingFields.DBColName[GetListingFields.currentRow]#[#GetInventory.CurrentRow#]")# TIA, Cutter ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: passing multiple values from the same form field
I have no idea what you are really trying to do. It sounds very convoluted. But hopefully the answer to your question is the array notation for form data. It usually is for these kinds of serially numbered fields. #form["fieldname" & counter]# HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
re: ImageCFC component Available
Thanks Rick:) ~Dave the disruptor~ google will pay you money to getting rid of ie :) http://explorerdestroyer.com/ http://www.killbillsbrowser.com/ From: Rick Root <[EMAIL PROTECTED]> Sent: Friday, February 03, 2006 2:39 PM To: CF-Talk Subject: ImageCFC component Available Hi all, http://www.opensourcecf.com/imagecfc I've got my new image.cfc component ready for public consumption. I'm calling it "2.00 beta 1" right now. 2.00 because it's based on Jim Dew's original work. Beta because it's not thoroughly tested. It *HAS* been tested on CFMX 7 (Windows and Linux) and Bluedragon 6.2 JX (Linux). Should also work on CFMX 6.1. The most important feature is that it supports specifying JPEG compression, allowing you to increase your output quality as long as you're willing to accept he increase in file size. The CFC includes the following methods: getImageInfo(), rotate(), scaleX() scaleY(), resize(), flipHorizontal(), flipVertical(), crop(), and convert() It will read JPG, PNG, and GIF images from local files or from URLS. It will write JPG and PNG files. Any valid readable format can be converted to a valid writeable format. All functions can take a file, URL, or BufferedImage object as input. All functions can output a file OR return a BufferedImage object. all functions optionally accept a JPEG compression argument, a number between 0 and 100. The default is 90. Rick Root ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
passing mulitple values from the same form field
Does anyone know how I can pass multiple values for an insert from grouped radio inputs? Not sure if I'm explaining it correctly but here it goes. I'm using a query group to group the radio inputs. I set up a counter for the group heading so each group can have a unique name. example: group option1 option1 option1 group option2 option2 option2 I want to pass the form fields option#count# to a custom tag: How can I pass the form option variables which can be many with the other(s) form variables which can on be one each? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flash CFForm Style
Great, thanks! Mike -Original Message- From: Michael Grove [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:21 PM To: CF-Talk Subject: Re: Flash CFForm Style I have been working on a form with custom colors.. here is the code I found and am using. There are alot of global styles listed below. For background color you only need one, but I figured I will give you all that I have and let you pick out what you need. function formOnLoad() { // Do anything that you need to do in the onload Event // call the function that is in charge of applying the styles applyStyles(); } function applyStyles() { _global.styles.CheckBox.setStyle("fillColors", [0xa7a7a7, 0xff]); _global.styles.RadioButton.setStyle("fillColors", [0x006699, 0xff]); _global.styles.Form.setStyle("color", 0x00); _global.styles.Button.setStyle("borderThickness", 1); _global.styles.Panel.setStyle("backgroundColor", 0xE5F0F9); _global.styles.Panel.setStyle("color", 0xff); _global.styles.Panel.setStyle("headerColors", [0x277DC6,0x50ABF7]); _global.styles.HBox.setStyle("backgroundColor", 0x757575); _global.styles.HBox.setStyle("marginTop", 10); _global.styles.HBox.setStyle("marginBottom", 10); _global.styles.HBox.setStyle("marginLeft", 10); _global.styles.Accordion.setStyle("fillColors", [0x547000,0x739802]); _global.styles.Accordion.setStyle("selectedFillColors", [0x84af00,0xa3d800]); _global.styles.Accordion.setStyle("themeColor", 0x0066cc); _global.styles.Accordion.setStyle("color", 0x0ff); _global.styles.TextArea.setStyle("fontSize",14); _global.styles.TextInput.setStyle("fontSize",9); _global.styles.DataGrid.setStyle("rollOverColor", 0xf5ffd7); _global.styles.DataGrid.setStyle("selectionColor", 0x84af00); _global.styles.DataGrid.setStyle("headerColors", [0xa6a6a6,0xe2e2e2]); } ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: setting up network data source
I would still look into firewall issues...Named Pipes uses the same ports as File and Print sharing, so some firewall may be letting that through, but not 1433 (TCP). -jim On 2/3/06, Paul <[EMAIL PROTECTED]> wrote: > Both use the same port here. It must be to do with TCP, assuming the other > two are using named pipes. I'll see what I can stir up, I guess. Thanks > for taking some time on this. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Flash CFForm Style
I have been working on a form with custom colors.. here is the code I found and am using. There are alot of global styles listed below. For background color you only need one, but I figured I will give you all that I have and let you pick out what you need. function formOnLoad() { // Do anything that you need to do in the onload Event // call the function that is in charge of applying the styles applyStyles(); } function applyStyles() { _global.styles.CheckBox.setStyle("fillColors", [0xa7a7a7, 0xff]); _global.styles.RadioButton.setStyle("fillColors", [0x006699, 0xff]); _global.styles.Form.setStyle("color", 0x00); _global.styles.Button.setStyle("borderThickness", 1); _global.styles.Panel.setStyle("backgroundColor", 0xE5F0F9); _global.styles.Panel.setStyle("color", 0xff); _global.styles.Panel.setStyle("headerColors", [0x277DC6,0x50ABF7]); _global.styles.HBox.setStyle("backgroundColor", 0x757575); _global.styles.HBox.setStyle("marginTop", 10); _global.styles.HBox.setStyle("marginBottom", 10); _global.styles.HBox.setStyle("marginLeft", 10); _global.styles.Accordion.setStyle("fillColors", [0x547000,0x739802]); _global.styles.Accordion.setStyle("selectedFillColors", [0x84af00,0xa3d800]); _global.styles.Accordion.setStyle("themeColor", 0x0066cc); _global.styles.Accordion.setStyle("color", 0x0ff); _global.styles.TextArea.setStyle("fontSize",14); _global.styles.TextInput.setStyle("fontSize",9); _global.styles.DataGrid.setStyle("rollOverColor", 0xf5ffd7); _global.styles.DataGrid.setStyle("selectionColor", 0x84af00); _global.styles.DataGrid.setStyle("headerColors", [0xa6a6a6,0xe2e2e2]); } ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Issue with CSS and doctype
Turns out the issue was with the case of one of my css classes. Once I changed it, it was working fine. So now I get it. Thanks for your help. The emails add in the double .. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
Both use the same port here. It must be to do with TCP, assuming the other two are using named pipes. I'll see what I can stir up, I guess. Thanks for taking some time on this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:53 PM To: CF-Talk Subject: RE: setting up network data source > Thanks for the ideas Dave. I double-checked the SQL login - > that's what I'm using in enterprise mgr. TCP/IP is also > already enabled - I really thought that would be the solution > earlier... > > Doesn't enterprise mgr use port 1433 just like CF? What does > CF do differently from enterprise mgr or the System DSN > console in establishing database connections? I'm puzzled. Enterprise Manager (and CF) use whatever port they're told to use. The default SQL Server listener is on TCP/1433. You would have to look in your Client Network Utility to see what you're actually using. Enterprise Manager and your System DSN could well be using Named Pipes instead of TCP/IP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Flash CFForm Style
I need to be able to set the background color of a Flash CFForm "DateField" input box. Any idea how to do this? Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Issue with CSS and doctype
What is the nature of the problem? After moving the script tag link tag to the head section where I believe they belong. I ran this sample and I got something, but I don't know if it is a wrong something or a correct something. Using my FF validator function, There where these 7 warnings, but no errors. Some of these warnings may help you out, since they seem to point to improper nesting which could cause all kinds of undesirable behavior. line 6 column 91 - Warning: adjacent hyphens within comment line 25 column 7 - Warning: missing before line 27 column 1 - Warning: inserting implicit line 36 column 16 - Warning: discarding unexpected line 42 column 4 - Warning: discarding unexpected line 14 column 1 - Warning: lacks "summary" attribute line 27 column 1 - Warning: anchor "sub0" already defined -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
> Thanks for the ideas Dave. I double-checked the SQL login - > that's what I'm using in enterprise mgr. TCP/IP is also > already enabled - I really thought that would be the solution > earlier... > > Doesn't enterprise mgr use port 1433 just like CF? What does > CF do differently from enterprise mgr or the System DSN > console in establishing database connections? I'm puzzled. Enterprise Manager (and CF) use whatever port they're told to use. The default SQL Server listener is on TCP/1433. You would have to look in your Client Network Utility to see what you're actually using. Enterprise Manager and your System DSN could well be using Named Pipes instead of TCP/IP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Comcast blacklisting solutions?
>>It's more cost effective to put the hammer down and inconvenience a minority then watch customer satisfaction levels plummet and support costs rise. This is not an excuse for not providing at least one address to which, even black listed people, could mail enquiries about what is the problem. This was my point. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Issue with CSS and doctype
Is that triple dot ellipse thing part of the actual CSS markup that I am not familiar with or just an artifact of the email message? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C code run. Run code run. Please!" - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Stan Winchester wrote: > Yes I've installed the latest drivers from the MySQL site. It never has made > a difference. > > What I've been wondering is what MySQL engine should I be using "MyISAM" or > the default "InnoDB"? From coldfusion's perspective, it doesn't really matter unless you want to use transactions... so you downloaded the new mysql connectorJ, installed the jar file in the appropriatel ocation, and then used the "other" datasource type instead of the "mysql" datasource type, and it still didn't work? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Creating a string of len(x)
Much better, many thanks. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:32 PM To: CF-Talk Subject: RE: Creating a string of len(x) > From: Nathan C. Smith [mailto:[EMAIL PROTECTED] > So I want to create a function to create string of arbitrary > length before I put anything into it (well, printable > characters anyway) > So I'm thinking there must be something better than > Loop 1 to x time > > Loop > And it's probably really obvious, but can somebody shoot me a > clue. (list? > Array of char?) RepeatString(string,count) :-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Yes I've installed the latest drivers from the MySQL site. It never has made a difference. What I've been wondering is what MySQL engine should I be using "MyISAM" or the default "InnoDB"? >Are you guys using the same/correct jdbc drivers? CF7 doesn't ship with >MySQL drivers for version 4 and 5, you have to install them youself. Have >you install the latest ones from the mysql website? > >Russ > >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Creating a string of len(x)
> From: Nathan C. Smith [mailto:[EMAIL PROTECTED] > So I want to create a function to create string of arbitrary > length before I put anything into it (well, printable > characters anyway) > So I'm thinking there must be something better than > Loop 1 to x time > > Loop > And it's probably really obvious, but can somebody shoot me a > clue. (list? > Array of char?) RepeatString(string,count) :-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Creating a string of len(x)
So I want to create a function to create string of arbitrary length before I put anything into it (well, printable characters anyway) So I'm thinking there must be something better than Loop 1 to x time Loop And it's probably really obvious, but can somebody shoot me a clue. (list? Array of char?) Thanks. -Nate ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Issue with CSS and doctype
You might want to try the css-discuss list: http://www.css-discuss.org They are *very* good at everything css... mike Robert Everland III wrote: > Can anyone help me out. When i change the doctype it completely changes how > it looks. I have no idea why. Can anyone explain. Raw css is first. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
Thanks for the ideas Dave. I double-checked the SQL login - that's what I'm using in enterprise mgr. TCP/IP is also already enabled - I really thought that would be the solution earlier... Doesn't enterprise mgr use port 1433 just like CF? What does CF do differently from enterprise mgr or the System DSN console in establishing database connections? I'm puzzled. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 12:49 PM To: CF-Talk Subject: RE: setting up network data source > On my dev machine, I can successfully set up a System DSN > using Win XP's admin tools. > > On my dev machine, I can successfully connect to the database > using Enterprise Mgr. > > On the remote server, I can successfully create a datasource > in CF Administrator to this database locally. > > On my dev machine, I cannot create a data source in CF > Administrator. It times out trying to establish a connection. Are you sure you're connecting using a native SQL login when you're using Enterprise Manager? If so, perhaps you're connecting via Named Pipes instead of via TCP/IP. Make sure that your SQL Server is configured to accept TCP/IP connections. You can do this using the Server Network Utility from the server console. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Issue with CSS and doctype
It doesn't validate, but the errors are on the javascript, it's the display that is the issue. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query a mySQL View?
The best thing to do with the MySQL site is search it through google: views site:http://dev.mysql.com/doc/refman/5.1 Then it becomes awesome again ;-) Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Issue with CSS and doctype
Does it validate as strict? -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:45 PM To: CF-Talk Subject: OT: Issue with CSS and doctype Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. container { color: #00; font-family:tahoma, verdana, helvetica; font-size: 11px; background-color: #f1f1ed; width:170px; height: 100%; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; padding-right : 1px; padding-top : 1px; padding-bottom : 1px; } leftMenu { color:#006699; text-decoration:none; font-weight:bold; } leftMenu:hover { color:#00; text-decoration:none; font-weight:bold; } leftMenu:active { color:#00; text-decoration:none; font-weight:bold ; } Menu { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 2px; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; background-color: #D4D0C8; cursor:pointer; color:#00; } Option { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 16px; background-color: #f5f5f5; border-top : 1px solid #ff; border-bottom : 1px solid #ff; border-left : 1px solid #ff; border-right : 1px solid #ff; cursor:pointer; } Options { padding-top : 1px; padding-right : 1px; padding-bottom : 1px; padding-left : 1px; } imgPosition { vertical-align: middle; } http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en-AU"> Transportation Scheduler [LOGIN] Text Folders http://www.yahoo.com');" onmouseover="this.style.background='#D8E4F8'" onmouseout="this.style.background='#f5f5f5'"> Text Links Text Links Text Links ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
> On my dev machine, I can successfully set up a System DSN > using Win XP's admin tools. > > On my dev machine, I can successfully connect to the database > using Enterprise Mgr. > > On the remote server, I can successfully create a datasource > in CF Administrator to this database locally. > > On my dev machine, I cannot create a data source in CF > Administrator. It times out trying to establish a connection. Are you sure you're connecting using a native SQL login when you're using Enterprise Manager? If so, perhaps you're connecting via Named Pipes instead of via TCP/IP. Make sure that your SQL Server is configured to accept TCP/IP connections. You can do this using the Server Network Utility from the server console. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Issue with CSS and doctype
Can anyone help me out. When i change the doctype it completely changes how it looks. I have no idea why. Can anyone explain. Raw css is first. ...container { color: #00; font-family:tahoma, verdana, helvetica; font-size: 11px; background-color: #f1f1ed; width:170px; height: 100%; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; padding-right : 1px; padding-top : 1px; padding-bottom : 1px; } ...leftMenu { color:#006699; text-decoration:none; font-weight:bold; } ...leftMenu:hover { color:#00; text-decoration:none; font-weight:bold; } ...leftMenu:active { color:#00; text-decoration:none; font-weight:bold ; } ...Menu { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 2px; border-right: buttonshadow 1px solid; border-top: #f5f5f5 1px solid; border-left: #f5f5f5 1px solid; border-bottom: buttonshadow 1px solid; background-color: #D4D0C8; cursor:pointer; color:#00; } ...Option { height: 20px; padding-top : 2px; padding-right : 5px; padding-bottom : 3px; padding-left : 16px; background-color: #f5f5f5; border-top : 1px solid #ff; border-bottom : 1px solid #ff; border-left : 1px solid #ff; border-right : 1px solid #ff; cursor:pointer; } ...Options { padding-top : 1px; padding-right : 1px; padding-bottom : 1px; padding-left : 1px; } ...imgPosition { vertical-align: middle; } http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en-AU"> Transportation Scheduler [LOGIN] Text Folders http://www.yahoo.com');" onmouseover="this.style.background='#D8E4F8'" onmouseout="this.style.background='#f5f5f5'"> Text Links Text Links Text Links ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
LOL, I didnt want to be that blunt. But yeah, it sucks. On 2/3/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > Be honest. The mySQL website is a piece of crap. > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Ryan Guill [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:29 PM > To: CF-Talk > Subject: Re: Query a mySQL View? > > > Ah, awesome. Do you know where I could get more information on them? > The MySql website is hard to navigate sometimes... > -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com Use CF and SQL? Try qBrowser - http://www.ryanguill.com/docs/ www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Comcast blacklisting solutions?
Obviously you've never worked for a large ISP help desk that answers complaint after complaint about spam. It's more cost effective to put the hammer down and inconvenience a minority then watch customer satisfaction levels plummet and support costs rise. Emmet -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:55 PM To: CF-Talk Subject: Re: Comcast blacklisting solutions? >>I've sent an email to Comcast with no answer, of course. This is indeed the most stupid thing in the whole story : they black list you, then you cannot even ask them "why?". I receive about 200 spams per day, so what ? I get about 99% filtered by Thunderbird, but I'm sure that any of my customers messages will get through. The server my mail was managed before had a "spam filter". It ws so busy to analyse all messages that sometimes it took 4 hours to receive a mesage I sent to myself ! Some get paranoïd with spam, and they harm others 10 times more than spam does. This reminds me some Usenet maniacs who spend hours and 1000s of lines in messages to explain others why they should not "overload the banwidth" ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ImageCFC component Available
Hi all, http://www.opensourcecf.com/imagecfc I've got my new image.cfc component ready for public consumption. I'm calling it "2.00 beta 1" right now. 2.00 because it's based on Jim Dew's original work. Beta because it's not thoroughly tested. It *HAS* been tested on CFMX 7 (Windows and Linux) and Bluedragon 6.2 JX (Linux). Should also work on CFMX 6.1. The most important feature is that it supports specifying JPEG compression, allowing you to increase your output quality as long as you're willing to accept he increase in file size. The CFC includes the following methods: getImageInfo(), rotate(), scaleX() scaleY(), resize(), flipHorizontal(), flipVertical(), crop(), and convert() It will read JPG, PNG, and GIF images from local files or from URLS. It will write JPG and PNG files. Any valid readable format can be converted to a valid writeable format. All functions can take a file, URL, or BufferedImage object as input. All functions can output a file OR return a BufferedImage object. all functions optionally accept a JPEG compression argument, a number between 0 and 100. The default is 90. Rick Root ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231282 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Load Balancing issues
Russ's 2 suggestions are excellent. ServerIron and BigIP. Both can be found for a steal on ebay quite a bit. If your on a budget stick with the ServerIron searches unless you want an old 4u BigIp. Emmet -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 2:02 PM To: CF-Talk Subject: RE: Load Balancing issues We're using ServerIronXL in a shared environment managed by the hosting company. BigIp F5 is also supposed to be pretty good. Personally, I've never managed a loadbalancer, but if I had to go with the cheapest solution, I would roll my own using LVS. There is enough customization to allow you to do what you want. Also the latest version of apache allows it to be used as a loadbalancer. I haven't tested it yet, and I don't know if it supports sticky sessions, but it might very well be possible. Russ > -Original Message- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:53 PM > To: CF-Talk > Subject: RE: Load Balancing issues > > Down these lines, does anyone have a recommendation for a good hardware > load balancer? Doesn't have to be top of the line or have a ton of > features. Just something reliable with decent features at a good price. > > > John Burns > Certified Advanced ColdFusion MX Developer > Wyle Laboratories, Inc. | Web Developer > > > -Original Message- > From: Nathan Strutz [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:50 PM > To: CF-Talk > Subject: Re: Load Balancing issues > > On 2/3/06, Russ <[EMAIL PROTECTED]> wrote: > > The load balancer has to specifically support sticky sessions. I > > think it does this via some sort of cookie, but I'm not entirely sure. > > Yes, depending on your HWLB device, it can set a cookie, go by IP > address or segment, URL params, etc., aka, literally anything that can > be used to identify the end-user. Smart ones will use a combination of > these tricks. > > > > Now, session replication in CF is enterprise only, but I've been able > > to get it to work with CF7 Standard. This is not documented or > > supported by Macromedia AFAIK, but I don't think it's against the > > EULA. I am planning to write an article on it sometime soon. Look > > for it in the next few issues of Fusion Authority. > > You've peaked my interest. I'm wondering how it would be possible... > of course there are always workarounds like client variables (yuck!) or > other DB storage mechanisms, and at one point i'd thought up a plan to > allow web service session lookups between servers. In any event, I'd > love to hear what you've got. :) > > -nathan strutz > http://www.dopefly.com/ > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query a mySQL View?
Be honest. The mySQL website is a piece of crap. -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:29 PM To: CF-Talk Subject: Re: Query a mySQL View? Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root <[EMAIL PROTECTED]> wrote: > Ryan Guill wrote: > > Sorry for the side topic on this, but I am in mysql setting up a new > > database for one of our new projects right now, and now that I am on > > mysql 5, I see Views now. I haven't ever used them before. What are > > they and what can they do? > > A view is sort of like a table, except that is is actually a query. > > You sometimes use views to simplify complex joins. Like if you commonly > join 5 tables, your sql query might get exceptionally complicated. > > But you could create a view, and query it as if it were one table > instead of 5... > > create view myView > as > SELECT A.field1, A.field2, B.field3, B.field4 > FROM table1 A inner join table2 B on A.id=b.id; > > select * from myView > where field1 = 3 > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7
Are you guys using the same/correct jdbc drivers? CF7 doesn't ship with MySQL drivers for version 4 and 5, you have to install them youself. Have you install the latest ones from the mysql website? Russ > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:21 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 > > How does rds in HomeSite or DW display the field lengths? Are they all > 65535? The reason this is important to me is because I have created a cfc > wizard for Homesite that works great with SQL Server, but with MySQL data > sources it thinks everything is 65535 in length. > > >I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers > without > >issue. > > > >On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Ah, awesome. Do you know where I could get more information on them? The MySql website is hard to navigate sometimes... On 2/3/06, Rick Root <[EMAIL PROTECTED]> wrote: > Ryan Guill wrote: > > Sorry for the side topic on this, but I am in mysql setting up a new > > database for one of our new projects right now, and now that I am on > > mysql 5, I see Views now. I haven't ever used them before. What are > > they and what can they do? > > A view is sort of like a table, except that is is actually a query. > > You sometimes use views to simplify complex joins. Like if you commonly > join 5 tables, your sql query might get exceptionally complicated. > > But you could create a view, and query it as if it were one table > instead of 5... > > create view myView > as > SELECT A.field1, A.field2, B.field3, B.field4 > FROM table1 A inner join table2 B on A.id=b.id; > > select * from myView > where field1 = 3 > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Pete Ruckelshaus wrote: > I was only able to get MySQL to work with MX7 using an ODBC passthrough. > > It's really too bad that MySQL makes it so difficult for companies > like Macromedia to get the Java version of their drivers so that they > could update the default support in a point release...I mean it's only > been, what, 3 years since mySQL3 was replaced by mySQL4? > > /SARCASM > > Seriously, Macromedia, update the darned mySQL drivers already. don't be too hard on Macromedia. From what I undestand, MySQL's modern JDBC drivers are released under a license that basically prohibits macromedia from distributing them. you don't have to do odbc passthru, you can just use "Other" and install a current MySQL JDBC Driver. That's why I do. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Ryan Guill wrote: > Sorry for the side topic on this, but I am in mysql setting up a new > database for one of our new projects right now, and now that I am on > mysql 5, I see Views now. I haven't ever used them before. What are > they and what can they do? A view is sort of like a table, except that is is actually a query. You sometimes use views to simplify complex joins. Like if you commonly join 5 tables, your sql query might get exceptionally complicated. But you could create a view, and query it as if it were one table instead of 5... create view myView as SELECT A.field1, A.field2, B.field3, B.field4 FROM table1 A inner join table2 B on A.id=b.id; select * from myView where field1 = 3 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
How does rds in HomeSite or DW display the field lengths? Are they all 65535? The reason this is important to me is because I have created a cfc wizard for Homesite that works great with SQL Server, but with MySQL data sources it thinks everything is 65535 in length. >I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without >issue. > >On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Sorry for the side topic on this, but I am in mysql setting up a new database for one of our new projects right now, and now that I am on mysql 5, I see Views now. I haven't ever used them before. What are they and what can they do? Thanks, On 2/3/06, Ken Ferguson <[EMAIL PROTECTED]> wrote: > Works fine for me. > --Ferg > > Rick Root wrote: > > Les Mizzell wrote: > > > >> Hmmm - now that I can design a view in mySQL, how do I query the view in > >> Coldfusion? > >> > >> Don't work like it does in SQL Server, where you cn just go: > >> > >> select * from myVIEW > >> > > > > That's the way it's supposed to work. > > > > Rick > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Code Analyzer Desktop Program?
Tony Hicks wrote: > I was wondering if there was a software written that analyzes code like the > Admin tool does? The problem I'm having with the admin tool is that when I > view a report, it asks me to login again. When I login, it tells me the data > has expired... I've tried everything and I can't view the details. So I was > hoping there might be a desktop application written that just analyzes for > parse errors and such. For anything that shows up during compilation you can wire cfcompile.bat into your IDE. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Load Balancing issues
We're using ServerIronXL in a shared environment managed by the hosting company. BigIp F5 is also supposed to be pretty good. Personally, I've never managed a loadbalancer, but if I had to go with the cheapest solution, I would roll my own using LVS. There is enough customization to allow you to do what you want. Also the latest version of apache allows it to be used as a loadbalancer. I haven't tested it yet, and I don't know if it supports sticky sessions, but it might very well be possible. Russ > -Original Message- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:53 PM > To: CF-Talk > Subject: RE: Load Balancing issues > > Down these lines, does anyone have a recommendation for a good hardware > load balancer? Doesn't have to be top of the line or have a ton of > features. Just something reliable with decent features at a good price. > > > John Burns > Certified Advanced ColdFusion MX Developer > Wyle Laboratories, Inc. | Web Developer > > > -Original Message- > From: Nathan Strutz [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:50 PM > To: CF-Talk > Subject: Re: Load Balancing issues > > On 2/3/06, Russ <[EMAIL PROTECTED]> wrote: > > The load balancer has to specifically support sticky sessions. I > > think it does this via some sort of cookie, but I'm not entirely sure. > > Yes, depending on your HWLB device, it can set a cookie, go by IP > address or segment, URL params, etc., aka, literally anything that can > be used to identify the end-user. Smart ones will use a combination of > these tricks. > > > > Now, session replication in CF is enterprise only, but I've been able > > to get it to work with CF7 Standard. This is not documented or > > supported by Macromedia AFAIK, but I don't think it's against the > > EULA. I am planning to write an article on it sometime soon. Look > > for it in the next few issues of Fusion Authority. > > You've peaked my interest. I'm wondering how it would be possible... > of course there are always workarounds like client variables (yuck!) or > other DB storage mechanisms, and at one point i'd thought up a plan to > allow web service session lookups between servers. In any event, I'd > love to hear what you've got. :) > > -nathan strutz > http://www.dopefly.com/ > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
I've gotten it to work with upgraded ODBC drivers and with the ConnectorJ. --Ferg Scott Stroz wrote: > I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without > issue. > > On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> I was only able to get MySQL to work with MX7 using an ODBC passthrough. >> >> It's really too bad that MySQL makes it so difficult for companies >> like Macromedia to get the Java version of their drivers so that they >> could update the default support in a point release...I mean it's only >> been, what, 3 years since mySQL3 was replaced by mySQL4? >> >> /SARCASM >> >> Seriously, Macromedia, update the darned mySQL drivers already. >> >> Pete >> >> On 2/2/06, Adkins, Randy <[EMAIL PROTECTED]> wrote: >> >>> Does anyone have problems running MySQL 5 with CFMX 7? >>> >>> I have CMFX 7 and MySQL 4.1 but now the ODBC connections >>> bomb out for the following error: >>> >>> Connection verification failed for data source: DEV_THISSITE >>> java.sql.SQLException: Communication failure during handshake. Is there >>> a server running on localhost:3306? >>> The root cause was that: java.sql.SQLException: Communication failure >>> during handshake. Is there a server running on localhost:3306? >>> >>> >>> >>> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query a mySQL View?
Works fine for me. --Ferg Rick Root wrote: > Les Mizzell wrote: > >> Hmmm - now that I can design a view in mySQL, how do I query the view in >> Coldfusion? >> >> Don't work like it does in SQL Server, where you cn just go: >> >> select * from myVIEW >> > > That's the way it's supposed to work. > > Rick > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Load Balancing issues
Down these lines, does anyone have a recommendation for a good hardware load balancer? Doesn't have to be top of the line or have a ton of features. Just something reliable with decent features at a good price. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 1:50 PM To: CF-Talk Subject: Re: Load Balancing issues On 2/3/06, Russ <[EMAIL PROTECTED]> wrote: > The load balancer has to specifically support sticky sessions. I > think it does this via some sort of cookie, but I'm not entirely sure. Yes, depending on your HWLB device, it can set a cookie, go by IP address or segment, URL params, etc., aka, literally anything that can be used to identify the end-user. Smart ones will use a combination of these tricks. > Now, session replication in CF is enterprise only, but I've been able > to get it to work with CF7 Standard. This is not documented or > supported by Macromedia AFAIK, but I don't think it's against the > EULA. I am planning to write an article on it sometime soon. Look > for it in the next few issues of Fusion Authority. You've peaked my interest. I'm wondering how it would be possible... of course there are always workarounds like client variables (yuck!) or other DB storage mechanisms, and at one point i'd thought up a plan to allow web service session lookups between servers. In any event, I'd love to hear what you've got. :) -nathan strutz http://www.dopefly.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Load Balancing issues
On 2/3/06, Russ <[EMAIL PROTECTED]> wrote: > The load balancer has to specifically support sticky sessions. I think it > does this via some sort of cookie, but I'm not entirely sure. Yes, depending on your HWLB device, it can set a cookie, go by IP address or segment, URL params, etc., aka, literally anything that can be used to identify the end-user. Smart ones will use a combination of these tricks. > Now, session replication in CF is enterprise only, but I've been able to get > it to work with CF7 Standard. This is not documented or supported by > Macromedia AFAIK, but I don't think it's against the EULA. I am planning to > write an article on it sometime soon. Look for it in the next few issues of > Fusion Authority. You've peaked my interest. I'm wondering how it would be possible... of course there are always workarounds like client variables (yuck!) or other DB storage mechanisms, and at one point i'd thought up a plan to allow web service session lookups between servers. In any event, I'd love to hear what you've got. :) -nathan strutz http://www.dopefly.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231268 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SMS Gateways
I heard some stuff when Macromedia first came out with the gateways for CFMX about the costs of SMS Gateways. Does anyone have round about figures for that? Pricing for the gateway account and then prices per message? I thought that it was pretty expensive but wanted to know if it's changed or if anyone knows more details. I don't need exact numbers, just an idea. Thanks! John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: setting up network data source
Are you running SQL server on a standard port? Do you have some kind of firewall preventing access to the network for the cf service? Try running CF as a user or at least check 'allow to interact with desktop' checkbox. If you have any sort of firewall locally, disable it and see if that helps. Note, that windows SP2 comes with a firewall, and sometimes you might not even know that it's there and enabled. Russ > -Original Message- > From: Paul [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 12:39 PM > To: CF-Talk > Subject: RE: setting up network data source > > Sorry I didn't specify... SQL Server, yes. The server is using SQL > authentication, which works when I connect using enterprise mgr but not cf > admin. > > -Original Message- > From: John Beynon [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 10:23 AM > To: CF-Talk > Subject: Re: setting up network data source > > SQL server i guess? What authentication is the server using - NT > authenication or SQL authentication, that's usually the best place to > start looking. > > jb. > > On 03/02/06, Paul <[EMAIL PROTECTED]> wrote: > > I'm trying to connect my local CF instance to a database on another > server > > in my network, and I'm having trouble. Here's what I know. > > > > > > > > On my dev machine, I can successfully set up a System DSN using Win XP's > > admin tools. > > > > On my dev machine, I can successfully connect to the database using > > Enterprise Mgr. > > > > On the remote server, I can successfully create a datasource in CF > > Administrator to this database locally. > > > > On my dev machine, I cannot create a data source in CF Administrator. > It > > times out trying to establish a connection. > > > > > > > > I suspect I may be making a stupid mistake - does anyone spot it? > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Using JDBC drivers all of my MySQL data sources show a field length of 65535 regardless of data type. This is not specific to MySQL 5 with CFMX 7, I have had this problem since CF6.1 & MySQL 4. I would love to resolve this issue! >Have you tried one of the newer Mysql JDBC or ODBC drivers? > >http://www.mysql.com/products/connector/j/ >http://dev.mysql.com/downloads/connector/odbc/ > >Also check to see if Mysql is actually running on port 3306. > >Dave > >On Feb 2, 2006, at 11:07 AM, Adkins, Randy wrote: > >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Load Balancing issues
The load balancer has to specifically support sticky sessions. I think it does this via some sort of cookie, but I'm not entirely sure. If you have clustering in coldfusion with session replication enabled, then you can also set the load balancing algorithm to either enable sticky session in JRUn proxy (which handles the connection from IIS or apache), or not enable them. If you do enable them, it used the JSESSIONID (which must be enabled for this to work) to send the request to the proper server. If you don't have sticky sessions enabled, it won't necessarily go to the same server, but it won't matter since sessions are replicated (session CFC's are currently not replicated, but I believe all other variables are). Now, session replication in CF is enterprise only, but I've been able to get it to work with CF7 Standard. This is not documented or supported by Macromedia AFAIK, but I don't think it's against the EULA. I am planning to write an article on it sometime soon. Look for it in the next few issues of Fusion Authority. Russ > -Original Message- > From: Tony Hicks [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 11:35 AM > To: CF-Talk > Subject: Re: Load Balancing issues > > Russ, > > Where can I find information on either of these? I'm using a hardware load > balancer and we've been fiddling with the Affinity settings but nothings > working better than 70% of the time (while both servers are up). > > I'm supposing these are Enterprise-only features? > > >Also you can set up the loadbalancer to do sticky sessions (You can do > this > >in coldfusion as well). This won't prevent people from losing their > session > >if one of the servers fails, but it will send them to the same server as > >long as both servers are up. > > > >Russ > > > >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Encapsulation?
Wouldn't this be easier in a Stored Procedure? Well, SQL Encapsulation I mean... "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 -Original Message- From: Baz <[EMAIL PROTECTED]> To: CF-Talk Sent: Fri Feb 03 15:14:27 2006 Subject: RE: SQL Encapsulation? Hi Gang, Found your messages in my Junk Mail - was wondering why no-one responded! Brian you're right on all fronts. The example I gave was a paging one, but it's only an example, the real issue is re-using *portions* of SQL code in other queries - and not the query result itself. Here is a way that I have re-used *portions* of SQL code in 1 CFC: ** Search() ** SELECT COUNT(OrderID) as TotalRows FROM #getFrom()# WHERE CustomerName like '%Keywords%' ** Count() ** SELECT #getSelect()# FROM #getFrom()# WHERE StatusID > 5 ** getSelect() ** DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, CustomerName ** getFrom() ** Order INNER JOIN OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN Customer ON `Order`.CustomerID = Customer.CustomerID The preceding methods all live in the same CFC. You will notice that the Search() method and Count() method share the same FROM clause by getting it from another method. But they have a different SELECT, WHERE, GROUP BY, and so forth, so the query results will be very different. Other methods may share the same WHERE but not the same SELECT and even more methods may SHARE different parts. So you see, it's not a matter of caching queries, but building queries using encapsulated SQL. I am finding that my gateways CFCs (those that return queries) are generally using the same SQL for each method in the CFC. And that makes sense because if you want a COUNT it usually is for a record-set you want I the future. Same for SUM, GROUP, etc... These are all different representations of the same base. So SQL being a form of code like any other, should be re-used and encapsulated like any other. It doesn't seem proper to have to find and paste the same changes in 15-20 methods just because a little logic in the SQL changes. Thoughts? Baz -Original Message- From: Brian Peddle [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:07 AM To: CF-Talk Subject: RE: SQL Encapsulation? I was basing my assumptions on writing these same things over and over from job to job for past 10 years. I assumed with the top 50 he is paging. I am also assuming he built up his where clause using a series of 'if' or 'case' statements so it won't always be the same. So if someone has 50 dropdowns for a report generator the person could pick no options or pick all 50. But it seems as though he has disappeared from our discussion so your are right, its us guessing what he want. -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 8:08 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, first of all, I didn't read his initial question to be one of pagination, which is what you're implying. I read it as one of reusing query results in multiple ways. In that scenario, you could very easily cache your object, either in the application or the session scope. So, you'd be storing more in memory, but only making a single trip to the database. It's all trade-offs. Obviously, if you're working with millions of rows of data, this might not be the best approach. But, it seemed reasonable to me that if he's indicating that the where clause could have "hundreds of lines of complex logic based on passed in arguments" that he'd ultimately be returning a relatively small result set. Honestly, I'd be doing my best not to design an app that has hundreds of lines of complex logic for a single query, as I'd find that seriously unmaintainable. But, without knowing more specifics about what he's actually trying to acomplish, we're just tossing out potential solution scenarios. We don't really know the paramaters of the problem we're trying to solve
RE: setting up network data source
Sorry I didn't specify... SQL Server, yes. The server is using SQL authentication, which works when I connect using enterprise mgr but not cf admin. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 10:23 AM To: CF-Talk Subject: Re: setting up network data source SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul <[EMAIL PROTECTED]> wrote: > I'm trying to connect my local CF instance to a database on another server > in my network, and I'm having trouble. Here's what I know. > > > > On my dev machine, I can successfully set up a System DSN using Win XP's > admin tools. > > On my dev machine, I can successfully connect to the database using > Enterprise Mgr. > > On the remote server, I can successfully create a datasource in CF > Administrator to this database locally. > > On my dev machine, I cannot create a data source in CF Administrator. It > times out trying to establish a connection. > > > > I suspect I may be making a stupid mistake - does anyone spot it? > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Code Analyzer Desktop Program?
I was wondering if there was a software written that analyzes code like the Admin tool does? The problem I'm having with the admin tool is that when I view a report, it asks me to login again. When I login, it tells me the data has expired... I've tried everything and I can't view the details. So I was hoping there might be a desktop application written that just analyzes for parse errors and such. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Load Balancing issues
Russ, Where can I find information on either of these? I'm using a hardware load balancer and we've been fiddling with the Affinity settings but nothings working better than 70% of the time (while both servers are up). I'm supposing these are Enterprise-only features? >Also you can set up the loadbalancer to do sticky sessions (You can do this >in coldfusion as well). This won't prevent people from losing their session >if one of the servers fails, but it will send them to the same server as >long as both servers are up. > >Russ > >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RJustify Question
You could also wrap the text in a PRE tag. Keeps space formatting. -Original Message- From: PINE Phyo Z [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:06 AM To: CF-Talk Subject: RE: RJustify Question Table and div solutions are good. For some reasons if they don't work, using the tag below will solve the issue. HTH Pine -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:54 PM To: CF-Talk Subject: RE: RJustify Question Use a table and right align the columns... Eric -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, 02 February 2006 19:03 To: CF-Talk Subject: RJustify Question Trying to align a column of integers 9 11 999 77 3 So, the below does nothing: #RJustify(9, 3)# #RJustify(11, 3)# #RJustify(999, 3)# Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: setting up network data source
SQL server i guess? What authentication is the server using - NT authenication or SQL authentication, that's usually the best place to start looking. jb. On 03/02/06, Paul <[EMAIL PROTECTED]> wrote: > I'm trying to connect my local CF instance to a database on another server > in my network, and I'm having trouble. Here's what I know. > > > > On my dev machine, I can successfully set up a System DSN using Win XP's > admin tools. > > On my dev machine, I can successfully connect to the database using > Enterprise Mgr. > > On the remote server, I can successfully create a datasource in CF > Administrator to this database locally. > > On my dev machine, I cannot create a data source in CF Administrator. It > times out trying to establish a connection. > > > > I suspect I may be making a stupid mistake - does anyone spot it? > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
setting up network data source
I'm trying to connect my local CF instance to a database on another server in my network, and I'm having trouble. Here's what I know. On my dev machine, I can successfully set up a System DSN using Win XP's admin tools. On my dev machine, I can successfully connect to the database using Enterprise Mgr. On the remote server, I can successfully create a datasource in CF Administrator to this database locally. On my dev machine, I cannot create a data source in CF Administrator. It times out trying to establish a connection. I suspect I may be making a stupid mistake - does anyone spot it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RJustify Question
Table and div solutions are good. For some reasons if they don't work, using the tag below will solve the issue. HTH Pine -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:54 PM To: CF-Talk Subject: RE: RJustify Question Use a table and right align the columns... Eric -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, 02 February 2006 19:03 To: CF-Talk Subject: RJustify Question Trying to align a column of integers 9 11 999 77 3 So, the below does nothing: #RJustify(9, 3)# #RJustify(11, 3)# #RJustify(999, 3)# Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Encapsulation?
I'm not such a big fan of that method either - that's why I wrote the post! :) Maybe I should just make better use of views... In any case, I appreciate the time you spent giving it thought. Cheers, Baz -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 11:25 AM To: CF-Talk Subject: Re: SQL Encapsulation? Well, we were both interpreting your request a bit incorrectly then. But, I'm not sure I have an answer for you on this one. It's not something I'd do. I'd be more apt to make a view that "encapsulated" the generic joined data, and then pull the columns (selects) under the conditions (wheres) that I wanted. I find the method you're using below to be difficult to read, and while I understand the concept, it's one of those places where I fail to see the benefit of doing it that way. On 2/3/06, Baz <[EMAIL PROTECTED]> wrote: > > Hi Gang, > > Found your messages in my Junk Mail - was wondering why no-one responded! > > Brian you're right on all fronts. The example I gave was a paging one, but > it's only an example, the real issue is re-using *portions* of SQL code in > other queries - and not the query result itself. Here is a way that I have > re-used *portions* of SQL code in 1 CFC: > > ** Search() ** > > SELECT COUNT(OrderID) as TotalRows > FROM #getFrom()# > WHERE CustomerName like '%Keywords%' > > > ** Count() ** > > SELECT #getSelect()# > FROM #getFrom()# > WHERE StatusID > 5 > > > ** getSelect() ** > DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, > OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, > OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, > OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, > CustomerName > > ** getFrom() ** > Order INNER JOIN > OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN > Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN > Customer ON `Order`.CustomerID = Customer.CustomerID > > The preceding methods all live in the same CFC. You will notice that the > Search() method and Count() method share the same FROM clause by getting > it > from another method. But they have a different SELECT, WHERE, GROUP BY, > and > so forth, so the query results will be very different. Other methods may > share the same WHERE but not the same SELECT and even more methods may > SHARE > different parts. So you see, it's not a matter of caching queries, but > building queries using encapsulated SQL. > > I am finding that my gateways CFCs (those that return queries) are > generally > using the same SQL for each method in the CFC. And that makes sense > because > if you want a COUNT it usually is for a record-set you want I the future. > Same for SUM, GROUP, etc... These are all different representations of the > same base. > > So SQL being a form of code like any other, should be re-used and > encapsulated like any other. It doesn't seem proper to have to find and > paste the same changes in 15-20 methods just because a little logic in the > SQL changes. > > Thoughts? > > Baz > > > > > > -Original Message- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 9:07 AM > To: CF-Talk > Subject: RE: SQL Encapsulation? > > I was basing my assumptions on writing these same things over and over > from > job to job for past 10 years. > > I assumed with the top 50 he is paging. I am also assuming he built up > his > where clause using a series of 'if' or 'case' statements so it won't > always > be the same. So if someone has 50 dropdowns for a report generator the > person could pick no options or pick all 50. > > But it seems as though he has disappeared from our discussion so your are > right, its us guessing what he want. > > -Original Message- > From: Deanna Schneider [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 8:08 AM > To: CF-Talk > Subject: Re: SQL Encapsulation? > > Well, first of all, I didn't read his initial question to be one of > pagination, which is what you're implying. I read it as one of reusing > query > results in multiple ways. In that scenario, you could very easily cache > your > object, either in the application or the session scope. So, you'd be > storing > more in memory, but only making a single trip to the database. It's all > trade-offs. Obviously, if you're working with millions of rows of data, > this > might not be the best approach. But, it seemed reasonable to me that if > he's > indicating that the where clause could have "hundreds of lines of complex > logic based on passed in arguments" that he'd ultimately be returning a > relatively small result set. > > Honestly, I'd be doing my best not to design an app that has hundreds of > lines of complex logic for a single query, as I'd find that seriously > unmaintainable. But, without knowing more specifics about what he's > actually > trying to acomplish, we're just tossing out pote
RE: JRun Web Server Config display problem
> I have the multiserver CF MX7 running on our live server, and > have a small problem with the Web Server Configuration app. > > We have about 50 sites setup there, and because there is no > scrollbar for the site list, the buttons down the bottom of > the list are now off the desktop. > > Is this a known issue? Is there a workaround for it? I believe you can pass the desired parameters to it directly from the command line, rather than using the GUI at all. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT Best way to identify if a form was change
Looks good. I will check it out in more details... Thanks, Victor On 2/3/06, Dave Carabetta <[EMAIL PROTECTED]> wrote: > > On 2/3/06, Victor Moore <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > What is the best way to identify if a form has been changed? Currently I > set > > up a hidden field on the form on every onChange event. Then on the > onUnload > > I check the status of the hidden field and let the user know. Is this > the > > best (only) way to do it? > > > > Your easiest solution (obviously, my opinion) would be to head over to > Dan Switzer's site and use his amazing qForms JavaScript library. It > takes all the pain out of doing JS validation and it's incredibly > robust. His API literally has a changedFields() method that does all > the work for you. You would simply do: > > objForm = new qForm("myFormName"); > alert( objForm.changedFields ); > > That's it. No need for your own hidden fields or anything. I'm telling > you, Dan has done an incredible job of abstracting away the > complexities of JavaScript: > > http://www.pengoworks.com/index.cfm?action=get:qforms > > Regards, > Dave. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Encapsulation?
Well, we were both interpreting your request a bit incorrectly then. But, I'm not sure I have an answer for you on this one. It's not something I'd do. I'd be more apt to make a view that "encapsulated" the generic joined data, and then pull the columns (selects) under the conditions (wheres) that I wanted. I find the method you're using below to be difficult to read, and while I understand the concept, it's one of those places where I fail to see the benefit of doing it that way. On 2/3/06, Baz <[EMAIL PROTECTED]> wrote: > > Hi Gang, > > Found your messages in my Junk Mail - was wondering why no-one responded! > > Brian you're right on all fronts. The example I gave was a paging one, but > it's only an example, the real issue is re-using *portions* of SQL code in > other queries - and not the query result itself. Here is a way that I have > re-used *portions* of SQL code in 1 CFC: > > ** Search() ** > > SELECT COUNT(OrderID) as TotalRows > FROM #getFrom()# > WHERE CustomerName like '%Keywords%' > > > ** Count() ** > > SELECT #getSelect()# > FROM #getFrom()# > WHERE StatusID > 5 > > > ** getSelect() ** > DISTINCT OrderID, CustomerID, BillingAddressID, ShippingAddressID, > OrderDate, OrderFile, OrderPrescriptionFile, OrderInvoicePrintedDate, > OrderAgreementSigned, OrderShippingPrice, OrderDiscount, OrderComment, > OrderProblem, OrderCancelled, StatusID, Status, StatusPhrased, CustomerID, > CustomerName > > ** getFrom() ** > Order INNER JOIN > OrderStatus ON `Order`.OrderID = OrderStatus.OrderID INNER JOIN > Status ON OrderStatus.StatusID = Status.StatusID INNER JOIN > Customer ON `Order`.CustomerID = Customer.CustomerID > > The preceding methods all live in the same CFC. You will notice that the > Search() method and Count() method share the same FROM clause by getting > it > from another method. But they have a different SELECT, WHERE, GROUP BY, > and > so forth, so the query results will be very different. Other methods may > share the same WHERE but not the same SELECT and even more methods may > SHARE > different parts. So you see, it's not a matter of caching queries, but > building queries using encapsulated SQL. > > I am finding that my gateways CFCs (those that return queries) are > generally > using the same SQL for each method in the CFC. And that makes sense > because > if you want a COUNT it usually is for a record-set you want I the future. > Same for SUM, GROUP, etc... These are all different representations of the > same base. > > So SQL being a form of code like any other, should be re-used and > encapsulated like any other. It doesn't seem proper to have to find and > paste the same changes in 15-20 methods just because a little logic in the > SQL changes. > > Thoughts? > > Baz > > > > > > -Original Message- > From: Brian Peddle [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 9:07 AM > To: CF-Talk > Subject: RE: SQL Encapsulation? > > I was basing my assumptions on writing these same things over and over > from > job to job for past 10 years. > > I assumed with the top 50 he is paging. I am also assuming he built up > his > where clause using a series of 'if' or 'case' statements so it won't > always > be the same. So if someone has 50 dropdowns for a report generator the > person could pick no options or pick all 50. > > But it seems as though he has disappeared from our discussion so your are > right, its us guessing what he want. > > -Original Message- > From: Deanna Schneider [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 8:08 AM > To: CF-Talk > Subject: Re: SQL Encapsulation? > > Well, first of all, I didn't read his initial question to be one of > pagination, which is what you're implying. I read it as one of reusing > query > results in multiple ways. In that scenario, you could very easily cache > your > object, either in the application or the session scope. So, you'd be > storing > more in memory, but only making a single trip to the database. It's all > trade-offs. Obviously, if you're working with millions of rows of data, > this > might not be the best approach. But, it seemed reasonable to me that if > he's > indicating that the where clause could have "hundreds of lines of complex > logic based on passed in arguments" that he'd ultimately be returning a > relatively small result set. > > Honestly, I'd be doing my best not to design an app that has hundreds of > lines of complex logic for a single query, as I'd find that seriously > unmaintainable. But, without knowing more specifics about what he's > actually > trying to acomplish, we're just tossing out potential solution scenarios. > We > don't really know the paramaters of the problem we're trying to solve. > > > On 2/2/06, Brian Peddle <[EMAIL PROTECTED]> wrote: > > > > Using this method you would be bringing back potentially hundreds of > > thousands of records. > > > > He only needs 50 at a time. Why pass 100,000 or more maybe when you can > > send 50 records back to C
Los Angeles CFUG reforming - for real
I have, in a moment of enthusiastic madness, taken on reestablishing the Los Angeles CFUG, formerly part of SCFUG. If you would be interested in presenting at a meeting in the next few months, please let me know. There will be no charge for membership or attendance, although we will try to have a low cost food option, if folks want it. Meeting day is not set, but will probably be Tuesday or Wednesday evenings at 6:30 PMI am currently looking for a meeting place, most likely on the West side of Los Angeles. Please contact me off list is you can provide: A meeting place; A speaker (such as yourself); and/or You are with an organization that would be interested in underwriting the group, which would not be very expensive, as most fixed expenses like the Web site, etc. are already covered. The site should be up later this week. Thanks! Cary Gordon The Cherry Hill Company cgordon attt chillco ddott com 310-397-2999 (v) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT Best way to identify if a form was change
On 2/3/06, Victor Moore <[EMAIL PROTECTED]> wrote: > Hi All, > > What is the best way to identify if a form has been changed? Currently I set > up a hidden field on the form on every onChange event. Then on the onUnload > I check the status of the hidden field and let the user know. Is this the > best (only) way to do it? > Your easiest solution (obviously, my opinion) would be to head over to Dan Switzer's site and use his amazing qForms JavaScript library. It takes all the pain out of doing JS validation and it's incredibly robust. His API literally has a changedFields() method that does all the work for you. You would simply do: objForm = new qForm("myFormName"); alert( objForm.changedFields ); That's it. No need for your own hidden fields or anything. I'm telling you, Dan has done an incredible job of abstracting away the complexities of JavaScript: http://www.pengoworks.com/index.cfm?action=get:qforms Regards, Dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT Best way to identify if a form was change
> From: Victor Moore [mailto:[EMAIL PROTECTED] > What is the best way to identify if a form has been changed? > Currently I set up a hidden field on the form on every > onChange event. Then on the onUnload I check the status of > the hidden field and let the user know. Is this the best > (only) way to do it? I'd check out qForms from Pengoworks. http://pengoworks.com/qforms/docs/objects_qform.htm#hasChanged Mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SOT Best way to identify if a form was change
Hi All, What is the best way to identify if a form has been changed? Currently I set up a hidden field on the form on every onChange event. Then on the onUnload I check the status of the hidden field and let the user know. Is this the best (only) way to do it? Thanks Victor ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Sending an attached file with a unique name
I'm sending an attached pdf via cfmail/cfmailpart to a recipient. Right now, I'm naming the files in storage via uuid. I'd like to send the file along with a friendlier name (e.g. your_file.pdf). Is this possible without copying/renaming the file? Thanks, Rich ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFGRID And HREF?
Has anyone gotten this to work? I have a flash form, with a CFGRID in it. The grid comes up fine, but double clicking on any of the rows fails to bring me to the new page. Can someone provide a link to a tutorial on how to make this work? The Macromedia documentation does not work, and has several comments after the example advising them of such. I am flummoxed. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54