Re: URL parameter in a Frame

2000-06-23 Thread Brett Payne-Rhodes
Ummm, why can't you pass a URL parameter to a frame? I do it all the time and it seems to work for me... Is it that you are passing it to the frameset but not then passing it to the relevant frame? For example, if I have a frameset called diary.cfm which has two frames diaryCalendar.cfm and diary

Re: Stored Procedure

2000-06-23 Thread Sean Renet
So Dave, how would you rewrite this SP using DECODE to dynamically set the ORDER BY? CREATE PROCEDURE webclientacctholddaily @caccountid int, @OrderBy varchar(50) AS DECLARE @mySQL nvarchar(500) SET @mySQL = N'SELECT holdings.*,securities.* FROM holdings, securities WHERE holdings.secid = securit

Form to CFMAIL Sending Attachment Problem

2000-06-23 Thread KJis18
Ok what i am trying to do is send a "resume" document from a file field in a form, to the next page which will process it as a MIMEATTACH in the CFMAIL Tag. For some reason, it does it correctly, but it does not show the right file attached, all it shows is a .tmp file. Can someone help me?

Re: Credit Card Number Parameters

2000-06-23 Thread Seth Petry-Johnson
> Has anyone got a list of the values for credit card numbers like if the number begins with > "6" it's a Discover Card, etc, etc. 4 = Visa 5 = Mastercard 6 = Discover (at least according to you, I don't know for sure ) > I'd like to write some javascript validation using the information hidden

Re: using at rather than cfschedule

2000-06-23 Thread Jim McAtee
Create a batch file and schedule the batch file using AT. In the batch file you need to set an environment variable indicating the location of the cf template. Optionally, you can set whatever values you'd want in your CGI query string (url parameters). Example: @echo off set "QUERY_STRING=Req

Re: Shopping Mall Application

2000-06-23 Thread Sim Graves
Dear Shane, Thanks for the AbleCommerce source. It looks real promising for my project and certainly inexpensive enough. You're a pal for taking your time to help me. Sim Shane Witbeck wrote: > AbleCommerce. > > Sincerely, > > Shane Witbeck > Webmaster > [EMAIL PROTECTED] > www.digitalsanct

RE: Shopping Mall Application

2000-06-23 Thread Steve Pierce
Just FYI CartEase is $249 for 5 stores with 1yr support and upgrades. - Steve -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 10:18 PM To: [EMAIL PROTECTED] Subject: RE: Shopping Mall Application Sim, In addition to AbleCommerce, take

RE: Shopping Mall Application

2000-06-23 Thread Chris Montgomery
Sim, In addition to AbleCommerce, take a look at Cartease, http://www.cartease.com. I'm in the process of evaluating it against a couple other low-cost shopping carts, but it might be what you need. It (version 2) has the capability to let affiliates create and generate stores. Download the de

RE: Shopping Mall Application

2000-06-23 Thread Shane Witbeck
AbleCommerce. Sincerely, Shane Witbeck Webmaster [EMAIL PROTECTED] www.digitalsanctum.com -Original Message- From: Sim Graves [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 9:22 PM To: [EMAIL PROTECTED] Subject: Shopping Mall Application I've created a few individual store

Shopping Mall Application

2000-06-23 Thread Sim Graves
I've created a few individual stores in CF/FuseBox but my client wants to create a mall where members can build their own stores through an HTLM interface. Have any of you created such a critter that I could purchase. I think it would be more cost effective for my client to purchase this ap

using at rather than cfschedule

2000-06-23 Thread Jason Egan
WAAAY back there was a post on using the NT AT command rather than cfschedule -- is cfschedule better in 4.5? -- if not, does anyone know the correct way to use AT to run a CFM script? Thanks je -- Archives: http://www.e

Re: not cfinclude, but...

2000-06-23 Thread C
At 04:50 PM 6/23/00 -0400, you wrote: >I'll try and make this as clear as possible... > >What I am attempting to do is include header and footer pages on any given >document. These are .htm pages, and are not on a cold fusion server so I >can't use . Is there a way, and where do I find the resou

Credit Card Number Parameters

2000-06-23 Thread Sim Graves
Has anyone got a list of the values for credit card numbers like if the number begins with "6" it's a Discover Card, etc, etc. I'd like to write some javascript validation using the information hidden within the numbers. TIA Sim Graves

Re: not cfinclude, but...

2000-06-23 Thread Dana Larose
If think there is a way if your are using server side includes, the #include directive or something like that. (All you have to do is tell your webserver to accept .shtml pages). This may not work, as it has been a LONG time since I've done anything with SSI. If you are stuck with just .htm pag

RE: not cfinclude, but...

2000-06-23 Thread ron
> What I am attempting to do is include header and > footer pages on any given > document. These are .htm pages, and are not on a > cold fusion server so I > can't use . Is there a way, and where do > I find the resources to > do this? Steve, Check out the tag. With it, you can grab another s

random record query retrieval

2000-06-23 Thread Richard Mazur
Hi. I have a database of 4,000 or so records. I would like to do a query based on some conditions (i.e. where active =1 AND group_id = 45). I can do this. The problem I have having is that out of the conditional query I would like to pull a random 3 records out and have use and be able to output

RE: Inserting Multiple Values into One Database Field

2000-06-23 Thread Anthony Israel-Davis
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFDD6E.32B327EA Content-Type: text/plain; charset="iso-8859-1" Don't know what's up without seeing the code. Off the top of my

not cfinclude, but...

2000-06-23 Thread Steve Dworman
I'll try and make this as clear as possible... What I am attempting to do is include header and footer pages on any given document. These are .htm pages, and are not on a cold fusion server so I can't use . Is there a way, and where do I find the resources to do this? Please email me off the l

Re: Inserting Multiple Values into One Database Field

2000-06-23 Thread KJis18
hey there, thanks for the Tip Anthony, but when I search like two words, it won't pick it up, it only picks up the first word i put in my search box. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe

SQL Server 6.5 Problem

2000-06-23 Thread Mark Rogers
SQL Server Problem We have been running Sequel Server 6.5 (SQL 6.5, NT 4.0 SP5) uneventfully for some time now. While rebooting the server today received the following error message "unable to start SQLSERVER SERVICES due to internal NT error". No changes or upgrades have been made to the server

RE: Inserting Multiple Values into One Database Field

2000-06-23 Thread Anthony Israel-Davis
Doh! - sorry about the last post hit send when going for 'file'. Anyhoo - Worked fine for me - I'm using SQL Server7, BTW...maybe I misunderstood the question but '#var1# #var2 #var3...#' works fine with MSSS7. ant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] S

Re: Parsing Data to the same page

2000-06-23 Thread Jon Boehnker
the name of the form needs to be different from the name of the select box.. right now you have them both set to 'area'. HTH Jon - Original Message - From: WL <[EMAIL PROTECTED]> To: "Dana Larose" <[EMAIL PROTECTED]> Cc: Cold Fusion Talk <[EMAIL PROTECTED]> Sent: Friday, June 23, 200

RE: Inserting Multiple Values into One Database Field

2000-06-23 Thread Anthony Israel-Davis
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFDD65.9C442DD4 Content-Type: text/plain; charset="iso-8859-1" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMA

Re: Parsing Data to the same page

2000-06-23 Thread Brian Peddle
What you are attempting to do will not work this way. Cold Fusion processes the page on the server and returns HTML to the client. If someone choices something in select box 1, you cant run a query to get select box two unless you submit the page again. There are 3 options I know of. 1. Afte

RE: Inserting Multiple Values into One Database Field

2000-06-23 Thread KChapman
That should throw a SQL error. What you need to do is create the list outside of your query statement. INSERT INTO search(keywords) VALUES('#keywords#') --K Katrina Chapman Consultant Ameriquest Mortgage

Re: Parsing Data to the same page

2000-06-23 Thread WL
> If I understand you correctly, you want the second version of your SQL > statement to happen only if the user selects a category, otherwise use the > first. OK well I've uses your idea but have come across a really irritating problem. Obviously this select is only on the 2nd page, but the er

Re: Serving Dynamic RA and WMP

2000-06-23 Thread Dirk De Bock
You can do this with CF : rstp://www.yourserver.com#rasrc# in a file by itself So you give the correct path in the parameter 'rasrc' I never tried this with Windows Media but there's no reason it won't work the same way - Original Message - From: "Duane Boudreau" <[EMAIL PROTECTED]>

RE: Inserting Multiple Values into One Database Field

2000-06-23 Thread Anthony Israel-Davis
Try this: INSERT INTO search(keywords) VALUES('#name#,#address#,#phone#') remove the "AND"s and wrap the whole thing in single quotes. Hope that helps ant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 1:56 PM To: [EMAIL PROTECTED]

RE: Verity Search rules

2000-06-23 Thread Richard Colman
Check out: http://www.faculty.uci.edu/index.htm look towards the bottom of the page and you will see another attempt to provide concise user instructions for a rather complex set of rules. Good luck. Richard Colman -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent:

Re: Verity Search rules

2000-06-23 Thread paul smith
I put as much as I thot users could put up with at http://www.cbee.org/search.html best, paul At 05:04 PM 6/23/00 -0400, you wrote: >I am using verity to search my web site, and I need to have an explanation >describing the rules and syntax of a verity search for my users. Does >anyone have th

Re: Parsing Data to the same page

2000-06-23 Thread Dana Larose
If I understand you correctly, you want the second version of your SQL statement to happen only if the user selects a category, otherwise use the first. Presumably, your select box will look like: All Categories 1 ... All you need is to have your query look like: SELECT *

Parsing Data to the same page

2000-06-23 Thread WL
Hi, This is going to seem trivial for all of you, but I hope you can spare me a min. I have a page, in which I want it to modify a SQL query depending on a users' selection. For exampls, the following SQL: SELECT * FROM advert_details WHERE county = 'berks' What I need to do is have a Select

Verity Search rules

2000-06-23 Thread Robert M. Saxon, Jr.
I am using verity to search my web site, and I need to have an explanation describing the rules and syntax of a verity search for my users. Does anyone have these instructions on a page that they would be willing to share? ___ Robert M. Saxon, Jr. (Rob), S

Inserting Multiple Values into One Database Field

2000-06-23 Thread KJis18
Ok, what i am trying to do is add a column in my database that would contain "Keywords" for a search. What i am trying to do is add values from the data entered in the form from the previous page to one field in the database I only get a value of "-1" ? is there something i am doing wr

RE: Java and CF

2000-06-23 Thread Larry Meadors
I've used createobject() successfully. Didn't look to closely at the mem use. Is it possible that the mem use you're seeing is the jvm? We just had a thread about cfx tags in java. Read it before going that route unles you *like* to restart services... ;-) Larry >>> [EMAIL PROTECTED] 06/2

RE: Running Stored Procedures on AS/400 or DB2???

2000-06-23 Thread Robert Everland
I don't think AS/400 can do stored procedures. I know DB2 can but not the flavor of DB2 that the AS/400 runs. YOu can get an add on SQL tool for AS/400 to run stored procedures though. We are using AS/400 with JDEdwards to do a ton of stuff and are getting the SQL add on. I do find that the client

Serving Dynamic RA and WMP

2000-06-23 Thread Duane Boudreau
Hi All, I've been trying to wrap my head around this one all day and either going to have to give up and hit the margaritas or ask the experts. I have a client (whom shall remain unnamed) that is having problems serving RA and WMP files in Netscape. The problem is that the content is being served

Running Stored Procedures on AS/400 or DB2???

2000-06-23 Thread joeug
Hello all, I am trying to run a Stored Procedure on an AS/400 using DB2 Connect and Client Express ODBC Connectors. Neither of them work. Have you guys been able to run stored procedures on AS/400 or Db2 successfully? Appretiate any help. Thanks Joe - Sent using MailStart.com ( h

OT: ASP Mailing Lists (asp-talk?)

2000-06-23 Thread Billy Cravens
I've recently begun a contract where the skillset requires both ASP and CF. In addition to brushing up on my ASP skills (been over a year since I did serious development), I'd like to find a list of the same quality as this one for ASP. There's so many of them out there, I thought I'd ask for su

Re: check-box editing

2000-06-23 Thread Christine Kelley
Thanks Mike!! You gave me the clue I needed. - I set some of the info equal to variables and then put it all together. Thanks again, Christine - Original Message - From: "Mike Hughes" <[EMAIL PROTECTED]> To: "Christine Kelley" <

RE: Win2k or NT?

2000-06-23 Thread Dave Watts
> I'm going to be getting a dedicated server for my personal > website from Digital Nation very soon (being with Interland > is really starting to suck). I'll be buying CF 4.5 and SQL > Server 7 and I'm trying to decided if I should go with NT > or 2000. I've heard a lot of good things (as well as

SourceSafe integration

2000-06-23 Thread Ken Goldstraw
Hello fine CFers What's the general consensus of CF's SourceSafe integration feature? My boss is considering using it. TIA Ken Goldstraw Web Developer Bigdough.com -- Archives: http://www.eGroups.com/list/cf-talk To Un

RE: Win2k or NT?

2000-06-23 Thread Kevin Langevin
I run CF Server (Enterprise usually, but Pro right now) and SQL Server 7 on my Laptop (PIII-500/288MB) which is running Win2K Advanced Server. It flies. Stable...Knock on wood, my laptop has not crashed once since I installed the software. I have left it up and running for up to two weeks at a

Re: access across LAN

2000-06-23 Thread Jacob
Create a NT user account for the cold fusion service. Take care of all the necessary permissions (just like if it was a actually person accessing information across the network. Go to Control Panel - Services. Log on as This account. Choose the user account you created for cold fusion. Re start t

Re: Win2k or NT?

2000-06-23 Thread Jeremy Allen
The real problem, most places are quietly not selling NT 4.0 anymore. You can still buy it in *plenty* of places, but ive noticed more than one place wihch has just removed NT from its product list. That said, I would wait for a year at least for Win2K before I trusted it with anything even clo

RE: access across LAN

2000-06-23 Thread mherbene
This article (http://www.allaire.com/Handlers/index.cfm?ID=13519&Method=Full) describes the basic issues, even though it's about Netware servers. You can run CF under a domain account that has rights to both its own server and the other one(s), or you can create a matchine account on the other ma

CFContent not working in IE 5

2000-06-23 Thread Michael P.
The following code works just fine in Netscape 4.x and almost works in IE 5. In IE 5, the file is downloaded but the cursor remains as an hourglass and the icon in the upper-right hand corner keeps spinning as if it is still trying to get a response from the server. If I hit refresh all is good

Re: Win2k or NT?

2000-06-23 Thread Nick McClure
From what I have done windows 2000 is better. IIS 5 seems to be much more stable than 4 At 10:52 AM 6/23/2000 -0600, you wrote: >I'm going to be getting a dedicated server for my personal website from >Digital >Nation very soon (being with Interland is really starting to suck). I'll be >buyin

RE: Win2k or NT?

2000-06-23 Thread Rif Kiamil
I would wait till SP2 or 3 on Win2K. -Original Message- From: Aaron Powell [mailto:[EMAIL PROTECTED]] Sent: 23 June 2000 17:52 To: [EMAIL PROTECTED] Subject: Win2k or NT? I'm going to be getting a dedicated server for my personal website from Digital Nation very soon (being with Interla

RE: Java and CF

2000-06-23 Thread Trahan, Shane
Using CFOBJECT is not the best way eh? So 4.5 now allows CFX's to be written in Java I always thought it was just C? If I recompile the Java Code will I have to register the CFX's again -Original Message- From: Conrad, Christopher [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000

access across LAN

2000-06-23 Thread Jay Wigginton
Can someone point me to a resource or examples that explains how to configure a cold fusion server and another NT server to enable it to access files on the other NT server on the same LAN... specifically, to perform cffile operations, writing files, reading, deleting files on the other a NT serve

Win2k or NT?

2000-06-23 Thread Aaron Powell
I'm going to be getting a dedicated server for my personal website from Digital Nation very soon (being with Interland is really starting to suck). I'll be buying CF 4.5 and SQL Server 7 and I'm trying to decided if I should go with NT or 2000. I've heard a lot of good things (as well as a lot of

CreateODBCTime question

2000-06-23 Thread Gary McNeel, Jr.
I have a tiny little schedule program that runs from MS SQL Server. This is very simple. In it the user enters an EventDetail, EventDate, EventStartTime and EventEndTime. The date and time fields in SQL are DateTime datatype. As I insert or update the records I use a CreateODBCDate for the Event

Re: Logical Limit of NT User Accounts

2000-06-23 Thread Justin v0.9 MacCarthy
FROM http://sam.cs.unc.edu/ntfaq.html Q. How many user accounts can I have in one Domain? A. The real problem is that each user account and machine account takes up space in the SAM file, and the SAM file has to be memory resident. A user account takes up 1024 bytes of memory (a machine account

URL parameter in a Frame

2000-06-23 Thread Tim Bahlke
I ask for some advice on if this is the best way to pass a URL parameter to a nested frame. In application.cfm I have The frame cannot access the URL parameter directly so I though of this work around. Am I going to run into problems down the road if I do this? Thanks. ---

RE: Java and CF

2000-06-23 Thread Conrad, Christopher
CFX_J or CFX's on 4.5x Chris Christopher Conrad Victoria's Secret Catalogue http://www.VictoriasSecret.com Senior.Programmer.Analyst 614.337.5653 [EMAIL PROTECTED] > -Original Message- > From: Trahan, Shane [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 23, 2000 12:08 PM > To: '[EMAIL

RE: Logical Limit of NT User Accounts

2000-06-23 Thread Zachary Bedell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Under NT 4, it was 20,000 accounts per domain. Under Win2k, there's no pratical limit. Regards, Zac Bedell Zachary S. Bedell, Chief Technology Officer, Adirondack Technologies, Inc. Please include original

RE: Changing file permissions in Unix

2000-06-23 Thread Mark Warrick
There are instructions in the CF Documentation titled "Setting File and Directory Attributes". Check the docs. Or just set the permissions with the unix CHMOD command. -- Mark Warrick Phone: (714) 547-5386 Efax.com Fax: (801) 730-72

RE: Changing file permissions in Unix

2000-06-23 Thread Frédéric LeMieux
If you are using CFFILE, you can always put the MODE="" attribute. -Original Message- From: Steve Bernard [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 12:12 PM To: [EMAIL PROTECTED] Subject: RE: Changing file permissions in Unix CFEXECUTE? Steve -Original Message- Fr

RE: [Another Way...]Checking for a record, and then deleting it

2000-06-23 Thread Philip Arnold - ASP
> The correct way in ANSI SQL > would be something Like > > DELETE FROM SystemQuote WHERE CFID Exists IN > ( > Select CFID > FROM SystemQuote > WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) > ) > > Check the syntax but something like that . Isn't that exactly the same as; DELETE FROM SystemQuote

Re: Authenticating a user using NT Authentication

2000-06-23 Thread jeff tapper
It may be as simple as a variable scoping problem. a CFPARAM tag is being used to set a default value of Categories (no scope) to a blank string. The cfa_contentObjectProperty tag is also referencing the the variable without a scope. Its possible the two unscoped variables are actually refe

Re: Changing file permissions in Unix

2000-06-23 Thread Justin v0.9 MacCarthy
Using the mode attribute in File = upload ??? MODE=777 etc just your standard chmod numbers Or you chould try cfexecute chmod etc... BTW the is a linux cf list @ [EMAIL PROTECTED] ~Justin > We have our CF user (www) file permissions set to owner read-write only (no group or world read o

Logical Limit of NT User Accounts

2000-06-23 Thread David B. Brooks
Greetings All, I'm going to utilize Cold Fusion's Advanced Security using my local NT Domain for authentication. Does anyone know the logical limit to the number of users NT can handle in its database? Thanks for all the info! David Brooks PC Pros, Inc. ---

RE: Changing file permissions in Unix

2000-06-23 Thread Steve Bernard
CFEXECUTE? Steve -Original Message- From: Carol Chandler [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 11:51 AM To: [EMAIL PROTECTED] Subject: Changing file permissions in Unix We have our CF user (www) file permissions set to owner read-write only (no group or world read or w

Java and CF

2000-06-23 Thread Trahan, Shane
What is the best way to use Java and CF? I have tried using CFOBJECT but have had alot of problems with it not releasing memory etc.. How can I best leverage Java and CF? If anyone has any insight into Java and CFOBJECT please let me know!! I have been trying to figure out why CFOBJECT doesn't

RE: Support for NCLOB Datatype in Oracle

2000-06-23 Thread Dave Watts
> I ran into this problem a while back. Apparently Cold Fusion has > difficulties putting more than 4000 characters at a time into > a CLOB in Oracle. I ended up writing a little PL/SQL script that > would break down a character string passed to it into chunks and > insert them one by one. I'm no

Changing file permissions in Unix

2000-06-23 Thread Carol Chandler
We have our CF user (www) file permissions set to owner read-write only (no group or world read or write), and like it that way for most instances. However, in one case, we need to change a file generated by CF to group read-write. Is there a chmod command available in CF, or is there some co

RE: Support for NCLOB Datatype in Oracle

2000-06-23 Thread James Berry
Sorry it took so long.. It seems that there is always a major crisis in the morning. --- PL/SQL Code This takes the 4000 characters and appends them to the correct field --- CREATE OR REPLACE PROCEDURE "WEB"."UPDATE_EXPLA

RE: Client variables to an url and form

2000-06-23 Thread Frédéric LeMieux
Never had that specific problem, but I always have CLIENTMANAGEMENT="Yes" CLIENTSTORGAE="[validStoragePlace]" in my IF you don't have it, maybe this is your problem. -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 11:07 AM To: '[EMAIL PROT

Re: [Another Way...]Checking for a record, and then deleting it

2000-06-23 Thread Justin v0.9 MacCarthy
The correct way in ANSI SQL would be something Like DELETE FROM SystemQuote WHERE CFID Exists IN ( Select CFID FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) ) Check the syntax but something like that . Justin - Original Message - From: Chris Terrebonne <[EMAIL PROTECTE

RE: [Another Way...]Checking for a record, and then deleting it

2000-06-23 Thread Chris Terrebonne
Another thing that might be causing you a problem is the CRLF after the AND in the if statement. Make sure the initial if statement is all one one line. IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)) > 0) DELETE FROM SystemQuote WHERE CFID = #CFID# ---

RE: Solaris vs Linux

2000-06-23 Thread Jeff Honken
We have the Solaris, Linux and N.T. servers all running Cold Fusion. I've found both the Solaris and Linux versions very stable and great to work with. Of course NT is NT. We utilize both MySQL and Oracle for our databases. The Oracle version for Solaris seems to more stable. The linux versio

RE: Bad cfml.exe ???

2000-06-23 Thread Jacob
I agree. But since this site was set up about 4-5 years ago, this is the way it has been. This is not a big concern now since I can still use the cfml.exe from 4.0.0. Since 4.0.1 is a small upgrade to 4.0.0, I am not going to lose very many feature with the new cfml.exe. We are talking abo

Client variables to an url and form

2000-06-23 Thread Robert Everland
Ok I appended client.urltoken to 2 urls on 2 different pages and it passes me 2 different cfids and cftokens. Why is it doing this. Do I have to put something special in my cfapplication. Anyone have any experieince with this. I am using 4.5.1, nt 4. Robert Everland III Web Developer Dix

RE: [Another Way...]Checking for a record, and then deleting it

2000-06-23 Thread Chris Terrebonne
Never tried it on Oracle. It works great on MS SQL 7. Check the Oracle docs for the correct SQL format of the statement and it should work Chris -- Original Message From: "Frédéric LeMieux"<[EMAIL PROTECTED]> Subject: RE: [Another Way...]Checking for a

Re: CFERROR

2000-06-23 Thread Guy Walker
Tom Where is it located? Guy - Original Message - From: "Tom Harwood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 23, 2000 7:44 AM Subject: Re: CFERROR > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this me

RE: Allaire Cold Fusion Template Header Size: 54 .... What's this?

2000-06-23 Thread Steve Bernard
Isn't that the same text that appears in the header of an encrypted template? Just a thought, might be way off, and even if this is the case I don't know why it would start to show up in the logs. Steve -Original Message- From: KungFusion [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23

RE: Allaire Cold Fusion Template Header Size: 54 .... What's this?

2000-06-23 Thread Dave Watts
> anybody seen this before? ... > Allaire Cold Fusion Template Header Size: 54 Allaire Cold > Fusion Template Header Size: 54 ... The message "Allaire Cold Fusion Template Header Size: ..." appears at the top of an encrypted file. It looks to me like you encrypted the same file many, many times.

Allaire Cold Fusion Template Header Size: 54 .... What's this?

2000-06-23 Thread KungFusion
anybody seen this before? I had to redo my development box at home and after installing CF4.5 I get this message on all my DirectoryIndex pages... Machine specs: W2K Server (scary!!, we'll see if it makes a week before completly crashing) CF4.5 (I haven't installed the upgrade 4.5.1 yet) SQL 7 ya

Re: CFERROR

2000-06-23 Thread Tom Harwood
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_000_01BFDD21.83AAFD46 Content-Type: text/plain; charset="iso-8859-1" Hello Michael, Have you seen our whitepaper on error handling?

RE: Stored Procedure

2000-06-23 Thread Dave Watts
> Does SQL have an equivalent to DECODE? Yes - CASE. Here's a comparison from SQL Server Books Online: Oracle: DECODE (test_value, expression1, value1 [[,expression2, value2] [...]] [,default_value] ) SQL Server: CASE test_value WHEN expression1 THEN value1 [[WHEN expression2 THEN value2] [...]

RE: Regular Expression Help

2000-06-23 Thread Steve Bernard
What you describe is one of the tenants of Fusebox, www.fusebox.org. In that case the global app code is included in the local app code for each of the sub folders. What you describe achieves much the same effect by a different name. Steve -Original Message- From: Todd Ashworth [mailto:[

Re: scheduled tasks - problems....

2000-06-23 Thread Randy Adkins
Make sure the scheduled task is running on a normal port 80 and not something else. This was one problem an Allaire Representative noted when we contracted him to visit to resolve the problem. Other than that, just make sure your settings are correct for the time to start and end the task.

RE: Bad cfml.exe ???

2000-06-23 Thread Dave Watts
> I can't help with the problem you mentioned, but I WOULD > point out that - at least when I was working with Perl - > putting executables into a public-accessable CGI directory > was regarded a really, really good way to let people execute > arbitrary code on your system. > > In other words, a b

Re: Bad cfml.exe ???

2000-06-23 Thread Jacob
points to the template directory. d:\html\template\ Everything works fine with the cfml.exe from 4.0.0. I have no problems. When I copy the cfml.exe from 4.0.1 to replace the old one, that is when I get the error. When I restore the cfml.exe from 4.0.0, it works again. At 08:17 PM 6/22/00 -

RE: Variables to append to url

2000-06-23 Thread Frédéric LeMieux
CLIENT.urlToken will append your tokens in the URL -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Friday, June 23, 2000 9:55 AM To: '[EMAIL PROTECTED]' Subject: Variables to append to url I lost the darn email with the variable to append to the url. Al

RE: [Another Way...]Checking for a record, and then deleting it

2000-06-23 Thread Frédéric LeMieux
hmmm I never saw that kind of SQL statement. So I tried, and it is not working ! The Oracle Database returns "Invalid SQL statement". Where did you see that king of statement ? Can you give me more information on how to make this king of SQL working ? -Original Message- From: Chris

Variables to append to url

2000-06-23 Thread Robert Everland
I lost the darn email with the variable to append to the url. Also do I have to put a cfid and cftoken when I submit a form? And if so is there anything special besides doing a cfid=#cfid# cftoken=#cftoken#? Robert Everland III Web Developer Dixon Ticonderoga

Re:[Another Way...]Checking for a record, and then deleting it

2000-06-23 Thread Chris Terrebonne
Or you could do it all via SQL: IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)) > 0) DELETE FROM SystemQuote WHERE CFID = #CFID# Chris -- Original Message From: "Chris Terrebonne"<[EMAIL PROTECTED]> Subject: Re:C

Re: -- help.

2000-06-23 Thread Randy Adkins
The name is the name of the query that all the directory results are dumped into. So you can use the contents of the query to search as you would a query. - Original Message - From: "miles" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 22, 2000 2:21 PM Subject: -- he

Re:Checking for a record, and then deleting it

2000-06-23 Thread Chris Terrebonne
Just test for the RecordCount... Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) DELETE FROM SystemQuote WHERE CFID = #CFID# -- Original Message From: "Chris Farrugia"<[EMAIL PROTECTED]> Subject: Check

RE: CFSTOREDPROC and Access97

2000-06-23 Thread Aidan Whitehall
Thanks for all the replies... very helpful -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -

CFOBJECT

2000-06-23 Thread Trahan, Shane
I am using CFOBJECT with some Java Classes and am having a problem.. I have seen many posts in regards to this but have yet to see anything from allaire on this issue. I am using Java Classes with CFOBJECT and I really like this feature. HOWEVER, the CFOBJECT never seems to release the action fro

RE: Regular Expression Help

2000-06-23 Thread Aidan Whitehall
> Application.cfm files are great for saving on coding and site > management and > stuff, but when you have sub folders that need their own > Application.cfm > files, they become less convenient as you have to make sure > to include any > needed code from the Application.cfms above them. Today

No Subject

2000-06-23 Thread Cristi
usubscribe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the bo

Scheduler and SQLBase.. help needed urgently

2000-06-23 Thread steven broadbent
I am trying to use CF administrator to write updates and inserts to tables on Centura SQLBase (formerly Gupta) We are using CF 4.5 The template runs fine from the browser, but won't run as a scheduled task. If I add code to send an e mail in the template, either above or below

RE: SQL Server Date comparison

2000-06-23 Thread Smith, Melanie
Oops - Correction - Sorry Phillip! Don't be ! Thanks a lot > -Original Message- > From: Smith, Melanie > Sent: Thursday, June 22, 2000 5:27 PM > To: '[EMAIL PROTECTED]' > Subject: RE: SQL Server Date comparison > > Message-ID: <[EMAIL PROTECTED]> > > Thanks Phillip and Robert.

RE: Checking for a record, and then deleting it

2000-06-23 Thread Beth Strichartz
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01BFDD0A.E847BC10 Content-Type: text/plain; charset="iso-8859-1" Hi, Test for results after the NOBLE(STAR Beth Strichartz C

RE: Tracking users through a site

2000-06-23 Thread Zachary Bedell
:~~ : From: Zachary Bedell <[EMAIL PROTECTED]> : Another possibility, if cookies are an option, would be to : continuely pass a "Click Stream" cookie back & forth to the : user. At each page request, just take the current cookie :~~

Solaris vs Linux

2000-06-23 Thread Stas Maximov
Dear Fusioners, I'm on the stage of choosing platform for application server. Candidates are Sparc Solaris and PIII-750 Linux. As I understand there is no difference what hardware is: Sparc Server of Intel P3 if the latter has enough RAM and faster Intel processor. But what about ColdFusion for t

  1   2   >