Re: How to auto generate images?
http://www.flashgap.com/ HTH I have never used this product so i have no idea if this will work for your application. At 10:45 AM 10/23/2001 -0700, you wrote: >Does anyone know how to dynamically generate formatted images. > >i.e. > >1. A client fills out a web site banner name in a form and presses submit >2. That automatically generates the banner image, with formatting rules like >drop shadow, etc. > >I know Macromedia Generator does this, but its a very heavy price to pay in >terms of server load and up front costs. > >Are there any other good alternatives? > ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Access Question
It's doing the math. It thinks 10/18/2001 is 10 divided by 18 divided by 2001. Use single quotes. Bryan Love Macromedia Certified Professional Internet Application Developer / Database Analyst Telecommunication Systems Inc. [EMAIL PROTECTED] "What father would hesitate to say 'if there must be trouble let it be in my day, that my child may have peace'?" - Thomas Paine, An American Crisis -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 5:43 PM To: CF-Talk Subject: Access Question 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 shows: SQL = SELECT * FROM messages WHERE message_date = 10/18/2001 If I use single quotes around #attributes.datebox# it gives me an error saying "datatype mismatch". ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular Expression
> 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/ > You could easily do it with two statements. I don't think CF allows for retrieving matches to regular expressions like perl. Assuming the text above in in a variable called text, I would just do: ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF 4 to CF 5 CFContent Causes Windows NT Error Number 5
I have images on another server via a mapped drive being served to customers via CFContent. It worked with 4.0 but 5 causes Windows Nt Error Number 5. Any ideas? I must quit and come back tomorrow. Thanks, Jeff ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Not Working With MSSQL
Hi Guys! Thanx to Ian Rutherford's suggestion, I have discovered the source of the problem: As long as I create my stored procedure without it, and not try to pass the CF version of the ODBC date setting as an input variable, I can call my stored procedure using the tag. But... that kind of defeats the purpose. So, how do I get a date value in there? Thanx Dave ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Access Question
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 shows: SQL = SELECT * FROM messages WHERE message_date = 10/18/2001 If I use single quotes around #attributes.datebox# it gives me an error saying "datatype mismatch". ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access Default values
You can set the default value of a field in an Access table's design view. - Original Message - From: Joseph Thompson To: CF-Talk Sent: Sunday, October 07, 2001 10:58 AM Subject: Re: Access Default values Creating tables and fields isn't the problem per se. The trick is setting "Default" values. Like setting an INT field that defaults to say 16 instead of 0. I can't find a Default() that works in Access. (not counting ADO) ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamically generate page content without refresh a page
> 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 course without > refresing the whole page again). is it possible? if yes, how > technical is it? You can use JavaScript to do this. You can't use CF, by itself. You can rewrite parts of a page using DHTML, or all of a page using document.write. If you need to exchange data with the server, you can use frames or "pipes": http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GIFAs Pipe/ (originally pointed out to the list by Dick Applebaum, if I recall correctly) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Enterprise Manager alternatives?
Embarcaderro rapidsql is okay... www.embarcaderro.com Perhaps you could try query analyzer? CREATE TABLE works pretty good too... -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 10:06 AM To: CF-Talk Subject: RE: SQL Server Enterprise Manager alternatives? Info Assistant from http://www.resultdata.com is excellent. David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 9:58 PM To: CF-Talk Subject: SQL Server Enterprise Manager alternatives? Hi all, I know this has come up in the past, and I was wondering if anyone had found anything to replace SQL Server's Enterprise Manager? I have a client on crappy shared hosting, and their SQL Server machine has about half a million databases on it (exaggeration). Enterprise Manager hangs/timesout trying to get a list of everything on the server. I need to add some tables and I would really like to avoid doing it the hard/manual way. Thanks, Kay. ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Excel
Have you looked here? http://www.cfcomet.com EC -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 5:19 PM To: CF-Talk Subject: CF and Excel 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 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to auto generate images?
Does anyone know how to dynamically generate formatted images. i.e. 1. A client fills out a web site banner name in a form and presses submit 2. That automatically generates the banner image, with formatting rules like drop shadow, etc. I know Macromedia Generator does this, but its a very heavy price to pay in terms of server load and up front costs. Are there any other good alternatives? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IIF Help
> 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(""))#
#iif((dateformat(i, "mm-dd-yy") eq (dateformat(qrygetusers1.we_date,
"mm-dd-yy")), de("checked"), de(""))#
With the quotes around the dateformat, you're comparing the text rather than
the evaluated functions, which will never be equal
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
> -Original Message-
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> Sent: 17 October 2001 13:22
> To: CF-Talk
> Subject: IIF Help
>
>
>
~~
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfmail problem: double post
Hi all, Having a strange problem with cfmail that I persoanlly haven't noticed before. I am sending out an email like so: Hello #Form.friends_name#, Please visit www.blahdiblah.co.uk to download a screensaver Thanks Contact details more contact details Now most of the time these mails are going through just fine, but occasionally someone gets one that looks like this: Hello #Form.friends_name#,Please visitwww.blahdiblah.co.uk to download a screensaverThanksContact detailsmore contact details ie with no formatting at all. Can anyone suggest why this might be happening Many Thanks Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: controlling GROUP ACCESS
First of all, giving everyone the same username and password is a mistake. Nobody should EVER share the same login information. Next, you're going to need to figure out a way to track usage. The easiest way is to track by IP address, however if everyone is behind a proxy or firewall, that won't work. Another way to track them is by using cookies. You associate the cookie on their machine with their user info. Whatever means you use to track the user, next you need a table to track concurrent sessions. As soon as a user logs in, you make an entry to the usage table. When the number of users reaches 20, you would prevent the next user from logging in. Another thing your probably going to want to do is implement an "auto logout" feature like many of the online banking sites have. This will prevent somebody from walking away from their desk for extended periods - thereby causing the next person to not be able to login because potentially all the concurrent sessions would be in use. If you are hosting the code itself on your own server, you will be able to protect it and enforce the usage rules. However, if you give it to the client and let them host it under their control, well, then nothing really would stop them cracking open the code to eliminate all your security measures. ---mark -Original Message- From: Hamid Hossain [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 3:00 AM To: CF-Talk Subject: controlling GROUP ACCESS 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 registration. They want to buy 20 licences for 20 PCs for a year. All the 20 PCs should login with the same username and password at the same time. Or I may provide them with a software that makes them already logged in. I need any suggestion about this kind of GROUP ACCESS to a website. How to sell a number of licences to a customer. Regards, Hamid Hossain ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: dynamically generate page content without refresh a page
Take a look at this page: http://www.vboston.com/DepressedPress/Content/ColdFusion/Essays/GIFAsPipe/ It may be able to give you some ideas. C. Hatton Humphrey, Developer Fisher, Towne & Associates 716-839-2141 x336 [EMAIL PROTECTED] > -Original Message- > From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 10:39 PM > To: CF-Talk > Subject: dynamically generate page content without refresh a page > > > 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 course without refresing > the whole > page again). is it possible? if yes, how technical is it? > > thanks > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Excel
fairly low tech approach but I have set up an access database that links to an excel spreadsheet that can be freely uploaded by site administrator. The access database has the DSN mapping. I use it so he can upload many new records at once, and is used as part of an import process. Eric Dawson From: Scott Mulholland <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: CF and Excel Date: Wed, 17 Oct 2001 17:18:40 -0400 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 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: dynamically generate page content without refresh a page
I believe you can to that utilizing frames within a fusebox scenario. check the last couple of chapters in the fusebox methodology book at secreteagents.com. - Original Message - From: "Mak Wing Lok" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 18, 2001 7:38 PM Subject: dynamically generate page content without refresh a page > 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 course without refresing the whole > page again). is it possible? if yes, how technical is it? > > thanks > > ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to auto generate images?
Does anyone know how to dynamically generate formatted images. i.e. 1. A client fills out a web site banner name in a form and presses submit 2. That automatically generates the banner image, with formatting rules like drop shadow, etc. I know Macromedia Generator does this, but its a very heavy price to pay in terms of server load and up front costs. Are there any other good alternatives? ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Running app from server...HELP!
Hi, I've posted this before but I'm at a dead end. I have no idea how to go about this. I'm listing files in a directory on my server. All files are wrapped with What I want to happen is when a user clicks on a file I want that file opened in an editor on the client PC (not the server). In my case, UltraEdit. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC Error Code = 22008 (Datetime field overflow)
Hi Guys! Can anybody figure out why I get a date time field overflow on this: SELECT * FROM sysobjects WHERE (OBJECTPROPERTY(id, N'IsProcedure') = 1) AND (name = N'sp_UpdateTimeOut') CREATE PROCEDURE sp_UpdateTimeOut @UserID [int] ,@TimeOutVarChar [varchar] AS SET @RowsEffected = 0 UPDATE Time_Actual SET Time_Out = CAST(@TimeOutVarChar AS datetime) WHERE Users_ID = @UserID AND Time_Out IS NULL Thanx Dave ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
'2001-10-23 06:18:10' Is Being Converted to "2"
Hi Guys!
Can anybody figure out why this stored procedure is converting my varchar to
"2"? Write your own for the datasource variable MyDSN and run this:
SELECT COUNT(*)
FROM sysobjects
WHERE
(OBJECTPROPERTY(id, N'IsProcedure') = 1)
AND (name = N'sp_Test')
DROP PROCEDURE sp_Test
CREATE PROCEDURE sp_Test
@DateTimeVarChar [varchar]
AS
SELECT @DateTimeVarChar
-- DECLARE @Test_Assignment [datetime]
-- SET @Test_Assignment = CAST(@DateTimeVarChar AS datetime)
{ CALL sp_Test('#DateTimeVarChar#') }
Thanx
Dave
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slow File Uploads For Netscape/Mac user
Hello all, Has anyone experienced the following problem: While using the Mac a user of ours has experienced significantly increased file upload times as compared to their uploading of similar files on a pc. If anyone has found a resolution or other info about this please respond. - Bill - ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Next Page - Previous Page
Anyone have any links to sites explaining how to make a report that spans several pages (Next/Previous page navigation)? I've seen them posted here before a long time ago. ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Regular Expression
Try treating the text a list with a cr/lf delimeter, and then tret each list item as another list with a delimeter of "=", http://www.cnn.com/ OtherSrvLev=0w33a Category=31 "> setvariable( listgetat(i,1,"=") , listgetat(i,2,"=") ); #url# -- In this case, you now have the variables ID,URL,OtherSrvLev & Category which can all be used. HTH Craig. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: 19 October 2001 02:50 To: CF-Talk Subject: Regular Expression 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 remove EVERYTHING (numeric/alpha/special/+New lines) from "[Object]" over to "URL=", keep everything from URL= to the New line and again, remove everything from OtherSrvLev to the end. So I will be left with a URL alone. Anyone? Michael. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Why Will this not export to Excel
> When i run this page it just pulls up the page as though > cfcontent was not even there. What have I done wrong? > ... > > ... > > > Untitled > > > > > > If you include HTML tags, or any other undesired stuff, before your CFCONTENT tag, it's not going to work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: related select boxes
Steven this is what i do with the 2 selects related. notice the default values. if nothing is selected then pre-select US & Ohio if this is an update then there would be values & i just grab the values in the else's statement to default1="#rs_Update.Country_Code_ID#" default2="#rs_Update.State_Code_ID#" hth -paul -paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Enterprise Manager alternatives?
Info Assistant from http://www.resultdata.com is excellent. David L. Boardwine Senior Analyst Ohio Department of Development/ITO Phone (614) 752-4431 [EMAIL PROTECTED] From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 9:58 PM To: CF-Talk Subject: SQL Server Enterprise Manager alternatives? Hi all, I know this has come up in the past, and I was wondering if anyone had found anything to replace SQL Server's Enterprise Manager? I have a client on crappy shared hosting, and their SQL Server machine has about half a million databases on it (exaggeration). Enterprise Manager hangs/timesout trying to get a list of everything on the server. I need to add some tables and I would really like to avoid doing it the hard/manual way. Thanks, Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problem downloading .exe file (double post)
> 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: > > download > > but when I click on it and try to download I get the > following message: > > File download of [screensaver.exe] was not completed > succesfully. Server has internal error > > IS this a mime type problem? If so, can anyone tell me the > mime type for exe files? I don't think it's a MIME problem. Instead, I think it's that your web server is executing the file, instead of simply passing it back to the browser. If you're using IIS, right-click on the directory within the IIS MMC, and set it to only read or execute scripts. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Getting Trigger Results Back Through CFPROCS
Hi Guys!
Has anybody been able to figure out how to get trigger results back through
cfprocs? If I do something like this:
{ CALL sp_MyStoredProc(#Int(MyInput)#) }
The results of whatever triggers run can be seen in the dump - like Audit_ID
will be there if their is some audit trail being run on the table. If I do
something like this:
How do I see the results of whatever triggers run? What if I know that
Audit_ID is the name of the field/column? Note that Audit_ID is never
mentioned in sp_MyStoredProc - it's the output of a separate trigger.
Thanx
Dave
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Percent calculation
Peter, Here's some code that might help you get what you're after: The original weight is #weight# grams The percent change is #NumberFormat(percent_change * 100, "99.9")#% The percent change reflects an increase, therefore the final weight is #NumberFormat(final_weight,"999.99")# The original weight is #weight# grams The percent change is #NumberFormat(percent_change * 100, "99.9")#% The percent change reflects a decrease, therefore the final weight is #NumberFormat(final_weight,"999.99")# Dina - Original Message - From: Tilbrook, Peter To: CF-Talk Sent: Thursday, October 18, 2001 8:02 PM Subject: Percent calculation 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 Change: -15.4% Final Weight (would be 250 grams minus 15.4%): ?? Thanks! PT ** This transmission is intended only for the use of the addressee(s) and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you have received this transmission in error, please notify the ANZFA IT helpdesk prior to deleting all copies of this transmission together with any attachments. ANZFA helpdesk: E-mail: [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hiding files - cfhttp & cfcontent
Hi, I can't see how this is possible. On my remote server, I have the file w.cfm - eventually it will have a load of statements, calling url.ca which will in turn load the text file containing a WDDX packet. For now though, I'm just working with one text file, wddx.txt. Here's how w.cfm looks at the moment: On my local server, my custom tag wants to use to call w.cfm such as www.myserver.com/w.cfm?ca=wddx.txt This should, in theory, load wddx.txt but it doesn't. The custom tag spews out an XML parsing error, presumabely because it isn't loading any/required WDDX packet. Stumped. Any advice appreciated. I'm doing it this way, because I don't want the filenames to be known by the end user. Will -- http://www.localbounty.com - free local and national advertising ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Enterprise Manager alternatives?
Try Embarcadaro's DBArtisan or Rapid SQL programs http://www.embarcadero.com ..they both have several good features. SQL Programmer 2001 by BMC Software http://www.bmc.com/database/sqlprogrammerfree/ is another good product. I don't know if these will help solve your problem though, but they are a good alternative to Enterprise Manager. Brian Ferrigno Senior Web Developer 516.626.2100 x311 http://www.vandis.com -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 9:58 PM To: CF-Talk Subject: SQL Server Enterprise Manager alternatives? Hi all, I know this has come up in the past, and I was wondering if anyone had found anything to replace SQL Server's Enterprise Manager? I have a client on crappy shared hosting, and their SQL Server machine has about half a million databases on it (exaggeration). Enterprise Manager hangs/timesout trying to get a list of everything on the server. I need to add some tables and I would really like to avoid doing it the hard/manual way. Thanks, Kay. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
