Re: Java class called from CF errors

2005-07-15 Thread James Holmes
If the same keystore file works in a java app but not in CF, something
else is going on.

On 7/15/05, Taco <[EMAIL PROTECTED]> wrote:
> Certainly did, a few times actually.
> 
> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 14 July 2005 4:49 PM
> To: CF-Talk
> Subject: Re: Java class called from CF errors
> 
> Did you restart the CF server after adding the cert to the keystore?
> 
> On 7/14/05, Taco <[EMAIL PROTECTED]> wrote:
> > Hi,
> > Yeah actually tried that, no luck..
> >
> > Funny thing is no matter whether I refer to the CF or Java keystore
> running
> > the class with main() works like a charm.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212059
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: web services advice

2005-07-15 Thread James Holmes
In the CF admin you need to refresh the webservice that is defined
automatically when you invoke that URL. CF is caching the stub and
doesn't see the new methods/arguments/whatever when the webservice
changes unless the refresh is done.

On 7/15/05, Simon Smith <[EMAIL PROTECTED]> wrote:

> 
> adds two args (user and password) to call and cfc page 
> 
>  webservice ="http://172.20.2.100/ws/conveyancing/cfcs/LMSintroducer.cfc?wsdl";
> method ="myIntroducers"
> l_id="1100,1104"
> maxRecords="3"
> user="as"
> pwd="as"
> returnVariable="foo">
> 
> and fails (
> Web service operation "myIntroducers" with parameters 
> {PWD={as},L_ID={1100,1104},USER={as},MAXRECORDS={3},} could not be found. )
> )
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212058
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Delivery barcode

2005-07-15 Thread James Holmes
I tried barbeque, using the servlet that they supply as part of the
package. It took about a minute to install into CF and it worked with
just a reboot, no trouble. It's a really good solution if you are
using Enterprise (and can therefore run servlets). If you can't run
servlets you can still write CF that does the work with the barbecue
java classes.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212057
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Triggering MSSQL DTS from CF

2005-07-15 Thread Dan G. Switzer, II
Jamie,

>
>I'd like to upload a file to the CFMX server, then run a MSSQL DTS on that
>file to insert/scrub it.
>

Here's what I've done in the past to run a DTS script from SQL. I
occasionally get people telling me it didn't work for them, but I think
that's usually a permission issue:

http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS

- Dan

.
: Dan G. Switzer, II   :
: e-mail:  [EMAIL PROTECTED] :
: url: http://www.pengoworks.com/  :
: blog:    http://blog.pengoworks.com/ :
: _            :
:    |_) _  _  _  _ |  | _  _|_  _ :
:    |  (/_| )(_|(_)|/\|(_)| |\ _) :
:  _|  :
:...




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212056
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Cfmx and 5 on the same development server

2005-07-15 Thread Willie Fleischman
Hi all,
  We are running CFMX and CF5 on the same Win2k server, used a hack so that
we could run them both through IIS5.0.  Everything was fine until today when
all of a sudden MX stopped working.  Now MX can't find any files.  We get
the following data regardless of what directory or file we attempt to view
through IE.  Any suggestions?
 
Thanks,
Willie
 

Error Occurred While Processing Request  
File not found: /directory/index.cfm  
 
  
Please try the following: 
Check the ColdFusion documentation to verify that you are using the correct
syntax. 
Search the Knowledge Base to find a solution to your problem. 
 
 
Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322) 
Remote Address   192.168.1.1 
Referrer
Date/Time   15-Jul-05 04:07 PM 
 
Stack Trace (click to expand)  
 
 
 
coldfusion.runtime.TemplateNotFoundException: File not found:
/directory/index.cfm
 at coldfusion.filter.PathFilter.invoke(PathFilter.java:77)
 at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
 at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
 at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence
Filter.java:28)
 at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
 at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
 at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
 at coldfusion.CfmServlet.service(CfmServlet.java:105)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
 at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
 at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
 at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
 at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
 at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
 
 
 
 
 
 
 
 
 
 



Debugging Information ColdFusion Server Standard 6,1,0,hf53813_61 
Template  /plannernet/index.cfm 
Time Stamp  15-Jul-05 04:07 PM 
Locale  English (US) 
User Agent  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322) 
Remote IP  192.168.1.1 
Host Name  192.168.1.1 
 
 
 



Execution Time
 
No top level page was found. 
 



Exceptions
 
16:07:36.036 - coldfusion.runtime.TemplateNotFoundException - in : line -1
 File not found: /plannernet/index.cfm
 
 



Scope Variables
 
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\http\plannerNet\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword,
application/x-shockwave-flash, */*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=2406; CFTOKEN=38882518
HTTP_HOST=mx.crdnl.com
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET
CLR 1.1.4322)
PATH_INFO=/directory/index.cfm
PATH_TRANSLATED=D:\http\directory\index.cfm
QUERY_STRING=
REMOTE_ADDR=192.168.1.1
REMOTE_HOST=192.168.1.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/index.cfm
SERVER_NAME=mx.crdnl.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=
 
Cookie Variables:
CFID=2406
CFTOKEN=38882518
 
Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)
 
Debug Rendering Time: 301 ms


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212055
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Catching errors and emailing

2005-07-15 Thread Dave Watts
> Email is about as secure as a standard web page is and I 
> don't know many people who have 'real' security for their 
> logs, admin or the like. SSL costs.

For administrative purposes, a self-signed certificate will do just fine.
That doesn't cost anything.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212054
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF7 Install Woes

2005-07-15 Thread Steven Erat
Ok, you might want to try starting ColdFusion with strace to see all
the system calls, which might help identify the problem.

For example, 
strace /opt/coldfusionmx7/bin/coldfusion start

This will output lots of stuff the console, but when the info stops
rushing by you the point of failure might near the end.

Of course, I'm sure you know that CentOS is not supported or tested by
Macromedia, nor is RHEL 4, so I have a to chide you a bit that this
information should have been in the first post because the subject
line belies the fact that the reason you might be having install woes
could be that its because you're not on a supported OS.  I just think
it creates unnecessary FUD on the list when posting such a blanketing
subject line without pointing this out.

Anyway .let me know if you find anything interesting with strace.



On 7/15/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> Yeah, you bet Steven.  You meant a `grep` in the `ps` command, right?
> The output you want is listed below.  I've also include a shutdown
> message (which is indicitive of a problem).  Note that the
> /opt/coldfusionmx7/runtime/logs directory never gets anything written
> to it; it dies out before that happens, only
> /opt/coldfusionmx7/logs/cfserver.log is ever created.
> 
> The linux is CentOS 4.1.  Basically a free (as in beer) recompile of
> RHEL 4's [free as in speech] SRPMS with the word 'redhat' removed.
> This was a fresh install, and SELinux is entirely disabled on the
> system (because it causes problems, as you're well aware).
> 
> thanks,
> barneyb

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212053
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Jann E. VanOver
But doesn't SSL seem like a small cost in the light of all the credit 
card fraud stories going around?

I took Matt's advice when I set up this kind of error logging for a 
customer a few months ago.  I already had an area of the website with 
security in order to process credit cards, I added an admin login area 
there to browse error logs.

I do NOT want credit card numbers leaked from any of my sites, OR my 
customer's Verisign password or login (which MIGHT be kept in a request 
variable and therefore dumped with the error logging info).

Thanks Matt!  I use most of your logging code also -- nice stuff.

Michael Dinowitz wrote:

>Email is about as secure as a standard web page is and I don't know many 
>people who have 'real' security for their logs, admin or the like. SSL costs.
>
>  
>
>>Something you might want to consider is that, if you are emailing
>>errors to yourself via cfdump, those dumps could contain info that 
>>you
>>might be a little leery of sending free/clear over a non-secure email.
>>
>>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212052
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Matt Robertson
On 7/15/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
> Email is about as secure as a standard web page is and I don't know many 
> people who have 'real' security for their logs, admin or the like. SSL costs.

I agree that few people do it but in this day and age, when you can
get a cheapo 128-bit cert for $14.95 (ev1servers.net) and a decent one
for only a little more (as a comodo reseller I pay about US$45) it
seems like thats a mighty small price to pay to secure some
potentially sensitive info.



-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212051
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing (new Question)

2005-07-15 Thread Matt Robertson
On 7/15/05, Aldon <[EMAIL PROTECTED]> wrote:
> How do I catch server response when an email is accepted for delivery?

I don't believe there is any direct way to do that.  Maybe something
like iMS can if used in place of CFMail.  That program can do just
about everything else you'd ever want...

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212050
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Michael Dinowitz
Email is about as secure as a standard web page is and I don't know many people 
who have 'real' security for their logs, admin or the like. SSL costs.

> Something you might want to consider is that, if you are emailing
> errors to yourself via cfdump, those dumps could contain info that 
> you
> might be a little leery of sending free/clear over a non-secure email.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212049
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Detect if Session Management is enabled?

2005-07-15 Thread Dave Watts
> The try/catch method is the only one that seems to work, and 
> is going to write to error logs right?

No, it won't automatically write to error logs. That's up to you. You can do
that using the CFLOG tag.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212048
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Matt Robertson
Something you might want to consider is that, if you are emailing
errors to yourself via cfdump, those dumps could contain info that you
might be a little leery of sending free/clear over a non-secure email.
 Not just things like form variables of a form post blows up (which
could expose yucky things like unencrypted credit card numbers).

One solution to that is to store the errors on disk and then notify
yourself of the occurrence of the error -- but not its specifics --
via email.  Then you go to your top secret -- and secured -- error
handling area, log in and see the errors (or log in via terminal
server and view them thataway).

The code below does the dumping thing pretty thoroughly.  It could be
written more sparingly but I just snipped it out of something a lot
bigger.  It will loop thru a large list of potential scopes and dump
them all out to a single variable via cfcontent.  You can then plug
that variable value into an email, or a cffile statement as you
please.  Dumping the variables scope like this also means that any
queries you run get dumped as well and, while this can be very helpful
it can also be a mighty big file... not something you might want to
email for size reasons.

Typical size of one of these in email is 80-350k, but the sky is the
limit.  Still I prefer the verbose logging as too much info is usually
better than the reverse.

I wrote up the whole procedure start to finish at
http://mysecretbase.com/Building_A_ColdFusion_Error_Handler.cfm and am
currently writing something a little more streamlined for release as a
custom tag that can be used either site wide or app-wide.


// ---
// ERROR HANDLER VARIABLES
// ---
variables.ErrorHandler=StructNew();
// the list of scopes to loop thru.
variables.ErrorHandler.vars="CFCATCH,ERROR,APPLICATION,ATTRIBUTES,CALLER,CGI,CLIENT,FORM,REQUEST,SESSION,THIS,THISTAG,URL,VARIABLES";







 
 


-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212047
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Damien McKenna
> > Out of that list, the ones I think are the most likely 
> > suspects are the C/C++ runtimes (MSVCP60.DLL, MSVCRT.DLL).
> 
> That makes a lot of sense.  I got the vcredist.exe file but it won't
> execute.  I'll find some way of getting them on there.

Well it turned out that those DLLs *are* in place.  Darn.  I'll work on
it over the weekend I guess.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212046
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Detect if Session Management is enabled?

2005-07-15 Thread Loathe
The try/catch method is the only one that seems to work, and is going to
write to error logs right?

I did isDefined('session') which came back YES.

Unfortunately we aren't doing CF 7 development on this one :(

Tim

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 6:05 PM
To: CF-Talk
Subject: RE: Detect if Session Management is enabled?


> How would you do this programmatically?

One easy way, offhand:






... Session management isn't enabled - do something!




Alternatively, you might test for the existence of the Session scope - I
don't know if that'll work, but it might:

...

Finally, in CFMX 7 the values that you'd set within your Application.cfc are
available as variables within it, although I'm not sure how (or if) they're
available outside the Application.cfc instance.

There may well be other, better methods, but this is what popped into my
head.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212045
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Damien McKenna
> Out of that list, the ones I think are the most likely 
> suspects are the C/C++ runtimes (MSVCP60.DLL, MSVCRT.DLL).

That makes a lot of sense.  I got the vcredist.exe file but it won't
execute.  I'll find some way of getting them on there.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212044
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Detect if Session Management is enabled?

2005-07-15 Thread Dave Watts
> How would you do this programmatically?

One easy way, offhand:






... Session management isn't enabled - do something!




Alternatively, you might test for the existence of the Session scope - I
don't know if that'll work, but it might:

...

Finally, in CFMX 7 the values that you'd set within your Application.cfc are
available as variables within it, although I'm not sure how (or if) they're
available outside the Application.cfc instance.

There may well be other, better methods, but this is what popped into my
head.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212043
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Damien McKenna
> Well, it sounds to me like your install is pretty hosed. If 
> possible, I'd recommend that you completely uninstall CFMX,
> delete any remaining registry keys, and try again

Thanks, Dave, that's what I'm attemping.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212042
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Detect if Session Management is enabled?

2005-07-15 Thread Loathe
How would you do this programmatically?

TIA

Tim Heald
Senior Web Developer
TeraTech, Inc.
2003 Winner CFDJ awards Best Consulting Service

Email: [EMAIL PROTECTED]
Voice: 1-301-424-3903 x111
Web:   http://www.teratech.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212041
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Dave Watts
> Did the install completely succeed?  Maybe you need to reboot?
> 
> Anyway - that DLL depends on:
> 
> ADVAPI32.DLL (system32 folder)
> CFINDEX.DLL 
> GDI32.DLL (system32 folder)
> KERNEL32.DLL (system32 folder)
> LIBALLRSEI.DLL (cfusionmx\lib folder)
> MSVCP60.DLL (system32 folder)
> MSVCRT.DLL (system32 folder)
> NTDLL.DLL (system32 folder)
> RPCRT4.DLL (system32 folder)
> USER32.DLL (system32 folder)
> VDK200.DLL (cfusionmx\lib folder)
> WS2HELP.DLL (system32 folder)
> WS2_32.DLL (system32 folder)
> WSOCK32.DLL (system32 folder)
> 
> Make sure that all of these DLLs exist on your server (some 
> can't be missing or Windows would not boot).

Out of that list, the ones I think are the most likely suspects are the
C/C++ runtimes (MSVCP60.DLL, MSVCRT.DLL).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212040
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Howie Hamlin
Did the install completely succeed?  Maybe you need to reboot?

Anyway - that DLL depends on:

ADVAPI32.DLL (system32 folder)
CFINDEX.DLL 
GDI32.DLL (system32 folder)
KERNEL32.DLL (system32 folder)
LIBALLRSEI.DLL (cfusionmx\lib folder)
MSVCP60.DLL (system32 folder)
MSVCRT.DLL (system32 folder)
NTDLL.DLL (system32 folder)
RPCRT4.DLL (system32 folder)
USER32.DLL (system32 folder)
VDK200.DLL (cfusionmx\lib folder)
WS2HELP.DLL (system32 folder)
WS2_32.DLL (system32 folder)
WSOCK32.DLL (system32 folder)

Make sure that all of these DLLs exist on your server (some can't be missing or 
Windows would not boot).

HTH,

Howie

- Original Message - 
From: "Damien McKenna" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, July 15, 2005 4:55 PM
Subject: cfindex.dll: Can't find dependent libraries


> I'm just after doing a fresh install of CFMX 6.1 on a Windows 2000
> Server with J2RE 1.4.x and have struck problems.  First off the ODBC
> services are not listed in the service manager.  Secondly CFM pages
> aren't being processed in IIS and the following error is in
> cfmx/logs/exception.log:
>  
> "Error","main","07/15/05","16:27:09",,"ColdFusion\lib\cfindex.dll: Can't
> find dependent libraries"


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212039
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Adam Haskell
And if that doesn't work call Marcomedia...install support is free :)

Adam H

On 7/15/05, Dave Watts <[EMAIL PROTECTED]> wrote: 
> Well, it sounds to me like your install is pretty hosed. If possible, I'd
> recommend that you completely uninstall CFMX, delete any remaining registry
> keys, and try again:
> 
> http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19187
> 
> However, if you simply want to diagnose the dependency problem, you can use
> Dependency Checker (depends.exe) to open the DLL and find what files it's
> looking for. Dependency Checker is available in the Windows 2000 Resource
> Kit I think, and may also be part of various versions of Visual Studio. It's
> bailed me out more than once. There's a freeware dependency checker here,
> but I don't know anything about it:
> 
> http://www.winsite.com/bin/Info?50008196
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212038
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Dave Watts
> I'm just after doing a fresh install of CFMX 6.1 on a Windows 2000
> Server with J2RE 1.4.x and have struck problems.  First off the ODBC
> services are not listed in the service manager.  Secondly CFM pages
> aren't being processed in IIS and the following error is in
> cfmx/logs/exception.log:
>  
> "Error","main","07/15/05","16:27:09",,"ColdFusion\lib\cfindex.
> dll: Can't find dependent libraries"
> java.lang.UnsatisfiedLinkError: ColdFusion\lib\cfindex.dll: 
> Can't find dependent libraries
>  at java.lang.ClassLoader$NativeLibrary.load(Native Method)
>  at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1560)

Well, it sounds to me like your install is pretty hosed. If possible, I'd
recommend that you completely uninstall CFMX, delete any remaining registry
keys, and try again:

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19187

However, if you simply want to diagnose the dependency problem, you can use
Dependency Checker (depends.exe) to open the DLL and find what files it's
looking for. Dependency Checker is available in the Windows 2000 Resource
Kit I think, and may also be part of various versions of Visual Studio. It's
bailed me out more than once. There's a freeware dependency checker here,
but I don't know anything about it:

http://www.winsite.com/bin/Info?50008196

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212037
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Damien McKenna
I should also mention that right after installing CFMX 6.1 (standalone +
IIS connector) it said it was going to open the admin to finish the
installation but never did.  Then I ran the 6.1 updater, that went fine.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212036
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


cfindex.dll: Can't find dependent libraries

2005-07-15 Thread Damien McKenna
I'm just after doing a fresh install of CFMX 6.1 on a Windows 2000
Server with J2RE 1.4.x and have struck problems.  First off the ODBC
services are not listed in the service manager.  Secondly CFM pages
aren't being processed in IIS and the following error is in
cfmx/logs/exception.log:
 
"Error","main","07/15/05","16:27:09",,"ColdFusion\lib\cfindex.dll: Can't
find dependent libraries"
java.lang.UnsatisfiedLinkError: ColdFusion\lib\cfindex.dll: Can't find
dependent libraries
 at java.lang.ClassLoader$NativeLibrary.load(Native Method)
 at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1560)
 at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1485)
 at java.lang.Runtime.loadLibrary0(Runtime.java:788)
 at java.lang.System.loadLibrary(System.java:834)
 at
coldfusion.verity.VerityServiceImpl.(VerityServiceImpl.java:51)
 at coldfusion.server.CFService.setupVerity(CFService.java:128)
 at coldfusion.server.CFService.start(CFService.java:336)
 at coldfusion.server.jrun4.NeoService.start(NeoService.java:47)
 at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
 at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
 at jrunx.kernel.ServiceAdapter.invokeMethod(ServiceAdapter.java:705)
 at
jrunx.kernel.JRunServiceDeployer.invokeOnServices(JRunServiceDeployer.ja
va:460)
 at
jrunx.kernel.JRunServiceDeployer.startServices(JRunServiceDeployer.java:
312)
 at
jrunx.kernel.JRunServiceDeployer.startLifecycle(JRunServiceDeployer.java
:260)
 at
jrunx.kernel.JRunServiceDeployer.deployServices(JRunServiceDeployer.java
:87)
 at
jrunx.kernel.DeploymentService.loadServices(DeploymentService.java:46)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
 at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
 at jrunx.kernel.JRun.startServer(JRun.java:568)
 at jrunx.kernel.JRun.(JRun.java:486)
 at jrunx.kernel.JRun$1.run(JRun.java:339)
 at java.security.AccessController.doPrivileged(Native Method)
 at jrunx.kernel.JRun.start(JRun.java:336)
 at jrunx.kernel.JRun.startByNTService(JRun.java:420)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at jrunx.kernel.JRun.invoke(JRun.java:180)
 at jrunx.kernel.JRun.main(JRun.java:168)

 
This is a server that's supposed to be shipped to a colo on Tuesday and
I'm totally stuck.  Any ideas anyone?  Thanks.
 
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
 
The Limu Company - http://www.thelimucompany.com/
  - 407-804-1014
#include 
 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212035
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Email CFDOCUMENT created PDF

2005-07-15 Thread Ian Skinner
IIRC there is a filename attribute to the cfdocument tag that will save the pdf 
as a file instead of streaming it to the client.  You should then easily be 
able to attach this file to the e-mail with cfmailparameter tags.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

-Original Message-
From: Doug Bedient [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 1:17 PM
To: CF-Talk
Subject: Email CFDOCUMENT created PDF

I want to create a PDF and email it. Has anyone done this. It seems like
it would be a no brainer but I can't figure it out. I can create the PDF
and I can send the email but how do you include the one with the other.
As far as I can tell you can't save the PDF to disk and dropping it in as
content does not work.

Thanks in advance,
Doug



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212034
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Email CFDOCUMENT created PDF

2005-07-15 Thread Doug Bedient
I want to create a PDF and email it. Has anyone done this. It seems like it 
would be a no brainer but I can't figure it out. I can create the PDF and I can 
send the email but how do you include the one with the other. As far as I can 
tell you can't save the PDF to disk and dropping it in as content does not work.

Thanks in advance,
Doug

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212033
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Doug Bedient
Yes it's already at 8 minutes. Which should be fine most the time but once in a 
while... If I go more than that it seems to puke. I would like to have a 
failsafe check.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212032
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF7 Install Woes

2005-07-15 Thread Barney Boisvert
Yeah, you bet Steven.  You meant a `grep` in the `ps` command, right? 
The output you want is listed below.  I've also include a shutdown
message (which is indicitive of a problem).  Note that the
/opt/coldfusionmx7/runtime/logs directory never gets anything written
to it; it dies out before that happens, only
/opt/coldfusionmx7/logs/cfserver.log is ever created.

The linux is CentOS 4.1.  Basically a free (as in beer) recompile of
RHEL 4's [free as in speech] SRPMS with the word 'redhat' removed. 
This was a fresh install, and SELinux is entirely disabled on the
system (because it causes problems, as you're well aware).

thanks,
barneyb

root:panama:/opt/coldfusionmx7/bin # ./coldfusion start
Starting ColdFusion MX 7...
The ColdFusion MX 7 server is starting up and will be available shortly.
==
ColdFusion MX 7 has been started.
ColdFusion MX 7 will write logs to /opt/coldfusionmx7/logs/cfserver.log
==

root:panama:/opt/coldfusionmx7/logs # cat cfserver.log
Starting Macromedia JRun 4 (Build 84683), coldfusion server
07/15 12:40:09 warning Unable to open
/opt/coldfusionmx7/runtime/lib/license.properties
07/15 12:40:13 info JRun Naming Service listening on *:2920

root:panama:/opt/coldfusionmx7/runtime/logs # lsof -i :2920
COMMAND   PID   USER   FD   TYPE DEVICE SIZE NODE NAME
cfmx7   20385 nobody7u  IPv6  90543   TCP *:2920 (LISTEN)
cfmx7   20386 nobody7u  IPv6  90543   TCP *:2920 (LISTEN)
cfmx7   20387 nobody7u  IPv6  90543   TCP *:2920 (LISTEN)
cfmx7   20388 nobody7u  IPv6  90543   TCP *:2920 (LISTEN)
 48 more lines

root:panama:/opt/coldfusionmx7/runtime/logs # ps -ef | grep cfmx
nobody   20383 1  0 12:40 pts/000:00:00
/opt/coldfusionmx7/bin/cfmx7 -jar cfusion.jar -autorestart -start
coldfusion
nobody   20385 20383  4 12:40 pts/000:00:08
/opt/coldfusionmx7/bin/cfmx7 -jar cfusion.jar -start coldfusion
nobody   20386 20385  0 12:40 pts/000:00:00
/opt/coldfusionmx7/bin/cfmx7 -jar cfusion.jar -start coldfusion
nobody   20387 20386  0 12:40 pts/000:00:00
/opt/coldfusionmx7/bin/cfmx7 -jar cfusion.jar -start coldfusion
 50 more lines

root:panama:/opt/coldfusionmx7/bin # ./coldfusion stop
Stopping ColdFusion MX 7, please wait
Stopping coldfusion server...could not stop server, either it's not
running, you don't have permission to stop the server or it needs to
be killed manually
The ColdFusion MX 7 server seems to be hanging, will stop non-gracefully
ColdFusion MX 7 has been stopped



On 7/15/05, Steven Erat <[EMAIL PROTECTED]> wrote:
> Can you post more information?  Perhaps the contents of the console
> window after starting up, then a ps -ef | cfmx, and perhaps do a live
> tail on all the jrun logs  during startup (tail -f
> /opt/coldfusionmx7/runtime/logs/*.log).
> 
> Also, what's the version of Linux?
> 
> -Steven Erat
> 
> 

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

Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212031
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Triggering MSSQL DTS from CF

2005-07-15 Thread jacksonj
I'd like to upload a file to the CFMX server, then run a MSSQL DTS on that file 
to insert/scrub it.

The file upload should be no problem, but how do I run a DTS from CF?

Also, after the file is uploaded, can anybody suggest how to make the file 
available to the MSSQL server (which is on a different machine from the Web 
server)?

Is this the wrong way to go? Is there some way that I can avoid 
transferring/exposing the file to MSSQL? Is there some clever way I could pass 
the data via SQL, maybe via a SPROC parameter, or some such thing?

It would be pretty cool if I could do something like the latter--bulk insert 
sorta inline data.

Thanks,
Jamie

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212030
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Join queries

2005-07-15 Thread Deanna Schneider
I've not used the flash forms at all yet. So, I don't think I can be
of great help. Sorry. Have you looked at the documentation to see if
it mentions anything about checkboxes?

On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> Yeah, i remember now why i did that weird thing with the loop - i
> couldn't seem to get it to work.
> 
> If I put the below in, the flash form will not load (although no
> error comes up either).
> 
>  
>   name="relationshipTypes" label="#relationshipTypeName#"
> value="#relationshipTypeID#">
>  
> 
> But if i add the _relationshipTypeID to make each name in the loop
> unique it comes up no problem.
> 
> Do you know why this is happening by any chance?  Is it a flash form
> problem?
> 
>  
>   name="relationshipTypes_#relationshipTypeID#"
> label="#relationshipTypeName#" value="#relationshipTypeID#">
>  
> 
> Thanks,
> 
> Stuart
> 
> ps: i've changed the attributes to relationshipTypes instead.
> 
> 
> On 15 Jul 2005, at 18:43, Deanna Schneider wrote:
> 
> > I don't use ms-sql, so I'm a bit rusty on the ansi standard left join
> > sytax. It'll look something like the below. (Note the change in the
> > from close, and the deletion of the one part of the where clause.)
> >
> > The a and p (and now l) are just aliases, so I don't have to type out
> > your tablenames over and over.
> >
> > As for your generating your checkboxes, there's no need to use
> > different checkbox names. Just do this:
> >  
> >  > name="attributes" label="#attributeName#" value="#attributeid#">
> > 
> >
> > On your action page, if any of the checkboxes have been selected, then
> > you'll get a comma-delimited list of all the checked ones. (If none
> > have been checked, form.attributes won't be there at all, so be
> > careful. Come to think of it, attributes is a reserved word, so call
> > it something else, too  - maybe "attributesDesired" or something.
> >
> > 
> > SELECT profileID, userID, profileTitle, gender,
> > genderSeeking, screenName, location, locationID, locationName, age,
> > confirmationID, imageName, imageAuthorisation
> >
> > FROM (tbl_020publicProfiles p LEFT OUTER JOIN
> > tbl_020publicProfilesAttributes a on p.profileid = a.profileid) INNER
> > JOIN tbl_020publicLocations l ON p.locationid = l.locationid
> >
> > WHERE gender = '#form.genderSeeking#' AND genderSeeking =
> > '#form.gender#' AND confirmationID = 'yes' AND userID <>
> >  > cfsqltype="cf_sql_integer" maxlength="4"> AND
> > tbl_020publicLocations.locationID =
> > tbl_020publicProfiles.location > form.location neq 0> AND location = '#form.location#' > isDefined('form.minAge') and form.minAge neq 0> AND age >=
> > #form.minAge# > neq 0> AND age <= #form.maxAge# > ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
> > imageAuthorisation = 1
> > AND a.attributeid IN ( > value="#form.attributeid#" list="yes")
> >ORDER by confirmationDate DESC
> >
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212029
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF7 Install Woes

2005-07-15 Thread Steven Erat
Can you post more information?  Perhaps the contents of the console
window after starting up, then a ps -ef | cfmx, and perhaps do a live
tail on all the jrun logs  during startup (tail -f
/opt/coldfusionmx7/runtime/logs/*.log).

Also, what's the version of Linux?  

-Steven Erat



On 7/15/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> I just rebuilt a server last night, and a fresh copy of CF7 standard
> refuses to run on it.  CF6.1 runs just dandy, but CF7 tries to start
> up, but only gets to the point of binding it's JNDI port, and then
> stops doing anything else.  It gives every indication it's started up
> successfully, but it hasn't.
> 
> I've tried using the installer fresh from the CD and the trial
> download from MM.com, and both behave this way.  I've also tried
> with/without the search services, RDS, Apache connector, etc.  And
> I've tried both a fresh install and an "upgrade" install of 6.1.
> 
> The server's linux, and if anyone's got any clever ideas, I'd really
> appreciate it.
> 
> thanks,
> barneyb

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212028
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Data Access in Flash... more

2005-07-15 Thread SStewart
Thanks, 

I kinda thought that's what I was doing.. like I said I'm VERY new to this...


sas

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep 
carcass... and thus the Pipes were born" 
 
 the Scottish Rogues


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 15, 2005 02:06 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low

Unless this is in a CF page or a FlashComm app, it simply won't work. Flash
doesn't have the capabilities or the integrated drivers to handle making
direct DB calls. 

The reason your script isn't throwing an error is because Flash assumes that
there's a custom class object named CF with a method called Query. I'd
strongly suggest looking at remoting for your middleware as this is easily
the best way to get dynamic data into flash.

Here's some instructions on CF.Query and other SSAS functions for future
reference:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=1496.htm 

Cheers,

Kevin

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212027
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Join queries

2005-07-15 Thread Saturday (Stuart Kidd)
Yeah, i remember now why i did that weird thing with the loop - i  
couldn't seem to get it to work.

If I put the below in, the flash form will not load (although no  
error comes up either).

 
 
 

But if i add the _relationshipTypeID to make each name in the loop  
unique it comes up no problem.

Do you know why this is happening by any chance?  Is it a flash form  
problem?

 
 
 

Thanks,

Stuart

ps: i've changed the attributes to relationshipTypes instead.


On 15 Jul 2005, at 18:43, Deanna Schneider wrote:

> I don't use ms-sql, so I'm a bit rusty on the ansi standard left join
> sytax. It'll look something like the below. (Note the change in the
> from close, and the deletion of the one part of the where clause.)
>
> The a and p (and now l) are just aliases, so I don't have to type out
> your tablenames over and over.
>
> As for your generating your checkboxes, there's no need to use
> different checkbox names. Just do this:
>  
>  name="attributes" label="#attributeName#" value="#attributeid#">
> 
>
> On your action page, if any of the checkboxes have been selected, then
> you'll get a comma-delimited list of all the checked ones. (If none
> have been checked, form.attributes won't be there at all, so be
> careful. Come to think of it, attributes is a reserved word, so call
> it something else, too  - maybe "attributesDesired" or something.
>
> 
> SELECT profileID, userID, profileTitle, gender,
> genderSeeking, screenName, location, locationID, locationName, age,
> confirmationID, imageName, imageAuthorisation
>
> FROM (tbl_020publicProfiles p LEFT OUTER JOIN
> tbl_020publicProfilesAttributes a on p.profileid = a.profileid) INNER
> JOIN tbl_020publicLocations l ON p.locationid = l.locationid
>
> WHERE gender = '#form.genderSeeking#' AND genderSeeking =
> '#form.gender#' AND confirmationID = 'yes' AND userID <>
>  cfsqltype="cf_sql_integer" maxlength="4"> AND
> tbl_020publicLocations.locationID =
> tbl_020publicProfiles.location form.location neq 0> AND location = '#form.location#' isDefined('form.minAge') and form.minAge neq 0> AND age >=
> #form.minAge# neq 0> AND age <= #form.maxAge# ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
> imageAuthorisation = 1
> AND a.attributeid IN ( value="#form.attributeid#" list="yes")
>ORDER by confirmationDate DESC
>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212026
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CF7 Install Woes

2005-07-15 Thread Barney Boisvert
I just rebuilt a server last night, and a fresh copy of CF7 standard
refuses to run on it.  CF6.1 runs just dandy, but CF7 tries to start
up, but only gets to the point of binding it's JNDI port, and then
stops doing anything else.  It gives every indication it's started up
successfully, but it hasn't.

I've tried using the installer fresh from the CD and the trial
download from MM.com, and both behave this way.  I've also tried
with/without the search services, RDS, Apache connector, etc.  And
I've tried both a fresh install and an "upgrade" install of 6.1.

The server's linux, and if anyone's got any clever ideas, I'd really
appreciate it.

thanks,
barneyb

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

Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212025
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Data Access in Flash... more

2005-07-15 Thread SStewart
Thanks, 

I kinda thought that's what I was doing.. like I said I'm VERY new to this...


sas

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep 
carcass... and thus the Pipes were born" 
 
 the Scottish Rogues


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 15, 2005 02:06 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low

Unless this is in a CF page or a FlashComm app, it simply won't work. Flash
doesn't have the capabilities or the integrated drivers to handle making
direct DB calls. 

The reason your script isn't throwing an error is because Flash assumes that
there's a custom class object named CF with a method called Query. I'd
strongly suggest looking at remoting for your middleware as this is easily
the best way to get dynamic data into flash.

Here's some instructions on CF.Query and other SSAS functions for future
reference:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=1496.htm 

Cheers,

Kevin


-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED] 
Sent: July 15, 2005 11:47 AM
To: CF-Talk
Subject: RE: Data Access in Flash... more

I encapsulated it within a function and it doesn't return any errors, now I
need to find out if it's actuall passing the data and get it into a data
grid.

function getConcrete(){
result = CF.query({datasource:"DocWf_SQL_Test", sql:"EXEC
GetConcreteStatus"});
return result;
}

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born" 
 
.. the Scottish Rogues


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 15, 2005 01:22 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low

The function in question is for Server side Actionscript. This form of
scripting is normally used with Flash communication server applications. 

There are no DB drivers included within the plug-in, so direct DB calls
aren't there to use. 

Cheers,

Kevin

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
 





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212024
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Data Access in Flash... more

2005-07-15 Thread Kevin Aebig
Unless this is in a CF page or a FlashComm app, it simply won't work. Flash
doesn't have the capabilities or the integrated drivers to handle making
direct DB calls. 

The reason your script isn't throwing an error is because Flash assumes that
there's a custom class object named CF with a method called Query. I'd
strongly suggest looking at remoting for your middleware as this is easily
the best way to get dynamic data into flash.

Here's some instructions on CF.Query and other SSAS functions for future
reference:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=1496.htm 

Cheers,

Kevin


-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED] 
Sent: July 15, 2005 11:47 AM
To: CF-Talk
Subject: RE: Data Access in Flash... more

I encapsulated it within a function and it doesn't return any errors, now I
need to find out if it's actuall passing the data and get it into a data
grid.

function getConcrete(){
result = CF.query({datasource:"DocWf_SQL_Test", sql:"EXEC
GetConcreteStatus"});
return result;
}

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born" 
 
. the Scottish Rogues


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 15, 2005 01:22 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low

The function in question is for Server side Actionscript. This form of
scripting is normally used with Flash communication server applications. 

There are no DB drivers included within the plug-in, so direct DB calls
aren't there to use. 

Cheers,

Kevin

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212023
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Verity taking out spaces in PDF?

2005-07-15 Thread Raymond Camden
It is my understanding that the Summary is NOT a straight cut and
paste, but Verity's attempt to summarize your content. Therefore, it
will not be perfect. The "context" value should be a straight cut and
paste.

On 7/15/05, Scott Stroz <[EMAIL PROTECTED]> wrote:
> Does anyone know of an issue with Verity stripping out spaces (whitespace)
> when indexing PDFs?
> 
> Some of the 'summary' from our collectoin read like
> whenyouenterthecorrectvalueitwillwork.
> 
> 
> --
> Scott Stroz
> Boyzoid.com 
> ___
> Some days you are the dog,
> Some days you are the tree.
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212022
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Data Access in Flash... more

2005-07-15 Thread SStewart
I encapsulated it within a function and it doesn't return any errors, now I 
need to find out if it's actuall passing the data and get it into a data grid.

function getConcrete(){
result = CF.query({datasource:"DocWf_SQL_Test", sql:"EXEC 
GetConcreteStatus"});
return result;
}

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep 
carcass... and thus the Pipes were born" 
 
 the Scottish Rogues


-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 15, 2005 01:22 pm
To: CF-Talk
Subject: RE: Data Access in Flash... more
Importance: Low

The function in question is for Server side Actionscript. This form of
scripting is normally used with Flash communication server applications. 

There are no DB drivers included within the plug-in, so direct DB calls
aren't there to use. 

Cheers,

Kevin

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212021
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Join queries

2005-07-15 Thread Deanna Schneider
I don't use ms-sql, so I'm a bit rusty on the ansi standard left join
sytax. It'll look something like the below. (Note the change in the
from close, and the deletion of the one part of the where clause.)

The a and p (and now l) are just aliases, so I don't have to type out
your tablenames over and over.

As for your generating your checkboxes, there's no need to use
different checkbox names. Just do this:
 



On your action page, if any of the checkboxes have been selected, then
you'll get a comma-delimited list of all the checked ones. (If none
have been checked, form.attributes won't be there at all, so be
careful. Come to think of it, attributes is a reserved word, so call
it something else, too  - maybe "attributesDesired" or something.


SELECT profileID, userID, profileTitle, gender,
genderSeeking, screenName, location, locationID, locationName, age,
confirmationID, imageName, imageAuthorisation

FROM (tbl_020publicProfiles p LEFT OUTER JOIN
tbl_020publicProfilesAttributes a on p.profileid = a.profileid) INNER
JOIN tbl_020publicLocations l ON p.locationid = l.locationid

WHERE gender = '#form.genderSeeking#' AND genderSeeking =
'#form.gender#' AND confirmationID = 'yes' AND userID <>
 AND
tbl_020publicLocations.locationID =
tbl_020publicProfiles.location AND location = '#form.location#' AND age >=
#form.minAge# AND age <= #form.maxAge# AND
imageAuthorisation = 1
AND a.attributeid IN (

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212020
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Douglas Knudsen
have you tried raising the request tiemout setting on the scheduled task?

DK

On 7/15/05, Doug Bedient <[EMAIL PROTECTED]> wrote:
> 
> This is a little OT but what is the best way to restart processing after 
> an error has occurred. Details: I have a scheduled page that parses a TXT 
> file. Sometimes the file is so large that it times out. I am time stamping 
> the items that have completed and I want the page to re-run to handle the 
> ones that have not been processed. I tried a CFCATCH with a CFLOCATION to 
> the page but that was a pipe dream.
> 
> Any thoughts?
> 
> Thanks,
> Doug
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212019
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Data Access in Flash... more

2005-07-15 Thread Kevin Aebig
The function in question is for Server side Actionscript. This form of
scripting is normally used with Flash communication server applications. 

There are no DB drivers included within the plug-in, so direct DB calls
aren't there to use. 

Cheers,

Kevin

-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED] 
Sent: July 15, 2005 9:34 AM
To: CF-Talk
Subject: Data Access in Flash... more

I'm digging through the Flash Pro MX 2004 help docs and it mentions using a
function called CF.query so I drop this into my flash doc and get the
following

**Error** Screen=data, layer=Layer 1, frame=1:Line 1: ')' or ',' expected
 CF.query(datasource:"DocWf_SQL_Test", sql:"EXEC GetConcreteStatus",
username:"sa", password:"password"),

**Error** Screen=data, layer=Layer 1, frame=1:Line 3: Syntax error.

Total ActionScript Errors: 2 Reported Errors: 2

I'm not sure what the syntax error is or exactly hw the function is to
be used.

sas

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep
carcass... and thus the Pipes were born" 
 
. the Scottish Rogues

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212018
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Join queries

2005-07-15 Thread Greg Morphis
the p and the a are just aliases for the tables.. some people don't
mind typing out the table names over and over again however I think
most like the shorthand of aliases.


On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> Thanks Deanna.  Just a couple of questions (and problems).
> 
> The form which displays the check boxes does so with a loop getting a
> list of the possible attributes:
> 
>  
>  
>  SELECT attributeID, attributeName
>  FROM tbl_020publicAttributes
>  
> 
>  
>   name="attribute_#attributeID#" label="#attributeName#">
>  
> 
> And also, there don't necessarily have to be any attributes in the
> table tbl_020publicProfilesAttributes for every profile as some may
> not have changed their profile accordingly.
> 
> Also can you tell me, are the p and the a just references which could
> be any letter?  Oh yes, i'm using MS-SQL.
> 
> It was about a week ago when you suggested i should use this middle
> join table instead and i never thought i'd get my head around it but
> managed to create one and have it update (well, delete or create
> rows) when users change their profiles.  Now i'm up to the bit where
> the searching is and this part has just stumped me a bit.
> 
> I am learning however... :)  Albeit slowly.
> 
> Thanks,
> 
> 
> On 15 Jul 2005, at 16:50, Deanna Schneider wrote:
> 
> > Try this. I'm not sure which DB, or if all users are requred to select
> > the type of match they seek. So, you may need to use the SQL Server
> > join syntax or the outer join syntax, if matching that parameter is
> > optional.
> >
> > 
> > SELECT profileID, userID, profileTitle, gender,
> > genderSeeking, screenName, location, locationID, locationName, age,
> > confirmationID, imageName, imageAuthorisation
> > FROM tbl_020publicProfiles p,
> > tbl_020publicLocations,tbl_020publicProfilesAttributes a
> > WHERE gender = '#form.genderSeeking#' AND genderSeeking =
> > '#form.gender#' AND confirmationID = 'yes' AND userID <>
> >  > cfsqltype="cf_sql_integer" maxlength="4"> AND
> > tbl_020publicLocations.locationID =
> > tbl_020publicProfiles.location > form.location neq 0> AND location = '#form.location#' > isDefined('form.minAge') and form.minAge neq 0> AND age >=
> > #form.minAge# > neq 0> AND age <= #form.maxAge# > ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
> > imageAuthorisation = 1
> >
> > AND p.profileid = a.profileid
> > AND a.attributeid IN ( > value="#form.attributeid#" list="yes")
> > ORDER by confirmationDate DESC
> > 
> >
> > On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> >
> >> Hi guys,
> >>
> >> I'm working on the search page of a dating application.
> >>
> >> In the form where the user gets to choose his/her preferred partner
> >> there are a few checkboxes which says:
> >>
> >> I am searching for:
> >>
> >> Love
> >> Casual
> >> Travel mate
> >> Friend
> >>
> >> When displayed as checkboxes i'm pulling from a table called
> >> tbl_020publicAttributes (fields: attributeID, attributeName).
> >>
> >> All users with profiles on the site have their attributes in a join
> >> table called tbl_020publicProfilesAttributes (fields profileID,
> >> attributeID)
> >>
> >> So when a visitor comes to the site and fills out a search form i
> >> want the results to also include the stated type of attributes they
> >> are looking for.
> >>
> >> So far my form works but i have no idea how i am going to also
> >> include this other table tbl_020publicProfilesAttributes:
> >>
> >>  
> >>  SELECT profileID, userID, profileTitle, gender,
> >> genderSeeking, screenName, location, locationID, locationName, age,
> >> confirmationID, imageName, imageAuthorisation
> >>  FROM tbl_020publicProfiles, tbl_020publicLocations
> >>  WHERE gender = '#form.genderSeeking#' AND genderSeeking =
> >> '#form.gender#' AND confirmationID = 'yes' AND userID <>
> >>  >> cfsqltype="cf_sql_integer" maxlength="4"> AND
> >> tbl_020publicLocations.locationID =
> >> tbl_020publicProfiles.location >> form.location neq 0> AND location = '#form.location#' >> isDefined('form.minAge') and form.minAge neq 0> AND age >=
> >> #form.minAge# >> neq 0> AND age <= #form.maxAge# >> ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
> >> imageAuthorisation = 1
> >>  ORDER by confirmationDate DESC
> >>  
> >>
> >> Any help i'd be very grateful with.
> >>
> >> Thanks,
> >>
> >> Saturday
> >>
> >>
> >>
> >>
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212017
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www

RE: Coldfusion7, & blank date fields!

2005-07-15 Thread Dave Watts
> Be aware that relying on name references when passing 
> parameters into a stored procedure from a CF template 
> doesn't work correctly 100%, at least from experience 
> on SQL Server. To be sure that you don't get mismatched 
> parameters, you should call the same number of parameters 
> and pass them in the same order that they are declared in 
> the procedure.

Named parameters are not supported at all with CFMX, if I recall correctly.
Your CFPROCPARAM tags must be in the same order as the parameters are
declared within the stored procedure.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212016
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Coldfusion7, & blank date fields!

2005-07-15 Thread Nick Han
Be aware that relying on name references when passing parameters into a
stored procedure from a CF template doesn't work correctly 100%, at
least from experience on SQL Server.  To be sure that you don't get
mismatched parameters, you should call the same number of parameters and
pass them in the same order that they are declared in the procedure.




-Original Message-
From: Anthony Prato [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 15, 2005 8:52 AM
To: CF-Talk
Subject: Re: Coldfusion7,  & blank date fields!

If I understand correctly you are trying to have these date parameters
of your stored procedure optional. Why not make them optional in the
stored procedure? In your stored procedure when you define for example
"@DOB datetime," Just change it to "@DOB datetime=null" This will set
the parameter @DOB to null if it is not passed into the SP. (this is
for SQL server, that is what you are using correct?)

Anthony

On 7/15/05, Andy Mcshane <[EMAIL PROTECTED]> wrote:
> OK, the code below is used to call the function
> 
> 
> 
> All of my form fields are within the structure 'DataFields' and I know
that they are all there when it is passed to the CFC.
> 
> Within my CFC my CFSTOREDPROC is as follows
> 
>
>datasource="#request.datasource#"
>returncode="Yes" debug="Yes">
>
>value=#arguments.clubid#
>cfsqltype = CF_SQL_INTEGER
>[EMAIL PROTECTED]>
>value=#arguments.PLAYERID#
>cfsqltype = CF_SQL_INTEGER
>[EMAIL PROTECTED]>
> ..other stuff here 
>
>value=#arguments.DOB#
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>null="yes"
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>
>value=#arguments.FIXDATE#
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>null="yes"
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>
>
>
> 
> The last part is giving me the problem. I have tried using 'isDate' as
well as the above which is just checking if there is any data there. If
there is nothing then I need to pass null. Unfortunately using the code
above simply loses the parameter so instead of my stored procedure
receiving 19 parameters as expected every blank date field loses one off
the total i.e. 1 blank field and then only 18 parameters are passed. I
am going mad trying to solve this, please help.
> 
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212015
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Join queries

2005-07-15 Thread Saturday (Stuart Kidd)
Thanks Deanna.  Just a couple of questions (and problems).

The form which displays the check boxes does so with a loop getting a  
list of the possible attributes:

 
 
 SELECT attributeID, attributeName
 FROM tbl_020publicAttributes
 

 
 
 

And also, there don't necessarily have to be any attributes in the  
table tbl_020publicProfilesAttributes for every profile as some may  
not have changed their profile accordingly.

Also can you tell me, are the p and the a just references which could  
be any letter?  Oh yes, i'm using MS-SQL.

It was about a week ago when you suggested i should use this middle  
join table instead and i never thought i'd get my head around it but  
managed to create one and have it update (well, delete or create  
rows) when users change their profiles.  Now i'm up to the bit where  
the searching is and this part has just stumped me a bit.

I am learning however... :)  Albeit slowly.

Thanks,


On 15 Jul 2005, at 16:50, Deanna Schneider wrote:

> Try this. I'm not sure which DB, or if all users are requred to select
> the type of match they seek. So, you may need to use the SQL Server
> join syntax or the outer join syntax, if matching that parameter is
> optional.
>
> 
> SELECT profileID, userID, profileTitle, gender,
> genderSeeking, screenName, location, locationID, locationName, age,
> confirmationID, imageName, imageAuthorisation
> FROM tbl_020publicProfiles p,
> tbl_020publicLocations,tbl_020publicProfilesAttributes a
> WHERE gender = '#form.genderSeeking#' AND genderSeeking =
> '#form.gender#' AND confirmationID = 'yes' AND userID <>
>  cfsqltype="cf_sql_integer" maxlength="4"> AND
> tbl_020publicLocations.locationID =
> tbl_020publicProfiles.location form.location neq 0> AND location = '#form.location#' isDefined('form.minAge') and form.minAge neq 0> AND age >=
> #form.minAge# neq 0> AND age <= #form.maxAge# ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
> imageAuthorisation = 1
>
> AND p.profileid = a.profileid
> AND a.attributeid IN ( value="#form.attributeid#" list="yes")
> ORDER by confirmationDate DESC
> 
>
> On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
>
>> Hi guys,
>>
>> I'm working on the search page of a dating application.
>>
>> In the form where the user gets to choose his/her preferred partner
>> there are a few checkboxes which says:
>>
>> I am searching for:
>>
>> Love
>> Casual
>> Travel mate
>> Friend
>>
>> When displayed as checkboxes i'm pulling from a table called
>> tbl_020publicAttributes (fields: attributeID, attributeName).
>>
>> All users with profiles on the site have their attributes in a join
>> table called tbl_020publicProfilesAttributes (fields profileID,
>> attributeID)
>>
>> So when a visitor comes to the site and fills out a search form i
>> want the results to also include the stated type of attributes they
>> are looking for.
>>
>> So far my form works but i have no idea how i am going to also
>> include this other table tbl_020publicProfilesAttributes:
>>
>>  
>>  SELECT profileID, userID, profileTitle, gender,
>> genderSeeking, screenName, location, locationID, locationName, age,
>> confirmationID, imageName, imageAuthorisation
>>  FROM tbl_020publicProfiles, tbl_020publicLocations
>>  WHERE gender = '#form.genderSeeking#' AND genderSeeking =
>> '#form.gender#' AND confirmationID = 'yes' AND userID <>
>> > cfsqltype="cf_sql_integer" maxlength="4"> AND
>> tbl_020publicLocations.locationID =
>> tbl_020publicProfiles.location> form.location neq 0> AND location = '#form.location#'> isDefined('form.minAge') and form.minAge neq 0> AND age >=
>> #form.minAge#> neq 0> AND age <= #form.maxAge#> ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
>> imageAuthorisation = 1
>>  ORDER by confirmationDate DESC
>>  
>>
>> Any help i'd be very grateful with.
>>
>> Thanks,
>>
>> Saturday
>>
>>
>>
>>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212014
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Catching errors and emailing

2005-07-15 Thread Doug Bedient
This is a little OT but what is the best way to restart processing after an 
error has occurred. Details: I have a scheduled page that parses a TXT file. 
Sometimes the file is so large that it times out. I am time stamping the items 
that have completed and I want the page to re-run to handle the ones that have 
not been processed. I tried a CFCATCH with a CFLOCATION to the page but that 
was a pipe dream.

Any thoughts?

Thanks,
Doug

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212013
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Verity taking out spaces in PDF?

2005-07-15 Thread Scott Stroz
Does anyone know of an issue with Verity stripping out spaces (whitespace) 
when indexing PDFs?

Some of the 'summary' from our collectoin read like 
whenyouenterthecorrectvalueitwillwork.


-- 
Scott Stroz
Boyzoid.com 
___
Some days you are the dog,
Some days you are the tree.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212012
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Catching errors and emailing (new Question)

2005-07-15 Thread Aldon
How do I catch server response when an email is accepted for delivery?



-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 9:06 AM
To: CF-Talk
Subject: Catching errors and emailing


Sorry, forgot to mention that I use this code in a sitewide error handling
template so every error on the site gets emailed to me, even ones in a
CFTRY/CFCATCH. On a related note, don't use CFTRY/CFCATCH to handle known
errors. Handle the error directly!

>
>   
>   
>   
>   
>label="session">
>   
>



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Access throwing error missing operator (I hate Access!)

2005-07-15 Thread S . Isaac Dealey
Access has its own unique syntax for multiple join statements (ain't
it lovely?) ... You can get away with a single join statement the way
normal join statements work, but after the first one, they have to be
nested (in a way that other db's don't like of course because it's
non-standard).

FROM tbl_threads t

INNER JOIN (tbl_users u
INNER JOIN (tbl_forums f ON t.frn_ForumId = f.ForumId)
ON t.frn_UserId = u.UserId)

I'm not absolutely certain that's correct, since this is from memory
and my sql-abstraction layer does this for me... The syntax is
absolutely vomitous... but Access requires it...


hth

s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212010
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Coldfusion7, & blank date fields!

2005-07-15 Thread Anthony Prato
If I understand correctly you are trying to have these date parameters
of your stored procedure optional. Why not make them optional in the
stored procedure? In your stored procedure when you define for example
"@DOB datetime," Just change it to "@DOB datetime=null" This will set
the parameter @DOB to null if it is not passed into the SP. (this is
for SQL server, that is what you are using correct?)

Anthony

On 7/15/05, Andy Mcshane <[EMAIL PROTECTED]> wrote:
> OK, the code below is used to call the function
> 
> 
> 
> All of my form fields are within the structure 'DataFields' and I know that 
> they are all there when it is passed to the CFC.
> 
> Within my CFC my CFSTOREDPROC is as follows
> 
> hint="Insert page one player report details">
>datasource="#request.datasource#"
>returncode="Yes" debug="Yes">
>
>value=#arguments.clubid#
>cfsqltype = CF_SQL_INTEGER
>[EMAIL PROTECTED]>
>value=#arguments.PLAYERID#
>cfsqltype = CF_SQL_INTEGER
>[EMAIL PROTECTED]>
> ..other stuff here 
>
>value=#arguments.DOB#
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>null="yes"
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>
>value=#arguments.FIXDATE#
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>null="yes"
>cfsqltype = CF_SQL_DATE
>[EMAIL PROTECTED]>
>
>
>
>
> 
> The last part is giving me the problem. I have tried using 'isDate' as well 
> as the above which is just checking if there is any data there. If there is 
> nothing then I need to pass null. Unfortunately using the code above simply 
> loses the parameter so instead of my stored procedure receiving 19 parameters 
> as expected every blank date field loses one off the total i.e. 1 blank field 
> and then only 18 parameters are passed. I am going mad trying to solve this, 
> please help.
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212009
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Join queries

2005-07-15 Thread Deanna Schneider
Try this. I'm not sure which DB, or if all users are requred to select
the type of match they seek. So, you may need to use the SQL Server
join syntax or the outer join syntax, if matching that parameter is
optional.


SELECT profileID, userID, profileTitle, gender,
genderSeeking, screenName, location, locationID, locationName, age,
confirmationID, imageName, imageAuthorisation
FROM tbl_020publicProfiles p,
tbl_020publicLocations,tbl_020publicProfilesAttributes a
WHERE gender = '#form.genderSeeking#' AND genderSeeking =
'#form.gender#' AND confirmationID = 'yes' AND userID <>
 AND
tbl_020publicLocations.locationID =
tbl_020publicProfiles.location AND location = '#form.location#' AND age >=
#form.minAge# AND age <= #form.maxAge# AND
imageAuthorisation = 1

AND p.profileid = a.profileid
AND a.attributeid IN (

On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> Hi guys,
> 
> I'm working on the search page of a dating application.
> 
> In the form where the user gets to choose his/her preferred partner
> there are a few checkboxes which says:
> 
> I am searching for:
> 
> Love
> Casual
> Travel mate
> Friend
> 
> When displayed as checkboxes i'm pulling from a table called
> tbl_020publicAttributes (fields: attributeID, attributeName).
> 
> All users with profiles on the site have their attributes in a join
> table called tbl_020publicProfilesAttributes (fields profileID,
> attributeID)
> 
> So when a visitor comes to the site and fills out a search form i
> want the results to also include the stated type of attributes they
> are looking for.
> 
> So far my form works but i have no idea how i am going to also
> include this other table tbl_020publicProfilesAttributes:
> 
>  
>  SELECT profileID, userID, profileTitle, gender,
> genderSeeking, screenName, location, locationID, locationName, age,
> confirmationID, imageName, imageAuthorisation
>  FROM tbl_020publicProfiles, tbl_020publicLocations
>  WHERE gender = '#form.genderSeeking#' AND genderSeeking =
> '#form.gender#' AND confirmationID = 'yes' AND userID <>
>  cfsqltype="cf_sql_integer" maxlength="4"> AND
> tbl_020publicLocations.locationID =
> tbl_020publicProfiles.location form.location neq 0> AND location = '#form.location#' isDefined('form.minAge') and form.minAge neq 0> AND age >=
> #form.minAge# neq 0> AND age <= #form.maxAge# ('form.hasPhotograph') and form.hasPhotograph eq 1> AND
> imageAuthorisation = 1
>  ORDER by confirmationDate DESC
>  
> 
> Any help i'd be very grateful with.
> 
> Thanks,
> 
> Saturday
> 
> 
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212008
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Coldfusion7, & blank date fields!

2005-07-15 Thread Andy Mcshane
That was indeed a great help, I had to slightly modify your code to get it to 
work. I had to change it to this (for some strange reason it doesn't like 
checking for the length > 0?)



this works OK. And yes, I do still use the 'dbvarname' attribute purely as a 
personal thing.

Thanks for your help.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212007
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Data Access in Flash... more

2005-07-15 Thread SStewart
I'm digging through the Flash Pro MX 2004 help docs and it mentions using a 
function called CF.query so I drop this into my flash doc and get the following

**Error** Screen=data, layer=Layer 1, frame=1:Line 1: ')' or ',' expected
 CF.query(datasource:"DocWf_SQL_Test", sql:"EXEC GetConcreteStatus", 
username:"sa", password:"password"),

**Error** Screen=data, layer=Layer 1, frame=1:Line 3: Syntax error.

Total ActionScript Errors: 2 Reported Errors: 2

I'm not sure what the syntax error is or exactly hw the function is to be 
used.

sas

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep 
carcass... and thus the Pipes were born" 
 
 the Scottish Rogues

 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.15/49 - Release Date: 07/14/2005
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212006
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Coldfusion7, & blank date fields!

2005-07-15 Thread Tangorre, Michael
> From: Andy Mcshane [mailto:[EMAIL PROTECTED] 

Have you checked the values that are passed into the CFC before you use
them.? Just output them within the CFC to ensure that the expected
values are at least within the CFC.

You can avoid the use of cfif/cfelse tags and duplicate cfprocparam tags
by evaluating an expression within the null attribute of the
cfprocparam/cfqueryparam tags to determine whether or not NULL is sent
or the actual value of the variable. If the expression evaluates to Yes,
the value attribute of the tag is ignored. If the expression evaluates
to No then the value attribute is passed in.

The attribute dbvarname is no longer used in CFMX7, in fact it is
ignored. I guess if you are using it to keep the stored procedure
parameter names in check it can't hurt but I'd say if an attribute is no
longer supported, don't use it.



Not sure if any of that helps, but it cleans things up a little. :-)

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212005
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Join queries

2005-07-15 Thread Saturday (Stuart Kidd)
Hi guys,

I'm working on the search page of a dating application.

In the form where the user gets to choose his/her preferred partner  
there are a few checkboxes which says:

I am searching for:

Love
Casual
Travel mate
Friend

When displayed as checkboxes i'm pulling from a table called  
tbl_020publicAttributes (fields: attributeID, attributeName).

All users with profiles on the site have their attributes in a join  
table called tbl_020publicProfilesAttributes (fields profileID,  
attributeID)

So when a visitor comes to the site and fills out a search form i  
want the results to also include the stated type of attributes they  
are looking for.

So far my form works but i have no idea how i am going to also  
include this other table tbl_020publicProfilesAttributes:

 
 SELECT profileID, userID, profileTitle, gender,  
genderSeeking, screenName, location, locationID, locationName, age,  
confirmationID, imageName, imageAuthorisation
 FROM tbl_020publicProfiles, tbl_020publicLocations
 WHERE gender = '#form.genderSeeking#' AND genderSeeking =  
'#form.gender#' AND confirmationID = 'yes' AND userID <>  
 AND  
tbl_020publicLocations.locationID =  
tbl_020publicProfiles.location AND location = '#form.location#' AND age >=  
#form.minAge# AND age <= #form.maxAge# AND  
imageAuthorisation = 1
 ORDER by confirmationDate DESC
 

Any help i'd be very grateful with.

Thanks,

Saturday


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212004
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Access throwing error missing operator (I hate Access!)

2005-07-15 Thread Stan Winchester
I found the problem. I thought I would let Access create the joins for me and 
so I opened the "Create query in Design view" wizard in Access and selected the 
tables and it calculated the joins correctly and it works fine in Access, SQL 
Server, MySQL, and PostgreSQL!

Here is the correct format:

FROM tbl_users u
  INNER JOIN (((tbl_conferences c
INNER JOIN tbl_forums f
  ON c.ConferenceId = f.frn_ConferenceId) 
INNER JOIN tbl_threads t
  ON f.ForumId = t.frn_ForumId) 
INNER JOIN tbl_messages m 
  ON t.ThreadId = m.frn_ThreadId) 
ON u.UserId = t.frn_UserId

Here is the bad format:

  FROM tbl_threads t
INNER JOIN tbl_users u
  ON t.frn_UserId = u.UserId
INNER JOIN tbl_forums f
  ON t.frn_ForumId = f.ForumId
INNER JOIN tbl_conferences c
  ON f.frn_ConferenceId = c.ConferenceId
INNER JOIN tbl_messages m
  ON t.ThreadId = m.frn_ThreadId

Aftershock Web Design, Inc.
by: Stan Winchester
President/Developer
http://www.aftershockweb.com/   
Phone 503-244-3440
Fax 503-244-3454

>I trying to get an application to work with MS Access and it threw the
>following error:
>
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
>query expression 't.frn_UserId = u.UserId INNER JOIN tbl_forums f ON
>t.frn_ForumId = f.ForumId'.
>
>Native Error Code  -3100
>SQL State  37000
>
>This error happens on CFMX & BD 6.2 only when the data source is an Access
>database, when it is MySQL, SQL Server, or PostgreSQL it works fine. Here is
>the query:
>
>SQL
>SELECT DISTINCT 
>t.ThreadName, t.frn_UserId, t.frn_ForumId, 
>t.DateCreated, t.ThreadId, t.IsReadonly, 
>t.IsActive, u.UserId, u.FirstName, u.LastName,
>f.ForumName 
>FROM tbl_threads t 
>  INNER JOIN tbl_users u 
>   ON t.frn_UserId = u.UserId 
>  INNER JOIN tbl_forums f 
>   ON t.frn_ForumId = f.ForumId
>
>BTW: This error happens site wide, but only with Access. Any ideas how to
>fix this. I've googled the error and came up with nothing.
>
>Thank you,
>Aftershock Web Design, Inc.
>by: Stan Winchester
>President/Developer
>http://www.aftershockweb.com/   
>Phone 503-244-3440
>Fax 503-244-3454

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212003
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Merrill, Jason
>>Do you have the Access DB open on your workstation?

Oops!  That seemed to be it.  I feel like an idiot.  I was doing updates
previously with the database without a problem when the file was open in
access.  It only popped up now when I did the UPDATE for some reason.
Thanks Michael, Dave, Doug, Anthony, Clint!

Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com







NOTICE:
This message is for the designated recipient only and may contain privileged or 
confidential information. If you have received it in error, please notify the 
sender immediately and delete the original. Any other use of this e-mail by you 
is prohibited.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212002
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Why does only one datasource throw an error?

2005-07-15 Thread Jeff Small
> My guess, based on your error message, is that you're using different 
> values
> for either the database server or the port. With SQL Server 2000, you can
> run multiple instances of SQL Server on the same machine. Each one will
> listen on a different port, and have a different name, although the name
> isn't especially important outside of Enterprise Manager.

Odd...I was using the "default" values for port (1433), and the server name 
was exactly the same for each datasource, because I checked that.

What I wound up doing, was creating a NEW database, and calling it 
"JMH2005". Then I used the Import/Export tool to create a DTS package that 
copied databases and objects between "JMH" and "JMH2005". Then I went into 
CFAdmin, and created a new datasource, named it "JMH2005" and pointed it to 
the new database that I just created.

It worked like a charm. Once I went into my Application.cfm and changed my 
datasource to "JMH2005" it all...just...well, worked.

I still wonder what happened. 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212001
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Query error

2005-07-15 Thread Clint Tredway
If you have that table open in design view or open at all in Access (I
think), you will get this error.

On 7/15/05, Merrill, Jason <[EMAIL PROTECTED]> wrote:
> >>can you post a more informative error message?
> 
> OK - I put in some pseudo variables instead of using the ones from Flash
> Remoting and got this when I call the CFC from a CFM:
> 
> 
> --
> Error Executing Database Query.
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
> Microsoft Access Driver] The table 'Lessons' is already opened
> exclusively by another user, or it is already open through the user
> interface and cannot be manipulated programmatically.
> 
> The error occurred in
> C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11
> Called from
> C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2
> Called from
> C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11
> Called from
> C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2
> 
> 9 : UPDATE Lessons
> 10 :SET Lesson =  cfsqltype="CF_SQL_VARCHAR" value="#lesson#">
> 11 :WHERE ID =  cfsqltype="CF_SQL_INTEGER" value="#row#">
> 12 : 
> 13 : 
> 
> --
> 
> Not sure how its being used by someone else, this is all being done
> locally on my workstation and only have ColdFusion accessing the access
> database.  I am also only using the Developer edition of ColdFusion MX
> 7, but that shouldn't matter because you get 2 IP addresses to connect
> anyway, right?
> 
> What's going on here?
> 
> Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com
> 
> 
> NOTICE:
> This message is for the designated recipient only and may contain privileged 
> or confidential information. If you have received it in error, please notify 
> the sender immediately and delete the original. Any other use of this e-mail 
> by you is prohibited.
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212000
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Tangorre, Michael
> From: Merrill, Jason [mailto:[EMAIL PROTECTED] 
> Error Executing Database Query.  
> [Macromedia][SequeLink JDBC Driver][ODBC 
> Socket][Microsoft][ODBC Microsoft Access Driver] The table 
> 'Lessons' is already opened exclusively by another user, or 
> it is already open through the user interface and cannot be 
> manipulated programmatically.  

Do you have the Access DB open on your workstation?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211999
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Merrill, Jason
>>can you post a more informative error message? 

OK - I put in some pseudo variables instead of using the ones from Flash
Remoting and got this when I call the CFC from a CFM:


--
Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] The table 'Lessons' is already opened
exclusively by another user, or it is already open through the user
interface and cannot be manipulated programmatically.  
  
The error occurred in
C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11
Called from
C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2
Called from
C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11
Called from
C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2
 
9 : UPDATE Lessons
10 :SET Lesson =  
11 :WHERE ID =  
12 : 
13 :  

--

Not sure how its being used by someone else, this is all being done
locally on my workstation and only have ColdFusion accessing the access
database.  I am also only using the Developer edition of ColdFusion MX
7, but that shouldn't matter because you get 2 IP addresses to connect
anyway, right?

What's going on here?

Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com


NOTICE:
This message is for the designated recipient only and may contain privileged or 
confidential information. If you have received it in error, please notify the 
sender immediately and delete the original. Any other use of this e-mail by you 
is prohibited.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211998
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Merrill, Jason
Yeah, thanks - I just caught that and fixed it to specify numeric -
thanks, but the error remains - I just posted a more detailed error in
this thread - might be posted before or after this one...

Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com










>>-Original Message-
>>From: Dave Watts [mailto:[EMAIL PROTECTED]
>>Sent: Friday, July 15, 2005 11:14 AM
>>To: CF-Talk
>>Subject: RE: Query error
>>
>>> where 9 should be an integer, unless Remoting still sends it
>>> as a string. If so, it seems there is no way to be sure it's
>>> being sent as a number from Flash, is there a way in CF to convert
>>> it from a string type (if that's really how its being sent) to type
>>> numeric? Or at least find out what data type its being received as?
>>
>>Well, CF is more or less typeless*, but you can specify the expected
data
>>type in your CFARGUMENT tag. If I recall correctly, you're specifying
a
>>string when you really expect a number. This will result in your CFC
>>throwing an exception if the data can't be cast as a number. I really
don't
>>see why this would make a difference in this case, assuming that you
>>actually are passing a numeric value, but I'd recommend that you
explicitly
>>specify the data types you expect your arguments to receive.
>>
>>* This is an oversimplification, but still a useful way to think of
CF.
>>
>>Dave Watts, CTO, Fig Leaf Software
>>http://www.figleaf.com/
>>
>>Fig Leaf Software provides the highest caliber vendor-authorized
>>instruction at our training centers in Washington DC, Atlanta,
>>Chicago, Baltimore, Northern Virginia, or on-site at your location.
>>Visit http://training.figleaf.com/ for more information!
>>
>>
>>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211997
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Merrill, Jason
>>can you post a more informative error message? 

OK - I put in some pseudo variables instead of using the ones from Flash
Remoting and got this when I call the CFC from a CFM:


--
Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] The table 'Lessons' is already opened
exclusively by another user, or it is already open through the user
interface and cannot be manipulated programmatically.  
  
The error occurred in
C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11
Called from
C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2
Called from
C:\CFusionMX7\wwwroot\com\macromedia\test\updateDatabase_2.cfc: line 11
Called from
C:\CFusionMX7\wwwroot\com\macromedia\test\invokeUpdateDB2CFC.cfm: line 2
 
9 : UPDATE Lessons
10 :SET Lesson =  
11 :WHERE ID =  
12 : 
13 :  

--

Not sure how its being used by someone else, this is all being done
locally on my workstation and only have ColdFusion accessing the access
database.  I am also only using the Developer edition of ColdFusion MX
7, but that shouldn't matter because you get 2 IP addresses to connect
anyway, right?

What's going on here?

Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com










>>-Original Message-
>>From: Douglas Knudsen [mailto:[EMAIL PROTECTED]
>>Sent: Friday, July 15, 2005 10:28 AM
>>To: CF-Talk
>>Subject: Re: Query error
>>
>>can you post a more informative error message? Also, test it without
the
>>queryparams. Also, maybe just build the SQL in a string and email it
to
>>yourself to see if the SQL and inputed arguments are actually coming
in
>>correct from Flash.
>>
>>Aside fro this I'll not that you should VAR scope your local variables
too.
>>:)
>>
>>DK
>>
>>On 7/14/05, Merrill, Jason <[EMAIL PROTECTED]> wrote:
>>>
>>> Any idea why I'm getting an "Error Executing Database Query." With
this?
>>> I can take out the query and return "lesson" and "row" just fine.
>>> Lesson and ID in the table are varchar and integer type fields
>>> respectively.
>>>
>>> 
>>> 
>>> 
>>> 
>>> 
>>> UPDATE Lessons
>>> SET Lesson = >> value="#Arguments.lesson#">
>>> WHERE ID = >> value="#Arguments.row#">
>>> 
>>>  
>>> 
>>> 
>>>
>>> Thanks.
>>>
>>> Jason Merrill | E-Learning Solutions |
>>icfconsulting.com
>>>
>>>
>>> NOTICE:
>>> This message is for the designated recipient only and may contain
>>> privileged or confidential information. If you have received it in
error,
>>> please notify the sender immediately and delete the original. Any
other use
>>> of this e-mail by you is prohibited.
>>>
>>>
>>
>>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211996
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Catching errors and emailing

2005-07-15 Thread Tangorre, Michael
 

> From: Dave Watts [mailto:[EMAIL PROTECTED] 
> At that point, though, overhead is probably not your primary 
> concern (or even an important concern at all). After all, 
> exceptions are, well, exceptional, by their very nature, so 
> you shouldn't have to deal with too many of them at once.

I was merely commenting on what Mikey D was saying I haven't seen
nor used a lot of cfcatch blocks on MX6 or 7 but back on CF 4-5, it
seemed that whenever cfcatch was involved, performance took a hit. It
could have been the crappy application I was stuck working on in general
but it performance always improved when we corrected the overuse of the
cfcatch tag.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211995
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Dave Watts
> where 9 should be an integer, unless Remoting still sends it 
> as a string. If so, it seems there is no way to be sure it's 
> being sent as a number from Flash, is there a way in CF to convert 
> it from a string type (if that's really how its being sent) to type 
> numeric? Or at least find out what data type its being received as?

Well, CF is more or less typeless*, but you can specify the expected data
type in your CFARGUMENT tag. If I recall correctly, you're specifying a
string when you really expect a number. This will result in your CFC
throwing an exception if the data can't be cast as a number. I really don't
see why this would make a difference in this case, assuming that you
actually are passing a numeric value, but I'd recommend that you explicitly
specify the data types you expect your arguments to receive.

* This is an oversimplification, but still a useful way to think of CF.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211994
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Delivery barcode

2005-07-15 Thread Connie DeCinko
One point not yet addressed, is how you get the number from USPS.  It
appears they don't easily give you access to getting that number assigned to
your package electronically.
 
 
Constanty "Connie" DeCinko III
Web Architect, Webmaster, Web Developer
Lone Jet Enterprises
Glendale, Arizona
www.LoneJet.com
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211993
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Why does only one datasource throw an error?

2005-07-15 Thread Dave Watts
> Okay, here's what I've done so far.
> 
> I have a datasource called JMH. It's the ONLY one that's not 
> working. SO I clicked on JMH, and pointed it to another database. 
> I got the following error:
> 
> Connection verification failed for data source: JMH
> []java.sql.SQLException: SQLException while attempting to connect: 
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The 
> requested instance is either invalid or not running.
> The root cause was that: java.sql.SQLException: SQLException while 
> attempting to connect: java.sql.SQLException: 
> [Macromedia][SQLServer JDBC Driver]The requested instance is either 
> invalid or not running.
> 
> So I thought, "hmmm...I wonder if I can just create everything from 
> scratch?" So I went to enterprise manager, created a database, called 
> it "Jeff" and then switched over to CFAdmin. I created a new SQL Server 
> datasource, named it "Jeff", filled out all the appropriate 
> username/password (same as for JMH...sa) and viola! It worked.
> 
> So then, I thought, "well, can I point my bad JMH datasource at what I 
> now know is a good, clean, new database that I already know can work 
> in CF?". So I clicked on JMH, pointed the *database* to "Jeff" and 
> clicked "submit" and got the exact same error message as above.

My guess, based on your error message, is that you're using different values
for either the database server or the port. With SQL Server 2000, you can
run multiple instances of SQL Server on the same machine. Each one will
listen on a different port, and have a different name, although the name
isn't especially important outside of Enterprise Manager.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211992
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Catching errors and emailing

2005-07-15 Thread Dave Watts
> The overhead comes into play when an an exception is thrown 
> and the cfcatch portio executes... especially if you have multiple 
> cfcatch tags that are not in the best order, e.g. the most specific 
> being first then so on down to the most general.

At that point, though, overhead is probably not your primary concern (or
even an important concern at all). After all, exceptions are, well,
exceptional, by their very nature, so you shouldn't have to deal with too
many of them at once.

As for the ordering of your CFCATCH tags, again that's not really a
performance issue but rather a logic issue - you don't want to catch an
exception as a general type if it could be caught as a specific type. I
really doubt there's any significant time spent by CF going through the list
of possible exceptions you're trying to catch and matching the exception you
have against that list.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211991
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Coldfusion7, & blank date fields!

2005-07-15 Thread Andy Mcshane
OK, the code below is used to call the function



All of my form fields are within the structure 'DataFields' and I know that 
they are all there when it is passed to the CFC.

Within my CFC my CFSTOREDPROC is as follows






..other stuff here 














The last part is giving me the problem. I have tried using 'isDate' as well as 
the above which is just checking if there is any data there. If there is 
nothing then I need to pass null. Unfortunately using the code above simply 
loses the parameter so instead of my stored procedure receiving 19 parameters 
as expected every blank date field loses one off the total i.e. 1 blank field 
and then only 18 parameters are passed. I am going mad trying to solve this, 
please help.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211990
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Access throwing error missing operator (I hate Access!)

2005-07-15 Thread Stan Winchester
I trying to get an application to work with MS Access and it threw the
following error:



[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in
query expression 't.frn_UserId = u.UserId INNER JOIN tbl_forums f ON
t.frn_ForumId = f.ForumId'.

 

Native Error Code  -3100

SQL State  37000



 

This error happens on CFMX & BD 6.2 only when the data source is an Access
database, when it is MySQL, SQL Server, or PostgreSQL it works fine. Here is
the query:

 

SQL

SELECT DISTINCT 

t.ThreadName, t.frn_UserId, t.frn_ForumId, 

t.DateCreated, t.ThreadId, t.IsReadonly, 

t.IsActive, u.UserId, u.FirstName, u.LastName,

f.ForumName 

FROM tbl_threads t 

  INNER JOIN tbl_users u 

   ON t.frn_UserId = u.UserId 

  INNER JOIN tbl_forums f 

   ON t.frn_ForumId = f.ForumId

 

BTW: This error happens site wide, but only with Access. Any ideas how to
fix this. I've googled the error and came up with nothing.

 

Thank you,

Aftershock Web Design, Inc.

by: Stan Winchester

President/Developer

[EMAIL PROTECTED]  

http://www.aftershockweb.com/   

Phone 503-244-3440

Fax 503-244-3454

 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211989
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Why does only one datasource throw an error?

2005-07-15 Thread Jeff Small
Okay, here's what I've done so far.

I have a datasource called JMH. It's the ONLY one that's not working. SO I 
clicked on JMH, and pointed it to another database. I got the following 
error:

Connection verification failed for data source: JMH
[]java.sql.SQLException: SQLException while attempting to connect: 
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested 
instance is either invalid or not running.
The root cause was that: java.sql.SQLException: SQLException while 
attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC 
Driver]The requested instance is either invalid or not running.

So I thought, "hmmm...I wonder if I can just create everything from 
scratch?" So I went to enterprise manager, created a database, called it 
"Jeff" and then switched over to CFAdmin. I created a new SQL Server 
datasource, named it "Jeff", filled out all the appropriate 
username/password (same as for JMH...sa) and viola! It worked.

So then, I thought, "well, can I point my bad JMH datasource at what I now 
know is a good, clean, new database that I already know can work in CF?". So 
I clicked on JMH, pointed the *database* to "Jeff" and clicked "submit" and 
got the exact same error message as above.

Now I'm really stumped.

--
Jeff Small
LHWH Advertising
Myrtle Beach, SC 29577
843-448-1123 Ext 254
- Original Message - 
From: "Jeff Small" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, July 15, 2005 10:17 AM
Subject: Why does only one datasource throw an error?


>I have a SQL server here for development, and all the other datasources 
>that
> the CF Admin are pointing to that reside on that server are coming back as
> good (Verify all Connections...ok) but one is throwing an error. I deleted
> it, and tried to reinstall the datasource, but I got the following error:
>
> Connection verification failed for data source: JMH
> []java.sql.SQLException: SQLException while attempting to connect:
> java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested
> instance is either invalid or not running.
> The root cause was that: java.sql.SQLException: SQLException while
> attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver]The requested instance is either invalid or not running.
>
> I don't understand...*what* instance is either invalid or not running? The
> SQL Server is there, it's running, the database is there, it's okay, the
> tables are there, they have data in them...*other* tables are there and 
> are
> working...where should I go next?
>
>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211988
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Coldfusion7, & blank date fields!

2005-07-15 Thread Tangorre, Michael
> From: Andy Mcshane [mailto:[EMAIL PROTECTED] 
> passed to procedure. Anybody have any ideas?

Post the code. In particular, the cfprocparam code within the CFC.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211987
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: HomeSite+ and Perl Files

2005-07-15 Thread Ben Doom
IIRC, you also have t register the file type with Windows.

--Ben

Jim McAtee wrote:
> When I attempt to open a Perl file (with .pl or .pm extension) in 
> HomeSite+ I first get a dialog box stating that the file isn't a 
> recognized text document.  After I tell HomeSite to open it any way, the 
> color coding is correct.  In the File Settings, Extension Manager I have 
> these extensions entered and checked off as editable.  What else is 
> necessary? 
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211986
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Coldfusion7, & blank date fields!

2005-07-15 Thread Andy Mcshane
Hi all. I have started to notice some very strange activity of late with a new 
site that I am writing. Here are the details,

I have a number of form fields, 4 of which are date fields.
The date fields can all be blank.
All of my form fields are put into a new staructure and this structure is then 
passed to a CFC using the 'argumentcollection=' syntax.
Within my CFC I am using cfstoredproc to call a SQL2000 stored procedure, all 
of the parameters are passed out using cfprocparam. 
I check here whether my datefields do in fact contain a date else I set 
null="yes" for that specific cfprocparam. This is where the problem starts, if 
one of my date fields is empty, i.e. pass out null, my stored procedure does 
not receive the correct number of parameters and I get an error. If all of my 
date fields are populated then I get no error as the correct number of 
parameters have been passed. It almost seems that the blank date fields that 
are being passed out as null with a cfsqltype = CF_SQL_DATE are being lost and 
not getting passed to procedure. Anybody have any ideas?

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211985
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Catching errors and emailing

2005-07-15 Thread Tangorre, Michael
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
> CFTRY/CFCATCH is very efficient and has close to no overhead 
> on a standard CF page. It's an issue of approach, not execution speed.

The overhead comes into play when an an exception is thrown and the
cfcatch portio executes... especially if you have multiple cfcatch tags
that are not in the best order, e.g. the most specific being first then
so on down to the most general.

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211984
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Saturday (Stuart Kidd)
Thanks everyone for your help and I like your photo Doug!

I got it working now! :)

I had a few problems because first of all i wasn't using the line  
below, instead i had the cftry/cfcatch on my main page and it wasn't  
cfmailing:



But then i put it on the top of my main page and all is good.

Should the type be 'exception'?  Will that catch all?

The CFERROR, could i put that in my APPLICATION.CFM or is that  
dangerous?

Thanks,

Saturday


Then on my other page, request_err.cfm I have:


On 15 Jul 2005, at 14:50, Raymond Camden wrote:

> It is meant to be use in an error template. Check out the doc for
> , which lets you specify a page to run when an error occurs.
>
> On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
>
>> Thanks for that.
>>
>> Can I ask why it's not a good idea to use CFTRY/CFCATCH?
>>
>> Whereabouts do i put the CFMAIL script below?  It comes up with an
>> error saying that TYPE is undefined in ERROR?
>>
>> Thanks,
>>
>> Saturday
>>
>>
>> On 15 Jul 2005, at 14:06, Michael Dinowitz wrote:
>>
>>
>>> Sorry, forgot to mention that I use this code in a sitewide error
>>> handling template so every error on the site gets emailed to me,
>>> even ones in a CFTRY/CFCATCH. On a related note, don't use CFTRY/
>>> CFCATCH to handle known errors. Handle the error directly!
>>>
>>>
>>>
 
 
 
 
 
 >>> label="session">
 >>> label="application">
 


>>>
>>>
>>>
>>
>>
>>
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211983
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Query error

2005-07-15 Thread Douglas Knudsen
can you post a more informative error message? Also, test it without the 
queryparams. Also, maybe just build the SQL in a string and email it to 
yourself to see if the SQL and inputed arguments are actually coming in 
correct from Flash. 

Aside fro this I'll not that you should VAR scope your local variables too. 
:)

DK

On 7/14/05, Merrill, Jason <[EMAIL PROTECTED]> wrote:
> 
> Any idea why I'm getting an "Error Executing Database Query." With this?
> I can take out the query and return "lesson" and "row" just fine.
> Lesson and ID in the table are varchar and integer type fields
> respectively.
> 
> 
> 
> 
> 
> 
> UPDATE Lessons
> SET Lesson =  value="#Arguments.lesson#">
> WHERE ID =  value="#Arguments.row#">
> 
>  
> 
> 
> 
> Thanks.
> 
> Jason Merrill | E-Learning Solutions | 
> icfconsulting.com
> 
> 
> NOTICE:
> This message is for the designated recipient only and may contain 
> privileged or confidential information. If you have received it in error, 
> please notify the sender immediately and delete the original. Any other use 
> of this e-mail by you is prohibited.
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211982
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Why does only one datasource throw an error?

2005-07-15 Thread Jeff Small
I have a SQL server here for development, and all the other datasources that 
the CF Admin are pointing to that reside on that server are coming back as 
good (Verify all Connections...ok) but one is throwing an error. I deleted 
it, and tried to reinstall the datasource, but I got the following error:

Connection verification failed for data source: JMH
[]java.sql.SQLException: SQLException while attempting to connect: 
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested 
instance is either invalid or not running.
The root cause was that: java.sql.SQLException: SQLException while 
attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC 
Driver]The requested instance is either invalid or not running.

I don't understand...*what* instance is either invalid or not running? The 
SQL Server is there, it's running, the database is there, it's okay, the 
tables are there, they have data in them...*other* tables are there and are 
working...where should I go next? 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Delivery barcode

2005-07-15 Thread James Smith
> Actually if you are just doing 3of9 or UPC type barcodes it 
> is simple to do with a truetype font and a page or so of 
> code.  If this is what you are after I have already done the 
> work for our internal system here and you are welcome to it.  
> If you want 2D barcodes, good luck :)

Here is the code I use for EAN/UPC type barcodes...

This is called as a custom tag something like...


With a style like
..ean13 { font-family: "EAN-13"; font-size: 50px;}

Unfortunately I can't find the site I downloaded the font from but if anyone
wants it I can email it to you.

-





  



  Error, barcode wrong format.
  




























#barcode#



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211980
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Raymond Camden
It is meant to be use in an error template. Check out the doc for
, which lets you specify a page to run when an error occurs.

On 7/15/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote:
> Thanks for that.
> 
> Can I ask why it's not a good idea to use CFTRY/CFCATCH?
> 
> Whereabouts do i put the CFMAIL script below?  It comes up with an
> error saying that TYPE is undefined in ERROR?
> 
> Thanks,
> 
> Saturday
> 
> 
> On 15 Jul 2005, at 14:06, Michael Dinowitz wrote:
> 
> > Sorry, forgot to mention that I use this code in a sitewide error
> > handling template so every error on the site gets emailed to me,
> > even ones in a CFTRY/CFCATCH. On a related note, don't use CFTRY/
> > CFCATCH to handle known errors. Handle the error directly!
> >
> >
> >> 
> >> 
> >> 
> >> 
> >> 
> >>  >> label="session">
> >>  >> label="application">
> >> 
> >>
> >
> >
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Delivery barcode

2005-07-15 Thread James Smith
> As someone already mentioned, if you are just trying to 
> develop standard vertical line barcodes, then fusionzone is 
> the way to go.

Actually if you are just doing 3of9 or UPC type barcodes it is simple to do
with a truetype font and a page or so of code.  If this is what you are
after I have already done the work for our internal system here and you are
welcome to it.  If you want 2D barcodes, good luck :)

--
Jay



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211978
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Douglas Knudsen
You can also setup a custom site wide error template to do this. I set one 
up using this image
http://www.cubicleman.com/images/george_error.jpg funny, eh? 

in the template, after displaying the image and a message to the user, I 
have this





Browser: #error.browser#
Time: #error.datetime#
Diagnostics: #error.diagnostics#
HTTPReferer: #error.httpreferer#
Mailto: #error.mailto#
Message: #error.message#
QueryString: #error.querystring#
RemoteAddress: #error.remoteaddress#
RootCause: #error.rootcause#
StackTrace: #error.stacktrace#
Template: #error.template#
Type: #error.type#
JSessionID: #cookie.jsessionid# 
JRun Server Name: #jr.getServerName()#








note that when you use custom error templates, the CF logs are not populated 
with the error info, thus I have the above cflog statements.

DK

On 7/15/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
> 
> I caught and edited that after the fact. I've been up all night on a CF 7 
> speed increase project. Going fantastically (Love persister CFCs for query 
> caching) but while site speed saves, posting speed kills. :)
> 
> >Heh, so Stuart, just in case you are a newbie, don't forget to remove
> >the BCC below. If you don't, your errors will also email to Michael.
> >(Tsk tsk, Mikey. ;)
> >
> >On 7/15/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
> >>
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211977
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Michael Dinowitz
>Can I ask why it's not a good idea to use CFTRY/CFCATCH?
CFTRY/CFCATCH is to handle unexpected errors. If you expect the error, you 
should write your code to handle the error directly rather than expecting it to 
be handled in a general manner. Of course, this is my opinion and others will 
differ. CFTRY/CFCATCH is very efficient and has close to no overhead on a 
standard CF page. It's an issue of approach, not execution speed.

>Whereabouts do i put the CFMAIL script below?  It comes up with an  
>error saying that TYPE is undefined in ERROR?
I put it in a template, then map the template in the CFAdministrator under 
server settings - settings - site wide error handler. This will cause the 
template holding the code to be run every time an error is thrown. 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211976
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Saturday (Stuart Kidd)
Thanks for that.

Can I ask why it's not a good idea to use CFTRY/CFCATCH?

Whereabouts do i put the CFMAIL script below?  It comes up with an  
error saying that TYPE is undefined in ERROR?

Thanks,

Saturday


On 15 Jul 2005, at 14:06, Michael Dinowitz wrote:

> Sorry, forgot to mention that I use this code in a sitewide error  
> handling template so every error on the site gets emailed to me,  
> even ones in a CFTRY/CFCATCH. On a related note, don't use CFTRY/ 
> CFCATCH to handle known errors. Handle the error directly!
>
>
>> 
>> 
>> 
>> 
>> 
>> > label="session">
>> > label="application">
>> 
>>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211975
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query error

2005-07-15 Thread Merrill, Jason
Dave, thanks for your response.  See my responses below:

>>My guess is that one of the following is true:
>>
>>1. You don't have a datasource called "coursesDB".

I do.  I've been accessing it and making modifications to it.  It seems
only to mess up when I try and do this UPDATE type query.

>>2. The user account used by CF doesn't have rights to update the
Lessons
>>table.

It does.

>>3. The Lessons table belongs to another user account, so your user
account
>>can't see it without specifying the username explicitly ("UPDATE
>>otherusername.Lessons ...").

Nope.

>>4. The table is not in fact named "Lessons".

It is.

>>5. The table doesn't have a field called "Lesson".

It does.

>>6. The "Lesson" field doesn't contain a VARCHAR.

It does. at least in Access it designed to be field data type "Text"
which Dreamweaver displays as VARCHAR.  

>>7. The table doesn't have a field called "ID".

It does.

>>8. The "ID" field doesn't contain an INTEGER.

It does - at least in Access it designed to be field data type "Number".


>>9. You're passing the wrong datatype to one of the fields - my guess
would
>>be that Arguments.row should be a number instead of a string.

It does, at least as far as I know how Flash Remoting works,  I am
sending like this:

var pc:PendingCall = updateDatabaseService.recieveData({lesson:"How to
Dismantle an Atomic Bomb", row:9});

where 9 should be an integer, unless Remoting still sends it as a
string.  If so, it seems there is no way to be sure it's being sent as a
number from Flash, is there a way in CF to convert it from a string type
(if that's really how its being sent) to type numeric?   Or at least
find out what data type its being received as?

Thanks for your help.

Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com





NOTICE:
This message is for the designated recipient only and may contain privileged or 
confidential information. If you have received it in error, please notify the 
sender immediately and delete the original. Any other use of this e-mail by you 
is prohibited.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Flash CFFORM and visible attributes.

2005-07-15 Thread Stephen Moretti
I'm having problems with the visible attribute on the cfform tags.

visible="no" on :
cfgrid hides the grid, but leaves a blank spot the size of the grid.
cfinput, hides the control, but leaves the label.  A labelless 
cfinput leaves a blank spot.
cfformgroup does nothing at all.

This all stems from trying to hide some text fields that I'm using for 
calculations and bindings to text displays in other tabs in a form.
The hidden type cfinput can't be used in actionscript, so I had to use a 
text field.  Unfortunately making text fields invisible leaves a gap as 
I have noted above.  The next thought was to put my "working fields" 
onto a tab in the form which was disabled and invisible to the user.  
Disabling a tab doesn't disable the tab, it actually only greys out all 
of the form fields and, as I have already noted, the visible="no" 
attribute doesn't make any difference to the display of the tab.

I would really like to be able to hide the my "working fields" tab in a 
form I'm creating. I would also like to stop users from switching to the 
next tab when they haven't completed certain fields.

Is either of these possible?  Whats the deal with the visible 
attribute?  Am I misunderstanding how to use it?

Here's a much simplified example of the form I'm trying to build and the 
problems I'm seeing with the visible attribute.


SELECT group_id, group_desc
FROM tblMat_Group
ORDER BY Sequence








Select one...








#htmlcodeformat(thisForm)#



Any help would be much appreciated.

Regards

Stephen


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Removing pound signs from a string

2005-07-15 Thread Michael Dinowitz
I was under the impression that he was only looking to escape the pound sign in 
a SKU string. If the string is more than that, then you are correct and much 
more care is needed. 

>I was under the impression that he had other code that might have valid
>CFML, so doing a blanketed replace would corrupt that data. 
>
>Honestly, if you're going to let your users write executable CFML, then I'd
>just require them to escape their pound signs manually.
>
>-Dan

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211972
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF5 & RDS, does it run on a pre-defined port?

2005-07-15 Thread Che Vilnonis
Once again, thanks for confirming what I thought to be true.

-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 9:27 AM
To: CF-Talk
Subject: Re: CF5 & RDS, does it run on a pre-defined port?


Che,
RDS would use the SSL cert installed on the Web server. Most people I have
seen use RDS over port 80, because that is the default. I encourage people
to turn off RDS on production servers because of the security risks.
 -Mike Chabot
 On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
>
> OK, Mike. One more silly question. Does RDS have SSL built in or does it
> have to use a web server's SSL certificate?
>
> -Original Message-
> From: Mike Chabot [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 15, 2005 8:56 AM
> To: CF-Talk
> Subject: Re: CF5 & RDS, does it run on a pre-defined port?
>
>
> Che,
> The port would typically be 80 or 443. It is whatever port the Web server
> associated with ColdFusion is set up to listen to requests on. As a
> reminder, port 80 is unsecured. If someone sniffs your RDS password, they
> can potentially take control of your server.
> Enjoy,
> Mike Chabot
> On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> >
> > Does anyone know if RDS on CF5 runs on a pre-defined port?
> > Thanks.
> >
> > Che Vilnonis
> > Application Developer
> > Advertising Systems Incorporated
> > 8470C Remington Avenue
> > Pennsauken, NJ 08110
> > p: 856.488.2211
> > f: 856.488.1990
> > www.asitv.com  http://www.asitv.com




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF5 & RDS, does it run on a pre-defined port?

2005-07-15 Thread Mike Chabot
Che,
RDS would use the SSL cert installed on the Web server. Most people I have 
seen use RDS over port 80, because that is the default. I encourage people 
to turn off RDS on production servers because of the security risks.
 -Mike Chabot
 On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: 
> 
> OK, Mike. One more silly question. Does RDS have SSL built in or does it
> have to use a web server's SSL certificate?
> 
> -Original Message-
> From: Mike Chabot [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 15, 2005 8:56 AM
> To: CF-Talk
> Subject: Re: CF5 & RDS, does it run on a pre-defined port?
> 
> 
> Che,
> The port would typically be 80 or 443. It is whatever port the Web server
> associated with ColdFusion is set up to listen to requests on. As a
> reminder, port 80 is unsecured. If someone sniffs your RDS password, they
> can potentially take control of your server.
> Enjoy,
> Mike Chabot
> On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> >
> > Does anyone know if RDS on CF5 runs on a pre-defined port?
> > Thanks.
> >
> > Che Vilnonis
> > Application Developer
> > Advertising Systems Incorporated
> > 8470C Remington Avenue
> > Pennsauken, NJ 08110
> > p: 856.488.2211
> > f: 856.488.1990
> > www.asitv.com  http://www.asitv.com


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


CFSELECT (I hate CFFORM)

2005-07-15 Thread Stan Winchester
Are there any JavaScript errors? If so, try using FireFox's JS debugger. I have 
found CFFORM's JS sometimes will conflict with other JS that might be on the 
page. You could also just use a select tag and write your own JS to validate or 
use qForms as previously suggested.

Stan Winchester
Aftershock Web Design
http://www.aftershockweb.com/

>Hi All,
>
>I NEVER use CFFORM, but I've taken over  a site that does *sigh* ;-)
>
>Any idea why this code would NOT throw a typical CFFORM JavaScript alert
>when the user does not select anything?
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF5 & RDS, does it run on a pre-defined port?

2005-07-15 Thread Che Vilnonis
OK, Mike. One more silly question. Does RDS have SSL built in or does it
have to use a web server's SSL certificate?

-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 8:56 AM
To: CF-Talk
Subject: Re: CF5 & RDS, does it run on a pre-defined port?


Che,
The port would typically be 80 or 443. It is whatever port the Web server
associated with ColdFusion is set up to listen to requests on. As a
reminder, port 80 is unsecured. If someone sniffs your RDS password, they
can potentially take control of your server.
 Enjoy,
Mike Chabot
 On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
>
> Does anyone know if RDS on CF5 runs on a pre-defined port?
> Thanks.
>
> Che Vilnonis
> Application Developer
> Advertising Systems Incorporated
> 8470C Remington Avenue
> Pennsauken, NJ 08110
> p: 856.488.2211
> f: 856.488.1990
> www.asitv.com 




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211968
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Removing pound signs from a string

2005-07-15 Thread Dan G. Switzer, II
Michael,

>In truth all you have to do is double the pound signs so Replace(string,
>'##', '', 'all') should do it. It will replace every single pound
>within your text with a double pound, ignoring everything else.

I was under the impression that he had other code that might have valid
CFML, so doing a blanketed replace would corrupt that data. 

Honestly, if you're going to let your users write executable CFML, then I'd
just require them to escape their pound signs manually.

-Dan



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Michael Dinowitz
I caught and edited that after the fact. I've been up all night on a CF 7 speed 
increase project. Going fantastically (Love persister CFCs for query caching) 
but while site speed saves, posting speed kills. :)

>Heh, so Stuart, just in case you are a newbie, don't forget to remove
>the BCC below. If you don't, your errors will also email to Michael.
>(Tsk tsk, Mikey. ;)
>
>On 7/15/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
>>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Event gateways and real player

2005-07-15 Thread Michael Dinowitz
If the internal browser has a http_user_agent that identifies it as a real 
player, then a simple CFIF on the target CF page will allow you to handle the 
real player content from other content. Or you can just have a different real 
player page.
Is there a different user agent and can you post what it is?
Thanks

>Dear All, 
>
>This is my first post to this list!
>
> 
>
>I'm looking to possibly set a way to divert CF page requests made from
>within real player (enterprise or likewise) to a site. At the moment, I can
>browse the pages from within real player, but want to customise the pages
>specifically:
>
> 
>
>Is this the sort of thing I could do with an Event gateway? Or is there a
>simpler way of doing it?
>
> 
>
>I'm assuming that the internal browser built into real player will be
>identifiable to CF, and thus you could divert requests, much like you would
>do if browsing from a mobile device?
>
> 
>
>Any ideas on this would be appreciated.
>
> 
>
>Best, 
>
>Tom

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211965
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Catching errors and emailing

2005-07-15 Thread Raymond Camden
Heh, so Stuart, just in case you are a newbie, don't forget to remove
the BCC below. If you don't, your errors will also email to Michael.
(Tsk tsk, Mikey. ;)

On 7/15/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
>  type="HTML">
> 
> 
> 
> 
>  label="session">
>  label="application">
> 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211964
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Catching errors and emailing

2005-07-15 Thread Michael Dinowitz
Sorry, forgot to mention that I use this code in a sitewide error handling 
template so every error on the site gets emailed to me, even ones in a 
CFTRY/CFCATCH. On a related note, don't use CFTRY/CFCATCH to handle known 
errors. Handle the error directly!

>
>   
>   
>   
>   
>label="session">
>label="application">
>

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211963
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF5 & RDS, does it run on a pre-defined port?

2005-07-15 Thread Che Vilnonis
thanks... that is what i thought.

-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 8:56 AM
To: CF-Talk
Subject: Re: CF5 & RDS, does it run on a pre-defined port?


Che,
The port would typically be 80 or 443. It is whatever port the Web server
associated with ColdFusion is set up to listen to requests on. As a
reminder, port 80 is unsecured. If someone sniffs your RDS password, they
can potentially take control of your server.
 Enjoy,
Mike Chabot
 On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
>
> Does anyone know if RDS on CF5 runs on a pre-defined port?
> Thanks.
>
> Che Vilnonis
> Application Developer
> Advertising Systems Incorporated
> 8470C Remington Avenue
> Pennsauken, NJ 08110
> p: 856.488.2211
> f: 856.488.1990
> www.asitv.com 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211962
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Catching errors and emailing

2005-07-15 Thread Michael Dinowitz







 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211961
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF5 & RDS, does it run on a pre-defined port?

2005-07-15 Thread Mike Chabot
Che,
The port would typically be 80 or 443. It is whatever port the Web server 
associated with ColdFusion is set up to listen to requests on. As a 
reminder, port 80 is unsecured. If someone sniffs your RDS password, they 
can potentially take control of your server.
 Enjoy,
Mike Chabot
 On 7/15/05, Che Vilnonis <[EMAIL PROTECTED]> wrote: 
> 
> Does anyone know if RDS on CF5 runs on a pre-defined port?
> Thanks.
> 
> Che Vilnonis
> Application Developer
> Advertising Systems Incorporated
> 8470C Remington Avenue
> Pennsauken, NJ 08110
> p: 856.488.2211
> f: 856.488.1990
> www.asitv.com 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211960
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >