Re: CFMail Sanity Check - Where's the Macromedia rep

2004-07-04 Thread Matt Robertson
> Well, that's good to hear. I hope spamcop is included in that.

Yes, and downgraded accordingly. Spamcop was once golden, then based
on some rather draconian behavior (like blacklisting a domain merely
mentioned in an email's text... The U.S. D.O.T. got listed for awhile
on spamcop, for example, as a GEICO spam listed auto recalls from
DOT.gov in its spammage)  a lot of admins went from trusting them
implicity to not at all.  Based on the list traffic I subscribe to
they seem to have cleaned up to the point where they're back on the
'useful' list, but nothing like their original sainted-mother status. 
Since I have moved exclusively to Bayesian filtering during this
period blacklists are something I only read about.

 
> -good to know, thanks. But you see then the characteristics of cfmail DO contribute to
> a spam score, as missing headers - I think - are noted on many spam tests. 

Yes indeed.  I suppose you could argue that this is part of why there
is a cfmailparam tag... so that coders can write a proper email
message... and it should not be so that people think cfmail alone will
do the whole job.  Blame MM for not getting the word out on that
score.

>>This is exactly what I was getting at above. Why in the world does
CFMX not include them then???

Cuz its the job of cfmailparam, and its up to you to figure this out
:-(  See above.  Bad karma.

> > How can it be detected if CF places the header properly, and its a
> > valid value?
> 
> I mean that things like a fake but correct Outlook mailer ID are detected because there can be several checks and if they all don't match perfectly it is noted as forged, which is a death sentence. 

Yup.  Duplicate headers are bad.  Pretending to be Outlook is muy mas bad.

 
> >>If on the other hand you had a sender of [EMAIL PROTECTED]
> > and the reply-to was [EMAIL PROTECTED] then yes, that would be a giant red
> > flag.
> -yes, I have been doing that out of necessity. Can't tell how bad the effect is, but a few bounces. Maybe others are tossed. Others go through fine. But I need to change that.

Ouch.  As I'm sure you know you get a spanking for doing that.  You
may have a good reason but the environment of today says you can't go
there.

thx for the css tips.  Always looking for the grail there.

-- 
--Matt Robertson--
MSB Designs, Inc.
mysecretbase.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




[Reply To] RE: Homesite+ snippets question

2004-07-04 Thread Seamus Campbell
Yes - I know that - but there seems to be no way to add a new  
snippets folder at the top level ie NOT under an already existing  
snippet folder

Seamus

 You wrote 
Right click in the window. :-)
>>
>> 
>>
>>Also, if you have other CF developers, the shared snippets  
feature is cool
>>
>> 
>>
>>  _  
>>
>>From: Seamus Campbell [mailto:[EMAIL PROTECTED] 
>>Sent: Monday, 5 July 2004 2:05 p.m.
>>To: CF-Talk
>>Subject: Homesite+ snippets question
>>
>> 
>>
>>Hi
>>
>>I've just got Homesite+.
>>
>>I cannot see a way to add a new folder in the top level in  
>>snippets.
>>
>>I can only add a new folder within another folder.
>>
>>Help please - this is really annoying me
>>
>>Seamus
>>
>>Seamus Campbell   Boldacious WebDesign
>>http://www.boldacious.com      [EMAIL PROTECTED]
>>ph 02 6297 4883  mob 0410 609 267
>>
>>  _  
>>
>>
>>
>>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Homesite+ snippets question

2004-07-04 Thread Matthew Walker
Right click in the window. :-)

Also, if you have other CF developers, the shared snippets feature is cool

  _  

From: Seamus Campbell [mailto:[EMAIL PROTECTED] 
Sent: Monday, 5 July 2004 2:05 p.m.
To: CF-Talk
Subject: Homesite+ snippets question

Hi

I've just got Homesite+.

I cannot see a way to add a new folder in the top level in  
snippets.

I can only add a new folder within another folder.

Help please - this is really annoying me

Seamus

Seamus Campbell   Boldacious WebDesign
http://www.boldacious.com      [EMAIL PROTECTED]
ph 02 6297 4883  mob 0410 609 267

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: CFMail Sanity Check - Where's the Macromedia rep

2004-07-04 Thread stylo stylo
> >Having run mail servers and bought/used
> various server-level antispam products, I haven't seen anything that
> biases against CF

Well, that's good to hear. I hope spamcop is included in that.

>>My CF 6.1 does not place a message ID or a content-type (just checked). 
>>Your ISP is propping up CF and thats fine, but I would
> caution that you can't count on that.
-good to know, thanks. But you see then the characteristics of cfmail DO contribute to a spam score, as missing headers - I think - are noted on many spam tests. This is exactly what I was getting at above. Why in the world does CFMX not include them then??? Maybe you've had few problems as you are fixing Macromedia's mistakes? -Or maybe there's a good explanation from MM as to why? I don't know, but that is why I say that MM needs to look at it seriously and write something up about it. It's a major concern. One less CFC article; one (and a first) cfmail and spam article.

> How can it be detected if CF places the header properly, and its a
> valid value?

I mean that things like a fake but correct Outlook mailer ID are detected because there can be several checks and if they all don't match perfectly it is noted as forged, which is a death sentence. That's why I am very wary of using any spammer tricks. Finding out the real problem and MM's fixing it is better.

>>If on the other hand you had a sender of [EMAIL PROTECTED]
> and the reply-to was [EMAIL PROTECTED] then yes, that would be a giant red
> flag.
-yes, I have been doing that out of necessity. Can't tell how bad the effect is, but a few bounces. Maybe others are tossed. Others go through fine. But I need to change that.

> > BTW, you should not use external css in an email. 
> Odd as after a LOT of trial and error we found that an external style
> sheet, linked back to the original web site, was the least
> failure-prone option.  

I put my real css block at the bottom of the email within the content div I'm styling. Basing styles on body doesn't work and css can be stripped out if in the head.

See this article and especially the forum responses with tips:

http://alistapart.com/articles/cssemail/

 "After a couple of rounds, I moved forward with embedded styles. This turned out to be my first step to success. (In further support of embedded styles, it is important to note that AOL versions 6.0+ will reject any email linking to external style sheets. Yes: reject, bounce, slam the door in your virtual face.)"

Also worth noting on topic that css cuts down on spam flags. Nice bonus!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Homesite+ snippets question

2004-07-04 Thread Seamus Campbell
Hi

I've just got Homesite+.

I cannot see a way to add a new folder in the top level in  
snippets.

I can only add a new folder within another folder.

Help please - this is really annoying me

Seamus

Seamus Campbell   Boldacious WebDesign
http://www.boldacious.com      [EMAIL PROTECTED]
ph 02 6297 4883  mob 0410 609 267
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: CFX_ConsoleCommand and CFX_Execute

2004-07-04 Thread Lewis Sellers
At 12:07 PM 6/2/2004, you wrote:
>Your install them as CFX custom tags.
>
>They do come with the DLL. you need.
>
>If you mail me off list I can send you an Updated DLL what will allow you to
>get Output 1& 2 out in the return.

Pardon?

>Cheers
>Mr Kev McCabe

>I'm trying to find an alternative to  (which doesn't work
>well with some commands, I've found), and I'm now looking at
>CFX_ConsoleCommand and CFX_Execute (both at
>http://www.intrafoundation.com/coldfusion.html).
>
>Two questions: How do these tags differ, and what do I do with the
>downloads? It looks like they're in C++ source code, which I don't
>know how to configure and compile, etc. Is this really what I'm
>expected to do? Can anyone compile these for me and send me the dll,
>or is that not even possible? Any tips?
>
>Thanks,
>Jamie

I wrote both of the said tags. What happened is I ended up creating a 
series of about half a dozen similar tags a few years back -- one after 
another. Each one a new, improved and *cough* better version that the one 
before. CFX_Execute was the last one created in that series, and not 
surprisingly, I consider all the ones that came before it as deprecated.

I believe I created an updated version of CFX_EXECUTE tag just a month or 
two ago per someone's request one weekend. Spent a few hours debugging a 
few outstanding issues with it. I don't recall whether I uploaded it before 
the server the site is on went all unstable or not though. Hmm.

CFX_Execute was created, FYI, to replace CFEXECUTE (or add the feature to 
earlier versions of CF that didn't have it in the first place.)

As Kev said, the DLL's *should* be in the zip itself already (though they 
may be down in a folder called "Release". Don't recall exactly.) If they're 
not there, email me, and I'll send you a copy asap. :)

And yes, I know -- the reply is a little late. Just now getting to the 
backlog of email.

--min
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: beta fckeditor out

2004-07-04 Thread Peter Tilbrook
Um, I am running WinXp SP2 RC2 and it doesn't block Active X (or Flash) - it
is just a LOT more wary about executing stuff than WinXP SP1.

 
So far it seems to be pretty good.
Peter Tilbrook
Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com
 
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
E-mail: [EMAIL PROTECTED] 

  _  

From: Michael Kear [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 4 July 2004 11:58 PM
To: CF-Talk
Subject: RE: beta fckeditor out

Thanks Kay,    it's amazing how frequently our paths cross on the net. 

I've looked at XStandard one, and it uses an ACTIVEX control which means it
will fail to work when WinXPPro SP2 comes out in a few weeks, just like all
flash will fail.  All ActiveX controls will fail unless they are from
Microsoft, as I understand it,  or have I got the wrong idea with that? 

And Massimo Foti's WYSIWYG at cfmentor.com is by far the most promising. It
runs as a coldfusion custom tag, (or cfmodule if you prefer) but it only
works on IE6+.   If you have mozilla users or netscape users you're stuffed.
And it would be good to be able to offer a choice of styles from the site's
style sheet instead of giving them the raw styling commands. Instead of
Bold, Underline, Italics etc, I'd like to have a drop down that lets me use
the styles as in the style sheet (i.e. "headline", "byline", "story body",
"story teaser" etc)    But within those limitations, I guess it qualifies
Kay, so I have to change my statement to "I have a list of one".

Cheers

Mike Kear

Windsor, NSW, Australia

AFP Webworks

http://afpwebworks.com

  _  

From: Kay Smoljak [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 4 July 2004 11:29 PM
To: CF-Talk
Subject: Re: beta fckeditor out

Michael Kear <[EMAIL PROTECTED]> wrote:
> I'm still looking for a choice of WYSIWYG editors that will produce valid
> XHTML.  Up till now I have a list of zero.

http://www.xstandard.com/
http://www.cfmentor.com/code/index.cfm?action="">

:)

-- 
Kay Smoljak
http://kay.smoljak.com 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Havent seen this error before...

2004-07-04 Thread Cutter (CF-Talk)
I am now getting an odd error:

Error Executing Database Query.
Unknown Types value

The error occurred in 
/home/httpd/[omitted]/system/cfcomponents/com/[omitted]/boutique/category.cfc: 
line 43
Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205
Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114
Called from 
/home/httpd/[omitted]/system/cfcomponents/com/[omitted]/boutique/category.cfc: 
line 43
Called from /home/httpd/[omitted]/secure/editor/_cat.cfm: line 205
Called from /home/httpd/[omitted]/secure/editor/main.cfm: line 114

41 :
42 :   
returntype="boolean">
43 : 
44 :   update	tblboutcat2
45 :   set		txtBoutCat = 
value="#instance.category#" null="#yesnoformat(not 
len(trim(instance.category)))#">,
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: beta fckeditor out

2004-07-04 Thread Jochem van Dieten
Claude Schneegans wrote:
>> It's actually got some features in mozilla/gecko that aren't available
>> in IE, like splitting table cells with the mouse,
> 
> One could do this easily with IE as well.
> The trouble with Mozilla it finding where it is documented...

In the source of course :-)

Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: beta fckeditor out

2004-07-04 Thread Claude Schneegans
>>It's actually got some features in mozilla/gecko that aren't available
in IE, like splitting table cells with the mouse,

One could do this easily with IE as well.
The trouble with Mozilla it finding where it is documented...

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




SOT: How to organize projects in Eclipse

2004-07-04 Thread Dick Applebaum
I would appreciate it if some of you experienced Eclipse users would 
give me some advice on how to  organize folders/files/projects under 
eclipse.

Because of its Java orientation, Java-language projects appear to be 
treated in a special way that does not apply to other languages:

I am used to structuring my CF/ASP/JSP/Perl/PHP code something like:

ClientA_Project
---Admin
-Application.cfm or equivalent
-DB Creation & Maintenance
Source Data
Create/Populate/Convert Programs & CFCs
-Validation Testing
Semi-Automatic Validation programs & CFCs
Source Data
Results Data
---Support
--Flash fla
--OSA scripts
--Java source
---www (in sub folders as necessary)
--Application.cfm or equivalent
--Production Programs and CFC's
--Style Sheets
--_javascript_ source
--images
--Flash,swf
--Java applets
   *
   *
   *
ClientB_Project
   *
   *
   *

Then I have a series of non-client or project related folders such as

Examples
myCFMXapps
myJSPapps
myJavaapps
myPearlapps
CustomTags
UtilityPrograms

I have no problem putting a program, regardless of language, in any 
directory or subdirectory

With eclipse, it doesn't appear that I have that flexibility.  To gain 
many of the benefits, Java programs must be in a Java Project which is 
created at the highest eclipse dir level

What if I have a project for a client that is mostly CFML, but does 
contain a few Java (or other language) programs -- it doesn't seem 
logical to promote these project parts to a top-level eclipse Java 
project?

Some of my utility programs include parts written in several languages, 
it makes sense to keep these all together in a sub-folder, rather than 
promote the Java piece to a high-level Java project, or even promote 
the sub-folder to a Java-Project?

How do others who use eclipse, Java, CF and other languages organize 
their files?

TIA

Dick

"Arguments are to be avoided; they are always vulgar and often 
convincing."
- Oscar Wilde -
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Testing for existence of a directory

2004-07-04 Thread Mark Leder
Didn't think to look at the functions.
I must be brain dead today.

 
Thanks, Mark 

  _  

From: Paul Vernon [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 04, 2004 2:07 PM
To: CF-Talk
Subject: RE: Testing for existence of a directory


     


Paul 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Date/Time format problem

2004-07-04 Thread Andrew Grosset
Found the problem: use "CF_SQL_Timestamp" instead of "CF_SQL_Date"...in cfqueryparam:



any other suggestions welcome, Andrew.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Displaying Results in Columns

2004-07-04 Thread Charlie Griefer
Hi Jillian:

The tutorials use the currentRow variable to determine where to end the
current row and create the new row.  When you're grouping, you (as you
realize) can't use the currentRow var since it's not going to be
incremental anymore.  What you'd need to do is initialize a variable to
0, and manually increment it for each iteration of the .  Use
that var MOD 2 as opposed to currentRow MOD 2 and you should be fine.

Something like:







 
 
  
  
    
  
  #foo.data#
  
   
   
  
   
  
 





The above code uses the variables.endrow variable in place of where you
would 'normally' use queryname.currentrow in 'non-grouped' output.

Hope that helps (or at the very least, doesn't confuse the issue worse)
:)

Charlie

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 04, 2004 11:10 AM
To: CF-Talk
Subject: RE: Displaying Results in Columns

Charlie,

 
Thank you for the links... but I'm still stuck.  I understand completely
how to sort the results into columns --except that I've got a cfoutput
group going on in my results.  I can't figure out how to look at the
results 'as a whole'.

 
Any tips? Something simple I'm just not seeing?

 
--
Jillian

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: July 4, 2004 11:06 AM
To: CF-Talk
Subject: RE: Displaying Results in Columns

http://tutorial140.easycfm.com/
http://tutorial141.easycfm.com/

Either of those should help (the second one goes a bit further towards
maintaining 'proper' HTML) :)

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 04, 2004 9:35 AM
To: CF-Talk
Subject: Displaying Results in Columns

I'm hoping somebody out there can help.  I need to display these results
in two columns (currently just displaying in one).  


password="#db_password#"> SELECT * FROM users WHERE dealership =
#form.dealership# ORDER BY department 


#department#



#first_name#




Thanks!

--
Jillian 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Displaying Results in Columns

2004-07-04 Thread Jillian Carroll
Charlie,

 
Thank you for the links... but I'm still stuck.  I understand completely how
to sort the results into columns --except that I've got a cfoutput group
going on in my results.  I can't figure out how to look at the results 'as a
whole'.

 
Any tips? Something simple I'm just not seeing?

 
--
Jillian

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: July 4, 2004 11:06 AM
To: CF-Talk
Subject: RE: Displaying Results in Columns

http://tutorial140.easycfm.com/
http://tutorial141.easycfm.com/

Either of those should help (the second one goes a bit further towards
maintaining 'proper' HTML) :)

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 04, 2004 9:35 AM
To: CF-Talk
Subject: Displaying Results in Columns

