Re: locking, I think
Yes, that's the one. It's quite good, although it isn't a TOAD-killer (but there again what is?). On 10/8/06, Dave Watts [EMAIL PROTECTED] wrote: Because Oracle has a Free tool now that does a lot of the same work. What Free tool from Quest does the same thing as TOAD? I think James is referring to Oracle's new free SQL Developer: http://www.oracle.com/technology/software/products/sql/index.html 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! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ajax and CF...*sigh*...again...
On 10/8/06, Jim Davis [EMAIL PROTECTED] wrote: I don't agree that XML is too much of a PITA - at least not more or less than anything else. I meant this in the contect of frameworks are evil, so I want to reinvent the wheel, so XML is too much coding to deal with, so I'll just evaluate a JSON return in the client -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ajax and CF...*sigh*...again...
And of course that should be context and I should learn to speel chick more often. On 10/8/06, James Holmes [EMAIL PROTECTED] wrote: On 10/8/06, Jim Davis [EMAIL PROTECTED] wrote: I don't agree that XML is too much of a PITA - at least not more or less than anything else. I meant this in the contect of frameworks are evil, so I want to reinvent the wheel, so XML is too much coding to deal with, so I'll just evaluate a JSON return in the client -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror?
You can also use java util props and keep shrinking the code until you get one line. Like the CF classLoader, one line is all you need! cfset application.sqlserver_connection = createObject(java, java.lang.Class).forName(macromedia.jdbc.MacromediaDriver).newInstance().connect(#jdbc_str#, props) It would interesting if you load these lines into CF from a props file. Call it sql_server.properties cfset props = createObject(java, java.util.Properties) cfset props.setProperty(netAddress, ) cfset props.setProperty(portNumber, 1433) cfset props.setProperty(maxPooledStatements, 0) cfif NOT isdefined(application.sqlserver_connection) OR application.sqlserver_connection.isClosed() EQ YES cfset application.sqlserver_connection.close() /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror?
I think this is it. cfset FileInputStream = createObject(java, java.io.FileInputStream ).init(sqlServer.properties) cfset props = createObject(java, java.util.Properties).init() cfset props.load(FileInputStream) cfset FileInputStream.close() ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror?
And finally if isClosed() equals YES then its closed and a NO means its open. cfset FileInputStream = createObject(java, java.io.FileInputStream ).init(C:\CFusionMX7\wwwroot\sqlServer.properties) cfset props = createObject(java, java.util.Properties).init() cfset props.load(FileInputStream) cfset FileInputStream.close() cfset conn = createObject(java, java.lang.Class).forName( macromedia.jdbc.MacromediaDriver).newInstance().connect(jdbc, props) cfdump var=#conn.isClosed()# cfset conn.close() ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument underline in Linux
I don't know if it will help, but from Brian's blog entry: (http://www.briankotek.com/blog/index.cfm/2006/10/5/Special-Cases) Until you have to do something more than hello world. A while back we tried to add PDF generation to our application as an option to save the page, and we spent days just trying to get the CSS to affect the generated PDF. We tried linking to the CSS file outside of document. We tried inside cfdocument. We tried cfincluding it. We tried actually copying it within cfdocument. We tried inline styles. You get the idea. FWIW, we had to do a style type=text/css@import url('/assets/css/pdf.css');/style within every cfdocumentitem block to finally get it to work. Again, this sort of thing is not covered anywhere in the documentation (that I could find). On 10/7/06, Brad Wood [EMAIL PROTECTED] wrote: Actually we've had problems with our fonts too. They seem to want to revert back to Times new roman on us. One of the CF updaters fixed part of that. It still breaks if I do this though: p align=centerspan style=FONT-FAMILY: Arial, Helvetica, sans-serifI show up Arial/span/p span style=FONT-FAMILY: Arial, Helvetica, sans-serifp align=centerI show up Times/p/span Seems CSS doesn't get inherited properly from ancestor elements. ~Brad ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: locking, I think
Teddy Payne wrote: I typically don't make my UUIDs my primary keys are I prefer database to perform binary searchings on numbers and 35 character strings. A UUID/GUID is a number. Its string representation may be a bit funky, but it is still just a 128 bit number. Jochem ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
database design revisted
I have a table which holds information for a auction site and was wonder how to handle a couple of things. Sorry for the long drawn out question, but I am just a little baffeled on what the correct way of doing this may be. Hopefully I will not have too many questions after this, but the database is getting a little hairy. [auction expire] Say a auction is listed for 7 days, and ends at a specified time. How would I go about ending the auction? I have the following fields in the table. Would I need to run a scheduled task every so often and check the ending time and mark the auction as being over? Or should I have the code that checks the auction status in application.cfm and run it everytime someone visits the site? listed_time ending_time [payment_method] When placing an item up for auction, the seller can choose what payment types they prefer (Paypal, certified check, personal check, money order) should I store this info in it's own table referencing the user_id of the users table as key? I looked at the way EBAY was handling it, and they are having the seller decide payment options with each auction. Would it be better to do that only when a user signs up as a seller, and just put their preferred payment options in their preferences, instead of making them choose every time they place an auction? IE: [user_preferences] user_id payement_preference shipto_preference etc etc etc Thanks for all the help folks Doug (CFNoob) ;-/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfdocument underline in Linux
What you are seeing is correct CSS if the p tag has been defined, possibly by default, as Times New Roman. In my experience,span should nearly always be an inner tag. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 1:06 PM To: CF-Talk Subject: RE: cfdocument underline in Linux Actually we've had problems with our fonts too. They seem to want to revert back to Times new roman on us. One of the CF updaters fixed part of that. It still breaks if I do this though: p align=centerspan style=FONT-FAMILY: Arial, Helvetica, sans-serifI show up Arial/span/p span style=FONT-FAMILY: Arial, Helvetica, sans-serifp align=centerI show up Times/p/span Seems CSS doesn't get inherited properly from ancestor elements. ~Brad -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Friday, October 06, 2006 11:58 PM To: CF-Talk Subject: Re: cfdocument underline in Linux I didn't see the other replies, but a long shot could be an issue that sometimes effects jasperreports when switching from windows to linux. It has to do with the font metrics of the different JVMs, if I recall right... although I think that only happens with pre-compiled reports... have you tried switching the font just to see if that's it? Sorry I'm not more specific, I kinda doubt this is it, but it's something to try if you haven't yet... :-/ :Denny On 10/6/06, Brad Wood [EMAIL PROTECTED] wrote: Thanks for the suggestions. A member of my QA team conducted some test using both the tags and the CSS equivalent. Unfortunately, the results were still the same. Cfdocument on Linux refuses to display underline correctly regardless of whether or not it is CSS or the u tag. I even installed the latest Hotfix for cfdocument. On the bright side, after posting to the adobe forums and livedocs, I got a response from an Adobe employee who said he would look into it. I will keep my fingers crossed. ~Brad -Original Message- From: Jon Clausen [mailto:[EMAIL PROTECTED] Sent: Friday, October 06, 2006 6:30 PM To: CF-Talk Subject: Re: cfdocument underline in Linux Brad, I saw you got the bug fix in another reply. I'm not sure there is a fix for the tags themselves, but have you tried using CSS styles in place of the tags? I have a client that runs almost exclusively on SUSE boxes and the cfdocument work I've done has all been CSS-based. I've had no problems with any display issues other than a default font-size difference from my own development machines. u/u= span style=text-decoration: underline/span. I know it's not a straight fix, but at least it will get the display looking right. Jon On Oct 6, 2006, at 3:08 PM, Brad Wood wrote: Anybody??? -Original Message- From: Brad Wood Sent: Friday, October 06, 2006 10:49 AM To: CF-Talk Subject: RE: cfdocument underline in Linux Well, I guess I am not going to get any more help with my cfdocument/PDF/Linux bug I have exampled here www.bradwood.com/cfdocumenttest/ Does anyone know if Adobe publishes their bug reports so I can search and see if there is one entered already, and what the status is? How can I enter my own bug report? Thanks! ~Brad ** We are experiencing a handful of anomalies with the cfdocument tag when generating PDF's. *One* of which is that text surrounded by u /u exhibits strange behavior such as extra spaces (which are underlined) magically appearing before and or after the text. Example utest/u would have extra __ at the end of it-- sometimes all the way to the end of the page. About the only info I could find on the net was an unanswered comment on the Adobe Livedocs, and this unresolved Experts Exchange article: http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/ Q_21619446 ...html The above article seems to agree that the problem is limited to Linux, but nobody knows why it happens. We are using CF 7.0.2. I have run 4 tests. a) PDF Generation using cfdocument on a Windows server using CF 7.0.2 b) FlashPaper Generation using cfdocument on a Windows server using CF 7.0.2 c) PDF Generation using cfdocument on a Liniux server using CF 7.0.2 d) FlashPaper Generation using cfdocument on a Liniux server using CF 7.0.2 a) Works! 51 KB File b) Works! 57 KB File c) Broken! 2 KB File!! d) Works! 56 KB File The problem does in fact seem to be limited to PDF files on Linux servers. And why the heck is the file so small??? All of these test files are available for you to view at www.bradwood.com/cfdocumenttest. Please check them out to prove I'm not completely insane. If anybody out there heard of this, experienced this, works for iText and personally wants to fix this, or just want to lend moral support, I would love to hear from you. ? Thanks. ~Brad
Re: database design revisted
[auction expire] auction_start_date days_listed auction_end_date Maybe I'm missing something here, but it appears that when an auction is initially configured, you can set the auction_end_date by adding auction_start_date and days_listed. From there, all you need to do is compare auction_end_date to the current date. [payment_method] I would set up master tables for payments options and shipping options for use with separate preference tables for payment and shipping: (assume SQL Server database...untested) -- master table for payment options create table payment_options ( pmt_option_id int identity not null primary key, pmt_option_desc varchar (50) ); -- master table for shipping options create table shipping_options ( shp_option_id int identity not null primary key, shp_option_desc varchar (50) ); create table seller_pmt_preferences ( user_id int not null references user (user_id), pmt_option_id int not null references payment_options (pmt_option_id), constraint pk_seller_pmt_pref primary key clustered (user_id, pmt_option_id) ); create table seller_shp_preferences ( user_id int not null references user (user_id), shp_option_id int not null references shipping_options (shp_option_id), constraint pk_seller_shp_pref primary key clustered (user_id, shp_option_id) ); Then use the following query syntax to pull the seller options for display: !--- get seller payment options --- select p.pmt_option_id, p.pmt_option_desc from payment_options p inner join seller_pmt_preferences s on s.pmt_option_id = p.pmt_option_id where s.user_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.user_id# Dina ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: database design revisted
Dina, Thanks for the reply. As for the first question, [auction_end] I understand how to set-up the table as far as that goes, but am not sure if I should simply run the code for checking the expire date/time in the application.cfm or another way. What would you do? - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, October 08, 2006 9:34 AM Subject: Re: database design revisted [auction expire] auction_start_date days_listed auction_end_date Maybe I'm missing something here, but it appears that when an auction is initially configured, you can set the auction_end_date by adding auction_start_date and days_listed. From there, all you need to do is compare auction_end_date to the current date. [payment_method] I would set up master tables for payments options and shipping options for use with separate preference tables for payment and shipping: (assume SQL Server database...untested) -- master table for payment options create table payment_options ( pmt_option_id int identity not null primary key, pmt_option_desc varchar (50) ); -- master table for shipping options create table shipping_options ( shp_option_id int identity not null primary key, shp_option_desc varchar (50) ); create table seller_pmt_preferences ( user_id int not null references user (user_id), pmt_option_id int not null references payment_options (pmt_option_id), constraint pk_seller_pmt_pref primary key clustered (user_id, pmt_option_id) ); create table seller_shp_preferences ( user_id int not null references user (user_id), shp_option_id int not null references shipping_options (shp_option_id), constraint pk_seller_shp_pref primary key clustered (user_id, shp_option_id) ); Then use the following query syntax to pull the seller options for display: !--- get seller payment options --- select p.pmt_option_id, p.pmt_option_desc from payment_options p inner join seller_pmt_preferences s on s.pmt_option_id = p.pmt_option_id where s.user_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.user_id# Dina ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: database design revisted
What version of ColdFusion are you using, Doug? On 10/8/06, Doug Brown [EMAIL PROTECTED] wrote: Dina, Thanks for the reply. As for the first question, [auction_end] I understand how to set-up the table as far as that goes, but am not sure if I should simply run the code for checking the expire date/time in the application.cfm or another way. What would you do? - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, October 08, 2006 9:34 AM Subject: Re: database design revisted [auction expire] auction_start_date days_listed auction_end_date Maybe I'm missing something here, but it appears that when an auction is initially configured, you can set the auction_end_date by adding auction_start_date and days_listed. From there, all you need to do is compare auction_end_date to the current date. [payment_method] I would set up master tables for payments options and shipping options for use with separate preference tables for payment and shipping: (assume SQL Server database...untested) -- master table for payment options create table payment_options ( pmt_option_id int identity not null primary key, pmt_option_desc varchar (50) ); -- master table for shipping options create table shipping_options ( shp_option_id int identity not null primary key, shp_option_desc varchar (50) ); create table seller_pmt_preferences ( user_id int not null references user (user_id), pmt_option_id int not null references payment_options (pmt_option_id), constraint pk_seller_pmt_pref primary key clustered (user_id, pmt_option_id) ); create table seller_shp_preferences ( user_id int not null references user (user_id), shp_option_id int not null references shipping_options (shp_option_id), constraint pk_seller_shp_pref primary key clustered (user_id, shp_option_id) ); Then use the following query syntax to pull the seller options for display: !--- get seller payment options --- select p.pmt_option_id, p.pmt_option_desc from payment_options p inner join seller_pmt_preferences s on s.pmt_option_id = p.pmt_option_id where s.user_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.user_id# Dina ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: removing bad emails from bounced emails and db
If you were starting from scratch (and can install a CFX) I would recommend CFX_POP3. I used it on a project awhile back and it was awesome both in terms of speed and capability. IIRC it has a mode that will validate an address via an smtp check, without actually sending any mail. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: database design revisted
CFMX 7.02 - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, October 08, 2006 10:22 AM Subject: Re: database design revisted What version of ColdFusion are you using, Doug? On 10/8/06, Doug Brown [EMAIL PROTECTED] wrote: Dina, Thanks for the reply. As for the first question, [auction_end] I understand how to set-up the table as far as that goes, but am not sure if I should simply run the code for checking the expire date/time in the application.cfm or another way. What would you do? - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, October 08, 2006 9:34 AM Subject: Re: database design revisted [auction expire] auction_start_date days_listed auction_end_date Maybe I'm missing something here, but it appears that when an auction is initially configured, you can set the auction_end_date by adding auction_start_date and days_listed. From there, all you need to do is compare auction_end_date to the current date. [payment_method] I would set up master tables for payments options and shipping options for use with separate preference tables for payment and shipping: (assume SQL Server database...untested) -- master table for payment options create table payment_options ( pmt_option_id int identity not null primary key, pmt_option_desc varchar (50) ); -- master table for shipping options create table shipping_options ( shp_option_id int identity not null primary key, shp_option_desc varchar (50) ); create table seller_pmt_preferences ( user_id int not null references user (user_id), pmt_option_id int not null references payment_options (pmt_option_id), constraint pk_seller_pmt_pref primary key clustered (user_id, pmt_option_id) ); create table seller_shp_preferences ( user_id int not null references user (user_id), shp_option_id int not null references shipping_options (shp_option_id), constraint pk_seller_shp_pref primary key clustered (user_id, shp_option_id) ); Then use the following query syntax to pull the seller options for display: !--- get seller payment options --- select p.pmt_option_id, p.pmt_option_desc from payment_options p inner join seller_pmt_preferences s on s.pmt_option_id = p.pmt_option_id where s.user_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.user_id# Dina ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: database design revisted
Doug, There's no reason that you should need to add any kind of logic to expire an auction. You especially would not need to do anything in your Application.cfm/Application.cfc. When a user views an auction, just check the auction end date/time against the current date/time, and if the end date has already passed, set some kind of a flag: ie. cfset isAuctionFinished = dateCompare( now(), auction_end_date ) EQ 1 / That's it. All you have to do at that point is just check in your code if the auction is finished, and take the necessary action based on that. I am leaving out tons of implementation specific details, and of course you'ld want to validate your data, but the general idea is that you just check if the auction is finished whenever a user views it. You're having to retrieve that auction data anyways, so what's the big deal in adding one extra check to see if it's finished? I don't see any reason to run a scheduled job when it's not a problem to do the check in real time. As for the preferred payment, why not give the seller the opportunity to do both things you talked about? In their profile, let them choose a preferred method, but at the same time, give them the option to use a different method on a per-auction basis. - Justin On 10/8/06, Doug Brown [EMAIL PROTECTED] wrote: Dina, Thanks for the reply. As for the first question, [auction_end] I understand how to set-up the table as far as that goes, but am not sure if I should simply run the code for checking the expire date/time in the application.cfm or another way. What would you do? - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, October 08, 2006 9:34 AM Subject: Re: database design revisted [auction expire] auction_start_date days_listed auction_end_date Maybe I'm missing something here, but it appears that when an auction is initially configured, you can set the auction_end_date by adding auction_start_date and days_listed. From there, all you need to do is compare auction_end_date to the current date. [payment_method] I would set up master tables for payments options and shipping options for use with separate preference tables for payment and shipping: (assume SQL Server database...untested) -- master table for payment options create table payment_options ( pmt_option_id int identity not null primary key, pmt_option_desc varchar (50) ); -- master table for shipping options create table shipping_options ( shp_option_id int identity not null primary key, shp_option_desc varchar (50) ); create table seller_pmt_preferences ( user_id int not null references user (user_id), pmt_option_id int not null references payment_options (pmt_option_id), constraint pk_seller_pmt_pref primary key clustered (user_id, pmt_option_id) ); create table seller_shp_preferences ( user_id int not null references user (user_id), shp_option_id int not null references shipping_options (shp_option_id), constraint pk_seller_shp_pref primary key clustered (user_id, shp_option_id) ); Then use the following query syntax to pull the seller options for display: !--- get seller payment options --- select p.pmt_option_id, p.pmt_option_desc from payment_options p inner join seller_pmt_preferences s on s.pmt_option_id = p.pmt_option_id where s.user_id = cfqueryparam cfsqltype=cf_sql_integer value=#form.user_id# Dina ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: removing bad emails from bounced emails and db
If you were starting from scratch (and can install a CFX) I would recommend CFX_POP3. I used it on a project awhile back and it was awesome both in terms of speed and capability. IIRC it has a mode that will validate an address via an smtp check, without actually sending any mail. Nearly right Matt, the e-mail validation is provided by the CFX_ValidEmail tag that I also wrote :) Paul ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror?
Hi Dan, I'm confused, how is this code intended to work? Does it keep the connection with the new principle? What is the server was restarted. blists -Original Message- From: Dan Plesse [mailto:[EMAIL PROTECTED] Sent: October 7, 2006 11:36 PM To: CF-Talk Subject: Re: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror? You can also use java util props and keep shrinking the code until you get one line. Like the CF classLoader, one line is all you need! cfset application.sqlserver_connection = createObject(java, java.lang.Class).forName(macromedia.jdbc.MacromediaDriver).newInstance(). connect(#jdbc_str#, props) It would interesting if you load these lines into CF from a props file. Call it sql_server.properties cfset props = createObject(java, java.util.Properties) cfset props.setProperty(netAddress, ) cfset props.setProperty(portNumber, 1433) cfset props.setProperty(maxPooledStatements, 0) cfif NOT isdefined(application.sqlserver_connection) OR application.sqlserver_connection.isClosed() EQ YES cfset application.sqlserver_connection.close() /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror?
It mainly shows a way to make your code more compact and reading stuff from a properties file and using that infomation in your JDBC connection. Does SQL server send out information when it restarts? If isClosed() is YES sever is down and another check or ping isClosed() No means it's back. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF - Javascript Monitor Resolution help
This may be OT and if it is, I'll gladly move it to another group. I need to be able to determine (via javascript) preferably the user's monitor resolution. I have a client who wishes to have a FLASH animation that fills the browser banner area as much as possible so that a user on with a setting of 1024 wide doesn't have excessive whitespace around an 760 pixel wide banner. I have looked around at several javascripts scripts that can do this but... 1) I admit my complete inadequacy in javascript (I can read it and butch it up) and 2) I can't seem to do a decent job of getting my javascript to send a variable value BACK to my CFMX7 page. Any help? Oh, and I am tossing in some cash for the help (hence why this may be an OT / Job )! If there is an elegant way of even doing it in Flash, that is an option as well ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF - Javascript Monitor Resolution help
Screen.width And Screen.height E.G. A HREF=javascript:alert('Your resolution is '+screen.width+'x'+screen.height); Click for your screen resolution/A -- Russ -Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: 08 October 2006 21:45 To: CF-Talk Subject: CF - Javascript Monitor Resolution help This may be OT and if it is, I'll gladly move it to another group. I need to be able to determine (via javascript) preferably the user's monitor resolution. I have a client who wishes to have a FLASH animation that fills the browser banner area as much as possible so that a user on with a setting of 1024 wide doesn't have excessive whitespace around an 760 pixel wide banner. I have looked around at several javascripts scripts that can do this but... 1) I admit my complete inadequacy in javascript (I can read it and butch it up) and 2) I can't seem to do a decent job of getting my javascript to send a variable value BACK to my CFMX7 page. Any help? Oh, and I am tossing in some cash for the help (hence why this may be an OT / Job )! If there is an elegant way of even doing it in Flash, that is an option as well ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
limiting output of text
Hi, Am calling text from datasource and need to display only a small portion of it. ie. first 100 characters etc.. my code: cfif len(getRewards.reward_description) #Replace(Trim(getRewards.reward_description), Chr(10), br , ALL)# /cfif cheers terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: limiting output of text
What about cfoutput#Left(getRewards.reward_description, 100)#/cfoutput On 10/8/06, terry yee [EMAIL PROTECTED] wrote: Hi, Am calling text from datasource and need to display only a small portion of it. ie. first 100 characters etc.. my code: cfif len(getRewards.reward_description) #Replace(Trim(getRewards.reward_description), Chr(10), br , ALL)# /cfif cheers terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: limiting output of text
Cheers, Just what i needed What about cfoutput#Left(getRewards.reward_description, 100)#/cfoutput On 10/8/06, terry yee [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Soap and namespaces A bit deeper
Will, When you get Unable to find a constructor for class com.netsuite.webservices platform.core_1_3.RecordRef that accepts parameters of type ( java.lang.String, java.lang.String, com.netsuite.webservices.platform.core_1_3.types.RecordType ). It means you did not call the constructor correctly because your args are wrong. I wrote a java class dumper here and post it a weeks ago please use that code and find out what the args list is and or make sure the object you passed is the write type. or pass it to my online class dumper at cfide.org good luck, dan ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF - Javascript Monitor Resolution help
-Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: Sunday, October 08, 2006 4:45 PM To: CF-Talk Subject: CF - Javascript Monitor Resolution help This may be OT and if it is, I'll gladly move it to another group. I need to be able to determine (via javascript) preferably the user's monitor resolution. I have a client who wishes to have a FLASH animation that fills the browser banner area as much as possible so that a user on with a setting of 1024 wide doesn't have excessive whitespace around an 760 pixel wide banner. I have looked around at several javascripts scripts that can do this but... 1) I admit my complete inadequacy in javascript (I can read it and butch it up) and 2) I can't seem to do a decent job of getting my javascript to send a variable value BACK to my CFMX7 page. Here's an old article (I wrote it 2000) but it still seems to do the trick: http://www.depressedpress.com/Content/Development/ColdFusion/Articles/GetRes /Index.cfm Explains how to get the resolution and send it back to CF using a phony pixel graphic on the page. Jim Davis ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: limiting output of text
Heh. I don't know why I don't like cfif len(something) in the same manner I don't like cfif recordcount, but anywayze... ;-] cfset dis_reward_description = Replace(Trim(reward_description), Chr(10),br / ,ALL) cfif len(dis_reward_description) gt 97 #left(dis_reward_description,97)#... cfelseif len(dis_reward_description) gt 0 #dis_reward_description# /cfif And you may consider a fixed-width font so the kerning(sp?) doesn't defeat this attempt at making things even. I left the query name off, as it maybe should be, so long as it's in the main query loop. Otherwise, you'd want someQ.someField[someQ.currentrow], I think. I don't know. I'm not the best practicer of scoping by a long shot. Hehehe, -Denny On 10/8/06, terry yee [EMAIL PROTECTED] wrote: Hi, Am calling text from datasource and need to display only a small portion of it. ie. first 100 characters etc.. my code: cfif len(getRewards.reward_description) #Replace(Trim(getRewards.reward_description), Chr(10), br , ALL)# /cfif cheers terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: limiting output of text
www.cflib.org has a UDF called *FullLeft(str, count) * allows you to do a left on a string and only trim at the end of whole words. Some how i see triming at the last word being the next question :-) On 10/8/06, Denny Valliant [EMAIL PROTECTED] wrote: Heh. I don't know why I don't like cfif len(something) in the same manner I don't like cfif recordcount, but anywayze... ;-] cfset dis_reward_description = Replace(Trim(reward_description), Chr(10),br / ,ALL) cfif len(dis_reward_description) gt 97 #left(dis_reward_description,97)#... cfelseif len(dis_reward_description) gt 0 #dis_reward_description# /cfif And you may consider a fixed-width font so the kerning(sp?) doesn't defeat this attempt at making things even. I left the query name off, as it maybe should be, so long as it's in the main query loop. Otherwise, you'd want someQ.someField[someQ.currentrow], I think. I don't know. I'm not the best practicer of scoping by a long shot. Hehehe, -Denny On 10/8/06, terry yee [EMAIL PROTECTED] wrote: Hi, Am calling text from datasource and need to display only a small portion of it. ie. first 100 characters etc.. my code: cfif len(getRewards.reward_description) #Replace(Trim(getRewards.reward_description), Chr(10), br , ALL)# /cfif cheers terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
webDU 2007: 22-23 March 2007, Hilton Sydney
webDU 2007: 22-23 March 2007, Hilton Sydney == The Antipodes premier CF conference is on again :) Dates Call for Papers -- The dates and venue for webDU 2007 [1] released. * 22-23 March 2007 (THU-FRI) * The Hilton, Sydney Australia * Plus a workshop day, 21 March 2007 (WED) Also we've opened the Call For Papers [2]; veterans and budding presenters alike, please send in your submissions. [1]: http://www.webdu.com.au/ [2]: http://www.webdu.com.au/go/call-for-papers webDU Announcements -- There's a new announcements only mailing list [3] -- no discussions. As a consequence it's really very low volume; less than a post a week on average. And you'll only see posts from me keeping you up to date on the latest changes to the conference agenda and activities surrounding the conference. [3]: http://groups.google.com/group/webdu-ann/about That's all for now! Geoff Bowers Conference Manager webDU Conference Team http://www.webdu.com.au/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - Javascript Monitor Resolution help
Good Snake, now. how do I get it to be an 'autodetect' and pased into a CF variable? I was considering either making it a function or CFC or placing in the application.cfc file. dg Screen.width And Screen.height E.G. A HREF=javascript:alert('Your resolution is '+screen.width+'x'+screen.height); Click for your screen resolution/A -- Russ -Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: 08 October 2006 21:45 To: CF-Talk Subject: CF - Javascript Monitor Resolution help This may be OT and if it is, I'll gladly move it to another group. I need to be able to determine (via javascript) preferably the user's monitor resolution. I have a client who wishes to have a FLASH animation that fills the browser banner area as much as possible so that a user on with a setting of 1024 wide doesn't have excessive whitespace around an 760 pixel wide banner. I have looked around at several javascripts scripts that can do this but... 1) I admit my complete inadequacy in javascript (I can read it and butch it up) and 2) I can't seem to do a decent job of getting my javascript to send a variable value BACK to my CFMX7 page. Any help? Oh, and I am tossing in some cash for the help (hence why this may be an OT / Job )! If there is an elegant way of even doing it in Flash, that is an option as well ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF - Javascript Monitor Resolution help
Try using a 1x1 pixle image img src=sendinfo.cfm?scrWidth=xxxscrHeight= That is how every stats report tool does it. But the best thing would be to define an Ajax call back to the server, and change the info using DHTML. Either way the info needs to hit the server first before you can do anything else. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF - Javascript Monitor Resolution help
Auto detecting it would be done by running it when a page loads or on a timer or any other method that doesnt require the user specifically initializing it. Putting it into a cf var... You would need to send it back to a cf page via a post, get or simply document.location to a page passing it along in the url and grab it from there. Something like... document.location = 'mypage.cfm?res=' + Screen.width + 'x' + Screen.height; then mypage.cfm could read the url var 'url.res' and of course there is always AJAX. -Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: Sunday, October 08, 2006 8:54 PM To: CF-Talk Subject: Re: CF - Javascript Monitor Resolution help Good Snake, now. how do I get it to be an 'autodetect' and pased into a CF variable? I was considering either making it a function or CFC or placing in the application.cfc file. dg Screen.width And Screen.height E.G. A HREF=javascript:alert('Your resolution is '+screen.width+'x'+screen.height); Click for your screen resolution/A -- Russ -Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: 08 October 2006 21:45 To: CF-Talk Subject: CF - Javascript Monitor Resolution help This may be OT and if it is, I'll gladly move it to another group. I need to be able to determine (via javascript) preferably the user's monitor resolution. I have a client who wishes to have a FLASH animation that fills the browser banner area as much as possible so that a user on with a setting of 1024 wide doesn't have excessive whitespace around an 760 pixel wide banner. I have looked around at several javascripts scripts that can do this but... 1) I admit my complete inadequacy in javascript (I can read it and butch it up) and 2) I can't seem to do a decent job of getting my javascript to send a variable value BACK to my CFMX7 page. Any help? Oh, and I am tossing in some cash for the help (hence why this may be an OT / Job )! If there is an elegant way of even doing it in Flash, that is an option as well ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: limiting output of text
This will trim the text (str) at the specified length (trimat) and then delete everything AFTER the last space it finds. This way no words get cut in half. This is a much scaled down version of what I use for 'teasers' to articles. This method simply removes html rather than take them in to account when trimming the length. cfscript function teaserText(str,trimat) { if(len(str) gt trimat) { // Remove any html tags so they arent counted in the length str = rereplace(str, .*?, , all); //Cut the text at the desired length str = left(str, trimat); //Delete everything after the last space character str = listdeleteat(str, listlen(str, ), ); //Add '...' to the end to indicate that there is more to //read than what you see here str = str ...; } return str; } /cfscript cfoutput#teasertext(thetext, 150)#/cfoutput -Original Message- From: terry yee [mailto:[EMAIL PROTECTED] Sent: Sunday, October 08, 2006 5:36 PM To: CF-Talk Subject: limiting output of text Hi, Am calling text from datasource and need to display only a small portion of it. ie. first 100 characters etc.. my code: cfif len(getRewards.reward_description) #Replace(Trim(getRewards.reward_description), Chr(10), br , ALL)# /cfif cheers terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF SQLite
I was wondering whether anyone has managed to connect SQLite to Coldfusion MX. There is a JDBC driver for Coldfusion but I just can't seem to get it working properly. Any help would be greatly appreciated. Adam ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quicky question re: cfdocument and fonts
To Peter Boughton, Christine Davis, Chris Peterson, and Sandra Clark -- Thanks again for the help you provided me regarding my question about how to switch fonts within a cfdocument. In the end, a combination of inline style specifications (not font tags) and upgrading my server from 7.0 to 7.0.2 completely fixed the problem. My app is now producing PDFs in the desired font. Thank you! -- Larry Afrin Medical University of South Carolina Sandra Clark wrote: Make sure your call to a stylesheet is within the cfdocument tags. Basically your entire layout. I'm not sure how Acrobat handles font or other obsolete tags, but it does handle most of CSS properly. Sandra Clark == http://www.shayna.com Training in Cascading Style Sheets and Accessibility -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 2:07 PM To: CF-Talk Subject: Re: Quicky question re: cfdocument and fonts Peter -- Thanks for the idea, but I had also tried (prior to my original posting) the inline style stuff such as you suggested -- and got exactly the same result. Any other ideas? There has to be some way to use cfdocument to generate a PDF with a font other than Times Roman... -- LBA Quoting Peter Boughton [EMAIL PROTECTED]: What about if you try using span style=font: Whatever;../span ? Howdy -- I'm making my first use of cfdocument (no jokes about being behind the times, please -- I've been busy with other things), and it seems that no matter what I specify in the font tag inside the cfdocument, the resulting PDF displays the content in the same Times Roman font in whatever the default font size is (looks like about 12). I tried lots of the different font faces listed on my CF Administrator's Font Management page, but I keep getting the same result. Have also tried both yes and no fontembed settings, makes no difference. For that matter, I can't even get it to pay attention to font size=whatever tags. The size of the type in the PDF is properly affected by tags like h1, but font doesn't seem to be having any effect at all. I searched around a bit before writing this post, and I found a little bit of material alluding to there being some font problems with cfdocument in 7.0, but it wasn't clear to me that Updater 1 really fixed it, as there seem to be some more recent hotfixes for the same problem. I really couldn't find a good summary of the whole issue. Bottom line: I'm running MX 7 (version 7,0,0,91690 -- again, no jokes about behind the times; I believe in not fixing it if it ain't broke, but now it's broke) on Linux. Can anybody tell me what I have to do to get my cfdocument-produced PDFs to pay attention to my font tags? -- Larry Afrin Medical University of South Carolina [EMAIL PROTECTED] ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - Javascript Monitor Resolution help
Just a suggestion, but since Flash is vector based and scales exceptionally well, why don't you just use the javascript to change the height/width in your object tag, or pass it as a script var if you're using FlashObject(http://blog.deconcept.com/flashobject/). That would seem to be a bit more elegant solution than having to deal with it on the server level. -Jon On Oct 8, 2006, at 9:32 PM, Bobby Hartsfield wrote: Auto detecting it would be done by running it when a page loads or on a timer or any other method that doesnt require the user specifically initializing it. Putting it into a cf var... You would need to send it back to a cf page via a post, get or simply document.location to a page passing it along in the url and grab it from there. Something like... document.location = 'mypage.cfm?res=' + Screen.width + 'x' + Screen.height; then mypage.cfm could read the url var 'url.res' and of course there is always AJAX. -Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: Sunday, October 08, 2006 8:54 PM To: CF-Talk Subject: Re: CF - Javascript Monitor Resolution help Good Snake, now. how do I get it to be an 'autodetect' and pased into a CF variable? I was considering either making it a function or CFC or placing in the application.cfc file. dg Screen.width And Screen.height E.G. A HREF=javascript:alert('Your resolution is '+screen.width+'x'+screen.height); Click for your screen resolution/A -- Russ -Original Message- From: T Burke [mailto:[EMAIL PROTECTED] Sent: 08 October 2006 21:45 To: CF-Talk Subject: CF - Javascript Monitor Resolution help This may be OT and if it is, I'll gladly move it to another group. I need to be able to determine (via javascript) preferably the user's monitor resolution. I have a client who wishes to have a FLASH animation that fills the browser banner area as much as possible so that a user on with a setting of 1024 wide doesn't have excessive whitespace around an 760 pixel wide banner. I have looked around at several javascripts scripts that can do this but... 1) I admit my complete inadequacy in javascript (I can read it and butch it up) and 2) I can't seem to do a decent job of getting my javascript to send a variable value BACK to my CFMX7 page. Any help? Oh, and I am tossing in some cash for the help (hence why this may be an OT / Job )! If there is an elegant way of even doing it in Flash, that is an option as well ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4