Re: MIME TYPE?

[Bryan LaPlante]

What I would really like to know is how do you set the download file name
with cfcontent so that the saveAs dialogue box does not say thankyou.zip.

- Original Message -
From: "Scott, Andrew" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 1:00 AM
Subject: RE: MIME TYPE?


> cfcontent, and then use the mimetype that is required for the file!
>
> HTH
>
>
> -Original Message-
> From: Brian Thornton [mailto:[EMAIL PROTECTED]]
> Sent: 10 April 2001 14:01
> To: CF-Talk
> Subject: MIME TYPE?
>
>
> Anyone know how to download a file instead on displaying it on the
browser?
> To generate to pop up dialog for saving it to a disk...
>
> -Brian
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MIME TYPE?

[Scott, Andrew]

cfcontent, and then use the mimetype that is required for the file!

HTH


-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: 10 April 2001 14:01
To: CF-Talk
Subject: MIME TYPE?


Anyone know how to download a file instead on displaying it on the browser?
To generate to pop up dialog for saving it to a disk...

-Brian
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: QUERY PROBLEM

[kishore]

Hi,

The default format of date function is date with time. Ms-Access has also
the same format. If you want to compare two date values, change the target
value to default format and make the comparision. Like 
which is the default for both CF & MS-Access. Now try with this default
format,

good luck,

Regards
kishore

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 12:23 AM
Subject: QUERY PROBLEM


> I am trying to pull the next baseball game from a schedule I have in an
> Access database. When it processes it pulls the next game to a degree. If
> there is a game today it will not pull that game. Example there is a game
> today 4/9/2001 and the ext game it displays is 4/10/2001  Any ideas?
>
> 
>
> 
> SELECT *
> FROM schedule
> WHERE gdate >= #today#
> 
>
> ALSO HAD IT AS
>
> 
> SELECT *
> FROM schedule
> WHERE gdate >= NOW()
> 
>
>
> Thanks.
>
> Brian Hasselback
> [EMAIL PROTECTED]
> http://www.intent.net
> http://www.hasselback.com
> Web Hosting & Development
> (502) 452-1851
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: MIME TYPE?

[Arden Weiss]

Go to http://www.infomentum.com and look for AppletFile.  Works great -- 
both up and down -- with progress bars to keep the user distracted from 
poking keys and clicking buttons during the process...

