Re: CF-TALK is BACK!

2001-10-21 Thread Michael Dinowitz
You did the pay pal thing and I'm very grateful for it. The problem was about 100,000 corrupted files on the machine in the mail directory. It took over 30 hours to checkdisk and fix it which is why it was down all that time. I've backed everything up and will be finding out which files have

RE: cfgrid

2001-10-21 Thread Dave Watts
i created a grid on my test server. i am running cf server 4.0. i moved it over to the main webserver (running cf server 5.0) and now i get the error messege below. it looks like it is an error with my browser..i run ie 5.0. but i viewed the grid in the same browser just pointing to the

RE: How to prevent Serialization failures?

2001-10-21 Thread Jeremy Allen
Some hints for minimizing deadlocks: Update tables in the same order anywhere they are updated. Use a low isolation level Keep transactions as short as possible, in a single batch if possible. Avoid doing a lot in a transaction that would cause it to wait in the middle or something.

cfcontent - *old classic*

2001-10-21 Thread Rich Wild
*sigh* ok, I've got this old chestnut - *again* cfcontent type=application/unknown reset=YES CFHEADER NAME=content-disposition VALUE=attachment; filename=#original_doc_name# cfcontent file=#outside_root_path##doc_name# deletefile=No type=application/unknown Trying to get a file to download

List Slow?

2001-10-21 Thread Mike Tangorre
Is the list slow today? = Michael T. Tangorre Web Applications Developer Alfred University Webteam Slave :-) [EMAIL PROTECTED] AIM: CrazyFlash4 = Friends don't let friends code before coffee!

cfcontent - *old classic*

2001-10-21 Thread Rich Wild
*sigh* ok, I've got this old chestnut - *again* cfcontent type=application/unknown reset=YES CFHEADER NAME=content-disposition VALUE=attachment; filename=#original_doc_name# cfcontent file=#outside_root_path##doc_name# deletefile=No type=application/unknown Trying to get a file to download

controlling GROUP ACCESS

2001-10-21 Thread Hamid Hossain
Hi, I have a website that produces some information. No one can see my information except registered users. I give every user a UserName and Password to access his account. I want to add a new type of registration. Some of the big organizations asked me to provide them with a special

OT: Is the CF-Talk list down?

2001-10-21 Thread Michael Wilson
Anyone else having issues receiving CF-Talk mail? Mike ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

RE: HELP! IIS 5 and Access with Netscape browser 4.75

