Re: expire cookie in 5min

[Kevin Schmidt]

You should be able to use the CreateTimeSpan function for the expires
attribute.

IE EXPIRES="#CreateTimeSpan(0,0,5,0)#"

This will set it to expire in 5 minutes.

- Original Message -
From: "Art Broussard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:24 AM
Subject: expire cookie in 5min


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0073_01C05AB7.C1924EC0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I want to set a cookie to expire in 5 min. Can some body show me the =
> right way to set a cookie to expire in 5min?
>
> I dont know how to check when a cookie is set to expire so I dont know =
> if this is right.
>
>  value=3D"what ever"=20
> expires=3D"#TimeFormat(DateAdd("n", 5, Now()), "hh:mm:ss")#">
>
> Does this need to have the date set also?
>
> thanks
>
> Art
>
> --=_NextPart_000_0073_01C05AB7.C1924EC0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  charset=3Diso-8859-1">
> 
> 
> 
> 
> I want to set a cookie to expire in 5 =
> min. Can some=20
> body show me the right way to set a cookie to expire in =
> 5min?
>  
> I dont know how to check when a cookie =
> is set to=20
> expire so I dont know if this is right.
>  
>  name=3D"5min" 
> value=3D"what ever" 
> expires=3D"#TimeFormat(DateAdd("n", 5, =
> Now()),=20
> "hh:mm:ss")#">
>  
> Does this need to have the date set=20
> also?
>  
> thanks
>  
> Art
>
> --=_NextPart_000_0073_01C05AB7.C1924EC0--
>
~~
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: Cheap Hosting Needed

[Daryl Fullerton]

Jeremy,

I know a few good ones in the states.
Would you consider hosting in ireland?

D

Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
Ireland

Direct +44 (0) 28 9022 7888
Tel  +44 (0) 028 9022 3224
Fax +44 (0) 028 9022 3223


[EMAIL PROTECTED]
Http://www.BizNet-Solutions.com

[EMAIL PROTECTED] (Chairman)
Http://www.cfug.ie The Irish Cold Fusion User Group
- Original Message -
From: Jeremy Toevs <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 5:15 PM
Subject: Cheap Hosting Needed


Anyone know of any goof CF Hosting companies that charge about 20 to 30 per
month. I am with BMI.net right now and they are not very good.
~~
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: Gore is OJ!!

[Eric J Hoffman]

Get bent Lee.  We can trash Bush if you want with much more validity;
politics belongs on CF-Politics.  Check it out.

Eric J Hoffman, MAIP
Director of Internet Development
Small Dog Design

-Original Message-
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:40 AM
To: CF-Talk
Subject: Re: Gore is OJ!!


As honest as bush then. At least Gore doesn't giggle when he signs death
warrents. I have absolutely no respect for someone, like Bush, who looks
up to Danny-boy Quayle as his intellectual superior.

Aside from that, lets keep politics out of CF-Talk. I cannot stand
hearing republicrats whine and have tempertantrums because their boy's
brother didn't rig the election in Florida enough.

Lee Surma wrote:
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> After watching the aerial view of the Ryder truck being followed down =
> the highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are astounding.
>
> Gore has the same sleazy, damn the law to win, attorneys.
>
> He's a liar and guilty as heck.
>
> Even though he is a fortunate son, white male, he has managed to play =
> the race card.
>
> He's using the media to his advantage.
>
> And he's a rich egomaniac.
>
> There is one big difference however.
>
> Gore is not going to win.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> After watching the aerial view of the Ryder truck being followed down =
> the=20
> highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are=20
> astounding.
> Gore has the same sleazy, damn the law to win, attorneys.
> He’s a liar and guilty as heck.
> Even though he is a fortunate son, white male, he has managed to play =
> the=20
> race card.
> He’s using the media to his advantage.
> And he’s a rich egomaniac.
> There is one big difference however.
> Gore is not going to win.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20--
>
>
~~
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

ACL on Resource

[Rob Sherman]

Looking for a few other suggestions..  Admin swears he installed CF on NT 4
SP 6a Server as the Administrator but you can't even test the installation
without getting prompted for a login and password.. if you cancel, you get
the 401.3 Error "ACL on Resource"

It seems to be a permissions problem, forgot what I did to fix this in a
previous similar problem.


Sincerely,

Rob Sherman
Allaire Certified Developer & Instructor
CFDude, Inc.  http://www.cfdude.com
 (310) 543-1622  (310) 543-0512



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

Advanced Querying

[W Luke]

Hi,

I wonder if someone could help me out with some queries I'm running on a
scheduled task.

I need to send out outstanding invoices, including details of what they have
bought (i.e. an Advert - details of which are in advert_details).  Once
done, I need to set the "Sent" column of the Invoices to "Yes".  It involved
3 tables - invoices, payments and advert_details.

Below is what I've done - but I'm pretty sure I've done it wrong, and I'm
not sure where or how to set the invoices.sent to "Yes".


SELECT email,ad_ID,advert_ID,paid,sent
FROM payments,invoices
WHERE paid = Yes AND sent = No AND ad_ID = advert_ID



There are no outstanding INVOICES TO BE PAID



 
 SELECT * FROM advert_details WHERE ID = #ad_ID# AND email = '#email#'
 


 

 

 There are #invoices.recordcount# invoices outstanding


I'd be grateful for anyone's wisdom with advanced querying on this..

Cheers

Will



~~
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 on a MS Access Database

[Doug Powell]

Switch the where statement to


 UPDATE JobInfoUpload
 SET CheckedOut='Yes',
 CheckedOutBy=#InSol.Name#
 Where JobInfoUpload.FileID = '#URL.FileID#'




-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database


Im trying a UPDATE on a Access database, and im getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


Everything is spelled correct, but i get an error below.  I have a feeling
it has something to do with my Yes/No Column in the database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the
fields included in your query exist and that you have specified their names
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (25:1) to (25:60) in the template
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Query String: JobId=11&LoginID=1&FileID=48

~~
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 on a MS Access Database

[Gilles Ratte]

or maybe this (use field = value):


 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where JobInfoUpload.FileID = '#URL.FileID#' 


> -Message d'origine-
> De:   Chad Gray [SMTP:[EMAIL PROTECTED]]
> Date: Thursday, November 30, 2000 11:52 AM
> À:CF-Talk
> Objet:UPDATE on a MS Access Database
> 
> Im trying a UPDATE on a Access database, and im getting an error
> 
> 
> 
>  UPDATE JobInfoUpload
>  SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
>  Where '#URL.FileID#' = JobInfoUpload.FileID
> 
> 
> Everything is spelled correct, but i get an error below.  I have a feeling
> 
> it has something to do with my Yes/No Column in the database.
> 
> 
> 
> ODBC Error Code = 07001 (Wrong number of parameters)
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
> Hint: The cause of this error is usually that your query contains a 
> reference to a field which does not exist. You should verify that the 
> fields included in your query exist and that you have specified their
> names 
> correctly.
> SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where 
> '48' = JobInfoUpload.FileID"
> Data Source = "CJM.mdb"
> The error occurred while processing an element with a general identifier
> of 
> (CFQUERY), occupying document position (25:1) to (25:60) in the template 
> file D:\Web\Capitol1interface\chad\checkout.cfm.
> Date/Time: 11/30/00 11:51:07
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
> Query String: JobId=11&LoginID=1&FileID=48
> 
> 
~~
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

Encryption

[Dakin, Corey]

I am looking for a tool to Encrypt my Coldfusion Source Code.  Any help
please.

 
Corey Dakin 
County IS Director / Network Security Officer 
Phone: 816.792.6532 
Email: [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

RE: UPDATE on a MS Access Database

[Gilles Ratte]

try this:


 UPDATE JobInfoUpload
 SET CheckedOut=1,   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


> -Message d'origine-
> De:   Chad Gray [SMTP:[EMAIL PROTECTED]]
> Date: Thursday, November 30, 2000 11:52 AM
> À:CF-Talk
> Objet:UPDATE on a MS Access Database
> 
> Im trying a UPDATE on a Access database, and im getting an error
> 
> 
> 
>  UPDATE JobInfoUpload
>  SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
>  Where '#URL.FileID#' = JobInfoUpload.FileID
> 
> 
> Everything is spelled correct, but i get an error below.  I have a feeling
> 
> it has something to do with my Yes/No Column in the database.
> 
> 
> 
> ODBC Error Code = 07001 (Wrong number of parameters)
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
> Hint: The cause of this error is usually that your query contains a 
> reference to a field which does not exist. You should verify that the 
> fields included in your query exist and that you have specified their
> names 
> correctly.
> SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where 
> '48' = JobInfoUpload.FileID"
> Data Source = "CJM.mdb"
> The error occurred while processing an element with a general identifier
> of 
> (CFQUERY), occupying document position (25:1) to (25:60) in the template 
> file D:\Web\Capitol1interface\chad\checkout.cfm.
> Date/Time: 11/30/00 11:51:07
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
> Query String: JobId=11&LoginID=1&FileID=48
> 
> 
~~
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: a bbs in cf

[Bob Silverberg]

There are lots of ways to do it, but if you start by finding out whether
there is a period, then you could use ListFirst() and ListLast() with '.' as
a delimiter to get both the first and last part.  You could then use the
Mid() function combined with the Len() function to extract the different
pieces.  Take a look at the section of the docs on string functions for
other useful functions.

As for other products, I'm not sure what functionality you're looking for,
but you might want to check out the free used-to-be-Allaire Forums at
www.forumspot.org.

Bob

-Original Message-
From: Jordie Fike [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 11:23 AM
To: CF-Talk
Subject: a bbs in cf


first a thank you to those that helped me with my "dates in a sql
statement" problem .. it has taken me close to fruition on my current pet
project .. but now I've run into another road block

My Immediate Problem:
can anyone point me in the proper direction so that I might be able to
learn what specific functions that are available in CF to read the contents
of strings/variables? What I need to accomplish is to take something of the
form

1234.010203

and be able to break it up into

is_there_a_period = 1
var_1 = 1234
var_2 = 01
var_3 = 02
var_4 = 03

when I won't know the length of what's before or after the period. i.e.
they might be of the form

12
or
1234
or
1234.01
or
1234.0102
etc.

I know I can find the presence of the period with



but I don't know how to find out how many characters there are to the right
or left of the period if it does exist, and what the value of these
individual characters on either side of the period are.

What I'm Up To:
A while back I implemented a BBoard written in Tcl on
OuterBanksBeachGuide.com - it was written by Phillip Greenspun of MIT. It
has served us well through it's 4 year life span, but lately I've had
clients asking for something similar on their sites. The problem with
continuing to use Phillip's board is that it requires an AOLServer backed
hosting solution and they don't come cheap. So I went looking for something
written in CF at a comparable price (did I mention that Phillip's app is
open source) but wasn't able to find much .. so then I get the bright idea
to try and port Phillip's board from Tcl to CF. I checked with Phillip to
make sure he was OK with this idea and he assured me that he is. Although
it is my hope to get this functional on my own .. I would like to turn this
into an open source project of it's own.

If this is something that you feel you would like to be involved in or if
you would like a copy once I get it working please feel free to email me
direct .. just so long as you are charging for your time installing the
application and not selling the app itself. If anyone knows that I am
reinventing the wheel and that something like this is already available, if
you would kindly email me a quick note to point me in the right direction I
would greatly appreciate it.

Jordie Fike
Tech Admin
[EMAIL PROTECTED]
http://www.outer-banks.nc.us
phone - 1.252.441.6698
fax - 1.252.480.2259 
~~
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: (Admin) test

[Michael Dinowitz]

If your reading this, then the list has been moved to the new filtering
system. This has the effect of removing multiple footers and all of the
garbage generated by HTML email. I'm going to add in an on the fly subject
filter to kill threads that should not be on the list. I'm hoping I'll never
have to use it.
If you find any problems with the list or emails please email me off list at
[EMAIL PROTECTED]
Thank you.


>
> Michael Dinowitz
> Publisher - The Fusion Authority (www.fusionauthority.com/alert)
> ListManager - CF-Talk, CF-Jobs, Spectra-Talk, JRun-Talk, etc.
> (www.houseoffusion.com)
>
>
>
> 
~~
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

(Admin) test

[Michael Dinowitz]

Michael Dinowitz
Publisher - The Fusion Authority (www.fusionauthority.com/alert)
ListManager - CF-Talk, CF-Jobs, Spectra-Talk, JRun-Talk, etc.
(www.houseoffusion.com)



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

CFlocking large if statements

[Ken Tam]

This is a multi-part message in MIME format.

--=_NextPart_000_0010_01C05ACF.7A7A4F20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

CFlocking large if statements?
=20
How would you go about this if the "if" statement requires a "readonly" =
and within the if statement requires several "exclusives"? Please have a =
look at the code below. Any help or suggestions are appreciated.




 bunch of code 



 bunch of code 


SELECT column
FROM table
WHERE columnID =3D #session.variable3#


 bunch of code 



 bunch of code 



 bunch of code 



This if statement and its contents are about 50 lines of code.

Thanks,
Kenny

--=_NextPart_000_0010_01C05ACF.7A7A4F20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








CFlocking large if =
statements?
 
How would you go about this if the "if" =
statement=20
requires a "readonly" and within the if statement requires several =
"exclusives"?=20
Please have a look at the code below. Any help or suggestions are=20
appreciated.
 
 

 
    =
 bunch of=20
code 
 
    
 
        =
 bunch of=20
code 
 
    
        =
SELECT=20
column
        =
FROM=20
table
        =
WHERE=20
columnID =3D #session.variable3#
    =

 
    =20
bunch of code 
 
    
 
        =
 bunch of=20
code 
 
    
 
        =
 bunch of=20
code 
 

 
This if statement and its contents are =
about 50=20
lines of code.
 
Thanks,
Kenny

--=_NextPart_000_0010_01C05ACF.7A7A4F20--

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

CFFILE locking?

[Len Conrad]

With , does CF have implicit file locking or 
serialization of access to one file (such as a logging file common 
used by all a site's pages) or do we have implement our own locking scheme?

In either case, what happens when there is a collision?

Does CF do its own retry/timeout thing or do we have to do that also?

Len

~~
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 Question

[Sean Daniels]

The statement should be:

DELETE from auction_records where auction_id='#id#' and userid='#userid#'



- Sean


  Sean Daniels
  Manager, Engineering
  Marketplace Technologies
  (t) 207.439.6030
  (c) 207.332.6340 


http://www.dealforce.com
http://www.dealstream.com
http://www.mergernetwork.com


> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 11:11 AM
> To: CF-Talk
> Subject: SQL 7.0 Question
> 
> 
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
> 
> 
> DELETE * from auction_records where auction_id='#id#' and 
> userid='#userid#'
> 
> 
> Here is the error:
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect 
> syntax near
> '*'.
> 
> Is * not the correct syntax for All is SQL 7.0?
> 
> Thanks,
> Rich
> 
> ~~
> 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
~~
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 Question

[Marius Milosav]

You don't need * in a delete statement
try
delete auction_records where auction_id='#id#' and userid='#userid#'

Marius Milosav
www.scorpiosoft.com
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm

- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question


> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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

~~
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.1 SP2 -- Ramping/Queing Problem

[dave fauth]

We are having the same problem on the development server.  It was an
upgrade from 4.0.1 to 4.5.1sp2. Today, I uninstalled the CF4.5.1sp2 per the
following Allaire instructions:

Uninstall ColdFusion using the Add/Remove Programs Control Panel Applet. 
Reboot. 
Delete the entire \cfusion directory tree. 
Delete the CFDOCS and CFIDE directories from your web root. 
Delete the HKLM\Software\Allaire registry folder. 
Delete any remaining ColdFusion services from the
HKLM\System\CurrentControlSet\Services registry folder. 
Delete cfml.ini from your Windows directory. 
Delete the following files from your Windows/System directory (you may not
find all of these): - CFFileProxy.dll - CFFtp.dll - CFFtp30.ocx - cfmsg.dll
- cfperfmon.dll - CFRds.dll - CFRegExp.dll - CFSDebug.dll -
CfShellFtpRds.dll - CFSourceControl.ocx - cfssvradmin.dll - cfvalidator.dll 

Reboot. 
Reinstall ColdFusion 

On the first reinstall, I went to 4.5 and then 4.5.1sp2.  It didn't help.
So I repeated the process and looked for more stuff in the registry related
to ColdFusion, WDDX and Allaire.  I deleted that stuff and reinstalled 4.5.
 That seemed to make a big difference as I wasn't seeing the queing of
requests under the same load as before.  

I guess the next step is to go to 4.5.1sp2 and see if it holds.

dave

At 10:43 PM 11/29/2000 -0500, you wrote:
>We have a problem with CF 4.5.1 SP2 in which the CF App server
>just starts queing requests and never finishes processing of active
>threads.  When this happens we always have plenty of memory and
>CPU available. It happens under conditions of very light load to
>very heavy load. It happens on different servers at different times of
>the day.  We are running NT SP6a and Website.  We are using
>primarily UDB and Sybase databases. Allaire told us to put
>CFLOCKs in our code.  We put tons of CFLOCKs in our code,
>first write locks, then read locks, then any possible lock.  All
>this accomplishes is to slow our apps way down.  A number of
>folks have experienced server "locking/ramping" problems with
>versions 4.5, 4.5.1, 4.5.1 SP1, etc. Has anyone found a solution?
>When the App Server stops handling requests, we can still serve
>up http requests, and run eveything else on the box. Thanks.

---
dave fauth
[EMAIL PROTECTED]

"The opinions expressed here
are my own and not those of 
DOMAIN technologies, inc."
~~
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 Question

[Jeff Sarsoun]

Why the * ?


DELETE from auction_records where auction_id='#id#' and userid='#userid#'


If your 'deleting' your all of the record anyway.

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

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

~~
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: Gore is OJ!!

[Dave Hannum]

Hold on Larry!  You sound just like Sore and Loserman when you first get
your spin and slams in then say "let's tone down the rhetoric".  If you're
going to say "lets keep politics out of CF-Talk", don't interject your
political views FIRST!

Hey, I feel like Sean Hannity!  - LOL  8-)

Dave





- Original Message -
From: "Larry C. Lyons" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:40 AM
Subject: Re: Gore is OJ!!


As honest as bush then. At least Gore doesn't giggle when he signs death
warrents. I have absolutely no respect for someone, like Bush, who looks
up to Danny-boy Quayle as his intellectual superior.

Aside from that, lets keep politics out of CF-Talk. I cannot stand
hearing republicrats whine and have tempertantrums because their boy's
brother didn't rig the election in Florida enough.

Lee Surma wrote:
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> After watching the aerial view of the Ryder truck being followed down =
> the highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are astounding.
>
> Gore has the same sleazy, damn the law to win, attorneys.
>
> He's a liar and guilty as heck.
>
> Even though he is a fortunate son, white male, he has managed to play =
> the race card.
>
> He's using the media to his advantage.
>
> And he's a rich egomaniac.
>
> There is one big difference however.
>
> Gore is not going to win.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> After watching the aerial view of the Ryder truck being followed down =
> the=20
> highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are=20
> astounding.
> Gore has the same sleazy, damn the law to win, attorneys.
> He’s a liar and guilty as heck.
> Even though he is a fortunate son, white male, he has managed to play =
> the=20
> race card.
> He’s using the media to his advantage.
> And he’s a rich egomaniac.
> There is one big difference however.
> Gore is not going to win.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20--
>
> ~~
> 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

--
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--
~~
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

~~
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 on a MS Access Database

[Chris Michl]

Do you have your clause flip-flopped?

Where '#URL.FileID#' = JobInfoUpload.FileID

Should be:

Where JobInfoUpload.FileID='#URL.FileID#'


- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:51 AM
Subject: UPDATE on a MS Access Database


> Im trying a UPDATE on a Access database, and im getting an error
>
>
> 
>  UPDATE JobInfoUpload
>  SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
>  Where '#URL.FileID#' = JobInfoUpload.FileID
> 
>
> Everything is spelled correct, but i get an error below.  I have a feeling
> it has something to do with my Yes/No Column in the database.
>
>
>
> ODBC Error Code = 07001 (Wrong number of parameters)
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
> Hint: The cause of this error is usually that your query contains a
> reference to a field which does not exist. You should verify that the
> fields included in your query exist and that you have specified their
names
> correctly.
> SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
> '48' = JobInfoUpload.FileID"
> Data Source = "CJM.mdb"
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (25:1) to (25:60) in the template
> file D:\Web\Capitol1interface\chad\checkout.cfm.
> Date/Time: 11/30/00 11:51:07
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
> Query String: JobId=11&LoginID=1&FileID=48
>
> ~~
> 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

~~
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 on a MS Access Database

[cf-talk]

Chad, are you sure, you have the right datasourcename ?
It looks more like the raw DB-name you used.
Uwe


Mail: [EMAIL PROTECTED]
WWW: www.sdsolutions.de
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 5:51 PM
Subject: UPDATE on a MS Access Database


Im trying a UPDATE on a Access database, and im getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


Everything is spelled correct, but i get an error below.  I have a feeling
it has something to do with my Yes/No Column in the database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the
fields included in your query exist and that you have specified their names
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (25:1) to (25:60) in the template
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Query String: JobId=11&LoginID=1&FileID=48

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


~~
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 on a MS Access Database

[Simon Horwith]

you don't need the cfoutputs in the query, just the # signs will do, and you
probably need single quotes around #insol.name#.  Also, if
JobInfoUpload.FileID is a numeric field then you need to remove the single
quotes from #URL.FileID#.  Also, I'd reverse the where clause parameters to
make it more readable.

Try:


 UPDATE JobInfoUpload
 SET CheckedOut='Yes', 
 CheckedOutBy='#InSol.Name#'
 Where JobInfoUpload.FileID = '#URL.FileID#'


~Simon


> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database


Im trying a UPDATE on a Access database, and im getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


Everything is spelled correct, but i get an error below.  I have a feeling 
it has something to do with my Yes/No Column in the database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a 
reference to a field which does not exist. You should verify that the 
fields included in your query exist and that you have specified their names 
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where 
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (25:1) to (25:60) in the template 
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Query String: JobId=11&LoginID=1&FileID=48

~~
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
~~
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 Question

[Adkins, Randy]

No the * is not used in SQL 7.0 when using the DELETE function

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

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

~~
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: Studio Error

[Judith Campbell]

At 08:42 AM 11/30/00 -0500, you wrote:
>Question:  What does it mena if CF Studio 4.5.1 returns an error that
>says "Canvas can not be used for drawing"?   If anyone knows, I'd really
>appreciate it.  Thanks!
>
>
>Scott Wolf
>Goodfriend Computer Training

It means the memory leak in Studio has used up all the available 
resources.   Close some other programs and exit studio.  I usually reboot, 
but it's not always necessary.  I really, really wish they would fix this bug.

Judith

~~
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 on a MS Access Database

[Eron Cohen]

Chad, you probably just need single quotes around
'#InSol.Name#'  Single quotes let the database know
that you are inserting a string, for instance into a
TEXT field.  They're easy to forget by mistake.

(and you may also be missing a  (but that's
not likely the cause of your problem here))

Eron

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database


Im trying a UPDATE on a Access database, and im
getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',  
CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' =
JobInfoUpload.FileID


Everything is spelled correct, but i get an error
below.  I have a feeling 
it has something to do with my Yes/No Column in the
database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.
Hint: The cause of this error is usually that your
query contains a 
reference to a field which does not exist. You should
verify that the 
fields included in your query exist and that you have
specified their names 
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes',
CheckedOutBy=chad Where 
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a
general identifier of 
(CFQUERY), occupying document position (25:1) to
(25:60) in the template 
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows
98)
Query String: JobId=11&LoginID=1&FileID=48

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

__
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
~~
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

RESOLVED: CFerror flakiness

[Chris Norloff]

Just to pass on something I learned recently - CFERROR doesn't like comments in the CF 
pages it calls (putting them at the end of the CF page worked better than at the 
beginning).

We have CFERROR call a CF page, which then runs SendMail and calls another CF page.  
With comments at the beginning of the CF pages (file name, developer, change history, 
etc.) we'd occasionally get a flaky response - the pages wouldn't execute and the 
user'd be left with nothing but a blank screen.

Putting the comments at the end of the CF pages solved that problem.

Chris Norloff
(CF 4.0.1 on iPlanet on Solaris)




~~
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: Gore is OJ!!

[Emmet McGovern]

NO POLITICS PLEASE  everyone has different beliefs, no need to spout of
yours to a cf list.  Go to alt.politics.gore.bashing.whining

Emmet McGovern

-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:09 AM
To: CF-Talk
Subject: Gore is OJ!!


This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

After watching the aerial view of the Ryder truck being followed down =
the highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are astounding.

Gore has the same sleazy, damn the law to win, attorneys.

He's a liar and guilty as heck.

Even though he is a fortunate son, white male, he has managed to play =
the race card.

He's using the media to his advantage.

And he's a rich egomaniac.

There is one big difference however.

Gore is not going to win.


--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









After watching the aerial view of the Ryder truck being followed down =
the=20
highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are=20
astounding.
Gore has the same sleazy, damn the law to win, attorneys.
He’s a liar and guilty as heck.
Even though he is a fortunate son, white male, he has managed to play =
the=20
race card.
He’s using the media to his advantage.
And he’s a rich egomaniac.
There is one big difference however.
Gore is not going to win.

--=_NextPart_000_0005_01C05AA4.D737AB20--


~~
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
~~
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: Finding duplicate records

[Rick Lamb]

You should be setting up primary keys or unique index's in your database for
the fields you don't want duplicates. Then around your insert/update
statements us cftry type="database" to catch it when they try and insert
duplicate information, then deal with them appropriately.

Rick

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 7:55 AM
To: CF-Talk
Subject: Re: Finding duplicate records



I would like to use something like this for a form, we are having lost of
problems with duplicate entries. I tried it as shown and it would not let
me get past my name because someone else had used the same department. Is
there a way to make it check all the fields like an 'and' statement? If
this isn't possible is there another way to stop multiple submits?

To: <[EMAIL PROTECTED]>
Subject: Re: Finding duplicate records
Message-ID: <016201c0550b$9fe57470$a41f88d8@ns2>

I got the solution for you, I wrote this and snippetized it because it just
so handy.










SELECT *
FROM #Tablename#
WHERE #dupecheckloop# = '#listgetat(dupecheckvalues,looptracker)#'


You have entered a duplicate #listgetat(dupecheckvalues,looptracker)#
Please correct this error.




Linda McElroy
Web Designer
Sears Direct Response

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

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

CFlocking large if statements

[Ken Tam]

This is a multi-part message in MIME format.

--=_NextPart_000_000B_01C05AC9.FD0C4520
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

CFlocking large if statements?

How would you go about this if the "if" statement requires a "readonly" =
and within the if statement requires several "exclusives"? Please have a =
look at the code below. Any help or suggestions are appreciated.




 bunch of code 



 bunch of code 


SELECT column
FROM table
WHERE columnID =3D #session.variable3#


 bunch of code 



 bunch of code 



 bunch of code 



This if statement and its contents are about 50 lines of code.

Thanks,
Kenny

--=_NextPart_000_000B_01C05AC9.FD0C4520
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








CFlocking large if =
statements?
 
How would you go about this if the "if" =
statement=20
requires a "readonly" and within the if statement requires several =
"exclusives"?=20
Please have a look at the code below. Any help or suggestions are=20
appreciated.
 
 

 
    =
 bunch of=20
code 
 
    
 
        =
 bunch of=20
code 
 
    
        =
SELECT=20
column
        =
FROM=20
table
        =
WHERE=20
columnID =3D #session.variable3#
    =

 
    =20
bunch of code 
 
    
 
        =
 bunch of=20
code 
 
    
 
        =
 bunch of=20
code 
 

 
This if statement and its contents are =
about 50=20
lines of code.
 
Thanks,
Kenny

--=_NextPart_000_000B_01C05AC9.FD0C4520--

~~
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: Get the last 12 months transactions?

[Kevin Schmidt]

Yes.

This gives you today

This will give a date 365 days before today


If your date is older than a year the datecompare function will return 1.

- Original Message -
From: "fr me" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 9:59 AM
Subject: Get the last 12 months transactions?


> Does anyone know how to test that a date is in the last 12 months?
>

_
> Get more from the Web.  FREE MSN Explorer download :
http://explorer.msn.com
>
> ~~
> 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
>


~~
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 on a MS Access Database

[Todd Ashworth]

You don't need the s inside of a .

Also, you need single quotes around #InSol.name#, or else the database
thinks "chad" is a field name and will compain when it can't find it.

Todd Ashworth

- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:51 AM
Subject: UPDATE on a MS Access Database


| Im trying a UPDATE on a Access database, and im getting an error
|
|
| 
|  UPDATE JobInfoUpload
|  SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
|  Where '#URL.FileID#' = JobInfoUpload.FileID
| 
|
| Everything is spelled correct, but i get an error below.  I have a feeling
| it has something to do with my Yes/No Column in the database.
|
|
|
| ODBC Error Code = 07001 (Wrong number of parameters)
| [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
| Hint: The cause of this error is usually that your query contains a
| reference to a field which does not exist. You should verify that the
| fields included in your query exist and that you have specified their
names
| correctly.
| SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
| '48' = JobInfoUpload.FileID"
| Data Source = "CJM.mdb"
| The error occurred while processing an element with a general identifier
of
| (CFQUERY), occupying document position (25:1) to (25:60) in the template
| file D:\Web\Capitol1interface\chad\checkout.cfm.
| Date/Time: 11/30/00 11:51:07
| Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
| Query String: JobId=11&LoginID=1&FileID=48
|
| ~~
| 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
|


~~
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: Get the last 12 months transactions?

[Rick Lamb]

Check out the function dateDiff()

-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?


Does anyone know how to test that a date is in the last 12 months?

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

~~
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 on a MS Access Database

[mark_wimer]

Chad,
Is your last line of code switched around? Should it read
 Where JobInfoUpload.FileID = '#URL.FileID#'
instead?

Mark

Mark Wimer, Bird Point Count Database
American Bird Conservancy, c/o
USGS-Patuxent Wildlife Research Center
12100 Beech Forest Road, Laurel, MD  20708-4038
Ph: 301-497-5596   Email: [EMAIL PROTECTED]


Im trying a UPDATE on a Access database, and im getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


Everything is spelled correct, but i get an error below.  I have a feeling
it has something to do with my Yes/No Column in the database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the
fields included in your query exist and that you have specified their names

correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a general identifier of

(CFQUERY), occupying document position (25:1) to (25:60) in the template
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Query String: JobId=11&LoginID=1&FileID=48

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




~~
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: Finding duplicate records

[Bob Silverberg]

How about this?  It's a cfm file that you can include to check for
duplicates.  I wrote it awhile ago, for a particular purpose, and I just now
noticed that it only deals with character fields.  You could add extra logic
to deal with numeric fields as well.  Perhaps it will give you an idea of
what you can do.


 DSN: Datasource name for the database
--> PK: Primary key of the table being queried
--> chkTable: Name of the table being queried
--> chkFields: A list containing the dbField/formFields to compare (the
dbField name must be the formField name)
<-- qryCheckDups: A query containing the primary key of the record(s) found

|| END FUSEDOC ||
--->


SELECT #PK#
FROM #chkTable#
WHERE





AND

#fld# = '#Evaluate(eval)#'



Bob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 8:55 AM
To: CF-Talk
Subject: Re: Finding duplicate records



I would like to use something like this for a form, we are having lost of
problems with duplicate entries. I tried it as shown and it would not let
me get past my name because someone else had used the same department. Is
there a way to make it check all the fields like an 'and' statement? If
this isn't possible is there another way to stop multiple submits?

To: <[EMAIL PROTECTED]>
Subject: Re: Finding duplicate records
Message-ID: <016201c0550b$9fe57470$a41f88d8@ns2>

I got the solution for you, I wrote this and snippetized it because it just
so handy.










SELECT *
FROM #Tablename#
WHERE #dupecheckloop# = '#listgetat(dupecheckvalues,looptracker)#'


You have entered a duplicate #listgetat(dupecheckvalues,looptracker)#
Please correct this error.




Linda McElroy
Web Designer
Sears Direct Response

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

~~
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: Gore is OJ!!

[Stephen M Aylor]

A simple request to keep this type of commentary off list would have been
sufficient - yet you wasted little time and gave little effort in
contemplating the reprocussions of tossing your 2 pence in the ring.

No more commentary on this - now that you've got your verbal diarrhea off
your chest right?

Spare us all your banter as well please. Repub or Dem or Green Party - your
rebuttal commentary is on par with the intellect you alledge Bush to
manifest.

Save it next time or at least make an apology - or better yet - respond
directly to the original offending poster.

Steve

> As honest as bush then. At least Gore doesn't giggle when he signs death
> warrents. I have absolutely no respect for someone, like Bush, who looks
> up to Danny-boy Quayle as his intellectual superior.
>
> Aside from that, lets keep politics out of CF-Talk. I cannot stand
> hearing republicrats whine and have tempertantrums because their boy's
> brother didn't rig the election in Florida enough.


~~
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 on a MS Access Database

[Brandon Behrens]

Here are a couple of things.  When you get too few parameters, you have
messed up your SQL statement:  here is where you messed up:

Checkedoutby needs single quotes around it like checked out.
I don't know  if this is mandatory or not, but you might want to switch
JobInfoUpload.FileID and #URLFileID# around.  Field names come first.

HTH

Brandon

Brandon Behrens
Developer
Momentum Software
http://www.momentumsoftware.com
512.236.1517

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:52 AM
To: CF-Talk
Subject: UPDATE on a MS Access Database

Im trying a UPDATE on a Access database, and im getting an error



 UPDATE JobInfoUpload
 SET CheckedOut='Yes',   CheckedOutBy=#InSol.Name#
 Where '#URL.FileID#' = JobInfoUpload.FileID


Everything is spelled correct, but i get an error below.  I have a feeling
it has something to do with my Yes/No Column in the database.



ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Hint: The cause of this error is usually that your query contains a
reference to a field which does not exist. You should verify that the
fields included in your query exist and that you have specified their names
correctly.
SQL = "UPDATE JobInfoUpload SET CheckedOut='Yes', CheckedOutBy=chad Where
'48' = JobInfoUpload.FileID"
Data Source = "CJM.mdb"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (25:1) to (25:60) in the template
file D:\Web\Capitol1interface\chad\checkout.cfm.
Date/Time: 11/30/00 11:51:07
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)
Query String: JobId=11&LoginID=1&FileID=48

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

~~
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: Gore is OJ!!

[Jamey S. Lyster]

I second that!!!

I am here to read up on ColdFusion as well.

Jamey

- Original Message -
From: "William J Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 8:26 AM
Subject: RE: Gore is OJ!!


> WTF???
>
> I dont subscribe to this list to hear republicans talk this kinda shit.
> I want to be on this list to hear about coldfusion. If i want to hear
> opinions from assholes i'd go down to the Court house in Broward county
and
> hear these damn republicans screaming at people and assaulting people.
>
> So can we leave this list to ColdFusion Related matters??
>
> Thanks
>
>
> Bill Wheatley
> Director of Development
> AEPS INC
> Allaire ColdFusion Consulting Partner
> Allaire Certified ColdFusion Developer
> http://www.aeps.com
> ICQ: 417645
> http://www.aeps2000.com
> 954-472-6684 X303
>
> IMPORTANT NOTICE:
> This e-mail and any attachment to it is intended only to be read or used
by
> the named addressee.  It is confidential and may contain legally
privileged
> information.  No confidentiality or privilege is waived or lost by any
> mistaken transmission to you.  If you receive this e-mail in error, please
> immediately delete it from your system and notify the sender.  You must
not
> disclose, copy or use any part of this e-mail if you are not the intended
> recipient.  The RTA is not responsible for any unauthorized alterations to
> this e-mail or attachment to it
>
>
>
> -Original Message-
> From: Lee Surma [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 9:09 AM
> To: CF-Talk
> Subject: Gore is OJ!!
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> After watching the aerial view of the Ryder truck being followed down =
> the highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are astounding.
>
> Gore has the same sleazy, damn the law to win, attorneys.
>
> He's a liar and guilty as heck.
>
> Even though he is a fortunate son, white male, he has managed to play =
> the race card.
>
> He's using the media to his advantage.
>
> And he's a rich egomaniac.
>
> There is one big difference however.
>
> Gore is not going to win.
>
>
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> After watching the aerial view of the Ryder truck being followed down =
> the=20
> highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are=20
> astounding.
> Gore has the same sleazy, damn the law to win, attorneys.
> He’s a liar and guilty as heck.
> Even though he is a fortunate son, white male, he has managed to play =
> the=20
> race card.
> He’s using the media to his advantage.
> And he’s a rich egomaniac.
> There is one big difference however.
> Gore is not going to win.
>
> --=_NextPart_000_0005_01C05AA4.D737AB20--
>
>
> ~~
> 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
>
> ~~
> 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
>

~~
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: Gore is OJ!!

[Stephen M Aylor]

Of course we can get back to CF - but only after you snipe your tripe in
there... right?  Typical.

The guy obviously posted to the wrong list - I suppose as a stereo typical
"perfect" democrat youve never made a similar mistake?

Your post was so ... "Mean Spirited" ... tsk tsk tsk.

If you are so concerned about getting the list back ON Topic - then leave
your polictical tripe commentary out and post an apology as the other user
did.

Steve


> WTF???
>
> I dont subscribe to this list to hear republicans talk this kinda shit.
> I want to be on this list to hear about coldfusion. If i want to hear
> opinions from assholes i'd go down to the Court house in Broward county
and
> hear these damn republicans screaming at people and assaulting people.
>
> So can we leave this list to ColdFusion Related matters??
>
> Thanks
>
>
> Bill Wheatley
> Director of Development


~~
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 Question

[Jim Gurfein]

don't use a '*' in the delete statement on SQL7

At 11:11 AM 11/30/00 -0500, you wrote:
>Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
>works great except one statement.
>
>
>DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
>
>
>Here is the error:
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
>'*'.
>
>Is * not the correct syntax for All is SQL 7.0?
>
>Thanks,
>Rich
>
>~~
>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

Sincerely yours,

Jim Gurfein
President, CEO
RestaurantRow.com, Inc.
http://www.restaurantrow.com
914.921.3200 ext 101
914.921.9190 fax

~~
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: Gore is OJ!!

[Greg Wolfinger]

Larry:

If you wanna keep polotics out of CF-Talk, I suggest not starting more
problems by insulting others.  Let's just kill this message thread right
here.

Greg
- Original Message -
From: "Larry C. Lyons" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:40 AM
Subject: Re: Gore is OJ!!


> As honest as bush then. At least Gore doesn't giggle when he signs death
> warrents. I have absolutely no respect for someone, like Bush, who looks
> up to Danny-boy Quayle as his intellectual superior.
>
> Aside from that, lets keep politics out of CF-Talk. I cannot stand
> hearing republicrats whine and have tempertantrums because their boy's
> brother didn't rig the election in Florida enough.
>
> Lee Surma wrote:
> >
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000_0005_01C05AA4.D737AB20
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > After watching the aerial view of the Ryder truck being followed down =
> > the highway this morning, it just occurred to me. Gore is OJ!!! The =
> > parallels are astounding.
> >
> > Gore has the same sleazy, damn the law to win, attorneys.
> >
> > He's a liar and guilty as heck.
> >
> > Even though he is a fortunate son, white male, he has managed to play =
> > the race card.
> >
> > He's using the media to his advantage.
> >
> > And he's a rich egomaniac.
> >
> > There is one big difference however.
> >
> > Gore is not going to win.
> >
> > --=_NextPart_000_0005_01C05AA4.D737AB20
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > 
> > 
> >  > http-equiv=3DContent-Type>
> > 
> > 
> > 
> > 
> > 
> > After watching the aerial view of the Ryder truck being followed down
=
> > the=20
> > highway this morning, it just occurred to me. Gore is OJ!!! The =
> > parallels are=20
> > astounding.
> > Gore has the same sleazy, damn the law to win, attorneys.
> > He’s a liar and guilty as heck.
> > Even though he is a fortunate son, white male, he has managed to play
=
> > the=20
> > race card.
> > He’s using the media to his advantage.
> > And he’s a rich egomaniac.
> > There is one big difference however.
> > Gore is not going to win.
> >
> > --=_NextPart_000_0005_01C05AA4.D737AB20--
> >
> > ~~
> > 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
>
> --
> Larry C. Lyons
> ColdFusion/Web Developer
> EBStor.com
> 8870 Rixlew Lane, Suite 201
> Manassas, Virginia 20109-3795
> tel: (703) 393-7930 x253
> fax: (703) 393-2659
> http://www.ebstor.com
> http://www.pacel.com
> email: [EMAIL PROTECTED]
>
> Chaos, panic, and disorder - my work here is done.
> --
> ~~
> 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
>

~~
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: Nesting enclosing Custom Tags

[Kevin Miller]

Try this:

(will run 'start' code in tag)

 (will run 'end' code in tag)

In your tag, you can run the appropriate code depending on the value of
Attributes.Part.

Kevin


>>> [EMAIL PROTECTED] 11/30/00 05:32AM >>>

  I don't know if what you are trying to do is possible.  Double
checking
the manual may help.  

(will run 'start' code in tag)

 (will run 'end' code in tag)

   I just don't think there is a way to execute code from two tags 
using the above syntax.  You may want to try to simplify it into 
one tag.  


Marc Schipperheyn wrote:
> 
> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0004_01C05AAE.84F5BB40
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> 
> Hi all,
> 
> I'm looking for a way to nest a set of enclosing custom tags inside
another
> set of enclosing custom tags. I can't get it to work and I've added
an
> example with three templates: testmotherchild, mother and child. The
idea is
> that the closing tag of the child should be called in the closing tag
of the
> mother and the opening tag of the child in the opening tag of the
mother.
> 
> Using includes this behaviour would be easy. So it should be possible
in a
> Custom Tag setting. Any ideas?
> 
> Marc
> 
> **test template**
> 
> 
> Some code
> 
> 
> 
> **mother.cfm**
> 
>  motherstart
>  
> 
> 
>  motherend
>  
> 
> 
> **child.cfm**
> 
> 
>  childstart
> 
> 
> 
>  childend
> 
> 
> 


-- 
Jeff Houser | mailto:[EMAIL PROTECTED] 
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5  | ISBN: 0-07-213238-8   
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
http://www.farcryfly.com | http://www.mp3.com/FarCryFly 
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~~
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
~~
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: IP Address blocking

[Kevin Schmidt]

That would be what I would suggest as well.  Just set up a custom tag that
executes any time a file is uploaded. Read in the content of the file and
use regular expressions to sort out the links and kill or mangle them.

PS the jnl site still hasn't changed

Kevin Schmidt
Allaire Certified Cold Fusion Developer
Internet Services Manager
PWB, Inc. Integrated Marketing and Communications
Office: 734.995.5000
Mobile: 734.649.4843

- Original Message -
From: "Matthias Wiemann" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 7:47 AM
Subject: AW: IP Address blocking


Hi,
we had a similar problem since we wanted to have a scheduled job which will
add CF Session-Variables to links in our .cfm pages, which were posted by a
dumb Content Management System(no names here).

We used a custom tag CF_DirectoryList (->see devex.allaire.com) to recurse
the directories and get the filenames.
To replace the old links by the new links we used regular expressions
(ReFind).

With the help of the Regular Expression you can then change the url or even
remove the Link-Tags if the url contains an unwanted url.

HTH

- Matthias P. Wiemann

eWiemann Consulting GmbH

Tel: +49.(0)89.127.377.44
Fax: +49.(0)89.127.377.46



> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 30. November 2000 07:28
> An: CF-Talk
> Betreff: IP Address blocking
>
>
> I have  a unique problem. I know how to keep folks from linking to my
> pages on my server, but I allow others to also post pages to my web
> servers.  Their pages contain links to places I don't want
> folks going to.
> So, I could prevent them from writing their pages on my server, or I
> could search out and mangle such links. However, is there yet a
> sneakier way to let them do their thing, but I make it
> "non-responsive"
> when it gets clicked on?  Or could I redirect it to some other site?
> What is the best way to proceed. /spe
>
> ~~
> 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
>
~~
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=sts


~~
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 Question

[Jeanne Sarfaty Glazer]

I believe the SQL should read:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
(minus the *)

- - - Jeanne

- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question


> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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
>

~~
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 Question

[Jeffry Houser]

  I'm surprised that statement worked in Access.  

  The delete statement automatically deletes a whole row.  You do not 
need to specify a wildcard, or column as you would in a select statement.

 
   DELETE from auction_records where auction_id='#id#' and userid='#userid#'
 



ibtoad wrote:
> 
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
> 
> 
> DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
> 
> 
> Here is the error:
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
> '*'.
> 
> Is * not the correct syntax for All is SQL 7.0?
> 
> Thanks,
> Rich
> 
> ~~
> 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

-- 
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5  | ISBN: 0-07-213238-8   
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~~
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: Gore is OJ!!

[Chris Straight]

guess what lee I do not appreciate this at all either I find it to be
unprofessional and childish but Mr. Wheatley you could be a little more
professional as well I personally am uninterested in the whole election
bumble that has turned out so please do not post any more political comments
on this list.

Chris Straight
Lead Web Applications Developer
University of Oregon Bookstore, inc.
http://www.uobookstore.com/

-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 8:27 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Gore is OJ!!


WTF???

I dont subscribe to this list to hear republicans talk this kinda shit.
I want to be on this list to hear about coldfusion. If i want to hear
opinions from assholes i'd go down to the Court house in Broward county and
hear these damn republicans screaming at people and assaulting people.

So can we leave this list to ColdFusion Related matters??

Thanks


Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303

IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it



-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:09 AM
To: CF-Talk
Subject: Gore is OJ!!


This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

After watching the aerial view of the Ryder truck being followed down =
the highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are astounding.

Gore has the same sleazy, damn the law to win, attorneys.

He's a liar and guilty as heck.

Even though he is a fortunate son, white male, he has managed to play =
the race card.

He's using the media to his advantage.

And he's a rich egomaniac.

There is one big difference however.

Gore is not going to win.


--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









After watching the aerial view of the Ryder truck being followed down =
the=20
highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are=20
astounding.
Gore has the same sleazy, damn the law to win, attorneys.
He’s a liar and guilty as heck.
Even though he is a fortunate son, white male, he has managed to play =
the=20
race card.
He’s using the media to his advantage.
And he’s a rich egomaniac.
There is one big difference however.
Gore is not going to win.

--=_NextPart_000_0005_01C05AA4.D737AB20--


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

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

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

ListContains wierdness - why?

[Park, Simon]

Why does the following always return TRUE?



TRUE

FALSE


Do I need to put the values into an array?

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park  Computer Systems Management, Inc.
Ph: 703-823-4300 x119   205 South Whiting Street #201
fax: 703-823-4301   Alexandria, VA  22304
 http://www.csmi.com  

~~
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 database transfer from one server to another

[Chris Terrebonne]

Look up the syntax for sp_dettach and sp_attach.
With that you can move the db by hand with no leftovers.

Chris
--
Original Message
From: "ryo watanabe"<[EMAIL PROTECTED]>
Subject: SQL 7 database transfer from one server to another
Date: Thu, 30 Nov 2000 11:27:36 -0500

>This is a multi-part message in MIME format.
>
>--=_NextPart_000_0038_01C05AC0.8A100420
>Content-Type: text/plain;
>   charset="Windows-1252"
>Content-Transfer-Encoding: quoted-printable
>
>when I transfer a SQL database from one server to another using MSDTS, =
>it ignores the datatypes.  am I missing something when I use MSDTS, or =
>is this a bug?
>
>--=_NextPart_000_0038_01C05AC0.8A100420
>Content-Type: text/html;
>   charset="Windows-1252"
>Content-Transfer-Encoding: quoted-printable
>
>
>
>charset=3Dwindows-1252">
>
>
>
>
>when I transfer a SQL database from one server to =
>another=20
>using MSDTS, it ignores the datatypes.  am I missing something when =
>I use=20
>MSDTS, or is this a bug?
>
>--=_NextPart_000_0038_01C05AC0.8A100420--
>
>~~
>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
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

~~
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: Firewall Question

[Marcus]

Thanks Dave... I couldn't have said it any better...

Marcus
A net admin

> With all due respect, I suspect you're not a network admin!
>
> Any time you open a port, it's a risk - it's another thing that has to be
> watched. There are typically limited resources for what a network
> administrator can deal with, and no matter what products you buy to help
> monitor security issues, they still require human guidance and
> intervention.
> I've seen enough misconfigured firewalls to know that you can't simply buy
> hardware and software to solve security issues.
>
> The question here is, do the risks outweigh the rewards? From the network
> admin's point of view, probably not - until someone convinces him
> otherwise.
>

~~
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: CFFILE - writing a CF template REDUX

[Bud]

On 11/30/00, j p penned:
>Example:
>Section A - is the actual page code I want to generate, with all character
>that cause a problem replaces with something else. This is needed beacuse a
><, >,  or " inside a CFSET (or inside teh CFFILE) will cause the tag to
>fail.

There should be no problem using < inside of quotes in the cffile 
output variable or inside of quotes inside of cfset. The only things 
that should give you problems are quotes and #.

For instance this code:



some page text

`variables.SomeVar`



">

I would write like this: Paste this into a template and change the 
path of cffile and watch it work. :)




" & 
chr(10) & chr(10)

& variables.SomeVar & chr(10) & chr(10)

& "" & chr(10)
& "">



-- 

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

Re: SQL 7.0 Question

[Jamie Keane]

Try just DELETE FROM  WHERE 

You'd have to use UPDATE to delete/mangle individual cell data, so the * in
the previous statement is unnecessary. :)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: ibtoad <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Thursday, November 30, 2000 2:24 PM
Subject: SQL 7.0 Question


>Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
>works great except one statement.
>
>
>DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
>
>
>Here is the error:
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
>'*'.
>
>Is * not the correct syntax for All is SQL 7.0?
>
>Thanks,
>Rich
>
>~~
>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

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

date funcions in netscape

[Eli Shechter]

Hi

i have created a calendar with date functions,

examples;



#daysInMonth(now())#
#dayofweek(now())#
#dayofweekAsString(todayOfWeek)#


the problem is, that netscape takes a long time to process these functions.
it works fast in IE though.

are there any alternative functions i can use?? or any way to speed it up??

Thank You
-Eli Shechter-

~~
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: Gore is OJ!!

[Clint Tredway]

Watch your language man. I don't want to see that filth on the list. I agree
that the previous post could be left off, but your post is worse than the
one you are complaining about. 

So chill.

-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:27 AM
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Gore is OJ!!


WTF???

I dont subscribe to this list to hear republicans talk this kinda shit.
I want to be on this list to hear about coldfusion. If i want to hear
opinions from assholes i'd go down to the Court house in Broward county and
hear these damn republicans screaming at people and assaulting people.

So can we leave this list to ColdFusion Related matters??

Thanks


Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303

IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it



-Original Message-
From: Lee Surma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:09 AM
To: CF-Talk
Subject: Gore is OJ!!


This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

After watching the aerial view of the Ryder truck being followed down =
the highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are astounding.

Gore has the same sleazy, damn the law to win, attorneys.

He's a liar and guilty as heck.

Even though he is a fortunate son, white male, he has managed to play =
the race card.

He's using the media to his advantage.

And he's a rich egomaniac.

There is one big difference however.

Gore is not going to win.


--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









After watching the aerial view of the Ryder truck being followed down =
the=20
highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are=20
astounding.
Gore has the same sleazy, damn the law to win, attorneys.
He’s a liar and guilty as heck.
Even though he is a fortunate son, white male, he has managed to play =
the=20
race card.
He’s using the media to his advantage.
And he’s a rich egomaniac.
There is one big difference however.
Gore is not going to win.

--=_NextPart_000_0005_01C05AA4.D737AB20--


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

~~
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
~~
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 Question

[Nardi, Gaston]

That's right, don't use the * 
Just DELETE FROM ... WHERE ...

Regards,
Gaston


> -Mensaje original-
> De:   ibtoad [SMTP:[EMAIL PROTECTED]]
> Enviado el:   Jueves 30 de Noviembre de 2000 13:11
> Para: CF-Talk
> Asunto:   SQL 7.0 Question
> 
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
> 
> 
> DELETE * from auction_records where auction_id='#id#' and
> userid='#userid#'
> 
> 
> Here is the error:
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near
> '*'.
> 
> Is * not the correct syntax for All is SQL 7.0?
> 
> Thanks,
> Rich
> 
> ~~
> 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
~~
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

Way OT: PDA's, Christmas & Wap dev

[Paul Ihrig]

ok this is way Way OT: 

i wanted to get my fiance a cheap PDA that has internet capabilities.
so i can beging to experiment on building wap app's.

what is good, what is worth its price?

i have been looking at the hand springs & palms but would like your feed
back if you have any good or bad experience.
also any good cheap sevice providers for them.

also she is a director developer, & is mostly on the mac platform.
what is good for synking up with her G3 laptop?

i appologize for the OT.

thanks.

-paul
~~
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 Question

[Bosky, Dave]

try

DELETE auction_records where auction_id='#id#' and userid='#userid#'


-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
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
~~
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 Question

[Gregory Harris]

Your statement for SQL would be:

DELETE  from auction_records where auction_id='#id#' and userid='#userid#'

(basically delete the "*")
Gregory Harris
Web Developer
Stirling Bridge Group LLC

- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 8:11 AM
Subject: SQL 7.0 Question


> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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
>
>

~~
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 Question

[Doug Powell]

Take out the * in the Query in SQL all you need is


DELETE from auction_records where auction_id='#id#' and userid='#userid#'


Instead of

DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


You will need to do this on all you DELETE if you have many
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

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


~~
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: Gore is OJ!!

[Vance_Duke]

I do not think this is the medium for Political Debates.  Please take this
off-list.

Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729



   

"Lee Surma"

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

rg>  cc:   

 Subject: Gore is OJ!! 

11/30/00   

08:09 AM   

Please 

respond to 

cf-talk

   

   





This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/plain;
   charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

After watching the aerial view of the Ryder truck being followed down =
the highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are astounding.

Gore has the same sleazy, damn the law to win, attorneys.

He's a liar and guilty as heck.

Even though he is a fortunate son, white male, he has managed to play =
the race card.

He's using the media to his advantage.

And he's a rich egomaniac.

There is one big difference however.

Gore is not going to win.


--=_NextPart_000_0005_01C05AA4.D737AB20
Content-Type: text/html;
   charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









After watching the aerial view of the Ryder truck being followed down =
the=20
highway this morning, it just occurred to me. Gore is OJ!!! The =
parallels are=20
astounding.
Gore has the same sleazy, damn the law to win, attorneys.
He’s a liar and guilty as heck.
Even though he is a fortunate son, white male, he has managed to play =
the=20
race card.
He’s using the media to his advantage.
And he’s a rich egomaniac.
There is one big difference however.
Gore is not going to win.

--=_NextPart_000_0005_01C05AA4.D737AB20--


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




~~
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 Question

[Evan Lavidor]

If you're deleting, you don't need the "*".  SQL Server understands that you
want to delete the whole row just by saying "DELETE FROM tablename where
something = 'somethingelse'".

Evan

> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 11:11 AM
> To: CF-Talk
> Subject: SQL 7.0 Question
>
>
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and
> userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect
> syntax near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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

~~
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: Problems sending to List

[Michael Dinowitz]

I got your message 12 minutes after it was sent. Its possible that the list
is having problems sending mail to you. This happens when the connection
between the HoF server tries and fails to connect to another mail server for
some reason. The message is then 'queued up and then tried again in an hour.


> Anyone else having problems sending to the list?
> I have sent 2 messages already.
>
> First one was at 11:32 AM (Eastern Time)
> Second one was at 1:02 PM (Eastern Time)
>
> And now this one at 1:51 PM (Eastern Time)
>
> All dated 11/30/2000.
>
> I can send and receive to other people and to
> other lists.
>
> Is CF-Talk still having delivery issues???
>
> ~~
> 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
>

~~
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: Gore is OJ!!

[Braver, Ben:]

This doesn't even belong on CF-Community let alone CF-Talk.
This is SPAM.
Stop it.

