Re[2]: counting to 5-problem

2003-06-11 Thread cf-talk
I made it this way:
a) with a group and having count > 5
I identified which ones. I then copied
them into a temp_table
[group by company having count(*) > 5]
b) then I deleted the exact above records
in the original table.
c) Copied them back from the temp_table

I am sure there must be a stored procedure
or something else for this which is much easier. :-)
But what I did solved at least my problem.
Thanks for help.

Uwe


MT> they want them all to go, just 5 at a time I imagine. I am assuming this is
MT> to prevent alerting the network guys of a SPAM attack  :-)


MT> - Original Message - 
MT> From: "DURETTE, STEVEN J (AIT)" <[EMAIL PROTECTED]>
MT> To: "CF-Talk" <[EMAIL PROTECTED]>
MT> Sent: Wednesday, June 11, 2003 12:19 PM
MT> Subject: RE: counting to 5-problem


>> My question would be how do you determine which 5?
>>
>> If you had a list of 10 people, would only the first 5 get the e-mail?
MT> Why
>> would you want to prevent the others from getting the e-mail if they
MT> signed
>> up for it?
>>
>>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, June 11, 2003 8:53 AM
>> To: CF-Talk
>> Subject: counting to 5-problem
>>
>>
>> We are having
>> an eMailing-List where
>> quite e few people do have
>> eMail-adresses from the same
>> companies. Now we want to send out
>> eMails only to 5 people of
>> the same company but not more.
>> The sixth eMail-adress should be marked (with a checkbox or s.th.
>> else).
>> The fields are eMail and company.
>> How can I do this ?
>> I don't have an idea yet.
>> Can someone help me ?
>> Uwe
>>
>>
>> 
MT> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Checkbox woes

2003-06-11 Thread Kwang Suh
You're using session variables in the query, but you're not setting them
anywhere on this page.
- Original Message - 
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 11:25 PM
Subject: Checkbox woes


> I am have a bit of a time with this whole checkbox thing. The check boxes
are for users to select an item if they want to include it in the search.
They always return a 0 instead of a 1 if I have a box checked thus it is not
being used by my query on the action page as a search criteria.
>
> Maybe I am tired but I need to get this done. The follwoing is my form
code followed by the action code. Any help is appreciated in advance.
>
> FORM PAGE:
> 
> 
> 
>   
>   Books
>   
>   Music
> Items
> 
>
> 
> 
>
> ACTION PAGE:
>
> 
> 
>
> 
> 
>
> 
> SELECT sm.sid as rf1,sm.SALEADDR as rf2, sm.SALEcity as rf4,sM.saletype as
rf3, s.saledate as rf5, s.saletimefrom+' - '+saletimeto as rf6
> FROM sale_master sm,  sale s
> WHERE sm.sid = s.sid
> AND s.saleDisplay = 'Yes'
> AND sm.SALEreleased = 1
> AND sm.SALEITEM1 = #session.vSI1#)
> AND sm.SALEITEM2 = #session.vSI2#)
> 
>
> 
> Get your own free email account from
> http://www.popmail.com
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...

2003-06-11 Thread cf-talk
This is very good news.  Please keep us posted.

-Novak

- Original Message - 
From: "Stacy Young" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 7:48 PM
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on W
indows Issues...


> Not much else I can say but, kick a$$ !  ;)
>
> -Stace
>
> -Original Message-
> From: Damon Cooper [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 9:42 PM
> To: CF-Talk
> Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on
> W indows Issues...
>
> One more update:
>
> We believe we at least somewhat understand the "CFMX doesn't startup on
> reboot" issue as recreated on the machines in house here.
>
> To summarize (and I'm sure I'm whitewashing some of this):
>
> 1) The CFMX App Server is an native Windows executable wrapper that is
> the main "ColdFusion MX Application Server" service.
> 2) It controls, starts, stops, and monitors the main "jrun.exe"
> executable that CFMX is runs on.
> 3) The wrapper executable has separate timeout values for both starting
> and stopping the main "jrun.exe" executable.  Both timeout values are
> currently hardwired to 20 seconds.
> 4) On machines with a lot going on during startup, or complex services
> dependencies, or slow machines, the "jrun.exe" executable can exceed the
> 20 second timeout in successfully starting.  When this timeout is
> exceeded, the Service wrapper executable "gives up", returns a failure
> code and CFMX is not started.
> 5) If, when CFMX is told to shutdown (via the Services Control Panel, or
> via command, or when an Updater installer tells it to shutdown), the
> "jrun.exe" exceeds the Service wrapper's shutdown timeout (20 sec), the
> wrapper returns a failure code and gives up.
>
> When we extend the startup timeout of the Service wrapper executable (we
> give it some patience), "jrun.exe" and CFMX eventually startup fine, but
> it may take some extra time.  Same for shutdown in most cases.
>
> So...
>
> We're testing a fix to the wrapper that a) raises the default timeout
> for both operations, and making these values configurable via a setting
> (registry, XML file, whatever). It seems to work in all cases so far,
> and we hope to get it to Mike's hoster guy to try shortly (he may
> already have it now).
>
> Finally, as extra shutdown insurance, we may optionally allow the
> shutdown code of the Service wrapper to do a forced shutdown of the
> "jrun.exe" if the (now extended, configurable) timeout expires. As soon
> as we have a good hotfix, we'll try to make it generally available ASAP.
>
>
>
> Sorry about all this, and thanks for hanging with us...
>
> Damon
>
>
>
>
> -Original Message-
> From: Damon Cooper
> Sent: Tuesday, June 10, 2003 7:16 AM
> To: 'CF-Talk '; '[EMAIL PROTECTED]'
> Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on
> Windows Issues...
>
>
> Quick update:
>
> Switching JVM's didn't have any affect on our test machine exhibiting
> the problem. We do get "Error Number 2" errors in the System Event Log,
> however, which indicate "The system cannot find the file specified."
> This could be due to the fact that a socket open failed (TCP sockets are
> OS "files") due to the OS network layer not being ready for us, or we
> were impatient with a short timeout, and may need to sleep & retry the
> open and/or use a longer timeout.
>
> We continue to actively work this today.  More to come...
>
>
>
>
> -Original Message-
> From: Damon Cooper
> Sent: Sunday, June 08, 2003 10:42 AM
> To: 'CF-Talk '
> Subject: Update on the Installer "Freeze" & Failure to Auto-Start on
> Windows Issues...
>
>
> I've not had the cycles to keep up with the feeding frenzy this has
> turned into, but I thought I'd update everyone on where we are regarding
> the 2 issues reported and discussed here at the one machine at Mike's
> hosting site:
>
> 1) ZeroG Java-based Updater installer hang.
>
> It took us a little while to track this down (we had to find a machine
> with less-than 8-bit color display capability...harder than you'd think
> these days).
>
> Here's the scoop:
>
> a) For the GUI-based installer, a minimum of 8-bit color depth (256
> colors) is required to run InstallAnywhere-based installers.
> Additionally, installers require a minimum 640 X 480 screen resolution.
>
>
> b) The Updater installer can be invoked in "silent" mode on Windows, if
> you have a machine that doesn't meet (a) above for the GUI install, or
> (b) you have a need to apply the Updater to many machines via batch
> scripts, etc, etc.  Follow the instructions here for a "silent" install:
>
> http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote
> s_mx_updater03.html#silentinstall
>
>
> 2) CF not automatically starting reliably on Windows after system
> reboot:
>
> We had 3 engineers working this all day Friday, and we believe we have a
> reproducible case, and have started debug

Re: Checkbox woes

2003-06-11 Thread cf-talk
Not sure exactly what you're trying to do but two things I'll mention:

1.  Always remember that if a check box IS NOT checked the field is never
passed in the form.  You'll need to use CFPARAM or something to set the
default to 0 just in case the box is not checked.

2.  Why are you setting the value of your checkbox to "on"?  Why not just
set it to "1" instead?

-Novak


- Original Message - 
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:25 PM
Subject: Checkbox woes


> I am have a bit of a time with this whole checkbox thing. The check boxes
are for users to select an item if they want to include it in the search.
They always return a 0 instead of a 1 if I have a box checked thus it is not
being used by my query on the action page as a search criteria.
>
> Maybe I am tired but I need to get this done. The follwoing is my form
code followed by the action code. Any help is appreciated in advance.
>
> FORM PAGE:
> 
> 
> 
>   
>   Books
>   
>   Music
> Items
> 
>
> 
> 
>
> ACTION PAGE:
>
> 
> 
>
> 
> 
>
> 
> SELECT sm.sid as rf1,sm.SALEADDR as rf2, sm.SALEcity as rf4,sM.saletype as
rf3, s.saledate as rf5, s.saletimefrom+' - '+saletimeto as rf6
> FROM sale_master sm,  sale s
> WHERE sm.sid = s.sid
> AND s.saleDisplay = 'Yes'
> AND sm.SALEreleased = 1
> AND sm.SALEITEM1 = #session.vSI1#)
> AND sm.SALEITEM2 = #session.vSI2#)
> 
>
> 
> Get your own free email account from
> http://www.popmail.com
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Checkbox woes

2003-06-11 Thread ecreese
I am have a bit of a time with this whole checkbox thing. The check boxes are for 
users to select an item if they want to include it in the search. They always return a 
0 instead of a 1 if I have a box checked thus it is not being used by my query on the 
action page as a search criteria.

Maybe I am tired but I need to get this done. The follwoing is my form code followed 
by the action code. Any help is appreciated in advance.

FORM PAGE:


 
  
  Books
  
  Music 
Items

   



ACTION PAGE:








SELECT sm.sid as rf1,sm.SALEADDR as rf2, sm.SALEcity as rf4,sM.saletype as rf3, 
s.saledate as rf5, s.saletimefrom+' - '+saletimeto as rf6
FROM sale_master sm,  sale s
WHERE sm.sid = s.sid
AND s.saleDisplay = 'Yes'
AND sm.SALEreleased = 1
AND sm.SALEITEM1 = #session.vSI1#)
AND sm.SALEITEM2 = #session.vSI2#)



Get your own free email account from
http://www.popmail.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: session locking ?

2003-06-11 Thread Jim Davis
If you'd like more information on locking I've a guide here (watch the
wrap):

http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/

It's applicable directly to CF 5 and below.  The techniques are still
applicable to CFMX, but the warnings about server stability don't apply.

Hope you like it.

Jim Davis
President, http://www.depressedpress.com
Webmaster, http://www.firstnight.org
Webmaster, http://www.cfAdvocacy.org
Senior Consultant, http://www.metlife.com


> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 11:47 PM
> To: CF-Talk
> Subject: Re: session locking ?
> 
> cool, i hadn't read anything that said you could so I was wondering
> (wondering wrong as always)
> 
> Thanks
> 
> dave
> - Original Message -
> From: "Matt Robertson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 11:00 PM
> Subject: RE: session locking ?
> 
> 
> > You mean ''session variables'' right?  You can and should always
combine
> > cflocks where you can.  Saves overhead.
> >
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > HtH,
> >
> > 
> >  Matt Robertson   [EMAIL PROTECTED]
> >  MSB Designs, Inc.  http://mysecretbase.com
> > 
> >
> > -Original Message-
> > From: Dave Lyons [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, June 11, 2003 7:59 PM
> > To: CF-Talk
> > Subject: session locking ?
> >
> >
> > do you need to lock each session separately?
> > for example, I want to set 3 sessions on a successful login, I'm
> > assuming they need to be separately locked but I thought I'd ask
> >
> > dave
> >
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: session locking ?

2003-06-11 Thread Dave Lyons
cool, i hadn't read anything that said you could so I was wondering
(wondering wrong as always)

Thanks

dave
- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 11:00 PM
Subject: RE: session locking ?


> You mean ''session variables'' right?  You can and should always combine
> cflocks where you can.  Saves overhead.
>
> 
> 
> 
> 
> 
> 
>
> HtH,
>
> 
>  Matt Robertson   [EMAIL PROTECTED]
>  MSB Designs, Inc.  http://mysecretbase.com
> 
>
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 7:59 PM
> To: CF-Talk
> Subject: session locking ?
>
>
> do you need to lock each session separately?
> for example, I want to set 3 sessions on a successful login, I'm
> assuming they need to be separately locked but I thought I'd ask
>
> dave
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



saving textarea input to rtf

2003-06-11 Thread Andrew Henry
Hi,

Somewhat of a newbie question I expect.

I have to save input from a textarea, in which the user has the opportunity to alter 
the text in the area(e.g. bold, italic), into an rtf file. That is to say, I need to 
save what the user sees in the textarea into an rtf file so that when the user opens 
the rtf file, from say "Word" the bold and italicized text are retained. 

Thanks for any ideas you have to offer.

Cheers,

Andrew Henry


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...

2003-06-11 Thread Doug White
I too, am impressed very favorably with not only the follow-up, but the
reassurance that those of us that were experiencing problems and took quite a
bit of flack from other users of this list for complaining about it, were not
imagining the problems.

It is also very re-assuring that the identification and resolution has become a
priority of MM, and I am really going to enjoy becoming a member of the happy
campers again.

I now have a slick and solid running Win2003/CFMX server running and am in the
process of adding the free hosting of another user group, the first of which are
very interested in a CFMX web site.  I think it will be a showpiece when
uploaded and goes live within the next few days.

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: "Mike Kear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 9:54 PM
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on W
indows Issues...


| This is excellent follow-up.  I'm pleased they're working on it like
| terriers and aren't going to let it go till it's resolved.
|
| What Damon says would explain how come some people experience the problem
| and others don't, and also how come the problem went away when some people
| forced CFMX to load earlier in the boot-up cycle.
|
|
| Cheers,
| Michael Kear
| Windsor, NSW, Australia
| AFP Webworks.
|
|
|
|
| -Original Message-
| From: Damon Cooper [mailto:[EMAIL PROTECTED]
| Sent: Thursday, 12 June 2003 11:42 AM
| To: CF-Talk
| Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on W
| indows Issues...
|
| One more update:
|
| We believe we at least somewhat understand the "CFMX doesn't startup on
| reboot" issue as recreated on the machines in house here.
|
| To summarize (and I'm sure I'm whitewashing some of this):
|
| 1) The CFMX App Server is an native Windows executable wrapper that is the
| main "ColdFusion MX Application Server" service.
| 2) It controls, starts, stops, and monitors the main "jrun.exe" executable
| that CFMX is runs on.
| 3) The wrapper executable has separate timeout values for both starting and
| stopping the main "jrun.exe" executable.  Both timeout values are currently
| hardwired to 20 seconds.
| 4) On machines with a lot going on during startup, or complex services
| dependencies, or slow machines, the "jrun.exe" executable can exceed the 20
| second timeout in successfully starting.  When this timeout is exceeded, the
| Service wrapper executable "gives up", returns a failure code and CFMX is
| not started.
| 5) If, when CFMX is told to shutdown (via the Services Control Panel, or via
| command, or when an Updater installer tells it to shutdown), the "jrun.exe"
| exceeds the Service wrapper's shutdown timeout (20 sec), the wrapper returns
| a failure code and gives up.
|
| When we extend the startup timeout of the Service wrapper executable (we
| give it some patience), "jrun.exe" and CFMX eventually startup fine, but it
| may take some extra time.  Same for shutdown in most cases.
|
| So...
|
| We're testing a fix to the wrapper that a) raises the default timeout for
| both operations, and making these values configurable via a setting
| (registry, XML file, whatever). It seems to work in all cases so far, and we
| hope to get it to Mike's hoster guy to try shortly (he may already have it
| now).
|
| Finally, as extra shutdown insurance, we may optionally allow the shutdown
| code of the Service wrapper to do a forced shutdown of the "jrun.exe" if the
| (now extended, configurable) timeout expires. As soon as we have a good
| hotfix, we'll try to make it generally available ASAP.
|
|
|
| Sorry about all this, and thanks for hanging with us...
|
| Damon
|
|
|
|
| -Original Message-
| From: Damon Cooper
| Sent: Tuesday, June 10, 2003 7:16 AM
| To: 'CF-Talk '; '[EMAIL PROTECTED]'
| Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on
| Windows Issues...
|
|
| Quick update:
|
| Switching JVM's didn't have any affect on our test machine exhibiting the
| problem. We do get "Error Number 2" errors in the System Event Log, however,
| which indicate "The system cannot find the file specified."  This could be
| due to the fact that a socket open failed (TCP sockets are OS "files") due
| to the OS network layer not being ready for us, or we were impatient with a
| short timeout, and may need to sleep & retry the open and/or use a longer
| timeout.
|
| We continue to actively work this today.  More to come...
|
|
|
|
| -Original Message-
| From: Damon Cooper
| Sent: Sunday, June 08, 2003 10:42 AM
| To: 'CF-Talk '
| Subject: Update on the Installer "Freeze" & Failure to Auto-Start on Windows
| Iss

RE: session locking ?

2003-06-11 Thread Matt Robertson
You mean ''session variables'' right?  You can and should always combine
cflocks where you can.  Saves overhead.








HtH,


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com


-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 7:59 PM
To: CF-Talk
Subject: session locking ?


do you need to lock each session separately?
for example, I want to set 3 sessions on a successful login, I'm
assuming they need to be separately locked but I thought I'd ask

dave



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



session locking ?

2003-06-11 Thread Dave Lyons
do you need to lock each session separately?
for example, I want to set 3 sessions on a successful login, I'm assuming they need to 
be separately locked but I thought I'd ask

dave


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...

2003-06-11 Thread Mike Kear
This is excellent follow-up.  I'm pleased they're working on it like
terriers and aren't going to let it go till it's resolved.

What Damon says would explain how come some people experience the problem
and others don't, and also how come the problem went away when some people
forced CFMX to load earlier in the boot-up cycle.


Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.




-Original Message-
From: Damon Cooper [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 12 June 2003 11:42 AM
To: CF-Talk
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on W
indows Issues...

One more update:

We believe we at least somewhat understand the "CFMX doesn't startup on
reboot" issue as recreated on the machines in house here.

To summarize (and I'm sure I'm whitewashing some of this):

1) The CFMX App Server is an native Windows executable wrapper that is the
main "ColdFusion MX Application Server" service.
2) It controls, starts, stops, and monitors the main "jrun.exe" executable
that CFMX is runs on.
3) The wrapper executable has separate timeout values for both starting and
stopping the main "jrun.exe" executable.  Both timeout values are currently
hardwired to 20 seconds.
4) On machines with a lot going on during startup, or complex services
dependencies, or slow machines, the "jrun.exe" executable can exceed the 20
second timeout in successfully starting.  When this timeout is exceeded, the
Service wrapper executable "gives up", returns a failure code and CFMX is
not started.
5) If, when CFMX is told to shutdown (via the Services Control Panel, or via
command, or when an Updater installer tells it to shutdown), the "jrun.exe"
exceeds the Service wrapper's shutdown timeout (20 sec), the wrapper returns
a failure code and gives up.

When we extend the startup timeout of the Service wrapper executable (we
give it some patience), "jrun.exe" and CFMX eventually startup fine, but it
may take some extra time.  Same for shutdown in most cases.

So...

We're testing a fix to the wrapper that a) raises the default timeout for
both operations, and making these values configurable via a setting
(registry, XML file, whatever). It seems to work in all cases so far, and we
hope to get it to Mike's hoster guy to try shortly (he may already have it
now).

Finally, as extra shutdown insurance, we may optionally allow the shutdown
code of the Service wrapper to do a forced shutdown of the "jrun.exe" if the
(now extended, configurable) timeout expires. As soon as we have a good
hotfix, we'll try to make it generally available ASAP.



Sorry about all this, and thanks for hanging with us...

Damon




-Original Message-
From: Damon Cooper 
Sent: Tuesday, June 10, 2003 7:16 AM
To: 'CF-Talk '; '[EMAIL PROTECTED]'
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on
Windows Issues...


Quick update:

Switching JVM's didn't have any affect on our test machine exhibiting the
problem. We do get "Error Number 2" errors in the System Event Log, however,
which indicate "The system cannot find the file specified."  This could be
due to the fact that a socket open failed (TCP sockets are OS "files") due
to the OS network layer not being ready for us, or we were impatient with a
short timeout, and may need to sleep & retry the open and/or use a longer
timeout.

We continue to actively work this today.  More to come...




-Original Message-
From: Damon Cooper 
Sent: Sunday, June 08, 2003 10:42 AM
To: 'CF-Talk '
Subject: Update on the Installer "Freeze" & Failure to Auto-Start on Windows
Issues...


I've not had the cycles to keep up with the feeding frenzy this has turned
into, but I thought I'd update everyone on where we are regarding the 2
issues reported and discussed here at the one machine at Mike's hosting
site:

1) ZeroG Java-based Updater installer hang.

It took us a little while to track this down (we had to find a machine with
less-than 8-bit color display capability...harder than you'd think these
days).

Here's the scoop:

a) For the GUI-based installer, a minimum of 8-bit color depth (256 colors)
is required to run InstallAnywhere-based installers. Additionally,
installers require a minimum 640 X 480 screen resolution.  

b) The Updater installer can be invoked in "silent" mode on Windows, if you
have a machine that doesn't meet (a) above for the GUI install, or (b) you
have a need to apply the Updater to many machines via batch scripts, etc,
etc.  Follow the instructions here for a "silent" install:

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx
_updater03.html#silentinstall


2) CF not automatically starting reliably on Windows after system reboot:
 
We had 3 engineers working this all day Friday, and we believe we have a
reproducible case, and have started debugging the process to see what's
happening.  

One of the things we're about to try is to simply switch Java VM's to see if
this is the result of a Java VM bug (

RE: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...

2003-06-11 Thread Stacy Young
Not much else I can say but, kick a$$ !  ;)

-Stace

-Original Message-
From: Damon Cooper [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 9:42 PM
To: CF-Talk
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on
W indows Issues...

One more update:

We believe we at least somewhat understand the "CFMX doesn't startup on
reboot" issue as recreated on the machines in house here.

To summarize (and I'm sure I'm whitewashing some of this):

1) The CFMX App Server is an native Windows executable wrapper that is
the main "ColdFusion MX Application Server" service.
2) It controls, starts, stops, and monitors the main "jrun.exe"
executable that CFMX is runs on.
3) The wrapper executable has separate timeout values for both starting
and stopping the main "jrun.exe" executable.  Both timeout values are
currently hardwired to 20 seconds.
4) On machines with a lot going on during startup, or complex services
dependencies, or slow machines, the "jrun.exe" executable can exceed the
20 second timeout in successfully starting.  When this timeout is
exceeded, the Service wrapper executable "gives up", returns a failure
code and CFMX is not started.
5) If, when CFMX is told to shutdown (via the Services Control Panel, or
via command, or when an Updater installer tells it to shutdown), the
"jrun.exe" exceeds the Service wrapper's shutdown timeout (20 sec), the
wrapper returns a failure code and gives up.

When we extend the startup timeout of the Service wrapper executable (we
give it some patience), "jrun.exe" and CFMX eventually startup fine, but
it may take some extra time.  Same for shutdown in most cases.

So...

We're testing a fix to the wrapper that a) raises the default timeout
for both operations, and making these values configurable via a setting
(registry, XML file, whatever). It seems to work in all cases so far,
and we hope to get it to Mike's hoster guy to try shortly (he may
already have it now).

Finally, as extra shutdown insurance, we may optionally allow the
shutdown code of the Service wrapper to do a forced shutdown of the
"jrun.exe" if the (now extended, configurable) timeout expires. As soon
as we have a good hotfix, we'll try to make it generally available ASAP.



Sorry about all this, and thanks for hanging with us...

Damon




-Original Message-
From: Damon Cooper 
Sent: Tuesday, June 10, 2003 7:16 AM
To: 'CF-Talk '; '[EMAIL PROTECTED]'
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on
Windows Issues...


Quick update:

Switching JVM's didn't have any affect on our test machine exhibiting
the problem. We do get "Error Number 2" errors in the System Event Log,
however, which indicate "The system cannot find the file specified."
This could be due to the fact that a socket open failed (TCP sockets are
OS "files") due to the OS network layer not being ready for us, or we
were impatient with a short timeout, and may need to sleep & retry the
open and/or use a longer timeout.

We continue to actively work this today.  More to come...




-Original Message-
From: Damon Cooper 
Sent: Sunday, June 08, 2003 10:42 AM
To: 'CF-Talk '
Subject: Update on the Installer "Freeze" & Failure to Auto-Start on
Windows Issues...


I've not had the cycles to keep up with the feeding frenzy this has
turned into, but I thought I'd update everyone on where we are regarding
the 2 issues reported and discussed here at the one machine at Mike's
hosting site:

1) ZeroG Java-based Updater installer hang.

It took us a little while to track this down (we had to find a machine
with less-than 8-bit color display capability...harder than you'd think
these days).

Here's the scoop:

a) For the GUI-based installer, a minimum of 8-bit color depth (256
colors) is required to run InstallAnywhere-based installers.
Additionally, installers require a minimum 640 X 480 screen resolution.


b) The Updater installer can be invoked in "silent" mode on Windows, if
you have a machine that doesn't meet (a) above for the GUI install, or
(b) you have a need to apply the Updater to many machines via batch
scripts, etc, etc.  Follow the instructions here for a "silent" install:

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote
s_mx_updater03.html#silentinstall


2) CF not automatically starting reliably on Windows after system
reboot:
 
We had 3 engineers working this all day Friday, and we believe we have a
reproducible case, and have started debugging the process to see what's
happening.  

One of the things we're about to try is to simply switch Java VM's to
see if this is the result of a Java VM bug (we've had several in the
interacting-with-Windows-as-a-Service area before, so we're not ruling
that out, and it's a quick thing to try.  Recall that the CFMX Gold bits
shipped out of the box with the Sun 1.3.1_03 VM.  Trying the 1.3.1_08
VM, the 1.4.1_03 VM and the 1.4.2 Beta VM will determine whether it's
something that's fixed in the VM

RE: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...

2003-06-11 Thread Damon Cooper
One more update:

We believe we at least somewhat understand the "CFMX doesn't startup on reboot" issue 
as recreated on the machines in house here.

To summarize (and I'm sure I'm whitewashing some of this):

1) The CFMX App Server is an native Windows executable wrapper that is the main 
"ColdFusion MX Application Server" service.
2) It controls, starts, stops, and monitors the main "jrun.exe" executable that CFMX 
is runs on.
3) The wrapper executable has separate timeout values for both starting and stopping 
the main "jrun.exe" executable.  Both timeout values are currently hardwired to 20 
seconds.
4) On machines with a lot going on during startup, or complex services dependencies, 
or slow machines, the "jrun.exe" executable can exceed the 20 second timeout in 
successfully starting.  When this timeout is exceeded, the Service wrapper executable 
"gives up", returns a failure code and CFMX is not started.
5) If, when CFMX is told to shutdown (via the Services Control Panel, or via command, 
or when an Updater installer tells it to shutdown), the "jrun.exe" exceeds the Service 
wrapper's shutdown timeout (20 sec), the wrapper returns a failure code and gives up.

When we extend the startup timeout of the Service wrapper executable (we give it some 
patience), "jrun.exe" and CFMX eventually startup fine, but it may take some extra 
time.  Same for shutdown in most cases.

So...

We're testing a fix to the wrapper that a) raises the default timeout for both 
operations, and making these values configurable via a setting (registry, XML file, 
whatever). It seems to work in all cases so far, and we hope to get it to Mike's 
hoster guy to try shortly (he may already have it now).

Finally, as extra shutdown insurance, we may optionally allow the shutdown code of the 
Service wrapper to do a forced shutdown of the "jrun.exe" if the (now extended, 
configurable) timeout expires. As soon as we have a good hotfix, we'll try to make it 
generally available ASAP.



Sorry about all this, and thanks for hanging with us...

Damon




-Original Message-
From: Damon Cooper 
Sent: Tuesday, June 10, 2003 7:16 AM
To: 'CF-Talk '; '[EMAIL PROTECTED]'
Subject: RE: Update on the Installer "Freeze" & Failure to Auto-Start on Windows 
Issues...


Quick update:

Switching JVM's didn't have any affect on our test machine exhibiting the problem. We 
do get "Error Number 2" errors in the System Event Log, however, which indicate "The 
system cannot find the file specified."  This could be due to the fact that a socket 
open failed (TCP sockets are OS "files") due to the OS network layer not being ready 
for us, or we were impatient with a short timeout, and may need to sleep & retry the 
open and/or use a longer timeout.

We continue to actively work this today.  More to come...




-Original Message-
From: Damon Cooper 
Sent: Sunday, June 08, 2003 10:42 AM
To: 'CF-Talk '
Subject: Update on the Installer "Freeze" & Failure to Auto-Start on Windows Issues...


I've not had the cycles to keep up with the feeding frenzy this has turned into, but I 
thought I'd update everyone on where we are regarding the 2 issues reported and 
discussed here at the one machine at Mike's hosting site:

1) ZeroG Java-based Updater installer hang.

It took us a little while to track this down (we had to find a machine with less-than 
8-bit color display capability...harder than you'd think these days).

Here's the scoop:

a) For the GUI-based installer, a minimum of 8-bit color depth (256 colors) is 
required to run InstallAnywhere-based installers. Additionally, installers require a 
minimum 640 X 480 screen resolution.  

b) The Updater installer can be invoked in "silent" mode on Windows, if you have a 
machine that doesn't meet (a) above for the GUI install, or (b) you have a need to 
apply the Updater to many machines via batch scripts, etc, etc.  Follow the 
instructions here for a "silent" install:

http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater03.html#silentinstall


2) CF not automatically starting reliably on Windows after system reboot:
 
We had 3 engineers working this all day Friday, and we believe we have a reproducible 
case, and have started debugging the process to see what's happening.  

One of the things we're about to try is to simply switch Java VM's to see if this is 
the result of a Java VM bug (we've had several in the 
interacting-with-Windows-as-a-Service area before, so we're not ruling that out, and 
it's a quick thing to try.  Recall that the CFMX Gold bits shipped out of the box with 
the Sun 1.3.1_03 VM.  Trying the 1.3.1_08 VM, the 1.4.1_03 VM and the 1.4.2 Beta VM 
will determine whether it's something that's fixed in the VM.  If anyone on this list 
is experiencing the issue, and wants to try these VM's and report back, that would be 
a big help, and you can participate in helping to move this issue forward.

More to come, when we know more (likely M

Re: Cftextarea...

2003-06-11 Thread David K
Just posted this on another thread but here it is again.

Here's a useful resource on WYSIWYG text editors..
http://www.bris.ac.uk/is/projects/cms/ttw/ttw.html

and a Daemonite blog entry that you also may find useful...
http://blog.daemon.com.au/archives/000141.html#000141

--David K


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: DTS to update SQL Server database?

2003-06-11 Thread jonhall
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

-- 
mailto:[EMAIL PROTECTED]
Wednesday, June 11, 2003, 7:33:26 PM, you wrote:

>> Other than importing a flat file, the other two have downsides as
>> well. Like the phantom user issue...

DH> Phantom user issue?



DH> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: active edit alternatives

2003-06-11 Thread David K
Here's a useful resource on WYSIWYG text editors..
http://www.bris.ac.uk/is/projects/cms/ttw/ttw.html

and a Daemonite blog entry that you also may find useful...
http://blog.daemon.com.au/archives/000141.html#000141

--David K

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFFILE upload max. file size?

2003-06-11 Thread Stacy Young
That's good to know...I ran into this a while back but never knew what
was causing the failure (I can only guess this was it but...)...was one
of the last straws before I went Apache.

-Stace


-Original Message-
From: Trey Rouse [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 3:47 PM
To: CF-Talk
Subject: RE: CFFILE upload max. file size?

There is a bug in IIS that limits the file upload size.  Its tricky to
put a number on it, but anything over 4 megs on a 100mbit line will
likely send your server running never to return.

It has nothing to do with memory allocation, it's a fricken bug in IIS.
Microsoft acknowledges it to their ASP developers and directs them to
use a com object for the transfer in lou of a form post.  This works of
course for CF as well, but it means you can not use CFFILE for user
uploads on top of IIS.

Well, unless you like having your server crash.

Trey Rouse
Data Application Architect
Web Services - Rice University

> -Original Message-
> From: Andrew Golden [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 13, 2003 12:35 PM
> To: CF-Talk
> Subject: CFFILE upload max. file size?
> 
> Does anyone know if there is a maximum file size that can be
transferred
> using CFFILE to upload? What is the largest anyone has ever had
repeated
> success with? Any help would be appreciatedthanks!
> 
> Andrew Golden
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Stacy Young
Try returning an array of structs...should be a lot easier to work with
in .NET

-Stace

-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 3:21 AM
To: CF-Talk
Subject: Consuming CFMX Web Services in ASP.NET

My friend has a problem when calling a web service method which returns
CFMX query object.
 
When I return a query object from CFC function, .NET cannot get the
recordset object.
 
I'm using CFMX U3.
 
Any experiences?




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: query question

2003-06-11 Thread Casey C Cook
We have watched the web-server spike up to 100 percent utilization on 
cumbersome queries before (afterward the page was modified to reduce the 
number of results returned). Im not sure if this is supposed to happen but 
it did.

Casey Cook

This is a PRIVATE message. If you are not the intended recipient, please 
delete without copying and kindly advise us by e-mail of the mistake in 
delivery. NOTE: Regardless of content, this e-mail shall not operate to 
bind CSC to any order or other contract unless pursuant to explicit 
written agreement or government initiative expressly permitting the use of 
e-mail for such purpose.






"Robert Shaw" 
06/11/2003 04:39 PM
Please respond to cf-talk

 
To: CF-Talk <[EMAIL PROTECTED]>
cc: 
Subject:query question


Hi All,
It appears a certain query of mine is causing our CPU to spike. We're 
working on the query but what is strange is that it will hose CF. It was 
my 
uderstanding that CF passes the connection off so I would think it would 
be 
normal for the database server's CPU to spike but not for CF to cause the 
webserver CPU to spike. If we kill the query it immediately goes back 
down. 
Does this sound right? I have not seen this happen before and am 
questioning 
if my logic is off.

TIA,
Rob

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: query question

2003-06-11 Thread Parker, Kevin
I had a similar problem too - we restructured the queries to use INNER JOINS
and it solved it. It went from CPU flat out to barely a blip on the radar
screen


**
Kevin Parker
Web Services Manager
WorkCover Corporation

e: [EMAIL PROTECTED]
w: www.workcover.com

p:+ 61 8 8233 2548
f: +61 8 8233 2282
m: 0418 806 166
**


-Original Message-
From: Robert Shaw [mailto:[EMAIL PROTECTED]
Sent: Thursday, 12 June 2003 9:09 AM
To: CF-Talk
Subject: query question


Hi All,
It appears a certain query of mine is causing our CPU to spike. We're 
working on the query but what is strange is that it will hose CF. It was my 
uderstanding that CF passes the connection off so I would think it would be 
normal for the database server's CPU to spike but not for CF to cause the 
webserver CPU to spike. If we kill the query it immediately goes back down. 
Does this sound right? I have not seen this happen before and am questioning

if my logic is off.

TIA,
Rob

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



query question

2003-06-11 Thread Robert Shaw
Hi All,
It appears a certain query of mine is causing our CPU to spike. We're 
working on the query but what is strange is that it will hose CF. It was my 
uderstanding that CF passes the connection off so I would think it would be 
normal for the database server's CPU to spike but not for CF to cause the 
webserver CPU to spike. If we kill the query it immediately goes back down. 
Does this sound right? I have not seen this happen before and am questioning 
if my logic is off.

TIA,
Rob

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: DTS to update SQL Server database?

2003-06-11 Thread Dina Hess
> Other than importing a flat file, the other two have downsides as
> well. Like the phantom user issue...

Phantom user issue?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: active edit alternatives

2003-06-11 Thread Dave Lyons
LOL! tell me about it!
I can spell pretty good, I just cant type for sh*t
And then the stupid spell check screws everything up anyway!
Have you ever tried to spell check an email with code in it?

You know how they say that your family got its name from what they did? Does
Griefer = Grief giver? ha-ha jk

- Original Message -
From: "Charlie Griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 7:05 PM
Subject: Re: active edit alternatives


> Dude...if there's anybody who shouldn't take a spell checker for granted,
> it's you : )
>
> c'mon...big hugs...just kidding :)
>
> - Original Message -
> From: "Dave Lyons" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 3:56 PM
> Subject: Re: active edit alternatives
>
>
> > I don't know, this one you suggested took an awfully long time to load
up
> > (over 90 seconds on a cable line)
> >
> > I'd still recommend HTMLAREA, its free, configurable and you can
implement
> > it in about 2 minutes. The only thing it doesn't have is a spell
checker,
> > big whoopy:)
> >
> > Dave
> > - Original Message -
> > From: "Trey Rouse" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 11, 2003 3:30 PM
> > Subject: RE: active edit alternatives
> >
> >
> > > We've had some problems using realObjects in a test rollout on campus.
> > >
> > > Everybody has failed to mention what is hands down the best product...
> > >
> > > http://www.ephox.com/
> > >
> > > Take a look at EditLive! For Java.  Hands down the cleanest TTW WYSWYG
> > > I've worked with.
> > >
> > > Our current solution is from Ektron using the empower/ewebeditpro
> > > solution.  Its not pretty, but coupling it with some 2003 Terminal
> > > servers, an emulator from HobSoft, and a little slight of hand, we are
> > > delivering the activeX controls out to our mac/unix clients.
> > >
> > > This solution has been less than ideal, and we are currently
developing
> > > a EditLive! solution to replace our Ektron based product.
> > >
> > > Simply put, Ektron has given us 16 months of broken promises to
deliver
> > > a cross platform solution.  There was a rumored java version that they
> > > never let into beta, and there is a Flash object that lacks link
library
> > > and image support, which we have designated as core requirements of
any
> > > TTW WYSIWYG solution.
> > >
> > > Good luck,
> > >
> > > Trey Rouse
> > > Data Application Architect
> > > Web Services - Rice University
> > >
> > >
> > > > -Original Message-
> > > > From: joe hobson [mailto:[EMAIL PROTECTED]
> > > > Sent: Friday, June 06, 2003 10:18 AM
> > > > To: CF-Talk
> > > > Subject: active edit alternaitves
> > > >
> > > > Thanks for the realObjects suggestion. That's the only one i've seen
> > > so
> > > > far that's cross-platform. activEdit gives their excuse about the
Mac
> > > not
> > > > supporting LiveConnect while realObjects finds a work around for the
> > > > issue. So who would you trust for maintaing excellent future
> > > development?
> > > >
> > > > But i still don't understand why there isn't a basic Flash-based
> > > WYSIWYG
> > > > editor out there, which theoretically could overcome the browser and
> > > > platform compatibility issues much easier. If anyone knows of one,
> > > please
> > > > speak up.
> > > >
> > > > On a related note, does anyone use activSpell, outside of activEdit?
> > > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: active edit alternatives

2003-06-11 Thread Charlie Griefer
Dude...if there's anybody who shouldn't take a spell checker for granted,
it's you : )

c'mon...big hugs...just kidding :)

- Original Message -
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 3:56 PM
Subject: Re: active edit alternatives


> I don't know, this one you suggested took an awfully long time to load up
> (over 90 seconds on a cable line)
>
> I'd still recommend HTMLAREA, its free, configurable and you can implement
> it in about 2 minutes. The only thing it doesn't have is a spell checker,
> big whoopy:)
>
> Dave
> - Original Message -
> From: "Trey Rouse" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 3:30 PM
> Subject: RE: active edit alternatives
>
>
> > We've had some problems using realObjects in a test rollout on campus.
> >
> > Everybody has failed to mention what is hands down the best product...
> >
> > http://www.ephox.com/
> >
> > Take a look at EditLive! For Java.  Hands down the cleanest TTW WYSWYG
> > I've worked with.
> >
> > Our current solution is from Ektron using the empower/ewebeditpro
> > solution.  Its not pretty, but coupling it with some 2003 Terminal
> > servers, an emulator from HobSoft, and a little slight of hand, we are
> > delivering the activeX controls out to our mac/unix clients.
> >
> > This solution has been less than ideal, and we are currently developing
> > a EditLive! solution to replace our Ektron based product.
> >
> > Simply put, Ektron has given us 16 months of broken promises to deliver
> > a cross platform solution.  There was a rumored java version that they
> > never let into beta, and there is a Flash object that lacks link library
> > and image support, which we have designated as core requirements of any
> > TTW WYSIWYG solution.
> >
> > Good luck,
> >
> > Trey Rouse
> > Data Application Architect
> > Web Services - Rice University
> >
> >
> > > -Original Message-
> > > From: joe hobson [mailto:[EMAIL PROTECTED]
> > > Sent: Friday, June 06, 2003 10:18 AM
> > > To: CF-Talk
> > > Subject: active edit alternaitves
> > >
> > > Thanks for the realObjects suggestion. That's the only one i've seen
> > so
> > > far that's cross-platform. activEdit gives their excuse about the Mac
> > not
> > > supporting LiveConnect while realObjects finds a work around for the
> > > issue. So who would you trust for maintaing excellent future
> > development?
> > >
> > > But i still don't understand why there isn't a basic Flash-based
> > WYSIWYG
> > > editor out there, which theoretically could overcome the browser and
> > > platform compatibility issues much easier. If anyone knows of one,
> > please
> > > speak up.
> > >
> > > On a related note, does anyone use activSpell, outside of activEdit?
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: active edit alternatives

2003-06-11 Thread Dave Lyons
I don't know, this one you suggested took an awfully long time to load up
(over 90 seconds on a cable line)

I'd still recommend HTMLAREA, its free, configurable and you can implement
it in about 2 minutes. The only thing it doesn't have is a spell checker,
big whoopy:)

Dave
- Original Message -
From: "Trey Rouse" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 3:30 PM
Subject: RE: active edit alternatives


> We've had some problems using realObjects in a test rollout on campus.
>
> Everybody has failed to mention what is hands down the best product...
>
> http://www.ephox.com/
>
> Take a look at EditLive! For Java.  Hands down the cleanest TTW WYSWYG
> I've worked with.
>
> Our current solution is from Ektron using the empower/ewebeditpro
> solution.  Its not pretty, but coupling it with some 2003 Terminal
> servers, an emulator from HobSoft, and a little slight of hand, we are
> delivering the activeX controls out to our mac/unix clients.
>
> This solution has been less than ideal, and we are currently developing
> a EditLive! solution to replace our Ektron based product.
>
> Simply put, Ektron has given us 16 months of broken promises to deliver
> a cross platform solution.  There was a rumored java version that they
> never let into beta, and there is a Flash object that lacks link library
> and image support, which we have designated as core requirements of any
> TTW WYSIWYG solution.
>
> Good luck,
>
> Trey Rouse
> Data Application Architect
> Web Services - Rice University
>
>
> > -Original Message-
> > From: joe hobson [mailto:[EMAIL PROTECTED]
> > Sent: Friday, June 06, 2003 10:18 AM
> > To: CF-Talk
> > Subject: active edit alternaitves
> >
> > Thanks for the realObjects suggestion. That's the only one i've seen
> so
> > far that's cross-platform. activEdit gives their excuse about the Mac
> not
> > supporting LiveConnect while realObjects finds a work around for the
> > issue. So who would you trust for maintaing excellent future
> development?
> >
> > But i still don't understand why there isn't a basic Flash-based
> WYSIWYG
> > editor out there, which theoretically could overcome the browser and
> > platform compatibility issues much easier. If anyone knows of one,
> please
> > speak up.
> >
> > On a related note, does anyone use activSpell, outside of activEdit?
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



The DBMS returned an unspecified error

2003-06-11 Thread Tim Do
Hello all,
 
I'm seeing this error once in a while on our live sites but then I would do
a refresh.. and it would be fine.  Any ideas?
 
Thanks,
 
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: DTS to update SQL Server database?

2003-06-11 Thread jon hall
Wednesday, June 11, 2003, 3:59:51 PM, you wrote:
>>In my perfect world though, in a batch situation, with a small update,
>>the publishing side would fire a DTS that connected to the remote side
>>and updated the data. This one takes very little time to setup, and
>>doesn't place the constraints that replication does on the schema. It
>>also can be done manually or automated, so it's flexible.

Let me modify this...whichever side I control is the side that has the
DTS. It could be that I controlled the side being published too, in
that case, it becomes a pull transaction instead of a push.

DH> Wow, well said; thank you for taking the time to help me understand this. I
DH> always thought DTS was used to migrate databases, or transfer data between
DH> disparate data sources. I didn't realize it was useful for making small
DH> batch updates.

Yeah...just schedule the DTS, and you never have to touch it again,
and modifying it is point and click.

DH> I had already run into the schema problem you mentioned with replication
DH> since my primary keys are identities.

DH> But why don't you recommend FTPing the updated database files? Is that some
DH> kind of SQL Server no-no? If so, why?

It would definitely be possible to do this by disconnecting the
detaching the db and uploading and reattaching, or by uploading a
backup, or even uploading a flat file and importing it, or some other way,
but all those adds steps, and possible points of failure. None are
totally unacceptable, they just wouldn't be my choice.

Other than importing a flat file, the other two have downsides as
well. Like the phantom user issue...

-- 
 jon
 mailto:[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



db2 cftransaction best practices

2003-06-11 Thread s r
I am trying to convince my Manager and DBAs here to 
change the way they manage Database transactions in 
here.

The environment is ColdFusion 5.0, DB2 version 6, DB2
connect

The current setup is as follows.
-

1. All access to the database is through Stored
Procedures only.
Right now they have the concept of building generic
inserts, updates and 
deletes to each table. 

2. They want to set up transaction processing using
cftransaction 
to keep the DB2 stored procedures simple.

For example say there are 3 tables.
tableA, tableB, tableC
Say my transaction requires 
1. delete row from tableC
2. update row in tableB
3. insert new row in tableB
4. insert a row in tableA

then as per the current practice here  I have to do
this















Now to my Question:
--

1. I am trying to convince the processing would be
quicker
if the transaction processing is also built inside
another
Stored Procedure. I am arguing at least give me an
option of doing 
transactions inside the database by providing a
controller stored procedure 
that sets up the transaction and makes nested calls to
the generic ones.

2. I know the processing would be quicker, but I am
trying 
to give them some numbers and a comparison of how much
improvement we can achieve by moving the complexity
into
Stored Procedures.

Can someone point me in the right direction. Also can
someone
tell me what other Issues i can bring up in support of
my
case.

thanks
sudhakar




__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Dave Watts
> IMO, if ASP.NET cannot consume a Web Service built in 
> CFMX, it greatly reduces the benefit of writing it in 
> CFMX.
> 
> I think the touted benefit of Web Services is that they 
> can be consumed by the most common platforms, no?
> 
> Can anyone confirm that they are incompatible?

They aren't necessarily incompatible. However, between almost any two
platforms that provide web services interfaces, you may very well encounter
compatibility issues. The likelihood of these issues arising tends to
increase with the complexity of the specific web services, but there are
some general problems that you might encounter. For example, within the SOAP
specification, there's no defined datatype or description for a recordset,
so each platform tends to implement returned recordsets differently.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Matthew Small
You're right, but I thought webservices that were meant to be consumed
cross-platform should use basic datatypes like string pairs and not have
complex proprietary structures.

I don't know enough about either type of webservice to say how they
interact.

Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 

-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 4:11 PM
To: CF-Talk
Subject: Re: Consuming CFMX Web Services in ASP.NET

IMO, if ASP.NET cannot consume a Web Service built in CFMX, it greatly
reduces the benefit of writing it in CFMX.

I think the touted benefit of Web Services is that they can be consumed
by
the most common platforms, no?

Can anyone confirm that they are incompatible?

-Frank Mamone


- Original Message -
From: "Michael Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 12:45 PM
Subject: Re: Consuming CFMX Web Services in ASP.NET


> just a thought...  what about wddx?
>
>
> - Original Message -
> From: "Matthew Small" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 12:19 PM
> Subject: RE: Consuming CFMX Web Services in ASP.NET
>
>
> > I don't imagine that the .NET datatable and the CFMX recordset are
> > compatible by nature, but I've never tried so I don't know for sure.
I
> > think that the data is passable, but that your friend will have to
> > explicitly loop through the XML object and find his data manually,
or
> > write a small object that will do it for him.
> >
> > Questions:
> > 1. Is he definitely retrieving data from the webservice through
CFMX?
> > 2. How is he attempting to read the data?
> >
> >
> > Matthew Small
> > IT Director
> > Showstopper American Dance Championships
> > [EMAIL PROTECTED]
> > 843-357-1847
> >
> >
> > -Original Message-
> > From: Murat Demirci [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, June 11, 2003 11:57 AM
> > To: CF-Talk
> > Subject: RE: Consuming CFMX Web Services in ASP.NET
> >
> > Any response?
> >
> >
> >
> > -Original Message-
> > From: Murat Demirci [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 10, 2003 10:21 AM
> > To: CF-Talk
> > Subject: Consuming CFMX Web Services in ASP.NET
> >
> >
> > My friend has a problem when calling a web service method which
returns
> > CFMX
> > query object.
> >
> > When I return a query object from CFC function, .NET cannot get the
> > recordset object.
> >
> > I'm using CFMX U3.
> >
> > Any experiences?
> >
> >
> >
> >
> >
> >
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Frank Mamone
IMO, if ASP.NET cannot consume a Web Service built in CFMX, it greatly
reduces the benefit of writing it in CFMX.

I think the touted benefit of Web Services is that they can be consumed by
the most common platforms, no?

Can anyone confirm that they are incompatible?

-Frank Mamone


- Original Message -
From: "Michael Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 12:45 PM
Subject: Re: Consuming CFMX Web Services in ASP.NET


> just a thought...  what about wddx?
>
>
> - Original Message -
> From: "Matthew Small" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 11, 2003 12:19 PM
> Subject: RE: Consuming CFMX Web Services in ASP.NET
>
>
> > I don't imagine that the .NET datatable and the CFMX recordset are
> > compatible by nature, but I've never tried so I don't know for sure.  I
> > think that the data is passable, but that your friend will have to
> > explicitly loop through the XML object and find his data manually, or
> > write a small object that will do it for him.
> >
> > Questions:
> > 1. Is he definitely retrieving data from the webservice through CFMX?
> > 2. How is he attempting to read the data?
> >
> >
> > Matthew Small
> > IT Director
> > Showstopper American Dance Championships
> > [EMAIL PROTECTED]
> > 843-357-1847
> >
> >
> > -Original Message-
> > From: Murat Demirci [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, June 11, 2003 11:57 AM
> > To: CF-Talk
> > Subject: RE: Consuming CFMX Web Services in ASP.NET
> >
> > Any response?
> >
> >
> >
> > -Original Message-
> > From: Murat Demirci [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, June 10, 2003 10:21 AM
> > To: CF-Talk
> > Subject: Consuming CFMX Web Services in ASP.NET
> >
> >
> > My friend has a problem when calling a web service method which returns
> > CFMX
> > query object.
> >
> > When I return a query object from CFC function, .NET cannot get the
> > recordset object.
> >
> > I'm using CFMX U3.
> >
> > Any experiences?
> >
> >
> >
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Tony Walker
Or, if possible, add a field to the vct file for include/exclude...

ô¿ô Tony

-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 11:37 AM
To: CF-Talk
Subject: SOT: SQL Question - Could CF make this easier?

I am creating a drop-down list of items, but I want to keep several items
from appearing in the drop-down.

Is there a more efficient way to accomplish this (there will be several more
exclusions):


SELECT DISTINCT 
Description 
FROMVCT 
ORDER BY 
Description
WHERE   description != 'ANISE'
AND description != 'APPLES'
AND description != 'ASPARAGUS'
AND description != 'BEETS'
AND description != 'BROCCOLI'


--
Jillian



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: DTS to update SQL Server database?

2003-06-11 Thread Dina Hess
>In my perfect world though, in a batch situation, with a small update,
>the publishing side would fire a DTS that connected to the remote side
>and updated the data. This one takes very little time to setup, and
>doesn't place the constraints that replication does on the schema. It
>also can be done manually or automated, so it's flexible.

Wow, well said; thank you for taking the time to help me understand this. I
always thought DTS was used to migrate databases, or transfer data between
disparate data sources. I didn't realize it was useful for making small
batch updates.

I had already run into the schema problem you mentioned with replication
since my primary keys are identities.

But why don't you recommend FTPing the updated database files? Is that some
kind of SQL Server no-no? If so, why?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: populate the damn array

2003-06-11 Thread Owens, Howard
Great explanation, Bryan.  Thanks.  And it worked.

H.


> -Original Message-
> From: Bryan Love [SMTP:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 11:50 AM
> To:   CF-Talk
> Subject:  RE: populate the damn array
> 
> just move "ad = StructNew();" inside the for loop and problem solved.
> 
> The reason it's doing that is because you only declared structNew once.
> When you declare structNew it causes the variable (ad) to point to a
> memory
> address (let's use 0x1234 for this example).
> You then add this memory address to the array 36 times so you have an
> array
> where each item points to the exact same memory space.  The last loop of
> the
> for loop sets the values in that memory space to the last item in the file
> and so it will appear that all the array items are the same (which they
> are)
> and they all point to the last item from the file.
> 
> Put structNew inside the for loop and each iteration of the list will give
> "ad" a new memory pointer and each array item will be unique.
> 
> +---+
> Bryan Love
>   Database Analyst
>   Macromedia Certified Professional
>   Internet Application Developer
> TeleCommunication Systems
> [EMAIL PROTECTED]
> +---+
> 
>   
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFFILE upload max. file size?

2003-06-11 Thread Trey Rouse
There is a bug in IIS that limits the file upload size.  Its tricky to
put a number on it, but anything over 4 megs on a 100mbit line will
likely send your server running never to return.

It has nothing to do with memory allocation, it's a fricken bug in IIS.
Microsoft acknowledges it to their ASP developers and directs them to
use a com object for the transfer in lou of a form post.  This works of
course for CF as well, but it means you can not use CFFILE for user
uploads on top of IIS.

Well, unless you like having your server crash.

Trey Rouse
Data Application Architect
Web Services - Rice University

> -Original Message-
> From: Andrew Golden [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 13, 2003 12:35 PM
> To: CF-Talk
> Subject: CFFILE upload max. file size?
> 
> Does anyone know if there is a maximum file size that can be
transferred
> using CFFILE to upload? What is the largest anyone has ever had
repeated
> success with? Any help would be appreciatedthanks!
> 
> Andrew Golden
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: DTS to update SQL Server database?

2003-06-11 Thread jon hall
I've found out the best way is usually determined by the
circumstances. How much does a client want to pay...how technical is
the other side, do you want realtime, pseudo-realtime, or batched
updates, firewalls, etc.

In my perfect world though, in a batch situation, with a small update,
the publishing side would fire a DTS that connected to the remote side
and updated the data. This one takes very little time to setup, and
doesn't place the constraints that replication does on the schema. It
also can be done manually or automated, so it's flexible.

-- 
 jon
 mailto:[EMAIL PROTECTED]

Wednesday, June 11, 2003, 3:12:04 PM, you wrote:
DH> Hi all,

DH> Can someone explain? Is it better to use DTS, replication, or FTP to update
DH> SQL Server 2K database files on a shared host? (The database is small; there
DH> will only be about 50 new records each week.)

DH> TIA,
DH> ~Dina



DH> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to use ExpandPath

2003-06-11 Thread Mike Townend
What you can do is set them in the Application.cfm and assign them to a
variable, then at any point you have a reference to the root... Ie

Application.cfm




Upload.cfm



Etc



-Original Message-
From: Mike Mertsock [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 20:27
To: CF-Talk
Subject: How to use ExpandPath


>If you want relative to the current template you can use
>
>GetCurrentTemplatePath()
>
>I usually use that with GetDirectoryFromPath() wrapped around it in my 
>Application.cfm page for things like image upload paths
>
>
>ExpandPath() is for converting the URL script name into an absolute 
>path
>
>HTH
>
Oh i see. So ExpandPath's argument is a like a relative URL. But those other
two functions are so freakin long to type!

MM 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: active edit alternatives

2003-06-11 Thread Trey Rouse
We've had some problems using realObjects in a test rollout on campus.

Everybody has failed to mention what is hands down the best product...

http://www.ephox.com/

Take a look at EditLive! For Java.  Hands down the cleanest TTW WYSWYG
I've worked with.

Our current solution is from Ektron using the empower/ewebeditpro
solution.  Its not pretty, but coupling it with some 2003 Terminal
servers, an emulator from HobSoft, and a little slight of hand, we are
delivering the activeX controls out to our mac/unix clients.

This solution has been less than ideal, and we are currently developing
a EditLive! solution to replace our Ektron based product.

Simply put, Ektron has given us 16 months of broken promises to deliver
a cross platform solution.  There was a rumored java version that they
never let into beta, and there is a Flash object that lacks link library
and image support, which we have designated as core requirements of any
TTW WYSIWYG solution.

Good luck,

Trey Rouse
Data Application Architect
Web Services - Rice University


> -Original Message-
> From: joe hobson [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 10:18 AM
> To: CF-Talk
> Subject: active edit alternaitves
> 
> Thanks for the realObjects suggestion. That's the only one i've seen
so
> far that's cross-platform. activEdit gives their excuse about the Mac
not
> supporting LiveConnect while realObjects finds a work around for the
> issue. So who would you trust for maintaing excellent future
development?
> 
> But i still don't understand why there isn't a basic Flash-based
WYSIWYG
> editor out there, which theoretically could overcome the browser and
> platform compatibility issues much easier. If anyone knows of one,
please
> speak up.
> 
> On a related note, does anyone use activSpell, outside of activEdit?
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



How to use ExpandPath

2003-06-11 Thread Mike Mertsock
>If you want relative to the current template you can use
>
>GetCurrentTemplatePath()
>
>I usually use that with GetDirectoryFromPath() wrapped around it in my
>Application.cfm page for things like image upload paths
>
>
>ExpandPath() is for converting the URL script name into an absolute path
>
>HTH
>
Oh i see. So ExpandPath's argument is a like a relative URL. But those other two 
functions are so freakin long to type!

MM
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



DTS to update SQL Server database?

2003-06-11 Thread Dina Hess
Hi all,

Can someone explain? Is it better to use DTS, replication, or FTP to update
SQL Server 2K database files on a shared host? (The database is small; there
will only be about 50 new records each week.)

TIA,
~Dina



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Chris Kief
Jillian,

Another thing you may run across is the situation where you don't know
what's going to be in that list because it's being generated by another
query. In that case, the trick is to use a sub-query like so:

SELECT DISTINCT Description
FROMVCT
WHERE   description NOT IN (SELECT something FROM SomethingElse)
ORDER BY Description

chris



>-Original Message-
>From: Bryan Love [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 11, 2003 11:42 AM
>To: CF-Talk
>Subject: RE: SQL Question - Could CF make this easier?
>
>sure, the IN and NOT IN clauses are much faster than using multiple ANDs,
>but don't transfer the load to CF - allow the DB to do what it's best at...
>
>
>SELECT DISTINCT Description
>FROM   VCT
>WHERE  description NOT IN ('ANISE','APPLES','ASPARAGUS','BEETS','BROCCOLI')
>ORDER BY Description
>
>
>+---+
>Bryan Love
>  Database Analyst
>  Macromedia Certified Professional
>  Internet Application Developer
>TeleCommunication Systems
>[EMAIL PROTECTED]
>+---+
>
>"...'If there must be trouble, let it be in my day, that my child may have
>peace'..."
>   - Thomas Paine, The American Crisis
>
>"Let's Roll"
>   - Todd Beamer, Flight 93
>
>
>
>-Original Message-
>From: Jillian Carroll [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 11, 2003 11:37 AM
>To: CF-Talk
>Subject: SOT: SQL Question - Could CF make this easier?
>
>
>I am creating a drop-down list of items, but I want to keep several items
>from appearing in the drop-down.
>
>Is there a more efficient way to accomplish this (there will be several
>more
>exclusions):
>
>
>SELECT DISTINCT
>   Description
>FROM   VCT
>ORDER BY
>   Description
>WHERE  description != 'ANISE'
>   AND description != 'APPLES'
>   AND description != 'ASPARAGUS'
>   AND description != 'BEETS'
>   AND description != 'BROCCOLI'
>
>
>--
>Jillian
>
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMX on Cobalt RaQ550

2003-06-11 Thread Costas Piliotis
I have a client of mine who has colocated his server, and the colo facility
is having trouble installing cfmx onto that box running the "Linux 2.4
Multitasking operating systen" as Sun calls it.

They've apparantly installed it on other Cobalt servers, but are having
major troubles with this one...

Has anyone gotten CFMX to work on this appliance?  Anything quirky in the
installation I should be aware of?  

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: populate the damn array

2003-06-11 Thread Ian Skinner
Just a quick guess from what I remember when I've done stuff like this, try
putting your temp struct in the loop.

 

Manifest=Replace(manifest, chr(09), ";", "ALL");
ListFileLen=ListLen(Manifest,  "#chr(10)##chr(13)#");
container = ArrayNew(1);

for (y=1; y LTE ListFileLen; y=y+1)...;
ad = StructNew();   //Placing this here
allows it to be cleared each time.
ad.attribute_name="#ListGetAt(ListFileText, 2, ";")#";
ad.ad_id="#ListGetAt(ListFileText,
3, ";")#";
ad.display_text="Caption";

ad.attribute_cdata="#ListGetAt(ListFileText, 4, ";")#";

ad.startdate="#ListGetAt(ListFileText, 5, ";")#";

ad.stopdate="#ListGetAt(ListFileText, 5, ";")#";

containerAds = ArrayAppend(container, ad);

}
 

--
Ian Skinner
Web Programmer
BloodSource
Sacramento, CA


-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:33 AM
To: CF-Talk
Subject: populate the damn array


OK, this probably something real stupid, but I'm not seeing it ... 

This code takes a tabbed file and is supposed to parse it into an array of
structures.

The problem is, the array is populating with 36 elements of the same data.
Whatever the last item in the file is, that because the repeated element ...
which means that each array append is overwriting previous data, or
something like that ... below is the complete code ... can anyone see what
the error is? Probably something simple and stupid:

 

Manifest=Replace(manifest, chr(09), ";", "ALL");
ListFileLen=ListLen(Manifest,  "#chr(10)##chr(13)#");
container = ArrayNew(1);
ad = StructNew();

for (y=1; y LTE ListFileLen; y=y+1) {
ListFileText="#ListGetAt(Manifest, y,
"#chr(10)##chr(13)#")#";

ad.attribute_name="#ListGetAt(ListFileText, 2, ";")#";
ad.ad_id="#ListGetAt(ListFileText,
3, ";")#";
ad.display_text="Caption";

ad.attribute_cdata="#ListGetAt(ListFileText, 4, ";")#";

ad.startdate="#ListGetAt(ListFileText, 5, ";")#";

ad.stopdate="#ListGetAt(ListFileText, 5, ";")#";

containerAds = ArrayAppend(container, ad);

}
 

~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: populate the damn array

2003-06-11 Thread Bryan Love
just move "ad = StructNew();" inside the for loop and problem solved.

The reason it's doing that is because you only declared structNew once.
When you declare structNew it causes the variable (ad) to point to a memory
address (let's use 0x1234 for this example).
You then add this memory address to the array 36 times so you have an array
where each item points to the exact same memory space.  The last loop of the
for loop sets the values in that memory space to the last item in the file
and so it will appear that all the array items are the same (which they are)
and they all point to the last item from the file.

Put structNew inside the for loop and each iteration of the list will give
"ad" a new memory pointer and each array item will be unique.

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:33 AM
To: CF-Talk
Subject: populate the damn array


OK, this probably something real stupid, but I'm not seeing it ... 

This code takes a tabbed file and is supposed to parse it into an array of
structures.

The problem is, the array is populating with 36 elements of the same data.
Whatever the last item in the file is, that because the repeated element ...
which means that each array append is overwriting previous data, or
something like that ... below is the complete code ... can anyone see what
the error is? Probably something simple and stupid:

 

Manifest=Replace(manifest, chr(09), ";", "ALL");
ListFileLen=ListLen(Manifest,  "#chr(10)##chr(13)#");
container = ArrayNew(1);
ad = StructNew();

for (y=1; y LTE ListFileLen; y=y+1) {
ListFileText="#ListGetAt(Manifest, y,
"#chr(10)##chr(13)#")#";

ad.attribute_name="#ListGetAt(ListFileText, 2, ";")#";
ad.ad_id="#ListGetAt(ListFileText,
3, ";")#";
ad.display_text="Caption";

ad.attribute_cdata="#ListGetAt(ListFileText, 4, ";")#";

ad.startdate="#ListGetAt(ListFileText, 5, ";")#";

ad.stopdate="#ListGetAt(ListFileText, 5, ";")#";

containerAds = ArrayAppend(container, ad);

}
 

~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: One search for Spidered Pages, Oracle & Basis DBs

2003-06-11 Thread Ryan Kime
I've done something like this. I've got a page-based collection and some
varying DB-based collections. Depending on the parameters passed, it will
add the collections to a list and then use the collection param of cfsearch
to display the list. Then you get a nice unified result set with the
"custom" being used by each collection to drill down through the data. Keep
in mind though that the more collections you add, the slower it gets.

As for the multiple datasource idea from Stephen, I'm not sure. 

Ryan

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 12:46 PM
To: CF-Talk
Subject: Re: One search for Spidered Pages, Oracle & Basis DBs


Okay, can you give me a hint as to how to populate a collection with more
than one datasource? I thought that you had to feed  a
(single) query object.

If you can indeed only feed it a single query object, do you propose I unify
two queries from separate datasources? If so, do you know a better way than
looping one of the queries and doing query functions to append rows?

Okay, say I do get both of these DBs indexed in the same collection, are you
saying it's also possible to get my Verity K2 spidered index in there as
well!? :-/

Thanks,
Jamie

On Wed, 11 Jun 2003 18:04:50 +0100, in cf-talk you wrote:

>Jamie,
>
>Why not use one Verity collection which is populated by data from your 
>multiple datasources.  Use one of the custom field to specify which 
>datasource the record came from.
>
>That way you use CFSearch to get your a result set with title, summary 
>and all the good stuff.  When the user wants to see the record itself 
>you use the record id, held in the key field in your collection, and 
>the datasource identifier from one of the custom fields to decide what 
>page to display or what database to get the single record from.
>
>That should be a damn site more speedy than querying and trying to 
>output from 3 disperate datasources. ;o)
>
>Stephen
>
>- Original Message -
>From: "Jamie Jackson" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, June 11, 2003 5:52 PM
>Subject: Re: One search for Spidered Pages, Oracle & Basis DBs
>
>
>> Nevermind, this should be pretty straightforward. I think I'll just 
>> do three search routines on the results page, which will return three 
>> different blocks of results. Also, maybe I'll cfflush to give 'em 
>> something to look at while it takes forever. ;-)
>>
>> Thanks,
>> Jamie
>>
>> On Wed, 11 Jun 2003 11:16:29 -0400, in cf-talk you wrote:
>>
>> >Looking for ideas regarding the creation of a single search 
>> >interface that (at once) searches pages, Oracle & Basis DBs.
>> >
>> >Is anybody doing this?
>> >
>> >Thanks,
>> >Jamie
>> >
>> 
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: SQL Question - Could CF make this easier?

2003-06-11 Thread CF Dude
You could create a SPROC to do it like this.

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO


CREATE PROCEDURE getDescriptions()

AS

SET NOCOUNT ON

 SELECT DISTINCT 
  description
 FROM vct
 WHERE description 
 NOT IN (
  'ANISE', 'APPLES', 'ASPARAGUS', 'BEETS', 'BROCCOLI'
  )
 ORDER BY 
  description
END 

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


- Original Message - 
From: "Bryan Love" <[EMAIL PROTECTED]>


sure, the IN and NOT IN clauses are much faster than using multiple ANDs,
but don't transfer the load to CF - allow the DB to do what it's best at...


SELECT DISTINCT Description 
FROM VCT 
WHERE description NOT IN ('ANISE','APPLES','ASPARAGUS','BEETS','BROCCOLI')
ORDER BY Description


+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:37 AM
To: CF-Talk
Subject: SOT: SQL Question - Could CF make this easier?


I am creating a drop-down list of items, but I want to keep several items
from appearing in the drop-down.

Is there a more efficient way to accomplish this (there will be several more
exclusions):


SELECT DISTINCT 
Description 
FROM VCT 
ORDER BY 
Description
WHERE description != 'ANISE'
AND description != 'APPLES'
AND description != 'ASPARAGUS'
AND description != 'BEETS'
AND description != 'BROCCOLI'


--
Jillian




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Bryan Love
sure, the IN and NOT IN clauses are much faster than using multiple ANDs,
but don't transfer the load to CF - allow the DB to do what it's best at...


SELECT DISTINCT Description 
FROMVCT 
WHERE   description NOT IN ('ANISE','APPLES','ASPARAGUS','BEETS','BROCCOLI')
ORDER BY Description


+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:37 AM
To: CF-Talk
Subject: SOT: SQL Question - Could CF make this easier?


I am creating a drop-down list of items, but I want to keep several items
from appearing in the drop-down.

Is there a more efficient way to accomplish this (there will be several more
exclusions):


SELECT DISTINCT 
Description 
FROMVCT 
ORDER BY 
Description
WHERE   description != 'ANISE'
AND description != 'APPLES'
AND description != 'ASPARAGUS'
AND description != 'BEETS'
AND description != 'BROCCOLI'


--
Jillian



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



populate the damn array

2003-06-11 Thread Owens, Howard
OK, this probably something real stupid, but I'm not seeing it ... 

This code takes a tabbed file and is supposed to parse it into an array of
structures.

The problem is, the array is populating with 36 elements of the same data.
Whatever the last item in the file is, that because the repeated element ...
which means that each array append is overwriting previous data, or
something like that ... below is the complete code ... can anyone see what
the error is? Probably something simple and stupid:

 

Manifest=Replace(manifest, chr(09), ";", "ALL");
ListFileLen=ListLen(Manifest,  "#chr(10)##chr(13)#");
container = ArrayNew(1);
ad = StructNew();

for (y=1; y LTE ListFileLen; y=y+1) {
ListFileText="#ListGetAt(Manifest, y,
"#chr(10)##chr(13)#")#";

ad.attribute_name="#ListGetAt(ListFileText, 2, ";")#";
ad.ad_id="#ListGetAt(ListFileText,
3, ";")#";
ad.display_text="Caption";

ad.attribute_cdata="#ListGetAt(ListFileText, 4, ";")#";

ad.startdate="#ListGetAt(ListFileText, 5, ";")#";

ad.stopdate="#ListGetAt(ListFileText, 5, ";")#";

containerAds = ArrayAppend(container, ad);

}
 

~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



SOT: SQL Question - Could CF make this easier?

2003-06-11 Thread Jillian Carroll
I am creating a drop-down list of items, but I want to keep several items
from appearing in the drop-down.

Is there a more efficient way to accomplish this (there will be several more
exclusions):


SELECT DISTINCT 
Description 
FROMVCT 
ORDER BY 
Description
WHERE   description != 'ANISE'
AND description != 'APPLES'
AND description != 'ASPARAGUS'
AND description != 'BEETS'
AND description != 'BROCCOLI'


--
Jillian


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Displaying PDFs

2003-06-11 Thread Douglas.Knudsen
>-Original Message-
>From: Paige Chandler [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, June 11, 2003 2:12 PM
>To: CF-Talk
>Subject: Displaying PDFs
>
>
>Hello All,
>
>
>When displaying a .pdf file can that be accomplished by 
>"calling" it from a
>button or does it have to be "called" from a image - .jpg for 
>instance? 
>
>The below is page 13 of my web sit. As you can see it calls 
>page 14 or page
>15
>
>FileExists(ExpandPath("./Images/#Trim(Session.Client_ID)##Trim(Session
>Insured_ID)#2.jpg"))>
> Search1" 
>onClick="window.location='http:\CVS3WP14.CFM'"> 
> Search1" onClick="window.location='http:\CVS3WP15.CFM'"> 
>
> Search1" onClick="window.location='http:\CVS3WP14.CFM'"> 
>
>
>
>Page 14 is now coded as:
> 
>
>face="Arial">"/Images/#Trim(Session
>Client_ID)##Trim(Session.Insured_ID)#1.pdf"
>
> 
>It displays the code not the image.  What am I doing wrong?  TIA.
>
>Paige

The code does not display an image nor is a PDF an image.  Your code is creating a 
standard link to your PDF file.  If you want to display the actual PDF file, look into 
the CFCONTENT tag.  

Doug


>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfdump raw data

2003-06-11 Thread Raymond Camden
Just an FYI, I released a newer version of the code, although in custom
tag format. It allows you to filter out or show only particular
struct/columns. Useful when dumping a large number of fat
structures/queries. You can download it from my blog.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, June 11, 2003 11:52 AM
> To: CF-Talk
> Subject: RE: cfdump raw data
> 
> 
> Look at Rays dump tag
> 
> http://www.cflib.org/udf.cfm?ID=619 code included
> 
> WG
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Displaying PDFs

2003-06-11 Thread Paige Chandler
Hello All,


When displaying a .pdf file can that be accomplished by "calling" it from a
button or does it have to be "called" from a image - .jpg for instance? 

The below is page 13 of my web sit. As you can see it calls page 14 or page
15


  
  

  



Page 14 is now coded as:
 

"/Images/#Trim(Session
Client_ID)##Trim(Session.Insured_ID)#1.pdf"

 
It displays the code not the image.  What am I doing wrong?  TIA.

Paige
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfdump raw data

2003-06-11 Thread Jim Davis
Well - if you want to store it or something you could use CFSAVECONTENT
to grab it all.

Jim Davis
President, http://www.depressedpress.com
Webmaster, http://www.firstnight.org
Webmaster, http://www.cfAdvocacy.org
Senior Consultant, http://www.metlife.com


> -Original Message-
> From: Scott Mulholland [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 1:41 PM
> To: CF-Talk
> Subject: RE: cfdump raw data
> 
> Correct.  I don't think I explained it well. I am trying to get an
> answer to this for someone else, here was their explanation to me:
> 
> Yes, it is an XML package.  But you know how CFDUMP will render the
> ENTIRE
> CONTENTS of an xml package regardless of the unpredictable number of
> levels
> or nested structures?  I was hoping that someone knew how to replicate
> that
> functionality while exposing the output to CFML.
> 
> -Original Message-
> From: Critz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 12:01 PM
> To: CF-Talk
> Subject: Re: cfdump raw data
> 
> 
> oi Scott!!
> 
> well you are inputing(sp?) a variable into cfdump, no?
> 
> 
> 
> 
> 
> Wednesday, June 11, 2003, 12:56:10 PM, you wrote:
> 
> SM> Is there a way to access the data cfdump uses as a variable of
some
> SM> sort?
> 
> SM> Thanks,
> SM> Scott
> 
> SM>
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: louisville cfug members

2003-06-11 Thread Dave Lyons
I guess several people asked if it could be moved because Thursdays were
bad.

Anyway, there wont be another meeting until around September.
I didn't get an email either but I wasn't supposed to be here so I just
checked the website.

Rick will be sending out an email about when the next meeting will be.

Dave



- Original Message -
From: "Stephenie Hamilton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 9:52 AM
Subject: RE: louisville cfug members


> Huh? Since when? Wtf?? I didn't even get an email about the new day.. Is
> it always going to be on tues now? 
>
>
> ~~
> Stephenie Hamilton
> Macromedia Certified ColdFusion Professional
> CFXHosting
>
>
>
>
>
> -Original Message-
> From: Dave Lyons [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 9:46 PM
> To: CF-Talk
> Subject: louisville cfug members
>
>
> Just want to take a second and thank you all for not showing up and
> allowing me to take home all of the prizes & give-aways tonight! Granted
> I was hoping paul would be there so I could win my monthly supply of
> cdr's, haha
>
> But seriously, it was tonight & not Thursday night, just fyi
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.488 / Virus Database: 287 - Release Date: 6/5/2003
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfdump raw data

2003-06-11 Thread webguy
Look at Rays dump tag

http://www.cflib.org/udf.cfm?ID=619 code included

WG


-Original Message-
From: Scott Mulholland [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 18:41
To: CF-Talk
Subject: RE: cfdump raw data


Correct.  I don't think I explained it well. I am trying to get an
answer to this for someone else, here was their explanation to me:

Yes, it is an XML package.  But you know how CFDUMP will render the
ENTIRE
CONTENTS of an xml package regardless of the unpredictable number of
levels
or nested structures?  I was hoping that someone knew how to replicate
that
functionality while exposing the output to CFML.

-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 12:01 PM
To: CF-Talk
Subject: Re: cfdump raw data


oi Scott!!

well you are inputing(sp?) a variable into cfdump, no?





Wednesday, June 11, 2003, 12:56:10 PM, you wrote:

SM> Is there a way to access the data cfdump uses as a variable of some
SM> sort?

SM> Thanks,
SM> Scott

SM>


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: One search for Spidered Pages, Oracle & Basis DBs

2003-06-11 Thread Jamie Jackson
Okay, can you give me a hint as to how to populate a collection with
more than one datasource? I thought that you had to feed  a
(single) query object.

If you can indeed only feed it a single query object, do you propose I
unify two queries from separate datasources? If so, do you know a
better way than looping one of the queries and doing query functions
to append rows?

Okay, say I do get both of these DBs indexed in the same collection,
are you saying it's also possible to get my Verity K2 spidered index
in there as well!? :-/

Thanks,
Jamie

On Wed, 11 Jun 2003 18:04:50 +0100, in cf-talk you wrote:

>Jamie,
>
>Why not use one Verity collection which is populated by data from your
>multiple datasources.  Use one of the custom field to specify which
>datasource the record came from.
>
>That way you use CFSearch to get your a result set with title, summary and
>all the good stuff.  When the user wants to see the record itself you use
>the record id, held in the key field in your collection, and the datasource
>identifier from one of the custom fields to decide what page to display or
>what database to get the single record from.
>
>That should be a damn site more speedy than querying and trying to output
>from 3 disperate datasources. ;o)
>
>Stephen
>
>- Original Message - 
>From: "Jamie Jackson" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, June 11, 2003 5:52 PM
>Subject: Re: One search for Spidered Pages, Oracle & Basis DBs
>
>
>> Nevermind, this should be pretty straightforward. I think I'll just do
>> three search routines on the results page, which will return three
>> different blocks of results. Also, maybe I'll cfflush to give 'em
>> something to look at while it takes forever. ;-)
>>
>> Thanks,
>> Jamie
>>
>> On Wed, 11 Jun 2003 11:16:29 -0400, in cf-talk you wrote:
>>
>> >Looking for ideas regarding the creation of a single search interface
>> >that (at once) searches pages, Oracle & Basis DBs.
>> >
>> >Is anybody doing this?
>> >
>> >Thanks,
>> >Jamie
>> >
>> 
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfdump raw data

2003-06-11 Thread Scott Mulholland
Correct.  I don't think I explained it well. I am trying to get an
answer to this for someone else, here was their explanation to me:

Yes, it is an XML package.  But you know how CFDUMP will render the
ENTIRE 
CONTENTS of an xml package regardless of the unpredictable number of
levels 
or nested structures?  I was hoping that someone knew how to replicate
that 
functionality while exposing the output to CFML.

-Original Message-
From: Critz [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 12:01 PM
To: CF-Talk
Subject: Re: cfdump raw data


oi Scott!!

well you are inputing(sp?) a variable into cfdump, no?





Wednesday, June 11, 2003, 12:56:10 PM, you wrote:

SM> Is there a way to access the data cfdump uses as a variable of some 
SM> sort?
 
SM> Thanks,
SM> Scott

SM> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Weird XMLTransform error (long)

2003-06-11 Thread Massimo, Tiziana e Federica
> Correct. As I read the XSL spec, there's no difference between
> 
> bar
> 
> and
> 
>   
> 
I am just wild guessing here, have you tried this?:

bar


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re[2]: counting to 5-problem

2003-06-11 Thread cf-talk
It is an announcement
the customer wants to send
out.
All eMail-adresses are double-opt-in
adresses.
It is more the wish of the customer, not
to send more than 5 to the same company.
It doesn't matter which 5. There shouldn't
be a special rule to detect them.

Uwe

Hello STEVEN,

Wednesday, June 11, 2003, 6:19:50 PM, you wrote:

DSJA> My question would be how do you determine which 5?

DSJA> If you had a list of 10 people, would only the first 5 get the e-mail?  Why
DSJA> would you want to prevent the others from getting the e-mail if they signed
DSJA> up for it?


DSJA> -Original Message-
DSJA> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
DSJA> Sent: Wednesday, June 11, 2003 8:53 AM
DSJA> To: CF-Talk
DSJA> Subject: counting to 5-problem 


DSJA> We are having
DSJA> an eMailing-List where
DSJA> quite e few people do have
DSJA> eMail-adresses from the same
DSJA> companies. Now we want to send out
DSJA> eMails only to 5 people of
DSJA> the same company but not more.
DSJA> The sixth eMail-adress should be marked (with a checkbox or s.th.
DSJA> else).
DSJA> The fields are eMail and company.
DSJA> How can I do this ?
DSJA> I don't have an idea yet.
DSJA> Can someone help me ?
DSJA> Uwe


DSJA> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Matthew Small
Well, I don't of any WDDX objects for ASP.NET but there could be one, I
don't know for sure.  I don't think that there would be one because
ASP.NET has web services by default and WDDX is kind of a pre-web
service technology.

I still think that consuming the CFMX service in ASP.NET is going to be
tedious job.

Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 12:45 PM
To: CF-Talk
Subject: Re: Consuming CFMX Web Services in ASP.NET

just a thought...  what about wddx?


- Original Message - 
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 12:19 PM
Subject: RE: Consuming CFMX Web Services in ASP.NET


> I don't imagine that the .NET datatable and the CFMX recordset are
> compatible by nature, but I've never tried so I don't know for sure.
I
> think that the data is passable, but that your friend will have to
> explicitly loop through the XML object and find his data manually, or
> write a small object that will do it for him.
>
> Questions:
> 1. Is he definitely retrieving data from the webservice through CFMX?
> 2. How is he attempting to read the data?
>
>
> Matthew Small
> IT Director
> Showstopper American Dance Championships
> [EMAIL PROTECTED]
> 843-357-1847
>
>
> -Original Message-
> From: Murat Demirci [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 11:57 AM
> To: CF-Talk
> Subject: RE: Consuming CFMX Web Services in ASP.NET
>
> Any response?
>
>
>
> -Original Message-
> From: Murat Demirci [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 10:21 AM
> To: CF-Talk
> Subject: Consuming CFMX Web Services in ASP.NET
>
>
> My friend has a problem when calling a web service method which
returns
> CFMX
> query object.
>
> When I return a query object from CFC function, .NET cannot get the
> recordset object.
>
> I'm using CFMX U3.
>
> Any experiences?
>
>
>
>
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

2003-06-11 Thread Buddy
Okay so I have been handed a problem resulting from code that someone else
wrote, I'm sure some of you can sympathize. Hopefully some of you might also
have some advice.

We run a report every month, this month it is much bigger then usual.
Normally it takes a while to do, but never has any errors, this month it is
taking a while then erroring out. The file in question does a big query on
the main database, then does a bunch of queries of a query based on the
original query. The main query looks like this:

Select SIGNUPS, TDATE, SITEID,WMID from DATA
WHERE TDATE> #CreateODBCDateTime(MASTERLASTPAY)# and TDATE<=
#CreateODBCDateTime(ENDDATE)# and signups > 0

Simple, no problems there. Here is the error:

unknown exception condition

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (116:4) to (116:51) in the template
file E:\blah\blah

Line 116 where the error resides looks like this:

Select SIGNUPS from
SELECTMASTERDATA WHERE ((TDATE>'#STARTDATE#') and (TDATE<= '#ENDDATE2#')
and (WMID='#ID#'))

Again, nothing seems wrong here.

The thing that troubles me is that it will process a ton of rows and then
seemingly error out at random, one time on the 500th row and the 750th the
next time. And I think it might have something to do with the load on the
box at the time.

I have seen that error referenced in regards to q of q, but a lot of the
problems people are having seem to have to do with locking, and I don't have
anything to lock, so I don't think that is it.

Any advice would be greatly appreciated.
-Buddy



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: One search for Spidered Pages, Oracle & Basis DBs

2003-06-11 Thread Stephen Moretti
Jamie,

Why not use one Verity collection which is populated by data from your
multiple datasources.  Use one of the custom field to specify which
datasource the record came from.

That way you use CFSearch to get your a result set with title, summary and
all the good stuff.  When the user wants to see the record itself you use
the record id, held in the key field in your collection, and the datasource
identifier from one of the custom fields to decide what page to display or
what database to get the single record from.

That should be a damn site more speedy than querying and trying to output
from 3 disperate datasources. ;o)

Stephen

- Original Message - 
From: "Jamie Jackson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 5:52 PM
Subject: Re: One search for Spidered Pages, Oracle & Basis DBs


> Nevermind, this should be pretty straightforward. I think I'll just do
> three search routines on the results page, which will return three
> different blocks of results. Also, maybe I'll cfflush to give 'em
> something to look at while it takes forever. ;-)
>
> Thanks,
> Jamie
>
> On Wed, 11 Jun 2003 11:16:29 -0400, in cf-talk you wrote:
>
> >Looking for ideas regarding the creation of a single search interface
> >that (at once) searches pages, Oracle & Basis DBs.
> >
> >Is anybody doing this?
> >
> >Thanks,
> >Jamie
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cfdump raw data

2003-06-11 Thread Critz
oi Scott!!

well you are inputing(sp?) a variable into cfdump, no?





Wednesday, June 11, 2003, 12:56:10 PM, you wrote:

SM> Is there a way to access the data cfdump uses as a variable of some
SM> sort?
 
SM> Thanks,
SM> Scott

SM> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cfdump raw data

2003-06-11 Thread Scott Mulholland
Is there a way to access the data cfdump uses as a variable of some
sort?
 
Thanks,
Scott

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Image Scroller....

2003-06-11 Thread Che Vilnonis
Does anyone know of a custom tag that can query a db for pictures
and then display thumbnails of them that automatically 'scroll' to
the left/right. (Much like a javascript/java news scroller.)

When a thumbnail is clicked, a pop-up window display a larger image.

Thanks...
Ché

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: One search for Spidered Pages, Oracle & Basis DBs

2003-06-11 Thread Jamie Jackson
Nevermind, this should be pretty straightforward. I think I'll just do
three search routines on the results page, which will return three
different blocks of results. Also, maybe I'll cfflush to give 'em
something to look at while it takes forever. ;-)

Thanks,
Jamie

On Wed, 11 Jun 2003 11:16:29 -0400, in cf-talk you wrote:

>Looking for ideas regarding the creation of a single search interface
>that (at once) searches pages, Oracle & Basis DBs.
>
>Is anybody doing this?
>
>Thanks,
>Jamie
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: ArrayDeleteAt for a 2d array?

2003-06-11 Thread Bryan Love
If you are going to have many values stored for each item in the array then
you may also be better off using an array of structs instead of an array of
arrays  A struct can store unlimited key value pairs so you'd end up
with code like this instead...











You can reference the values like this...

x[1].userID
x[1].userName
x[2].userID
 and so on

+---+
Bryan Love
  Database Analyst
  Macromedia Certified Professional
  Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:15 PM
To: CF-Talk
Subject: RE: ArrayDeleteAt for a 2d array?


Perfect, Brian.  I do indeed have to save more than 2 items to each row.  I
was trying ArrayDeleteAt but screwing up the syntax.  Thanks very much for
your help yesterday and today nursemaiding me thru this.

In case its useful to anyone poking around in the archives some day, here's
the template I used to test the creation and deletion of 2d array items.









 
 


 
 



 
 
 
 
 



Click Plain to add array items

 
del #i#

Plain





---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---


-- Original Message --
From: Bryan Love <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 10 Jun 2003 15:28:02 -0700

>Here you go.  By the way, if you are only storing two values you would be
>much better off using a single array where, say, odd indices are the userID
>and even indices are the username.  Then you could do something like this
>(it doesn't buy you much here, but if you do other manipulations it could
>save you some headaches):
>
>   from="1" 
>   to="#ArrayLen(LoginArray)#" 
>   index="ArrayRows"
>   step="2">
>   
>
>   
>   
>   
>   
> 
>
>
>
>but here is the answer to your original question:
>
>
>   from="1" 
>   to="#ArrayLen(LoginArray)#" 
>   index="ArrayRows">
>   
>
>   
>   
>   
>
>
>+---+
>Bryan Love
>  Database Analyst
>  Macromedia Certified Professional
>  Internet Application Developer
>TeleCommunication Systems
>[EMAIL PROTECTED]
>+---+
>
>"...'If there must be trouble, let it be in my day, that my child may have
>peace'..."
>   - Thomas Paine, The American Crisis
>
>"Let's Roll"
>   - Todd Beamer, Flight 93
>
>
>
>-Original Message-
>From: Matt Robertson [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, June 10, 2003 2:50 PM
>To: CF-Talk
>Subject: ArrayDeleteAt for a 2d array?
>
>
>How do you loop over a *2d* array and delete a single row (and all its
>elements), where that row is determined by a test of the contents.  Like
so:
>
>
>
>   from="1" 
>   to="#ArrayLen(LoginArray)#" 
>   index="ArrayRows">
>   
>
>   
>   
>
>
>I've been fighting a losing battle with this all afternoon.
>
>---
> Matt Robertson, [EMAIL PROTECTED]
> MSB Designs, Inc. http://mysecretbase.com
>---
> 
> 
>
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Michael Tangorre
just a thought...  what about wddx?


- Original Message - 
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 12:19 PM
Subject: RE: Consuming CFMX Web Services in ASP.NET


> I don't imagine that the .NET datatable and the CFMX recordset are
> compatible by nature, but I've never tried so I don't know for sure.  I
> think that the data is passable, but that your friend will have to
> explicitly loop through the XML object and find his data manually, or
> write a small object that will do it for him.
>
> Questions:
> 1. Is he definitely retrieving data from the webservice through CFMX?
> 2. How is he attempting to read the data?
>
>
> Matthew Small
> IT Director
> Showstopper American Dance Championships
> [EMAIL PROTECTED]
> 843-357-1847
>
>
> -Original Message-
> From: Murat Demirci [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 11:57 AM
> To: CF-Talk
> Subject: RE: Consuming CFMX Web Services in ASP.NET
>
> Any response?
>
>
>
> -Original Message-
> From: Murat Demirci [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 10:21 AM
> To: CF-Talk
> Subject: Consuming CFMX Web Services in ASP.NET
>
>
> My friend has a problem when calling a web service method which returns
> CFMX
> query object.
>
> When I return a query object from CFC function, .NET cannot get the
> recordset object.
>
> I'm using CFMX U3.
>
> Any experiences?
>
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Matthew Small
I don't imagine that the .NET datatable and the CFMX recordset are
compatible by nature, but I've never tried so I don't know for sure.  I
think that the data is passable, but that your friend will have to
explicitly loop through the XML object and find his data manually, or
write a small object that will do it for him.

Questions:
1. Is he definitely retrieving data from the webservice through CFMX?
2. How is he attempting to read the data?


Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 

-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 11:57 AM
To: CF-Talk
Subject: RE: Consuming CFMX Web Services in ASP.NET

Any response?



-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 10:21 AM
To: CF-Talk
Subject: Consuming CFMX Web Services in ASP.NET


My friend has a problem when calling a web service method which returns
CFMX
query object.
 
When I return a query object from CFC function, .NET cannot get the
recordset object.
 
I'm using CFMX U3.
 
Any experiences?





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT but urgent - Killing Process/service

2003-06-11 Thread webguy
Check out  ps tools

http://www.sysinternals.com/ntw2k/freeware/pstools.shtml

You should try to do net stop "service namme" (as listed by net start)

WG


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 17:33
To: CF-Talk
Subject: RE: OT but urgent - Killing Process/service


The resource kit has a utility called "Kill" that can force kill a process.
If you do a google search you can probably come up with a download (it's a
tiny command line program).

-mk

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:19 AM
To: CF-Talk
Subject: OT but urgent - Killing Process/service


We have a small program running on one of our remote servers and we can not
seem to kill/stop the process. It was written by a previous emplyee in C++.
Is there anyway to stop it? When trying to stop it from the services area in
NT just hangs... we would like to not have to reboot this server until
tonight when the load is minimal... anyone know a way to kill the process?

Its an NT 2K Server box.

Thanks,

Michael Tangorre



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT but urgent - Killing Process/service

2003-06-11 Thread Lomvardias Christopher
Use PsKill http://www.sysinternals.com/ntw2k/freeware/pskill.shtml


-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 12:19 PM
To: CF-Talk
Subject: OT but urgent - Killing Process/service


We have a small program running on one of our remote servers and we can not
seem to kill/stop the process. It was written by a previous emplyee in C++.
Is there anyway to stop it? When trying to stop it from the services area in
NT just hangs... we would like to not have to reboot this server until
tonight when the load is minimal... anyone know a way to kill the process?

Its an NT 2K Server box.
 
Thanks,

Michael Tangorre


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT but urgent - Killing Process/service

2003-06-11 Thread Critz
oi Michael!!

use cfexecute to run a batch file that

net stop "service name"





Wednesday, June 11, 2003, 12:18:57 PM, you wrote:

MT> We have a small program running on one of our remote servers and we can not seem 
to kill/stop the process. It was written by a previous emplyee in C++. Is there anyway 
to stop it? When trying to
MT> stop it from the services area in NT just hangs... we would like to not have to 
reboot this server until tonight when the load is minimal... anyone know a way to kill 
the process?

MT> Its an NT 2K Server box.
 
MT> Thanks,

MT> Michael Tangorre

MT> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT but urgent - Killing Process/service

2003-06-11 Thread Dave Watts
> We have a small program running on one of our remote servers 
> and we can not seem to kill/stop the process. It was written 
> by a previous emplyee in C++. Is there anyway to stop it? 
> When trying to stop it from the services area in NT just 
> hangs... we would like to not have to reboot this server 
> until tonight when the load is minimal... anyone know a way 
> to kill the process?
> 
> Its an NT 2K Server box.

There are plenty of kill utilities. The Windows 2000 Resource Kit comes with
one or two; you can download pskill and pslist from
http://www.sysinternals.com/.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT but urgent - Killing Process/service

2003-06-11 Thread Matthew Small
PSKill will do the trick, I'm sure.

http://www.sysinternals.com/ntw2k/freeware/pskill.shtml


Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 12:19 PM
To: CF-Talk
Subject: OT but urgent - Killing Process/service

We have a small program running on one of our remote servers and we can
not seem to kill/stop the process. It was written by a previous emplyee
in C++. Is there anyway to stop it? When trying to stop it from the
services area in NT just hangs... we would like to not have to reboot
this server until tonight when the load is minimal... anyone know a way
to kill the process?

Its an NT 2K Server box.
 
Thanks,

Michael Tangorre


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: OT but urgent - Killing Process/service

2003-06-11 Thread Mark A. Kruger - CFG
The resource kit has a utility called "Kill" that can force kill a process.
If you do a google search you can probably come up with a download (it's a
tiny command line program).

-mk

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:19 AM
To: CF-Talk
Subject: OT but urgent - Killing Process/service


We have a small program running on one of our remote servers and we can not
seem to kill/stop the process. It was written by a previous emplyee in C++.
Is there anyway to stop it? When trying to stop it from the services area in
NT just hangs... we would like to not have to reboot this server until
tonight when the load is minimal... anyone know a way to kill the process?

Its an NT 2K Server box.

Thanks,

Michael Tangorre


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: counting to 5-problem

2003-06-11 Thread Michael Tangorre
they want them all to go, just 5 at a time I imagine. I am assuming this is
to prevent alerting the network guys of a SPAM attack  :-)


- Original Message - 
From: "DURETTE, STEVEN J (AIT)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 12:19 PM
Subject: RE: counting to 5-problem


> My question would be how do you determine which 5?
>
> If you had a list of 10 people, would only the first 5 get the e-mail?
Why
> would you want to prevent the others from getting the e-mail if they
signed
> up for it?
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 11, 2003 8:53 AM
> To: CF-Talk
> Subject: counting to 5-problem
>
>
> We are having
> an eMailing-List where
> quite e few people do have
> eMail-adresses from the same
> companies. Now we want to send out
> eMails only to 5 people of
> the same company but not more.
> The sixth eMail-adress should be marked (with a checkbox or s.th.
> else).
> The fields are eMail and company.
> How can I do this ?
> I don't have an idea yet.
> Can someone help me ?
> Uwe
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: counting to 5-problem

2003-06-11 Thread DURETTE, STEVEN J (AIT)
My question would be how do you determine which 5?

If you had a list of 10 people, would only the first 5 get the e-mail?  Why
would you want to prevent the others from getting the e-mail if they signed
up for it?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 8:53 AM
To: CF-Talk
Subject: counting to 5-problem 


We are having
an eMailing-List where
quite e few people do have
eMail-adresses from the same
companies. Now we want to send out
eMails only to 5 people of
the same company but not more.
The sixth eMail-adress should be marked (with a checkbox or s.th.
else).
The fields are eMail and company.
How can I do this ?
I don't have an idea yet.
Can someone help me ?
Uwe


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



OT but urgent - Killing Process/service

2003-06-11 Thread Michael Tangorre
We have a small program running on one of our remote servers and we can not seem to 
kill/stop the process. It was written by a previous emplyee in C++. Is there anyway to 
stop it? When trying to stop it from the services area in NT just hangs... we would 
like to not have to reboot this server until tonight when the load is minimal... 
anyone know a way to kill the process?

Its an NT 2K Server box.
 
Thanks,

Michael Tangorre

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Murat Demirci
Any response?



-Original Message-
From: Murat Demirci [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 10:21 AM
To: CF-Talk
Subject: Consuming CFMX Web Services in ASP.NET


My friend has a problem when calling a web service method which returns CFMX
query object.
 
When I return a query object from CFC function, .NET cannot get the
recordset object.
 
I'm using CFMX U3.
 
Any experiences?




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Regarding ExpandPath

2003-06-11 Thread Paige Chandler
Hello All,

Many thanks. I finally got it working.

Matthew Walker's suggestion to debug was a great help:

!#ExpandPath("Images\#Trim(Session.Client_ID)##Trim(Session.Insure
d_ID)#1.jpg")#!

I finally determined that I had to put the "Images" subdirectory under my main 
sub"CVS". I had it as a sub outside of CVS
 and ExpandPath insisted on expanding .../CVS/Images/.
instead of .../Images/

Regards,

Paige
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Coldfusion server not installing jrun.dll

2003-06-11 Thread Petr Kysela
Has any of you had problem installing CF server on IIS/Win 2000? When I
install it, it doesn't put "jrun.dll" in this folder at all:
C:\CFusionMX\runtime\lib\wsconfig\1
 
Any idea why it wouldn't basically install itself, and then upon
completion it majestically opens cf administrator with an error(page
can't be displayed).
 
cheers
 
Petr

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cfftp

2003-06-11 Thread Stephen Moretti
> oi Stephen!!
>
> but  I  gathered  from  his message(could be wrong... not first time) that
cf was the client logging
> INTO  an  ftp  server,  right?  so  rights  has nothing to do with CF...
it has something to do with
> permissions on the server.  I don't see how which account CFServer is
setup as being a factor..??
>

The error message from the FTP server is :
"An exception occurred when performing the FTP putfile operation.
The cause of this exception was that: c:\cftptest.txt (Permission denied)"

Hmmm re-reading the error message and the context I suspect you're right.

Looks like the user specified in the CFFTP command does not have access to
the location that its trying to write to.  So that'd mean that either user
doesn't have the appropriate rights all round or just to the path that CFFTP
is trying write the file to.

Robert says that he can put the file up there himself and the error message
would suggest that CFFTP is logging in just fine, then I'd suggest looking
to make sure that CFFTP is definately navigating to the correct folder to
put the file.

Sorry about the confusion Robert.

Regards

Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to use ExpandPath

2003-06-11 Thread Angel Stewart
This helped much! Thanks!
:)
I didn't even know I needed help 
but I just made a little file upload routine I was writing a lot more
efficient 
than hardcoding an Application variable called imagepath.

-Gel


-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED] 

If you want relative to the current template you can use

GetCurrentTemplatePath()

I usually use that with GetDirectoryFromPath() wrapped around it in my
Application.cfm page for things like image upload paths


ExpandPath() is for converting the URL script name into an absolute path

HTH

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



One search for Spidered Pages, Oracle & Basis DBs

2003-06-11 Thread Jamie Jackson
Looking for ideas regarding the creation of a single search interface
that (at once) searches pages, Oracle & Basis DBs.

Is anybody doing this?

Thanks,
Jamie
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to use ExpandPath

2003-06-11 Thread webguy
BTW you should add the contextroot to URLS too .
Check out Seans blog for details, www.corfield.org

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: 11 June 2003 16:11
To: CF-Talk
Subject: RE: How to use ExpandPath


If you want relative to the current template you can use

GetCurrentTemplatePath()

I usually use that with GetDirectoryFromPath() wrapped around it in my
Application.cfm page for things like image upload paths


ExpandPath() is for converting the URL script name into an absolute path

HTH



-Original Message-
From: Mike Mertsock [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 16:05
To: CF-Talk
Subject: How to use ExpandPath


Yes, the fact that it's relative to the *base* template caused me untold
frustration before I found that out. What is the strategy behind it working
that way, instead of being relative from the current template? It does not
make for easy-to-read code.

Mike Mertsock
Alfred University Web Team


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: How to use ExpandPath

2003-06-11 Thread Mike Townend
If you want relative to the current template you can use

GetCurrentTemplatePath()

I usually use that with GetDirectoryFromPath() wrapped around it in my
Application.cfm page for things like image upload paths


ExpandPath() is for converting the URL script name into an absolute path

HTH



-Original Message-
From: Mike Mertsock [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 16:05
To: CF-Talk
Subject: How to use ExpandPath


Yes, the fact that it's relative to the *base* template caused me untold
frustration before I found that out. What is the strategy behind it working
that way, instead of being relative from the current template? It does not
make for easy-to-read code.

Mike Mertsock
Alfred University Web Team

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



How to use ExpandPath

2003-06-11 Thread Mike Mertsock
Yes, the fact that it's relative to the *base* template caused me untold frustration 
before I found that out. What is the strategy behind it working that way, instead of 
being relative from the current template? It does not make for easy-to-read code.

Mike Mertsock
Alfred University Web Team
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cfftp

2003-06-11 Thread Critz
oi Stephen!!

but  I  gathered  from  his message(could be wrong... not first time) that cf was the 
client logging
INTO  an  ftp  server,  right?  so  rights  has nothing to do with CF... it has 
something to do with
permissions on the server.  I don't see how which account CFServer is setup as being a 
factor..??





Wednesday, June 11, 2003, 9:09:23 AM, you wrote:

>> oi Stephen!!
>>
>> if he's logging into an ftp server via cf... I wouldn't think that would
SM> matter, no?
>>
SM> Well the logging in is fine, but looking at the error message he gave it
SM> would indicate that CF doesn't have access to the file (c:\cfftptest.txt)
SM> that he wants to move.

SM> This isn't a function of the CFFTP tag, but of the user under which CF is
SM> being run.
SM> Best practice security says that you should run CF under a specific user
SM> which only has access to certain things (things being folders, files,
SM> registry entries etc), but even then I believe that SYSTEM has a restricted
SM> view on the world anyway.

SM> Stephen



SM> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Weird XMLTransform error (long)

2003-06-11 Thread Massimo Foti
> > Unless you provide default value for them, it throws an error.
> Correct. As I read the XSL spec, there's no difference between
>
> bar
>
> and
>
>   

Have you tried both and only the second one works? I am definitely not an
XSLT expert, but I always used the "select" attribute


> However this is either incorrect, or the transform engine doesn't
> recognize it as such. When I use the later format, it works just fine.
> So it appears that the error is worded incorrectly. It should have said
> something to the effect of "Parameter is undefined" if that's the
> error, rather than telling me to correct a statement that didn't exist.

Well, it would be nice if every error message would be correct and
relevant...


> > BTW XmlTransform() doesn't allows you to pass parameters to an XSLT
> > file, if
> > you would like to work around this, check:
> Right again, but I'm not passing parameters in to the XMLTransform
> call. I'm using Dan Switzer's xslt UDF (
> http://cflib.org/udf.cfm?ID=899) as the workaround.
>
> >  if
> > you would like to work around this, check:
> >
> > http://www.cfmentor.com/code/index.cfm?action=script&id=123
> Your code throws two variable undefined errors. This are eliminated if
> you change the names of the input variables to "xmlstring" and
> "xslstring" from "xmlinput" and "xslinput" respectively.

Ooops! Thanks for the pointer
I just fixed it, shame on me I forgot to scope those variables...


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



ServerInfo v3.4 Utility

2003-06-11 Thread Andrew Penhorwood
I have created a free CF Server Utility which can be downloaded at

http://www.kaleo.biz/Kaleo_Download.cfm

It displays information in the following areas: CF Server, Web Server, OS 
platform, Java platform and CF Server Locale Support (sorted and grouped 
alphabetically)

On the CF Server MX the updater is displayed in plain English (e.g. updater 
1 2 or 3).

The above link has a demo version running for those who want to see it in 
action.

Andrew Penhorwood
[EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: conversion of Access datatypes in the query

2003-06-11 Thread Matthew Small
Thanks, Mike, you jarred my memory.  STR() works just fine in Access.
CAST does not.

Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 10:19 AM
To: CF-Talk
Subject: RE: conversion of Access datatypes in the query

Havnt tried this, but it might be possible to use CStr()... i.e.
CStr(integerfield) as sFoo

Or maybe the Cast(integerfield as varchar) altho Im not sure that will
work

HTH



-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 15:12
To: CF-Talk
Subject: conversion of Access datatypes in the query


Hi everyone - 
I need to be able to convert both a datetime field and an
integer
field to strings in a query (for concatenation with a string
field) but I can't remember how to do it.

Select datetimefield + stringfield + integerfield as stringtype from
table

Any help?


Matthew Small
IT Director
Showstopper American Dance Championships [EMAIL PROTECTED]
843-357-1847
 





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: conversion of Access datatypes in the query

2003-06-11 Thread CF Dude
This is from the tSql BOL, so I don't know if this will work w/Access or not.

CAST ( expression AS data_type ) 

E

- Original Message - 
From: "Matthew Small" <[EMAIL PROTECTED]>


Hi everyone - 
I need to be able to convert both a datetime field and an
integer field to strings in a query (for concatenation with a string
field) but I can't remember how to do it.

Select datetimefield + stringfield + integerfield as stringtype from
table

Any help?


Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: conversion of Access datatypes in the query

2003-06-11 Thread Marius Milosav
Opps, I didn't see the Access requirement. The convert function is working
in SQL, I don't know about Access


- Original Message -
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:11 AM
Subject: conversion of Access datatypes in the query


> Hi everyone -
> I need to be able to convert both a datetime field and an
> integer field to strings in a query (for concatenation with a string
> field) but I can't remember how to do it.
>
> Select datetimefield + stringfield + integerfield as stringtype from
> table
>
> Any help?
>
>
> Matthew Small
> IT Director
> Showstopper American Dance Championships
> [EMAIL PROTECTED]
> 843-357-1847
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: conversion of Access datatypes in the query

2003-06-11 Thread Marius Milosav
use the convert function

select convert (varchar (11), datetimefield) + stringfield + convert
(varchar (10) ,integerfield )

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm


- Original Message -
From: "Matthew Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:11 AM
Subject: conversion of Access datatypes in the query


> Hi everyone -
> I need to be able to convert both a datetime field and an
> integer field to strings in a query (for concatenation with a string
> field) but I can't remember how to do it.
>
> Select datetimefield + stringfield + integerfield as stringtype from
> table
>
> Any help?
>
>
> Matthew Small
> IT Director
> Showstopper American Dance Championships
> [EMAIL PROTECTED]
> 843-357-1847
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Get the mailserver that powers this list at 
http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: conversion of Access datatypes in the query

2003-06-11 Thread Mike Townend
Havnt tried this, but it might be possible to use CStr()... i.e.
CStr(integerfield) as sFoo

Or maybe the Cast(integerfield as varchar) altho Im not sure that will work

HTH



-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 15:12
To: CF-Talk
Subject: conversion of Access datatypes in the query


Hi everyone - 
I need to be able to convert both a datetime field and an integer
field to strings in a query (for concatenation with a string
field) but I can't remember how to do it.

Select datetimefield + stringfield + integerfield as stringtype from table

Any help?


Matthew Small
IT Director
Showstopper American Dance Championships [EMAIL PROTECTED]
843-357-1847
 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: i will sell domain cftop.com

2003-06-11 Thread Thomas Chiverton
On Friday 06 Jun 2003 21:55 pm, Ian Skinner wrote:

> across the pond reverse the comma and period in numbers US 100,000.00
> equals European 100.000,00.

Err... no.

-- 
Tom C
"Land of the free, home of the brave... you have to be brave to live there and 
enjoy the freedoms"
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



conversion of Access datatypes in the query

2003-06-11 Thread Matthew Small
Hi everyone - 
I need to be able to convert both a datetime field and an
integer field to strings in a query (for concatenation with a string
field) but I can't remember how to do it.

Select datetimefield + stringfield + integerfield as stringtype from
table

Any help?


Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: louisville cfug members

2003-06-11 Thread Ben Doom
Dang it.  I was even going up to Louisville for a business trip today.
Probably going to be there Thurs. night.  Was going to try to talk my boss
(who is also going on the trip) into us attending.  :-(


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, June 11, 2003 9:53 AM
: To: CF-Talk
: Subject: RE: louisville cfug members
:
:
: Huh? Since when? Wtf?? I didn't even get an email about the new day.. Is
: it always going to be on tues now? 
:
:
: ~~
: Stephenie Hamilton
: Macromedia Certified ColdFusion Professional
: CFXHosting
:
:
:
:
:
: -Original Message-
: From: Dave Lyons [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, June 10, 2003 9:46 PM
: To: CF-Talk
: Subject: louisville cfug members
:
:
: Just want to take a second and thank you all for not showing up and
: allowing me to take home all of the prizes & give-aways tonight! Granted
: I was hoping paul would be there so I could win my monthly supply of
: cdr's, haha
:
: But seriously, it was tonight & not Thursday night, just fyi
:
:
: ---
: Outgoing mail is certified Virus Free.
: Checked by AVG anti-virus system (http://www.grisoft.com).
: Version: 6.0.488 / Virus Database: 287 - Release Date: 6/5/2003
:
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: louisville cfug members

2003-06-11 Thread Dan Phillips
Yeah, I didn't get an email either. 

Dan Phillips
www.CFXHosting.com 
1-866-239-4678
[EMAIL PROTECTED]

-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 11, 2003 9:53 AM
To: CF-Talk
Subject: RE: louisville cfug members


Huh? Since when? Wtf?? I didn't even get an email about the new day.. Is
it always going to be on tues now? 


~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
CFXHosting





-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 10, 2003 9:46 PM
To: CF-Talk
Subject: louisville cfug members


Just want to take a second and thank you all for not showing up and
allowing me to take home all of the prizes & give-aways tonight! Granted
I was hoping paul would be there so I could win my monthly supply of
cdr's, haha

But seriously, it was tonight & not Thursday night, just fyi


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.488 / Virus Database: 287 - Release Date: 6/5/2003
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



  1   2   >