Re: Note passing system?

2001-04-17 Thread Rey Bango

:o)

Hi Peter. I certainly understand where you're coming from. After 3 years of
doing some solid CF work, I'm very capable of building most of the stuff
that I need. I'm just an advocate of code reuse. If there's something out
there that helps me reduce my coding time, I'd like to take advantage of it.
I really hate reinventing the wheel.

Thanks for the feedback...

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Peter Tilbrook" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 1:59 AM
Subject: RE: Note passing system?


 As a side note - if you have an idea for your application - do it! Do not
 expect someone else to have already written the code for you. CF makes
 coding easy. If you are worried about the code have trusted people try and
 break it. Spend at least 3 weeks with beta testers on trusted code. You
 would be amazed at how the feedback either picks up problems or points
out,
 even unobtrusively, better ways to accomplish a task.

 -Original Message-
 From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 17 April 2001 15:33
 To: CF-Talk
 Subject: RE: Note passing system?


 I implemented the same thing for the new Friends Plus site. The beauty of
 the system is that nobpdys email address is released.

 We could be draconian and introduce full auditing but it has not been
 necessary yet. The user remain anonymous and their email address is never
 released unless they give it out.

 -Original Message-
 From: Rey Bango [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 17 April 2001 14:57
 To: CF-Talk
 Subject: Re: Note passing system?


 Not really, Paul. Its more like an internal messaging system. One where I
 can write a message to another user or perhaps a group of users and have
 them correspnd back. Again, its not a true email system but one that would
 allow me to be able to communicate within the scope of my own application.

 Rey...
 Certified Allaire Instructor
 Member of Team Allaire

 "A browser's beauty, at its heart, is its usefulness as a *TOOL*."



 - Original Message -
 From: "Paul Begovich" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, April 16, 2001 7:35 PM
 Subject: Re: Note passing system?


  Sounds like you want a project management tool.
 
  We have an internal system here we use to parse out work.  Basically the
  client/project manager submits an item to a form and it appears on the
  necessary persons desktop based on who they select.  They see the item,
do
  the work, mark their time, and reply via the form.  It's a great project
  management tool and it keeps track of correspondence.
 
  Building a system like your describing isn't too difficult, it's just
time
  consuming.  We have looked into outside utilities to do this, but we've
  found them lacking.  As a development shop we have found that when we
need
  some additional functionality we build it on.  The current system we
have
  now has grown out of several developers efforts in the past two years to
  incompass project managment, billing, contacts, work requests, logging,
 and
  a host of other things.
 
  A third party too may save you time in the short run, but in the long
run,
  it'll probably lacks the additional functionality you want.  I recommend
  buiding your own system, keeping in mind you want to be able to add
  additionally functionality in the future.
 
  - Paul
 
 
  - Original Message -
  From: "Rey Bango" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Monday, April 16, 2001 1:07 PM
  Subject: Note passing system?
 
 
   Anyone know of a good CF-based note/messaging system? I'm not talking
  about
   an email server but more of a db driven messaging software that will
 allow
   me to post a message to a specific suer. When that user comes in, they
 can
   check for their own messages and reply accordingly. Again, its not an
  email
   system per se.
  
   Thanks,
  
   Rey Bango...
   Certified Allaire Instructor
   Member of Team Allaire
  
   "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
  
  
  
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Note passing system?

2001-04-17 Thread Javier Woodhouse

I'd like to add to that... I also have no problem comming up with the code i
need, but code that is available publicaly is likely to have undergone
serveral bug fixes, performance enhancements and it might even be better
then what i could come up with. Code reuse has it's benefits 

Regards,
Javier

 -Original Message-
 From: Rey Bango [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 4:37 PM
 To: CF-Talk
 Subject: Re: Note passing system?
 
 
 :o)
 
 Hi Peter. I certainly understand where you're coming from. 
 After 3 years of
 doing some solid CF work, I'm very capable of building most 
 of the stuff
 that I need. I'm just an advocate of code reuse. If there's 
 something out
 there that helps me reduce my coding time, I'd like to take 
 advantage of it.
 I really hate reinventing the wheel.
 
 Thanks for the feedback...
 
 Rey...
 Certified Allaire Instructor
 Member of Team Allaire
 
 "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
 
 
 - Original Message -
 From: "Peter Tilbrook" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 1:59 AM
 Subject: RE: Note passing system?
 
 
  As a side note - if you have an idea for your application - 
 do it! Do not
  expect someone else to have already written the code for 
 you. CF makes
  coding easy. If you are worried about the code have trusted 
 people try and
  break it. Spend at least 3 weeks with beta testers on 
 trusted code. You
  would be amazed at how the feedback either picks up 
 problems or points
 out,
  even unobtrusively, better ways to accomplish a task.
 
  -Original Message-
  From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 17 April 2001 15:33
  To: CF-Talk
  Subject: RE: Note passing system?
 
 
  I implemented the same thing for the new Friends Plus site. 
 The beauty of
  the system is that nobpdys email address is released.
 
  We could be draconian and introduce full auditing but it 
 has not been
  necessary yet. The user remain anonymous and their email 
 address is never
  released unless they give it out.
 
  -Original Message-
  From: Rey Bango [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 17 April 2001 14:57
  To: CF-Talk
  Subject: Re: Note passing system?
 
 
  Not really, Paul. Its more like an internal messaging 
 system. One where I
  can write a message to another user or perhaps a group of 
 users and have
  them correspnd back. Again, its not a true email system but 
 one that would
  allow me to be able to communicate within the scope of my 
 own application.
 
  Rey...
  Certified Allaire Instructor
  Member of Team Allaire
 
  "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
 
 
 
  - Original Message -
  From: "Paul Begovich" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Monday, April 16, 2001 7:35 PM
  Subject: Re: Note passing system?
 
 
   Sounds like you want a project management tool.
  
   We have an internal system here we use to parse out work. 
  Basically the
   client/project manager submits an item to a form and it 
 appears on the
   necessary persons desktop based on who they select.  They 
 see the item,
 do
   the work, mark their time, and reply via the form.  It's 
 a great project
   management tool and it keeps track of correspondence.
  
   Building a system like your describing isn't too 
 difficult, it's just
 time
   consuming.  We have looked into outside utilities to do 
 this, but we've
   found them lacking.  As a development shop we have found 
 that when we
 need
   some additional functionality we build it on.  The 
 current system we
 have
   now has grown out of several developers efforts in the 
 past two years to
   incompass project managment, billing, contacts, work 
 requests, logging,
  and
   a host of other things.
  
   A third party too may save you time in the short run, but 
 in the long
 run,
   it'll probably lacks the additional functionality you 
 want.  I recommend
   buiding your own system, keeping in mind you want to be 
 able to add
   additionally functionality in the future.
  
   - Paul
  
  
   - Original Message -
   From: "Rey Bango" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Monday, April 16, 2001 1:07 PM
   Subject: Note passing system?
  
  
Anyone know of a good CF-based note/messaging system? 
 I'm not talking
   about
an email server but more of a db driven messaging 
 software that will
  allow
me to post a message to a specific suer. When that user 
 comes in, they
  can
check for their own messages and reply accordingly. 
 Again, its not an
   email
system per se.
   
Thanks,
   
Rey Bango...
Certified Allaire Instructor
Member of Team Allaire
   
"A browser's beauty, at its heart, is its usefulness as 
 a *TOOL*."
   
   
   
   
  
 

~~
Structure your ColdFusion code with Fusebox. Get 

test

2001-04-17 Thread mahmad


Test


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Order of Display/Page Rendering Question

2001-04-17 Thread mahmad


Any one llike to let me know ,what will happen if would like to make one
part of Application in ASP other is in JSP and other is in CF or PHP.
Thanks in Advance.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Import data to ACCESS

2001-04-17 Thread Tony Gruen

James, will the export be the same records every time? Or will the client
change the data selections from export to export?


Tony Gruen
sfnetworks


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:03 PM
To: CF-Talk
Subject: Re: Import data to ACCESS



James Maltby
james.m@thoughtbTo: CF-Talk
[EMAIL PROTECTED]
ubble.net   cc:
 Subject: Import data to
ACCESS
03/30/01 03:45 PM
Please respond to
cf-talk










Here's a dudy for y'all -

SCENARIO: current client's website - running on NT4, CF 4.01, Access 97
backend - have come back to us with the following request:

They have an Orrible 7 database internally from which they want to export
tab delimited (or csv) data (deleted, amended and new records) on a regular
basis (usually about 200 - 500 records each time) - and they want us to
write an application that will "execute" this file on their server.

ISSUES: the server does not have Access on it, just the databases required
-
they will not allow a remote ODBC connection to the Oracle database - the
server is v. old (about 2 years old - 1/2 gig RAM - x86 Pentium II
300/400(?) Proc.)

SOLUTION: we suggest upgrading the backend to MS SQL - using SPs to import
the data - run by CF pages in the admin management system we have written.

PROBLEM: they want us to suggest using the current techs. - i.e. using
ACCESS databases without having access on the server any suggestions...

TIA

James
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: validation

2001-04-17 Thread mahmad


U must need a structure like array in which u will insert the names from
DB.On the client side after entering the name ur name will be compared with
the names oretrieved from DB.
It is ans according to ur Q.


   
  
"Jones, Becky" 
  
bjones@MilesStockbTo: CF-Talk 
[EMAIL PROTECTED]   
ridge.com cc: 
  
   Subject: validation 
  
04/17/01 01:27 AM  
  
Please respond to  
  
cf-talk
  
   
  
   
  




i want to have a form where i can insert a new user into my database.  and
i
have that form but i want to be able to validate it before it submits this
new user into my database.  i want to check to make sure the person doesnt
already exist. (it wont be me entering the data, so i dont want to have
user
input errors if they dont search thru the drop down list before adding a
new
person...resulting in duplicate people).
someone told me to look thru the custom tags and i did...but i really dont
see what i am looking for.
can anyone give me any ideas or some direction?
thanks for all your help,
bec.


*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information.  If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Creating Page Breaks to make page printable?

2001-04-17 Thread Bill Davies

Don't think page break is implemented in Navigator.

-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: 17 April 2001 05:34
To: CF-Talk
Subject: Re: Creating Page Breaks to make page printable?


http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre
akAfter.asp

- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, April 16, 2001 6:20 PM
Subject: Re: Creating Page Breaks to make page printable?



  Does anyone know of a way to force printing breaks of a document?

 You can do this with style sheets.



 --
 This message sent compliments of db Technology
http://www.dbtech.net/




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: (Easy SQL)

2001-04-17 Thread Michael Lugassy

getdate() for now()
getdate(-1) for yesterday and so on

- Original Message -
From: "Eric Dawson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, April 16, 2001 9:08 PM
Subject: (Easy SQL)


 I have a member table which contains
 userid, signup_datetime

 I want to create a daily summary of registrations.
 select signup_datetime as justDatenotTime,count(userID) as NewMembers
 from membertable
 group by justDatenotTime

 == * ==
 I know this has to be simple, but I can't find the syntax. How do I drop
the
 time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just
 the day?

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Michael Lugassy

I had the same problem, it's ain't possible.
What I used is to open a window indicating
only .jpeg or .gif is allowed and then used a javascript
to check what file was inserted in the formfield (before
uploading, not after): take a look:

script
extensions = new Array(".JPG",".GIF",".gif",".jpg")
function allowedExt(fileType){
 var extension = fileType.substring(fileType.length-4, fileType.length)
 for (var i = 0; i  extensions.length; i++) {
   if (extension == extensions[i]) {
return true
break
  }
 }alert(errorMsg()); return false
}

function errorMsg(){
  alertTxt = "Please select one of the following file types: \n\r"
  for (var i = 2; i  extensions.length; i++){
   alertTxt += extensions[i] + " "
{
  }
 }return alertTxt
}


Hope this helps.

Bye.

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Inputfilter

2001-04-17 Thread Michael Lugassy

it's attached.
you can add your own invalid signs/cahrs on one of the lines.

Take care,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Michael Lugassy

Please someone help out.

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, April 16, 2001 5:24 PM
Subject: Transferring 1-3Kb data


 We devloped a client program (in visual c++) that stores
 log files for usage in the client and its features.

 I need the best way to deliver those small log files (no more then 2Kb for
a full week of usage) to our CF production server and then, to zip those
files and send them daily
 to our development server.

 I will definitly manage the 2 tasks of zipping and transferring
 the log files but what is the best way to create/get them
 from the client? I though about 2 alternatives:

 1. open a ftp connection to upload the file weekly by each client.

 2. send the file in http (using WDDX/URL/FORMFIELD)
 and create a copy of the file locally on the server.

 the two solutions are not sclable enough, any help would be appriciated!


 Thanks,

 Michael Lugassy
 Interactive Music Ltd
 http://www.imvamp.com




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: input type='file'

2001-04-17 Thread Chiraporn

so we could not do anything about it :(


but thank you for reply Michael :)
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 4:26 PM
To: CF-Talk
Subject: Re: input type='file'


I had the same problem, it's ain't possible.
What I used is to open a window indicating
only .jpeg or .gif is allowed and then used a javascript
to check what file was inserted in the formfield (before
uploading, not after): take a look:

script
extensions = new Array(".JPG",".GIF",".gif",".jpg")
function allowedExt(fileType){
 var extension = fileType.substring(fileType.length-4, fileType.length)
 for (var i = 0; i  extensions.length; i++) {
   if (extension == extensions[i]) {
return true
break
  }
 }alert(errorMsg()); return false
}

function errorMsg(){
  alertTxt = "Please select one of the following file types: \n\r"
  for (var i = 2; i  extensions.length; i++){
   alertTxt += extensions[i] + " "
{
  }
 }return alertTxt
}


Hope this helps.

Bye.

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Bryan LaPlante

I have a question about your script. Assuming the input looks like so
form name="foo"
input type="file" name="bar"
/form
does your script refer to the input as document.foo.bar.value;
If so how did you work around the access denied js error that the browser
gives me when I try this?

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 4:25 AM
Subject: Re: input type='file'


 I had the same problem, it's ain't possible.
 What I used is to open a window indicating
 only .jpeg or .gif is allowed and then used a javascript
 to check what file was inserted in the formfield (before
 uploading, not after): take a look:

 script
 extensions = new Array(".JPG",".GIF",".gif",".jpg")
 function allowedExt(fileType){
  var extension = fileType.substring(fileType.length-4, fileType.length)
  for (var i = 0; i  extensions.length; i++) {
if (extension == extensions[i]) {
 return true
 break
   }
  }alert(errorMsg()); return false
 }

 function errorMsg(){
   alertTxt = "Please select one of the following file types: \n\r"
   for (var i = 2; i  extensions.length; i++){
alertTxt += extensions[i] + " "
 {
   }
  }return alertTxt
 }


 Hope this helps.

 Bye.

 Michael Lugassy
 Interactive Music Ltd.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Last row inserted

2001-04-17 Thread Michael Lugassy

If u'r using CF (and that's the forum, right?)
AND YOU HAVE a colum where you put the date
of each INSERT just use this:

cfquery name="x" datasource="y" MAXROWS="1"
SELECT colum from table ORDER by columthatholds_date
DESC/cfquery

If u'r not holding the date of the insert, the MAX idea is good.

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfmal with attachments and cfserver memory usage

2001-04-17 Thread Michael Lugassy

I had similiar problems and had to buy a dedicated Mail Server (IMAIL is
recommened, from IPSWITCH).
Anyow, you probarbly know CF is NOT recommended
for high-volume "MAILING LIST" like yours.

If you can't get your hands on a dedicated mail server (that
will help ALOT in performace!!) I suggested this:

1. Don't attach the file(s) using the MIMEATTACH switch
on the parent CFMAIL tag, instead, use CFMAILPARAM(s)
something like this:

CFMAILPARAM FILE="#dir_mapt#\#filename1#"
CFMAILPARAM FILE="#dir_mapt#\#filename2#"
CFMAILPARAM FILE="#dir_mapt#\#filename3#"

2. Don't use the QUERY attribute with the CFMAIL
instead, try to think of using CFLOOP=QUERY (that's
not recommened too, but...) with a single CFMAIL each
time (you don't need examples for that, right?)

3. give a time interval (of about 5 minutes) between
CFLOOP and/or multiple CFMAIL recipintes list.
This will give the server "TIME TO RECOVER".

hope this tips helps,
again - I recommened a dedicated mail software that
will run on the same CF machine to handle this tasks.
I think you can get IMAIL For 900$ 1 time fee and deliver
100K messages a day without a problem on pentium 100mhz

It's MUCH BETTER.

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Using 90-100% of processor time (911!)

2001-04-17 Thread Michael Lugassy

No one asked you what version are you using?
It is recommened that you'll upgrade to SP2 (4.5.1)
it's free from allaire.
We had the same problem with our old 4.5 version.

Anyhow, I don't think it's an immediate change, like the others. Please
remember what happened BEFORE the first time you rebooted the server (prior
to the problem).
This reboot will make all the changes take affect.

BUT CHECK YOUR VERSION INFO (under admin.)
and get back to me.

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Using 90-100% of processor time (911!)

2001-04-17 Thread Xing Li

Not sure if anyone else has mentioned this yet but there is a very rare and
random cfmail bug that cause exactly the cpu usage you have described. Once
in a blue moon CF 4.5.X blurps out an empty/0K email queue in the
C:\CFUSION\MAIL\POOL folder or wherever you installed CF. Look for a 0K file
and remove it if you find it. Once you do that and restart the service
everything should return to normal. It's extremely rare but it does happen.

xing

- Original Message -
From: "Bonnie Betts" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, April 16, 2001 9:27 PM
Subject: Re: CF Using 90-100% of processor time (911!)


 Question on this thread:

 Would any of the log files give you a hint as to which pages were accessed
 when the server started using up resources?

 Bonnie E. Betts
 [EMAIL PROTECTED]
 www.interacttechs.com


 - Original Message -
 From: "Steven A. del Sol" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, April 16, 2001 1:35 PM
 Subject: Re: CF Using 90-100% of processor time (911!)


  I believe your problem is that on one of your pages you are timing out.
  Check to see if you have a page where you are passing a Alpha into a
  numeric field.
 
  It will not necessarily crash if you have a number in the sequence
  somewhere but it can stall your
  cfserver for hours.  Also, set your timeout's lower and set server to
  restart on two timeouts.
 
  This error can happen with datefields too.  Hope you find your problem
it
  took us three weeks
  going through thousands of line of code to fine one date field not
  validating, throwing errors and
  causing  the server to have cfserver at 95% to 100% of the memory usage.
 
 
 
  GOOD LUCK
 
 
 
 
  At 12:48 PM 4/16/2001 -0400, you wrote:
  My server developed a problem today. CFServer.exe is using almost all
of
 the
  available processing time. I've tried stopping and starting the
services
 and
  the NT box, but as soon as I start CF again it almost immediately grabs
 all
  of the processor time.
  
  I'm running NT and CF 4.01. We've had this application up and running
for
 a
  little over a year now and have only started having this problem today.
 I'd
  greatly appreciate any suggestions, since this has my Web site running
at
 a
  crawl.
  
  TIA!
  
  Russell Conway
  HallofSports.com, Inc.
  351 West 22nd Street
  New York, NY 10011
  P (646) 638-2500
  F (646) 638-3444
  http://www.hallofsports.com
  .. . . where the legends live on
  
  
  
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Error Catching Overhead - Performance Data?

2001-04-17 Thread Xing Li

Don't want to do more than I need to so I will try to get the answer here
first.

Has anyone done any performance testing with huge blocks of CF code with and
without nested/non-nested CFTRY/CFCATCH code?

It would be interesting to see if anyone has experienced any significant
difference between the two styles in terms of raw performance.

xing


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Screen Shot on Win 2K

2001-04-17 Thread Michael Lugassy

Actually PrintScreen alone will do also.
ALT+print screen takes off the TASKBAR out of the picture.

Say chees,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Always the same Verity error code...

2001-04-17 Thread Capolinea

Hello Ladies and Gentlemen,

Always the same problem on my web site hosted by Intermedia with a Verity collection

Error occurred in tag CFSEARCH
 Internal Error: VDKSessionNew failed
 Error Code: -125

Tech support always restarts the Cold Fusion services...until the next crash

Any idea to fix this problem?

Thanks a lot for your help
Rémi van der Deure


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Inputfilter

2001-04-17 Thread Michael Lugassy

Guess this forums doesn't support attachs.
here is the code, wide spread:


cfparam name="attributes.scopes"
cfparam name="attributes.chars" default=""
cfparam name="attributes.tags" default=""
cfscript
 reTags = "" ;
 if ( attributes.tags eq "ALL" )
  reTags = "[^]*" ;
 else if ( attributes.tags neq "" )
  reTags = "/?(#ListChangeDelims(attributes.tags,  '|', ',' )#)[^]*" ;
 charList = '' ;
 if ( attributes.chars neq "" ) {
  charList = attributes.chars ;

  for ( i=Len(attributes.chars)-1; i gte 1; i=i-1 )
   charList = Insert( ",", charList, i ) ;
 }
/cfscript
cfloop list="#attributes.scopes#" index="scopeName"
 cfif not findnocase("multipart/form-data",cgi.CONTENT_TYPE)
  cfscript
   s = Evaluate( scopeName ) ;
   for ( field in s )
if ( IsSimpleValue( s[field] ) ) {
 if ( reTags neq '' )
  s[field] = REReplace( s[field], reTags, "", "ALL" ) ;
 if ( charList neq '' )
  s[field] = ReplaceList( s[field], charList, "" ) ;
}
  /cfscript
 /cfif
/cfloop



Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Michael Lugassy

form action="something.cfm" method="post" enctype="multipart/form-data"
name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);"

this is the form heading.


- Original Message -
From: "Bryan LaPlante" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 10:44 AM
Subject: Re: input type='file'


 I have a question about your script. Assuming the input looks like so
 form name="foo"
 input type="file" name="bar"
 /form
 does your script refer to the input as document.foo.bar.value;
 If so how did you work around the access denied js error that the browser
 gives me when I try this?

 - Original Message -
 From: "Michael Lugassy" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 4:25 AM
 Subject: Re: input type='file'


  I had the same problem, it's ain't possible.
  What I used is to open a window indicating
  only .jpeg or .gif is allowed and then used a javascript
  to check what file was inserted in the formfield (before
  uploading, not after): take a look:
 
  script
  extensions = new Array(".JPG",".GIF",".gif",".jpg")
  function allowedExt(fileType){
   var extension = fileType.substring(fileType.length-4, fileType.length)
   for (var i = 0; i  extensions.length; i++) {
 if (extension == extensions[i]) {
  return true
  break
}
   }alert(errorMsg()); return false
  }
 
  function errorMsg(){
alertTxt = "Please select one of the following file types: \n\r"
for (var i = 2; i  extensions.length; i++){
 alertTxt += extensions[i] + " "
  {
}
   }return alertTxt
  }
 
 
  Hope this helps.
 
  Bye.
 
  Michael Lugassy
  Interactive Music Ltd.
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Michael Lugassy

Take the script, open a new html window
and write them in BOLD LETTERS! :)
just like we did here:
http://www.imvamp.com/userpages/upload/index.cfm

Don't :(

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Bryan LaPlante

I've never gotten that to work for me. It always complains about object
required or access denied when I refer to a client side file upload. It is
my understanding that JavaScript can not access the content of the input
type due to security issues.

I will have to try your method.

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 5:26 AM
Subject: Re: input type='file'


 form action="something.cfm" method="post" enctype="multipart/form-data"
 name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);"

 this is the form heading.


 - Original Message -
 From: "Bryan LaPlante" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 10:44 AM
 Subject: Re: input type='file'


  I have a question about your script. Assuming the input looks like so
  form name="foo"
  input type="file" name="bar"
  /form
  does your script refer to the input as document.foo.bar.value;
  If so how did you work around the access denied js error that the
browser
  gives me when I try this?
 
  - Original Message -
  From: "Michael Lugassy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 4:25 AM
  Subject: Re: input type='file'
 
 
   I had the same problem, it's ain't possible.
   What I used is to open a window indicating
   only .jpeg or .gif is allowed and then used a javascript
   to check what file was inserted in the formfield (before
   uploading, not after): take a look:
  
   script
   extensions = new Array(".JPG",".GIF",".gif",".jpg")
   function allowedExt(fileType){
var extension = fileType.substring(fileType.length-4,
fileType.length)
for (var i = 0; i  extensions.length; i++) {
  if (extension == extensions[i]) {
   return true
   break
 }
}alert(errorMsg()); return false
   }
  
   function errorMsg(){
 alertTxt = "Please select one of the following file types: \n\r"
 for (var i = 2; i  extensions.length; i++){
  alertTxt += extensions[i] + " "
   {
 }
}return alertTxt
   }
  
  
   Hope this helps.
  
   Bye.
  
   Michael Lugassy
   Interactive Music Ltd.
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Michael Lugassy

just keep in mind that the form must come AFTER the script.

- Original Message -
From: "Bryan LaPlante" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 11:36 AM
Subject: Re: input type='file'


 I've never gotten that to work for me. It always complains about object
 required or access denied when I refer to a client side file upload. It is
 my understanding that JavaScript can not access the content of the input
 type due to security issues.

 I will have to try your method.

 - Original Message -
 From: "Michael Lugassy" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 5:26 AM
 Subject: Re: input type='file'


  form action="something.cfm" method="post" enctype="multipart/form-data"
  name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);"
 
  this is the form heading.
 
 
  - Original Message -
  From: "Bryan LaPlante" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 10:44 AM
  Subject: Re: input type='file'
 
 
   I have a question about your script. Assuming the input looks like so
   form name="foo"
   input type="file" name="bar"
   /form
   does your script refer to the input as document.foo.bar.value;
   If so how did you work around the access denied js error that the
 browser
   gives me when I try this?
  
   - Original Message -
   From: "Michael Lugassy" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Tuesday, April 17, 2001 4:25 AM
   Subject: Re: input type='file'
  
  
I had the same problem, it's ain't possible.
What I used is to open a window indicating
only .jpeg or .gif is allowed and then used a javascript
to check what file was inserted in the formfield (before
uploading, not after): take a look:
   
script
extensions = new Array(".JPG",".GIF",".gif",".jpg")
function allowedExt(fileType){
 var extension = fileType.substring(fileType.length-4,
 fileType.length)
 for (var i = 0; i  extensions.length; i++) {
   if (extension == extensions[i]) {
return true
break
  }
 }alert(errorMsg()); return false
}
   
function errorMsg(){
  alertTxt = "Please select one of the following file types: \n\r"
  for (var i = 2; i  extensions.length; i++){
   alertTxt += extensions[i] + " "
{
  }
 }return alertTxt
}
   
   
Hope this helps.
   
Bye.
   
Michael Lugassy
Interactive Music Ltd.
   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: input type='file'

2001-04-17 Thread Bryan LaPlante

dude, you are a genius. I have never gotten that to work. My hat is off to
ya.

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 5:53 AM
Subject: Re: input type='file'


 just keep in mind that the form must come AFTER the script.

 - Original Message -
 From: "Bryan LaPlante" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 11:36 AM
 Subject: Re: input type='file'


  I've never gotten that to work for me. It always complains about object
  required or access denied when I refer to a client side file upload. It
is
  my understanding that JavaScript can not access the content of the input
  type due to security issues.
 
  I will have to try your method.
 
  - Original Message -
  From: "Michael Lugassy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 5:26 AM
  Subject: Re: input type='file'
 
 
   form action="something.cfm" method="post"
enctype="multipart/form-data"
   name="uploadForm" OnSubmit="return allowedExt(this.filefield.value);"
  
   this is the form heading.
  
  
   - Original Message -
   From: "Bryan LaPlante" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Tuesday, April 17, 2001 10:44 AM
   Subject: Re: input type='file'
  
  
I have a question about your script. Assuming the input looks like
so
form name="foo"
input type="file" name="bar"
/form
does your script refer to the input as document.foo.bar.value;
If so how did you work around the access denied js error that the
  browser
gives me when I try this?
   
- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 4:25 AM
Subject: Re: input type='file'
   
   
 I had the same problem, it's ain't possible.
 What I used is to open a window indicating
 only .jpeg or .gif is allowed and then used a javascript
 to check what file was inserted in the formfield (before
 uploading, not after): take a look:

 script
 extensions = new Array(".JPG",".GIF",".gif",".jpg")
 function allowedExt(fileType){
  var extension = fileType.substring(fileType.length-4,
  fileType.length)
  for (var i = 0; i  extensions.length; i++) {
if (extension == extensions[i]) {
 return true
 break
   }
  }alert(errorMsg()); return false
 }

 function errorMsg(){
   alertTxt = "Please select one of the following file types: \n\r"
   for (var i = 2; i  extensions.length; i++){
alertTxt += extensions[i] + " "
 {
   }
  }return alertTxt
 }


 Hope this helps.

 Bye.

 Michael Lugassy
 Interactive Music Ltd.

   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Screen Shot on Win 2K

2001-04-17 Thread douglas . kronenberger

Works for me. 

Sounds like maybe you have some video driver software that uses that
combination as a hotkey to change display. If so you should be able to
change or disable it some where under the display driver.

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 11:30 PM
To: CF-Talk
Subject: OT: Screen Shot on Win 2K


Off Topic: How do you do a screen shot with Win 2000?  When I try Shift +
Alt + Print Screen it doesn't work like it used to in Win 98.  Instead it
wants to put the display in High Contrast.

Thanks,
Rich
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Transferring 1-3Kb data

2001-04-17 Thread Angél Stewart

We
I don't understand.
Why do you need Coldfusion for this?
For the client PCs..I think it would be much better to send the files via
that same C++ client using FTP?

And won't it be a lot easier to implement a log file transfer using a small
C++ program running as a service under NT?

Alternately you would have to use CFFTP to send the files from the
production to the development server, and Schedule a task in the CF
Administrator.
There are also tags that will Zip the files for you via CF.

Sorry I couldn't be more help.

-Gel


-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]

Please someone help out.

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]

 We devloped a client program (in visual c++) that stores
 log files for usage in the client and its features.

 I need the best way to deliver those small log files (no more then 2Kb for
a full week of usage) to our CF production server and then, to zip those
files and send them daily
 to our development server.

 I will definitly manage the 2 tasks of zipping and transferring
 the log files but what is the best way to create/get them
 from the client? I though about 2 alternatives:

 1. open a ftp connection to upload the file weekly by each client.

 2. send the file in http (using WDDX/URL/FORMFIELD)
 and create a copy of the file locally on the server.

 the two solutions are not sclable enough, any help would be appriciated!


 Thanks,

 Michael Lugassy
 Interactive Music Ltd
 http://www.imvamp.com




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: cookies not being set

2001-04-17 Thread Mike Sprague

I was away from my computer when all the answers came in.  Thanks to all that helped.  
It seems that a javascript redirect is the best work around for now.  Thanks again.

Mike

*** REPLY SEPARATOR  ***
On 4/16/2001 at 2:33 PM Nick McClure wrote:

|CFLocation works on an http error.
|
|It is 302 Object Moved.
|
|Cookies work on an http header also. You could get happy and create the 
|http headers that will do this. It is all possible and I have done them 
|separately. I do not know if this will actually set the cookie though. I
|am 
|going to try this later today.
|
|I will let you know how it works.
|
|At 01:57 PM 4/16/2001 -0400, you wrote:
|Or write the redirect header manually:
|
|http://www.teamallaire.com/tutorials/index.cfm?fuseaction=displaytopicid=01
|3
|
|Benjamin S. Rogers
|Web Developer, c4.net
|Voice: (508) 240-0051
|Fax: (508) 240-0057
|
|-Original Message-
|From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
|Sent: Monday, April 16, 2001 1:41 PM
|To: CF-Talk
|Subject: RE: cookies not being set
|
|
|You cant use CFCOOKIE AND CFLOCATION on the same page, you may want to
|change your CFLOCATION's to a META redirect.
|
|-Adrian





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: DNS

2001-04-17 Thread Todd Ashworth

You'll probably get a lot better, more useful info from the DNS folks at
[EMAIL PROTECTED]

You can sign up to the list here: http://isp-lists.isp-planet.com/isp-dns/

Todd Ashworth --

- Original Message -
From: "Dylan Bromby" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:02 AM
Subject: OT: DNS


| i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this
| particular migration? any recommendations? has anyone had any trouble with
| DNS on Win2K?
|
| tia.
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Michael Lugassy

Gel.,
Thanks for answering:

1. isn't a single FTP connection for each users (even for 1 minute) is time
consuming and inefficient when there is the
chance 100s of users will open unique FTP connections each time?

2. what do you mean by a C++ program running as service? can you give me an
example?

Bare in mind that our log files create itself on the client machine. the
solution I'mt trying to find is to deliver
this small log file to the server and store it there.

won't getting the file in http (as a formfield) and creating the file myself
(CFFILE) is better then a complete FTP session?

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CSS

2001-04-17 Thread Neil H.

I want to make "flat" select boxes, radio buttons, and checkboxes.  What I
mean is no shadow and a 1px border of a color.

Anyone have any ideas?  The browser for this app is always IE 5.x

Thanks,

Neil



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Delimiters

2001-04-17 Thread Dave Hannum

Besides commas and pipes, what are the next best choices for delimiting
lists?

thanks,
Dave


===
David R Hannum
Ohio University
Web Analyst/Programmer
(740) 597-2524
[EMAIL PROTECTED]


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Transferring 1-3Kb data

2001-04-17 Thread JustinMacCarthy


 2. send the file in http (using WDDX/URL/FORMFIELD)
 and create a copy of the file locally on the server.

 the two solutions are not scalable enough, any help would be
appriciated!



Why is this not scalable ?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Help with Verity Error...pleeeease

2001-04-17 Thread Capolinea

Hello Ladies and Gentlemen,

Always the same problem on my web site hosted by Intermedia with a Verity
collection

Error occurred in tag CFSEARCH
Internal Error: VDKSessionNew failed
Error Code: -125

Tech support always restarts the Cold Fusion services...until the next crash

Any idea to fix this problem?

Thanks a lot for your help
Rémi van der Deure




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CSS

2001-04-17 Thread Douglas Knudsen



I can not recall if this is possible at the moment, but a good ref for
IE technology stuff is on the evil empire's web site at
http://msdn.microsoft.com/workshop/c-frame.htm?/workshop/author/defaul
t.asp

It is actually a good ref for DHTML stuff even if the info is at times
slightly jaded.


Cheers!
'It looks like a strange Star Trek episode.'
 -- anonymous quote about Atlanta's blanket of yellow
-
Douglas Knudsen
Leveraged Technologies Group  !-- My views. All MINE --
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 04/17/2001 08:54 AM

To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)

Subject:  CSS


I want to make "flat" select boxes, radio buttons, and checkboxes.
What I
mean is no shadow and a 1px border of a color.

Anyone have any ideas?  The browser for this app is always IE 5.x

Thanks,

Neil
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Delimiters

2001-04-17 Thread Michael Lugassy

use a series of hard to find types.
something like: "~%~"

this will guarntee NO ONE will type it.

- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:54 PM
Subject: Delimiters


 Besides commas and pipes, what are the next best choices for delimiting
 lists?

 thanks,
 Dave


 ===
 David R Hannum
 Ohio University
 Web Analyst/Programmer
 (740) 597-2524
 [EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CSS

2001-04-17 Thread Bryan LaPlante

input type="text" style="border:1px solid blue;"

- Original Message -
From: "Neil H." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 7:54 AM
Subject: CSS


 I want to make "flat" select boxes, radio buttons, and checkboxes.  What I
 mean is no shadow and a 1px border of a color.

 Anyone have any ideas?  The browser for this app is always IE 5.x

 Thanks,

 Neil




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CSS

2001-04-17 Thread James Maltby

Use something like:

input type="text" name="whatever" style="background-color: FF; border:
1 solid FF"

Or whatever - the style is the important inline code - or you could css the
input tag if you prefer - however "flat" drop down select, radio and check
are nearly impossible - you can change the bgcolor of the drop down and the
font used in such, but I've never seen a flat radio (etc)... 

J

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: 17 April 2001 13:55
To: CF-Talk
Subject: CSS


I want to make "flat" select boxes, radio buttons, and checkboxes.  What I
mean is no shadow and a 1px border of a color.

Anyone have any ideas?  The browser for this app is always IE 5.x

Thanks,

Neil
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CSS

2001-04-17 Thread Capolinea

Hope it can help...

html
head
titleUntitled Document/title
meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
style type="text/css"
!--
..box {  border: #99; border-style: solid; border-top-width: thin;
border-right-width: thin; border-bottom-width: thin; border-left-width:
thin}
--
/style
/head

body bgcolor="#FF"
form method="post" action=""
  input type="text" name="textfield" class="box"
/form
/body
/html


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CSS

2001-04-17 Thread stas

Go here:

http://www.dansteinman.com/dynduo/

Look under Widgets on the left bottom.

- Original Message -
From: "Neil H." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 8:54 AM
Subject: CSS


I want to make "flat" select boxes, radio buttons, and checkboxes.  What I
mean is no shadow and a 1px border of a color.

Anyone have any ideas?  The browser for this app is always IE 5.x

Thanks,

Neil
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Delimiters

2001-04-17 Thread Lomvardias, Christopher

Here is Mr. Watts suggestion which I have used extensively and had no
problems with.


"I typically use the ASCII bell character, CHR 7, for this. I've never had
a
problem yet, but maybe I'm just lucky."

Dave Watts, CTO, Fig Leaf Software

Chris
--
Chris Lomvardias
[EMAIL PROTECTED]
Syscom, Inc.
400 E. Pratt Street, Suite 300
Baltimore, MD 21202
(410)539-3737 x1722 voice
(410)539-7302 fax
[EMAIL PROTECTED] (pager via email)
http://www.syscom.com/
--


-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:55 AM
To: CF-Talk
Subject: Delimiters


Besides commas and pipes, what are the next best choices for delimiting
lists?

thanks,
Dave


===
David R Hannum
Ohio University
Web Analyst/Programmer
(740) 597-2524
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Michael Lugassy

I don't know.. CFFILE?
If there is no other way... :(


- Original Message -
From: "JustinMacCarthy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 3:06 PM
Subject: RE: Transferring 1-3Kb data



  2. send the file in http (using WDDX/URL/FORMFIELD)
  and create a copy of the file locally on the server.
 
  the two solutions are not scalable enough, any help would be
 appriciated!
 


 Why is this not scalable ?



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Verity wizard error in Coldfusion Studio

2001-04-17 Thread Carlo van Wyk

Hi all

I just completed the Verity Wizard in Coldfusion Studio 4.5. (File - New -
CFML - Verity Wizard)
When I do a search it is fine, but as soon as I try to view one of the files
it gives me an error: 

Error Diagnostic Information
An error has occurred.
HTTP/1.0 404 Object Not Found

The url in the url bar is
http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF
USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the error.

My Verity collection name is gencol
The path to the files is C:\cfusion\verity\collections\files\
I haven't made any modifications to the files generated by the wizard.


If someone could help me on this matter I would greatly appreciate it. 
1)What could the error be as I have run this wizard a couple of times and
always get the same error.
2) Why is the URL presented in such a garbled way - is it for security
reasons?
3) I see that the way it is trying to open the file is with a paramater
extended to your cfm file. Is there perhaps a way to link directly to the
file without appending the paramater to the cfm file?

Regards
Carlo van Wyk
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Delimiters

2001-04-17 Thread Michael Caulfield

A while back on this list Dave Watts suggested using a bell (chr(7), or
Cntl-G for the more old school) for a delimiter, since it's a non-printable.
I've used it ever since and saved myself a lot of headache.

[Apologies if I'm crediting the wrong source here]

Michael Caulfield

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 7:55 AM
To: CF-Talk
Subject: Delimiters


Besides commas and pipes, what are the next best choices for delimiting
lists?

thanks,
Dave


===
David R Hannum
Ohio University
Web Analyst/Programmer
(740) 597-2524
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Verity wizard error in Coldfusion Studio

2001-04-17 Thread Carlo van Wyk

Hi all

I just completed the Verity Wizard in Coldfusion Studio 4.5. (File - New -
CFML - Verity Wizard)
When I do a search it is fine, but as soon as I try to view one of the files
it gives me an error: 

Error Diagnostic Information
An error has occurred.
HTTP/1.0 404 Object Not Found

The url in the url bar is
http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF
USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the error.

My Verity collection name is gencol
The path to the files is C:\cfusion\verity\collections\files\
I haven't made any modifications to the files generated by the wizard.


If someone could help me on this matter I would greatly appreciate it. 
1)What could the error be as I have run this wizard a couple of times and
always get the same error.
2) Why is the URL presented in such a garbled way - is it for security
reasons?
3) I see that the way it is trying to open the file is with a paramater
extended to your cfm file. Is there perhaps a way to link directly to the
file without appending the paramater to the cfm file?

Regards
Carlo van Wyk
 

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Drop Down Combo Boxes Disappearing in IE

2001-04-17 Thread Ricq Pattay

I have a CF page with approximately 40-50 drop down select/combo boxes
(query driven  dynamically named). On some computers in IE 5.5 the drop
downs don't appear when the page loads -- there's only a white space where
the drop down should be.  Other form elements (text boxes, submit buttons)
appear normally. Netscape seems fine but with only limited testing from me.

Any ideas?

Ricq Pattay ~ [EMAIL PROTECTED]
Senior Analyst/Programmer
College of Veterinary Medicine
University of Minnesota - Twin Cities


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Note passing system?

2001-04-17 Thread Joe Sheble aka Wizaerd

As strange as this may sound in light of normal developmental thought 
processes... I like to re-invent the wheel... each time I do, I get a 
better, more efficient, and sometimes a much better looking wheel...  of 
course I don't do this all the time, and I may use a function or two that 
somebody else wrote, but I've always written my own applications.  It's why 
I'm a developer... I love developing...

At 02:37 AM 4/17/01 -0400, you wrote:
:o)

Hi Peter. I certainly understand where you're coming from. After 3 years of
doing some solid CF work, I'm very capable of building most of the stuff
that I need. I'm just an advocate of code reuse. If there's something out
there that helps me reduce my coding time, I'd like to take advantage of it.
I really hate reinventing the wheel.

Thanks for the feedback...

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Peter Tilbrook" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 1:59 AM
Subject: RE: Note passing system?


  As a side note - if you have an idea for your application - do it! Do not
  expect someone else to have already written the code for you. CF makes
  coding easy. If you are worried about the code have trusted people try and
  break it. Spend at least 3 weeks with beta testers on trusted code. You
  would be amazed at how the feedback either picks up problems or points
out,
  even unobtrusively, better ways to accomplish a task.
 
  -Original Message-
  From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 17 April 2001 15:33
  To: CF-Talk
  Subject: RE: Note passing system?
 
 
  I implemented the same thing for the new Friends Plus site. The beauty of
  the system is that nobpdys email address is released.
 
  We could be draconian and introduce full auditing but it has not been
  necessary yet. The user remain anonymous and their email address is never
  released unless they give it out.
 
  -Original Message-
  From: Rey Bango [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 17 April 2001 14:57
  To: CF-Talk
  Subject: Re: Note passing system?
 
 
  Not really, Paul. Its more like an internal messaging system. One where I
  can write a message to another user or perhaps a group of users and have
  them correspnd back. Again, its not a true email system but one that would
  allow me to be able to communicate within the scope of my own application.
 
  Rey...
  Certified Allaire Instructor
  Member of Team Allaire
 
  "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
 
 
 
  - Original Message -
  From: "Paul Begovich" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Monday, April 16, 2001 7:35 PM
  Subject: Re: Note passing system?
 
 
   Sounds like you want a project management tool.
  
   We have an internal system here we use to parse out work.  Basically the
   client/project manager submits an item to a form and it appears on the
   necessary persons desktop based on who they select.  They see the item,
do
   the work, mark their time, and reply via the form.  It's a great project
   management tool and it keeps track of correspondence.
  
   Building a system like your describing isn't too difficult, it's just
time
   consuming.  We have looked into outside utilities to do this, but we've
   found them lacking.  As a development shop we have found that when we
need
   some additional functionality we build it on.  The current system we
have
   now has grown out of several developers efforts in the past two years to
   incompass project managment, billing, contacts, work requests, logging,
  and
   a host of other things.
  
   A third party too may save you time in the short run, but in the long
run,
   it'll probably lacks the additional functionality you want.  I recommend
   buiding your own system, keeping in mind you want to be able to add
   additionally functionality in the future.
  
   - Paul
  
  
   - Original Message -
   From: "Rey Bango" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Monday, April 16, 2001 1:07 PM
   Subject: Note passing system?
  
  
Anyone know of a good CF-based note/messaging system? I'm not talking
   about
an email server but more of a db driven messaging software that will
  allow
me to post a message to a specific suer. When that user comes in, they
  can
check for their own messages and reply accordingly. Again, its not an
   email
system per se.
   
Thanks,
   
Rey Bango...
Certified Allaire Instructor
Member of Team Allaire
   
"A browser's beauty, at its heart, is its usefulness as a *TOOL*."
   
   
   
   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: 

order by not working

2001-04-17 Thread paul .

Hi guys am using orderby to sort the fields to get the sort order alphabetically am 
finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY '4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Verity wizard error in Coldfusion Studio

2001-04-17 Thread Capolinea

Seems that the path you give for viewing document is not good


- Original Message -
From: Carlo van Wyk [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:43 PM
Subject: Verity wizard error in Coldfusion Studio


 Hi all

 I just completed the Verity Wizard in Coldfusion Studio 4.5. (File -
New -
 CFML - Verity Wizard)
 When I do a search it is fine, but as soon as I try to view one of the
files
 it gives me an error:

 Error Diagnostic Information
 An error has occurred.
 HTTP/1.0 404 Object Not Found

 The url in the url bar is

http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF
 USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the
error.

 My Verity collection name is gencol
 The path to the files is C:\cfusion\verity\collections\files\
 I haven't made any modifications to the files generated by the wizard.


 If someone could help me on this matter I would greatly appreciate it.
 1)What could the error be as I have run this wizard a couple of times and
 always get the same error.
 2) Why is the URL presented in such a garbled way - is it for security
 reasons?
 3) I see that the way it is trying to open the file is with a paramater
 extended to your cfm file. Is there perhaps a way to link directly to the
 file without appending the paramater to the cfm file?

 Regards
 Carlo van Wyk


 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Dave f

