RE: Best way to access CFC's?

2004-11-29 Thread Andy Ousterhout
Why would you do that? -Original Message- From: Sean Corfield. Unless you specify a component *reference* in rather than a component name: -- ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.n

RE: Retrieving Hint from components

2004-11-28 Thread Andy Ousterhout
Thanks to everyone. getMetaData is just what I was looking for. Andy -Original Message- From: Douglas Knudsen take a look at getMetaData() eg On Fri, 26 Nov 2004 15:01:56 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > How would I retrieve the hint from a CFC: >

Retrieving Hint from components

2004-11-26 Thread Andy Ousterhout
How would I retrieve the hint from a CFC: Andy ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185463 Archives: htt

RE: CFC Objects in Drop Down

2004-11-15 Thread Andy Ousterhout
When I want to do this, I create a session variable and pass it's name to the form handler. -Original Message- From: Ryan Anklam [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 2:31 PM To: CF-Talk Subject: CFC Objects in Drop Down Is there any way to pass CFC's into a drop down

RE: CFC's and multiple returnVariable(s)

2004-11-15 Thread Andy Ousterhout
Return a structure. -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 3:14 PM To: CF-Talk Subject: CFC's and multiple returnVariable(s) Hello, I'm really new to using cfc and I really like them and I'm find them to be a great time saver. My

RE: MS SQL - Invalid Object Name

2004-11-13 Thread Andy Ousterhout
Thanks. That was the problem! Andy -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Saturday, November 13, 2004 3:03 PM To: CF-Talk Subject: RE: MS SQL - Invalid Object Name > From: Andy Ousterhout [mailto:[EMAIL PROTECTED] > I some how had a dup

MS SQL - Invalid Object Name

2004-11-13 Thread Andy Ousterhout
object name 'tabPeople'. Any ideas on how to fix this besides dropping, adding and re-filling with data? Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL60044 Phone 847.735.9890 Fax 847.735.9910 Yahoo IM: andy_ousterhout AOL

RE: Primary Key Justification

2004-11-09 Thread Andy Ousterhout
Michael: I see three basic problems with this assuming that other tables need to be linked to this table: 1. Size - Since the entire table needs to be replicated in each table that it is linked to, this is highly inefficient 2. Seek Performance - Searching and comparing long text fields can bec

RE: OT: How do I print out a directory listing in XP

2004-11-03 Thread Andy Ousterhout
-0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote: > I need to print out a directory listing for a disk I am sending to a printer. > Can someone tell me how to do this? > > Thanks, > Andy > > ~| Purch

OT: How do I print out a directory listing in XP

2004-11-03 Thread Andy Ousterhout
I need to print out a directory listing for a disk I am sending to a printer. Can someone tell me how to do this? Thanks, Andy ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.

RE: test

2004-11-01 Thread Andy Ousterhout
retest -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 11:35 AM To: CF-Talk Subject: test Testing Mark A. Kruger, CFG, MSCE www.cfwebtools.com www.necfug.com http://blog.mxconsulting.com ~

RE: CSS and Debugging

2004-10-19 Thread Andy Ousterhout
Shannon: I'd like to start using CSS for tables, but don't know how. Can you provide a sample table? Andy Shannon Palmer wrote: > OK. I'm converting some of my nested table page layouts to css and I've noticed that the debugging messages are hidden behind the page content now. Is there a trick

RE: Execute Query string w CFQUERYPARAM

2004-10-19 Thread Andy Ousterhout
Nail bitter down to the finish with major lawsuits to follow. Buy stock in antacid companies. Andy -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 9:03 AM To: CF-Talk Subject: RE: Execute Query string w CFQUERYPARAM Hey - in regards to t

RE: Why does this function not return a variable of Type Query

2004-10-09 Thread Andy Ousterhout
Yup, that's got it.  Stupid error.  Thanks.   -Original Message-   From: Dave Carabetta [mailto:[EMAIL PROTECTED]   Sent: Saturday, October 09, 2004 8:16 PM   To: CF-Talk   Subject: Re: Why does this function not return a variable of Type Query   On Sat, 9 Oct 2004 17:36:29 -0500,

RE: Why does this function not return a variable of Type Query

2004-10-09 Thread Andy Ousterhout
 http://exciteworks.com   Plans starting at -$12.95- including MS SQL Server!   Andy Ousterhout wrote:   > Why does this:   >   >   > returnvariable="qryPostalCodes"/>   > #IsQuery("qryPostalCodes")#   >   > Where:   >   >   > returntype="query"

Why does this function not return a variable of Type Query

2004-10-09 Thread Andy Ousterhout
Why does this: returnvariable="qryPostalCodes"/> #IsQuery("qryPostalCodes")# Where: returntype="query" displayname="Returns state list">        dbtype="ODBC" username="#instance.settings.DBRead.ID#" password="#instance.settings.DBRead.PW#" >     SELECT  State     FROM  tabZipCodes     GROUP

RE: SQL Question: Using query to generate report columns

2004-10-01 Thread Andy Ousterhout
#      something like that.   Doug   - Original Message -   From: Andy Ousterhout <[EMAIL PROTECTED]>   Date: Fri, 1 Oct 2004 10:52:28 -0500   Subject: SQL Question: Using query to generate report columns   To: CF-Talk <[EMAIL PROTECTED]>   I need to create a

SQL Question: Using query to generate report columns

2004-10-01 Thread Andy Ousterhout
I need to create a report that shows Customers in columns and items purchased in rows.  To simplify this discussion, assume that there are two tables: PurchasedItems     Customer     Item #     Qty Items     Item #     Name Is there a way to create a report that would look like this: Customer Na

RE: ANNOUNCE: CSS interview with Sandra Clark; Hal Helms Fusebox and Mach-II classes new dates and MAX

2004-09-30 Thread Andy Ousterhout
Sandy, Very nice.  Wish I was going to be in the area.  If you every do one in Chicago, let me know. Andy   -Original Message-   From: Michael Smith [mailto:[EMAIL PROTECTED]   Sent: Thursday, September 30, 2004 6:27 PM   To: CF-Talk   Subject: ANNOUNCE: CSS interview with Sandra Clark; Ha

RE: Backing Up off of server

2004-09-23 Thread Andy Ousterhout
Thanks.  This will help keep what little hair I have left on my head and out of my hands. Andy   -Original Message-   From: Bryan Stevenson [mailto:[EMAIL PROTECTED]   Sent: Thursday, September 23, 2004 1:14 PM   To: CF-Talk   Subject: Re: Backing Up off of server   Hmmm...best guess is t

RE: Backing Up off of server

2004-09-23 Thread Andy Ousterhout
I am getting error on NT User cfd/Kruyon.  Not sure why.  Don't know who this user is or why Export is looking for this name.  Any suggestions would be appreciated   -Original Message-   From: Bryan Stevenson [mailto:[EMAIL PROTECTED]   Sent: Thursday, September 23, 2004 12:21 PM   To: CF-T

RE: Backing Up off of server (WAS RE: Doug White - clickdoug.com)

2004-09-23 Thread Andy Ousterhout
Tried that, copied data, but not indices, stored proc's, relationships, etc...How do I do that? Andy -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 10:49 AM To: CF-Talk Subject: Re: Backing Up off of server (WAS RE: Doug White - clic

Backing Up off of server (WAS RE: Doug White - clickdoug.com)

2004-09-23 Thread Andy Ousterhout
OK,  I back-up, but to my current service provider's stuff (Please, CFDynamics, don't pull a Dougie!). Question:  How could I perform a backup to my computer.  MS SQL.  I am looking for data, tables, indices and relationships. Andy   -Original Message-   From: Thomas Chiverton [mailto:[EM

RE: Creating a unique ID from a Query Insert for use in an Update

2004-09-21 Thread Andy Ousterhout
I hear these guys ship! http://www.beeramerica.com/ Andy   -Original Message-   From: Steve Kahn [mailto:[EMAIL PROTECTED]   Sent: Tuesday, September 21, 2004 12:45 PM   To: CF-Talk   Subject: Re: Creating a unique ID from a Query Insert for use in an Update   The primary key needed to

RE: Creating a unique ID from a Query Insert for use in an Update

2004-09-21 Thread Andy Ousterhout
1.  Which version of MS SQL? 2.  Do you have a field in TrackUsers that is set as the Identity field? 3.  Try setting NoCount OFF   -Original Message-   From: Steve Kahn [mailto:[EMAIL PROTECTED]   Sent: Tuesday, September 21, 2004 12:28 PM   To: CF-Talk   Subject: Re: Creating a unique ID

RE: Creating a unique ID from a Query Insert for use in an Update

2004-09-21 Thread Andy Ousterhout
What does SET NOCOUNT do? Andy   -Original Message-   From: Paul Hastings [mailto:[EMAIL PROTECTED]   Sent: Tuesday, September 21, 2004 11:14 AM   To: CF-Talk   Subject: Re: Creating a unique ID from a Query Insert for use in an Update   >   >   set nocount on   >   Insert into t

RE: Creating a unique ID from a Query Insert for use in an Update

2004-09-21 Thread Andy Ousterhout
Note that this issues that trackusers.UserId is Auto Increment field.   -Original Message-   From: Steve Kahn [mailto:[EMAIL PROTECTED]   Sent: Tuesday, September 21, 2004 10:33 AM   To: CF-Talk   Subject: Re: Creating a unique ID from a Query Insert for use in an Update   Yes Microsoft SQ

RE: Creating a unique ID from a Query Insert for use in an Update

2004-09-21 Thread Andy Ousterhout
yes.   -Original Message-   From: Steve Kahn [mailto:[EMAIL PROTECTED]   Sent: Tuesday, September 21, 2004 10:33 AM   To: CF-Talk   Subject: Re: Creating a unique ID from a Query Insert for use in an Update   Yes Microsoft SQL:   Is this correct usage?    set nocount on Ins

RE: Creating a unique ID from a Query Insert for use in an Update

2004-09-21 Thread Andy Ousterhout
What database?  For MS SQL:   set nocount on   Insert into   Select scope_identity() as myID   Set nocount on Then:     Andy   -Original Message-   From: Steve Kahn [mailto:[EMAIL PROTECTED]   Sent: Tuesday, September 21, 2004 10:12 AM   To: CF-Talk   Subject: Creat

RE: Return Links (best practice)

2004-09-07 Thread Andy Ousterhout
I have a security check in my Application.cfm that checks to see if the requested page requires a login, and if the person is not currently logged in, calls the logon page, sending it the requested page. In the logon page, I copy all URL to the statement and create TYPE="HIDDEN"> for each FORM v

SSL Question

2004-09-01 Thread Andy Ousterhout
I only have a small portion of my site - placing orders and changing customer information where I care if the data is encrypted over the net.  I currently only use https: for these related pages. Should I be concerned about sending ordering information (only last 4 digits of Credit Card), customer

RE: Download file

2004-08-28 Thread Andy Ousterhout
: Download file   heh, man ok place this in your HTML doc:     this file   Ian   - Original Message -   From: Andy Ousterhout <[EMAIL PROTECTED]>   Date: Thu, 26 Aug 2004 21:37:03 -0500   Subject: RE: Download file   To: CF-Talk <[EMAIL PROTECTED]>   Actually, you are r

RE: Download file

2004-08-26 Thread Andy Ousterhout
Actually, you are right on that this is probably so easy that you don't understand why I am asking.  I just don't know how to put the direct link in.   -Original Message-   From: Chris Johnston [mailto:[EMAIL PROTECTED]    I am still a little unclear as to what exactly you are trying to  

RE: Download file

2004-08-26 Thread Andy Ousterhout
: CF-Talk   Subject: Re: Download file   On Thu, 26 Aug 2004 15:39:57 -0500, Andy Ousterhout   <[EMAIL PROTECTED]> wrote:   > What command do I use to download a file I've already created?   >   From where, using what kind of technology over what kind of   connection? More detai

Download file

2004-08-26 Thread Andy Ousterhout
What command do I use to download a file I've already created? Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: Calculating Sales Tax within the US

2004-08-25 Thread Andy Ousterhout
That is my knowledge as well, unless you have a physical presence in the Ship To state.  So if you have a small sales office in Illinois, but everything else out of TX, you are still supposed to pay state, county, & city sales taxes when shipping to Illinois. Andy   -Original Message-   Fr

RE: Calculating Sales Tax within the US

2004-08-25 Thread Andy Ousterhout
General rule is that you only have to charge sales tax on those shipments to states were you have a physical presence.  If they are just a web store located in TX, then they should be able to give you their state's sales tax rules. Andy -Original Message- From: Brook Davies [mailto:[EMAI

RE: categories, subcategories and sub-subcategories in a database

2004-08-25 Thread Andy Ousterhout
When building hierarchal tables I always recommend having both a parent, left sibling and left-most child pointers.  This makes it easy to traverse the hierarchy in all directions. Andy   -Original Message-   From: Nando [mailto:[EMAIL PROTECTED]   Sent: Tuesday, August 24, 2004 10:25 PM  

RE: Breadcrumbs - do you fully track users?

2004-08-23 Thread Andy Ousterhout
Jim, I thought that breadcrumbs was the path you took, so you could go back 2-3 steps rather than using back/back, etc... Andy   -Original Message-   From: Jim Davis [mailto:[EMAIL PROTECTED]   Sent: Monday, August 23, 2004 10:06 AM   To: CF-Talk   Subject: RE: Breadcrumbs - do you fully t

RE: Fake online orders--how common are they?

2004-08-21 Thread Andy Ousterhout
I've entered false orders when that is the only way I can get pricing. Andy   -Original Message-   From: Samuel Neff [mailto:[EMAIL PROTECTED]   Sent: Friday, August 20, 2004 12:33 PM   To: CF-Talk   Subject: OT: Fake online orders--how common are they?   For people that run e-commerce si

RE: index of cities and states in US

2004-08-17 Thread Andy Ousterhout
You could use a Zip-code table as a starter.  I don't know if any Zip codes cover two cities, but it would be good start. Andy   -Original Message-   From: Mark Drew [mailto:[EMAIL PROTECTED]   Sent: Tuesday, August 17, 2004 6:57 AM   To: CF-Talk   Subject: Re: index of cities and states i

RE: ABA routing numbers?

2004-08-16 Thread Andy Ousterhout
You can buy a book and also a computer file.  Go to the American Banking Association site for more information. Andy   -Original Message-   From: Damien McKenna [mailto:[EMAIL PROTECTED]   Sent: Monday, August 16, 2004 10:12 AM   To: CF-Talk   Subject: SOT: ABA routing numbers?   I've got

RE: Error Handling

2004-08-13 Thread Andy Ousterhout
error information.   If you need more details, let me know and I'll find a tutorial real   quick via google, but I'm on my way out of the office for the weekend.   On Fri, 13 Aug 2004 14:17:35 -0500, Andy Ousterhout   <[EMAIL PROTECTED]> wrote:   > Joe,   >  Do you have an

RE: Error Handling

2004-08-13 Thread Andy Ousterhout
Joe, Do you have an example of the _javascript_? Andy   -Original Message-   From: Joe Rinehart [mailto:[EMAIL PROTECTED]   Sent: Friday, August 13, 2004 1:57 PM   To: CF-Talk   Subject: Re: Error Handling   Lee,   This is usually accomplished by specifying an error template via the   CF

RE: forms and sub-forms best practices feedback desired

2004-08-08 Thread Andy Ousterhout
I have created classes for each of my forms, whether multi-page or not.  The classes, using gets and sets retrieve and store information to the DB and perform all validation.  I persist an instance of the class in a session variable to maintain state between screens for both a single screen form va

Re: Cfcatch issues.

2004-07-26 Thread Andy Ousterhout
This works fine: Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

OT: Page design Contact work

2004-06-10 Thread Andy Ousterhout
I am looking for contractor who could build a page that prints an invoice. Specifically I need to the "page" to: 1.  When called, create a print-formatted invoice that isn't displayed and automatically open windows print dialog.  Environment is IE 6.0, _javascript_ enabled 2.  Manage multiple page

RE: update an array

2004-06-03 Thread Andy Ousterhout
Here is what you could do: In form:     In Action Page:     Andy -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Thursday, June 03, 2004 2:02 PM To: CF-Talk Subject: update an array   I have a form that displays information from an array into input text fi

More on Invoices

2004-05-28 Thread Andy Ousterhout
Ok, bloated form, but looks nice.  How would I catch if I need to start a second page?  Do I need to count lines and characters in each line's descriptions to determine if time for new page or is there another way?  CSS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [Us

RE: Invoice Template

2004-05-28 Thread Andy Ousterhout
section.   Search for "invoice".   Download one you like.   Save as HTML.   Voila!!! The worlds largest, most bloated code ever. But they do look nice.   :-)   Mike   > -Original Message-----   > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]   > Sent: Friday, May 28, 2004

Duplicates (was RE: Invoice Template)

2004-05-28 Thread Andy Ousterhout
  Save as HTML.   Voila!!! The worlds largest, most bloated code ever. But they do look nice.   :-)   Mike   > -Original Message-----   > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]   > Sent: Friday, May 28, 2004 1:27 PM   > To: CF-Talk   > Subject: Invoice Template   

Invoice Template

2004-05-28 Thread Andy Ousterhout
Does anyone have an invoice template for printing that they can share with me? CSS or table-based are all fine with me. Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Using CFCATCH to display default error messages

2004-05-23 Thread Andy Ousterhout
Are the output statements within a catch any block?   -Original Message-   From: Stan Winchester [mailto:[EMAIL PROTECTED]   Sent: Saturday, May 22, 2004 11:46 PM   To: CF-Talk   Subject: Re: Using CFCATCH to display default error messages   I've read the documentation, and when I use the

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-20 Thread Andy Ousterhout
I would use a case construct.  Or even use the MOD function with an array to load the values or count of values into an array: // NOTE:  THIS IS OFF OF THE TOP OF A VERY EMPTY HEAD SO FORGIVE SYNTAX ERRORS RangeCount = 6;//Create ranges of 1-6, 7-12, etc NumRanges

RE: **UPDATE** Arrange sequential selections into ranges how to???

2004-05-20 Thread Andy Ousterhout
I would use a case construct.  Or even use the MOD function with an array to load the values or count of values into an array: // NOTE:  THIS IS OFF OF THE TOP OF A VERY EMPTY HEAD SO FORGIVE SYNTAX ERRORS RangeCount = 6;//Create ranges of 1-6, 7-12, etc NumRanges

RE: Does Javascript work within AOL's browser????

2004-05-13 Thread Andy Ousterhout
Thanks.  I've got a User that emailed me using an AOL address and he/she can't use functionality that requires _javascript_.  I've got an email into him/her asking what type of computer they are using and browser type.  Thought I'd do a little preliminary research about AOL. Are you aware of brows

Does Javascript work within AOL's browser????

2004-05-13 Thread Andy Ousterhout
Does anyone know if _javascript_ works in AOL's browser? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Site being blocked for content

2004-04-21 Thread Andy Ousterhout
-     From: Andy Ousterhout     To: CF-Talk     Sent: Tuesday, April 20, 2004 3:56 PM     Subject: Site being blocked for content     Somehow, our site, which only sells cookies, no nudity or profanity,  is being     blocked by at least one school system for content.     Does anyone have a list of

Site being blocked for content

2004-04-20 Thread Andy Ousterhout
Somehow, our site, which only sells cookies, no nudity or profanity,  is being blocked by at least one school system for content. Does anyone have a list of service providers that provide blocking services? I'd really like to find out who is blocking us and get us off of that list!

RE: Listing all available DSN names

2004-04-19 Thread Andy Ousterhout
site.   ---   Exciteworks -- expert hosting for less!   http://exciteworks.com   specializing in reseller accounts   Andy Ousterhout wrote:   > I am trying to validate the DSN names that my service provider as   > set-up for   > me.  Is there a way that I can list those availa

RE: Listing all available DSN names

2004-04-18 Thread Andy Ousterhout
the service factory.   I think Jochem has some code samples on his site.   ---   Exciteworks -- expert hosting for less!   http://exciteworks.com   specializing in reseller accounts   Andy Ousterhout wrote:   > I am trying to validate the DSN names that my service provider as   > set-

Listing all available DSN names

2004-04-18 Thread Andy Ousterhout
I am trying to validate the DSN names that my service provider as set-up for me.  Is there a way that I can list those available to me out? Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL    60044 Phone 847.735.9890 Fax 847.735.9910 Yah

RE: ZIP code validation

2004-04-18 Thread Andy Ousterhout
Does this come with longitude/latitude?   -Original Message-   From: Doug White [mailto:[EMAIL PROTECTED]   Sent: Sunday, April 18, 2004 6:42 PM   To: CF-Talk   Subject: Re: ZIP code validation   I purchase mine direct from the USPS   ==   We can get ri

RE: SQL question. Someone help!!!

2004-04-16 Thread Andy Ousterhout
Jeff, why not this (off of top of my head, so syntax surely wrong...) delete where key in (     select key, count(key) as DupCount     from D1.field = d2.field AND (continue for all fields that will ensuer that only duplicates included)     group by (same list as from)     having DupCount > 1 )   

RE: Securing CF Apps.

2004-03-23 Thread Andy Ousterhout
Mission accomplished!  :-)   -Original Message-   From: Rob [mailto:[EMAIL PROTECTED]   Sent: Tuesday, March 23, 2004 5:09 PM   To: CF-Talk   Subject: RE: Securing CF Apps.   On Tue, 2004-03-23 at 14:58, Andy Ousterhout wrote:   > Let the semantic battle begin..   >   > U

RE: Securing CF Apps.

2004-03-23 Thread Andy Ousterhout
Let the semantic battle begin.. Unless the point of this discussion is to argue, why not start with how you define an application? And Barney, browsing is the key action to the application.  Without it, no purchases.  From a usability, both the ability to quickly find the product and the linka

RE: Securing CF Apps.

2004-03-23 Thread Andy Ousterhout
Bryan, Depends if you validate access at the row or column level in your database. If you do, then a User playing with a URL will still not see anything they shouldn't.  If you don't, then someone who wants to can still break the encryption and troll your data. Andy   and it's not that little

RE: Emailing Form.FieldNames results via looping?

2004-03-18 Thread Andy Ousterhout
break it!  :-)   -Original Message-   From: Matt Robertson [mailto:[EMAIL PROTECTED]   Sent: Thursday, March 18, 2004 5:27 PM   To: CF-Talk   Subject: RE: Emailing Form.FieldNames results via looping?   Thx Dave,   The app does work well as is and, if it ain't broke...   

RE: Emailing Form.FieldNames results via looping?

2004-03-18 Thread Andy Ousterhout
If it works for form, it will work for all scopes.  Just try it.   -Original Message-   From: Matt Robertson [mailto:[EMAIL PROTECTED]   Sent: Thursday, March 18, 2004 3:11 PM   To: CF-Talk   Subject: RE: Emailing Form.FieldNames results via looping?   Dave watts wrote:   >I'm pretty sure

RE: Emailing Form.FieldNames results via looping?

2004-03-18 Thread Andy Ousterhout
You don't need CFOUTPUT inside of CFMAIL.  Second, skip the evaluate and just use #form[thisField]# Andy   -Original Message-   From: Bob Haroche [mailto:[EMAIL PROTECTED]   Sent: Thursday, March 18, 2004 12:24 PM   To: CF-Talk   Subject: Emailing Form.FieldNames results via looping?   I

RE: Create View problem

2004-03-12 Thread Andy Ousterhout
Thanks.  That did it.   -Original Message-   From: Jochem van Dieten [mailto:[EMAIL PROTECTED]   Sent: Friday, March 12, 2004 4:12 PM   To: CF-Talk   Subject: Re: Create View problem   Andy Ousterhout wrote:   > I am trying to create a view in MS ACCESS and am getting the following er

Create View problem

2004-03-12 Thread Andy Ousterhout
I am trying to create a view in MS ACCESS and am getting the following error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition. Here is the create statement.  I've tested the select portion separatey and that works. CREATE

RE: Marketing / Design ???

2004-03-09 Thread Andy Ousterhout
The question is one of usability, as already noted above.  If the majority of orders contain more than 1 item per order, then it would seem to me that the system should stay in shopping mode until requested to check-out.  However, the system would need to make it clear to the user that the item was

RE: Newbie Locking Question

2004-03-07 Thread Andy Ousterhout
No.   -Original Message-   From: Bob Haroche [mailto:[EMAIL PROTECTED]   Sent: Sunday, March 07, 2004 6:24 PM   To: CF-Talk   Subject: Newbie Locking Question   Using CF 5...   If I set an Application variable once in Application.cfm that is   (theoretically) never going to change, eg:  

OT: Looking for freelance graphics person

2004-03-03 Thread Andy Ousterhout
I am looking for a freelance graphics person who can clean-up and reshadow professionally taken product pictures.  Can anyone who knows someone email me off-list? Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL    60044 Phone 847.735.989

RE: SQL Brainblock

2004-03-01 Thread Andy Ousterhout
iif( [field] IS NULL, NullValue, [FIELD])   -Original Message-   From: Mickael [mailto:[EMAIL PROTECTED]   Sent: Monday, March 01, 2004 9:13 AM   To: CF-Talk   Subject: Re: SQL Brainblock   I am using Access     - Original Message -     From: [EMAIL PROTECTED]     To: CF-Talk     S

RE: SQL Brainblock

2004-03-01 Thread Andy Ousterhout
ISNULL(field, Value if Null) in MS SQL   -Original Message-   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]   Sent: Monday, March 01, 2004 8:29 AM   To: CF-Talk   Subject: RE: SQL Brainblock   what db?   you would do it with   nvl(act_val, val_if_null)   in oracle (i think :-)   --

RE: Trying to group dates in dropdown list

2004-02-26 Thread Andy Ousterhout
Please provide us with the query you are try to get working.  I do this with a Select ... Year(DateField) As DateYear, Month(DateField) As DateMonth >From tabTable Group By Year(DateField), Month(DateField) Order By Year(DateField), Month(DateField); Then my loop to build drop down works perfectly

RE: extends + init() = returntype confusion

2004-02-25 Thread Andy Ousterhout
parent CFC.   > -Original Message-----   > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]   > Sent: Wednesday, February 25, 2004 3:13 PM   > To: CF-Talk   > Subject: RE: extends + init() = returntype confusion   >   > Interesting.  So if I "override" a component in parent

RE: extends + init() = returntype confusion

2004-02-25 Thread Andy Ousterhout
quite troublesome to do effectively.   Cheers,   barneyb   > -----Original Message-   > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]   > Sent: Wednesday, February 25, 2004 2:26 PM   > To: CF-Talk   > Subject: RE: extends + init() = returntype confusion   >   > Barney,   > T

RE: extends + init() = returntype confusion

2004-02-25 Thread Andy Ousterhout
Barney, This is the first I've seen/heard a "super" qualifier.  What does it point to/stand for? Andy   -Original Message-   From: Barney Boisvert [mailto:[EMAIL PROTECTED]   Sent: Wednesday, February 25, 2004 4:18 PM   To: CF-Talk   Subject: RE: extends + init() = returntype confusion   

RE: CSS

2004-02-25 Thread Andy Ousterhout
  approachable book, but it's best used if you can spend some time to work   through each project.   Cascading Style Sheets 2.0 Programmer's Reference   by Eric A. Meyer   - This is a really good desk reference once you have a grasp of CSS.   -Kevin   - Original Message -   Fro

RE: CSS

2004-02-25 Thread Andy Ousterhout
Thanks. How do I specify a separate media type in the CSS? I clearly don't know much about CSS.  Is there a good book I can get as a reference guide?   ll that is necessary is to use instead of   src="" media="screen"> (can also do this with import). What I tend to do is   reverse the two when

RE: CSS

2004-02-25 Thread Andy Ousterhout
  -Original Message-   From: Andy Ousterhout [mailto:[EMAIL PROTECTED]   Sent: 25 February 2004 18:35   To: CF-Talk   Subject: CSS   Can someone point me to a site that I can use to learn how to use CSS to   design pages to be printed versus for display?   Thanks,   Andy [Todays Threads] [This

CSS

2004-02-25 Thread Andy Ousterhout
Can someone point me to a site that I can use to learn how to use CSS to design pages to be printed versus for display? Thanks, Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Easy String Question?

2004-02-24 Thread Andy Ousterhout
Left("3_2_000 ",find("_","3_2_000 ")-1)   -Original Message-   From: Eric [mailto:[EMAIL PROTECTED]   Sent: Tuesday, February 24, 2004 10:19 PM   To: CF-Talk   Subject: Easy String Question?   I have a string and its late.  :)   I have a string 3_2_000 and what I need is the numbers befor

DROP VIEW problem

2004-02-24 Thread Andy Ousterhout
I've got DROP privileges with MX Administrator. Andy Ousterhout O'My Goodness www.omygoodness.com 910 Sherwood Drive, Unit 19 Lake Bluff, IL    60044 Phone 847.735.9890 Fax 847.735.9910 Yahoo IM:  andy_ousterhout [Todays Threads] [This Message] [Subscription] [Fast Unsub

RE: Microsoft Access limitations

2004-02-23 Thread Andy Ousterhout
The error message says that it can't find your table.  Does it exist in DSN and if so, are you using any Access User security? Andy   -Original Message-   From: Anna Smith [mailto:[EMAIL PROTECTED]   Sent: Monday, February 23, 2004 3:58 PM   To: CF-Talk   Subject: Microsoft Access limitati

RE: sql question

2004-02-23 Thread Andy Ousterhout
The way I did this is :     1.  Add a property, IsKeeper, default False.     2.  Create grouped query on all of the fields that you want to be sure are the same before deleting a row     3.  Create update query setting IsKeeper to True where Key is in query you just created.     4.  Visually inspec

RE: File Not Found error

2004-02-22 Thread Andy Ousterhout
Very strange.  So I make a minor change to the file, added a comment, just to see what happens, and it works. Thanks for the help.   -Original Message-   From: Andy Ousterhout [mailto:[EMAIL PROTECTED]   Sent: Sunday, February 22, 2004 11:27 AM   To: CF-Talk   Subject: File Not Found

RE: File Not Found error

2004-02-22 Thread Andy Ousterhout
This program has worked for months.  It is being called via form action.  The correct URL is showing in the browser address line: https://www.omygoodness.com/maintenance/prdgrpdateact.cfm I've looked at the directory and the file is there.  I've deleted it, then put it back.  Nothing. Should I a

File Not Found error

2004-02-22 Thread Andy Ousterhout
File not found: /maintenance/prdgrpdateact.cfm Why would I be getting this error when I can see the file via FTP? Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Reg Expressions?

2004-02-19 Thread Andy Ousterhout
Nice link.  Thanks   There is a section  called "Regular Expressions" that I find has a nice   reference, could probably fit on a page if you cut and paste it   http://www.webdevelopersjournal.com/articles/jscript_forms2.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe

RE: SQL Select starting at xth row

2004-02-18 Thread Andy Ousterhout
Thanks.  This will work in MS as well.   -Original Message-   From: Philip Arnold [mailto:[EMAIL PROTECTED]   Sent: Wednesday, February 18, 2004 9:40 AM   To: CF-Talk   Subject: RE: SQL Select starting at xth row   > From: Andy Ousterhout   >   > Is there a way to have an S

RE: SQL Select starting at xth row

2004-02-18 Thread Andy Ousterhout
MS Access now, moving to MS SQL 1 month   -Original Message-   From: Pascal Peters [mailto:[EMAIL PROTECTED]   Sent: Wednesday, February 18, 2004 9:15 AM   To: CF-Talk   Subject: RE: SQL Select starting at xth row   What db?   > -Original Message-   > From: Andy Oust

SQL Select starting at xth row

2004-02-18 Thread Andy Ousterhout
Is there a way to have an SQL Select return information starting at the xth row? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Regular expression help

2004-02-16 Thread Andy Ousterhout
What regular _expression_ would find a "#" followed by any number of blanks, followed by 2-3 numbers For example, I want to return 45 from this string: Testing this string # 45 to 46 Andy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Back Button and form resubmittal/display

2004-02-14 Thread Andy Ousterhout
Thanks.   -Original Message-   From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]   Sent: Saturday, February 14, 2004 2:36 PM   To: CF-Talk   Subject: Re: Back Button and form resubmittal/display   > Is there a way that I can have a form redisplayed when the   > back button is   > used?   >

Back Button and form resubmittal/display

2004-02-14 Thread Andy Ousterhout
Is there a way that I can have a form redisplayed when the back button is used? Right now the "Page Expired" message shows and the user has to refresh and resubmit.  All I want to have happen is to have the previous page shown just like it was before a submit button was pressed. Andy [Todays Thr

RE: Integrating bar code readers with web apps

2004-02-14 Thread Andy Ousterhout
Think of bar code reading as just a simple, easy way to enter an identification number.  All the reader does is read the code and input it into the keyboard buffer, saving the typing. Andy -Original Message- From: stas [mailto:[EMAIL PROTECTED] Sent: Saturday, February 14, 2004 10:57 AM

<    1   2   3   4   5   >