2001-10-21 Thread Russel Madere
You may have to provide the domain for the NT user in the format DOMAIN\UserName. Russel -Original Message- From: S V [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 10:04 AM To: CF-Talk Subject: HELP! IIS 5 and Access with Netscape browser 4.75 I have removed

How do you cast a query into a structure?

2001-10-21 Thread Dave Babbitt
Hi Guys! How do I do this: StructFindKey(MyQuery, MyKey, 'ALL') Thanx ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Crazy Dates

2001-10-21 Thread Angel Stewart
CFLOOP CONDITION=DATECOMPARE (#CurrentDate#,#EndDate#) neq 1 CFOUTPUTtdinput type=text name=#Attributes.VacType#_#DateFormat(CurrentDate,'mmdd')# size = 1/td/CFOUTPUT CFSET CurrentDate = DateAdd(d,CurrentDate,1) !--- Advance current Date one day --- /CFLOOP

RE: cfgrid

2001-10-21 Thread John Anderson
Yeah make sure you are running java 1.3 as your runtime enviro, If not, go to control panels and uninstall the old version. Hit the page again, and ie will go out and find the current runtime. Or just uninstall and get the 1.3 runtime from sun. http://java.sun.com/Download5 We had the same

RE: Find unused files?

2001-10-21 Thread John Anderson
Try parsedog to find all includes, custom tags etc. May help? Originally written to find case issues when migrating code from NT enviro to unix. Open source so you may be able to modify the code to find files that arent included anywhere? http://www.aloha-webdesign.com -Original

OT: help with input type=file

2001-10-21 Thread Bruce, Rodney
Hello all Would somebody help with what I am sure is something simple I am just missing. I would like to keep the user from typing in a file name in the input Type=File and force them to use the browse button. This works input type=text onfocus = this.blur() for

Re: (OT) Using CF to create a PDF doc through XSL

2001-10-21 Thread Stephen M Aylor
Eric, Appligent, formerly Digital Applications [www.appligent.com | www.digapp.com ] develops what are considered some of the most robust, cross platform PDF generation/manipulation tools, and will even sell you their same as adobe pdf library for creating PDF will almost ALL current Adobe

Re: Where'd the list go?

2001-10-21 Thread Rayna Evans
Me either...it's been like two days for me...what's up? [EMAIL PROTECTED] 10/18/01 14:34 PM I haven't received anything from the list all day. What happened? Kristine C. Hege [EMAIL PROTECTED] Database Applications SpecialistPhone: (802) 463-2111 SoVerNet Inc.

Why Will this not export to Excel

2001-10-21 Thread Joshua Tipton
When i run this page it just pulls up the page as though cfcontent was not even there. What have I done wrong? Josh !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN cfquery name=qryGETMTHS datasource=0424_SQL_REGION_VACATION dbtype=ODBC username=

RE: Sorting a Query of a Query

2001-10-21 Thread Kevin Gilchrist
Have you confirmed that storeid is a column name in the query? You can do that by doing: cfoutput #qGetOrders.columnlist# /cfoutput It's unrelated,but you also need a comma between the two sort fields i.e. ORDER BY #orderby# , #updn# If all else fails (I know this works for Oracle, I

RE: window format

2001-10-21 Thread Costas Piliotis
Why not open the window first, and use form name=whatever target=newWindowYhatYouWillOpen -Original Message- From: Leon Greeff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 4:00 AM To: CF-Talk Subject: window format Hi there, Does anyone of you have a script that will

OT: dynamically generate page content without refresh a page

2001-10-21 Thread Mak Wing Lok
hi all, juat a question here, not so much on CF, but will like to do it on a CF page, how I can make a page dynamically generate its content without refresh a page as i have see this on some web site. for example, if i click on a button then the page will display a table with some data on it (of

RE: Help with dedicated server

2001-10-21 Thread Mark Warrick
Most ISPs that offer dedicated services also rent you all the software as well, so in most cases you don't need to buy anything. That should be included in the monthly lease. Two servers is probably going to run you between $1600-$2000 per month for a decent ISP, but you can get it much cheaper

RE: Where'd the list go?

2001-10-21 Thread Brunt, Michael
Same here. Mike Brunt Sempra Energy 213.244.5226 It's a little-known fact that the Y1K problem caused the Dark Ages. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 9:20 AM To: CF-Talk Subject: Where'd the list go? I haven't

cfabort bug

2001-10-21 Thread Greg Saunders
When I run this: cfabort showerror=hi I get the depressing error below. I'm running CF 5 on NT 2000, and have also duplicated it on CF 4.5.1 SP2 on NT 2000. All the code in the page is what you see above. What's really weird is that it appears sensitive to the string passed to

Re: client wants online credit card processing

2001-10-21 Thread Jacob
Look at http://www.linkpoint.net. We use it with Card Services. They have a custom CFX tag also. Jacob At 06:53 PM 10/17/2001 -0700, you wrote: Hi all, I've been getting deeper into cold fusion, and it's working out quite well. I have a client who wants credit card processing. But his

Read a file on the server

2001-10-21 Thread Dusty Tinashe Shoko
My files are hosted remotely on another server with my ISP! Suppose I want to read a file how would I do that if I didnt know the full path to it? I cant like say c:\inetpub\wwwroot\ you know? So now you understand, God is beautiful! Evil will never triumph! Coz TRUTH will always

Re: client wants online credit card processing

2001-10-21 Thread Matt Robertson
From a strictly technical perspective, its no different than doing it on a single-server web site. You wing over to the CF server establish your secure connection, process the card etc. and then ship the user back to the html server on a straight http connection. If you're asking how to

Re: CF-TALK is BACK!

2001-10-21 Thread Matt Robertson
Ouch. What an incredible pain. Messages are coming in very few and only sporadically, and sometimes multiple times so you're obviously still working on it. Just figured out I can read msgs on the web site archives and respond via email. My last post showed up there in 1 or 2 minutes. Good

OT - Making MP3s Easily

2001-10-21 Thread Mike Kear
Is there an easy way for someone to make a wav file into a mp3 file? I have a recording artist making a radio station ID for me, but he only has windows sound recorder. Whats the best way for me to tell this fine person of marvellous musical talent but limited computer knowledge how to make the

RE: client wants online credit card processing

2001-10-21 Thread Paris Lundis
the answer is yes... couple of things here... from their non-CF server to yours please use SSL for communications. Otherwise it is plain text and someone could pull the financials... Next there will be overhead on the transaction and overhead... be sure to build some logic into the system to

RE: IIF Help

2001-10-21 Thread Bill Holloway
I'd do a dateCompare() or a dateDiff() rather than messing with the dateFormat(). Something like: #iif( NOT dateCompare(i, qrygetusers1.we_date), DE('checked'), DE('')# HTH, Bill -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 6:22 AM

Re: How do I pipe the results of running CFML.EXE to a file?

2001-10-21 Thread Nelson Winters
I don't know if or how you could do this directly. However, if it's not possible, the following might provide a suitable solution. In your cf template (harness_tag_disqualify_user_field.cfm), embed your code in the cfsavecontent/cfsavecontent tags (Use cf_bodycontent custom tag if you're not

need help with cfsearch

2001-10-21 Thread swank
hi, Does anyone know how to achive that cool multi-page links (like on google) on a reault with CF? like this:     Previous 1 2 3 4 5 6 7 8 9 10 11 12 Next I've got my search page working, i just need a code example to the the paging working... thanks for any help!

Re: Opening file in another app using CF

2001-10-21 Thread phumes1
I have a list of files which have a href.../a around them. When a user clicks on a link, how can I have that filename open in UltraEdit or WordPad on the users PC? Has anyone done anything like this? ~~ Your ad could be here. Monies from ads go

Creating a New Session

2001-10-21 Thread Owens, Howard
I have an application where I want to have something like: Hello, Howard. Welcome to this site. (If you're not Howard, click here ). The click here cancel's the session for Howard (I've been using #structClear(session)#) After the session is clear, I want to start a new session, but this

cfflush equivalent

2001-10-21 Thread Simon Whittaker
Hello there, Does anyone know of a cfflush equivalent (eg custom tag)which would work within CF4.5. I have a very large page which cannot be cached as it is an action page which changes continuously. What I would like to be able to do is spit information out as it is processed instead of waiting

Re: Help please

2001-10-21 Thread Don Vawter
If sales id is a text value then you will need to quote session.procces_id WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = '#session.PROCESS_ID#' ) ^single quotes^ - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF-Talk [EMAIL

RE: Help please

2001-10-21 Thread Christopher Olive
you need to do a text compare. WHERE (Sales.ProductID = Products.ProductID) AND (Sales.PROCESS_ID = '#session.PROCESS_ID#') notice the tick marks. christopher olive, cio cresco technologies, inc http://www.crescotech.com -Original Message- From: Parker, Kevin [mailto:[EMAIL

RE: Help please

2001-10-21 Thread Jay Sudowski - Handy Networks LLC
If Sales.Process_ID is a text field in your Access Database, it should be enclosed in single quotes on the query. IE - CFQUERY NAME=GetAllSalesForSession DATASOURCE=#attributes.dsn# SELECT Sales.SaleDate, Sales.ProductID, Products.ProductName, Products.UnitPrice, Sales.Quantity,

RE: Help please

2001-10-21 Thread Matthew W Jones
you need to be doing a text compare if it is stored as text, ie. Sales.PROCESS_ID = '#session.PROCESS_ID#' Also, you probably shouldn't use session variables in your query, bc you should be locking ALL accesses to session variables. -Original Message- From: Parker, Kevin

RE: Where'd the list go?

2001-10-21 Thread Tammy Hong
haven't gotten anything since yesterday... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 11:20 AM To: CF-Talk Subject: Where'd the list go? I haven't received anything from the list all day. What happened? Kristine C. Hege

Re: Help please

2001-10-21 Thread Marius Milosav
If it is text in the database you have to put quotes around it. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To:

(sql) Trouble with MAX()

2001-10-21 Thread Owens, Howard
My SQL statement goes something like this: SELECT MAX(mycolumn) FROM MyTable WHERE ThisValue=ThatValue In this case, mycolumn is a FLOAT data type. There are four rows with the following values: 6.0 6.25 6.25 6.25 My select statement returns only: 6.0 I tried

RE: Help please

2001-10-21 Thread Dave Watts
Sales.PROCESS_ID is stored as a text value (even though its numeric) as Access can't store a 20 digit integer. It has to be a 20 digit integer. session.PROCESS_ID is numeric as its generated via a rand function. I can't seem to get this to execute. I've tried applying Val to

HouseOfFusion Web Sites Down?

2001-10-21 Thread John McKown
HouseOfFusion Web Sites Down? What happened yesterday? All of the HouseOfFusion sites were down. And the message board volume slowed to a trickle. John McKown, President Delaware.Net, Inc. ~~ Your ad could be here. Monies from ads go to support

OT Cant select text in IE

2001-10-21 Thread Don Vawter
I have a page in which all content is contained in div tags which are absolute positioned. There is no content between the body tags. IN IE 5.5 I am unable to select text by dragging a cursor over it. This is obviously a problem in textareas where a person should be able to highlight and cut

RE: HELP! IIS 5 and Access with Netscape browser 4.75

2001-10-21 Thread Ken Wilson
It's not a Netscape version issue. Only IE will being able to login unless you go back and check off the Basic Authentication box on the tab where you turned off Anonymous Access. Do keep in mind the caution noted there about passwords being passed in clear text. Ken -Original

RE: client wants online credit card processing

2001-10-21 Thread Matt Robertson
Thats a valid point. real time cc processing isn't cheap, and generally is the wrong answer for a small business with an unproven web business model. Most of my clients don't use it, instead doing exactly what Paris mentions. Once they can't keep up with all of the orders, then its time to

Re: IIF Help

2001-10-21 Thread James Sleeman
At 02:22 AM 10/18/2001, you wrote: Can someone Please help me with this one. #iif((dateformat(i, mm-dd-yy) eq (dateformat(qrygetusers1.we_date, mm-dd-yy)), de(checked), de())# what was with the extra quotes and brackets ? this looks better... #iif(dateformat(i, mm-dd-yy) eq

Getting Scope

2001-10-21 Thread Duane Boudreau
Hi All, I'm trying to sort my way thru a mountain of spaghetti code. Is there a way to grab the scope that CF finds a variable in? not a single variable any where is scoped :( TIA, Duane ~~ Get the mailserver that powers this list at

RE: HELP! IIS 5 and Access with Netscape browser 4.75

2001-10-21 Thread Tilbrook, Peter
I think NS has a problem sending clear text passwords (or something like that). Original Message- From: S V [mailto:[EMAIL PROTECTED]] Sent: Thursday, 18 October 2001 1:04 To: CF-Talk Subject: HELP! IIS 5 and Access with Netscape browser 4.75 I have removed Anonymous access in IIS5

problem downloading .exe file (double post)

2001-10-21 Thread Will Swain
Hi all, I am having a problem setting up a link to download a .exe file. I have a page with a link to the file like so: a href=screens_pc/screensaver.exedownload/a but when I click on it and try to download I get the following message: File download of [screensaver.exe] was not completed

RE: Sorting a Query of a Query

2001-10-21 Thread Joshua Miller
Nope, no comma ... but I did figure it out - was missing a declaration for a column in the QueryNew() line. Joshua Miller Web Development::Programming Eagle Technologies Group, Inc. www.eagletgi.com [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent:

need help with CFsearch

2001-10-21 Thread swank
hi, Does anyone know how to achive that cool multi-page links (like on google) on a reault with CF? like this:     Previous 1 2 3 4 5 6 7 8 9 10 11 12 Next I've got my search page working, i just need a code example to the the paging working... thanks for any help!

dynamically generate page content without refresh a page

2001-10-21 Thread Mak Wing Lok
hi all, juat a question here, not so much on CF, but will like to do it on a CF page, how I can make a page dynamically generate its content without refresh a page as i have see this on some web site. for example, if i click on a button then the page will display a table with some data on it

Access Question

2001-10-21 Thread Greg Luce
I haven't used access much, so I'm sure this is going to sound dumb, but can you think of a reason that I get 0 records for this query when I can see there's a record in the db with a date of 10/18/2001? SELECT* FROM messages WHERE message_date = #attributes.datebox# The debugging

RE: cfgrid

2001-10-21 Thread Costas Piliotis
There's been a couple of threads regarding this. A macromedia tech claimed that you should move to Flash instead of Java. Go figure. Try installing JRE 1.3 http://java.sun.com/products/plugin/ Me thinks that macromedia wrote the new cfgrid control to conform with Sun's Java and forgot to

Re Help with Dedicated Server

2001-10-21 Thread Brunt, Michael
I don't know what happened to my original reply 1 1/2 days ago but here it is as it should have been. This is a difficult one to answer as things like people's opinions about hosters, who's good-bad and why etc get in the way. I spent some time working as a consultant with Allaire so I saw a

Re: Building a answer key

2001-10-21 Thread Aaron Rouse
Actually I found a solution to this shortly after sending the email(a couple of days ago). I just added onto my existing structure. So I have a .Value which equals the value of the input tag, such us Yes. Then I have in my structure a .Yes = 0; and a .No = 0; If I were code those zeros as the

Percent calculation

2001-10-21 Thread Tilbrook, Peter
Hi there! I need to find the percentage of a value in ColdFusion but have been getting inconsistent results. eg: Initial Weight: 250 grams Weight Change: 10.7% Final Weight (would be 250 grams plus 10.7%): ?? and also for subtracting (weight reduction), eg: Initial Weight: 250 grams Weight

RE: CF_Query as an array

2001-10-21 Thread Pete Freitag
The reason you are getting that error is because MAX is an aggregate function meaning that it takes all the results of the query and calculates one value for the column. You are trying to select multiple rows, but also have one of the columns be single value. It won't let you do this. One

Re: CF_Query as an array

2001-10-21 Thread Nelson Winters
I may be mistaken, but from your error message, it looks like you haven't put Apartment_ID in a GROUP BY clause. It would be helpful if you actually post your query. With regards to the query really being an array, that's almost true. It's really a structure of arrays. This means that you can

CF and Excel

2001-10-21 Thread Scott Mulholland
Is there a way to read in an Excel worksheet into a cf app, possibly through com, without using excel as the datasource? Thanks, Scott ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: String manipulation

2001-10-21 Thread James Sleeman
See GetDirectoryFromPath() and GetFileFromPath() At 04:16 AM 10/19/2001, you wrote: Hi, I would like to split the following line into two strings. The length or contents of the string can vary depending on the directory structure. Basically, I need to extract the directory path into one

Re: SQL Server Enterprise Manager alternatives?

2001-10-21 Thread James Sleeman
Nothing hard about adding tables the Manual Way. Open up query analyzer and repeat after me... CREATE TABLE MyTable ( MyPrimaryField INTEGER NOT NULL PRIMARY KEY, MyFirstFieldVARCHAR(25), MySecondField DATETIME,

OT: Shall be order

2001-10-21 Thread Michael Lugassy
Please help me with that SQL script, I'm hopeless :( I have a product table which has: product_cat (identity, int, i.e=4) and product_list (which is a $$ delimited list of products, i.e - mouse_wheel$$screen$$keyboard) - don't ask... about 400,000 rows. I have a info table that looks like this:

Regular Expression

2001-10-21 Thread Michael Lugassy
This is not neccesarly have to be done with coldfusion's REReplace but anyhow, I'm trying to come up with a regular expression that will help me turn this: [Object] ID=2031 URL=http://www.cnn.com/ OtherSrvLev=0w33a Category=31 Into: http://www.cnn.com/ Overall, I'm trying to find a way to

Re: doublepost: odbc error

2001-10-21 Thread James Sleeman
At 12:16 AM 10/19/2001, you wrote: What does this mean? Message:ODBC Error Code = S1000 (General error) Error Code: -1808 SQL State: S1000 Detail: [Microsoft][ODBC Microsoft Access Driver] Not enough space on disk. My guess... there is not

Re: String manipulation

2001-10-21 Thread Justin Scott
There are functions available to do this for you... getdirectoryfrompath(path) - Extracts a the full directory (including \) from a full path and filename. getfilefrompath(path) - Extracts the filename from a full path and filename. -Justin Scott, Lead Developer Sceiron Internet Services,

dynamically generate page content without refresh a page

2001-10-21 Thread Mak Wing Lok
hi all, juat a question here, not so much on CF, but will like to do it on a CF page, how I can make a page dynamically generate its content without refresh a page as i have see this on some web site. for example, if i click on a button then the page will display a table with some data on it

RE: Test Hacking a web site.

2001-10-21 Thread Jeremy Allen
Yes but this was a simple contrived example at how a social engineering example would work. In reality it would be a little more complex but social engineering is a way of hacking that combines social interaction with technology to form a 'best of breed' sort of system infiltration. It is all