RE: Ever have trouble with Client Variables changing?

2003-11-24 Thread Brrrian
Well, this is my cfapp tag:so using cookies by default I think for URLtoken.

cfapplication name=appName
clientmanagement=Yes
clientstorage=clientregName

and I am checking the values for cfid and cftoken... they are not changing 
as I am clicking... but the darn Client.Variable is however many other 
client.Variables are NOT changing...FYI, the client.Variable that is 
changing on me is being used as a True/False boolean value and a cfparam is 
being used to initialize it to false.

Brian

At 01:33 PM 11/22/03 +1100, you wrote:

Are you passing #URLToken# (or #CFID# #CFToken#) between your pages? (eg
appended to URL links or embedded in your form action attribute) CF might
be getting confused about which client it is dealing with - especially if
you are not using cookies.

Peter Tilbrook
ColdFusion Applications Developer
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group - 
http://www.actcfug.comhttp://www.actcfug.com
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA

Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
E-mail: [EMAIL PROTECTED]

World Wide Web: http:/www.coldgen.com/

-Original Message-
From: Brrrian [mailto:[EMAIL PROTECTED]
Sent: Saturday, 22 November 2003 11:43 AM
To: CF-Talk
Subject: Ever have trouble with Client Variables changing?

I have a Client variable that I set as True of False... it is changing on
me.

For example once a page loads I dump the client variable list and I can
see
that it is set False...I Click on something reloads the page and it has
switched to True.But not Always.is very Odd.The Only place
where cfset Client.VariableNameexists is marked with DeBug code and it
does not appear...

To DeBug this I have written a
cfoutputModule:#Client.VariableName#br/cfoutput
into each module called when the PageClick runs...

It is changed sometimes... but not always...I'm going CRAZY trying to
figure this out.

??Anyone?

thanks,
Brian

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




New Lists and other items

2003-11-24 Thread Michael Dinowitz
The following lists have been added to House of Fusion:
HoF-Features - for discussion about errors and new features with the HoF system
XML - the old WDDX list reborn for focus on XML issues.
RIA - For discussion about Rich Internet Applications, their creation, use, etc.
Flex - For non-NDA conversation about the new application and its language. Once
the product is out of beta, then this will be open to all conversation.
CF-IDE - Discussion about the various IDEs for CF and other languages. Studio,
Homesite, DWMX, Eclipse, etc. are all on topic here
Central - The new Macromedia desktop (and other places) connective environment.
CF-Java - Discussion about the use of CF and Java together. This may be more
specific and involved than general CF/Java talk on CF-Talk

The following lists have been removed:
Flashcom - Visit the more active Flashcomm list at chattyfix.figleaf.com
CF-PDF - Created upon request from others, this list has never gotten any
postings
DWMX - Rolled into CF-IDE

Finally, an RSS feed for all lists exists on the front page of each list in the
control bar. Any discussion about its use, new features or what's wrong with it
can go onto HoF-Features.

If I've missed anything or you have any suggestions, please let me know.
Thank you
--
Michael Dinowitz
Finding technical solutions to the problems you didn't know you had yet

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SQL Help

2003-11-24 Thread Michael Traher
Yes you would have to have an OR for each area code in your list in
addition to the in clause (which is expanded by the DBMS to a list of
OR's anyway which is why it is likely to run slowly).

This will extract the records you need - after that you will have to be
able to parse the memo field to extract the actual telephone numbers
that match your area codes.

In '%,nnn%' the first % recognizes that this value can have any number
of characters before it in the memo field. The ',' (comma) is the marker
which matches to the start of the numbers otherwise we would match where
area codes happen to crop up elsewhere in the numbers, the 'nnn' is the
area code we are trying to match and the last % recognizes that there
can be any number of characters following the area code.

HTH

Michael Traher 

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: 21 November 2003 17:56
To: CF-Talk
Subject: Re: SQL Help

Hi Michael,

Thanks for the response.Please excuse me if this is obvious as I don't
see it.How would I extract on the numbers I need using the below.If
I have 20 area codes would I need to make the first in (then the 20 area
codes) then OR for each areacode ?

Thanks

Mike
- Original Message - 
From: Michael Traher 
To: CF-Talk 
Sent: Friday, November 21, 2003 12:44 PM
Subject: RE: SQL Help

(Left(phone_list,3) in ('212','213')OR phone_list like '%,212%' OR
phone_list like '%,213%')

but I would predict poor performance.

No chance to change the database I guess?

Michael Traher 

-Original Message-
From: Mickael [mailto:[EMAIL PROTECTED] 
Sent: 21 November 2003 17:23
To: CF-Talk
Subject: SQL Help

Hello All,

I have a memo field in SYBASE that contains phone numbers delimited by
a
comma.

I need to qualify telephone numbers that are in a group of area codes,
using SQL only I can't use CF.

The is called phone_list and the values look like this
2125551212,213555-1212,2145551212

How could I in SQL only grab telephone # with area codes that are in
my
list.

I was thinking to do where Left(phone,3) in (212,213) 

But how to a parse through the memo field.

Thanks

Mike

 _


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Mike Townend
6.1 has some components listed in the component manager that can probably
allow you to do this.MX didnt, I havnt tried using them so i dont know how
effective they are.

 
HTH

-Original Message-
From: Seibert Don R [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 03:42
To: CF-Talk
Subject: RE: On the fly DSN creation, why?

Does ColdFusion MX 6.1 give you the ability to create DSNs on the fly?

_

From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 23, 2003 8:27 PM
To: CF-Talk

 Hi, I'm wondering why people like creating DSNs on the fly. 
 What benefit do you think it gives you? 

You don't need access to the CF Administrator in that case.

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

_

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Determing wehre you've loaded from

2003-11-24 Thread Adrian Lynch
Take a look at the available CGI variables.

 
 cfdump var=#CGI# /

 
This might have something of interest to you.

 
Ade

-Original Message-
From: Craig Earls [mailto:[EMAIL PROTECTED]
Sent: 23 November 2003 00:17
To: CF-Talk
Subject: Determing wehre you've loaded from

I am developing an app that includes a Flash Form accessing CFC.I
set the arget for the flash remoting gateway in a FlashVar.This si
good but still not great.I need to remember to change source code
when I move from local testing to putting out to the public server.

I would like to be able to find out what domain the page is being
served from without having to hard code it.Is this possible in CFMX?

So, on my location machine the tag or function would return
localhost and on the public server it would return
www.servername.com

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Samuel R. Neff
You can do dynamic ODBC connections in MX by creating a datasource to an
empty Access database and use that as a proxy, specifying the real
connection string in the FROM clause of your query.

cfquery name=excelData datasource=proxy
SELECT Salesperson, SalesAmount
FROM Excel 8.0; DATABASE=#tempFile#; HDR=YES.[Sales$]
/cfquery

HTH,

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: Dave Carabetta [mailto:[EMAIL PROTECTED] 
 Sent: Sunday, November 23, 2003 11:57 PM
 To: CF-Talk
 Subject: Re: On the fly DSN creation, why?
 
 This is a definite archive search, but I could swear somebody 
 posted a way to do this using MS Access. I have no 
 recollection at all of the details, but an archive search may help.
 
 Officially though, the CF 5 way of creating dsn-less 
 connections was deprecated because (I believe) JDBC does not 
 support them.
 
 Regards,
 Dave.
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: 3 select Calendar pop-up

2003-11-24 Thread Dwayne Cole
Are you talking about interface or the results?
 
If just the results couldn't you just separate them out later (perhaps
using the DatePart() function)?
 
Jim Davis
 
 

I'm talking about the interface.I actually put them back together later.But if you know of a really good js Calandar pop than it may be worth a redesign.



-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 23, 2003 12:51 PM
To: CF-Talk
Subject: 3 select Calendar pop-up
 
My form fields for entering dates have three drop downs, one for months,
on for the day, and one for the year. I'm looking for a calendar pop-up
script that faciliates data entry in my Date fields.I discovered
several but they all return the date to one field. 

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer 
850-591-0212 




_



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: 3 select Calendar pop-up

2003-11-24 Thread Bert Dawson
Have you checked out Matt Kruse's Calendar Popup: http://www.mattkruse.com/_javascript_/calendarpopup/
I think it'll do what you're after - see the example at the bottom of the page.

HTH
Bert

 -Original Message-
 From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
 Sent: 23 November 2003 17:51
 To: CF-Talk
 Subject: 3 select Calendar pop-up
 
 
 My form fields for entering dates have three drop downs, one 
 for months, on for the day, and one for the year. I'm looking 
 for a calendar pop-up script that faciliates data entry in my 
 Date fields.I discovered several but they all return the 
 date to one field. 

		

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: 3 select Calendar pop-up

2003-11-24 Thread Dwayne Cole
Thanks Bert.

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212

 
It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all sound and fury, signifying nothing.The Fifth Discipline - Peter Senge

Have you checked out Matt Kruse's Calendar Popup: http://www.mattkruse.com/_javascript_/calendarpopup/
I think it'll do what you're after - see the example at the bottom of the page.

HTH
Bert


 -Original Message-
 From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
 Sent: 23 November 2003 17:51
 To: CF-Talk
 Subject: 3 select Calendar pop-up
 
 
 My form fields for entering dates have three drop downs, one 
 for months, on for the day, and one for the year. I'm looking 
 for a calendar pop-up script that faciliates data entry in my 
 Date fields.I discovered several but they all return the 
 date to one field. 

		


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Server busy error.

2003-11-24 Thread Ketan Patel
Hi All,
I am facing a strange issue with CF timeout or CF Server. I have a script
which can run anywhere from 2 seconds to 5 minutes. Sometimes I get
following error message.

Error Diagnostic Information
Request canceled or ignored by server Server busy or unable to fulfill
request. The server is unable to fulfill your request due to extremely high
traffic or an unexpected internal error. Please attempt your request again
(if you are repeatedly unsuccessful you should notify the site
administrator). (Location Code: 26)

I am not sure whatsetting can resolve this also I have set the
requesttimeout=600 so I think this should be enough. I am not sure how to
debug or solve this one.

Ketan Patel

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: TDateTime conversion

2003-11-24 Thread Thomas Chiverton
On Tuesday 18 Nov 2003 10:28 am, Shahzad.Butt wrote:
 Has anyone written any UDF or something to convert TDateTime value (in
 Delphi) to normal ODBC date/time format? Even a TSQL command will help
 me as well..

TDateTime's are measured from sometime in 1899 (check the Delphi help), as 
opposed to 1970-odd for most normal languages.

I'd probably start by finding the number of seconds difference betwen the two 
datums (this will be a constant).
Then subtract that from the TDateTime, and you have 
number-of-seconds-since-normal-epoc, which I think CF will handle file (with 
CreateOdbcDateTime, possibably).

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: 3 select Calendar pop-up

2003-11-24 Thread Larry C. Lyons
Dwayne Cole wrote:
 My form fields for entering dates have three drop downs, one for months, 
 on for the day, and one for the year. I'm looking for a calendar pop-up 
 script that faciliates data entry in my Date fields.I discovered 
 several but they all return the date to one field.
 
 Dwayne Cole, MS in MIS, MBA
 Certified Advanced ColdFusion Developer
 850-591-0212

Selene Bainum of Webtricks.com has a very nice popup calendar that you 
can parse the month, day and year very easily. Its at:

http://www.webtricks.com/sourcecode/code.cfm?CodeID=5

regards,

larry

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Auto-Populate a Word Document

2003-11-24 Thread Dwayne Cole
I working on an application that pulls info from a database and popluates a fields of a contract.In the past I would generate an HTML display of the contract in seperate window and from there the users would just print it out.Sometimes, however, condition of the contract may need toslightly modified before printing.

I would like to push the contract to the client browser as MS word.If the user wants to edit, save, or print the contract they can.

What's the best way to I handle this?

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212

 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Auto-Populate a Word Document

2003-11-24 Thread Philip Arnold
have a CFCONTENT change the type to Word (can't remember the setting off
the top of my head)
Put whatever HTML layout you want in there (Word treats HTML as layout
when the Content Type is right)

 
Voila

-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 10:52 AM
To: CF-Talk
Subject: Auto-Populate a Word Document

I working on an application that pulls info from a database and
popluates a fields of a contract.In the past I would generate an HTML
display of the contract in seperate window and from there the users
would just print it out.Sometimes, however, condition of the contract
may need toslightly modified before printing.

I would like to push the contract to the client browser as MS word.If
the user wants to edit, save, or print the contract they can.

What's the best way to I handle this?

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: 3 select Calendar pop-up

2003-11-24 Thread Tangorre, Michael
One of the best, cross browser calendars I have used is this
http://dynarch.com/mishoo/calendar/ http://dynarch.com/mishoo/calendar/ 

 
mike

-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 9:36 AM
To: CF-Talk
Subject: RE: 3 select Calendar pop-up

Thanks Bert.

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212

It can truly be said that nothing happens until there is vision. But it is
equally true that a vision with no underlying sense of purpose, no calling,
is just a good idea - all sound and fury, signifying nothing.The Fifth
Discipline - Peter Senge

Have you checked out Matt Kruse's Calendar Popup:
http://www.mattkruse.com/_javascript_/calendarpopup/
http://www.mattkruse.com/_javascript_/calendarpopup/ 
I think it'll do what you're after - see the example at the bottom of the
page.

HTH
Bert


 -Original Message-
 From: Dwayne Cole [mailto:[EMAIL PROTECTED] 
 Sent: 23 November 2003 17:51
 To: CF-Talk
 Subject: 3 select Calendar pop-up
 
 
 My form fields for entering dates have three drop downs, one 
 for months, on for the day, and one for the year. I'm looking 
 for a calendar pop-up script that faciliates data entry in my 
 Date fields.I discovered several but they all return the 
 date to one field. 

 

 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Testing DSN's before processing queries

2003-11-24 Thread dsmith
Does anyone know a method to test a DSN before running a query?We link to an AS/400 DSN which is occasionally offline for backups, maintenance, etc.I'd like to run a test that if the DSN isn't working will display a Please come back later message.Any suggestions?

Thanks,
Daron Smith
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Testing DSN's before processing queries

2003-11-24 Thread Pascal Peters
Use try catch on a query that you know will work (and is fast) if it is
online. You can even throw an error and use cferror for the display of
the message. Or you can use try catch on the query itself.
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: maandag 24 november 2003 16:12
To: CF-Talk
Subject: Testing DSN's before processing queries

Does anyone know a method to test a DSN before running a query?We link
to an AS/400 DSN which is occasionally offline for backups, maintenance,
etc.I'd like to run a test that if the DSN isn't working will display
a Please come back later message.Any suggestions?

Thanks,
Daron Smith 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Testing DSN's before processing queries

2003-11-24 Thread John Stanley
You could use something like this:

 
cftry
 cfquery name=get_this datasource=arf
select * from sys_note_type
 /cfquery
 cfcatch type=Database
cfif findnocase(Data source arf could not be found.,cfcatch.message)
Please Come back later
/cfif
 /cfcatch
/cftry

-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 10:12 AM
To: CF-Talk
Subject: Testing DSN's before processing queries

Does anyone know a method to test a DSN before running a query?We link to
an AS/400 DSN which is occasionally offline for backups, maintenance, etc.
I'd like to run a test that if the DSN isn't working will display a Please
come back later message.Any suggestions?

Thanks,
Daron Smith 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: HTML CSS only table question.

2003-11-24 Thread Ian Skinner
I have a table laid out something like this simplified example:

table
tr
 tddata/td
 td rowspan=4Data/td
tr
tr
 tddata/td
tr
tr
 td rowspan=2data/td
tr
/table
I am working on the calculation that results in the unnecessary rowspan in
the third row.But I don't think that applies to this issue.

This results in a display such as this:
(I hope this comes through clearly)

|--|--|
| data | data |
|--||
| data ||
|--||
| data ||
|--|--|

Now the problem is that the data in the right column is several lines long,
and is sometimes longer then the data in the rows in the left column.When
this happens, I would like the height of the top two cells to remain
constant, and the bottom cell to expand to match the height of the right
column.I've tried setting the height with both the height parameter in the
td tag and the CSS height property.Neither seemed to have much effect.
The three rows on the left are spacing themselves equally.This needs to
work in our IE5.5+ intranet environment.

Anybody have any suggestions?

Thank You

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Auto-Populate a Word Document

2003-11-24 Thread Samuel R. Neff
cfcontent type=application/msword reset=no

cfheader name=Content-Disposition value=attachment;
filename=Labels01.doc

More info here:

http://www.rewindlife.com/archives/32.cfm

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: Philip Arnold [mailto:[EMAIL PROTECTED] 
 Sent: Monday, November 24, 2003 10:59 AM
 To: CF-Talk
 Subject: RE: Auto-Populate a Word Document
 
 have a CFCONTENT change the type to Word (can't remember the 
 setting off the top of my head) Put whatever HTML layout you 
 want in there (Word treats HTML as layout when the Content 
 Type is right)
 
 
 Voila
 
 -Original Message-
 From: Dwayne Cole [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 24, 2003 10:52 AM
 To: CF-Talk
 Subject: Auto-Populate a Word Document
 
 I working on an application that pulls info from a database 
 and popluates a fields of a contract.In the past I would 
 generate an HTML display of the contract in seperate window 
 and from there the users would just print it out.Sometimes, 
 however, condition of the contract may need toslightly 
 modified before printing.
 
 I would like to push the contract to the client browser as MS 
 word.If the user wants to edit, save, or print the contract 
 they can.
 
 What's the best way to I handle this?
 
 Dwayne Cole, MS in MIS, MBA

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Cfcontent/cfheader

2003-11-24 Thread Tangorre, Michael
I am sending out emails that contain a link to a page that serves up a file
for the user to download via cfheaaer and cfcontent.

cfheader 
	name=Content-Disposition value=attachment;
filename=#selectDoc.documentName# 
cfcontent 
	file=#request.docPath##selectDoc.documentName# 
	type=application/x-unknown /

This works fine, but I need to get around one hurdle. Basically if the user
is not logged in when they click the link in their email, then are prompted
to login. Once their login has been verified, I send them to their
download... And here is where my issue is.

I am using cflogin/cfloginuser to handle security and when I authenticate
the user and cflocate them to the download page which prompts them to
download the file, before the location bar changes the user is presented
with the download prompt and can get the file ok, but once the download
completes the page now shows the login screen and not the page where the
download took place? Does this make sense? I am thinking that it has to do
with the cfheader and cfcontent usage, and I am not sure what to do to be
able to relocate the user after a download or display a link for them to
click etc..

Hope that all made sense.

Mike
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Declared SQL variables in select statement error

2003-11-24 Thread Chris More
Why can I execute this statement fine in MS SQL Analyzer:

DECLARE @q1 varchar(7)
	
SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1

And If I try to do this in CF:

cfquery name=sales datasource=forecasting
DECLARE @q1 varchar(7)
	
SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1
/cfquery

I get this error:

QUERY The QUERY attribute of the tag does not specify the name of an available query

This is a simplified version of my problem, but it seems that CF will execute the query without an error but the returned query structure won't exist at all.

Has anyone else ran into this problem?

Thanks,
Chris
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:SQL Help

2003-11-24 Thread Stan Winchester
I don't know if SYBASE supports UDF like SQL 2000, but take a look at the following: http://www.houseoffusion.com/lists.cfm/link=m:4:23904:120461 

I found the above solution to be very helpful, and hope it can help you!
Good Luck
Stan

Hello All,

I have a memo field in SYBASE that contains phone numbers delimited by 
a comma.

I need to qualify telephone numbers that are in a group of area codes, 
using SQL only I can't use CF.

The is called phone_list and the values look like this 2125551212,
213555-1212,2145551212

How could I in SQL only grab telephone # with area codes that are in 
my list.

I was thinking to do where Left(phone,3) in (212,213) 

But how to a parse through the memo field.

Thanks

Mike



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Declared SQL variables in select statement error

2003-11-24 Thread Hassan Arteaga Rodriguez
Try this...

 
cfquery name=sales datasource=forecasting
SELECT period_name AS 'q1'
FROM adj_periods
WHERE period_id = 1
/cfquery

Regards...

Declare is a keyword for MS SQL notSQL language...i'm ok ?


__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: Chris More [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 09:50 AM
To: CF-Talk
Subject: Declared SQL variables in select statement error

Why can I execute this statement fine in MS SQL Analyzer:

DECLARE @q1 varchar(7)

SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1

And If I try to do this in CF:

cfquery name=sales datasource=forecasting
DECLARE @q1 varchar(7)

SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1
/cfquery

I get this error:

QUERY The QUERY attribute of the tag does not specify the name of an
available query

This is a simplified version of my problem, but it seems that CF will
execute the query without an error but the returned query structure
won't exist at all.

Has anyone else ran into this problem?

Thanks,
Chris
[EMAIL PROTECTED] 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Bryan F. Hogan
Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 8:34 AM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?

You can do dynamic ODBC connections in MX by creating a datasource to an
empty Access database and use that as a proxy, specifying the real
connection string in the FROM clause of your query.

cfquery name=excelData datasource=proxy
SELECT Salesperson, SalesAmount
FROM Excel 8.0; DATABASE=#tempFile#; HDR=YES.[Sales$] /cfquery

HTH,

Sam


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CF with Bluetooth (RETRACT)

2003-11-24 Thread Thomas Chiverton
On Thursday 13 Nov 2003 20:33 pm, Tony Weeg wrote:
 does bluetooth give any web access in its PAN?
 I guess lets say you had a wireless device with internet access
 and bluetooth on it as well, could a pda within that
 PAN get out to the web to, lets say, get email?

Did just that from my nice new SE P900 over the weekend, accessing my webmail 
via a Bluetooth link'ed mobile phone:
laptop -[BlTo]- P900 -[Mobile Network]- web server

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CF with Bluetooth (RETRACT)

2003-11-24 Thread Thomas Chiverton
 Did just that from my nice new SE P900 over the weekend, accessing my
 webmail via a Bluetooth link'ed mobile phone:
 laptop -[BlTo]- P900 -[Mobile Network]- web server

Of course, then I got silly and just did:
P900 -[Mobile Network]- web server
:-)

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:3 select Calendar pop-up

2003-11-24 Thread Irvin Gomez
Dwayne, let me know if this is close to what you're looking for.

http://www.pixel69.com/calendar.cfm

My form fields for entering dates have three drop downs, one for 
months, on for the day, and one for the year. I'm looking for a 
calendar pop-up script that faciliates data entry in my Date fields.
I discovered several but they all return the date to one field. 

Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer 
850-591-0212 

 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: On the fly DSN creation, why?

2003-11-24 Thread stas
Sure, let's say you want to let a user upload an Access database and import
it an existing data source. I am currently stuck figuring out how to do the
reverse - extract data to a stand alone dynamically generated Access
database.

- Original Message -
From: Bryan F. Hogan
To: CF-Talk
Sent: Monday, November 24, 2003 12:04 PM
Subject: RE: On the fly DSN creation, why?

Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Samuel R. Neff
In the example I posted, it was to work with an uploaded Excel spreadsheet.
In that case, you don't want a real DSN to it but just a dynamic connection.

Besides, someone else asked about the HOW, not just WHY (sorry if I'm
encouraging the repurposement of your thread).

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
 Sent: Monday, November 24, 2003 12:05 PM
 To: CF-Talk
 Subject: RE: On the fly DSN creation, why?
 
 Hi All, you missed what I was trying to do. I know how, but I 
 want to know why. Why do people like create DSNs on the fly?
 
 -Original Message-
 From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 24, 2003 8:34 AM
 To: CF-Talk
 Subject: RE: On the fly DSN creation, why?
 
 You can do dynamic ODBC connections in MX by creating a 
 datasource to an empty Access database and use that as a 
 proxy, specifying the real connection string in the FROM 
 clause of your query.
 
 cfquery name=excelData datasource=proxy
 SELECT Salesperson, SalesAmount
 FROM Excel 8.0; DATABASE=#tempFile#; HDR=YES.[Sales$] /cfquery
 
 HTH,
 
 Sam
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Mike Townend
we wanted to do it so that users were able to upload an excel spreadsheet,
which could then be manipulated by other people over a period of time.At
the time of writing there was no way to do it in MX that appeared to work.
So we have a bank of datasources setup in CF which is then monitored by
other code and matched up with ODBC datasources via CFRegistry

 
Much much easier (and secure) than installing MS Office on the server (which
has the added problem of being really locked down) and trying to use COM

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 17:05
To: CF-Talk
Subject: RE: On the fly DSN creation, why?

Hi All, you missed what I was trying to do. I know how, but I want to
know why. Why do people like create DSNs on the fly?

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 8:34 AM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?

You can do dynamic ODBC connections in MX by creating a datasource to an
empty Access database and use that as a proxy, specifying the real
connection string in the FROM clause of your query.

cfquery name=excelData datasource=proxy
SELECT Salesperson, SalesAmount
FROM Excel 8.0; DATABASE=#tempFile#; HDR=YES.[Sales$] /cfquery

HTH,

Sam

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Bryan F. Hogan
 Besides, someone else asked about the HOW, not just WHY (sorry if I'm
encouraging the repurposement of your thread).

Didn't mean to bother you. I repurposed already. And you answered.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Ordering a QofQ

2003-11-24 Thread Brad Roberts
I'm building a query dynamically, and then trying to sort it on a numeric
column, but it only wants to sort alphabetically.Anyone experience this,
or know what I need to do to sort numerically?

cfquery name=qResults dbtype=query
	select * from qResults order by hasPhoto DESC, price DESC
/cfquery

-Brad


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF and ASP

2003-11-24 Thread Bushy
Can I have some ASP code in my test.cfm file? Its a breadcrumb writting in ASP.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




looking for a good dynamic menu

2003-11-24 Thread walker
Hey all,

I need to find a good dynamic menu - kind of like the one found on 
http://www.jensonusa.com, where the rollover pops down a second list of 
items to choose from.

Does anyone know of one that is cross browser compatible, and works well 
with cold fusion?

Thanks for your help.

-w

_
walker fenton
[EMAIL PROTECTED]
303.722.5473 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CF - post to database question

2003-11-24 Thread Michael Grove
I am looking for a way to post information directly to a database from a csv, excel or text delimited file.

I am looking for one of two options.

Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file automatically and post it in a database.

Option two would be to simply give the user the ability to access a web form and upload the file to the server, which in turn would place the data in a database.

Can someone point me in the right direction?
Thanks
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: looking for a good dynamic menu

2003-11-24 Thread Hassan Arteaga Rodriguez
U should try fireworks MX !!

 
Regards, 

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: walker [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 11:43 AM
To: CF-Talk
Subject: looking for a good dynamic menu

Hey all,

I need to find a good dynamic menu - kind of like the one found on 
http://www.jensonusa.com, where the rollover pops down a second list of 
items to choose from.

Does anyone know of one that is cross browser compatible, and works well

with cold fusion?

Thanks for your help.

-w

_
walker fenton
[EMAIL PROTECTED]
303.722.5473 

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CF - post to database question

2003-11-24 Thread Bryan Stevenson
Both options are possible, although the e-mail option would have more possible points of failure (i.e. mail not deliverednot read properlyforgot the attachement etc.)

The only really tough part here is extracting the data from the file.There are many customs tags to extract data from Excel files, so have a look at the MM Exchange.Grabbing data out of PROPERLY formatted flat file (CSV...tab delimited etc.) is very easy (but if the formatting is off you're up the creek).You simply use CFFILE to read the file in question.That is read into a variable which you then loop through to parse out the records.Remember that the first row is usually the column names...other than that pay specialattention to the row delimiters and the column delimiters (these will allow you to seperate out each record and then each field in that record).On each pass of the loop you insert your data.

HTH

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Michael Grove 
To: CF-Talk 
Sent: Monday, November 24, 2003 8:44 AM
Subject: CF - post to database question

I am looking for a way to post information directly to a database from a csv, excel or text delimited file.

I am looking for one of two options.

Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file automatically and post it in a database.

Option two would be to simply give the user the ability to access a web form and upload the file to the server, which in turn would place the data in a database.

Can someone point me in the right direction?
Thanks

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: looking for a good dynamic menu

2003-11-24 Thread walker
I'm working on a CF 5 server.

At 11:48 AM 11/24/2003, you wrote:
U should try fireworks MX !!


Regards,

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: walker [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 11:43 AM
To: CF-Talk
Subject: looking for a good dynamic menu

Hey all,

I need to find a good dynamic menu - kind of like the one found on
http://www.jensonusa.com,http://www.jensonusa.com, where the rollover 
pops down a second list of
items to choose from.

Does anyone know of one that is cross browser compatible, and works well

with cold fusion?

Thanks for your help.

-w

_
walker fenton
[EMAIL PROTECTED]
303.722.5473

_


--
[
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: looking for a good dynamic menu

2003-11-24 Thread Johan Steenkamp
Commercial - http://www.opencube.com/ (light as it loads only the script required by the browser)
Other - you can find a number at www.dynamicdrive.com (hvmenu is a good one)

Johan
www.assetnow.com 
- Original Message - 
From: Hassan Arteaga Rodriguez 
To: CF-Talk 
Sent: Tuesday, November 25, 2003 7:48 AM
Subject: RE: looking for a good dynamic menu

U should try fireworks MX !!

Regards, 

__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-Original Message-
From: walker [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 11:43 AM
To: CF-Talk
Subject: looking for a good dynamic menu

Hey all,

I need to find a good dynamic menu - kind of like the one found on 
http://www.jensonusa.com, where the rollover pops down a second list of 
items to choose from.

Does anyone know of one that is cross browser compatible, and works well

with cold fusion?

Thanks for your help.

-w

_
walker fenton
[EMAIL PROTECTED]
303.722.5473 

 _


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: looking for a good dynamic menu

2003-11-24 Thread Matt Robertson
http://milonic.com

Works on everything.More features than you can shake a stick at.I
wrote a CF wrapper in the Exchange, and sell a fancier one that includes
a license for what is now below the current ver's cost.Neither work
with the brand-new version 5, but the older ver was lighter-weight and
did everything I could ask for, personally.As soon as I can get my cms
upgrade released I'll update both tags.Maybe over the U.S.
Thanksgiving holiday week.


 Matt Robertson [EMAIL PROTECTED] 
 MSB Designs, Inc.http://mysecretbase.com


-Original Message-
From: walker [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 9:43 AM
To: CF-Talk
Subject: looking for a good dynamic menu

Hey all,

I need to find a good dynamic menu - kind of like the one found on 
http://www.jensonusa.com, where the rollover pops down a second list of 
items to choose from.

Does anyone know of one that is cross browser compatible, and works well

with cold fusion?

Thanks for your help.

-w

_
walker fenton
[EMAIL PROTECTED]
303.722.5473 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Declared SQL variables in select statement error

2003-11-24 Thread Michael Traher
I think the same answer is implied in Hassan's answer as well..

It would seem that you have told the DBMS to create a local variable and
put the query results in the local variable then end, thus losing the
local variable.

If you want to refer to the result then Hassan's code looks good!

Michael Traher 

-Original Message-
From: Chris More [mailto:[EMAIL PROTECTED] 
Sent: 24 November 2003 15:50
To: CF-Talk
Subject: Declared SQL variables in select statement error

Why can I execute this statement fine in MS SQL Analyzer:

DECLARE @q1 varchar(7)

SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1

And If I try to do this in CF:

cfquery name=sales datasource=forecasting
DECLARE @q1 varchar(7)

SELECT @q1 = period_name
FROM adj_periods
WHERE period_id = 1
/cfquery

I get this error:

QUERY The QUERY attribute of the tag does not specify the name of an
available query

This is a simplified version of my problem, but it seems that CF will
execute the query without an error but the returned query structure
won't exist at all.

Has anyone else ran into this problem?

Thanks,
Chris
[EMAIL PROTECTED]

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Ordering a QofQ

2003-11-24 Thread John Burns
This probably has to do with the data type of the field that you're working
with.For instance, if price is a text field because you're storing $123.43
instead of a numeric field and just storing 123.43 it would sort
alphabetically instead of numerically.You could probably convert the field
value to a numeric value in your first query using CAST or INT and that
would return it as numeric.Then your sort should work.It's been a while
since I've done that, but I think it would work.

John Burns

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 12:38 PM
To: CF-Talk
Subject: Ordering a QofQ

I'm building a query dynamically, and then trying to sort it on a numeric
column, but it only wants to sort alphabetically.Anyone experience this,
or know what I need to do to sort numerically?

cfquery name=qResults dbtype=query
select * from qResults order by hasPhoto DESC, price DESC
/cfquery

-Brad


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Recursion and Breadcrumbs

2003-11-24 Thread Jake McKee
After searching high and low, I've found quite a few discussions about
using recursion to create breadcrumbs, and other nested categorical
info. It seems to be a pretty common question, and I would expect that
there is a common solution out there, but I can't seem to find one. 

I'm trying to display:

Home  Cat  Sub Cat  Sub Sub Cat  .. Etc.

My DB table looks like :

Cat IDCatNameParentCatID

---

1 CDs0

2 Good CDs1

3 Bad CDs1

4 U22

5 Nsync3

This would display:

Home  CDs  Good CDs  U2

Anyone have a straightforward code snippet for this?

Thanks!
Jake



--

My Blog -http://www.countersinkdg.com www.countersinkdg.com 




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




re: Breadcrumb in CF

2003-11-24 Thread Bushy
How can I do something similar in CF using the below ASP code?

%
Function BreadCrumbs()
	Dim lstrPathAry
	Dim llngMaxIndex
	Dim lstrPath
	Dim lstrHTML

	lstrPathAry = Split(Request.ServerVariables(PATH_INFO), /)
	
	llngMaxIndex = UBound(lstrPathAry) - 1
	
	lstrHTML = BYou are here:/B 

	lstrPath = /
	lstrHTML = lstrHTML  A href=""  lstrPath  Home/A 
	
	For llngIndex = 1 To llngMaxIndex
		lstrPath = lstrPath  Server.URLPathEncode(lstrPathAry(llngIndex))  /
		lstrHTML = lstrHTML  gt; A href=""  lstrPathServer.HTMLEncode(lstrPathAry(llngIndex))  /A
	Next
	
	BreadCrumbs = lstrHTML
	
End Function
%


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Bryan F. Hogan
Hi I'm confused on this one. Did you create a DTS to import from the
uploaded spreadsheet? If so where does the DSN-less connection come into
play?

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 12:14 PM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?

we wanted to do it so that users were able to upload an excel
spreadsheet, which could then be manipulated by other people over a
period of time.At the time of writing there was no way to do it in MX
that appeared to work. So we have a bank of datasources setup in CF
which is then monitored by other code and matched up with ODBC
datasources via CFRegistry

 
Much much easier (and secure) than installing MS Office on the server
(which has the added problem of being really locked down) and trying to
use COM


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:Recursion and Breadcrumbs

2003-11-24 Thread Trevor Holm-Laursen
Hey, I wrote a custom tag to do exactly that.Email me off list at 

[EMAIL PROTECTED]

and I'll get you a copy
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Bryan F. Hogan
I've been thinking about this today and so-far I can't figure out why
the need for DSN-less connections. Could a Macro in your Access database
not import data from an uploaded Excel Spreadsheet

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 12:14 PM
To: CF-Talk
Subject: RE: On the fly DSN creation, why?

In the example I posted, it was to work with an uploaded Excel
spreadsheet. In that case, you don't want a real DSN to it but just a
dynamic connection.

Besides, someone else asked about the HOW, not just WHY (sorry if I'm
encouraging the repurposement of your thread).

Sam


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Recursion and Breadcrumbs

2003-11-24 Thread Hagan, Ryan Mr (Contractor ACI)
This is what I generally use.Let me know if you need clarification.

cffunction name=list_categories returntype=string output=No
 cfargument name=myCatId type=numeric default=0 required=true

 cfset var currQuery = 
 cfset var returnString = 

 cfquery name=currQuery datasource=#request.dsn.name#
username=#request.dsn.user# password=#request.dsn.pass#
 SELECT catId, parentCatId, catName
 FROM item_categories
 WHERE parentId = #arguments.myCatId# 
 ORDER BY category
 /cfquery

 cfloop query=currQuery
cfset returnString = returnString  catName   gt; 
cfset returnString = returnString  list_categories( Val(currQuery.catId)
)
 /cfloop

 cfreturn returnString

 
/cffunction

-Original Message-
From: Jake McKee [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 1:51 PM
To: CF-Talk
Subject: Recursion and Breadcrumbs

After searching high and low, I've found quite a few discussions about
using recursion to create breadcrumbs, and other nested categorical
info. It seems to be a pretty common question, and I would expect that
there is a common solution out there, but I can't seem to find one. 

I'm trying to display:

Home  Cat  Sub Cat  Sub Sub Cat  .. Etc.

My DB table looks like :

Cat IDCatNameParentCatID

---

1 CDs0

2 Good CDs1

3 Bad CDs1

4 U22

5 Nsync3

This would display:

Home  CDs  Good CDs  U2

Anyone have a straightforward code snippet for this?

Thanks!
Jake

--

My Blog -http://www.countersinkdg.com www.countersinkdg.com 


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Bryan F. Hogan
 Sure, let's say you want to let a user upload an Access database and
import it an existing data source.

If the database you want to import data is in SQL you can use a DTS. If
it is in Access you can use a Macro.

I am currently stuck figuring out how to do the reverse - extract
data to a stand alone dynamically generated Access database.

Same as above.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:Recursion and Breadcrumbs

2003-11-24 Thread Trevor Holm-Laursen
Here's the code to the Custom tag I wrote to do this exact thing

cfsetting enablecfoutputonly=Yes

!--- 
Author:			Trevor Holm-Laursen
Attributes:		REQUIRED
CategoryID - ID of category to build crumb for

OPTIONAL

Nested Tags:
 ---

!--- Validate CategoryID ---
cfif IsDefined(attributes.CategoryID) AND attributes.CategoryID NEQ 
	cfset varCategoryID = attributes.CategoryID
cfelse
	cfoutputCategoryID is a required variable./cfoutput
	cfabort
/cfif
cfquery name=getParent datasource=#application.qryDSN#
	SELECT *
	FROM tblCategory
	WHERE CategoryID = #varCategoryID#
/cfquery

cfif getParent.ParentID EQ 0
	cfset Caller.Link = a href=''#getParent.CategoryName#/a
cfelse
	CF_FCSCategoryCrumb CategoryID=#getParent.ParentID# 
	cfset Caller.Link = Link   :   a href=''#getParent.CategoryName#/a
/cfif

cfsetting enablecfoutputonly=No
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: Macromedia Technotes Notification

2003-11-24 Thread David K
I'm looking for a way to keep up with the latest TechNotes and Bulletins
from Macromedia. In the Macromedia XML News Aggregator (
http://www.markme.com/mxna/index.cfm ) I've seen an entry entitled
ColdFusion TechNote Notification but can't locate the feed for it. Can
anyone provide the URL? Also, If there's an email signup for email
notifications, I would appreciate the URL or signup instructions for that as
well.

TIA

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF and ASP

2003-11-24 Thread d.a.collie
Doubt it the .cfm file will tell the webserver to use the Cold
Fusion app server... if it has an asp extension it would then run
through the asp.dll

I know this can be changed but I doubt that you would be able to get
both languages going at the same time...

-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: 24 November 2003 17:38
To: CF-Talk
Subject: RE: CF and ASP

Can I have some ASP code in my test.cfm file? Its a breadcrumb writting
in ASP.



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: On the fly DSN creation, why?

2003-11-24 Thread stas
I would greatly appreciate if you could post an example on how to do this.
I've asked several times without success. Thanks much!

- Original Message -
From: Bryan F. Hogan
To: CF-Talk
Sent: Monday, November 24, 2003 2:03 PM
Subject: RE: On the fly DSN creation, why?

 Sure, let's say you want to let a user upload an Access database and
import it an existing data source.

If the database you want to import data is in SQL you can use a DTS. If
it is in Access you can use a Macro.

I am currently stuck figuring out how to do the reverse - extract
data to a stand alone dynamically generated Access database.

Same as above.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF and ASP

2003-11-24 Thread Schuster, Steven
What if you used an IFRAME. That may work. Dunno though as I have never
tried it.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 2:39 PM
To: CF-Talk
Subject: RE: CF and ASP

 
Doubt it the .cfm file will tell the webserver to use the Cold
Fusion app server... if it has an asp extension it would then run
through the asp.dll

I know this can be changed but I doubt that you would be able to get
both languages going at the same time...

-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: 24 November 2003 17:38
To: CF-Talk
Subject: RE: CF and ASP

Can I have some ASP code in my test.cfm file? Its a breadcrumb writting
in ASP.


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF and ASP

2003-11-24 Thread d.a.collie
nice thinking

see no reason why it shouldn't work as it is two separate page calls..

I like it Steven :-)

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: 24 November 2003 19:41
To: CF-Talk
Subject: RE: CF and ASP

What if you used an IFRAME. That may work. Dunno though as I have never
tried it.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 2:39 PM
To: CF-Talk
Subject: RE: CF and ASP

 
Doubt it the .cfm file will tell the webserver to use the Cold
Fusion app server... if it has an asp extension it would then run
through the asp.dll

I know this can be changed but I doubt that you would be able to get
both languages going at the same time...

-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: 24 November 2003 17:38
To: CF-Talk
Subject: RE: CF and ASP

Can I have some ASP code in my test.cfm file? Its a breadcrumb writting
in ASP.


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




problems with cfhttp and USPS

2003-11-24 Thread walker
Hey,

First off, thanks for your help.

I am having an issue with cfhttp talking to the USPS intl shipping price 
server. 9 times out of 10 the results come back with an error.

I've heard that there are cfx http tags out there- anyone used one that 
works on Solaris?

Or has anyone seen this problem before and fixed it?

Here is the error-

http://www.bikesmart.com/vt/test_usps_raw.cfm

Server Product
ColdFusion Server
Version: 5, 0, 0, 0
Edition: Professional
Operating System : UNIX
OS Version: 5.9, SunOS
OS Build Number: Generic_112233-04

Thanks!

_
walker fenton
[EMAIL PROTECTED]
303.722.5473 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Clearing Trusted Cache in CF 5

2003-11-24 Thread Tom Jordahl
Trusted cache will prevent ColdFusion (5 or MX) from checking the disk for
the file timestamp.

This can have a medium to large-ish performance impact.Huge if your
templates are mounted across the network on a file server.

You can switch this setting on/off without restarting the server, so you can
update a template, flip the switch off, request that page to clear the
cache, and then flip the switch on again.All without restarting.This is
by design.

If you have a large number of pages that you are updating, a restart would
probably be better, or (as Jon Block mentioned) a regression script which
hits every page in your app (using cfhttp).

Macromedia recommends that all performance sensitive sites turn trusted
cache on.

--
Tom Jordahl
Macromedia Server Development

-Original Message-
From: Doug White [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 21, 2003 9:27 AM
To: CF-Talk
Subject: Re: Clearing Trusted Cache in CF 5

Only if your site has very rare changes.

With trusted cache off, a new change will have a minor delay the first time
it
is invoked while it compiles, and from then on, it will load just as well as
if
TC was turned on.

I was searching for the Link which discusses this extensively, but am
running
against a deadline, and don't have the time to look it up.

==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com http://www.clickdoug.com 
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP
==
If you are not satisfied with my service, my job isn't done!

- Original Message - 
From: Lofback, Chris [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, November 21, 2003 8:22 AM
Subject: RE: Clearing Trusted Cache in CF 5

| Really?I thought this was a common recommendation for performance
tweaking...
|
| Chris Lofback
| Web Administrator
| Ceridian Benefits Services
| 3201 34th Street S.
| St. Petersburg, FL 33711
| 727-395-8881
|
|
| -Original Message-
| From: Doug White [mailto:[EMAIL PROTECTED]
| Sent: Friday, November 21, 2003 9:14 AM
| To: CF-Talk
| Subject: Re: Clearing Trusted Cache in CF 5
|
|
| On a production server with frequent changes, it is best that you turn off
| trusted cache and leave it off.
|
| ==
| Stop spam on your domain, use our gateway!
| For hosting solutions http://www.clickdoug.com http://www.clickdoug.com 
| Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP
| ==
| If you are not satisfied with my service, my job isn't done!
|
| - Original Message - 
| From: Lofback, Chris [EMAIL PROTECTED]
| To: CF-Talk [EMAIL PROTECTED]
| Sent: Friday, November 21, 2003 7:55 AM
| Subject: Clearing Trusted Cache in CF 5
|
| | Does disabling and then reenabling the Trusted Cache option in CF 5
clear
the
| template cache?If not, how can I make CF refresh the entire cache?Does
it
| require a restart?
| |
| | Thanks,
| | Chris
| |
|
|
| 

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: DW extension keyboard shortcuts

2003-11-24 Thread Barney Boisvert
I beat my head against this one all weekend.In DWMX (not 04), is it
possible to assign a keyboard shortcut to a command extension?I couldn't
find anything about it either way in the helps.

Cheers,
barneyb

---
Barney Boisvert
[EMAIL PROTECTED]


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT: DW Stop refeshing site

2003-11-24 Thread Tony Weeg
how can I make it so that dw doesn't have to REFRESH MY SITES when I make
changes to files etc?

thanks.
tony

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Macromedia Technotes Notification

2003-11-24 Thread Michael Dinowitz
Fusion Authority keeps up with the tech notes. While it's not immediate like the
XML feed is, it does cover them and more. We've got an issue coming out in an
hour or so that brings the latest technotes out.

 I'm looking for a way to keep up with the latest TechNotes and Bulletins
 from Macromedia. In the Macromedia XML News Aggregator (
 http://www.markme.com/mxna/index.cfm ) I've seen an entry entitled
 ColdFusion TechNote Notification but can't locate the feed for it. Can
 anyone provide the URL? Also, If there's an email signup for email
 notifications, I would appreciate the URL or signup instructions for that as
 well.

 TIA

 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: DW Stop refeshing site

2003-11-24 Thread John Beynon
It's on the Local Info tab when you go into Manage Sites, there's a
checkbox, CACHE that will need to be unticked,

Jb.

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 24 November 2003 20:03
To: CF-Talk
Subject: OT: DW Stop refeshing site

how can I make it so that dw doesn't have to REFRESH MY SITES when I make
changes to files etc?

thanks.
tony


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: DW extension keyboard shortcuts

2003-11-24 Thread Massimo, Tiziana e Federica
You can assign keyboard shortcuts to menu entries. So, first create the menu
entry for your command, then assign a shortcut to it


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/



- Original Message -
From: Barney Boisvert
Newsgroups: cf-talk
Sent: Monday, November 24, 2003 9:01 PM
Subject: OT: DW extension keyboard shortcuts

I beat my head against this one all weekend.In DWMX (not 04), is it
possible to assign a keyboard shortcut to a command extension?I couldn't
find anything about it either way in the helps.

Cheers,
barneyb


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Samuel R. Neff
Bryan,

DTS implies MSSQL and if you're using a DTS to import from an uploaded Excel
or Access database, then somehow you must be passing the path to the Excel
or Access file to the DTS package.This is really the same as dsn-less
connection, just through DTS and not through CF.

Also, you can't run an Access macro on the server without automation which
is a big no-no.

Best regards,

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: DW extension keyboard shortcuts

2003-11-24 Thread Barney Boisvert
That's what I assumed would happen.It happily displays on the Commands
menu, but no dice in the keyboard shortcut screen.I also tried manually
adding it to the menu.xml file, and that didn't work either.

 
barneyb

_

From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 12:33 PM
To: CF-Talk
Subject: Re: DW extension keyboard shortcuts

You can assign keyboard shortcuts to menu entries. So, first create the menu
entry for your command, then assign a shortcut to it


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/


- Original Message -
From: Barney Boisvert
Newsgroups: cf-talk
Sent: Monday, November 24, 2003 9:01 PM
Subject: OT: DW extension keyboard shortcuts

I beat my head against this one all weekend.In DWMX (not 04), is it
possible to assign a keyboard shortcut to a command extension?I couldn't
find anything about it either way in the helps.

Cheers,
barneyb

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: On the fly DSN creation, why?

2003-11-24 Thread Bryan F. Hogan
 Also, you can't run an Access macro on the server without automation
which is a big no-no.

I don't want to get into the politics of having Access installed on the
machine, that's not my concern, it's the users concern. All I want to do
get the reasons why people go through so much time and effort to do a
DSN less connection in _CFML_.

 DTS implies MSSQL and if you're using a DTS to import from an uploaded
Excel or Access database, then somehow you must be passing the path to
the Excel or Access file to the DTS package.

Yep, I was asked for an example through code, but I don't see a need to
do it through code. It can be done with the database engines. You'll
probably counter and say that in order to run the DTS your doing it
through code anyways. My answer would be yes but your calling a stored
procedure. Or firing a Macro.

 This is really the same as dsn-less connection, just through DTS and
not through CF

Yep


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Error with Web Connector after installing CFMX 6.1

2003-11-24 Thread Angel Stewart
I got some errors with CFMX, where it had totally stopped processing CFM
pages. All I would get when I visited a CFM page was a blank screen.

 
I've just uninstalled, rebooted..reinstalled and rebooted CFMX.

 
After the reinstall I got a message saying that the web connector
installation had failed, and I would have to try manually.

 
I just ran the Web connector wizard, and I get this error message:

 
The connection to the remote JNDI server on host localhost port 2901 has
failed (as have all backup hosts listed if any) Please verify that the
server is running and the NamingService is available.

 
Any idea what the problem could be and how to fix this?

 
This is on my development PC...

 
-Gel


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Auto-Populate a Word Document

2003-11-24 Thread peter . tilbrook
Try this EasyCFM tutorial:

http://tutorial13.easycfm.com/

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927



Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: New Lists and other items

2003-11-24 Thread peter . tilbrook
Do the RSS feeds support autodiscovery? I use FeedDemon 1.0 RC4 and it
didn't seem to like it.

Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609

Tel: (02) 62115927



Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




ListFind() weirdness

2003-11-24 Thread Seth Johnson
OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5.

 
Here's an example.I create a COMMA DELIMITED list of values, each value
actually consists of 3 groups of numbers separated by an underscore.
ListFind() is not returning the proper result when this list contains a
single value.

 
cfset lstTemp = 4483_035738_8647
cfoutput
 #ListFind(lstTemp, 4483_035738_8647)#br
 #ListFind(lstTemp, 4483_035738_8647, 1)#br
 #ListFind(lstTemp, 4483_035738_8647, 2)#br
/cfoutput

 
All of the ListFind()s are returning a value of 1, even though they should
be returning 0.

 
In this case, the list and the value I'm looking for are one and the same,
so a straight ListFInd() should return an index of 1.However, if I call
ListFind() with a starting position of 1, shouldn't it return 0?It works
fine if the list contains more than one value, but not if it has just one
value.

 
Any help would be VERY much appreciated.

 
Seth Petry-Johnson

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Error with Web Connector after installing CFMX 6.1

2003-11-24 Thread Mahmut Basaran
I had a similar problem a while ago, although it says localhost it's not really using localhost (it's using the static ip of your box).

so, if you have any firewalls, ipsec rules etc.. disable them and run the connector executable again. You can also check the log files to dig more info.
- Original Message - 
From: Angel Stewart 
To: CF-Talk 
Sent: Monday, November 24, 2003 11:00 PM
Subject: Error with Web Connector after installing CFMX 6.1

I got some errors with CFMX, where it had totally stopped processing CFM
pages. All I would get when I visited a CFM page was a blank screen.

I've just uninstalled, rebooted..reinstalled and rebooted CFMX.

After the reinstall I got a message saying that the web connector
installation had failed, and I would have to try manually.

I just ran the Web connector wizard, and I get this error message:

The connection to the remote JNDI server on host localhost port 2901 has
failed (as have all backup hosts listed if any) Please verify that the
server is running and the NamingService is available.

Any idea what the problem could be and how to fix this?

This is on my development PC...

-Gel


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Jar files not being read

2003-11-24 Thread Barney Boisvert
I just added a JAR to my app's WEB-INF/lib directory and it's behaving very
strangely.I can happily instantiate and use the classes from my CF code.
I can happily instantiate and use the classes from a custom Java class that
is compiled and run with the JAR on the classpath.However, running that
custom Java class from CF causes NoClassDefFoundErrors to be thrown,
referencing the classes in the JAR.

There are several other JARs in the same directory, and I've had no problems
at all using their classes directly from CF and/or through custom Java
classes from CF.I checked permissions and ownership, and all were as they
should be.I also tried unpackaging the JAR and rebuilding it, and that
didn't help either.

Anyone had anything similar happen to them?Just about gone nuts with this.
I'm running 6.1 Standard on RH Linux with Apache 2.

TIA,
barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax: 360.647.5351

www.audiencecentral.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: New Lists and other items

2003-11-24 Thread Michael Dinowitz
It seems that autodiscovery requires a link format other than what I have. I'll
look into adding it in the next revision. Till then, you can add this link
directly:
http://www.houseoffusion.com/cf_lists/RSS.cfm/forumid=4
The forumid reflects the specific forum so 4 is CF-Talk, 5 is CF-Community, etc.
All lists automatically have an RSS feed.

 Do the RSS feeds support autodiscovery? I use FeedDemon 1.0 RC4 and it
 didn't seem to like it.

 Peter Tilbrook
 Transitional Services - Enterprise eSolutions
 Centrelink (http://www.centrelink.gov.au)
 2 Faulding Street
 Symonston ACT 2609

 Tel: (02) 62115927





 Important:This e-mail is intended for the use of the addressee and may
contain information that is confidential, commercially valuable or subject to
legal or parliamentary privilege.If you are not the intended recipient you are
notified that any review, re-transmission, disclosure, use or dissemination of
this communication is strictly prohibited by several Commonwealth Acts of
Parliament.If you have received this communication in error please notify the
sender immediately and delete all copies of this transmission together with any
attachments.

 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind() weirdness

2003-11-24 Thread Schuster, Steven
Wouldn't a list, by nature of it being a list, need more than 1 value to be
called a list?

 
If you know the format could you do some ugly code like

 
If (Len(myList) LTE 16
 !--- One Value List ---
else
!--- List me baby ---

 
S

 
-Original Message-
From: Seth Johnson [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 4:14 PM
To: CF-Talk
Subject: ListFind() weirdness

 
OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5.

Here's an example.I create a COMMA DELIMITED list of values, each value
actually consists of 3 groups of numbers separated by an underscore.
ListFind() is not returning the proper result when this list contains a
single value.

cfset lstTemp = 4483_035738_8647
cfoutput
#ListFind(lstTemp, 4483_035738_8647)#br
#ListFind(lstTemp, 4483_035738_8647, 1)#br
#ListFind(lstTemp, 4483_035738_8647, 2)#br
/cfoutput

All of the ListFind()s are returning a value of 1, even though they should
be returning 0.

In this case, the list and the value I'm looking for are one and the same,
so a straight ListFInd() should return an index of 1.However, if I call
ListFind() with a starting position of 1, shouldn't it return 0?It works
fine if the list contains more than one value, but not if it has just one
value.

Any help would be VERY much appreciated.

Seth Petry-Johnson

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE:Unable to Update the CFMX ODBC Server ( Was Error with Web Connector after installing CFMX 6.1)

2003-11-24 Thread Angel Stewart
I fixed this by using 127.0.0.1 .

 
I've now run into another problem:

 
Unable to update the ColdFusion MX ODBC Server.
Timeout period expired without completion of
F:\CFusionMX\db\slserver52\admin\swcla.exe

I get this everytime I try to add a DNS through the CFMX Administrator. 

 
Any word on this one?

 
-Gel

-Original Message-
From: Mahmut Basaran [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 5:17 PM
To: CF-Talk
Subject: Re: Error with Web Connector after installing CFMX 6.1

I had a similar problem a while ago, although it says localhost it's
not really using localhost (it's using the static ip of your box).

so, if you have any firewalls, ipsec rules etc.. disable them and run
the connector executable again. You can also check the log files to dig
more info.



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ListFind() weirdness

2003-11-24 Thread Marlon Moyer
According to my help, the syntax for Listfind is

ListFind(List,string,delemiters)

I don't think that you can specify start position.

Marlon

Seth Johnson wrote:

 OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5.


 Here's an example.I create a COMMA DELIMITED list of values, each value
 actually consists of 3 groups of numbers separated by an underscore.
 ListFind() is not returning the proper result when this list contains a
 single value.


 cfset lstTemp = 4483_035738_8647
 cfoutput
 #ListFind(lstTemp, 4483_035738_8647)#br
 #ListFind(lstTemp, 4483_035738_8647, 1)#br
 #ListFind(lstTemp, 4483_035738_8647, 2)#br
 /cfoutput


 All of the ListFind()s are returning a value of 1, even though they 
 should
 be returning 0.


 In this case, the list and the value I'm looking for are one and the same,
 so a straight ListFInd() should return an index of 1.However, if I call
 ListFind() with a starting position of 1, shouldn't it return 0?It works
 fine if the list contains more than one value, but not if it has just one
 value.


 Any help would be VERY much appreciated.


 Seth Petry-Johnson
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind() weirdness

2003-11-24 Thread Bryan F. Hogan
There is nothing wrong with this.

ListFind(list, value [, delimiters ])

The first instance. No delimiter is specified so comma would be default.
Since your value is equal to the search string returns index 1.

The second instance your delimiter is 1, since your value matches your
search string and no 1 is in your value it returns 1.

The third instance is the same as above.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Jar files not being read

2003-11-24 Thread Bryan F. Hogan
Don't you have to restart the service?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




preventing back button of browser

2003-11-24 Thread Ketan Patel
hi all,

does anybodyknow a good way of preventingback button of browser.

thanks,
ketan

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind() weirdness

2003-11-24 Thread Schuster, Steven
I suppose you could also do a find for the delimeter and if it is not found
assume it is not a list as well.

 
S

-Original Message-
From: Schuster, Steven [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 4:21 PM
To: CF-Talk
Subject: RE: ListFind() weirdness

 
Wouldn't a list, by nature of it being a list, need more than 1 value to be
called a list?

If you know the format could you do some ugly code like

If (Len(myList) LTE 16
 !--- One Value List ---
else
!--- List me baby ---

S

-Original Message-
From: Seth Johnson [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 4:14 PM
To: CF-Talk
Subject: ListFind() weirdness

OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5.

Here's an example.I create a COMMA DELIMITED list of values, each value
actually consists of 3 groups of numbers separated by an underscore.
ListFind() is not returning the proper result when this list contains a
single value.

cfset lstTemp = 4483_035738_8647
cfoutput
#ListFind(lstTemp, 4483_035738_8647)#br
#ListFind(lstTemp, 4483_035738_8647, 1)#br
#ListFind(lstTemp, 4483_035738_8647, 2)#br
/cfoutput

All of the ListFind()s are returning a value of 1, even though they should
be returning 0.

In this case, the list and the value I'm looking for are one and the same,
so a straight ListFInd() should return an index of 1.However, if I call
ListFind() with a starting position of 1, shouldn't it return 0?It works
fine if the list contains more than one value, but not if it has just one
value.

Any help would be VERY much appreciated.

Seth Petry-Johnson

_

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind() weirdness

2003-11-24 Thread Raymond Camden
ListFind doesn't accept a 'index' argument. The 3rd argument is the
delimiter, which defualts to a comma. Now, the second example you used,
where you passed 1 as the 3rd arg, should return 0 since 1 doesn't exist in
the list.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Jar files not being read

2003-11-24 Thread Barney Boisvert
Yeah, done that about a million times.Actually got lazy enough to write
myself an alias so I didn't have to type the whole command out every time.
; )

_

From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 1:25 PM
To: CF-Talk
Subject: RE: Jar files not being read

Don't you have to restart the service?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind() weirdness

2003-11-24 Thread Bryan F. Hogan
1 is the delimiter. It should return 1 as it correctly does.

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 4:27 PM
To: CF-Talk
Subject: RE: ListFind() weirdness

ListFind doesn't accept a 'index' argument. The 3rd argument is the
delimiter, which defualts to a comma. Now, the second example you used,
where you passed 1 as the 3rd arg, should return 0 since 1 doesn't exist
in the list.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Auto-Populate a Word Document

2003-11-24 Thread Samuel R. Neff
Even MS tells you to never do this.

Microsoft does not currently recommend, and does not support, Automation of
Microsoft Office applications from any unattended, non-interactive client
application or component (including ASP, DCOM, and NT Services), because
Office may exhibit unstable behavior and/or deadlock when run in this
environment.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] 
 Sent: Monday, November 24, 2003 4:05 PM
 To: CF-Talk
 Subject: Re: Auto-Populate a Word Document
 
 Try this EasyCFM tutorial:
 
 http://tutorial13.easycfm.com/
 
 Peter Tilbrook

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ListFind() weirdness

2003-11-24 Thread Chris Stoner
ListFind(list, value [, delimiters ])

The third argument of ListFind is not starting position but rather it is the lists delimiter.So your 1 and 2 delimited list does have exaclty 1 list item (as there are no 1's or 2's in your number).
- Original Message - 
From: Seth Johnson 
To: CF-Talk 
Sent: Monday, November 24, 2003 4:14 PM
Subject: ListFind() weirdness

OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5.

Here's an example.I create a COMMA DELIMITED list of values, each value
actually consists of 3 groups of numbers separated by an underscore.
ListFind() is not returning the proper result when this list contains a
single value.

cfset lstTemp = 4483_035738_8647
cfoutput
#ListFind(lstTemp, 4483_035738_8647)#br
#ListFind(lstTemp, 4483_035738_8647, 1)#br
#ListFind(lstTemp, 4483_035738_8647, 2)#br
/cfoutput

All of the ListFind()s are returning a value of 1, even though they should
be returning 0.

In this case, the list and the value I'm looking for are one and the same,
so a straight ListFInd() should return an index of 1.However, if I call
ListFind() with a starting position of 1, shouldn't it return 0?It works
fine if the list contains more than one value, but not if it has just one
value.

Any help would be VERY much appreciated.

Seth Petry-Johnson


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: preventing back button of browser

2003-11-24 Thread Marlon Moyer
Ketan,

There doesn't seem to be a foolproof way of preventing the back button.
Your best bet, IMHO, is to handle it with server side logic.

Marlon

Ketan Patel wrote:

 hi all,

 does anybodyknow a good way of preventingback button of browser.

 thanks,
 ketan
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: preventing back button of browser

2003-11-24 Thread cf-talk
Technically there really isn't anyway to prevent a back button from
being clicked... BUT... you can use _javascript_'s location.replace()
function to overwrite the current page location in your browser.
Essentially what you'll end up with is a page that has no history so the
back button won't be available.

 
-Novak

-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 1:31 PM
To: CF-Talk
Subject: preventing back button of browser

hi all,

does anybodyknow a good way of preventingback button of browser.

thanks,
ketan

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Auto-Populate a Word Document

2003-11-24 Thread Bryan F. Hogan
Sam most of us know this. I in fact detest using office for anything.
However clients want certain things and when they have seen it done on
other sites, and management insists on giving them this ability it is
our obligations as paid employees to do what is asked.

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 4:39 PM
To: CF-Talk
Subject: RE: Auto-Populate a Word Document

Even MS tells you to never do this.

Microsoft does not currently recommend, and does not support,
Automation of Microsoft Office applications from any unattended,
non-interactive client application or component (including ASP, DCOM,
and NT Services), because Office may exhibit unstable behavior and/or
deadlock when run in this environment.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757

Sam


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: preventing back button of browser

2003-11-24 Thread Mahmut Basaran
I wrote that script a while (2 years something) ago with my friend Joseph Thompson (also from the list).

http://cfhub.com/contributions/backbutton/

you can probably improve the code (to make it less), anyway, it should be fine as it is. completely server side logic, there is also a live demo you can check.

- Original Message - 
From: Ketan Patel 
To: CF-Talk 
Sent: Monday, November 24, 2003 11:31 PM
Subject: preventing back button of browser

hi all,

does anybodyknow a good way of preventingback button of browser.

thanks,
ketan


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: ListFind() weirdness

2003-11-24 Thread Marlon Moyer
I would think it should pass back 1 since it will treat the string as a 
1 element string regardless of what delimiter you specify if it can't 
find that delimiter.

Raymond Camden wrote:

 ListFind doesn't accept a 'index' argument. The 3rd argument is the
 delimiter, which defualts to a comma. Now, the second example you used,
 where you passed 1 as the 3rd arg, should return 0 since 1 doesn't 
 exist in
 the list.

 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: ListFind() weirdness

2003-11-24 Thread Raymond Camden
Yea yea, I was wrong about that part. Sorry folks. I blame it on the snow in
Salt Lake... :)


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:ListFind() weirdness

2003-11-24 Thread Seth Petry-Johnson
According to my help, the syntax for Listfind is

ListFind(List,string,delemiters)

(banging head on keyboard, wall, and anything else hard)

I am such an idiot.You're completely right.What a rookie mistake to make, and I've been at this game WAY to long to be making rookie mistakes.Doh!

Thanks for the help,
Seth
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: DW extension keyboard shortcuts

2003-11-24 Thread Massimo, Tiziana e Federica
 That's what I assumed would happen.It happily displays on the Commands
 menu, but no dice in the keyboard shortcut screen.

That's because the entry under the Commands menu are dinamycally generated
by DW. You need to hardcode the entry inside menus.xml in order to have it
show inside the shortcut editor's GUI

 I also tried manually
 adding it to the menu.xml file, and that didn't work either.

Are you sure you are editing the right file?
Please check its path under a multiuser operating system:

http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: DW extension keyboard shortcuts

2003-11-24 Thread Barney Boisvert
That would explain it.much thanks.

 
cheers,
barneyb

_

From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 2:18 PM
To: CF-Talk
Subject: Re: DW extension keyboard shortcuts

 That's what I assumed would happen.It happily displays on the Commands
 menu, but no dice in the keyboard shortcut screen.

That's because the entry under the Commands menu are dinamycally generated
by DW. You need to hardcode the entry inside menus.xml in order to have it
show inside the shortcut editor's GUI

 I also tried manually
 adding it to the menu.xml file, and that didn't work either.

Are you sure you are editing the right file?
Please check its path under a multiuser operating system:

http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/



_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT: good place to find contractors?

2003-11-24 Thread chris petersen
Anyone know a good place to look for CF contractors? Also, if anyone on
list is seeking additional contract opportunities, please feel free to
email me off list.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Jar files not being read

2003-11-24 Thread Barney Boisvert
Ok, get this, if I unzip the JAR to the WEB-INF/classes directory does NOT
work.Unzip the JAR into a random directory, add that directory to the CF
class path, and it'll work.Bizarre.

 
Rather annoyed to have to litter my filesystem with random class files, but
at least it works.

 
cheers,
barneyb

_

From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 1:39 PM
To: CF-Talk
Subject: RE: Jar files not being read

Yeah, done that about a million times.Actually got lazy enough to write
myself an alias so I didn't have to type the whole command out every time.
; )

_

From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 24, 2003 1:25 PM
To: CF-Talk
Subject: RE: Jar files not being read

Don't you have to restart the service?

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CVS

2003-11-24 Thread Daryl Walsh
when setting up cvs, do people generally
have one cvs repository per 'version',
i.e., development server = 1 cvs version.
staging server = another and the live web site
= a third? 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: good place to find contractors?

2003-11-24 Thread Bryan Stevenson
Christry the CF-Jobs list if you haven't already ;-)

.of course I will throw my company's hat into the ring.Full-time CF since 1998 (version 3.1) and we are in Canada...so the exchange rate will save some development cost.

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: chris petersen 
To: CF-Talk 
Sent: Monday, November 24, 2003 2:34 PM
Subject: SOT: good place to find contractors?

Anyone know a good place to look for CF contractors? Also, if anyone on
list is seeking additional contract opportunities, please feel free to
email me off list.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Auto-Populate a Word Document

2003-11-24 Thread Samuel R. Neff
But there are lots of other ways to do the same thing.I just gave a preso
at MAX going over 7 different ways to do this.Breezo with examples will be
posted shortly.

Best regards,

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] 
 Sent: Monday, November 24, 2003 4:46 PM
 To: CF-Talk
 Subject: RE: Auto-Populate a Word Document
 
 Sam most of us know this. I in fact detest using office for anything.
 However clients want certain things and when they have seen 
 it done on other sites, and management insists on giving them 
 this ability it is our obligations as paid employees to do 
 what is asked.
 
 -Original Message-
 From: Samuel R. Neff [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 24, 2003 4:39 PM
 To: CF-Talk
 Subject: RE: Auto-Populate a Word Document
 
 Even MS tells you to never do this.
 
 Microsoft does not currently recommend, and does not 
 support, Automation of Microsoft Office applications from any 
 unattended, non-interactive client application or component 
 (including ASP, DCOM, and NT Services), because Office may 
 exhibit unstable behavior and/or deadlock when run in this 
 environment.
 
 http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757
 
 Sam

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: good place to find contractors?

2003-11-24 Thread Jim T
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 3:52 PM
To: CF-Talk
Subject: Re: good place to find contractors?

Christry the CF-Jobs list if you haven't already ;-)

.of course I will throw my company's hat into the ring.Full-time CF
since 1998 (version 3.1) and we are in Canada...so the exchange rate will
save some development cost.

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
 - Original Message -
 From: chris petersen
 To: CF-Talk
 Sent: Monday, November 24, 2003 2:34 PM
 Subject: SOT: good place to find contractors?

 Anyone know a good place to look for CF contractors? Also, if anyone on
 list is seeking additional contract opportunities, please feel free to
 email me off list.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >