Re: Text searching in Oracle

2003-03-17 Thread Thomas Chiverton
On Saturday 15 Mar 2003 19:33 pm, Matt Robertson wrote: Can this be done with CF and one of the other long types, assuming CF 4.5? MX? Maybe you need to redefine the problem. Why are you trying to do a 'like' on a number ? I ask because

RE: Text searching in Oracle

2003-03-17 Thread Pascal Peters
CF_SQL_LONGVARCHAR has nothing to do with the numeric type long. It is used to describe text fields with a very large number of characters. As he is using Oracle, it will probably be a field of type CLOB (or maybe LONG and then he should switch to CLOB). -Original Message- From: Thomas

IE for PPC

2003-03-17 Thread Shahzad.Butt
Hello At the beggining of my application I want to make a check if user is coming from Hand Held device (Palm top etc with pocket pc) then CFLocation. What is best way to check if user is using pocket pc? Using CGI variable i am getting following string from my handheld device.

RE: IE for PPC

2003-03-17 Thread Robertson-Ravo, Neil (RX)
wont a list check for PPC do it? -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 11:24 To: CF-Talk Subject: IE for PPC Hello At the beggining of my application I want to make a check if user is coming from Hand Held device (Palm top etc with pocket

Re: IE for PPC

2003-03-17 Thread jochemd
Quoting Shahzad.Butt [EMAIL PROTECTED]: I can compare this string but in future we will have different devices then i've to change the code and put another IF. Is it only option i've got? It depends on *why* you want to know if the device is a handheld. If it is just for reasons of output

Using createUUID()

2003-03-17 Thread FlashGuy
Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF?

RE: Text searching in Oracle

2003-03-17 Thread Hays, Duncan
I ran into this with some short news type items that were displayed on our web site with FileMaker/Lasso. FileMaker, Access, 4D and some other smaller db's have text or memo fields that hold 32k or more. The similar data type in Oracle 8 is varchar2(4000). So I put the body of the news record in a

RE: Using createUUID()

2003-03-17 Thread Tangorre, Michael
Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),mmdd)##Rand()##Rand()# -Original Message- From: FlashGuy [mailto:[EMAIL

Matrix problem

2003-03-17 Thread rick
I'm not very experienced at this, but I need to create a report that creates a matrix (the number of times where, say, column f intersects the row 5). I see how I can work the query (a kind of Where F AND 5 statement--other approaches appreciated). But I'm at a loss about how to output it so

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil

RE: Using createUUID()

2003-03-17 Thread Sicular, Alexander
I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE:

RE: Using createUUID()

2003-03-17 Thread Randell B Adkins
But that would not make it unique I would not think. However if you have a DB, simply have a table and increment the field by one each time you need a unique ID. Field 1: ID (Autonumber) (seed 1000) Field 2: Prefix (text) example CT Then use #Prefix#-#Numberformat(ID,00)# Something like

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... sic/ The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. AFAIK

RE: Using createUUID()

2003-03-17 Thread Tony Weeg
but not the first four...the whole uuid in and of itself, would be, however, you could conceivably get the same striking everything but the first four ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce

RE: Using createUUID()

2003-03-17 Thread Sicular, Alexander
Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: CF-Talk Subject: RE: Using createUUID() erm... I would say that they are unique. No UUID is the same

RE: Using createUUID()

2003-03-17 Thread Tony Weeg
ran this, and got those, not too unique using the first four...maybe he could mid() some part of it, towards the end of a uuid, that looks to be unique... cfloop from=1 to=10 index=i cfoutput

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
not sure what the odds could be : its not 1 in a thousand, I see your point, but in this instance, just include more chars or add your own rand function... though, Rand again but definition is not 'unique', there is a chance you could get the same ID. N -Original Message- From: Tony

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
have done/been doing for weeks now with no probs :-) -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using createUUID() Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. -Original Message-

RE: Using createUUID()

2003-03-17 Thread Jason Lees (National Express)
The point of a UUID is not to use the first four characters, but to use the whole ID Jason Lees Development Team Leader National Express Systems. -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using

Re: Can someone walk me thru changing my ALT-3 shortcut?

2003-03-17 Thread Jeff
OK, I've tried following those same steps, and the shortcuts just don't take. So far I've: 1. Created a copy 2. Navigated to the Surround With Comment option 3. Typed CTRL+3 4. Clicked Changed 5. Confirmed the override 6. Clicked OK twice 7. Restarted DWMX Nothing. To compound the

RE: Using createUUID()

2003-03-17 Thread jochemd
Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]: erm... I would say that they are unique. No UUID is the same by its very definition; thats the point... Just generate enough and you will get duplicates. But the problem is more with the following: In CF, you could use : myUUID =

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
yep, that would do it, -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:38 To: CF-Talk Subject: RE: Using createUUID() ran this, and got those, not too unique using the first four...maybe he could mid() some part of it, towards the end of a uuid,

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
I dont think that is the point per say, but I do see the point of potential conflicts -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:41 To: CF-Talk Subject: RE: Using createUUID() The point of a UUID is not to use the first

RE: Using createUUID()

2003-03-17 Thread Andre Mohamed
If you only use 4 characters then there are only roughly (10+26) to the power of 4 = 1679616 different combinations... this is a relatively low number which may or may not be considered unique enough for your purposes. With only 100,000 records you already have nearly a 6% chance of a collision.

RE: Using createUUID()

2003-03-17 Thread Andre Mohamed
Ignore my last post...ASCII has more than 36 characters...the point still holds though. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:48 To: CF-Talk Subject: RE: Using createUUID() If you only use 4 characters then there are only roughly (10+26)

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
yep, as noted in another post, if it fits your development, then you can still use it; back on track : does and will mySQL support newid() -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:51 To: CF-Talk Subject: RE: Using createUUID() Ignore my

RE: Using createUUID()

2003-03-17 Thread Larry Juncker
Unless I am missing something very simple, why would this not work? cfloop from=1 to=1000 index=i cfoutput CT-#Right(createUUID(),7)# BR /cfoutput /cfloop I ran this code and found no dups in 1000 lines on one

RE: Using createUUID()

2003-03-17 Thread Andre Mohamed
MySQL has an AUTO_INCREMENT column type (well it used to). It depends what scope of uniqueness you need for the ID - if unique at the table level is sufficient then this will do, though it does tie your code down to MySQL. André -Original Message- From: Robertson-Ravo, Neil (RX)

big database (need to modify columns)

2003-03-17 Thread Tony Weeg
hey all, has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? everytime I try it times the F**K out. and its driving me crazy thanks. ...tony Tony Weeg Senior Web

RE: Using createUUID()

2003-03-17 Thread Jason Lees (National Express)
Heres a URL on how the UUID is defined http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. there are

RE: big database (need to modify columns)

2003-03-17 Thread Robertson-Ravo, Neil (RX)
what do you need to doand what DB? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 14:00 To: CF-Talk Subject: big database (need to modify columns) hey all, has anyone on here ever had to add a column or change a column's properties. My database

RE: Using createUUID()

2003-03-17 Thread FlashGuy
If there is no change of duplication I like this ID#. In the code below. Would the UUID number be different for the hidden field when I eventually insert the form fields into my database? input class=uuid type=text value=cfoutputCT-#Right(createUUID(),7)#/cfoutput name=uuidnumber size=38

RE: Using createUUID()

2003-03-17 Thread Robertson-Ravo, Neil (RX)
The UUID will ALWAYS be unique - thats the whole point, and why you can define a row id with one of course like people have stated, reducing the amount of chars may increase the chance of a dupe with that block, but in essense the UUID will always be unique, if CF does not produce a unique

Remoting...

2003-03-17 Thread Tim Blair
Evening all, When you make a call to createGatewayConnection() from within the Action Script, what happens? What I mean is, does Flash make a call to the CFC purely to check if it exists and then discards anything, or does it hold a reference to the new instance? What we'd like to do is PUSH

Re: Using createUUID()

2003-03-17 Thread Stephen Moretti
It all depends on your OS. CF on some OSs will return consecutive numbers not random numbers using UUID. On some OSs your code would return the same four numbers everytime for quite a while before it changed. Regards Stephen CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London

Re: big database (need to modify columns)

2003-03-17 Thread jochemd
Quoting Tony Weeg [EMAIL PROTECTED]: has anyone on here ever had to add a column or change a column's properties. My database already has like 15 million rows of data in it? if so, how the HECK did you do it? ALTER TABLE table ADD COLUMN column datatype; Never done it on something

RE: Using createUUID()

2003-03-17 Thread jochemd
Quoting Jason Lees (National Express) [EMAIL PROTECTED]: http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. And although MAC

RE: Using createUUID()

2003-03-17 Thread Larry Juncker
As long as you use this value when the form is initially loaded, then this value would insert into the database as well. I think I understand what you are asking. If you are wanting this to be a unique form ID number then I would recommend calling it something other than UUID, because once you

Re: Remoting...

2003-03-17 Thread Frank Mamone
I see what your trying to do do, but somewhere, something has to poll to see if an update has happenned. How does the CFC know if there was an update? Do you mean a DB update? BTW, it's a great question. Looking forward to other's responses. -Frank - Original Message - From: Tim Blair

RE: Using createUUID()

2003-03-17 Thread Andy Ousterhout
As I understand it, createUUID returns a character string. I thought that record ID's should be numeric because of the improved performance on indexed look-ups. Do numeric indexes run significantly faster then character ones? Andy -Original Message- From: Robertson-Ravo, Neil (RX)

Re: Can someone walk me thru changing my ALT-3 shortcut?

2003-03-17 Thread Dave Carabetta
That's so weird. Those steps worked *perfectly* for me, and I'm on DWMX 6.1 too. I can type anything and select it, and hit ctrl-3 and it's all surrounded by poundsigns... Well, what's wierd is that I sent the post to cf-talk, but it didn't post for literally about 3 days. In that interim, I did

RE: Using createUUID()

2003-03-17 Thread FlashGuy
On Mon, 17 Mar 2003 08:19:44 -0600, Larry Juncker wrote: As long as you use this value when the form is initially loaded, then this value would insert into the database as well. I think I understand what you are asking. If you are wanting this to be a unique form ID number then I would

RE: Create PostScript file from dynamic pages or query outputs

2003-03-17 Thread Ben Doom
I would look into GhostScript. If nothing else, you should be able to build the PDF in CF and convert it to PS. However, it strikes me as odd that whatever software they're using to create their PDFs can't use a PDF as input. -- Ben Doom Programmer General Lackey Moonbow Software,

RE: Pet Market cfc's

2003-03-17 Thread Raymond Camden
While I can take the blame for the infamous jedimasterwhopper bug (sigh), I can't take the credit for Petmarket. : === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL

Re: Using createUUID()

2003-03-17 Thread S . Isaac Dealey
Hi, I need to generate a unique ID for every form I submit. The createUUID # generated is just too long for my needs. My ID only needs to be 10 characters in length. Something like: CT-0001001 I'm using MySQL. Can I have mysql generate the unique ID? How could I do this with CF? If

RE: Remoting...

2003-03-17 Thread Tim Blair
I see what your trying to do do, but somewhere, something has to poll to see if an update has happenned. How does the CFC know if there was an update? Do you mean a DB update? Think of it in terms of a private messaging system: one user of the site sends another user a message which gets

RE: Matrix problem

2003-03-17 Thread Ben Doom
I don't think I understood the question. And, given that there's been no response in the last hour and a half, I suspect no one else did, either. To me, a matrix is simply an n-dimensional array where n 1. In a 2-dimensional matrix, column f will intersect row 5 exactly once. Your query

RE: big database (need to modify columns)

2003-03-17 Thread Tony Weeg
but from query analyzer I should be ok? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc. Mobile workforce monitoring, mapping reporting www.navtrak.net 410.548.2337 -Original Message- From: [EMAIL PROTECTED]

RE: Remoting...

2003-03-17 Thread Benoit Hediard
You can only push data on demand with Flash Remoting. You cannot control when you'll get the response from a remoting call... (you'll get the response as soon as the request is finished on the server). It is a request/response mechanism. If you need to be able to push data from a server to a

RE: Using createUUID()

