edit Word document on browser?

2002-03-14 Thread Mak Wing Lok
is there a way to edit a Word document on a web browser where the Word doc would be retrieve and save directly into the server? __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/

RE: Truncating Logs

2002-03-14 Thread Ian Tait
http://www.sqlserverfaq.com Has some useful info on this subject. One thing I did recently was to back up the database, detatch the db files using sp_detatch_db, and reattach just the data file using sp_attach_db, forcing it to create a new log file. This was for a log file that just would not

Re: CustomTags?

2002-03-14 Thread Randy Adkins
Here is what they sent me. - Original Message - From: laszlo [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 8:33 PM Subject: Re: CustomTags? Same problem here, any post will be appreciated laszlo Randy Adkins wrote: Does anyone have a copy of

RE: CF Certification

2002-03-14 Thread Kevan . Windle
So when you say CF MX is that just an update to CF5 or is it NEO? -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: 14 March 2002 04:40 To: CF-Talk Subject: Re: CF Certification Actually, I was at the CFUG New York meeting the other night and Michael Dinowitz

Re: CF Certification

2002-03-14 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: So when you say CF MX is that just an update to CF5 or is it NEO? ColdFusion MX: The Application Formerly Known As Neo Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20

RE: Truncating Logs

2002-03-14 Thread Bill Grover
I picked up the following from SQL Magazine. This code if run in the Query Analyzer window will eventually shrink the log file. Make sure you are in the right database before executing the statements. I've had to let mine run for a minute or so, but if you monitor the logfile size eventually

RE: SQL help please

2002-03-14 Thread Bill Grover
I'm not sure you can do it with a simple select statement. If I understand what you want you want to look at each entry and whenever the paycatid field changes report the first start and last end dates for that id. You will probably need to create and run a stored procedure. Your SP will need

Re: SCRIPT

2002-03-14 Thread phumes1
Hi, How can I incorporate the history.back into the SCRIPT code below so it runs automatically? a href=javascript:history.back()font class=navlinks[Back]nbsp;/font/a script language=JavaScript type=text/javascript !-- window.location=http://localhost/test1/test2/test3/index.cfm;;

Image and DB Solution needed

2002-03-14 Thread Andrew Scott
I have a small problem; I need to pull images out of a DB. Now if I use the following code nothing is appearing. cfcontent type=image/GIF reset=yescfoutput#query.test#/cfoutput Now if I remove the cfoutputs and use the file attribute it will display an image, so my questioning thinks that there

RE: Image and DB Solution needed

2002-03-14 Thread Ken Wilson
Is there truly a critical need to store the actual image in the DB instead of just the name of the image? Ken -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:11 AM To: CF-Talk Subject: Image and DB Solution needed I have a small

Independent Consultant/Programmer Sample Contract

2002-03-14 Thread Dave Hannum
Almost weekly, somebody comes on the list and asks for a sample contract for doing freelance/independent work. Here is something to look at. If you go to TechRepbulic.com and join (free), you can get access to lots of downloadable white papers, example apps, Excel and Word documents, and

RE: Image and DB Solution needed

2002-03-14 Thread Sicular, Alexander
How are you storing the image in the db? As binary or string? Either way cfcontent needs a file, so take query.test, write to file and then read the file back as action=readbinary then use that var in the cfoutput. Some code I use cfquery name=getBinaryData datasource=#dsn# SELECT binaryString,

RE: Image and DB Solution needed

2002-03-14 Thread Andrew Scott
Yes, the web page space is not enough and the DB has the space to expand. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 March 2002 12:18 AM To: CF-Talk Subject: RE: Image and DB Solution needed Is there truly a critical need to store the actual image

RE: Fusebox pros and cons

2002-03-14 Thread Bill Killillay
As does everyone, I'd guess. I prefer using stored procedures for that. Once you place your database access logic in the database itself, there's little to be gained from saving a three-line CF file in a separate location. Unless you have to make changes to that stored procedure and now you

RE: CF_ThreeSelectsRelated

2002-03-14 Thread James Taavon
Do you manage the database? Can you put some data in the NULL field. That is what I did for mine. I inserted N/A in all NULL fields which for me is BOX 3. I always have a value for BOX 12 for what I am doing? My question is how can you have a value in BOX 3 that is related to a NULL value in BOX

Re: Independent Consultant/Programmer Sample Contract

2002-03-14 Thread Paul Giesenhagen
In addition try http://www.quickforms.com Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder v2.0 - Original Message - From: Dave Hannum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 7:19 AM Subject: Independent

Re: edit Word document on browser?

2002-03-14 Thread Dave Carabetta
is there a way to edit a Word document on a web browser where the Word doc would be retrieve and save directly into the server? If you're using Win2K and IIS 5, you can use the WebDAV utility to do this. Check out msdn.microsoft.com for more info on how to implement it, but it's not that

XML editor?

2002-03-14 Thread laszlo
Gents, I have a SAX-based java prog, which reads an XML file and writes to a MySQL tables. Then I have a CF app editing the MySQL tables (web-enabled, bunch of users acn add/delete/change data). After all the editing, I want to re-create the XML from the MySQL database. Questions: - Is there a

RE: Image and DB Solution needed

2002-03-14 Thread Andrew Scott
How do you clean up the images, this is a concern as the web space is limited. And uuid files would mean more disk space. So there must be a way to do this with out saving as a temp file first! Can anyone explain to me why this doesn't work, so that I can find a solution to this? -Original

RE: Dynamic Images

2002-03-14 Thread Haggerty, Michael A.
This is an interesting post. How is the placement of the round images determined in the first place? I would assume, since they are place dynamically, there is some logic you would be using to determine their placement which could be emulated in a UDF or something. That way whatever you use to

Re: CFSET

2002-03-14 Thread phumes1
Hi, I have the following CFSET's in my index. cfset DosPath = ListDeleteAt(URL.filename, ListLen(URL.filename, \),\) cfset FileNameOnly = ListLast(URL.filename, \) cfset sr1 = replace(LCase(DosPath),d:\books\,,ALL) cfset sr2 = ListFirst(sr1, \) cfset MyFontDir = \other\fontload\#auth#\#sr2#

RE: CFSET

2002-03-14 Thread Pascal Peters
Are you sure you are passing the filename on the URL : index.cfm?filename=d%3A%5Cbooks%5Ctest%5Cfile%2Eext . It is just saying that URL.filename doesn't exist. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: donderdag 14 maart 2002 15:29 To: CF-Talk Subject: Re: CFSET

RE: CFSET

2002-03-14 Thread Andrew Scott
You could try cfoutput#url.Filename#/cfoutput Before this to see if the variable actually exist's if this also errors then url.filename doesn't actually exist. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Friday, 15 March 2002 1:29 AM To: CF-Talk Subject: Re:

RE: CFSET

2002-03-14 Thread Haggerty, Michael A.
URL.Filename? Are you sure you don't mean CGI.scipt_name? M -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 9:29 AM To: CF-Talk Subject: Re: CFSET Hi, I have the following CFSET's in my index. cfset DosPath = ListDeleteAt(URL.filename,

RE: SQL help please

2002-03-14 Thread Kwang Suh
Yeah, I ended up using a cursor to do it. Thanks Bill. -Original Message- From: Bill Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 6:01 AM To: CF-Talk Subject: RE: SQL help please I'm not sure you can do it with a simple select statement. If I understand what you

RE: Fusebox pros and cons

2002-03-14 Thread savan . thongvanh
not being contradictory here but, how does too much client envolment hinder a well written application? most of the clients i've worked with don't have the CF skillset in the organization so I've been able to keep everything pretty clean, as our individual interpretations of clean go. I would

RE: Fusebox pros and cons

2002-03-14 Thread Mark A. Kruger - CFG
I think he meant that clients often expand and dilute development methodology by adding features and functions to an application after the dev plan is locked down... you know, your client comes in during the beta and says hey you know I was thinking, what if we... Personally, the best

RE: Fusebox pros and cons

2002-03-14 Thread Ian Lurie
That's easy: When a client starts a sentence with 'Wouldn't it be easy to...', and you've already completed requirements collection, and done all the stuff you're supposed to to prevent scope creep, but know that you're in for a fight anyway. That's 'destructive' input. -Original

RE: SCRIPT

2002-03-14 Thread Steve Oliver
script language=JavaScript type=text/javascript !-- window.history.back(); //-- /script _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent:

HELP NEEDED

2002-03-14 Thread Allan Pichler
I have a little problem guys and i need your help! I've made a little perl script that runs every 5 minutes, it checks a MySQL DB to see if there's any mailjobs scheduled that needs to be executed. If there's jobs in queue it runs another perl script with the id of the mailjob as an argument.

RE: Fusebox pros and cons

2002-03-14 Thread Jeffry Houser
I was being sarcastic, meaning that clients will always come up with some foolish idea. From a recent discussion here, having the local weather (Relative to home office) taking up 90% of the Corporate Intranet homepage when the bulk of the users are from a remote location. I believe your

Re: CFPOP unknown exception condition

2002-03-14 Thread Owen Leonard
Have you installed the CFPOP Hot fix? TechNote 20371 has full list of hot fixes. Deb Thanks for the suggestion. I tried installing it on my development machine and the problem still persists there. I'll install it on the server just for kicks, but if anyone has any other ideas I'd really

RE: SCRIPT

2002-03-14 Thread phumes1
Thanks. Can I also have it do a refresh of the previous page once I go back? At 10:16 AM 3/14/2002 -0500, you wrote: script language=JavaScript type=text/javascript !-- window.history.back(); //-- /script _ steve oliver senior internet developer atnet

RE: Fusebox pros and cons

2002-03-14 Thread savan . thongvanh
i read ya. :-) Ian Lurie [EMAIL PROTECTED] on 03/14/2002 09:09:25 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Fusebox pros and cons That's easy: When a client starts a sentence with 'Wouldn't it be easy to...', and you've already completed

RE: Fusebox pros and cons

2002-03-14 Thread savan . thongvanh
you got my point exactly. Jeffry Houser [EMAIL PROTECTED] on 03/14/2002 09:17:26 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Fusebox pros and cons I was being sarcastic, meaning that clients will always come up with some foolish idea. From

OT: live.allaire.com -- where did it go?

2002-03-14 Thread Carlisle, Eric
I have a project coming up where I'll need to keyframe movies to push html pages. I remember Allaire had a really great tutorial site that did this. Does this still exist at Macromedia? Can anyone point me at any online resources / books for accomplishing the same technology? Thanks :)

RE: SCRIPT

2002-03-14 Thread Steve Oliver
If you need a refresh, then use the window.location.href='' That will navigate to the page so you won't have to reload. If you need it to go back to any number of pages, just use some CF script ... window.location.href='cfoutput#CGI.http_referer#/cfoutput'; /script

RE: SCRIPT

2002-03-14 Thread savan . thongvanh
just a reminder that using the back() method of the history object is going to go back one step at the top level document of the window. if you have a frameset you might inadvertently take a user off your site. if you have problems w/ that, and as i personally prefer, try using history.go(-1)

RE: SCRIPT

2002-03-14 Thread Ramin Surya
You can try: opener.location.reload() -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 9:29 AM To: CF-Talk Subject: RE: SCRIPT Thanks. Can I also have it do a refresh of the previous page once I go back? At 10:16 AM 3/14/2002 -0500, you

RE: SCRIPT

2002-03-14 Thread phumes1
Thats it! Thanks At 10:34 AM 3/14/2002 -0500, you wrote: If you need a refresh, then use the window.location.href='' That will navigate to the page so you won't have to reload. If you need it to go back to any number of pages, just use some CF script ...

Re: HELP NEEDED

2002-03-14 Thread savan . thongvanh
i love cf and all but since you're doing all that perl stuff wouldn't it be easier to accomplish that w/ a perl cgi script? c'anyone tell i'm having a slow day? :P Allan Pichler [EMAIL PROTECTED] on 03/14/2002 09:24:14 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED]

