Stream data with ADO in CF
Has anyone successfully streamed data with ADO in ColdFusion? If you want to know why? I am using FOR XML in MS SQL and need to retrieve the result, if you know any better ways I'd love to hear about it. Samples please... At the moment I am getting an error when I try to stream with ADO, the error is "Type mismatch in provider" Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
The selected method ResolvePath was not found
I get the error "The selected method ResolvePath was not found" when trying to inspect a local web service, i.e. /my.cfc?wdsl I am not invoking it, I am just inspecting it, i.e. access http:///my.cfc?wdsl via the browser I'm on Apache if that could make any difference? Any ideas? Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ANNOUNCE: ColdFusion MX Master Class, July 19th
True, England can't seem to hold onto anything for very long. certainly not a one-goal lead... _ From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 24 June 2004 17:24 To: CF-Talk Subject: RE: ANNOUNCE: ColdFusion MX Master Class, July 19th Nah. The British would have lost this colony just like they lost every other one. It would have taken longer, agreed. Jerry Johnson >>> [EMAIL PROTECTED] 06/24/04 12:12PM >>> Would those be the same cheese-eating surrender-monkeys without whose help you would still be under British rule? ;P (sorry, couldn't resist!) _ From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: 24 June 2004 16:55 To: CF-Talk Subject: RE: ANNOUNCE: ColdFusion MX Master Class, July 19th French restaurant? Let's not support the cheese-eating surrender-monkeys as part of the class. :-) Greg -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 11:12 AM To: CF-Talk Subject: ANNOUNCE: ColdFusion MX Master Class, July 19th Join us July 19th for five challenging days of ColdFusion MX training. The ColdFusion MX Master Class is five extended-hour days of intensive advanced training (8:00 AM to 7:00 PM) in the very best ColdFusion engineering techniques, followed by a sumptuous and hard-earned graduation dinner at the finest French restaurant in Atlanta. Classes are limited to only three students per class, and each class is personally taught by Adam and David Churvis (the principal authors of The ColdFusion MX Bible), so these classes are more like personal mentoring than a regular training class. You'll even get after-class support from us to help you resolve challenging issues. Check out the itinerary at http://www.ColdFusionTraining.com. David and I hope to see you in July! :) PS-- If your budget's almost shot or your boss is tightening the ropes, then give me a call at 770-446-8866 and we'll do what we can to accommodate you. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training: * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cftransaction inside or outside cfloops?
Also, it may help in these situations to think of as a kind of DB-based Transactions, depending on the isolation level, may need to lock the db (either on a row or table basis) to stop any other process making a change while the transaction completes. It's worth bearing this in mind if the loop is going to be more than just a few records. I always try and put the cftransaction around the least amount of code possible, for this very reason. _ From: Steve Nelson [mailto:[EMAIL PROTECTED] Sent: 10 June 2004 19:16 To: CF-Talk Subject: cftransaction inside or outside cfloops? Which is better and why? insert insert insert Vs. insert insert insert Steve Nelson _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Coldfusion & Regex
Can anybody on the list provide any examples of using coldfusion with regex. For example I have the following line of regex that checks for the detection of SQL meta characters, which will help prevent SQL Injection etc /(\%27)|(\')|(\-\-)|(\%23)|(#)/ix I envisage this will be placed in the application .cfm of the site, but how would you integrate it in with coldfusion to check for invalid input via cookies, form input, http entries etc??? Any ideas would be most welcome Thanks Ian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion & Regex
You could for example check if the chi.request_method is POST, if so loop over the form structure and run the regex on each key of the form structure, you could do the same thing for the URL structure. But. your probably better of using cfqueryparam or cfprocparam, which I believe should protect you against SQL injection in most cases. Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Friday, 25 June 2004 6:58 PM To: CF-Talk Subject: Coldfusion & Regex Can anybody on the list provide any examples of using coldfusion with regex. For example I have the following line of regex that checks for the detection of SQL meta characters, which will help prevent SQL Injection etc /(\%27)|(\')|(\-\-)|(\%23)|(#)/ix I envisage this will be placed in the application .cfm of the site, but how would you integrate it in with coldfusion to check for invalid input via cookies, form input, http entries etc??? Any ideas would be most welcome Thanks Ian _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion & Regex
function isValid( strInput ){
// NOTE: the hash character must be escaped
// to prevent the CF engine thinking it's the start
// of a variable name
var reRegEx = "/(\%27)|(\')|(\-\-)|(\%23)|(##)/ix";
if( REFindNoCase( reRegEx, arguments.strInput ) GT 0 ){
return false;
} else {
return true;
}
}
...
Hope that helps
Alistair
Alistair Davidson
Senior Technical Developer
Headshift.com
--
HEADSHIFT >> www.headshift.com
T: 020 7357 7358
--
smarter > simpler > social >
_
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: 25 June 2004 09:58
To: CF-Talk
Subject: Coldfusion & Regex
Can anybody on the list provide any examples of using coldfusion with
regex.
For example I have the following line of regex that checks for the
detection of SQL meta characters, which will help prevent SQL Injection
etc
/(\%27)|(\')|(\-\-)|(\%23)|(#)/ix
I envisage this will be placed in the application .cfm of the site, but
how would you integrate it in with coldfusion to check for invalid input
via cookies, form input, http entries etc???
Any ideas would be most welcome
Thanks
Ian
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Coldfusion & Regex
function isValid( strInput ){
// NOTE: the hash character must be escaped
// to prevent the CF engine thinking it's the start
// of a variable name
var reRegEx = "/(\%27)|(\')|(\-\-)|(\%23)|(##)/ix";
if( REFindNoCase( reRegEx, arguments.strInput ) GT 0 ){
return false;
} else {
return true;
}
}
...
Hope that helps
Alistair
Alistair Davidson
Senior Technical Developer
Headshift.com
--
HEADSHIFT >> www.headshift.com
T: 020 7357 7358
--
smarter > simpler > social >
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Coldfusion & Regex
Use to prevent sql injection. You can do what you described in the application.cfm on the scopes url, form, cookie. Loop over the scopes and check the vars. The regexps in CF are different though: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp.htm Pascal > -Original Message- > From: Ian Vaughan [mailto:[EMAIL PROTECTED] > Sent: vrijdag 25 juni 2004 10:58 > To: CF-Talk > Subject: Coldfusion & Regex > > Can anybody on the list provide any examples of using > coldfusion with regex. > > For example I have the following line of regex that checks > for the detection of SQL meta characters, which will help > prevent SQL Injection etc > > /(\%27)|(\')|(\-\-)|(\%23)|(#)/ix > > I envisage this will be placed in the application .cfm of the > site, but how would you integrate it in with coldfusion to > check for invalid input via cookies, form input, http entries etc??? > > Any ideas would be most welcome > > Thanks > > Ian > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion & Regex
The regexp you used will not work as intended in CF !
> -Original Message-
> From: Alistair Davidson [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 25 juni 2004 11:35
> To: CF-Talk
> Subject: RE: Coldfusion & Regex
>
>
>
>
> function isValid( strInput ){
>
> // NOTE: the hash character must be escaped
> // to prevent the CF engine thinking it's the start
> // of a variable name
> var reRegEx = "/(\%27)|(\')|(\-\-)|(\%23)|(##)/ix";
>
> if( REFindNoCase( reRegEx, arguments.strInput ) GT 0 ){
> return false;
> } else {
> return true;
>}
> }
>
>
>
> ...
>
>
>
>
>
>
>
> Hope that helps
>
> Alistair
>
> Alistair Davidson
> Senior Technical Developer
> Headshift.com
> --
> HEADSHIFT >> www.headshift.com
> T: 020 7357 7358
> --
> smarter > simpler > social >
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Some Expert input on this
I am no expert in Object Oriented Programming, and I'm pretty sure I am
loosing the plot somewhere with the following cfc, I would really appreciate
some expert input from someone (Sean where art thou)..
I believe I need to lock any access to the object as its in the server
scope, not sure yet whether it gives better performance creating the object
only once in the server and lock access to it, or recreate the object every
time and not having to lock access to it, I believe its the first one.
I think I am losing the plot when we get to
request.result.objError.fnConstruct( request.result );
request.result.objError.fnDisplay( request.result );
But I can't really tell you why, but I'm pretty sure its not a good thing
having to pass itself back with request.result
Hope someone's still awake..
test.cfm
// this will eventually only be set once in the server scope
server.objProcess = createObject("component", "process");
throwontimeout="yes"
type="exclusive"
scope="server">
request.result = server.objProcess.fnExecute( "this string means nothing"
);
request.result.objError.fnConstruct( request.result );
request.result.objError.fnDisplay( request.result );
process.cfc
this.result = structNew();
message = structNew();
structInsert(message, "isDisplayed", false);
structInsert(message, "isMessage", false);
structInsert(message, "myArray", arrayNew(1));
structInsert(message, "myString", "");
structInsert(this.result, "message", message);
error = structNew();
structInsert(error, "isDisplayed", false);
structInsert(error, "isError", false);
structInsert(error, "myArray", arrayNew(1));
structInsert(error, "myString", "");
structInsert(this.result, "error", error);
structInsert(this.result, "objError", createObject("component", "error"));
name="fnExecute"
output="false"
returntype="struct">
type="string"
required="true">
#ttt#
' )>
error.cfc
hint="I work with errors">
name="fnAppend"
output="false"
returntype="any"
displayname="Error Append"
hint="I append an error message to an array">
type="struct"
required="true"
displayname="Result Structure"
hint="I am the Result Structure">
type="string"
required="true"
default="There was an error"
displayname="Error Message"
hint="I am the error message to append">
arguments.errorMessage)>
name="fnConstruct"
output="false"
returntype="struct"
displayname="Error Construct"
hint="I construct error messages">
type="struct"
required="true"
displayname="Result Structure"
hint="I am the Result Structure">
index="i">
#arguments.result.error.myArray[ i
]#">
">
name="fnDisplay"
output="true"
returntype="any"
displayname="Error Display"
hint="I display error messages">
type="struct"
required="true"
displayname="Result Structure"
hint="I am the structure that contains the result">
structUpdate(arguments.result.error, "isDisplayed", true);
name="fnClear"
output="false"
returntype="any"
displayname="Error Clear"
hint="I clear error messages">
type="struct"
required="true"
displayname="Result Structure"
hint="I am the structure that contains the result">
Taco Fleur
Tell me and I will forget
Show me and I will remember
Teach me and I will learn
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Coldfusion & Regex
Pascal
How would I reference the scopes url, form etc ? A snippet would help me
get me head around this.
So why wouldnt the code (regex) below work in coldfusion ??
cfscript>
function isValid( strInput ){
// NOTE: the hash character must be escaped
// to prevent the CF engine thinking it's the start
// of a variable name
var reRegEx = "/(\%27)|(\')|(\-\-)|(\%23)|(##)/ix";
var reRegEx =
"/((\%3C)|<)((\%69)|i|(\%49))((\%6D)|m|(\%4D))((\%67)|g|(\%47))[^\n]+((\
%3E)|>)/I";
if( REFindNoCase( reRegEx, arguments.strInput ) GT 0 ){
return false;
} else {
return true;
}
}
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 25 June 2004 11:16
To: CF-Talk
Subject: RE: Coldfusion & Regex
Use to prevent sql injection.
You can do what you described in the application.cfm on the scopes url,
form, cookie. Loop over the scopes and check the vars. The regexps in CF
are different though:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp.htm
Pascal
> -Original Message-
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 25 juni 2004 10:58
> To: CF-Talk
> Subject: Coldfusion & Regex
>
> Can anybody on the list provide any examples of using
> coldfusion with regex.
>
> For example I have the following line of regex that checks
> for the detection of SQL meta characters, which will help
> prevent SQL Injection etc
>
> /(\%27)|(\')|(\-\-)|(\%23)|(#)/ix
>
> I envisage this will be placed in the application .cfm of the
> site, but how would you integrate it in with coldfusion to
> check for invalid input via cookies, form input, http entries etc???
>
> Any ideas would be most welcome
>
> Thanks
>
> Ian
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: java.lang.OutOfMemoryError
There's also a sneaky workaround I found involving the inbuilt java.lang.System object. I wrote a blog article about it here (a bit waffly, but you can just skip straight to the code at the bottom!) : http://instantbadger.blogspot.com/2004_06_01_instantbadger_archive.html# 108798595159007922 Hope that helps, Alistair -- HEADSHIFT >> www.headshift.com T: 020 7357 7358 -- smarter > simpler > social > _ From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: 19 June 2004 00:12 To: CF-Talk Subject: java.lang.OutOfMemoryError I am program-parsing a large XML file -- my iTunes library: 3,9 Meg 85,000 lines 3,500 tracks 20 Playlists 1 Library Playlist containing all the tracks. A big file When I tried doing this with CFMX XML functions, everything was in memory and I got the" "java.lang.OutOfMemoryError" With the help of Joe Rinehart I put together a Java object to read the XML file, line by line. [EMAIL PROTECTED] I parse each line and: 1) Build a structure of structures of track info: TrackID --- Title --- Artist --- File Path 2) Build a Structuer of structures of structures of structures of Playlist info PlayListID ---Name ---Tracks --TrackNumber -TrackID Title Artist File Path as I create each track in the playlist, I populate it with the info from the tracks structure. This all goes well and I am left with 2 big structures in memory. For debugging purposes, I decided to cfdump both structures. Strange thing happens: the program completes and displays the track structure (the first cfdump) about half through the playlist structure the display stops and I get: java.lang.OutOfMemoryError I can change the program so that it just does either one cfdump or the other and it runs fine. so, I added a cfflusg between the 2 cfdumps and it runs fine. My questions: What is causing the out of memory error? Is there a memory limit to CF tags such as cfdump, cfhttp, cffile, etc? if so what is it. Can/should I change JVM settings to alleviate this? TIA Dick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: java.lang.OutOfMemoryError
There's also a sneaky workaround I found involving the inbuilt java.lang.System object. I wrote a blog article about it here (a bit waffly, but you can just skip straight to the code at the bottom!) : http://instantbadger.blogspot.com/2004_06_01_instantbadger_archive.html# 108798595159007922 Hope that helps, Alistair -- HEADSHIFT >> www.headshift.com T: 020 7357 7358 -- smarter > simpler > social > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [ANN] BlueDragon 6.1 Released!
>>final release of BlueDragon 6.1 Does it supports CFX_s or equivalent? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
inventory management
I'm using the Cartweaver e-commerce for a customer and would like to have an easier way to receive inventory into the database. Currently, you must go to the item and then it's sku page and add your received quantity. This will be tedious seeing as my customer currently has over 1500 items in the inventory table and may receive 10 different items or 100 items at any given time. Has anyone written any software/tags that could be modified to allow the manager to key in all the parts rec'd and quantities and then the update to the database occurrs? Thanks in advance -- Chris Tilley [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion & Regex
And the same for url & cookie
The regexp won't work, because it is JS syntax (I think) and NOT CF
syntax.
/ is a normal character in CF
\%3C will match "%3C" and not the ascii character corresponding with the
hexcode 3C
/I will match /I and not make the regexp case insensitive
.
Pascal
> -Original Message-
> From: Ian Vaughan [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 25 juni 2004 12:38
> To: CF-Talk
> Subject: RE: Coldfusion & Regex
>
> Pascal
>
> How would I reference the scopes url, form etc ? A snippet
> would help me get me head around this.
>
> So why wouldnt the code (regex) below work in coldfusion ??
>
> cfscript>
>
> function isValid( strInput ){
>
> // NOTE: the hash character must be escaped
> // to prevent the CF engine thinking it's the start
> // of a variable name
> var reRegEx = "/(\%27)|(\')|(\-\-)|(\%23)|(##)/ix";
> var reRegEx =
> "/((\%3C)|<)((\%69)|i|(\%49))((\%6D)|m|(\%4D))((\%67)|g|(\%47)
> )[^\n]+((\
> %3E)|>)/I";
>
> if( REFindNoCase( reRegEx, arguments.strInput ) GT 0 ){
> return false;
> } else {
> return true;
>}
> }
>
>
>
>
>
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: 25 June 2004 11:16
> To: CF-Talk
> Subject: RE: Coldfusion & Regex
>
>
> Use to prevent sql injection.
>
> You can do what you described in the application.cfm on the
> scopes url,
> form, cookie. Loop over the scopes and check the vars. The
> regexps in CF
> are different though:
>
> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp.htm
>
> Pascal
>
> > -Original Message-
> > From: Ian Vaughan [mailto:[EMAIL PROTECTED]
> > Sent: vrijdag 25 juni 2004 10:58
> > To: CF-Talk
> > Subject: Coldfusion & Regex
> >
> > Can anybody on the list provide any examples of using
> > coldfusion with regex.
> >
> > For example I have the following line of regex that checks
> > for the detection of SQL meta characters, which will help
> > prevent SQL Injection etc
> >
> > /(\%27)|(\')|(\-\-)|(\%23)|(#)/ix
> >
> > I envisage this will be placed in the application .cfm of the
> > site, but how would you integrate it in with coldfusion to
> > check for invalid input via cookies, form input, http
> entries etc???
> >
> > Any ideas would be most welcome
> >
> > Thanks
> >
> > Ian
> >
> >
> >
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
how to open an attached file in its own application (ms-word, excel etc).. please read
Hello everybody,
I have CFMX installed running on a windows machine.
I have a section on the site where users can view the
files that are attached to a log.
I've called this file showAttachments.cfm
Here is the code:
showattachments.cfm
---
select * from attachments where logID = '#url.id#'
cellspacing="0">
window.open('viewattachment.cfm?id=#fileID#&filename=#fileName#',
'Document',
'top=10,left=10,height=500,width=600,resizable=Yes,scrollbars=Yes')">#fileName#
Clicking on the ahref link opens up
viewattachment.cfm.
Here is the code.
viewattachment.cfm
---
select * from attachments where logID = '#url.id#'
and fileName = '#url.filename#'
DATASOURCE="db"
USER=""
PASSWORD=""
SQL="select Contents FROM attachment WHERE logID =
'#url.id#' and fileName = '#url.filename#'"
OUTPUT="E:\inetpub\wwwroot\FileUploads\#fName#">
mimetypes=arraynew(1);
mimetypes[1]="application/msword,application/msword,doc";
mimetypes[2]="application/x-msexcel,xls";
mimetypes[3]="application/pdf,application/pdf,pdf";
mimetypes[4]="text/plain,text/plain,txt";
mimetypes[5]="application/rtf,application/rtf,rtf";
mimetypes[6]="application/text,plain,csv";
mimetypes[7]="image/jpeg,image/jpeg,jpg,image/x-png,image/pjpeg,image/png,image/jfif";
mimetypes[8]="image/gif,image/gif,gif";
mimetypes[9]="application/x-visio,vsd";
mimetypes[10]="application/drafting,drw";
mimetypes[11]="model/vnd.dwf,dwf";
mimetypes[12]="image/x-dwg,dwg";
mimetypes[13]="application/dxf,dxf";
mimetypes[14]="application/x-excel,xls";
mimetypes[15]="application/vnd.ms-excel,xls";
legalextensions="doc,xls,pdf,txt,rtf,csv,gif,jpg,vsd,drw,dwf,dwg,dxf";
mimetype=listgetat(mimetypes[listfindnocase(legalextensions,trim(right(fName,3)))],1);
FILE="E:\inetpub\wwwroot\FileUploads\#fName#"
deletefile="yes">
An error has
occurred!.
The above code works fine. It opens the file inside
the browser window. However I want the file to open
inside its own application. So if the attached file is
a word document, I want it to open in msword. Also,
because this is an intranet/internal application, once
after the document is open, if the user wishes to edit
the document, I want to save the changes automatically
saved back to the database when the user presses the
save button. I hope I am making sense.
Can somebody show me how to do this.
I'll really appreciate your help
Best regards
cfcoder
__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Catching this Error
Hi, I'm trying to catch the error below, but I'm not sure what scope it is in, or how to display it in an error template. When I wrap the cfstoredproc in a cftry tag, I can catch the error generically, but I cannot display this specific error message because I do not know what variable is holding it. It's not in the Error scope, for example. What can I put in the Cfdump var = "[Insert Var Here]" to get the message below, if any? Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK_Timer'. Cannot insert duplicate key in object 'Timer'. I'm also trying to trap this error message in the stored proc itself, but that's for another group. TIA. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
On Fri, 25 Jun 2004 06:43:35 -0700 (PDT), cf coder <[EMAIL PROTECTED]> wrote: > > > The above code works fine. It opens the file inside > the browser window. However I want the file to open > inside its own application. So if the attached file is > a word document, I want it to open in msword. Also, > because this is an intranet/internal application, once > after the document is open, if the user wishes to edit > the document, I want to save the changes automatically > saved back to the database when the user presses the > save button. I hope I am making sense. > Can somebody show me how to do this. > I don't believe you can force this, as it's an end-user preference setting in the browser. The only alternative I can think of is to serve the file with a mime type of "application/unknown," which makes the user to download the file to their system instead of opening in a browser. From there, they can open the document in the relevant application. It's not pretty, but it's an alternative. As a side note, browsers such as Mozilla Firefox will open the document in the external application by default (I believe because it does not support ActiveX), with the exception of the Acrobat Reader plugin. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: inventory management
Do they have an SKU bar code or something on the physical product? On my last project, they would just scan the bar code, and it jumps right to the product info page, and they can do whatever theyw ant to it (update inventory for that particlular item, change description, etc). All of this web based, with some _javascript_ - Original Message - From: Chris Tilley To: CF-Talk Sent: Friday, June 25, 2004 8:03 AM Subject: inventory management I'm using the Cartweaver e-commerce for a customer and would like to have an easier way to receive inventory into the database. Currently, you must go to the item and then it's sku page and add your received quantity. This will be tedious seeing as my customer currently has over 1500 items in the inventory table and may receive 10 different items or 100 items at any given time. Has anyone written any software/tags that could be modified to allow the manager to key in all the parts rec'd and quantities and then the update to the database occurrs? Thanks in advance -- Chris Tilley [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
there must be a way to do this. I mean, its hard to beleive that nobody has ever tried to find a solution to this problem. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [ANN] BlueDragon 6.1 Released!
Yes, BlueDragon 6.1 supports CFX tags implemented in both Java and C++. Any CFX tag that runs on CF5/MX will run correctly on BlueDragon. Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 8:58 AM To: CF-Talk Subject: Re: [ANN] BlueDragon 6.1 Released! >>final release of BlueDragon 6.1 Does it supports CFX_s or equivalent? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
it's a feature of the local browser not something controllable. There's an option that needs to be flagged in eg. excel to stop it opening the spreadsheet within an IE session. Of course, if you don't use IE then the problem goes away. On Fri, 25 Jun 2004 10:25:45 -0400, cf coder <[EMAIL PROTECTED]> wrote: > > there must be a way to do this. I mean, its hard to beleive that nobody has ever tried to find a solution to this problem. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: how to open an attached file in its own application (ms-word, excel etc).. please read
You have a problem here: It's saying open in the browser. Change it to HTH, Sam -- Blog: http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 9:44 AM To: CF-Talk Subject: how to open an attached file in its own application (ms-word, excel etc).. please read Hello everybody, I have CFMX installed running on a windows machine. I have a section on the site where users can view the files that are attached to a log. I've called this file showAttachments.cfm Here is the code: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
i wouldnt concider being in control of my OWN puter a problem, the problem i see is having some other coder whos not thinking clearly deciding how i should best view the material and with what program. sounds like a job for M$ maybe u should look at FrontPage, I'm sure thats one of the #1 tools thats included just my half dimwhitted opinion -- Original Message -- From: cf coder <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 25 Jun 2004 10:25:45 -0400 >there must be a way to do this. I mean, its hard to beleive that nobody has ever tried to find a solution to this problem. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cffile question
hi there. ok, I have a mapped network drive, that from my cfmx server, I can write files to, etc...however when I try to use coldfusion and cffile, to create the file on the mapped network drive, it gives me an error, access denied. Detail The cause of this exception was: java.io.FileNotFoundException: f:\vehiclesIncsvFormat.csv (Access is denied). Message An error occurred when performing a file operation WRITE on file f:\vehiclesIncsvFormat.csv. RootCause struct Message f:\vehiclesIncsvFormat.csv (Access is denied) any ideas? permissions are set to EVERYONE, full control. (for now, until I get this working and can pare down permissions.) ideas anyone? thanks ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 visit www.antiwrap.com to send long url emails to your friends! -- dont mistake my perfection as arrogance anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
So weird - cannot use variable for query in CFQUERY
Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server Regardless of the query used the following code gives me an "Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax " error: #myquery# datasource="#datasource#">#myquery# However it works if I don't use a variable and instead literally put the same query inside the query block: select Count(*) as thecount from cdomains where thedomain='#ListGetAt(getcustomer.email,2,"@")#'; I have been working on this for hours and can't figure it out. I know I have stored my queries in variables before but it won't work in this case. Anyone ever seen this? -Dustin Snell Unisyn Software, LLC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: So weird - cannot use variable for query in CFQUERY
maybe its not parsing the #listGetAt# like it should? tw -Original Message- From: Dustin Snell [Unisyn Software, LLC] [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:53 AM To: CF-Talk Subject: So weird - cannot use variable for query in CFQUERY Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server Regardless of the query used the following code gives me an "Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax " error: #myquery# datasource="#datasource#">#myquery# However it works if I don't use a variable and instead literally put the same query inside the query block: select Count(*) as thecount from cdomains where thedomain='#ListGetAt(getcustomer.email,2,"@")#'; I have been working on this for hours and can't figure it out. I know I have stored my queries in variables before but it won't work in this case. Anyone ever seen this? -Dustin Snell Unisyn Software, LLC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: how to open an attached file in its own application (ms-word, excel etc).. please read
why? Cause everyone has M$ Word or Excel? Using CFCONTENT you can tell the browser to expect a different mimetype and perhaps download or open it, perhaps, perhaps. What the browser does with this knowledge is beyond your control. Doug -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:26 AM To: CF-Talk Subject: Re: how to open an attached file in its own application (ms-word, excel etc).. please read there must be a way to do this. I mean, its hard to beleive that nobody has ever tried to find a solution to this problem. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: So weird - cannot use variable for query in CFQUERY
PerserveSingleQuotes() perhaps? datasource="#datasource#">#PreserveSingleQuotes(myquery)# Doug -Original Message- From: Dustin Snell [Unisyn Software, LLC] [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:53 AM To: CF-Talk Subject: So weird - cannot use variable for query in CFQUERY Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server Regardless of the query used the following code gives me an "Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax " error: #myquery# datasource="#datasource#">#myquery# However it works if I don't use a variable and instead literally put the same query inside the query block: select Count(*) as thecount from cdomains where thedomain='#ListGetAt(getcustomer.email,2,"@")#'; I have been working on this for hours and can't figure it out. I know I have stored my queries in variables before but it won't work in this case. Anyone ever seen this? -Dustin Snell Unisyn Software, LLC _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cffile question
Tony, Are your cfmx services running under the localSystem account or an administrator account? I think that sometimes your LocalSystem account may not have rights to mapped drives, whereas if your CFMX services is running under an administrator account, you'll have better luck. Sincerely, Andrew Webmaster -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 9:44 AM To: CF-Talk Subject: cffile question hi there. ok, I have a mapped network drive, that from my cfmx server, I can write files to, etc...however when I try to use coldfusion and cffile, to create the file on the mapped network drive, it gives me an error, access denied. Detail The cause of this exception was: java.io.FileNotFoundException: f:\vehiclesIncsvFormat.csv (Access is denied). Message An error occurred when performing a file operation WRITE on file f:\vehiclesIncsvFormat.csv. RootCause struct Message f:\vehiclesIncsvFormat.csv (Access is denied) any ideas? permissions are set to EVERYONE, full control. (for now, until I get this working and can pare down permissions.) ideas anyone? thanks ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 visit www.antiwrap.com to send long url emails to your friends! -- dont mistake my perfection as arrogance anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: So weird - cannot use variable for query in CFQUERY
I think you've having a problem with single quotes being escapedtry: #preserveSingleQuotes(myquery)# -joe - Original Message - From: Dustin Snell [Unisyn Software, LLC] <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 07:53:16 -0700 Subject: So weird - cannot use variable for query in CFQUERY To: CF-Talk <[EMAIL PROTECTED]> Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server Regardless of the query used the following code gives me an "Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax " error: #myquery# datasource="#datasource#">#myquery# However it works if I don't use a variable and instead literally put the same query inside the query block: select Count(*) as thecount from cdomains where thedomain='#ListGetAt(getcustomer.email,2,"@")#'; I have been working on this for hours and can't figure it out. I know I have stored my queries in variables before but it won't work in this case. Anyone ever seen this? -Dustin Snell Unisyn Software, LLC [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: how to open an attached file in its own application (ms-word, excel etc).. please read
There is no way to do this from a browser (unless you use ActiveX, possibly - I've never tried it) , for very valid security reasons Can you imagine the security risks if it was possible to craft a HTML document that would automatically force-launch a downloaded document in an external application ? No? OK, lemme give you a for instance - I have a word document on my web server In that word document is a VBA macro In that macro is code that sets your IE bookmarks, your homepage, and your Active Desktop to a given url. What if I set that URL to some really nasty hardcore kiddie sado-porn sites? What if I then followed that code with some more code to auto-launch a browser window? What if I then followed that code with some other code to capture the desktop image, and mail it along with a list of your favourites, to fbi.gov, and every other email address I find on your PC? And what if i put some code to auto-download and force-launch that document into one of my web pages? OK, that may be a bit over-convoluted, let's try a simpler example - The way you normally launch a document in a stand-alone application is by executing the application's .exe file with the document title as the first command line parameter. e.g. Start->Run-> "iexplore.exe http://bcheck.scanit.be/bcheck/sid-9478971b4113f76c5568dc573ea08d34/" What if I ran "FORMAT.COM C: /X" ? Hope that's a bit clearer Sorry if I'm a bit grouchy today, I'm still hurting after that damn Swiss referee last nightgrrr. ;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: inventory management
No SKU bar code. Just a physical part no. - Original Message - From: brobborb <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 09:16:54 -0500 Subject: Re: inventory management To: CF-Talk <[EMAIL PROTECTED]> Do they have an SKU bar code or something on the physical product? On my last project, they would just scan the bar code, and it jumps right to the product info page, and they can do whatever theyw ant to it (update inventory for that particlular item, change description, etc). All of this web based, with some _javascript_ - Original Message - From: Chris Tilley To: CF-Talk Sent: Friday, June 25, 2004 8:03 AM Subject: inventory management I'm using the Cartweaver e-commerce for a customer and would like to have an easier way to receive inventory into the database. Currently, you must go to the item and then it's sku page and add your received quantity. This will be tedious seeing as my customer currently has over 1500 items in the inventory table and may receive 10 different items or 100 items at any given time. Has anyone written any software/tags that could be modified to allow the manager to key in all the parts rec'd and quantities and then the update to the database occurrs? Thanks in advance -- Chris Tilley [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cffile question
Have you tried using a UNC path? Also, is CF running as a user that has rights to access it, by default CF runs under LocalSystem so has full access to its own machine and thats all HTH - Original Message - From: Tony Weeg <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 10:43:32 -0400 Subject: cffile question To: CF-Talk <[EMAIL PROTECTED]> hi there. ok, I have a mapped network drive, that from my cfmx server, I can write files to, etc...however when I try to use coldfusion and cffile, to create the file on the mapped network drive, it gives me an error, access denied. Detail The cause of this exception was: java.io.FileNotFoundException: f:\vehiclesIncsvFormat.csv (Access is denied). Message An error occurred when performing a file operation WRITE on file f:\vehiclesIncsvFormat.csv. RootCause struct Message f:\vehiclesIncsvFormat.csv (Access is denied) any ideas? permissions are set to EVERYONE, full control. (for now, until I get this working and can pare down permissions.) ideas anyone? thanks ...tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfftp question
I hope I am just being stupid, but... Is there a way to tell cfftp to get a file and keep the date and time from = the ftp server, rather than the date and time it was got? If not, is thee an alternative tag or method of retrieval that will keep = the date and time? Thanks, Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfftp question
I don't think you can do that. However, you should be able to download the file, check the server for the datetime, and then use some system call or another to reset the date to the one you want via CFEXECUTE. Cheers, barneyb > -Original Message- > From: Jerry Johnson [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 8:07 AM > To: CF-Talk > Subject: cfftp question > > I hope I am just being stupid, but... > > Is there a way to tell cfftp to get a file and keep the date > and time from = > the ftp server, rather than the date and time it was got? > > If not, is thee an alternative tag or method of retrieval > that will keep = > the date and time? > > Thanks, > Jerry Johnson > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP and certificates
Ion, I'm not sure that this is possible. The client certificate relies on the browser to pass it back to the server and I don't think that kind of functionality has been built into CFHTTP. In researching this, I've come across references on how to do it in Java, so that may be the way you need to go. http://java.sun.com/j2se/1.4.2/docs/guide/plugin/developer_guide/protocol_support.html http://java.sun.com/products/jsse/ Hope this helps and let me know if you're successful as I have a couple of sites that are secured this way also. Marlon On Fri, 25 Jun 2004 02:37:16 +0300, Ion Rosca <[EMAIL PROTECTED]> wrote: > > Hi 2 all! > I have a problem... I need to make a CFHTTP call to one server > through HTTPS... this server uses client certificates for > authorization... I recieve from them (server's owners) 2 > certificates... > 1. servercert.cer which I register without any problems using keytool > 2. clientcert.p12 with password clientcert_passwd which I have no idea how to register it... > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: So weird - cannot use variable for query in CFQUERY
You were correct. Could you please explain to me how/why this happens? -Dustin _ From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 8:00 AM To: CF-Talk Subject: Re: So weird - cannot use variable for query in CFQUERY I think you've having a problem with single quotes being escapedtry: #preserveSingleQuotes(myquery)# -joe - Original Message - From: Dustin Snell [Unisyn Software, LLC] <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 07:53:16 -0700 Subject: So weird - cannot use variable for query in CFQUERY To: CF-Talk <[EMAIL PROTECTED]> Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server Regardless of the query used the following code gives me an "Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax " error: #myquery# datasource="#datasource#">#myquery# However it works if I don't use a variable and instead literally put the same query inside the query block: select Count(*) as thecount from cdomains where thedomain='#ListGetAt(getcustomer.email,2,"@")#'; I have been working on this for hours and can't figure it out. I know I have stored my queries in variables before but it won't work in this case. Anyone ever seen this? -Dustin Snell Unisyn Software, LLC _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cffile question
can you use unc path in cffile? I didn't know that...ill have to try... thanks. tw -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:04 AM To: CF-Talk Subject: Re: cffile question Have you tried using a UNC path? Also, is CF running as a user that has rights to access it, by default CF runs under LocalSystem so has full access to its own machine and thats all HTH - Original Message - From: Tony Weeg <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 10:43:32 -0400 Subject: cffile question To: CF-Talk <[EMAIL PROTECTED]> hi there. ok, I have a mapped network drive, that from my cfmx server, I can write files to, etc...however when I try to use coldfusion and cffile, to create the file on the mapped network drive, it gives me an error, access denied. Detail The cause of this exception was: java.io.FileNotFoundException: f:\vehiclesIncsvFormat.csv (Access is denied). Message An error occurred when performing a file operation WRITE on file f:\vehiclesIncsvFormat.csv. RootCause struct Message f:\vehiclesIncsvFormat.csv (Access is denied) any ideas? permissions are set to EVERYONE, full control. (for now, until I get this working and can pare down permissions.) ideas anyone? thanks ...tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: So weird - cannot use variable for query in CFQUERY
As far as I know, it's cf being nice and trying to help your strings get into SQL statements more easily. Like so: UPDATE table SET column = '#text#' ...CF would automatically escape the single quotes in #text# so that you don't need to do so. -joe - Original Message - From: Dustin Snell [Unisyn Software, LLC] <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 08:21:29 -0700 Subject: RE: So weird - cannot use variable for query in CFQUERY To: CF-Talk <[EMAIL PROTECTED]> You were correct. Could you please explain to me how/why this happens? -Dustin _ From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 8:00 AM To: CF-Talk Subject: Re: So weird - cannot use variable for query in CFQUERY I think you've having a problem with single quotes being escapedtry: #preserveSingleQuotes(myquery)# -joe - Original Message - From: Dustin Snell [Unisyn Software, LLC] <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 07:53:16 -0700 Subject: So weird - cannot use variable for query in CFQUERY To: CF-Talk <[EMAIL PROTECTED]> Using CF MX 6.1 with MSSQL 2000 on Windows 2003 Server Regardless of the query used the following code gives me an "Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax " error: #myquery# datasource="#datasource#">#myquery# However it works if I don't use a variable and instead literally put the same query inside the query block: select Count(*) as thecount from cdomains where thedomain='#ListGetAt(getcustomer.email,2,"@")#'; I have been working on this for hours and can't figure it out. I know I have stored my queries in variables before but it won't work in this case. Anyone ever seen this? -Dustin Snell Unisyn Software, LLC _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cffile question
ok I used the unc path, and still the same thing. what are the implications if I change the cfmx server to be a different account, other than localSystem? what could happen if I make the change? can I do it on the fly and it wont alter anything else? lets say if I use an administrator account... thanks. tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:20 AM To: CF-Talk Subject: RE: cffile question can you use unc path in cffile? I didn't know that...ill have to try... thanks. tw -Original Message- From: JediHomer [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:04 AM To: CF-Talk Subject: Re: cffile question Have you tried using a UNC path? Also, is CF running as a user that has rights to access it, by default CF runs under LocalSystem so has full access to its own machine and thats all HTH - Original Message - From: Tony Weeg <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 10:43:32 -0400 Subject: cffile question To: CF-Talk <[EMAIL PROTECTED]> hi there. ok, I have a mapped network drive, that from my cfmx server, I can write files to, etc...however when I try to use coldfusion and cffile, to create the file on the mapped network drive, it gives me an error, access denied. Detail The cause of this exception was: java.io.FileNotFoundException: f:\vehiclesIncsvFormat.csv (Access is denied). Message An error occurred when performing a file operation WRITE on file f:\vehiclesIncsvFormat.csv. RootCause struct Message f:\vehiclesIncsvFormat.csv (Access is denied) any ideas? permissions are set to EVERYONE, full control. (for now, until I get this working and can pare down permissions.) ideas anyone? thanks ...tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ANNOUNCE: ColdFusion MX Master Class, July 19th
>French restaurant? Let's not support the cheese-eating surrender-monkeys as >part of the class. :-) > In case you have not noticed, this is a technical list, could you take your contemptible racist screed elsewhere. Larry C. Lyons [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfmx service question
what are the implications of changing how the service logs in? if I wanted to change it from local system to lets say, a network admin acct? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 visit www.antiwrap.com to send long url emails to your friends! -- dont mistake my perfection as arrogance anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cffile question
> ok I used the unc path, and still the same thing. The SYSTEM account has no rights or access to other servers, via UNC paths or drive mappings. > what are the implications if I change the cfmx server to be a > different account, other than localSystem? what could happen > if I make the change? > > can I do it on the fly and it wont alter anything else? lets > say if I use an administrator account... If you use an administrator account, it should be very easy for you to do this. Of course, you'd still need to make sure that this administrative account has rights to the remote shares to be able to access them from CF. If you use a non-administrative account, as I'd strongly recommend, you will need to ensure that this account has the right to run as a service, and that it has modify rights to the directory containing the CFMX server binaries and read-execute rights to the directory containing your CF code. There's no reason you need to run CF as an administrative account. In fact, you can get very restrictive about the CF account's rights and permissions. The CF account simply needs read rights to your CF files, not execute rights, and it doesn't need modify rights to the entire CFusionMX\JRun directory. It's just easier to set up that way, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
> what are the implications of changing how the service logs in? > > if I wanted to change it from local system to lets say, a > network admin acct? For the love of all that's holy, don't run CFMX as a domain admin! If you do, all your CF code will run with the privileges necessary to do anything at all on your entire domain! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
network admin? ugh, what's the IP? ;) Better to use an account with much less access to your system, eh? IIRC, I have mine set to a normal user with a couple restricitons. As an added bonus, RDS finally can't change system files. Dave Watts, u out there? He's the d00d with a more precise answer on this. Doug -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:32 AM To: CF-Talk Subject: cfmx service question what are the implications of changing how the service logs in? if I wanted to change it from local system to lets say, a network admin acct? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 visit www.antiwrap.com to send long url emails to your friends! -- dont mistake my perfection as arrogance anonymous _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cffile question
so I can do it as administrator, and change it in the services panel, and restart, and things should be good? tw -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:46 AM To: CF-Talk Subject: RE: cffile question > ok I used the unc path, and still the same thing. The SYSTEM account has no rights or access to other servers, via UNC paths or drive mappings. > what are the implications if I change the cfmx server to be a > different account, other than localSystem? what could happen > if I make the change? > > can I do it on the fly and it wont alter anything else? lets > say if I use an administrator account... If you use an administrator account, it should be very easy for you to do this. Of course, you'd still need to make sure that this administrative account has rights to the remote shares to be able to access them from CF. If you use a non-administrative account, as I'd strongly recommend, you will need to ensure that this account has the right to run as a service, and that it has modify rights to the directory containing the CFMX server binaries and read-execute rights to the directory containing your CF code. There's no reason you need to run CF as an administrative account. In fact, you can get very restrictive about the CF account's rights and permissions. The CF account simply needs read rights to your CF files, not execute rights, and it doesn't need modify rights to the entire CFusionMX\JRun directory. It's just easier to set up that way, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
the d00d speaks! So let it be written, so let it be done. LOL! Doug -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:47 AM To: CF-Talk Subject: RE: cfmx service question > what are the implications of changing how the service logs in? > > if I wanted to change it from local system to lets say, a > network admin acct? For the love of all that's holy, don't run CFMX as a domain admin! If you do, all your CF code will run with the privileges necessary to do anything at all on your entire domain! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
true...local box admin acct? not domain admin :) tw -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:47 AM To: CF-Talk Subject: RE: cfmx service question > what are the implications of changing how the service logs in? > > if I wanted to change it from local system to lets say, a > network admin acct? For the love of all that's holy, don't run CFMX as a domain admin! If you do, all your CF code will run with the privileges necessary to do anything at all on your entire domain! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Catching this Error
In your do to see what is in there > -Original Message- > From: [EMAIL PROTECTED] > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: vrijdag 25 juni 2004 15:52 > To: CF-Talk > Subject: Catching this Error > > Hi, > > I'm trying to catch the error below, but I'm not sure what > scope it is in, or how to display it in an error template. > When I wrap the cfstoredproc in a cftry tag, I can catch the > error generically, but I cannot display this specific error > message because I do not know what variable is holding it. > It's not in the Error scope, for example. What can I put in > the Cfdump var = "[Insert Var Here]" to get the message below, if any? > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of > PRIMARY KEY constraint 'PK_Timer'. Cannot insert duplicate > key in object 'Timer'. > > I'm also trying to trap this error message in the stored proc > itself, but that's for another group. > > TIA. > > Sincerely, > Andrew > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx service question
That would give the CF server rights to do anything a network/domain admin can do. Don't do it. -joe - Original Message - From: Tony Weeg <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 11:32:23 -0400 Subject: cfmx service question To: CF-Talk <[EMAIL PROTECTED]> what are the implications of changing how the service logs in? if I wanted to change it from local system to lets say, a network admin acct? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 visit www.antiwrap.com to send long url emails to your friends! -- dont mistake my perfection as arrogance anonymous [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Catching this Error
> I'm trying to catch the error below, but I'm not sure what > scope it is in, or how to display it in an error template. > When I wrap the cfstoredproc in a cftry tag, I can catch the > error generically, but I cannot display this specific error > message because I do not know what variable is holding it. > It's not in the Error scope, for example. What can I put in > the Cfdump var = "[Insert Var Here]" to get the message below, > if any? > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Violation of > PRIMARY KEY constraint 'PK_Timer'. Cannot insert duplicate > key in object 'Timer'. > > I'm also trying to trap this error message in the stored proc > itself, but that's for another group. You can just dump the entire CFCATCH scope to see what's there: The variables you'll be interested in are CFCATCH.NativeErrorCode, CFCATCH.SQLState and CFCATCH.QueryError, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cffile question
I think there's two posts going along this same line now. I would not grant CF administrator access - generally, I run it as a specific user and grant that user rights only to what it needs. -joe - Original Message - From: Tony Weeg <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 11:37:04 -0400 Subject: RE: cffile question To: CF-Talk <[EMAIL PROTECTED]> so I can do it as administrator, and change it in the services panel, and restart, and things should be good? tw -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:46 AM To: CF-Talk Subject: RE: cffile question > ok I used the unc path, and still the same thing. The SYSTEM account has no rights or access to other servers, via UNC paths or drive mappings. > what are the implications if I change the cfmx server to be a > different account, other than localSystem? what could happen > if I make the change? > > can I do it on the fly and it wont alter anything else? lets > say if I use an administrator account... If you use an administrator account, it should be very easy for you to do this. Of course, you'd still need to make sure that this administrative account has rights to the remote shares to be able to access them from CF. If you use a non-administrative account, as I'd strongly recommend, you will need to ensure that this account has the right to run as a service, and that it has modify rights to the directory containing the CFMX server binaries and read-execute rights to the directory containing your CF code. There's no reason you need to run CF as an administrative account. In fact, you can get very restrictive about the CF account's rights and permissions. The CF account simply needs read rights to your CF files, not execute rights, and it doesn't need modify rights to the entire CFusionMX\JRun directory. It's just easier to set up that way, of course. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: from APRIL 2004 till current month
Thanks everyone,
I need to pass the value, like the dateformat so, I can directly use in in the query.
I am submitting this form with the date value (month and year only) and then using it in the query.
There is no logic in comming in my mind that how to do that. I need both month and year.
Regards,
> everything u need is here
> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi58.
> htm#wp1103187
>
> ^_^
>
> Seriously, if I understand your question correctly, take a look at
> dateDiff() to determine the number of months from April 2004 to Now(),
> note Now() is a function. Now loop from 1 to this number. On each
> iteration use DateAdd() to add 1 month to the atarting month of April
> 2004, look at CreateDate() to set this. Bamm!!!
>
> something like...in psuedo code
> myStart = CreateDate('2004','4','1')
> numMonths = DateDiff('m',myStart,Now())
> loop over i from 0 to numMonths
> myDate = DateAdd('m',myStart)
> #myDate#
> end loop
>
> Doug
>
> -Original Message-
> From: Asim Manzur [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 24, 2004 3:18 PM
> To: CF-Talk
> Subject: from APRIL 2004 till current month
>
>
>
> All Months
>
>
> How can I generate the dynamic months till this month from April in
> select box
>
> Regards,
> Asim Manzur
> _
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
OT: Measure Application Bandwidth
Hi all, I am in search of a tool that will allow me to measure how much bandwidth an application uses per user(average). We have tried NAPA on a few different machines and could never get it to run. Does anyone know of a reliable tool for this? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
duplicate inserts
So this is a complete mystery to me but I've seen now on a few occasions (mostly on MX(6.1) I think but it may have happend with 5.0 too) But every so often when I'm inserting a record into a database two records get inserted. I check my cf code with debugging and note that it's not actualy happening on the cf side (or at least the code side itself) is there anything I can do to find out why this is happening. The developers here are using access db but I saw it on ms sql once before too. -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Image Issue
Hi Guys, When I try to upload an image using cffile, How do I check for an existence of an image on the action page. For regular form fields, we use IsDefined(), but what about for input type = file. Thanks a ton, Milan - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
> true...local box admin acct? > > not domain admin :) By default, local Administrator accounts still don't have rights to network resources. You can use a domain account that has those rights, and is a member of the local Administrators group, but again you don't need to use that privileged an account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Image Issue
> -Original Message- > From: Milan Mushran [mailto:[EMAIL PROTECTED] > Sent: vrijdag 25 juni 2004 17:51 > To: CF-Talk > Subject: Image Issue > > Hi Guys, > > When I try to upload an image using cffile, How do I check > for an existence of an image on the action page. For regular > form fields, we use IsDefined(), but what about for input type = file. > > Thanks a ton, > Milan > > > - > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Image Issue
> When I try to upload an image using cffile, How do I check > for an existence of an image on the action page. For regular > form fields, we use IsDefined(), but what about for input > type = file. After the file has been uploaded, you can look at CFFile.ClientFileExt to see the extension of the original file. You can also use the ACCEPT attribute of the CFFILE tag to limit uploads to specific MIME types such as image/gif. Of course, someone could take any file and rename it to something.gif before uploading it, and these measures wouldn't prevent that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Measure Application Bandwidth
On Fri, 25 Jun 2004 10:47:49 -0500, Chris McGrath <[EMAIL PROTECTED]> wrote: > > Hi all, > > I am in search of a tool that will allow me to measure how much > bandwidth an application uses per user(average). The tools that comes to mind to keep track of this sort of stuff are either web stats, or something which actually tracks the bandwidth used on your network and you can do the calculations yourself. Here are a couple of free packages which might get you started down that path (both of which I've used and like) AWStats: http://awstats.sourceforge.net/ MRTG: http://people.ee.ethz.ch/~oetiker/webtools/mrtg/ Not sure if either of those are quite what you're looking for, but it's a start I suppose... - Brandon -- -- http://devnulled.com http://spooled.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Measure Application Bandwidth
Chris McGrath wrote: > > I am in search of a tool that will allow me to measure how much > bandwidth an application uses per user(average). What sort of application? If you mean a HTTP based application just get it from your webserver logfiles. If you mean something else, please elaborate. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
ok, thanks dave, ill talk with my networkHomey, and see what he has to say, and go from there, until them ;) later. tw -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 11:58 AM To: CF-Talk Subject: RE: cfmx service question > true...local box admin acct? > > not domain admin :) By default, local Administrator accounts still don't have rights to network resources. You can use a domain account that has those rights, and is a member of the local Administrators group, but again you don't need to use that privileged an account. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
thank you guys for your help. Alistair, I now see why this is not allowed or not recommended. Given that this is not possible, is it possible to open the file that's sitting on the server. I've changed the cfcontent deletefile attribute to 'no' deletefile="no"> When a user hits on a file name in href, the windows open/save file dialog box propmpts the user to either save or open the file. If the user clicks on the 'open' button, I want windows to open the file that's in the server file upload directory (E:\inetpub\wwwroot\FileUploads\). At the minute if I try to open a file, for example if the file name is 'test.doc', when I hit on the 'open' button, windows creates a file in a temp folder under my profile and opens that file. Is it possible to open the server copy? I hope I am making sense. Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx service question
Tony Weeg wrote: > what are the implications of changing how the service logs in? It gets different permissions :-) > if I wanted to change it from local system to lets say, a network admin > acct? I think others have sufficiently explained why this usually is not a good idea. So maybe it is a good idea to take a step back and share the problem that you want to solve with us, instead of presenting a (dubious) solution. What is the problem that needs solving? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to open an attached file in its own application (ms-word, excel etc).. please read
thank you guys for your help. Alistair, I now see why this is not allowed or not recommended. Given that this is not possible, is it possible to open the file that's sitting on the server. I've changed the cfcontent deletefile attribute to 'no' deletefile="no"> When a user hits on a file name in href, the windows open/save file dialog box propmpts the user to either save or open the file. If the user clicks on the 'open' button, I want windows to open the file that's in the server file upload directory (E:\inetpub\wwwroot\FileUploads\). At the minute if I try to open a file, for example if the file name is 'test.doc', when I hit on the 'open' button, windows creates a file in a temp folder under my profile and opens that file. Is it possible to open the server copy? I hope I am making sense. Best regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Image Issue
I think what he means is there a way to check for the existence of that file FileExists -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:55 AM To: CF-Talk Subject: RE: Image Issue > -Original Message- > From: Milan Mushran [mailto:[EMAIL PROTECTED] > Sent: vrijdag 25 juni 2004 17:51 > To: CF-Talk > Subject: Image Issue > > Hi Guys, > > When I try to upload an image using cffile, How do I check > for an existence of an image on the action page. For regular > form fields, we use IsDefined(), but what about for input type = file. > > Thanks a ton, > Milan > > > - > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Image Issue
you can also look at cffile.contenttype and cffile.contentsubtype for mimetype stuffs. Better than the extension. hmm...how does CF determine this though? anyone? Doug -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:04 PM To: CF-Talk Subject: RE: Image Issue > When I try to upload an image using cffile, How do I check > for an existence of an image on the action page. For regular > form fields, we use IsDefined(), but what about for input > type = file. After the file has been uploaded, you can look at CFFile.ClientFileExt to see the extension of the original file. You can also use the ACCEPT attribute of the CFFILE tag to limit uploads to specific MIME types such as image/gif. Of course, someone could take any file and rename it to something.gif before uploading it, and these measures wouldn't prevent that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
need to write a csv file to a network shared drive. getting access denied due to cfmx service running under local system account :) me -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:06 PM To: CF-Talk Subject: Re: cfmx service question Tony Weeg wrote: > what are the implications of changing how the service logs in? It gets different permissions :-) > if I wanted to change it from local system to lets say, a network admin > acct? I think others have sufficiently explained why this usually is not a good idea. So maybe it is a good idea to take a step back and share the problem that you want to solve with us, instead of presenting a (dubious) solution. What is the problem that needs solving? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Measure Application Bandwidth
It's an http based coldfusion application. Basically what I am looking for is something I can put on a users machine and track how much bandwidth they use while they use the application. > This is a multi-part message in MIME format. > > > Chris McGrath wrote: > > > > I am in search of a tool that will allow me to measure how much > > bandwidth an application uses per user(average). > > What sort of application? If you mean a HTTP based application > just get it from your webserver logfiles. If you mean something > else, please elaborate. > > Jochem > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx service question
Tony Weeg wrote: > need to write a csv file to a network shared drive. > > getting access denied due to cfmx service running under local system account What I would do is: - create a normal user account on the domain - restrict that account to logging in on the webserver and the target server - add that account to a services group on the webserver which has the "start as a service" priviledge set - grant that account the appropriate permissions on the webserver (there is a knowledge base article on the Macromedia website for that, and search the archives of this list because you can restrict permissions a bit further then the article indicates) - grant that account permissions on the target drive - switch CF to run under that account Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
WOT: Getting started with ASP.NET
Does anybody have any recommendations on where to get started in ASP.NET? I worked with ASP traditional years back, but have been entirely CF since. Now I am being drug kicking back into the ASP world and have to immediately understand .NET and be able to write decent code. So anybody have any suggestions on tutorials, resources, mailing lists, etc.? Thanks -- Jeff Chastain - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Measure Application Bandwidth
Chris, Ahh, so you want something on the client side. Check out NetStat Live by AnalogX: http://www.analogx.com/contents/download/network/nsl.htm - Brandon On Fri, 25 Jun 2004 11:23:08 -0500, Chris McGrath <[EMAIL PROTECTED]> wrote: > > It's an http based coldfusion application. Basically what I am looking > for is something I can put on a users machine and track how much > bandwidth they use while they use the application. > > > This is a multi-part message in MIME format. > > > > > > Chris McGrath wrote: > > > > > > I am in search of a tool that will allow me to measure how much > > > bandwidth an application uses per user(average). > > > > What sort of application? If you mean a HTTP based application > > just get it from your webserver logfiles. If you mean something > > else, please elaborate. > > > > Jochem > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT: Getting started with ASP.NET
I would be interested in this too. Looks like I will HAVE to go the M$ route for some projects, as much as I hate it, concurrent with writing CF code for others. YUck! Ray At 12:23 PM 6/25/2004, you wrote: >Does anybody have any recommendations on where to get started in ASP.NET? I >worked with ASP traditional years back, but have been entirely CF >since. Now I >am being drug kicking back into the ASP world and have to immediately >understand >.NET and be able to write decent code. > >So anybody have any suggestions on tutorials, resources, mailing lists, etc.? > >Thanks >-- Jeff Chastain > >- >This mail sent through IMP: http://horde.org/imp/ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
thanks jochem, will do, and actually, have my network admin do it ;) thanks again! tw -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:27 PM To: CF-Talk Subject: Re: cfmx service question Tony Weeg wrote: > need to write a csv file to a network shared drive. > > getting access denied due to cfmx service running under local system account What I would do is: - create a normal user account on the domain - restrict that account to logging in on the webserver and the target server - add that account to a services group on the webserver which has the "start as a service" priviledge set - grant that account the appropriate permissions on the webserver (there is a knowledge base article on the Macromedia website for that, and search the archives of this list because you can restrict permissions a bit further then the article indicates) - grant that account permissions on the target drive - switch CF to run under that account Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT: Getting started with ASP.NET
On Fri, 25 Jun 2004 10:23:39 -0600, Jeff Chastain <[EMAIL PROTECTED]> wrote: > > Does anybody have any recommendations on where to get started in ASP.NET? I > worked with ASP traditional years back, but have been entirely CF since. Now I > am being drug kicking back into the ASP world and have to immediately understand > .NET and be able to write decent code. > > So anybody have any suggestions on tutorials, resources, mailing lists, etc.? > Download the ASP.NET Resource Kit. It's one of the most complete end-to-end packages I've ever seen for any language when it comes to getting started and becoming an advanced developer (yes, even over ColdFusion). It's a huge file, but worth the wait. http://msdn.microsoft.com/asp.net/asprk/ Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Getting started with ASP.NET
Check out the .NET-Talk group on House Of Fusion. This exact topic is being discussed today. Robyn -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:24 PM To: CF-Talk Subject: WOT: Getting started with ASP.NET Does anybody have any recommendations on where to get started in ASP.NET? I worked with ASP traditional years back, but have been entirely CF since. Now I am being drug kicking back into the ASP world and have to immediately understand .NET and be able to write decent code. So anybody have any suggestions on tutorials, resources, mailing lists, etc.? Thanks -- Jeff Chastain - This mail sent through IMP: http://horde.org/imp/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT: Getting started with ASP.NET
Ray Champagne wrote: > I would be interested in this too. Looks like I will HAVE to go the M$ > route for some projects, as much as I hate it, concurrent with writing CF > code for others. YUck! Heh Sure they don't have PHP on that server? I was in the same position - client wanted to keep their host which wasn't using Cold Fusion. I was NOT looking forward into getting back into ASP. Then I found out that PHP was running on the server as well. Not that I'm great with PHP, but it's sure more efficient than ASP - code weight wise and execution wise as well, from what I can tell... -- Les Mizzell -- Certe, toto, sentio nos in kansate non iam adesse -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT: Getting started with ASP.NET
1. Go to asp.net and get the sample code and such. 2. Join the Net-Talk list on HoF. 3. Play with code and ask questions. - Original Message - From: Jeff Chastain <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 10:23:39 -0600 Subject: WOT: Getting started with ASP.NET To: CF-Talk <[EMAIL PROTECTED]> Does anybody have any recommendations on where to get started in ASP.NET? I worked with ASP traditional years back, but have been entirely CF since. Now I am being drug kicking back into the ASP world and have to immediately understand .NET and be able to write decent code. So anybody have any suggestions on tutorials, resources, mailing lists, etc.? Thanks -- Jeff Chastain - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Image Issue
Basically, I do not want to upload a file if the user did not select an image on the form page and was just trying to update some text instead. So, How do I check for the existence of an image before file upload. Thanks a ton, Milan [EMAIL PROTECTED] wrote: I think what he means is there a way to check for the existence of that file FileExists -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:55 AM To: CF-Talk Subject: RE: Image Issue > -Original Message- > From: Milan Mushran [mailto:[EMAIL PROTECTED] > Sent: vrijdag 25 juni 2004 17:51 > To: CF-Talk > Subject: Image Issue > > Hi Guys, > > When I try to upload an image using cffile, How do I check > for an existence of an image on the action page. For regular > form fields, we use IsDefined(), but what about for input type = file. > > Thanks a ton, > Milan > > > - > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! > > _ - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Image Issue
...on action page -joe - Original Message - From: Milan Mushran <[EMAIL PROTECTED]> Date: Fri, 25 Jun 2004 09:53:01 -0700 (PDT) Subject: RE: Image Issue To: CF-Talk <[EMAIL PROTECTED]> Basically, I do not want to upload a file if the user did not select an image on the form page and was just trying to update some text instead. So, How do I check for the existence of an image before file upload. Thanks a ton, Milan [EMAIL PROTECTED] wrote: I think what he means is there a way to check for the existence of that file FileExists -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:55 AM To: CF-Talk Subject: RE: Image Issue > -Original Message- > From: Milan Mushran [mailto:[EMAIL PROTECTED] > Sent: vrijdag 25 juni 2004 17:51 > To: CF-Talk > Subject: Image Issue > > Hi Guys, > > When I try to upload an image using cffile, How do I check > for an existence of an image on the action page. For regular > form fields, we use IsDefined(), but what about for input type = file. > > Thanks a ton, > Milan > > > - > Do you Yahoo!? > Yahoo! Mail - 50x more storage than other providers! > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Image Issue
Checking the fields length would work as described in the tag below. I've always checked to see if the field was empty though. EG: HTH, Jordan Milan Mushran wrote: > Basically, I do not want to upload a file if the user did not select > an image on the form page and was just trying to update some text > instead. So, How do I check for the existence of an image before file > upload. > > > Thanks a ton, > Milan > > [EMAIL PROTECTED] wrote: > I think what he means is there a way to check for the existence of > that file > FileExists > > -Original Message- > From: Pascal Peters [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 10:55 AM > To: CF-Talk > Subject: RE: Image Issue > > > > > -Original Message- > > From: Milan Mushran [mailto:[EMAIL PROTECTED] > > Sent: vrijdag 25 juni 2004 17:51 > > To: CF-Talk > > Subject: Image Issue > > > > Hi Guys, > > > > When I try to upload an image using cffile, How do I check > > for an existence of an image on the action page. For regular > > form fields, we use IsDefined(), but what about for input type = file. > > > > Thanks a ton, > > Milan > > > > > > - > > Do you Yahoo!? > > Yahoo! Mail - 50x more storage than other providers! > > > > > _ > - > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Image Issue
I would check to make sure someone did not just accidently hit the space bar in the FileFIeld. On Fri, 25 Jun 2004 10:06:16 -0700, Jordan Michaels <[EMAIL PROTECTED]> wrote: > > Checking the fields length would work as described in the tag below. > I've always checked to see if the field was empty though. EG: > > > > > > HTH, > Jordan > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
mm bug db
Is the Macromedia bug database publicly accessible? If so, does anyone have any link -- I can't seem to find any.. -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting started with ASP.NET
Beginning ASP.NET with C# from WROX, and Essential C# (if you want to use C#, otherwise VB.NET in place of C#). These helped me out when the decision in my company was made to abandon CF and go to .NET. - Original Message - From: Jeff Chastain To: CF-Talk Sent: Friday, June 25, 2004 11:23 AM Subject: WOT: Getting started with ASP.NET Does anybody have any recommendations on where to get started in ASP.NET? I worked with ASP traditional years back, but have been entirely CF since. Now I am being drug kicking back into the ASP world and have to immediately understand .NET and be able to write decent code. So anybody have any suggestions on tutorials, resources, mailing lists, etc.? Thanks -- Jeff Chastain - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [ANN] BlueDragon 6.1 Released!
Thanks for the explanation, Dick! Rick -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 1:25 AM To: CF-Talk Subject: Re: [ANN] BlueDragon 6.1 Released! I hit the send button too soon! So, you can run a BD/CFML system from CD-ROM. You could also copy the package back to a hard drive & it would run read-write -- No reinstall just a file copy. Technically this is practical, but BD J2ee is expensive and the license does not permit redistribution on CD. But, New Atlanta has expressed to myself, others and the list, in general; their willingness to work with anybody who has a need for an unique packaging/distribution solution, and "make it happen". -- can't ask for more than that! Dick On Jun 24, 2004, at 10:16 PM, Dick Applebaum wrote: > Some people have wanted to make samples of their web sites to > distribute on CD. There are a lot of other reasons, too -- they have > been covered in prior threads about CFAnywhere, so I won't recount > them > here. The are explained at: > > http://67.124.145.42/CFAnywhereDocs/CFanywhere.html > > I was able to put together a package of BD J2ee, Jetty, and McKoi db > and burn it to CD-Rom. > > Then, you can run the whole thing, anywhere, from CD -- no reinstall > or > copying -- the whole thing jest executes from CD. > > I did it with BD, but you should be able to do it with CFMX (with a > little effort). > > The nice feature of BD that makes this easy is: > > BD traps any built-in disk writes (logging, etc.), and, instead of > terminating, just "Backs Of" and doesn't try to write anymore -- so > you > don't need to reconfigure BD at all -- it just runs read-only, if it > needs to. > > HTH > > Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: WOT: Getting started with ASP.NET
I'd suggest starting with Microsoft's ASP.NET Quickstart tutorials: http://www.asp.net/tutorials/quickstart.aspx Of course, you'll want to watch for upcoming BlueDragon.NET release, which will allow you to natively deploy CFML pages as integrated parts of ASP.NET applications (sharing application, session, and request scope variables, for example, as well as doing includes/forwards between CFML and ASPX pages). Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:31 PM To: CF-Talk Subject: Re: WOT: Getting started with ASP.NET I would be interested in this too. Looks like I will HAVE to go the M$ route for some projects, as much as I hate it, concurrent with writing CF code for others. YUck! Ray At 12:23 PM 6/25/2004, you wrote: >Does anybody have any recommendations on where to get started in ASP.NET? I >worked with ASP traditional years back, but have been entirely CF >since. Now I >am being drug kicking back into the ASP world and have to immediately >understand >.NET and be able to write decent code. > >So anybody have any suggestions on tutorials, resources, mailing lists, etc.? > >Thanks >-- Jeff Chastain > >- >This mail sent through IMP: http://horde.org/imp/ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Image Issue
I had tried this before posting the question and for some reason it did not work..Now it is. Thank u very much. Jordan Michaels <[EMAIL PROTECTED]> wrote: Checking the fields length would work as described in the tag below. I've always checked to see if the field was empty though. EG: HTH, Jordan Milan Mushran wrote: > Basically, I do not want to upload a file if the user did not select > an image on the form page and was just trying to update some text > instead. So, How do I check for the existence of an image before file > upload. > > > Thanks a ton, > Milan > > [EMAIL PROTECTED] wrote: > I think what he means is there a way to check for the existence of > that file > FileExists > > -Original Message- > From: Pascal Peters [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 10:55 AM > To: CF-Talk > Subject: RE: Image Issue > > > > > -Original Message- > > From: Milan Mushran [mailto:[EMAIL PROTECTED] > > Sent: vrijdag 25 juni 2004 17:51 > > To: CF-Talk > > Subject: Image Issue > > > > Hi Guys, > > > > When I try to upload an image using cffile, How do I check > > for an existence of an image on the action page. For regular > > form fields, we use IsDefined(), but what about for input type = file. > > > > Thanks a ton, > > Milan > > > > > > - > > Do you Yahoo!? > > Yahoo! Mail - 50x more storage than other providers! > > > > > _ > - > - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [ANN] BlueDragon 6.1 Released!
Thanks for the info! Rick -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:52 AM To: CF-Talk Subject: RE: [ANN] BlueDragon 6.1 Released! Hi Rick, I'll let Dick answer about "run read-only". Yes, there's a free standalone server edition of BlueDragon that's free of charge. There's also a standalone Server JX edition that adds JDBC drivers (the free edition only support ODBC), precompiled templates, and Java Servlet and JavaServer Pages (JSP). BlueDragon Server JX license are priced at $895 per server. Then there's BlueDragon for J2EE Servers (BlueDragon/J2EE) that allows you to deploy CFML applications onto any standard J2EE server in a standard WAR or EAR file (if you don't know what this mean, it's probably not important to you; if you do know what it means, then it could be very important). BlueDragon/J2EE is priced at $2499/CPU. Finally, soon to be added to the lineup is BlueDragon.NET, which will allow you to deploy and integrate CFML applications on ASP.NET servers. Pricing for BlueDragon.NET hasn't been announced (I don't think), but will likely be in line with BlueDragon/J2EE. More details are here: http://www.newatlanta.com/products/bluedragon/product_info/configurations.cf m Of course, there's a suite of technical support options available for whichever BlueDragon edition you choose: http://www.newatlanta.com/biz/support/index.jsp Regards, Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:48 AM To: CF-Talk Subject: RE: [ANN] BlueDragon 6.1 Released! What does "run read-only" mean Dick? I must have been totally misunderstanding Blue Dragon. I thought it was free of charge, unless purchasing support, like MySQL...was I totally misinformed? Rick -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:11 AM To: CF-Talk Subject: Re: [ANN] BlueDragon 6.1 Released! Finally! A CFML engine that supports Mac OS X! Maybe BD will find a home on some of the 1,100 or 1,500 Mac G5 boxes sold to Virginia Poly or for the Army respectively. BTW, BD, without change, will run read-only (as in from a CD/DVD) Congratulations! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Coding Standards Implementation
Hello fam! I am drafting up a coding and design standards document for the hospital. Once it is complete, what do you suggest in terms if implementation? 1) Impose the standards only on newly created apps 2) Go back and implement the standards on apps that were built in the past (pre-standards) As far as the feasibility of #2, it's slim to none considering I am the only coder (though we will be hiring an additional one next month). Also, when standards are updated and/or changed, do you go back and update the previous work, or just apply it to new stuff? Just wanted to get your thoughts on how you have implemented your standards, etc. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org "There is no right price for the wrong product, even if it is inexpensive and delivered on time." [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Getting started with ASP.NET
Thanks for the pointers. I will check out the different resources mentioned. I did subscribe to the .NET-Talk list, but I don't see any discussions going on today. Thanks -- Jeff Quoting Robyn Follen <[EMAIL PROTECTED]>: > Check out the .NET-Talk group on House Of Fusion. This exact topic is being > discussed today. > > Robyn > > -Original Message- > From: Jeff Chastain [mailto:[EMAIL PROTECTED] > Sent: Friday, June 25, 2004 12:24 PM > To: CF-Talk > Subject: WOT: Getting started with ASP.NET > > > Does anybody have any recommendations on where to get started in ASP.NET? I > worked with ASP traditional years back, but have been entirely CF since. > Now I > am being drug kicking back into the ASP world and have to immediately > understand > .NET and be able to write decent code. > > So anybody have any suggestions on tutorials, resources, mailing lists, > etc.? > > Thanks > -- Jeff Chastain > > - > This mail sent through IMP: http://horde.org/imp/ > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: mm bug db
On Fri, 25 Jun 2004 19:14:25 +0200, Hugo Ahlenius <[EMAIL PROTECTED]> wrote: > > Is the Macromedia bug database publicly accessible? If so, does anyone > have any link -- I can't seem to find any.. > No. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: inventory management
I've thought about doing something a bar-code scanner and a web app. Does it work well? What kind of hardware would I need to pick up and what would be the costs? Can you control where the scanner puts the info it reads or does the user have to position the cursor to the right text box, etc in order for that to work? Just curious. John Burns -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 10:17 AM To: CF-Talk Subject: Re: inventory management Do they have an SKU bar code or something on the physical product? On my last project, they would just scan the bar code, and it jumps right to the product info page, and they can do whatever theyw ant to it (update inventory for that particlular item, change description, etc). All of this web based, with some _javascript_ - Original Message - From: Chris Tilley To: CF-Talk Sent: Friday, June 25, 2004 8:03 AM Subject: inventory management I'm using the Cartweaver e-commerce for a customer and would like to have an easier way to receive inventory into the database. Currently, you must go to the item and then it's sku page and add your received quantity. This will be tedious seeing as my customer currently has over 1500 items in the inventory table and may receive 10 different items or 100 items at any given time. Has anyone written any software/tags that could be modified to allow the manager to key in all the parts rec'd and quantities and then the update to the database occurrs? Thanks in advance -- Chris Tilley [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfmx service question
Tony, The only 2 things you need for CF to do this is: 1. CF to be running as an account that has access to the network share. Local accounts don't have this, so you'd need a domain account or something. 2. The account that CF is running as needs the access that Dave Watts described in his post. I wouldn't go with any more or less than what is described above. Sure it's easier to just make the user a local admin, but that opens your server up completely to CF so that if CF is compromised, the whole server is compromised. John Burns -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:15 PM To: CF-Talk Subject: RE: cfmx service question need to write a csv file to a network shared drive. getting access denied due to cfmx service running under local system account :) me -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 12:06 PM To: CF-Talk Subject: Re: cfmx service question Tony Weeg wrote: > what are the implications of changing how the service logs in? It gets different permissions :-) > if I wanted to change it from local system to lets say, a network > admin acct? I think others have sufficiently explained why this usually is not a good idea. So maybe it is a good idea to take a step back and share the problem that you want to solve with us, instead of presenting a (dubious) solution. What is the problem that needs solving? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Image Issue
You can also do a check to make sure that the file is of the correct type (image) here. (right(form.filefield,3) eq "jpg" or right(form.filefield,3) eq "gif")) You can do checks for other extensions as well, but that's just an idea. John -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, June 25, 2004 1:12 PM To: CF-Talk Subject: Re: Image Issue I would check to make sure someone did not just accidently hit the space bar in the FileFIeld. On Fri, 25 Jun 2004 10:06:16 -0700, Jordan Michaels <[EMAIL PROTECTED]> wrote: > > Checking the fields length would work as described in the tag below. > I've always checked to see if the field was empty though. EG: > > > > > > HTH, > Jordan > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cftransaction inside or outside cfloops?
Wouldn't the answer to this be akin to the standard advice of putting cfoutputs *outside* of a cfloop? In the given example, there is nothing meaningful going on in the loop other than stuff that needs a cftransaction applied to it. Wouldn't applying and reapplying such a block repeatedly be unnecessary overhead when you could forego this and apply/and disengage it only once? Is the benefit to minimizing the ... well, the 'span' of the application of the cftransaction -- in a situation where very little else is going on -- *that* significant? -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RTF File Question
I have RTF data in a database that I want to display in a text box. The only solution I have seen is to purchase a very expensive RTF WYSIWYG editor. Does anyone have any ideas? -Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coding Standards Implementation
I use 2), but *try* to keep in mind the old adage "if it ain't broke don't fix it". When you mess with production code it becomes dev server code again; mostly due to stoopid typos made inadvertently during the re-dev process. Very often I create more trouble for myself and wish I had left the code alone... but despite that I think the benefits of evolution overcome the growing pains. When I do re-do code, I try to keep it as part of a general overhaul. Say, a new release to add Feature X; While I'm at it I'll also run thru the code and do whatever else I think it needs. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
