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: CFQUERY NAME=MyQuery DATASOURCE=#MyDSN# DBTYPE=ODBC { CALL sp_MyStoredProc(#Int(MyInput)#) } /CFQUERY CFDUMP VAR=#MyQuery# The results of whatever triggers run can

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 cfswitch cfcase 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

Re: Percent calculation

Peter, Here's some code that might help you get what you're after: cfset weight = 250 cfset percent_change = 107/1000 cfset final_weight = weight + (weight * percent_change) cfoutput The original weight is #weight# gramsbr The percent change is #NumberFormat(percent_change * 100, 99.9)#%br The

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

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: 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: 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

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#

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? ... !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN ... html head titleUntitled/title link rel=STYLESHEET type=text/css href=css/vacation.css /head

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 =, cfset input= [Object] ID=2031 URL=http://www.cnn.com/ OtherSrvLev=0w33a Category=31 cfset input = replace(input,[Object],,ALL) cfloop list=#input#

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

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 -

ODBC Error Code = 22008 (Datetime field overflow)

Hi Guys! Can anybody figure out why I get a date time field overflow on this: CFQUERY NAME=CheckProcedure DATASOURCE=#MyDSN# DBTYPE=ODBC SELECT * FROM sysobjects WHERE (OBJECTPROPERTY(id, N'IsProcedure') = 1) AND (name =

'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 CFSET for the datasource variable MyDSN and run this: CFSET DateTimeVarChar=#DateFormat(Now(), '-mm-dd')# #TimeFormat(Now(), 'HH:mm:ss')# CFQUERY NAME=CheckProcedure DATASOURCE=#MyDSN#

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 a href.../a. 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

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

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

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: cfmail from=#fromaddress# to=#Form.friends_email# subject=Screen Saver recommendation from #getuserdetails.name# Hello #Form.friends_name#, Please visit

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

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

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

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

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

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,

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

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

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

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

CFPROCPARAM Not Working With MSSQL

Hi Guys! Thanx to Ian Rutherford's suggestion, I have discovered the source of the problem: CFPROCPARAM TYPE=In CFSQLTYPE=CF_SQL_DATE DBVARNAME=@TimeOutDateTime VALUE=#CreateODBCDateTime(DateAdd('', 1, Now()))# As long as I create my stored procedure

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

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

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

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