Re: Okay, go here to see what I'm talking about...(cfserver not running correctly)

2004-08-23 Thread Jeff Small
> In that case, check the CFIDE virtual directory anyway I suspect that it > will have an application configured and it will not have the correct cfm > mappings If that is the case, your best bet is to use the remove button > as you dont need an IIS application to be configured for CFIDE...

Re: Okay, go here to see what I'm talking about...(cfserver not running correctly)

2004-08-23 Thread Jeff Small
> I may have missed this in one of the messages but I don't think so... > > I'm assuming that barefoot2003 is a virtual directory just like CFIDE is > if so, check the following settings in IIS... Sadly, barefoot2003 is just a folder under wwwroot. Which is why I REALLY don't understand why i

Is Bonnie Powers still around? Re: Okay, go here to see what I'm talking about...(cfserver not running correctly)

2004-08-23 Thread Jeff Small
> sorry, just found original thread before it was renamed - i see my > suggestion was offered before, > > jb. That's okay... I found THIS on the old House of Fusion archives, but the thread just died...if Bonnie Powers is around, I'd love to hear how she fixed this EXACT same problem! http://www

Re: Okay, go here to see what I'm talking about...(cfserver not running correctly)

2004-08-23 Thread Jeff Small
> you didn't by any chance FTP the administrator pages to the server did > you? I've seen this before where customtags i've bought have just > returned garbage when called - turns out they need to be FTP'ed in BIN > mode and not ASCII No! See? That's what I mean! We haven't done *anything* to thes

Okay, go here to see what I'm talking about...(cfserver not running correctly)

2004-08-23 Thread Jeff Small
http://dev.lhwh.com/cfide/administrator/ That's all we're able to get... Now, go here... http://dev.lhwh.com/barefoot2003/ See? One works, with datasources, with cfm pages compiling and displaying perfectly...the other...nothing. [Todays Threads] [This Message] [Subscription] [Fast Unsub

Re: Server not running...but running...um, help?

2004-08-23 Thread Jeff Small
> > I suggested that earlier - but he says that other .cfm files > > on the same configured sites run correctly. wouldn't that > > indicate that the connector was correctly installed? > > Probably, but not necessarily. I'm not sure what Jeff means when he says one > URL works fine locally, but not

Re: Server not running...but running...um, help?

2004-08-23 Thread Jeff Small
> Jeff, > > I'm speaking of the little batch files buried in the /cfusionmx/ directory that > remove and re-add the necessary connectors for the jvm.  If you are running CF > the process is to remove the extension mappings in the IIS admin for the > application. > > As for your problem - hmmm d

Re: Server not running...but running...um, help?

2004-08-23 Thread Jeff Small
> I think your service is not being handed the request. I would run the connectors. It looks like an encrypted file being > served by IIS (instead of being processed first by CF) - sort of like seeing the source code on an unecrypted file. Nah, see, pages *within* the server are working and are be

Re: Server not running...but running...um, help?

2004-08-23 Thread Jeff Small
> You must have uploaded the encrypted files to the server over ftp in > ASCII mode, this corrupts the files. You need to use binary mode. Wait, I never uploaded them at all. They just suddenly started acting this way... Can I move my administration directory on my own local machine over to our d

Server not running...but running...um, help?

