RE: tracing where users are from

2002-01-10 Thread Declan Maher
This is an email (from an ASP mailing list called 4guysfromrolla.com) which discusses checking where a user is from. Hope it helps. One question that is often asked on the ASPMessageboard is: How can I determine where someone is located, by grabbing their IP, either so the page can be

Re: tracing where users are from

2002-01-10 Thread Paul Hastings
This is an email (from an ASP mailing list called 4guysfromrolla.com) which discusses checking where a user is from. Hope it helps. wow thats quite a tour. another, less intensive idea (which just came to me), might be to look at cgi.HTTP_ACCEPT_LANGUAGE which also returns a locale (us) as

AllaireMIB Error

2002-01-10 Thread Erika L Walker-Arnold
Have any of you guys run across this in your event logs on a Win2k Server running CF 5 ... Event Type: Error Event Source: Allaire AllaireMIB Event Category: None Event ID: 3 Date: 11/26/2001 Time: 2:36:58 PM User: N/A Computer: servername

RE: ALTER TABLE syntax

2002-01-10 Thread Aidan Whitehall
Should be more like this shouldnt it? ALTER TABLE test ADD COLUMN testNum BYTE NOT NULL WITH DEFAULT 5 You need the WITH clause. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q266694 has ALTER TABLE Test ADD TestColumn INT NOT NULL DEFAULT -1 for use in SQL Server. Doesn't

SQL Help

2002-01-10 Thread Waldemiro Junior
Hi Folks. How can I know the next value to be inserted in an Identity field data type (MS SQL Server)? When I put this query: SELECT MAX(COD_REQ) FROM TAUX_001 it returns the value 10, which corresponds correctly to what its recorded on the table, but when I insert something in it, after

Overwriting a session

2002-01-10 Thread Kay Smoljak
Hi all, Basically, I don't like relying on cookies, so I code my apps appending the cfid and cftoken to each link where session variables are required. At the beginning of each page request I do cfset token = cfid/#session.cfid#/cftoken/#cftoken#/ (I'm using search engine safe URLS) and then I

Re: Sorting multi-dimensional arrays?

2002-01-10 Thread Matt Kornguth
Tried that. Get the error message: The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/ time values. Queries, arrays, and COM

hair-tearing Jet SQL problem!

2002-01-10 Thread Gyrus
OK, I'm having real difficulties getting some table creation Jet SQL code working. The DEFAULT keyword doesn't seem to work. I was trying to using it in an ALTER TABLE statement, but some people here alerted me to the fact that there are problems adding fields to exisiting tables if you specify

RE: Sorting multi-dimensional arrays?

2002-01-10 Thread Allan Pichler
There should be a custom tag available to sort multidimensional arrays! can't remember the name though! @llan -Original Message- From: Matt Kornguth [mailto:[EMAIL PROTECTED]] Sent: 10. januar 2002 14:57 To: CF-Talk Subject: Re: Sorting multi-dimensional arrays? Tried that. Get the

RE: how to prevent user from opening multiple browsers..

2002-01-10 Thread Mark Stewart
You can capture the users IP with the cgi.remote_addr variable and either place it in your db or an application scoped array or structure. Storing it in a cookie, client or session variable is no good since those variables would be user specific. If it were me, I would go with the application

Re: CF Mappings

2002-01-10 Thread Chris Norloff
Mappings aren't required (though the two default mappings might be). I just recently added a mapping for some error-handling code - it's nice to be able to include the code from ANYWHERE and let it rely on the mapping t o run. Otherwise, each code insertion would have to have the relative path

Re: CF Mappings

2002-01-10 Thread Chris Norloff
You CAN use them with cfinclude and cfmodule, but you don't have to. cfincl ude and cfmodule work fine with relative paths or by running in the current directory. I've found they don't work well with absolute paths (in my experience they' ll work sometimes but are not robust). Chris Norloff

simulating stored procedures in MS Access?

2002-01-10 Thread Birgit Pauli-Haack
in know this sounds wired:-) But I remember some article somewhere that someone has found a way so simulate stored procedures for Access datasources. Does anybody know more? could have been CFDJ (no luck) Fusion Authority or some place else... -- Best regards, Birgit Pauli-Haack

Re: CF Mappings

2002-01-10 Thread Chris Norloff
-- Original Message -- from: Jennifer Larkin [EMAIL PROTECTED] There are some times where a mapping is an extremely good idea, like when you have two sites on the same server and there is a different webroot for each site but there are elements from one