2003-03-17 Thread cfhelp
I got this from another CF developer I used to work with (I don't know if he is on the list). This tag creates a SQL formated GUID in variable you specify. !--- Place in a NewGUID.cfm file and place in Custom Tag Directory --- cfsetting enablecfoutputonly=Yes !---

Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
I was reading the tutorial over on cfvault, and I noticed it wasn't using cflogin, or cfloginuser, or any of the newer MX security features, and I was wondering if anyone had a good url with a good introduction to application security using some of the newer CFMX features. I'm trying to wrap my

RE: big database (need to modify columns)

2003-03-17 Thread Robertson-Ravo, Neil (RX)
yep -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 15:09 To: CF-Talk Subject: RE: big database (need to modify columns) but from query analyzer I should be ok? ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer

Newbe SQL question

2003-03-17 Thread Howie Hamlin
I have a basic MSSQL7 question - we have a table with no unique identifier (don't ask - I didn't design it) where, on an insert, we want to update a record if it exists and insert it if it doesn't. The record can be identified only by a combination of columns. For example - select

RE: Remoting...

2003-03-17 Thread Tim Blair
FlashCom hides all the complexity of the socket connection and notification mechanism. It's really great! I agree that it's great in principle, but from all the swearing coming from one of our guys developing with FlashComm I'd say that the current release isn't up to scratch for a production

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Raymond Camden
Also, if I use cfloginuser I'm limited to name, password, and roles, but the table is going to store more information than that, that I'd like access to, like first and last name for instance. I'd like to display that on each page, but I'm not sure how to get it for each logged in user.

RE: Remoting...

2003-03-17 Thread Benoit Hediard
Alternatively, is there a way around it? Say having flash call the CFC straight away (once) and the CFC will wait until an update has occurred, then return the new data to Flash, whereupon Flash will update and call the CFC again, which will wait etc etc etc... How about creating an

RE: Newbe SQL question

2003-03-17 Thread Craig Dudley
You could use a trigger, but better just to use a stored proc. Something along the lines of.. Create procedure someproc @a int, @b varchar // etc etc as If exists(select a,b,c,d,e,f from sometable where [EMAIL PROTECTED] and ..) begin // It does exist so do update end else begin

Check if file on server is *read-only*

2003-03-17 Thread FlashGuy
HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 10:23 AM, Raymond Camden at [EMAIL PROTECTED] wrote: The cflogin framework handles 2 basic things - authentication and authorization. User data would still need to be handled as it is now. For example, maybe on login you get info like the user's name and age. You could then store

Re: Newbe SQL question

2003-03-17 Thread Jochem van Dieten
Howie Hamlin wrote: I have a basic MSSQL7 question - we have a table with no unique identifier (don't ask - I didn't design it) where, on an insert, we want to update a record if it exists and insert it if it doesn't. The record can be identified only by a combination of columns. For

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Raymond Camden
Darn, that did more to confuse me than anything else... So lemme get this straight, I'm not going to be able to start my logic with does a session exist? because the cflogin tag isn't going to do anything with sessions? Like create one? The cflogin tag has nothing to do with sessions.

Re: Newbe SQL question

2003-03-17 Thread Paul Hastings
In other words, selection based on 7 columns or so is the only way to uniquely identify a record. So, is it possible to have a trigger check for uniqueness and insert or update a record depending on whether the record was found? sql server triggers work after the insert--inserting then figuring

Forum System Recommendations

2003-03-17 Thread Mosh Teitelbaum
All: A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap (about

Re: Check if file on server is *read-only*

2003-03-17 Thread ksuh
On Windows systems, files that are read only will have an R in the attributes column when using cfdirectory. For *nix systems, you should be able to check the mode column. - Original Message - From: FlashGuy [EMAIL PROTECTED] Date: Monday, March 17, 2003 8:37 am Subject: Check if file

RE: Matrix problem

2003-03-17 Thread rick
You're right. Matrix must be thowing folks off. But I'm afraid you've lost me, now. Let me try again. I'm working with a body of monthly 500 reports from which I need to distill certain information. For the report output (which will take the form of a matrix), assume column f is Brown_Eyes

RE: Forum System Recommendations

2003-03-17 Thread Kris Pilles
QD Forums is nice and is open source. From QuillDesigns, I am going to purchase it this week for a client. -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:51 AM To: CF-Talk Subject: Forum System Recommendations All: A client of mine

RE: Forum System Recommendations

2003-03-17 Thread Bill Brown
My friend developed one of the first forum apps for CF called CFBoards and his pricing (and feature set) is right in line with what you want: http://www.eruditionzone.com/index.cfm?fuseaction=cfboards I've seen it in use and I liked it a lot. Bill : -Original Message- : From: Mosh

Re: Forum System Recommendations

2003-03-17 Thread Stephen Moretti
Mosh, A client of mine (small, non-profit) would like to quickly add a discussion forum to their website. It needs to support unlimited threads, topics, messages, etc. It needs to support forum searches, user profiles, moderation, limited HTML content. And, preferably, it should be cheap

RE: Matrix problem

2003-03-17 Thread Matthew Small
Select count(*) where WHERE f='brown-eyes' AND somecol='big_feet' I can only guess that's what you want to do. But if this isn't it, you should probably learn proper database lingo and re-ask the question. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy

Re: flash forms

2003-03-17 Thread Mike Chambers
Just put the beveled graphics behind the text box. mike chambers [EMAIL PROTECTED] - Original Message - From: Mahmut Basaran [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 11:23 PM Subject: Re: flash forms Also, is there a way to make html style

Re: Matrix problem

2003-03-17 Thread Stephen Moretti
Rick, I'm working with a body of monthly 500 reports from which I need to distill certain information. For the report output (which will take the form of a matrix), assume column f is Brown_Eyes and assume row 5 is Big_Feet. I can easily imagine a query of the DB WHERE brown-eyes AND

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 10:46 AM, Raymond Camden at [EMAIL PROTECTED] wrote: The cflogin tag has nothing to do with sessions. Period. As it stands, you 'create' a session when you put the cfapplication tag in your browser. I believe it exists even before you do your first cfset session.foo = 1. (Actually,

RE: Forum System Recommendations

2003-03-17 Thread Douglas.Knudsen
I use http://forum.snitz.com/ internally on our Intranet. Its an ASP app...I know...but its free and really easy to set up. Doug -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 10:51 AM To: CF-Talk Subject: Forum System Recommendations

Re: Check if file on server is *read-only*

2003-03-17 Thread Randell B Adkins
Use the ATTRIBUTES parameter [EMAIL PROTECTED] 03/17/03 10:37AM HI, Is there a way with CF to check if a file is read-only? I'm listing files on the server with cfdirectory. --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces

Clearing Cached Pages

2003-03-17 Thread Dave Sueltenfuss
Good Morning, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Raymond Camden
on 3/17/03 10:46 AM, Raymond Camden at [EMAIL PROTECTED] wrote: The cflogin tag has nothing to do with sessions. Period. As it stands, you 'create' a session when you put the cfapplication tag in your browser. I believe it exists even before you do your first cfset session.foo = 1.

Re: Forum System Recommendations

2003-03-17 Thread Stephen Moretti
Ah well now - if you're talking free - www.phpbb.com if you can run php applications on your server ;o) Stephen I use http://forum.snitz.com/ internally on our Intranet. Its an ASP app...I know...but its free and really easy to set up. Doug -Original Message- From: Mosh

RE: Clearing Cached Pages

2003-03-17 Thread Tony Weeg
if the server is cfmx, then its not the users cache, its most likely cfmx. other than that, they could try shift + refresh that forces the browser to snag a live copy... ...tony Tony Weeg Senior Web Developer UnCertified Advanced ColdFusion Developer Information System Design Navtrak, Inc.

Re: Check if file on server is *read-only*

2003-03-17 Thread FlashGuy
Thanks On Mon, 17 Mar 2003 08:51:45 -0700, [EMAIL PROTECTED] wrote: On Windows systems, files that are read only will have an R in the attributes column when using cfdirectory. For *nix systems, you should be able to check the mode column. - Original Message - From: FlashGuy

RE: Clearing Cached Pages

2003-03-17 Thread Dobris, Eric
Hi Dave, Try This: CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Expires VALUE=Now() CFHEADER NAME=cache-control VALUE=no-cache, no-store, must-revalidate Eric -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:15 AM To: CF-Talk

RE: Clearing Cached Pages

2003-03-17 Thread Pascal Peters
!--- prevent the pages from caching --- CFHEADER NAME=Pragma VALUE=no-cache CFHEADER NAME=Cache-Control VALUE=no-cache, no-store, must-revalidate -Original Message- From: Dave Sueltenfuss [mailto:[EMAIL PROTECTED] Sent: maandag 17 maart 2003 17:15 To: CF-Talk Subject: Clearing Cached

Re: Clearing Cached Pages

2003-03-17 Thread Stephen Moretti
Dave, I encountered a problem on Friday where a user continued to see an old page, even after I had updated it. I realize this has to due with the users cache, but am wondering if anyone knows of a way/command to clear the cache or prevent a site from caching. Any help is appreciated To

OT: Dropdown Question

2003-03-17 Thread Ciliotta, Mario
Hi, I was wondering if anyone has an example or maybe a custom tag that I could use that would allow me to have a dropdown box on a page that if the option for the user to select is not there then the user can type something in the field. I tried to leave a blank option out there but the

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 11:14 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Well, if it's user data like age, name, rank, etc, a struct seems to make more sense, but use whatever is best for you. Actually, a struct makes a LOT of sense, and I see what you're saying now. Why not just use one

Re: canadian database

2003-03-17 Thread David K
God I love this list! On my way to work this morning I was wondering how I was going to source this very thing. Thanks! - Original Message - From: Erik Yowell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 1:41 PM Subject: RE: canadian database Perhaps

Re: OT: Dropdown Question

2003-03-17 Thread Scott Brady
-- Original Message -- From: Ciliotta, Mario [EMAIL PROTECTED] I was wondering if anyone has an example or maybe a custom tag that I could use that would allow me to have a dropdown box on a page that if the option for the user to select is not there then

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Douglas.Knudsen
-Original Message- From: Jeff [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 11:42 AM To: CF-Talk Subject: Re: Application Security using cflogin and cfloginuser on 3/17/03 11:14 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Well, if it's user data like age, name, rank, etc, a

Re: Postal Code lookup / ZIP Code lookup

2003-03-17 Thread David K
Paul: Thanks for this. Would have replied sooner but was away from the office. Also, FYI, found this on another thread this morning. http://www.zipinfo.com/ Best, David - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday,

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Raymond Camden
1. Login.cfm will reside in the root and will take username and password 2. Login_process will ALSO reside in the root, and if the user successfully logs in, it sets a session, cfset session.LoggedIn=1 refreshes the parent window, then Correct, although I normally recommend using

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 11:49 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: no need to place this check in every page...that's what application.cfm is for. Doug Arrrgh...But I thought that any code in the application.cfm page was run when every page was requested. If I put that code in my

RE: force a download - .txt file

2003-03-17 Thread Dan O'Keefe
This method forces the download, but names the file index.cfm instead of the actual filename that you are downloading. Anyone know how to name it properly? Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 5:18 PM To: CF-Talk Subject:

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 11:53 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Correct, although I normally recommend using self-posting forms. It makes updates _much_ easier. Self posting forms, like the type that DreamweaverMX makes? Once the user successfully logs in: Place a line of code on each page

Access SQL question

2003-03-17 Thread SRetsky
Hi: thanks, but it did not work. I tried to make changes to it for Access 2000 (tried ltrim for reverse, could not find function for charindex (tried locate, instr)) and could not get it to work. Any other trys? thanks Sandy Subject: Access SQL question From: Mahmut Basaran [EMAIL

RE: Clearing Cached Pages

2003-03-17 Thread Dave Sueltenfuss
Thanks Tony, Unfortunately, I am still on CF 5 Pro. I plan to upgrade in the near future to CFMX (guess I better accelerate my upgrade process). I can not ask the users to do a shift + refresh, because the fix was for a security issue, and There is no guarantee they would do it. This program

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Douglas.Knudsen
depends...I know vague frustration going on here...but it does depend on how you set it up. I usually use a two dir system myself with a dir /login with its own application.cfm file that does no login check and an application.cfm file in my / dir that does the check for every file below /

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Raymond Camden
on 3/17/03 11:53 AM, Raymond Camden at [EMAIL PROTECTED] wrote: Correct, although I normally recommend using self-posting forms. It makes updates _much_ easier. Self posting forms, like the type that DreamweaverMX makes? I wouldn't know - I use HomeSite+. Once the user successfully

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 12:23 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: depends...I know vague frustration going on here...but it does depend on how you set it up. I usually use a two dir system myself with a dir /login with its own application.cfm file that does no login check and an

RE: Forum System Recommendations

2003-03-17 Thread Mosh Teitelbaum
Thanks to those that replied. I'm researching the options you suggested. Thanks. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent:

Re: Application Security using cflogin and cfloginuser

2003-03-17 Thread Jeff
on 3/17/03 12:27 PM, Raymond Camden at [EMAIL PROTECTED] wrote: Correct, becuase my 'core' Application.cfm will contain site-wide logic, but I have a specific need for this particular subfolder. So, unlike most Application.cfm files, you won't see a cfapplication tag in it. We aren't defining

RE: Application Security using cflogin and cfloginuser

2003-03-17 Thread Raymond Camden
Under normal circumstance, I'd cfinclude the file that contained the login form. When you cfinclude a cfm, you do NOT rerun the Application.cfm. In your case, it's a bit more complicated because you are launching a subwindow via javascript. I hate to say 'Add a hack', but in your case you kind of

  1   2   >