Re: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror?
I think this is it. ~| 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?
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! It would interesting if you load these lines into CF from a props file. Call it sql_server.properties ~| 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: 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: 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: 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: How to get MS-Access Table & Column info without cfobjec
To get table info from MS Access you need to talk to the connection object and ask the connection via a method which has four args. Scroll down to see the output http://www.cfide.org/getColumnLength.html A jws web service is the best way if you can't handle the null requirements for the method if you are still in CF 6. Source examples http://www.geocities.com/empiricallyspeaking/Access_getTablesCF5.txt http://www.geocities.com/empiricallyspeaking/Access_getTables.txt Change txt into jws and call it like a web service. and add close() methods to the connection object and ResultSet object. On 10/7/06, Chetna Sharma <[EMAIL PROTECTED]> wrote: > > How to list all the table in the MSAccess database.Iam firing query if on > access then i am able to get the list of the table but from the > vb.netapplication iam not able to get this as it is diplaying an error "Read > Permission not on msysobject" > > so please tell how to retreive tables list and repair the database from > the application > Thanks > Chetna Sharma > > Unfortunately, read permissions on table 'MSysObject are not set. > > > >I can't open the db in either Access97 or Access2000 on WinNT or WinXP > >-- hangs on NT, crashes on XP. > > > >I was able to repair the db successfully, but still can't open it. > > > >Yet, I can manipulate it with CFMX for any table I can remember. > > > >Any way to set the MSysObject permissions through an SQL Query? > > > >TIA > > > >Dick > > > >"Part of the inhumanity of the computer is that, > >once it is competently programmed and working > >smoothly, it is completely honest." - Isaac > >Asimov - > > > >On Monday, October 7, 2002, at 04:36 AM, Craig Dudley 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:255910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
BlogCFC 5.5 Released
I'm happy to announce the 5.5 release of BlogCFC. BlogCFC is a free, open source blogging application. There are many new features in this release, including: * Slideshows * Oracle support (thanks to Deanne Schneider) * XML-RPC support For more information, please see: http://ray.camdenfamily.com/index.cfm/2006/10/7/BlogCFC-55-Released -- === Raymond Camden, Vice President of Technology for roundpeg Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster Video game player? Have kids? Check out KidGamers.org ~| 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:255909 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
Paul, That would be great. Can you send it to me offlist? Thanks, Russ P.S. As I've said, I'm not necessarily saying that it's CFX_POP3 that's causing the instability, as we use a few other CFX tags to send/process mail, such as boogie bounce and ims mail, but something is causing issues, and if you have a debug version, that might at least eliminate a piece of the puzzle. > -Original Message- > From: Paul Vernon [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 07, 2006 6:45 AM > To: CF-Talk > Subject: RE: removing bad emails from bounced emails and db > > > cfxpop3 tag and have been fairly happy with the performance > > (although the server that sends mail and checks bounces keeps > > restarting the cf service and we've yet to pin down the culprit. > > > > Russ, > > If you need one to help identify your instability, I can provide you with > a > debug version of CFX_POP3 that would log any exceptions it > encounters/creates. > > 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:255908 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...
> -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 07, 2006 2:52 PM > To: CF-Talk > Subject: Re: Ajax and CF...*sigh*...again... > > >>I don't agree that XML is "too much of a PITA" > > May be not, but it is not a panacea either. > Sometimes, other solutions are many times simpler. Of course - but nothing is without issues. > Example : instead of using may generate a 500 k file, > create the Javascript code to define the structure, which may be less > than 5k. That ratio seems a little off... it really depends on what dialect of XML you're using. And the size of the transmitted file really doesn't have anything to with the complexity of the script. How do a large XML file, a small JSON file and a medium-sized block of JS code differ in developer complexity when they all result in the same exact output - a JS object? (Remember also that in CF this is exactly what "WDDX2JS" does in the WDDX tag: it generates client-side script.) But in the end generating JS is essentially what JSON does (JSON being essentially JavaScript literal notation). JSON attempts to eliminate some of the problems with that and to a great extent does. But generation of client-side code has its own problems as well. Structural validation of transmitted JS is even harder than validation of plain JSON - but validation of XML is well-defined. Data validation of JS (data typing) is either non-existent or tends to increase complexity and file size. Like most JSON parsers most people sending JS to the browser tend to muddy dates and strings and numbers. Transmitted JS, unlike an abstracted transfer mechanism like XML or JSON is designed to be "run" - the consumer environment "matters". An abstracted service has the benefits of loose coupling. There are complexities to loose coupling and most of the benefits are delayed but they can be important and tend to simplify extended development - often offsetting the additional complexity of the abstraction layer. Passing code blocks firstly means that a method has to be in-place which can "run" the code. This adds some complexity to interactive applications (usually a frame or iframe is used to run the code to eliminate main-page refreshing). Secondly you're running that code "blind" - whatever code is in there will run. This was a major concern in early JSON development were the only "deserilization" was the "eval()" method. JSON addressed this by incorporating a stricter parser but the problems would still remain for direct code generation. Lastly there are consistency issues. If you're going to standardize your JS deployment - make it generic - then you're just doing another abstraction layer. In other words you essentially end up with an object on the server and an object on the client - and each of which need know how to generate/consume them. If you don't make the transfer generic then you're writing a lot of custom script (or probably a lot of semi-generic script for problem groups) that doesn't really give you a whole heck of a lot. In the end the main issue is transfer size. XML can be big - depending on the selected dialect it can be huge - but some dialects are briefer. When dealing with very large packets of regular data (recordsets for example) YODEL adds only marginally to JSON can even beat client-side code generation. But like I said the end result on the client is the same: a JavaScript object ready to use. 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:255907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Output list of fields names from table
>>I would add "WHERE 1=0" just so no records are returned. Assuming the database driver is smart enough not to evaluate the expression for every record ;-) The longest time may not be for the number of records returned, but for the number of records tested. May be better use some indexed id field which sure does not exist in the table, like WHERE someId = 0, where someId is an auto number starting with1 for instance. This way the driver should end the query right at start. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:255906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java help
That appears to be it Dina. Thanks a ton.
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 07, 2006 1:37 PM
To: CF-Talk
Subject: Re: Java help
Bobby,
I think this is what you want:
import java.math.*;
import java.text.*;
import java.util.Locale;
public class BigDecimalFormatTest {
public static void main (String[] args) {
double [] nums = {71.715,71.725,71.735,71.745,71.755,71.765,71.775,71.785,
71.795};
NumberFormat form;
form = NumberFormat.getCurrencyInstance(Locale.US);
for (int i = 0; i < nums.length; ++i) {
BigDecimal theNumber = new BigDecimal (Double.toString(nums[i]));
theNumber = theNumber.setScale(2, RoundingMode.HALF_UP);
System.out.println(form.format(theNumber));
}
}
}
The key here is the double conversion to BigDecimal and setting the rounding
mode to half_up. The reason you weren't getting what you thought you should
is because DecimalFormat uses the half_even rounding mode.
Dina
On 10/7/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> Thanks for the suggestion. I saw that link before but dismissed it for
> some
> reason. I guess I assumed it was doing something else. In any event, I
> just
> tried it and it DID come up with different output but still not what it
> should be. I may very well be using it wrong though. It's probably obvious
> that I'm no Java programmer. I'm basically just taking what I know about
> programming in general and the syntax of JavaScript and doing the best I
> can
> here.
>
> This is what I have from your suggestion and what it displays.
>
> import java.text.*;
> import java.math.BigDecimal;
>
> public class dollarFormattingTest
> {
> public static void main(String[] args)
> {
> DecimalFormat dollarFormat = new DecimalFormat("$0.00");
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.815)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.825)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.835)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.845)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.855)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.865)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.875)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.885)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.895)));
> }
> }
>
>
> This is the output now...
>
> $71.81
> $71.83
> $71.83
> $71.84
> $71.86
> $71.86
> $71.88
> $71.89
> $71.89
>
> That's either extremely weird... or I'm completely missing something
> obvious. :-/
>
>
> -Original Message-
> From: Denny Valliant [mailto:[EMAIL PROTECTED]
> Sent: Saturday, October 07, 2006 1:25 AM
> To: CF-Talk
> Subject: Re: Java help
>
> Could this be it?
>
> http://forum.java.sun.com/thread.jspa?threadID=736383&messageID=4230346
>
>
> On 10/6/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
> > I should also mention that I tried this as well...
> .
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006
>
>
>
>
>
~|
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:255905
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion SQL question
> I am using ColdFusion MX 7 and a MySQL database. I have a database of surveys > taken with each record having a date that the survey was taken. MySQL and dates are a strange thing. The biggest issue is that dates are treated differently depending on the version of the MySQL server you're working with. If it were up to me I would be using the DateDiff function to get your range, here are some MySQL specific examples: If your starting and ending dates are 05/01/2005 and 05/31/2005 SELECT * FROM Surveys WHERE DateDiff(Surveys.ShopDate, '2005-05-01') >= 0 AND DateDiff(Surveys.ShopDate, '2005-05-31') <= 0 Yes, for those that use MSSQL's DateDiff that's WAY different syntax. According to the docs: DATEDIFF() returns expr1 expr2 expressed as a value in days from one date to the other. expr1 and expr2 are date or date-and-time expressions. Only the date parts of the values are used in the calculation. Now for the downside - DateDiff() and other date functions did not enter the MySQL scene until version 4.1.1 which means you need to make sure your version of MySQL supports the above mentioned code. Hatton ~| 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:255904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion SQL question
On Saturday 07 October 2006 17:55, Christopher Lavie wrote: Have you tried dateCompare() instead of <= ? Also, mySql takes a little different format with the storage of date/time values. It displays DATETIME values in '-MM-DD HH:MM:SS > This probably has a simple, obvious solution, > but it's frustrating the > hell out of me. > > I am using ColdFusion MX 7 and a MySQL > database. I have a database of > surveys taken with each record having a date that the survey was taken. > > I am trying to pull records between two dates. > > This code worked just fine with an Access > database but not with the > MySQL database: > >Session.WhereClause & " AND > ((Survey.ShopDate BETWEEN ## #NewBeginDate# ## AND ## #NewEndDate# ##))"> > > (Later, I apply the Session.WhereClause > variable to the SQL statement.) > > The following code works just fine when I use > it in the database itself > (obviously replacing the variables with actual dates). Unfortunately it > returns no records in my ColdFusion code when I leave off the single > quotes, and it returns a syntax error when I include the quotes. > >Session.WhereClause & " AND > Survey.ShopDate >= '#NewBeginDate#' AND Survey.ShopDate <= '#NewEndDate#' > "> > > I have tried the CreateODBCDateTime function to > no avail. > > Can anybody help me? I'm at my wits end. > > Thanks! > > Chris > > > > > > ~| 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:255903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Output list of fields names from table
On Saturday 07 October 2006 16:34, Dawson, Michael wrote: no records are returned. And as someone else suggested in another thread, you should add the function getBeer(Heineken) to that. ~| 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:255902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion SQL question
This probably has a simple, obvious solution, but it's frustrating the hell out of me. I am using ColdFusion MX 7 and a MySQL database. I have a database of surveys taken with each record having a date that the survey was taken. I am trying to pull records between two dates. This code worked just fine with an Access database but not with the MySQL database: (Later, I apply the Session.WhereClause variable to the SQL statement.) The following code works just fine when I use it in the database itself (obviously replacing the variables with actual dates). Unfortunately it returns no records in my ColdFusion code when I leave off the single quotes, and it returns a syntax error when I include the quotes. = '#NewBeginDate#' AND Survey.ShopDate <= '#NewEndDate#' "> I have tried the CreateODBCDateTime function to no avail. Can anybody help me? I'm at my wits end. Thanks! Chris ~| 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:255901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Output list of fields names from table
I would add "WHERE 1=0" just so no records are returned. M!ke -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 4:14 PM To: CF-Talk Subject: Re: Output list of fields names from table Les Mizzell wrote: > What's the quickest dirtiest way (for testing only) to output all the > field names from a specific table - assuming you've *no* idea what the > field names are to start with and can only get at the table (for the > moment) through a query on a CF page? > SELECT * FROM sometable #thequery.columnlist# ~| 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:255900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Output list of fields names from table
Coldfusion wrote: > Actually I would add TOP 1 to the select statement that way you are not > obtaining All records in a LARGE table. I found that out REAL fast! Well, REAL slow actually Thanks, Les ~| 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:255899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Output list of fields names from table
Actually I would add TOP 1 to the select statement that way you are not obtaining All records in a LARGE table. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 5:14 PM To: CF-Talk Subject: Re: Output list of fields names from table Les Mizzell wrote: > What's the quickest dirtiest way (for testing only) to output all the > field names from a specific table - assuming you've *no* idea what the > field names are to start with and can only get at the table (for the > moment) through a query on a CF page? > SELECT * FROM sometable #thequery.columnlist# ~| 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:255898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Output list of fields names from table
Les Mizzell wrote: > What's the quickest dirtiest way (for testing only) to output all the > field names from a specific table - assuming you've *no* idea what the > field names are to start with and can only get at the table (for the > moment) through a query on a CF page? > SELECT * FROM sometable #thequery.columnlist# ~| 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:255897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Output list of fields names from table
What's the quickest dirtiest way (for testing only) to output all the field names from a specific table - assuming you've *no* idea what the field names are to start with and can only get at the table (for the moment) through a query on a CF page? ~| 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:255896 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?
Following up on this, I was able to set up the mirroring on SQL 2005 between 2 servers using he High Availability mode with a 3rd witness server to provide the automatic failover. The SQL side of things works great. If I take the Primary DB server "DBServer1", offline (by stopping the SQL Server), the "DBServer2" which was the Mirror becomes the primary. The code below also works by automatically contacting the DBServer2 when the DBServer1 can not be reached. However it is a bit slow, because it tries to contact DBServer1 first and then uses DBServer2 - but I think this is because the connection info is not being cached because the connection is being opened and closed and that this may not happen when it is set up as a regular datasource. The only real problem is this; When the DB the was originally the Primary (the one that went down) comes back up, it assumes the role of mirror, and the failover server REMAINS the primary. This is apparently how the mirroring works in SQL Server 2005. The problem with this is two fold. For starters, it means you would need to have a fairly robust mirror, since it may take over as the primary some day. And the bigger problem is that once the first server server comes back on-line and starts actings as the Mirror the code below returns an error because it can contact the first server, but fails when opening the DB because the Mirror DB is inaccessible as it is in RESTORE mode and can not be accessed. It would be nice if once the Original Primary DB Server came back online that it would resume Primary Duties and switch with the Mirror currently acting as the Primary. #con.getWarnings()# Driver Name: #DatabaseMetaData.getDriverName()# Driver Version: #DatabaseMetaData.getDriverVersion()# Database Name:#DatabaseMetaData.getDatabaseProductName()# Database Version: #DatabaseMetaData.getDatabaseProductVersion()# -Original Message- From: blists [mailto:[EMAIL PROTECTED] Sent: October 5, 2006 12:05 PM To: CF-Talk Subject: RE: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror? Hi Dave, Thanks for the feedback, after some more searching last night, I found a thread that showed how to add an alternateServers=(server2:1433) to the connection string which would configure the datasource to automatically contact the second / alternate server is the first was down. http://forums.datadirect.com/ddforums/message.jspa?messageID=3685 Adobe also has an article about this and about how those settings when inputed directly in the datasource config in cfadmin would be lost and need to be manually added to the neo-query.xml file http://www.macromedia.com/go/25b0de5e I was able to add this parameter and have been testing it but am not quite there yet. I don't actually even have two database servers set up yet..so.. I did manage to hack together this code to test the datasource configuration and see if the failover works. This is basically the same code from the article above combined with some insights gained from an adobe article: ColdFusion MX: Creating a pure Java connection to a data source http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19607 #con.getWarnings()# Driver Name: #DatabaseMetaData.getDriverName()# Driver Version: #DatabaseMetaData.getDriverVersion()# Database Name:#DatabaseMetaData.getDatabaseProductName()# Database Version: #DatabaseMetaData.getDatabaseProductVersion()# Error - info below Close Error - info below I'm gonna keep trying.. Blists -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: October 4, 2006 8:37 PM To: CF-Talk Subject: RE: SQl Server 2005 w/ Mirroring. How does CF know when to 'failo ver' to the mirror? > I am just doing some research into this. With SQL Server 2005 > and mirroring, the mirror will automatically take over if the > primary/principle server fails. But if you the datasource > references the principle SQL Servers name, and that server > was down, how would it failover? > > The only thing I can think of is that you may need to setup > two datasources for the principle and mirror and set up a > connection check within the CF application code that checks > the server and changes the #datasource# var used in the app > to the mirror if the principle is down. > > But this seems incorrect, because in which state would we > consider the princible down? And would those states match the > mirrored states? And what about client variable storage, > would that need the same type of thing? Any have a mirrored > SQL Server and coldfusion running together? How do you do it? SQL Server 2005's mirroring is somewhat like log shipping in SQL Server 2000. With that, you'd h
Re: Ajax and CF...*sigh*...again...
>>I don't agree that XML is "too much of a PITA" May be not, but it is not a panacea either. Sometimes, other solutions are many times simpler. Example : instead of using http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:255894 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...
> -Original Message- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 07, 2006 5:28 AM > To: CF-Talk > Subject: Re: Ajax and CF...*sigh*...again... > > Eventually people are going to want to return more than a plain string > or HTML to their page. To do that they will probalby want to use JSON > (assuming XML is too much of PITA, which it is). So then they have to > write code to get their CF data into JSON and back again. In other > words, they'll spend time rewriting the same thing that's been done > multiple times before by people with more experience. I don't agree that XML is "too much of a PITA" - at least not more or less than anything else. JSON is great - but has some marked limitations: it's hard to validate, there's no data typing (no real difference between strings and dates for example), and it's more difficult to deserialize (especially for languages other than JS). XML (depending on the dialect used) addresses most of those complaints at the cost of a (sometimes much) larger packet size and more tedious code - unless you use a pre-built parser. The problem, as I see it, is that many of the libraries out there are "larger" solutions - they often provide "end to end" solutions for problems. For example they might have methods specifically for doing drop-down boxes, or timers, or loading indicators or whatever. This isn't at all "bad"... but for somebody just learning (or wanting more control) they seem large and heavy. They often (almost by necessity) force potentially incompatible methodologies onto the developer. For others this is a complete and utter God-send. They simply use the library/framework as a black-box tool and get their work done. The other extreme is to "do it all yourself". This is definitely much slower, of course, and there definitely is a level of redundancy but the benefits are a much more complete understanding and a toolset that matches your style perfectly (or at least as closely as the underlying technologies allow). Personally I prefer the middle-ground: compact objects/services/components that handle the "hard stuff" but exert very few dictates on the usage. That's were things like pre-built XML/JSON parsers come in. (Here come the plugs!) I prefer, of course, YODEL (my very own XML dialect): http://www.depressedpress.com/Content/Development/YODEL The pre-built parsers try to completely abstract the activity of XML-transfer but tries not to impose any development paradigms. YODEL attempts to address what's "bad" about XML and JSON while still providing flexibility. There are CF and JS parsers but they are connected only by the standard. For making HTTP requests in the browser I use another object I created to do HTTP Request pooling: http://www.depressedpress.com/Content/Development/JavaScript/Extensions/DP_H TTPRequestPool In both these cases I looked for simple, cut-down solutions to do the same jobs... but I couldn't find any. Most people either provide complete frameworks or non-portable "snippets". Again neither of these is bad - both can be insanely useful actually - but I think their's another class of coder that really wants something in-between. 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:255893 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
> > 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:255892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Java help
Bobby,
I think this is what you want:
import java.math.*;
import java.text.*;
import java.util.Locale;
public class BigDecimalFormatTest {
public static void main (String[] args) {
double [] nums = {71.715,71.725,71.735,71.745,71.755,71.765,71.775,71.785,
71.795};
NumberFormat form;
form = NumberFormat.getCurrencyInstance(Locale.US);
for (int i = 0; i < nums.length; ++i) {
BigDecimal theNumber = new BigDecimal (Double.toString(nums[i]));
theNumber = theNumber.setScale(2, RoundingMode.HALF_UP);
System.out.println(form.format(theNumber));
}
}
}
The key here is the double conversion to BigDecimal and setting the rounding
mode to half_up. The reason you weren't getting what you thought you should
is because DecimalFormat uses the half_even rounding mode.
Dina
On 10/7/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> Thanks for the suggestion. I saw that link before but dismissed it for
> some
> reason. I guess I assumed it was doing something else. In any event, I
> just
> tried it and it DID come up with different output but still not what it
> should be. I may very well be using it wrong though. It's probably obvious
> that I'm no Java programmer. I'm basically just taking what I know about
> programming in general and the syntax of JavaScript and doing the best I
> can
> here.
>
> This is what I have from your suggestion and what it displays.
>
> import java.text.*;
> import java.math.BigDecimal;
>
> public class dollarFormattingTest
> {
> public static void main(String[] args)
> {
> DecimalFormat dollarFormat = new DecimalFormat("$0.00");
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.815)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.825)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.835)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.845)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.855)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.865)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.875)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.885)));
> System.out.println(dollarFormat.format(new java.math.BigDecimal(71.895)));
> }
> }
>
>
> This is the output now...
>
> $71.81
> $71.83
> $71.83
> $71.84
> $71.86
> $71.86
> $71.88
> $71.89
> $71.89
>
> That's either extremely weird... or I'm completely missing something
> obvious. :-/
>
>
> -Original Message-
> From: Denny Valliant [mailto:[EMAIL PROTECTED]
> Sent: Saturday, October 07, 2006 1:25 AM
> To: CF-Talk
> Subject: Re: Java help
>
> Could this be it?
>
> http://forum.java.sun.com/thread.jspa?threadID=736383&messageID=4230346
>
>
> On 10/6/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
> > I should also mention that I tried this as well...
> .
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006
>
>
>
>
>
~|
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:255891
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
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: I show up Arial I show up Times 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 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. > > = . > > 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 exhibits strange > > behavior such as extra spaces (which are underlined) magically > > appearing > > before and or after the text. > > > > Example test 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| 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:
RE: Dreamweaver great for CF but is there any WYSIWYG ajax editor?
I doubt that there is an IDE devoted to 'AJAX' since it's basically a recently adapted term for a collection of old JavaScript functions and methods for accomplishing tasks asynchronously. Cutter uncovered a JavaScript IDE that looks promising in the recent thread about favorite add-ons and plug-ins though. I haven't had a chance to put it to the test but it's called Aptana (http://aptana.com/) Apparently it offers hints and help with CSS and HTML but seems to be focused more on JavaScript. If you try it out, feel free to let me know what you think about it. Hopefully, I'll get the chance soon. -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 12:03 PM To: CF-Talk Subject: Dreamweaver great for CF but is there any WYSIWYG ajax editor? Hi everybody: I know it seems a little funny but is there any WYSIWYG Ajax editor? I just want to use some of the functions and I wonder if something like that is out there. I wish something like dreamweaver (as it works for CF very good and it saves my time all the time) was made for AJAX. Thanks Benign ~| 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:255889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dreamweaver great for CF but is there any WYSIWYG ajax editor?
Hi everybody: I know it seems a little funny but is there any WYSIWYG Ajax editor? I just want to use some of the functions and I wonder if something like that is out there. I wish something like dreamweaver (as it works for CF very good and it saves my time all the time) was made for AJAX. Thanks Benign ~| 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:255888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: locking, I think
James, What Free tool from Quest does the same thing as TOAD? I have been a TOAD user for many years and I didn't know that Quest had a free version like Toad. Dave -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 2:32 AM To: CF-Talk Subject: Re: locking, I think That'll work fine. Out of interest, why can't you get TOAD to manage your Oracle DB? Too expensive or some other reason? Because Oracle has a Free tool now that does a lot of the same work. On 10/7/06, daniel kessler <[EMAIL PROTECTED]> wrote: > alright, I'm gonna try to get the number from DUAL and insert that. > > I'd like to try triggers, but the last time I tried to make them, I had problems. We aren't allowed to use a GUI (managing tool) to work with the DB. Admittedly, I was pretty much a complete novice at the time. So when I have time I'd like to try again. > > Thanks for the sequence information. I had once learned that it's its own table but I had forgotten completely. -- 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:255887 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...
Yes, I know - that's my point. On 10/7/06, Snake <[EMAIL PROTECTED]> wrote: > No need to write the code to convert between CF/JSON, it has already been > done, check out http://jehiah.com/projects/cfjson/ > > Russ > > -Original Message- > From: James Holmes [mailto:[EMAIL PROTECTED] > Sent: 07 October 2006 10:28 > To: CF-Talk > Subject: Re: Ajax and CF...*sigh*...again... > > Eventually people are going to want to return more than a plain string or > HTML to their page. To do that they will probalby want to use JSON (assuming > XML is too much of PITA, which it is). So then they have to write code to > get their CF data into JSON and back again. In other words, they'll spend > time rewriting the same thing that's been done multiple times before by > people with more experience. > > The "all frameworks are the devil's work" religion is also a religion. > > On 10/7/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > You can forget about AJAX, CFAJAX and all big theories... > > -- > 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:255886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: removing bad emails from bounced emails and db
Sweet! Glad to be of service. -- Josh - Original Message - From: "Dave Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Friday, October 06, 2006 10:24 PM Subject: Re: removing bad emails from bounced emails and db > what i ended up doing was downloading all the bounces in outlook and > exporting them all to a big csv file. Then I got this > http://www.maxprog.com/EmailExtractor.html and dropped the csv file into > that and it spit out a nice list of emails, then ran them into a list and > thru rays getemail udf and into db then compared them against the mailing > list db and removed any matches. Seems to have worked well. > > Thanks for the suggestion i woulda never thought of it > > > > > > > > > >>Hi Dave, >> >>I should have mentioned I was using Outlook Express. I funneled all the >>emails into an Outlook Express folder I created called "unsubscribe", then >>selected all the emails in that folder and dragged them out of Outlook >>Express into a folder on my desktop. This automatically saved them all as >>separate .eml files, which are just text files containing the email >>source. >>So I didn't really do any exporting as such, just drag and drop. Not sure >>if this will work in plain Outlook or not. >> >>-- Josh >> > > ~| 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:255885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to get MS-Access Table & Column info without cfobject
>>I suspect the fact that it works only on ODBC means it wont work with CFMX, which uses JDBC I have developed a new version with a CFC companion that supports JDBC, and is compataible with the previous version, ie. it creates the same queries. It is not fully tested yet with all imaginable drivers, but so far it woks. The main tag is now called CF_DSinfo and uses an attribute DStype = "ODBC" | "JDBC" If anyone buys the standard version, I will send this new version as a beta test. The new version of CFX_ODBC also has the possibility to compact an ACCESS database if it has an ODBC connection. Also note that, even if you use JDBC in your application, no one prevents you from also defining an ODBC connection to your database in Windows and use CFX_ODBCInfo under CFMX with no problem. The ODBC and JDBC connections can work in parallel. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:255884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How to get MS-Access Table & Column info without cfobject
I suspect the fact that it works only on ODBC means it wont work with CFMX, which uses JDBC Russ -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 07 October 2006 15:32 To: CF-Talk Subject: Re: How to get MS-Access Table & Column info without cfobject >>please tell how to retreive tables list CFX_ODBCinfo will give you all this, and many more: See http://www.cftagstore.com/tags/cfxodbcinfo.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:255883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java help
Thanks for the suggestion. I saw that link before but dismissed it for some
reason. I guess I assumed it was doing something else. In any event, I just
tried it and it DID come up with different output but still not what it
should be. I may very well be using it wrong though. It's probably obvious
that I'm no Java programmer. I'm basically just taking what I know about
programming in general and the syntax of JavaScript and doing the best I can
here.
This is what I have from your suggestion and what it displays.
import java.text.*;
import java.math.BigDecimal;
public class dollarFormattingTest
{
public static void main(String[] args)
{
DecimalFormat dollarFormat = new DecimalFormat("$0.00");
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.815)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.825)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.835)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.845)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.855)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.865)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.875)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.885)));
System.out.println(dollarFormat.format(new java.math.BigDecimal(71.895)));
}
}
This is the output now...
$71.81
$71.83
$71.83
$71.84
$71.86
$71.86
$71.88
$71.89
$71.89
That's either extremely weird... or I'm completely missing something
obvious. :-/
-Original Message-
From: Denny Valliant [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 07, 2006 1:25 AM
To: CF-Talk
Subject: Re: Java help
Could this be it?
http://forum.java.sun.com/thread.jspa?threadID=736383&messageID=4230346
On 10/6/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
> I should also mention that I tried this as well...
.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.13.0/465 - Release Date: 10/6/2006
~|
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:255882
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How to get MS-Access Table & Column info without cfobject
>>please tell how to retreive tables list CFX_ODBCinfo will give you all this, and many more: See http://www.cftagstore.com/tags/cfxodbcinfo.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:255881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regular expressions and bluedragon?
Doug Hyde wrote: > > So, I tried creating a regular expression to remove it and came up with the > following: > > You need REReplace(), not Replace(). 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:255880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Regular expressions and bluedragon?
Hi, I am running bluedragon free edition and I am trying to write a regular expression to remove part of a query string. I grab the query string from cgi.query_string and store it as a variable "location". The substring I would like to remove would always be either "&lang=1" "&lang=2" or "&lang=3" - it could appear without the "&" (as the first element in the query string). So, I tried creating a regular expression to remove it and came up with the following: It does not work. I decided to work in steps and tried this, without worrying about the punctation: So, I tried this: And it worked, but it isn't doing what I want. So it seems other than literal strings (like "lang=") I can't get any regular expression to work. To test, I did the following: It does nothing. Am I doing something wrong? Thanks. Doug ~| 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:255879 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
> cfxpop3 tag and have been fairly happy with the performance > (although the server that sends mail and checks bounces keeps > restarting the cf service and we've yet to pin down the culprit. > Russ, If you need one to help identify your instability, I can provide you with a debug version of CFX_POP3 that would log any exceptions it encounters/creates. 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:255878 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...
No need to write the code to convert between CF/JSON, it has already been done, check out http://jehiah.com/projects/cfjson/ Russ -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 07 October 2006 10:28 To: CF-Talk Subject: Re: Ajax and CF...*sigh*...again... Eventually people are going to want to return more than a plain string or HTML to their page. To do that they will probalby want to use JSON (assuming XML is too much of PITA, which it is). So then they have to write code to get their CF data into JSON and back again. In other words, they'll spend time rewriting the same thing that's been done multiple times before by people with more experience. The "all frameworks are the devil's work" religion is also a religion. On 10/7/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > You can forget about AJAX, CFAJAX and all big theories... -- 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:255877 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
That'll work fine. Out of interest, why can't you get TOAD to manage your Oracle DB? Too expensive or some other reason? Because Oracle has a Free tool now that does a lot of the same work. On 10/7/06, daniel kessler <[EMAIL PROTECTED]> wrote: > alright, I'm gonna try to get the number from DUAL and insert that. > > I'd like to try triggers, but the last time I tried to make them, I had > problems. We aren't allowed to use a GUI (managing tool) to work with the > DB. Admittedly, I was pretty much a complete novice at the time. So when I > have time I'd like to try again. > > Thanks for the sequence information. I had once learned that it's its own > table but I had forgotten completely. -- 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:255876 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...
Eventually people are going to want to return more than a plain string or HTML to their page. To do that they will probalby want to use JSON (assuming XML is too much of PITA, which it is). So then they have to write code to get their CF data into JSON and back again. In other words, they'll spend time rewriting the same thing that's been done multiple times before by people with more experience. The "all frameworks are the devil's work" religion is also a religion. On 10/7/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > You can forget about AJAX, CFAJAX and all big theories... -- 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:255875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to get MS-Access Table & Column info without cfobject
How to list all the table in the MSAccess database.Iam firing query if on access then i am able to get the list of the table but from the vb.net application iam not able to get this as it is diplaying an error "Read Permission not on msysobject" so please tell how to retreive tables list and repair the database from the application Thanks Chetna Sharma Unfortunately, read permissions on table 'MSysObject are not set. > >I can't open the db in either Access97 or Access2000 on WinNT or WinXP >-- hangs on NT, crashes on XP. > >I was able to repair the db successfully, but still can't open it. > >Yet, I can manipulate it with CFMX for any table I can remember. > >Any way to set the MSysObject permissions through an SQL Query? > >TIA > >Dick > >"Part of the inhumanity of the computer is that, >once it is competently programmed and working >smoothly, it is completely honest." - Isaac >Asimov - > >On Monday, October 7, 2002, at 04:36 AM, Craig Dudley 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:255874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