Access violation when deploying from project: why?

2002-01-10 Thread letters
I've started getting Access violations when I deploy a file from a project. I haven't changed anything on my system, but the problem appeared last night. Here's the error: Access violation at address 0082516D in module 'cfstudio5.exe'. Read of address 0328. My system: Win2000 Pro. Thanks for

Re: Weird Join (o8i)

2002-01-10 Thread Troy Simpson
Bryan, Thanks. This is a good solution. I wish I had known this earlier. I ha ve other issues where this would work perfect. But in this case, I am unable to utilized the Order By for this query in the way you described. I should have clearified this. There is a SCORE column that I am using

RE: AllaireMIB Error

2002-01-10 Thread Beau Harbin
Erika, I recently ran across these as well and talked to my server guy. He thinks they are from the Management and Monitoring services that come with CF 5. I have since disabled those services and am waiting to see if I still get the error. It was fairly random in the past, so it may take a

Re: simulating stored procedures in MS Access?

2002-01-10 Thread Dave Carabetta
Here ya go... http://www.sys-con.com/coldfusion/article.cfm?id=51 Incidentally, I got this from Systemanage's web site, which where Charlie Arehart, a pretty well-known CF guru puts up his CF contributions. I don't know him or have any connection with his company but have always found his

Re: simulating stored procedures in MS Access?

2002-01-10 Thread Jochem van Dieten
Birgit Pauli-Haack wrote: in know this sounds wired:-) But I remember some article somewhere that someone has found a way so simulate stored procedures for Access datasources. There is no need to simulate, stored procedures are supported. The problem is that the only procedural language

best technique for repopulating multi-page forms

2002-01-10 Thread stas
Hello, I have a fusebox (2) app that stores user data in the database. I need to create a mechanism to allow users to change their data. Now, I've done this in the past many times, but some of my new forms are wizard like (multi-page), and I am soliciting opinions on what methods you guys are

RE: Overwriting a session

2002-01-10 Thread Joel Parramore
You're using the cfid and cftoken values in the url but set a cookie anyw ay as a fallback? If that's the case... you could use an IsDefined(session.cfid ) check instead of the cftry-cfcatch (or in addition to, depending on how y ou've laid out error handling. If the session.cfid is defined,

Re: simulating stored procedures in MS Access?

2002-01-10 Thread Birgit Pauli-Haack
Thanks Dave, great resources indeed. Birgit Thursday, January 10, 2002, 10:02:21 AM, you wrote: DC Here ya go... DC http://www.sys-con.com/coldfusion/article.cfm?id=51 DC Incidentally, I got this from Systemanage's web site, which where Charlie DC Arehart, a pretty well-known CF guru puts

RE: CF Mappings

2002-01-10 Thread Chris Norloff
That's slightly different - you're then using an absolute path in the cfinc lude or cfmodule. I've had problems with that - it just wasn't robust for me (CF 4.5 SP2 on Solaris; Oracle 8i). That's why I went to mappings, even though it requires a server configurati on. Chris Norloff

CLIENT variable questions

2002-01-10 Thread Dave Carabetta
I have inherited an application that makes fairly extensive use of CLIENT variables (nothing complex, just simple user preferences in a multi-server environment), but poorly manages them. I have been tasked with the cleanup and maintenance of them, and I have a couple of questions regarding

CFMail

2002-01-10 Thread Dave Clay
Any ideas why this will wount work in CF 5: CFQUERY name=getEmail dataSource=AUTOMATION maxRows=1 SELECT * FROM Jobs WHERE RecID = #session.RecordID# /CFQUERY CFIF #getEmail.status# EQ 4 cfmail query=getEmail to=#email# from=[EMAIL PROTECTED] subject=Work Order SubmissionThe

WDDX on Solaris?

2002-01-10 Thread Ian Lurie
Hi all, Does ColdFusion 4.1 on Solaris support WDDX? Any horror stories I should know about? Thanks, Ian Lurie Portent Interactive Using Process, Design and Content to create great web sites since 1995 Consulting, design, development, measurement http://www.portentinteractive.com

Re: CFMail

2002-01-10 Thread Jochem van Dieten
Dave Clay wrote: Any ideas why this will wount work in CF 5: cfmail problem Any help would be greatly appreiated. What is in your mail.log file? Jochem __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB

verity and html comments round II

2002-01-10 Thread phillip
is there any special configuration you have to use in order to have verity index commented out html text? a co-worker has indexed a bunch of html pages that have the word orgeon in them many times within commented out html. the only pages that verity is returning are the ones that have oregon

calling .sql scripts with CF and MySQL: how to?

2002-01-10 Thread letters
I'm still getting my head around the MySQL/Solaris combination with CF -- sorry if this question is very basic. I want to call .sql scripts from the MySQL database via CF. How can I do this? Thanks, Marc Garrett __ Dedicated

Quanta?

2002-01-10 Thread Chris Montgomery
Anyone ever used Quanta for developing CF pages? If so, what are your experiences with it? Here'a a mention in the Linux Today Newsletter (1/9/02): LINUXPR: THEKOMPANY.COM RELEASES QUANTA GOLD VERSION 3.3.2 WITH ZOPE AND COLDFUSION SUPPORT Quanta Gold is designed for the professional web

RE: CFMail

2002-01-10 Thread Nick Betts
First of all, try scoping the email variable with Queryname to avoid any ambiguities. Another method is to set the variables first : eg cfset sEmail = query.email then refer to sEmail in CFMAIL tag instead of query.email. Regards, Nick -Original Message- From: Jochem van Dieten

RE: Quanta?

2002-01-10 Thread Jesse Noller
Hmm. I ought to load up KDE to try it out. I've heard good things. /effiete gnome slob === Jesse Noller Linux Muliercula Macromedia Server Development [EMAIL PROTECTED] Frisbeetarianism (n.), The belief that, when you die, your soul goes up on the roof and gets stuck there.

RE: AllaireMIB Error

2002-01-10 Thread Michiel Boland
I recently ran across these as well and talked to my server guy. He thinks they are from the Management and Monitoring services that come with CF 5. I have since disabled those services and am waiting to see if I still get the error. It was fairly random in the past, so it may take a few

Re: Quanta?

2002-01-10 Thread Billy Cravens
I've used Quanta (for PHP, not CF development). It's not a bad editor, but it doesn't have the power of Studio. Once they offer (do they?) the ability to extend the IDE with user-defined toolbars and wizards (similar to VTML), it will be very cool. (I know they say they support CF, but I get

Re: calling .sql scripts with CF and MySQL: how to?

2002-01-10 Thread Billy Cravens
I don't think there's a way to do it using CFQuery, since the method requires directing a file into the mySQL client via command line. Your best bet seems like CFExecute. (I'm assuming this is available for Solaris - I'm absolutely ignorant on CF/Solaris) - Original Message - From:

Re: calling .sql scripts with CF and MySQL: how to?

2002-01-10 Thread Billy Cravens
Why no just CFFile the .sql file, and include the contents of the file in a CFQuery - this isn't exactly what you're looking for, but it gives you same results. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 10:26 AM Subject:

RE: verity and html comments round II

2002-01-10 Thread Dave Watts
is there any special configuration you have to use in order to have verity index commented out html text? a co-worker has indexed a bunch of html pages that have the word orgeon in them many times within commented out html. the only pages that verity is returning are the ones that have

RE: verity and html comments round II

2002-01-10 Thread phillip
nah, that's just my quick, sloppy typing of the word oregon :)... so i take it there are no special verity settings. phillip On Thu, 10 January 2002, Dave Watts wrote: is there any special configuration you have to use in order to have verity index commented out html text? a co-worker

RE: WDDX on Solaris?

2002-01-10 Thread Dave Watts
Does ColdFusion 4.1 on Solaris support WDDX? Any horror stories I should know about? I'm pretty sure that it does, and without any serious problems. Any platform that supports Spectra runs WDDX. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202)

Re: verity and html comments round II

2002-01-10 Thread Billy Cravens
Here's my 30-second workaround - CF process that grabs source from all the pages, strips out comment indicators (but keeps text of comments), sticks text into db. Then verity against the db, and have pointers to the true url in the database, which are then output as the result of your verity

CFMAIL problem - not sending, stuck in spool

2002-01-10 Thread Melissa Fraher
I have a problem with Cold Fusion sending out email and was just wondering if you have any advice. When the mail is generated it sits in a folder named SPOOL. If it gets sent, it disappears from the SPOOL. If it cannot be delivered in 60 seconds it goes to the UNDELIVERABLE folder. For some

Re: CFMAIL problem - not sending, stuck in spool

2002-01-10 Thread Don Vawter
Get the resendmail tag from the tag gallery - Original Message - From: Melissa Fraher [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 10:20 AM Subject: CFMAIL problem - not sending, stuck in spool I have a problem with Cold Fusion sending out email and

RE: verity and html comments round II

2002-01-10 Thread Andrew Tyrone
One trick I've used with dynamic pages using include files for header and footer is to set a pagetitle variable in the main file for each page, which I call the content page. The included header will be the page that h as the html title tags, and it will use the pagetitle variable to output

RE: AllaireMIB Error

2002-01-10 Thread Mark A . Kruger - CFG
Michael, Yes - we had the same experience with the monitor, we actually had to generate a script to restart our web server services. It starts with killing the monitoring service. If you find a way to disable this behavior let me know. It is probably not needed in Win2k because a restart

Re: SQL Help

2002-01-10 Thread Douglas Brown
I am not sure what is happening. It should not insert a value of 101 if your max is 10. Say I have a table that only has 7 rows because I deleted 3 and my max is ten, when I insert it should give me 11. I always hated identity fields, that is why I do not use them. There are two major

flash components: calendar

2002-01-10 Thread Billy Cravens
I'm trying to use the Flash Components kit's calendar widget. I'm using it in inline mode for date selection. The custom tag creates a hidden form field for the field that I specify, but no matter what I select in the calendar, it always passes a zero-length string. Does this widget work

RE: SQL Help

2002-01-10 Thread Bill Grover
The system is working as designed. The identity column keeps incrementing the number to use. so if you do 100 inserts then delete 90 records the next ID used will be 101. The question is, why do you need this number? The usual places where I've seen it needed is when you are doing an

Re: SQL Help

2002-01-10 Thread Waldemiro Junior
Thanks a lot Bill - Original Message - From: Bill Grover [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:17 PM Subject: RE: SQL Help The system is working as designed. The identity column keeps incrementing the number to use. so if you do 100

RE: reading text file contents intro a database

2002-01-10 Thread Mark Stewart
If you're using SQL Server 2K, I would use a DTS Package to do this. Mark -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 3:57 PM To: CF-Talk Subject: reading text file contents intro a database I need to read the contents of a comma or tab

RE: flash components: calendar

2002-01-10 Thread Angel Stewart
The widget is f***ked up. You need to DOUBLE CLICK the date you select in order for it to register. At least this works in Internet Explorer. Doesn't seem to work at all in Opera. A real shame :( -Gel -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] I'm trying to

Re: SQL Help

2002-01-10 Thread Dick Applebaum
In SQL Server, identity fields, a number is never reused... deletes do not reset the counter to the next available identity value. When you think about what goes on under the covers (of SQL), it makes sense. SQL would need to maintain a linked list (or somesuch) of deleted identity values to

OT: Javascript Help

2002-01-10 Thread clint
I know this is off topic, but it kinda isn't. Can someone show me how to add 5 minutes to now in javascript? I am having a hard time finding how to do this. Thanks! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM /

Step in the rigth direction --Developer Edition

2002-01-10 Thread Jason Kufner
I just wanted to point this out to everyone on the list. With all the talk about the 'death of coldFusion' I think this is a real step in the right direction. I've already convinced one client to use ColdFusion BECAUSE their IT department could poke around and use this Developers' Edition to

RE: flash components: calendar

2002-01-10 Thread Andre Turrettini
hmm. Thats strange. I've seen it work great. DRE -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:38 AM To: CF-Talk Subject: RE: flash components: calendar The widget is f***ked up. You need to DOUBLE CLICK the date you select in

Re: OT: Javascript Help

2002-01-10 Thread savan . thongvanh
var fiveMinutes=30; //milliseconds in 5 minutes var now = new Date(); var temp=now.getTime() //temp=now in milliseconds var newTime=new Date(eval(temp+fiveMinutes)); //newTime is now 5 minutes from now or trimmed down var newTime=new Date(new

Re: flash components: calendar

2002-01-10 Thread Billy Cravens
Yeah, double clicking seemed to do the trick - this is unacceptable, so it looks like I'll go with a DHTML calendar. Any suggestions? - Original Message - From: Angel Stewart [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 12:38 PM Subject: RE: flash

Multiple Records from Oracle SP

2002-01-10 Thread Issac Rosa
I understand that Oracle SPs only return 1 record. Has anyone found a workaround for this and used the SPs in ColdFusion? I found the following response from an Oracle Forum discussing how to get multiple rows from a stored procedure. Does anyone know if this would work and can this be called

RE: Problem with QuerySetCell

2002-01-10 Thread Tammy Hong
Hi Bryan, Your suggestion worked really well. I have one additional question though. The UNION ALL returns all information from both select statements; howeve r, when I output the query I noticed that if a dept is missing from either result, it will fill in the data of the one that exists. Is

Re: Javascript Help

2002-01-10 Thread Don Vawter
d=new Date(); alert(d); d.setHours(d.getHours()+5); alert(d); - Original Message - From: clint [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 11:35 AM Subject: OT: Javascript Help I know this is off topic, but it kinda isn't. Can someone show me how

Re: hair-tearing Jet SQL problem!

2002-01-10 Thread Joseph Thompson
I can't wait to see if there is a solution here. I have come up against this problem again and again. I have been able to read the field types with ADO but... modifying those has been a little mystifying. I got about this far and then gave up on it. http://cfhub.com/advanced/ado/ I was

Re: CFMAIL problem - not sending, stuck in spool

2002-01-10 Thread Melissa Fraher
Don - Thank you for the response. Actually , it won't send any mail right now because one piece of mail is in the spool and I can't delete it. So even when I manually drag undeliverables into the spool, they won't go out. Any ideas out there? Thanks. Melissa Don Vawter wrote: Get the

Re: verity and html comments round II

2002-01-10 Thread Joseph Thompson
That is my prefered method :-) Here's my 30-second workaround - CF process that grabs source from all the pages, strips out comment indicators (but keeps text of comments), sticks text into db. Then verity against the db, and have pointers to the true url in the database, which are then

Re: OT: Javascript Help

2002-01-10 Thread Alex
www.irt.org On Thu, 10 Jan 2002, clint wrote: I know this is off topic, but it kinda isn't. Can someone show me how to add 5 minutes to now in javascript? I am having a hard time finding how to do this. Thanks!

Re: Step in the rigth direction --Developer Edition

2002-01-10 Thread Kevin Miller
Ditto. Smart move. Kevin [EMAIL PROTECTED] 01/10/02 11:06AM I just wanted to point this out to everyone on the list. With all the talk about the 'death of coldFusion' I think this is a real step in the right direction. I've already convinced one client to use ColdFusion BECAUSE their IT

Help Quick!

2002-01-10 Thread Neil H .
I am trying to determine when a page doesn't exist by using the missing page handler in CF. How do I determine what the actual page is? Thanks, Neil __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB

concatenate blank fields in access and SQL

2002-01-10 Thread Mark W . Breneman
Is there a way to concatenate two fields in access when one of them are blank? Select Title + ' '+ subtitle as fulltitle from table Fulltitle is blank when ether field is blank. Does any one know if this works in SQL server 7. Thanks! Mark W. Breneman -Macromedia Certified ColdFusion 5

UK post-code tags

2002-01-10 Thread W Luke
Hi, Seen one newish tag that can retreive addresses based on UK Post Codes [1], but was wondering if anyone knew of a free one available. Client doesn't want to have to pay extra, but will do if absolutely necessary. Cheers Will [1]

OT: Returning Error Message from SQL to ColdFusion

2002-01-10 Thread Gary Ashbaugh
I have a stored procedure that contains several validity checks and raises an error message if it finds it otherwise it updates the record, such as: If @Phone is NULL Select @ErrMsg = @ErrMsg + 'Phone Required. ' If Len(@ErrMsg) 0 Begin Raiserror

Re: CFMail

2002-01-10 Thread Melissa Fraher
Dave - This might sound obvious, but are you sure that session.RecordID is being set properly? Are you sure that your query has records? Try outputting the variables on screen just to check. If you comment out the cfif statement will it work? I usually try commenting out one piece of the code

RDS - my turn for problems :(

2002-01-10 Thread Judith Taylor
Well, I've upgraded my development server to CF5and my Studio to version 5...now for some reason, whenever I click on 'localhost' in my database tag (in Studio), I get the error The connection to the server cannot be established. I have tried everything, including uninstalling both Studio

Re: CFMAIL problem - not sending, stuck in spool

2002-01-10 Thread Billy Cravens
Wouldn't this tag only handle mail that is in the UNDELIVERABLE folder? If so, this has nothing to do with Melissa's problem. - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 11:13 AM Subject: Re: CFMAIL problem - not

Re: Step in the rigth direction --Developer Edition

2002-01-10 Thread Billy Cravens
Of course, if the user had a liscensed copy of CF Studio, it included the developers copy of CF Server. I'd think you'd make CF Studio (liscensed, not trial) one of your class requirements. - Original Message - From: Jason Kufner [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

Re: OT: Javascript Help

2002-01-10 Thread Dick Applebaum
theDate = new Date(); myMinutes = 5 + theDate.getMinutes(); At 1:35 PM -0500 1/10/02, clint wrote: I know this is off topic, but it kinda isn't. Can someone show me how to add 5 minutes to now in javascript? I am having a hard time finding how to do this. Thanks!

Re: Help Quick!

2002-01-10 Thread Alex
Thanks for providing all the information needed to solve your problem. From what I can see if someone asks for www.site.com/blah.cfm and blah.cfm doesn't exist you want to read the web surfers mind and find out where they wanted to go. Try cf_mindreader from the developers exchange. On Thu, 10

Re: RDS - my turn for problems :(

2002-01-10 Thread Douglas Brown
What does you properties say for you localhost RDS in my computer? Does it have a pssword? Does it display 127.0.0.1? There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From:

Deleting Projects in Studio - Yes.. Again!

2002-01-10 Thread Lee Fuller
Still wondering.. Has anyone found a way to delete unwanted projects from Studio yet? The docs say to select Project - Delete. There IS no Project - Delete function. Nor can one right-click on the project. You can right-click on the folders once the project is open, and remove them. But

Re: Help Quick!

2002-01-10 Thread William Wheatley
Such a smarty pants I THINK he meant to ask when someone hits a page that is non existent how do you find it and fix any links. And you would be able to find that in the WEB SERVER logs for one. Hope that helps Neil, sometimes all the information you need is available upon closer evaluation

Re: Step in the rigth direction --Developer Edition

2002-01-10 Thread Jeffry Houser
That is a pretty expensive requirement for a class isn't it? Even with an education discount, it's still over $100, right? At 01:45 PM 01/10/2002 -0600, you wrote: Of course, if the user had a liscensed copy of CF Studio, it included the developers copy of CF Server. I'd think you'd make CF

RE: concatenate blank fields in access and SQL

2002-01-10 Thread C. Hatton Humphrey
Is there a way to concatenate two fields in access when one of them are blank? Select Title + ' '+ subtitle as fulltitle from table Fulltitle is blank when ether field is blank. Does any one know if this works in SQL server 7. Is SQL server adding a NULL field to anything turns the

Re: Help Quick!

2002-01-10 Thread Don Vawter
I use IIS to redirect all errors to a handling template. If it is not a cf template the cgi.query_string looks like this: 404;http://www.cyberroomies.com/robots.txt If it is a cf template you can find it cgi.script_name BTW a trick I use is that if the missing object is an image I use

Re: Help Quick!

2002-01-10 Thread Jochem van Dieten
Neil H. wrote: I am trying to determine when a page doesn't exist by using the missing page handler in CF. How do I determine what the actual page is? CGI.query_string I think. If it is not usefull try them all ;) Jochem

RE: Step in the rigth direction --Developer Edition

2002-01-10 Thread Ken Wilson
I'd think you'd make CF Studio (liscensed, not trial) one of your class requirements. I would think requiring an upfront investment in Studio would cut down on attendance amongst those who aren't already familiar with CF. Particularly when Homesite and other editors can be used quite easily.

RE: Help Quick!

2002-01-10 Thread C. Hatton Humphrey
I don't think any variables or values are actually passed to the page designated as your missing template handler. Although, you might be able to make use of some of the CGI variables... maybe HTTP_REFERER or CF_TEMPLATE_PATH or something along those lines. Hatton -Original Message-

Re: Deleting Projects in Studio - Yes.. Again!

2002-01-10 Thread Bruce Sorge
What version of Studio are you using? I am on 5.0 and this is the way to de lete them. If I right-click on my project, I am offered the option to delet e it. -- Original Message -- From: Lee Fuller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu,

Re: concatenate blank fields in access and SQL

2002-01-10 Thread Tony Schreiber
Blank or NULL? Is there a NVL function in SQL7 like in Oracle? If so you could do Select NVL(title,'')... Which would just give you an empty string when the title is NULL... Is there a way to concatenate two fields in access when one of them are blank? Select Title + ' '+ subtitle as

Re: Deleting Projects in Studio - Yes.. Again!

2002-01-10 Thread Don Vawter
Just use explorer and delete the project file (whatever.apf) You can also right click on project root node and delete it. The above works in Studio 4.51. No experience with 5.0 - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January

Re: RDS - my turn for problems :(

2002-01-10 Thread Judith Taylor
Through the CF Administrator, I have it set to not use/require a Studio password. This is not a problem as this is a development only box. And yes, the properties for my localhost RDS are set to 127.0.0.1 Thanks anyway, Judith Douglas Brown put into words: What does you properties say for

Re: Deleting Projects in Studio - Yes.. Again!

2002-01-10 Thread Douglas Brown
Same way for 4.5 There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Lee Fuller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 1:09 PM

Re: Help Quick!

2002-01-10 Thread Alex
On Thu, 10 Jan 2002, William Wheatley wrote: I THINK he meant to ask when someone hits a page that is non existent how do you find it and fix any links. Oh, then put a cfmail tag in your missing page template with diagnostics. Also, run a link checker on your site --there are a lot

RE: Help Quick!

2002-01-10 Thread Andrew Tyrone
Neil: From the CF Documentation: To set up the missing template Handler: In the ColdFusion Administrator, click Settings. The system displays the Server Settings page. Specify the absolute path the server uses to find the missing templat e handler

Re: Help Quick!

2002-01-10 Thread Jochem van Dieten
Don Vawter wrote: BTW a trick I use is that if the missing object is an image I use cfcontent to serve a substitute place holder image so you don't get a broken image link I use the same so I don't have to put a favicon in every folder. Jochem

RE: UK post-code tags

2002-01-10 Thread Kola Oyedeji
Will I think you may have to talk the client into coffing up, I once looked into this and I think the only free option I could find was importing postcodes from a textfile and even then it wasnt the full postcode. You could use http to grab a postcode from the royalmail site but this is kind of

Re: RDS - my turn for problems :(

2002-01-10 Thread Douglas Brown
Well, not sure but have you tried setting your hostname from 127.0.0.1 to machineName.domainName.com There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Judith Taylor [EMAIL

Re: Help Quick!

2002-01-10 Thread Neil H .
Uhh yeah. I guess I understood the problem and wasn't clear. Plus I was in the midst of fixing a screw up :) Any way I think the problem is ok and I have fixed it, but it seams like I have a cfmail tag in my 404 page and its emailing me like 15 times for each missing page. Strange?! Neil

Re: Help Quick!

2002-01-10 Thread Neil H .
I am a little confused. I didn't think IIS could catch missing CFM pages?! Neil - Original Message - From: Don Vawter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:29 PM Subject: Re: Help Quick! I use IIS to redirect all errors to a handling

Re: Help Quick!

2002-01-10 Thread Neil H .
Alex, We replaced several pages on this site so I want a 404 page to catch pages that we replace or moved to a more logical place :) Thanks, Neil - Original Message - From: Alex [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 4:41 PM Subject: Re: Help

Re: Quanta?

2002-01-10 Thread Nick Texidor
Alternately you could use jEdit! :^) It runs on Linux Windows, so you could use the same environment on both platforms. jEdit, IMO, is closer to Studio than Quanta is... it includes code collapsing, syntax highlighting etc... it also supports plugins that include options for FTP, Code Aid,

Re: RDS - my turn for problems :(

2002-01-10 Thread Judith Taylor
Douglas Brown put into words: Well, not sure but have you tried setting your hostname from 127.0.0.1 to machineName.domainName.com That also errors out in that it's a dns erroraddress or name could not be resolved. Thanks anyway. Judith Judith Taylor Freelance ColdFusion Developer -

Re: Help Quick!

2002-01-10 Thread Billy Cravens
It can. (I think this might be IIS5+ - but I could be wrong) look at the app mappings (properties of web site, Home Directory, Configuration, Edit a mapping) and you'll see an option for Check that file exists - Original Message - From: Neil H. [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: Help Quick!

2002-01-10 Thread Billy Cravens
Actually, there's no mind reading involved. You know the URL they are looking for, as well as any variables GET'ed or POST'ed. Easy enough to look at that information and develop a method for redirecting the user (possibly a database of moved pages, or a lookup for common typos of URL's) -

  1   2   >