RE: custom tag help

[Pascal Peters]

Phillip,

If you are using CF5, this wont work because variables wasn't a
structure back then. I'm just telling you this, not to correct James,
but because you are using CT and not CFC (so I think you might be on pre
CFMX).

Before CFMX you would have to (reluctantly) use Evaluate():

#Evaluate(attributes.queryname  .  attributes.fieldname)#

Pascal

 -Original Message-
 From: James Holmes [mailto:[EMAIL PROTECTED]
 Sent: 19 October 2004 06:40
 To: CF-Talk
 Subject: RE: custom tag help
 
 The variables scope should work within the custom tag:
 
 cfoutput query=#ATTRIBUTES.QUERYNAME#
 #VARIABLES[ATTRIBUTES.QUERYNAME][attributes.fieldname][currentrow]#
 /cfoutput
 
 Note that I dropped the query name from currentrow as it's now a
dynamic
 name and you can rely on CF to figure out what currentrow means inside
a
 cfoutput tag.
 
 -Original Message-
 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, 19 October 2004 11:26
 To: CF-Talk
 Subject: RE: custom tag help
 
 Thanks James. That does work if you assume that display is the query
name,
 but what if the query name is stored in an attributes.queryname value?
 I've
 played around with what you gave me but I can't seem to get it to
work.
 any
 thoughts?

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181812
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Securing the ColdFusion Administrator...

[Thomas Chiverton]

On Saturday 16 Oct 2004 01:23 am, Troy Simpson wrote:
 Any ideas why?

Have you read httpd.apache.org ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181814
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: [sot] moving to JSP

[Mark Drew]

Do you mean Strutts ?


On Mon, 18 Oct 2004 15:44:34 -0400, Douglas Knudsen
[EMAIL PROTECTED] wrote:
 maybe a cf-community thingbut
 wanting to move to JSP stuffs, anyone out there move to JSP stuffs
 from the CF world?   Is there really such a thing as RAD in the
 Java/JSP world?  I'm used to being on like 6 to 10 projects in a given
 year, can this happen in the JSP world?  Anyone out htere blending the
 two, JSP and CF?
 
 --
 Douglas Knudsen
 http://www.cubicleman.com
 this is my signature, like it?
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181815
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Re: [sot] moving to JSP

[simon]

I've been working a lot on CF/Java hybrids... to be honest, I don't end-up 
using JSP much.  In the J2EE world, JSP is primarily a presentation tier 
construct... ColdFusion is much better suited for the presentation tier.  Java 
Beans, EJBs, simple classes, and sometimes servlets, are often times a good 
place for logic (it depends on your needs). I've used CFML for the presentation 
tier in STRUTS based java applications - if your java applications are using 
STRUTS then that's an option.
The best good use for JSPs I've found hasn't been a use of JSPs themselves, but 
of JSP tags.  JSP tags are easily imported for use in CFML pages with the 
CFIMPORT tag, and they can be a good place to put simple shared functionality 
that's better written in Java than CFML and are also sometimes a good way to 
provide a friendlier interface to your EJBs and other Java bits.
Regarding your question about whether or not you could work on 6-10 projects in 
a year if you're doing Java work - if it's JSP development then that's 
certainly feasible... it's not impossible if you're doing more serious Java 
development, but I'd say it's not as common due to the fact that those 
applications are typically more complex. It really all depends on what you're 
doing.

~Simon


 
 Do you mean Strutts ?
 
 
 On Mon, 18 Oct 2004 15:44:34 -0400, Douglas Knudsen
 [EMAIL PROTECTED] wrote:
  maybe a cf-community thingbut
  wanting to move to JSP stuffs, anyone out there move to JSP stuffs
  from the CF world?   Is there really such a thing as RAD in the
  Java/JSP world?  I'm used to being on like 6 to 10 projects in a given
  year, can this happen in the JSP world?  Anyone out htere blending the
  two, JSP and CF?
  
  --
  Douglas Knudsen
  http://www.cubicleman.com
  this is my signature, like it?
  
  
 
 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181816
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Field Naming

[Andrew Dixon]

Hi Everyone.

I'm just starting a major project for a government client and the
first job is to design the database. Is there any recongnised
convention on the naming of database fields. In the past I have always
named them [table_name_field_name] for example: projects_id where the
table is called 'projects' and the field is called 'id'.

Thanks in advanced.

Best Regards

Andrew.

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181817
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Execute Query string w CFQUERYPARAM

[Aaron Rouse]

I'd assume that is something that started at a certain version of CF? 
Does it take just one cfqueryparam in the statement for that to
happen?  Such as a insert statement with two columns, one of which has
a cfqueryparam and the other is a hard coded value(for whatever
reason).


On Tue, 19 Oct 2004 10:24:52 +0200, Jochem van Dieten
[EMAIL PROTECTED] wrote:
 Joseph Flanigan wrote:
  Why it is better in your opinion to use stored procedures for
  insert/update/deletes?
 
  The quick answer is that stored procedures are pre-complied execution plans.
 
 So are queries that use cfqueryparam. (They are translated to a
 JDBC prepared statement.)
 
 Jochem

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181818
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Getting the last X days' worth of posts.

[Keith Gaughan]

This is something for my personal site, and nothing work related.

On my weblog homepage, I want it to list all the posts in the last seven
days that have posts. Here's what I'm doing right now:

SELECT   DISTINCT E1.entry_id, E1.date_posted, E1.title, E1.body
FROM entries AS E1, entries AS E2
WHEREE1.date_posted = E2.date_posted
GROUP BY E2.date_posted
HAVING   COUNT(DISTINCT TO_DAYS(E1.date_posted)) = @nDays
ORDER BY E1.date_posted DESC

Where @nDays is the number of days to show.

Now, this was a quick hack to get it working. It's far from efficient,
and since I wrote it I've been searching for a better way of doing this
but without any luck. Query caching makes it bearable, but it's those
occasional 2 second lags when the cache times out that cause the pain.

I'm using MySQL 4.0.6, so no subselects.

Any ideas?

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://www.digital-crew.com/

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181819
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Aaron DC]

Hi Andrew

Based purely on ituition / gut feel / experience, I never name a table as
its plural, always singular form, so Project table, not Projects table.

Sorry I know of no published field naming standard, but do something similar
to what you have suggested.

Aaron

- Original Message -
From: Andrew Dixon [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 9:30 PM
Subject: OT: Field Naming


 Hi Everyone.

 I'm just starting a major project for a government client and the
 first job is to design the database. Is there any recongnised
 convention on the naming of database fields. In the past I have always
 named them [table_name_field_name] for example: projects_id where the
 table is called 'projects' and the field is called 'id'.



~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181820
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Tangorre, Michael]

 From: Andrew Dixon [mailto:[EMAIL PROTECTED] 
 I'm just starting a major project for a government client and 
 the first job is to design the database. Is there any 
 recongnised convention on the naming of database fields. In 
 the past I have always named them [table_name_field_name] for 
 example: projects_id where the table is called 'projects' and 
 the field is called 'id'.

I tend to go with the following:

For example:

Table: APPLICATION_USER

Field (primary key): APPLICATION_USER_ID

Additional Fields:
FIRST_NAME
MIDDLE_NAME
LAST_NAME
EMAIL_ADDRESS
ADDRESS1
ADDRESS2

Etc...

Michael T. Tangorre 

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181821
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Another Is this Homesite feature in DW? question

[Peterson, Andrew S.]

Hi,
 
Homesite has a nice AutoCompletion feature whereby you enter a trigger
string and it spits out the remainder of the code for you. For instance,
you enter '#att and it will automatically add ributes.# and even place
the cursor before the pound sign and after the period. I cannot find
this feature in DWMX2K. Is it in there somewhere or is there a similar
feature?
 
TIA.
 
Sincerely,
 
Andrew


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181822
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Re: [sot] moving to JSP

[Douglas Knudsen]

danke simon.  good points about using CF as the pres layer.  i might
be doing some websphere development, someone here called it the M1
Abrahms of app servers, lol.  With that cost, hard to convince them to
put CF on the box as well.  we shall see.

mark, ok strutts.  strutts is a framework, like machii is, correct?  i
have been messing with machii lately.  a RAD framework?  h.now
i suppose one mans RAD is another mans SAD, slow app developent. 
considering what simon mentioned, that Java/JSP/J2EE projects tend to
be more complex, we can see RAD mean something different, eh?

kewl...thanks for the tidbits.

Doug


On Tue, 19 Oct 2004 05:39:56 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 I've been working a lot on CF/Java hybrids... to be honest, I don't end-up
 using JSP much.  In the J2EE world, JSP is primarily a presentation tier
 construct... ColdFusion is much better suited for the presentation tier.  Java
 Beans, EJBs, simple classes, and sometimes servlets, are often times a good
 place for logic (it depends on your needs). I've used CFML for the presentation
 tier in STRUTS based java applications - if your java applications are using
 STRUTS then that's an option.
 The best good use for JSPs I've found hasn't been a use of JSPs themselves, but
 of JSP tags.  JSP tags are easily imported for use in CFML pages with the
 CFIMPORT tag, and they can be a good place to put simple shared functionality
 that's better written in Java than CFML and are also sometimes a good way to
 provide a friendlier interface to your EJBs and other Java bits.
 Regarding your question about whether or not you could work on 6-10 projects in
 a year if you're doing Java work - if it's JSP development then that's
 certainly feasible... it's not impossible if you're doing more serious Java
 development, but I'd say it's not as common due to the fact that those
 applications are typically more complex. It really all depends on what you're
 doing.
 
 ~Simon
 
 
 
  Do you mean Strutts ?
 
 
  On Mon, 18 Oct 2004 15:44:34 -0400, Douglas Knudsen
  [EMAIL PROTECTED] wrote:
   maybe a cf-community thingbut
   wanting to move to JSP stuffs, anyone out there move to JSP stuffs
   from the CF world?   Is there really such a thing as RAD in the
   Java/JSP world?  I'm used to being on like 6 to 10 projects in a given
   year, can this happen in the JSP world?  Anyone out htere blending the
   two, JSP and CF?
  
   --
   Douglas Knudsen
   http://www.cubicleman.com
   this is my signature, like it?
  
  
 
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181823
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Field Naming

[Keith Gaughan]

Andrew Dixon wrote:

 Hi Everyone.
 
 I'm just starting a major project for a government client and the
 first job is to design the database. Is there any recongnised
 convention on the naming of database fields. In the past I have always
 named them [table_name_field_name] for example: projects_id where the
 table is called 'projects' and the field is called 'id'.

None that I know of, but what I do is use plural in general for the
table names, e.g. categories, posts. After all, we are talking about
sets here, and it's natural to pluralise them.

Fields I give the singular form to, so the projects would have a field
called project_id. The reasoning being that whereas the set contains
many projects, hence the pluralisation, each tuple refers to just one,
so it's singular.

K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://www.digital-crew.com/

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181824
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Field Naming

[Andrew Dixon]

After a quick search on Google I found this:

http://www.ss64.com/orasyntax/naming.html

Which seems like a good little guide. It mentions an ISO standard
(ISO11157) but I had a quick look at this and this appears to be a
more general standard for data type naming.

Andrew.


On Tue, 19 Oct 2004 14:11:15 +0100, Keith Gaughan
[EMAIL PROTECTED] wrote:
 Andrew Dixon wrote:
 
  Hi Everyone.
 
  I'm just starting a major project for a government client and the
  first job is to design the database. Is there any recongnised
  convention on the naming of database fields. In the past I have always
  named them [table_name_field_name] for example: projects_id where the
  table is called 'projects' and the field is called 'id'.
 
 None that I know of, but what I do is use plural in general for the
 table names, e.g. categories, posts. After all, we are talking about
 sets here, and it's natural to pluralise them.
 
 Fields I give the singular form to, so the projects would have a field
 called project_id. The reasoning being that whereas the set contains
 many projects, hence the pluralisation, each tuple refers to just one,
 so it's singular.
 
 K.
 
 --
 Keith Gaughan, Developer
 Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
 http://www.digital-crew.com/
 
 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181825
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[d.a.collie]

As said there is no definitive but here's my two pennies worth.

 After all, we are talking about sets here, and it's natural to
pluralise them.

My old database teacher would have a fit with that... but each to their
own :)  

We use two words to describe (and name) each table

An example here would be

TABLE: PROJECT_DETAIL
COLUMN: PD_ID, PD_NAME... etc

The column name is collapsed two a two letter prefix, not actually came
across a time when their was a duplicate prefix within a schema but I'm
sure if it happened you could use a different

Anyways... 

-- 
dc

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181826
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Deanna Schneider]

There's whole religions dealing with table-naming conventions. For instance, 
I'm in the table names are singular sect. My other conventions are:
prepend table names with project name/abbreviation. (We do this because 
we'll have multiple projects in the same DB, which in itself is not a best 
practice.)
Do not prepend column names with table name (except the ID column)
Use standard column names for look-up tables (i.e., all the descriptive 
title columns are called title or name - not type, color etc. This 
lets you do some things dynamically with your administrative tools, if you 
want. On the other hand, it means aliasing table names if you're joining. I 
don't mind aliasing, so that's how I do it.

-d

- Original Message - 
From: Andrew Dixon [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 6:30 AM
Subject: OT: Field Naming


 Hi Everyone.

 I'm just starting a major project for a government client and the
 first job is to design the database. Is there any recongnised
 convention on the naming of database fields. In the past I have always
 named them [table_name_field_name] for example: projects_id where the
 table is called 'projects' and the field is called 'id'.

 Thanks in advanced.

 Best Regards

 Andrew.

 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181827
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: custom tag help

[Phillip Perry]

No i'm using cfmx. I just got on so I haven't tested anything yet.

Phil

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 3:10 AM
To: CF-Talk
Subject: RE: custom tag help


Phillip,

If you are using CF5, this wont work because variables wasn't a
structure back then. I'm just telling you this, not to correct James,
but because you are using CT and not CFC (so I think you might be on pre
CFMX).

Before CFMX you would have to (reluctantly) use Evaluate():

#Evaluate(attributes.queryname  .  attributes.fieldname)#

Pascal

 -Original Message-
 From: James Holmes [mailto:[EMAIL PROTECTED]
 Sent: 19 October 2004 06:40
 To: CF-Talk
 Subject: RE: custom tag help

 The variables scope should work within the custom tag:

 cfoutput query=#ATTRIBUTES.QUERYNAME#
 #VARIABLES[ATTRIBUTES.QUERYNAME][attributes.fieldname][currentrow]#
 /cfoutput

 Note that I dropped the query name from currentrow as it's now a
dynamic
 name and you can rely on CF to figure out what currentrow means inside
a
 cfoutput tag.

 -Original Message-
 From: Phillip Perry [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, 19 October 2004 11:26
 To: CF-Talk
 Subject: RE: custom tag help

 Thanks James. That does work if you assume that display is the query
name,
 but what if the query name is stored in an attributes.queryname value?
 I've
 played around with what you gave me but I can't seem to get it to
work.
 any
 thoughts?



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181828
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

UUID as cftoken / createUUID bug

[Andy Allan]

Anyone know how the CFAdmin creates UUIDs for cftoken (on the Server
Settings/Settings page)?

Basically wanting to know if it uses createUUID() and is therefore affected by
the clock speed bug affecting createUUID() on Windows
http://www.macromedia.com/support/coldfusion/ts/documents/createuuid_clock_speed.htm

Cheers,
Andy

-- 
[EMAIL PROTECTED]
www.creative-restraint.co.uk

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181829
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Ian Sheridan]

Andrew,

I usually go with this method:

Name of application == My Sample Application == msa_

Table for users == msa_usr_users

User table fields ==

 usr_id
 usr_firstname
 usr_lastname

And a Foreign Key would be like so ==

 usr_uro_id (this would be a foreign key to the userroles table)

This way when I do joins i do not have any confusion what table a
column is from. Also I always use plurals in the table name because I
do not have a tables that has only *one* item in it.

Ian

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181830
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Execute Query string w CFQUERYPARAM

[Mark A Kruger]

Hey - in regards to this topic I found an insiteful article in a Builder.com
newsletter. Sometimes an SP doesn't give you the performance gains you think
it could because of the query cache.  I couldn't find a link to it on
builder so I posted it on my blog.

http://blog.mxconsulting.com/

-Mk

-Original Message-
From: Joseph Flanigan [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 5:47 PM
To: CF-Talk
Subject: Re: Execute Query string w CFQUERYPARAM


  Why it is better in your opinion to use stored procedures for
insert/update/deletes?

The quick answer is that stored procedures are pre-complied execution plans.

To run in the  database engine, every SQL statement is compiled into
something the database people call execution plans. These plans are the
code that change and read data. Whenever a query is run that changes the
structure of tables, efficient query plans result in the best performance
of the database. A rule I follow is that if any changes are made that
result in any table index being changed then use stored procedures. Insert
and deletes always change indexes, most of the time updates do too.




~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181831
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Robertson-Ravo, Neil (RX)]

Again, its all personal choice.  I usually steer well clear of underscores
as a rule as it can be hard to distinguish between multiple underscores..

Normally we go for the following approach:

Tables : tblEventSettings

And column names using Hungarian Notation (which has its adversaries too!):

vcName 
cName
iProductID
dDateInserted

etc

the same for Store Procedures:

[app]sp_[Get..Update..Delete][Feature]

N


-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 14:57
To: CF-Talk
Subject: Re: Field Naming

Andrew,

I usually go with this method:

Name of application == My Sample Application == msa_

Table for users == msa_usr_users

User table fields ==

 usr_id
 usr_firstname
 usr_lastname

And a Foreign Key would be like so ==

 usr_uro_id (this would be a foreign key to the userroles table)

This way when I do joins i do not have any confusion what table a
column is from. Also I always use plurals in the table name because I
do not have a tables that has only *one* item in it.

Ian

-- 

--
Ian Sheridan
http://www.savagevines.com


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181832
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Field Naming

[Jochem van Dieten]

Andrew Dixon wrote:
 
 I'm just starting a major project for a government client and the
 first job is to design the database. Is there any recongnised
 convention on the naming of database fields.

Does the client have other databases? Which convention do they use?

Jochem

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181833
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Keith Gaughan]

[EMAIL PROTECTED] wrote:

 As said there is no definitive but here's my two pennies worth.
 
After all, we are talking about sets here, and it's natural to
pluralise them.
 
 My old database teacher would have a fit with that... but each to their
 own :)  

Maybe so, but it makes a lot of sense when you're reading over the SQL.
I've never heard a really convincing argument against pluralising the
names in most cases, with the obvious exceptions of things like
bannedlist, navigation, and the like.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://www.digital-crew.com/

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181834
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Tangorre, Michael]

 From: Robertson-Ravo, Neil (RX) 
 
 Again, its all personal choice.  I usually steer well clear 
 of underscores as a rule as it can be hard to distinguish 
 between multiple underscores..

Out of the following, I find option 1 to be the easiest to read.

APPLICATION_USER
APPLICATION-USER
ApplicationUser
tblApplicationUser

Prefixing table names with tbl is a waste in my opinion. Say you have 10
tables all starting with tbl, you have to start at the 4th character to
identify which table you are looking for. Not a major slow down, but
when you have DBs with hundreds of tables, this can add up.

As many have stated, database naming conventions often lead to list
wars, to each his own is probably the best convention. :-)

Mike

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181835
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Field Naming

[Andrew Dixon]

Hi Jochem.

No. They have no other database at the the moment. At the moment all
the data is keep in a strange series of Excel sheets which has become
unmanageable (I'm attempting to decipher at the moment). The reason I
asked the question was because in a recent meeting with them one of
them asked if there was a standard naming convention we could use, you
know what government people are like, love their standards and
conventions!!!

Andrew.


On Tue, 19 Oct 2004 16:08:54 +0200, Jochem van Dieten
[EMAIL PROTECTED] wrote:
 Andrew Dixon wrote:
 
  I'm just starting a major project for a government client and the
  first job is to design the database. Is there any recongnised
  convention on the naming of database fields.
 
 Does the client have other databases? Which convention do they use?
 
 Jochem
 
 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Dreamweaver Autocomplete

[Ewok]

In CF Studio I had my own custom vtm's and a ton of autocompleted tags set
up and loved it. Can you not do the same in Dreamweaver MX? I see the vtm's
so I can probably add insight for my custom tags pretty easily but I'd love
to have my old autocompletes back for the constant reuse of tags that are
always the same...

For instance... 

I could type cfquery[space] and it would autocomplete this...

cfquery name= datasource=#request.maindsn#

/cfquery

And it would put my cursor between the 2 quotes in the name attribute
It was extremely nice!

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004
 


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181837
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Execute Query string w CFQUERYPARAM

[Aaron Rouse]

Does the same type of logic apply in Oracle or does it handle SPs
differently than SQL Server?


On Tue, 19 Oct 2004 09:02:30 -0500, Mark A Kruger
[EMAIL PROTECTED] wrote:
 Hey - in regards to this topic I found an insiteful article in a Builder.com
 newsletter. Sometimes an SP doesn't give you the performance gains you think
 it could because of the query cache.  I couldn't find a link to it on
 builder so I posted it on my blog.
 
 http://blog.mxconsulting.com/
 
 -Mk


~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181839
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Robertson-Ravo, Neil (RX)]

but when you have DBs with hundreds of tables, this can add up.

Erm...that statement isn't true.  The DB will probably work faster with
grouped tablenames over ad-hoc names.  

You are correctdo what you feel confortable with failing that follow
best-practice and examples in-house.

N




-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 15:18
To: CF-Talk
Subject: RE: Field Naming

 From: Robertson-Ravo, Neil (RX) 
 
 Again, its all personal choice.  I usually steer well clear 
 of underscores as a rule as it can be hard to distinguish 
 between multiple underscores..

Out of the following, I find option 1 to be the easiest to read.

APPLICATION_USER
APPLICATION-USER
ApplicationUser
tblApplicationUser

Prefixing table names with tbl is a waste in my opinion. Say you have 10
tables all starting with tbl, you have to start at the 4th character to
identify which table you are looking for. Not a major slow down, but
when you have DBs with hundreds of tables, this can add up.

As many have stated, database naming conventions often lead to list
wars, to each his own is probably the best convention. :-)

Mike



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181838
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Field Naming

[Jochem van Dieten]

Andrew Dixon wrote:
 
 No. They have no other database at the the moment. At the moment all
 the data is keep in a strange series of Excel sheets which has become
 unmanageable (I'm attempting to decipher at the moment). The reason I
 asked the question was because in a recent meeting with them one of
 them asked if there was a standard naming convention we could use, you
 know what government people are like, love their standards and
 conventions!!!

What is supposed to be stored in the database? There might be 
some standard that deals specifically with the type of 
information you have to work with. For instance, OASIS has 
compiled a nice list of different address information standards: 
http://www.oasis-open.org/committees/download.php/176/na_initiatives.pdf
There are other lists for other types of information.

Jochem

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181840
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Execute Query string w CFQUERYPARAM

[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 this topic I found an insiteful article in a Builder.com
newsletter. Sometimes an SP doesn't give you the performance gains you think
it could because of the query cache.  I couldn't find a link to it on
builder so I posted it on my blog.

http://blog.mxconsulting.com/

-Mk

-Original Message-
From: Joseph Flanigan [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 5:47 PM
To: CF-Talk
Subject: Re: Execute Query string w CFQUERYPARAM


  Why it is better in your opinion to use stored procedures for
insert/update/deletes?

The quick answer is that stored procedures are pre-complied execution plans.

To run in the  database engine, every SQL statement is compiled into
something the database people call execution plans. These plans are the
code that change and read data. Whenever a query is run that changes the
structure of tables, efficient query plans result in the best performance
of the database. A rule I follow is that if any changes are made that
result in any table index being changed then use stored procedures. Insert
and deletes always change indexes, most of the time updates do too.






~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181841
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Robertson-Ravo, Neil (RX)]

Isn't the snippets the equivalent in DW? 

-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 15:17
To: CF-Talk
Subject: Dreamweaver Autocomplete

In CF Studio I had my own custom vtm's and a ton of autocompleted tags set
up and loved it. Can you not do the same in Dreamweaver MX? I see the vtm's
so I can probably add insight for my custom tags pretty easily but I'd love
to have my old autocompletes back for the constant reuse of tags that are
always the same...

For instance... 

I could type cfquery[space] and it would autocomplete this...

cfquery name= datasource=#request.maindsn#

/cfquery

And it would put my cursor between the 2 quotes in the name attribute
It was extremely nice!

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004
 




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181842
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dreamweaver Autocomplete

[Massimo Foti]

 In CF Studio I had my own custom vtm's and a ton of autocompleted tags set
 up and loved it. Can you not do the same in Dreamweaver MX? I see the
vtm's
 so I can probably add insight for my custom tags pretty easily but I'd
love
 to have my old autocompletes back for the constant reuse of tags that are
 always the same...

DW use VTML files for its Tag Library. Unlike in CF Studio, VTML isn't
used for the GUI part.

If you want to customize the tags: Edit  Tag Libraries

Check DW's docs for additional info


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/




~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181843
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Tangorre, Michael]

 From: Robertson-Ravo, Neil (RX) 
 but when you have DBs with hundreds of tables, this can add up.
 Erm...that statement isn't true. 

How so? You mean to tell me that this:

tblA
tblB
tblC
tblD
tblE

Is faster than:

A
B
C
D
E

?

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181844
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Ewok]

Dunno... are they


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 10:25 AM
To: CF-Talk
Subject: RE: Dreamweaver Autocomplete

Isn't the snippets the equivalent in DW? 

-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 15:17
To: CF-Talk
Subject: Dreamweaver Autocomplete

In CF Studio I had my own custom vtm's and a ton of autocompleted tags set
up and loved it. Can you not do the same in Dreamweaver MX? I see the vtm's
so I can probably add insight for my custom tags pretty easily but I'd love
to have my old autocompletes back for the constant reuse of tags that are
always the same...

For instance... 

I could type cfquery[space] and it would autocomplete this...

cfquery name= datasource=#request.maindsn#

/cfquery

And it would put my cursor between the 2 quotes in the name attribute
It was extremely nice!

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004
 






~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181845
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Jochem van Dieten]

Tangorre, Michael wrote:
From: Robertson-Ravo, Neil (RX) 
 
 Again, its all personal choice.  I usually steer well clear 
 of underscores as a rule as it can be hard to distinguish 
 between multiple underscores..
 
 Out of the following, I find option 1 to be the easiest to read.
 
 APPLICATION_USER
 APPLICATION-USER
 ApplicationUser
 tblApplicationUser

What is wrong with application_user? I prefer to keep everything 
in lowercase so I can easily distinguish SQL keywords from 
identifiers.


 Prefixing table names with tbl is a waste in my opinion. Say you have 10
 tables all starting with tbl, you have to start at the 4th character to
 identify which table you are looking for. Not a major slow down, but
 when you have DBs with hundreds of tables, this can add up.

I don't think the slow down is really that significant. But what 
I dislike is that objects in a database are no longer grouped 
together logically if you prefix them and list them 
alfabetically. If I have a table with several indexes I want them 
to appear together when I list all the objects.

Jochem

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181846
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Jochem van Dieten]

Ian Sheridan wrote:
 
 Name of application == My Sample Application == msa_
 
 Table for users == msa_usr_users

Application prefix? Isn't that what schema's are for?
CREATE SCHEMA msa ...
CREATE TABLE msa.users ...

Jochem

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181847
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Russell Patterson]

This is my style as well.  I personally find using the _ underscore 
cumbersome and have just never got around to using it.  I do mix Caps  
Small letters to differentiate the elements of a field name.

Russell

- Original Message - 
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 9:01 AM
Subject: RE: Field Naming


 Again, its all personal choice.  I usually steer well clear of underscores
 as a rule as it can be hard to distinguish between multiple underscores..

 Normally we go for the following approach:

 Tables : tblEventSettings

 And column names using Hungarian Notation (which has its adversaries 
 too!):

 vcName
 cName
 iProductID
 dDateInserted

 etc

 the same for Store Procedures:

 [app]sp_[Get..Update..Delete][Feature]

 N





~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181848
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Robertson-Ravo, Neil (RX)]

Well it will probably be negligible, but are  you planning to name your
tables A,B,C,D,E etc...?

You will be in the same boat of any naming convention unless you only want
tables names A,B,C or, AA, BB, CC or even AAA, BBB,CCC etc... ;-)

N



-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 15:34
To: CF-Talk
Subject: RE: Field Naming

 From: Robertson-Ravo, Neil (RX) 
 but when you have DBs with hundreds of tables, this can add up.
 Erm...that statement isn't true. 

How so? You mean to tell me that this:

tblA
tblB
tblC
tblD
tblE

Is faster than:

A
B
C
D
E

?



~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181849
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Execute Query string w CFQUERYPARAM

[Mark A Kruger]

Uh... did I miss something?

-Mark

-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 9:23 AM
To: CF-Talk
Subject: RE: Execute Query string w CFQUERYPARAM


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 this topic I found an insiteful article in a Builder.com
newsletter. Sometimes an SP doesn't give you the performance gains you think
it could because of the query cache.  I couldn't find a link to it on
builder so I posted it on my blog.

http://blog.mxconsulting.com/

-Mk

-Original Message-
From: Joseph Flanigan [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 5:47 PM
To: CF-Talk
Subject: Re: Execute Query string w CFQUERYPARAM


  Why it is better in your opinion to use stored procedures for
insert/update/deletes?

The quick answer is that stored procedures are pre-complied execution plans.

To run in the  database engine, every SQL statement is compiled into
something the database people call execution plans. These plans are the
code that change and read data. Whenever a query is run that changes the
structure of tables, efficient query plans result in the best performance
of the database. A rule I follow is that if any changes are made that
result in any table index being changed then use stored procedures. Insert
and deletes always change indexes, most of the time updates do too.








~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181850
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Ewok]

If I recall, studio used vtm files as well. I remember writing quite a few
tag insights for my custom tags. I'm not after insights, Im after
autocompletion of text. Im not sure what snippets are in DW either since I
stuck with studio for as long as I could

-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 10:25 AM
To: CF-Talk
Subject: Re: Dreamweaver Autocomplete

 In CF Studio I had my own custom vtm's and a ton of autocompleted tags set
 up and loved it. Can you not do the same in Dreamweaver MX? I see the
vtm's
 so I can probably add insight for my custom tags pretty easily but I'd
love
 to have my old autocompletes back for the constant reuse of tags that are
 always the same...

DW use VTML files for its Tag Library. Unlike in CF Studio, VTML isn't
used for the GUI part.

If you want to customize the tags: Edit  Tag Libraries

Check DW's docs for additional info


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181851
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Jochem van Dieten]

Robertson-Ravo, Neil (RX) wrote:
 but when you have DBs with hundreds of tables, this can add up.
 
 Erm...that statement isn't true.  The DB will probably work faster with
 grouped tablenames over ad-hoc names.  

With the one database that I know enough about the internals to 
say something sensible about it, PostgreSQL, I can only think of 
reasons why it would be slower. Raw size, index access patterns 
of the catalogs etc. would all make this slower.

Jochem

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181852
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Tangorre, Michael]

 From: Robertson-Ravo, Neil (RX) 

 Well it will probably be negligible, but are  you planning to 
 name your tables A,B,C,D,E etc...?
 You will be in the same boat of any naming convention unless 
 you only want tables names A,B,C or, AA, BB, CC or even AAA, 
 BBB,CCC etc... ;-)

A better example would be:

tblApplicationUser
tblCoupon
tblElephant
tblKite
tblRole
tblSpecial
tblWhiteList

Versus:

ApplicationUser
Coupon
Elephant
Kite
Role
Special
WhiteList


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181854
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Tangorre, Michael]

 What is wrong with application_user? I prefer to keep 
 everything in lowercase so I can easily distinguish SQL 
 keywords from identifiers.

Good point. If I weren't so tied to the color coding of the database
IDEs I use, then this would be my choice as well; but since the color
coding identifies the key words, etc... I am reluctant to switch... For
now anyway.

Mike

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181853
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Robertson-Ravo, Neil (RX)]

Yeah...I suppose it is down to each RDBMS but I know for SQL Server the
performance difference would not even significant or even on the scale. 

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 15:36
To: CF-Talk
Subject: Re: Field Naming

Robertson-Ravo, Neil (RX) wrote:
 but when you have DBs with hundreds of tables, this can add up.
 
 Erm...that statement isn't true.  The DB will probably work faster with
 grouped tablenames over ad-hoc names.  

With the one database that I know enough about the internals to 
say something sensible about it, PostgreSQL, I can only think of 
reasons why it would be slower. Raw size, index access patterns 
of the catalogs etc. would all make this slower.

Jochem



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181855
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Robertson-Ravo, Neil (RX)]

It would be negligible, if any.  It would all depend on, like Jochem stated
on your RDBMS but in SQL Server you will find no difference from the
internal QOE and the sysobject table.



-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: 19 October 2004 15:44
To: CF-Talk
Subject: RE: Field Naming

 From: Robertson-Ravo, Neil (RX) 

 Well it will probably be negligible, but are  you planning to 
 name your tables A,B,C,D,E etc...?
 You will be in the same boat of any naming convention unless 
 you only want tables names A,B,C or, AA, BB, CC or even AAA, 
 BBB,CCC etc... ;-)

A better example would be:

tblApplicationUser
tblCoupon
tblElephant
tblKite
tblRole
tblSpecial
tblWhiteList

Versus:

ApplicationUser
Coupon
Elephant
Kite
Role
Special
WhiteList




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181856
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Ian Sheridan]

Jochem,

Your right, but when you have multiple apps using the same DB or when
the user account does not have permissions to do CREATE SCHEMA, this
comes in handy for me. Also, I do the 'My Sample Application' ==
msa_ thing anyway in my file naming so this helps in keeping things
straight in my head.

The more important part of my naming convention is the table name
after the app abbr. This way I know what column goes to what table
without any guesswork (helps with knowledge transfer too). Also the
app abbr comes in handy when I have multiple user tables (or other
similar tables).

Ian


On Tue, 19 Oct 2004 16:06:59 +0200, Jochem van Dieten
[EMAIL PROTECTED] wrote:
 Ian Sheridan wrote:
 
  Name of application == My Sample Application == msa_
 
  Table for users == msa_usr_users
 
 Application prefix? Isn't that what schema's are for?
 CREATE SCHEMA msa ...
 CREATE TABLE msa.users ...
 
 Jochem


-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181857
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Stephen Moretti (cfmaster)]

Robertson-Ravo, Neil (RX) wrote:

but when you have DBs with hundreds of tables, this can add up.

Erm...that statement isn't true.  The DB will probably work faster with grouped 
tablenames over ad-hoc names.  
  

Really?  I don't see why it would... 

But I think Mike's point was from the visual aspect not server-side 
processing.  I've got a couple of databases where I've tried this 
approach, using tbl for tables and lnk (link) for relationship and, to 
be honest, I wish I'd never bothered.  I can find my link tables easy 
enough, but I always seem to manage to go straight past the table I 
actually wanted.  Having said this, it was fine when I had 
capitalisation in the table names, but an export from one db to another 
kindly lower-cased all the table names and its a pain in the backside now.

Andrew, 
I would go with that Oracle guideline page you found and adjust it to 
your requirements, then document it all up for the client.  I don't 
believe there is a standard standard (as you might have noticed from all 
the points of view) for table and field name.

Hope this helps

Stephen


~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181858
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dreamweaver Autocomplete

[Massimo Foti]

 If I recall, studio used vtm files as well. I remember writing quite a few
 tag insights for my custom tags.

The nice thing about DW is that you can add/edit VTML for tag insights using
a GUI


 I'm not after insights, Im after
 autocompletion of text.

Then you have to go to:
Help  Extensions  Extending DW  then search for Code Hints


 Im not sure what snippets are in DW either since I
 stuck with studio for as long as I could

CF Studio has Snippets as well (very similar functionality). But they are a
totally different beast


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/






~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181859
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Field Naming

[Calvin Ward]

Isn't a set singular?

So a set refers to one set such as a table containing People, but more than one set 
(sets - plural) would be like People and Organization (two sets).

So a table name should be singular using the set reference :P

-Original Message-
From:  [EMAIL PROTECTED]
Date:  10/19/04 9:28 am
To:  CF-Talk 
Subj:  RE: Field Naming

As said there is no definitive but here's my two pennies worth.

 After all, we are talking about sets here, and it's natural to
pluralise them.

My old database teacher would have a fit with that... but each to their
own :)  

We use two words to describe (and name) each table

An example here would be

TABLE: PROJECT_DETAIL
COLUMN: PD_ID, PD_NAME... etc

The column name is collapsed two a two letter prefix, not actually came
across a time when their was a duplicate prefix within a schema but I'm
sure if it happened you could use a different

Anyways... 

-- 
dc



~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181860
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Ewok]

Thanks, I guess snippets are the closest I'm going to get in DW

-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 10:47 AM
To: CF-Talk
Subject: Re: Dreamweaver Autocomplete

 If I recall, studio used vtm files as well. I remember writing quite a few
 tag insights for my custom tags.

The nice thing about DW is that you can add/edit VTML for tag insights using
a GUI


 I'm not after insights, Im after
 autocompletion of text.

Then you have to go to:
Help  Extensions  Extending DW  then search for Code Hints


 Im not sure what snippets are in DW either since I
 stuck with studio for as long as I could

CF Studio has Snippets as well (very similar functionality). But they are a
totally different beast


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181861
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dreamweaver Autocomplete

[Massimo Foti]

 Thanks, I guess snippets are the closest I'm going to get in DW

I suspect you are misreading my posts... What you are looking for is called
Code Hints in DW and it's fully customizable (see previous post for
directions)


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181862
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

REPOST: Access to cfschedule and cfindex/cfcollection listings

[Burns, John D]

Below is a post that I submitted last week and I didn't get any
responses.  Can anyone shed some insight on this?



Does anyone know of a way via the CF service factory or some other way
to be able to list the scheduled tasks that CF has and the collections
and indexes that have been created?  We're trying to lock down developer
access to the CF Administrator and we've already created a tool using
the service factory for adding and removing debugging IP addresses.  The
only other things we really need to set up for developers to access
outside of the administrator is the listings of those portions of the
administrator.  Any help would be greatly appreciated. Thanks!
 
John Burns




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181863
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dreamweaver Autocomplete

[Russell Patterson]

If you go to settings in DW, you can turn on Autocomplete.

Russell

- Original Message - 
From: Ewok [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 10:06 AM
Subject: RE: Dreamweaver Autocomplete


 Thanks, I guess snippets are the closest I'm going to get in DW

 -Original Message-
 From: Massimo Foti [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 19, 2004 10:47 AM
 To: CF-Talk
 Subject: Re: Dreamweaver Autocomplete

 If I recall, studio used vtm files as well. I remember writing quite a 
 few
 tag insights for my custom tags.

 The nice thing about DW is that you can add/edit VTML for tag insights 
 using
 a GUI


 I'm not after insights, Im after
 autocompletion of text.

 Then you have to go to:
 Help  Extensions  Extending DW  then search for Code Hints


 Im not sure what snippets are in DW either since I
 stuck with studio for as long as I could

 CF Studio has Snippets as well (very similar functionality). But they are 
 a
 totally different beast

 
 Massimo Foti
 DW tools: http://www.massimocorner.com
 CF tools:  http://www.olimpo.ch/tmt/


 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181864
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Chris Peters]

If everyone wants to get all technical with relational database theory, a table name 
should be singular because it is an ENTITY.

Most entities (tables) have relationships (foreign key linking) with other entities.

These relationships can be thought of as verbs, and entities can be thought of as 
nouns.

For example, if you linked an ARTIST table to a ARTWORK table, you could say, ARTIST 
creates PAINTING.

This is especially helpful if you create entity-relationship diagrams, which I highly 
recommend for larger projects.  I wish I had a good resource to point you to other 
than my Database Systems textbook from college.


Chris

 Isn't a set singular?
 
 So a set refers to one set such as a table containing People, but more 
 than one set (sets - plural) would be like People and Organization 
 (two sets).
 
 So a table name should be singular using the set reference :P
 
 -Original Message-
 From:  [EMAIL PROTECTED]
 Date:  10/19/04 9:28 am
 To:  CF-Talk 
 Subj:  RE: Field Naming
 
 As said there is no definitive but here's my two pennies worth.
 
  After all, we are talking about sets here, and it's natural to
 pluralise them.
 
 My old database teacher would have a fit with that... but each to 
 their
 own :)  
 
 We use two words to describe (and name) each table
 
 An example here would be
 
 TABLE: PROJECT_DETAIL
 COLUMN: PD_ID, PD_NAME... etc
 
 The column name is collapsed two a two letter prefix, not actually 
 came
 across a time when their was a duplicate prefix within a schema but 
 I'm
 sure if it happened you could use a different
 
 Anyways... 
 
 -- 
 dc
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181865
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

ColdFusion with ScreenSurfer

[Ian Skinner]

Anybody out there use, or are familiar with, the ScreenSurfer product by Inventu nee 
TeamStudio?

I am trying to use the product to connect to a HP VT100 application but I am just not 
getting some fundamental concept(s).  I can not event get passed the login to the 
application.

I have submitted a request for help to Inventu, but I am also casting out to this 
group hoping that somebody out there is familiar with this product and can provide 
some real world experience.

Thank You

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

C code. C code run. Run code run. Please!
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181866
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

SOT: Drop-Ship Limitations to California

[Dick Applebaum]

This is SOT but it may affect anyone writing programs to do ecommerce 
with customers in California.

I was recently told by a pcConnection representative that they could 
only drop-ship items to California from pcConnection warehouses in Ohio 
and Tennessee -- because of California tax laws.

Anyone ever heard of this?

In my case it has caused a 2 1/2 month delay in receiving an item I 
ordered on Aug 2 that was in stock (but apparently not in the correct 
warehouse).

TIA

Dick


Misery no longer loves company. Nowadays it insists on it.
- Russell Baker -

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181867
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: REPOST: Access to cfschedule and cfindex/cfcollection l istings

[James Holmes]

Do it however it's done in the CF Admin.

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 19 October 2004 11:10 
To: CF-Talk
Subject: REPOST: Access to cfschedule and cfindex/cfcollection
listings

Below is a post that I submitted last week and I didn't get any responses.
Can anyone shed some insight on this?



Does anyone know of a way via the CF service factory or some other way to be
able to list the scheduled tasks that CF has and the collections and indexes
that have been created?  We're trying to lock down developer access to the
CF Administrator and we've already created a tool using the service factory
for adding and removing debugging IP addresses.  The only other things we
really need to set up for developers to access outside of the administrator
is the listings of those portions of the administrator.  Any help would be
greatly appreciated. Thanks!

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181868
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Keith Gaughan]

Robertson-Ravo, Neil (RX) wrote:

 Well it will probably be negligible, but are  you planning to name your
 tables A,B,C,D,E etc...?
 
 You will be in the same boat of any naming convention unless you only want
 tables names A,B,C or, AA, BB, CC or even AAA, BBB,CCC etc... ;-)

I think his point is that tbl- doesn't add any extra benefit in
recognisablity, and only means more typing. I'd have to say I'd agree.

rant type=gentle subject=Poor use of Hungarian Notation
Ditto on the VB-style Hungarian Notation that a lot of people use,
which kind of misses the point of what Simonyi was trying to make, which
is to mark the semantic type rather than the physical type. This is less
necessary in a language with strong typing or safe types such as Lisp,
Python, ML, and Java than a weakly-typed language like C. Weak, unsafe
types in C are the reason why Hungarian Notation was invented.

But Visual Basic came along, and the developers missed the point, with
prefixes like int-, lng-, str-, var-, c. marking physical types rather
than the semantics.

Now, what makes sense are prefixes like nentitys, e.g. nDays for the
number of days, ientity for an index of entity, e.g. iBook for the
index of a book in a list of books.

With GUIs, marking physical types makes sense when you want to imply
that two widgets are related, e.g. lblName and txtName for a
label/textfield pair. But this is one of the few where such a usage
really makes sense.
/rant

K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://www.digital-crew.com/

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181869
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: ColdFusion with ScreenSurfer

[simon]

I used it quite a bit in an RD and prototyping capacity at Fig Leaf about 4 
years ago... I even gave a presentation about it at DevCon in 2001... I don't 
have the slides or code anymore, but you could try asking Fig Leaf if they 
still have the materials laying around somewhere and are willing to share.  For 
that matter, if anyone has their DevCon 2001 Conference CD and/or booklet 
handy, it's probably in there ;)

~Simon

 
 Anybody out there use, or are familiar with, the ScreenSurfer product by 
Inventu nee TeamStudio?
 
 I am trying to use the product to connect to a HP VT100 application but I am 
just not getting some fundamental concept(s).  I can not event get passed the 
login to the application.
 
 I have submitted a request for help to Inventu, but I am also casting out to 
this group hoping that somebody out there is familiar with this product and can 
provide some real world experience.
 
 Thank You
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message. 
 
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181870
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: REPOST: Access to cfschedule and cfindex/cfcollection listings

[Doug James]

John,

I think the files [cf_root_dir]\lib\neo-cron.xml (scheduled tasks) and 
[cf_root_dir]\lib\neo-verity.xml (indexes and collections) are your 
starting points.

Doug James
IT Developer
MUSC - Hollings Cancer Center
843.792.6357
http://hcc.musc.edu

Burns, John D wrote:

Below is a post that I submitted last week and I didn't get any
responses.  Can anyone shed some insight on this?



Does anyone know of a way via the CF service factory or some other way
to be able to list the scheduled tasks that CF has and the collections
and indexes that have been created?  We're trying to lock down developer
access to the CF Administrator and we've already created a tool using
the service factory for adding and removing debugging IP addresses.  The
only other things we really need to set up for developers to access
outside of the administrator is the listings of those portions of the
administrator.  Any help would be greatly appreciated. Thanks!
 
John Burns






~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181871
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: REPOST: Access to cfschedule and cfindex/cfcollection l istings

[Burns, John D]

Ok, and how do I figured that out?

John Burns 

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 11:30 AM
To: CF-Talk
Subject: RE: REPOST: Access to cfschedule and cfindex/cfcollection
l istings

Do it however it's done in the CF Admin.

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 19 October 2004 11:10
To: CF-Talk
Subject: REPOST: Access to cfschedule and cfindex/cfcollection
listings

Below is a post that I submitted last week and I didn't get any
responses.
Can anyone shed some insight on this?



Does anyone know of a way via the CF service factory or some other way
to be able to list the scheduled tasks that CF has and the collections
and indexes that have been created?  We're trying to lock down developer
access to the CF Administrator and we've already created a tool using
the service factory for adding and removing debugging IP addresses.  The
only other things we really need to set up for developers to access
outside of the administrator is the listings of those portions of the
administrator.  Any help would be greatly appreciated. Thanks!



~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181872
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Keith Gaughan]

Chris Peters wrote:

 If everyone wants to get all technical with relational database theory,
 a table name should be singular because it is an ENTITY.

The way I was taught it, a table represents a *set* of entities.

K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://www.digital-crew.com/

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Dick Applebaum]

On Oct 19, 2004, at 8:47 AM, Keith Gaughan wrote:


 If everyone wants to get all technical with relational database 
 theory,
 a table name should be singular because it is an ENTITY.

 The way I was taught it, a table represents a *set* of entities.



Actually, a table is an entity that contains a set of entities.

Dick

Those who flee temptation generally leave a forwarding address.
- Lane Olinghouse -

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181874
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: [sot] moving to JSP

[Damien McKenna]

Douglas Knudsen wrote:

With that cost, hard to convince them to put CF on the box as well.
  

Try BlueDragon.. http://www.newatlanta.com/

mark, ok strutts.  strutts is a framework, like machii is, correct?

Correct.

i have been messing with machii lately.  a RAD framework?  h.now
i suppose one mans RAD is another mans SAD, slow app developent.
  

Each framework has a learning curve, but once you get past that it tends 
to be smooth sailing.
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
Nothing endures but change. - Heraclitus

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181875
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Peterson, Andrew S.]

Ewok,

You're looking for the same thing I am - the Trigger String
functionality, which does not seem to be the same as the Code Hints or
other DW featues.  I cannot find the equivalent in DW. 

Coincidentally, I posted almost the same question as you did this
morning - see post below. 
 
Sincerely,
 
Andrew



-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 7:35 AM
To: CF-Talk
Subject: Another Is this Homesite feature in DW? question

Hi,
 
Homesite has a nice AutoCompletion feature whereby you enter a trigger
string and it spits out the remainder of the code for you. For instance,
you enter '#att and it will automatically add ributes.# and even place
the cursor before the pound sign and after the period. I cannot find
this feature in DWMX2K. Is it in there somewhere or is there a similar
feature?
 
TIA.
 
Sincerely,
 
Andrew




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181876
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

cflock

[Phillip Perry]

Hi,

First, thanks to James and everyone else for the solutions to the custom
tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
rotation and I am using cflock. But when I execute my code it gives this
error...

Cannot lock APPLICATION scope.
CFLock cannot be used to lock the application or session shared scopes
without these scopes being established through the use of the CFApplication
tag. If you want to use the session scope you need to enable session
management. Application and/or Session variables must also be enabled in the
ColdFusion Administrator.

I'm assuming I have to fiddle with the admin settings, but what exactly am I
looking for..or is it even an admin problem in the first place?

Thanks

Phil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181877
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Another Is this Homesite feature in DW? question

[Nathan Strutz]

I don't believe DWMX has the auto-complete feature built in, but 
CFEclipse does :)

http://cfeclipse.tigris.org/

-nathan strutz


Peterson, Andrew S. wrote:

 Hi,
  
 Homesite has a nice AutoCompletion feature whereby you enter a trigger
 string and it spits out the remainder of the code for you. For instance,
 you enter '#att and it will automatically add ributes.# and even place
 the cursor before the pound sign and after the period. I cannot find
 this feature in DWMX2K. Is it in there somewhere or is there a similar
 feature?
  
 TIA.
  
 Sincerely,
  
 Andrew
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181878
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflock

[Barney Boisvert]

You just need to add a CFAPPLICATION tag to you app, and you'll be set.  

cheers,
barneyb

On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry
[EMAIL PROTECTED] wrote:
 Hi,
 
 First, thanks to James and everyone else for the solutions to the custom
 tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
 rotation and I am using cflock. But when I execute my code it gives this
 error...
 
 Cannot lock APPLICATION scope.
 CFLock cannot be used to lock the application or session shared scopes
 without these scopes being established through the use of the CFApplication
 tag. If you want to use the session scope you need to enable session
 management. Application and/or Session variables must also be enabled in the
 ColdFusion Administrator.
 
 I'm assuming I have to fiddle with the admin settings, but what exactly am I
 looking for..or is it even an admin problem in the first place?
 
 Thanks
 
 Phil
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181879
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflock

[Ubqtous]

You need to make sure you have an Application.cfm module in your
application's directory. That Application.cfm module needs to have a
CFAPPLICATION tag within it, which will allow you to use
application-scoped variables and to CFLOCK that scope.

On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry
[EMAIL PROTECTED] wrote:
 Hi,
 
 First, thanks to James and everyone else for the solutions to the custom
 tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
 rotation and I am using cflock. But when I execute my code it gives this
 error...
 
 Cannot lock APPLICATION scope.
 CFLock cannot be used to lock the application or session shared scopes
 without these scopes being established through the use of the CFApplication
 tag. If you want to use the session scope you need to enable session
 management. Application and/or Session variables must also be enabled in the
 ColdFusion Administrator.
 
 I'm assuming I have to fiddle with the admin settings, but what exactly am I
 looking for..or is it even an admin problem in the first place?
 

-- 
Ubqtous

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181880
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Keith Gaughan]

Dick Applebaum wrote:

 On Oct 19, 2004, at 8:47 AM, Keith Gaughan wrote:
 
 
 If everyone wants to get all technical with relational database 
 theory, a table name should be singular because it is an ENTITY.

 The way I was taught it, a table represents a *set* of entities.
 
 Actually, a table is an entity that contains a set of entities.

'tis true, but then ER diagrams and the like are for modelling
relationships between various entitities in the platonic sense as
opposed to the more solid ones you're dealing with when you go to an
RDBMS. A table is just a set of those entities made substantial and
isn't itself modelled in ER diagrams, a way of grouping entities with
same platonic form modelled in the ER diagram.

K.

-- 
Keith Gaughan, Developer
Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland
http://www.digital-crew.com/

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181881
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: Drop-Ship Limitations to California

[Matt Robertson]

Hi Dick,

Sounds like a load of poo-poo.  They must have some sort of tax
problem themselves, or a lack of desire to comply with something. 
Either way their problem is becoming yours.  I'd walk up the ladder
over there and see if I could get a less-bogus answer.

-- 
--Matt Robertson--
President, Janitor
MSB Designs, Inc.
mysecretbase.com

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181882
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Upload Utility

[Greg Morphis]

I'm needing to create an Upload Utility that will allow users to
create directories, change directories, and upload files into those
directories.

Is this best done in the DB, storing the File information, 
I would imagine I'd need to store
File information, and what directory it's under

or is this best done using cfdirectory and reading the contents of the folders?

I've been using cfdirectory and it's becoming a pain. 

Anyone have any ideas or tutorials or anything I can look at?

Thanks

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181883
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Execute Query string w CFQUERYPARAM

[Joseph Flanigan]

Mark thanks for the posting.

The article makes a couple of good points but does it does not dismiss 
performance gains. The article illustrates using select queries in 
unplanned manner.

When a procedure is complied, columns that depend on indexes are 
represented in the compile. These indexes become part of the execution 
plan. When a procedure is used in an unplanned manner, like the article 
describes, slower performance should be expected. Just from reading the 
information that the author presented, it appears the use of the indexes 
was in an unplanned manner.  At the end of the article the author modified 
the procedure to use case statements to regain the performance.

This is a very good article in that it demonstrates the importance of using 
execution plans that match query parameters.


At 08:02 AM 10/19/2004, you wrote:
Hey - in regards to this topic I found an insiteful article in a Builder.com
newsletter. Sometimes an SP doesn't give you the performance gains you think
it could because of the query cache.  I couldn't find a link to it on
builder so I posted it on my blog.

http://blog.mxconsulting.com/

-Mk

http://www.switch-box.org/CFSQLTool/Download/

Switch_box  MediaFirm, Inc.
www.Switch-box.org  Loveland, CO  USA


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181884
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Upload Utility

[Douglas Knudsen]

me, I would replace the idea of  directory with the idea of category. 
Upload all files into a single library on the server, store the path,
title, description, mimetype, categoryid, etc in the DB, then mosh out
CFCONTENT to get teh file to the client.

I can make u an admin on the unifiedportal  in dev to see this in action :)

Doug


On Tue, 19 Oct 2004 12:03:32 -0500, Greg Morphis [EMAIL PROTECTED] wrote:
 I'm needing to create an Upload Utility that will allow users to
 create directories, change directories, and upload files into those
 directories.
 
 Is this best done in the DB, storing the File information,
 I would imagine I'd need to store
 File information, and what directory it's under
 
 or is this best done using cfdirectory and reading the contents of the folders?
 
 I've been using cfdirectory and it's becoming a pain.
 
 Anyone have any ideas or tutorials or anything I can look at?
 
 Thanks
 
 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181885
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Upload Utility

[Massimo, Tiziana e Federica]

 or is this best done using cfdirectory and reading the contents of the
folders?

 I've been using cfdirectory and it's becoming a pain.

 Anyone have any ideas or tutorials or anything I can look at?

This isn't a tutorial, but it may be worth a check:

http://www.olimpo.ch/tmt/cfc/tmt_file_io


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181886
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Consume a web service with JavaScript...possible?

[Scott Stroz]

Massimo,

Thanx for the info, unfortuantely, most of the links on
http://www.mozilla.org/projects/webservices/ that would give more info
are not working.

What I need is something that will walk me through the steps like I am
an idiot.  Both for consuming Web Services with JavaScript and
creating extensions for FireFox.

Anyone else?


On Mon, 18 Oct 2004 22:07:31 +0200, Massimo, Tiziana e Federica
[EMAIL PROTECTED] wrote:
  I have an idea for an extension for FireFox,  One key element is going
   to be the ability to comsume a web service, or parse an XML file.
  
   Can I consume a web service using JavaSCript?
  
  Yes. If you are using Mozilla, this may be a good starting point:
  
  http://www.mozilla.org/projects/webservices/
  
   Any ideas on good references on parsing XML in JavaSCript?  Most of
   the stuff I have found is IE-centric.
  
  There are powerful croos-browser libraries that may be worth a check:
  
  https://sourceforge.net/projects/sarissa/
  http://xmljs.sourceforge.net/index.html
  
  Hope it will help
  
  
  Massimo Foti
  DW tools: http://www.massimocorner.com
  CF tools:  http://www.olimpo.ch/tmt/
  
  

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181887
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Upload Utility

[Dave Francis]

CFFTP ??

- Original Message - 
From: Douglas Knudsen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 1:13 PM
Subject: Re: Upload Utility


 me, I would replace the idea of  directory with the idea of category.
 Upload all files into a single library on the server, store the path,
 title, description, mimetype, categoryid, etc in the DB, then mosh out
 CFCONTENT to get teh file to the client.

 I can make u an admin on the unifiedportal  in dev to see this in action
:)

 Doug


 On Tue, 19 Oct 2004 12:03:32 -0500, Greg Morphis [EMAIL PROTECTED]
wrote:
  I'm needing to create an Upload Utility that will allow users to
  create directories, change directories, and upload files into those
  directories.
 
  Is this best done in the DB, storing the File information,
  I would imagine I'd need to store
  File information, and what directory it's under
 
  or is this best done using cfdirectory and reading the contents of the
folders?
 
  I've been using cfdirectory and it's becoming a pain.
 
  Anyone have any ideas or tutorials or anything I can look at?
 
  Thanks
 
 

 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181888
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Using a form field name as part of the name of a session variable

[Peterson, Andrew S.]

Hi,
 
I'm hoping this is just a question of syntax. Is it possible to set part
of the name of a session variable using the name of a form variable? The
form name is dynamic too. Here's the code that ain't working:
 
cfset session.qNum#form.qNum# = form.answer
^
For example, what I'd like to set in the above line of code is a session
variable named qNum2, or whatever value form.qNum is.
 
If this doesn't work, I can always hard code it using a 1000 line
cfswitch block, but no one (me most of all) wants to see that :-)
 
Thanks in advance.
 
Sincerely,
 
Andrew

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181889
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: [cftalk] Re: Upload Utility

[Daniel Mackey]

Hi,

Check out : http://www.cftagstore.com/tags/cffilemanagerv301.cfm

Might be of interest to you.

Regards,
Dan.

-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 18:17
To: CF-Talk
Subject: [cftalk] Re: Upload Utility


CFFTP ??

- Original Message -
From: Douglas Knudsen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 1:13 PM
Subject: Re: Upload Utility


 me, I would replace the idea of  directory with the idea of category.
 Upload all files into a single library on the server, store the path,
 title, description, mimetype, categoryid, etc in the DB, then mosh out
 CFCONTENT to get teh file to the client.

 I can make u an admin on the unifiedportal  in dev to see this in action
:)

 Doug


 On Tue, 19 Oct 2004 12:03:32 -0500, Greg Morphis [EMAIL PROTECTED]
wrote:
  I'm needing to create an Upload Utility that will allow users to
  create directories, change directories, and upload files into those
  directories.
 
  Is this best done in the DB, storing the File information,
  I would imagine I'd need to store
  File information, and what directory it's under
 
  or is this best done using cfdirectory and reading the contents of the
folders?
 
  I've been using cfdirectory and it's becoming a pain.
 
  Anyone have any ideas or tutorials or anything I can look at?
 
  Thanks
 
 





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181890
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cflock

[Phillip Perry]

Great thanks. I made a new folder in the main directory so I hadn't thought
about making an app.cfm inside it. I guess that shows how important a
app.cfm file really is

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 12:52 PM
To: CF-Talk
Subject: Re: cflock


You just need to add a CFAPPLICATION tag to you app, and you'll be set.

cheers,
barneyb

On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry
[EMAIL PROTECTED] wrote:
 Hi,

 First, thanks to James and everyone else for the solutions to the custom
 tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
 rotation and I am using cflock. But when I execute my code it gives this
 error...

 Cannot lock APPLICATION scope.
 CFLock cannot be used to lock the application or session shared scopes
 without these scopes being established through the use of the
CFApplication
 tag. If you want to use the session scope you need to enable session
 management. Application and/or Session variables must also be enabled in
the
 ColdFusion Administrator.

 I'm assuming I have to fiddle with the admin settings, but what exactly am
I
 looking for..or is it even an admin problem in the first place?

 Thanks

 Phil





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181891
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflock

[Jeff Congdon]

You don't need one in the current directory, you just need to make sure 
the one in the previous directory has that cfapplication tag.  If 
there's no app.cfm in the current diretory, CF will automatically look 
in ../, ../.../, etc until it finds one.  Generally you want 1 app.cfm, 
and it should be in the root directory of the application.  Obviously 
there are cases where you'd want more than 1, but that's for another day.

-jc

Phillip Perry wrote:

Great thanks. I made a new folder in the main directory so I hadn't thought
about making an app.cfm inside it. I guess that shows how important a
app.cfm file really is

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 12:52 PM
To: CF-Talk
Subject: Re: cflock


You just need to add a CFAPPLICATION tag to you app, and you'll be set.

cheers,
barneyb

On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry
[EMAIL PROTECTED] wrote:
  

Hi,

First, thanks to James and everyone else for the solutions to the custom
tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner
rotation and I am using cflock. But when I execute my code it gives this
error...

Cannot lock APPLICATION scope.
CFLock cannot be used to lock the application or session shared scopes
without these scopes being established through the use of the


CFApplication
  

tag. If you want to use the session scope you need to enable session
management. Application and/or Session variables must also be enabled in


the
  

ColdFusion Administrator.

I'm assuming I have to fiddle with the admin settings, but what exactly am


I
  

looking for..or is it even an admin problem in the first place?

Thanks

Phil









~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181892
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using a form field name as part of the name of a session variable

[Ewok]

Try this 

cfset session[qNum#form.qNum#] = form.answer

Or something like that... maybe without quotes? But I think with.


-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 1:23 PM
To: CF-Talk
Subject: Using a form field name as part of the name of a session variable

Hi,
 
I'm hoping this is just a question of syntax. Is it possible to set part
of the name of a session variable using the name of a form variable? The
form name is dynamic too. Here's the code that ain't working:
 
cfset session.qNum#form.qNum# = form.answer
^
For example, what I'd like to set in the above line of code is a session
variable named qNum2, or whatever value form.qNum is.
 
If this doesn't work, I can always hard code it using a 1000 line
cfswitch block, but no one (me most of all) wants to see that :-)
 
Thanks in advance.
 
Sincerely,
 
Andrew



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181893
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Joseph Flanigan]

The are so many options on which styles to follow, the approach I recommend 
is to pick a something, document it and follow your document.

For my clients that I do database design work for, as part of the 
deliverable, I give them a copy of the style guide we used to develop the 
database.

If you want to see the style guide we use, it is included with the 
documentation for CFSQLTool. To get you started, you may wish to take it 
and modify to meet your needs. I make no claims as to if it best or better 
practice, just that it works good for us.

There is no separate download for the style guide, but if you download the 
tool, ( http://www.switch-box.org/CFSQLTool/Download/  ) unzip the file and 
look in the docs folder you will find the file 
docs_Databases_Style_Practices.cfml

Create Table Pajamas,

Joseph





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181894
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Ewok]

Yes, but I want to autocomplete custom text and tags like the example I
posted. Thanks

-Original Message-
From: Russell Patterson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 11:17 AM
To: CF-Talk
Subject: Re: Dreamweaver Autocomplete

If you go to settings in DW, you can turn on Autocomplete.

Russell

- Original Message - 
From: Ewok [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 10:06 AM
Subject: RE: Dreamweaver Autocomplete


 Thanks, I guess snippets are the closest I'm going to get in DW

 -Original Message-
 From: Massimo Foti [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 19, 2004 10:47 AM
 To: CF-Talk
 Subject: Re: Dreamweaver Autocomplete

 If I recall, studio used vtm files as well. I remember writing quite a 
 few
 tag insights for my custom tags.

 The nice thing about DW is that you can add/edit VTML for tag insights 
 using
 a GUI


 I'm not after insights, Im after
 autocompletion of text.

 Then you have to go to:
 Help  Extensions  Extending DW  then search for Code Hints


 Im not sure what snippets are in DW either since I
 stuck with studio for as long as I could

 CF Studio has Snippets as well (very similar functionality). But they are 
 a
 totally different beast

 
 Massimo Foti
 DW tools: http://www.massimocorner.com
 CF tools:  http://www.olimpo.ch/tmt/


 



~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181895
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Drop-Ship Limitations to California

[Cary Gordon]

This hold true for every state that charges sales tax.  If you are in CA and
hsve one local warehouse that you ship from, it is dead simple: You charge
tax in CA and no tax anywhere else.

The mail order computer stuff companies have a more complicated situation.
They have limited warehousing on their own.  Almost everything is dropped
shipped from distributors like Ingram Micro, Tech Data, etc., and those
folks have warehouses everywhere.  The big vendors are connected to the
distributors extranets, but even that does not guarantee that they have
current stock info, so if they sell you a framitz that is in IM's PA
warehouse, and it turns out to only be available in CA, they (and you) have
a problem.

I went through a huge argument with a company in Denver who sold me a
product that was supposedly coming from the manufacturer in Tennessee.  They
found out after the fact that it had shipped for CA and hit my credit card
for the tax. I wound up in a heated conversation with the president of the
company, and, finally, they took it off.

Cary Gordon
The Cherry Hill Company



-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 8:22 AM
To: CF-Talk
Subject: SOT: Drop-Ship Limitations to California

This is SOT but it may affect anyone writing programs to do ecommerce with
customers in California.

I was recently told by a pcConnection representative that they could only
drop-ship items to California from pcConnection warehouses in Ohio and
Tennessee -- because of California tax laws.

Anyone ever heard of this?

In my case it has caused a 2 1/2 month delay in receiving an item I ordered
on Aug 2 that was in stock (but apparently not in the correct warehouse).

TIA

Dick


Misery no longer loves company. Nowadays it insists on it.
- Russell Baker -



~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181896
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Field Naming

[Chris Peters]

Oops. I meant ARTIST creates ARTWORK.

 If everyone wants to get all technical with relational database theory, 
 a table name should be singular because it is an ENTITY.
 
 Most entities (tables) have relationships (foreign key linking) with 
 other entities.
 
 These relationships can be thought of as verbs, and entities can be 
 thought of as nouns.
 
 For example, if you linked an ARTIST table to a ARTWORK table, you 
 could say, ARTIST creates PAINTING.
 
 This is especially helpful if you create entity-relationship diagrams, 
 which I highly recommend for larger projects.  I wish I had a good 
 resource to point you to other than my Database Systems textbook from 
 college.
 
 
 Chris
 
  Isn't a set singular?
  
  So a set refers to one set such as a table containing People, but 
 more 
  than one set (sets - plural) would be like People and Organization 
  (two sets).
  
  So a table name should be singular using the set reference :P
  
  -Original Message-
  From:  [EMAIL PROTECTED]
  Date:  10/19/04 9:28 am
  To:  CF-Talk 
  Subj:  RE: Field Naming
  
  As said there is no definitive but here's my two pennies worth.
  
   After all, we are talking about sets here, and it's natural to
  pluralise them.
  
  My old database teacher would have a fit with that... but each to 
  their
  own :)  
  
  We use two words to describe (and name) each table
  
  An example here would be
  
  TABLE: PROJECT_DETAIL
  COLUMN: PD_ID, PD_NAME... etc
  
  The column name is collapsed two a two letter prefix, not actually 
  came
  across a time when their was a duplicate prefix within a schema but 
 
  I'm
  sure if it happened you could use a different
  
  Anyways... 
  
  -- 
  dc
  

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181897
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Ewok]

Well I don’t THINK I am, it just doesn't appear to be what I'm looking for.

Like I said, if I typed cfquery and a space in CFStudio, it would
autocomplete with ALL of the following.

cfquery name= datasource=#request.maindsn#

/cfquery


And put the cursor between the quotes in the NAME attribute. I don't see
where Edit  Prefs  Code Hints can do that. I do see how snippets can do it
but there are defiantly not enough keyboard shortcuts for all I want : )

-Original Message-
From: Massimo Foti [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 11:07 AM
To: CF-Talk
Subject: Re: Dreamweaver Autocomplete

 Thanks, I guess snippets are the closest I'm going to get in DW

I suspect you are misreading my posts... What you are looking for is called
Code Hints in DW and it's fully customizable (see previous post for
directions)


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004
 


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181898
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Consume a web service with JavaScript...possible?

[Dick Applebaum]

Have a look at Rob Rohan's Neuromancer:

http://rohanclan.com/products/neuromancer/

He wrote this for the specific purpose of consuming web services with 
Javascript.

HTH

Dick


On Oct 19, 2004, at 10:15 AM, Scott Stroz wrote:

 Massimo,

 Thanx for the info, unfortuantely, most of the links on
 http://www.mozilla.org/projects/webservices/ that would give more info
 are not working.

 What I need is something that will walk me through the steps like I am
 an idiot.  Both for consuming Web Services with JavaScript and
 creating extensions for FireFox.

 Anyone else?


 On Mon, 18 Oct 2004 22:07:31 +0200, Massimo, Tiziana e Federica
 [EMAIL PROTECTED] wrote:
 I have an idea for an extension for FireFox,  One key element is 
 going
 to be the ability to comsume a web service, or parse an XML file.

 Can I consume a web service using JavaSCript?

  Yes. If you are using Mozilla, this may be a good starting point:

  http://www.mozilla.org/projects/webservices/

 Any ideas on good references on parsing XML in JavaSCript?  Most of
 the stuff I have found is IE-centric.

  There are powerful croos-browser libraries that may be worth a check:

  https://sourceforge.net/projects/sarissa/
  http://xmljs.sourceforge.net/index.html

  Hope it will help

  
  Massimo Foti
  DW tools: http://www.massimocorner.com
  CF tools:  http://www.olimpo.ch/tmt/
  


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181899
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using a form field name as part of the name of a session variable

[Peterson, Andrew S.]

 Try this 

 cfset session[qNum#form.qNum#] = form.answer

PERFECT. I never would have figured that out on my own. I mean, there's
not even a DOT after session.  Thanks.

Sincerely,
 
Andrew


-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 12:40 PM
To: CF-Talk
Subject: RE: Using a form field name as part of the name of a session
variable

Try this 

cfset session[qNum#form.qNum#] = form.answer

Or something like that... maybe without quotes? But I think with.


-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 1:23 PM
To: CF-Talk
Subject: Using a form field name as part of the name of a session
variable

Hi,
 
I'm hoping this is just a question of syntax. Is it possible to set part
of the name of a session variable using the name of a form variable? The
form name is dynamic too. Here's the code that ain't working:
 
cfset session.qNum#form.qNum# = form.answer
^
For example, what I'd like to set in the above line of code is a session
variable named qNum2, or whatever value form.qNum is.
 
If this doesn't work, I can always hard code it using a 1000 line
cfswitch block, but no one (me most of all) wants to see that :-)
 
Thanks in advance.
 
Sincerely,
 
Andrew





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181900
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Dreamweaver Autocomplete

[Ewok]

Funny heh.

Yeah, I defiantly miss that feature A LOT most of my sites have the same
settings request.maindsn, request.imageroot, request.webroot, etc, etc...

I had a ton of autocompletes set up for them like img  spit back img
#request.imageroot#/ alt= border=0 / and placed the cursor after the
slash, cfqueries, tables, etc... just a ton of constantly reused code blocks

If I can't find something, I'll be reinstalling studio  

-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 12:23 PM
To: CF-Talk
Subject: RE: Dreamweaver Autocomplete

Ewok,

You're looking for the same thing I am - the Trigger String
functionality, which does not seem to be the same as the Code Hints or
other DW featues.  I cannot find the equivalent in DW. 

Coincidentally, I posted almost the same question as you did this
morning - see post below. 
 
Sincerely,
 
Andrew



-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 7:35 AM
To: CF-Talk
Subject: Another Is this Homesite feature in DW? question

Hi,
 
Homesite has a nice AutoCompletion feature whereby you enter a trigger
string and it spits out the remainder of the code for you. For instance,
you enter '#att and it will automatically add ributes.# and even place
the cursor before the pound sign and after the period. I cannot find
this feature in DWMX2K. Is it in there somewhere or is there a similar
feature?
 
TIA.
 
Sincerely,
 
Andrew






~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181901
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dreamweaver Autocomplete

[Spike]

This may or may not be of interest to you, but you can do this in cfeclipse.

You can specify a unique set of trigger characters for each snippet. If 
you type those characters followed by ctrl+i (or whatever custom 
shortcut you change that to) it will insert the full snippet with your 
cursor at the position between the start and end blocks of the snippet.

You can do a lot more than that if you also use snippet variables, but 
that's probably getting a bit off topic.

Of course, if you don't want to, or can't use cfelcipse then that's a 
moot point, but I thought was worth mentioning.

Spike


Ewok wrote:
 Well I don’t THINK I am, it just doesn't appear to be what I'm looking for.
 
 Like I said, if I typed cfquery and a space in CFStudio, it would
 autocomplete with ALL of the following.
 
 cfquery name= datasource=#request.maindsn#
 
 /cfquery
 
 
 And put the cursor between the quotes in the NAME attribute. I don't see
 where Edit  Prefs  Code Hints can do that. I do see how snippets can do it
 but there are defiantly not enough keyboard shortcuts for all I want : )
 
 -Original Message-
 From: Massimo Foti [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, October 19, 2004 11:07 AM
 To: CF-Talk
 Subject: Re: Dreamweaver Autocomplete
 
 
Thanks, I guess snippets are the closest I'm going to get in DW
 
 
 I suspect you are misreading my posts... What you are looking for is called
 Code Hints in DW and it's fully customizable (see previous post for
 directions)
 
 
 Massimo Foti
 DW tools: http://www.massimocorner.com
 CF tools:  http://www.olimpo.ch/tmt/
 
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004
  
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181902
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Using a form field name as part of the name of a session variable

[Chris Peters]

This would also work (although it looks kinda strange):

cfset session.qNum#form.qNum# = form.answer

 Try this 

 cfset session[qNum#form.qNum#] = form.answer

PERFECT. I never would have figured that out on my own. I mean, there's
not even a DOT after session.  Thanks.

Sincerely,
 
Andrew


-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 12:40 PM
To: CF-Talk
Subject: RE: Using a form field name as part of the name of a session
variable

Try this 

cfset session[qNum#form.qNum#] = form.answer

Or something like that... maybe without quotes? But I think with.


-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 1:23 PM
To: CF-Talk
Subject: Using a form field name as part of the name of a session
variable

Hi,
 
I'm hoping this is just a question of syntax. Is it possible to set part
of the name of a session variable using the name of a form variable? The
form name is dynamic too. Here's the code that ain't working:
 
cfset session.qNum#form.qNum# = form.answer
^
For example, what I'd like to set in the above line of code is a session
variable named qNum2, or whatever value form.qNum is.
 
If this doesn't work, I can always hard code it using a 1000 line
cfswitch block, but no one (me most of all) wants to see that :-)
 
Thanks in advance.
 
Sincerely,
 
Andrew

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181903
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Drop-Ship Limitations to California

[Dick Applebaum]

If I understand what you are saying:

1) If the state I live in charges sales tax
2) and the drop-shipper has a warehouse in my state (or is licensed to 
do business in my state)
3) I get charged sales tax even though the the item is dropped-shipped 
from an out-of-state warehouse of the drop-shipper.

That is consistent  with my understanding of sales tax law.

For example, I am charged CA sales tax on Items I purchase from another 
company in Ohio, because they are licensed to do business in CA, but 
have no facilities in CA -- they do traveling schools  demonstrations.

So, to avoid charging me taxes, pcConnection has to find a drop-shipper 
that is NOT licensed to do business in my state.

Or, I need to find a vendor with a different drop-shipper.

By the reaction I get when I talk to pcConnection support people, 
consideration mainly applies to California residents.

Dick


On Oct 19, 2004, at 10:44 AM, Cary Gordon wrote:




 This hold true for every state that charges sales tax.  If you are in 
 CA and
 hsve one local warehouse that you ship from, it is dead simple: You 
 charge
 tax in CA and no tax anywhere else.

 The mail order computer stuff companies have a more complicated 
 situation.
 They have limited warehousing on their own.  Almost everything is 
 dropped
 shipped from distributors like Ingram Micro, Tech Data, etc., and those
 folks have warehouses everywhere.  The big vendors are connected to the
 distributors extranets, but even that does not guarantee that they have
 current stock info, so if they sell you a framitz that is in IM's PA
 warehouse, and it turns out to only be available in CA, they (and you) 
 have
 a problem.

 I went through a huge argument with a company in Denver who sold me a
 product that was supposedly coming from the manufacturer in Tennessee. 
  They
 found out after the fact that it had shipped for CA and hit my credit 
 card
 for the tax. I wound up in a heated conversation with the president of 
 the
 company, and, finally, they took it off.

 Cary Gordon
 The Cherry Hill Company



 -Original Message-
 From: Dick Applebaum [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, October 19, 2004 8:22 AM
 To: CF-Talk
 Subject: SOT: Drop-Ship Limitations to California

 This is SOT but it may affect anyone writing programs to do ecommerce 
 with
 customers in California.

 I was recently told by a pcConnection representative that they could 
 only
 drop-ship items to California from pcConnection warehouses in Ohio and
 Tennessee -- because of California tax laws.

 Anyone ever heard of this?

 In my case it has caused a 2 1/2 month delay in receiving an item I 
 ordered
 on Aug 2 that was in stock (but apparently not in the correct 
 warehouse).

 TIA

 Dick


 Misery no longer loves company. Nowadays it insists on it.
 - Russell Baker -



 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181904
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Using Macromedia's DB/2 driver with Derby/Cloudscape?

[Dick Applebaum]

The Derby database is the Apache.org distro of IBM's Cloudscape 
database.

Both use IBM's DB/2 Universal driver.

I am trying to use the Macromedia-supplied driver for DB/2 in lieu of 
downloading the DB/2 Universal driver jars (Driver and License) from 
the IBM site.

Is it possible to use the Macromedia-supplied DB/2 driver to access 
Cloudscape/Derby databases?

TIA

Dick

Some people, when confronted with a problem, think “I know, I’ll use
  regular expressions”. Now they have two problems.
--Jamie Zawinski, on comp.lang.emacs

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181905
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Using Macromedia's DB/2 driver with Derby/Cloudscape?

[Dick Applebaum]

The Derby database is the Apache.org distro of IBM's Cloudscape 
database.

Both use IBM's DB/2 Universal driver.

I am trying to use the Macromedia-supplied driver for DB/2 in lieu of 
downloading the DB/2 Universal driver jars (Driver and License) from 
the IBM site.

Is it possible to use the Macromedia-supplied DB/2 driver to access 
Cloudscape/Derby databases?

TIA

Dick

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181906
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Using a form field name as part of the name of a session variable

[Ewok]

Actually that wouldn’t work. It would create the variable in the session
scope. I don't think that's what he is after. He wanted to end up with a
variable called qnum2, not session.qNum2

-Original Message-
From: Chris Peters [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 2:08 PM
To: CF-Talk
Subject: Re: Using a form field name as part of the name of a session
variable

This would also work (although it looks kinda strange):

cfset session.qNum#form.qNum# = form.answer

 Try this 

 cfset session[qNum#form.qNum#] = form.answer

PERFECT. I never would have figured that out on my own. I mean, there's
not even a DOT after session.  Thanks.

Sincerely,
 
Andrew


-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 12:40 PM
To: CF-Talk
Subject: RE: Using a form field name as part of the name of a session
variable

Try this 

cfset session[qNum#form.qNum#] = form.answer

Or something like that... maybe without quotes? But I think with.


-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 1:23 PM
To: CF-Talk
Subject: Using a form field name as part of the name of a session
variable

Hi,
 
I'm hoping this is just a question of syntax. Is it possible to set part
of the name of a session variable using the name of a form variable? The
form name is dynamic too. Here's the code that ain't working:
 
cfset session.qNum#form.qNum# = form.answer
^
For example, what I'd like to set in the above line of code is a session
variable named qNum2, or whatever value form.qNum is.
 
If this doesn't work, I can always hard code it using a 1000 line
cfswitch block, but no one (me most of all) wants to see that :-)
 
Thanks in advance.
 
Sincerely,
 
Andrew



~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181907
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Dreamweaver Autocomplete

[Massimo Foti]

Ewok [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Well I don’t THINK I am, it just doesn't appear to be what I'm looking
for.

 Like I said, if I typed cfquery and a space in CFStudio, it would
 autocomplete with ALL of the following.

 cfquery name= datasource=#request.maindsn#

 /cfquery

 And put the cursor between the quotes in the NAME attribute. I don't see
 where Edit  Prefs  Code Hints can do that.

You can do that, but not from the GUI, you have to add custom Code Hints. I
mentioned this already, go to:

Help  Extensions  Extending DW  then search for Code Hints and you will
get all the details.

Now, maybe it's not worth the efforts (it's up to you to judge), but it's
definitely possible


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/






~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181908
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Strange variable showing up...

[Phillip Perry]

In doing my banner rotation template I'm now getting an undefined error. The
error itself is not whats made me confused. Its the Application variables
list in the debugger thats got me confused. It refers to a variable called
movierotation which does not exist in my code anywhere. I did a find 3 times
on the file but its not there. Have any of you had similar problems with
variables you dont use showing up for no reason?

Phil




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181909
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Strange variable showing up...

[Adrocknaphobia]

Make sure you are defining a unique application name. Maybe there is
another cf with the same application name that includes that variable.

-Adam


On Tue, 19 Oct 2004 14:40:42 -0400, Phillip Perry
[EMAIL PROTECTED] wrote:
 In doing my banner rotation template I'm now getting an undefined error. The
 error itself is not whats made me confused. Its the Application variables
 list in the debugger thats got me confused. It refers to a variable called
 movierotation which does not exist in my code anywhere. I did a find 3 times
 on the file but its not there. Have any of you had similar problems with
 variables you dont use showing up for no reason?
 
 Phil
 
 

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181910
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Strange variable showing up...

[John Stanley]

you probably already tried this, but when you did the search did you check
the box marked include subfolders?

-Original Message-
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 19, 2004 2:41 PM
To: CF-Talk
Subject: Strange variable showing up...


In doing my banner rotation template I'm now getting an undefined error. The
error itself is not whats made me confused. Its the Application variables
list in the debugger thats got me confused. It refers to a variable called
movierotation which does not exist in my code anywhere. I did a find 3 times
on the file but its not there. Have any of you had similar problems with
variables you dont use showing up for no reason?

Phil






~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181911
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Strange variable showing up...

[Ben Doom]

Sounds like some other project is using the same application name.  Try 
changing it to something else.

--Ben

Phillip Perry wrote:
 In doing my banner rotation template I'm now getting an undefined error. The
 error itself is not whats made me confused. Its the Application variables
 list in the debugger thats got me confused. It refers to a variable called
 movierotation which does not exist in my code anywhere. I did a find 3 times
 on the file but its not there. Have any of you had similar problems with
 variables you dont use showing up for no reason?
 
 Phil


~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181912
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54