Re:

[Justin v0.9 MacCarthy]

Did you check the logs? Maybe the mail server you are using is not allowing
you to relay mail? The logs are located in c:\cfusion\logs\

If you need an alternative:
Have a look at the www.coolfusion.com
They have a email server for posting mail at $70 ( I think ) which is far
better than the built in CF mail.


JustinMacCarthy


- Original Message -
From: Tim Bahlke <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 13, 2000 2:06 PM
Subject: RE: 


> I have looked in the Undeliverable Directory, nothing
>
> The connection to the server in CF Administrator has been verified
>
> I'm using a different server other then mine to send the emails.  Could
that
> be the problem ... do I need to send the message form the same server that
> the from address is associated with?
>
> 
> Tim Bahlke, CIFO
> thinkcreate.com
> p. 336.230.0575
> f. 336.230.0083
>
> -Original Message-
> From: Gordon Burns [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 13, 2000 1:18 AM
> To: [EMAIL PROTECTED]
> Subject: Re: 
>
> Hi Tim,
>
> Have you looked in the Undelivered Directory?
>
> Have you made sure you can connect to the SMTP server?
>
> Is thinkcreate.com allowed to send mail through the smtp server you are
> using?
>
> Regards
>
> Gordon
>
>
>
>
>
> At 21:27 12/07/00 -0700 David Shadovitz said
> >Tim,
> >Are you sure nothing is happening?  I'd try using your own email address
> >as the "To" field.
> >-David
> >
> >On Wed, 12 Jul 2000 17:27:58 -0400 "Tim Bahlke" <[EMAIL PROTECTED]>
> >writes:
> >> I have never had luck getting cfmail to work.  How does this look to
> >> y'all:
> >>
> >>  >> SUBJECT="Order
> >> #URL.sessionid#" SERVER="server1.clicktex.com">
> >>
> >> Message
> >>
> >> 
> >>
> >> When I process this page nothing happens, no email, no error,
> >> nothing, and
> >> nothing is showing up in the logs ... nothing
> >
> >YOU'RE PAYING TOO MUCH FOR THE INTERNET!
> >Juno now offers FREE Internet Access!
> >Try it today - there's no risk!  For your FREE software, visit:
> >http://dl.www.juno.com/get/tagj.
> >---
> ---
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> >
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> --

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

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

Re: Find a date from a given date

[Justin v0.9 MacCarthy]

 Oh My God... You would think he could have doubled the speed of the loop
with step=2. LOL :-)

Oh Dear,

~Justin

> 
> 
> 
> 
> 
> 
> #dateformat(date1)#
> #dateformat(date2)#
> 



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

Re: Quite simple, co

[Justin v0.9 MacCarthy]

> Gregory Harris:
> Quite simple, count the amount of Fields, and the amount of values, and
they aren't consistent you have 11 fields and 12 values, re-tool and try
again!

Nope 12 and 12.

You should try looking at the full sql that gets passed, check it for quotes
etc What DB are you using???

~Justin

> >>> [EMAIL PROTECTED] 07/12 8:05 AM >>>
> Why would this query:
>
> 
> insert into emails(
SUBJECT, FROMX, TO, DATEX,
> BODY, ATTACHMENTS, CC, MESSAGENUMBER,
> ATTACHMENTFILES, REPLYTO, HEADER, TIMEx)
> values
( 
'#query.SUBJECT#',  '#FROMX#',  '#query.TO#',  #DATEy#,
 '#query.BODY#',  '#ATTACHMENTSX#',  '#query.CC#',  '#query.MESSAGENUMBER#',
  '#ATTACHMENTFILESX#',  '#query.REPLYTO#',  '#query.HEADER#',  '#TIMEx#'
);
> 
> 
> 
> return this error?:
> 
> ODBC Error Code = 21S01 (Insert value list does not
> match column list)
> 
>  [Microsoft][ODBC Microsoft Access 97 Driver] Number
> of query values and destination fields aren't the
> same.
> 
> What's also odd is that the data is being saved to the table.
> 
> TIA,
> 
> Doug Jordon
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
> 
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
> 
> 


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

Re: cffile

[Justin v0.9 MacCarthy]

Something like "c:\inetpub\wwwroot\picapp\"
or
"YOUR_drive:\whatever_your_webroot_directory_is\

~Justin

- Original Message -
From: Daslweb - Greg <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 11, 2000 5:39 PM
Subject: cffile


> in CFfile tag what is meant by full file path
>
> ie...what is I want to place pooh.gif into
> http://www.daslweb.com/picapp/
>
> what would the code be to upload?
>
>
> Thanks, Gregory Pekofsky
>
> --

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

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

Re: Problem writing to file with

[Justin v0.9 MacCarthy]

>  encoding=" & """ & "utf-8" & """ & " ?" & ">">
>
> When I display this on the page #Data# it looks fine,
> but when I use it in the OUTPUT="#Data#" in  it puts  version="1.0" encoding="utf-8" ?>  in the file.

I think what you want to do is :



To display it in the browser

#HTMLCodeFormat(data)#

write it to a file



I thnk you are mixing up HTML escaped charactors with using chr(*) etc,

try these

 
  
  

and rewrite your code

  


~Justin MacCarthy

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

Re: WishList: ListServ interaction with Cold Fusion

[Justin v0.9 MacCarthy]

Check out iMS mailserver from www.coolfusion.com , a fully scriptable  mail
server all from CF ...

It's really good

~Justin MacCarthy

- Original Message -
From: Eric Dawson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 4:51 PM
Subject: WishList: ListServ interaction with Cold Fusion


> - I need a method of handling listserv functions.
> - I need something that I can easily integrate with Cold Fusion driven
> sites.
> - ListBot etc.
>
> What I would like to be able to do is create Cold Fusion queries that get
> passed to the mail server, and the campaign is executed. I want to have
the
> flexibility of performing "mail merge" campaigns. As well as being able to
> change the message delivered based on profile information.
>
> Example: We use to deliver annual investment statements that had different
> wording based on a persons age, and different personal account
information.
>
> Interested in learning what other people are doing. What products are
> available, and how they all tie into Cold Fusion front ends.
>
> Hope I am not too vague.
>
> Best Regards,
> Eric Dawson
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --

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

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

CF log analysis templates

[Justin v0.9 MacCarthy]

Has anyone got CF template which parse / cycle / graph the various cf logs ?

Thanks Justin 

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

Re: More than one Submit button

[Justin v0.9 MacCarthy]

>
> But, each submit button will have to have a different
> fuseaction.
>
Sure , create a hidden form field called fuseaction


Put this function in the header



and on your buttons





~Justin



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

Re: Mirroring files from one clustered server to another.

[Justin v0.9 MacCarthy]

> > BTW, Mirroring is going to be built into CF 5 (Per: allaire).
>

That's part of the ServerFarm admin tool the have in Development called
Harvest. It sounds really cool, transaction management/ clustering /
mirroring for an entire Farm etc all from one admin area


~JustinMacCarthy

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

Re: vs. (Was - Re: What am I doing wrong?)

[Justin v0.9 MacCarthy]

> names, etc., when setting them in the Application.cfm file?  Is it 
> or ?  Judging by the responses, I would assume that 


The best way is to something like






.
.
.




~Justin MacCarthy



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

Re: Offline Post to CF Site

[Justin v0.9 MacCarthy]

Solution

>Yeah, good few folks including myself  are doing this, your should look at
WDDX for this , there is an example in BenFortas book that show you how to
do this in the other direction, but it should be easy to change (in VBA) (if
you don't want to buy the book, the examples are in the wddx SDK @
www.wddx.org )

It's pretty cool if you have any questions, you know what to do..

nice email address BTW

~Justin



- Original Message -
From: Eric Dawson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 6:30 PM
Subject: Offline Post to CF Site


> I need to create a method for a realestate agent to post listings while
> talking to a client. He has a laptop.
>
> Method 1.) Go to www site, login and use online admin tools.
> Method 2.) Use some sort of offline tool to prepare the upload. Do all of
> the work, hit a button and boom, site is updated.
>
> I am thinking you might be able to use Word (He is creating a feature
sheet
> done in word already), and add a macro that does the export to html and
ftp
> to the server. Or a form post that prompts the transfer of data.
>
> Anyone doing this? (Offline creation and online posting of information)
>
> Eric
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --

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

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

Re: Bug in VB example provided with Forta's advanced book?

[Justin v0.9 MacCarthy]

also make sure you have the WDDX type lib checked in references...

~J

- Original Message -
From: Kris Marwood <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 04, 2000 11:28 AM
Subject: Bug in VB example provided with Forta's advanced book?


> Has anyone had any trouble running the A2Z bookstore WDDX / Visual Basic
> demonstration app from Ben Forta's advanced CF book? (page 380 - the code
I
> used was not included on the CD and was downloaded from forta.com) I've
just
> installed Visual Basic Pro yesterday and I'm trying to run the VB file Ben
> provides (A2Z Client.vbp), but I keep getting the following error when I
> start the program:
>
>  "run-time error 5 - Invalid procedure or call in argument" which points
to
> the following code:
>
>  For Count = 1 To StoresRS.getRowCount
> cboStores.AddItem (StoresRS.getField(Count, "NAME"))' this is the
> line in question
>   Next Count
>
> I can get the WDDX packet from the bookrobot.cfm robot into VB without a
> problem, but the above code is giving me trouble. I have set up the
> MSinet.ocx && allaire WDDX COM objects etc but I still get the error. Does
> anyone know what could be going wrong with Forta's code? The following is
> the function where the code is that is generating the runtime error.
>
> ' This executes when the application first starts up.
> ' It fetches current list of stores from CFM-based Store Robot.
> Private Sub GetStores()
>   Dim strURL As String, Count As Integer
>
>   ' Fetch WDDX Packet of data from Store Robot
>   MyXML = Inet1.OpenURL("http://127.0.0.1/robots/BookRobot.cfm")
>
>   ' Deserialize the packet into a recordset
>   Set StoresRS = MyDeser.deserialize(MyXML)
>
>   storesList.Text = MyXML
>
>   If MyXML <> "" Then
> MsgBox ("WDDX Packet Successfully retrieved from " & RobotServer &
"!")
>   End If
>
>' Clear the current entries from ListBox
>   cboStores.Clear
>
>   ' Loop through the rows of the recordset
>   ' For each row, add an item to the ListBox
>   For Count = 1 To StoresRS.getRowCount
> cboStores.AddItem (StoresRS.getField(Count, "NAME"))
>   Next Count
>
>
>   ' Select the first item in the ListBox
>   cboStores.ListIndex = 0
>
> End Sub
>
> Any help would be much appreciated
>
> Kris Marwood
> Technical Manager
> Reaction Media Group
> [EMAIL PROTECTED]
> www.reactionmedia.com.au
>
> Web Development + e-Commerce + Multimedia
>
>
>
> --

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

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

Re: Can you loop a CFMAIL tag w/o a query?

[Justin v0.9 MacCarthy]

If you are doing a lot of bulk mail-shots or mail lists you should look at
the POST server at www.coolfusion.com
or
http://www.coolfusion.com/post_se.htm
for $79

It beats the heck out or the CFmail ...

~Justin MacCarthy

- Original Message -
From: Roberts, Jesse D <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 03, 2000 7:29 PM
Subject: RE: Can you loop a CFMAIL tag w/o a query?


> I've used this type of method before.  This code is modified from what I
use
> in my case, but you get the idea.
>
> 
>  TO="#Email_Address#"
>FROM="[EMAIL PROTECTED]"
> SUBJECT="Subject"
> SERVER="mail.domain.com">
>
> Message text.
>
> 
> 
>
> Jesse D. Roberts
> Business Process Analyst
> Procurement Quality Assurance
> Boeing - Huntington Beach, CA
> [EMAIL PROTECTED]
> Ph. 714-896-3462
> Fx. 714-896-3303
>
> > -Original Message-
> > From: Jeff Bearer [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, July 03, 2000 10:59 AM
> > To: cf-talk
> > Subject: Can you loop a CFMAIL tag w/o a query?
> >
> > I'm working on something that will upload a text file and then parse
> > info and send out mail to the addresses that are loaded into an array,
> > but CFMAIL tells me that you can't use a CFOUTPUT tag in a CFMAIL tag
> > unless you have the QUERY attribute.
> >
> > Is there a way to do this or am I going to have the load this data into
> > the database?  After the mail is sent the information is not needed so
> > it's kinda silly to load it into the database.
> >
> > -Jeff Bearer
>
> --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> --

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

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

Re: limiting upload file size - solution

[Justin v0.9 MacCarthy]

 Hi all ,

To do this use you can use the
CGI.CONTENT_LENGTH variable 

Justin MacCarthy



- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 03, 2000 3:04 AM
Subject: Re: limiting upload file size


>
>
>
>
> >I want to not upload at all if the file is bigger than 1MB. How can this
be
> >done?
>
> I can't think of a way to do this, but while I was looking around for a
solution
> I found this page about file upload fields which is quite informative:
> http://www.hut.fi/u/jkorpela/forms/file.html
>
> I hope this is of some interest.
>
> 
> Rob Keniger
>
>
> --

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

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

Re: UPS CHECK DIGIT

[Justin v0.9 MacCarthy]

Just a comment, that's the kind of thing I would have written that as a
 block. It would be  a little faster and less bulky looking 

~Justin MacCarthy


- Original Message -
From: Zachary Bedell <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 02, 2000 2:36 PM
Subject: RE: UPS CHECK DIGIT


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> > This is what I came up with.  Anyone have anything any faster?
>
> I'm not sure if this is any faster, but I think it's a little easier
> to grok.
>
> It's not in tag form, but should be easy enough to tagify...
>
> Hope this helps.
>
> Best regards,
> Zachary Bedell
>
> 
>
> 
> 
>  Len(TrackingNumber) - 2)>
> 
>
> 
> 
> 
> 
> 
> 
> 
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.3 for non-commercial use 
>
> iQA/AwUBOV9FWAraVoMWBwRBEQI5LwCgij+D/1gd5yYg3gaawmpfeeyFaJoAn0AM
> qIetaKh9+3recuB2SXkNgehD
> =C8gi
> -END PGP SIGNATURE-
> --

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

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

Re: Wow! activepdf rules

[Justin v0.9 MacCarthy]

These guys LOOK great , but are VERY low on details , anyone using them???

www.i-doc.net

Thanks
~Justin

- Original Message -
From: Stephen M. Aylor <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 01, 2000 4:21 PM
Subject: Re: Wow! activepdf rules


> COOL, All my "yappin" on pdf maybe helped eh? :-)
>
> Also - you may have a look at Digital Applications' tools.
>
> www.digapp.com  FDF Merge  AppendPDF and they will even license you
"their"
> PDF Library (expensive).
>
> Does ActivePDF have a Linux/Solaris solution, pretty sure they're NT
> centric.  Digital Applications stuff is a bit more cross platform if that
> matters to you.
>
> Now if we can just figure out how to "embed" an XML doc inside the PDF,
and
> then extract the xml 'data' programatically cha ching :-)
>
> All the best,
>
> Steve
>
>
> > >>> Sean Renet <[EMAIL PROTECTED]> Saturday, July 01, 2000
> > >>>
> > If anyone needs a CF to PDF solution, I highly recommend
> > http://www.activepdf.com/.  I have been playing with an eval version
> > of
> > thier activePDF Toolkit and it is incredilbe.  The control it gives you
> > for
> > creating on the fly custom PDF's using CF has me giddy.  So I thought
> > I
> > would share it all with you.  I have been pulling my hair out trying to
> > get
> > CF to work with Crystal Reports 8 and someone suggested I give
> > activepdf a
> > try.  The CF application of activepdf isn't documented too well, but I
> > called the sales number and talked to someone named Tim that was
> > amazingly
> > helpful. Anyway I just thought I would spread the word because I
> > cannot
> > begin to tell you what a relief finding this solution was.
>
>
> --

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

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

Re: CF 3.1 docs?

[Justin v0.9 MacCarthy]

Chris check out:

http://www1.allaire.com/Handlers/index.cfm?ID=6248&Method=Full&Cache=Off


~Justin

- Original Message -
From: Chris Evans <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 29, 2000 2:57 PM
Subject: CF 3.1 docs?


> I'm looking for the docs for 3.1, to support a client with that version.
> Does anybody have a link to them online?
>
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
>
>
> --

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

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

Mac File Uploads + extensions

[Justin v0.9 MacCarthy]

How are people dealing with files uploaded by AppleMacs. How can you tell
what type of files they are ??

~Justin

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

Re: row numbers

[Justin v0.9 MacCarthy]

Sure is #Queryname.CurrentRow#

~Justin
- Original Message -
From: Douglas Jordon <[EMAIL PROTECTED]>
To: Cold Fusion List <[EMAIL PROTECTED]>
Sent: Wednesday, June 28, 2000 5:19 PM
Subject: row numbers


> Is there a way to find out which row number any given record is?
>
> TIA,
>
> Doug Jordon
> --

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

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

Running Cf under a user account - It's official: I'm stupid

[Justin v0.9 MacCarthy]

I fixed this - I had forgot to add that user as an account on my SQL Box

I need a day off  ( uptime is 22 days )

~Justin


> -Original Message-
> From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
> Sent: 28 June 2000 11:42
> To: [cftalk]
> Subject: Running Cf under a user account
>
>
> Hi Everybody,
>
> I'm having a problem running CF under a user account,it works fine
> except for ODBC connections.
> I've followed Kb Article 11859 but with no luck ... any ideas ???
>
> ~Justin
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

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

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

Re: Running Cf under a user account

[Justin v0.9 MacCarthy]

What do you mean ???

> How many accounts have you got?


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

Running Cf under a user account

[Justin v0.9 MacCarthy]

Hi Everybody,

I'm having a problem running CF under a user account,it works fine
except for ODBC connections.
I've followed Kb Article 11859 but with no luck ... any ideas ???

~Justin

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

Re: NULL using it in CF

[Justin v0.9 MacCarthy]

> > ColdFusion uses either BSTRs or MFC CStrings (which are implemented
> > as BSTRs, I believe) instead of the usual C/C++ NULL terminated
> > strings.
>
> Ah. The evil legacy of Visual Basic strikes again. :) In that case, yea,
len
> when be faster.
>
> Thanks for pointing that out. Had slipped my mind for some reason.
>
> --min
>

So is Len faster on *nix ???  :-) I wonder if we'll have to rewrite the
rules as the new Java architecture is rolled out ...


~Justin MacCarthy

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

Server times + international site

[Justin v0.9 MacCarthy]

Hi All,

Can anyone tell me how they deal with Timezones??? We are doing a web
Application , which will be used (hopefully :- 0 ) by folks across several
timezones.
Should we set are system clock to GMT and offset the timezones in the code
 Anyone dealt with this already??


~Justin

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

Re: NULL using it in CF

[Justin v0.9 MacCarthy]

Use


do something
- Original Message -
From: Colin Robinson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 27, 2000 12:14 PM
Subject: NULL using it in CF


> Could someone please tell me what is wrong with the following:
>
> do something
>
> I get :
> Error resolving parameter NULL
>
>
> Colin Robinson
> In-tuition.co.uk
> Tel: +44 (0) 1825 746400
> ICQ: 74207528
>
> --

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

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

Re: what's the name of my server?

[Justin v0.9 MacCarthy]

Greg, check out CFX_SystemInfo @
www. intrafoundation.com

SHould give you want you are looking for

~Justin MacCarthy
www.cfug.ie


- Original Message -
From: Greg Saunders <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 26, 2000 6:21 PM
Subject: what's the name of my server?


> I want to programmatically get the name of the server on which CF is
> running, which I believe I can only do through the registry
> (cgi.server_name will not work).
>
> Anyone know where I should look in the registry?  A quick scan turned it
up
> in a few different places, but I want to make sure i find something
reliable.
>
> thanks,
>
> Gregory M. Saunders, Ph.D.
> Senior Design Architect
> Cognitive Arts Corporation  (http://www.cognitivearts.com)
> 1840 Oak Avenue, 4th Floor
> Evanston, IL 60201-5914
> --

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

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

Running CF under a different user

[Justin v0.9 MacCarthy]

HI all,

I've got the service running under a user (cfserver) but I can't get any
odbc DataSources to work.
I have followed article 11859 in the Allaire KnowledgeBase. If I change back
to the system account all my odbc's work.
I think it is permissions thing ...anyone know?

~Justin MacCarthy



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

Re: Logical Limit of NT User Accounts

[Justin v0.9 MacCarthy]

FROM

http://sam.cs.unc.edu/ntfaq.html

Q. How many user accounts can I have in one Domain?

A. The real problem is that each user account and machine account takes up
space in the SAM file, and the SAM file has to be memory resident. A user
account takes up 1024 bytes of memory (a machine account half as much), so
for each person (assuming they each had one machine) would be 1.5 KB. This
would mean for a 10,000 user domain each PDC/BDC would need 15MB of memory
just to store the SAM! Imagine a network with 100,000 people. This is one of
the reasons you have multiple domains and then setup trust relationships.

FROM

http://sam.cs.unc.edu/ntfaq.html



~Justin MacCarthy


- Original Message -
From: David B. Brooks <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 5:17 PM
Subject: Logical Limit of NT User Accounts


> Greetings All,
>
> I'm going to utilize Cold Fusion's Advanced Security using my local NT
> Domain for authentication.  Does anyone know the logical limit to the
number
> of users NT can handle in its database?
>
> Thanks for all the info!
>
> David Brooks
> PC Pros, Inc.
>
> --

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

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

Re: Changing file permissions in Unix

[Justin v0.9 MacCarthy]

Using the mode attribute in File = upload ???

MODE=777 etc

just your standard chmod numbers

Or you chould try cfexecute chmod etc...

BTW the is a linux cf list @ [EMAIL PROTECTED] 

~Justin

> We have our CF user (www) file permissions set to owner read-write only
(no group or world read or write), and like it that way for most instances.
However, in one case, we need to change a file generated by CF to group
read-write.  Is there a chmod command available in CF, or is there some
command that allows you to plug in a Unix command?
>
> Thanks.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
>

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

Re: [Another Way...]Checking for a record, and then deleting it

[Justin v0.9 MacCarthy]

The correct way in ANSI SQL
would be something Like

DELETE FROM SystemQuote WHERE CFID Exists IN
(
Select CFID
FROM SystemQuote
WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
)

Check the syntax but something like that .

Justin

- Original Message -
From: Chris Terrebonne <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 23, 2000 4:09 PM
Subject: RE: [Another Way...]Checking for a record, and then deleting it


> Never tried it on Oracle.  It works great on MS SQL 7.
> Check the Oracle docs for the correct SQL format of the statement and it
> should work
>
> Chris
> --
> Original Message
> From: "Frédéric LeMieux"<[EMAIL PROTECTED]>
> Subject: RE: [Another Way...]Checking for a record, and then deleting it
> Date: Fri, 23 Jun 2000 09:52:08 -0400
>
> >hmmm I never saw that kind of SQL statement. So I tried, and it is
not
> >working !
> >The Oracle Database returns "Invalid SQL statement".
> >
> >Where did you see that king of statement ? Can you give me more
information
> >on how to make this king of SQL working ?
> >
> >
> >-Original Message-
> >From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, June 23, 2000 9:48 AM
> >To: [EMAIL PROTECTED]
> >Subject: Re:[Another Way...]Checking for a record, and then deleting it
> >
> >
> >Or you could do it all via SQL:
> >
> >
> >IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND
> >CFTOKEN=#CFTOKEN#)) > 0)
> > DELETE FROM SystemQuote WHERE CFID = #CFID#
> >
> >
> >Chris
> >--
> >Original Message
> >From: "Chris Terrebonne"<[EMAIL PROTECTED]>
> >Subject: Re:Checking for a record, and then deleting it
> >Date: Fri, 23 Jun 2000 08:43:08 -0500
> >
> >>Just test for the RecordCount...
> >>
> >>
> >>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
> >>
> >>
> >>
> >> 
> >> DELETE FROM SystemQuote WHERE CFID = #CFID#
> >> 
> >>
> >>
> >>--
> >>Original Message
> >>From: "Chris Farrugia"<[EMAIL PROTECTED]>
> >>Subject: Checking for a record, and then deleting it
> >>Date: Thu, 22 Jun 2000 21:24:46 -0400
> >>
> >>>I have a table in a database that contains the fields CFID, CFTOKEN,
WDDX
> >>>(which is an array that I used CFWDDX on), and the date.  It is for a
> >>system
> >>>configurator for new computer systems.  When someone fills in the forms
> >for
> >>>what they want on their system, it puts it in a database, then they can
> >>>click a reconfigure button...  that takes them back to the form they
just
> >>>filled out so they can reconfigure their system.  THen they hit the
> submit
> >>>button again and here I need to check if a record in the quotes table
> >>>already exists (meaning this is at least the second time they've
> >configured
> >>>a system), and if it exists, then that record needs to be deleted.
Here
> >is
> >>>the code I've tried but it doesn't work:
> >>>
> >>>
> >>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
> >>>
> >>>
> >>>
> >>>
> >>> 
> >>> DELETE FROM SystemQuote WHERE CFID = #CFID#
> >>> 
> >>>
> >>>
> >>>
> >>>
> >>>Does anybody know of a way of doing this?  Thanks in advance.
> >>>
>
>>>-
> -
> >-
> >>---
> >>>Archives: http://www.eGroups.com/list/cf-talk
> >>>To Unsubscribe visit
> >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >>send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> >>the body.
> >>>
> >>
> >>_
> >>Free email with personality! Over 200 domains!
> >>http://www.MyOwnEmail.com
> >>
>
>>--
> -
> >---
> >>Archives: http://www.eGroups.com/list/cf-talk
> >>To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
> >>
> >
> >_
> >Free email with personality! Over 200 domains!
> >http://www.MyOwnEmail.com
> >
>
>---
> -
> >--
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
> >
>
>---
> ---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> _
> Free email with personality! Over 200 domains!
> http://www.MyOwnEmail.com
>
> ---

Re:

[Justin v0.9 MacCarthy]

Tim, you might want to combine CF and JavaScript for what you want to do.
For example :


SELECT Name
FROM dB



#name#


Hope that helps

~JustinMacCarthy

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

Re: SQL Server/CF Question

[Justin v0.9 MacCarthy]

On the memory note I think SQL server will only use a upper limit of 3Gb of
RAM...

~JustinMacCarthy


> As I've said, SQL Server LOVES memory, and the more you can give it, the
> happier it is, but a 512Mb lower limit should be noted, below that and it
> does run slower... 1Gb RAM should give flying performance (I'm jealous of
> the amount you've got )


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

Re:

[Justin v0.9 MacCarthy]

No
- Original Message -
From: Tim Bahlke <[EMAIL PROTECTED]>
To: Cf-Talk <[EMAIL PROTECTED]>
Sent: Thursday, June 22, 2000 5:43 PM
Subject: 


> Can I call a  function through a link like a javascript
function.
>
> Like ...
>
> blah
>
> 
> Tim Bahlke, CIFO
> thinkcreate.com
> p. 336.230.0575
> f. 336.230.0083
>
>
>
> --

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

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

Re: äãéîòî ä÷éèñéèèñì úéæëøîä äëùìä

[Justin v0.9 MacCarthy]

CF doesn't support Unicode at this time. However I believe the next release
will.

~JustinMacCarthy

- Original Message -
From: jonathan hamner <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 5:19 PM
Subject: äãéîòî ä÷éèñéèèñì úéæëøîä äëùìä


> Is there a way to have CF store input to a form in
> another language besides english( like : Arabic,
> Japanese, chinese etc) in SQL Server database?
>
> Thanks A lot
>
>
>
> __
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
> --

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

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

Re: CFX execution time

[Justin v0.9 MacCarthy]

Is the CFX set to remain loaded in memory?

~Justin

- Original Message -
From: Michel Vuijlsteke <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 4:21 PM
Subject: CFX execution time


> Hello.
>
> I have Delphi-built cfx that takes 2 integers and returns them to me
> multiplied with a status code.
>
> Is it normal for a simple cfx like that to take more than 2 seconds to
> process?
>
> Thing is, a more complex cfx which does a complex calculation involving a
> third-party dll and binary files holding data takes approx. the same time.
>
> Is there really an almost 2 s overhead for cfx tags? All this in NT4, CF
> 4.01, 512 Mb RAM, with no significant load on the machine and using the
> standard delphi framework as described in the Forta book.
>
> Michel Vuijlsteke
> Netpoint NV
> --

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

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

Re: Need help with a SQL query

[Justin v0.9 MacCarthy]

Hi Seth,

This book also has info on cross Tabulations which what you want 
Also there are scripts here http://www.swynk.com/sqlhome/6xlibrary.asp for
doing this ...
BTW It's an excellent site for SQL
~Justin

>Have a look at Joe Cleko's books SQL for Smarties  . He has lots on these
>types of relationships IE trees.
>Also there are lots of SQL functions examples to answer questions like

>Path Enumeration
>Finding root and "Leaf " nodes
>Subtree deletetion
>etc

>IMO His books are a must have for "Real World SQL users" :-)

>Checkem' out at :
.http://www.amazon.co.uk/exec/obidos/ASIN/1558604324/qid=961587236/sr=1-1/02
6
-2836789-6296449
http://www.amazon.co.uk/exec/obidos/ASIN/1558603239/qid=961587236/sr=1-3/026
-2836789-6296449


~ JustinMacCarthy


- Original Message -
From: Seth Petry-Johnson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 12:11 AM
Subject: Need help with a SQL query


> Sorry about the non-descriptive subject, but I'm tired and really couldn't
> think of a way to describe my question in one line .
>
> I have a database table of product information and a database table of
> product category information.  Each product may exist in more than one
> category, so I created a "mappings" table that simply contains
> ItemID-CategoryID pairs.  This is all well and good.
>
> I am trying to write a product details query that includes a comma
delimited
> list of the CategoryIDs that the product belongs to.  Currently I run two
> queries: one for the data from the product table and another for the
> CategoryIDs from the mappings table.  Then I create a list of the Category
> IDs and manually add the list to the query of other product data.
>
> Is there a way to get SQL to do this for me in one query?  As far as I
know
> subqueries are only useful when they return a single value, which won't
> quite work here.  Any ideas?
>
> Thanks in advance,
> Seth Petry-Johnson
> Argo Enterprise and Associates
>
>
>
> --

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

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

Re: Database Design Question

[Justin v0.9 MacCarthy]

Hi Brook,

Have a look at Joe Cleko's books SQL for Smarties  . He has lots on these
types of relationships IE trees.
Also there are lots of SQL functions examples to answer questions like

Path Enumeration
Finding root and "Leaf " nodes
Subtree deletetion
etc

IMO His books are a must have for "Real World SQL users" :-)

Checkem' out at :

http://www.amazon.co.uk/exec/obidos/ASIN/1558604324/qid=961587236/sr=1-1/026
-2836789-6296449
http://www.amazon.co.uk/exec/obidos/ASIN/1558603239/qid=961587236/sr=1-3/026
-2836789-6296449


~ JustinMacCarthy




- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 12:23 PM
Subject: RE: Database Design Question


> The standard way to take care of this is a self-referencing table, and a
> recursive function to bust them out.
>
> ID|Parent_ID
>
> Top levels have an id of 0, and the other rows work well with an
autonumber
> in the id.
>
> If children can have multiple parents, as in a BOM(Bill of Materials)
> problem, you'll need two tables of course.
>
>
> -Original Message-
> From: Brook Davies [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 20, 2000 6:42 PM
> To: [EMAIL PROTECTED]
> Subject: Database Design Question
>
> I have listings that look like:
>
> 1.0 foobars
> 1.1 foobars the revenge
> 1.1.2 foobars the revenge II
> 1.1.2.1 more foobar specials
> 2.0 brown foobars
> 3.0 green foobars
>
> etc..
>
> What is the best DB design in terms of performance for a classification
> system like this?
>
> Thanks,
> Brook Davies
> MaracasMedia Inc.
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

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

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

Re: COM object/Interface problems

[Justin v0.9 MacCarthy]

Try using cfx_spawn from Intrafoundation.com

~J


- Original Message -
From: Russel Madere <[EMAIL PROTECTED]>
To: Cf Talk <[EMAIL PROTECTED]>
Sent: Wednesday, June 21, 2000 2:59 AM
Subject: COM object/Interface problems


> Does Cold Fusion implement COM objects/interfaces differently from the
> command line?
>
> I have a command line program that works fine.  When I run the exact same
> program with the CFEXECUTE tag, and the same attributes, it does not work.
> When I look into the resulting files (shortcuts) there is a critical part
> missing that causes them not to work properly.
>
> Any help would be appreciated.
>
> Russel Madere
>
> --

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

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

Re: Getting Last Directory Name from Path

[Justin v0.9 MacCarthy]

Something like ...

#listgetat(path,Listlen(path,"/")-1,"/")#


- Original Message -
From: Chris Montgomery <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 6:19 PM
Subject: Getting Last Directory Name from Path


> Howdy,
>
> What's the best way to get the last directory name from a path?  For
> example, in this path:
>
> directory1/directory2/directory3/filename.cfm
>
> I want to extract just directory3.
>
> Any help much appreciated.
>
> Chris Montgomery   [EMAIL PROTECTED]
> :: Web development/Consulting  http://www.astutia.com ::
> :: Allaire Consulting Partner/ NetObjects Reseller::
> :: 210-490-3249/888-745-7603   Fax 210-490-4692   ::
>
> --

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

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

Re: Mail Servers

[Justin v0.9 MacCarthy]

Sure but what platform, features do you need ??

~JustinMacCarthy

- Original Message -
From: Steve Robson <[EMAIL PROTECTED]>
To: House of Fusion (E-mail) <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 12:54 PM
Subject: OT: Mail Servers


> Does anyone know of any email servers that will scale to several million
> mailboxes (about 3-5 million)?
>
> Thanks
> Steve
> --

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

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

Re: Parsing variables?

[Justin v0.9 MacCarthy]

SELECT * FROM table WHERE id = #ID#

or more correctly

SELECT * FROM table WHERE id = #URL.ID#

~JustinMacCarthy

- Original Message -
From: WL <[EMAIL PROTECTED]>
To: Cold Fusion Talk <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 12:09 PM
Subject: Parsing variables?


> [nb: beginners' question.  Hope you all don't mind]
>
> Hi.
>
> I've dealt with PHP for some time and am moving into CF at the moment.
> Could someone explain how I parse data and variables in CF?  I have a
number
> of SQL statements which generate an ID to be used in another SQL statement
> on another page, as follows:
>
> 
> 
> #subject#
> 
> 
>
> In show.cfm, what should the WHERE part of the Sql look like?
>
> Thanks for any help.
>
> Will
>
> --

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

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

Re: http/wddx-confused....

[Justin v0.9 MacCarthy]

Use Something like ...

ReReplace(NEWS,"(*)","\1")

- Original Message -
From: Bosky, Dave <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 19, 2000 4:39 PM
Subject: http/wddx-confused


> I am pulling in a news page but I want to strip out everything except
> information
> contained within  tags.  I remember doing something similar to this
> in
> advanced cf class but now I'm having trouble doing it.
>
> Any help would be appreciated..
>
> Thanks,
> Dave
>
> --

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

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

Re: How to stop an infinite CF loop?

[Justin v0.9 MacCarthy]

What about using these settings in the Admin?

Timeout requests
 Set a value to limit the amount of time ColdFusion waits before terminating
a request.

Restart unresponsive server
 This option allows you to restart the ColdFusion Server service (daemon) in
the event some ColdFusion component does not respond within the specified
amount of time.


~J

- Original Message -
From: Chris Evans <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 19, 2000 2:58 PM
Subject: RE: How to stop an infinite CF loop?


> There is no way to stop an individual template during execution.  The only
> way to stop it is to cycle the service.
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
>
>
> -Original Message-
> From: Lon Lentz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 19, 2000 9:48 AM
> To: [EMAIL PROTECTED]
> Subject: RE: How to stop an infinite CF loop?
>
>
>
>Actually, this was the first time this has happened with this tag. We
> renamed the tag and solved the problem. I'm just looking for a possible
way
> of stopping a similar situation in the future.
>
>
> Lon Lentz
> Applications Developer - GetLists.Com
> DataWarehousing and List Sales - Market your lists on the Net!
> [EMAIL PROTECTED]
> 941-541-9000 Ext. 210
>
> -Original Message-
> From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 19, 2000 4:12 AM
> To: [EMAIL PROTECTED]
> Subject: Re: How to stop an infinite CF loop?
>
>
> have you isolated the tag? If so why not just fix it.
>
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> --

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

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