^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Brian Thornton [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, April 10, 2001 12:01 AM
To: CF-Talk
Subject:MIME TYPE?

Anyone know how to download a file instead on displaying it on the browser? 
To generate to pop up dialog for saving it to a disk...

-Brian
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Moreover News Feed

[Mak Wing Lok]

just wondering, other than news feed from moreover, is that any other site
do offer other feeding, ie. weather, horoscope,etc..??

mak wl

- Original Message -
From: "Kelly" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 8:25 AM
Subject: Re: Moreover News Feed


> I am using it. We actually used the NON FREE version.  But its pretty much
> the same
> just a hell of a lot more news. I just take the WDDX packet and through it
> into SQL and
> then create the page the way I want it.   Our site is still under
> development but
> when it launches I will send you the URL.
> Kelly
>
> At 12:38 PM 4/9/2001 -0500, you wrote:
>
> >I assume there are some people here using the Moreover.com News feed.  I
was
> >wondering if someone might like to send me links to their site so I might
> >see how you implemented it.  I am not much on the "look and feel" side
and
> >was looking to get some ideas.
> >
> >Thanks in advance,
> >Vance Duke
> >Sr. CF Programmer
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

MIME TYPE?

[Brian Thornton]

Anyone know how to download a file instead on displaying it on the browser? To 
generate to pop up dialog for saving it to a disk...

-Brian


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!

[Robert Everland III]

No query at all, it's a client variable going to a database.

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 10:56 PM
To: CF-Talk
Subject: RE: ODBC Error Code = 37000 UGH!


what is the code for the query?  I'd guess that it's either a Where problem
or a variable reference problem.

Hatton

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 10:35 PM
To: CF-Talk
Subject: ODBC Error Code = 37000 UGH!


I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client
variable. Anyone seen this before?

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'55'.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ODBC Error Code = 37000 UGH!!!!!!!!!!!!!

[C. Hatton Humphrey]

what is the code for the query?  I'd guess that it's either a Where problem
or a variable reference problem.

Hatton

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 10:35 PM
To: CF-Talk
Subject: ODBC Error Code = 37000 UGH!


I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client
variable. Anyone seen this before?

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'55'.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OLE DB question

[Bud]

Hi all. I've got SQL 2000 installed on W2K. On the CF Server I have
NT 4.0 sp6a and CF 4.01. I installed MDAC 2.6 on the CF Server.

I can create an OLEDB datasource using either sqloledb or msdasql and
verify fine. However, when using the datasource in an actual CF
template I get the error:

CMemoryException: unknown cause
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

Any clues what I should look for. I'd like to try using OLEDB to see
if it gets rid of the ConnectionWrite and ConnectionRead errors.

Or if anyone else has any idea what I should look for to get rid of
THOSE using ODBC that would also be hunkydory. I've only got like 4
datasources set up on SQL 2000, so I don't understand why I'd be
getting connection errors.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ODBC Error Code = 37000 UGH!!!!!!!!!!!!!

[Robert Everland III]

I have CF 4.5.1 SP2, MDAC 2.6, SQL SP3. Does this whenever I set a client
variable. Anyone seen this before?

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
'55'.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF Cert: wait for 5.0?

[Ben Forta]

I don't think a final announcement has been made yet, but a "upgrade" exam
has been discussed for folks who have already certified. A formal
announcement will be out shortly.

--- Ben


-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 5:46 PM
To: CF-Talk
Subject: Re: CF Cert: wait for 5.0?


Forta spoke at last month's Dallas/Ft. Worth CFUG, and he stated that you
would need to get "re-certified" for
5.0.  I'm not sure if that's a full certification, or something like
Microsoft does (abbreviated test(s) to cover
new stuff).  Ben, if I heard you wrong, please correct me.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

John Wilker wrote:

> As I understand it the current certification will be good through V5. I
> asked them after I took mine and while they hadn't finalized anything yet,
> the speculation was that it would be good through at least a version. i.e.
> 4.5 - 5, at at least. I know MS certs last 2 versions. An MCSE friend of
> mine had his SQL cert just expire and he was 6.5 certified. Hopefully
> Allaire will do something like that.
>
> Mine was 150.00 through VUE. I think it's vue.com there should be a link
off
> the Allaire site in the certification section that takes you to the
> VUE/allaire page to sign up for the exam.
>
> J.
>
> John Wilker
> Web Applications Consultant
> Allaire Certified ColdFusion Developer
>
> www.red-omega.com 
>
> The Coca-Cola name in China was first read as "Kekoukela", meaning "Bite
the
> wax tadpole" or "female horse stuffed with wax", depending on the dialect.
> Coke then researched 40,000 characters to find a phonetic equivalent
"kokou
> kole", translating into "happiness in the mouth."
>
> -Original Message-
> From: Marc Garrett [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 6:15 AM
> To: CF-Talk
> Subject: CF Cert: wait for 5.0?
>
> Does anyone know how long after CF 5 is released before the certification
> exam becomes available? Is it better to take it now, or wait for the new
> exam?
>
> Also, I could not find pricing information on Allaire's site. Does anyone
> know the price?
>
> Thanks,
>
> Marc Garrett
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Registry size.

[Scott, Andrew]

Not if you follow the basic guidelines and user variables instead of hard
coding this info, also to be 100% sure wrap these with cftry and have your
own custom message!!! That should make it harder for anyone to second guess.



-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: 10 April 2001 12:01
To: CF-Talk
Subject: Re: Registry size.


Jon,
If there is ever an error in the dsn won't the server throw the DSN
name.  This would become a security issue since user X can query user Y's
client info?

Thanks,

Neil

- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 6:27 PM
Subject: Re: Registry size.


> Changing the client variables to be stored in a database is one of the
first
> things I do on a new server. Using an Access database is much better than
> the registry. SQL Server or any other real rdbms is even better.
>
> jon
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 5:58 PM
> Subject: Re: Registry size.
>
>
> > I host several sites with people and some really sloppy code.  Does
using
> a
> > MDB have any ramifications.  Also won't people be able to manipulate
this
> > database?!  They can't manipulate the registry since it is locked there
is
> > no CFregistry.
> >
> > Thanks,
> >
> > Neil
> >
> > - Original Message -
> > From: "Arden Weiss" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 27, 2001 9:59 PM
> > Subject: RE: Registry size.
> >
> >
> > > Time to move your client variables to ODBC source, etc... to avoid
> > CrAsHiTiSe.
> > >
> > >  ^
> > > / \__
> > >(@\___
> > >   /  O
> > >  /(_/
> > > /_/
> > > Whoof...
> > > 410-757-3487
> > >
> > > -Original Message-
> > > From: Neil H. [SMTP:[EMAIL PROTECTED]]
> > > Sent: Tuesday, March 27, 2001 7:47 PM
> > > To: CF-Talk
> > > Subject: Registry size.
> > >
> > > I noticed my registry is getting huge (128 megs) and that I increased
it
> > to
> > > 160 megs for space sakes but are the entries in there that I can
remove
> > from
> > > CF not collecting garbage?
> > >
> > > Thanks,
> > >
> > > Neil
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Registry size.

[Javier Woodhouse]

Use a username/password if it's a shared box...

> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 10, 2001 12:01 PM
> To: CF-Talk
> Subject: Re: Registry size.
> 
> 
> Jon,
> If there is ever an error in the dsn won't the server 
> throw the DSN
> name.  This would become a security issue since user X can 
> query user Y's
> client info?
> 
> Thanks,
> 
> Neil
> 
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 6:27 PM
> Subject: Re: Registry size.
> 
> 
> > Changing the client variables to be stored in a database is 
> one of the
> first
> > things I do on a new server. Using an Access database is 
> much better than
> > the registry. SQL Server or any other real rdbms is even better.
> >
> > jon
> > - Original Message -
> > From: "Neil H." <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, April 09, 2001 5:58 PM
> > Subject: Re: Registry size.
> >
> >
> > > I host several sites with people and some really sloppy 
> code.  Does
> using
> > a
> > > MDB have any ramifications.  Also won't people be able to 
> manipulate
> this
> > > database?!  They can't manipulate the registry since it 
> is locked there
> is
> > > no CFregistry.
> > >
> > > Thanks,
> > >
> > > Neil
> > >
> > > - Original Message -
> > > From: "Arden Weiss" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, March 27, 2001 9:59 PM
> > > Subject: RE: Registry size.
> > >
> > >
> > > > Time to move your client variables to ODBC source, 
> etc... to avoid
> > > CrAsHiTiSe.
> > > >
> > > >  ^
> > > > / \__
> > > >(@\___
> > > >   /  O
> > > >  /(_/
> > > > /_/
> > > > Whoof...
> > > > 410-757-3487
> > > >
> > > > -Original Message-
> > > > From: Neil H. [SMTP:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, March 27, 2001 7:47 PM
> > > > To: CF-Talk
> > > > Subject: Registry size.
> > > >
> > > > I noticed my registry is getting huge (128 megs) and 
> that I increased
> it
> > > to
> > > > 160 megs for space sakes but are the entries in there that I can
> remove
> > > from
> > > > CF not collecting garbage?
> > > >
> > > > Thanks,
> > > >
> > > > Neil
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Registry size.

[Neil H.]

Jon,
If there is ever an error in the dsn won't the server throw the DSN
name.  This would become a security issue since user X can query user Y's
client info?

Thanks,

Neil

- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 6:27 PM
Subject: Re: Registry size.


> Changing the client variables to be stored in a database is one of the
first
> things I do on a new server. Using an Access database is much better than
> the registry. SQL Server or any other real rdbms is even better.
>
> jon
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 5:58 PM
> Subject: Re: Registry size.
>
>
> > I host several sites with people and some really sloppy code.  Does
using
> a
> > MDB have any ramifications.  Also won't people be able to manipulate
this
> > database?!  They can't manipulate the registry since it is locked there
is
> > no CFregistry.
> >
> > Thanks,
> >
> > Neil
> >
> > - Original Message -
> > From: "Arden Weiss" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 27, 2001 9:59 PM
> > Subject: RE: Registry size.
> >
> >
> > > Time to move your client variables to ODBC source, etc... to avoid
> > CrAsHiTiSe.
> > >
> > >  ^
> > > / \__
> > >(@\___
> > >   /  O
> > >  /(_/
> > > /_/
> > > Whoof...
> > > 410-757-3487
> > >
> > > -Original Message-
> > > From: Neil H. [SMTP:[EMAIL PROTECTED]]
> > > Sent: Tuesday, March 27, 2001 7:47 PM
> > > To: CF-Talk
> > > Subject: Registry size.
> > >
> > > I noticed my registry is getting huge (128 megs) and that I increased
it
> > to
> > > 160 megs for space sakes but are the entries in there that I can
remove
> > from
> > > CF not collecting garbage?
> > >
> > > Thanks,
> > >
> > > Neil
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF 4.5 Automatic locking of session variables

[JAIME HOI]

actually i have alreadi selected that option but i still get the error that
i should use CFLOCK to lock session variables.

JAIME HOI



-Original Message-
From: Chris Michl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 8:54 AM
To: CF-Talk
Subject: RE: CF 4.5 Automatic locking of session variables


Yes - go into the CF Administrator, click on LOCKING from the menu on the
left. Towards the bottom of the scree you'll see the different locking
options. Select AUTOMATIC READ LOCKING for Application, Server or Session
variables. A couple of months ago there was some discussion regarding this
topic. Check the archives at
http://www.mail-archive.com/cf-talk@houseoffusion.com/.

Regards,
Chris

-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 7:44 PM
To: CF-Talk
Subject: CF 4.5 Automatic locking of session variables



may i ask whether if there is automatic locking for session variables? Cos
previously i code my application in CF4.0 and  most of the sessionn
variables are not locked. But now we are going to migrate to CF4.5. And
somehow the compiler produce an error when a session variable was not
locked. Instead of opening all the files and locking all the session
variables, is there a way whereby i can do a 1-time setting in the
administrator to auto-locked session variables?

JAIME HOI
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Passing a structure to JavaScript with wddx

[Marius Milosav]

Thanks Chris,

the problem is only related if I use action cfml2js. Is working fine if I
pass the structure to another page using cfml2wddx.

The error pops up when it tries to create the JavaScript object
stMsg=new Object(); stMsg.3=new Object();

It complains about missing ; between stMsg and .3

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm


- Original Message -
From: "Chris Michl" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 8:46 PM
Subject: RE: Passing a structure to JavaScript with wddx


> Marius,
>
> Here's some sample code. I'm dumping the WDDX packet into a client
variable
> which is used in another frame.
>
> 
> Basket=StructNew();
> rc=StructInsert(Basket, "Item", "#Trim(getPartInfo.item_no)#");
> rc=StructInsert(Basket, "Description", "#Trim(getPartInfo.item_desc_1)#");
> rc=StructInsert(Basket, "Price",
> "#Trim(NumberFormat(getPartInfo.Price,'9.99'))#");
> rc=StructInsert(Basket, "Prod_cat", "#Ucase(getPartInfo.prod_cat)#");
> rc=StructInsert(Basket, "Std_cost",
> "#Trim(NumberFormat(getPartInfo.std_cost,'9.99'))#");
> rc=StructInsert(Basket, "DiscRate", "#Trim(Variables.DiscRate)#");
> rc=StructInsert(Basket, "DiscPrice", "#Trim(Variables.DiscPrice)#");
> rc=StructInsert(Basket, "PriceBreakQty",
"#Trim(Variables.PriceBreakQty)#");
> rc=StructInsert(Basket, "PriceBasis", "#Trim(Variables.PriceBasis)#");
> rc=StructInsert(Basket, "PriceCodeType",
"#Trim(Variables.PriceCodeType)#");
> 
>
> 
> 
>
> 
>
> 
>
> 
> #wddxBasket.Item#
> #wddxBasket.Description#
> ETC.
> 
>
> Regards,
>
> Chris
>
>
>
> -Original Message-
> From: Marius Milosav [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 7:42 PM
> To: CF-Talk
> Subject: Passing a structure to JavaScript with wddx
>
>
> If anybody passed successfully a structure with wddx can you please let me
> know how.
>
> 
> gives a JavaScript error. :
> ; expected
>
> It works fine if I pass arrays or queries.
> myST is a valid structure and is populated
>
> Thanks
>
> Marius Milosav
> www.scorpiosoft.com
> It's not about technology, it's about people.
> Virtual Help Desk Demo (VHD)
> www.scorpiosoft.com/vhd/login.cfm
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[Steve Cohen]

Check out Tutorial 9 on www.flashcfm.com for integrating the feed into Flash
using CF.

Steve


-Original Message-
From: Vance Duke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 3:08:AM
To: CF-Talk
Subject: Moreover News Feed



I assume there are some people here using the Moreover.com News feed.  I was
wondering if someone might like to send me links to their site so I might
see how you implemented it.  I am not much on the "look and feel" side and
was looking to get some ideas.

Thanks in advance,
Vance Duke
Sr. CF Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF 4.5 Automatic locking of session variables

[Chris Michl]

Yes - go into the CF Administrator, click on LOCKING from the menu on the
left. Towards the bottom of the scree you'll see the different locking
options. Select AUTOMATIC READ LOCKING for Application, Server or Session
variables. A couple of months ago there was some discussion regarding this
topic. Check the archives at
http://www.mail-archive.com/cf-talk@houseoffusion.com/.

Regards,
Chris

-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 7:44 PM
To: CF-Talk
Subject: CF 4.5 Automatic locking of session variables



may i ask whether if there is automatic locking for session variables? Cos
previously i code my application in CF4.0 and  most of the sessionn
variables are not locked. But now we are going to migrate to CF4.5. And
somehow the compiler produce an error when a session variable was not
locked. Instead of opening all the files and locking all the session
variables, is there a way whereby i can do a 1-time setting in the
administrator to auto-locked session variables?

JAIME HOI
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Passing a structure to JavaScript with wddx

[Chris Michl]

Marius,

Here's some sample code. I'm dumping the WDDX packet into a client variable
which is used in another frame.


Basket=StructNew();
rc=StructInsert(Basket, "Item", "#Trim(getPartInfo.item_no)#");
rc=StructInsert(Basket, "Description", "#Trim(getPartInfo.item_desc_1)#");
rc=StructInsert(Basket, "Price",
"#Trim(NumberFormat(getPartInfo.Price,'9.99'))#");
rc=StructInsert(Basket, "Prod_cat", "#Ucase(getPartInfo.prod_cat)#");
rc=StructInsert(Basket, "Std_cost",
"#Trim(NumberFormat(getPartInfo.std_cost,'9.99'))#");
rc=StructInsert(Basket, "DiscRate", "#Trim(Variables.DiscRate)#");
rc=StructInsert(Basket, "DiscPrice", "#Trim(Variables.DiscPrice)#");
rc=StructInsert(Basket, "PriceBreakQty", "#Trim(Variables.PriceBreakQty)#");
rc=StructInsert(Basket, "PriceBasis", "#Trim(Variables.PriceBasis)#");
rc=StructInsert(Basket, "PriceCodeType", "#Trim(Variables.PriceCodeType)#");










#wddxBasket.Item#
#wddxBasket.Description#
ETC.


Regards,

Chris



-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 7:42 PM
To: CF-Talk
Subject: Passing a structure to JavaScript with wddx


If anybody passed successfully a structure with wddx can you please let me
know how.


gives a JavaScript error. :
; expected

It works fine if I pass arrays or queries.
myST is a valid structure and is populated

Thanks

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF 4.5 Automatic locking of session variables

[JAIME HOI]

may i ask whether if there is automatic locking for session variables? Cos
previously i code my application in CF4.0 and  most of the sessionn
variables are not locked. But now we are going to migrate to CF4.5. And
somehow the compiler produce an error when a session variable was not
locked. Instead of opening all the files and locking all the session
variables, is there a way whereby i can do a 1-time setting in the
administrator to auto-locked session variables?

JAIME HOI



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Passing a structure to JavaScript with wddx

[Marius Milosav]

If anybody passed successfully a structure with wddx can you please let me
know how.


gives a JavaScript error. :
; expected

It works fine if I pass arrays or queries.
myST is a valid structure and is populated

Thanks

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Moreover News Feed

[Kelly]

I am using it. We actually used the NON FREE version.  But its pretty much 
the same
just a hell of a lot more news. I just take the WDDX packet and through it 
into SQL and
then create the page the way I want it.   Our site is still under 
development but
when it launches I will send you the URL.
Kelly

At 12:38 PM 4/9/2001 -0500, you wrote:

>I assume there are some people here using the Moreover.com News feed.  I was
>wondering if someone might like to send me links to their site so I might
>see how you implemented it.  I am not much on the "look and feel" side and
>was looking to get some ideas.
>
>Thanks in advance,
>Vance Duke
>Sr. CF Programmer
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[Lee Fuller]

Too bad the moreover.com site won't answer.  8(



Lee Fuller
Chief Technical Officer
PrimeDNA Corporation 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[John Lucas]

Here's how we are using the moreover feeds:

http://www.wjol.com/news/national/index.cfm?fuseaction=currentheadlines

We created a database with the moreover feed information and then utilized
one of the moreover tags in the tag gallery to fetch the headlines.  The tag
creates files on the server that the web site displays.  Headlines are
rescheduled every hour using cfschedule.  We opted for this so that we did
not have to worry about timing out when moreover was not available.  I
believe that was suggested earlier in the thread.

John Lucas
[EMAIL PROTECTED]
http://www.fastestisp.com



-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:48 PM
To: CF-Talk
Subject: RE: Moreover News Feed


Its not a glorious site, its one of my "love jobs" - its currently under
redevelopment but have a look at www.region2ops.on.net and then select World
News. This is essentially straight out of the box from Moreover and uses a
string of keywords to search all feeds as there is no relevant subject feed.
Have a look at the code and  you will see what I mean - its JavaScript
based. I am currently redeveloping this site with PHP Nuke (www.phpnuke.org)
because it frees me up from about 99% of the maintenance which I can then
relegate to the brigade members through the PHP Nuke backend. I am currently
investigating using a XML feed from Moreover to replace this. It appears
that PHP Nuke supports connecting to a XML feed out of the box but I don't
quite understand it that well yet.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287




-Original Message-
From: Vance Duke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 3:08:AM
To: CF-Talk
Subject: Moreover News Feed



I assume there are some people here using the Moreover.com News feed.  I was
wondering if someone might like to send me links to their site so I might
see how you implemented it.  I am not much on the "look and feel" side and
was looking to get some ideas.

Thanks in advance,
Vance Duke
Sr. CF Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[Parker, Kevin]

Its not a glorious site, its one of my "love jobs" - its currently under
redevelopment but have a look at www.region2ops.on.net and then select World
News. This is essentially straight out of the box from Moreover and uses a
string of keywords to search all feeds as there is no relevant subject feed.
Have a look at the code and  you will see what I mean - its JavaScript
based. I am currently redeveloping this site with PHP Nuke (www.phpnuke.org)
because it frees me up from about 99% of the maintenance which I can then
relegate to the brigade members through the PHP Nuke backend. I am currently
investigating using a XML feed from Moreover to replace this. It appears
that PHP Nuke supports connecting to a XML feed out of the box but I don't
quite understand it that well yet.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287




-Original Message-
From: Vance Duke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 3:08:AM
To: CF-Talk
Subject: Moreover News Feed



I assume there are some people here using the Moreover.com News feed.  I was
wondering if someone might like to send me links to their site so I might
see how you implemented it.  I am not much on the "look and feel" side and
was looking to get some ideas.

Thanks in advance,
Vance Duke
Sr. CF Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SOT: SSL Accelerator Cards

[Cary Gordon]

We use nCypher cards.  They work and the company is good to work with. I 
would not characterize them as "low-cost," however.

That said, we do plan to do another round of eval in the next few months..

If you want (or anyone needs) more info, please contact me off list.

At 10:33 AM 4/9/2001 -0400, you wrote:
>Does anyone on the list have any experience with SSL Accelerator cards?  We
>are looking for a low-cost card for our server, and as part of our
>evaluation I'd really appreciate hearing from anyone who has used or looked
>at these cards.  Any recommendations or products to avoid?
>
>Thanks,
>Bob


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Registry size.

[Jon Hall]

Changing the client variables to be stored in a database is one of the first
things I do on a new server. Using an Access database is much better than
the registry. SQL Server or any other real rdbms is even better.

jon
- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 5:58 PM
Subject: Re: Registry size.


> I host several sites with people and some really sloppy code.  Does using
a
> MDB have any ramifications.  Also won't people be able to manipulate this
> database?!  They can't manipulate the registry since it is locked there is
> no CFregistry.
>
> Thanks,
>
> Neil
>
> - Original Message -
> From: "Arden Weiss" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 27, 2001 9:59 PM
> Subject: RE: Registry size.
>
>
> > Time to move your client variables to ODBC source, etc... to avoid
> CrAsHiTiSe.
> >
> >  ^
> > / \__
> >(@\___
> >   /  O
> >  /(_/
> > /_/
> > Whoof...
> > 410-757-3487
> >
> > -Original Message-
> > From: Neil H. [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 27, 2001 7:47 PM
> > To: CF-Talk
> > Subject: Registry size.
> >
> > I noticed my registry is getting huge (128 megs) and that I increased it
> to
> > 160 megs for space sakes but are the entries in there that I can remove
> from
> > CF not collecting garbage?
> >
> > Thanks,
> >
> > Neil
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: NT event log grabber / reader???

[Mark W. Breneman]

Nope, even check www.forta.com.

Any other Ideas?

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

-Original Message-
From: Tumy, Brad [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:22 PM
To: CF-Talk
Subject: RE: NT event log grabber / reader???


Ben Forta wrote a tag to display the event log...I am pretty sure about
this...I would do a search for all tags written by Forta

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:15 PM
To: CF-Talk
Subject: NT event log grabber / reader???



Has anyone built a Custom tag, or other wise, that can display the NT event
log on a HTML page or e-mail?

I have checked the Developers Exchange.  Only thing there is tags to write
to the event log.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: encrypt/decrypt

[Nick Texidor]

Apparently though, these are not recommended for use as there is no
guarantee they will be included in the next versions of CF.


on 10/04/01 5:10, Lewis Steven at [EMAIL PROTECTED] wrote:

> You can also use: cfusion_encrypt() and cfusion_decrypt().
> 
> cfusion_encrypt() encrypts the text to numbers and it is DB safe.
> 
> Steve
> 
> Will Swain wrote:
>> 
>> Thanks Zach,
>> 
>> I'll have a look at that
>> 
>> Cheers
>> 
>> Will
>> 
>> -Original Message-
>> From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]]
>> Sent: 05 April 2001 19:26
>> To: CF-Talk
>> Subject: RE: encrypt/decrypt
>> 
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>> 
>> The values that the CF Encrypt function creates usually aren't safe to
>> put into a database -- they're binary values if my memory serves
>> correctly.  The error you're getting is because Decrypt throws an error
>> if the value it gets isn't a valid value made by the Encrypt functions.
>> 
>> Before you put your values into the DB, you need to convert them to text
>> only values.  URLEncodedFormat() would work.  ToString() would probably
>> work too.  Then when you pull the value back out of the DB, you just
>> URLDecode() it.  I'm not sure how you turn ToString() back to it's
>> original form.  I thought it was ToBinary() or something, but I don't
>> see that in my quickref book
>> 
>> To guard against crashes b/c of modified, corrupted values, just
>> surround your Decrypt() function call in a CF Try block & handle it
>> accordingly.
>> 
>> 
>> 
>> 
>> INSERT INTO Table (Secret) VALUES( '#Gibberish#'
>> 
>> 
>> 
>> 
>> SELECT Secret
>> FROM Table
>> WHERE ...
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> The secret word is: #Secret#
>> 
>> Something broke...
>> 
>> 
>> Hope that's helpful.
>> 
>> Best regards,
>> Zac Bedell
>>> -Original Message-
>>> From: Will Swain [mailto:[EMAIL PROTECTED]]
>>> Sent: Thursday, April 05, 2001 7:16 AM
>>> To: CF-Talk
>>> Subject: encrypt/decrypt
>>> 
>>> 
>>> Hi guys,
>>> 
>>> Got an interesting one here. I am encrypting some details
>>> before entering
>>> them in a databse, then decrypting them as the authorised views them.
>>> 
>>> 
>>> However, I am getting this error on decryption:
>>> 
>>> Error Diagnostic Information
>>> 
>>> An error occurred while evaluating the expression:
>>> 
>>> 
>>>  decryptednumber = decrypt(encryptednumber, numberkey)
>>> 
>>> 
>>> 
>>> Error near line 25, column 8.
>>> --
>>> --
>>> 
>>> 
>>> The value to be decrypted is not valid
>>> 
>>> 
>>> This is the code I have in that location. Interestingly,
>>> decrtypting the
>>> name doesn't seem to cuase a problem:
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> This is the code on another page that encrypts the values:
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> Any ideas on this anyone??
>>> 
>>> TIA
>>> 
>>> Will Swain
>>> 
>>> 
>>> 
>>> 
>> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: odbc ole-db

[Nick McClure]

ODBC can do this as well. In the select statement you user 
Database.dbo.table in ODBC as well. It all depends on the security settings 
you have.

One of the big things about it is MS is discontinuing support of ODBC. 
Their preferred method is currently OLE DB. It also what they use to 
connect to Exchange and other data types.

At 04:45 PM 4/9/2001 -0500, you wrote:
>one big advantage with OLE DB over ODBC using SQL Server is this:
>
>ODBC - for each database you have to set up an DSN
>
>OLE DB - you set up one DSN and all the databases can be referenced via that
>ONE DSN
>
>Greg
>
>-Original Message-
>From: Mike [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 09, 2001 6:20 PM
>To: CF-Talk
>Subject: odbc ole-db
>
>
>odbc ole-db
>What is the deference's?
>Is there any advantage or disadvantage over one or the other?
>
>Thanks for the answers on the last question you guys are a life saver!
>Thanks
>Mike
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Registry size.

[Neil H.]

I host several sites with people and some really sloppy code.  Does using a
MDB have any ramifications.  Also won't people be able to manipulate this
database?!  They can't manipulate the registry since it is locked there is
no CFregistry.

Thanks,

Neil

- Original Message -
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 9:59 PM
Subject: RE: Registry size.


> Time to move your client variables to ODBC source, etc... to avoid
CrAsHiTiSe.
>
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
> /_/
> Whoof...
> 410-757-3487
>
> -Original Message-
> From: Neil H. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 27, 2001 7:47 PM
> To: CF-Talk
> Subject: Registry size.
>
> I noticed my registry is getting huge (128 megs) and that I increased it
to
> 160 megs for space sakes but are the entries in there that I can remove
from
> CF not collecting garbage?
>
> Thanks,
>
> Neil
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: odbc ole-db, stored proc

[dm]

this fixed it: 


SET NOCOUNT ON
Exec MyProc
SET NOCOUNT OFF






~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Cert: wait for 5.0?

[Billy Cravens]

Forta spoke at last month's Dallas/Ft. Worth CFUG, and he stated that you would need 
to get "re-certified" for
5.0.  I'm not sure if that's a full certification, or something like Microsoft does 
(abbreviated test(s) to cover
new stuff).  Ben, if I heard you wrong, please correct me.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

John Wilker wrote:

> As I understand it the current certification will be good through V5. I
> asked them after I took mine and while they hadn't finalized anything yet,
> the speculation was that it would be good through at least a version. i.e.
> 4.5 - 5, at at least. I know MS certs last 2 versions. An MCSE friend of
> mine had his SQL cert just expire and he was 6.5 certified. Hopefully
> Allaire will do something like that.
>
> Mine was 150.00 through VUE. I think it's vue.com there should be a link off
> the Allaire site in the certification section that takes you to the
> VUE/allaire page to sign up for the exam.
>
> J.
>
> John Wilker
> Web Applications Consultant
> Allaire Certified ColdFusion Developer
>
> www.red-omega.com 
>
> The Coca-Cola name in China was first read as "Kekoukela", meaning "Bite the
> wax tadpole" or "female horse stuffed with wax", depending on the dialect.
> Coke then researched 40,000 characters to find a phonetic equivalent "kokou
> kole", translating into "happiness in the mouth."
>
> -Original Message-
> From: Marc Garrett [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 6:15 AM
> To: CF-Talk
> Subject: CF Cert: wait for 5.0?
>
> Does anyone know how long after CF 5 is released before the certification
> exam becomes available? Is it better to take it now, or wait for the new
> exam?
>
> Also, I could not find pricing information on Allaire's site. Does anyone
> know the price?
>
> Thanks,
>
> Marc Garrett
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: odbc ole-db

[Greg Jordan]

one big advantage with OLE DB over ODBC using SQL Server is this:

ODBC - for each database you have to set up an DSN

OLE DB - you set up one DSN and all the databases can be referenced via that
ONE DSN

Greg

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:20 PM
To: CF-Talk
Subject: odbc ole-db


odbc ole-db
What is the deference's?
Is there any advantage or disadvantage over one or the other?

Thanks for the answers on the last question you guys are a life saver!
Thanks
Mike
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: encrypt/decrypt

[Jon Hall]

These are undocumented functions used by the cf admin. The syntax is exactly
the same as the standard encrypt() functions.

You can use this code with the standard encrypt functions to make the
strings db safe.

This produces a db safe string


This decrypts the string


jon
- Original Message -
From: "Jim Gurfein" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 5:01 PM
Subject: Re: encrypt/decrypt


> I've checked normal resources and can't find any documentation on
> cfusion_encrypt() and cfusion_decrypt(). Am I missing something?
>
>
> At 03:10 PM 4/9/01 -0400, you wrote:
> >You can also use: cfusion_encrypt() and cfusion_decrypt().
> >
> >cfusion_encrypt() encrypts the text to numbers and it is DB safe.
> >
> >Steve
> >
> >Will Swain wrote:
> > >
> > > Thanks Zach,
> > >
> > > I'll have a look at that
> > >
> > > Cheers
> > >
> > > Will
> > >
> > > -Original Message-
> > > From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]]
> > > Sent: 05 April 2001 19:26
> > > To: CF-Talk
> > > Subject: RE: encrypt/decrypt
> > >
> > > -BEGIN PGP SIGNED MESSAGE-
> > > Hash: SHA1
> > >
> > > The values that the CF Encrypt function creates usually aren't safe to
> > > put into a database -- they're binary values if my memory serves
> > > correctly.  The error you're getting is because Decrypt throws an
error
> > > if the value it gets isn't a valid value made by the Encrypt
functions.
> > >
> > > Before you put your values into the DB, you need to convert them to
text
> > > only values.  URLEncodedFormat() would work.  ToString() would
probably
> > > work too.  Then when you pull the value back out of the DB, you just
> > > URLDecode() it.  I'm not sure how you turn ToString() back to it's
> > > original form.  I thought it was ToBinary() or something, but I don't
> > > see that in my quickref book
> > >
> > > To guard against crashes b/c of modified, corrupted values, just
> > > surround your Decrypt() function call in a CF Try block & handle it
> > > accordingly.
> > >
> > > 
> > > 
> > > 
> > > INSERT INTO Table (Secret) VALUES( '#Gibberish#'
> > > 
> > >
> > > 
> > > 
> > > SELECT Secret
> > > FROM Table
> > > WHERE ...
> > > 
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > > 
> > > The secret word is: #Secret#
> > > 
> > > Something broke...
> > > 
> > >
> > > Hope that's helpful.
> > >
> > > Best regards,
> > > Zac Bedell
> > > > -Original Message-
> > > > From: Will Swain [mailto:[EMAIL PROTECTED]]
> > > > Sent: Thursday, April 05, 2001 7:16 AM
> > > > To: CF-Talk
> > > > Subject: encrypt/decrypt
> > > >
> > > >
> > > > Hi guys,
> > > >
> > > > Got an interesting one here. I am encrypting some details
> > > > before entering
> > > > them in a databse, then decrypting them as the authorised views
them.
> > > >
> > > >
> > > > However, I am getting this error on decryption:
> > > >
> > > > Error Diagnostic Information
> > > >
> > > > An error occurred while evaluating the expression:
> > > >
> > > >
> > > >  decryptednumber = decrypt(encryptednumber, numberkey)
> > > >
> > > >
> > > >
> > > > Error near line 25, column 8.
> > > > --
> > > > --
> > > > 
> > > >
> > > > The value to be decrypted is not valid
> > > >
> > > >
> > > > This is the code I have in that location. Interestingly,
> > > > decrtypting the
> > > > name doesn't seem to cuase a problem:
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > >
> > > > This is the code on another page that encrypts the values:
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > 
> > > >
> > > > Any ideas on this anyone??
> > > >
> > > > TIA
> > > >
> > > > Will Swain
> > > >
> > > >
> > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: odbc ole-db, stored proc

[Greg Jordan]

did you add an OLE DB DSN in the CF administrator?

Greg

-Original Message-
From: dm [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:34 PM
To: CF-Talk
Subject: RE: odbc ole-db, stored proc


running a stored procedure on sql server 2k.
sp executes fine from query analyzer and
returns a result.
when i try to call the sp from cf using
either cfquery or cfstoredproc
i get a 'query does not exist error' on the output.
that was/is on an OLEDB connection.

added an odbc datasource and the problem is gone,
i.e., the query is found and the results outputted.

what do i need to do to get the sp to
work under OLE as it does under ODBC?

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:20 PM
To: CF-Talk
Subject: odbc ole-db


odbc ole-db
What is the deference's?
Is there any advantage or disadvantage over one or the other?

Thanks for the answers on the last question you guys are a life saver!
Thanks
Mike
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Movie Show Time Feed (was: RE: Moreover News Feed)

[mjones]

Probably not exactly what you are looking for, but this is from
www.zap2it.com


http://www.zap2it.com/movies/zipcode/change/side/1,1243,-5--,00.html
" target="_new">
http://www.zap2it.com/movies">
http://www.zap2it.com/affiliates/zap2it_widlogo.gif"
WIDTH="100" HEIGHT="16" BORDER="0" ALT="Zap2it.com Movies">
http://www.zap2it.com/affiliates/movieshowtimes.gif"
WIDTH="100" HEIGHT="13" BORDER="0" ALT="Showtimes">

http://www.zap2it.com/affiliates/getshowtimes.gif" height="13"
width="100" border=0 alt="Input Zip">


 


-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 4:07 PM
To: CF-Talk
Subject: Movie Show Time Feed (was: RE: Moreover News Feed)


I don't suppose anyone has found a service similar to Moreover or iSyndicate
that feeds national movie show times and other pertinent information about
movies (e.g. reviews, theater locations, etc.)?

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Movie Show Time Feed (was: RE: Moreover News Feed)

[Benjamin S. Rogers]

I don't suppose anyone has found a service similar to Moreover or iSyndicate
that feeds national movie show times and other pertinent information about
movies (e.g. reviews, theater locations, etc.)?

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: encrypt/decrypt

[Jim Gurfein]

I've checked normal resources and can't find any documentation on 
cfusion_encrypt() and cfusion_decrypt(). Am I missing something?


At 03:10 PM 4/9/01 -0400, you wrote:
>You can also use: cfusion_encrypt() and cfusion_decrypt().
>
>cfusion_encrypt() encrypts the text to numbers and it is DB safe.
>
>Steve
>
>Will Swain wrote:
> >
> > Thanks Zach,
> >
> > I'll have a look at that
> >
> > Cheers
> >
> > Will
> >
> > -Original Message-
> > From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]]
> > Sent: 05 April 2001 19:26
> > To: CF-Talk
> > Subject: RE: encrypt/decrypt
> >
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > The values that the CF Encrypt function creates usually aren't safe to
> > put into a database -- they're binary values if my memory serves
> > correctly.  The error you're getting is because Decrypt throws an error
> > if the value it gets isn't a valid value made by the Encrypt functions.
> >
> > Before you put your values into the DB, you need to convert them to text
> > only values.  URLEncodedFormat() would work.  ToString() would probably
> > work too.  Then when you pull the value back out of the DB, you just
> > URLDecode() it.  I'm not sure how you turn ToString() back to it's
> > original form.  I thought it was ToBinary() or something, but I don't
> > see that in my quickref book
> >
> > To guard against crashes b/c of modified, corrupted values, just
> > surround your Decrypt() function call in a CF Try block & handle it
> > accordingly.
> >
> > 
> > 
> > 
> > INSERT INTO Table (Secret) VALUES( '#Gibberish#'
> > 
> >
> > 
> > 
> > SELECT Secret
> > FROM Table
> > WHERE ...
> > 
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > The secret word is: #Secret#
> > 
> > Something broke...
> > 
> >
> > Hope that's helpful.
> >
> > Best regards,
> > Zac Bedell
> > > -Original Message-
> > > From: Will Swain [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, April 05, 2001 7:16 AM
> > > To: CF-Talk
> > > Subject: encrypt/decrypt
> > >
> > >
> > > Hi guys,
> > >
> > > Got an interesting one here. I am encrypting some details
> > > before entering
> > > them in a databse, then decrypting them as the authorised views them.
> > >
> > >
> > > However, I am getting this error on decryption:
> > >
> > > Error Diagnostic Information
> > >
> > > An error occurred while evaluating the expression:
> > >
> > >
> > >  decryptednumber = decrypt(encryptednumber, numberkey)
> > >
> > >
> > >
> > > Error near line 25, column 8.
> > > --
> > > --
> > > 
> > >
> > > The value to be decrypted is not valid
> > >
> > >
> > > This is the code I have in that location. Interestingly,
> > > decrtypting the
> > > name doesn't seem to cuase a problem:
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >
> > >
> > > This is the code on another page that encrypts the values:
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >
> > > Any ideas on this anyone??
> > >
> > > TIA
> > >
> > > Will Swain
> > >
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Little OT: Security on NT, IIS, and CF

[Terry Bader]

can ppl upload files to your site??
if so are they restricted on the file types? (dont want any cfm or any other
executables uploaded)
if not, have you restricted the REGISTRY, CFDIRECTORY adn CFFILE in CF
ADMIN??

are you on NT4 with IIS??  make sure the Update for the .htr has been
installed (i.e. try: http://domainname/index.cfm+.htr and look at the
source, if it contains CF code, better go get the update)


when pages are accessed with url variables, and doing queries, look for
correct datatypes being passed and that semi-colons arent in the url
variable being used in the query

hmm...  thats a few...



Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 4:14 PM
> To: CF-Talk
> Subject: Little OT: Security on NT, IIS, and CF
> 
> 
>   Ok we are about to go live here soon and am looking at 
> Security to
> really lock down the servers. Now I know people can append 
> things to the url
> I check for that, or add things to a form, I check for that 
> also. Only thing
> I need to know is if there is still a security lax with MDAC 
> where someone
> could send a query to a url and drop a table. Can that still 
> be done? I am
> slowly going through Microsoft's checklist for everything. Is there an
> allair err Macromedia checklist? Also anyone have any 
> recomendations for a
> security scanner so I can double check everything after I am done.
> 
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Little OT: Security on NT, IIS, and CF

[Bob Silverberg]

You may already have covered this, but to avoid people sending bad SQL (like
a drop table statement) to your db, make sure that all numeric fields being
passed to the database are surrounded by the Val function:

Don't do:

SELECT * FROM MyTable WHERE MyId = #form.MyId#

Do:

SELECT * FROM MyTable WHERE MyId = #Val(form.MyId)#

Bob

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: April 9, 2001 4:14 PM
To: CF-Talk
Subject: Little OT: Security on NT, IIS, and CF


Ok we are about to go live here soon and am looking at Security to
really lock down the servers. Now I know people can append things to the url
I check for that, or add things to a form, I check for that also. Only thing
I need to know is if there is still a security lax with MDAC where someone
could send a query to a url and drop a table. Can that still be done? I am
slowly going through Microsoft's checklist for everything. Is there an
allair err Macromedia checklist? Also anyone have any recomendations for a
security scanner so I can double check everything after I am done.

Robert Everland III
Web Developer
Dixon Ticonderoga
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Little OT: Security on NT, IIS, and CF

[Jon Hall]

Dont forget msadc...
Here is a nice little list of ways MS is making hackers job easier everyday.

http://www.guninski.com/win2k.html

jon
- Original Message -
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 4:13 PM
Subject: Little OT: Security on NT, IIS, and CF


> Ok we are about to go live here soon and am looking at Security to
> really lock down the servers. Now I know people can append things to the
url
> I check for that, or add things to a form, I check for that also. Only
thing
> I need to know is if there is still a security lax with MDAC where someone
> could send a query to a url and drop a table. Can that still be done? I am
> slowly going through Microsoft's checklist for everything. Is there an
> allair err Macromedia checklist? Also anyone have any recomendations for a
> security scanner so I can double check everything after I am done.
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: odbc ole-db, stored proc

[dm]

running a stored procedure on sql server 2k.
sp executes fine from query analyzer and
returns a result.
when i try to call the sp from cf using
either cfquery or cfstoredproc
i get a 'query does not exist error' on the output.
that was/is on an OLEDB connection.

added an odbc datasource and the problem is gone, 
i.e., the query is found and the results outputted. 

what do i need to do to get the sp to 
work under OLE as it does under ODBC? 

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:20 PM
To: CF-Talk
Subject: odbc ole-db


odbc ole-db 
What is the deference's?
Is there any advantage or disadvantage over one or the other?

Thanks for the answers on the last question you guys are a life saver!
Thanks 
Mike



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF Cert: wait for 5.0?

[Marc Garrett]

Thanks guys.

Marc

"Terry Bader" <[EMAIL PROTECTED]> wrote in message
210EF7B72E71D311903D00105AA333DF51C6F2@EXCHANGESERVER">news:210EF7B72E71D311903D00105AA333DF51C6F2@EXCHANGESERVER...
> $150..
>
> www.vue.com/allaire




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SMTP Server

[Jon Hall]

Can you install cfx tags? If so, this would be yet another recomendation for
coolfusion.com's cfx_ims mail server... ;-) It's a cfx smtp server. However
I dont see the reason for not runnng an smtp server...If the server is not
yours, and the smtp server for bouldernetwork.com cant be configured to
allow the site to relay, just set one up on any machine that is on the net
24/7...

jon
- Original Message -
From: "Brian Thornton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 3:16 PM
Subject: SMTP Server


> We have client that is hosting offsite. They now have the need to
generating email messages via CFMAIL. Anyone know of a company we can send
through for a monthly fee without moving locations?
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: QUERY PROBLEM

[Peter J. MacDonald]

Order BY GDATE

Thank You,
Peter

Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:53 PM
To: CF-Talk
Subject: QUERY PROBLEM


I am trying to pull the next baseball game from a schedule I have in an
Access database. When it processes it pulls the next game to a degree. If
there is a game today it will not pull that game. Example there is a game
today 4/9/2001 and the ext game it displays is 4/10/2001  Any ideas?




SELECT *
FROM schedule
WHERE gdate >= #today#


ALSO HAD IT AS


SELECT *
FROM schedule
WHERE gdate >= NOW()



Thanks.

Brian Hasselback
[EMAIL PROTECTED]
http://www.intent.net
http://www.hasselback.com
Web Hosting & Development
(502) 452-1851
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SMTP Server

[Tumy, Brad]

can't you just use pop3.microsoft.com like everyone else in the free world
:) 

sorry, just kidding.

Check with your host...most of them have SMTP configured.

-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 4:23 PM
To: CF-Talk
Subject: RE: SMTP Server


For SMTP, you should usually be allowed to use the ISP's mailserver.  They
almost always will aloow you to send outgoing mail through their server,
even if you don't use them for your POP accounts.

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 3:55 PM
> To: CF-Talk
> Subject: Re: SMTP Server
>
>
> Don't have one we outsource it for virus protection etc...
> - Original Message -
> From: "Nick McClure" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 12:37 PM
> Subject: Re: SMTP Server
>
>
> > Any reason why you can't run your own smtp server?
> >
> >
> > At 12:16 PM 4/9/2001 -0700, you wrote:
> > >We have client that is hosting offsite. They now have the need to
> > >generating email messages via CFMAIL. Anyone know of a company we can
> send
> > >through for a monthly fee without moving locations?
> > >
> > >
> > >
> >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Little OT: Security on NT, IIS, and CF

[Robert Everland]

Ok we are about to go live here soon and am looking at Security to
really lock down the servers. Now I know people can append things to the url
I check for that, or add things to a form, I check for that also. Only thing
I need to know is if there is still a security lax with MDAC where someone
could send a query to a url and drop a table. Can that still be done? I am
slowly going through Microsoft's checklist for everything. Is there an
allair err Macromedia checklist? Also anyone have any recomendations for a
security scanner so I can double check everything after I am done.

Robert Everland III
Web Developer
Dixon Ticonderoga

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

odbc ole-db

[Mike]

odbc ole-db 
What is the deference's?
Is there any advantage or disadvantage over one or the other?

Thanks for the answers on the last question you guys are a life saver!
Thanks 
Mike

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Certified ColdFusion Developer Study Guide

[Peter J. MacDonald]

My Company ordered it and we had it last week.  I have not looked at it yet.

Thank You,
Peter

Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com



-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 9:07 AM
To: CF-Talk
Subject: RE: Certified ColdFusion Developer Study Guide


You can order it on Amazon.  Its due to ship very shortly, if its not
already.  I ordered a copy about a month ago, but am yet to have delivery of
it...

Nick.

-Original Message-
From: Richard L Smith [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2001 13:37
To: CF-Talk
Subject: Re: Certified ColdFusion Developer Study Guide


Kelly,

This is the first I have heard of it.
Where do you get it.

Rick
- Original Message -
From: "Kelly" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, April 07, 2001 12:30 PM
Subject: Certified ColdFusion Developer Study Guide


> Has anyone picked it up yet?  I  think I am going to get a copy today.
Just
> wanted
> to hear your thoughts if you got it.
> Kelly
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SMTP Server

[Cameron Childress]

For SMTP, you should usually be allowed to use the ISP's mailserver.  They
almost always will aloow you to send outgoing mail through their server,
even if you don't use them for your POP accounts.

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 3:55 PM
> To: CF-Talk
> Subject: Re: SMTP Server
>
>
> Don't have one we outsource it for virus protection etc...
> - Original Message -
> From: "Nick McClure" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 12:37 PM
> Subject: Re: SMTP Server
>
>
> > Any reason why you can't run your own smtp server?
> >
> >
> > At 12:16 PM 4/9/2001 -0700, you wrote:
> > >We have client that is hosting offsite. They now have the need to
> > >generating email messages via CFMAIL. Anyone know of a company we can
> send
> > >through for a monthly fee without moving locations?
> > >
> > >
> > >
> >
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[Benjamin S. Rogers]

Next time, you may want to avoid off topic post and spare the developer the
public criticism by sending a message directly to the developer, the company
hosting the site, or to the contact address listed on the site.

In any case, I'll pass on your observation to the appropriate FoodCount.com
staff member.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

-Original Message-
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:45 PM
To: CF-Talk
Subject: Re: Moreover News Feed


Not to be picky, but there's a blatant typo on your site.  On the "My Diet"
page, under "Add Your Foods" you've got "locate" spelled "loate". 
 (BTW - nobody's worse than me at making typos)

Dave


- Original Message -
From: "Benjamin S. Rogers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 2:33 PM
Subject: RE: Moreover News Feed


> A scheduled task queries MoreOver once an hour (or when the page below
first
> loads) and deserializes the WDDX feed into a query that is stored in the
> application scope.
>
> Anyway, the actual display is nothing terribly interesting. We just use
the
> extra content to liven up the site a bit.
>
> http://www.foodcount.com/Index.cfm?Method=Nutrition
>
> Benjamin S. Rogers
> Web Developer, c4.net
> Voice: (508) 240-0051
> Fax: (508) 240-0057
>
> -Original Message-
> From: Vance Duke [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 1:38 PM
> To: CF-Talk
> Subject: Moreover News Feed
>
>
>
> I assume there are some people here using the Moreover.com News feed.  I
was
> wondering if someone might like to send me links to their site so I might
> see how you implemented it.  I am not much on the "look and feel" side and
> was looking to get some ideas.
>
> Thanks in advance,
> Vance Duke
> Sr. CF Programmer
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SMTP Server

[Brian bouldernet]

Don't have one we outsource it for virus protection etc...
- Original Message -
From: "Nick McClure" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 12:37 PM
Subject: Re: SMTP Server


> Any reason why you can't run your own smtp server?
>
>
> At 12:16 PM 4/9/2001 -0700, you wrote:
> >We have client that is hosting offsite. They now have the need to
> >generating email messages via CFMAIL. Anyone know of a company we can
send
> >through for a monthly fee without moving locations?
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: QUERY PROBLEM

[brian]

My formatting for the dates in the database is m/d/ It matches my today
variable. Also if there isnt a game today I want tit to display the next
game. It is a Date/Time object in the database.

Thanks

-Original Message-
From: Truman Esmond III [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:24 PM
To: CF-Talk
Subject: RE: QUERY PROBLEM


Comparing dates are fun - here's a couple suggestions:

-check your formatting of the date object you're comparing and format your
where-clause date to be exactly the same format as appears in the DB (i.e.
smalldate time, ODBC d/t obj. etc.); relying on the auto conversion within
ODBC has yielded unpredictable results for me...

-Make sure it's a Date/Time object in the DB...

-Pass in (as defaults if necessary) all date/time elements that exist in the
DB data (i.e. if seconds exist, have them in the compare value even if its
:00...

-If you want all games later than today, get rid of the = in your where
clause(s)

-If you only want the next (1) record, use the "top" function in the SQL to
get the first record

-It will help performance if you set up an index on your dates in the DB
table...

Hope these quick comments help.  If I think of others I'll post 'em!

Truman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 12:53 PM
To: CF-Talk
Subject: QUERY PROBLEM


I am trying to pull the next baseball game from a schedule I have in an
Access database. When it processes it pulls the next game to a degree. If
there is a game today it will not pull that game. Example there is a game
today 4/9/2001 and the ext game it displays is 4/10/2001  Any ideas?




SELECT *
FROM schedule
WHERE gdate >= #today#


ALSO HAD IT AS


SELECT *
FROM schedule
WHERE gdate >= NOW()



Thanks.

Brian Hasselback
[EMAIL PROTECTED]
http://www.intent.net
http://www.hasselback.com
Web Hosting & Development
(502) 452-1851
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Moreover News Feed

[Dave Hannum]

Just a little FYI on my experience using the news feeds, whether it's from
Moreover.com or iSyndicate.com.  Your best bet is to run a background
harvesting app and put the links, headlines and source info into a local
database and call it up from there.  Experience with both of these has
taught me that if they're down, or if there is a network problem or
congestion, your pages can take an excruciatingly long time to load or maybe
even not load at all - depending on how you've coded the page.  You can
either write the harvest load into a database or even write it out to a file
with CFFILE and call it with a CFINCLUDE.  This will make your page load
MUCH faster and maybe even prevent non-loading.

Dave


- Original Message -
From: "Jeff Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 3:05 PM
Subject: Moreover News Feed


> Okay, maybe I live under a rock or something, but I gotta ask. What
exactly
> *is* the moreover news feed? Is it a news service that lets you use that
> cfhttp tag and pull news stuff from their site? Does it cost money? How
does
> it work? It seems really cool on your site, and I'm curious as to how this
> all works...
>
> Jeff Small
>
> on 4/9/01 2:33 PM, Benjamin S. Rogers at [EMAIL PROTECTED] wrote:
>
> > A scheduled task queries MoreOver once an hour (or when the page below
first
> > loads) and deserializes the WDDX feed into a query that is stored in the
> > application scope.
> >
> > Anyway, the actual display is nothing terribly interesting. We just use
the
> > extra content to liven up the site a bit.
> >
> > http://www.foodcount.com/Index.cfm?Method=Nutrition
> >
> > Benjamin S. Rogers
> > Web Developer, c4.net
> > Voice: (508) 240-0051
> > Fax: (508) 240-0057
> >
> > -Original Message-
> > From: Vance Duke [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 09, 2001 1:38 PM
> > To: CF-Talk
> > Subject: Moreover News Feed
> >
> >
> >
> > I assume there are some people here using the Moreover.com News feed.  I
was
> > wondering if someone might like to send me links to their site so I
might
> > see how you implemented it.  I am not much on the "look and feel" side
and
> > was looking to get some ideas.
> >
> > Thanks in advance,
> > Vance Duke
> > Sr. CF Programmer
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Moreover News Feed

[Dave Hannum]

Not to be picky, but there's a blatant typo on your site.  On the "My Diet"
page, under "Add Your Foods" you've got "locate" spelled "loate". 
 (BTW - nobody's worse than me at making typos)

Dave


- Original Message -
From: "Benjamin S. Rogers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 2:33 PM
Subject: RE: Moreover News Feed


> A scheduled task queries MoreOver once an hour (or when the page below
first
> loads) and deserializes the WDDX feed into a query that is stored in the
> application scope.
>
> Anyway, the actual display is nothing terribly interesting. We just use
the
> extra content to liven up the site a bit.
>
> http://www.foodcount.com/Index.cfm?Method=Nutrition
>
> Benjamin S. Rogers
> Web Developer, c4.net
> Voice: (508) 240-0051
> Fax: (508) 240-0057
>
> -Original Message-
> From: Vance Duke [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 1:38 PM
> To: CF-Talk
> Subject: Moreover News Feed
>
>
>
> I assume there are some people here using the Moreover.com News feed.  I
was
> wondering if someone might like to send me links to their site so I might
> see how you implemented it.  I am not much on the "look and feel" side and
> was looking to get some ideas.
>
> Thanks in advance,
> Vance Duke
> Sr. CF Programmer
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SMTP Server

[savan . thongvanh]

huh?




"Brian Thornton" <[EMAIL PROTECTED]> on 04/09/2001 02:16:29 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:

Subject:  SMTP Server


We have client that is hosting offsite. They now have the need to
generating email messages via CFMAIL. Anyone know of a company we can send
through for a monthly fee without moving locations?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SMTP Server

[Nick McClure]

Any reason why you can't run your own smtp server?


At 12:16 PM 4/9/2001 -0700, you wrote:
>We have client that is hosting offsite. They now have the need to 
>generating email messages via CFMAIL. Anyone know of a company we can send 
>through for a monthly fee without moving locations?
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: QUERY PROBLEM

[Truman Esmond III]

Comparing dates are fun - here's a couple suggestions:

-check your formatting of the date object you're comparing and format your
where-clause date to be exactly the same format as appears in the DB (i.e.
smalldate time, ODBC d/t obj. etc.); relying on the auto conversion within
ODBC has yielded unpredictable results for me...

-Make sure it's a Date/Time object in the DB...

-Pass in (as defaults if necessary) all date/time elements that exist in the
DB data (i.e. if seconds exist, have them in the compare value even if its
:00...

-If you want all games later than today, get rid of the = in your where
clause(s)

-If you only want the next (1) record, use the "top" function in the SQL to
get the first record

-It will help performance if you set up an index on your dates in the DB
table...

Hope these quick comments help.  If I think of others I'll post 'em!

Truman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 12:53 PM
To: CF-Talk
Subject: QUERY PROBLEM


I am trying to pull the next baseball game from a schedule I have in an
Access database. When it processes it pulls the next game to a degree. If
there is a game today it will not pull that game. Example there is a game
today 4/9/2001 and the ext game it displays is 4/10/2001  Any ideas?




SELECT *
FROM schedule
WHERE gdate >= #today#


ALSO HAD IT AS


SELECT *
FROM schedule
WHERE gdate >= NOW()



Thanks.

Brian Hasselback
[EMAIL PROTECTED]
http://www.intent.net
http://www.hasselback.com
Web Hosting & Development
(502) 452-1851
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: QUERY PROBLEM

[Todd Stanley]

Date is probably a date/time function.  So your definition of 'today' needs
to be a little more exact.  My point being, you probably have the date
(4/9/2001) stored as:  04/09/2001 00:00:00.000 and when you do the now()
function Access is seeing that as 04/09/2001 15:30:29.001 which is actually
later then the date you have stored.  This will always be something to look
for with datetime fields.  I work mostly with SQL, not Access, so this may
or not be the case for you.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:53 PM
To: CF-Talk
Subject: QUERY PROBLEM


I am trying to pull the next baseball game from a schedule I have in an
Access database. When it processes it pulls the next game to a degree. If
there is a game today it will not pull that game. Example there is a game
today 4/9/2001 and the ext game it displays is 4/10/2001  Any ideas?




SELECT *
FROM schedule
WHERE gdate >= #today#


ALSO HAD IT AS


SELECT *
FROM schedule
WHERE gdate >= NOW()



Thanks.

Brian Hasselback
[EMAIL PROTECTED]
http://www.intent.net
http://www.hasselback.com
Web Hosting & Development
(502) 452-1851
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[Benjamin S. Rogers]

The service we are discussing is offered free of charge by MoreOver.com.
They provide categorically organized news feeds, updated by hand by their
own staff members. The news feeds are provided in several different formats,
one of which is WDDX.

Because MoreOver is only providing bibliographic information about the
articles, they do not need to charge any royalty fees. They have in turn
provided this service free of charge to developers.

MoreOver has many other services that it does charge for, including
supplying the news content to several high profile sites such as AltaVista.

In any case, the MoreOver is a good quick and dirty way to add more content
to a site free of charge. It is really a good deal all around.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:06 PM
To: CF-Talk
Subject: Moreover News Feed


Okay, maybe I live under a rock or something, but I gotta ask. What exactly
*is* the moreover news feed? Is it a news service that lets you use that
cfhttp tag and pull news stuff from their site? Does it cost money? How does
it work? It seems really cool on your site, and I'm curious as to how this
all works...

Jeff Small

on 4/9/01 2:33 PM, Benjamin S. Rogers at [EMAIL PROTECTED] wrote:

> A scheduled task queries MoreOver once an hour (or when the page below
first
> loads) and deserializes the WDDX feed into a query that is stored in the
> application scope.
>
> Anyway, the actual display is nothing terribly interesting. We just use
the
> extra content to liven up the site a bit.
>
> http://www.foodcount.com/Index.cfm?Method=Nutrition
>
> Benjamin S. Rogers
> Web Developer, c4.net
> Voice: (508) 240-0051
> Fax: (508) 240-0057
>
> -Original Message-
> From: Vance Duke [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 1:38 PM
> To: CF-Talk
> Subject: Moreover News Feed
>
>
>
> I assume there are some people here using the Moreover.com News feed.  I
was
> wondering if someone might like to send me links to their site so I might
> see how you implemented it.  I am not much on the "look and feel" side and
> was looking to get some ideas.
>
> Thanks in advance,
> Vance Duke
> Sr. CF Programmer
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop is not working please suggest ..

[paul .]

Hi Jeff!.
 qry_get_team_members returns the members who and all added ..

please have a look at this this is the code..
--- 
  
 
   

  
  #qry_get_team_members.name[loopcount]# 
  


---
this is the query

select * from MEMBERS where team_idx=#session.team_idx#  





--

On Mon, 09 Apr 2001 11:44:04  
 Garza, Jeff wrote:
>Ok, so what is the output of qry_get_team_members and qry_get_meetings.
>
>Are you returning the proper resultsets from these queries?
>
>Jeff Garza
>Web Developer/Webmaster
>Spectrum Astro, Inc.
>480.892.8200
>
>[EMAIL PROTECTED]
>http://www.spectrumastro.com
>
>
>
>-Original Message-
>From: paul . [mailto:[EMAIL PROTECTED]] 
>Sent: Monday, April 09, 2001 11:01 AM
>To: CF-Talk
>Subject: RE: cfloop is not working please suggest ..
>
>
> 
>--well jeff thanks..
>but am indexing because i need to make the members display first and make
>them absentees for the meeting..
>the issue is am adding the members and indexing them and make them absent
>later.
>here the case is am adding them.. its fine and and displays the first added
>person.. when i make the fisrt guy absent only the next member it shows..
>but i want all of the guys who are added so that i can make any of them
>absent
>-got it?? help me please .. but the same thing works elsewhere but not here
>-paul
>
>On Mon, 09 Apr 2001 10:28:42  
> Garza, Jeff wrote:
>>Why are you using a indexed loop when you can loop on the query??? 
>>
>>
>>  
>>#name#
>>  
>>
>>
>>
>>  
>>  
>>
>>
>>Also, you need to use a cfoutput tag pair within your cfloop to display the
>>ouput.  Also, If you are getting no output, make sure that you are properly
>>closing your TR's and TD's.  Netscape will puke if all is not right within
>>your table structure.
>>
>>Jeff Garza
>>Web Developer/Webmaster
>>Spectrum Astro, Inc.
>>480.892.8200
>>
>>[EMAIL PROTECTED]
>>http://www.spectrumastro.com
>>
>>
>>
>>-Original Message-
>>From: paul . [mailto:[EMAIL PROTECTED]] 
>>Sent: Monday, April 09, 2001 10:02 AM
>>To: CF-Talk
>>Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
>>suggest
>>
>>
>> hey guys please do suggest 
>>-paul
>>--
>>
>>On Mon, 09 Apr 2001 09:27:06  
>> paul . wrote:
>>>Hi all !.. i am using the following coding But it shows just the first
>>record only not all that records which match the query.. is this cfloop is
>>not working..? But 'indexing' its doing..
>>>please suggest
>>>-paul
>>>
>>>
>>>
>>>  
>>>  
>>>  #qry_get_team_members.name[loopcount]#
>
>>>  
>>>
>>>
>>>  
>>>
>>>
>>>  
>>>
>>>
>>>Get 250 color business cards for FREE! at Lycos Mail
>>>http://mail.lycos.com/freemail/vistaprint_index.html
>>>
>>
>>>
>
>>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SMTP Server

[Brian Thornton]

We have client that is hosting offsite. They now have the need to generating email 
messages via CFMAIL. Anyone know of a company we can send through for a monthly fee 
without moving locations?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:Printing, page breaks, and heading info

[Terri Stocke]

Okay, I moved it and tried it in the body, and then in a paragraph tag. Both 
instances caused the blue screen when I tried to print (it still printed, 
but killed my PC).

So, I guess I either need to find a way to print the top info I want on 
every page, or if that is not possible with just CF and the browser, dump 
the info to PDF per Adrian's suggestion and see if I can manipulate it that 
way...

Thanks for the help!


Original Message Follows
From: [EMAIL PROTECTED] (Carol Bluestein)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re:Printing, page breaks, and heading info
Date: Mon, 09 Apr 2001 09:42:02 -0400

Believe you can't use the style=page-break etc. inside a table.
So you have to count rows and end your table, put in the
break, and start a new table for each page.


Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:Printing, page breaks, and heading info
Author: [EMAIL PROTECTED]
Date:   4/9/01 12:48 PM

Hey all,

I have a shipping and receiving application that allows employees to
generate a shipping request via the web. The shipping dept. would like that
form to be printed out by the user, but they want one of two things when
this happens:

1) Either only allow the maximum number of items that will print on one
page, and prompt the user to fill out a second form for additional items; OR

2) Automatically have the app insert a break between the item in the last
row of the table and the next table row on the next page, but ALSO make sure
that the shipping address and other info is ALSO printed on each subsequent
page.

I favor the second method, since it is less hassle for the user, and it
would be easier to just insert a break in the table than to try to guess how
many characters a user might enter onto the page (virtually impossible to
determine how many pages they will need).

After searching the archives, I found the snippet I thought would work:
. I tried this in both the body tag
and in my table tag, but each time I used it I got the dreaded blue screen
o' death. I then found and tried a variation: http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: encrypt/decrypt

[Lewis Steven]

You can also use: cfusion_encrypt() and cfusion_decrypt().

cfusion_encrypt() encrypts the text to numbers and it is DB safe.

Steve

Will Swain wrote:
> 
> Thanks Zach,
> 
> I'll have a look at that
> 
> Cheers
> 
> Will
> 
> -Original Message-
> From: Zachary S. Bedell [mailto:[EMAIL PROTECTED]]
> Sent: 05 April 2001 19:26
> To: CF-Talk
> Subject: RE: encrypt/decrypt
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> The values that the CF Encrypt function creates usually aren't safe to
> put into a database -- they're binary values if my memory serves
> correctly.  The error you're getting is because Decrypt throws an error
> if the value it gets isn't a valid value made by the Encrypt functions.
> 
> Before you put your values into the DB, you need to convert them to text
> only values.  URLEncodedFormat() would work.  ToString() would probably
> work too.  Then when you pull the value back out of the DB, you just
> URLDecode() it.  I'm not sure how you turn ToString() back to it's
> original form.  I thought it was ToBinary() or something, but I don't
> see that in my quickref book
> 
> To guard against crashes b/c of modified, corrupted values, just
> surround your Decrypt() function call in a CF Try block & handle it
> accordingly.
> 
> 
> 
> 
> INSERT INTO Table (Secret) VALUES( '#Gibberish#'
> 
> 
> 
> 
> SELECT Secret
> FROM Table
> WHERE ...
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> The secret word is: #Secret#
> 
> Something broke...
> 
> 
> Hope that's helpful.
> 
> Best regards,
> Zac Bedell
> > -Original Message-
> > From: Will Swain [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 05, 2001 7:16 AM
> > To: CF-Talk
> > Subject: encrypt/decrypt
> >
> >
> > Hi guys,
> >
> > Got an interesting one here. I am encrypting some details
> > before entering
> > them in a databse, then decrypting them as the authorised views them.
> >
> >
> > However, I am getting this error on decryption:
> >
> > Error Diagnostic Information
> >
> > An error occurred while evaluating the expression:
> >
> >
> >  decryptednumber = decrypt(encryptednumber, numberkey)
> >
> >
> >
> > Error near line 25, column 8.
> > --
> > --
> > 
> >
> > The value to be decrypted is not valid
> >
> >
> > This is the code I have in that location. Interestingly,
> > decrtypting the
> > name doesn't seem to cuase a problem:
> >
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> >
> > This is the code on another page that encrypts the values:
> >
> > 
> >
> > 
> >
> > 
> >
> > 
> >
> > Any ideas on this anyone??
> >
> > TIA
> >
> > Will Swain
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ODBC Error

[McGuckin, Chris]

It probably means that the datasource you want to access needs to be a
system DSN, meaning that the sytem has control over the datasource, as
opposed to file or user DSNs.  Is your current datasource a user DSN, file
DSN, or system DSN?  Check the ODBC Datasource Administration (under the
control panel).  If your datasource is listed under any tab other than
System, then CF won't be able to use it (as CF runs under the system
account). 

Christopher McGuckin
DynCorp I&ET, Inc.
(703) 264-9247
"Outside of a dog, a book is man's best friend.  Inside of a dog it's too
dark to read".
-Groucho Marx


-Original Message-
From: CF Crazy [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:49 PM
To: CF-Talk
Subject: ODBC Error


I was using a new tag(not a tag just a single page) from the .

It says that I need to set a system database  in my Administrator.  I have 
never done that.  What is a System Database?  I tried picking the same 
database as my Data source but it FAILED!


Please Help?


Stephanie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Moreover News Feed

[Jeff Small]

Okay, maybe I live under a rock or something, but I gotta ask. What exactly
*is* the moreover news feed? Is it a news service that lets you use that
cfhttp tag and pull news stuff from their site? Does it cost money? How does
it work? It seems really cool on your site, and I'm curious as to how this
all works...

Jeff Small

on 4/9/01 2:33 PM, Benjamin S. Rogers at [EMAIL PROTECTED] wrote:

> A scheduled task queries MoreOver once an hour (or when the page below first
> loads) and deserializes the WDDX feed into a query that is stored in the
> application scope.
> 
> Anyway, the actual display is nothing terribly interesting. We just use the
> extra content to liven up the site a bit.
> 
> http://www.foodcount.com/Index.cfm?Method=Nutrition
> 
> Benjamin S. Rogers
> Web Developer, c4.net
> Voice: (508) 240-0051
> Fax: (508) 240-0057
> 
> -Original Message-
> From: Vance Duke [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 1:38 PM
> To: CF-Talk
> Subject: Moreover News Feed
> 
> 
> 
> I assume there are some people here using the Moreover.com News feed.  I was
> wondering if someone might like to send me links to their site so I might
> see how you implemented it.  I am not much on the "look and feel" side and
> was looking to get some ideas.
> 
> Thanks in advance,
> Vance Duke
> Sr. CF Programmer
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

QUERY PROBLEM

[brian]

I am trying to pull the next baseball game from a schedule I have in an
Access database. When it processes it pulls the next game to a degree. If
there is a game today it will not pull that game. Example there is a game
today 4/9/2001 and the ext game it displays is 4/10/2001  Any ideas?




SELECT *
FROM schedule
WHERE gdate >= #today#


ALSO HAD IT AS


SELECT *
FROM schedule
WHERE gdate >= NOW()



Thanks.

Brian Hasselback
[EMAIL PROTECTED]
http://www.intent.net
http://www.hasselback.com
Web Hosting & Development
(502) 452-1851


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ODBC Error

[CF Crazy]

I was using a new tag(not a tag just a single page) from the .

It says that I need to set a system database  in my Administrator.  I have 
never done that.  What is a System Database?  I tried picking the same 
database as my Data source but it FAILED!


Please Help?


Stephanie


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:Printing, page breaks, and heading info

[Terri Stocke]

Thanks, Carol and Adrian!

Since I'm doing alot of complex looping, conditionals and variable setting 
within my display block (and heck, just cuz I'm lazy today ;), I don't want 
to go back in and change alot of code.

I can deal with not having the nice page breaks. But, do either of you know 
how to get my heading information (ship to address, contact name, etc.) that 
prints on the first page to print on all subsequent pages?

Thanks in advance!

Terri


Original Message Follows
From: [EMAIL PROTECTED] (Carol Bluestein)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re:Printing, page breaks, and heading info
Date: Mon, 09 Apr 2001 09:42:02 -0400

Believe you can't use the style=page-break etc. inside a table.
So you have to count rows and end your table, put in the
break, and start a new table for each page.


Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:Printing, page breaks, and heading info
Author: [EMAIL PROTECTED]
Date:   4/9/01 12:48 PM

Hey all,

I have a shipping and receiving application that allows employees to
generate a shipping request via the web. The shipping dept. would like that
form to be printed out by the user, but they want one of two things when
this happens:

1) Either only allow the maximum number of items that will print on one
page, and prompt the user to fill out a second form for additional items; OR

2) Automatically have the app insert a break between the item in the last
row of the table and the next table row on the next page, but ALSO make sure
that the shipping address and other info is ALSO printed on each subsequent
page.

I favor the second method, since it is less hassle for the user, and it
would be easier to just insert a break in the table than to try to guess how
many characters a user might enter onto the page (virtually impossible to
determine how many pages they will need).

After searching the archives, I found the snippet I thought would work:
. I tried this in both the body tag
and in my table tag, but each time I used it I got the dreaded blue screen
o' death. I then found and tried a variation: http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop is not working please suggest ..

[Garza, Jeff]

Ok, so what is the output of qry_get_team_members and qry_get_meetings.

Are you returning the proper resultsets from these queries?

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 09, 2001 11:01 AM
To: CF-Talk
Subject: RE: cfloop is not working please suggest ..


 
--well jeff thanks..
but am indexing because i need to make the members display first and make
them absentees for the meeting..
the issue is am adding the members and indexing them and make them absent
later.
here the case is am adding them.. its fine and and displays the first added
person.. when i make the fisrt guy absent only the next member it shows..
but i want all of the guys who are added so that i can make any of them
absent
-got it?? help me please .. but the same thing works elsewhere but not here
-paul

On Mon, 09 Apr 2001 10:28:42  
 Garza, Jeff wrote:
>Why are you using a indexed loop when you can loop on the query??? 
>
>
>  
>#name#
>  
>
>
>
>  
>  
>
>
>Also, you need to use a cfoutput tag pair within your cfloop to display the
>ouput.  Also, If you are getting no output, make sure that you are properly
>closing your TR's and TD's.  Netscape will puke if all is not right within
>your table structure.
>
>Jeff Garza
>Web Developer/Webmaster
>Spectrum Astro, Inc.
>480.892.8200
>
>[EMAIL PROTECTED]
>http://www.spectrumastro.com
>
>
>
>-Original Message-
>From: paul . [mailto:[EMAIL PROTECTED]] 
>Sent: Monday, April 09, 2001 10:02 AM
>To: CF-Talk
>Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
>suggest
>
>
> hey guys please do suggest 
>-paul
>--
>
>On Mon, 09 Apr 2001 09:27:06  
> paul . wrote:
>>Hi all !.. i am using the following coding But it shows just the first
>record only not all that records which match the query.. is this cfloop is
>not working..? But 'indexing' its doing..
>>please suggest
>>-paul
>>
>>
>>
>>  
>>  
>>  #qry_get_team_members.name[loopcount]#

>>  
>>
>>
>>  
>>
>>
>>  
>>
>>
>>Get 250 color business cards for FREE! at Lycos Mail
>>http://mail.lycos.com/freemail/vistaprint_index.html
>>
>
>>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Moreover News Feed

[Benjamin S. Rogers]

A scheduled task queries MoreOver once an hour (or when the page below first
loads) and deserializes the WDDX feed into a query that is stored in the
application scope.

Anyway, the actual display is nothing terribly interesting. We just use the
extra content to liven up the site a bit.

http://www.foodcount.com/Index.cfm?Method=Nutrition

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

-Original Message-
From: Vance Duke [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:38 PM
To: CF-Talk
Subject: Moreover News Feed



I assume there are some people here using the Moreover.com News feed.  I was
wondering if someone might like to send me links to their site so I might
see how you implemented it.  I am not much on the "look and feel" side and
was looking to get some ideas.

Thanks in advance,
Vance Duke
Sr. CF Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: NT event log grabber / reader???

[Tumy, Brad]

Ben Forta wrote a tag to display the event log...I am pretty sure about
this...I would do a search for all tags written by Forta

-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:15 PM
To: CF-Talk
Subject: NT event log grabber / reader???



Has anyone built a Custom tag, or other wise, that can display the NT event
log on a HTML page or e-mail?

I have checked the Developers Exchange.  Only thing there is tags to write
to the event log.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

NT event log grabber / reader???

[Mark W. Breneman]

Has anyone built a Custom tag, or other wise, that can display the NT event
log on a HTML page or e-mail?

I have checked the Developers Exchange.  Only thing there is tags to write
to the event log.

Thanks

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop is not working please suggest ..

[paul .]

 Hi randy thanks
well the member-idx changes..
well the system goes like this.. 
am adding the members one after another. and by using cfloop and index am making the 
members made absent by deleting them individually later . for that i need to display 
all the added member got it..?>
please do suggest what happes here
but when i make the first person absent only the nest person appears ?
i need all of them get displayed..
-paul

--

On Mon, 09 Apr 2001 13:27:15  
 Adkins, Randy wrote:
>Regarding the cfloop, does the #member_idx# change?
>If not, maybe there is only one record that matches within
>the initial team_member query.
>
>That would be a starting point to look at.
>
>-Original Message-
>From: paul . [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 09, 2001 1:02 PM
>To: CF-Talk
>Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
>suggest
>
>
> hey guys please do suggest 
>-paul
>--
>
>On Mon, 09 Apr 2001 09:27:06  
> paul . wrote:
>>Hi all !.. i am using the following coding But it shows just the first
>record only not all that records which match the query.. is this cfloop is
>not working..? But 'indexing' its doing..
>>please suggest
>>-paul
>>
>>
>>
>>  
>>  
>>  #qry_get_team_members.name[loopcount]# 
>>  
>>
>>
>>  
>>
>>
>>  
>>
>>
>>Get 250 color business cards for FREE! at Lycos Mail
>>http://mail.lycos.com/freemail/vistaprint_index.html
>>
>
>>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Moreover News Feed

[Mary_Baotic]

We are using it here for our portal.  Our portal is inside our firewall,
however I can send you some code snippets if you like.

Mary


   
 
"Vance Duke"   
 
   
works.com>cc:  
 
  Subject: Moreover News Feed  
 
04/09/01 01:38 PM  
 
Please respond to  
 
cf-talk
 
   
 
   
 





I assume there are some people here using the Moreover.com News feed.  I
was
wondering if someone might like to send me links to their site so I might
see how you implemented it.  I am not much on the "look and feel" side and
was looking to get some ideas.

Thanks in advance,
Vance Duke
Sr. CF Programmer
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: sql 7.0 vs. sql 2000

[Bob Silverberg]

Although it's not a major reason to upgrade, the client tools that come with
SS2K contain some nice enhancements.  If you're building complex stored
procedures, Query Analyzer's built in SP debugger is an excellent tool.

One thing to keep in mind - I've heard from a number of reliable sources
that SS7 performs better on NT than SS2K.  So if you're on NT, you may want
to stick with SS7, but if you're on or moving to W2K, you'll get a
performance boost from SS2K.

Bob

-Original Message-
From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
Sent: April 9, 2001 1:26 PM
To: CF-Talk
Subject: RE: sql 7.0 vs. sql 2000


SQL Server has 3 advantages to SQL Server 7
1) Functions (A true lifesaver)
2) XML Support (Both into and out of the database)
3) Stability (although I have never had any problems with 7's stability)

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:21 PM
To: CF-Talk
Subject: sql 7.0 vs. sql 2000

sql 7.0 vs. sql 2000
What are the advantage and disadvantages?
Thanks
Mike
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop is not working please suggest ..

[paul .]

 
--well jeff thanks..
but am indexing because i need to make the members display first and make them 
absentees for the meeting..
the issue is am adding the members and indexing them and make them absent later.
here the case is am adding them.. its fine and and displays the first added person.. 
when i make the fisrt guy absent only the next member it shows.. but i want all of the 
guys who are added so that i can make any of them absent
-got it?? help me please .. but the same thing works elsewhere but not here
-paul

On Mon, 09 Apr 2001 10:28:42  
 Garza, Jeff wrote:
>Why are you using a indexed loop when you can loop on the query??? 
>
>
>  
>#name#
>  
>
>
>
>  
>  
>
>
>Also, you need to use a cfoutput tag pair within your cfloop to display the
>ouput.  Also, If you are getting no output, make sure that you are properly
>closing your TR's and TD's.  Netscape will puke if all is not right within
>your table structure.
>
>Jeff Garza
>Web Developer/Webmaster
>Spectrum Astro, Inc.
>480.892.8200
>
>[EMAIL PROTECTED]
>http://www.spectrumastro.com
>
>
>
>-Original Message-
>From: paul . [mailto:[EMAIL PROTECTED]] 
>Sent: Monday, April 09, 2001 10:02 AM
>To: CF-Talk
>Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
>suggest
>
>
> hey guys please do suggest 
>-paul
>--
>
>On Mon, 09 Apr 2001 09:27:06  
> paul . wrote:
>>Hi all !.. i am using the following coding But it shows just the first
>record only not all that records which match the query.. is this cfloop is
>not working..? But 'indexing' its doing..
>>please suggest
>>-paul
>>
>>
>>
>>  
>>  
>>  #qry_get_team_members.name[loopcount]# 
>>  
>>
>>
>>  
>>
>>
>>  
>>
>>
>>Get 250 color business cards for FREE! at Lycos Mail
>>http://mail.lycos.com/freemail/vistaprint_index.html
>>
>
>>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop is not working please suggest ..SOS hey Guys please suggest

[Chang Liu]

 
  
  
  #name# 
  
  
 
 





- Original Message -
From: "paul ." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 1:02 PM
Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
suggest


> hey guys please do suggest
> -paul
> --
>
> On Mon, 09 Apr 2001 09:27:06
>  paul . wrote:
> >Hi all !.. i am using the following coding But it shows just the first
record only not all that records which match the query.. is this cfloop is
not working..? But 'indexing' its doing..
> >please suggest
> >-paul
> >
> >
> >
> >  
> >  
> >  #qry_get_team_members.name[loopcount]#

> >  
> >
> >
> >  
> >
> >
> >  
> >
> >
> >Get 250 color business cards for FREE! at Lycos Mail
> >http://mail.lycos.com/freemail/vistaprint_index.html
> >
>
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: update numeric SubString?

[Adrian Cesana]

Anyone have any idea as to why this would result in a  when run thru
CF but when executed thru T-SQL works ok???


UPDATE mytable SET
switch =  left(switch, 3) + '1' + right(switch , len(switch) -4)
WHERE po = 236107

DB: SQL7 (switch = numeric field)
CF: 4.01


-Adrian


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Certified ColdFusion Developer Study Guide

[Terry Bader]

guess i didnt need to repeat everything you just said...
but it is worth repeating...

=^)


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Michailov, Dimitar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 9:47 AM
> To: CF-Talk
> Subject: RE: Certified ColdFusion Developer Study Guide
> 
> 
> Nick:
> 
> I preordered mine 10 days ago from Amazon and I had it 
> delivered to my door
> last Thursday (Apr. 5). You should be getting yours soon.
> 
> In addition to the useful exam preparation material, I like 
> the 15% off
> coupon from the exam fee (150$) which makes the book almost free.
> 
> Dimo Michailov
> Cold Fusion 4.5 Web Developer
> USA-IT, Inc.
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Nick Betts [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 9:07 AM
> To: CF-Talk
> Subject: RE: Certified ColdFusion Developer Study Guide
> 
> 
> You can order it on Amazon.  Its due to ship very shortly, if its not
> already.  I ordered a copy about a month ago, but am yet to 
> have delivery of
> it...
> 
> Nick.
> 
> -Original Message-
> From: Richard L Smith [mailto:[EMAIL PROTECTED]]
> Sent: 09 April 2001 13:37
> To: CF-Talk
> Subject: Re: Certified ColdFusion Developer Study Guide
> 
> 
> Kelly,
> 
> This is the first I have heard of it.
> Where do you get it.
> 
> Rick
> - Original Message -
> From: "Kelly" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, April 07, 2001 12:30 PM
> Subject: Certified ColdFusion Developer Study Guide
> 
> 
> > Has anyone picked it up yet?  I  think I am going to get a 
> copy today.
> Just
> > wanted
> > to hear your thoughts if you got it.
> > Kelly
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF Cert: wait for 5.0?

[Terry Bader]

$150..

www.vue.com/allaire


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Marc Garrett [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 9:15 AM
> To: CF-Talk
> Subject: CF Cert: wait for 5.0?
> 
> 
> Does anyone know how long after CF 5 is released before the 
> certification
> exam becomes available? Is it better to take it now, or wait 
> for the new
> exam?
> 
> Also, I could not find pricing information on Allaire's site. 
> Does anyone
> know the price?
> 
> Thanks,
> 
> Marc Garrett
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Moreover News Feed

[Vance Duke]

I assume there are some people here using the Moreover.com News feed.  I was
wondering if someone might like to send me links to their site so I might
see how you implemented it.  I am not much on the "look and feel" side and
was looking to get some ideas.

Thanks in advance,
Vance Duke
Sr. CF Programmer


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Certified ColdFusion Developer Study Guide

[Terry Bader]

i got it... 

it is nicely put together... 
it also has a 15% discount for the Cert Test through VUE.com...  so, you
spend $40+ on the book, but save $22.50 on the test...  so for about $20,
you can't beat picking it up


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Kelly [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, April 07, 2001 12:31 PM
> To: CF-Talk
> Subject: Certified ColdFusion Developer Study Guide
> 
> 
> Has anyone picked it up yet?  I  think I am going to get a 
> copy today. Just 
> wanted
> to hear your thoughts if you got it.
> Kelly
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Slightly OT: SQL Server Access from Unix

[Edward Smith]

CF install on Solaris is really easy.  If you are installing Advanced
Security, be sure to check out this problem:

ColdFusion Server 4.5.1, 4.5.1 SP1, and 4.5.1 SP2: Advanced Security
Crashes after 12/1/2000 on Solaris(Article 18666)
http://www.allaire.com/Handlers/index.cfm?ID=18666&Method=Full

And the various other hotfixes
(http://www.allaire.com/Handlers/index.cfm?ID=20371&Method=Full) - also
make sure to install SP2:

Here's a document that talks about webserver and database compatibility:

http://www.allaire.com/handlers/index.cfm?ID=13567



Erika L Walker wrote:
> 
> 
> 
> (Although will make doubly sure when I get my hands on the docs)
> 
> It is CF 4.5 Enterprise running on Apache. It has not been installed yet on
> the client's machine and I am doing some background prep work before I talk
> to the client's IT guy. When I first started searching for ways to make the
> connection, I couldn't find anything. Even on Allaire's site, although, it
> is quite possible I was not searching using the correct parameters, but I
> though I would get something!
> 
> I was told that installation of Enterprise on a Unix box wasn't too
> complicated and that the client's IT guy could handle it. I have only ever
> installed it on Windows systems, so I'm a bit in the dark when it comes to
> Unix installations.
> 
> Thank you for the heads-up! (you math guru, you! )
> 
> Erika
> 
> "There are only two ways to live your life: One is as though nothing is a
> miracle, the other is as though everything is." - Albert Einstein
> 
> 
> AIM: WebErika5
> Yahoo: WebErika
> MSN: WebErika
> AskMe.com Expert: WebErika
> 
> Erika L. Walker
> Vice President
> RUWebby, LLC
> 973-626-2412 (c)
> 973-244-9120 (o)
> 153 Rutgers Lane
> Parsippany, NJ 07054
> 
> Website Design/Programming
> Database Integration
> Allaire Partner - ColdFusion
> 
> 
> -Original Message-
> From: Nick McClure [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 12:11 PM
> To: CF-Talk
> Subject: RE: Slightly OT: SQL Server Access from Unix
> 
> What version of CF do you have?
> 
> 4.5 came with the Merant(Spelling) drivers for SQL server.
> 
> I have used them from a Solaris box running CF 4.5 and Netscape Enterprise.
> 
> At 11:43 AM 4/9/2001 -0400, you wrote:
> >$4000 for a database driver? There is no other way to do this?
> >
> >It was $5000 just for CF. Please tell me there is another way to make a
> >connection to SQL Server from a Unix box
> >
> >
> >
> >Erika
> >
> >"There are only two ways to live your life: One is as though nothing is a
> >miracle, the other is as though everything is." - Albert Einstein
> >
> >-Original Message-
> >From: Marius Milosav [mailto:[EMAIL PROTECTED]]
> >Sent: Monday, April 09, 2001 11:23 AM
> >To: CF-Talk
> >Subject: Re: Slightly OT: SQL Server Access from Unix
> >
> >
> >Look at the Merant site.
> >There is a odbc driver that you can download and test ( I can't remember
> the
> >name exactly. Connect ODBC or something). It's free for one month after
> that
> >is $4000.00
> >Install it on your Solaris box. During the  installation process you will
> be
> >able to configure the MS-SQL server (name, version port etc).
> >After that, it will be available in the ODBC list in the ColdFusion Admin.
> >
> >Good luck
> >Marius Milosav
> >www.scorpiosoft.com
> >It's not about technology, it's about people.
> >Virtual Help Desk Demo (VHD)
> >www.scorpiosoft.com/vhd/login.cfm
> >
> >- Original Message -
> >From: "Erika L Walker" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Monday, April 09, 2001 10:58 AM
> >Subject: Slightly OT: SQL Server Access from Unix
> >
> >
> > > I would have posted this to the CF-SQL or CF-Server list, but from the
> > > amount of traffic I see on those boards, I was afraid no one would get
> my
> > > question.
> > >
> > > I also tried to look this up first online but didn't get anywhereso
> >I'm
> > > turning to the brilliant members of this list! :-)
> > >
> > > Where can I find information on connecting to SQL 7.0 on a Win NT
> machine
> > > from a separate Unix (Solaris) machine running CF 4.5? Both machines are
> >on
> > > the same netowrk. Actually, they are side by side. (If they could just
> > > ignore their differences, shake hands and make up like good
> machines )
> > >
> > > Has anyone done this? Are there any problems, etc. We have to be able to
> > > make this connection, there are no other alternatives.
> > >
> > > Many thanks in advance,
> > >
> > > Erika
> > >
> > > "There are only two ways to live your life: One is as though nothing is
> a
> > > miracle, the other is as though everything is." - Albert Einstein
> > >
> > > 
> > > AIM: WebErika5
> > > Yahoo: WebErika
> > > MSN: WebErika
> > > AskMe.com Expert: WebErika
> > > 
> > > E

RE: cfloop is not working please suggest ..SOS hey Guys please su ggest

[Garza, Jeff]

Why are you using a indexed loop when you can loop on the query??? 


  
#name#
  



  
  


Also, you need to use a cfoutput tag pair within your cfloop to display the
ouput.  Also, If you are getting no output, make sure that you are properly
closing your TR's and TD's.  Netscape will puke if all is not right within
your table structure.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 09, 2001 10:02 AM
To: CF-Talk
Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
suggest


 hey guys please do suggest 
-paul
--

On Mon, 09 Apr 2001 09:27:06  
 paul . wrote:
>Hi all !.. i am using the following coding But it shows just the first
record only not all that records which match the query.. is this cfloop is
not working..? But 'indexing' its doing..
>please suggest
>-paul
>
>
>
>  
>  
>  #qry_get_team_members.name[loopcount]# 
>  
>
>
>  
>
>
>  
>
>
>Get 250 color business cards for FREE! at Lycos Mail
>http://mail.lycos.com/freemail/vistaprint_index.html
>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfloop is not working please suggest ..SOS hey Guys please su ggest

[Adkins, Randy]

Regarding the cfloop, does the #member_idx# change?
If not, maybe there is only one record that matches within
the initial team_member query.

That would be a starting point to look at.

-Original Message-
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:02 PM
To: CF-Talk
Subject: Re: cfloop is not working please suggest ..SOS hey Guys please
suggest


 hey guys please do suggest 
-paul
--

On Mon, 09 Apr 2001 09:27:06  
 paul . wrote:
>Hi all !.. i am using the following coding But it shows just the first
record only not all that records which match the query.. is this cfloop is
not working..? But 'indexing' its doing..
>please suggest
>-paul
>
>
>
>  
>  
>  #qry_get_team_members.name[loopcount]# 
>  
>
>
>  
>
>
>  
>
>
>Get 250 color business cards for FREE! at Lycos Mail
>http://mail.lycos.com/freemail/vistaprint_index.html
>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Best way to identify users after authentication

[Adkins, Randy]

Try Locking your session variables using CFLOCK



-Original Message-
From: Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:01 PM
To: CF-Talk
Subject: Best way to identify users after authentication


Hi all,

We have a site that a user can log into using a
username and password, and then they can update their
personal account information.

Currently, the user can only access if the username
and password match those in the database, and then a
cookie is set to be able to identify the user and
allow retrieval of their account info and personal
options.

In about 2-3 cases out of 500, some users get somebody
elses information (if you are Mary, you might have
Jim's information). The system checks to see if
cookies are enabled, and won't allow the user to login
without having cookies turned on, so I'm not sure why
this happens.

Is this the best way to identify the user by using a
cookie after authenticating? Or should a client or
session variable be set instead? What's the most
secure and reliable method?

Thanks!

Mark
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: sql 7.0 vs. sql 2000

[Troy Hiltbrand]

SQL Server has 3 advantages to SQL Server 7
1) Functions (A true lifesaver)
2) XML Support (Both into and out of the database)
3) Stability (although I have never had any problems with 7's stability)

-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 1:21 PM
To: CF-Talk
Subject: sql 7.0 vs. sql 2000

sql 7.0 vs. sql 2000
What are the advantage and disadvantages?
Thanks
Mike
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfloop is not working please suggest ..SOS hey Guys please suggest

[paul .]

 hey guys please do suggest 
-paul
--

On Mon, 09 Apr 2001 09:27:06  
 paul . wrote:
>Hi all !.. i am using the following coding But it shows just the first record only 
>not all that records which match the query.. is this cfloop is not working..? But 
>'indexing' its doing..
>please suggest
>-paul
>
>
>
>  
>  
>  #qry_get_team_members.name[loopcount]# 
>  
>
>
>  
>
>
>  
>
>
>Get 250 color business cards for FREE! at Lycos Mail
>http://mail.lycos.com/freemail/vistaprint_index.html
>

>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Best way to identify users after authentication

[Mark]

Hi all,

We have a site that a user can log into using a
username and password, and then they can update their
personal account information.

Currently, the user can only access if the username
and password match those in the database, and then a
cookie is set to be able to identify the user and
allow retrieval of their account info and personal
options.

In about 2-3 cases out of 500, some users get somebody
elses information (if you are Mary, you might have
Jim's information). The system checks to see if
cookies are enabled, and won't allow the user to login
without having cookies turned on, so I'm not sure why
this happens.

Is this the best way to identify the user by using a
cookie after authenticating? Or should a client or
session variable be set instead? What's the most
secure and reliable method?

Thanks!

Mark
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfloop problem

[paul .]

Hi Guys am encpountering a problem with Cfloop.. here is the codiw i have done and , 
itseems it displays only the first record for the comditions.. but i need all the 
records that meet the condition..
please help SOS
-paul 




 
  
  #qry_get_team_members.name[loopcount]# 
  


  


  


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Slightly OT: SQL Server Access from Unix

[Erika L Walker]

(Although will make doubly sure when I get my hands on the docs)

It is CF 4.5 Enterprise running on Apache. It has not been installed yet on
the client's machine and I am doing some background prep work before I talk
to the client's IT guy. When I first started searching for ways to make the
connection, I couldn't find anything. Even on Allaire's site, although, it
is quite possible I was not searching using the correct parameters, but I
though I would get something!

I was told that installation of Enterprise on a Unix box wasn't too
complicated and that the client's IT guy could handle it. I have only ever
installed it on Windows systems, so I'm a bit in the dark when it comes to
Unix installations.

Thank you for the heads-up! (you math guru, you! )

Erika

"There are only two ways to live your life: One is as though nothing is a
miracle, the other is as though everything is." - Albert Einstein


AIM: WebErika5
Yahoo: WebErika
MSN: WebErika
AskMe.com Expert: WebErika

Erika L. Walker
Vice President
RUWebby, LLC
973-626-2412 (c)
973-244-9120 (o)
153 Rutgers Lane
Parsippany, NJ 07054

Website Design/Programming
Database Integration
Allaire Partner - ColdFusion



-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 12:11 PM
To: CF-Talk
Subject: RE: Slightly OT: SQL Server Access from Unix


What version of CF do you have?

4.5 came with the Merant(Spelling) drivers for SQL server.

I have used them from a Solaris box running CF 4.5 and Netscape Enterprise.

At 11:43 AM 4/9/2001 -0400, you wrote:
>$4000 for a database driver? There is no other way to do this?
>
>It was $5000 just for CF. Please tell me there is another way to make a
>connection to SQL Server from a Unix box
>
>
>
>Erika
>
>"There are only two ways to live your life: One is as though nothing is a
>miracle, the other is as though everything is." - Albert Einstein
>
>-Original Message-
>From: Marius Milosav [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 09, 2001 11:23 AM
>To: CF-Talk
>Subject: Re: Slightly OT: SQL Server Access from Unix
>
>
>Look at the Merant site.
>There is a odbc driver that you can download and test ( I can't remember
the
>name exactly. Connect ODBC or something). It's free for one month after
that
>is $4000.00
>Install it on your Solaris box. During the  installation process you will
be
>able to configure the MS-SQL server (name, version port etc).
>After that, it will be available in the ODBC list in the ColdFusion Admin.
>
>Good luck
>Marius Milosav
>www.scorpiosoft.com
>It's not about technology, it's about people.
>Virtual Help Desk Demo (VHD)
>www.scorpiosoft.com/vhd/login.cfm
>
>- Original Message -
>From: "Erika L Walker" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, April 09, 2001 10:58 AM
>Subject: Slightly OT: SQL Server Access from Unix
>
>
> > I would have posted this to the CF-SQL or CF-Server list, but from the
> > amount of traffic I see on those boards, I was afraid no one would get
my
> > question.
> >
> > I also tried to look this up first online but didn't get anywhereso
>I'm
> > turning to the brilliant members of this list! :-)
> >
> > Where can I find information on connecting to SQL 7.0 on a Win NT
machine
> > from a separate Unix (Solaris) machine running CF 4.5? Both machines are
>on
> > the same netowrk. Actually, they are side by side. (If they could just
> > ignore their differences, shake hands and make up like good
machines )
> >
> > Has anyone done this? Are there any problems, etc. We have to be able to
> > make this connection, there are no other alternatives.
> >
> > Many thanks in advance,
> >
> > Erika
> >
> > "There are only two ways to live your life: One is as though nothing is
a
> > miracle, the other is as though everything is." - Albert Einstein
> >
> > 
> > AIM: WebErika5
> > Yahoo: WebErika
> > MSN: WebErika
> > AskMe.com Expert: WebErika
> > 
> > Erika L. Walker
> > Vice President
> > RUWebby, LLC
> > 973-626-2412 (c)
> > 973-244-9120 (o)
> > 153 Rutgers Lane
> > Parsippany, NJ 07054
> > 
> > Website Design/Programming
> > Database Integration
> > Allaire Partner - ColdFusion
> > 
> >
> >
> > -Original Message-
> > From: paul . [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 09, 2001 10:36 AM
> > To: CF-Talk
> > Subject: Re: Free sites for coldfusion
> >
> >
> >
> > --hey Kishore
> > try this man!
> > http://www.cfm-resources.com/
> > =paulraj
> >
> > On Mon, 09 Apr 2001 12:47:05
> >  kishore wrote:
> > >
> > >Hi all,
> > >
> > >I am new member to this list. Can anybody tell me the free sites for
> > >coldfusion hosting. I am in need of this site for demo purpose.
> > >
> > >Regards
> > >G. KISHORE KUMAR,

RE: excluding application.cfm from one template

[Jay Brushett]

The environment variables! Of course. Just what I needed.

Thanks,

Jay

At 12:00 PM 4/9/2001 -0400, you wrote:
>Two ways that I can think of:
>
>1) Put the template in seperate directory from the rest of your site and 
>place an empty application.cfm in the same directory.
>
>2) In the application.cfm check the value of cgi.path_info for the name of 
>the template and skip the bits you don't want to execute.
>
> > -Original Message-
> > From: Jay Brushett [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, April 09, 2001 9:10 AM
> > To:   CF-Talk
> > Subject:  excluding application.cfm from one template
> >
> >
> > HI,
> >
> > I was wondering if there is a way to exclude application.cfm from showing
> > up on one template.
> >
> > Thanks,
> >
> > Jay
> > < > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > < >
> >
> > Jay Brushett
> > [EMAIL PROTECTED]
> >
> > Developer
> >
> > < ZeddComm Inc. >
> > 2nd Floor, The Tower | 100 Signal Hill Road
> > St. John's, Newfoundland | Canada A1A 1B3
> > Main: 709.570.5669 | Fax: 709.739.9003
> > Web: www.zeddcomm.com
> > < > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > < >
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfloop is not working please suggest ..SOS

[paul .]

Hi all !.. i am using the following coding But it shows just the first record only not 
all that records which match the query.. is this cfloop is not working..? But 
'indexing' its doing..
please suggest
-paul



  
  
  #qry_get_team_members.name[loopcount]# 
  


  


  


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Printing, page breaks, and heading info

[Adrian Cesana]

I have battled the same before in a similar application, using the
STYLE=page-break does work but not within a table it seems. IMHO its also
very kludgy for these type of apps.  If you cant get it working correctly
you may want to look into writing a pdf for these documents.

-Adrian



-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]

Hey all,

I have a shipping and receiving application that allows employees to
generate a shipping request via the web. The shipping dept. would like that
form to be printed out by the user, but they want one of two things when
this happens:

1) Either only allow the maximum number of items that will print on one
page, and prompt the user to fill out a second form for additional items; OR

2) Automatically have the app insert a break between the item in the last
row of the table and the next table row on the next page, but ALSO make sure
that the shipping address and other info is ALSO printed on each subsequent
page.




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Slightly OT: SQL Server Access from Unix

[Marius Milosav]

Yes, I know.
try to call Merant and see if you can get a better deal.  Depending of your
particular case they may give you a break.
For the project we had implemented, money was not an issue. If you need to
access the SQL server constantly than maybe this is the cheapest and solid
solution. Any other custom development will actually cost more in developing
and testing time.
If you have a database on Solaris, you can write a SP (trigger) on the
MS-SQL server to write the information in a file. ftp the file to the
Solaris box and insert into the proper tables. Depending of the nature of
your application this may be a viable solution

Sorry.
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm

- Original Message -
From: "Erika L Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 11:43 AM
Subject: RE: Slightly OT: SQL Server Access from Unix


> $4000 for a database driver? There is no other way to do this?
>
> It was $5000 just for CF. Please tell me there is another way to make a
> connection to SQL Server from a Unix box
>
>
>
> Erika
>
> "There are only two ways to live your life: One is as though nothing is a
> miracle, the other is as though everything is." - Albert Einstein
>
> -Original Message-
> From: Marius Milosav [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 09, 2001 11:23 AM
> To: CF-Talk
> Subject: Re: Slightly OT: SQL Server Access from Unix
>
>
> Look at the Merant site.
> There is a odbc driver that you can download and test ( I can't remember
the
> name exactly. Connect ODBC or something). It's free for one month after
that
> is $4000.00
> Install it on your Solaris box. During the  installation process you will
be
> able to configure the MS-SQL server (name, version port etc).
> After that, it will be available in the ODBC list in the ColdFusion Admin.
>
> Good luck
> Marius Milosav
> www.scorpiosoft.com
> It's not about technology, it's about people.
> Virtual Help Desk Demo (VHD)
> www.scorpiosoft.com/vhd/login.cfm
>
> - Original Message -
> From: "Erika L Walker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 10:58 AM
> Subject: Slightly OT: SQL Server Access from Unix
>
>
> > I would have posted this to the CF-SQL or CF-Server list, but from the
> > amount of traffic I see on those boards, I was afraid no one would get
my
> > question.
> >
> > I also tried to look this up first online but didn't get anywhereso
> I'm
> > turning to the brilliant members of this list! :-)
> >
> > Where can I find information on connecting to SQL 7.0 on a Win NT
machine
> > from a separate Unix (Solaris) machine running CF 4.5? Both machines are
> on
> > the same netowrk. Actually, they are side by side. (If they could just
> > ignore their differences, shake hands and make up like good
machines )
> >
> > Has anyone done this? Are there any problems, etc. We have to be able to
> > make this connection, there are no other alternatives.
> >
> > Many thanks in advance,
> >
> > Erika
> >
> > "There are only two ways to live your life: One is as though nothing is
a
> > miracle, the other is as though everything is." - Albert Einstein
> >
> > 
> > AIM: WebErika5
> > Yahoo: WebErika
> > MSN: WebErika
> > AskMe.com Expert: WebErika
> > 
> > Erika L. Walker
> > Vice President
> > RUWebby, LLC
> > 973-626-2412 (c)
> > 973-244-9120 (o)
> > 153 Rutgers Lane
> > Parsippany, NJ 07054
> > 
> > Website Design/Programming
> > Database Integration
> > Allaire Partner - ColdFusion
> > 
> >
> >
> > -Original Message-
> > From: paul . [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 09, 2001 10:36 AM
> > To: CF-Talk
> > Subject: Re: Free sites for coldfusion
> >
> >
> >
> > --hey Kishore
> > try this man!
> > http://www.cfm-resources.com/
> > =paulraj
> >
> > On Mon, 09 Apr 2001 12:47:05
> >  kishore wrote:
> > >
> > >Hi all,
> > >
> > >I am new member to this list. Can anybody tell me the free sites for
> > >coldfusion hosting. I am in need of this site for demo purpose.
> > >
> > >Regards
> > >G. KISHORE KUMAR,
> > >Mail : [EMAIL PROTECTED]
> > >
> > >
> > >
> > >
> >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

sql 7.0 vs. sql 2000

[Mike]

sql 7.0 vs. sql 2000 
What are the advantage and disadvantages?
Thanks
Mike

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: excluding application.cfm from one template

[Jay Brushett]

Thanks for the reply.

I went another route and placed the template outside the sub-folders.

Thanks,

Jay


At 04:46 PM 4/9/2001 +0100, you wrote:
>You would have to place your template in a further subfolder which contains
>a blank application.cfm.  As far as I know that's the only way to do it.
>
>-Original Message-
>From: Jay Brushett [mailto:[EMAIL PROTECTED]]
>Sent: 09 April 2001 14:10
>To: CF-Talk
>Subject: excluding application.cfm from one template
>
>
>
>HI,
>
>I was wondering if there is a way to exclude application.cfm from showing
>up on one template.
>
>Thanks,
>
>Jay
>< > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > < >
>
>Jay Brushett
>[EMAIL PROTECTED]
>
>Developer
>
>< ZeddComm Inc. >
>2nd Floor, The Tower | 100 Signal Hill Road
>St. John's, Newfoundland | Canada A1A 1B3
>Main: 709.570.5669 | Fax: 709.739.9003
>Web: www.zeddcomm.com
>< > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > < >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: excluding application.cfm from one template

[Jon Hall]

or surround the application.cfm code with a test for the single page.


application.cfm code...


jon


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 11:46 AM
Subject: RE: excluding application.cfm from one template


> You would have to place your template in a further subfolder which
contains
> a blank application.cfm.  As far as I know that's the only way to do it.
>
> -Original Message-
> From: Jay Brushett [mailto:[EMAIL PROTECTED]]
> Sent: 09 April 2001 14:10
> To: CF-Talk
> Subject: excluding application.cfm from one template
>
>
>
> HI,
>
> I was wondering if there is a way to exclude application.cfm from showing
> up on one template.
>
> Thanks,
>
> Jay
> < > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > < >
>
> Jay Brushett
> [EMAIL PROTECTED]
>
> Developer
>
> < ZeddComm Inc. >
> 2nd Floor, The Tower | 100 Signal Hill Road
> St. John's, Newfoundland | Canada A1A 1B3
> Main: 709.570.5669 | Fax: 709.739.9003
> Web: www.zeddcomm.com
> < > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > < >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists