RE: cfhttp Connection failure

2001-09-25 Thread Kevin Roche
Hi, I have seen this many times through lack of cookies. Kevin -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: 24 September 2001 21:04 To: CF-Talk Subject: RE: cfhttp Connection failure A number of reasons. Proxy server? Perhaps the site expects a particular

Re: ISP Privacy - does your isp do this???

2001-09-25 Thread Tony Hicks
It seems to me that this is common, yours is just more honest about it.. Ironic that Earthlink's new kick is about keeping your information private.. A company shouldn't have the right to say Ok, you're paying us to setup an account based on information you provided, and then we're going to sell

RE: WDDX

2001-09-25 Thread Alistair Davidson
Depends where you store it! If its a CLIENT variable, then it depends on where you're storing client variables - but just as a guide, I've run into problems storing more than 64k in a client variable stored in a SQL Server 7.0 DB Alistair Davidson Senior Developer Rocom New Media

OT: perl function for round-up

2001-09-25 Thread Mak Wing Lok
sorry for the OT, does any Perl expert out there know what's the perl function to round up a decimal value? this is my first time doing perl and i don't seems to find it in the ref. book that i had. ~~ Get the mailserver that powers this list at

RE: SQL- Column datatype on an empty table

2001-09-25 Thread DeVoil, Nick
Bill I'm needing to get a list of the datatypes and maxlength properties of the columns of an empty table Something like this: select column_name, data_type, character_maximum_length from information_schema.columns where table_name = 'whatever' Nick

RE: perl function for round-up

2001-09-25 Thread DeVoil, Nick
what's the perl function to round up a decimal value? ceil() rounds up to the next integer. It's in the POSIX module. ** Information in this email is confidential and may be privileged. It is intended for the addressee only.

RE: Delay function in CFM

2001-09-25 Thread Philip Arnold - ASP
I am looking for a CFM function where it delays a specific amount of time before it proceeds to the next line of instruction. There are several Wait or Sleep type tags in the TagGallery, but they're NT based Most also deal in whole seconds, so if you want to wait a quarter of a second, it

Printing reports on per page

2001-09-25 Thread Tristram Charnley
This must be a no-brainer but. I'm creating a report from a large recordset. How can I get these to print from the browser one per page? Tristram Charnley ~~ Your ad could be here. Monies from ads go to support these lists and provide more

RE: Error 232

2001-09-25 Thread Peter Tilbrook
Our IT guys (not CF minded at all) phoned me today about their massive (280Mb) ColdFusion log files. I told them their doesn't appear to be a way to disable logging but they should monitor the logs and clear/delete them as appropriate. 280Mb is a hell of a log file for a one site CF server.

RE: AHHHHHHHH Netscape HTML Question

2001-09-25 Thread Peter Tilbrook
Netscape is VERY fussy about tables - which is good (and a reason why you should test sites under different browsers wherever possible). Of course it has (NS) other features that frustrate also. ~~ Your ad could be here. Monies from ads go to

RE: CPU 100% notification?

2001-09-25 Thread Peter Tilbrook
CF 4.5? Have you installed the 4.5.x service pack (hardly a patch but a BIG download). CF5 utilises memory much better than 4.5x Is there a fix for the 100%CPU problem with CF 4.5 yet? Also does anyone know of a way to send a notification email when the CF server pegs at 100%CPU and wont

RE: Printing reports on per page

2001-09-25 Thread Kurt Ward
This will work in IE only: p style='page-break-before: always' -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 7:54 AM To: CF-Talk Subject: Printing reports on per page This must be a no-brainer but. I'm creating a report

RE: Absolute Path Usage

2001-09-25 Thread Peter Tilbrook
Relative paths are recommended, if more for portability that anything else. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: CFMAIL on 5.0

2001-09-25 Thread Carlisle, Eric
It's very discouraging to hear that this bug still exists. This was a bug existed in 4.5.1 and was supposed to be fixed in 5.0. No hotfix available for this one, by the way. Upgrading to 5.0 is MM's fix. I think it's high time for this one to be fixed! It's a very serious bug. Due to this

Re: Sql Server 2000

2001-09-25 Thread William J Wheatley
Nope still went into Single User Mode again this morning and its only 1 db this is so damn weird and even after Sql Server SP1 Bill Wheatley Director of Development Certified Master ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684

Setting up a knowledgebase

2001-09-25 Thread kbutterly
Good morning, all. I have just been assigned a project to set up a company wide knowledge base and I am soliciting ideas, references, warnings, and resources. We will be using SQL Server for the database. There will be a user portion of the site and an admin portion. From the user portion we

RE: Sql Server 2000

2001-09-25 Thread Peter Tilbrook
Will, was having similar problems (probably will again tomorrow). My app refused to connect to SQL Server (2000). If I reboot or logout both IE (6) and SQL - SQL in particular - forget connection settings. I can go into the Control Panel and re-configure the SQL ODBC connection to get my app to

Re: WDDX

2001-09-25 Thread Chris Norloff
I know if you want to save the WDDX packet in a client variable you may have size problems - our Oracle 8.1 database errors if we try to insert more than 4000 characters at once (and that's easy to do with packetized client variables since they're all inserted at once at the end of the

RE: WDDX

2001-09-25 Thread Raymond Camden
Did you try changing the size of the columns in the db? === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is.

Re: `NOT in` CFQuery problem

2001-09-25 Thread Deanna Schneider
You just have to do what the error message is asking you to do - output the query.columnname, like so: (I can't remember what you named your first query, so you'll have to change the query name.) Cfquery name=todaysmembers datasource=#DSNb# SELECT * FROM members WHERE subscribe_date =

Re: Sql Server 2000

2001-09-25 Thread Al Musella, DPM
Try disabling any automated maintanace tasks... it may be that it is putting the db into single user mode to process the task, then not completeing successfully, so it never gets to removing the single user mode. Check your error logs for problems relating to automated maintanace tasks. At

RE: Error 232

2001-09-25 Thread John McCosker
Error,TID=218,09/24/01,8:53:30,Error number 232 occurred attempting to close connection to web server. Error,TID=218,09/24/01,8:53:30,Windows NT error number 232 occurred. Our log file is full of these as well, also get occassional 109 errors can't find the definition of this one on ms site

Re: Error 232

2001-09-25 Thread Marius Milosav
Open a dos window and type : net helpmsg 232 (or whatever number you get from the logs) It will tell you the error description. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm -

Re: Error 109 (was: Error 232)

2001-09-25 Thread Todd Ashworth
I *think* the 109 is caused when a visitor hits the stop button on their browser before the page loads. Todd - Original Message - From: John McCosker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 9:21 AM Subject: RE: Error 232

RE: reading an XLS file into a query...

2001-09-25 Thread Christopher Olive
my suggestion (since i've done this exact thng) is to write a stored procedure that calls a DTS package to import the data into an SQL table. then call a second stored proc to massage it into a format that you can use. christopher olive, cio cresco technologies, inc http://www.crescotech.com

Re: `NOT in` CFQuery problem

2001-09-25 Thread W Luke
I did, but it didn't work. Then I realised that I had quote the function ('#QuotedValueList(firstquery.semail)#') which was causing the error (the first and last emails in the list came out as ''[EMAIL PROTECTED] Thanks Will - Original Message - From: Deanna Schneider [EMAIL PROTECTED]

Intranet Recommendations

2001-09-25 Thread Dharmesh Goel
Hi All, We are looking at implementing an Intranet solution here (in house). We have a small list of requirements that most intranets we evaluated do not meet. Would appreciate any suggestions. Key features that are needed: 1. Forums - Allow attachments, subscription (email

CFTRANSACTION error in CF example

2001-09-25 Thread Chad Gray
There is an error in the example code that comes with the CFStudio help file for CFTRANSACTION. I get this error: Context validation error in tag CFTRY The tag is not correctly positioned relative to other tags in the template: the last tag nested inside tag CFTRY must be a CFCATCH tag.

RE: CFTRANSACTION error in CF example

2001-09-25 Thread Mike Townend
You need to change how the try works with transaction... CFTRANSACTION CFTRY !--- Queries Here --- CFTRANSACTION ACTION=COMMIT/ CFCATCH !--- We have experienced an error...

RE: Intranet Recommendations

2001-09-25 Thread Neil Clark
'Synergy' if it is still going! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

Re: CFTRANSACTION error in CF example

2001-09-25 Thread Chad Gray
Whoops... sorry about the formatting forgot to break the HTML tags for those with HTML email programs. Question was how do i get this example to work so i can see what it is doing? Error: Context validation error in tag CFTRY The tag is not correctly positioned relative to other tags in the

RE: Intranet Recommendations

2001-09-25 Thread Stephen Moretti
'Synergy' if it is still going! Its still going http://www.evolutionb.com/ regards ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

RE: CFTRANSACTION error in CF example

2001-09-25 Thread Joel Parramore
Chad: Put the CFTRY inside the CFTRANSACTION block. Also, two CFCATCH blocks aren't needed in that code. The commitIt flag isn't really needed also unless you want it for something else outside the block. So, something like this will work: CFTRANSACTION ACTION=BEGIN CFTRY

MySQL and CFTRANSACTION

2001-09-25 Thread Chad Gray
Thanks for the code Mike. It is working now.. Kinda. Now im getting an error that my database driver does not support CFTRANSACTION Im using MySQL. So i take it i will only be able to use CFTRY and CFCATCH to watch for errors on the SQL statements? Anyone have a work around or more

Re: Hiermenus v4.1 - http://www.dhtmlab.com/ and ColdFusion

2001-09-25 Thread phumes1
I'm using this menu system along with ColdFusion. My CF code displays all the files in a specific directory with the following a href attached to each filename. a href=#name# title=Left Click here... onMouseOver=popUp('HM_Menu1',event) onMouseOut=popDown('HM_Menu1') class=dirlinks alt=#name#

RE: MySQL and CFTRANSACTION

2001-09-25 Thread Joel Parramore
MySQL hasn't support transactions very well (if at all) in previous versions. Try searching the forums for some hints. Here's one that I found: http://forums.allaire.com/coldfusion/messageview.cfm?catid=10threadid=22086 1highlight_key=ykeyword1=cftransactionkeyword2=mysql -Original

Re: Absolute Path Usage

2001-09-25 Thread Bruce Holm
What I am wanting is a relative path but relative to the web root...for portability. I have an include file that I want to include by specifying the same path every time in all files in the hierarchy. So I put this include file in /global directory and want to reference it by /global/foo.cfm,

RE: Intranet Recommendations

2001-09-25 Thread Neil Clark
sorry Steven you know what the Grapvine is like :-) ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

Re: Absolute Path Usage

2001-09-25 Thread Jeffry Houser
I didn't see the original post, so I'm jumping in the middle. At 08:15 AM 09/25/2001 -0700, you wrote: What I am wanting is a relative path but relative to the web root...for portability. I have an include file that I want to include by specifying the same path every time in all files in the

Re: Absolute Path Usage

2001-09-25 Thread Bruce Holm
See below... - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 11:30 AM Subject: Re: Absolute Path Usage I didn't see the original post, so I'm jumping in the middle. .. The way I do this is by setting a

Re: Absolute Path Usage

2001-09-25 Thread Chad Gray
Im jumping into the middle also, but have to tried adding a mapping in the CFadministrator? I had to use a path for some CFCINCLUDES that went 3 or 4 folders deep, and it works great! At 08:51 AM 9/25/2001 -0700, you wrote: See below... - Original Message - From: Jeffry Houser

RE: MySQL and CFTRANSACTION

2001-09-25 Thread Billy Cravens
Transaction support in mySQL: http://www.mysql.com/doc/M/i/Missing_Transactions.html Perhaps you could a lot of your error catching/validation inside of your mySQL SQL? --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Chad Gray [mailto:[EMAIL

RE: Error 232

2001-09-25 Thread Kevin Roche
Hi, That says : The pipe is being closed. Can anyone out there translate the description into somthing we can understand ? I can think of lots more questions now What is the pipe? Who is smoking it ? Why was it open ? Whis is it ebing closed ? Why wasn't it closed sooner ? Why is

RE: reading an XLS file into a query...

2001-09-25 Thread Billy Cravens
If you're using CF5, you can specify a connection string, so no DSN is required. That way you can access it through ODBC. Why no DSN? If you can't go that route, I have a hard time believing that your other options (COM, DTS) are available if you can't set up a simple DSN. --- Billy Cravens

Re: Absolute Path Usage

2001-09-25 Thread Bruce Holm
My hosting company controls the CF Server administration mapping. SInce they share the CF server with many other website domains, they won't be creating mappings like / to my web root. If my domain was the only one on their server (dedicated server) then I could have them do this. Thanks for

RE: Error 232

2001-09-25 Thread Chris Martinez
This is not a pipe. -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 11:15 AM To: CF-Talk Subject: RE: Error 232 Hi, That says : The pipe is being closed. Can anyone out there translate the description into somthing we can understand ?

Re: Absolute Path Usage

2001-09-25 Thread Jeffry Houser
At 08:51 AM 09/25/2001 -0700, you wrote: See below... - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 11:30 AM Subject: Re: Absolute Path Usage I didn't see the original post, so I'm jumping in the middle.

Re: MySQL and CFTRANSACTION

2001-09-25 Thread Matt Robertson
It looks as if this is fixed in myODBC 2.50.39. Appears to work on my dev server, but since I'm using myISAM table types I can't test it all the way thru. Based on the errmsgs, it looks as if the failure I'm getting is related to my table type, and not CFTRANSACTION itself. If you're using a

RE: Sql Server 2000

2001-09-25 Thread Michael Ross
This may be way off, but when I was going through I turned off File and Print Sharing on my SQL 2000 (on Win2000 Advanced) server I couldn't connect to the server either, once it was check again it worked. Then again this may be very common knowledge and I am just a idiotbut maybe it

Monitoring of Cold Fusion logs

2001-09-25 Thread Steven Monaghan
I am a new Cold Fusion Developer/Administrator and was wondering if anyone has any suggestions on what to check my logs for. I'm running on Solaris, and I have a pretty generic log monitoring script that I can use, but I'm not sure what to look for, meaning which messages are critical, and which

Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Boardwine, David L.
My office will soon be upgrading from 4.5 pro to 5.0 pro. Is there any special things I should know before the upgrade? Are there any gotchas to look out for? Any input from others that have done that migration would be helpful and appreciated. TIA, David L. Boardwine Senior Analyst Ohio

Odd Sybase error

2001-09-25 Thread Stevens, Jason
Does the following look familiar to anyone? Any clue on what might cause it? I'm unable to find anything that might explain why it is breaking or what that sybase error interprets into. Error Diagnostic Information CWebException: Error: Sybase Error Code = -106941804 Explanation:

RE: Absolute Path Usage

2001-09-25 Thread Mark Stewart
If you were to use fusebox style methodology, you would put those variables in app_locals.cfm. It's already been stated that mappings are not the answer, but that's what I use - much cleaner. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25,

RE: Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Mark Stewart
I haven't had any problems. 5 seems to be very stable and so far I'm very pleased. Mark -Original Message- From: Boardwine, David L. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 12:41 PM To: CF-Talk Subject: Upgrading from v4.5 pro to v5.0 pro My office will soon be

Long client var in Oracle [was: WDDX]

2001-09-25 Thread Chris Norloff
This is going into the CDATA column DATA - CF automatically makes it a LONG datatype in our Oracle db. It can take 2GB in that column, but each insert is limited to 4000 characters. I can't find the error no. now, but basically it directed us to use bind variables for inserting the string,

RE: Absolute Path Usage

2001-09-25 Thread Owens, Howard
If I was hosting with a company (and I've worked with many shared hosts and I use mappings on all my applications) that wouldn't set up a CFMapping for me -- I'd change hosts. There's no reason not to set up mappings for you. H. Howard Owens Internet Operations Coordinator www.insidevc.com

OT: Check out what Gartner is recommending. Drop IIS!

2001-09-25 Thread Rey Bango
Now, I've always found Gartner to sway in a particular direction based in the wind changes and the phases of the moon but this recommendation is just plain stupid. Check it out: http://news.cnet.com/news/0-1003-200-7294516.html Rey Bango ~~ Your

Re: Passing the results from the CFDIRECTORY to another template?

2001-09-25 Thread phumes1
Hi Bruce, Could there be a syntax error in the code below? This is the error I keep getting. Below the error I've attached my test file. I've removed the javascript for the popup menu. I want to get your code working first. If I comment out these two lines it runs ok. cfset

RE: Intranet Recommendations

2001-09-25 Thread Brunt, Michael
There is a good ColdFusion-Fusebox open source program that has much of what you are looking for but would need some coding work to enable the group authorization requirements you are looking for. I was trying to find a link to it for you but could not but I do have a .zip copy of it here as we

CF wish list (was: Absolute Path Usage)

2001-09-25 Thread Owens, Howard
Then you've got to surround these links with cfoutput tags. I wish Macromedia would create a new CF tag ... cfa href (or cfhref) This way you could include variables in HREF tags without the need to use output tags, a la cfinput Which brings up another wish list item ... in Studio, if you

RE: Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Costas Piliotis
I've had issues with cfgrid loading... Don't quite know why. I've even applied the hot fix,and still the applet won't load... -Original Message- From: Mark Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 9:53 AM To: CF-Talk Subject: RE: Upgrading from v4.5 pro to

Re: Absolute Path Usage

2001-09-25 Thread Stephenie Hamilton
Howard said: they won't be creating mappings like / to my web root that doesn't necessarily mean they won't set up a mapping for you, but they cannot set up a / mapping as that is already used by CF for the default root ask them to setup a mapping for /somename that points to where you

RE: CF wish list (was: Absolute Path Usage)

2001-09-25 Thread Ben Forta
Sound like a perfect little Custom Tag for you to write :-) -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 1:11 PM To: CF-Talk Subject: CF wish list (was: Absolute Path Usage) Then you've got to surround these links with cfoutput

Protecting, a, images/pics, directory?

2001-09-25 Thread Absolute 1
I am trying to make it so you have to login and be authenticated before you can view a subdirectory of images and pictures, much like I would if I used application.cfm to check authentication before .cfm files are loaded in a subdirectory. But apparently application.cfm is not run before .jpg

RE: Intranet Recommendations

2001-09-25 Thread Neil Clark
be good if you shared it with everyone.. share and share alike my man! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Re: Error 232

2001-09-25 Thread Jon Hall
http://support.microsoft.com/support/kb/articles/Q109/7/87.asp All your pipes are belong to us. jon - Original Message - From: Chris Martinez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 12:12 PM Subject: RE: Error 232 This is not a pipe.

AND OR placement in SQL

2001-09-25 Thread W Luke
Hi, Bit confused on the placement of AND OR operators in the same query. cfquery cachedwithin=#createtimespan(0,0,10,0)# name=getads datasource=#DSN# SELECT left(subject,20) as newsubject, * FROM advert_details WHERE town = '#form.towny#' OR (natpaid = Yes AND nationwide = Yes) cfif

RE: Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Pete Freitag
David, You should check out http://www.cfbughunt.org This site lists bugs people have found in CF5. You will notice I put bugs in quotes because most of the bugs listed have not been validated yet. The intention of that site is to show that CF5 is fairly bug free. There aren't any

RE: Intranet Recommendations

2001-09-25 Thread John Paitel
Mike- I would be interested in a copy of that source when you get a moment. Thanks! John At 10:14 AM 9/25/01 -0700, you wrote: There is a good ColdFusion-Fusebox open source program that has much of what you are looking for but would need some coding work to enable the group authorization

FW: CFMAIL Error

2001-09-25 Thread Hirschman, Miriam
-Original Message- From: Hirschman, Miriam Sent: Tuesday, September 25, 2001 1:36 PM To: '[EMAIL PROTECTED]' Subject: CFMAIL Error I am trying to send email with the CFMAIL tag and I am getting the following error: Error Diagnostic Information unknown exception condition

CFMAIL

2001-09-25 Thread webmaster
Does anyone know how I can send nail with cfmail and flag the message as urgent or hi-priority ? tia Richard ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community.

Re: Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Deanna Schneider
Here's one I discovered today - If you're using cfcontent to generate csv files for excel, previously you didn't need to include a #char(13)# snippet at the end of your lines. You could just hit return within a cfoutput. Now, you have to explicitly code the #char(13)# if you want a carriage

RE: Protecting, a, images/pics, directory?

2001-09-25 Thread Carlisle, Eric
I would also like to hear information on this. As far as I know, you need web server security to keep someone from accessing an image file. You can, however, prevent image names from being shown. img src=image.cfm?id=1234567890 where url.id is an encrypted filename. Inside image.cfm, do a

RE: Protecting, a, images/pics, directory?

2001-09-25 Thread Mike Townend
You could place the images outside of the wwwroot so that they are not accessable at all, then use CFCONTENT tag to display the image to the user after they have been authenticated. HTH Mike -Original Message- From: Absolute 1 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25,

RE: Upgrading from v4.5 pro to v5.0 pro

2001-09-25 Thread Billy Cravens
Check your virtual directories --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 12:18 PM To: CF-Talk Subject: RE: Upgrading from v4.5 pro to v5.0 pro I've had issues with

RE: CF wish list (was: Absolute Path Usage)

2001-09-25 Thread Pete Freitag
You can add your studio wish here: http://forums.allaire.com/visual/categories.cfm?catid=95 it turns out every time I think of something in studio I would like, its already there! Pete Freitag ([EMAIL PROTECTED]) CFDEV.COM ColdFusion Developer Resources

RE: AND OR placement in SQL

2001-09-25 Thread Costas Piliotis
When using funky and and or clauses in the where clause, it's a really good idea to use parenthesis to control the flow. It won't muck up the query, but you may not necessarily get the results you want... -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: AND OR placement in SQL

2001-09-25 Thread Steven Monaghan
My suggestion when mixing AND OR is to wrap everything in parentheses. This way there can be no confusion. SELECT left(subject,20) as newsubject, * FROM advert_details WHERE ( town = '#form.towny#' OR ( natpaid = Yes AND nationwide =

RE: formatting question

2001-09-25 Thread Snyder, Jason
What I did was to convert the query to an array, use dateformat on the field(s) that I wanted to be formatted, and then convert back to a query. This is not the most elegant solution seeing that when the user creates/modifies dates in the grid, there is no restrictions on what they enter.

Re: Long client var in Oracle [was: WDDX]

2001-09-25 Thread Deanna Schneider
I believe that you just have to use a cfprocparam ... tag to insert long or clob data into oracle - something like cfquery name=insert datasource=#dsn# username=#uname# password=#pword# INSERT INTO longtest(clientvars) VALUES(cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR

Re: CFMAIL

2001-09-25 Thread John Lucas
cfmail to= from= subject= cfmailparam name=X-Priority value=1 cfmailparam name=X-MSMAIL-Priority value=High John - Original Message - From: webmaster [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 12:40 PM Subject: CFMAIL Does anyone know how I can

Re: AND OR placement in SQL

2001-09-25 Thread Deanna Schneider
Depends on what you want it to do. Right now, it's saying, select this stuff if town is the same as the form.towny AND category is form.category OR select this stuff if natpaid is yes and nationwide is yes AND category is form.category. My guess is that what you want is: select this stuff if

RE: CF wish list (was: Absolute Path Usage)

2001-09-25 Thread Owens, Howard
I can see how a custom tag would work. But even that seems more complicated that it needs to be. A cfa href tag would be much easier to use than a cf_a href tag. I mean, it would be so easy to do (especially if you had a wizard in Studio to write this tag): cfa href=#request.mypath#/file.cfm

RE: Check out what Gartner is recommending. Drop IIS!

2001-09-25 Thread Paul Sizemore
When I read this from Gartner I rejoiced; check out how MS is responding @ http://www.theregister.co.uk/content/55/21869.html Paul Sizemore Finish Line 3308 N Mitthoeffer Rd Indianapolis, IN 46235 W: 317-899-1022 ext 3516 -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]]

Re: Protecting, a, images/pics, directory?

2001-09-25 Thread Dave Hannum
The application.cfm file does nothing to prevent directory browsing or calling of non .cfm files directly. That's set up on the web server. You can build a login script and then use CFDIRECTORY to list the image files then use CFFILE to bring them into a page to view. Dave - Original

RE: CFMAIL

2001-09-25 Thread Carlisle, Eric
is that a e-mail header? if so, use cfmailparam for that. -Original Message- From: webmaster [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 1:40 PM To: CF-Talk Subject: CFMAIL Does anyone know how I can send nail with cfmail and flag the message as urgent or hi-priority

RE: Protecting, a, images/pics, directory?

2001-09-25 Thread Costas Piliotis
Instead of using gif or jpeg files, have you considered using the cfcontent tag and using cfm files to verify the seucrity? You can use img src=somefile.cfm instead... Works like a charm. -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25,

Re: Passing the results from the CFDIRECTORY to another template?

2001-09-25 Thread phumes1
OK. It seems I have it working properly now. See attached screen captures. How would I check which link was clicked (RecNo) and match that against the (RecNo) in the fileinfo.cfm (template) and display the filename. Sorry for asking so many questions but this is kinda over my head. Thanks

Re: Passing the results from the CFDIRECTORY to another template?

2001-09-25 Thread phumes1
Opps. Forgot to attach the screen captures. At 11:44 AM 9/24/01 -0700, you wrote: Make sure you have session management activated...then cfdirectory name=queryName ... !--- Create a new structure for each column of info you want --- cfset Session.stDirFileName = StructNew() cfset

RE: CF wish list (was: Absolute Path Usage)

2001-09-25 Thread Owens, Howard
Thanks. I've done that before. Maybe some other people -- if they think it's a good idea -- need to make the request. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Pete Freitag [SMTP:[EMAIL

Grab formated text from file and put in database

2001-09-25 Thread P Broussard
I have some text files to be used in the Meal-Master program. The files are delimeted but I am not sure how. I want to read the ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

Re: CFMAIL

2001-09-25 Thread Howie Hamlin
Sure. Just use CFMailParam like: cfmail ... cfmailparam name=X-priority value=1 cfmailparam name=X-MSMail-Priority value=High .. /cfmail HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The

Grab formated text from file and put in database Doh!!

2001-09-25 Thread P Broussard
Sorry, I sent it to early. :) I have some text files that were to be used in the Meal-Master program but now I need to put them in a database. The files are delimited but I am not sure how. I want Coldfusion to read the file, treat it like a list, and then insert it into the database. I just

Re: CFMAIL

2001-09-25 Thread admin
John, Thank you ever so much !! Richard - Original Message - From: John Lucas [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 10:55 AM Subject: Re: CFMAIL cfmail to= from= subject= cfmailparam name=X-Priority value=1 cfmailparam

RE: Absolute Path Usage

2001-09-25 Thread Shawn Grover
cfinclude can only take relative paths. To get around this issue with my templates, I used CFHTTP to read the file in question (page header and menu), then dump the resulting text to my page in the appropriate locations. This is nice because CFHTTP uses absolute paths, and saves me the hassle

SQL Query Quandary

2001-09-25 Thread Jim McAtee
I've got three tables describing lodging properties and their amenities, as shown below. If a lodging property has more than one amenity (for example, hot tub, min-ibar, fireplace, etc) then there are multiple records for that property in the property_amenities table. Pretty basic stuff.

Re: CF 5.0 Management Repository Server

2001-09-25 Thread Neil H.
Have you heard anything about CFgraph and JVM problems? Thanks, Neil - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 27, 2001 3:16 PM Subject: RE: CF 5.0 Management Repository Server I have noticed that the service CF

Re: Check out what Gartner is recommending. Drop IIS!

2001-09-25 Thread Rey Bango
Paul, Rejoicing for a more secure product is certainly understandable but Gartner's recommendation to dump IIS altogether is just plain dumb. Replacing every IIS box makes absolutely no business sense and the cost would be astronomical. In addition, a bigger part of the issue is the way

Fwd: Re: Passing the results from the CFDIRECTORY to another template?

2001-09-25 Thread phumes1
Opps. Forgot to attach the screen captures. OK. It seems I have it working properly now. See attached screen captures. How would I check which link was clicked (RecNo) and match that against the (RecNo) in the fileinfo.cfm (template) and display the filename. Sorry for asking so many

RE: Absolute Path Usage

2001-09-25 Thread Jeffry Houser
Aren't there efficiency considerations for using CFHTTP? I don't think choosing a solution because Then I don't have to code correctly is a good reasoning. At 12:51 PM 09/25/2001 -0600, you wrote: cfinclude can only take relative paths. To get around this issue with my templates, I used

  1   2   3   >