RE: How to clear local cache when users logout

2009-09-25 Thread Imperial, Robert

I tend wrap content in a stuffsend them
back to login type deal, no need to clear anything client side
(even if you could).

Bob 
-Original Message-
From: Nathan Chen [mailto:nathan.c...@cu.edu] 
Sent: Thursday, September 24, 2009 6:54 PM
To: cf-talk
Subject: How to clear local cache when users logout


All:

 

How do you clear users'  local cache after they log out and the session
variable is cleared? I can clear the session on the server, but if users
click the Back button, they can still get back and that's not what I
want. This must have been discussed but I guess I missed.

 

Nathan Chen





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326628
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Any mail going around...I'm not getting any... :o(

2008-10-03 Thread Imperial, Robert
Snail's pace here //


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 03, 2008 12:31 PM
To: cf-talk
Subject: RE: Any mail going around...I'm not getting any... :o(

Does traffic seem really slow today?



> -Original Message-
> From: Yves Arsenault [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 03, 2008 12:09 PM
> To: cf-talk
> Subject: Re: Any mail going around...I'm not getting any... :o(
> 
> I got your message.
> ;-)
> 
> Yves Arsenault





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313435
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: cfmail woes

2008-08-28 Thread Imperial, Robert
That took care of it! Thanks Justin it's working like a charm, off to
storm the castle now ;)

Bob
 

-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 28, 2008 9:59 AM
To: CF-Talk
Subject: Re: cfmail woes

> "Error","scheduler-2","08/27/08","13:39:08",,"Invalid Addresses;
nested
> exception is: class javax.mail.SendFailedException: 550 5.7.1 Unable
to
> relay for [EMAIL PROTECTED] "

It sounds as though your SMTP server isn't configured to relay messages 
for your ColdFusion server.  If this SMTP relay is ONLY used by your web

server, then I would set the connection controls to only allow 
connections from localhost (127.0.0.1), and then set the relay 
restrictions to "allow all" (since only the localhost can connect, relay

control becomes a moot point).  These settings are under the access tab 
in the SMTP properties in the IIS configuration.


-Justin Scott




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311715
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: cfmail woes

2008-08-28 Thread Imperial, Robert
Yes sir ;)


Hello World!
 


-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, August 28, 2008 9:58 AM
To: CF-Talk
Subject: Re: cfmail woes

Have you confirmed that the e-mail contains a proper e-mail address in 
the "TO" property? That is what I see in the error message.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311714
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfmail woes

2008-08-28 Thread Imperial, Robert
Hi folks,

 

I've run into an issue I cannot seem to resolve with sending mail via
cfmail here. I'm trying to send a barebones test email and keep running
into the following after initially setting the mail server to 127.0.0.1
and then setting it to the actual IP 

 

>From the cf mail log-

Invalid Addresses; nested exception is: class
javax.mail.SendFailedException: 550 5.7.1 Unable to relay for
[EMAIL PROTECTED]

And of course it drops it into the undeliverable folder never to be seen
again. 

 

>From the exception log-

"Error","scheduler-2","08/27/08","13:39:08",,"Invalid Addresses; nested
exception is: class javax.mail.SendFailedException: 550 5.7.1 Unable to
relay for [EMAIL PROTECTED] "

 

This is on a windows box running:

IIS 

Windows 2003  Standard

ColdFusion MX 7,0,2,142559 Standard

 

This has baffled me since I have the same setup on a 2nd box that has no
issue with sending emails and hasn't had for the past year or so.

 

Any help or light to be shed would be greatly appreciated.

 

Bob



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311709
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Need help with restoring from .bak

2008-07-03 Thread Imperial, Robert
Ok it's late in the day and I've obviously overlooked the obvious here
:) I was trying to run this query via https and this box had a selSSL
cert installed on it, which is what was giving me trouble connecting via
the Enterprise Manager. I'll deal with that later but at least the
RESTORE ran under http. 

Thanks again Jochem and Dave.

By the way Dave, I haven't had the chance to work with anything I picked
up in your class last week. Cam back and as always after a week away,
the to-do-list was a mile long.

Bob Imperial

-Original Message-----
From: Imperial, Robert [mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 03, 2008 3:52 PM
To: CF-Talk
Subject: RE: Need help with restoring from .bak

Thanks for the heads up Dave, now that I've take care of that I have a
new error. 
Progress I guess :) now I get  [Macromedia][SQLServer JDBC
Driver][SQLServer]Exclusive access could not be obtained because the
database is in use.  I'm a little confused here, is the reference in the
error to the db I am attempting use to initiate the connection with, or
the db I am trying to restore? As far as I can see the db I'm using here
to initiate the connection is not being used by anybody at the moment.

Bob






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308558
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Need help with restoring from .bak

2008-07-03 Thread Imperial, Robert
Thanks for the heads up Dave, now that I've take care of that I have a
new error. 
Progress I guess :) now I get  [Macromedia][SQLServer JDBC
Driver][SQLServer]Exclusive access could not be obtained because the
database is in use.  I'm a little confused here, is the reference in the
error to the db I am attempting use to initiate the connection with, or
the db I am trying to restore? As far as I can see the db I'm using here
to initiate the connection is not being used by anybody at the moment.

Bob




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308556
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Need help with restoring from .bak

2008-07-03 Thread Imperial, Robert
Hi folks,

 

Scrambling here trying to restore a db on a ms sql server and cannot
connect with Enterprise Manager (another story). Is there a command line
utility out there anywhere that will let me restore a db from a .bak
file on a windows box? Or is there a way to do this from a CF query? TIA

 

Bob



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308539
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


cfmail and pgp

2008-06-09 Thread Imperial, Robert
Hello folks,

 

I am in need of some help here with something I've not had the
opportunity to deal with before and was hoping somebody on list has had
the experience of using pgp along with emails on the fly using cfmail?
The extent of my experience with pgp is limited to using it as an
individual and well outside of realm of cf, mainly just to see if I
could get it to work for me and that was long ago. FYI these emails
would be going out to probably no more than 25-30 people and would need
to be something the end users could handle doing w/o a lot of
difficulty. Please feel free to email me off list if you'd like on this.

 

Thanks!

 

Bob 

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


digital signatures

2008-05-28 Thread Imperial, Robert
Hello folks,

 

I've been working on some simple utilities here at work to convert what
people have been doing with paper, yes, that's right some people are
still using paper. Now that I've converted a ton of paper to web forms
and created pdfs for them along with emails, they've asked me about
providing a way to allow them to digitally sign these documents. I'm not
sure where to start with all of this and how complicated a task this
might be so I thought I'd ask here to see if anyone has any suggestions
on where to begin with this. "Them" are doctors just to clarify a little
so I'll be dealing hippa regs on this as well. Any insights, suggestions
or feed-back  that you can offer on where to start for someone that's
never done this before would be greatly appreciated.

 

Thanks!

 

Bob Imperial

Department of Medicine

043B Macnider Hall, CB 7005

UNC at Chapel Hill Chapel Hill, NC 27599

Phone: (919) 843-6151

 

 "Programming is 10% science, 35% ingenuity and 65% getting the
ingenuity to work with the science."

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306153
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Open Source CF Shopping Carts

2008-04-11 Thread Imperial, Robert
There's Cartweaver but I've only had experience with CFWebstore and have
had great service and support from Mary Jo on it.
My 2 cents.

Bob

-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 11, 2008 12:05 PM
To: CF-Talk
Subject: Re: Open Source CF Shopping Carts

Thanks.  Just to clarify, I'm not looking for FREE Open Source shopping
carts.  I'm looking for shopping carts built in ColdFusion where the
unencrypted source code is available to someone to modify and customize
it.  I'm willing to pay for the shopping cart.  I just wanted to clarify
as "open source" means more than one thing nowadays.

Any others besides CFWEBStore ?

Dave 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303210
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: OT - JS Date picker

2008-02-20 Thread Imperial, Robert
Not sure if this will work for you but have you tried
http://www.yxscripts.com/xc2/index.html ?

Bob

-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 20, 2008 11:49 AM
To: CF-Talk
Subject: OT - JS Date picker

I need a date picker. The CIO is super picky and wants it "just so" and
doesn't know (or care) what hoops I have to go though to do it. I got
one
that works (and meets his requirements):

http://www.oakcitygraphics.com/jquery/clockpick/ClockPick.cfm

But it needs the Doc Type declared to work in IE.

Ex:
http://www.w3.org/TR/html4/loose.dtd";>

There is no doc type declared in our intranet (not my doing btw). So
declaring the Doc Type renders the drop down nav bars useless and totaly
mucks up the design in both browsers (of course it does).

Does anyone have anything on hand that you have used? Yes I googled it
and
it is slim pickins

The main requirements are: free, that it looks decent, and that the user
not
have to click anything to close the time picker widget after selecting
the
time. Which was his main objection to this one (Which is very nice):
http://www.nogray.com/js_tools.php

And yes I tried to make it do so but my JS chops aren't all that
advanced
and I don't want to muck around with the source code.

TIA,
Gerald




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299430
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Good CF Developer learning ActionScript?

2007-08-23 Thread Imperial, Robert
Try learnflash.com they have it covered I think, everything from
learning for point-click commandos to coders.

B

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

Sent: Thursday, August 23, 2007 11:20 AM
To: CF-Talk
Subject: Good CF Developer learning ActionScript?

Anyone know of any high quality "learn as you go" DVD based training for
Actionscript?

Thanks

D



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286961
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Can't see the trees for the forest here ...

2007-07-10 Thread Imperial, Robert
Hello folks,
 
I am in need of some enlightenment here with an issue that has me
stumped. I have a from validation script that I use in several forms in
a small personnel editor I built. In one particular page this script is
not firing and I cannot for the life of me see why it's not. The one
thing that seems to somehow play a part in this scenario is a session
variable I set at login: SESSION.Auth.UserRole, this gets set to 1 or 2.
1 is a basic rights level, 2 is full rights. The only place I actually
use this is where I display a set of links to various functions within
the editor. Below is the basic set up for this:
 

Change my password Change password
now.
Add a New Web Administrator Add New 
View All
Registered IP Addresses View in web or as an Excel file.
All Faculty Members Add New Edit/Delete
All Administative Staff Add New Edit/Delete
All Nursing Staff Add New Edit/Delete

 Faculty
Members  
 Add New  
Edit/Delete 
Administrative
Personnel  
Add New  
Edit/Delete
Nursing
Staff  
Add New  
Edit/Delete

 
The actions for addadminpersonnel and addnursing load the same form with
some conditional stuff for preloading the form if the action is "edit"
 yada yada yada.
 
My script is in the head as shown below:
 
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>


Add Member
  
function validateForm() {
var allOk = true;
var errorString = "The following are required
fields:\n";

// require first name
if (!document.addmember.First_Name.value) {
allOk = false;
errorString += "\n- First Name";
}
// require last name
if (!document.addmember.Last_Name.value) {
allOk = false;
errorString += "\n- Last Name";
}   

// require a division before processing the
request
if (!document.addmember.Division.selectedIndex >
0) {
allOk = false;
errorString += "\n- Division";
}
// validate their email
var validEmail =
/^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/;
if
(!validEmail.test(document.addmember.Email.value)) {
allOk = false;
errorString += "\n- Email Address";
}   
if (!allOk)   
{
alert(errorString);
return false;
} 
 
return allOk;
}




 
Trimmed this down but I think you get the idea ...



   



 
 



This just blows past my validation script and can't see why as this same
script is working just fine setup in pretty much the same way, just a
much larger form. Like I mentioned before, the only thing that seems to
be related is SESSION.Auth.UserRole. Email me off list if needed.
 
TIA!
 
Bob Imperial
DOM-IS Web Developer
Department of Medicine
125 Macnider Hall, CB 7005
UNC at Chapel Hill Chapel Hill, NC 27599
Phone: (919) 843-6151
 


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283426
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: video gallery / audio gallery?

2007-06-29 Thread Imperial, Robert
Sounds like something you could probably do with SlideShow Pro
http://www.slideshowpro.net/


Bob Imperial
DOM-IS Web Developer
Department of Medicine
125 Macnider Hall, CB 7005
UNC at Chapel Hill Chapel Hill, NC 27599
Phone: (919) 843-6151
-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 29, 2007 9:41 AM
To: CF-Talk
Subject: video gallery / audio gallery?

I am working on a site for a small church that would like to broacast
video excerpts of the pastor's sermons and audio excerpts of the churh
chior.

Does any one know of a "video display gallery" of the likes of cnn.com,
video.yahoo.com, or youTube.  I do not need a full application, I just
need something that I can feed an xml file.  

Likewise I am looking for a similar audio gallery that supports mp3
files.

Dwayne



~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282547
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: retrieve mac address with CF?

