Re: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-28 Thread CF-Talk

Courtney, I don't want to do a search.
I want to do a sort.
The sort in a numeric way over a varchar field is possible with this Tag.

But I will try what you supposed on taking QueryAddColumn()
Thanks.
Uwe
- Original Message -
From: "Courtney Payne" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Freitag, 27. Oktober 2000 14:14
Subject: RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)


Well, you can't do a numeric search on non-numeric values.

Umm... I think I'd add a field/column to my result set -- using the
QueryAddColumn() -- and, for each row, set this new field to the
'housenumber' field's *numeric* equivalent -- using the QuerySetCell() and
Val() functions.  Then sort on this, now numeric, field in my cf_querysort.

Courtney E. Payne, Developer
Fig Leaf Software
"We've got you covered"
[EMAIL PROTECTED]
www.figleaf.com


-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 5:21 PM
To: CF-Talk
Subject: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)


o.k.
I had a sorting problem yesterday but with the help of the Custom Tag
CF_QuerySort
I am able to sort a varchar-column in a numeric way. (This morning I thought
at least !)
Although right now it doesn't seem to work anymore, since in my housenumber
field there
are most likely values like 93-94 and 101B and so on. I don't know why
exactly but he (CF) is telling me
nonstop when I order via the housenumber-field in a numeric manner the
following:
---
Error Diagnostic Information
In function ArraySort the array element at position 4 is not a numeric value
The error occurred while evaluating the expression:
 Temp = ArraySort(MyArray, Attributes.SortType, Attributes.SortOrder)
The error occurred while processing an element with a general identifier of
(CFSET), occupying document position (39:1) to (39:76).
---
Ideas why ?

Uwe

SD Solutions
Lange Zeile 27
85435 Erding
Fon: 08122/903791
Fax: 08122/903792
Mail: [EMAIL PROTECTED]
Web: www.sdsolutions.de




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


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




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



Re: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)

2000-10-28 Thread CF-Talk

Peter, thank you.
This is probably it. I was thinking this is the reason for the error as
well.
I probably have to add another column additionally to the housenumber field
which is
taking the additions like "A" or "B" or "-" so that the values in the field
itself stay as numeric/text values.
Uwe
- Original Message -
From: "Peter J. MacDonald" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Freitag, 27. Oktober 2000 23:37
Subject: RE: CF_QuerySort-problem (Was: SQL-SORT-Problem in a query !)


The reason is that 93-94 and 101B can not be turned into numbers.  The tag
is probably suppose to take VARCHAR columns and make them into numeric
columns only if the value of the column is a number(i.e. no A-Z or special
characters.

Pete

-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 17:21
To: CF-Talk
Subject: CF_QuerySort-problem (Was: SQL-SORT-Problem
in a query !)

o.k.
I had a sorting problem yesterday but with the help of the
Custom Tag
CF_QuerySort
I am able to sort a varchar-column in a numeric way. (This
morning I thought
at least !)
Although right now it doesn't seem to work anymore, since in
my housenumber
field there
are most likely values like 93-94 and 101B and so on. I
don't know why
exactly but he (CF) is telling me
nonstop when I order via the housenumber-field in a numeric
manner the
following:

---
Error Diagnostic Information
In function ArraySort the array element at position 4 is not
a numeric value
The error occurred while evaluating the expression:
Temp = ArraySort(MyArray, Attributes.SortType,
Attributes.SortOrder)
The error occurred while processing an element with a
general identifier of
(CFSET), occupying document position (39:1) to (39:76).

---
Ideas why ?

Uwe

SD Solutions
Lange Zeile 27
85435 Erding
Fon: 08122/903791
Fax: 08122/903792
Mail: [EMAIL PROTECTED]
Web: www.sdsolutions.de





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


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



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



Re: CF-Talk V1 #86

2000-10-28 Thread Randy Zeitman

Kwang, Thank you for the quick reply!

I would like to follow your advice but I don't know howI had the 
same error without the CreateODBCDate conversion tag and can find no 
docs on OLE date formats. Should I not be using CreateDate?
..

You are using ODBC date formats for OLE DB, which does not support ODBC date
formats.

You must use the native DB syntax for dates...
-- 

Signature..
"In the best relationships sex is the booby prize."

"I'm gotten so out of shape sittin' at the computer all day that I 
get out of breath when I have to reach for the percent key!"

- Zeitman

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



Re: OLEDB CreateDate Problem - got it...

2000-10-28 Thread Randy Zeitman

Apologies to Mr. Suh who did indeed answer the question by stating 
'You must use the native DB syntax for dates...' So I am using Excel 
which I think is using the Jet driver and looked at my MySql book and 
simply wrote the date as the Date data type specified and ignored the 
CF tag. ( -MM-DD) The code below works. (I am noting it here for 
other novices like myself.) I believe I set the formatting of the 
excel date to General Date though I've not tried to see if it makes a 
difference.

CFSET ye = 2000
CFSET mo = 06
CFSET da = 01

CFQUERY datasource="test1" NAME="datething"
UPDATE testdate
set  aucdate = '#ye#-#mo#-#da#'
where dID   = 2
/CFQUERY

Thanks, Randy
-- 

Signature..
"In the best relationships sex is the booby prize."

"I'm gotten so out of shape sittin' at the computer all day that I 
get out of breath when I have to reach for the percent key!"

- Zeitman

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



HTML problem still here...

2000-10-28 Thread ibtoad

Ok, I created this little form page that helps people generate a
professional ebay auction page. As you can see the only way they can get the
html code right now is to use the internet explorer source button.  I have
asked this same question a couple of day ago and still haven't figured it
out.  Is there a way I can get the html code that is generated to display in
the browser instead of using the source button?  Here is the link:
http://www.cfm-resources.com/h/happytoad/

Some people have suggested the htmleditformat fuction, but I don't
understand how that works.

P.S. you don't have to fill in any info to test it just click the submit
button.


Thanks,
Rich

Thanks,
Rich


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



RE: HTML problem still here...

2000-10-28 Thread Eron Cohen

Hi Rich,

Why not have a textarea that has the HTML code in it
display on the result page.  Then people can just copy
and paste it right out of the textarea.

I am not sure how you're backend code is working right
now, but in order for this to work, you may need to
write the resulting page to a file (or write it into a
variable or something like that) and then read it into
a variable and then put that variable between your
TEXTAREA#THERESULT#/TEXTAREA tags.

Hope this helps.

Eron

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 11:23 AM
To: CF-Talk
Subject: HTML problem still here...


Ok, I created this little form page that helps people
generate a
professional ebay auction page. As you can see the
only way they can get the
html code right now is to use the internet explorer
source button.  I have
asked this same question a couple of day ago and still
haven't figured it
out.  Is there a way I can get the html code that is
generated to display in
the browser instead of using the source button?  Here
is the link:
http://www.cfm-resources.com/h/happytoad/

Some people have suggested the htmleditformat fuction,
but I don't
understand how that works.

P.S. you don't have to fill in any info to test it
just click the submit
button.


Thanks,
Rich

Thanks,
Rich


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


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

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



Re: HTML problem still here...

2000-10-28 Thread Tom Muck

To expand on that, you can also have a "Select All" button next to the text
area that selects the code for the user so that all they have to do is copy
it.  Something like:

function selectAll(){
document.forms[0].ebaybidarea.focus();
document.forms[0].ebaybidarea.select();
}

then in the button :

INPUT name=Button1 onclick=selectAll() type=button value="Select all"

Hope this helps.

tom

- Original Message -
From: "Eron Cohen" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 11:38 AM
Subject: RE: HTML problem still here...


 Hi Rich,

 Why not have a textarea that has the HTML code in it
 display on the result page.  Then people can just copy
 and paste it right out of the textarea.

 I am not sure how you're backend code is working right
 now, but in order for this to work, you may need to
 write the resulting page to a file (or write it into a
 variable or something like that) and then read it into
 a variable and then put that variable between your
 TEXTAREA#THERESULT#/TEXTAREA tags.

 Hope this helps.

 Eron

 -Original Message-
 From: ibtoad [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 11:23 AM
 To: CF-Talk
 Subject: HTML problem still here...


 Ok, I created this little form page that helps people
 generate a
 professional ebay auction page. As you can see the
 only way they can get the
 html code right now is to use the internet explorer
 source button.  I have
 asked this same question a couple of day ago and still
 haven't figured it
 out.  Is there a way I can get the html code that is
 generated to display in
 the browser instead of using the source button?  Here
 is the link:
 http://www.cfm-resources.com/h/happytoad/

 Some people have suggested the htmleditformat fuction,
 but I don't
 understand how that works.

 P.S. you don't have to fill in any info to test it
 just click the submit
 button.


 Thanks,
 Rich

 Thanks,
 Rich

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


 __
 Do You Yahoo!?
 Yahoo! Messenger - Talk while you surf!  It's FREE.
 http://im.yahoo.com/
 --
--
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


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



RE: HTML problem still here...

2000-10-28 Thread ibtoad

This is exactly what i would like to do but I don't know how.  Since the
results page is created by cold fusion, I don't have a hard copy of the html
until it is generated.  So, I don't know how I can take the entire html code
that is generated and change it into the text area box that you suggested.
Please elaborate if possible on how I can handle this.

Thanks again,
Rich

-Original Message-
From: Eron Cohen [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 11:38 AM
To: CF-Talk
Subject: RE: HTML problem still here...


Hi Rich,

Why not have a textarea that has the HTML code in it
display on the result page.  Then people can just copy
and paste it right out of the textarea.

I am not sure how you're backend code is working right
now, but in order for this to work, you may need to
write the resulting page to a file (or write it into a
variable or something like that) and then read it into
a variable and then put that variable between your
TEXTAREA#THERESULT#/TEXTAREA tags.

Hope this helps.

Eron

-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 11:23 AM
To: CF-Talk
Subject: HTML problem still here...


Ok, I created this little form page that helps people
generate a
professional ebay auction page. As you can see the
only way they can get the
html code right now is to use the internet explorer
source button.  I have
asked this same question a couple of day ago and still
haven't figured it
out.  Is there a way I can get the html code that is
generated to display in
the browser instead of using the source button?  Here
is the link:
http://www.cfm-resources.com/h/happytoad/

Some people have suggested the htmleditformat fuction,
but I don't
understand how that works.

P.S. you don't have to fill in any info to test it
just click the submit
button.


Thanks,
Rich

Thanks,
Rich



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


__
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/


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


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



Re: HTML problem still here...

2000-10-28 Thread Tom Muck

Sorry. . .do it something like this:

CFHEADER NAME="Content-Disposition" VALUE="inline"
CFCONTENT TYPE="text/html"
textarea cols="60" rows="5" name="ebaybidarea"
  -- put your CFM page code right here ---
/textarea

tom

- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 12:16 PM
Subject: RE: HTML problem still here...


 This is exactly what i would like to do but I don't know how.  Since the
 results page is created by cold fusion, I don't have a hard copy of the
html
 until it is generated.  So, I don't know how I can take the entire html
code
 that is generated and change it into the text area box that you suggested.
 Please elaborate if possible on how I can handle this.

 Thanks again,
 Rich

 -Original Message-
 From: Eron Cohen [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 11:38 AM
 To: CF-Talk
 Subject: RE: HTML problem still here...


 Hi Rich,

 Why not have a textarea that has the HTML code in it
 display on the result page.  Then people can just copy
 and paste it right out of the textarea.

 I am not sure how you're backend code is working right
 now, but in order for this to work, you may need to
 write the resulting page to a file (or write it into a
 variable or something like that) and then read it into
 a variable and then put that variable between your
 TEXTAREA#THERESULT#/TEXTAREA tags.

 Hope this helps.

 Eron

 -Original Message-
 From: ibtoad [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 11:23 AM
 To: CF-Talk
 Subject: HTML problem still here...


 Ok, I created this little form page that helps people
 generate a
 professional ebay auction page. As you can see the
 only way they can get the
 html code right now is to use the internet explorer
 source button.  I have
 asked this same question a couple of day ago and still
 haven't figured it
 out.  Is there a way I can get the html code that is
 generated to display in
 the browser instead of using the source button?  Here
 is the link:
 http://www.cfm-resources.com/h/happytoad/

 Some people have suggested the htmleditformat fuction,
 but I don't
 understand how that works.

 P.S. you don't have to fill in any info to test it
 just click the submit
 button.


 Thanks,
 Rich

 Thanks,
 Rich

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


 __
 Do You Yahoo!?
 Yahoo! Messenger - Talk while you surf!  It's FREE.
 http://im.yahoo.com/
 --
--
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
 message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

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


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



RE: HTML problem still here...

2000-10-28 Thread ibtoad

OK that works great. I just had to double output the entire page so the 1st
output would show up as the actual page and the second will show up in the
text box.  Now how do i add the select all button?

thanks for the help,
Rich

-Original Message-
From: Tom Muck [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 12:32 PM
To: CF-Talk
Subject: Re: HTML problem still here...


Sorry. . .do it something like this:

CFHEADER NAME="Content-Disposition" VALUE="inline"
CFCONTENT TYPE="text/html"
textarea cols="60" rows="5" name="ebaybidarea"
  -- put your CFM page code right here ---
/textarea

tom

- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 12:16 PM
Subject: RE: HTML problem still here...


 This is exactly what i would like to do but I don't know how.  Since the
 results page is created by cold fusion, I don't have a hard copy of the
html
 until it is generated.  So, I don't know how I can take the entire html
code
 that is generated and change it into the text area box that you suggested.
 Please elaborate if possible on how I can handle this.

 Thanks again,
 Rich

 -Original Message-
 From: Eron Cohen [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 11:38 AM
 To: CF-Talk
 Subject: RE: HTML problem still here...


 Hi Rich,

 Why not have a textarea that has the HTML code in it
 display on the result page.  Then people can just copy
 and paste it right out of the textarea.

 I am not sure how you're backend code is working right
 now, but in order for this to work, you may need to
 write the resulting page to a file (or write it into a
 variable or something like that) and then read it into
 a variable and then put that variable between your
 TEXTAREA#THERESULT#/TEXTAREA tags.

 Hope this helps.

 Eron

 -Original Message-
 From: ibtoad [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 11:23 AM
 To: CF-Talk
 Subject: HTML problem still here...


 Ok, I created this little form page that helps people
 generate a
 professional ebay auction page. As you can see the
 only way they can get the
 html code right now is to use the internet explorer
 source button.  I have
 asked this same question a couple of day ago and still
 haven't figured it
 out.  Is there a way I can get the html code that is
 generated to display in
 the browser instead of using the source button?  Here
 is the link:
 http://www.cfm-resources.com/h/happytoad/

 Some people have suggested the htmleditformat fuction,
 but I don't
 understand how that works.

 P.S. you don't have to fill in any info to test it
 just click the submit
 button.


 Thanks,
 Rich

 Thanks,
 Rich

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


 __
 Do You Yahoo!?
 Yahoo! Messenger - Talk while you surf!  It's FREE.
 http://im.yahoo.com/
 --
--
 
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
 message with 'unsubscribe' in the body to
[EMAIL PROTECTED]

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



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


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



Re: HTML problem still here...

2000-10-28 Thread Tom Muck

script language="JavaScript"
!--
function selectAll(){
document.forms[0].ebaybidarea.focus();
document.forms[0].ebaybidarea.select();
}
//--
/script


then in the button :

INPUT name=Button1 onclick=selectAll() type=button value="Select all"

tom

- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 12:39 PM
Subject: RE: HTML problem still here...


 OK that works great. I just had to double output the entire page so the
1st
 output would show up as the actual page and the second will show up in the
 text box.  Now how do i add the select all button?

 thanks for the help,
 Rich

 -Original Message-
 From: Tom Muck [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 12:32 PM
 To: CF-Talk
 Subject: Re: HTML problem still here...


 Sorry. . .do it something like this:

 CFHEADER NAME="Content-Disposition" VALUE="inline"
 CFCONTENT TYPE="text/html"
 textarea cols="60" rows="5" name="ebaybidarea"
   -- put your CFM page code right here ---
 /textarea

 tom

 - Original Message -
 From: "ibtoad" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Saturday, October 28, 2000 12:16 PM
 Subject: RE: HTML problem still here...


  This is exactly what i would like to do but I don't know how.  Since the
  results page is created by cold fusion, I don't have a hard copy of the
 html
  until it is generated.  So, I don't know how I can take the entire html
 code
  that is generated and change it into the text area box that you
suggested.
  Please elaborate if possible on how I can handle this.
 
  Thanks again,
  Rich
 
  -Original Message-
  From: Eron Cohen [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, October 28, 2000 11:38 AM
  To: CF-Talk
  Subject: RE: HTML problem still here...
 
 
  Hi Rich,
 
  Why not have a textarea that has the HTML code in it
  display on the result page.  Then people can just copy
  and paste it right out of the textarea.
 
  I am not sure how you're backend code is working right
  now, but in order for this to work, you may need to
  write the resulting page to a file (or write it into a
  variable or something like that) and then read it into
  a variable and then put that variable between your
  TEXTAREA#THERESULT#/TEXTAREA tags.
 
  Hope this helps.
 
  Eron
 
  -Original Message-
  From: ibtoad [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, October 28, 2000 11:23 AM
  To: CF-Talk
  Subject: HTML problem still here...
 
 
  Ok, I created this little form page that helps people
  generate a
  professional ebay auction page. As you can see the
  only way they can get the
  html code right now is to use the internet explorer
  source button.  I have
  asked this same question a couple of day ago and still
  haven't figured it
  out.  Is there a way I can get the html code that is
  generated to display in
  the browser instead of using the source button?  Here
  is the link:
  http://www.cfm-resources.com/h/happytoad/
 
  Some people have suggested the htmleditformat fuction,
  but I don't
  understand how that works.
 
  P.S. you don't have to fill in any info to test it
  just click the submit
  button.
 
 
  Thanks,
  Rich
 
  Thanks,
  Rich
 

 --
 --
  
  Archives:
  http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe:
  http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]
 
 
  __
  Do You Yahoo!?
  Yahoo! Messenger - Talk while you surf!  It's FREE.
  http://im.yahoo.com/

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

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

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

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


Re: HTML problem still here...

2000-10-28 Thread Tom Muck

by the way, if you have Outlook express, those slashes always come thru with
a "file:" in front, but that shouldn't be there.

tom

- Original Message -
From: "Tom Muck" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 12:58 PM
Subject: Re: HTML problem still here...


 script language="JavaScript"
 !--
 function selectAll(){
 document.forms[0].ebaybidarea.focus();
 document.forms[0].ebaybidarea.select();
 }
 file://--
 /script

 then in the button :

 INPUT name=Button1 onclick=selectAll() type=button value="Select all"

 tom




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



Upsizing to SQL Server from Access

2000-10-28 Thread John Fix 3rd

I'm in the process of moving my databases from Access 2000 to SQL Server 7.
I've got SQL running on a different machine than my web/CF server, and I
upsized my Access databases to SQL successfully.  I also added a System DSN
via the ODBC control panel and connected successfully to the datasource.
However, the Cold Fusion admin ODBC tab cannot verify the datasource.  Any
idea why?

Thanks!

John
www.cornells.com


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



RE: HTML problem still here...

2000-10-28 Thread ibtoad

Perfect!!  Check it out:
http://www.cfm-resources.com/h/happytoad/

Thank you so much for the help. It's greatly appreciated.

Rich

-Original Message-
From: Tom Muck [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 1:15 PM
To: CF-Talk
Subject: Re: HTML problem still here...


by the way, if you have Outlook express, those slashes always come thru with
a "file:" in front, but that shouldn't be there.

tom

- Original Message -
From: "Tom Muck" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 12:58 PM
Subject: Re: HTML problem still here...


 script language="JavaScript"
 !--
 function selectAll(){
 document.forms[0].ebaybidarea.focus();
 document.forms[0].ebaybidarea.select();
 }
 file://--
 /script

 then in the button :

 INPUT name=Button1 onclick=selectAll() type=button value="Select all"

 tom





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


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



Re: HTML problem still here...

2000-10-28 Thread Tom Muck

Good job.  I like it. . .

tom

- Original Message - 
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 1:42 PM
Subject: RE: HTML problem still here...


 Perfect!!  Check it out:
 http://www.cfm-resources.com/h/happytoad/
 
 Thank you so much for the help. It's greatly appreciated.
 
 Rich
 



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



RE: Upsizing to SQL Server from Access

2000-10-28 Thread Bob Silverberg

Yes, if you specify a valid SQL Server logon and password (i.e., one that is
setup within SQL Server) in the CF Administrator (under the CF Settings 
area), it shouldn't matter which account the CF Server is running under.

Bob

-Original Message-
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 2:35 PM
To: CF-Talk
Subject: RE: Upsizing to SQL Server from Access


After going around in circles a bit, I got it to work by changing the logged
in user for the Cold Fusion server service.  I had it starting under the
system account before, but now it's running under a user name that is valid
for the SQL server.  The datasource verifies, but is this a valid security
setup to use?  Should I be able to get the connection working WITHOUT having
CFServer run under a user account?

Thanks!

John

-Original Message-
From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 2:28 PM
To: CF-Talk
Subject: Re: Upsizing to SQL Server from Access


We went through this once before:
Questions:
Have you changed and usernames or passwords?
Are you Connecting through TCPip?


- Original Message -
From: John Fix 3rd [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 11:22 AM
Subject: Upsizing to SQL Server from Access


 I'm in the process of moving my databases from Access 2000 to SQL
 Server
7.
 I've got SQL running on a different machine than my web/CF server, and
 I upsized my Access databases to SQL successfully.  I also added a
 System
DSN
 via the ODBC control panel and connected successfully to the
 datasource. However, the Cold Fusion admin ODBC tab cannot verify the
 datasource.  Any idea why?

 Thanks!

 John
 www.cornells.com

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




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



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


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



RE: multiple similar sites on one server

2000-10-28 Thread Brad Roberts

Just to add, I've thought about using the app as a custom tag.  What are
some thoughts building on doing that?  Directory structure?  What files are
used in the custom tag and which aren't?

Brad

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 3:05 PM
To: Fusebox
Cc: CF Talk
Subject: multiple similar sites on one server


Check out this scenario:

What if you wanted to host ecommerce sites for just vitamin stores?  You
created an awesome app (in fusebox of course) catered to the vitamin store
business.  Your database is set up to handle multiple stores.  You don't
want to just copy your app for every store you set up, because this wouldn't
be feasible for later changes to your app.  When you got a new client, the
idea would be to create only the files and variables unique to that site:

Variables:
  Unique ID of the store
  Any style attributes

Files:
  Header and footer files for design.

So how could you reuse the entire functionality of the site and only change
the design (headers/footers) and style (colors, fonts, etc.)?  I've thought
about this a lot, but I keep running into roadblocks.

Any help is appreciated,

Brad

BTW, The new Fusebox Book is great!  It's an easy read, even on my monitor
:)


--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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



cfcontent

2000-10-28 Thread Duane Boudreau

I'm using cfcontent to trigger the upload of a file. Does anyone remember
the trick to faking cfcontent into using a file name other the name of the
template it is located in?

TIA,
Duane


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



RE: cfcontent

2000-10-28 Thread David Gassner

It's:

CFHEADER NAME="Content-Disposition" VALUE="inline; Filename=#myfilename#"

 -Original Message-
 From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 12:29 PM
 To: CF-Talk
 Subject: cfcontent


 I'm using cfcontent to trigger the upload of a file. Does anyone remember
 the trick to faking cfcontent into using a file name other the name of the
 template it is located in?

 TIA,
 Duane

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



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



RE: Upsizing to SQL Server from Access

2000-10-28 Thread John Fix 3rd

OK, got it.  I added a specific web server account to SQL Server config and
then entered that info into the CF Admin page and it verifies properly.

Thanks!

John

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 3:02 PM
To: CF-Talk
Subject: RE: Upsizing to SQL Server from Access


Yes, if you specify a valid SQL Server logon and password (i.e., one that is
setup within SQL Server) in the CF Administrator (under the CF Settings 
area), it shouldn't matter which account the CF Server is running under.

Bob

-Original Message-
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 2:35 PM
To: CF-Talk
Subject: RE: Upsizing to SQL Server from Access


After going around in circles a bit, I got it to work by changing the logged
in user for the Cold Fusion server service.  I had it starting under the
system account before, but now it's running under a user name that is valid
for the SQL server.  The datasource verifies, but is this a valid security
setup to use?  Should I be able to get the connection working WITHOUT having
CFServer run under a user account?

Thanks!

John

-Original Message-
From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 2:28 PM
To: CF-Talk
Subject: Re: Upsizing to SQL Server from Access


We went through this once before:
Questions:
Have you changed and usernames or passwords?
Are you Connecting through TCPip?


- Original Message -
From: John Fix 3rd [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 11:22 AM
Subject: Upsizing to SQL Server from Access


 I'm in the process of moving my databases from Access 2000 to SQL
 Server
7.
 I've got SQL running on a different machine than my web/CF server, and
 I upsized my Access databases to SQL successfully.  I also added a
 System
DSN
 via the ODBC control panel and connected successfully to the
 datasource. However, the Cold Fusion admin ODBC tab cannot verify the
 datasource.  Any idea why?

 Thanks!

 John
 www.cornells.com

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




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



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



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


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



CF-Talk enhancement (possibly)

2000-10-28 Thread Philip Arnold - ASP

This is mainly to Michael D, but I thought some other feedback from others
might help with the issue...

I don't know about the rest of you, but I get (slighly) annoyed with the
messages with no subject - especially when there are several in a day, and
the replies are all "Re:" in the subject

So, what I am suggesting (if it's possible Michael...) is that if a
non-subject message comes in, it's automatically given a subject, similar to
those "CF-Talk V1 #n" messages... if Michael is feeling particularly nasty,
then something like "Lazy person who couldn't be bothered typing a Subject
#43" (heh, only kidding)

At least that way, we can find the replies easier than hunting through 20
messages with no title and the 60-70 replies which don't follow - especially
when you put your CF-Talk folder into Subject Order

Comments?

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

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



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



RE: CF-Talk enhancement (possibly)

2000-10-28 Thread Chad Elley

I think it would be a good addition to the list.

I also like the feature of putting the name of the user group in the subject
line.  Another group I belong to does this.  For example, put [CF-Talk] at
the beginning of the subject of all messages.  This helps sorting CF e-mails
from others.



-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 5:16 PM
To: CF-Talk
Subject: CF-Talk enhancement (possibly)


This is mainly to Michael D, but I thought some other feedback from others
might help with the issue...

I don't know about the rest of you, but I get (slighly) annoyed with the
messages with no subject - especially when there are several in a day, and
the replies are all "Re:" in the subject

So, what I am suggesting (if it's possible Michael...) is that if a
non-subject message comes in, it's automatically given a subject, similar to
those "CF-Talk V1 #n" messages... if Michael is feeling particularly nasty,
then something like "Lazy person who couldn't be bothered typing a Subject
#43" (heh, only kidding)

At least that way, we can find the replies easier than hunting through 20
messages with no title and the 60-70 replies which don't follow - especially
when you put your CF-Talk folder into Subject Order

Comments?

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

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




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


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



RE: cfcontent

2000-10-28 Thread Duane Boudreau

I tried that but it didn't work. I thought there was/is something that can
be done to the url to fix this.

In file one I have

a href="getfile.cfm?filename=something.ext"GetFile/a

in getfile.cfm:

cfcontent type=""
file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
deletefile="No"

Duane


 -Original Message-
 From: David Gassner [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 3:44 PM
 To: CF-Talk
 Subject: RE: cfcontent


 It's:

 CFHEADER NAME="Content-Disposition" VALUE="inline;
 Filename=#myfilename#"

  -Original Message-
  From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, October 28, 2000 12:29 PM
  To: CF-Talk
  Subject: cfcontent
 
 
  I'm using cfcontent to trigger the upload of a file. Does
 anyone remember
  the trick to faking cfcontent into using a file name other the
 name of the
  template it is located in?
 
  TIA,
  Duane
 
  --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]
 

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


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



RE: CF-Talk enhancement (possibly)

2000-10-28 Thread Peter Theobald

"Use filters Luke..."

At 05:33 PM 10/28/00 -0400, Chad Elley wrote:
I think it would be a good addition to the list.

I also like the feature of putting the name of the user group in the subject
line.  Another group I belong to does this.  For example, put [CF-Talk] at
the beginning of the subject of all messages.  This helps sorting CF e-mails
from others.



-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 5:16 PM
To: CF-Talk
Subject: CF-Talk enhancement (possibly)


This is mainly to Michael D, but I thought some other feedback from others
might help with the issue...

I don't know about the rest of you, but I get (slighly) annoyed with the
messages with no subject - especially when there are several in a day, and
the replies are all "Re:" in the subject

So, what I am suggesting (if it's possible Michael...) is that if a
non-subject message comes in, it's automatically given a subject, similar to
those "CF-Talk V1 #n" messages... if Michael is feeling particularly nasty,
then something like "Lazy person who couldn't be bothered typing a Subject
#43" (heh, only kidding)

At least that way, we can find the replies easier than hunting through 20
messages with no title and the 60-70 replies which don't follow - especially
when you put your CF-Talk folder into Subject Order

Comments?

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

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




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


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


---
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938


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



RE: CF-Talk enhancement (possibly)

2000-10-28 Thread Cameron Childress

 I also like the feature of putting the name of the user group in 
--snip--
 This is mainly to Michael D, but I thought some other feedback 
--snip--
 "Use filters Luke..."

No, use CF-Community.  

Please.

-Cameron


Cameron Childress
ElliptIQ Inc.
p. 770.460.7277.232
f. 770.460.0963

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



RE: cfcontent

2000-10-28 Thread David Gassner

Duane, the complete code in getfile.cfm should be:

cfheader name="Content-Disposition"
  value="inline; Filename=#url.filename#"
cfcontent type=""
  file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
  deletefile="No"

This trick only works in the browser when trying to save the file to disk.
If the user opens the file directly in a host application (say, for a Word
document), the new file name won't be respected within Word when called from
within Internet Explorer.  I've also experimented with dropping out the
"inline;" part of the Value attribute and seen no change in behavior.

David

 -Original Message-
 From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 2:51 PM
 To: CF-Talk
 Subject: RE: cfcontent


 I tried that but it didn't work. I thought there was/is something that can
 be done to the url to fix this.

 In file one I have

 a href="getfile.cfm?filename=something.ext"GetFile/a

 in getfile.cfm:

 cfcontent type=""
 file="#GetDirectoryFromPath(GetCurrentTemplatePath())##url.filename#"
 deletefile="No"

 Duane


  -Original Message-
  From: David Gassner [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, October 28, 2000 3:44 PM
  To: CF-Talk
  Subject: RE: cfcontent
 
 
  It's:
 
  CFHEADER NAME="Content-Disposition" VALUE="inline;
  Filename=#myfilename#"
 
   -Original Message-
   From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
   Sent: Saturday, October 28, 2000 12:29 PM
   To: CF-Talk
   Subject: cfcontent
  
  
   I'm using cfcontent to trigger the upload of a file. Does
  anyone remember
   the trick to faking cfcontent into using a file name other the
  name of the
   template it is located in?
  
   TIA,
   Duane
  
   --
   --
   Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
   Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
   or send a message with 'unsubscribe' in the body to
   [EMAIL PROTECTED]
  
 
  --
  --
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
  or send a message with 'unsubscribe' in the body to
  [EMAIL PROTECTED]

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



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



Session variables

2000-10-28 Thread Brian Ivey

Dear List,

I have been working on a project on my home computer. I uploaded it to the
web today and am now experiencing strange behavior. Session variables that
are working fine at home just do not work on the web. I imagine it is a CF
Server setting, but could not get in touch with the hosting service to
verify.

I am not sure it is the best way to do this, but I have all the session
variables for this project stored in one template. Only these variables are
in this template and they are initialized with a CFParam statement. This
template is pulled in with a CFInclude statement. The line following checks
to see if the variable session.valid has been set. If not, the client is
redirected to a login template. The login bombs at the first reference to a
session variable.

I have uploaded the application.cfm file turning session management on.

I can post the code if anyone would care to have a look.

Thanks,
Brian Ivey


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



FormURL2Attributes

2000-10-28 Thread Robert Everland III

How exactly is this tag supposed to work. I am trying to set up a site with
friendly urls but am having problems getting it to work right. I am not
using fusebox but would like an example as to how this works.

Bob Everland


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



RE: FormURL2Attributes

2000-10-28 Thread Brad Roberts

Make sure you've got the latest formurl2attributes tag from fusebox.org
All you have to do use forward slashes in your url's:

index.cfm/action/viewproduct/productid/123

instead of:

index.cfm?action=viewproductproductid=123

You probably will want to use the fusetoken tag also.  That allows you to
append the cfid/cftoken on to your url's in the search engine friendly
format:

index.cfm/action/viewproduct/productid/123/#fusetoken#

which relates to:

index.cfm/action/viewproduct/productid/123/cfid/23/cftoken/549303

HTH,

Brad

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 8:36 PM
To: CF-Talk
Subject: FormURL2Attributes


How exactly is this tag supposed to work. I am trying to set up a site with
friendly urls but am having problems getting it to work right. I am not
using fusebox but would like an example as to how this works.

Bob Everland



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


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



RE: FormURL2Attributes

2000-10-28 Thread Robert Everland III

Why not try something like this instead?
cfid/#session.cfid#/cftoken/#session.cftoken#.htm ?

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 8:55 PM
To: CF-Talk
Subject: RE: FormURL2Attributes


Make sure you've got the latest formurl2attributes tag from fusebox.org
All you have to do use forward slashes in your url's:

index.cfm/action/viewproduct/productid/123

instead of:

index.cfm?action=viewproductproductid=123

You probably will want to use the fusetoken tag also.  That allows you to
append the cfid/cftoken on to your url's in the search engine friendly
format:

index.cfm/action/viewproduct/productid/123/#fusetoken#

which relates to:

index.cfm/action/viewproduct/productid/123/cfid/23/cftoken/549303

HTH,

Brad

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 28, 2000 8:36 PM
To: CF-Talk
Subject: FormURL2Attributes


How exactly is this tag supposed to work. I am trying to set up a site with
friendly urls but am having problems getting it to work right. I am not
using fusebox but would like an example as to how this works.

Bob Everland



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



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


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



Re: CF-Talk enhancement (possibly)

2000-10-28 Thread Michael Dinowitz

This was attempted and shot down really fast. You'll notice that the TO
field for the list is always CF-Talk. That was placed in for filtering
purposes and it really doesn't matter how the post got here, it'll always
show that.


 I think it would be a good addition to the list.

 I also like the feature of putting the name of the user group in the
subject
 line.  Another group I belong to does this.  For example, put [CF-Talk] at
 the beginning of the subject of all messages.  This helps sorting CF
e-mails
 from others.



 -Original Message-
 From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, October 28, 2000 5:16 PM
 To: CF-Talk
 Subject: CF-Talk enhancement (possibly)


 This is mainly to Michael D, but I thought some other feedback from others
 might help with the issue...

 I don't know about the rest of you, but I get (slighly) annoyed with the
 messages with no subject - especially when there are several in a day, and
 the replies are all "Re:" in the subject

 So, what I am suggesting (if it's possible Michael...) is that if a
 non-subject message comes in, it's automatically given a subject, similar
to
 those "CF-Talk V1 #n" messages... if Michael is feeling particularly
nasty,
 then something like "Lazy person who couldn't be bothered typing a Subject
 #43" (heh, only kidding)

 At least that way, we can find the replies easier than hunting through 20
 messages with no title and the 60-70 replies which don't follow -
especially
 when you put your CF-Talk folder into Subject Order

 Comments?

 Philip Arnold
 ASP Multimedia Limited
 T: +44 (0)20 8680 1133

 "Websites for the real world"

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


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

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



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



Re: CF-Talk enhancement (possibly)

2000-10-28 Thread Michael Dinowitz

At the moment it can't be done with the software we're running. On the other
hand, work has already been started on altering the way the list is worked
and that can be added as a feature. Other features include automatic
cleanups of 'extra' post footers. I know its been a slow thing, but there's
been a lot going on from the Fusebox book on to the death of my grandmother.
It'll be done, just a little slow.


 This is mainly to Michael D, but I thought some other feedback from others
 might help with the issue...

 I don't know about the rest of you, but I get (slighly) annoyed with the
 messages with no subject - especially when there are several in a day, and
 the replies are all "Re:" in the subject

 So, what I am suggesting (if it's possible Michael...) is that if a
 non-subject message comes in, it's automatically given a subject, similar
to
 those "CF-Talk V1 #n" messages... if Michael is feeling particularly
nasty,
 then something like "Lazy person who couldn't be bothered typing a Subject
 #43" (heh, only kidding)

 At least that way, we can find the replies easier than hunting through 20
 messages with no title and the 60-70 replies which don't follow -
especially
 when you put your CF-Talk folder into Subject Order

 Comments?



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



Re: automated response

2000-10-28 Thread Michael Dinowitz

Sorry, that was supposed to be to the original poster, not to the list.
As long as it was, I may as well mention that if your going away and have an
automated response running, either turn it off or unsubscribe from the
lists. If not, I'll try and do it for you so that posters do not get the
automated messages. Thanks.


 You have been removed from the CF-Talk list while out of the office. Once
 you return, you can resign up.

 Michael Dinowitz
 Publisher: Fusion Authority weekly news alert
 (www.fusionauthority.com/alert)
 Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
 (www.houseoffusion.com)

 - Original Message -
 From: "peter" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, October 27, 2000 7:32 PM
 Subject: automated response


  I will be out of the office from Monday 10/30/00 to Friday 11/3/00. I
will
 be returning to work on Monday 11/6/00. I will reply to your message at
that
 time.
 
  -Peter Amiri
   Amiri Industries, Inc.

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

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



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



Re: OT Dreamweaver CF Objects

2000-10-28 Thread Jon Hall

If you are a Dreamweaver guy like me, Ultradev is wonderful. It is not any
good for developing templates, but it's great for getting a visual on what
your code looks like, and it wont mangle your code.

jon
- Original Message -
From: "Matt Fuller" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, October 27, 2000 8:18 PM
Subject: OT Dreamweaver CF Objects


 I searched all around www.allaire.com and www.macromedia.com to find CF
 objects for Dreamweaver.  I saw the announcement of these objects on the
 allaire site anyway, this pages just sent me to the macro. site and I
could
 not find them.  Does anyone know where I could find them?  A link would be
 nice if macro. does have them somewhere.

 Thanks,
 Matt

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


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



Re: OT Dreamweaver CF Objects

2000-10-28 Thread Kevin Mansel

For some odd reason when I write this little cfif statement in dreamweaver,
it turns our fine, but if i were to open the file in Ultra Dev, it really
messes it up badtry it

cfif IsDefined('action') AND action IS "sendemail"

Kevin



~~~
Kevin Mansel
Web Developer / Cold Fusion Programming
http://www.kevinmansel.com
[EMAIL PROTECTED]
Phone : 206-286-6310
Cell : 425-346-7221


- Original Message -
From: "Jon Hall" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 8:35 PM
Subject: Re: OT Dreamweaver CF Objects


 If you are a Dreamweaver guy like me, Ultradev is wonderful. It is not any
 good for developing templates, but it's great for getting a visual on what
 your code looks like, and it wont mangle your code.

 jon
 - Original Message -
 From: "Matt Fuller" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, October 27, 2000 8:18 PM
 Subject: OT Dreamweaver CF Objects


  I searched all around www.allaire.com and www.macromedia.com to find CF
  objects for Dreamweaver.  I saw the announcement of these objects on the
  allaire site anyway, this pages just sent me to the macro. site and I
 could
  not find them.  Does anyone know where I could find them?  A link would
be
  nice if macro. does have them somewhere.
 
  Thanks,
  Matt
 

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

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




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



Re: New To Sql From Access

2000-10-28 Thread Kevin Mansel

I think it is :

CREATE TABLE yourtable
(
TableID INTEGER NOT NULL PRIMARY KEY
)

-Kev



~~~
Kevin Mansel
Web Developer / Cold Fusion Programming
http://www.kevinmansel.com
[EMAIL PROTECTED]
Phone : 206-286-6310
Cell : 425-346-7221


- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
[EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 8:50 PM
Subject: New To Sql From Access


 How do I set up sql field names to be equivalent to autonumber field names
 in access


 Kind Regards

 Claude Raiola (Director)
 AustralianAccommodation.com Pty. Ltd.
 Website: www.AustralianAccommodation.com
 Email: [EMAIL PROTECTED]

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




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



Re: New To Sql From Access

2000-10-28 Thread Jon Hall

just set the field to field type identity

jon
- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
[EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Saturday, October 28, 2000 11:50 PM
Subject: New To Sql From Access


 How do I set up sql field names to be equivalent to autonumber field names
 in access


 Kind Regards

 Claude Raiola (Director)
 AustralianAccommodation.com Pty. Ltd.
 Website: www.AustralianAccommodation.com
 Email: [EMAIL PROTECTED]

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


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