OT: Outlook mail folders

2002-03-14 Thread Jeff Beer
Does anyone have info on how to read e-mail messages in an Outlook mail folder? I need to parse through about 1200 messages and really don't want to do them all manually! The string parsing is simple - I just need to figure out how to access the mail. TIA! Jeff

RE: Outlook mail folders

2002-03-14 Thread Rich Wild
best place for this: http://www.cfcomet.com -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: 14 March 2002 15:48 To: CF-Talk Subject: OT: Outlook mail folders Does anyone have info on how to read e-mail messages in an Outlook mail folder? I need to parse

RE: HELP NEEDED

2002-03-14 Thread Allan Pichler
I just find it way easier to do the interface part in cf! :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 4:47 PM To: CF-Talk Subject: Re: HELP NEEDED i love cf and all but since you're doing all that perl stuff wouldn't it be

RE: Outlook mail folders

2002-03-14 Thread Ian Lurie
You can export the mail folder's contents to Access or Excel, I believe, and then search it that way. -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 7:48 AM To: CF-Talk Subject: OT: Outlook mail folders Does anyone have info on how to read

RE: HELP NEEDED

2002-03-14 Thread Matthew R. Small
Just thinking here... Why don't you write a batch file on your CF server that executes your perl script on the other server? - Matt Small -Original Message- From: Allan Pichler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:24 AM To: CF-Talk Subject: HELP NEEDED I have a

RE: Fusebox pros and cons

2002-03-14 Thread Jeffry Houser
Bingo, that is correct. As an example: I want a one-time rating system. I really want to capture the user's first impression without them being able to change it. [create a one time rating system] What if the user wants to change there rating? It does happen. At 08:04 AM 3/14/2002

Re: HELP NEEDED

2002-03-14 Thread Jeffry Houser
Won't cfexecute do it? Although, I believe you will have to have drive access to the other server (A mapped drive perhaps?) If you have ColdFusion on server2, use a cfhttp to execute a page with the cfexecute in it that runs the perl script. At 04:24 PM 3/14/2002 +0100, you wrote: I

RE: HELP NEEDED

2002-03-14 Thread Matthew R. Small
That is, using CFEXECUTE. - Matt Small -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:59 AM To: CF-Talk Subject: RE: HELP NEEDED Just thinking here... Why don't you write a batch file on your CF server that executes your perl

RE: HELP NEEDED

2002-03-14 Thread Allan Pichler
Well ... the problem is that the other box is a FreeBSD box! Can I use cfexecute to solve my problem @llan -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 5:04 PM To: CF-Talk Subject: RE: HELP NEEDED That is, using CFEXECUTE. - Matt

RE: Fusebox pros and cons

2002-03-14 Thread Christopher Olive
that's the point of having an appendix b in your contract, with this sort of thing specified. the clause in the contract referencing said appendix shoul dhave something along the lines of if Client requests more, this is my/our fee for changes, per hour. then jack the hourly rate up REAL

RE: Fusebox pros and cons

2002-03-14 Thread Ian Lurie
Yup. That works. But it still ticks off the clients. If everyone was reasonable we wouldn't need governments, I guess... -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:02 AM To: CF-Talk Subject: RE: Fusebox pros and cons that's

Retrieving header vars?

2002-03-14 Thread Reed Powell
Anyone out there had any luck getting access in a CFM page to ALL of the header vars that come over from the client? I'm about to start using Siteminder to do the user authentication, and it puts the user info into the header vars. I don't want to use the current CF support for SiteMinder

Re: SQL help please

2002-03-14 Thread ccook22
try select employeeid, startdate, enddate, count(*), paycatid from X group by employeeid, startdate, enddate, paycatid ksuh

RE: HELP NEEDED

2002-03-14 Thread Matthew R. Small
Golly... I'm not UNIX expert, but as long as you can find a way to execute your PERL script from your CF machine (is it Windows or what?) then you can make CF perform the execution as well. Is there a webserver running on the other machine? If so, then (and its really not necessary but keeps you

Page not refreshing

2002-03-14 Thread Smith, Daron [PA]
I have a message board that uses a meta refresh attribute to relocate a user to the main page after a post has been completed. However, for some reason IE will not refresh the page on the first time a user posts it returns the standard 'page cannot be displayed or dns error'. However if you hit

RE: Fusebox pros and cons

2002-03-14 Thread Jeffry Houser
I did have such some clause... but in that case I made the change as a customer service move. Bad move, because now I had the precedent of going over and above for nothing extra. After making it known that I had done way more than was in the contract and that the clock was going to start

Re: Fusebox pros and cons

2002-03-14 Thread David Schmidt
I believe that an important key to controlling scope creep is persistent documentation. I have found that if I can point at a piece of paper and just remind the customer that s/he said (or did not say) they needed a particular feature, then the may reconsider their new request. Granted that

RE: Outlook mail folders

2002-03-14 Thread Moneymaker, Jon S CONT (WPNSTA Yorktown)
Just tried this with an outlook folder that had almost a thousand messages in it...worked like a champ, moved it all over to access2k without a hitch... pretty cool actually. hey...something microsoft ACTUALLY worked (looking to see if sky is falling) Jon -Original Message- From: Ian

Mail tags

2002-03-14 Thread savan . thongvanh
is there a pop tag or tagset out there? ie for marking messages on the pop server read, for deletion, etc.? __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation ·

DB.....Access to SQL

2002-03-14 Thread CF_JONNY
I have an Access 2000 db that I used to build the site and the HOST has created the SQL db for it. I can see it through Access. Question is do I need to reconfigure the DSN and connections in my CF Administrator to keep everything online with SQL DB? Any other concerns I should think of?

RE: Outlook mail folders

2002-03-14 Thread Ian Lurie
Well, a CF programmer probably wrote the export code... -Original Message- From: Moneymaker, Jon S CONT (WPNSTA Yorktown) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 8:34 AM To: CF-Talk Subject: RE: Outlook mail folders Just tried this with an outlook folder that had

Re: Contracts (was Fusebox pros and cons)

2002-03-14 Thread David Schmidt
Another possiblity to help deal with customers that add changes, is to create a combination contract, where a fixed price is given for a fixed scope, and then a fixed budget for out-of-scope items. For instance, cfparam name=scopeofwork default=task1, task2, task3, task4 cfparam

Javascript does not want to change the current location

2002-03-14 Thread Macarie Neculai
Hi! I have the following problem: have a page that uses frames, and the frame structure is something like this: -- | topbar | |- | menu | up | | | - | | |

RE: Retrieving header vars?

2002-03-14 Thread Dave Watts
Anyone out there had any luck getting access in a CFM page to ALL of the header vars that come over from the client? I'm about to start using Siteminder to do the user authentication, and it puts the user info into the header vars. I don't want to use the current CF support for SiteMinder

RE: Javascript does not want to change the current location