Just a thought;
why not send log data to the server (formfields/database) to begin with.
amount of data is so trivial scalability shouldn't be a problem. (Unless
I've totally misunderstood the problem, and you have hundreds of concurrent
users)
Dave

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 10:29 AM
Subject: Re: Transferring 1-3Kb data


 I don't know.. CFFILE?
 If there is no other way... :(


 - Original Message -
 From: "JustinMacCarthy" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 3:06 PM
 Subject: RE: Transferring 1-3Kb data


 
   2. send the file in http (using WDDX/URL/FORMFIELD)
   and create a copy of the file locally on the server.
  
   the two solutions are not scalable enough, any help would be
  appriciated!
  
 
 
  Why is this not scalable ?
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Delimiters

2001-04-17 Thread Mark Woods

unprintable US-ASCII control characters, chr(30) for example


At 01:54 PM 4/17/2001, you wrote:
Besides commas and pipes, what are the next best choices for delimiting
lists?

thanks,
Dave


===
David R Hannum
Ohio University
Web Analyst/Programmer
(740) 597-2524
[EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Delimiters

2001-04-17 Thread Mark Woods

At 03:11 PM 4/17/2001, you wrote:
use a series of hard to find types.
something like: "~%~"

I think a sequence of characters is interpreted as a sequence of different 
possible delimiters, rather than a single delimiter comprising of a 
sequence of characters.

Might be wrong, but I'm sure I ran into this a few years ago




this will guarntee NO ONE will type it.

- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:54 PM
Subject: Delimiters


  Besides commas and pipes, what are the next best choices for delimiting
  lists?
 
  thanks,
  Dave
 
 
  ===
  David R Hannum
  Ohio University
  Web Analyst/Programmer
  (740) 597-2524
  [EMAIL PROTECTED]
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: order by not working

2001-04-17 Thread Howie Hamlin

Not exactly sure what you're trying to do but you're telling the SQL Server
to sort by the character '4'.  You should specify a field name there without
the quotes.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server

- Original Message -
From: "paul ." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 9:52 AM
Subject: order by not working


 Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
 ---
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC
 
 the above is the SQL whats wrong
 -paul


 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Verity wizard error in Coldfusion Studio

2001-04-17 Thread Carlo van Wyk

I have already double checked that and have set it up in different
directories as well.

Any other suggestions?

Regards
Carlo

-Original Message-
From: Capolinea [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 5:01 PM
To: CF-Talk
Subject: Re: Verity wizard error in Coldfusion Studio


Seems that the path you give for viewing document is not good


- Original Message -
From: Carlo van Wyk [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:43 PM
Subject: Verity wizard error in Coldfusion Studio


 Hi all

 I just completed the Verity Wizard in Coldfusion Studio 4.5. (File -
New -
 CFML - Verity Wizard)
 When I do a search it is fine, but as soon as I try to view one of the
files
 it gives me an error:

 Error Diagnostic Information
 An error has occurred.
 HTTP/1.0 404 Object Not Found

 The url in the url bar is

http://127.0.0.1/search/MyApplication_VOpenFile.cfm?serverFilePath=C%3A%5CCF
 USION%5CVerity%5CCollections%5Cfiles%5Csolve%2Edoc when I receive the
error.

 My Verity collection name is gencol
 The path to the files is C:\cfusion\verity\collections\files\
 I haven't made any modifications to the files generated by the wizard.


 If someone could help me on this matter I would greatly appreciate it.
 1)What could the error be as I have run this wizard a couple of times and
 always get the same error.
 2) Why is the URL presented in such a garbled way - is it for security
 reasons?
 3) I see that the way it is trying to open the file is with a paramater
 extended to your cfm file. Is there perhaps a way to link directly to the
 file without appending the paramater to the cfm file?

 Regards
 Carlo van Wyk


 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Note passing system?

2001-04-17 Thread Arden Weiss

To a hammer, every problem seems like a nail -- Right?

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Joe Sheble aka Wizaerd [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 17, 2001 9:43 AM
To: CF-Talk
Subject:Re: Note passing system?

As strange as this may sound in light of normal developmental thought 
processes... I like to re-invent the wheel... each time I do, I get a 
better, more efficient, and sometimes a much better looking wheel...  of 
course I don't do this all the time, and I may use a function or two that 
somebody else wrote, but I've always written my own applications.  It's why 
I'm a developer... I love developing...

At 02:37 AM 4/17/01 -0400, you wrote:
:o)

Hi Peter. I certainly understand where you're coming from. After 3 years of
doing some solid CF work, I'm very capable of building most of the stuff
that I need. I'm just an advocate of code reuse. If there's something out
there that helps me reduce my coding time, I'd like to take advantage of it.
I really hate reinventing the wheel.

Thanks for the feedback...

Rey...
Certified Allaire Instructor
Member of Team Allaire

"A browser's beauty, at its heart, is its usefulness as a *TOOL*."


- Original Message -
From: "Peter Tilbrook" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 1:59 AM
Subject: RE: Note passing system?


  As a side note - if you have an idea for your application - do it! Do not
  expect someone else to have already written the code for you. CF makes
  coding easy. If you are worried about the code have trusted people try and
  break it. Spend at least 3 weeks with beta testers on trusted code. You
  would be amazed at how the feedback either picks up problems or points
out,
  even unobtrusively, better ways to accomplish a task.
 
  -Original Message-
  From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 17 April 2001 15:33
  To: CF-Talk
  Subject: RE: Note passing system?
 
 
  I implemented the same thing for the new Friends Plus site. The beauty of
  the system is that nobpdys email address is released.
 
  We could be draconian and introduce full auditing but it has not been
  necessary yet. The user remain anonymous and their email address is never
  released unless they give it out.
 
  -Original Message-
  From: Rey Bango [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 17 April 2001 14:57
  To: CF-Talk
  Subject: Re: Note passing system?
 
 
  Not really, Paul. Its more like an internal messaging system. One where I
  can write a message to another user or perhaps a group of users and have
  them correspnd back. Again, its not a true email system but one that would
  allow me to be able to communicate within the scope of my own application.
 
  Rey...
  Certified Allaire Instructor
  Member of Team Allaire
 
  "A browser's beauty, at its heart, is its usefulness as a *TOOL*."
 
 
 
  - Original Message -
  From: "Paul Begovich" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Monday, April 16, 2001 7:35 PM
  Subject: Re: Note passing system?
 
 
   Sounds like you want a project management tool.
  
   We have an internal system here we use to parse out work.  Basically the
   client/project manager submits an item to a form and it appears on the
   necessary persons desktop based on who they select.  They see the item,
do
   the work, mark their time, and reply via the form.  It's a great project
   management tool and it keeps track of correspondence.
  
   Building a system like your describing isn't too difficult, it's just
time
   consuming.  We have looked into outside utilities to do this, but we've
   found them lacking.  As a development shop we have found that when we
need
   some additional functionality we build it on.  The current system we
have
   now has grown out of several developers efforts in the past two years to
   incompass project managment, billing, contacts, work requests, logging,
  and
   a host of other things.
  
   A third party too may save you time in the short run, but in the long
run,
   it'll probably lacks the additional functionality you want.  I recommend
   buiding your own system, keeping in mind you want to be able to add
   additionally functionality in the future.
  
   - Paul
  
  
   - Original Message -
   From: "Rey Bango" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Monday, April 16, 2001 1:07 PM
   Subject: Note passing system?
  
  
Anyone know of a good CF-based note/messaging system? I'm not talking
   about
an email server but more of a db driven messaging software that will
  allow
me to post a message to a specific suer. When that user comes in, they
  can
check for their own messages and reply accordingly. Again, its not an
   email
system per se.
   
Thanks,
   
Rey Bango...
Certified Allaire Instructor
Member of 

RE: order by not working

2001-04-17 Thread Hayes, David

If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.

Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause.  The next programmer
(maybe you) who looks at the code will be glad you did; also, if the column
order in the table is changed, you'll get unexpected results.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working


Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Creating Page Breaks to make page printable?

2001-04-17 Thread Paul Sizemore

I did an ASP project a while back that required page breaks on print. After
head banging by a lot of people, I came up with the following code. 

When printed from "most" browsers, it prints in what looks like page breaks
because of the way browsers try to not break images. If you tie your text
content to an image (that is around 80% of the page height) with a table,
the browser will print what looks to the user as page breaks.

You might need to adjust the height of the spacer, but I think this is the
number that worked in Netscape and IE 3 up. 

table width="100%" border="0" cellspacing="0" cellpadding="0"
  tr
td width="10"img src="spacer.gif" width="1" height="450"/td
tdPage One Content/td
  /tr
/table

table width="100%" border="0" cellspacing="0" cellpadding="0"
  tr
td width="10"img src="spacer.gif" width="1" height="450"/td
tdPage Two Content/td
  /tr
/table 


Paul Sizemore

Finish Line
3308 N Mitthoeffer Rd
Indianapolis, IN 46235
W: 317-899-1022 ext 3516


-Original Message-
From: Bill Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 3:07 AM
To: CF-Talk
Subject: RE: Creating Page Breaks to make page printable?

Don't think page break is implemented in Navigator.

-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: 17 April 2001 05:34
To: CF-Talk
Subject: Re: Creating Page Breaks to make page printable?


http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pageBre
akAfter.asp

- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, April 16, 2001 6:20 PM
Subject: Re: Creating Page Breaks to make page printable?



  Does anyone know of a way to force printing breaks of a document?

 You can do this with style sheets.



 --
 This message sent compliments of db Technology
http://www.dbtech.net/




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Michael Lugassy

Yes. we anticipate hunderds of users simulatniosly.


- Original Message -
From: "Dave f" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 4:04 PM
Subject: Re: Transferring 1-3Kb data


 Just a thought;
 why not send log data to the server (formfields/database) to begin
with.
 amount of data is so trivial scalability shouldn't be a problem. (Unless
 I've totally misunderstood the problem, and you have hundreds of
concurrent
 users)
 Dave

 - Original Message -
 From: "Michael Lugassy" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 10:29 AM
 Subject: Re: Transferring 1-3Kb data


  I don't know.. CFFILE?
  If there is no other way... :(
 
 
  - Original Message -
  From: "JustinMacCarthy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 3:06 PM
  Subject: RE: Transferring 1-3Kb data
 
 
  
2. send the file in http (using WDDX/URL/FORMFIELD)
and create a copy of the file locally on the server.
   
the two solutions are not scalable enough, any help would be
   appriciated!
   
  
  
   Why is this not scalable ?
  
  
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: DNS

2001-04-17 Thread Marcus

I made that migration just a few weeks ago.

The zone files from metaIP should transfer almost perfectly with just a few
minor modifications.

Marcus


 i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this
 particular migration? any recommendations? has anyone had any trouble with
 DNS on Win2K?

 tia.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



check this please

2001-04-17 Thread paul .

Hi Guys !
this is the SQl

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 'key_issues' 
DESC
 
--
"key_issues" field has characters  and i want the table  to be sorted by the 
key_issues alpahebeticaly .
kindly sugest
-paul

--

On Tue, 17 Apr 2001 09:16:27  
 Hayes, David wrote:
If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.

Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause.  The next programmer
(maybe you) who looks at the code will be glad you did; also, if the column
order in the table is changed, you'll get unexpected results.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working


Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Delimiters

2001-04-17 Thread JustinMacCarthy

chr(7)

Justin 

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 3:11 PM
To: CF-Talk
Subject: Re: Delimiters


use a series of hard to find types.
something like: "~%~"

this will guarntee NO ONE will type it.

- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 2:54 PM
Subject: Delimiters


 Besides commas and pipes, what are the next best choices for delimiting
 lists?

 thanks,
 Dave


 ===
 David R Hannum
 Ohio University
 Web Analyst/Programmer
 (740) 597-2524
 [EMAIL PROTECTED]




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: check this please this orderby not working

2001-04-17 Thread paul .

 
--

On Tue, 17 Apr 2001 07:34:07  
 paul . wrote:
Hi Guys !
this is the SQl

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 
'key_issues' DESC
 
--
"key_issues" field has characters  and i want the table  to be sorted by the 
key_issues alpahebeticaly .
kindly sugest
-paul

--

On Tue, 17 Apr 2001 09:16:27  
 Hayes, David wrote:
If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.

Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause.  The next programmer
(maybe you) who looks at the code will be glad you did; also, if the column
order in the table is changed, you'll get unexpected results.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working


Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: check this please

2001-04-17 Thread Howie Hamlin

remove the quotes around key_issues like:

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
key_issues DESC

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server


- Original Message -
From: "paul ." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 10:34 AM
Subject: check this please


 Hi Guys !
 this is the SQl
 
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

 --
 "key_issues" field has characters  and i want the table  to be sorted by
the key_issues alpahebeticaly .
 kindly sugest
 -paul

 --

 On Tue, 17 Apr 2001 09:16:27
  Hayes, David wrote:
 If you're trying to sort by the 4th item in the columns list, omit the
 single quotes around 4.
 
 Given that you are using the * to select all the columns, I suggest
 specifying the column name in your order by clause.  The next programmer
 (maybe you) who looks at the code will be glad you did; also, if the
column
 order in the table is changed, you'll get unexpected results.
 
 -Original Message-
 From: paul . [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 8:53 AM
 To: CF-Talk
 Subject: order by not working
 
 
 Hi guys am using orderby to sort the fields to get the sort order
 alphabetically am finding taht is not working please suggest
 ---
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
 '4' ASC
 
 the above is the SQL whats wrong
 -paul
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/

 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



New Courseware Survey

2001-04-17 Thread Steve Drucker


In order to better serve our customers and the CF/MM community at-large, Fig
Leaf Software has developed a courseware survey where you can indicate which
web development topics interest you the most.

All responses are anonymous.

Please participate by accessing the following url:

http://www.figleaf.com/trainingsurvey/

Regards,
Steve Drucker
CEO
Fig Leaf Software

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CSS

2001-04-17 Thread Neil H.

In IE all this does is put a gray square around the box?!

Neil

- Original Message -
From: "Capolinea" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, March 11, 2001 10:18 AM
Subject: Re: CSS


 Hope it can help...

 html
 head
 titleUntitled Document/title
 meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
 style type="text/css"
 !--
 ..box {  border: #99; border-style: solid; border-top-width: thin;
 border-right-width: thin; border-bottom-width: thin; border-left-width:
 thin}
 --
 /style
 /head

 body bgcolor="#FF"
 form method="post" action=""
   input type="text" name="textfield" class="box"
 /form
 /body
 /html



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: check this please

2001-04-17 Thread Michael Lugassy

get off the ' out of "key_issues"

- Original Message -
From: "paul ." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 4:34 PM
Subject: check this please


 Hi Guys !
 this is the SQl
 
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

 --
 "key_issues" field has characters  and i want the table  to be sorted by
the key_issues alpahebeticaly .
 kindly sugest
 -paul

 --

 On Tue, 17 Apr 2001 09:16:27
  Hayes, David wrote:
 If you're trying to sort by the 4th item in the columns list, omit the
 single quotes around 4.
 
 Given that you are using the * to select all the columns, I suggest
 specifying the column name in your order by clause.  The next programmer
 (maybe you) who looks at the code will be glad you did; also, if the
column
 order in the table is changed, you'll get unexpected results.
 
 -Original Message-
 From: paul . [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 8:53 AM
 To: CF-Talk
 Subject: order by not working
 
 
 Hi guys am using orderby to sort the fields to get the sort order
 alphabetically am finding taht is not working please suggest
 ---
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
 '4' ASC
 
 the above is the SQL whats wrong
 -paul
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/

 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Creating Page Breaks to make page printable?

2001-04-17 Thread Michael Lugassy

If you mean a printable version for every page (just
like we did on:
http://www.imvamp.com/support/documentation/player/monitor/index.html
(click on: printable version)

you should use a table code that will break the line
at about 650 pixels width

just specify

table width=650
and on every td specify td width=650
this will break lines automaticlly at the end of the words with no need to
use BR or special wrapping techniques.

just keep the table below 650pixels!
and make a clean page. people like it!

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: check this please

2001-04-17 Thread paul .

well Howie !.
 key_issues field is a charecter field.. it throws erroer
-paul

--

On Tue, 17 Apr 2001 10:43:42  
 Howie Hamlin wrote:
remove the quotes around key_issues like:

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
key_issues DESC

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server


- Original Message -
From: "paul ." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 10:34 AM
Subject: check this please


 Hi Guys !
 this is the SQl
 
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

 --
 "key_issues" field has characters  and i want the table  to be sorted by
the key_issues alpahebeticaly .
 kindly sugest
 -paul

 --

 On Tue, 17 Apr 2001 09:16:27
  Hayes, David wrote:
 If you're trying to sort by the 4th item in the columns list, omit the
 single quotes around 4.
 
 Given that you are using the * to select all the columns, I suggest
 specifying the column name in your order by clause.  The next programmer
 (maybe you) who looks at the code will be glad you did; also, if the
column
 order in the table is changed, you'll get unexpected results.
 
 -Original Message-
 From: paul . [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 8:53 AM
 To: CF-Talk
 Subject: order by not working
 
 
 Hi guys am using orderby to sort the fields to get the sort order
 alphabetically am finding taht is not working please suggest
 ---
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
 '4' ASC
 
 the above is the SQL whats wrong
 -paul
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/

 




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: check this please

2001-04-17 Thread Terry Bader

remove the single quotes around key_issues


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






 -Original Message-
 From: paul . [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 10:34 AM
 To: CF-Talk
 Subject: check this please
 
 
 Hi Guys !
 this is the SQl
 
 select * from UHC.PCA_SPECIAL where team_idx=1 and 
 quarter_idx=5 ORDER BY 'key_issues' DESC
  
 --
 "key_issues" field has characters  and i want the table  to 
 be sorted by the key_issues alpahebeticaly .
 kindly sugest
 -paul
 
 --
 
 On Tue, 17 Apr 2001 09:16:27  
  Hayes, David wrote:
 If you're trying to sort by the 4th item in the columns 
 list, omit the
 single quotes around 4.
 
 Given that you are using the * to select all the columns, I suggest
 specifying the column name in your order by clause.  The 
 next programmer
 (maybe you) who looks at the code will be glad you did; 
 also, if the column
 order in the table is changed, you'll get unexpected results.
 
 -Original Message-
 From: paul . [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 8:53 AM
 To: CF-Talk
 Subject: order by not working
 
 
 Hi guys am using orderby to sort the fields to get the sort order
 alphabetically am finding taht is not working please suggest
 ---
 select * from UHC.PCA_SPECIAL where team_idx=1 and 
 quarter_idx=5 ORDER BY
 '4' ASC
 
 the above is the SQL whats wrong
 -paul
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



ODD CF error message

2001-04-17 Thread Shawnea Carter

This one came in our support logs today:

THISTAG.HASENDTAG=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223
335654321

Anyone?

Thanks!

Shawnea Carter





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: check this please

2001-04-17 Thread Dylan Bromby

take the single quotes out.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 7:34 AM
To: CF-Talk
Subject: check this please


Hi Guys !
this is the SQl

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

--
"key_issues" field has characters  and i want the table  to be sorted by the
key_issues alpahebeticaly .
kindly sugest
-paul

--

On Tue, 17 Apr 2001 09:16:27
 Hayes, David wrote:
If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.

Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause.  The next programmer
(maybe you) who looks at the code will be glad you did; also, if the column
order in the table is changed, you'll get unexpected results.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working


Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: check this please

2001-04-17 Thread Dylan Bromby

post your error.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 7:57 AM
To: CF-Talk
Subject: Re: check this please


well Howie !.
 key_issues field is a charecter field.. it throws erroer
-paul

--

On Tue, 17 Apr 2001 10:43:42
 Howie Hamlin wrote:
remove the quotes around key_issues like:

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
key_issues DESC

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server


- Original Message -
From: "paul ." [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 10:34 AM
Subject: check this please


 Hi Guys !
 this is the SQl
 
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

 --
 "key_issues" field has characters  and i want the table  to be sorted by
the key_issues alpahebeticaly .
 kindly sugest
 -paul

 --

 On Tue, 17 Apr 2001 09:16:27
  Hayes, David wrote:
 If you're trying to sort by the 4th item in the columns list, omit the
 single quotes around 4.
 
 Given that you are using the * to select all the columns, I suggest
 specifying the column name in your order by clause.  The next programmer
 (maybe you) who looks at the code will be glad you did; also, if the
column
 order in the table is changed, you'll get unexpected results.
 
 -Original Message-
 From: paul . [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 8:53 AM
 To: CF-Talk
 Subject: order by not working
 
 
 Hi guys am using orderby to sort the fields to get the sort order
 alphabetically am finding taht is not working please suggest
 ---
 select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER
BY
 '4' ASC
 
 the above is the SQL whats wrong
 -paul
 
 
 Get 250 color business cards for FREE!
 http://businesscards.lycos.com/vp/fastpath/

 




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Jon Hall

With a couple of hundred users simultaneously, I dont think this is a job
for CF, unless it's just processing the files after they have been uploaded.
I think this functionality needs to be built into your application. The
application needs to open a connection to the host which is listening for
your clients Upload the file, then disconnect. Easier than writing an mp3
decoder... At least in java it would be...

jon
- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 11:24 AM
Subject: Re: Transferring 1-3Kb data


 Yes. we anticipate hunderds of users simulatniosly.


 - Original Message -
 From: "Dave f" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 4:04 PM
 Subject: Re: Transferring 1-3Kb data


  Just a thought;
  why not send log data to the server (formfields/database) to begin
 with.
  amount of data is so trivial scalability shouldn't be a problem. (Unless
  I've totally misunderstood the problem, and you have hundreds of
 concurrent
  users)
  Dave
 
  - Original Message -
  From: "Michael Lugassy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 10:29 AM
  Subject: Re: Transferring 1-3Kb data
 
 
   I don't know.. CFFILE?
   If there is no other way... :(
  
  
   - Original Message -
   From: "JustinMacCarthy" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Tuesday, April 17, 2001 3:06 PM
   Subject: RE: Transferring 1-3Kb data
  
  
   
 2. send the file in http (using WDDX/URL/FORMFIELD)
 and create a copy of the file locally on the server.

 the two solutions are not scalable enough, any help would be
appriciated!

   
   
Why is this not scalable ?
   
   
   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Creating Page Breaks to make page printable?

2001-04-17 Thread Arden Weiss

I use max table width of 670 with similar success.

The advantage of this in addition to printing is that 670 pixel width 
displays well on any size screen.

On 640x480 the user has to scroll the screen right to see everything. On 
800x640 the total available screen width is used effectively. On higher 
resolution screens the used area is still restricted to the 670 pixel 
center portion of the screen.

When printing, the 670 pixels will fit on a portrait page well (680 is to 
big).  650 pixel table widths will also work fine, but you can get 20 more 
pixels with the 670 setting.

Vertical paginated control of printed pages is a completely different 
issue. There I am using PDF files -- created and displayed in the browser 
via an application button -- not the browsers print button. Alternatively 
one can use CFEXECUTE to run Access or FoxPro report writer on the server 
and print to a PDF file which is then displayed in the browser and printed 
accordingly (the latter requires the CF administrator  permission to run 
CFEXECUTE, which is unlikely on hosted shared servers).

Don't you just love the fact that these hot-shot tool developers provide us 
poor little application developers with these half-baked tools.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Michael Lugassy [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 17, 2001 11:55 AM
To: CF-Talk
Subject:Re: Creating Page Breaks to make page printable?

If you mean a printable version for every page (just
like we did on:
http://www.imvamp.com/support/documentation/player/monitor/index.html
(click on: printable version)

you should use a table code that will break the line
at about 650 pixels width

just specify

table width=650
and on every td specify td width=650
this will break lines automaticlly at the end of the words with no need to
use BR or special wrapping techniques.

just keep the table below 650pixels!
and make a clean page. people like it!

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: (Easy SQL)

2001-04-17 Thread Hayes, David

Take a look at the convert function.

convert(char(8), signup_datetime, 1) as signup_date should give you what you
want.

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:09 PM
To: CF-Talk
Subject: (Easy SQL)


I have a member table which contains
userid, signup_datetime

I want to create a daily summary of registrations.
select signup_datetime as justDatenotTime,count(userID) as NewMembers
from membertable
group by justDatenotTime

== * ==
I know this has to be simple, but I can't find the syntax. How do I drop the

time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just 
the day?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



great Search Results snippest!

2001-04-17 Thread Michael Lugassy

Hi,
I just constructed a snippest that will highlight each word on the results page (very 
much like MSDN
results page). SUPPORT MULTIPLE keywords!

I just did it in a couple of minutes and HAD TO GIVE IT TO YA to look and use.

I will post the optimized version soon...

*class="highlight" reffers to the design you want to highlight
in my case:  

style type="text/css"
..highlight{background-color : Yellow;}
/style


This is the coldfusion code you'll need:


cfset a=ArrayNew(1)
cfset a=ListToArray(q," ") !---q is the query form field---

cfoutput query="x" !--- match your query/verity switch here---

cfset thisrow=""
cfif Arraylen(a) eq 1cfset toary=1
cfset row=""cfelsecfset row="ReplaceNoCase("cfset 
toary=evaluate(Arraylen(a)-1)/cfif
cfloop index="i" from="1" to="#toary#"
cfset row=row"ReplaceNoCase("
/cfloop
cfset row=row"#chr(34)##SUMMARY##chr(34)#" !--- you can change SUMMARY to whatever 
you're searching/displaying as results---

cfloop index="i" from="1" to="#Arraylen(a)#"
cfset thisrow=thisrow",#chr(34)##a[i]##chr(34)#,#chr(34)#font 
class=highlight#a[i]#/font#chr(34)#)"
/cfloop

cfset row=rowthisrow

#evaluate(row)#
/cfoutput

this will work on multiple words!

Send me your comments.


Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Setting up Access Datasources

2001-04-17 Thread Curtis C. Layton

Here's an interesting question:

We recently set up a server cluster that is configured in this fashion:

Web1/Web2 Boxes:  Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5
SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0

NowI can get SQL Server databases to verify on both Web boxes with no problem.  
I've mapped a drive onto the Web boxes to add Access databases but I cannot get them 
to verify.  Any help with be appreciated. 



Curtis C. Layton
Senior Web Applications Developer
Words In Progress Inc.
[EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



ZIPPING with coldfusion

2001-04-17 Thread Michael Lugassy

Could someone point to a good program/object I can use
to easily zip a couple of 100s .txt files using CFEXCUTE
or CFOBJECT?

(Not in Developer's Exchange..)

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Accessing UniData

2001-04-17 Thread Owen Leonard

Has anyone ever used CF to access data in a UniData database?  Our library
circulation system uses UniData (v. 3.3.2i.b2) to store all book and patron
data, and I'm wondering if I could set it up to interface with CF.  If
anyone has any advice I'd really appreciate it.

-- Owen


Athens County Library Services
http://www.athenscounty.lib.oh.us


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



WAG Equipment/Bandwidth requirements

2001-04-17 Thread Wjreichard

Does anyone have an estimate, or knows of a source of infomation, that can determine 
the number of servers (web/db/etc) that one would need based on unique vistors a month?

If one wanted to run a site with 300K Unique Vistors per month, how would you estimate 
the number of servers needed in a cluster and also the bandwidth needed. I know there 
are a lot of variable like the average amount of data per request etc.

But any WAG estimation info would be appreciated.

Thanks,
Bill

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Michael Lugassy

I'm glad you checked out our product. :)
But what is exactly this connection to the host?
is it via FTP or HTTP?

How is this done with visual c++?

- Original Message -
From: "Jon Hall" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 5:34 PM
Subject: Re: Transferring 1-3Kb data


 With a couple of hundred users simultaneously, I dont think this is a job
 for CF, unless it's just processing the files after they have been
uploaded.
 I think this functionality needs to be built into your application. The
 application needs to open a connection to the host which is listening for
 your clients Upload the file, then disconnect. Easier than writing an mp3
 decoder... At least in java it would be...

 jon
 - Original Message -
 From: "Michael Lugassy" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 11:24 AM
 Subject: Re: Transferring 1-3Kb data


  Yes. we anticipate hunderds of users simulatniosly.
 
 
  - Original Message -
  From: "Dave f" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 4:04 PM
  Subject: Re: Transferring 1-3Kb data
 
 
   Just a thought;
   why not send log data to the server (formfields/database) to begin
  with.
   amount of data is so trivial scalability shouldn't be a problem.
(Unless
   I've totally misunderstood the problem, and you have hundreds of
  concurrent
   users)
   Dave
  
   - Original Message -
   From: "Michael Lugassy" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Tuesday, April 17, 2001 10:29 AM
   Subject: Re: Transferring 1-3Kb data
  
  
I don't know.. CFFILE?
If there is no other way... :(
   
   
- Original Message -
From: "JustinMacCarthy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 3:06 PM
Subject: RE: Transferring 1-3Kb data
   
   

  2. send the file in http (using WDDX/URL/FORMFIELD)
  and create a copy of the file locally on the server.
 
  the two solutions are not scalable enough, any help would be
 appriciated!
 


 Why is this not scalable ?



   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ZIPPING with coldfusion

2001-04-17 Thread Bryan LaPlante

This one works great, http://www.forta.com/cf/tags/ I use it for my Custom
tag wizard http://www.netwebapps.com/mytags/main.cfm
- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 11:42 AM
Subject: ZIPPING with coldfusion


 Could someone point to a good program/object I can use
 to easily zip a couple of 100s .txt files using CFEXCUTE
 or CFOBJECT?

 (Not in Developer's Exchange..)

 Thanks,

 Michael Lugassy
 Interactive Music Ltd.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ZIPPING with coldfusion

2001-04-17 Thread Nick McClure

PKZip command line would work well with CFExecute

www.pkware.com

I have done it before in perl so I am sure it can be done with CFExecute.

At 06:42 PM 4/17/2001 +0200, you wrote:
Could someone point to a good program/object I can use
to easily zip a couple of 100s .txt files using CFEXCUTE
or CFOBJECT?

(Not in Developer's Exchange..)

Thanks,

Michael Lugassy
Interactive Music Ltd.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Setting up Access Datasources

2001-04-17 Thread Terry Bader

alot of times people forget to clear out the username field that is normally
populated with the default "admin"  just a suggestion...


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






 -Original Message-
 From: Curtis C. Layton [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 11:10 AM
 To: CF-Talk
 Subject: Setting up Access Datasources
 
 
 Here's an interesting question:
 
 We recently set up a server cluster that is configured in 
 this fashion:
 
 Web1/Web2 Boxes:  Win 2K Advanced Server SP1, CF Enterprise 
 4.5, MDAC 2.5
 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0
 
 NowI can get SQL Server databases to verify on both Web 
 boxes with no problem.  I've mapped a drive onto the Web 
 boxes to add Access databases but I cannot get them to 
 verify.  Any help with be appreciated. 
 
 
 
 Curtis C. Layton
 Senior Web Applications Developer
 Words In Progress Inc.
 [EMAIL PROTECTED]
 
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: ZIPPING with coldfusion

2001-04-17 Thread Caulfield, Michael

This may not be what your looking for, but there is actually a ZIP object
exposed by CFStudio, easily scriptable with js or vbs. You can find docs on
it in the "scripting the visual tools object model" help file.

If you're just looking to do some admin tasks, it might be a good choice.
License doesn't cover use outside of studio though.

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 11:42 AM
To: CF-Talk
Subject: ZIPPING with coldfusion


Could someone point to a good program/object I can use
to easily zip a couple of 100s .txt files using CFEXCUTE
or CFOBJECT?

(Not in Developer's Exchange..)

Thanks,

Michael Lugassy
Interactive Music Ltd.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: ZIPPING with coldfusion

2001-04-17 Thread Steve Bernard

There's CFX_Zip, if you want "native" tool. Otherwise, most of the popular
ZIP compression tools support command-line execution. WinZip, for example,
has a CLI add-on at their download site.

Steve

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 12:42 PM
To: CF-Talk
Subject: ZIPPING with coldfusion


Could someone point to a good program/object I can use
to easily zip a couple of 100s .txt files using CFEXCUTE
or CFOBJECT?

(Not in Developer's Exchange..)

Thanks,

Michael Lugassy
Interactive Music Ltd.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: great Search Results snippest!

2001-04-17 Thread Raymond Camden

This seems to be a bit overcomplex, unless I'm misreading your code. Why not
just use Regex?

!--- This would be the keywords searched for ---
CFSET Searched = "ray camden"
CFSET ModSearched = "("  Replace(Searched," ","|","ALL")  ")"

!--- This would be the results from the DB, normally a query ---
CFSET Results = "This is a ray test camden foo."
CFOUTPUT
#REReplace(Results,"#ModSearched#","SPAN
CLASS=""highlight""\1/SPAN","ALL")#
/CFOUTPUT

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

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

 -Original Message-
 From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 12:03 PM
 To: CF-Talk
 Subject: great Search Results snippest!


 Hi,
 I just constructed a snippest that will highlight each word on
 the results page (very much like MSDN
 results page). SUPPORT MULTIPLE keywords!

 I just did it in a couple of minutes and HAD TO GIVE IT TO YA to
 look and use.

 I will post the optimized version soon...

 *class="highlight" reffers to the design you want to highlight
 in my case:



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Does Studio have Built-in Scripting?

2001-04-17 Thread Larry W. Virden

I was looking at the figleaf downloaded slides  from the Using VTOM presentation
by Mr. Powers and was wondering - what language is the code on 4th slide?
Normally I think of Windows Scripting Host as being something like Visual
Basic.  What is on page 4 appears to be Javascript; and in fact, the
example files are all *.js , which is what I know I use for javascript.

I am certain that I'm missing something from just reading the slides -
perhaps someone can (gently smile) educate me a bit further on this
topic...
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
--

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Using Java in CF

2001-04-17 Thread Bruce, Rodney

A little help please.  I am trying to use some javascript on my CF pages.  I
would like to pass the formname and  fieldname to the function, perform an
action and return the value: i.e.

SCRIPT LANGUAGE = "JavaScript"
!--
function changevalue(FormName, FieldName)
{
var oldvalue;
var newvalue;

oldvalue = document.FormName.FieldName.value;

TAKE ACTION HERE

document.FormName.FieldName.value = newvalue;
}
//--
/SCRIPT

The formname and Fieldnames are being passed fine,  but how do I use them.
now oldvalue is being set EQ to "document.FormName.FieldName.value" not the
value of the field ,  how can I get the value from the form field. 

If I call the formfield in the function by hardcoding its name I get the
function to work fine, but I would like to re-use this without having to
change the function each time.

Thanks for your help
Rodney

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Cookies and their expiration

2001-04-17 Thread Moneymaker, Jon S (WPNSTA Yorktown)

Still pretty new to all this, but am being asked some questions by superiors
about CF's use/creation of cookies
 
CF (to maintain state) drops a "cookie" on the client that contains a cfid
and cftoken
 
Looking at the cookie (it's properties) in IE, (said superior noted with
some surprise) that the expriation is, or appears to be 2037.
 
MY Question: is there a way to cause said cfid/token/cookie to expire sooner
(a lot sooner)?
 
I tried several things recommended in the books...but the cookie remained on
the browserpersistant little bugger that it is.
 
suggestions?
 
Jon Moneymaker (and yes...that really is my last name)
Network Administrator 
Fleet and Family Support Center, Yorktown, VA 
 
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: check this please: the error on removing the single '

2001-04-17 Thread paul .

hi Guys this is what i got by removing the single quote
--
DB2 Error Code = -134

[IBM][CLI Driver][DB2/6000] SQL0134N Improper use of a string column, host variable, 
constant, or function "KEY_ISSUES". SQLSTATE=42907 



SQL = "select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY 
key_issues DESC"

Data Source = "QRTREPORTS"


-paul 



--

On Tue, 17 Apr 2001 08:26:18  
 Dylan Bromby wrote:
take the single quotes out.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 7:34 AM
To: CF-Talk
Subject: check this please


Hi Guys !
this is the SQl

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

--
"key_issues" field has characters  and i want the table  to be sorted by the
key_issues alpahebeticaly .
kindly sugest
-paul

--

On Tue, 17 Apr 2001 09:16:27
 Hayes, David wrote:
If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.

Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause.  The next programmer
(maybe you) who looks at the code will be glad you did; also, if the column
order in the table is changed, you'll get unexpected results.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working


Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Does Studio have Built-in Scripting?

2001-04-17 Thread Caulfield, Michael

No, actually you're not missing anything. Windows scripting host is just
what the name implies: a host for various scripting languages to run in. WSH
is language neutral and can be used with vbs, js, perlscript, etc. So if you
are a javascripter, go wild.

-Original Message-
From: Larry W. Virden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 11:08 AM
To: CF-Talk
Subject: Re: Does Studio have Built-in Scripting?


I was looking at the figleaf downloaded slides  from the Using VTOM
presentation
by Mr. Powers and was wondering - what language is the code on 4th slide?
Normally I think of Windows Scripting Host as being something like Visual
Basic.  What is on page 4 appears to be Javascript; and in fact, the
example files are all *.js , which is what I know I use for javascript.

I am certain that I'm missing something from just reading the slides -
perhaps someone can (gently smile) educate me a bit further on this
topic...
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden mailto:[EMAIL PROTECTED] URL:
http://www.purl.org/NET/lvirden/
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
--
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Does Studio have Built-in Scripting?

2001-04-17 Thread Jason Powers

Windows Script Host actually runs CScript, WScript, JScript, and VBScript,
if I'm not mistaken.  I haven't used CScript or WScript, and I use
JavaScript in my front-end coding, so that was my natural choice to write my
tools in.  If you have any other questions, feel free to hit me offlist, and
I'd be glad to discuss them with you.

Jason Powers
Fig Leaf Software


-Original Message-
From: Larry W. Virden [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 12:08 PM
To: CF-Talk
Subject: Re: Does Studio have Built-in Scripting?


I was looking at the figleaf downloaded slides  from the Using VTOM
presentation
by Mr. Powers and was wondering - what language is the code on 4th slide?
Normally I think of Windows Scripting Host as being something like Visual
Basic.  What is on page 4 appears to be Javascript; and in fact, the
example files are all *.js , which is what I know I use for javascript.

I am certain that I'm missing something from just reading the slides -
perhaps someone can (gently smile) educate me a bit further on this
topic...
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden mailto:[EMAIL PROTECTED] URL:
http://www.purl.org/NET/lvirden/
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
--
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Setting up Access Datasources

2001-04-17 Thread Andrew Tyrone

 -Original Message-
 From: Curtis C. Layton [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 11:10 AM
 To: CF-Talk
 Subject: Setting up Access Datasources
 
 
 Here's an interesting question:
 
 We recently set up a server cluster that is configured in this fashion:
 
 Web1/Web2 Boxes:  Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC 2.5
 SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0
 
 NowI can get SQL Server databases to verify on both Web boxes 
 with no problem.  I've mapped a drive onto the Web boxes to add 
 Access databases but I cannot get them to verify.  Any help with 
 be appreciated. 


Make sure ColdFusion is running under a user account with sufficient rights to your 
servers.  ColdFusion must be running under it's own user account to be able to access 
network drives.


- Andy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Cookies and their expiration

2001-04-17 Thread Dan G. Switzer, II

Jon,

The reason the cookie last so long is to effectively never expire it.
Preferably, you don't want to reassign a user a new CFID/CFTOKEN pair--you
want to keep those cookies on their system forever, that way you'd be able
to track that particular user over the lifetime of the app. The length of
the cookie doesn't reflect the length of the user's session or client
variables--that's all independant of each other.

However, if you do want to override the setting, you should be able to use
the CFCOOKIE tag and manually re-write the CFID/CFTOKEN variables with a
shorter lifespan. Just be aware that doing so would cause the server to
regenerate a new CFID/CFTOKEN pair for the same browser if they visit your
site after the cookie expires.

-Dan



 -Original Message-
 From: Moneymaker, Jon S (WPNSTA Yorktown)
 [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 17, 2001 12:08 PM
 To: CF-Talk
 Subject: Cookies and their expiration


 Still pretty new to all this, but am being asked some
 questions by superiors
 about CF's use/creation of cookies

 CF (to maintain state) drops a "cookie" on the client that
 contains a cfid
 and cftoken

 Looking at the cookie (it's properties) in IE, (said superior
 noted with
 some surprise) that the expriation is, or appears to be 2037.

 MY Question: is there a way to cause said cfid/token/cookie
 to expire sooner
 (a lot sooner)?

 I tried several things recommended in the books...but the
 cookie remained on
 the browserpersistant little bugger that it is.

 suggestions?

 Jon Moneymaker (and yes...that really is my last name)
 Network Administrator
 Fleet and Family Support Center, Yorktown, VA





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



escaping ' in SQL

2001-04-17 Thread Gil Barden

Hi everyone,
I have a question about how to pass an SQL statement through a text area
box in a form while protecting the SQL statement.  Below I have a
self-submitting form, that passes the dynamic text through the text-area box
and then passes to a query that is to be then displayed.

Problem is, that the SQL gets re-parsed when I use the " ' " single tick
for a string to a " " " double tick.  I have tried htmlcodeFormat() and
htmleditformat() with no success.

The error I recieve is:


Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near
'n'.


SQL = "select * from d_school_names where charter_school = ''n''"



Here is my code:


html
head
/head
body bgcolor="#C0C0C0"
cfif isdefined("form.submit")
!--- Dynamice Query ---
!--- cftry   ---
cfquery name="dynQuery" datasource="xxx" username=""
password=""
#form.sql#
/cfquery

!--- Outputting query ---

cfset columns = ListtoArray(#dynQuery.ColumnList#)
cfset numColumns = arraylen(#columns#)

table border="1" cellpadding="1" cellspacing="1"
thCurrent Row/th
cfloop index="i" from="1" to="#numColumns#"
cfoutputth#columns[i]#/th/cfoutput
/cfloop

cfloop query="dynQuery"
tr
td

cfoutput#dynQuery.currentRow#/cfoutput
/td
cfloop index="i" from="1" 
to="#numColumns#"
td
cfoutput
cfif 
evaluate(columns[i]) EQ ""
nbsp;
cfelse

#evaluate(columns[i])#
/cfif
/cfoutput
/td
/cfloop
/tr
/cfloop
/table
!--- cfcatch type="Database"
You have caused a database error!  Please hit your back button 
and try
again.
/cfcatch
!--- Catching any type of error. ---
cfcatch type="Any"
You have caused a database error!  Please hit your back button 
and try
again.
/cfcatch
/cftry  ---

!--- First time through form ---
cfelse

h3  Please Enter a SQL Statement below/h3

form action="#cgi.script_name#?#cgi.Query_String#" method="post"

textarea cols="50" rows="5" name="SQL"
/textarea
br
input type="Submit" name="submit"
/form
/cfif
/body
/html




Gil Barden


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: check this please: the error on removing the single '

2001-04-17 Thread Dylan Bromby

post the columns and their respective datatypes. i'm not super familiar with
DB2 though so i don't know if that's a nuance of that DB.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 9:20 AM
To: CF-Talk
Subject: RE: check this please: the error on removing the single '


hi Guys this is what i got by removing the single quote
--
DB2 Error Code = -134

[IBM][CLI Driver][DB2/6000] SQL0134N Improper use of a string column, host
variable, constant, or function "KEY_ISSUES". SQLSTATE=42907



SQL = "select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5
ORDER BY key_issues DESC"

Data Source = "QRTREPORTS"


-paul



--

On Tue, 17 Apr 2001 08:26:18
 Dylan Bromby wrote:
take the single quotes out.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 7:34 AM
To: CF-Talk
Subject: check this please


Hi Guys !
this is the SQl

select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'key_issues' DESC

--
"key_issues" field has characters  and i want the table  to be sorted by
the
key_issues alpahebeticaly .
kindly sugest
-paul

--

On Tue, 17 Apr 2001 09:16:27
 Hayes, David wrote:
If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.

Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause.  The next programmer
(maybe you) who looks at the code will be glad you did; also, if the
column
order in the table is changed, you'll get unexpected results.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working


Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
---
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC

the above is the SQL whats wrong
-paul


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Transferring 1-3Kb data

2001-04-17 Thread Jon Hall

Not necessarily either although there are tons of ftp libraries out there
that could be implemented into the program very easily. A raw tcp or udp
connect on whatever port you want would work. You would have to write the
server side app that received the file, then write it to the hard drive.
I think if I was doing this, I'd code the ftp capabilities into the client
and just make the program upload it's log file, if only in the interest of
time savings, and programming an industrial size server side daemon in java
is not something a can do yet ;-)

jon

- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:57 PM
Subject: Re: Transferring 1-3Kb data


 I'm glad you checked out our product. :)
 But what is exactly this connection to the host?
 is it via FTP or HTTP?

 How is this done with visual c++?

 - Original Message -
 From: "Jon Hall" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 5:34 PM
 Subject: Re: Transferring 1-3Kb data


  With a couple of hundred users simultaneously, I dont think this is a
job
  for CF, unless it's just processing the files after they have been
 uploaded.
  I think this functionality needs to be built into your application. The
  application needs to open a connection to the host which is listening
for
  your clients Upload the file, then disconnect. Easier than writing an
mp3
  decoder... At least in java it would be...
 
  jon
  - Original Message -
  From: "Michael Lugassy" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Tuesday, April 17, 2001 11:24 AM
  Subject: Re: Transferring 1-3Kb data
 
 
   Yes. we anticipate hunderds of users simulatniosly.
  
  
   - Original Message -
   From: "Dave f" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Tuesday, April 17, 2001 4:04 PM
   Subject: Re: Transferring 1-3Kb data
  
  
Just a thought;
why not send log data to the server (formfields/database) to
begin
   with.
amount of data is so trivial scalability shouldn't be a problem.
 (Unless
I've totally misunderstood the problem, and you have hundreds of
   concurrent
users)
Dave
   
- Original Message -
From: "Michael Lugassy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 10:29 AM
Subject: Re: Transferring 1-3Kb data
   
   
 I don't know.. CFFILE?
 If there is no other way... :(


 - Original Message -
 From: "JustinMacCarthy" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, April 17, 2001 3:06 PM
 Subject: RE: Transferring 1-3Kb data


 
   2. send the file in http (using WDDX/URL/FORMFIELD)
   and create a copy of the file locally on the server.
  
   the two solutions are not scalable enough, any help would be
  appriciated!
  
 
 
  Why is this not scalable ?
 
 
 

   
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Setting up Access Datasources

2001-04-17 Thread Curtis C. Layton

Thanks...that might be it...I was messing with the service logins but I'm
going to have to talk to our SA to work that one out.  Thanks again.

- Original Message -
From: "Andrew Tyrone" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:47 PM
Subject: RE: Setting up Access Datasources


  -Original Message-
  From: Curtis C. Layton [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, April 17, 2001 11:10 AM
  To: CF-Talk
  Subject: Setting up Access Datasources
 
 
  Here's an interesting question:
 
  We recently set up a server cluster that is configured in this fashion:
 
  Web1/Web2 Boxes:  Win 2K Advanced Server SP1, CF Enterprise 4.5, MDAC
2.5
  SQL Box: Win 2K Advanced Server SP1, SQL Server 7.0
 
  NowI can get SQL Server databases to verify on both Web boxes
  with no problem.  I've mapped a drive onto the Web boxes to add
  Access databases but I cannot get them to verify.  Any help with
  be appreciated.


 Make sure ColdFusion is running under a user account with sufficient
rights to your servers.  ColdFusion must be running under it's own user
account to be able to access network drives.


 - Andy



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   >