Re: OT: C# equivalent of CFDUMP

2004-01-09 Thread Thomas Chiverton
On Thursday 08 Jan 2004 20:20 pm, Mauricio Giraldo wrote: printf :-) isn't printf kind of more like cfoutput? I dunno. I write CFML :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole

Re: CFC Constructor Question

2004-01-09 Thread Thomas Chiverton
On Thursday 08 Jan 2004 21:38 pm, Paul Hastings wrote: oh my. i hope you're not using dw to handle your i81n text. We're not even thinking about i18n *yet* - it's almost certain to become more important in the future though. Gonna be fun tearing our app apart to seperate the presentation and

RE: CFDJ isn't exactly kicking bootay

2004-01-09 Thread Simon Horwith
my apologies.I thought we were talking about the merits of CFDJ Content in comparison to book content. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List

RE: CFDJ isn't exactly kicking bootay

2004-01-09 Thread Simon Horwith
I wouldn't consider builder.com more reputable... in fact most, not all, websites are less reputable in my opnion.Anyone can create a site, where as a publication in print requires more organization and support.I don't know what their subscription numbers are, so I can't comment on that.I think

Re: CFDJ isn't exactly kicking bootay

2004-01-09 Thread Thomas Chiverton
On Friday 09 Jan 2004 10:17 am, Simon Horwith wrote: websites are less reputable in my opnion.Anyone can create a site, where But only some web sites will attract the 'names' in the community - either as writers, reviewers or just plain members. Those will be the reputable ones. -- Tom

RE: Map with Co-ordinates

2004-01-09 Thread Hugo Ahlenius
ESRI http://www.esri.com Runs a commercial web-service (pay per use) that you can use for this. http://www.esri.com/software/arcwebservices/index.html - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP

RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE?

2004-01-09 Thread Mike Townend
you havnt mentioned which version of CF you are using...If you are using 6.1 then there is a new function ReleaseObject() that may be of use to you. HTH -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 9, 2004 01:15 To: CF-Talk Subject: RE:

Get URL

2004-01-09 Thread Shahzad.Butt
How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Get URL

2004-01-09 Thread Adrian Lynch
Dump CGI to see what's available to use. cfdump var=#CGI# / Ade :O) -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:15 To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm

RE: Get URL

2004-01-09 Thread Craig Dudley
Try cfdump var=#cgi# The variables you want is in there somewhere. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:15 To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in

RE: Get URL

2004-01-09 Thread Mike Townend
theres a nifty little UDF on cflib called GetCurrentURL() which should do the job HTH -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, January 9, 2004 12:15 To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in

Selecting TOP N

2004-01-09 Thread Tangorre, Michael
I can't seem to get SELECT TOP 10 to work when the query below has a DISTINCT clause in it... Can anyone shed some light into my confusion. SELECT DISTINCT(T.opportunityId), O.title, O.createDate, U.firstName, U.lastName, U.emailAddress FROM tbl_ta T INNER JOIN tbl_opportunity O ON

RE: Selecting TOP N

2004-01-09 Thread Philip Arnold
Which way round are you putting it in? This works: SELECT DISTINCT TOP 10 fields -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 8:00 AM To: CF-Talk Subject: Selecting TOP N I can't seem to get SELECT TOP 10 to work when the

RE: Selecting TOP N

2004-01-09 Thread Tangorre, Michael
Thanks! I just had it backwards Mike -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 8:10 AM To: CF-Talk Subject: RE: Selecting TOP N Which way round are you putting it in? This works: SELECT DISTINCT TOP 10 fields

RE: Selecting TOP N

2004-01-09 Thread Spectrum WebDesign
If MySQL SELECT yourfieds FROM yourtable LIMIT 10 Cheers - Original Message - From: Philip Arnold [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 08:09:43 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: RE: Selecting TOP N Which way round are you putting it in? This works: SELECT DISTINCT TOP 10

Re: CFLAP Record Limit?

2004-01-09 Thread Ron Eberhard
I have had no problems with queries in excess of 10,000.Occasionally, the LDAP server is slow and can cause a time-out problem, so I increase the time-out to accommodate these times. Chris Stoner wrote: I am accessing our active directory via cfldap and it currently only returns 1000 records

Re:Generating PDFs in CF

2004-01-09 Thread Spectrum Web
After test this example IE show me the error: if (year 1000) --^ Blank spaces don't permitted. Maybe !DOCTYPE ITEXT SYSTEM http://www.lowagie.com/iText/itext.dtd There is a sweet Java-based open source project that generates PDF based on an XML input format.The project is called

OT Automated FTP Account Creation

2004-01-09 Thread Greg Luce
I'm trying to find a way to programmatically create FTP accounts in apache. Anyone have any experience with this? Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Get URL

2004-01-09 Thread Bill Grover
Try cfset lcFullURL = Trim(CGI.path_info) cfif CGI.query_string NEQ cfset lcFullURL = lcFullURL ? CGI.query_string /cfif This is the code I use in a my login page.Basically I do it so a user can bookmark any page on the site (i.e. www.euservices.com/myeu/somepage.cfm?parm=somevalue) and if

insert multiple drop down list selects into access

2004-01-09 Thread Tim Laureska
Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple

RE: insert multiple drop down list selects into access

2004-01-09 Thread Burns, John
I don't think access would handle a comma delimited list as a number. You'd have to change the field type to some sort of string, or loop over the form input and insert each one individually (depending on your database design). John Burns -Original Message- From: Tim Laureska

java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Bryan F. Hogan
I know very little about Java but can't this function have a try/catch block and if invalid just recreate the session? I'm getting Session is invalid null errors. The tagcontext is the application tag on line 5. Here is a copy of it. cfapplication name=thename clientmanagement=yes

Re: OT Automated FTP Account Creation

2004-01-09 Thread Thomas Chiverton
On Friday 09 Jan 2004 13:49 pm, Greg Luce wrote: FTP accounts in apache. Anyone have any experience with this? Apache is a web server, it doesn't know anything about FTP services. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger

Re: CFContent Excel design woes

2004-01-09 Thread Deanna Schneider
Hatton, Did you miss the post where someone said that Office 97 ignores stylesheets? -d - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 08, 2004 8:08 AM Subject: RE: CFContent Excel design woes I still have not been

Re: insert multiple drop down list selects into access

2004-01-09 Thread Pete Ruckelshaus
You'll have to loop over that field and do multiple inserts.Something like: cfloop list=#FORM.cat_no# cfquery to insert /cfloop Pete Tim Laureska wrote: Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly

RE: insert multiple drop down list selects into access

2004-01-09 Thread Pascal Peters
Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht-

Images - store in DB or filesystem?

2004-01-09 Thread Spectrum WebDesign
What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects

RE: Images - store in DB or filesystem?

2004-01-09 Thread MILAN MUSHRAN
Change the datatype from number to text. From: Spectrum WebDesign [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Images - store in DB or filesystem? Date: Fri, 09 Jan 2004 12:15:21 -0300 What's the in/out for image storage? Bynary in BLOB database fields or

Re: Images - store in DB or filesystem?

2004-01-09 Thread Charlie Griefer
I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Bryan Stevenson
Thanks Matt...I was starting to think that might be the problem. BTWwhat did you mean by this line??: Be aware that there are only solutions besides iText for PDF generation. Did you mean other solutions? Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge

RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Bryan Stevenson
Another good point.The Secure FTP app was set to auto, but I'll try again with binary forced Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] -

RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Nathan Strutz
You can put a try/catch around your cfapplication tag. There's a good chance it will pick up these error conditions, then send yourself an html email with cfdumps of #session#, #variables# and #getpagecontext().getcfscopes()# to find out what's going on. -nathan strutz -Original Message-

RE: OT Automated FTP Account Creation

2004-01-09 Thread Greg Luce
OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. I guess by your reply Apache is different? Greg -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:22 AM To: CF-Talk

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Matt Liotta
Did you mean other solutions? I did mean other, sorry for the typo. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

single IP issue

2004-01-09 Thread Bryan Stevenson
Hey All, I hadatrial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions

Re: Images - store in DB or filesystem?

2004-01-09 Thread Jochem van Dieten
Spectrum WebDesign wrote: What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? Depends on usage pattern. What do you intend to do with your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays

RE: OT Automated FTP Account Creation

2004-01-09 Thread Dave Watts
OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. I guess by your reply Apache is different? IIS is quite a bit more than a web server. It consists of web, FTP and mail servers, depending on what you choose to install. Apache, on

RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Bryan F. Hogan
I haven't added the try/catch around the cfapplication tag. But my error reporting has all of this information already. All I know is the the checkSessionValidity() should have a try/catch around it if possible. Everything else is fine. There is no explanation in the scopes about why. Just that

Re: OT Automated FTP Account Creation

2004-01-09 Thread Thomas Chiverton
On Friday 09 Jan 2004 15:49 pm, Greg Luce wrote: OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. | don't think it does, though on Windows they may share a control panel or two. I guess by your reply Apache is different? It's a

Re: single IP issue

2004-01-09 Thread Thomas Chiverton
On Friday 09 Jan 2004 15:49 pm, Bryan Stevenson wrote: I know I've seen this one discussed here beforeany thoughts? Run Squid as a front-end proxy ? Sorry, I'm in a not-being-very-helpful-in-fact-slightly-silly mood 'cause it's nearly the weekend ;-) -- Tom Chiverton Advanced ColdFusion

Re: Images - store in DB or filesystem?

2004-01-09 Thread Matt Liotta
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Matt Liotta
Another good point.  The Secure FTP app was set to auto, but I'll try again with binary forced Again, I would check out SCP as it is much nicer for transferring files and more secure too. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Images - store in DB or filesystem?

2004-01-09 Thread Spectrum WebDesign
Web sites but i'm looking for up-to-date technology... If stored images in BLOB fields is very slow why Oracle/SQL Server/Informix/MySQL companies agrees with that technology?? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 16:53:55 +0100 To: CF-Talk

Re: Images - store in DB or filesystem?

2004-01-09 Thread Charlie Griefer
Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the

RE: single IP issue

2004-01-09 Thread Dave Watts
I had a trial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Bryan Stevenson
Yeah I have Putty and use it for root level access (nice and secure)still learning my Linux commands...but scp is a command right?secure copy? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]

Re: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Ubqtous
Bryan, On 1/9/2004 at 10:53, you wrote: BFH There is no explanation in the scopes about BFH why. Just that the IllegalStateException exception was returned as far BFH as I can tell. I was getting a similar error (session is invalid) on an MX6.1/Linux server. The only thing that made it go away

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Bryan Stevenson
ooo...hey...if you can fire me the command to grab an entire local dir and scp it up I'd be one happy camper ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]

RE: Images - store in DB or filesystem?

2004-01-09 Thread Dave Watts
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. I would agree with you about the choice of the word bloat, but relational databases are hardly designed for storing binary data - it's purely an afterthought at most. Relational

RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Bryan F. Hogan
You know it may be. I do have that checked. I'll uncheck it and see if I get the errors again. When they popup mysteriously. Thanks -Original Message- From: Ubqtous [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:06 AM To: CF-Talk Subject: Re:

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Matt Liotta
SCP is secure copy or the cp command over SSH. Putty has a program named pscp or Putty SCP that will allow you to do SCP from the command-line on Windows. For example, transferring a file is as follows. prompt pscp somefile.txt [EMAIL PROTECTED]:/home/username/somefile.txt -Matt On Jan 9,

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Matt Liotta
prompt pscp -r somedir [EMAIL PROTECTED]:/home/username/somedir -Matt On Jan 9, 2004, at 11:04 AM, Bryan Stevenson wrote: ooo...hey...if you can fire me the command to grab an entire local dir and scp it up I'd be one happy camper ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce

Re: iText (was Re: CFDJ isn't exactly kicking bootay)

2004-01-09 Thread Dave Carabetta
Yeah I have Putty and use it for root level access (nice and secure)still learning my Linux commands...but scp is a command right? secure copy? scp usage: scp -v localfile.txt [EMAIL PROTECTED]:localfile.txt You will then be prompted for a password and it will copy the file out there for

Re: single IP issue

2004-01-09 Thread Bryan Stevenson
Thanks Dave...on it now ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com

CFFTP - file transferred is 0 bytes?

2004-01-09 Thread Bosky, Dave
I'm using CFFTP on CFMX to transfer a text file from one server to another. The file gets created on the remote machine but contains no data and is 0 bytes in length. Anything I can check out that might be causing this to happen? CFFTP action="" connection=#CONN1# stoponerror=no

Re: Images - store in DB or filesystem?

2004-01-09 Thread Jochem van Dieten
Spectrum WebDesign wrote: Web sites That is not exactly what I would call a usage pattern. What *xactly* do you intent to do with the images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

RE: OT Automated FTP Account Creation

2004-01-09 Thread Greg Luce
Well, I'm not sure what version of Redhat exactly we're running. I know it's different from our dev server and production servers. I'm not able to find out right now what FTP server we're using. Perhaps we can just talk theoretically. Is it something CF can call with a COM object? Are there FTP

Re: Images - store in DB or filesystem?

2004-01-09 Thread Spectrum WebDesign
Jochem web page display... img src=""> - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 17:19:20 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Images - store in DB or filesystem? Spectrum WebDesign wrote: Web sites That is not exactly what I

Re: Images - store in DB or filesystem?

2004-01-09 Thread Jochem van Dieten
Spectrum WebDesign wrote: web page display... img src=""> How many images? How big are the images? How often will they be displayed? Will they be cached somewhere? How often will there be images inserted/updated? Do you intent to use the images in relational queries? Do you want to search

RE: OT Automated FTP Account Creation

2004-01-09 Thread Burns, John
It depends on the ftp server.Some FTP servers keep the users and permissions in text files.If that's the case, you can automate user creation by modifying that text file.There may be ways to add users other ways through calling functions of the FTP server software but you'd have to rely on the

RE: OT Automated FTP Account Creation

2004-01-09 Thread Dave Watts
Well, I'm not sure what version of Redhat exactly we're running. I know it's different from our dev server and production servers. I'm not able to find out right now what FTP server we're using. Perhaps we can just talk theoretically. Is it something CF can call with a COM object? Are

RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Dave Watts
I was getting a similar error (session is invalid) on an MX6.1/Linux server. The only thing that made it go away was disabling Use J2EE session variables in CF Administrator. I have no idea if that's the actual cause or just a coincidence, but I haven't seen the error since. You should be

TSQL problem

2004-01-09 Thread Shahzad.Butt
I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: single IP issue

2004-01-09 Thread Bryan Stevenson
hmmm...the 2 license.properties files (JRun and CFMX) do not have an allowedIP setting. The issue acts like CFMX is allowing only our office IP to connect to this server (anybody outside our office cannot connectand the server is outside our office).The error the rest of the world gets is:

RE: TSQL problem

2004-01-09 Thread Philip Arnold
Why not use DateAdd()? What's in the . - that could make a big difference -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM To: CF-Talk Subject: TSQL problem I know its coldfusion group but I wonder if someone can help me

Login Roles

2004-01-09 Thread Ian Skinner
When using the CFlogin function of MX 6.x is there a way to get all the roles of a given user outside of the cflogin/cflogin block?I know you can use IsUserInRole() to get a Boolean of if a user is in a given role, but, especially when debugging, it would often be useful to see the all roles to

RE: verity search

2004-01-09 Thread Tim Do
The query returns 10 more than the cfsearch did. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 9:16 PM To: CF-Talk Subject: RE: verity search thanks Dave... I removed the extensions and double checked the query.. it does return

RE: OT Automated FTP Account Creation

2004-01-09 Thread Greg Luce
Thanks John. Hopefully it's the case of the text file. Sounds painless. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:36 AM To: CF-Talk Subject: RE: OT Automated FTP Account Creation It depends on the ftp server.Some FTP servers keep

RE: Login Roles

2004-01-09 Thread Raymond Camden
There is no way of doing this. However, if your roles come from a UDF or CFC, you can just call it again. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE?

2004-01-09 Thread Shawn Grover
Unfortunately, my client hasn't updated his server yet, and likely won't for some time.So, we are stuck running CFMX 6.0. Further research indicates I have two choices left to me - either do the work client-side or remove the Office 2000 objects, and use the Office XP objects.Both cases leave a

RE: TSQL problem

2004-01-09 Thread Shahzad.Butt
Following is the query SELECT DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)), CHARINDEX('.', CAST(PanelLocalDT AS Decimal(10,5)))-1) AS INT), '1899-12-30') + ' ' + 'CAST(((CaST(RIGHT(CONVERT(decimal(10,4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -

RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Bryan F. Hogan
Thanks Dave! I wonder why they have the web.xml configuration for the timeout set to automatically discover the max timeout set in the administrator. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:51 AM To: CF-Talk Subject: RE:

CF_HTML2PDF3

2004-01-09 Thread kelly
I am using this tag to create pdfs. A user enters how many cards they want to print, it then goes to a page that outputs some user information and a graphic. My problem is is that sometimes the graphic appears and sometimes it doesn't. Very random. It seems to work if I completely close acrobat

RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Bryan F. Hogan
Don't have. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:03 PM To: CF-Talk Subject: RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379) Thanks Dave!

RE: verity search

2004-01-09 Thread Adrian Lynch
Is the value for the key attribute unique? Ade -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 16:47 To: CF-Talk Subject: RE: verity search The query returns 10 more than the cfsearch did. -Original Message- From: Dave Watts [mailto:[EMAIL

Re: single IP issue

2004-01-09 Thread Bryan Stevenson
it's definately the single IP issue...confirmed it in the logsbut no allowedIP settng in the license.properties files.now the fun beginswhere oh where is the dang setting ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t.

Re: Images - store in DB or filesystem?

2004-01-09 Thread Paul Hastings
cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. well the GIS industry builds uses huge monster thumping databases.

RE: verity search

2004-01-09 Thread Tim Do
that was it!I changed the cfindex key to the primary key in the table .. purged and updated the verity.. works great!Thanks so much! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:18 AM To: CF-Talk Subject: RE: verity search Is the value

RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
Hmm, that's odd I thought that was what InterMedia from Oracle was all about? Of course they just scratched the surface in 8i but in 9i it's all about that. I can search binary data, both clob and blob. They can be stored within the database structure itself or in separate files associated with

RE: TSQL problem

2004-01-09 Thread Philip Arnold
Why is the second one in quotes? You shouldn't need to do that as long as you convert things right There's too much there for me to break out easily without seeing the data, but if I'm right, you're trying to make a date/time calculated out of a date/time field, right? -Original

RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's just data. Regardless if you go this route the space differences would be minimal. If you want I can post the JSP code we use for retrieval? Stephen E. Schuster

RE: TSQL problem

2004-01-09 Thread Dave Watts
I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest You can use sp_executesql, EXECUTE, or EXEC, depending on which version of SQL Server you're using.

RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert into the blob. To retrieve we have this JSP page. This allows a direct stream read to the browser and does not write the file to the system and then attempt to read it. But we have code that does that as well if you need

Re: single IP issue

2004-01-09 Thread Ryan Mitchell
Now, I could be wrong, but if you have installed the enterprise version as the on top of jrun4 option (as 2 licence files makes me think u have) then I don¹t imagine u can revert to the CFMX standard stand alone version, I would imagine you have to do a fresh install? On 9/1/04 5:21 pm, Bryan

Re: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Ubqtous
Dave, On 1/9/2004 at 11:51, you wrote: DW You should be able to make that error go away by limiting the DW duration of J2EE session variables within web.xml: DW http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid DW =669435#2598160 Thanks! I had stopped checking that

Re: single IP issue

2004-01-09 Thread Bryan Stevenson
chatting with MM nowwe'll see ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com

RE: single IP issue

2004-01-09 Thread Dave Watts
Now, I could be wrong, but if you have installed the enterprise version as the on top of jrun4 option (as 2 licence files makes me think u have) then I don¹t imagine u can revert to the CFMX standard stand alone version, I would imagine you have to do a fresh install? I think you're

Need help with MS Word Automation

2004-01-09 Thread Shawn Grover
I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once

RE: Need help with MS Word Automation

2004-01-09 Thread Schuster, Steven
You are opening a can of worms...I don't recommend this.. But try www.cfcomet.com http://www.cfcomet.com/ And use OWA or whatever it is called. It is for Office and makes '00 and '03 automation much easier. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101

RE: Images - store in DB or filesystem?

2004-01-09 Thread Dave Jones
Stephen, I'd be interested in seeing the JSP code, particularly the part about streaming the output. Thanks, Dave Jones NetEffect At 12:39 PM 1/9/04 -0500, you wrote: Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's

Re: single IP issue

2004-01-09 Thread Bryan Stevenson
Hmmm...and when I asked this list before everybody thought it wouldn't be a problemg. Well I'll ask this...if it's the Standard versioncan I still access and use Java like so? cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); /cfscript

Re: single IP issue

2004-01-09 Thread kelly
Is it possible to format pdf EXACTLY as you have formatted it in the html/cd tag? As the code loops, the images/text don't align evenly in each row. I am trying to format pdf for Avery business card paper. Here is my code: CF_HTML2PDF3 myHTMLDOC=D:\Program Files\HTMLDOC\htmldoc.exe

oops...cf_html2pdf question.

2004-01-09 Thread kelly
sorry about my last post. Is it possible to format pdf EXACTLY as you have formatted it in the html/cd tag? As the code loops, the images/text don't align evenly in each row. I am trying to format pdf for Avery business card paper. Here is my code: CF_HTML2PDF3 myHTMLDOC=D:\Program

RE: Need help with MS Word Automation

2004-01-09 Thread Samuel R. Neff
If you're open to options other than automation, take a look at these links: Integrating ColdFusion with Microsoft Office: Breezo and examples http://www.rewindlife.com/archives/000118.cfm Serving Word http://www.rewindlife.com/archives/32.cfm HTH, Sam

RE: single IP issue

2004-01-09 Thread Dave Watts
Hmmm...and when I asked this list before everybody thought it wouldn't be a problemg. When you asked before, you said you'd installed CFMX Enterprise, without saying you'd installed CFMX on J2EE, I think. Well I'll ask this...if it's the Standard versioncan I still access and

Re: single IP issue

2004-01-09 Thread Bryan Stevenson
Thanks Dave, Yeah you may be right about what I said I installed.There was some confusion at the time because the ISP installed CF on a colo box and wasn't 100% sure which option was selected ;-) Oh well...as long as I can run that code I'm laughin Cheers Bryan Stevenson B.Comm. VP Director

RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)

2004-01-09 Thread Dave Watts
Are there any specific advantages to using J2EE sessions? Yes, although for most CF developers they probably aren't significant. By default, J2EE session cookies are a bit more obtuse than those used by traditional CF session management, and they're actually session cookies - they don't persist

Re: Images - store in DB or filesystem?

2004-01-09 Thread Kevin Graeme
Do you have a rough estimate of the performance difference of using this streamed output via JSP compared to just doing a standard CF query? -Kevin - Original Message - From: Schuster, Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM

RE: Images - store in DB or filesystem?

2004-01-09 Thread Schuster, Steven
I did, let me dig around and see if I can find them. I already posted the JSP code, here is the CF equivalent that writes the file to disk and lets you view them. This doesn't take any more space either as the cfcontent tag simply deletes the file after it has streamed to the browser. cfparam

  1   2   >