2002-03-14 Thread VAN VLIET, SCOTT E (SBCSI)
Did you try: location='http://www.google.com' (with the http://)? Where is the a href= being called from? Did you try just: top.main.up.location='http://www.google.com'? Did you check the spelling (and case) of your frame names? So many questions ^_^ -- SCOTT VAN VLIET SENIOR ANALYST SBC

RE: Javascript does not want to change the current location

2002-03-14 Thread Steve Oliver
I may of misunderstood the question, but if you want it to go there in the current frame, why don't you just use a regular link with the target set to _self? _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original

Creating a new query from two existing queries and then sorting the new query

2002-03-14 Thread Alan Walker
Hello All, I need to output a list of two event types coming from different tables in a calendar format. I have two queries getting each type. I am creating a new query with all the columns necessary to both event types using QueryNew and then QueryAddRow and QuerySetCell. I can get all the

Retrying with CFHTTP Post

2002-03-14 Thread Nick Baker
Our site is communicating with another using CFHTTP Post. The site we are communicating with is overloaded and times out certain times of the day. We want to keep banging multiple times. Attempting this with a CFLOOP causes a time out problem with our page. Any other suggestions on of how to

RE: Image and DB Solution needed

2002-03-14 Thread Tony Schreiber
With CFCONTENT you can set to to delete the file from disk after it is served. How do you clean up the images, this is a concern as the web space is limited. And uuid files would mean more disk space. So there must be a way to do this with out saving as a temp file first! Can anyone explain

Re: Retrying with CFHTTP Post

2002-03-14 Thread Dave Hannum
CFTRY/CFCATCH with a redirect back to the original CFHTTP. This way there is a slight delay between attempts and avoids a timeout. Dave - Original Message - From: Nick Baker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 12:54 PM Subject: Retrying

Re: HELP NEEDED

2002-03-14 Thread Alex
cfexecute /usr/bin/perl perlscode.pl On Thu, 14 Mar 2002 [EMAIL PROTECTED] wrote: i love cf and all but since you're doing all that perl stuff wouldn't it be easier to accomplish that w/ a perl cgi script? c'anyone tell i'm having a slow day? :P Allan Pichler [EMAIL PROTECTED] on

Re: Contracts

2002-03-14 Thread Alex
search on google.com anyway specs and contracts always change during the project otherwise a company could just outsource overseas for $10/hr On Wed, 13 Mar 2002, Brian Thornton wrote: Eric or anyone else, Do you happen to have a contract template I could use? I would like to see what

Re: Retrying with CFHTTP Post

2002-03-14 Thread Cosmera
You might try using the HTTP COM object if you are using Windows. I have had much better success with it than with cfhttp with regard to performance. - Original Message - From: Nick Baker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 9:54 AM Subject:

Problems with CF-TALK mail server?

2002-03-14 Thread Matthew R. Small
It's happened to me everyday this week now, and it's happened before... I won't get any mail from this list for over two hours or some long period of time and then a ton of it comes in all at once. Anybody else experiencing this phenomenon? If I need to ask a question and get an answer and it

RE: Creating a new query from two existing queries and then sorting the new query

2002-03-14 Thread Ramin Surya
Query on Query on CF5 can do the job. -Original Message- From: Alan Walker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 11:44 AM To: CF-Talk Subject: Creating a new query from two existing queries and then sorting the new query Hello All, I need to output a list of two

RE: Image and DB Solution needed

2002-03-14 Thread Sicular, Alexander
You can easily write a temp file clean up script to check file datetimes and delete all those that are say 1 day old... Whatever. Uuid is just being used as a name, not additional file space. However storing the image as base64 in the db does add about 33% to the size of the file. Good luck,

Re: Problems with CF-TALK mail server?

2002-03-14 Thread Michael Dinowitz
The answer has to do with your mail server. When a mail server with a message wants to deliver it, the mailserver will try to talk to the receiving server. If the receiving server is not listening for some reason, the mail is held and an attempt is made in an hour. A different issue is the

RE: file/mime types

2002-03-14 Thread Brian Ferrigno
Paul, Here's a partial list of MIME types for audio and video. Format = audio/basic video/mpeg etc. audio basic [RFC2045,RFC2046] 32kadpcm[RFC2421,RFC2422] vnd.qcelp [Lundblade] vnd.digital-winds [Strazds] vnd.lucent.voice

[Re:] RE: ] RE: cached query

2002-03-14 Thread FARRAH NG
hi John, i did exactly what you have written. In the update action page, after the update query is executed, i put in the query to do a select on the updated table and with cachedwithin=#createtimespan(0,0,0,0)#. But when i refresh the home page the changes is not shown. I tried to

RE: Javascript does not want to change the current location

2002-03-14 Thread Langford, Bryan
Heres a fix all I am giving two options for reframing it or breaking the frame entirely: in the up frame page write a call to the javascript : onclick=parent.frameNavig(); in the framset page itself write the javascript : function frameNavig() { //changes the frame to the page you want. //

RE: Mail tags

2002-03-14 Thread Pete Freitag
CFPOP - http://livedocs.macromedia.com/cf50docs/CFML_Reference/Tags74.jsp#1101854 + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Can you tell if a page is using frames...

2002-03-14 Thread Yager, Brian T Contractor/NCCIM
Hello all, Is there a function in CF that can tell if the page is in a frame? If not, can this be done using JavaScript? Thanks, Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342

weird sql error

2002-03-14 Thread Jen Perkins
I keep getting a really strange sql error and I don't know what the heck it's coming from. === DETAIL: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 33: Incorrect syntax near 'P11'. SQL = SET NOCOUNT ON INSERT INTO images ( archiveFlag, approvalTypeID,

RE: Can you tell if a page is using frames...

2002-03-14 Thread Dave Watts
Is there a function in CF that can tell if the page is in a frame? No. CF is server-side, and doesn't have a clue about frames or any other client-side stuff. If not, can this be done using JavaScript? Yes, it can. I think CF Studio has an example of this, that you can generate using the

RE: Can you tell if a page is using frames...

2002-03-14 Thread E C list
It can be done using Javascript. I do this alot (the coldfusion IF statement is just to allow me to turn this off when I don't actually WANT frames...this will force you into frames if you're not. The window.location.href should point to the location of the file that has the frames: script

Re: Can you tell if a page is using frames...

2002-03-14 Thread BEN MORRIS
This script detects if the page is in frames (client-side of course) and then gets it out of frames. SCRIPT LANGUAGE=JavaScript !--// if (parent.frames[1]) { parent.location.href=self.location.href; } //-- /SCRIPT Yager, Brian T Contractor/NCCIM [EMAIL PROTECTED] 03/14/02 02:39PM Hello

Re: Retrying with CFHTTP Post

2002-03-14 Thread Nick Baker
Dave, Thanks for the input but I don't think a CFTRY/CFCATCH would gain us anything. Detecting the error is not a problem. The other Web site does in fact return HTML code with an error message. Basically the message is that the server is too busy to handle the request. Since we have a user

OT: UGH Stupid web save

2002-03-14 Thread Robert Everland
I have a client who is having problems having internet explorer opening up tif files in the web browser. I know IE doesn't open TIF natively but he uses the same exact program as someone else in his office and her internet explorer asks her if she wants to open or save, his just asks if

SQL Query Analyzer

2002-03-14 Thread Kahng, Lucius
I'm trying to retrieve a long text field from out ColdFusion SQL database using SQL Query Analyzer, however, the program truncates the field contents. Is there a way to display the full contents of long text fields? (Instead of having to use CFML to output a the whole table's column contents!)

RE: Can you tell if a page is using frames...

2002-03-14 Thread Yager, Brian T Contractor/NCCIM
Thanks everyone. All of this helped. I actually needed the code for both framebusting and to make sure the user is within my frame. Brian Yager President - North AL Cold Fusion Users Group Sr. Systems Analyst NCCIM/CIC [EMAIL PROTECTED] (256) 842-8342 -Original Message- From: E C

Re: OT: UGH Stupid web save

2002-03-14 Thread BEN MORRIS
My understanding is that when it comes to viewing files outside of the browser, it depends if your PC has any programs associated with the file extension. So he probably just doesn't have any image viewer/editor installed that views tiffs. Robert Everland [EMAIL PROTECTED] 03/14/02 03:07PM

Trimming Duplicates

2002-03-14 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
I have this query and it is returning records with the same name. I want to use a function like DISTINCT in my select statement, but I can't because I am pulling 2 field any suggestions. Basically when I put #location# it will come up with a city and right now it is coming up with it 20 times.

DB.....Access to SQL

2002-03-14 Thread CF_JONNY
I have an Access 2000 db that I used to build the site and the HOST has created the SQL db for it. I can see it through Access. Question is do I need to reconfigure the DSN and connections in my CF Administrator to keep everything online with SQL DB? Any other concerns I should think of?

FW: DB.....Access to SQL

2002-03-14 Thread CF_JONNY
I have an Access 2000 db that I used to build the site and the HOST has created the SQL db for it. I can see it through Access. Question is do I need to reconfigure the DSN and connections in my CF Administrator to keep everything online with SQL DB? Any other concerns I should think of?

Re: CFPOP unknown exception condition

2002-03-14 Thread Owen Leonard
So why wouldn't the cftry tag catch the 'unknown exception condition' error that CFPOP is generating? Every time this error happens, the mailbox on the mail server is locked, and the user can't even try again for however long it takes the mailbox to 'unlock.' -- Owen I know I've asked

RE: OT: UGH Stupid web save

2002-03-14 Thread Robert Everland
He does, that's the thing I don't understand. They both have the exact same program. When he clicks save and opens it it works fine. Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: Thursday, March

RE: OT: UGH Stupid web save

2002-03-14 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
I have run into something similar before.. I have CF Studio and Ultra Dev and Dream weaver installed on my home PC depending on the order in which they installed is what dictates what is associated with and .html file if I just click on it. The fix is simple check to see if the association is

OT: Javascript (File Upload option)

2002-03-14 Thread James Taavon
Has anyone written a script to give a user the option to select how many files they wish to upload and then using onChange provide the respective number of upload boxes? __ Why Share? Dedicated Win 2000 Server · PIII 800 /

RE: OT: UGH Stupid web save

2002-03-14 Thread BEN MORRIS
The only thing I can think of is that for some reason the file association might not be there. I would check under Win Explorer - tools menu - folder options - file types tab Robert Everland [EMAIL PROTECTED] 03/14/02 03:22PM He does, that's the thing I don't understand. They both have the

  1   2   >