Re: setting variable with a period

[Samuel Farmer]

You can still set variables in MX with periods.  Its just if the word before
the period is not a variable type (variables, form, url, request, etc.) it
will make a structure.  So, the rule is really that you can not have a
period as part of a variable name.

So, your example 
will work fine.

HTH,

Sam

PS, We still have an opening for a junior CF developer.  Send resume if
interested.

- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 2:08 PM
Subject: Re: setting variable with a period


> No, this is on CF 5.0 .. but for CFMX what can you do to work around this?
>
> SO I cannot set the following in CFMX:
>
> 
> (period at the end of a sentance?)
>
> That kind of bites!
>
> Paul Giesenhagen
> QuillDesign
>
>
> - Original Message -
> From: "Gyrus" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 03, 2002 1:00 PM
> Subject: Re: setting variable with a period
>
>
> > - Original Message -
> > From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> > > I am doing the following but am getting an invalid parser construct,
it
> > > doesn't like the period is 1.5
> > >
> > > 
> > >  request.shipcode_1.5 = '1.50';
> > > 
> > ---
> >
> > Are you on MX? MX now doesn't allow periods in var names. Or rather, if
> you
> > put a period in a var name, it treats it as a structure, and if the
> > structure isn't defined, it creates it dynamically.
> >
> > So the above code would try to create a new structure called
> > 'request.shipcode_1', and set the key '5' to '1.50'. And I guess like
> other
> > vars, the key can't start with a numeral...
> >
> > HTH,
> >
> > - Gyrus
> >
> > 
> > - [EMAIL PROTECTED]
> > work: http://www.tengai.co.uk
> > play: http://www.norlonto.net
> > - PGP key available
> > 
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

cfmail: attachment + multipart?

[Samuel Farmer]

All,

I am trying to send out a cfmail in multipart format and (sometimes) send an
attachment as well.  Got the first part to work, but if I add a file to the
mimeAttach attribute I get the file but the email formating is lost.  Any
ideas/solutions?

Heres the code:

variables.boundary=Replace(CreateUUID(), "-", "", 'all');
variables.contenttype="multipart/alternative; boundary=""#boundary#""";




--#variables.boundary#
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

#getEmailInfo.plainText#

--#variables.boundary#
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit




#getEmailInfo.htmlText#



--#variables.boundary#--



JOB DC AREA
We are looking to hire a Junior CF Programmer.  If you are interested send
me your resume.

Cheers,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
INTELIX - Intelligent Solutions

12500 Fair Lakes Circle, Suite 150
Fairfax, VA 22033

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

cf_html2pdf3 timeout issues

[Samuel Farmer]

I am getting a timeout error, listed below, when I run this tag in either CF
MX or 5.  Any pointers on installation?

Code:

This is a test.


Error MX:
Timeout period expired without completion of
d:\cfusionMX\bin\pdf\htmldoc-1.8.8-windows.exe
The Error Occurred in D:\CFusionMX\CustomTags\pdf\html2pdf3.cfm: line 136

Error CF5:
Timeout period expired without completion of
d:\cfusionMX\bin\pdf\htmldoc-1.8.8-windows.exe --webpage -f
c:\inetpub\wwwroot\users\sfarmer\\test.pdf
c:\inetpub\wwwroot\users\sfarmer\\Generated_8-21-2002_10-20-53-A.cfm

Thanks,

Sam

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: A place for queries?

[Samuel Farmer]

If you are on MX then I would say the best place is in a component.  We are
working on a new project and wanted to follow a MVC model and have put all
queries in components.  Bit of a pain at first but the deeper you get into
it the more code resuse you will find.

Before we moved to that style we separated logic/query from output as much
as possible.

HTH,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions




- Original Message -
From: "Mark W. Breneman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 11:04 AM
Subject: A place for queries?


> Is there a "best practice place" to put queries on the cfm page?  i.e.
above
> the  tag?, below the  tag?
>
> I have seen where verity will grab SQL code in its "summary" is does the
> placing of the query effect this? (I expect it does)
>
> Thanks
>
>
>
> Mark W. Breneman
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Unexplained Error Message

[Samuel Farmer]

We are getting the following error on a unix machine after verifying that
the datasource exist.  A google groups search reveals that others have got
this error but no solution.  Any help?

Error:

Error Occurred While Processing Request
Error Diagnostic Information
Oracle Error Code = 0

The driver for the ORACLE80 Data Source type could not be loaded.
ld.so.1: /opt/coldfusion/bin/cfserver: fatal: libclntsh.so: open failed:
No such file or directory


Cheers,

Sam



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMX Error: Index: 163, Size: 156

[Samuel Farmer]

Running: CFMX with Macromedia Web Server

On a series of pages I keep getting the following error: Index: 163, Size:
156

The solution seems to be to just reload as the error never comes up twice in
a row.  The page has a few includes and about 10 templates in all including
cfc's and custom tags and I have heard that MX has problems with too many
includes so maybe that is the problem?

Anyone got any advice on this error?

Thanks,

Sam



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Data out of cfloginuser

[Samuel Farmer]

All,

Anyone know if it is possible to read data out of cfloginuser?  I have a
situation where I would like to add a role for a user 5 to 10 pages after
they have logged in.

It is possible to run the cfloginuser tag again, but I need to know what the
password and roles are so that I can set them again!

Thanks,

Sam



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SOT: 2d barcodes

[Samuel Farmer]

All--

Has anyone any experience/advice with printing 2d barcodes?  Our process
would be to retrieve info from database, put in 2d format and then print.
Would be using CFMX (and some 3rd party software) if that helps.

Thanks,

Sam



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Sometimes clearing query cache

[Samuel Farmer]

Accidently deleted the original email about this but recently encountered a
similar problem so thought I would pass on how we solved it:

-Paramed a variable called session.clearcache to 1 in the application.cfm
file (with locking of course)
-On the page that runs the query to be cached
if clearcache is 1
set variables.timespan = CreateTimeSpan(0,0,0,0)
set session.clearcache = 0
else
set variables.timespan = CreateTimeSpan(0,0,30,0)
/if

the cfquery then looks like:


-On the page that you make changes to the data that the query will bring
back set session.clearcache = 1

HTH,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
INTELIX - Intelligent Solutions
A Fast 50 Company




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: alternating rows

[Samuel Farmer]

Also perfect time for a UDF:

function bgcolor_switch(ROW) {
 color = "CDCDCD";
 if (ROW mod 2 is 1) {
  color="ff";
 }
 return color;
}

Code:



Thanks,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
INTELIX - Intelligent Solutions
** A Washington Post Techway "Fast 50" Company **
http://www.intelixinc.com/news/fast50.html



> -Original Message-
> From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 18, 2002 13:31
> To: CF-Talk
> Subject: alternating rows
>
>
> Does anyone remember the quick way to alternate row colors when using MOD
on
> a recorcount?
>
> Mike
>
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL case insensitive search ???

[Samuel Farmer]

What database are you using?

Other responses seem to have covered SQLServer.  If you are using ORACLE
then all searches are case sensitive and you would need to make both the
column and the search criteria the same case in order to be
"case-insensitive".  ORACLE has two functions UPPER and LOWER that you can
use, ie:

WHERE UPPER(Table.FieldName) LIKE '%UPPER(searchString)%'

Sam


- Original Message -
From: "Brian Scandale" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 15, 2002 12:35 AM
Subject: SQL case insensitive search ???


> how does one go about structuring a case insensitive search on a text
field in a database?
>
> Currently using
>
> WHERE Table.FieldName LIKE '%searchString%'
>
> Thanks,
> Brian
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: GET Size

[Samuel Farmer]

2K.

Sam


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 10:56 AM
Subject: GET Size


> what is the max length of a GET request?
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Custom Tag

[Samuel Farmer]

Speaking of which, are variables stored in a structure of any sort?  Be
really useful if they where when it came to cferror.  We have cferror
calling a custom tag that emails all url, form, session, cgi variables and
it would be really useful to send all the variables that had been set and
their value.

If anyone wants a copy of the custom tag let me know.

Thanks,

Sam


- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, February 06, 2002 11:29 AM
Subject: RE: Custom Tag

>
> The Attributes scope is a structure, so you should be able to loop over it
> as such:
>
> 
> 
> 
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444

>
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Why no error.type in CF5

[Samuel Farmer]

Does anyone know why Macromedia decided to drop the key "type" from the
error structure created by ??

Was a pretty useful feature.

Off to rewrite some code,

Sam


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Login forms

[Samuel Farmer]

An easier way, and one we use in all our applications, is to test if a user
has logged in or is logging in on the application.cfm file and if they have
not include a login file and then abort.  This way the page requested never
changes and there is no need to use cflocation (my least popular tag...) or
remember the desired page or anything like that.

So the code in the Application.cfm would look something like this:



 [forces user to log in]

  [runs security file, if login
fails include login and abort again]
 

Of course you should also lock around session variables but this is just a
quick example.

Hope this helps,

Sam

Sam Farmer - Senior Developer
Certified Advanced ColdFusion 5 Developer
[EMAIL PROTECTED]
INTELIX - Intelligent Solutions




- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 28, 2002 12:45 PM
Subject: RE: Login forms


> > I want the user to be sent to the page that he originally
> > requested after logging in. It should not matter what page
> > he tried to get to. He should go to that page, not a page
> > that is programmed statically into the login page.
>
> This is pretty simple. Track the requested page URL as a variable, and
> redirect to that. For example, if you're using the Session scope, you can
> have something like this in Application.cfm:
>
> 
> 
> 
> 
> 
> 
>
> Then, in the page that processes the login, you'd simply redirect to the
> originally requested page:
>
> 
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQLServer Stored Proc Permissions

[Samuel Farmer]

Hi,

I am trying to use a system stored procedure in SQLServer7 that is in the
master database called sp_fkeys.  My datasource accesses a database called
'mydb' that does not have the sp_fkeys stored procedure in the database.  In
Query Analyzer the stored procedure works with the sams database is chosen.
But, every time I call the stored procedure from the datasource using
http://www.intelixinc.com>



__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists