Fw: CFQuery of database tables

[Winston Sia]

This is a multi-part message in MIME format.

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

Hi,

I'm would like to make a query to each database table, with a "select *" =
to output all records. I am going to use CFTABLE to output the results. =
Is there any way I can do this wihtout having to specify one by one the =
column/field names of that table?

I am trying to do this since I want to display or output the whole =
contents of all the tables in my database, which I am going to transfer =
to Excel sheet.

You see, the data I want to get is on IBM DB2, which I want to export to =
my local SQL database. And the DB2 is remote, and I have no access to =
it. I want to populate my local SQL database with the data on the IBM =
DB2 database.

We already requested for a comma-delimited text file of all the data of =
all the tables of our database, but the DB admin is not responding. So I =
am now trying to just get the data ourselves using CF.. manually.

Immediate help will be very much appreciated.

Thanks,
Winston

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









Hi,
 
I'm would like to make a query to each database =
table,=20
with a "select *" to output all records. I am going to use CFTABLE to =
output the=20
results. Is there any way I can do this wihtout having to specify one by =
one the=20
column/field names of that table?
 
I am trying to do this since I want to display =
or output=20
the whole contents of all the tables in my database, which I am going to =

transfer to Excel sheet.
 
You see, the data I want to get is on IBM DB2, =
which I=20
want to export to my local SQL database. And the DB2 is remote, and I =
have no=20
access to it. I want to populate my local SQL database with the data on =
the IBM=20
DB2 database.
 
We already requested for a comma-delimited text =
file of=20
all the data of all the tables of our database, but the DB admin is not=20
responding. So I am now trying to just get the data ourselves using CF.. =

manually.
 
Immediate help will be very much =
appreciated.
 
Thanks,
Winston

--=_NextPart_000_020E_01C0A1A1.B3261D40--


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

OT: xml ms lib menu tree?

[moonerent]

Hello,

Is the source code for the menu tree found at
http://msdn.microsoft.com/library/default.asp available?

I have a very large xml doc I need to load in small sections, based on what
part of the tree the user clicks on. The aforementioned menu tree does that.

TIA,

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

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

Stumped !

[Jim Mixon]

quite frankly I am stumped . . . hopefully I can explain this properly here 
.. . . and get some needed help . . .

Certain fields in a form are dynamically generated, according to the number 
of entries in a table . . .

Each dynamically generated field, i am presuming, needs to have its own 
field name(name="uniquename">

so I have each field being created with a "name="sameword#number#" where 
the number changes with each new field sequentially by adding 1.

since the submitting form fieldname is not yet known to the processing 
page, how can I get that data into the designated table using the INSERT 
query . . .?

I can certainly recreate the needed names in the processing page, but that 
involves a variable which doesnt seem to work in this case . . .

creating a variable to act as a "form.variable-instead-of-fieldname" just 
wont work for me . . .

the idea is that the user form would never need updating because it 
supplies fields to the user based on entries in another table . . totally 
dynamic . . .

each formfield subsequently needs to create its own record in another table 
.. .

perhaps this is just not doable using CF and SQL alone?


Jim Mixon - CEO
APT POINT NET, Inc. "A Premiere InterNET Gateway" . . .
[EMAIL PROTECTED]   http://www.apt.net/
PO Box 160217 Hialeah, FL 33016 305-821-8451
FAX (305) 821-8189 auto-switching FAX
powered by Cold Fusion 4.01 . . . . feel the force!
CF Hosting Now Available . . . . ! 

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

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

Re: Voice XML

[moonerent]

Paul,

http://www.wirelessdevnet.com/channels/voice/training/voicexmloverview.html

Rick


- Original Message -
From: "Paul Campano" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 26, 2001 8:54 PM
Subject: Voice XML


> Does anyone have sample code using CF and Voice XML, specfically code to
query a database and use the results?.  I
> have been to studio.tellme.com, but they only give example code in Perl
and ASP.  Thanks.
>
> Paul Campano
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Slightly OT: SQL "Mode" function?

[David Shadovitz]

In CF, I'd use ValueList to put the database field's values into a list, then 
use ListValueCount to see how many times each value occurs, and then use Max to 
get the largest count.  Finally, you'd look back in the list to grab the value 
which had that max count.

Not a bad idea for a custom tag or a UDF.

-David

On Tuesday, February 27, 2001 1:24 PM, Albert, Gregory Mitchell (Greg)** CTR ** 
[SMTP:[EMAIL PROTECTED]] wrote:
> Does anyone know of a way to get the mode (the most frequently occuring
> number) for a column? I didn't see any sort of SQL function for this, but it
> would be a useful function, if someone had an idea of how to do it with CF.


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

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

RE: pie chart

[David Shadovitz]

CF comes with a pie chart Java applet.  Check out the CF 3.1 documentation on 
the bar and pie chart "graphlets" at 
http://telecom.fit.edu/cfdocs/user/ug20.htm.  (Thanks to Al Musella for tipping 
me off to this.)

-David

On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] 
wrote:
> www.cfxgraphicsserver.com

> - Original Message -
> From: "Mak Wing Lok" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 27, 2001 4:38 PM
> Subject: pie chart
> >
> > anyone knows any nice and cool pie chart custom tags?

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

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

Problem with logging in

[JAIME HOI]

The problem is wif the logging in process. Some users are not able to log in
.. Error displayed being "Page not Found". Do u have any idea what caused the
error??

Code :
-Verify user 








 to the menu page.  





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

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

Is anyone aware of a CF solution like this

[Parker, Kevin]

http://www.portalscripts.com/Commercial_Scripts/ODP__/version_3_x/version_3_
x.shtml


+
Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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

+




This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


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

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

Re: CFFTP error

[Jim McAtee]

Don't know if this has anything to do with your error, but do you really
want to give a directory name if you've already done a "ChangeDir" to the
directory where you're requesting the listing?  I'd think that it would try
to get a listing of a subdirectory named ILS70PTT located in ILS70PTT.

Jim


- Original Message -
From: "Mak Wing Lok" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 9:31 PM
Subject: CFFTP error


> hi all,
>
> i encountered the following error :
>
> Error Diagnostic Information
> 200 PORT subcommand request successful.
>
> The error occurred while processing an element with a general identifier
of
> (CFFTP), occupying document position (26:1) to (26:99).
>
> the CF codes :
>
>   username="MS007"
>  connection="myftp"
>  password="MS007"
>  server="100.100.100.34"
>  stoponerror="Yes">
>
>   username="MS007"
>  connection="myftp"
>  password="MS007"
>  server="100.100.100.34"
>  directory="ILS70PTT"
>  stoponerror="Yes">
>
> line 26 :
>  connection="myftp">
> 
>  #name# 
> 
>
> fyi, i tried to ftp into an AS400 server.
>
> what could be causing this error? any idea?


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

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

CFFTP error

[Mak Wing Lok]

hi all,

i encountered the following error :

Error Diagnostic Information
200 PORT subcommand request successful.

The error occurred while processing an element with a general identifier of
(CFFTP), occupying document position (26:1) to (26:99).

the CF codes :





line 26 :


 #name# 


fyi, i tried to ftp into an AS400 server.

what could be causing this error? any idea?



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

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

RE: WDVL Poll

[Dave Watts]

> I want to add here, that the original version of CF was 
> implemented as a CGI program. I was under the impression 
> that the version for some of the less widely used operating 
> systems (Unix?) still operate that way. Is this the case?

CF can be used as a CGI program with any web server on Windows or Solaris.
The list of "official CF-supported" web servers includes only those with
which API integration is supported.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

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

Building Cold Fusion Search - Dynamic SQL

[Sheila Handler]

Kim,

The input from the multiple select will be the 2 (or more) skills selected
"skill1,skill2".
Since this is a list, why not loop thru it to construct dynamic sql that
ANDs the skills:


SELECT e.empId,es.skillId
  from emp e,empSkills es
  where e.empId=es.empId

 AND  skilld = '#i#'
 


That will end up being

AND skilld='skill1'
AND skilld='skill2'

which is what you want.

Sheila Handler
jdt technologies, ltd
[EMAIL PROTECTED]

- Original Message -
From: Kim Mayhall <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 3:23 AM
Subject: Building Cold Fusion Search - Dynamic SQL


> I'm trying to build some sql statements based on selections from a list
box:
>
> 
>  Skill1
>  Skill2
>  Skill3
>  Skill4
> (etcthis size will vary as it's dynamically populated)
> 
>
> A user can do a multiple select, so let's say the user picked option 1 and
> option 3.
>
> On my action page, I want to pick ONLY the employees that have the 2
skills
> selected.
>
> If I use an IN statement, I get employees with one skill or the other, but
I
> only want those with both:
>
>SELECT e.empId,es.skillId
> from emp e,empSkills es
> where skillId IN (#frmSkill#)
> AND e.empId=es.empId
>
> How can I write the SQL to select only the employees with both, or do I
use
> Cold Fusion to do that?
>
> Kim Mayhall
> The Garrigan Lyman Group
> http://www.glg.com 
> (206) 223-5548
>
>





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

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

CF Web-based IMAP Help

[Erik S. Nachbahr]

Greetings,

I want to write a web-based (CF of course) IMAP client. It would be
universal so the user could choose their IMAP server and log in via the
interface I create. Does anyone know of an existing CF custom tag that
does this? Does this already exist?

thanks!

Erik

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

Re: FrontPage question

[Jeffry Houser]

   (Newbie alert? :Ha, ha: J/K)I can't tell you why, that's just the 
way it is.  But, I do suggest you don't use FrontPage to edit ColdFusion 
pages.  I might go further to suggest that you don't use FrontPage to edit 
HTML pages either, because it will do the same thing to HTML pages that it 
does to CF pages, which is adding extra HTML crap.

I once worked with an HTML expert who was able to take 8-10K FrontPage 
files and shrink them down to 2-3K by removing all of this extra HTML.


At 04:56 PM 02/27/2001 -0600, you wrote:
>i opened a page with frontpage so i can edit it, and it ends up adding extra
>html crap!  why
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Which version of MDAC is best with Cold Fusion 4.5.1

[Jeffry Houser]

   If it's working, don't change anything.

   I have ColdFusion and the latest version of MDAC (I'm pretty sure 2.5) 
running on my machines here just fine.  Of course with only one user (me) 
you don't get a lot of server load.

At 04:19 PM 02/27/2001 -0500, you wrote:

>I think I am currently run MDAC 2.1 (no patches) with Cold Fusion
>Profesional 4.5.1.
>
>Presently we are using ODBC against both VFP and Access databases/tables.
>
>Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the
>organization.
>
>Can and/or should I have our DBA upgrade to the 2.51.5303.5 version??  Will
>Cold Fusion play nice with 2.5, or should we go to the latest patched
>version of 2.1 ??
>
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
>/_/
>Whoof...
>410-757-3487
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: gettting form.variables using pure html?

[han peng]

thanx for yr reply..
 well.. yr codes still need to open a mail program like outlook.. eudora..
etc.. to send mail..
hmmm.. wat they wan is to send it directly.. after they click submit...
on the webpage..

anyway..
thanx for yr help.. :Þ

cheers
han
- Original Message -
From: Sean Renet <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 5:37 PM
Subject: Re: gettting form.variables using pure html?


> you mean something like this?
>
> mailto:[EMAIL PROTECTED]?subject=Some subject"
> method="post">
> 
> 
> 
> 
>
> Both browsers will fire off a warning, and the form fields will be name
> value pairs sent as an attachment to the email.
>
> Like this...
> name=John+Doe&age=21&submit=Submit+Query
>
> You could also href it or javascript the same...
>
>  mailto:[EMAIL PROTECTED]?subject=Some subject&body=this
> is the body of this email">Sean Renet
>
> - Original Message -
> From: "han peng" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 27, 2001 12:01 AM
> Subject: gettting form.variables using pure html?
>
>
> > hi..
> >  juz to confirm my thoughts...
> >
> > is there any way we can pass variables of a form to another page and
> display the variables.. using pure html??
> >
> > my friend thinking of doing a simple homepage at those free hosting
site.
> > Hes thinking of having a form that can send email directly w/o using the
> mail program. i know we can do this w/ CF... but can this be done using
pure
> html.. or maybe w/ javascript?
> >
> > cheers
> > han
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: FTP clients

[Jim McAtee]

I think it would be pretty simple to write a CF application to manage your
site updates.  Keep a database of the files, with full path, last modified
timestamp, and timestamp on the file when it was last uploaded.  Use CFFTP
to copy the content up to the server.  Once you upload a file to the remote
server (and you know the transfer was successful), record the modification
timestamp of the local file in your database.  Once the timestamp on the
local file differes from that in your db, you know you need to upload the
file.

You'd pick up new files, and find deleted content by using CFDIRECTORY to
traverse your local directory tree, looking for new files and detecting
files that have been deleted (a name change is essentially a delete, then an
add from both your database and the remote server).

You could do this in either one or two steps.  Probably best to do it in
two: Traverse the directory tree, and make queries to your database, looking
for differences and creating a list of files to be uploaded and deleted from
the remote server.  Then perform the FTP in the second step.

Jim


- Original Message -
From: "Parker, Kevin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 6:00 PM
Subject: FTP clients


> I apologise that this is sought of OT'sh so if anyone has any suggestions
> please email me of the list.
>
> Our web site has grown so big that we face huge upload times each time we
> regenerate. The FTP client we use can only check if a file has changed by
> comparing file size. This is unreliable. Comparing date and time stamps
seem
> to be the way to go but when you write a file to the server it takes on
the
> date and time stamp of the destination server. We need an FTP client with
> some intelligence that addresses this problem so that only changed files
are
> reliably uploaded.
>
> Can anyone advise if they use a FTP client that addresses this issue and
> what it is?
>
> TIA!
>
>
>
> +
> Kevin Parker
> Web Services Manager
> WorkCover Corporation
>
> [EMAIL PROTECTED]
>
> www.workcover.com
>
> p: +61 8 82332548
> f: +61 8 82332000
> m: 0418 800 287
>
> +
>
>
>

> This e-mail is intended for the use of the addressee only. It may contain
> information that is protected by legislated confidentiality and/or is
> legally privileged. If you are not the intended recipient you are
prohibited
> from disseminating, distributing or copying this e-mail. Any opinion
> expressed in this e-mail may not necessarily be that of the WorkCover
> Corporation of South Australia. Although precautions have been taken, the
> sender cannot warrant that this e-mail or any files transmitted with it
are
> free of viruses or any other defect.
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and destroy the original e-mail and any
copies.
>

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

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

RE: MSXML in cfobject to Load, Send, & Retrieve XML results?

[Vano, Carl G, SITS]

Error 405: Method Not Allowed 

The method specified in the Request-Line is not allowed for the requested
URL (Universal Resource Locator) "/Scripts/xmlquery.py". 

-Original Message-
From: Charlie McCormack [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 5:36 PM
To: CF-Talk
Subject: RE: MSXML in cfobject to Load, Send, & Retrieve XML results?


What is the error you are getting.



> -Original Message-
> From: Vano, Carl G, SITS [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 6:46 AM
> To: CF-Talk
> Subject: MSXML in cfobject to Load, Send, & Retrieve XML results?
> 
> 
> Does anyone know what is wrong with my code below? I am trying to 
> use MSXML
> cfobjects to load an XML doc, then open an HTTP connection and 
> send the XML
> doc. I am expecting back a query result in XML format. 
> 
> I am new to XML & cfbjects. If anyone knows where I could view 
> examples, or
> a tutorial on XML, cfobjects, and MSXML please let me know. 
> 
> When I try to output the query result I get back the following error: 
> 
> Error 405: Method Not Allowed 
> 
> The method specified in the Request-Line is not allowed for the requested
> URL (Universal Resource Locator) "/Scripts/xmlquery.py". 
> 
> Thanks! 
> Carl Vano
> 
> 
> 
> 
>  subclass=""FACILITY-NTX"">vendor == Cisco
>  cord>&l
> t;/query>">
> 
>name="XMLDoc"
>   class="MSXML2.DOMDocument"
>   action="CREATE">
> 
>name="XMLhttp"
>   class="MSXML2.ServerXMLHTTP"
>   action="CREATE">
> 
>   
> 
>  "http://servername/Scripts/xmlquery.py", false)>
>  
> 
> 
>   
>  
>  
> #res#
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: pie chart

[Sean Renet]

www.cfxgraphicsserver.com
- Original Message -
From: "Mak Wing Lok" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 4:38 PM
Subject: pie chart


> hi..
>
> anyone knows any nice and cool pie chart custom tags?
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: [error trapping]

[Alex]

>Do you normally display a generic template 
Yes. I do not let the user know what went wrong. just that an email
notification was sent. No need to give out error diagnostics to site users.

>Should I be trapping (cfthrow) any thing to stop people from
entering a search criteria that shouldn't be used 
I use javascript validation to narrow things done.

>Can I parse out the errors from trap do help determine what the user
Have your error template emailed to you.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: FTP clients

[Lanny R. Udey]

Hi,

It's probably not what you are looking for but we use the Cisco 11000 smart content 
switch (was Arrowpoint) for this exact reason. It keeps track of what is on the 
staging server and, using a publish subscribe model, copies anything new to the 
production servers while taking them out of rotation. Works great.

I don't know of any any other FTP program that does this. Would be interested though.

Lanny Udey
Hofstra University


>>> [EMAIL PROTECTED] Tuesday, February 27, 2001 >>>
I apologise that this is sought of OT'sh so if anyone has any suggestions
please email me of the list.

Our web site has grown so big that we face huge upload times each time we
regenerate. The FTP client we use can only check if a file has changed by
comparing file size. This is unreliable. Comparing date and time stamps seem
to be the way to go but when you write a file to the server it takes on the
date and time stamp of the destination server. We need an FTP client with
some intelligence that addresses this problem so that only changed files are
reliably uploaded.

Can anyone advise if they use a FTP client that addresses this issue and
what it is?

TIA!



+
Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED] 

www.workcover.com 

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

+



This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.

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

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

FYI: Microsoft Plans Public Preview Of IE 6.0

[Howie Hamlin]

http://www.techweb.com/wire/story/TWB20010227S0010

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!


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

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

FTP clients

[Parker, Kevin]

I apologise that this is sought of OT'sh so if anyone has any suggestions
please email me of the list.

Our web site has grown so big that we face huge upload times each time we
regenerate. The FTP client we use can only check if a file has changed by
comparing file size. This is unreliable. Comparing date and time stamps seem
to be the way to go but when you write a file to the server it takes on the
date and time stamp of the destination server. We need an FTP client with
some intelligence that addresses this problem so that only changed files are
reliably uploaded.

Can anyone advise if they use a FTP client that addresses this issue and
what it is?

TIA!



+
Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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

+



This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


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

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

RE: Building Cold Fusion Search - Dynamic SQL

[Christopher Olive, CIO]

great googlymoogly!  my bad.  thanks.

(i've been doing "customer relationship" stuff all day.  must have rotted my
brain!)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Maia, Eric [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 2:22 PM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


The problem with this approach is that it ignores the relational model of
the two tables. Each record in empSkills will only have one value for
skillId, so you won't get any records looking for two values. You'll need to
do a self-join or subquery to look for one record in emp that has two or
more related records in empSkills that match the two skills you're looking
for.

Try this:

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId

mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:43 AM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


since a multiple select gives you nothing more than a list, try a list loop.

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com



-Original Message-
From: Kim Mayhall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 2:23 PM
To: CF-Talk
Subject: Building Cold Fusion Search - Dynamic SQL


I'm trying to build some sql statements based on selections from a list box:


 Skill1
 Skill2
 Skill3
 Skill4
(etcthis size will vary as it's dynamically populated)


A user can do a multiple select, so let's say the user picked option 1 and
option 3.

On my action page, I want to pick ONLY the employees that have the 2 skills
selected.

If I use an IN statement, I get employees with one skill or the other, but I
only want those with both:

   SELECT e.empId,es.skillId
from emp e,empSkills es
where skillId IN (#frmSkill#)
AND e.empId=es.empId

How can I write the SQL to select only the employees with both, or do I use
Cold Fusion to do that?

Kim Mayhall
The Garrigan Lyman Group
http://www.glg.com 
(206) 223-5548
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

need some query help

[Adrian Cesana]

This query works fine but I need to select about 10-15 more columns from the
Master (m) table. The only way I can seem to get that to work is if I also
group on all the columns but this totally kills the query speed and Im not
sure I am even getting correct results in that case.

Basically this selects 2 columns from the Master table and SUM's the
QtyShipped from the Detail table for each record in the master.  How can I
select more columns from Master without grouping?


SELECT m.po,m.statcomm,sum(d.qtyshipped) AS TotalQty
FROM pos m,posd d
WHERE m.shipdate  BETWEEN '02/25/2001' AND '02/25/2001'
AND
m.po = d.po
GROUP BY m.po,m.statcomm
ORDER BY m.po


Thanks,Adrian


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

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

pie chart

[Mak Wing Lok]

hi..

anyone knows any nice and cool pie chart custom tags?




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

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

RE: FrontPage question

[Roque,Carlos]

Why are you doing using FrontPage, it sucks. Get Dreamweaver or Ultradev.

Carlos Roque
I.S., Applications
Web Development
x2154

 -Original Message-
From:   Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent:   Tuesday, February 27, 2001 2:57 PM
To: CF-Talk
Subject:FrontPage question

i opened a page with frontpage so i can edit it, and it ends up adding extra
html crap!  why
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Is this list alive?

[Michael]

Yepper ALIVE and raring too go,   Johnny Five is
aliveee
"Kevin Miller" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> For some reason, I seemed to have been unsubscribed.  I resubscribed this
morning, but haven't received anything yet.
>
> Kevin
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: FrontPage question

[Michael]

You poor poor person you, Frontpage, yuk,
"Phoeun Pha" <[EMAIL PROTECTED]> wrote in message
3FDBC86059BAD4119A1B0090273D1EB60C2AA3@HOUBLUE">news:3FDBC86059BAD4119A1B0090273D1EB60C2AA3@HOUBLUE...
> i opened a page with frontpage so i can edit it, and it ends up adding
extra
> html crap!  why
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Which version of MDAC is best with Cold Fusion 4.5.1

[Jon Hall]

MDAC 2.6, which is also installed with Win2k SP1 reintroduced a previous bug
that had been patched in earlier MDAC's. It basically hoses Access
(specifically pass-thru queries)  and some ADO stuff if I remember
correctly. The newest patch for CF fixes these problems, so it is safe to
upgrade the Win2k SP1 or manually put MDAC 2.6 on the system. I've done it.

jon
- Original Message -
From: "Adrian Cooper" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 6:23 PM
Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1


>
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 27, 2001 10:58 PM
>
>
> > I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you
go to
> > 4.52 RC2, or whatever the latest version is, it fixes the problems with
MDAC
> > 2.6 though.
>
> What_is_the problem with MDAC 2.6?
>
> SQL Server 2000 also installs it by default - or a later release of it.
>
> Adrian Cooper.
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: FrontPage question

[Joby Bednar]

Everyone should know by now that Microsoft wants people to do things their
way, so they tell you what you need.  You obviously needed more HTML code in
your site... you should just bow your head down to their superior wisdom and
thank them for showing you the error of your ways.

All I can say is thank God for their deeper insight.

Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com 
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED] 
Cell:  949-283-5138
Personal Fax:  208-485-1170



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 2:57 PM
To: CF-Talk
Subject: FrontPage question


i opened a page with frontpage so i can edit it, and it ends up adding extra
html crap!  why
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Any RegEx wizards about??

[BORKMAN Lee]

An even simpler solution...
Replace(form.EmailText,'"','','all')

Magic.

Good Luck,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork



-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]



>
> Replace(form.EmailText,,"","all") will work just fine
>
> Philip Arnold


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

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

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

RE: Which version of MDAC is best with Cold Fusion 4.5.1

[Simon Horwith]

Unless you're using SQL Server 2000, why not use MDAC 2.5?  It tried and
true (MDAC 2.6 hosed my machine two days ago).  I wouldn't use 2.6 if you
don't have a good reason to do so.

~Simon

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



-Original Message-
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:24 PM
To: CF-Talk
Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1



- Original Message - 
From: "Jon Hall" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 10:58 PM


> I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go
to
> 4.52 RC2, or whatever the latest version is, it fixes the problems with
MDAC
> 2.6 though.

What_is_the problem with MDAC 2.6?

SQL Server 2000 also installs it by default - or a later release of it.

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

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

Re: FrontPage question

[Jon Hall]

That is what Frontpage does. Frontpage really really sucks. I'd suggest
Dreamweaver/Ultradev for WYSIWYG dev work.

jon
- Original Message -
From: "Phoeun Pha" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 5:56 PM
Subject: FrontPage question


> i opened a page with frontpage so i can edit it, and it ends up adding
extra
> html crap!  why
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: FrontPage question

[Jay Patton]

i would sum it up by saying that, FrontPage SUCKS! (in my opinion) it adds
extra or useless html code all the time, i use dreamweaver instead.

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Phoeun Pha" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 3:56 PM
Subject: FrontPage question


> i opened a page with frontpage so i can edit it, and it ends up adding
extra
> html crap!  why
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: FrontPage question

[John Wilker]

Because it's FrontPage :-)

Opening files and saving them in FP is disastrous, at least every time I
ever did it, it ended badly. As a rule, don't use front page unless you
never intend to work with the code in studio again. As long as you stay with
FP forever you'd be ok, why you'd wanna do that I don't know :-)

J.

John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 2:57 PM
To: CF-Talk
Subject: FrontPage question


i opened a page with frontpage so i can edit it, and it ends up adding extra
html crap!  why
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: FrontPage question

[Adrian Cooper]

- Original Message -
From: "Phoeun Pha" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 10:56 PM


> i opened a page with frontpage so i can edit it, and it ends up adding extra
> html crap!  why

Because it assumes that your existing HTML is wrong or incomplete, and corrects
it for you.

Why don't you use Studio or UltraDev or Ultra-Edit?

Adrian Cooper.



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

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

error trapping

[Belfiori, Ross]

I am trapping errors from a CFSEARCH and need some ideas.  The search covers
both a database search and document search.  I assume that trapping for type
ANY is the only thing that I can do.but that is why I ask ya'll.  
*   Do you normally display a generic template when you trap an
errorinstead of displaying the CF error page?
*   Should I be trapping (cfthrow) any thing to stop people from
entering a search criteria that shouldn't be used (CF commands?special
characters?)
*   Can I parse out the errors from trap do help determine what the user
did and notify them of their mistake?
*   anything else?

thanx for your help

Ropo

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

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

Re: Which version of MDAC is best with Cold Fusion 4.5.1

[Adrian Cooper]

- Original Message - 
From: "Jon Hall" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 10:58 PM


> I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go to
> 4.52 RC2, or whatever the latest version is, it fixes the problems with MDAC
> 2.6 though.

What_is_the problem with MDAC 2.6?

SQL Server 2000 also installs it by default - or a later release of it.

Adrian Cooper.



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

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

Re: SQL Server Licensing question

[Adrian Cooper]

- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 9:30 PM


>
> Nope. I just got off the phone with them. You have to sign up for the
> Application Service Provider's licensing program and pay them $5.99
> per month for every client who hosts SQL Server. Once you get enough
> clients to be worthwhile, you can switch to per processor mode for
> $249.00 per month.

Maybe you could expand on what your are trying to achieve here?

If you have a SQL Server license - you can have as many databases under that
installation as you want to. Cold Fusion (like ASP for example) talks to those
databases via an ODBC or OLEDB datasource.  If you are running multiple websites
with multiple datasources it doesn't matter. The datasource is merely a
requirement of the website, and which in turn requires SQL Server.

But maybe I have misunderstood your objectives?

Adrian Cooper.



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

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

RE: Using Authentication window

[Gieseman, Athelene]

This is a question I posed to the list some time ago.  I tried way back
when, but only the cf service login id was returned.  I just tried again,
and it's working fine.  I'm confused as to what's different (or rather, what
I did wrong the first time.)  But very happy it's working!!  Thank you to
all who posted an answer on this.

Athelene Gieseman
[EMAIL PROTECTED]

-Original Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:07 PM
To: CF-Talk
Subject: RE: Using Authentication window


an authentication window?  you mean like the one IIS pops up when using
NTCR?

after authentication, check CGI.AUTH_USER (CGI.REMOTE_USER might work as
well.  i've seen them both used).

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:46 PM
To: CF-Talk
Subject: Using Authentication window


Does anyone know how to get a userid from a Authentication and pass that
variable to CF so that I can use it to query a DB and populate some fields?

I would appreicate it any help that you can offer.

Thanks in Advance.

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

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

FrontPage question

[Phoeun Pha]

i opened a page with frontpage so i can edit it, and it ends up adding extra
html crap!  why

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

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

Re: TO USE SQL or something entirely different.

[Jeff W]

I would post code, but I havn't started coding this yet. ;-)

The current code is only a short query to find out if the card is ready to
ship AND if its going out UPS. That query puts its results in a file
suitable for import into the UPS software. Nothing special.

Right now I get doubles, triples, etc.of the same shipping destination in
this query. What my goal is, is to try and take those duplicate, and
triplicate, etc. records and meld them into one record, adding their weights
together. The list would then only have one instance of the shipping
destination and its total weight instead of numerous times. I can then
import this list into the UPS software without editing the actual text file
like I do now.

Hope that is a little clearer.



- Original Message -
From: "Elizabeth Marcotte - Selphcotte Web Designs"
<[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 12:21 PM
Subject: RE: TO USE SQL or something entirely different.


> Jeff
>
> If I understand you correctly - you could create arrays - loop through the
> arrays comparing whatever fields you are using to determine the same
records
> going to the same place, do the calcs on those records - update another
> array with the totals for each "same place" - this new array will have one
> record for each same place - they loop through the new array and insert
into
> wherever you need to insert only once.
>
> I am sorry that is confusing - I might not be understanding what you
need -
> but Arrays are a good way to group data.  Hope that helps.  If you post
the
> code you are using - it might be easier for people to help?
> E
>
> -Original Message-
> From: Jeff W [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 27, 2001 8:29 AM
> To: CF-Talk
> Subject: TO USE SQL or something entirely different.
>
> I need a good starting point.
>
> I am looking to streamline our shipping procedures. Right now I generate
two
> queries that divide out packages that are going UPS and US mail. Thats the
> easy part.. These insert easily into our standard UPS software. LOL
>
> What I would like to do.
>
> Each business card order is shipped pretty much separately (for drop ship
> purposes and the fact that not every color is produced everyday). So A UPS
> query may have multiple sets of cards (records) going to the same place.
How
> in the world can I take that query, combine all the records that are the
> same, add their weights up and insert them back into the list only once???
>
> I am open for suggestions.
>
> Jeff
> Priority Business Cards
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

IP Address question

[Phoeun Pha]

So u mean, if you can reverse engineer the browser, u can make it not show
an IP, or show a fake IP



-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 6:13 PM
To: CF-Talk
Subject: RE: getting IP Address w/o cf


by CGI, i'm assuming you mean PERL? you can write CGIs in lots of languages.

client IP addresses are one of a number of environmental variables exposed
by the client web browser to the server. the environmental variable is
REMOTE_ADDR. that's not CF-specific, but true for PERL, ASP, PHP, etc.

for example, something like <%= Request.ServerVariables("REMOTE_ADDR") %>
gets you the IP in ASP.

--dylan


-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 8:53 AM
To: CF-Talk
Subject: OT: getting IP Address w/o cf


I have a client who has a site that is on unix (eww) and am needing to know
a way to get a user's ip address.  I know how to do it with cold fusion, but
don't know how to with CGI or FrontPage.  They have FrontPage 2000 server on
their web server.  Any ideas?

Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Which version of MDAC is best with Cold Fusion 4.5.1

[Jon Hall]

I use 2.5 on our NT and Win2k boxes with no problems with 4.51. If you go to
4.52 RC2, or whatever the latest version is, it fixes the problems with MDAC
2.6 though.

jon
- Original Message -
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 4:19 PM
Subject: Which version of MDAC is best with Cold Fusion 4.5.1


>
> I think I am currently run MDAC 2.1 (no patches) with Cold Fusion
> Profesional 4.5.1.
>
> Presently we are using ODBC against both VFP and Access databases/tables.
>
> Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the
> organization.
>
> Can and/or should I have our DBA upgrade to the 2.51.5303.5 version??
Will
> Cold Fusion play nice with 2.5, or should we go to the latest patched
> version of 2.1 ??
>
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
> /_/
> Whoof...
> 410-757-3487
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Cached Query! Was Working Yesterday!

[Chip Griffin]

I believe this can occur if the uncached query failed to complete for any
reason.  CF apparently will think it was cached, but of course it will have
no results available.  I have seen this occur on a server when a
particularly long-running query is still executing to go into the cache at
the same time another request comes in for the cached version.  (My guess is
that CF marks a query as cached when it begins to execute rather than when
it has completed, but I don't know this for certain.)

There is some discussion of this issue in the CF forums on Allaire's web
site.

You can use  and  around the query code to trap this error
and submit the query without asking for an available cached version.

There may be other explanations, but this is the only one I am familiar
with.

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:00 PM
To: CF-Talk
Subject: Cached Query! Was Working Yesterday!


CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (39:1) to (40:43).


This is the entire message.  Why would it do this?  It was working
yesterday, I went live with it, now it's failing.  I'm going insane!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SQL Server Licensing question

[Edward Smith]

Send it back, and use PostgreSQL.

Send it back.  There are a lot of databases out there.  

What is your required feature set?

Bud wrote:
> 
> On 2/27/01, Christian L. Watt penned:
> >Yes, you can.  ColdFusion is the main user of the database at that point.  I
> >believe this clause is reffering to you setting up a SQL server and letting
> >other companies connect to it as a production database for there company,
> >not for web production.  Not the best articulator, but hope this answers
> >your question.
> 
> Nope. I just got off the phone with them. You have to sign up for the
> Application Service Provider's licensing program and pay them $5.99
> per month for every client who hosts SQL Server. Once you get enough
> clients to be worthwhile, you can switch to per processor mode for
> $249.00 per month.
> 
> Ol' Bill has to make a cut off of every dollar I make, even if he is
> the richest bas&^$# in the world and I just paid him over $4,000.00
> and it will probably be years before I show any sort of profit at
> all. Yeah!! That's fair!
> --
> 
> Bud Schneehagen - Tropical Web Creations
> 
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: MSXML in cfobject to Load, Send, & Retrieve XML results?

[Charlie McCormack]

What is the error you are getting.



> -Original Message-
> From: Vano, Carl G, SITS [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 6:46 AM
> To: CF-Talk
> Subject: MSXML in cfobject to Load, Send, & Retrieve XML results?
> 
> 
> Does anyone know what is wrong with my code below? I am trying to 
> use MSXML
> cfobjects to load an XML doc, then open an HTTP connection and 
> send the XML
> doc. I am expecting back a query result in XML format. 
> 
> I am new to XML & cfbjects. If anyone knows where I could view 
> examples, or
> a tutorial on XML, cfobjects, and MSXML please let me know. 
> 
> When I try to output the query result I get back the following error: 
> 
> Error 405: Method Not Allowed 
> 
> The method specified in the Request-Line is not allowed for the requested
> URL (Universal Resource Locator) "/Scripts/xmlquery.py". 
> 
> Thanks! 
> Carl Vano
> 
> 
> 
> 
>  subclass=""FACILITY-NTX"">vendor == Cisco
>  cord>&l
> t;/query>">
> 
>name="XMLDoc"
>   class="MSXML2.DOMDocument"
>   action="CREATE">
> 
>name="XMLhttp"
>   class="MSXML2.ServerXMLHTTP"
>   action="CREATE">
> 
>   
> 
>  "http://servername/Scripts/xmlquery.py", false)>
>  
> 
> 
>   
>  
>  
> #res#
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: ecommerce / cybercash

[Joby Bednar]

My vote is for SkipJack.com... 

Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com  
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED]  
Cell:  949-283-5138
Personal Fax:  208-485-1170


-Original Message-
From: megan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:26 PM
To: CF-Talk
Subject: ecommerce / cybercash


Hi all,
Sorry if this question has been asked recently. I've been gaining skills
in Cold Fusion, and I'm ready to start looking at ecommerce, I think. Is
CyberCash the best way to go for interfacing Cold Fusion with credit
card capability? Are there references on the Web regarding this? books?
(BTW: I'm glad CF-Talk is going to remain, at least in part, a forum for
newbies like me to work up to more advanced levels.)
Thanks in advance,
Megan



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


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

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

Re: ecommerce / cybercash

[Mark]

Megan,

We've had great experiences integrating
with Authorize.Net and I understand it's 
easier to interface with than Cybercash 
(although I haven't worked with CC, just 
read other's experiences).

HTH

Mark


--- megan <[EMAIL PROTECTED]> wrote:
> Hi all,
> Sorry if this question has been asked recently. I've
> been gaining skills
> in Cold Fusion, and I'm ready to start looking at
> ecommerce, I think. Is
> CyberCash the best way to go for interfacing Cold
> Fusion with credit
> card capability? Are there references on the Web
> regarding this? books?
> (BTW: I'm glad CF-Talk is going to remain, at least
> in part, a forum for
> newbies like me to work up to more advanced levels.)
> Thanks in advance,
> Megan
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Weird Memory Address Displayed

[Norman Elton]

Hello all!

This afternoon, one of our CFM pages stopped working. Rather than displaying
an error, it just gave an odd memory address:

-2147417848 (0x80010108)

All other pages on the site worked fine. For some reason, just this one page
was bad. We created a new site in IIS and copied all the files over. The new
"site" worked perfectly, but the old copy of the file was bad.

We checked all the error logs, which revealed nothing. We figured it must be
an IIS issue, or an issue between IIS and ColdFusion. For now, we're running
the application off under the new name, but we'd like to figure out what
cause the first one to go bad.

Has anyone ever seen this before?

Thanks!

Norman Elton
Information Technology
College of William & Mary


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

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

RE: Manager of Support

[lsellers]

> Anyone know who the Manager of Support is at Allaire.

Waldo.


--min


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

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

RE: WOT: Serving to the web using W2K, IIS and DSL

[Alex Skinner - Digital Dreams]

If you have a dynamic ip you can use a free dynamic routing name service
such as

dydns.org or dynip.com

For example you could have my teammember.dynip.com

This is a client program which you install on the computer and it updates
the dns entry at their end depending on the current dynamic ip very smart,
and also gets around doing it with IPCONFIG and some clever scripting.

HTH

ALex

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tony
Schreiber
Sent: 27 February 2001 05:01
To: CF-Talk
Subject: Re: WOT: Serving to the web using W2K, IIS and DSL


> I will be out of the office today, Monday, February 26.  I will return
> Tuesday, February 27.


In case you guys didn't know, Ramonda Ramos will be out of the office
today.


Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone!
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group
http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: SQL Server Licensing question

[Adrian Cooper]

- Original Message -
From: "Jeffry Houser" <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 12:01 AM


> >NO RENTAL/NO COMMERCIAL HOSTING. You may not rent, lease, lend, or
> >provide commercial hosting services with the Product.
> >
> >So, did I just throw away 4k? Can SQL Server not be used by an ISP?
>
>I haven't explored the various options, but I was under the impression
> that my ISP had paid ~$10,000 for their copy of SQL Server 2000.  If you

Sounds like they purchased a 2 CPU license then:

SQL Server 2000 can now be purchased as CPU licenses which provide for unlimited
client device accesses. This replaces the SQL Server 7 with Internet Connector
License.

If you only need one CPU, then this is very cost effective - $4,999.00 per CPU
for the standard edition.

Full details at:

http://www.microsoft.com/sql/productinfo/pricing.htm

Adrian Cooper.



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

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

Re: CFFILE Error (why?)

[Jay Patton]

boy do i feel dumb. i was referring to a code snippit from one of the other
sites that i have used this on before, and it turns out that i overlooked
the final slash at the end of the path.

THANK YOU so much for pointing that out to me.

Thanks all,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 1:45 PM
Subject: Re: CFFILE Error (why?)


> Is there a directory on the D drive called \64.???.132.???\beta\images
>
> or are you trying to connect to a server IP of 64.???.132.???\beta\images
>
> The syntax of the CFFILE statement looks ok.  Although i usually format it
> in a different order and i dont think that matters.  I would try putting a
> trailing \ after images like this:
>
> D:\64.???.132.???\beta\images\
>
> If you want to send the file to an IP use CFFTP.
>
>
> At 12:38 PM 2/27/01 -0700, you wrote:
> >why do i get this error?
> >here is the query or rather the CFFile action.
> >
> > >   filefield="ItemPic"
> >   destination="#storepath#\images" 
> >   nameconflict="overwrite"
> > >
> >
> >and here is the error.
> >Error Diagnostic Information
> >Error processing CFFILE
> >
> >Error attempting to save uploaded file to path
> >'D:\64.???.132.???\beta\images..' Access is denied. (error 5)
> >
> >The error occurred while processing an element with a general identifier
> >of (CFFILE), occupying document position (294:4) to (298:4).
> >
> >it worked fine the other day.
> >any ideas?
> >thanks,
> >
> >Jay Patton
> >Web Design / Application Design
> >Web Pro USA
> >406.549.3337 ext. 203
> >1.888.5WEBPRO
> >www.webpro-usa.com
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL Server Licensing question

[Bud]

On 2/27/01, Christian L. Watt penned:
>Yes, you can.  ColdFusion is the main user of the database at that point.  I
>believe this clause is reffering to you setting up a SQL server and letting
>other companies connect to it as a production database for there company,
>not for web production.  Not the best articulator, but hope this answers
>your question.

Nope. I just got off the phone with them. You have to sign up for the 
Application Service Provider's licensing program and pay them $5.99 
per month for every client who hosts SQL Server. Once you get enough 
clients to be worthwhile, you can switch to per processor mode for 
$249.00 per month.

Ol' Bill has to make a cut off of every dollar I make, even if he is 
the richest bas&^$# in the world and I just paid him over $4,000.00 
and it will probably be years before I show any sort of profit at 
all. Yeah!! That's fair!
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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

RE: Strengths of each

[Eric Barr]

My ASP is a bit rusty and the code is a bit long for here. So, how about
PSUEDO Code:

1) Store CFID & CFToken in an ASP Session Variable

2) Have some other values you want to send to CF (I'm assuming their
session variables_

3) Use a FOR IN structure to loop over the SESSION level scope
be avoid the CFID and CFTOKEN variables in your session scope

4) In this loop build your the WDDX packet you want to store.  This
packet should match the format that CF uses for its client variables.
You'll need to play with how to do this.  Their is some good reference
at http://www.wddx.org/WDDX_SDK/joust_files/ on the WDDX object for ASP.
You might be able to use the "serialize" method and simply convert a RS
into the packet or it might just be easier to build the packet by
hand.

5) Either way once the packet is built update the CF client variable
tables using the CFID and CF Token you are storing in memory.

Note: you could run into some concurrency issues here.  Using the
HITCOUNT and LASTVIST flags should allow you to work around this (check
the options you have set for the Client Store in CF Administrator)


Hope that helps. If you need something a bit more concrete, pester me
and I'll write something, but I most likely won't have time till Monday.

-eric



Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390 
(f)   212.580.7181


-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 9:44 PM
To: CF-Talk
Subject: RE: Strengths of each


First of all thanks for the part about the asp.net, I haven't the time
to
digest this information at the moment. I am well aware that there is no
Custom Tag functionality in ASP and that you need to write functions.

I have all this already coded and ready to go, what I need is the logic
to
know what variables have been set in a page (ASP pages only) so that I
can
take these out of ASP and migrate these across to CF. Going from CF to
ASP
is no problem what so ever:-)

So if you have code that I can see that would do this I would like to
see
it:-)



-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 04:02
To: CF-Talk
Subject: RE: Strengths of each


> if there was a tag like cfa_dump on ASP, that could dump session,
> application etc then I have the code waiting but I just need that
answered.

In ASP you can Dump all the variables.  Its not too hard. Their are 5
intrinsic objects in ASP   : Response, Request, Application, Session and
Server. For any of these objects you could simply walk their structure
using a FOR IN loop.

In ASP their aren't really custom tags. ... you can write functions, run
include files, or instantiate some type of object to do the work ... the
quickest would most likely write the code in a function.  And simply
include it on the pages you want to show the debug information.  You
might want to look into the Trace functionality coming in ASP.NET (
http://msdn.microsoft.com/library/default.asp?URL=/library/dotnet/cpguid
e/cpcontracefunctionality.htm)


-eric

Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390 
(f)   212.580.7181
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Slightly OT: SQL "Mode" function?

[Albert, Gregory Mitchell (Greg)** CTR **]

Does anyone know of a way to get the mode (the most frequently occuring
number) for a column? I didn't see any sort of SQL function for this, but it
would be a useful function, if someone had an idea of how to do it with CF.

Thanks in advance!

Greg Albert



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

Which version of MDAC is best with Cold Fusion 4.5.1

[Arden Weiss]

I think I am currently run MDAC 2.1 (no patches) with Cold Fusion 
Profesional 4.5.1.

Presently we are using ODBC against both VFP and Access databases/tables.

Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the 
organization.

Can and/or should I have our DBA upgrade to the 2.51.5303.5 version??  Will 
Cold Fusion play nice with 2.5, or should we go to the latest patched 
version of 2.1 ??

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


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

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

ecommerce / cybercash

[megan]

Hi all,
Sorry if this question has been asked recently. I've been gaining skills
in Cold Fusion, and I'm ready to start looking at ecommerce, I think. Is
CyberCash the best way to go for interfacing Cold Fusion with credit
card capability? Are there references on the Web regarding this? books?
(BTW: I'm glad CF-Talk is going to remain, at least in part, a forum for
newbies like me to work up to more advanced levels.)
Thanks in advance,
Megan



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

RE: CF on Solaris Intel

[Dave Watts]

> Can CF run on Solaris Intel or just Sparc?

Just SPARC.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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

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

"Illegal Port Command" with CFFTP

[Gregory Harris]

Hello, every time I try and execute this command:



I get this error:

500 Illegal PORT Command

Any ideas as to what might be happening?  Thanks!


Gregory Harris
Web Developer

The Stirling Bridge Group, LLC
*We Engineer Internet Business Solutions*
TEL: (949) 707-1534  FAX: (949) 707-1535




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

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

Re: SQL Server Licensing question

[Jeffry Houser]

At 01:30 PM 02/27/2001 -0500, you wrote:
>Hi all. Sorry for the OT post. Just got my brand new SQL Server 2000
>with 1 processor license in the mail and promptly read over the
>license. What in Gawd's name is this supposed to mean?
>
>NO RENTAL/NO COMMERCIAL HOSTING. You may not rent, lease, lend, or
>provide commercial hosting services with the Product.
>
>So, did I just throw away 4k? Can SQL Server not be used by an ISP?

   I haven't explored the various options, but I was under the impression 
that my ISP had paid ~$10,000 for their copy of SQL Server 2000.  If you 
want to get sneaky, just provide ColdFusion hosting, with SQL Server 
databases thrown in for free.  That's not much different than giving away 
Internet Explorer with your purchase of windows, is it?  Sure, you don't 
pay (directly) for IE, but MS had to cover the development costs somehow.



Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I've got the brains, you've got the looks, let's make lots of money


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

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

Re: WDVL Poll

[Jeffry Houser]

   I want to add here, that the original version of CF was implemented as a 
CGI program.  I was under the impression that the version for some of the 
less widely used operating systems (Unix?) still operate that way.  Is this 
the case?

At 01:10 PM 02/27/2001 -0500, you wrote:
>I know what CGI is and I also know that they are inherently slower because
>the Web Server needs to spawn a new process each time the CGI is called
>whereas an ISAPI app (or app server like CF) does not require this.
>
>Regards,
>
>Howie
>
>- Original Message -
>From: "Dylan Bromby" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Tuesday, February 27, 2001 10:03 AM
>Subject: RE: WDVL Poll
>
>
> > i don't know about FastCGI, but CGI is not a language in and of itself.
>it's
> > a standard (Common Gateway Interface) for talking to web server
>components,
> > etc. you can write CGI apps in PERL, C++, etc. so while i agree it might
> > take longer to write a CGI app in, say, C++ than CF, i don't know if
>you're
> > saying CGI applications are slow, because they're not necessarily.
> >
> > for a good overview by NCSA, see:
> >
> > http://hoohoo.ncsa.uiuc.edu/cgi/intro.html
> >
> > --dylan
> >
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFFILE with UNC Paths.

[Eric Barr]

Neil,

I don't believe you can use UNC's with CFFILE (someone please correct
me).  I remember trying this out and it not working. But it could have
been a permissions issue. When CF installs the service runs as the local
system account ...which is god on that system, but has no rights outside
the system.  Try having your CF Server running under its own special
account.  You will need to give the account the appropriate permissions
to functions (please not Administrator).  Once the account has
permissions to Run on the local system, make sure it has permission to
access the network resource.

 If you can't use UNC's you have an alternative.  You could use
CFEXECUTE to map a drive (look into the "NET USE" command)  Once a drive
is mapped CFFILE should have no problem writing to it.  However, the
security issues mentioned above still apply.  

At one point I started working on a detailed list of the permissions CF
needs to run,  I think around the time when the hidden tags in CF were
discovered, but I never got to far on it ...sorry.


Regards,
-eric

Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390 
(f)   212.580.7181


-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 11:12 AM
To: CF-Talk
Subject: CFFILE with UNC Paths.


Anyone know a way to write a file via a UNC path?

Thanks,

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

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

RE: Display Query Horizontally

[Jay E Wigginton]

Thanks... that works great!

Jay

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:34 PM
To: CF-Talk
Subject: RE: Display Query Horizontally


> I have been trying to determine a way to display query's record set
> horizontally oriented rather than vertically oriented and maintain proper
> column and row alignment... example:
>
>  Record1 Record2 Record3 Record4
> field1   R1-F1   R2-F1   R3-F1   R4-F1
> field2   R1-F2   R2-F2   R3-F2   R4-F2
> field3   R1-F3   R2-F3   R3-F3   R4-F3
>
> Is there a simple means of doing this?






Record #i#




#i#

#Evaluate(i)#





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

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFFILE Error (why?)

[Philip Arnold - ASP]

> why do i get this error?
> here is the query or rather the CFFile action.
>
>filefield="ItemPic"
>   destination="#storepath#\images" 
>   nameconflict="overwrite"
> >
>
> and here is the error.
> Error Diagnostic Information
> Error processing CFFILE
>
> Error attempting to save uploaded file to path
> 'D:\64.???.132.???\beta\images..' Access is denied. (error 5)
>
> The error occurred while processing an element with a general
> identifier of (CFFILE), occupying document position (294:4) to (298:4).
>
> it worked fine the other day.
> any ideas?

OK, I assume that you're sending to a remote machine, and 64.???.132.???
isn't a folder

If so, then get rid of the D: and use \\

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

"Websites for the real world"

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



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

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

Re: CFFILE Error (why?)

[Chad Gray]

Is there a directory on the D drive called \64.???.132.???\beta\images

or are you trying to connect to a server IP of 64.???.132.???\beta\images

The syntax of the CFFILE statement looks ok.  Although i usually format it 
in a different order and i dont think that matters.  I would try putting a 
trailing \ after images like this:

D:\64.???.132.???\beta\images\

If you want to send the file to an IP use CFFTP.


At 12:38 PM 2/27/01 -0700, you wrote:
>why do i get this error?
>here is the query or rather the CFFile action.
>
>   filefield="ItemPic"
>   destination="#storepath#\images" 
>   nameconflict="overwrite"
> >
>
>and here is the error.
>Error Diagnostic Information
>Error processing CFFILE
>
>Error attempting to save uploaded file to path 
>'D:\64.???.132.???\beta\images..' Access is denied. (error 5)
>
>The error occurred while processing an element with a general identifier 
>of (CFFILE), occupying document position (294:4) to (298:4).
>
>it worked fine the other day.
>any ideas?
>thanks,
>
>Jay Patton
>Web Design / Application Design
>Web Pro USA
>406.549.3337 ext. 203
>1.888.5WEBPRO
>www.webpro-usa.com
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFFILE Error (why?)

[Christian L. Watt]

An IP is not a valid path.  With CFFile you must use a valid local path.  If
it works in Explorer (not IE, MS) then it will work with CFFile (as a
general rule of thumb.)

CW

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 1:38 PM
To: CF-Talk
Subject: CFFILE Error (why?)


why do i get this error?
here is the query or rather the CFFile action.


  nameconflict="overwrite"
>

and here is the error.
Error Diagnostic Information
Error processing CFFILE 

Error attempting to save uploaded file to path
'D:\64.???.132.???\beta\images..' Access is denied. (error 5) 

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (294:4) to (298:4).

it worked fine the other day.
any ideas?
thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Domain Move and Data Integrity

[Tony Schreiber]

The problem you described below would not occur if you set the server on
the old address to access the datasource on the new address. Two sites
yes, but only one datasource.

> > Couldn't you just point the DSN on the access side to the SQL 
> > db until the
> > change takes place?
> 
> 
> I've got a similar problem.
> 
> 
> A site is in on a server at IP address 123.0.0.10 (for example).
> 
> You move the site to a different server (at the same host or not - doesn't
> make a difference) on IP 218.03.10.50
> 
> You alter the DNS entries.
> 
> Users connect to the Internet via ISPa. ISPa caches domain names so that it
> resolves to 123.0.0.10 until the TTL kicks in (cognoscenti - is this how it
> works?). Those users hit the site and add / modify / delete data to the
> database on 123.0.0.10.
> 
> Other users connect to the Inter via ISPb. ISPb refreshes their domain name
> cache earlier. Their users hit the site at 218.03.10.50 and add / modify /
> delete data to the database on that server. 
> 
> 
> End result - Host1 has a database with some new entries. Host2 has a
> database with some new entries.
> 
> Someone (ie the developer) has to go and mop up the differences and compile
> them into the database on Host2.
> 
> 
> Q: How can you prevent this situation arising without taking the site
> completely offline until ISPb has updated their domain name cache?
> 
> 
> 
> Anwsers on a postcard...
> 
> -- 
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
> 
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

update - urgent... query/variable problems...

[Joby Bednar]

Thanks all who tried to help... the problem was actually a setting
difference in using cf_passwordgenerator creating the session_id that was
being used to find the pro_id... it would generate a 10 digit string on my
system and a 20 digit string on the other system, but since the database
only allowed 10 then it would never find the pro_id.  Geez... what a pain.
Thank you Allaire for adding 'debug="yes"' in cfquery, a great feature!

Anyway, this brings up a question from below: why should I usually lock
session variables?  I thought session variables are specific to the client
so would they not conflict with each other?  I actually haven't done much
with cflock and cftransaction, so any further insight is very helpful.

Thanks,

Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com 
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED] 
Cell:  949-283-5138
Personal Fax:  208-485-1170



-Original Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 6:10 PM
To: CF-Talk
Subject: RE: urgent... query/variable problems...


Joby,

You can use the  around both queries. Also, I assume you are
setting session.pro_session_id before this code.  Don't forget you should be
locking read and write access to session variables with .

-Andy

> -Original Message-
> From: Joby Bednar [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 26, 2001 5:41 PM
> To: CF-Talk
> Subject: urgent... query/variable problems...
>
>
> I posted a question the other day asking about session variables and
> password protected folders... I've narrowed the problem down to the
> following (and it has nothing to do with folders and session variables):
>
> I have a script that updates a database from info from forms and then
> selects the id (key) and stores it in a session variable to be used in the
> next couple stages later on.  The problem is that the second query doesn't
> grab anything when I tested the site on our live server.  The odd thing is
> that it works on my laptop but doesn't work on our live server.  There
> doesn't seem to be anything wrong with session variables... all the other
> variables created are stored fine.  The problems only seems to be the
> variable "pro_id".
>
> Here's the latest version of the code I've been trying to get to work:
>
> 
>  UPDATE Profiles
>  SET  pro_business_type = '#form.pro_business_type#',
>pro_business_year = #form.pro_business_year#,
>pro_sic = '#form.pro_sic#',
>pro_business_ee = #form.pro_business_ee#,
>pro_business_revenue = '#form.pro_business_revenue#',
>pro_business_stock = #form.pro_business_stock#,
>pro_business_traded = #form.pro_business_traded#,
>pro_business_homebased = #form.pro_business_homebased#,
>pro_step = 4
>  WHERE pro_session_id = '#session.pro_session_id#'
> 
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
> 
>  SELECT pro_id
>  FROM Profiles
>  WHERE pro_session_id = '#session.pro_session_id#'
> 
>
> 
>
> Is there some sort of timing issue that prevents the second query from
> working right after updating the same DB?  How can I get around this?  Any
> insight you might have would be very helpful!!!
> Joby Bednar
> Director of Internet Design
> iNEOgroup.com
> http://www.ineogroup.com
> Fusing your Dreams and the Web, Together as One
> [EMAIL PROTECTED]
> Cell:  949-283-5138
> Personal Fax:  208-485-1170
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Early Expiring Sessions

[Neil H.]

I don't think that is it.  I don't believe the server has restarted.

Thanks,

Neil

- Original Message -
From: "JoshMEagle" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 2:45 PM
Subject: Re: Early Expiring Sessions


> If your server is set to "Restart on XX Unresponsize Requests" then when
> CFServer restarts your SESSION and APPLICATION variables are cleared.
>
> Joshua Miller
> Web Development
> Eagle Technologies Group, Inc.
> Business Solutions for the Next Generation
> www.eagletgi.com
> [EMAIL PROTECTED]
>
>
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 27, 2001 8:00 AM
> Subject: Early Expiring Sessions
>
>
> > Does anyone notice on CF 4.51 SP2 that sessions expire early?  I set my
> > application to 30 minutes and I am sure the admin is set to have
sessions
> of
> > 1 day!
> >
> > ANy ideas?
> >
> > Thanks,
> >
> > Neil
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Building Cold Fusion Search - Dynamic SQL

[Kim Mayhall]

That's it!  Thank you so much for understanding my problem and giving me a
solution!

  
Kim Mayhall 
The Garrigan Lyman Group 
http://www.glg.com 
(206) 223-5548 


-Original Message-
From: Maia, Eric [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 11:22 AM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


The problem with this approach is that it ignores the relational model of
the two tables. Each record in empSkills will only have one value for
skillId, so you won't get any records looking for two values. You'll need to
do a self-join or subquery to look for one record in emp that has two or
more related records in empSkills that match the two skills you're looking
for. 

Try this:

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId

mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:43 AM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


since a multiple select gives you nothing more than a list, try a list loop.

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com



-Original Message-
From: Kim Mayhall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 2:23 PM
To: CF-Talk
Subject: Building Cold Fusion Search - Dynamic SQL


I'm trying to build some sql statements based on selections from a list box:


 Skill1
 Skill2
 Skill3
 Skill4
(etcthis size will vary as it's dynamically populated)


A user can do a multiple select, so let's say the user picked option 1 and
option 3.

On my action page, I want to pick ONLY the employees that have the 2 skills
selected.

If I use an IN statement, I get employees with one skill or the other, but I
only want those with both:

   SELECT e.empId,es.skillId
from emp e,empSkills es
where skillId IN (#frmSkill#)
AND e.empId=es.empId

How can I write the SQL to select only the employees with both, or do I use
Cold Fusion to do that?

Kim Mayhall
The Garrigan Lyman Group
http://www.glg.com 
(206) 223-5548
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CF on Solaris Intel

[James Taavon]

Can CF run on Solaris Intel or just Sparc?

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

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

RE: Domain Move and Data Integrity

[Philip Arnold - ASP]

> This is one of the prime reasons not to use an Access or file-based
> database. If you use SQL Server, or any client server DB, you simply point
> the new DSN to the new SQL server.  Both sites can now use the same
> database.  No hassles. No updates.  No "merging" of data.

Here's a few other "prime" reasons;
Access only does Table Locking, SQL Server has record locking
Access has a 50 concurrent user limit before it crashes - SQL Server has no
theoretical limit
Access has no native "get the identity of the current record" function
(AFAIK)
Access doesn't have Stored Procedures
Access is a bloody Desktop application! Just the part of SQL Server that
says "Server" should give some hint as to why it's better for servers 

I could go on, but I won't

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

"Websites for the real world"

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



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

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

RE: WDVL Poll

[Christian L. Watt]

Lets also keep in mind that a site that runs a poll to include CF that no
where do I see has any CF info, help, or any mention except in a poll, how
can you say that it is a valid poll without the proper exposure.  Let
Macromedia, a site of signifcant traffic from all types of developers (and a
site that does not compete with several hundred other sites offering the
same info), run this poll and lets get a true representation of the web
community!!!

CW

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:11 PM
To: CF-Talk
Subject: Re: WDVL Poll


I know what CGI is and I also know that they are inherently slower because
the Web Server needs to spawn a new process each time the CGI is called
whereas an ISAPI app (or app server like CF) does not require this.

Regards,

Howie

- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 10:03 AM
Subject: RE: WDVL Poll


> i don't know about FastCGI, but CGI is not a language in and of itself.
it's
> a standard (Common Gateway Interface) for talking to web server
components,
> etc. you can write CGI apps in PERL, C++, etc. so while i agree it might
> take longer to write a CGI app in, say, C++ than CF, i don't know if
you're
> saying CGI applications are slow, because they're not necessarily.
>
> for a good overview by NCSA, see:
>
> http://hoohoo.ncsa.uiuc.edu/cgi/intro.html
>
> --dylan
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFFTP question

[Philip Arnold - ASP]

> Let me preface this post with this, " I am very tired, I have
> been working too hard, just like all of you, and I am sick to
> boot, so please forgive my stupidity."
>
> I have been successful at using CFFTP to do all sorts of things I
> need done, except get a remote file and put it locally.  I am
> using GetFile to attempt to write a file to my C:/Temp directory
> (for testing purposes). However, when I execute the process, it
> puts the file in the C:/Temp directory on the remote machine, not
> my local machine.  Am I mis-using GetFile?  Am I screwed up in the head?
>
> Code is as follows...
>
> 
>  username="username"
> password="password"
> server="server"
> connection="test"
> stoponerror="yes">
>
> 
>   connection="test"
>  directory="directory/"
>  stoponerror="yes">
>
> 
>   connection="test"
>  remotefile="remote_file.txt"
>  localfile="C:\temp\remote_file.txt"
>  failifexists="yes"
>  stoponerror="yes">
>
> 
>  connection="test"
> stoponerror="yes">


Try specifying the directory of the remote file - I had this problem with a
PutFile that the directory fixed

remotefile="/remote_file.txt"

Pretty sure that sould fix it

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

"Websites for the real world"

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



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

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

Re: SQL Server Licensing question

[Ken Wilson]

Not a direct answer but a lead perhaps. The Q/A section references a
"Commercial Licensing Program".

Question:
Licensing Can I use Processor Licenses to commercially host applications
running on .NET Enterprise Server products?

Answer:
Microsoft does offer Processor Licenses for .NET Enterprise Server products
through its Commercial Licensing Program. Licenses (including Processor,
Server and Client Access Licenses) acquired through retail or OEM channels,
or through Microsoft's Volume Licensing Programs cannot be rented, leased or
lent to 3rd parties, or to provide commercial hosting services.



- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 1:30 PM
Subject: SQL Server Licensing question


> Hi all. Sorry for the OT post. Just got my brand new SQL Server 2000
> with 1 processor license in the mail and promptly read over the
> license. What in Gawd's name is this supposed to mean?
>
> NO RENTAL/NO COMMERCIAL HOSTING. You may not rent, lease, lend, or
> provide commercial hosting services with the Product.
>
> So, did I just throw away 4k? Can SQL Server not be used by an ISP?
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

MSXML in cfobject to Load, Send, & Retrieve XML results?

[Vano, Carl G, SITS]

Does anyone know what is wrong with my code below? I am trying to use MSXML
cfobjects to load an XML doc, then open an HTTP connection and send the XML
doc. I am expecting back a query result in XML format. 

I am new to XML & cfbjects. If anyone knows where I could view examples, or
a tutorial on XML, cfobjects, and MSXML please let me know. 

When I try to output the query result I get back the following error: 

Error 405: Method Not Allowed 

The method specified in the Request-Line is not allowed for the requested
URL (Universal Resource Locator) "/Scripts/xmlquery.py". 

Thanks! 
Carl Vano










  

http://servername/Scripts/xmlquery.py", false)>
 


  
 
 
#res#

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

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

RE: SQL Server Licensing question

[Christian L. Watt]

Yes, you can.  ColdFusion is the main user of the database at that point.  I
believe this clause is reffering to you setting up a SQL server and letting
other companies connect to it as a production database for there company,
not for web production.  Not the best articulator, but hope this answers
your question.

CW

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:30 PM
To: CF-Talk
Subject: SQL Server Licensing question


Hi all. Sorry for the OT post. Just got my brand new SQL Server 2000 
with 1 processor license in the mail and promptly read over the 
license. What in Gawd's name is this supposed to mean?

NO RENTAL/NO COMMERCIAL HOSTING. You may not rent, lease, lend, or 
provide commercial hosting services with the Product.

So, did I just throw away 4k? Can SQL Server not be used by an ISP?
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFFILE Error (why?)

[Jay Patton]

why do i get this error?
here is the query or rather the CFFile action.


  nameconflict="overwrite"
>

and here is the error.
Error Diagnostic Information
Error processing CFFILE 

Error attempting to save uploaded file to path 'D:\64.???.132.???\beta\images..' 
Access is denied. (error 5) 

The error occurred while processing an element with a general identifier of (CFFILE), 
occupying document position (294:4) to (298:4).

it worked fine the other day.
any ideas?
thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com


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

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

Re: FAQ request

[Chang Liu]

it is:
http://www.thenetprofits.co.uk/coldfusion/faq/

thank you for your reply.

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 12:52 PM
Subject: RE: FAQ request


> > Can someone  tell me the "ColdFusion FAQ" web address again?
> >
> > This address had been sent a couple days ago and the content
> > included beginner and intermediate level.
>
> It's on the front of the HOF website I think
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: FAQ request

[Chang Liu]

thank you very much!
- Original Message -
From: "Aidan Whitehall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 12:45 PM
Subject: RE: FAQ request


> > Can someone  tell me the "ColdFusion FAQ" web address again?
> >
> > This address had been sent a couple days ago and the content
> > included beginner and intermediate level.
>
> http://www.thenetprofits.co.uk/coldfusion/faq/
>
>
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
>
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Stored Procedure Question (Sybase)

[Sandi Benditt]

We are in the process of moving all our queries to stored procedures, but 
I've run into a problem that maybe someone can help me with.

Take the following query.  If I move it to a stored procedure and try to 
pass the sort variable to it I get an error along the lines of you can't 
use a variable in an order by (I forget the exact wording).


SELECT
vaba, np_code, partnum, qty,  fe_usl, asl
FROM
gvware..mytd_b3f021_parts
WHERE
asl="#url.asl#" and
trans_month="#trans_month#"
ORDER BY
   
 #sort#
   
 vaba,asl,fe_usl
   


Can anyone help?
--
Sandi Benditt
Sr. Programmer Analyst - Advanced Technologies
DecisionOne


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

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

RE: Building Cold Fusion Search - Dynamic SQL

[Maia, Eric]

The problem with this approach is that it ignores the relational model of
the two tables. Each record in empSkills will only have one value for
skillId, so you won't get any records looking for two values. You'll need to
do a self-join or subquery to look for one record in emp that has two or
more related records in empSkills that match the two skills you're looking
for. 

Try this:

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId

mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 6:43 AM
To: CF-Talk
Subject: RE: Building Cold Fusion Search - Dynamic SQL


since a multiple select gives you nothing more than a list, try a list loop.

SELECT
e.empId,
es.skillId
FROM
emp e,
empSkills es
WHERE
e.empId=es.empId
http://www.crescotech.com



-Original Message-
From: Kim Mayhall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26, 2001 2:23 PM
To: CF-Talk
Subject: Building Cold Fusion Search - Dynamic SQL


I'm trying to build some sql statements based on selections from a list box:


 Skill1
 Skill2
 Skill3
 Skill4
(etcthis size will vary as it's dynamically populated)


A user can do a multiple select, so let's say the user picked option 1 and
option 3.

On my action page, I want to pick ONLY the employees that have the 2 skills
selected.

If I use an IN statement, I get employees with one skill or the other, but I
only want those with both:

   SELECT e.empId,es.skillId
from emp e,empSkills es
where skillId IN (#frmSkill#)
AND e.empId=es.empId

How can I write the SQL to select only the employees with both, or do I use
Cold Fusion to do that?

Kim Mayhall
The Garrigan Lyman Group
http://www.glg.com 
(206) 223-5548
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Cached Query! Was Working Yesterday!

[Christian L. Watt]

If your developement server is different than your production server, make
sure that cached queries is enable in CF Adminstrator...

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:00 PM
To: CF-Talk
Subject: Cached Query! Was Working Yesterday!


CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (39:1) to (40:43).


This is the entire message.  Why would it do this?  It was working
yesterday, I went live with it, now it's failing.  I'm going insane!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Using Authentication window

[Garza, Jeff]

After the user has authenticated via the window, the CGI.AUTH_USER variable
is available on the page.  You can capture this and insert into the DB.

This is on a Win2K box with CF4.5.2.

Cheers,

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

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



-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 10:46 AM
To: CF-Talk
Subject: Using Authentication window


Does anyone know how to get a userid from a Authentication and pass that
variable to CF so that I can use it to query a DB and populate some fields?

I would appreicate it any help that you can offer.

Thanks in Advance.

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

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

Is this list alive?

[Kevin Miller]

For some reason, I seemed to have been unsubscribed.  I resubscribed this morning, but 
haven't received anything yet.

Kevin


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

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

RE: Using Authentication window

[Christopher Olive, CIO]

an authentication window?  you mean like the one IIS pops up when using
NTCR?

after authentication, check CGI.AUTH_USER (CGI.REMOTE_USER might work as
well.  i've seen them both used).

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:46 PM
To: CF-Talk
Subject: Using Authentication window


Does anyone know how to get a userid from a Authentication and pass that
variable to CF so that I can use it to query a DB and populate some fields?

I would appreicate it any help that you can offer.

Thanks in Advance.

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

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

data insert & security issues

[kenfusion]

If I am allowing users to insert data into a db via a text area in a form
what kind of security issues does that raise? And does anyone have recommendations
for how to handle those issues?





--
iWon  - Voted the #1 portal on the Web! 




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

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

RE: Display Query Horizontally

[James Rector]

One way to do it, but it can get ugly if any of the fields break to two
lines, then the table rows might not line up correctly. If that is the case
there are a few other ways to handle it...


SELECT
fname, lname, age
FROM
tbl_people








First Name


Last Name


Age










#fname#


#lname#


#age#









-Original Message-
From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 11:28 AM
To: CF-Talk
Subject: Display Query Horizontally


I have been trying to determine a way to display query's record set
horizontally oriented rather than vertically oriented and maintain proper
column and row alignment... example:

 Record1 Record2 Record3 Record4
field1   R1-F1   R2-F1   R3-F1   R4-F1
field2   R1-F2   R2-F2   R3-F2   R4-F2
field3   R1-F3   R2-F3   R3-F3   R4-F3

Is there a simple means of doing this?

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

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

RE: Domain Move and Data Integrity

[Aaron Johnson]

This is one of the prime reasons not to use an Access or file-based
database. If you use SQL Server, or any client server DB, you simply point
the new DSN to the new SQL server.  Both sites can now use the same
database.  No hassles. No updates.  No "merging" of data.

But let's put it another way. There is constant discussion of how Access is
cheaper to use... let's say in this situation that it costs you 5 to 10
hours to manage the entire process of moving, merging, talking with client,
talking with hosting provider to manage the transition.  Let's also say that
you bill $50 an hour (which is low)... We're talking about anywhere from
$250 to $500 of billable time ONLY because you're using Access.  How much is
SQL per month?  $50? Does it make sense yet to move away from Access to SQL?

Just a thought, I'm not trying to say Access isn't right for "some"
things...

Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
617.350.0339
617.350.8884
66172567
[EMAIL PROTECTED]



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 12:39 PM
To: CF-Talk
Subject: RE: Domain Move and Data Integrity


> Couldn't you just point the DSN on the access side to the SQL
> db until the
> change takes place?


I've got a similar problem.


A site is in on a server at IP address 123.0.0.10 (for example).

You move the site to a different server (at the same host or not - doesn't
make a difference) on IP 218.03.10.50

You alter the DNS entries.

Users connect to the Internet via ISPa. ISPa caches domain names so that it
resolves to 123.0.0.10 until the TTL kicks in (cognoscenti - is this how it
works?). Those users hit the site and add / modify / delete data to the
database on 123.0.0.10.

Other users connect to the Inter via ISPb. ISPb refreshes their domain name
cache earlier. Their users hit the site at 218.03.10.50 and add / modify /
delete data to the database on that server.


End result - Host1 has a database with some new entries. Host2 has a
database with some new entries.

Someone (ie the developer) has to go and mop up the differences and compile
them into the database on Host2.


Q: How can you prevent this situation arising without taking the site
completely offline until ISPb has updated their domain name cache?



Anwsers on a postcard...

--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFFTP question

[Nick Call]

Let me preface this post with this, " I am very tired, I have been working too hard, 
just like all of you, and I am sick to boot, so please forgive my stupidity."

I have been successful at using CFFTP to do all sorts of things I need done, except 
get a remote file and put it locally.  I am using GetFile to attempt to write a file 
to my C:/Temp directory (for testing purposes). However, when I execute the process, 
it puts the file in the C:/Temp directory on the remote machine, not my local machine. 
 Am I mis-using GetFile?  Am I screwed up in the head?

Code is as follows...






  


 
  

 



Please help. Thanks in advance.

Nick Call
[EMAIL PROTECTED]


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

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

Re: Display Query Horizontally

[JoshMEagle]

 // This is how many columns to display
 // This divides the total rows by the
columns to give the finished no. of rows


 
   Table Header
 


 
  
  #variable#
  
 





Joshua Miller
Web Development
Eagle Technologies Group, Inc.
Business Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]
- Original Message -
From: "Jay E Wigginton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 12:28 PM
Subject: Display Query Horizontally


> I have been trying to determine a way to display query's record set
> horizontally oriented rather than vertically oriented and maintain proper
> column and row alignment... example:
>
>  Record1 Record2 Record3 Record4
> field1   R1-F1   R2-F1   R3-F1   R4-F1
> field2   R1-F2   R2-F2   R3-F2   R4-F2
> field3   R1-F3   R2-F3   R3-F3   R4-F3
>
> Is there a simple means of doing this?
>
> thanks
> Jay
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Display Query Horizontally

[Philip Arnold - ASP]

> I have been trying to determine a way to display query's record set
> horizontally oriented rather than vertically oriented and maintain proper
> column and row alignment... example:
>
>  Record1 Record2 Record3 Record4
> field1   R1-F1   R2-F1   R3-F1   R4-F1
> field2   R1-F2   R2-F2   R3-F2   R4-F2
> field3   R1-F3   R2-F3   R3-F3   R4-F3
>
> Is there a simple means of doing this?






Record #i#




#i#

#Evaluate(i)#





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

"Websites for the real world"

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



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

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

RE: Dynamic group in output query

[Philip Arnold - ASP]

> I had a group column set dynamically for an output query, based on whether
> a form variable was passed into the template, as follows:
>
> 
> 
> 
> 
> 
>
> The variable, "queryGroup," is used in the output query, as:  query="getMainList" group=#queryGroup#> , and this works fine.
>
> Now, I have a situation where, if I pass in another form variable, I don't
> want grouping, so I need to include the whole grouping string, instead of
> just variable for which column to use. The following works in a CFOUTPUT,
> but not in a CFOUTPUT QUERY:
>
> 
> #queryGroup#
>
> I've tried all sorts of variations on:
> , but I get an "Invalid token"
> error as soon as I get to a # or < (as in a CFIF at this position).
>
> Any suggestions? I suppose I could use a CFIF statement and have two
> versions of the CFOUTPUT, but I'd rather have dynamic text within one.

Gods, you did no testing before sending this, did you?











Just remember to sort it properly in the database before the output

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

"Websites for the real world"

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


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 27 February 2001 16:31
> To: CF-Talk
> Subject: Dynamic group in output query
>
>
>
> TIA,
> --John
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

SQL Server Licensing question

[Bud]

Hi all. Sorry for the OT post. Just got my brand new SQL Server 2000 
with 1 processor license in the mail and promptly read over the 
license. What in Gawd's name is this supposed to mean?

NO RENTAL/NO COMMERCIAL HOSTING. You may not rent, lease, lend, or 
provide commercial hosting services with the Product.

So, did I just throw away 4k? Can SQL Server not be used by an ISP?
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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

Re: WDVL Poll

[Howie Hamlin]

I know what CGI is and I also know that they are inherently slower because
the Web Server needs to spawn a new process each time the CGI is called
whereas an ISAPI app (or app server like CF) does not require this.

Regards,

Howie

- Original Message -
From: "Dylan Bromby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 10:03 AM
Subject: RE: WDVL Poll


> i don't know about FastCGI, but CGI is not a language in and of itself.
it's
> a standard (Common Gateway Interface) for talking to web server
components,
> etc. you can write CGI apps in PERL, C++, etc. so while i agree it might
> take longer to write a CGI app in, say, C++ than CF, i don't know if
you're
> saying CGI applications are slow, because they're not necessarily.
>
> for a good overview by NCSA, see:
>
> http://hoohoo.ncsa.uiuc.edu/cgi/intro.html
>
> --dylan
>



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

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

Cached Query! Was Working Yesterday!

[Willy Ray]

CFQuery Retrieval of cached query failed
The error occurred while processing an element with a general identifier of (CFQUERY), 
occupying document position (39:1) to (40:43).


This is the entire message.  Why would it do this?  It was working yesterday, I went 
live with it, now it's failing.  I'm going insane!


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

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

RE: Removing Duplicate Values in a List

[Aidan Whitehall]

   SELECT DISTINCT Keywords
   FROM Photos
   ORDER BY Keywords




should work



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

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