Re: Cfform Problem
Patrick,
The problem is that the form is never submitted, so of course the excel
and html results pages cannot access the form variables.
There are several ways to go about this. Here's one way:
* use a regular submit button.
* use a checkbox named "excel"
* the form's action page is always the same: results.cfm
* results.cfm looks like:
cfif isDefined("Form.excel")
do Excel stuff (cfcontent, cfheader,...)
cfelse
do html stuff
/cfif
Here's another way:
* use an onsubmit handler which sets the form's action to either
excelresults.cfm or htmlresults.cfm, based on whether the excel checkbox
is checked.
-David
On Wed, 2 Aug 2000 20:57:14 -0400 "Patrick Mullins"
<[EMAIL PROTECTED]> writes:
> Hello. I'm having a problem trying to figure this one out. I want to
> have a
> way for people to decide is they want the results of a search
> displayed
> in a simple html format or an excel spreadsheet. Basically I have
> two
> pages, one that lists the data with as plain html, and one that
> generates an excel file. How can I add a check box on the submit
> form
> that allows them to choose which one they want?
>
> This is the code for the form:
>
>
>
> Excel
> Format
>
> List All Items
> ---
> Armor
> Amulets
> Weapons
> Rings
>
>
>
>
>
>
>
>
>
>
> This is the query in excelresults.cfm and htmlresults.cfm
>
>
> SELECT Count, Name, Defense, Durability, Requirements, Properties
> FROM items
> WHERE
> count = '#trim(cfform.search)#' OR
> type = '#trim(cfform.search)#'
> ORDER by type
>
>
> Funny thing is that it worked just fine before I tried adding the
> option of
> sending the search results to an excel spreadsheet. Now it tells me
> that it's bombing out when it gets to #trim(form.search). Is the
> problem with the line "location.href=""?? I read somewhere that
> passing the search through a url would not work.
>
> Any Ideas?
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Integrating with Flash
At 12:28 AM 8/3/00 -0400, you wrote: >Special thanks goes out to Schlomy Gantz and the rest of the CFUN-2K people >on a great conference. > >Schlomy made an inspiring presentation on CF integration with Macromedia >Flash. I've got a project that would definitely benefit from it. A few >questions: > >Does anyone know of any good books/resources on building Flash clips? >Are there any huge limitations to Flash integration without Generator? >Is it worth waiting for Flash 5 to come out? I was privy to a conversation about flash integration without generator last week ands the gist of the conversation was: it's a complete pain in the butt. Supposedly generator makes it much easier. Without generator it is bad bad bad. That's all I know. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More CFLOCK
At 04:27 PM 8/2/00 , you wrote: Bud, perhaps the user has 3 or 4 browser windows open, or multiple frames hitting session vars at the same time.. best regards.. >I'm still trying to decipher in my own mind why it would be so >important to lock session variables. Application variables I can >understand, because if one person changes the value, the value will >change for everyone. But what about sessions? If I have session.foo >in my application, there could be 100 people that have session.foo >set to 100 different values. How would person 1 changing the value of >session.foo affect the other 99 people? >-- Brian L. Wolfsohnhttp://www.cus.com CUS Business Systems Ft.Lauderdale,FL Software for Auctioneers (954) 565-5600 Email:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
INTEGRATION: CF & Equifax
This is a multi-part message in MIME format. --=_NextPart_000_0023_01BFFCD3.0C29FAC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone have any experience that they would like to share on = exchanging data with Equifax to validate a consumers credit as part of = an online sale? Any info is appreciated and can be sent off-list if you prefer. Thanks, Shane [EMAIL PROTECTED] [EMAIL PROTECTED] --=_NextPart_000_0023_01BFFCD3.0C29FAC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone have any experience that = they would=20 like to share on exchanging data with Equifax to validate a consumers = credit as=20 part of an online sale? Any info is appreciated and can be sent = off-list if=20 you prefer. Thanks, Shane mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] --=_NextPart_000_0023_01BFFCD3.0C29FAC0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More CFLOCK
--=_50885084==_.ALT Content-Type: text/plain; charset="us-ascii" Yes, this same thought has occured to me. I must lock Application variables and Server variables because multiple users may be executing reads and writes at the same time. But a Session variable is unique to ONE user, who is viewing ONE page at this exact moment. Why do I have to lock a Session variable that is only being accessed by ONE user at a time? At 04:27 PM 8/2/00 -0400, Bud wrote: >On 8/2/00, Zachary Bedell penned: >> >>* Locking writes without also locking all reads is completely >>useless. > >I'm still trying to decipher in my own mind why it would be so >important to lock session variables. Application variables I can >understand, because if one person changes the value, the value will >change for everyone. But what about sessions? If I have session.foo >in my application, there could be 100 people that have session.foo >set to 100 different values. How would person 1 changing the value of >session.foo affect the other 99 people? >-- > >Bud Schneehagen - Tropical Web Creations > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >ColdFusion Solutions / eCommerce Development >[EMAIL PROTECTED] >http://www.twcreations.com/ >954.721.3452 >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 --=_50885084==_.ALT Content-Type: text/html; charset="us-ascii" Yes, this same thought has occured to me. I must lock Application variables and Server variables because multiple users may be executing reads and writes at the same time. But a Session variable is unique to ONE user, who is viewing ONE page at this exact moment. Why do I have to lock a Session variable that is only being accessed by ONE user at a time? At 04:27 PM 8/2/00 -0400, Bud wrote: On 8/2/00, Zachary Bedell penned: > >* Locking writes without also locking all reads is completely >useless. I'm still trying to decipher in my own mind why it would be so important to lock session variables. Application variables I can understand, because if one person changes the value, the value will change for everyone. But what about sessions? If I have session.foo in my application, there could be 100 people that have session.foo set to 100 different values. How would person 1 changing the value of session.foo affect the other 99 people? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/" eudora="autourl">http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk" eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com/" eudora="autourl">http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 --=_50885084==_.ALT-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Integrating with Flash
Special thanks goes out to Schlomy Gantz and the rest of the CFUN-2K people on a great conference. Schlomy made an inspiring presentation on CF integration with Macromedia Flash. I've got a project that would definitely benefit from it. A few questions: Does anyone know of any good books/resources on building Flash clips? Are there any huge limitations to Flash integration without Generator? Is it worth waiting for Flash 5 to come out? Thanks! Norman Elton -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Paging query results
--=_50606103==_.ALT
Content-Type: text/plain; charset="us-ascii"
Apparently, this is not necessary.
Queries are cached by name *and* the exact SQL. So different WHERE clauses will cache
separately.
At 09:50 AM 8/2/00 -0700, Scott Weikert wrote:
>Well... say you've got some sort of unique identifier for that user - be it
>a GUID, or an ID that you generate, etc. that is assigned to that user in
>some fashion (client variable, cookie, etc). Grab all or part of that ID and
>use it in your query name, like "query123abc" for one guy and "query456def"
>for the next. This way the queries don't overwrite each other when two or
>more people hit the same page (though they may have different 'WHERE'
>statements based on various choices they made to get to that page). And you
>set up these queries to be cached for a short time so they don't get nailed
>each time, but don't hang around terribly long either.
>
>Here's how I do it -
>
>
>
>Say "UserID" is '123abc', you'd end up with "QueryName123abc".
>
>CACHEDWITHIN="whatever you set">
>
>Later when you want to reference the query, use the same method. I've found,
>however, that sometimes you have to remove the quotes INSIDE the Evaluate()
>function, a la 'Evaluate(QueryName)'. I use this method in an app I'm
>working on. Depending on a particular variable setting, I grab the contents
>of one of a series of pre-generated queries (tucked into Application
>variables, as I use them all the time and they don't change). All the names
>of the queries are a string plus a number (the value of the variable in
>question). I use to packetize the query results - and in this case,
>I have to use 'Evaluate(Queryname)' as opposed to 'Evaluate("QueryName")'.
>
>Hope that helps!
>--Scott
>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, August 02, 2000 4:38 AM
>> To: [EMAIL PROTECTED]
>> Subject: RE: Paging query results
>>
>>
>> Could someone explain this please.
>>
>> best, paul
>>
>> At 03:02 PM 8/1/00 -0700, you wrote:
>> >Perhaps use a dynamically-generated
>> >query name so that two people hitting the page at the same time won't
>> >overwrite each other's query results.
>>
>> --
>>
>> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>> To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
>s/cf_talk or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 Fax 1.212.679.8032
--=_50606103==_.ALT
Content-Type: text/html; charset="us-ascii"
Apparently, this is not necessary.
Queries are cached by name *and* the exact SQL. So different WHERE
clauses will cache separately.
At 09:50 AM 8/2/00 -0700, Scott Weikert wrote:
Well... say you've got some sort of unique
identifier for that user - be it
a GUID, or an ID that you generate, etc. that is assigned to that user
in
some fashion (client variable, cookie, etc). Grab all or part of that ID
and
use it in your query name, like "query123abc" for one guy and
"query456def"
for the next. This way the queries don't overwrite each other when two
or
more people hit the same page (though they may have different
'WHERE'
statements based on various choices they made to get to that page). And
you
set up these queries to be cached for a short time so they don't get
nailed
each time, but don't hang around terribly long either.
Here's how I do it -
Say "UserID" is '123abc', you'd end up with
"QueryName123abc".
Later when you want to reference the query, use the same method. I've
found,
however, that sometimes you have to remove the quotes INSIDE the
Evaluate()
function, a la 'Evaluate(QueryName)'. I use this method in an app
I'm
working on. Depending on a particular variable setting, I grab the
contents
of one of a series of pre-generated queries (tucked into
Application
variables, as I use them all the time and they don't change). All the
names
of the queries are a string plus a number (the value of the variable
in
question). I use to packetize the query results - and in
this case,
I have to use 'Evaluate(Queryname)' as opposed to
'Evaluate("QueryName")'.
Hope that helps!
--Scott
> -Original Message-
> From: [EMAIL PROTECTED]
[mailto:[EMA
RE: Paging query results
--=_50487748==_.ALT Content-Type: text/plain; charset="us-ascii" No, I'm pretty sure that is incorrect. Using MAXROWS on the Query will limit the number of rows retrieved from the database, which will cut off the list of results. Queries do not have a STARTROW. To show a page at a time I must use STARTROW and MAXROWS on the At 04:40 PM 8/2/00 +0100, Anthony Geoghegan wrote: >|I am using STARTROW and MAXROWS to display one page at a time, >|and calling the same page with different arguments to change >|the page I am displaying... BUT this reexecutes the query each >|time. This query searches through a large database and takes a >|little time. This is a pretty inefficient way to do it (I think). > >Make sure you use maxrows on the cfquery tag, to limit the query to your >maxrows cfoutput size. >Also A verity search will probably produce a quicker response then a >standard select statement. > >Regards, >Anthony Geoghegan >Lead Developer >Ireland Film and Television Net >26 South Frederick Street >Dublin 2 >Ireland >Tel: +353 1 671 3664 >Fax: +353 1 671 0763 >Web: www.iftn.ie www.wow.ie >mailto:[EMAIL PROTECTED] > >NOTICE: >This communication is confidential. The copyright in this communication >belongs to Ireland Film & Television Net (IFTN) or a third party. > >If you are not the intended recipient of this communication please delete >and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. >If you are the intended recipient of this communication you should not copy, >disclose or distribute this communication without the authority of IFTN. > >Any views expressed in this communication are those of the individual sender >except where the sender specifically states those are of view of IFTN. > >Except as required by law IFTN does not represent, warrant, and/guarantee >that the integrity of this communication has been maintained or that the >communication is free of virus, interception or interference. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 --=_50487748==_.ALT Content-Type: text/html; charset="us-ascii" No, I'm pretty sure that is incorrect. Using MAXROWS on the Query will limit the number of rows retrieved from the database, which will cut off the list of results. Queries do not have a STARTROW. To show a page at a time I must use STARTROW and MAXROWS on theAt 04:40 PM 8/2/00 +0100, Anthony Geoghegan wrote: |I am using STARTROW and MAXROWS to display one page at a time, |and calling the same page with different arguments to change |the page I am displaying... BUT this reexecutes the query each |time. This query searches through a large database and takes a |little time. This is a pretty inefficient way to do it (I think). Make sure you use maxrows on the cfquery tag, to limit the query to your maxrows cfoutput size. Also A verity search will probably produce a quicker response then a standard select statement. Regards, Anthony Geoghegan Lead Developer Ireland Film and Television Net 26 South Frederick Street Dublin 2 Ireland Tel: +353 1 671 3664 Fax: +353 1 671 0763 Web: http://www.iftn.ie/" eudora="autourl">www.iftn.ie http://www.wow.ie/" eudora="autourl">www.wow.ie mailto:[EMAIL PROTECTED]" eudora="autourl">mailto:[EMAIL PROTECTED] NOTICE: This communication is confidential. The copyright in this communication belongs to Ireland Film & Television Net (IFTN) or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of IFTN. Any views expressed in this communication are those of the individual sender except where the sender specifically states those are of view of IFTN. Except as required by law IFTN does not represent, warrant, and/guarantee that the integrity of this communication has been maintained or that the communication is free of virus, interception or interference. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk" eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
tags on IE Vs Netscape
hi all, To run the application in netscape is becoming problem for me bcos, the tags , etc.., never work on netscape, but i donno what to replace instead of these. how to overcome this. Is there any resource where i can find some discrimination between netscape and IE about such tags. can anybody help me in this. thanx in advance. regards nagesh -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Distributing a CF Website Application on CD Rom Can it be achieved ??
I guess you could that, if you had all your users load CFSERVER on thier PC's. I dont think CF is meant for that, you might as well save time looking at Director or Authorware.. Joe - Original Message - From: "AustralianAccommodation.com Pty. Ltd." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 11:26 PM Subject: Distributing a CF Website Application on CD Rom Can it be achieved ?? > This is a multi-part message in MIME format. > > --=_NextPart_000_00C6_01BFFD4E.604D0540 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Just wondering whether it is possible to have cold fusion set up in such = > a way that the cf application I have designed can be distributed via a = > cd rom=20 > > > Kind Regards > > Claude Raiola (Director) > AustralianAccommodation.com Pty. Ltd. > Website: www.AustralianAccommodation.com > Email: [EMAIL PROTECTED] > > --=_NextPart_000_00C6_01BFFD4E.604D0540 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > > > > Just wondering whether it is possible = > to have cold=20 > fusion set up in such a way that the cf application I have designed can = > be=20 > distributed via a cd rom > > > Kind Regards > > Claude Raiola=20 > (Director)AustralianAccommodation.com Pty. Ltd.Website: href=3D"http://www.AustralianAccommodation.com">www.AustralianAccommodati= > on.comEmail:=20 > href=3D"mailto:[EMAIL PROTECTED]">Director@AustralianA= > ccommodation.com > > --=_NextPart_000_00C6_01BFFD4E.604D0540-- > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Distributing a CF Website Application on CD Rom Can it be achieved ??
This is a multi-part message in MIME format. --=_NextPart_000_00C6_01BFFD4E.604D0540 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just wondering whether it is possible to have cold fusion set up in such = a way that the cf application I have designed can be distributed via a = cd rom=20 Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] --=_NextPart_000_00C6_01BFFD4E.604D0540 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Just wondering whether it is possible = to have cold=20 fusion set up in such a way that the cf application I have designed can = be=20 distributed via a cd rom Kind Regards Claude Raiola=20 (Director)AustralianAccommodation.com Pty. Ltd.Website: http://www.AustralianAccommodation.com">www.AustralianAccommodati= on.comEmail:=20 mailto:[EMAIL PROTECTED]">Director@AustralianA= ccommodation.com --=_NextPart_000_00C6_01BFFD4E.604D0540-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Studio tips
Color coding your tags in Cold Fusion can be pretty cool. For instance, on my machine, any comments have a light grey background with black type. In Options>Settings>Color Coding. Double click on the type of file (for instance HTML/CFM) that you want to color code tags for. Pretty cool. - Original Message - From: "Phil Labonte" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 9:29 PM Subject: Studio tips > I am looking for any ColdFusion Studio 4.5 tips and tricks. > > We are giving a small presentation at the Ottawa ColdFusion User Group > Meeting this Tuesday and I am looking for anything you can send. > > Things like keyboard shortcuts, things people do to make coding a little > easier. Some tricks that people who use Studio to code every once in a > while might not know. > > Any help would be greatly appreciated. > > Thanks! > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: prevent users from quitting
-> I have a user/product registration process which takes several steps. -> Incomplete date occurs if a user quits the process at any point -> (by closing -> the browser, etc), which is a problem. One solution might be to -> collect all -> the information from each step (into a structure or arrays), and -> do the sql -> inserts at the very end. -> -> Is there another way to do this? Is there a javascript command -> that would -> tell the cf server that the browser has been closed, and allow -> the program -> to 'rollback' the incomplete data? -> -> Thanks ahead of time. -> Andrew Kopelman Even if there is JavaScript solution, I think doing the inserts at the end makes the most sense, as well as wrapping a transaction around all of your database inserts, updates and deletes for the registration. That way you are never getting incomplete or orphaned data in your DB. -- Dan O'Keefe TriPoint Technologies [EMAIL PROTECTED] 954.501.3113 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Specific CF Calls that Crash CF?
I found a simple way to "crash" CF.. just include a file in itself.. or an endless loop. I think that uses up all available resources until cf can't function anymore! For example: in header.cfm --- ... ... -- Al >I was wondering if there are specific CF calls that crash CF 4.51. We are >running CF 4.51, IIS 4.0, SQL 7.0 on a Dual P-3 with 1 GB of RAM. One of >our teams had an application running on the box that was bullet proof and >never crashed the CF Service. We were running 4.5, when another team put >an application on the box, and now the CF Service crashes about 1 or 2 >times a day, at which time we updated to 4.51 and the problem still >persists. Mind you, these are not huge applications, but they are relied >upon. Are there some specific CF Calls that might be crashing the Service? >I also thought that updating to 4.51 would eliminate these problems. Is >there still something buggy in 4.51. > >Vance Duke >Cold Fusion Application Developer >469-357-4729 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Security gotchas with dynamic SQL statements?
It looks to me like a malicious user could stick damned near anything in there, unfortunately. If you're only going to put a single condition in there, I reckon the easiest way to solve the problem would be to strip all spaces out of their string. In this case you'd get the following: Good case: BaseWhere: "ShortDesc = LongDesc" Executed query: SELECT SKU,DeptID,ShortDesc,LongDesc FROM Products WHERE ShortDesc=LongDesc AND DeptID = #Attributes.DeptID# AND ProductSKU = '#Attributes.ProductSKU#' This would execute fine. Bad case: BaseWhere: "1=1; drop table products; select * from products where 1=1" Executed query: SELECT SKU,DeptID,ShortDesc,LongDesc FROM Products WHERE 1=1;droptableproducts;select*fromproductswhere1=1 AND DeptID = #Attributes.DeptID# AND ProductSKU = '#Attributes.ProductSKU#' This would have an SQL error, not drop the products table. You might want to tweak it. Also consider that their statements might contain single quotes, and you may have to use PreserveSingleQuotes in your CF. David Cummins Seth Petry-Johnson wrote: > > This is a multi-part message in MIME format. > > --=_NextPart_000_00C1_01BFFBFD.799EA140 > Content-Type: text/plain; > charset="Windows-1252" > Content-Transfer-Encoding: 7bit > > List, > > I have a query "module" (custom tag) that supports a user-defined "base > WHERE clause" as a parameter. The query takes a number of pre-defined > parameters that it uses to build a WHERE clause, but the "base where" allows > the implementers of the query to tweak the results a bit. I'm worried about > the potential for abuse, since in at least one instance this query will > receive the base where clause data from the querystring or form data. What > do I need to look out for to ensure that malicious users can not embed > dangerous SQL statements into the FORM or URL data? > > Here's how it works on the page in question (unnecessary > parameters/statements have been removed for brevity): > > > > > > > > > > > BaseWhere="#URL.BaseWhere#" > DeptID="#URL.DeptID#" > ProductSKU="#URL.ProductSKU#"> > > the resulting SQL statement looks a bit like this: > > SELECT SKU,DeptID,ShortDesc,LongDesc > FROM Products > WHERE > > #Attributes.BaseWhere# AND > > DeptID = #Attributes.DeptID# > AND ProductSKU = '#Attributes.ProductSKU#' > > > I don't know enough advanced SQL to know if this allows a malicious user > could embed dangerous statements into the WHERE clause or not. Anyone have > any pointers? > > Regards, > Seth Petry-Johnson > Argo Enterprise and Associates > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio tips
I found this one in Junes CFDJ in an article by Charles Arehart, for creating a quick JavaScript block. Thanks Charles (also for the WAP presentation at CFUN-2K). type scriptj, then press ctrl-j and you get this: Dan O'Keefe -Original Message- From: Phil Labonte [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 8:30 PM To: [EMAIL PROTECTED] Subject: Studio tips I am looking for any ColdFusion Studio 4.5 tips and tricks. We are giving a small presentation at the Ottawa ColdFusion User Group Meeting this Tuesday and I am looking for anything you can send. Things like keyboard shortcuts, things people do to make coding a little easier. Some tricks that people who use Studio to code every once in a while might not know. Any help would be greatly appreciated. Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: import a csv file
If you're looking to pull the info into a query, I'd use either Nate Weiss' CFX_CSVtoQuery or my own CFX_DelimToQuery tags. They're MUCH faster and more efficient than doing this by HTTP. Michael J. Sheldon http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 14:07 To: [EMAIL PROTECTED] Subject: import a csv file What is the best way to tackle the import of a csv file. Unlikely to exceed 300 records 15 fields each record. Initially appending it to an existing Access table. Should I use the CFX_http tag? The file will be uploaded to the server at a fixed time each day. All tips and suggestions appreciated. TIA Gordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio tips
> I am looking for any ColdFusion Studio 4.5 tips and tricks. > > We are giving a small presentation at the Ottawa ColdFusion User Group > Meeting this Tuesday and I am looking for anything you can send. > > Things like keyboard shortcuts, things people do to make coding a little > easier. Some tricks that people who use Studio to code every once in a > while might not know. One of the neatest things is mapping key strokes to snippets (some may be dups not sure). My favorite snippets are: CTRL + ALT + Q CTRL + SHIFT + O '' CTRL + ALT + ' CTRL + ALT + A CTRL + SHIFT + V HTH, Duane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Studio tips
I am looking for any ColdFusion Studio 4.5 tips and tricks. We are giving a small presentation at the Ottawa ColdFusion User Group Meeting this Tuesday and I am looking for anything you can send. Things like keyboard shortcuts, things people do to make coding a little easier. Some tricks that people who use Studio to code every once in a while might not know. Any help would be greatly appreciated. Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More CFLOCK
> Well from what I have read so far as it pertains to reading > variables in the memory, it's ok to not lock them. You don't > want to get overzealous with locking, it does have an impact > on performace. What is the summattion with CFLOCK? I am doing > a presentation at the CFUG in Orlando Thursday at 7 pm at > the IT Research building (a shameless plug I know) and I > think I have it down pretty good I would just like to know > what the rest of the community agrees on. Some of the things > I have summed up are: > > CFLOCK should be used on writes of session,server, and > application variables CFLOCK should be used on reads of CFX_Tags > (though I just saw that so I am not sure about that) > Locking should not be initiated at server level as it will > severly impede performance Reading memory variables is ok as > long as you are sure that the write to them has been locked > > ANything else to add? I'd disagree about your statement that reads of memory variables shouldn't be locked, for various reasons mentioned here previously. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: prevent users from quitting
can you set client variables for his? - Original Message - From: "andrew kopelman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 2:27 PM Subject: prevent users from quitting > I have a user/product registration process which takes several steps. > Incomplete date occurs if a user quits the process at any point (by closing > the browser, etc), which is a problem. One solution might be to collect all > the information from each step (into a structure or arrays), and do the sql > inserts at the very end. > > Is there another way to do this? Is there a javascript command that would > tell the cf server that the browser has been closed, and allow the program > to 'rollback' the incomplete data? > > Thanks ahead of time. > Andrew Kopelman > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Cfform Problem
Hello. I'm having a problem trying to figure this one out. I want to have a way for people to decide is they want the results of a search displayed in a simple html format or an excel spreadsheet. Basically I have two pages, one that lists the data with as plain html, and one that generates an excel file. How can I add a check box on the submit form that allows them to choose which one they want? This is the code for the form: Excel Format List All Items --- Armor Amulets Weapons Rings This is the query in excelresults.cfm and htmlresults.cfm SELECT Count, Name, Defense, Durability, Requirements, Properties FROM items WHERE count = '#trim(cfform.search)#' OR type = '#trim(cfform.search)#' ORDER by type Funny thing is that it worked just fine before I tried adding the option of sending the search results to an excel spreadsheet. Now it tells me that it's bombing out when it gets to #trim(form.search). Is the problem with the line "location.href=""?? I read somewhere that passing the search through a url would not work. Any Ideas? Thanks, Patrick Mullins -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Good Datasource Gone Bad?
Hi Folks, I've been having a problem lately, and I wanted to run it past this list to see if anyone has any ideas. I've been doing some work that involves a remote site using a small MS Access database. Every now and then I get a problem where specific ColdFusion templates that used to load fine suddenly just hang the server, and it always seems to coincide with times when I have recently changed and reuploaded the database using FTP Explorer. When the problem occurs I can usually narrow it down to one query that doesn't work. Most recently it was a relatively big query, but nothing that should hang the server and furthermore, the same thing doesn't seem to be happening on my local version of the site. The site is not launched yet, only 2 or 3 people access it at the moment. Also, I am not the administrator of the server (its a site hosting company) so I don't have any control over the configuration or easy access to the logs. Thanks for any ideas. Eron -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: XML / XSL
Cary, It is an Allaire KB: http://www.allaire.com/handlers/index.cfm?ID=14244&Method=Full Also, you may want to check here: http://www.sys-con.com/xml/archives/0102/gassner/index.html dave At 08:28 AM 8/2/00 -0700, you wrote: >What KB article would that be? I searched xml, xsl and lotus and found >nothing like what you mentioned. > >Cary > >At 09:13 AM 8/2/2000 -0400, you wrote: >>Doug, >> >>I'm just getting started in XML/XSL with CF. I've looked at the KB >>article from Allaire on it and have downloaded the Lotus XML parser. >> >>One question I have is how the set the Class Path. The Lotus parser >>documentation isn't really clear on it. It seems like there is a place in >>the CF administrator but there must be another place to do it. Anybody's >>help would be appreciated. >> >>I'm looking to both read XML into WDDX and also convert WDDX into XML via XSL. >> >>What kind of things are you doing with XML? >> >>dave > >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > --- dave fauth [EMAIL PROTECTED] "The opinions expressed here are my own and not those of DOMAIN technologies, inc." -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: javascript question
>any idea why this doesn't load credcard.cfm? >onClick="document.credcard.action=credcard.cfm;document.credcard.submit();"> Yeah, you have to put javascript literal strings inside quotes otherwise javascript interprets it as a variable. Try this: Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: anchors in IE
Try putting the achor at the end of the URL, like this: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Error 500
I had 2 problems I can remember. post method to a page that doesn't allow script processing (use get instead) When I attempt to use method=post in a CFHTTP call, and use a CFHTTPPARAM type=formfield, the server throws a 500 internal server error, with NO indication of what the problem is, either on screen, in the logs, or in the event viewer. this only happens on CF 4.01. try patching, or upgrading. At 03:58 PM 8/2/2000 -0700, Chapman, Katrina wrote: >Yes it's running. > >--K > > > -Original Message- > > From: Heather R. Moll [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, August 02, 2000 12:54 PM > > To: [EMAIL PROTECTED] > > Subject: Re: HTTP Error 500 > > > > Is your Personal Web Server on? > > I know it sounds dumb, but I made the mistake before of trying to view a > > site, and forgetting to turn the pws on. > > > > - Original Message - > > From: Chapman, Katrina <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Wednesday, August 02, 2000 11:42 AM > > Subject: HTTP Error 500 > > > > > > > I'm getting error's trying to get CF pages to run on my local machine. > > I > > > get this error, > > > The page cannot be displayed > > > There is a problem with the page you are trying to reach and it cannot > > be > > > displayed. > > > Every page I attempt to access has this problem. Even the docs and > > cfide. > > > Anyone have any ideas? > > > TIA, > > > --K > > > > > > > > -- > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > -- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. !j! The mark of mediocrity is searching for the precedent. !jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI BIGWORDS.com worker#2 .r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFIF statement problem
Shouldn't you have pounds around 'variable.user' in your WHERE clause? Or will CF assume that if you scope the variable? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 8:37 PM > To: [EMAIL PROTECTED] > Subject: CFIF statement problem > > > Hi again, > > First, thank you so much to Bill & Dana for your advice. I > was able to fix > those things you pointed out to me. I feel good that you > didn't say "your > approach is entirely wrong." LOL > > But now I'm getting a new error. A person comes to our site at > http://www.marksport.com/testsandbox/registerform.cfm and > enters their email > address. I want to query the database (which is built and > accessible but has > absolutely no data in it at the moment) and send them to > http://www.marksport.com/testsandbox/updateform.cfm if their > email exists in > the database OR > http://www.marksport.com/testsandbox/shortform.cfm if it does > not. To that end I have this and query (among other things)... > > > > > DATASOURCE="marksport" > DBTYPE="ODBC" > USERNAME="xxx" > PASSWORD="xxx"> > SELECT uid, email > FROM user_info_basic > WHERE email = variable.user > > > > > > > > > HELP It goes to updateform.cfm, which, of course, cannot > parse correctly > because there is nothing in the database to parse. I've > tried different > things before writing this email. Can't seem to find a setup > that works. > > Thank you in advance for your help. > > :-) > Oriole > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfhttp problem
Hi Everyone, I am having trouble with cfhttp. I am trying to execute a page and the page just hangs for about 2 minutes then displays 'connection failure'. Maybe its my set up here that is the problem but it does not make any sense to me. Here is the code: http://www.excite.com" resolveurl="yes"> #CFHTTP.FileContent# thanks for your help Sal Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Multiple actions from a Form?
Dave, the x and y attributes get set when you click on the image and are the x and y co-ordinates of the image. I would like to see the code you have to be able to achieve this, cause I can't see how your suggestion will work. -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: 02 August 2000 20:30 To: [EMAIL PROTECTED] Subject: Re: Multiple actions from a Form? As far as I remember, you need to set the x,y values for each image button in order to be able to pass their names as action attributes to your action page. So something like, should hopefully do what you want. OR of course you can use Philip's suggestion with Javascript but be careful of non Javascript enabled visitors. Dave Wilson Internet Technology Manager, BizNet Solutions Co-Founder CFUG Ireland http://www.cfug.ie 224, Lisburn Road Belfast BT9 6GE Tel: 02890 225 776 Fax: 02890 223 223 web: http://www.biznet-solutions.com email: [EMAIL PROTECTED] - Original Message - From: Philip Arnold - ASP <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 10:09 AM Subject: RE: Multiple actions from a Form? > > Ok I sought of use this method to make actions against a form, the problem > > is that with this form the client wants images as the buttons. > > Now I am well > > aware of the way things work with images, except I haven't been able to > > figure out how to send an action type to the action page Sort > > of Fusebox in a way:-) > > > > Ok here is the problem I face, I have two buttons and if I use the input > > type=submit I can use the name=action to decide what action needs to take > > place. However for some reason the input type=image does not work > > this way, > > can someone help me out here. I know I did this once before on a site, but > > as I have done so many sites I can't find the code quick enough:-) > > Why not do it with JavaScript? > Don't have the buttons as type="image", but have them as real images, and > have an onClick method which calls a JS function to set the Action > > Have the default Action as a hidden field, then just set > document.myForm.Action="whatever" in the function > > As long as the user has JS enabled, then it'll work fine > > Philip Arnold > 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. > ** > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Multiple actions from a Form?
Thanks Phillip, can send me off list the sample code I need to do that. I am still not upto speed on Javascript but I can debug it, strange huh! Now that you mention it, I think this is how I got around it last time Now if only I had the name of that site I wrote it on:-) -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 02 August 2000 19:10 To: [EMAIL PROTECTED] Subject: RE: Multiple actions from a Form? > Ok I sought of use this method to make actions against a form, the problem > is that with this form the client wants images as the buttons. > Now I am well > aware of the way things work with images, except I haven't been able to > figure out how to send an action type to the action page Sort > of Fusebox in a way:-) > > Ok here is the problem I face, I have two buttons and if I use the input > type=submit I can use the name=action to decide what action needs to take > place. However for some reason the input type=image does not work > this way, > can someone help me out here. I know I did this once before on a site, but > as I have done so many sites I can't find the code quick enough:-) Why not do it with JavaScript? Don't have the buttons as type="image", but have them as real images, and have an onClick method which calls a JS function to set the Action Have the default Action as a hidden field, then just set document.myForm.Action="whatever" in the function As long as the user has JS enabled, then it'll work fine Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTTP Authorization
Take a pill... someone else on this thread mentioned an ISAPI DLL so I figured I would mention it... Sheesh Howie - Original Message - From: Rick Osborne <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 4:52 PM Subject: RE: HTTP Authorization > Please Don't confuse the issue. :) Your product, and I quote, "is an > add-on DLL". The original post (long since snipped) was asking how to do > *HTTP-header-based authentication using straight CF code (specifically > the CFHEADER tag)*. > > So, once again, lemme repeat: You cannot do this with IIS. You will need a > DLL, such as iAuth or whatever. (But wait, I've said that before, haven't > I?) > > Sheesh. :) > > -Rick (who is beginning to sound like a broken record) > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 11:06 AM > To: [EMAIL PROTECTED] > Subject: Re: HTTP Authorization > > > You can do authentication with IIS or WebSite using ColdFusion. We have > products that allow you to do that - called iAuth. More information is at > www.coolfusion.com (look under the Products section - there will be a few > products called "inFusion Authenticator") > > Regards, > > Howie Hamlin > -- > inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 > www.CoolFusion.com > > Please vote for iMS in the Most Innovative category here: > *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** > > Check out inFusion Mail Server - the world's most configurable email server > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Multiple Select List
On 8/2/00, Olson, Kelly penned: >[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in = >query expression 'EmployeeID=3D107,24'. I'm not sure if that 3D is part of the value you inputted from the form or mime output from your e-mail. But, if your EmployeeID field is an integer, you'll get that error if any non numeric characters are in there, including the comma. Not that that matters, you can't query with a list like that anyway. You'll need to loop through it. WHERE EmployeeID = #mylist# or 0=1 Which would basically write: WHERE EmployeeID = 107 or EmployeeID = 24 or 0=1 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: more questions from an obvious newbie
Before calculating any line prices, set some variable
to zero. Add each line price to this variable as you
calculate the line price...your variable will then
equal the sum of the line prices.
--- Jon Tillman <[EMAIL PROTECTED]> wrote:
> I need a bit more help (suprise).
>
> I am wondering how I would go about adding together
> the output of a dynamic
> number of the following statement:
>
#DollarFormat("#ListGetAt(ShoppingCart_Qty,ListFind(ShoppingCart_Product,productId))#"*"#productPrice#")#
>
> Basically, the above is the unit price * the
> quantity, giving a line price. I
> now need to take all of the line prices and create a
> total of them. Any ideas?
>
> --
> This Email is 100% Virus Free! How do I know?
> Because no Microsoft products were used to
> generate it!
>
>
:::
> Jon Tillman
> LINUX USER: #141163
> ICQ: 4015362
> [EMAIL PROTECTED]
> http://tillman.freehosting.net
>
:::
>
--
> Archives:
>
http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to
> [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
javascript question
any idea why this doesn't load credcard.cfm? -- ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Doug N email me about imail
It's really easy. Just write to users.lst in the appropriate IMAIL/thedomain directory and put each e-mail address on its own line. I can see if I can dig up the code, but basically you CFQUERY the data set just on e-mail address, CFLOOP over it creating a variable with myVar=myVAR & #chr(13)# and then CFFILE WRITE to the directory with this variable (which is just a list of the items with carriage returns). One note. You can use CFFILE append in a loop but this does a LOT of I/O and isn't recommended. I only bring it up here because I've seen it done (and tried it myself) as a shortcut. It's fast and easy to code, but the I/O is a killer. --Doug -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 10:39 AM To: '[EMAIL PROTECTED]' Subject: Doug N email me about imail I remember you mentioning how you use CF to write to a txt file so Imail can send out a newsletter. Is there anyway you could send me that code? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Error 500
GOt to have CF server and a web server running on that machine... --- Kelly Matthews Internet Development Coordinator AAAE 703.578.2509 [EMAIL PROTECTED] http://www.airportnet.org --- > -Original Message- > From: Chapman, Katrina [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 12:42 PM > To: '[EMAIL PROTECTED]' > Subject: HTTP Error 500 > > I'm getting error's trying to get CF pages to run on my local machine. I > get this error, > The page cannot be displayed > There is a problem with the page you are trying to reach and it cannot be > displayed. > Every page I attempt to access has this problem. Even the docs and cfide. > Anyone have any ideas? > TIA, > --K > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Error 500
Yes it's running. --K > -Original Message- > From: Heather R. Moll [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 12:54 PM > To: [EMAIL PROTECTED] > Subject: Re: HTTP Error 500 > > Is your Personal Web Server on? > I know it sounds dumb, but I made the mistake before of trying to view a > site, and forgetting to turn the pws on. > > - Original Message - > From: Chapman, Katrina <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 02, 2000 11:42 AM > Subject: HTTP Error 500 > > > > I'm getting error's trying to get CF pages to run on my local machine. > I > > get this error, > > The page cannot be displayed > > There is a problem with the page you are trying to reach and it cannot > be > > displayed. > > Every page I attempt to access has this problem. Even the docs and > cfide. > > Anyone have any ideas? > > TIA, > > --K > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFHTTP Help
As far as I know CFHTTP will wait for the remote page to finish, unless you specify TIMEOUT. Tell me, is this Perl page on the same server? If so, you could simply use CFEXECUTE and call the Perl script directly. That is if your using CF 4.5. === Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) Allaire Certified Instructor and Member of Team Allaire Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Neil H. [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 3:23 PM > To: [EMAIL PROTECTED] > Subject: CFHTTP Help > > > I have a question. I am running a slow perl page by sending a CFHTTP > request. The perl script write a file. My code then opens the file with > cffile but it can't find it. I think CF isn't waiting for the CFHTTP to > complete before trying to find the file? I there a way to force > CF to wait > for the Perl script to finish? > > Thanks, > > Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Advanced Security user directory issue...
Ray -- we had this problem when we converted our userDirectory to Oracle. For us, we solved it by going into the CFAdmin, and setting the userDirectory password under the advanced secutiry section. hope this helps. At 08:19 AM 8/2/00 -0400, you wrote: >I'm trying to help a coworker over the phone so I don't have access to the >files in question, but her problem seems to be this. We have a userdirectory >set up in SQL Server. The ODBC control panel can correctly connect to it >with no problems. We even setup the DSN in ColdFusion Admin and had no >problems talking to it. > >However, when we try to authenticate, we get a failure. Looking at the log >files, it appears as if Netegrity tries to connect to the DSN w/o passing in >a username and password. Has anyone seen this before? On my local machine, I >had no problems with Netegrity speaking to SQL Server. > >=== >Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com) >Allaire Certified Instructor and Member of Team Allaire > >Email : [EMAIL PROTECTED] >ICQ UIN : 3679482 > >"My ally is the Force, and a powerful ally it is." - Yoda > > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. == Jeff Tapper [EMAIL PROTECTED] Team Manager / Lead Applications Architect http://www.gtriad.com G. Triad == -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
anchors in IE
I'm passing an anchor in an onload URL so that a long list doesn't have to be scrolled: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [OT] IE 5.5 and CSS
I noticed similar in IE 5.5. I haven't had time to investigate it yet,
but I've heard two things about IE 5.5. One, the implementation of CSS is
more compliant with established standards. Two, it's much buggier that IE
5. So, either the CSS that used to work, doesn't anymore because it's
been fixed (!) or else you're seeing the results of some bug.
Jim
-Original Message-
From: Robert M. Saxon, Jr. <[EMAIL PROTECTED]>
To: Cf-Talk <[EMAIL PROTECTED]>
Date: Wednesday, August 02, 2000 2:47 PM
Subject: [OT] IE 5.5 and CSS
>I just downloaded IE 5.5 and I noticed that the CSS that I used on my CF
>page is not working. The CSS file is linked in the header, and the
>references in the HTML are all to classes.
>
>For example:
>#txtHeadline#
>
><-in style.css->
>.cover-headline {font-family:Arial,Helvetica,sans-serif;
>font-style:normal;
>font-size:11pt;
>font-weight:bold;
>}
>
>The page looked fine in IE 5. It also works in Netscape 4.7.
>
>Does anyone know what I need to do to fix this?
>
>Thanks in advance,
>
>Rob
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[ANN] Kansas City CFUG Meeting features JRrun - next Tuesday, August 8...
KCFusion, the Kansas City Cold Fusion Users Group, has a special meeting in the works for next Tuesday night, August 8th, at 7pm at the usual place (see http://kcfusion.org for the map). A presentation of Allaire JRun, an application server based on the Java 2 Enterprise Edition (J2EE) specifications will be given by developer Tom Reilly. Tom is a Principal Developer at Allaire Corporation, where he is part of the JRun development team. He was a member of the Live Software team that developed JRun and was responsible for the design and implementation of the JRun JSP implementation. Allaire Corp.'s JRun is one of the most widely adopted engines for developing and deploying server-side Java applications that use Java Servlets and JavaServer Pages (JSP). The first commercially available product to fully support the JSP 1.0 specification, JRun enables more than 80,000 developers worldwide to add the functionality of server-side Java to their existing Web servers, including Microsoft's IIS, Netscape's Enterprise Server, Apache, and more. Join us at the KCFusion meeting to see what solutions JRun can provide for your business! -Introduction to JRun 3.0 by developer Tom Reilly -JSP debugging with JRun Studio -Profiling servlets with the interceptor -Load balancing/failover with ClusterCats -Q&A bring your coding questions We look forward to seeing you. As always, admission is FREE, and we've got lots of giveaways this time courtesy of Allaire, including Allaire t-shirts, JRun t-shirts, and a drawing for a FREE COPY OF JRUN! We're also going to be providing limited quantities of PIZZA and DRINKS starting at 6:45 pm, so come early and bring your appetites! All the Best, Your KCFusion Directors Ron Allen Hornbaker, Bryan Laplante and Robin Greenhagen mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
import a csv file
What is the best way to tackle the import of a csv file. Unlikely to exceed 300 records 15 fields each record. Initially appending it to an existing Access table. Should I use the CFX_http tag? The file will be uploaded to the server at a fixed time each day. All tips and suggestions appreciated. TIA Gordon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF statement problem
On 8/2/00, [EMAIL PROTECTED] penned: > > Better put some ## around variable user. And you'll need to cfset user and variable.user or you'll get an error, or just set the value of cookie to #user#. > > > > > Try and then the rest. testregistered.email is defined, it's just empty if there are no records. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
prevent users from quitting
I have a user/product registration process which takes several steps. Incomplete date occurs if a user quits the process at any point (by closing the browser, etc), which is a problem. One solution might be to collect all the information from each step (into a structure or arrays), and do the sql inserts at the very end. Is there another way to do this? Is there a javascript command that would tell the cf server that the browser has been closed, and allow the program to 'rollback' the incomplete data? Thanks ahead of time. Andrew Kopelman Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date fields
Do you get an error message? What is it? --K > -Original Message- > From: Ray, James A [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 11:06 AM > To: [EMAIL PROTECTED] > Subject: Date fields > > I have an oracle table that is defined has a date field in it. When I > allow > the user to enter information and they enter the date and save it, > everything goes great. > > The problem is, when the user saves the record without entering the date. > I > get an error. Before I save the data I do the following. > > > (I suspect the problem is > here) > >"dd-mmm-yy")#> > > > How do I save a date field without putting in a real date? I know I have > missed something in my reading. > > Thank you > > Jim Ray > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Error 500
Yes and Yes. Sorry I didn't give specifics. IIS 4 NT 4 SP5 CF 4.51 We checked that the services are running. We re-installed. The next step is trash the drive and start over. This isn't the first problem I've had with this machine. --K > -Original Message- > From: Olive, Christopher M Mr NMR > [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 12:44 PM > To: '[EMAIL PROTECTED]' > Subject: RE: HTTP Error 500 > > is the CF server running? is IIS? > > Chris Olive, > DOEHRS Website Administrator > > -Original Message- > From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 12:42 PM > To: '[EMAIL PROTECTED]' > Subject: HTTP Error 500 > > > I'm getting error's trying to get CF pages to run on my local machine. I > get this error, > The page cannot be displayed > There is a problem with the page you are trying to reach and it cannot be > displayed. > Every page I attempt to access has this problem. Even the docs and cfide. > Anyone have any ideas? > TIA, > --K > > -- > -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF statement problem
Try SELECT uid, email FROM user_info_basic WHERE email = variable.user Jacob At 03:36 PM 8/2/00 -0400, you wrote: >But now I'm getting a new error. A person comes to our site at >http://www.marksport.com/testsandbox/registerform.cfm and enters their email >address. I want to query the database (which is built and accessible but has >absolutely no data in it at the moment) and send them to >http://www.marksport.com/testsandbox/updateform.cfm if their email exists in >the database OR http://www.marksport.com/testsandbox/shortform.cfm if it does >not. To that end I have this and query (among other things)... > > > > > DATASOURCE="marksport" > DBTYPE="ODBC" > USERNAME="xxx" > PASSWORD="xxx"> >SELECT uid, email > FROM user_info_basic > WHERE email = variable.user > > > > > > > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hacker on a budget (Solicitation)
On Wed, 02 Aug 2000, Paul Ihrig spewed forth into the void: > Jon. > Becoming a PAC rat is not a hard thing to achieve. > > With a little help from corporate America, > you should have no trouble in filling you living space with computers of > yesteryear that will rattle happy to perform. > > My suggestion it to just start calling the large business around you. > We have a 3 year cycle here at work & still manage to toss out 10 or so > computers a month. > > We have some guy, like yourself come buy every now & then to pick up the > stuff. well good for him, and for me, by proxy :) > > -Original Message- > From: Jon Tillman [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 2:50 AM > To: [EMAIL PROTECTED] > Subject: OT: Hacker on a budget (Solicitation) > > Hey folks, > I am making a proposition here that may or may not interest you. I am an > aspiring hacker (per the New Hackers Dictionary definition, not the lame > media > electronic-trespass definition) who has a strong interest in Linux and > networking. To further my studies, I want to build a private network to > learn > about networking, and security on. The rub is that I have almost no budget > to > speak of. So I am asking for donations. I do not accept money. I only want > old > hardware you are not using anymore, and/or old manuals on just about any > computer topic. If you have a bunch of crud sitting around that you don't > need/want/use, I would like to have it. If you are interested, please > contact > me via email so I can arrange to pick it up (if you are within reasonable > distance from Little River, SC, USA) or pay postage/shipping. Any help at > all > would be appreciated. I would also like information on other ways/places I > could go about securing hardware from in this manner. > Thanks for your time. > > PS: Nothing I receive from this will ever be sold for profit, I just want > stuff > for my own use > > -- > ::: > Jon Tillman > LINUX USER: #141163 > ICQ: 4015362 > [EMAIL PROTECTED] > http://tillman.freehosting.net > ::: > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! (2)
There is also the DISTINCTROW keyword. As it sounds, this will select entire distinct rows. SELECT DISTINCTROW Column1, Column2, etc -Rick -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 11:10 AM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You can only select ONE distinct column. SELECT DISTINCT Column1, Column2, etc Will give the distinct Column1 values. Dave - Original Message - From: "aslam bajaria" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 10:30 AM Subject: RE: Help! (2) select distinct(*) gives an error. Also select distinct(column1, column2,...,LastColumn) gives an error. Can someone tell me how to avoid this error. Appreciate. A.B. --- Johan Coens <[EMAIL PROTECTED]> wrote: > Maybe: > > Step 1: SELECT DISTINCT ... (all colums), name it > qryAllRecords > Step 2: DELETE FROM , now you're table is > empty > Step 3: LOOP over qryAllRecords and insert them into > the database. > > Make sure you have a backup and use CFTRANSACTION! > > Best Regards, > Johan Coens > > -Original Message- > From: aslam bajaria [mailto:[EMAIL PROTECTED]] > Sent: woensdag 2 augustus 2000 6:30 > To: [EMAIL PROTECTED] > Subject: Help! > > > Hello All, > There is a very seriuous problem I am facing. Please > help. The problem is as follows: > > Somehow I have created duplicate records in SQL > Server > 7.0 table. > > I have to remove the duplicate the records. It all > happened because there is no primary key when the > record was created. > > If it were a few records, I could have manually > deleted them. Now the records are in thousands. Can > someone suggest me a code that would check for > duplicate values in a table and delete them. > > Please help. > > A.B. > > __ > Do You Yahoo!? > Kick off your party with Yahoo! Invites. > http://invites.yahoo.com/ > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or > send a message to [EMAIL PROTECTED] > with 'unsubscribe' in > the body. > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Authorization
Please Don't confuse the issue. :) Your product, and I quote, "is an add-on DLL". The original post (long since snipped) was asking how to do *HTTP-header-based authentication using straight CF code (specifically the CFHEADER tag)*. So, once again, lemme repeat: You cannot do this with IIS. You will need a DLL, such as iAuth or whatever. (But wait, I've said that before, haven't I?) Sheesh. :) -Rick (who is beginning to sound like a broken record) -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 11:06 AM To: [EMAIL PROTECTED] Subject: Re: HTTP Authorization You can do authentication with IIS or WebSite using ColdFusion. We have products that allow you to do that - called iAuth. More information is at www.coolfusion.com (look under the Products section - there will be a few products called "inFusion Authenticator") Regards, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 www.CoolFusion.com Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** Check out inFusion Mail Server - the world's most configurable email server -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF & Dual Processors
At 10:24 AM 8/2/00 -0700, you wrote: >All of our machines here run CF on dual CPUs. We had the some problem last >year when we were using Access for our database. When we switched to SQL, >it stopped. > >Setup a performance monitor and monitor cold fusion activity and system >memory. > >Do you have anything else running on this machine? What type of webserver? Access DB and IIS4.0 . . . Jim Mixon - CEO APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . [EMAIL PROTECTED] http://www.apt.net/ 8405 NW 53 St. Miami, FL 33166 305-418-4111 FAX (305) 418-4111 press 7 and SEND! powered by Cold Fusion 4.01 . . . . feel the force! CF Hosting Now Available . . . . ! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF & Dual Processors
On 8/2/00, Chris Michl penned: >Is your DB Access by chance? If so, there are problems running that >configuration...I don't happen to have any references at my fingertips, >however. I'm running a Dual PIII 550 and have a ton of Access DBs on the server and never have a problem. 4.01 -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: More CFLOCK
On 8/2/00, Zachary Bedell penned: > >* Locking writes without also locking all reads is completely >useless. I'm still trying to decipher in my own mind why it would be so important to lock session variables. Application variables I can understand, because if one person changes the value, the value will change for everyone. But what about sessions? If I have session.foo in my application, there could be 100 people that have session.foo set to 100 different values. How would person 1 changing the value of session.foo affect the other 99 people? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF & Dual Processors
At 08:40 AM 8/2/00 -0700, you wrote: >Does this machine have less than 512 mb? I have had less than optimum >results with 4.51 on machines with less than 256 mb per processor. What >you describe is in line with the problems I have seen. the machine has 512Meg ram and we are using ACCESS. But have been using access with the single CPU cfg's for a good while with few if any problems . . . I suppose there may be issues with dual cpu's and access tho . . . Jim Mixon - CEO APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . [EMAIL PROTECTED] http://www.apt.net/ 8405 NW 53 St. Miami, FL 33166 305-418-4111 FAX (305) 418-4111 press 7 and SEND! powered by Cold Fusion 4.01 . . . . feel the force! CF Hosting Now Available . . . . ! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date fields
1) Can't you just require a date be entered for the form to go through? 2) If not, why not create a bogus/dummy date and insert that? Some date far into the future or way in the past that will never get entered in normal usage... in that way you could do queries looking for said date to pull up records that users haven't entered legit dates on... > -Original Message- > From: Ray, James A [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 7:06 PM > To: [EMAIL PROTECTED] > Subject: Date fields > > > I have an oracle table that is defined has a date field in > it. When I allow > the user to enter information and they enter the date and save it, > everything goes great. > > The problem is, when the user saves the record without > entering the date. I > get an error. Before I save the data I do the following. > > > (I suspect the > problem is > here) > >"dd-mmm-yy")#> > > > How do I save a date field without putting in a real date? I > know I have > missed something in my reading. > > Thank you > > Jim Ray > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date fields
You can either make the date a mandatory field or default the date to today's date. ~Mark -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 2:06 PM To: [EMAIL PROTECTED] Subject: Date fields I have an oracle table that is defined has a date field in it. When I allow the user to enter information and they enter the date and save it, everything goes great. The problem is, when the user saves the record without entering the date. I get an error. Before I save the data I do the following. (I suspect the problem is here) How do I save a date field without putting in a real date? I know I have missed something in my reading. Thank you Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Oddball CFILE question
Hey everyone, I am hacking up some code for a project, and I've found that I have a script that must run tag once per day. Now, I know I can use , but was wondering... Since, if you have a tag that looks like: If you can treat the cfdirectory as a query, is there any way to cache the results, a la 'cachedwithin' for cfqueries? Dana -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTTP Authorization
You can do authentication with IIS or WebSite using ColdFusion. We have products that allow you to do that - called iAuth. More information is at www.coolfusion.com (look under the Products section - there will be a few products called "inFusion Authenticator") Regards, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 www.CoolFusion.com Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** Check out inFusion Mail Server - the world's most configurable email server - Original Message - From: Stanislav Maximov <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 8:04 AM Subject: HTTP Authorization > Do anybody have any idea how to make HTTP authorization with CF? > I've tried something like this with no success (assuming user will enter > "user"/"password" as the credentials: > --- > > success! > > > > > --- > Please tell me were am I wrong? > > TIA > > stas@ > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! (2)
left my on my other server. :) Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 2:42 PM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You'll get all of the column 2's that are associated with each distinct column 1. What's wrong? Can't you read my mind? Dave - Original Message - From: "Olive, Christopher M Mr NMR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 11:28 AM Subject: RE: Help! (2) that's not technically correct. if you SELECT DISTINCT Column1, Column2 you will get the distinct combinations of Column1, Column2. Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 11:10 AM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You can only select ONE distinct column. SELECT DISTINCT Column1, Column2, etc Will give the distinct Column1 values. Dave - Original Message - From: "aslam bajaria" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 10:30 AM Subject: RE: Help! (2) select distinct(*) gives an error. Also select distinct(column1, column2,...,LastColumn) gives an error. Can someone tell me how to avoid this error. Appreciate. A.B. --- Johan Coens <[EMAIL PROTECTED]> wrote: > Maybe: > > Step 1: SELECT DISTINCT ... (all colums), name it > qryAllRecords > Step 2: DELETE FROM , now you're table is > empty > Step 3: LOOP over qryAllRecords and insert them into > the database. > > Make sure you have a backup and use CFTRANSACTION! > > Best Regards, > Johan Coens > > -Original Message- > From: aslam bajaria [mailto:[EMAIL PROTECTED]] > Sent: woensdag 2 augustus 2000 6:30 > To: [EMAIL PROTECTED] > Subject: Help! > > > Hello All, > There is a very seriuous problem I am facing. Please > help. The problem is as follows: > > Somehow I have created duplicate records in SQL > Server > 7.0 table. > > I have to remove the duplicate the records. It all > happened because there is no primary key when the > record was created. > > If it were a few records, I could have manually > deleted them. Now the records are in thousands. Can > someone suggest me a code that would check for > duplicate values in a table and delete them. > > Please help. > > A.B. > > __ > Do You Yahoo!? > Kick off your party with Yahoo! Invites. > http://invites.yahoo.com/ > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or > send a message to [EMAIL PROTECTED] > with 'unsubscribe' in > the body. > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: HTTP Error 500
Is your Personal Web Server on? I know it sounds dumb, but I made the mistake before of trying to view a site, and forgetting to turn the pws on. - Original Message - From: Chapman, Katrina <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 11:42 AM Subject: HTTP Error 500 > I'm getting error's trying to get CF pages to run on my local machine. I > get this error, > The page cannot be displayed > There is a problem with the page you are trying to reach and it cannot be > displayed. > Every page I attempt to access has this problem. Even the docs and cfide. > Anyone have any ideas? > TIA, > --K > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: HTTP Error 500
is the CF server running? is IIS? Chris Olive, DOEHRS Website Administrator -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 12:42 PM To: '[EMAIL PROTECTED]' Subject: HTTP Error 500 I'm getting error's trying to get CF pages to run on my local machine. I get this error, The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Every page I attempt to access has this problem. Even the docs and cfide. Anyone have any ideas? TIA, --K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFIF statement problem
Hi again, First, thank you so much to Bill & Dana for your advice. I was able to fix those things you pointed out to me. I feel good that you didn't say "your approach is entirely wrong." LOL But now I'm getting a new error. A person comes to our site at http://www.marksport.com/testsandbox/registerform.cfm and enters their email address. I want to query the database (which is built and accessible but has absolutely no data in it at the moment) and send them to http://www.marksport.com/testsandbox/updateform.cfm if their email exists in the database OR http://www.marksport.com/testsandbox/shortform.cfm if it does not. To that end I have this and query (among other things)... SELECT uid, email FROM user_info_basic WHERE email = variable.user HELP It goes to updateform.cfm, which, of course, cannot parse correctly because there is nothing in the database to parse. I've tried different things before writing this email. Can't seem to find a setup that works. Thank you in advance for your help. :-) Oriole -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFHTTP Help
I have a question. I am running a slow perl page by sending a CFHTTP request. The perl script write a file. My code then opens the file with cffile but it can't find it. I think CF isn't waiting for the CFHTTP to complete before trying to find the file? I there a way to force CF to wait for the Perl script to finish? Thanks, Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Getting file attributes *before* upload: Was (Re: Help! (2))
Well, you learn something new every day. I was 'taught' to put the () in. Now for a CF question ... Is there a tag for, or does anyone know of a way to find out the attritbutes of a file *before* cf_file uploads it? I'm going to be having people constantly send me many, many 3-10 meg files and don't want to waste the bandwidth uploading the stuff if the person is just going to have to do it again because some attributes aren't quite right. I've found one that does exactly what I need, but it does it after the file has been uploaded. Anyone? Thanks. Todd Ashworth - Original Message - From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 12:41 PM Subject: RE: Help! (2) | Yup, kill the brackets - it was originally posted (by Johan) to point out | that you should put all of the column names in | | select distinct * | will work fine -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hacker on a budget (Solicitation)
Jon. Becoming a PAC rat is not a hard thing to achieve. With a little help from corporate America, you should have no trouble in filling you living space with computers of yesteryear that will rattle happy to perform. My suggestion it to just start calling the large business around you. We have a 3 year cycle here at work & still manage to toss out 10 or so computers a month. We have some guy, like yourself come buy every now & then to pick up the stuff. -Original Message- From: Jon Tillman [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 2:50 AM To: [EMAIL PROTECTED] Subject:OT: Hacker on a budget (Solicitation) Hey folks, I am making a proposition here that may or may not interest you. I am an aspiring hacker (per the New Hackers Dictionary definition, not the lame media electronic-trespass definition) who has a strong interest in Linux and networking. To further my studies, I want to build a private network to learn about networking, and security on. The rub is that I have almost no budget to speak of. So I am asking for donations. I do not accept money. I only want old hardware you are not using anymore, and/or old manuals on just about any computer topic. If you have a bunch of crud sitting around that you don't need/want/use, I would like to have it. If you are interested, please contact me via email so I can arrange to pick it up (if you are within reasonable distance from Little River, SC, USA) or pay postage/shipping. Any help at all would be appreciated. I would also like information on other ways/places I could go about securing hardware from in this manner. Thanks for your time. PS: Nothing I receive from this will ever be sold for profit, I just want stuff for my own use -- ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Multiple Select List
This is a multi-part message in MIME format. --=_NextPart_000_003B_01BFFC97.66BBD3F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am creating a select list from some data. What I want to do is be = able to select multiple names out of the list and print/display the next = page several times based on the names, one per record. Basically = print/Display multiple records. I keep getting an error as follows. It does't like 2 + employee ID's. = What options are avaialbe for doing this. ODBC Error Code =3D 37000 (Syntax error or access violation)=20 [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in = query expression 'EmployeeID=3D107,24'.=20 The error occurred while processing an element with a general identifier = of (CFQUERY), occupying document position (44:1) to (44:46). --=_NextPart_000_003B_01BFFC97.66BBD3F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am creating a select list from = some=20 data. What I want to do is be able to select multiple names out of = the=20 list and print/display the next page several times based on the names, = one per=20 record. Basically print/Display multiple records. I keep getting an error as follows. It does't like 2 + employee = ID's. =20 What options are avaialbe for doing this. ODBC Error Code =3D 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in = query=20 expression 'EmployeeID=3D107,24'.=20 The error occurred while processing an element with a general = identifier of=20 (CFQUERY), occupying document position (44:1) to (44:46). --=_NextPart_000_003B_01BFFC97.66BBD3F0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[OT] IE 5.5 and CSS
I just downloaded IE 5.5 and I noticed that the CSS that I used on my CF
page is not working. The CSS file is linked in the header, and the
references in the HTML are all to classes.
For example:
#txtHeadline#
<-in style.css->
.cover-headline {font-family:Arial,Helvetica,sans-serif;
font-style:normal;
font-size:11pt;
font-weight:bold;
}
The page looked fine in IE 5. It also works in Netscape 4.7.
Does anyone know what I need to do to fix this?
Thanks in advance,
Rob
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Other File Types
You don't do it in the administrator. What web server are you running? Is it IIS? --K > -Original Message- > From: DJMixes.Com [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 10:27 AM > To: [EMAIL PROTECTED] > Subject: Re: Other File Types > > Do you mean that you want CF to parse other types of files for CF code? > If so, I believe it is in the registry. CAn't remember where. Just do a > search for *.cfm > > Derek > > > "Kent A. Orso" <[EMAIL PROTECTED]> wrote in message > news:<002101bffc75$55004f00$[EMAIL PROTECTED]>... > > I know someone already touched on this, but I can't seem to find the > email > > so I'll ask again. Where in Cold Fusion Administrator, do I add other > files > > types that I want the Cold Fusion server to recognize beyond *.cfm > types? > > (i.e. - *.html, *.jtml) > > > > Thanks in Advance, > > K. Orso > > > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Thank you
Good Goda commercial web site you can actually understand in under a minute! Plain English, even. You rock, dude. Jeff Epstein Web Producer -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 12:11 PM To: [EMAIL PROTECTED] Subject: Thank you I wanted to give the whole list a big thank you for all of the support I have been given over the past 4 months. This past week, we announced our company, Turbo Squid, Inc. at the SIGGRAPH conference in New Orleans. Because of all of the support I received from the list, both actual and moral, we were able to demo a working copy of our product. If you are interested, take a look at our website, http://www.turbosquid.com, and see what we have done. I want to say thanks again to every one. Russel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: shopping carts
You might want a structure containing an array of structures. The outer structure would be useful for any information that you need that is order specific (as opposed to item specific). That structure then contains an array of items in the cart, and each item is represented by a structure (containing product number, description, price, quantity, etc). --- Ben -Original Message- From: Daslweb - Greg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 1:38 PM To: [EMAIL PROTECTED] Subject: Re: shopping carts Use an array because they are dynamic with cold fusion. For example if you set row 1 through ten with information and then delete row 8, row 9 becomes row 8 and row 10 becomes row 9 - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "Cf-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 7:12 AM Subject: shopping carts > What kind of data structure would you recommend storing a shopping cart as? > > I have set one up as a structure Session.Cart which contains a set of > structures identified by ProductID as the Keys, where each of these > structures contains the basic info about each product ordered (name, price, > quantity). I'm storing more than just the ProductID and Quantity in order to > reduce database load. Is this a good way of doing it, or would an array or a > list or whatever be better. There must be one best way I should think. What > do people consider that to be?? > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Filling up: Ecommerce Development with ColdFusion Seminar
Email [EMAIL PROTECTED] with a request for as many $195.00 passes as you need for your company/CFUG/etc. We look forward to seeing you there! At 10:20 AM 8/2/00 -0400, you wrote: >Hey ... how do I get the 'Special Price Pass'??? > > >Tim Bahlke, CIFO >thinkcreate.com >p. 336.230.0575 >f. 336.230.0083 > > > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * *Publishers of the CommerceBlocks line of modular development tools* * for ColdFusion * * * * Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866Fax:770-242-0410* * * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help! (2)
This is a multi-part message in MIME format. --=_NextPart_000_0019_01BFFCB1.51F1B830 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Re: Help! (2)This depends on the database. Access will allow you to: select distinct field1, field2, field3 from sometable which will result in a number of rows less than the total number of rows = in the table, in the result set. Dc - Original Message -=20 From: Todd Ashworth=20 To: [EMAIL PROTECTED]=20 Sent: Wednesday, August 02, 2000 16:31 Subject: Re: Help! (2) You can only select 1 distinct field.=20 Pick 1 field that you want to be distinct and=20 SELECT DISTINCT(that_field), other_field, other_field2, etc FROM = table=20 Be careful which field you select distinctly.=20 Todd Ashworth=20 - Original Message -=20 From: "aslam bajaria" <[EMAIL PROTECTED]>=20 To: <[EMAIL PROTECTED]>=20 Sent: Wednesday, August 02, 2000 10:30 AM=20 Subject: RE: Help! (2)=20 | select distinct(*) gives an error.=20 | Also=20 | select distinct(column1, column2,...,LastColumn) gives=20 | an error.=20 |=20 | Can someone tell me how to avoid this error.=20 |=20 | Appreciate.=20 | A.B.=20 |=20 |=20 |=20 | --- Johan Coens <[EMAIL PROTECTED]> wrote:=20 | > Maybe:=20 | >=20 | > Step 1: SELECT DISTINCT ... (all colums), name it=20 | > qryAllRecords=20 | > Step 2: DELETE FROM , now you're table is=20 | > empty=20 | > Step 3: LOOP over qryAllRecords and insert them into=20 | > the database.=20 | >=20 | > Make sure you have a backup and use CFTRANSACTION!=20 | >=20 | > Best Regards,=20 | > Johan Coens=20 | >=20 | > -Original Message-=20 | > From: aslam bajaria [mailto:[EMAIL PROTECTED]]=20 | > Sent: woensdag 2 augustus 2000 6:30=20 | > To: [EMAIL PROTECTED]=20 | > Subject: Help!=20 | >=20 | >=20 | > Hello All,=20 | > There is a very seriuous problem I am facing. Please=20 | > help. The problem is as follows:=20 | >=20 | > Somehow I have created duplicate records in SQL=20 | > Server=20 | > 7.0 table.=20 | >=20 | > I have to remove the duplicate the records. It all=20 | > happened because there is no primary key when the=20 | > record was created.=20 | >=20 | > If it were a few records, I could have manually=20 | > deleted them. Now the records are in thousands. Can=20 | > someone suggest me a code that would check for=20 | > duplicate values in a table and delete them.=20 | >=20 | > Please help.=20 | >=20 | > A.B.=20 | >=20 | > __=20 | > Do You Yahoo!?=20 | > Kick off your party with Yahoo! Invites.=20 | > http://invites.yahoo.com/=20 | >=20 | = -= -=20 --=20 | > --=20 | > Archives:=20 | >=20 | http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 | > To Unsubscribe visit=20 | >=20 | = http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta= lk=20 | > or=20 | > send a message to [EMAIL PROTECTED]=20 | > with 'unsubscribe' in=20 | > the body.=20 | >=20 | >=20 | = -= -=20 =20 | > Archives:=20 | >=20 | http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 | > To Unsubscribe visit=20 | >=20 | = http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta= lk=20 | > or send a message to=20 | > [EMAIL PROTECTED] with 'unsubscribe'=20 | > in the body.=20 |=20 |=20 | __=20 | Do You Yahoo!?=20 | Kick off your party with Yahoo! Invites.=20 | http://invites.yahoo.com/=20 | = -= -=20 =20 | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 | To Unsubscribe visit=20 = http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta= lk or=20 send a message to [EMAIL PROTECTED] with 'unsubscribe' = in=20 the body.=20 |=20 = -= -=20 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/=20 To Unsubscribe visit = http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta= lk or send a message to [EMAIL PROTECTED] with = 'unsubscribe' in the body. --=_NextPart_000_0019_01BFFCB1.51F1B830 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Re: Help! (2) This depends on the database. = Access will=20 allow you to: select distinct field1, field2, field3 = from=20 sometable which will result in a number of rows = less than the=20 total number of rows in the table, in the result set. Dc - Original Message - From:=20 mailto:[EMAIL PR
Re: Help! (2)
You'll get all of the column 2's that are associated with each distinct column 1. What's wrong? Can't you read my mind? Dave - Original Message - From: "Olive, Christopher M Mr NMR" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 11:28 AM Subject: RE: Help! (2) that's not technically correct. if you SELECT DISTINCT Column1, Column2 you will get the distinct combinations of Column1, Column2. Chris Olive, DOEHRS Website Administrator -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 11:10 AM To: [EMAIL PROTECTED] Subject: Re: Help! (2) You can only select ONE distinct column. SELECT DISTINCT Column1, Column2, etc Will give the distinct Column1 values. Dave - Original Message - From: "aslam bajaria" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 10:30 AM Subject: RE: Help! (2) select distinct(*) gives an error. Also select distinct(column1, column2,...,LastColumn) gives an error. Can someone tell me how to avoid this error. Appreciate. A.B. --- Johan Coens <[EMAIL PROTECTED]> wrote: > Maybe: > > Step 1: SELECT DISTINCT ... (all colums), name it > qryAllRecords > Step 2: DELETE FROM , now you're table is > empty > Step 3: LOOP over qryAllRecords and insert them into > the database. > > Make sure you have a backup and use CFTRANSACTION! > > Best Regards, > Johan Coens > > -Original Message- > From: aslam bajaria [mailto:[EMAIL PROTECTED]] > Sent: woensdag 2 augustus 2000 6:30 > To: [EMAIL PROTECTED] > Subject: Help! > > > Hello All, > There is a very seriuous problem I am facing. Please > help. The problem is as follows: > > Somehow I have created duplicate records in SQL > Server > 7.0 table. > > I have to remove the duplicate the records. It all > happened because there is no primary key when the > record was created. > > If it were a few records, I could have manually > deleted them. Now the records are in thousands. Can > someone suggest me a code that would check for > duplicate values in a table and delete them. > > Please help. > > A.B. > > __ > Do You Yahoo!? > Kick off your party with Yahoo! Invites. > http://invites.yahoo.com/ > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or > send a message to [EMAIL PROTECTED] > with 'unsubscribe' in > the body. > > -- > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to > [EMAIL PROTECTED] with 'unsubscribe' > in the body. __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Nested Recursive Custom Tags AttributeCollection Nightmare
Thanks Steve, I'll let you know when my brain untangles :-) As always I'm looking forward to your next movie. Chris - Original Message - From: Steve Martin <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 4:12 PM Subject: RE: Nested Recursive Custom Tags AttributeCollection Nightmare > Is used when associating child tags with a parent tag. For > example: > > [some code] > > > > > Here we are associating the tag CF_MenuItem with the parent tag CF_Menu > which means we can use the two tags in the following manner: > > > > > > And the Menu.cfm (aka CF_Menu) template will have access to the attributes > that were passed into the child tags (CF_MenuItem) as an array of > structures, e.g. > data[1].label would contain the value "label 1" > data[2].url would contain the value "URL 2" > and so on. > > > ATTRIBUTECOLLECTION is a handy way of passing multiple attributes into a tag > there the number of attributes may vary. For example: > > would be equivalent to: > > > > > > BE WARNED: The way attributecollection works has changed dramatically > between 4.01 and 4.5: > You can mix and match attribute collection with normal attributes and where > a 'real' attribute has the same name as one of the keys that is being passed > in through attributecollection, the 'real' attribute takes precedence in > 4.01. In 4.5 it would appear that the key held within attributecollection > takes precedence over the 'real'attribute. Go figure. > > Hope this makes sense > > Steve > > > -Original Message- > > From: Chris Hayes [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 02, 2000 15:12 > > To: [EMAIL PROTECTED] > > Subject: Nested Recursive Custom Tags AttributeCollection Nightmare > > > > > > I have a tag which is going to call itself many times over. > > > > I want to be able to create a structure, call the custom tag and be left > > with a modified structure at the end of it. > > > > > > > > > > In the module "acustomtag.cfm": > > Update the stucture with new values and under certain conditions: > > > AttributeCollection="#menuStructure#"> > > > > This will creat a many-tiered hierachy of nests of the same tag. > > > > Upon return to the calling script I should have the modified structure > > "myStructure". > > > > I have read the manual and it left my brain tangled. Can somebody please > > clarify the syntax and usage of "AttributeCollection" and "CFAssociate" in > > order to get this monster working... > > > > cheers in advance > > > > Chris > > > > -- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF & Dual Processors
A couple of references I quickly looked up: http://support.microsoft.com/support/kb/articles/Q178/6/50.ASP and http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=282578 - Original Message - From: "Dave Wilson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 10:30 AM Subject: Re: CF & Dual Processors > What problems? We've never had any problems with dual processor servers and > Access, except for the obvious scalability and speed issues associated with > Access of course. > > Dave Wilson > Internet Technology Manager, > BizNet Solutions > > > Co-Founder CFUG Ireland > http://www.cfug.ie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help!
I would feel much safer about it if he put the results of your qryAllRecords into a new table before deleting. But maybe that's just because I'm paranoid about the word delete. At 08:35 AM 8/2/00 +0200, you wrote: >Maybe: > >Step 1: SELECT DISTINCT ... (all colums), name it qryAllRecords >Step 2: DELETE FROM , now you're table is empty >Step 3: LOOP over qryAllRecords and insert them into the database. > >Make sure you have a backup and use CFTRANSACTION! > >Best Regards, >Johan Coens > >-Original Message- >From: aslam bajaria [mailto:[EMAIL PROTECTED]] >Sent: woensdag 2 augustus 2000 6:30 >To: [EMAIL PROTECTED] >Subject: Help! > > >Hello All, >There is a very seriuous problem I am facing. Please >help. The problem is as follows: > >Somehow I have created duplicate records in SQL Server >7.0 table. > >I have to remove the duplicate the records. It all >happened because there is no primary key when the >record was created. > >If it were a few records, I could have manually >deleted them. Now the records are in thousands. Can >someone suggest me a code that would check for >duplicate values in a table and delete them. > >Please help. > >A.B. > >__ >Do You Yahoo!? >Kick off your party with Yahoo! Invites. >http://invites.yahoo.com/ > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Determining Datasources (CFX_DATASOURCES)
HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\DataSources Is where you will find a list of all your datasources. Dunno if this is useful. Knocked up a quick registry navigation template that did the job for me. Enjoy! Adam Reynolds > -- > From: Reynolds, Adam[SMTP:[EMAIL PROTECTED]] > Sent: 02 August 2000 15:36 > To: '[EMAIL PROTECTED]' > Subject: RE: Determining Datasources (CFX_DATASOURCES) > > Thanks...will give it a go. > Adam Reynolds > > > -- > > From: Rick Osborne[SMTP:[EMAIL PROTECTED]] > > Sent: 02 August 2000 15:08 > > To: [EMAIL PROTECTED] > > Subject:RE: Determining Datasources (CFX_DATASOURCES) > > > > Heh. Do what the CF Administrator does: open up the registry and read > > them > > directly from there. > > > > -Rick > > > > -Original Message- > > From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, August 02, 2000 9:38 AM > > To: '[EMAIL PROTECTED]' > > Subject: RE: Determining Datasources (CFX_DATASOURCES) > > > > > > This provides a list of ODBC sources available to CF Server as well as > any > > other apps connecting to the server. > > > > What I am looking for is a way of listing the currently available Native > > Datasources from within the CF server. > > Adam > > > > > -- > > > From: David Shadovitz[SMTP:[EMAIL PROTECTED]] > > > Sent: 01 August 2000 14:44 > > > To: [EMAIL PROTECTED] > > > Subject: Re: Determining Datasources (CFX_DATASOURCES) > > > > > > No, I meant OracleDBInfo; see > > > > > > http://devex.allaire.com/developer/gallery/info.cfm?ID=D33BAD72-59F8-11D4 > > > -83E000508B94F85A&method=Full > > > > > > But a quick look at the code shows that it first checks the Registry > for > > > ODBC data sources and then uses the Oracle data dictionary. > > > > > > -David > > > > > > On Tue, 1 Aug 2000 10:04:33 +0100 "Reynolds, Adam" > > > <[EMAIL PROTECTED]> writes: > > > > Do you mean CFX_DATASOURCES? This works, but only returns the ODBC > > > > datasources. > > > > > > > > It was written by Ben Forta. If Ben reads this, have you done an > > > > update that > > > > also returns the Native databases set up on a server? > > > > > > > > Thanks > > > > > > > > Adam Reynolds > > > > > > > > > -- > > > > > From: David Shadovitz[SMTP:[EMAIL PROTECTED]] > > > > > Sent: 01 August 2000 04:08 > > > > > To: [EMAIL PROTECTED] > > > > > Subject: Re: Determining Datasources > > > > > > > > > > The Tag Gallery has OracleDBInfo, which uses CFREGISTRY to get at > > > > the > > > > > ODBC datasources on an NT server. > > > > > -David > > > > > > > > > > On Mon, 31 Jul 2000 16:52:16 +0100 "Reynolds, Adam" > > > > > <[EMAIL PROTECTED]> writes: > > > > > > I'm in the process of writing an Oracle User Administration (add > > > > > > > > > > delete > > > > > > users, role management etc) sub-fusebox and need to know if it > > > > is > > > > > > possible > > > > > > to automatically determine the names of the available Oracle 8 > > > > > > datasources > > > > > > that the current server has. > > > > > > YOU'RE PAYING TOO MUCH FOR THE INTERNET! > > > Juno now offers FREE Internet Access! > > > Try it today - there's no risk! For your FREE software, visit: > > > http://dl.www.juno.com/get/tagj. > > > > > > -- > > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > > or > > > send a message to [EMAIL PROTECTED] with 'unsubscribe' > > in > > > the body. > > > > > ** > > This email and any attachments are confidential and solely > > for the use of the intended recipient. They may contain > > material protected by legal professional or other privilege. > > If you are not the intended recipient or the person responsible > > for delivering to the intended recipient, you are not authorised > > to and must not disclose, copy, distribute or retain this email > > or its attachments. Although this email and its attachments > > are believed to be free of any virus or other defect, it is the > > responsibility of the recipient to ensure that they are virus free > > and no responsibility is accepted by the company for any > > loss or damage arising from receipt or use thereof. > > > > ** > > > -- > > -- > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' > in > > the body. > > > >
Date fields
I have an oracle table that is defined has a date field in it. When I allow the user to enter information and they enter the date and save it, everything goes great. The problem is, when the user saves the record without entering the date. I get an error. Before I save the data I do the following. (I suspect the problem is here) How do I save a date field without putting in a real date? I know I have missed something in my reading. Thank you Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Clustered server - keeping code insync
1) Yes, IOW there is not a dedicated network for this purpose 2) Fast but not dedicated How small have you gotten the performance hit to be? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 5:29 PM To: [EMAIL PROTECTED] Subject: RE: Clustered server - keeping code insync Are your web servers using the same NIC card to get this content from the file share that they are for their web access? Is the file share server fast and dedicated to this purpose? --Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 8:15 AM To: [EMAIL PROTECTED] Subject: RE: Clustered server - keeping code insync When I tried this the performance hit was significant, ~ 1 second per request. Have you found a way to do it that doesn't have that impact? -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 10:49 AM To: [EMAIL PROTECTED] Subject: RE: Clustered server - keeping code insync Use a central file server. - Steve -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 5:47 AM To: [cftalk] Subject: Clustered server - keeping code insync Hi all , Has anyone got any recommendations for keeping the code on several production servers in a clustered setup in sync??? Thanks ~Justin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Studio Color Bars
Thanks! best, paul At 09:37 AM 8/2/00 -0400, you wrote: >The lines happen if you click over the left-hand edge of the line, and the >colors will cycle with each click. It has something to do with Studio's >debugging features, I think, -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Complex Arrays and Structures
[Gene Kraybill] > create a large application structure to hold the configuration > settings for each customer. I've done several sets of similar systems in the past. What follows has worked for me, but I am also interested in hearing what others have done. When you are going to be using deep levels of structures/arrays/etc, I find its easiest to create shortcuts (references) to them, which makes the code a bit easier to read. Since structures are always passed by reference unless you explicitly copy them, it's also pretty efficient. For example: I also like to use the word 'This' to denote local references to objects that I'm going to be using alot. So, if you are working with a singe customer over the entire page, you could create ThisCustomer: To me, this is infinitely easier to read and remember than traipsing down the object heirarchy each time. Also, I imagine it's probably more efficient. (I've never done tests on this, tho, has anyone else?) To get to that Customer's config options, you could then use: By the way, you may already be aware of this, but you don't have to convert numbers to strings to make CF happy. Dereferencing a struct as ["1"] or [1] both work just fine. :) Also, if you have a static string for a key (you know what its name will always be) you don't have to deref it as a string. Like so: I tend to prefer doing it this way, as I come from a C/Perl background and that just seems more natural to me. :) But, each to their own. > We also need to hold the order form data, and there can be multiple forms] I'm working on a similar system this week, as a matter of fact. And yep, your idea is right: However, you need to be wary of arrays. Arrays *copy* instead of reference by default. So, if you are going to be changing data, you can't do this: I'd use that last one if you are going to be doing lots of updates to the form data. That way you aren't having to make CF walk the object tree every time you do an update. You *really* need to be conscious of which elements of your object tree are arrays and which are structures. They may be accessed the same, but since one copies and one references, you can get yourself into alot of trouble. (I fell into this trap on Monday, as a matter of fact, and about kicked myself when I figured out what I was doing.) > I've never attempted to use arrays, structs and queries to this > level of complexity, or mix and match them like this in the same > structure. Fun, eh? :) > The advantage it seems to offer is that all config data will be > held in a single structure, and it'll be easy to reference it by > customer number and loop over it when needed. Oh yeah. And when you really start using it for serious in-memory caching it will dramatically speed up your pages. I use it to eliminate as many db queries per page as possible. With OLEDB or Native access it may not matter so much, but every little bit helps. Especially if you're just doing lots and lots of reads and very few writes. > But it's also rather complex and the var references are long > and unwieldy, Try the system that I use, with the local references. I think that this will really help. It lets you think about small pieces of code (just the things that pertain to ThisCustomer or TheseItems) and not have to think about the entire object tree. > I need to figure out whether storing all this config data in > an application structure will cause memory problems. I haven't had *any* memory problems with the systems I've developed. I'm actually inclined to think that in certain cases it can actually take up less memory than hitting the db all the time. This might be rare, but unless you are storing several hundred or thousand sets of objects, it really shouldn't be an issue. You said you were doing a couple dozen? Pfft. No problem. > And how could we roughly estimate how much memory a complex > structure like this will require? I've oft wondered this myself. The closest I can do is look at the memory usage, initialize the application and load all of the data, and then look again. If there is a better way I'd love to know it. Now, let's talk about locking for a moment, since that seems to be such a hot topic of debate. However, I may be doing it wrong so I'd love to hear what others have to say. I'm not too bothered by locking, as I just do it at the most granular level that I can. That is, if I'm working on a customer, then I create a lock for just that customer: Again, for a system that is mostly reads and adds (not inserts and updates) this works wonderfully. However, you have to be wary about being too granular in a system that is constantly being updated. For example, I wouldn't want to lock on a TheseItems level in a system where the entire customer may concurrently be deleted from the system. (At which point I would be working on data that either no longer existed or wasn't relevant.) In such a case, y
cfindex error
Hi Folks, Does anyone know what this error means? Error occurred in tag CFINDEX Internal Error: Purge failed Error Code: -23 The same code worked on the development server. The production server, though, has multiple domains on "virtual servers," and I'm wondering if that has something to do with it. Thanks -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: downloading a file to users hard drive
I had need to create a csv file of user selected queries to import into Excel on the users system. I had my CF program create the file on our FTP server using unique names then just put a link with that file on the page using ftp://url.com/filename.csv it was simple and worked well in our case. The one thing this made easy was it let the user specify where to save the file. Good Luck David Green - Original Message - From: "Joel Richards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 01, 2000 2:54 PM Subject: downloading a file to users hard drive > Hello-- > I need a way to have a user download a selected file to his or her hard > drive. What is the best way to do this? > Thanks > Joel > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Tranning Materials
Does anyone have any of the tranning materials from the fast track tranning series? -Brian -/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/ Brian Thornton The Internet Design Firm 910 16th Street #810 Denver, CO 80202 phone. 303.893.6628 [EMAIL PROTECTED] www.tidf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Paging query results
Well... say you've got some sort of unique identifier for that user - be it
a GUID, or an ID that you generate, etc. that is assigned to that user in
some fashion (client variable, cookie, etc). Grab all or part of that ID and
use it in your query name, like "query123abc" for one guy and "query456def"
for the next. This way the queries don't overwrite each other when two or
more people hit the same page (though they may have different 'WHERE'
statements based on various choices they made to get to that page). And you
set up these queries to be cached for a short time so they don't get nailed
each time, but don't hang around terribly long either.
Here's how I do it -
Say "UserID" is '123abc', you'd end up with "QueryName123abc".
Later when you want to reference the query, use the same method. I've found,
however, that sometimes you have to remove the quotes INSIDE the Evaluate()
function, a la 'Evaluate(QueryName)'. I use this method in an app I'm
working on. Depending on a particular variable setting, I grab the contents
of one of a series of pre-generated queries (tucked into Application
variables, as I use them all the time and they don't change). All the names
of the queries are a string plus a number (the value of the variable in
question). I use to packetize the query results - and in this case,
I have to use 'Evaluate(Queryname)' as opposed to 'Evaluate("QueryName")'.
Hope that helps!
--Scott
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 4:38 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Paging query results
>
>
> Could someone explain this please.
>
> best, paul
>
> At 03:02 PM 8/1/00 -0700, you wrote:
> >Perhaps use a dynamically-generated
> >query name so that two people hitting the page at the same time won't
> >overwrite each other's query results.
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Doug N email me about imail
I remember you mentioning how you use CF to write to a txt file so Imail can send out a newsletter. Is there anyway you could send me that code? Robert Everland III Web Developer Dixon Ticonderoga -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SiteMinder
Thanks Erki for the reply Dana E. Johnson Sr. Web Developer CIT VTF/Technology Financing Services [EMAIL PROTECTED] (904) 620-7458 -Original Message- From: Erki Esken [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 02, 2000 9:16 AM To: [EMAIL PROTECTED] Subject: Re: SiteMinder > Anybody know what the windows NT service Siteminder is, what is > it's function this thing is periodically shutting down my server. Netegrity SiteMinder is authentication and security management engine that ColdFusion uses for Advanced Security I believe. Anyway.. Look at http://www.siteminder.com/products/siteminder.html for more info. Erki -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
HTTP Error 500
I'm getting error's trying to get CF pages to run on my local machine. I get this error, The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Every page I attempt to access has this problem. Even the docs and cfide. Anyone have any ideas? TIA, --K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Other File Types
Do you mean that you want CF to parse other types of files for CF code? If so, I believe it is in the registry. CAn't remember where. Just do a search for *.cfm Derek "Kent A. Orso" <[EMAIL PROTECTED]> wrote in message news:<002101bffc75$55004f00$[EMAIL PROTECTED]>... > I know someone already touched on this, but I can't seem to find the email > so I'll ask again. Where in Cold Fusion Administrator, do I add other files > types that I want the Cold Fusion server to recognize beyond *.cfm types? > (i.e. - *.html, *.jtml) > > Thanks in Advance, > K. Orso > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! (2)
> select distinct(*) gives an error. > Also > select distinct(column1, column2,...,LastColumn) gives > an error. > > Can someone tell me how to avoid this error. Yup, kill the brackets - it was originally posted (by Johan) to point out that you should put all of the column names in select distinct * will work fine Philip Arnold 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. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Thank you
I wanted to give the whole list a big thank you for all of the support I have been given over the past 4 months. This past week, we announced our company, Turbo Squid, Inc. at the SIGGRAPH conference in New Orleans. Because of all of the support I received from the list, both actual and moral, we were able to demo a working copy of our product. If you are interested, take a look at our website, http://www.turbosquid.com, and see what we have done. I want to say thanks again to every one. Russel -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF Hack for MS's WAS
This is a multi-part message in MIME format. --=_NextPart_000_0002_01BFFC6E.F87236A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Here's the URL2Form tag that I mentioned. I placed a call to it in the Application.cfm for load testing purposes with WAS. So far so good... Matt --=_NextPart_000_0002_01BFFC6E.F87236A0 Content-Type: application/octet-stream; name="URL2Form.cfm" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="URL2Form.cfm" =20 --=_NextPart_000_0002_01BFFC6E.F87236A0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF & Dual Processors
Does this machine have less than 512 mb? I have had less than optimum results with 4.51 on machines with less than 256 mb per processor. What you describe is in line with the problems I have seen. Cary At 10:39 AM 8/2/2000 -0400, you wrote: >Anyone heard of any special config's or any reason why CF doesn't work well >with dual processors? > >I have a dual PIII 550Mhz new server I built and at least once every two >days CF stops running correctly and I have to stop and start the CF >services. No error messages anywhere I can find related to this and this >symptom I have not seen before on the single cpu servers I had been using >to date . . . the dual processors are the only change I can see from what I >am used too and thought this may have something to do with it . . > >any input would be appreciated . . . > > >Jim Mixon - CEO >APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . >[EMAIL PROTECTED] http://www.apt.net/ >8405 NW 53 St. Miami, FL 33166 305-418-4111 >FAX (305) 418-4111 press 7 and SEND! >powered by Cold Fusion 4.01 . . . . feel the force! >CF Hosting Now Available . . . . ! >-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF & Dual Processors
All of our machines here run CF on dual CPUs. We had the some problem last year when we were using Access for our database. When we switched to SQL, it stopped. Setup a performance monitor and monitor cold fusion activity and system memory. Do you have anything else running on this machine? What type of webserver? Jacob At 10:39 AM 8/2/00 -0400, you wrote: >Anyone heard of any special config's or any reason why CF doesn't work well >with dual processors? > >I have a dual PIII 550Mhz new server I built and at least once every two >days CF stops running correctly and I have to stop and start the CF >services. No error messages anywhere I can find related to this and this >symptom I have not seen before on the single cpu servers I had been using >to date . . . the dual processors are the only change I can see from what I >am used too and thought this may have something to do with it . . > >any input would be appreciated . . . > > >Jim Mixon - CEO >APT POINT NET, Inc. "A Premiere InterNET Gateway" . . . >[EMAIL PROTECTED] http://www.apt.net/ >8405 NW 53 St. Miami, FL 33166 305-418-4111 >FAX (305) 418-4111 press 7 and SEND! >powered by Cold Fusion 4.01 . . . . feel the force! >CF Hosting Now Available . . . . ! >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: shopping carts
A session array of structures is the way to go. session.aCart[i].Bean_ID session.aCart[i].Bean_name session.aCart[i].Bean_description Should look familiar to some ppl. Steve > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 15:12 > To: Cf-Talk > Subject: shopping carts > > > What kind of data structure would you recommend storing a > shopping cart as? > > I have set one up as a structure Session.Cart which contains a set of > structures identified by ProductID as the Keys, where each of these > structures contains the basic info about each product ordered > (name, price, > quantity). I'm storing more than just the ProductID and Quantity > in order to > reduce database load. Is this a good way of doing it, or would an > array or a > list or whatever be better. There must be one best way I should > think. What > do people consider that to be?? > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Help! (2)
select distinct column1, column2,...,LastColumn > -Original Message- > From: aslam bajaria [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 02, 2000 15:31 > To: [EMAIL PROTECTED] > Subject: RE: Help! (2) > > > select distinct(*) gives an error. > Also > select distinct(column1, column2,...,LastColumn) gives > an error. > > Can someone tell me how to avoid this error. > > Appreciate. > A.B. > > > > --- Johan Coens <[EMAIL PROTECTED]> wrote: > > Maybe: > > > > Step 1: SELECT DISTINCT ... (all colums), name it > > qryAllRecords > > Step 2: DELETE FROM , now you're table is > > empty > > Step 3: LOOP over qryAllRecords and insert them into > > the database. > > > > Make sure you have a backup and use CFTRANSACTION! > > > > Best Regards, > > Johan Coens > > > > -Original Message- > > From: aslam bajaria [mailto:[EMAIL PROTECTED]] > > Sent: woensdag 2 augustus 2000 6:30 > > To: [EMAIL PROTECTED] > > Subject: Help! > > > > > > Hello All, > > There is a very seriuous problem I am facing. Please > > help. The problem is as follows: > > > > Somehow I have created duplicate records in SQL > > Server > > 7.0 table. > > > > I have to remove the duplicate the records. It all > > happened because there is no primary key when the > > record was created. > > > > If it were a few records, I could have manually > > deleted them. Now the records are in thousands. Can > > someone suggest me a code that would check for > > duplicate values in a table and delete them. > > > > Please help. > > > > A.B. > > > > __ > > Do You Yahoo!? > > Kick off your party with Yahoo! Invites. > > http://invites.yahoo.com/ > > > -- > -- > > -- > > Archives: > > > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > > or > > send a message to [EMAIL PROTECTED] > > with 'unsubscribe' in > > the body. > > > > > -- > > > Archives: > > > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > > or send a message to > > [EMAIL PROTECTED] with 'unsubscribe' > > in the body. > > > __ > Do You Yahoo!? > Kick off your party with Yahoo! Invites. > http://invites.yahoo.com/ > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help! (2)
You can only select 1 distinct field. Pick 1 field that you want to be distinct and SELECT DISTINCT(that_field), other_field, other_field2, etc FROM table Be careful which field you select distinctly. Todd Ashworth - Original Message - From: "aslam bajaria" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 02, 2000 10:30 AM Subject: RE: Help! (2) | select distinct(*) gives an error. | Also | select distinct(column1, column2,...,LastColumn) gives | an error. | | Can someone tell me how to avoid this error. | | Appreciate. | A.B. | | | | --- Johan Coens <[EMAIL PROTECTED]> wrote: | > Maybe: | > | > Step 1: SELECT DISTINCT ... (all colums), name it | > qryAllRecords | > Step 2: DELETE FROM , now you're table is | > empty | > Step 3: LOOP over qryAllRecords and insert them into | > the database. | > | > Make sure you have a backup and use CFTRANSACTION! | > | > Best Regards, | > Johan Coens | > | > -Original Message- | > From: aslam bajaria [mailto:[EMAIL PROTECTED]] | > Sent: woensdag 2 augustus 2000 6:30 | > To: [EMAIL PROTECTED] | > Subject: Help! | > | > | > Hello All, | > There is a very seriuous problem I am facing. Please | > help. The problem is as follows: | > | > Somehow I have created duplicate records in SQL | > Server | > 7.0 table. | > | > I have to remove the duplicate the records. It all | > happened because there is no primary key when the | > record was created. | > | > If it were a few records, I could have manually | > deleted them. Now the records are in thousands. Can | > someone suggest me a code that would check for | > duplicate values in a table and delete them. | > | > Please help. | > | > A.B. | > | > __ | > Do You Yahoo!? | > Kick off your party with Yahoo! Invites. | > http://invites.yahoo.com/ | > | -- -- | > -- | > Archives: | > | http://www.mail-archive.com/cf-talk@houseoffusion.com/ | > To Unsubscribe visit | > | http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk | > or | > send a message to [EMAIL PROTECTED] | > with 'unsubscribe' in | > the body. | > | > | -- | > Archives: | > | http://www.mail-archive.com/cf-talk@houseoffusion.com/ | > To Unsubscribe visit | > | http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk | > or send a message to | > [EMAIL PROTECTED] with 'unsubscribe' | > in the body. | | | __ | Do You Yahoo!? | Kick off your party with Yahoo! Invites. | http://invites.yahoo.com/ | -- | Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ | To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. | -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Paging query results
|I am using STARTROW and MAXROWS to display one page at a time, |and calling the same page with different arguments to change |the page I am displaying... BUT this reexecutes the query each |time. This query searches through a large database and takes a |little time. This is a pretty inefficient way to do it (I think). Make sure you use maxrows on the cfquery tag, to limit the query to your maxrows cfoutput size. Also A verity search will probably produce a quicker response then a standard select statement. Regards, Anthony Geoghegan Lead Developer Ireland Film and Television Net 26 South Frederick Street Dublin 2 Ireland Tel: +353 1 671 3664 Fax: +353 1 671 0763 Web: www.iftn.ie www.wow.ie mailto:[EMAIL PROTECTED] NOTICE: This communication is confidential. The copyright in this communication belongs to Ireland Film & Television Net (IFTN) or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of IFTN. Any views expressed in this communication are those of the individual sender except where the sender specifically states those are of view of IFTN. Except as required by law IFTN does not represent, warrant, and/guarantee that the integrity of this communication has been maintained or that the communication is free of virus, interception or interference. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