I'm hoping somebody out there can help.  I need to display these results
in two columns (currently just displaying in one).  


password="#db_password#">
SELECT *
FROM users
WHERE dealership = #form.dealership#
ORDER BY
department



#department#



#first_name#




Thanks!

--
Jillian 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Testing for existence of a directory

2004-07-04 Thread Paul Vernon

     


Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Testing for existence of a directory

2004-07-04 Thread Mark Leder
I want to create a directory on the fly.

I'm intending to use 
using a memberName (easy).

However, I can't figure out how to test for the existence of a directory by
that same name.
The cfdirectory commands that I see will list the contents WITHIN a
directory, not the directory / folder name itself.

Is there something else I should be using?

Thanks, Mark
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Date/Time format problem

2004-07-04 Thread Andrew Grosset
I'm trying to input a date and time into a SQL 2000 database. 
The date is correctly updated but the time is always set to zeros.
How do I get the time value (1 sec before midnight) to be updated?





 UPDATE client1
 SET paidDate = ,
	    sub_period = #sub_period#
    WHERE ID=#form.ID#


thanks, Andrew.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Displaying Results in Columns

2004-07-04 Thread Charlie Griefer
http://tutorial140.easycfm.com/
http://tutorial141.easycfm.com/

Either of those should help (the second one goes a bit further towards
maintaining 'proper' HTML) :)

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 04, 2004 9:35 AM
To: CF-Talk
Subject: Displaying Results in Columns

I'm hoping somebody out there can help.  I need to display these results
in two columns (currently just displaying in one).  


password="#db_password#">
SELECT 	*
FROM 		users
WHERE		dealership = #form.dealership#
ORDER BY
		department



	#department#

	
	
		#first_name#
	
	


Thanks!

--
Jillian
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Displaying Results in Columns

2004-07-04 Thread Jillian Carroll
I'm hoping somebody out there can help.  I need to display these results in
two columns (currently just displaying in one).  


password="#db_password#">
SELECT 	*
FROM 		users
WHERE		dealership = #form.dealership#
ORDER BY
		department



	#department#

	
	
		#first_name#
	
	


Thanks!

--
Jillian
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Updating multiple records

2004-07-04 Thread Mark Leder
Thanks, Frank.
So simple, yet worked like a charm.
Sometimes the easiest stuff is what I get tripped up on.

Thanks, Mark 

  _  

From: Frank Mamone [mailto:[EMAIL PROTECTED] 
Sent: Sunday, July 04, 2004 12:17 PM
To: CF-Talk
Subject: Re: Updating multiple records

Mark,

Try this:





UPDATE myTable

SET controlID = '#createUUID()#'

WHERE memberID = #memberID#





-Frank

- Original Message -
From: Mark Leder <[EMAIL PROTECTED]>
Date: Sun, 4 Jul 2004 11:39:25 -0400
Subject: Updating multiple records
To: CF-Talk <[EMAIL PROTECTED]>

Hi all,

I have a SQL 2000 db with about 3400 records, which I upsized from MSAccess.

Each record has a unique memberID (1,2,3, and so on, from Access).  I need

to insert (in a new field) a UUID into each of the first 3300 records (the

newer ones already have it).  How would I go about doing it?



UPDATE myTable

SET controlID = '#createUUID()#'

WHERE memberID = ??? (this would Increment the memberID by one, I

guess, from 1 through 3300) 



Thanks, Mark 
  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Updating multiple records

2004-07-04 Thread Frank Mamone
Mark,

Try this:





	UPDATE myTable

	SET controlID = '#createUUID()#'

	WHERE memberID = #memberID#





-Frank

- Original Message -
From: Mark Leder <[EMAIL PROTECTED]>
Date: Sun, 4 Jul 2004 11:39:25 -0400
Subject: Updating multiple records
To: CF-Talk <[EMAIL PROTECTED]>

Hi all,

I have a SQL 2000 db with about 3400 records, which I upsized from MSAccess.

Each record has a unique memberID (1,2,3, and so on, from Access).  I need

to insert (in a new field) a UUID into each of the first 3300 records (the

newer ones already have it).  How would I go about doing it?



	UPDATE myTable

	SET controlID = '#createUUID()#'

	WHERE memberID = ??? (this would Increment the memberID by one, I

guess, from 1 through 3300)	



Thanks, Mark
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Updating multiple records

2004-07-04 Thread Mark Leder
Hi all,

I have a SQL 2000 db with about 3400 records, which I upsized from MSAccess.
Each record has a unique memberID (1,2,3, and so on, from Access).  I need
to insert (in a new field) a UUID into each of the first 3300 records (the
newer ones already have it).  How would I go about doing it?


	UPDATE myTable
	SET controlID = '#createUUID()#'
	WHERE memberID = ??? (this would Increment the memberID by one, I
guess, from 1 through 3300)	


Thanks, Mark
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Insert row into middle of existing query

2004-07-04 Thread Gaulin, Mark
Does cf's "query of query" support sql "union"?  If so you could probably use that to create a new query from the old one that had the new record sorted to the correct position (assuming you could define the sort order using the fields in the query).  Then put the new query into your session variable.  This is pretty much the same as copying the query by hand but hopefuly it could be done with less code (but probably not faster in execution time, if that matters to you).



From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Fri 7/2/2004 2:37 PM
To: CF-Talk
Subject: RE: Insert row into middle of existing query

You'd probably have to copy the query object to another object and move
all of the rows that are after the row you're wanting to add down 1
space and insert the row you want above.  I don't think there's any
automatic way to do it.  You'd basically be looping over the whole
query.

John 

-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 02, 2004 2:30 PM
To: CF-Talk
Subject: Insert row into middle of existing query

After a database insert, I would like to update the cached query
(session
scope) instead of going back to the database and repeating the query.
The main problem is that the order of the query matters since I am using
the group attribute of cfoutput. The query needs to be ordered by date.
The QueryAddRow function can add a row to the end of the query, which
means I need to take the extra step of reording the query by date. When
I try to reorder the query using a QoQ with an order by clause, I get
the error:

"Error casting an object of type to an incompatible type. This usually
indicates a programming error in Java, although it could also mean you
have tried to use a foreign object in a different way than it was
designed. "

 SELECT * FROM
this.active.qDailyData ORDER BY ActivityDate 

So, is there any way to efficiently add a new row to a specific point in
the middle of an existing query?

Thank you,
Mike Chabot 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: beta fckeditor out

2004-07-04 Thread Rick Root
Michael Kear wrote:

> FCKEditor is one I've used - shows a lot of promise.  But does it produce
> correct XHTML?  (i.e. lower case tags, correct line breaks with the close
> slash <.br /> etc)  The last few versions haven't.  In fact it's changed
> valid XHTML into invalid by changing all the case characters to upper case.

It generally doesn't write the code, most of that is built into the 
browser.. so it generated whatever code IE wanted to write, in most c ases.

  - Rick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: beta fckeditor out

2004-07-04 Thread Kay Smoljak
On Sun, 4 Jul 2004 23:58:13 +1000, Michael Kear <[EMAIL PROTECTED]> wrote:
> Thanks Kay,    it's amazing how frequently our paths cross on the net.
Yeah, that means we must both be MAJOR nerds :)

> I've looked at XStandard one, and it uses an ACTIVEX control which means it
> will fail to work when WinXPPro SP2 comes out in a few weeks, just like all
> flash will fail.  All ActiveX controls will fail unless they are from
> Microsoft, as I understand it,  or have I got the wrong idea with that?

I don't think that's true... I am running SP2 RC1 on my TabletPC (it
adds some really must-have handwriting recognition enhancements), and
Flash is working fine. I don't use IE generally, but I just fired it
up, reset all IE settings to their default (a nifty feature that SP2
adds to the Tools menu) and browsed to a couple of sites that use
Flash, including macromedia.com, and everything worked fine. Maybe if
I didn't have the latest version of Flash installed already, but I
don't really know. If you're worried, you should probably download and
install the RC2 - I've got it in a Virtual PC virtual machine at work,
but haven't had time to play with it much yet.

Cheers,
K.

-- 
Kay Smoljak
http://kay.smoljak.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: beta fckeditor out

2004-07-04 Thread Michael Kear
Thanks Kay,    it's amazing how frequently our paths cross on the net. 

I've looked at XStandard one, and it uses an ACTIVEX control which means it
will fail to work when WinXPPro SP2 comes out in a few weeks, just like all
flash will fail.  All ActiveX controls will fail unless they are from
Microsoft, as I understand it,  or have I got the wrong idea with that? 

And Massimo Foti's WYSIWYG at cfmentor.com is by far the most promising. It
runs as a coldfusion custom tag, (or cfmodule if you prefer) but it only
works on IE6+.   If you have mozilla users or netscape users you're stuffed.
And it would be good to be able to offer a choice of styles from the site's
style sheet instead of giving them the raw styling commands. Instead of
Bold, Underline, Italics etc, I'd like to have a drop down that lets me use
the styles as in the style sheet (i.e. "headline", "byline", "story body",
"story teaser" etc)    But within those limitations, I guess it qualifies
Kay, so I have to change my statement to "I have a list of one".

Cheers

Mike Kear

Windsor, NSW, Australia

AFP Webworks

http://afpwebworks.com



  _  

From: Kay Smoljak [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 4 July 2004 11:29 PM
To: CF-Talk
Subject: Re: beta fckeditor out

Michael Kear <[EMAIL PROTECTED]> wrote:
> I'm still looking for a choice of WYSIWYG editors that will produce valid
> XHTML.  Up till now I have a list of zero.

http://www.xstandard.com/
http://www.cfmentor.com/code/index.cfm?action="">

:)

-- 
Kay Smoljak
http://kay.smoljak.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: beta fckeditor out

2004-07-04 Thread Kay Smoljak
Michael Kear <[EMAIL PROTECTED]> wrote:
> I'm still looking for a choice of WYSIWYG editors that will produce valid
> XHTML.  Up till now I have a list of zero.

http://www.xstandard.com/
http://www.cfmentor.com/code/index.cfm?action="">

:)

-- 
Kay Smoljak
http://kay.smoljak.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: beta fckeditor out

2004-07-04 Thread Michael Kear
FCKEditor is one I've used - shows a lot of promise.  But does it produce
correct XHTML?  (i.e. lower case tags, correct line breaks with the close
slash <.br /> etc)  The last few versions haven't.  In fact it's changed
valid XHTML into invalid by changing all the case characters to upper case.

I'm still looking for a choice of WYSIWYG editors that will produce valid
XHTML.  Up till now I have a list of zero.



Cheers

Mike Kear

Windsor, NSW, Australia

AFP Webworks

http://afpwebworks.com



  _  

From: Joe Rinehart [mailto:[EMAIL PROTECTED] 
Sent: Sunday, 4 July 2004 9:30 PM
To: CF-Talk
Subject: Re: beta fckeditor out

It's actually got some features in mozilla/gecko that aren't available
in IE, like splitting table cells with the mouse, etc.  For something
that's free, it's pretty spiffy.

-joe
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: beta fckeditor out

2004-07-04 Thread Joe Rinehart
It's actually got some features in mozilla/gecko that aren't available
in IE, like splitting table cells with the mouse, etc.  For something
that's free, it's pretty spiffy.

-joe

- Original Message -
From: Claude Schneegans <[EMAIL PROTECTED]>
Date: Sat, 03 Jul 2004 14:35:53 -0400
Subject: Re: beta fckeditor out
To: CF-Talk <[EMAIL PROTECTED]>

>>fckeditor is web based WYSIWYG HTML editor.

Ah! Yet another one! ;-)



--

___

REUSE CODE! Use custom tags;

See http://www.contentbox.com/claude/customtags/tagstore.cfm

(Please send any spam to this address: [EMAIL PROTECTED])

Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]