Re:CFXML use of memory

2003-09-30 Thread Eric Chataigné
In fact I am managing an Extranet and I have around 250 organisations that are interested in downloading information from the system.
We are looking for a standard way to provide such facility and the Web services standard seems perfect. As the downloaded data depends on the user, it will be difficult to generate a file and then make it available to the users. We have already run a pilot with Coldfusion where we create a string and send it back to the remote process. It works fine even for huge profile.

As we want to use web services, we will use cffunction to rationalise and simplify the application maintenance. By using XML variable, I expect to avoid duplication of variable when calling a function.

I can't see the advantage of using java to develop such feature. First, I don't know java and it would take me ages to develop the feature, but most important, I am not sure that it would be less memory consuming!!!


Many thanks for your useful feedback.


Joe,

I am curious, how are you creating the XML doc? What is the format of the 
data? I is based on a recordset? I ask because I am currently tasked with 
doing the same thing and want to know what is a good format for exchanging 
a CF recordset with a Delphi application.

Brook

At 12:14 PM 9/29/2003 -0400, you wrote:
I wouldnt advice creating a 10MB XML Document Via CFMX Or any other 
Application Server. I would write a simple
Java Application (Win NT Scheduled Or Other) that creates the XML file and 
let the User Download the File like
any other download.

Joe Eugene
- Original Message -
From: Eric Chataign
To: CF-Talk
Sent: Monday, September 29, 2003 8:51 AM
Subject: CFXML use of memory


Hello,

I have to generate a XML document that contains a lot of records (the 
 size of the text file can be more than 10 Mb.


Does anyone know how must a CFMX variable requires as RAM in regards to 
 the text docuement?


Many thanks.

--
[
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




FW: CFGURU: Permissions error

2003-09-30 Thread Snake Hollywood
 
I'm having fun with CFMx this week.
Now getting this error when trying to use cffile
Normal file actions work fine within a site, it's only UPLOAD that
doesn't work as this temp file is being copied from outside the site by
CF. Have tried adding this temp folder into the sandbox security, but no
joy. I think it must have been the cfmx6.1 upgrade that caused this one
as sandboxes were working fine b4 that.
 
 Security: The requested template has been denied access to
E:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp5
331.tmp.
The following is the internal exception message: access 
denied (java.io.FilePermission 
E:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp5
331.tmp read)


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Menu options based on login ???

2003-09-30 Thread Ian Vaughan
Hi

I have created a login system in Coldfusion and it works great.

However I would like to restrict some links on the main menu to certain users

For example

CFIF Session.status = ?? WHAT GOES HERE ???

Display menu for users with a session.status of administrator only

CFELSE

Display other menu items for all users and the administrator to view
/CFIF 


How is this achieveable in Coldfusion through cfif statements ?? 


This is what I have at the moment, this checks the users login details and sets session variables for that session.

In my case I have added one called Session.status

-
CFQUERY DATASOURCE=#Application.DSN# NAME=Security
SELECT *
FROM admin
WHERE Username = '#form.Username#' AND Password = '#form.Password#'
/CFQUERY

CFIF Security.RecordCount IS 0
CFLOCATION URL="" ADDTOKEN=No

!--- If validation is succesful then set the username, password from the preceding login form that matched the admin query and was validated as Session variable. Also set the user ID from the admin query as a session id, then send them staright to their administration page ---

CFELSE

CFSET Session.Password = #Security.Password#
CFSET Session.Username = #Security.username#
CFSET Session.ID = #Security.ID#
CFSET Session.Fname = #Security.Fname#
CFSET Session.Lname = #Security.Lname#
CFSET Session.status = #Security.Status#

CFLOCATION URL="" ADDTOKEN=No
/CFIF

--



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Menu options based on login ???

2003-09-30 Thread Peter Tilbrook
Try this (assuming the status variable is a numeric value, 1 for
administrator access - 2 for editor access - 3 for contributor access, etc.:

cfswitch _expression_ = #Session.Status#
cfcase value = 1

	Display menu for administrators only.

/cfcase
cfcase value = 2

	Display menu for editors only.

/cfcase
cfcase value = 3

	Display menu for contributors only.

/cfcase
cfdefaultcase

	Display menu for contributors only.

/cfdefaultcase
/cfswitch

Or you could wrap individual menu items in cfif Session.Status EQ 1 etc
for specifics.

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 September 2003 6:10 PM
To: CF-Talk
Subject: Menu options based on login ???


Hi

I have created a login system in Coldfusion and it works great.

However I would like to restrict some links on the main menu to certain
users

For example

CFIF Session.status = ?? WHAT GOES HERE ???

Display menu for users with a session.status of administrator only

CFELSE

Display other menu items for all users and the administrator to view
/CFIF


How is this achieveable in Coldfusion through cfif statements ??


This is what I have at the moment, this checks the users login details and
sets session variables for that session.

In my case I have added one called Session.status

-
CFQUERY DATASOURCE=#Application.DSN# NAME=Security
SELECT *
FROM admin
WHERE Username = '#form.Username#' AND Password = '#form.Password#'
/CFQUERY

CFIF Security.RecordCount IS 0
CFLOCATION URL="" ADDTOKEN=No

!--- If validation is succesful then set the username, password from the
preceding login form that matched the admin query and was validated as
Session variable. Also set the user ID from the admin query as a session id,
then send them staright to their administration page ---

CFELSE

CFSET Session.Password = #Security.Password#
CFSET Session.Username = #Security.username#
CFSET Session.ID = #Security.ID#
CFSET Session.Fname = #Security.Fname#
CFSET Session.Lname = #Security.Lname#
CFSET Session.status = #Security.Status#

CFLOCATION URL="" ADDTOKEN=No
/CFIF


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF Salary Range

2003-09-30 Thread Adam Reynolds
Ok if we ain't talking ratescan this be moved to either cf-jobs-talk or
cf-community.

Where this topic is going will bring out strong emotions and rants can go on
and on and on :)
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: 30 September 2003 06:14
To: CF-Talk
Subject: Re: CF Salary Range


Tim Laureska wrote:

 I'm more concerned about what someone mentioned previously... the
 offshore folk who work for peanuts, but still do decent work. it
 seems this type of foreign competition is pervasive throughout our
 economy anymore ... Can anyone give me a reason to say those fears for
 the future are unfounded??? Sometimes I feel like we're all just
 circlin' the drain, albeit slowly

Are you kidding?We've only seen the beginning.Moving programming
offshore
is about many times as easier than moving manufacturing (it's just another
type
of manufacturing, anyway, isn't it?) and we've seen how quickly the
manufacturing job sector of our economy has been lost in the US.A large
portion of high paying programming and engineering jobs are about to leave
and
never return.And it will happen _much_ faster than we've seen in the
hard
goods sector.Ten years or less.It will be an unprecedented job exodus
the
likes of which we've never seen before.



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF Salary Range

2003-09-30 Thread Tim Laureska
Yeah... agreed ... sorry, movin' on

-Original Message-
From: Adam Reynolds [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 5:34 AM
To: CF-Talk
Subject: RE: CF Salary Range

Ok if we ain't talking ratescan this be moved to either cf-jobs-talk
or
cf-community.

Where this topic is going will bring out strong emotions and rants can
go on
and on and on :)
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: 30 September 2003 06:14
To: CF-Talk
Subject: Re: CF Salary Range


Tim Laureska wrote:

 I'm more concerned about what someone mentioned previously... the
 offshore folk who work for peanuts, but still do decent work. it
 seems this type of foreign competition is pervasive throughout our
 economy anymore ... Can anyone give me a reason to say those fears
for
 the future are unfounded??? Sometimes I feel like we're all just
 circlin' the drain, albeit slowly

Are you kidding?We've only seen the beginning.Moving programming
offshore
is about many times as easier than moving manufacturing (it's just
another
type
of manufacturing, anyway, isn't it?) and we've seen how quickly the
manufacturing job sector of our economy has been lost in the US.A
large
portion of high paying programming and engineering jobs are about to
leave
and
never return.And it will happen _much_ faster than we've seen in the
hard
goods sector.Ten years or less.It will be an unprecedented job
exodus
the
likes of which we've never seen before.




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF Salary Range

2003-09-30 Thread John McCosker
Agreed.
 
J.

-Original Message-
From: Adam Reynolds [mailto:[EMAIL PROTECTED]
Sent: 30 September 2003 10:34
To: CF-Talk
Subject: RE: CF Salary Range


Ok if we ain't talking ratescan this be moved to either cf-jobs-talk or
cf-community.

Where this topic is going will bring out strong emotions and rants can go on
and on and on :)
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: 30 September 2003 06:14
To: CF-Talk
Subject: Re: CF Salary Range


Tim Laureska wrote:

 I'm more concerned about what someone mentioned previously... the
 offshore folk who work for peanuts, but still do decent work. it
 seems this type of foreign competition is pervasive throughout our
 economy anymore ... Can anyone give me a reason to say those fears for
 the future are unfounded??? Sometimes I feel like we're all just
 circlin' the drain, albeit slowly

Are you kidding?We've only seen the beginning.Moving programming
offshore
is about many times as easier than moving manufacturing (it's just another
type
of manufacturing, anyway, isn't it?) and we've seen how quickly the
manufacturing job sector of our economy has been lost in the US.A large
portion of high paying programming and engineering jobs are about to leave
and
never return.And it will happen _much_ faster than we've seen in the
hard
goods sector.Ten years or less.It will be an unprecedented job exodus
the
likes of which we've never seen before.



_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CF Salary Range

2003-09-30 Thread Hawkes, Keith A CIV
How about the folks in California's Silicon Valley that are willing to work
FOR FREE?!?!Of course, we are talking about California, where anything
goes . . .

Keith Hawkes
DoD CF Developer
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SES and URL Rewrite

2003-09-30 Thread Ketan Patel
Hi,
Is there any way besides ISAPI Filter.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


-Original Message-
From: Jack Dalaa [mailto:[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 9:52 AM
To: CF-Talk
Subject: Re:SES and URL Rewrite


Download ISAPI Rewrite (www.isapirewrite.com), then use the following
rules in httpd.ini:


[ISAPI_Rewrite]
RepeatLimit 20

# Defend your computer from some worm attacks
RewriteRule (/dyn/.*?)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)?
$1(?2$2:\?)$3=$4?5$5: [N,I]
RewriteRule /dyn(.+?)/?(\?.*)? $1.cfm$2 [I]


.. You can change the 'dyn' to whatever you want, but that would enable
URL's like:

http://www.abc.com/dyn/info/articleid/34

If you don't include the dyn, all URLs will be picked up by the filter,
which wont work right.

Have fun!


Jack

Hi,
I am also looking for something but. I want to know that for
eg:
if my URL is:

http://www.abc.com/info.cfm?ArticleID=3043

can I rewrite the URL as

http://www.abc.com/info/ArticleID/3043

If you notice that I replaced info.cfm by info , means I want to remove
the
file extension.
Let me know if this is possible, I know in Apache there is something like
this.

Thanks,

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Ketan Patel
Any Help on this topic is appreciated.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 7:43 AM
To: CF-Talk
Subject: Need better CFX tag instead of CFHTTP tag.


Hi,
I am looaking for a good CFX tag which resolves URL redirects and all. I
need CFX http tag which resolves url redirects at server level means IIS
redirects and all. Also returns me header information with the page
content.
Eg: www.compaq.com which redirects to new hp site.
Please suggest me a good CFX tag which will help me. I tird using cfx_http
but its not giving me what I want.

Thanks,


Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Java Custome Tag

2003-09-30 Thread Lists2 - TriPointTek
Anyone know of a unencrypted java custom tag for CF. Preferrably 
performs a somewhat basic function.

Thanks,

Dan



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SES and URL Rewrite

2003-09-30 Thread Hugo Ahlenius
You can also use the 404 handler, I guess. It gets executed and dispatches
the processing to the proper template according to the CGI path variable.




-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
 WWW: http://www.grida.no
- 






| -Original Message-
| From: Ketan Patel [mailto:[EMAIL PROTECTED]
| Sent: Tuesday, September 30, 2003 13:34
| To: CF-Talk
| Subject: RE: SES and URL Rewrite
|
|
| Hi,
| Is there any way besides ISAPI Filter.
|
| Ketan Patel
| G3 Technology Group, LLC
| Graphics III Advertising, Inc.
| (410)789-7007 or (800)783-1799
| It's Not Creative if it doesn't Sell.
| http://www.g3group.com http://www.g3group.com
|
|
|-Original Message-
|From: Jack Dalaa [mailto:[EMAIL PROTECTED]
|Sent: Monday, September 29, 2003 9:52 AM
|To: CF-Talk
|Subject: Re:SES and URL Rewrite
|
|
|Download ISAPI Rewrite (www.isapirewrite.com), then use the
| following
| rules in httpd.ini:
|
|
|[ISAPI_Rewrite]
|RepeatLimit 20
|
|# Defend your computer from some worm attacks
|RewriteRule (/dyn/.*?)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)?
| $1(?2$2:\?)$3=$4?5$5: [N,I]
|RewriteRule /dyn(.+?)/?(\?.*)? $1.cfm$2 [I]
|
|
|.. You can change the 'dyn' to whatever you want, but that
| would enable
| URL's like:
|
|http://www.abc.com/dyn/info/articleid/34
|
|If you don't include the dyn, all URLs will be picked up by
| the filter,
| which wont work right.
|
|Have fun!
|
|
|Jack
|
|Hi,
|I am also looking for something but. I want to know that for
|eg:
|if my URL is:
|
|http://www.abc.com/info.cfm?ArticleID=3043
|
|can I rewrite the URL as
|
|http://www.abc.com/info/ArticleID/3043
|
|If you notice that I replaced info.cfm by info , means I
| want to remove
| the
|file extension.
|Let me know if this is possible, I know in Apache there is
| something like
|this.
|
|Thanks,
|
|Ketan Patel
|G3 Technology Group, LLC
|Graphics III Advertising, Inc.
|(410)789-7007 or (800)783-1799
|It's Not Creative if it doesn't Sell.
|http://www.g3group.com http://www.g3group.com
|
|
|
| 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Daniel Mackey
Hi,

We came up with the same issues before and developed a COM object that
handles redirects. The COM object is scriptable with VBScript scripts so you
could for example:

Script1 - Browse to a URL
Script2 - Fill in a form
Script3 - Submit the form

And get the returned HTML from the last page of the script processing.

The scripts run sequentially,

The could bit of the com object is that it handles the redirect perfectly.

I know on the forums at the time of writing the COM object, MRichmond (Look
her up on the forums) wrote a Java CFX that handled redirects.

Hope this is of some assistance,

Regards,
Dan.

--
If you would like to purchase any of my tags, components or applications, I
have a PayPal Account that may make it easier for you.

Visit www.CFTagStore.com for the very best Coldfusion Custom Tags,
Components and Applications.

Daniel Mackey
Digital Crew Ltd.
Pembroke House,
Pembroke Street,
Cork,
Ireland

T: 00353 21 427 7778


-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:34
To: CF-Talk
Subject: RE: Need better CFX tag instead of CFHTTP tag.


Any Help on this topic is appreciated.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


 -Original Message-
 From: Ketan Patel [mailto:[EMAIL PROTECTED]
 Sent: Monday, September 29, 2003 7:43 AM
 To: CF-Talk
 Subject: Need better CFX tag instead of CFHTTP tag.


 Hi,
 I am looaking for a good CFX tag which resolves URL redirects and all. I
 need CFX http tag which resolves url redirects at server level means IIS
 redirects and all. Also returns me header information with the page
content.
 Eg: www.compaq.com which redirects to new hp site.
 Please suggest me a good CFX tag which will help me. I tird using
cfx_http
 but its not giving me what I want.

 Thanks,


 Ketan Patel
 G3 Technology Group, LLC
 Graphics III Advertising, Inc.
 (410)789-7007 or (800)783-1799
 It's Not Creative if it doesn't Sell.
 http://www.g3group.com http://www.g3group.com




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Java Custome Tag

2003-09-30 Thread Ben Forta
There are some examples in source code form under the cfx directory
under the ColdFusion root (so on Windows using a default install
C:\CFusionMX\cfx\java\distrib\examples).
 
--- Ben
 
 
-Original Message-
From: Lists2 - TriPointTek [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 10:30 AM
To: CF-Talk
Subject: Java Custome Tag


Anyone know of a unencrypted java custom tag for CF. Preferrably 
performs a somewhat basic function.

Thanks,

Dan



_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Philip Arnold
 I am looaking for a good CFX tag which resolves URL redirects and all.
I
 need CFX http tag which resolves url redirects at server level means
IIS
 redirects and all. Also returns me header information with the page
content.
 Eg: www.compaq.com which redirects to new hp site.
 Please suggest me a good CFX tag which will help me. I tird using
cfx_http
 but its not giving me what I want.

Which version of CF are you running? CFMX has a lot better CFHTTP
control than CF5 or less



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Java Custome Tag

2003-09-30 Thread Craig Dudley
I've got loads, you just after the format?There's a JAVA CFX section
in the help which covers most things, and includes some hello world
cfx's which should help.

But basically the format of a cfx is something like.

-
import com.allaire.cfx.*;

public class myClassName implements CustomTag{
public void processRequest( Request request, Response response )
throws Exception{

 // Your JAVA code in here

	}
}



If you want to see something a little more complex, just shout.

-Original Message-
From: Lists2 - TriPointTek [mailto:[EMAIL PROTECTED] 
Sent: 30 September 2003 15:30
To: CF-Talk
Subject: Java Custome Tag


Anyone know of a unencrypted java custom tag for CF. Preferrably 
performs a somewhat basic function.

Thanks,

Dan





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Ketan Patel
Hi,
I am on CF5.0 but soon will be moving to CFMX. Regarding the COM object is
there anysite I cna find more on that.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 7:45 AM
To: CF-Talk
Subject: RE: Need better CFX tag instead of CFHTTP tag.


 I am looaking for a good CFX tag which resolves URL redirects and all.
I
 need CFX http tag which resolves url redirects at server level means
IIS
 redirects and all. Also returns me header information with the page
content.
 Eg: www.compaq.com which redirects to new hp site.
 Please suggest me a good CFX tag which will help me. I tird using
cfx_http
 but its not giving me what I want.

Which version of CF are you running? CFMX has a lot better CFHTTP
control than CF5 or less




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Daniel Mackey
Hi Ketan,

I will try and get some sort of a demo going maybe tonight or tomorrow.
Email me off list and I'll explain more.

Regards,
Dan.
--
If you would like to purchase any of my tags, components or applications, I
have a PayPal Account that may make it easier for you.

Visit www.CFTagStore.com for the very best Coldfusion Custom Tags,
Components and Applications.

Daniel Mackey
Digital Crew Ltd.
Pembroke House,
Pembroke Street,
Cork,
Ireland

T: 00353 21 427 7778

-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:55
To: CF-Talk
Subject: RE: Need better CFX tag instead of CFHTTP tag.


Hi,
I am on CF5.0 but soon will be moving to CFMX. Regarding the COM object is
there anysite I cna find more on that.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


 -Original Message-
 From: Philip Arnold [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 30, 2003 7:45 AM
 To: CF-Talk
 Subject: RE: Need better CFX tag instead of CFHTTP tag.


  I am looaking for a good CFX tag which resolves URL redirects and all.
 I
  need CFX http tag which resolves url redirects at server level means
 IIS
  redirects and all. Also returns me header information with the page
 content.
  Eg: www.compaq.com which redirects to new hp site.
  Please suggest me a good CFX tag which will help me. I tird using
 cfx_http
  but its not giving me what I want.

 Which version of CF are you running? CFMX has a lot better CFHTTP
 control than CF5 or less





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Application and Request scope

2003-09-30 Thread Paul Wilson
I've been reading a few threads that advise on storing various things (that's a technical description btw) in the
application or request scope. Why is this a good idea and what things should be stored there?

Thanks!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Snake Hollywood
try www.intrafoundation.com, the IHTK has a CFX that does http
 
Russ Michaels
Macromedia/Allaire Certified ColdFusion Developer
 
CFMX Hosting
Phone: 0845 456 3487
Tech Support: 0906 9607800
FAX: 0709 2212 636
 http://www.cfmxhosting.co.uk/ WEB: cfmxhosting.co.uk
 
Please use the support helpdesk on our web site to submit support
tickets.

Join our ColdFusion Developer discussion lists.
Send an e-mail tomailto:[EMAIL PROTECTED]
[EMAIL PROTECTED]

-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED] 
Sent: 30 September 2003 12:34
To: CF-Talk
Subject: RE: Need better CFX tag instead of CFHTTP tag. 


Any Help on this topic is appreciated.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com
http://www.g3group.com 


-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 7:43 AM
To: CF-Talk
Subject: Need better CFX tag instead of CFHTTP tag.


Hi,
I am looaking for a good CFX tag which resolves URL redirects and all.
I
need CFX http tag which resolves url redirects at server level means
IIS
redirects and all. Also returns me header information with the page
content.
Eg: www.compaq.com which redirects to new hp site.
Please suggest me a good CFX tag which will help me. I tird using
cfx_http
but its not giving me what I want.

Thanks,


Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com
http://www.g3group.com 



_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Java Custome Tag

2003-09-30 Thread John McCosker
There is also a really good article on this at sys-con.com,
https://www.sys-con.com/coldfusion/article.cfm?id=639
https://www.sys-con.com/coldfusion/article.cfm?id=639 
 
J.

-Original Message-
From: Lists2 - TriPointTek [mailto:[EMAIL PROTECTED]
Sent: 30 September 2003 15:30
To: CF-Talk
Subject: Java Custome Tag


Anyone know of a unencrypted java custom tag for CF. Preferrably 
performs a somewhat basic function.

Thanks,

Dan



_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Flash date format problem

2003-09-30 Thread Kay Smoljak
I'm working on a Flash remoting app, and I need to pass a list of dates from the Flash calendar component to a CFC. I'm having some problems with date formats.

Flash is sending dates as strings like this: Mon Mar 10 00:00:00 GMT+0800 2003

In my CFC, when I run the following statements:
#CreateODBCDateTime(Mon Mar 10 00:00:00 GMT+0800 2003)#br
#DateFormat(Mon Mar 10 00:00:00 GMT+0800 2003,'dd/mm/')#br
#ParseDateTime(Mon Mar 10 00:00:00 GMT+0800 2003)#

I get the following results:
{ts '2000-03-10 00:00:00'}
10/03/2000
{ts '2000-03-10 00:00:00'} 

That is, the 10th of March 2000 NOT the 10th of March 2003.

Any ideas on what I need to do to return the correct year?

TIA,
Kay.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CF Salary Range

2003-09-30 Thread Lists2 - TriPointTek
Tim Laureska wrote:

 I'm more concerned about what someone mentioned previously... the
 offshore folk who work for peanuts, but still do decent work. it
 seems this type of foreign competition is pervasive throughout our
 economy anymore ... Can anyone give me a reason to say those fears for
 the future are unfounded??? Sometimes I feel like we're all just
 circlin' the drain, albeit slowly

I was shocked but very happy to see in my local newspaper this past 
weekend that the government is stepping up to the plate, and may help in 
this area. I have pasted the contents of the article below since the 
sun-sentinel.com site requires a free login.

---


Foreign worker visas to be cut


By Joan Fleischer Tamen
Business Writer

September 27, 2003

Aiming to curb abuses in foreign worker visa programs that critics say 
displace American workers at a time of rising unemployment, U.S. 
legislators from Florida and several New England states are pushing for 
stricter laws on the use of such employment visas.

Barring any last-minute action in Congress -- and there is little sign 
of it -- the annual quota for H-1B visas for skilled foreign workers 
automatically drops from 195,000 to 65,000 on Oct. 1. A $1,000 fee for 
each visa used to fund training programs for U.S. workers and students 
also will expire.

But some worry it's too little, too late.

Many companies skirt U.S. immigration laws and bring over inexpensive 
foreign workers with visas other than the H1-B, such as the L-1.

The L-1 is intended for intra-company transfers but now is routinely 
used by computer consultant companies that lease out temporary foreign 
workers to other employers.

U.S. Rep. Robert Wexler, D-Boca Raton, said he is joining a bipartisan 
group of legislators led by U.S. Rep. Rosa DeLauro, D-Connecticut, that 
would close loopholes in immigration laws that allow companies to bring 
in foreign workers, pay them less and replace American workers.

The more I learned about abuses by certain companies and how workers in 
South Florida are affected, I became convinced I should be a part of the 
effort to reform the visa programs, said Wexler, who this week said he 
is co-sponsoring a bill called the L-1 Non-Immigration Reform Act.

Wexler said he was moved by the personal accounts of displaced South 
Florida technology workers profiled in a South Florida Sun-Sentinel 
story that ran Aug. 10. It reported on potential abuses in the foreign 
worker visa programs and how South Florida workers not only were 
displaced by visa holders but often were required to train their 
replacements.

In this so-called jobless recovery, with so many Americans still out of 
work and with high-technology workers especially hurting, it doesn't 
make sense to keep lax liberal immigration laws, said Wexler.

Coral Springs resident Phil Marraffini, 47, a senior systems analyst who 
lost his job to visa holders and was profiled in the story, said he was 
gratified when contacted by Wexler.

I'm hoping that it can help make a difference, said Marraffini, who 
now works as a housepainter. It is an outrage what has been done to so 
many American technology workers.

*Bill seeks cap

*DeLauro's bill would place an annual cap of 35,000 L-1 visas and 
require L-1 workers to be paid prevailing U.S. wages. The bill would 
also deny L-1s to any company that has laid off an American worker in 
the six months before or after filing an L-1 application.

The cap on H1-B visas at 65,000, Wexler said is still too high.

I'd certainly be amenable to a larger drop, and for keeping the $1,000 
training fee, said the Democrat from Boca Raton. In the past during a 
strong economy, I supported increasing the caps.

In 1998 and again in 2000, Congress increased the numbers on H-1B visas 
-- from 65,000 a year to 115,000 a year for two years beginning in 1999; 
and to 195,000 a year for three years beginning in 2001.

Not all visas issued count toward the cap. Those applying to extend 
their three-year visa for another three years, for example, or those in 
academia or research are not counted.

A just-published report by the Department of Homeland Security's Office 
of Immigration Statistics shows that 197,537 H1-B visas were approved in 
2002, down 40 percent from 331,206 in 2001.

But at the same time, the number of workers coming in on the much less 
regulated L-1 visa is on the rise.

There are an estimated 325,000 L-1 visa holders currently working in the 
United States. Florida ranks third after California and New York for 
having the largest number of these visa holders.

We don't believe that Congress intended -- or could have even 
anticipated -- that the L-1 visa program would be used by some companies 
to import substantial numbers of technical workers, IT professionals and 
engineers and then use those employees to provide services under 
contract or lease arrangements with other U.S.-based employers who, in 
turn, lay 

RE: Application and Request scope

2003-09-30 Thread Jim Davis
I explain this pretty thoroughly in my guide to CF variables here:
 
http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V
ariables/Index.cfm
 
I'm sure other people have other (perhaps better) opinions but that
should give you the skinny at least.
 
Jim Davis
 
-Original Message-
From: Paul Wilson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 8:08 AM
To: CF-Talk
Subject: Application and Request scope
 
I've been reading a few threads that advise on storing various things
(that's a technical description btw) in the
application or request scope. Why is this a good idea and what things
should be stored there?

Thanks!
_

[Todays 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Java Custome Tag

2003-09-30 Thread Lists2 - TriPointTek
Ben Forta wrote:

 There are some examples in source code form under the cfx directory
 under the ColdFusion root (so on Windows using a default install
 C:\CFusionMX\cfx\java\distrib\examples).

 --- Ben

Didn't think of looking there. Thanks.

Dan



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Java Custome Tag

2003-09-30 Thread Lists2 - TriPointTek
Craig Dudley wrote:

 I've got loads, you just after the format?There's a JAVA CFX section
 in the help which covers most things, and includes some hello world
 cfx's which should help.

I want to integrate a few into CF in conjunction with learning Java.

Thanks



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CF Salary Range

2003-09-30 Thread Doug White
See reply posted in CF-Community

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases.
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: Lists2 - TriPointTek [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 10:33 AM
Subject: Re: CF Salary Range


| Tim Laureska wrote:
|
|  I'm more concerned about what someone mentioned previously... the
|  offshore folk who work for peanuts, but still do decent work. it
|  seems this type of foreign competition is pervasive throughout our
|  economy anymore ... Can anyone give me a reason to say those fears for
|  the future are unfounded??? Sometimes I feel like we're all just
|  circlin' the drain, albeit slowly
|
| I was shocked but very happy to see in my local newspaper this past
| weekend that the government is stepping up to the plate, and may help in
| this area. I have pasted the contents of the article below since the
| sun-sentinel.com site requires a free login.
|
| ---
|
|
|Foreign worker visas to be cut
|
|
| By Joan Fleischer Tamen
| Business Writer
|
| September 27, 2003
|
| Aiming to curb abuses in foreign worker visa programs that critics say
| displace American workers at a time of rising unemployment, U.S.
| legislators from Florida and several New England states are pushing for
| stricter laws on the use of such employment visas.
|
| Barring any last-minute action in Congress -- and there is little sign
| of it -- the annual quota for H-1B visas for skilled foreign workers
| automatically drops from 195,000 to 65,000 on Oct. 1. A $1,000 fee for
| each visa used to fund training programs for U.S. workers and students
| also will expire.
|
| But some worry it's too little, too late.
|
| Many companies skirt U.S. immigration laws and bring over inexpensive
| foreign workers with visas other than the H1-B, such as the L-1.
|
| The L-1 is intended for intra-company transfers but now is routinely
| used by computer consultant companies that lease out temporary foreign
| workers to other employers.
|
| U.S. Rep. Robert Wexler, D-Boca Raton, said he is joining a bipartisan
| group of legislators led by U.S. Rep. Rosa DeLauro, D-Connecticut, that
| would close loopholes in immigration laws that allow companies to bring
| in foreign workers, pay them less and replace American workers.
|
| The more I learned about abuses by certain companies and how workers in
| South Florida are affected, I became convinced I should be a part of the
| effort to reform the visa programs, said Wexler, who this week said he
| is co-sponsoring a bill called the L-1 Non-Immigration Reform Act.
|
| Wexler said he was moved by the personal accounts of displaced South
| Florida technology workers profiled in a South Florida Sun-Sentinel
| story that ran Aug. 10. It reported on potential abuses in the foreign
| worker visa programs and how South Florida workers not only were
| displaced by visa holders but often were required to train their
| replacements.
|
| In this so-called jobless recovery, with so many Americans still out of
| work and with high-technology workers especially hurting, it doesn't
| make sense to keep lax liberal immigration laws, said Wexler.
|
| Coral Springs resident Phil Marraffini, 47, a senior systems analyst who
| lost his job to visa holders and was profiled in the story, said he was
| gratified when contacted by Wexler.
|
| I'm hoping that it can help make a difference, said Marraffini, who
| now works as a housepainter. It is an outrage what has been done to so
| many American technology workers.
|
| *Bill seeks cap
|
| *DeLauro's bill would place an annual cap of 35,000 L-1 visas and
| require L-1 workers to be paid prevailing U.S. wages. The bill would
| also deny L-1s to any company that has laid off an American worker in
| the six months before or after filing an L-1 application.
|
| The cap on H1-B visas at 65,000, Wexler said is still too high.
|
| I'd certainly be amenable to a larger drop, and for keeping the $1,000
| training fee, said the Democrat from Boca Raton. In the past during a
| strong economy, I supported increasing the caps.
|
| In 1998 and again in 2000, Congress increased the numbers on H-1B visas
| -- from 65,000 a year to 115,000 a year for two years beginning in 1999;
| and to 195,000 a year for three years beginning in 2001.
|
| Not all visas issued count toward the cap. Those applying to extend
| their three-year visa for another three years, for example, or those in
| academia or research are not counted.
|
| A just-published report by the Department of Homeland Security's Office
| of 

RE: Flash date format problem

2003-09-30 Thread McGill, Eric
Worst case scenario, you can parse that thing out to a date format you know cf likes:
 
cfscript
 dteFromFlash = Mon Mar 10 00:00:00 GMT+0800 2003;
 dteConverted = listGetAt( dteFromFlash, 3,   )  -  listGetAt( dteFromFlash, 2,   )  -  listGetAt( dteFromFlash, 6,   );
 writeOutput(dteConverted);
/cfscript

-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 8:31 AM
To: CF-Talk
Subject: Flash date format problem


I'm working on a Flash remoting app, and I need to pass a list of dates from the Flash calendar component to a CFC. I'm having some problems with date formats.

Flash is sending dates as strings like this: Mon Mar 10 00:00:00 GMT+0800 2003

In my CFC, when I run the following statements:
#CreateODBCDateTime(Mon Mar 10 00:00:00 GMT+0800 2003)#br
#DateFormat(Mon Mar 10 00:00:00 GMT+0800 2003,'dd/mm/')#br
#ParseDateTime(Mon Mar 10 00:00:00 GMT+0800 2003)#

I get the following results:
{ts '2000-03-10 00:00:00'}
10/03/2000
{ts '2000-03-10 00:00:00'} 

That is, the 10th of March 2000 NOT the 10th of March 2003.

Any ideas on what I need to do to return the correct year?

TIA,
Kay.

_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Java Custome Tag

2003-09-30 Thread Lists2 - TriPointTek
John McCosker wrote:

 There is also a really good article on this at sys-con.com,
 https://www.sys-con.com/coldfusion/article.cfm?id=639
 https://www.sys-con.com/coldfusion/article.cfm?id=639

 J.

Great, thanks John.



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Java Custome Tag

2003-09-30 Thread Craig Dudley
You don't necessarily need to use CFX's, you can integrate a lot of java
class files just by using cfobject.
 
With CFMX this is a whole lot better as you can actually use java
methods without writing and compiling class files.
 
You have lots of options, I guess if the java is quite complex then a
CFX is probably the way to go but simple calls to java methods shouldn't
need them.
 
Have fun,
 
Craig.

	-Original Message-
	From: Lists2 - TriPointTek [mailto:[EMAIL PROTECTED] 
	Sent: 30 September 2003 16:43
	To: CF-Talk
	Subject: Re: Java Custome Tag
	
	
	Craig Dudley wrote:
	
	 I've got loads, you just after the format?There's a JAVA CFX
section
	 in the help which covers most things, and includes some hello
world
	 cfx's which should help.
	
	I want to integrate a few into CF in conjunction with learning
Java.
	
	Thanks
	
	
	
_

	[ Todays Threads

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Java Custome Tag

2003-09-30 Thread Darron J. Schall
You don't necessarily need to use CFX's, you can integrate a lot of java
class files just by using cfobject.

Just a quick example of leveraging a built-in Java class in CFMX:

cfscript
 st = createObject(Java, java.util.StringTokenizer);
 st.init(This is my a|b String,  |, false); // call the constructor.
pass in space and | as separater chars, and the false means that we don't
want the separaters returned as tokens
 writeOutput(Tokens:  st.countTokens()  br/);// display the token
count
 while (st.hasMoreTokens()) { // loop through all of the tokens and just
output one token per line
writeOutput(st.nextToken());
writeOutput(br/);
 }
/cfscript


-d

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Java Custome Tag

2003-09-30 Thread Lists2 - TriPointTek
Darron J. Schall wrote:

 You don't necessarily need to use CFX's, you can integrate a lot of java
 class files just by using cfobject.

 Just a quick example of leveraging a built-in Java class in CFMX:

 cfscript
 st = createObject(Java, java.util.StringTokenizer);
 st.init(This is my a|b String,  |, false); // call the constructor.
 pass in space and | as separater chars, and the false means that we 
 don't
 want the separaters returned as tokens
 writeOutput(Tokens:  st.countTokens()  br/);// display the token
 count
 while (st.hasMoreTokens()) { // loop through all of the tokens and just
 output one token per line
writeOutput(st.nextToken());
writeOutput(br/);
 }
 /cfscript


 -d
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




re: Getting information from another website

2003-09-30 Thread Bushy
Hi,

I would like to know if this is possible. Every week I go to this website that has the schedule for my sons hockey. 

http://allplayers.bladenet.net/allplayers/schedules.do?associationCode=CA0309seasonNumber=0scheduleGroupCode=CA0309-1

>From here I select the start/end from the dropdown menu and division which is Minor Ataom Blue and then click on Go to get the schedule.

Is it possible to create a CF template that grabs all this information automatically behind the scenes so I can just add a link on my desktop that would popup the weekly 
schedule?




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Drawing diagonal lines

2003-09-30 Thread Terry Troxel
I am using html and CF to dynamically draw rectangular wall modules
based upon user input. I am using a scale of 1.5 pixels = 1 inch. I really
would like to come up with a way of displaying the roof slope as well,
but have been unsuccessful so far in drawing a diagonal line that I
can display on the screen as well as send to the printer. I failed in my 
attempts to use dhtml layers as it displayed properly on the screen, but
printed incorrectly.

If anyone could offer some suggestions I would appreciate it.

Terry Troxel
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Parameters with cfmail in CFMX

2003-09-30 Thread Bastian Schmid
Hello,

I'm in big trouble with cfmail.

I have a textare to enter a eMail. This eMail is sent to the recipient with the following code:

cfmail to=#email# 
from=#absender_name# #absender_email# 
 subject=#betreff# 
server=mail.sdsolutions.de 
Port=25 
CFMAILPARAM NAME=content-type VALUE ='multipart/alternative; boundary==_NextPart_000_000C_01C314E8.6E94A770' 
CFMAILPARAM NAME=charset VALUE =UTF-8 
cfmailparam name=Reply-To value=[EMAIL PROTECTED] 
cfmailparam name=MIME-Version value=1.0 

This is a multi-part message in MIME format. 

--=_NextPart_000_000C_01C314E8.6E94A770 
Content-Type: text/plain; charset=iso-8859-1 
Content-Transfer-Encoding: quoted-printable 


#form.email_text# 


--=_NextPart_000_000C_01C314E8.6E94A770 
Content-Type: text/html; charset=iso-8859-1 

#form.email_html# 



--=_NextPart_000_000C_01C314E8.6E94A770-- 
/cfmail 

That works fine on CF 5.
But now we updated to CF MX and the code doesn't work any more.

I get the following error message:

An exception occurred when setting up mail server parameters.
This exception was caused by: java.lang.NullPointerException.

Der Fehler trat auf in '\mail_send.cfm: line 105 

105 : #email_html#
106 : 
107 : 
Is it impossible to use parameters within the cfmail Tag? Or is there somethng wrong in my code?Greetz,Bastian 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Getting information from another website

2003-09-30 Thread Pascal Peters
You can use cfhttp to do that. Look at what fields the form posts and
the URL of the action page.
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: dinsdag 30 september 2003 15:46
To: CF-Talk
Subject: re: Getting information from another website


Hi,

I would like to know if this is possible. Every week I go to this
website that has the schedule for my sons hockey. 

http://allplayers.bladenet.net/allplayers/schedules.do?associationCode=C
A0309seasonNumber=0scheduleGroupCode=CA0309-1

>From here I select the start/end from the dropdown menu and division
which is Minor Ataom Blue and then click on Go to get the schedule.

Is it possible to create a CF template that grabs all this information
automatically behind the scenes so I can just add a link on my desktop
that would popup the weekly 
schedule?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Application and Request scope

2003-09-30 Thread cfhelp
I read this and now I am questioning my Application.

 

I have been building a document Library system. The Application is shared
between all the sites using it by Virtual Directories. 

 

I use session variables in the login.cfm to set the User information (GUID,
Directory, IsAdmin) after login authentication.

 

cfset SESSION.Auth = StructNew()

cfset SESSION.Auth.Email = QryCheckLogin.Email

cfset SESSION.Auth.UserGUID = QryCheckLogin.UserGUID

cfset SESSION.Auth.LibraryGUID = QryCheckLogin.DocLibOwnerGUID

cfset SESSION.Auth.IsLoggedIn = 'YES'

cfset SESSION.Auth.Admin = '#App_Admin#'

 

I am not locking the above.

 

 

Everything seems to be working when multiple users are on the site (on the
same website or sharing). I also named the Application dynamically by

 

cfset AppName = #ListGetAt(CGI.HTTP_Host,'2','.')#

cfapplication name=DocumentLibrary#AppName#

sessionmanagement=Yes

setclientcookies=Yes

sessiontimeout=#CreateTimeSpan(0,0,30,0)#

applicationtimeout=#CreateTimeSpan(0,0,30,0)#

 

Then I just use cfparam to set variables.

 

cfparam name=App_DataSource default=TheDatabase

cfparam name=App_DataBaseUser default=TheUserName!--- 

cfparam name=App_DataBasePass default=ThePassword

cfparam name=App_Admin default=NO

cfparam name=APP_Path default=#expandPath('../../../../')#

cfparam name=APP_LibraryOwnerURL default=#CGI.HTTP_Host#

 

 

Should I use Application Variables?

 

Should I be locking them?

 

Rick

 

_

From: Jim Davis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 7:36 AM
To: CF-Talk

 

I explain this pretty thoroughly in my guide to CF variables here:

http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V
http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V 
ariables/Index.cfm

I'm sure other people have other (perhaps better) opinions but that
should give you the skinny at least.

Jim Davis

-Original Message-
From: Paul Wilson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 8:08 AM
To: CF-Talk
Subject: Application and Request scope

I've been reading a few threads that advise on storing various things
(that's a technical description btw) in the
application or request scope. Why is this a good idea and what things
should be stored there?

Thanks!
_

[Todays 

_

[Todays 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re[6]: query string recognition

2003-09-30 Thread Ubqtous
Andre,

On 9/29/2003 at 18:45, you wrote:

AT Look in your cgi variables.You may have to parse it out of a string.

The URL parameter does not appear in any of the CGI variables.

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




pass array to CFtag by reference NOT value?

2003-09-30 Thread Gyrus
I know arrays are passed to custom tags via attributes by *value*, not 
reference (as is the case for structures and so on). Is there any way of 
forcing an array to be passed to a custom tag by *reference*?

I'm writing a tag that needs to recursively strip out the descendants of 
hierarchical records (its an array modelling the possibly nested sections 
of a website). I think it needs to recurse (call itself) to do this, and 
obviously you want each recursion to operate on the same array, to 
progressively strip out the children.

At the moment I'm working with the idea of the custom tag relying on the 
array being worked on sitting in the Request scope. This seems OK-ish, but 
obviously it makes the tag much less modular. Any ideas?


Gyrus
[EMAIL PROTECTED]
http://norlonto.net/gyrus/dev/
PGP key available 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Combining Form Fields ?

2003-09-30 Thread Ian Vaughan
I have three form fields that will make up a name, these are Title, Forename and Surname.

Is it possible to combine the contents of these three form fields so it is entered into 1 database field.

So basically is it possible for the form elements below to be entered as 'Mr Ian Vaughan' in the contactname database field ?

tr
td width=15% class=sectionSummaryTitle/td
td width=85%

 select size=1 name=title
option selectedSelect a Title/option
option value=MrMr/option
option value=MrsMrs/option
option value=MsMs/option
option value=DrDr/option
option value=RevRev/option
/select/td
/tr

tr
td width=15% class=sectionSummaryForename/td
td width=85%input name=forename class=mini size=30/td
/tr

tr
td width=15% class=sectionSummarySurname/td
td width=85%input name=surname class=mini size=30/td
/tr
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: pass array to CFtag by reference NOT value?

2003-09-30 Thread Pascal Peters
There is no way of doing that AFAIK
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED] 
Sent: dinsdag 30 september 2003 16:21
To: CF-Talk
Subject: pass array to CFtag by reference NOT value?


I know arrays are passed to custom tags via attributes by *value*, not 
reference (as is the case for structures and so on). Is there any way of

forcing an array to be passed to a custom tag by *reference*?


 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Cookie bug

2003-09-30 Thread John Stanley
I found a bug that some people might not be aware of. If you create a cookie
called DSN in a web application, then the cold fusion administrator
datasource page breaks. We are using CFMX.
 
Just letting you guys know so you dont run into any problems.
 
John Stanley 
Web Application Developer 
www.activeaero.com 



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Combining Form Fields ?

2003-09-30 Thread Tony Weeg
sure.

in your sql just do this...

insert
(fullname)
values
('#form.title# #form.firstname# #form.lastname#') 

hth

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 10:22 AM
To: CF-Talk
Subject: Combining Form Fields ?

I have three form fields that will make up a name, these are Title, Forename
and Surname.

Is it possible to combine the contents of these three form fields so it is
entered into 1 database field.

So basically is it possible for the form elements below to be entered as 'Mr
Ian Vaughan' in the contactname database field ?

tr
td width=15% class=sectionSummaryTitle/td td width=85%

select size=1 name=title
option selectedSelect a Title/option option value=MrMr/option
option value=MrsMrs/option option value=MsMs/option option
value=DrDr/option option value=RevRev/option /select/td /tr

tr
td width=15% class=sectionSummaryForename/td
td width=85%input name=forename class=mini size=30/td /tr

tr
td width=15% class=sectionSummarySurname/td
td width=85%input name=surname class=mini size=30/td /tr



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: pass array to CFtag by reference NOT value?

2003-09-30 Thread Matt Liotta
 I know arrays are passed to custom tags via attributes by *value*, not
 reference (as is the case for structures and so on). Is there any way 
 of
 forcing an array to be passed to a custom tag by *reference*?

Simply wrap the array in a structure.

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.MontaraSoftware.com
(888) 408-0900 x901

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Parameters with cfmail in CFMX

2003-09-30 Thread Ubqtous
Bastian,

On 9/30/2003 at 10:08, you wrote:

BS Is it impossible to use parameters within the cfmail Tag?
BS Or is there somethng wrong in my
BS code?

I am not sure why your code breaks, but MX6.1 now has a cfmailpart tag
that will probably simplify things:

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pb3.htm

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: query string recognition

2003-09-30 Thread McGill, Eric
I can't be certain, but I would say you just can't do it in CF5... You couldn't in ASP2.0, could in 3.0. You can in PHP 4.x and you can in CFMX. I would guess running different app servers on same webserver (IIS5) and OS (win2k) suggests that the appserver of choice is the one to blame (or be credited).
 
Good luck!
Eric
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Combining Form Fields ?

2003-09-30 Thread Pascal Peters
INSERT INTO tbl_contact (contactname,...)
VALUES (
cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.Title#
#form.Forename# #form.Surname#,
...
)
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: dinsdag 30 september 2003 16:22
To: CF-Talk
Subject: Combining Form Fields ?


I have three form fields that will make up a name, these are Title,
Forename and Surname.

Is it possible to combine the contents of these three form fields so it
is entered into 1 database field.

So basically is it possible for the form elements below to be entered as
'Mr Ian Vaughan' in the contactname database field ?

tr
td width=15% class=sectionSummaryTitle/td
td width=85%

select size=1 name=title
option selectedSelect a Title/option
option value=MrMr/option
option value=MrsMrs/option
option value=MsMs/option
option value=DrDr/option
option value=RevRev/option
/select/td
/tr

tr
td width=15% class=sectionSummaryForename/td
td width=85%input name=forename class=mini size=30/td
/tr

tr
td width=15% class=sectionSummarySurname/td
td width=85%input name=surname class=mini size=30/td
/tr 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re[2]: query string recognition

2003-09-30 Thread Ubqtous
Eric,

On 9/30/2003 at 10:32, you wrote:

ME I can't be certain, but I would say you just can't do it in CF5...
ME You couldn't in ASP2.0, could in 3.0. You can in PHP 4.x and you
ME can in CFMX. I would guess running different app servers on same
ME webserver (IIS5) and OS (win2k) suggests that the appserver of
ME choice is the one to blame (or be credited).

I can live with that! I just wanted to make sure I wasn't doing
anything wrong code-wise.

Any idea if it's syntactically valid to append a query string with no
file name ( foo.com/?bar= )? I am guessing so, but then again maybe
it's just tolerated.

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Parameters with cfmail in CFMX

2003-09-30 Thread Tim Blair
 Is it impossible to use parameters within the cfmail Tag?
 Or is there somethng wrong in my code?

If you're using MX6.1 then there is an incompatibility with the old
way of sending multipart mails (as you are doing it) and with the new
cfmailpart tag.

http://tech.badpen.com/index.cfm?mode=entryentry=2

HTH,

Tim.


---
OUR NEW SITE IS NOW LIVE
Visit our new website at http://www.rawnet.com/ and
race around the beautiful Bracknell streets at
http://xmas.rawnet.com/
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




re: Getting information from another website

2003-09-30 Thread Jerry Johnson
If all you want is for the page to pop up with your info, just bookmark the following link (watch the wrap)

http://allplayers.bladenet.net/allplayers/schedulesDisplay.do?associationCode=CA0309seasonNumber=0scheduleGroupAssociationCode=CA0309scheduleGroupNumber=1scheduleNumber=20startMonth=9startDay=23endMonth=10endDay=13 


You will want to change the startmonth and startday and endmonth and endday as needed.

Jerry Johnson

 [EMAIL PROTECTED] 09/30/03 09:46AM 
Hi,

I would like to know if this is possible. Every week I go to this website that has the schedule for my sons hockey. 

http://allplayers.bladenet.net/allplayers/schedules.do?associationCode=CA0309seasonNumber=0scheduleGroupCode=CA0309-1 

>From here I select the start/end from the dropdown menu and division which is Minor Ataom Blue and then click on Go to get the schedule.

Is it possible to create a CF template that grabs all this information automatically behind the scenes so I can just add a link on my desktop that would popup the weekly 
schedule?





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: query string recognition

2003-09-30 Thread McGill, Eric
[McGill, Eric] Only some versions of app servers will see those vars. Also, some that do allow you to do that will not recognize the query string on post requests - so you can do it on everything until you submit a form, then you have to specify a filename that you're posting to. I'm not sure if this behavior is also dependent upon the appserver. Either way, just have to test in the version you'll be running the app on.
Any idea if it's syntactically valid to append a query string with no
file name ( foo.com/?bar= )? I am guessing so, but then again maybe
it's just tolerated.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: pass array to CFtag by reference NOT value?

2003-09-30 Thread Gyrus
At 10:27 30/09/2003 -0400, you wrote:
Simply wrap the array in a structure.

I'm missing the obvious today... Thanks.

Gyrus
[EMAIL PROTECTED]
http://norlonto.net/gyrus/dev/
PGP key available 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Parameters with cfmail in CFMX

2003-09-30 Thread Bastian Schmid
It works now!
Thanks a lot!

Greez,
Bastian
- Original Message - 
From: Tim Blair 
To: CF-Talk 
Sent: Tuesday, September 30, 2003 4:09 PM
Subject: RE: Parameters with cfmail in CFMX


 Is it impossible to use parameters within the cfmail Tag?
 Or is there somethng wrong in my code?

If you're using MX6.1 then there is an incompatibility with the old
way of sending multipart mails (as you are doing it) and with the new
cfmailpart tag.

http://tech.badpen.com/index.cfm?mode=entryentry=2

HTH,

Tim.


---
OUR NEW SITE IS NOW LIVE
Visit our new website at http://www.rawnet.com/ and
race around the beautiful Bracknell streets at
http://xmas.rawnet.com/
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Application and Request scope

2003-09-30 Thread Mike Brunt
Rick, you should lock Application, Server and Session variables.Session
because if you use Frames or if you have slow running requests users can
launch more than one thread which can cause memory corruption.

Here is how those three scopes are seen: -

SERVER – By all CFAPPLICATIONs on a single physical server.

APPLICATION – By all users in a single CFAPPLICATION

SESSION – By a single user in a single Session.

I have another suggestion go to our blog at http://www.webapper.net
http://www.webapper.net/and search for CFLOCK you will find a few
pointers there that may help.

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper Web Application Specialists

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 6:37 AM
To: CF-Talk
Subject: RE: Application and Request scope

I read this and now I am questioning my Application.



I have been building a document Library system. The Application is shared
between all the sites using it by Virtual Directories.



I use session variables in the login.cfm to set the User information (GUID,
Directory, IsAdmin) after login authentication.



cfset SESSION.Auth = StructNew()

cfset SESSION.Auth.Email = QryCheckLogin.Email

cfset SESSION.Auth.UserGUID = QryCheckLogin.UserGUID

cfset SESSION.Auth.LibraryGUID = QryCheckLogin.DocLibOwnerGUID

cfset SESSION.Auth.IsLoggedIn = 'YES'

cfset SESSION.Auth.Admin = '#App_Admin#'



I am not locking the above.





Everything seems to be working when multiple users are on the site (on the
same website or sharing). I also named the Application dynamically by



cfset AppName = #ListGetAt(CGI.HTTP_Host,'2','.')#

cfapplication name=DocumentLibrary#AppName#

sessionmanagement=Yes

setclientcookies=Yes

sessiontimeout=#CreateTimeSpan(0,0,30,0)#

applicationtimeout=#CreateTimeSpan(0,0,30,0)#



Then I just use cfparam to set variables.



cfparam name=App_DataSource default=TheDatabase

cfparam name=App_DataBaseUser default=TheUserName!---

cfparam name=App_DataBasePass default=ThePassword

cfparam name=App_Admin default=NO

cfparam name=APP_Path default=#expandPath('../../../../')#

cfparam name=APP_LibraryOwnerURL default=#CGI.HTTP_Host#





Should I use Application Variables?



Should I be locking them?



Rick



_

From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 7:36 AM
To: CF-Talk



I explain this pretty thoroughly in my guide to CF variables here:

http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V
 http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V
http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Guides/V%3E

ariables/Index.cfm

I'm sure other people have other (perhaps better) opinions but that
should give you the skinny at least.

Jim Davis

-Original Message-
From: Paul Wilson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 8:08 AM
To: CF-Talk
Subject: Application and Request scope

I've been reading a few threads that advise on storing various things
(that's a technical description btw) in the
application or request scope. Why is this a good idea and what things
should be stored there?

Thanks!
_

[Todays

_

[Todays
_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Using getPageContext().forward()

2003-09-30 Thread Dave Carabetta
I'm using Client variables with getPageContext().forward() and I'm running 
into a problem where Client variables I set on the first page do not exist 
on the page that I forward to. I'm wondering whether or not this is expected 
behavior. Here's a small test snippet to reproduce:

test1.cfm
-
cfset Client.test1 = Pre-Forward

cfscript
getPageContext().forward(test2.cfm);
/cfscript

test2.cfm
-
cfdump var=#Client#

As you can (hopefully) see by the results, test1 is not present in the 
Client scope when I forward(). However, it does exist if I am using 
cflocation to pass from one template to the next. Since these are two 
back-end templates, I was hoping to use the server-side forward() instead of 
the client-side cflocation.

I'm using MX 6.1 on Solaris using the internal JWS.

Any confirmation of this behaviour, expected or otherwise, is appreciated.

Regards,
Dave.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Combining Form Fields ?

2003-09-30 Thread A.Little
It usually best not to store data like this in one field though, rather
store it in the 3 seperate fields and combine them in the query when you
extract the data from the database or in your application. You may find in
the future that you need to get 'Mr Smith' rather than 'Mr John Smith' from
the database, and this can be a right pain if you're storing all the data in
one field.
HTH
Alex

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED] 
Sent: 30 September 2003 15:30
To: CF-Talk
Subject: RE: Combining Form Fields ?


INSERT INTO tbl_contact (contactname,...)
VALUES (
cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.Title#
#form.Forename# #form.Surname#,
...
)
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: dinsdag 30 september 2003 16:22
To: CF-Talk
Subject: Combining Form Fields ?


I have three form fields that will make up a name, these are Title,
Forename and Surname.

Is it possible to combine the contents of these three form fields so it
is entered into 1 database field.

So basically is it possible for the form elements below to be entered as
'Mr Ian Vaughan' in the contactname database field ?

tr
td width=15% class=sectionSummaryTitle/td
td width=85%

select size=1 name=title
option selectedSelect a Title/option
option value=MrMr/option
option value=MrsMrs/option
option value=MsMs/option
option value=DrDr/option
option value=RevRev/option
/select/td
/tr

tr
td width=15% class=sectionSummaryForename/td
td width=85%input name=forename class=mini size=30/td
/tr

tr
td width=15% class=sectionSummarySurname/td
td width=85%input name=surname class=mini size=30/td
/tr 
_


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Displaying links on a page

2003-09-30 Thread Deetra Whatley
Good Day, 

How do I create horizontal Links in ColdFusion? 

I would like to display links like this: 
Links First  Second  Third  Fourth. 

Is there a way that ColdFusion know what page I am on and can display the text for the the active link - the last link.Am I supposed to use the url variable.

What am I doing wrong?Can someone help me please use CF to display the horizontal links bar so that I do not have to type (copy) the links on every page. 

Thank you so very much.

Deetra Whatley
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Displaying links on a page

2003-09-30 Thread Tony Weeg
your looking for whats called a Bread Crumb Trail of links, and there are
many ways to do it...some do it by next id in succession from query results.
some do it based on values in the url string, some do it based on a parentID
in a database so if you know the id of the product you are showing on a
page, you can make a db call to get the parent categoryId and make it work
that way.

there are options :)

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Deetra Whatley [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 11:13 AM
To: CF-Talk
Subject: Displaying links on a page

Good Day, 

How do I create horizontal Links in ColdFusion? 

I would like to display links like this: 
Links First  Second  Third  Fourth. 

Is there a way that ColdFusion know what page I am on and can display the
text for the the active link - the last link.Am I supposed to use the url
variable.

What am I doing wrong?Can someone help me please use CF to display the
horizontal links bar so that I do not have to type (copy) the links on every
page. 

Thank you so very much.

Deetra Whatley



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: IIS not rendering ASP?

2003-09-30 Thread Shawn Grover
We have a web server that has been setup for virtual hosting.But for some
reason it is refusing to interpret the ASP files.A request for an ASP file
results in the text of the file being passed to the client, with no server
side processing.

We have searched MSDN, and the official solution is to install service
pack 1.The server already has the latest SP installed, so this should not
be the issue.We are scouring the web for any tips, but haven't found
anything that works ye (found a few promising suggestions, but they didn't
do the trick).We need to get the virtual hosting working and stable before
we install CFMX - we have a need for both CFMX and ASP.

Any tips are welcomed.Thanks in advance.

Shawn
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: IIS not rendering ASP?

2003-09-30 Thread Bryan Stevenson
A..the ASP files know that CFMX is coming and they're running scaredthey must be hiding ;-)

Couldn't resistgetting weirdbeen in the the war room for weeks working on a big technical design document ;-)

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Shawn Grover 
To: CF-Talk 
Sent: Tuesday, September 30, 2003 8:29 AM
Subject: OT: IIS not rendering ASP?


We have a web server that has been setup for virtual hosting.But for some
reason it is refusing to interpret the ASP files.A request for an ASP file
results in the text of the file being passed to the client, with no server
side processing.

We have searched MSDN, and the official solution is to install service
pack 1.The server already has the latest SP installed, so this should not
be the issue.We are scouring the web for any tips, but haven't found
anything that works ye (found a few promising suggestions, but they didn't
do the trick).We need to get the virtual hosting working and stable before
we install CFMX - we have a need for both CFMX and ASP.

Any tips are welcomed.Thanks in advance.

Shawn

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS not rendering ASP?

2003-09-30 Thread McGill, Eric
First thing I would do is go into IIS control panel and confirm that the extension *.asp is mapped to asp.dll under the properties for that particular website. I'm sorry not to be able to tell you which tab it is - I'm not near a box with IIS running - but I think it is under the Configuration button, then one of the tabs that is in the next form. If you're lucky enough for this to be the problem, just add the mapping there... (Hit Add  Enter ASP in the extension field  Browse to ASP.DLL)
Good luck,
Eric

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]


A request for an ASP file results in the text of the file being passed to the client, with no server
side processing.



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Combining Form Fields ?

2003-09-30 Thread Deanna Schneider
Ian,
I know someone mentioned it already, but it's best to store each piece in a
separate field. Then, if you want to have the fullname when you query the
db, you can do something like this:

SELECT title || ' ' || forename || ' ' || surname AS fullname
FROM yourtable

(That's the oracle syntax. I think SQL server uses  instead of || to
concantenate...)

-Deanna

- Original Message - 
From: Ian Vaughan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:22 AM
Subject: Combining Form Fields ?


 I have three form fields that will make up a name, these are Title,
Forename and Surname.

 Is it possible to combine the contents of these three form fields so it is
entered into 1 database field.

 So basically is it possible for the form elements below to be entered as
'Mr Ian Vaughan' in the contactname database field ?

 tr
 td width=15% class=sectionSummaryTitle/td
 td width=85%

select size=1 name=title
 option selectedSelect a Title/option
 option value=MrMr/option
 option value=MrsMrs/option
 option value=MsMs/option
 option value=DrDr/option
 option value=RevRev/option
 /select/td
 /tr

 tr
 td width=15% class=sectionSummaryForename/td
 td width=85%input name=forename class=mini size=30/td
 /tr

 tr
 td width=15% class=sectionSummarySurname/td
 td width=85%input name=surname class=mini size=30/td
 /tr

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:Flash date format problem

2003-09-30 Thread Kay Smoljak
Thanks Eric,

I had started doing that, but I was hoping to avoid the brute force approach :) 

Someone on another mailing list posted this link, which fixed the problem:
http://www.darronschall.com/weblog/archives/40.cfm

Cheers,
Kay.

Worst case scenario, you can parse that thing out to a date format you 
know cf likes: snip

 I'm working on a Flash remoting app, and I need to pass a list of 
 dates from the Flash calendar component to a CFC. I'm having some 
 problems with date formats. snip






Flash is sending dates as strings like this: Mon Mar 10 00:00:00 
GMT+0800 2003

In my CFC, when I run the following statements:
#CreateODBCDateTime(Mon Mar 10 00:00:00 GMT+0800 2003)#br
#DateFormat(Mon Mar 10 00:00:00 GMT+0800 2003,'dd/mm/')#br
#ParseDateTime(Mon Mar 10 00:00:00 GMT+0800 2003)#

I get the following results:
{ts '2000-03-10 00:00:00'}
10/03/2000
{ts '2000-03-10 00:00:00'} 

That is, the 10th of March 2000 NOT the 10th of March 2003.

Any ideas on what I need to do to return the correct year?

TIA,
Kay.


_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Drawing diagonal lines

2003-09-30 Thread Barney Boisvert
You might look into SVG.It's an XML-based vector graphics plugin, somewhat
similar to Flash.However, since it's all XML, it's a snap to generate with
CF.My company uses it internally for graphing and plotting all kinds of
stuff.The only downside is that the plugin is over 2MB, but that's a one
time cost.

barneyb
-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 6:55 AM
To: CF-Talk
Subject: Drawing diagonal lines


I am using html and CF to dynamically draw rectangular wall modules
based upon user input. I am using a scale of 1.5 pixels = 1 inch. I really
would like to come up with a way of displaying the roof slope as well,
but have been unsuccessful so far in drawing a diagonal line that I
can display on the screen as well as send to the printer. I failed in my
attempts to use dhtml layers as it displayed properly on the screen, but
printed incorrectly.

If anyone could offer some suggestions I would appreciate it.

Terry Troxel

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SES and URL Rewrite

2003-09-30 Thread Michael Dinowitz
In Website and CFMX I use this ugly code:

function SES()
{
 var SESUrlVars=RemoveChars(CGI.path_Info, 1, 1);
 var SESloopcount=ListLen(SESurlvars, '');
 // If these are the same, then nothing important is on the url
 if (script_name EQ path_info)
return 1;

 for(i=1;i LTE SESloopcount; i=i+1)
Url.#listfirst(listgetat(SESUrlVars, i, ''),
'=')#=listlast(listgetat(SESUrlVars, i, ''), '=');
 return 1;
 }

This may not work in IIS, but the concept is there. Take an url where the
question mark is replaces with a slash and work from there. For example, the url
below would normally have the question mark between the .cfm and method.
http://www.houseoffusion.com/cf_lists/index.cfm/method=threadsforumid=4displaydate=09/30/2003

Note that some go hog wild with this concept and place slashes everywhere. Not
needed. Just one will do it for you.

 Hi,
 I am also looking for something but. I want to know that for
 eg:
 if my URL is:

 http://www.abc.com/info.cfm?ArticleID=3043

 can I rewrite the URL as

 http://www.abc.com/info/ArticleID/3043

 If you notice that I replaced info.cfm by info , means I want to remove the
 file extension.
 Let me know if this is possible, I know in Apache there is something like
 this.

 Thanks,


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Drawing diagonal lines

2003-09-30 Thread Jerry Johnson
A poorly thought out idea follows:

What if you had two gifs containing diagnal lines in a transarent image.


\and/

10 pixels by 10 pixels.

First, decide whether the slope is positive or negative.

Then, just set the image display size to the rise and run of your needed slope, and you have a diagnal line.

(This assumes you dont need to draw anything under the slope.)

Just a thought.

Jerry Johnson

 [EMAIL PROTECTED] 09/30/03 12:18PM 
You might look into SVG.It's an XML-based vector graphics plugin, somewhat
similar to Flash.However, since it's all XML, it's a snap to generate with
CF.My company uses it internally for graphing and plotting all kinds of
stuff.The only downside is that the plugin is over 2MB, but that's a one
time cost.

barneyb
-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 6:55 AM
To: CF-Talk
Subject: Drawing diagonal lines


I am using html and CF to dynamically draw rectangular wall modules
based upon user input. I am using a scale of 1.5 pixels = 1 inch. I really
would like to come up with a way of displaying the roof slope as well,
but have been unsuccessful so far in drawing a diagonal line that I
can display on the screen as well as send to the printer. I failed in my
attempts to use dhtml layers as it displayed properly on the screen, but
printed incorrectly.

If anyone could offer some suggestions I would appreciate it.

Terry Troxel


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Drawing diagonal lines

2003-09-30 Thread Terry Troxel
Barney,

I have the SVG plugin plugged in, but have not used it.
Any chance you could point me at some examples, tutorials,
etc. The application I am building will be running on an intranet
so the 2 meg plugin size is not a downside. I have all the required
dimensions already being saved into a database so your idea
sounds like just what the doctor ordered if it can print as well as
display.

Terry
- Original Message - 
From: Barney Boisvert 
To: CF-Talk 
Sent: Tuesday, September 30, 2003 9:18 AM
Subject: RE: Drawing diagonal lines


You might look into SVG.It's an XML-based vector graphics plugin, somewhat
similar to Flash.However, since it's all XML, it's a snap to generate with
CF.My company uses it internally for graphing and plotting all kinds of
stuff.The only downside is that the plugin is over 2MB, but that's a one
time cost.

barneyb
 -Original Message-
 From: Terry Troxel [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 30, 2003 6:55 AM
 To: CF-Talk
 Subject: Drawing diagonal lines


 I am using html and CF to dynamically draw rectangular wall modules
 based upon user input. I am using a scale of 1.5 pixels = 1 inch. I really
 would like to come up with a way of displaying the roof slope as well,
 but have been unsuccessful so far in drawing a diagonal line that I
 can display on the screen as well as send to the printer. I failed in my
 attempts to use dhtml layers as it displayed properly on the screen, but
 printed incorrectly.

 If anyone could offer some suggestions I would appreciate it.

 Terry Troxel


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Re[2]: query string recognition

2003-09-30 Thread Dave Watts
 Any idea if it's syntactically valid to append a query 
 string with no file name ( foo.com/?bar= )? I am guessing 
 so, but then again maybe it's just tolerated.

According to this:

ftp://ftp.rfc-editor.org/in-notes/rfc1738.txt

the path and searchpart are both optional, and it appears you can have
either one without the other.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS not rendering ASP?

2003-09-30 Thread Shawn Grover
Thanks, we've checked that the ASP.dll was setup.But still no luck.
(setting up on the ISAPI tab causes the site to not work at all, but it IS
listed under the Home Directory tab / Configuration button).Navigating
to the virtual server, we get the text of the iisstart.asp file. (The site
documents are set for default.html and index.html - no mention of
iisstart.asp.)Navigating to a user created asp page (which we know works
fine) causes either the same type of behaviour, orHTTP 403.1 Forbidden:
Execute Access Forbidden - and we have checked all the security settings,
reset the permissions, and ensured Script and Execute access was turned
on...This is a weird one, I'm almost tempted to rip out IIS and put in
Apache, but I'd get shot for that.
 
Thanks for the tip.Any others?
 
Shawn

-Original Message-
From: McGill, Eric [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:50 AM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


First thing I would do is go into IIS control panel and confirm that the
extension *.asp is mapped to asp.dll under the properties for that
particular website. I'm sorry not to be able to tell you which tab it is -
I'm not near a box with IIS running - but I think it is under the
Configuration button, then one of the tabs that is in the next form. If
you're lucky enough for this to be the problem, just add the mapping
there... (Hit Add  Enter ASP in the extension field  Browse to ASP.DLL)
Good luck,
Eric

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]


A request for an ASP file results in the text of the file being passed to
the client, with no server
side processing.



_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS not rendering ASP?

2003-09-30 Thread DURETTE, STEVEN J (AIT)
By any chance was the iis lockdown tool run on this and set to stop asp?
 
You might want to rerun the tool and ensure that asp is allowed.
 
Steve
 

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:37 PM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


Thanks, we've checked that the ASP.dll was setup.But still no luck.
(setting up on the ISAPI tab causes the site to not work at all, but it IS
listed under the Home Directory tab / Configuration button).Navigating
to the virtual server, we get the text of the iisstart.asp file. (The site
documents are set for default.html and index.html - no mention of
iisstart.asp.)Navigating to a user created asp page (which we know works
fine) causes either the same type of behaviour, orHTTP 403.1 Forbidden:
Execute Access Forbidden - and we have checked all the security settings,
reset the permissions, and ensured Script and Execute access was turned
on...This is a weird one, I'm almost tempted to rip out IIS and put in
Apache, but I'd get shot for that.

Thanks for the tip.Any others?

Shawn

-Original Message-
From: McGill, Eric [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:50 AM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


First thing I would do is go into IIS control panel and confirm that the
extension *.asp is mapped to asp.dll under the properties for that
particular website. I'm sorry not to be able to tell you which tab it is -
I'm not near a box with IIS running - but I think it is under the
Configuration button, then one of the tabs that is in the next form. If
you're lucky enough for this to be the problem, just add the mapping
there... (Hit Add  Enter ASP in the extension field  Browse to ASP.DLL)
Good luck,
Eric

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]


A request for an ASP file results in the text of the file being passed to
the client, with no server
side processing.



_

[ Todays Threads 
_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS not rendering ASP?

2003-09-30 Thread Shawn Grover
The lockdown tool wasn't explitly run, but it might have run as part of
service pack 4.We'll try running the tool manually and see what happens.
Thanks.

-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 10:44 AM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


By any chance was the iis lockdown tool run on this and set to stop asp?

You might want to rerun the tool and ensure that asp is allowed.

Steve


-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:37 PM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


Thanks, we've checked that the ASP.dll was setup.But still no luck.
(setting up on the ISAPI tab causes the site to not work at all, but it IS
listed under the Home Directory tab / Configuration button).Navigating
to the virtual server, we get the text of the iisstart.asp file. (The site
documents are set for default.html and index.html - no mention of
iisstart.asp.)Navigating to a user created asp page (which we know works
fine) causes either the same type of behaviour, orHTTP 403.1 Forbidden:
Execute Access Forbidden - and we have checked all the security settings,
reset the permissions, and ensured Script and Execute access was turned
on...This is a weird one, I'm almost tempted to rip out IIS and put in
Apache, but I'd get shot for that.

Thanks for the tip.Any others?

Shawn

-Original Message-
From: McGill, Eric [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:50 AM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


First thing I would do is go into IIS control panel and confirm that the
extension *.asp is mapped to asp.dll under the properties for that
particular website. I'm sorry not to be able to tell you which tab it is -
I'm not near a box with IIS running - but I think it is under the
Configuration button, then one of the tabs that is in the next form. If
you're lucky enough for this to be the problem, just add the mapping
there... (Hit Add  Enter ASP in the extension field  Browse to ASP.DLL)
Good luck,
Eric

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]


A request for an ASP file results in the text of the file being passed to
the client, with no server
side processing.



_

[ Todays Threads 
_

[ Todays Threads 
_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFFILE wordperfect MIME type

2003-09-30 Thread Tim Laureska
Hello... can anyone tell me what the mime type should be for wordperfect
in referencing acceptable file types in CFFILE ... Is it as simple as
application/wordperfector are there separate references for
different versions?

TIA
Tim 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS not rendering ASP?

2003-09-30 Thread Dave Watts
 The lockdown tool wasn't explitly run, but it might have run 
 as part of service pack 4. We'll try running the tool manually 
 and see what happens. Thanks.

The IIS Lockdown tool isn't run unless you do it explicitly. Also, what it
does, if I recall correctly, is that it removes the ISAPI extensions, so if
you go into the IIS MMC and see the extensions, they either weren't removed,
or they were reentered manually after running IIS Lockdown.

However, it's possible that you're using URLScan, and you have urlscan.ini
written in such a way that ASP requests are denied.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS not rendering ASP?

2003-09-30 Thread DURETTE, STEVEN J (AIT)
Shawn,
 
Also, you might want to try going to iislists.com.There is a lot of
information there and you can sign up for the list you need (iis4, iis5,
iis6).
 
The people on that list really seem to know IIS.And Brett (the guy who
runs the list) is a professional IIS trainer.
 
Steve
 

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:56 PM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


The lockdown tool wasn't explitly run, but it might have run as part of
service pack 4.We'll try running the tool manually and see what happens.
Thanks.

-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 10:44 AM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


By any chance was the iis lockdown tool run on this and set to stop asp?

You might want to rerun the tool and ensure that asp is allowed.

Steve


-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:37 PM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


Thanks, we've checked that the ASP.dll was setup.But still no luck.
(setting up on the ISAPI tab causes the site to not work at all, but it IS
listed under the Home Directory tab / Configuration button).Navigating
to the virtual server, we get the text of the iisstart.asp file. (The site
documents are set for default.html and index.html - no mention of
iisstart.asp.)Navigating to a user created asp page (which we know works
fine) causes either the same type of behaviour, orHTTP 403.1 Forbidden:
Execute Access Forbidden - and we have checked all the security settings,
reset the permissions, and ensured Script and Execute access was turned
on...This is a weird one, I'm almost tempted to rip out IIS and put in
Apache, but I'd get shot for that.

Thanks for the tip.Any others?

Shawn

-Original Message-
From: McGill, Eric [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:50 AM
To: CF-Talk
Subject: RE: IIS not rendering ASP?


First thing I would do is go into IIS control panel and confirm that the
extension *.asp is mapped to asp.dll under the properties for that
particular website. I'm sorry not to be able to tell you which tab it is -
I'm not near a box with IIS running - but I think it is under the
Configuration button, then one of the tabs that is in the next form. If
you're lucky enough for this to be the problem, just add the mapping
there... (Hit Add  Enter ASP in the extension field  Browse to ASP.DLL)
Good luck,
Eric

-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]


A request for an ASP file results in the text of the file being passed to
the client, with no server
side processing.



_

[ Todays Threads 
_

[ Todays Threads 
_

[ Todays Threads 
_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




cfqueryparam and NULL values (SELECT)

2003-09-30 Thread Charlie Griefer
Hey all..

trying to do the following query:

SELECT *
FROM tblCheckout
WHERE 
 videoID = cfqueryparam value=#URL.videoID# cfsqltype=cf_sql_integer AND
 actual_returndate = cfqueryparam value= cfsqltype=cf_sql_date null=yes 

i'm getting 0 records returned, where I know there is 1 record that matches the criteria.

I'm getting hung up on the actual_returndate value, where i'm searching for a NULL.

it works without cfqueryparam:

SELECT *
FROM tblCheckout
WHERE 
 videoID = cfqueryparam value=#URL.videoID# cfsqltype=cf_sql_integer AND
 actual_returndate IS NULL

returns the record i'm looking for.

Am I using cfqueryparam wrong here?

Thx!
Charlie
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




MagickTag

2003-09-30 Thread Greg Luce
Anyone have experience using MagickTag by Alagad? I've used it to resize
uploaded images with success, but having a hard time creating images
with text or combined images. The documentation isn't really clear on
the usage for these functions. Anyone have any sample code they've used
to lay text on images or combine images to create something like a
banner ad?

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfqueryparam and NULL values (SELECT)

2003-09-30 Thread Dave Watts
 trying to do the following query:
 
 SELECT *
 FROM tblCheckout
 WHERE 
videoID = cfqueryparam value=#URL.videoID# 
 cfsqltype=cf_sql_integer AND
actual_returndate = cfqueryparam value= 
 cfsqltype=cf_sql_date null=yes 
 
 i'm getting 0 records returned, where I know there is 1 
 record that matches the criteria.
 
 I'm getting hung up on the actual_returndate value, where 
 i'm searching for a NULL.
 
 it works without cfqueryparam:
 
 SELECT *
 FROM tblCheckout
 WHERE 
videoID = cfqueryparam value=#URL.videoID# 
 cfsqltype=cf_sql_integer AND
actual_returndate IS NULL
 
 returns the record i'm looking for.
 
 Am I using cfqueryparam wrong here?

If you know that you want to retrieve only records where actual_returndate
is NULL, there's no need to use CFQUERYPARAM there - just use
actual_returndate IS NULL. The NULL attribute of CFQUERYPARAM is useful
when you don't know whether the value should be NULL until runtime, in which
case you can do something like this:

WHERE field = cfqueryparam value=#Form.foo# cfsqltype=cf_sql_whatever
null=#YesNoFormat(NOT Len(Trim(Form.foo))#

However, not all databases allow you to use NULL in an equality comparison;
in those cases you need to use the IS operator instead, which would lead to
something like this:

cfset bFooNotNull = Len(Trim(Form.foo))
...
WHERE field cfif bFooNotNull = cfqueryparam ... cfelse IS NULL /cfif

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Drawing diagonal lines

2003-09-30 Thread Barney Boisvert
We didn't build stuff specific for printing, but I've printed graphs out
without a problem, and I know other people have as well, with no complaints,
so it works.

I found very limited help online for getting started, but the grammar is
pretty simple for just drawing stuff.The Adobe site
(http://www.adobe.com/svg/basics/intro.html) has some good basic
information, and then I pretty much just worked from the W3C spec
(http://www.w3.org/Graphics/SVG/).Unfortunately, Freehand doesn't seem to
think SVG is worthwhile enough to be able to export it, but oh well.

cheers,
barneyb
-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:32 AM
To: CF-Talk
Subject: Re: Drawing diagonal lines


Barney,

I have the SVG plugin plugged in, but have not used it.
Any chance you could point me at some examples, tutorials,
etc. The application I am building will be running on an intranet
so the 2 meg plugin size is not a downside. I have all the required
dimensions already being saved into a database so your idea
sounds like just what the doctor ordered if it can print as well as
display.

Terry
 - Original Message -
 From: Barney Boisvert
 To: CF-Talk
 Sent: Tuesday, September 30, 2003 9:18 AM
 Subject: RE: Drawing diagonal lines


 You might look into SVG.It's an XML-based vector graphics plugin,
somewhat
 similar to Flash.However, since it's all XML, it's a snap to generate
with
 CF.My company uses it internally for graphing and plotting all kinds
of
 stuff.The only downside is that the plugin is over 2MB, but that's a
one
 time cost.

 barneyb
-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 6:55 AM
To: CF-Talk
Subject: Drawing diagonal lines


I am using html and CF to dynamically draw rectangular wall modules
based upon user input. I am using a scale of 1.5 pixels = 1 inch. I
really
would like to come up with a way of displaying the roof slope as well,
but have been unsuccessful so far in drawing a diagonal line that I
can display on the screen as well as send to the printer. I failed in
my
attempts to use dhtml layers as it displayed properly on the screen,
but
printed incorrectly.

If anyone could offer some suggestions I would appreciate it.

Terry Troxel



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfqueryparam and NULL values (SELECT)

2003-09-30 Thread Barney Boisvert
CFQUERYPARAM is only useful for dynamic information.It makes the
statements faster with most DBMSs (using prepared statements), and also
provides a level of security, because it prevents SQL injection attacks.
For any hard coded values (numbers, strings, whatever), you can use
CFQUERYPARAM if you want, but it's unnecessary.NULL is a special case.
There is no way to use CFQUERYPARAM to pass a NULL to the database, so for
that 'value' (and that value alone) you HAVE to use it directly.A good
tip-off is that the entire comparison is IS NULL or IS NOT NULL, so
you'd actually have to pass multiple keywords.

So, the second form of the query you provided is the correct form, and the
only one that'll work.

barneyb
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 10:08 AM
To: CF-Talk
Subject: cfqueryparam and NULL values (SELECT)


Hey all..

trying to do the following query:

SELECT *
FROM tblCheckout
WHERE
videoID = cfqueryparam value=#URL.videoID#
cfsqltype=cf_sql_integer AND
actual_returndate = cfqueryparam value= cfsqltype=cf_sql_date
null=yes

i'm getting 0 records returned, where I know there is 1 record that
matches the criteria.

I'm getting hung up on the actual_returndate value, where i'm searching
for a NULL.

it works without cfqueryparam:

SELECT *
FROM tblCheckout
WHERE
videoID = cfqueryparam value=#URL.videoID#
cfsqltype=cf_sql_integer AND
actual_returndate IS NULL

returns the record i'm looking for.

Am I using cfqueryparam wrong here?

Thx!
Charlie

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfqueryparam and NULL values (SELECT)

2003-09-30 Thread Dave Watts
 There is no way to use CFQUERYPARAM to pass a NULL to the 
 database, so for that 'value' (and that value alone) you 
 HAVE to use it directly.

This may be true sometimes, but isn't always true. That's why CFQUERYPARAM
has a NULL attribute - for exactly those cases. Some databases do allow the
use of NULL with the equality operator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




mailserver suggestions (outgoing)

2003-09-30 Thread chris petersen
I'm looking for a new outgoing mailserver (preferably free) to work with
coldfusion for relaying outgoing mail. I'm currently using Postcast -
it's been great for a year or so, but all of a sudden it keeps crashing,
and I don't know what to do short of replacing it.
 
Any good suggestions for a new mserver? I just need something coldfusion
can connect to and send mail through.
 
TIA,
 
Chris

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need better CFX tag instead of CFHTTP tag.

2003-09-30 Thread Tom Jordahl
 

I would certainly be interested in hearing why the CFMX 6.1 CFHTTP tag does not meet your needs.

 

--
Tom Jordahl
Macromedia Server Development

-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 7:55 AM
To: CF-Talk
Subject: RE: Need better CFX tag instead of CFHTTP tag. 

 

Hi,
I am on CF5.0 but soon will be moving to CFMX. Regarding the COM object is
there anysite I cna find more on that.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.comhttp://www.g3group.com http://www.g3group.com%3e 


-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 7:45 AM
To: CF-Talk
Subject: RE: Need better CFX tag instead of CFHTTP tag.


 I am looaking for a good CFX tag which resolves URL redirects and all.
I
 need CFX http tag which resolves url redirects at server level means
IIS
 redirects and all. Also returns me header information with the page
content.
 Eg: www.compaq.com which redirects to new hp site.
 Please suggest me a good CFX tag which will help me. I tird using
cfx_http
 but its not giving me what I want.

Which version of CF are you running? CFMX has a lot better CFHTTP
control than CF5 or less






_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfqueryparam and NULL values (SELECT)

2003-09-30 Thread DURETTE, STEVEN J (AIT)
Another place where the null attribute comes in handy is for inserts where
you may or may not have data to insert.
 
That's generally what I use it for.If I'm checking for NULL, I usually use
IS NULL.
 
Steve
 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 1:33 PM
To: CF-Talk
Subject: RE: cfqueryparam and NULL values (SELECT)


 There is no way to use CFQUERYPARAM to pass a NULL to the 
 database, so for that 'value' (and that value alone) you 
 HAVE to use it directly.

This may be true sometimes, but isn't always true. That's why CFQUERYPARAM
has a NULL attribute - for exactly those cases. Some databases do allow the
use of NULL with the equality operator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ http://www.figleaf.com/ 
voice: (202) 797-5496
fax: (202) 797-5444

_

[ Todays Threads 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfqueryparam and NULL values (SELECT)

2003-09-30 Thread Barney Boisvert
Well, learn something new every day.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 10:33 AM
To: CF-Talk
Subject: RE: cfqueryparam and NULL values (SELECT)


 There is no way to use CFQUERYPARAM to pass a NULL to the
 database, so for that 'value' (and that value alone) you
 HAVE to use it directly.

This may be true sometimes, but isn't always true. That's why CFQUERYPARAM
has a NULL attribute - for exactly those cases. Some databases do allow
the
use of NULL with the equality operator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: cfqueryparam and NULL values (SELECT)

2003-09-30 Thread Charlie Griefer
ok cool.

I knew that just hard-coding the IS NULL would be ok...but I thought that consistently using the cfqueryparam would be...better.And knowing about the NULL attribute of the tag (thanks to Dave's article up on MM*), thought it could/should work.

Just wanted to make sure i wasn't overlooking anything or trying to use the tag incorrectly.

Thanks!

charlie

* which is a must-read, btw...if you haven't yet, it's at http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html
- Original Message - 
From: Dave Watts 
To: CF-Talk 
Sent: Tuesday, September 30, 2003 10:33 AM
Subject: RE: cfqueryparam and NULL values (SELECT)


 There is no way to use CFQUERYPARAM to pass a NULL to the 
 database, so for that 'value' (and that value alone) you 
 HAVE to use it directly.

This may be true sometimes, but isn't always true. That's why CFQUERYPARAM
has a NULL attribute - for exactly those cases. Some databases do allow the
use of NULL with the equality operator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: mailserver suggestions (outgoing)

2003-09-30 Thread cfhelp
I use IIS for relaying on my websites. 

 

But if that is not possible you could download ArgoSoft and use it. 

 

http://www.argosoft.com/ http://www.argosoft.com/ 

 

 

Rick

 

_

From: chris petersen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 12:37 PM
To: CF-Talk

 

I'm looking for a new outgoing mailserver (preferably free) to work with
coldfusion for relaying outgoing mail. I'm currently using Postcast -
it's been great for a year or so, but all of a sudden it keeps crashing,
and I don't know what to do short of replacing it.

Any good suggestions for a new mserver? I just need something coldfusion
can connect to and send mail through.

TIA,

Chris



_

[Todays 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: Usability

2003-09-30 Thread Candace Cottrell
Well, just got back form the Nielsen/Norman Group conference in Chicago
and I have to say that is was a real eye-opener!
I had one session where Don Norman himself critiques a flash RIA I'm
working on. And HE DIDNT BASH IT!
 
Actually, I found quite a few flash proponents and a lot of people who
were just scarred by the whole intro thing. A lot of people didn't
realize that flash could be used as a GUI tool!!!
 
Can you imagine!?!?
 
Anyway, I was surprised that so many companies have folks dedicated to
performing usability considerations and testing. I was particularly
interested in finding out that so many people don't give a hoot about
usability!
 
I would suggest any of you RIA developers check out Hoa Loranger's
Flash Usability study. It's well worth the price, and she was really
shocked to hear that the belief exists in the development community that
Usability experts hate developers/designers.
 
Any thoughts/ experiences you're willing to share about usability in
your company/projects??
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT: Usability

2003-09-30 Thread Mike Brunt
Thanks for this run-down Candace and you're right Usability and Accessibilty are very much neglectedand it is a REALLY big mistake that could eventually have legal implications.

Where can I find the Flash Usability study btw?

Kind Regards - Mike Brunt
Original Message ---
Well, just got back form the Nielsen/Norman Group conference in Chicago
and I have to say that is was a real eye-opener!
I had one session where Don Norman himself critiques a flash RIA I'm
working on. And HE DIDNT BASH IT!
 
Actually, I found quite a few flash proponents and a lot of people who
were just scarred by the whole intro thing. A lot of people didn't
realize that flash could be used as a GUI tool!!!
 
Can you imagine!?!?
 
Anyway, I was surprised that so many companies have folks dedicated to
performing usability considerations and testing. I was particularly
interested in finding out that so many people don't give a hoot about
usability!
 
I would suggest any of you RIA developers check out Hoa Loranger's
Flash Usability study. It's well worth the price, and she was really
shocked to hear that the belief exists in the development community that
Usability experts hate developers/designers.
 
Any thoughts/ experiences you're willing to share about usability in
your company/projects??
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Usability

2003-09-30 Thread Kevin Graeme
That's really cool Candace! I'm glad to hear that they didn't rip your RIA
to shreds. I figured that, like anything, it's really a matter of how it's
designed and not what technology you choose.

-Kevin

- Original Message - 
From: Candace Cottrell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:54 PM
Subject: OT: Usability


 Well, just got back form the Nielsen/Norman Group conference in Chicago
 and I have to say that is was a real eye-opener!
 I had one session where Don Norman himself critiques a flash RIA I'm
 working on. And HE DIDNT BASH IT!

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT -- How many CF ISP's and Inhouse users?

2003-09-30 Thread Nick Baker
Curious if any has a good estimate of the following:

1. How manyISP's sell CF hosting services?

2. How many use CF servers for their own hosting?

Forta.com shows a total of 936 CF ISP's. I interpret those sell hosting 
services. Since that is a registration deal I am wondering how close that 
number is?

Thanks,

Nick

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT: Usability

2003-09-30 Thread Candace Cottrell
http://store.yahoo.com/nngroup/flasusbunrep.html

The site is nngroup.com.

Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org

 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 9/30/2003 2:34:36 PM 
Thanks for this run-down Candace and you're right Usability and Accessibilty are very much neglectedand it is a REALLY big mistake that could eventually have legal implications.

Where can I find the Flash Usability study btw?

Kind Regards - Mike Brunt
Original Message ---
Well, just got back form the Nielsen/Norman Group conference in Chicago
and I have to say that is was a real eye-opener!
I had one session where Don Norman himself critiques a flash RIA I'm
working on. And HE DIDNT BASH IT!

Actually, I found quite a few flash proponents and a lot of people who
were just scarred by the whole intro thing. A lot of people didn't
realize that flash could be used as a GUI tool!!!

Can you imagine!?!?

Anyway, I was surprised that so many companies have folks dedicated to
performing usability considerations and testing. I was particularly
interested in finding out that so many people don't give a hoot about
usability!

I would suggest any of you RIA developers check out Hoa Loranger's
Flash Usability study. It's well worth the price, and she was really
shocked to hear that the belief exists in the development community that
Usability experts hate developers/designers.

Any thoughts/ experiences you're willing to share about usability in
your company/projects??

Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org


[EMAIL PROTECTED]






 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




free CF shopping cart ? your favorite ?

2003-09-30 Thread McNamara Kyle W CONT PORT
Hello,

Do any of you have an opinion on the what is the best CF (MX) shopping cart
that is for free or cheap?

Thank you!

Kyle

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Insert gone astray.... adding more than instructed :)

2003-09-30 Thread G.H.
Trying to get some code to work. Maybe someone could help me.

Problem is that when I run the code, I seem to be getting unexpected 
results. The query runs, and where it should only dump 1 record into the 
db it is dumping 2 records that are identical except for the ID field 
(which is a MSAccess AutoNum).

My search for a cure is not going well. Can anyone see why this is 
happening?The insert that I am using is at the end of the page.

html
head
titleVERIFY ADD ITEM/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1

link href="" rel=stylesheet type=text/css

cfscript
/**
* Checks to see if a var is an integer.
* version 1.1 - mod by Raymond Camden
*
* @param varToCheckValue you want to validate as an integer.
* @return Returns a Boolean.
* @author Nathan Dintenfass ([EMAIL PROTECTED])
* @version 1.1, April 10, 2002
*/
 function isInt(varToCheck){
return isNumeric(varToCheck) and round(varToCheck) is vartoCheck;
 }
 function isCurrency(c)
 {
 if(isNumeric(trim(c)))
 {
 c = NumberFormat(c,9.00);
//writeOutput(trim(c)  br /);
 }
 else
 {
 return isNumeric(trim(c));
 }
 return isCur2(trim(c));
 }
 function isCur2(n)
 {
 var dollars = ;
 var cents= ;
 if (listLen(n, '.') EQ 2)
 {
 dollars = listFirst(n, '.');
 cents = listLast(n, '.');
 return (len(cents) EQ 2 AND (isNumeric(dollars) AND 
isNumeric(cents)));
 }
 else
 {
 return listLen(n, '.') EQ 2;
 }
 }
/cfscript
/head
body
cfif NOT ISDEFINED(FORM.ProductType) OR NOT 
ISDEFINED(Form.ProductID) OR NOT ISDEFINED(Form.addAnother) OR NOT 
ISDEFINED(Form.Size) OR NOT ISDEFINED(FORM.Price)
cfset ErrCnt = 0
cfset ErrArr = ArrayNew(1)
cfif NOT ISDEFINED(FORM.ProductType)
cfset ErrCnt = ErrCnt + 1
cfset ErrArr[ErrCnt] = Form.ProductType: Not Defined. If you get 
this message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.ProductID)
cfset ErrCnt = ErrCnt + 1
cfset ErrArr[ErrCnt] = Form.ProductID: Not Defined. If you get 
this message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.addAnother)
cfset ErrCnt = ErrCnt + 1
cfset ErrArr[ErrCnt] = Form.AddAnother: Not Defined. If you get 
this message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.Size)
cfset ErrCnt = ErrCnt + 1
cfset ErrArr[ErrCnt] = Form.Size: Not Defined. If you get this 
message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.Price)
cfset ErrCnt = ErrCnt + 1
cfset ErrArr[ErrCnt] = Form.Price: Not Defined. If you get this 
message again, contact your system administrator
/cfif
cfif ErrCnt GT 0
div class=PageHeadingError Messages/div
br /
cfdump var=#ErrArr#
cfabort
/cfif
/cfif
cfset v = StructNew()
!--- Product Type ---
cfset v.PT = 
!--- Product ID ---
cfset v.PID = 
!--- AddAnother ---
cfset v.AA = 
!--- Size ---
cfset v.S=
!--- Price ---
cfset v.P=
!--- Best Buy ---
cfset v.BB = 
cfset e = ArrayNew(1)

cfset ecnt = 0
cfif ISDEFINED(Form.ProductType) AND LEN(TRIM(FORM.ProductType)) GT 0
cfif NOT ISNUMERIC(Form.ProductType)
cfswitch _expression_=#UCASE(Form.ProductType)#
 cfcase delimiters=| value=W|WINE|WINES
 cfset v.PT = W
 /cfcase
 cfcase delimiters=| value=L|LIQUOR|LIQUORS
 cfset v.PT = L
 /cfcase
 cfdefaultcase
 cfset ecnt = ecnt+1
 cfset e[ecnt] = StructNew()
 cfset e[ecnt].FieldName= Product Type
 cfset e[ecnt].ErrorMessage = Product Type Invalid. Not 
Recognized. Valid Entries are: W, WINE, WINES, L, LIQUOR, LIQUORS
 /cfdefaultcase
/cfswitch
cfelse
cfset ecnt = ecnt+1
cfset e[ecnt] = StructNew()
cfset e[ecnt].FieldName= Product Type
cfset e[ecnt].ErrorMessage = Product Type Invalid. May not 
contain numeric data
/cfif
cfelse
cfset ecnt = ecnt+1
cfset e[ecnt] = StructNew()
cfset e[ecnt].FieldName= Product Type
cfset e[ecnt].ErrorMessage = Product Type Not Found. Try Again.
/cfif
!--- Validate ProductID ---

cfif ISNUMERIC(FORM.ProductID) AND VAL(Form.ProductID) GT 0
cfquery name=verify_product_does_exist datasource=#DS#
SELECT * FROM #trim(v.PT)#Product WHERE PID = #Form.ProductID#
/cfquery
cfif verify_product_does_exist.recordcount IS 1
 cfset v.PID = trim(Form.ProductID)
 cfelse
 cfset ecnt = ecnt+1
 cfset e[ecnt] = StructNew()
 cfset e[ecnt].FieldName= Product ID
 cfset e[ecnt].ErrorMessage = Product ID Invalid. Not Not Found. 
Please Try Again
/cfif
cfelse
cfset ecnt = ecnt+1
cfset e[ecnt] = StructNew()
cfset e[ecnt].FieldName= Product ID
cfif NOT ISNUMERIC(FORM.ProductID)
 cfset e[ecnt].ErrorMessage = Product ID Invalid. Must be 
submitted and Product ID can not contain letters
 cfelse
 cfset e[ecnt].ErrorMessage = Product ID Invalid. Must be 
submitted and Product ID cannnot be '0'
/cfif
/cfif
!--- END PRODUCT ID VALIDATION ---
!--- PRODUCT SIZE VALIDATION ---
!--- RULES: MUST BE DEFINED ---
!--- RULES: MUST BE GT 0 ---
!--- RULES: MUST BE NUMERIC ---
!--- RULES: MUST NOT BE THE SAME AS A ITEM ALREADY LISTED ---
cfif ISDEFINED(Form.Size) AND LEN(TRIM(FORM.Size)) GT 0
cfif ISNUMERIC(Form.Size)
cfif isInt(Form.Size)
 cfquery name=verify_size_is_uk_for_prod 

Re: credit card test numbers

2003-09-30 Thread cf-talk
For Visa you can use:

4012345678990

Please note the two 9's at the end.

-Novak

- Original Message - 
From: Robert Orlini [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 11:41 AM
Subject: credit card test numbers


 I'm testing out the use of our CF validation script for credit cards. I
don't want to use real cc numbers. Anyone know of test numbers to use for Am
Express, M/C and Visa?

 Thanks.

 Robert Orlini
 HW Wilson
 718-588-8400 x2656
 ¿


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Insert gone astray... not doing as instructed....

2003-09-30 Thread GH - CF
Trying to get some code to work. Maybe someone could help me.

Problem is that when I run the code, I seem to be getting unexpected 
results. The query runs, and where it should only dump 1 record into the 
db it is dumping 2 records that are identical except for the ID field 
(which is a MSAccess AutoNum).

My search for a cure is not going well. Can anyone see why this is 
happening?The insert that I am using is at the end of the page.

html
head
titleVERIFY ADD ITEM/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1

link href="" rel=stylesheet type=text/css

cfscript
/**
 * Checks to see if a var is an integer.
 * version 1.1 - mod by Raymond Camden
 *
 * @param varToCheckValue you want to validate as an integer.
 * @return Returns a Boolean.
 * @author Nathan Dintenfass ([EMAIL PROTECTED])
 * @version 1.1, April 10, 2002
 */
function isInt(varToCheck){
return isNumeric(varToCheck) and round(varToCheck) is vartoCheck;
}
function isCurrency(c)
{
if(isNumeric(trim(c)))
{
c = NumberFormat(c,9.00);
//writeOutput(trim(c)  br /);
}
else
{
return isNumeric(trim(c));
}
return isCur2(trim(c));
}
function isCur2(n)
{
var dollars = ;
var cents= ;
if (listLen(n, '.') EQ 2)
{
dollars = listFirst(n, '.');
cents = listLast(n, '.');
return (len(cents) EQ 2 AND (isNumeric(dollars) AND 
isNumeric(cents)));
}
else
{
return listLen(n, '.') EQ 2;
}
}
/cfscript
/head
body
cfif NOT ISDEFINED(FORM.ProductType) OR NOT 
ISDEFINED(Form.ProductID) OR NOT ISDEFINED(Form.addAnother) OR NOT 
ISDEFINED(Form.Size) OR NOT ISDEFINED(FORM.Price)
cfset ErrCnt = 0
cfset ErrArr = ArrayNew(1)
cfif NOT ISDEFINED(FORM.ProductType)
 cfset ErrCnt = ErrCnt + 1
 cfset ErrArr[ErrCnt] = Form.ProductType: Not Defined. If you get 
this message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.ProductID)
 cfset ErrCnt = ErrCnt + 1
 cfset ErrArr[ErrCnt] = Form.ProductID: Not Defined. If you get 
this message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.addAnother)
 cfset ErrCnt = ErrCnt + 1
 cfset ErrArr[ErrCnt] = Form.AddAnother: Not Defined. If you get 
this message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.Size)
 cfset ErrCnt = ErrCnt + 1
 cfset ErrArr[ErrCnt] = Form.Size: Not Defined. If you get this 
message again, contact your system administrator
/cfif
cfif NOT ISDEFINED(FORM.Price)
 cfset ErrCnt = ErrCnt + 1
 cfset ErrArr[ErrCnt] = Form.Price: Not Defined. If you get this 
message again, contact your system administrator
/cfif
cfif ErrCnt GT 0
div class=PageHeadingError Messages/div
 br /
 cfdump var=#ErrArr#
 cfabort
/cfif
/cfif
cfset v = StructNew()
!--- Product Type ---
cfset v.PT = 
!--- Product ID ---
cfset v.PID = 
!--- AddAnother ---
cfset v.AA = 
!--- Size ---
cfset v.S=
!--- Price ---
cfset v.P=
!--- Best Buy ---
cfset v.BB = 
cfset e = ArrayNew(1)

cfset ecnt = 0
cfif ISDEFINED(Form.ProductType) AND LEN(TRIM(FORM.ProductType)) GT 0
cfif NOT ISNUMERIC(Form.ProductType)
 cfswitch _expression_=#UCASE(Form.ProductType)#
cfcase delimiters=| value=W|WINE|WINES
cfset v.PT = W
/cfcase
cfcase delimiters=| value=L|LIQUOR|LIQUORS
cfset v.PT = L
/cfcase
cfdefaultcase
cfset ecnt = ecnt+1
cfset e[ecnt] = StructNew()
cfset e[ecnt].FieldName= Product Type
cfset e[ecnt].ErrorMessage = Product Type Invalid. Not 
Recognized. Valid Entries are: W, WINE, WINES, L, LIQUOR, LIQUORS
/cfdefaultcase
 /cfswitch
 cfelse
 cfset ecnt = ecnt+1
 cfset e[ecnt] = StructNew()
 cfset e[ecnt].FieldName= Product Type
 cfset e[ecnt].ErrorMessage = Product Type Invalid. May not contain 
numeric data
/cfif
cfelse
cfset ecnt = ecnt+1
cfset e[ecnt] = StructNew()
cfset e[ecnt].FieldName= Product Type
cfset e[ecnt].ErrorMessage = Product Type Not Found. Try Again.
/cfif
!--- Validate ProductID ---

cfif ISNUMERIC(FORM.ProductID) AND VAL(Form.ProductID) GT 0
 cfquery name=verify_product_does_exist datasource=#DS#
 SELECT * FROM #trim(v.PT)#Product WHERE PID = #Form.ProductID#
 /cfquery
 cfif verify_product_does_exist.recordcount IS 1
cfset v.PID = trim(Form.ProductID)
cfelse
cfset ecnt = ecnt+1
cfset e[ecnt] = StructNew()
cfset e[ecnt].FieldName= Product ID
cfset e[ecnt].ErrorMessage = Product ID Invalid. Not Not Found. 
Please Try Again
 /cfif
 cfelse
 cfset ecnt = ecnt+1
 cfset e[ecnt] = StructNew()
 cfset e[ecnt].FieldName= Product ID
 cfif NOT ISNUMERIC(FORM.ProductID)
cfset e[ecnt].ErrorMessage = Product ID Invalid. Must be 
submitted and Product ID can not contain letters
cfelse
cfset e[ecnt].ErrorMessage = Product ID Invalid. Must be 
submitted and Product ID cannnot be '0'
 /cfif
/cfif
!--- END PRODUCT ID VALIDATION ---
!--- PRODUCT SIZE VALIDATION ---
!--- RULES: MUST BE DEFINED ---
!--- RULES: MUST BE GT 0 ---
!--- RULES: MUST BE NUMERIC ---
!--- RULES: MUST NOT BE THE SAME AS A ITEM ALREADY LISTED ---
cfif ISDEFINED(Form.Size) AND LEN(TRIM(FORM.Size)) GT 0
cfif ISNUMERIC(Form.Size)
 cfif isInt(Form.Size)
cfquery name=verify_size_is_uk_for_prod datasource=#DS#

RE: credit card test numbers

2003-09-30 Thread Tony Weeg
I think its just 4 and any other 15 digits, however to be sure that you
arent mischarging
someones card, you would want to use 4111

wouldntyathink? 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 2:35 PM
To: CF-Talk
Subject: Re: credit card test numbers

For Visa you can use:

4012345678990

Please note the two 9's at the end.

-Novak

- Original Message -
From: Robert Orlini [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 11:41 AM
Subject: credit card test numbers


 I'm testing out the use of our CF validation script for credit cards. I
don't want to use real cc numbers. Anyone know of test numbers to use for Am
Express, M/C and Visa?

 Thanks.

 Robert Orlini
 HW Wilson
 718-588-8400 x2656
 ¿





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Insert gone astray... not doing as instructed....

2003-09-30 Thread GH - CF
Sorry for the 2nd post of the same message made a mistake on my 
end Sorry.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Passing a URL number (used to be action pages not passing along info)

2003-09-30 Thread Laura Schlee
OK, there's good news and bad news -- 

I got my URL to pass along the ID number I was looking
for -- thanks! -- but I'm pretty sure it's not getting
passed as a number because I got suspicious and
created an action page with one line

cfoutput#URL.PersonnelKey#/cfoutput

and I'm getting this error message:

Element PERSONNELKEY is undefined in URL. 

Is my syntax wrong? I'm still using the same URL as
below:

http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKey=21486

and the SQL is the same as well. The form page code is
below, in case that's where I'm messing things up.

Geez, I wanted to have this finished today -- I guess
that's not going to happen :(

Thanks,

Laura
=
Laura Schlee
DML Associates
cell 703-622-0363
ofc202-685-1360




!-- Check for the existence of the PersonnelKey value
--
cfif NOT IsDefined(URL.PersonnelKey)
!-- If the PersonnelKey value is not available, send
the user to the 
search for a person page --
cflocation url="">
/cfif

html
head
titleAdd a Permit - Vehicle Table/title
/head
body bgcolor=#FF
p
h2Add Vehicle Information to Personnel Record/h2
/p
form action="">
method=post

!-- Embed PersonnelKey as a hidden field --

cfoutput
input type=hidden name=PersonnelKey
value=URL.PersonnelKey
/cfoutput

table width=650 border=1 cellspacing=0
cellpadding=0
 tr 
td colspan=2bCar Information/b/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81nbsp;/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81Year/td
 /tr
 tr 
td width=96Tag Number/td
td width=44State/td
td width=144Make/td
td width=153Model/td
td width=118Color/td
td width=81()/td
 /tr
 tr 
td width=96 
input type=text name=TagNumber size=10
maxlength=10
/td
tdselect name=TagState
		option value=ALAL/option
		option value=AKAK/option
		option value=AZAZ/option
		option value=ARAR/option
		option value=CACA/option
		option value=COCO/option
		option value=CTCT/option
		option value=DEDE/option
		option value=DCDC/option
		option value=FLFL/option
		option value=GAGA/option
		option value=HIHI/option
		option value=IDID/option
		option value=ILIL/option
		option value=ININ/option
		option value=IAIA/option
		option value=KSKS/option
		option value=KYKY/option
		option value=LALA/option
		option value=MEME/option
		option value=MDMD/option
		option value=MAMA/option
		option value=MIMI/option
		option value=MNMN/option
		option value=MSMS/option
		option value=MOMO/option
		option value=MTMT/option
		option value=NENE/option
		option value=NVNV/option
		option value=NHNH/option
		option value=NJNJ/option
		option value=NMNM/option
		option value=NYNY/option
		option value=NCNC/option
		option value=NDND/option
		option value=OHOH/option
		option value=OKOK/option
		option value=OROR/option
		option value=PAPA/option
		option value=RIRI/option
		option value=SCSC/option
		option value=SDSD/option
		option value=TNTN/option
		option value=TXTX/option
		option value=UTUT/option
		option value=VTVT/option
		option value=VAVA/option
		option value=WAWA/option
		option value=WVWV/option
		option value=WIWI/option
		option value=WYWY/option
		/select
/td
td width=144 
input type=text name=Make size=20
maxlength=20
/td
td width=153 
input type=text name=Model size=20
maxlength=20
/td
td width=118 
input type=text name=Color size=20
maxlength=20
/td
td width=81 
input type=text name=CarYear size=10
maxlength=10
/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81nbsp;/td
 /tr
 tr 
td width=96bDOD Decal Information/b/td
td width=44nbsp;/td
td width=144nbsp;/td
td colspan=2bInsurance
Information/b/td
td width=81nbsp;/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81Insurance/td
 /tr
 tr 
td width=96Decal/td
td colspan=2 
table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
tdDecal/td
tdDecal/td
 /tr
/table
/td
td width=153Insurance/td
td width=118Policy/td
td width=81Expiration/td
 /tr
 tr 
td width=96 Number/td
td colspan=2 
table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
tdColor/td
tdExpiration/td
 /tr
/table
/td
td width=153Company/td
td width=118Number/td
td width=81MMDDYY/td
 /tr
 tr 
td width=96 
input type=text name=DODDecalNumber
size=15 maxlength=15
/td
td colspan=2
	 table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
td
input type=text name=DODDecalColor
size=15 maxlength=15
/td
td
input type=text
name=DODDecalExpiration size=15 maxlength=15
/td
 /tr
/table
	/td
td width=153 
input type=text name=InsuranceCompany
size=20 maxlength=20
/td
td width=118 
input type=text name=PolicyNumber
size=20 maxlength=20
/td
td width=81 
input type=text
name=InsuranceExpirationDate size=10
maxlength=10
/td
 /tr
 tr
tdnbsp;/td
td colspan=2nbsp;/td
tdnbsp;/td
tdnbsp;/td
tdnbsp;/td
 /tr
 tr
tdstrongPermit 

Re: Passing a URL number (used to be action pages not passing along info)

2003-09-30 Thread Jerry Johnson
I think your syntax is wrong.

This line:

input type=hidden name=PersonnelKey value=URL.PersonnelKey

should probably be 

input type=hidden name=PersonnelKey value=#URL.PersonnelKey#

(You want to write the value of the variable, not the literal string URL.PersonnelKey)

Jerry Johnson

 [EMAIL PROTECTED] 09/30/03 02:53PM 
OK, there's good news and bad news -- 

I got my URL to pass along the ID number I was looking
for -- thanks! -- but I'm pretty sure it's not getting
passed as a number because I got suspicious and
created an action page with one line

cfoutput#URL.PersonnelKey#/cfoutput

and I'm getting this error message:

Element PERSONNELKEY is undefined in URL. 

Is my syntax wrong? I'm still using the same URL as
below:

http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKey=21486 

and the SQL is the same as well. The form page code is
below, in case that's where I'm messing things up.

Geez, I wanted to have this finished today -- I guess
that's not going to happen :(

Thanks,

Laura
=
Laura Schlee
DML Associates
cell 703-622-0363
ofc202-685-1360




!-- Check for the existence of the PersonnelKey value
--
cfif NOT IsDefined(URL.PersonnelKey)
!-- If the PersonnelKey value is not available, send
the user to the 
search for a person page --
cflocation url="">
/cfif

html
head
titleAdd a Permit - Vehicle Table/title
/head
body bgcolor=#FF
p
h2Add Vehicle Information to Personnel Record/h2
/p
form action="">
method=post

!-- Embed PersonnelKey as a hidden field --

cfoutput
input type=hidden name=PersonnelKey
value=URL.PersonnelKey
/cfoutput

table width=650 border=1 cellspacing=0
cellpadding=0
 tr 
td colspan=2bCar Information/b/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81nbsp;/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81Year/td
 /tr
 tr 
td width=96Tag Number/td
td width=44State/td
td width=144Make/td
td width=153Model/td
td width=118Color/td
td width=81()/td
 /tr
 tr 
td width=96 
input type=text name=TagNumber size=10
maxlength=10
/td
tdselect name=TagState
		option value=ALAL/option
		option value=AKAK/option
		option value=AZAZ/option
		option value=ARAR/option
		option value=CACA/option
		option value=COCO/option
		option value=CTCT/option
		option value=DEDE/option
		option value=DCDC/option
		option value=FLFL/option
		option value=GAGA/option
		option value=HIHI/option
		option value=IDID/option
		option value=ILIL/option
		option value=ININ/option
		option value=IAIA/option
		option value=KSKS/option
		option value=KYKY/option
		option value=LALA/option
		option value=MEME/option
		option value=MDMD/option
		option value=MAMA/option
		option value=MIMI/option
		option value=MNMN/option
		option value=MSMS/option
		option value=MOMO/option
		option value=MTMT/option
		option value=NENE/option
		option value=NVNV/option
		option value=NHNH/option
		option value=NJNJ/option
		option value=NMNM/option
		option value=NYNY/option
		option value=NCNC/option
		option value=NDND/option
		option value=OHOH/option
		option value=OKOK/option
		option value=OROR/option
		option value=PAPA/option
		option value=RIRI/option
		option value=SCSC/option
		option value=SDSD/option
		option value=TNTN/option
		option value=TXTX/option
		option value=UTUT/option
		option value=VTVT/option
		option value=VAVA/option
		option value=WAWA/option
		option value=WVWV/option
		option value=WIWI/option
		option value=WYWY/option
		/select
/td
td width=144 
input type=text name=Make size=20
maxlength=20
/td
td width=153 
input type=text name=Model size=20
maxlength=20
/td
td width=118 
input type=text name=Color size=20
maxlength=20
/td
td width=81 
input type=text name=CarYear size=10
maxlength=10
/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81nbsp;/td
 /tr
 tr 
td width=96bDOD Decal Information/b/td
td width=44nbsp;/td
td width=144nbsp;/td
td colspan=2bInsurance
Information/b/td
td width=81nbsp;/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81Insurance/td
 /tr
 tr 
td width=96Decal/td
td colspan=2 
table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
tdDecal/td
tdDecal/td
 /tr
/table
/td
td width=153Insurance/td
td width=118Policy/td
td width=81Expiration/td
 /tr
 tr 
td width=96 Number/td
td colspan=2 
table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
tdColor/td
tdExpiration/td
 /tr
/table
/td
td width=153Company/td
td width=118Number/td
td width=81MMDDYY/td
 /tr
 tr 
td width=96 
input type=text name=DODDecalNumber
size=15 maxlength=15
/td
td colspan=2
	 table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
td
input type=text name=DODDecalColor
size=15 maxlength=15
/td
td
input type=text
name=DODDecalExpiration size=15 maxlength=15
/td
 /tr
/table
	/td
td 

RE: Passing a URL number (used to be action pages not passing along info)

2003-09-30 Thread Ben Densmore
Your hidden form field containing Url.Personnelkey is missing ound
signs. That is probably where the error is. Try #url.personnelkey#

 

Ben

 

-Original Message-
From: Laura Schlee [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 2:54 PM
To: CF-Talk
Subject: Passing a URL number (used to be action pages not passing
along info)

 

OK, there's good news and bad news -- 

I got my URL to pass along the ID number I was looking
for -- thanks! -- but I'm pretty sure it's not getting
passed as a number because I got suspicious and
created an action page with one line

cfoutput#URL.PersonnelKey#/cfoutput

and I'm getting this error message:

Element PERSONNELKEY is undefined in URL. 

Is my syntax wrong? I'm still using the same URL as
below:

http://localhost:8500/InfoCenter/Parking/addpermitv_test.cfm?PersonnelKe
y=21486

and the SQL is the same as well. The form page code is
below, in case that's where I'm messing things up.

Geez, I wanted to have this finished today -- I guess
that's not going to happen :(

Thanks,

Laura
=
Laura Schlee
DML Associates
cell 703-622-0363
ofc202-685-1360




!-- Check for the existence of the PersonnelKey value
--
cfif NOT IsDefined(URL.PersonnelKey)
!-- If the PersonnelKey value is not available, send
the user to the 
search for a person page --
cflocation url="">
/cfif

html
head
titleAdd a Permit - Vehicle Table/title
/head
body bgcolor=#FF
p
h2Add Vehicle Information to Personnel Record/h2
/p
form action="">
method=post

!-- Embed PersonnelKey as a hidden field --

cfoutput
input type=hidden name=PersonnelKey
value=URL.PersonnelKey
/cfoutput

table width=650 border=1 cellspacing=0
cellpadding=0
 tr 
td colspan=2bCar Information/b/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81nbsp;/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81Year/td
 /tr
 tr 
td width=96Tag Number/td
td width=44State/td
td width=144Make/td
td width=153Model/td
td width=118Color/td
td width=81()/td
 /tr
 tr 
td width=96 
input type=text name=TagNumber size=10
maxlength=10
/td
tdselect name=TagState
option value=ALAL/option
option value=AKAK/option
option value=AZAZ/option
option value=ARAR/option
option value=CACA/option
option value=COCO/option
option value=CTCT/option
option value=DEDE/option
option value=DCDC/option
option value=FLFL/option
option value=GAGA/option
option value=HIHI/option
option value=IDID/option
option value=ILIL/option
option value=ININ/option
option value=IAIA/option
option value=KSKS/option
option value=KYKY/option
option value=LALA/option
option value=MEME/option
option value=MDMD/option
option value=MAMA/option
option value=MIMI/option
option value=MNMN/option
option value=MSMS/option
option value=MOMO/option
option value=MTMT/option
option value=NENE/option
option value=NVNV/option
option value=NHNH/option
option value=NJNJ/option
option value=NMNM/option
option value=NYNY/option
option value=NCNC/option
option value=NDND/option
option value=OHOH/option
option value=OKOK/option
option value=OROR/option
option value=PAPA/option
option value=RIRI/option
option value=SCSC/option
option value=SDSD/option
option value=TNTN/option
option value=TXTX/option
option value=UTUT/option
option value=VTVT/option
option value=VAVA/option
option value=WAWA/option
option value=WVWV/option
option value=WIWI/option
option value=WYWY/option
/select
/td
td width=144 
input type=text name=Make size=20
maxlength=20
/td
td width=153 
input type=text name=Model size=20
maxlength=20
/td
td width=118 
input type=text name=Color size=20
maxlength=20
/td
td width=81 
input type=text name=CarYear size=10
maxlength=10
/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81nbsp;/td
 /tr
 tr 
td width=96bDOD Decal Information/b/td
td width=44nbsp;/td
td width=144nbsp;/td
td colspan=2bInsurance
Information/b/td
td width=81nbsp;/td
 /tr
 tr 
td width=96nbsp;/td
td width=44nbsp;/td
td width=144nbsp;/td
td width=153nbsp;/td
td width=118nbsp;/td
td width=81Insurance/td
 /tr
 tr 
td width=96Decal/td
td colspan=2 
table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
tdDecal/td
tdDecal/td
 /tr
/table
/td
td width=153Insurance/td
td width=118Policy/td
td width=81Expiration/td
 /tr
 tr 
td width=96 Number/td
td colspan=2 
table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
tdColor/td
tdExpiration/td
 /tr
/table
/td
td width=153Company/td
td width=118Number/td
td width=81MMDDYY/td
 /tr
 tr 
td width=96 
input type=text name=DODDecalNumber
size=15 maxlength=15
/td
td colspan=2
 table width=188 border=0 cellspacing=0
cellpadding=0
 tr 
td
input type=text name=DODDecalColor
size=15 maxlength=15
/td
td
input type=text
name=DODDecalExpiration size=15 maxlength=15
/td
 /tr
/table
/td
td width=153 
input type=text name=InsuranceCompany
size=20 maxlength=20
/td
td 

  1   2   >