2007-06-25 Thread Imperial, Robert
Thanks Bobby ...this could be useful for me down the road if this works
for snagging info from remote boxes, I'll putz around with it and see
what I can break.

Bob

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 25, 2007 12:39 PM
To: CF-Talk
Subject: RE: retrieve mac address with CF?

You can cfexecute 'arp -a' to get a nice formatted output of macs and
their
IPs. If the IP isn't listed, ping it first, then do 'arp -a' and extract
the
MAC/IP

...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-----Original Message-
From: Imperial, Robert [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 25, 2007 10:39 AM
To: CF-Talk
Subject: RE: retrieve mac address with CF?

 thanks for the response, seems my boss didn't phrase his question
correctly . he was asking about retrieving IP addresses from Macs,
which
we already do ;)

Thanks!

Bob

-Original Message-
From: John Blayter [mailto:[EMAIL PROTECTED]
Sent: Monday, June 25, 2007 10:21 AM
To: CF-Talk
Subject: Re: retrieve mac address with CF?

If you want to get the MAC address of the server it looks like you can
get
to it through some  java.

http://forum.java.sun.com/thread.jspa?threadID=245711


On 6/25/07, Bob Imperial <[EMAIL PROTECTED]> wrote:
> Good morning folks ... or at least it's morning here ;) I was just 
> asked if I could retrieve mac addresses via coldfusion and
have no idea. Is this possible with cf, if so or if someone knows of a
good
reference to point me in the direction of, I would appreciate it
greatly.
>
> Thanks! Bob
>
> 







~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: retrieve mac address with CF?

2007-06-25 Thread Imperial, Robert
 thanks for the response, seems my boss didn't phrase his question
correctly . he was asking about retrieving IP addresses from Macs,
which we already do ;)

Thanks!

Bob

-Original Message-
From: John Blayter [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 25, 2007 10:21 AM
To: CF-Talk
Subject: Re: retrieve mac address with CF?

If you want to get the MAC address of the server it looks like you can
get to it through some  java.

http://forum.java.sun.com/thread.jspa?threadID=245711


On 6/25/07, Bob Imperial <[EMAIL PROTECTED]> wrote:
> Good morning folks ... or at least it's morning here ;)
> I was just asked if I could retrieve mac addresses via coldfusion and
have no idea. Is this possible with cf, if so or if someone knows of a
good reference to point me in the direction of, I would appreciate it
greatly.
>
> Thanks! Bob
>
> 



~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282050
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


need help with updating date field

2007-05-30 Thread Imperial, Robert
I know this is probably obvious to most of you here, but I have an error
on an update statement that I need some enlightenment on please. I'm
using MSSQL2k, CFMX7 and I have an insert statement that works fine
using "#createODBCdate(Now())#" but my update bombs on it?? Here's my
update:
 
UPDATE AdminPersonnel
SET First_Name = '#form.First_Name#',
Last_Name = '#form.Last_Name#',
MI = '#form.MI#',
Division = '#form.division#',
Degree = '#form.Degree#',
Title = '#form.Title#',
Email = '#form.Email#',
Phone = '#form.Phone#',
Fax = '#form.Fax#'
Date = '#createODBCdate(Now())#',
IPAddress = '#CGI.REMOTE_ADDR#'
WHERE ID = #form.ID#
 
And here is the error

Error Executing Database Query. 

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL
Server Driver][SQL Server]Line 1: Incorrect syntax near 'Date'.   The
error occurred in D:\WebNew\domis\admin\actUpdateAdminPersonnel.cfm:
line 16: line 1
Called from D:\WebNew\index.cfm: line 17
14 :   Date = '#createODBCdate(Now())#',
15 :   IPAddress = '#CGI.REMOTE_ADDR#'
16 :WHERE ID = #form.ID#
17 : 
 
Awaiting your enlightenment ;)
 
 
Bob 
 


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279585
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Edit excel on line

2007-05-22 Thread Imperial, Robert
Does anyone out there know of a cf app out there that would allow
editing of excel files on line like the product found at
http://www.xcellery.com/ ? Preferably an open source version? Does
anybody out there have any experience with this application and if so,
what are your pros/cons? 
 
Thanks!
 
Bob Imperial
DOM-IS Webmaster
Department of Medicine
125 Macnider Hall, CB 7005
UNC at Chapel Hill Chapel Hill, NC 27599
 


~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278879
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4