> -Original Message-
> From: Lee Surma [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 6:09 AM
> To:   CF-Talk
> Subject:  Gore is OJ!!
> 
> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> After watching the aerial view of the Ryder truck being followed down =
> the highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are astounding.
> 
> Gore has the same sleazy, damn the law to win, attorneys.
> 
> He's a liar and guilty as heck.
> 
> Even though he is a fortunate son, white male, he has managed to play =
> the race card.
> 
> He's using the media to his advantage.
> 
> And he's a rich egomaniac.
> 
> There is one big difference however.
> 
> Gore is not going to win.
> 
> 
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/html;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> After watching the aerial view of the Ryder truck being followed down =
> the=20
> highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are=20
> astounding.
> Gore has the same sleazy, damn the law to win, attorneys.
> He’s a liar and guilty as heck.
> Even though he is a fortunate son, white male, he has managed to play =
> the=20
> race card.
> He’s using the media to his advantage.
> And he’s a rich egomaniac.
> There is one big difference however.
> Gore is not going to win.
> 
> --=_NextPart_000_0005_01C05AA4.D737AB20--
> 
> 
> ~~
> 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
~~
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

Problems sending to List

[Adkins, Randy]

Anyone else having problems sending to the list?
I have sent 2 messages already.

First one was at 11:32 AM (Eastern Time)
Second one was at 1:02 PM (Eastern Time)

And now this one at 1:51 PM (Eastern Time)

All dated 11/30/2000.

I can send and receive to other people and to
other lists. 

Is CF-Talk still having delivery issues???

~~
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: Get the last 12 months transactions?

[Billy Cravens]

Something like 
 

-- 
Billy Cravens
[EMAIL PROTECTED]


fr me wrote:
> 
> Does anyone know how to test that a date is in the last 12 months?
> _
> Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com
> 
> ~~
> 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
~~
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 Question

[Hays, Duncan]

In Oracle you just use DELETE FROM TABLE. No * is necessary.

Duncan Hays

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
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
~~
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: Gore is OJ!!

[Billy Cravens]

hmm.. maybe my judgement is a bit different than most, but this strikes
me as a smidgen off-topic.

-- 
Billy Cravens
[EMAIL PROTECTED]


Lee Surma wrote:
> 
> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> After watching the aerial view of the Ryder truck being followed down =
> the highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are astounding.
> 
> Gore has the same sleazy, damn the law to win, attorneys.
> 
> He's a liar and guilty as heck.
> 
> Even though he is a fortunate son, white male, he has managed to play =
> the race card.
> 
> He's using the media to his advantage.
> 
> And he's a rich egomaniac.
> 
> There is one big difference however.
> 
> Gore is not going to win.
> 
> --=_NextPart_000_0005_01C05AA4.D737AB20
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> After watching the aerial view of the Ryder truck being followed down =
> the=20
> highway this morning, it just occurred to me. Gore is OJ!!! The =
> parallels are=20
> astounding.
> Gore has the same sleazy, damn the law to win, attorneys.
> He’s a liar and guilty as heck.
> Even though he is a fortunate son, white male, he has managed to play =
> the=20
> race card.
> He’s using the media to his advantage.
> And he’s a rich egomaniac.
> There is one big difference however.
> Gore is not going to win.
> 
> --=_NextPart_000_0005_01C05AA4.D737AB20--
> 
> ~~
> 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
~~
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.1 SP2 -- Ramping/Queing Problem

[David Fauth]

welcome to the club...We're having the same problem.  Reinstalling didn't help.  
CFLOCKs didn't help.  Not sure what to do but it looks like 4.0.1 may be the fallback. 
 We're running Oracle 8, NT sp6a and IIS4.

dave



-- Original Message --
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Wed, 29 Nov 2000 22:43:18 -0500

>We have a problem with CF 4.5.1 SP2 in which the CF App server
>just starts queing requests and never finishes processing of active
>threads.  When this happens we always have plenty of memory and
>CPU available. It happens under conditions of very light load to
>very heavy load. It happens on different servers at different times of
>the day.  We are running NT SP6a and Website.  We are using
>primarily UDB and Sybase databases. Allaire told us to put
>CFLOCKs in our code.  We put tons of CFLOCKs in our code,
>first write locks, then read locks, then any possible lock.  All
>this accomplishes is to slow our apps way down.  A number of
>folks have experienced server "locking/ramping" problems with
>versions 4.5, 4.5.1, 4.5.1 SP1, etc. Has anyone found a solution?
>When the App Server stops handling requests, we can still serve
>up http requests, and run eveything else on the box. Thanks.
>~~
>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
>
~~
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

Excerpt

[Rob Eastland]

I'm trying to build a tag that gets the article text from an access memo
field and returns part of it as a news excerpt on another page. I thought of
doing a cfhttp from the main news page and stripping it down, but I think
that would be slow and  I was wondering if anyone had a better suggestion?

:--))
Rob Eastland

~~
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 Question

[David Livingston]

Yes, you don't need * when doing a SQL delete statement.
Dave

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
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
~~
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 Question

[Chris Terrebonne]

Yes, * is the syntax for ALL in SQL7, but you don't need to specify that
for a DELETE.
When you issue a delete, you delete the entire record, so there is no need
to specify columns.
Try:
DELETE from auction_records where auction_id='#id#' and userid='#userid#'


Chris
--
Original Message
From: "ibtoad"<[EMAIL PROTECTED]>
Subject: SQL 7.0 Question
Date: Thu, 30 Nov 2000 11:11:27 -0500

>Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
>works great except one statement.
>
>
>DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
>
>
>Here is the error:
>
>ODBC Error Code = 37000 (Syntax error or access violation)
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
>'*'.
>
>Is * not the correct syntax for All is SQL 7.0?
>
>Thanks,
>Rich
>
>~~
>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
>

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

~~
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 Question

[Clint Tredway]

You do not need the *.

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
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
~~
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 Question

[Simon Horwith]

I believe you want:


DELETE from auction_records where auction_id='#id#' and userid='#userid#'
 

in other words, you don't want that asterisk.

~Simon

> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 11:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
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
~~
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: Get the last 12 months transactions?

[Gregory Harris]

 If
the date you are testing if the date is greater than or equal to last year
(substitute your favorite operator as needed)

Gregory Harris
Web Developer
Stirling Bridge Group LLC

- Original Message -
From: "fr me" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 7:59 AM
Subject: Get the last 12 months transactions?


> Does anyone know how to test that a date is in the last 12 months?
>

_
> Get more from the Web.  FREE MSN Explorer download :
http://explorer.msn.com
>
> ~~
> 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
>
>

~~
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: What Time Zone

[Scott Wolf]

Eastern :P

Scott Wolf
Goodfriend Computer Training

-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:00 AM
To: CF-Talk
Subject: What Time Zone


Dear All,

I know this is not the place for this type of message but does any body
know
what Time Zone Allaire's HQ is in ?

>From R
~~
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
~~
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: Massive Delay

[Michael Dinowitz]

The Lyris server I was using for news crashed the network services (as I
mentioned in a different post). Now that it is off, the posts are flying.


> Has anyone experienced a LONG TIME before they
> receive emails from House of Fusion or even their
> own POSTS?
>
>
>
> ~~
> 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
>

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

(Admin)Re: Gore is OJ!!

[Michael Dinowitz]

Take this topic over to CF-Community or better yet take it totally off the
lists. It is very OT for CF-Talk and I don't want to come down hard on
anyone.

~~
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: Gore is OJ!!

[ron]

Lee: You better don some protective gear... not only did you start a
polarizing political topic in the development-oriently CF-Talk list, you did
it with an HTML message. :)

Everyone else: Please, let this die now. Send your responses to
mailto:[EMAIL PROTECTED] if you really feel the need.

thx,
Ron

> -Original Message-
> From: Lee Surma [mailto:[EMAIL PROTECTED]]
< big snip >


~~
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: Gore is OJ!!

[Robert Everland]

Love to keep things on topic of computers, especially CF. Take your
political jargon over to CNN bulletin boards or anything.

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: SP2 install killed our OLEDBs!

[ron]

> We had this problem and needed to reinstall MDAC.  There is a
> copy of it in
> \mdac

If you're running Win2K, you can't reinstall MDAC to my knowledge.
Installing CF on Win2K sometimes breaks ADO for ASP, so having OLEDB broken
too doesn't surprise me. Unfortunately, sometimes only a Win2K reinstall or
update will fix it.

-ron

~~
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 Question

[Aaron Rouse]

You are correct, just leave off the *

- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 10:11 AM
Subject: SQL 7.0 Question


> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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
>

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

Massive Delay

[Adkins, Randy]

Has anyone experienced a LONG TIME before they 
receive emails from House of Fusion or even their 
own POSTS?



~~
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: What Time Zone

[John Tierney]

Allaire's HQ in Massachusetts is in the Eastern Timezone

(Glad to get a question I know the answer to..thanks to all for all the help
over the past year.)

John Tierney


-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 9:00 AM
To: CF-Talk
Subject: What Time Zone


Dear All,

I know this is not the place for this type of message but does any body know
what Time Zone Allaire's HQ is in ?

>From R
~~
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

~~
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: Get the last 12 months transactions?

[Dylan Bromby]

Or if you want to do it in SQL, use the BETWEEN operator

-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 7:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?


Does anyone know how to test that a date is in the last 12 months?

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

~~
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: Get the last 12 months transactions?

[Dylan Bromby]

You can use DateDiff()

-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 7:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?


Does anyone know how to test that a date is in the last 12 months?

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

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

~~
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 Question

[Hayes, David]

I'm guessing auction_id or userid are numeric -- not text -- fields; try
removing the single quotes where appropriate.

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:11 AM
To: CF-Talk
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.


DELETE * from auction_records where auction_id='#id#' and userid='#userid#'


Here is the error:

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

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

Is * not the correct syntax for All is SQL 7.0?

Thanks,
Rich

~~
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
~~
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 Question

[Bruce Heerssen]

No, just remove the asterisk (*) and it should work fine. In delete queries, it
is assumed that you want to delete all records that match the criteria in the
WHERE clause, unless you explicitly specify which fields to delete.

-- Bruce

> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 10:11 AM
> To: CF-Talk
> Subject: SQL 7.0 Question
>
>
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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

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

FW: (Admin) List status

[Angél Stewart]

Why on earth do that??

That will be chaos!
THe subjectline should be enough to see the type of error or help needed or
offered, or at least the first few lines of the
message.

How will having 10 different mailing lists for each facet of CF help? Would
anyone ONLY subscribe to say the "Security" mailing list..without being on
the Database Backend mailing list?

And if you think you will subscribe to more than one..say 4 or 5..then what
would be the point in splitting the list into several focussed parts in the
first place?

-Gel


-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]

I have a question Mike:
Previously, you had mentioned "breaking" the CF-Talk list into several
lists, each devoted to more specific issues/complaints/etc.
Is this still in the works?


~~
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 Question

[netman]

You may want to use FROM instead of from, I am not sure if it is that picky
or not, but * does mean all in SQL 7.0 as well.

Robert
- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question


> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> 
> DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
> 
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~
> 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

~~
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 Question

[Todd Ashworth]

You don't need the * ... DELETE FROM will work just fine.

Todd Ashworth

- Original Message -
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
Subject: SQL 7.0 Question


| Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
| works great except one statement.
|
| 
| DELETE * from auction_records where auction_id='#id#' and
userid='#userid#'
| 
|
| Here is the error:
|
| ODBC Error Code = 37000 (Syntax error or access violation)
|
| [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
| '*'.
|
| Is * not the correct syntax for All is SQL 7.0?
|
| Thanks,
| Rich
|
| ~~
| 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
|


~~
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: Gore is OJ!!

[Stewart McGowan]

who's gore? Is he an allaire certified doodah?

~~
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 Cahce or Build Static File

[Greg Wolfinger]

This is a multi-part message in MIME format.

--=_NextPart_000_0017_01C05ACB.7FC19D70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey Guys:

I am building a web site that randomly pulls 4 different categories from =
a database and displays the sub categories in them, with links to each =
of those categories.  Picture the Yahoo! homepage, cause its the same =
thing.

Right now I have a database query that finds all of the top level =
categories and randomly picks four to be selected.  It then querries for =
all of the sub categories of those four categories and then lists the =
data in the same format as Yahoo!  I cache the querries for 1 day since =
this is placed on the homepage so it will be needed every time someone =
goes to the site.

I was wondering though if it would be easier to say have a script run at =
3am and generate files for each root category with its sub categories =
and then just randomly select four of those files instead of having to =
use cached querries at all.  Does anyone know if this would decrease or =
increase performance or not make much of a difference.  Any other =
solutions.

Thanks is Advanced,



Greg Wolfinger
Certified Uncertified ColdFusion Developer

--=_NextPart_000_0017_01C05ACB.7FC19D70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hey Guys:
 
I am building a web site that randomly =
pulls 4=20
different categories from a database and displays the sub categories in =
them,=20
with links to each of those categories.  Picture the Yahoo! =
homepage, cause=20
its the same thing.
 
Right now I have a database query that =
finds all of=20
the top level categories and randomly picks four to be selected.  =
It then=20
querries for all of the sub categories of those four categories and then =
lists=20
the data in the same format as Yahoo!  I cache the querries for 1 =
day since=20
this is placed on the homepage so it will be needed every time someone =
goes to=20
the site.
 
I was wondering though if it would be =
easier to say=20
have a script run at 3am and generate files for each root category with =
its sub=20
categories and then just randomly select four of those files instead of =
having=20
to use cached querries at all.  Does anyone know if this would =
decrease or=20
increase performance or not make much of a difference.  Any other=20
solutions.
 
Thanks is Advanced,
 
 
 
Greg Wolfinger
Certified Uncertified ColdFusion=20
Developer

--=_NextPart_000_0017_01C05ACB.7FC19D70--

~~
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: Get the last 12 months transactions?

[Duane Boudreau]

> -Original Message-
> From: fr me [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 10:59 AM
> To: CF-Talk
> Subject: Get the last 12 months transactions?
> 
> 
> Does anyone know how to test that a date is in the last 12 months?
>
>
>

Try something like this:

SELECT fields
FROMtable
WHERE   date <= #DateAdd("m", 12, Now())#

HTH,
Duane Boudreau
Director of Web Technologies
Ektron, Inc.


~~
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: Get the last 12 months transactions?

[Simon Horwith]

 the date variable is within one year of now.

 the date variable is older than one year


By te way,
A less efficient way of doing this, which is more flexible in that you don't
have to be testing for a date within an interval of now (i.e. you could
specify a range) might look something like this:




The date variable occured within the last 12 months

this date is Greater han one year old


~Simon

> Simon Horwith
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-Original Message-
From: fr me [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:59 AM
To: CF-Talk
Subject: Get the last 12 months transactions?


Does anyone know how to test that a date is in the last 12 months?

_
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com

~~
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
~~
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: Another newbie Query/DB Question

[Hayes, David]

OK, so you populate your "select distributor state" control from tblstate,
with the values = state_name

Then do the same query on your listing page, but add WHERE dis_state =
'#FORM.#'

You can even put a conditional in your cfquery:

select 
FROM 
etc
etc
 NEQ >
WHERE dis_state = '#FORM.#'



-Original Message-
From: Michael Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 10:12 AM
To: CF-Talk
Subject: Another newbie Query/DB Question


Hi,

I have an Access DB with the following:

tbldis - dis_id, dis_name, dis_phone, dis_city and dis_state
tblstate - id, state_name

I have made a page that lists all distributors (over 100), Grouped/ordered
by state, then city and then distributor name. At present the page lists
'all' distributors by default. What I would like to do is to add the ability
for the user to select an individual state from a dropdown menu and pull up
the distributors for only a specific state, if they so choose.

I only use tblstate to populate a dropdown on the insert form and update
forms in the admin interface. This puts the actual state_name, rather than
an ID in tbldis during an update or insert.

As things stand, is it possible for me to accomplish what I want and if so
could you provide an example. If not what changes will I have to make to my
DB in order to make this work.

Thanks,

Mike






Michael Wilson - CTO/Secretary
http://www.xionmedia.com

Xion Media, Inc. Web Development
P: 704-398-2454  F: 704-398-2063

"In the middle of difficulty lies opportunity." --Albert Einstein

~~
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
~~
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: IP Address blocking

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

You might be able to use the HTTP Referer of the request to determine
whether to show the page or not.  We use a similar thing to prevent
direct linking to image content on our site -- we use CF to serve
images via CFCONTENT.  The page checks the referer before serving the
image.  If the referer is from our server, the user sees the image
and never knows anything is out of the ordinary.  If the referer is
missing or is from another site, they get a "You've been bad" kind of
image served to them instead.  That image just has text that explains
bandwidth theft and asks the user to report the site they clicked
from to us.

Here's slightly abridged code:



















This should be even easier if you're only serving HTML files from
those links.  Something like the following stuck at the top of the
protected pages should suffice:

You don't belong here!



Hope that's helpful.

Best regards,
Zac Bedell


Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.

Please include original message in any replies -- I get a 
lot of email every day, and I have a REALLY bad memory... 
So I don't always remember everything that was said.  
Thanks!





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 1:28 AM
> To: CF-Talk
> Subject: IP Address blocking
> 
> 
> I have  a unique problem. I know how to keep folks from linking to
> my  pages on my server, but I allow others to also post pages to my
> web  servers.  Their pages contain links to places I don't want 
> folks going to.
> So, I could prevent them from writing their pages on my server, or
> I could search out and mangle such links. However, is there yet a
> sneakier way to let them do their thing, but I make it 
> "non-responsive"
> when it gets clicked on?  Or could I redirect it to some other
> site? What is the best way to proceed. /spe
> 
> ~~
> 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
> 

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOiaM8avhLS1aWPxeEQKZZQCgu3dwOMTdDSPyfncspXevjsFxT6cAoOYF
zjb25p1JJb3HfbaekyZ+FHFP
=Z64M
-END PGP SIGNATURE-
~~
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

Cheap Hosting Needed

[Jeremy Toevs]

Anyone know of any goof CF Hosting companies that charge about 20 to 30 per month. I 
am with BMI.net right now and they are not very good.

~~
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?sidebarRsts

Advanced queries

[W Luke]

Hi,

I wonder if someone could help me out with some queries I'm running on a
scheduled task.

I need to send out outstanding invoices, including details of what they have
bought (i.e. an Advert - details of which are in advert_details).  Once
done, I need to set the "Sent" column of the Invoices to "Yes".  It involved
3 tables - invoices, payments and advert_details.

Below is what I've done - but I'm pretty sure I've done it wrong, and I'm
not sure where or how to set the invoices.sent to "Yes".


SELECT email,ad_ID,advert_ID,paid,sent
FROM payments,invoices
WHERE paid = Yes AND sent = No AND ad_ID = advert_ID



There are no outstanding INVOICES TO BE PAID



 
 SELECT * FROM advert_details WHERE ID = #ad_ID# AND email = '#email#'
 


 

 

 There are #invoices.recordcount# invoices outstanding


I'd be grateful for anyone's wisdom with advanced querying on this..

Cheers

Will

~~
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 Question

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> 
> DELETE * from auction_records where auction_id='#id#' and 
> userid='#userid#'
> 
> 
> Here is the error:
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: 
> Incorrect syntax near '*'.
> 
> Is * not the correct syntax for All is SQL 7.0?

In SQL, a DELETE statement inherently means to delete all columns. 
The * is redundant since there's no way to specify the columns you
want to delete in a DELETE statement.  Access probably ignored it;
but to the best of my knowledge, that isn't technically correct SQL. 
SQL Server is kicking it out for that reason.  The statement should
be:

DELETE FROM auction_records 
WHERE auction_id='#id#' 
AND userid='#userid#'

(Caps of course are not important, but I like all my SQL keywords
capped for readability...)

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOiaLNqvhLS1aWPxeEQLKKwCfVxX/QJ39/4OgI79p2wFVIlpTQb8AoLWn
jE5qpxzPrhXBcyht8P6yRCl1
=XpCU
-END PGP SIGNATURE-
~~
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: Firewall Question

[Philip Arnold - ASP]

> companies like checkpoint (they might have been acquired - not sure)
> make/made great products for securing internet/network traffic.

Just a FYI, Check Point are still running happily;
Check Point Software Technologies
Suite 5B
Enterprise House, Vision Park
Histon,
Cambridge
Cambridgeshire
CB4 5BW
United Kingdom

T: 01223236861
T: 01223236847
W: www.checkpoint.com

I'm not pushing their products, they just happen to exhibit at an exhibition
we run the website for...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**

~~
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: Studio Error

[Philip Arnold - ASP]

> Question:  What does it mena if CF Studio 4.5.1 returns an error that
> says "Canvas can not be used for drawing"?   If anyone knows, I'd really
> appreciate it.  Thanks!

Your resources are too used up
Close some applications and try again... it's bleeding annoying

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they 
are addressed. If you have received this email in error please notify 
the system manager.
**

~~
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: IP Address blocking

[Philip Arnold - ASP]

> I have  a unique problem. I know how to keep folks from linking to my
> pages on my server, but I allow others to also post pages to my web
> servers.  Their pages contain links to places I don't want folks going to.
> So, I could prevent them from writing their pages on my server, or I
> could search out and mangle such links. However, is there yet a
> sneakier way to let them do their thing, but I make it "non-responsive"
> when it gets clicked on?  Or could I redirect it to some other site?
> What is the best way to proceed. /spe

If it's a hyper-link in the copy, then you're going to have to do some
specific code for that before it's displayed no matter what...

Here's how I'd treat it;
Either change the A HREF to something else, like AHREF (which HTML will
ignore as a tag),
Or edit the code in the HREF part of the link - the problem with this is
that it'll still look like a link, but people will get annoyed that they
can't get the link working.

I'd personally go for the first option, as that way it'll still display the
URL, but people will have to go out of their way to put it into the Address.

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**

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