Re: macromedia and Adobe?!

[Stephen Moretti (cfmaster)]

Interesting times ahead. 

There are going to be a lot of unhappy people all round when they start 
dumping/merging competing products from either of the company's 
portfolios. (I just hope GoLive gets the bin treatment)

I'm surprised that the monopolies commission (or whatever its called in 
the US) hasn't had words about this really.


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203169
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: macromedia and Adobe?!

[Stephen Moretti (cfmaster)]

Thomas Chiverton wrote:

Incidentally, it looks more like a takeover of MM by Adobe, looking at the 
board make-up etc.

PDF FAQ  http://snipurl.com/abodemacromediaFAQ


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203177
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: Table name - Singular or plural?

[Stephen Moretti (cfmaster)]

Will Tomlinson wrote:

This is the exact reason I gave it ago with singular table names. tblPeople,
with a PK of PersonID or PeopleID didn't sit too well, tblPersons didn't
seem right either.




When I was reading through this thread, I started asking myself who names a 
table tblpeople anyway? lol! I know I have less experience than most on the 
list, but I've never built a tblperson or tblpeople. What does tblperson 
represent?

tbldoctors
tbllawyers
tbladministrators
tblemployees
tblusers

Where would I use tblperson and need to make it plural anyway? What does 
tblperson represent? Wouldn't you use something more specific? 
  

Nope.  You use something generic.
If you have tblDoctor, tblAdmin, tblLawyers, what happens when you have 
another type of job? Say nurses or barristers?  You'd have to create 
another table and a whole bunch more logic to handle them within your 
application.

If you use something more generic then you can add as many jobs as you 
like with only minor changes to your application logic to handle the 
additional types.

tblEmployee is ok as is tblUser, because these are both fairly generic, 
allowing you to add as many employees or users as you like and then 
apply a job title/description to an employee (director, secretary, 
doctor, nurse) and roles to users (user, administrator, moderator).

Below is an example of storing a person's details and being able to 
assign them to multiple types.  If you only wanted to allow a person 
to have one type you would place PersonTypeID in tblPerson as a 
foreign key.

tblPerson
===
PersonID
Name
Address
TelNo

lnkPerson2PersonType
===
PersonID
PersonTypeID

tblPersonType
==
PersonTypeID
Title
Description

tblPerson
--
PersonID Name   Address   TelNo
1  Stephen Moretti   Newcastle Upon Tyne  0845 226 2896

tblPersonType
---
PersonID Title Description
1   Director Company Director
2   Developer  ColdFusion Developer

lnkPerson2PersonType

PersonID   PersonTypeID
1   1
1   2

Now with tblPersonType, I can add as many types as are needed by the 
application and add more when I realise I've missed some.  I can be 
anything I want, doctor, nurse, evil genius. just by adding the type 
to the table and linking the person to the new type.

PersonID Title Description
3  Evil Genius  Austin Power's latest nemesis

lnkPerson2PersonType

PersonID   PersonTypeID
1   3

I hope that makes sense.

Regards

Stephen
PS.  Please excuse the evil genius stuff  Having one of those 
mornings. :D


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200661
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: Table name - Singular or plural?

[Stephen Moretti (cfmaster)]

Calvin Ward wrote:

Now you're delving into normalization, which is loosely connected, but not
tightly coupled, with table/view/etc. naming conventions.
  

Yeah.  Normalisation is something that I do without even thinking about 
it these days.  I didn't really want to get into it, but it related to 
Will's question of naming tables and using tblDoctor and so on. 

I also don't like to use tbl as a prefix, however using a prefix for link
tables, views, stored procedures, etc. seems fine.
  

My use of the tbl prefix comes and goes (consistent within a project). 
Sometimes I like to use it. Other times it annoys the hell out of me.  
It is, however, useful for grouping tables, link tables, views, sp, etc 
together when viewing database objects. Its mildly annoying when you 
have lnkTableName and a data table vanishes into the midst of the link 
tables because the table name begins with the letter L.

Even after 16 years of database design and development I still haven't 
come up with a table naming convention that I'm really happy with.  Its 
probably a bit like how I now like cabbage, when I used to hate it as a 
kid.  My tastes keep changing.

Stephen


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200667
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: need coldfusion splst sr level-with cascade bob ross 201 569 2822 to 100k

[Stephen Moretti (cfmaster)]

Jeffry Houser wrote:

  That has to be the shortest job post I've ever read, although I don't 
think I understand all the code.  What is splst?
  Senior Level, with Cascading Style (sheets?)

At 10:14 PM 3/29/2005, you wrote:
  

need coldfusion splst sr level-with cascade
style-urgent-bob ross 201 569 2822-central nj-80-100k-urgent


(Gets old man's head out the box) Mobile phones have a lot to answer for!! 

So in english.

Urgent Requirement!
Senior level ColdFusion specialist with Cascading Style Sheet expertise 
required for permenant position in Central New Jersey.
Wage $80,000 to $100,000 dependant on experience
To apply, contact Bob Ross on 201 569 2822


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Re: MySQL DSN troubles

[Stephen Moretti (cfmaster)]

Eric Creese wrote:

Okay still having trouble with this. I downloaded the connector and followed 
the directions  at this link 
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253) However 
I now get a new error.

Connection verification failed for data source: bhkjxk
[]java.lang.NoClassDefFoundError: java/sql/Savepoint
The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint
  

Don't know if this is related or not, but there's a line missing from 
that KB article.

You also need to add the path to the J Connector to the Class Path in 
the Java/JVM settings in the CF Admin, then you can restart the server.

Actually, I set up the connector a whole different way that doesn't 
include using the WEB-INF/lib folder.

Save the mysql-connector-java-3.1.7-bin.jar (latest version I believe) 
to anywhere you like (I have mine saved in CFusionMX/runtime/servers/lib 
- can't remember why, but it works) 
Add the path, including the full jar file name, to the class path under 
the Java/JVM settings in the CF Admin. Make sure you use the correct 
seperator for your server OS, if you already have anything in the Class 
Path.
Make sure that the user CF is running under has access to the jar file 
and now restart the CF services.

Other than that, my DSN settings are exactly the same as the way you 
have yours set.

Another possibility to look into is changing the JVM that CF is using.  
I have mine currently using Sun j2sdk1.4.2_04, but I believe that you 
can go up to j2sdk1.4.2_07, but 07 may possibly break LDAP.

Hope that helps.

Stephen
PS. You  were posting at 1am, 1:40am and 3am GMT!  Its got to be quite 
out there in list land at that time. ;)


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200393
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: MySQL DSN troubles

[Stephen Moretti (cfmaster)]

Steven Erat wrote:

Don't know if this is related or not, but there's a line missing from 
that KB article.
You also need to add the path to the J Connector to the Class Path in 
the Java/JVM settings in the CF Admin, then you can restart the server.



For article http://www.macromedia.com/go/6ef0253, you do not need to add the 
driver jar to the class path if the jar is in cf_root/WEB-INF/lib

The jar files in cf_root/WEB-INF/lib are automatically included in the 
ColdFusion classpath when ColdFusion starts.
  

Yeah I realised after I started replying hence the Actually... part of 
my reply. However, for some reason I've had problems getting the 
suggested installation in article 6ef0253 to work.  I never did work out 
why I couldn't get the J Connector working like this and could be 
completely unrelated to Eric's problem.  The alternate J-Run type set 
up has always worked for me on a number of different OS Servers.

I think I got this alternate installation set up from your blog Steven ;)

Stephen


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200437
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: MySQL DSN troubles

[Stephen Moretti (cfmaster)]

Ken Ferguson wrote:

Sorry, I hit send on accident before pasting it in.

I've got this in my class path mapping:
C:\CFusionMX7\runtime\jre\lib\ext\mysql-connector-java-3.1.6-bin.jar
  

Yeah this is for the reason that Steven states below.

For article http://www.macromedia.com/go/6ef0253, you do not need to add
the driver jar to the class path if the jar is in cf_root/WEB-INF/lib

The jar files in cf_root/WEB-INF/lib are automatically included in the
ColdFusion classpath when ColdFusion starts.
  

Because you don't have the jar file in thie WEB-INF/lib you need to add 
the path to the jar to your class path.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200439
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: Anyone used these tools?

[Stephen Moretti (cfmaster)]

Claude Schneegans wrote:

 We will not be supporting firefox until they improve their handling 
of javascript.

I don't know which bug they are refering to, but one thing is sure: if 
they had a decent documentation about what can be done with their 
Javascript implementation at Mozilla, more developers would be 
interested in having cross browser applications.

  

Here you go Claude.

http://www.w3.org/DOM/




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198139
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: Anyone used these tools?

[Stephen Moretti (cfmaster)]

Will The Game wrote:

http://www.smartsurfonline.com/cfpowertools/

And PLEASE don't post with, cf-community please.

SHEESH!

Will
  

Will,

I think that gives you your answer.

This company are on people's junk email list.
They have been known not to complete projects in a timely fashion.
They have been known to falsify download statistics in order to gain a 
high ranking for their product.
They are rude to people who try to help them by reporting a problem with 
their website.
They are incapable of writing or debugging relatively simple JS to check 
browser compatibility.

It doesn't bode well for thier products really.  If one of your 
requirements is cross browser compatibility which includes Firefox, then 
I would not be surprised if these products are unsuitable for you.

But, that all said, if you trial the product you want, you like it, it 
does what you need, its in a suitable price bracket and you get 
acceptable levels of customer service, then go for it 

Stephen


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198143
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: eggy

[Stephen Moretti (cfmaster)]

RADEMAKERS Tanguy wrote:

http://www.petefreitag.com/item/90.cfm 


  

Heck! Thats like 3 years old!



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194939
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: 2 to the power of 10

[Stephen Moretti (cfmaster)]

Tony Weeg wrote:

hola peeps!

is there a udf or something else to handle this simple calculation?

i can do it myself, with some dumb code, just wondering if there is
something already built.
  

After all the smart alec answers ;)

2^10 is what you are after.  ^ is the CF exponentiation operator.


Regards

Stephen



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194983
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: 2 to the power of 10

[Stephen Moretti (cfmaster)]

Stephen Moretti (cfmaster) wrote:

Tony Weeg wrote:

  

hola peeps!

is there a udf or something else to handle this simple calculation?

i can do it myself, with some dumb code, just wondering if there is
something already built.
 



After all the smart alec answers ;)

2^10 is what you are after.  ^ is the CF exponentiation operator.
  

D'oh!  Now I see why everyone looked to be taking the michael!  
Thunderbird interpretes 2  ^  10 and turns it into 2^10!




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194990
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: Internet Explorer 7 (no really!)

[Stephen Moretti (cfmaster)]

Bryan Stevenson wrote:

The only way I can see that FireFox (or any other newcomer) can truly make a 
dent (and/or scare MS) is to convince computer manufacturers/retailers to 
package FireFox with their computers.  That of course will require the 
heavens to open up and large bolts of lightning will spill form and strike 
Redmond ;-)
  

The EU seems to be having a good go at this  Telling Bill to stop 
his unfair practices of wiring in Media Player et al


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195006
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

MySQL J Connector error and Changing class path on CFMX6.1 update 1 on RH Linux

[Stephen Moretti (cfmaster)]

I haven't had to change anything on this server for ages, but now we're
looking at up upgrading mySQL to mySQL 4.1 and I thought I do some other
minor maintenance while I'm at it.


So problem number one:  I've followed Steve Erats instructions on how to
set up the mySQL J Connector, but I keep getting No suitable driver
available please check the driver setting in resources file, error:
com.mysql.jdbc.Driver.
The J Connector does work with MySQL 4.0.x, doesn't it?
This all works fine on my windows dev box.

Second problem,  I thought I'd try and see if my other problem was class
path related, so I put the mysql jar file somewhere else and tried to
change the class path to point to it.
When I hit submit I get Important notice about last submission... and
then a red bullet point beneath it and no message.  Up above the
important notice text I get what looks to be a grey cfdump output that
says [unknown type] and nothing else.
I've had a look at the logs and there is nothing showing up in there.


Any help would be much appreciated, cos a simple test has now turned
into a major expedition!

Regards

Stephen





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194219
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 Developer - Northern Virginia

[Stephen Moretti (cfmaster)]

S. Isaac Dealey wrote:

Expects a bachelors degree but doesn't seem to know what incumbent
means...

http://dictionary.reference.com/search?q=incumbent

Unless he meant lying, leaning, or resting on the job offer...
  

Issac,

You need to read the noun rather than the adjective.

Stephen


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

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

Re: ColdFusion Developer - Northern Virginia

[Stephen Moretti (cfmaster)]

Stephen Moretti (cfmaster) wrote:

S. Isaac Dealey wrote:

  

Expects a bachelors degree but doesn't seem to know what incumbent
means...

http://dictionary.reference.com/search?q=incumbent

Unless he meant lying, leaning, or resting on the job offer...
 



Issac,

You need to read the noun rather than the adjective.
  

Mind you, with that meaning, it does make it sound like this job is only 
going to the person who already holds it. ;oD


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

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

Re: CF7 MySQL question

[Stephen Moretti (cfmaster)]

Andy Allan wrote:

You have to install the v4 driver yourself, and I believe there is
already a technote on how to do so (as well as being blogged by Steven
Erat).

I'm sure someone from MM will pip in with the reasons as to why the v4
driver wasn't shipped :-)
  

More than likely its because the v4 J Connector driver is a work in 
progress, where as the v3 driver is now completely static.

Which reminds me - must update the Connector on my dev machine.

Stephen


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193802
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: help with approach for order tempalte

[Stephen Moretti (cfmaster)]

Tim Laureska wrote:

upon submission of this order screen, the template needs to summarize
the order for the customer

I'm not sure how to approach this... ie. how to send the order
information to a process template and then how to code the template to
ensure proper entry into the DB

Is this a structure scenario or query loop or what..??

Being new to this sort of ordering, any pointers in the right direction
would be appreciated
  

You're going to need 2 tables for storing orders.
One for storing the general details of an order like the date of the 
order, customer name, address, contact details that kind of thing.  You 
could probably go one stage further and have a Customer table, so that 
people can register on the site and only need enter a customer id and 
password to complete their invoice/delivery details, but for the minute 
I'll stick with one table with the customer details in there.

So, your Order table would be :
OrderID
OrderDate
CustomerName
Address1
Blah...

Items order would be in a table (OrderItems) like so :
OrderID
ProductID
OrderQty

On your order form you should make sure that each Quantity field is 
uniquely identified for each product.  One of the ways I've used in the 
past is to append the productid to the name of the quantity form field.

eg.
form action=ordersummary.cfm method=post
cfoutput query=ProductList
#ProductTitle# - #ProductDescription# - input type=text 
name=Quantity_#ProductID# size=3 maxlength=3
/cfoutput
input type=submit name=submit value=submit
/form

If your Product ID for an item is say 123 this would give you a 
quantity field called Quantity_123 on the summary page and the value of 
this form field would be the quantity that the person wants to order.

You will need to parse through the form fields to get the productid and 
quantity ordered.  I'm sure there are probably better ways, but here's 
one thats tried and tested.

cfset NoFormFields = ListLen(form.fieldnames)
!--- Loop through all the form fields ---
cfloop from=1 to=#NoFormFields# index=i
cfset thisFieldName = lcase(ListGetAt(form.fieldnames,i))
!--- Check to see if this field is a Quanity Field ---
cfif ListFirst(thisFieldName,_) EQ quantity
   !--- It is, so get the productID off the end of the variable 
name ---
   cfset thisProductID = ListLast(thisFieldName,_)
   cfset thisOrderQty = form[thisFieldName]
   !--- Now insert the Order Item into the table with an OrderID 
that was previously generated ---
   cfquery name=InsertOrderLine datasource=YourDSN
   INSERT INTO OrderItem (OrderID,ProductID,OrderQty)
   VALUES (#thisOrderID#,#thisProductID#,#thisOrderQty#)
   /cfquery
/cfif
/cfloop

It should go without saying that you need to use all the appropriate 
variable scoping and cfqueryparams with any code in this email.

The thisOrderID is a value that you've either generated manually, 
created using createuuid() or is the ID of the customer order details 
record that was stored in the database. Which ever way you create it, 
its the unique identifier for this particular order.

To create the summary you would create a JOIN query between your product 
table and your order item table to get the details of each product 
ordered and the quantity ordered. eg.

SELECT p.ProductID, p.Title, p.Description, p.Price, oi.OrderQty
FROM Product AS P
INNER JOIN OrderItem AS oi ON p.ProductID = oi.ProductID
WHERE oi.OrderID = #thisOrderItem#

You can now loop through this query row by row, outputting the product 
details, the quantity ordered and the cost of ordering that many items, 
with an total order value at the bottom of the summary.

Well I think thats about it...  I hope that helps and hope I didn't go 
off at a complete tangent, completely misinterprete your question or try 
to teach my grandmother to suck eggs.

Regards

Stephen


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192856
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: 50 GMail Invites???

[Stephen Moretti (cfmaster)]

When they've taken over the world Pinky! ;)

Sorry - I'll go now...

Adrocknaphobia wrote:

Heck, I couldnt even give away my first 6 so exactly when will it
stop being a 'beta'?

-Adam


On Thu, 3 Feb 2005 17:36:43 +, Mark Drew [EMAIL PROTECTED] wrote:
  

ANyone noticed that Gmail now gives away 50 invites?

I dont know that many people! sad ole me!





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192911
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 Coldfusion with XML

[Stephen Moretti (cfmaster)]

Ian Vaughan wrote:

Getting the following error from my ocde below, any ideas folks?
  

[snip]

Document root element is missing.  
Document root element is missing.  
  

[snip]

Ian,

You need to read up on the usage of CFFILE and its actions. The action 
upload does not load the file into a variable, it moves the file from 
a temporary file created by the web server during the form submission to 
a real file some where on the harddisk of the server.  You still need to 
read the file in once you have uploaded it somewhere appropriate.

You have been told this previously by other response to your email. 
Please make sure you carefully read the responses you get and read the 
manual for the various CF tags and function you are using.

Below is some code to help you out. 

Regards

Stephen
=
cffile action=upload
filefield=UploadFile
destination=#GetTempDirectory()#
nameconflict=overwrite

cffile action=read
file=#GetTempDirectory()##cffile.serverfile#
variable=variables.thisXMLFile

CFSET variables.MyXML = XmlParse(variables.thisXMLFile)

CFSET variables.xnBuildingRecordset = variables.MyXML.XMLRoot

CFSET variables.xnSchemeUniqueRecordIdentifier = 
variables.xnBuildingRecordset.XMLAttributes[name]

CFOUTPUT
PThe Number is #variables.xnSchemeUniqueRecordIdentifier#/P
/CFOUTPUT


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191913
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 Coldfusion with XML

[Stephen Moretti (cfmaster)]

Ian Vaughan wrote:

I have an XML document that needs to be converted to a fixed width Comma
Seperated File so it can be inserted into the relevant databases.

XSLT would perform this transformation but how can Coldfusion fit in to
make this an easy to use web application.

For example...

The user would upload the XML file using CFFILE through a web interface.
In the action page it would process the XML doc and produce the relevant
CSV file.

Any ideas on the best way forward on this ...
  

What exactly is the end point?  The creation of the CSV?  Or does 
something happen with the CSV afterwards?

If something is happening with the CSV afterwards, then you need to look 
at what you need in order to perform the next task. 

If the CSV is the end, then you probably don't need to involve CF other 
than to handle the file upload, just use the XSLT.
If you want to save the generated CSV out somehow somewhere, then Nick's 
suggestion of the XMLTransform is probably the way to go.
If you actually need to do something with the XML data in CF, but only 
need the CSV as a means of getting the data into CF, then xml2query will 
cut out the CSV middle-man giving you something easier to work with in CF.

So basically, you need to think about what is next the application/data 
flow and process the XML accordingly.

Stephen


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191774
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 Coldfusion with XML

[Stephen Moretti (cfmaster)]

Ian Vaughan wrote:

Dave

There is no real requirement, would it be easier (coding wise) to
transform the XML files straight into the database via CFFILE ? Rather
than producing a CSV file?
  

Ian,

Are you trying to just dump the CSV into a column in a table in your 
database?
Or are you looking at taking the XML root as being a table that exists 
in your database, the children in that xml packet being rows and columns 
in your table and putting each child under the root into a row in the 
database?

Stephen



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191810
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 Coldfusion with XML

[Stephen Moretti (cfmaster)]

Ian Vaughan wrote:

Yes taking the XML doc and parsing the information stored within into a
database table. 
  

ok - in which case - I refer you to point 3 of my previous email

If you actually need to do something with the XML data in CF, but only 
need the CSV as a means of getting the data into CF, then xml2query will 
cut out the CSV middle-man giving you something easier to work with in CF.

You can then use the query thats been created from the xml to insert the 
data into your database.

Regards

Stephen


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191817
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: .net will

[Stephen Moretti (cfmaster)]

Mark Drew wrote:

Darn, 
I better move to the states, although moving to london I might be able
to find a CFUG, hell, if I do I promise not to only eat my hat (I dont
have one so easy) but to show off cfeclipse :)
  

Mark,

There is one CFUG and one MMUG in London, plus there are variety of UGs 
cropping up in Scotland now.

I used to run a Northern UK CFUG that travelled between Newcastle, Leeds 
and York, but short of coming and visting people in their own front 
room, people were surprisingly apathetic! :(

Anyway, take a look here http://snipurl.com/ukmmugs  for the UK UG listings.

Stephen


~|
Logware: a new and convenient web-based time tracking application. Start 
tracking and documenting hours spent on a project or with a client with Logware 
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191531
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: BlogCFM seeks hosting

[Stephen Moretti (cfmaster)]

Rick Root wrote:

Would anyone like to donate some hosting for the BlogCFM project?  I'm 
developing it on my coldfusion server at work.. but would like someplace 
reasonably permanent for blogcfm to live.  Preferably on a linux server 
with mysql.  CFMX preferable, as I haven't tested it on Bluedragon yet 
because I don't have access to a server running a production version of 
bluedragon)

Traffic won't be high - the downloads will all be from cfopen.org.

I'd be happy to place a link to the hosting provider on the site.

I'm making good progress towards the first public source release... I've 
added most of the features I want to see initially.

Thanks.

Rick

BlogCFM:  http://www.it.dev.duke.edu/blogcfm
  

www.cf-developer.net


~|
Logware: a new and convenient web-based time tracking application. Start 
tracking and documenting hours spent on a project or with a client with Logware 
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191321
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: BlogCFM seeks hosting

[Stephen Moretti (cfmaster)]

Stephen Moretti (cfmaster) wrote:

Rick Root wrote:

  

Would anyone like to donate some hosting for the BlogCFM project?  I'm 
developing it on my coldfusion server at work.. but would like someplace 
reasonably permanent for blogcfm to live.  Preferably on a linux server 
with mysql.  CFMX preferable, as I haven't tested it on Bluedragon yet 
because I don't have access to a server running a production version of 
bluedragon)

Traffic won't be high - the downloads will all be from cfopen.org.

I'd be happy to place a link to the hosting provider on the site.

I'm making good progress towards the first public source release... I've 
added most of the features I want to see initially.

Thanks.

Rick

BlogCFM:  http://www.it.dev.duke.edu/blogcfm
 



www.cf-developer.net
  

Ahh - sorry!  I forgot!  cfdeveloper is no longer available to people 
outside of the UK due to abuse by overseas users.


~|
Logware: a new and convenient web-based time tracking application. Start 
tracking and documenting hours spent on a project or with a client with Logware 
today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191322
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: BlogCFM seeks hosting

[Stephen Moretti (cfmaster)]

Neil Middleton wrote:

That'll explain where http://www.cf-developer.co.uk went then
  

Its still there, just without the hyphen. ;)


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191329
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: How'd www.firstnight.org do over new years?

[Stephen Moretti (cfmaster)]

Jim McAtee wrote:

- Original Message - 
From: Jim Davis [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, January 03, 2005 9:23 PM
Subject: RE: How'd www.firstnight.org do over new years?


  

Anything else you'd like to know?



That was certainly fascinating, but why the particular fascination with 
site stats for a web site that only has significant traffic for 72 hours 
out of the year?
  

And why not?  Snapshots like this from event-based sites that receive 
relatively heavy traffic for short periods of time are probably better 
than information coming out of longer term audience-based sites.  The 
audience based sites have a tendency to show trends according to the 
specific user profile, where as events will have a much broader user 
spectrum.

I suspect that you're really only objecting to one specific paragraph, 
which is kinda sad really, as the other information regarding stats is 
an indicator of number of people that accessed this application in the 
short life of the event and interesting, though not surprising, 
marketing related information.

I'm guessing you must be volunteering your time.  You'd have saved many, 
many hours of work by simply moving to a dedicated server a couple of days 
prior to being swamped.  

I think the answer to your comment is found in this statement from Jim's 
email:
Finally around 2pm the client bit the bullet and let me order a 
dedicated server.



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189222
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 built-in tags and permission-based security framework

[Stephen Moretti (cfmaster)]

Ian Vaughan wrote:

How could I display the correct menu options which are generated from the 
correct cfquery based on the user logged in.

So if the user logged in is from the personnel department the following query 
populates the select boxes, but if the user logged in is from the finance 
department then the finance query runs on the page to populate the select box.

Can anybody see any flaws with this approach ? Or how it can be improved to 
make the solution more flexible?
  

Ian,

Are you saying that you have a separate category table for each department?

Stephen



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188510
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: ColdFusion built-in tags and permission-based security framework

[Stephen Moretti (cfmaster)]

Stephen Moretti (cfmaster) wrote:

Ian Vaughan wrote:

  

How could I display the correct menu options which are generated from the 
correct cfquery based on the user logged in.

So if the user logged in is from the personnel department the following query 
populates the select boxes, but if the user logged in is from the finance 
department then the finance query runs on the page to populate the select box.

Can anybody see any flaws with this approach ? Or how it can be improved to 
make the solution more flexible?
 



Ian,

Are you saying that you have a separate category table for each department?

Yes, each department about 6 in total 

Ok - you definately need to abstract the design of your database.  At 
the minute, if you need to add a new department or remove a department 
you have to get your hands dirty, create a new table or remove a table 
from the database and make changes to the code to allow for this.

What you need to do is have one category table, one user/member of staff 
table and a department table.  The departments table maintains the 
complete list of departments along with a unique ID for each 
department.  The same is true for the users and categories tables.
You then need to relate these tables to one another, ie. have tables 
that tell you which users belong in which department and which 
departments have access to which categories. 

Take a look at the ER diagram I've run up for you here 
http://snipurl.com/bilm  It fairly simplified, but hopefully it should 
help to make sense of what I'm describing above.

With a database structure like this you can add and remove departments 
extremely easily, add new users to departments and change the categories 
available to any given department as well as allow multiple departments 
access to one category.

How does this work?  Your user logs in, so you get a unique identifier 
for them by querying the users table during the login process. 

SELECT UserID FROM Users
WHERE UserName='#form.loginname#' AND Password = 
'#hash(form.loginpassword)#'

With that UserID you can identify the department(s) that that user is a 
member of, by querying the link table between user and department.

SELECT Department.DepartmentID, Department.DepartmentName
FROM Department
INNER JOIN DeptMembers AS DM ON Department.DepartmentID = 
DM.DepartmentID
WHERE DM.UserID = #qryUser.UserID#

If you want to know what categories they can access you can get this 
information by JOINing DepartmentMembers to Categories through 
DepartmentCategories.

SELECT Categories.CategoryID, Categories.CategoryName
FROM Categories
INNER JOIN DepartmentCategories AS DC ON Categories.CategoryID = 
DC.CategoryID
INNER JOIN DepartmentMembers AS DM ON DC.DeparmentID = 
DM.DeparmentID
WHERE DM.UserID = #qryUser.UserID#

This doesn't take in to account handling your tree of categories, but as 
you've more than likely got the code to manage this, it shouldn't be too 
hard to integrate what is here with what you've got for the category tree. 

BTW : You should have a look at John Celko's nested set model 
(http://snipurl.com/JoeCelko_NestedSets - you will need to register on 
the site, but its free and I've not had any spam from them)

Hope this helps

Regards

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188514
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: Spam Filters

[Stephen Moretti (cfmaster)]

Another method of attack is using an email client that has junk mail filters 
built into it. I use Mozilla's Thunderbird email client, which has junk mail 
filters that, once trained, filter out spam amazingly well.
  

Complete aside - but just thought I'd mention that Thunderbird v1 has 
been released!!! :oD
Download speeds are understandably awful at the minute, but they could 
be much worse!

Stephen


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186752
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: Spam Filters

[Stephen Moretti (cfmaster)]

Tim Laureska wrote:

It looks like they took the download Thuderbird link off the mozilla site as 
of 5:40 AM EST
  

???

http://www.mozilla.org/products/thunderbird/

Still there for me.




~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186771
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: CFMODULE vs. CFINCLUDE

[Stephen Moretti (cfmaster)]

The loadtemplate.cfm is a engine which provides us with overriding
schemes. 

So basically you're using a cfmodule to cfinclude some files depending 
on what is in the attributes of the tag.

I personally would only use cfsavecontent for caching logic.
Then you would have encapsulated those tags with a cfsavecontent tag.
  

??confused   cfsavecontent takes output and puts it into a variable. It 
doesn't cache anything.

Micha,  a favour. Could you put at least a little of the email that you 
are replying to into your response please? For some reason your emails 
don't thread properly, they always appear under the initial email and 
not under the email you are replying to.  In a long thread without a 
reference to what you're replying to, your responses can be very confusing.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185780
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

cfx_google on cf5 and linux

[Stephen Moretti (cfmaster)]

I'm trying to get cfx_google up and running on CF5 on Linux.

I've got the default cf5 jvm registered.
I've got the full path to the googleapi.jar in the class path field (its 
the only one there)
I've been lazy and put the jar in to the default 
/opt/coldfusion/Java/classes directory, so CFX Jar Path is just that and 
so is the Dynamic Class Load Path.

In the CFX Tags I've created a java cfx tag entry with CFX_GOOGLE for 
the tag name and CFX_Google for the Class Name.

The jar has the same ownership and rights as the other jar files in the 
Java/classes folder and I've checked that I've got the right case for 
the class name in the jar.

I've restarted CF a number of times and rebooted the whole server once.

Despite all this I'm still getting :
The JVM library could not be found. Please check if the file specified 
in the ColdFusion Administrator actually exists.

I'm kinda rusty on java cfx's, but I think I've covered all the bases, 
so not sure why this is failing. 

Any help would be much appreciated.

Stephen


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185784
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: CFMODULE vs. CFINCLUDE

[Stephen Moretti (cfmaster)]

Ben Rogers wrote:

In ASP based services, cfimport is useless because it demands a static
taglib attribute. That takes away all the glamour and glitter the tag
could have. At.. least.. for me ;)



I agree that it's an unfortunate limitation, but I'm not sure how ASP based
services has any direct relevance? We have developed and/or currently host
several ASP style applications, some of which use the cfimport tag. The
static nature of the cfimport tag definitely affects the overall site
structure a bit, but I don't see how it precludes an entire class of
applications.
  

ASP = Application Server Provider not Active Server Pages in this instance


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185811
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: CFMODULE vs. CFINCLUDE

[Stephen Moretti (cfmaster)]

Ben Rogers wrote:

If I remember correctly, doesn't cfmodule create a whole new memory
block for every call, where as the cfinclude will only use the existing
memory space and be part of the normal page cache?



Yes. In fact, that's at least part of the point. cfmodule -- and custom tags 
in general -- provide encapsulation. I would only use cfinclude only if you 
really want the included tag to be able to step all over your variables and
vise-versa.
  

You are quite correct.  However, using cfmodule and custom tags is 
potentially is server killer because it is EVERY call to the 
cfmodule/tag and not just the first call that grabs additional memory.  
So for every page call for every site visitor more memory is allocated 
for each cfmodule.  Showing my age a bit now..  cfmodule and cf in 
general used to have a few problems with letting go of and reusing of 
allocated memory, so I've become acustom to using cfincludes rather than 
cfmodule, because of low resources in the memory department years back 
and a need to make stable applications that didn't require me to restart 
the server every couple of hours.  (A slight exageration, but that did 
used to happen with one of the sites I built back in 1997.  It used to 
get extremely high peeks of traffic at certain times of the day and it 
used to take the server down by taking all the available memory.  We 
eventually worked out what the problem was, reworked a load of stuff in 
the site and then site was rock solid - so solid that our poor old 128kb 
line used to get topped out)

With regards step all over your variables.  Never had a problem.  All 
it takes is a little care, attention to detail and meaningful variable 
names.

Even if this isn't true for CFMX any more, personally, I'd probably lean
towards the cfinclude method, because
a) thats what I'm used to,
b) I find it visually easier to read



My preference is to use custom tags. I keep all the tags having to do with the 
look and feel of a site in a directory called /tagLibs/layout. I then use the 
cfimport tag to import them with the prefix layout. It ends up
looking something like this:

What's CFIMPORT?  ~joke~   Most of my clients are still on CF5 (don't 
fix what aint broke).

Personally, I find that much easier to read. More importantly (almost as 
important as encapsulation), it also affords me the ability to pass in 
parameters via the tag attributes. The tags have corresponding cfparam tags
which check to ensure that parameters have been passed and supply defaults if 
necessary.
  

Personal feelings.  Don't rag on mine just because I don't agree with you.

  

c) I feel like can tinker with the header and footer dynamically with a 
cfinclude than a cfmodule.



I assume by using the phrase I feel like you mean that there isn't a 
practical difference? I would agree that the use of includes establishes less 
of a contract between the caller and the tag/template. However, I think that's 
a very bad thing. You, on the other hand, seem to prefer a less
formal interface between your cfm templates.
  

In a sense yes that is correct.  By tinker dynamically I mean I can 
replace the headers much more easily dynamically with cfinclude than I 
can with cfmodule.  I can have a directory full of different headers for 
different occasions (images of Wurzel Gummage come to mind).  I can 
easily switch between headers by changing a single variable.  Using a 
CFMODULE, I have to pass some information into the tag that tells the 
logic in the tag which bit of html to use.  That html is either hard 
coded into the module (yak!) or you cfinclude it (pointless call to 
cfmodule). 

andd) Easier to get to the header and footers if I need to change them or 
simply replace them.


I'm not sure I understand this. Why would you have to put your cfm template 
anywhere different if you're using the cfmodule tag as opposed to cfinclude?
As far as I know, the path attribute of both tags obey all the same rules.

So you've never had a client ask you to re-skin a site?  Here's a new 
design now go implement it. I'm not talking about simple CSS changes 
here.  We're talking structural changes. If you have display code 
embedded inside logic, which happens the second you use a cfmodule or a 
call to custom tag, you would have to fiddle on  changing the HTML 
buried in the logic or take the html out of the logic and replace it 
with the new html.  Both of these methods are prone to simple time 
consuming mistakes - one slip and away goes a bit of logic you didn't 
want to remove.  Seperate your html into individual files that can be 
included, set up a few standard variables for things like page titles 
etc and you can hand it off to a designer and let them get on with it 
with  no fear that they are going to break anything more disasterous 
than the page title.

What goes on inside the the cfmodule?  Is the header and footer actually 
inside the cfmodule template or does it include 

Re: CFMODULE vs. CFINCLUDE

[Stephen Moretti (cfmaster)]

I had some problems in ColdFusion 4.0, though I think 
(besides not giving up memory) most were squared away by 4.1. 
I don't think I deployed anything to (nor load tested on) 
4.5. ColdFusion 5 seemed to be better about giving up 
resources that weren't in use.



CF 5 did release memory, while CF 4.0.1 didn't. I don't remember whether CF 
4.5.1 did or not.
  

If remember correctly 4.5.1/2 were better, but still not the best.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185856
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: CF and Databases

[Stephen Moretti (cfmaster)]

Jason Smith wrote:

I have a client that has access backend for his cf application, when trying 
to run a query for a report that checks for item status the page always 
times out never will load. The query works on other reports with no 
problem. There are about 1500 products in the field and the status id is 
numerical from 1-10.

Now myself personally I would never use an access database for this type of 
work I would prefer to use mysql but I don't have that choice. So if anyone 
is familiar with cf/access or know of any issues that have to do with 
access indexing not working correctly under a cf app please let know.
  

1500 records is really a drop in the ocean for what, the much maligned, 
Access can handle.  Its not ideal for a web app, but it'll handle a hell 
of a lot more traffic than is generally made out with careful querying 
and the judicious use of the various types of caching available in CF.

The problem sound like it is down to the query and the indexes on the 
tables.  Can you tell us the query and the table structure, specifically 
the column type and indexes for the columns that are joined?

Stephen


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185640
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: MX Methodologies (Mach2?? Fusebox??)

[Stephen Moretti (cfmaster)]

Claude Schneegans wrote:

It is a big deal if it made your job easier and your project more successful.
  


My point is that it DOES NOT make my job easy.
Apparently, at least for the product I'm thinking of, it made easier for the 
programmers to make an inefficient system that repeats 5 times the same query 
in the same page, etc. And it is a commercial product.
And no, trying to find my way in a structure that includes 100 templates DOES 
NOT make my job easier.

I tend to stay out of the fusebox arguments and have since in the 
inception of FB3, which is frankly a right old mess and deserves the 
criticism it deserves when, in my opinion (which probably isn't worth a 
damn), it lost sight one of the original core concepts of Fusebox; 
readability.  It became illegible to the casual code browser and the 
core code was quite capable of generating spaghetti without adding 
anything extra to the application. This said, Mach-ii does intrigue me 
and given appropriate time I will be taking a look at it. 

This all aside, well a written Fusebox application, whatever version you 
use be it FB2, xFB, FB3, FB4 or Mach-ii (not strictly FB, but an 
off-shoot all the same), should NOT call the same query in the same page 
5 times.  That is just plain bad application design and development and 
is not a function of Fusebox.

Breaking an application into lots of small templates that are only 
included when required and controlled by conditions is actually very 
efficient in version of CF prior to CFMX.  The reason being that in 
previous version of CF included files are only ever interpreted when a 
surrounding condition was found to be true. 

For example :
cfif somecondition
cfinclude template=thisfile.cfm
cfelse
cfinclude template=thatfile.cfm
/cfif

If somecondition is true then thisfile.cfm is picked up and interpreted, 
but thatfile.cfm is ignored.  If these templates are actually quite 
large and the code was inline in the condition above, then every single 
line of code would have to be interpreted, rather than only the code 
that is required for the given condition.

This doesn't forgive bad layout of conditions and poor naming for files, 
but with readable code, sensible filenames and a fuseaction you should 
be able to isolate the file you need to one or two files at the most 
fairly quickly.  Unfortunately, FB3 does not lend itself well to this 
simple concept because it attempts to make life easy for you by allowing 
you to map circuits in the fbx_Circuits.cfm file and having 300 lines of 
code in one of 5 files in order to work all that out.

I still use an enhanced/extended version of fb2 after all these years.  
I can go back to an application that I haven't looked at in years or 
look at any number of applications written by a number of colleagues 
around the country and within minutes I can follow the code and find the 
files I need.  (I may cringe at some of the code I wrote way-back-when, 
but that soon repaired if needs be)

Anyway, after all that, my point is that your problem with this 
application that you mention is unlikely to due to the fact that it is a 
Fusebox framework application and more to do with shoddy workmanship.  
You should have been able to add a new circuit for your new 
functionality and simple change a few display templates in order to add 
the appropriate links to the new actions in your new circuit.
Fusebox really is just a simple hub/spoke procedural framework at the 
end of the day.

Other than that, I agree with a lot of what you've said.  Other than for 
code re-use, I still don't quite understand why OO is being forced onto 
a concept that is inherently procedural.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185671
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: cfstoredproc and cfdump

[Stephen Moretti (cfmaster)]

Ian Littlefair wrote:

Thanks Adam. Could you be a bit more specific please?
  

If you output searchResults.columnlist after you've called your stored 
procedure it should give you the list of columns returned. 

However, from your cfdump I would hazard that the column names will be 
:B1 and P_Key. You might want to look at your SP to get it to return 
your flag column in a valid column name, say something like login_flag

Hope that helps

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185696
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: cfstoredproc and cfdump

[Stephen Moretti (cfmaster)]

Stephen Moretti (cfmaster) wrote:

Ian Littlefair wrote:

  

Thanks Adam. Could you be a bit more specific please?
 



If you output searchResults.columnlist after you've called your stored 
procedure it should give you the list of columns returned. 

However, from your cfdump I would hazard that the column names will be 
:B1 and P_Key. You might want to look at your SP to get it to return 
your flag column in a valid column name, say something like login_flag
  

Oh! Meant to say.

You should still be able to access that :B1 column inside a 
cfloop/cfoutput, like this : searchResults[:B1]

Stephen


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185698
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: CFMODULE vs. CFINCLUDE

[Stephen Moretti (cfmaster)]

Michael Dinowitz wrote:

I'm rewriting Raymond's Lighthouse Bugtracker (not my idea) and one piece
bought up an old question I had. Is there any performance difference between
a CFMODULE acting as a layout wrapper or 2 CFINCLUDE templates with layout?
In the first case, your code is:
cfmodule template=layout.cfm
Display stuff
/cfmodule

In the second  case you have:
CFINCLUDE template=header
Display Stuff
CFINCLUDE template=footer

Because of the nature of the CFMODULE, it's called twice and various
variables are created in its process. The CFINCLUDE method uses 2
CFINCLUDES, but there's nothing special about them. No extra variables, etc.

Logic says that the CFINCLUDE method of template layout is more efficient,
but I'd like to know what others think? 

I'll ask the question about what people think of the pagecontext include vs.
cfinclude another time. :)
  

If I remember correctly, doesn't cfmodule create a whole new memory 
block for every call, where as the cfinclude will only use the existing 
memory space and be part of the normal page cache?

Even if this isn't true for CFMX any more, personally, I'd probably lean 
towards the cfinclude method, because
a) thats what I'm used to,
b) I find it visually easier to read
c) I feel like can tinker with the header and footer dynamically 
with a cfinclude than a cfmodule.
andd) Easier to get to the header and footers if I need to change 
them or simply replace them.

What goes on inside the the cfmodule?  Is the header and footer actually 
inside the cfmodule template or does it include the header and footer 
templates?  If it includes them, then it'd be a bit of a pointless call 
to the cfmodule, if its in the cfmodule template, then refer to my point 
(d) above. ;)

Stephen


~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185701
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: What causes this error?

[Stephen Moretti (cfmaster)]

Mike Kear wrote:

Thanks for your help Stephen.  I dont have access to the logs, so I
dont know.   I was hoping to send a message to the Sysadmin saying we
are getting this error, here's what we need to do to fix it    

He tends to just reboot when we get an error, which often makes the
immediate problem go away, without removing the underlying causes.
  

Nightmare.

To be honest the error is a bit general.  Whats happened is something 
has knocked CFMX for six, but without investigating the contents of the 
logs for the websites, CFMX and the OS logs on the server it would be 
hard to say whats has caused this.

See if you can get the logs out of your hosts and do a bit of investigation.

BTW - restarting CFMX will more than likely suffice rather than 
rebooting the whole server.

Sorry that this doesn't really help. 

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185420
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: Need to encrypt cfm output

[Stephen Moretti (cfmaster)]

Jon Austin wrote:

This is a fallacy; the client's browser need to see plain text or it
will never be able to render the HTML! (SSL being the exception - the
browser knows how to handle it)

What you are doing is actually 'encoding' the HTML sent to the client;
this is at best obfuscation and will not stop someone who is
determined.
  

This is exactly what html guardian does.  All it is is a couple of line 
of code that applies an increment/decrement to each character code to 
output as a string to the browser.  In the browser is a javascript 
function that takes this string and reverses the changes to the 
character codes.  It add some very simple javascript to prevent right 
clicking (also encoded by their function).

It would be pretty easy to pipe all the out from an application into a 
variable and then do this sort of thing to the contents of the variable 
as the last action in a template  
(onRequestEnd.cfm/app_layout.cfm/whatevertakesyourfancy.cfm)

Be aware, that this type of application requires that site users have 
javascript enabled and is easily reverse engineered in about 10 minutes, 
which is what I just did to be able to give this response.

Regards

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185422
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: What causes this error?

[Stephen Moretti (cfmaster)]

Mike Kear wrote:

What causes this error, on a production server that's been working
fine for months -  no structural changes, no new software added, only
site updates done .

[quote]
Server Error
The server encountered an internal error and was unable to complete
your request.
Could not connect to JRun Server.
[/quote]

Anyone know ?

Could be anything

Is there anything in the logs? CF and Windows?

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185417
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: Week() and DayOfWeek() issues

[Stephen Moretti (cfmaster)]

COLLIE David wrote:

Seems that it reports correctly in CF5... But doesn't on CFMX Anyone
got any ideas what gives with this?
  

Probably something to do with Java and the calculations that are being 
done - he says guessing.

If you fancy writing your own functions this link should be useful : 
http://snipurl.com/iso_week_number

Regards

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185305
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: Backup MySQL DB... and restore ;-(

[Stephen Moretti (cfmaster)]

Marco Antonio C. Santos wrote:

Hi all

I want to backup my database to a file that is just like a SQL dump.
With mysqldump I can do that. Easy. Then, I just want to be able to
execute that .sql file when I need to restore my database... with
CF... What do you think about?
  

Aside from using mysqldump, you could also get the freebie version of 
sqlyog 4.0.  I have to be honest and say I haven't looked at it that 
much, but it does look very nice!  Much nice than the pervious versions 
I've got kicking around here.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184576
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: Macromedia gives up on the server market in Australia and walks away.

[Stephen Moretti (cfmaster)]

I LOVE CF but Macromedia need to plan on Total Global Coverge,
besides.. I recon a few Macromeedies from London wouldnt mind spending
a stint in Oz ;)
  

~lol~ You know there aren't that many MM employees in the UK any more (I 
think its 3 now) and I believe one of those is an escapee... errr I mean 
Australian anyway. ;oD 

Steal some of the american staff instead. ;op




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184578
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: ODBC error I can't explain

[Stephen Moretti (cfmaster)]

James Smith wrote:

I am reading an excel file with an ODBC query and I am getting the following
error.

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel
Driver] Too many fields defined. 

Can anyone explain this error, I am not sure why I am getting it.
  

There is a limit to the number of columns you can have in a query.  
Chances are the driver thinks that the query is returning the maximum 
number of columns an excel spreadsheet can have, which I think is some 
thing like the magic 65535 number. I think you are looking at a maximum 
of 256 columns in a query.

Make sure that you have ranges and columns defined in your spreadsheet 
to make sure that there are specific tables and columns to query.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184368
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: ODBC error I can't explain

[Stephen Moretti (cfmaster)]

Robertson-Ravo, Neil (RX) wrote:

Should be fairly self explanatory...you are passing too much information to
the Datasource - it is expecting say 10 fields of data and you are passing
it 11.

Perform a data mapping to see what you should be passing.
  

Wrong way around Neil.  He's querying the spreadsheet not writing to it.


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184371
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: ODBC error I can't explain

[Stephen Moretti (cfmaster)]

James Smith wrote:

That would be my interpretation of the error as well, however the sheet only
has 1 column and that column has only 2956 records.

Any other ideas?
  

Still sounds like that is the problem.  Although when you look at the 
spreadsheet it only has one column with data in it, excel has a nasty 
habit of saying all these x columns are actually in the spreadsheet, but 
empty.

I can't remember exactly how the excel jdbc connector works, but 
couldn't you do a select COLUMN from spreadsheet, rather than select * 
from spreadsheet? 

Do you really need it to be an excel spreadsheet?  If this is part of a 
manual process, can you save it out as a CSV and use that instead?

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184375
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] reading response headers with javascript

[Stephen Moretti (cfmaster)]

Critter wrote:

and perhaps.. can you shed a little more light on the process...
perhaps a point in the right direction.. an example.. something that
would be a bit more valuable than your previous answer?
  

Would you care to expand on exactly what it is that you are after, so 
that a more useful answer can be given?


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184389
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] reading response headers with javascript

[Stephen Moretti (cfmaster)]

Dave Watts wrote:

Server: Microsoft-IIS/5.0
Date: Tue, 16 Nov 2004 16:20:06 GMT
Set-Cookie: CFID=56888;path=/
CFTOKEN=15399655;path=/
gplResponse: -117.769469|33.721224|-117.759359|33.730204|8
Content-Type: image/jpeg
Connection: close

was trying to access the gplResponse variable...



I don't think you're going to be able to do that. Why not just have the
server write this as a cookie?
  

I have to agree.  There are a number of response headers that make it 
into the various javascript DOM, but I don't believe that they are 
generally and universally made available in the client.

Having said that, a number of references to XMLHttpRequest hinted that 
maybe it is possible to access response headers from the client.  Until 
I found this page (http://www.mozilla.org/xmlextras/) I thought it was 
all IE specific (and generally written using some server side code).  
The examples given would need some browser checking to load the 
appropriate XMLHttp... object, but it might do what you need.

Hope that helps.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184412
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: ERD for MySQL

[Stephen Moretti (cfmaster)]

Mark Drew wrote:

Does anybody use any fornt ends to mysql that allow you to do ERD's in
the way the MS SQL Enterprise Manager works?

Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data
Studio et al), but something that I can visually design the tables and
relationships with .

If its for OS X the better!
  


I use Charonware's CASE Studio. (http://www.casestudio.com)
Its not the worlds greatest ERD modelling tool, but for your money it 
does the job nicely and has reverse engineering tools as a bonus.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184251
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: A Quick cry for help, figured you guys have probably seen this...

[Stephen Moretti (cfmaster)]

Jeff Small wrote:

We have a development database running on a little windowsXP Pro machine 
that's hummed along quite nicely. Then today, we ran SP2 because we did a 
monthly reboot and it reminded us. We didn't change any settings and when it 
came back up we just cut off the Windows Firewall, the Virus checker, etc 
thinking, well, we'll just cut it all off. We really didn't fear it 
because this little machine does *one* thing...run SQL server in-house for 
testing and development.

Now the server running CF is throwing errors and all the SQL server 
datasources that are normally pointing at the IG-SQL (Interactive Group 
SQL...clever, eh?) and working are all being refused with the following 
error:
  

This should help I think.

http://www.winnetmag.com/SQLServer/Article/ArticleID/42854/SQLServer_42854.html

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184315
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: ActiveEdit4.0 demands money from firefox users

[Stephen Moretti (cfmaster)]

Mike Kear wrote:

Is anyone else finding this?  We have fully licensed ActivEdit4.0 but
FireFox users calling the page with the ActivEdit control get a
messages saying they've tried to use an unlicensed copy of ActivEdit.

If they click away the warning, they go back to the page and have the
control there, but can't edit.

If they click OK, they are taken to the ActivEdit page and asked to pay 
money.

huh?  I thought it was US -the site owners who had to pay, not the site users.

  

HTMLArea 3 - http://sourceforge.net/project/showfiles.php?group_id=69750
TinyMCE - http://tinymce.moxiecode.com/

Both free
I use HTMLArea, which is easy to use and works in nearly all browser, 
but has a few bugs.
TinyMCE seems to have received rave reviews recently, but I've yet to 
try it out.

Not the answer you really wanted, but thought I would pass on this info 
having used ActivEdit and soEditor and moved on.

Stephen

-- 
Registration for MX Europe 2005 is now open. 
http://www.mxeurope.org/go/registration

Early bird discounts available.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183842
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: Primary Key Justification

[Stephen Moretti (cfmaster)]

Keith Gaughan wrote:

Claude Schneegans wrote:
  

I can see for having the whole record as the primary key is to save space. 
Adding an extra column to store a primary key
requires the space to store it and the storage for the sequence.



Not even, you may save the space of an integer key in the table, but think 
about the index!

  

But there's no sense if saving space like that when you need a whole 
tuple to do a lookup.

I think that was the point.

-- 
Registration for MX Europe 2005 is now open. 
http://www.mxeurope.org/go/registration

Early bird discounts available.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183759
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: [Fwd: [CF-Dev] MX Europe 2005 Registration Open - Get your Early Bird tickets now!]

[Stephen Moretti (cfmaster)]

Thomas Chiverton wrote:

On Thursday 04 Nov 2004 19:08 pm, Stephen Moretti (cfmaster) wrote:
  

http://www.mxeurope.org/go/registration



Host does not resolve.

Looks like you have a dns problem. The domain and site have been up for 
quite some time and I'm not aware of anyone else reoprting not being 
able to reach the site.


-- 
Registration for MX Europe 2005 is now open. 
http://www.mxeurope.org/go/registration

Early bird discounts available.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183487
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: [Fwd: [CF-Dev] MX Europe 2005 Registration Open - Get your Early Bird tickets now!]

[Stephen Moretti (cfmaster)]

John Beynon wrote:

there does seem to be a problem - it worked yesterday but doesn't work
today. I'll shoot the guys that look after it an email,
  

hmmm weird - I've been tidying some of the content up today and can 
still get to it, but yes there does seem to be a problem.  checkdsn.net 
is saying it can't find it either.

Niklas is away, but if you know who's hosting it then please do shoot 
them. ;)

regards

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183496
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: Bluedragon Server

[Stephen Moretti (cfmaster)]

Calvin Ward wrote:

While that may be true, it seems probable the the release of Blackstone will further 
create a gap between actual CFMX and BD
  

Of course, this is pure speculation.  Speculating here myself, because 
I'm not on the beta test, but I would not be surprised if MM shortened 
BDs list of enhancement by adding that functionality to Blackstone and 
the list of incompatibilities didn't really increase that much.

Plus how many people will actually upgrade to Blackstone?  Yeah there 
will be the die-hards that go with every upgrade and the luck ones who 
will be handed Blackstone on a plate, but currently I'm still on CF5.  
Clients dictate upgrades.  I personally can't justify the expense of 
upgrading to CFMX, as much as I'd like to, and most clients have no 
requirement for for some of the additional functionality provided by 
CFMX.  Again, as much as I'd like to look into building apps with the 
likes of Mach-II, I can't justify upgrading to CFMX purely for this reason.

I know someone who, until very recently, was still running cf4.5.2, 
because he had no requirement to upgrade and only upgraded recently, 
because he moved/upgraded his servers and felt that it was an 
appropriate time to upgrade CF too.

At the end of the day, it comes down to your requirements and the 
requirements of your clients. Personally, I don't use BD.  I have used 
BD in the past, back in the alpha testing days. It looked great and held 
a lot of promise back then, but wasn't production ready, so I had to go 
with MM CF.  Since then I've, unfortunately, never had the requirement 
to look into using it.  If and when the opportunity arises, then I will 
definately be looking at BD in detail as well as at MM CF Server.  If it 
meets the requirements of the project that is paying for it and is cost 
effective, then I will go with it.

What a developer should never do is chose not to use an alternate 
product, because it isn't the original.

hmm... sorry that turned into a bit of a rant  I'll go back to my 
dark corner now...

regards

Stephen
PS.  http://www.mxeurope.org/  - Registration is open!! 
The list of speakers and topics looks to be excellent.


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183389
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

[Fwd: [CF-Dev] MX Europe 2005 Registration Open - Get your Early Bird tickets now!]

[Stephen Moretti (cfmaster)]

Forwarded from the UK Dev list.

---
Hi Everyone,

Registration for MX Europe 2005 is now open. 

http://www.mxeurope.org/go/registration

If you register before the 30 November 2004 you will be eligible for Early Bird 
pricing and will save £50 on the standard conference ticket price. Register today to 
ensure you do not miss out on this fantastic offer.

Regards

Niklas


About MX Europe 2005


MX Europe is a yearly European Macromedia Developer Conference organised and run by UK 
ColdFusion User Group.  For our third year, MX Europe 2005 will be held in London from 
the 31st January to the 2nd February 2005.

The conference is the ideal way to concentrate all the knowledge from the US and 
Europe - without having to take expensive Atlantic flights across to America, worry 
about visa requirements and the like.

The event features numerous workshops on Flash Design, ColdFusion Development, Server 
Management, User Interfaces, Mobile Devices and Web Development Solutions.  The 
conference program is designed to enable emerging and seasoned developers extend their 
skill sets and expand their knowledgebase.

In addition to in-depth technical and designer sessions, the MX Europe 2005 Conference 
also includes a Sponsor Exhibit area which is open from registration on Monday to 
close of conference on Wednesday.

You will also have the opportunity to meet the European Macromedia team, speakers from 
the US and Europe and all the developers and designers who use Macromedia technology.

-- 

Registration for MX Europe 2005 is now open. 
http://www.mxeurope.org/go/registration

Early bird discounts available.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183395
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: Forcing text to wrap in table cell

[Stephen Moretti (cfmaster)]

Allan Cliff - CFUG Spain wrote:

What if you live in
Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ?

- Original Message - 
From: dave [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 10:05 AM
Subject: Re: Forcing text to wrap in table cell


  

and the british have
supercalifragilisticexpealidous


-- Original Message --
From: Thomas Chiverton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Wed, 3 Nov 2004 08:46:43 +



On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
  

Well if the longest word in the English language is 28 chars...


Not by a long shot.
  

http://www.fact-index.com/l/lo/longest_word_in_english.html



~|
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:183238
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: SPAM-BULK: Forcing text to wrap in table cell

[Stephen Moretti (cfmaster)]

Hugo Ahlenius wrote:

|-Original Message-
|From: Bert Dawson [mailto:[EMAIL PROTECTED]
|The simplest solution is not to worry about it, though without
|knowing more details i can't say whether this is an option.
|Who is going to be entering a big string with no whitespace?

A URL is a common case for that:
http://www.macromedia.com/cfusion/exchange/index.cfm?catid=0snid=sn131
itemnumber=18extid=1007786catid=0#loc=en_usview=sn130viewname=coldf
usion%20exchangecatid=0snid=sn131itemnumber=18extid=1007786viewName
=Macromedia%20Exchangeavm=1
  

Ah yes, but that won't push the td out if its in a valid a href tag 
and I would hope that it would be anchored to a meaningful bit of text 
eg. Resource Bundle CFC, which should wrap nicely, as long as the td 
isn't like 10 pixels wide or something silly like that.

Does anyone know of a good way to make sure that long text doesn't stretch a table 
cell?
[snip]
Anyone have a simple solution?
  

Will, your best solution is probably moderators and administrators, but 
failing that *Antidisestablishmentarianism is the longest word in 
English at 28 characters, if you discount medical and chemical names 
(which are generally Latin anyway), so you could always dump anything 
over 28 characters and call the user rude names at the same time.  Of 
course this will only work if the text doesn't have html in it.

Hope that helps

Stephen
***


~|
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:183107
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: Urgent:coldfusion loging

[Stephen Moretti (cfmaster)]

vishnu prasad wrote:

Hi CF gurus
Is it possible to backup all the coldfusion mx logs to some other directory and then 
delete the orginal file 

i mean i want to move all the coldfusion mx log file to another directory ,so that 
coldfusion log fill will have only the current date log detail
  

Each log file has an archive button in the CF Administrator.  Just press 
that and the log will be renamed with a number appended to the end.

Stephen


~|
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:183109
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: Homesite - disabling Browse feature and Edit/Browse tabs?

[Stephen Moretti (cfmaster)]

Damien McKenna wrote:

Patrick Hardy wrote:
  

View - Ressource windows, just uncheck everything!


Actually, I meant the Edit/Browse tabs, I'd like to only have the Edit window and not 
see the tabs above them.
  

I'm not sure that you can.  They aren't a massive annoyance and removing 
them will only give you one extra line of code. Do you really need them 
gone?


~|
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:182921
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: editors, back to HomeSite+ for me

[Stephen Moretti (cfmaster)]

Spike,

Why did you give up on it?

At the minute we're trying to look at ways to make transition to 
cfeclipse simpler. Anyone who has tried it and no longer uses it can help us in that 
respect, so your comments would be appreciated.

I quite like cfeclipse, but there were two major stumbling blocks for 
me.  The first is an absolute killer. The only FTP plugin that is 
available for eclipse just isn't 'there' yet.  Its flakey, undocumented 
and appears not to be getting much in the way of development attention, 
but looks like it would be an excellent synchronisation tool in place of 
the sync tool in DWMX.

The second reason is simply that I use the wsiwyg view in DWMX way too 
much.  If I was a straight code monkey, not having to deal with designs 
too much or anything like that, then I would be using cfeclipse, but I 
use the design side of DWMX too much and switch tools all the time is a 
pain.

I have to say, I did find myself desperate for the to do list/notepad 
functionality from eclipse in DWMX the other day.  Too many threads and 
no where easily visible to make a note of them. :)

For anyone that hasn't had a look at eclipse/cfesclipe recently (ie. 
since the release of a stable version 3) go take another look.  eclipse 
3.0.1 is considerably better and nicer to use than version 2.x.

Stephen



~|
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:182939
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: Variable Session scopes

[Stephen Moretti (cfmaster)]

Carl V wrote:

What is the best way of creating variable session scopes called from a global vars 
page without CF chucking errors..

global vars page
cfscript
 request.sessionVar = mySite; // This changes across the mini sites
 request.dbsitePrefix = test;
/cfscript

Application.cfm Page - and yes sessionmanagement is on  
cfif Not IsDefined(SESSION[request.sessionVar])

cfscript
SESSION[request.sessionVar] = StructNew();
SESSION[request.sessionVar].USERNAME = ;
SESSION[request.sessionVar].OBJECTID = ;
SESSION[request.sessionVar].USER_LOGGEDIN = false;
SESSION[request.sessionVar].Agree = False;
/cfscript
/cfif
  

Its probably worth copying your session variable to a local variable, so 
that you don't keep hitting the session and to make it easier to access 
your variables.

request.thisSession = duplicate(session[request.sessionVar]);

This way your login references will be 
request.thisSession.Username/ObjectID/user_LoggedIn

You will need to remember to copy the thisSession variable back into 
session[request.sessionVar] at the end of the request, just in case any 
changes were made.

Hope this helps

Regards

Stephen


~|
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:182792
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: Web Services problem

[Stephen Moretti (cfmaster)]

Will Tomlinson wrote:

I'm learning about using Web Services and I'm getting an error that doesn't make 
sense. Maybe someone could shed some light on the problem? 

I'm using a CFC to simply retrieve some zip codes from a db. 

cfcomponent
   cffunction name=myFunction access=remote returntype=query
   cfset getzips =
   cfquery name=getzips datasource=#DSN# maxrows=20
   SELECT zipcode FROM tblzipcodes
   /cfquery
   cfreturn getzips
   /cffunction
/cfcomponent


Then I'm invoking it using this:

cfinvoke webservice=http://www.wtomlinson.com/queryCFC.cfc?wsdl; method=myfunction
returnvariable=returnedquery
/cfinvoke

cfoutput query=returnedquery#zipcode#br/cfoutput


It seems to work fine if the invocation is on my server, but when I have someone to 
place it on their server to call my web service, there's an error:

http://gtcc-it.org/web-service.cfm

Could not generate stub objects for web service invocation.  
Name: http://www.wtomlinson..com/queryCFC.cfc?wsdl. WSDL: 
http://www.wtomlinson..com/queryCFC.cfc?wsdl. java.net.UnknownHostException: 
www.wtomlinson..com: www.wtomlinson..com It is recommended that you use a web browser 
to retrieve and examine the requested WSDL document for correctness. If the requested 
WSDL document canapos;t be retrieved or it is dynamically generated, it is likely 
that the target web service has programming errors. 
  

You've got a typo in your code.

cfinvoke webservice=http://www.wtomlinson..com/queryCFC.cfc?wsdl;

You've got a double full stop in domain name.

Regards

Stephen




~|
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:182795
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: Web Services problem

[Stephen Moretti (cfmaster)]

Scott Stroz wrote:

The 'wtomlinson..com' is showing up in the error message, not from his
code (or at least the code he posted here)

I copied his code right from his post into a page and it worked.
  

Yep - so he's got a typo in his code on that remote server that has been 
introduced after he created the original code and tested it on his server.


~|
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:182827
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: Odd errors - only sometimes

[Stephen Moretti (cfmaster)]

Foye Troute wrote:

  I am working on some new pages and am getting very odd errors. Odd because
they seem to be browser dependant. On my development system (XP ProSP2 with
CFMX.)I don't see the error. On a laptop with XPHomeSP2 I don't see the
error. On a laptop with Win2000 I see the errors.
 
The page is on a production system at:
http:www.waterfront-properties.com/agents.cfm?curragent=3 This is a results
page normally called from a form. Works from a URL also.
 
The error is:
Internet Explorer Script Error.
An error has occurred in the script on this page.
'_CF_checknew_all is undefined'
followed by a second error
'startms' is undefined

The problem is your CFFORM.

FORM NAME=new_all.cfm METHOD=POST onSubmit=return _CF_checknew_all.cfm(this)

You have the action in the name field of the form and no action.

You don't actually make use any of the benefits of CFFORM, so I would 
suggest changing your cfform to an ordinary form tag and any CFINPUTs to 
ordinary INPUT tags.

This would give you :

form name=yourformname action=new_all.cfm method=post
formfields in here
/form

Regards

Stephen


~|
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:182487
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: Odd errors - only sometimes

[Stephen Moretti (cfmaster)]

Foye Troute wrote:

Thanks Stephen, you were right on. I must have read thru that a dozens times and 
never saw it.

That solved I can now go back and clean up some of the code and do a few tweaks.

Thanks again.
  

No problem.  Fresh eyes alway help.

Just so you know.  The javascript function in the top of your page was 
generated by CFFORM.  Its created to handle the validation functions 
that are a part of the cfinput tag.

Regards

Stephen


~|
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:182496
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

[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: OT: Switching domains with IIS

[Stephen Moretti (cfmaster)]

Rick Root wrote:

 Hi folks.. We are going to be changing our fully qualified domain name
 from www.ads.duke.edu to www.it.dev.duke.edu ... Right now, you can use
 both domains but the url doesn't change... I'd like for *ALL* requests
 to www.ads.duke.edu to be re-written to www.it.dev.duke.edu so that
 we are consistent in our use of the new domain.. but we don't want to
 screw up people's bookmarks...

 We're using IIS 6.0

Just create a new site for the old domain that redirects to the new 
domain.This can all be done in IIS - the redirect is under the home 
directory settings.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: no end date

[Stephen Moretti (cfmaster)]

Daniel Kessler wrote:

 I have a calendar of events.All events have a start date/time, but
 many of them don't have an end date/time.I can work around this by
 setting an obviously incorrect end date and checking for it (i.e.
 12.17.66, my wife's birthday).However, I'd prefer to not set a date
 if there isn't one and check for that instead.

Is it likely that if there isn't an end date, it is because the end date 
is the same as the start date?

If this is true, why not simply insert the same date into start and end 
date?
It'll make it easier when you need to know all the events that end 
between two dates :)

Regards

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Hot-fixes

[Stephen Moretti (cfmaster)]

  But on development systems I install everything.

 But then your development environment and production environment are
 different. So if you create something that works in the development
 environment it might not work in the production environment.

Which is why you should have a staging server that replicates the 
production server.

;)

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Hot-fixes

[Stephen Moretti (cfmaster)]

John Beynon wrote:

 I just have Firefox configed to watch the hotfix page
 (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm)
 for changesworks for me,

Ooo... which extension is that?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Looping....again

[Stephen Moretti (cfmaster)]

dave wrote:

 i think 1st thing to do is run a script to get rid of all the quotes

 probably use the replace function

Not neccessary Thats what the textdelimiter attribute of CFHTTP is for.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Looping....again

[Stephen Moretti (cfmaster)]

Brant,

 My CFX_PDF tag don't work inside the loops though :-( so I think I am 
 gonna
 have to go back to trying to build this data into another set of DB 
 tables,
 but each drug given a script number so that I can then query the data 
 based
 on the doctors name, and then build the scripts again, but with a less
 complex looping structure, so as to be able to include the cfx_pdf tags.

OK - Here's a suggestionYou'll have to have a play to work out the 
best way to do this...

Use CFSAVECONTENT to save the output from the cfloop through the data 
and then pass the contents of the cfsavecontent variable to your CFX_PDF 
tag after the end of the loop.

 As I have stated, I think I need to get this data back into a DB 
 table, and
 mark each drug to belong to a unique script number?

 The doctors can then logon, and I can again run a query of querys to 
 get the
 data out.

If thats the case, then youneed only do a simple loop through the 
query generated from the CSV file and insert each record in turn into 
the database.When you insert each record you are going to want to 
split the data into multiple tables, one for the patient, one for the 
medication and one to link the paitent to the medication along with the 
other information specific to that item on this patients script. ie. 
pdocpresno, sqty,srpts etc.NOTE. It may not be feasible to spilt 
the medications out into a seperate table, so one table for patient and 
one for script rows will suffice.

When a doctor logs in, give him a means to search for and select a 
patient, then you need only query the database for that one patient and 
their script records.When you output the data for cfx_pdf you will 
still need a loop much like the one I or Pascal created for you, to make 
sure you only get 3 lots of medication on a script.

Which ever way you do this, don't bother inserting everything into a 
struct/array and then inserting it into a database or outputing it to 
cfx_pgp.Its just another brain drain and loop that isn't really required.

As a total aside:Remember that you are storing personal information in 
a database.You will need to make sure that the practice's Data 
Protection subscription allows you to do this.If you are, then 
security of this data is of absolute paramount.

Hope this all helps

Regards

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Looping....again

[Stephen Moretti (cfmaster)]

Brant Winter wrote:

 Dave - I assumed it would involve some complex looping to work out which
 drugs below to the same patient on the same day etc etc.

 I am using the following code to generate a query object from the CSV 
 file:

 cfhttp url="" name=qGetData method=GET
 timeout=20 delimiter=, textqualifier=/cfhttp

Brant,

I think like Dave says - you're going at this BAB...Don't try and 
create seperate structs and arrays for all this data, just leave it in 
your query, but reorder the data using QofQ into something that helps 
with the output.

cfquery name=sortedPatients dbtype=query
SELECT * FROM qGetData
ORDER BY Medicare, LastName, FirstName
/cfquery

Then you have a straight loop of medication by patient and all you have 
to do is split them into scripts.

cfset prevmedicare = 0
cfset medcount = 0

CFLOOP QUERY=sortedPatients
 cfif prevmedicare neq sortedPatients.medicare
 cfif sortedPatients.currentrow NEQ 1
 !--- Output script Footer, if I'm not on the first record ---
 /cfif
 !--- new patient ---
cfset medcount = 0
cfset prevMedicare = sortedPatients.medicare
!--- Output scriptheader ---
 /cfif
 cfif variables.medcount eq 3
cfset medcount = 0
 !--- Output the footer of script ---
 !--- Output the header of next script for this patient ---
 /cfif
 !--- Output single row of the script ---

 cfset medcount = IncrementValue(medcount)

 cfif sortedPatient.recordcount eq sortedPatient.currentrow
 !--- See if this is the last record and output a script footer if 
it is ---
 /cfif
/CFLOOP

Clear as mud??

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Looping....again

[Stephen Moretti (cfmaster)]

dave wrote:

 actually Stephen he doesnt have this in a db yet, hes getting it from 
 a csv file then trying to do all that.

Doesn't matter He's loading the CSV into a query using CFHTTP. ;)


 personally, i think he should break it down, put it in the db then do 
 just like u showed.

 but his problem is that this csv file is a friggin mess (i think) and 
 hes trying to get to clever with the code. But the csv file is 
 generated by a pharmacys software program which means he probably has 
 no control over how its made.

Doesn't really matter as long as each row is in the same format you can 
load the csv into a query using cfhttp. ie. each row is : medicareno, 
firstname,lastname,medication,quantity,description

Once you've loaded the CSV into a query, you can then use Query of Query 
to reorder etc etc without the overhead of having to insert everything 
into a DB and then requery everything out of the DB.


 i'd say get the csv  rip it out 1 line at a time, get the info for 1 
 line (1 record), break the line down  insert it to the db then delete 
 the line and loop it.

Don't need to.CFHTTP will take the first line as the column names for 
the query it generates and insert the rest of the CSV data into the 
query, as long as there are no data errors of course.If there are 
errors in the data, its not going to matter if you load it into a query 
using cfhttp or parse the contents of the csv into a database, it will 
still fail.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Looping....again

[Stephen Moretti (cfmaster)]

dave wrote:

 i didnt know it loaded into a query, see i told ya i dont know jack 
 (least im tryin)
 we havent seen the csv yet though, if i recall it looked like

 name blaha lala

 are u sure? doesnt seem right to me

Yep - sure...

cfhttp
 method=GET
 timeout=20
 url="" gets the file with a 
timeout of 20 seconds
 name=qGetData --- Sets the name for the query that the CSV will 
be loaded into.
 delimiter=, --- says that each column will be seperated by a comma
 textqualifier= / --- says that double quotes will be used to 
delimit text columns

There is an attribute called columns which you can put a comma 
delimited list of columns that will be used when the query is 
generated.However, by default, cfhttp will take the first line of the 
file and use this as the columns.

You could have used this method with the water data that you used in 
your example, if they had put the data description seperate from the 
data and they hadn't put a row of bad data below the column headings, 
before starting the actual water data.

Regards

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: HTTPS Upload of a file.

[Stephen Moretti (cfmaster)]

James Smith wrote:

 I am trying to upload a file from CF to a remote server.I have no direct
 access to the remote server as it is owned by a third party.

Are you saying you are trying to push a file from your CF Server to 
a.n.other server?

If so, you're going to need FTP access or some other form of access to 
this server, like a file upload form. If you have FTP access, then 
CFFTP.If you have a file upload form under SSL, then take a look at 
cfx_http, as I think CFHTTP has problems with https, but of course 
that's only going to work if you can get the local file name into the 
file form field.

Basically, it comes down to needing to know what interface you actually 
have to upload this file with before being able to tell you what you can 
use or need to do.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: CF_TwoSelectsRelated and Passing Variable

[Stephen Moretti (cfmaster)]

hammerin hankster wrote:

 I'm using the CF_TwoSelectsRelated custom tag (which works great), and 
 I'm trying to pass the variable of the dynamically selected variable 
 from the 2nd drop-down box to a second form on the page.Can't figure 
 out how to do this.Here's the CF_TwoSelectRelated tag:

There's no passthrough variable in 2selectsrelated to allow you to pass 
the selected value in the second drop down and send it to the second form.

Why not use one form? It doesn't look to me that the second drop down 
would be related to the site id drop down on the second form and that 
you actually want to pass the selected values from the 2SelectsRelated 
and the siteID through on form submission.If this is the case, then 
the code below will work fine.

FORM name=DateForm ACTION="" METHOD=POST 
 require_Selected();
input type=HIDDEN name=occname value=#form.occname#
TABLE border=0 cellspacing=1 cellpadding=1 width=500
tr
 td
CF_TwoSelectsRelated
 QUERY=readocc
 NAME1=clientitd
 NAME2=occupantid
 DISPLAY1=clientname
 DISPLAY2=occname
 VALUE1=clientid
 VALUE2=occupantid
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 SIZE1=1
 SIZE2=1
 HTMLBETWEEN=BR
 AUTOSELECTFIRST=Yes
 EMPTYTEXT1=(Choose a Client)
 EMPTYTEXT2=(Choose an Occupant)
 >
 FORMNAME=MyOtherForm
 /td
/tr
tr
 tdSite ID:/td
 tdselect name=siteid
cfoutput query=readsiteinfo
 option value=#siteid##siteid# - #sitename#
/cfoutput
/select
 /td
/tr
/table
/form

Regards

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Looking for a thread

[Stephen Moretti (cfmaster)]

Trevor Holm-Laursen wrote:

 Hey everyone.I deleted an email by mistake from a thread and can't 
 seem to
 find it on the search.It was a thread on passing the form scope to a cfc
 method as an argument and was just in the last couple weeks.Any help to
 find this would be great.

http://www.houseoffusion.com/ is your friend ;)

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Web/RAD Software Tools Solid CF Code

[Stephen Moretti (cfmaster)]

[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:

 Anyone here succesfully use any Web/RAD tools to build online 
 applications.

 I have delved into looking into some UML tools - but most start at $15k +

Have you had a look at Synthis' Adalon?http://www.adalon.net/

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Javascript submit button vs html submit button

[Stephen Moretti (cfmaster)]

Mike Kear wrote:

 How true is the following statement? :

 [quote]

 If you use a _javascript_ form submit button, you have to make sure your
 form variables dont get too large because the _javascript_ function
 passes the input to the action page using the GET method, and the
 total length of a URL and all the URL Variables is limited.If you
 have a very large amount of form input, you had better use HTML submit
 buttons and the POST method

 [/quote]

 Is this true? 

Its only half true.

Yes with GET type form submission you do need to ensure that the number 
of variables and their values does not exceed the maximum length for a 
URL (128 characters I think...don't quote me)

_javascript_ submission of pages need not be a GET submission.It can 
also be a POST method. This is determined by the FORM tag and not the 
way that it is submitted.

Its brought about by an application I'm working on
 where we might have a hidden form field with as many as 40,000 userIDs
 passed to the action page in a comma delimited list.

Ummm... eek!Would it not be better to provide a single reference to 
something the DB that allows you to pick out those IDs rather than 
passing them around on a page?

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Basics Clarification

[Stephen Moretti (cfmaster)]

Steve Brownlee wrote:

 We've all said it a million times - don't use the hashes inside a CF 
 tag that
 processes on its own.

 !--- No no no ---
 cfif #check# eq 1

 But one thing I've always wondered is why.I know doing this is wrong 
 from
 years of seeing people scream at developers who do it, but I never 
 heard an
 explanation as to what problems this causes.Anyone know the guts behind
 this?

Originally you had to do your cfifs this way back in version 2 land.

Basically what you are saying here is :

I have a command CFIFinside that command I have a variable called 
check that I need to insert the value it contains into the cfif and then 
check it against the value on the other side of the operator.

cfset check = 12
cfif #check# eq 1
becomes
cfif 12 eq 1
becomes
false

What you are doing is adding an extra stage of processing to the cfif, 
rather than just saying compare the variable check against the value 
on the other side of the operator.

cfset check = 12
cfif check eq 1
becomes
false

Plus it looks dreadful and makes your code hard to read.

Stephen
PS. It may not may the slightest difference in CFMX, but it still looks 
awful!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Basics Clarification

[Stephen Moretti (cfmaster)]

Dave Watts wrote:

  Originally you had to do your cfifs this way back in version 2 land.

 Well, actually, I'm pretty sure that they weren't even needed then. 
 However,
 no one had really figured out appropriate usage for them yet.

I think you're probably right.I vaguely remember there being some 
times that you had to use hashes around variables in conditions, but, it 
is so long ago now, who knows or even really cares. ;)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Amazon AIMS

[Stephen Moretti (cfmaster)]

James Smith wrote:

 Has anyone here managed to get Amazons AIMS system working with 
 ColdFusion?
 I am pulling my hair out over this and Amazon are unable to help.

 I someone has even got it working in a different language (Perl or asp for
 example) that may help also.

Are you talking about the Amazon web service?

What version of CF are you using?
What is it you're trying to do?
What is the problem you are having?

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Google your business name lately?

[Stephen Moretti (cfmaster)]

Louis Mezo wrote:

 The selection of the particular URLs that are returned on Google if 
 you run
 a search on logisynth is what's suspect. Out of all of the material
 available, this is what someone chose to represent me with? This is not
 automation or chance, but deliberate. Anybody who doesn't know anything
 about me or my company would be immediately turned off, so I'm not buying
 that it leaves you with a neutral impression.

 This is smear, and it's been going on for while. So, I wonder if 
 anyone else
 is finding themselves in a similar situation on Google. So check your name
 and your business name on Google, you might be unpleasantly surprised.

 I also suspect the motivation of the individual in question who selected
 this particular material to represent my business with.

I don't understand.

A search for logisynth on google.com returns 5 links; 2 links from the 
houseoffusion articles for this list, one from a thread on the MM forums 
and 2 from elance.

The first 3 are directly associated with you using your email address in 
those posts and the 2 elance entries are related to your service 
provider name on elance.

The 2 links from HoF archives are you actually being amusing, the link 
to the forums is a mildly unfortunate incident where you lost the 
connection to the database when a prospective client tried your 
application and the elance entries are meerly your mini-pitch for a job. 

The loss of link to your database server, while annoying and mildly 
embarasing, comes under the heading of meh... $#it happens. The thread 
is a month old and I would have hoped that you will have learned from 
this and ensured that you have appropriate error trapping in place and 
have turned off all the CF debug options in the adminstrator.

Google is entirely automated. It will have indexed pretty much all of 
the MM forums and the HoF archives and the unprotected areas of elance.
logisynth is a pretty unique search term that you are giving to Google 
and is very likely to turn up only entries that have your email address 
or elance provider name in them. 

If you were to do a search for moretti in google it'll turn up 
hundreds of thousands of entries in google, because moretti is like 
smith in Italy.However, change that to moretti coldfusion then thats 
a different matter.It'll still turn up lots of entries, but the first 
page and a bit related directly to me, including references to Simon 
Horwith's CFDJ tales from the list column.One of these references is 
mildly out of context and possible paints a poor picture of my coding 
skills, but ~shrug~ these things happen.Hopefully, all the other 
results paint an entirely different picture of me and negates this one 
thing that I'm not entirely happy about.

~sigh~ there used to be so many more references to me and coldfusion I'm 
gonna have spend some more time helping out on CF-Talk. ;o)

In short, that one link to the forums is not the end of the world.If 
you're really worried about it, then make sure that there are more items 
available that paint a different picture of you and quit shouting 
conspiracy because its only going to end up in google in a few days time.

Regards

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Senior CF/StudioMX2004 Developer available

[Stephen Moretti (cfmaster)]

Louis Mezo wrote:

 I'm sorry, but the RNC in NY provided the context, not some fuzzy 
 amorphous
 vapor.

I think thats quite enough of this thread now, thank you!

A reminder.This is an international mailing list some of us are not 
from the US, let alone New York. Both the reference to SNL and RNC are 
totally lost on me.All I saw was you reducing the thread to an all 
time childish low by calling one of my UK colleagues insulting names!

Please give it a rest.That means you too Neil. ;o)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: escaping character

[Stephen Moretti (cfmaster)]

Brant Winter wrote:

 So when you say to read the csv as a query object what exactly do you mean
 ?Do you mean treat the data as if it came straight out of a cfquery
 statement ? I am confused !

Pascal made a minor typo. 
A query object in cf is what you would get as a result from a cfquery.
 should read
 A query object in cf is what you would get as a result from a cfhttp.

CFFILE will read your file into a variable in one big block. 
If you use CFHTTP to read your file in, it is possible to put your CSV 
data straight into a cfquery object.You can then loop through your 
query object and insert the data into the database.You should find 
this easier than trying to parse your CSV file manually.

Have a read up on CFHTTP and you should see what Pascal is trying to say 
to you.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: escaping character

[Stephen Moretti (cfmaster)]

Brant Winter wrote:

 What am i doing wrong here ? Sorry about the huge post, but I just 
 cant see
 what I am missing now ? The error in line 57 refers to a different field
 than the exception message showing an address Syntax error (missing
 operator) in query _expression_ '2 HOLBOURN CRES'.

 cfhttp url="" name=qData delimiter=,

 resolveurl=no timeout=20/cfhttp
 !--- cfdump var=#qData# ---
 cfloop query=qData
cfquery datasource=obscript
INSERT INTO scripts ( SRXNO, SDISPDATE, PTITLE, PFIRSTNAME, 
 PSURNAME, PADDRESS, PSUBURB, PPOSTCODE, PMEDICARE, PMEDICDATE, 
 PCONCTYPE, PCONCNO, PCONCVDATE, PSAFENTNO, PREPATNO, SDOCPRESNO, 
 SDOCNAME, SDRUGDESC, SALTDESC, SQTY, SAUTHORITY, SSIGS, SWARDNO )
VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#, 
 #qData.PFIRSTNAME#, #qData.PSURNAME#, #qData.PADDRESS#, 
 #qData.PSUBURB#, #qData.PPOSTCODE#, #qData.PMEDICARE#, 
 #qData.PMEDICDATE#, #qData.PCONCTYPE#, #qData.PCONCNO#, 
 #qData.PCONCVDATE#, #qData.PSAFENTNO#, #qData.PREPATNO#, 
 #qData.SDOCPRESNO#, #qData.SDOCNAME#, #qData.SDRUGDESC#, 
 #qData.SALTDESC#, #qData.SQTY#, #qData.SAUTHORITY#, #qData.SSIGS#, 
 #qData.SWARDNO# )
/cfquery
 /cfloop

You need single quotes around your text and dates must in an appropriate 
format for your database.

You should look into using CFQueryParam and possibly CreateODBCDateTime 
et al.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Webservice: argument type mismatch

[Stephen Moretti (cfmaster)]

 I'm using a webservice to send a fax and I'm getting an error when 
 calling one of the
 functions:
 Could not perform web service invocation SendfaxEx_2 because
 java.lang.IllegalArgumentException: argument type mismatch

[snip]

 I think that the webservice is written in Asp.Net.

 This is the test code I'm using:

 !--- Create the webservice object ---
 cfset faxWebService = 
 CreateObject(webservice,https://ws.interfax.net/dfs.asmx?WSDL)
 cfset faxID = faxWebService.SendfaxEx_2(aaa, aaa, 123123, , 
 toBase64(),
 , , -00-00, 0,, , , subject, [EMAIL PROTECTED], 
 A4, Portrait, true, false )

If I remember correctly I don't think .NET webservices understand CF 
booleans.Try using 1 or 0 instead.

Have you tried using the http post method as an alternate?

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Webservice: argument type mismatch

[Stephen Moretti (cfmaster)]

 Thanks for the response. I tried all sort of combinations (1, True, 
 true, true),
 nothing worked.

Ok - well - only 4 of the attributes in the method you are using are 
actually compulsary.Look at the definition and remove all the 
attributes except those 4, adding in more attributes when you get 
sensible errors (ie. missing parameter etc) rather than type mismatch 
errors until you have got the data right for each attribute.


  Have you tried using the http post method as an alternate?

 No, didn't try that. I will start googling and sniffing trafic to see 
 how it's done
 (how should the response look like) but if you have a link handy it 
 would be
 helpfull.

Try taking a look at https://ws.interfax.net/dfs.asmx - you'll find all 
the methods, attributes and their responses listed there.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Webservice: argument type mismatch

[Stephen Moretti (cfmaster)]

 
  If I remember correctly I don't think .NET webservices understand CF
  booleans.Try using 1 or 0 instead.

 Thanks for the response. I tried all sort of combinations (1, True, 
 true, true),
 nothing worked.

  Have you tried using the http post method as an alternate?

 No, didn't try that. I will start googling and sniffing trafic to see 
 how it's done
 (how should the response look like) but if you have a link handy it 
 would be
 helpfull.

Oh and make sure your date/times are in ISO-8603 format.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Webservice: argument type mismatch

[Stephen Moretti (cfmaster)]

 Oh and make sure your date/times are in ISO-8603 format.

Typo damnit!that should be iso-8601
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Date Format

[Stephen Moretti (cfmaster)]

Tangorre, Michael wrote:

 What is everyone's take on the correct date format in the U.S.?
 A bunch of us here at work got into a nice argument during lunch about
 it :-)Seems like everyone thinks their way is the official way.


 -MM-DD
 YY-MM-DD
 MM-DD-
 MM-DD-YY


 /MM/DD
 YY/MM/DD
 MM/DD/
 MM/DD/YY


 Any others? Which one is the best and most universal way?

Funnily enough I just this second posted a response to another thread 
about checking date formats.

This is for data rather than display, but the ISO standard for date/time 
is 8601 
(http://www.iso.ch/iso/en/prods-services/popstds/datesandtime.html) 
which says that the format is like this : *-MM-DDThh:mm:ss for a 
date/time

For display purposes - all of your examples are wrong my way is the 
right way - its dd/mm/ ;oD

Does it really matter which way a date is displayed?Having said that 
though - generally, as a brit, I see US dates as MM/DD/.

Stephen
*
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Date Format

[Stephen Moretti (cfmaster)]

  Does it really matter which way a date is displayed?Having
  said that though - generally, as a brit, I see US dates as MM/DD/.

 I think it does matter in certain situations how the date is displayed.

Yeah it does matter some of the time - generally I try to go OTT with 
date displays, so that there can be no mistaking what date it is.eg. 
DDD DD MMM 

 Why not always display it in a locale neutral format then you never have
 to worry about audience or anything and all your work is conistent? That
 was my argument anyway. Right now we have internal applications (9 of
 them) and like 4 different date formats being used. Ugh.

Ick!Someone needs to take a hand, pick one and set it down in stone as 
the defacto date format.It confusing enough going from Euro dates to 
US dates without mixing up the US date formats too.

 I still votefor -MM-DD for dates. :-)

heh heh. If you have to use a numeric date format, I think I would be 
tempted to agree.Otherwise, dd mmm  would be my euro preference.

Stephen
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]