2004-08-23 Thread Jeff Small
When I try to go to the admin page on our development server (http://development.ourdomain.com/CFIDE/administrator/index.cfm), I'm seeing nothing but gobbeldygook (first line sample: Allaire Cold Fusion Template Header Size: New Version£çò~Áð¬Õh/ÔÜý¥Æhqؤä8X°É¿Ìò©?P^qv ßNÊÒ?ùFÍû'ÉÊ "o¦^9.) How

Re: Outlook moving messages to cf-talk to 'Junk E-mail' folder??

2004-08-03 Thread Jeff Small
> Anyone else having this problem?  It seems to have just started today > and it seems to be a little random.  Only certain people and only > certain messages.  I don't have any weird filtering set up for words or > anything.  I've just added SPAM to the junk senders list and it moves > that stuff

Re: CFC for dynamic menu?

2004-07-23 Thread Jeff Small
> If I needed multiple formats, I'd probably make a single CFC that has > three methods, one to pull the raw menu query (probably delegatin gto > a dedicated DAO), one to pull the menu as a structure, and one to pull > the menu as XML.  That's really a single job, so it makes sense to > have it all

Re: CFC for dynamic menu?

2004-07-23 Thread Jeff Small
> Depends on what you're looking to do.  Structs are probably going to > be slighly faster, and they'll be more familiar as well (since you use > them all the time).  XML, on the other hand, will let you build the > navigation with XSL, which can be very advantageous in certiain > situations.  In a

Re: CFC for dynamic menu?

2004-07-23 Thread Jeff Small
> What's the best method of passing this object back from the CFC?   Should I > create an xml object?  Or a struct containing all the menu data and submenu > data? Does it matter? I can't speak for everyone here, but I love structs. I pass structs in and out of my CFCs all the freakin' time an

CFLogin/Logout and session variables...

2004-07-22 Thread Jeff Small
In the livedocs for cflogin, it says the following: After a user logs in, the ColdFusion user authorization and authentication information remains valid until any of the following happens: 1. The login times out. This happens if the user does not request a new page for the idleTimeout period. 2. T

Question about my default cfm page in DreamweaverMX 2004

2004-07-19 Thread Jeff Small
I'd like to add the following code in all my "New..." cfm pages: < ---     Filename:     Created By:     Notes: --- > ...and I was wondering where that file is located. Can't I change the template that the new file is created from and add that in at the top? So, if I hit "New" (or ctrl-N) the def

Re: A question about database design re: security

2004-07-13 Thread Jeff Small
> > So is there any overwhelming security reason why you wouldn't > > store additional information in a usertable? > > No, there isn't, usually. There may be some rare cases where you want to > allow people to access user information but not the password column, but > there are other ways to deal w

A question about database design re: security

2004-07-13 Thread Jeff Small
After reading Anthony McLure's great article on CFCs and a basic security model (http://www.macromedia.com/devnet/mx/coldfusion/articles/cfc_practices.html) , I was only left with really one question, and it concerns the design of the database... In his example, he has a nice database design where

Re: Is there an example/tutorial on CFCs with CFLogin?

2004-07-08 Thread Jeff Small
> > So what you're saying is, in the following example: > > > > > > > [deletia] > > >   > > > > > > > > Which portions would I want to use CFCs for? This is what I'm > > most fuzzy on. > > I'd probably just use it for the authentication query. That's it? That's easy! [Todays Threads]

Re: Is there an example/tutorial on CFCs with CFLogin?

2004-07-08 Thread Jeff Small
> > I'm not *sure* why I want to do cflogin inside the CFC. For > > one, I was wanting to create something that, with minimal > > effort, could be used with Flash Remoting. I'm creating an > > application that's going to require some basic security (IE, > > you gotta be logged in to use it) and eve

Re: Is there an example/tutorial on CFCs with CFLogin?

2004-07-08 Thread Jeff Small
> My question is - why do you want to do the _within_ the CFC? I > typically use within my application.cfm files. My CFCs will handle > stuff like, authentication, getUserRoles, etc, but the actual mechanics of > > prompt for login > use cflogin if authenticated > > are handled by the Application

Is there an example/tutorial on CFCs with CFLogin?

2004-07-08 Thread Jeff Small
I had tried digging into this before I went on vacation, and now that I'm back, I'm finding that I'm back at square one and still a little confused on how exactly to use CFCs to create a nice, clean, CFC based basic CFlogin to protect a directory. I have an application that I wrote upon returning

Re: coldfusion on Mac OS X - Trouble installing

2004-06-23 Thread Jeff Small
> I am trying to set up coldfusion on my Mac for development.  I am running > OS 10.3.4 and Java 1.4.2 > Thanks in advance I have absolutely nothing to contribute to this, except to say that I am following this thread now with bated breathI eagerly anticipate this discussion as I'm *right* th

CFCs and CFLoginUser()

2004-06-22 Thread Jeff Small
My current thinking on creating logins with CFCs is that you create a CFC that passes in the Form.username and Form.password into a CFC that Queries the DB and returns a Query object containing all of your information. Once I've passed your username and password into the CFC and returned all of yo

Re: CFMX and JRUN

2004-06-18 Thread Jeff Small
> Yes and No :-). If you install CFMX for J2EE w/ Jrun, option 2 of the > install, a full version of Jrun *is* installed. If you choose to install the > Server Configuration, option 1 of the install, a full version of Jrun *is > not* installed. Does this matter if you're installing a single user l

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
From: "Dick Applebaum" <[EMAIL PROTECTED]> > HTH > > Dick /me prints that whole message out and tapes it to his laptop... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> In general, you're better off using a database server like MS SQL Server > rather than a desktop database like Access. Of course, SQL Server is quite a > bit more expensive. Keep in mind, this is just for to develop on my Powerbook. I have development tools at work, and I've got a PC with a Sing

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> A GUI Client is useful for experimenting with/validating complex > queries before coding them in CF. > > A fairly good, general-purpose, GUI SQL Client is ViennaSQL -- open > Source, written in Java and can interface any DB that has a JDBC > Driver. > > If you go MySQL, CocoaMYSQL is a Mac-s

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> I mostly use the command line client that comes with the > distribution, and for the rest pgAdmin. But there are many more, > like phpPgAdmin, pgManage and a lot of commercial tools. Does pgAdmin do what you can also do in the command line? I mean to say, the stuff that you're doing in the comma

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> I guess if it is small amount of traffic it is ok, I do disagree on > principle though! use mySQL as it is for free  but I can see your > point.. and it scares me :) Remember though, a lot of times the clients have Access as well, and they like just going and downloading the access file themselv

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> Havent uinstalled PostgreSQL on OS X as yet.. are there good clients > apart from Aqua data  studio? Do you have to download/install PostgreSQL...then go get a client to interface with it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> We don't :) Why would we want to offer MySQL when we can offer > PostgreSQL? So...less SQL "gotchas" on PostgreSQL? I'm listening...I'm listening... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> Using OS X you can get mysql and phpmyadmin  or/and  Aqua Data studio > (as a client for most db servers) Yeah, I was kinda hoping to stick with CF though. Use CF with some sort of DB. > Just an open question do people STILL really use access  in production > environments?! Oh sure. We do all

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> You also can get free developer versions of Sybase_ASE (up to 25 > concurrent users, AIR), Oracle9i > PointBase, etc -- most any popular DB except MS-SQL-Server and > MS-Access. > > If you use SQL-Server, have a look at Sybase -- they share ancesters & > both have T/SQ. Sybase sounds interesting

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> On Friday 18 Jun 2004 15:27 pm, Jeff Small wrote: > > databases solutions are you guys using locally? > > On MacOS, I'm fairly sure you can have the normal free*/small DB's such as > postgresql and mysql. Okay, if a guy's familiar with access and MSSQL, whi

