RE: picking up form variables on the action page??

[Rich Wild]

> If no form variables are passed, then form.fieldnames will not be 
> defined.  IsDefined('form.fieldnames')  = False
> 
> If a checkbox exists in a form and is not checked when the form is 
> processed, then the checkbox variable will not be defined.
> IsDefined('form.CheckboxVariableName')  = False
> 
> As for a textbox with no value entered, the variable will be defined 
> but will have a value of "".
> IsDefined('form.TextboxVariableName')  = True
> TextBoxVariableName = ""



Yeah. Thought so.

Cheers Clint.

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---


--
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: netscape taking a long time to render page

[pan]

> hey guys,i've got a page here that is taking a very very long time  to 
> render in NS (after it has downloaded) i know its because of some tag 
> formating, but i cant seem to find it. all my tables check out as far as i 
> can tell.. can i get a few more sets of eyes to take a look at the html & 
> possibly show me what i've done wrong?
> 
> heres the url for the html output of the page thats giving me a problem:
> 
> http://www.yarooze.com/kitehigh/testNSproblem.cfm
> 
HTTP/1.0 404 Object Not Found

--
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: Grab image size with CFFile object attributes

[Rich Wild]

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34726E-2830-11D4-AA
9700508B94F380&method=Full

CFX_GifGD is what you need. Very very cool tag. Does mountains of stuff. A
godsend.

There are others though.

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Mark Smeets [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 25, 2000 5:45 AM
> To: [EMAIL PROTECTED]
> Subject: Grab image size with CFFile object attributes
> 
> 
> Question, you can grab a file size in a CFFile tag when you upload a 
> file/image but can you also grab the image height and width?
> 
> I could guess but I'm not entirely sure. It makes sense to 
> have something 
> like this.
> 
> Mark Smeets/stranger0/ICQ #1062196
> 
> "Mr. West, not every situation requires your patented 
> approach of shoot 
> first, shoot later, shoot some more and then when everybody's 
> dead try to 
> ask a question or two" - Wild Wild West
> 
> Other Press Webslinger *New and Improved*
> http://otherpress.douglas.bc.ca/
> 
> Official Splitting Adam Homepage
> http://www.splittingadam.com/
> 
> Over the Wall Productions and Web Designs
> http://www.solarcourt.com/
> 
> __
> ___
> Get Your Private, Free E-mail from MSN Hotmail at 
http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.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: Please hack me, others are....

[lsellers]

> Help,
>
> Last week we launch a new on line game, people seem to want the
> free trip...
> they have successfully hacked it.
>
> It's a ColdFusion/SQL7 driven site with the game in Flash. CF and
> Flash send
> security and score information back and forth.
>
> Somehow, despite not being able to play more than once, and if they do the
> players score doesn't increase until the next day. People are running up
> really high scores, like a million points when the highest
> possible cum for
> the contest until today is 500.
>
> Please take a moment and see if you can run up a score and if so, how.
>
> I'm on a few hours sleep this week on another deadline, so if this email
> isn't clear please let me know. Otherwise have fun.
>
> http://www.lossimpson.com Click on the Bart Bowl game.

Don't have time right now, but, as example, a few years ago I hacked the tv
show The Profiler's special online game about jack the serial killer.

You were supposed to fine 9(?) items scattered about the site. Of course
they kept score client site via cookies. I simply went into netscape's
cookie.txt file, and found the variable's their site was creating. It was
_instantly_ obvious to me they were bit encoding the items, so changed the
number's boolean flags to give me everything and saved the cookie.txt.

Started the browser up.

I won. Think I was second there. (Made me feel... like a predatory serial
killer, oddly enough. ;-)

Point is, are you saving _ANY_ info client side? If it's anything beyond a
simple unqiue session id, you're going to be hacked.

--min

>
> Thanks much,
>
> Rick
>
>
>  _ Do You
> Yahoo!? Get your free @yahoo.com address at http://mail.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.

Checkboxes....

[Mr G Lewis]

Hello,
 This has almost certainly been asked before... so here we go
again:

I have a form that displays a set of items each with its own 
checkbox.  The number of choices will vary from day to day. The 
user selects any number of the items displayed and these choices 
are to be entered into a database.

The items come from the database so result from a query e.g.


SELECT Item_Name, Item_ID
FROM Items
WHERE Active=1 
 

then I do something like this to create a set of checkboxes - I don't 
know
how many checkboxes there are so I have to create the names 
dynamically:






 
#Item_Name#
 





so the next template receives a set of FORM.Choice_1, 
FORM.Choice_2 and so on which contain the Item_ID values that I 
need to insert into the database.

This where I am stumped - how do I step through those vales in 
order to insert them? OR perhaps there is a BETTER WAY.

I guess I can't do this:



INSERT INTO Choices(Items)
Values('Choice_#Count#')



I could write the Choice_N values to an array Choices[N] then loop over 
that but there must be a better way

Graham

--
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: Checkboxes....

[DeVoil, Nick]

> This has almost certainly been asked before...

Yesterday in fact :-)
The thread is called "picking up form variables on the action page??"

Nick


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
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.

MDCFUG news

[Michael Smith]

You are invited to the Maryland ColdFusion User Group Meeting, on
Tuesday 9/12/00 at 6:30pm

   * What: ColdFusion Users sharing programming tips and code
   * Cost: FREE (and free pizza too!)
   * Website:  http://www.cfug-md.org/
   * Meetings: Second Tuesday of every month.
   * Where:Rockville MD, near I-270
   * Signup:   mailto:[EMAIL PROTECTED]?subject=MDCFUG signup
   Or call us at 301-424-3903

- Michael Smith, TeraTech, TeraTech http://www.teratech.com/
   MDCFUG http://www.cfug-md.org/

-- Agenda 

Here's what's coming up at the MDCFUG meeting this Tuesday, at 6:30
pm:

  * Tom Folkes of TFolkes.com will speak on "Knowledge Management Tool
Using ColdFusion". CyberHiveMind.com is
 a third generation holographic search tool. It is designed to both
provide the user with support in expanding their search and database
drill down.

  * Janaki Naga of Differential Technologies "Firsttime Fusebox
project"

  * MDCFUG Group session "Ideas for CF coding style guide"

 * Q&A session - bring a floppy with problem or neat code or email it
to
   mailto:[EMAIL PROTECTED]?subject=CF problem for MDCFUG

There will be a free MDCFUG coffee mugs for you if you
bring some CF code or techniques to the meeting!

The meeting is located at:

  Best Western (Washington Gateway)
  1251 W Montgomery Ave
  Rockville, MD 20850-3198 (301-424-4940 )


For a map or directions go here:

http://www.cfug-md.org/directions.cfm

To get to the User Group:

 * Take I-270 to Route 28 (Exit 6B) towards Darnestown.
 * Turn right at second light (Hurley Ave) and go up "S" bend hill.
 * Park in the main lot and go in the main hotel entrance.
 * Once inside the building go past the bar and front desk and vier
left
   - the room is in one of the Salons on the left about 20 meters on.

--

***
CF News
***

Fusebox FUN 2000

At CFUN-2k this weekend, Steve Nelson of SecretAgents.com and Michael
Smith of TeraTech, Inc., announced the first ever Fusebox
conference, set for Saturday, September 16, 2000. The conference,
sponsored by SecretAgents.com and TeraTech, will be a 9 to 5 FuseFest
full of lectures and information about the methodology, and includes a
free copy of the forthcoming Fusebox book. Speakers include: Hal
Helms,
Steve Nelson, Nat Papovich, Gabe Roffman, Fred T. Sanders, Cameron
Childress and Michael Smith. Location: Charlottesville, VA, at the
Best
Western Cavalier Inn, 105 Emmet, Charlottesville, VA 22904-0201. Price
of admission is $99, which includes lunch (but not hotel
accomodations). For more information
   http://www.fusebox.org/conference

A signup form is in URL above. Also you can sign up by
email through [EMAIL PROTECTED] or by calling TeraTech at
1-800-447-9120.

CF101 - Back to Basics
--
Either learn basic CF or if you are a CF smartie then help other's
learn it at this Saturday morning event 9/9/00.
  http://www.cfconf.org/cf101/

10 security threats
---
Avi Pawar, a CJCFUG member, told us about the SANS Institute's article
entitled "How To Eliminate The Ten Most Critical
Internet Security Threats".  You can read the article, updated August
18, 2000, at:
  http://www.sans.org/topten.htm


Hien Nguyen
Central Jersey ColdFusion User Group (CJCFUG)

Nullsoft NSCopy
---
For website binary file copies that don't zap all your
bandwidth... Copy files across network, tweak your own transfer rate,
multiple source directories, progress indicators, can auto skip
or overwrite existing fields.

http://firehose.net/free/nscopy/

The idea came from Tag who needed a means to synchronize his stream
machine without overloading the network traffic in order to avoid
skipping. The solution was this little copy utility that he and lone
coded over a night while drinking coffee, redbulls, and smoking
cigarettes at
the fire exit every 20 minutes. It allows you to select a list of
source directories and a target, and to specify a maximum throughput.

Because all great (hmm) things should be free, this should be too. Not
only that, we're pretty much giving away all rights to it, giving you
the
source, and letting you do what you want with it (see the license
below).

features

 Multiple source directories
 Max speed range from 512cps to unlimited (spaceballs mode)
 Detailed progress indicators (current file, overall)
 Save/Load directory sets
 Automatically skips or overwrites existing files
 Disabled notifications mode
 Incredible default design window with minimize, close buttons and
titlebar.

Submitted by David Schroeder.

Adam Churvis Seminar

***  REGISTRATION CLOSES TOMORROW!
***  Advance Registration Only -- No On-Site Registration
***  CFUG Members Get In For Less Than Half-Price! (see below)
***  All Attendees Get Free CommerceBlocks Softw

RE: Yet another filesize question

[DeVoil, Nick]

> i feel so unloved. :)

Chris, we love you.

(do they say things like that in the US army?)


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
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: Slightly OT - Detecting that a page has completed. - Many Thanks

[Michael O Reilly]

Don,

Here's how it works.
We need two tables. One to record the DateTime that a request began. And
another table which records when requests complete.
For each record in tRequestStart, there may or may not be a record in
tRequestComplete depnding on whether the whole page was received at the
Client.
I'm using MsSQL7, stored procedures and ISS. You may need to use SQL
statements in your code if using Access.
You'll need MDAC installed to use ADO.

Table structure (tRequestStart)

iUniqueID int (AutoIncrement) PK
iCrewID int
DTRequestStart DateTime

Table structure (tRequestComplete)

iRequestID int PK (NOTE: Not AutoIncrement)
iCrewID int
DTRequestEnd DateTime

I my case, I pick users for a CFTree, so the CFTREEITEMKEY contains the
UserID.
At the start of the page the user has requested, use the following CF code
to call a stored procedure.
Change the Datasource name to match yours. You may need to use a CFQUERY
depending on DB










The SQL for the SP is simple 

CREATE PROCEDURE sp_InsertReqStartRecord
@SUCCESS int OUTPUT,
@iCrewID int
 AS 
 INSERT INTO tRequestStart
 (
 [iCrewID],
 [DTRequestStart]
) 
VALUES 
(
 @iCrewID,
 GETDATE()
)
SELECT @SUCCESS = @@IDENTITY


This creates the time-stamped record and returns the RecordID, which we use
at the end of the page.

If you don't have Remote Scripting,it's a small download from Microsoft's
Web site from

http://www.msdn.microsoft.com/scripting/remotescripting/rsdown.htm

You may also need the latest Windows Scripting engine which you can install
from any IE5 installation.

Now the fairly complex bit. Remote scripting lets you call a function on the
server from the client.
You create a Active Server Page with the function you will to call from the
Client and declare them in a special way.
Getting the Server side working was the hardest part for me.

Here's the final piece of code that runs on the Client. There a two pieces
of JavaScript required. One to enable Remote Scripting and the other to call
the Server Side function.

1) Enable Remote Scripting. This should be place immediately after the
 tag. Note: NOT in the 




   RSEnableRemoteScripting("../_ScriptLibrary/RScripting")


I had a lot of problems with paths. The installation of Remote Scripting put
stuff into C:\Inetpub\WWWRoot\_ScriptLibrary which is normally in the root
level of your Web Server. Try to get samples working with this path before
you go copying stuff to other directories, otherwise you'll never figure
what's causing errors (coding or path errors).

2) Call the Exported Server Function. This should be the last line of code
in your page. You know the user recieved th rest of the page if this script
runs.



co =
RSExecute("LogRosterRequest.asp","logreq",#CFTREEITEMKEY#,#Result#);
if (co.return_value ==1) {
window.alert("Your Roster Request has been logged.");
}




Here I'm calling an Exported function called logreq (Javascript is case
sensitive) from an Active Server Page called LogRosterRequest.asp. Again be
careful with paths. I'm passing in The UserID (#CFTREEITEMKEY#) and the
RecordID (#Result#) we got when CF called the stored procedure and created a
record in tRequestStart.


On the server.

Make sure RS.htm, RS.Asp and RSProxy.class exist in
c:\inetpub\wwwroot\_scriptlibrary.

Finally here is the code for LogRosterRequest.asp which exist in the same
directory and the CFM page that get's sent to the Client.

<%@ LANGUAGE=VBSCRIPT %>
<% Option Explicit %>
<% RSDispatch %>





   var public_description = new MyServerMethods();
   function MyServerMethods()
   { 
  this.logreq = Function( 'n1','n2','return addRecord(n1,n2)' );
   }




Function addRecord(crewstr,recstr)
Dim objCmd
Dim objConn
' Data types are converted because they are passed as strings
  addRosterRecord = 0
  
Set objConn = Server.CreateObject("ADODB.Connection")
Set objCmd = Server.CreateObject("ADODB.Command")
objConn.ConnectionString = "PROVIDER=SQLOLEDB" & _
";SERVER=ServerName;UID=UserName;PWD=Password;DATABASE=DatabaseName"  
objConn.Open
If (objConn.State = adStateOpen) Then 
  Set objCmd.activeconnection=objconn
  objCmd.CommandText = "sp_InsertReqRecEnd"
  objCmd.Parameters.Append objCmd.CreateParameter("@SUCCESS", adInteger,
adParamOutput, 0, 0)
  objCmd.Parameters.Append objCmd.CreateParameter("@iCrewID", adInteger,
adParamInput, , CInt(crewstr))
  objCmd.Parameters.Append objCmd.CreateParameter("@iRecID", adInteger,
adParamInput, , CInt(recstr))
  objCmd.CommandType = adCmdStoredProc
  objCmd.Execute
  addRosterRecord = ObjCmd("@SUCCESS")
End if
  Set ObjCmd.ActiveConnection = Nothing
  Set ObjCmd = Nothing
  Set objConn=Nothing  
End Function


You'll to change the ADO connection string to use your Server, Database and
log in with a valid Username and Password.

This code calls a store procedure which inserts the matching time-stamped
record. Here's the Stored procedure.

CREATE PROCEDURE sp_Inse

RE: Checkboxes....

[Mr G Lewis]

Nick,

> Yesterday in fact :-)
> The thread is called "picking up form variables on the action page??"

Thing is I only rejoined the list today.  I can see one tail end of that 
thread but it is only talking about checking the existance of FORM 
varaiables.  Perhaps the start oif the thread refered to my question 
but I cannot access those messages (they do not seem to be in the 
archives yet) 

My question is to do with passing checkbox FORM variables whose 
names are dynamically generated in the form.

I can't send them as as an array (I guess a form variable cannot be 
an array ... I experimented and it didn't work) without resorting to 
WDDX or somesuch so I am sending them as

Item_1Item_n

My problem is is looping through those in the next template and 
inserting their values into the database.

I am trying to write the ones that get passed to an array and then 
looping through that to do the inserts but it is clunky and anyway 
doesn't work at the moment.

Graham
--
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: Checkboxes....

[DeVoil, Nick]

> Thing is I only rejoined the list today.  

Sorry Graham, will forward you the thread off list.

Nick


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
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: SQL Trigger / Stored Proc question

[DeVoil, Nick]

> CREATE TRIGGER GetMax_ID ON mytable
> FOR INSERT
> AS
> SELECT mytable_ID FROM INSERTED
> 
> How would I reference the result within a stored procedure to insert
> the "mytable_id" in the next query?

Neil

I don't think you can pass a value out from a trigger - once the trigger
is created it exists independently of the rest of your code. But you
could put all the logic inside the trigger, or have the trigger call
a procedure with all the logic inside it.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
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: Checkboxes....

[Mr G Lewis]

Nick,
Many many thanks for digging out the thread messages and 
sending them to me.  You are right this is the same question.  I 
don't entirely understand the answer though:




 
 



I would have a loop within the cfform as I guess is implied above
How do the values of the selected checkboxes get added to the list 
before the submit button is pressed and how is that list passed to 
the next template - as an  ?

or are we ignoring the normal checkbox FORM values and using the 
list instead?

Graham

> > This has almost certainly been asked before... 
> Yesterday in fact :-)
> The thread is called "picking up form variables on the action page??"

--
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: SQL Trigger / Stored Proc question

[Paul Hastings]

> I don't think you can pass a value out from a trigger - once the trigger

sure you can. you can reference its value in queryName.mytable_ID


--
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: How do I get my Current URL

[Mr G Lewis]

Hmm.  Only partly works for me.  Only the the 
#CGI.SERVER_NAME# part returns anything

Same problem with #CGI.SCRIPT_NAME# amd 
#CGI.QUERY_STRING# suggested by somebody else

> The following works within a CF page:
> 
> Current URL is http://#CGI.SERVER_NAME##CGI.PATH_INFO#
> 
> Hope this helps
> H   Larry Juncker
>  L  Senior Cold Fusion Programmer
>   I Heartland Communications Group
>   Internet Division
> 
> ]
> -Original Message-
> From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 24, 2000 10:58 AM
> To: Cf-Talk
> Subject: How do I get my Current URL
> 
> 
> I've done this 100's of times, and I've drawn a blank. How do I get the
> current URL of the page I'm working on (full URL with parameters) within a
> variable? I'm trying to do a "Print This Page" button which will, with an
> additional parameter of &Print=1, kill the menus and titles and print the
> page. I have all the javascript and other functionality in place, I just
> need the link that refers to the currentpage with the added parameter.
> 
> Thanks...
> 
> 
> 
> Mark Armendariz
> Righteous Design
> 
> www.sorighteous.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 s
end 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: How do I get my Current URL

[Mr G Lewis]

I take it back:

http://#CGI.SERVER_NAME##CGI.PATH_INFO##CGI.SCRIPT_NA
ME#?#CGI.QUERY_STRING#

does work perfectly

On 24 Aug 00, at 15:05, Chapman, Katrina wrote:

> Don't know of one off the top of my head but you could build it using three
> CGI variables.  Server_name, Script_name, and query_string
> 
> Just concatenate those in that order and you'll have it.
> 
> --K
> 
> -Original Message-
> From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 24, 2000 8:58 AM
> To: Cf-Talk
> Subject: How do I get my Current URL
> 
> 
> I've done this 100's of times, and I've drawn a blank. How do I get the
> current URL of the page I'm working on (full URL with parameters) within a
> variable? I'm trying to do a "Print This Page" button which will, with an
> additional parameter of &Print=1, kill the menus and titles and print the
> page. I have all the javascript and other functionality in place, I just
> need the link that refers to the currentpage with the added parameter.
> 
> Thanks...
> 
> 
> 
> Mark Armendariz
> Righteous Design
> 
> www.sorighteous.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 s
end 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: SQL Trigger / Stored Proc question

[DeVoil, Nick]

> > I don't think you can pass a value out from a trigger - once the trigger
> 
> sure you can. you can reference its value in queryName.mytable_ID

But what is the query that queryName refers to?

If you say  CREATE TRIGGER...AS SELECT mytable_ID...

then what is executed is the CREATE TRIGGER statement, i.e. it stores the
trigger in the database. The trigger only *fires* when a row is inserted.
Are you saying that CF is clever enough to pick up the fact that the
trigger has fired & grab the value from somewhere?

The SQL Server documentation says:


Triggers can include any number and kind of Transact-SQL statements except
SELECT. A trigger is designed to check or change data based on a data
modification statement; it should not return data to the user.

...

To eliminate having results returned to an application due to a trigger
firing, do not include either SELECT statements that return results, or
statements that perform variable assignment in a trigger. A trigger that
includes either SELECT statements that return results to the user or
statements that perform variable assignment requires special handling; these
returned results would have to be written into every application in which
modifications to the trigger table are allowed. 


I think encapsulating it all in a stored proc would be the best thing.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
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: SQL Trigger / Stored Proc question

[Paul Hastings]

lets nip this myth in the bud

> But what is the query that queryName refers to?

the cfquery for the original insert.

> Are you saying that CF is clever enough to pick up the fact that the
> trigger has fired & grab the value from somewhere?

no, but ODBC & sql server are...

> The SQL Server documentation says:

since we're quoting (BoL):

"When a trigger fires, results are returned to the calling application, just
as with stored procedures."

> 
> Triggers can include any number and kind of Transact-SQL statements except
> SELECT. A trigger is designed to check or change data based on a data
> modification statement; it should not return data to the user.
> 

where does this bit come from? BoL only *suggests* you refrain from
returning results w/triggers because it would require all applications
accessing that table be able to handle the returned results.

> 
> To eliminate having results returned to an application due to a trigger
> firing, do not include either SELECT statements that return results, or
> statements that perform variable assignment in a trigger. A trigger that

you've taken this out of context. see the 1st line for this "quote" above.

triggers do have their place in development toolboxes.



--
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: Passing Variable values over more than 1 page

[Dave Hannum]

Store the values of the variables as Session Variables.
i.e.  Session.variableName

Create the variable via CFPARAM either in your CFAPPLICATION or just prior
to it's usage.  Then you can clear the value when you send the email with a
CFSET.

Study up on session and application variables.

Dave


=
"What we need is a list of specific unknown problems we will encounter"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 5:45 PM
Subject: Passing Variable values over more than 1 page


I am wanting to pass some variables over 2 or three pages and I am wondering
how to achieve this

I have a search results page and then the user can click on an email link
that takes them to a cf email form page on the site once the user sends the
email I want the page to go back to the search results page so the user can
keep looking at the other search results

my thought was that if I could pass the variables that were went sent from
the form to the search results page and then pass those same variable values
to the email form page then when the email is sent the search criteria
values can be sent back to the search results action page and hence display
the search results again

I tried the function of going back to pages in browser history however I was
getting an expired error message and so I felt the idea above would be a
more secure way of achieving what I want

any ideas comments and suggestions would be appreciated



Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
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.

--
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: SQL Trigger / Stored Proc question

[DeVoil, Nick]

Paul,

> triggers do have their place in development toolboxes.

Sure, I never said otherwise. Triggers are great.
I've built systems that rely completely on them.

> > But what is the query that queryName refers to?
> 
> the cfquery for the original insert.
> 
> > Are you saying that CF is clever enough to pick up the fact
> > that the trigger has fired & grab the value from somewhere?
> 
> no, but ODBC & sql server are...

So let me get this straight, if you have a trigger in
your database like this:

CREATE TRIGGER table1_insert
ON table1
FOR INSERT
AS
SELECT table1_ID FROM INSERTED


and have a .CFM containing this:


INSERT into table1 (col2) VALUES (#value2#)


then you can refer to #insertRow.table1_ID# and it will
contain the ID that was inserted for you by SQL Server,
despite no such variable/column being mentioned in the
, because the SQL Server ODBC driver returns the
trigger variable in response to the INSERT statement
and CF puts that in the  results accordingly?

If so... cool!

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
--
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.

SQL UNION across 2 Differnt DSN's

[Joseph J. Sanger, M.D.]

I would like to do a simple select statement, but need to mingle the 
results together for display purposes.  I am trying to merge the 
select from each of two identical tables located on two different 
Oracle DB Servers.  A simple UNION statement can only live under a 
single CFQuery statement (which of course points to a single DSN) 
 any suggestions on an efficient way to do this in CF?
___
  Joseph J. Sanger, M.D.| Phone: (212) 263-7410
  Associate Professor of Clinical Radiology | Fax:   (212) 263-2039
  Director, Division of Radiology Informatics   |
  Co-Director, Division of Nuclear Medicine |
  Co-Director, Nuclear Cardiology   |
  New York University School of Medicine| [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.

Why Netscape's serious lag time?

[Harold Goodson]

Hey all,

Might anyone be able to offer a plausible solution to Netscape's lag time
at the following URL?

It appears to be loading the tables and *all* of their images before
displaying the page at all.  This problem exists in other sites I have
worked on and I've yet to find a solution outside of not using tables
within tables.  I can't imagine it being caused by the CF code, but I can't
really see what's causing it to happen.


http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&Department
_name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif

or just: http://www.awgear.com and click sleeping bags or most all of the
links.

Any ideas/suggestions would be appreciated.

-Andy G.

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

[Terri Stocke]

Laura,

What I do is place a blank option tag in my query-driven select field, like 
so, making sure that it is selected by default:





Then in your action page:


Error!  You must select a state!




Terri

Original Message Follows
From: LH Rothman <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF Talk <[EMAIL PROTECTED]>
Subject: CFIF Questions
Date: Thu, 24 Aug 2000 21:34:57 -0700

Hello!

I want to force folks to select a state but I'm using CFSELECT and the
required tag doesn't work with it.  Consequently I'm attempting to
modify the CFIF statement on my action page with little success.  I've
tried this:


Error!  You must select a state!



but it doesn't work.  The ultimate goal is to require folks to select at
MINIMUM a state in this search and give them an error if they select
nothing.  I know I'm making a stupid mistake and and any help would be
very appreciated!!!

Thank you,
-Laura
An Apparent Newbie!


-- My Action page in progress--


SELECT Zip, City, County, State, Business, Phone, Fax, Website, Email,
Street1, Legal, Comments
FROM Contacts
WHERE Legal LIKE '1'


  AND Business LIKE '#Business#%'


  AND City LIKE '#City#%'


  AND County LIKE '#County#%'


  AND Zip LIKE '#Zip#%'


  AND State LIKE '#State#%'

ORDER BY Business




Search Results





Found #Contacts.RecordCount# Matches







#Business#
#Street1#N/A
#City#, #State# #Zip#
PH: #Phone#N/A
FX: #Fax#N/A
Web: #Website#N/A
Email: mailto:#Email#">#Email#N/A
#Comments#











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


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.

Anyone using Crystal Reports 8 successfully?!

[Mike Deane]

I have small problem, Crystal Reports, version 8.  What gives?  I am new
to cold fusion and the CFREPORT tag does not seem to work and I can't
seem to find any online resources to figure this one out.

Thank you.
/mdeane
--
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: SQL Trigger / Stored Proc question

[Andy Ewings]

quite righta trigger cannot contain a select and therefore cannot return
a resultset or return a parameter

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 25 August 2000 11:38
To: '[EMAIL PROTECTED]'
Subject: RE: SQL Trigger / Stored Proc question


> > I don't think you can pass a value out from a trigger - once the trigger
> 
> sure you can. you can reference its value in queryName.mytable_ID

But what is the query that queryName refers to?

If you say  CREATE TRIGGER...AS SELECT mytable_ID...

then what is executed is the CREATE TRIGGER statement, i.e. it stores the
trigger in the database. The trigger only *fires* when a row is inserted.
Are you saying that CF is clever enough to pick up the fact that the
trigger has fired & grab the value from somewhere?

The SQL Server documentation says:


Triggers can include any number and kind of Transact-SQL statements except
SELECT. A trigger is designed to check or change data based on a data
modification statement; it should not return data to the user.

...

To eliminate having results returned to an application due to a trigger
firing, do not include either SELECT statements that return results, or
statements that perform variable assignment in a trigger. A trigger that
includes either SELECT statements that return results to the user or
statements that perform variable assignment requires special handling; these
returned results would have to be written into every application in which
modifications to the trigger table are allowed. 


I think encapsulating it all in a stored proc would be the best thing.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

--
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: OT- Program to compare two pages of code for differences

[Greg Witte]

I've been using FCOMPARE and I've been pretty happy with it.

http://www.oneysoft.com/fcompare.htm

-Greg Witte

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 5:52 PM
To: [EMAIL PROTECTED]
Subject: OT- Program to compare two pages of code for differences


Does anyone know where I can find a program for comparing two pages of code
for differences?

I have two copies of a page and want to be able to compare to see how they
differ.

TYIA

H   Larry Juncker
 L  Senior Cold Fusion Programmer
  I Heartland Communications Group
  Internet Division


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

IsNotDefined()

[Peter Benoit]

Is there a way to do this?

I've tried things like !IsDefined() with no success...

Thanks,
Pete

--
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: IsNotDefined()

[Andy Ewings]

try: 

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: 25 August 2000 13:51
To: '[EMAIL PROTECTED]'
Subject: IsNotDefined()


Is there a way to do this?

I've tried things like !IsDefined() with no success...

Thanks,
Pete


--
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: IsNotDefined()

[Jamie Keane]

Try NOT IsDefined().

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Friday, August 25, 2000 8:49 AM
Subject: IsNotDefined()


>Is there a way to do this?
>
>I've tried things like !IsDefined() with no success...
>
>Thanks,
>Pete
>
>---
---
>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: Concatenate Strings

[Jamie Keane]

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit <[EMAIL PROTECTED]>
To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]>
Date: Thursday, August 24, 2000 7:18 PM
Subject: Concatenate Strings


>How can I concatenate 2 strings in CF?
>
>
>---
---
>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:

[Yanik Lupien]

Et bien j'en connais 2 !

Mon collège de travail ansi que moi. à part ça je sais pas !

Vous connaissez le coin ?

Yanik Lupien

- Original Message -
From: "Milks, Jim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 2:53 PM
Subject: RE: 


> Beaucoup de CF a Brossard?
>
> JM
>
> -Original Message-
> From: Yanik Lupien
> To: [EMAIL PROTECTED]
> Sent: 24/08/00 11:34 AM
> Subject: 
>
> Hi, I'm working on a project called GOgraph, it's a search engine where
> you
> can search images (over 20 000)!
> I have also write a custom tag to help Cold Fusion partners to embed our
> search engin on there site (Using WDDX)!
>
> I need help to test it!, I need comment on the custom tag and the doc
> file!
>
> Before you can test it be sure to add you IP Address in the "Setup your
> servers IP" you can use wildcard like "207.253.24.*" if you use a DHCP
> server.
>
> Anyone can help me?
>
> The GOgraph search engin URL
> http://www.gograph.com
>
> Register here it's the free trial system! (Not finish but work)
> http://www.gograph.com/fusion/en/cf_gograph/index.cfm
>
> Thank you
>
> Yanik Lupien
>
> Visicom Media
> http://www.visic.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: Page Refresh

[Michael Ross]

Ok here's my problem then.  I have users that can change information that they see on 
the screen.  They click edit and a small window opens and they change whatever.  Then 
when they click close window I need the parent page to reload?  I am thinking JS is 
needed??  Any ideas

Thanks
Mike

>>> [EMAIL PROTECTED] 08/24/00 09:34PM >>>
If you are refreshing a .cfm pager (onload or metatag) it will keep 
the session active.

HTH

Dick

At 4:09 PM -0400 8/24/00, Michael Ross wrote:
>I think that I read somewhere that you can have a page refresh every 
>20 seconds or what ever time limit I want.  Assuming that thisis 
>correct will sesson variables still die after the time limit.  Or 
>will the refreshing keep them alive?
>
>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: Page Refresh

[Howell, Katie]

I use

function closeme() {
this.window.opener.location.reload();
opener.focus();
this.window.close();
HTH

Katie

-Original Message-
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 9:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Page Refresh


Ok here's my problem then.  I have users that can change information that
they see on the screen.  They click edit and a small window opens and they
change whatever.  Then when they click close window I need the parent page
to reload?  I am thinking JS is needed??  Any ideas

Thanks
Mike

>>> [EMAIL PROTECTED] 08/24/00 09:34PM >>>
If you are refreshing a .cfm pager (onload or metatag) it will keep 
the session active.

HTH

Dick

At 4:09 PM -0400 8/24/00, Michael Ross wrote:
>I think that I read somewhere that you can have a page refresh every 
>20 seconds or what ever time limit I want.  Assuming that thisis 
>correct will sesson variables still die after the time limit.  Or 
>will the refreshing keep them alive?
>
>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.
--
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: Cookies

[Cfmarksport]

In a message dated 08/24/2000 8:46:54 PM Eastern Daylight Time, 
[EMAIL PROTECTED] writes:

<< This surely can't be a *total* can it?  Does this mean that there can only
 be 20 cookies set at any one time? >>

My understanding is that once you reach the browser's limit, the browser 
writes over the earliest cookies with the latest.  So if you want to use 30 
you will only have your last 20 available to you.

:-)
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.

RE:

[Milks, Jim]

Pas plus que ca, mais ton nom m'a dit que tu etait probablement québecois ou
francais, alors j'ai visité ton site et j'ai vu l'addresse. J'était curieux
si CF commencait a etre populaire au Quebec, ca ca commence dans notre coin
a Hull/Ottawa.

JM

PS: Pardonne mon francais...je fait mon possible 

-Original Message-
From: Yanik Lupien
To: [EMAIL PROTECTED]
Sent: 25/08/00 8:59 AM
Subject: Re: 

Et bien j'en connais 2 !

Mon collège de travail ansi que moi. à part ça je sais pas !

Vous connaissez le coin ?

Yanik Lupien

- Original Message -
From: "Milks, Jim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 2:53 PM
Subject: RE: 


> Beaucoup de CF a Brossard?
>
> JM
>
> -Original Message-
> From: Yanik Lupien
> To: [EMAIL PROTECTED]
> Sent: 24/08/00 11:34 AM
> Subject: 
>
> Hi, I'm working on a project called GOgraph, it's a search engine
where
> you
> can search images (over 20 000)!
> I have also write a custom tag to help Cold Fusion partners to embed
our
> search engin on there site (Using WDDX)!
>
> I need help to test it!, I need comment on the custom tag and the doc
> file!
>
> Before you can test it be sure to add you IP Address in the "Setup
your
> servers IP" you can use wildcard like "207.253.24.*" if you use a DHCP
> server.
>
> Anyone can help me?
>
> The GOgraph search engin URL
> http://www.gograph.com
>
> Register here it's the free trial system! (Not finish but work)
> http://www.gograph.com/fusion/en/cf_gograph/index.cfm
>
> Thank you
>
> Yanik Lupien
>
> Visicom Media
> http://www.visic.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?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Dates

[Philip Arnold - ASP]

> If I use this?
>
> 
> 
>
> Will months with 2 digits appear with 2 digits?  IE 10/10/00?

I know this sounds a bit odd, but wouldn't 2 minutes of checking have saved
you hours of waiting for a reply from this list?


#DateFormat(CreateDate(2000,1,10),"m/dd/")#
#DateFormat(CreateDate(2000,10,10),"m/dd/")#


This would have answered your question, took less than a minute to type and
less than a  second to generate the result

Or, check the documentation;
"m -- Month as digits with no leading zero for single-digit months."

It would also be a completely useless function if it chopped the month off,
wouldn't it?

One of our developers has taken to asking questions like this (instead of
reading the manuals, on-line docs or testing) and we've taken to ignoring
her questions until she realises that it's a LOT better to learn for herself
than to ask for help from others around - it means that she'll be a lot more
self-reliant when a bigger job is handed over for her to complete.

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.

RE: Join vs Union Perference(sp)

[Philip Arnold - ASP]

> Which is better an apple or a bicycle?

Erm, a bicycle as you can use it to ride to an apple tree and pick as many
apples as you want, while one apple can only be eaten once 

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.

RE: IsDefined() Problem

[Philip Arnold - ASP]

> Figured it out (taken me months!)
>
> I need to put quotes in, which seems a bit irish to me as all other
> functions (those I can think of off the top of my head) you don't put the
> quotes in when putting in a variable.

OK, here's why it's not stupid to have quotes...
isDefined() replaces ParameterExists(), which required the variable name to
be put in without quotes, in fact, you couldn't (naturally) check for the
existance of a dynamic variable name

isDefined() uses the quotes because it can take dynamic variable names, take
this example;



#i# not completed




Without using an Evaluate() on the first CFIF, you couldn't do this... why
use 2 functions when one will do?

Hope this explains a bit

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.

RE: ColdFusion Server-side Source Control

[Milks, Jim]

Yes I have some experience, and my conclusion is STAY AWAY! 
Vss and CF just don't seem to integrate well. We thought we had it solved,
until we lost a day's worth of development. Our final conclusion was to
simply run CF and VSS seperately and use Alt + Tab a lot.
I would agree that the multiple projects appear to be the issue, but we
never had enough time to invest in trying to solve it...

Good luck..


JM 

-Original Message-
From: Truman Esmond III
To: [EMAIL PROTECTED]
Sent: 24/08/00 7:43 PM
Subject: ColdFusion Server-side Source Control


Okay, I've spent enough time spinning my wheels on this by myself - any
help
is appreciated :)

Anyone successfully implemented server-side source control through CF?
Found better docs somewhere on this feature within CF?

We've got source control set up through studio, but we're trying to have
an
internal development server connect to a client's VSS db, and have all
of
our local developers use RDS locally on that machine for this effort -
the
problem seemingly lies in that there are multiple projects and multiple
working directories.  The form in the CFAdmin only allows a single DB to
be
connected (and is kinda vague about exactly which .ini file to connect
to)
and only a single working directory.
Any experiences, configurations and references to other documentation
would
be greatly appreciated!

Secondly and similarly, has anyone tried using the CF server-side source
control or even studio integrated source control using SourceGear's
SourceOffSite? Looks like it *should* work the same (only faster) since
their based on the same API...

Truman


--
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: Yet another filesize question

[Olive, Christopher M Mr NMR]

that makes me feel better.  it's gonna be a good weekend. :)

(actually, its a DOD project.  but i'm a contractor, so who cares about *my*
sexual orientation? sides, they didn't ask)

:)

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 4:54 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Yet another filesize question


> i feel so unloved. :)

Chris, we love you.

(do they say things like that in the US army?)


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

--
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: Why Netscape's serious lag time?

[Geoffrey V. Brown]

Hi,
Netscape is a little freaky about tables.  You have to make sure that all of
your width / height calculations are defined, and are accurate.  On first
glance, I found that you have a table with a width of 600 contained within a
table with a width of 585.  Netscape is probably trying to recalc all the
tables, which causes the lag.  I didn't dig any deeper than that though...

Thanks,
Geoffrey Vail Brown
__
Director of Online Operations
Deerfield.com
231.935.4640
[EMAIL PROTECTED]

Check out our complete line of Internet leveraging software at:
http://www.deerfield.com

> -Original Message-
> From: Harold Goodson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 25, 2000 8:04 AM
> To: [EMAIL PROTECTED]
> Subject: Why Netscape's serious lag time?
>
>
> Hey all,
>
> Might anyone be able to offer a plausible solution to Netscape's lag time
> at the following URL?
>
> It appears to be loading the tables and *all* of their images before
> displaying the page at all.  This problem exists in other sites I have
> worked on and I've yet to find a solution outside of not using tables
> within tables.  I can't imagine it being caused by the CF code,
> but I can't
> really see what's causing it to happen.
>
>
> http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&D
> epartment
> _name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif
>
> or just: http://www.awgear.com and click sleeping bags or most all of the
> links.
>
> Any ideas/suggestions would be appreciated.
>
> -Andy G.
>
> --
> 
> 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: CSS

[Hales, John M]

The O'Reilly book "Cascading Style Sheets" is the best reference I've found.
It has a table which covers what you're asking for.

hth

Mike Hales

-Original Message-
From: Reilly, Jim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 5:30 PM
To: [EMAIL PROTECTED] (E-mail)
Subject: OT: CSS




Anyone have a document/list/URL's of things that "work/don't work"
on NS4+ and IE4+ browsers?

(looking for many as I can get...)


Example:
TABLE { vertical-align : middle; text-align : center; background-color :
green; }

Option  NetscapeIE
==  ===
text-align : center;no  yes

...
..
.
.


Tkx,
Jim

--
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: [RE: OT- Program to compare two pages of code for differences]

[double-down]

use the diff command. if this is windows and you do not have diff download
cygnus unix tools.

"Scott, Andrew" <[EMAIL PROTECTED]> wrote:
try MS Source Safe, not only is it good for backing up code, but it makes
great sense to be able to go back revisions if need be:-)

regards

Andrew Scott
ANZ eCommerce Centre
* Ph 9273 0693  
* [EMAIL PROTECTED]


-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 23 August 2000 07:52
To: [EMAIL PROTECTED]
Subject: OT- Program to compare two pages of code for differences


Does anyone know where I can find a program for comparing two pages of code
for differences?

I have two copies of a page and want to be able to compare to see how they
differ.

TYIA

H   Larry Juncker
 L  Senior Cold Fusion Programmer
  I Heartland Communications Group
  Internet Division


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



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Trigger / Stored Proc question

[Adam Phillip Churvis]

Sorry, my friend, but you are wrong here.  Triggers can contain hundreds of
lines of complicated code to enforce complex user-defined business rules,
and they can contain SELECT statements and also return result sets (in
T/SQL)-- which can be configured to look like parameters if the result set
is a single row.

I lectured on this at CFUN2K last month, and our upcoming high-end
ecommerce product uses these techniques extensively to create a very robust
and scalable app.

The meat of the issue is this: inserting a table row from a stored
procedure, then gaining access to the Indentity column value just inserted.
 The trigger Neil shows will indeed produce a result that can be accessed
in CFML after CFQUERY is run by using QueryName.ColumnName.  The problem
is: how do you access this from a stored procedure that inserts the row?

The answer is this: reference @@IDENTITY in the stored procedure
IMMEDIATELY after the statement that inserts the table row.  This won't
make use of the trigger's SELECT result, but it will give you the value of
the Identity column most recently inserted into a table.

BTW, David and I will be teaching this and many other techniques during
next week's Ecommerce Development with ColdFusion seminar in Memphis.  If
you want a half-price pass, then just email a request to
[EMAIL PROTECTED], but hurry because today is the final
day of registration.

Hope this helps.  Cheers! :)

At 01:42 PM 8/25/00 +0100, you wrote:
>quite righta trigger cannot contain a select and therefore cannot return
>a resultset or return a parameter
>
>-Original Message-
>From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
>Sent: 25 August 2000 11:38
>To: '[EMAIL PROTECTED]'
>Subject: RE: SQL Trigger / Stored Proc question
>
>
>> > I don't think you can pass a value out from a trigger - once the trigger
>> 
>> sure you can. you can reference its value in queryName.mytable_ID
>
>But what is the query that queryName refers to?
>
>If you say  CREATE TRIGGER...AS SELECT mytable_ID...
>
>then what is executed is the CREATE TRIGGER statement, i.e. it stores the
>trigger in the database. The trigger only *fires* when a row is inserted.
>Are you saying that CF is clever enough to pick up the fact that the
>trigger has fired & grab the value from somewhere?
>
>The SQL Server documentation says:
>
>
>Triggers can include any number and kind of Transact-SQL statements except
>SELECT. A trigger is designed to check or change data based on a data
>modification statement; it should not return data to the user.
>
>...
>
>To eliminate having results returned to an application due to a trigger
>firing, do not include either SELECT statements that return results, or
>statements that perform variable assignment in a trigger. A trigger that
>includes either SELECT statements that return results to the user or
>statements that perform variable assignment requires special handling; these
>returned results would have to be written into every application in which
>modifications to the trigger table are allowed. 
>
>
>I think encapsulating it all in a stored proc would be the best thing.
>
>Nick
>
>
>**
>Information in this email is confidential and may be privileged. 
>It is intended for the addressee only. If you have received it in error,
>please notify the sender immediately and delete it from your system. 
>You should not otherwise copy it, retransmit it or use or disclose its
>contents to anyone. 
>Thank you for your co-operation.
>**
>
>--
>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.


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

Re: netscape taking a long time to render page

[perry]

i'm getting a 404 file not found on that url

i've noticed that netscape doesn't render very quickly with lots of embedded
tables (to me, 5 or greater is a lot) and a large amount of text in the page
(about 3 or more 'pages' worth).

perry


on 8/24/00 7:19 PM, Chris at [EMAIL PROTECTED] wrote:

> hey guys,i've got a page here that is taking a very very long time  to
> render in NS (after it has downloaded) i know its because of some tag
> formating, but i cant seem to find it. all my tables check out as far as i
> can tell.. can i get a few more sets of eyes to take a look at the html &
> possibly show me what i've done wrong?
> 
> heres the url for the html output of the page thats giving me a problem:
> 
> http://www.yarooze.com/kitehigh/testNSproblem.cfm
> 
> its actually all cold fusion code, so dont be fooled by the .cfm ext.
> 
> thanx for any help you can give.
> -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.

RE: SQL Trigger / Stored Proc question

[Andy Ewings]

I stand corrected!...thanks.

Out of curiosity - When faced with this sort of thing I always reference the
INSERTED table to get the ID rather than @@IDENTITY.  I know it will be
marginal if anything but will @@IDENTITY be quicker?  are there any other
advantages or is it essentially the same thing?

-Original Message-
From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]]
Sent: 25 August 2000 14:33
To: [EMAIL PROTECTED]
Subject: RE: SQL Trigger / Stored Proc question


Sorry, my friend, but you are wrong here.  Triggers can contain hundreds of
lines of complicated code to enforce complex user-defined business rules,
and they can contain SELECT statements and also return result sets (in
T/SQL)-- which can be configured to look like parameters if the result set
is a single row.

I lectured on this at CFUN2K last month, and our upcoming high-end
ecommerce product uses these techniques extensively to create a very robust
and scalable app.

The meat of the issue is this: inserting a table row from a stored
procedure, then gaining access to the Indentity column value just inserted.
 The trigger Neil shows will indeed produce a result that can be accessed
in CFML after CFQUERY is run by using QueryName.ColumnName.  The problem
is: how do you access this from a stored procedure that inserts the row?

The answer is this: reference @@IDENTITY in the stored procedure
IMMEDIATELY after the statement that inserts the table row.  This won't
make use of the trigger's SELECT result, but it will give you the value of
the Identity column most recently inserted into a table.

BTW, David and I will be teaching this and many other techniques during
next week's Ecommerce Development with ColdFusion seminar in Memphis.  If
you want a half-price pass, then just email a request to
[EMAIL PROTECTED], but hurry because today is the final
day of registration.

Hope this helps.  Cheers! :)

At 01:42 PM 8/25/00 +0100, you wrote:
>quite righta trigger cannot contain a select and therefore cannot
return
>a resultset or return a parameter
>
>-Original Message-
>From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
>Sent: 25 August 2000 11:38
>To: '[EMAIL PROTECTED]'
>Subject: RE: SQL Trigger / Stored Proc question
>
>
>> > I don't think you can pass a value out from a trigger - once the
trigger
>> 
>> sure you can. you can reference its value in queryName.mytable_ID
>
>But what is the query that queryName refers to?
>
>If you say  CREATE TRIGGER...AS SELECT mytable_ID...
>
>then what is executed is the CREATE TRIGGER statement, i.e. it stores the
>trigger in the database. The trigger only *fires* when a row is inserted.
>Are you saying that CF is clever enough to pick up the fact that the
>trigger has fired & grab the value from somewhere?
>
>The SQL Server documentation says:
>
>
>Triggers can include any number and kind of Transact-SQL statements except
>SELECT. A trigger is designed to check or change data based on a data
>modification statement; it should not return data to the user.
>
>...
>
>To eliminate having results returned to an application due to a trigger
>firing, do not include either SELECT statements that return results, or
>statements that perform variable assignment in a trigger. A trigger that
>includes either SELECT statements that return results to the user or
>statements that perform variable assignment requires special handling;
these
>returned results would have to be written into every application in which
>modifications to the trigger table are allowed. 
>
>
>I think encapsulating it all in a stored proc would be the best thing.
>
>Nick
>
>
>**
>Information in this email is confidential and may be privileged. 
>It is intended for the addressee only. If you have received it in error,
>please notify the sender immediately and delete it from your system. 
>You should not otherwise copy it, retransmit it or use or disclose its
>contents to anyone. 
>Thank you for your co-operation.
>**
>---
-
>--
>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.


Respectfully,

Adam Phillip Churvis
President
Productivity Enhancement, Inc.


*  PRODUCTIVITY ENHANCEMENT, INC.  *
*

RE: Rich Text Files (RTF) Creation and Manipulation

[Clint Tillerson]

I'll second Dave's suggestion below to use WordPerfect. I too 
struggled and eventually succeeded.  I had to produce several 100+ 
page reports with complex tables, headers, page numbering, and 
page breaks.  

The code produced by Word was very hard to edit, and Word threw 
in a lot of "trash" code that wasn't necessary.  WordPerfect was 
much easier to modify.  I also had trouble producing code that 
would look identical in both Word and WordPerfect when viewed by 
the user.  Because the WordPerfect code was so much cleaner, it 
made this task much easier. 
 - Good Luck



> > I have a need to manipulate RTF files with ColdFusion. While
> > I have been successful in working with RTF files in Word, and
> > then saving out for manipulation with CF, I need to be able to
> > do some things that are a bit more complicated.

> 
> I've done this successfully many times in the past, building documents
> that even have grouped output across multiple pages. The secret to my
> success: Use WordPerfect instead of Word to generate the template.
> WordPerfect's RTF is much cleaner and simpler than Word's, and each
> major RTF control word is on a separate line. I ended up buying a copy
> of WordPerfect just for this purpose.
> 



Clint R. Tillerson
Meteorologist/Programmer
Pacific Environmental Services, Inc.
5001 South Miami Blvd.
PO Box 12077
RTP, NC  27709
(919) 941-0333
Fax: (919) 941-0234

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

cffile and text qualifier

[Bud]

Hi. I've got to create a little cffile for importing a csv file that 
uses "" as the text qualifier. I'm presuming the quotes will just 
tell the database on a manual import to ignore any commas between the 
quotes. But, how will this work with cffile if I loop through each 
row? There may be some commas in the fields as some are descriptions, 
Company names (Company, Inc.), etc.

I'll use chr(10) as the outside loop delimiter. On the inside, would 
you just use something like:

delimiter="#chr(34)#,#chr(34)#"

then replace the first and last quote from each row? Or does someone 
have a cleaner way?

Thanks.
-- 

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: Urgent help required....

[John Wright]

I have seen this when another process on an NT box has the file open or the
file has been corrupted in some manner. I would suggest re-creating the
file.

John

- Original Message -
From: "kailash" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 1:21 PM
Subject: Urgent help required


Hi! friends...
I am getting this error... has anyone faced this errorif so please
help

Error Occurred While Processing Request
Error Diagnostic Information
Cannot load template file

The template file exists, however, it either cannot be opened for reading,
or it is encrypted and its data has been corrupted


--
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: Anyone using Crystal Reports 8 successfully?!

[Gieseman, Athelene]

I just recently worked through this one (with some help from this list!)
You'll want to install the CR Web Component Server.  Once you have that up
on your web server, you can just use a URL to display the report in the
browser.  From there the user can print it.  I'm still having a problem with
the refresh though.  I've used a datasource in the report.  And this works
fine as long as I save the data in the report.  But if the user clicks on
the CR refresh button in the browser, they are prompted for an ID and
password.  No matter what ID and password I use there, I can't get the
report to redisplay.  I called Seagate about a week ago to try to figure out
how to get around it.  After being on hold for over 1/2 hour I accidentally
disconnected the line.  I haven't had the time to call back and wait again.
But I don't think this should be hard to fix.

Athelene Gieseman
[EMAIL PROTECTED]

-Original Message-
From: Mike Deane [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 7:34 AM
To: '[EMAIL PROTECTED]'
Subject: Anyone using Crystal Reports 8 successfully?!


I have small problem, Crystal Reports, version 8.  What gives?  I am new
to cold fusion and the CFREPORT tag does not seem to work and I can't
seem to find any online resources to figure this one out.

Thank you.
/mdeane

--
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: [RE: RE: Session timeout?]

[JL]

then do you ever get timeout?
if you compare the client.lastvisit with now(), it will never GTE 30 because
client.LastVisit is always updated before you excute this piece of code.

I use client management too...

Andy Ewings <[EMAIL PROTECTED]> wrote:
> Yup...this is what I do in mine..
> 
> 
> 
>   
>   DELETE FROM CDATA WHERE CFID =
> '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder'
>   
> 
> 
> OK I am using Clent management and it is being stored in a SQL database but
> you get the idea
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 15:27
> To: [EMAIL PROTECTED]
> Subject: RE: RE: Session timeout?
> 
> 
> 
> 
> Thanks Andy,
>  I cant do that cause i an dynamically logging the
> user. 
> 
> Is there  a ways you could say.
> 
> isDefined(Sessiontimeout)??
> 
> or 
> i have to calculate the time the user spends in the app and log
> them off!
>  
> 
> --- Original Message ---
> Andy Ewings <[EMAIL PROTECTED]> Wrote on 
> Thu, 24 Aug 2000 15:04:50 +0100
>  -- 
> Set a param in your application.cfm called Session.Loggedin for
> example with
> a default of "no"
> When a user logs in set this variable to yes.
> 
> Then in your application.cfm also have code that says:
> 
> 
>   
> 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 15:01
> To: [EMAIL PROTECTED]
> Subject: Session timeout?
> 
> 
> 
> 
> Hello all.
>Is there a way to find whether the session timed out.If
> the session timed out display the logon page.
> 
> Some like 
> 
> 
> 
> 
> but i cant get this work.
> 
> Appretiate any comments.
> 
> thanks
> Joe
> 
> 
> -
> Sent using MailStart.com ( http://MailStart.Com/welcome.html
> )
> The FREE way to access your mailbox via any web browser, anywhere!
> 
>

> --
> 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.
> 
> 
> 
> -
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
> 
>

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



Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Urgent help required....

[jamesa {James Alexander}]

you'll also get that error if the file does not have the correct permissions
set.




-Original Message-
From: John Wright [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 8:51 AM
To: [EMAIL PROTECTED]
Subject: Re: Urgent help required


I have seen this when another process on an NT box has the file open or the
file has been corrupted in some manner. I would suggest re-creating the
file.

John

- Original Message -
From: "kailash" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 1:21 PM
Subject: Urgent help required


Hi! friends...
I am getting this error... has anyone faced this errorif so please
help

Error Occurred While Processing Request
Error Diagnostic Information
Cannot load template file

The template file exists, however, it either cannot be opened for reading,
or it is encrypted and its data has been corrupted



--
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: [RE: RE: Session timeout?]

[Andy Ewings]

Ummm...ok.but if that's the case how can you ever interrogate the
Client.LastVisit variable and get a value other than the current time?

-Original Message-
From: JL [mailto:[EMAIL PROTECTED]]
Sent: 25 August 2000 14:57
To: [EMAIL PROTECTED]
Subject: Re: [RE: RE: Session timeout?]


then do you ever get timeout?
if you compare the client.lastvisit with now(), it will never GTE 30 because
client.LastVisit is always updated before you excute this piece of code.

I use client management too...

Andy Ewings <[EMAIL PROTECTED]> wrote:
> Yup...this is what I do in mine..
> 
> 
> 
>   
>   DELETE FROM CDATA WHERE CFID =
> '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder'
>   
> 
> 
> OK I am using Clent management and it is being stored in a SQL database
but
> you get the idea
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 15:27
> To: [EMAIL PROTECTED]
> Subject: RE: RE: Session timeout?
> 
> 
> 
> 
> Thanks Andy,
>  I cant do that cause i an dynamically logging the
> user. 
> 
> Is there  a ways you could say.
> 
> isDefined(Sessiontimeout)??
> 
> or 
> i have to calculate the time the user spends in the app and log
> them off!
>  
> 
> --- Original Message ---
> Andy Ewings <[EMAIL PROTECTED]> Wrote on 
> Thu, 24 Aug 2000 15:04:50 +0100
>  -- 
> Set a param in your application.cfm called Session.Loggedin for
> example with
> a default of "no"
> When a user logs in set this variable to yes.
> 
> Then in your application.cfm also have code that says:
> 
> 
>   
> 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 15:01
> To: [EMAIL PROTECTED]
> Subject: Session timeout?
> 
> 
> 
> 
> Hello all.
>Is there a way to find whether the session timed out.If
> the session timed out display the logon page.
> 
> Some like 
> 
> 
> 
> 
> but i cant get this work.
> 
> Appretiate any comments.
> 
> thanks
> Joe
> 
> 
> -
> Sent using MailStart.com ( http://MailStart.Com/welcome.html
> )
> The FREE way to access your mailbox via any web browser, anywhere!
> 
>

> --
> 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.
> 
> 
> 
> -
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
> 
>

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



Get free email and a permanent address at http://www.netaddress.com/?N=1

--
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: Anyone using Crystal Reports 8 successfully?!

[Mike Deane]

I am at the exact same point as you.  I cannot get the Web Component
Server to force scheduled refreshes.  I cannot include the file into a
.cfm file.  This is not a pretty sight right now.

Any one get past this point?

Thanks.
/mdeane

-Original Message-
From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 9:51 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Anyone using Crystal Reports 8 successfully?!


I just recently worked through this one (with some help from this list!)
You'll want to install the CR Web Component Server.  Once you have that
up
on your web server, you can just use a URL to display the report in the
browser.  From there the user can print it.  I'm still having a problem
with
the refresh though.  I've used a datasource in the report.  And this
works
fine as long as I save the data in the report.  But if the user clicks
on
the CR refresh button in the browser, they are prompted for an ID and
password.  No matter what ID and password I use there, I can't get the
report to redisplay.  I called Seagate about a week ago to try to figure
out
how to get around it.  After being on hold for over 1/2 hour I
accidentally
disconnected the line.  I haven't had the time to call back and wait
again.
But I don't think this should be hard to fix.

Athelene Gieseman
[EMAIL PROTECTED]

-Original Message-
From: Mike Deane [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 7:34 AM
To: '[EMAIL PROTECTED]'
Subject: Anyone using Crystal Reports 8 successfully?!


I have small problem, Crystal Reports, version 8.  What gives?  I am new
to cold fusion and the CFREPORT tag does not seem to work and I can't
seem to find any online resources to figure this one out.

Thank you.
/mdeane


--
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: SQL Trigger / Stored Proc question

[Adam Phillip Churvis]

I always like to use explicit references if possible-- @@IDENTITY is used
here because it is the only way to do this.

"Faster" in terms of time difference between these two techniques should
not even be a consideration because, for all intents and purposes, it is
negligible, and there are countless other better opportunities in any app
to pick up speed.

Hope this helps.

Well, it's time for me to feed my trusty horse, Gefilte, so I simply must go...

At 02:39 PM 8/25/00 +0100, you wrote:
>I stand corrected!...thanks.
>
>Out of curiosity - When faced with this sort of thing I always reference the
>INSERTED table to get the ID rather than @@IDENTITY.  I know it will be
>marginal if anything but will @@IDENTITY be quicker?  are there any other
>advantages or is it essentially the same thing?

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: Why Netscape's serious lag time?

[Caulfield, Michael]

Netscape will not render tables until it finishes calculating the whole
table (whereas Microsoft makes educated guesses as it goes). If you have
picture widths playing into the calc time it can get ugly. The first thing I
would try is explicitly defining all the cell widths, and see if that speeds
it up.

-Original Message-
From: Harold Goodson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 7:04 AM
To: [EMAIL PROTECTED]
Subject: Why Netscape's serious lag time?


Hey all,

Might anyone be able to offer a plausible solution to Netscape's lag time
at the following URL?

It appears to be loading the tables and *all* of their images before
displaying the page at all.  This problem exists in other sites I have
worked on and I've yet to find a solution outside of not using tables
within tables.  I can't imagine it being caused by the CF code, but I can't
really see what's causing it to happen.


http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&Department
_name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif

or just: http://www.awgear.com and click sleeping bags or most all of the
links.

Any ideas/suggestions would be appreciated.

-Andy G.


--
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: [RE: [RE: RE: Session timeout?]]

[JL]

I set another variable client.LastVisit2 = client.LastVisit at the end of
application.cfm

then I compare the lastvisit2 with now() at the top of application.cfm  =)


Andy Ewings <[EMAIL PROTECTED]> wrote:
> Ummm...ok.but if that's the case how can you ever interrogate the
> Client.LastVisit variable and get a value other than the current time?
> 
> -Original Message-
> From: JL [mailto:[EMAIL PROTECTED]]
> Sent: 25 August 2000 14:57
> To: [EMAIL PROTECTED]
> Subject: Re: [RE: RE: Session timeout?]
> 
> 
> then do you ever get timeout?
> if you compare the client.lastvisit with now(), it will never GTE 30
because
> client.LastVisit is always updated before you excute this piece of code.
> 
> I use client management too...
> 
> Andy Ewings <[EMAIL PROTECTED]> wrote:
> > Yup...this is what I do in mine..
> > 
> > 
> > 
> > 
> > DELETE FROM CDATA WHERE CFID =
> > '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder'
> > 
> > 
> > 
> > OK I am using Clent management and it is being stored in a SQL database
> but
> > you get the idea
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 24 August 2000 15:27
> > To: [EMAIL PROTECTED]
> > Subject: RE: RE: Session timeout?
> > 
> > 
> > 
> > 
> > Thanks Andy,
> >  I cant do that cause i an dynamically logging the
> > user. 
> > 
> > Is there  a ways you could say.
> > 
> > isDefined(Sessiontimeout)??
> > 
> > or 
> > i have to calculate the time the user spends in the app and log
> > them off!
> >  
> > 
> > --- Original Message ---
> > Andy Ewings <[EMAIL PROTECTED]> Wrote on 
> > Thu, 24 Aug 2000 15:04:50 +0100
> >  -- 
> > Set a param in your application.cfm called Session.Loggedin for
> > example with
> > a default of "no"
> > When a user logs in set this variable to yes.
> > 
> > Then in your application.cfm also have code that says:
> > 
> > 
> > 
> > 
> > 
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 24 August 2000 15:01
> > To: [EMAIL PROTECTED]
> > Subject: Session timeout?
> > 
> > 
> > 
> > 
> > Hello all.
> >Is there a way to find whether the session timed out.If
> > the session timed out display the logon page.
> > 
> > Some like 
> > 
> > 
> > 
> > 
> > but i cant get this work.
> > 
> > Appretiate any comments.
> > 
> > thanks
> > Joe
> > 
> > 
> > -
> > Sent using MailStart.com ( http://MailStart.Com/welcome.html
> > )
> > The FREE way to access your mailbox via any web browser, anywhere!
> > 
> >
>

> > --
> > 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.
> > 
> > 
> > 
> > -
> > Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> > The FREE way to access your mailbox via any web browser, anywhere!
> > 
> >
>

> > --
> > 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.
> 
> 
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
>

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



Get f

RE: Yet another filesize question

[Milks, Jim]

Sorry I did not acknowledge you yesterday, but I do love you also. The
reason I didn't, is that I was receiving serious lag times in the
posting/delivery of messages. I actually saw responses to things I posted
BEFORE my posting. Anyway, hugs and kisses to you and your Army buddies...

JM 

-Original Message-
From: Olive, Christopher M Mr NMR
To: '[EMAIL PROTECTED]'
Sent: 25/08/00 9:20 AM
Subject: RE: Yet another filesize question

that makes me feel better.  it's gonna be a good weekend. :)

(actually, its a DOD project.  but i'm a contractor, so who cares about
*my*
sexual orientation? sides, they didn't ask)

:)

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 4:54 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Yet another filesize question


> i feel so unloved. :)

Chris, we love you.

(do they say things like that in the US army?)


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**


--
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: Table Row Background colors not showing in Nutscrape

[Larry Juncker]

I found my problem - appreciate the replies

I had an image defined for the background in the table, apparently if you
have a background image in Netscape, you can not define also  colors.

Thanks again

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 7:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Table Row Background colors not showing in Nutscrape





You need to ensure you write a non-breaking space - " " without the
quotes
- if you are not displaying content in a cell. This is a Netscape "feature".


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.


--
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: [RE: [RE: RE: Session timeout?]]

[Andy Ewings]

ok...thanks.  But to me, that makes Client.Lastvisit pretty useless.  You
may as well just use now() in both cases i.e. set lasvisit2 = now() at the
end of application.cfm and then test it against now() at the beggining

-Original Message-
From: JL [mailto:[EMAIL PROTECTED]]
Sent: 25 August 2000 15:14
To: [EMAIL PROTECTED]
Subject: Re: [RE: [RE: RE: Session timeout?]]


I set another variable client.LastVisit2 = client.LastVisit at the end of
application.cfm

then I compare the lastvisit2 with now() at the top of application.cfm  =)


Andy Ewings <[EMAIL PROTECTED]> wrote:
> Ummm...ok.but if that's the case how can you ever interrogate the
> Client.LastVisit variable and get a value other than the current time?
> 
> -Original Message-
> From: JL [mailto:[EMAIL PROTECTED]]
> Sent: 25 August 2000 14:57
> To: [EMAIL PROTECTED]
> Subject: Re: [RE: RE: Session timeout?]
> 
> 
> then do you ever get timeout?
> if you compare the client.lastvisit with now(), it will never GTE 30
because
> client.LastVisit is always updated before you excute this piece of code.
> 
> I use client management too...
> 
> Andy Ewings <[EMAIL PROTECTED]> wrote:
> > Yup...this is what I do in mine..
> > 
> > 
> > 
> > 
> > DELETE FROM CDATA WHERE CFID =
> > '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder'
> > 
> > 
> > 
> > OK I am using Clent management and it is being stored in a SQL database
> but
> > you get the idea
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 24 August 2000 15:27
> > To: [EMAIL PROTECTED]
> > Subject: RE: RE: Session timeout?
> > 
> > 
> > 
> > 
> > Thanks Andy,
> >  I cant do that cause i an dynamically logging the
> > user. 
> > 
> > Is there  a ways you could say.
> > 
> > isDefined(Sessiontimeout)??
> > 
> > or 
> > i have to calculate the time the user spends in the app and log
> > them off!
> >  
> > 
> > --- Original Message ---
> > Andy Ewings <[EMAIL PROTECTED]> Wrote on 
> > Thu, 24 Aug 2000 15:04:50 +0100
> >  -- 
> > Set a param in your application.cfm called Session.Loggedin for
> > example with
> > a default of "no"
> > When a user logs in set this variable to yes.
> > 
> > Then in your application.cfm also have code that says:
> > 
> > 
> > 
> > 
> > 
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: 24 August 2000 15:01
> > To: [EMAIL PROTECTED]
> > Subject: Session timeout?
> > 
> > 
> > 
> > 
> > Hello all.
> >Is there a way to find whether the session timed out.If
> > the session timed out display the logon page.
> > 
> > Some like 
> > 
> > 
> > 
> > 
> > but i cant get this work.
> > 
> > Appretiate any comments.
> > 
> > thanks
> > Joe
> > 
> > 
> > -
> > Sent using MailStart.com ( http://MailStart.Com/welcome.html
> > )
> > The FREE way to access your mailbox via any web browser, anywhere!
> > 
> >
>

> > --
> > 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.
> > 
> > 
> > 
> > -
> > Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> > The FREE way to access your mailbox via any web browser, anywhere!
> > 
> >
>

> > --
> > 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.
> 
> 
> 
> Get free email and a permanent address at http://www.netaddress.com/?N=1
>

> --
> 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: Yet another filesize question

[Olive, Christopher M Mr NMR]

warm fuzzies all around.

before the Net.Cops show up, i appreciate that.  and my confidence is
restored in the world, etc etc.

(i'm a bit shaken because i'm leaving the cushy DOD job and going
independent.  the silent treatment at work is a bit unbearable.  but soon i
shall rise from the ashes as...)

christopher olive, cio
cresc technologies
http://www.crescotech.com

-Original Message-
From: Milks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 10:15 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Yet another filesize question


Sorry I did not acknowledge you yesterday, but I do love you also. The
reason I didn't, is that I was receiving serious lag times in the
posting/delivery of messages. I actually saw responses to things I posted
BEFORE my posting. Anyway, hugs and kisses to you and your Army buddies...

JM 

-Original Message-
From: Olive, Christopher M Mr NMR
To: '[EMAIL PROTECTED]'
Sent: 25/08/00 9:20 AM
Subject: RE: Yet another filesize question

that makes me feel better.  it's gonna be a good weekend. :)

(actually, its a DOD project.  but i'm a contractor, so who cares about
*my*
sexual orientation? sides, they didn't ask)

:)

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 4:54 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Yet another filesize question


> i feel so unloved. :)

Chris, we love you.

(do they say things like that in the US army?)


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**


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

white space problems

[Mueller, Ben]

Has anybody else experienced problems with the CF admin setting "supress
white space by default" not working?  We're running CF 4.5.1 on NT 4 with
Service Pack
6a, and even after a re-start of the server with that option turned on, our
pages are still output to the browser with a ton of white space.  

We have experimented with using  in places,
and it
has worked, but because of the way our code is set up, there are many places
where we can't use it, so the admin setting is our only real option.

We have two side by side servers running the same configuration and code
(development and testing machines), and we get the same result from both
machines.

any help/suggestions would be 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:

[Yanik Lupien]

Aucun problem pour le français !

Cold Fusion commence à être populaire ici mais il n'y a quand même pas
beaucoup de conaisseur de cette technologie, il y a quand même quelque
compagnie qui l'utilise mais pas plus que ça, si la compagnie ou je
travaille l'utilise c'est que je leur ai recommendé tout simplement!

Tu n'as pas essayé  test la c'est très simple, il y a même un
example inclus dans le fichier .zip ?

Ps. il est très beau votre site !

Yanik Lupien

- Original Message -
From: "Milks, Jim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 25, 2000 9:16 AM
Subject: RE: 


Pas plus que ca, mais ton nom m'a dit que tu etait probablement québecois ou
francais, alors j'ai visité ton site et j'ai vu l'addresse. J'était curieux
si CF commencait a etre populaire au Quebec, ca ca commence dans notre coin
a Hull/Ottawa.

JM

PS: Pardonne mon francais...je fait mon possible

-Original Message-
From: Yanik Lupien
To: [EMAIL PROTECTED]
Sent: 25/08/00 8:59 AM
Subject: Re: 

Et bien j'en connais 2 !

Mon collège de travail ansi que moi. à part ça je sais pas !

Vous connaissez le coin ?

Yanik Lupien

- Original Message -
From: "Milks, Jim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 2:53 PM
Subject: RE: 


> Beaucoup de CF a Brossard?
>
> JM
>
> -Original Message-
> From: Yanik Lupien
> To: [EMAIL PROTECTED]
> Sent: 24/08/00 11:34 AM
> Subject: 
>
> Hi, I'm working on a project called GOgraph, it's a search engine
where
> you
> can search images (over 20 000)!
> I have also write a custom tag to help Cold Fusion partners to embed
our
> search engin on there site (Using WDDX)!
>
> I need help to test it!, I need comment on the custom tag and the doc
> file!
>
> Before you can test it be sure to add you IP Address in the "Setup
your
> servers IP" you can use wildcard like "207.253.24.*" if you use a DHCP
> server.
>
> Anyone can help me?
>
> The GOgraph search engin URL
> http://www.gograph.com
>
> Register here it's the free trial system! (Not finish but work)
> http://www.gograph.com/fusion/en/cf_gograph/index.cfm
>
> Thank you
>
> Yanik Lupien
>
> Visicom Media
> http://www.visic.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=sts&body=sts/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: Why Netscape's serious lag time?

[Philip Meadows]

Yup, I've seen a perfect example of this with Geo Calendar. It has so many
nested tables that even on a local server it renders too slowly in Netscape.
I will say though that as clunky as Mozilla is, it rendered the same page
more quickly than IE5. The best thing to do is take a look at your table
structure and find places to streamline it.

Philip

-Original Message-
From: Harold Goodson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 7:04 AM
To: [EMAIL PROTECTED]
Subject: Why Netscape's serious lag time?


Hey all,

Might anyone be able to offer a plausible solution to Netscape's lag time
at the following URL?

It appears to be loading the tables and *all* of their images before
displaying the page at all.  This problem exists in other sites I have
worked on and I've yet to find a solution outside of not using tables
within tables.  I can't imagine it being caused by the CF code, but I can't
really see what's causing it to happen.


http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&Department
_name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif

or just: http://www.awgear.com and click sleeping bags or most all of the
links.

Any ideas/suggestions would be appreciated.

-Andy G.


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

Unknown Error

[Reynolds, Adam]

Anybody come across an odd error. 

Unknown exception condition

Error occured for unknown cause.


I have no idea why this is happening when I attempt to bring up the
administrator screens.


This is happening on a NT4 Workstation Portable, running Personal web
server, and Coldfusion Enterprise (was personal edition), Service Pack 6a.
This is a demo machine.


Is it the Personal Web Server??? 


Adam Reynolds
ColdFusion Consultant
H.J. Heinz 
Tel.: +44 (0) 20 8756 5170
Mob.: +44 (0) 7973 386620
**
 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.

REGISTRATION CLOSES TODAY!

[Adam Phillip Churvis]

***  REGISTRATION CLOSES TODAY! 

***  Advance Registration Only -- No On-Site Registration
***  CFUG Members Get In For Less Than Half-Price! (see below) 
***  All Attendees Get Free CommerceBlocks Software
***  Memphis AirTran Flights and Hotel Rooms Are Cheap
***  You Know You Really Want To Attend...

ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR

Okay... 

You all know how great this thing is going to be next week, and how much
you really want it and need it.  If your boss won't pay for it then fund it
yourself, quit when you get back, and find a job for more money with a
company that "gets it."

Three full days of exactly what you need to know to not only build killer
ecommerce apps, but killer ColdFusion apps in general.  There's a database
design course built right in, too.  When you're done, you get all the
example code and free CommerceBlocks software.

Remember:

-- $195.00* for a three day, chef catered, materials heavy seminar with
free software you can really use is incredibly cheap (it's below our cost).

-- AirTran and other airlines' ticket prices are dirt cheap, as are hotel
rooms in Memphis (see the Memphis travel and lodging links on
www.coldfusionseminar.com)

-- This seminar series is already booked through June 2001, so don't wait
for it to come to your area.

-- As of this writing we have only 20 seats left.

For complete details and to register, go to www.ColdFusionSeminar.com.

Be there!

* Email [EMAIL PROTECTED] with your request for a $195.00
Special Price Seminar Pass, and we'll send you one right away.


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.

SQL JOIN

[James Taavon]

Hello.

I am evaluating two columns under the same name in two different tables.
The error I got, "A reference to column "ID" is ambiguous" was expected.
My code is below. Can I do and INNER JOIN two resolve this error and
retrieve the correct value? If so , how? I don't have much practice with
using JOIN.

Thanks in advance!



SELECT Max(id) AS MaxOfID
FROM db2admin.tb_assigned,db2admin.tb_complete
where db2admin.tb_assigned.id = db2admin.tb_complete.id






#NextPONum# 

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

preventing simultaneous updates

[Terri Stocke]

Hi,

I am trying to implement a check in my pages so that if user A is editing 
record 1 from edit form A at the same time that user B is editing record 1 
from edit form B, the user who submits it second will get an error that 
someone has just updated this record.

I have a field in my table called "status_date", which is populated with the 
sysdate every time a record is updated.

This is what I've attempted:

In each form page itself, I've immediately queried the current status date 
for the record. When I display this on the page for testing purposes, it 
displays in the format 2000-08-25 10:22:39. I then assign this value to a 
variable called "last_status_date".  Then I pass last_status_date as a 
hidden field to my action page (the page that does the updates.

Immediately in my action form (before any updates are made, I have the 
following:



SELECT STATUS_DATE
FROM SUG_SUGGESTIONS
WHERE SUGGESTION_ID=#URL.SUGGESTION_ID#







I have displayed the output of datedifference to see what is going on...

On my action page, this is what I get for output:

form last status date: 2000-08-25
status check from this page: 2000-08-25 10:40:59
difference: 0.445127314815

What is happening is that for some reason, the time portion of 
form.last_status_date is not passing with the hidden field, even though 
form.last_status_date fully displays on the form page as desired. Why would 
this be?

Also, I believe that my reasoning is flawed for what I am trying to do, 
because of the actual dates.  Should I be using different logic for 
determining if the record has been updated by user A just before user B 
submitted?

Does this make sense?

Thanks!
T

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: REGISTRATION CLOSES TODAY!

[Mike Deane]

I can't make it to this, if I weren't under unbearable deadline
pressures I would be there in a heart beat.  Adam, any chance that
DBblocks,v2 will be available for download soon?

Thanks.
/mdeane

-Original Message-
From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 10:40 AM
To: [EMAIL PROTECTED]
Subject: REGISTRATION CLOSES TODAY!


***  REGISTRATION CLOSES TODAY! 

***  Advance Registration Only -- No On-Site Registration
***  CFUG Members Get In For Less Than Half-Price! (see below) 
***  All Attendees Get Free CommerceBlocks Software
***  Memphis AirTran Flights and Hotel Rooms Are Cheap
***  You Know You Really Want To Attend...

ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR

Okay... 

You all know how great this thing is going to be next week, and how much
you really want it and need it.  If your boss won't pay for it then fund
it
yourself, quit when you get back, and find a job for more money with a
company that "gets it."

Three full days of exactly what you need to know to not only build
killer
ecommerce apps, but killer ColdFusion apps in general.  There's a
database
design course built right in, too.  When you're done, you get all the
example code and free CommerceBlocks software.

Remember:

-- $195.00* for a three day, chef catered, materials heavy seminar with
free software you can really use is incredibly cheap (it's below our
cost).

-- AirTran and other airlines' ticket prices are dirt cheap, as are
hotel
rooms in Memphis (see the Memphis travel and lodging links on
www.coldfusionseminar.com)

-- This seminar series is already booked through June 2001, so don't
wait
for it to come to your area.

-- As of this writing we have only 20 seats left.

For complete details and to register, go to www.ColdFusionSeminar.com.

Be there!

* Email [EMAIL PROTECTED] with your request for a
$195.00
Special Price Seminar Pass, and we'll send you one right away.


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.
--
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: SQL JOIN

[Terri Stocke]

You need to qualify which table you are pulling the id from, since you are 
using two different tables in your query...


 SELECT Max(tablename.id) AS MaxOfID
 FROM db2admin.tb_assigned,db2admin.tb_complete
where db2admin.tb_assigned.id = db2admin.tb_complete.id





Original Message Follows
From: "James Taavon" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Subject: SQL JOIN
Date: Fri, 25 Aug 2000 10:44:41 -0400

Hello.

I am evaluating two columns under the same name in two different tables.
The error I got, "A reference to column "ID" is ambiguous" was expected.
My code is below. Can I do and INNER JOIN two resolve this error and
retrieve the correct value? If so , how? I don't have much practice with
using JOIN.

Thanks in advance!



 SELECT Max(id) AS MaxOfID
 FROM db2admin.tb_assigned,db2admin.tb_complete
where db2admin.tb_assigned.id = db2admin.tb_complete.id






#NextPONum#

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


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.

Results Query to Oracle

[Ray, James A]

I want to take the results of a query and insert the results into an Oracle
table.  Looking into the books, it really doesn't cover anything like that.
Here are some of the basic elements I have so far.

This code works except for the fact it will only insert on 1 record.  Do I
use CFLOOP or what.  Thanks for the guidance.


SELECT  B.ENDITEMPN, B.ENDITEMSN, B.LOCATION, C.PRESSURENAME,
A.END_ITEM_NAME
FROMDSTS.END_ITEM A, DSTS.PRESSURE_REQTS C,
DSTS.ENDITEMSTORAGE B
WHERE   (A.ENDITEMPN = B.ENDITEMPN) AND (B.ENDITEMPN = C.ENDITEMPN)
  








INSERT INTO DSTS.EXCELEXPORT
(ENDITEMNAME,ENDITEMPN,ENDITEMSN,LOCATION)  
VALUES('#ENDITEMNAME#','#ENDITEMPN#',
'#ENDITEMSN#','#LOCATION#') 
 


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: IsDefined() Problem

[Dave Watts]

> I would imagine that if you don't put quotes around the
> variable in your IsDefined(), ColdFusion will evaluate
> the variable and check to see if that is defined rather
> than the variable itself. If that's the case, I would
> assume it would always evaluate to true.

No, actually, it's more likely to evaluate to false in that case.


 
true

false

 
true

false


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: SQL JOIN

[James Taavon]

The thing is I need am pulling the ID field from both tables. So should
I just rename one column a differnet name? 

Terri Stocke wrote:
> 
> You need to qualify which table you are pulling the id from, since you are
> using two different tables in your query...
> 
> 
>  SELECT Max(tablename.id) AS MaxOfID
>  FROM db2admin.tb_assigned,db2admin.tb_complete
> where db2admin.tb_assigned.id = db2admin.tb_complete.id
> 
> 
> 
> 
> Original Message Follows
> From: "James Taavon" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: SQL JOIN
> Date: Fri, 25 Aug 2000 10:44:41 -0400
> 
> Hello.
> 
> I am evaluating two columns under the same name in two different tables.
> The error I got, "A reference to column "ID" is ambiguous" was expected.
> My code is below. Can I do and INNER JOIN two resolve this error and
> retrieve the correct value? If so , how? I don't have much practice with
> using JOIN.
> 
> Thanks in advance!
> 
> 
>  SELECT Max(id) AS MaxOfID
>  FROM db2admin.tb_assigned,db2admin.tb_complete
> where db2admin.tb_assigned.id = db2admin.tb_complete.id
> 
> 
> 
> 
> 
> #NextPONum#
> 
> --
> 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.
> 
> 
> 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.

Re: OT: CSS

[Eva Holtsmark]

> Anyone have a document/list/URL's of things that "work/don't work"
> on NS4+ and IE4+ browsers?

http://www.webreview.com/wr/pub/guides/style/mastergrid.html
 "The Master List is the mother of all CSS (Cascading Style Sheet) charts, listing 
every aspect of the CSS spec and identifying how well it is supported by Netscape 4.x 
and
Internet Explorer 3.x, 4.x, and 5.x for both Macintosh and Windows 95, and Opera 3.6 
for Windows. "

Eva

--
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: Password Protecting a DB/DSN

[Dave Watts]

> In a shared hosting environment with critical data ...

If it's "critical data", you won't be able to store it in a shared hosting
environment, unless you trust all of the other people with access to that
server. It's as simple as that. It would be really difficult for the ISP to
build sandboxes that a moderately skilled developer couldn't step out of,
even using Advanced Security and turning off CFFILE, CFDIRECTORY, etc.

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: SQL JOIN

[Dave Watts]

> I am evaluating two columns under the same name in two
> different tables. The error I got, "A reference to column
> "ID" is ambiguous" was expected. My code is below. Can I do
> an INNER JOIN two resolve this error and retrieve the correct
> value? If so, how? I don't have much practice with using JOIN.
>
> 
> SELECT Max(id) AS MaxOfID
> FROM db2admin.tb_assigned,db2admin.tb_complete
>   where db2admin.tb_assigned.id = db2admin.tb_complete.id
> 

You'd have the same problem whether you used an ANSI SQL-92 INNER JOIN or
the WHERE clause join you're using now. The problem is that you have two ID
fields, one in each table, and you have to specify which one you want to
retrieve (even though they'll have the same values because of your join):

SELECT MAX(db2admin.db_assigned.id) ...

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: Yet another filesize question

[Dave Watts]

> > i feel so unloved. :)
> 
> Chris, we love you.
> 
> (do they say things like that in the US army?)

No, of course not. In the Army, you'd say "we love you, SIR!"

(former SP4, 3/35 Armor Btn) 
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: SQL JOIN

[Terri Stocke]

You could pull the max ID from each table like this:


 >  SELECT Max(db2admin.tb_assigned.id) AS MaxOfID1,
Max(db2admin.tb_complete.id) AS MaxOfID2
 >  FROM db2admin.tb_assigned,db2admin.tb_complete
 > where db2admin.tb_assigned.id = db2admin.tb_complete.id
 > 
 >
 >  or whatever...

But, I'm unclear as to the relationship between the tables. Will both tables 
necessarily always have the same number of ID's? If so, you can query on 
just one of ID fields instead of both...what exactly are you looking to do?

T


Original Message Follows
From: "James Taavon" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: SQL JOIN
Date: Fri, 25 Aug 2000 10:59:12 -0400

The thing is I need am pulling the ID field from both tables. So should
I just rename one column a differnet name?

Terri Stocke wrote:
 >
 > You need to qualify which table you are pulling the id from, since you 
are
 > using two different tables in your query...
 >
 > 
 >  SELECT Max(tablename.id) AS MaxOfID
 >  FROM db2admin.tb_assigned,db2admin.tb_complete
 > where db2admin.tb_assigned.id = db2admin.tb_complete.id
 > 
 >
 > 
 >
 > Original Message Follows
 > From: "James Taavon" <[EMAIL PROTECTED]>
 > Reply-To: [EMAIL PROTECTED]
 > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
 > Subject: SQL JOIN
 > Date: Fri, 25 Aug 2000 10:44:41 -0400
 >
 > Hello.
 >
 > I am evaluating two columns under the same name in two different tables.
 > The error I got, "A reference to column "ID" is ambiguous" was expected.
 > My code is below. Can I do and INNER JOIN two resolve this error and
 > retrieve the correct value? If so , how? I don't have much practice with
 > using JOIN.
 >
 > Thanks in advance!
 >
 > 
 >  SELECT Max(id) AS MaxOfID
 >  FROM db2admin.tb_assigned,db2admin.tb_complete
 > where db2admin.tb_assigned.id = db2admin.tb_complete.id
 > 
 >
 > 
 >
 > 
 > #NextPONum#
 > 
 > 
--
 > 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.
 >
 > 
 > 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.


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: OT- Program to compare two pages of code for differences

[Sean German]

Larry,

Check out Component Software Diff (CSDiff).  It can compare two files as
well as all the files in two folders.  Available from download.com

HTH


Sean G


-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 5:52 PM
To: [EMAIL PROTECTED]
Subject: OT- Program to compare two pages of code for differences


Does anyone know where I can find a program for comparing two pages of code
for differences?
--
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: SQL JOIN

[Don Vawter]

What exactly do you want. Do you want:
a. the maximum id in tb_assigned
b. the maximum id in tb_complete
c. the maximum id that occurs in either table
d. the maximum id that occurs in both tables

For a or b you wouldn't need a join
for c you would need to run two separate queries and compare maxvalues
for d you query would work if you prefix the id in max(id) with either table
name

- Original Message -
From: "James Taavon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 25, 2000 8:44 AM
Subject: SQL JOIN


> Hello.
>
> I am evaluating two columns under the same name in two different tables.
> The error I got, "A reference to column "ID" is ambiguous" was expected.
> My code is below. Can I do and INNER JOIN two resolve this error and
> retrieve the correct value? If so , how? I don't have much practice with
> using JOIN.
>
> Thanks in advance!
>
>
> 
> SELECT Max(id) AS MaxOfID
> FROM db2admin.tb_assigned,db2admin.tb_complete
> where db2admin.tb_assigned.id = db2admin.tb_complete.id
> 
>
> 
>
>
> 
> #NextPONum#
> 
> --

> 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: Cookies

[Philip Arnold - ASP]

> Hey all, I have a cookie question ...
>
> I was reading an article on Allaire's site, Cookie Considerations and
> Limitations, article 165, and it mentions that there is a maximum of 20
> cookies per domain.
> This surely can't be a *total* can it?  Does this mean that there can only
> be 20 cookies set at any one time?

It's not just number of cookies, but size of cookies... NS has a smaller
limit than IE, but it's still a limit

If you need to use that many cookies, then you're using them for the wrong
reasons
Why not just store one reference in a cookie, and then use that reference in
a database and store the information - this makes it easier for them to
return and re-pick-up if they lose their cookies as well

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.

RE: arraysort

[Philip Arnold - ASP]

> Dana, I know nothing about arrays.
> How could I use this?
> Say I have a DB with 5000 mail address.
> Any pointers would be great.
>
> Is there any thing in the wack book about it?

If you can, always sort in SQL - it's a LOT faster and lighter on the server

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.

Re: Yet another filesize question

[AustralianAccommodation.com Pty. Ltd.]

An I believe the theme song in the army is "Kiss Me Good Night Sergent Major
!!!"

Sorry I could not resist that one

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 26, 2000 1:00 AM
Subject: RE: Yet another filesize question


| > > i feel so unloved. :)
| >
| > Chris, we love you.
| >
| > (do they say things like that in the US army?)
|
| No, of course not. In the Army, you'd say "we love you, SIR!"
|
| (former SP4, 3/35 Armor Btn)
| 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.

--
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: arraysort

[Dana Larose]

> Dana, I know nothing about arrays.
> How could I use this?
> Say I have a DB with 5000 mail address.
> Any pointers would be great.

Well, it depends what you want to go with the email addresses.  If you just
want them ordered, you can probably just use an ORDER BY clause in your
query.  In my experience, CF looping is a little slow, so it's probably best
to let your database do most of the hard work.

What are you trying to do?

>
> Is there any thing in the wack book about it?

Don't think I've heard of the wack book.

Dana Larose
ColdFusion Monkey
Canadian Web Design & Consulting Inc.

A: 701-281 McDermot Avenue (McDermot & King)
P: 204.946.5155
C: 204.228.0477
F: 204.946.5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.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: OT- Program to compare two pages of code for differences

[Jeremy Allen]

I sent this last night ill forward it here.

http://www.meurrens.org/ip-Links/Tools/windiff/windif12.zip

Windiff, based on the GNU utility diff.. works like
a charm.


Also Visual Source Safe has a file comparison utility..


Jeremy Allen
[EMAIL PROTECTED]
[Insert quarter]

-Original Message-
From: Sean German [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 11:10 AM
To: '[EMAIL PROTECTED]'
Subject: RE: OT- Program to compare two pages of code for differences


Larry,

Check out Component Software Diff (CSDiff).  It can compare two files as
well as all the files in two folders.  Available from download.com

HTH


Sean G


-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 5:52 PM
To: [EMAIL PROTECTED]
Subject: OT- Program to compare two pages of code for differences


Does anyone know where I can find a program for comparing two pages of code
for differences?

--
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: cloop and multiple select box

[Philip Arnold - ASP]

> I find this simple, but only get one item to highlight.
>
> I am building a multiple select box from one query.  From another query I
> pull a user account.  I want to highlight those options that the user has
> previously selected while displaying the general list.
>
> It highlights one option, but not for the multiple selections previously
> made by the user:
>
> 
> 
>
>  trim(#C#)>selected>#cat_title#
>
>  

You  to select the code is the problem - you're using IS which implies
one answer

Remember than  returns a comma separates list (as long as
you POST the form), so you should treat it as a list

selected>#Cat_Title#
Should do the trick, although, not knowing your queries, I can't guarantee
it...

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.

RE: SQL UNION across 2 Differnt DSN's

[Philip Arnold - ASP]

> I would like to do a simple select statement, but need to mingle the
> results together for display purposes.  I am trying to merge the
> select from each of two identical tables located on two different
> Oracle DB Servers.  A simple UNION statement can only live under a
> single CFQuery statement (which of course points to a single DSN)
>  any suggestions on an efficient way to do this in CF?

As mentioned in many previous threads, you cannot combine 2 DSNs in one
query

You could try talking to the other databse, but I don't know the Oracle
syntax - it may be the same as SQL Server's one... this is referring to the
table as "database.dbo.table"

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.

RE: netscape taking a long time to render page

[Philip Arnold - ASP]

> hey guys,i've got a page here that is taking a very very long time  to
> render in NS (after it has downloaded) i know its because of some tag
> formating, but i cant seem to find it. all my tables check out as
> far as i
> can tell.. can i get a few more sets of eyes to take a look at the html &
> possibly show me what i've done wrong?
>
> heres the url for the html output of the page thats giving me a problem:
>
> http://www.yarooze.com/kitehigh/testNSproblem.cfm
>
> its actually all cold fusion code, so dont be fooled by the .cfm ext.

Since it gives a CF 404 error, here are some comments about NS rendering
pages

All images without Height or Width will have to start loading before the
page can render the text - unlike IE, it cannot dynamically re-align the
page

All tables with Align= will have to have all information around them loaded
before they can be rendered

All tables within tables have to be rendered before anything below them can
be rendered

Overall, NS is HORRIBLE for layout work, but enforces your HTML to be strict

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.

OLE DB vs. ODBC

[Richard Kuryk]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C00EAA.342889B8
Content-Type: text/plain;
charset="iso-8859-1"

Has anyone done any benchmarks between the two different Database
connections layers?  I know some things don't work through OLE DB but is
there a list or any documentation listing the advantages and disadvantages?


Thank you for any information you can provide.

Rich

--_=_NextPart_001_01C00EAA.342889B8
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






OLE DB vs. ODBC 



Has anyone done any benchmarks between the two =
different Database connections layers?  I know some things don't =
work through OLE DB but is there a list or any documentation listing =
the advantages and disadvantages?  

Thank you for any information you can provide.


Rich




--_=_NextPart_001_01C00EAA.342889B8--
--
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: ColdFusion and Cobalt RAQ

[Nick McClure]

I was doing some research on this a while back I went to the Cobalt site 
and looked in the KnowledgeBase and here is what I found.

Question
Is the RaQ 3i binary compatible with Redhat 6.0, and if so does it support 
Allaire Cold Fusion 4.5 for Linux?

Response
NOTE: UNSUPPORTED. Cobalt Networks currently does not offer support for 
third party software or modified systems. Please contact the appropriate 
software vendor for further assistance. Modifications through root shell 
access could potentially void your warranty. A fee will be assessed by 
Cobalt for fixes or rebuilds on systems with unsupported modifications.

Yes, the RaQ3i is binary compatible with RedHat 6. Although Cobalt has not 
tested Cold Fusion with the RaQ3i, we have received reports from customers 
that it does work.


At 12:15 AM 8/21/2000 -0400, you wrote:
>Anyone had any experience with Cold Fusion and a Cobalt RAQ 3 or 4 server?
>I'm interested to find out what people have come up with trying to get these
>two beasts working together.
>
>Jake
>
>--
>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.

--
Nick McClure[EMAIL PROTECTED]
Technical Director  859.245.9656
squareFish Mediawww.squareFish.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: SQL JOIN

[James Taavon]

The ID field is the number assigned to a certain project. This value
will exist in both tables, but not at the same time. To assign a new
number to a project I need to check the "Current Assignment" table ID
and the "Complete Assignment" ID to make sure that I dont re-assign a
number already used. If the number already exists in the complete table
without my knowledge, then when the "current assignment" table ID gets
passed into the "complete assignment" table ID will result in the
standard SQL error referring to duplicate row values. The goal is to
have this number generated automatically and inserted into the form so I
or anybody else does have to figure out what the last number used was
for a project.

Does that make sense?



Terri Stocke wrote:
> 
> You could pull the max ID from each table like this:
> 
> 
>  >  SELECT Max(db2admin.tb_assigned.id) AS MaxOfID1,
> Max(db2admin.tb_complete.id) AS MaxOfID2
>  >  FROM db2admin.tb_assigned,db2admin.tb_complete
>  > where db2admin.tb_assigned.id = db2admin.tb_complete.id
>  > 
>  >
>  >  or whatever...
> 
> But, I'm unclear as to the relationship between the tables. Will both tables
> necessarily always have the same number of ID's? If so, you can query on
> just one of ID fields instead of both...what exactly are you looking to do?
> 
> T
> 
> Original Message Follows
> From: "James Taavon" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: SQL JOIN
> Date: Fri, 25 Aug 2000 10:59:12 -0400
> 
> The thing is I need am pulling the ID field from both tables. So should
> I just rename one column a differnet name?
> 
> Terri Stocke wrote:
>  >
>  > You need to qualify which table you are pulling the id from, since you
> are
>  > using two different tables in your query...
>  >
>  > 
>  >  SELECT Max(tablename.id) AS MaxOfID
>  >  FROM db2admin.tb_assigned,db2admin.tb_complete
>  > where db2admin.tb_assigned.id = db2admin.tb_complete.id
>  > 
>  >
>  > 
>  >
>  > Original Message Follows
>  > From: "James Taavon" <[EMAIL PROTECTED]>
>  > Reply-To: [EMAIL PROTECTED]
>  > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>  > Subject: SQL JOIN
>  > Date: Fri, 25 Aug 2000 10:44:41 -0400
>  >
>  > Hello.
>  >
>  > I am evaluating two columns under the same name in two different tables.
>  > The error I got, "A reference to column "ID" is ambiguous" was expected.
>  > My code is below. Can I do and INNER JOIN two resolve this error and
>  > retrieve the correct value? If so , how? I don't have much practice with
>  > using JOIN.
>  >
>  > Thanks in advance!
>  >
>  > 
>  >  SELECT Max(id) AS MaxOfID
>  >  FROM db2admin.tb_assigned,db2admin.tb_complete
>  > where db2admin.tb_assigned.id = db2admin.tb_complete.id
>  > 
>  >
>  > 
>  >
>  > 
>  > #NextPONum#
>  > 
>  >
> --
>  > 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.
>  >
>  > 
>  > 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.
> 
> 
> 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.

RE: Grab image size with CFFile object attributes

[lsellers]

>
> Question, you can grab a file size in a CFFile tag when you upload a
> file/image but can you also grab the image height and width?
>
> I could guess but I'm not entirely sure. It makes sense to have something
> like this.

Personally I use CFX_ImageInfo,
http://www.intrafoundation.com/freeware.html. But then I wrote it, so you'd
expect that, eh? :)

--min

--
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: SQL JOIN

[Brandon Behrens]

Hey guys,

Can anyone help me with this problem?  I need to send an email in text
format.  I also next to attach an HTML file.  The HML file needs to be
created when I am sending the email and contain a link that I generate on
the fly.  Any ideas?

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.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: ColdFusion Server-side Source Control

[Truman Esmond III]

Hmmm... That's where I seem to be heading as well.  :(  Good idea, not so
good implementation.
I'm going to poke around a bit more - I'll let everyone know if I get it to
work.
Thanks for the feedback
Truman

-Original Message-
From: Milks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 7:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: ColdFusion Server-side Source Control


Yes I have some experience, and my conclusion is STAY AWAY!
Vss and CF just don't seem to integrate well. We thought we had it solved,
until we lost a day's worth of development. Our final conclusion was to
simply run CF and VSS seperately and use Alt + Tab a lot.
I would agree that the multiple projects appear to be the issue, but we
never had enough time to invest in trying to solve it...

Good luck..


JM

-Original Message-
From: Truman Esmond III
To: [EMAIL PROTECTED]
Sent: 24/08/00 7:43 PM
Subject: ColdFusion Server-side Source Control


Okay, I've spent enough time spinning my wheels on this by myself - any
help
is appreciated :)

Anyone successfully implemented server-side source control through CF?
Found better docs somewhere on this feature within CF?

We've got source control set up through studio, but we're trying to have
an
internal development server connect to a client's VSS db, and have all
of
our local developers use RDS locally on that machine for this effort -
the
problem seemingly lies in that there are multiple projects and multiple
working directories.  The form in the CFAdmin only allows a single DB to
be
connected (and is kinda vague about exactly which .ini file to connect
to)
and only a single working directory.
Any experiences, configurations and references to other documentation
would
be greatly appreciated!

Secondly and similarly, has anyone tried using the CF server-side source
control or even studio integrated source control using SourceGear's
SourceOffSite? Looks like it *should* work the same (only faster) since
their based on the same API...

Truman


--
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: SQL JOIN

[Deanna L. Schneider]

Okay, what I would say first is that you probably have some referential
integrity problems, as the two tables are dependent on each other, and the
completed table shouldn't have any id's in it that haven't already been used
in the current table. But, if you must do this...here's one solution. It's
not the most elegant, and depending on your db, you could probably do this
easier with triggers or something.



SELECT max(c.id) AS maxid
FROMcurrentassingmenttable c





Selectp.id
fromcompletetable p
WHERE p.id = #newid#



Oops, that id was already used! You have to decide what you want to do if
the id was already used...incrementwhat?


Does that get you started?
-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: REGISTRATION CLOSES TODAY!

[Peter Theobald]

Will session notes (or even a videotape?) be made available after the seminar?
(Even if we have to purchase them)

At 10:47 AM 8/25/00 -0400, Mike Deane wrote:
>I can't make it to this, if I weren't under unbearable deadline
>pressures I would be there in a heart beat.  Adam, any chance that
>DBblocks,v2 will be available for download soon?
>
>Thanks.
>/mdeane
>
>-Original Message-
>From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]]
>Sent: Friday, August 25, 2000 10:40 AM
>To: [EMAIL PROTECTED]
>Subject: REGISTRATION CLOSES TODAY!
>
>
>***  REGISTRATION CLOSES TODAY! 
>
>***  Advance Registration Only -- No On-Site Registration
>***  CFUG Members Get In For Less Than Half-Price! (see below) 
>***  All Attendees Get Free CommerceBlocks Software
>***  Memphis AirTran Flights and Hotel Rooms Are Cheap
>***  You Know You Really Want To Attend...
>
>ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR
>
>Okay... 
>
>You all know how great this thing is going to be next week, and how much
>you really want it and need it.  If your boss won't pay for it then fund
>it
>yourself, quit when you get back, and find a job for more money with a
>company that "gets it."
>
>Three full days of exactly what you need to know to not only build
>killer
>ecommerce apps, but killer ColdFusion apps in general.  There's a
>database
>design course built right in, too.  When you're done, you get all the
>example code and free CommerceBlocks software.
>
>Remember:
>
>-- $195.00* for a three day, chef catered, materials heavy seminar with
>free software you can really use is incredibly cheap (it's below our
>cost).
>
>-- AirTran and other airlines' ticket prices are dirt cheap, as are
>hotel
>rooms in Memphis (see the Memphis travel and lodging links on
>www.coldfusionseminar.com)
>
>-- This seminar series is already booked through June 2001, so don't
>wait
>for it to come to your area.
>
>-- As of this writing we have only 20 seats left.
>
>For complete details and to register, go to www.ColdFusionSeminar.com.
>
>Be there!
>
>* Email [EMAIL PROTECTED] with your request for a
>$195.00
>Special Price Seminar Pass, and we'll send you one right away.
>
>
>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.
>--
>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

--
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: REGISTRATION CLOSES TODAY!

[Peter Theobald]

Will session notes (or even a videotape?) be made available
after the seminar?
(Even if we have to purchase them)

At 10:47 AM 8/25/00 -0400, Mike Deane wrote:
I can't make it to this, if I weren't under
unbearable deadline
pressures I would be there in a heart beat.  Adam, any chance
that
DBblocks,v2 will be available for download soon?

Thanks.
/mdeane

-Original Message-
From: Adam Phillip Churvis
[mailto:[EMAIL PROTECTED]" 
eudora="autourl">mailto:[EMAIL PROTECTED]]
Sent: Friday, August 25, 2000 10:40 AM
To: [EMAIL PROTECTED]
Subject: REGISTRATION CLOSES TODAY!


***  REGISTRATION CLOSES TODAY! 

***  Advance Registration Only -- No On-Site Registration
***  CFUG Members Get In For Less Than Half-Price! (see below) 

***  All Attendees Get Free CommerceBlocks Software
***  Memphis AirTran Flights and Hotel Rooms Are Cheap
***  You Know You Really Want To Attend...

ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR

Okay... 

You all know how great this thing is going to be next week, and how
much
you really want it and need it.  If your boss won't pay for it then
fund
it
yourself, quit when you get back, and find a job for more money with
a
company that "gets it."

Three full days of exactly what you need to know to not only build
killer
ecommerce apps, but killer ColdFusion apps in general.  There's
a
database
design course built right in, too.  When you're done, you get all
the
example code and free CommerceBlocks software.

Remember:

-- $195.00* for a three day, chef catered, materials heavy seminar
with
free software you can really use is incredibly cheap (it's below 
our
cost).

-- AirTran and other airlines' ticket prices are dirt cheap, as are
hotel
rooms in Memphis (see the Memphis travel and lodging links on
http://www.coldfusionseminar.com/" 
eudora="autourl">www.coldfusionseminar.com)

-- This seminar series is already booked through June 2001, so 
don't
wait
for it to come to your area.

-- As of this writing we have only 20 seats left.

For complete details and to register, go to
http://www.coldfusionseminar.com/" 
eudora="autourl">www.ColdFusionSeminar.com.

Be there!

* Email [EMAIL PROTECTED] with your request for a
$195.00
Special Price Seminar Pass, and we'll send you one right away.


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  /" 
eudora="autourl">http://www.commerceblocks.com ;
 E-mail:
[EMAIL PROTECTED] *
* Phone:  
770-446-8866   
Fax:    770-242-0410
*
*
*




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


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Session timeout?

[Joseph Eugene]

This is a multi-part message in MIME format.

--=_NextPart_000_0021_01C00E93.8B251AE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thanks guys,
Here is my scenario, i have a custom server =
application
that protects my directory.So, the first time the user hits the page.. =
will be
asked for userid and password.This gets written in CGI.Auth_user(winnt =
log files).
I grab the userid and set all the application or session variables.
So in this particular case, when a session expires, =
a new session is=20
automatically created.What i really need is to, some how verify whether =
this
particular session has expired.
Some like

   


I cant verify for session variables cause a new =
session
is dynamically created and new session variables get instanciated.

Appretiate any help..

Thanks
Joe

--=_NextPart_000_0021_01C00E93.8B251AE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Thanks=20
guys,  &nbs=
p;=20
Here is my scenario, i have a custom server applicationthat protects =
my=20
directory.So, the first time the user hits the page.. will beasked =
for=20
userid and password.This gets written in CGI.Auth_user(winnt log=20
files).
I grab the userid and set all the application =
or=20
session=20
variables.  =
; =20
So in this particular case, when a session expires, a new session is=20

automatically created.What i really need is =
to, some=20
how verify whether thisparticular session has=20
expired.  &=
nbsp;=20
Some=20
like   =
;=20
  &nbs=
p;=
;   =20
&n=
bsp;  =20
&nbs=
p;  =20
I cant verify for session variables cause a new sessionis =
dynamically=20
created and new session variables get=20
instanciated.&nbs=
p;  =20
Appretiate any=20
help..  =
; =20
Thanks  &nb=
sp;=20
Joe

--=_NextPart_000_0021_01C00E93.8B251AE0--

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

questions about "cachedwithin"

[Todd Ashworth]

To paraphrase the CFWACK:

'The ColdFusion caching logic takes , , and other dynamic
structures in queries into account, ensuring that caching is safe to use
within a dynamic environment.'

OK .. Say I have



SELECT field1
FROM table
WHERE field2 = '#Variables.index#'



I'm assuming in this scenario I will end up with 10 different cached queries
... or would all of the queries overwrite each other because they all have
the same name?

Also, does anyone know how much overhead is associated with removing the
oldest cached query from memory and replacing it with the newest when the
limit is reached?  I'm guessing even if it has to be done a lot, it's still
faster than than hitting the database for 15 rows of data, every single
time.

Todd Ashworth


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

Fw: Please hack me, others are....

[Mooner Ent]

 John,
>
> I knew I forgot something :-)
>
> The English site has the game, but we had to reverse program it, so they
> aren't really the same. If it helps http://www.thesimpsons.com
>
> Otherwise I've included some translations for you to get to the code part,
> that I'm sure you can read.
>
> Start At:
>
http://www.lossimpson.com/SIM/spanish/MUNDIAL/BARTBOWL/index.cfm?fa=registra
> tion
>
> You can register as many times as you need to help me find the hole. You
can
> even but in bogus registration information.
>
> Nombre = Name
> Apellidos = Last Name
> Fecha de Nacimiento:   =  00/00/2000
> Pais: = country
> email = email (can be bogus)
> contrasena: = password
> pregunta: = answer to question you can put in a word.
>
> Then it will send you back to the log in page.
> http://www.lossimpson.com/SIM/spanish/MUNDIAL/BARTBOWL/index.cfm
> Put in your email and password.
>
> Now you'll see a launch page: If you want to see top scores click on the
> link that reads tablero de ganadores.
>
> If you have flash 4 click on the flash movie that says Bart Bowl. A pop up
> window will appear. Click on the big blue button "jugar" = "play game".
>
> The question will come up, and you can guess at the correct ones, after
each
> of the five question you'll be taken to a flash screen telling you if your
> answer is right, then click on the blue button "continuar".
>
> PS I'm not using cookies.
>
> TIA
>
> Rick
>
>


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.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.