Anybody encounter this error "Http Error 400 : Bad Request"

2001-03-07 Thread JAIME HOI
Did anybody encounter this error before?? Some of my users encounter this error during login. After verification of the password and user id, the page will be redirected to a menu page. But sometimes , some browsers encounter this error "The Page cannot be found" and there is this error code "Ht

RE: Advanced ColdFusion, UK, March 12th

2001-03-07 Thread Tristram Charnley
Me too, and I'll second that. Anyone going to do the Spectra course on 19th March? Tristram Charnley - [EMAIL PROTECTED] "If something is hard to do, its not worth doing!" Homer Simpson. > -Original Message- > From: Jason Lees (National Express) > [mailto:[EMAIL PROTEC

RE: Anybody encounter this error "Http Error 400 : Bad Request"

2001-03-07 Thread Tony Gruen
Yes, I have encountered this exact scenario before and it drove me crazy for weeks. It turned out to be that if the user clicked back then submitted again the URL variables were doubled - this produced this error and the url line looked something like.(don't remember exactly but I am sure you

ColdFusion General Forum in Delphi.com

2001-03-07 Thread Teng-Yan Loke
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've created an online community called "ColdFusion General Forum". It's for folks who prefer to use a web-based interface for discussions. Please join the discussion! With the message board, you can view discussion folders quickly in the left-hand c

FW: UK-based ColdFusion training course for network administrator s

2001-03-07 Thread Aidan Whitehall
Repost: == Is anyone aware of, or running, a UK-based ColdFusion training course specifically designed for network administrators, not developers? BTW, I've checked the Tech-connect site and there doesn't seem to be anything specifically geared for CF and network admins... Thanks

Re: Advanced ColdFusion, UK, March 12th

2001-03-07 Thread Adam Phillip Churvis
Take a look at the "Advanced Bootcamp for ColdFusion, Database, and Javascript" course being offered on www.ColdFusionTraining.com. Respectfully, Adam Phillip Churvis Productivity Enhancement, Inc. Publishers of the CommerceBlocks line of modular ColdFusion development tools Website: http://ww

RE: curly queries

2001-03-07 Thread DeVoil, Nick
Toby Something like this will get you n rows per poem where n is the number of options, filtering out the hidden ones. Assuming each poem must have options - otherwise you need an outer join. select p.poem_id, p.poem_title, d.option_name, o.setting from poem p, poem_option o, poem_option_def d w

Closing A Browser Window

2001-03-07 Thread ehoma
Hi, Anyone know how I can make my logout.cfm page actually close the browser window? I've created the browser window by using the following called from another browser window: window.open('/URL/index.cfm','Admin', 'toolbar,location,status,menubar,scrollbars,resizable,width=710,height=370') W

RE: curly queries

2001-03-07 Thread DeVoil, Nick
OK, hold the messages about basic CFML errors... #poem_id# #poem_title# #option_name#=#setting# ** Information in this email is confidential and may be privileged. It is intended for the addre

RE: Closing A Browser Window

2001-03-07 Thread Javed Mushtaq
try this mate, Embed with the script to clear the client and session variables and just put this after the script to do the clearing. Works for me. window.close(); ~~ Structure your ColdFusion code with Fusebox. Get the

Invalid data in message

2001-03-07 Thread Bjørn Jensen
We're recently enabled the feature to have all coldfusion error captured and an error page displayed. In this page we send ourselves an email with error info. The weird thing is that some of the messages go through and some of them dont, our cf server says: MAIL\spool\4D.cfmail. SMTP server replie

RE: Closing A Browser Window

2001-03-07 Thread Edward Chanter
try this: > -Original Message- > From: ehoma [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 07, 2001 9:51 AM > To: CF-Talk > Subject: Closing A Browser Window > > > Hi, > > Anyone know how I can make my logout.cfm page actually close the browser > window? I've created the brows

RE: Advanced ColdFusion, UK, March 12th

2001-03-07 Thread Daniel Lancelot
Anything like this in the uk??? -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 09:41 To: CF-Talk Subject: Re: Advanced ColdFusion, UK, March 12th Take a look at the "Advanced Bootcamp for ColdFusion, Database, and Javascript" course being of

Another FAQ:

2001-03-07 Thread Michael
Just thought I would pass this along, for interst sake. http://developer.irt.org/script/fusion.htm Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http:

Database joins

2001-03-07 Thread Bjørn Jensen
Hi, I'm wondering if it's possible to make a join over 2 different databases on 2 different servers. What I'm trying to do is that I have my information on 1 server, including a customer id and the customer name is located on the other server. I can easily get all this info in multiple queries, th

Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Edward Chanter
Hey people, Does anyone have any experience using CF and/or another application to convert files on the fly? The scenario is: 1. Client logs onto website 2. Client uploads word or powerpoint document via a web page and cfftp 3. Server converts document to either html or pdf 4. Document is put o

Re: Closing A Browser Window

2001-03-07 Thread Brian Thornton
But the user will be prompted... Try This: STEP 1: make a "fake" link that will open the window for you. CLICK ME! The link "JavaScript:void(0)" is a null function that does nothing. 'attributes' can include things like height=, width=, scrollbars=yes,no location=yes,no menubar=yes,no resizea

RE: Database joins

2001-03-07 Thread Philip Arnold - ASP
> Hi, I'm wondering if it's possible to make a join over 2 > different databases > on 2 different servers. What I'm trying to do is that I have my > information > on 1 server, including a customer id and the customer name is > located on the > other server. I can easily get all this info in multip

Re: A request

2001-03-07 Thread Sean Renet
Phillip, Get caller ID. You know I used to tell recording artists who's phone numbers got out that the converse could also be true. That is, your phone number gets out and no one cares to call :-P Sean Renet. - Original Message - From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: "CF-T

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Philip Arnold - ASP
> Does anyone have any experience using CF and/or another application to > convert files on the fly? > > The scenario is: > > 1. Client logs onto website > 2. Client uploads word or powerpoint document via a web page and cfftp > 3. Server converts document to either html or pdf > 4. Document is pu

Re: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Brian Thornton
Adobe has created a ASP app for this on the fly I first signed up several months ago for $20 a year. Check out a couple of vendors http://www.adobe.com http://www.cardiff.com/products/A1/ - Original Message - From: "Edward Chanter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sen

RE: curly queries

2001-03-07 Thread Eric Barr
Toby, Their are two ways that you could do this. First way it to return your data in a column based manor (the "way you want it") then just print it out, the second is to return it in a row based manor ( the "way it is now"). Each way has issues. Column Based : What it seems like you would li

Migration from NT4 to Solaris

2001-03-07 Thread Capolinea
Hello to all CF Guru, I was asked by my boss to look for informations in order to migrate a web site from NT4 to Solaris We are running CF 451 US Enterprise on 2 front server and a database Oracle 8i running on another server. Is it worth doing that? What the pro and cons? Any ideas, experie

Re: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Brian Thornton
Sorry ASP meaning Application Service Provider not ASP as in Active Server Pages. - Original Message - From: "Brian Thornton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 4:26 AM Subject: Re: Converting Docs and Powerpoint files to html or pdf using

RE: A request

2001-03-07 Thread Philip Arnold - ASP
> Get caller ID. The problem is that the guys in the office grab the phone as soon as it rings, and since we have a lot of clients who call from different locations, we can't know all of the numbers - good idea generally though > You know I used to tell recording artists who's phone numbers got

OT: SQL Help, Please

2001-03-07 Thread Scott Brader
Sorry for the OT but I'm at a loss on this one. I've built an application for a Fire/Rescue service to log their calls, meeting attendance, etc. (geared to small, volunteer agencies). One of the things that's very important for them is a sum of the hours spent on calls. Each call record has a uni

RE: SQL Help, Please

2001-03-07 Thread Philip Arnold - ASP
> I've built an application for a Fire/Rescue service to log their calls, > meeting attendance, etc. (geared to small, volunteer agencies). One of the > things that's very important for them is a sum of the hours spent > on calls. > Each call record has a uniquely generated call number that is the

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Thomas Chiverton
We have a program called '5D' that sets up a pseudo printer under Windows, that actualy creates a PDF file... > - Original Message - > From: "Edward Chanter" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, March 07, 2001 5:18 AM > Subject: Converting Docs and Po

RE: SQL Help, Please

2001-03-07 Thread Scott Brader
Philip, Thanks for the help. Unfortunately, that didn't do the trick. The query returns a -2. I've put in test records to this point, so I know that the return should be 22. Any other ideas? Thanks, Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairi

RE: SQL Help, Please

2001-03-07 Thread Scott Brader
Philip, Upon further testing, your suggestion does work fine, however, I'm getting the error whenever the times are on two different days; dispatch time was 23:25 and return to quarters time was 02:15. Will I have to change it from short time format to a different date/time format? Thanks, Scott

RE: SQL Help, Please

2001-03-07 Thread DeVoil, Nick
If they leave at 22:00 and get back at 20:00 the next day, and you are only storing the *time*, not the date and time, then they are indeed getting back 2 hours earlier than they left. Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2

Re: Another Security Question...

2001-03-07 Thread Vance Duke
Thanks. But until I can get a copy of the book, can someone help me with the question? Thanks, Vance Duke - Original Message - From: "Scott, Andrew" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 4:37 PM Subject: RE: Another Security Question...

RE: SQL Help, Please

2001-03-07 Thread Scott Brader
Changing the field type to General Date and storing the date and time solved the problem. Thanks for all the help! Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mob

Query Performance

2001-03-07 Thread Javed Mushtaq
Hi all, Just a quick question - why would one write an Action page with the following bit of code for a insert select statement METHOD A: Insert into TblCustomer (CustomerId, Forename,Surname, CompanyName) SELECT tmpTblCustomer.CustomerId, tmpTblCustomer.Forename, tmpTblCustomer.Surname

RE: Query Performance

2001-03-07 Thread Philip Arnold - ASP
> Just a quick question - why would one write an Action page with the > following bit of code for a insert select statement > > METHOD A: > > Insert into TblCustomer (CustomerId, Forename,Surname, CompanyName) > SELECT tmpTblCustomer.CustomerId, tmpTblCustomer.Forename, > tmpTblCustomer.Surn

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Larry Juncker
If they are using Word or Powerpoint 2000 all they have to do si save the file as an HTML file. The work is already done for them. That seems simple enough. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Philip Arnold - ASP [ma

Re: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Ken Wilson
> If they are using Word or Powerpoint 2000 all they have to do si save the > file as an HTML file. Have you ever looked at the quality of the code that method generates? ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Jason Lees (National Express)
You can always run them through dreamweaver before commiting them to disk (esp the word files). Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 14:37 To: CF-Talk Subject: Re: Converting Docs and P

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Larry Juncker
Yes, I have, however that was not the question. I use Dreamweaver after that point to clean it up with the Cleanup Front Page and Clean up Word Extensions that are available. That is one conversion process. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -O

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Edward Chanter
Not if the whole thing has to be uploaded to a web server via http.. Doing a "Save as html" saves the images in a seperate directory, if your users are techneanderthals like mine then asking them to zip the files up and ftp them to the server isn't an option. Plus the converstion that Word doe

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Gavin Lilley
Dreamweaver has a cool function which cleans up Microsoft html and turns it into something workable. -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 14:37 To: CF-Talk Subject: Re: Conv

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Edward Chanter
Thanks to all of you who posted replies to this thread. Just to let you know I've sorted the problem using activePDF and it works like an absolute dream Now I can actually get some sleep tonight :-)) I've managed to create a very basic app that allows a user to submit a word document via an h

Re: Migration from NT4 to Solaris

2001-03-07 Thread C Frederic Valone
I have found through my experiences that CF on NT4 has been a better performer and had more stability than on Solaris. Most of my experiences were pre cf 4.5.1 but I still find NT to be preferable for running the CF server and the web server. Capolinea wrote: > > Hello to all CF Guru, > > I w

RE: Anybody encounter this error "Http Error 400 : Bad Request"

2001-03-07 Thread Ben Dyer
Are there any spaces that can be generated in the URL, like: http://www.site.com/whatever/index.cfm?something=this value Netscape would bounce that URL, IE would translate it to: http://www.site.com/whatever/index.cfm?something=this%20value --Ben >-Original Message- >From: JAIME HOI

RE: Anybody encounter this error "Http Error 400 : Bad Request"

2001-03-07 Thread Edward Chanter
Try using #URLEncode(http://www.site.com/whatever/index.cfm?something=this value)# > -Original Message- > From: Ben Dyer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 07, 2001 2:49 PM > To: CF-Talk > Subject: RE: Anybody encounter this error "Http Error 400 : Bad Request" > > > Ar

OT: Converting Microsoft Publisher/QuarkXpress to PDF

2001-03-07 Thread DeVoil, Nick
Kind of related to the Word/Powerpoint thread... Does anyone have any idea how to convert documents in the above 2 formats to PDF? Not automatically using CF, but manually on a PC. I'm being asked & have no clue about this stuff. I believe there is a plugin for QuarkXpress that does this? As for

OT: Displaying Javascript erros in NS6

2001-03-07 Thread Daniel Lancelot
Has anyone managed to do this??? I cant find how to display javascript errors in NS6?? Cheers. Daniel Lancelot Web Developer Netstep Corporate Communications Tel +44 (0) 1422 200308 Fax +44 (0) 1422 200306 e-mail: [EMAIL PROTECTED] www: http://www.netstep.co.uk ~

Re: OT: Converting Microsoft Publisher/QuarkXpress to PDF

2001-03-07 Thread Chad Gray
Purchase Adobe Acrobat, and you will be able to output these files to PDF. Adobe Acrobat comes with a "print driver" that lets any program that can print to a printer, output to a PDF. At 02:54 PM 3/7/01 +, you wrote: >Kind of related to the Word/Powerpoint thread... > >Does anyone have a

Help with Url??

2001-03-07 Thread ibtoad
I am trying to intereact with an existing website and need to pass a url for a return path. The problem is that the outside site is changing my return url by adding amp; instead of the & alone. example: http://localhost/index.cfm?value1=whatever&value2=whatever Is there anyway to strip the amp;

LEVEL 8 Systems Corporate Website

2001-03-07 Thread Jones, Becky
would anyone know what type of package this company used to make this image? something like photoshop or dreamweaver? http://www.level8.com/ * This e-mail, including any attachments, is intended for the receipt and use by the intended address

RE: Displaying Javascript erros in NS6

2001-03-07 Thread Dan G. Switzer, II
Go to: Tasks > Tools > JavaScript Console It took me a while to find it the first time too-I got to used to being able to type "javascript:" in the address bar. :) -Dan -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 10:12 AM To: CF-Ta

RE: reading local INI file

2001-03-07 Thread Dave Watts
> > > I have set up several kiosks, each of them are connected > > > to the net... I need to uniquely identify each computer, > > > but without human intervention. The browser is a Delphi > > > form, and part of the INI file that is on each kiosk > > > contains a unique ID for that kiosk. Any idea

CFMail - multiple "FROM" addresses

2001-03-07 Thread Albert, Gregory Mitchell (Greg)** CTR **
I need to send mail through CFMail from multiple people, but I am running into problems. When I have more than one address, the first address isn't formatted correctly. Instead of [EMAIL PROTECTED], it has galbert%agere.com. Of course, the mail server can't recognize this. The senders also need t

Re: Help with Url??

2001-03-07 Thread Alex Schrimsher
URLencodedformat - Original Message - From: "ibtoad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 10:22 AM Subject: Help with Url?? > I am trying to intereact with an existing website and need to pass a url for > a return path. The problem is t

RE: Displaying Javascript erros in NS6

2001-03-07 Thread Javed Mushtaq
Have you tried putting javascript: into the location bar and hitting return. That does the trick in NN4.7 as i am using that. -Original Message- From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 15:12 To: CF-Talk Subject: OT: Displaying Javascript erros in NS6 Has a

RE: Displaying Javascript erros in NS6

2001-03-07 Thread Daniel Lancelot
thanks - I have been tearing my hair out for the last 2 hours trying to find how to do this... -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 15:29 To: CF-Talk Subject: RE: Displaying Javascript erros in NS6 Go to: Tasks > Tools > JavaScript C

RE: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Katherine Maltby
I think it's probably Photoshop. Kath Katherine Maltby Senior Producer -- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in a

Help, help, help Pleasssssse: migration from NT4 to Solaris

2001-03-07 Thread Capolinea
Hello to all CF Guru, I was asked by my boss to look for informations in order to migrate a web site from NT4 to Solaris We are running CF 451 US Enterprise on 2 front server and a database Oracle 8i running on another server. Is it worth doing that (NT > Solaris) ? What the pro and cons ? Any i

Updating CLOBs

2001-03-07 Thread Jeff Britts
Been having an issue with updating clobs. Solaris 4.5.latest, Oracle 8i.latest, native datasource Inserting a record with a CLOB works fine, but when you go to update it, it throws a "Missing Expression Error". There is no missing expression. If you change the cfsqltype to CF_SQL_LONGVARCHAR

RE: Migration from NT4 to Solaris

2001-03-07 Thread Kevin Gilchrist
I'll let you know we go live in about two weeks! (Except this will be a brand new site, not migrating from NT) -Original Message- From: Capolinea [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 7:52 AM To: CF-Talk Subject: Migration from NT4 to Solaris Hello to all CF Guru,

Another SQL statement question...

2001-03-07 Thread river
It's off-topic, but I know people here are experienced with SQL, so... I am using SQL 7.0 and CF 4.5. I am trying to combine two ntext field columns to one field in a query, but I have a problem when one of the fields contains 'NULL' value. I am trying: SELECT TextID, TextColumn1 + TextColumn2

RE: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Philip Arnold - ASP
> would anyone know what type of package this company used to make > this image? > something like photoshop or dreamweaver? > > http://www.level8.com/ Photoshop is an image editor, DreamWeaver is an HTML editor - so I doubt an image was created in DreamWeaver... They could have built it in just

Re: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Deanna L. Schneider
All ya gotta do is view source. They used photoshop and imageready. But, the same could be done in Fireworks. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg

RE: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Garza, Jeff
If you look at the source, you'll see the light... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 8:20 AM To: CF-Talk

Those darn Access .ldb files

2001-03-07 Thread Douglas . Knudsen
Ok, I've searched through the House of Fusion Mail Archive and Allaire's support forums for info regarding how to unlock a M$ Access file through CF. We are using NT4 SP5(or 6) and CF 4.0.1. I have done/tried the following: 1) unchecked the 'maintan connections' checkbox in the ODBC setup f

RE: Help, help, help Pleasssssse: migration from NT4 to Solaris

2001-03-07 Thread Thomas Chiverton
Well, in general, Solaris will serve more hits per doller, but it really depends on the details of you web site, database backend, layering model etc. -Original Message- From: Capolinea [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 3:39 PM To: CF-Talk Subject: Help, help, hel

RE: Converting Microsoft Publisher/QuarkXpress to PDF

2001-03-07 Thread Braver, Ben:
Nick, If you really mean "manually on a pc", when you install Adobe Acrobat to create PDF files, it installs a print driver which "prints" to PDF files. So in a true manual sense, you pick File / Print from the program menu. A little less manually, you can print from applications to .ps PostScri

RE: Help, help, help Pleasssssse: migration from NT4 to Solaris

2001-03-07 Thread Jeff Britts
We're using both. Just started using Solaris 6 months ago. Both have been reliable. It's hard for me to compare the two. The Solaris runs about twice as fast, BUT, we've got a pretty hefty Sun box and a pretty basic NT box. -Original Message- From: Capolinea [mailto:[EMAIL PROTECTED]]

RE: Another SQL statement question...

2001-03-07 Thread DeVoil, Nick
how about SELECT TextID, IFNULL(TextColumn1, '') + IFNULL(TextColumn2, '') AS AllTextColumns FROM Table1 -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 3:53 PM To: CF-Talk Subject: Another SQL statement question... It's off-topic, but I know

RE: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Gavin Lilley
I have only ever done this in Fireworks, but Im sure theres some sort of feature in dreamweaver (lets face it - dw does everything else!). I would bet that photoshop and the other adobe software does this just as well as the macromedia stuff! -- Gavin Lilley Internet / Intranet Developer http://h

RE: cfmail

2001-03-07 Thread Daniel Lancelot
How about using CFFile to write the file (could be .txt .htm whatever), before using as shown by Howie... -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: 06 March 2001 23:30 To: CF-Talk Subject: RE: cfmail but wouldnt the user that recieves the form need to have

RE: Another SQL statement question...

2001-03-07 Thread Philip Arnold - ASP
> It's off-topic, but I know people here are experienced with SQL, so... > > I am using SQL 7.0 and CF 4.5. I am trying to combine two ntext field > columns to one field in a query, but I have a problem when one of > the fields contains 'NULL' value. I am trying: > > SELECT TextID, TextColumn1 +

cf 4.5.1 sp2

2001-03-07 Thread MIKE GEORGE
We just bought a copy of CF 4.5.1. How do I know if this is Service Pack 2 or not. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts

Re: Those darn Access .ldb files

2001-03-07 Thread Jeffry Houser
I'm confused. Are you trying to unlock the database inside a 'functional' page that users will see? I've only had to do this when I am copying over the database. Using method two, I would run it without the try/catch tags. If the page throws an error, who cares. It's a page for my o

Re: Those darn Access .ldb files

2001-03-07 Thread Jay Patton
This has worked well for me when ive had that problem: Unlock Database! Select * >From YourTable Where lock="whatever you want it to" I just refresh the page a few times and it unlocks the DB. Hope this is helpfull. Jay Patton Web Design / Application Design Web Pro USA 406.549.3337

Re: Those darn Access .ldb files (forgot to add)

2001-03-07 Thread Jay Patton
sorry i forgot to add, that code i sent you is from a page that i use called unlock.cfm and i just run that page when the db gets locked. Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: <[EMAIL PROTEC

RE: Another SQL statement question...

2001-03-07 Thread Maia, Eric
I think COALESCE is another way to do this: COALESCE(TextColumn1, ' ') -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 8:18 AM To: CF-Talk Subject: RE: Another SQL statement question... how about SELECT TextID, IFNULL(TextColumn1, '') +

RE: CFMail - Sending a link in an email

2001-03-07 Thread Maia, Eric
Outlook handles HTML mail from my CF server just fine. What type of mail server are you using to send the mail from your CF server? I've seen HTML mail "garbled" by passing it through a listserver that can't handle it, even though the clients on both ends can read it OK. -Original Message

RE: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Thomas Chiverton
> but Im sure theres some sort of > feature in dreamweaver (lets face it - dw does everything else!). Err... no ? Dreamweaver is very good, and writes nice (if bloated at times) HTML/ColdFusion/whatever. It isnt a picture editor, however, in any shape or form ! ~

RE: Another SQL statement question...

2001-03-07 Thread DeVoil, Nick
Yes, my bad, isnull not ifnull -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 4:24 PM To: CF-Talk Subject: RE: Another SQL statement question... > It's off-topic, but I know people here are experienced with SQL, so... > > I am usi

RE: ColdFusion General Forum in Delphi.com

2001-03-07 Thread Angél Stewart
Do we get all the messages that are sent to the CFTALK list over on that discussion forum..adn are our responses sent back to the mailing list as well? ;-P hee hee -Gel -Original Message- From: Teng-Yan Loke [mailto:[EMAIL PROTECTED]] I've created an online community called "ColdFusion

RE: cf 4.5.1 sp2

2001-03-07 Thread Nick Betts
Install it, go into CF Admin, Version Info. It should state version 4, 5, 1, SP2 Nick Betts PoulterNet Leeds -Original Message- From: MIKE GEORGE [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 16:38 To: CF-Talk Subject: cf 4.5.1 sp2 We just bought a copy of CF 4.5.1. How do I know if

Passing URL Values to An Included Page

2001-03-07 Thread Angél Stewart
Hello all! I'm forging ahead, albeit slowly what with having a dayjob and all, with my little gamesite, Carigamer.com I'm now implmenting a simply News Archive viewing system, and have run into a problem. All the pages are included from the main page, default.cfm using the format default.cfm?p

Re: Passing URL Values to An Included Page

2001-03-07 Thread Alex Schrimsher
#allnews.h eadline# The first attribute is passed with ? all others with & Alex - Original Message - From: "Angél Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 12:16 PM Subject: Passing URL Values to An Included Page > Hello all! > > I

RE: Passing URL Values to An Included Page

2001-03-07 Thread James Maltby
Try setting an "archive" id param in default.cfm (or Application.cfm) such as then append the archive_id to the end of you link http://www.carigamer.com/default.cfm?page=news/viewarchived.cfm&archive_id=1 234 Then instead of using "id" within viewarchived.cfm - change it to #url.archive_id# O

Broken image links

2001-03-07 Thread Chris Martin
Hi. Here at work, we keep a database of image paths. These paths are based on who uploads an image, what group it belongs to, what it is used for, et cetera. We have an internal Sql server query that we use to lookup the path for an image, given that images ID. We use this query for almost al

RE: Passing URL Values to An Included Page

2001-03-07 Thread Angél Stewart
Well waddya know..it picked it up correctly. I didn't try that, because somehow I didn't think the newsviewer.cfm page would pick it up. tsk tsk tsk. I need coffee. -Gel *slinks off redfaced and ashamed* -Original Message- From: Alex Schrimsher [mailto:[EMAIL PROTECTED]] #allnews.h e

Excel

2001-03-07 Thread Clint Tredway
Someone had a n example of how to send a query to Excell and format it. Does this require Excell to be on the server and the Client or just the client or just the server? Thanks for any help! -- Clint Tredway www.factorxsoftware.com -- ~~ Stru

cfoutput

2001-03-07 Thread John McCosker
Has anyone come a accross a weird one like this, I have a query like so SELECT dt, messageType FROMdbo.milford WHERE status > = 4 or status < = 6 and datediff(day , dt , getdate() ) = 0 but when I output the query l

RE: Broken image links

2001-03-07 Thread James Maltby
Usually Netscape fails where IE works when there are spaces in url names (e.g. would work in IE, but not in Netscape - may also be in the html output code - Netscape is far harder on tables for example - or I may be way way way way off! James "You're a big man, but you're out of shape. With me

RE: Excel

2001-03-07 Thread C. Hatton Humphrey
Clint, There are a couple of tags on the DevEx that do this. I actually found that HTML2EXCEL works a bit better if you're wanting to format the data returned by the query. We did have to install Excel on the server. We used Excel 97, which took about 15 meg. HTH Hatton Humphrey > -Origi

RE: cfoutput

2001-03-07 Thread John Stanley
Is the recordcount for the query greater than zero? Put the following code after the query but before the cfoutput tag to check: alert("Query has returned #qry_checkMilforStatus.recordcount# records"); ~~ Structure

RE: LEVEL 8 Systems Corporate Website

2001-03-07 Thread Tristram Charnley
They used ImageReady which comes with PhotoShop 6.0 - ImageReady adds JavaScript code to the resulting HTML file to specify rollover states. Tristram Charnley - [EMAIL PROTECTED] "If something is hard to do, its not worth doing!" Homer Simpson. > -Original Message- > F

Re: Broken image links

2001-03-07 Thread Alex Schrimsher
There are spaces in the name of your image file. Either rename then or use htmlencodedformat the files. Alex - Original Message - From: "Chris Martin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 12:39 PM Subject: Broken image links > Hi. He

OT: Help!!! - Nettscape 6 DOM

2001-03-07 Thread Daniel Lancelot
Ideally, Can someone point me to an understandable DOM reference for Netscape 6 I am trying to position a div dynamically using JS in NS6 - and document.getElementById(tdiv).style.pixelTop and document.getElementById(tdiv).style.Top and document.getElementById(tdiv).Top dont seem to work - has

RE: Broken image links

2001-03-07 Thread Ben Dyer
Exactly. Wrapping the path and file name in #URLEncodedFormat()# should fix the problem. --Ben At 11:48 AM 3/7/01, you wrote: >Usually Netscape fails where IE works when there are spaces in url names >(e.g. would work in IE, but not in >Netscape - may also be in the html output code - Netscap

HELP going from Dynamic CF Queries to Stored Procedures

2001-03-07 Thread metzy martinez
Our company is going from using regular cfquery statements to putting them into stored procedures in order to get the load of our cold fusion box and letting the sql server box handle the load. where i'm having problems is making a query that is dynamic and changing it to a stored procedure. i'm

RE: cfoutput

2001-03-07 Thread Patricia Lee
The first thing i'd do is check to make sure the query is returning results. Have you downloaded cf_dump or cf_objectdump from the taggallery yet? if not, go there and find them... download ... then use them to check the output of the query. Seeing as you're dynamically passing in a username and

RE: cfoutput

2001-03-07 Thread Dave Watts
> I have a query like so > > username="#application.gateway#" password="#application.key#" > maxrows="1"> > SELECT dt, messageType > FROMdbo.milford > WHERE status > = 4 or status < = 6 and > datediff(day > , dt , getdate()

HELP going from Dynamic CF Queries to Stored Procedures

2001-03-07 Thread metzy martinez
-Original Message- From: metzy martinez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 1:01 PM To: CF-Talk Subject: HELP going from Dynamic CF Queries to Stored Procedures Our company is going from using regular cfquery statements to putting them into stored procedures in

  1   2   3   >