Re: ColdFusion on Mac OS X

2004-06-18 Thread Jeff Small
> I havent come across any build issues using the apache connector for > JRUN, it works quite well. (to me it seems faster on my iBook but I > might be wrong!) > > Mark Drew > > On > > I followed the above instructions and had  a painless install on OS X. > > Note that I opted to remain using the b

Re: Where do you get ODBC Drivers for SQL Server and Access? (OS X)

2004-06-08 Thread Jeff Small
> I don't think you'll be able to connect to Access very well from OS X. I > haven't actually tried to do this, but I suspect that the SequeLink ODBC > client used by CFMX is only installed on Windows. You should be able to use > the MS SQL Server JDBC driver to connect to SQL Server from CFMX on a

Where do you get ODBC Drivers for SQL Server and Access? (OS X)

2004-06-08 Thread Jeff Small
I've got ODBC in my Utilities folder, but when I want to add a datasource, I don't have an Access Driver. I looked all over Microsoft.com but couldn't seem to find it. Is all I need the driver for Access? Where do you go to get one for Access and SQL Server if you're running OS X? I'm trying to slo

Re: I don't even know what I need to be able to do this...[fdf/cf]

2004-06-07 Thread Jeff Small
> //INSERT THIS LINE HERE! > That's awesome! I stumbled onto the same problem right when you replied. Thanks so much! The only issue I have now is, why isn't it populating my checkboxes with their appropriate values? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User

Re: I don't even know what I need to be able to do this...[fdf/cf]

2004-06-07 Thread Jeff Small
> Yes, this is correct I used your code in a little test example, and all I'm seeing is Text rendered to the screen. Here is the *EXACT* contents of what I've got. Is there any good tutorial site for outputting a FDF file using CF that maybe could help me? SELECT * FROM tblPDFTesting WHERE tblPD

Re: I don't even know what I need to be able to do this...[fdf/cf]

2004-06-07 Thread Jeff Small
> I've never processed the acrobat form data, but from what I understand, > they're just standard form fields Okay, that's easy enough to figure out. > The client could see a link to a prepopulated fdf file, or they could > see a link to cfm template that serves up the fdf file via cfcontent. > I

Re: I don't even know what I need to be able to do this...[fdf/cf]

2004-06-07 Thread Jeff Small
- Original Message - From: "Marlon Moyer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 07, 2004 10:27 AM Subject: RE: I don't even know what I need to be able to do this...[fdf/cf] > Jeff, > > FDF files are just simple text files that are very easy to create wi

I don't even know what I need to be able to do this...[fdf/cf]

2004-06-07 Thread Jeff Small
Here are the basic requirements: They (client) have a couple of hundred forms in PDF format that they want *their* clients to be able to "fill out" and "submit". We have CF sitting on their server. On their (client's) end, they want to be able to save the same PDF form, but filled out, on their end

Is my init() function's access private or package?

2004-06-01 Thread Jeff Small
They both *appear* to read the same to me...but if I wanted to call my init function inside my CFC, do I make it "private" or "package" and why would I choose one over the other?     ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Is an empty query object still a "good" query object?

2004-06-01 Thread Jeff Small
From: "Dain Anderson" > Jeff Small wrote: > > But useful, in sofar as you could build a little check > > myQuery.recordcount GT 0> and it would work... > > Correct me if I'm wrong, but when an empty query object is returned from > a CFC, and then you

Re: Is an empty query object still a "good" query object?

2004-06-01 Thread Jeff Small
> > I mean, if your CFC returns a Query Object, how do you take > > into account a Query that returns no rows? Is it just a Query > > Object with a recordcount of 0? It's still an "okay" > > QueryObject to pass out, right? It's just empty...right? > > Whether you create a query object in a CFC or a

Is an empty query object still a "good" query object?

2004-06-01 Thread Jeff Small
I mean, if your CFC returns a Query Object, how do you take into account a Query that returns no rows? Is it just a Query Object with a recordcount of 0? It's still an "okay" QueryObject to pass out, right? It's just empty...right? [Todays Threads] [This Message] [Subscription] [Fast Unsubsc

Re: How do you *manage* time? (Add it, Subtract it, Track it)

2004-05-28 Thread Jeff Small
> I always use seconds, and build up from there. > its soo easy to work with them, with dateAdd, and dateDiff. > > and as always the database is really thin, since your just storing numbers. > > .02 > > tw After I typed this, I had a thought about this more, and thought this: Why do I need to stor

How do you *manage* time? (Add it, Subtract it, Track it)

2004-05-28 Thread Jeff Small
Okay, so let's say you're using SQL Server, and you want to create an application that was going to track time and do things like, eventually multiply hours by currency (hourly rate by 1 hour 45 minutes) and add several rows containing time to accumulate time spent, time remaining, etc, and graphin

Is there anything wrong with this (part 2)

2004-05-26 Thread Jeff Small
** THE CFC CODE (maint.cfc) ** output="false" displayname="Insert A Hosting Provider" hint="Takes form data and inserts it into a Hosting Provider Table. Returns ID of inserted record in a struct."> displayname="Insert Contents" hint="A Struct containing all the content from the form, t

Is there anything wrong with this (part 1)

2004-05-26 Thread Jeff Small
Sorry, I got a note saying my post was "too long". I apologize, but I was pasting code...I broke it into two pieces and thought I'd post both parts, so you (you all) could see it. >From previous... It works...I want it to be good and robust though...so, looking it over, is there anything I can do

Is there anything wrong with this?

2004-05-26 Thread Jeff Small
It works...I want it to be good and robust though...so, looking it over, is there anything I can do to make it better? What follows is good ol' generic code to insert from a form, but using a CFC to do so. So, look over the Processing and the CFC and let me know what you think. Of particular import

Re: Quick Question about inserting dates...

2004-05-12 Thread Jeff Small
> If you're using SQL Server, don't pass the date from CF, get SQL Server > to insert the data itself > > INSERT INTO table (dateField) > VALUES (getDate()) Well, that's pretty cool...I've just been using #Now()#...I always forget to let SQL do all the work...sigh... But still, what's the differe

Quick Question about inserting dates...

2004-05-12 Thread Jeff Small
In Dreamweaver, using the Insertion Wizard, if I want to insert a hidden "datesubmitted" field and use #Now()# and the database is SQLServer, which option do I want to select in the "Submit As" dropdown? "Date" or "Date MS Access"? It's just a nagging question that I've always wondered...what's th

Re: What causes this error?

2004-05-06 Thread Jeff Small
> The CF Administrator datasource settings for MS SQL Server don't allow the > use of trusted connections. You'll need to create a native SQL login within > your database (as opposed to a Windows account) and use that from CF. You > may also need to configure your SQL Server to allow both Windows a

Re: CFCs that perform INSERT...yikes...

2004-05-04 Thread Jeff Small
> Actually this should be: [snip] Thanks Ben, Dave and Tom. This has been a real help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

How to tell if the "Flash Remoting Components" and Updater are installed?

2004-04-22 Thread Jeff Small
I'm looking on macromedia.com, and I'm here: http://www.macromedia.com/software/flashremoting/downloads/components/ ...and I'm wondering if I've installed these...how does one tell, and how does one know if the updater near the bottom is loaded... [Todays Threads] [This Message] [Subscriptio

Re: SQL Cursor Output in CF?

2004-04-21 Thread Jeff Small
> On Wednesday 21 Apr 2004 15:33 pm, Jeff Small wrote: > > Is there a way to get SQL Cursor output in ColdFusion? > > Yup, but possibly only from stored procedures. > What CF version ? CFMX, does that matter? [Todays Threads] [This Message] [Subscription] [Fast Un

SQL Cursor Output in CF?

2004-04-21 Thread Jeff Small
Is there a way to get SQL Cursor output in ColdFusion? It doesn't appear to be available in the Query Scope. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: [DWMX2K4] Does this feature sound familiar?

2004-04-02 Thread Jeff Small
> >www.macromedia.com/go/wish > >I guess we could post it to the wishlist. > > Please do- that's the best way to get it directly into the product team. > This isn't the first (or do I suspect the last) time I've heard of a request > for code collapse in DW, I've also submitted a request for it myse

Re: [DWMX2K4] Does this feature sound familiar?

2004-04-02 Thread Jeff Small
> Yes, I know that was in CF Studio (v5 I think...maybe even earlier)  I > really liked it as well and didn't even really notice it was gone until > you just mentioned it.  I don't know if there's anything lurking in > Dreamweaver or not, but at a quick glance, I couldn't find anything. > > John Bu

[DWMX2K4] Does this feature sound familiar?

2004-04-02 Thread Jeff Small
I can't remember where this was, what software had it, and how you even got to it, but I'll describe what it was, and someone pipe up and tell me I'm either crazy, or I just need to dig deeper to find it... I seem to recall that in some prior version (maybe even Studio?) that you could highlight a

Re: Okay, bear with me, I'm not even sure what I'm asking...

2004-03-25 Thread Jeff Small
- Original Message - From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 2:36 PM Subject: RE: Okay, bear with me, I'm not even sure what I'm asking... > Did I misunderstand this - I think he IS asking why he can't use exaclty

Okay, bear with me, I'm not even sure what I'm asking...

2004-03-25 Thread Jeff Small
Okay, here's the deal. One of our programmers has created an include that would be in the root of a site (call it, "navbar.cfm") and there's one page (index.cfm) that calls it from the root (). Now, in navbar.cfm, there's a path to an image (let's say src="" for instance). He's using absolute pat

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> well...yeah... > > > 1 > > Okay, see, that was my question, how do I set the "values" of the hours and minutes. Easy enough, just pass the number of seconds...gotcha... > > 1 > 2 > > > then just add up > > > > :) tony Once again, it was harder in my head than you've made it here on "pape

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> Totally, you've been a terrific help. I hope this helped others as much as > it helped me. Oh yeah, one more thing, regarding how *they've* decided *they* want the interface, which is sort of dictating my database design...I have no problem with it, I just want to make sure it's "do-able"... Le

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> that's fine...so don't have beginTime and endTime just have timeOnTask, and > let them enter what they want, and translate that into seconds in the cf > code... > > I use beginTime and endTime, in a web application because, I capture them > logging in, and logging out, therefore I can interpret t

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
- Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 24, 2004 1:48 PM Subject: RE: Quick Question, RE: Datatype and future date/time calculation > ok... > > I would have these tables. > > tasks > -- > id > allottedTime

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> you may have posted already, but a quick run-down of the final > application... Oh, I'm just looking for what would be considered the "best" datatype to use to calculate time spent doing a task. A Task, which is stored in a task table, has a certain amount of "time" attached to it (TimeAllocated

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> use seconds in an integer field... > they are easier to work with > > using epoch time (01/01/1970 00:00:00.000) > > you can use that as a base, and do dateDiff's and dateAdd's using (now()) > or a date in the futureto get seconds in between two events... > > if you need more code to look

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> so lets say start time was today, now(). > > > > that will give you a value something like this > > 1080131574 > > throw that into an integer column called beginTime > > and you can translate that back to a "human readable" date time like this > > > > which will return > > {ts '2004-03-24 1

Re: Quick Question, RE: Datatype and future date/time calculation

2004-03-24 Thread Jeff Small
> Use datetime datatypes with datediff/dateadd functions. Will date time allow me to "insert" dates/times that are larger than 24 hours? I mean, no harm in trying, of course... I was actually planning on taking advantage of datediff/dateadd, that's why I was hoping a datetime datatype would suffi

Quick Question, RE: Datatype and future date/time calculations

2004-03-24 Thread Jeff Small
Let's say a table was going to contain "AllocatedTime" which would be the total time allocation for a task, say...an hour, possibly 8, maybe 16, maybe even a half hour or 45 minutes...you get it, a range of hours and minutes, and another table was going to contain separate entries to track progress

CFCs...best practices, tutorials, examples...

2004-03-12 Thread Jeff Small
I've made it my mission to start all new sites that we develop using CFCs. I'd like to wrap the queries in CFCs, I'd like to perform logins using CFLogin and CFLoginUser (I've already got a terrific working login app written that we reuse frequently) using CFCs and I'd like to *responsibly* use CFC

Re: Reliable way to get ID of inserted record

2004-03-11 Thread Jeff Small
> I think that Rob nailed it in the posting right after yours.  This is only an issue where you have a trigger that inserts into a different table that has an IDENTITY field in it.  In that case, @@IDENTITY will return the inserted ID from the trigger rather than your your original insert.  Also, a

Re: CF Mail Interface Needed

2004-03-11 Thread Jeff Small
- Original Message - From: "Bryan F. Hogan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 11, 2004 2:23 PM Subject: OT: CF Mail Interface Needed > Hi All, I'm looking for a Web Based Email client as nice as this Perl > one at http://www.webbasedemail.com/. If

Re: Reliable way to get ID of inserted record

2004-03-11 Thread Jeff Small
From: "Jeff Garza" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 11, 2004 1:35 PM Subject: Re: Reliable way to get ID of inserted record > Be carefull using @@IDENTITY, as it can return erroneous information (especially if your tables have triggers associated with the

Re: Piggyback question to: Transferring Dreamweaver Sites and settings to new machine.

2004-03-11 Thread Jeff Small
> Is it legal to take our Copies of DWMX and HS+ to our home dev boxes to use? > > just wondering. > > thanks! I actually *just* got off the phone a couple days ago about this very topic. I had installed Dreamweaver on a machine here at work and wanted to transfer the license, and was on the phon

Re: "Edit" Button on IE...can you add Dreamweaver?

2004-03-10 Thread Jeff Small
From: "Ben Forta" <[EMAIL PROTECTED]> Subject: RE: "Edit" Button on IE...can you add Dreamweaver? > I think that this is what you are looking for: > http://www.macromedia.com/support/dreamweaver/ts/documents/ie_default_editor > .htm Like a CHARM, it worked...now...Dreamweaver...my precious... [T

SOT: "Edit" Button on IE...can you add Dreamweaver?

2004-03-10 Thread Jeff Small
In my IE "Standard Buttons" menu, there's the "Edit" button. This allows you to "edit" a webpage in certain applications (On mine, it's Notepad, Word, and Excel...go figure). Sometimes it would be neat to "edit" or "open" a page with this button just to see how certain things are accomplished, sort

Re: Ben's book is out

2004-03-10 Thread Jeff Small
> I know what you mean. > > But the title is misleading, whole series title that is. It is not a subject > meant to be learned in 10 minutes, it is a series of lessons that each take > 10 minutes (or less). We have the Sams marketing folks to thank for that. > :-) I'm on the list for "Teach Yourse

Re: SQL Help

2004-03-09 Thread Jeff Small
Hi Rodney, I'm not really able to help all that much, but what I suggest is trying the SQL mailing list. I replied and forwarded this to that list in an effort to get it over to "the SQL people". They're really great at this sort of stuff, and you might get a faster, better response from it. Have

Re: *sigh* what am I doing wrong again? It's been AGES since I've set this up...

2004-02-24 Thread Jeff Small
Nevermind. I took the pansy way out. I uninstalled CF, then just reinstalled it. I realized I simply answered the install "wizard" a little incorrectly. So I went thru it a little slower this time and just made sure I did everything right. Works like a charm now. Sorry Ben. Don't hate me. [Todays

Re: *sigh* what am I doing wrong again? It's been AGES since I've set this up...

2004-02-24 Thread Jeff Small
Crap. Now it's all hosed up. I set it up just like you said, found the file, changed port 8500 to 80, restarted, and now my CFAdministrator is all "wonky" No stylesheets, the main admin login page has broken images, and when I log in, it's all broken looking. Did I do something wrong?   - Ori

*sigh* what am I doing wrong again? It's been AGES since I've set this up...

2004-02-24 Thread Jeff Small
I'm in Dreamweaver. I've JUST set up a brand new computer, and I haven't set this stuff up in ages. My CF Administrator is at http://127.0.0.1:8500/CFIDE/administrator/index.cfm. I don't want that. I want it to be http://localhost/CFIDE/administrator/index.cfm. The first site I set up in Dreamweave

Re: OT: Question about Dreamweaver MX 2004

2004-02-18 Thread Jeff Small
Kevin Marino <[EMAIL PROTECTED]> wrote: >If this needs to be moved to a more appropriate list, >please do. > >Oh and is there a good Dreamweaver discussion list out >there, MM site is a bit lacking. You know, I went to house of fusion to actually look, because I've switched over to MX 2004 late

Re: DWMX "Insert" menu/toolbar question

2004-02-11 Thread Jeff Small
"Barney Boisvert" <[EMAIL PROTECTED]> wrote: >In the dropdown, the last item should be "show as tabs" >or something to that >effect. Daaamn. All day...all day I've been looking right at it. Well, it's always the most obvious things that humble you. Thanks so much. That's the one thing that

DWMX "Insert" menu/toolbar question

2004-02-11 Thread Jeff Small
Is there anyway to switch from the dropdown style of the insert menu back to the tabbed version? I've just gotten DWMX 2004 and this is my first day working with it, and I'm about to pull my hair out switching back and forth between the various insert toolbar dropdowns. I much prefer the tabbe

Re: How do I tell if I got FlashMX "professional"?

2004-02-10 Thread Jeff Small
On Tue, 10 Feb 2004 11:50:10 -0800   "Barney Boisvert" <[EMAIL PROTECTED]> wrote: >The installer from MM has both, and it picks which you >get based on the >license key.  You'll have to install it to tell for sure. Yeah, that's what I did. I was kinda nervous about installing it before I knew i

SOT: How do I tell if I got FlashMX "professional"?

2004-02-10 Thread Jeff Small
I just upgraded to StudioMX 2004, purchased from the Macromedia site by our IT guy, and I made sure that I told him I wanted Flash "Professional" as I understood that this one was the one you wanted if you wanted to integrate CF and Flash. When I downloaded it, I noticed that my Flash installe

Re: Clip at the last "space" character/Display "More..."

2003-12-22 Thread Jeff Small
On Mon, 22 Dec 2003 14:17:56 -0500   "Jerry Johnson" <[EMAIL PROTECTED]> wrote: > >string=trim(rereplaceNoCase(left(string,254),"(.*)[[:space:]]+.*$","\1"))> Bingo...say hello to my newest snippet... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Clip at the last "space" character/Display "More..."

2003-12-22 Thread Jeff Small
"Tony Weeg" <[EMAIL PROTECTED]> wrote: >sorry, I didn't read the "the field" line > >heh, >that's not ur answer > >back to my hole. That's okay...I think it's a *combination* of Left() and something else. I see it as starting with Left(), but ending at the first space character BEFOR

Clip at the last "space" character/Display "More..."

2003-12-22 Thread Jeff Small
Okay, I know this is an easy one, and I've actually *done* it before, I just can't remember where, or how... On output, I've got a field that I want to clip at the LAST space character before 254 characters are displayed. If it's a memo/text field, and it contains 500 characters, I only want t

Re: News Feed for NFL games

2003-11-04 Thread Jeff Small
On Tue, 4 Nov 2003 11:23:50 -0500   Dave Watts <[EMAIL PROTECTED]> wrote: >Ok then, by that logic, if Mike isn't at home to tell me >not to take a dump >on his doorstep, it's ok for me to do so. Thanks for the >clarification! >Mike, you might want to watch your step tonight, ok? Great...now I've

Re: Can the user's role in CFLOGIN be a list?

2003-07-17 Thread Jeff Small
On Thu, 17 Jul 2003 08:41:30 -0500 "Raymond Camden" <[EMAIL PROTECTED]> wrote: >You set your roles to "admin, creative" ? Notice the >space before >creative. " creative" is not equal to "creative" You da man...and my forehead hurts from banging it on my desk. ~~

Can the user's role in CFLOGIN be a list?

2003-07-17 Thread Jeff Small
I had always thought, that if I put a column in my table for users' "roles" that it could be a list, and IsUserInRole() would return a true or false if the user's role was contained in the role assigned in the cfloginuser tag. In other words, I had always thought you could have a role column

Re: Why isn't my output showing up right?

2003-02-12 Thread Jeff Small
on 2/12/03 12:55 PM, Dave Watts at [EMAIL PROTECTED] wrote: >> However this isn't working, whenever I put the loop >> in the output, it only returns one record. When I >> take OUT the loop, it returns all the records but >> only one rate: >> >> ... >> >> And here's version one of the output: >>

Why isn't my output showing up right?

2003-02-12 Thread Jeff Small
There are so many people yelling at me right now...I'm about to commit hari kari...please help me... Okay, My query works. I know this because I can "test" it by clicking on my recordset and clicking "test" and passing the appropriate variable. My Joins are working, this much I know. What I'm tr

Re: Okay, that settles it, I'm definitely having problems...anyone else? Q inside...

2003-02-10 Thread Jeff Small
> THE FUNCTION > > >