file transfers

[Trace]

Hello everybody,

I am about to start writing code that allows a user to be able to download
and upload batch files to a server through a web interface. Before starting
this, I would like to ask some advice. Is the best method for this to loop
the files using cfftp? I have been looking through the custom tags and there
doesn't seem to one that does batch file uploads/downloads (unless I missed
it). Is there a custom tag that anybody has experience with that they would
recommend?

Thank you in advance,

Trace

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT:SQL syntax error in mySQL

[Trace]

Hi everybody,

I have just switched a cf site from using a MSAccess database to mySQL . The
following query produces and error now (did work in MSAccess):

SELECT   t.transID, a.authorID, g.groupID, ts.transName
FROM (tbl_authors a INNER JOIN tbl_groups g
 ON a.GroupID = g.groupID)
INNER JOIN
(tbl_transcripts t LEFT JOIN tbl_transcriptionists ts
 ON t.TransID=ts.TransID)
ON a.AuthorID = t.AuthorID
WHEREt.status = 20


If I take out the LEFT JOIN statement and use this query instead, it works
just fine:

SELECTt.transID, a.authorID, g.groupID
 FROM  (tbl_authors a INNER JOIN tbl_groups g
 ON a.GroupID = g.groupID)
INNER JOIN
tbl_transcripts t
ON a.AuthorID = t.AuthorID
 WHERE   t.status = 20

I am new to mySQL. Is there a limit to the number of nested joins in a
query? The error I get is:


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: OT:SQL syntax error in mySQL

[Trace]

sorry...here is the error I get:

Error Diagnostic Information

ODBC Error Code = 42000 (Syntax error or access violation)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.53-max]You have an error in your SQL
syntax near 'LEFT JOIN tbl_transcriptionists ts ON t.TransID=ts.TransID) ON
a.Aut' at line 5

SQL = SELECT t.transID, a.authorID, g.groupID, ts.transName FROM
(tbl_authors a INNER JOIN tbl_groups g ON a.GroupID = g.groupID) INNER JOIN
tbl_transcripts t LEFT JOIN tbl_transcriptionists ts ON
t.TransID=ts.TransID) ON a.AuthorID = t.AuthorID WHERE t.transcriptstatus =
20

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (18:1) to (18:57) in the template
file C:\Inetpub\wwwroot\temp\mytemplate.cfm.


Anyhow, if anybody has a clue about this, it would be GREATLY appreciated.

Thanks!

Trace





- Original Message -
From: Trace [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 3:09 PM
Subject: OT:SQL syntax error in mySQL


 Hi everybody,

 I have just switched a cf site from using a MSAccess database to mySQL .
The
 following query produces and error now (did work in MSAccess):

 SELECT   t.transID, a.authorID, g.groupID, ts.transName
 FROM (tbl_authors a INNER JOIN tbl_groups g
  ON a.GroupID = g.groupID)
 INNER JOIN
 (tbl_transcripts t LEFT JOIN tbl_transcriptionists ts
  ON t.TransID=ts.TransID)
 ON a.AuthorID = t.AuthorID
 WHEREt.status = 20


 If I take out the LEFT JOIN statement and use this query instead, it works
 just fine:

 SELECTt.transID, a.authorID, g.groupID
  FROM  (tbl_authors a INNER JOIN tbl_groups g
  ON a.GroupID = g.groupID)
 INNER JOIN
 tbl_transcripts t
 ON a.AuthorID = t.AuthorID
  WHERE   t.status = 20

 I am new to mySQL. Is there a limit to the number of nested joins in a
 query? The error I get is:


 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

OT: Powerpoint Com object

[Trace]

Hi everyone,

This is not specificaly a cold fusion question but I am hoping somebody
might have experience in this:

I have been using the powerpoint com object (with very helpful information
from cfcomet.com) to convert PowerPoint into jpg's. My question is: Is there
another alternative if the server does not have PowerPoint installed? The
site that requires this PowerPoint conversion is on a shared hosting plan.
The hosting company supports COM objects and asked me to send the the .dll
file. I am completely new to COM objects and am not too sure where to go
from here in regards to the PowerPoint object. I have been doing some
research and found that the Microsoft PowerPoint object model is provided by
MSPPT.OLB (MSPPT9.OLB for WIN2K). Am I going in the right direction?

Thanks for any help,
Trace

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Query question

[Trace]

Is there a way to refer to 2 fields in one query with the same name?

I have a field called title in table tbl_Pages and a field called Name
in table tbl_Categories

cfquery name=getHyperlinks datasource=#ds#
SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS
hyperlink_title
FROM   tbl_Pages,  tbl_Categories
/cfquery

Obviously the above gives me the error: Duplicate output alias
'hyperlink_title'

Is there a way around this? This is for cf 4.5.

Thanks,
Trace

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Query question

[Trace]

Is there a way to refer to 2 fields in one query with the same name?

I have a field called title in table tbl_Pages and a field called Name
in table tbl_Categories

cfquery name=getHyperlinks datasource=#ds#
SELECTtbl_Pages.title AS hyperlink_title, 
  tbl_Categories.Name AS hyperlink_title
FROM   tbl_Pages,  tbl_Categories
/cfquery

Obviously the above gives me the error: Duplicate output alias
'hyperlink_title'

Is there a way around this? This is for cf 4.5.

Thanks,
Trace
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Query question

[Trace]

It was for concatenating the 2 fields into one. But Dave answered my
question.

Thank you,

Trace

- Original Message -
From: Jerry Johnson
To: CF-Talk
Sent: Tuesday, May 28, 2002 1:04 PM
Subject: Re: Query question


What are you trying to get?

1. a query with all the titles from pages added to all the names from
categories?

2. a single field that concatenates the title and the name together?

3. something I'm not seeing?

Jerry Johnson

 [EMAIL PROTECTED] 05/28/02 02:53PM 
Is there a way to refer to 2 fields in one query with the same name?

I have a field called title in table tbl_Pages and a field called Name
in table tbl_Categories

cfquery name=getHyperlinks datasource=#ds#
SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS
hyperlink_title
FROM   tbl_Pages,  tbl_Categories
/cfquery

Obviously the above gives me the error: Duplicate output alias
'hyperlink_title'

Is there a way around this? This is for cf 4.5.

Thanks,
Trace



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Spiders and SES urls

[Trace]

Hi guys,

I am not so sure how search engine spiders work so I hope this does not sound like a 
stupid question: If I use SES (search engine safe) urls, does the spider read the file 
after it has been to the cf server? In other words, will the spider index the page 
after it has grabbed the dynamic content from the database? Like a browser would?

Thanks,

Trace
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Spiders and SES urls

[Trace]

Forgot the example of a url I would be using:

somesite.com/index.cfm/id/19.htm

instead of :

somesite.com/index.cfm?id=19

Trace

- Original Message - 
  From: Trace 
  To: CF-Talk 
  Sent: Sunday, May 12, 2002 5:24 PM
  Subject: Spiders and SES urls


  Hi guys,

  I am not so sure how search engine spiders work so I hope this does not sound like a 
stupid question: If I use SES (search engine safe) urls, does the spider read the file 
after it has been to the cf server? In other words, will the spider index the page 
after it has grabbed the dynamic content from the database? Like a browser would?

  Thanks,

  Trace
  
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Spiders and SES urls

[Trace]

Great...thanks Paul!
  - Original Message - 
  From: Paul Giesenhagen 
  To: CF-Talk 
  Sent: Sunday, May 12, 2002 5:23 PM
  Subject: Re: Spiders and SES urls


  Yes it will, the spider acts like a browser...(at least most of them)

  Paul Giesenhagen
  QuillDesign
  http://www.quilldesign.com

  - Original Message -
  From: Trace [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Sunday, May 12, 2002 7:24 PM
  Subject: Spiders and SES urls


   Hi guys,
  
   I am not so sure how search engine spiders work so I hope this does not
  sound like a stupid question: If I use SES (search engine safe) urls, does
  the spider read the file after it has been to the cf server? In other words,
  will the spider index the page after it has grabbed the dynamic content from
  the database? Like a browser would?
  
   Thanks,
  
   Trace
   
  
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfx_html2pdf

[Trace]

Hello

I am using cfx_html2pdf (the java version) and have it working except that
images do not show up in the pdf. Has anybody come across this before? I am
only converting a template with some text and an image but for the rest, I
am using the exact example code that came with the tag.
I set the
Java Virtual Machine Path= c:/jdk1.3.1/jre/bin/classic/jvm.dll
Class Path= c:/cfusion/java/classes
When installing JDK 1.3.1, I set the system paths (under control
panel/system/advanced) to the correct path (C:\jdk1.3.1\bin ).

If anyone has an idea about this I would greatly appreciate it. Below is
code used:

The page that gets converted:

HTMLHEADTITLEA sample for HTML2PDF tag/TITLE/HEADBODY

h1font color=RedThis is a sample page for HTML2PDF custom
tag./font/h1
Sample text
br
img src=images/sample.GIF width=109 height=29 alt= border=0
div align=centerA nice picture/div

CFINCLUDE TEMPLATE=topdf.inc

/BODY/HTML

*


The topdf.inc template:
*
CFSET s = http://;  CGI.SERVER_NAME  CGI.SCRIPT_NAME
CFSET qs = CGI.QUERY_STRING
cfoutput
form action=toPdf.cfm method=post
input type=hidden name=sourceurl VALUE=#s#
input type=hidden name=sourceqs VALUE=#qs#
div align=centerinput type=submit value=To PDF FILE/div
 /form
  /cfoutput
*


The topdf.cfm template:
*
HTMLHTMLHEADTITLEPDF Generator/TITLE/HEADBODY
 cfset url=#sourceurl#

cfif sourceqs is not 
cfset url=url?#sourceqs#
/cfif
 CFHTTP
URL =  #url#
resolveurl = 1
throwonerror = Yes
/CFHTTP

cfset filename = #rand()#.pdf
CFX_Html2pdf
html_String=#cfhttp.filecontent#
outputfile=c:\inetpub\wwwroot\#filename#
imagesdir=c:\inetpub\wwwroot\images\
header=HTML2PDF Demo Page
footer=HTML2PDF Demo
hd_size=7
hd_style=BOLD
hd_color=7dedf7
hd_alignment=RIGHT

cfcontent type=application/pdf file=c:\inetpub\wwwroot\#filename#
deletefile=Yes
/BODY/HTML
*



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

Hit Count

[Trace]

Hi Guys,

How can I get and display hits per day as well as total hits? Not only the
page hits, but every image that the viewer has downloaded from the server. I
am inserting into the database the hits per page (code below) but I want the
complete hits.

cfquery name="qryHitCount"
 datasource="#DS#"
 username="#application.EC_SQL_UN#"
 password="#application.EC_SQL_PW#"
  INSERT INTO tblHitLog (HitDT, HitIP)
  VALUES (#NOW()#, '#cgi.remote_addr#')
/cfquery

 I am sure there must be better way than to loop through that query the
amount of times that there are images on that page. It does not need to go
to a database. I have looked at a couple of custom tags  but can't seem to
find one that would address this. I hope this is clear.

Thanks,

Trace








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

'mailto' content

[Trace Faber]

Hi Guys,

I'm trying to include body text in a a href="mailto:." tag. Now I get
the body text in there but I am having trouble formatting it. For example
line breaks. I am probably going about this completely wrong, but below is
my code.


cfset emailContent = "This is a test."chr(13)chr(10)"I like testing
things."chr(13)chr(10)chr(13)chr(10)"This is the beginning of a
paragraph."

cfset emailContent = URLEncodedFormat(emailContent)

cfoutput
a href="mailto:blah.cfm?subject=Testbody=#emailContent#"Test/a
/cfoutput


Any tips would be greatly appreciated.

Trace


~~
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: OT: JS Question

[Trace Faber]

Hi Dave,

This has worked for me...

script language="Javascript"
   !--
  function cursorForm() {
window.document.formName.fieldName.focus()
return true;
  }
--
/script

body onLoad="cursorForm()"
/body

- Original Message -
From: David Hannum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 15, 2001 8:13 AM
Subject: OT: JS Question


 Hello,

 Is there a way to force the focus to a form field (text field) onLoad?

 Thanks,
 Dave




~~
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: Web Based SQL Manager

[Trace Faber]

You bet


 - Original Message -
 From: "Clint Tredway" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, January 12, 2001 9:26 AM
 Subject: Web Based SQL Manager


  Would any of you be interested in a web based SQL Server7 Manager(its
 free)?
 
 

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