RE: OT- Program to compare two pages of code for differences

2000-08-25 Thread 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.



cluster cats confusing client sessions?

2000-08-17 Thread Sean German

Howdy,

Over the past couple days I've had several instances of members of my site
seeing account information of other members.  

I have a members-only service to which visitors log in with a user name and
password.  I keep track of the visitors identity and membership status with
client variables referenced to cftoken and cfid either in a cookie or in a
url.variable for those running without cookies.

We've been up for about two years and never had this type of issue before
the last week or so.  The only event I can come up with that roughly
correlates to the onset of the issue is a period last week of higher than
usual traffic that caused Cluster Cats to load-balance a lot of folks to our
back up server.

The best I've been able to come up with is something along the lines of User
1 comes in to Server 1 and gets assigned to Session A.  User 2 comes in to
the back up, Server 2, which keeps its own session count and gives User 2
Session A.  User 2 then returns to the site during a period of less
activity, is identified by Server 1 as Session A and is associated with User
1.

Makes sense?  Of course not.  The client variables are stored in a single
central db used by both servers.  So even if someone was redirected to a
backup server mid-session, the system should keep their identity straight.
(I've since enabled session aware load management in Cluster Cats.)

Any ideas?  While we don't anything as critical as credit card data online,
this is a very not good thing to have happen.

BTW, running CF 4.0.1 on NT4 SP5 with Cluster Cats build 356, MS SQL7 SP2

TIA!!


Sean 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: Airport Code Database

2000-08-17 Thread Sean German


Oh, btw http://flyaow.com/citycode.htm is an international list,
alphabetical by city name and 3 letter code.

HTH,

Sean G.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 12:12 PM
To: Cf-Talk
Subject: Airport Code Database


I have an application that requires that I offer a listing of airports and
their associated codes. Does anyone have a tag or know of a source for the
data so I can build my own tag?

Thanks,
Scott


Scott Brader
USAV Group
5485 South Westridge Drive
PO Box 510620
New Berlin, WI 53151-0620
Phone: 262.814.2000
Fax: 262.814.2006

Amateurs Practice Until They Get It Right,
Experts Practice Until They Can't Get It Wrong

Any opinions expressed herein are mine and are not representative of USAV
Communications Group.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
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: Airport Code Database

2000-08-17 Thread Sean German

Howdy,

An alternate source, just for giggles:

http://flyaow.com/citycode.htm


Sean G.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 12:12 PM
To: Cf-Talk
Subject: Airport Code Database


I have an application that requires that I offer a listing of airports and
their associated codes. Does anyone have a tag or know of a source for the
data so I can build my own tag?

Thanks,
Scott


Scott Brader
USAV Group
5485 South Westridge Drive
PO Box 510620
New Berlin, WI 53151-0620
Phone: 262.814.2000
Fax: 262.814.2006

Amateurs Practice Until They Get It Right,
Experts Practice Until They Can't Get It Wrong

Any opinions expressed herein are mine and are not representative of USAV
Communications Group.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
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: Comma/Number Problem

2000-08-10 Thread Sean German

K,

Fair enough.  The expression removes all characters that aren't a digit or
decimal point(0-9 or .).  

rereplace(vartocleanup, "[^0-9\.]+", "", "ALL")

Whether you prefer that or Don's newstring=replace(oldstring,",","","ALL")
depends on the source of the numbers.  If you have some legacy data or other
controlled source where you know the only issue will be commas, Don's
replace will do ya just fine.  If there's a chance you might face other
non-numeric characters (currency symbols, etc.), the rereplace would be more
appropriate.  Right tool for the job and all that.

HTH,


Sean G.


-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 4:09 PM
To: [EMAIL PROTECTED]
Subject: RE: Comma/Number Problem


No offense to you Shawn but with new people, which he obvioulsy is as he
doesn't know about replace, you should probably explain what this does
instead of just supplying it.

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



RE: Comma/Number Problem

2000-08-10 Thread Sean German

This is something I've picked up from this list.

cleanNumber = rereplace(vartocleanup, "[^0-9\.]+", "", "ALL")



HTH,,

Sean G.


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 3:24 PM
To: [EMAIL PROTECTED]
Subject: Comma/Number Problem


Hi,

I am trying to add a bunch of numbers to get a total value. It works fine 
unless someone uses a comma to separate 'thousands':

Ex. 10,500

How do I get rid of the comma before I add it up??

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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: Parsing URLs on IIS 4

2000-07-25 Thread Sean German

There are post-SP5 fixes other than SP6 that can have this affect.  (What is
an MS SP but a collection of fixes released since the last SP?)

I know the Ogle utility has this affect, as well as the (iirc) malformed
HTTP request header fix.

My impression that the use of slash-delimited query strings with IIS4 was
taking advantage of a vulnerability 'feature' .


HTH

Sean G.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 7:18 AM
To: [EMAIL PROTECTED]
Subject: Parsing URLs on IIS 4


Can anyone suggest what settings in IIS 4 / SP5 could cause problems with 
slash-delimited query strings?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
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 and CFELSE

2000-07-13 Thread Sean German

Howdy,

CF won't let you seperate cfform and /cfform so both opening and closing
tags need to be in the same branch of the cfif logic.  For example,


cfif CONDITION
cfform action=true_action method=
/cfform
cfelse
cfform action=false_action method=
/cfform
/cfif


Or you can do something like this,

cfform method=
cfif CONDITION
action=true_action
cfelse
action=false_action
/cfif
/cfform


But you cannot do this,

cfif CONDITION
cfform
cfelse
cfform
/cfif

/cfform


HTH


Sean.





-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 13, 2000 11:40 AM
To: [EMAIL PROTECTED]
Subject: CFIF and CFELSE


This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_2C7475F2.A6C7A9E6
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

There Must be something I don't know about CFIF.  I want to check if a URL =
variable exists.  If it does, I want to add the same variable to the URL =
of the action of a CFForm, basically so I can check for it on the action =
page, and use it to re-route a cflocation. =20

Here's the problem.  I have a CFIF that, if it's true, starts a CFFORM =
with the URL variable included in the action, then it has a CFELSE that =
starts the same form, just without the URL variable.  Problem is, it =
doesn't work.  Tells me that there's an extraneous  at the bottom =
of the template.  Basically, whether or not the criterion is met, it =
doesn't start the form. =20

I musta missed something about CFIF, CFELSE, or CFFORM.  Any Ideas?  =
Here's my logic:




   
  
   =

 


Whether myvariable exists or not it doesn't print either of the cfform =
lines.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



cahcing results of a stored procedure

2000-06-29 Thread Sean German

Howdy,

Is there a method of caching the result set of a  &
 analogous to ?

TIA

Sean G.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: CFFILE Accept

2000-06-16 Thread Sean German

Howdy,

I don't think you can stop CFFILE, but you can manage the page after the
cffile action.








HTH,

Sean

-Original Message-
From: Double Down, Inc [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 08, 2000 6:45 PM
To: [EMAIL PROTECTED]
Subject: CFFILE Accept


This is a multi-part message in MIME format.

--=_NextPart_000_0008_01BFD160.7CDD3280
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Trying to set the accept attribute in CFFILE to only accept .jpg and .gif
 
Can someone tell me how to do this.
 
TIA
 
DDINC
 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Is there a typical cause for this error message?

2000-06-01 Thread Sean German

Yes,

A typical cause is the data being inserted too long.  Check the length of
the column in the database and your data validation.

HTH

Sean


-Original Message-
From: Steve Weiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 01, 2000 10:43 AM
To: '[EMAIL PROTECTED]'
Subject: Is there a typical cause for this error message?


Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 22001 (String data right truncation)

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: returning autoID after insert [sql] [tip]

2000-05-25 Thread Sean German

Sorry, that was supposed to go back to myself and into my tip folder and not
out to the group.  *blush*


When struggling with a piece of code that just won't behave, take a step
back and look at the bigger picture.  Has the data been validated?  Are
logical operands grouped properly?  (AND and NOT are evaluated before OR in
a single expression.  Expressions in parentheses are evaluated first.)  Is
the issue a version-specific feature not specific to your version of the
software?  Are you making changes in the dev environment and then looking in
production for the changes?  (Well, maybe that's just me.)



-Original Message-----
From: Sean German [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 9:47 AM
To: '[EMAIL PROTECTED]'
Subject: returning autoID after insert [sql] [tip]


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



returning autoID after insert [sql] [tip]

2000-05-25 Thread Sean German



-Original Message-
From: Tom Nunamaker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 3:21 AM
To: [EMAIL PROTECTED]
Subject: Re: Avoiding using the MAX function


In SQL server, you can do this:

CREATE TRIGGER GetMax_ID ON mytable
FOR INSERT
AS
SELECT mytable_ID FROM INSERTED

When you run your query to do the INSERT, the trigger will
fire and return the mytable_ID of the inserted record for you.

Tom

Robert Everland wrote:
> 
> WHy not use a trigger?
> 
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
> 
> -Original Message-
> From: Olive, Christopher M Mr USACHPPM
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 24, 2000 1:08 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Avoiding using the MAX function
> 
> yes, if you call a stored procedure to insert the record, and reference
the
> @@IDENTITY property after the SP call.
> 
> Chris Olive
> DOHRS Website Administrator
> [EMAIL PROTECTED]
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 24, 2000 12:45 PM
> To: Cf-Talk
> Subject: Avoiding using the MAX function
> 
> Hi Everyone,
> 
> At the CFUG-orama in Washington DC last week, I think Ben Forta said that
> there is a way to avoid having to use the "MAX()" SQL function to get the
ID
> number of the item you just inserted into a database.  Can anyone tell me
> how to do this?
> 
> In other words, currently I'm doing something like this:
> 
> 
> INSERT INTO tablename  (x,y,z)
> values ('x','y','z')
> 
> 
> Then, to get the autonumber'ed ID of the item I just inserted, I'll use:
> 
> 
> Select Max(ID) as the_newest_record
> >From Tablename
> 
> 
> Now I'll have the ID number of the newest inserted record in
> #get_the_newest_record.newest_record#.
> 
> If I understood Ben correctly, then there is a way to insert the record
AND
> return the ID number of that inserted record all at the same time.
> 
> The database in question is a SQL Server database.  (Although it would be
> good to know how to do it with MS Access if its possible).
> 
> Thanks,
> 
> Eron
> 
>

> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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.eGroups.com/list/cf-talk
> To Unsubscribe visit
> 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.eGroups.com/list/cf-talk
> To Unsubscribe visit
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.eGroups.com/list/cf-talk
To Unsubscribe visit
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.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: in consideration of large arrays?

2000-05-23 Thread Sean German

Nevermind :)

FOund what I was looking for.


Sean


-Original Message-
From: Sean German [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 22, 2000 8:45 PM
To: '[EMAIL PROTECTED]'
Subject: in consideration of large arrays?


Howdy fusioneers,

I know theoretically the size of an array is limited by the available
memory, but what other considerations need to be made when working with
large arrays?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: CFCONTENT and SP6A

2000-05-23 Thread Sean German

Riddle me this Mr Watts,

My server seems to have gone from parsing URLs from the left to parsing from
the right.  (NT4 SP5 IIS4 CF 4.0.1)  While neither SP6 nor 6a has been
applied, I have applied post-SP5 hot fixes.  And what's an MS SP but the
same ole hot fixes in a new package?

So do we know which particular facet of SP6 changes the parsing order?  Are
there any other methods of (intentionally or unintentionally) affecting the
parse order?


T again IA


Sean
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 22, 2000 1:43 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: CFCONTENT and SP6A


> I was wondering if you could explain your comment about the
> direction it parses the URL - I don't quite understand what
> the issue involved is.

If the URL is parsed from left to right by the server, it will stop at the
first valid file name it finds, and treat everything after that file name as
URL parameter data. For example, with this URL:

http://www.myserver.com/myfile.cfm/myfile.csv

the server will go to myfile.cfm, passing myfile.csv as URL data to it. This
trick allows you to execute one file, myfile.cfm, while making the browser
think it's asking for myfile.csv.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



in consideration of large arrays?

2000-05-22 Thread Sean German

Howdy fusioneers,

I know theoretically the size of an array is limited by the available
memory, but what other considerations need to be made when working with
large arrays?

I have a template that works with an array of about 6000 elements.  No
matter for how long I set the time out, the dern thing still conks out after
a few minutes.

The available physical memory doesn't go below 180K running CF 4.0.1 on NT4,
SP5, IIS 4.  The code is good and was running in production until a couple
weeks ago.  At some point the database outgrew the methods.

Any hints, suggestions, or job offers?  And will the server setting time out
limit override a url ?timeoutrequest= or the other way around?

TIA


Sean
[EMAIL PROTECTED]




This isn't too complicated but seems to be one of the frequenty asked
questions.

You cannot do this:









Bad form to break up the form tags.

But you can do this:


some action

some other action

>


















--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: IIS set up passing variables in the path_info?

2000-05-11 Thread Sean German

Thanks Paul,

Looks like we're working along the same lines, except we're adding .htm to
the variable to get indexed by search engines that don't spider .cfm pages.
So I link to page.cfm/variable.htm

My trouble is my development box takes this url and knows to pull up
page.cfm, while my production boxes are looking for varbiable.htm.  With IIS
4, is this controlled by an ISAPI filter or application mapping?  We didn't
change the configuration to get his working in development, so I'm coming up
short on what I need to do to get it going in production.

Argh.

Thanks again,

Sean
[EMAIL PROTECTED]


BTW,  to those contributing to the OT: Lighten things up a little thread,
you are all disturbed people, and I respect you for  it.  =)





 








When you're installing (or re-installing) the latest MDAC from MS, remember
to stop any related non-essential services.  Components that are in use will
not be updated, but you will not receive any warning or message that the
installation was not complete.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 11, 2000 1:11 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS set up passing variables in the path_info?


I do the same at www.support.net using

 

in act_globals.cfm

best,  paul


At 09:42 PM 5/10/00 -0400, you wrote:
>Howdy,
>
>I've set up my site to pass variables like so,
>http://www.mycompany.com/page.cfm/variable.htm
>
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



IIS set up passing variables in the path_info?

2000-05-10 Thread Sean German

Howdy,

I've set up my site to pass variables like so,
http://www.mycompany.com/page.cfm/variable.htm

Then at the top of page.cfm I have a little ditty to look for htm in the
cgi.path_info and fish out the variable.

This is working on my test servers, but not in production, where I get an
ugly 404.  NT 4 SP5 IIS4 CF 4.0.1.  The only difference I can think of is
the production servers run Cluster Cats, build 356.

Maybe it's my brain rebeling for working through 90210, but I'm not making
progress.

Any ideas?

TIA,


Sean
[EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Integrity constraint violation on session table?

2000-04-13 Thread Sean German

Howdy,

CF 4.0.1 on NT 4 SP5, MS SQL7 SP2 in back.  

Storing client variables in a database, I started getting the following
error in the application.log about a month ago:

"Error","TID=496","04/12/00","16:01:31","206.33.238.2","Mozilla/4.7
(Macintosh; I; PPC)","ODBC Error Code = 23000 (Integrity constraint
violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert
duplicate key row in object 'CDATA' with unique index 'id1'.Date/Time:
04/12/00 16:01:31

This error is usually followed by the entire cluster crashing (the load on
each machine gradually increases until none are available).  Restarting the
CF Application Server service on the machine that logged the error gets
everything back to normal.

What does it mean?  I'm extra confused because the CDATA table doesn't have
any keys defined.

TIA


Sean
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: getting fields of a table(sql)

2000-04-07 Thread Sean German

Joe,

SELECT  syscolumns.name
FROMsyscolumns INNER JOIN sysobjects ON sysobjects.id =
syscolumns.id
WHERE   sysobjects.name = "Your_Table_Name"

HTH,

Sean.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 5:05 PM
To: [EMAIL PROTECTED]
Subject: getting fields of a table(sql)



Hello All,
  Is there a way/sql statement that would get me all
the fields in the table? and store it in a variable ?
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: Captupturing Form Elements

2000-04-06 Thread Sean German

Is there an analogous solution to looping through the fields of a query?

-Original Message-
From: Brian Peddle [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 06, 2000 10:51 AM
To: [EMAIL PROTECTED]
Subject: Re: Captupturing Form Elements


You can loop over all the fieldnames submitted:



Put whatever processing on the fieldnames you need here

 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: 237 checkboxes

2000-03-29 Thread Sean German

H.

You could give each checkbox the same name (ex/ yes_no) with incrimental
values (1,2,3,...237).  The result is a single variable, form.yes_no, to
define.  The plus side is the result is a list you can just search for the
yeses (boxes that were checked).  The minus side is the result is a list you
have to search for the yeses.

If each checkbox has a different name, you can loop through form fields with
something like:


#evaluate('form.' & field_name)#



HTH,

Sean

-Original Message-
From: Daniel Murphy [mailto:[EMAIL PROTECTED]]


I have search form that contains a large amount of yes/no check boxes -237
to be exact. It is to search the results of a survey that has 237 questions.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
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: mail server requires password

2000-03-28 Thread Sean German

Howdy,

The general consensus is you can't, however I have a similar set up (SMTP
requires username/password) and the CF Application Server service is set to
log on as an account with send mail permissions, and CFMail gets out.

Also explore the possibility of having two IPs open for sending mail; one
accessible from the network that requires authentication, and one private IP
protected by firewall, for example, but open to the CF server that does not
require authentication.

YMMV,

Sean.


-Original Message-
From: Christopher P. Maher [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 9:59 PM
To: MailingList CF-Talk
Subject: mail server requires password


I've changed mail server software and have things configured so that the
mail server requires a username/password to send mail. I have several
applications that use CFMail but they no longer work because the mail server
wants a password. How can I send the username/password to the mail server
with CFMail?

Thanks,

Chris

---
Christopher P. Maher
mailto:[EMAIL PROTECTED]
Maher Associates, Inc.
Actuarial and Computer Consulting
http://www.maherassociates.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
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.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.