Manipulate the DPI with cfimage?

2008-01-03 Thread Carsten Klement
Hello,
i use a Linux Server with CF8 an want to read out or manipulate the dpi of 
pictures with cfimage. I have found it only in the function 
ImageGetEXIFMetaData, but not every picture have the Exif Data.

Is it right, that this function is not supported in CF8?

Thanks!
Carsten 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295735
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Andy Matthews
When you're dealing with images for display on computer screens, there's
really no such thing as dpi. It all has to do with the pixel dimensions.

If you have a 1600x1200 image, then it would be 22in x 16in at 72dpi (on a
monitor) or 5in x 4in at 300dpi.




-Original Message-
From: Carsten Klement [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 8:02 AM
To: CF-Talk
Subject: Manipulate the DPI with cfimage?

Hello,
i use a Linux Server with CF8 an want to read out or manipulate the dpi of
pictures with cfimage. I have found it only in the function
ImageGetEXIFMetaData, but not every picture have the Exif Data.

Is it right, that this function is not supported in CF8?

Thanks!
Carsten 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295737
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


OT:Flex Training

2008-01-03 Thread Qasim Rasheed
Sorry for being slightly OT. Does anyone has recommendations for Flex
training with emphasis on using ColdFusion at the back end?

Thanks

-- 
Qasim Rasheed
(IM qasimrasheed AT yahoo, msn or GTalk)


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295738
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: mssql pagination

2008-01-03 Thread Dan G. Switzer, II
Jonathon,

Here's a stored procedure you can use in MSSQL 2k for pagination:

http://blog.pengoworks.com/index.cfm/2006/6/19/MSSQL-2k-Stored-Procedure-for
-Pagination

It doesn't use #temp tables and it will only return the pages of data you're
after. I've used it on tables with several millions of records and had great
success with it.

Also, in SQL Server 2005 you can solve this problem with Common Table
Expressions (CTE)

-Dan

-Original Message-
From: Jonathon Stierman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 6:01 PM
To: CF-Talk
Subject: mssql pagination

I can't imagine I'm the first person to try to do something like this, so
hopefully you guys can give me some insight!  I know this isn't strictly
CF-related -- but I'm hoping some of you have tried to do something like
this in the past.

I'm trying to produce a paginated list of records.  The query I'm working
with has about 2 rows, and I'd rather not force the user to sift
through
all those pages in a single page request.  So I'd like to break it up,
maybe
display 50 records per page.  I'd also prefer not to have the full query
sitting in memory every request.  If I'm only displaying rows 50-100, I
only
want rows 50-100 in the query object.  Using cfloop with startrow and
maxrows won't cut it this time.

Apparently this is super easy in MYSQL using the LIMIT (records), (offset)
clause.

Turns in MSSQL makes things difficult.  A couple sites I hit up showed
examples of using of subqueries and the TOP filter, or (ugh) temporary
tables.  I went with the subquery/TOP approach.  For example, ordering by
dateAdded and wanting to show rows 20-30:

SELECT TOP 10 sampleID
FROM Samples
WHERE 0=0
AND sampleID NOT IN (
   SELECT TOP 20 sampleID
   FROM Samples
   ORDER BY Samples.dateAdded
)
ORDER BY Samples.dateAdded

Grab the first 10 records after eliminating the first 20 records, always
sorting by dateAdded.

But I found it worked sporadically.  Pages 1 and 2 worked fine, displaying
the 1-10 and 11-20 records respectively.  But page 3 gave me some strange
results.  It showed records 14-23 or some other mismatch.  Obviously not
what I was looking for!

After some investigation, I found out my subquery was not returning the
right samples to exlude.  What I haven't been able to figure out is *why*
they are not returning the right subset.  As far as I can tell, the SQL
looks good to me.

So my question to you guys is --

1.  Can you see anything wrong with how I've set up my Query?
2.  How have you dealt with pagination in the past?  Is there an easier
route than what I'm taking now?

PS -- I am running on MSSQL Server 2000 (I have heard they offer an OFFSET
clause in 2005, but sadly, I do not have access to that).

If anyone is interested in seeing some sample data of what I'm working on,
I
put up this HTML page:

http://www.vimm.com/developerTools/sampledata.html

You can see in the All Samples section that records 20-30 should be:
[147,
148, 149, 150, 63, 36, 40, 382, 383, 384].
But the Total Wrapper query returns: [146, 147, 148, 149, 150, 63, 382,
383,
384, 440].
What happened to record 40?  It's row #27 in the All Samples query, but
it's
included in the exclude Nested Subquery that should only be pulling the top
20 results.  How does that happen?

Jonathon





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295736
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF 5 and DAO

2008-01-03 Thread Chad Gray
I am so use to using MX and CFCs that now I have to work on a CF5 server for a 
client and 

Is there a good way of setting up a DAO in CF5 so I can reuse SQL code and not 
have to retype the CFQueryies each time I need them?

Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295739
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


sql question: contains space' '

2008-01-03 Thread morchella
hey guys.
this is a 2 parter.

i have a table i need to fix.  i have no real idea how to do this. the
problem is the Contact filed.

the first several thousand entries combine fnme  lname into this one field
from a xls file.
then maybe 20,000 entries only have a name with a space in the Contact
filed.
then some one caught the error in the xls file  made a tweak to it so the
remainding3k entries are fine again.

so...
Part 1
i need to find out how to do a where statement that looks for a single name
that could be any thing, a null or a single name with a space or any
combinations of space

like 'Joe ',  'Dan ' but NOT 'James Dean'
right now my select to find the problem isn't really working..

SELECT rep_assigned, id, industry, Contact, Address, City, State, Zip
FROMContacts
WHERE (Contact LIKE '') OR (Contact LIKE ' ')

Part 2
then i will need to do a find  update from the xls where Contact is a
partial match  Address is a full match.
this is the part that scares the crap out of me!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295740
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Rick Root
On 1/3/08, Andy Matthews [EMAIL PROTECTED] wrote:
 When you're dealing with images for display on computer screens, there's
 really no such thing as dpi. It all has to do with the pixel dimensions.

I've argued many times myself (as author of ImageCFC) that DPI is
not a function of the image itself, but the meta-data of the image, as
the DPI is *ONLY* used for print.

So unless you're using Coldfusion to send a file to the printer after
manipulating the dpi, there's no point.

that being said.. if you've got a jpeg that has the meta data for DPI,
you could theoretically change the metadata to say that the image is
300 dpi, and when you open it in photoshop, it would be 300 dpi.

But as was said, the DPI has nothing to do with the image itself, so
if you've got an image with no meta data, you'd have to first convert
it to a format that supported image metadata, add thei mage metadata
and set the DPI.

-- 
Rick Root
Coldfusion/Flex Developer needed in Durham, full-time, no
telecommuters.  Please email me!  No third parties.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295741
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT:Flex Training

2008-01-03 Thread Rick Root
On 1/3/08, Qasim Rasheed [EMAIL PROTECTED] wrote:
 Sorry for being slightly OT. Does anyone has recommendations for Flex
 training with emphasis on using ColdFusion at the back end?


Qasim - One of my coworkers took flex training at Figleaf in DC and
found it to be very helpful.  I myself am self-taught which means
I'm undisciplined and not very good =)  But if you're looking to
jump-start your own training, I'd recommend just going through the
Getting Started Tutorials.. they are quite good at teaching the basics
of Flex... and utilize the mailing lists (RDAUG and
[EMAIL PROTECTED]) for assistance.

One tip - if you install Coldfusion Developer edition on your machine
that you'll be training on, install it as a standalone server with the
built-in web server using all the standard ports and paths... you'll
find setting up Flex Builder projects to be much simpler =)

-- 
Rick Root
Coldfusion/Flex Developer needed in Durham, full-time, no
telecommuters.  Please email me!  No third parties.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295742
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 question: contains space' '

2008-01-03 Thread morchella
but what if i want
like '% ';
and
not like '% money'

where money could be any last name or character.

On Jan 3, 2008 10:17 AM, Greg Morphis [EMAIL PROTECTED] wrote:

 the SQL statement like requires a %..
 for example..
 select * from froo where name like 'G%'
 will return all names that starts with G..
 So try something like
 select * from tbl where name like '% ';
 That will catch anything with a trailing space.
 Just a heads up..


 On Jan 3, 2008 9:03 AM, morchella [EMAIL PROTECTED] wrote:
  hey guys.
  this is a 2 parter.
 
  i have a table i need to fix.  i have no real idea how to do this. the
  problem is the Contact filed.
 
  the first several thousand entries combine fnme  lname into this one
 field
  from a xls file.
  then maybe 20,000 entries only have a name with a space in the Contact
  filed.
  then some one caught the error in the xls file  made a tweak to it so
 the
  remainding3k entries are fine again.
 
  so...
  Part 1
  i need to find out how to do a where statement that looks for a single
 name
  that could be any thing, a null or a single name with a space or any
  combinations of space
 
  like 'Joe ',  'Dan ' but NOT 'James Dean'
  right now my select to find the problem isn't really working..
 
  SELECT rep_assigned, id, industry, Contact, Address, City, State,
 Zip
  FROMContacts
  WHERE (Contact LIKE '') OR (Contact LIKE ' ')
 
  Part 2
  then i will need to do a find  update from the xls where Contact is a
  partial match  Address is a full match.
  this is the part that scares the crap out of me!
 
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295744
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: OT:Flex Training

2008-01-03 Thread Chad Gray
I don't know of any training.  I have had to do my own experimentation with the 
help docs and the 'Adobe Flex 2 training from the source' book to figure out 
how to communicate with CFCs and the flash remoting mechanism on the CF server.

http://www.adobe.com/devnet/flex/articles/tfs_excerpts.html

http://www.adobe.com/devnet/flex/data_services.html




-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 9:58 AM
To: CF-Talk
Subject: OT:Flex Training

Sorry for being slightly OT. Does anyone has recommendations for Flex
training with emphasis on using ColdFusion at the back end?

Thanks

-- 
Qasim Rasheed
(IM qasimrasheed AT yahoo, msn or GTalk)




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295745
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 question: contains space' '

2008-01-03 Thread Greg Morphis
the SQL statement like requires a %..
for example..
select * from froo where name like 'G%'
will return all names that starts with G..
So try something like
select * from tbl where name like '% ';
That will catch anything with a trailing space.
Just a heads up..


On Jan 3, 2008 9:03 AM, morchella [EMAIL PROTECTED] wrote:
 hey guys.
 this is a 2 parter.

 i have a table i need to fix.  i have no real idea how to do this. the
 problem is the Contact filed.

 the first several thousand entries combine fnme  lname into this one field
 from a xls file.
 then maybe 20,000 entries only have a name with a space in the Contact
 filed.
 then some one caught the error in the xls file  made a tweak to it so the
 remainding3k entries are fine again.

 so...
 Part 1
 i need to find out how to do a where statement that looks for a single name
 that could be any thing, a null or a single name with a space or any
 combinations of space

 like 'Joe ',  'Dan ' but NOT 'James Dean'
 right now my select to find the problem isn't really working..

 SELECT rep_assigned, id, industry, Contact, Address, City, State, Zip
 FROMContacts
 WHERE (Contact LIKE '') OR (Contact LIKE ' ')

 Part 2
 then i will need to do a find  update from the xls where Contact is a
 partial match  Address is a full match.
 this is the part that scares the crap out of me!


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295743
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 question: contains space' '

2008-01-03 Thread Greg Morphis
'% ' shouldnt return ' money'
it should only return enteries with a trailing space..
for example

create table testtbl ( name varchar2(10));
insert into testtbl values ('Greg ');
insert into testtbl values ('Greg M');
insert into testtbl values ('Greg Mo');
insert into testtbl values ('Gary ');
insert into testtbl values ('Ghetto Fab');

commit;

select * from testtbl where name like '% '


returns only
NAME
'Greg '
'Gary '
(I added quotes so you can see the trailing space)


On Jan 3, 2008 9:21 AM, morchella [EMAIL PROTECTED] wrote:
 but what if i want
 like '% ';
 and
 not like '% money'

 where money could be any last name or character.


 On Jan 3, 2008 10:17 AM, Greg Morphis [EMAIL PROTECTED] wrote:

  the SQL statement like requires a %..
  for example..
  select * from froo where name like 'G%'
  will return all names that starts with G..
  So try something like
  select * from tbl where name like '% ';
  That will catch anything with a trailing space.
  Just a heads up..
 
 
  On Jan 3, 2008 9:03 AM, morchella [EMAIL PROTECTED] wrote:
   hey guys.
   this is a 2 parter.
  
   i have a table i need to fix.  i have no real idea how to do this. the
   problem is the Contact filed.
  
   the first several thousand entries combine fnme  lname into this one
  field
   from a xls file.
   then maybe 20,000 entries only have a name with a space in the Contact
   filed.
   then some one caught the error in the xls file  made a tweak to it so
  the
   remainding3k entries are fine again.
  
   so...
   Part 1
   i need to find out how to do a where statement that looks for a single
  name
   that could be any thing, a null or a single name with a space or any
   combinations of space
  
   like 'Joe ',  'Dan ' but NOT 'James Dean'
   right now my select to find the problem isn't really working..
  
   SELECT rep_assigned, id, industry, Contact, Address, City, State,
  Zip
   FROMContacts
   WHERE (Contact LIKE '') OR (Contact LIKE ' ')
  
   Part 2
   then i will need to do a find  update from the xls where Contact is a
   partial match  Address is a full match.
   this is the part that scares the crap out of me!
  
  
  
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295746
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: mssql pagination

2008-01-03 Thread Jonathon Stierman
Thanks Dan, Adam, and Eric!  

I haven't played around with stored procedures much, so this will give me a
chance to give them a whirl.

As for 2000 being out of date, I hear you there -- I'll have to push to get
the budget for it.  At least now I have some leverage (a problem that can't
easily be fixed otherwise).

Jonathon




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295748
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 question: contains space' '

2008-01-03 Thread Ian Skinner
You may need to get into database character functions.  I believe they 
all have them, but they all implement them slightly differently.  You 
will need to consult appropriate documentation for you database 
management system.

But you should be able to do something like this concept.

SELECT fields
FROM aTable
WHERE right(aField, 1) = ' '

I.E. Select records where the last character of a field is a space.

The purpose of the LIKE operator is to search the entire field for a 
match, and that is not really what you want.  You want to match a 
specific character.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295749
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 question: contains space' '

2008-01-03 Thread Paul Ihrig
just fond out why
man this db is so messed up...

'Joe Garth '


so i would i look for NOT LIKE '% % '


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295750
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 question: contains space' '

2008-01-03 Thread Jim Wright
On 1/3/08, Paul Ihrig [EMAIL PROTECTED] wrote:
 just fond out why
 man this db is so messed up...

 'Joe Garth '


 so i would i look for NOT LIKE '% % '


OR...
ltrim(rtrim(contact)) NOT LIKE '% %'

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295751
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: mssql pagination

2008-01-03 Thread Jim Wright
On 1/2/08, Jonathon Stierman [EMAIL PROTECTED] wrote:
 You can see in the All Samples section that records 20-30 should be: [147,
 148, 149, 150, 63, 36, 40, 382, 383, 384].
 But the Total Wrapper query returns: [146, 147, 148, 149, 150, 63, 382, 383,
 384, 440].
 What happened to record 40?  It's row #27 in the All Samples query, but it's
 included in the exclude Nested Subquery that should only be pulling the top
 20 results.  How does that happen?

Since the sort order you are using (dateAdded) is not unique, it is
probably using some other factor (like a clustered index or record
insertion order) along with dateAdded to sort the records returned.
Use something like this...

SELECT TOP 10 sampleID, dateAdded
FROM Samples a WHERE 0=0 AND a.sampleID
NOT IN ( SELECT TOP 20 b.sampleID FROM Samples b
ORDER BY b.dateAdded ASC,b.currentRow )
ORDER BY a.dateAdded ASC,a.currentRow;

However, I'm guessing that the above will not scale well with a very
large dataset, so something like the SP sent earlier may be a better
solution.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295747
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 question: contains space' '

2008-01-03 Thread Mark Kruger
If what you are trying to  do is eliminate trailing spaces why not just do:

Update contacts set contact = rtrim(ltrim(contact))

 

-Original Message-
From: morchella [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 9:03 AM
To: CF-Talk
Subject: sql question: contains space' '

hey guys.
this is a 2 parter.

i have a table i need to fix.  i have no real idea how to do this. the
problem is the Contact filed.

the first several thousand entries combine fnme  lname into this one field
from a xls file.
then maybe 20,000 entries only have a name with a space in the Contact
filed.
then some one caught the error in the xls file  made a tweak to it so the
remainding3k entries are fine again.

so...
Part 1
i need to find out how to do a where statement that looks for a single name
that could be any thing, a null or a single name with a space or any
combinations of space

like 'Joe ',  'Dan ' but NOT 'James Dean'
right now my select to find the problem isn't really working..

SELECT rep_assigned, id, industry, Contact, Address, City, State, Zip
FROMContacts
WHERE (Contact LIKE '') OR (Contact LIKE ' ')

Part 2
then i will need to do a find  update from the xls where Contact is a
partial match  Address is a full match.
this is the part that scares the crap out of me!




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295753
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 question: contains space' '

2008-01-03 Thread morchella
ok..
thank you!

SELECT id, Contact, Address, City, State, Zip
FROM Leads
WHERE (Contact LIKE '') OR
  (Contact LIKE ' ') OR
  (Contact NOT LIKE '% % ')
AND (LTRIM(RTRIM(Contact)) NOT LIKE '% %')
ORDER BY id

now to fix 20,000+ records!

wonder if it breaks!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295752
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: 2008 conferences of interest

2008-01-03 Thread Sean Corfield
On Jan 2, 2008 6:27 AM, Andy Matthews [EMAIL PROTECTED] wrote:
 I'm really leaning towards this one. I've heard that it's a little more
 in-depth than CFUnited is. Can anyone confirm this?

Well, I'm content chair for cf.Objective() so I may be a little biased
(but I'm also on the advisory board for CFUNITED)...

cf.Objective() is designed to be different from CFUNITED.

CFUNITED has long established itself as the biggest ColdFusion-focused
event in the world. It has the most attendees (over 900 in 2007), the
most speakers, the most tracks, the most sessions and covers the
broadest possible range of topics that might interest CFers. It has a
lot of sponsors and exhibitors. It has something for everyone, from a
full-on bootcamp to frameworks and advanced stuff and it even has
non-CF topics that CFers might find interesting such as a track on
management stuff. CFUNITED has also traditionally had New Atlanta
and Microsoft as sponsors - and speakers - adding to the variety.

http://cfunited.com/go/topics

cf.Objective() is smaller (100 attendees in 2006, 200 attendees in
2007 and we're hoping for 400 in 2008 - a number we probably won't
exceed in future years in order to maintain the small conference
feel and the ease of networking). cf.Objective() has always been
focused just on advanced ColdFusion topics and frameworks, with an
emphasis on Adobe ColdFusion. For example, in 2007 it was *the*
conference to learn about the new features in ColdFusion 8 before its
release. This year cf.Objective() has formal tracks, including an RIA
track (that is still mostly focused on ColdFusion). There are also
some two hour in-depth sessions, three of which are going to be hands
on (Advanced ColdBox, Advanced ColdSpring, Agile Development).

http://cfobjective.com/sessions.cfm

Is there overlap between the two conferences? Well, yes, of course
there is *some* overlap. This year, CFUNITED has a frameworks track
which means it is going to be repeating a number of talks from the
cf.Objective() frameworks track (as well as some new talks you won't
see at cf.Objective()). There are a number of other talks that you
will see at both conferences but when you look the topics published
for both conferences (cf.Objective() has the full schedule posted,
CFUNITED is still selecting more sessions) you might be surprised at
just how little overlap there actually is. Even where you might expect
overlap on tracks (RIA, IDEs/Tools, Deployment/Platform), the
different focus of the conferences shows and there is actually very
little duplication.

I'm attending both conferences - cf.Objective() as an attendee,
CFUNITED as a speaker. If you held a gun to my head and told me to
pick just one CF conference to attend, I would pick cf.Objective()
because I get more out of it as an advanced CFer. If you made me pick
just one conference to attend, regardless of technology, I'd pick SD
West (amazing C++ / Java / C# / design patterns content!). If budget
allowed, I'd definitely attend both cf.Objective() and CFUNITED in
North America. If money was really no object, I'd also attend webDU,
Scotch on the Rocks and MAX Europe!

Hope that helps?

Don't forget the early bird for CFUNITED ends on Saturday - January 5th!
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295754
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 5 and DAO

2008-01-03 Thread Ben Doom
We always used includes, although cfmodule would probably be better.  We 
just broke each inline query out into an include, then called it as 
necessary.

--Ben Doom

Chad Gray wrote:
 I am so use to using MX and CFCs that now I have to work on a CF5 server for 
 a client and 
 
 Is there a good way of setting up a DAO in CF5 so I can reuse SQL code and 
 not have to retype the CFQueryies each time I need them?
 
 Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?
 
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295755
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 question: contains space' '

2008-01-03 Thread morchella
Mark
i am trying to find where only the lastname was added to the field Contact.
some 2000+ records. then do a match on a known field like email or phone 
then update the Contact field with the combined 'fname lname' from a xls
spread sheet.

then after all the names are combined i will just add 2 new fields  do it
the way it should have been done a few years ago!


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295756
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
 I've argued many times myself (as author of ImageCFC) that DPI is
not a function of the image itself, but the meta-data of the image, as
the DPI is *ONLY* used for print.

 or scanning, I couldn't agree more.
The resolution is a quality of instruments, images have no resolution.
 and DPI do not even express a resolution as currently said, but a 
density, anyway... ;-)

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295757
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: 2008 conferences of interest

2008-01-03 Thread Andy Matthews
Thanks for the feedback Shawn. I've put in my request for either WebManiacs
or CFObjective.

CFObjective because it does have a lot to offer for more advanced
developers. WebManiacs because what it offers for the price is too good to
pass up.


andy 

-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 10:29 AM
To: CF-Talk
Subject: Re: 2008 conferences of interest

On Jan 2, 2008 6:27 AM, Andy Matthews [EMAIL PROTECTED] wrote:
 I'm really leaning towards this one. I've heard that it's a little 
 more in-depth than CFUnited is. Can anyone confirm this?

Well, I'm content chair for cf.Objective() so I may be a little biased (but
I'm also on the advisory board for CFUNITED)...

cf.Objective() is designed to be different from CFUNITED.

CFUNITED has long established itself as the biggest ColdFusion-focused event
in the world. It has the most attendees (over 900 in 2007), the most
speakers, the most tracks, the most sessions and covers the broadest
possible range of topics that might interest CFers. It has a lot of sponsors
and exhibitors. It has something for everyone, from a full-on bootcamp to
frameworks and advanced stuff and it even has non-CF topics that CFers might
find interesting such as a track on management stuff. CFUNITED has also
traditionally had New Atlanta and Microsoft as sponsors - and speakers -
adding to the variety.

http://cfunited.com/go/topics

cf.Objective() is smaller (100 attendees in 2006, 200 attendees in
2007 and we're hoping for 400 in 2008 - a number we probably won't exceed in
future years in order to maintain the small conference
feel and the ease of networking). cf.Objective() has always been focused
just on advanced ColdFusion topics and frameworks, with an emphasis on Adobe
ColdFusion. For example, in 2007 it was *the* conference to learn about the
new features in ColdFusion 8 before its release. This year cf.Objective()
has formal tracks, including an RIA track (that is still mostly focused on
ColdFusion). There are also some two hour in-depth sessions, three of which
are going to be hands on (Advanced ColdBox, Advanced ColdSpring, Agile
Development).

http://cfobjective.com/sessions.cfm

Is there overlap between the two conferences? Well, yes, of course there is
*some* overlap. This year, CFUNITED has a frameworks track which means it is
going to be repeating a number of talks from the
cf.Objective() frameworks track (as well as some new talks you won't see at
cf.Objective()). There are a number of other talks that you will see at both
conferences but when you look the topics published for both conferences
(cf.Objective() has the full schedule posted, CFUNITED is still selecting
more sessions) you might be surprised at just how little overlap there
actually is. Even where you might expect overlap on tracks (RIA, IDEs/Tools,
Deployment/Platform), the different focus of the conferences shows and there
is actually very little duplication.

I'm attending both conferences - cf.Objective() as an attendee, CFUNITED as
a speaker. If you held a gun to my head and told me to pick just one CF
conference to attend, I would pick cf.Objective() because I get more out of
it as an advanced CFer. If you made me pick just one conference to attend,
regardless of technology, I'd pick SD West (amazing C++ / Java / C# / design
patterns content!). If budget allowed, I'd definitely attend both
cf.Objective() and CFUNITED in North America. If money was really no object,
I'd also attend webDU, Scotch on the Rocks and MAX Europe!

Hope that helps?

Don't forget the early bird for CFUNITED ends on Saturday - January 5th!
--
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295758
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 5 and DAO

2008-01-03 Thread Greg Luce
Stored procedures. :-)

On Jan 3, 2008 11:33 AM, Ben Doom [EMAIL PROTECTED] wrote:

 We always used includes, although cfmodule would probably be better.  We
 just broke each inline query out into an include, then called it as
 necessary.

 --Ben Doom

 Chad Gray wrote:
  I am so use to using MX and CFCs that now I have to work on a CF5 server
 for a client and
 
  Is there a good way of setting up a DAO in CF5 so I can reuse SQL code
 and not have to retype the CFQueryies each time I need them?
 
  Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?
 
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295759
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Mark Kruger
Claude,

Hmmm Ok this is interesting to me. The argument below seems semantic
So I think I am missing something. I'd like to get my head around this.

Visually DPI represents dots per inch - it's a measure of density in
printing. The higher the DPI the better the quality of printing - right? 

Ok I get that so far

On a monitor the pixel is in one way a measurement of size - as in how
many pixels can I get on the screen. When I look at an image in Fireworks I
get a measurement of pixels at the bottom - 800 by 600 for example - 96
pixels per inch. That's a size measurement. 

But on a screen or inside the file - what is representative of the quality
of the file as it is presented on a monitor... In a JPG file there is a
quality setting for exporting. This setting (as I understand it) is really
related to the lossy compression that is used and dictates how aggressively
the file is to be compressed.

But this is where non-imagy folks like me get confused. I DPI is not the
same as resolution what is the proper term? Is it bit depth or the
number of colors used or what. How do you reference the quality of the image
on the screen without using the word resolution? And if resolution IS the
proper term for the quality of an image, then doesn't it have at least
some correlation to DPI?

In my head a JPG is still a group of pixels - a bitmap... (even though I
know it is more than that).   I envision that the smaller the pixels are and
the closer they are packed tightly together - the better the resolution of
the picture - yes? So in my head, DPI and JPG's pixels have a similar
function. 

I need education on this point. What is the proper way of referring to the
quality of a digital image? Camera's use mega-pixels ... But doesn't
that mean smaller pixels packed closer together? Isn't it analogous to
having 180 pixels per inch instead of just 96 pixels per inch? And doesn't
that translate pretty well into the idea of density? 

Help out a struggling graphically challenged coder :)

-mark

Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com


-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 


 I've argued many times myself (as author of ImageCFC) that DPI is not a
function of the image itself, but the meta-data of the image, as the DPI is
*ONLY* used for print.

. or scanning, I couldn't agree more.
The resolution is a quality of instruments, images have no resolution.
. and DPI do not even express a resolution as currently said, but a
density, anyway... ;-)





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295760
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 5 and DAO

2008-01-03 Thread Chad Gray
I though about that, but I am forced to use Access and too my knowledge you 
can't do Stored Procedures.


-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 11:52 AM
To: CF-Talk
Subject: Re: CF 5 and DAO

Stored procedures. :-)

On Jan 3, 2008 11:33 AM, Ben Doom [EMAIL PROTECTED] wrote:

 We always used includes, although cfmodule would probably be better.  We
 just broke each inline query out into an include, then called it as
 necessary.

 --Ben Doom

 Chad Gray wrote:
  I am so use to using MX and CFCs that now I have to work on a CF5 server
 for a client and
 
  Is there a good way of setting up a DAO in CF5 so I can reuse SQL code
 and not have to retype the CFQueryies each time I need them?
 
  Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?
 
 
 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295761
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 5 and DAO

2008-01-03 Thread Aaron Rouse
We did cfincludes as well and in this same manner.  I have seen where people
have done a cfinclude of a series of UDFs and each UDF is a query more or
less.  Seems like it would not be the most efficient of ways to do things.

On Jan 3, 2008 10:33 AM, Ben Doom [EMAIL PROTECTED] wrote:

 We always used includes, although cfmodule would probably be better.  We
 just broke each inline query out into an include, then called it as
 necessary.

 --Ben Doom

 Chad Gray wrote:
  I am so use to using MX and CFCs that now I have to work on a CF5 server
 for a client and
 
  Is there a good way of setting up a DAO in CF5 so I can reuse SQL code
 and not have to retype the CFQueryies each time I need them?
 
  Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?
 
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295762
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Andy Matthews
Mark...

You're also confusing image quality (compression) with DPI (or pixel
dimensions). At it's heart, a bitmapped (or raster) image, is simply a
series of 1 pixels blocks with specific color assignments. An image doesn't
know what quality (compression) it is. It also doesn't know what resolution
it is. The only thing an image knows about itself, is how many pixels it is
comprised of, and what specific color each of those pixels are.

I think Claude's usage of the term density is an excellent choice. DPI
simply indicates how many pixels are crammed into your unit of measure. If
you REALLY want to start bending your head you'd start talking LPI (lines
per inch), or linescreen. That's usually a better measure of print quality
than is DPI.

Bit depth simply refers to the total number of colors available to an image.
 

-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 11:06 AM
To: CF-Talk
Subject: RE: Manipulate the DPI with cfimage?

Claude,

Hmmm Ok this is interesting to me. The argument below seems semantic
So I think I am missing something. I'd like to get my head around this.

Visually DPI represents dots per inch - it's a measure of density in
printing. The higher the DPI the better the quality of printing - right? 

Ok I get that so far

On a monitor the pixel is in one way a measurement of size - as in how
many pixels can I get on the screen. When I look at an image in Fireworks I
get a measurement of pixels at the bottom - 800 by 600 for example - 96
pixels per inch. That's a size measurement. 

But on a screen or inside the file - what is representative of the quality
of the file as it is presented on a monitor... In a JPG file there is a
quality setting for exporting. This setting (as I understand it) is really
related to the lossy compression that is used and dictates how aggressively
the file is to be compressed.

But this is where non-imagy folks like me get confused. I DPI is not the
same as resolution what is the proper term? Is it bit depth or the
number of colors used or what. How do you reference the quality of the image
on the screen without using the word resolution? And if resolution IS the
proper term for the quality of an image, then doesn't it have at least
some correlation to DPI?

In my head a JPG is still a group of pixels - a bitmap... (even though I
know it is more than that).   I envision that the smaller the pixels are and
the closer they are packed tightly together - the better the resolution of
the picture - yes? So in my head, DPI and JPG's pixels have a similar
function. 

I need education on this point. What is the proper way of referring to the
quality of a digital image? Camera's use mega-pixels ... But doesn't
that mean smaller pixels packed closer together? Isn't it analogous to
having 180 pixels per inch instead of just 96 pixels per inch? And doesn't
that translate pretty well into the idea of density? 

Help out a struggling graphically challenged coder :)

-mark

Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com


-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 


 I've argued many times myself (as author of ImageCFC) that DPI is not a
function of the image itself, but the meta-data of the image, as the DPI is
*ONLY* used for print.

.. or scanning, I couldn't agree more.
The resolution is a quality of instruments, images have no resolution.
.. and DPI do not even express a resolution as currently said, but a
density, anyway... ;-)







~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295764
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 5 and DAO

2008-01-03 Thread Eric Cobb
Actually, you can.  Sort of.

http://intersuite.com/client/index.cfm/2007/11/8/Stupid-MS-Access-Tricks

This was tested on CF 7, but I would think that it would work with CF 5

Hope this helps!

Eric



Chad Gray wrote:
 I though about that, but I am forced to use Access and too my knowledge you 
 can't do Stored Procedures.
 
 
 -Original Message-
 From: Greg Luce [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, January 03, 2008 11:52 AM
 To: CF-Talk
 Subject: Re: CF 5 and DAO
 
 Stored procedures. :-)
 
 On Jan 3, 2008 11:33 AM, Ben Doom [EMAIL PROTECTED] wrote:
 
 We always used includes, although cfmodule would probably be better.  We
 just broke each inline query out into an include, then called it as
 necessary.

 --Ben Doom

 Chad Gray wrote:
 I am so use to using MX and CFCs that now I have to work on a CF5 server
 for a client and
 Is there a good way of setting up a DAO in CF5 so I can reuse SQL code
 and not have to retype the CFQueryies each time I need them?
 Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?




 
 
 
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295763
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 5 and DAO

2008-01-03 Thread Dominic Watson
Personally, I would do it in a way where you can set the name of the
variable that is going to store the query in the calling code. i.e. I would
avoid something like this as it can lead to ambiguity over where the
qry_users variable is set:

cfinclude template=queries/QRY_getusers.cfm
cfloop query=qry_users/cfloop

Somthing like this would be better if you can get it to work in CF5 (works
in CF8):

!--- calling template ---
cfmodule template=queries/QRY_getusers.cfm result=qry_users
dsn=#request.dsn#

!--- module ---
cfparam name=attributes.result default=result type=variableName
cfparam name=attributes.dsn default=foo
cfquery name=qry_user datasource=#attributes.dsn#
 *SELECT* * *FROM* FbUser
/cfquery

cfset caller[attributes.result] = qry_user


Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295766
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Rick Root
On 1/3/08, Mark Kruger [EMAIL PROTECTED] wrote:
 Ok So compression is the best measure of quality?

Yes, in a world of compressed images.

However, your average print shop would rarely used compressed graphics
for printed material.

dots per inch is a reasonable measure of quality when you consider
that you're taking a 2100x1500 image and printing it in the space of
7x5 (300dpi) or 14x10 (150 dpi).. keeping in mind that the
halftone screen used for high quality printing aren't usually much
over 150 lines per inch.

dpi is merely a representation of actual pixels to the space
allotted for printing or viewing those pixels.. so density is a
pretty good word.

For a fun read:

http://en.wikipedia.org/wiki/Halftone

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295767
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: mssql pagination

2008-01-03 Thread Jochem van Dieten
Jonathon Stierman wrote:
 As for 2000 being out of date, I hear you there -- I'll have to push to get
 the budget for it.  At least now I have some leverage (a problem that can't
 easily be fixed otherwise).

How about mainstream support ends this year?
http://support.microsoft.com/lifecycle/search/?sort=PNalpha=sqlx=9y=10

Jochem

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295768
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Mark Kruger
Ok So compression is the best measure of quality? 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 11:24 AM
To: CF-Talk
Subject: RE: Manipulate the DPI with cfimage?

Mark...

You're also confusing image quality (compression) with DPI (or pixel
dimensions). At it's heart, a bitmapped (or raster) image, is simply a
series of 1 pixels blocks with specific color assignments. An image doesn't
know what quality (compression) it is. It also doesn't know what resolution
it is. The only thing an image knows about itself, is how many pixels it is
comprised of, and what specific color each of those pixels are.

I think Claude's usage of the term density is an excellent choice. DPI
simply indicates how many pixels are crammed into your unit of measure. If
you REALLY want to start bending your head you'd start talking LPI (lines
per inch), or linescreen. That's usually a better measure of print quality
than is DPI.

Bit depth simply refers to the total number of colors available to an image.
 

-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 11:06 AM
To: CF-Talk
Subject: RE: Manipulate the DPI with cfimage?

Claude,

Hmmm Ok this is interesting to me. The argument below seems semantic
So I think I am missing something. I'd like to get my head around this.

Visually DPI represents dots per inch - it's a measure of density in
printing. The higher the DPI the better the quality of printing - right? 

Ok I get that so far

On a monitor the pixel is in one way a measurement of size - as in how
many pixels can I get on the screen. When I look at an image in Fireworks I
get a measurement of pixels at the bottom - 800 by 600 for example - 96
pixels per inch. That's a size measurement. 

But on a screen or inside the file - what is representative of the quality
of the file as it is presented on a monitor... In a JPG file there is a
quality setting for exporting. This setting (as I understand it) is really
related to the lossy compression that is used and dictates how aggressively
the file is to be compressed.

But this is where non-imagy folks like me get confused. I DPI is not the
same as resolution what is the proper term? Is it bit depth or the
number of colors used or what. How do you reference the quality of the image
on the screen without using the word resolution? And if resolution IS the
proper term for the quality of an image, then doesn't it have at least
some correlation to DPI?

In my head a JPG is still a group of pixels - a bitmap... (even though I
know it is more than that).   I envision that the smaller the pixels are and
the closer they are packed tightly together - the better the resolution of
the picture - yes? So in my head, DPI and JPG's pixels have a similar
function. 

I need education on this point. What is the proper way of referring to the
quality of a digital image? Camera's use mega-pixels ... But doesn't
that mean smaller pixels packed closer together? Isn't it analogous to
having 180 pixels per inch instead of just 96 pixels per inch? And doesn't
that translate pretty well into the idea of density? 

Help out a struggling graphically challenged coder :)

-mark

Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com


-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 


 I've argued many times myself (as author of ImageCFC) that DPI is not a
function of the image itself, but the meta-data of the image, as the DPI is
*ONLY* used for print.

... or scanning, I couldn't agree more.
The resolution is a quality of instruments, images have no resolution.
... and DPI do not even express a resolution as currently said, but a
density, anyway... ;-)









~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295765
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
 Visually DPI represents dots per inch - it's a measure of density in
printing. The higher the DPI the better the quality of printing - right?

Exact. It's a density. The definition of a resolution is the size of 
the smallest element the instrument can measure,
-- if the instrument sees or measures things -- or generate, if the 
instrument creates things.
It is closely related to the density, of course, but it is not formerly 
the same thing.
Thus, the unit of resolution for instruments like printers, monitors or 
scanners would be in inches,
or 1/1000 In. For instance, a printer with a density of 1000 DPI has a 
density of 1/1000 In.
Note that on some optical instruments like cameras, or human eye, the 
resolution is measured
in angle units. The human eye has a resolution of about 1 minute angle.

 On a monitor the pixel is in one way a measurement of size - as in how
many pixels can I get on the screen.

Ok, now how many pixels, this is called the definition. This is the 
maximum number of different elements
the instrument can measure or genrate (ie: lines in TV transmission)
Of course, the more pixels you have to represent an image, the better 
the quality will be.
Note that:
density = definition / size of the working area
resolution = size of the working area / definition
then density = 1 / resolution

 When I look at an image in Fireworks I
get a measurement of pixels at the bottom - 800 by 600 for example - 96
pixels per inch. That's a size measurement.

For the pixels, yes, but one should never should forget that it is a 
virtual image.
Normally, a virtual object has no size.
Now, if you make a physical representation of your virtual image, it 
becomes a real image,
and its size will be nb.pixels * resolution of the printer,
or nb.pixels / density of the printer.
Talking of pixels per inch in a virtual image just does not make sense.
Where are the inches we are talking about ?

 This setting (as I understand it) is really
related to the lossy compression that is used and dictates how aggressively
the file is to be compressed.

Exact, and it has nothing to do with pixels, or density.

 But this is where non-imagy folks like me get confused. I DPI is not the
same as resolution what is the proper term?

In my book it is density.

  Is it bit depth or the number of colors used or what.

Yes, it is the numbers of bits used to express color, thus the magnitude 
of the numbers that can be used
to express the color. Then one should finally call it the color 
definition.

 How do you reference the quality of the image
on the screen without using the word resolution? And if resolution IS the
proper term for the quality of an image, then doesn't it have at least
some correlation to DPI?

You cannot express the quality in DPI or any other kind of unit.
The quality depends on many factors like the pixel definition, the color 
definition, the compression level
the precision and fidelity of the display or printing equipment, and 
finally, the quality of your own eye !
The overall quality is a chain of elements, DPI is only one of them.

 I need education on this point. What is the proper way of referring 
to the
quality of a digital image?

There is no really a unit to measure quality, one only can take in 
account the quality of each
element in the chain.
Just like in a old analogic sound equipment, the overall quality depends 
on many element, from
the musical instrument to the auditor's ear, including the recording 
system, the vinyl record pressing,
the piezzo pick-up, the speaker system, etc.


-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295769
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
 I think Claude's usage of the term density is an excellent choice.

Humbly, it's not really my choice, this is the way I learned it when I 
was student in physics.
I just hope the translation is correct, in French, we call it densité ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295770
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Manipulate the DPI with cfimage?

2008-01-03 Thread Claude Schneegans
 Ok So compression is the best measure of quality?

 except that it is a reverse measure: the higher the compression is, 
the lower the quality.
Some softwares use % compression, some others % in quality.
A 10% compressed image is equivalent to a 90% quality, etc.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295771
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Struct Issue

2008-01-03 Thread Adkins, Randy
I have a CFC which returns a query based listing of error messages. Here
is the CFC: 


cffunction name=getMessage access=public description=Returns
either a structure containing all system messages, or an array
containing one or more messages corresponding to the messageID passed in
from the system messages structure
cfargument name=messageID type=string required=false
default=
!--- Return all messages ---
cfif messageID eq  or messageID eq all
cfreturn session.systemMessageStruct
cfelse
!--- Return messages based on incoming argument ---
cfquery name=variables.qMessages dbtype=query
select * from session.systemMessageStruct where
message_id = '#arguments.messageID#'
/cfquery
cfreturn variables.qMessages
/cfif
/cffunction


Here is the call to the getMessages function: (Yes it is set as an
object)
cfset messageStruct =
application.msgMgr.getMessage(attributes.messageId)

Now I can check it this way but at times it returns an error on the
initial startup:
cfif messageStruct.recordcount
 ... blah blah
/cfif


Here is the error returned:
---
You have attempted to dereference a scalar variable of type class
java.lang.String as a structure with members.


TO clarify somethings:
Yes the basic structure is created as a query (dynamic query)
onApplicationStart:
cfset variables.systemMessageStruct =
queryNew('message_id,message,messageType,IconSize')
!--- Copy Dynamic Query to Session Scope ---
cfset session.systemMessageStruct = variables.systemMessageStruct


Any idea why it would return the error or a way I can prevent it? I can
not use IsStruct since it is a query rather than a true structure?



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295772
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: mssql pagination

2008-01-03 Thread Jonathon Stierman
That will definitely help my footing as well!  

Arguably even more than my fringe case that I couldn't work around. ;)

Thanks, Jochem!

Jonathon



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295773
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CF 4.5 MS Access Data Source Name

2008-01-03 Thread Ian Skinner
Flash from the past.  On a CF 4.5 (Hopefully soon to be replaced) server 
does one need to do something special to set up an Access data source 
name?  I'm looking at the data sources panels in the Administrator and 
I do not see any options for Access.  I see Merant drives for 
dBase/FoxPro, IBM DB2/6000 Informix 7.x/9/x, Sybase 11, OpenIngres 1.s, 
OpenIngres 2.x Oracle 7, Oracle 8, Text and MS SQL Server. 

It have been a very long time since I have had to work with this version 
and I do not recall what has to be done to create a DSN.  Is it 
mandatory to create a Windows ODBC entry first.  I am hoping not, since 
I do not have access to the box, just to CF administrator through from a 
remote client browser session.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295774
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 4.5 MS Access Data Source Name

2008-01-03 Thread Ian Skinner
Now that I wake up a bit and realize that this 4.5 server I am looking 
it is a Unix box.  I probably figured out why I am not seeing the built 
in Microsoft Access database driver as well as that no matter how much 
access I have to the box, I am unlikely to find a Microsoft ODBC 
administration tool.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295775
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Struct Issue

2008-01-03 Thread Rick Root
On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote:

 Here is the call to the getMessages function: (Yes it is set as an
 object)
 cfset messageStruct =
 application.msgMgr.getMessage(attributes.messageId)

 Now I can check it this way but at times it returns an error on the
 initial startup:
 cfif messageStruct.recordcount
  ... blah blah
 /cfif


 Here is the error returned:
 ---
 You have attempted to dereference a scalar variable of type class
 java.lang.String as a structure with members.

This is pretty easy.  It means that SOMEHOW that variable
messageStruct contains a string and not a structure.

Based on the code in the function, it's hard to imagine how this
happens or why it would contain an string.

One thing you might do:

cfif not isQuery(messageStruct)
 --- send yourself an error message, report an error, etc ---
cfelseif messageStruct.recordcount
  ... blah blah
/cfif

 TO clarify somethings:
 Yes the basic structure is created as a query (dynamic query)
 onApplicationStart:
 cfset variables.systemMessageStruct =
 queryNew('message_id,message,messageType,IconSize')
 !--- Copy Dynamic Query to Session Scope ---
 cfset session.systemMessageStruct = variables.systemMessageStruct

I've had issues in the past with creating queries dynamically and not
adding rows... unfortunately I can't remember exactly what those
issues were.

 Any idea why it would return the error or a way I can prevent it? I can
 not use IsStruct since it is a query rather than a true structure?

How about isQuery() =)

It might also be wise to either change the variable name to NOT refer
to struct, since it isn't a struct, *OR* convert the query returned -
since you're expecting only one row anyway to a real structure.

cflib has a nice QueryRowToStruct() function.

It's more efficient to access structure elements than elements of a
single-record query anyway so if you're accessing the contents of the
struct a lot, it makes sense to convert it to a REAL struct.

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295776
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Struct Issue

2008-01-03 Thread Josh Nathanson
 Any idea why it would return the error or a way I can prevent it? I can
 not use IsStruct since it is a query rather than a true structure?

It looks like a string is being returned rather than a query as you are 
expecting.

You'll need to trace back through your code and figure out where it's 
getting a string from.  It looks like it might be getting it from 
session.systemMessageStruct.

-- Josh 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295778
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Struct Issue

2008-01-03 Thread Adkins, Randy
Thanks. Sometimes the query will have multiple messages to be displayed
with different messageIDs. Thus the reason I considered the dynamic
query method :-)

I will try isQuery but I think I have found that for some reason the
initial call is not creating the dynamic query itself.

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 2:23 PM
To: CF-Talk
Subject: Re: Struct Issue

On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote:

 Here is the call to the getMessages function: (Yes it is set as an
 object)
 cfset messageStruct =
 application.msgMgr.getMessage(attributes.messageId)

 Now I can check it this way but at times it returns an error on the
 initial startup:
 cfif messageStruct.recordcount
  ... blah blah
 /cfif


 Here is the error returned:
 ---
 You have attempted to dereference a scalar variable of type class
 java.lang.String as a structure with members.

This is pretty easy.  It means that SOMEHOW that variable
messageStruct contains a string and not a structure.

Based on the code in the function, it's hard to imagine how this
happens or why it would contain an string.

One thing you might do:

cfif not isQuery(messageStruct)
 --- send yourself an error message, report an error, etc ---
cfelseif messageStruct.recordcount
  ... blah blah
/cfif

 TO clarify somethings:
 Yes the basic structure is created as a query (dynamic query)
 onApplicationStart:
 cfset variables.systemMessageStruct =
 queryNew('message_id,message,messageType,IconSize')
 !--- Copy Dynamic Query to Session Scope ---
 cfset session.systemMessageStruct = variables.systemMessageStruct

I've had issues in the past with creating queries dynamically and not
adding rows... unfortunately I can't remember exactly what those
issues were.

 Any idea why it would return the error or a way I can prevent it? I
can
 not use IsStruct since it is a query rather than a true structure?

How about isQuery() =)

It might also be wise to either change the variable name to NOT refer
to struct, since it isn't a struct, *OR* convert the query returned -
since you're expecting only one row anyway to a real structure.

cflib has a nice QueryRowToStruct() function.

It's more efficient to access structure elements than elements of a
single-record query anyway so if you're accessing the contents of the
struct a lot, it makes sense to convert it to a REAL struct.

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295777
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Struct Issue

2008-01-03 Thread Rick Root
On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote:
 Thanks. Sometimes the query will have multiple messages to be displayed
 with different messageIDs. Thus the reason I considered the dynamic
 query method :-)

 I will try isQuery but I think I have found that for some reason the
 initial call is not creating the dynamic query itself.

If it wasn't created at all, you'd get a not defined error.

For example, cfdump var=#foobar.bar# when foobar is not defined
rsults in this error:  Element BAR is undefined in FOOBAR.

So in your case, messageStrucct *IS* being defined somewhere but it's
being defined as a string somehow.

-- 
Rick Root
Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
www.opensourcecf.com

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295779
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Struct Issue

2008-01-03 Thread Brian Kotek
Just a note that your method does not return a struct or an array, which is
what your description attribute says. It returns a struct or a query.

Also, you might want to consider refactoring this into two methods, because
having it sometimes return a query and other times return a struct will
probably end up causing you big headaches. Either that, or refactor it so
that it always returns the same type of value (or example, an array of one
or more messages).

On Jan 3, 2008 2:38 PM, Rick Root [EMAIL PROTECTED] wrote:

 On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote:
  Thanks. Sometimes the query will have multiple messages to be displayed
  with different messageIDs. Thus the reason I considered the dynamic
  query method :-)
 
  I will try isQuery but I think I have found that for some reason the
  initial call is not creating the dynamic query itself.

 If it wasn't created at all, you'd get a not defined error.

 For example, cfdump var=#foobar.bar# when foobar is not defined
 rsults in this error:  Element BAR is undefined in FOOBAR.

 So in your case, messageStrucct *IS* being defined somewhere but it's
 being defined as a string somehow.

 --
 Rick Root
 Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
 www.opensourcecf.com

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295781
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: onApplicationStart

2008-01-03 Thread Brian Kotek
You can just call onApplicationStart() again, but be aware that it won't be
thread safe as it is when the application starts up.

On Jan 3, 2008 3:01 PM, Adkins, Randy [EMAIL PROTECTED] wrote:

 Question:
 When using the onApplicationStart within an Application.cfc, lets say I
 wanted to restart the Application to pickup some changes.
 Now I know you can cycle the CF Services but I do not have that access
 to the server.

 What is another way besides creating a temp file to explicitly reset
 those variables?
 Is there a way to make the Application expire and restart (sort of
 speak)?





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295782
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: onApplicationStart

2008-01-03 Thread Michael Dinowitz
You can have a cfif looking for a url variable such as reset. Inside the
CFIF you can recall the onapplicationstart method
cfif structkeyexists(url, 'reset')
   cfset onapplicationstart()
/cfif

Personally, I'd go for a separate reset page. Why have a CFIF if it will
rarely, if ever used.

On Jan 3, 2008 3:01 PM, Adkins, Randy [EMAIL PROTECTED] wrote:

 Question:
 When using the onApplicationStart within an Application.cfc, lets say I
 wanted to restart the Application to pickup some changes.
 Now I know you can cycle the CF Services but I do not have that access
 to the server.

 What is another way besides creating a temp file to explicitly reset
 those variables?
 Is there a way to make the Application expire and restart (sort of
 speak)?





 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295786
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Struct Issue

2008-01-03 Thread Adkins, Randy
Sorry I did not update the description. It now will always return a
Query :-)

I did find out that onApplicationStart it was not re-initiaing the
application.msgMgr object for the new functions and still trying to use
the old setup which did create a basic variable rather than a query.

All is good now :-)

-Original Message-
From: Brian Kotek [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 3:06 PM
To: CF-Talk
Subject: Re: Struct Issue

Just a note that your method does not return a struct or an array, which
is
what your description attribute says. It returns a struct or a query.

Also, you might want to consider refactoring this into two methods,
because
having it sometimes return a query and other times return a struct will
probably end up causing you big headaches. Either that, or refactor it
so
that it always returns the same type of value (or example, an array of
one
or more messages).

On Jan 3, 2008 2:38 PM, Rick Root [EMAIL PROTECTED] wrote:

 On 1/3/08, Adkins, Randy [EMAIL PROTECTED] wrote:
  Thanks. Sometimes the query will have multiple messages to be
displayed
  with different messageIDs. Thus the reason I considered the dynamic
  query method :-)
 
  I will try isQuery but I think I have found that for some reason the
  initial call is not creating the dynamic query itself.

 If it wasn't created at all, you'd get a not defined error.

 For example, cfdump var=#foobar.bar# when foobar is not defined
 rsults in this error:  Element BAR is undefined in FOOBAR.

 So in your case, messageStrucct *IS* being defined somewhere but it's
 being defined as a string somehow.

 --
 Rick Root
 Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at
 www.opensourcecf.com

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295785
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: onApplicationStart

2008-01-03 Thread Will Tomlinson
What is another way besides creating a temp file to explicitly reset
those variables?
Is there a way to make the Application expire and restart (sort of
speak)?

Here's what I use:

cffunction name=onRequestStart returntype=void output=false
  cfif structKeyExists(url,reinitApp)
cflock scope=application type=exclusive timeout=5 
throwontimeout=true
  cfset onApplicationStart()
/cflock
  /cfif
/cffunction

Then add ?reinitApp=1 in any url to restart the app

Will 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295784
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: onApplicationStart

2008-01-03 Thread Barney Boisvert
No, not really.  I put all my initialization logic in a separate
method of Application.cfc, and then invoke that method from
onRequestStart if certain conditions are met (usually the presence of
a reloadApplication URL param that is set to a specific value).

Note that this doesn't expire the application, it just reinitializes
it.  So any pre-existing application variables will continue to exist
unless your initialization explicitly overwrites or deletes them.

cheers,
barneyb

On Jan 3, 2008 12:01 PM, Adkins, Randy [EMAIL PROTECTED] wrote:
 Question:
 When using the onApplicationStart within an Application.cfc, lets say I
 wanted to restart the Application to pickup some changes.
 Now I know you can cycle the CF Services but I do not have that access
 to the server.

 What is another way besides creating a temp file to explicitly reset
 those variables?
 Is there a way to make the Application expire and restart (sort of
 speak)?



-- 
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295783
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: onApplicationStart

2008-01-03 Thread Adkins, Randy
Sweet.. thanks

-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 3:00 PM
To: CF-Talk
Subject: Re: onApplicationStart

What is another way besides creating a temp file to explicitly reset
those variables?
Is there a way to make the Application expire and restart (sort of
speak)?

Here's what I use:

cffunction name=onRequestStart returntype=void output=false
  cfif structKeyExists(url,reinitApp)
cflock scope=application type=exclusive timeout=5
throwontimeout=true
  cfset onApplicationStart()
/cflock
  /cfif
/cffunction

Then add ?reinitApp=1 in any url to restart the app

Will 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295787
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: onApplicationStart

2008-01-03 Thread Mike Chabot
You can try putting most of your OnApplicationStart code into
cfinclude files and call those cfinclude file in some other reload
page. This has an advantage over calling OnApplicationStart again if
there are some things that OnApplicationStart does that you don't want
to do a second time, such as reinitializing a list of logged-in users.
If you just want to reload some application-scope variables or some
cached functions, calling the entire OnApplicationStart again might be
overkill. Another way to do this is to put conditionals in the
OnApplicationStart block that only reinitializes certain sections
depending on the input variables (commonly a URL variable).

My guess is that you don't actually want to expire the application in
order to reload a few variables. If you do want to expire the
application, there are ways to do this. Setting the application
timeout = 0 is one way.

-Mike Chabot

On Jan 3, 2008 3:06 PM, Brian Kotek [EMAIL PROTECTED] wrote:
 You can just call onApplicationStart() again, but be aware that it won't be
 thread safe as it is when the application starts up.

 On Jan 3, 2008 3:01 PM, Adkins, Randy [EMAIL PROTECTED] wrote:

  Question:
  When using the onApplicationStart within an Application.cfc, lets say I
  wanted to restart the Application to pickup some changes.
  Now I know you can cycle the CF Services but I do not have that access
  to the server.
 
  What is another way besides creating a temp file to explicitly reset
  those variables?
  Is there a way to make the Application expire and restart (sort of
  speak)?
 
 
 
 
 
 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295789
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: onApplicationStart

2008-01-03 Thread Raymond Camden
Just note though - that lock isn't really necessary if all you are
doing is setting a bunch of simple values in the app scope. And by
simple I mean things that dont' need to be single threaded. A CFC
stored in the app scope is most likely fine as well.

On Jan 3, 2008 1:59 PM, Will Tomlinson [EMAIL PROTECTED] wrote:
 What is another way besides creating a temp file to explicitly reset
 those variables?
 Is there a way to make the Application expire and restart (sort of
 speak)?

 Here's what I use:

 cffunction name=onRequestStart returntype=void output=false
   cfif structKeyExists(url,reinitApp)
 cflock scope=application type=exclusive timeout=5 
 throwontimeout=true
   cfset onApplicationStart()
 /cflock
   /cfif
 /cffunction

 Then add ?reinitApp=1 in any url to restart the app

 Will

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295790
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: onApplicationStart

2008-01-03 Thread Ian Skinner
You can also temporiarly set the session timeout to 0 or some other 
really short time, let the application expire, then return the timeout 
to the desired value.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295788
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


onApplicationStart

2008-01-03 Thread Adkins, Randy
Question:
When using the onApplicationStart within an Application.cfc, lets say I
wanted to restart the Application to pickup some changes.
Now I know you can cycle the CF Services but I do not have that access
to the server.

What is another way besides creating a temp file to explicitly reset
those variables?
Is there a way to make the Application expire and restart (sort of
speak)?





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295780
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Manipulate the DPI with cfimage?

2008-01-03 Thread Mark Kruger
Claude,

Thanks for an enlightening foray into the world of graphics. I especially
like the part about a virtual object having no size..fascinating. It made me
think to myself... If a virtual tree falls in the woods... (ha).

In any case, excellent stuff. I feel edicated enough to be able to say now
with certainty that I know next to nothing about working with graphics :)

-Mark  

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 

 Visually DPI represents dots per inch - it's a measure of density in
printing. The higher the DPI the better the quality of printing - right?

Exact. It's a density. The definition of a resolution is the size of the
smallest element the instrument can measure,
-- if the instrument sees or measures things -- or generate, if the
instrument creates things.
It is closely related to the density, of course, but it is not formerly the
same thing.
Thus, the unit of resolution for instruments like printers, monitors or
scanners would be in inches, or 1/1000 In. For instance, a printer with a
density of 1000 DPI has a density of 1/1000 In.
Note that on some optical instruments like cameras, or human eye, the
resolution is measured in angle units. The human eye has a resolution of
about 1 minute angle.

 On a monitor the pixel is in one way a measurement of size - as in how
many pixels can I get on the screen.

Ok, now how many pixels, this is called the definition. This is the
maximum number of different elements the instrument can measure or genrate
(ie: lines in TV transmission) Of course, the more pixels you have to
represent an image, the better the quality will be.
Note that:
density = definition / size of the working area resolution = size of the
working area / definition then density = 1 / resolution

 When I look at an image in Fireworks I get a measurement of pixels at the
bottom - 800 by 600 for example - 96 pixels per inch. That's a size
measurement.

For the pixels, yes, but one should never should forget that it is a virtual
image.
Normally, a virtual object has no size.
Now, if you make a physical representation of your virtual image, it becomes
a real image, and its size will be nb.pixels * resolution of the printer, or
nb.pixels / density of the printer.
Talking of pixels per inch in a virtual image just does not make sense.
Where are the inches we are talking about ?

 This setting (as I understand it) is really related to the lossy
compression that is used and dictates how aggressively the file is to be
compressed.

Exact, and it has nothing to do with pixels, or density.

 But this is where non-imagy folks like me get confused. I DPI is not the
same as resolution what is the proper term?

In my book it is density.

  Is it bit depth or the number of colors used or what.

Yes, it is the numbers of bits used to express color, thus the magnitude of
the numbers that can be used to express the color. Then one should finally
call it the color definition.

 How do you reference the quality of the image on the screen without using
the word resolution? And if resolution IS the proper term for the
quality of an image, then doesn't it have at least some correlation to
DPI?

You cannot express the quality in DPI or any other kind of unit.
The quality depends on many factors like the pixel definition, the color
definition, the compression level the precision and fidelity of the display
or printing equipment, and finally, the quality of your own eye !
The overall quality is a chain of elements, DPI is only one of them.

 I need education on this point. What is the proper way of referring to
the quality of a digital image?

There is no really a unit to measure quality, one only can take in account
the quality of each element in the chain.
Just like in a old analogic sound equipment, the overall quality depends on
many element, from the musical instrument to the auditor's ear, including
the recording system, the vinyl record pressing, the piezzo pick-up, the
speaker system, etc.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295791
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Exception thrown and not caught - is back

2008-01-03 Thread Dustin M. Snell
Hello CF-Talk,

 

When I try to implement the following tutorial I get the dreaded error
Exception Thrown and Not Caught in IE. Quite a few people in the comments
seem to have the same problem - anyone happen to know what causes this for
this example?

 

http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Rel
ated-Selects

 

-Dustin

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Exception thrown and not caught - is back

2008-01-03 Thread Dustin Snell [Network Automation]
I recall my question. I found I had not blocked content for .cfc requests in
my OnRequentEnd. Sorry to clog the tubes with this.

-Original Message-
From: Dustin M. Snell [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 03, 2008 12:46 PM
To: CF-Talk
Subject: Exception thrown and not caught - is back

Hello CF-Talk,

 

When I try to implement the following tutorial I get the dreaded error
Exception Thrown and Not Caught in IE. Quite a few people in the comments
seem to have the same problem - anyone happen to know what causes this for
this example?

 

http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Rel
ated-Selects

 

-Dustin

 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295794
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


OT: Admin SQL Server from Linux

2008-01-03 Thread Bryan Stevenson
Hey All,

Tossed Windows recently for Ubuntulooking for a Linux alternative to 
MS SQL Server Enterprise Manager.

Any ideas?

I have VirtualBox installed with Win XP Pro virtualized with itso I 
can install Ent Mngr in there if I must (or possibly using the WINE 
emulator)but I'd rather use something meant to run in Linux.

TIA

Cheers

-- 

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295793
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT: Admin SQL Server from Linux

2008-01-03 Thread Jordan Michaels
Hey Bryan,

In the past I've used Aqua Data Studio from my linux desktops to work 
with MS SQL Server. It's a pretty nice product with a lot of features. 
It's written in Java which gives it the platform independence.

http://www.aquafold.com/

I'm sure there are other options available, but that's what I found when 
I needed it.

Grats on Ubuntu by the way. I've been meaning to swap out my SuSE 
workstations for Ubuntu but just haven't had the time yet. I like Ubuntu 
a whole lot and have been running it on my home machine for quite some time.

Hope this helps!

Warm regards,
Jordan Michaels
Vivio Technologies


Bryan Stevenson wrote:
 Hey All,
 
 Tossed Windows recently for Ubuntulooking for a Linux alternative to 
 MS SQL Server Enterprise Manager.
 
 Any ideas?
 
 I have VirtualBox installed with Win XP Pro virtualized with itso I 
 can install Ent Mngr in there if I must (or possibly using the WINE 
 emulator)but I'd rather use something meant to run in Linux.
 
 TIA
 
 Cheers
 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295795
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


PDF merge works once, then fails

2008-01-03 Thread Paul Malan
I am trying to merge two separate PDF files into a single two-page file.  I'm 
doing this as part of a loop of 125 records.  And I'm losing my mind.

The cfpdf merge works one time--the first time--and then returns 
NullPointerException.  It doesn't matter which record I handle first--if I 
start at record 1, record 2 fails.  If I start at record 2 it works but record 
3 fails.  If I start at record 50 it works but record 51 fails, and on and on.

What would cause a nullpointerexception in this case?  My code is obviously 
checking out--it does what it should the first time--and I have no idea what to 
try next.

I'm puzzled.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295796
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT: Admin SQL Server from Linux

2008-01-03 Thread Bryan Stevenson
Hey Jordan,

Thanks for the linkI'll check that out.

Worst case is I'll remote desktop via SSH to one of our Win 2k3 servers 
that has SQL Server and Ent. Mngr installed ;-)

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
 
Notice:
This message, including any attachments, is confidential and may contain
information that is privileged or exempt from disclosure. It is intended
only for the person to whom it is addressed unless expressly authorized
otherwise by the sender. If you are not an authorized recipient, please
notify the sender immediately and permanently destroy all copies of this
message and attachments.



Jordan Michaels wrote:
 Hey Bryan,

 In the past I've used Aqua Data Studio from my linux desktops to work 
 with MS SQL Server. It's a pretty nice product with a lot of features. 
 It's written in Java which gives it the platform independence.

 http://www.aquafold.com/

 I'm sure there are other options available, but that's what I found when 
 I needed it.

 Grats on Ubuntu by the way. I've been meaning to swap out my SuSE 
 workstations for Ubuntu but just haven't had the time yet. I like Ubuntu 
 a whole lot and have been running it on my home machine for quite some time.

 Hope this helps!

 Warm regards,
 Jordan Michaels
 Vivio Technologies


 Bryan Stevenson wrote:
   
 Hey All,

 Tossed Windows recently for Ubuntulooking for a Linux alternative to 
 MS SQL Server Enterprise Manager.

 Any ideas?

 I have VirtualBox installed with Win XP Pro virtualized with itso I 
 can install Ent Mngr in there if I must (or possibly using the WINE 
 emulator)but I'd rather use something meant to run in Linux.

 TIA

 Cheers

 

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295797
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: PDF merge works once, then fails

2008-01-03 Thread Paul Malan
Okay, I think there is a bug using cfpdfparam nested within cfpdf 
action=merge.  I pulled the cfpdfparams out, opting instead for a 
comma-separated list in the Source attribute, and it works.

This works: 
cfpdf action=merge   
source=#expandPath('.')#\pdf\tmpStub.pdf,#expandPath('.')#\pdf\tmpACH.pdf 
destination=#expandPath('.')#\pdf\tmpCombined.pdf overwrite=yes

Null pointer after a single iteration:
cfpdf action=merge destination=#expandPath('.')#\pdf\tmpCombined.pdf 
overwrite=yes
cfpdfparam source=#expandPath('.')#\pdf\tmpStub.pdf
cfpdfparam source=#expandPath('.')#\pdf\tmpACH.pdf
/cfpdf 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295798
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Using message bounces to manage email list?

2008-01-03 Thread Pete Ruckelshaus
Hi,

I have developed an email newsletter application for one of my clients (a
local bike shop).  They have nearly 5,000 email addresses in the database,
and we are using a shared server with crystaltech.  I have created an
interface that allows them to remove bounced email addresses from the
database, but it is a manual process.  Knowing that cfmail has a failto
attribute, I was wondering if anyone has done what I am thinking of
doing...namely, create a script that monitors the failto email address, and
then uses cfpop to grab messages, then parse those messages for the bounced
email addresses, and then delete them automatically from the database.  Has
anyone done that?  I guess my main question is how to grab the failed email
addresses from the bounced emails?

Thanks,

Pete


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295799
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: onApplicationStart

2008-01-03 Thread Sean Corfield
On Jan 3, 2008 12:24 PM, Raymond Camden [EMAIL PROTECTED] wrote:
 Just note though - that lock isn't really necessary if all you are
 doing is setting a bunch of simple values in the app scope. And by
 simple I mean things that dont' need to be single threaded. A CFC
 stored in the app scope is most likely fine as well.

Careful! That's not necessarily true if there are multiple variables
and the integrity of the code relies on them not being set
inconsistently. In other words, race condition *can* still apply here
depending on how atomic the initialization code is...

As for the CFC, if you have init code like this:

application.someVar = createObject(component,MyThing);
application.someVar.someMethod(42);

then that may well not be safe either - in particular if someMethod
is actually init! - because the application code may depend on
someVar being in at least the state that someMethod() puts it in (and
other requests could access application.someVar after the
createObject() but before the someMethod() call).

A safer way to do that initialization is:

var someVar = createObject(component,MyThing);
someVar.someMethod(42);
application.someVar = someVar;

i.e., fully initialize the component before placing it in application scope.
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: 2008 conferences of interest

2008-01-03 Thread Sean Corfield
On Jan 3, 2008 8:42 AM, Andy Matthews [EMAIL PROTECTED] wrote:
 CFObjective because it does have a lot to offer for more advanced
 developers. WebManiacs because what it offers for the price is too good to
 pass up.

If you make it to cf.Objective(), say Hi! :)

I can't go to WebManiacs due to a scheduling conflict (with a cat
show). I was asked to speak but had to turn them down :(
-- 
Sean A Corfield -- (904) 302-SEAN
An Architect's View -- http://corfield.org/

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295801
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 5 and DAO

2008-01-03 Thread s. isaac dealey
 I am so use to using MX and CFCs that now I have to work on a CF5
 server for a client and 
 
 Is there a good way of setting up a DAO in CF5 so I can reuse SQL
 code and not have to retype the CFQueryies each time I need them?
 
 Should I use CFModule?  CFInclude?  A custom tag CF_ProductDAO?

Before I offer my thoughts on the actual question, I just wanted to stop
real briefly and mention, because it seemed like you got a couple responses
from folks who may not have been using ColdFusion since as far back as
ColdFusion 5 (or were distracted and didn't notice this was a CF5
question or remember offhand what CF5 supported). 

The cffunction tag was added in ColdFusion version 6. Prior to 6,
versions 5 and 5.5 (iirc), UDFs couldn't include any tags because they
had to be declared entirely in cfscript and there's never been any way
to embed tags in cfscript. So the suggestion of using UDF's is moot
(although I remember really *wanting* to do that in CF5). :) 

I actually had at the time created the first version of the SQL
abstraction layer that's in the onTap framework on ColdFusion 5 using
cfmodule. Though it was way more complicated than you likely need for
your purposes. That being said, you may find it easier to use custom
tags if you have access to the custom tags directory -- which in the
past I had always avoided like the plague, but given that if/when you
upgrade it will probably be to ColdFusion 8 where you can assign the
custom tag diretory in-application, the upgrade plan then makes that
transition easier. Using cf_productDAO for example would be a bit
easier to find if you needed to perform a multi-file search in your code,
than would be cf_module template=../productDAO.cfm. It's also fewer
keystrokes, which is another bonus. If/when you upgrade, you can then
rewrite the custom tags internally to use CFC-based DAO's, but in the
interrim, the custom tag syntax should make your work a bit less tedious
and give you a bit of flexibility to do things like sub-tags if you
found yourself in a situation where you were having difficulty creating
an elegant way of getting argument data into a method. 

I might do something like this internally within the DAO tag: 

cfparam name=attributes.method type=string
cfset here = getDirectoryFromPath(getCurrentTemplatePath())

cfif fileExists(here  productdao/  attributes.method  .cfm
  cfinclude template=#attributes.method#.cfm
/cfif

cfif structKeyExists(variables,result)
  cfparam name=attributes.return type=string default=
  cfif len(trim(attributes.return))
cfset caller[attributes.return] = variables.result
  /cfif
/cfif

The idea behind this structure is to give you a consistent interface for
the methods. Each method has its own template and you'll know that
whatever it is you need to return goes in the variables.result variable
within that template and will then be returned by the custom tag, so you
don't have to keep rewriting the code that returns the result variable. 

anyway, that's my take,
hth,

ike

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295802
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Using message bounces to manage email list?

2008-01-03 Thread J.J. Merrick
Pete,

I wrote a blog post a while back with a way to do this:

http://jeremiahx.com/2007/08/12/how-to-email-bounce-management/

Basically you put an ID of your user inside of the failto so it would be

failto=[EMAIL PROTECTED]

Create a catchall on the bounces.mydomain.com domain and then parse
the email address. This way you know exactly who the user is in your
database just in case the email is forwarded and the bounce message
you get back contains an email address that is not in your database.

J.J.

On 1/3/08, Pete Ruckelshaus [EMAIL PROTECTED] wrote:
 Hi,

 I have developed an email newsletter application for one of my clients (a
 local bike shop).  They have nearly 5,000 email addresses in the database,
 and we are using a shared server with crystaltech.  I have created an
 interface that allows them to remove bounced email addresses from the
 database, but it is a manual process.  Knowing that cfmail has a failto
 attribute, I was wondering if anyone has done what I am thinking of
 doing...namely, create a script that monitors the failto email address, and
 then uses cfpop to grab messages, then parse those messages for the bounced
 email addresses, and then delete them automatically from the database.  Has
 anyone done that?  I guess my main question is how to grab the failed email
 addresses from the bounced emails?

 Thanks,

 Pete


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295804
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Using message bounces to manage email list?

2008-01-03 Thread Dave l
i do that on a site.

first thing is that a lot of crystaltech's servers are on spam lists so I would 
check your server to see.


just set up the failto address and run a scheduled task to check it and run 
cfpoop to check it but you need to be sure to check the header and body content 
for the bounces because some providers do different things. What I do is just 
check for email addresses and there should be 2, the one that bounced and the 
one that is the failto. I grab those and put them in a temp table and loop 
through the emails, when its done looping i compare the bounced ones with the 
mailing list and if there is a match it deletes it.

The big problem with this though is that cfpop takes FOREVER to do this and it 
can time out. 

This site gets about 10,000 bounces every broadcast and it takes weeks to get 
through them, this summer we are changing it up and bought an email checker 
that grabs all the email addresses from that email acount and spits them out 
into a list then they can take the list and upload it and it will run and 
delete all the matches and only takes about a minutes to do it all.



Hi,

I have developed an email newsletter application for one of my clients (a
local bike shop).  They have nearly 5,000 email addresses in the database,
and we are using a shared server with crystaltech.  I have created an
interface that allows them to remove bounced email addresses from the
database, but it is a manual process.  Knowing that cfmail has a failto
attribute, I was wondering if anyone has done what I am thinking of
doing...namely, create a script that monitors the failto email address, and
then uses cfpop to grab messages, then parse those messages for the bounced
email addresses, and then delete them automatically from the database.  Has
anyone done that?  I guess my main question is how to grab the failed email
addresses from the bounced emails?

Thanks,

Pete 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4